NN2023032801/update.php

<?
//代码不要删除，只有不断添加及修改，老的不能删除
include("config/conn.php");
include("config/function.php");

$zfstr=" DEFAULT CHARSET=utf8";

$sql="ALTER TABLE yjcode_user ADD openshop1 int(10) null";mysql_query($sql);
$sql="ALTER TABLE yjcode_pro ADD downurl varchar(250) null";mysql_query($sql);

$sql="CREATE TABLE IF NOT EXISTS yjcode_chajian(
id int NOT NULL AUTO_INCREMENT,
PRIMARY KEY(id),
bh char(50) null,
sj datetime null,
cjbh char(50) null,
tit char(50) null,
txt text null,
var1 text null,
var2 text null,
var3 text null,
zt int(10) null
)".$zfstr;mysql_query($sql);
$sql="ALTER TABLE yjcode_kuaidi ADD kdbh varchar(100) null";mysql_query($sql);

$sql="ALTER TABLE yjcode_type ADD propx int(10) null";mysql_query($sql);
$sql="ALTER TABLE yjcode_user ADD mybh char(50) null";mysql_query($sql);
$sql="alter table yjcode_control drop column propx";mysql_query($sql);
delFile("m/user/orderclose.php");
delFile("m/index.php");

$sql="ALTER TABLE yjcode_control ADD qzmot int(10) null";mysql_query($sql);
$sql="ALTER TABLE yjcode_control ADD ipzcnum int(10) null";mysql_query($sql);
$sql="ALTER TABLE yjcode_control ADD ipnewsnum int(10) null";mysql_query($sql);
$sql="ALTER TABLE yjcode_user ADD jbmot char(50) null";mysql_query($sql);
$sql="CREATE TABLE IF NOT EXISTS yjcode_guolv(
id int NOT NULL AUTO_INCREMENT,
PRIMARY KEY(id),
bh char(50) null,
admin int(10) null,
tit char(50) null,
ip1 char(10) null,
ip2 char(10) null,
ip3 char(10) null,
ip4 char(10) null,
txt text null,
sj datetime null,
zt int(10) null
)".$zfstr;mysql_query($sql);
$sql="alter table yjcode_pro MODIFY upf varchar(250)";mysql_query($sql);
$sql="ALTER TABLE yjcode_user ADD ifmian int(10) null";mysql_query($sql);
$sql="ALTER TABLE yjcode_control ADD ifopenshop char(10) null DEFAULT 'on'";mysql_query($sql);
$sql="ALTER TABLE yjcode_control ADD alipaywap text null";mysql_query($sql);
$sql="ALTER TABLE yjcode_user MODIFY bdemail char(50)";mysql_query($sql);
$sql="ALTER TABLE yjcode_control ADD mrbuy int(10) null";mysql_query($sql);

$sql="CREATE TABLE IF NOT EXISTS yjcode_wenda(
id int NOT NULL AUTO_INCREMENT,
PRIMARY KEY(id),
bh char(50) null,
probh char(50) null,
userid int(10) null,
selluserid int(10) null,
sj datetime null,
hfsj datetime null,
uip char(50) null,
txt text null,
hftxt text null
)".$zfstr;mysql_query($sql);
$sql="ALTER TABLE yjcode_propj ADD ifvideo int(10) null";mysql_query($sql);

$sql="ALTER TABLE yjcode_moneyrecord ADD jyh varchar(200) null";mysql_query($sql);

$sql="ALTER TABLE yjcode_tp ADD upty int(10) null";mysql_query($sql);
$sql="ALTER TABLE yjcode_control ADD aliosskg varchar(200) null";mysql_query($sql);

