Как да го оправя това?

M

MaDHaCkEr

Registered
Ползвам този код за последните 10 теми
<?

//phpBB - last topics
//Email: bobi@wthost.net
//Name: Bobi Haidar
// http://web-tourist.net





$user="root"; //DB user
$pass="annms"; //DB pass
$db="phpbb3"; //DB name

$broi_temi="20"; // Колко последни теми да показва
$broi_bukvi="25"; //До колко букви от заглавието на темата да показва

mysql_connect(localhost,$user,$pass);
mysql_select_db($db) or die( "Unable to select database");
$query="SELECT c.topic_time , c.topic_title,c.forum_id,c.topic_id, c.topic_replies,c.topic_type,f.forum_name FROM phpbb3_topics c, phpbb3_forums f WHERE c.forum_id=f.forum_id and f.auth_view like '0' ORDER BY c.topic_time ";
$result=mysql_query($query);
$num=mysql_num_rows($result);
mysql_close();
$ii=$num-$broi_temi;


for ($i=$num-1; $i>$ii;$i--)
{
$tema=mysql_result($result,$i,"c.topic_title");
$id=mysql_result($result,$i,"c.forum_id");
$topic_broi=mysql_result($result,$i,"c.topic_replies");
$topic_id=mysql_result($result,$i,"c.topic_id");
$topic=mysql_result($result,$i,"c.topic_type");
$cat=mysql_result($result,$i,"f.forum_name");

if (strlen($tema)>$broi_bukvi)
{$totchki='...';}
else
{$totchki='';}

$tema=substr($tema,0 , $broi_bukvi);
echo" » $cat: <a href='http://87.120.252.71/websites/jambazy/forum/viewtopic.php?t=$topic_id' >$tema$totchki ($topic_broi)</a><br/>";
}


?>
Увеличете...

Като направя datebase да е phpbb сичко си е нормално, обаче като го сменя на phpbb3 и ми излиза това...
Код: 
» Test Forum 1: Welcome to phpBB 2 (1)

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -1 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 182

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -1 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 183

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -1 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 184

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -1 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 185

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -1 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 186

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -1 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 187
» : ()

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -2 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 182

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -2 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 183

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -2 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 184

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -2 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 185

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -2 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 186

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -2 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 187
» : ()

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -3 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 182

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -3 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 183

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -3 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 184

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -3 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 185

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -3 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 186

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -3 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 187
» : ()

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -4 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 182

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -4 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 183

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -4 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 184

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -4 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 185

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -4 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 186

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -4 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 187
» : ()

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -5 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 182

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -5 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 183

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -5 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 184

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -5 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 185

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -5 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 186

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -5 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 187
» : ()

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -6 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 182

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -6 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 183

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -6 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 184

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -6 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 185

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -6 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 186

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -6 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 187
» : ()

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -7 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 182

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -7 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 183

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -7 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 184

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -7 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 185

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -7 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 186

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -7 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 187
» : ()

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -8 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 182

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -8 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 183

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -8 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 184

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -8 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 185

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -8 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 186

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -8 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 187
» : ()

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -9 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 182

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -9 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 183

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -9 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 184

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -9 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 185

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -9 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 186

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -9 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 187
» : ()

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -10 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 182

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -10 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 183

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -10 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 184

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -10 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 185

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -10 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 186

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -10 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 187
» : ()

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -11 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 182

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -11 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 183

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -11 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 184

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -11 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 185

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -11 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 186

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -11 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 187
» : ()

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -12 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 182

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -12 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 183

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -12 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 184

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -12 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 185

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -12 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 186

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -12 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 187
» : ()

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -13 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 182

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -13 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 183

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -13 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 184

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -13 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 185

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -13 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 186

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -13 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 187
» : ()

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -14 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 182

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -14 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 183

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -14 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 184

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -14 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 185

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -14 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 186

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -14 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 187
» : ()

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -15 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 182

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -15 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 183

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -15 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 184

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -15 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 185

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -15 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 186

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -15 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 187
» : ()

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -16 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 182

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -16 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 183

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -16 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 184

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -16 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 185

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -16 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 186

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -16 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 187
» : ()

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -17 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 182

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -17 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 183

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -17 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 184

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -17 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 185

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -17 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 186

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -17 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 187
» : ()

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -18 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 182

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -18 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 183

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -18 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 184

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -18 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 185

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -18 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 186

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -18 on MySQL result index 23 in C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php on line 187
» :
 
ох... не знам кога автора на тоя урок ще си оправи грешката - малка е но пък колко теми се изписаха....
глей са:

<?

//phpBB - last topics
//Email: bobi@wthost.net
//Name: Bobi Haidar
// http://web-tourist.net





$user="root"; //DB user
$pass="annms"; //DB pass
$db="phpbb3"; //DB name

$broi_temi="20"; // Колко последни теми да показва
$broi_bukvi="25"; //До колко букви от заглавието на темата да показва

