<?
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 = '<img src="' . $_CONF['images_url'] . 'up.png" alt="Sort Ascending" width="16" height="16" border="0" align="absmiddle">'; 
	$down = '<img src="' . $_CONF['images_url'] . 'down.png" alt="Sort Descending" width="16" height="16" border="0" align="absmiddle">';
	
	switch ($column) {
	case "team" :
		if ($current_sort != "team_asc" && $current_sort != NULL) $ret_val .= '<a href="#" onClick="form1.sort.value=\'team_asc\'; form1.submit();">'.$up.'</a>';
		if ($current_sort != "team_desc") $ret_val .= '<a href="#" onClick="form1.sort.value=\'team_desc\'; form1.submit();">'.$down.'</a>';		
		break;
	case "code" :
		if ($current_sort != "code_asc") $ret_val .= '<a href="#" onClick="form1.sort.value=\'code_asc\'; form1.submit();">'.$up.'</a>';
		if ($current_sort != "code_desc") $ret_val .= '<a href="#" onClick="form1.sort.value=\'code_desc\'; form1.submit();">'.$down.'</a>';		
		break;
	case "coach" :
		if ($current_sort != "coach_asc") $ret_val .= '<a href="#" onClick="form1.sort.value=\'coach_asc\'; form1.submit();">'.$up.'</a>';
		if ($current_sort != "coach_desc") $ret_val .= '<a href="#" onClick="form1.sort.value=\'coach_desc\'; form1.submit();">'.$down.'</a>';		
		break;
	case "dirname" :
		if ($current_sort != "dirname_asc") $ret_val .= '<a href="#" onClick="form1.sort.value=\'dirname_asc\'; form1.submit();">'.$up.'</a>';
		if ($current_sort != "dirname_desc") $ret_val .= '<a href="#" onClick="form1.sort.value=\'dirname_desc\'; form1.submit();">'.$down.'</a>';		
		break;
	case "contact" :
		if ($current_sort != "contact_asc") $ret_val .= '<a href="#" onClick="form1.sort.value=\'contact_asc\'; form1.submit();">'.$up.'</a>';
		if ($current_sort != "contact_desc") $ret_val .= '<a href="#" onClick="form1.sort.value=\'contact_desc\'; form1.submit();">'.$down.'</a>';		
		break;
	case "class" :
		if ($current_sort != "class_asc" && $current_sort != NULL) $ret_val .= '<a href="#" onClick="form1.sort.value=\'class_asc\'; form1.submit();">'.$up.'</a>';
		if ($current_sort != "class_desc") $ret_val .= '<a href="#" onClick="form1.sort.value=\'class_desc\'; form1.submit();">'.$down.'</a>';		
		break;
	case "name" :
		if ($current_sort != "name_asc") $ret_val .= '<a href="#" onClick="form1.sort.value=\'name_asc\'; form1.submit();">'.$up.'</a>';
		if ($current_sort != "name_desc") $ret_val .= '<a href="#" onClick="form1.sort.value=\'name_desc\'; form1.submit();">'.$down.'</a>';		
		break;

	}

	return $ret_val;

}

// used to calculate the ranking of a wrestler
function calcRank($W) {
        global $_CONF;
	for ($i=0; $i<sizeof($W); $i++) {              
		if (($W[$i]['current_win'] + $W[$i]['current_loss']) == 0) $rank = -999;
		else $rank = round((($W[$i]['current_win']) / ($W[$i]['current_win'] + $W[$i]['current_loss']) + ($W[$i]['current_win'] + $W[$i]['current_loss']) / 150) * 1000, 2);
                
                if (($W[$i]['prev_win'] + $W[$i]['prev_loss']) == 0) $prank = -1;
                else $prank = round((($W[$i]['prev_win']) / ($W[$i]['prev_win'] + $W[$i]['prev_loss']) + ($W[$i]['prev_win'] + $W[$i]['prev_loss']) / 150) * 300, 2);		

               If ($_CONF['Mass']){                 
                    $placement = (2401000*(7-converter($W[$i]['nationals'])))+(343000*(7-converter($W[$i]['newengland'])))+(49000*(8-converter($W[$i]['allstate'])))+(7000*(8-converter($W[$i]['states'])))+(1000*(6-converter($W[$i]['sectionals'])));
               }
               else $placement = 0;
               
		$W[$i]['rank'] = $rank + $placement + $prank;
               
	}	 
	return $W;
}

function converter($S) {
    If (($S == "")||($S==0)) $S=7;
    return $S;
}

function multi_sort($tab,$key){
   $compare = create_function('$a,$b','if ($a["'.$key.'"] == $b["'.$key.'"]) {return 0;}else {return ($a["'.$key.'"] > $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;
}
?><html>
	<head>
	<title> Tournament Seeding Login</title>
	<link href="style.css" rel="stylesheet" type="text/css">
	</head>
	<body onLoad="login.username.focus();">
	<center>
        <h1> Tournament Seeding Login
        </h1>
    	<img src="images/seedingsubmit.gif" alt="" width="342" height="224" border="0"> 
	    <form name="login" id="login" action="index.php" method="post">
    	    <table border="0">
	            <tr>
    	            <td> Login:</td>
        	        <td> <input type="text" name="username" size="10"></td>
	            </tr>
    	        <tr>
        	        <td> Password:</td>
            	    <td> <input type="password" name="passwd" size="10"></td>
	            </tr>
    	    </table>
	        <input type="submit" name="cmd_submit" value="Submit">
	    </form></center>
	</body>
	</html>