$result = 0; if ($task == 'dosave') { $result = 1; $setting['setting_he_wall_comments_per_page'] = (int) $_POST['setting_he_wall_comments_per_page']; $setting['setting_he_wall_actions_per_page'] = (int) $_POST['setting_he_wall_actions_per_page']; $setting['setting_he_wall_guest_view'] = (int) $_POST['setting_he_wall_guest_view']; $setting['setting_he_wall_music_sync'] = (int) $_POST['setting_he_wall_music_sync']; $setting['setting_he_wall_video_sync'] = (int) $_POST['setting_he_wall_video_sync']; $setting['setting_he_wall_photo_sync'] = (int) $_POST['setting_he_wall_photo_sync']; $setting['setting_he_wall_video_player_width'] = (int) $_POST['setting_he_wall_video_player_width']; $setting['setting_he_wall_video_player_height'] = (int) $_POST['setting_he_wall_video_player_height']; $setting['setting_he_wall_video_thumb_width'] = (int) $_POST['setting_he_wall_video_thumb_width']; $setting['setting_he_wall_video_thumb_height'] = (int) $_POST['setting_he_wall_video_thumb_height']; $setting['setting_he_wall_photo_width'] = (int) $_POST['setting_he_wall_photo_width']; $setting['setting_he_wall_photo_height'] = (int) $_POST['setting_he_wall_photo_height']; $setting['setting_he_wall_photo_thumb_width'] = (int) $_POST['setting_he_wall_photo_thumb_width']; $setting['setting_he_wall_photo_thumb_height'] = (int) $_POST['setting_he_wall_photo_thumb_height']; $setting['setting_he_wall_photo_filesize'] = (int) $_POST['setting_he_wall_photo_filesize']; $setting['setting_he_wall_photo_exts'] = trim($_POST['setting_he_wall_photo_exts']); $setting['setting_he_wall_photo_mimes'] = trim($_POST['setting_he_wall_photo_mimes']); $setting['setting_he_wall_music_filesize'] = (int) $_POST['setting_he_wall_music_filesize']; $setting['setting_he_wall_music_exts'] = trim($_POST['setting_he_wall_music_exts']); $setting['setting_he_wall_music_mimes'] = trim($_POST['setting_he_wall_music_mimes']); $sql = he_database::placeholder("UPDATE `se_settings` SET \r\n `setting_he_wall_comments_per_page`=?, \r\n `setting_he_wall_actions_per_page`=?, \r\n `setting_he_wall_music_sync`=?,\r\n `setting_he_wall_video_sync`=?,\r\n `setting_he_wall_photo_sync`=?,\r\n `setting_he_wall_guest_view`=?,\r\n \r\n `setting_he_wall_video_player_width`=?,\r\n `setting_he_wall_video_player_height`=?,\r\n `setting_he_wall_video_thumb_width`=?,\r\n `setting_he_wall_video_thumb_height`=?,\r\n \r\n `setting_he_wall_photo_width`=?,\r\n `setting_he_wall_photo_height`=?,\r\n `setting_he_wall_photo_thumb_width`=?,\r\n `setting_he_wall_photo_thumb_height`=?,\r\n `setting_he_wall_photo_filesize`=?,\r\n `setting_he_wall_photo_exts`='?',\r\n `setting_he_wall_photo_mimes`='?',\r\n \r\n `setting_he_wall_music_filesize`=?,\r\n `setting_he_wall_music_exts`='?',\r\n `setting_he_wall_music_mimes`='?'", $setting['setting_he_wall_comments_per_page'], $setting['setting_he_wall_actions_per_page'], $setting['setting_he_wall_music_sync'], $setting['setting_he_wall_video_sync'], $setting['setting_he_wall_photo_sync'], $setting['setting_he_wall_guest_view'], $setting['setting_he_wall_video_player_width'], $setting['setting_he_wall_video_player_height'], $setting['setting_he_wall_video_thumb_width'], $setting['setting_he_wall_video_thumb_height'], $setting['setting_he_wall_photo_width'], $setting['setting_he_wall_photo_height'], $setting['setting_he_wall_photo_thumb_width'], $setting['setting_he_wall_photo_thumb_height'], $setting['setting_he_wall_photo_filesize'], $setting['setting_he_wall_photo_exts'], $setting['setting_he_wall_photo_mimes'], $setting['setting_he_wall_music_filesize'], $setting['setting_he_wall_music_exts'], $setting['setting_he_wall_music_mimes']); he_database::query($sql); } $smarty->assign('music_plugin_installed', $music_plugin_installed); $smarty->assign('album_plugin_installed', $album_plugin_installed); $smarty->assign('video_plugin_installed', $video_plugin_installed); $smarty->assign('result', $result); include "admin_footer.php";
function get_users($user_ids) { if (!$user_ids) { return array(); } $user_ids_str = implode(',', $user_ids); $sql = "SELECT `user_id`, `user_username`, `user_fname`, `user_lname`, `user_photo` FROM `se_users`\r\n \tWHERE `user_id` IN ({$user_ids_str})"; $user_list = array(); $res = he_database::query($sql); while ($row = he_database::fetch_row_from_resource($res)) { $author = new se_user(); $author->user_exists = 1; $author->user_info['user_id'] = $row['user_id']; $author->user_info['user_username'] = $row['user_username']; $author->user_info['user_fname'] = $row['user_fname']; $author->user_info['user_lname'] = $row['user_lname']; $author->user_info['user_photo'] = $row['user_photo']; $author->user_displayname(); $user_list[$row['user_id']] = $author; } return $user_list; }
/** * Checks if module has db structure and if it is needed upgrade or not * * @return void; */ function check_db_structure() { global $settings; $file_version = $this->get_version(); //check if db structure is ready if( !$settings['he_mass_mailing_version'] ) { if( !he_database::fetch_row("SHOW COLUMNS FROM se_settings LIKE 'he_mass_mailing_version'") ) { he_database::query("ALTER TABLE `se_settings` ADD `he_mass_mailing_version` int(10) NOT NULL DEFAULT $file_version"); he_database::query("ALTER TABLE `se_settings` ADD `he_mass_mailing_last_execute` int(10) NOT NULL"); he_database::query("ALTER TABLE `se_settings` ADD `he_mass_mailing_limit_per_execute` int(10) NOT NULL DEFAULT 30"); he_database::query("CREATE TABLE `se_he_mass_mailing_campaign` (`id` int(11) NOT NULL AUTO_INCREMENT,`subject` varchar(255) NOT NULL,`message` text NOT NULL,`sender` int(10) NOT NULL,`sent_time` int(10) unsigned NOT NULL,`is_email` tinyint(1) NOT NULL,PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;"); he_database::query("CREATE TABLE `se_he_mass_mailing_queue` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT,`campaign_id` int(11) NOT NULL,`recipient` int(10) NOT NULL,`email` varchar(64) NOT NULL,`full_name` varchar(128) NOT NULL,`replace` text NOT NULL,PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;"); $settings['he_mass_mailing_version'] = $file_version; } } //check db and file version if( $file_version > $settings['he_mass_mailing_version'] ) { //db version is older than file so we have to upgrade db version switch( $settings['he_mass_mailing_version'] ) { case 101: break; } } }
function fetch_field($query) { global $database; $row = $database->database_fetch_array(he_database::query($query)); return $row ? $row[0] : null; }
function recent_taked_quizzes($count = 10) { $query = he_database::placeholder("SELECT `play`.`user_id` AS `play_user_id`, `play`.`play_stamp`, `quiz`.*\r\n\t\t\tFROM `se_he_quiz_play` AS `play`\r\n\t\t\tINNER JOIN ( \r\n\t\t\t SELECT MAX(`play_stamp`) AS `play_stamp` FROM `se_he_quiz_play`\r\n\t\t\t WHERE `play_stamp`!=0\r\n\t\t\t GROUP BY `quiz_id`\r\n\t\t\t) AS `last` ON (`play`.`play_stamp`=`last`.`play_stamp`)\r\n\t\t\tINNER JOIN `se_he_quiz` AS `quiz` ON (`play`.`quiz_id`=`quiz`.`quiz_id`)\r\n\t\t\tWHERE `quiz`.approved = 1 AND `quiz`.`status`=1\r\n\t\t\tLIMIT ?", $count); $takes = array(); $res = he_database::query($query); $quiz_arr = array(); while ($quiz = he_database::fetch_row_from_resource($res)) { $quiz['user'] = new se_user(array($quiz['play_user_id'])); $quiz['photo_url'] = $quiz['photo'] ? he_quiz::photo_url() . $quiz['photo'] : ''; $quiz_arr[$quiz['quiz_id']] = $quiz; } return $quiz_arr; }
function delete_user_uploads() { $query = he_database::placeholder("DELETE FROM `se_he_uploads`\r\n WHERE `uploads_user_id`=? AND `uploads_instance_type`='?'", $this->user_id, $this->instance_type); he_database::query($query); }
exit; } // SET RESULT VARIABLE $result = 0; if ($task == "dosave") { $level_info['level_wall_allowed'] = $_POST['level_wall_allowed']; $level_info['level_wall_action_privacy'] = is_array($_POST['level_wall_action_privacy']) ? $_POST['level_wall_action_privacy'] : array(); //GET PRIVACY AND PRIVACY DIFFERENCES if (empty($level_info['level_wall_action_privacy']) || !is_array($level_info['level_wall_action_privacy'])) { $level_info['level_wall_action_privacy'] = array(63); } rsort($level_info['level_wall_action_privacy']); $new_privacy_options = $level_info['level_wall_action_privacy']; $level_info['level_wall_action_privacy'] = serialize($level_info['level_wall_action_privacy']); $query = he_database::placeholder("UPDATE `se_levels` SET `level_wall_allowed`=?, `level_wall_action_privacy`='?'\r\n WHERE `level_id`=?", $level_info['level_wall_allowed'], $level_info['level_wall_action_privacy'], $level_id); he_database::query($query); $result = 1; } // GET PREVIOUS PRIVACY SETTINGS $privacy_options = array(); for ($c = 6; $c > 0; $c--) { $priv = pow(2, $c) - 1; if (user_privacy_levels($priv) != "" && $priv != 1) { SE_Language::_preload(user_privacy_levels($priv)); $privacy_options[$priv] = user_privacy_levels($priv); } } // ASSIGN VARIABLES AND SHOW ADMIN ADD USER LEVEL PAGE $smarty->assign('result', $result); $smarty->assign('level_wall_action_privacy', unserialize($level_info['level_wall_action_privacy'])); $smarty->assign('privacy_options', $privacy_options);
function delete_he_wall_action() { $sql = "DELETE FROM se_he_wall_comment WHERE action_id NOT IN (SELECT action_id FROM se_actions)"; he_database::query($sql); $sql = "DELETE FROM se_he_wall_hidden_action WHERE action_id NOT IN (SELECT action_id FROM se_actions)"; he_database::query($sql); $sql = "DELETE FROM se_he_wall_like WHERE action_id NOT IN (SELECT action_id FROM se_actions)"; he_database::query($sql); he_wall::delete_action_uploads(); }