DragonPrime - LoGD Resource Community
Welcome Guest
  • Good afternoon, Guest.
    Please log in, or register.
  • July 30, 2016, 01:41:35 PM
Home Forums News Links Downloads Login Register Advanced Search
* * *
DragonPrime Menu
Login
 
 
Resource Pages
IRC Channels
Search

Pages: [1]   Go Down
  Print  
Author Topic: Listing  (Read 1710 times)
0 Members and 1 Guest are viewing this topic.
Dhampir
Guest
« 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.

Thanks,

-Dhampir
Logged
SaucyWench
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.
Logged

SaucyWench
Owner of GemDust.com and Darton City proudly hosted by LunarPages
Sichae
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 »

Code:
$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
  Print  
 
Jump to:  


*
DragonPrime Notices
Play LoGD on Dragonprime

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