vBaCMPS Latest Geek Articles

[The Geek]

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 (https://vborg.vbsupport.ru/showthread.php?t=72825).

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 (https://vborg.vbsupport.ru/showthread.php?t=73836) one too.

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

nJoy

[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?

[TTG]

Easy install, no problems .. thanks for the hack

Clicked Install

[The Geek]

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]

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]

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]

Holy crap that was fast! THANK YOU

[rlamego]

Thanks again! =)

[bold]

help i get this error.


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]

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

[bold]

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

i have 33,34,35

[bold]

i have 33,34,35
oh actually it was because i excluded 33,34,35 in the misc options so that it doesn't show up on the latest threads. is there a way i can only make the articles show up in the latest articles block and not in the latest threads block?

[The Geek]

the misc options so that it doesn't show up on the latest threads. is there a way i can only make the articles show up in the latest articles block and not in the latest threads block?

hmmm... edit your latestgeekarticles.php module and remove $iforumperms in line 101 and let me know if that sorts it.

[bold]

nope didnt work. i get teh same error.

[The Geek]

show up on the latest threads. is there a way i can only make the articles show up in the latest articles block and not in the latest threads block?
can you PM me temporary FTP and Admin details so I can have a look?

[frage]

Originally Posted by bold
the misc options so that it doesn't show up on the latest threads. is there a way i can only make the articles show up in the latest articles block and not in the latest threads block?
yepp I have the same prob,
but nevertheless
I love your humour and your good work
frage

[yinyang]

nailgeek - you never cease to make me chuckle in your install instructions. gg.

i have a quick question for you. i plan on making one of my article forums a designated "Download" section.

i would then like to adapt the latest articles module and turn it into an additional "latest downloads" module.

is there any way to a) do this easily and b) are you planning on coming out with a "hottest articles" so i (i meaning you hopefully ... :P ) can adapt it to a "hottest download" module?

good stuff!!

[The Geek]

yepp I have the same prob,
but nevertheless
I love your humour and your good work
frage
Updated package and fixed the bug when using exluded forum id's. It now works with them.

Yinyang-> There is no reason installs and readmes should be drab eh? ;)
I wouldnt see a problem with changing the phrase 'latest articles' to 'latest downloads' if that is all you are after. Just search your phrases for geek_articles_latest or were you after some other type of modification?

The 'Most popular' or 'Hotest Articles' would be a cinch. Would you guys prefer it as a seperate module or a configuration for Latest Articles? I think most would like it as a seperate module is my guess.

nJoy. Hope that update sorts the woes you guys had.

[frage]

nope..
ok mysql says: no prob for me,
and I would like to see the table for the latest article,
but no article ...
and yes: everybody could see this latest articles...

*a cup of coffee for the nail geek *
;)
frage

[The Geek]

Hi frage.

So you are saying that you are no longer getting a mysql error, but no 'Recent Articles' is showing up?

If so, give me the following settings:

Latest Geek Articles
Article forum id's
Maximum number of articles to show

Miscellaneous Options
Excluded Forums

Then, could you turn on Add Template Name in HTML Comments and give me a link to the homepage? And I will look into it for you.

[frage]

please have a look to your pm

thanks a lot for your help
frage

[frage]

you made may day!
:up:
thanks a lot
frage

[The Geek]

you made may day!
:up:
thanks a lot
frage
No problem Frage. Thanks for helping me make the hack better ;)

[yinyang]

Updated package and fixed the bug when using exluded forum id's. It now works with them.

Yinyang-> There is no reason installs and readmes should be drab eh? ;)
I wouldnt see a problem with changing the phrase 'latest articles' to 'latest downloads' if that is all you are after. Just search your phrases for geek_articles_latest or were you after some other type of modification?

The 'Most popular' or 'Hotest Articles' would be a cinch. Would you guys prefer it as a seperate module or a configuration for Latest Articles? I think most would like it as a seperate module is my guess.

nJoy. Hope that update sorts the woes you guys had.

you're absolutely correct!!! installs and readmes should learn a thing or two from you!! but then you won't be so unique.

i want to install and latest articles and latest downloads. so then i can just 1) install latest articles and then take another copy of latest articles and 2) replace everywere it says "articles" with "downloads" (including the file name ) and upload. that should work right?

ooh ooh meee..... Most Popular (i like that term better) articles as a separate module!!!! please.

-yinyang

[bold]

No problem Frage. Thanks for helping me make the hack better ;)
thanks for fixing it :)

[The Geek]

you're absolutely correct!!! installs and readmes should learn a thing or two from you!! but then you won't be so unique.

i want to install and latest articles and latest downloads. so then i can just 1) install latest articles and then take another copy of latest articles and 2) replace everywere it says "articles" with "downloads" (including the file name ) and upload. that should work right?

