} if ($_GET['application'] == 'accept') { check_membership(true); if ($game->player['user_alliance_rights6'] != 1) { message(NOTICE, constant($game->sprache("TEXT10"))); } $sql = 'SELECT * FROM alliance_application, user, alliance WHERE application_id = ' . $_GET['app_id'] . ' AND user_id = application_user AND alliance_id = application_alliance'; if (($application_data = $db->queryrow($sql)) === false) { message(DATABASE_ERROR, 'Could not query app data'); } if ($application_data['application_alliance'] != $game->player['user_alliance']) { message(NOTICE, constant($game->sprache("TEXT22"))); } SystemMessage($application_data['application_user'], constant($game->sprache("TEXT35")), constant($game->sprache("TEXT23")) . $application_data['alliance_name'] . constant($game->sprache("TEXT24")) . '<br>' . constant($game->sprache("TEXT25"))); $sql = 'UPDATE user SET user_alliance = ' . $application_data['application_alliance'] . ', user_alliance_status = ' . ALLIANCE_STATUS_MEMBER . ' WHERE user_id = ' . $application_data['application_user']; alliance_log('<font color=green>' . $application_data['application_username'] . '</font> ' . constant($game->sprache("TEXT26")) . ' (' . $game->player['user_name'] . ')', 0, $application_data['application_alliance']); if (!$db->query($sql)) { message(DATABASE_ERROR, 'Could not add user to alliance'); } $sql = 'INSERT INTO userally_history (user_id, alliance_id, join_date) VALUES (' . $application_data['application_user'] . ', ' . $application_data['application_alliance'] . ', ' . time() . ')'; if (!$db->query($sql)) { message(DATABASE_ERROR, 'Could not record userally history'); } /* if($application_data['application_read']!=1) { $sql = 'UPDATE alliance SET alliance_application_new = (alliance_application_new - 1) WHERE alliance_id = '.$game->player['user_alliance']; if(!$db->query($sql)) { message(DATABASE_ERROR, 'Could not Update alliance application READ'); } } */
SET user_alliance = 0, user_alliance_status = 0, user_alliance_rights1 = 0, user_alliance_rights2 = 0, user_alliance_rights3 = 0, user_alliance_rights4 = 0, user_alliance_rights5 = 0, user_alliance_rights6 = 0, user_alliance_rights7 = 0, user_alliance_rights8 = 0, last_alliance_kick = ' . $ACTUAL_TICK . ' WHERE user_id = ' . $user_id; if (!$db->query($sql)) { message(DATABASE_ERROR, 'Could not update user alliance data'); } alliance_log('<font color=green>' . $user_data['user_name'] . '</font> ' . constant($game->sprache("TEXT11")) . ' <font color=green>' . $game->player['user_name'] . '</font>' . constant($game->sprache("TEXT12"))); $sql = 'UPDATE userally_history SET leave_date = ' . time() . ' WHERE user_id = ' . $user_id . ' AND alliance_id = ' . $game->player['user_alliance']; if (!$db->query($sql)) { message(DATABASE_ERROR, 'Could not record userally history'); } $sql = 'UPDATE alliance SET alliance_points = alliance_points - ' . $user_data['user_points'] . ', alliance_planets = alliance_planets - ' . $user_data['user_planets'] . ', alliance_honor = alliance_honor - ' . $user_data['user_honor'] . ' WHERE alliance_id = ' . $game->player['user_alliance']; if (!$db->query($sql)) { message(DATABASE_ERROR, 'Could not update alliance data'); } SystemMessage($user_id, constant($game->sprache("TEXT13")), constant($game->sprache("TEXT14")) . ' <b>' . $game->player['alliance_name'] . '</b>' . constant($game->sprache("TEXT15"))); redirect('a=alliance_rights'); } elseif (!empty($_POST['kick'])) {
WHERE alliance_tag = "' . $alliance_tag . '" OR alliance_name = "' . $alliance_name . '"'; if (($ally_exists = $db->queryrow($sql)) === false) { message(DATABASE_ERROR, 'Could not query alliance name/tag data'); } if (!empty($ally_exists['alliance_id'])) { message(NOTICE, constant($game->sprache("TEXT54"))); } // Password entry removed $sql = 'INSERT INTO alliance (alliance_name, alliance_tag, alliance_owner, alliance_text, alliance_logo, alliance_homepage, alliance_points, alliance_planets, alliance_honor, alliance_application_text) VALUES ("' . $alliance_name . '", "' . $alliance_tag . '", "' . $game->player['user_id'] . '", "", "", "", ' . $game->player['user_points'] . ', ' . $game->player['user_planets'] . ', ' . $game->player['user_honor'] . ',"")'; if (!$db->query($sql)) { message(DATABASE_ERROR, 'Could not insert new alliance data'); } $new_alliance_id = $db->insert_id(); alliance_log('<font color=green>' . $game->player['user_name'] . '</font> ' . constant($game->sprache("TEXT55")) . ' <font color=red>' . $alliance_name . ' [' . $alliance_tag . ']</font> ' . constant($game->sprache("TEXT56")), 0, $new_alliance_id); $sql = 'UPDATE user SET user_alliance = ' . $new_alliance_id . ', user_alliance_status = ' . ALLIANCE_STATUS_OWNER . ', user_alliance_rights1 = 1, user_alliance_rights2 = 1, user_alliance_rights3 = 1, user_alliance_rights4 = 1, user_alliance_rights5 = 1, user_alliance_rights6 = 1, user_alliance_rights7 = 1, user_alliance_rights8 = 1 WHERE user_id = ' . $game->player['user_id']; if (!$db->query($sql)) { message(DATABASE_ERROR, 'Could not update user alliance data'); }