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

[tormodg]

It seems there are some bugs in this thingy too. The post date is shown as well as the last date for the comment made. There seems to be no option to remove this except edit the template.

Also, the option to show views/comments is not conditioned in the modul so it is displayed by default. Could be a good idea to remove this (I hardly have any comments on my articles, people just read and go post something intelligent elsewhere in the forums). I just commented that bit out in the module.

I think I have installed almost everything by you now. So now I can take one of those vBa Links Directory popup things, thank you. That would be a killer.

[venomx]

Originally Posted by nathanaus

Take adv_portal_ off the front of you templates being used list and re-save.

So instead of:
adv_portal_latestgeekarticles
adv_portal_latestgeekarticlebits

You would have:
latestgeekarticles
latestgeekarticlebits

This bit of info needs added to the install file...

[The Geek]

Originally Posted by venomx

This bit of info needs added to the install file...

its not in there as it isnt correct as far as I know the vbacmps templates need the adv_portal_ prefix

[mekro]

Hi

Just wondering if this is possible with your hack and that is, i use your article system to run a card of the day system.

I would like to have the latest new card of the day thread (not new replies) including the attachment of the card which is uploaded with it shown on my vbadvanced homepage.

Is this possible.

Thanks
Kirk

[The Geek]

Originally Posted by mekro

Hi

Just wondering if this is possible with your hack and that is, i use your article system to run a card of the day system.

I would like to have the latest new card of the day thread (not new replies) including the attachment of the card which is uploaded with it shown on my vbadvanced homepage.

Is this possible.

Thanks
Kirk

If I understand you correctly - you are wanting to show the latest attachment thumbnail from specific forums?

Sounds like a cool idea - but no this wouldnt work for you. Sorry

[Rich]

Hello,
When creating new module templates, they need to be written like this:

adv_portal_TEMPLATE NAME

However, when you are adding the module to the pages, it is not entered with the prefix. All you enter for the template name on the "add module" page is the template name. So where it asks for template name, you only enter: TEMPLATE NAME

If you add the prefix in the add module section, it will not work!

[intrigue]

any reason why it shows the last 3 posts rather then articles?
.matt

[The Geek]

not sure what you mean matt - are you sure you have the correct forumids in?

[Lizard King]

if ($shownewpm)
{
eval('$pmscript = "' . fetch_template('pm_popup_script') . '";');
$footer .= str_replace('"private.php', '"' . $vboptions['bburl'] . '/private.php', $pmscript);
}

This part cannot be completed in cmps 1.0.1 because in vba_cmps_include_bottom.php you cannot find this. Is it possible to get this working in any other way ?

[joerns]

Hi there,

thanks for this excellent hack. I installed it following the instructions, and the hack does display the latest articles on the portal page. But every so often, I get the following error:

Database error in vBulletin 3.0.6:

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.forumid, forum.title AS forumtitle
, post.pagetext AS preview

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')

WHERE open <> '10' AND thread.visible = 1 Array AND deletionlog.primaryid IS NULL
ORDER BY thread.dateline DESC
LIMIT 4

mysql error: You have an error in your SQL syntax near 'Array AND deletionlog.primaryid IS NULL
ORDER BY thread.dateline DESC
LI' at line 14

mysql error number: 1064

What could the problem be?