Emistry

you could try this.
https://pastebin.com/SY05Vjxr

conf/battle/drops.conf#L143-L150

prontera,155,181,5 script Sample 4_F_KAFRA1,{ if (getcharid(3) <= 150001) { if (#COMPENSATION_REWARD <= 0) { #COMPENSATION_REWARD = gettimetick(2); getitem 501, 1; getitem 501, 2; getitem 501, 3; mes "You gained reward for the compensation."; close; } } end; } define the account id here
if (getcharid(3) <= 150001) {  

prontera,155,181,5 script Sample 4_F_KAFRA1,{ if (getgroupid() == 1) { [email protected] = gettime(8); if (#DAILY_VIP_REWARD != [email protected]) { #DAILY_VIP_REWARD = [email protected]; getitem 501, 1; getitem 501, 2; getitem 501, 3; mes "You gained reward for todays."; close; } } end; }  

it return more than 1 field.

 
you need to provide the array to store other fields that returned from the query.
query_sql("SHOW COLUMNS FROM `login` LIKE 'magic_shop%'", [email protected]$, [email protected]$, [email protected]$, [email protected]$, [email protected]$, [email protected]$); return getarraysize([email protected]$);  

prontera,155,181,5 script Sample 4_F_KAFRA1,{ if (getgmlevel() >= 99) { mes "Enter player name"; input [email protected]$; mes [email protected]$ + " has "+ readparam(CASHPOINT_VAR,[email protected]$) + " cashpoints"; close; } end; }  

you didnt execute the database upgrade files from gepard shield itself.

try this 
https://pastebin.com/K0w5yFDL
 

i dont see  why there is a need of using my multi currency shop.
its hack-able since years ago after emulator has removed some "feature" that make it no longer safe.
 
rathena has already introduced the point system which is fairly easier to use, why doesnt use it?
 

here is a slightly updated version...
https://pastebin.com/gwaeHFd4
[Debug]: script debug : 0 110017945 : SQL Mall - HEALING - Loaded 189 Item(s) [Debug]: script debug : 0 110017945 : SQL Mall - USABLE - Loaded 594 Item(s) [Debug]: script debug : 0 110017945 : SQL Mall - ETC - Loaded 1,533 Item(s) [Debug]: script debug : 0 110017945 : SQL Mall - WEAPON - Loaded 605 Item(s) [Debug]: script debug : 0 110017945 : SQL Mall - NPC not found - Shop#t_4_12 [Debug]: script debug : 0 110017945 : SQL Mall - ARMOR - Loaded 1,100 Item(s) [Debug]: script debug : 0 110017945 : SQL Mall - CARD - Loaded 439 Item(s) [Debug]: script debug : 0 110017945 : SQL Mall - PETEGG - Loaded 1 Item(s) [Debug]: script debug : 0 110017945 : SQL Mall - PETARMOR - Loaded 1 Item(s) [Debug]: script debug : 0 110017945 : SQL Mall - AMMO - Loaded 1 Item(s) [Debug]: script debug : 0 110017945 : SQL Mall - DELAYCONSUME - Loaded 1 Item(s) [Debug]: script debug : 0 110017945 : SQL Mall - CASH - Loaded 733 Item(s)  

remove item with 0 cost auto hide any extra npc (naming dependent) fix some item cost  

@Wickedknight2 your method aren't quite correct, you shall randomize the value when it roll the items. Otherwise your script end up always giving the same item.
 
could try something like this.
https://pastebin.com/PZzpiz6V

https://rathena.org/board/topic/90790-mini-map-help/?do=findComment&amp;comment=237632

try
https://pastebin.com/L9x6bXQn

https://pastebin.com/ug6wrJEJ
try

you can try something like this.
https://pastebin.com/SXR3dGKU
@create hello world // create an event that required player to enter "hello world" @end // end the event @type // enter hello world  

OnPCLoginEvent: query_sql("SELECT COUNT(`char_id`) FROM `char` WHERE `online` = 1 AND `account_id` IN (SELECT `account_id` FROM `login` WHERE `last_ip` = '"+getcharip()+"')", [email protected]); if ([email protected] >= 3) { mes "Login count per IP exceed."; sleep2 3000; atcommand "@kick "+strcharinfo(0); } end; can try something like this.

https://pastebin.com/BNTZveAc

https://rathena.org/board/topic/105789-utility-sql-job-changer/

function script Count { if (#c > 0) { #c--; dispbottom "You can use it again "+ #c +" times more."; sc_start SC_INCREASEAGI,240000,10; delitem xxx,1; } return; }  

hmm, seem like I tried script it long ago, forgotten to post it, cant remember if the script are completed or not .. 
https://pastebin.com/gMRsG4by

something like this ?
https://pastebin.com/hpdUzSf7

something like this ?
https://pastebin.com/cfnTDZYB

prontera,155,181,5 script PVP Warper 4_F_KAFRA1,{ for ([email protected] = 0; [email protected] < .map_size; [email protected]++) [email protected]$ = [email protected]$ + .map$[[email protected]] + "("+getmapusers(.map$[[email protected]])+" user(s))" + ":"; [email protected] = select([email protected]$) - 1; mapannounce .map$[[email protected]], strcharinfo(0)+ " has entered this PVP room.", bc_map; warp .map$[[email protected]], 0, 0; end; OnInit: setarray .map$, "prontera", "payon", "izlude"; .map_size = getarraysize(.map$); end; }  

dispbottom "============== My Rank ==============", 0xffe066; query_sql( "SELECT `points`, 1 + (SELECT COUNT(1) FROM `mvp_ranking` t1 WHERE t1.`points` > t2.`points`) FROM `mvp_ranking` t2 WHERE `char_id` = "+ getcharid(0), [email protected], [email protected]); dispbottom "My Rank is: " + [email protected]+ ".", 0x6666ff; dispbottom "My Points is: " + [email protected]+ ".", 0x6666ff; dispbottom "==========================================", 0xffe066; try this