[2.0.15] Latest active topics on index

[WestTac1]

Is there any way to stop it scrolling and just display the topics on the main page statically?

try remove the marquee in the code and increas the height of the table

How would I do that? (Removing the marquee code,and add a static code?) Thanks in advance for any help!! BTW, Awesome mod and very easy to install and use!

[zparta]

Is there any way to stop it scrolling and just display the topics on the main page statically?

try remove the marquee in the code and increas the height of the table

How would I do that? (Removing the marquee code,and add a static code?) Thanks in advance for any help!! BTW, Awesome mod and very easy to install and use!

you would change the code you put in the tpl file and remove:
<marquee id="recent_topics" behavior="scroll" direction="up" height="100" scrolldelay="100" scrollamount="2">
</marquee>

and every onMouseOver="document.all.recent_topics.stop()" onMouseOut="document.all.recent_topics.start()

remove that frome the code in your tpl file then it should work just fine

[thongish]

INSERT INTO phpbb_config ( config_name, config_value ) VALUES ('topics_on_index', '10');

This is what I did.....

Code: Select all

<?php 
/*************************************************************************** 
 *                               db_update.php 
 *                            ------------------- 
 * 
 *   copyright            : ©2003 Freakin' Booty ;-P & Antony Bailey 
 * 
 ***************************************************************************/ 

/*************************************************************************** 
 * 
 *   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. 
 * 
 ***************************************************************************/ 

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

// 
// Start session management 
// 
$userdata = session_pagestart($user_ip, PAGE_INDEX); 
init_userprefs($userdata); 
// 
// End session management 
// 


if( !$userdata['session_logged_in'] ) 
{ 
   $header_location = ( @preg_match('/Microsoft|WebSTAR|Xitami/', getenv('SERVER_SOFTWARE')) ) ? 'Refresh: 0; URL=' : 'Location: '; 
   header($header_location . append_sid("login.$phpEx?redirect=db_update.$phpEx", true)); 
   exit; 
} 

if( $userdata['user_level'] != ADMIN ) 
{ 
   message_die(GENERAL_MESSAGE, 'You are not authorised to access this page'); 
} 


$page_title = 'Updating the database'; 
include($phpbb_root_path . 'includes/page_header.'.$phpEx); 

echo '<table width="100%" cellspacing="1" cellpadding="2" border="0" class="forumline">'; 
echo '<tr><th>Updating the database</th></tr><tr><td><span class="genmed"><ul type="circle">'; 


$sql = array(); 
$sql[] = "INSERT INTO " . $table_prefix . "config ( config_name, config_value ) VALUES ('topics_on_index', '10')"; 

for( $i = 0; $i < count($sql); $i++ ) 
{ 
   if( !$result = $db->sql_query ($sql[$i]) ) 
   { 
      $error = $db->sql_error(); 

      echo '<li>' . $sql[$i] . '<br /> +++ <font color="#FF0000"><b>Error:</b></font> ' . $error['message'] . '</li><br />'; 
   } 
   else 
   { 
      echo '<li>' . $sql[$i] . '<br /> +++ <font color="#00AA00"><b>Successfull</b></font></li><br />'; 
   } 
} 


echo '</ul></span></td></tr><tr><td class="catBottom" height="28">&nbsp;</td></tr>'; 

echo '<tr><th>End</th></tr><tr><td><span class="genmed">Installation is now finished. Please be sure to delete this file now.<br />If you have run into any errors, please visit the <a href="http://www.phpbbhacks.com/forums" target="_phpbbhacks">phpBBHacks.com support forums</a> and ask someone for help.</span></td></tr>'; 
echo '<tr><td class="catBottom" height="28" align="center"><span class="genmed"><a href="' . append_sid("index.$phpEx") . '">Have a nice day</a></span></td></table>'; 

include($phpbb_root_path . 'includes/page_tail.'.$phpEx); 

?>

Uploaded the file to my /forum/ folder and ran db_update.php but it did nothing... also uploaded the modified files that were required.

I see the new area on the main index page at the bottom of the forum for "Last Active Posts" but nothing is showing in it. I'm using 2.0.6 of phpBB.

How do I get this to work? Because this is a cool MOD!

[zparta]

if you got category hierarchy installed there is a conflict i dont know how to fix because it changes alot of stuff in the code

[raintree]

hi,

this may a bit off topics, my apologized.

Just looking up and down, by chance, is there any "images folder mod" with list box?

thanks in advance.

[zparta]

hi,

this may a bit off topics, my apologized.

Just looking up and down, by chance, is there any "images folder mod" with list box?

thanks in advance.

a bit off-topic

i dont understand what you are trying to say can you explain in more detail

[Einstein]

If so I can tell you a workaround.

So what's the workaround for categories hierarchy?

[Einstein]

If so I can tell you a workaround.

So what's the workaround for categories hierarchy?

Here's one workaround, seems to work at least. This code is copied from search:

