function deleteTicket($n)
{
loadMessage($n, &$message);
$query = "DELETE FROM ss_tickets ";
$query .= "WHERE tic_subject = '" . $message->subject . "' AND tic_message = '" . $message->message . "'";
mysql_query($query);
}
require "includes/common.php";
$userID = $_SESSION["id"];
//retrieve message number
if (isset($HTTP_GET_VARS["msg"])) {
$msg = $HTTP_GET_VARS["msg"];
} else {
$msg = $_POST["msg"];
}
//delete message
if ($_POST["procedure"] == "DELETE") {
deleteMessage($userID, $msg);
header('Location: inbox.php');
}
//load message
if ($msg > "") {
loadMessage($userID, $msg, &$message);
}
$pageTitle = "View Message";
if ($_SESSION["type"] == "3") {
require 'includes/adminHeader.php';
} else {
require 'includes/userHeader.php';
}
?>
<br />
<table width="540" align="center">
<tr>
<td colspan="2">
<table align="left" cellpadding="2">
<tr>
public function unlove_item_recook($recook_id = false, $allow_print = false)
{
$message = lang('failed_save_data');
$status = 'error';
if (!empty($recook_id)) {
$message = lang('success_save_data');
$status = 'success';
$resLoveRecook = $this->db->query('CALL UnloveRecook(?,?)', array($recook_id, $this->session->userdata('userid')));
$resLoveRecook->next_result();
$resRecookHeader = $this->db->query('CALL GetRecookHeader(?,?)', array($recook_id, $this->session->userdata('userid')));
$valuesRecookHeader = $resRecookHeader->result_array();
$resRecookHeader->next_result();
$value = $valuesRecookHeader[0];
$recipe_id = $value['RecipeID'];
$slug = $value['Slug'];
$flag_love = $value['FlagRecookLove'];
loadSubview('common/action_bottom_find', array('recipe_id' => $recipe_id, 'recook_id' => $recook_id, 'slug' => $slug, 'flag_love' => $flag_love, 'flag_recook' => 1, 'flag_creator' => 1));
} else {
loadMessage($message, $status);
}
}
viewGroup();
break;
case 'createChatGroup':
createChatGroup();
break;
case 'updateChatGroupImage':
updateChatGroupImage();
break;
case 'chat':
chat();
break;
case 'dateRequest':
dateRequest();
break;
case 'loadMessage':
loadMessage();
break;
case 'loadMessageByUser':
loadMessageByUser();
break;
case 'shout':
shout();
break;
case 'addQuestion':
addQuestion();
break;
case 'addAnswer':
addAnswer();
break;
case 'addShop':
addShop();
public function register()
{
if ($this->session->userdata('loggedin')) {
$this->load->helper('url');
redirect($this->domain);
}
$this->load->library('form_validation');
$this->load->helper('form');
$this->load->helper('build_data');
$post = $this->input->post();
$message = 'Please fill all the required fields.';
$status = 'error';
$countries = $this->db->query('CALL GetCountry()');
$countries = buildDataDropdown($countries, 'CountryID', 'CountryName');
// To get the parameter redirect after
$get = $this->input->get();
if (!empty($post)) {
$this->form_validation->set_rules('fullname', 'Full name', 'required');
$this->form_validation->set_rules('email', 'Email', 'required|valid_email');
$this->form_validation->set_rules('password', 'Password', 'required');
$this->form_validation->set_rules('gender', 'Gender', 'required');
$this->form_validation->set_rules('CountryID', 'Country', 'required');
if ($this->form_validation->run() == TRUE) {
$res = $this->db->query('CALL RegisterUser(?,?,?,?,?)', array($post['fullname'], $post['email'], sha1($post['password']), $post['gender'], $post['CountryID']));
$data = $res->result()[0];
if ($data->UserID != -1) {
$this->session->set_userdata('loggedin', true);
$this->session->set_userdata('userid', $data->UserID);
$this->session->set_userdata('username', $post['fullname']);
$this->session->set_userdata('useremail', $post['email']);
$this->session->set_userdata('isAdmin', 0);
$this->session->set_userdata('userphoto', 'default');
if (isset($get['redirect_after'])) {
$this->session->set_userdata('redirect_now', true);
$this->session->set_userdata('redirect_after', $get['redirect_after']);
}
$message = 'Successfully signed up.';
$status = 'success';
} else {
$this->setCustomError('email', 'Email has been registered. Please try another email.');
}
}
}
$this->load->vars(array('redirect_after' => isset($get['redirect_after']) ? $get['redirect_after'] : false, 'countries' => $countries));
if ($this->input->is_ajax_request()) {
loadMessage($message, $status);
} else {
$this->load->vars(array('site_title' => 'Register'));
}
$this->render($post);
}
function follower_list($user_id = false)
{
$message = lang('failed_display_list_follower');
$status = 'error';
if (!empty($user_id)) {
$resFollowerUser = $this->db->query('CALL GetMyFollowerUser(?)', array($user_id));
$valuesUserFollower = $resFollowerUser->result_array();
$resFollowerUser->next_result();
$this->load->vars(array('valuesUserFollower' => $valuesUserFollower));
loadModal('follower_list');
} else {
loadMessage($message, $status);
loadModal('follower_list');
}
}
public function contact_us()
{
$this->load->helper('form');
$post = $this->input->post();
$message = false;
$status = false;
if (!empty($post)) {
$this->form_validation->set_rules('name', 'Name', 'required');
$this->form_validation->set_rules('email', 'Email', 'required|valid_email');
$this->form_validation->set_rules('message', 'Message', 'required');
if ($this->form_validation->run() == TRUE) {
$resInsertContactUs = $this->db->query('CALL InsertContactUs(?,?,?,?,?)', array($post['name'], $post['email'], $post['message'], $this->session->userdata('userid'), $this->getRealUserIp()));
$query_result = $resInsertContactUs->result();
$resInsertContactUs->next_result();
$message = lang('success_save_data');
$status = 'success';
} else {
$message = lang('failed_save_data');
$status = 'error';
}
}
$this->load->vars(array('site_title' => lang('contact_us')));
loadMessage($message, $status);
$this->render($post, 'Pages/' . $this->site_lang . '/contact_us');
}
$msg = $HTTP_GET_VARS["msg"];
} else {
$msg = $_POST["msg"];
}
//delete message
if ($_POST["procedure"] == "DELETE") {
deleteTicket($msg);
if ($_SESSION["type"] == "3") {
header('Location: tickets.php');
} else {
header('Location: main.php');
}
}
//load message
if ($msg > "") {
loadMessage($msg, &$message);
}
$pageTitle = "View Message";
if ($_SESSION["type"] == "3") {
require 'includes/adminHeader.php';
} else {
require 'includes/userHeader.php';
}
?>
<br />
<table width="540" align="center">
<tr>
<td colspan="2">
<table align="left" cellpadding="2">
<tr>
