Determines if a query contains any rows
| public HasRecords ( string $sql = "" ) : boolean | ||
| $sql | string | [Optional] If specified, the query is first executed Otherwise, the last query is used for comparison |
| return | boolean | TRUE if records exist, FALSE if not or query error |
/** Đăng nhập admin cp */
function admin_cp_login()
{
global $hmuser;
$hmdb = new MySQL(true, DB_NAME, DB_HOST, DB_USER, DB_PASSWORD, DB_CHARSET);
hook_action('admin_cp_login');
$user_login = hm_post('login');
$password = hm_post('password');
$logmein = hm_post('log-me-in');
if (is_numeric($logmein)) {
$tableName = DB_PREFIX . "users";
$whereArray = array('user_login' => MySQL::SQLValue($user_login));
$hmdb->SelectRows($tableName, $whereArray);
if ($hmdb->HasRecords()) {
$row = $hmdb->Row();
$salt = $row->salt;
$user_pass = $row->user_pass;
$password_encode = hm_encode_str(md5($password . $salt));
if ($password_encode == $user_pass) {
$time = time();
$ip = hm_ip();
$cookie_array = array('time' => $time, 'ip' => $ip, 'user_login' => $user_login, 'admincp' => 'yes');
$cookie_user = hm_encode_str($cookie_array);
setcookie('admin_login', $cookie_user, time() + COOKIE_EXPIRES, '/');
$_SESSION['admin_login'] = $cookie_user;
return json_encode(array('status' => 'success', 'mes' => _('Đăng nhập thành công')));
} else {
return json_encode(array('status' => 'error', 'mes' => _('Sai mật khẩu')));
}
} else {
return json_encode(array('status' => 'error', 'mes' => _('Không có tài khoản này')));
}
}
}
return FALSE;
}
}
function get_uri_data($args)
{
$hmdb = new MySQL(true, DB_NAME, DB_HOST, DB_USER, DB_PASSWORD, DB_CHARSET);
if (!is_array($args)) {
parse_str($args, $args);
}
if (isset($args['uri'])) {
$uri = $args['uri'];
} else {
$uri = FALSE;
}
if (isset($args['id'])) {
$id_uri = $args['id'];
} else {
$id_uri = FALSE;
}
$tableName = DB_PREFIX . "request_uri";
if (is_numeric($id_uri)) {
$whereArray = array('id' => MySQL::SQLValue($id_uri));
} else {
$whereArray = array('uri' => MySQL::SQLValue($uri));
}
$hmdb->SelectRows($tableName, $whereArray);
if ($hmdb->HasRecords()) {
$row = $hmdb->Row();
return $row;
} else {
function list_plugin($active = 1)
{
$hmdb = new MySQL(true, DB_NAME, DB_HOST, DB_USER, DB_PASSWORD, DB_CHARSET);
$tableName = DB_PREFIX . "plugin";
$whereArray = array('active' => MySQL::SQLValue($active, MySQL::SQLVALUE_NUMBER));
$hmdb->SelectRows($tableName, $whereArray);
if ($hmdb->HasRecords()) {
while ($row = $hmdb->Row()) {
$return[] = $row->key;
}
return json_encode($return);
} else {
return array();
}
}
function is_theme_active($theme)
{
$hmdb = new MySQL(true, DB_NAME, DB_HOST, DB_USER, DB_PASSWORD, DB_CHARSET);
if (is_dir(BASEPATH . HM_THEME_DIR . '/' . $theme) and is_file(BASEPATH . HM_THEME_DIR . '/' . $theme . '/init.php')) {
$tableName = DB_PREFIX . "option";
$whereArray = array('section' => MySQL::SQLValue('system_setting'), 'key' => MySQL::SQLValue('theme'), 'value' => MySQL::SQLValue($theme));
$hmdb->SelectRows($tableName, $whereArray);
if ($hmdb->HasRecords()) {
return TRUE;
} else {
return FALSE;
}
} else {
return FALSE;
}
}
/** Kiểm tra mã đổi mật khẩu tồn tại */
function newpw_checkkey()
{
global $hmuser;
$hmdb = new MySQL(true, DB_NAME, DB_HOST, DB_USER, DB_PASSWORD, DB_CHARSET);
hook_action('newpw_checkkey');
$key = hm_get('key');
$tableName = DB_PREFIX . "field";
$whereArray = array('name' => MySQL::SQLValue('lostpw_key'), 'object_type' => MySQL::SQLValue('user'), 'val' => MySQL::SQLValue($key));
$hmdb->SelectRows($tableName, $whereArray);
if ($hmdb->HasRecords()) {
return TRUE;
} else {
hm_exit(_('Đường link đã hết hạn'));
}
}
/** bảng danh sách thành viên */
function user_show_data($user_group, $perpage)
{
$hmdb = new MySQL(true, DB_NAME, DB_HOST, DB_USER, DB_PASSWORD, DB_CHARSET);
hook_action('user_show_data');
$request_paged = hm_get('paged', 1);
$paged = $request_paged - 1;
$offset = $paged * $perpage;
$limit = "LIMIT {$perpage} OFFSET {$offset}";
if (!$hmdb->Query("SELECT * FROM " . DB_PREFIX . "users WHERE `user_group` = '{$user_group}' ORDER BY id DESC {$limit}")) {
$hmdb->Kill();
}
if ($hmdb->HasRecords()) {
/* Trả về các user */
while ($row = $hmdb->Row()) {
$array_use[] = array('id' => $row->id, 'user_nicename' => $row->user_nicename, 'user_role' => user_role_id_to_nicename($row->user_role));
}
$array['user'] = $array_use;
/* Tạo pagination */
$hmdb->Query(" SELECT * FROM " . DB_PREFIX . "users WHERE `user_group` = '{$user_group}' ");
$total_item = $hmdb->RowCount();
$total_page = ceil($total_item / $perpage);
$first = '1';
if ($request_paged > 1) {
$previous = $request_paged - 1;
} else {
$previous = $first;
}
if ($request_paged < $total_page) {
$next = $request_paged + 1;
} else {
$next = $total_page;
}
$array['pagination'] = array('first' => $first, 'previous' => $previous, 'next' => $next, 'last' => $total_page, 'total' => $total_item, 'paged' => $request_paged);
} else {
$array['user'] = array();
$array['pagination'] = array();
}
return hook_filter('user_show_data', json_encode($array, TRUE));
}
function content_show_data($key, $status, $perpage)
{
global $hmcontent;
$hmdb = new MySQL(true, DB_NAME, DB_HOST, DB_USER, DB_PASSWORD, DB_CHARSET);
hook_action('content_show_data');
$request_paged = hm_get('paged', 1);
$paged = $request_paged - 1;
$offset = $paged * $perpage;
$limit = "LIMIT {$perpage} OFFSET {$offset}";
if (!$hmdb->Query("SELECT * FROM " . DB_PREFIX . "content WHERE `key` = '{$key}' AND status = '{$status}' ORDER BY id DESC {$limit}")) {
$hmdb->Kill();
}
if ($hmdb->HasRecords()) {
/* Trả về các content */
while ($row = $hmdb->Row()) {
$array_con[] = array('id' => $row->id, 'name' => $row->name, 'slug' => $row->slug);
}
$array['content'] = $array_con;
/* Tạo pagination */
$hmdb->Query(" SELECT * FROM " . DB_PREFIX . "content WHERE `key` = '{$key}' AND status = '{$status}' ");
$total_item = $hmdb->RowCount();
$total_page = ceil($total_item / $perpage);
$first = '1';
if ($request_paged > 1) {
$previous = $request_paged - 1;
} else {
$previous = $first;
}
if ($request_paged < $total_page) {
$next = $request_paged + 1;
} else {
$next = $total_page;
}
$array['pagination'] = array('first' => $first, 'previous' => $previous, 'next' => $next, 'last' => $total_page, 'total' => $total_item, 'paged' => $request_paged);
$all_content = $hmcontent->hmcontent;
if (isset($all_content[$key]['chapter']) and $all_content[$key]['chapter'] == TRUE) {
$array['chapter'] = TRUE;
} else {
$array['chapter'] = FALSE;
}
} else {
$array['content'] = array();
$array['pagination'] = array();
$array['chapter'] = FALSE;
}
return hook_filter('content_show_data', json_encode($array, TRUE));
}
function taxonomy_checkbox_list($args = array())
{
hook_action('taxonomy_checkbox_list');
hook_filter('taxonomy_checkbox_list_before', $args);
global $hmtaxonomy;
$hmdb = new MySQL(true, DB_NAME, DB_HOST, DB_USER, DB_PASSWORD, DB_CHARSET);
@($key = $args['key']);
@($parent = $args['parent'] ? $args['parent'] : 0);
@($default_value = $args['default_value']);
@($object_id = $args['object_id']);
if (is_numeric($object_id)) {
$tableName = DB_PREFIX . "relationship";
$whereArray = array('object_id' => MySQL::SQLValue($object_id), 'relationship' => MySQL::SQLValue('contax'));
$hmdb->SelectRows($tableName, $whereArray);
while ($row = $hmdb->Row()) {
$default_value[] = $row->target_id;
}
}
if (!is_array($default_value)) {
$default_value = array();
}
$tax = $hmtaxonomy->hmtaxonomy;
if (isset($tax[$key])) {
$tableName = DB_PREFIX . "taxonomy";
$whereArray = array('key' => MySQL::SQLValue($key), 'parent' => MySQL::SQLValue($parent), 'status' => MySQL::SQLValue('public'));
$hmdb->SelectRows($tableName, $whereArray);
if ($hmdb->HasRecords()) {
if ($parent != 0) {
echo '<ul class="taxonomy_tree_sub_group taxonomy_tree_sub_group_of_' . $parent . '">';
}
while ($row = $hmdb->Row()) {
$taxs[] = $row;
}
foreach ($taxs as $tax) {
if (in_array($tax->id, $default_value)) {
$checked = 'checked';
} else {
$checked = '';
}
echo '<li data-id="' . $tax->id . '" data-slug="' . $tax->slug . '" class="tax_tree_item tax_tree_item_' . $tax->id . '">';
echo '<input type="checkbox" name="taxonomy[]" value="' . $tax->id . '" ' . $checked . ' /> ';
echo '<label>' . $tax->name . '</label>';
taxonomy_checkbox_list(array('key' => $key, 'parent' => $tax->id, 'default_value' => $default_value));
echo '</li>';
}
if ($parent != 0) {
echo '</ul>';
}
}
}
}
/** Ajax xóa thư mục */
function del_media_group($args)
{
$hmdb = new MySQL(true, DB_NAME, DB_HOST, DB_USER, DB_PASSWORD, DB_CHARSET);
$id = $args['group_id'];
if (is_numeric($id)) {
/** Xóa thư mục */
$path = BASEPATH . '/' . HM_CONTENT_DIR . '/uploads/' . get_media_group_part($id);
DeleteDir($path);
$tableName = DB_PREFIX . "media_groups";
$whereArray = array('id' => MySQL::SQLValue($id));
$hmdb->DeleteRows($tableName, $whereArray);
/** Xóa các file trong thư mục */
$tableName = DB_PREFIX . "media";
$whereArray = array('media_group_id' => MySQL::SQLValue($id));
$hmdb->SelectRows($tableName, $whereArray);
if ($hmdb->HasRecords()) {
while ($row = $hmdb->Row()) {
$id_media_file = $row->id;
delete_media($id_media_file);
}
}
/** Xóa thư mục con */
$tableName = DB_PREFIX . "media_groups";
$whereArray = array('parent' => MySQL::SQLValue($id));
$hmdb->SelectRows($tableName, $whereArray);
if ($hmdb->HasRecords()) {
while ($row = $hmdb->Row()) {
$id_sub_folder = $row->id;
del_media_group(array('group_id' => $id_sub_folder));
}
}
}
}
