Statistics tweaking

Support and feedback for UniAdmin

Statistics tweaking

Postby Tupsi » Thu Jun 21, 2007 7:58 pm

Morning

I was looking for a way to change the piecharts into showing me more then 5 slices or filter stuff in the action part like "gettaddonlist", "getsettings", etc. only showing me what addons people actually downloaded.

Right now "GETADDONLIST, GETSETTINGS, GETDELETEADDONS" or in the top5 only showing me 2 addons.

was hoping to find the number of slices somewhere in the php files and just raise that to a number which helps me, but was not able to find it.

any hints?
Tupsi
WR.net Apprentice
WR.net Apprentice
 
Posts: 74
Joined: Fri Jul 14, 2006 5:26 pm

Statistics tweaking

Postby zanix » Thu Jun 21, 2007 10:15 pm

None actually,
Matt made the pie charts and I don't quite understand how to change them
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5546
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Statistics tweaking

Postby PleegWat » Fri Jun 22, 2007 12:25 am

Stats.php, line 195, contains the SQL query that fetches the data.

Code: Select all
    $sql "SELECT count(`id`) count, `$field_name` field FROM `".UA_TABLE_STATS."` GROUP BY `$field_name` ORDER BY `count` DESC LIMIT 0,5";
 


Change the LIMIT 0,5 to the start/amount you want.
I <3 /bin/bash
User avatar
PleegWat
WoWRoster.net Dev Team
WoWRoster.net Dev Team
 
Posts: 1636
Joined: Tue Jul 04, 2006 1:43 pm

Statistics tweaking

Postby Tupsi » Thu Nov 22, 2007 8:57 pm

Thanks for the hint Pleegwat. Lucky me I tried the search first, was about to repost the question as I had completly forgot about it :-)

I changed it to LIMIT 2,10 now and its doing what I wanted in the first place, thanks.
Tupsi
WR.net Apprentice
WR.net Apprentice
 
Posts: 74
Joined: Fri Jul 14, 2006 5:26 pm

Statistics tweaking

Postby lunzet » Fri Nov 23, 2007 9:15 am

great news....looking much better now.

thx
User avatar
lunzet
WR.net Journeyman
WR.net Journeyman
 
Posts: 119
Joined: Sat Jan 13, 2007 1:23 pm


Return to UniAdmin

Who is online

Users browsing this forum: No registered users and 0 guests