Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 3.0 > vBulletin 3.0 Full Releases
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
vBadvanced CMPS - News Digest Module 1.02 Details »»
vBadvanced CMPS - News Digest Module 1.02
Version: 1.0.2, by Michael Morris Michael Morris is offline
Developer Last Online: Jun 2009 Show Printable Version Email this Page

Version: 3.0.3 Rating:
Released: 10-02-2004 Last Update: 10-31-2004 Installs: 15
 
No support by the author.

This header message last editted October 10th.

News Digest for vBadvanced CMPS
vers. 1.0.2

This hack allows your vBadvanced hompage to display news in a digest format. Instead of having each article appear in a box, it will appear as an item in a bulleted list. These lists are sorted by date and then by category. If you're site has more than a couple of news items per day you should find this hack useful, especially if those news items are particularly small by themselves (only a line or two of text).

Live examples:
http://www.enworld.org/forums/index.php (starting below the ad for Dundjinni).

This hack requires that you have vBadvanced CMPS of course. Image support for the categories (as seen on the enworld site) can be accomplished by installing BeerMonster's banner images on forumhome hack. If you don't want to install this other hack, or if you're boards has a different hack that associates images with forums, you'll need to modify the provided newsdigest.php file.

BeerMonster's hack is found here...
https://vborg.vbsupport.ru/showthread.php?t=63994

During the installation of this hack you will create 3 templates. This hack requires no file modifications in and of itself, but some supplemental hacks do require such modifications, and they'll be dealt with in detail shortly. First, the primary hack:

Step 1: Prepare the newsdigest.php file.
Download the attached file and put it in [yourforum]/modules/

Step 1A:
If you don't want to have any forum images for your categories, or don't wish to install the forum banners hack above then open the newsdigest.php file and search for the following code.

Find:
PHP Code:
SELECT thread.threadidpostusernamepostuseridthread.dateline AS postdatelinethread.forumidforum.title as titleforum.fhbanner as iconpost.postidpagetextallowsmilie 
Replace With:
PHP Code:
SELECT thread.threadidpostusernamepostuseridthread.dateline AS postdatelinethread.forumidforum.title as titlepost.postidpagetextallowsmilie 
Advanced Users Note: the only difference between these two blocks is the 2nd lacks the "forum.fhbanner as icon," entry. If you have already installed a hack that creates forum images for use with categories you can change this line to refer to the column you've set. For instance, on enworld the line is "forum.icon as icon,"

Step 2: Create the Templates
Create a new template called adv_portal_newsdigest_date and insert the following into it:

HTML Code:
<if condition="$prevdate"><br /><hr></if>
<table align="center" border="0" cellpadding="0" cellspacing="0" width="100%">
	<tr>
		<td align="center" valign="top" class="tborder">
		<table align="center" border="1" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" width="100%">
			<tr>
				<td align="center" valign="top" class="tcat">
					$datelongform
				</td>
			</tr>
		</table>
		</td>
	</tr>
</table>
<br>
Create a new template called adv_portal_newsdigest_category and insert the following into it.

HTML Code:
<b>$news[title]</b><if condition="$news['icon']"><img src="./images/forumicons/$news[icon]" align="right" height="60" weight="60"></if>
If you don't want category images insert this code instead:

HTML Code:
<b>$news[title]</b>
Create a new template called adv_portal_newsdigest_item and insert the following into it:

HTML Code:
<div align="justify">$news[message] - scoop submitted by $news[postusername]</div>
Step 3: Set up your News Forums
Go to your forum manager and create one news forum for each news category you desire to have on your news page. Also choose their display order at this step by modifying the display orders of the forums themselves. Note their forum #'s

Step 4: Prepare the News Page
Open your vBadvanced CMPS control panel and select "Add Module"

Module Title: News Digest
File to Include: newsdigest.php

Templates to Include: adv_portal_newsdigest_date, adv_portal_newsdigest_category, adv_portal_newsdigest_item

