------------ By wish & Vinny ------------ -- phpMyAdmin SQL Dump -- version 2.7.0 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Aug 21, 2007 at 04:45 PM -- Server version: 5.0.41 -- PHP Version: 5.1.1 -- -- Database: `portal` -- -- -------------------------------------------------------- -- -- Table structure for table `fusion_admin` -- CREATE TABLE `fusion_admin` ( `admin_id` tinyint(2) unsigned NOT NULL auto_increment, `admin_rights` char(2) NOT NULL default '', `admin_image` varchar(50) NOT NULL default '', `admin_title` varchar(50) NOT NULL default '', `admin_link` varchar(100) NOT NULL default 'reserved', `admin_page` tinyint(1) unsigned NOT NULL default '1', PRIMARY KEY (`admin_id`) ) ENGINE=MyISAM AUTO_INCREMENT=37 DEFAULT CHARSET=latin1 AUTO_INCREMENT=37 ; -- -- Dumping data for table `fusion_admin` -- INSERT INTO `fusion_admin` VALUES (1, 'AD', 'admins.gif', 'Administrators', 'administrators.php', 2); INSERT INTO `fusion_admin` VALUES (2, 'AC', 'article_cats.gif', 'Article Categories', 'article_cats.php', 1); INSERT INTO `fusion_admin` VALUES (3, 'A', 'articles.gif', 'Articles', 'articles.php', 1); INSERT INTO `fusion_admin` VALUES (4, 'B', 'blacklist.gif', 'Blacklist', 'blacklist.php', 2); INSERT INTO `fusion_admin` VALUES (5, 'C', '', 'Comments', 'reserved', 2); INSERT INTO `fusion_admin` VALUES (6, 'CP', 'c-pages.gif', 'Custom Pages', 'custom_pages.php', 1); INSERT INTO `fusion_admin` VALUES (7, 'DB', 'db_backup.gif', 'Database Backup', 'db_backup.php', 3); INSERT INTO `fusion_admin` VALUES (8, 'DC', 'dl_cats.gif', 'Download Categories', 'download_cats.php', 1); INSERT INTO `fusion_admin` VALUES (9, 'D', 'dl.gif', 'Downloads', 'downloads.php', 1); INSERT INTO `fusion_admin` VALUES (10, 'FQ', 'faq.gif', 'FAQs', 'faq.php', 1); INSERT INTO `fusion_admin` VALUES (11, 'F', 'forums.gif', 'Forums', 'forums.php', 1); INSERT INTO `fusion_admin` VALUES (12, 'IM', 'images.gif', 'Images', 'images.php', 1); INSERT INTO `fusion_admin` VALUES (13, 'I', 'infusions.gif', 'Infusions', 'infusions.php', 3); INSERT INTO `fusion_admin` VALUES (14, 'IP', '', 'Infusion Panels', 'reserved', 3); INSERT INTO `fusion_admin` VALUES (15, 'M', 'members.gif', 'Members', 'members.php', 2); INSERT INTO `fusion_admin` VALUES (16, 'N', 'news.gif', 'News', 'news.php', 1); INSERT INTO `fusion_admin` VALUES (17, 'NC', 'news_cats.gif', 'News Categories', 'news_cats.php', 1); INSERT INTO `fusion_admin` VALUES (18, 'P', 'panels.gif', 'Panels', 'panels.php', 3); INSERT INTO `fusion_admin` VALUES (19, 'PH', 'photoalbums.gif', 'Photo Albums', 'photoalbums.php', 1); INSERT INTO `fusion_admin` VALUES (20, 'PI', 'phpinfo.gif', 'PHP Info', 'phpinfo.php', 3); INSERT INTO `fusion_admin` VALUES (21, 'PO', 'polls.gif', 'Polls', 'polls.php', 1); INSERT INTO `fusion_admin` VALUES (22, 'S', 'shout.gif', 'Shoutbox', 'shoutbox.php', 2); INSERT INTO `fusion_admin` VALUES (23, 'SL', 'site_links.gif', 'Site Links', 'site_links.php', 3); INSERT INTO `fusion_admin` VALUES (24, 'SU', 'submissions.gif', 'Submissions', 'submissions.php', 2); INSERT INTO `fusion_admin` VALUES (25, 'U', 'upgrade.gif', 'Upgrade', 'upgrade.php', 3); INSERT INTO `fusion_admin` VALUES (26, 'UG', 'user_groups.gif', 'User Groups', 'user_groups.php', 2); INSERT INTO `fusion_admin` VALUES (27, 'WC', 'wl_cats.gif', 'Web Link Categories', 'weblink_cats.php', 1); INSERT INTO `fusion_admin` VALUES (28, 'W', 'wl.gif', 'Web Links', 'weblinks.php', 1); INSERT INTO `fusion_admin` VALUES (29, 'S1', 'settings.gif', 'Main Settings', 'settings_main.php', 3); INSERT INTO `fusion_admin` VALUES (30, 'S2', 'settings_time.gif', 'Time and Date Settings', 'settings_time.php', 3); INSERT INTO `fusion_admin` VALUES (31, 'S3', 'settings_forum.gif', 'Forum Settings', 'settings_forum.php', 3); INSERT INTO `fusion_admin` VALUES (32, 'S4', 'registration.gif', 'Registration Settings', 'settings_registration.php', 3); INSERT INTO `fusion_admin` VALUES (33, 'S5', 'photoalbums.gif', 'Photo Gallery Settings', 'settings_photo.php', 3); INSERT INTO `fusion_admin` VALUES (34, 'S6', 'settings_misc.gif', 'Miscellaneous Settings', 'settings_misc.php', 3); INSERT INTO `fusion_admin` VALUES (35, 'S7', 'settings_pm.gif', 'Private Message Options', 'settings_messages.php', 3); -- -------------------------------------------------------- -- -- Table structure for table `fusion_article_cats` -- CREATE TABLE `fusion_article_cats` ( `article_cat_id` smallint(5) unsigned NOT NULL auto_increment, `article_cat_name` varchar(100) NOT NULL default '', `article_cat_description` varchar(200) NOT NULL default '', `article_cat_sorting` varchar(50) NOT NULL default 'article_subject ASC', `article_cat_access` tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`article_cat_id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -- Dumping data for table `fusion_article_cats` -- INSERT INTO `fusion_article_cats` VALUES (1, 'Battlegrounds Events', 'Battlegrounds Events Will be Posted Here', 'article_subject ASC', 0); -- -------------------------------------------------------- -- -- Table structure for table `fusion_articles` -- CREATE TABLE `fusion_articles` ( `article_id` smallint(5) unsigned NOT NULL auto_increment, `article_cat` smallint(5) unsigned NOT NULL default '0', `article_subject` varchar(200) NOT NULL default '', `article_snippet` text NOT NULL, `article_article` text NOT NULL, `article_breaks` char(1) NOT NULL default '', `article_name` smallint(5) unsigned NOT NULL default '1', `article_datestamp` int(10) unsigned NOT NULL default '0', `article_reads` smallint(5) unsigned NOT NULL default '0', `article_allow_comments` tinyint(1) unsigned NOT NULL default '1', `article_allow_ratings` tinyint(1) unsigned NOT NULL default '1', PRIMARY KEY (`article_id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -- Dumping data for table `fusion_articles` -- INSERT INTO `fusion_articles` VALUES (1, 1, 'Warsong', 'fhgfhgfhhgfhgfhgfhgfhgfhgfhgfhgfhgfhgfhgfhgfhgfhgfhgf
hgfhgfhgfhgfhgfhgfhgfhgfhgfhgfhgfhgfhgfhgfhgfhgfhgfhgf
hgfhgfhgfhgfhgfhgfhgfhgfhgfhgfhgfhgfhgfhgfhgf', '', 'n', 1, 1177416952, 3, 0, 0); -- -------------------------------------------------------- -- -- Table structure for table `fusion_blacklist` -- CREATE TABLE `fusion_blacklist` ( `blacklist_id` smallint(5) unsigned NOT NULL auto_increment, `blacklist_ip` varchar(20) NOT NULL default '', `blacklist_email` varchar(100) NOT NULL default '', `blacklist_reason` text NOT NULL, PRIMARY KEY (`blacklist_id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -- Dumping data for table `fusion_blacklist` -- -- -------------------------------------------------------- -- -- Table structure for table `fusion_comments` -- CREATE TABLE `fusion_comments` ( `comment_id` smallint(5) unsigned NOT NULL auto_increment, `comment_item_id` smallint(5) unsigned NOT NULL default '0', `comment_type` char(2) NOT NULL default '', `comment_name` varchar(50) NOT NULL default '', `comment_message` text NOT NULL, `comment_smileys` tinyint(1) unsigned NOT NULL default '1', `comment_datestamp` int(10) unsigned NOT NULL default '0', `comment_ip` varchar(20) NOT NULL default '0.0.0.0', PRIMARY KEY (`comment_id`) ) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ; -- -- Dumping data for table `fusion_comments` -- INSERT INTO `fusion_comments` VALUES (7, 2, 'P', 'fd', 'fd', 1, 1176234165, '127.0.0.1'); INSERT INTO `fusion_comments` VALUES (9, 2, 'P', '1', 'jhgjhg', 1, 1184141971, '91.148.143.68'); -- -------------------------------------------------------- -- -- Table structure for table `fusion_custom_pages` -- CREATE TABLE `fusion_custom_pages` ( `page_id` smallint(5) NOT NULL auto_increment, `page_title` varchar(200) NOT NULL default '', `page_access` tinyint(3) unsigned NOT NULL default '0', `page_content` text NOT NULL, `page_allow_comments` tinyint(1) unsigned NOT NULL default '0', `page_allow_ratings` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`page_id`) ) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=latin1 AUTO_INCREMENT=23 ; -- -- Dumping data for table `fusion_custom_pages` -- INSERT INTO `fusion_custom_pages` VALUES (1, 'Server Status', 0, '\\"4.1\\")\r\n mysql_unbuffered_query(\\"SET NAMES cp1251\\");\r\n $sqlquery =mysql_query(\\"SELECT * FROM restart\\") or die(mysql_error());\r\n $row = mysql_fetch_array($sqlquery, MYSQL_ASSOC);\r\n $sqlquery =mysql_query(\\"SELECT * FROM restart\\") or die(mysql_error());\r\n $row = mysql_fetch_array($sqlquery, MYSQL_ASSOC);\r\n $row[\\''start_time\\''];\r\n$time=time();\r\n$uptime=$time-$row[\\''start_time\\''];\r\n\r\n$day = floor(($uptime / 86400)*1.0) ;\r\n $calc1 = $day * 86400 ;\r\n $calc2 = $uptime - $calc1 ;\r\n $hour = floor(($calc2 / 3600)*1.0) ;\r\n if ($hour < 10) {\r\n $hour = \\"0\\".$hour ;\r\n}\r\n $calc3 = $hour * 3600 ;\r\n $calc4 = $calc2 - $calc3 ;\r\n $min = floor(($calc4 / 60)*1.0) ;\r\n if ($min < 10) {\r\n $min = \\"0\\".$min ;\r\n}\r\n $calc5 = $min * 60 ;\r\n $sec = floor(($calc4 - $calc5)*1.0) ;\r\n if ($min < 10) {\r\n}\r\nif (realm_OnLine())\r\n{\r\n $uptime_sega = $day.\\" Дн., \\".$hour.\\" ч. \\".$min.\\" мин. \\".$sec.\\"сек.\\" ;\r\n echo $uptime_sega;\r\n}\r\nelse echo \\"
Server Offline\\";\r\n?>', 0, 0); INSERT INTO `fusion_custom_pages` VALUES (19, 'World Map', 0, '\r\n \r\n \r\n \r\n
\r\n

World Map

\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
\r\n', 0, 0); INSERT INTO `fusion_custom_pages` VALUES (13, 'Talent Calculator', 0, '\r\n\r\n
', 0, 0); INSERT INTO `fusion_custom_pages` VALUES (8, 'Online Players', 0, ' \\''Creation of account\\'',\r\n \\''create\\'' => \\''is completed !\\'',\r\n \\''failed\\'' => \\''was not possible !\\'',\r\n \\''not_all\\'' => \\''Fields are filled not all\\'',\r\n \\''playerson\\'' => \\''players online\\'',\r\n \\''off\\'' => \\''is offline\\'',\r\n \\''name\\'' => \\''Account Name\\'',\r\n \\''password\\'' => \\''Password\\'',\r\n \\''ip_limit\\'' => Array(\\''From your IP \\'',\\'' accounts are already created\\''),\r\n \\''char\\'' => Array(\\''Name\\'',\\''Race\\'',\\''Class\\'',\\''LvL\\'',\\''Location\\''),\r\n );\r\n break; \r\ncase \\"ru\\": \r\n $button=\\"create_ru.gif\\";\r\n $text = Array(\r\n \\''acc\\'' => \\''Создание аккаунта\\'',\r\n \\''create\\'' => \\''завершено !\\'',\r\n \\''failed\\'' => \\''невозможно !\\'',\r\n \\''not_all\\'' => \\''Заполнены не все поля\\'',\r\n \\''playerson\\'' => \\''игроков на сервере\\'',\r\n \\''off\\'' => \\''сейчас отключен\\'',\r\n \\''name\\'' => \\''Имя Аккаунта\\'',\r\n \\''password\\'' => \\''Пароль\\'',\r\n \\''ip_limit\\'' => Array(\\''С вашего IP \\'',\\'' аккаунтов уже создано\\''),\r\n \\''char\\'' => Array(\\''Персонаж\\'',\\''Раса\\'',\\''Класс\\'',\\''ЛвЛ\\'',\\''Расположение\\''),\r\n );\r\n break; \r\n}\r\n\r\n$maps_a = Array(\r\n 0 => \\''Azeroth\\'', \r\n 1 => \\''Kalimdor\\'', \r\n 2 => \\''UnderMine\\'',\r\n 13 => \\''Test zone\\'',\r\n 17 => \\''Kalidar\\'',\r\n 30 => \\''Alterac Valley\\'', \r\n 33 => \\''Shadowfang Keep Instance\\'', \r\n 34 => \\''The Stockade Instance\\'', \r\n 35 => \\''Stormwind Prizon\\'', \r\n 36 => \\''Deadmines Instance\\'', \r\n 43 => \\''Wailing Caverns Instance\\'', \r\n 44 => \\''Monastery Interior\\'', \r\n 47 => \\''Razorfen Kraul Instance\\'', \r\n 48 => \\''Blackfathom Deeps Instance\\'', \r\n 70 => \\''Uldaman Instance\\'', \r\n 90 => \\''Gnomeregan Instance\\'', \r\n 109 => \\''Sunken Temple Instance\\'', \r\n 129 => \\''Razorfen Downs Instance\\'', \r\n 150 => \\''Outland\\'', \r\n 169 => \\''Emerald Forest\\'', \r\n 189 => \\''Scarlet Monastery Instance\\'', \r\n 209 => \\''Zul\\\\\\''Farrak Instance\\'', \r\n 229 => \\''Blackrock Spire Instance\\'', \r\n 230 => \\''Blackrock Depths Instance\\'', \r\n 249 => \\''Onyxia\\\\\\''s Lair Instance\\'', \r\n 269 => \\''Caverns of Time\\'', \r\n 289 => \\''Scholomance Instance\\'', \r\n 309 => \\''Zul\\\\\\''Gurub Instance\\'', \r\n 329 => \\''Stratholme Instance\\'', \r\n 349 => \\''Mauradon Instance\\'', \r\n 369 => \\''Deeprun Tram\\'', \r\n 389 => \\''Ragefire Chasm Instance\\'', \r\n 409 => \\''The Molten Core Instance\\'', \r\n 429 => \\''Dire Maul Instance\\'', \r\n 449 => \\''Alliance PVP Barracks\\'', \r\n 450 => \\''Horde PVP Barracks\\'', \r\n 451 => \\''Development Land\\'', \r\n 469 => \\''Blackwing Lair Instance\\'', \r\n 489 => \\''Warsong Gulch\\'', \r\n 509 => \\''Ruins of Ahn\\\\\\''Qiraj Instance\\'', \r\n 529 => \\''Arathi Basin\\'',\r\n 531 => \\''Temple of Ahn\\\\\\''Qiraj Instance\\'', \r\n 533 => \\''Naxxramas Instance\\'',\r\n 530 => \\''Outlands\\'',\r\n 532 => \\''Karazhan\\'',\r\n 560 => \\''Old Hillsbrad\\'',\r\n 540 => \\''The Shattered Halls\\'',\r\n 542 => \\''The Blood Furnace\\'',\r\n 543 => \\''Hellfire Ramparts\\'',\r\n 544 => \\''Magtheridon\\\\\\''s Lair\\'',\r\n 545 => \\''The Steamvault\\'',\r\n 546 => \\''The Underbog\\'',\r\n 547 => \\''The Slave Pens\\'',\r\n 548 => \\''Serpentshrine Cavern\\'',\r\n 550 => \\''The Eye\\'',\r\n 552 => \\''The Arcatraz\\'',\r\n 553 => \\''The Botanica\\'',\r\n 554 => \\''The Mechanar\\'',\r\n 555 => \\''Shadow Labyrinth\\'',\r\n 556 => \\''Sethekk Halls\\'',\r\n 557 => \\''Mana-Tombs\\'',\r\n 558 => \\''Auchenai Crypts\\'',\r\n 559 => \\''Nagrand Arena\\'',\r\n 562 => \\''Blade\\\\\\''s Edge Arena\\'',\r\n 564 => \\''Black Temple\\'',\r\n 565 => \\''Gruul\\\\\\''s Lair\\'',\r\n 566 => \\''Eye of the Storm\\'',\r\n 568 => \\''Zul\\\\\\''Aman\\'',\r\n 37 => \\''Azshara Crater\\'',\r\n 534 => \\''Old Hyjal\\'', \r\n);\r\n\r\n\r\n\r\n$zone = Array(\r\n 0 => Array(\r\n Array(700,10,1244,1873,\\''Undercity\\'',1497),\r\n Array(-840,-1330,-5050,-4560,\\''Ironforge\\'',1537),\r\n Array(1190,200,-9074,-8280,\\''Stormwind City\\'',1519),\r\n Array(-2170,-4400,-7348,-6006,\\''Badlands\\'',3),\r\n Array(-500,-4400,-4485,-2367,\\''Wetlands\\'',11),\r\n Array(2220,-2250,-15422,-11299,\\''Stranglethorn Vale\\'',33),\r\n Array(-1724,-3540,-9918,-8667,\\''Redridge Mountains\\'',44),\r\n Array(-2480,-4400,-6006,-4485,\\''Loch Modan\\'',38),\r\n Array(662,-1638,-11299,-9990,\\''Duskwood\\'',10),\r\n Array(-1638,-2344,-11299,-9918,\\''Deadwind Pass\\'',41),\r\n Array(834,-1724,-9990,-8526,\\''Elwynn Forest\\'',12),\r\n Array(-500,-3100,-8667,-7348,\\''Burning Steppes\\'',46),\r\n Array(-608,-2170,-7348,-6285,\\''Searing Gorge\\'',51),\r\n Array(2000,-2480,-6612,-4485,\\''Dun Morogh\\'',1),\r\n Array(-1575,-5425,-432,805,\\''The Hinterlands\\'',47),\r\n Array(3016,662,-11299,-9400,\\''Westfall\\'',40),\r\n Array(600,-1575,-1874,220,\\''Hillsbrad Foothills\\'',267),\r\n Array(-2725,-6056,805,3800,\\''Eastern Plaguelands\\'',139),\r\n Array(-850,-2725,805,3400,\\''Western Plaguelands\\'',28),\r\n Array(2200,600,-900,1525,\\''Silverpine Forest\\'',130),\r\n Array(2200,-850,1525,3400,\\''Tirisfal Glades\\'',85),\r\n Array(-2250,-3520,-12800,-10666,\\''Blasted Lands\\'',4),\r\n Array(-2344,-4516,-11070,-9600,\\''Swamp of Sorrows\\'',8),\r\n Array(-1575,-3900,-2367,-432,\\''Arathi Highlands\\'',45),\r\n Array(600,-1575,220,1525,\\''Alterac Mountains\\'',36),\r\n ),\r\n 1 => Array(\r\n Array(2698,2030,9575,10267,\\''Darnassus\\'',1657),\r\n Array(326,-360,-1490,-910,\\''Thunder Bluff\\'',1638),\r\n Array(-3849,-4809,1387,2222,\\''Orgrimmar\\'',1637),\r\n Array(-1300,-3250,7142,8500,\\''Moonglade\\'',493),\r\n Array(2021,-400,-9000,-6016,\\''Silithus\\'',1377),\r\n Array(-2259,-7000,4150,8500,\\''Winterspring\\'',618),\r\n Array(-400,-2094,-8221,-6016,\\''Un\\\\\\''Goro Crater\\'',490),\r\n Array(-590,-2259,3580,7142,\\''Felwood\\'',361),\r\n Array(-3787,-8000,1370,6000,\\''Azshara\\'',16),\r\n Array(-1900,-5500,-10475,-6825,\\''Tanaris\\'',440),\r\n Array(-2478,-5500,-5135,-2330,\\''Dustwallow Marsh\\'',15),\r\n Array(360,-1536,-3474,-412,\\''Mulgore\\'',215),\r\n Array(4000,-804,-6828,-2477,\\''Feralas\\'',357),\r\n Array(3500,360,-2477,372,\\''Desolace\\'',405),\r\n Array(-804,-5500,-6828,-4566,\\''Thousand Needles\\'',400),\r\n Array(-3758,-5500,-1300,1370,\\''Durotar\\'',14),\r\n Array(1000,-3787,1370,4150,\\''Ashenvale\\'',331),\r\n Array(2500,-1300,4150,8500,\\''Darkshore\\'',148),\r\n Array(3814,-1100,8600,11831,\\''Teldrassil\\'',141),\r\n Array(3500,-804,-412,3580,\\''Stonetalon Mountains\\'',406),\r\n Array(-804,-4200,-4566,1370,\\''The Barrens\\'',17),\r\n ),\r\n 530 => Array(\r\n Array(12996,-4468,-5821,5821,\\''Outland\\'',466),\r\n Array(10295,4770,-3641,41,\\''Nagrand\\'',477),\r\n Array(9475,4447,-1416,1935,\\''Zangarmarsh\\'',467),\r\n Array(5539,375,-1962,1481,\\''Hellfire Peninsula\\'',465),\r\n Array(4225,-1275,-5614,-1947,\\''Shadowmoon Valley\\'',473),\r\n Array(8845,3420,791,4408,\\''Blade\\\\\\''s Edge Mountains\\'',475),\r\n Array(7083,1683,-4600,-1000,\\''Terokkar Forest\\'',478),\r\n Array(5483,-91,1739,5456,\\''Netherstorm\\'',479),\r\n Array(-4487,-9412,7758,11041,\\''Eversong Woods\\'',462),\r\n Array(-5.283,-8583,6066,8266,\\''Ghostlands\\'',463),\r\n Array(-10500,-14570,-5508,-2793,\\''Azuremyst Isle\\'',464),\r\n Array(-10075,-13337,-2933,-758,\\''Bloodmyst Isle\\'',476),\r\n Array(-11066,-12123,-4314,-3609,\\''The Exodar\\'',471),\r\n Array(-6400,-7612,9346,10153,\\''Silvermoon City\\'',480),\r\n Array(6135,4829,-2344,-1473,\\''Shattrath City\\'',481),\r\n ),\r\n 566 => Array(\r\n Array(2660,389,1404,2918,\\''Eye of the Storm\\'',482),\r\n ),\r\n\r\n);\r\n\r\n$def = Array(\r\n \\''character_race\\'' => Array(\r\n 1 => \\''Human\\'',\r\n 2 => \\''Orc\\'',\r\n 3 => \\''Dwarf\\'',\r\n 4 => \\''Night Elf\\'',\r\n 5 => \\''Undead\\'',\r\n 6 => \\''Tauren\\'',\r\n 7 => \\''Gnome\\'',\r\n 8 => \\''Troll\\'',\r\n 9 => \\''Goblin\\'',\r\n 11 => \\''Draenei\\'',\r\n 10 => \\''Blood Elf\\'',\r\n ),\r\n\r\n \\''character_class\\'' => Array(\r\n 1 => \\''Warrior\\'',\r\n 2 => \\''Paladin\\'',\r\n 3 => \\''Hunter\\'',\r\n 4 => \\''Rogue\\'',\r\n 5 => \\''Priest\\'',\r\n 7 => \\''Shaman\\'',\r\n 8 => \\''Mage\\'',\r\n 9 => \\''Warlock\\'',\r\n 11 => \\''Druid\\'',\r\n ),\r\n);\r\n\r\nclass DBLayer\r\n{\r\n var $link_id;\r\n var $query_result;\r\n var $saved_queries = array();\r\n var $num_queries = 0;\r\n\r\n function DBLayer($db_host, $db_username, $db_password, $db_name)\r\n {\r\n $this->link_id = @mysql_connect($db_host, $db_username, $db_password, true);\r\n\r\n if ($this->link_id)\r\n {\r\n if (@mysql_select_db($db_name, $this->link_id))\r\n return $this->link_id;\r\n else\r\n error(\\''Unable to select database. MySQL reported: \\''.mysql_error(), __FILE__, __LINE__);\r\n }\r\n else\r\n error(\\''Unable to connect to MySQL server. MySQL reported: \\''.mysql_error(), __FILE__, __LINE__);\r\n }\r\n\r\n function query($sql)\r\n {\r\n $this->query_result = @mysql_query($sql, $this->link_id);\r\n\r\n if ($this->query_result)\r\n {\r\n ++$this->num_queries;\r\n return $this->query_result;\r\n }\r\n else\r\n {\r\n return false;\r\n }\r\n }\r\n\r\n\r\n function result($query_id = 0, $row = 0)\r\n {\r\n return ($query_id) ? @mysql_result($query_id, $row) : false;\r\n }\r\n\r\n\r\n function fetch_assoc($query_id = 0)\r\n {\r\n return ($query_id) ? @mysql_fetch_assoc($query_id) : false;\r\n }\r\n\r\n\r\n function fetch_row($query_id = 0)\r\n {\r\n return ($query_id) ? @mysql_fetch_row($query_id) : false;\r\n }\r\n\r\n\r\n function num_rows($query_id = 0)\r\n {\r\n return ($query_id) ? @mysql_num_rows($query_id) : false;\r\n }\r\n\r\n\r\n function affected_rows()\r\n {\r\n return ($this->link_id) ? @mysql_affected_rows($this->link_id) : false;\r\n }\r\n\r\n\r\n function insert_id()\r\n {\r\n return ($this->link_id) ? @mysql_insert_id($this->link_id) : false;\r\n }\r\n\r\n\r\n function get_num_queries()\r\n {\r\n return $this->num_queries;\r\n }\r\n\r\n\r\n function get_saved_queries()\r\n {\r\n return $this->saved_queries;\r\n }\r\n\r\n\r\n function free_result($query_id = false)\r\n {\r\n return ($query_id) ? @mysql_free_result($query_id) : false;\r\n }\r\n\r\n\r\n function escape($str)\r\n {\r\n if (function_exists(\\''mysql_real_escape_string\\''))\r\n return mysql_real_escape_string($str, $this->link_id);\r\n else\r\n return mysql_escape_string($str);\r\n }\r\n\r\n\r\n function error()\r\n {\r\n $result[\\''error_sql\\''] = @current(@end($this->saved_queries));\r\n $result[\\''error_no\\''] = @mysql_errno($this->link_id);\r\n $result[\\''error_msg\\''] = @mysql_error($this->link_id);\r\n\r\n return $result;\r\n }\r\n\r\n\r\n function close()\r\n {\r\n if ($this->link_id)\r\n {\r\n if ($this->query_result)\r\n @mysql_free_result($this->query_result);\r\n\r\n return @mysql_close($this->link_id);\r\n }\r\n else\r\n return false;\r\n }\r\n}\r\n\r\nfunction error($message, $file, $line, $db_error = false)\r\n{\r\n global $siteerrors;\r\n $s = \\"\\\\t\\\\t\\".\\''Error: \\''.$message.\\''.\\''.\\"\\\\n\\";\r\n echo $s;\r\n}\r\n\r\nfunction get_zone_name($mapid, $x, $y){\r\nglobal $maps_a, $zone;\r\n\r\nif (!empty($maps_a[$mapid]))\r\n {\r\n $zmap=$maps_a[$mapid];\r\n if (($mapid==0) or ($mapid==1) or ($mapid==530))\r\n {\r\n $i=0; $c=count($zone[$mapid]);\r\n while ($i<$c)\r\n {\r\n if ($zone[$mapid][$i][2] < $x AND $zone[$mapid][$i][3] > $x AND $zone[$mapid][$i][1] < $y AND $zone[$mapid][$i][0] > $y) $zmap=$zone[$mapid][$i][4];\r\n $i++;\r\n }\r\n }\r\n } else $zmap=\\"Unknown zone\\";\r\nreturn $zmap;\r\n } \r\n\r\nfunction test_realm(){\r\n global $server, $port;\r\n $s = @fsockopen(\\"$server\\", $port, $ERROR_NO, $ERROR_STR,(float)0.5);\r\n if($s){@fclose($s);return true;} else return false;\r\n}\r\n\r\nfunction get_realm_name(){\r\n global $hostr, $userr, $passwordr, $dbr, $database_encoding;\r\n $realm_db = new DBLayer($hostr, $userr, $passwordr, $dbr);\r\n $realm_db->query(\\"SET NAMES $database_encoding\\");\r\n $query = $realm_db->query(\\"SELECT * FROM `realmlist`\\");\r\n $result = $realm_db->fetch_assoc($query);\r\n $realm_db->close();\r\n unset($realm_db);\r\n return($result[\\''name\\'']);\r\n\r\n\r\n\r\n// сделать проверку на неполучение ипа\r\n\r\n $realm_db = new DBLayer($hostr, $userr, $passwordr, $dbr);\r\n $realm_db->query(\\"SET NAMES $database_encoding\\");\r\n\r\n$ip_cr=0;\r\nif ($lock_reg!=0){\r\n $query = $realm_db->query(\\"SELECT `last_ip` FROM `account` WHERE `last_ip`=\\''$ip\\''\\");\r\n while($result = $realm_db->fetch_assoc($query)) $ip_cr++;\r\n}\r\n\r\nif (($ip_cr>=$lock_reg) && ($lock_reg!=0))\r\n{\r\n $cont=\\''\r\n\\''.$text[\\"ip_limit\\"][0].$ip.\\''
\\''.$ip_cr.$text[\\"ip_limit\\"][1].\\''\r\n

Back\\'';\r\n } else\r\n {\r\n if($realm_db->query(\\"INSERT INTO `account` (`username`,`password`,`email`,`last_ip`,`locked`) VALUES (\\''$username\\'',\\''$passw\\'',\\''$email\\'',\\''$ip\\'',\\''$lock_acc\\'')\\"))\r\n {\r\n $cont=\\''\r\n\\''.$text[\\"acc\\"].\\''
\\''.$username.\\''
\\''.$text[\\"create\\"].\\''\r\n\\'';\r\n }\r\n else\r\n {\r\n $cont=\\''\r\n\\''.$text[\\"acc\\"].\\''
\\''.$username.\\''
\\''.$text[\\"failed\\"].\\''\r\n

Back\\'';\r\n }\r\n}\r\n\r\n\r\n \r\n $realm_db->close();\r\n unset($realm_db);\r\n }\r\n\r\n\r\n\r\nfunction make_players_array(){\r\n global $host, $user, $password, $db, $database_encoding, $pl_array;\r\n$i=0;\r\n $mangos_db = new DBLayer($host, $user, $password, $db);\r\n $mangos_db->query(\\"SET NAMES $database_encoding\\");\r\n $query = $mangos_db->query(\\"SELECT * FROM `character` WHERE `online`=\\''1\\'' ORDER BY `name`\\");\r\n while($result = $mangos_db->fetch_assoc($query))\r\n {\r\n $char_data = explode(\\'' \\'',$result[\\''data\\'']);\r\n $char_gender = dechex($char_data[36]);\r\n $char_gender = str_pad($char_gender,8, 0, STR_PAD_LEFT);\r\n $char_gender = $char_gender{3};\r\n $res_pos=get_zone_name($result[\\''map\\''], $result[\\''position_x\\''], $result[\\''position_y\\'']);\r\n\r\n$pl_array[$i] = Array($result[\\''name\\''], $result[\\''race\\''], $result[\\''class\\''], $char_data[34], $res_pos, $char_gender);\r\n$i++;\r\n }\r\n $mangos_db->close();\r\n unset($mangos_db);\r\nreturn $i;\r\n}\r\n\r\n$onlineplayers=make_players_array();\r\n\r\nif (!$sort = &$_GET[\\''s\\'']) $sort=0;\r\nif (!$flag = &$_GET[\\''f\\'']) $flag=0;\r\nif ($flag==0) { $flag=1; $sort_type=\\''<\\''; } \r\n else { $flag=0; $sort_type=\\''>\\''; }\r\n$link=$_SERVER[\\''PHP_SELF\\''].\\"?f=\\".$flag.\\"&s=\\";\r\n\r\nif (!empty($pl_array)) \r\n {\r\n usort($pl_array, create_function(\\''$a, $b\\'', \\''if ( $a[\\''.$sort.\\''] == $b[\\''.$sort.\\''] ) return 0; if ( $a[\\''.$sort.\\''] \\''.$sort_type.\\'' $b[\\''.$sort.\\''] ) return -1; return 1;\\''));\r\n }\r\n\r\n$list=\\"\\";\r\n$i=0;\r\nwhile ($i < $onlineplayers)\r\n {\r\n $name=$pl_array[$i][0];\r\n $race=$pl_array[$i][1];\r\n $class=$pl_array[$i][2];\r\n $res_race = $def[\\''character_race\\''][$race];\r\n $res_class = $def[\\''character_class\\''][$class];\r\n $lvl=$pl_array[$i][3];\r\n $loc=$pl_array[$i][4];\r\n $gender=$pl_array[$i][5];\r\n $list.= \\"\r\n \r\n \r\n $name\r\n $res_race\r\n $res_class\r\n $lvl\r\n $loc\r\n \\";\r\n $i++;\r\n }\r\n\r\n$title=get_realm_name();\r\nif (test_realm())\r\n {\r\n $title.=(\\'' (\\''.$onlineplayers.\\'' \\''.$text[\\"playerson\\"].\\'')\\'');\r\n } else\r\n {\r\n $title.=(\\'' \\''.$text[\\"off\\"]);\r\n }\r\n\r\n\r\n// Main part !!!\r\n?>\r\n<?php print $title ?>\r\nstyle.css\\" type=text/css \r\nrel=stylesheet>\r\n\r\n\r\n\r\n
\r\n\r\n \r\n \r\n
\r\n backcreateiy1.jpg\\" border=0 style=\\"background-repeat: repeat-x;\\">\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
\r\n
\r\n
pixel.gif\\" \r\n width=1>
pixel.gif\\" \r\n width=203>\r\n \r\n \r\n
pixel.gif\\" \r\n width=217>
\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
pixel.gif\\" width=1>
pixel.gif\\" width=106>\r\n \r\n

