test

OnNPCKillEvent:
IF(killedrid == mob_id)
{
    mob_kill ++;
    IF(mob_kill >= 500)
    {
        query_sql("INSERT INTO `test_table` (`char_id`,`mob_id`,`mob_count`) VALUES ('"+getcharid(0)+"', '"+mob_id+"', '"+mob_count+"'");
        mob_count = 0;
    }
}
END;

CREATE TABLE `test_table` (
`char_id` INT(15) NOT NULL,
`mob_id` INT(5) NOT NULL,
`mob_count` INT(5) NOT NULL,
PRIMARY KEY(`char_id`)
);