New Posts show up in external website.
Mod Version: 1.00, by JacBowen
This modification is in the archives.
| vB Version: 3.6.8 | Rating:  (0 vote - 0 average) |
Installs: 5 |
| Released: 17 Aug 2007 | Last Update: Never | Downloads: 2 |
 Not Supported
|
||
Hey Guys,
Well I have been looking for something like this everywhere but just couldn't find it, being a basic coder I just couldn't get my head round it, but I tried my best and this is the outcome.
What is it?
Maybe you have a forum and a HTML/PHP website (externally) and you want it to show the latest post in a little navbit or what not, well this is the answer. It's something I whipped up in a few minutes so don't expect anything awesome.
It only shows the latest post, ideal for a little in line frame in the corner of your site.
| 2x Files
|- db.php
|- index.html
Ok, first you need to create a new PHP file called "db.php" (I advise something more harder to guess £*$&*hy8^5t) once done, put this code in. Make sure you edit it to your MYSQL settings.
After that create "index.php" or what ever you want to call it.
Then upload, make sure you change the file paths, like I said this is not good at all, but might come in handy for some. It is easy to install and I do expect to be making upgrades (to post more than 1 post etc).
You can add more info to the 'index.php' file, for example the IP address it was made posted by, by putting.
You can replace ipaddress and put anything, these are your options.
postid
threadid
parentid
username
userid
title
dateline
pagetext
allowsmilie
showsignature
ipaddress
iconid
visible
attach
infraction
reportthreadid
Have fun, I know this is a sort of bad mod so don't flame
. I am new to this and it's just the start .
Jac
Well I have been looking for something like this everywhere but just couldn't find it, being a basic coder I just couldn't get my head round it, but I tried my best and this is the outcome.
What is it?
Maybe you have a forum and a HTML/PHP website (externally) and you want it to show the latest post in a little navbit or what not, well this is the answer. It's something I whipped up in a few minutes so don't expect anything awesome.
It only shows the latest post, ideal for a little in line frame in the corner of your site.
| 2x Files
|- db.php
|- index.html
Ok, first you need to create a new PHP file called "db.php" (I advise something more harder to guess £*$&*hy8^5t) once done, put this code in. Make sure you edit it to your MYSQL settings.
PHP Code:
<?
$dbh=mysql_connect ("localhost", "YOUR_DB_USER", "YOUR_DB_PASS***WORD") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("YOUR_DB_NAME");
$mysql_table=post
?>
PHP Code:
<style type="text/css">
<!--
.style1 {
font-size: 12px;
font-weight: bold;
font-family: Verdana, Arial, Helvetica, sans-serif;
}
.style2 {
font-size: 11px;
font-family: Verdana, Arial, Helvetica, sans-serif;
font-style: italic;
}
body,td,th {
color: ffffff;
}
body {
background-color: #797979;
}
-->
</style>
<span class="style1">
<?
include("EDIT THE FILE PATH TO THE DB.php FILE");
$query = mysql_query("SELECT * FROM $mysql_table");
$query = mysql_query("SELECT * FROM `$mysql_table`
ORDER BY `postid` DESC
LIMIT 0 , 1");
if(mysql_error()) {
print(mysql_error());
}
while($row = mysql_fetch_array($query)) {
echo "
".$row['title']." -
".$row['username']."
<p>
";
}
?>
</span>
<span class="style2">
<?
include("EDIT THE FILE PATH TO THE DB.php FILE");
$query = mysql_query("SELECT * FROM $mysql_table");
$query = mysql_query("SELECT * FROM `$mysql_table`
ORDER BY `postid` DESC
LIMIT 0 , 1");
if(mysql_error()) {
print(mysql_error());
}
while($row = mysql_fetch_array($query)) {
echo "
".$row['pagetext']."
<p>
";
}
?>
</span>
Then upload, make sure you change the file paths, like I said this is not good at all, but might come in handy for some. It is easy to install and I do expect to be making upgrades (to post more than 1 post etc).
You can add more info to the 'index.php' file, for example the IP address it was made posted by, by putting.
PHP Code:
".$row['ipaddress']."
postid
threadid
parentid
username
userid
title
dateline
pagetext
allowsmilie
showsignature
ipaddress
iconid
visible
attach
infraction
reportthreadid
Have fun, I know this is a sort of bad mod so don't flame
. I am new to this and it's just the start .Jac
Download
No files for download.
Screenshots
