Beispiel #1
0
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')");
    }

}
Beispiel #2
0
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}')");
    }
}
Beispiel #3
0
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&amp;task=accept&amp;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 />";
        }
    }
}