vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Referrers On Forumhome v.1.3 (https://vborg.vbsupport.ru/showthread.php?t=101324)

tnguy3n 11-27-2005 09:00 PM

Quote:

Originally Posted by Boofo
Hey, college boy. How's it going? ;)

Any way to have the number of referrals after each name be clickable with a window and a list of the names? Or maybe take you to another page that has a referral listing of some kind for the site? ;)

Hey boofy, how is it down there in Des Moines? School is getting more tensed now as it's getting closer to finals.

A popup that lists all of the names is cool, but maybe I'll add another query to get the list since the other one is way too big aleady.

Boofo 11-27-2005 09:06 PM

Quote:

Originally Posted by tnguy3n
Hey boofy, how is it down there in Des Moines? School is getting more tensed now as it's getting closer to finals.

A popup that lists all of the names is cool, but maybe I'll add another query to get the list since the other one is way too big aleady.

A new page with how many and the names, too? ;)

Make sure you let me know when you get some free time and we'll hook up since you are this close. ;)

MThornback 11-28-2005 12:03 PM

Quote:

Database error in vBulletin 3.5.1:

Invalid SQL:
SELECT COUNT(*) AS totalref, user.username, user.userid, user.usergroupid, usergroup.usergroupid, usergroup.opentag, usergroup.closetag FROM vb3_user AS users LEFT JOIN vb3_user AS user ON (users.referrerid = user.userid) LEFT JOIN vb3_usergroup ON (usergroup.usergroupid = user.usergroupid) WHERE users.referrerid != 0 GROUP BY users.referrerid ORDER BY totalref DESC LIMIT 0,5;

MySQL Error : Unknown table 'usergroup' in field list
Error Number : 1109
Date : Monday, November 28th 2005 @ 02:01:26 PM
Script : http://www.webcadets.com/forum/index.php
Referrer : http://www.webcadets.com/forum/arcade.php?&act=Arcade
IP Address :
Username : MThornback
Classname : vb_database
Help, Please?

Dead End Society 11-29-2005 11:18 AM

Yeah I get the same error when I install the plugin....when I uninstall it I can access my forums again. So this means it's conflicting with another hack right?

MThornback 11-29-2005 11:59 AM

Quote:

Originally Posted by Dead End Society
Yeah I get the same error when I install the plugin....when I uninstall it I can access my forums again. So this means it's conflicting with another hack right?

I'm thinking it means that we have another hack that dropped that row for some reason, or replaced it with something else...but I wanted to ask to be sure..

tnguy3n 12-02-2005 03:08 AM

Quote:

Originally Posted by Boofo
A new page with how many and the names, too? ;)

Done as requested. Just download and install new release of the hack. ;)

Quote:

Make sure you let me know when you get some free time and we'll hook up since you are this close. ;)
We definitely should. My semester will end on the 22nd of December, then I'll have 4 weeks off. If you have chance going to down to IC, give me me a call.

tnguy3n 12-02-2005 03:10 AM

Quote:

Originally Posted by MThornback
I'm thinking it means that we have another hack that dropped that row for some reason, or replaced it with something else...but I wanted to ask to be sure..

Frankly, I got no idea what caused that bug, but there's a work-around (posted in first post) to fix this bug.

Boofo 12-02-2005 03:52 AM

Quote:

Originally Posted by tnguy3n
Done as requested. Just download and install new release of the hack. ;)

Thank you, sir. ;)

Quote:

Originally Posted by tnguy3n
We definitely should. My semester will end on the 22nd of December, then I'll have 4 weeks off. If you have chance going to down to IC, give me me a call.

Sounds like a plan. ;)

How long do you have left then?

kurtbarker 12-03-2005 08:17 PM

hey mate, i'm getting:
Code:

Database error in vBulletin 3.5.1:

Invalid SQL:
SELECT COUNT(*) AS totalref, user.username, user.userid, user.usergroupid, usergroup.usergroupid, usergroup.opentag, usergroup.closetag FROM vb_user AS users LEFT JOIN vb_user AS user ON (users.referrerid = user.userid) LEFT JOIN vb_usergroup ON (usergroup.usergroupid = user.usergroupid) WHERE users.referrerid != 0 GROUP BY users.referrerid ORDER BY totalref DESC LIMIT 0,5;

MySQL Error  : Unknown table 'usergroup' in field list
Error Number : 1109
Date        : Saturday, December 3rd 2005 @ 04:16:21 PM
Script      : http://commodorelife.com/forums/
Referrer    :
IP Address  : 220.101.20.174
Username    : kurtbarker
Classname    : vb_database

any suggestions?

tnguy3n 12-03-2005 08:24 PM

pls read first post for the alternative.


All times are GMT. The time now is 10:36 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01135 seconds
  • Memory Usage 1,745KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (9)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete