}
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');
}
