|
- 帖子
- 43
- 积分
- 67
- 威望
- 0
- 金币
- 22 个
- 体力
- 50
|
體育彩票 FOR DZ5.5 BIG5
#####################################
# 名稱: 體育彩票5.5 BIG5 #
# 演視: http://9966.htcfn.com/plugin.php?identifier=gym&module=gym
# 本人已測試5.5可用 #
# #
#####################################
1,數據庫升級- CREATE TABLE `cdb_gym_class` (
- `id` SMALLINT( 6 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
- `gameclass` VARCHAR( 40 ) NOT NULL ,
- PRIMARY KEY ( `id` )
- ) TYPE = MYISAM ;
- CREATE TABLE `cdb_gym_game` (
- `id` smallint(6) unsigned NOT NULL auto_increment,
- `gname` varchar(30) NOT NULL default '',
- `score1` varchar(20) NOT NULL default '',
- `score2` varchar(20) NOT NULL default '',
- `score3` varchar(20) NOT NULL default '',
- `ending` tinyint(2) NOT NULL default '0',
- `gameclass` smallint(6) unsigned NOT NULL default '0',
- `gamedate` date NOT NULL default '0000-00-00',
- `gametime` time NOT NULL default '00:00:00',
- `addtime` int(11) NOT NULL default '0',
- `info` text NOT NULL,
- `hteamrate` float NOT NULL default '0',
- `equalrate` float NOT NULL default '0',
- `vteamrate` float NOT NULL default '0',
- `score` varchar(20) NOT NULL default '',
- `duzhu` int(10) NOT NULL default '0',
- `yingli` int(8) NOT NULL default '0',
- `addend` tinyint(1) NOT NULL default '0',
- `userincome` int(10) NOT NULL default '0',
- PRIMARY KEY (`id`)
- ) TYPE=MyISAM AUTO_INCREMENT=1 ;
-
- CREATE TABLE `cdb_gym_dudan` (
- `id` SMALLINT( 6 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
- `username` VARCHAR( 15 ) NOT NULL ,
- `gameid` SMALLINT( 6 ) UNSIGNED NOT NULL ,
- `game1` SMALLINT( 2 ) UNSIGNED NOT NULL ,
- `game2` VARCHAR( 10 ) NOT NULL ,
- `duzhu1` SMALLINT( 6 ) UNSIGNED NOT NULL ,
- `duzhu2` SMALLINT( 6 ) UNSIGNED NOT NULL ,
- `duzhu3` SMALLINT( 6 ) UNSIGNED NOT NULL ,
- `addtime` INT( 11 ) NOT NULL ,
- PRIMARY KEY ( `id` )
- ) TYPE = MYISAM ;
- CREATE TABLE `cdb_gym_winnerlist` (
- `id` SMALLINT( 6 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
- `username` VARCHAR( 15 ) NOT NULL ,
- `gameid` SMALLINT( 6 ) UNSIGNED NOT NULL ,
- `gametime` DATE NOT NULL ,
- `winmoney` SMALLINT( 6 ) UNSIGNED NOT NULL ,
- PRIMARY KEY ( `id` )
- ) TYPE = MYISAM ;
- CREATE TABLE `cdb_gym_winuser` (
- `id` SMALLINT( 6 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
- `username` VARCHAR( 15 ) NOT NULL ,
- `win` SMALLINT( 6 ) UNSIGNED NOT NULL ,
- `lost` SMALLINT( 6 ) UNSIGNED NOT NULL ,
- `money` SMALLINT( 6 ) NOT NULL ,
- PRIMARY KEY ( `id` )
- ) TYPE = MYISAM ;
|
-
-
體育彩票5.5.rar (49.91 KB)
售价: 金币 5 个 [记录]
[购买]
|
