Hulp bij aanpassen laatste 24 uur

Installatie lukt niet? Plotseling een foutmelding. Of weet je niet hoe iets werkt. Problemen met phpBB2 kun je in dit archief opzoeken.
Forumregels

Sinds 1 januari 2009 wordt phpBB2 niet meer ondersteund.
Onderstaande informatie is verouderd en dient uitsluitend als archief.phpBB2.0.x
Gesloten
Edo

Hulp bij aanpassen laatste 24 uur

Bericht door Edo » 23 dec 2002, 22:33

Hallo allen,

Ik heb een laatste 24 uur hack op mijn forum maar wil graag dat de output van de berichten er wat anders uit komt te zien en ik kom er zelf niet uit dus mijn hoop is op jullie gevestigd.

De output is nu:

Website forum-->categorie 1
...Naam:Jan Op:20.12.02 22:17:34 | Bericht titel
Website forum-->categorie 2
...Naam:Piet Op:20.12.02 22:17:34 | Bericht titel

Iedere keer als er een nieuw bericht word geplaatst word de regel ...Naam enz vervangen door de nieuwe.

Nu wil ik graag dat alle reacties te zien zijn, dus als er een nieuwe reactie komt op een onderwerp deze onderaan aansluit.
bv:

Website forum-->categorie 1
...Naam:Jan Op:20.12.02 22:17:34 | Bericht titel
...Naam:piet Op:21.12.02 22:13:40 | Bericht titel
...Naam:willem Op:22.12.02 22:08:10 | Bericht titel
Website forum-->categorie 2
...Naam:Piet Op:20.12.02 22:17:34 | Bericht titel
...Naam:jappie Op:20.12.02 22:18:10 | Bericht titel

En ik zou graag waar nu de bericht titel komt te staan de bv eerste 20 letters van de bericht body willen zien.

Ik hoop dat het begrijpelijk is en dat iemand me kan helpen.
Bedankt alvast.

Hier is de code:

latest.php

Code: Selecteer alles

<?php

/**********************************************************************************
########################################################
## Mod Title:   Latest Post
## Mod Version: 0.1
## Author:      Matt Slovig < matthias@slovig.de >
## Credits:     Philip Mayer for the original phpBB 1.4x-Script I used
########################################################
**********************************************************************************/

define('IN_PHPBB', true);
$phpbb_root_path = "./";
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);

