Home Community Mys-Script Creative Off-Topic |
|
|
Thread Tools | Display Modes |
#1
|
||||
|
||||
Online list ... and a Stats Page for Players
How would I adjust the Online list to show Players in order of who has the most pets?
Also, I'd like to make a stats page for Players ... something simple that just shows their number of pets, in that order, their name, and that sort of thing :) |
#2
|
||||
|
||||
Umm, let me think... I don't know how it is with your version, but with mine, I think you'd have to write a code on the online page or something like that that for each user displayed, the code will go to the owned_adoptables table and return the count of all adoptable rows that have an owner that matches the user's name. Then, I remember reading a PHP book that tells you how to count rows and order by value, but I have no clue if that'll work with mysidia.
Another much easier way to do this if your site has no pets, is maybe to add a pet count column in the users table and set it to 0. Then, each time a user adopts a pet, add the number of pets adopted to the value. Then do the order thing. Did that make any sense? |
#3
|
||||
|
||||
I do have pets on there, but what code would I use to call it up for the total :)
Sorry I have tried a few times here and failed haha. Thanks for your help ! |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Who's Online page | parayna | Questions and Supports | 2 | 12-11-2014 12:20 PM |
Editing Stats Page & Little Icon | Glow | Questions and Supports | 4 | 12-07-2014 08:29 AM |
Showing stats on click page | Hwona | Questions and Supports | 9 | 05-07-2014 07:40 AM |
Help Making Stats Page = Click Page & Lineages? | squiggler | Questions and Supports | 2 | 02-22-2014 04:42 AM |
Online Page | Nieth | Questions and Supports | 7 | 11-26-2013 06:10 AM |
What's New? |
What's Hot? |
What's Popular? |