Add-On Releases - CES Site News

CES Site News
Version: 1.6.3
vBulletin 3.7.x, 3.8.x supported

*** NEWS ***
5/15/2008 - v1.6.3 released
5/5/2008 - v1.6.2 released
5/2/2008 - v1.6.1 released
4/17/2008 - v1.6.0 released
11/7/2007 - v1.5.1 released
9/9/2007 - v1.5.0 released
4/12/2007 - v1.4.1 released
4/5/2007 - v1.4.0 released
4/1/2007 - 4/2/2007 - v1.3.1 through v1.3.2 released
3/30/2007 - v1.3.0 released
3/23/2007 - 3/26/2007 - v1.2.0 through v1.2.4 released
3/14/2007 - v1.1.1 released
3/12/2007 - v1.1.0 released
2/9/2007 - v1.0.8 released
1/29/2007 - v1.0.7 released
1/23/2007 - 1/27/2007 - v1.0.0 through v1.0.6 released

Known Issues:
- none

What It Does:
This allows you to turn one of your forums into a news blog.

Live Installation: http://www.crackedeggstudios.com/news.php
This site is usually an update or two ahead of what's available in this thread, because that's where we do all our testing.

Products to Install: 1
Plugins Included: 14
Files to Upload: 7
Files to Edit: 0
New Templates: 8
Template Edits: 0

Mod Features:
- adds options to the Forum Manager
- uses forum permissions
- threads in the given forum become articles
- pull articles from other forums
- full-text articles are displayed in a customized forumdisplay
- post replies are added as comments
- set number of articles and comments per page
- turn on/off announcements in news display
- turn on/off attachments in news display
- turn on/off last comment in news display
- ajax quick edit in news display (basically, quick edit in forum display)
- display articles on every comments page
- limit size of article preview
- additional BB-Code tags for articles

BB-Code Tags:
[previewlength]value[/previewlength]
Placing this anywhere in an article overrides the preview limit for that article only. Multiple [previewlength] tags are cumulative. A "Read More..." link will appear if this tag is used.

[preview]value[/preview]
Placing this anywhere in an article defines text that will only show on Newsdisplay. Text contained in this tag completely replaces the post text on Newsdisplay. Multiple [preview] tags are cumulative. A "Read More..." link will appear if this tag is used.

[more]value[/more]
Placing this anywhere in an article defines text that will only show on Shownews. Text contained in this tag does not replace the post text on Shownews. It only hides text from Newsdisplay.

*** Changelog ***
As of Version 1.6.3:
- bug fix: preview functions do nothing since alias support added
- bug fix: preview functions never worked on editpost or newthread
- bug fix: inconsistent postbit after quick edit
- updated files: news.php, shownews.php, ces_news_bbcode.php,
ces_news_quick_edit.js

As of Version 1.6.2:
- bug fix: more database errors in vB 3.6.x
- bug fix: post controls hide on news display in IE7
- bug fix: threadbit and postbit widths inconsistent
- updated templates: ces_news_postbit, ces_news_threadbit
- updated files: shownews.php

*** Screenshots ***
1. New Forum Manager Option
2. Site News Settings
3. News Articles (forumdisplay)
4. Comments (showthread)

[Chadi]

I also got a few of these email errors this morning:

Database error in vBulletin 3.6.10:

Invalid SQL:

SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
user.*, userfield.*, usertextfield.*,
icon.title as icontitle, icon.iconpath,
avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,


editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
editlog.reason AS edit_reason, editlog.hashistory,
postparsed.pagetext_html, postparsed.hasimages,
sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages,
sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,
IF(user.displaygroupid=0, user.usergroupid, user.displaygroupid) AS displaygroupid, user.infractiongroupid
, '' AS field18
, journals.journaldesc, journals.journal_id
FROM post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)


LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 31 AND postparsed.languageid = 1)
LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 31 AND sigparsed.languageid = 1)
LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid)
LEFT JOIN journals AS journals ON (journals.journalist_id=post.userid)
WHERE post.postid IN (0,67504)
ORDER BY post.dateline;

MySQL Error : Unknown column 'editlog.hashistory' in 'field list'
Error Number : 1054
Date : Friday, May 2nd 2008 @ 07:09:17 AM
Script : http://www.talkjesus.com/shownewsces.php?t=11346
Referrer :
IP Address : 66.249.70.172
Username : Unregistered
Classname : vB_Database

[thincom2000]

Well hopefully this bug fix update covers all the backwards compatibility issues...

[Chadi]

Please see attached, it did not work.

[blastup]

hey i got an idea.. could you make news.php default to a news section? like newsdisplay.php?f=1 but you could just go to newsdisplay.php then it will appear! just by default! then it should also work if it is newsdisplay.php?f=2 or newsdisplay.php?f=3 !!! let me know thanks because i feel that using vbseo to put the file up in the homepage is a bad idea! it will be better if there is something at the index..

let me know thanks

also it seems like there is still bugs mentioned from a few people! let me know if its bug free again thanks

again awesome hack

[blastup]

i still have no idea on how to make the urls convert in vbseo! i am thinking of the best way is to use newsdisplay.php only and not shownews.php i think i am going to just going to make newsdisplay.php direct to the real thread! that way you can preserve the urls and have url free conflicts! I think im going to use if conditions to define the showpost.php so it will look like newsdisplays template on certain forum ids.

do you think this is a good idea? do you think this will be hard to do?

[blastup]

vbulletin.org did the same thing for the mods and styles section so i think it might just work!

[thincom2000]

Originally Posted by blastup

hey i got an idea.. could you make news.php default to a news section? like newsdisplay.php?f=1 but you could just go to newsdisplay.php then it will appear! just by default! then it should also work if it is newsdisplay.php?f=2 or newsdisplay.php?f=3 !!! let me know thanks because i feel that using vbseo to put the file up in the homepage is a bad idea! it will be better if there is something at the index..

let me know thanks

also it seems like there is still bugs mentioned from a few people! let me know if its bug free again thanks

again awesome hack

You can accomplish this using .htaccess. Also if you add the do=main to the URL it is slightly different.

For example on my site I have:

RewriteRule ^main.php$ news.php?do=main&f=2 [L,QSA]

This makes forumid 2 display without extra forumdisplay stuff like subforums on the page main.php, which doesn't physically exist.

[thincom2000]

Originally Posted by chadi

Please see attached, it did not work.

Hm... that's surprising. I actually fixed that for the last release, so I'm not sure why I had to do it again. Again, I took the trim() calls out of the product file, so you should just redownload it.

[Chadi]

Thanks, but still a few bugs.

See attached.

In IE7, it buries the bottom part of the post as you can barely see the icons/buttons.

In Firefox and Opera, it shows grey color on the right side for some reason.

[thincom2000]

Ah, I think those are related to the fact that you use postbit_legacy on your forum, and the mod doesn't have legacy versions. I will look into this.