if(query_sql("SELECT `claim` FROM `reward_logs` WHERE `code` = '" + escape_sql(.@pc$) + "'",.@claim)) { set .@claim,1; query_sql("UPDATE `reward_logs` SET `claim` = '"+1+"' WHERE `code` = '" + escape_sql(.@pc$) + "'" ); query_sql("UPDATE `reward_logs` SET `last_ip` = '"+getcharip(strcharinfo(0))+"' WHERE `code` = '" + escape_sql(.@pc$) + "'" ); } else { query_sql("INSERT INTO `reward_logs` (`char_id`,`last_ip`,`code`,`redeem_time`,`claim`) VALUES ('"+getcharid(strcharinfo(0))+"','"+getcharip(strcharinfo(0))+"','"+escape_sql(.@pc$)+"',NOW(),'"+1+"')"); }