Bank Teller

12/17/2012 10:57 .Santa.#1
Hey. How to add some items to the bank? Which table to use?
12/17/2012 11:01 Old-School#2
You can use the "Gift box" this table is
PS_GameData.dbo.UserStoredPointItems

Like theese : [Only registered and activated users can see links. Click Here To Register...]
12/17/2012 21:20 nephren#3
PS_Billing.dbo.User_Product is for Bank. You should fix your PSBilling first.
12/18/2012 15:12 .Santa.#4
If you mean [Only registered and activated users can see links. Click Here To Register...], 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 Old-School#5
Quote:
You can Better use PS_GameData.dbo.UserStoredPointItems
12/19/2012 20:03 nephren#6
Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'BuyDate',


use GetDate()