|
You last visited: Today at 14:03
Advertisement
Bank Teller
Discussion on Bank Teller within the Shaiya Private Server forum part of the Shaiya category.
12/17/2012, 10:57
|
#1
|
elite*gold: 0 
Join Date: May 2011
Posts: 26
Received Thanks: 1
|
Bank Teller
Hey. How to add some items to the bank? Which table to use?
|
|
|
|
12/17/2012, 11:01
|
#2
|
elite*gold: 0
Join Date: Dec 2012
Posts: 76
Received Thanks: 65
|
You can use the "Gift box" this table is
PS_GameData.dbo.UserStoredPointItems
Like theese : 
|
|
|
|
|
12/17/2012, 21:20
|
#3
|
elite*gold: 92
Join Date: Aug 2009
Posts: 739
Received Thanks: 975
|
PS_Billing.dbo.User_Product is for Bank. You should fix your PSBilling first.
|
|
|
|
|
12/18/2012, 15:12
|
#4
|
elite*gold: 0
Join Date: May 2011
Posts: 26
Received Thanks: 1
|
If you mean , then yes, I have done this fix. But the problem still remained off the logs here.
PS_DBAGENT__charsave
Code:
//PS_DBAGENT__charsave log start (DBAgent01)
--<begin>2012-12-18 18:02:04,virusna4ok,1,[Adm]Qwerty,9
{?=call usp_Save_Char_Info_E(9,60, 21,4, 28000,12,9,8,7,15, 20265,13988,10222, 1,46, 1125491160,-294712505, 521.048706,78.720009,1789.596191, 0,200,0,0,0, 120000,0,0,0)}
EXEC usp_Save_User_StoredMoney_E 1,1,2142784398
{?=call usp_Save_Char_Product_Item_E(1,1,0, 9,3685387514006274048, 1,0, 40255,40,255, 0, 1,'2012-12-18 18:01:43','B')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684860723384352768,3684860723384287232,3684860723384418304,3684860723383762944,3684860723383697408,3684860723384221696,3684860723383828480,3684860723382779904,3684860723382714368,3684860723384156160,3684860723384025088,3684860723383959552,3684860723384090624,3684860723383894016,3684860723384680448,3684860723384614912,3684860723383173120,3684860723383042048,3684860723383107584,3684860723383238656,3684860723382976512,3684860723383566336,3684860723384877056,3684860723384811520,3684860723384745984,3684860723383631872,3684860723383435264,3684860723383304192,3684860723383500800,3684860723383369728,3684860723382910976,3684860723384483840,3684860723382845440,3684860723382583296,3684860723382648832,3684860723382517760,3684860723384549376,3684860770627354624,3684860770627420160,3684860757742256128')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684860757742321664')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684860770627223552')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684860770627158016')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684860770627289088')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684860985375653888')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684860985375522816')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684860985375588352')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861088454868992')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861088454803456')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861088454737920')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861238778724352')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861238778658816')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861238778789888')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556608270336')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556608335872')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556608401408')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556608466944')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556608139264')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556608204800')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556607483904')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556607352832')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556607418368')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556607877120')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556607549440')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556607746048')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556607614976')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556606894080')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556606828544')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556607942656')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556608008192')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556607156224')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556606238720')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556608073728')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556606304256')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556607025152')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556606566400')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556607287296')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556606763008')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556606697472')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556606959616')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556607221760')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556606173184')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556606631936')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556607090688')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556607811584')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556607680512')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556606435328')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556606500864')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556606369792')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861582376173568')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861582376304640')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861582376239104')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861582376108032')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861526541729792')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861526541664256')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861526541598720')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861599555911680')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861599555977216')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861599555846144')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861526541402112')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861526541467648')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861526541533184')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861526541860864')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861526541795328')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861526541926400')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861513656500224')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861599556173824')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861599556042752')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861599556108288')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861702635061248')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684590793277964288')}
{?=call Usp_Save_Char_Item_Del_E(9,'3685387514006274048')}
{?=call Usp_Save_Char_Skill_Mod_E(9,4,3,0)}
{?=call Usp_Save_Char_Skill_Mod_E(9,31,3,0)}
{?=call Usp_Save_Char_Skill_Mod_E(9,30,3,0)}
{?=call Usp_Save_Char_Skill_Mod_E(9,112,3,0)}
{?=call Usp_Save_Char_Skill_Mod_E(9,39,3,0)}
{?=call Usp_Save_Char_Skill_Mod_E(9,151,3,0)}
{?=call Usp_Save_Char_Skill_Mod_E(9,156,3,0)}
{?=call Usp_Save_Char_Skill_Mod_E(9,171,3,0)}
{?=call Usp_Save_Char_Skill_Mod_E(9,38,3,0)}
{?=call Usp_Save_Char_ApplySkill_Del_E(9,0,0,1)}
{?=call Usp_Save_Char_ApplySkill_Add_E2(9,223,1,2482145)}
{?=call Usp_Save_Char_ApplySkill_Add_E2(9,225,1,2482148)}
{?=call Usp_Save_Char_ApplySkill_Add_E2(9,227,1,2482150)}
{?=call Usp_Save_Char_ApplySkill_Add_E2(9,233,1,2482142)}
{?=call Usp_Save_Char_ApplySkill_Add_E2(9,235,1,2482147)}
{?=call Usp_Save_Char_ApplySkill_Add_E2(9,286,3,2534398)}
EXEC usp_Save_Char_QuickSlot_Del_E 9
EXEC usp_Save_Char_QuickSlot_Add_E 9,0,0,100,38
EXEC usp_Save_Char_QuickSlot_Add_E 9,0,1,100,156
EXEC usp_Save_Char_QuickSlot_Add_E 9,0,2,100,171
EXEC usp_Save_Char_QuickSlot_Add_E 9,0,3,100,39
EXEC usp_Save_Char_QuickSlot_Add_E 9,0,4,100,151
EXEC usp_Save_Char_QuickSlot_Add_E 9,1,0,100,192
EXEC usp_Save_Char_QuickSlot_Add_E 9,1,9,100,56
EXEC usp_Save_Char_QuickSlot_Add_E 9,13,0,100,31
EXEC usp_Save_Char_QuickSlot_Add_E 9,13,1,100,30
EXEC usp_Save_Char_QuickSlot_Add_E 9,13,2,100,112
--<end>2012-12-18 18:02:04,virusna4ok,1,[Adm]Qwerty,9
PS_DBAGENT__system
Code:
2012-12-18 17:57:59 PS_DBAGENT__system log start (DBAgent01)
2012-12-18 17:58:06 connect game, Name=
2012-12-18 17:58:06 connect game, Name=
2012-12-18 18:02:04 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'BuyDate', table 'PS_GameData.dbo.ProductLog'; column does not allow nulls. INSERT fails., SQL STATE: 23000, NATIVE ERROR: 515 (0x203)
2012-12-18 18:02:04 ::SaveCharacter 9 [Adm]Qwerty ret=1, qerr=-1, {?=call usp_Save_Char_Product_Item_E(1,1,0, 9,3685387514006274048, 1,0, 40255,40,255, 0, 0,0,0,0,0,0,'', 1,'2012-12-18 18:01:43','B')}
2012-12-18 18:02:04 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'BuyDate', table 'PS_GameData.dbo.ProductLog'; column does not allow nulls. INSERT fails., SQL STATE: 23000, NATIVE ERROR: 515 (0x203)
2012-12-18 18:02:04 ::SaveCharacter 9 [Adm]Qwerty ret=1, qerr=-1, {?=call usp_Save_Char_Product_Item_E(1,1,0, 9,3685387514006274048, 1,0, 40255,40,255, 0, 0,0,0,0,0,0,'', 1,'2012-12-18 18:01:43','B')}
PS_GAME__system
Code:
2012-12-18 17:58:02 PS_GAME__system log start (Game01) [KR]
2012-12-18 17:58:02 Loaded Behavior In Factory : data/ai/sorp1
2012-12-18 17:58:02 Loaded Behavior In Factory : data/ai/croco1
2012-12-18 17:58:02 Loaded Behavior In Factory : data/ai/croco2
2012-12-18 17:58:02 Loaded Behavior In Factory : data/ai/Troll1
2012-12-18 17:58:02 Loaded Behavior In Factory : data/ai/Spink1
2012-12-18 17:58:02 Loaded Behavior In Factory : data/ai/GoldenPig
2012-12-18 17:58:02 Loaded Behavior In Factory : data/ai/Sorp3
2012-12-18 17:58:02 Loaded Behavior In Factory : data/ai/SorpNamed1
2012-12-18 17:58:02 Loaded Behavior In Factory : data/ai/SorpNamed2
2012-12-18 17:58:02 Loaded Behavior In Factory : data/ai/Sorp2
2012-12-18 17:58:02 Loaded Behavior In Factory : data/ai/CrocoNamed1
2012-12-18 17:58:02 Loaded Behavior In Factory : data/ai/CrocoNamed2
2012-12-18 17:58:02 Loaded Behavior In Factory : data/ai/CrocoNamed3
2012-12-18 17:58:02 Loaded Behavior In Factory : data/ai/OrcNamed1
2012-12-18 17:58:02 Loaded Behavior In Factory : data/ai/OrcNamed2
2012-12-18 17:58:02 Loaded Behavior In Factory : data/ai/OrcNamed3
2012-12-18 17:58:02 Loaded Behavior In Factory : data/ai/TrollNamed1
2012-12-18 17:58:02 Loaded Behavior In Factory : data/ai/HellTouthNamed1
2012-12-18 17:58:02 Loaded Behavior In Factory : data/ai/Deinos
2012-12-18 17:58:02 Loaded Behavior In Factory : data/ai/Parridalis
2012-12-18 17:58:02 Loaded Behavior In Factory : data/ai/Alcarian
2012-12-18 17:58:02 Loaded Behavior In Factory : data/ai/ZinAlcaria
2012-12-18 17:58:02 Loaded Behavior In Factory : data/ai/Belizabeth
2012-12-18 17:58:02 Loaded Behavior In Factory : data/ai/Kirhiross
2012-12-18 17:58:02 Loaded Behavior In Factory : data/ai/CrypticOne
2012-12-18 17:58:02 Loaded Behavior In Factory : data/ai/Haruhion
2012-12-18 17:58:02 Loaded Behavior In Factory : data/ai/Freezing
2012-12-18 17:58:03 RandomOption Error : ItemID=22171, byServer=6, Wis=0
2012-12-18 17:58:03 RandomOption Error : ItemID=40171, byServer=6, Wis=0
2012-12-18 17:58:06 connect mgr 856
2012-12-18 17:58:06 connect dbagent 860
2012-12-18 17:58:06 connect dbagent2 864
2012-12-18 17:58:06 connect gamelog 880
2012-12-18 17:58:07 Market End -----------------------
2012-12-18 17:58:07 Load Shaiya.SData 3
2012-12-18 17:58:24 <Console input> /nprotectoff
2012-12-18 17:58:24 <Console output> cmd NProtect off ok
2012-12-18 18:02:04 discon client: (104, 1236) T=000:03:00:000, RC=45,RCS=0, RB=669,RBS=3, SC=259,SCS=1, SB=9614,SBS=51
The remaining files are no changes.
|
|
|
|
|
12/18/2012, 18:18
|
#5
|
elite*gold: 0
Join Date: Dec 2012
Posts: 76
Received Thanks: 65
|
Quote:
Quote:
Originally Posted by .Santa.
If you mean , then yes, I have done this fix. But the problem still remained off the logs here.
PS_DBAGENT__charsave
Code:
//PS_DBAGENT__charsave log start (DBAgent01)
--<begin>2012-12-18 18:02:04,virusna4ok,1,[Adm]Qwerty,9
{?=call usp_Save_Char_Info_E(9,60, 21,4, 28000,12,9,8,7,15, 20265,13988,10222, 1,46, 1125491160,-294712505, 521.048706,78.720009,1789.596191, 0,200,0,0,0, 120000,0,0,0)}
EXEC usp_Save_User_StoredMoney_E 1,1,2142784398
{?=call usp_Save_Char_Product_Item_E(1,1,0, 9,3685387514006274048, 1,0, 40255,40,255, 0, 1,'2012-12-18 18:01:43','B')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684860723384352768,3684860723384287232,3684860723384418304,3684860723383762944,3684860723383697408,3684860723384221696,3684860723383828480,3684860723382779904,3684860723382714368,3684860723384156160,3684860723384025088,3684860723383959552,3684860723384090624,3684860723383894016,3684860723384680448,3684860723384614912,3684860723383173120,3684860723383042048,3684860723383107584,3684860723383238656,3684860723382976512,3684860723383566336,3684860723384877056,3684860723384811520,3684860723384745984,3684860723383631872,3684860723383435264,3684860723383304192,3684860723383500800,3684860723383369728,3684860723382910976,3684860723384483840,3684860723382845440,3684860723382583296,3684860723382648832,3684860723382517760,3684860723384549376,3684860770627354624,3684860770627420160,3684860757742256128')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684860757742321664')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684860770627223552')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684860770627158016')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684860770627289088')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684860985375653888')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684860985375522816')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684860985375588352')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861088454868992')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861088454803456')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861088454737920')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861238778724352')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861238778658816')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861238778789888')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556608270336')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556608335872')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556608401408')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556608466944')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556608139264')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556608204800')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556607483904')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556607352832')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556607418368')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556607877120')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556607549440')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556607746048')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556607614976')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556606894080')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556606828544')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556607942656')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556608008192')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556607156224')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556606238720')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556608073728')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556606304256')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556607025152')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556606566400')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556607287296')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556606763008')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556606697472')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556606959616')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556607221760')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556606173184')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556606631936')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556607090688')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556607811584')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556607680512')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556606435328')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556606500864')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861556606369792')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861582376173568')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861582376304640')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861582376239104')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861582376108032')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861526541729792')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861526541664256')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861526541598720')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861599555911680')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861599555977216')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861599555846144')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861526541402112')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861526541467648')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861526541533184')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861526541860864')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861526541795328')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861526541926400')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861513656500224')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861599556173824')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861599556042752')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861599556108288')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684861702635061248')}
{?=call Usp_Save_Char_Item_Del_E(9,'3684590793277964288')}
{?=call Usp_Save_Char_Item_Del_E(9,'3685387514006274048')}
{?=call Usp_Save_Char_Skill_Mod_E(9,4,3,0)}
{?=call Usp_Save_Char_Skill_Mod_E(9,31,3,0)}
{?=call Usp_Save_Char_Skill_Mod_E(9,30,3,0)}
{?=call Usp_Save_Char_Skill_Mod_E(9,112,3,0)}
{?=call Usp_Save_Char_Skill_Mod_E(9,39,3,0)}
{?=call Usp_Save_Char_Skill_Mod_E(9,151,3,0)}
{?=call Usp_Save_Char_Skill_Mod_E(9,156,3,0)}
{?=call Usp_Save_Char_Skill_Mod_E(9,171,3,0)}
{?=call Usp_Save_Char_Skill_Mod_E(9,38,3,0)}
{?=call Usp_Save_Char_ApplySkill_Del_E(9,0,0,1)}
{?=call Usp_Save_Char_ApplySkill_Add_E2(9,223,1,2482145)}
{?=call Usp_Save_Char_ApplySkill_Add_E2(9,225,1,2482148)}
{?=call Usp_Save_Char_ApplySkill_Add_E2(9,227,1,2482150)}
{?=call Usp_Save_Char_ApplySkill_Add_E2(9,233,1,2482142)}
{?=call Usp_Save_Char_ApplySkill_Add_E2(9,235,1,2482147)}
{?=call Usp_Save_Char_ApplySkill_Add_E2(9,286,3,2534398)}
EXEC usp_Save_Char_QuickSlot_Del_E 9
EXEC usp_Save_Char_QuickSlot_Add_E 9,0,0,100,38
EXEC usp_Save_Char_QuickSlot_Add_E 9,0,1,100,156
EXEC usp_Save_Char_QuickSlot_Add_E 9,0,2,100,171
EXEC usp_Save_Char_QuickSlot_Add_E 9,0,3,100,39
EXEC usp_Save_Char_QuickSlot_Add_E 9,0,4,100,151
EXEC usp_Save_Char_QuickSlot_Add_E 9,1,0,100,192
EXEC usp_Save_Char_QuickSlot_Add_E 9,1,9,100,56
EXEC usp_Save_Char_QuickSlot_Add_E 9,13,0,100,31
EXEC usp_Save_Char_QuickSlot_Add_E 9,13,1,100,30
EXEC usp_Save_Char_QuickSlot_Add_E 9,13,2,100,112
--<end>2012-12-18 18:02:04,virusna4ok,1,[Adm]Qwerty,9
PS_DBAGENT__system
Code:
2012-12-18 17:57:59 PS_DBAGENT__system log start (DBAgent01)
2012-12-18 17:58:06 connect game, Name=
2012-12-18 17:58:06 connect game, Name=
2012-12-18 18:02:04 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'BuyDate', table 'PS_GameData.dbo.ProductLog'; column does not allow nulls. INSERT fails., SQL STATE: 23000, NATIVE ERROR: 515 (0x203)
2012-12-18 18:02:04 ::SaveCharacter 9 [Adm]Qwerty ret=1, qerr=-1, {?=call usp_Save_Char_Product_Item_E(1,1,0, 9,3685387514006274048, 1,0, 40255,40,255, 0, 0,0,0,0,0,0,'', 1,'2012-12-18 18:01:43','B')}
2012-12-18 18:02:04 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'BuyDate', table 'PS_GameData.dbo.ProductLog'; column does not allow nulls. INSERT fails., SQL STATE: 23000, NATIVE ERROR: 515 (0x203)
2012-12-18 18:02:04 ::SaveCharacter 9 [Adm]Qwerty ret=1, qerr=-1, {?=call usp_Save_Char_Product_Item_E(1,1,0, 9,3685387514006274048, 1,0, 40255,40,255, 0, 0,0,0,0,0,0,'', 1,'2012-12-18 18:01:43','B')}
PS_GAME__system
Code:
2012-12-18 17:58:02 PS_GAME__system log start (Game01) [KR]
2012-12-18 17:58:02 Loaded Behavior In Factory : data/ai/sorp1
2012-12-18 17:58:02 Loaded Behavior In Factory : data/ai/croco1
2012-12-18 17:58:02 Loaded Behavior In Factory : data/ai/croco2
2012-12-18 17:58:02 Loaded Behavior In Factory : data/ai/Troll1
2012-12-18 17:58:02 Loaded Behavior In Factory : data/ai/Spink1
2012-12-18 17:58:02 Loaded Behavior In Factory : data/ai/GoldenPig
2012-12-18 17:58:02 Loaded Behavior In Factory : data/ai/Sorp3
2012-12-18 17:58:02 Loaded Behavior In Factory : data/ai/SorpNamed1
2012-12-18 17:58:02 Loaded Behavior In Factory : data/ai/SorpNamed2
2012-12-18 17:58:02 Loaded Behavior In Factory : data/ai/Sorp2
2012-12-18 17:58:02 Loaded Behavior In Factory : data/ai/CrocoNamed1
2012-12-18 17:58:02 Loaded Behavior In Factory : data/ai/CrocoNamed2
2012-12-18 17:58:02 Loaded Behavior In Factory : data/ai/CrocoNamed3
2012-12-18 17:58:02 Loaded Behavior In Factory : data/ai/OrcNamed1
2012-12-18 17:58:02 Loaded Behavior In Factory : data/ai/OrcNamed2
2012-12-18 17:58:02 Loaded Behavior In Factory : data/ai/OrcNamed3
2012-12-18 17:58:02 Loaded Behavior In Factory : data/ai/TrollNamed1
2012-12-18 17:58:02 Loaded Behavior In Factory : data/ai/HellTouthNamed1
2012-12-18 17:58:02 Loaded Behavior In Factory : data/ai/Deinos
2012-12-18 17:58:02 Loaded Behavior In Factory : data/ai/Parridalis
2012-12-18 17:58:02 Loaded Behavior In Factory : data/ai/Alcarian
2012-12-18 17:58:02 Loaded Behavior In Factory : data/ai/ZinAlcaria
2012-12-18 17:58:02 Loaded Behavior In Factory : data/ai/Belizabeth
2012-12-18 17:58:02 Loaded Behavior In Factory : data/ai/Kirhiross
2012-12-18 17:58:02 Loaded Behavior In Factory : data/ai/CrypticOne
2012-12-18 17:58:02 Loaded Behavior In Factory : data/ai/Haruhion
2012-12-18 17:58:02 Loaded Behavior In Factory : data/ai/Freezing
2012-12-18 17:58:03 RandomOption Error : ItemID=22171, byServer=6, Wis=0
2012-12-18 17:58:03 RandomOption Error : ItemID=40171, byServer=6, Wis=0
2012-12-18 17:58:06 connect mgr 856
2012-12-18 17:58:06 connect dbagent 860
2012-12-18 17:58:06 connect dbagent2 864
2012-12-18 17:58:06 connect gamelog 880
2012-12-18 17:58:07 Market End -----------------------
2012-12-18 17:58:07 Load Shaiya.SData 3
2012-12-18 17:58:24 <Console input> /nprotectoff
2012-12-18 17:58:24 <Console output> cmd NProtect off ok
2012-12-18 18:02:04 discon client: (104, 1236) T=000:03:00:000, RC=45,RCS=0, RB=669,RBS=3, SC=259,SCS=1, SB=9614,SBS=51
The remaining files are no changes. |
|
You can Better use PS_GameData.dbo.UserStoredPointItems
|
|
|
|
|
12/19/2012, 20:03
|
#6
|
elite*gold: 92
Join Date: Aug 2009
Posts: 739
Received Thanks: 975
|
Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'BuyDate',
use GetDate()
|
|
|
|
 |
