Use of announcement boards

[Thomas]

I use an announcement board to generate news on my frontside. I call it with:
<!--#include virtual="/forum/index.php?action=news;board=18;limit=15" -->

Is there a way to include just 1 post (limit=1) and then put in an ad (468x400) and then include post 2-8 (limit=2-8  ).

Hope someone can help me with this.

/MR.T

[Spaceman-Spiff]

u might need to edit News.php
or add the banned inside your topic

[Thomas]

I hope to implement the banner (468x400) permanently after post #1 on my frontside.
If I put it in my topic it wil follow the topic, and thats not what I want.

Any other sugestions?

/MR.T

[[Unknown]]

Modify News.php to take a limit and a start.  Make the query end like this: LIMIT $start,$limit.

That should work.

-[Unknown]

[Thomas]

This sounds like a good solution, but I am afraid I need som more information on how to do this.
Hope you can help me Unknown.

/MR.T

[[Unknown]]

Hmmm... I'm away from my development computer.....

Just add $start to the global line (it will start with global...), then find the line that looks like "LIMIT $limit" and change it to "LIMIT $start,$limit".

-[Unknown]

[Thomas]

I tried it out, but I then got the following errors on my frontpage:

Code Select Expand

Parse error: parse error, unexpected T_GLOBAL in /home/dykkesid/www/forum/News.php on line 31

Fatal error: Call to undefined function: () in /home/dykkesid/www/forum/index.php on line 292If you are one your devolopement computer Unknown, would it be to much to ask of you to put out the complete news.php and the 2 include scripts to call just post 1 and post 2-15?

/MR.T

[[Unknown]]

Code Select Expand

<?
/*****************************************************************************/
/* News.php                                                                   */
/*****************************************************************************/
/* YaBB: Yet another Bulletin Board                                          */
/* Open-Source Project started by Zef Hemel ([email protected])                 */
/* Software Version: YaBB SE                                                 */
/* ========================================================================= */
/* Software Distributed by:    http://www.yabbse.org                         */
/* Support, News, Updates at:  http://www.yabbse.org/community               */
/*                             http://www.yabbforum.com/community            */
/* ========================================================================= */
/* Copyright (c) 2001-2002 The YaBB SE Development Team                      */
/* Software by: The YaBB SE Development Team                                 */
/*****************************************************************************/
/* This program is free software; you can redistribute it and/or modify it   */
/* under the terms of the GNU General Public License as published by the     */
/* Free Software Foundation; either version 2 of the License, or (at your    */
/* option) any later version.                                                */
/*                                                                           */
/* This program is distributed in the hope that it will be useful, but       */
/* WITHOUT ANY WARRANTY; without even the implied warranty of                */
/* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU General */
/* Public License for more details.                                          */
/*                                                                           */
/* The GNU GPL can be found in gpl.txt in this directory                     */
/*****************************************************************************/

$newsphpver = 'YaBB SE 1.5.1RC1';

global $scripturl, $db_prefix, $txt, $db_name, $db_server, $db_user, $db_passwd, $cgi, $imagesdir, $board, $limit, $template, $ext, $locale, $timeformatstring, $start;

if (!defined('YaBBSE'))
   die('Hacking attempt...');

$dbcon = mysql_connect($db_server, $db_user, $db_passwd);
mysql_select_db ($db_name);

$types_to_register = array('GET', 'POST', 'COOKIE', 'SESSION', 'SERVER');
foreach ($types_to_register as $type)
{
   $arr = @${'HTTP_' . $type . '_VARS'};
   if (@count($arr) > 0)
      extract($arr, EXTR_OVERWRITE);
}

if(!defined('LC_TIME'))
   define('LC_TIME', 'LC_TIME');
setlocale (LC_TIME, $locale);

if ($limit == null)
   $limit = 5;
if ($start == null)
   $start = 0;

if ($board == null)
{
   print 'No Board Specified!';
   exit;
}

$request = db_query("
   SELECT t.*,b.*,c.*
   FROM {$db_prefix}topics as t, {$db_prefix}boards as b, {$db_prefix}categories as c
   WHERE b.ID_CAT=c.ID_CAT
      AND c.memberGroups=''
      AND b.ID_BOARD=$board)");
