Emistry

try 
4117,Side_Winder_Card,Sidewinder Card,6,20,,10,,,,,,,,2,,,,,{ addtoskill "TF_DOUBLE",1,2; bonus bDoubleRate,5; },{},{}  

prontera,155,181,5 script PVP Room 4_F_KAFRA1,{ for ([email protected] = 0; [email protected] < .size; [email protected]++) [email protected]$ += .name$[[email protected]] + "[ "+getmapusers(.map$[[email protected]])+" ]" + ":"; [email protected] = select([email protected]$) - 1; warp .map$[[email protected]], 0, 0; end; OnInit: setarray .name$, "Title 1", "Title 2", "Title 3", "Title 4", "Title 5", "Title 6"; setarray .map$, "pvp_map_1", "pvp_map_2", "pvp_map_3", "pvp_map_4", "pvp_map_5", "pvp_map_6"; .size = getarraysize(.map$); initnpctimer; OnTimer5000: .index = (.index % .size); delwaitingroom; waitingroom .name$[.index] + "[ "+getmapusers(.map$[.index])+" ]", 0; .index++; initnpctimer; end; } try

maybe something like this ?
prontera,155,181,5 script Sample 4_F_KAFRA1,{ [email protected]_aid = getcharid(3); [email protected]$ = "SELECT c.`account_id`,c.`name`,c.`online`, SUM(ISNULL(i.`amount`, 0)) " + "FROM `char` c " + "INNER JOIN `inventory` i ON c.`char_id` = i.`char_id` AND i.`nameid` IN (21026, 210267) " + "WHERE c.`account_id` IN (SELECT `account_id` FROM `login` WHERE `level` > 0) " // + "AND c.`online` = 1 " + "GROUP BY i.`char_id` " + "ORDER BY c.`name`"; [email protected] = query_sql([email protected]$, [email protected], [email protected]$, [email protected], [email protected]); mes "Found "[email protected]+" Record(s)"; for ([email protected] = 0; [email protected] < [email protected]; [email protected]++) { if ([email protected][[email protected]]) { if (attachrid([email protected][[email protected]])) [email protected][[email protected]] = (countitem(21026) + countitem(210267)); attachrid([email protected]_aid); } mes "^0000FF"+([email protected]+1) +". ^007700"+ [email protected]$[[email protected]] +" "+([email protected][[email protected]] ? "(VIP)" : "" )+" - ^007700"+([email protected][[email protected]] ? "Online":"Offline" )+"^000000"; } close; } it shall include offline players too.

https://rathena.org/board/topic/118628-grf-encryption-file-not-found/
 

try change
else if ( !getcharid( 2,[email protected]$ ) ) { mes .npcname$; mes "^ff0000"[email protected]yer$+" is not a member of your guild."; close; } into
else if ( !getcharid(2) || getcharid(2) != getcharid( 2,[email protected]$ ) ) { mes .npcname$; mes "^ff0000"[email protected]yer$+" is not a member of your guild."; close; }  

query_sql("SELECT `messaggio` FROM `discordbot` WHERE `id` = 1", [email protected]$); announce "Discord> " + escape_sql([email protected]$), 0, 0x0965f9; and its not advised to use `SELECT * FROM ...` in query, its a common mistake did by alot beginner when they didnt aware of the total columns returned by the script command.
and each array assigned are meant for each individual column.

sql-files/upgrades/upgrade_20181224.sql

try this.
https://pastebin.com/9TBUuFTn

prontera,155,181,5 script sample 4_F_KAFRA1,{ for ([email protected] = bStr; [email protected] <= bLuk; [email protected]++) if (readparam([email protected]) >= 165) { mes "ok! you have stats that are over 165."; close; } mes "is not good, you dont have stats that is over 165."; close; }  

quote it so that I could mark this topic solved.

the errors are pretty much self explained.... item id doesn't exists in your db.
if you're using pre-re make sure your item exists in the db/pre-re/item_db.txt

you probably changed a new client or renamed it.
just use the GRF Editor to generate a new cps.dll using the new client you made.

-    script    OnlineReward#1    -1,{   //--Start of the Script OnPCLoginEvent: attachnpctimer ""+strcharinfo(0)+""; initnpctimer; end;     OnTimer30000: //Check if Vending (normal or @at) if(checkvending() >= 1) {     dispbottom "The rewards has stopped because you were vending . Please relog if you wish to start again.";     stopnpctimer;     end; }   OnTimer60000: set @minute, @minute + 1; //Check for 1 Minute if(@minute == 1 && (strcharinfo(3) == "prontera" || strcharinfo(3) == "payon")){     set @minute,0;     set #CASHPOINTS,#CASHPOINTS+100;     dispbottom "You received 100 Cash Points. Current Cash Points: " + #CASHPOINTS; } stopnpctimer; initnpctimer; end; } if(@minute == 1 && (strcharinfo(3) == "prontera" || strcharinfo(3) == "payon")){  

you can check on the message by clicking on the tick or cross symbols. 
It refer to the job for both appveyor and travis

you can click on the details to further read the details for each job.

use unitkill() instead.  percentheal aren't a good example although it do the same trick.
{ skilleffect "AC_CONCENTRATION",0; if (rand(100) < 50) unitkill getcharid(3); },{},{}  

disable this settings to enable vending near npc
conf/battle/player.conf#L174-L176

i think this should do the trick.
itemID, ..........., { progressbar "0xFFFFFF", 5; unitskilluseid getcharid(3), "NPC_SELFDESTRUCTION", 1; },{ },{ }  

you can try this, i think it should do the trick.
prontera,155,181,5 script Sample 4_F_KAFRA1,{ OnRetry: [email protected]_id = getcharid(2); query_sql("SELECT `guild_lv` FROM `guild` WHERE `guild_id` = "[email protected]_id, [email protected]_lv); if ([email protected]_id || [email protected]_lv) { mes "Guild not found, or kindly retry."; if ([email protected]_id) if (select("Retry", "Cancel") == 1) { requestguildinfo([email protected]_id, strnpcinfo(3)+"::OnRetry"); } close; } else if (getguildmasterid([email protected]_id) != getcharid(0)) { mes "You're not guild master."; close; } else if ([email protected]_lv >= 50) { mes "Your guild already reached max level."; close; } // increase guild exp if ([email protected]_lv <= 1) guildgetexp(100000); if ([email protected]_lv <= 2) guildgetexp(400000); if ([email protected]_lv <= 3) guildgetexp(900000); if ([email protected]_lv <= 4) guildgetexp(1600000); if ([email protected]_lv <= 5) guildgetexp(2500000); if ([email protected]_lv <= 6) guildgetexp(3600000); if ([email protected]_lv <= 7) guildgetexp(4900000); if ([email protected]_lv <= 8) guildgetexp(6400000); if ([email protected]_lv <= 9) guildgetexp(8100000); if ([email protected]_lv <= 10) guildgetexp(10000000); if ([email protected]_lv <= 11) guildgetexp(12100000); if ([email protected]_lv <= 12) guildgetexp(14400000); if ([email protected]_lv <= 13) guildgetexp(16900000); if ([email protected]_lv <= 14) guildgetexp(19600000); if ([email protected]_lv <= 15) guildgetexp(22500000); if ([email protected]_lv <= 16) guildgetexp(25600000); if ([email protected]_lv <= 17) guildgetexp(28900000); if ([email protected]_lv <= 18) guildgetexp(32400000); if ([email protected]_lv <= 19) guildgetexp(36100000); if ([email protected]_lv <= 20) guildgetexp(40000000); if ([email protected]_lv <= 21) guildgetexp(44100000); if ([email protected]_lv <= 22) guildgetexp(48400000); if ([email protected]_lv <= 23) guildgetexp(52900000); if ([email protected]_lv <= 24) guildgetexp(57600000); if ([email protected]_lv <= 25) guildgetexp(62500000); if ([email protected]_lv <= 26) guildgetexp(67600000); if ([email protected]_lv <= 27) guildgetexp(72900000); if ([email protected]_lv <= 28) guildgetexp(78400000); if ([email protected]_lv <= 29) guildgetexp(84100000); if ([email protected]_lv <= 30) guildgetexp(90000000); if ([email protected]_lv <= 31) guildgetexp(96100000); if ([email protected]_lv <= 32) guildgetexp(102400000); if ([email protected]_lv <= 33) guildgetexp(108900000); if ([email protected]_lv <= 34) guildgetexp(115600000); if ([email protected]_lv <= 35) guildgetexp(122500000); if ([email protected]_lv <= 36) guildgetexp(129600000); if ([email protected]_lv <= 37) guildgetexp(136900000); if ([email protected]_lv <= 38) guildgetexp(144400000); if ([email protected]_lv <= 39) guildgetexp(152100000); if ([email protected]_lv <= 40) guildgetexp(160000000); if ([email protected]_lv <= 41) guildgetexp(168100000); if ([email protected]_lv <= 42) guildgetexp(176400000); if ([email protected]_lv <= 43) guildgetexp(184900000); if ([email protected]_lv <= 44) guildgetexp(193600000); if ([email protected]_lv <= 45) guildgetexp(202500000); if ([email protected]_lv <= 46) guildgetexp(211600000); if ([email protected]_lv <= 47) guildgetexp(220900000); if ([email protected]_lv <= 48) guildgetexp(230400000); if ([email protected]_lv <= 49) guildgetexp(240100000); if ([email protected]_lv < 50) guildgetexp(250000000); // guild skills. guildskill(10000,1); guildskill(10001,1); guildskill(10002,1); guildskill(10003,3); guildskill(10004,10); guildskill(10005,1); guildskill(10006,5); guildskill(10007,5); guildskill(10008,5); guildskill(10009,5); guildskill(10010,1); guildskill(10011,3); guildskill(10012,1); guildskill(10013,1); guildskill(10014,1); guildskill(10016,5); mes "Done"; close; } it would be more accurate if there was a script command like *getguildinfo that retrieve the guild information.

prontera,155,181,5 script Sample 4_F_KAFRA1,{ mes "Warp to "+.map$+" ?"; if (.item_id_size) { for ([email protected] = 0; [email protected] < .item_id_size; [email protected]++) { mes "> "+.item_qty[[email protected]]+"x "+getitemname(.item_id[[email protected]]); if (countitem(.item_id[[email protected]]) < .item_qty[[email protected]]) [email protected]++; } } if (select("Warp", "Cancel") == 1) { if ([email protected]) { mes "You didnt have enough items."; } else { if (.item_id_size) for ([email protected] = 0; [email protected] < .item_id_size; [email protected]++) delitem .item_id[[email protected]], .item_qty[[email protected]]; warp .map$, 0, 0; } } close; OnInit: .map$ = "prontera"; setarray .item_id, 501, 502, 503; setarray .item_qty, 100, 200, 300; .item_id_size = getarraysize(.item_id); end; }  

// +10 HP for every refines. bonus bMaxHP, (getrefine() * 10); // +10 HP for every 2 refines. bonus bMaxHP, ((getrefine() / 2) * 10); // +10 HP for every 3 refines. bonus bMaxHP, ((getrefine() / 3) * 10); // +10 HP for every 4 refines. bonus bMaxHP, ((getrefine() / 4) * 10); // +10 HP for every 5 refines. bonus bMaxHP, ((getrefine() / 5) * 10);  

if i am not mistaken about it ...
Navi_Mob = { { "abbey01", --> Map Name 20594, --> Unique Code 300, --> Monster Type (300 = Normal Mob, 301 = MVP) 3736588, --> (Not sure) "구울", --> Monster Name 1 "GHOUL", --> Monster Name 2 (Sprite Name) 61, --> Mob Level 3211521 --> (Not sure) },  
additional info.
https://github.com/HerculesWS/StaffPlugins/blob/master/Haru/naviluagenerator/naviluagenerator.c#L397-L418

try this
https://pastebin.com/RCqBbTc1

try this.
https://pastebin.com/kT7Gy5NH

shutdown server and execute this query
ALTER TABLE `login` ADD `last_login_date` DATETIME; UPDATE `login` SET `last_login_date` = `last_login` WHERE `last_login_date` IS NULL then load this npc.
https://pastebin.com/hduVVqPB

both are same, the below picture show the korea letters.
for grf, you just need to change the encoding.
GRF > Setting > Display Encoding > Korean