- 精华
- 阅读权限
- 80
- 好友
- 相册
- 分享
- 听众
- 收听
- 注册时间
- 2010-7-18
- 在线时间
- 小时
- 最后登录
- 1970-1-1
|
本帖最后由 疯狂的Brant 于 2014-8-10 23:40 编辑
RT,记得是老周做的GM工具,名字叫DN TOOL,周流做的,网上查不到,有的请给个网盘地址多谢多谢!-------------------------------------------------------------
自己动手丰衣足食啊
首先多谢互联网这个万能神!
自己找相关代码做了扩空间工具,期间发现物品生效的后台修改方法。
下面是自己整理修改过的扩背包仓库3备用纹章的主要代码,会玩SQL的直接看SQL语句自己改吧。目前适用133版的,369版还没试,最近没时间玩游戏。- decimal items = Convert.ToDecimal(sdb.ReturnExecSQL(@"select max(ItemSerial) as ItemSerial from EffectItems"));
- if ((int)sdb.ReturnExecSQL(string.Format(@"select count(EffectItemID) from EffectItems where ItemID = 1073742455 and CharacterID = {0}", cid)) < 1 && (int)sdb.ReturnExecSQL(string.Format(@"select count(EffectItemID) from EffectItems where ItemID = 1107331072 and CharacterID = {0}", cid)) < 1)
- {
- sdb.ExecSQL(string.Format(@"USE DNWorld
- INSERT INTO EffectItems (CharacterID,ItemID,EffectItemGetCode,EffectItemGetKey,Price,EternityFlag,EffectItemExpireDate,Property1,Property2,Property3,Property4,Property5,RegisterDate,ExpireCompleteFlag,ItemSerial)
- VALUES ({0},1107331072,1,1,1,'True','2024-01-01 00:00:00',0,0,0,0,0,GETDATE(),'False',{1}+1)
- INSERT INTO EffectItems (CharacterID,ItemID,EffectItemGetCode,EffectItemGetKey,Price,EternityFlag,EffectItemExpireDate,Property1,Property2,Property3,Property4,Property5,RegisterDate,ExpireCompleteFlag,ItemSerial)
- VALUES ({0},1107331072,1,1,1,'True','2024-01-01 00:00:00',0,0,0,0,0,GETDATE(),'False',{1}+2)
- INSERT INTO EffectItems (CharacterID,ItemID,EffectItemGetCode,EffectItemGetKey,Price,EternityFlag,EffectItemExpireDate,Property1,Property2,Property3,Property4,Property5,RegisterDate,ExpireCompleteFlag,ItemSerial)
- VALUES ({0},1107331072,1,1,1,'True','2024-01-01 00:00:00',0,0,0,0,0,GETDATE(),'False',{1}+3)
- INSERT INTO EffectItems (CharacterID,ItemID,EffectItemGetCode,EffectItemGetKey,Price,EternityFlag,EffectItemExpireDate,Property1,Property2,Property3,Property4,Property5,RegisterDate,ExpireCompleteFlag,ItemSerial)
- VALUES ({0},1107331072,1,1,1,'True','2024-01-01 00:00:00',0,0,0,0,0,GETDATE(),'False',{1}+4)
- INSERT INTO EffectItems (CharacterID,ItemID,EffectItemGetCode,EffectItemGetKey,Price,EternityFlag,EffectItemExpireDate,Property1,Property2,Property3,Property4,Property5,RegisterDate,ExpireCompleteFlag,ItemSerial)
- VALUES ({0},1107335168,1,1,1,'True','2024-01-01 00:00:00',0,0,0,0,0,GETDATE(),'False',{1}+5)
- INSERT INTO EffectItems (CharacterID,ItemID,EffectItemGetCode,EffectItemGetKey,Price,EternityFlag,EffectItemExpireDate,Property1,Property2,Property3,Property4,Property5,RegisterDate,ExpireCompleteFlag,ItemSerial)
- VALUES ({0},1107335168,1,1,1,'True','2024-01-01 00:00:00',0,0,0,0,0,GETDATE(),'False',{1}+6)
- INSERT INTO EffectItems (CharacterID,ItemID,EffectItemGetCode,EffectItemGetKey,Price,EternityFlag,EffectItemExpireDate,Property1,Property2,Property3,Property4,Property5,RegisterDate,ExpireCompleteFlag,ItemSerial)
- VALUES ({0},1107335168,1,1,1,'True','2024-01-01 00:00:00',0,0,0,0,0,GETDATE(),'False',{1}+7)
- INSERT INTO EffectItems (CharacterID,ItemID,EffectItemGetCode,EffectItemGetKey,Price,EternityFlag,EffectItemExpireDate,Property1,Property2,Property3,Property4,Property5,RegisterDate,ExpireCompleteFlag,ItemSerial)
- VALUES ({0},1107335168,1,1,1,'True','2024-01-01 00:00:00',0,0,0,0,0,GETDATE(),'False',{1}+8)
- INSERT INTO EffectItems (CharacterID,ItemID,EffectItemGetCode,EffectItemGetKey,Price,EternityFlag,EffectItemExpireDate,Property1,Property2,Property3,Property4,Property5,RegisterDate,ExpireCompleteFlag,ItemSerial)
- VALUES ({0},1107333120,1,1,1,'True','2024-01-01 00:00:00',0,0,0,0,0,GETDATE(),'False',{1}+9)
- INSERT INTO EffectItems (CharacterID,ItemID,EffectItemGetCode,EffectItemGetKey,Price,EternityFlag,EffectItemExpireDate,Property1,Property2,Property3,Property4,Property5,RegisterDate,ExpireCompleteFlag,ItemSerial)
- VALUES ({0},1107333120,1,1,1,'True','2024-01-01 00:00:00',0,0,0,0,0,GETDATE(),'False',{1}+10)
- INSERT INTO EffectItems (CharacterID,ItemID,EffectItemGetCode,EffectItemGetKey,Price,EternityFlag,EffectItemExpireDate,Property1,Property2,Property3,Property4,Property5,RegisterDate,ExpireCompleteFlag,ItemSerial)
- VALUES ({0},1107333120,1,1,1,'True','2024-01-01 00:00:00',0,0,0,0,0,GETDATE(),'False',{1}+11)
- INSERT INTO EffectItems (CharacterID,ItemID,EffectItemGetCode,EffectItemGetKey,Price,EternityFlag,EffectItemExpireDate,Property1,Property2,Property3,Property4,Property5,RegisterDate,ExpireCompleteFlag,ItemSerial)
- VALUES ({0},1107333120,1,1,1,'True','2024-01-01 00:00:00',0,0,0,0,0,GETDATE(),'False',{1}+12)
- INSERT INTO EffectItems (CharacterID,ItemID,EffectItemGetCode,EffectItemGetKey,Price,EternityFlag,EffectItemExpireDate,Property1,Property2,Property3,Property4,Property5,RegisterDate,ExpireCompleteFlag,ItemSerial)
- VALUES ({0},1073742455,1,1,1,'True','2017-01-01 00:00:00',0,0,0,0,0,GETDATE(),'False',{1}+13)--添加3纹章栏", cid, items));
- MessageBox.Show("已经完成扩容");
- }
- else
- MessageBox.Show("角色已经扩充空间,请选择其他角色!");
复制代码
|
|