ooh ooh meee..... Most Popular (i like that term better) articles as a separate module!!!! please.

-yinyang
I think its going to be a bit harder than that.
Look... I felt bad so I just ran a quick 'Replace' on the install and module file. You can try those two (they install the same as Latest Articles)... Just remember that they are not something I support (I Am away for a week anyway so you're on your own ;) ).

Anyhoo... it should at least help get you started (if not do it for you!)

nJoy

[MissKalunji]

do you know how i can transform this hack to use it to show article on a non vb page?? i dont have vbapms and dont want to...
Lemme know

[The Geek]

do you know how i can transform this hack to use it to show article on a non vb page?? i dont have vbapms and dont want to...
Lemme know
Hi there, I will take a look at it when I get back in town... It really shouldnt be too difficult to do :)

[MissKalunji]

Hi there, I will take a look at it when I get back in town... It really shouldnt be too difficult to do :)


:up: thank youuuuuuuuuuuu :classic:

[mekro]

Hi

I would like to use this but for a different way i will be using the geek article system for a yugioh site and it will be used for a Card of the Day feature.

In each card of the day is a picture of the card and I was wondering if instead of showing the latest article on the homepage would it be poccible just to show the image of it.

Anyhelp

Kirk

[The Geek]

Hi

I would like to use this but for a different way i will be using the geek article system for a yugioh site and it will be used for a Card of the Day feature.

In each card of the day is a picture of the card and I was wondering if instead of showing the latest article on the homepage would it be poccible just to show the image of it.

Anyhelp

Kirk
I wouldnt think that it would be overly difficult to do - however the code would need to pull the attachment (if that was how you were doing the picture).

If its only an image and not an article per say - maybe a photopost or vba gallery featured pic would suit your needs better?

[msimplay]

Any Chance of this for Vbadvanced the original version ?

[The Geek]

Any Chance of this for Vbadvanced the original version ?
Hey there msimplay. Most likely not as I only use vbacmps. Couple that with the fact that there have been 11 installs in 2 months doesnt get me overly excited to do so. I would rather work on Geek Articles 3.0

That said... the module is very straight forward and could most likely be proted to anything you want with just a little investegatory work.

Let me know how you do if you decide to.

[nathanaus]

Do you know if this runs on vbaCMPS 1.0.1?

In the instructions for this it says to find:


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

I don't seem to have that anywhere in my vba_cmps_include_bottom.php file.
As such where do I add "unset($fperms);" to now?

[KTBleeding]

Hmm. I can't get this to work. :(
I've tried everything I can think of.. It's active on all pages, every usergroup is set to view it, but it doesn't come up.

Do I have the settings incorrect?

[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

*edit to add* what version of VBACMPS do you have? I can't find some of the code mentioned that needs to be changed, but it doesn't look like this mod is supported anymore

[KTBleeding]

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

*edit to add* what version of VBACMPS do you have? I can't find some of the code mentioned that needs to be changed, but it doesn't look like this mod is supported anymore
Nope, still doesn't work with that done. Thanks though.

I'm using 1.0.0 which is very strange cause I downloaded it from vbadvanced.com two days ago. :ermm:

Try searching for:
// $header replacement

The code should be RIGHT above that.

[nathanaus]

Nope no match. Thanks anyway. I'm using 1.0.1

Also I noticed you are including files and templates. Can that be done? I thought you had to have a file or a template?

[KTBleeding]

Weird? Is the closing php tag in your "vba_cmps_include_bottom.php" file? (The ?> at the very bottom of the page)

I just downloaded 1.0.1 and I see it in there.. Maybe it's possible the whole file isn't completed?

[Jason McConnell]

Nope no match. Thanks anyway. I'm using 1.0.1

Also I noticed you are including files and templates. Can that be done? I thought you had to have a file or a template?
It can be done with both, sometimes wit both a file and multiple templates. Take a look at the calendar module ;)

[The Geek]

Do you know if this runs on vbaCMPS 1.0.1?

In the instructions for this it says to find:


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

I don't seem to have that anywhere in my vba_cmps_include_bottom.php file.
As such where do I add "unset($fperms);" to now?
Looks like that was removed in 1.0.1

Do the replace in that step, but dont put the unset($fperms); anywhere.
BTW: Your templates need to be prefixed.

PS - please click install if you have installed this mod ;)

[nathanaus]

Looks like that was removed in 1.0.1

Do the replace in that step, but dont put the unset($fperms); anywhere.
BTW: Your templates need to be prefixed.

PS - please click install if you have installed this mod ;)
Thanks, did that and it works perfectly. Good job :)

Clicked install too :)

[KTBleeding]

How are you guys getting it to work? haha

Hmm. I can't get this to work. :(
I've tried everything I can think of.. It's active on all pages, every usergroup is set to view it, but it doesn't come up.

