Static Pages with vSeo url

jarod1981® · #1 01-14-2007, 10:00 PM

Hello!

I want create other pages .php with recent posts in .html format
I try this code:

Quote:

<?php
echo " <table width=\"100%\" border=\"1\"> <tr>
<td height=\"15\" class=\"tabella\">Ultime dal Nostro Forum</td>
<td height=\"15\" class=\"tabella\">Autore</td>
<td height=\"15\" class=\"tabella\">Risposte</td>
<td height=\"15\" class=\"tabella\">Visite</td>
</tr> ";

include_once ('forums/includes/functions_vbseo.php');
vbseo_get_options();
vbseo_prepare_seo_replace();
get_forum_info();

mysql_pconnect("host", "user","pass") or die("Ci Scusiamo Per l'incoveniente tornero on-line tra 10 minuti");
mysql_select_db("tuodatabse") or die("Impossibile selezionare il database");

$query = "SELECT * FROM VB_thread WHERE forumid=1 ORDER BY threadid DESC LIMIT 20";
$risultati= mysql_query($query);

$conta=0;
while($tmp = mysql_fetch_assoc($risultati))
{
$threadrow = $tmp;
$conta++;
$target1=$tmp["title"];
$replycount=$tmp["replycount"];
$postusername=$tmp["postusername"];
$postuserid=$tmp["postuserid"];
$lastposter=$tmp["lastposter"];
$views=$tmp["views"];
$valutazione=$tmp["votetotal"];

if($start>=0){
$threadurl = vbseo_thread_url_row($threadrow, $start);
}else{
$threadurl = vbseo_thread_url_row($threadrow);
}

$getprofile = mysql_query("SELECT * FROM VB_user WHERE userid =".$postuserid);
$conta=0;

while($tmp = mysql_fetch_assoc($getprofile))
{
$profilerow = $tmp;
$conta++;
}

$profileurl = "members/".$profilerow['username'].".html";
$profileurl = strtolower($profileurl);
echo"<tr><td align=\"left\"><a href=\"http://www.sito.it/forums/$threadurl\">$target1</a> </td><td> $postusername </td><td > $replycount </td><td > $views</td><tr>";
}

echo " </table> ";

The result must be as this! Link

But on my site it's don't work : Link

Please, Where is the error?

Sorry for my bad english

Thanks friends

Oleg Ignatiuk · #2 01-14-2007, 10:37 PM

Hello,

is this forum id correct ?

PHP Code:

  $query = "SELECT * FROM VB_thread WHERE forumid=1 ORDER BY threadid DESC LIMIT 20";

jarod1981® · #3 01-14-2007, 11:03 PM

Hi Oleg!

Pardon, I have change that string in:

Quote:

$query = "SELECT * FROM VB_thread WHERE forumid=12 ORDER BY threadid DESC LIMIT 20";

12 = Software Freeware

But...Nada

Oleg Ignatiuk · #4 01-14-2007, 11:09 PM

The problem doesn't seem to be related to vBSEO in this case - your sql query doesn't return any thread rows, you could try to execute this query in phpmyadmin or vB admincp to check it further.

jarod1981® · #5 01-14-2007, 11:13 PM

Mmm okey Oleg, I try to execute query in phpmyadmin

Very thanks for your kind ;-)

Bye!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sitemap alırken hata alıyorum :(	erhanerhan_5	Türkçe	9	11-15-2006 09:44 AM
i think something is wrong....	briansol	General Discussion	3	08-20-2006 07:10 PM
Seiten im google Index, gibts eine Faustformel?	fade	Deutsch	8	08-15-2006 05:10 AM
Compression Error	Lazer	Troubleshooting	19	03-03-2006 02:23 PM

SEO

Static Pages with vSeo url

Static Pages with vSeo url

Similar Threads