customFunctions.inc.php

Go to the documentation of this file.

<?php
 
require_once(CH_DIRECTORY_PATH_INC . "db.inc.php");
require_once(CH_DIRECTORY_PATH_INC . "utils.inc.php");
require_once(CH_DIRECTORY_PATH_INC . "design.inc.php");
 
function loginUser($sName, $sPassword, $bLogin = false)
{
    $sField = $bLogin ? "NickName" : "ID";
    $sId = getValue("SELECT `ID` FROM `Profiles` WHERE `" . $sField . "`='" . $sName . "' AND `Password`='" . $sPassword . "' LIMIT 1");
 
    return !empty($sId) ? TRUE_VAL : FALSE_VAL;
}
 
function loginAdmin($sLogin, $sPassword)
{
    //--- Stanalone version.
    //global $sAdminLogin;
    //global $sAdminPassword;
    //$bResult = $sLogin == $sAdminLogin && $sPassword == $sAdminPassword ? TRUE_VAL : FALSE_VAL;
 
    //--- Cheetah version.
    $sName = getValue("SELECT `NickName` FROM `Profiles` WHERE `NickName`='$sLogin' AND `Password`='$sPassword' AND (`Role` & 2) LIMIT 1");
    $bResult = !empty($sName) ? TRUE_VAL : FALSE_VAL;
    //end of changes
 
    return $bResult;
}
 
 
function getUserInfo($sId, $bNick = false)
{
    global $sWomanImageUrl;
    global $sManImageUrl;
    global $sProfileUrl;
    global $sRootURL;
 
    //get info by ID on these fields
    $sNick = "";
    $sSex = "";
    $sAge = "0";
    $sDesc = "";
    $sPhoto = "";
    $sProfile = "";
 
    //You should change this query to retrieve user's data correctly
    $sWherePart = ($bNick ? "`NickName`" : "`ID`") . " = '" . $sId . "'";
    $aUser = getArray("SELECT * FROM `Profiles` WHERE " . $sWherePart . " LIMIT 1");
 
    $oBaseFunctions = ch_instance("ChBaseFunctions");
    $sSex = !empty($aUser['Sex']) ? $aUser['Sex'] : "male";
    $sPhoto = $oBaseFunctions->getMemberAvatar($sId);
    if(empty($sPhoto))
        $sPhoto = $sSex == "male" ? $sManImageUrl : $sWomanImageUrl;
    $sNick = $GLOBALS['oFunctions']->getUserTitle($sId);
    $sAge = isset($aUser['DateOfBirth']) ? getAge($aUser['DateOfBirth']) : "25";
    $sDesc = $GLOBALS['oFunctions']->getUserInfo($sId);
 
    $sProfile = getParam('enable_modrewrite') == "on" ? $sRootURL . $aUser['NickName'] : $sProfileUrl . "?ID=" . $sId;
 
    return array("id" => (int)$aUser["ID"], "nick" => $sNick, "sex" => $sSex, "age" => $sAge, "desc" => $sDesc, "photo" => $sPhoto, "profile" => $sProfile);
}
 
function getAge($sDob)
{
    $aDob = explode('-', $sDob);
    $iDobYear = $aDob[0];
    $iDobMonth = $aDob[1];
    $iDobDay = $aDob[2];
    $iAge = date('Y') - $iDobYear;
    if($iDobMonth > date('m'))
        $iAge--;
    else if($iDobMonth == date('m') && $iDobDay > date('d'))
        $iAge--;
    return $iAge;
}
 
function searchUser($sValue, $sField = "ID")
{
    if($sField == "ID")
       $sField = "ID";//you migth change this value on your user's ID column name
    else
       $sField = "NickName";//you migth change this value on your user's nick column name
 
    //Search for user and type result of this search
    $sId = getValue("SELECT `ID` FROM `Profiles` WHERE `" . $sField . "` = '" . $sValue . "' LIMIT 1");
    return $sId;
}
 
function getFriends($sId)
{
   $aUsers = array();
   $rResult = getResult("SELECT `Profile` FROM `sys_friend_list` WHERE `ID` = '" . $sId . "' AND `Check` = 1 UNION SELECT `ID` FROM `sys_friend_list` WHERE `Profile` = '" . $sId . "' AND `Check` = 1");
   while($aUser = $rResult->fetch()) $aUsers[] = $aUser['Profile'];
   return $aUsers;
}