vb.org Archive
Page 33 of 53 « First 233132 33 343543 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 Boardstatistic Version 2 (https://vborg.vbsupport.ru/showthread.php?t=66783)

alqafelah 09-21-2004 04:01 PM
Gteat hack, but have error :(

PHP Code:
Database error in vBulletin :

Invalid SQL: 
    SELECT * FROM style
    WHERE (styleid = 0 AND userselect = 1)
        OR styleid = 
    ORDER BY styleid ASC
    LIMIT 1

mysql error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY styleid ASC
    LIMIT 1' at line 4

mysql error number: 1064 
any idea?

Onkel_Tom 09-21-2004 04:58 PM
Quote:
Originally Posted by alqafelah
Gteat hack, but have error :(

PHP Code:
Database error in vBulletin :

Invalid SQL: 
    SELECT * FROM style
    WHERE (styleid = 0 AND userselect = 1)
        OR styleid = 
    ORDER BY styleid ASC
    LIMIT 1

mysql error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY styleid ASC
    LIMIT 1' at line 4

mysql error number: 1064 
any idea?
Sorry, but this code you mentioned is not from vB3 Boardstatistic Version 2 hack !
You get this error because there is no number after the "styleid = " command, but this not from statistic hack ;)

Wential 09-21-2004 05:48 PM
Quote:
Originally Posted by alqafelah
Gteat hack, but have error :(

PHP Code:
Database error in vBulletin :
 
Invalid SQL: 
    SELECT * FROM style
    WHERE (styleid = 0 AND userselect = 1)
        OR styleid = 
    ORDER BY styleid ASC
    LIMIT 1
 
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY styleid ASC
    LIMIT 1' at line 4
 
mysql error number: 1064 
any idea?
What php file is this error from?

alqafelah 09-21-2004 06:30 PM
Onkel_Tom, thx for reply but i got this error in this hack only !

Wential, the Statistics home worked fine .. but the error got when i press on any of these links :

Overview | Browsers / Operating Systems | Countries of visitors | Searchrobots / Spiders | Last days | Referers / Top Level Domains | Polls / Stickys / Searchwords

thanx

Onkel_Tom 09-21-2004 08:57 PM
Hmm, we only use the variable styleid in the installation file to install all the Templates to the database. No where else this variable is used.

Wential 09-21-2004 10:15 PM
I tried to re-create this error and failed. It looks like something went wrong on the installation. Considering the number of Mods in your Forum, I'm not really surprised.

Code Monkey 09-22-2004 02:31 AM
Installed. Works great. :D

One question though. How is this affected by something like vbindex or the like? Since many visitors enter the site through the front page.

Wential 09-22-2004 03:11 AM
It is unaffected by VBindex since I use both hacks on my board and my stats are great!

venomx 09-22-2004 03:22 AM
Noone can help me? :(

Code Monkey 09-22-2004 04:51 AM
One thing I noticed in functions_statistik.php. You use ereg quite a bit. Such as.
PHP Code:
if(ereg("Opera", $agent)) $c_browser = "Opera"; 
More efficient would be to use PCRE functions.
PHP Code:
 if(preg_match('#Opera#', $agent)) $c_browser = 'Opera'; 
And since no regular expresions are really needed for this, far more efficient would be.
PHP Code:
if(strpos($agent, 'Opera')) $c_browser = 'Opera'; 
Anyway, thanks for the hack.


All times are GMT. The time now is 11:38 PM.
Page 33 of 53 « First 233132 33 343543 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.01871 seconds
  • Memory Usage 1,756KB
  • 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
  • (6)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