Forum module - topics in forum:

Blocks 7x - Discussions regarding PHP-Nuke Blocks. 7x

Help with randomness of block

Heres the code so far. How can I get the

Code: :

/Input the team id here for the team you would like to display

$teamid = 2;

part of the script to pull a random team from the database??
Any help would be great!! Thanks in advance.

Code: :

<?php

if (eregi("block-BattleMenu.php", $_SERVER['PHP_SELF'])) {
Header("Location: index.php");
die();
}

global $prefix, $db, $bgcolor1, $bgcolor2, $bgcolor3, $bgcolor4, $textcolor1, $textcolor2;

//Input the team id here for the team you would like to display

$teamid = 2;

//Module linkage
$module_name="Battles";
$integration_url="modules.php?name=$module_name";

///////////////////////////////////////////////////////////////
//Let's get everything we need from the team id inserted above
///////////////////////////////////////////////////////////////
//get team name
$query = "select * from ".$prefix."_teams where team_id = $teamid";
$queryrs = $db->sql_query($query);
$rs = $db->sql_fetchrow($queryrs);
$teamname = $rs['name'];
//get ladder id's and the records for each ladder for the team id inserted above
$query = "select * from ".$prefix."_ladderteams where team_id = $teamid";
$queryrs = $db->sql_query($query);
for($emp=0;$rs = $db->sql_fetchrow($queryrs);$emp++) {
$ladders[$emp]['ladderid']=$rs['ladder_id'];
$records[$emp]['ladderid']=$rs['ladder_id'];
$records[$emp]['wins']=$rs['wins'];
$records[$emp]['losses']=$rs['losses'];
$records[$emp]['streakwin']=$rs['streakwins'];
$records[$emp]['streakloss']=$rs['streaklosses'];
//get rank
$query1="select * from ".$prefix."_ladders where sid = ".$rs['ladder_id']."";
$queryrs1=$db->sql_query($query1);
$rs1 = $db->sql_fetchrow($queryrs1);
$sortby1 = str_replace("[", "", $rs1["standingstype"]);
$sortby = str_replace("]", "", $sortby1);
$query2="select * from ".$prefix."_ladderteams where ladder_id = ".$rs['ladder_id']." order by $sortby DESC";
$queryrs2=$db->sql_query($query2);
for($emp2=1;$rs2 = $db->sql_fetchrow($queryrs2);$emp2++) {
if ($rs2['name'] == $teamname) {
$records[$emp]['rank']=$emp2;
}
}
}
//get ladder names for the ladder id's retrieved above
$cnt=0;
foreach($ladders as $lads) {
$query = "select * from ".$prefix."_ladders where sid = ".$lads['ladderid']."";
$queryrs = $db->sql_query($query);
for($emp=0;$rs = $db->sql_fetchrow($queryrs);$emp++) {
$ladders[$cnt]['laddername']=$rs['title'];
}
$cnt++;
}

///////////////////////////////////////////////////////////////
//Now let's start our output for the block
//This is where you would want to make it how you
//want it to look
///////////////////////////////////////////////////////////////
$content .= "<center>
TeamName: ".$teamname."
 
Competitions:
 ";
foreach($ladders as $lads) {
$content .= " ";
$content .= "".$lads['laddername']."";
$content .= " ";
foreach ($records as $recs) {
if ($recs['ladderid'] == $lads['ladderid']) {
$content .= "Rank: ".$recs['rank'];
$content .= " ";
$content .= "Record: ".$recs['wins']."/".$recs['losses'];
$content .= " ";
$content .= "Streakwins: ".$recs['streakwin'];
$content .= " ";
$content .= "Streaklosses: ".$recs['streakloss'];
$content .= " ";
}
}
}
$content .= "</center>";

?>

Forum module - topics in forum:

Search from web