Need Hack : lat 10 posts in a marquee

I need the hack that shows the last 10 posts in a marquee at the top of the forum .

Does anyone know from where to get it ?

[Stasik]

we have to check ther threadid in thread table and get the forumid from there

[ozone2000]

FireFly, can you make it look like this:
http://www.dynamicdrive.com/dynamicindex2/crosstick.htm
... then that'll be cool!

[WebMasterAJ]

How would you make it show just the thread, and not the posts?

Other than that, this is pretty cool

[Admin]

webhost:

PHP Code:

<?php

error_reporting(7);

require("./global.php");

$latestposts=$DB_site->query("SELECT post.postid AS id,LEFT(post.pagetext,20) AS text FROM post LEFT JOIN thread ON thread.threadid WHERE thread.forumid<>14 AND thread.forumid<>43 AND thread.forumid<>87 GROUP BY post.postid ORDER BY post.dateline DESC LIMIT 10");
$marquee = "";
while ($latestpost=$DB_site->fetch_array($latestposts)) {
  if ($marquee) {
    $marquee .= "&nbsp;&nbsp;";  // String to seperate between each link
  }
  $marquee .= "<a href=\"showthread.php?s=$session[sessionhash]&postid=$latestpost[id]\">$latestpost[text] ...</a>";
}
?>
<? echo("$marquee"); ?>

(working)

[WebMasterAJ]

hmmm... thanks, but for some reason its not showing the title of the thread, it just shows ...

Any ideas?

[Admin]

AJ, I don't understand. You want the latest 10 threads' titles to be displayed?
If so, use this:

PHP Code:

<?php

error_reporting(7);

require("./global.php");

$latestposts=$DB_site->query("SELECT threadid,title FROM thread ORDER BY dateline DESC LIMIT 10");
$marquee="";
while ($latestpost=$DB_site->fetch_array($latestposts)) {
  if ($marquee) {
    $marquee .= "&nbsp;&nbsp;";  // String to seperate between each link
  }
  $marquee .= "<a href=\"showthread.php?s=$session[sessionhash]&threadid=$latestpost[threadid]\">$latestpost[title] ...</a>";
}
?>
<marquee-code-here value="<? echo("$marquee"); ?>">

[WebMasterAJ]

AWESOME... thanks

[Admin]

No problem.

ozone2000:
I'll get to you when I fix webhost's version.

[webhost]

Firefly

I get this error now

Database error in vBulletin: Invalid SQL: SELECT post.postid,LEFT(post.pagetext,20) FROM post LEFT JOIN thread ON thread.threadid WHERE thread.forumid<>30 AND thread.forumid<>33 AND thread.forumid<>38 ORDER BY post.dateline DESC LIMIT 10
mysql error: Got error 28 from table handler
mysql error number: 1030
Date: Monday 03rd of September 2001 10:51:55 AM
Script: /marquee.php
Referer:

[Admin]

That's wierd, it's working perfect for me.