Vick98
05-02-2011, 08:14 AM
I have recently added a clan wars module to my website. In the package there is a php code that is used to create a forum widget. I use vBadvanced and need the php code to be converted to a bb code so I can create a new module for the home page. Could someone help convert this code or give me some directions on how this could be done? Thank you in advance for your help and assistance.
global $db;
$wconf = $db->fetch_array($db->query_read("SELECT colorbox, formatblock FROM ".TABLE_PREFIX."clan_wars_config"));
$lastwars = "<center><table cellpadding='0' cellspacing'0' border='0' class='lastwarstable' width='90%'>";
$result5 = $db->query_read("SELECT opp_tag, wid, wardate FROM ".TABLE_PREFIX."clan_wars WHERE status='0' AND active='1' ORDER BY wardate ASC LIMIT 5");
if($db->num_rows($result5) > 0){
$lastwars .= "<tr>
<td align='left' colspan='2'><b>Upcoming Wars</b></td>
</tr>";
while($row5 = $db->fetch_array($result5)){
$wid = $row5['wid'];
$opp_tag = $row5['opp_tag'];
$wardate = $row5['wardate'];
$lastwars .= "<tr>
<td align='left'><a href='clanwars.php?do=Details&wid=$wid'>$opp_tag</a></td>
<td width='20%' align='center'><b>".date($wconf['formatblock'], $wardate)."</b></td>
</tr>";
}
}
//Last Wars
$result6 = $db->query_read("SELECT opp_tag, wid, opp_score, our_score FROM ".TABLE_PREFIX."clan_wars WHERE status='1' AND active='1' ORDER BY wardate DESC LIMIT 5");
if($db->num_rows($result6) > 0){
$lastwars .= "<tr>
<td align='left' colspan='2'><b>Last Wars</b></td>
</tr>";
while($row5 = $db->fetch_array($result6)){
$wid = $row5['wid'];
$opp_tag = $row5['opp_tag'];
$our_score = $row5['our_score'];
$opp_score = $row5['opp_score'];
$wconf = $db->fetch_array($db->query_read("SELECT colorbox FROM ".TABLE_PREFIX."clan_wars_config"));
if($wconf['colorbox']){
//Colored boxes
if ($our_score > $opp_score) {
$tdcolor ='#009900';
}else if ($our_score < $opp_score) {
$tdcolor ='#990000';
}else {
$tdcolor ='#3333FF';
}
$tdcolor = 'style="background:'.$tdcolor.' url();"';
$fontcolor ='#FFFFFF';
}else{
//Colored Text
if ($our_score > $opp_score){
$fontcolor = "#009900";
}elseif($our_score < $opp_score){
$fontcolor = "990000";
}else{
$fontcolor = "#3333FF";
}
$tdcolor ='';
}
$lastwars .= "<tr>
<td align='left'><a href='clanwars.php?do=Details&wid=$wid'>$opp_tag</a></td>
<td width='20%' $tdcolor align='center'><font color='$fontcolor'><b>$our_score/$opp_score</b></font></td>
</tr>";
}
}
$lastwars .= "</table></center>";
$output = $lastwars;
global $db;
$wconf = $db->fetch_array($db->query_read("SELECT colorbox, formatblock FROM ".TABLE_PREFIX."clan_wars_config"));
$lastwars = "<center><table cellpadding='0' cellspacing'0' border='0' class='lastwarstable' width='90%'>";
$result5 = $db->query_read("SELECT opp_tag, wid, wardate FROM ".TABLE_PREFIX."clan_wars WHERE status='0' AND active='1' ORDER BY wardate ASC LIMIT 5");
if($db->num_rows($result5) > 0){
$lastwars .= "<tr>
<td align='left' colspan='2'><b>Upcoming Wars</b></td>
</tr>";
while($row5 = $db->fetch_array($result5)){
$wid = $row5['wid'];
$opp_tag = $row5['opp_tag'];
$wardate = $row5['wardate'];
$lastwars .= "<tr>
<td align='left'><a href='clanwars.php?do=Details&wid=$wid'>$opp_tag</a></td>
<td width='20%' align='center'><b>".date($wconf['formatblock'], $wardate)."</b></td>
</tr>";
}
}
//Last Wars
$result6 = $db->query_read("SELECT opp_tag, wid, opp_score, our_score FROM ".TABLE_PREFIX."clan_wars WHERE status='1' AND active='1' ORDER BY wardate DESC LIMIT 5");
if($db->num_rows($result6) > 0){
$lastwars .= "<tr>
<td align='left' colspan='2'><b>Last Wars</b></td>
</tr>";
while($row5 = $db->fetch_array($result6)){
$wid = $row5['wid'];
$opp_tag = $row5['opp_tag'];
$our_score = $row5['our_score'];
$opp_score = $row5['opp_score'];
$wconf = $db->fetch_array($db->query_read("SELECT colorbox FROM ".TABLE_PREFIX."clan_wars_config"));
if($wconf['colorbox']){
//Colored boxes
if ($our_score > $opp_score) {
$tdcolor ='#009900';
}else if ($our_score < $opp_score) {
$tdcolor ='#990000';
}else {
$tdcolor ='#3333FF';
}
$tdcolor = 'style="background:'.$tdcolor.' url();"';
$fontcolor ='#FFFFFF';
}else{
//Colored Text
if ($our_score > $opp_score){
$fontcolor = "#009900";
}elseif($our_score < $opp_score){
$fontcolor = "990000";
}else{
$fontcolor = "#3333FF";
}
$tdcolor ='';
}
$lastwars .= "<tr>
<td align='left'><a href='clanwars.php?do=Details&wid=$wid'>$opp_tag</a></td>
<td width='20%' $tdcolor align='center'><font color='$fontcolor'><b>$our_score/$opp_score</b></font></td>
</tr>";
}
}
$lastwars .= "</table></center>";
$output = $lastwars;