[Ipb Mods] Latest 10 Downloads List

**FireNova** · #1 08-30-2005, 08:31 AM

File Name :: Latest 10 Downloads List
Author :: FireNova
Category :: Ipb Mods
Description ::
This script will show the last x downloads from your ipb forums. This requires you to have the download mod already installed. This mod was made using the D2-Downloads System 2.0 databse fields. The forum that this has been tested on were the ipb 2.0x.

This is a PHP script. In order for it to run, you must have PHP on your webhosting account. If you are not sure about this, then ask your webhost about it.

It is only a very simple script and an example of what it looks like is here.

http://p3rc3pt10n.net

In the downloads box.

Please leave the copyright notice in. It will NOT show up when the script is used.

enjoy using it!
FireNova[P3rc3pt10n.net]

View File

**Chaos King** · #2 09-20-2005, 12:19 PM

nice, i saw it on invisionize!

**GR3Z** · #3 11-06-2005, 06:04 PM

You didn't seem to reply on invisionize so i posted here

http://fractical.teamhalo.co.uk/Forum_Stats is where it is at the bottom.

the only problem is that instead of showing as

Code:

http://fractical.teamhalo.co.uk/forum/index.php?download=22

its like this

Code:

http://fractical.teamhalo.co.uk/forumindex.php?download=22

i followed the steps and it doesn't work here is my code. (xx is my database info)

Code:

<?
/*

P3rc3pt10n Downloads List.

Thank you for using this simple ipb mod.

Version 1.0.2 Created August 17th 2005

COPYRIGHT P3rc3pt10n.net 2005

You are not permitted to sell this script, but you can use it, copy it or distribute it, providing that you do not delete this copyright notice, and you do not remove any reference to P3rc3pt10n.net

DESCRIPTION

This script will show the last x downloads from your ipb forums. This requires you to have the download mod already installed. This mod was made using the D2-Downloads System 2.0 databse fields. The forum that this has been tested on were the ipb 2.0x.

This is a PHP script. In order for it to run, you must have PHP on your webhosting account. If you are not sure about this, then ask your webhost about it.

SETUP INSTRUCTIONS

Step 1: Replace Username and Password to your actual Mysql username and password.
Step 2: Replace Database_name with the name of your ipb mysql database.
Step 3: Replace http://siteurl.com/forums/ with the actual url to your forums.
Step 4: Upload the file to your webspace and link it to where you want to show it. You can link it by 

 	<?php include('downloadlist.php'); ?>

Note: If you wish to change it from lastest 10 to X amount find the following phrase

  	limit 10");

change the 10 to the number of downloads you wish to show.

Thanks for using this
Firenova[P3rc3pt10n.net]

Edits:

30 August 05
Add boardurl varible to make things easier.

*/

echo 'Latest 10 Downloads:
<br />
<br />
';

//connect to mysql
//change user and password to your mySQL name and password
mysql_connect("localhost","xxx","xxx"); 
	
//select which database you want to edit
mysql_select_db("Database_Name"); 

//enter your forum url
$board_url = 'http://fractical.teamhalo.co.uk/forum/';

//Do NOT edit below this unless you know what you are doing!
$result = mysql_query("select * from ibf_files order by id desc limit 10");

while($r=mysql_fetch_array($result))
{	
 
  $fname=$r["fname"];
  $id=$r["id"];
  
  echo " ▪ <a href='/forum/index.php?download=$id' title='$fname'>$fname</a>
<br /><br />
";
}

echo "<div align='center'>
<a href='/forum/index.php?act=downloads' title='View All Downloads'>View All Downloads</a></div>";

?>

can you give me code to fix this please ?

thanks

**Insaze** · #4 11-07-2005, 07:55 AM

Quote:

//connect to mysql
//change user and password to your mySQL name and password
mysql_connect("localhost","xxx","xxx");

//select which database you want to edit
mysql_select_db("Database_Name");

//enter your forum url
$board_url = 'http://fractical.teamhalo.co.uk/forum/';

//Do NOT edit below this unless you know what you are doing!
$result = mysql_query("select * from ibf_files order by id desc limit 10");

while($r=mysql_fetch_array($result))
{

$fname=$r["fname"];
$id=$r["id"];

echo " ? $fname

";
}

i think thats how it works
one backslash too much spoils the whole thing
im not sure though :S

**FireNova** · #5 11-07-2005, 12:02 PM

if what insaze said doesnt work then on this line you have

$board_url = 'http://fractical.teamhalo.co.uk/forum/';

remove the last slash

$board_url = 'http://fractical.teamhalo.co.uk/forum';

because the code already has the slashes in

**GR3Z** · #6 11-07-2005, 04:45 PM

non of the above work

**FireNova** · #7 11-07-2005, 05:11 PM

oh im really sorry i havent updated the rar file in the download section the bottom of the code should look like this

while($r=mysql_fetch_array($result))
{

$fname=$r["fname"];
$id=$r["id"];

echo " ▪ $fname

";
}

echo "<div align='center'>
View All Downloads</div>";

?>

**GR3Z** · #8 11-11-2005, 12:15 PM

it still doesnt work :S
http://fractical.teamhalo.co.uk/Forum_Stats

**FireNova** · #9 11-11-2005, 12:20 PM

is this what your code looks like? Is it an exact copy part from the parts need to be changed?

Quote:

<?
/*

P3rc3pt10n Downloads List.

Thank you for using this simple ipb mod.

Version 1.0.2 Created August 17th 2005

COPYRIGHT P3rc3pt10n.net 2005

You are not permitted to sell this script, but you can use it, copy it or distribute it, providing that you do not delete this copyright notice, and you do not remove any reference to P3rc3pt10n.net

DESCRIPTION

This script will show the last x downloads from your ipb forums. This requires you to have the download mod already installed. This mod was made using the D2-Downloads System 2.0 databse fields. The forum that this has been tested on were the ipb 2.0x.

This is a PHP script. In order for it to run, you must have PHP on your webhosting account. If you are not sure about this, then ask your webhost about it.

SETUP INSTRUCTIONS

Step 1: Replace Username and Password to your actual Mysql username and password.
Step 2: Replace Database_name with the name of your ipb mysql database.
Step 3: Replace http://siteurl.com/forums/ with the actual url to your forums.
Step 4: Upload the file to your webspace and link it to where you want to show it. You can link it by

<?php include('downloadlist.php'); ?>

Note: If you wish to change it from lastest 10 to X amount find the following phrase

limit 10");

change the 10 to the number of downloads you wish to show.

Thanks for using this
Firenova[P3rc3pt10n.net]

Edits:

30 August 05
Add boardurl varible to make things easier.

*/

echo 'Latest 10 Downloads:

';

//connect to mysql
//change user and password to your mySQL name and password
mysql_connect("localhost","Username","Password");

//select which database you want to edit
mysql_select_db("Database_Name");

//enter your forum url
$board_url = 'http://siteurl.com/forums/';

//Do NOT edit below this unless you know what you are doing!
$result = mysql_query("select * from ibf_files order by id desc limit 10");

while($r=mysql_fetch_array($result))
{

$fname=$r["fname"];
$id=$r["id"];

echo " ▪ $fname

";
}

echo "<div align='center'>
View All Downloads</div>";

?>

**Insaze** · #10 11-11-2005, 01:20 PM

a slash is missing FN... maybe u did a backslash somewhere or forgot sommat im too lazy to look through this now

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)