Sorry for reviving this thread but i cant seem to update this query.
Here's my query
INSERT INTO
rebirth_system (`account_id`, `name`, `num_rebirth`, `last_ip`)
VALUES
(
"+ getcharid(3) +",
'"+ escape_sql( strcharinfo(0) ) +"',
'"+ num_rebirth +"',
'(Select `account_id` From login Where `account_id` = "+ getcharid(3) +")'
)
ON DUPLICATE KEY UPDATE `rebirth_system.num_rebirth` = `rebirth_system.num_rebirth` + 1;