<?php

if (!defined('XOOPS_ROOT_PATH')) exit();

require_once(CMS_MODULE_PATH.'/include/xoopensim.func.php');
require_once(CMS_MODULE_PATH.'/class/AbstructAction.class.php');


class  avatarsAction extends Abstruct_Action
{
	var $db_data = array();
	var $icon = array();
	var $pnum = array();
	var $action_url;
	var $edit_url;
	var $owner_url;

	var $db_ver  = '0.6';
	var $isAdmin = false;
	var $userid  = 0;

	var $avatars_num = 0;
	var $max_avatars = 0;
	var $isAvatarMax = false;

	// Page Control
	var $Cpstart = 0;
	var $Cplimit = 25;
	var $firstname = '';
	var $lastname  = '';
	var $order	   = '';
	var $pstart;
	var $plimit;
	var $number;
	var $sitemax;
	var $sitestart;

	// SQL
	var $lnk_firstname = '';
	var $lnk_lastname  = '';
	var $sql_countcnd  = '';
	var $sql_condition = '';


	function  avatarsAction($controller) 
	{
		$this->mController = $controller;
		//$root = & XCube_Root::getSingleton();
		$root = $controller->mRoot;

		if ($root->mContext->mUser->isInRole('Site.GuestUser')) {
			//$root->mController->executeForward(CMS_MODULE_URL);
			$controller->executeRedirect(CMS_MODULE_URL, 2, _MD_XPNSM_ACCESS_FORBIDDEN);
		}

		$this->userid	 = $root->mContext->mXoopsUser->get('uid');
		$this->isAdmin	 = isXoopensimAdmin($root);
		$this->db_ver	 = opensim_get_db_version();

		$this->avatars_num = xoopensim_get_avatars_num($this->userid);
		$this->max_avatars = $controller->mRoot->mContext->mModuleConfig['max_own_avatars'];
		if (!$this->isAdmin and $this->max_avatars>=0 and $this->avatars_num>=$this->max_avatars) $this->isAvatarMax = true;

		$sql_order = 'ORDER BY created ASC';

		// firstname & lastname
		$this->firstname = $root->mContext->mRequest->getRequest('firstname');
		$this->lastname  = $root->mContext->mRequest->getRequest('lastname');
		if ($this->firstname!='' and !preg_match('/^\w+$/', $this->firstname)) $this->firstname = '';
		if ($this->lastname!=''  and !preg_match('/^\w+$/', $this->lastname))  $this->lastname  = '';

		$this->order = $root->mContext->mRequest->getRequest('order');
		if (!isAlphabetNumeric($order)) $order = '';

		$sql_validuser = $sql_firstname = $sql_lastname = '';
		if ($this->firstname=='' and $this->lastname=='') {
			if ($this->db_ver=='0.6') $sql_validuser = "username!=''";
			else                      $sql_validuser = "FirstName!=''";
		}
		else {
			if ($this->firstname!='') { 
				if ($this->db_ver=='0.6') $sql_firstname = "username  LIKE '$this->firstname'";
				else                      $sql_firstname = "FirstName LIKE '$this->firstname'";
				$this->lnk_firstname = "&amp;firstname=$this->firstname";
			}
			if ($this->lastname!='') { 
				if ($this->firstname!='') $sql_lastname = "and lastname LIKE '$this->lastname'";
				else                      $sql_lastname = "lastname LIKE '$this->lastname'";
				$this->lnk_lastname  = "&amp;lastname=$this->lastname";
			}
		}

		// 0.7: PrincipalID, FirstName, LastName, Created, Login,     homeRegionID 
		// 0.6: users.UUID,  username,  lastname, created, lastLogin, regions.uuid 
		$sql_order = $this->order;
		if ($this->order!='') {
			if ($db_ver=="0.6") {
				if ($sql_order=='firstname')  $sql_order = 'username';
				else if ($sql_order=='login') $sql_order = 'lastlogin';
			}
		}

		// pstart & plimit
		$this->pstart = $root->mContext->mRequest->getRequest('pstart');
		$this->plimit = $root->mContext->mRequest->getRequest('plimit');
		if ($this->pstart!='' and !preg_match('/^[0-9]+$/', $this->pstart)) $this->pstart = '';
		if ($this->plimit!='' and !preg_match('/^[0-9]+$/', $this->plimit)) $this->plimit = '';
		if ($this->pstart=='') $this->pstart = $this->Cpstart;
		if ($this->plimit=='') $this->plimit = $this->Cplimit;
		$sql_limit = "LIMIT $this->pstart, $this->plimit";

		// Order
		if ($sql_order=='login') $sql_order = 'ORDER BY '.$sql_order.' DESC ';
		else if ($sql_order!='') $sql_order = 'ORDER BY '.$sql_order.' ASC ';
		else 					 $sql_order = 'ORDER BY created ASC ';

		// SQL Condition
		$this->sql_countcnd  = " WHERE $sql_validuser $sql_firstname $sql_lastname";
		$this->sql_condition = " WHERE $sql_validuser $sql_firstname $sql_lastname $sql_order $sql_limit";
		$this->action_url    = CMS_MODULE_URL.'/?action=avatars';
		$this->edit_url      = CMS_MODULE_URL.'/?action=edit';
		$this->owner_url     = CMS_MODULE_URL.'/?action=owner';
	}


