http://wapik.110mb.com/game.zip
//
//
Движок Игры !!!!
НЕ забываем НАЖАТЬ СПАСИБО !!!!!!
Дамб БД
# RST MySQL tools
# Home page: http://rst.void.ru
#
# Host settings:
# mag.su (80.93.56.106)
# MySQL version: (3.23.58)
# Date: March 30, 2006, 8:22 pm
# dump db "mag_main" table "forum"
#_________________________________________________________
DROP TABLE IF EXISTS `forum`;
CREATE TABLE `forum` (
`num` int(11) NOT NULL auto_increment,
`messtime` varchar(14) NOT NULL default '',
`messtype` tinyint(4) NOT NULL default '0',
`fromnick` varchar(12) NOT NULL default '',
`tonick` varchar(12) NOT NULL default '',
`messtext` text NOT NULL,
PRIMARY KEY (`num`),
KEY `tonick` (`tonick`,`num`),
KEY `key2` (`tonick`,`messtype`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `letters`;
CREATE TABLE `letters` (
`num` int(11) NOT NULL auto_increment,
`messtime` varchar(14) NOT NULL default '',
`messtype` tinyint(4) default NULL,
`fromid` int(11) NOT NULL default '0',
`toid` int(11) NOT NULL default '0',
`fromnick` text,
`tonick` text,
`messtext` text,
`atts` text NOT NULL,
PRIMARY KEY (`num`),
KEY `messtime` (`messtime`),
KEY `toid` (`toid`,`num`),
KEY `fromid` (`fromid`,`num`),
KEY `toidtype` (`toid`,`messtype`),
KEY `tonick` (`tonick`(11)),
KEY `messtype` (`messtype`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `messages`;
CREATE TABLE `messages` (
`num` int(11) NOT NULL auto_increment,
`messtime` char(14) NOT NULL default '',
`messtype` tinyint(3) unsigned NOT NULL default '0',
`fromid` int(10) unsigned NOT NULL default '0',
`toid` int(10) unsigned NOT NULL default '0',
`fromnick` char(40) NOT NULL default '',
`tonick` char(40) NOT NULL default '',
`messtext` char(255) NOT NULL default '',
`room` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`num`),
KEY `messtime` (`messtime`),
KEY `room` (`room`),
KEY `messtype` (`messtype`),
KEY `toid` (`toid`),
KEY `fromid` (`fromid`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `online`;
CREATE TABLE `online` (
`ion` char(12) binary NOT NULL default '',
`lasttime` int(10) unsigned NOT NULL default '0',
`logtime` int(10) unsigned NOT NULL default '0',
`nick` char(12) NOT NULL default '',
`pass` char(12) binary NOT NULL default '',
`id` char(32) binary NOT NULL default '',
`status` tinyint(3) unsigned NOT NULL default '0',
`sent` int(10) unsigned NOT NULL default '0',
`lastsent` int(10) unsigned NOT NULL default '0',
`room` int(10) unsigned NOT NULL default '0',
`messlim` smallint(5) unsigned NOT NULL default '0',
`refrint` smallint(5) unsigned NOT NULL default '0',
`lastmess` char(255) NOT NULL default '',
`ignor` char(255) NOT NULL default '',
`ignorposts` int(10) unsigned NOT NULL default '0',
`friends` char(255) NOT NULL default '',
`usetrans` tinyint(3) unsigned NOT NULL default '0',
`rusnick` tinyint(3) unsigned NOT NULL default '0',
`showpic` tinyint(3) unsigned NOT NULL default '0',
`width` tinyint(3) unsigned NOT NULL default '0',
`image` tinyint(3) unsigned NOT NULL default '0',
UNIQUE KEY `ion` (`ion`),
UNIQUE KEY `nick` (`nick`),
KEY `room` (`room`)
) TYPE=HEAP MAX_ROWS=400;
DROP TABLE IF EXISTS `partners`;
CREATE TABLE `partners` (
`num` int(11) NOT NULL auto_increment,
`time` int(10) unsigned NOT NULL default '0',
`nick` text NOT NULL,
`pi` smallint(5) unsigned NOT NULL default '0',
`tarif` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`num`),
KEY `time` (`time`),
KEY `pi` (`pi`,`time`),
KEY `tarif` (`tarif`,`time`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `posts`;
CREATE TABLE `posts` (
`num` int(10) unsigned NOT NULL default '0',
`messtime` int(10) unsigned NOT NULL default '0',
`messtype` tinyint(3) unsigned NOT NULL default '0',
`fromnick` char(12) NOT NULL default '',
`fromrus` tinyint(3) unsigned NOT NULL default '0',
`sent` int(10) unsigned NOT NULL default '0',
`tonick` char(12) NOT NULL default '',
`torus` tinyint(3) unsigned NOT NULL default '0',
`messtext` char(255) NOT NULL default '',
`room` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`num`),
KEY `room` (`room`)
) TYPE=HEAP MAX_ROWS=1400;
DROP TABLE IF EXISTS `privats`;
CREATE TABLE `privats` (
`room` int(10) unsigned NOT NULL default '0',
`pass` char(20) binary NOT NULL default '',
`nick` char(12) NOT NULL default '',
`closetime` int(10) unsigned NOT NULL default '0',
UNIQUE KEY `room` (`room`),
UNIQUE KEY `pass` (`pass`),
UNIQUE KEY `nick` (`nick`)
) TYPE=HEAP MAX_ROWS=100;
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
`ind` int(11) NOT NULL auto_increment,
`nick` text,
`pass` blob,
`email` text,
`status` tinyint(4) default NULL,
`sent` int(11) default NULL,
`lastrefr` varchar(14) NOT NULL default '',
`regtime` varchar(14) NOT NULL default '',
`logtime` varchar(14) NOT NULL default '',
`refrint` smallint(6) default NULL,
`messlim` smallint(6) default NULL,
`mode` tinyint(4) default NULL,
`ignor` text,
`favor` text,
`profile` text,
`friends` text,
`mailtime` varchar(14) NOT NULL default '',
`subjectlen` smallint(6) NOT NULL default '0',
`inpage` smallint(6) NOT NULL default '0',
`outpage` smallint(6) NOT NULL default '0',
`redirto` text,
`redirfrom` text,
`votetime` int(10) unsigned NOT NULL default '0',
`voted` int(10) unsigned NOT NULL default '0',
`ignorposts` int(10) unsigned NOT NULL default '0',
`names` text,
`vals` text,
`gametime` int(10) unsigned NOT NULL default '0',
`paytime` int(10) unsigned NOT NULL default '0',
`pi` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`ind`),
KEY `nick` (`nick`(10))
) TYPE=MyISAM;
DROP TABLE IF EXISTS `wapchat`;
CREATE TABLE `wapchat` (
`id` int(11) NOT NULL auto_increment,
`mylogontime` varchar(14) NOT NULL default '',
`mynick` text,
`mymess` text,
`messtime` varchar(14) NOT NULL default '',
`atts` text,
`newfld` text NOT NULL,
PRIMARY KEY (`id`),
KEY `messtime` (`messtime`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `www`;
CREATE TABLE `www` (
`id` int(11) NOT NULL auto_increment,
`time` int(10) unsigned NOT NULL default '0',
`status` tinyint(3) unsigned NOT NULL default '0',
`prev` int(11) NOT NULL default '0',
`url` text NOT NULL,
`title` text NOT NULL,
`options` text NOT NULL,
`buffer` mediumtext NOT NULL,
PRIMARY KEY (`id`),
KEY `time` (`time`),
KEY `STATUS` (`status`)
) TYPE=MyISAM;
//
//
Движок Игры !!!!
НЕ забываем НАЖАТЬ СПАСИБО !!!!!!
Дамб БД
# RST MySQL tools
# Home page: http://rst.void.ru
#
# Host settings:
# mag.su (80.93.56.106)
# MySQL version: (3.23.58)
# Date: March 30, 2006, 8:22 pm
# dump db "mag_main" table "forum"
#_________________________________________________________
DROP TABLE IF EXISTS `forum`;
CREATE TABLE `forum` (
`num` int(11) NOT NULL auto_increment,
`messtime` varchar(14) NOT NULL default '',
`messtype` tinyint(4) NOT NULL default '0',
`fromnick` varchar(12) NOT NULL default '',
`tonick` varchar(12) NOT NULL default '',
`messtext` text NOT NULL,
PRIMARY KEY (`num`),
KEY `tonick` (`tonick`,`num`),
KEY `key2` (`tonick`,`messtype`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `letters`;
CREATE TABLE `letters` (
`num` int(11) NOT NULL auto_increment,
`messtime` varchar(14) NOT NULL default '',
`messtype` tinyint(4) default NULL,
`fromid` int(11) NOT NULL default '0',
`toid` int(11) NOT NULL default '0',
`fromnick` text,
`tonick` text,
`messtext` text,
`atts` text NOT NULL,
PRIMARY KEY (`num`),
KEY `messtime` (`messtime`),
KEY `toid` (`toid`,`num`),
KEY `fromid` (`fromid`,`num`),
KEY `toidtype` (`toid`,`messtype`),
KEY `tonick` (`tonick`(11)),
KEY `messtype` (`messtype`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `messages`;
CREATE TABLE `messages` (
`num` int(11) NOT NULL auto_increment,
`messtime` char(14) NOT NULL default '',
`messtype` tinyint(3) unsigned NOT NULL default '0',
`fromid` int(10) unsigned NOT NULL default '0',
`toid` int(10) unsigned NOT NULL default '0',
`fromnick` char(40) NOT NULL default '',
`tonick` char(40) NOT NULL default '',
`messtext` char(255) NOT NULL default '',
`room` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`num`),
KEY `messtime` (`messtime`),
KEY `room` (`room`),
KEY `messtype` (`messtype`),
KEY `toid` (`toid`),
KEY `fromid` (`fromid`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `online`;
CREATE TABLE `online` (
`ion` char(12) binary NOT NULL default '',
`lasttime` int(10) unsigned NOT NULL default '0',
`logtime` int(10) unsigned NOT NULL default '0',
`nick` char(12) NOT NULL default '',
`pass` char(12) binary NOT NULL default '',
`id` char(32) binary NOT NULL default '',
`status` tinyint(3) unsigned NOT NULL default '0',
`sent` int(10) unsigned NOT NULL default '0',
`lastsent` int(10) unsigned NOT NULL default '0',
`room` int(10) unsigned NOT NULL default '0',
`messlim` smallint(5) unsigned NOT NULL default '0',
`refrint` smallint(5) unsigned NOT NULL default '0',
`lastmess` char(255) NOT NULL default '',
`ignor` char(255) NOT NULL default '',
`ignorposts` int(10) unsigned NOT NULL default '0',
`friends` char(255) NOT NULL default '',
`usetrans` tinyint(3) unsigned NOT NULL default '0',
`rusnick` tinyint(3) unsigned NOT NULL default '0',
`showpic` tinyint(3) unsigned NOT NULL default '0',
`width` tinyint(3) unsigned NOT NULL default '0',
`image` tinyint(3) unsigned NOT NULL default '0',
UNIQUE KEY `ion` (`ion`),
UNIQUE KEY `nick` (`nick`),
KEY `room` (`room`)
) TYPE=HEAP MAX_ROWS=400;
DROP TABLE IF EXISTS `partners`;
CREATE TABLE `partners` (
`num` int(11) NOT NULL auto_increment,
`time` int(10) unsigned NOT NULL default '0',
`nick` text NOT NULL,
`pi` smallint(5) unsigned NOT NULL default '0',
`tarif` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`num`),
KEY `time` (`time`),
KEY `pi` (`pi`,`time`),
KEY `tarif` (`tarif`,`time`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `posts`;
CREATE TABLE `posts` (
`num` int(10) unsigned NOT NULL default '0',
`messtime` int(10) unsigned NOT NULL default '0',
`messtype` tinyint(3) unsigned NOT NULL default '0',
`fromnick` char(12) NOT NULL default '',
`fromrus` tinyint(3) unsigned NOT NULL default '0',
`sent` int(10) unsigned NOT NULL default '0',
`tonick` char(12) NOT NULL default '',
`torus` tinyint(3) unsigned NOT NULL default '0',
`messtext` char(255) NOT NULL default '',
`room` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`num`),
KEY `room` (`room`)
) TYPE=HEAP MAX_ROWS=1400;
DROP TABLE IF EXISTS `privats`;
CREATE TABLE `privats` (
`room` int(10) unsigned NOT NULL default '0',
`pass` char(20) binary NOT NULL default '',
`nick` char(12) NOT NULL default '',
`closetime` int(10) unsigned NOT NULL default '0',
UNIQUE KEY `room` (`room`),
UNIQUE KEY `pass` (`pass`),
UNIQUE KEY `nick` (`nick`)
) TYPE=HEAP MAX_ROWS=100;
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
`ind` int(11) NOT NULL auto_increment,
`nick` text,
`pass` blob,
`email` text,
`status` tinyint(4) default NULL,
`sent` int(11) default NULL,
`lastrefr` varchar(14) NOT NULL default '',
`regtime` varchar(14) NOT NULL default '',
`logtime` varchar(14) NOT NULL default '',
`refrint` smallint(6) default NULL,
`messlim` smallint(6) default NULL,
`mode` tinyint(4) default NULL,
`ignor` text,
`favor` text,
`profile` text,
`friends` text,
`mailtime` varchar(14) NOT NULL default '',
`subjectlen` smallint(6) NOT NULL default '0',
`inpage` smallint(6) NOT NULL default '0',
`outpage` smallint(6) NOT NULL default '0',
`redirto` text,
`redirfrom` text,
`votetime` int(10) unsigned NOT NULL default '0',
`voted` int(10) unsigned NOT NULL default '0',
`ignorposts` int(10) unsigned NOT NULL default '0',
`names` text,
`vals` text,
`gametime` int(10) unsigned NOT NULL default '0',
`paytime` int(10) unsigned NOT NULL default '0',
`pi` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`ind`),
KEY `nick` (`nick`(10))
) TYPE=MyISAM;
DROP TABLE IF EXISTS `wapchat`;
CREATE TABLE `wapchat` (
`id` int(11) NOT NULL auto_increment,
`mylogontime` varchar(14) NOT NULL default '',
`mynick` text,
`mymess` text,
`messtime` varchar(14) NOT NULL default '',
`atts` text,
`newfld` text NOT NULL,
PRIMARY KEY (`id`),
KEY `messtime` (`messtime`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `www`;
CREATE TABLE `www` (
`id` int(11) NOT NULL auto_increment,
`time` int(10) unsigned NOT NULL default '0',
`status` tinyint(3) unsigned NOT NULL default '0',
`prev` int(11) NOT NULL default '0',
`url` text NOT NULL,
`title` text NOT NULL,
`options` text NOT NULL,
`buffer` mediumtext NOT NULL,
PRIMARY KEY (`id`),
KEY `time` (`time`),
KEY `STATUS` (`status`)
) TYPE=MyISAM;