Post: #7

(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

Coruja did correct your code in the right way, the problem is that there is a logical error: for each row you're updating skill_id and skill_value checking if char_id = <UID>. You should only set skill_value=<I.<LOCAL._FOR>>, checking if char_id=<UID> and skill_id=<dlocal._FOR>