ArcEmu: Mythical Wow V1.1 Beta - ArcEmu

Jump to content

Toggle shoutbox Lastest Announcements

dfighter  : (07 December 2014 - 12:06 PM) Arcemu is in hibernation mode, please read http://arcemu.org/fo...showtopic=26903
dfighter  : (01 January 2013 - 05:56 PM) Arcemu wishes you all a happy new year!
Hasbro  : (12 September 2012 - 10:01 AM) Please excuse our outage from the web! Our web host had a major malfunction!
dfighter  : (01 September 2012 - 04:05 PM) Since the spam bots just don't want to stop, I've enabled admin verification when registering.
dfighter  : (23 January 2012 - 09:56 PM) Please note that from now on you will need to confirm your email on the wiki in order to edit it!
Hasbro  : (31 December 2011 - 12:50 PM) Happy New Years all!
Navid  : (26 December 2011 - 04:09 AM) Merry Christmas !!!!!! Happy holidays all :)
WAmadeus  : (24 December 2011 - 03:54 PM) Merry Christmas to all!
dfighter  : (24 December 2011 - 11:05 AM) The Arcemu team wishes y'all a Merry Christmukkah!
Hasbro  : (05 October 2011 - 12:53 PM) Looking for web designers for upcoming web related project. If you're interested in designing user interfaces contact me
dfighter  : (02 September 2011 - 03:47 PM) So who here wants vehicles in Arcemu? :P http://arcemu.org/fo...showtopic=25440
Hasbro  : (14 August 2011 - 03:25 PM) Join us on irc, grab an irc client and connect to irc.freenode.net join channel #arcemu /server irc.freenode.net:6667 /join #arcemu
jackpoz  : (03 August 2011 - 05:33 AM) to all Lua Engine (old one) users: please check http://arcemu.org/fo...showtopic=25274
Hasbro  : (20 May 2011 - 05:27 PM) Looking for people experienced with CMake configuration and setup! Contact me asap
Hasbro  : (15 May 2011 - 05:03 PM) ArcEmu is recruiting C++ programmers, contact Hasbro if interested.
paroxysm  : (03 May 2011 - 06:26 PM) Updated luabridge gossip example to describe the whole gossip creation process rather than just how to create menu. Gossip tutorial
paroxysm  : (23 April 2011 - 11:35 AM) Lua writers can refer to the Luabridge Tutorials section in the Wiki to learn how to write gossip code correctly.
Hasbro  : (20 April 2011 - 05:22 PM) Thank you for your continuous contribution of bug reports, we are working on them.
Hasbro  : (17 April 2011 - 03:20 AM) Please consider donating to support our bills. Donations can be sent using PayPal to donations@arcemu.org - Thank you for your support.
paroxysm  : (10 April 2011 - 12:43 AM) Refer to the Luabridge Tutorials section in the Wiki to learn the new syntax of luabridge.
Resize Shouts Area

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Mythical Wow V1.1 Beta

#1 User is offline   archcry 

  • Newbie
  • Group: Members
  • Posts: 5
  • Joined: 25-April 11
  • Gender:Male
  • Location:The netherlands
  • Server OS:Windows

Posted 27 April 2011 - 08:40 AM

Introduction:

I downloaded a website called mythical wow from AC webs soem days ago.
It was only running on trinity core and some contents were (and some are still) not working.

Anyways, I did some work on making it compatible with arcemu.
It's now fully compatible with arcemu.

List of changes:
- Seperated website and account database (your website will still run when your computer is offline)
- Compatible with arcemu
- Added add realm script (for realm status and such)
- When computer shuts down all account will be forced to log out.


The first fix is somehow not working atm, feel welcome to fix it :)
The seperate databases are working (one on my computer and one on my domain) but the site does not show up when my computer is offline.

Install:

Sql codes for shoutbox, realm and news:
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `news`
-- ----------------------------
DROP TABLE IF EXISTS `news`;
CREATE TABLE `news` (
  `id` int(32) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) DEFAULT NULL,
  `author` varchar(32) DEFAULT NULL,
  `date` varchar(32) DEFAULT NULL,
  `post` longtext,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of news
-- ----------------------------

