Hey, so I'm currently, trying to have an item insert somethings into the inventory table of my inventory sql database, but i'm having some issues could someone help me out?
query_sql"INSERT INTO 'equip_count' VALUES='"+(.@equip_count + 1)+"' FROM 'inventory' WHERE 'char_id'='"+getcharid(0)+"' AND 'nameid'='"+getequipid(2)+"'"
The above query, is going to be activated when ever they equip an item. Also, every 10seconds an item is equipped.
I already got the SELECT part down to pull data, but adding info eludes me.
Should I be using the UPDATE command instead? (Not sure if it requires a re-log).
Note - I've been away from scripting for quite a few years now @.@
Question
GmOcean
Hey, so I'm currently, trying to have an item insert somethings into the inventory table of my inventory sql database, but i'm having some issues could someone help me out?
The above query, is going to be activated when ever they equip an item. Also, every 10seconds an item is equipped.
I already got the SELECT part down to pull data, but adding info eludes me.
Should I be using the UPDATE command instead? (Not sure if it requires a re-log).
Note - I've been away from scripting for quite a few years now @.@
Edited by GmOceanLink to comment
Share on other sites
6 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.