Club members @ /myclubs

[Dobby]

This isn't advertising my club. I was doing it to suggest an addition.

From:



To:

Club Funds: $1,333,337
Club Members: 1337

Or something like that

Like it? Good. 
Dont like it? 

[TheSandman]

I woudlnt put it under club funds, since that is under "base and funds", id put it under description or founder

[Dobby]

I woudlnt put it under club funds, since that is under "base and funds", id put it under description or founder

Ok but cant "base and funds" be changed to "Club info" or "Club stats"?

[Joshy]

in the SQL query for "clubs" when you get the info, add a field called "(SELECT COUNT(*) FROM club_members WHERE club_id = clubs.id AND position > 0) as member_count" in the SELECT statement. Get it with mysql_fetch...("member_count")

So atm you have a query like

Code (SQL) Select Expand

SELECT *, club_base.* FROM clubs LEFT JOIN club_base ON clubs.id = club_base.club_id WHERE clubs.id = %n
Change it to (don't copy this directly, just add the new field where I put it;

Code (SQL) Select Expand

SELECT *, club_base.*, (SELECT COUNT(*) FROM club_members WHERE club_id = clubs.id AND position > 0) as member_count FROM clubs LEFT JOIN club_base ON clubs.id = club_base.club_id WHERE club_id = %n

[Matias]

Added.



Edit: Due to some issues the code will be reviewed for next update.