noobonly

Hi I would like to ask about emistry's item collector, is it possible to make it by account, it seems that if you have 2 characters in one account and submitted items it will count the item on both characters? any help on how to make it if one character already submitted if another one submitted on the same account it will increment on the said account and the first character instead of having 2 entries for the ranking /* CREATE TABLE IF NOT EXISTS `e_npc_trade_item` ( `cid` INT(11) UNSIGNED NOT NULL DEFAULT '0', `name` VARCHAR(30) NOT NULL DEFAULT '', `nameid` INT(11) UNSIGNED NOT NULL DEFAULT '0', `amount` INT(11) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (`cid`,`nameid`,`amount`) ) ENGINE=MyISAM; */ prontera,155,175,5 script Item Collector 4_F_KAFRA9,{ doevent "trade_item_main::OnTalk"; } - script trade_item_main -1,{ function func_DisallowItem { switch ( getarg( 0,0 ) ) { default: return 0; // case <itemID>: case 501: // Red Potion case 502: // Orange Potion case 4001: // Poring Card return 1; } return 0; } OnInit: // Top Rank .top_rank = 10; // NPC take what item ID, 0 = all items. .only_one_itemid = 512; end; OnTalk: .@is_gm = ( getgmlevel() >= 99 ); mes "^0055FF[ Item Collector ]^000000"; mes "Do you have any used items? You may give it to me."; mes " "; mes "I'll always remember who giveaway his items to me."; next; switch( select( "View Top "+.top_rank+" Rank", "Give Item to NPC", ( .@is_gm ) ? "[GM] Reset" : "" )) { default: do { switch( select( "Filter by Name", ( .only_one_itemid ) ? "":"Filter by ItemID", "Without Filter" ) ) { case 1: mes "Enter Char Name"; break; case 2: mes "Enter ItemID"; break; default: break; } if ( @menu && @menu < 3 ) { next; input .@input$; } .@sql$ = "SELECT `name`, `nameid`, SUM(`amount`) AS `total` " + "FROM `e_npc_trade_item` " + "WHERE 1 = 1 " + ( .only_one_itemid ? "AND `nameid` = "+.only_one_itemid+" " : "" ) + ( ( @menu == 1 ) ? "AND `name` = '"+escape_sql( .@input$ )+"' " : "" ) + ( ( @menu == 2 ) ? "AND `nameid` = '"+escape_sql( .@input$ )+"' " : "" ) + "GROUP BY `cid`,`nameid` " + "ORDER BY `total` DESC LIMIT "+.top_rank; query_sql( .@sql$,.@name$,.@nameid,.@total ); .@size = getarraysize( .@name$ ); mes "Top "+.top_rank+" Records:"; if ( .@size ) { for ( .@i = 0; .@i < .@size; .@i++ ) { mes "["+(.@i+1)+".] '"+getitemname( .@nameid[.@i] )+"' ("+.@total[.@i]+"ea) - '"+.@name$[.@i]+"' "; } } else { mes "no record found."; } next; } while ( 1 ); break; case 2: if ( !.only_one_itemid ) { mes "Pick an item and give to me"; getinventorylist; for ( .@i = 0; .@i < @inventorylist_count; .@i++ ) { if ( @inventorylist_bound[.@i] <= 0 && @inventorylist_expire[.@i] <= 0 && @inventorylist_equip[.@i] <= 0 && func_DisallowItem( @inventorylist_id[.@i] ) <= 0 ) { .@menu$ = .@menu$ + getitemname( @inventorylist_id[.@i] ) + " ("+@inventorylist_amount[.@i]+" left)"; .@count++; } .@menu$ = .@menu$ + ":"; } if ( .@count ) { .@i = select( .@menu$ ) - 1; .@itemid = @inventorylist_id[.@i]; } } else { .@itemid = .only_one_itemid; .@count++; } if ( .@itemid ) { mes "How many "+getitemname( .@itemid )+" will be given to me?"; input .@amount,0,countitem( .@itemid ); if ( .@amount ) { delitem .@itemid,.@amount; npctalk "Thank you, "+strcharinfo(0)+" donated "+.@amount+"x "+getitemname( .@itemid )+" to me."; query_sql( "INSERT INTO `e_npc_trade_item` ( `cid`,`name`,`nameid`,`amount` ) VALUES ( "+getcharid(0)+",'"+escape_sql( strcharinfo(0) )+"',"+.@itemid+","+.@amount+" ) ON DUPLICATE KEY UPDATE `amount` = `amount` + "+.@amount ); mes "Thank for your kindness."; } } else { mes "You dont have any item available to give to NPC."; } break; case 3: mes "This action cant be undo, confirm your action?"; next; if ( select( "Yes, confirm.","Cancel" ) == 1 ) { query_sql( "TRUNCATE `e_npc_trade_item`" ); } break; } close; }

edit fixed.

