mvp sql error

[VladimirCastro]

heres my script.. of mvp i got error it says that db sql error mvp 

 

 

    query_sql "SELECT `name` FROM `mvp` WHERE `char_id`="+getcharid(0)+"",.@name$;


    if ( .@name$ == "" ) { query_sql "INSERT INTO `mvp` (`char_id`,`name`,`kills`,`points`) VALUES (" + getcharid(0) + ",'" + escape_sql(strcharinfo(0)) + "',1,1)"; end; }


    query_sql "UPDATE `mvp` SET `kills` = (`kills` + 1), `points` = (`points` +1) WHERE `char_id`=" + getcharid(0);


    end;
 

 

 

[Capuche]

Replace yours lines by this line

query_sql "INSERT INTO `mvp` VALUES (" + getcharid(0) + ",'" + escape_sql( strcharinfo(0) ) + "',1,1) on duplicate key update `kills` = `kills` + 1, `points` = `points` +1";

 

If you still have some error, report it

[VladimirCastro]

i mean how can i make a sql database with that one?

[Patskie]

Like this? if so, add this on your script

OnInit:
query_sql "CREATE TABLE IF NOT EXISTS `mvp` (`char_id` INT(11) NOT NULL DEFAULT '0', `name` VARCHAR(30) NOT NULL DEFAULT '', `kills` INT NOT NULL DEFAULT '0', `points` INT NOT NULL DEFAULT '0') ENGINE=MyISAM";