-- ----------------------------
-- Table structure for `realms`
-- ----------------------------
DROP TABLE IF EXISTS `realms`;
CREATE TABLE `realms` (
  `id` int(32) NOT NULL AUTO_INCREMENT,
  `host` varchar(32) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `port` int(32) DEFAULT NULL,
  `db` varchar(32) DEFAULT NULL,
  `type` varchar(56) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of realms
-- ----------------------------

-- ----------------------------
-- Table structure for `shouts`
-- ----------------------------
DROP TABLE IF EXISTS `shouts`;
CREATE TABLE `shouts` (
  `id` int(32) NOT NULL AUTO_INCREMENT,
  `author` varchar(32) DEFAULT NULL,
  `shout` varchar(64) DEFAULT NULL,
  `date` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of shouts
-- ----------------------------


Edit this in order to get it working:
<?php error_reporting(0);
mb_http_output("UTF-8");
ob_start("mb_output_handler");
ini_set('smtp_port', '25');
/*********************************\
 Wsc Cms V1 Main Config
\*********************************/
if (!isset($_SESSION)) 
{
  session_start();
}
//Asign Page Titles
$title="Unholy Confessions";
//End Title Asign

//Server Realmlist
$realmlist="Set Realmlist mythical.dyndns-ip.com";
//End Realmlist

//Database Connect
$db_host="<host>";//Logon Host
$db_user="<db_user>";//Logon User
$db_pass="<db password>";//Logon Password
$db_account="<account db>";//Logon Db
$db_char="<char db>";//Character Db
$db_site="<u can delete this line>";//Site Database
$db_world="<world db>d";//World Db
$web_host="<website host>";//Web host
$web_user="<website user>";//web user
$web_pass="<website password>";//web password
$web_database="<website_database>";//database name
$con = mysql_connect("$db_host","$db_user","$db_pass");
//End Database Connect

//Declare Variable Session
$wsc_user=""; $wsc_gm=""; $wsc_admin="";
if(isset($_SESSION['wsc_user'])){$wsc_user=$_SESSION['wsc_user'];}
if(isset($_SESSION['wsc_gm'])){$wsc_gm=$_SESSION['wsc_gm'];}
if(isset($_SESSION['wsc_admin'])){$wsc_admin=$_SESSION['wsc_admin'];}
$login=array("$wsc_user", "$wsc_gm", "$wsc_admin");
//End Session
?>


Features:

The site was not fully coded, but has some tools which should work:
Register... Bridged with Phpbb3 register function... (Not tested)
Forgot Password (Not Tested)
Multiple Realm status with bar graph
Shoutbox
Admin panel
Post, edit, delete news
Edit account,
Truncate Shoutbox(Wipe table clean)
Account panel
Account details when logged in
Character unstuck/revive
Realm registration

Screenshots:
Posted Image
Posted Image
Posted Image

Credits:
Credits:
Stipt for the design.
Me and azer for the coding.
Jesper for slider js.

Download:
click here


~ Archcry
1

#2 User is offline   setkeh 

  • Newbie
  • Group: Members
  • Posts: 3
  • Joined: 16-June 11
  • IRC:setkeh
  • Gender:Male
  • Location:Aussie land
  • Server OS:Linux

Posted 16 June 2011 - 06:14 AM

Nice work mate It looks Great and is working quite well i just have 1 small issue im having a hard time sorting out.

when i try to add a real from the admin page i get the following error

Realm error: Table 'arc_world.realms' doesn't exist


im usig arc_world database as the database for the real AFAIK thats where the realm data is stored

any ideas would be hugely appreciated

cheers
setkeh
0

#3 User is offline   iEzri 

  • < Ace of spades >
  • Group: Contributor
  • Posts: 1,692
  • Joined: 22-December 08
  • Gender:Female
  • Interests:I'm likely to cause mischief
  • Server OS:Linux

Posted 16 June 2011 - 07:29 AM

View Postsetkeh, on 16 June 2011 - 06:14 AM, said:


Realm error: Table 'arc_world.realms' doesn't exist


im usig 'arc_world' database



:D
Posted Image I do not join. I lead.
0

#4 User is offline   setkeh 

  • Newbie
  • Group: Members
  • Posts: 3
  • Joined: 16-June 11
  • IRC:setkeh
  • Gender:Male
  • Location:Aussie land
  • Server OS:Linux

Posted 16 June 2011 - 07:41 AM

View PostiEzri, on 16 June 2011 - 07:29 AM, said:

:D


if there is somthing to get there i dont get it :P i like big writing in crayon :D :P
0

#5 User is offline   iEzri 

  • < Ace of spades >
  • Group: Contributor
  • Posts: 1,692
  • Joined: 22-December 08
  • Gender:Female
  • Interests:I'm likely to cause mischief
  • Server OS:Linux

Posted 16 June 2011 - 09:59 AM

View Postsetkeh, on 16 June 2011 - 07:41 AM, said:

if there is somthing to get there i dont get it :D i like big writing in crayon :P :P


Posted Image

?

maybe you should look here: http://dev.mysql.com/doc/
Posted Image I do not join. I lead.
0

#6 User is offline   setkeh 

  • Newbie
  • Group: Members
  • Posts: 3
  • Joined: 16-June 11
  • IRC:setkeh
  • Gender:Male
  • Location:Aussie land
  • Server OS:Linux

Posted 16 June 2011 - 10:32 AM

Issue Resolved its like dfighter pointed out i dident read the post correctly and dident add

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `news`
-- ----------------------------
DROP TABLE IF EXISTS `news`;
CREATE TABLE `news` (
  `id` int(32) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) DEFAULT NULL,
  `author` varchar(32) DEFAULT NULL,
  `date` varchar(32) DEFAULT NULL,
  `post` longtext,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of news
-- ----------------------------

-- ----------------------------
-- Table structure for `realms`
-- ----------------------------
DROP TABLE IF EXISTS `realms`;
CREATE TABLE `realms` (
  `id` int(32) NOT NULL AUTO_INCREMENT,
  `host` varchar(32) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `port` int(32) DEFAULT NULL,
  `db` varchar(32) DEFAULT NULL,
  `type` varchar(56) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of realms
-- ----------------------------

-- ----------------------------
-- Table structure for `shouts`
-- ----------------------------
DROP TABLE IF EXISTS `shouts`;
CREATE TABLE `shouts` (
  `id` int(32) NOT NULL AUTO_INCREMENT,
  `author` varchar(32) DEFAULT NULL,
  `shout` varchar(64) DEFAULT NULL,
  `date` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of shouts
-- ----------------------------


to the database :D

cheers
setkeh

P.S yes playdough is good enough if crayons arent handy :P
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users