<?php

function ShowUserlist() {
	$id = $GLOBALS['id']+0;
	$out = '';

	SQL_EmptyQuery("DELETE FROM {$GLOBALS['sql_prefix']}userlist WHERE chat={$id} AND posttime<(now() - INTERVAL '{$GLOBALS['chat']['timeout']} minutes')", __FILE__.' : '.__LINE__.' : '.__FUNCTION__);

	$find = array(
		'{USERIMAGE}',
		'{USERLINK}',
		'{USERNAME}',
		'{CONTACTS}',
		'{IDENT}',
		'{TIME}',
		'{IDLE_SECONDS}',
		'{IDLE_MINUTES}',
		'{IDLE_HOURS}',
		'{USER_BAN}',
		'{USER_IGNORE}'
		);

	$users = array();
	$utimezone = PChoose($_SESSION['chats'][$id]['timezone'], $GLOBALS['chat']['form_timezone']);
	$rez = SQL_SingleQuery("SELECT username,userid,link,image,ident,to_char(timezone('{$utimezone}', posttime), '{$GLOBALS['chat']['form_lastpost']}') as posttime,round(EXTRACT(EPOCH FROM (now() - posttime))) as idlesecond FROM {$GLOBALS['sql_prefix']}userlist WHERE chat=$id ORDER BY idlesecond ASC", NULL, __FILE__.' : '.__LINE__.' : '.__FUNCTION__);
	$num = SQL_NumRows($rez);
	for($i=0;$i<$num;$i++) {
		$row = SQL_FetchAssoc($rez, $i);
		$users[] = $row;
	}
	SQL_FreeResult($rez);

	if (count($users) > 0) {
		$banimg = array_merge($_SESSION['imagebans'], $GLOBALS['imagebans']);
		$banimg = array_unique($banimg);
		sort($banimg);

		$images = array();
		$ids = array();
		$ids[] = 0;
		$ccx = count($users);
		for ($cc=0;$cc<$ccx;$cc++) {
			$users[$cc]['userid'] += 0;
			if (!empty($users[$cc]['image'])) {
				if (!CheckImageBanned($users[$cc]['image'], $banimg))
					$images[] = $users[$cc]['image'];
			}
			if (!empty($users[$cc]['userid'])) {
				$ids[] = $users[$cc]['userid'];
			}
		}
		if ($_SESSION['chats'][$id]['noimg'] != true) {
			$images = ScaleImageSize($images);
		}

		$query = "SELECT
			u.skype,u.id,u.prefs,u.aim,u.ym,u.icq,u.jabber,u.msn,u.email,u.site,
			char_length(u.profile) as profile,
			COALESCE(u.country, 'XX') as country2,
			COALESCE(c.name, 'Unknown') as country
			FROM {$GLOBALS['sql_prefix']}users as u
			LEFT JOIN {$GLOBALS['sql_prefix']}country_names as c
			ON (u.country=c.name2) WHERE (";
		foreach ($ids as $idx) {
			$query .= "u.id='{$idx}' OR ";
		}
		$query = ereg_replace(' OR $', ')', $query);

		$contacts = array();
		$rez = SQL_SingleQuery($query, NULL, __FILE__.' : '.__LINE__.' : '.__FUNCTION__);
		$num = SQL_NumRows($rez);
		for($i=0;$i<$num;$i++) {
			$row = SQL_FetchAssoc($rez, $i);
			$contacts[$row['id']] = $row;
		}
		SQL_FreeResult($rez);

		$ifind = array(
			'{URL}',
			'{WIDTH}',
			'{HEIGHT}',
			'{SWIDTH}',
			'{SHEIGHT}',
			'{TEXT}'
			);
		for ($cc=0;$cc<count($users);$cc++) {
			$buf = $GLOBALS['chattheme']['userlistentry']['entry'];
			if ($users[$cc]['image']) {
				if (($_SESSION['chats'][$id]['noimg'] != true) && (!CheckFlags($_SESSION['chats'][$id]['prefs'], 'T') || preg_match('@^http://i\.pjj\.cc/.*$@is', $users[$cc]['image']))) {
					$loc = ArrayFind($images, 'sum', crc32($users[$cc]['image']))-1;
					$irepl = array(
						$users[$cc]['image'],
						$images[$loc]['width'],
						$images[$loc]['height'],
						$GLOBALS['settings']['pimgx'],
						$GLOBALS['settings']['pimgy'],
						$users[$cc]['link']
						);
					$users[$cc]['image'] = str_replace($ifind, $irepl, $GLOBALS['chattheme']['userlistentry']['imagesrc']);
				} else {
					$ifind = array(
						'{URL}',
						'{TEXT}'
						);
					$irepl = array(
						$users[$cc]['image'],
						$users[$cc]['link']
						);
					$users[$cc]['image'] = str_replace($ifind, $irepl, $GLOBALS['chattheme']['userlistentry']['imagehidden']);
				}
				$buf = str_replace('{IMAGE}', $GLOBALS['chattheme']['userlistentry']['image'], $buf);
			} else {
				$buf = str_replace('{IMAGE}', '', $buf);
			}

			$contact = '';
			if ($contacts[$users[$cc]['userid']]) {
				$contact = $GLOBALS['chattheme']['userlistentry']['contact']['all'];

				if (!empty($users[$cc]['userid'])) {
					$contact = str_replace(
						'{PMSG}',
						str_replace('{IM}', UTF8Entities($users[$cc]['userid']), $GLOBALS['chattheme']['userlistentry']['contact']['pmsg']),
						$contact
						);
				} else {
					$contact = str_replace('{PMSG}', '', $contact);
				}

				if (!CheckFlags($contacts[$users[$cc]['userid']]['prefs'], 'K') && $contacts[$users[$cc]['userid']]['aim']) {
					$contact = str_replace(
						'{SKYPE}',
						str_replace('{IM}', UTF8Entities($contacts[$users[$cc]['userid']]['skype']), $GLOBALS['chattheme']['userlistentry']['contact']['skype']),
						$contact
						);
				} else {
					$contact = str_replace('{SKYPE}', '', $contact);
				}

				if (!CheckFlags($contacts[$users[$cc]['userid']]['prefs'], 'A') && $contacts[$users[$cc]['userid']]['aim']) {
					$contact = str_replace(
						'{AIM}',
						str_replace('{IM}', UTF8Entities($contacts[$users[$cc]['userid']]['aim']), $GLOBALS['chattheme']['userlistentry']['contact']['aim']),
						$contact
						);
				} else {
					$contact = str_replace('{AIM}', '', $contact);
				}

				if (!CheckFlags($contacts[$users[$cc]['userid']]['prefs'], 'N') && $contacts[$users[$cc]['userid']]['msn']) {
					$contact = str_replace(
						'{MSN}',
						str_replace('{IM}', UTF8Entities($contacts[$users[$cc]['userid']]['msn']), $GLOBALS['chattheme']['userlistentry']['contact']['msn']),
						$contact
						);
				} else {
					$contact = str_replace('{MSN}', '', $contact);
				}

				if (!CheckFlags($contacts[$users[$cc]['userid']]['prefs'], 'J') && $contacts[$users[$cc]['userid']]['jabber']) {
					$contact = str_replace(
						'{JABBER}',
						str_replace('{IM}', UTF8Entities($contacts[$users[$cc]['userid']]['jabber']), $GLOBALS['chattheme']['userlistentry']['contact']['jabber']),
						$contact
						);
				} else {
					$contact = str_replace('{JABBER}', '', $contact);
				}

				if (!CheckFlags($contacts[$users[$cc]['userid']]['prefs'], 'Y') && $contacts[$users[$cc]['userid']]['ym']) {
					$contact = str_replace(
						'{YM}',
						str_replace('{IM}', UTF8Entities($contacts[$users[$cc]['userid']]['ym']), $GLOBALS['chattheme']['userlistentry']['contact']['ym']),
						$contact
						);
				} else {
					$contact = str_replace('{YM}', '', $contact);
				}

				if (!CheckFlags($contacts[$users[$cc]['userid']]['prefs'], 'Q') && $contacts[$users[$cc]['userid']]['icq']) {
					$contact = str_replace(
						'{ICQ}',
						str_replace('{IM}', $contacts[$users[$cc]['userid']]['icq'], $GLOBALS['chattheme']['userlistentry']['contact']['icq']),
						$contact
						);
				} else {
					$contact = str_replace('{ICQ}', '', $contact);
				}

				if ($contacts[$users[$cc]['userid']]['site']) {
					$contact = str_replace(
						'{SITE}',
						str_replace('{IM}', $contacts[$users[$cc]['userid']]['site'], $GLOBALS['chattheme']['userlistentry']['contact']['site']),
						$contact
						);
				} else {
					$contact = str_replace('{SITE}', '', $contact);
				}

				if ($contacts[$users[$cc]['userid']]['profile'] && (CheckMemberOfChat($id) || !CheckFlags($contacts[$users[$cc]['userid']]['prefs'], 'P'))) {
					$contact = str_replace(
						'{PROFILE}',
						str_replace('{IM}', $users[$cc]['userid'], $GLOBALS['chattheme']['userlistentry']['contact']['profile']),
						$contact
						);
				} else {
					$contact = str_replace('{PROFILE}', '', $contact);
				}

				if (CheckMemberOfChat($id) || !CheckFlags($contacts[$users[$cc]['userid']]['prefs'], 'I')) {
					$contact = str_replace(
						'{INFO}',
						str_replace('{IM}', $users[$cc]['userid'], $GLOBALS['chattheme']['userlistentry']['contact']['info']),
						$contact
						);
				} else {
					$contact = str_replace('{INFO}', '', $contact);
				}

				if (CheckFlags($contacts[$users[$cc]['userid']]['prefs'], 'M') && $contacts[$users[$cc]['userid']]['email']) {
					$contact = str_replace(
						'{EMAIL}',
						str_replace('{IM}', $contacts[$users[$cc]['userid']]['email'], $GLOBALS['chattheme']['userlistentry']['contact']['email']),
						$contact
						);
				} else {
					$contact = str_replace('{EMAIL}', '', $contact);
				}

				if (!CheckFlags($contacts[$users[$cc]['userid']]['prefs'], 'c') && $contacts[$users[$cc]['userid']]['country2'] != 'XX') {
					$contact = str_replace(
						'{COUNTRY}',
						str_replace(
							'{COUNTRY}',
							$contacts[$users[$cc]['userid']]['country'],
							str_replace(
								'{COUNTRY2}',
								strtolower($contacts[$users[$cc]['userid']]['country2']),
								$GLOBALS['chattheme']['userlistentry']['contact']['country']
								)
							),
						$contact
						);
				} else {
					$contact = str_replace('{COUNTRY}', '', $contact);
				}
			}

			if ($users[$cc]['link'] && !preg_match('|^([^\s]+:).*|', $users[$cc]['link']))
				$users[$cc]['link'] = 'Text: '.UTF8Entities($users[$cc]['link']);

			$userimage = "<a href=\"{$users[$cc]['link']}\" title=\"{$users[$cc]['link']}\" target=\"_blank\">{$users[$cc]['image']}</a>";
			if (!$users[$cc]['link'])
				$userimage = $users[$cc]['image'];
			
			if (!$users[$cc]['username'])
				$users[$cc]['username'] = $GLOBALS['chat']['s_defaulthandle'];
			$username = "<a href=\"{$users[$cc]['link']}\" title=\"{$users[$cc]['link']}\" target=\"_blank\">".UTF8Entities($users[$cc]['username']).'</a>';
			if (!$users[$cc]['link'])
				$username = UTF8Entities($users[$cc]['username']);
			
			$repl = array(
				$userimage,
				$users[$cc]['link'],
				$username,
				str_replace('{LEVEL}', '', $contact),
				UTF8Entities($users[$cc]['ident']),
				UTF8Entities($users[$cc]['posttime']),
				UTF8Entities($users[$cc]['idlesecond']),
				UTF8Entities(round($users[$cc]['idlesecond']/60)),
				UTF8Entities(round($users[$cc]['idlesecond']/3600))
				);

			if (CheckFlags('*', 'MmZX')) {
				$repl[] = str_replace('{LEVEL}', $GLOBALS['level'], str_replace('{IDENT}', UTF8Entities($users[$cc]['ident']), $GLOBALS['chattheme']['userlistentry']['ban']));
			} else {
				$repl[] = '';
			}
			if (FindIgnore($users[$cc]['ident'], $id))
				$repl[] = str_replace('{LEVEL}', $GLOBALS['level'], str_replace('{IDENT}', UTF8Entities($users[$cc]['ident']), $GLOBALS['chattheme']['userlistentry']['unignore']));
			else
				$repl[] = str_replace('{LEVEL}', $GLOBALS['level'], str_replace('{IDENT}', UTF8Entities($users[$cc]['ident']), $GLOBALS['chattheme']['userlistentry']['ignore']));

			$out .= str_replace($find, $repl, $buf);
		}
	}

	$find = array(
		"|<p>[\r\n]*<br>|is",
		"|<br>[\r\n]*<br>|is"
		);
	$repl = array(
		'<p>',
		'<br>'
		);

	return preg_replace($find, $repl, $out);
}

function AddToUserlist($id=0) {
	if ($id == 0)
		$id = $GLOBALS['id'];
	$id = SQL_EscapeString($id)+0;

	$new_link	= SQL_EscapeOrNullString($_SESSION['chats'][$id]['link'] ? $_SESSION['chats'][$id]['link'] : $_SESSION['chats'][0]['link']);
	$new_img	= SQL_EscapeOrNullString($_SESSION['chats'][$id]['image'] ? $_SESSION['chats'][$id]['image'] : $_SESSION['chats'][0]['image']);
	$new_name	= SQL_EscapeOrNullString($_SESSION['chats'][$id]['username'] ? $_SESSION['chats'][$id]['username'] : $_SESSION['chats'][0]['username']);
	$new_ident	= SQL_EscapeOrNullString($_SESSION['chats'][$id]['ident'] ? $_SESSION['chats'][$id]['ident'] : $_SESSION['chats'][0]['ident']);
	$new_id		= SQL_EscapeOrNullInt($_SESSION['chats'][$id]['id'] ? $_SESSION['chats'][$id]['id'] : $_SESSION['chats'][0]['id']);

	$rez = SQL_Begin();
	$extra = '';
	if (CheckFlags($GLOBALS['chat']['prefs'], 'U'))
		$extra = "OR username={$new_name}";
	SQL_Query("DELETE FROM {$GLOBALS['sql_prefix']}userlist WHERE chat={$id} AND (userid={$new_id} {$extra} OR ident={$new_ident} OR posttime<(now() - INTERVAL '{$GLOBALS['chat']['timeout']} minutes'))", $rez, __FILE__.' : '.__LINE__.' : '.__FUNCTION__);
	SQL_Query("INSERT INTO {$GLOBALS['sql_prefix']}userlist (chat,username,link,image,ident,userid) VALUES ($id,$new_name,$new_link,$new_img,$new_ident,$new_id)", $rez, __FILE__.' : '.__LINE__.' : '.__FUNCTION__);
	SQL_Commit($rez);
}

function RemoveFromUserlist($id=0, $uid=0, $ident=0) {
	if ($id == 0)
		$id = $GLOBALS['id'];
	$id = intval($id);

	if ($uid == 0)
		$uid = PChoose($_SESSION['chats'][$id]['id'], $_SESSION['chats'][0]['id']);
	$uid = intval($uid);
	if ($uid < 1)
		$uid = 'null';

	if ($ident == 0)
		$ident = PChoose($_SESSION['chats'][$id]['ident'], $_SESSION['chats'][0]['ident']);
	$ident = SQL_EscapeOrNullString($ident);

	SQL_EmptyQuery("DELETE FROM {$GLOBALS['sql_prefix']}userlist WHERE chat=$id AND (userid=$uid OR ident=$ident OR posttime<(now() - INTERVAL '{$GLOBALS['chat']['timeout']} minutes'))", __FILE__.' : '.__LINE__.' : '.__FUNCTION__);
}

?>