error getvariableofnpc cant find

[IsabelaFernandez]

I'm trying to use this script but it keeps giving this error, I would like to make it work like it used to. already installed the SQL files

 

 

gd_pk_title.sql GD_PK_TITLE_2.txt

[millu]

On 4/18/2022 at 6:11 PM, IsabelaFernandez said:

I'm trying to use this script but it keeps giving this error, I would like to make it work like it used to. already installed the SQL files

 

 

gd_pk_title.sql 156 B · 1 download GD_PK_TITLE_2.txt 2.84 kB · 6 downloads

error is in insert

table:

CREATE TABLE IF NOT EXISTS `gd_pk_title` (
  `char_id` int(11) unsigned NOT NULL,
  `var` int(11) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

no default value for fields, so you need to inform all fields in an
*insert*, as they are defined as *NOT NULL*, in table.

query_sql "SELECT `char_id` FROM `GD_PK_TITLE` WHERE `char_id` = "+@GDCID+"",@GDTID;
    if( !@GDTID )
//ERROR        query_sql "INSERT `GD_PK_TITLE` VALUES("+@GDCID+",1)";
            query_sql "INSERT INTO `GD_PK_TITLE` FIELDS (`char_id,`var`) VALUES("+@GDCID+",1)";
    else
        query_sql "UPDATE `GD_PK_TITLE` SET `var` = `var`+1 WHERE `char_id` = "+@GDCID+"";

Edited April 28, 2022 by millu