session_save_path("/home/users/web/b2992/glo.dkapla2/cgi-bin/tmp");
session_start();
require_once('include/config.php');
require_once('include/lib-database.php');
require_once('include/lib-master-database.php');
require_once('include/lib-custom-database.php');
require_once('include/lib-layout.php');
require_once('include/lib-forms.php');
require_once('include/lib-super-forms.php');
// validate user
function validateUser() {
global $_CONF;
$sql = "SELECT * FROM users WHERE username = '{$_POST['username']}' AND passwd = PASSWORD('{$_POST['passwd']}')";
$result = fetchMDbRow($sql);
if ($result) {
$sql2 = "SELECT * FROM tourneylist where uid = '{$result['uid']}' AND tnid = '{$_CONF['Tourney_ID']}'";
//echo $sql2;
$exsists = fetchMDbRow($sql2);
if ($exsists) {
$_SESSION['validated_user'] = $result['uid'];
return true;}
else {
return true;
}
}
else return false;
}
// validate admin
function validateAdmin() {
$sql = "SELECT * FROM admin WHERE username = '{$_POST['username']}' AND passwd = PASSWORD('{$_POST['passwd']}')";
$result = fetchDbRow($sql);
if ($result) {
$_SESSION['validated_admin'] = $result['uid'];
return true;
}
else return false;
}
// validate Admin user for page
function validateUserPage () {
global $_CONF;
if ($_SESSION['validated_admin']) {
$sql = "SELECT * FROM admin WHERE uid = {$_SESSION['validated_admin']}";
$userinfo = fetchDbRow($sql);
return $userinfo;
}
else {
session_destroy();
header("Location: {$_CONF['site_url']}", false); /* Redirect browser */
}
}
// validate admin
function validateSuperAdmin() {
$sql = "SELECT * FROM admin WHERE username = '{$_POST['username']}' AND passwd = PASSWORD('{$_POST['passwd']}')";
$result = fetchMDbRow($sql);
if ($result) {
$_SESSION['validated_superadmin'] = $result['uid'];
$_SESSION['validated_admin'] = $result['uid'];
return true;
}
else return false;
}
// validate Super Admin for page
function validateSuperUserPage () {
global $_CONF;
if ($_SESSION['validated_superadmin']) {
$sql = "SELECT * FROM admin WHERE uid = {$_SESSION['validated_superadmin']}";
$userinfo = fetchMDbRow($sql);
return $userinfo;
}
else {
session_destroy();
header("Location: {$_CONF['site_url']}", false); /* Redirect browser */
}
}
// validate user for page
function validatePage () {
global $_CONF;
if ($_SESSION['validated_user']) {
$sql = "SELECT * FROM users WHERE uid = {$_SESSION['validated_user']}";
$userinfo = fetchMDbRow($sql);
return $userinfo;
}
else {
session_destroy();
header("Location: {$_CONF['site_url']}", false); /* Redirect browser */
}
}
// logoff user
function logOff () {
global $_CONF;
session_destroy();
header("Location: {$_CONF['site_url']}/index.php?msg=logoff"); /* Redirect browser */
}
// general DB var request
function getDbVar ($var_name) {
$sql = "SELECT * FROM vars WHERE var_name IN ('{$var_name}')";
$result = fetchDbRow($sql);
return $result['var_value'];
}
// get site lock status
function lockStatus () {
$sql = "SELECT * FROM vars WHERE var_name IN ('site_lock')";
$result = fetchDbRow($sql);
if ($result['var_value'] == '0') return "unlocked";
else return "locked";
}
// toggle site lock
function toggleLock () {
$sql = "SELECT * FROM vars WHERE var_name IN ('site_lock')";
$result = fetchDbRow($sql);
if ($result['var_value'] == '0') $new_val = '1';
else $new_val = '0';
$sql = "UPDATE vars SET var_value = '{$new_val}' WHERE var_name = 'site_lock'";
$result = dbQuery($sql);
}
// get site showwrestler status
function showwrestlerStatus () {
$sql = "SELECT ShowWr FROM vars";
$result = fetchDbRow($sql);
if ($result['ShowWr'] == '0') return "hidden";
else return "visible";
}
function showseedStatus () {
$sql = "SELECT ShowSd FROM vars";
$result = fetchDbRow($sql);
if ($result['ShowSd'] == '0') return "hidden";
else return "visible";
}
//toggle show wrestler
function toggleshowwrestler () {
$sql = "SELECT ShowWr FROM vars";
$result = fetchDbRow($sql);
if ($result['ShowWr'] == '0') $new_val = '1';
else $new_val = '0';
$sql = "UPDATE vars SET ShowWr = '{$new_val}'";
$result = dbQuery($sql);
}
function toggleshowseeds () {
$sql = "SELECT ShowSd FROM vars";
$result = fetchDbRow($sql);
if ($result['ShowSd'] == '0') $new_val = '1';
else $new_val = '0';
$sql = "UPDATE vars SET ShowSd = '{$new_val}'";
$result = dbQuery($sql);
}
// get team lock status
function teamLockStatus ($tid) {
$sql = "SELECT locked FROM team WHERE tid={$tid}";
$result = fetchDbRow($sql);
if ($result['locked'] == '0') return "unlocked";
else return "locked";
}
// toggle the team lock
function toggleTeamLock ($tid,$email) {
global $_CONF;
$sql = "SELECT locked FROM team WHERE tid={$tid}";
$result = fetchDbRow($sql);
if ($result['locked'] == '0')
{
$new_val = '1';
$subject = "Roster Submitted";
$message = "You have successfuly submitted your roster. You may unlock and change your roster up unitl " .$_CONF['LockDate']. ". Please relock your roster if you unlock your roster.";
}
else
{
$new_val = '0';
$subject = "Roster Unlocked";
$message = "You have unlocked your roster. You may continue to change your roster up unitl " .$_CONF['LockDate']. ". Please relock your roster when you are finished.";
}
$sql = "UPDATE team SET locked='{$new_val}' WHERE tid={$tid}";
$result = dbQuery($sql);
$to = $email;
$from = $_CONF['seedingemail'];
$headers = "From: $from\r\n";
$headers .= "CC: ".$_CONF['seedingemail']."\n";
mail($to,$subject,$message,$headers);
//echo $email;
}
// contatenate phone number fields into one text string suitable for upload to DBB
function implodePhone($var_name) {
if ($_POST[$var_name.'1'] == '') return '';
return "(".$_POST[$var_name.'1'].") ".$_POST[$var_name.'2']."-".$_POST[$var_name.'3'];
}
// expand telephone string from DB to three fields to use in forms
function explodePhone($var_name) {
if (strlen($var_name) < 14) return array('','','');
$phone[] = substr($var_name, 1, 3);
$phone[] = substr($var_name, 6, 3);
$phone[] = substr($var_name, 10, 4);
return $phone;
}
// return SQL ORDER BY commands based on GET sort code
function sqlSort ($sort_code) {
switch ($sort_code) {
case "team_asc" :
return "team.name ASC";
case "team_desc" :
return "team.name DESC";
case "code_asc" :
return "team.code ASC";
case "code_desc" :
return "team.code DESC";
case "coach_asc" :
return "users.coach_name ASC";
case "coach_desc" :
return "users.coach_name DESC";
case "dirname_asc" :
return "team.dir_name ASC";
case "dirname_desc" :
return "team.dir_name DESC";
case "contact_asc" :
return "users.contact_name ASC";
case "contact_desc" :
return "users.contact_name DESC";
case "class_asc" :
return "wrestlers.cid ASC";
case "class_desc" :
return "wrestlers.cid DESC";
case "name_asc" :
return "wrestlers.name ASC";
case "name_desc" :
return "wrestlers.name DESC";
}
}
// add sort arrows for column sorting
function columnSort ($column, $current_sort) {
global $_CONF;
$ret_val = "";
$up = '';
$down = '';
switch ($column) {
case "team" :
if ($current_sort != "team_asc" && $current_sort != NULL) $ret_val .= ''.$up.'';
if ($current_sort != "team_desc") $ret_val .= ''.$down.'';
break;
case "code" :
if ($current_sort != "code_asc") $ret_val .= ''.$up.'';
if ($current_sort != "code_desc") $ret_val .= ''.$down.'';
break;
case "coach" :
if ($current_sort != "coach_asc") $ret_val .= ''.$up.'';
if ($current_sort != "coach_desc") $ret_val .= ''.$down.'';
break;
case "dirname" :
if ($current_sort != "dirname_asc") $ret_val .= ''.$up.'';
if ($current_sort != "dirname_desc") $ret_val .= ''.$down.'';
break;
case "contact" :
if ($current_sort != "contact_asc") $ret_val .= ''.$up.'';
if ($current_sort != "contact_desc") $ret_val .= ''.$down.'';
break;
case "class" :
if ($current_sort != "class_asc" && $current_sort != NULL) $ret_val .= ''.$up.'';
if ($current_sort != "class_desc") $ret_val .= ''.$down.'';
break;
case "name" :
if ($current_sort != "name_asc") $ret_val .= ''.$up.'';
if ($current_sort != "name_desc") $ret_val .= ''.$down.'';
break;
}
return $ret_val;
}
// used to calculate the ranking of a wrestler
function calcRank($W) {
global $_CONF;
for ($i=0; $i $b["'.$key.'"]) ? -1 : 1;}');
usort($tab,$compare) ;
return $tab;
}
function multi_var_sort($tab,$key,$key2,$reverse=""){
If ($reverse == ""){
$compare = create_function('$a,$b','if ($a["'.$key.'"] == $b["'.$key.'"]) {if ($a["'.$key2.'"] == $b["'.$key2.'"]) {return 0;}else {return ($a["'.$key2.'"] > $b["'.$key2.'"]) ? -1 : 1;}}else {return ($a["'.$key.'"] < $b["'.$key.'"]) ? -1 : 1;}');
}
else $compare = create_function('$a,$b','if ($a["'.$key.'"] == $b["'.$key.'"]) {if ($a["'.$key2.'"] == $b["'.$key2.'"]) {return 0;}else {return ($a["'.$key2.'"] < $b["'.$key2.'"]) ? -1 : 1;}}else {return ($a["'.$key.'"] < $b["'.$key.'"]) ? -1 : 1;}');
usort($tab,$compare) ;
return $tab;
}
?>
Tournament Seeding Login
Tournament Seeding Login