mysql_connect("localhost",$user,$pass);
mysql_select_db($db) or die( "Unable to select database");
$query="SELECT c.topic_time , c.topic_title,c.forum_id,c.topic_id, c.topic_replies,c.topic_type,f.forum_name FROM phpbb3_topics c, phpbb3_forums f WHERE c.forum_id=f.forum_id and f.auth_view like '0' ORDER BY c.topic_time ";
$result=mysql_query($query);
$num=mysql_num_rows($result);
mysql_close();
$ii=$num-$broi_temi;


for ($i=$num-1; $i>$ii;$i--)
{
$tema=mysql_result($result,$i,"c.topic_title");
$id=mysql_result($result,$i,"c.forum_id");
$topic_broi=mysql_result($result,$i,"c.topic_replies");
$topic_id=mysql_result($result,$i,"c.topic_id");
$topic=mysql_result($result,$i,"c.topic_type");
$cat=mysql_result($result,$i,"f.forum_name");

if (strlen($tema)>$broi_bukvi)
{$totchki='...';}
else
{$totchki='';}

$tema=substr($tema,0 , $broi_bukvi);
echo" » $cat: <a href='http://87.120.252.71/websites/jambazy/forum/viewtopic.php?t=$topic_id' >$tema$totchki ($topic_broi)</a><br/>";
}


?>
Увеличете...

грешката е това което е в червено.
там трябва да си попълниш mysql хоста. със кавичките
 
Ми то сървъра ми е на мойто PC MySQL хоста не е ли localhost... Ще ме извиниш ако не е така, ама MySQL не разбирам и съм учещ се все още :)
 
Пак така се получава
http://87.120.252.71/websites/JaMBaZy/

и направих урока със интегрирането обаче постоянно ме тормози това съобщение :(
Warning: Cannot modify header information - headers already sent by (output started at C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php:10) in C:\Server\xampp\htdocs\Websites\JaMBaZy\forum\includes\sessions.php on line 366

Warning: Cannot modify header information - headers already sent by (output started at C:\Server\xampp\htdocs\Websites\JaMBaZy\index.php:10) in C:\Server\xampp\htdocs\Websites\JaMBaZy\forum\includes\sessions.php on line 367
Увеличете...
 
Аз ти препоръчвам този скрипт:


Код: 
<?php 
// 
// Basic Configuration 
// Колко последни теми да показва? 
$topicnumber = 10; 
// накъде да скролира? 
$scroll = "up"; 
// променте пътя до папката на форума ви 
$urlPath = "http://83.222.180.184/phpBB2/"; 

// Database Configuration (Където се намира вашият phpBB config.php файл 
include 'C:\Program Files\xampp\htdocs\phpBB2\config.php'; 

// Connecting & Selecting Databases 
$table_topics = $table_prefix. "topics"; 
$table_forums = $table_prefix. "forums"; 
$table_posts = $table_prefix. "posts"; 
$table_users = $table_prefix. "users"; 
$link = mysql_connect("$dbhost", "$dbuser", "$dbpasswd") or die("Could not connect"); 
mysql_select_db("$dbname") or die("Could not select database"); 

// Perform Sql Query 
$query = "SELECT t.topic_id, t.topic_title, t.topic_last_post_id, t.forum_id, p.post_id, p.poster_id, p.post_time, u.user_id, u.username 
FROM $table_topics t, $table_forums f, $table_posts p, $table_users u 
WHERE t.topic_id = p.topic_id AND 
f.forum_id = t.forum_id AND 
t.topic_status <> 2 AND 
p.post_id = t.topic_last_post_id AND 
p.poster_id = u.user_id 
ORDER BY p.post_id DESC LIMIT $topicnumber"; 
$result = mysql_query($query) or die("Query failed"); 

// Outcome of the HTML 
// Be carefull when you edit these! 
print "<marquee id=\"recent_topics\" behavior=\"scroll\" direction=\"$scroll\" height=\"170\" scrolldelay=\"100\" scrollamount=\"2\" onMouseOver=\"document.all.recent_topics.stop()\" onMouseOut=\"document.all.recent_topics.start()\"> 
<table cellpadding='3' cellSpacing='2' width='350'>"; 
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) { 
echo "<tr valign='top'><td><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\"><font color=\"#FFCC00\"><b><p><a href=\"$urlPath/viewtopic.php?topic=$row[topic_id]&forum=$row[forum_id]\"></p>" . 
$row["topic_title"] . 
"</a></td></font></b><td><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\"><font color=\"#C0C0C0\"> 
</td></tr></font>"; 
} 
print "</table></marquee>"; 

// Free Result 
mysql_free_result($result); 

// Close the Connection 
mysql_close($link); 
?>
 
http://web-tourist.net/login/login/view.php?st=1484

ето ти го точния урок, че аз по тоя скрипт дет ти го дадох съм пипал малко и не ти изкарва от кой е пусната темата и датата... :)
 
MaDHaCkEr, дава ти грешка защото нямаш 20 теми във форума т :)
Напиши 20 теми и ще видиш, че няма да има никакви грешки. ;)
 
Трябва да си влезнал или регистриран, за да отговориш тук.

Back
Горе