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("角色已经扩充空间,请选择其他角色!");