Page 1 of 1

phpbb uzlabosana, tabulas izveide..

Posted: 23 Aug 2007, 17:14
no edw
sveiki, ka izveidot sadas 2 tabulas
Jaunākais forumā
un Jaunākie komentāri.


es te meginu, meginu bet neizdodas.... :/

Posted: 23 Aug 2007, 17:24
no foxsk8
Varbūt tev labāk ir uzlikt šo te modifikāciju?

https://notepad.lv/viewtopic.php?t=553

Ja vajag tieši tikai izvilkt ārā vari meiģināt šos modus

http://phpbbhacks.com/download/3090

Vai arī šeit vari izmeiģināt arī citus modus

http://phpbbhacks.com/searchresults.php ... &Submit=Go

Ja nesanāk raksti šeit. Palīdzēšu.

Posted: 23 Aug 2007, 17:48
no edw
nja ta pati problema kas man bija
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in

idejas?

Posted: 23 Aug 2007, 17:57
no foxsk8
Tieši kuru modifikāciju tu izmanto? Vēl vari pameiģināt šo ar RSS un Javascriptu.

http://www.phpbbhacks.com/download/2057

Š eit vari redzēt demo, kā izskatās. Tur tu pats vari uzģenerēt kā vajag.

https://notepad.lv/topics_anywhere.php

Par to tavu problēmu nav ne jausmas, parasti visi modi strādā, kā vajag.

Posted: 27 Aug 2007, 22:12
no edw
neko pratigu neatradu, dabuju vieno forumu, kur rada tikai pedeja komenteta topika forumu!

varbut vari pasviest to kodu, kas te ir? vismaz pateikt kur nemi?
runaju tiesi par to tabulu "Jaunākais forumā"

Posted: 28 Aug 2007, 15:44
no foxsk8
Nu kods, kas šeit ir izskatās šādi

Code: Select all

// START: Recent Topics-II
// ## --- Configuration of Recent Topics --- ##
// Number of Recent Topics (not Forum ID)
$CFG['number_recenttopics'] = '7';
// Exceptional Forums for Recent Topics, eg. '2,4,10' (note: Smartor's Recent Topics script has its own permission checking, so you can leave this variable blank)
$CFG['exceptional_forums'] = '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,61,62'; // this is set for my forum your ID's will most likely be different
// ## --- END: Configuration of Recent Topics --- ##
$sql = "SELECT * FROM ". FORUMS_TABLE . " ORDER BY forum_id";
if (!$result = $db->sql_query($sql))
{
   message_die(GENERAL_ERROR, 'Could not query forums information', '', __LINE__, __FILE__, $sql);
}
$forum_data = array();
while( $row = $db->sql_fetchrow($result) )
{
   $forum_data[] = $row;
}
$is_auth_ary = array();
$is_auth_ary = auth(AUTH_ALL, AUTH_LIST_ALL, $userdata, $forum_data);
if( $CFG['exceptional_forums'] == '' )
{
   $except_forum_id = '\'start\'';
}
else
{
   $except_forum_id = $CFG['exceptional_forums'];
}
for &#40;$i = 0; $i <count>sql_query&#40;$sql&#41;&#41;
&#123;
   message_die&#40;GENERAL_ERROR, 'Could not query recent topics - II information', '', __LINE__, __FILE__, $sql&#41;;
&#125;
$number_recenttopics = $db->sql_numrows&#40;$result&#41;;
$recent_topicrow = array&#40;&#41;;
while &#40;$row = $db->sql_fetchrow&#40;$result&#41;&#41;
&#123;
   $recent_topicrow&#91;&#93; = $row;
&#125;
for &#40;$i = 0; $i <number_recenttopics>assign_block_vars&#40;'recent_topicrow', array&#40;
      'U_TITLE' => append_sid&#40;"viewtopic.$phpEx?" . POST_POST_URL . '=' . $recent_topicrow&#91;$i&#93;&#91;'post_id'&#93;&#41; . '#' .$recent_topicrow&#91;$i&#93;&#91;'post_id'&#93;,
      'L_TITLE' => $recent_topicrow&#91;$i&#93;&#91;'topic_title'&#93;,
      'U_FORUMS' => append_sid&#40;"viewforum.$phpEx?" . POST_FORUM_URL . '=' . $recent_topicrow&#91;$i&#93;&#91;'forum_id'&#93;&#41; . '#' .$recent_topicrow&#91;$i&#93;&#91;'forum_name'&#93;,
      'L_FORUMS' => $recent_topicrow&#91;$i&#93;&#91;'forum_name'&#93;,
      'U_POSTER' => append_sid&#40;"profile.$phpEx?mode=viewprofile&amp;" . POST_USERS_URL . "=" . $recent_topicrow&#91;$i&#93;&#91;'user_id'&#93;&#41;,
      'S_POSTER' => $recent_topicrow&#91;$i&#93;&#91;'username'&#93;,
		'S_REPLY' => $recent_topicrow&#91;$i&#93;&#91;'topic_replies'&#93;,

      'S_POSTTIME' => create_date&#40;$board_config&#91;'default_dateformat'&#93;, $recent_topicrow&#91;$i&#93;&#91;'post_time'&#93;, $board_config&#91;'board_timezone'&#93;&#41;
      &#41;
   &#41;;
&#125;
// END&#58; Recent Topics-II
Lai attēloto to:

Code: Select all

<table>
   <tr>
   <td><span><b>Jaunākie komentāri</b></span></td>
   </tr>
   <tr>
   <td><span>
   
   <BEGIN>
   &raquo; <a>&#123;recent_topicrow.L_TITLE&#125;</a> &#91;<font>&#123;recent_topicrow.S_REPLY&#125;</font>&#93;<br>
   <a>&#123;recent_topicrow.S_POSTER&#125;</a><br>
   <br>
   <END>
   
   </span></td>
   </tr>
</table> 
Protams, attēlojam kodam jābūt ir tā templeita failam, kuram atbilst tas php kods. Š itais ir no ezportal ņemts. Nezinu vai tev sanāks uz standarta uzdabot virsū. Tabula mysql arī ir. Papēti, paeksperimentē.

Posted: 28 Aug 2007, 16:14
no edw
ok, paldies mēģināšu, ja kas ziņošu.. ;)