The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Code:
<? /* declare some relevant variables */ $DBhost = ""; $DBuser = ""; $DBpass = ""; $DBName = ""; $DBForum = ""; $DBLimit = ""; $DBLink = ""; /* 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"); $time3 = date("M d Y",$time); $storyquery = "SELECT pagetext FROM post where threadid = $theid order by dateline limit 0,1"; $storyres = mysql_query("$storyquery"); $story = mysql_result($storyres,"pagetext"); $title = str_replace("[","<",$title); $title = str_replace("]",">",$title); $story = str_replace("[","<",$story); $story = str_replace("]",">",$story); echo("<TABLE CELLSPACING="0" CELLPADDING="8" WIDTH="100%" ALIGN="center" BORDER="0"><TR><TD valign='top'><TABLE CELLSPACING="3" CELLPADDING="3" WIDTH="100%" ALIGN="NONE" BORDER="0"><TR bgcolor='#000000'><TD bgcolor='#181c28'><font face="Verdana" size="4" color="#FFFFFF"> <a href=$DBLink=$theid>$title</a></font><font face="Verdana" size="1" color="#D8D0AD">" - Posted By: </font><font face="Verdana" size="1" color="#D8D0AD"> <a href="mailto:sqlboy@playway.net">$name</a></font><font face="Verdana" size="1" color="#D8D0AD">@ $time3 - </b></font></TD></TR></TABLE><TABLE CELLSPACING="0" CELLPADDING="5" WIDTH="100%" ALIGN="NONE" BORDER="0"><TR><TD width='100%' valign='top'><font face="Verdana" size="2" color="#FFFFFF"><DIV ALIGN="left" CLASS="main">$story</TD></TR></TABLE>"); print "<p>Title: <A href=$DBLink=$theid>$title</a> <br>Story: $story <br>posted by: $name <br>posted on: $time3 "; $i++; } } ?> |
#2
|
|||
|
|||
Is this part of vbb2.0? or is this some form of .php page you are creating...
cause here is what I do.. I add \"something\" ( \ ) infront of the "'s.. Code:
echo("<TABLE CELLSPACING=\"0\" CELLPADDING=\"8\" WIDTH=\"100%\" ALIGN=\"center\" BORDER=\"0\"><TR><TD valign='top'><TABLE CELLSPACING=\"3\" CELLPADDING=\"3\" WIDTH=\"100%\" ALIGN=\"NONE\" BORDER=\"0\"><TR bgcolor='#000000'><TD bgcolor='#181c28'><font face=\"Verdana\" size=\"4\" color=\"#FFFFFF\"> and umm .. could you copy and paste your errors you are getting? |
#3
|
||||
|
||||
You will need to escape all quote marks in any echo blocks as so:
PHP Code:
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|