\r\n\r\n\r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
\\''.$text[\\''char\\''][0] ?>\\''.$text[\\''char\\''][1] ?>\\''.$text[\\''char\\''][2] ?>\\''.$text[\\''char\\''][3] ?>\\''.$text[\\''char\\''][4] ?>
pixel.gif\\'' width=400>
\r\n\r\n 		pixel.gif\\" width=124>
pixel.gif\\" \r\n width=1>
', 0, 0); INSERT INTO `fusion_custom_pages` VALUES (21, 'Components', 0, '
\r\n
Teleporter
\r\n(Teleport Your Here to some of the main city )
\r\n

\r\n\\''teleporter\\''

\r\n\r\n
\r\n\r\n
Change Account Password
\r\n(Change your old account password with new one)
\r\n

\r\n\\''passchange\\''

\r\n\r\n
\r\n\r\n
Ustucker
\r\n(Your Charecter is stuck ? use this tool to fix it)
\r\n

\r\n\\''unstuck\\''

\r\n\r\n
\r\n
Character Transfer
\r\n(Move Your Character to a new account)
\r\n

\r\n\\''POMM\\''

\r\n\r\n\r\n
\r\n
Players online Map
\r\n(Show Online Players Locations on the Map)
\r\n

\r\n\\''POMM\\''

\r\n\r\n\r\n
\r\n
World Map
\r\n(Show the World map all ciry flypath and etc.)\r\n

\r\n\\''World

\r\n
', 0, 0); INSERT INTO `fusion_custom_pages` VALUES (22, 'Countdown', 0, '
\r\n
', 0, 0); -- -------------------------------------------------------- -- -- Table structure for table `fusion_download_cats` -- CREATE TABLE `fusion_download_cats` ( `download_cat_id` smallint(5) unsigned NOT NULL auto_increment, `download_cat_name` varchar(100) NOT NULL default '', `download_cat_description` text NOT NULL, `download_cat_sorting` varchar(50) NOT NULL default 'download_title ASC', `download_cat_access` tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`download_cat_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; -- -- Dumping data for table `fusion_download_cats` -- INSERT INTO `fusion_download_cats` VALUES (1, 'Patches', 'World of Warcraft Patches needed to play on the server', 'download_datestamp ASC', 0); -- -------------------------------------------------------- -- -- Table structure for table `fusion_downloads` -- CREATE TABLE `fusion_downloads` ( `download_id` smallint(5) unsigned NOT NULL auto_increment, `download_title` varchar(100) NOT NULL default '', `download_description` text NOT NULL, `download_url` varchar(200) NOT NULL default '', `download_cat` smallint(5) unsigned NOT NULL default '0', `download_license` varchar(50) NOT NULL default '', `download_os` varchar(50) NOT NULL default '', `download_version` varchar(20) NOT NULL default '', `download_filesize` varchar(20) NOT NULL default '', `download_datestamp` int(10) unsigned NOT NULL default '0', `download_count` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`download_id`) ) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ; -- -- Dumping data for table `fusion_downloads` -- INSERT INTO `fusion_downloads` VALUES (11, 'World of Warcraft Burning Crusade Expansion - enGB "Torrent"', 'This is World of Warcraft Expansion\r\nThis Will update Your WOW To Expansion Pack to Version 2.0.0 enGB', '../files/WoW-BurningCrusade-enGB-Installer-full-downloader.torrent', 1, '', '', '', '2,23 GB', 1187700261, 1); INSERT INTO `fusion_downloads` VALUES (12, 'World of Warcraft Burning Crusade Expansion - enUS "Torrent"', 'This is World of Warcraft Expansion\r\nThis Will update Your WOW To Expansion Pack to Version 2.0.0 enUS', '../files/WoW-BurningCrusade-enUS-Installer-full-downloader.torrent', 1, '', '', '', '2.05 GB', 1187700492, 0); -- -------------------------------------------------------- -- -- Table structure for table `fusion_faq_cats` -- CREATE TABLE `fusion_faq_cats` ( `faq_cat_id` smallint(5) unsigned NOT NULL auto_increment, `faq_cat_name` varchar(200) NOT NULL default '', `faq_cat_description` varchar(250) NOT NULL default '', PRIMARY KEY (`faq_cat_id`) ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; -- -- Dumping data for table `fusion_faq_cats` -- INSERT INTO `fusion_faq_cats` VALUES (1, 'Fast Guide to know what you need to play here', 'Thinks needed to do before i can play'); INSERT INTO `fusion_faq_cats` VALUES (2, 'What Commands i`m allowed to use', 'User Commands'); INSERT INTO `fusion_faq_cats` VALUES (3, 'What Rules have i to follow', 'the rules that you must keep'); -- -------------------------------------------------------- -- -- Table structure for table `fusion_faqs` -- CREATE TABLE `fusion_faqs` ( `faq_id` smallint(5) unsigned NOT NULL auto_increment, `faq_cat_id` smallint(5) unsigned NOT NULL default '0', `faq_question` varchar(200) NOT NULL default '', `faq_answer` text NOT NULL, PRIMARY KEY (`faq_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; -- -- Dumping data for table `fusion_faqs` -- INSERT INTO `fusion_faqs` VALUES (1, 1, '"What do i need to play here?"', '\r\n1. First you need World of Warcraft The Burning Crusade if you don`t have it look at download section\r\n2. Second The latest patch that server support (Currently 2.1.1)\r\n3. Register Account. Note: That this is only account for SITE After login in the site from left menu you will see link named Game Account from there you can create acccount for Game.\r\n4. Replace the file realmlist.wtf (located in the game folder) with this file realmlist.wtf\r\n5. Have fun ! :)\r\n\r\n'); INSERT INTO `fusion_faqs` VALUES (2, 2, 'All users commands', '\r\nacct\r\nSyntax: .acct\r\nDisplay the access level of your account.\r\n\r\ncommands\r\nSyntax: .commands\r\nDisplay a list of available commands for your account level.\r\n\r\ndismount\r\nSyntax: .dismount\r\nDismount you, if you are mounted.\r\n\r\ninfo\r\nSyntax: .info\r\nDisplay the number of connected players.\r\n\r\ngmlist\r\nSyntax: .gmlist\r\nDisplay a list of available Game Masters.\r\n\r\nhelp\r\nSyntax: .help\r\nDisplay usage instructions for the given .\r\n\r\nstart\r\nSyntax: .start\r\nTeleport you to the starting area of your character.\r\n'); -- -------------------------------------------------------- -- -- Table structure for table `fusion_flood_control` -- CREATE TABLE `fusion_flood_control` ( `flood_ip` varchar(20) NOT NULL default '0.0.0.0', `flood_timestamp` int(5) unsigned NOT NULL default '0' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `fusion_flood_control` -- -- -------------------------------------------------------- -- -- Table structure for table `fusion_forum_attachments` -- CREATE TABLE `fusion_forum_attachments` ( `attach_id` smallint(5) unsigned NOT NULL auto_increment, `thread_id` smallint(5) unsigned NOT NULL default '0', `post_id` smallint(5) unsigned NOT NULL default '0', `attach_name` varchar(100) NOT NULL default '', `attach_ext` varchar(5) NOT NULL default '', `attach_size` int(20) unsigned NOT NULL default '0', PRIMARY KEY (`attach_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `fusion_forum_attachments` -- -- -------------------------------------------------------- -- -- Table structure for table `fusion_forums` -- CREATE TABLE `fusion_forums` ( `forum_id` smallint(5) unsigned NOT NULL auto_increment, `forum_cat` smallint(5) unsigned NOT NULL default '0', `forum_name` varchar(100) NOT NULL default '', `forum_order` smallint(5) unsigned NOT NULL default '0', `forum_description` text NOT NULL, `forum_moderators` text NOT NULL, `forum_access` tinyint(3) unsigned NOT NULL default '0', `forum_posting` tinyint(3) unsigned NOT NULL default '0', `forum_lastpost` int(10) unsigned NOT NULL default '0', `forum_lastuser` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`forum_id`) ) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ; -- -- Dumping data for table `fusion_forums` -- INSERT INTO `fusion_forums` VALUES (1, 0, 'Elon WoW Server', 1, '', '', 0, 0, 0, 0); INSERT INTO `fusion_forums` VALUES (2, 1, 'Server News', 1, 'Everything that happen to the server will be post here like updates and etc.', '1', 0, 103, 1186991134, 1); INSERT INTO `fusion_forums` VALUES (3, 0, 'World Of Warcraft Classes', 2, '', '', 0, 0, 0, 0); INSERT INTO `fusion_forums` VALUES (4, 3, 'Warrior', 1, 'Post here everything related with this class', '1', 0, 101, 0, 0); INSERT INTO `fusion_forums` VALUES (5, 3, 'Paladin', 2, 'Post here everything related with this class', '1', 0, 101, 0, 0); INSERT INTO `fusion_forums` VALUES (6, 3, 'Druid', 3, 'Post here everything related with this class', '1', 0, 101, 0, 0); INSERT INTO `fusion_forums` VALUES (7, 3, 'Mage', 4, 'Post here everything related with this class', '1', 0, 101, 0, 0); INSERT INTO `fusion_forums` VALUES (8, 3, 'Warlock', 2, 'Post here everything related with this class', '1', 0, 101, 0, 0); INSERT INTO `fusion_forums` VALUES (9, 3, 'Shaman', 5, 'Post here everything related with this class', '1', 0, 101, 0, 0); INSERT INTO `fusion_forums` VALUES (10, 3, 'Rogue', 6, 'Post here everything related with this class', '1', 0, 101, 0, 0); INSERT INTO `fusion_forums` VALUES (11, 3, 'Priest', 7, 'Post here everything related with this class', '1', 0, 101, 0, 0); INSERT INTO `fusion_forums` VALUES (12, 3, 'Hunter', 8, 'Post here everything related with this class', '1', 0, 101, 0, 0); INSERT INTO `fusion_forums` VALUES (13, 0, 'Other', 3, '', '', 0, 0, 0, 0); INSERT INTO `fusion_forums` VALUES (14, 13, 'Trunk', 1, 'everything talk about here ', '1', 0, 101, 0, 0); -- -------------------------------------------------------- -- -- Table structure for table `fusion_infusions` -- CREATE TABLE `fusion_infusions` ( `inf_id` smallint(5) unsigned NOT NULL auto_increment, `inf_title` varchar(100) NOT NULL default '', `inf_folder` varchar(100) NOT NULL default '', `inf_version` varchar(10) NOT NULL default '0', PRIMARY KEY (`inf_id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -- Dumping data for table `fusion_infusions` -- -- -------------------------------------------------------- -- -- Table structure for table `fusion_messages` -- CREATE TABLE `fusion_messages` ( `message_id` smallint(5) unsigned NOT NULL auto_increment, `message_to` smallint(5) unsigned NOT NULL default '0', `message_from` smallint(5) unsigned NOT NULL default '0', `message_subject` varchar(100) NOT NULL default '', `message_message` text NOT NULL, `message_smileys` char(1) NOT NULL default '', `message_read` tinyint(1) unsigned NOT NULL default '0', `message_datestamp` int(10) unsigned NOT NULL default '0', `message_folder` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`message_id`) ) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ; -- -- Dumping data for table `fusion_messages` -- INSERT INTO `fusion_messages` VALUES (8, 1, 1, 'Hello all', 'Sf', 'y', 1, 1174818520, 1); -- -------------------------------------------------------- -- -- Table structure for table `fusion_messages_options` -- CREATE TABLE `fusion_messages_options` ( `user_id` smallint(5) unsigned NOT NULL default '0', `pm_email_notify` tinyint(1) unsigned NOT NULL default '0', `pm_save_sent` tinyint(1) unsigned NOT NULL default '0', `pm_inbox` smallint(5) unsigned NOT NULL default '0', `pm_savebox` smallint(5) unsigned NOT NULL default '0', `pm_sentbox` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`user_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `fusion_messages_options` -- INSERT INTO `fusion_messages_options` VALUES (0, 1, 1, 20, 20, 20); -- -------------------------------------------------------- -- -- Table structure for table `fusion_new_users` -- CREATE TABLE `fusion_new_users` ( `user_code` varchar(32) NOT NULL default '', `user_email` varchar(100) NOT NULL default '', `user_datestamp` int(10) unsigned NOT NULL default '0', `user_info` text NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `fusion_new_users` -- -- -------------------------------------------------------- -- -- Table structure for table `fusion_news` -- CREATE TABLE `fusion_news` ( `news_id` smallint(5) unsigned NOT NULL auto_increment, `news_subject` varchar(200) NOT NULL default '', `news_cat` smallint(5) unsigned NOT NULL default '0', `news_news` text NOT NULL, `news_extended` text NOT NULL, `news_breaks` char(1) NOT NULL default '', `news_name` smallint(5) unsigned NOT NULL default '1', `news_datestamp` int(10) unsigned NOT NULL default '0', `news_start` int(10) unsigned NOT NULL default '0', `news_end` int(10) unsigned NOT NULL default '0', `news_visibility` tinyint(3) unsigned NOT NULL default '0', `news_reads` smallint(5) unsigned NOT NULL default '0', `news_sticky` tinyint(1) unsigned NOT NULL default '0', `news_allow_comments` tinyint(1) unsigned NOT NULL default '1', `news_allow_ratings` tinyint(1) unsigned NOT NULL default '1', PRIMARY KEY (`news_id`) ) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ; -- -- Dumping data for table `fusion_news` -- INSERT INTO `fusion_news` VALUES (2, ' Welcome To Elon WoW Server', 18, 'Welcome huhWel
', '', 'n', 1, 1172909997, 0, 0, 0, 26, 1, 0, 0); -- -------------------------------------------------------- -- -- Table structure for table `fusion_news_cats` -- CREATE TABLE `fusion_news_cats` ( `news_cat_id` smallint(5) unsigned NOT NULL auto_increment, `news_cat_name` varchar(100) NOT NULL default '', `news_cat_image` varchar(100) NOT NULL default '', PRIMARY KEY (`news_cat_id`) ) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ; -- -- Dumping data for table `fusion_news_cats` -- INSERT INTO `fusion_news_cats` VALUES (1, 'Bugs', 'bugs.gif'); INSERT INTO `fusion_news_cats` VALUES (2, 'Downloads', 'downloads.gif'); INSERT INTO `fusion_news_cats` VALUES (3, 'Games', 'games.gif'); INSERT INTO `fusion_news_cats` VALUES (4, 'Graphics', 'graphics.gif'); INSERT INTO `fusion_news_cats` VALUES (5, 'Hardware', 'hardware.gif'); INSERT INTO `fusion_news_cats` VALUES (6, 'Journal', 'journal.gif'); INSERT INTO `fusion_news_cats` VALUES (7, 'Members', 'members.gif'); INSERT INTO `fusion_news_cats` VALUES (8, 'Mods', 'mods.gif'); INSERT INTO `fusion_news_cats` VALUES (9, 'Movies', 'movies.gif'); INSERT INTO `fusion_news_cats` VALUES (10, 'Network', 'network.gif'); INSERT INTO `fusion_news_cats` VALUES (11, 'News', 'news.gif'); INSERT INTO `fusion_news_cats` VALUES (12, 'PHP-Fusion', 'php-fusion.gif'); INSERT INTO `fusion_news_cats` VALUES (13, 'Security', 'security.gif'); INSERT INTO `fusion_news_cats` VALUES (14, 'Software', 'software.gif'); INSERT INTO `fusion_news_cats` VALUES (15, 'Themes', 'themes.gif'); INSERT INTO `fusion_news_cats` VALUES (16, 'Windows', 'windows.gif'); INSERT INTO `fusion_news_cats` VALUES (17, 'BC News', 'WOW_TBC_Logo.png'); INSERT INTO `fusion_news_cats` VALUES (18, 'Server News', 'freemigration.jpg'); INSERT INTO `fusion_news_cats` VALUES (19, 'Events', 'arena.jpg'); -- -------------------------------------------------------- -- -- Table structure for table `fusion_online` -- CREATE TABLE `fusion_online` ( `online_user` varchar(50) NOT NULL default '', `online_ip` varchar(20) NOT NULL default '', `online_lastactive` int(10) unsigned NOT NULL default '0' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `fusion_online` -- INSERT INTO `fusion_online` VALUES ('0', '127.0.0.1', 1187703872); -- -------------------------------------------------------- -- -- Table structure for table `fusion_panels` -- CREATE TABLE `fusion_panels` ( `panel_id` smallint(5) unsigned NOT NULL auto_increment, `panel_name` varchar(100) NOT NULL default '', `panel_filename` varchar(100) NOT NULL default '', `panel_content` text NOT NULL, `panel_side` tinyint(1) unsigned NOT NULL default '1', `panel_order` smallint(5) unsigned NOT NULL default '0', `panel_type` varchar(20) NOT NULL default '', `panel_access` tinyint(3) unsigned NOT NULL default '0', `panel_display` tinyint(1) unsigned NOT NULL default '0', `panel_status` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`panel_id`) ) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ; -- -- Dumping data for table `fusion_panels` -- INSERT INTO `fusion_panels` VALUES (1, 'Menu', 'navigation_panel', '', 1, 1, 'file', 0, 0, 1); INSERT INTO `fusion_panels` VALUES (2, 'Online Users', 'online_users_panel', '', 1, 2, 'file', 0, 0, 1); INSERT INTO `fusion_panels` VALUES (3, 'Forum Threads', 'forum_threads_panel', '', 1, 3, 'file', 0, 0, 0); INSERT INTO `fusion_panels` VALUES (4, 'Latest Articles', 'latest_articles_panel', '', 1, 4, 'file', 0, 0, 0); INSERT INTO `fusion_panels` VALUES (5, 'Welcome Message', 'welcome_message_panel', '', 2, 1, 'file', 0, 0, 0); INSERT INTO `fusion_panels` VALUES (6, 'Forum Threads List', 'forum_threads_list_panel', '', 2, 2, 'file', 0, 0, 1); INSERT INTO `fusion_panels` VALUES (7, 'User Info', 'user_info_panel', '', 4, 1, 'file', 0, 0, 1); INSERT INTO `fusion_panels` VALUES (8, 'Members Poll', 'member_poll_panel', '', 4, 3, 'file', 0, 0, 0); INSERT INTO `fusion_panels` VALUES (9, 'Shoutbox', 'shoutbox_panel', '', 4, 2, 'file', 0, 0, 1); INSERT INTO `fusion_panels` VALUES (11, 'Screenshots', 'random_photo_panel', '', 1, 5, 'file', 0, 0, 1); -- -------------------------------------------------------- -- -- Table structure for table `fusion_photo_albums` -- CREATE TABLE `fusion_photo_albums` ( `album_id` smallint(5) unsigned NOT NULL auto_increment, `album_title` varchar(100) NOT NULL default '', `album_description` text NOT NULL, `album_thumb` varchar(100) NOT NULL default '', `album_user` smallint(5) unsigned NOT NULL default '0', `album_access` smallint(5) unsigned NOT NULL default '0', `album_order` smallint(5) unsigned NOT NULL default '0', `album_datestamp` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`album_id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -- Dumping data for table `fusion_photo_albums` -- INSERT INTO `fusion_photo_albums` VALUES (1, 'Game Screenshot', 'Take a screenshot in the game and upload it here', 'outland1_t1.jpg', 1, 0, 1, 1172682450); -- -------------------------------------------------------- -- -- Table structure for table `fusion_photos` -- CREATE TABLE `fusion_photos` ( `photo_id` smallint(5) unsigned NOT NULL auto_increment, `album_id` smallint(5) unsigned NOT NULL default '0', `photo_title` varchar(100) NOT NULL default '', `photo_description` text NOT NULL, `photo_filename` varchar(100) NOT NULL default '', `photo_thumb1` varchar(100) NOT NULL default '', `photo_thumb2` varchar(100) NOT NULL default '', `photo_datestamp` int(10) unsigned NOT NULL default '0', `photo_user` smallint(5) unsigned NOT NULL default '0', `photo_views` smallint(5) unsigned NOT NULL default '0', `photo_order` smallint(5) unsigned NOT NULL default '0', `photo_allow_comments` tinyint(1) unsigned NOT NULL default '1', `photo_allow_ratings` tinyint(1) unsigned NOT NULL default '1', PRIMARY KEY (`photo_id`) ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; -- -- Dumping data for table `fusion_photos` -- INSERT INTO `fusion_photos` VALUES (2, 1, 'Outland', 'Outland', 'outland1.jpg', 'outland1_t1.jpg', 'outland1_t2.jpg', 1174913587, 1, 40, 1, 1, 1); INSERT INTO `fusion_photos` VALUES (4, 1, 'Me in SW', 'Me in Stormwind', 'wowscrnshot_021407_182102.jpg', 'wowscrnshot_021407_182102_t1.jpg', 'wowscrnshot_021407_182102_t2.jpg', 1175187928, 7, 30, 2, 1, 1); -- -------------------------------------------------------- -- -- Table structure for table `fusion_poll_votes` -- CREATE TABLE `fusion_poll_votes` ( `vote_id` smallint(5) unsigned NOT NULL auto_increment, `vote_user` smallint(5) unsigned NOT NULL default '0', `vote_opt` smallint(2) unsigned NOT NULL default '0', `poll_id` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`vote_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; -- -- Dumping data for table `fusion_poll_votes` -- INSERT INTO `fusion_poll_votes` VALUES (1, 1, 0, 1); -- -------------------------------------------------------- -- -- Table structure for table `fusion_polls` -- CREATE TABLE `fusion_polls` ( `poll_id` smallint(5) unsigned NOT NULL auto_increment, `poll_title` varchar(200) NOT NULL default '', `poll_opt_0` varchar(200) NOT NULL default '', `poll_opt_1` varchar(200) NOT NULL default '', `poll_opt_2` varchar(200) NOT NULL default '', `poll_opt_3` varchar(200) NOT NULL default '', `poll_opt_4` varchar(200) NOT NULL default '', `poll_opt_5` varchar(200) NOT NULL default '', `poll_opt_6` varchar(200) NOT NULL default '', `poll_opt_7` varchar(200) NOT NULL default '', `poll_opt_8` varchar(200) NOT NULL default '', `poll_opt_9` varchar(200) NOT NULL default '', `poll_started` int(10) unsigned NOT NULL default '0', `poll_ended` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`poll_id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -- Dumping data for table `fusion_polls` -- INSERT INTO `fusion_polls` VALUES (1, 'Did you like site design ?', 'Yes, the best one', 'Well average', 'Not so bad', 'No, it suX', '', '', '', '', '', '', 1172999632, 0); -- -------------------------------------------------------- -- -- Table structure for table `fusion_posts` -- CREATE TABLE `fusion_posts` ( `forum_id` smallint(5) unsigned NOT NULL default '0', `thread_id` smallint(5) unsigned NOT NULL default '0', `post_id` smallint(5) unsigned NOT NULL auto_increment, `post_subject` varchar(100) NOT NULL default '', `post_message` text NOT NULL, `post_showsig` tinyint(1) unsigned NOT NULL default '0', `post_smileys` tinyint(1) unsigned NOT NULL default '1', `post_author` smallint(5) unsigned NOT NULL default '0', `post_datestamp` int(10) unsigned NOT NULL default '0', `post_ip` varchar(20) NOT NULL default '0.0.0.0', `post_edituser` smallint(5) unsigned NOT NULL default '0', `post_edittime` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`post_id`), KEY `thread_id` (`thread_id`) ) ENGINE=MyISAM AUTO_INCREMENT=32 DEFAULT CHARSET=latin1 AUTO_INCREMENT=32 ; -- -- Dumping data for table `fusion_posts` -- INSERT INTO `fusion_posts` VALUES (2, 15, 31, 'test', '[b][color=yellow]test[/color][/b]\r\n\r\n[i][color=orange]ever[/color][/i]', 0, 1, 1, 1186991134, '91.148.143.68', 1, 1186991156); -- -------------------------------------------------------- -- -- Table structure for table `fusion_ratings` -- CREATE TABLE `fusion_ratings` ( `rating_id` smallint(5) unsigned NOT NULL auto_increment, `rating_item_id` smallint(5) unsigned NOT NULL default '0', `rating_type` char(1) NOT NULL default '', `rating_user` smallint(5) unsigned NOT NULL default '0', `rating_vote` tinyint(1) unsigned NOT NULL default '0', `rating_datestamp` int(10) unsigned NOT NULL default '0', `rating_ip` varchar(20) NOT NULL default '0.0.0.0', PRIMARY KEY (`rating_id`) ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; -- -- Dumping data for table `fusion_ratings` -- -- -------------------------------------------------------- -- -- Table structure for table `fusion_settings` -- CREATE TABLE `fusion_settings` ( `sitename` varchar(200) NOT NULL default '', `siteurl` varchar(200) NOT NULL default '', `sitebanner` varchar(200) NOT NULL default '', `siteemail` varchar(100) NOT NULL default '', `siteusername` varchar(30) NOT NULL default '', `siteintro` text NOT NULL, `description` text NOT NULL, `keywords` text NOT NULL, `footer` text NOT NULL, `opening_page` varchar(100) NOT NULL default '', `news_style` tinyint(1) unsigned NOT NULL default '0', `locale` varchar(20) NOT NULL default 'English', `theme` varchar(100) NOT NULL default '', `shortdate` varchar(50) NOT NULL default '', `longdate` varchar(50) NOT NULL default '', `forumdate` varchar(50) NOT NULL default '', `subheaderdate` varchar(50) NOT NULL default '', `timeoffset` char(3) NOT NULL default '0', `numofthreads` smallint(2) unsigned NOT NULL default '5', `attachments` tinyint(1) unsigned NOT NULL default '0', `attachmax` int(12) unsigned NOT NULL default '150000', `attachtypes` varchar(150) NOT NULL default '.gif,.jpg,.png,.zip,.rar,.tar', `thread_notify` tinyint(1) unsigned NOT NULL default '0', `enable_registration` tinyint(1) unsigned NOT NULL default '1', `email_verification` tinyint(1) unsigned NOT NULL default '1', `admin_activation` tinyint(1) unsigned NOT NULL default '0', `display_validation` tinyint(1) unsigned NOT NULL default '1', `validation_method` varchar(5) NOT NULL default 'image', `thumb_w` smallint(3) unsigned NOT NULL default '100', `thumb_h` smallint(3) unsigned NOT NULL default '100', `photo_w` smallint(4) unsigned NOT NULL default '400', `photo_h` smallint(4) unsigned NOT NULL default '300', `photo_max_w` smallint(4) unsigned NOT NULL default '1800', `photo_max_h` smallint(4) unsigned NOT NULL default '1600', `photo_max_b` int(10) unsigned NOT NULL default '150000', `thumb_compression` char(3) NOT NULL default 'gd2', `thumbs_per_row` smallint(2) unsigned NOT NULL default '4', `thumbs_per_page` smallint(2) unsigned NOT NULL default '12', `tinymce_enabled` tinyint(1) unsigned NOT NULL default '0', `smtp_host` varchar(200) NOT NULL default '', `smtp_username` varchar(100) NOT NULL default '', `smtp_password` varchar(100) NOT NULL default '', `bad_words_enabled` tinyint(1) unsigned NOT NULL default '0', `bad_words` text NOT NULL, `bad_word_replace` varchar(20) NOT NULL default '[censored]', `guestposts` tinyint(1) unsigned NOT NULL default '0', `numofshouts` tinyint(2) unsigned NOT NULL default '10', `flood_interval` tinyint(2) unsigned NOT NULL default '15', `counter` bigint(20) unsigned NOT NULL default '0', `version` varchar(10) NOT NULL default '6.00.400', `maintenance` tinyint(1) unsigned NOT NULL default '0', `maintenance_message` text NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `fusion_settings` -- INSERT INTO `fusion_settings` VALUES ('Elon WoW Server', 'http://elonbc.sytes.net/', 'rotate.php', 'support@elonbc.sytes.net', 'admin', '
\r\n Welcome to Elon WoW Server\r\n

NOTE !: Please Register an a account for site then you will be able to create one for Game\r\n

\r\n
Best View With Firefox 2
', '', '', '
\r\n
Site Content ©2007 elonwow.sytes.net, World of Warcraft ©2004-2007 Blizzard Entertainment, Inc. All rights reserved.\r\nAll images and World of Warcraft related content are protected by copyright law and are registered by Blizzard Entertainment, Inc.\r\nelonwow.sytes.net is in no way related to, or endorsed by Blizzard Entertainment. Blizzard, World of Warcraft and any other\r\nrelated items are all Registered Trademarks of Blizzard Entertainment.
\r\n', 'news.php', 0, 'English', 'awebcms_dark', '%d/%m/%Y %H:%M', '%B %d %Y %H:%M:%S', '%d-%m-%Y %H:%M', '%B %d %Y %H:%M:%S', '0', 5, 0, 150000, '.gif,.jpg,.png,.zip,.rar,.tar', 1, 1, 0, 0, 1, 'image', 150, 120, 400, 300, 1800, 1600, 400000, 'gd2', 4, 12, 1, '', '', '', 0, 'viewpage.php?page_id=7', '****', 0, 5, 6, 81, '6.01.11', 0, 'Weekly Maintance of Server and Site it will take about 5-10 min \r\nThank you for your patiance\r\n\r\nBest Regards WoWnor team'); -- -------------------------------------------------------- -- -- Table structure for table `fusion_shoutbox` -- CREATE TABLE `fusion_shoutbox` ( `shout_id` smallint(5) unsigned NOT NULL auto_increment, `shout_name` varchar(50) NOT NULL default '', `shout_message` varchar(200) NOT NULL default '', `shout_datestamp` int(10) unsigned NOT NULL default '0', `shout_ip` varchar(20) NOT NULL default '0.0.0.0', PRIMARY KEY (`shout_id`) ) ENGINE=MyISAM AUTO_INCREMENT=67 DEFAULT CHARSET=latin1 AUTO_INCREMENT=67 ; -- -- Dumping data for table `fusion_shoutbox` -- -- -------------------------------------------------------- -- -- Table structure for table `fusion_site_links` -- CREATE TABLE `fusion_site_links` ( `link_id` smallint(5) unsigned NOT NULL auto_increment, `link_name` varchar(100) NOT NULL default '', `link_url` varchar(200) NOT NULL default '', `link_visibility` tinyint(3) unsigned NOT NULL default '0', `link_position` tinyint(1) unsigned NOT NULL default '1', `link_window` tinyint(1) unsigned NOT NULL default '0', `link_order` smallint(2) unsigned NOT NULL default '0', PRIMARY KEY (`link_id`) ) ENGINE=MyISAM AUTO_INCREMENT=40 DEFAULT CHARSET=latin1 AUTO_INCREMENT=40 ; -- -- Dumping data for table `fusion_site_links` -- INSERT INTO `fusion_site_links` VALUES (1, 'News', 'index.php', 0, 1, 0, 1); INSERT INTO `fusion_site_links` VALUES (2, 'Events', 'articles.php', 103, 1, 0, 4); INSERT INTO `fusion_site_links` VALUES (3, 'Downloads', 'downloads.php', 0, 1, 0, 5); INSERT INTO `fusion_site_links` VALUES (4, 'FAQ', 'faq.php', 0, 1, 0, 6); INSERT INTO `fusion_site_links` VALUES (5, 'Forum', 'forum/', 0, 1, 0, 2); INSERT INTO `fusion_site_links` VALUES (6, 'Web Links', 'weblinks.php', 103, 1, 0, 7); INSERT INTO `fusion_site_links` VALUES (8, 'Contact Us', 'contact.php', 103, 1, 0, 10); INSERT INTO `fusion_site_links` VALUES (9, 'Screenshost', 'photogallery.php', 0, 1, 0, 11); INSERT INTO `fusion_site_links` VALUES (10, 'Search', 'search.php', 0, 1, 0, 12); INSERT INTO `fusion_site_links` VALUES (11, '---', '---', 101, 1, 0, 15); INSERT INTO `fusion_site_links` VALUES (12, 'Submit Link', 'submit.php?stype=l', 102, 1, 0, 17); INSERT INTO `fusion_site_links` VALUES (13, 'Submit News', 'submit.php?stype=n', 102, 1, 0, 18); INSERT INTO `fusion_site_links` VALUES (14, 'Submit Article', 'submit.php?stype=a', 103, 1, 0, 19); INSERT INTO `fusion_site_links` VALUES (15, 'Submit Photo', 'submit.php?stype=p', 101, 1, 0, 20); INSERT INTO `fusion_site_links` VALUES (16, 'Server Status', 'stats/stats.xml', 0, 1, 1, 3); INSERT INTO `fusion_site_links` VALUES (20, '* Game Account *', 'game_acc.php', 101, 2, 0, 16); INSERT INTO `fusion_site_links` VALUES (26, 'Mailltoall', 'infusions/pd_mailtoall/mailtoall.php', 103, 2, 0, 21); INSERT INTO `fusion_site_links` VALUES (24, 'Talent Calculator', 'viewpage.php?page_id=13', 0, 1, 0, 8); INSERT INTO `fusion_site_links` VALUES (36, 'Components', 'viewpage.php?page_id=21', 0, 1, 0, 13); INSERT INTO `fusion_site_links` VALUES (38, 'Armory', 'armory/index.php', 0, 1, 0, 14); -- -------------------------------------------------------- -- -- Table structure for table `fusion_submissions` -- CREATE TABLE `fusion_submissions` ( `submit_id` smallint(5) unsigned NOT NULL auto_increment, `submit_type` char(1) NOT NULL default '', `submit_user` smallint(5) unsigned NOT NULL default '0', `submit_datestamp` int(10) unsigned NOT NULL default '0', `submit_criteria` text NOT NULL, PRIMARY KEY (`submit_id`) ) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ; -- -- Dumping data for table `fusion_submissions` -- -- -------------------------------------------------------- -- -- Table structure for table `fusion_thread_notify` -- CREATE TABLE `fusion_thread_notify` ( `thread_id` smallint(5) unsigned NOT NULL default '0', `notify_datestamp` int(10) unsigned NOT NULL default '0', `notify_user` smallint(5) unsigned NOT NULL default '0', `notify_status` tinyint(1) unsigned NOT NULL default '1' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `fusion_thread_notify` -- -- -------------------------------------------------------- -- -- Table structure for table `fusion_threads` -- CREATE TABLE `fusion_threads` ( `forum_id` smallint(5) unsigned NOT NULL default '0', `thread_id` smallint(5) unsigned NOT NULL auto_increment, `thread_subject` varchar(100) NOT NULL default '', `thread_author` smallint(5) unsigned NOT NULL default '0', `thread_views` smallint(5) unsigned NOT NULL default '0', `thread_lastpost` int(10) unsigned NOT NULL default '0', `thread_lastuser` smallint(5) unsigned NOT NULL default '0', `thread_sticky` tinyint(1) unsigned NOT NULL default '0', `thread_locked` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`thread_id`) ) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ; -- -- Dumping data for table `fusion_threads` -- INSERT INTO `fusion_threads` VALUES (2, 15, 'test', 1, 4, 1186991134, 1, 1, 0); -- -------------------------------------------------------- -- -- Table structure for table `fusion_user_groups` -- CREATE TABLE `fusion_user_groups` ( `group_id` tinyint(3) unsigned NOT NULL auto_increment, `group_name` varchar(100) NOT NULL default '', `group_description` varchar(200) NOT NULL default '', PRIMARY KEY (`group_id`) ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; -- -- Dumping data for table `fusion_user_groups` -- INSERT INTO `fusion_user_groups` VALUES (1, 'VIP', 'Donators'); INSERT INTO `fusion_user_groups` VALUES (2, 'GM', 'Game Masters'); INSERT INTO `fusion_user_groups` VALUES (3, 'Moderators', 'People that manage diffrent cont of the site'); -- -------------------------------------------------------- -- -- Table structure for table `fusion_users` -- CREATE TABLE `fusion_users` ( `user_id` smallint(5) unsigned NOT NULL auto_increment, `user_name` varchar(30) NOT NULL default '', `user_password` varchar(32) NOT NULL default '', `user_email` varchar(100) NOT NULL default '', `user_hide_email` tinyint(1) unsigned NOT NULL default '1', `user_location` varchar(50) NOT NULL default '', `user_birthdate` date NOT NULL default '0000-00-00', `user_aim` varchar(16) NOT NULL default '', `user_icq` varchar(15) NOT NULL default '', `user_msn` varchar(100) NOT NULL default '', `user_yahoo` varchar(100) NOT NULL default '', `user_web` varchar(200) NOT NULL default '', `user_theme` varchar(100) NOT NULL default 'Default', `user_offset` char(3) NOT NULL default '0', `user_avatar` varchar(100) NOT NULL default '', `user_sig` text NOT NULL, `user_posts` smallint(5) unsigned NOT NULL default '0', `user_joined` int(10) unsigned NOT NULL default '0', `user_lastvisit` int(10) unsigned NOT NULL default '0', `user_ip` varchar(20) NOT NULL default '0.0.0.0', `user_rights` text NOT NULL, `user_groups` text NOT NULL, `user_level` tinyint(3) unsigned NOT NULL default '101', `user_status` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`user_id`) ) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ; -- -- Dumping data for table `fusion_users` -- INSERT INTO `fusion_users` VALUES (1, 'admin', '8685f7c3ab57d22e1ca3bc44ad222253', 'admin@somehost.bg', 1, '', '0000-00-00', '', '', '', '', '', 'Default', '0', '0-5-8[1].gif', '', 19, 1172231376, 1187703803, '127.0.0.1', 'A.AC.AD.B.C.CP.DB.DC.D.FQ.F.IM.I.IP.M.N.NC.P.PH.PI.PO.S.SL.S1.S2.S3.S4.S5.S6.S7.SU.UG.U.W.WC', '.2', 103, 0); -- -------------------------------------------------------- -- -- Table structure for table `fusion_vcode` -- CREATE TABLE `fusion_vcode` ( `vcode_datestamp` int(10) unsigned NOT NULL default '0', `vcode_1` varchar(5) NOT NULL default '', `vcode_2` varchar(32) NOT NULL default '' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `fusion_vcode` -- -- -------------------------------------------------------- -- -- Table structure for table `fusion_weblink_cats` -- CREATE TABLE `fusion_weblink_cats` ( `weblink_cat_id` smallint(5) unsigned NOT NULL auto_increment, `weblink_cat_name` varchar(100) NOT NULL default '', `weblink_cat_description` text NOT NULL, `weblink_cat_sorting` varchar(50) NOT NULL default 'weblink_name ASC', `weblink_cat_access` tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`weblink_cat_id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -- Dumping data for table `fusion_weblink_cats` -- INSERT INTO `fusion_weblink_cats` VALUES (1, 'Banners', 'Friends', 'weblink_id ASC', 0); -- -------------------------------------------------------- -- -- Table structure for table `fusion_weblinks` -- CREATE TABLE `fusion_weblinks` ( `weblink_id` smallint(5) unsigned NOT NULL auto_increment, `weblink_name` varchar(100) NOT NULL default '', `weblink_description` text NOT NULL, `weblink_url` varchar(200) NOT NULL default '', `weblink_cat` smallint(5) unsigned NOT NULL default '0', `weblink_datestamp` int(10) unsigned NOT NULL default '0', `weblink_count` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`weblink_id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -- Dumping data for table `fusion_weblinks` --