Jump to content
  • 0

In-game item monitor for GM

KoolKat29

Asked by KoolKat29,

 Share

Question

KoolKat29 Poring

KoolKat29

Posted
  • Group:  Members
  • Topic Count:  2
  • Topics Per Day:  0.00
  • Content Count:  90
  • Reputation:   5
  • Joined:  06/17/12
  • Last Seen:  
Posted (edited)

Hello fellow rAthena. Is there any available npc or script for GMs that will allow and show the rankings of items aquired by players cart/storage/mail/inventory excluding the gm's accounts? 

 

Ex. 

It will show the 10 most aquired and 10 least aquired items by players.

If possible, gm can input the item ID of the item to check the total items aquired of every players in game.

 

Reason.

For servers with lots of daily events with special prizes like tcg and poring coins. We can easily monitor and compare the differences or impact of prizes/items as the number of player grows. With that, we can adjust (add/delete/modify) our scripts/npcs and maintain the balance of our special items/rewards in game.

 

It will run an sql query I guess.

 

Thanks..

 

 

 

Firs try:
 

trinity_in,128,155,5	script	item check	807,{

set .req_gmlvl, 99;
	

mes "[Item Check Menu]";
mes "----------------------------------";
mes "";
mes "For GM Staffs Only.";
mes "----------------------------------";
next;
if(getgmlevel() >= .req_gmlvl)
{
switch( select( "Manual Check:Ranking"))
{
case 1:
			mes "Input Item Number";
			next;
			input .@input_id;
			
			//sql
			//inventory
			query_sql ("SELECT SUM(`amount`) FROM `inventory` WHERE `nameid` = '"+.@input_id+"'", .@inv_amount);
			
			//storage
			query_sql ("SELECT SUM(`amount`) FROM `storage` WHERE `nameid` = '"+.@input_id+"'", .@store_amount);
								
			//guild storage
			query_sql ("SELECT SUM(`amount`) FROM `guild_storage` WHERE `nameid` = '"+.@input_id+"'", .@guild_amount);
			
			//carts
			query_sql ("SELECT SUM(`amount`) FROM `cart_inventory` WHERE `nameid` = '"+.@input_id+"'", .@cart_amount);
			
			//mail
			query_sql ("SELECT SUM(`amount`) FROM `cart_inventory` WHERE `nameid` = '"+.@input_id+"'", .@mail_amount);
			
			
			set .@total,.@inv_amount + .@store_amount + .@guild_amount + .@cart_amount + .@mail_amount;
			mes "There are: " + .@total + " available in game.";
			close;

case 2:
		mes "Ranking";
		next;
		mes "soon";
		close;
}
}
close;
}

 

 

 

 

Second Try: (The least I can do :))

trinity_in,128,155,5	script	item check	807,{

set .req_gmlvl, 99;
	

mes "[Item Check Menu]";
mes "----------------------------------";
mes "";
mes "For GM Staffs Only.";
mes "----------------------------------";
next;
if(getgmlevel() >= .req_gmlvl)
{
switch( select( "Manual Check:Ranking"))
	{
	case 1:
			mes "Input Item Number";
			next;
			input .@input_id;
			
			//sql
			//inventory
			query_sql ("SELECT SUM(`amount`) FROM `inventory` WHERE `nameid` = '"+.@input_id+"'", .@inv_amount);
			
			//storage
			query_sql ("SELECT SUM(`amount`) FROM `storage` WHERE `nameid` = '"+.@input_id+"'", .@store_amount);
								
			//guild storage
			query_sql ("SELECT SUM(`amount`) FROM `guild_storage` WHERE `nameid` = '"+.@input_id+"'", .@guild_amount);
			
			//carts
			query_sql ("SELECT SUM(`amount`) FROM `cart_inventory` WHERE `nameid` = '"+.@input_id+"'", .@cart_amount);
			
			//mail
			query_sql ("SELECT SUM(`amount`) FROM `mail` WHERE `nameid` = '"+.@input_id+"'", .@mail_amount);
			
			
			set .@total,.@inv_amount + .@store_amount + .@guild_amount + .@cart_amount + .@mail_amount;
			
			mes "There are: " + .@total + " available in game.";
			close;

	case 2:
	mes "Please choose a Table: ";
	switch( select( "Inventory:Storage:Guild Storage:Cart:Mail"))
		{
		case 1:
			mes "ITEM INVENTORY RANKING";
			mes "-----------------------";
		
			query_sql ("SELECT SUM(amount) , nameid FROM inventory GROUP BY nameid ORDER BY SUM(amount) DESC LIMIT 10", .@rank_amount, .@rank_id);
		
			mes "1. "+getitemname(.@rank_id[0])+"^0055FF ("+.@rank_amount[0]+")^000000";
			mes "2. "+getitemname(.@rank_id[1])+"^0055FF ("+.@rank_amount[1]+")^000000";
			mes "3. "+getitemname(.@rank_id[2])+"^0055FF ("+.@rank_amount[2]+")^000000";
			mes "4. "+getitemname(.@rank_id[3])+"^0055FF ("+.@rank_amount[3]+")^000000";
			mes "5. "+getitemname(.@rank_id[4])+"^0055FF ("+.@rank_amount[4]+")^000000";
			mes "6. "+getitemname(.@rank_id[5])+"^0055FF ("+.@rank_amount[5]+")^000000";
			mes "7. "+getitemname(.@rank_id[6])+"^0055FF ("+.@rank_amount[6]+")^000000";
			mes "8. "+getitemname(.@rank_id[7])+"^0055FF ("+.@rank_amount[7]+")^000000";
			mes "9. "+getitemname(.@rank_id[8])+"^0055FF ("+.@rank_amount[8]+")^000000";
			mes "10. "+getitemname(.@rank_id[9])+"^0055FF ("+.@rank_amount[9]+")^000000";
			close;
		
		case 2:
			mes "ITEM STORAGE RANKING";
			mes "-----------------------";
		
			query_sql ("SELECT SUM(amount) , nameid FROM storage GROUP BY nameid ORDER BY SUM(amount) DESC LIMIT 10", .@rank_amount, .@rank_id);
		
			mes "1. "+getitemname(.@rank_id[0])+"^0055FF ("+.@rank_amount[0]+")^000000";
			mes "2. "+getitemname(.@rank_id[1])+"^0055FF ("+.@rank_amount[1]+")^000000";
			mes "3. "+getitemname(.@rank_id[2])+"^0055FF ("+.@rank_amount[2]+")^000000";
			mes "4. "+getitemname(.@rank_id[3])+"^0055FF ("+.@rank_amount[3]+")^000000";
			mes "5. "+getitemname(.@rank_id[4])+"^0055FF ("+.@rank_amount[4]+")^000000";
			mes "6. "+getitemname(.@rank_id[5])+"^0055FF ("+.@rank_amount[5]+")^000000";
			mes "7. "+getitemname(.@rank_id[6])+"^0055FF ("+.@rank_amount[6]+")^000000";
			mes "8. "+getitemname(.@rank_id[7])+"^0055FF ("+.@rank_amount[7]+")^000000";
			mes "9. "+getitemname(.@rank_id[8])+"^0055FF ("+.@rank_amount[8]+")^000000";
			mes "10. "+getitemname(.@rank_id[9])+"^0055FF ("+.@rank_amount[9]+")^000000";
			close;
		
		case 3:
			mes "ITEM GUILD STORAGE RANKING";
			mes "-----------------------";
		
			query_sql ("SELECT SUM(amount) , nameid FROM guild_storage GROUP BY nameid ORDER BY SUM(amount) DESC LIMIT 10", .@rank_amount, .@rank_id);
		
			mes "1. "+getitemname(.@rank_id[0])+"^0055FF ("+.@rank_amount[0]+")^000000";
			mes "2. "+getitemname(.@rank_id[1])+"^0055FF ("+.@rank_amount[1]+")^000000";
			mes "3. "+getitemname(.@rank_id[2])+"^0055FF ("+.@rank_amount[2]+")^000000";
			mes "4. "+getitemname(.@rank_id[3])+"^0055FF ("+.@rank_amount[3]+")^000000";
			mes "5. "+getitemname(.@rank_id[4])+"^0055FF ("+.@rank_amount[4]+")^000000";
			mes "6. "+getitemname(.@rank_id[5])+"^0055FF ("+.@rank_amount[5]+")^000000";
			mes "7. "+getitemname(.@rank_id[6])+"^0055FF ("+.@rank_amount[6]+")^000000";
			mes "8. "+getitemname(.@rank_id[7])+"^0055FF ("+.@rank_amount[7]+")^000000";
			mes "9. "+getitemname(.@rank_id[8])+"^0055FF ("+.@rank_amount[8]+")^000000";
			mes "10. "+getitemname(.@rank_id[9])+"^0055FF ("+.@rank_amount[9]+")^000000";
			close;
		
		case 4:
			mes "ITEM CART RANKING";
			mes "-----------------------";
		
			query_sql ("SELECT SUM(amount) , nameid FROM cart_inventory GROUP BY nameid ORDER BY SUM(amount) DESC LIMIT 10", .@rank_amount, .@rank_id);
		
			mes "1. "+getitemname(.@rank_id[0])+"^0055FF ("+.@rank_amount[0]+")^000000";
			mes "2. "+getitemname(.@rank_id[1])+"^0055FF ("+.@rank_amount[1]+")^000000";
			mes "3. "+getitemname(.@rank_id[2])+"^0055FF ("+.@rank_amount[2]+")^000000";
			mes "4. "+getitemname(.@rank_id[3])+"^0055FF ("+.@rank_amount[3]+")^000000";
			mes "5. "+getitemname(.@rank_id[4])+"^0055FF ("+.@rank_amount[4]+")^000000";
			mes "6. "+getitemname(.@rank_id[5])+"^0055FF ("+.@rank_amount[5]+")^000000";
			mes "7. "+getitemname(.@rank_id[6])+"^0055FF ("+.@rank_amount[6]+")^000000";
			mes "8. "+getitemname(.@rank_id[7])+"^0055FF ("+.@rank_amount[7]+")^000000";
			mes "9. "+getitemname(.@rank_id[8])+"^0055FF ("+.@rank_amount[8]+")^000000";
			mes "10. "+getitemname(.@rank_id[9])+"^0055FF ("+.@rank_amount[9]+")^000000";
			close;
		
		case 5:
			mes "ITEM MAIL RANKING";
			mes "-----------------------";
		
			query_sql ("SELECT SUM(amount) , nameid FROM mail GROUP BY nameid ORDER BY SUM(amount) DESC LIMIT 10", .@rank_amount, .@rank_id);
		
			mes "1. "+getitemname(.@rank_id[0])+"^0055FF ("+.@rank_amount[0]+")^000000";
			mes "2. "+getitemname(.@rank_id[1])+"^0055FF ("+.@rank_amount[1]+")^000000";
			mes "3. "+getitemname(.@rank_id[2])+"^0055FF ("+.@rank_amount[2]+")^000000";
			mes "4. "+getitemname(.@rank_id[3])+"^0055FF ("+.@rank_amount[3]+")^000000";
			mes "5. "+getitemname(.@rank_id[4])+"^0055FF ("+.@rank_amount[4]+")^000000";
			mes "6. "+getitemname(.@rank_id[5])+"^0055FF ("+.@rank_amount[5]+")^000000";
			mes "7. "+getitemname(.@rank_id[6])+"^0055FF ("+.@rank_amount[6]+")^000000";
			mes "8. "+getitemname(.@rank_id[7])+"^0055FF ("+.@rank_amount[7]+")^000000";
			mes "9. "+getitemname(.@rank_id[8])+"^0055FF ("+.@rank_amount[8]+")^000000";
			mes "10. "+getitemname(.@rank_id[9])+"^0055FF ("+.@rank_amount[9]+")^000000";
			close;
		}
	
	}
}
close;
}


