vb.org Archive - vb3 Statistic Version 1.01

Page 16 of 19

« 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 Statistic Version 1.01 (https://vborg.vbsupport.ru/showthread.php?t=65924)

Wachtmeister

06-13-2004 06:22 PM

I've renamed the tables to fix the table-prefix problem.

Now, when running http://........../statistik.php i get the following:

Database error in vBulletin 3.0.1:

Invalid SQL:
SELECT threadid, title, lastpost, postusername,lastposter,dateline
FROM vb3_thread
WHERE forumid IN(1, 2, 7, 67, 9, 69, 70, 65, 66, 3, 4, 5, 6, 71, 73, 76, 77, 78, 79, 80, 72, 64, 41, 44, 57, 60, 61, 43, 62, 63, 40, 59, 45, 46, 47, 56, 53, 52, 55, 54, 58, 74, 75, 42, 48, 49, 50, 51, 12, 13, 14)
AND thread.open <> 10
AND thread.visible = '1'
ORDER BY lastpost
DESC LIMIT 10

mysql error: Unknown table 'thread' in where clause

mysql error number: 1109

Date: Sunday 13th of June 2004 09:18:01 PM
Script: http://www.webgurus.de/forum/statistik.php
Referer:
Username:
IP Address: 217.231.170.193

Can someone help?

RapCheck

06-13-2004 06:31 PM

I've been waiting since vb3 came out for this hack, users always ask for the stats back!

But, I wish wish wish it was 100% english. I just dont feel comfortable with this one yet :(

Wachtmeister

06-13-2004 06:34 PM

I'll do the translation, but i want to get it running first....

Doesn't this hack work with vb's using table prefix?

killervette

06-13-2004 06:34 PM

The last 10 days is still not showing up for me...anyone else??

Mijae

06-17-2004 02:15 AM

I'd install this, but I checked and some parts of the template arent working properly :D

Natch

06-17-2004 02:57 AM

Quote:

Originally Posted by Wachtmeister

With your renamed tables, you need to make it

Code:

FROM vb3_thread as thread

- then your script will work as normal ...

PcFreak

06-17-2004 12:10 PM

@all
I am now finished with the statistics version 1.5
The new version is full XHTML coded

https://vborg.vbsupport.ru/external/2010/10/30.jpg

All other code is optimized and i have fix some bugs.
I have mad an another Statistic Module for the Arcade Hack
Top Level Domains now showing.
The statistic have a navigationbar now.

At moment i don?t release this hack, because the hack is in testing mode.

But feel free to check the new statistic here:

http://at-lantis.de/statistik.php

Improvement suggestions and criticism are welcome

PcFreak

Intex

06-17-2004 06:06 PM

PCFreak - Looks great. Let me know if you want someone to test it on a separate system.

Quote:

Originally Posted by PcFreak

SaN-DeeP

06-17-2004 11:30 PM

weird but i am getting this error:

Code:

 Database error in vBulletin 3.0.0: 

Invalid SQL: 

SELECT threadid, title, lastpost, postusername,lastposter,dateline 

FROM vb3_thread 

WHERE forumid IN(3, 4, 44, 5, 45, 6, 14, 52, 11, 10, 46, 13, 30, 33, 43, 34, 32, 31, 37, 38, 40, 42, 39, 41, 15, 16, 17, 18, 19, 7, 36, 21, 24, 35, 20, 22, 47, 48, 53, 49, 50, 51, 25, 26, 27)

AND thread.open <> 10

AND thread.visible = '1'                

ORDER BY lastpost 

DESC LIMIT 10 

 

mysql error: Unknown table 'thread' in where clause

mysql error number: 1109

changing few lines make it work:

Code:

 $getbeitraege= $DB_site->query("

  SELECT threadid, title, lastpost, postusername,lastposter,dateline  

  FROM " . TABLE_PREFIX . "thread 

  WHERE forumid IN(" . implode(', ', $forumids) . ")

  AND vb3_thread.open <> 10

  AND vb3_thread.visible = '1'                

  ORDER BY lastpost 

  DESC  LIMIT $limit 

 ");

esnecca

06-18-2004 12:26 AM

It looks beautiful, PcFreak. You might consider removing the word statistic/s from every category heading except "General Statistics". You already have two titles without the word statistic/s in them, and I think it might read a little more smoothly. Just an idea...:)

Thank you for such a great hack.

All times are GMT. The time now is 03:57 PM.

Page 16 of 19

« First

Last »

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01227 seconds Memory Usage 1,747KB 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 (3)bbcode_code_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)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: