<?php
!function_exists('readover') && exit('Forbidden');

$updatecache_fd = 0;$sqladd = array();
$query = $db->query("SELECT eg.uid,eg.gid,eg.togid,m.groupid,m.groups,m.username FROM pw_extragroups eg LEFT JOIN pw_members m USING(uid) WHERE eg.startdate+eg.days*86400<".pwEscape($timestamp,false)."LIMIT 100");

while ($rt = $db->fetch_array($query)) {
	if ($rt['gid']==$rt['groupid']) {
		$newgid=($rt['togid'] && strpos($rt['groups'],",$rt[togid],")!==false) ? $rt['togid'] : '-1';
		$newgroups=str_replace(','.$newgid.',',',',$rt['groups']);
	} else {
		$newgid=$rt['groupid'];
		$newgroups=str_replace(','.$rt['gid'].',',',',$rt['groups']);
	}
	if ($rt['gid']=='5') {
		$query1 = $db->query("SELECT fid,forumadmin FROM pw_forums WHERE forumadmin!=''");
		while ($fm = $db->fetch_array($query1)) {
			if ($fm['forumadmin'] && strpos($fm['forumadmin'],",$rt[username],")!==false) {
				$newadmin = str_replace(",$rt[username],",',',$fm['forumadmin']);
				$newadmin == ',' && $newadmin = '';
				$db->update("UPDATE pw_forums SET forumadmin=".pwEscape($newadmin,false)."WHERE fid=".pwEscape($fm['fid'],false));
				$updatecache_fd=1;
			}
		}
	}
	$newgroups==',' && $newgroups='';
	if (in_array($newgid,array('-1','6','7')) && $newgroups=='') {
		$db->update("DELETE FROM pw_administrators WHERE uid=".pwEscape($rt['uid'],false));
	} else {
		$sqladd[] = array($rt['uid'],$rt['username'],$newgid,$newgroups);
	}
	$db->update("UPDATE pw_members SET".pwSqlSingle(array('groupid'=>$newgid,'groups'=>$newgroups),false)."WHERE uid=".pwEscape($rt['uid'],false));
	$db->update("DELETE FROM pw_extragroups WHERE uid=".pwEscape($rt['uid'],false)."AND gid=".pwEscape($rt['gid'],false));
}
if ($sqladd) {
	$db->update("REPLACE INTO pw_administrators (uid,username,groupid,groups) VALUES ".pwSqlMulti($sqladd,false));
}
if ($updatecache_fd) {
	$havechild = array();
	$db->update("UPDATE pw_forums SET childid='0',fupadmin=''");
	$query = $db->query("SELECT fid,forumadmin FROM pw_forums WHERE type='category' ORDER BY vieworder");
	while ($cate = $db->fetch_array($query)) {
		$query2 = $db->query("SELECT fid,forumadmin FROM pw_forums WHERE type='forum' AND fup=".pwEscape($cate['fid'],false));
		if ($db->num_rows($query2)) {
			$havechild[] = $cate['fid'];
			while ($forum = $db->fetch_array($query2)){
				$fupadmin = trim($cate['forumadmin']);
				if ($fupadmin) {
					$db->update("UPDATE pw_forums SET fupadmin=".pwEscape($fupadmin,false)."WHERE fid=".pwEscape($forum['fid'],false));
				}
				if (trim($forum['forumadmin'])) {
					$fupadmin .= $fupadmin ? substr($forum['forumadmin'],1) : $forum['forumadmin']; //is
				}
				$query3 = $db->query("SELECT fid,forumadmin FROM pw_forums WHERE type='sub' AND fup=".pwEscape($forum['fid'],false));
				if ($db->num_rows($query3)) {
					$havechild[] = $forum['fid'];
					while ($sub1 = $db->fetch_array($query3)){
						$fupadmin1=$fupadmin;
						if ($fupadmin1) {
							$db->update("UPDATE pw_forums SET fupadmin=".pwEscape($fupadmin1,false)."WHERE fid=".pwEscape($sub1['fid'],false));
						}
						if (trim($sub1['forumadmin'])) {
							$fupadmin1 .= $fupadmin1 ? substr($sub1['forumadmin'],1) : $sub1['forumadmin'];
						}
						$query4 = $db->query("SELECT fid,forumadmin FROM pw_forums WHERE type='sub' AND fup=".pwEscape($sub1['fid'],false));
						if ($db->num_rows($query4)) {
							$havechild[] = $sub1['fid'];
							while ($sub2 = $db->fetch_array($query4)){
								$fupadmin2 = $fupadmin1;
								if ($fupadmin2) {
									$db->update("UPDATE pw_forums SET fupadmin=".pwEscape($fupadmin2,false)."WHERE fid=".pwEscape($sub2['fid'],false));
								}
							}
						}
					}
				}
			}
		}
	}
	if ($havechild) {
		$havechilds = pwImplode($havechild,false);
		$db->update("UPDATE pw_forums SET childid='1' WHERE fid IN($havechilds)");
	}
}
?>