• 568阅读
  • 4回复

我兄弟杀手收集的SQL命令要看就回个帖 [复制链接]

上一主题 下一主题
离线angerne
 
发帖
78
祝福宝石
-1
威望
-1
玛雅之石
0
创造宝石
0
只看楼主 正序阅读 使用道具 楼主  发表于: 2006-07-16
Update item_Rare SET [Max] = [Max]*10 修改所有属性上限的一句话 M~t S *  
M~t S *  
[post] 下面是100级以上战绩组队,理论上可以混到298级, M~t S *  
我是以不打乱数据库里面数据为准哲,倒回去就可以回到你原来的设置。 M~t S *  
这样的设置方法是最理想的。 M~t S *  
下面是100级以上战绩组队的执行语句 M~t S *  
Update NPC_Lv2Exp SET max_tactic = max_tactic*3 M~t S *  
Update NPC_Lv2Exp_old SET max_tactic = max_tactic*3 M~t S *  
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ M~t S *  
M~t S *  
update BasicItemBage set M~t S *  
BasicItemPercentTableNo = BasicItemPercentTableNo*3 M~t S *  
M~t S *  
M~t S *  
update RareItemBab set M~t S *  
RareItemPercentTableNo = RareItemPercentTableNo*4 M~t S *  
M~t S *  
M~t S *  
FALL表凋落*2 M~t S *  
update ItemFallPercent set M~t S *  
per1 = per1 *2 , M~t S *  
per2 = per2 *2 , M~t S *  
per3 = per3 *2 , M~t S *  
per4 = per4 *2 , M~t S *  
per5 = per5 *2 , M~t S *  
per6 = per6 *2 , M~t S *  
per7 = per7 *2 , M~t S *  
per8 = per8 *2 , M~t S *  
per9 = per9 *2 , M~t S *  
per10 = per10 *2 , M~t S *  
per11 = per11 *2 , M~t S *  
per12 = per12 *2 , M~t S *  
per13 = per13 *2 , M~t S *  
per14 = per14 *2 , M~t S *  
per15 = per15 *2 , M~t S *  
per16 = per16 *2 , M~t S *  
per17 = per17 *2 , M~t S *  
per18 = per18 *2 , M~t S *  
per19 = per19 *2 , M~t S *  
per20 = per20 *2 M~t S *  
M~t S *  
M~t S *  
这是查你想知道的ID里所拥有的角色名 M~t S *  
select [name] from chr_info M~t S *  
where login_id = 'ID号' M~t S *  
M~t S *  
设置每30秒定时发公告 内容为XXX M~t S *  
update event_message set M~t S *  
[time] = 30 M~t S *  
message = 'XXX' M~t S *  
M~t S *  
M~t S *  
Update Chr_Info M~t S *  
M~t S *  
SET tac_skillEXP = 0x219C457D219C457D219C457D219C457D219C457D219C457D219C457D219C457D219C457D219C457D219C457D219C457D219C457D M~t S *  
Where (name = 'XXX') M~t S *  
战绩到顶 M~t S *  
M~t S *  
M~t S *  
Update NPC_Generation_SP SET NpcExp = NpcExp*10 M~t S *  
战绩到顶 M~t S *  
SET tac_skillEXP = 0x219C457D219C457D219C457D219C457D219C457D219C457D219C457D219C457D219C457D219C457D219C457D219C457D219C457D M~t S *  
Where (name = 'CHARNAME') M~t S *  
M~t S *  
M~t S *  
工作经验150 M~t S *  
Update skill_lvexp SET F2 = F2*50 M~t S *  
Update skill_lvexp SET F3 = F3*50 M~t S *  
Update skill_lvexp SET F4 = F4*50 M~t S *  
Update skill_lvexp SET F5 = F5*50 M~t S *  
Update skill_lvexp SET F6 = F6*50 M~t S *  
Update skill_lvexp SET F7 = F7*50 M~t S *  
Update skill_lvexp SET F8 = F8*50 M~t S *  
Update skill_lvexp SET F9 = F9*50 M~t S *  
Update skill_lvexp SET F10 = F10*50 M~t S *  
Update skill_lvexp SET F11 = F11*50 M~t S *  
Update skill_lvexp SET F12 = F12*50 M~t S *  
Update skill_lvexp SET F13 = F13*50 M~t S *  
Update skill_lvexp SET F14 = F14*50 M~t S *  
Update skill_lvexp SET F15 = F15*50 M~t S *  
Update skill_lvexp SET F16 = F16*50 M~t S *  
Update skill_lvexp SET F17 = F17*50 M~t S *  
Update skill_lvexp SET F18 = F18*50 M~t S *  
Update skill_lvexp SET F19 = F19*50 M~t S *  
Update skill_lvexp SET F20 = F20*50 M~t S *  
Update skill_lvexp SET F21 = F21*50 M~t S *  
Update skill_lvexp SET F22 = F22*50 M~t S *  
Update skill_lvexp SET F23 = F23*50 M~t S *  
Update skill_lvexp SET F24 = F24*50 M~t S *  
Update skill_lvexp SET F25 = F25*50 M~t S *  
Update skill_lvexp SET F26 = F26*50 M~t S *  
Update skill_lvexp SET F27 = F27*50 M~t S *  
Update skill_lvexp SET F28 = F28*50 M~t S *  
Update skill_lvexp SET F29 = F29*50 M~t S *  
Update skill_lvexp SET F30 = F30*50 M~t S *  
Update skill_lvexp SET F31 = F31*50 M~t S *  
Update skill_lvexp SET F32 = F32*50 M~t S *  
Update skill_lvexp SET F33 = F33*50 M~t S *  
Update skill_lvexp SET F34 = F34*50 M~t S *  
Update skill_lvexp SET F35 = F35*50 M~t S *  
Update skill_lvexp SET F36 = F36*50 M~t S *  
Update skill_lvexp SET F37 = F37*50 M~t S *  
Update skill_lvexp SET F38 = F38*50 M~t S *  
Update skill_lvexp SET F39 = F39*50 M~t S *  
Update skill_lvexp SET F40 = F40*50 M~t S *  
Update skill_lvexp SET F41 = F41*50 M~t S *  
Update skill_lvexp SET F42 = F42*50 M~t S *  
Update skill_lvexp SET F43 = F43*50 M~t S *  
Update skill_lvexp SET F44 = F44*50 M~t S *  
Update skill_lvexp SET F45 = F45*50 M~t S *  
Update skill_lvexp SET F46 = F46*50 M~t S *  
Update skill_lvexp SET F47 = F47*50 M~t S *  
Update skill_lvexp SET F48 = F48*50 M~t S *  
Update skill_lvexp SET F49 = F49*50 M~t S *  
Update skill_lvexp SET F50 = F50*50 M~t S *  
Update skill_lvexp SET F51 = F51*50 M~t S *  
Update skill_lvexp SET F52 = F52*50 M~t S *  
Update skill_lvexp SET F53 = F53*50 M~t S *  
Update skill_lvexp SET F54 = F54*50 M~t S *  
Update skill_lvexp SET F55 = F55*50 M~t S *  
Update skill_lvexp SET F56 = F56*50 M~t S *  
Update skill_lvexp SET F57 = F57*50 M~t S *  
Update skill_lvexp SET F58 = F58*50 M~t S *  
Update skill_lvexp SET F59 = F59*50 M~t S *  
Update skill_lvexp SET F60 = F60*50 M~t S *  
Update skill_lvexp SET F61 = F61*50 M~t S *  
Update skill_lvexp SET F62 = F62*50 M~t S *  
Update skill_lvexp SET F63 = F63*50 M~t S *  
Update skill_lvexp SET F64 = F64*50 M~t S *  
Update skill_lvexp SET F65 = F65*50 M~t S *  
Update skill_lvexp SET F66 = F66*50 M~t S *  
Update skill_lvexp SET F67 = F67*50 x@\'@>_GM  
Update skill_lvexp SET F68 = F68*50 x@\'@>_GM  
Update skill_lvexp SET F69 = F69*50 x@\'@>_GM  
Update skill_lvexp SET F70 = F70*50 x@\'@>_GM  
Update skill_lvexp SET F71 = F71*50 x@\'@>_GM  
Update skill_lvexp SET F72 = F72*50 x@\'@>_GM  
Update skill_lvexp SET F73 = F73*50 x@\'@>_GM  
Update skill_lvexp SET F74 = F74*50 x@\'@>_GM  
Update skill_lvexp SET F75 = F75*50 x@\'@>_GM  
Update skill_lvexp SET F76 = F76*50 x@\'@>_GM  
Update skill_lvexp SET F77 = F77*50 x@\'@>_GM  
Update skill_lvexp SET F78 = F78*50 x@\'@>_GM  
Update skill_lvexp SET F79 = F79*50 x@\'@>_GM  
Update skill_lvexp SET F80 = F80*50 x@\'@>_GM  
Update skill_lvexp SET F81 = F81*50 x@\'@>_GM  
Update skill_lvexp SET F82 = F82*50 x@\'@>_GM  
Update skill_lvexp SET F83 = F83*50 x@\'@>_GM  
Update skill_lvexp SET F84 = F84*50 x@\'@>_GM  
Update skill_lvexp SET F85 = F85*50 x@\'@>_GM  
Update skill_lvexp SET F86 = F86*50 x@\'@>_GM  
Update skill_lvexp SET F87 = F87*50 x@\'@>_GM  
Update skill_lvexp SET F88 = F88*50 x@\'@>_GM  
Update skill_lvexp SET F89 = F89*50 x@\'@>_GM  
Update skill_lvexp SET F90 = F90*50 x@\'@>_GM  
Update skill_lvexp SET F91 = F91*50 x@\'@>_GM  
Update skill_lvexp SET F92 = F92*50 x@\'@>_GM  
Update skill_lvexp SET F93 = F93*50 x@\'@>_GM  
Update skill_lvexp SET F94 = F94*50 x@\'@>_GM  
Update skill_lvexp SET F95 = F95*50 x@\'@>_GM  
Update skill_lvexp SET F96 = F96*50 x@\'@>_GM  
Update skill_lvexp SET F97 = F97*50 x@\'@>_GM  
Update skill_lvexp SET F98 = F98*50 x@\'@>_GM  
Update skill_lvexp SET F99 = F99*50 x@\'@>_GM  
Update skill_lvexp SET F100 = F100*50 x@\'@>_GM  
Update skill_lvexp SET F101 = F101*50 x@\'@>_GM  
Update skill_lvexp SET F102 = F102*50 x@\'@>_GM  
服务器经验 x@\'@>_GM  
在NPC_Generation_SP表上点右键选择设计表,然后找到NpcExp列,旁边是不是有个int啊,下拉找到float,然后关闭表存盘 x@\'@>_GM  
Update NPC_Generation_SP SET NpcExp = NpcExp*10000 x@\'@>_GM  
查找指定ID x@\'@>_GM  
select * from chr_info x@\'@>_GM  
where login_id = '这里写ID' x@\'@>_GM  
公会仓库 x@\'@>_GM  
select * from guild_item x@\'@>_GM  
where guild_code = 这里写公会代码 x@\'@>_GM  
order by cn x@\'@>_GM  
x@\'@>_GM  
x@\'@>_GM  
清空人物銀行的句法 x@\'@>_GM  
x@\'@>_GM  
Update Chr_Info2 SET bankitem = 0 x@\'@>_GM  
x@\'@>_GM  
清空人物裝備的句法 x@\'@>_GM  
x@\'@>_GM  
x@\'@>_GM  
x@\'@>_GM  
Update Chr_Info SET equip = 0
评价一下你浏览此帖子的感受

精彩

感动

搞笑

开心

愤怒

无聊

灌水
离线wwnnb
发帖
5
祝福宝石
0
威望
0
玛雅之石
0
创造宝石
0
只看该作者 4楼 发表于: 2006-08-06
00000000000000000000
离线aixiwoaini
发帖
262
祝福宝石
0
威望
0
玛雅之石
0
创造宝石
0
只看该作者 地板  发表于: 2006-08-05
好东西哈!谢谢了哦!
520
离线believer
发帖
23
祝福宝石
0
威望
0
玛雅之石
0
创造宝石
0
只看该作者 板凳  发表于: 2006-08-04
不错 很多使用的 命令
离线jack368
发帖
445
祝福宝石
0
威望
0
玛雅之石
0
创造宝石
0
只看该作者 沙发  发表于: 2006-07-21
快速回复
限100 字节
如果您在写长篇帖子又不马上发表,建议存为草稿
 
上一个 下一个

      管理员联系信箱 [email protected] 所有内容均来之互联网,如侵犯您的隐私和权益,请和我们及时联系!