@empladder

[sandbox]

File Name: @empladder

File Submitter: sandbox

File Submitted: 2 Mar 2014

File Category: Utilities

Content Author: sandbox

Script details and usage

It's a script that will show the top 10 Emperium breakers of your server.

Suggestions for the improvement of this very simple script would be appreciated.

Installation

• Enable the script on your NPC folder
• Find this line in npc/guild/agit_main.txt

// The Emperium has been broken.

OnAgitBreak:

Add below 

set empladder,empladder+1;

• If your script support WoE SE, you will have to edit this file too > npc/guild2/agit_main_se.txt

Find

OnStartArena:

set .@GID,getcharid(2);

Add below 

set empladder,empladder+1;

 

Terms & Conditions

• You are not allowed to reproduce or make profit of this script
• You are not allowed to take credit for this script. Though you can modify/edit it to your liking.
• I can give you support, but please, do not message me.
• It is your own responsibility to create a backup before implementing anything new.

Pastebin: http://rathena.org/board/pastebin/73thwenhsb2a/

at_empladder.txt

[Santafe]

Hey sandycould u make this an npc too? Thx alot

[sandbox]

I'll post one when I get home

[Santafe]

Thank u

[sandbox]

Thank u

Almost forgot about you, here's your NPC!

//======Name========================================
// Emperium Ladder
//======Version=====================================
// 1.0
//======Author(s)===================================
// Sandbox
//======Comments====================================
// It's a script that will show the top 10 Emperium breakers of your server.
//==================================================
 
prontera,123,123,4	script	empladder	78,{
 
		mes "Here are our top 10 breakers!";	
query_sql ("SELECT `char`.char_id,`char`.`name`,global_reg_value.`value` FROM global_reg_value LEFT JOIN `char` ON global_reg_value.char_id=`char`.char_id WHERE global_reg_value.str='empladder' ORDER BY CAST(`global_reg_value`.`value` AS UNSIGNED) DESC LIMIT 10", .@char_id, .@name$, .@count);
		    for( set .@x,0; .@x<10; set .@x,.@x+1 )
			    {
			        mes "^880000"+(.@x+1)+"^000000) ^0000FF"+.@name$[.@x]+"^000000 - ^008800"+.@count[.@x]+"^000000 Point(s)";
			    } // .@x starts at 0, but you want to start with '1st', so use (.@x+1)
		close; 
}

[Santafe]

Thank u

Almost forgot about you, here's your NPC!

//======Name========================================
// Emperium Ladder
//======Version=====================================
// 1.0
//======Author(s)===================================
// Sandbox
//======Comments====================================
// It's a script that will show the top 10 Emperium breakers of your server.
//==================================================
 
prontera,123,123,4	script	empladder	78,{
 
		mes "Here are our top 10 breakers!";	
query_sql ("SELECT `char`.char_id,`char`.`name`,global_reg_value.`value` FROM global_reg_value LEFT JOIN `char` ON global_reg_value.char_id=`char`.char_id WHERE global_reg_value.str='empladder' ORDER BY CAST(`global_reg_value`.`value` AS UNSIGNED) DESC LIMIT 10", .@char_id, .@name$, .@count);
		    for( set .@x,0; .@x<10; set .@x,.@x+1 )
			    {
			        mes "^880000"+(.@x+1)+"^000000) ^0000FF"+.@name$[.@x]+"^000000 - ^008800"+.@count[.@x]+"^000000 Point(s)";
			    } // .@x starts at 0, but you want to start with '1st', so use (.@x+1)
		close; 
}

*hails sandbox for this*

[Stolao]

Why not add a bindatcommand to view top 10?

[sandbox]

It already works like that, unless you mean something else?

[Stolao]

It already works like that, unless you mean something else?

lol so it does, i was reading the quotes sorry

[n0stalgia]

help me please 
 

[Onairda]

hi can someone convert this @empladder in present database because now the database has don't have global_reg_value table anymore thankyou 
query_sql ("SELECT `char`.char_id,`char`.`name`,global_reg_value.`value` FROM global_reg_value LEFT JOIN `char` ON global_reg_value.char_id=`char`.char_id WHERE global_reg_value.str='empladder' ORDER BY CAST(`global_reg_value`.`value` AS UNSIGNED) DESC LIMIT 10", .@char_id, .@name$, .@count);
 

[Onairda]

On 4/16/2014 at 11:37 AM, sandbox said:

It already works like that, unless you mean something else?

 

On 4/16/2014 at 12:50 PM, Stolao said:

lol so it does, i was reading the quotes sorry

hi can someone convert this @empladder in present database because now the database has don't have global_reg_value table anymore thankyou 
 

query_sql ("SELECT `char`.char_id,`char`.`name`,global_reg_value.`value` FROM global_reg_value LEFT JOIN `char` ON global_reg_value.char_id=`char`.char_id WHERE global_reg_value.str='empladder' ORDER BY CAST(`global_reg_value`.`value` AS UNSIGNED) DESC LIMIT 10", .@char_id, .@name$, .@count);

thankyou