Do I have the settings incorrect?

[nathanaus]

How are you guys getting it to work? haha
When I created the page I didn't use the templates just the file.

See attached.

I think because you specified the file you don't need to specify the templates used. Could be wrong though.

[KTBleeding]

Hmm, very strange.

I know it's set on for all my pages, and the module itself is active.
IF I deactivate the article module, then the module below it changes color from "alt1" to "alt2".. so I guess it's reading something there? :/

[nathanaus]

Hmm, very strange.

I know it's set on for all my pages, and the module itself is active.
IF I deactivate the article module, then the module below it changes color from "alt1" to "alt2".. so I guess it's reading something there? :/
Have you written an article and specified which forum number to use to pull articles from?

[KTBleeding]

Yes, I have several article contents added. :)

I figured out the problem though. I'm an idiot and either didn't see this part in the readme, or skimmed through it.. but I didn't notice the Geek settings under the vBA CMPS general settings.

Got it all sorted though, thanks for the help.

[KTBleeding]

Is there a way to make it so when an article gets a comment, it's not brought to the top of the "latest article" module?

[KTBleeding]

Is there a way to make it so when an article gets a comment, it's not brought to the top of the "latest article" module?Pumb. :dead:

[The Geek]

Pumb. :dead:
Have you tried changing the Sort from the last comment made? setting?

[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]

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]

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]

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?

[KTBleeding]

When using GAS 3.51, I can not get certain settings to show up. Like the article icon does not show up. I also experienced the settings not saving in the AdminCP once or twice before they finally did save.

Just bringing it to your attention Geek. Thanks for all the help thus far.

EDIT: Nevermind all of the above, I JUST noticed that the "icon" means the Post Icons rather than the actual Article Icon itself. But I still did get the settings not saving thing.

Is there a way to include the Article Icon as well?

[The Geek]

When using GAS 3.51, I can not get certain settings to show up. Like the article icon does not show up. I also experienced the settings not saving in the AdminCP once or twice before they finally did save.

Just bringing it to your attention Geek. Thanks for all the help thus far.

EDIT: Nevermind all of the above, I JUST noticed that the "icon" means the Post Icons rather than the actual Article Icon itself. But I still did get the settings not saving thing.

Is there a way to include the Article Icon as well?
This hasnt been reworked for 3.0 (its designed for 2.0)

It will work - just not with the 3.0 extras (like header images etc...).

[aloha]

Okay hmmm... This is my error...

Warning: move_uploaded_file(/var/www/html/gas/images/1/4/0/ban2.jpg): failed to open stream: No such file or directory in /includes/functions_geekarticles_images.php on line 104

Warning: move_uploaded_file(): Unable to move '/tmp/phpNLcbdQ' to '/var/www/html/gas/images/1/4/0/ban2.jpg' in /includes/functions_geekarticles_images.php on line 104

If I could get some assistance... lol :: waves @ geek :: Thanks for the kick *** scripts :rolleyes: :nervous:

[FightRice.com]

:nervous:

[wattieuk]

Can anyone tell me how to rename the module (as it appears on the website). I cannot find a template to edit and can't find it in the php file.
Thanks.

[COBRAws]

This hasnt been reworked for 3.0 (its designed for 2.0)

It will work - just not with the 3.0 extras (like header images etc...).
are u willing to? apart from only 51 installs hehe

* COBRAws begs :P

[Benumbed]

Doest seem to work with the lastest vBadvanced CMPS v2.x

[Aeolian_X]

Is there an update coming for the latest vBAdvanced CMPS?

[yoyoyoyo]

this would be great for my new site- I hope that an update happens soon, but if it means other new geek-innovations being put to the backburner I can wait :D

[The Geek]

Im up to my eyeballs in several open projects and doubt ill get around to this for awhile. Personally I just wish someone would take the mack over as I know many would love this.

[InsaneContender]

I would love to be able to show either random articles, or latest articles on a sidebar all over my site. But it's not the vBCMPS sidebar, it is just a regular sidebar.

Is there a way to go about doing this?

[altsounds]

How can I get the article images to show?? I really need to know how to do this for both this and the featured articles add ons. Both great addons but make no sense without the ability to show the article image.

Can someone who is a better coder than me help me with this?? I have been trying for days now and am stumped and get nothing but red x's. :(

[|Jordan|]

I followed all the file edits and used the install script, but the settings do not show up in default settings. I looked in mysql and they are all there though.

[master85]

hi guys,
I've installed this Hack, but when I go to "Default Settings", I don't view anything else about Article setttings...

In which section I must search: Thread, News Archive, etc ???

Help me, please :(

Thanks,
Giuseppe Leone

P.S.
My system: vBulletin 3.09 -> vBA CMPS 2.0 -> GAS 3.53

[trinigamers]

is there one for 3.5?