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)

[dizzy100]

Great, really looking forward to it as i can't use it till that addition as my news is just too big But i'll keep an eye open as i loved the hack and it worked very well apart from the small issues with path i had.

Thanks thincom2000, look forward to the update. I'll mark as installed so i catch it when its done

[Chadi]

Originally Posted by thincom2000

AdminCP -> Styles & Templates -> Style Manager -> All Style Options -> Sizes and Dimensions -> Main Table Width.

If this is a value larger than you might have specified maybe in the showthread template or something, that's what's causing your problem. I know whenever I change the layout of my site and then nothing matches in width anymore, Main Table Width is usually the culprit.

I never changed the layout settings ever on this style actually.

If your not 100% sure how to correct this (I'm 100% confident it is the hack settings, but I'm not blaming you lol) perhaps you can explain how to remove the comments area (box and button). I don't mind leaving the option off.

[thincom2000]

It's your current value for Spacer Size. Your value of 15 is compressing the first post table by 15 on each side. I would recommend either setting Spacer Size to 0, or if that makes your forum look horrid, could you post the 10 lines above and below $firstbit in your SHOWNEWS template?

Then I'll try to figure out how to rearrange $spacer_open and $spacer_close for your case, since I am using a modified version of the template.

[Chadi]

Thanks for your reply. I'd rather not modify the style's layout and everything looks fine except the comments area in this hack. I love the hack and wish to resolve this with your good support

This is the the portion of the unmodified shownews template

<if condition="$vboptions['allowthreadedmode']">
			<td class="vbmenu_control" id="displaymodes" nowrap="nowrap">
				<a href="$show[nojs_link]#goto_displaymodes">$vbphrase[display_modes]</a>
				<if condition="$show['popups']">
					<script type="text/javascript"> vbmenu_register("displaymodes"); </script>
				</if>
			</td>
		</if>
	</tr>
</table>
<!-- / toolbar -->

<!-- end content table -->
$spacer_close
<!-- / end content table -->

<if condition="$show['reputation']">
	<script type="text/javascript" src="clientscript/vbulletin_ajax_reputation.js?v=$vboptions[simpleversion]"></script>
</if>

$firstbit

$similararticles

<div id="posts"><if condition="$postbits == ''">$news_comments<else />$postbits</if><br />

<div id="lastpost"></div></div>

<!-- start content table -->
$spacer_open
<!-- / start content table -->

<!-- controls below postbits -->
<table cellpadding="0" cellspacing="0" border="0" width="100%">
	<tr valign="top">
		<if condition="$show['largereplybutton']">
			<td class="smallfont"><a href="newreply.php?$session[sessionurl]do=newreply&amp;noquote=1&amp;p=$LASTPOSTID" rel="nofollow"><if condition="$show['closethread']"><img src="$stylevar[imgdir_button]/reply.gif" alt="$vbphrase[reply]" border="0" /><else /><img src="$stylevar[imgdir_button]/threadclosed.gif" alt="$vbphrase[closed_article]" border="0" /></if></a></td>
		<else />

[Chadi]

Just noticed something today:

When viewing the news submission (main news page) it does not show the inline thumbnail attachments unless you view each specific news thread. Is there a possible way to get them to show on the main page?

[thincom2000]

Just updated v1.1.0 with the attachments fix. You'll notice in the Changelog that I also included all the other things that have been suggested in the past week or so (or more). If you downloaded v1.1.0 already you only need to replace the updated news.php file.

[Chadi]

Ok, this is happening again. I've just upgraded and its conflicting with RSS Newsfeed hack (remember a few weeks ago I mentioned the conflicting same filenames).

Before upgrading, I changed news.php to newsces.php
shownews.php to shownewsces.php

I edited each file to find any area that shows news.php or shownews.php and added the 'ces' to each.

Now, I am getting directed to the RSS feeds page instead again. Did I miss something else?

I searched all templates for news.php (which would bring up shownews.php by default too)
and found nothing aside the rss feeds link, which is properly news.php

[thincom2000]

There is a new setting in the AdminCP for when you rename the files.

[Chadi]

Thank you. Now getting database errors :P

Database error in vBulletin 3.6.5:

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,
            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(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
            
            , attach.info_hash, attach.size, attach.comment, attach.created_by, attach.announce_list, attach.completed_by,
            attach.completed, attach.seeders, attach.leechers, attach.ulspeed, attach.dlspeed, 
            attach.dateline AS attachdate, attach.thumbnail_dateline, attach.filename, attach.filesize, 
            attach.visible AS attachvisible, attach.attachmentid, attach.counter,
            IF(attach.thumbnail_filesize > 0, 1, 0) AS hasthumbnail, attach.thumbnail_filesize,
            attachmenttype.thumbnail AS build_thumbnail, attachmenttype.newwindow
            , 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 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 = 19 AND postparsed.languageid = 1)
        LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 19 AND sigparsed.languageid = 1)
        LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid)
        LEFT JOIN attachment AS attach ON(attach.postid = post.postid)
        LEFT JOIN attachmenttype AS attachmenttype USING (extension)
             LEFT JOIN journals AS journals ON (journals.journalist_id=post.userid)
        WHERE post.postid IN (0,71157,71157)
        ORDER BY post.dateline;

MySQL Error  : Unknown column 'attach.info_hash' in 'field list'
Error Number : 1054
Date         : Monday, March 12th 2007 @ 05:40:41 PM
Script       : http://www.talkjesus.com/shownewsces.php?t=12192
Referrer     : http://www.talkjesus.com/
IP Address   : xxx.xxx.149.108
Username     : Chad
Classname    : vb_database

[thincom2000]

Haha, whoops. That's my shownews. Product version has been added to the zip instead (I hope). Sorry about that.