Similar Threads
|
[RELEASE] FIX for Bank teller DC problem
11/04/2015 - Shaiya PServer Guides & Releases - 10 Replies
i have not fully 100 % tested with populated server and stuff like that it was tested on my local server first atempt proved dc happened aproxamently 15 mins after removeing an item from the bank teller due to errors in procs so i fixed what i seen and retryed again and lasted aproxamently 30 mins with absolutly no dc opened the db and checked the tabel the item removed from the bank teller had vanished from the tabel as it should i baught a stack of glod bars just after removeing the item from...
|
ELITE TELLER V2
05/07/2012 - WarRock Hacks, Bots, Cheats & Exploits - 2 Replies
V2 HAS BEEN JUST BEEN CODED!!
hAVE FUN!!:bandit:
Use this smart program to tell your friends about eltepvpers.com;)
Scans: https://www.virustotal.com/file/57dcecc5cc3c93fdab 294e1c84b8e0328df54a3deca7b5902b0f402c17be6d90/ana lysis/1336384108/
Downloads: 2shared - Upload complete
|
Elite teller v1
05/06/2012 - WarRock Hacks, Bots, Cheats & Exploits - 2 Replies
Hey, This Program helps you help Elitepvpers.com By sending this to you friends telling them about Hacks and warrock Hacks, Completely Safe And Free.
Virus scans: https://www.virustotal.com/file/6119e99e0cc710bba7 284127190746efcb4c1e20b0bcb263ba85c47daa75fe30/ana lysis/1336297902/
MADE BY GREENMATS!
Link Safe: 2shared - Upload complete
|
penn & teller: bullshit
05/04/2012 - Trading - 8 Replies
suche eine seite wo man alle staffeln und alle folgen penn & teller: bullshit gucken kann (stream). biete 20€ psc für den, der mir hilft.
|
[Help]Bank Teller
08/22/2010 - Shaiya Private Server - 2 Replies
Hey guys and Gals
I know the stored Proc to send items to the Bank teller and it works great again thumbs up for the people who answered me. My problem is that when the person takes the item out it Dced them shortly after and the item is back the bank. This causes me problems as you can imagine.
I have been messing around with it trying to figure out why it is doing that and can't find anything..
If anyone has any help in this matter that would be amazing:handsdown:
Thank you!
|
All times are GMT +1. The time now is 14:04.
|
|