	function  execute()
	{
		$this->number    = count(opensim_get_avatars_infos($this->sql_countcnd));
		$this->sitemax   = ceil ($this->number/$this->plimit);
		$this->sitestart = round($this->pstart/$this->plimit, 0) + 1;
		if ($this->sitemax==0) $this->sitemax = 1;

		// back more and back one
		if (0==$this->pstart) {
			$this->icon[0] = 'off';
			$this->pnum[0] = 0;
		}
		else {
			$this->icon[0] = 'on';
			$this->pnum[0] = $this->pstart - $this->plimit;
			if ($this->pnum[0]<0) $this->pnum[0] = 0;
		}

		// forward one
		if ($this->number <= ($this->pstart + $this->plimit)) {
			$this->icon[1] = 'off'; 
			$this->pnum[1] = 0; 
		}
		else {
			$this->icon[1] = 'on'; 
			$this->pnum[1] = $this->pstart + $this->plimit;
		}

		// forward more
		if (0 > ($this->number - $this->plimit)) {
			$this->icon[2] = 'off';
			$this->pnum[2] = 0;
		}
		else {
			$this->icon[2] = 'on';
			$this->pnum[2] = $this->number - $this->plimit;
		}

		$this->icon[3] = $this->icon[4] = $this->icon[5] = $this->icon[6] = 'icon_limit_off';
		if ($this->plimit != 10)  $this->icon[3] = 'icon_limit_10_on'; 
		if ($this->plimit != 25)  $this->icon[4] = 'icon_limit_25_on';
		if ($this->plimit != 50)  $this->icon[5] = 'icon_limit_50_on';
		if ($this->plimit != 100) $this->icon[6] = 'icon_limit_100_on';


		// auto synchro
		xoopensim_synchro_opensimdb();

		// Xoopensim Users DB
		$usersdbHandler = & xoops_getmodulehandler('usersdb');

		// OpenSim DB
		$users = opensim_get_avatars_infos($this->sql_condition);

		$colum  = 0;
		foreach($users as $user) {
			$this->db_data[$colum]				= $user;
			$this->db_data[$colum]['num']	    = $colum;
			$this->db_data[$colum]['uname']     = ' - ';		// user name in Xoops
			$this->db_data[$colum]['region_id'] = $user['hmregion'];
			$this->db_data[$colum]['region']    = opensim_get_region_name($user['hmregion']);
			$this->db_data[$colum]['state']     = AVATAR_STATE_NOSTATE;
			$this->db_data[$colum]['editable']  = AVATAR_NOT_EDITABLE;

			$created = $this->db_data[$colum]['created'];
			if ($created==null or $created=='' or $created=='0') {
				$this->db_data[$colum]['born'] = ' - ';
			}
			else {
				$this->db_data[$colum]['born'] = date(DATE_FORMAT, $created);
			}

			$lastlogin = $this->db_data[$colum]['lastlogin'];
			if ($lastlogin==null or $lastlogin=='' or $lastlogin=='0') {
				$this->db_data[$colum]['lastin'] = ' - ';
			}
			else {
				$this->db_data[$colum]['lastin'] = date(DATE_FORMAT, $lastlogin);
			}

			// Agent Online Info
			$UUID = $this->db_data[$colum]['UUID'];
			$online = opensim_get_avatar_online($UUID);
			$this->db_data[$colum]['online'] = $online['online'];
			if ($online['online']) {
				$this->db_data[$colum]['region_id'] = $online['region_id'];
				$this->db_data[$colum]['region']    = $online['region_name'];
			}

			// serach Xoopensim DB
			$uid = -1;
			$avatardata = & $usersdbHandler->get($UUID);

			// auto synchro
			if ($avatardata==null) {
				xoopensim_synchro_opensimdb(false);
				$avatardata = & $usersdbHandler->get($UUID);
			}

			if ($avatardata!=null) {
				$avt_state = $avatardata->get('state');

				if (!((int)$avt_state&AVATAR_STATE_SYNCDB)) {
					xoopensim_synchro_opensimdb(false);
				}

				$uid = $avatardata->get('uid');
				$this->db_data[$colum]['state'] = (int)$avt_state;
				if ($uid>0) {
					$user_module =& xoops_gethandler('user');
					$user_info =& $user_module->get($uid);
					if ($user_info!=null) {
						$this->db_data[$colum]['uname'] = $user_info->getVar('uname');
					}
				}
			}

			$this->db_data[$colum]['uid'] = $uid;

			if ($this->isAdmin or $this->userid==$uid) {
				$this->db_data[$colum]['editable'] = AVATAR_EDITABLE;
			}
			elseif ($uid==0) {
				if (!$this->isAvatarMax) {
					$this->db_data[$colum]['editable'] = AVATAR_OWNER_EDITABLE;
				}
			}

			$this->db_data[$colum]['uuid']    = str_replace('-', '', $UUID);
			$this->db_data[$colum]['rg_uuid'] = str_replace('-', '', $this->db_data[$colum]['region_id']);

			$colum++;
		}
	}


