Jump to content

@empladder


sandbox

Recommended Posts


  • Group:  Members
  • Topic Count:  38
  • Topics Per Day:  0.01
  • Content Count:  949
  • Reputation:   173
  • Joined:  06/12/12
  • Last Seen:  

File Name: @empladder

File Submittersandbox

File Submitted: 2 Mar 2014

File CategoryUtilities

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

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  91
  • Topics Per Day:  0.02
  • Content Count:  325
  • Reputation:   34
  • Joined:  06/01/13
  • Last Seen:  

Hey sandycould u make this an npc too? Thx alot :)

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  38
  • Topics Per Day:  0.01
  • Content Count:  949
  • Reputation:   173
  • Joined:  06/12/12
  • Last Seen:  

I'll post one when I get home :D

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  91
  • Topics Per Day:  0.02
  • Content Count:  325
  • Reputation:   34
  • Joined:  06/01/13
  • Last Seen:  

Thank u :)

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  38
  • Topics Per Day:  0.01
  • Content Count:  949
  • Reputation:   173
  • Joined:  06/12/12
  • Last Seen:  

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; 
}
  • Upvote 1
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  91
  • Topics Per Day:  0.02
  • Content Count:  325
  • Reputation:   34
  • Joined:  06/01/13
  • Last Seen:  

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*

Link to comment
Share on other sites

  • 1 month later...

  • Group:  Developer
  • Topic Count:  48
  • Topics Per Day:  0.01
  • Content Count:  1443
  • Reputation:   337
  • Joined:  10/17/12
  • Last Seen:  

Why not add a bindatcommand to view top 10?

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  38
  • Topics Per Day:  0.01
  • Content Count:  949
  • Reputation:   173
  • Joined:  06/12/12
  • Last Seen:  

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

Link to comment
Share on other sites


  • Group:  Developer
  • Topic Count:  48
  • Topics Per Day:  0.01
  • Content Count:  1443
  • Reputation:   337
  • Joined:  10/17/12
  • Last Seen:  

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

lol so it does, i was reading the quotes sorry

Link to comment
Share on other sites

  • 4 months later...

  • Group:  Members
  • Topic Count:  4
  • Topics Per Day:  0.00
  • Content Count:  47
  • Reputation:   0
  • Joined:  01/16/12
  • Last Seen:  

help me please 11gis1y.jpg
 

Link to comment
Share on other sites

  • 3 years later...

  • Group:  Members
  • Topic Count:  70
  • Topics Per Day:  0.03
  • Content Count:  164
  • Reputation:   8
  • Joined:  12/30/16
  • Last Seen:  

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);
 

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  70
  • Topics Per Day:  0.03
  • Content Count:  164
  • Reputation:   8
  • Joined:  12/30/16
  • Last Seen:  

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 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...