<?php

function active_users() {
	$mintime = date_unixtots(date_tstounix(now())-600);
	$sql = "SELECT DISTINCT tbl_userlog.log_name FROM tbl_userlog, tbl_employees WHERE tbl_userlog.log_name=tbl_employees.username AND tbl_userlog.log_stamp > '".$mintime."' ORDER BY tbl_userlog.log_name ASC";
	$res = mysql_query($sql);
	
	$ctr = 0;
	while ($row = mysql_fetch_array($res)) {
		$users[$ctr++] = $row["log_name"];
	}
	return $users;
}

function add_log($pt) {
	//if (whois() != "awaldron") {
		$sql = "INSERT INTO tbl_userlog (log_name,log_ip,log_page,log_title) VALUES ";
		$sql .= "('".whois()."','".GetHostByName($_SERVER["REMOTE_ADDR"])."','".self()."','".$pt."')";
		$res = mysql_query($sql);
		return 1;
	//}
}

function dbconnect() {
	$db = mysql_connect("localhost", "awaldron", "IamMine92");
    if (!$db) { return error("Could not connect to DB.<br>".mysql_error()); }
    else { mysql_select_db("awaldron_intrabreeze"); return ""; }
}

function dbVar($var) {
	return quickSQL("SELECT var_value FROM tbl_variables WHERE var_name='".$var."'");
}

function event_in() {
	$in = "";
	$sql1 = "SELECT DISTINCT A.event_id FROM tbl_event as A, tbl_event_su as B WHERE A.event_active=1 AND A.event_id=B.event_id AND B.esu_start > ".time()."";
	$sql2 = "SELECT DISTINCT A.event_id FROM tbl_event as A, tbl_event_is as B WHERE A.event_active=1 AND A.event_id=B.event_id";
	$sql3 = "SELECT DISTINCT A.event_id FROM tbl_event as A, tbl_event_rs as B WHERE A.event_active=1 AND A.event_id=B.event_id";
	$res1 = mysql_query($sql1);
	$res2 = mysql_query($sql2);
	$res3 = mysql_query($sql3);
	while ($row = mysql_fetch_array($res1)) $in .= ",".$row["event_id"];
	while ($row = mysql_fetch_array($res2)) $in .= ",".$row["event_id"];
	while ($row = mysql_fetch_array($res3)) $in .= ",".$row["event_id"];
	$in = substr($in,1);
	if (zero($in)) $in = "0";
	
	return $in;	
}

function forum_icon($ntid) {
	$nonew = "<img src=\"/gui/forums/no_new_posts.gif\" alt=\"No new posts\" title=\"No new posts\" />\n";
	$new = "<img src=\"/gui/forums/new_posts.gif\" alt=\"New posts since last visit\" title=\"New posts since last visit\" />\n";
	
	if (!is_logged()) { $last_visit = mktime(0,0,0,date("m"),date("d"),date("Y")); }
	else {	
		//$maxnrd = quickSQL("SELECT MAX(last_access) FROM tbl_notice_visits WHERE notice_type_id=".$ntid." AND username='".$_SESSION["auth_user"]."'");
		$max_ndr = quickSQL("SELECT MAX(last_access) FROM tbl_notice_visits WHERE notice_type_id=".$ntid." AND username='".$_SESSION["auth_user"]."'");

		$allread = get_allread();
		if ($allread !== FALSE) $last_visit = $allread;
		else $last_visit = time() - 1209600; //2419200 = 4 weeks; 1209600 = 2 weeks
		if ($max_ndr > $last_visit) $last_visit = $max_ndr;
	}
	$latest = quickSQL("SELECT MAX(latest_thread) FROM tbl_notices WHERE notice_type_id=".$ntid);
	if ($latest > $last_visit) return $new; //return $latest."<P>".$last_visit."<P>".$new;
	else return $nonew; //$latest."<P>".$last_visit."<P>".$nonew;
}

function forum_last_post($ntid) {
	$date = quickSQL("SELECT MAX(latest_thread) FROM tbl_notices WHERE notice_active=1 AND notice_type_id=".$ntid);
	if (zero($date)) return "No Posts";
	else return date("F j, Y h:i a",$date);
}