	function  executeView($render) 
	{
		$render->setTemplateName('xoopensim_avatars.html');

		$root 	   = & XCube_Root::getSingleton();
		$grid_name = $root->mContext->mModuleConfig['grid_name'];
		$content   = $root->mContext->mModuleConfig['avatars_content'];
		$userinfo  = $root->mContext->mModuleConfig['userinfo_link'];

		$render->setAttribute('grid_name', 		$grid_name);
		$render->setAttribute('content',   		$content);
		$render->setAttribute('userinfo',   	$userinfo);
		$render->setAttribute('use_utc_time',   USE_UTC_TIME);

		$render->setAttribute('db_data',   		$this->db_data);
		$render->setAttribute('action_url',		$this->action_url);
		$render->setAttribute('edit_url',		$this->edit_url);
		$render->setAttribute('owner_url',		$this->owner_url);
		$render->setAttribute('module_url',		CMS_MODULE_URL);
		$render->setAttribute('firstname', 		$this->firstname);
		$render->setAttribute('lastname',  		$this->lastname);

		$render->setAttribute('not_edit',		AVATAR_NOT_EDITABLE);
		$render->setAttribute('can_edit',		AVATAR_EDITABLE);
		$render->setAttribute('owner_edit',		AVATAR_OWNER_EDITABLE);

		$render->setAttribute('lnk_firstname',	$this->lnk_firstname);
		$render->setAttribute('lnk_lastname',	$this->lnk_lastname);
		$render->setAttribute('icon',	   		$this->icon);
		$render->setAttribute('sitemax',   		$this->sitemax);
		$render->setAttribute('sitestart', 		$this->sitestart);

		$render->setAttribute('pstart',	   		$this->pstart);
		$render->setAttribute('plimit',	   		$this->plimit);
		$render->setAttribute('order',	   		$this->order);
		$render->setAttribute('pnum',	   		$this->pnum);
		$render->setAttribute('number',	   		$this->number);
	}
}

?>