View Single Post
  #2  
Old 12-12-2005, 02:57 PM
---MAD--- ---MAD--- is offline
 
Join Date: Jun 2005
Location: Earth
Posts: 191
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by toytaco99
Ok, I spent about 2 hours last night searching for some help with this and am still stuck.

I'm creating a custom index page on my site to list all of my site donators. This is seperate from the Show Forum Leaders page. It's a PHP page and I've not been using templates because it pulls in items from other parts of the site, too.

So, can someone help me figure out the PHP to create the query of all users in (secondary or primary) group x and display their usernames on a page?

I did this with my old forum (ubb.threads) and it worked fine, but I'm drowning in a sea of PHP code right now.

Thanks in advance for any help.

Ok, I was able to figure it out this morning (7 hours of sleep helps) with the following code:

PHP Code:
$groupid 19;

        
$group $db->query_read("
            SELECT userid, username
            FROM " 
TABLE_PREFIX "user
            WHERE 
$groupid IN(membergroupids) OR usergroupid = $groupid
            ORDER BY username ASC
        "
);
        
        while (
$person $db->fetch_array($group))
        {
            echo 
"<option value=\"/forum/member.php?u=$person[userid]\">$person[username]</option>";
        }
        unset(
$group);
        
$db->free_result($group); 
I was actually putting the users into a drop down menu, so that's why there's an "option" tag in there.

Not sure if this snippet of code will help anyone else on here, but if it does, great!
hmm no one has replied.
I tried your code, it doesnt use the templates or styles and doesnt look good. It just shows all my users on next to each other. Not spaced out.
Maybe someone can add to it :s?
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01259 seconds
  • Memory Usage 1,788KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_php
  • (1)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete