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+"')");
                }