include($phpbb_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_admin.' . $phpEx);
include($phpbb_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_latest.' . $phpEx);

//
// Start session management
//
$userdata = session_pagestart($user_ip, PAGE_INDEX, $board_config['session_length']);
init_userprefs($userdata);
//
// End session management
//

$page_title = $lang['latest_posts'];
include($phpbb_root_path . 'includes/page_header.'.$phpEx);

if (!isset($selorder)) $selorder = "las24";
if (!isset($nodays)) $nodays = 3;

$template->assign_vars(array(
	"L_TOPIC" => $lang['Topic'],
	"L_MATCHES" => $lang['matches'],

	"FORM_ACTION" => $PHP_SELF,
	"L_LAS24_MSG"   => $lang['last_24h'],
	"L_LAS2_MSG"   => $lang['last_2h'],
	"L_LAS4_MSG"   => $lang['last_4h'],
	"L_LAS6_MSG"   => $lang['last_6h'],
	"L_LAS8_MSG"   => $lang['last_8h'],
	"L_TODAY_MSG"   => $lang['today'],
	"L_YESTR_MSG"   => $lang['yesterday'],
	"L_LWEEK_MSG"   => $lang['last_week'],
	"L_LADAY_MSG"   => $lang['last_xdays'],

	"L_SHOW"        => $lang['show_posts'],
	"L_SHOWING"     => $lang['showing_posts'],
	"L_DAYS"        => $lang['day_posts'],
	"L_LAST"        => $lang['last_posts'],

	"NODAYS"      => $nodays,
	"PAGE_NAME" => $lang['latest_posts'],

	)
);

$template->set_filenames(array(
	"body" => "latest.tpl")
);

// SQLs:

$part1 = "
SELECT from_unixtime(p.post_time, '%d.%m.%y %H:%i:%s') as topic_time,
       f.forum_name as forum_name,
       f.forum_id as forum_id,
       u.username as username,
       p.poster_id as poster_id,
       p.post_id as post_id,
       t.topic_id as topic_id,
       t.topic_title as topic_title
FROM   ".TOPICS_TABLE." t,
       ".POSTS_TABLE." p
       LEFT OUTER JOIN ".FORUMS_TABLE." f on p.forum_id = f.forum_id
       LEFT OUTER JOIN ".USERS_TABLE." u on p.poster_id = u.user_id
WHERE  p.post_id = t.topic_last_post_id and f.auth_view = 0 and  ";

$part2 = " ORDER BY p.post_time desc ";

$showdays = 86400 * $nodays;

$lastweeksql  = $part1."UNIX_TIMESTAMP(NOW()) - p.post_time < 691200".$part2;
$yesterdaysql = $part1."FROM_UNIXTIME(p.post_time,'%Y%m%d') - FROM_UNIXTIME(unix_timestamp(NOW()),'%Y%m%d') = -1".$part2;
$todaysql     = $part1."FROM_UNIXTIME(p.post_time,'%Y%m%d') - FROM_UNIXTIME(unix_timestamp(NOW()),'%Y%m%d') = 0".$part2;

$last24hsql   = $part1."UNIX_TIMESTAMP(NOW()) - p.post_time < 86400".$part2;
$last2hsql   = $part1."UNIX_TIMESTAMP(NOW()) - p.post_time < 7200".$part2;
$last4hsql   = $part1."UNIX_TIMESTAMP(NOW()) - p.post_time < 14400".$part2;
$last6hsql   = $part1."UNIX_TIMESTAMP(NOW()) - p.post_time < 21600".$part2;
$last8hsql   = $part1."UNIX_TIMESTAMP(NOW()) - p.post_time < 28800".$part2;
$lastXdsql    = $part1."UNIX_TIMESTAMP(NOW()) - p.post_time < $showdays".$part2;

switch ($selorder) {

 case "las24" : $sql = $last24hsql; $template->assign_vars(array("MSG" => $lang['last_24h'])); break;
 case "las2" : $sql = $last2hsql; $template->assign_vars(array("MSG" => $lang['last_2h'])); break;
 case "las4" : $sql = $last4hsql; $template->assign_vars(array("MSG" => $lang['last_4h'])); break;
 case "las6" : $sql = $last6hsql; $template->assign_vars(array("MSG" => $lang['last_6h'])); break;
 case "las8" : $sql = $last8hsql; $template->assign_vars(array("MSG" => $lang['last_8h'])); break;
 case "today" : $sql = $todaysql; $template->assign_vars(array("MSG" => $lang['today'])); break;
 case "yestr" : $sql = $yesterdaysql; $template->assign_vars(array("MSG" => $lang['yesterday'])); break;
 case "lweek" : $sql = $lastweeksql; $template->assign_vars(array("MSG" => $lang['last_week'])); break;
 case "laday" : $sql = $lastXdsql; $template->assign_vars(array("MSG" => $lang['last_xdays1'].$nodays.$lang['last_xdays2'])); break;

}

$style = 0;

$result = $db->sql_query($sql)
or message_die(GENERAL_ERROR, "Couldn't retrieve data", "", __LINE__, __FILE__, $sql);
while( $row = $db->sql_fetchrow($result) ) {
	$style++;
	(!($style% 2) ) ? $class = 'row2' : $class= 'row1';
		$template->assign_block_vars("posts", array(
		"TOPIC_TITLE" => $row["topic_title"],
		"TOPIC_TIME" => $row["topic_time"],
		"TOPIC_URL" => "viewtopic.".$phpEx."?p=".$row["post_id"]."#".$row["post_id"],
		"FORUM_NAME" => $row["forum_name"],
		"FORUM_URL" => "viewforum.".$phpEx."?f=".$row["forum_id"],
		"USERNAME" => $row["username"],
		"USER_URL" => "profile.".$phpEx."?mode=viewprofile&u=".$row["poster_id"],
		"POST_ID" => $row["post_id"],
		"FORUM_ID" => $row["forum_id"],
		"CLASS" => $class,
			)
		);
}

  // all data ready, displaying...

$template->pparse("body");

include($phpbb_root_path . 'includes/page_tail.'.$phpEx);
?>
latest.tpl

Code: Selecteer alles

<script language="JavaScript">
<!--
function MM_jumpMenu(targ,selObj,restore){ //v3.0
  eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
  if (restore) selObj.selectedIndex=0;
}
//-->
</script>
<table  cellpadding="2" background="#788897" cellspacing="0" width="625" border="0" >
<tr> 
	<th class="row5" align="center" width="600" height="21" nowrap="nowrap">Website Forum</span></th>
	
  </tr><tr> 
<td class="row2" align="center" width="600" height="21" cellpadding="3"><span class="genmed"><strong>Maak je keuze in het pulldown menu, bijvoorbeeld 'Laatste 4 uur' <br>of vul het aantal dagen in die je wilt zien en klick op 'dag(en)'</strong></span></td>
</tr>

<form name="form1" method="get" action="{FORM_ACTION}"></table>
<table align="center" width="625">

<tr>
    <td class="genmed" style="text-align: center">
        <p><br>{L_SHOWING} <strong>{MSG}</strong></p>
          {L_SHOW}
  <select name="menu1" onChange="MM_jumpMenu('parent',this,1)">
    <option selected value="">Zoeken op</option>
    <option value="{FORM_ACTION}?selorder=las2">{L_LAS2_MSG}</option>
    <option value="{FORM_ACTION}?selorder=las4">{L_LAS4_MSG}</option>
    <option value="{FORM_ACTION}?selorder=las6">{L_LAS6_MSG}</option>
    <option value="{FORM_ACTION}?selorder=las8">{L_LAS8_MSG}</option>
    <option value="{FORM_ACTION}?selorder=today">{L_TODAY_MSG}</option>
    <option value="{FORM_ACTION}?selorder=yestr">{L_YESTR_MSG}</option>
    <option value="{FORM_ACTION}?selorder=las24">{L_LAS24_MSG}</option>
  </select>&nbsp;&nbsp;&nbsp;&nbsp;Laatste: 
  <input type="text" name="nodays" size="2" value="{NODAYS}" maxlength="3">
          <input type="hidden" name="selorder" value="laday">
          <a href="javascript:document.form1.submit();">
          {L_DAYS}
          </a>  <br>          
      </td>
    </tr>
  </table>
</form>

<table  align="center" width="625">
<tr>
	<th class="row5" align="center" colspan="4"><span >{L_MATCHES}</th>
</tr>
<tr>
	
	<td class="row2" height="21" align="left" width="600"><span class="cattitle"><strong>Categorie</span></strong></td>	
	
</tr>

<!-- BEGIN posts -->
        <TR BGCOLOR="<? echo $color2; ?>">
        
        <TD class="{posts.CLASS}" ALIGN="LEFT" WIDTH="600"><span class="genmed"><strong><a href="{U_INDEX}" class="nav">{L_INDEX}</a> -> <a href="{posts.FORUM_URL}">{posts.FORUM_NAME}</a></strong></span><br>
        
        <span class="genmed">&nbsp;&nbsp;&nbsp;Door:<a href="{posts.USER_URL}">{posts.USERNAME}</a> Op:{posts.TOPIC_TIME}&nbsp;|&nbsp;<a href="{posts.TOPIC_URL}">{posts.TOPIC_TITLE}</a></span></TD>
        
        </tr>
<!-- END posts -->

</table>
Omhoog
Gesloten

Terug naar “2.0 Support”