Post: #5

(09-12-2015 03:29 AM)Coruja Wrote:  you must use the arguments in correct order, you wrote SELECT [a] FROM WHERE [b] [c] but the correct is SELECT [a] FROM [b] WHERE [c]

Code:

DB.QUERY "SELECT * FROM myrunuo_characters_skills WHERE char_id='<UID>' LIMIT 1
IF (<DB.ROW.NUMROWS>)
  FOR 1 49
    DB.EXECUTE "UPDATE myrunuo_characters_skills SET skill_id=<dLOCAL._FOR>, skill_value=<I.<LOCAL._FOR>> WHERE char_id=<UID> LIMIT 1"
  ENDFOR
ELSE
  FOR 1 49
    DB.QUERY "INSERT INTO myrunuo_characters_skills (char_id, skill_id, skill_value) VALUES ('<UID>', '<dLOCAL._FOR>', '<I.<LOCAL._FOR>>')"
  ENDFOR
ENDIF

Hello , I tried your correction but the problem remains ... If log in the first time makes the correct entry . If you change the skill and the skill log out saves only 49 with the exact value for 49 times .