Code: Select all

$keys = array();
$keys = get_auth_keys('Root');
$auth_view_forum_sql = '';
for ($i=0; $i < count($keys['id']); $i++)
{
	if ($tree['type'][ $keys['idx'][$i] ] == POST_FORUM_URL)
	{
		$auth_view_forum_sql .= (($auth_view_forum_sql != '') ? ', ' : '') . $tree['id'][ $keys['idx'][$i] ];
	}
}
$auth_view_forum_sql = ($auth_view_forum_sql == '' ? '(0)' : '(' . $auth_view_forum_sql . ')'); 

Is there any PHP guru that can say if this is OK?

[raintree]

hi,

this may a bit off topics, my apologized.

Just looking up and down, by chance, is there any "images folder mod" with list box?

thanks in advance.

a bit off-topic

i dont understand what you are trying to say can you explain in more detail

Is there any personal images/pictures gallery for registered user? Example, 1 of the registered users would like to sell their used computer parts on the forum, posting/attach of images/picture is the best way to support his/her sales.
However, he/she got too many items on sales. What I'm requesting is "do any like "gallery mod" so call personal gallery for registered user'? If guest or registered want to view the pic gallery, they can just click on the "my gallery" list box under the registered nick below.

Something like below URL, this is a very good example.


http://www.arofanatics.com/forums/showt ... did=101343

Kindly look at this registered nick "aro crazzz" on the left, under his nick you can find a list box showing "aro crazzz gallery", this is what I'm requesting for.

Await for your kind advise.

Thanks in advance.

[zparta]

hi,

this may a bit off topics, my apologized.

Just looking up and down, by chance, is there any "images folder mod" with list box?

thanks in advance.

a bit off-topic

i dont understand what you are trying to say can you explain in more detail

Is there any personal images/pictures gallery for registered user? Example, 1 of the registered users would like to sell their used computer parts on the forum, posting/attach of images/picture is the best way to support his/her sales.
However, he/she got too many items on sales. What I'm requesting is "do any like "gallery mod" so call personal gallery for registered user'? If guest or registered want to view the pic gallery, they can just click on the "my gallery" list box under the registered nick below.

Something like below URL, this is a very good example.


http://www.arofanatics.com/forums/showt ... did=101343

Kindly look at this registered nick "aro crazzz" on the left, under his nick you can find a list box showing "aro crazzz gallery", this is what I'm requesting for.

Await for your kind advise.

Thanks in advance.

i have no idea if there is any mod that do that post a topic in mod request forum

[idea]

this is the first line in "readme" file

#
#-----[ SQL ]------------------------------------------
#
INSERT INTO phpbb_config ( config_name, config_value ) VALUES ('topics_on_index', '10');



???? where do i insert that statement?? sorry...i'm so new to this thing..

[Einstein]

Thanks zparta. I've taken a mod someone else wrote and i'm modifying it quite heavily, to create a "main page" for phpBB that can be used as the default page. It contains the latest topics, and i'll be adding on news and such sometime. When it's working I might submit it for other to use.

I'm modifying it quite heavily too ... My version looks the same as near the search result list. I'm creating different page "Recent topics". I know there exists a MOD that do the same. But I don't like the way it's built. I will share the code when I'm ready.

Thanks, zparta for a really good MOD.

[Einstein]

this is the first line in "readme" file

#
#-----[ SQL ]------------------------------------------
#
INSERT INTO phpbb_config ( config_name, config_value ) VALUES ('topics_on_index', '10');



???? where do i insert that statement?? sorry...i'm so new to this thing..

Use thongish way, a few posts above. Or execute it manaully into your database. You can use phpMyAdmin or some other client. Search the forum for phpMyAdmin.

[idea]

i still don't get it

where do i insert this statement ?

Code: Select all

INSERT INTO phpbb_config ( config_name, config_value ) VALUES ('topics_on_index', '10'); 

I'm currently using CPANEL

I'm in phpMyAdmin --> xxxx_phpBB database --> now what??

please help me 8O

[zparta]

If so I can tell you a workaround.

So what's the workaround for categories hierarchy?

Here's one workaround, seems to work at least. This code is copied from search:

Code: Select all

$keys = array();
$keys = get_auth_keys('Root');
$auth_view_forum_sql = '';
for ($i=0; $i < count($keys['id']); $i++)
{
	if ($tree['type'][ $keys['idx'][$i] ] == POST_FORUM_URL)
	{
		$auth_view_forum_sql .= (($auth_view_forum_sql != '') ? ', ' : '') . $tree['id'][ $keys['idx'][$i] ];
	}
}
$auth_view_forum_sql = ($auth_view_forum_sql == '' ? '(0)' : '(' . $auth_view_forum_sql . ')'); 

Is there any PHP guru that can say if this is OK?

every way is ok aslong as it works but witch one is the right way(more secure) is another question
hmm i will try this code a little later and look thru it more correctly and look at it