I'm looking to make or get some help here on how to make a module with the widget code provided with vB Clan Wars.
Here is the code:
Code:
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;
I haven't a clue how to get it working I've tried a .php module but no luck it just throws up errors on my site. Can someone possibly help ? I'm stuck here.
Thanks