vb.org Archive
Page 12 of 50 « First 21011 12 131422 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   Referral Statistics (https://vborg.vbsupport.ru/showthread.php?t=64469)

gspot 09-08-2004 07:44 AM
Quote:
Originally Posted by venomx
Sorry didnt try to install this yet just read the first few pages. How about a way to count how many new refs since last reset?
Ok people I have re-edited the whole layout of this hack... I think everyone will like it. Please check-out the new pictures and the new features that it has to offer. Many features where added from VENOMX's requests that I think all of us will find useful. Enjoy and post any comment or suggestions that you may have. :)

venomx 09-08-2004 08:08 AM
Cool :)
Ill install this in a few hours.. Was just heading to bed when the email came in saying you posted.. :P

gspot 09-08-2004 08:10 AM
Quote:
Originally Posted by venomx
Cool :)
Ill install this in a few hours.. Was just heading to bed when the email came in saying you posted.. :P
No problem, had some free time this afternoon and now its bedtime for me as well. Hope you all like it. :)

venomx 09-08-2004 08:14 AM
Hey just had an idea.... What would be nice is for you/someone to make an addon for this and uShop.

Like an on/off switch for the "since reset" counter and when we turn it off it auto awards the top 3 members whatever amount of points we have set for the winners...
When its turned off it wouldnt show the since last reset text of the pages for the members... :P

gspot 09-08-2004 02:33 PM
Quote:
Originally Posted by venomx
Hey just had an idea.... What would be nice is for you/someone to make an addon for this and uShop.

Like an on/off switch for the "since reset" counter and when we turn it off it auto awards the top 3 members whatever amount of points we have set for the winners...
When its turned off it wouldnt show the since last reset text of the pages for the members... :P
Remember to click Install. Yes, that is a whole different hack that I dont support. Sorry, but if someone else wants to make this an addon then please go ahead. Since everyone's referal competitions are probably going to be different. Some people will issue points, some will issues prizes and so forth. Sorry.

etaslim 09-12-2004 02:14 PM
How to add the new database table? Has to be done from PHPMyAdmin, is it? Can someone be kind enough to advice step by step procedure. Thanks alot!

gspot 09-12-2004 04:16 PM
Quote:
Originally Posted by etaslim
How to add the new database table? Has to be done from PHPMyAdmin, is it? Can someone be kind enough to advice step by step procedure. Thanks alot!
In PHPMyAdmin run this query:

CREATE TABLE `referrals` (
`date` TEXT NOT NULL
);

Or for step by step:
1) create a new table named: "referrals"
2) create one new field named: "date"
3) Type: "text"
4) not null

Hope this helps :)

SaN-DeeP 09-14-2004 10:48 AM
Code:
Database error in vBulletin 3.0.3:

Invalid SQL: SELECT COUNT(*) AS referrals, user.username, user.userid FROM vb3_user AS users LEFT JOIN user AS user ON (users.referrerid = user.userid)
                                  WHERE user.userid > 0
                                  GROUP BY users.referrerid
                                  ORDER BY referrals DESC
                                  LIMIT 10
mysql error: Table ******.user' doesn't exist
aNy fix for this ?

thnx

gspot 09-14-2004 03:19 PM
Quote:
Originally Posted by SaN-DeeP
Code:
Database error in vBulletin 3.0.3:

Invalid SQL: SELECT COUNT(*) AS referrals, user.username, user.userid FROM vb3_user AS users LEFT JOIN user AS user ON (users.referrerid = user.userid)
                                  WHERE user.userid > 0
                                  GROUP BY users.referrerid
                                  ORDER BY referrals DESC
                                  LIMIT 10
mysql error: Table ******.user' doesn't exist
aNy fix for this ?

thnx
SAn-deep

I think you need to try it again. If your using a database table prefix for vbulletin, it looks like the script is working then. Is your prefix "vb3" for your database tables? The script is trying to grab the table "vb3_user" - do you even have this table in your vbulletin database? If not, you need to not use a database prefix and it should be trying to use table "user". Many people have installed this hack with no problems.

-GSPOT-

etaslim 09-16-2004 11:52 AM
Quote:
Originally Posted by gspot
In PHPMyAdmin run this query:
Hope this helps :)
Great! Thanks for the help, gspot. It runs perfectly now on my two forums.


All times are GMT. The time now is 05:09 PM.
Page 12 of 50 « First 21011 12 131422 Last »
Show 40 post(s) from this thread on one page

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.01265 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
  • (2)bbcode_code_printable
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (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