Step 5: Activate the Module
Go to your page settings and turn the original news module off (It's redundant). Enter the forum #'s of each forum you want in any order (the display order of the categories is the same as the forums. Turn the newsdigest module on.

---------------------------------------------------------

FINISHED.

Version History
Version 1.0.0 had several little glitches due to me rushing it out the door in my excitement from creating my first big hack. I'll demonstrate a bit more patience in the future.

Version 1.0.1 (and prior) has a serious month wrap bug.

Version 1.0.2 is current.

If you like this hack please click install - thx.

---------------------------------------------------------

Supplemental Hack: Bump and Debump News
The date of the news is important with this hack. If you find an item displaying on the wrong day then you can use the following tools to scoot it around. Note - this "supplemental" hack is almost exactly like Rigel Kentaurus' "Bump Thread and Make Thread Older" hack, so I'm not going to take any credit for originality. Here is the modified version of his hack for bumping news items around for the digester.

Code:
Code Modifications: 2 in 1 file
Template Modifications: 2 in 1 template
New phrases: 4

###################################################################
# Code modifications in file "postings.php" 
###################################################################

-------------------------------------------------------------------
search for this code:
-------------------------------------------------------------------

	case 'removeredirect':

-------------------------------------------------------------------
change it to:
-------------------------------------------------------------------

	case 'removeredirect':
        
	// Hack: bump and debump
	case 'bumpnews':
	case 'debumpnews':



-------------------------------------------------------------------
search for this code:
-------------------------------------------------------------------



// ############################### start do open / close thread ###############################



-------------------------------------------------------------------
change it to:
-------------------------------------------------------------------



// ############################### start news bump and de-bump ###########################
if ($_REQUEST['do'] == 'bumpnews')
{
	// only mods with the correct permissions should be able to access this
	if (!can_moderate($threadinfo['forumid'], 'caneditthreads'))
	{
		print_no_permission();
	}

	// Bump
	$DB_site->query("UPDATE ".TABLE_PREFIX."thread SET dateline=".TIMENOW." WHERE 

threadid='".$threadinfo['threadid']."'");

	$url = "forumdisplay.php?$session[sessionurl]f=$threadinfo[forumid]";
	eval(print_standard_redirect('redirect_bumpnews'));
}

if ($_REQUEST['do'] == 'debumpnews')
{
	// only mods with the correct permissions should be able to access this
	if (!can_moderate($threadinfo['forumid'], 'caneditthreads'))
	{
		print_no_permission();
	}

	// De-Bump
	$DB_site->query("UPDATE ".TABLE_PREFIX."thread SET dateline=dateline-86400 WHERE 

threadid='".$threadinfo['threadid']."'");

	$url = "forumdisplay.php?$session[sessionurl]f=$threadinfo[forumid]";
	eval(print_standard_redirect('redirect_debumpnews'));
}



###################################################################
# Template modifications in SHOWTHREAD
###################################################################

-------------------------------------------------------------------
search for this:
-------------------------------------------------------------------

<option value="removeredirect">$vbphrase[remove_redirects]</option>

-------------------------------------------------------------------
change it to:
-------------------------------------------------------------------

<option value="removeredirect">$vbphrase[remove_redirects]</option>
<option value="bumpnews">$vbphrase[bumpnews]</option>
<option value="debumpnews">$vbphrase[debumpnews]</option>


-------------------------------------------------------------------
search for this:
-------------------------------------------------------------------

<div><label for="ao_rrd"><input type="radio" name="do" id="ao_rrd" value="removeredirect" />$vbphrase[remove_redirects]</label></div>

-------------------------------------------------------------------
change it to:
-------------------------------------------------------------------

<div><label for="ao_rrd"><input type="radio" name="do" id="ao_rrd" value="removeredirect" />$vbphrase[remove_redirects]</label></div>
<div><label for="ao_bump"><input type="radio" name="do" id="ao_bump" value="bumpnews" />$vbphrase[bumpnews]</label></div>
<div><label for="ao_dbump"><input type="radio" name="do" id="ao_dbump" value="debumpnews" />$vbphrase[debumpnews]</label></div>


###################################################################
# New phrases
###################################################################

Add these four phrases in the admin control panel (Phrase Manager -> Add new Phrase)

Type: Show thread
Name: bumpnews
Text: Bump News

Type: Show thread
Name: debumpnews
Text: Make News older

Type: Front-End Redirect Messages
Name: bumpnews
Text: The News item is now set to today

Type: Front-End Redirect Messages
Name: debumpnews
Text: The News Item is now one day older

Supporters / CoAuthors

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #12  
Old 10-10-2004, 07:26 PM
Michael Morris's Avatar
Michael Morris Michael Morris is offline
 
Join Date: Nov 2003
Location: Knoxville TN
Posts: 774
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by LPH2004
This is gorgeous but how do I only get 2 days worth ... and not a whole HUGE string of days ... ?

I'm installing it on www.whatisnew.com
The last part of the newsdigest.php file is the looks like this.

PHP Code:
if ($vba_options['portal_news_forumid'])
    {
    
$timespan 'thread.dateline>UNIX_TIMESTAMP(CURDATE())';
    
construct_newsdays();
    
$timespan 'thread.dateline<UNIX_TIMESTAMP(CURDATE()) AND thread.dateline>UNIX_TIMESTAMP(CURDATE()-1)';
    
construct_newsdays();
    
$timespan 'thread.dateline<UNIX_TIMESTAMP(CURDATE()-1) AND thread.dateline>UNIX_TIMESTAMP(CURDATE()-2)';
    
construct_newsdays();
    
$timespan 'thread.dateline<UNIX_TIMESTAMP(CURDATE()-2) AND thread.dateline>UNIX_TIMESTAMP(CURDATE()-3)';
    
construct_newsdays();
    
$timespan 'thread.dateline<UNIX_TIMESTAMP(CURDATE()-3) AND thread.dateline>UNIX_TIMESTAMP(CURDATE()-4)';
    
construct_newsdays();
    
$timespan 'thread.dateline<UNIX_TIMESTAMP(CURDATE()-4) AND thread.dateline>UNIX_TIMESTAMP(CURDATE()-5)';
    
construct_newsdays();
    
$timespan 'thread.dateline<UNIX_TIMESTAMP(CURDATE()-5) AND thread.dateline>UNIX_TIMESTAMP(CURDATE()-6)';
    
construct_newsdays();
    
$timespan 'thread.dateline<UNIX_TIMESTAMP(CURDATE()-6) AND thread.dateline>UNIX_TIMESTAMP(CURDATE()-7)';
    
construct_newsdays();
    
$timespan 'thread.dateline<UNIX_TIMESTAMP(CURDATE()-7) AND thread.dateline>UNIX_TIMESTAMP(CURDATE()-8)';
    
construct_newsdays(); 
    } 
The first line checks for any news posts made prior to the current date in case there's a glitch in the timestamp of the news item that puts it in the future it will still display. Each line that follows is one day. So, simply trim it down to the number of desired iterations. Two days would read...

PHP Code:
if ($vba_options['portal_news_forumid'])
    {
    
$timespan 'thread.dateline>UNIX_TIMESTAMP(CURDATE())';
    
construct_newsdays();
    
$timespan 'thread.dateline<UNIX_TIMESTAMP(CURDATE()) AND thread.dateline>UNIX_TIMESTAMP(CURDATE()-1)';
    
construct_newsdays();
    
$timespan 'thread.dateline<UNIX_TIMESTAMP(CURDATE()-1) AND thread.dateline>UNIX_TIMESTAMP(CURDATE()-2)';
    
construct_newsdays();
    } 
I've tried a couple of times now to get this to work as a while loop but so far nothing gets displayed when I try it that way
Reply With Quote
  #13  
Old 10-10-2004, 07:42 PM
LPH2004 LPH2004 is offline
 
Join Date: Feb 2004
Posts: 47
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thank you for the very fast response !

Now, it is starting to take shape by showing just 2 days.

However, it is showing up to 18 stories from the same category. I've looked where to change this to just up to 5 but I'm not sure. The story length cut down to 100 causes some of the stories to have all of the text linked/underlined. I've set it to 200 and stories are all red past a certain point.

Any ideas?
Reply With Quote
  #14  
Old 10-10-2004, 08:06 PM
Michael Morris's Avatar
Michael Morris Michael Morris is offline
 
Join Date: Nov 2003
Location: Knoxville TN
Posts: 774
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by LPH2004
Thank you for the very fast response !

Now, it is starting to take shape by showing just 2 days.

However, it is showing up to 18 stories from the same category. I've looked where to change this to just up to 5 but I'm not sure. The story length cut down to 100 causes some of the stories to have all of the text linked/underlined. I've set it to 200 and stories are all red past a certain point.

Any ideas?
The line limiter is rather dumb, and it won't close tags. What do you want the limit on stories within a category to be?
Reply With Quote
  #15  
Old 10-10-2004, 08:24 PM
LPH2004 LPH2004 is offline
 
Join Date: Feb 2004
Posts: 47
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Michael Morris
The line limiter is rather dumb, and it won't close tags. What do you want the limit on stories within a category to be?
Well, I decided to create Frontpage news forums for the major categories and then will make sure they do not exceed 500. They'll say something like "discuss this here" kinda posts.

I've updated the front of www.whatisnew.com now and am adding more of these "news" forums for each category.
Reply With Quote
  #16  
Old 10-10-2004, 08:29 PM
Michael Morris's Avatar
Michael Morris Michael Morris is offline
 
Join Date: Nov 2003
Location: Knoxville TN
Posts: 774
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by LPH2004
Well, I decided to create Frontpage news forums for the major categories and then will make sure they do not exceed 500. They'll say something like "discuss this here" kinda posts.

I've updated the front of www.whatisnew.com now and am adding more of these "news" forums for each category.
Ok. Well, have fun with it and let me know if anything major crops up. I'm going to be working primarily on a Reviews database extention for vbulletin that allows users to post book reviews and look up product and product line information by publisher -though I'll try to keep if flexiable enough for any kind of reviews application. Part of that hack is translating a home-made program someone else wrote into a format vbulletin can deal with :\

Signing off now, and have a good day.
Reply With Quote
  #17  
Old 10-28-2004, 06:08 AM
Jaxx Jaxx is offline
 
Join Date: Mar 2003
Location: Seattle, Wa
Posts: 102
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks a bunch.

I very pleased with it, you did a great job on it.

Is there any chance of getting some type of mod that would count the replies to a news article and put (# comments) next to it?

*edit*
Now that brings up, how would you moderate the new thread, but not the replies?
Reply With Quote
  #18  
Old 10-28-2004, 07:12 AM
Michael Morris's Avatar
Michael Morris Michael Morris is offline
 
Join Date: Nov 2003
Location: Knoxville TN
Posts: 774
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I think you can set up a forum so that only new threads are moderated and not new posts without performing any hacks.

Anyway, ENWorld runs an archive of news items by using vbulletin's syndicator - it shows the 20 most recent news items for each topic. To add one to go with this system create a new page, turn all modules off on that page and point it's custom content at a new template (I used adv_portal_headlines)

The content for us is...

HTML Code:
<table width="100%" border="0" cellspacing="0" cellpadding="0"><tr><td class="tborder">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
    <tr><td class="tcat" align="center">Headline Summary Page</td></tr>
</table></td></tr></table>
<br />
<table width="100%" border="0" cellspacing="0" cellpadding="0">
	<tr>
		<td width="33%" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"><tr><td class="tborder">
			<table width="100%" border="0" cellspacing="2" cellpadding="1">
				<tr><td align="center" class="thead">Site News</td></tr>
          <script type="text/javascript" src="http://www.enworld.org/forums/external.php?forumids=162&type=js"></script>
          <script type="text/javascript">
<!--
var max = 10;
if(threads.length < max) max = threads.length;
for(i = 0; i < max; i++)
{ 
if (threads[i].title.length > 45)
{ threads[i].title = threads[i].title.substring(0, 45) + '...'; }
document.writeln("<tr><td class=\"alt2\"><a href=\"http://www.enworld.org/forums/showthread.php?t=" + threads[i].threadid + "\">" + threads[i].title + "</a></td></tr>");
}
//-->
</script>
			</table>
			<table width="100%" border="0" cellspacing="2" cellpadding="1">
				<tr><td align="center" class="thead">Software</td></tr>
          <script type="text/javascript" src="http://www.enworld.org/forums/external.php?forumids=179&type=js"></script>
          <script type="text/javascript">
<!--
var max = 10;
if(threads.length < max) max = threads.length;
for(i = 0; i < max; i++)
{ 
if (threads[i].title.length > 45)
{ threads[i].title = threads[i].title.substring(0, 45) + '...'; }
document.writeln("<tr><td class=\"alt2\"><a href=\"http://www.enworld.org/forums/showthread.php?t=" + threads[i].threadid + "\">" + threads[i].title + "</a></td></tr>");
}
//-->
</script>
			</table>
			<table width="100%" border="0" cellspacing="2" cellpadding="1">
				<tr><td align="center" class="thead">Community</td></tr>			
          <script type="text/javascript" src="http://www.enworld.org/forums/external.php?forumids=178&type=js"></script>
          <script type="text/javascript">
<!--
var max = 10;
if(threads.length < max) max = threads.length;
for(i = 0; i < max; i++)
{ 
if (threads[i].title.length > 45)
{ threads[i].title = threads[i].title.substring(0, 45) + '...'; }
document.writeln("<tr><td class=\"alt2\"><a href=\"http://www.enworld.org/forums/showthread.php?t=" + threads[i].threadid + "\">" + threads[i].title + "</a></td></tr>");
}
//-->
</script>
			</table>	
		</td></tr></table></td>
		<td width="34%" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"><tr><td class="tborder">
			<table width="100%" border="0" cellspacing="2" cellpadding="1">
				<tr><td align="center" class="thead">Official WotC</td></tr>
          <script type="text/javascript" src="http://www.enworld.org/forums/external.php?forumids=164&type=js"></script>
          <script type="text/javascript">
<!--
var max = 10;
if(threads.length < max) max = threads.length;
for(i = 0; i < max; i++)
{ 
if (threads[i].title.length > 45)
{ threads[i].title = threads[i].title.substring(0, 45) + '...'; }
document.writeln("<tr><td class=\"alt2\"><a href=\"http://www.enworld.org/forums/showthread.php?t=" + threads[i].threadid + "\">" + threads[i].title + "</a></td></tr>");
}
//-->
</script>
			</table>
			<table width="100%" border="0" cellspacing="2" cellpadding="1">
				<tr><td align="center" class="thead">Books &amp; Novels</td></tr>			
			          <script type="text/javascript" src="http://www.enworld.org/forums/external.php?forumids=180&type=js"></script>
          <script type="text/javascript">
<!--
var max = 10;
if(threads.length < max) max = threads.length;
for(i = 0; i < max; i++)
{ 
if (threads[i].title.length > 45)
{ threads[i].title = threads[i].title.substring(0, 45) + '...'; }
document.writeln("<tr><td class=\"alt2\"><a href=\"http://www.enworld.org/forums/showthread.php?t=" + threads[i].threadid + "\">" + threads[i].title + "</a></td></tr>");
}
//-->
</script>
			</table>
			<table width="100%" border="0" cellspacing="2" cellpadding="1">
				<tr><td align="center" class="thead">Other</td></tr>			
<script type="text/javascript" src="http://www.enworld.org/forums/external.php?forumids=181&type=js"></script>
<script type="text/javascript">
<!--
var max = 10;
if(threads.length < max) max = threads.length;
for(i = 0; i < max; i++)
{ 
if (threads[i].title.length > 45)
{ threads[i].title = threads[i].title.substring(0, 45) + '...'; }
document.writeln("<tr><td class=\"alt2\"><a href=\"http://www.enworld.org/forums/showthread.php?t=" + threads[i].threadid + "\">" + threads[i].title + "</a></td></tr>");
}
//-->
</script>			
			</table>
		</td></tr></table></td>
		<td width="33%" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"><tr><td class="tborder">
			<table width="100%" border="0" cellspacing="2" cellpadding="1">
				<tr><td align="center" class="thead">D20/OGL</td></tr>
          <script type="text/javascript" src="http://www.enworld.org/forums/external.php?forumids=163&type=js"></script>
          <script type="text/javascript">
<!--
var max = 10;
if(threads.length < max) max = threads.length;
for(i = 0; i < max; i++)
{ 
if (threads[i].title.length > 45)
{ threads[i].title = threads[i].title.substring(0, 45) + '...'; }
document.writeln("<tr><td class=\"alt2\"><a href=\"http://www.enworld.org/forums/showthread.php?t=" + threads[i].threadid + "\">" + threads[i].title + "</a></td></tr>");
}
//-->
</script>
			</table>
			<table width="100%" border="0" cellspacing="2" cellpadding="1">
				<tr><td align="center" class="thead">PDF/e-publishing</td></tr>
          <script type="text/javascript" src="http://www.enworld.org/forums/external.php?forumids=111&type=js"></script>
          <script type="text/javascript">
<!--
var max = 10;
if(threads.length < max) max = threads.length;
for(i = 0; i < max; i++)
{ 
if (threads[i].title.length > 45)
{ threads[i].title = threads[i].title.substring(0, 45) + '...'; }
document.writeln("<tr><td class=\"alt2\"><a href=\"http://www.enworld.org/forums/showthread.php?t=" + threads[i].threadid + "\">" + threads[i].title + "</a></td></tr>");
}
//-->
</script>
			</table>
			<table width="100%" border="0" cellspacing="2" cellpadding="1">
				<tr><td align="center" class="thead">Sci-Fi/Fantasy</td></tr>
<script type="text/javascript" src="http://www.enworld.org/forums/external.php?forumids=110&type=js"></script>
<script type="text/javascript">
<!--
var max = 10;
if(threads.length < max) max = threads.length;
for(i = 0; i < max; i++)
{ 
if (threads[i].title.length > 45)
{ threads[i].title = threads[i].title.substring(0, 45) + '...'; }
document.writeln("<tr><td class=\"alt2\"><a href=\"http://www.enworld.org/forums/showthread.php?t=" + threads[i].threadid + "\">" + threads[i].title + "</a></td></tr>");
}
//-->
</script>
			</table>			
		</td></tr></table></td>
	</tr>
</table>
<br />
  <div align="center"><a href="http://www.enworld.org/forums/news.php?page=syndicate">Click here 
    to syndicate these headlines</a>.</div>
<br />
Note that there's really not that much fancy going on here if you know HTML. The javascript uses the syndicator to fetch the headlines, and I carefully inserted the classes I wanted into each table row and header to get their colors to display right.

For this to work on your page you have to go to vboptions >> syndication and turn it on, choosing XML syndication. At that point a link will appear in each forum "Syndicate this page" Follow this instructions that appear.

If you need any help just yell.
Reply With Quote
  #19  
Old 10-28-2004, 07:34 AM
Michael Morris's Avatar
Michael Morris Michael Morris is offline
 
Join Date: Nov 2003
Location: Knoxville TN
Posts: 774
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Jaxx
Thanks a bunch.

I very pleased with it, you did a great job on it.

Is there any chance of getting some type of mod that would count the replies to a news article and put (# comments) next to it?
Easy enough. Open the provided newsdigest.php file. Find this code (It's almost at the start):

PHP Code:
SELECT thread.threadid
IMMEDIATELY AFTER INSERT
PHP Code:
replycount
The query should read like this after you're done

PHP Code:
SELECT thread.threadidreplycountpostusernamepostuserid
and so on.

Doing that captures the reply count. You can now slip it into the news item by putting $news[replycount] into the template. For example, change the adv_portal_newsdigest_item template to:

HTML Code:
<div align="justify">$news[message] - submitted by $news[postusername]. <a href="showthread.php?t=$news[threadid]">Comments: $news[replycount]</a></div>
Reply With Quote
  #20  
Old 10-28-2004, 07:43 AM
Jaxx Jaxx is offline
 
Join Date: Mar 2003
Location: Seattle, Wa
Posts: 102
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks a bunch.

I ran across this though after doing the above. Sorry to be a bother, still relatively new to php.


Code:
Database error in vBulletin 3.0.3:

Invalid SQL: 
			SELECT thread.threadid, replycount, postusername, postuserid, thread.dateline AS postdateline, 
			thread.forumid, forum.title as title, forum.fhbanner as icon, post.postid, pagetext, allowsmilie
			FROM thread AS thread
			LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
			LEFT JOIN forum AS forum ON (forum.forumid = thread.forumid)	
			LEFT JOIN deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
			WHERE thread.dateline>UNIX_TIMESTAMP(CURDATE()) AND thread.forumid IN(45,46,42,43,44) 
			AND thread.visible = 1 AND thread.open != 10 AND deletionlog.primaryid IS NULL 
			GROUP BY post.postid
			ORDER BY forum.displayorder
mysql error: Column: 'replycount' in field list is ambiguous

mysql error number: 1052

Date: Thursday 28th of October 2004 04:52:27 AM
Script: http://www.ahazi.org/forums/showthread.php?p=53981
Referer: http://www.ahazi.org/forums/editpost.php?do=editpost&p=53981
Reply With Quote
  #21  
Old 10-28-2004, 07:56 AM
Michael Morris's Avatar
Michael Morris Michael Morris is offline
 
Join Date: Nov 2003
Location: Knoxville TN
Posts: 774
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

No problem
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 05:56 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.06455 seconds
  • Memory Usage 2,415KB
  • Queries Executed 26 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (2)bbcode_code
  • (6)bbcode_html
  • (7)bbcode_php
  • (5)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete