Page MenuHomeIn-Portal Phabricator
Files F1033907

in-portal
No OneTemporary
Actions

File Metadata

Created
Sat, Jun 21, 4:32 AM

in-portal
View Options

Index: branches/unlabeled/unlabeled-1.54.2/kernel/include/usersession.php
===================================================================
--- branches/unlabeled/unlabeled-1.54.2/kernel/include/usersession.php (nonexistent)
+++ branches/unlabeled/unlabeled-1.54.2/kernel/include/usersession.php (revision 6783)
@@ -0,0 +1,1264 @@
+<?php
+
+class clsUserSession
+{
+ //Common DB operation class variables
+ var $m_dirtyFieldsMap = array();
+ //Identity
+ var $m_SessionKey;
+ var $m_CurrentTempKey;
+ var $m_PrevTempKey;
+ //Required attributes
+ var $m_LastAccessed;
+ var $m_PortalUserId;
+ var $m_Language;
+ var $m_Theme;
+ var $m_GroupId;
+ var $adodbConnection;
+ var $m_Errors;
+ var $m_GroupList;
+ var $PermCache;
+ var $SysPermCache;
+ var $PermCacheGroups;
+ var $CurrentUser;
+ var $UseTempKeys;
+ var $AdminSearchFields;
+
+ function clsUserSession($id=NULL, $TempKeys=FALSE)
+ {
+ global $objConfig, $objLanguages, $objThemes, $m_var_list, $FrontEnd;
+
+ $this->m_Errors = new clsErrorManager();
+ $this->adodbConnection = &GetADODBConnection();
+
+ $this->PermCache = array();
+ $this->PermCacheGroups = '';
+ $this->UseTempKeys = $TempKeys;
+ $this->AdminSearchFields = array("UserName", "GroupName", "us.IpAddress");
+
+ if( GetVar('help_usage') == 'install' ) return;
+
+ if(!$this->UseTempKeys || strlen($id)==0)
+ {
+ //echo "with cookies";
+ if( !isset($_SERVER['HTTP_REFERER']) ) $_SERVER['HTTP_REFERER'] = '';
+ if(!isset($_GET['destform'])) $_GET['destform'] = null;
+ if(!isset($_GET['continue_sess'])) $_GET['continue_sess'] = null;
+
+ // strstr($_SERVER['HTTP_REFERER'], $_SERVER['HTTP_HOST'].$objConfig->Get("Site_Path")) || defined(IS_PO...)
+ // && ( (defined('IS_POPUP') && IS_POPUP) || $_GET['destform'] == 'popup' || $_GET['continue_sess'] == 1)
+ if( strlen($id) )
+ {
+ $this->Set("SessionKey",$id);
+ return $this->LoadFromDatabase($id);
+ }
+ else
+ {
+ $this->Set("PortalUserId", 0);
+ $this->Set("Language", $objLanguages->GetPrimary());
+ $ThemeId = $m_var_list["theme"];
+ $this->SetThemeName($ThemeId);
+ //$this->Set("Theme", $objConfig->Get("Default_Theme"));
+ $this->Set("GroupList",0);
+ $this->Set("SessionKey","");
+ if ($FrontEnd) {
+ $this->Set("GroupList",$objConfig->Get("User_GuestGroup").','.$objConfig->Get('User_LoggedInGroup') );
+ }
+ }
+ }
+ else
+ {
+ //echo "without cookies";
+ return $this->LoadFromTempKey($id);
+ }
+ }
+
+ function AdminSearchWhereClause($SearchList)
+ {
+ $sql = "";
+ if( !is_array($SearchList) ) $SearchList = explode(",",$SearchList);
+
+ // remove empty elements
+ $SearchListTmp=Array();
+ for($f = 0; $f < count($SearchList); $f++)
+ if($SearchList[$f])
+ $SearchListTmp[]=$SearchList[$f];
+ $SearchList=$SearchListTmp;
+
+ if( !count($SearchList) || !count($this->AdminSearchFields) ) return '';
+
+ for($f = 0; $f < count($SearchList); $f++)
+ {
+ $value = $SearchList[$f];
+ if( strlen($value) )
+ {
+ $inner_sql = "";
+ for($i = 0; $i < count($this->AdminSearchFields); $i++)
+ {
+ $field = $this->AdminSearchFields[$i];
+ if( strlen( trim($value) ) )
+ {
+ if( strlen($inner_sql) ) $inner_sql .= " OR ";
+
+ //if (!stristr($value, "Guest")) {
+ $inner_sql .= $field." LIKE '%".$value."%'";
+ //}
+ //else {
+ // $inner_sql .= $field." IS NULL";
+ //}
+ }
+ }
+ if( strlen($inner_sql) )
+ {
+ $sql .= '('.$inner_sql.') ';
+ if($f < count($SearchList) - 1) $sql .= " AND ";
+ }
+ }
+ }
+ return $sql;
+ }
+
+ function CopyToNewSession()
+ {
+ $OldKey = $this->GetSessionKey();
+ $this->GetNewSession();
+ if($OldKey != $this->GetSessionKey())
+ {
+ $this->Set("PortalUserId",$this->Get("PortalUserId"));
+ $this->Set("GroupId",$this->Get("GroupId"));
+ $this->Set("GroupList",$this->Get("GroupList"));
+ $this->Set("Language",$this->Get("Language"));
+ $this->Set("tz",$this->Get("tz"));
+ $this->Set("LastAccessed",adodb_date("U"));
+ $this->Update();
+ }
+ }
+
+ function Get($name)
+ {
+ $var = "m_" . $name;
+ return isset($this->$var) ? $this->$var : '';
+ }
+
+ function Set($name, $value)
+ {
+ if (is_array($name))
+ {
+ for ($i=0; $i<sizeof($name); $i++)
+ { $var = "m_" . $name[$i];
+ $this->$var = $value[$i];
+ $this->m_dirtyFieldsMap[$name[$i]] = $value[$i];
+ }
+ }
+ else
+ {
+ $var = "m_" . $name;
+ $this->$var = $value;
+ $this->m_dirtyFieldsMap[$name] = $value;
+ //echo "Set: $var = $value <br>\n";
+ }
+ }
+
+ function Validate()
+ {
+ $dataValid = true;
+ if(!isset($this->m_LastAccessed))
+ {
+ $this->m_Errors->AddError("error.fieldIsRequired",'LastAccessed',"","",get_class($this),"Validate");
+ $dataValid = false;
+ }
+
+ if(!isset($this->m_PortalUserId))
+ {
+ $this->m_Errors->AddError("error.fieldIsRequired",'PortalUserId',"","",get_class($this),"Validate");
+ $dataValid = false;
+ }
+
+ if(!isset($this->m_Language))
+ {
+ $this->m_Errors->AddError("error.fieldIsRequired",'Language',"","",get_class($this),"Validate");
+ $dataValid = false;
+ }
+
+ if(!isset($this->m_Theme))
+ {
+ $this->m_Errors->AddError("error.fieldIsRequired",'Theme',"","",get_class($this),"Validate");
+ $dataValid = false;
+ }
+
+ return $dataValid;
+ }
+
+ function Delete()
+ {
+ if(!isset($this->m_SessionKey))
+ {
+ $this->m_Errors->AddError("error.AppError",NULL,'Internal error: Delete requires set id',"",get_class($this),"Delete");
+ return false;
+ }
+ //Delete associated adata first
+ $sql = sprintf("DELETE FROM ".GetTablePrefix()."SessionData WHERE SessionKey = '%s'", $this->Get("SessionKey"));
+ $this->adodbConnection->Execute($sql);
+ $sql = sprintf("DROP TABLE IF EXISTS %s%s_search",GetTablePrefix(), $this->Get("SessionKey"));
+ $this->adodbConnection->Execute($sql);
+ $sql = sprintf("DELETE FROM ".GetTablePrefix()."UserSession WHERE SessionKey = '%s'", $this->Get("SessionKey"));
+ $this->adodbConnection->Execute($sql);
+ if ($this->adodbConnection->Execute($sql) === false)
+ {
+ $this->m_Errors->AddError("error.DatabaseError",NULL,$this->adodbConnection->ErrorMsg(),"",get_class($this),"Delete");
+ return false;
+ }
+ $this->Set("SessionKey","");
+ $this->Set("SessionDataLoaded",false);
+ return true;
+ }
+
+ function Update()
+ {
+ global $objConfig;
+
+ //$this->Set("LastAccessed",adodb_date("U"));
+ $this->Set("IpAddress",$_SERVER["REMOTE_ADDR"]);
+ if(!isset($this->m_SessionKey))
+ {
+ $this->m_Errors->AddError("error.AppError",NULL,'Internal error: Update requires set id',"",get_class($this),"Update");
+ return false;
+ }
+ if(!is_numeric($this->Get("PortalUserId")))
+ {
+ $this->Set("PortalUserId",0);
+ }
+ if(!strlen($this->Get("GroupList")))
+ {
+ $this->Set("GroupList",$objConfig->Get("User_GuestGroup"));
+ }
+ if(count($this->m_dirtyFieldsMap) == 0)
+ return true;
+ $sql = "UPDATE ".GetTablePrefix()."UserSession SET ";
+ $first = 1;
+ foreach ($this->m_dirtyFieldsMap as $key => $value)
+ {
+ if($first)
+ {
+ $sql = sprintf("%s %s=%s",$sql,$key,$this->adodbConnection->qstr($value));
+ $first = 0;
+ }
+ else
+ {
+ $sql = sprintf("%s, %s=%s",$sql,$key,$this->adodbConnection->qstr($value));
+ }
+ }
+ $sql = sprintf("%s WHERE SessionKey = '%s'",$sql, $this->Get("SessionKey"));
+ //echo $sql;
+ if ($this->adodbConnection->Execute($sql) === false)
+ {
+ $this->m_Errors->AddError("error.DatabaseError",NULL,$this->adodbConnection->ErrorMsg(),"",get_class($this),"Update");
+ return false;
+ }
+ return true;
+ }
+
+ function Create()
+ {
+ global $objConfig;
+
+ $this->Set("LastAccessed", adodb_mktime());
+ if(!is_numeric($this->Get("PortalUserId")))
+ {
+ $this->Set("PortalUserId",0);
+ }
+ if(!strlen($this->Get("GroupList")))
+ {
+ $this->Set("GroupList",$objConfig->Get("User_GuestGroup"));
+ }
+ $sql = "INSERT INTO ".GetTablePrefix()."UserSession (";
+ $first = 1;
+ foreach ($this->m_dirtyFieldsMap as $key => $value)
+ {
+ if($first)
+ {
+ $sql = sprintf("%s %s",$sql,$key);
+ $first = 0;
+ }
+ else
+ {
+ $sql = sprintf("%s, %s",$sql,$key);
+ }
+ }
+ $sql = sprintf('%s ) VALUES (',$sql);
+ $first = 1;
+ foreach ($this->m_dirtyFieldsMap as $key => $value)
+ {
+ if($first)
+ {
+ $sql = sprintf("%s %s",$sql,$this->adodbConnection->qstr($value));
+ $first = 0;
+ }
+ else
+ {
+ $sql = sprintf("%s, %s",$sql,$this->adodbConnection->qstr($value));
+ }
+ }
+ $sql = sprintf('%s)',$sql);
+ //echo $sql."<br>\n";
+ if ($this->adodbConnection->Execute($sql) === false)
+ {
+ $this->m_Errors->AddError("error.DatabaseError",NULL,$this->adodbConnection->ErrorMsg(),"",get_class($this),"Create");
+ return false;
+ }
+ return true;
+ }
+
+ function LoadFromTempKey($id=NULL)
+ {
+ global $objLanguages, $objConfig,$m_var_list;
+ $referer = $_SERVER["HTTP_REFERER"];
+ //echo "Referer: $referer <br>\n";
+ if(strlen($referer) && strpos($referer,"env="))
+ {
+ $keystart = strpos($referer,"env=")+4;
+ $referer = substr($referer,$keystart);
+ $keyend = strpos($referer,"-");
+ $LastKey = substr($referer,0,$keyend);
+ if(strlen($LastKey))
+ {
+ $sql = "SELECT * FROM ".GetTablePrefix()."UserSession WHERE (CurrentTempKey = '$id' OR PrevTempKey='$id' OR CurrentTempKey='$LastKey' OR PrevTempKey='$LastKey') ";
+ }
+ else
+ $sql = "SELECT * FROM ".GetTablePrefix()."UserSession WHERE CurrentTempKey = '$id' AND PrevTempKey IS NULL";
+ }
+ else
+ $sql = "SELECT * FROM ".GetTablePrefix()."UserSession WHERE CurrentTempKey = '$id' AND PrevTempKey IS NULL";
+
+ $result = $this->adodbConnection->Execute($sql);
+ if ($result === false)
+ {
+ $this->m_Errors->AddError("error.DatabaseError",NULL,$this->adodbConnection->ErrorMsg(),"",get_class($this),"LoadFromDatabase");
+ return false;
+ }
+ $data = $result->fields;
+ if (is_array($data))
+ {
+ foreach($data as $field => $value)
+ {
+ $mname = "m_" . $field;
+ $this->$mname = $data[$field];
+ }
+
+ if($this->Get("CurrentTempKey")) {
+ $this->Set("PrevTempKey",$this->Get("CurrentTempKey"));
+ $this->UseTempKeys=TRUE;
+ }
+
+ if (!$this->Get("CurrentTempKey") || !strstr($_SERVER['HTTP_REFERER'], $_SERVER['HTTP_HOST'].$objConfig->Get("Site_Path"))) {
+ //$this->Set("PrevTempKey",$this->Get("CurrentTempKey"));
+ //$this->Set("CurrentTempKey",$this->GetUniqueKey());
+ $this->UseTempKeys=FALSE;
+ $this->Set("PortalUserId", 0);
+ $this->Set("Language", $objLanguages->GetPrimary());
+ $ThemeId = $m_var_list["theme"];
+ $this->SetThemeName($ThemeId);
+ //$this->Set("Theme", $objConfig->Get("Default_Theme"));
+ $this->Set("GroupList",0);
+ $this->Set("SessionKey","");
+ $this->Set("GroupList",$objConfig->Get("User_GuestGroup"));
+ }
+ //$this->UseTempKeys=TRUE;
+ $this->Update();
+ return true;
+ }
+ else
+ {
+ $this->Set("PortalUserId", 0);
+ $this->Set("Language", $objLanguages->GetPrimary());
+ $ThemeId = $m_var_list["theme"];
+ $this->SetThemeName($ThemeId);
+ //$this->Set("Theme", $objConfig->Get("Default_Theme"));
+ $this->Set("GroupList",0);
+ $this->Set("SessionKey","");
+ $this->Set("GroupList",$objConfig->Get("User_GuestGroup"));
+ $this->Set("CurrentTempKey",$this->GetUniqueKey());
+ return false;
+ }
+ }
+
+ function LoadFromDatabase($id)
+ {
+ if(!isset($id))
+ {
+ $this->m_Errors->AddError("error.AppError",NULL,'Internal error: LoadFromDatabase id',"",get_class($this),"LoadFromDatabase");
+ return false;
+ }
+ $sql = sprintf("SELECT * FROM ".GetTablePrefix()."UserSession WHERE SessionKey = '%s'",$id);
+
+ $result = $this->adodbConnection->Execute($sql);
+ if ($result === false)
+ {
+ $this->m_Errors->AddError("error.DatabaseError",NULL,$this->adodbConnection->ErrorMsg(),"",get_class($this),"LoadFromDatabase");
+ return false;
+ }
+ $data = $result->fields;
+ if (is_array($data))
+ {
+ foreach($data as $field => $value)
+ {
+ $mname = "m_" . $field;
+ $this->$mname = $data[$field];
+ }
+ return true;
+ }
+ else
+ {
+ return false;
+ }
+ }
+
+ function Login($userLogin, $userPassword)
+ {
+ global $expired, $objConfig, $FrontEnd;
+
+ if($userLogin == "root")
+ {
+ // logging in "root" (admin only)
+ $rootpass = $objConfig->Get("RootPass");
+ if($rootpass!=$userPassword)
+ {
+ return false;
+ }
+ else
+ {
+ if(!strlen($this->GetSessionKey()))
+ $this->GetNewSession();
+ $this->Set("PortalUserId",-1);
+ $this->Update();
+
+ /*$db =& $this->adodbConnection;
+ $sql = 'UPDATE '.GetTablePrefix().'Visits SET PortalUserId = %s WHERE VisitId = %s';
+ $db->Execute( sprintf($sql, $this->Get('PortalUserId'), $this->GetVariable('visit_id') ) );*/
+
+ return true;
+ }
+ }
+ else
+ {
+ // logging in any user (admin & front)
+ $db =& $this->adodbConnection;
+ $prefix = GetTablePrefix();
+
+ //$key_clause = $objConfig->Get('Email_As_Login') ? 'pu.Email = %1$s' : 'pu.Login = %1$s';
+ $key_clause = 'pu.Email = %1$s OR pu.Login = %1$s';
+
+ $sql = 'SELECT *, MD5(pu.Password) AS md5pw
+ FROM '.$prefix.'PortalUser pu
+ LEFT JOIN '.$prefix.'UserGroup ug USING (PortalUserId)
+ LEFT JOIN '.$prefix.'PortalGroup pg ON ug.GroupId = pg.GroupId
+ WHERE ('.$key_clause.') AND (pu.Status = 1) AND (pu.Password = %2$s OR MD5(pu.Password) = %2$s OR pu.Password = MD5(%2$s) ) AND
+ ( (ug.MembershipExpires IS NULL) OR ( ug.MembershipExpires >= UNIX_TIMESTAMP() ) )
+ ORDER BY ug.PrimaryGroup DESC, pg.Personal DESC';
+
+ $result = $db->Execute( sprintf($sql, $db->qstr($userLogin), $db->qstr($userPassword) ) );
+
+ if($result === false)
+ {
+ $this->m_Errors->AddError('error.DatabaseError',NULL,$this->adodbConnection->ErrorMsg(),'',get_class($this),'Login');
+ return false;
+ }
+
+ if($result->EOF) return -1; // no any user with username & pass specified
+ }
+
+ if( !strlen($this->GetSessionKey()) ) $this->GetNewSession();
+
+ $this->Set("PortalUserId", $result->fields["PortalUserId"]);
+
+ if($FrontEnd)
+ {
+ $application =& kApplication::Instance();
+ $application->setVisitField('PortalUserId', $this->Get('PortalUserId') );
+ $application->SetVar('u_id', $this->Get('PortalUserId'));
+ }
+
+ // unset($this->CurrentUser);
+ $this->CurrentUser = null;
+ if( strlen($result->fields['tz']) > 0 ) $this->Set('tz',$result->fields['tz']);
+ $PrimaryGroup = 0;
+ $PersonalGroup = 0;
+ $GroupList = Array();
+
+ while($result && !$result->EOF)
+ {
+ $skipadd=0;
+ $g = $result->fields["GroupId"];
+
+ if($result->fields["PrimaryGroup"]==1)
+ {
+ $PrimaryGroup = $g;
+ $skipadd=1;
+ }
+ if($result->fields["Personal"]==1)
+ {
+ $PersonalGroup=$g;
+ $skipadd=0;
+ }
+ if(!$skipadd)
+ $GroupList[] = $g;
+ $result->MoveNext();
+ }
+
+ if($PrimaryGroup) array_unshift($GroupList, $PrimaryGroup);
+ if ($FrontEnd) array_push($GroupList, $objConfig->Get('User_LoggedInGroup') );
+
+ $extra_groups = implode(',', $GroupList);
+
+ $this->SetVariable('UserGroups', $extra_groups);
+ $this->SetVariable('user_id', $this->Get('PortalUserId'));
+
+ $this->Set('GroupId', $PersonalGroup ? $PersonalGroup : $PrimaryGroup);
+
+ $this->Set('GroupList', $extra_groups);
+ $this->SetVariable('UserGroups', $this->Get('GroupList') );
+
+
+ $app = kApplication::Instance();
+ $kSession = $app->recallObject('Session');
+ $kSession->SetField('GroupList', $extra_groups);
+ $app->StoreVar('UserGroups', $this->Get('GroupList') );
+ $app->setVisitField('PortalUserId', $this->Get('PortalUserId') );
+
+
+ $this->Set('LastAccessed', adodb_date('U') );
+ $this_login = $this->GetPersistantVariable("ThisLogin");
+ $this->SetPersistantVariable("LastLogin", $this_login);
+ $this->SetPersistantVariable("ThisLogin", adodb_mktime());
+ $this->ResetSysPermCache();
+ $this->PermCache = array();
+ $this->Update();
+
+ if($userLogin != 'root' && $FrontEnd)
+ {
+ if( ! $this->HasSystemPermission('LOGIN') )
+ {
+ $this->Logout();
+ return -2; // no perm login
+ }
+ }
+
+ return true; // login ok
+ }
+
+ function Logout()
+ {
+ global $objConfig, $FrontEnd;
+
+ $this->Set("PortalUserId", 0); // not logged-in
+ $this->Set('LastAccessed',0); // session become expired
+ $this->Set("GroupId", $objConfig->Get("User_GuestGroup"));
+ #$this->SetPersistantVariable("LastLogin", adodb_mktime());
+
+ $group_list = $FrontEnd ? $objConfig->Get('User_GuestGroup').','.$objConfig->Get('User_LoggedInGroup') : '';
+ $this->Set("GroupList", $group_list);
+ $this->SetVariable('UserGroups', $group_list );
+ $this->SetVariable('user_id', -2);
+
+ if( class_exists('kApplication') )
+ {
+ $app = kApplication::Instance();
+ $kSession = $app->recallObject('Session');
+ $kSession->SetField('GroupList', $group_list);
+ $app->StoreVar('UserGroups', $group_list );
+ }
+
+ $this->Set("IpAddress",$_SERVER['REMOTE_ADDR']);
+
+ $this->DeleteSessionData($this->GetSessionKey());
+ $this->Update();
+ //$this->Delete();
+ $this->ResetSysPermCache();
+ $this->PermCache = array();
+
+ if($FrontEnd && class_exists('kApplication') )
+ {
+ $app =& kApplication::Instance();
+ $app->Redirect();
+ }
+ }
+
+ function SetVariable($variableName, $variableValue)
+ {
+ global $objConfig, $FrontEnd;
+
+ $objConfig->Set($variableName,$variableValue,2);
+ $variableValue = addslashes($variableValue);
+
+ //if(!(int)$FrontEnd==1)
+ //{
+ $db =& $this->adodbConnection;
+ $sessionkey = $this->GetSessionKey();
+ $sql = 'REPLACE INTO '.GetTablePrefix().'SessionData (SessionKey,VariableName,VariableValue) VALUES (%s,%s,%s)';
+ $db->Execute( sprintf($sql, $db->qstr($sessionkey), $db->qstr($variableName), $db->qstr($variableValue) ) );
+
+ if( class_exists('kApplication') )
+ {
+// echo 'var stored ['.$variableName.'] = ['.$variableValue.']<br>';
+ $application =& kApplication::Instance();
+ $application->StoreVar($variableName, $variableValue);
+ }
+
+ // echo "<BR>UPDATE: $sql<BR>";
+ //}
+ }
+
+ function SetPersistantVariable($variableName, $variableValue)
+ {
+ global $objConfig, $objUsers;
+
+ $userid = (int)$this->Get("PortalUserId");
+
+ if($userid > 0)
+ {
+ if(!is_object($this->CurrentUser))
+ {
+ $this->CurrentUser = $objUsers->GetItem($userid);
+ }
+ if(!$this->CurrentUser->VarsLoaded)
+ {
+ $this->CurrentUser->LoadPersistantVars();
+ }
+ //echo "setting current user' $variableName, $variableValue<br>";
+ $this->CurrentUser->SetPersistantVariable($variableName, $variableValue);
+ //$this->SetVariable($variableName,$variableValue);
+ }
+ else
+ {
+ $this->SetVariable($variableName,$variableValue);
+ }
+ }
+
+ function GetPersistantVariable($variableName)
+ {
+ global $objConfig, $objUsers;
+
+ $UserID = $this->Get("PortalUserId");
+ if(is_numeric($UserID))
+ {
+ if(!is_object($this->CurrentUser))
+ {
+ $this->CurrentUser = $objUsers->GetItem($UserID);
+ }
+ if(!$this->CurrentUser->VarsLoaded)
+ {
+ $this->CurrentUser->LoadPersistantVars();
+ }
+ $val = $this->CurrentUser->GetPersistantVariable($variableName);
+ //echo "Persistant Val for $variableName: $val<br>";
+ }
+ if(!strlen($val))
+ $val = $objConfig->Get($variableName);
+ return $val;
+ }
+
+ function GetVariable($variableName)
+ {
+ global $objConfig;
+
+ return $objConfig->Get($variableName);
+ }
+
+ function LoadSessionData()
+ {
+ global $objConfig, $objUsers;
+
+ if(is_numeric($this->Get("PortalUserId")))
+ {
+ $sql = "SELECT VariableName, VariableValue FROM ".GetTablePrefix()."SessionData where SessionKey='" . $this->Get("SessionKey") . "'";
+ //echo $sql."<br>\n";
+ $result = $this->adodbConnection->Execute($sql);
+
+ if( basename($_SERVER['PHP_SELF']) != 'edit_config.php' )
+ {
+ while ($result && !$result->EOF)
+ {
+ $data = $result->fields;
+ //echo "<PRE>"; print_r($data); echo "</PRE>";
+ $objConfig->Set($data["VariableName"],$data["VariableValue"],FALSE);
+ $result->MoveNext();
+ }
+ }
+
+ if(!is_object($this->CurrentUser))
+ {
+ $this->CurrentUser = $objUsers->GetItem($this->Get("PortalUserId"));
+ }
+ if(!$this->CurrentUser->VarsLoaded)
+ {
+ $this->CurrentUser->LoadPersistantVars();
+ }
+ }
+ if((int)$this->GetPersistantVariable("Language"))
+ $this->Set("Language",$objConfig->Get("Language"));
+ $this->DeleteExpiredSessions();
+ return true;
+ }
+
+ function DeleteSessionData($key)
+ {
+ $sql = "DELETE FROM ".GetTablePrefix()."SessionData WHERE SessionKey='$key'";
+ $this->adodbConnection->Execute($sql);
+ }
+
+ function SaveSessionData()
+ {
+ global $objConfig;
+
+ //echo "Saving Session Data..<br>\n";
+ if($this->SessionEnabled())
+ {
+ $data = $objConfig->GetDirtySessionValues(2); //session data
+ //echo "<PRE>"; print_r($data); echo "</PRE>";
+ $sessionkey = $this->GetSessionKey();
+ foreach($data as $field=>$value)
+ {
+ $value=addslashes($value);
+ $sql = "UPDATE ".GetTablePrefix()."SessionData SET VariableValue='$value' WHERE VariableName='$field' AND SessionKey='$sessionkey'";
+ $this->adodbConnection->Execute($sql);
+ //echo $sql."<br>\n";
+
+ if($this->adodbConnection->Affected_Rows()==0)
+ {
+ $sql = "INSERT INTO ".GetTablePrefix()."SessionData (VariableName,VariableValue,SessionKey) VALUES ('$field','$value','$sessionkey')";
+ $this->adodbConnection->Execute($sql);
+ }
+ // echo $sql."<br>\n";
+ }
+ }
+ }
+
+ function DeleteEditTables()
+ {
+ $tables = $this->adodbConnection->MetaTables();
+ $mask = '/'.GetTablePrefix().'ses_(.*)_edit_(.*)/';
+ $sql='SELECT COUNT(*) FROM '.GetTablePrefix().'UserSession WHERE SessionKey = \'%s\'';
+ foreach($tables as $table)
+ {
+ if( preg_match($mask,$table,$rets) )
+ {
+ $sid=$rets[1];
+ $is_alive = $this->adodbConnection->GetOne( sprintf($sql,$sid) );
+ if(!$is_alive) @$this->adodbConnection->Execute('DROP TABLE IF EXISTS '.$table);
+ }
+ }
+ }
+
+ function DeleteExpiredSessions()
+ {
+ global $objConfig;
+
+ $cutoff = adodb_mktime()-$objConfig->Get("SessionTimeout");
+ $thiskey = $this->GetSessionKey();
+ $sql = "SELECT SessionKey from ".GetTablePrefix()."UserSession WHERE LastAccessed<$cutoff AND SessionKey != '$thiskey'";
+ $result = $this->adodbConnection->Execute($sql);
+ $keys = array();
+ while ($result && !$result->EOF)
+ {
+ $keys[] = "SessionKey='" . $result->fields["SessionKey"] . "'";
+ $result->MoveNext();
+ }
+ if(count($keys)>0)
+ {
+ $keywhere = implode(" OR ", $keys);
+ $sql = "DELETE FROM ".GetTablePrefix()."SessionData WHERE $keywhere";
+ //echo $sql;
+ $this->adodbConnection->Execute($sql);
+ $this->adodbConnection->Execute("DELETE FROM ".GetTablePrefix()."UserSession WHERE LastAccessed<$cutoff");
+ $this->DeleteEditTables();
+ }
+ }
+
+ function SetSysPermCache()
+ {
+ unset($this->SysPermCache);
+ $GroupList = $this->Get('GroupList');
+
+ if ($GroupList && $GroupList != '0') {
+ $this->SysPermCache = Array();
+ $sql = 'SELECT *
+ FROM '.GetTablePrefix().'Permissions
+ WHERE Type = 1 AND GroupId IN ('.$GroupList.')'; // AND PermissionValue = 1';
+
+ $rs = $this->adodbConnection->Execute($sql);
+
+ $PermList = Array();
+ while (!$rs->EOF) {
+ $this->SysPermCache[ $rs->fields['Permission'] ] = $rs->fields['PermissionValue'];
+ $PermList[] = $rs->fields['Permission'];
+ $rs->MoveNext();
+ }
+
+ if ($PermList) {
+ $this->SetVariable('SysPerm', implode(',', $PermList));
+ }
+ }
+ }
+
+ /**
+ * Fills system permission cache in session (memory only, not db)
+ *
+ */
+ function GetSysPermCache()
+ {
+ $perms = trim($this->GetVariable('SysPerm'));
+ if (!$perms) {
+ $this->SetSysPermCache();
+ }
+ else {
+ $p = explode(',', $perms);
+ $this->SysPermCache = Array();
+ for($i = 0; $i < count($p); $i++)
+ {
+ $n = $p[$i];
+ $this->SysPermCache[$n] = 1;
+ }
+ }
+ }
+
+ /**
+ * Allows to detect if system permissions are loaded
+ *
+ * @return bool
+ */
+ function SysPermCacheLoaded()
+ {
+ return isset($this->SysPermCache);
+ }
+
+ /**
+ * Resets system permission cache
+ *
+ */
+ function ResetSysPermCache()
+ {
+ $this->SetVariable('SysPerm', '');
+ unset($this->SysPermCache);
+ }
+
+ function HasSystemPermission($PermissionName)
+ {
+ global $objGroups;
+
+ // "root" is always allowed to login to admin
+ if ($this->Get('PortalUserId') == -1 && ($PermissionName == 'ADMIN' || $PermissionName == 'LOGIN') ) {
+ return true;
+ }
+
+ // cut last comma (just in case in-portal made a mistake before)
+ $GroupList = $this->Get('GroupList');
+ if (substr($GroupList, -1) == ',') {
+ $GroupList = substr($GroupList, 0, -1);
+ $this->Set('GroupList', $GroupList);
+ }
+
+ // if loaded permissions are from other group list, then current (e.g. user is become logged-in during script run)
+ if ($this->Get('GroupList') != $this->PermCacheGroups) {
+ $this->ResetSysPermCache();
+ }
+
+ // load system permission cache if not already loaded
+ if (!$this->SysPermCacheLoaded()) {
+ $this->GetSysPermCache();
+ $this->PermCacheGroups = $this->Get('GroupList');
+ }
+ //echo "SysPerm $PermissionName: [". $this->SysPermCache[$PermissionName]."]<br>\n";
+ return isset($this->SysPermCache[$PermissionName]) ? $this->SysPermCache[$PermissionName] == 1 : false;
+ }
+
+ function HasCatPermission($PermissionName,$CatId=NULL)
+ {
+ global $objCatList, $objUsers;
+
+ $PermSet =FALSE;
+ $Value = 0;
+ if($this->Get("PortalUserId")==-1)
+ return TRUE;
+ if(!strlen($PermissionName))
+ return FALSE;
+ $GroupList = $this->Get("GroupList");
+ if(substr($GroupList,-1)==",")
+ {
+ $GroupList = substr($GroupList,0,-1);
+ $this->Set("GroupList",$GroupList);
+ }
+ if(!strlen($this->Get("SessionKey")))
+ $this->Set("GroupId",0);
+ if(strlen(trim($GroupList)))
+ {
+ if(strlen($this->Get("GroupId")))
+ {
+ $GroupList = $this->Get("GroupId").",".$GroupList;
+ }
+ }
+ else
+ {
+ $GroupList = $this->Get("GroupId");
+ }
+
+ if($CatId == NULL)
+ {
+ $CatId = $objCatList->CurrentCategoryID();
+ }
+
+ $Cat = &$objCatList->GetCategory($CatId);
+
+ $Value="";
+ for($p=0;$p<count($this->PermCache);$p++)
+ {
+ $pItem = $this->PermCache[$p];
+ if($pItem["perm"]==$PermissionName && $pItem["cat"]==$CatId)
+ {
+ $Value=$pItem["value"];
+ break;
+ }
+ }
+ if(is_object($Cat) && !is_numeric($Value))
+ {
+ $Value = 0;
+ $CatList = $Cat->Get("ParentPath");
+ $CatList = substr($CatList,1,-1);
+ $CatList = str_replace("|",",",$CatList);
+ if(strlen($CatList))
+ {
+ $CatList ="0,".$CatList;
+ }
+ else
+ $CatList = "0";
+ $sql = "SELECT * FROM ".GetTablePrefix()."Permissions WHERE Permission LIKE '$PermissionName' AND CatId IN ($CatList) AND GroupId IN ($GroupList)";
+// echo $sql."<br>\n";
+ $rs = $this->adodbConnection->Execute($sql);
+ $PermValue = array();
+ while($rs && !$rs->EOF)
+ {
+ $index = $rs->fields["CatId"];
+ if(!is_numeric($PermValue[$index]) || $rs->fields["PermissionValue"]) {
+ // remember permission value of not set or allowed
+ $PermValue[$index] = $rs->fields["PermissionValue"];
+ }
+ $rs->MoveNext();
+ }
+ $cats = array_reverse(explode(",",$CatList));
+ for($c=0;$c<count($cats);$c++)
+ {
+ $index = $cats[$c];
+ if( isset($PermValue[$index]) && is_numeric($PermValue[$index]) )
+ {
+ $Value = $PermValue[$index];
+ break;
+ }
+ }
+ $perm = array();
+ $perm["perm"] = $PermissionName;
+ $perm["cat"] = $CatId;
+ $perm["value"] = $Value;
+ array_push($this->PermCache, $perm);
+ }
+ //echo $GroupList." Has Permission $PermissionName = $Value<br>\n";
+ return $Value;
+ }
+
+ function HasCatPermInList($PermList,$CatId=NULL, $System=FALSE)
+ {
+ $value = 0;
+ if(strlen($PermList))
+ {
+ $plist = explode(",",$PermList);
+ $value=0;
+ for($p=0;$p<count($plist);$p++)
+ {
+ if($this->HasCatPermission($plist[$p]))
+ {
+ $value = 1;
+ break;
+ }
+ else
+ {
+ if($System)
+ {
+ if($this->HasSystemPermission($plist[$p]))
+ {
+ $value = 1;
+ break;
+ }
+ }
+ }
+ }
+ }
+ return $value;
+ }
+
+ function GetACLClause()
+ {
+ $GroupList = $this->Get("GroupList");
+ if(strlen($GroupList))
+ $Groups = explode(",",$GroupList);
+ $acl_where = "";
+ if(@count($Groups)>0 && is_array($Groups))
+ {
+ $acl_where = array();
+ for($i=0;$i<count($Groups);$i++)
+ {
+ $g = $Groups[$i];
+ if(strlen($g)>0)
+ $acl_where[] = "FIND_IN_SET($g,acl) ";
+ }
+ if(count($acl_where))
+ {
+ $acl_where = "(".implode(" OR ",$acl_where).")";
+ }
+ else {
+ $acl_where = "FIND_IN_SET(0,acl)";
+ }
+ }
+ else {
+ $acl_where = "FIND_IN_SET(0,acl)";
+ }
+ return $acl_where;
+ }
+
+ function GetEditTable($base_table)
+ {
+ $prefix = GetTablePrefix();
+ if(strlen($prefix))
+ {
+ if(substr($base_table,0,strlen($prefix))!=$prefix)
+ $base_table = $prefix.$base_table;
+ }
+ $table = $prefix."ses_".$this->GetSessionKey()."_edit_".$base_table;
+ //echo "Table: $table <br>\n";
+ return $table;
+ }
+
+ function GetSessionTable($base_table,$name)
+ {
+ $prefix = GetTablePrefix();
+ if(strlen($prefix))
+ {
+ if(substr($base_table,0,strlen($prefix))!=$prefix)
+ $base_table = $prefix.$base_table;
+ }
+ $table = $prefix."ses_".$this->GetSessionKey()."_".$name.$base_table;
+ //echo "Table: $table <br>\n";
+ return $table;
+ }
+
+ function GetSearchTable($base_table="")
+ {
+ $prefix = GetTablePrefix();
+ if(strlen($base_table))
+ {
+ if(strlen($prefix))
+ {
+ if(substr($base_table,0,strlen($prefix))!=$prefix)
+ $base_table = $prefix.$base_table;
+ }
+ $table = $prefix."ses_".$this->GetSessionKey()."_search_".$base_table;
+ }
+ else
+ $table = $this->GetSessionTable('Search',''); //$prefix."ses_".$this->GetSessionKey()."_search";
+ return $table;
+ }
+
+ function GetTotalSessions()
+ {
+ # $time = adodb_mktime() - 900;
+ $sql = "SELECT count(*) as SesCount FROM ".GetTablePrefix()."UserSession";
+ $result = $this->adodbConnection->Execute($sql);
+ if ($result === false)
+ {
+ $this->m_Errors->AddError("error.DatabaseError",NULL,$this->adodbConnection->ErrorMsg(),"",get_class($this),"GetTotalSessions");
+ return false;
+ }
+ return $result->fields["SesCount"];
+ }
+
+ function Query_UserSession($whereClause,$orderByClause)
+ {
+ $resultSet = array();
+ $sql = "SELECT ".GetTablePrefix()."* FROM ".GetTablePrefix()."UserSession ";
+ if(isset($whereClause))
+ $sql = sprintf('%s WHERE %s',$sql,$whereClause);
+ if(isset($orderByClause))
+ $sql = sprintf('%s ORDER BY %s',$sql,$orderByClause);
+ $result = $this->adodbConnection->Execute($sql);
+ if ($result === false)
+ {
+ $this->m_Errors->AddError("error.DatabaseError",NULL,$this->adodbConnection->ErrorMsg(),"",get_class($this),"Query_UserSession");
+ return false;
+ }
+ while (!$result->EOF)
+ {
+ $item = new clsUserSession(NULL);
+ $item->Set("SessionKey",$result->fields["SessionKey"]);
+ $item->Set("LastAccessed", $result->fields["LastAccessed"]);
+ $item->Set("PortalUserId", $result->fields["PortalUserId"]);
+ $item->Set("Language", $result->fields["Language"]);
+ $item->Set("Theme" , $result->fields["Theme"]);
+ array_push($resultSet,$item);
+ $result->MoveNext();
+ }
+ return $resultSet;
+ }
+
+ function GetUniqueKey()
+ {
+ while(true)
+ {
+ /* create the new session key here */
+ mt_srand(100000000*(double)microtime());
+ $sessionId=strtoupper(sprintf("AD%xFD",mt_rand(100000000,999999999))); //9 digit hex session id
+ $query = "select SessionKey from ".GetTablePrefix()."UserSession ";
+ $query .= "where SessionKey='$sessionId' OR CurrentTempKey='$sessionId' OR PrevTempKey='$sessionId'";
+ $rs = $this->adodbConnection->Execute($query);
+ if($rs->EOF)
+ break;
+ if($i>100)
+ {
+ return "";
+ }
+ $i++;
+ }
+ //echo "Getting Unique Key: $sessionId<br>";
+ return $sessionId;
+ }
+
+ function GetNewSession()
+ {
+ global $sessionId, $objConfig, $objLanguages, $m_var_list, $FrontEnd;
+
+ $i=0;
+
+ if($this->Get("PortalUserId")>0 || $objConfig->Get("GuestSessions")==1)
+ {
+ //echo "Creating Session<br>\n";
+ $sessionId = $this->GetUniqueKey();
+ $this->Set("SessionKey", $sessionId);
+ $this->Set("CurrentTempKey",$sessionId);
+ if($m_var_list["lang"])
+ {
+ $this->Set("Language",$m_var_list["lang"]);
+ }
+ else
+ $this->Set("Language", $objLanguages->GetPrimary());
+ $this->SetThemeName();
+ //$this->Set("Theme", $objConfig->Get("Default_Theme"));
+ $this->UpdateAccessTime();
+ $this->Set("IpAddress", $_SERVER['REMOTE_ADDR'] );
+ $this->Create();
+
+ if($FrontEnd)
+ {
+ $application =& kApplication::Instance();
+ $application->HandleEvent( new kEvent('visits:OnRegisterVisit') );
+ }
+
+ }
+ else
+ $this->Set("SessionKey","");
+ }
+
+ function SessionEnabled()
+ {
+ $res = FALSE;
+ $key = $this->GetSessionKey();
+ if(strlen($key)>0)
+ $res = TRUE;
+ return $res;
+ }
+
+ function GetSessionKey()
+ {
+ return $this->Get("SessionKey");
+ }
+
+ function SetThemeName($id=0)
+ {
+ global $objThemes;
+
+ if($id==0)
+ $id = $objThemes->GetPrimaryTheme();
+
+ $Theme = $objThemes->GetItem($id);
+ $name = $Theme->Get("Name");
+ $this->Set("Theme",$name);
+ //$this->Update();
+ }
+
+ function ValidSession($SessionKey=NULL)
+ {
+ global $objConfig;
+
+ $a = $this->Get("LastAccessed");
+ $cutoff = adodb_mktime()-$objConfig->Get("SessionTimeout");
+ //echo $a." ".$cutoff."<br>";
+ //$ip = ($_SERVER['REMOTE_ADDR'] == $this->Get("IpAddress"));
+ //echo $this->Get("IpAddress");
+ //$ip = TRUE;
+ if ($a < $cutoff) {
+ //$this->UpdateAccessTime();
+ }
+ return ($a >= $cutoff);
+
+
+ }
+
+ function UpdateAccessTime()
+ {
+ $this->Set("LastAccessed", adodb_mktime() );
+ }
+
+ function InSpamControl($ResourceId,$DataType=NULL)
+ {
+ static $ClearStat;
+
+ if(!$ClearStat)
+ $this->PurgeSpamControl();
+ $ClearStat=1;
+ if(strlen($DataType))
+ $DataType="'".$DataType."'";
+ $sql = "SELECT count(*) as SpamCount FROM ".GetTablePrefix()."SpamControl WHERE ItemResourceId=$ResourceId AND DataType=$DataType";
+ if($this->Get("PortalUserId")==-2)
+ {
+ $sql .= " AND PortalUserId=-2 AND IPaddress='".$_SERVER["REMOTE_ADDR"]."'";
+ }
+ else
+ {
+ $sql .= " AND PortalUserId=".$this->Get("PortalUserId");
+ }
+ $rs = $this->adodbConnection->Execute($sql);
+ $value = (int)$rs->fields["SpamCount"];
+ if($value>0)
+ {
+ return TRUE;
+ }
+ else
+ return FALSE;
+ }
+
+ function AddToSpamControl($ResourceId,$secstoexpire,$DataType=NULL)
+ {
+ $expire = adodb_date("U") + $secstoexpire;
+ if(strlen($DataType))
+ $DataType = "'".$DataType."'";
+ $sql = "INSERT INTO ".GetTablePrefix()."SpamControl (ItemResourceId,IPaddress,Expire,PortalUserId,DataType) VALUES (";
+ $sql .= $ResourceId.",'".$_SERVER["REMOTE_ADDR"]."',$expire,".$this->Get("PortalUserId").",$DataType)";
+ //echo $sql;
+ $this->adodbConnection->Execute($sql);
+ }
+
+ function PurgeSpamControl()
+ {
+ $sql = "DELETE FROM ".GetTablePrefix()."SpamControl WHERE Expire<".adodb_date("U");
+
+ $this->adodbConnection->Execute($sql);
+ }
+
+}/* clsUserSession */
+
+?>
Property changes on: branches/unlabeled/unlabeled-1.54.2/kernel/include/usersession.php
___________________________________________________________________
Added: cvs2svn:cvs-rev
## -0,0 +1 ##
+1.54
\ No newline at end of property
Added: svn:executable
## -0,0 +1 ##
+*
\ No newline at end of property
Index: branches/unlabeled/unlabeled-1.54.2/core/units/categories/categories_config.php
===================================================================
--- branches/unlabeled/unlabeled-1.54.2/core/units/categories/categories_config.php (nonexistent)
+++ branches/unlabeled/unlabeled-1.54.2/core/units/categories/categories_config.php (revision 6783)
@@ -0,0 +1,278 @@
+<?php
+
+$config = Array(
+ 'Prefix' => 'c',
+ 'ItemClass' => Array('class'=>'CategoriesItem','file'=>'categories_item.php','build_event'=>'OnItemBuild'),
+ 'ListClass' => Array('class'=>'kDBList','file'=>'','build_event'=>'OnListBuild'),
+ 'EventHandlerClass' => Array('class'=>'CategoriesEventHandler','file'=>'categories_event_handler.php','build_event'=>'OnBuild'),
+ 'TagProcessorClass' => Array('class'=>'CategoriesTagProcessor','file'=>'categories_tag_processor.php','build_event'=>'OnBuild'),
+
+ 'RegisterClasses' => Array(
+ Array('pseudo' => 'kPermCacheUpdater','class' => 'kPermCacheUpdater', 'file' => 'cache_updater.php','build_event'=>''),
+ ),
+
+ 'AutoLoad' => true,
+ 'CatalogItem' => true,
+ 'AdminTemplatePath' => 'categories',
+ 'AdminTemplatePrefix' => 'categories_',
+
+ 'QueryString' => Array(
+ 1 => 'id',
+ 2 => 'page',
+ 3 => 'event',
+ 4 => 'mode',
+ ),
+ 'AggregateTags' => Array(
+ Array(
+ 'AggregateTo' => 'm',
+ 'AggregatedTagName' => 'CategoryLink',
+ 'LocalTagName' => 'CategoryLink',
+ ),
+ ),
+ 'IDField' => 'CategoryId',
+
+ 'StatusField' => Array('Status'),
+
+ 'TitleField' => 'Name', // field, used in bluebar when editing existing item
+ 'TitlePhrase' => 'la_Text_Category',
+ 'ItemType' => 1, // used for custom fields only
+
+ 'StatisticsInfo' => Array(
+ 'pending' => Array(
+ 'icon' => 'icon16_cat_pending.gif',
+ 'label' => 'la_tab_Categories',
+ 'js_url' => '#url#',
+ 'url' => Array('t' => 'advanced_view', 'SetTab' => 'c', 'pass' => 'm,c.showall', 'c.showall_event' => 'OnSetFilterPattern', 'c.showall_filters' => 'show_active=0,show_pending=1,show_disabled=0,show_new=1,show_pick=1'),
+ 'status' => STATUS_PENDING,
+ ),
+ ),
+
+ 'TableName' => TABLE_PREFIX.'Category',
+
+ 'ViewMenuPhrase' => 'la_text_Categories',
+
+ 'TitlePresets' => Array(
+ 'default' => Array( 'new_status_labels' => Array('c' => '!la_title_Adding_Category!'),
+ 'edit_status_labels' => Array('c' => '!la_title_Editing_Category!'),
+ 'new_titlefield' => Array('c' => '!la_title_New_Category!'),
+ ),
+ 'category_list' => Array('prefixes' => Array('c_List'), 'format' => "!la_title_Categories! (#c_recordcount#)"),
+
+ 'catalog' => Array('prefixes' => Array('c_List'), 'format' => "!la_title_Categories! (<span id='c_item_count'>#c_recordcount#</span>)"),
+
+ 'advanced_view' => Array('prefixes' => Array('c_List'), 'format' => "!la_title_AdvancedView!"),
+
+ 'categories_edit' => Array('prefixes' => Array('c'), 'format' => "#c_status# '#c_titlefield#' - !la_title_General!"),
+ 'categories_properties' => Array('prefixes' => Array('c'), 'format' => "#c_status# '#c_titlefield#' - !la_title_Properties!"),
+ 'categories_relations' => Array('prefixes' => Array('c'), 'format' => "#c_status# '#c_titlefield#' - !la_title_Relations!"),
+ 'categories_images' => Array('prefixes' => Array('c'), 'format' => "#c_status# '#c_titlefield#' - !la_title_Images!"),
+ 'categories_permissions'=> Array('prefixes' => Array('c', 'g_List'), 'format' => "#c_status# '#c_titlefield#' - !la_title_Permissions!"),
+ 'categories_custom' => Array('prefixes' => Array('c'), 'format' => "#c_status# '#c_titlefield#' - !la_title_Custom!"),
+
+ 'categories_update' => Array('prefixes' => Array(), 'format' => "!la_title_UpdatingCategories!"),
+
+ 'images_edit' => Array( 'prefixes' => Array('c', 'c-img'),
+ 'new_status_labels' => Array('c-img'=>'!la_title_Adding_Image!'),
+ 'edit_status_labels' => Array('c-img'=>'!la_title_Editing_Image!'),
+ 'new_titlefield' => Array('c-img'=>'!la_title_New_Image!'),
+ 'format' => "#c_status# '#c_titlefield#' - #c-img_status# '#c-img_titlefield#'",
+ ),
+
+ 'relations_edit' => Array( 'prefixes' => Array('c', 'c-rel'),
+ 'new_status_labels' => Array('c-rel'=>"!la_title_Adding_Relationship! '!la_title_New_Relationship!'"),
+ 'edit_status_labels' => Array('c-rel'=>'!la_title_Editing_Relationship!'),
+ 'format' => "#c_status# '#c_titlefield#' - #c-rel_status#",
+ ),
+
+ 'tree_site' => Array('format' => '!la_selecting_categories!'),
+ ),
+
+ 'PermItemPrefix' => 'CATEGORY',
+
+ 'PermSection' => Array('main' => 'CATEGORY:in-portal:categories', /*'search' => 'in-portal:configuration_search',*/ 'email' => 'in-portal:configuration_email', 'custom' => 'in-portal:configuration_custom'),
+
+
+ /* 'Sections' => Array(
+ // "Structure & Data" section
+ 'in-portal:site' => Array(
+ 'parent' => 'in-portal:root',
+ 'icon' => 'struct',
+ 'label' => 'la_tab_Site_Structure',
+ 'url' => Array('t' => 'sections_list', 'pass_section' => true, 'pass' => 'm'),
+ 'permissions' => Array('view'),
+ 'priority' => 1,
+ 'type' => stTREE,
+ ),
+
+ 'in-portal:browse' => Array(
+ 'parent' => 'in-portal:site',
+ 'icon' => 'catalog',
+ 'label' => 'la_tab_Browse',
+ 'url' => Array('t' => 'in-portal/catalog', 'pass' => 'm'),
+ 'late_load' => Array('t' => 'in-portal/xml/tree_categories', 'pass' => 'm', 'm_cat_id' => 0),
+ 'onclick' => 'checkCatalog(0)',
+ 'permissions' => Array('view'),
+ 'priority' => 0.1,
+ 'type' => stTREE,
+ ),
+ 'in-portal:advanced_view' => Array(
+ 'parent' => 'in-portal:site',
+ 'icon' => 'advanced_view',
+ 'label' => 'la_tab_AdvancedView',
+ 'url' => Array('t' => 'in-portal/advanced_view', 'pass' => 'm'),
+ 'permissions' => Array('view'),
+ 'priority' => 0.2,
+ 'type' => stTREE,
+ ),
+
+ 'in-portal:reviews' => Array(
+ 'parent' => 'in-portal:site',
+ 'icon' => 'reviews',
+ 'label' => 'la_tab_Reviews',
+ 'url' => Array('index_file' => 'reviews.php', 'pass' => 'm'),
+ 'permissions' => Array('view'),
+ 'priority' => 3,
+ 'type' => stTREE,
+ ),
+
+ 'in-portal:configure_categories' => Array(
+ 'parent' => 'in-portal:site',
+ 'icon' => 'cat_settings',
+ 'label' => 'la_tab_Settings',
+ 'url' => Array('t' => 'config/config_universal', 'pass_section' => true, 'pass' => 'm'),
+ 'permissions' => Array('view', 'edit'),
+ 'priority' => 4,
+ 'type' => stTREE,
+ ),
+
+ 'in-portal:configuration_search' => Array(
+ 'parent' => 'in-portal:site',
+ 'icon' => 'settings_search',
+ 'label' => 'la_tab_ConfigSearch',
+ 'url' => Array('t' => 'in-portal/config/config_search', 'module_key' => 'category', 'pass_section' => true, 'pass' => 'm'),
+ 'permissions' => Array('view', 'edit'),
+ 'priority' => 5,
+ 'type' => stTREE,
+ ),
+
+ 'in-portal:configuration_email' => Array(
+ 'parent' => 'in-portal:site',
+ 'icon' => 'settings_email',
+ 'label' => 'la_tab_ConfigE-mail',
+ 'url' => Array('t' => 'in-portal/config/config_email', 'module' => 'In-Portal:Category', 'pass_section' => true, 'pass' => 'm'),
+ 'permissions' => Array('view', 'edit'),
+ 'priority' => 6,
+ 'type' => stTREE,
+ ),
+
+ 'in-portal:configuration_custom' => Array(
+ 'parent' => 'in-portal:site',
+ 'icon' => 'settings_custom',
+ 'label' => 'la_tab_ConfigCustom',
+ 'url' => Array('t' => 'in-portal/custom_fields/custom_fields_list', 'cf_type' => 1, 'pass_section' => true, 'pass' => 'm,cf'),
+ 'permissions' => Array('view', 'add', 'edit', 'delete'),
+ 'priority' => 7,
+ 'type' => stTREE,
+ ),
+
+ ),*/
+
+ 'FilterMenu' => Array(
+ 'Groups' => Array(
+ Array('mode' => 'AND', 'filters' => Array('show_active','show_pending','show_disabled'), 'type' => WHERE_FILTER),
+ Array('mode' => 'AND', 'filters' => Array('show_new'), 'type' => HAVING_FILTER),
+ Array('mode' => 'AND', 'filters' => Array('show_pick'), 'type' => WHERE_FILTER),
+ ),
+ 'Filters' => Array(
+ 'show_active' => Array('label' =>'la_Active', 'on_sql' => '', 'off_sql' => 'Status != 1' ),
+ 'show_pending' => Array('label' => 'la_Pending', 'on_sql' => '', 'off_sql' => 'Status != 2' ),
+ 'show_disabled' => Array('label' => 'la_Disabled', 'on_sql' => '', 'off_sql' => 'Status != 0' ),
+ 's1' => Array(),
+ 'show_new' => Array('label' => 'la_Text_New', 'on_sql' => '', 'off_sql' => '`IsNew` != 1' ),
+ 'show_pick' => Array('label' => 'la_prompt_EditorsPick', 'on_sql' => '', 'off_sql' => '`EditorsPick` != 1' ),
+ )
+ ),
+
+ 'ListSQLs' => Array( ''=> ' SELECT %1$s.* %2$s
+ FROM %1$s
+ LEFT JOIN '.TABLE_PREFIX.'PermCache ON '.TABLE_PREFIX.'PermCache.CategoryId = %1$s.CategoryId
+ LEFT JOIN '.TABLE_PREFIX.'%3$sCategoryCustomData cust ON %1$s.ResourceId = cust.ResourceId'),
+
+ 'ItemSQLs' => Array( ''=> ' SELECT %1$s.* %2$s
+ FROM %1$s
+ LEFT JOIN '.TABLE_PREFIX.'PermCache ON '.TABLE_PREFIX.'PermCache.CategoryId = %1$s.CategoryId
+ LEFT JOIN '.TABLE_PREFIX.'%3$sCategoryCustomData cust ON %1$s.ResourceId = cust.ResourceId'),
+
+ 'SubItems' => Array('c-rel', 'c-img', 'c-cdata', 'c-perm'),
+
+ 'ListSortings' => Array(
+ '' => Array(
+ 'ForcedSorting' => Array("CurrentSort" => 'asc', 'Priority' => 'desc', 'Name' => 'asc'),
+ 'Sorting' => Array('Name' => 'asc'),
+ )
+ ),
+
+ 'CalculatedFields' => Array(
+ '' => Array(
+ 'CurrentSort' => "REPLACE(ParentPath, CONCAT('|', ".'%1$s'.".CategoryId, '|'), '')",
+ )
+ ),
+
+ 'Fields' => Array
+ (
+ 'CategoryId' => Array('type' => 'int','not_null' => 1,'default' => ''),
+ 'Type' => Array('type' => 'int','not_null' => 1,'default' => 0),
+ 'ParentId' => Array('type' => 'int','not_null' => 1,'default' => 0),
+ 'Name' => Array('type' => 'string', 'formatter' => 'kMultiLanguage', 'not_null' => 1, 'required' => 1, 'default' => ''),
+ 'Filename' => Array('type' => 'string', 'not_null' => 1, 'default' => ''),
+ 'AutomaticFilename' => Array('type' => 'int', 'not_null' => 1, 'default' => 1),
+ 'Description' => Array('type' => 'string', 'formatter' => 'kMultiLanguage', 'not_null' => 1, 'required' => 1, 'default' => ''),
+ 'CreatedOn' => Array('formatter' => 'kDateFormatter', 'default'=>'#NOW#', 'required' => 1, 'not_null' => 1),
+ 'EditorsPick' => Array('type' => 'int', 'not_null' => 1, 'default' => 0),
+ 'Status' => Array('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array (1 => 'la_Active', 2 => 'la_Pending', 0 => 'la_Disabled' ), 'use_phrases' => 1, 'not_null' => 1,'default' => 2),
+ 'Pop' => Array('type' => 'int', 'default' => ''),
+ 'Priority' => Array('type' => 'int', 'not_null' => 1, 'default' => ''),
+ 'MetaKeywords' => Array('type' => 'string', 'default' => ''),
+ 'CachedDescendantCatsQty' => Array('type' => 'int', 'default' => ''),
+ 'CachedNavbar' => Array('type' => 'string', 'formatter' => 'kMultiLanguage', 'not_null' => 1, 'default' => ''),
+ 'CreatedById' => Array('type' => 'int', 'formatter' => 'kLEFTFormatter', 'options' => Array(-1 => 'root', -2 => 'Guest'),'left_sql'=>'SELECT %s FROM '.TABLE_PREFIX.'PortalUser WHERE `%s` = \'%s\'', 'left_key_field' => 'PortalUserId', 'left_title_field' => 'Login', 'not_null' => 1,'default' => '0'),
+ 'ResourceId' => Array('type' => 'int', 'default' => ''),
+ 'ParentPath' => Array('type' => 'string', 'not_null' => 1, 'default' => ''),
+ 'NamedParentPath' => Array('type' => 'string', 'not_null' => 1, 'default' => ''),
+ 'MetaDescription' => Array('type' => 'string', 'default' => ''),
+ 'HotItem' => Array('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array (2 => 'la_Auto', 1 => 'la_Always', 0 => 'la_Never'), 'use_phrases' => 1, 'not_null' => 1, 'default' => 2),
+ 'NewItem' => Array('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array (2 => 'la_Auto', 1 => 'la_Always', 0 => 'la_Never'), 'use_phrases' => 1, 'not_null' => 1, 'default' => 2),
+ 'PopItem' => Array('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array (2 => 'la_Auto', 1 => 'la_Always', 0 => 'la_Never'), 'use_phrases' => 1, 'not_null' => 1, 'default' => 2),
+ 'Modified' => Array('type' => 'int', 'formatter' => 'kDateFormatter', 'not_null' => 1,'default' => '#NOW#'),
+ 'ModifiedById' => Array('type' => 'int', 'formatter' => 'kLEFTFormatter', 'options' => Array(-1 => 'root', -2 => 'Guest'),'left_sql'=>'SELECT %s FROM '.TABLE_PREFIX.'PortalUser WHERE `%s` = \'%s\'', 'left_key_field' => 'PortalUserId', 'left_title_field' => 'Login', 'not_null' => 1,'default' => '0'),
+ 'CategoryTemplate' => Array('type' => 'string', 'not_null' => 1, 'default' => ''),
+ 'CachedCategoryTemplate' => Array('type' => 'string', 'not_null' => 1, 'default' => ''),
+ ),
+
+ 'VirtualFields' => Array(
+ 'CurrentSort' => Array('type' => 'string', 'default' => ''),
+ 'IsNew' => Array('type' => 'int', 'default' => 0),
+ ),
+
+ 'Grids' => Array(
+ 'Default' => Array(
+ 'Icons' => Array('default'=>'icon16_cat.gif'),
+ 'Fields' => Array(
+ 'Name' => Array('title' => 'la_col_Name', 'data_block' => 'category_td'),
+ 'Description' => Array('title' => 'la_col_Description'),
+ 'CreatedOn_formatted' => Array('title' => 'la_col_CreatedOn', 'sort_field' => 'CreatedOn'),
+ ),
+
+ ),
+ ),
+
+ 'ConfigMapping' => Array(
+ 'PerPage' => 'Perpage_Category',
+ 'DefaultSorting1Field' => 'Category_Sortfield',
+ 'DefaultSorting2Field' => 'Category_Sortfield2',
+ 'DefaultSorting1Dir' => 'Category_Sortorder',
+ 'DefaultSorting2Dir' => 'Category_Sortorder2',
+ ),
+ );
+
+?>
\ No newline at end of file
Property changes on: branches/unlabeled/unlabeled-1.54.2/core/units/categories/categories_config.php
___________________________________________________________________
Added: cvs2svn:cvs-rev
## -0,0 +1 ##
+1.54
\ No newline at end of property
Added: svn:executable
## -0,0 +1 ##
+*
\ No newline at end of property

Event Timeline

In-Portal CMS · In-Portal Community Pages · In-Portal Issue Tracker · In-Portal Repository Browser · Quality Assurance · In-Portal CI Server