Post: #1

Good evening,
I have a problem with a SQL query.
Use the script to create the paperdoll Avatar.
Because there is a bug, that is, every time a client connects rewrites again his skill, I made a query that checks whether it already exists and performs an UPDATE instead of rewriting.
Here lies the problem ... The query works, but instead of cycling all skills I marked all as necromancy ... and of course with its value ..
The query is this:

// Character skills UPDATE
Db.query "SELECT * FROM WHERE myrunuo_characters_skills char_id = '<eval <uid >>'
    if (<DB.ROW.NUMROWS>> 0)
for x 1 <eval <DB.ROW.NUMROWS >>
Db.Execute "UPDATE myrunuo_characters_skills September skill_id = <dlocal.x>, skill_value = << def.player_skill_ <dlocal.x >>> WHERE char_id = <eval <uid >>"
endfor
endif

Db.query "SELECT * FROM WHERE myrunuo_characters_skills char_id = '<eval <uid >>'
    if (<DB.ROW.NUMROWS> == 0)
// Insert Character Skills
for 1 x 49
db.query insert into myrunuo_characters_skills (char_id, skill_id, skill_value) VALUES ('<eval <uid >>', '<dlocal.x>', '<< def.player_skill_ <dlocal.x >>>')
endfor
endif