function call_move_text() { global $local_stats,$id,$confirm,$target,$tool; include_once('inc/functions/resort_tools.php'); check_access($tool); echo "<form method=\"post\" action=\"".$_SERVER['REQUEST_URI']."\">" . "Input user id: <input name=id size=5><br>" . "Move to alliance: <input name=target size=5><br>" . '<label>Check if touring:</label>' . '<input type="checkbox" name="tourer">' . "<input type=submit value=Move name=confirm>" . "</form>" . "<br><br>"; if ($confirm && $id && $target) { //if ($target == 1 && $local_stats[LEVEL] < 5) // $target = 2; echo "User $id has been move to alliance $target"; $orkTime = date(TIMESTAMP_FORMAT); $search = mysql_query("SELECT * FROM stats WHERE id = $id"); $search = mysql_fetch_array($search); //mysql_query("UPDATE stats SET kingdom = $target, type ='player', invested = 0 where id = $id"); //mysql_query("UPDATE rankings_personal SET alli_id = $target where id = $id"); //mysql_query("UPDATE stats SET vote = 0, invested = 0 WHERE vote = $id"); //mysql_query("UPDATE goods SET credits = 0, market_money = 0, market_food = 0, market_soldiers = 0, market_wood = 0 WHERE id = $id"); move_tribe($id, $target); mysql_query("INSERT INTO news (id, time, ip, type, duser, ouser, result, text, kingdom_text, kingdoma, kingdomb) VALUES ('', '$orkTime', '---', 'Mod Move', '0', '0', '1', '', '<font class=\"indicator\">$search[tribe] was moved from #$search[kingdom] to #$target!</font>', '$search[kingdom]', '$target')"); } }
function call_tour_move_text() { global $local_stats, $id, $confirm, $target, $tool; include_once 'inc/functions/resort_tools.php'; check_access($tool); $alli_id = ''; if (isset($_POST['alli_id'])) { $alli_id = intval($_POST['alli_id']); } echo '<h2>ORKFiA Tour!</h2>'; $strForm = "<form method=\"post\" action=\"" . $_SERVER['REQUEST_URI'] . "\">" . '<label>Where is our touring tribe? Alliance #</label> ' . '<input name="alli_id" size="3" value="' . $alli_id . '"/><br /><br />'; if (isset($_POST['alli_id']) && !empty($_POST['alli_id'])) { $iAlliance = intval($_POST['alli_id']); include 'inc/functions/vote.php'; // select everyone in this alliance $strSQL = "SELECT * " . " FROM stats " . " WHERE kingdom = " . $iAlliance . " ORDER BY tribe ASC"; $result = mysql_query($strSQL) or die("Elder Defect:" . mysql_error()); $strForm .= "<label>Select the lucky tribe</label>: " . '<select name="id" size="1">' . render_option_list($result, TRIBE, ID, 0) . '</select><br /><br />' . '<label>Where will they apparate to? Alliance #</label>: ' . '<input name="target" size="5" /><br /><br />' . '<input type="submit" value="Move Tourer" name="confirm">'; } else { $strForm .= '<input type="submit" value="Choose Alliance" name="confirm">'; } $strForm .= "</form>"; echo $strForm; if (isset($_POST['confirm']) && isset($_POST['id']) && !empty($_POST['id']) && isset($_POST['target']) && !empty($_POST['target'])) { $id = intval($_POST['id']); $target = intval($_POST['target']); $trgTmpUser = new clsUser($id); $strTribeName = ucwords(stripslashes($trgTmpUser->get_stat(TRIBE))); if ($trgTmpUser->get_build(LAND) != 1) { echo '<p>"W-T-F mate?" That was not a tourer tribe.</p></div>'; include_game_down(); exit; } elseif ($target < 11) { echo '<p>"W-T-F mate?" No apparating into staff alliances.</p></div>'; include_game_down(); exit; } echo "<p>Leader! The tribe of " . $strTribeName . " has now apparated to alliance #<strong>{$target}</strong>. Let us hope that neither of their citizens got splinched.</p>"; $orkTime = date(TIMESTAMP_FORMAT); $search = mysql_query("SELECT * FROM stats WHERE id = {$id}"); $search = mysql_fetch_array($search); //mysql_query("UPDATE stats SET kingdom = $target, type ='player', invested = 0 where id = $id"); //mysql_query("UPDATE rankings_personal SET alli_id = $target where id = $id"); //mysql_query("UPDATE stats SET vote = 0, invested = 0 WHERE vote = $id"); //mysql_query("UPDATE goods SET credits = 0, market_money = 0, market_food = 0, market_soldiers = 0, market_wood = 0 WHERE id = $id"); include_once 'inc/staff/move.inc.php'; move_tribe($id, $target); mysql_query("INSERT INTO news (id, time, ip, type, duser, ouser, result, text, kingdom_text, kingdoma, kingdomb) VALUES ('', '{$orkTime}', '---', 'Tour Move', '0', '0', '1', '', '<span class=\"indicator\">{$search['tribe']} has joined our alliance. Long live Orkfia! Long live the tour!</span>', '', '{$target}')"); } }
function call_mergers_text() { global $userid, $task, $mergerid, $checker, $listtribeid, $changedname, $declinereason, $local_stats, $tool; include_once 'inc/functions/resort_tools.php'; // we're abstracting the actual moving out to there include_once 'inc/staff/move.inc.php'; //if (! user_has_access($tool)) //{ // echo "Sorry, this page is restricted to ORKFiA Staff"; // include_game_down(); // exit; //} check_access($tool); $orkTime = date('YmdHis'); echo "<h2>Select task:</h2><br />| <a href='main.php?cat=game&page=resort_tools&tool=mergers&task=pending'>View Pending Mergers</a> | <a href='main.php?cat=game&page=resort_tools&tool=mergers&task=done'>View Done Mergers</a> | <a href='main.php?cat=game&page=resort_tools&tool=mergers&task=rejected'>View Declined Mergers</a> | <a href='main.php?cat=game&page=resort_tools&tool=mergers&task=requested'>View Requested Mergers</a> |<br /><br />"; if ($task == "changename") { // loads a form where you can change the requested name of a tribe $seek = mysql_query("SELECT newname FROM mergers WHERE id = {$mergerid}"); $seek = mysql_fetch_array($seek); echo "<form method=\"post\" action=\"main.php?cat=game&page=resort_tools&tool=mergers&task=changed&mergerid={$mergerid}\">"; echo "<br /><br /><table border=0 cellspacing=0 cellpadding=0 class='small'>"; echo "<tr class='header'><th colspan=2> Change Requested Name </th></tr>"; echo "<tr class='subheader'><th> Current Requested Name </th><td> New Name </td></tr>"; echo "<tr class='data'><th> {$seek['newname']} </th><td> <input type='text' name='changedname' maxLength='30'></td> </tr>"; echo "<tr class='data'><td colspan='2'><input type=submit value='Change requested name'></td></tr>"; echo "</table>"; echo "</form>"; } if ($task == "changed") { // the queries part for changing the requested name of a tribe //check if someone else already has that name first $changedname = quote_smart(strip_tags(trim($changedname))); $check = mysql_query("SELECT * FROM stats WHERE tribe = {$changedname} AND id != {$mergerid}"); if (mysql_num_rows($check) != 0) { echo "<br /><br />Some tribe is already using that name<br /><br />"; } else { $update = mysql_query("UPDATE mergers SET newname = {$changedname} WHERE id = {$mergerid}"); echo "<br /><br />The Requested tribe name is changed<br /><br />"; $task = "pending"; } } if ($task == "decline") { // loads a form where you can give a reason for not merging a tribe echo "<form method=\"post\" action=\"main.php?cat=game&page=resort_tools&tool=mergers&task=delete&mergerid={$mergerid}\">"; echo "<br /><br /><table border=0 cellspacing=0 cellpadding=0 class='small'>"; echo "<tr class='header'><th colspan=2> Decline Merge </th></tr>"; echo "<tr class='subheader'><th>Decline Reason</th></tr>"; echo "<tr class='data'><td><input type='text' name='declinereason' maxLength='100'></td></tr>"; echo "<tr class='data'><td><input type=submit value='Decline Merge'></td></tr>"; echo "</table>"; echo "</form>"; } if ($task == "delete") { // the queries part for the decline option $seek = mysql_query("SELECT * FROM mergers WHERE id = {$mergerid}"); $seek = mysql_fetch_array($seek); $message1 = "Your merge request to {$seek['target']} has been declined.<br />The reason for this is: {$declinereason} .<br />"; $message2 = "The merge from {$seek['oldname']}(#{$seek['origin']}) has been declined.<br />The reason for this is: {$declinereason} .<br />"; $bleh2 = mysql_query("SELECT id FROM stats WHERE type='elder' AND kingdom='{$seek['target']}'"); $bleh2 = mysql_fetch_array($bleh2); $sendmessage1 = mysql_query("INSERT INTO messages (id, for_user, from_user, date, subject, text, new, action) VALUES ('', '{$seek['tribe']}', '0', '" . $orkTime . "', 'Merge Request Declined', '" . $message1 . "', 'new', 'received')"); $sendmessage2 = mysql_query("INSERT INTO messages (id, for_user, from_user, date, subject, text, new, action) VALUES ('', '{$bleh2['id']}', '0', '" . $orkTime . "', 'Merge Request Declined', '" . $message2 . "', 'new', 'received')"); $update = mysql_query("UPDATE mergers SET request_status = 'declined', declined_reason = '{$declinereason}', mod_id = {$local_stats['id']} WHERE id = {$mergerid}"); $task = "pending"; } if ($task == "accept") { // doing the merge itself $fetch = mysql_query("Select * from mergers where id = {$mergerid}"); $fetch = mysql_fetch_array($fetch); $search = mysql_query("Select * from stats where id = {$fetch['tribe']}"); $search = mysql_fetch_array($search); $newname = "'" . $fetch['newname'] . "'"; //$update = mysql_query("UPDATE goods SET credits = 0, market_money = 0, market_food = 0, market_soldiers = 0, market_wood = 0 WHERE id = {$fetch['tribe']}"); //$update = mysql_query("UPDATE stats set kingdom = {$fetch['target']}, type = 'player', vote = 0, invested = 0, tribe = $newname where id = {$fetch['tribe']}"); //$update = mysql_query("UPDATE rankings_personal set alli_id = {$fetch['target']} where id = {$fetch['tribe']}"); mysql_query("UPDATE stats SET tribe = {$newname} where id = {$fetch['tribe']}"); move_tribe($fetch['tribe'], $fetch['target']); $update = mysql_query("UPDATE mergers set request_status = 'done', merge_time = '{$orkTime}', mod_id = '{$local_stats['id']}' where id = {$fetch['id']}"); $strSQL = mysql_query("INSERT INTO news (id, time, ip, type, duser, ouser, result, text, kingdom_text, kingdoma, kingdomb) VALUES ('', '{$orkTime}', '---', 'Mod Move', '0', '0', '1', '', '<font class = \"positive\">{$search['tribe']}(#{$fetch['origin']}) has been merged into {$newname}(#{$fetch['target']})! </font>', '{$fetch['origin']}', '{$fetch['target']}')"); echo "<br /><br />Merge was done =D<br /><br />"; $task = "pending"; } elseif ($task == "done") { // show list with all done mergers $fetch = mysql_query("SELECT * FROM mergers WHERE request_status = 'done' order by merge_time desc"); $mergers = array(); while ($arrmergers = mysql_fetch_array($fetch, MYSQL_ASSOC)) { $mergers[$arrmergers["id"]] = $arrmergers; } echo "<br /><br /><table border=0 cellspacing=0 cellpadding=0 class='big'>"; echo "<tr class='header'><th colspan='5'> Done Mergers </th></tr>"; echo "<tr class='subheader'><th> Merge Time </td><td> Tribe ID </td><td> Old Location </td><td> New Location </td><td> Staff </td></tr>"; foreach ($mergers as $strKey => $value) { $mod = mysql_query("SELECT name FROM stats WHERE id={$value['mod_id']}"); $mod = mysql_fetch_array($mod); echo "<tr class='data'><th> {$value['merge_time']} </th><td> {$value['tribe']} </td><td> {$value['oldname']}(#{$value['origin']}) </td><td> {$value['newname']}(#{$value['target']}) </td><td> {$mod['name']} </td></tr>"; } echo "</table>"; } elseif ($task == "rejected") { // show list with all rejected mergers and the reason to reject it $fetch = mysql_query("SELECT * FROM mergers WHERE request_status = 'declined' order by merge_time desc"); $mergers = array(); while ($arrmergers = mysql_fetch_array($fetch, MYSQL_ASSOC)) { $mergers[$arrmergers["id"]] = $arrmergers; } echo "<br /><br /><table border=0 cellspacing=0 cellpadding=0 class='big'>"; echo "<tr class='header'><th colspan=5> Declined Mergers </th></tr>"; echo "<tr class='subheader'><th> Merge Time </th><td> Tribe ID </td><td> Location </td><td> Staff </td><td> Reason </td></tr>"; foreach ($mergers as $strKey => $value) { $mod = mysql_query("SELECT name FROM stats WHERE id={$value['mod_id']}"); $mod = mysql_fetch_array($mod); echo "<tr class='data'><th> {$value['merge_time']} </th><td> {$value['tribe']} </td><td> {$value['oldname']}(#{$value['origin']}) </td><td> {$mod['name']} </td><td>{$value['declined_reason']}</td></tr>"; } echo "</table>"; } elseif ($task == "requested") { // show list with all mergers not accepted by the elder yet $fetch = mysql_query("SELECT * FROM mergers WHERE request_status = 'not ready' order by merge_time desc"); $mergers = array(); while ($arrmergers = mysql_fetch_array($fetch, MYSQL_ASSOC)) { $mergers[$arrmergers["id"]] = $arrmergers; } echo "<br /><br /><table border=0 cellspacing=0 cellpadding=0 class='big'>"; echo "<tr class='header'><th colspan=4> Requested Mergers </th></tr>"; echo "<tr class='subheader'><th> Merge Time </th><td> Tribe ID </td><td> Current Location </td><td> Wanted Location </td></tr>"; foreach ($mergers as $strKey => $value) { echo "<tr class='data'><th> {$value['merge_time']} </th><td> {$value['tribe']} </td><td> {$value['oldname']}(#{$value['origin']}) </td><td>{$value['newname']}(#{$value['target']})</td></tr>"; } echo "</table>"; } elseif ($task == "pending") { // show list of all tribes ready to get merged $fetch = mysql_query("SELECT * FROM mergers WHERE request_status = 'ready' order by merge_time desc"); $mergers = array(); while ($arrmergers = mysql_fetch_array($fetch, MYSQL_ASSOC)) { $mergers[$arrmergers["id"]] = $arrmergers; } echo "<br /><br />" . '<table border="0" cellspacing="0" cellpadding="0" class="big">' . '<tr class="header">' . '<th colspan="8">New Mergers</th>' . '</tr>' . '<tr class="subheader">' . '<th> Merge Time </th>' . '<td> Tribe ID </td>' . '<td> Old Location </td>' . '<td> New Location </td>' . '<td class="center"> §1 </td>' . '<td class="center"> Ruler<br />Age </td>' . '<td> War </td>' . '<td> Actions </td>' . '</tr>'; foreach ($mergers as $strKey => $value) { // $age = mysql_query("SELECT land FROM build WHERE id = $value[tribe]"); // $age = mysql_fetch_array($land); // $ltxt = $land['land']; $bExists = TRUE; $strSQL = "SELECT id FROM " . TBL_USER . " WHERE id = {$value['tribe']}"; $resSQL = mysql_query($strSQL); if (mysql_num_rows($resSQL) == 1) { $objTmpUser = new clsUser($value['tribe']); } else { $bExists = FALSE; } // 21 YEARS OLD ==================================================== if ($bExists) { $iHours = $objTmpUser->get_user_info(HOURS); } else { $iHours = 11808; } if (($iYears = ceil(($iHours + 192) / 12)) > 21) { $strTmpYears = '<span class="negative">' . $iYears . '</span>'; } else { $strTmpYears = '<span class="positive">' . $iYears . '</span>'; } // WEEKS JOINED < 6 ================================================ if ($bExists) { $strDate = $objTmpUser->get_gamestat(SIGNUP_TIME); } else { $strDate = '0000-00-00 00:00:00'; } if (ceil((strtotime($strDate) - strtotime('-6 weeks')) / 86400) < 0) { $strTmpSignup = '<span class="negative">Veteran</span>'; } else { $strTmpSignup = '<span class="positive">Novice</span>'; } include_once "inc/functions/war.php"; $seek1['war_target'] = war_target($value['origin']); $seek2['war_target'] = war_target($value['target']); $seek4 = mysql_query("Select count(id) as bleh from stats where kingdom = {$value['target']}"); $seek4 = mysql_fetch_array($seek4); if ($seek1['war_target'] > 0 || $seek2['war_target'] > 0) { $war = '<font class="negative">At War</font>'; } else { $war = '<font class="positive">Ok!</font>'; } if ($seek1['war_target'] > 0 || $seek2['war_target'] > 0 || $seek4['bleh'] >= MAX_ALLIANCE_SIZE) { $accept = "<font class=\"negative\">No Merging *</font>"; $show = true; } else { $accept = "<a href='main.php?cat=game&page=resort_tools&tool=mergers&task=accept&mergerid={$value['id']}'>Accept</a>"; } echo "<tr class='data'>\n <th class='bsdown'> {$value['merge_time']} </th>\n <td class='bsdown'> {$value['tribe']} </td>\n <td class='bsdown'> {$value['oldname']}(#{$value['origin']}) </td>\n <td class='bsdown'> {$value['newname']}(#{$value['target']}) </td>\n <td class='bsdown center'> " . $strTmpSignup . " </td>\n <td class='bsdown center'> " . $strTmpYears . " </td>\n <td class='bsdown'> {$war} </td>\n <td class='bsdown'> <a href='main.php?cat=game&page=resort_tools&tool=mergers&task=changename&mergerid={$value['id']}'>Change Name</a><br />\n {$accept}<br />\n <a href='main.php?cat=game&page=resort_tools&tool=mergers&task=decline&mergerid={$value['id']}'>Decline</a>\n </td>\n </tr>"; } echo "</table>"; if (isset($show)) { echo "* = The no merging means that his alliance or the alliance he want to go to is at war, or that the alliance he want to merge to is already at " . MAX_ALLIANCE_SIZE . " tribes.<br />"; } } }