DragonPrime - LoGD Resource Community
Welcome Guest
  • Good morning, Guest.
    Please log in, or register.
  • June 20, 2018, 02:16:22 AM
Home Forums News Downloads Login Register Advanced Search
* * *
DragonPrime Menu
Resource Pages

Pages: [1]   Go Down
Author Topic: Listing  (Read 2362 times)
0 Members and 1 Guest are viewing this topic.
« on: August 21, 2005, 01:12:36 AM »

Alright, I've searched through the forum, using the, "Search" method, and I haven't found anything relative to this topic.

What I'm wanting to do, is make an easy way in the superuser grotto, to simply click on a nav, and then a list to appear, with everyone on the server on it, and it only listing their Name, Gold on hand, Gold in bank, Gems on hand....and if at all possible, how much they have in a module_pref that I've made, but I don't know how to even call that, so that's not a top priority.

Alright, now, I think i've got the SQL call to get everyone's info that I want listed.

And I've got the table set up to show the info that I want listed..

Just, I can't figure out how to get the information from the SQL call, to appear in the table..

I've looked over different scripts like, "list.php or user.php"..I still can't get it..

I was wondering if there was anyone out there, that could go through a step-by-step break down of what to do/how it does it...if at all possible. I do realize that most people probably won't have the time to do this for me...but if anyone can and does, I would be truely appreciative.


Mod God
Offline Offline

Posts: 2238

I'm a good girl.

View Profile WWW
« Reply #1 on: August 21, 2005, 01:56:18 AM »

Have a look at specifically, the ONLINE section of the list.php - all you will need to do is change the flags. Instead of Online status you will have * and instead of Sex and Location you would have Gold, Gems, etc.

Owner of GemDust.com and Darton City proudly hosted by LunarPages
iMod God
SVN Users
Mod God
Offline Offline

Posts: 3458

If ya didn't get it by now... you're hopeless...

View Profile WWW
« Reply #2 on: August 21, 2005, 10:02:43 AM »

$sql = "SELECT name,gold,goldinbank,gems,value FROM ".db_prefix("accounts")." INNER JOIN ".db_prefix("module_userprefs")." ON acctid=userid WHERE modulename='yourmodulename' AND setting='yourgemsettingname'";
That should do it... then just query the server, and fetch the associating data from the SQL call. Then, pump it into a table. You can figure that you by looking at ANY of the scripts that have a table or even simple server querying.
« Last Edit: August 21, 2005, 10:06:48 AM by Sichae » Logged

If you didn't understand anything in the above post, don't try to attempt anything suggested.

Pages: [1]   Go Up
Jump to:  

DragonPrime Notices
Please take the time to read the FAQ and browse the DragonPedia

Support Us
No funds raised yet this year
Your help is greatly appreciated!
Recent Topics
DragonPrime LoGD
Who's Online
51 Guests, 0 Users
Home Forums News Downloads Login Register Advanced Search