www.gusucode.com > 迪恩Kids育儿母婴商业版【整站带数据】源码程序 > 迪恩Kids育儿母婴商业版【整站带数据】/web/source/plugin/dsu_paulsign/sign_troubleshooting.inc.php

    <?php
/*
	dsu_paulsign Helper By DSU[DSU Team] 2011-06-19
*/
!defined('IN_DISCUZ') && exit('Access Denied');
!defined('IN_ADMINCP') && exit('Access Denied');
if($_G['adminid']!=='1') exit('Access Denied');
$lang = $_G['cache']['pluginlanguage_script']['dsu_paulsign'];
$num1 = C::t('#dsu_paulsign#dsu_paulsign')->checktableexist();
$num2 = C::t('#dsu_paulsign#dsu_paulsignset')->checktableexist();
$num3 = C::t('#dsu_paulsign#dsu_paulsignemot')->checktableexist();
C::t('#dsu_paulsign#dsu_paulsign')->fixlasted();
if($num1 > 0 && $num2 > 0)cpmsg("Tables are Normal!", '', 'succeed');
if($num1 <= 0){
	$sql = <<<EOF
CREATE TABLE IF NOT EXISTS `cdb_dsu_paulsign` (
  `uid` int(10) unsigned NOT NULL,
  `time` int(10) NOT NULL,
  `days` int(5) NOT NULL DEFAULT '0',
  `lasted` int(5) NOT NULL DEFAULT '0',
  `mdays` int(5) NOT NULL DEFAULT '0',
  `reward` int(12) NOT NULL DEFAULT '0',
  `lastreward` int(12) NOT NULL DEFAULT '0',
  `qdxq` varchar(5) NOT NULL,
  `todaysay` varchar(100) NOT NULL,
  PRIMARY KEY (`uid`),
  KEY `time` (`time`)
) ENGINE=MyISAM;
EOF;
	runquery($sql);
}
if($num2 <= 0){
	$sql = <<<EOF
CREATE TABLE IF NOT EXISTS `cdb_dsu_paulsignset` (
  `id` int(10) unsigned NOT NULL,
  `todayq` int(10) NOT NULL DEFAULT '0',
  `yesterdayq` int(10) NOT NULL DEFAULT '0',
  `highestq` int(10) NOT NULL DEFAULT '0',
  `qdtidnumber` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM;
INSERT INTO `cdb_dsu_paulsignset` (id, todayq, yesterdayq, highestq, qdtidnumber) VALUES ('1', '0', '0', '0', '0');
EOF;
	runquery($sql);
}
if($num3 <= 0){
	$sql = <<<EOF
CREATE TABLE IF NOT EXISTS `cdb_dsu_paulsignemot` (
  `id` int(5) unsigned NOT NULL AUTO_INCREMENT,
  `displayorder` tinyint(3) NOT NULL DEFAULT '0',
  `qdxq` varchar(5) NOT NULL,
  `count` int(6) NOT NULL DEFAULT '0',
  `name` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM;
INSERT INTO `cdb_dsu_paulsignemot` (`id`, `displayorder`, `qdxq`, `count`, `name`) VALUES
(1, 1, 'kx', '0', '$lang[mb_qb1]'),
(2, 2, 'ng', '0', '$lang[mb_qb2]'),
(3, 3, 'ym', '0', '$lang[mb_qb3]'),
(4, 4, 'wl', '0', '$lang[mb_qb4]'),
(5, 5, 'nu', '0', '$lang[mb_qb5]'),
(6, 6, 'ch', '0', '$lang[mb_qb6]'),
(7, 7, 'fd', '0', '$lang[mb_qb7]'),
(8, 8, 'yl', '0', '$lang[mb_qb8]'),
(9, 9, 'shuai', '0', '$lang[mb_qb9]');
EOF;
	runquery($sql);
}
cpmsg("Tables Fix Successfully!", '', 'succeed');
?>