I now have it working with the actual story content and posting the date as well. It is still just the one php file and a call from another page (if you want..) Yeha! Took me two days to hack together from not knowing any php or sql... god I like php... It's so easy. ( realativly)

You will probably want to edit the way it displays the ripped stories, that's easy enough if you are carefull and just play in the print output...

Remember if you want you can turn on html in the forum you are using and then post pictures etc... I sugest making that forum require moderator authorization if you use this though, to prevent peopel from posting things that would mess up your board.


Here's the final version: I'll call it VBul News Ripper 1.0

<?
/* declare some relevant variables */

$DBhost = "your server name or ip";
$DBuser = "the user name for the server";
$DBpass = "the pass word for the server";
$DBName = " the name of the database you're useing for vbulletin";
$DBForum = "The number of the forum you want to use to post news";
$DBLimit = "The number or stories to rip";
$DBLink = "Path to your showthread exp: forums/showthread.php?threadid";

/* don't mess with this one it should be the same for all vbulletins */

$DBTable = "thread";

/* do some story ripping... */

mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable toconnect to database");
mysql_select_db("$DBName") or die("Unable to access the News");
$sqlquery = "SELECT * FROM $DBTable WHERE forumid = $DBForum ORDER by dateline DESC LIMIT 0,$DBLimit";
$result = mysql_query($sqlquery);
$number = mysql_numrows($result);

$i = 0;

if ($number < 1) {
print "<CENTER><P>There Is NO News!</CENTER>";
}
else {
while ($number > $i) {
$title = mysql_result($result,$i,"title");
$theid = mysql_result($result,$i,"threadid");
$name = mysql_result($result,$i,"postusername");
$time = mysql_result($result,$i,"dateline");
$time2 = unixtojd($time);
$time3 = jdtogregorian($time2);
$storyquery = "SELECT pagetext FROM post where threadid = $theid order by dateline limit 0,1";
$storyres = mysql_query("$storyquery");
$story = mysql_result($storyres,"pagetext");


print "<p>Title: <A href=$DBLink=$theid>$title</a> <br>Story: $story <br>posted by: $name <br>posted on: $time3

";
$i++;
}
}

?>