if (mysql_fetch_array($request) == null)
{
   print 'You can not display a board that is in a category with MemberGroups or the board ID does not exist. Please check the board number before trying again.';
   exit;
}

$request = db_query("
   SELECT t.*,m.*
   FROM {$db_prefix}topics as t, {$db_prefix}messages as m
   WHERE t.ID_BOARD=$board
      AND m.ID_MSG=t.ID_FIRST_MSG)
   ORDER BY m.posterTime DESC
   LIMIT $start,$limit");

define('YaBBSE_news', 1);

while ($row = mysql_fetch_array($request))
{
   $news_icon = '<img src="' . $imagesdir . '/' . $row['icon'] . '.gif" align="absmiddle" />';
   $news_title = $row['subject'];
   $news_date = strftime($timeformatstring, $row['posterTime']);
   $news_tmp = $row['posterName'];
   $request2 = db_query("SELECT realName FROM {$db_prefix}members WHERE (memberName='$news_tmp') LIMIT 1");
   if ($tmp = mysql_fetch_array($request2))
      $news_poster = '<a href="' . $scripturl . '?action=viewprofile;user=' . $row['posterName'] . '">' . $tmp['realName'] . '</a>';
   else
      $news_poster = $news_tmp;

   $news_body = DoUBBC($row['body']);
   $news_checkcomment = ($row['numReplies'] == 1) ? $txt['yse_news_1'] : $txt['yse_news_2'];
   $news_comments = '<a href="' . $cgi . ';action=display;threadid=' . $row['ID_TOPIC'] . ';start=0">' . $row['numReplies'] . ' ' . $news_checkcomment . '</a>';
   $news_newcomment = '<a href="' . $cgi . ';action=post;threadid=' . $row['ID_TOPIC'] . ';title=Post+reply;start=' . $row['numReplies'] . '">' . $txt['yse_news_3'] . '</a>';
   if ($template == null)
      include('news_template.php');
   else
   {
      if ($ext == null)
         include($template . '.php');
      else
         include($template . '.' . $ext);
   }
}
exit;
?>
Call it with ;start=0;limit=1, and then ;start=1;limit=7.

-[Unknown]

Code Select Expand

[Thomas]

Thanks , but the only thing I got was:

Hacking attempt...

on my frontpage.

Could this be because of I am use 1,5 and it seems like this is 1,51?

/MR.T

[[Unknown]]

In that case, remove these lines:

if (!defined('YaBBSE'))
   die('Hacking attempt...');

-[Unknown]

[Thomas]

Upss

Then I got:

Fatal error: Call to undefined function: db_query() in /home/dykkesid/www/forum/News.php on line 60

/MR.T

[[Unknown]]

Oops, that was something I did to count queries real quick (and then changed back :$)

Change any "db_query" to "mysql_query".

-[Unknown]

[Thomas]

Thank you very much for the help Unknown.

I had to do a few other changes as well. You can see it in action on www.dykkesiden.com

I hav enow set up a webboard (468x400) between post 1 and 2

The script for 1,5 is:

Code Select Expand

<?
/*****************************************************************************/
/* News.php                                                                   */
/*****************************************************************************/
/* YaBB: Yet another Bulletin Board                                          */
/* Open-Source Project started by Zef Hemel ([email protected])                 */
/* Software Version: YaBB SE                                                 */
/* ========================================================================= */
/* Software Distributed by:    http://www.yabbse.org                         */
/* Support, News, Updates at:  http://www.yabbse.org/community               */
/*                             http://www.yabbforum.com/community            */
/* ========================================================================= */
/* Copyright (c) 2001-2002 The YaBB SE Development Team                      */
/* Software by: The YaBB SE Development Team                                 */
/*****************************************************************************/
/* This program is free software; you can redistribute it and/or modify it   */
/* under the terms of the GNU General Public License as published by the     */
/* Free Software Foundation; either version 2 of the License, or (at your    */
/* option) any later version.                                                */
/*                                                                           */
/* This program is distributed in the hope that it will be useful, but       */
/* WITHOUT ANY WARRANTY; without even the implied warranty of                */
/* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU General */
/* Public License for more details.                                          */
/*                                                                           */
/* The GNU GPL can be found in gpl.txt in this directory                     */
/*****************************************************************************/

