[SQL query] Need help ^^

[Kavvson]

$guildMembers = $SQL->query( 'SELECT COUNT(`gr`.`id`) AS `total` FROM `players` AS `p` LEFT JOIN `guild_ranks` AS `gr` ON `gr`.`id` = `p`.`rank_id` WHERE `gr`.`guild_id` = '.$guild_id )->fetch( );

$allM = $SQL->query ('SELECT COUNT(1) as `people` FROM `players` WHERE `rank_id` IN (SELECT `id` FROM `guild_ranks` WHERE `guild_id` = '.$guild_id.') AND online = 1')->fetch();

How to convert this scripts into a 1. Top guild members count 2. Top guild members online...

As a site in gesior. ?subtopic=guildstats . Just like top fraggers script~~

 

[Kavvson]

up help me ^^

 

[chojrak]

You are allowed to bump your own threads only once per 24 hours.

 

[Kavvson]

Aff correct! anyway got an idea?

 

[stian]

$guildMembers = $SQL->query( 'SELECT (SELECT COUNT(`gr`.`id`) FROM `players` AS `p` LEFT JOIN `guild_ranks` AS `gr` ON `gr`.`id` = `p`.`rank_id` WHERE `gr`.`guild_id` = '.$guild_id.') as `total`, (SELECT COUNT(1) FROM `players` WHERE `rank_id` IN (SELECT `id` FROM `guild_ranks` WHERE `guild_id` = '.$guild_id.') AND online = 1) as `people`' )->fetch( );

Like that?

 

[Kavvson]

I dont really need the '.$guild_id.' since it should show like top 5 guilds where is the most amount of members / members online

 

[Kavvson]

Bump

 

[rockseller]

This should help you:
Select * From Guilds order by ownerid DESC LIMIT 5;

that is the same as in T-SQL:
Select TOP(5) * FROM Guilds order by ownerid

 

[Kavvson]

Not really ;(

 

[Kavvson]

Is it so hard to make?:s

 

[Kavvson]

bump ;/