@@ -75,7 +75,7 @@ |
||
| 75 | 75 | |
| 76 | 76 | |
| 77 | 77 | /** |
| 78 | - * @param $fleet_group_id_list |
|
| 78 | + * @param string $fleet_group_id_list |
|
| 79 | 79 | */ |
| 80 | 80 | public static function db_acs_delete_by_list($fleet_group_id_list) { |
| 81 | 81 | doquery("DELETE FROM {{aks}} WHERE `id` IN ({$fleet_group_id_list})"); |
@@ -51,16 +51,16 @@ |
||
| 51 | 51 | */ |
| 52 | 52 | public static function db_acs_insert($fleetid, $user, $objFleet) { |
| 53 | 53 | doquery("INSERT INTO {{aks}} SET |
| 54 | - `name` = '" . db_escape(classLocale::$lang['flt_acs_prefix'] . $fleetid) . "', |
|
| 55 | - `teilnehmer` = '" . $user['id'] . "', |
|
| 56 | - `flotten` = '" . $fleetid . "', |
|
| 57 | - `ankunft` = '" . $objFleet->time_arrive_to_target . "', |
|
| 58 | - `galaxy` = '" . $objFleet->fleet_end_galaxy . "', |
|
| 59 | - `system` = '" . $objFleet->fleet_end_system . "', |
|
| 60 | - `planet` = '" . $objFleet->fleet_end_planet . "', |
|
| 61 | - `planet_type` = '" . $objFleet->fleet_end_type . "', |
|
| 62 | - `eingeladen` = '" . $user['id'] . "', |
|
| 63 | - `fleet_end_time` = '" . $objFleet->time_return_to_source . "'"); |
|
| 54 | + `name` = '" . db_escape(classLocale::$lang['flt_acs_prefix'].$fleetid)."', |
|
| 55 | + `teilnehmer` = '" . $user['id']."', |
|
| 56 | + `flotten` = '" . $fleetid."', |
|
| 57 | + `ankunft` = '" . $objFleet->time_arrive_to_target."', |
|
| 58 | + `galaxy` = '" . $objFleet->fleet_end_galaxy."', |
|
| 59 | + `system` = '" . $objFleet->fleet_end_system."', |
|
| 60 | + `planet` = '" . $objFleet->fleet_end_planet."', |
|
| 61 | + `planet_type` = '" . $objFleet->fleet_end_type."', |
|
| 62 | + `eingeladen` = '" . $user['id']."', |
|
| 63 | + `fleet_end_time` = '" . $objFleet->time_return_to_source."'"); |
|
| 64 | 64 | } |
| 65 | 65 | |
| 66 | 66 | /** |
@@ -25,9 +25,9 @@ |
||
| 25 | 25 | } |
| 26 | 26 | |
| 27 | 27 | /** |
| 28 | - * @param $template |
|
| 29 | - * @param $query_where |
|
| 30 | - * @param $query_limit |
|
| 28 | + * @param template $template |
|
| 29 | + * @param string $query_where |
|
| 30 | + * @param integer $query_limit |
|
| 31 | 31 | * |
| 32 | 32 | * @return array|bool|mysqli_result|null |
| 33 | 33 | */ |
@@ -17,7 +17,7 @@ |
||
| 17 | 17 | * @param $user |
| 18 | 18 | * @param $survey_id |
| 19 | 19 | * @param $survey_vote_id |
| 20 | - * @param $user_name_safe |
|
| 20 | + * @param string $user_name_safe |
|
| 21 | 21 | */ |
| 22 | 22 | public static function db_survey_vote_insert(&$user, $survey_id, $survey_vote_id, $user_name_safe) { |
| 23 | 23 | doquery("INSERT INTO {{survey_votes}} SET `survey_parent_id` = {$survey_id}, `survey_parent_answer_id` = {$survey_vote_id}, `survey_vote_user_id` = {$user['id']}, `survey_vote_user_name` = '{$user_name_safe}';"); |
@@ -7,7 +7,7 @@ discard block |
||
| 7 | 7 | return doquery( |
| 8 | 8 | "SELECT * FROM {{messages}} |
| 9 | 9 | WHERE |
| 10 | - `message_type` = '" . MSG_TYPE_PLAYER . "' AND |
|
| 10 | + `message_type` = '" . MSG_TYPE_PLAYER."' AND |
|
| 11 | 11 | ((`message_owner` = '{$user['id']}' AND `message_sender` = '{$recipient_id}') |
| 12 | 12 | OR |
| 13 | 13 | (`message_sender` = '{$user['id']}' AND `message_owner` = '{$recipient_id}')) ORDER BY `message_time` DESC LIMIT 20;"); |
@@ -53,7 +53,7 @@ discard block |
||
| 53 | 53 | FROM |
| 54 | 54 | {{messages}} AS m |
| 55 | 55 | LEFT JOIN {{users}} AS u ON u.id = m.message_owner " . |
| 56 | - ($int_type_selected >= 0 ? "WHERE `message_type` = {$int_type_selected} " : '') . |
|
| 56 | + ($int_type_selected >= 0 ? "WHERE `message_type` = {$int_type_selected} " : ''). |
|
| 57 | 57 | "ORDER BY |
| 58 | 58 | `message_id` DESC |
| 59 | 59 | LIMIT |
@@ -61,7 +61,7 @@ discard block |
||
| 61 | 61 | } |
| 62 | 62 | |
| 63 | 63 | public static function db_message_insert_all($message_type, $from, $subject, $text) { |
| 64 | - return doquery($QryInsertMessage = 'INSERT INTO {{messages}} (`message_owner`, `message_sender`, `message_time`, `message_type`, `message_from`, `message_subject`, `message_text`) ' . |
|
| 64 | + return doquery($QryInsertMessage = 'INSERT INTO {{messages}} (`message_owner`, `message_sender`, `message_time`, `message_type`, `message_from`, `message_subject`, `message_text`) '. |
|
| 65 | 65 | "SELECT `id`, 0, unix_timestamp(now()), {$message_type}, '{$from}', '{$subject}', '{$text}' FROM {{users}}"); |
| 66 | 66 | } |
| 67 | 67 | |
@@ -71,7 +71,7 @@ discard block |
||
| 71 | 71 | * @return array|bool|mysqli_result|null |
| 72 | 72 | */ |
| 73 | 73 | public static function db_message_count_by_type($int_type_selected) { |
| 74 | - $page_max = doquery('SELECT COUNT(*) AS `max` FROM {{messages}}' . ($int_type_selected >= 0 ? " WHERE `message_type` = {$int_type_selected};" : ''), true); |
|
| 74 | + $page_max = doquery('SELECT COUNT(*) AS `max` FROM {{messages}}'.($int_type_selected >= 0 ? " WHERE `message_type` = {$int_type_selected};" : ''), true); |
|
| 75 | 75 | |
| 76 | 76 | return $page_max; |
| 77 | 77 | } |
@@ -88,15 +88,15 @@ discard block |
||
| 88 | 88 | * @param $int_type_selected |
| 89 | 89 | */ |
| 90 | 90 | public static function db_message_list_delete_by_date($delete_date, $int_type_selected) { |
| 91 | - doquery("DELETE FROM {{messages}} WHERE message_time <= UNIX_TIMESTAMP('{$delete_date}')" . ($int_type_selected >= 0 ? " AND `message_type` = {$int_type_selected}" : '')); |
|
| 91 | + doquery("DELETE FROM {{messages}} WHERE message_time <= UNIX_TIMESTAMP('{$delete_date}')".($int_type_selected >= 0 ? " AND `message_type` = {$int_type_selected}" : '')); |
|
| 92 | 92 | } |
| 93 | 93 | |
| 94 | 94 | /** |
| 95 | 95 | * @param $insert_values |
| 96 | 96 | */ |
| 97 | 97 | public static function db_message_insert($insert_values) { |
| 98 | - doquery('INSERT INTO {{messages}} (`message_owner`, `message_sender`, `message_time`, `message_type`, `message_from`, `message_subject`, `message_text`) ' . |
|
| 99 | - 'VALUES ' . implode(',', $insert_values)); |
|
| 98 | + doquery('INSERT INTO {{messages}} (`message_owner`, `message_sender`, `message_time`, `message_type`, `message_from`, `message_subject`, `message_text`) '. |
|
| 99 | + 'VALUES '.implode(',', $insert_values)); |
|
| 100 | 100 | } |
| 101 | 101 | |
| 102 | 102 | |
@@ -23,7 +23,7 @@ |
||
| 23 | 23 | * @return array|bool|mysqli_result|null |
| 24 | 24 | */ |
| 25 | 25 | public static function db_missile_list_by_arrival() { |
| 26 | - $iraks = doquery("SELECT * FROM {{iraks}} WHERE `fleet_end_time` <= " . SN_TIME_NOW . " FOR UPDATE;"); |
|
| 26 | + $iraks = doquery("SELECT * FROM {{iraks}} WHERE `fleet_end_time` <= ".SN_TIME_NOW." FOR UPDATE;"); |
|
| 27 | 27 | |
| 28 | 28 | return $iraks; |
| 29 | 29 | } |
@@ -48,106 +48,106 @@ discard block |
||
| 48 | 48 | } |
| 49 | 49 | |
| 50 | 50 | switch($mode) { |
| 51 | - case 'write': |
|
| 52 | - $error_list = array(); |
|
| 53 | - $template = gettemplate('msg_message_compose', true); |
|
| 51 | + case 'write': |
|
| 52 | + $error_list = array(); |
|
| 53 | + $template = gettemplate('msg_message_compose', true); |
|
| 54 | 54 | |
| 55 | - $recipient_name = sys_get_param_str_unsafe('recipient_name'); |
|
| 56 | - if($recipient_name) { |
|
| 57 | - $recipient_row = DBStaticUser::db_user_by_username($recipient_name); |
|
| 58 | - } |
|
| 55 | + $recipient_name = sys_get_param_str_unsafe('recipient_name'); |
|
| 56 | + if($recipient_name) { |
|
| 57 | + $recipient_row = DBStaticUser::db_user_by_username($recipient_name); |
|
| 58 | + } |
|
| 59 | 59 | |
| 60 | - if(!$recipient_row) { |
|
| 61 | - $recipient_id = sys_get_param_id('id'); |
|
| 62 | - $recipient_row = DBStaticUser::db_user_by_id($recipient_id); |
|
| 63 | 60 | if(!$recipient_row) { |
| 64 | - $recipient_id = 0; |
|
| 61 | + $recipient_id = sys_get_param_id('id'); |
|
| 62 | + $recipient_row = DBStaticUser::db_user_by_id($recipient_id); |
|
| 63 | + if(!$recipient_row) { |
|
| 64 | + $recipient_id = 0; |
|
| 65 | + } |
|
| 65 | 66 | } |
| 66 | - } |
|
| 67 | - |
|
| 68 | - if($recipient_row) { |
|
| 69 | - $recipient_id = $recipient_row['id']; |
|
| 70 | - $recipient_name = $recipient_row['username']; |
|
| 71 | - } |
|
| 72 | - |
|
| 73 | - if($recipient_id == $user['id']) { |
|
| 74 | - $error_list[] = array('MESSAGE' => classLocale::$lang['msg_err_self_send'], 'STATUS' => ERR_ERROR); |
|
| 75 | - } |
|
| 76 | - |
|
| 77 | - $re = 0; |
|
| 78 | - $subject = sys_get_param_str('subject'); |
|
| 79 | - while(strpos($subject, classLocale::$lang['msg_answer_prefix']) !== false) { |
|
| 80 | - $subject = substr($subject, strlen(classLocale::$lang['msg_answer_prefix'])); |
|
| 81 | - $re++; |
|
| 82 | - } |
|
| 83 | - $re ? $subject = classLocale::$lang['msg_answer_prefix'] . $subject : false; |
|
| 84 | 67 | |
| 85 | - if(sys_get_param_str('msg_send')) { |
|
| 86 | - $subject = $subject ? $subject : classLocale::$lang['msg_subject_default']; |
|
| 68 | + if($recipient_row) { |
|
| 69 | + $recipient_id = $recipient_row['id']; |
|
| 70 | + $recipient_name = $recipient_row['username']; |
|
| 71 | + } |
|
| 87 | 72 | |
| 88 | - if(!$recipient_id) { |
|
| 89 | - $error_list[] = array('MESSAGE' => classLocale::$lang['msg_err_player_not_found'], 'STATUS' => ERR_ERROR); |
|
| 73 | + if($recipient_id == $user['id']) { |
|
| 74 | + $error_list[] = array('MESSAGE' => classLocale::$lang['msg_err_self_send'], 'STATUS' => ERR_ERROR); |
|
| 90 | 75 | } |
| 91 | 76 | |
| 92 | - $text = sys_get_param_str('text'); |
|
| 93 | - if(!$text) { |
|
| 94 | - $error_list[] = array('MESSAGE' => classLocale::$lang['msg_err_no_text'], 'STATUS' => ERR_ERROR); |
|
| 77 | + $re = 0; |
|
| 78 | + $subject = sys_get_param_str('subject'); |
|
| 79 | + while(strpos($subject, classLocale::$lang['msg_answer_prefix']) !== false) { |
|
| 80 | + $subject = substr($subject, strlen(classLocale::$lang['msg_answer_prefix'])); |
|
| 81 | + $re++; |
|
| 95 | 82 | } |
| 83 | + $re ? $subject = classLocale::$lang['msg_answer_prefix'] . $subject : false; |
|
| 96 | 84 | |
| 97 | - if(empty($error_list)) { |
|
| 98 | - $error_list[] = array('MESSAGE' => classLocale::$lang['msg_not_message_sent'], 'STATUS' => ERR_NONE); |
|
| 85 | + if(sys_get_param_str('msg_send')) { |
|
| 86 | + $subject = $subject ? $subject : classLocale::$lang['msg_subject_default']; |
|
| 99 | 87 | |
| 100 | - $user_safe_name = db_escape($user['username']); |
|
| 101 | - $recipient_name = db_escape($recipient_name); |
|
| 102 | - msg_send_simple_message($recipient_id, $user['id'], SN_TIME_NOW, MSG_TYPE_PLAYER, "{$user_safe_name} [{$user['galaxy']}:{$user['system']}:{$user['planet']}]", $subject, $text, true); |
|
| 88 | + if(!$recipient_id) { |
|
| 89 | + $error_list[] = array('MESSAGE' => classLocale::$lang['msg_err_player_not_found'], 'STATUS' => ERR_ERROR); |
|
| 90 | + } |
|
| 103 | 91 | |
| 104 | - //$recipient_id = 0; |
|
| 105 | - //$recipient_name = ''; |
|
| 106 | - //$subject = ''; |
|
| 107 | - $text = ''; |
|
| 92 | + $text = sys_get_param_str('text'); |
|
| 93 | + if(!$text) { |
|
| 94 | + $error_list[] = array('MESSAGE' => classLocale::$lang['msg_err_no_text'], 'STATUS' => ERR_ERROR); |
|
| 95 | + } |
|
| 108 | 96 | |
| 109 | - $msg_sent = true; |
|
| 110 | - } else { |
|
| 111 | - $subject = sys_get_param_str_unsafe('subject'); |
|
| 112 | - $text = sys_get_param_str_unsafe('text'); |
|
| 113 | - } |
|
| 114 | - $recipient_name = sys_get_param_str_unsafe('recipient_name'); |
|
| 115 | - } |
|
| 97 | + if(empty($error_list)) { |
|
| 98 | + $error_list[] = array('MESSAGE' => classLocale::$lang['msg_not_message_sent'], 'STATUS' => ERR_NONE); |
|
| 116 | 99 | |
| 117 | - $subject = $subject ? $subject : classLocale::$lang['msg_subject_default']; |
|
| 100 | + $user_safe_name = db_escape($user['username']); |
|
| 101 | + $recipient_name = db_escape($recipient_name); |
|
| 102 | + msg_send_simple_message($recipient_id, $user['id'], SN_TIME_NOW, MSG_TYPE_PLAYER, "{$user_safe_name} [{$user['galaxy']}:{$user['system']}:{$user['planet']}]", $subject, $text, true); |
|
| 118 | 103 | |
| 119 | - $template->assign_vars(array( |
|
| 120 | - 'RECIPIENT_ID' => $recipient_id, |
|
| 121 | - 'RECIPIENT_NAME' => htmlspecialchars($recipient_name), |
|
| 122 | - 'SUBJECT' => htmlspecialchars($subject), |
|
| 123 | - 'TEXT' => htmlspecialchars($text), |
|
| 124 | - )); |
|
| 104 | + //$recipient_id = 0; |
|
| 105 | + //$recipient_name = ''; |
|
| 106 | + //$subject = ''; |
|
| 107 | + $text = ''; |
|
| 125 | 108 | |
| 126 | - foreach($error_list as $error_message) { |
|
| 127 | - $template->assign_block_vars('result', $error_message); |
|
| 128 | - } |
|
| 109 | + $msg_sent = true; |
|
| 110 | + } else { |
|
| 111 | + $subject = sys_get_param_str_unsafe('subject'); |
|
| 112 | + $text = sys_get_param_str_unsafe('text'); |
|
| 113 | + } |
|
| 114 | + $recipient_name = sys_get_param_str_unsafe('recipient_name'); |
|
| 115 | + } |
|
| 129 | 116 | |
| 130 | - $message_query = DBStaticMessages::db_message_list_get_last_20($user, $recipient_id); |
|
| 131 | - while($message_row = db_fetch($message_query)) { |
|
| 132 | - $template->assign_block_vars('messages', array( |
|
| 133 | - 'ID' => $message_row['message_id'], |
|
| 134 | - 'DATE' => date(FMT_DATE_TIME, $message_row['message_time'] + SN_CLIENT_TIME_DIFF), |
|
| 135 | - 'FROM' => htmlspecialchars($message_row['message_from']), |
|
| 136 | - 'SUBJ' => htmlspecialchars($message_row['message_subject']), |
|
| 137 | - 'TEXT' => in_array($message_row['message_type'], array(MSG_TYPE_PLAYER, MSG_TYPE_ALLIANCE)) && $message_row['message_sender'] ? nl2br(htmlspecialchars($message_row['message_text'])) : nl2br($message_row['message_text']), |
|
| 117 | + $subject = $subject ? $subject : classLocale::$lang['msg_subject_default']; |
|
| 138 | 118 | |
| 139 | - 'FROM_ID' => $message_row['message_sender'], |
|
| 119 | + $template->assign_vars(array( |
|
| 120 | + 'RECIPIENT_ID' => $recipient_id, |
|
| 121 | + 'RECIPIENT_NAME' => htmlspecialchars($recipient_name), |
|
| 122 | + 'SUBJECT' => htmlspecialchars($subject), |
|
| 123 | + 'TEXT' => htmlspecialchars($text), |
|
| 140 | 124 | )); |
| 141 | - } |
|
| 142 | 125 | |
| 143 | - break; |
|
| 126 | + foreach($error_list as $error_message) { |
|
| 127 | + $template->assign_block_vars('result', $error_message); |
|
| 128 | + } |
|
| 129 | + |
|
| 130 | + $message_query = DBStaticMessages::db_message_list_get_last_20($user, $recipient_id); |
|
| 131 | + while($message_row = db_fetch($message_query)) { |
|
| 132 | + $template->assign_block_vars('messages', array( |
|
| 133 | + 'ID' => $message_row['message_id'], |
|
| 134 | + 'DATE' => date(FMT_DATE_TIME, $message_row['message_time'] + SN_CLIENT_TIME_DIFF), |
|
| 135 | + 'FROM' => htmlspecialchars($message_row['message_from']), |
|
| 136 | + 'SUBJ' => htmlspecialchars($message_row['message_subject']), |
|
| 137 | + 'TEXT' => in_array($message_row['message_type'], array(MSG_TYPE_PLAYER, MSG_TYPE_ALLIANCE)) && $message_row['message_sender'] ? nl2br(htmlspecialchars($message_row['message_text'])) : nl2br($message_row['message_text']), |
|
| 138 | + |
|
| 139 | + 'FROM_ID' => $message_row['message_sender'], |
|
| 140 | + )); |
|
| 141 | + } |
|
| 144 | 142 | |
| 145 | - case 'delete': |
|
| 146 | - $query_add = ''; |
|
| 143 | + break; |
|
| 147 | 144 | |
| 148 | - $message_range = sys_get_param_str('message_range'); |
|
| 145 | + case 'delete': |
|
| 146 | + $query_add = ''; |
|
| 149 | 147 | |
| 150 | - switch($message_range) { |
|
| 148 | + $message_range = sys_get_param_str('message_range'); |
|
| 149 | + |
|
| 150 | + switch($message_range) { |
|
| 151 | 151 | case 'unchecked': |
| 152 | 152 | case 'checked': |
| 153 | 153 | $marked_message_list = sys_get_param('mark', array()); |
@@ -171,65 +171,65 @@ discard block |
||
| 171 | 171 | case 'all': |
| 172 | 172 | $query_add = $query_add ? $query_add : true; |
| 173 | 173 | break; |
| 174 | - } |
|
| 174 | + } |
|
| 175 | 175 | |
| 176 | 176 | if($query_add) { |
| 177 | 177 | $query_add = $query_add === true ? '' : $query_add; |
| 178 | 178 | DBStaticMessages::db_message_list_delete($user, $query_add); |
| 179 | 179 | } |
| 180 | 180 | |
| 181 | - case 'show': |
|
| 182 | - if($current_class == MSG_TYPE_OUTBOX) { |
|
| 183 | - $message_query = DBStaticMessages::db_message_list_outbox_by_user_id($user['id']); |
|
| 184 | - } else { |
|
| 185 | - if($current_class == MSG_TYPE_NEW) { |
|
| 186 | - $SubUpdateQry = array(); |
|
| 187 | - foreach($sn_message_class_list as $message_class_id => $message_class) { |
|
| 188 | - if($message_class_id != MSG_TYPE_OUTBOX) { |
|
| 189 | - $SubUpdateQry[] = "`{$message_class['name']}` = '0'"; |
|
| 190 | - $user[$message_class['name']] = 0; |
|
| 181 | + case 'show': |
|
| 182 | + if($current_class == MSG_TYPE_OUTBOX) { |
|
| 183 | + $message_query = DBStaticMessages::db_message_list_outbox_by_user_id($user['id']); |
|
| 184 | + } else { |
|
| 185 | + if($current_class == MSG_TYPE_NEW) { |
|
| 186 | + $SubUpdateQry = array(); |
|
| 187 | + foreach($sn_message_class_list as $message_class_id => $message_class) { |
|
| 188 | + if($message_class_id != MSG_TYPE_OUTBOX) { |
|
| 189 | + $SubUpdateQry[] = "`{$message_class['name']}` = '0'"; |
|
| 190 | + $user[$message_class['name']] = 0; |
|
| 191 | + } |
|
| 191 | 192 | } |
| 193 | + $SubUpdateQry = implode(',', $SubUpdateQry); |
|
| 194 | + } else { |
|
| 195 | + $SubUpdateQry = "`{$sn_message_class_list[$current_class]['name']}` = '0', `{$sn_message_class_list[MSG_TYPE_NEW]['name']}` = `{$sn_message_class_list[MSG_TYPE_NEW]['name']}` - '{$user[$sn_message_class_list[$current_class]['name']]}'"; |
|
| 196 | + $SubSelectQry = "AND `message_type` = '{$current_class}'"; |
|
| 197 | + |
|
| 198 | + $user[$sn_message_class_list[MSG_TYPE_NEW]['name']] -= $user[$sn_message_class_list[$current_class]['name']]; |
|
| 199 | + $user[$sn_message_class_list[$current_class]['name']] = 0; |
|
| 192 | 200 | } |
| 193 | - $SubUpdateQry = implode(',', $SubUpdateQry); |
|
| 194 | - } else { |
|
| 195 | - $SubUpdateQry = "`{$sn_message_class_list[$current_class]['name']}` = '0', `{$sn_message_class_list[MSG_TYPE_NEW]['name']}` = `{$sn_message_class_list[MSG_TYPE_NEW]['name']}` - '{$user[$sn_message_class_list[$current_class]['name']]}'"; |
|
| 196 | - $SubSelectQry = "AND `message_type` = '{$current_class}'"; |
|
| 197 | 201 | |
| 198 | - $user[$sn_message_class_list[MSG_TYPE_NEW]['name']] -= $user[$sn_message_class_list[$current_class]['name']]; |
|
| 199 | - $user[$sn_message_class_list[$current_class]['name']] = 0; |
|
| 202 | + DBStaticUser::db_user_set_by_id($user['id'], $SubUpdateQry); |
|
| 203 | + $message_query = DBStaticMessages::db_message_list_by_owner_and_string($user, $SubSelectQry); |
|
| 200 | 204 | } |
| 201 | 205 | |
| 202 | - DBStaticUser::db_user_set_by_id($user['id'], $SubUpdateQry); |
|
| 203 | - $message_query = DBStaticMessages::db_message_list_by_owner_and_string($user, $SubSelectQry); |
|
| 204 | - } |
|
| 205 | - |
|
| 206 | - if(sys_get_param_int('return')) { |
|
| 207 | - header('Location: messages.php'); |
|
| 208 | - die(); |
|
| 209 | - } |
|
| 206 | + if(sys_get_param_int('return')) { |
|
| 207 | + header('Location: messages.php'); |
|
| 208 | + die(); |
|
| 209 | + } |
|
| 210 | 210 | |
| 211 | - $template = gettemplate('msg_message_list', true); |
|
| 212 | - while($message_row = db_fetch($message_query)) { |
|
| 213 | - $template->assign_block_vars('messages', array( |
|
| 214 | - 'ID' => $message_row['message_id'], |
|
| 215 | - 'DATE' => date(FMT_DATE_TIME, $message_row['message_time'] + SN_CLIENT_TIME_DIFF), |
|
| 216 | - 'FROM' => htmlspecialchars($message_row['message_from']), |
|
| 217 | - 'SUBJ' => htmlspecialchars($message_row['message_subject']), |
|
| 218 | - 'TEXT' => in_array($message_row['message_type'], array(MSG_TYPE_PLAYER, MSG_TYPE_ALLIANCE)) && $message_row['message_sender'] ? nl2br(htmlspecialchars($message_row['message_text'])) : nl2br($message_row['message_text']), |
|
| 219 | - |
|
| 220 | - 'FROM_ID' => $message_row['message_sender'], |
|
| 221 | - 'SUBJ_SANITIZED' => htmlspecialchars($message_row['message_subject']), |
|
| 222 | - 'STYLE' => $current_class == MSG_TYPE_OUTBOX ? $sn_message_class_list[MSG_TYPE_OUTBOX]['name'] : $sn_message_class_list[$message_row['message_type']]['name'], |
|
| 223 | - )); |
|
| 224 | - } |
|
| 211 | + $template = gettemplate('msg_message_list', true); |
|
| 212 | + while($message_row = db_fetch($message_query)) { |
|
| 213 | + $template->assign_block_vars('messages', array( |
|
| 214 | + 'ID' => $message_row['message_id'], |
|
| 215 | + 'DATE' => date(FMT_DATE_TIME, $message_row['message_time'] + SN_CLIENT_TIME_DIFF), |
|
| 216 | + 'FROM' => htmlspecialchars($message_row['message_from']), |
|
| 217 | + 'SUBJ' => htmlspecialchars($message_row['message_subject']), |
|
| 218 | + 'TEXT' => in_array($message_row['message_type'], array(MSG_TYPE_PLAYER, MSG_TYPE_ALLIANCE)) && $message_row['message_sender'] ? nl2br(htmlspecialchars($message_row['message_text'])) : nl2br($message_row['message_text']), |
|
| 219 | + |
|
| 220 | + 'FROM_ID' => $message_row['message_sender'], |
|
| 221 | + 'SUBJ_SANITIZED' => htmlspecialchars($message_row['message_subject']), |
|
| 222 | + 'STYLE' => $current_class == MSG_TYPE_OUTBOX ? $sn_message_class_list[MSG_TYPE_OUTBOX]['name'] : $sn_message_class_list[$message_row['message_type']]['name'], |
|
| 223 | + )); |
|
| 224 | + } |
|
| 225 | 225 | |
| 226 | - $current_class_text = classLocale::$lang['msg_class'][$current_class]; |
|
| 226 | + $current_class_text = classLocale::$lang['msg_class'][$current_class]; |
|
| 227 | 227 | |
| 228 | - $template->assign_vars(array( |
|
| 229 | - "MESSAGE_CLASS" => $current_class, |
|
| 230 | - "MESSAGE_CLASS_TEXT" => $current_class_text, |
|
| 231 | - )); |
|
| 232 | - break; |
|
| 228 | + $template->assign_vars(array( |
|
| 229 | + "MESSAGE_CLASS" => $current_class, |
|
| 230 | + "MESSAGE_CLASS_TEXT" => $current_class_text, |
|
| 231 | + )); |
|
| 232 | + break; |
|
| 233 | 233 | } |
| 234 | 234 | |
| 235 | 235 | if(!$template) { |
@@ -9,7 +9,7 @@ discard block |
||
| 9 | 9 | */ |
| 10 | 10 | |
| 11 | 11 | $allow_anonymous = true; |
| 12 | -include('common.' . substr(strrchr(__FILE__, '.'), 1)); |
|
| 12 | +include('common.'.substr(strrchr(__FILE__, '.'), 1)); |
|
| 13 | 13 | |
| 14 | 14 | global $config; |
| 15 | 15 | |
@@ -23,40 +23,40 @@ discard block |
||
| 23 | 23 | $mode = sys_get_param_str('mode'); |
| 24 | 24 | |
| 25 | 25 | $announce = array(); |
| 26 | -if($user['authlevel'] >= 3) { |
|
| 27 | - if(!empty($text)) { |
|
| 26 | +if ($user['authlevel'] >= 3) { |
|
| 27 | + if (!empty($text)) { |
|
| 28 | 28 | $announce_time = strtotime($announce_time, SN_TIME_NOW); |
| 29 | 29 | $announce_time = $announce_time ? $announce_time : SN_TIME_NOW; |
| 30 | 30 | |
| 31 | - if($mode == 'edit') { |
|
| 31 | + if ($mode == 'edit') { |
|
| 32 | 32 | DBStaticNews::db_news_update_set($announce_time, $text, $detail_url, $announce_id); |
| 33 | 33 | DBStaticSurvey::db_survey_delete_by_id($announce_id); |
| 34 | 34 | } else { |
| 35 | 35 | DBStaticNews::db_news_insert_set($announce_time, $text, $detail_url, $user); |
| 36 | 36 | $announce_id = db_insert_id(); |
| 37 | 37 | } |
| 38 | - if(($survey_question = sys_get_param_str('survey_question')) && ($survey_answers = sys_get_param('survey_answers'))) { |
|
| 38 | + if (($survey_question = sys_get_param_str('survey_question')) && ($survey_answers = sys_get_param('survey_answers'))) { |
|
| 39 | 39 | $survey_answers = explode("\r\n", $survey_answers); |
| 40 | 40 | $survey_until = strtotime($survey_until = sys_get_param_str('survey_until'), SN_TIME_NOW); |
| 41 | 41 | $survey_until = date(FMT_DATE_TIME_SQL, $survey_until ? $survey_until : SN_TIME_NOW + PERIOD_DAY * 1); |
| 42 | 42 | DBStaticSurvey::db_survey_insert($announce_id, $survey_question, $survey_until); |
| 43 | 43 | $survey_id = db_insert_id(); |
| 44 | - foreach($survey_answers as $survey_answer) { |
|
| 44 | + foreach ($survey_answers as $survey_answer) { |
|
| 45 | 45 | $survey_answer = db_escape(trim($survey_answer)); |
| 46 | - if(empty($survey_answer)) { |
|
| 46 | + if (empty($survey_answer)) { |
|
| 47 | 47 | continue; |
| 48 | 48 | } |
| 49 | 49 | DBStaticSurveyAnswer::db_survey_answer_insert($survey_id, $survey_answer); |
| 50 | 50 | } |
| 51 | 51 | } |
| 52 | 52 | |
| 53 | - if($announce_time <= SN_TIME_NOW) { |
|
| 54 | - if($announce_time > $config->var_news_last && $announce_time == SN_TIME_NOW) { |
|
| 53 | + if ($announce_time <= SN_TIME_NOW) { |
|
| 54 | + if ($announce_time > $config->var_news_last && $announce_time == SN_TIME_NOW) { |
|
| 55 | 55 | $config->db_saveItem('var_news_last', $announce_time); |
| 56 | 56 | } |
| 57 | 57 | |
| 58 | - if(sys_get_param_int('news_mass_mail')) { |
|
| 59 | - $text = sys_get_param('text') . ($detail_url ? " <a href=\"{$detail_url}\"><span class=\"positive\">{$lang['news_more']}</span></a>" : ''); |
|
| 58 | + if (sys_get_param_int('news_mass_mail')) { |
|
| 59 | + $text = sys_get_param('text').($detail_url ? " <a href=\"{$detail_url}\"><span class=\"positive\">{$lang['news_more']}</span></a>" : ''); |
|
| 60 | 60 | msg_send_simple_message('*', 0, 0, MSG_TYPE_ADMIN, $lang['sys_administration'], $lang['news_title'], $text); |
| 61 | 61 | } |
| 62 | 62 | } |
@@ -66,7 +66,7 @@ discard block |
||
| 66 | 66 | } |
| 67 | 67 | |
| 68 | 68 | $survey_answers = ''; |
| 69 | - switch($mode) { |
|
| 69 | + switch ($mode) { |
|
| 70 | 70 | case 'del': |
| 71 | 71 | DBStaticNews::db_news_delete_by_id($announce_id); |
| 72 | 72 | $mode = ''; |
@@ -76,9 +76,9 @@ discard block |
||
| 76 | 76 | $template->assign_var('ID', $announce_id); |
| 77 | 77 | case 'copy': |
| 78 | 78 | $announce = DBStaticNews::db_news_with_survey_select_by_id($announce_id); |
| 79 | - if($announce['survey_id']) { |
|
| 79 | + if ($announce['survey_id']) { |
|
| 80 | 80 | $query = DBStaticSurveyAnswer::db_survey_answer_text_select_by_news($announce); |
| 81 | - while($row = db_fetch($query)) { |
|
| 81 | + while ($row = db_fetch($query)) { |
|
| 82 | 82 | $survey_answers[] = $row['survey_answer_text']; |
| 83 | 83 | } |
| 84 | 84 | $survey_answers = implode("\r\n", $survey_answers); |
@@ -86,7 +86,7 @@ discard block |
||
| 86 | 86 | break; |
| 87 | 87 | } |
| 88 | 88 | } else { |
| 89 | - $annQuery = 'WHERE UNIX_TIMESTAMP(`tsTimeStamp`) <= ' . SN_TIME_NOW; |
|
| 89 | + $annQuery = 'WHERE UNIX_TIMESTAMP(`tsTimeStamp`) <= '.SN_TIME_NOW; |
|
| 90 | 90 | } |
| 91 | 91 | |
| 92 | 92 | nws_render($template, $annQuery, 20); |