<?php
/*=====================================================================*\
|| ################################################################### ||
|| # [#]app[#] [#]version[#]
|| # --------------------------------------------------------------- # ||
|| # All parts of this file are Š2003-[#]year[#] Iris Studios, Inc. No     # || 
|| # part of this file may be reproduced in any way: part or whole.  # ||
|| # --------------------------------------------------------------- # ||
|| # Š2003 - [#]year[#] Iris Studios, Inc. | http://www.iris-studios.com   # ||
|| ################################################################### ||
\*=====================================================================*/

// ###################### Start build_languages ######################
function build_languages()
{
	global $DB_sql, $env;
	
	$languages = $DB_sql->query("SELECT * FROM " . TABLE_PREFIX . "language");
	while ($language = $DB_sql->fetch_array($languages))
	{
		$tempstore["$language[languageid]"] = $language;
	}
	
	$DB_sql->query("
		### replacing the language cache ###
		REPLACE INTO " . TABLE_PREFIX . "datastore (title, data)
		VALUES ('language', '" . addslasheslike(serialize($tempstore)) . "')"
	);

	$env->datastore['language'] = $tempstore;
}

// ####################### Start build_settings ######################
function build_settings()
{
	global $DB_sql, $env;
	
	$settings = $DB_sql->query("SELECT * FROM " . TABLE_PREFIX . "setting");
	while ($setting = $DB_sql->fetch_array($settings))
	{
		$options["$setting[varname]"] = $setting['value'];
	}
	
	$DB_sql->query("
		### replacing the setting cache ###
		REPLACE INTO " . TABLE_PREFIX . "datastore (title, data)
		VALUES ('setting', '" . addslasheslike(serialize($options)) . "')"
	);
	
	$env->datastore['setting'] = $options;
}

// ###################### Start build_usergroups #####################
function build_usergroups()
{
	global $DB_sql, $env;
	
	$usergroups = $DB_sql->query("SELECT * FROM " . TABLE_PREFIX . "usergroup");
	while ($usergroup = $DB_sql->fetch_array($usergroups))
	{
		$groups["$usergroup[usergroupid]"] = $usergroup;
	}
	
	$DB_sql->query("
		### replacing usergroup cache ###
		REPLACE INTO " . TABLE_PREFIX . "datastore (title, data)
		VALUES ('usergroup', '" . addslasheslike(serialize($groups)) . "')"
	);
	
	$env->datastore['usergroup'] = $groups;
}

// ####################### Start build_statuses ######################
function build_statuses()
{
	global $DB_sql, $env;
	
	$statuses = $DB_sql->query("SELECT * FROM " . TABLE_PREFIX . "status ORDER BY displayorder ASC");
	while ($status = $DB_sql->fetch_array($statuses))
	{
		$tempstore["$status[statusid]"] = $status;
	}
	
	$DB_sql->query("
		### replacing status cache ###
		REPLACE INTO " . TABLE_PREFIX . "datastore (title, data)
		VALUES ('status', '" . addslasheslike(serialize($tempstore)) . "')"
	);
	
	$env->datastore['status'] = $tempstore;
}

// ###################### Start build_severities #####################
function build_severities()
{
	global $DB_sql, $env;
	
	$severities = $DB_sql->query("SELECT * FROM " . TABLE_PREFIX . "severity ORDER BY displayorder ASC");
	while ($severity = $DB_sql->fetch_array($severities))
	{
		$tempstore["$severity[severityid]"] = $severity;
	}
	
	$DB_sql->query("
		### replacing severity cache ###
		REPLACE INTO " . TABLE_PREFIX . "datastore (title, data)
		VALUES ('severity', '" . addslasheslike(serialize($tempstore)) . "')"
	);
	
	$env->datastore['severity'] = $tempstore;
}

// ###################### Start build_priorities #####################
function build_priorities()
{
	global $DB_sql, $env;
	
	$priorities = $DB_sql->query("SELECT * FROM " . TABLE_PREFIX . "priority ORDER BY displayorder ASC");
	while ($priority = $DB_sql->fetch_array($priorities))
	{
		$tempstore["$priority[priorityid]"] = $priority;
	}
	
	$DB_sql->query("
		### replacing priority cache ###
		REPLACE INTO " . TABLE_PREFIX . "datastore (title, data)
		VALUES ('priority', '" . addslasheslike(serialize($tempstore)) . "')"
	);
	
	$env->datastore['priority'] = $tempstore;
}

// ###################### Start build_assignedto #####################
function build_assignedto()
{
	global $DB_sql, $env;
	
	$users = $DB_sql->query("
		SELECT user.email, user.displayname, user.userid, user.showemail
		FROM " . TABLE_PREFIX . "user AS user
		LEFT JOIN " . TABLE_PREFIX . "usergroup AS usergroup ON (user.usergroupid = usergroup.usergroupid)
		WHERE (usergroup.permissions & " . CANBEASSIGNEDTO . ")"
	);
	while ($user = $DB_sql->fetch_array($users))
	{
		fetch_user_display_name($user);
		$devs["$user[userid]"] = $user;
	}
	
	$DB_sql->query("
		### replacing developer / assign to cache ###
		REPLACE INTO " . TABLE_PREFIX . "datastore (title, data)
		VALUES ('assignto', '" . addslasheslike(serialize($devs)) . "')"
	);
	
	$env->datastore['assignto'] = $devs;
}

// ##################### Start build_resolutions #####################
function build_resolutions()
{
	global $DB_sql, $env;
	
	$resolutions = $DB_sql->query("SELECT * FROM " . TABLE_PREFIX . "resolution ORDER BY displayorder ASC");
	while ($resolution = $DB_sql->fetch_array($resolutions))
	{
		$tempstore["$resolution[resolutionid]"] = $resolution;
	}
	
	$DB_sql->query("
		### replacing resolution cache ###
		REPLACE INTO " . TABLE_PREFIX . "datastore (title, data)
		VALUES ('resolution', '" . addslasheslike(serialize($tempstore)) . "')"
	);
	
	$env->datastore['resolution'] = $tempstore;
}

/*=====================================================================*\
|| ###################################################################
|| # $HeadURL$
|| # $Id$
|| ###################################################################
\*=====================================================================*/
?>