Bind @command

 

Change:

 

trinity_in,128,155,5	script	item check	807,{

set .req_gmlvl, 99;

 

 

To:

 

-	script	ItemRank	-1,{

OnInit:
	set .req_gmlvl, 99;
	bindatcmd("itemrank",strnpcinfo(3)+"::OnItemrank",99,99);
	end;
	
OnItemrank:
Edited by KoolKat29
Link to comment
Share on other sites

2 answers to this question

Recommended Posts

brunoshp Drops

brunoshp

Posted
  • Group:  Members
  • Topic Count:  64
  • Topics Per Day:  0.02
  • Content Count:  180
  • Reputation:   7
  • Joined:  12/19/12
  • Last Seen:  
Posted

up

Link to comment
Share on other sites
KoolKat29 Poring

KoolKat29

Posted
  • Group:  Members
  • Topic Count:  2
  • Topics Per Day:  0.00
  • Content Count:  90
  • Reputation:   5
  • Joined:  06/17/12
  • Last Seen:  
  • Author
Posted 
-	script	ItemRank	-1,{

OnInit:
	set .req_gmlvl, 99;
	bindatcmd("itemrank",strnpcinfo(3)+"::OnItemrank",99,99);
	end;
	
OnItemrank:
mes "[Item Check Menu]";
mes "----------------------------------";
mes "";
mes "For GM Staffs Only.";
mes "----------------------------------";
next;
if(getgmlevel() >= .req_gmlvl)
{
switch( select( "Manual Check:Ranking"))
	{
	case 1:
			mes "Input Item Number";
			next;
			input .@input_id;
			
			//sql
			//inventory
			query_sql ("SELECT SUM(`amount`) FROM `inventory` WHERE `nameid` = '"+.@input_id+"'", .@inv_amount);
			
			//storage
			query_sql ("SELECT SUM(`amount`) FROM `storage` WHERE `nameid` = '"+.@input_id+"'", .@store_amount);
								
			//guild storage
			query_sql ("SELECT SUM(`amount`) FROM `guild_storage` WHERE `nameid` = '"+.@input_id+"'", .@guild_amount);
			
			//carts
			query_sql ("SELECT SUM(`amount`) FROM `cart_inventory` WHERE `nameid` = '"+.@input_id+"'", .@cart_amount);
			
			//mail
			query_sql ("SELECT SUM(`amount`) FROM `mail` WHERE `nameid` = '"+.@input_id+"'", .@mail_amount);

			
			set .@total,.@inv_amount + .@store_amount + .@guild_amount + .@cart_amount + .@mail_amount;
			
			mes "There are: " + .@total + " available in game.";
			next;
			switch( select( "TOP Player Inventory:TOP Account Storage:TOP Guild Storage:TOP Player Cart:TOP Player Mail"))
				{
				case 1:
					query_sql ("SELECT amount , char_id FROM inventory WHERE nameid = "+.@input_id+" ORDER BY amount DESC LIMIT 5", .@top_amount, .@top_char);
			
					mes "1. "+.@top_char[0]+" "+.@top_amount[0]+" "+getitemname(.@input_id)+" ";
					mes "2. "+.@top_char[1]+" "+.@top_amount[1]+" "+getitemname(.@input_id)+" ";
					mes "3. "+.@top_char[2]+" "+.@top_amount[2]+" "+getitemname(.@input_id)+" ";
					mes "4. "+.@top_char[3]+" "+.@top_amount[3]+" "+getitemname(.@input_id)+" ";
					mes "5. "+.@top_char[4]+" "+.@top_amount[4]+" "+getitemname(.@input_id)+" ";
					close;
					
				case 2:
					query_sql ("SELECT amount , account_id FROM storage WHERE nameid = "+.@input_id+" ORDER BY amount DESC LIMIT 5", .@top_amount, .@top_acc);
			
					mes "1. "+.@top_acc[0]+" "+.@top_amount[0]+" "+getitemname(.@input_id)+" ";
					mes "2. "+.@top_acc[1]+" "+.@top_amount[1]+" "+getitemname(.@input_id)+" ";
					mes "3. "+.@top_acc[2]+" "+.@top_amount[2]+" "+getitemname(.@input_id)+" ";
					mes "4. "+.@top_acc[3]+" "+.@top_amount[3]+" "+getitemname(.@input_id)+" ";
					mes "5. "+.@top_acc[4]+" "+.@top_amount[4]+" "+getitemname(.@input_id)+" ";
					close;
					
				case 3:
					query_sql ("SELECT amount , guild_id FROM guild_storage WHERE nameid = "+.@input_id+" ORDER BY amount DESC LIMIT 5", .@top_amount, .@top_guild);
			
					mes "1. "+.@top_guild[0]+" "+.@top_amount[0]+" "+getitemname(.@input_id)+" ";
					mes "2. "+.@top_guild[1]+" "+.@top_amount[1]+" "+getitemname(.@input_id)+" ";
					mes "3. "+.@top_guild[2]+" "+.@top_amount[2]+" "+getitemname(.@input_id)+" ";
					mes "4. "+.@top_guild[3]+" "+.@top_amount[3]+" "+getitemname(.@input_id)+" ";
					mes "5. "+.@top_guild[4]+" "+.@top_amount[4]+" "+getitemname(.@input_id)+" ";
					close;
					
				case 4:
					query_sql ("SELECT amount , char_id FROM cart_inventory WHERE nameid = "+.@input_id+" ORDER BY amount DESC LIMIT 5", .@top_amount, .@top_char);
			
					mes "1. "+.@top_char[0]+" "+.@top_amount[0]+" "+getitemname(.@input_id)+" ";
					mes "2. "+.@top_char[1]+" "+.@top_amount[1]+" "+getitemname(.@input_id)+" ";
					mes "3. "+.@top_char[2]+" "+.@top_amount[2]+" "+getitemname(.@input_id)+" ";
					mes "4. "+.@top_char[3]+" "+.@top_amount[3]+" "+getitemname(.@input_id)+" ";
					mes "5. "+.@top_char[4]+" "+.@top_amount[4]+" "+getitemname(.@input_id)+" ";
					close;

				case 5:
					query_sql ("SELECT amount , send_name FROM mail WHERE nameid = "+.@input_id+" ORDER BY amount DESC LIMIT 5", .@top_amount, .@top_char$);
			
					mes "1. Sender "+.@top_char$[0]+" "+.@top_amount[0]+" "+getitemname(.@input_id)+" ";
					mes "2. Sender "+.@top_char$[1]+" "+.@top_amount[1]+" "+getitemname(.@input_id)+" ";
					mes "3. Sender "+.@top_char$[2]+" "+.@top_amount[2]+" "+getitemname(.@input_id)+" ";
					mes "4. Sender "+.@top_char$[3]+" "+.@top_amount[3]+" "+getitemname(.@input_id)+" ";
					mes "5. Sender "+.@top_char$[4]+" "+.@top_amount[4]+" "+getitemname(.@input_id)+" ";
					close;

				}
			close;

	case 2:
	mes "Please choose a Table: ";
	switch( select( "Inventory:Storage:Guild Storage:Cart:Mail"))
		{
		case 1:
			mes "ITEM INVENTORY RANKING";
			mes "-----------------------";
		
			query_sql ("SELECT SUM(amount) , nameid FROM inventory GROUP BY nameid ORDER BY SUM(amount) DESC LIMIT 10", .@rank_amount, .@rank_id);
		
			mes "1. "+getitemname(.@rank_id[0])+"^0055FF ("+.@rank_amount[0]+")^000000";
			mes "2. "+getitemname(.@rank_id[1])+"^0055FF ("+.@rank_amount[1]+")^000000";
			mes "3. "+getitemname(.@rank_id[2])+"^0055FF ("+.@rank_amount[2]+")^000000";
			mes "4. "+getitemname(.@rank_id[3])+"^0055FF ("+.@rank_amount[3]+")^000000";
			mes "5. "+getitemname(.@rank_id[4])+"^0055FF ("+.@rank_amount[4]+")^000000";
			mes "6. "+getitemname(.@rank_id[5])+"^0055FF ("+.@rank_amount[5]+")^000000";
			mes "7. "+getitemname(.@rank_id[6])+"^0055FF ("+.@rank_amount[6]+")^000000";
			mes "8. "+getitemname(.@rank_id[7])+"^0055FF ("+.@rank_amount[7]+")^000000";
			mes "9. "+getitemname(.@rank_id[8])+"^0055FF ("+.@rank_amount[8]+")^000000";
			mes "10. "+getitemname(.@rank_id[9])+"^0055FF ("+.@rank_amount[9]+")^000000";
			close;
		
		case 2:
			mes "ITEM STORAGE RANKING";
			mes "-----------------------";
		
			query_sql ("SELECT SUM(amount) , nameid FROM storage GROUP BY nameid ORDER BY SUM(amount) DESC LIMIT 10", .@rank_amount, .@rank_id);
		
			mes "1. "+getitemname(.@rank_id[0])+"^0055FF ("+.@rank_amount[0]+")^000000";
			mes "2. "+getitemname(.@rank_id[1])+"^0055FF ("+.@rank_amount[1]+")^000000";
			mes "3. "+getitemname(.@rank_id[2])+"^0055FF ("+.@rank_amount[2]+")^000000";
			mes "4. "+getitemname(.@rank_id[3])+"^0055FF ("+.@rank_amount[3]+")^000000";
			mes "5. "+getitemname(.@rank_id[4])+"^0055FF ("+.@rank_amount[4]+")^000000";
			mes "6. "+getitemname(.@rank_id[5])+"^0055FF ("+.@rank_amount[5]+")^000000";
			mes "7. "+getitemname(.@rank_id[6])+"^0055FF ("+.@rank_amount[6]+")^000000";
			mes "8. "+getitemname(.@rank_id[7])+"^0055FF ("+.@rank_amount[7]+")^000000";
			mes "9. "+getitemname(.@rank_id[8])+"^0055FF ("+.@rank_amount[8]+")^000000";
			mes "10. "+getitemname(.@rank_id[9])+"^0055FF ("+.@rank_amount[9]+")^000000";
			close;
		
		case 3:
			mes "ITEM GUILD STORAGE RANKING";
			mes "-----------------------";
		
			query_sql ("SELECT SUM(amount) , nameid FROM guild_storage GROUP BY nameid ORDER BY SUM(amount) DESC LIMIT 10", .@rank_amount, .@rank_id);
		
			mes "1. "+getitemname(.@rank_id[0])+"^0055FF ("+.@rank_amount[0]+")^000000";
			mes "2. "+getitemname(.@rank_id[1])+"^0055FF ("+.@rank_amount[1]+")^000000";
			mes "3. "+getitemname(.@rank_id[2])+"^0055FF ("+.@rank_amount[2]+")^000000";
			mes "4. "+getitemname(.@rank_id[3])+"^0055FF ("+.@rank_amount[3]+")^000000";
			mes "5. "+getitemname(.@rank_id[4])+"^0055FF ("+.@rank_amount[4]+")^000000";
			mes "6. "+getitemname(.@rank_id[5])+"^0055FF ("+.@rank_amount[5]+")^000000";
			mes "7. "+getitemname(.@rank_id[6])+"^0055FF ("+.@rank_amount[6]+")^000000";
			mes "8. "+getitemname(.@rank_id[7])+"^0055FF ("+.@rank_amount[7]+")^000000";
			mes "9. "+getitemname(.@rank_id[8])+"^0055FF ("+.@rank_amount[8]+")^000000";
			mes "10. "+getitemname(.@rank_id[9])+"^0055FF ("+.@rank_amount[9]+")^000000";
			close;
		
		case 4:
			mes "ITEM CART RANKING";
			mes "-----------------------";
		
			query_sql ("SELECT SUM(amount) , nameid FROM cart_inventory GROUP BY nameid ORDER BY SUM(amount) DESC LIMIT 10", .@rank_amount, .@rank_id);
		
			mes "1. "+getitemname(.@rank_id[0])+"^0055FF ("+.@rank_amount[0]+")^000000";
			mes "2. "+getitemname(.@rank_id[1])+"^0055FF ("+.@rank_amount[1]+")^000000";
			mes "3. "+getitemname(.@rank_id[2])+"^0055FF ("+.@rank_amount[2]+")^000000";
			mes "4. "+getitemname(.@rank_id[3])+"^0055FF ("+.@rank_amount[3]+")^000000";
			mes "5. "+getitemname(.@rank_id[4])+"^0055FF ("+.@rank_amount[4]+")^000000";
			mes "6. "+getitemname(.@rank_id[5])+"^0055FF ("+.@rank_amount[5]+")^000000";
			mes "7. "+getitemname(.@rank_id[6])+"^0055FF ("+.@rank_amount[6]+")^000000";
			mes "8. "+getitemname(.@rank_id[7])+"^0055FF ("+.@rank_amount[7]+")^000000";
			mes "9. "+getitemname(.@rank_id[8])+"^0055FF ("+.@rank_amount[8]+")^000000";
			mes "10. "+getitemname(.@rank_id[9])+"^0055FF ("+.@rank_amount[9]+")^000000";
			close;

		case 5:
			mes "ITEM MAIL RANKING";
			mes "-----------------------";
		
			query_sql ("SELECT SUM(amount) , nameid FROM mail GROUP BY nameid ORDER BY SUM(amount) DESC LIMIT 10", .@rank_amount, .@rank_id);
		
			mes "1. "+getitemname(.@rank_id[0])+"^0055FF ("+.@rank_amount[0]+")^000000";
			mes "2. "+getitemname(.@rank_id[1])+"^0055FF ("+.@rank_amount[1]+")^000000";
			mes "3. "+getitemname(.@rank_id[2])+"^0055FF ("+.@rank_amount[2]+")^000000";
			mes "4. "+getitemname(.@rank_id[3])+"^0055FF ("+.@rank_amount[3]+")^000000";
			mes "5. "+getitemname(.@rank_id[4])+"^0055FF ("+.@rank_amount[4]+")^000000";
			mes "6. "+getitemname(.@rank_id[5])+"^0055FF ("+.@rank_amount[5]+")^000000";
			mes "7. "+getitemname(.@rank_id[6])+"^0055FF ("+.@rank_amount[6]+")^000000";
			mes "8. "+getitemname(.@rank_id[7])+"^0055FF ("+.@rank_amount[7]+")^000000";
			mes "9. "+getitemname(.@rank_id[8])+"^0055FF ("+.@rank_amount[8]+")^000000";
			mes "10. "+getitemname(.@rank_id[9])+"^0055FF ("+.@rank_amount[9]+")^000000";
			close;

		}
	
	}
}
close;

}

   Final Try. Hope someone can help me on how to get the SUM of the highest and lowest item from inventory,storage, guild storage,cart inventory and mail. With the account id/account name.

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
Answer this question...

×   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.

×
 Share
Go to question listing
×
×
  • Create New...