IntegraMOD

Same problem here. The download files is, indeed, corrupted. Sorry, I checked, I do not have the original file anymore on my HD...

sanji

Damn, does anyone have the file at all?

Im sorry, but evolvers file does not exist. I have been through the files folder and every file backup with a fine tooth comb. Im assuming he uploaded the last file when we were having ftp issues.

Oh well so it looks like we are stuck for an easy solution unless of course some other kind user has downloaded the file and has a copy that can be reuploaded.

Guys?

Ezra to the rescue!!! <img> I got the file and will attach it to this post.

[color=blue]Edit][hr:37gxnpb5]It's an earlier version, so there's just one problem that was described earlier in this topic by "sanji". He wrote the following:

"I have downloaded the small exe made by evolver. There are two issues: first, when you type the name you want to use for the new block, only "M" are displayed - but the name is saved properly. For example, if you want to name your new block "test", it will be written "MMMM" when you try to type that word, although the block's file will be properly named... So just a small issue."

So, it will work like it should. Oh, and for other issues with this you have to read the rest of this topic, because everything works fine.

Greetings,
Ezra

Ezra is our hero. Hmm you can try to upload into the file upoad area?

PM on the way anyway! <img>

Well thanks to Ezra I now have the second recent topics block in position - very much apprecaited, but if possible I'd like to modify the routine but my PHP is not good enough to handle it.....

The idea of the second block is that we can use it to display the last 60 reviews posted in a forum so what we want to do is to retrieve the link to the first post in each thread and then display them backwards time wise, so we can say display the last 30 reviews. That is:

* Most recent review posting
* ...
* ...
* Oldest review

Is this possible at all?

The block as standard looks like this:

Code: Select all

<?php/***************************************************************************  *                        blocks_imp_recents_topic.php  *                            -------------------  *   begin                : Saturday, March 20, 2004  *   copyright            : (C) 2004 masterdavid - Ronald John David  *   website              : [url=http://www.integramod.com]http://www.integramod.com[/url]  *   email                : <a>webmaster@integramod.com</a>  *  *   note: removing the original copyright is illegal even you have modified  *         the code.  Just append yours if you have modified it.  ***************************************************************************/  /***************************************************************************  *  *   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.  *  ***************************************************************************/  if ( !defined('IN_PHPBB') ){     die("Hacking attempt");}  if(!function_exists(imp_recent_topics_Revie_block_func)){     function imp_recent_topics_Revie_block_func()     {         global $template, $portal_config, $userdata, $board_config, $db, $phpEx, $var_cache, $lang;           $forum_data = array();         if($portal_config['cache_enabled'])         {             $forum_data = $var_cache->get('forum', 90000, 'forum');           }         if(!$forum_data)         {             $sql = "SELECT * FROM ". FORUMS_TABLE . " ORDER BY forum_id";             if (!$result1 = $db->sql_query($sql))             {                 message_die(GENERAL_ERROR, 'Could not query forums information', '', __LINE__, __FILE__, $sql);             }             while( $row1 = $db->sql_fetchrow($result1) )             {                 $forum_data[] = $row1;             }             if($portal_config['cache_enabled'])             {                 $var_cache->save($forum_data, 'forum', 'forum');             }         }           $is_auth_ary = array();         $is_auth_ary = auth(AUTH_ALL, AUTH_LIST_ALL, $userdata, $forum_data);           if( $portal_config['md_except_forum_id_Revie'] == '' )         {             $except_forum_id = ''start'';         }         else         {             $except_forum_id = $portal_config['md_except_forum_id_Revie'];         }           for ($i = 0; $i <count>sql_query($sql))         {             message_die(GENERAL_ERROR, 'Could not query recent topics information', '', __LINE__, __FILE__, $sql);         }         $number_recent_topics_Revie = $db->sql_numrows($result1);         $recent_topic_Revie_row = array();         while ($row1 = $db->sql_fetchrow($result1))         {             $recent_topic_Revie_row[] = $row1;         }           if($portal_config['md_recent_topics_Revie_style']){             $style_row = 'scroll_Revie';         }else         {             $style_row = 'static_Revie';         }           $template->assign_block_vars($style_row,"");           for ($i = 0; $i <number_recent_topics_Revie>assign_block_vars($style_row . '.recent_topic_Revie_row', array(                     'U_TITLE' => append_sid("viewtopic.$phpEx?" . POST_POST_URL . '=' . $recent_topic_Revie_row[$i]['post_id']) . '#' .$recent_topic_Revie_row[$i]['post_id'],                     'L_TITLE' => smilies_pass($recent_topic_Revie_row[$i]['topic_title']),                     'L_BY' => $lang['By'],                     'U_POSTER' => append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=" . $recent_topic_Revie_row[$i]['user_id']),                     'S_POSTER' => $recent_topic_Revie_row[$i]['username'],                     'S_POSTTIME' => create_date($board_config['default_dateformat'], $recent_topic_Revie_row[$i]['post_time'], $board_config['board_timezone'])                     )                 );             }             else {                 $template->assign_block_vars($style_row . '.recent_topic_Revie_row', array(                     'U_TITLE' => append_sid("viewtopic.$phpEx?" . POST_POST_URL . '=' . $recent_topic_Revie_row[$i]['post_id']) . '#' .$recent_topic_Revie_row[$i]['post_id'],                     'L_TITLE' => smilies_pass($recent_topic_Revie_row[$i]['topic_title']),                     'L_BY' => $lang['By'],                     'U_POSTER' => append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=" . $recent_topic_Revie_row[$i]['user_id']),                     'S_POSTER' => $recent_topic_Revie_row[$i]['post_username'],                     'S_POSTTIME' => create_date($board_config['default_dateformat'], $recent_topic_Revie_row[$i]['post_time'], $board_config['board_timezone'])                     )                 );             }         }     }}  imp_recent_topics_Revie_block_func();?>

Hope someone can help!

change...

ORDER BY p.post_time DESC

to...

ORDER BY p.post_time ASC

change both occurances to be sure.

Sorry to bring this up again, but does anyone know how to increase the number of Exceptional Forum Ids so I can have over 88??? <img>

Teelk that just reverses the list based on the daet of the last posted topic, we're loocking to base the date on the original seed message of the topic so that we get the most recently posted review first.

We're not interested in the date based on subsequent posts replying to the original review.

"tekguru";p="22223" wrote:Teelk that just reverses the list based on the daet of the last posted topic, we're loocking to base the date on the original seed message of the topic so that we get the most recently posted review first.

We're not interested in the date based on subsequent posts replying to the original review.

Ah, ok. Try chaging those line to...

ORDER BY t.topic_time DESC

instead...

Teelk you are a wonder that has done it - pretty sure it has anyway - it looks right - thanks a million!

Hi guys

Where can I find this file?

the standard recent topics block shows ALL recent topics - even ones in hidden forums....Id like a way to disallow it from showing any topics in a certain forum.

I found a .zip called recent_articles.zip in the downloads - not sure if thisis it....but it doesnt work for me - get a mass ton of errors on the default portal.php

It DOES make mention of:
Make sure you add your portal config variables in the acp.

Whatever that is supposed to mean....if this is the bottom line issue can someone decribe in more detail what is suppsoed to be happening in ACP??

Or perhaps someone can help me with a quick hack to exclude a certain forum from display?

Hi,

For those who are still looking for the RecentTopicBlock Generator:
[url=http]Download[/url] <img>

hi .i want to show only exact forum ,like forum id 1,2,3 .Other forums wont show at my ''recent topics block '' how could i do this .its so important for me because i have made a rss block like this but it has occured some errors like null/empty blocks ..