function forum_num_posts($ntid) {
	$notices = forum_num_topics($ntid);
	return $notices + (int)quickSQL("SELECT COUNT(A.thread_id) FROM tbl_threads as A, tbl_notices as B WHERE A.notice_id=B.notice_id AND B.notice_type_id=".$ntid." AND A.thread_active=1 AND B.notice_active=1");
}

function forum_num_topics($ntid) {
	return (int)quickSQL("SELECT COUNT(notice_id) FROM tbl_notices WHERE notice_type_id=".$ntid." AND notice_active=1");
}

function get_allread() {
	if (!is_logged()) return FALSE;
	else {
		return quickSQL("SELECT allread FROM tbl_notice_allread WHERE username='".$_SESSION["auth_user"]."'");
	}
}

function get_owners($p) {
	if ($p) {
		$super = section_admin($p);
		$sql = "SELECT username FROM tbl_page_owners WHERE page_id=".$p." ORDER BY username ASC";
		$res = mysql_query($sql);
		for ($i=0; $i < mysql_num_rows($res); $i++) {
			$row = mysql_fetch_array($res);
			$owners[$i] = $row["username"];
		}
		$merged = array_unique(array_merge($super,$owners));
		sort($merged);
		return $merged;
	}
}

function get_owners_gb($gb) {
	if ($gb) {
		$ownsql = "SELECT username FROM tbl_gb_owners WHERE gb_id=".$gb." ORDER BY username ASC";
		$ownres = mysql_query($ownsql);
		for ($i=0; $i < mysql_num_rows($ownres); $i++) {
			$row = mysql_fetch_array($ownres);
			$owners[$i] = $row["username"];
		}
		return array_unique($owners);
	}
}

function get_user($id,$return) {
	if ($return == "groupname") $q = "SELECT * FROM tbl_employees, tbl_groups WHERE tbl_employees.username='".$id."' AND tbl_employees.group_id=tbl_groups.group_id";
	else $q = "SELECT * FROM tbl_employees WHERE username='".$id."'";
	$r = mysql_query($q);
	$i = mysql_fetch_array($r);
	
	if ($return == "fullname") return $i["fname"]." ".$i["lname"];
	else if ($return == "fullname2") return $i["lname"].", ".$i["fname"];
	else if ($return == "username") return $i["username"];
	else if ($return == "groupname") return $i["group_name"];
	else if ($return == "email") return $i["email"];
	else if ($return == "ext") return substr($i["ph_direct"],-4);
	else return mysql_error();
}

function mysql_dump($sql) {
	$res = mysql_query($sql);
	$cols = 0;
	$keys = array();
	$out = "<P><b>Rows returned: ".mysql_num_rows($res)."</b><br><table border=0 cellspacing=1 cellpadding=4 bgcolor=#999999 style=\"font:11px Verdana;\">";
	for ($i=1; $row = mysql_fetch_assoc($res); $i++) {
		if ($i == 1) {
			$out .= "<tr bgcolor=#CCCCCC><td></td>\n";
			foreach ($row as $key => $val) { $out .= "<td><b>".$key."</b></td>\n"; $cols++; $keys[count($keys)] = $key; }
			$out .= "</tr>\n";
			reset($row);
		}
		
		$out .= "<tr bgcolor=#".($i%2==1?"FFFFFF":"EEEEEE").">\n";
		$out .= "<td>".$i."</td>\n";
		for ($j=0; $j < count($keys); $j++) {
			$out .= "<td>".$row[$keys[$j]]."</td>";
		} 
		$out .= "</tr>\n";
	}
	$out .= "</table>\n";
	if (mysql_num_rows($res) == 0) $out .= "<P>".mysql_error();
	return $out;
}

function new_window($link) {
	$exts = array("doc","dot","xls","xlt","pdf","ppt","txt");
	for ($i=0; $i < count($exts); $i++) {
		if (strstr($link,$exts[$i])) return true;
	}
	if (substr($link,0,1) == "/") return false;
	else if (strstr($link,DOMAIN)) return false;
	else if (strstr($link,"appserver")) return true;
	else return false;		
}

function owners($p) {
	$owners = get_owners($p);	
	$return = "Content Owner".(count($owners)>1?"s":"").": ";
	for ($i=0; $i < count($owners); $i++) {
		if ($i > 0) $return .= ", ";
		$return .= "<a href=\"/profile.php?u=".$owners[$i]."\">".$owners[$i]."</a>";
	}
	return $return;
}

