[2.0.15] Latest active topics on index

The cleanup is complete. This forum is now read only.
Post Reply

Rating:

Excellent!
80
54%
Very Good
41
28%
Good
14
10%
Fair
7
5%
Poor
5
3%
 
Total votes: 147

WestTac1
Registered User
Posts: 2
Joined: Wed Dec 03, 2003 11:08 pm

Post by WestTac1 » Wed Dec 03, 2003 11:24 pm

zparta wrote:
commandojnr wrote: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
Registered User
Posts: 142
Joined: Fri Apr 04, 2003 7:14 am
Location: Sweden
Contact:

Post by zparta » Fri Dec 05, 2003 1:16 pm

WestTac1 wrote:
zparta wrote:
commandojnr wrote: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
Registered User
Posts: 6
Joined: Sat Dec 06, 2003 10:50 pm

Post by thongish » Sat Dec 06, 2003 11:32 pm

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
Registered User
Posts: 142
Joined: Fri Apr 04, 2003 7:14 am
Location: Sweden
Contact:

Post by zparta » Wed Dec 10, 2003 9:35 am

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
Registered User
Posts: 55
Joined: Sun Nov 09, 2003 11:32 am

Post by raintree » Sat Dec 13, 2003 4:59 pm

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
Registered User
Posts: 142
Joined: Fri Apr 04, 2003 7:14 am
Location: Sweden
Contact:

Post by zparta » Sun Dec 14, 2003 12:58 pm

raintree wrote: 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
Registered User
Posts: 247
Joined: Sat Oct 18, 2003 9:48 pm
Location: Finland
Contact:

Post by Einstein » Mon Dec 15, 2003 12:20 am

commandojnr wrote: If so I can tell you a workaround.


So what's the workaround for categories hierarchy?

Einstein
Registered User
Posts: 247
Joined: Sat Oct 18, 2003 9:48 pm
Location: Finland
Contact:

Post by Einstein » Mon Dec 15, 2003 12:42 am

Einstein wrote:
commandojnr wrote: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
Registered User
Posts: 55
Joined: Sun Nov 09, 2003 11:32 am

Post by raintree » Mon Dec 15, 2003 3:29 am

zparta wrote:
raintree wrote: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
Registered User
Posts: 142
Joined: Fri Apr 04, 2003 7:14 am
Location: Sweden
Contact:

Post by zparta » Mon Dec 15, 2003 4:58 pm

raintree wrote:
zparta wrote:
raintree wrote: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
Registered User
Posts: 247
Joined: Mon Oct 20, 2003 8:29 am

Post by idea » Tue Dec 16, 2003 11:12 am

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
Registered User
Posts: 247
Joined: Sat Oct 18, 2003 9:48 pm
Location: Finland
Contact:

Post by Einstein » Tue Dec 16, 2003 1:52 pm

commandojnr wrote: 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.
Last edited by Einstein on Tue Dec 16, 2003 1:57 pm, edited 1 time in total.

Einstein
Registered User
Posts: 247
Joined: Sat Oct 18, 2003 9:48 pm
Location: Finland
Contact:

Post by Einstein » Tue Dec 16, 2003 1:55 pm

idea wrote: 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
Registered User
Posts: 247
Joined: Mon Oct 20, 2003 8:29 am

Post by idea » Thu Dec 18, 2003 11:30 pm

i still don't get it :cry:

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 :cry:

zparta
Registered User
Posts: 142
Joined: Fri Apr 04, 2003 7:14 am
Location: Sweden
Contact:

Post by zparta » Sat Dec 20, 2003 5:00 pm

Einstein wrote:
Einstein wrote:
commandojnr wrote: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 :P
hmm i will try this code a little later and look thru it more correctly and look at it :)

Post Reply

Return to “[2.0.x] MOD Database Cleanup”