Zeny Ladder

[cahadeyelo]

Can someone help me with this script
 

function	script	ZENYLADDER	{
	query_sql("SELECT `c`.`name`, `c`.`class`, `c`.`base_level`, `c`.`job_level`, `c`.`zeny`, `g`.`name` FROM `char` c LEFT JOIN (`guild` g) ON (`c`.`guild_id` = `g`.`guild_id`) ORDER BY `c`.`zeny` DESC LIMIT 100", .@name$, .@class, .@blvl, .@jlvl, .@zeny, .@guild$);	

	mes "[ INFORMATION ]";
	for( set .@x,0; .@x<=99; set .@x,.@x+1 ) {
	mes "^0000FF"+(.@x+1)+".^000000 "+.@name$[.@x]+" - ^FF0000"+.@zeny[.@x]+"^000000z";
	}
	close;
}

This shows the zeny ranking on my server, the problem is the value of the zeny isn't separated by place value it just shows like this 100000 not like this 100,000.

[Winterfox]

function	script	ZENYLADDER	{
	query_sql("SELECT `c`.`name`, `c`.`class`, `c`.`base_level`, `c`.`job_level`, `c`.`zeny`, `g`.`name` FROM `char` c LEFT JOIN (`guild` g) ON (`c`.`guild_id` = `g`.`guild_id`) ORDER BY `c`.`zeny` DESC LIMIT 100", .@names$, .@classes, .@blvls, .@jlvls, .@zeny, .@guilds$);	

	mes "[ INFORMATION ]";
	for(.@i = 0; .@i < 100; .@i++)
	    mes "^0000FF" + (.@i + 1) + ".^000000 " + .@names$[.@i] + " - ^FF0000" + callfunc("F_InsertComma", .@zeny[.@i]) + "^000000z";
	close;
}

 

Edited July 11, 2023 by Winterfox

[cahadeyelo]

35 minutes ago, Winterfox said:

function	script	ZENYLADDER	{
	query_sql("SELECT `c`.`name`, `c`.`class`, `c`.`base_level`, `c`.`job_level`, `c`.`zeny`, `g`.`name` FROM `char` c LEFT JOIN (`guild` g) ON (`c`.`guild_id` = `g`.`guild_id`) ORDER BY `c`.`zeny` DESC LIMIT 100", .@names$, .@classes, .@blvls, .@jlvls, .@zeny, .@guilds$);	

	mes "[ INFORMATION ]";
	for(.@i = 0; .@i < 100; .@i++)
	    mes "^0000FF" + (.@i + 1) + ".^000000 " + .@names$[.@i] + " - ^FF0000" + callfunc("F_InsertComma", .@zeny[.@i]) + "^000000z";
	close;
}

 

it does what i wanted to do thanks but now all the names of the players that own the zeny are gone.

[cahadeyelo]

i've fixed it..THANKS
 

mes "^0000FF"+(.@x+1)+".^000000 "+.@name$[.@x]+" - ^FF0000"+ callfunc("F_InsertComma",.@zeny[.@x])+"^000000z";