Mysidia Adoptables Support Forum  

Home Community Mys-Script Creative Off-Topic
Go Back   Mysidia Adoptables Support Forum > Mysidia Adoptables > Questions and Supports

Notices

Reply
 
Thread Tools Display Modes
  #1  
Old 07-07-2014, 09:16 AM
Missy Master's Avatar
Missy Master Missy Master is offline
Pet-Sim.Online
 
Join Date: Jan 2010
Posts: 475
Gender: Unknown/Other
Credits: 44,555
Missy Master is an unknown quantity at this point
Default 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 :)
Reply With Quote
  #2  
Old 07-07-2014, 09:29 AM
Hwona's Avatar
Hwona Hwona is offline
Member
 
Join Date: Mar 2013
Posts: 620
Gender: Female
Credits: 48,191
Hwona is on a distinguished road
Default

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?
__________________
Reply With Quote
  #3  
Old 07-07-2014, 09:58 AM
Missy Master's Avatar
Missy Master Missy Master is offline
Pet-Sim.Online
 
Join Date: Jan 2010
Posts: 475
Gender: Unknown/Other
Credits: 44,555
Missy Master is an unknown quantity at this point
Default

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 !
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

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


All times are GMT -5. The time now is 10:34 AM.

Currently Active Users: 663 (0 members and 663 guests)
Threads: 4,080, Posts: 32,024, Members: 2,016
Welcome to our newest members, jolob.
BETA





What's New?

What's Hot?

What's Popular?


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
vBCommerce I v2.0.0 Gold ©2010, PixelFX Studios
vBCredits I v2.0.0 Gold ©2010, PixelFX Studios
Emoticons by darkmoon3636