Rank player scrips

[IvanD]

Does anyone have script like this?

NPC with Pub... #1 player have the most zeny and how much.

another npc

npc with pub... #1 who has the most PODS/Cashpoints and how many

 

thanks in advance

Edited April 13, 2020 by IvanD

[Patskie]

-	script	ranking	-1,{
	function CreateMessage;
	function CreateMessage {
		.@a = getarg(0, 0);
		switch (.@a) {
			case 0:
			default:
				return "No records.";
			case 1:
				.@sql$ = "SELECT `NAME`, `ZENY` FROM `CHAR` ORDER BY `ZENY` DESC LIMIT 1";
				break;
			case 2:
				.@sql$ = "SELECT A.`NAME`, B.`AMOUNT` FROM `CHAR` A, `INVENTORY` B WHERE A.`CHAR_ID` = B.`CHAR_ID` AND B.`NAMEID` =  '" + .pods_item_id + "' ORDER BY B.`AMOUNT` DESC LIMIT 1";
				break;
			case 3:
				.@sql$ = "SELECT B.`NAME`, A.`VALUE` FROM `ACC_REG_NUM` A, `CHAR` B WHERE A.`ACCOUNT_ID` = B.`ACCOUNT_ID` AND A.`KEY` = '#CASHPOINTS' ORDER BY A.`VALUE` DESC LIMIT 1";
				break;
		}
		
		if (query_sql(.@sql$, .@name$, .@value) > 0 && .@value > 0)
			.@str$ = .@name$ + " - [" + .@value + "]";
		else
			.@str$ = "No records.";
		
		return .@str$;
	}
	end;
	
	OnMinute60:
		delwaitingroom;
		waitingroom CreateMessage(strnpcinfo(2)), 0;
		end;
	
	OnInit:
		.pods_item_id = 1001; // put your pods item id
		waitingroom CreateMessage(strnpcinfo(2)), 0;
		end;
}

prontera,152,156,0	duplicate(ranking)	Top Zeny Ranking#1	100
prontera,155,156,0	duplicate(ranking)	Top Pods Ranking#2	100
prontera,158,156,0	duplicate(ranking)	Top Cashpoints Ranking#3	100

Updates every hour. Note of below

*waitingroom "<chatroom name>",<limit>{,"<event label>"{,<trigger>{,<required zeny>{,<min lvl>{,<max lvl>}}}}};
....
The maximum length of a chat room name is 60 letters.

 

Edited April 14, 2020 by Patskie

[IvanD]

On 4/14/2020 at 8:14 AM, Patskie said:

-	script	ranking	-1,{
	function CreateMessage;
	function CreateMessage {
		.@a = getarg(0, 0);
		switch (.@a) {
			case 0:
			default:
				return "No records.";
			case 1:
				.@sql$ = "SELECT `NAME`, `ZENY` FROM `CHAR` ORDER BY `ZENY` DESC LIMIT 1";
				break;
			case 2:
				.@sql$ = "SELECT A.`NAME`, B.`AMOUNT` FROM `CHAR` A, `INVENTORY` B WHERE A.`CHAR_ID` = B.`CHAR_ID` AND B.`NAMEID` =  '" + .pods_item_id + "' ORDER BY B.`AMOUNT` DESC LIMIT 1";
				break;
			case 3:
				.@sql$ = "SELECT B.`NAME`, A.`VALUE` FROM `ACC_REG_NUM` A, `CHAR` B WHERE A.`ACCOUNT_ID` = B.`ACCOUNT_ID` AND A.`KEY` = '#CASHPOINTS' ORDER BY A.`VALUE` DESC LIMIT 1";
				break;
		}
		
		if (query_sql(.@sql$, .@name$, .@value) > 0 && .@value > 0)
			.@str$ = .@name$ + " - [" + .@value + "]";
		else
			.@str$ = "No records.";
		
		return .@str$;
	}
	end;
	
	OnMinute60:
		delwaitingroom;
		waitingroom CreateMessage(strnpcinfo(2)), 0;
		end;
	
	OnInit:
		.pods_item_id = 1001; // put your pods item id
		waitingroom CreateMessage(strnpcinfo(2)), 0;
		end;
}

prontera,152,156,0	duplicate(ranking)	Top Zeny Ranking#1	100
prontera,155,156,0	duplicate(ranking)	Top Pods Ranking#2	100
prontera,158,156,0	duplicate(ranking)	Top Cashpoints Ranking#3	100

Updates every hour. Note of below

*waitingroom "<chatroom name>",<limit>{,"<event label>"{,<trigger>{,<required zeny>{,<min lvl>{,<max lvl>}}}}};
....
The maximum length of a chat room name is 60 letters.

 

not working sir