$newsphpver = 'YaBB SE 1.5.1RC1';

global $scripturl, $db_prefix, $txt, $db_name, $db_server, $db_user, $db_passwd, $cgi, $imagesdir, $board, $limit, $template, $ext, $locale, $timeformatstring, $start;

$dbcon = mysql_connect($db_server, $db_user, $db_passwd);
mysql_select_db ($db_name);

$types_to_register = array('GET', 'POST', 'COOKIE', 'SESSION', 'SERVER');
foreach ($types_to_register as $type)
{
   $arr = @${'HTTP_' . $type . '_VARS'};
   if (@count($arr) > 0)
      extract($arr, EXTR_OVERWRITE);
}

setlocale (LC_TIME, $locale);

if ($limit == null)
   $limit = 5;
if ($start == null)
   $start = 0;

if ($board == null)
{
   print 'No Board Specified!';
   exit;
}

$request = mysql_query("SELECT t.*,b.*,c.* FROM {$db_prefix}topics as t,{$db_prefix}boards as b,{$db_prefix}categories as c WHERE (b.ID_CAT=c.ID_CAT && c.memberGroups='' && b.ID_BOARD=$board)");
if (mysql_fetch_array($request) == null)
{
   print 'You can not display a board that is in a category with MemberGroups or the board ID does not exist. Please check the board number before trying again.';
   exit;
}

$request = mysql_query("SELECT t.*,m.* FROM {$db_prefix}topics as t,{$db_prefix}messages as m WHERE (t.ID_BOARD=$board && m.ID_MSG=t.ID_FIRST_MSG) ORDER BY m.posterTime DESC LIMIT $start,$limit");

while ($row = mysql_fetch_array($request))
{
   $news_icon = '<img src="' . $imagesdir . '/' . $row['icon'] . '.gif" align="absmiddle" />';
   $news_title = $row['subject'];
   $news_date = strftime($timeformatstring, $row['posterTime']);
   $news_tmp = $row['posterName'];
   $request2 = mysql_query("SELECT realName FROM {$db_prefix}members WHERE (memberName='$news_tmp') LIMIT 1");
   while ($tmp = mysql_fetch_array($request2))
      $news_poster = '<a href="' . $scripturl . '?action=viewprofile;user=' . $row['posterName'] . '">' . $tmp['realName'] . '</a>';
 
   $news_body = DoUBBC($row['body']);
   $news_checkcomment = ($row['numReplies'] == 1) ? $txt['yse_news_1'] : $txt['yse_news_2'];
   $news_comments = '<a href="' . $cgi . ';action=display;threadid=' . $row['ID_TOPIC'] . ';start=0">' . $row['numReplies'] . ' ' . $news_checkcomment . '</a>';
   $news_newcomment = '<a href="' . $cgi . ';action=post;threadid=' . $row['ID_TOPIC'] . ';title=Post+reply;start=' . $row['numReplies'] . '">' . $txt['yse_news_3'] . '</a>';
   if ($template == null)
      include('news_template.php');
   else
   {
      if ($ext == null)
         include($template . '.php');
      else
         include($template . '.' . $ext);
   }
}
exit;
?>
Thanks again Unknown.

/MR.T

[Thomas]

Here is the code for 1.51.
Thanks to [Unkown].
This allows me to set in pictures/ads or whatever between which posts I want. Very nice feature
See it in action at www.dykkesiden.com

