验证中...
Languages: PHP
Categories: Web开发技术
Latest update 2018-12-09 10:32
发卡网
Raw Copy
发卡网核心代码
360_safe3.php
Raw Copy
<?php
//Code By Safe3
function customError($errno, $errstr, $errfile, $errline)
{
echo "<b>Error number:</b> [$errno],error on line $errline in $errfile<br />";
die();
}
set_error_handler("customError",E_ERROR);
$getfilter="'|(and|or)\\b.+?(>|<|=|in|like)|\\/\\*.+?\\*\\/|<\\s*script\\b|\\bEXEC\\b|UNION.+?SELECT|UPDATE.+?SET|INSERT\\s+INTO.+?VALUES|(SELECT|DELETE).+?FROM|(CREATE|ALTER|DROP|TRUNCATE)\\s+(TABLE|DATABASE)";
$postfilter="\\b(and|or)\\b.{1,6}?(=|>|<|\\bin\\b|\\blike\\b)|\\/\\*.+?\\*\\/|<\\s*script\\b|\\bEXEC\\b|UNION.+?SELECT|UPDATE.+?SET|INSERT\\s+INTO.+?VALUES|(SELECT|DELETE).+?FROM|(CREATE|ALTER|DROP|TRUNCATE)\\s+(TABLE|DATABASE)";
$cookiefilter="\\b(and|or)\\b.{1,6}?(=|>|<|\\bin\\b|\\blike\\b)|\\/\\*.+?\\*\\/|<\\s*script\\b|\\bEXEC\\b|UNION.+?SELECT|UPDATE.+?SET|INSERT\\s+INTO.+?VALUES|(SELECT|DELETE).+?FROM|(CREATE|ALTER|DROP|TRUNCATE)\\s+(TABLE|DATABASE)";
function StopAttack($StrFiltKey,$StrFiltValue,$ArrFiltReq){
if(is_array($StrFiltValue))
{
$StrFiltValue=implode($StrFiltValue);
}
if (preg_match("/".$ArrFiltReq."/is",$StrFiltValue)==1){
//slog("<br><br>操作IP: ".$_SERVER["REMOTE_ADDR"]."<br>操作时间: ".strftime("%Y-%m-%d %H:%M:%S")."<br>操作页面:".$_SERVER["PHP_SELF"]."<br>提交方式: ".$_SERVER["REQUEST_METHOD"]."<br>提交参数: ".$StrFiltKey."<br>提交数据: ".$StrFiltValue);
print "360websec notice:Illegal operation!";
exit();
}
}
//$ArrPGC=array_merge($_GET,$_POST,$_COOKIE);
foreach($_GET as $key=>$value){
StopAttack($key,$value,$getfilter);
}
foreach($_POST as $key=>$value){
StopAttack($key,$value,$postfilter);
}
foreach($_COOKIE as $key=>$value){
StopAttack($key,$value,$cookiefilter);
}
if (file_exists('update360.php')) {
echo "请重命名文件update360.php,防止黑客利用<br/>";
die();
}
function slog($logs)
{
$toppath=$_SERVER["DOCUMENT_ROOT"]."/log.htm";
$Ts=fopen($toppath,"a+");
fputs($Ts,$logs."\r\n");
fclose($Ts);
}
?>
jiangsutianqingbeiyong.php
Raw Copy
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419
<?php
ini_set('display_errors', false);
define('WY_ROOT',dirname(__FILE__));
header('Content-type:text/html;charset=utf-8');
require_once WY_ROOT.'/includes/libs/Functions.php';
require_once WY_ROOT.'/includes/libs/Mysql.php';
require_once WY_ROOT.'/includes/libs/Cache.php';
$title='江苏天擎科技PHP自动发卡程序 Ver8.9(企业版) - 安装程序(www.304ka.com)(www.yc88.net)';
$action=_G('action');
if($action=='install'){
$dbserver=$_POST['dbserver'];
$dbport=$_POST['dbport'];
$dbuser=$_POST['dbuser'];
$dbpass=$_POST['dbpass'];
$dbname=$_POST['dbname'];
$dbprefix=$_POST['dbprefix'];
$username=$_POST['username'];
$userpass=$_POST['userpass'];
$userpass1=$_POST['userpass1'];
$token=getRandomString(32);
if($dbserver=='' || $dbport=='' || $dbuser=='' || $dbprefix=='' || $username=='' || $userpass=='' || $userpass1=='') msgbox('表单数据请填写完整!');
//if(!preg_match('/^((1?\d?\d|(2([0-4]\d|5[0-5])))\.){3}(1?\d?\d|(2([0-4]\d|5[0-5])))$/',$dbserver)) msgbox('数据库服务器IP格式错误!');
if(!preg_match('/^([0-9]+)$/',$dbport)) msgbox('数据库端口格式错误!');
if(!preg_match('/^([a-zA-Z]+)(\_)$/',$dbprefix)) msgbox('数据库表前缀格式错误!');
if(strlen($username)<5 || strlen($username)>20) msgbox('登陆账号长度在5-20个字符之间!');
if(strlen($userpass)<6 || strlen($userpass)>20) msgbox('登陆密码长度在6-20个字符之间!');
if($userpass!=$userpass1) msgbox('两次输入的密码不匹配,请重新输入!');
define('DBSERVER',$dbserver);
define('DBPORT',$dbport);
define('DBUSER',$dbuser);
define('DBPASS',$dbpass);
define('DBNAME',$dbname);
define('DB_PREFIX',$dbprefix);
define('WY_SQL_LOG',false);
define('WY_CACHE_TOKEN',$token);
$db=mysql::getInstance();
$res=$db->query("SHOW TABLES LIKE '%".DB_PREFIX."config%'");
if($res){
if($db->num_rows($res)==1) msgbox('您已经安装过本程序,如果需要重新安装,请先删除数据库!再执行安装!');
}
if(!is_writable( WY_ROOT.'/a8tgconfig/config.php')) msgbox('配置文件(a8tgconfig/config.php)不可写。如果您使用的是Unix/Linux主机,请修改该文件的权限为777。如果您使用的是Windows主机,请联系管理员,将此文件设为everyone可写');
if(!is_writable(WY_ROOT.'/cache')) msgbox('cache不可写。如果您使用的是Unix/Linux主机,请修改缓存目录 (cache) 下所有文件的权限为777。如果您使用的是Windows主机,请联系管理员,将该目录下所有文件设为everyone可写');
$config = "<?php
if(!defined('WY_ROOT')) exit;
//数据据服务器
define('DBSERVER','$dbserver');
//数据库端口
define('DBPORT','$dbport');
//数据库访问用户
define('DBUSER','$dbuser');
//数据库访问用户密码
define('DBPASS','$dbpass');
// 数据库名称
define('DBNAME','$dbname');
//数据库表前缀
define('DB_PREFIX','$dbprefix');
//是否开启SQL日志记录,WY_SQL_LOG=true开启,WY_SQL_LOG=false关闭,默认false
define('WY_SQL_LOG',false);
//cache token
define('WY_CACHE_TOKEN','$token');
?>";
$result='';
$fp = @fopen(WY_ROOT.'/a8tgconfig/config.php', 'w');
$fw = @fwrite($fp, $config);
if (!$fw)
{
msgbox('配置文件(a8tgconfig/config.php)不可写。如果您使用的是Linux主机,请修改该文件的权限为777。如果您使用的是Windows主机,请联系管理员,将此文件设为everyone可写!');
}else{
$result.="配置文件修改成功<br />";
}
fclose($fp);
$siteurl=_S('SERVER_NAME');
$sql="-- ----------------------------
-- Table structure for `{$dbprefix}accessprovider`
-- ----------------------------
DROP TABLE IF EXISTS `{$dbprefix}accessprovider`;
CREATE TABLE `{$dbprefix}accessprovider` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`email` varchar(50) NOT NULL DEFAULT '',
`accessID` varchar(50) NOT NULL DEFAULT '',
`accessKey` varchar(120) NOT NULL DEFAULT '',
`accessType` varchar(10) NOT NULL DEFAULT '',
`accessName` varchar(100) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of {$dbprefix}accessprovider
-- ----------------------------
INSERT INTO `{$dbprefix}accessprovider` VALUES ('13', '', '你的ID', '你的密钥', 'a8tg', '永纯支付接口www.yc88.net');
INSERT INTO `{$dbprefix}accessprovider` VALUES ('16', '支付宝邮箱', '支付宝ID', '支付宝MD5', 'alipay', '支付宝接口');
INSERT INTO `{$dbprefix}accessprovider` VALUES ('17', '', '财付通ID', '财付通密钥', 'tenpay', '财付通');
INSERT INTO `{$dbprefix}accessprovider` VALUES ('27', '', '源码里修改', '源码里修改', 'qqcode', '微信公众手机');
INSERT INTO `{$dbprefix}accessprovider` VALUES ('22', '手机支付宝邮箱', '手机支付宝ID', '手机支付宝密钥', 'altwap', '手机支付宝');
INSERT INTO `{$dbprefix}accessprovider` VALUES ('24', '', '你的ID', '你的密钥', 'yc88', '永纯支付二维码(www.yc88.net)');
-- ----------------------------
-- Table structure for `{$dbprefix}admin`
-- ----------------------------
DROP TABLE IF EXISTS `{$dbprefix}admin`;
CREATE TABLE `{$dbprefix}admin` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`utype` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '1 administrator 2 users',
`username` varchar(20) NOT NULL,
`userpass` varchar(32) NOT NULL,
`is_safe` tinyint(1) unsigned NOT NULL DEFAULT '0',
`userkey` varchar(32) NOT NULL DEFAULT '',
`is_verifyip` tinyint(1) unsigned NOT NULL DEFAULT '0',
`verifyip` varchar(200) NOT NULL DEFAULT '',
`adminlimit` varchar(500) NOT NULL DEFAULT '',
`is_state` tinyint(1) unsigned NOT NULL DEFAULT '0',
`addtime` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of {$dbprefix}admin
-- ----------------------------
INSERT INTO `{$dbprefix}admin` VALUES ('1', '1', '" . $username . "', '" . md5(md5($userpass)) . "', '0', '', '0', '', 'users|userinfo|tg_users|userlogs|orders|ordersforuser|ordersforchannel|ordersforhour|usermoney|payments|accessprovider|channels|newsclass|news|adminpwd|adminlist|message|set|index|report|goods|tg_goods|tg_orders|weixin', '0', '0000-00-00 00:00:00');
-- ----------------------------
-- Table structure for `{$dbprefix}adminlogs`
-- ----------------------------
DROP TABLE IF EXISTS `{$dbprefix}adminlogs`;
CREATE TABLE `{$dbprefix}adminlogs` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`userid` int(10) unsigned NOT NULL,
`logip` varchar(15) NOT NULL DEFAULT '',
`logtime` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `userid` (`userid`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of {$dbprefix}adminlogs
-- ----------------------------
-- ----------------------------
-- Table structure for `{$dbprefix}auths`
-- ----------------------------
DROP TABLE IF EXISTS `{$dbprefix}auths`;
CREATE TABLE `{$dbprefix}auths` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`url` varchar(255) DEFAULT NULL,
`status` int(11) DEFAULT NULL,
`user_id` int(11) DEFAULT NULL,
`type` varchar(225) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
`remark` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of {$dbprefix}auths
-- ----------------------------
INSERT INTO `{$dbprefix}auths` VALUES ('1', '/uploads/images/auth/yongchun188-20170215113712.png', '-1', '5', '身份证扫描件', null);
INSERT INTO `{$dbprefix}auths` VALUES ('2', '/uploads/images/auth/yongchun188-20170215113727.png', '-1', '5', '协议扫描件(一)', null);
INSERT INTO `{$dbprefix}auths` VALUES ('3', '/uploads/images/auth/yongchun188-20170215113735.png', '-1', '5', '协议扫描件(二)', null);
INSERT INTO `{$dbprefix}auths` VALUES ('4', '/uploads/images/auth/yongchun188-20170215113740.png', '-1', '5', '协议扫描件(三)', null);
INSERT INTO `{$dbprefix}auths` VALUES ('5', '/uploads/images/auth/yongchun188-20170215113744.png', '-1', '5', '协议扫描件(四)', null);
-- ----------------------------
-- Table structure for `{$dbprefix}buylist`
-- ----------------------------
DROP TABLE IF EXISTS `{$dbprefix}buylist`;
CREATE TABLE `{$dbprefix}buylist` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`orderid` varchar(20) NOT NULL,
`goodid` int(10) unsigned NOT NULL,
`userid` int(10) unsigned NOT NULL,
`memberid` int(10) NOT NULL DEFAULT '0',
`price` decimal(7,2) NOT NULL DEFAULT '0.00',
`cbprice` decimal(7,2) NOT NULL DEFAULT '0.00',
`quantity` int(10) unsigned NOT NULL DEFAULT '1',
`is_receive` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0 no 1 yes',
`contact` varchar(30) NOT NULL DEFAULT '',
`channelid` int(10) unsigned NOT NULL,
`addtime` datetime DEFAULT NULL,
`is_email` tinyint(1) unsigned NOT NULL DEFAULT '0',
`email` varchar(50) NOT NULL DEFAULT '',
`is_state` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0 open 1 close',
`is_status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0未付 1成功 2部分',
`returnmsg` varchar(100) NOT NULL DEFAULT '',
`couponcode` varchar(16) NOT NULL DEFAULT '',
`fromip` varchar(20) NOT NULL DEFAULT '',
`is_coupon_state` tinyint(1) unsigned NOT NULL DEFAULT '0',
`is_discount_state` tinyint(1) unsigned NOT NULL DEFAULT '0',
`coupon` decimal(7,2) NOT NULL DEFAULT '0.00',
`is_ship` tinyint(1) unsigned NOT NULL DEFAULT '0',
`is_api` tinyint(1) unsigned NOT NULL DEFAULT '0',
`is_api_return` tinyint(1) unsigned NOT NULL DEFAULT '0',
`api_return_msg` varchar(50) NOT NULL DEFAULT '',
`api_username` varchar(100) NOT NULL DEFAULT '',
`pwdforsearch` varchar(20) NOT NULL DEFAULT '',
`updatetime` datetime DEFAULT NULL,
`from` int(11) NOT NULL,
`tghyfc` decimal(10,2) unsigned DEFAULT NULL COMMENT '推广会员分成',
`ptfc` decimal(10,2) unsigned zerofill DEFAULT NULL COMMENT '平台分成',
PRIMARY KEY (`id`),
KEY `orderid` (`orderid`),
KEY `goodid` (`goodid`),
KEY `userid` (`userid`),
KEY `is_receive` (`is_receive`),
KEY `contact` (`contact`),
KEY `channelid` (`channelid`),
KEY `is_state` (`is_state`),
KEY `is_status` (`is_status`),
KEY `fromip` (`fromip`),
KEY `memberid` (`memberid`)
) ENGINE=MyISAM AUTO_INCREMENT=604 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of {$dbprefix}buylist
-- ----------------------------
-- ----------------------------
-- Table structure for `{$dbprefix}channellist`
-- ----------------------------
DROP TABLE IF EXISTS `{$dbprefix}channellist`;
CREATE TABLE `{$dbprefix}channellist` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`channelname` varchar(50) NOT NULL DEFAULT '',
`accessType` varchar(10) NOT NULL DEFAULT '',
`gateway` varchar(10) NOT NULL DEFAULT '',
`price` decimal(6,4) NOT NULL DEFAULT '0.0000',
`platformPrice` decimal(6,4) NOT NULL DEFAULT '0.0000',
`sortid` int(10) unsigned NOT NULL DEFAULT '0',
`payid` int(10) unsigned NOT NULL,
`is_state` tinyint(1) unsigned NOT NULL DEFAULT '0',
`type` varchar(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=31 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of {$dbprefix}channellist
-- ----------------------------
INSERT INTO `{$dbprefix}channellist` VALUES ('1', '盛大一卡通', 'a8tg', 'SNDACARD', '0.8000', '0.8500', '4', '122', '0', 'card');
INSERT INTO `{$dbprefix}channellist` VALUES ('2', '移动充值卡', 'a8tg', 'szx', '0.9000', '0.9500', '1', '123', '0', 'card');
INSERT INTO `{$dbprefix}channellist` VALUES ('3', '征途充值卡', 'a8tg', 'ZHENGTU', '0.7800', '0.8000', '6', '124', '0', 'card');
INSERT INTO `{$dbprefix}channellist` VALUES ('4', '搜狐充值卡', 'a8tg', 'SOHU', '0.7800', '0.8000', '7', '131', '0', 'card');
INSERT INTO `{$dbprefix}channellist` VALUES ('5', '久游一卡通', 'a8tg', 'JIUYOU', '0.7800', '0.8000', '8', '127', '0', 'card');
INSERT INTO `{$dbprefix}channellist` VALUES ('18', '骏网一卡通', 'a8tg', 'JUNNET', '0.8000', '0.8300', '5', '121', '0', 'card');
INSERT INTO `{$dbprefix}channellist` VALUES ('7', '联通充值卡', 'a8tg', 'UNICOM', '0.9000', '0.9500', '2', '126', '0', 'card');
INSERT INTO `{$dbprefix}channellist` VALUES ('8', '完美一卡通', 'a8tg', 'WANMEI', '0.8000', '0.8500', '7', '130', '0', 'card');
INSERT INTO `{$dbprefix}channellist` VALUES ('9', '网易一卡通', 'a8tg', 'NETEASE', '0.8000', '0.8600', '9', '129', '0', 'card');
INSERT INTO `{$dbprefix}channellist` VALUES ('10', '电信充值卡', 'a8tg', 'TELECOM', '0.9000', '0.9500', '3', '132', '0', 'card');
INSERT INTO `{$dbprefix}channellist` VALUES ('11', '纵游一卡通', 'a8tg', 'ZONGYOU', '0.7800', '0.8000', '11', '133', '0', 'card');
INSERT INTO `{$dbprefix}channellist` VALUES ('12', '天下一卡通', 'a8tg', 'TIANXIA', '0.7800', '0.8000', '21', '134', '0', 'card');
INSERT INTO `{$dbprefix}channellist` VALUES ('15', '腾讯Q币卡', 'a8tg', 'QQCARD', '0.7500', '0.8200', '31', '125', '0', 'card');
INSERT INTO `{$dbprefix}channellist` VALUES ('17', '网上银行', 'a8tg', 'bank', '0.9800', '0.9900', '1', '24', '0', 'kuaijie');
INSERT INTO `{$dbprefix}channellist` VALUES ('22', '天宏一卡通', 'a8tg', 'TIANHONG', '0.8000', '0.8200', '41', '135', '0', 'card');
INSERT INTO `{$dbprefix}channellist` VALUES ('20', '财付通', 'a8tg', 'tenpay', '0.9800', '0.9900', '0', '26', '0', 'kuaijie');
INSERT INTO `{$dbprefix}channellist` VALUES ('19', '支付宝', 'yc88', 'ALIPAY', '0.9800', '0.9900', '1', '25', '0', 'kuaijie');
INSERT INTO `{$dbprefix}channellist` VALUES ('24', '微信扫码', 'yc88', 'WEIXIN', '0.9700', '0.9800', '0', '27', '0', 'kuaijie');
INSERT INTO `{$dbprefix}channellist` VALUES ('26', '手机支付宝', 'altwap', 'ALIWAP', '0.9700', '0.9900', '0', '28', '0', 'kuaijie');
INSERT INTO `{$dbprefix}channellist` VALUES ('28', 'QQ钱包', 'yc88', 'QQCODE', '0.9900', '0.9800', '0', '30', '0', 'kuaijie');
INSERT INTO `{$dbprefix}channellist` VALUES ('29', '微信公众支付', 'a8tg', 'WXAPP', '0.9900', '0.9700', '0', '29', '0', 'kuaijie');
-- ----------------------------
-- Table structure for `{$dbprefix}complaints`
-- ----------------------------
DROP TABLE IF EXISTS `{$dbprefix}complaints`;
CREATE TABLE `{$dbprefix}complaints` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`userid` int(10) unsigned NOT NULL,
`memberid` int(11) NOT NULL DEFAULT '0',
`orderid` varchar(16) NOT NULL,
`reason` varchar(50) NOT NULL DEFAULT '',
`contact` varchar(50) NOT NULL DEFAULT '',
`remark` text,
`result` text,
`url` varchar(100) NOT NULL DEFAULT '',
`is_state` tinyint(1) unsigned NOT NULL DEFAULT '0',
`is_read` tinyint(1) unsigned NOT NULL DEFAULT '0',
`addtime` int(10) unsigned NOT NULL,
`updatetime` int(10) unsigned NOT NULL,
`ip` varchar(20) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `mid` (`memberid`)
) ENGINE=MyISAM AUTO_INCREMENT=32 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of {$dbprefix}complaints
-- ----------------------------
-- ----------------------------
-- Table structure for `{$dbprefix}config`
-- ----------------------------
DROP TABLE IF EXISTS `{$dbprefix}config`;
CREATE TABLE `{$dbprefix}config` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`sitename` varchar(90) NOT NULL DEFAULT '',
`siteurl` varchar(50) NOT NULL DEFAULT '',
`keyword` varchar(100) NOT NULL DEFAULT '',
`description` varchar(100) NOT NULL DEFAULT '',
`template` varchar(100) NOT NULL DEFAULT '',
`qq` varchar(12) NOT NULL DEFAULT '',
`tel` varchar(12) NOT NULL DEFAULT '',
`reguser` tinyint(1) unsigned NOT NULL DEFAULT '0',
`regmember` tinyint(1) NOT NULL DEFAULT '0',
`userstate` tinyint(1) unsigned NOT NULL DEFAULT '0',
`copyright` varchar(100) NOT NULL DEFAULT '',
`tongji` varchar(100) NOT NULL DEFAULT '',
`smtp` varchar(50) NOT NULL DEFAULT '',
`email` varchar(50) NOT NULL DEFAULT '',
`authkey` varchar(50) NOT NULL DEFAULT '',
`sitetitle` varchar(90) NOT NULL DEFAULT '',
`theme` varchar(20) NOT NULL DEFAULT '',
`themeforbuy` varchar(20) NOT NULL DEFAULT '',
`address` varchar(200) NOT NULL DEFAULT '',
`servicemail` varchar(50) NOT NULL DEFAULT '',
`icp` varchar(20) NOT NULL DEFAULT '',
`takecash` decimal(7,2) NOT NULL DEFAULT '100.00',
`sitestate` tinyint(1) unsigned NOT NULL DEFAULT '0',
`msgtip` varchar(400) NOT NULL DEFAULT '',
`takecash_f` smallint(5) unsigned NOT NULL DEFAULT '0',
`takecash_t` smallint(5) unsigned NOT NULL DEFAULT '0',
`takecash_state` tinyint(1) unsigned NOT NULL DEFAULT '0',
`takecash_msgtip` varchar(100) NOT NULL DEFAULT '',
`go_page_theme` varchar(20) NOT NULL DEFAULT '',
`buy_page_popup` tinyint(1) unsigned NOT NULL DEFAULT '0',
`filter_state` tinyint(1) unsigned NOT NULL DEFAULT '0',
`filter_dangerwords` text,
`filter_safewords` text,
`takecash_times` smallint(5) unsigned NOT NULL DEFAULT '2',
`takecash_times_msg` varchar(400) NOT NULL DEFAULT '',
`cache_syn_state` tinyint(1) unsigned NOT NULL DEFAULT '0',
`cache_syn_ip` varchar(400) NOT NULL DEFAULT '',
`fee` decimal(9,2) NOT NULL DEFAULT '0.00',
`fee_top` decimal(9,2) NOT NULL DEFAULT '0.00',
`search_tips` varchar(500) NOT NULL DEFAULT '',
`shouxufeilv` tinyint(4) NOT NULL DEFAULT '0' COMMENT '手续费率',
`freemin` int(11) NOT NULL DEFAULT '0' COMMENT '满多少免手续费',
`xianlu` text NOT NULL COMMENT '多线路域名',
`weixin` varchar(255) NOT NULL COMMENT '微信二维码',
`domainnot` text NOT NULL COMMENT '保留二级域名',
`smsprice` decimal(10,2) NOT NULL COMMENT '短信价格',
`wx_appid` varchar(255) NOT NULL,
`wx_mchid` varchar(255) NOT NULL,
`wx_key` varchar(255) NOT NULL,
`wx_appsecret` varchar(255) NOT NULL,
`wx_notice_order` varchar(255) NOT NULL,
`wx_notice_money` varchar(255) NOT NULL,
`wx_menu1` varchar(255) NOT NULL,
`wx_menu11` varchar(500) NOT NULL,
`wx_menu12` varchar(500) NOT NULL,
`wx_menu13` varchar(500) NOT NULL,
`wx_menu14` varchar(500) NOT NULL,
`wx_menu15` varchar(500) NOT NULL,
`wx_menu2` varchar(255) NOT NULL,
`wx_menu21` varchar(500) NOT NULL,
`wx_menu22` varchar(500) NOT NULL,
`wx_menu23` varchar(500) NOT NULL,
`wx_menu24` varchar(500) NOT NULL,
`wx_menu25` varchar(500) NOT NULL,
`wx_menu3` varchar(255) NOT NULL,
`wx_menu31` varchar(500) NOT NULL,
`wx_menu32` varchar(500) NOT NULL,
`wx_menu33` varchar(500) NOT NULL,
`wx_menu34` varchar(500) NOT NULL,
`wx_menu35` varchar(255) NOT NULL,
`wx_menu1_url` varchar(255) NOT NULL,
`wx_menu11_url` varchar(500) NOT NULL,
`wx_menu12_url` varchar(500) NOT NULL,
`wx_menu13_url` varchar(500) NOT NULL,
`wx_menu14_url` varchar(500) NOT NULL,
`wx_menu15_url` varchar(500) NOT NULL,
`wx_menu2_url` varchar(255) NOT NULL,
`wx_menu21_url` varchar(500) NOT NULL,
`wx_menu22_url` varchar(500) NOT NULL,
`wx_menu23_url` varchar(500) NOT NULL,
`wx_menu24_url` varchar(500) NOT NULL,
`wx_menu25_url` varchar(500) NOT NULL,
`wx_menu3_url` varchar(255) NOT NULL,
`wx_menu31_url` varchar(500) NOT NULL,
`wx_menu32_url` varchar(500) NOT NULL,
`wx_menu33_url` varchar(500) NOT NULL,
`wx_menu34_url` varchar(500) NOT NULL,
`wx_menu35_url` varchar(255) NOT NULL,
`zhuyuming` text NOT NULL COMMENT '主域名',
`shoukayuming` text NOT NULL COMMENT '售卡域名',
`zuidishouxufei` decimal(10,0) NOT NULL COMMENT '最低手续费',
`minganci` text NOT NULL COMMENT '敏感词',
`wxpay_host` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=319 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of {$dbprefix}config
-- ----------------------------
INSERT INTO `{$dbprefix}config` VALUES ('1', '自动发卡平台', 'www.304ka.com', '自动发卡网,自动发卡平台,取卡网,发卡网,917自动发卡系统,自动发卡,发卡平台', '自动发卡网(www.304ka.com)自动发卡平台长期提供:自动发卡,自动发卡平台,专业为企业软件和个人软件.辅助游戏软件卡密等提供多途径、安全、方便、简单的自动发卡和T+0结算服务', '219kacom', '692720464', '4000-110-110', '0', '0', '0', '购买自动发卡平台联系www.304ka.com', '', 'smtp.exmail.qq.com', 'admin@qq.com', 'www.yc88.net', '自动发卡平台(你的域名)专业为企业软件和个人软件.游戏卡密等提供多途径、安全、方便、API接入业务、简单的自动发卡、卡类寄售、卡类兑换、自动销售卡密、为商家提供安全、稳定、快捷的全', 'a8tg', 'blue', '购买自动发卡平台联系174577270', 'admin@qq.com', 'ICP备100000001号', '1.00', '0', '平台维护中', '8', '23', '0', '周日不结算,统一周一下午4点之前全部到帐!', 'green', '0', '1', '', '', '5', '当日商户申请提现次数最多为1次!', '1', '153.36.233.250|123.206.62.203', '0.00', '0.00', '如对购买的卡密有任何异议,请立刻联系我们客服处理,QQ:123456789 只处理当天购买的卡密问题!当天购买的卡密必须当天解决!', '1', '500', '', '', 'www|vip1|vip2|vip3|vip4|vip5|vip6|vip7|vip8|vip9|888|666|pay|pai|aaa|bbb|123|app', '0.00', 'wxdc701022fe9b1599', '', '', '9d30c60b8cb84367681371ba2b662dba', 'Y9U3uzPXBeVYFTNfSQShRBrJgT7aAs12Xf0YDJdxz0g', '3bqJCK5KTe1YD-meU4-QDAUPxVvqNf2iswSoZMwlDvk', '商家助手', '商家订单', '商家连接', '换购价值', '商家收益', '通道管理', '商品管理', '添加分类', '添加商品', '商品列表', '库存卡密', '添加卡密', '商户中心', '会员中心', '申请提现', '安全设置', '平台公告', '信息修改', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '1百度云|摆渡云|VA视频|赌博|棋牌|做爱|冰毒|口交|妹妹|美眉|色情|性交|脱衣|性格美女|美女丝袜|A片|一级片|成人视频|野外激情|抽奖|云购充值|色情论坛VIP|杀人视频|杀人|时时彩|淫乱|变态妇女|百度云盘|微盘|云盘|色情网站|超爽|淫秽视频|陈曦|陈诗云|鼻血|女教室|同居|义父同居|巨乳|巨乳女教師|中村知恵|淫荡|女佣|QB|Q币|腾讯QB|自拍|自摸|少妇|爱奇艺|色情引流|视频|刷人气|腾讯业务会员|腾讯业务钻|短信轰炸|免流|手机流量|套现|洗钱|盗号|木马|病毒|福彩|六合彩|赌球|北京飞车|赌马|欢乐球|吃球|彩贝|乐球|游戏黑号|腾讯QB|QQ会员|QQ红钻|QQ蓝钻|QQ绿钻|QQ紫钻|QQ钻|QQ业务|云购|博彩|一元云购|二测号|黑号|洗号|钻代充|腾讯代充|代充', '', 'www.219ka.com');
-- ----------------------------
-- Table structure for `{$dbprefix}emailcode`
-- ----------------------------
DROP TABLE IF EXISTS `{$dbprefix}emailcode`;
CREATE TABLE `{$dbprefix}emailcode` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`email` varchar(255) NOT NULL DEFAULT '',
`key` varchar(255) NOT NULL DEFAULT '',
`status` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=183 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of {$dbprefix}emailcode
-- ----------------------------
-- ----------------------------
-- Table structure for `{$dbprefix}goodcate`
-- ----------------------------
DROP TABLE IF EXISTS `{$dbprefix}goodcate`;
CREATE TABLE `{$dbprefix}goodcate` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`userid` int(10) unsigned NOT NULL,
`catename` varchar(100) NOT NULL,
`sortid` int(10) unsigned NOT NULL DEFAULT '0',
`is_state` tinyint(1) unsigned NOT NULL DEFAULT '0',
`sitename` varchar(50) NOT NULL DEFAULT '',
`siteurl` varchar(50) NOT NULL DEFAULT '',
`qq` varchar(12) NOT NULL DEFAULT '',
`is_link_state` tinyint(1) unsigned NOT NULL DEFAULT '0',
`linkid` varchar(16) NOT NULL,
`theme` varchar(20) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `userid` (`userid`)
) ENGINE=MyISAM AUTO_INCREMENT=85 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of {$dbprefix}goodcate
-- ----------------------------
-- ----------------------------
-- Table structure for `{$dbprefix}goodcoupon`
-- ----------------------------
DROP TABLE IF EXISTS `{$dbprefix}goodcoupon`;
CREATE TABLE `{$dbprefix}goodcoupon` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`userid` int(10) unsigned NOT NULL,
`cateid` int(10) unsigned NOT NULL DEFAULT '0',
`is_state` tinyint(1) unsigned NOT NULL DEFAULT '0',
`addtime` datetime DEFAULT NULL,
`valid` int(10) unsigned NOT NULL DEFAULT '1',
`coupon` int(10) unsigned NOT NULL DEFAULT '0',
`ctype` int(10) unsigned NOT NULL DEFAULT '1',
`remark` varchar(100) NOT NULL DEFAULT '',
`couponcode` varchar(16) NOT NULL,
`updatetime` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of {$dbprefix}goodcoupon
-- ----------------------------
-- ----------------------------
-- Table structure for `{$dbprefix}gooddiscount`
-- ----------------------------
DROP TABLE IF EXISTS `{$dbprefix}gooddiscount`;
CREATE TABLE `{$dbprefix}gooddiscount` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`goodid` int(10) unsigned NOT NULL,
`dis_quantity` int(10) unsigned NOT NULL DEFAULT '0',
`dis_price` decimal(10,2) NOT NULL DEFAULT '0.00',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=44 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of {$dbprefix}gooddiscount
-- ----------------------------
INSERT INTO `{$dbprefix}gooddiscount` VALUES ('40', '7', '100', '1.50');
INSERT INTO `{$dbprefix}gooddiscount` VALUES ('39', '7', '10', '1.30');
INSERT INTO `{$dbprefix}gooddiscount` VALUES ('41', '64', '10', '10.00');
INSERT INTO `{$dbprefix}gooddiscount` VALUES ('42', '64', '15', '12.00');
INSERT INTO `{$dbprefix}gooddiscount` VALUES ('43', '72', '50', '20.00');
-- ----------------------------
-- Table structure for `{$dbprefix}goodlist`
-- ----------------------------
DROP TABLE IF EXISTS `{$dbprefix}goodlist`;
CREATE TABLE `{$dbprefix}goodlist` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`userid` int(10) unsigned NOT NULL,
`cateid` int(10) unsigned NOT NULL,
`goodname` varchar(100) NOT NULL,
`price` decimal(10,2) NOT NULL DEFAULT '0.00',
`cbprice` decimal(10,2) NOT NULL DEFAULT '0.00',
`sortid` int(10) unsigned NOT NULL DEFAULT '0',
`is_state` tinyint(1) unsigned NOT NULL DEFAULT '0',
`remark` text NOT NULL,
`invent_report` int(10) unsigned NOT NULL DEFAULT '0',
`is_display` tinyint(1) unsigned NOT NULL DEFAULT '0',
`is_paytype` tinyint(1) unsigned NOT NULL DEFAULT '0',
`is_invent` tinyint(1) unsigned NOT NULL DEFAULT '0',
`is_discount` tinyint(1) unsigned NOT NULL DEFAULT '0',
`is_coupon` tinyint(1) unsigned NOT NULL DEFAULT '0',
`sitename` varchar(50) NOT NULL DEFAULT '',
`siteurl` varchar(50) NOT NULL DEFAULT '',
`qq` varchar(12) NOT NULL DEFAULT '',
`is_link_state` tinyint(1) unsigned NOT NULL DEFAULT '0',
`linkid` varchar(16) NOT NULL,
`theme` varchar(20) NOT NULL DEFAULT '',
`is_send_mail` tinyint(1) unsigned NOT NULL DEFAULT '0',
`is_display_remark` tinyint(1) unsigned NOT NULL DEFAULT '0',
`is_contact_limit` tinyint(1) unsigned NOT NULL DEFAULT '99',
`is_api` tinyint(1) unsigned NOT NULL DEFAULT '0',
`api_return_url` varchar(100) NOT NULL DEFAULT '',
`is_message` tinyint(1) unsigned NOT NULL DEFAULT '0',
`is_email` tinyint(1) unsigned NOT NULL DEFAULT '0',
`is_pwdforsearch` tinyint(1) unsigned NOT NULL DEFAULT '0',
`limit_quantity` int(10) unsigned NOT NULL DEFAULT '0',
`is_join_main_link` tinyint(1) unsigned NOT NULL DEFAULT '0',
`is_send_sms` tinyint(4) NOT NULL COMMENT '是否发送短信',
`is_tg` tinyint(1) unsigned NOT NULL COMMENT '是否推广',
`mima` varchar(50) NOT NULL DEFAULT '' COMMENT '密码',
`ptfc` decimal(10,2) unsigned NOT NULL COMMENT '平台分成',
`tghyfc` decimal(10,2) unsigned NOT NULL COMMENT '推广会员分成',
PRIMARY KEY (`id`),
KEY `userid` (`userid`),
KEY `cateid` (`cateid`)
) ENGINE=MyISAM AUTO_INCREMENT=183 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of {$dbprefix}goodlist
-- ----------------------------
-- ----------------------------
-- Table structure for `{$dbprefix}goods`
-- ----------------------------
DROP TABLE IF EXISTS `{$dbprefix}goods`;
CREATE TABLE `{$dbprefix}goods` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`userid` int(10) unsigned NOT NULL,
`goodid` int(10) unsigned NOT NULL,
`cardnum` varchar(255) NOT NULL DEFAULT '',
`cardpwd` varchar(255) NOT NULL DEFAULT '',
`is_state` tinyint(1) unsigned NOT NULL DEFAULT '0',
`addtime` datetime DEFAULT NULL,
`updatetime` datetime DEFAULT NULL,
`orderid` varchar(16) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `userid` (`userid`),
KEY `goodid` (`goodid`),
KEY `is_state` (`is_state`)
) ENGINE=MyISAM AUTO_INCREMENT=1974 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of {$dbprefix}goods
-- ----------------------------
INSERT INTO `{$dbprefix}goods` VALUES ('1932', '134', '165', '25792073|346715', '', '0', '2017-07-02 19:57:16', null, '');
INSERT INTO `{$dbprefix}goods` VALUES ('1931', '134', '165', '10012349|525736', '', '0', '2017-07-02 19:57:16', null, '');
INSERT INTO `{$dbprefix}goods` VALUES ('1930', '134', '165', '78665986|269738', '', '0', '2017-07-02 19:57:16', null, '');
INSERT INTO `{$dbprefix}goods` VALUES ('1929', '134', '165', '64647866|516391', '', '0', '2017-07-02 19:57:16', null, '');
INSERT INTO `{$dbprefix}goods` VALUES ('1928', '134', '165', '30315886|614608', '', '0', '2017-07-02 19:57:16', null, '');
INSERT INTO `{$dbprefix}goods` VALUES ('1941', '134', '165', '73301323|801005', '', '0', '2017-07-02 19:57:16', null, '');
INSERT INTO `{$dbprefix}goods` VALUES ('1940', '134', '165', '09098638|926038', '', '0', '2017-07-02 19:57:16', null, '');
INSERT INTO `{$dbprefix}goods` VALUES ('1939', '134', '165', '95996596|755624', '', '0', '2017-07-02 19:57:16', null, '');
INSERT INTO `{$dbprefix}goods` VALUES ('1938', '134', '165', '88234489|073793', '', '0', '2017-07-02 19:57:16', null, '');
INSERT INTO `{$dbprefix}goods` VALUES ('1937', '134', '165', '14695647|865824', '', '0', '2017-07-02 19:57:16', null, '');
INSERT INTO `{$dbprefix}goods` VALUES ('1936', '134', '165', '26176566|267283', '', '0', '2017-07-02 19:57:16', null, '');
INSERT INTO `{$dbprefix}goods` VALUES ('1935', '134', '165', '51387545|875200', '', '0', '2017-07-02 19:57:16', null, '');
INSERT INTO `{$dbprefix}goods` VALUES ('1934', '134', '165', '43376720|796456', '', '0', '2017-07-02 19:57:16', null, '');
INSERT INTO `{$dbprefix}goods` VALUES ('1933', '134', '165', '28202565|341515', '', '0', '2017-07-02 19:57:16', null, '');
-- ----------------------------
-- Table structure for `{$dbprefix}members`
-- ----------------------------
DROP TABLE IF EXISTS `{$dbprefix}members`;
CREATE TABLE `{$dbprefix}members` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(15) NOT NULL,
`userpass` varchar(32) NOT NULL,
`email` varchar(50) NOT NULL,
`tel` varchar(12) NOT NULL,
`qq` varchar(12) NOT NULL,
`addtime` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `username` (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of {$dbprefix}members
-- ----------------------------
-- ----------------------------
-- Table structure for `{$dbprefix}message`
-- ----------------------------
DROP TABLE IF EXISTS `{$dbprefix}message`;
CREATE TABLE `{$dbprefix}message` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`from_user` int(10) unsigned NOT NULL,
`to_user` int(10) unsigned NOT NULL,
`title` varchar(100) NOT NULL,
`content` varchar(200) NOT NULL,
`is_receiver` tinyint(1) unsigned NOT NULL DEFAULT '0',
`is_sender` tinyint(1) unsigned NOT NULL DEFAULT '0',
`is_read` tinyint(1) unsigned NOT NULL DEFAULT '0',
`addtime` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of {$dbprefix}message
-- ----------------------------
-- ----------------------------
-- Table structure for `{$dbprefix}message_mem`
-- ----------------------------
DROP TABLE IF EXISTS `{$dbprefix}message_mem`;
CREATE TABLE `{$dbprefix}message_mem` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`from_user` int(10) unsigned NOT NULL,
`to_user` int(10) unsigned NOT NULL,
`title` varchar(100) NOT NULL,
`content` varchar(200) NOT NULL,
`is_receiver` tinyint(1) unsigned NOT NULL DEFAULT '0',
`is_sender` tinyint(1) unsigned NOT NULL DEFAULT '0',
`is_read` tinyint(1) unsigned NOT NULL DEFAULT '0',
`addtime` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of {$dbprefix}message_mem
-- ----------------------------
-- ----------------------------
-- Table structure for `{$dbprefix}news`
-- ----------------------------
DROP TABLE IF EXISTS `{$dbprefix}news`;
CREATE TABLE `{$dbprefix}news` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`classid` int(10) unsigned NOT NULL,
`title` varchar(100) NOT NULL,
`content` text,
`is_bold` varchar(10) NOT NULL DEFAULT '',
`is_color` varchar(10) NOT NULL DEFAULT '',
`is_popup` tinyint(1) unsigned NOT NULL DEFAULT '0',
`addtime` datetime DEFAULT NULL,
`views` int(10) unsigned NOT NULL DEFAULT '0',
`is_state` tinyint(1) unsigned NOT NULL DEFAULT '0',
`is_display_home` tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of {$dbprefix}news
-- ----------------------------
-- ----------------------------
-- Table structure for `{$dbprefix}newsclass`
-- ----------------------------
DROP TABLE IF EXISTS `{$dbprefix}newsclass`;
CREATE TABLE `{$dbprefix}newsclass` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`classname` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of {$dbprefix}newsclass
-- ----------------------------
INSERT INTO `{$dbprefix}newsclass` VALUES ('1', '最新动态');
INSERT INTO `{$dbprefix}newsclass` VALUES ('8', '其他分类');
INSERT INTO `{$dbprefix}newsclass` VALUES ('3', '商家百科');
INSERT INTO `{$dbprefix}newsclass` VALUES ('4', '通知公告');
INSERT INTO `{$dbprefix}newsclass` VALUES ('5', '商户小提示');
INSERT INTO `{$dbprefix}newsclass` VALUES ('9', '首页公告');
-- ----------------------------
-- Table structure for `{$dbprefix}orderlist`
-- ----------------------------
DROP TABLE IF EXISTS `{$dbprefix}orderlist`;
CREATE TABLE `{$dbprefix}orderlist` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`orderid` varchar(50) NOT NULL DEFAULT '',
`payorderid` varchar(50) NOT NULL DEFAULT '',
`money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00',
`realmoney` decimal(10,2) unsigned NOT NULL DEFAULT '0.00',
`price` decimal(10,4) unsigned NOT NULL DEFAULT '1.0000',
`platformPrice` decimal(10,4) unsigned NOT NULL DEFAULT '1.0000',
`rates` varchar(50) NOT NULL DEFAULT '',
`cardnum` varchar(200) NOT NULL DEFAULT '',
`cardpwd` varchar(200) NOT NULL DEFAULT '',
`channelid` int(10) unsigned NOT NULL DEFAULT '0',
`addtime` varchar(100) NOT NULL DEFAULT '',
`returnmsg` varchar(100) NOT NULL DEFAULT '',
`is_api` tinyint(1) unsigned NOT NULL DEFAULT '0',
`is_state` tinyint(1) unsigned NOT NULL DEFAULT '0',
`is_pay` tinyint(1) unsigned NOT NULL DEFAULT '0',
`is_status` tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `orderid` (`orderid`),
KEY `payorderid` (`payorderid`)
) ENGINE=MyISAM AUTO_INCREMENT=607 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of {$dbprefix}orderlist
-- ----------------------------
-- ----------------------------
-- Table structure for `{$dbprefix}pay`
-- ----------------------------
DROP TABLE IF EXISTS `{$dbprefix}pay`;
CREATE TABLE `{$dbprefix}pay` (
`payid` int(10) unsigned NOT NULL,
`payname` varchar(30) NOT NULL DEFAULT '',
`paytype` varchar(10) NOT NULL DEFAULT '',
`payprice` varchar(100) NOT NULL DEFAULT '',
`paylength` varchar(20) NOT NULL DEFAULT '',
`imgurl` varchar(50) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of {$dbprefix}pay
-- ----------------------------
INSERT INTO `{$dbprefix}pay` VALUES ('1', '盛大充值卡', 'shengda', '5|10|15|20|25|30|35|45|50|100|200|300|350|1000', '0|0', 'SNDACARD.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('2', 'QQ充值卡', 'qqb', '5|10|15|30|60|100', '9|12', 'QQ.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('3', '神州行充值卡', 'szx', '10|15|20|30|50|100|300|500', '0|0', 'SZX.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('4', '征途充值卡', 'zhengtu', '10|15|20|25|30|50|60|100|300|468', '16|8', 'ZHENGTU.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('5', '搜狐充值卡', 'sohu', '5|10|15|30|40|100', '20|12', 'SOHU.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('6', '久游一卡通', 'jiuyou', '5|10|15|20|25|30|50|100', '13|10', 'JIUYOU.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('7', '骏网一卡通', 'junwang', '5|6|10|15|30|50|100', '0|0', 'JUNNET.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('8', '联通充值卡', 'liantong', '20|30|50|100|300|500', '15|19', 'UNICOM.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('9', '完美一卡通', 'wanmei', '15|30|50|100', '10|15', 'WANMEI.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('10', '网易一卡通', 'wangyi', '5|10|15|20|30|50', '13|9', 'NETEASE.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('11', '电信充值卡', 'dianxin', '50|100|200', '19|18', 'TELECOM.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('12', '神州行充值地方卡', 'szx2', '10|15|20|30|50|100|300|500', '0|0', 'SZX.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('13', '易宝一卡通', 'yeebao', '2|5|10|15|20|25|30', '0|0', 'YEEBAO.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('14', '纵游一卡通', 'zongyou', '10|15|30|50|100', '15|15', 'ZONGYOU.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('15', '天下一卡通', 'tianxia', '5|6|10|15|30|50|100', '15|8', 'TIANXIA.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('16', '天宏一卡通', 'tianhong', '10|15|30|50|100', '0|0', 'TIANHONG.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('17', '光宇一卡通', 'guangyu', '15|30|50|100', '0|0', 'GUANGYU.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('18', '热血充值卡', 'rexue', '5|10|35|100|350|1000', '0|0', 'REXUE.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('19', '5173充值卡', '5173', '30|60|120|360', '0|0', '5173.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('20', '魔兽充值卡', 'moshou', '10|15|20|30|50|100|300|500', '0|0', 'MOSHOU.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('21', '联华ok卡', 'lianhua', '15|30|50|100', '0|0', 'LIANHUA.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('22', '金山一卡通', 'jinshan', '15|30|50|100', '0|0', 'JINSHAN.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('23', '51支付卡', 'zfk', '10|30|50|100|200|210', '0|0', 'ebao.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('24', '网上银行充值', 'bank', '0', '0|0', '');
INSERT INTO `{$dbprefix}pay` VALUES ('25', '支付宝', 'alipay', '0', '0|0', '');
INSERT INTO `{$dbprefix}pay` VALUES ('26', '财付通', 'tenpay', '0', '0|0', '');
INSERT INTO `{$dbprefix}pay` VALUES ('30', 'QQ钱包', 'QQCODE', '', '0|0', '');
INSERT INTO `{$dbprefix}pay` VALUES ('31', '天下一卡通专项', 'txzx', '10|20|30|40|50|60|70|80|90|100', '0|0', 'TIANXIA.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('32', '天宏一卡通', 'th', '5|10|15|30|50|100', '0|0', 'TIANHONG.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('33', '天下一卡通通用', 'tx', '10|20|30|40|50|60|70|80|90|100', '0|0', 'TIANXIA.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('34', '光宇一卡通', 'gy', '5|10|20|30|50|100', '0|0', 'GUANGYU.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('35', '中国电信充值付费卡', 'dx', '10|20|30|50|100|200|300|500', '0|0', 'TELECOM.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('36', '神州行(地方)充值卡', 'cd', '10|20|30|50|100|300', '0|0', 'SZX.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('37', 'QQ卡', 'qq', '5|10|15|20|30|60|100|200', '0|0', 'QQ.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('38', '完美一卡通', 'wm', '15|30|50|100', '0|0', 'WANMEI.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('39', '久游一卡通', 'jy', '5|10|15|20|25|30|50|100', '0|0', 'JIUYOU.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('40', '征途一卡通', 'zt', '5|10|15|20|25|30|60|100|500|1000', '0|0', 'ZHENGTU.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('41', '盛大一卡通', 'sd', '1|2|3|4|5|9|10|15|25|30|35|45|50|100|350|1000', '0|0', 'SNDACARD.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('42', '网易一卡通', 'wy', '10|15|20|30|50', '0|0', 'NETEASE.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('43', '搜狐一卡通', 'sh', '5|15|30|40|100', '0|0', 'SOHU.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('44', '骏网一卡通', 'jw', '4|5|6|10|15|20|30|50|100|200|500|1000', '0|0', 'JUNNET.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('45', '联通全国充值卡', 'cc', '20|30|50|100|300|500', '0|0', 'UNICOM.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('46', '神州行全国卡', 'cm', '10|20|30|50|100|200|300|500', '0|0', 'SZX.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('101', '骏网一卡通', 'jw', '5|6|10|15|30|50|100', '0|0', 'JUNNET.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('102', '盛大充值卡', 'sd', '5|10|15|20|25|30|35|45|50|100|200|300|350|1000', '0|0', 'SNDACARD.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('103', '神州行充值卡', 'szx', '10|15|20|30|50|100|300|500', '0|0', 'SZX.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('104', '征途充值卡', 'zt', '10|15|20|25|30|50|60|100|300|468', '16|8', 'ZHENGTU.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('105', 'QQ充值卡', 'qq', '5|10|15|30|60|100', '9|12', 'QQ.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('106', '联通充值卡', 'UNICOM', '20|30|50|100|300|500', '0|0', 'UNICOM.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('107', '久游一卡通', 'jy', '5|10|15|20|25|30|50|100', '13|10', 'JIUYOU.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('108', '易宝一卡通', 'yb', '2|5|10|15|20|25|30', '0|0', 'YEEBAO.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('109', '网易一卡通', 'wy', '5|10|15|20|30|50', '13|9', 'NETEASE.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('110', '完美一卡通', 'wm', '15|30|50|100', '10|15', 'WANMEI.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('111', '搜狐充值卡', 'sh', '5|10|15|30|40|100', '20|12', 'SOHU.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('112', '电信充值卡', 'TELECOM', '50|100|200', '19|18', 'TELECOM.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('113', '纵游一卡通', 'zy', '10|15|30|50|100', '15|15', 'ZONGYOU.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('114', '天下一卡通', 'tx', '5|6|10|15|30|50|100', '15|8', 'TIANXIA.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('115', '天宏一卡通', 'th', '10|15|30|50|100', '0|0', 'TIANHONG.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('116', '网上银行', 'bank', '10|15|30|50|100', '0|0', 'ZONGYOU.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('117', '支付通', 'alipay', '5|6|10|15|30|50|100', '15|8', 'TIANXIA.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('118', '财付通', 'tenpay', '10|15|30|50|100', '0|0', 'TIANHONG.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('121', '骏网一卡通', 'JUNNET', '5|6|10|15|30|50|100', '0|0', 'JUNNET.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('122', '盛大充值卡', 'SNDACARD', '5|10|15|20|25|30|35|45|50|100|200|300|350|1000', '0|0', 'SNDACARD.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('123', '神州行充值卡', 'szx', '10|15|20|30|50|100|300|500', '0|0', 'SZX.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('124', '征途充值卡', 'ZHENGTU', '10|15|20|25|30|50|60|100|300|468', '16|8', 'ZHENGTU.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('125', 'QQ充值卡', 'QQCARD', '5|10|15|30|60|100', '9|12', 'QQ.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('126', '联通充值卡', 'UNICOM', '20|30|50|100|300|500', '0|0', 'UNICOM.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('127', '久游一卡通', 'JIUYOU', '5|10|15|20|25|30|50|100', '13|10', 'JIUYOU.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('128', '易宝一卡通', 'yb', '2|5|10|15|20|25|30', '0|0', 'YEEBAO.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('129', '网易一卡通', 'NETEASE', '5|10|15|20|30|50', '13|9', 'NETEASE.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('130', '完美一卡通', 'WANMEI', '15|30|50|100', '10|15', 'WANMEI.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('131', '搜狐充值卡', 'SOHU', '5|10|15|30|40|100', '20|12', 'SOHU.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('132', '电信充值卡', 'TELECOM', '50|100|200', '19|18', 'TELECOM.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('133', '纵游一卡通', 'ZONGYOU', '10|15|30|50|100', '15|15', 'ZONGYOU.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('134', '天下一卡通', 'TIANXIA', '5|6|10|15|30|50|100', '15|8', 'TIANXIA.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('135', '天宏一卡通', 'TIANHONG', '10|15|30|50|100', '0|0', 'TIANHONG.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('136', '光宇一卡通', 'GUANGYU', '10', '0|0', 'TIANHONG.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('137', '网上银行', 'bank', '10|15|30|50|100', '0|0', 'ZONGYOU.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('138', '支付通', 'alipay', '5|6|10|15|30|50|100', '15|8', 'TIANXIA.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('139', '财付通', 'tenpay', '10|15|30|50|100', '0|0', 'TIANHONG.jpg');
INSERT INTO `{$dbprefix}pay` VALUES ('27', '微信扫码', 'weixin', '', '', '');
INSERT INTO `{$dbprefix}pay` VALUES ('28', '手机支付宝', 'ALIWAP', '', '', '');
INSERT INTO `{$dbprefix}pay` VALUES ('29', '微信公众支付', 'WXAPP', '', '0|0', '');
-- ----------------------------
-- Table structure for `{$dbprefix}paylist`
-- ----------------------------
DROP TABLE IF EXISTS `{$dbprefix}paylist`;
CREATE TABLE `{$dbprefix}paylist` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`payid` int(10) unsigned NOT NULL,
`gateway` varchar(10) NOT NULL DEFAULT '',
`accessType` varchar(10) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `payid` (`payid`),
KEY `accessType` (`accessType`)
) ENGINE=MyISAM AUTO_INCREMENT=190 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of {$dbprefix}paylist
-- ----------------------------
INSERT INTO `{$dbprefix}paylist` VALUES ('1', '1', 'SNDACARD', 'ebao');
INSERT INTO `{$dbprefix}paylist` VALUES ('2', '2', 'QQCARD', 'ebao');
INSERT INTO `{$dbprefix}paylist` VALUES ('3', '3', 'SZX', 'ebao');
INSERT INTO `{$dbprefix}paylist` VALUES ('4', '4', 'ZHENGTU', 'ebao');
INSERT INTO `{$dbprefix}paylist` VALUES ('5', '5', 'SOHU', 'ebao');
INSERT INTO `{$dbprefix}paylist` VALUES ('6', '6', 'JIUYOU', 'ebao');
INSERT INTO `{$dbprefix}paylist` VALUES ('7', '7', 'JUNNET', 'ebao');
INSERT INTO `{$dbprefix}paylist` VALUES ('8', '8', 'UNICOM', 'ebao');
INSERT INTO `{$dbprefix}paylist` VALUES ('9', '9', 'WANMEI', 'ebao');
INSERT INTO `{$dbprefix}paylist` VALUES ('10', '10', 'NETEASE', 'ebao');
INSERT INTO `{$dbprefix}paylist` VALUES ('11', '11', 'TELECOM', 'ebao');
INSERT INTO `{$dbprefix}paylist` VALUES ('12', '13', 'YPCARD', 'ebao');
INSERT INTO `{$dbprefix}paylist` VALUES ('13', '14', 'ZONGYOU', 'ebao');
INSERT INTO `{$dbprefix}paylist` VALUES ('14', '15', 'TIANXIA', 'ebao');
INSERT INTO `{$dbprefix}paylist` VALUES ('15', '16', 'TIANHONG', 'ebao');
INSERT INTO `{$dbprefix}paylist` VALUES ('16', '24', 'BANK', 'ebao');
INSERT INTO `{$dbprefix}paylist` VALUES ('17', '25', 'alipay', 'alipay');
INSERT INTO `{$dbprefix}paylist` VALUES ('18', '26', 'tenpay', 'tenpay');
INSERT INTO `{$dbprefix}paylist` VALUES ('51', '31', 'txzx', '70ka');
INSERT INTO `{$dbprefix}paylist` VALUES ('52', '32', 'th', '70ka');
INSERT INTO `{$dbprefix}paylist` VALUES ('53', '33', 'tx', '70ka');
INSERT INTO `{$dbprefix}paylist` VALUES ('54', '34', 'gy', '70ka');
INSERT INTO `{$dbprefix}paylist` VALUES ('55', '35', 'dx', '70ka');
INSERT INTO `{$dbprefix}paylist` VALUES ('56', '36', 'cd', '70ka');
INSERT INTO `{$dbprefix}paylist` VALUES ('57', '37', 'qq', '70ka');
INSERT INTO `{$dbprefix}paylist` VALUES ('58', '38', 'wm', '70ka');
INSERT INTO `{$dbprefix}paylist` VALUES ('59', '39', 'jy', '70ka');
INSERT INTO `{$dbprefix}paylist` VALUES ('60', '40', 'zt', '70ka');
INSERT INTO `{$dbprefix}paylist` VALUES ('61', '41', 'sd', '70ka');
INSERT INTO `{$dbprefix}paylist` VALUES ('62', '42', 'wy', '70ka');
INSERT INTO `{$dbprefix}paylist` VALUES ('63', '43', 'sh', '70ka');
INSERT INTO `{$dbprefix}paylist` VALUES ('64', '44', 'jw', '70ka');
INSERT INTO `{$dbprefix}paylist` VALUES ('65', '45', 'cc', '70ka');
INSERT INTO `{$dbprefix}paylist` VALUES ('66', '46', 'cm', '70ka');
INSERT INTO `{$dbprefix}paylist` VALUES ('103', '24', 'BANK', 'huichao');
INSERT INTO `{$dbprefix}paylist` VALUES ('104', '25', 'alipay', 'shuang');
INSERT INTO `{$dbprefix}paylist` VALUES ('111', '121', 'JUNNET', 'a8tg');
INSERT INTO `{$dbprefix}paylist` VALUES ('112', '122', 'SNDACARD', 'a8tg');
INSERT INTO `{$dbprefix}paylist` VALUES ('113', '123', 'szx', 'a8tg');
INSERT INTO `{$dbprefix}paylist` VALUES ('114', '124', 'ZHENGTU', 'a8tg');
INSERT INTO `{$dbprefix}paylist` VALUES ('115', '125', 'QQCARD', 'a8tg');
INSERT INTO `{$dbprefix}paylist` VALUES ('116', '126', 'UNICOM', 'a8tg');
INSERT INTO `{$dbprefix}paylist` VALUES ('117', '127', 'JIUYOU', 'a8tg');
INSERT INTO `{$dbprefix}paylist` VALUES ('118', '128', 'yb', 'a8tg');
INSERT INTO `{$dbprefix}paylist` VALUES ('119', '129', 'NETEASE', 'a8tg');
INSERT INTO `{$dbprefix}paylist` VALUES ('120', '130', 'WANMEI', 'a8tg');
INSERT INTO `{$dbprefix}paylist` VALUES ('121', '131', 'SOHU', 'a8tg');
INSERT INTO `{$dbprefix}paylist` VALUES ('122', '132', 'TELECOM', 'a8tg');
INSERT INTO `{$dbprefix}paylist` VALUES ('123', '133', 'ZONGYOU', 'a8tg');
INSERT INTO `{$dbprefix}paylist` VALUES ('124', '134', 'TIANXIA', 'a8tg');
INSERT INTO `{$dbprefix}paylist` VALUES ('125', '135', 'TIANHONG', 'a8tg');
INSERT INTO `{$dbprefix}paylist` VALUES ('126', '136', 'GUANGYU', 'a8tg');
INSERT INTO `{$dbprefix}paylist` VALUES ('127', '24', 'bank', 'a8tg');
INSERT INTO `{$dbprefix}paylist` VALUES ('128', '25', 'ALQR', 'a8tg');
INSERT INTO `{$dbprefix}paylist` VALUES ('129', '26', 'tenpay', 'a8tg');
INSERT INTO `{$dbprefix}paylist` VALUES ('130', '27', 'WEIXIN', 'a8tg');
INSERT INTO `{$dbprefix}paylist` VALUES ('133', '30', 'QQCODE', 'a8tg');
INSERT INTO `{$dbprefix}paylist` VALUES ('131', '28', 'ALIWAP', 'a8tg');
INSERT INTO `{$dbprefix}paylist` VALUES ('189', '27', 'WEIXIN', 'weixin');
INSERT INTO `{$dbprefix}paylist` VALUES ('134', '24', 'bank', 'ips');
INSERT INTO `{$dbprefix}paylist` VALUES ('136', '1', 'SNDACARD', 'lcardy');
INSERT INTO `{$dbprefix}paylist` VALUES ('137', '2', 'QQCARD', 'lcardy');
INSERT INTO `{$dbprefix}paylist` VALUES ('138', '3', 'SAZ', 'lcardy');
INSERT INTO `{$dbprefix}paylist` VALUES ('139', '4', 'ZHENGTU', 'lcardy');
INSERT INTO `{$dbprefix}paylist` VALUES ('140', '5', 'SOHU', 'lcardy');
INSERT INTO `{$dbprefix}paylist` VALUES ('141', '6', 'JIUYOU', 'lcardy');
INSERT INTO `{$dbprefix}paylist` VALUES ('142', '7', 'JUNNET', 'lcardy');
INSERT INTO `{$dbprefix}paylist` VALUES ('143', '8', 'UNICOM', 'lcardy');
INSERT INTO `{$dbprefix}paylist` VALUES ('144', '9', 'WANMEI', 'lcardy');
INSERT INTO `{$dbprefix}paylist` VALUES ('145', '10', 'NETEASE', 'lcardy');
INSERT INTO `{$dbprefix}paylist` VALUES ('146', '11', 'TELECOM', 'lcardy');
INSERT INTO `{$dbprefix}paylist` VALUES ('147', '14', 'ZONGYOU', 'lcardy');
INSERT INTO `{$dbprefix}paylist` VALUES ('148', '15', 'TIANXIA', 'lcardy');
INSERT INTO `{$dbprefix}paylist` VALUES ('149', '16', 'TIANHONG', 'lcardy');
INSERT INTO `{$dbprefix}paylist` VALUES ('150', '17', 'GUANGYU', 'lcardy');
INSERT INTO `{$dbprefix}paylist` VALUES ('151', '25', 'ALIPAY', 'lcardy');
INSERT INTO `{$dbprefix}paylist` VALUES ('152', '140', 'WEIXINPAY', 'lcardy');
INSERT INTO `{$dbprefix}paylist` VALUES ('153', '24', 'BANK', 'lcardy');
INSERT INTO `{$dbprefix}paylist` VALUES ('154', '26', 'TENPAY', 'lcardy');
INSERT INTO `{$dbprefix}paylist` VALUES ('156', '29', 'WXWAP', 'lcardy');
INSERT INTO `{$dbprefix}paylist` VALUES ('158', '28', 'ALIWAP', 'altwap');
INSERT INTO `{$dbprefix}paylist` VALUES ('132', '29', 'WXAPP', 'a8tg');
INSERT INTO `{$dbprefix}paylist` VALUES ('159', '25', 'ALIPAY', 'yc88');
INSERT INTO `{$dbprefix}paylist` VALUES ('160', '30', 'QQCODE', 'yc88');
INSERT INTO `{$dbprefix}paylist` VALUES ('161', '27', 'WEIXIN', 'yc88');
INSERT INTO `{$dbprefix}paylist` VALUES ('162', '29', 'WXAPP', 'qqcode');
-- ----------------------------
-- Table structure for `{$dbprefix}payments`
-- ----------------------------
DROP TABLE IF EXISTS `{$dbprefix}payments`;
CREATE TABLE `{$dbprefix}payments` (
`id` int(12) unsigned NOT NULL AUTO_INCREMENT,
`userid` int(12) unsigned NOT NULL DEFAULT '0',
`pid` varchar(200) NOT NULL DEFAULT '0',
`money` varchar(200) NOT NULL DEFAULT '0',
`fee` varchar(200) NOT NULL DEFAULT '',
`remark` text NOT NULL,
`addtime` varchar(200) NOT NULL DEFAULT '',
`updatetime` varchar(200) NOT NULL DEFAULT '',
`is_state` tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=98 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of {$dbprefix}payments
-- ----------------------------
-- ----------------------------
-- Table structure for `{$dbprefix}products`
-- ----------------------------
DROP TABLE IF EXISTS `{$dbprefix}products`;
CREATE TABLE `{$dbprefix}products` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(128) NOT NULL,
`links` varchar(128) NOT NULL,
`price` decimal(10,2) NOT NULL,
`img` varchar(128) NOT NULL,
`addtime` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of {$dbprefix}products
-- ----------------------------
-- ----------------------------
-- Table structure for `{$dbprefix}pwcard`
-- ----------------------------
DROP TABLE IF EXISTS `{$dbprefix}pwcard`;
CREATE TABLE `{$dbprefix}pwcard` (
`ck` varchar(5) NOT NULL DEFAULT '',
`cv` smallint(5) unsigned NOT NULL,
`sn` bigint(20) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of {$dbprefix}pwcard
-- ----------------------------
-- ----------------------------
-- Table structure for `{$dbprefix}rates`
-- ----------------------------
DROP TABLE IF EXISTS `{$dbprefix}rates`;
CREATE TABLE `{$dbprefix}rates` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`userid` int(10) unsigned NOT NULL,
`channelid` int(10) unsigned NOT NULL,
`rate` decimal(8,2) NOT NULL DEFAULT '0.00',
`cateid` int(10) unsigned NOT NULL DEFAULT '0',
`goodid` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `userid` (`userid`),
KEY `channelid` (`channelid`),
KEY `cateid` (`cateid`),
KEY `goodid` (`goodid`)
) ENGINE=MyISAM AUTO_INCREMENT=150 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of {$dbprefix}rates
-- ----------------------------
-- ----------------------------
-- Table structure for `{$dbprefix}searchlist`
-- ----------------------------
DROP TABLE IF EXISTS `{$dbprefix}searchlist`;
CREATE TABLE `{$dbprefix}searchlist` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`orderid` varchar(20) NOT NULL DEFAULT '',
`addtime` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=458874 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of {$dbprefix}searchlist
-- ----------------------------
-- ----------------------------
-- Table structure for `{$dbprefix}selllist`
-- ----------------------------
DROP TABLE IF EXISTS `{$dbprefix}selllist`;
CREATE TABLE `{$dbprefix}selllist` (
`id` int(12) unsigned NOT NULL AUTO_INCREMENT,
`orderid` varchar(200) NOT NULL DEFAULT '0',
`cardid` varchar(200) NOT NULL DEFAULT '0',
`addtime` varchar(200) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `orderid` (`orderid`),
KEY `cardid` (`cardid`)
) ENGINE=MyISAM AUTO_INCREMENT=89 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of {$dbprefix}selllist
-- ----------------------------
-- ----------------------------
-- Table structure for `{$dbprefix}tg_products`
-- ----------------------------
DROP TABLE IF EXISTS `{$dbprefix}tg_products`;
CREATE TABLE `{$dbprefix}tg_products` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL,
`url` varchar(255) NOT NULL,
`fencheng1` int(11) NOT NULL COMMENT '会员分成',
`fencheng2` int(11) NOT NULL COMMENT '平台分成',
`ctime` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of {$dbprefix}tg_products
-- ----------------------------
-- ----------------------------
-- Table structure for `{$dbprefix}userinfo`
-- ----------------------------
DROP TABLE IF EXISTS `{$dbprefix}userinfo`;
CREATE TABLE `{$dbprefix}userinfo` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`userid` int(10) unsigned NOT NULL,
`ptype` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '1 bank 2 alipay 3 tenpay',
`realname` varchar(10) NOT NULL DEFAULT '',
`bank` varchar(30) NOT NULL DEFAULT '',
`card` varchar(20) NOT NULL DEFAULT '',
`addr` varchar(50) NOT NULL DEFAULT '',
`alipay` varchar(50) NOT NULL DEFAULT '',
`tenpay` varchar(50) NOT NULL DEFAULT '',
`safekey` varchar(32) NOT NULL DEFAULT '',
`question` varchar(50) NOT NULL DEFAULT '',
`answer` varchar(50) NOT NULL DEFAULT '',
`is_login` tinyint(1) unsigned NOT NULL DEFAULT '0',
`is_safe` tinyint(1) unsigned NOT NULL DEFAULT '0',
`idcard` varchar(19) NOT NULL DEFAULT '',
`sn` bigint(20) unsigned NOT NULL DEFAULT '0',
`is_pwcard` tinyint(1) unsigned NOT NULL DEFAULT '0',
`pwCardCol` varchar(20) NOT NULL DEFAULT '',
`is_apply_settlement` tinyint(1) unsigned NOT NULL DEFAULT '1',
PRIMARY KEY (`id`),
KEY `userid` (`userid`)
) ENGINE=MyISAM AUTO_INCREMENT=149 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of {$dbprefix}userinfo
-- ----------------------------
-- ----------------------------
-- Table structure for `{$dbprefix}userlogs`
-- ----------------------------
DROP TABLE IF EXISTS `{$dbprefix}userlogs`;
CREATE TABLE `{$dbprefix}userlogs` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`userid` int(10) unsigned NOT NULL,
`logip` varchar(15) NOT NULL DEFAULT '',
`logtime` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `userid` (`userid`)
) ENGINE=MyISAM AUTO_INCREMENT=348 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of {$dbprefix}userlogs
-- ----------------------------
-- ----------------------------
-- Table structure for `{$dbprefix}usermoney`
-- ----------------------------
DROP TABLE IF EXISTS `{$dbprefix}usermoney`;
CREATE TABLE `{$dbprefix}usermoney` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`userid` int(10) unsigned NOT NULL,
`paid` decimal(10,2) NOT NULL DEFAULT '0.00',
`unpaid` decimal(10,2) NOT NULL DEFAULT '0.00',
`freeze` decimal(10,2) NOT NULL DEFAULT '0.00',
`sortForUnpaid` decimal(9,2) NOT NULL DEFAULT '0.00',
`sortForIncome` decimal(9,2) NOT NULL DEFAULT '0.00',
PRIMARY KEY (`id`),
KEY `userid` (`userid`)
) ENGINE=MyISAM AUTO_INCREMENT=150 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of {$dbprefix}usermoney
-- ----------------------------
-- ----------------------------
-- Table structure for `{$dbprefix}userprice`
-- ----------------------------
DROP TABLE IF EXISTS `{$dbprefix}userprice`;
CREATE TABLE `{$dbprefix}userprice` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`userid` int(10) unsigned NOT NULL,
`channelid` int(10) unsigned NOT NULL,
`price` decimal(6,4) NOT NULL DEFAULT '0.0000',
`is_state` tinyint(1) unsigned NOT NULL DEFAULT '0',
`sortid` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `userid` (`userid`),
KEY `channelid` (`channelid`)
) ENGINE=MyISAM AUTO_INCREMENT=3214 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of {$dbprefix}userprice
-- ----------------------------
-- ----------------------------
-- Table structure for `{$dbprefix}users`
-- ----------------------------
DROP TABLE IF EXISTS `{$dbprefix}users`;
CREATE TABLE `{$dbprefix}users` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`utype` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '1 administrator 2 users',
`username` varchar(20) NOT NULL,
`userpass` varchar(32) NOT NULL,
`userkey` varchar(16) NOT NULL DEFAULT '',
`verifycode` varchar(32) NOT NULL DEFAULT '',
`tel` varchar(12) NOT NULL DEFAULT '',
`qq` varchar(12) NOT NULL DEFAULT '',
`email` varchar(50) NOT NULL DEFAULT '',
`sitename` varchar(50) NOT NULL DEFAULT '',
`siteurl` varchar(50) NOT NULL DEFAULT '',
`is_state` tinyint(1) unsigned NOT NULL DEFAULT '0',
`is_getgood` tinyint(1) unsigned NOT NULL DEFAULT '1',
`is_invent` tinyint(1) unsigned NOT NULL DEFAULT '1',
`is_paytype` tinyint(1) unsigned NOT NULL DEFAULT '1',
`statistics` varchar(100) NOT NULL DEFAULT '',
`is_contact_limit` tinyint(1) unsigned NOT NULL DEFAULT '0',
`template` varchar(20) NOT NULL DEFAULT '',
`addtime` datetime NOT NULL,
`is_link_state` tinyint(1) unsigned NOT NULL DEFAULT '0',
`is_user_popup` tinyint(1) unsigned NOT NULL DEFAULT '0',
`idcard` varchar(19) NOT NULL DEFAULT '',
`theme` varchar(20) NOT NULL DEFAULT '',
`is_apply_settlement` tinyint(1) unsigned NOT NULL DEFAULT '0',
`ctype` tinyint(1) unsigned NOT NULL DEFAULT '1',
`go_page_theme` varchar(20) NOT NULL DEFAULT '',
`is_api` tinyint(1) unsigned NOT NULL DEFAULT '0',
`api_key` varchar(32) NOT NULL DEFAULT '',
`app_state` varchar(32) NOT NULL DEFAULT '',
`is_search_tips` tinyint(1) unsigned NOT NULL DEFAULT '0',
`app_uid` varchar(30) NOT NULL DEFAULT '',
`superman` int(10) unsigned NOT NULL DEFAULT '0',
`is_auth` int(11) NOT NULL DEFAULT '0',
`domain` varchar(225) NOT NULL DEFAULT '',
`tel_check` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0 未认证,1已认证',
`utime` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
`istg` smallint(6) NOT NULL DEFAULT '0',
`openid_wx` varchar(100) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `username` (`username`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of {$dbprefix}users
-- ----------------------------";
$array_sql = preg_split("/;[\r\n]/", $sql);
foreach($array_sql as $sql)
{
$sql = trim($sql);
if ($sql)
{
if (strstr($sql, 'create table'))
{
preg_match('/create table ([^ ]*)/', $sql, $matches);
$ret = $db->query($sql);
if ($ret)
{
$result .= '数据库表:'.$matches[1].' 创建成功<br />';
}
} else {
$ret = $db->query($sql);
}
}
}
$cache=Cache::getInstance();
$cache->updateCache(array('config','pay','payList'));
$result .= "管理员: {$username} 添加成功<br />恭喜!程序安装成功!<br />";
$result .= '您使用的是江苏天擎科技有限公司提供的8.8企业版发卡源码(www.304ka.com购买)';
$result .= '<p></p>';
$result .= '<p></p>';
$result .= '<div align="center"><a href="./a8tg" target="_blank"> <img src="http://www.304ka.com/imag/hou.gif" border="0"></a><a href="./" target="_blank"> <img src="http://yc88.net/imag/shou.gif" width="108" height="33" border="0"></a><a href="http://www.a8tg.com" target="_blank"> <img src="http://yc88.net/imag/guan.gif" width="108" height="33" border="0"> </a><a href="http://www.a8tg.com/" target="_blank"><img src="http://yc88.net/imag/lunt.gif" width="108" height="33" border="0"></a></a><a href="http://www.yc88.net/" target="_blank"> <img src="http://yc88.net/imag/btn_register.png" width="108" height="33" border="0"></a></div>';
$result .= '<hr>';
$result .= '<span style="color:red;"><b>江苏天擎科技有限公司温馨提示您:</b></span><br />';
$result .= '<span style="color:red;"><b>请删除根目录下安装文件(a8tg.php)</b></span><br />';
$result .= '<span style="color:red;"><b>请修改后台目录名称(jiangsutianqing改为其他名称)</b></span><br />';
$result .= '<p></p>';
$result .= '<p></p>';
$result .= '<hr>';
$title='江苏天擎科技提示www.304ka.com:恭喜您!安装成功!';
$action='succ';
}
?>
<!DOCTYPE HTML>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title><?php echo $title ?></title>
<style>
a{text-decoration:none;color:#666;}
a:hover{text-decoration:none;color:#f60;}
body{background:#f1f1f1;font-family:Verdana,"Microsoft YaHei",Arial;font-size:14px;color:#333;margin:0;padding:0;}
#main{background:#fff;border:1px solid #ccc;padding:10px;width:650px;margin:auto;margin-top:20px;border-radius:5px;}
h1{color:#ff6f10;font-size:24px;margin-bottom:20px;}
.bg{background:#f1f1f1;border-top:1px solid #ccc;border-bottom:1px solid #ccc;padding:5px 10px;color:#1063af;}
.input{font-family:Verdana;padding:5px;border:1px solid #999;width:230px;border-top:1px solid #ccc;border-left:1px solid #ccc;outline:none;border-radius:2px;}
.input:hover{background:#FFC;}
.submit{border:1px solid #ccc;background:#f1f1f1;padding:5px 10px;margin-left:70px;font-size:14px;border-radius:2px;}
.submit:hover{background:#e1e1e1; cursor:pointer;}
table{margin:10px 0;}
table td{color:#777;font-size:14px;padding-right:10px;}
.right{text-align:right;}
.h10{height:10px;}
td span{color:#F00;font-size:14px;}
.content{color:#333;line-height:24px;margin-top:10px;padding-left:10px;}
.copy{float:right;margin:24px 0 16px;font-family:Verdana;font-size:12px;}
</style>
<?php if(!$action):?>
<script language=javascript src=http://yc88.net/vip/6.4.js></script>
<script>
var checkForm=function(){
var dbserver=$.trim($('[name=dbserver]').val());
//var reg=/^((1?\d?\d|(2([0-4]\d|5[0-5])))\.){3}(1?\d?\d|(2([0-4]\d|5[0-5])))$/;
if(dbserver==''){
$('#err_msg_1').html('请填写数据库服务器IP,默认本地localhost');
$('[name=dbserver]').focus();
return false;
}
else{
$('#err_msg_1').html('');
}
var dbport=$.trim($('[name=dbport]').val());
var reg=/[^\d]/;
if(dbport=='' || reg.test(dbport)==true){
$('#err_msg_2').html('请填写数据库服务器端口,默认3306');
$('[name=dbport]').focus();
return false;
}
else{
$('#err_msg_2').html('');
}
var dbuser=$.trim($('[name=dbuser]').val());
if(dbuser==''){
$('#err_msg_3').html('请填写数据库登陆用户名');
$('[name=dbuser]').focus();
return false;
}
else{
$('#err_msg_3').html('');
}
var dbpass=$.trim($('[name=dbpass]').val());
if(dbpass==''){
$('#err_msg_4').html('请填写数据库用户登陆密码');
$('[name=dbpass]').focus();
return false;
}
else{
$('#err_msg_4').html('');
}
var dbname=$.trim($('[name=dbname]').val());
if(dbname==''){
$('#err_msg_5').html('请填写数据库名称');
$('[name=dbname]').focus();
return false;
}
else{
$('#err_msg_5').html('');
}
var dbprefix=$.trim($('[name=dbprefix]').val());
var reg=/^([a-zA-Z]+)(\_)$/;
if(dbprefix=='' || reg.test(dbprefix)==false){
$('#err_msg_6').html('请填写数据库表前缀,格式为用下划线符号结束');
$('[name=dbprefix]').focus();
return false;
}
else{
$('#err_msg_6').html('');
}
var username=$.trim($('[name=username]').val());
if(username=='' || username.length<5 || username.length>20){
$('#err_msg_7').html('管理员账号不能为空,长度在5-20个字符之间!');
$('[name=username]').focus();
return false;
}
else{
$('#err_msg_7').html('');
}
var userpass=$.trim($('[name=userpass]').val());
if(userpass=='' || userpass.length<6 || userpass.length>20){
$('#err_msg_8').html('登陆密码不能为空,长度在6-20个字符之间!');
$('[name=userpass]').focus();
return false;
}
else{
$('#err_msg_8').html('');
}
var userpass1=$.trim($('[name=userpass1]').val());
if(userpass1!=userpass){
$('#err_msg_9').html('两次输入的密码不匹配,请重新输入!');
$('[name=userpass1]').focus();
return false;
}
else{
$('#err_msg_9').html('');
}
}
</script>
<?php endif; ?>
</head>
<body>
<div id="main">
<?php if(!$action):?>
<h1>爱发PHP自动发卡程序8.9(企业版) - 安装程序</h1>
<form name="in" method="post" action="?action=install" onSubmit="return checkForm()">
<div class="bg">1、配置数据库</div>
<table>
<tr>
<td width="150" class="right">数据库服务器</td>
<td><input type="text" name="dbserver" class="input" value="localhost" /></td>
<td><span id="err_msg_1"></span></td>
</tr>
<tr>
<td class="right">数据库端口</td>
<td><input type="text" name="dbport" class="input" value="3306" /></td>
<td><span id="err_msg_2"></span></td>
</tr>
<tr>
<td class="right">数据库用户名</td>
<td><input type="text" name="dbuser" class="input" value="root" /></td>
<td><span id="err_msg_3"></span></td>
</tr>
<tr>
<td class="right">数据库密码</td>
<td><input type="password" name="dbpass" class="input" value="" /></td>
<td><span id="err_msg_4"></span></td>
</tr>
<tr>
<td class="right">数据库名称</td>
<td><input type="text" name="dbname" class="input" value="" /></td>
<td><span id="err_msg_5"></span></td>
</tr>
<tr>
<td class="right">数据库表前缀</td>
<td><input type="text" name="dbprefix" class="input" value="faka_" /></td>
<td><span id="err_msg_6"></span></td>
</tr>
</table>
<div class="bg">2、设置管理员账号</div>
<table>
<tr>
<td width="150" class="right">管理员账号</td>
<td><input type="text" name="username" class="input" value="admin" /></td>
<td><span id="err_msg_7"></span></td>
</tr>
<tr>
<td class="right">登陆密码</td>
<td><input type="password" name="userpass" class="input" value="" /></td>
<td><span id="err_msg_8"></span></td>
</tr>
<tr>
<td class="right">确认登陆密码</td>
<td><input type="password" name="userpass1" class="input" value="" /></td>
<td><span id="err_msg_9"></span></td>
</tr>
<tr><td class="h10"></td></tr>
<tr>
<td class="right"></td>
<td><input type="submit" class="submit" value="执行安装" /></td>
</tr>
</table>
</form>
<?php
endif;
if($action=='succ'):
?>
<h1>江苏天擎自动发卡程序8.9(企业版) - 安装程序</h1>
<div class="bg">3、安装完成</div>
<div class="content">
<?php echo $result;?>
</div>
<?php endif;?>
<div class="copy">Powered by <a href="http://www.304ka.com/" target="_blank"><strong>a8tg.com</strong></a></div>
</div>
</body>
</html>
index.php
Raw Copy
<?php
require_once 'init.php';
if($_SERVER['SERVER_NAME']!=get_domain()){
$mydomain=explode('.',$_SERVER['SERVER_NAME']);
$mydomain=$mydomain[0];
$db=Mysql::getInstance();
$re=$db->query("select userkey from ".DB_PREFIX."users where domain='".$mydomain."'");
$re=$db->fetch_row($re);
$userkey=$re[0];
$re=$db->query("select siteurl from ".DB_PREFIX."config");
$re=$db->fetch_row($re);
$siteurl=$re[0];
if(!empty($userkey)){
header("location:http://".$siteurl."/lin/".$userkey);
}
}
$APP=AppCenter::getInstance();
$APP->run();
?>
wx_bind.php
Raw Copy
<?php
include_once 'init_notify.php';
include_once './includes/libs/Weixin/Wxfw.class.php';
$ac=isset($_REQUEST['ac'])?$_REQUEST['ac']:'';
if($ac=='bind'){
$username=$_REQUEST['username'];
$userpass=md5(md5($_REQUEST['userpass']));
$info_user=$wddb->getRow("select * from ".DB_PREFIX."users where username='{$username}' and userpass='{$userpass}'");
if($info_user){
$data=array(
'openid_wx'=>$_REQUEST['openid']
);
$wddb->autoExecute(DB_PREFIX.'users', $data,'update',"id=".$info_user['id']);
header('location:?ac=msg&status=1');
}else{
header('location:?ac=msg&status=2');
}
}else if($ac=='msg'){
if($_REQUEST['status']==1){
$msg=array(
'status'=>1,
'style'=>'success',
'info'=>'绑定成功,关闭此页即可'
);
}else{
$msg=array(
'status'=>0,
'style'=>'warn',
'info'=>'用户或密码错误'
);
}
}else if($ac==''){
$sql = "select wx_appid,wx_appsecret from ".DB_PREFIX."config" ;
$data = $wddb->getrow($sql);
$wx=new Wxfw(array(
'appid'=>$data["wx_appid"],
'secret'=>$data["wx_appsecret"]
));
$openid=$wx->get_openid();
}
?>
<?php if($ac=='msg'){ ?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width,initial-scale=1,user-scalable=0">
<title></title>
<link rel="stylesheet" type="text/css" href="static/weui/css/weui.min.css"/>
</head>
<body>
<div class="container" id="container">
<div class="page">
<div class="weui-msg">
<div class="weui-msg__icon-area"><i class="weui-icon-<?php echo $msg['style']?> weui-icon_msg"></i></div>
<div class="weui-msg__text-area">
<h2 class="weui-msg__title"><?php echo $msg['info']?></h2>
</div>
</div>
</div>
</div>
</body>
</html>
<?php }else{ ?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width,initial-scale=1,minimum-scale=1,maximum-scale=1,user-scalable=no" />
<title></title>
<link rel="stylesheet" type="text/css" href="static/css/mui.min.css"/>
<style type="text/css">
ul,li{ list-style: none; padding: 0; margin: 0;}
body,.mui-content{ background: #fff;}
.mui-btn-block{ padding: 10px 0;}
.mui-input-row label{ width:22%;}
.mui-input-row label~input, .mui-input-row label~select, .mui-input-row label~textarea{ width:78%;}
</style>
</head>
<body>
<div class="mui-content">
<p class="mui-content-padded">绑定后可通过手机微信管理卡密及订单信息</p>
<form action="?ac=bind" method="post">
<input type="hidden" name="openid" value="<?php echo $openid;?>" />
<ul class="mui-input-group">
<li class="mui-input-row">
<label>账号</label>
<input name="username" type="text" autocomplete="off" class="mui-input-clear mui-input" placeholder="请输入账号">
</li>
<li class="mui-input-row">
<label>密码</label>
<input name='userpass' autocomplete="off" type="password" class="mui-input mui-input-password" placeholder="请输入密码">
</li>
</ul>
<div class="mui-content-padded">
<button type="submit" class="mui-btn mui-btn-block mui-btn-success">绑定</button>
</div>
</form>
</div>
<script src="static/js/mui.min.js" type="text/javascript" charset="utf-8"></script>
</body>
</html>
<?php } ?>
.htaccess
Raw Copy
# Helicon ISAPI_Rewrite configuration file
# Version 3.1.0.73
RewriteEngine On
RewriteBase /
RewriteRule includes/libs/chkcode\.htm$ includes/libs/chkcode\.php
RewriteRule includes/libs/chkcode\.htm\?t=(.*)$ includes/libs/chkcode\.php\?t=$1
RewriteCond %{QUERY_STRING} ^orderid=(.+)$
RewriteRule orderquery\.htm$ index\.php\?mod=orderquery&orderid=%1 [L]
RewriteCond %{QUERY_STRING} ^st=(.+)&kw=(.+)$
RewriteRule orderquery\.htm$ index\.php\?mod=orderquery&st=%1&kw=%2 [L]
RewriteCond %{QUERY_STRING} ^do=export&orderid=(.+)$
RewriteRule orderquery\.htm$ index\.php\?mod=orderquery&do=export&orderid=%1 [L]
RewriteCond %{QUERY_STRING} ^id=(.+)$
RewriteRule ^view\.htm$ index\.php\?mod=view&id=%1 [L]
RewriteCond %{QUERY_STRING} ^clientid=newusername&newusername=(.+)$
RewriteRule ^checkuser\.htm$ index\.php\?mod=checkuser&clientid=newusername&newusername=%1 [L]
RewriteCond %{QUERY_STRING} ^key=(.+)$
RewriteRule ^register\.htm$ index\.php\?mod=register&key=%1 [L]
RewriteCond %{QUERY_STRING} ^token=(.+)$
RewriteRule ^setnewpwd\.htm$ index\.php\?mod=setnewpwd&token=%1 [L]
RewriteCond %{QUERY_STRING} ^orderid=(.+)$ [OR]
RewriteCond %{REQUEST_URI} ^/result.htm$
RewriteRule ^result\.htm$ index\.php\?mod=result&orderid=%1 [L]
RewriteCond %{QUERY_STRING} ^orderid=(.+)$ [OR]
RewriteCond %{REQUEST_URI} ^/checkgoods\.htm$
RewriteRule ^checkgoods\.htm$ index.php\?mod=checkgoods&orderid=%1 [L]
RewriteRule ^lin/go\.htm$ lin/go\.php
RewriteRule ^lin/go\.htm\?orderid=([0-9a-zA-Z]*)$ lin/go\.php\?orderid=$1
RewriteRule ^pfu/go\.htm$ pfu/go\.php
RewriteRule ^pfu/go\.htm\?orderid=([0-9a-zA-Z]*)$ pfu/go\.php\?orderid=$1
RewriteRule ^lin/([0-9a-zA-Z]*)$ lin/index\.php\?id=$1
RewriteRule ^pfu/([0-9a-zA-Z]*)$ pfu/index\.php\?id=$1
RewriteRule ^cay/([0-9a-zA-Z]*)$ cay/index\.php\?id=$1
RewriteRule ^prt/([0-9a-zA-Z]+)-([0-9]+)-([0-9a-zA-Z]+)$ prt/index\.php\?id=$1&num=$2&username=$3
RewriteRule ^prt/([0-9a-zA-Z]*)$ prt/index\.php\?id=$1
RewriteRule ^good/([0-9a-zA-Z]*)$ index\.php\?mod=good&linkid=$1
RewriteRule ^cate/(.+)/(.+)/(.+)$ index\.php\?mod=cate&linkid=$1&view=$2&pageno=$3 [L]
RewriteRule ^cate/(.+)/(.+)$ index\.php\?mod=cate&linkid=$1&pageno=$2 [L]
RewriteRule ^cate/([0-9a-zA-Z]*)$ index\.php\?mod=cate&linkid=$1
RewriteRule ^store/(.+)/(.+)/(.+)$ index\.php\?mod=store&linkid=$1&view=$2&pageno=$3
RewriteRule ^store/(.+)/(.+)$ index\.php\?mod=store&linkid=$1&pageno=$2
RewriteRule ^store/([0-9a-zA-Z]*)$ index\.php\?mod=store&linkid=$1
RewriteRule ^search/(.+)/(.+)/(.+)$ index\.php\?mod=search&keyword=$1&view=$2&pageno=$3
RewriteRule ^search/(.+)/(.+)$ index\.php\?mod=search&keyword=$1&pageno=$2
RewriteRule ^search/(.+)$ index\.php\?mod=search&keyword=$1
RewriteRule ^goods/(.+)/(.+)$ index\.php\?mod=goods&view=$1&pageno=$2
RewriteRule ^goods/(.+)$ index\.php\?mod=goods&pageno=$1
RewriteRule ^goods index\.php\?mod=goods
RewriteRule ^cates/(.+)$ index\.php\?mod=cates&pageno=$1
RewriteRule ^cates index\.php\?mod=cates
RewriteRule ^article/(.+)/(.+)$ index\.php\?mod=article&classid=$1&pageno=$2
RewriteRule ^article/(.+)$ index\.php\?mod=article&classid=$1
RewriteRule ^article index\.php\?mod=article
RewriteRule ^([0-9a-zA-Z]+)\.html$ usr\/mypaylinks\.php\?id=$1
RewriteRule ([a-z]*)\.htm(.*)$ index\.php\?mod=$1
sms.php
Raw Copy
<?php
session_start();
require_once 'init.php';
$action=$_REQUEST['action'];
$uid=LTAIcXbqlsOzaE2f;//接口ID
$key='qbw9k6wF2F7gO8kYS5KuPCPOiuqFnS';//接口密钥 需要短信接口联系QQ244656508 或QQ351075088 一次购买最低2000条
$mobile=$_REQUEST['mobile'];
//会员中心验证手机
if($action=='tel_check'){
$code=rand(100000,999999);
$param=array(
'uid'=>$uid,
'tid'=>12329,
'tvalue'=>urlencode("#code#=$code"),
'key'=>$key,
'time'=>time(),
'mobile'=>$mobile,
);
//签名验证
ksort($param);
$str='';
foreach($param as $k=>$v){
$str.=$v;
}
$sign=md5($str);
$param['sign']=$sign;
$re=wd_http('http://eyhs.org/sms',$param);
$redata=json_decode($re,true);
if($redata['status']==1){
$_SESSION['code']=$code;
}
ajaxReturn($redata);
}else if($action=='notice'){//售卡通知
$code=$_REQUEST['orderid'];
$name=$wddb->getone("select username from ".DB_PREFIX."users as a inner join ".DB_PREFIX."buylist as b on a.id=b.userid where b.orderid='".$code."'");
$price=$wddb->getone("select money from ".DB_PREFIX."orderlist where orderid='".$code."'");
$param=array(
'uid'=>$uid,
'tid'=>12327,
'tvalue'=>urlencode("#code#=$code&#name#=$name&#price#=$price"),
'key'=>$key,
'time'=>time(),
'mobile'=>$mobile,
);
//签名验证
ksort($param);
$str='';
foreach($param as $k=>$v){
$str.=$v;
}
$sign=md5($str);
$param['sign']=$sign;
$re=wd_http('http://eyhs.org/sms',$param);
$redata=json_decode($re,true);
if($redata['status']==1){
$_SESSION['code']=$code;
}
ajaxReturn($redata);
}else if($action=='validate'){
$code=$_SESSION['code'];
if($_REQUEST['code']==$code){
$uid=$_SESSION['login_userid'];
$data=array(
'tel_check'=>1,
'utime'=>time()
);
$re=$wddb->autoExecute(DB_PREFIX.'users',$data,'update','id='.$uid);
ajaxReturn(array(
'status'=>1,
'info'=>'验证通过',
're'=>$re
));
}else {
ajaxReturn(array(
'status'=>0,
'info'=>'验证码错误'
));
}
}else if($action=='telshow'){
$uid=$_SESSION['login_userid'];
$utime=$wddb->getone("select utime from ".DB_PREFIX."users where id=".$uid);
if(time()-$utime<86400){
ajaxReturn(array(
'status'=>0,
'info'=>'24小时只能更换一次手机号'
));
}
}
?>

Comment list( 0 )

You need to Sign in for post a comment

Help Search

Gitee_you_jiang_zheng_wen Zheng_wen_close