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 even get this error when attempting to post a blog post.

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,
spamlog.postid AS spamlog_postid,
deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,
editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
editlog.reason AS edit_reason,

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

, 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 spamlog AS spamlog ON(spamlog.postid = post.postid)
LEFT JOIN deletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND deletionlog.type = 'post')
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,107494)
ORDER BY post.dateline;

MySQL Error : Table 'admincd_vbulletin.spamlog' doesn't exist
Error Number : 1146
Date : Sunday, May 4th 2008 @ 12:23:01 PM
Script : http://www.talkjesus.com/shownewsces.php?t=20886
Referrer : http://www.talkjesus.com/newthread.p...newthread&f=72
IP Address : xxxxx
Username : Chad
Classname : vB_Database

[thincom2000]

Just curious, did you have 1.6.0 installed before upgrading to 1.6.1? (1.6.0 was released about 3 weeks ago)

[Chadi]

Honestly do not remember what the version was, but it was the latest at the time.

[thincom2000]

I cannot duplicate the gray color template bug you posted above. You mentioned it occurs in Firefox and Opera... Firefox is my main browser and I haven't found a combination of options to create this effect. What versions by chance are you using?

Regarding the IE7 button cutoff, that I have reproduced and am currently working on...

[Chadi]

Was using Firefox 2 (latest) at the time. Also tried in FF 3 Beta 5. Same results.

[thincom2000]

Ah, I see it in FF 3. Okay, well now that all of that is fixed, I'm uploading 1.6.2. Hopefully those were all the quirks...

[Chadi]

Thanks, but still one more issue :x

When I submit a new news post, it redirects me to the home page (yet successfully posting the new thread). However, when your on the home page or inside the CES News area and click on the post title, it redirects back to the home page again.

VBSEO related or not? Thanks again.

[thincom2000]

I would say it's vbSEO, because I have never encountered anything like that. And I just posted a new news item on my live site the other day...

[Chadi]

Problem persists with vbseo disabled too

[thincom2000]

Please check your server error logs and make sure you don't have an error 404 happening. Every time a link is clicked to read shownew.php on your site, it redirects to the forum home page. Make sure that in the options your Shownews Filename is set to "shownew"