$sql="ALTER TABLE yjcode_control ADD ifclose int(10) null";mysql_query($sql);
$sql="ALTER TABLE yjcode_control ADD closesm varchar(250) null";mysql_query($sql);
$sql="ALTER TABLE yjcode_control ADD ifserver char(10) null DEFAULT 'off'";mysql_query($sql);
$sql="ALTER TABLE yjcode_control ADD serversellbl float null DEFAULT 1";mysql_query($sql);
$sql="CREATE TABLE IF NOT EXISTS yjcode_servertype(
id int NOT NULL AUTO_INCREMENT,
PRIMARY KEY(id),
bh char(50) null,
admin int(10) null,
name1 char(50) null,
name2 char(50) null,
sj datetime null,
xh int(10) null,
zt int(10) null
)".$zfstr;mysql_query($sql);
$sql="CREATE TABLE IF NOT EXISTS yjcode_server(
id int NOT NULL AUTO_INCREMENT,
PRIMARY KEY(id),
bh char(50) null,
mybh char(50) null,
userid int(10) null,
sj datetime null,
lastsj datetime null,
uip char(50) null,
ty1id int(10) null,
ty2id int(10) null,
tit varchar(250) null,
txt text null,
wdes varchar(250) null,
wkey varchar(250) null,
djl int(10) null,
xsnum int(10) null,
money1 float null,
pf1 int(10) null,
pf2 int(10) null,
pf3 int(10) null,
iftp int(10) null,
ifxj int(10) null,
zt int(10) null,
ztsm varchar(250) null,
iftj int(10) null
)".$zfstr;mysql_query($sql);
$sql="CREATE TABLE IF NOT EXISTS yjcode_serverorder(
id int NOT NULL AUTO_INCREMENT,
PRIMARY KEY(id),
serverbh char(50) null,
orderbh char(50) null,
selluserid int(10) null,
userid int(10) null,
tit varchar(250) null,
num int(10) null,
money1 float null,
money2 float null,
money3 float null,
sj datetime null,
uip char(50) null,
taocan varchar(250) null,
txt text null,
ddzt int(10) null,
ifpj int(10) null
)".$zfstr;mysql_query($sql);
$sql="CREATE TABLE IF NOT EXISTS yjcode_serverorderlog(
id int NOT NULL AUTO_INCREMENT,
PRIMARY KEY(id),
orderbh char(50) null,
userid int(10) null,
selluserid int(10) null,
admin int(10) null,
txt text null,
sj datetime null,
fj varchar(250) null
)".$zfstr;mysql_query($sql);
$sql="CREATE TABLE IF NOT EXISTS yjcode_serverpj(
id int NOT NULL AUTO_INCREMENT,
PRIMARY KEY(id),
serverbh char(50) null,
orderbh char(50) null,
selluserid int(10) null,
userid int(10) null,
sj datetime null,
uip char(50) null,
pf1 int(10) null,
pf2 int(10) null,
pf3 int(10) null,
txt text null,
hf text null,
hfsj datetime null,
pjlx int(10) null,
iftp int(10) null,
ifvideo int(10) null
)".$zfstr;mysql_query($sql);
$sql="ALTER TABLE yjcode_control MODIFY serversellbl float null";mysql_query($sql);
$sql="ALTER TABLE yjcode_control ADD ucstr varchar(250) null";mysql_query($sql);
$sql="ALTER TABLE yjcode_control ADD smsbig int(10) null DEFAULT 30";mysql_query($sql);
$sql="CREATE TABLE IF NOT EXISTS yjcode_smsmaillog(
id int NOT NULL AUTO_INCREMENT,
PRIMARY KEY(id),
admin int(10) null,
fa varchar(200) null,
userid int(10) null,
txt varchar(200) null,
sj int(10) null,
uip char(50) null
)".$zfstr;mysql_query($sql);
$sql="CREATE TABLE IF NOT EXISTS yjcode_servertaocan(
id int NOT NULL AUTO_INCREMENT,
PRIMARY KEY(id),
money1 float null,
money2 float null,
xh int(10) null,
serverbh char(50) null,
tit1 varchar(200) null,
tit2 varchar(200) null,
userid int(10) null,
admin int(10) null,
zt int(10) null
)".$zfstr;mysql_query($sql);
$sql="ALTER TABLE yjcode_pro ADD admintj int(10) null";mysql_query($sql);
deletetable("yjcode_txtmb where mbid='002'");
$t="无图模板";
$x="比较适合不需要图片展示的商品";
intotable("yjcode_txtmb","mbid,tit,txt,admin","'002','".$t."','".$x."',1");
delFile("product/viewmb.php");
delFile("product/view.js");
delFile("product/view.css");
delFile("product/jquery-plugin-slide.js");
$sql="ALTER TABLE yjcode_pro MODIFY txt longtext";mysql_query($sql);
$sql="ALTER TABLE yjcode_user MODIFY money1 double";mysql_query($sql);

intotable("yjcode_update","sj","'".getsj()."'");
createDir("upload/news/");
delFile("update.php");
?>
<h1>版本已经更新<br><font color='#ff0000'>注：请在空间上删除该文件。</font>(如不存在，说明已自动删除)</h1>