Thread
:
Display full list of referrers and referrals
View Single Post
#
46
09-03-2001, 09:58 PM
dwh
Join Date: Feb 2002
Posts: 278
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
since the php vbcode isn't working, once again, here's the proper code to try:
"SELECT COUNT(*) AS referrals, user.username, user.userid FROM user AS users
LEFT JOIN user ON (users.referrerid = user.userid)
WHERE users.referrerid <> 0 AND
user.userid NOT IN (0)
GROUP BY users.referrerid
ORDER BY referrals DESC
LIMIT 100"
dwh
View Public Profile
Find all posts by dwh
X
vBulletin 3.8.12 by vBS Debug Information
Page Generation
0.01318 seconds
Memory Usage
1,754KB
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)
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
Messages:
(unspecified) fetch_permissions(4, 0, 1,''); -> cached fperms for forum 4
returning smilies from the datastore
(unspecified) fetch_permissions(4, 0, 1,''); -> cached fperms for forum 4
(unspecified) fetch_permissions(4, 0, 1,''); -> cached fperms for forum 4
php_sapi_name(): fpm-fcgi