setup3.sql

来自「Nt Discuz论坛2.6版更改头部导航栏插件」· SQL 代码 · 共 18 行

INSERT INTO [dnt_goodscreditrules] VALUES(1,0,11,'sellercredit_1.gif','buyercredit_1.gif'); 
INSERT INTO [dnt_goodscreditrules] VALUES(2,12,40,'sellercredit_2.gif','buyercredit_2.gif'); 
INSERT INTO [dnt_goodscreditrules] VALUES(3,41,90,'sellercredit_3.gif','buyercredit_3.gif'); 
INSERT INTO [dnt_goodscreditrules] VALUES(4,91,150,'sellercredit_4.gif','buyercredit_4.gif'); 
INSERT INTO [dnt_goodscreditrules] VALUES(5,151,250,'sellercredit_5.gif','buyercredit_5.gif'); 
INSERT INTO [dnt_goodscreditrules] VALUES(6,251,500,'sellercredit_6.gif','buyercredit_6.gif'); 
INSERT INTO [dnt_goodscreditrules] VALUES(7,501,1000,'sellercredit_7.gif','buyercredit_7.gif'); 
INSERT INTO [dnt_goodscreditrules] VALUES(8,1001,2000,'sellercredit_8.gif','buyercredit_8.gif'); 
INSERT INTO [dnt_goodscreditrules] VALUES(9,2001,5000,'sellercredit_9.gif','buyercredit_9.gif'); 
INSERT INTO [dnt_goodscreditrules] VALUES(10,5001,10000,'sellercredit_10.gif','buyercredit_10.gif'); 
INSERT INTO [dnt_goodscreditrules] VALUES(11,10001,20000,'sellercredit_11.gif','buyercredit_11.gif'); 
INSERT INTO [dnt_goodscreditrules] VALUES(12,20001,50000,'sellercredit_12.gif','buyercredit_12.gif'); 
INSERT INTO [dnt_goodscreditrules] VALUES(13,50001,100000,'sellercredit_13.gif','buyercredit_13.gif'); 
INSERT INTO [dnt_goodscreditrules] VALUES(14,100001,200000,'sellercredit_14.gif','buyercredit_14.gif'); 
INSERT INTO [dnt_goodscreditrules] VALUES(15,200001,500000,'sellercredit_15.gif','buyercredit_15.gif'); 


UPDATE [dnt_forums] SET [istrade] = 0;