class clsConcept
{
var $strConceptDesc;
var $m_intConceptId;
var $m_intLangId;
function AddConcept()
{
$strSqlCheck = "SELECT * FROM `concept` WHERE ConceptDesc = '".$this->strConceptDesc."'";
$rsSqlCheck = mysql_query($strSqlCheck);
if($rsSqlCheck && mysql_num_rows($rsSqlCheck)==0)
{
$strMaxId = "SELECT MAX(pkConceptId) as LastId FROM `concept`";
$intRsMaxId = mysql_query($strMaxId);
if($intRsMaxId && mysql_num_rows($intRsMaxId)>0)
{
$intArrMaxId = mysql_fetch_array($intRsMaxId);
$intNewId = $intArrMaxId['LastId']+1;
}
else
$intNewId = 1;
$this->m_intConceptId = $intNewId;
$strSql = "INSERT INTO `concept` (pkConceptId,ConceptDesc) VALUES (".intval($this->m_intConceptId).",'".$this->strConceptDesc."')";
$rsSql = mysql_query($strSql);
if(mysql_affected_rows()>0)
return TRUE;
}
else
return FALSE;
}
function DeleteConcept()
{
$strSqlCheck = "SELECT * FROM `concept_cmsg` WHERE fkConceptId = '".intval($this->m_intConceptId)."'";
$rsSqlCheck = mysql_query($strSqlCheck);
if($rsSqlCheck && mysql_num_rows($rsSqlCheck)==0)
{
$strSql = "DELETE FROM `concept` WHERE pkConceptId = ".intval($this->m_intConceptId)."";
$rsSql = mysql_query($strSql);
if(mysql_affected_rows()>0)
{
$strSql = "DELETE FROM `concept_cmsg` WHERE fkConceptId = ".intval($this->m_intConceptId)."";
$rsSql = mysql_query($strSql);
return TRUE;
}
}
else
return FALSE;
}
function GetAllConcept()
{
$strSql="SELECT * FROM concept ORDER BY pkConceptId";
$rs = mysql_query($strSql);
return $rs;
}
function GetConceptById()
{
$strSql="SELECT * FROM concept where `pkConceptId`=".intval($this->m_intConceptId);
$rsSql = mysql_query($strSql);
if($rsSql && mysql_num_rows($rsSql)>0)
{
return $rsSql;
}
else return FALSE;
}
function UpdateConcept()
{
$strSql="SELECT * FROM `concept` where `pkConceptId`=".intval($this->m_intConceptId);
$rsSql = mysql_query($strSql);
if($rsSql)
while($obQry=mysql_fetch_object($rsSql))
{
if($obQry->ConceptDesc == $this->strConceptDesc)
{return 0;exit;}
}
$strSql="UPDATE `concept` SET `ConceptDesc` = '".$this->strConceptDesc."' WHERE `pkConceptId` = ".intval($this->m_intConceptId);
$rsSql = mysql_query($strSql);
if($rsSql && mysql_num_rows($rsSql)>0)
return true;
else
return false;
}
}
?>
class clsConfiguration
{
function Checkfile($strFileName)
{
if(file_exists($strFileName))
return true;
else
return false;
}
function GetDB($strHost, $strDatabase, $strUser, $strPass)
{
$strLink=mysql_connect($strHost, $strUser, $strPass);
if(!$strLink)
return "Connection could not be made";
$strDB=mysql_select_db($strDatabase,$strLink);
if(!$strDB)
return "Database not found.";
return true;
}
function GetDBTables()
{
$strSql="show tables";
$rsSql=mysql_query($strSql);
return $rsSql;
}
function DeleteDBTables($strDelTables)
{
if($strDelTables)
{
$rs=mysql_query("drop tables ".$strDelTables);
return $rs;
}
else
return false;
}
function DeleteTable($strTable)
{
$strDelQry="Drop table ".$strTable;
$nCheck=mysql_query($strDelQry);
return $nCheck;
}
function CreateDatabase($strDbName,$strHost,$strUser,$strPass)
{
$strLink=mysql_connect($strHost, $strUser, $strPass);
//echo "here===>",$strDbName;
$strDbQry="CREATE DATABASE `$strDbName`";
//echo "
",$strDbQry;exit;
$nCheck=mysql_query($strDbQry);
return $nCheck;
}
}
?>
/*
*****************************************************************************
* Date 30-06-2005 *
* Author: Yasir Abbasi (Software Engineer) *
* Owner: DigitalSpinners *
*****************************************************************************
*/
//--------------------- START CLASS FOR Roles & Rights --------------------------
class clsRoles
{
var $m_intRoleId;
var $m_strRoleDesc;
var $m_intRightId;
var $m_RightDesc;
var $m_intId;
var $m_strDesc;
function AddNewRole()
{
$strSqlCheck = "SELECT * FROM `roles` WHERE RoleDesc = '".$this->m_strRoleDesc."'";
$rsSqlCheck = mysql_query($strSqlCheck);
if(mysql_num_rows($rsSqlCheck)==0)
{
$strSql = "INSERT INTO `roles` (RoleDesc) VALUES ('".$this->m_strRoleDesc."')";
$rsSql = mysql_query($strSql);
if(mysql_affected_rows()>0)
return TRUE;
else
return FALSE;
}
else
return false;
}
function GetLatestRoleId() //------ TO Get NEW ADMIN USER Id ---------
{
$strSql= "SELECT max(pkRoleId) as pkRoleId from `roles`";
$rsSql= mysql_query($strSql);
if($rsSql && mysql_num_rows($rsSql)>0)
return $rsSql;
else
return 0;
}
function EditRole()
{
$strSql = "UPDATE `roles` SET RoleDesc = '".$this->m_strRoleDesc."' WHERE pkRoleId = ".intval($this->m_intRoleId)."";
$rsSql = mysql_query($strSql);
if(mysql_affected_rows()>0)
return TRUE;
else
return FALSE;
}
function DeleteRole()
{
$strSql = "DELETE FROM `roles` WHERE pkRoleId = ".intval($this->m_intRoleId)."";
$intCheck=mysql_query($strSql);
return $intCheck;
}
function GetRoleDetail()
{
if(isset($this->m_intRoleId)) //By ID
$strSql="SELECT * FROM roles where roles.pkRoleId=".intval($this->m_intRoleId);
else
$strSql="SELECT * FROM roles where roles.RoleDesc=".$this->m_strRoleDesc; //By Description
$rsRole = mysql_query($strSql);
return $rsRole;
}
function RolesList($intRecordStart=-1,$intPerPage=0)
{
$strSql="SELECT * FROM roles";
$strSql.=" ORDER by roles.pkRoleId";
if($intRecordStart!=-1 && $intPerPage!=0)//If Paging Required
$strSql.=" LIMIT $intRecordStart,$intPerPage";
$rsRoles = mysql_query($strSql);
return $rsRoles;
}
function GetRightGroups()
{
$strSql = "SELECT * FROM `right_groups`";
$rsSql = mysql_query($strSql);
if($rsSql && mysql_num_rows($rsSql)>0)
return $rsSql;
else
return 0;
}
function RightsList($intRecordStart=-1,$intPerPage=0)
{
$strSql="SELECT * FROM rights,right_groups where rights.fkGroupId=right_groups.pkId order by fkGroupId,pkRightId";
if($intRecordStart!=-1 && $intPerPage!=0) //If Paging Required
$strSql.=" LIMIT $intRecordStart,$intPerPage";
$rsRights = mysql_query($strSql);
if($rsRights && mysql_num_rows($rsRights)>0)
return $rsRights;
else
return 0;
}
function AddRightInRole()
{
$strSql = "INSERT INTO `rolesrights` (pkRoleId,pkRightId) VALUES (".intval($this->m_intRoleId).",'".intval($this->m_intRightId)."')";
$rsSql = mysql_query($strSql);
if(mysql_affected_rows()>0) return TRUE;
else return FALSE;
}
function IsRoleAssigned()
{
$strSql = "SELECT * FROM `admin_user_roles` WHERE pkRoleId=".intval($this->m_intRoleId);
$rsSql = mysql_query($strSql);
if($rsSql && mysql_num_rows($rsSql)>0)
return 1;
else return 0;
}
function CheckRightInRole()
{
$strSql = "SELECT * FROM `rolesrights` WHERE pkRoleId = ".intval($this->m_intRoleId)." and pkRightId=".intval($this->m_intRightId);
$rsSql = mysql_query($strSql);
if($rsSql && mysql_num_rows($rsSql)>0)
return 1;
else
return 0;
}
function DeleteRoleRights()
{
$strSql = "DELETE FROM `rolesrights` WHERE pkRoleId = ".intval($this->m_intRoleId);
$rsSql = mysql_query($strSql);
if(mysql_affected_rows()>0)
return TRUE;
else
return FALSE;
}
}
?>
/*
*****************************************************************************
* Date 19-Aug-2008 *
* Author: Abdul Qadir (Senior Web Developer) *
* Owner: DigitalSpinners *
*****************************************************************************
*/
//--------------------- START CLASS FOR Polling --------------------------
class clsPolling
{
var $m_nIdTableName;
var $m_nIdWhere;
var $m_nIdstrQry;
var $m_nIdOrderBy;
var $m_intId;
var $m_strDesc;
function select()
{
if($this->m_nIdOrderBy=='')
$this->m_nIdOrderBy='';
else
$Orderby = " order by ".$this->m_nIdOrderBy;
if($this->m_nIdWhere=='')
$this->m_nIdWhere='';
else
$Where = " Where ".$this->m_nIdWhere;
$sql="SELECT * FROM ".$this->m_nIdTableName.$Where.$Orderby;
//echo "query ---".$sql."