supernova-ws /
SuperNova
| 1 | <?php |
||
| 9 | |||
| 10 | // ALLY ************************************************************************************************************* |
||
| 11 | public static function db_ally_list_recalc_counts() { |
||
| 12 | doquery("UPDATE `{{alliance}}` AS a LEFT JOIN (SELECT ally_id, count(*) AS ally_memeber_count FROM `{{users}}` |
||
|
Deprecated Code
introduced
by
|
|||
| 13 | WHERE ally_id IS NOT NULL GROUP BY ally_id) AS u ON u.ally_id = a.id SET a.`ally_members` = u.ally_memeber_count;"); |
||
| 14 | } |
||
| 15 | |||
| 16 | public static function db_ally_request_list($ally_id) { |
||
| 17 | return doquery("SELECT {{alliance_requests}}.*, {{users}}.username FROM {{alliance_requests}} LEFT JOIN {{users}} ON {{users}}.id = {{alliance_requests}}.id_user WHERE id_ally='{$ally_id}'"); |
||
| 18 | } |
||
| 19 | |||
| 20 | public static function db_ally_request_get_by_user_id($player_id) { |
||
| 21 | return doquery("SELECT * FROM {{alliance_requests}} WHERE `id_user` ='{$player_id}' LIMIT 1;", true); |
||
| 22 | } |
||
| 23 | |||
| 24 | public static function db_ally_count() { |
||
| 25 | $result = doquery('SELECT COUNT(`id`) AS ally_count FROM `{{alliance}}`', true); |
||
| 26 | |||
| 27 | return isset($result['ally_count']) ? $result['ally_count'] : 0; |
||
| 28 | } |
||
| 33 | * @return array|bool|mysqli_result|null |
||
| 34 | */ |
||
| 35 | public static function db_ally_get_by_id($id_ally) { |
||
| 36 | $ally = doquery("SELECT * FROM `{{alliance}}` WHERE `id` ='{$id_ally}' LIMIT 1", true); |
||
| 37 | |||
| 38 | return $ally; |
||
| 39 | } |
||
| 44 | * @return array|bool|mysqli_result|null |
||
| 45 | */ |
||
| 46 | public static function db_ally_list_search($searchtext) { |
||
| 47 | $search = doquery("SELECT ally_name, ally_tag, total_rank, ally_members FROM {{alliance}} WHERE ally_tag LIKE '%{$searchtext}%' OR ally_name LIKE '%{$searchtext}%' LIMIT 30"); |
||
| 48 | |||
| 49 | return $search; |
||
| 50 | } |
||
| 56 | * @return array|bool|mysqli_result|null |
||
| 57 | */ |
||
| 58 | public static function db_ally_get_by_name_or_tag($ally_tag, $ally_name) { |
||
| 59 | $query = doquery("SELECT ally_tag FROM {{alliance}} WHERE `ally_tag` = '{$ally_tag}' or `ally_name` = '{$ally_name}' LIMIT 1;", true); |
||
| 60 | |||
| 61 | return $query; |
||
| 62 | } |
||
| 67 | * @return array|bool|mysqli_result|null |
||
| 68 | */ |
||
| 69 | public static function db_ally_get_by_name($ally_name) { |
||
| 70 | $query = doquery("SELECT ally_name FROM {{alliance}} WHERE `ally_name` = '{$ally_name}' LIMIT 1;", true); |
||
| 71 | |||
| 72 | return $query; |
||
| 73 | } |
||
| 78 | * @param $user |
||
| 79 | */ |
||
| 80 | public static function db_ally_insert($ally_name, $ally_tag, $user) { |
||
| 81 | $ally = doquery("INSERT INTO {{alliance}} SET |
||
| 82 | `ally_name` = '{$ally_name}', |
||
| 83 | `ally_tag` = '{$ally_tag}', |
||
| 84 | `ally_owner` = '{$user['id']}', |
||
| 85 | `ally_owner_range` = '" . classLocale::$lang['ali_leaderRank'] . "', |
||
| 86 | `ally_members` = 1, |
||
| 87 | `ranklist` = '" . classLocale::$lang['ali_defaultRankName'] . ",0,0,0,0,0', |
||
| 88 | `ally_register_time`= " . SN_TIME_NOW |
||
| 96 | * @param $ally_id |
||
| 97 | */ |
||
| 98 | public static function db_ally_update_ally_user($ally_user_id, $ally_id) { |
||
| 99 | doquery("UPDATE {{alliance}} SET ally_user_id = {$ally_user_id} WHERE id = {$ally_id} LIMIT 1;"); |
||
| 100 | } |
||
| 101 | |||
| 102 | /** |
||
| 105 | * @param $POST_text |
||
| 106 | */ |
||
| 107 | public static function db_ally_request_insert($user, $id_ally, $POST_text) { |
||
| 108 | doquery("INSERT INTO {{alliance_requests}} SET `id_user` = {$user['id']}, `id_ally`='{$id_ally}', request_text ='{$POST_text}', request_time=" . SN_TIME_NOW . ";"); |
||
| 109 | } |
||
| 110 | |||
| 111 | /** |
||
| 112 | * @param $user |
||
| 113 | */ |
||
| 114 | public static function db_ally_request_delete_by_user($user) { |
||
| 115 | doquery("DELETE FROM {{alliance_requests}} WHERE `id_user` = {$user['id']};"); |
||
| 116 | } |
||
| 117 | |||
| 118 | |||
| 122 | * @return array|bool|mysqli_result|null |
||
| 123 | */ |
||
| 124 | public static function db_ally_get_by_tag($tag) { |
||
| 125 | $ally = doquery("SELECT * FROM {{alliance}} WHERE ally_tag='{$tag}' LIMIT 1;", '', true); |
||
| 126 | |||
| 127 | return $ally; |
||
| 128 | } |
||
| 133 | * @return array|bool|mysqli_result|null |
||
| 134 | */ |
||
| 135 | public static function db_ally_search_by_name_or_tag($ali_search_text) { |
||
| 136 | $search = doquery("SELECT DISTINCT * FROM {{alliance}} WHERE `ally_name` LIKE '%{$ali_search_text}%' OR `ally_tag` LIKE '%{$ali_search_text}%' LIMIT 30"); |
||
| 137 | |||
| 138 | return $search; |
||
| 139 | } |
||
| 144 | * @return array|bool|mysqli_result|null |
||
| 145 | */ |
||
| 146 | public static function db_ally_request_count_by_id($ally) { |
||
| 147 | $request = doquery("SELECT COUNT(*) AS request_count FROM {{alliance_requests}} WHERE `id_ally` ='{$ally['id']}'", true); |
||
| 148 | |||
| 149 | return $request; |
||
| 150 | } |
||
| 155 | * @param $ally |
||
| 156 | */ |
||
| 157 | public static function db_ally_update_by_changeset($ally_changeset, $ally) { |
||
| 158 | doquery("UPDATE {{alliance}} SET " . implode(',', $ally_changeset) . " WHERE `id`='{$ally['id']}' LIMIT 1;"); |
||
| 159 | } |
||
| 160 | |||
| 161 | /** |
||
| 165 | * @param $ally |
||
| 166 | */ |
||
| 167 | public static function db_ally_update_texts($text_list, $allyTextID, $text, $ally) { |
||
| 168 | doquery("UPDATE {{alliance}} SET `{$text_list[$allyTextID]['db_field']}`='{$text['safe']}' WHERE `id`='{$ally['id']}';"); |
||
| 169 | } |
||
| 170 | |||
| 171 | /** |
||
| 173 | * @param $user |
||
| 174 | */ |
||
| 175 | public static function db_ally_update_owner($idNewLeader, $user) { |
||
| 176 | doquery("UPDATE {{alliance}} SET `ally_owner`='{$idNewLeader}' WHERE `id`={$user['ally_id']};"); |
||
| 177 | } |
||
| 178 | |||
| 179 | /** |
||
| 180 | * @param $ally |
||
| 181 | */ |
||
| 182 | public static function db_ally_delete($ally) { |
||
| 183 | doquery("DELETE FROM {{alliance}} WHERE id='{$ally['id']}';"); |
||
| 184 | } |
||
| 185 | |||
| 186 | |||
| 189 | * @param $alliance_negotiation_contr_ally_id |
||
| 190 | */ |
||
| 191 | public static function db_ally_negotiation_delete($user, $alliance_negotiation_contr_ally_id) { |
||
| 192 | doquery("DELETE FROM {{alliance_negotiation}} WHERE alliance_negotiation_ally_id = {$user['ally_id']} AND alliance_negotiation_contr_ally_id = {$alliance_negotiation_contr_ally_id} LIMIT 1;"); |
||
| 193 | } |
||
| 194 | |||
| 195 | /** |
||
| 198 | * @return array|bool|mysqli_result|null |
||
| 199 | */ |
||
| 200 | public static function db_ally_negotiation_get_by_offer_id($offer_id) { |
||
| 201 | $negotiation = doquery("SELECT * FROM {{alliance_negotiation}} WHERE alliance_negotiation_id = {$offer_id} LIMIT 1;", '', true); |
||
| 202 | |||
| 203 | return $negotiation; |
||
| 204 | } |
||
| 207 | * @param $offer_id |
||
| 208 | */ |
||
| 209 | public static function db_ally_negotiation_delete_by_offer_id($offer_id) { |
||
| 210 | doquery("DELETE FROM {{alliance_negotiation}} WHERE alliance_negotiation_id = {$offer_id} LIMIT 1;"); |
||
| 211 | } |
||
| 212 | |||
| 213 | /** |
||
| 214 | * @param $offer_id |
||
| 215 | */ |
||
| 216 | public static function db_ally_negotiation_update_status_1($offer_id) { |
||
| 217 | doquery("UPDATE {{alliance_negotiation}} SET alliance_negotiation_status = 1 WHERE alliance_negotiation_id = {$offer_id} LIMIT 1;"); |
||
| 218 | } |
||
| 219 | |||
| 220 | /** |
||
| 222 | * @param $user |
||
| 223 | */ |
||
| 224 | public static function db_ally_negotiatiion_delete_extended($negotiation, $user) { |
||
| 225 | doquery( |
||
| 226 | "DELETE FROM {{alliance_negotiation}} |
||
| 227 | WHERE |
||
| 228 | (alliance_negotiation_ally_id = {$negotiation['alliance_negotiation_ally_id']} AND alliance_negotiation_contr_ally_id = {$user['ally_id']}) |
||
| 237 | * @return array|bool|mysqli_result|null |
||
| 238 | */ |
||
| 239 | public static function db_ally_list_get_by_not_user_ally($user) { |
||
| 240 | $query = doquery("SELECT id, ally_name, ally_tag FROM {{alliance}} WHERE `id` != {$user['ally_id']} ORDER BY ally_name;"); |
||
| 241 | |||
| 242 | return $query; |
||
| 243 | } |
||
| 248 | * @return array|bool|mysqli_result|null |
||
| 249 | */ |
||
| 250 | public static function db_ally_negotiation_list($user) { |
||
| 251 | $query = doquery( |
||
| 252 | "SELECT |
||
| 253 | *, |
||
| 254 | if(alliance_negotiation_ally_id = {$user['ally_id']}, 1, 0) AS owner, |
||
| 266 | * @param $d |
||
| 267 | */ |
||
| 268 | public static function db_ally_request_deny($d) { |
||
| 269 | doquery("UPDATE {{alliance_requests}} SET `request_denied` = 1, `request_text` = '" . classLocale::$lang['ali_req_deny_reason'] . "' WHERE `id_user`= {$d} LIMIT 1;"); |
||
| 270 | } |
||
| 271 | |||
| 272 | /** |
||
| 273 | * @param $ally |
||
| 274 | */ |
||
| 275 | public static function db_ally_update_member_increase($ally) { |
||
| 276 | doquery("UPDATE {{alliance}} SET `ally_members`= `ally_members` + 1 WHERE `id`='{$ally['id']}'"); |
||
| 277 | } |
||
| 278 | |||
| 279 | /** |
||
| 280 | * @param $ally |
||
| 281 | */ |
||
| 282 | public static function db_ally_update_member_decrease($ally) { |
||
| 283 | doquery("UPDATE {{alliance}} SET `ally_members`= `ally_members` - 1 WHERE `id`='{$ally['id']}' LIMIT 1;"); |
||
| 284 | } |
||
| 285 | |||
| 286 | /** |
||
| 288 | * @param $ally |
||
| 289 | */ |
||
| 290 | public static function db_ally_update_member_set($i, $ally) { |
||
| 291 | doquery("UPDATE {{alliance}} SET `ally_members`='{$i}' WHERE `id`='{$ally['id']}'"); |
||
| 292 | } |
||
| 293 | |||
| 294 | /** |
||
| 295 | * @param $id_user |
||
| 296 | */ |
||
| 297 | public static function db_ally_request_delete_by_user_id($id_user) { |
||
| 298 | doquery("DELETE FROM {{alliance_requests}} WHERE `id_user`= '{$id_user}' LIMIT 1;"); |
||
| 299 | } |
||
| 300 | |||
| 301 | |||
| 305 | * @return array|bool|mysqli_result|null |
||
| 306 | */ |
||
| 307 | public static function db_ally_get_members_by_user_as_ally(&$user) { |
||
| 308 | $alliance = doquery("SELECT `ally_members` FROM {{alliance}} WHERE `ally_user_id` = {$user['id']}", true); |
||
| 309 | |||
| 310 | return $alliance; |
||
| 311 | } |
||
| 315 | * @param $user |
||
| 316 | */ |
||
| 317 | public static function db_ally_update_ranklist($ranklist, $user) { |
||
| 318 | doquery("UPDATE {{alliance}} SET `ranklist` = '{$ranklist}' WHERE `id` ='{$user['ally_id']}';"); |
||
| 319 | } |
||
| 320 | |||
| 321 | /** |
||
| 325 | * @return array|bool|mysqli_result|null |
||
| 326 | */ |
||
| 327 | public static function db_ally_diplomacy_get_relations($ally_from, $ally_to) { |
||
| 328 | $query = doquery( |
||
| 329 | "SELECT b.* |
||
| 330 | FROM |
||
| 331 | {{alliance_diplomacy}} AS b, |
||
| 348 | * @return array|bool|mysqli_result|null |
||
| 349 | */ |
||
| 350 | public static function db_ally_get_ally_count(&$user) { |
||
| 351 | $lab_level = doquery("SELECT ally_members AS effective_level FROM {{alliance}} WHERE id = {$user['user_as_ally']} LIMIT 1", true); |
||
| 352 | |||
| 353 | return $lab_level; |
||
| 354 | } |
||
| 355 | |||
| 356 | } |
Loading history...