<?
/*****************************************************************************/
/* News.php                                                                   */
/*****************************************************************************/
/* YaBB SE: Yet another Bulletin Board Splinter Edition                      */
/* Open-Source Project inspired by Zef Hemel ([email protected])              */
/* Software Version:           YaBB SE 1.5.1                                 */
/* Software by:                The YaBB SE Development Team                  */
/* ========================================================================= */
/* Software Distributed by:    http://www.yabbse.org                         */
/* Copyright 2001-2003 by:     http://www.lewismedia.com (Lewis Media)       */
/* Support, News, Updates at:  http://www.yabbse.org/community               */
/* Inspired and Ported From:   http://www.yabbforum.com                      */
/*****************************************************************************/
/* This program is free software; you may redistribute it and/or modify it   */
/* under the terms of the provided license as published by Lewis Media.      */
/*                                                                           */
/* This program is distributed in the hope that it will be useful, but       */
/* WITHOUT ANY WARRANTY; without even the implied warranty of                */
/* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the provided    */
/* license for more information.                                             */
/*                                                                           */
/* See license.txt for details of the YaBB SE license. The latest version    */
/* of this license can be found at the distributor's site seen above.        */
/*****************************************************************************/

$newsphpver = 'YaBB SE 1.5.1';

global $scripturl, $db_prefix, $txt, $db_name, $db_server, $db_user, $db_passwd, $cgi, $imagesdir, $board, $limit, $template, $ext, $locale, $timeformatstring, $start;

if (!defined('YaBBSE'))
   die('Hacking attempt...');

$dbcon = mysql_connect($db_server, $db_user, $db_passwd);
mysql_select_db ($db_name);

$types_to_register = array('GET', 'POST', 'COOKIE', 'SESSION', 'SERVER');
foreach ($types_to_register as $type)
{
   $arr = @${'HTTP_' . $type . '_VARS'};
   if (@count($arr) > 0)
      extract($arr, EXTR_OVERWRITE);
}

if(!defined('LC_TIME'))
   define('LC_TIME', 'LC_TIME');
setlocale (LC_TIME, $locale);

if ($limit == null)
   $limit = 5;
if ($start == null)
 $start = 0;

if ($board == null)
{
   print 'No Board Specified!';
   exit;
}

$request = mysql_query("SELECT t.*,b.*,c.* FROM {$db_prefix}topics as t,{$db_prefix}boards as b,{$db_prefix}categories as c WHERE (b.ID_CAT=c.ID_CAT && c.memberGroups='' && b.ID_BOARD=$board)");
if (mysql_fetch_array($request) == null)
{
   print 'You can not display a board that is in a category with MemberGroups or the board ID does not exist. Please check the board number before trying again.';
   exit;
}

$request = mysql_query("SELECT t.*,m.* FROM {$db_prefix}topics as t, {$db_prefix}messages as m WHERE (t.ID_BOARD=$board && m.ID_MSG=t.ID_FIRST_MSG) ORDER BY m.posterTime DESC LIMIT $start,$limit");

define('YaBBSE_news', 1);

while ($row = mysql_fetch_array($request))
{
   $news_icon = '<img src="' . $imagesdir . '/' . $row['icon'] . '.gif" align="middle" alt="' . $row['icon'] . '" />';
   $news_title = $row['subject'];
   $news_date = strftime($timeformatstring, $row['posterTime']);
   $news_tmp = $row['posterName'];
   $request2 = mysql_query("SELECT realName FROM {$db_prefix}members WHERE (memberName='$news_tmp') LIMIT 1");
   if ($tmp = mysql_fetch_array($request2))
      $news_poster = '<a href="' . $scripturl . '?action=viewprofile;user=' . $row['posterName'] . '">' . $tmp['realName'] . '</a>';
   else
      $news_poster = $news_tmp;

   $news_body = DoUBBC($row['body']);
   $news_checkcomment = ($row['numReplies'] == 1) ? $txt['yse_news_1'] : $txt['yse_news_2'];
   $news_comments = '<a href="' . $cgi . ';action=display;threadid=' . $row['ID_TOPIC'] . ';start=0">' . $row['numReplies'] . ' ' . $news_checkcomment . '</a>';
   $news_newcomment = '<a href="' . $cgi . ';action=post;threadid=' . $row['ID_TOPIC'] . ';title=Post+reply;start=' . $row['numReplies'] . '">' . $txt['yse_news_3'] . '</a>';

   if ($template == null)
      include('news_template.php');
   else
   {
      if ($ext == null)
         include($template . '.php');
      else
         include($template . '.' . $ext);
   }
}
exit;
?>

/MR.T