function owners_pgroup($pgroup_id) {
	return "Content Owners: <b>".quickSQL("SELECT pgroup_name FROM tbl_pgroup WHERE pgroup_id=".$pgroup_id)."</b>";
}

function quickCOL($sql) {
	$res = mysql_query($sql);
	if (mysql_num_rows($res) > 0) {
		for ($i=0; $row = mysql_fetch_row($res); $i++) $arr[$i] = $row[0];
		return $arr;
	} else {
		//echo "\n<P>".$sql."\n<P>".mysql_error();
		return FALSE;
	}
}

function quickSQL($sql) {
	$res = mysql_query($sql);
	if (mysql_num_rows($res) == 1) {
		$row = mysql_fetch_row($res);
		return $row[0];
	} else {
		//echo "\n<P>".$sql."\n<P>".mysql_error();
		return FALSE;
	}
}

function quickUPDATE($sql) {
	if (mysql_query($sql) > 0) return TRUE;
	else return FALSE;
}

function quickRSET($sql) {
	$res = mysql_query($sql);
	if (mysql_num_rows($res) > 0) {
		for ($i=0; $row = mysql_fetch_assoc($res); $i++) {
			foreach ($row as $key => $val) $arr[$i][$key] = $val;
		}
		return $arr;
	} else {
		//echo "<P>".$sql."<P>".mysql_error();
		return array();
	}
}

function quickROW($sql) {
	$res = mysql_query($sql);
	if (mysql_num_rows($res) > 0) {
		$row = mysql_fetch_array($res);
		return $row;
	} else {
		echo mysql_error();
		return FALSE;
	}
}

/*
function section_admin($p) {
	$parent_id = quickSQL("SELECT parent_id FROM tbl_pages WHERE page_id=".$p);
	if ($parent_id < 1) return array();
	else if ($parent_id > 1) return section_admin($parent_id);
	else {
		$section_admins = array();
		$sql = "SELECT username FROM tbl_section_admins WHERE page_id=".$p;
		$res = mysql_query($sql);
		for ($i=0; $i < mysql_num_rows($res); $i++) {
			$row = mysql_fetch_array($res);
			$section_admins[$i] = $row["username"];
		}
		return $section_admins;
	}
}
*/

function section_admin($page_id,$parent_id=9999) {
	// GET ALL PARENT IDS UP TO AND EXCLUDING 1
	$in = "IN(".$page_id;
	for ($i=0; $parent_id > 1; $i++) {
		$parent_id = quickSQL("SELECT parent_id FROM tbl_pages WHERE page_id=".$page_id);
		if ($parent_id != 1) $in .= ",".$parent_id;
		$page_id = $parent_id;
	}
	$in .= ")";
	
	// Take Parent IDs and Find Each Parent's Section Admins
	$section_admins = array();
	$sql = "SELECT username FROM tbl_section_admins WHERE page_id ".$in;
	$res = mysql_query($sql);
	for ($i=0; $i < mysql_num_rows($res); $i++) {
		$row = mysql_fetch_array($res);
		$section_admins[$i] = $row["username"];
	}
	return $section_admins;
}

function set_allread() {
	if (!is_logged()) return FALSE;
	else {
		$upd = quickSQL("SELECT COUNT(allread) FROM tbl_notice_allread WHERE username='".$_SESSION["auth_user"]."'");
		if ($upd == 0) quickUPDATE("INSERT INTO tbl_notice_allread (username,allread) VALUES ('".$_SESSION["auth_user"]."',".time().")");
		else quickUPDATE("UPDATE tbl_notice_allread SET allread=".time()." WHERE username='".$_SESSION["auth_user"]."'");
		quickUPDATE("DELETE FROM tbl_notice_visits WHERE username='".$_SESSION["auth_user"]."'");
		return TRUE;
	}
}

function update_constants() {
	$res = mysql_query("SELECT * FROM tbl_variables ORDER BY var_name ASC");
	$fp = fopen("/home/awaldron/public_html/demo/functions/_constants.php","w");
	fwrite($fp,"<?php\n");
	while ($row = mysql_fetch_array($res)) {
		fwrite($fp,"define('".strtoupper($row["var_name"])."','".$row["var_value"]."');\n");
	}
	fwrite($fp,"?>");
	fclose($fp);	
}

