Hello to all

[INCARA]

Hi everyone,

I am from Turkey, Istanbul. I had a break from forums for 4-5 years and now trying to return
I have a question, probably I will send it to the right forum but shortly mention here. I have 2 websites, one vb5 and the other is php-nuke. I was showing my forums latest 10 messages (in vb4) in a table block of my php-nuke website. After vb5 it couldnt work. Is there any idea how can I do it?
Thanks.

Irfan

A part of my php file is;

if ($forum_id) {
$forumid = "AND forumid=$forum_id";
}
else {
if ($yasak_id) {
$yasak_id = explode(",",$yasak_id);
for ($i=0;$i<count($yasak_id);$i++)
$forumid .= " AND forumid<>$yasak_id[$i]";
}
}

if ($limit) {
$limited = "LIMIT $limit";
}
$thread_sql = mysql_query("SELECT threadid,title,lastpost,postusername,lastposter,replycount,views FROM thread WHERE visible=1 AND open=1 $forumid ORDER BY lastpost DESC $limited");
while($thread_get=mysql_fetch_array($thread_sql))
{
$postusername = $thread_get['postusername'];
$lastpost = $thread_get['lastpost'];
$poster = $thread_get['lastposter'];
$tid = $thread_get['threadid'];
$view = $thread_get['views'];
$reply = $thread_get['replycount'];
$psql = mysql_query("SELECT postid FROM post WHERE threadid=$tid ORDER BY postid DESC");
$getp=mysql_fetch_array($psql);
$pid = $getp['postid'];
$date2 = date ("m/d/y h:i" ,$lastpost);
$title = $thread_get['title'];
$title = substr($title,0,$txtlimit);
echo "  

[glennrocksvb]

Hi, welcome to the forums!

The database structure has changed from vB4 to vB5. All posts and channels are now in the node table. There is no thread or post table and the columns are different.

[INCARA]

Thank you for quick response. Where can I ask to this question or this is a subject out of VB Mod?
I need this and I can pay for it, if it is possible. Thanks.

[glennrocksvb]

I can help you on this privately. I assume php-nuke is in the same server as vB5? And the PHP code you posted is running on php-nuke?

Send me a PM to proceed.