Skip to content
View in the app

A better way to browse. Learn more.

Web Designer Forum

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

phpbb3 latest posts module

Featured Replies

Hi! I installed this module and it look bad, so i tried for hours to edit it but i only managed to do a little bit. This is Joomla 1.5

It looks like this:

aadlkg.gif

how to make it look like this:

rwjw1t.gif

 

here is the code:

<?php

/**

* @version	  $Id: mod_phpbb3_latest_topics.php 8813 2007-Dec-14 1:32:56 iapostolov $

* @packages   Joomla / phpBB3 / Protos Extensions

* @copyright   Copyright (C)  2007 Protos Extensions. All rights reserved.

* @author	  Ivo Apostolov @ Protos Extensions

* @website	  http://www.ivoapostolov.eu

* @e-mail	  me@ivoapostolov.eu

* @license	  GNU/GPL v2.0

*/



// no direct access

defined('_JEXEC') or die('Restricted access');



// get global mainframe stuff

  global $mainframe;



// load the module parameters	  

  $phpbb3_address			= $params->get('phpbb3_address');

  $phpbb3_post_count		 = $params->get('phpbb3_post_count', 10);

  $phpbb3_target			= $params->get('phpbb3_target', '_blank');

  $phpbb3_show_replies	  = $params->get('phpbb3_show_replies', 1);

  $phpbb3_show_last_poster   = $params->get('phpbb3_show_last_poster', 1);

  $phpbb3_show_profile	  = $params->get('phpbb3_show_profile', 1);

  $phpbb3_show_date		 = $params->get('phpbb3_show_date', 1);



// Load the database settings frot he phpBB configuration

  include_once "".$phpbb3_address."/config.php";



// Connect to the database

  $link = $link = mysql_connect("$dbhost", "$dbuser", "$dbpasswd");

  if (!$link)

  {

// Exit, if can not connect to the database	  

  die('Not connected : ' . mysql_error());

  }

// Select the database

  $db_selected = mysql_select_db("$dbname", $link);

  if (!$db_selected)

  {

// Exit, if can not select the database

  die ('Can\'t use foo : ' . mysql_error());

  }

// Set Query to UTF-8

  mysql_query("SET NAMES UTF8");



// Load the script directory (if any)

  $get_folder = "SELECT config_name, config_value FROM $table_prefix".config." WHERE config_name = 'script_path' LIMIT 0,1";

  $folder = mysql_query($get_folder);

  $folder = mysql_fetch_array($folder);

  extract($folder);	  

  $folder2 = $config_value;   



// Load the script domain

  $get_url = "SELECT config_name, config_value FROM $table_prefix".config." WHERE config_name = 'server_name' LIMIT 0,1";

  $url = mysql_query($get_url);

  $url = mysql_fetch_array($url);

  extract($url);

  $url2 = $config_value;   



// starting the module output	  

  echo "<ul class='forum_topics'>";



// Load the last topics

  $latest_topics = "SELECT * FROM $table_prefix".topics." WHERE topic_approved = '1' ORDER BY topic_last_post_time DESC LIMIT 0,$phpbb3_post_count";

  $topics = mysql_query($latest_topics);

  while($row = mysql_fetch_array($topics))

  {

  $date = date("d.m.Y", $topic_last_post_time);

  extract($row);



// Check if to show the number of replies	  

  if ($phpbb3_show_replies != 0) {

  $show_replies =  " (".$topic_replies.")";

  }

  else {

  $show_replies = "";

  }



// Check if to show the last poster name

  if ($phpbb3_show_last_poster != 0) {

  $last_poster =  " ".JText::_('zadnji poster | ')." ".$topic_last_poster_name."";

  }

  else {

  $last_poster = "";

  }



// Check if to link the last poster name to his profile

  if ($phpbb3_show_profile != 0 and $last_poster != "") {

  $show_profile =  " ".JText::_('last reply by')." <a class='forum_autor' href='http://".$url2."".$folder2."/memberlist.php?mode=viewprofile&u=".$topic_last_poster_id."' target='".$phpbb3_target."' >".$topic_last_poster_name."</a>";

  }

  else {

  $show_profile = $last_poster;

  }



// Check if to show the date

  if ($phpbb3_show_date != 0) {

  $show_date =  " ".JText::_('at')." ".$date."";

  }

  else {

  $show_date = "";

  }



// Start showing the latest posts	  

echo "<li class='forum_topic'><a class='topic_link' href='http://".$url2."".$folder2."/viewtopic.php?f=".$forum_id."&t=".$topic_id."' target='".$phpbb3_target."'>".$topic_title."</a>".$show_replies."".$show_date."</li>";
	echo "<ul>".$show_profile."</li>";
  }



// Ending the output

  echo "</ul>";


?>

  • 1 month later...

Try downloading firebug, get familiar with it. And then manipulate your module with css until you getting working right.

 

Then test it in other browsers for compatibility.

 

If you could post a link, I could probably tell you what css style to apply.

Create an account or sign in to comment

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.