谷迷网

 找回密码
 立即注册
搜索
热搜: 活动 交友 discuz
查看: 4351|回复: 0

龙之谷私服gm常用sql

[复制链接]

122

主题

133

帖子

836

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
836
发表于 2019-12-23 19:39:29 | 显示全部楼层 |阅读模式
USE [DNMembership]
GO
-- 所有人增加点券
update dbo.CashIncome
set CashAmount=120


USE [DNMembership]
GO
-- 显示所有人点券
select * from dbo.Cashincome

update Characters
set AccountLevelCode=0


update charmitemtable_temp
set _ItemID=302132232

update Guilds
set GuildLevel=40

update CharacterStatus
set CharacterLevel=90

update CharacterStatus
set CharacterExp=296511304
===========================================================
商城
update cashcommodity_temp
set _Price=1价格

update cashcommodity_temp
set _OnSale=1开启销售

update cashcommodity_temp
set _PriceFix=9999999之前的价格

update cashcommodity_temp
set _OnSaleREAL=1确定上架

----------------------------
update cashcommodity_temp
set _ReserveAble=0

update cashcommodity_temp
set _PresentAble=0
===========================================================
次元兔子
update itemdroptable_dimension_temp
set _GoldMin=500000

update itemdroptable_dimension_temp
set _GoldMax=10000000

update itemdroptable_dimension_temp
set _GoldProb=100000000

update itemdroptable_dimension_temp
set _GoldLumpMin=5

update itemdroptable_dimension_temp
set _GoldLumpMax=20

===========================================================
update itemdroptable_temp
set _GoldMin=10000000

update itemdroptable_temp
set _GoldMax=1000000000

update itemdroptable_temp
set _GoldProb=100000000

update itemdroptable_temp
set _GoldLumpMin=1

update itemdroptable_temp
set _GoldLumpMax=5
深渊深渊深渊深渊深渊深渊深渊深渊深渊深渊深渊深渊深渊深渊深渊深渊深渊深渊深渊深渊
update itemdroptable_temp
set _Item20Index=2101000002

update itemdroptable_temp
set _Item20Prob=100000000

update itemdroptable_temp
set _Item20Info=10
||||||||||||||||||||||||||||||||||||||||||||||||深渊深渊深渊深渊深渊深渊深渊深渊深渊深渊
update itemdroptable_temp
set _Item19Index=268452927

update itemdroptable_temp
set _Item19Prob=100000000

update itemdroptable_temp
set _Item19Info=100
||||||||||||||||||||||||||||||||||||||||||||||||深渊深渊深渊深渊深渊深渊深渊深渊深渊深渊
update itemdroptable_temp
set _Item18Index=268452928

update itemdroptable_temp
set _Item18Prob=100000000

update itemdroptable_temp
set _Item18Info=100
||||||||||||||||||||||||||||||||||||||||||||||||深渊深渊深渊深渊深渊深渊深渊深渊深渊深渊
update itemdroptable_temp
set _Item17Index=872915260

update itemdroptable_temp
set _Item17Prob=100000000

update itemdroptable_temp
set _Item17Info=20
||||||||||||||||||||||||||||||||||||||||||||||||深渊深渊深渊深渊深渊深渊深渊深渊深渊深渊
update itemdroptable_temp
set _Item16Index=805309014

update itemdroptable_temp
set _Item16Prob=100000000

update itemdroptable_temp
set _Item16Info=10
||||||||||||||||||||||||||||||||||||||||||||||||深渊深渊深渊深渊深渊深渊深渊深渊深渊深渊
update itemdroptable_temp
set _Item15Index=536873506

update itemdroptable_temp
set _Item15Prob=100000000

update itemdroptable_temp
set _Item15Info=100
||||||||||||||||||||||||||||||||||||||||||||||||深渊深渊深渊深渊深渊深渊深渊深渊深渊深渊
update itemdroptable_temp
set _Item14Index=268454513

update itemdroptable_temp
set _Item14Prob=100000000

update itemdroptable_temp
set _Item14Info=100
||||||||||||||||||||||||||||||||||||||||||||||||深渊深渊深渊深渊深渊深渊深渊深渊深渊深渊
update itemdroptable_temp
set _Item13Index=
268454514

update itemdroptable_temp
set _Item13Prob=100000000

update itemdroptable_temp
set _Item13Info=100
||||||||||||||||||||||||||||||||||||||||||||||||深渊深渊深渊深渊深渊深渊深渊深渊深渊深渊
===========================================================
update itemdroptable_temp
set _Item12Index=268452926

update itemdroptable_temp
set _Item12Prob=100000000

update itemdroptable_temp
set _Item12Info=100
||||||||||||||||||||||||||||||||||||||||||||||||深渊深渊深渊深渊深渊深渊深渊深渊深渊深渊
开蛋
update charmitemtable_temp
set _Prob=1

update charmitemtable_temp
set _Period=0

update charmitemtable_temp
set _Msg=1

update charmitemtable_temp
set _ItemID=302132232

update charmitemtable_temp
set _Count=1
===========================================================
update itemdropgrouptable_temp
set _Expectation=_Expectation*10
这个爆率
===========================================================
update itemdroptable_monsteritem_temp
set _Expectation=_Expectation*10
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
===========================================================
update itemdroptable_monsteritem_temp
set _GoldMin=_GoldMin*2

update itemdroptable_monsteritem_temp
set _GoldMax=_GoldMax*800

update itemdroptable_monsteritem_temp
set _GoldProb=100000000

update itemdroptable_monsteritem_temp
set _GoldLumpMin=_GoldLumpMin*2

update itemdroptable_monsteritem_temp
set _GoldLumpMax=_GoldLumpMax*15

===========================================================


===========================================================
update maptable_temp
set _MaxClearCount=99999

update maptable_temp
set _VehicleMode=1

update maptable_temp
set _PetMode=1

===========================================================
update stageentertable_temp
set _PartyOneNumMin=1

update stageentertable_temp
set _PartyOneNumMax=8

===========================================================
update enchanttable_temp
set _EnchantRatio=0.9
0.2500000000
强化百分之九十

===========================================================
update monsterweighttable_temp
set _HPWeight=_HPWeight*0.5

可能是怪物血量

===========================================================
合成箱子开出公告

update chaoscuberesulttable_temp
set _Msg=1

===========================================================
update combinedshoptable_temp
set _buyLimitCount=0

兑换无限次数

===========================================================
技能点

update playerleveltable_temp
set _SkillPoint=8

===========================================================
强化无需材料

update enchanttable_temp
set _NeedItemID1=0

update enchanttable_temp
set _NeedItemCount1=0

update enchanttable_temp
set _NeedCoin=0

回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

手机版|小黑屋|Comsenz Inc.  

GMT+8, 2020-1-21 13:00 , Processed in 0.105138 second(s), 25 queries .

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表