SKILL PROBLEMS

[Syek]

Hi, first of all sorry for my english, i´ll explain it quickly...

my problem is that at first i bought some skills and when i relogged all the skills where deleted like if i didn´t buy anyone, and when i tried to bought them again it says ¨Skill unable to learn¨, like if i already have it but some of they are completely reset and i cant use it



thanks, i have others problems, but this is one i need help

[castor4878]

all changes made during game (gaining XP, gold, purchasing / selling items, and acquiring skills) are saved to DB when the character leaves the game (to select another char. or to exit).

so, if at next login, something is missing, it basically because it wasn't saved to database.
such failures are quite always due to mistake in the stored procedures (SP) invoked by the ps_game service. SP are lie SQL-subroutine saved with the DB itself, you so find & edit them with MS SQL Studio.

to find out which one is buggy, check your logs ( .\PSM_Client\bin\Log\ ) and look for something like:

yyyy-mm-dd hh:mm:ss DBWrite::LogGame: err=-1, query=EXEC usp_The_Name_Of_A_Stored_Proc 'foo',1,2,'bar', 'parameters',....

followed by the error (missing field when the table has been changed, or more frequent a failure to convert an ODBC date (meaning an ibvalid string) into a valid datetime.

last step is to fix the SP.