News Hack script... [Archive]

Imperitus

03-20-2001, 05:47 PM

I was looking fro a news hack that would take the stories posted in a particular forum and rip them to post automaticly on my news page...

unfortunatly I haven't been able to find a simple script to do it that made sense to me. So I started looking into learning php and sql and making my own... :)

So here's the results so far:

--------

<html>
<head><title>News ripping script</title></head>
<body>

<?
/* 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";
$DBTable = "thread";
$DBForum = "The number of the forum you want to use to post news";

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

$i = 0;

if ($number < 1) {
print "<CENTER>There Were No Results for Your Search</CENTER>";
}
else {
while ($number > $i) {
$thename = mysql_result($result,$i,"title");
$theid = mysql_result($result,$i,"threadid");
$name = mysql_result($result,$i,"postusername");

print "<A href=forums/showthread.php?threadid=$theid>$thename</a> posted by: $name

";
$i++;
}
}
?>
</BODY></HTML>

--------

I then call it with the tag:

<?php include('news.php');?>

Pretty simple, and not too functional but it works and is easy to understand for a novice like me.

I'm going to try and get it to pull the content of the posts as well next... any comments?

03-20-2001, 05:50 PM

It has already been done...do a search for BFC_Weblog

03-20-2001, 06:04 PM

It was my understanding that that script was for the old vbulletin and that the new version vbshell or whatever was over kill for my simple needs... Maybe I'm wrong.

03-20-2001, 07:29 PM

If you search my posts on here you will find the first version of a script I wrote to do this using the features already in the vB code.

I have made quite a few improvments since then though, ie headlines, dailly top posters, polls... This will be a part of my complete site integration package I am writing for my site http://www.ravingaming.com. I will be releasing this code when it reaches a stage that I won't have to spend a lot of time supporting the code. But if you don't want to wait that long...

I suggest you first read through the /global.php, /admin/global.php, /admin/db_mysql.php, /functions.php and anything that is included in a good part of the files. If you include the /global.php you can do a lot more with your script, online users and the like. Plus you can use the class that is already written for interaction with the MySQL DB.

03-20-2001, 07:37 PM

Thanks for the tip. Yours was actualyt he script I was hoping to use... but my friends and I who are working on the site this is foar are impatient. :)

It's possible you're sill come out before I complet emine and I'll still use yours...

But in the mean time I'm using this project to learn php and sql... which I have never worked with before.

03-20-2001, 08:07 PM

Thanks for the news hack

Imperitus

03-20-2001, 08:21 PM

You're very welcome.

03-20-2001, 11:04 PM

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>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 "Title: <A href=$DBLink=$theid>$title</a> Story: $story posted by: $name posted on: $time3

";
$i++;
}
}

?>