Kilka dni temu przestała mi działać strona i podczas logowania wyskakuje następujący komunikat:
1.
Fatal error: Call to a member function RecordCount() on a non-object in /virtual/pl/przychodnia-medicus/panel/classes/Admin.Auth.Class.php on line 23
A administrator serwisu active24 gdzie strona jest postawiona zgłasza inny błąd kodu:
2.
PHP Fatal error: Call to a member function FetchNextObject() on a non-object in
/virtual/pl/przychodnia-medicus/classes/Site.Class.php on line 13
Nie znam się dobrze na php i nie ja tworzyłem stronę a potrzebuje pilnej pomocy w jej reanimacji, poniżej przedstawiam
kody obu plików php. Proszę o pomoc
1.
<?php
class Auth extends Site {
function user_auth() {
$username = trim(addslashes($_POST['username']));
$pass = md5(trim(strip_tags($_POST['userpass'])));
//print_r($_POST);
if($username!='' || $pass!='') {
//verify if login data is empty/malformed
if($username=='')
{
$_POST['empty_username']=ERROR_NO_USERNAME;
}
if($pass=='')
{
$_POST['empty_password']=ERROR_NO_PASSWORD;
}
$check_query="SELECT name FROM ".USERS_TABLE." WHERE name='$username'";
//echo $check_query;
$query = $this->db->Execute($check_query);
if ($query->RecordCount()==1)
{
$check_query2="SELECT name FROM ".USERS_TABLE." WHERE name='$username' AND password='$pass'";
//echo $check_query2;
$query2 = $this->db->Execute($check_query2);
if ($query2->RecordCount()==1) {
$check_logged="SELECT name FROM ".USERS_TABLE." WHERE name='$username' AND password='$pass'";
$logged_query = $this->db->Execute($check_logged);
$sessionname= $this->sessionname;
$userlogin= $this->userlogin;
if ($logged_query->RecordCount()==1){
//if(!isset($_SESSION[$sessionname])) {
$salt='4@*&DFMsDFH';
$session_key=md5(time().$salt);
//$session_query="UPDATE ".USERS_TABLE." SET session_key='".$session_key."' WHERE name='".$username."' ";
//echo $session_query;
//$session_result=$this->db->Execute($session_query);
$_SESSION[$sessionname] = $session_key;
$_SESSION[$userlogin] = $username;
$_COOKIE['useriid']=md5($session_key);
}
else {
$_POST['good_name']=$username;
$_POST['already_logged']='UĹĽytkownik juĹĽ zalogowany';
}
}
else
{
$_POST['good_name']=$username;
$_POST['empty_password']=ERROR_NO_PASSWORD;
}
}
else
{
$_POST['empty_username']=ERROR_NO_USERNAME;
$_POST['empty_password']=ERROR_NO_PASSWORD;
}
}
else
{
if($username=='')
{
$_POST['empty_username']=ERROR_NO_USERNAME;
}
if($pass=='')
{
$_POST['empty_password']=ERROR_NO_PASSWORD;
}
}
}
function permission_check($module) {
$userlogin=$this->userlogin;
$username=$_SESSION[$userlogin];
$sessioname=$this->sessionname;
$key=$_SESSION[$sessioname];
$user_query="SELECT uid FROM ".USERS_TABLE." WHERE name='".$username."'";
//echo $user_query;
$u_result=$this->db->Execute($user_query);
$u_row=$u_result->FetchNextObject();
$user_id=$u_row->UID;
$perm_query="SELECT mid FROM users_permissions WHERE uid='".$user_id."'";
//echo $perm_query;
$p_result=$this->db->Execute($perm_query);
while($row=$p_result->FetchNextObject()) {
$perm_array[]=$row->MID;
}
//print_r($perm_array);
if(in_array($module,$perm_array)==TRUE) {
$permission=TRUE;
}
else
{
$permission=FALSE;
}
return $permission;
}
function get_module_id($name) {
$module_query="SELECT mid FROM modules WHERE module_string='".$name."'";
//echo $user_query;
$m_result=$this->db->Execute($module_query);
$m_row=$m_result->FetchNextObject();
$m_id=$m_row->MID;
return $m_id;
}
function logout()
{
$key=$_SESSION[$this->sessionname];
$userlogin=$this->userlogin;
$username=$_SESSION[$userlogin];
//$session_query="UPDATE ".USERS_TABLE." SET session_key=' ' WHERE name='".$key."' ";
//$session_result=$this->db->Execute($session_query);
session_unset();
session_destroy();
}
}
?>
-----------------------------------------------------------------------------------------------------------------------------------------
oraz 2.
<?php
class Site {
var $sessionname;
var $userlogin;
function __construct($db)
{
$this->db = $db;
$secret_word = '34#$%^13af';
$this->userlogin = md5('' . $secret_word);
$this->sessionname = md5('logged' . $secret_word);
}
function sanitize_variables()
{
if (get_magic_quotes_gpc() == 0) {
$_SERVER = $this->addslashes_array($_SERVER);
$_GET = $this->addslashes_array($_GET);
$_POST = $this->addslashes_array($_POST);
$_COOKIE = $this->addslashes_array($_COOKIE);
$_FILES = $this->addslashes_array($_FILES);
$_ENV = $this->addslashes_array($_ENV);
$_REQUEST = $this->addslashes_array($_REQUEST);
}
}
function addslashes_array($data)
{
if (is_array($data)) {
foreach ($data as $key => $value) {
$data[$key] = $this->addslashes_array($value);
}
return $data;
} else {
return addslashes($data);
}
}
function pages_array_list()
{
$select_sql = "SELECT * FROM " . PAGES_TABLE . " AS pages INNER JOIN " . PATT_TABLE . " AS att ON pages.id=att.id ORDER BY pages.id ASC";
// echo $select_sql;
$sql_query = $this->db->Execute($select_sql);
$count=$sql_query->RecordCount();
if($count>0) {
while ($row = $sql_query->FetchNextObject()) {
$page_array[$row->ID] = array('page_name' => $row->PAGE_NAME, 'page_tag' => $row->PAGE_TAG . '.php', 'parent' => $row->PARENT, 'container' => $row->CONTAINER);
}
}
return $page_array;
}
function sort_page_array()
{
$page_array = $this->pages_array_list();
foreach ($page_array as $key => $value) {
if ($value['parent'] != 0) {
$this->get_array_path($value['parent'], $page_array);
$append_name = $_SESSION['pagepath'];
unset($_SESSION['pagepath']);
// $append_name.='>';
} else {
$append_name = '';
}
$array[$key] = array('page_name' => $append_name . $value['page_name'], 'page_tag' => $value['page_tag'], 'parent' => $value['parent'], 'container' => $value['container']);
}
$array = $this->msort($array, 'page_name');
return $array;
}
function msort($array, $id = "page_name")
{
$temp_array = array();
while (count($array) > 0) {
$lowest_id = 0;
$index = 0;
foreach ($array as $item) {
if (isset($item[$id]) && $array[$lowest_id][$id]) {
if ($item[$id] < $array[$lowest_id][$id]) {
$lowest_id = $index;
}
}
$index++;
}
$temp_array[] = $array[$lowest_id];
$array = array_merge(array_slice($array, 0, $lowest_id), array_slice($array, $lowest_id + 1));
}
return $temp_array;
}
function get_array_path($parent, $page_array)
{
// echo $parent;
if (isset($page_array[$parent])) {
$_SESSION['pagepath'] .= $page_array[$parent]['page_name'] . ' > ';
$new_parent = $page_array[$parent]['parent'];
if ($new_parent != '0') {
$this->get_array_path($new_parent, $page_array);
}
}
}
function file_redirect($filename)
{
// used to redirect user to login if not signed up
$host = $_SERVER['HTTP_HOST'];
$extra = $filename . '.php';
$uri = rtrim(dirname($_SERVER['PHP_SELF']), '/\\');
header ("Location: http://" . $host . $uri . "/$extra");
exit;
}
function max_elements() {
$sql="SELECT * FROM ".CONF_TABLE." WHERE conf_name='page_list_max'";
$result = $this->db->Execute($sql);
$row= $result->FetchNextObject();
$max = $row->CONF_VALUE;
return $max;
}
function products_list_array(){
$sql="SELECT * FROM products ORDER BY product_id";
$result = $this->db->Execute($sql);
if($result->RecordCount()>0) {
?>
,["[ --- Produkty --- ]"," "]
<?php
while($row=$result->FetchNextObject()) {
?>
,["<?php echo htmlentities($row->PRODUCT_NAME, ENT_QUOTES,'utf-8'); ?>", "<?php echo 'product.php?id='.$row->PRODUCT_ID;?>"]
<?php
}
}
}
function submit_element($text)
{
?>
<tr class="border_bottom">
<td></td>
<td style="text-align: right; padding: 10px 20px 10px 10px;"><input type="image" src="img/cms_common/agree.gif" /></td>
<td>
</td>
</tr>
<?php
}
}
?>
.