/* CREATE TABLE IF NOT EXISTS `e_npc_trade_item` ( `cid` INT(11) UNSIGNED NOT NULL DEFAULT '0', `name` VARCHAR(30) NOT NULL DEFAULT '', `nameid` INT(11) UNSIGNED NOT NULL DEFAULT '0', `amount` INT(11) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (`cid`,`nameid`,`amount`) ) ENGINE=MyISAM; */ prontera,155,175,5 script Item Collector 4_F_KAFRA9,{ doevent "trade_item_main::OnTalk"; } - script trade_item_main -1,{ function func_DisallowItem { switch ( getarg( 0,0 ) ) { default: return 0; // case <itemID>: case 501: // Red Potion case 502: // Orange Potion case 4001: // Poring Card return 1; } return 0; } OnInit: // Top Rank .top_rank = 10; // NPC take what item ID, 0 = all items. .only_one_itemid = 512; end; OnTalk: .@is_gm = ( getgmlevel() >= 99 ); mes "^0055FF[ Item Collector ]^000000"; mes "Do you have any used items? You may give it to me."; mes " "; mes "I'll always remember who giveaway his items to me."; next; switch( select( "View Top "+.top_rank+" Rank", "Give Item to NPC", ( .@is_gm ) ? "[GM] Reset" : "" )) { default: do { switch( select( "Filter by Name", ( .only_one_itemid ) ? "":"Filter by ItemID", "Without Filter" ) ) { case 1: mes "Enter Char Name"; break; case 2: mes "Enter ItemID"; break; default: break; } if ( @menu && @menu < 3 ) { next; input .@input$; } .@sql$ = "SELECT `name`, `nameid`, SUM(`amount`) AS `total` " + "FROM `e_npc_trade_item` " + "WHERE 1 = 1 " + ( .only_one_itemid ? "AND `nameid` = "+.only_one_itemid+" " : "" ) + ( ( @menu == 1 ) ? "AND `name` = '"+escape_sql( .@input$ )+"' " : "" ) + ( ( @menu == 2 ) ? "AND `nameid` = '"+escape_sql( .@input$ )+"' " : "" ) + "GROUP BY `cid`,`nameid` " + "ORDER BY `total` DESC LIMIT "+.top_rank; query_sql( .@sql$,.@name$,.@nameid,.@total ); .@size = getarraysize( .@name$ ); mes "Top "+.top_rank+" Records:"; if ( .@size ) { for ( .@i = 0; .@i < .@size; .@i++ ) { mes "["+(.@i+1)+".] '"+getitemname( .@nameid[.@i] )+"' ("+.@total[.@i]+"ea) - '"+.@name$[.@i]+"' "; } } else { mes "no record found."; } next; } while ( 1 ); break; case 2: if ( !.only_one_itemid ) { mes "Pick an item and give to me"; getinventorylist; for ( .@i = 0; .@i < @inventorylist_count; .@i++ ) { if ( @inventorylist_bound[.@i] <= 0 && @inventorylist_expire[.@i] <= 0 && @inventorylist_equip[.@i] <= 0 && func_DisallowItem( @inventorylist_id[.@i] ) <= 0 ) { .@menu$ = .@menu$ + getitemname( @inventorylist_id[.@i] ) + " ("+@inventorylist_amount[.@i]+" left)"; .@count++; } .@menu$ = .@menu$ + ":"; } if ( .@count ) { .@i = select( .@menu$ ) - 1; .@itemid = @inventorylist_id[.@i]; } } else { .@itemid = .only_one_itemid; .@count++; } if ( .@itemid ) { mes "How many "+getitemname( .@itemid )+" will be given to me?"; input .@amount,0,countitem( .@itemid ); if ( .@amount ) { delitem .@itemid,.@amount; npctalk "Thank you, "+strcharinfo(0)+" donated "+.@amount+"x "+getitemname( .@itemid )+" to me."; query_sql( "INSERT INTO `e_npc_trade_item` ( `cid`,`name`,`nameid`,`amount` ) VALUES ( "+getcharid(0)+",'"+escape_sql( strcharinfo(0) )+"',"+.@itemid+","+.@amount+" ) ON DUPLICATE KEY UPDATE `amount` = `amount` + "+.@amount ); mes "Thank for your kindness."; } } else { mes "You dont have any item available to give to NPC."; } break; case 3: mes "This action cant be undo, confirm your action?"; next; if ( select( "Yes, confirm.","Cancel" ) == 1 ) { query_sql( "TRUNCATE `e_npc_trade_item`" ); } break; } close; } How to make it not use sum instead make the items convert it to points, for example 1 apple = 1 itemcollectpoints instead of having it sum up everything in the table that was collected? That way the ranking npc wouldnt need to have the filters such as what item id and just show who had the most recycled items instead.

No that doesn't suit my needs. The request would be 1 shop which uses 5 different coins. Gold Silver Bronze Mithrill and Platinum. Some Items will require Gold and Silver, some will require Bronze and Mithrill at the same time, i know it can be scripted using the simple scripting with delitem and getitem etc, but i want to use the shop function/display. Hello I have this shop wherein you can use poring coin to purchase an item but i want to use different coins - shop custom_merchant -1,501:2000000 prontera,150,150,4 script Poring Coin Shop 100,{ mes "[Poring Coin Shop]"; mes "Hello! " + strcharinfo(0) +"..."; mes "I can sell you items in exchange for your Poring Coins"; callshop "custom_merchant",1; npcshopattach "custom_merchant"; end; OnBuyItem: for(set .@i,0; .@i<getarraysize(.itemsforsale); set .@i,.@i+1) { for(set .@d,0; .@d<getarraysize(@item_nameid); set .@d,.@d+1) { if(@item_nameid[.@d]==.itemsforsale[.@i]) { if(checkweight(@item_nameid[.@d],@item_count[.@d])) { if(countitem(.PriceItemID) >= .Price[.@i]*@item_count[.@d]) { delitem .PriceItemID,.Price[.@i]*@item_count[.@d]; getitem @item_nameid[.@d],@item_count[.@d]; } else dispbottom "You don't have enough "+getitemname(.PriceItemID)+" to buy the item."; } else dispbottom "You are overweight! Get rid of the unnecessary items first."; } } } deletearray @item_count, getarraysize(@item_count); deletearray @item_nameid, getarraysize(@item_nameid); close; OnInit: setarray .itemsforsale[0],501,502,503,504,505,506,507,508,509,510,511; set .PriceItemID,7539; setarray .Price[0],60,80,70,80,120,80,60,70,3,15,1; npcshopitem "custom_merchant",0,0; // Don't touch any coding beyond here for(set .i,0; .itemsforsale[.i]; set .i,.i+1) npcshopadditem "custom_merchant",.itemsforsale[.i],.Price[.i]; end; } How to set it to have 5 different coins as payment, some items may need 2 different coins some will need 4. The thing about Euphy's Quest Shop is you can't have the same item or reward. I want something with the same reward item multiple times. Hi is it possible to make this script allow 3 different coins per shop //===== eAthena Script ======================================= //= Custom-Currency Multi-Shop //===== By: ================================================== //= Euphy //===== Current Version: ===================================== //= 1.2 //===== Description: ========================================= //= Allows for better organization in a single shop call. //= Note that there are two configuration areas. //============================================================ // -------------------- Config 1 -------------------- // For each shop added, copy this MSHOPX dummy data. // Write your shop names in the select() function. - shop MSHOP1 -1,512:-1 - shop MSHOP2 -1,512:-1 - shop MSHOP3 -1,512:-1 - shop MSHOP4 -1,512:-1 - shop MSHOP5 -1,512:-1 - shop MSHOP6 -1,512:-1 - shop MSHOP7 -1,512:-1 - shop MSHOP8 -1,512:-1 prontera,163,174,4 script A Shop 984,{ set @s, select("Weapons:Headgears:Armors:Garments:Shoes:Shields:Cards:Misc"); // -------------------------------------------------- message strcharinfo(0),"This shop only accepts "+getitemname(.Currency[@s])+"."; dispbottom "You have "+countitem(.Currency[@s])+" "+getitemname(.Currency[@s])+"."; callshop "MSHOP"+@s,1; npcshopattach "MSHOP"+@s; end; OnBuyItem: set .@i,0; while (.@i < getarraysize(@bought_nameid)) { set .@j, 0; while (.@j < getarraysize(getd(".Shop"+@s))) { if(getd(".Shop"+@s+"["+.@j+"]") == @bought_nameid[.@i]) { set @itemcost, (getd(".Shop"+@s+"["+(.@j+1)+"]") * @bought_quantity[.@i]); set @totalcost, @totalcost + @itemcost; break; } set .@j, .@j+2; } set .@i, .@i+1; } if (@totalcost > countitem(.Currency[@s])) dispbottom "You don't have enough "+getitemname(.Currency[@s])+"."; else { set .@i,0; while (.@i < getarraysize(@bought_nameid)) { getitem @bought_nameid[.@i], @bought_quantity[.@i]; dispbottom "Purchased "+@bought_quantity[.@i]+"x "+getitemname(@bought_nameid[.@i])+"."; set .@i, .@i+1; } delitem .Currency[@s], @totalcost; } set @totalcost, 0; deletearray @bought_nameid[0], 128; deletearray @bought_quantity[0], 128; end; OnInit: // -------------------- Config 2 -------------------- // Currency: The ID of each shop currency, // in the same order as the shops. // Shop order follows that of the select() call, // and is formatted "ID1,Count1,ID2,Count2,..." setarray .Currency[1],513,513,513,513,513,513,513,513; setarray .Shop1[0],1202,5,1229,20; setarray .Shop2[0],5116,15; setarray .Shop3[0],2302,2,2348,30; setarray .Shop4[0],2502,2,2513,15,2523,15; setarray .Shop5[0],2441,15; setarray .Shop6[0],2199,32768; setarray .Shop7[0],4051,3,4285,6; setarray .Shop8[0],513,1,532,2,634,4; // -------------------------------------------------- set .@i,1; while (.@i <= getarraysize(.Currency)) { set .@j,0; while (.@j < getarraysize(getd(".Shop"+.@i))) { npcshopdelitem "MSHOP"+.@i,512; npcshopadditem "MSHOP"+.@i, getd(".Shop"+.@i+"["+.@j+"]"), getd(".Shop"+.@i+"["+(.@j+1)+"]"); set .@j, .@j+2; } set .@i, .@i+1; } end; }

Hello, is it possible to script a shop which calls the shop functions that will sell items for example 1 Kafra doll = 1 poring coin, 1 gold coin and 1 mithrill coin. 1 poopoo hat = 1 bronze coin 1 gold coin and 1 mithrill coin. in one npc? if you can give me a sample that would be awesome. Thank you. I have 5 different coins for the said shop some items will be needing 3 of the 5 some will need 2 of the 5 coins,

BUMP on this.

Thanks a lot it helped!

so the one i posted is wrong? nvm got it fixed. Thanks.

Im running version 2.9 and I want to ask if its possible to add an automatic monthly reset and give prizes to the top ranker, by kills. Im trying this if you can check if this is correct The script //===== eAthena Script ======================================================= //= PVP ladder script with dota announcement ( SQL only ) //===== By: ================================================================== //= ~AnnieRuru~ //===== Current Version: ===================================================== //= 2.9 //= 3.0 modified by Gerome //===== Compatible With: ===================================================== //= eAthena SQL 14279, with MySQL 5.1 //= rAthena //===== Description: ========================================================= //= PVP ladder store in SQL table //= plus anti-sit-killer feature //===== Topic ================================================================ //= http://www.eathena.ws/board/index.php?showtopic=177918 //===== Additional Comments: ================================================= //= still don't have modify value option, will be done ... in next year ... //============================================================================ // add all the maps that you want this script to trigger ... all pvp and event maps perhaps ? // but if you already enable "all" maps, then can comment all these guild_vs1 mapflag loadevent guild_vs2 mapflag loadevent guild_vs3 mapflag loadevent guild_vs4 mapflag loadevent guild_vs5 mapflag loadevent pvp_y_8-2 mapflag loadevent pvp_y_8-4 mapflag loadevent pvp_y_8-5 mapflag loadevent - script DOTAPVP -1,{ OnInit: /* ***************************************************************************************** ** CONFIGURATION ** ****************************************************************************************/ /* ================== Sound Effects ===================================================/ *- soundeffect : 0 - disable, 1 - play soundeffect to all players on map, *- 2 - play soundeffect to an area around the killer, 3 - play soundeffect to killer only *- ======================================================================================*/ set .sound, 1; /* ================== Announce Target flags ===========================================/ *- bc_all: Broadcast message is sent server-wide (default). *- bc_map: Message is sent to everyone in the same map as the source of the broadcast. *- bc_area: Message is sent to players in the vicinity of the source. *- bc_self: Message is sent only to current player. *- You cannot use more than one target flag. *- =======================================================================================*/ set .announceFlag$, "bc_map"; /* ================== Announce Color ====================================================/ *- The color parameter is a single number which can be in hexadecimal notation. *- The color format is in RGB (0xRRGGBB). *- default "0xFFFF00" = Yellow *- =======================================================================================*/ set .announceColor$,"0xFFFF00"; set .announcemap, 1; // announce the map name in the announcement ? : 0 - off, 1 - on set .announcekill, 1; // announce who pawn who's head : 0 - off, 1 - on set .msg_die, 1; // show message who kill you when die : 0 - off, 1 - on set .msg_kill, 1; // show message you kill who when killed someone : 0 - off, 1 - on /* GMs are not suppose to kill players. A GM with <this number> level or higher will do nothing. ** IF set to 60, GM60 and above kill any player will not get anything : 0 - off */ set .gmnokill, 0; set .killingspree, 3; set .dominating, 4; set .megakill, 5; set .unstoppable, 6; set .wickedsick, 7; set .monsterkill, 8; set .godlike, 9; set .holyshit, 10; set .continue, 1; // after beyond-godlike, every <this number> kills will make announcement again set .owned, 5; // how many times the party/guild has to kill to announce ownage set .owncontinue, 1; // after ownage, every <this number> party/guild cumulative kills will make ownage announce again set .min_gm_menu, 90; // minimum level of GM can use the GM menu on ladder npc set .showtotal, 20; // show the length of ladder. Note : Maximum value = 128 set .showpage, 10; // set the views per page. Note : Maximum value = 128 set .loweststreak, 3; // mininum streak count allow to show in highest streak ladder. Default 3 means must at least have killing spree streak to display in ladder set .lowestownage, 5; // mininum ownage count allow to show in longest ownage ladder. Default 5 means must at least have 5 ownage counts to display in ladder setarray .maptrigger$, // only these maps will trigger this script // "all", // uncomment this to allow load all maps "guild_vs1", "guild_vs2", "guild_vs3", "guild_vs4", "guild_vs5"; /* ================== Anti-sit-killer System ======================================================/ * A player must kill another player with this minimum <this number> base level to get the announcement and in the ladder. * Otherwise only have streak ended announcement and killed player's streak reset. * Its possible for a level 1 novice to kill a level 99 player and he/she will still get in the ladder * but a level 99 kill a level 1 player will get nothing * 0 - off this system ( default is 55, pk setting ) * =================================================================================================*/ set .lvltokill, 0; // when a player kill another same player <this number> times in a row, the player is warp back to save point. // and the player's streak, kills, and ownage count will deduct accordingly // 0 - off this system set .counttopunish, 6; // minimum level range to kill another player // eg. when set to 20, player level 99 needs to kill another player with minimum level of 79 to get announcement and increase the kill rank. // but a player with base level 50 kills a level 99 will also get the announcement // higher base level cannot kill lower level, but lower level can kill higher level // 0 - off this system set .minlvlrange, 0; /*============================================ Config ends ========================================*/ /*==================================================================================================*/ // to prevent bug happen if ( .announce < 0 || .announce > 1 ) set .announce, 0; if ( .continue < 1 ) set .continue, 1; if ( .owncontinue < 1 ) set .owncontinue, 1; if ( .gmnokill <= 0 ) set .gmnokill, 100; if ( .lvltokill <= 1 ) set .lvltokill, 0; if ( .counttopunish <= 1 ) set .counttopunish, 0; set .maptriggersize, getarraysize(.maptrigger$); end; // script start. OnPCKillEvent: if ( getgroupid() >= .gmnokill ) end; getmapxy .@map$, .@x, .@y, BL_PC; if ( .maptrigger$ != "all" ) { for ( set .@i, 0; .@i < .maptriggersize; set .@i, .@i +1 ) { if ( .@map$ == .maptrigger$[.@i] ) break; } if ( .@i == .maptriggersize ) end; } attachrid killedrid; if ( killerrid != getcharid(3) && ( .msg_die || .msg_kill ) ) { if ( .msg_die ) message strcharinfo(0),"You have been killed by "+ rid2name(killerrid); if ( .msg_kill ) message rid2name(killerrid),"You just killed "+ strcharinfo(0); } if ( @PlayersKilledStreak >= .holyshit ) set .@streakname$,"Beyond Godlike"; else if ( @PlayersKilledStreak >= .godlike ) set .@streakname$,"Godlike"; else if ( @PlayersKilledStreak >= .monsterkill ) set .@streakname$,"Monster Kill"; else if ( @PlayersKilledStreak >= .wickedsick ) set .@streakname$,"Wicked Sick"; else if ( @PlayersKilledStreak >= .unstoppable ) set .@streakname$,"Unstoppable"; else if ( @PlayersKilledStreak >= .megakill ) set .@streakname$,"Mega-kill"; else if ( @PlayersKilledStreak >= .dominating ) set .@streakname$,"Dominating"; else if ( @PlayersKilledStreak >= .killingspree ) set .@streakname$,"Killing Spree"; if ( @PlayersKilledStreak >= .killingspree && killerrid == getcharid(3) ) announce strcharinfo(0) +" has ended "+( (sex)?"him":"her" )+" own "+ .@streakname$ +"["+ @PlayersKilledStreak +"] streak "+( (.announcemap)?("at "+ .@map$):""),atoi(.announceFlag$), .announceColor$; else if ( @PlayersKilledStreak >= .killingspree ) announce rid2name(killerrid) +" has ended "+ strcharinfo(0) +"'s "+ .@streakname$ +"["+ @PlayersKilledStreak +"] streak "+( (.announcemap)?("at "+ .@map$):""),atoi(.announceFlag$), .announceColor$; else if ( .announcekill && killerrid != getcharid(3) ) announce rid2name(killerrid) +" has pawned "+ strcharinfo(0) +"'s head "+( (.announcemap)?("at "+ .@map$):""),atoi(.announceFlag$), .announceColor$; set @PlayersKilledStreak,0; set @dota_sql_deaths, @dota_sql_deaths +1; set @dota_multikills,0; query_sql "replace into pvpladder values ( "+ getcharid(0) +", '"+ escape_sql(strcharinfo(0)) +"', "+ @dota_sql_streaks +", "+ @dota_sql_kills +", "+ @dota_sql_deaths +", from_unixtime("+ @dota_sql_streaktime +") )"; set .@killed_gid, getcharid(2); if ( .@killed_gid ) { setd ".dota_sql_"+ .@killed_gid +"_c", 0; if ( getd(".dota_sql_"+ .@killed_gid +"_h") ) query_sql "replace into ownladder values ( "+ .@killed_gid +", '"+ escape_sql(getguildname(.@killed_gid)) +"', "+ getd(".dota_sql_"+ .@killed_gid +"_c") +", "+ getd(".dota_sql_"+ .@killed_gid +"_h") +", from_unixtime("+ getd(".dota_sql_"+ .@killed_gid +"_t") +") )"; } if ( killerrid == getcharid(3) || baselevel < .lvltokill ) end; if ( .minlvlrange ) set .@killedlvl, baselevel; attachrid killerrid; if ( .minlvlrange && .@killedlvl + .minlvlrange < baselevel ) end; if ( .counttopunish ) { if ( @sitkillminute != gettime(2) ) { deletearray @sitkillid, 128; deletearray @sitkilltimes, 128; set @sitkillminute, gettime(2); } set .@sitkillsize, getarraysize(@sitkillid); for ( set .@i,0; .@i < .@sitkillsize; set .@i, .@i +1 ) { if ( @sitkillid[.@i] != killedrid ) continue; else { set @sitkilltimes[.@i], @sitkilltimes[.@i] +1 ; if ( @sitkilltimes[.@i] >= .counttopunish ) { warp "SavePoint",0,0; announce strcharinfo(0) +" , Stop killing "+ rid2name(killedrid) + " !!!",0; debugmes strcharinfo(0) +" is sit-killing "+ rid2name(killedrid) +" for "+ @sitkilltimes[.@i] + " times"; logmes "is sit-killing "+ rid2name(killedrid) +" for "+ @sitkilltimes[.@i] +" times"; if ( @PlayersKilledStreak == @dota_sql_streaks ) { set @dota_sql_streaks, @dota_sql_streaks +1 - .counttopunish; set @dota_sql_streaktime, gettimetick(2); } set @PlayersKilledStreak, @PlayersKilledStreak +1 - .counttopunish; set @dota_sql_kills, @dota_sql_kills +1 - .counttopunish; query_sql "replace into pvpladder values ( "+ getcharid(0) +", '"+ escape_sql(strcharinfo(0)) +"', "+ @dota_sql_streaks +", "+ @dota_sql_kills +", "+ @dota_sql_deaths +", from_unixtime("+ @dota_sql_streaktime +") )"; set .@killer_gid, getcharid(2); if ( .@killer_gid ) { if ( getd(".dota_sql_"+ .@killer_gid +"_c") == getd(".dota_sql_"+ .@killer_gid +"_h") ) { setd ".dota_sql_"+ .@killer_gid +"_h", getd(".dota_sql_"+ .@killer_gid +"_h") +1 - .counttopunish; setd ".dota_sql_"+ .@killer_gid +"_t", gettimetick(2); } setd (".dota_sql_"+ .@killer_gid +"_c"), getd(".dota_sql_"+ .@killer_gid +"_c") +1 - .counttopunish; query_sql "replace into ownladder values ( "+ .@killer_gid +", '"+ escape_sql(getguildname(.@killer_gid)) +"', "+ getd(".dota_sql_"+ .@killer_gid +"_c") +", "+ getd(".dota_sql_"+ .@killer_gid +"_h") +", from_unixtime("+ getd(".dota_sql_"+ .@killer_gid +"_t") +") )"; } end; } break; } } if ( .@i == .@sitkillsize ) { set @sitkillid[.@i], killedrid; set @sitkilltimes[.@i], 1; } } set @PlayersKilledStreak, @PlayersKilledStreak +1 ; set @dota_sql_kills, @dota_sql_kills +1 ; if ( @PlayersKilledStreak > @dota_sql_streaks ) { set @dota_sql_streaks, @PlayersKilledStreak; set @dota_sql_streaktime, gettimetick(2); } query_sql "replace into pvpladder values ( "+ getcharid(0) +", '"+ escape_sql(strcharinfo(0)) +"', "+ @dota_sql_streaks +", "+ @dota_sql_kills +", "+ @dota_sql_deaths +", from_unixtime("+ @dota_sql_streaktime +") )"; if ( @PlayersKilledStreak == .killingspree ) setarray .@streakname$,"killingspree.wav","is on a KILLING SPREE","!"; else if ( @PlayersKilledStreak == .dominating ) setarray .@streakname$,"dominating.wav","is DOMINATING","!"; else if ( @PlayersKilledStreak == .megakill ) setarray .@streakname$,"megakill.wav","has a MEGA KILL","!"; else if ( @PlayersKilledStreak == .unstoppable ) setarray .@streakname$,"unstoppable.wav","is UNSTOPPABLE","!!"; else if ( @PlayersKilledStreak == .wickedsick ) setarray .@streakname$,"wickedsick.wav","is WICKED SICK","!!"; else if ( @PlayersKilledStreak == .monsterkill ) setarray .@streakname$,"monsterkill.wav","has a MONSTER KILL","!!"; else if ( @PlayersKilledStreak == .godlike ) setarray .@streakname$,"godlike.wav","is GODLIKE","!!!"; else if ( @PlayersKilledStreak >= .holyshit && ( (@PlayersKilledStreak - .holyshit) % .continue == 0 ) ) setarray .@streakname$,"holyshit.wav","is BEYOND GODLIKE",". Someone KILL "+( (sex)?"HIM":"HER" ) +"!!!!!!"; if ( .@streakname$[1] != "" ) { announce strcharinfo(0) +" "+ .@streakname$[1] +"["+ @PlayersKilledStreak +"] "+( (.announcemap)?("at "+ .@map$):"") + .@streakname$[2],atoi(.announceFlag$), .announceColor$; if ( .sound == 1 ) soundeffectall .@streakname$[0],0,.@map$; else if ( .sound == 2 ) soundeffectall .@streakname$[0],0; else if ( .sound == 3 ) soundeffect .@streakname$[0],0; } set @dota_multikills, @dota_multikills + 1; deltimer "DOTAPVP::OnStreakReset"; addtimer 18000,"DOTAPVP::OnStreakReset"; set .@killer_gid, getcharid(2); if ( .@killer_gid && .@killer_gid != .@killed_gid ) { setd ".dota_sql_"+ .@killer_gid +"_c", getd(".dota_sql_"+ .@killer_gid +"_c") +1 ; if ( getd(".dota_sql_"+ .@killer_gid +"_c") > getd(".dota_sql_"+ .@killer_gid +"_h") ) { setd ".dota_sql_"+ .@killer_gid +"_h", getd(".dota_sql_"+ .@killer_gid +"_c"); setd ".dota_sql_"+ .@killer_gid +"_t", gettimetick(2); } query_sql "replace into ownladder values ( "+ .@killer_gid +", '"+ escape_sql(getguildname(.@killer_gid)) +"', "+ getd(".dota_sql_"+ .@killer_gid +"_c") +", "+ getd(".dota_sql_"+ .@killer_gid +"_h") +", from_unixtime("+ getd(".dota_sql_"+ .@killer_gid +"_t") +") )"; } set .@dota_multikills, @dota_multikills; set .@origin, getcharid(3); sleep 1500; if ( .@killer_gid && .@killer_gid != .@killed_gid && getd(".dota_sql_"+ .@killer_gid +"_c") >= .owned && ( ( getd(".dota_sql_"+ .@killer_gid +"_c") - .owned ) % .owncontinue == 0 ) ) { announce "The guild ["+ getguildname(.@killer_gid) +"] is OWNING["+ getd(".dota_sql_"+ .@killer_gid +"_c") +"] !!!",atoi(.announceFlag$), .announceColor$; if ( .sound == 1 ) soundeffectall "ownage.wav",0,.@map$; else if ( .sound == 2 ) soundeffectall "ownage.wav",0; else if ( .sound == 3 && attachrid(.@origin) ) soundeffect "ownage.wav",0; } sleep 1250; if ( !attachrid(.@origin) ) end; if ( .@dota_multikills == 2 ) { announce strcharinfo(0) +" just got a Double Kill !",atoi(.announceFlag$), .announceColor$; if ( .sound == 1 ) soundeffectall "doublekill.wav",0,.@map$; else if ( .sound == 2 ) soundeffectall "doublekill.wav",0; else if ( .sound == 3 ) soundeffect "doublekill.wav",0; } else if ( .@dota_multikills == 3 ) { announce strcharinfo(0) +" just got a Triple Kill !!!",atoi(.announceFlag$), .announceColor$; if ( .sound == 1 ) soundeffectall "triplekill.wav",0,.@map$; else if ( .sound == 2 ) soundeffectall "triplekill.wav",0; else if ( .sound == 3 ) soundeffect "triplekill.wav",0; } else if ( .@dota_multikills == 4 ) { announce strcharinfo(0) +" just got a Ultra Kill !!!",atoi(.announceFlag$), .announceColor$; if ( .sound == 1 ) soundeffectall "ultrakill.wav",0,.@map$; else if ( .sound == 2 ) soundeffectall "ultrakill.wav",0; else if ( .sound == 3 ) soundeffect "ultrakill.wav",0; } else if ( .@dota_multikills >= 5 ) { announce strcharinfo(0) +" is on a Rampage !!!",atoi(.announceFlag$), .announceColor$; if ( .sound == 1 ) soundeffectall "rampage.wav",0,.@map$; else if ( .sound == 2 ) soundeffectall "rampage.wav",0; else if ( .sound == 3 ) soundeffect "rampage.wav",0; } end; OnStreakReset: set @dota_multikills, 0; end; OnWhisperGlobal: if ( @spam_dotapvp + 3 >= gettimetick(2) ) // 3 seconds interval so player don spam this command end; set @spam_dotapvp, gettimetick(2); if ( @dota_sql_kills == 0 && @dota_sql_deaths == 0 ) query_sql "select kills, deaths, streaks, unix_timestamp(streaktime) from pvpladder where char_id = "+ getcharid(0), @dota_sql_kills, @dota_sql_deaths, @dota_sql_streaks, @dota_sql_streaktime; if ( @dota_sql_kills || @dota_sql_deaths ) { dispbottom "Your current Streak : "+ @PlayersKilledStreak; dispbottom "Your total Kills : "+ @dota_sql_kills; dispbottom "Your total Deaths : "+ @dota_sql_deaths; dispbottom "Your highest Streak : "+ @dota_sql_streaks; query_sql "select date_format( from_unixtime("+ @dota_sql_streaktime +"),'%a %e/%c/%y %r')", .@time1$; dispbottom "Your highest Streak on : "+ .@time1$; } else dispbottom "You are not in the pvp ladder yet."; if ( getcharid(2) ) { if ( getd(".dota_sql_"+ getcharid(2) +"_h") == 0 ) { query_sql "select currentown, highestown, unix_timestamp(owntime) from ownladder where guild_id = "+ getcharid(2), .@c, .@h, .@t; setd ".dota_sql_"+ getcharid(2) +"_c", .@c; setd ".dota_sql_"+ getcharid(2) +"_h", .@h; setd ".dota_sql_"+ getcharid(2) +"_t", .@t; } if ( getd(".dota_sql_"+ getcharid(2) +"_h") ) { dispbottom "Your guild current Own : "+ getd(".dota_sql_"+ getcharid(2) +"_c"); dispbottom "Your guild highest Own : "+ getd(".dota_sql_"+ getcharid(2) +"_h"); query_sql "select date_format( from_unixtime("+ getvariableofnpc( getd(".dota_sql_"+ getcharid(2) +"_t"), "DOTAPVP" ) +"),'%a %e/%c/%y %r')", .@time2$; dispbottom "Your guild highest Own on : "+ .@time2$; } else dispbottom "Your guild is not in the ladder yet."; } end; OnPCLoadMapEvent: if ( @dota_sql_kills == 0 && @dota_sql_deaths == 0 ) { if ( .maptrigger$ != "all" ) { getmapxy .@map$, .@x, .@y, BL_PC; for ( set .@i, 0; .@i < .maptriggersize; set .@i, .@i +1 ) { if ( .@map$ == .maptrigger$[.@i] ) break; } if ( .@i == .maptriggersize ) end; } query_sql "select kills, deaths, streaks, unix_timestamp(streaktime) from pvpladder where char_id = "+ getcharid(0), @dota_sql_kills, @dota_sql_deaths, @dota_sql_streaks, @dota_sql_streaktime; } if ( getcharid(2) && getd(".dota_sql_"+ getcharid(2) +"_h") == 0 ) { query_sql "select currentown, highestown, unix_timestamp(owntime) from ownladder where guild_id = "+ getcharid(2), .@c, .@h, .@t; setd ".dota_sql_"+ getcharid(2) +"_c", .@c; setd ".dota_sql_"+ getcharid(2) +"_h", .@h; setd ".dota_sql_"+ getcharid(2) +"_t", .@t; } end; } prontera,146,170,6 script PvP-StatsViewer 57,{ set .@npcname$, strnpcinfo(0); while (1) { mes "["+ .@npcname$ +"]"; mes "Hello "+ strcharinfo(0) +"..."; mes "If you want to I can show you your PVP stats."; next; switch ( select ( "Most Kills","Highest Streak","Longest Ownage","Own Information","Explanation" ) ) { case 1: set .@nb, query_sql("select name, kills, deaths from pvpladder order by kills desc limit "+ getvariableofnpc(.showtotal,"DOTAPVP"), .@name$, .@kills, .@deaths); if ( .@nb == 0 ) { mes "["+ .@npcname$ +"]"; mes "The ladder currently is empty."; next; } for ( set .@j,0; .@j < .@nb; set .@j, .@j + getvariableofnpc(.showpage,"DOTAPVP") ) { mes "["+ .@npcname$ +"]"; for ( set .@i, .@j; .@i < (getvariableofnpc(.showpage,"DOTAPVP") + .@j) && .@i < .@nb; set .@i, .@i + 1 ) { mes "^996600"+ (.@i+1) +": ^006699"+ .@name$[.@i] +" ^00AA00["+ .@kills[.@i] +"] ^FF0000<"+ .@deaths[.@i] +">^000000"; } next; } break; case 2: set .@nb, query_sql("select name, streaks, date_format(streaktime,'%a %e/%c/%y %r') from pvpladder where streaks >= "+ getvariableofnpc(.loweststreak,"DOTAPVP") +" order by streaks desc limit "+ getvariableofnpc(.showtotal,"DOTAPVP"), .@name$, .@streak, .@time$); if ( .@nb == 0 ) { mes "["+ .@npcname$ +"]"; mes "The ladder currently is empty."; next; } for ( set .@j,0; .@j < .@nb; set .@j, .@j + getvariableofnpc(.showpage,"DOTAPVP") ) { mes "["+ .@npcname$ +"]"; for ( set .@i, .@j; .@i < (getvariableofnpc(.showpage,"DOTAPVP") + .@j) && .@i < .@nb; set .@i, .@i + 1 ) { mes "^996600"+ (.@i+1) +": ^006699"+ .@name$[.@i] +" ^70AC11{"+ .@streak[.@i] +"} ^000000on :"; mes " ^EE8800"+ .@time$[.@i] +"^000000"; } next; } break; case 3: set .@nb, query_sql("select name, highestown, date_format(owntime,'%a %e/%c/%y %r') from ownladder where highestown >= "+ getvariableofnpc(.lowestownage,"DOTAPVP") +" order by highestown desc limit "+ getvariableofnpc(.showtotal,"DOTAPVP"), .@name$, .@owned, .@time$); if ( .@nb == 0 ) { mes "["+ .@npcname$ +"]"; mes "The ladder currently is empty."; next; } for ( set .@j,0; .@j < .@nb; set .@j, .@j + getvariableofnpc(.showpage,"DOTAPVP") ) { mes "["+ .@npcname$ +"]"; for ( set .@i, .@j; .@i < (getvariableofnpc(.showpage,"DOTAPVP") + .@j) && .@i < .@nb; set .@i, .@i + 1 ) { mes "^996600"+ (.@i+1) +": ^006699"+ .@name$[.@i] +" ^00AAAA("+ .@owned[.@i] +") ^000000on :"; mes " ^EE8800"+ .@time$[.@i] +"^000000"; } next; } break; case 4: if ( @dota_sql_kills == 0 && @dota_sql_deaths == 0 ) query_sql "select kills, deaths, streaks, unix_timestamp(streaktime), date_format(streaktime,'%a %e/%c/%y %r') from pvpladder where char_id = "+ getcharid(0), @dota_sql_kills, @dota_sql_deaths, @dota_sql_streaks, @dota_sql_streaktime, .@time1$; mes "["+ .@npcname$ +"]"; if ( @dota_sql_kills == 0 && @dota_sql_deaths == 0 ) mes "You not yet kill any player."; else { mes "Your Current Streak : ^70AC11{"+ @PlayersKilledStreak +"}^000000"; mes "Your Total Kills : ^00AA00["+ @dota_sql_kills +"]^000000"; mes "Your Death Counts : ^FF0000<"+ @dota_sql_deaths +">^000000"; if ( @dota_sql_kills || @dota_sql_streaks ) { mes "Highest Streak was ^70AC11{"+ @dota_sql_streaks +"}^000000 on :"; query_sql "select date_format( from_unixtime("+ @dota_sql_streaktime +"),'%a %e/%c/%y %r')", .@time1$; mes " ^EE8800"+ .@time1$ +"^000000"; } } next; if ( getcharid(2) ) { if ( getvariableofnpc( getd(".dota_sql_"+ getcharid(2) +"_h"), "DOTAPVP" ) == 0 ) { query_sql "select currentown, highestown, unix_timestamp(owntime) from ownladder where guild_id = "+ getcharid(2), .@c, .@h, .@t; set getvariableofnpc( getd(".dota_sql_"+ getcharid(2) +"_c"), "DOTAPVP" ), .@c; set getvariableofnpc( getd(".dota_sql_"+ getcharid(2) +"_h"), "DOTAPVP" ), .@h; set getvariableofnpc( getd(".dota_sql_"+ getcharid(2) +"_t"), "DOTAPVP" ), .@t; } mes "["+ .@npcname$ +"]"; if ( getvariableofnpc( getd(".dota_sql_"+ getcharid(2) +"_h"), "DOTAPVP" ) == 0 ) { mes "Your guild not yet kill any player."; } else { mes "Your guild name : ^006699"+ strcharinfo(2) +"^000000"; mes "Current Owning : ^00AAAA("+ getvariableofnpc( getd(".dota_sql_"+ getcharid(2) +"_c"), "DOTAPVP" ) +")^000000"; mes "Longest Ownage was ^00AAAA("+ getvariableofnpc( getd(".dota_sql_"+ getcharid(2) +"_h"), "DOTAPVP" ) + ")^000000 on :"; query_sql "select date_format( from_unixtime("+ getvariableofnpc( getd(".dota_sql_"+ getcharid(2) +"_t"), "DOTAPVP" ) +"),'%a %e/%c/%y %r')", .@time2$; mes " ^EE8800"+ .@time2$ +"^000000"; } next; } break; case 5: mes "["+ .@npcname$ +"]"; mes "Explanation for Most Kills:"; mes " "; mes "^996600Rank. ^006699NAME ^00AA00[Total Kills] ^FF0000<Deaths>^000000"; mes " "; mes "--------------------------------"; mes " "; mes "The ^00AA00Kills^000000 added when a player kills another player."; mes " "; mes "^FF0000Deaths^000000 count increase when a player killed by another player, or suicide (eg: Grand Cross)."; mes " "; mes "A player killed by monsters, homunculus or pets will not add the kills or deaths count."; next; mes "["+ .@npcname$ +"]"; mes "Explanation for Highest Streak:"; mes " "; mes "^996600Rank. ^006699NAME ^70AC11{Highest Streak} ^000000on :"; mes " ^EE8800TIME^000000"; mes " "; mes "--------------------------------"; mes " "; mes "The ^70AC11Streak^000000 are added every time a player kills another player. It will reset upon log out, killed by another player, or suicide (eg: Sacrifice)."; mes " "; mes "Then it record in the server the ^EE8800TIME^000000 when that player got that highest streak."; mes " "; mes "A player killed by monsters, homunculus or pets will not reset the streak."; mes " "; mes "--------------------------------"; mes " "; mes "The numbers of straight kills to get these announcements are :"; mes "^70AC11"+ getvariableofnpc(.killingspree,"DOTAPVP") +"^000000 : Killing Spree"; mes "^70AC11"+ getvariableofnpc(.dominating,"DOTAPVP") +"^000000 : Dominating"; mes "^70AC11"+ getvariableofnpc(.megakill,"DOTAPVP") +"^000000 : Mega Kill"; mes "^70AC11"+ getvariableofnpc(.unstoppable,"DOTAPVP") +"^000000 : Unstoppable"; mes "^70AC11"+ getvariableofnpc(.wickedsick,"DOTAPVP") +"^000000 : Wicked Sick"; mes "^70AC11"+ getvariableofnpc(.monsterkill,"DOTAPVP") +"^000000 : Monster Kill"; mes "^70AC11"+ getvariableofnpc(.godlike,"DOTAPVP") +"^000000 : Godlike"; mes "^70AC11"+ getvariableofnpc(.holyshit,"DOTAPVP") +"^000000 : Beyond Godlike"; next; mes "["+ .@npcname$ +"]"; mes "Explanation for Longest Ownage:"; mes " "; mes "^996600Rank. ^006699NAME ^00AAAA(Longest Ownage) ^000000on :"; mes " ^EE8800TIME^000000"; mes " "; mes "--------------------------------"; mes " "; mes "The ^00AAAAOwnage^000000 added every time any guild members killed another player that doesn't belong to his/her guild. It will reset when any of the guild member was killed by ANY player, including his/her guild member."; mes " "; mes "Then it record in the server the ^EE8800TIME^000000 when the guild got that longest ownage."; mes " "; mes "If the server went under maintainance, the current ownage will survive after the server restart."; mes " "; mes "Any guild member killed by monster, homunculus or pets will not reset the ownage count."; next; if ( getvariableofnpc(.lvltokill,"DOTAPVP") ) { mes "["+ .@npcname$ +"]"; mes "You must kill another player with minimum base level of "+ getvariableofnpc(.lvltokill,"DOTAPVP") +", in order to get an announcement or get in the ladder."; mes " "; mes "It's possible for a base level 1 novice kills a base level 99 player and still can get in the ladder."; mes "However when a player level 99 kills a level 1 novice will get nothing."; next; } if ( getvariableofnpc(.counttopunish,"DOTAPVP") ) { mes "["+ .@npcname$ +"]"; mes "Some noob players try to kill the same person over and over again in hope of getting his/her name appear in the ladder."; mes "However if you trying to do the same thing on this ladder, your name will announce to the public, and your action will be recorded into the server to notify the GMs."; next; } if ( getvariableofnpc(.minlvlrange,"DOTAPVP") ) { mes "["+ .@npcname$ +"]"; mes "When you kill another player thats lower base level than you, the base level gap between you and that player must not more than "+ getvariableofnpc(.minlvlrange,"DOTAPVP") +"."; mes " "; if ( getvariableofnpc(.minlvlrange,"DOTAPVP") >= 200) mes "In other words, if your base level is 500, the player you killed must be at least level "+( 500 - getvariableofnpc(.minlvlrange,"DOTAPVP") )+" then only you will get the announcement and in the ladder."; else if ( getvariableofnpc(.minlvlrange,"DOTAPVP") >= 70) mes "In other words, if your base level is 255, the player you killed must be at least level "+( 255 - getvariableofnpc(.minlvlrange,"DOTAPVP") )+" then only you will get the announcement and in the ladder."; else mes "In other words, if your base level is 99, the player you killed must be at least level "+( 99 - getvariableofnpc(.minlvlrange,"DOTAPVP") )+" then only you will get the announcement and in the ladder."; mes "Higher base level kills lower level gets nothing, however lower level player kills higher level will get the announcement."; next; } break; } } } SQL Table //<!------------------------------------------------------------!> // create table pvpladder ( // char_id int(11) not null default '0' primary key, // name varchar(30) not null default '', // streaks smallint(6) unsigned not null default '0', // kills smallint(6) unsigned not null default '0', // deaths smallint(6) unsigned not null default '0', // streaktime datetime // ) engine = myisam; // // create table ownladder ( // guild_id int(11) not null default '0' primary key, // name varchar(24) not null default '', // currentown smallint(6) unsigned not null default '0', // highestown smallint(6) unsigned not null default '0', // owntime datetime // ) engine = myisam; //<!------------------------------------------------------------!> I want to make it automatically reset every month so is it right to add in this line OnDay0101: OnDay0201: OnDay0301: OnDay0401: OnDay0501: OnDay0601: OnDay0701: OnDay0801: OnDay0901: OnDay1001: OnDay1101: OnDay1201: query_sql "SELECT `name` FROM `pvpladder` ORDER BY `kills` DESC LIMIT 1", .@name$; if( getarraysize( .@name$ ) ) set $top_pvprank$, implode( .@name$, "?" ); end; } before this line if ( getcharid(2) && getd(".dota_sql_"+ getcharid(2) +"_h") == 0 ) { query_sql "select currentown, highestown, unix_timestamp(owntime) from ownladder where guild_id = "+ getcharid(2), .@c, .@h, .@t; setd ".dota_sql_"+ getcharid(2) +"_c", .@c; setd ".dota_sql_"+ getcharid(2) +"_h", .@h; setd ".dota_sql_"+ getcharid(2) +"_t", .@t; } end; and add this if( $top_pvprank$ != "" ) { explode( .@name$, $top1_pvprank$, "?" ); for( set .@i, 0; .@i < getarraysize( .@name$ ); set .@i, .@i + 1 ) { if( .@name$[ .@i ] == strcharinfo(0) ) { deletearray .@name$[ .@i ], 1; if( getarraysize( .@name$ ) ) set $top_pvprank$, implode( .@name$, "?" ); else set $top_pvprank$, ""; getitem 501, 1; //prize mes "Congratulation you were Top 1 Last Month."; close; } } } after OnPCKillEvent: Thanks a lot for the people who will answer.

Hello I'm new here I would just like to ask how I can send a prize via ro dex for the top ranker in this script, this script ranks top 10 mvp players and I would like to give the top ranker a prize. set MVPTotal, MVPTotal + 1; query_sql "SELECT char_id FROM ladder_mvp WHERE char_id = "+ getcharid(0) +"", .@cidA; if(!.@cidA) query_sql "INSERT INTO `ladder_mvp` (`char_id`, `char_name`, `kills`) VALUES ('"+ getcharid(0) +"', '"+ strcharinfo(0) +"', '1')"; else query_sql "UPDATE ladder_mvp SET kills = kills + 1 WHERE char_id = "+ getcharid(0) +""; end; OnDay0101: OnDay0201: OnDay0301: OnDay0401: OnDay0501: OnDay0601: OnDay0701: OnDay0801: OnDay0901: OnDay1001: OnDay1101: OnDay1201: if(.autoReset){ query_sql "SELECT * FROM ladder_mvp ORDER BY kills DESC LIMIT 10", .@creset, .@nreset$, .@kreset; query_sql("TRUNCATE TABLE ladder_mvp2"); for(set .@i, 0; .@i < getarraysize(.@creset); set .@i, .@i + 1) query_sql "INSERT INTO `ladder_mvp2` VALUES ('"+ .@creset[.@i] +"', '"+ .@nreset$[.@i] +"', '"+ .@kreset[.@i] +"', '0')"; query_sql("TRUNCATE TABLE ladder_mvp"); if(.announceReset) announce "The MvP Ladder has resetted!",bc_yellow|bc_all; } end; OnInit: OnInit: