vb.org Archive

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

Jacko 04-13-2005 06:54 PM

anyone got this to work in 3.0.7 its fresh install and first hack..?!

summit do with functions.php i think.

get the following error:

Code:

Database error in vBulletin 3.0.7:

Invalid SQL: SELECT thread.threadid, thread.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, IF(views <= thread.replycount, thread.replycount+1, views) AS views, thread.lastposter, thread.lastpost, pollid
                  , thread.iconid AS threadiconid
                        ,thread.forumid, forum.title AS forumtitle
                        , post.pagetext AS preview
                        , NOT ISNULL(subscribethread.subscribethreadid) AS subscribed
                        FROM thread as thread
                        LEFT JOIN forum AS forum ON (thread.forumid = forum.forumid)
                        LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
                        LEFT JOIN deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
                        LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1)
                        WHERE open <> '10' AND thread.forumid NOT IN(2,) AND deletionlog.primaryid IS NULL
                        ORDER BY lastpost DESC
                        LIMIT 5
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 ') AND deletionlog.primaryid IS NULL
                        ORDER BY lastpost DESC

mysql error number: 1064


KW802 04-13-2005 07:26 PM

Jacko, it works fine with all flavors of vB 3.0.x -- Did you install any modifications to CMPS or is that a stock install? If you want you can always submit a support ticket over at vbadvanced.com to have somebody take a look at it for you.

The Piper 04-14-2005 12:55 PM

I've searched all around this thread and on the vbadvanced.com forums, and I've seen a lot of users requesting a random thread module, in which a random thread would be picked from a specific forum and shown in the main page (or any other VBCMS page, for that effect), although no solution has shown up.

I (and certainly other people) would really appreciate any feedback on this, please.

USAMustangs.com 04-06-2007 05:55 AM

how do you keep a particular forum from showing up on the home page new threads?

my private admin forum is showing up in new post on home page?

how do you keep them from appearing in new posts/recent threads on vbadvanced portal?

magamaga1 10-19-2007 03:22 AM

will this mod work with 3.6.7 ?

KW802 10-19-2007 03:36 AM

Quote:

Originally Posted by magamaga1 (Post 1363504)
will this mod work with 3.6.7 ?

No. vBadvanced Homepage has long ago been updated to vBadvanced CMPS. For vB 3.6.x you can find it here.

puregraf 10-19-2007 07:50 PM

so why is this not supported anymore?

KW802 10-19-2007 09:40 PM

Quote:

Originally Posted by puregraf (Post 1363911)
so why is this not supported anymore?

Because it's several years old and has been replaced with vBadvanced CMPS?

sdavis2702 05-03-2008 06:49 AM

:) I love this!

akame 05-08-2008 02:22 PM

Dear Tigga,

I downloaded and followed all of your instructions. I have a problem. The includes/functions.php file does not contain this:

if (THIS_SCRIPT == 'online' OR THIS_SCRIPT == 'calendar' OR (THIS_SCRIPT == 'index' AND $vboptions['showevents']))

I am on VB 3.7.

Akame


All times are GMT. The time now is 12:10 AM.

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.01953 seconds
  • Memory Usage 1,740KB
  • 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
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (3)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