MySQL Data Transfer
Source Host: localhost
Source Database: mcms
Target Host: localhost
Target Database: mcms
Date: 25.03.2009 10:15:32
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for acc2char
-- ----------------------------
DROP TABLE IF EXISTS `acc2char`;
CREATE TABLE `acc2char` (
  `account` int(10) NOT NULL DEFAULT '0',
  `character` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`account`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for admins
-- ----------------------------
DROP TABLE IF EXISTS `admins`;
CREATE TABLE `admins` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` text,
  `im` text,
  `im_type` int(1) DEFAULT '1',
  `type` int(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for banner
-- ----------------------------
DROP TABLE IF EXISTS `banner`;
CREATE TABLE `banner` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `text` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for bugtraker
-- ----------------------------
DROP TABLE IF EXISTS `bugtraker`;
CREATE TABLE `bugtraker` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `title` text,
  `text` text,
  `razdel` int(2) DEFAULT NULL,
  `autor` text,
  `data` text,
  `status` int(2) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for comments
-- ----------------------------
DROP TABLE IF EXISTS `comments`;
CREATE TABLE `comments` (
  `idnews` int(10) NOT NULL,
  `idcomments` int(10) NOT NULL AUTO_INCREMENT,
  `text` text,
  `autor` int(10) DEFAULT NULL,
  PRIMARY KEY (`idcomments`)
) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for content
-- ----------------------------
DROP TABLE IF EXISTS `content`;
CREATE TABLE `content` (
  `id` int(10) NOT NULL DEFAULT '0',
  `title` varchar(255) DEFAULT NULL,
  `text` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for counter
-- ----------------------------
DROP TABLE IF EXISTS `counter`;
CREATE TABLE `counter` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `text` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for files
-- ----------------------------
DROP TABLE IF EXISTS `files`;
CREATE TABLE `files` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `url` text,
  `name` text,
  `type` int(3) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for menu
-- ----------------------------
DROP TABLE IF EXISTS `menu`;
CREATE TABLE `menu` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) DEFAULT NULL,
  `description` text,
  `url` text,
  `rotation` int(3) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for news
-- ----------------------------
DROP TABLE IF EXISTS `news`;
CREATE TABLE `news` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` char(200) NOT NULL,
  `text` text NOT NULL,
  `fulltext` text,
  `autor` int(10) DEFAULT NULL,
  `date` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for vote
-- ----------------------------
DROP TABLE IF EXISTS `vote`;
CREATE TABLE `vote` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `text` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records
-- ----------------------------
INSERT INTO `acc2char` VALUES ('5', '3');
INSERT INTO `acc2char` VALUES ('8', '2');
INSERT INTO `acc2char` VALUES ('24', '351');
INSERT INTO `acc2char` VALUES ('28', '11');
INSERT INTO `admins` VALUES ('1', 'Admins', '9299431', '1', '1');
INSERT INTO `admins` VALUES ('2', 'GMs', 'XXX', '2', '2');
INSERT INTO `admins` VALUES ('3', 'Moderators', 'XXX', '3', '3');
INSERT INTO `admins` VALUES ('4', 'Donators', 'XXX', '4', '4');
INSERT INTO `banner` VALUES ('1', 'Przykładowa reklama banner.');
INSERT INTO `counter` VALUES ('1', 'Пробная кнопка счетчика');
INSERT INTO `files` VALUES ('1', 'http://depositfiles.com/files/2ywva1v37', 'Универсальный довнлоадер клиента', '1');
INSERT INTO `files` VALUES ('2', 'http://depositfiles.com/files/viuxfug24', 'WoW-3.0.3.9183-to-3.0.8.9464-ruRU-patch', '2');
INSERT INTO `files` VALUES ('3', 'http://depositfiles.com/files/wdk71nzid', 'WoW-3.0.2.9056-to-3.0.3.9183-ruRU-patch', '2');
INSERT INTO `files` VALUES ('4', 'http://depositfiles.com/files/0cquddylm', 'WoW-3.0.8.9506-to-3.0.9.9551-ruRU-patch', '2');
INSERT INTO `files` VALUES ('5', 'http://depositfiles.com/files/22u7ashxt', 'WoW-3.0.8.9464-to-3.0.8.9506-ruRU-patch.', '2');
INSERT INTO `menu` VALUES ('1', 'Start', 'Strona główna', 'index.html', '1');
INSERT INTO `menu` VALUES ('2', 'Zarejestruj się', null, 'registration.html', '1');
INSERT INTO `menu` VALUES ('3', 'Jak zagrać?', null, 'howtoplay.html', '1');
INSERT INTO `menu` VALUES ('4', 'Statystyki', null, 'stats.html', '1');
INSERT INTO `menu` VALUES ('5', 'Gracze online', null, 'online.html', '1');
INSERT INTO `menu` VALUES ('6', 'Gracze na mapie', null, 'maps/', '1');
INSERT INTO `menu` VALUES ('7', 'Forum', null, 'forum/', '1');
INSERT INTO `menu` VALUES ('8', 'Armory', null, 'armory.html', '1');
INSERT INTO `menu` VALUES ('9', 'Aktualności', null, 'index.html', '2');
INSERT INTO `menu` VALUES ('10', 'Zarejestruj się', null, 'registration.html', '2');
INSERT INTO `menu` VALUES ('11', 'Jak grać?', null, 'howtoplay.html', '2');
INSERT INTO `menu` VALUES ('12', 'Gracze online', null, 'online.html', '2');
INSERT INTO `menu` VALUES ('13', 'Pliki', null, 'files.html', '1');
INSERT INTO `menu` VALUES ('14', 'TOP10', null, 'top10.html', '1');
INSERT INTO `menu` VALUES ('15', 'Bugtracker', null, 'bugtraker.html', '1');
INSERT INTO `news` VALUES ('10', 'Witamy na Legend', '<center><B>Witaj</B></center><br />  TEkst <u>вы</u> TEkst<img src=images/smile/ad.gif>', '<center><B></B></center><br /> .<img src=images/smile/ad.gif>', '5', '23.03.2009');
INSERT INTO `vote` VALUES ('1', 'Głosuj!)');

<?php
/********************************************/
/*              GetMaNGOS CMS               */
/* Ńčńňĺěŕ óďđŕâëĺíč˙ ęîíňĺíňîě äë˙ MaNGOS  */
/*            http://getmcms.ru             */
/*                (c) 2009                  */
/********************************************/
if(!defined('GETMANGOSCMS'))
{
  die("Äîńňóď çŕďđĺůĺí!");
}
//////////////////////////////////////////////
///// Íŕńňđîéęč ďîäęëţ÷ĺíč˙ ę áŕçĺ äŕííűő ////
//////////////////////////////////////////////
$database = array (
    'lDB'            => 'mysql://mangos:mangos@localhost:3306/mangos-logon',            // Íŕńňđîéęč ďîäęëţ÷ĺíč˙ ę logon-database
    'cDB'            => 'mysql://mangos:mangos@localhost:3306/characters-blizzlike',        // Íŕńňđîéęč ďîäęëţ÷ĺíč˙ ę characters-database
    'wDB'            => 'mysql://mangos:mangos@localhost:3306/mangos-world',            // Íŕńňđîéęč ďîäęëţ÷ĺíč˙ ę world-database
    'sDB'            => 'mysql://mangos:mangos@localhost:3306/mcms',                // Íŕńňđîéęč ďîäęëţ÷ĺíč˙ ę site-database
    'db_encoding'        => 'cp1251'                                // Ęîäčđîâęŕ áŕç äŕííűő
);

/////////////////////////////////////////////
///////////// Íŕńňđîéęč ńŕéňŕ ///////////////
/////////////////////////////////////////////
// Îáůčĺ íŕńňđîéęč ńŕéňŕ
$site = array(
    'name'            => 'GetMaNGOS CMS',         // Íŕçâŕíčĺ ńŕéňŕ
    'sitedir'        => '/MCMS/',            // Ŕäđĺń äî ńŕéňŕ îňíîńčňĺëüíî őîńňŕ
    'gameversion'        => '3.0.8',            // Âĺđńč˙ ęëčĺíňŕ
    'realmlist'        => 'localhost',            // Ŕäđĺń ńĺđâĺđŕ äë˙ đĺŕëěëčńňŕ
    'template'        => 'classic',            // Ňĺěŕ
    'servername'        => 'MaNGOS',            // Íŕçâŕíčĺ đĺŕëěŕ
    'ip_world'        => '127.0.0.1',            // Čď âîđëä ńĺđâĺđŕ
    'port_world'        => '8085',            // Ďîđň âîđëä ńĺđâĺđŕ
    'ip_logon'        => '127.0.0.1',            // Čď ëîăčí ńĺđâĺđŕ
    'port_logon'        => '3724',            // Ďîđň ëîăčí ńĺđâĺđŕ
    'language'        => 'Đóńńęčé',            // ßçűę čăđîâîé
    'buildClient'        => 9183,             // Áčëä ęëčĺíňŕ (äë˙ ěóëüňčâĺđńíîńňč ńŕéňŕ) | 8606 -> 2.4.3 | 9183 -> 3.0.3-3.0.9 | 9464, 9506 -> 3.0.8 | 9551 -> 3.0.9 |
);

// Íŕńňđîéęč âęëţ÷ĺíč˙ č îňęëţ÷ĺíč˙ đŕçëč÷íűő ěîäóëĺé
$nasite = array(
    'vote'            => '0',        // Đŕçëč÷íűĺ îďđîńű (ěîäóëü ďîęŕ ÷ňî íĺ íŕďčńŕí)
    'vote_server'        => '1',        // Ěîäóëü ăîëîńîâŕíč˙ çŕ ńĺđâĺđ íŕ ŇÎĎŕő
    'counter'        => '1',        // Ěîäóëü đŕçëč÷íűő ń÷ĺň÷čęîâ(ňčďŕ Ěŕčëŕ č ň.ä.)
    'banner'        => '1',        // Ěîäóëü đĺęëŕěíűő áŕííĺđîâ
    'login'            => '1',        // Ďŕíĺëü âőîäŕ â ëč÷íűé ęŕáčíĺň
    'admins'        => '1',        // Ěîäóëü "Íŕřŕ ęîěŕíäŕ"
);

// Đĺéňű ńĺđâĺđŕ
$rates = array(
    'xp'            => 'x1',    // Îďűň
    'drop'            => 'x1',    // Ëóň
    'quest'            => 'x1',    // Ęâĺńňű
    'party'            => 'x1',    // Ďŕňč îďűň
);

// Íŕńňđîéęč öâĺňîâ ţçĺđáŕđŕ
$options =array(
    'ColorsA' => array(
        'text_color_1'    => 'FFFF00',
        'text_color_2'     => 'FFFFFF',
        'color_1'         => '000000',
        'color_2'         => '006BFF'
    ),
    'ColorsH' => array(
        'text_color_1'    => 'FFFF00',
        'text_color_2'     => 'FFFFFF',
        'color_1'         => '000000',
        'color_2'         => 'FF0000'
    ),
    'ColorsGM' => array(
        'text_color_1'    => 'FFFF00',
        'text_color_2'     => 'FFFFFF',
        'color_1'         => '000000',
        'color_2'         => '00CC66'
    )
);
/////////////////////////////////////////////
/////////////////////////////////////////////
/////////////////////////////////////////////
?>