function update_top10($top10) {
	$fp = fopen("/home/intranet/functions/_top10.php","w");
	fwrite($fp,"<?php //".time()."\n");
	for ($i=0; $i < count($top10); $i++) {
		fwrite($fp,"echo \"<tr style=\\\"cursor:hand\\\" onmouseover=\\\"bgColor='#FFCC33'\\\" onmouseout=\\\"bgColor='#E0E0E0'\\\" bgColor='#E0E0E0' onclick=\\\"window.location='".$top10[$i]["path"]."'\\\"><td valign=\\\"middle\\\" align=\\\"center\\\" height=20><img src=\\\"/gui/bullet.gif\\\"></td><td><a href=\\\"".$top10[$i]["path"]."\\\" class=\\\"leftnav\\\">".$top10[$i]["title"]."</a></td></tr>\\n\";\n");
		fwrite($fp,"echo \"<tr bgcolor=\\\"#FFFFFF\\\"><td height=1 colspan=2><img src=\\\"/gui/clear.gif\\\" width=1 height=1></td></tr>\\n\";\n");
	}
	fwrite($fp,"?>");
	fclose($fp);	
}

function update_dbVAR($var,$val) {
	$res = mysql_query("UPDATE tbl_variables SET var_value='".$val."' WHERE var_name='".$var."'");
	return $res;
}

function username_change($from,$to) {
	quickUPDATE("UPDATE tbl_calendar_dates SET username='".$to."' WHERE username='".$from."'");
	quickUPDATE("UPDATE tbl_employees SET username='".$to."' WHERE username='".$from."'");
	quickUPDATE("UPDATE tbl_event SET event_owner='".$to."' WHERE event_owner='".$from."'");
	quickUPDATE("UPDATE tbl_event_is_att SET registrant='".$to."' WHERE registrant='".$from."'");
	quickUPDATE("UPDATE tbl_event_rs_att SET registrant='".$to."' WHERE registrant='".$from."'");
	quickUPDATE("UPDATE tbl_event_su_att SET registrant='".$to."' WHERE registrant='".$from."'");
	quickUPDATE("UPDATE tbl_extdir SET username='".$to."' WHERE username='".$from."'");
	quickUPDATE("UPDATE tbl_extdir_list SET username='".$to."' WHERE username='".$from."'");
	quickUPDATE("UPDATE tbl_files_access SET username='".$to."' WHERE username='".$from."'");
	quickUPDATE("UPDATE tbl_group_user SET username='".$to."' WHERE username='".$from."'");
	quickUPDATE("UPDATE tbl_notices SET username='".$to."' WHERE username='".$from."'");
	quickUPDATE("UPDATE tbl_notice_allread SET username='".$to."' WHERE username='".$from."'");
	quickUPDATE("UPDATE tbl_notice_visits SET username='".$to."' WHERE username='".$from."'");
	quickUPDATE("UPDATE tbl_pages SET username='".$to."' WHERE username='".$from."'");
	quickUPDATE("UPDATE tbl_page_owners SET username='".$to."' WHERE username='".$from."'");
	quickUPDATE("UPDATE tbl_pgroup SET pgroup_mod='".$to."' WHERE pgroup_mod='".$from."'");
	quickUPDATE("UPDATE tbl_pgroup_user SET username='".$to."' WHERE username='".$from."'");
	quickUPDATE("UPDATE tbl_photovote_votes SET username='".$to."' WHERE username='".$from."'");
	quickUPDATE("UPDATE tbl_section_admins SET username='".$to."' WHERE username='".$from."'");
	quickUPDATE("UPDATE tbl_threads SET username='".$to."' WHERE username='".$from."'");
	quickUPDATE("UPDATE tbl_userlog SET username='".$to."' WHERE username='".$from."'");
	quickUPDATE("UPDATE tbl_visitors SET username='".$to."' WHERE username='".$from."'");
	@ rename("/home/awaldron/public_html/demo/gui/photos/".$from.".jpg", "/home/awaldron/public_html/demo/gui/photos/".$to.".jpg");
	@ rename("/home/awaldron/public_html/demo/gui/photos/".$from."2.jpg", "/home/awaldron/public_html/demo/gui/photos/".$to."2.jpg");
}

