vb.org Archive - vB3 Forumhome Stats Cache Serialize hack v2.2

Page 29 of 44

« First

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)

- - vB3 Forumhome Stats Cache Serialize hack v2.2 (https://vborg.vbsupport.ru/showthread.php?t=61420)

Boofo

04-09-2004 10:30 PM

Quote:

Originally Posted by surfhog

:( lol lol

I have a different error now boofo, would you have any ideas please? seem like 1 error is solved then i get another........ lol

At least this time I did see the template, before i got the error lol ;)

Database error in vBulletin 3.0.0:

Invalid SQL:
SELECT profileviews,username,userid
FROM vb3_user
ORDER BY profileviews
DESC LIMIT 1

mysql error: Unknown column 'profileviews' in 'field list'

mysql error number: 1054

You need to run Query #2 for the profileviews, just not the datastore one. ;)

Boofo

04-09-2004 10:32 PM

Quote:

Originally Posted by BarBeQue

[high]* BarBeQue gives up.... how can he convince boofo that adding posts with threads is doublecounting......
[/high]

I counted each post on my board damnit and you do NOT add the threads to it cause threadposts are already included in the postcount

Make a new thread and you'll notice your postcount go up by 1.

You're wrong on that. Posts are replies and threads are threads. You better read the code a little more before you start spouting off.

You count it however you want to. I do it the way vbulletin does it. As long as it works for you the way you want it to now, what's the big deal?

surfhog

04-09-2004 10:38 PM

I realized that I didnt do that :)

so i did that and get this error when I run the query:

#1146 - Table '*********_******.user' doesn't exist

sorry to keep asking boofo :(

Boofo

04-09-2004 11:03 PM

Don't worry. we'll get you going. ;)

Ok, run the following query in the Admin CP >Import and Maintenance > Execute SQL Query (unless you are using phpmyadmin):

[sql]ALTER TABLE " . TABLE_PREFIX . "user ADD profileviews int(10) unsigned NOT NULL default '0'[/sql]

and let me know if that runs allright. ;)

surfhog

04-09-2004 11:41 PM

yes boofo I use phpadmin for queries, so would i run the same or would it be different script please. omg it's late here 01:40, I must be keen or just nutz lol

nope I tried the query and no it did not work same error :(

boofo are you on chat or would you have a spare moment to browse what i have done?

Boofo

04-10-2004 12:09 AM

Do you have a table prefix?

surfhog

04-10-2004 12:27 AM

yes Sir, I sure do..........

vb3_

Boofo

04-10-2004 01:02 AM

Then use this query.

[sql]ALTER TABLE vb3_user ADD profileviews int(10) unsigned NOT NULL default '0'[/sql]

surfhog

04-10-2004 01:09 AM

thanks boofo - okay the query executed.

but I still have error:

Database error in vBulletin 3.0.0:

Invalid SQL:
SELECT COUNT(*) AS referrals, user.username, user.userid
FROM vb3_user AS users
LEFT JOIN vb3_user ON (users.referrerid = user.userid)
WHERE users.referrerid <> 0
GROUP BY users.referrerid
ORDER BY referrals DESC
LIMIT 1

mysql error: Unknown table 'user' in field list

mysql error number: 1109

Boofo

04-10-2004 01:17 AM

Ok, you NEED to have that code like I have it here:

PHP Code:


		
			
    // <!-- TOP REFERRER -->

    $ref = $DB_site->query_first("

        SELECT COUNT(*) AS referrals, user.username, user.userid

        FROM " . TABLE_PREFIX . "user AS users

        LEFT JOIN " . TABLE_PREFIX . "user ON (users.referrerid = user.userid)

        WHERE users.referrerid <> 0

        GROUP BY users.referrerid

        ORDER BY referrals DESC

        LIMIT 1

    ");

Don't replace the TABLE_PREFIX with yours. Put this code in the file in place of the one you changed.

All times are GMT. The time now is 07:22 PM.

Page 29 of 44

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01727 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_php_printable (2)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
Messages: