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)
-   -   vBaCMPS Latest Geek Articles (https://vborg.vbsupport.ru/showthread.php?t=73828)

The Geek 01-04-2005 10:00 PM

vBaCMPS Latest Geek Articles
 
Hack: vBadvanced CMPS Latest Geek Articles
Version: 1.0
Author: Me

Instructions:
upload modules/latestgeekarticles.php into modules folder
upload admincp/latestgeekarticles_install.php into admincp folder
run above file
Follow the slight file modifications in the README.

File modifications: 1
Template modifications: 0
Installer: Yup. A very cool one.
Phrased: Yup

In a nutshell, this module is based upon the vBa Latest Topics module, but is instead set up to pull the 'Latest articles' from a specified forum. This is really designed for those using The Geek Article System.

Check out the Readme that comes in the package.

Change Log
version 1.3 uploaded 02/02/05
Minor update to module in order to work with new vBaCMPS release

version 1.2 uploaded 07/01/05
Fixed 'Excluded Forums' bug that appeared to have been bitten by Zombie.
It came back to haunt one user so I had to take drastic action and update it.
It now WORKS with your 'excluded forums' setting. That is to say, you can exclude your acticle forums from 'Latest topics' but they will still happily appear in Latest Articles.
Please note that this means there is now a file edit. Please read the README.

version 1.1 uploaded 07/01/05
Fixed bug where when users had vba excluded forums set, it caused a query error. To fix, download latest package and upload latest modules/latestgeektopics.php overwriting your old one.


note:if you dig this module, you may be interested in the Featured/Random Articles one too.

PS: Your template will be a tad different from my screen shot as this is for my style.

nJoy

TCB 01-05-2005 03:24 PM

Yeah baby, I like. Thanks a lot https://vborg.vbsupport.ru/external/2005/01/7.gif

Just one of the things that I miss by not having v3 articles is the 'featured article'. Perhaps this can be replaced by a 'random article' block that uses the first x characters of the post?

TTG 01-05-2005 03:48 PM

Easy install, no problems .. thanks for the hack

Clicked Install

The Geek 01-05-2005 04:21 PM

Quote:

Originally Posted by TCB
Yeah baby, I like. Thanks a lot https://vborg.vbsupport.ru/external/2005/01/7.gif

Just one of the things that I miss by not having v3 articles is the 'featured article'. Perhaps this can be replaced by a 'random article' block that uses the first x characters of the post?

Actually, it most liekly wouldnt be difficult to add a featured article module. It would require you to set the threadid in your vbacmps settings though. So in other words, every time you changed the feautred article, it would through vbacmps.

Does that sound pants or would you be interested in it?

fly 01-05-2005 06:03 PM

Quote:

Originally Posted by the nail geek
Actually, it most liekly wouldnt be difficult to add a featured article module. It would require you to set the threadid in your vbacmps settings though. So in other words, every time you changed the feautred article, it would through vbacmps.

Does that sound pants or would you be interested in it?

Please? Please? Please?

*biting fignernails*

The Geek 01-05-2005 07:10 PM

Quote:

Originally Posted by flypaper
Please? Please? Please?

*biting fignernails*

Done guys :)

I have released a Featured/Random Articles module here->
https://vborg.vbsupport.ru/showthread.php?t=73836

fly 01-05-2005 07:27 PM

Holy crap that was fast! THANK YOU

rlamego 01-06-2005 02:48 AM

Thanks again! =)

bold 01-06-2005 03:07 AM

help i get this error.

Code:

Database error in vBulletin 3.0.3:

Invalid SQL:
                  SELECT
                  IF(votenum >= 1, votenum, 0) AS votenum, IF(votenum >= 1 AND votenum != 0, votetotal / votenum, 0) AS voteavg,
                  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, iconpath AS threadiconpath
                        ,thread.forumid, forum.title AS forumtitle
                       
                        , NOT ISNULL(subscribethread.subscribethreadid) AS subscribed
                        FROM vb3_thread as thread
                        LEFT JOIN vb3_icon USING (iconid)
                        LEFT JOIN vb3_forum AS forum ON (thread.forumid = forum.forumid)
                       
                        LEFT JOIN vb3_deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
                        LEFT JOIN vb3_subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = 1)
                        WHERE open <> '10' AND thread.visible = 1 AND thread.forumid NOT IN(6,27,33,34,35) Array 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 'Array AND deletionlog.primaryid IS NULL
                        ORDER BY lastpost DE

mysql error number: 1064


The Geek 01-06-2005 06:04 AM

What do you have in your settings as your forum ids?


All times are GMT. The time now is 10:59 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.01037 seconds
  • Memory Usage 1,749KB
  • 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
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (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