function get_usernames() {
	$u = array();
	$uall = array();   
	$u = quickCOL("SELECT DISTINCT username FROM tbl_calendar_dates");
	$uall = array_merge($u,$uall);
	//$u = quickCOL("SELECT DISTINCT username FROM tbl_employees");
	//$u = quickCOL("SELECT DISTINCT event_owner FROM tbl_event");
	//$uall = array_merge($u,$uall);
	//$u = quickCOL("SELECT DISTINCT registrant FROM tbl_event_is_att");
	//$uall = array_merge($u,$uall);
	//$u = quickCOL("SELECT DISTINCT registrant FROM tbl_event_rs_att");
	//$uall = array_merge($u,$uall);
	//$u = quickCOL("SELECT DISTINCT registrant FROM tbl_event_su_att");
	//$uall = array_merge($u,$uall);
	$u = quickCOL("SELECT DISTINCT username FROM tbl_extdir");
	$uall = array_merge($u,$uall);
	$u = quickCOL("SELECT DISTINCT username FROM tbl_extdir_list");
	$uall = array_merge($u,$uall);
	$u = quickCOL("SELECT DISTINCT username FROM tbl_files_access");
	$uall = array_merge($u,$uall);
	//$u = quickCOL("SELECT DISTINCT username FROM tbl_group_user");
	//$uall = array_merge($u,$uall);
	//$u = quickCOL("SELECT DISTINCT username FROM tbl_notices");
	//$uall = array_merge($u,$uall);
	//$u = quickCOL("SELECT DISTINCT username FROM tbl_notice_allread");
	//$uall = array_merge($u,$uall);
	//$u = quickCOL("SELECT DISTINCT username FROM tbl_notice_visits");
	//$uall = array_merge($u,$uall);
	$u = quickCOL("SELECT DISTINCT username FROM tbl_pages");
	$uall = array_merge($u,$uall);
	$u = quickCOL("SELECT DISTINCT username FROM tbl_page_owners");
	$uall = array_merge($u,$uall);
	$u = quickCOL("SELECT DISTINCT pgroup_mod FROM tbl_pgroup");
	$uall = array_merge($u,$uall);
	$u = quickCOL("SELECT DISTINCT username FROM tbl_pgroup_user");
	$uall = array_merge($u,$uall);
	//$u = quickCOL("SELECT DISTINCT username FROM tbl_photovote_votes");
	//$uall = array_merge($u,$uall);
	$u = quickCOL("SELECT DISTINCT username FROM tbl_section_admins");
	$uall = array_merge($u,$uall);
	$u = quickCOL("SELECT DISTINCT username FROM tbl_threads");
	$uall = array_merge($u,$uall);
	//$u = quickCOL("SELECT DISTINCT username FROM tbl_userlog");
	//$uall = array_merge($u,$uall);
	$u = quickCOL("SELECT DISTINCT username FROM tbl_visitors");
	$uall = array_merge($u,$uall);
	$uall = array_unique($uall);
	sort($uall);
	$j = 0;
	$out = "DELETE FROM -- WHERE username NOT IN (";
	for ($i=0; $i < count($uall); $i++) {
		if (!zero($uall[$i])) {
			$out .= ($j==0?"":",")."'".strtolower($uall[$i])."'";
			$j++;
		}
	}
	$out .= ")";
	echo $out;
}


//function username_delete($user) {
//	quickUPDATE("DELETE FROM tbl_event WHERE event_owner='".$from."'");
//	quickUPDATE("DELETE FROM tbl_event_is_att WHERE registrant='".$from."'");
//	quickUPDATE("DELETE FROM tbl_event_rs_att WHERE registrant='".$from."'");
//	quickUPDATE("DELETE FROM tbl_event_su_att WHERE registrant='".$from."'");
//	quickUPDATE("DELETE FROM tbl_files_access WHERE username='".$from."'");
//	quickUPDATE("DELETE FROM tbl_notice_allread WHERE username='".$from."'");
//	quickUPDATE("DELETE FROM tbl_notice_visits WHERE username='".$from."'");
//	quickUPDATE("DELETE FROM tbl_page_owners WHERE username='".$from."'");
//	quickUPDATE("DELETE FROM tbl_pgroup_user WHERE username='".$from."'");
//	quickUPDATE("DELETE FROM tbl_section_admins WHERE username='".$from."'");
//	// UPDATE NAME, DON'T DELETE FROM THE FOLLOWING
//	quickUPDATE("UPDATE tbl_pgroup SET pgroup_mod='".$to."' WHERE pgroup_mod='".ADMIN_USERNAME."'");
//}

?>