private function setImageLinks() { // Load the API for the user. $api = new api($this->ID); // Set/Get the image. if ($api->valid()) { $this->smallPicUrl = "<img src=\"https://image.eveonline.com/Character/" . $api->getCharacterID() . "_64.jpg\">"; $this->largePicUrl = "<img src=\"https://image.eveonline.com/Character/" . $api->getCharacterID() . "_256.jpg\">"; } }
public function __construct() { // Construct a different html for ingame and the out-of-game browser. global $IGB; global $VERSION; global $MySelf; global $TIDY_ENABLE; global $width; global $URL; global $IGB_VISUAL; // Enable tidy, if we want to. $this->useTidy = $TIDY_ENABLE; // In case we are not logged in, or the object does not exist yet. if (!is_object($MySelf)) { $MySelf = new user(false, false); } if ($IGB && $IGB_VISUAL) { // Use IGB, set header and footer. $this->isIGB = true; // $this->header = file_get_contents('./include/ingame/igb-header.txt'); $this->header = file_get_contents('./include/ingame/igb-header.php'); if ($MySelf->isValid()) { $this->header .= makeMenu(); $this->header = str_replace("%%RANK%%", $MySelf->getRankName(), $this->header); $this->header = str_replace("%%CREDITS%%", number_format(getCredits($MySelf->getID()), 2) . " ISK", $this->header); $this->header = str_replace("%%USERNAME%%", ucfirst($MySelf->getUsername()), $this->header); } $this->header = str_replace("%%SITENAME%%", getConfig("sitename"), $this->header); // $this->footer = file_get_contents('./include/ingame/igb-footer.txt'); $this->footer = file_get_contents('./include/ingame/igb-footer.php'); $this->footer = str_replace("%%VERSION%%", $VERSION, $this->footer); } else { // Use normal browser. $this->isIGB = false; if ($MySelf->isValid() == 1) { // $this->header = file_get_contents('./include/html/header.txt'); $this->header = file_get_contents('./include/html/header.php'); } else { // $this->header = file_get_contents('./include/html/header-notloggedin.txt'); $this->header = file_get_contents('./include/html/header-notloggedin.php'); } // $this->footer = file_get_contents('./include/html/footer.txt'); $domainroot = $_SERVER['HTTP_HOST']; // Add page footer // use proper footer for sponcered sites. if ($domainroot == "miningbuddy.us" or $domainroot == "miningbuddy.de" or $domainroot == "miningbuddy.net") { $this->footer = file_get_contents('./include/html/mbh-footer.php'); } else { $this->footer = file_get_contents('./include/html/footer.php'); } // Generate the images. $mainLogo = new graphic("title"); $mainLogo->setText(getConfig("sitename")); $mainLogo->setBGColor("2D2D37"); // this is here to retain some code. Image caching seemed to be pretty useless. $imageCaching = false; if ($imageCaching) { $loginLogo = new graphic("standard"); $loginLogo->setText(ucfirst($MySelf->getUsername())); $loginLogo->setBGColor("2D2D37"); $loginLogo->setPrefixed(false); $versionLogo = new graphic("long"); $versionLogo->setText($VERSION); $versionLogo->setBGColor("2D2D37"); $versionLogo->setPrefixed(false); $rankLogo = new graphic("standard"); $rankLogo->setText($MySelf->getRankName()); $rankLogo->setBGColor("2D2D37"); $rankLogo->setPrefixed(false); $moneyLogo = new graphic("standard"); $moneyLogo->setText(number_format(getCredits($MySelf->getID()), 2) . " ISK"); $moneyLogo->setDirect(true); $moneyLogo->setBGColor("2D2D37"); $moneyLogo->setPrefixed(false); } // Replace variables in the header. $this->header = str_replace("%%SITENAME%%", getConfig("sitename") . " - " . $VERSION, $this->header); $this->header = makeMenu($this->header); $thisCharacterID = ""; if ($MySelf->isValid()) { $api = new api($MySelf->getID()); $thisCharacterID = $api->getCharacterID(); } if ($thisCharacterID == "") { $this->header = str_replace("%%PILOT64%%", "", $this->header); } else { $this->header = str_replace("%%PILOT64%%", "<img width='64' height='64' align='left' src='https://image.eveonline.com/Character/" . $api->getCharacterID() . "_64.jpg' />", $this->header); } $this->header = str_replace("%%LOGO%%", $mainLogo->render(), $this->header); if ($imageCaching) { $this->header = str_replace("%%LOGGEDIN%%", $loginLogo->render(), $this->header); // $this->header = str_replace("%%RANK%%", $rankLogo->render(), $this->header); $this->header = str_replace("%%CREDITS%%", $moneyLogo->render(), $this->header); $this->footer = str_replace("%%IMG%%", $versionLogo->render(), $this->footer); } else { $this->header = str_replace("%%LOGGEDIN%%", " " . ucfirst($MySelf->getUsername()), $this->header); $this->header = str_replace("%%RANK%%", " " . $MySelf->getRankName(), $this->header); $this->header = str_replace("%%CREDITS%%", " " . number_format(getCredits($MySelf->getID()), 2) . " ISK", $this->header); $this->footer = str_replace("%%IMG%%", $VERSION, $this->footer); } $this->header = str_replace("%%USERNAME%%", ucfirst($MySelf->getUsername()), $this->header); $this->header = str_replace("%%URL%%", $URL, $this->header); } $this->header = str_replace("%%VERSION%%", $VERSION, $this->header); $this->header .= "<!--header ends here-->"; $this->footer = "<!--footer starts here-->" . $this->footer; }
function profile() { // The usual suspects. global $MySelf; global $DB; // Set the ID. $ID = sanitize($_GET[id]); numericCheck($_GET[id], 0); // Load the profile. $profile = new profile($ID); $username = ucfirst(idToUsername($ID)); // Cache our permissions. $canSeeUsers = $MySelf->canSeeUsers(); // Need the api. $api = new api($ID); // Create table header. $table = new table(2, true); $table->addHeader(">> About " . $username); $table->addRow(); $table->addCol("Current rank:"); $table->addCol(getRank($ID)); $table->addRow(); $table->addCol("Last login:"******"SELECT lastlogin FROM users WHERE id='" . $ID . "' AND deleted='0' LIMIT 1"); $table->addCol(date("d.m.y. H:i:s", $lastLog[0])); $table->addRow(); $table->addCol("Total logins:"); $lastLog = $DB->getCol("SELECT COUNT(authkey) FROM auth WHERE user='******' LIMIT 1"); $table->addCol(number_format($lastLog[0], 0)); $table->addRow(); $table->addCol("Valid api-key on file:"); $table->addCol(yesno($api->valid(), true)); $table->addRow(); $table->addCol("Is available for mining:"); if ($profile->isOwn()) { if ($profile->MinerFlag()) { $temp = " [<a href=\"index.php?action=modprofile&id=" . $ID . "&mining=false\">set not available</a>]"; } else { $temp = " [<a href=\"index.php?action=modprofile&id=" . $ID . "&mining=true\">set available</a>]"; } } $table->addCol(yesno($profile->MinerFlag(), true) . $temp); $table->addRow(); $table->addCol("Is available for hauling:"); if ($profile->isOwn()) { if ($profile->HaulerFlag()) { $temp = " [<a href=\"index.php?action=modprofile&id=" . $ID . "&hauling=false\">set not available</a>]"; } else { $temp = " [<a href=\"index.php?action=modprofile&id=" . $ID . "&hauling=true\">set available</a>]"; } } $table->addCol(yesno($profile->HaulerFlag(), true) . $temp); $table->addRow(); $table->addCol("Is available for fighting:"); if ($profile->isOwn()) { if ($profile->FighterFlag()) { $temp = " [<a href=\"index.php?action=modprofile&id=" . $ID . "&fighting=false\">set not available</a>]"; } else { $temp = " [<a href=\"index.php?action=modprofile&id=" . $ID . "&fighting=true\">set available</a>]"; } } $table->addCol(yesno($profile->FighterFlag(), true) . $temp); if ($profile->emailVisible() || $profile->isOwn()) { if ($profile->isOwn()) { if ($profile->emailVisible()) { $temp = " (public) [<a href=\"index.php?action=modprofile&id=" . $ID . "&email=hide\">hide from public</a>]"; } else { $temp = " (hidden) [<a href=\"index.php?action=modprofile&id=" . $ID . "&email=show\">make public</a>]"; } } $table->addRow(); $table->addCol("Email address:"); $email = $DB->getCol("SELECT email FROM users WHERE id='" . $ID . "' LIMIT 1"); $table->addCol($email[0] . $temp); } // Statistics. $stats = new table(2, true); $stats->addHeader(">> Statistical breakdown"); $miningRunsJoined = $DB->getCol("SELECT COUNT(id) FROM joinups WHERE userid='" . $ID . "'"); $miningRunsJoined = $miningRunsJoined[0]; $OpjoinUps = $DB->getCol("SELECT COUNT(id) FROM joinups WHERE userid='" . $ID . "'"); $OpjoinUps = $OpjoinUps[0]; $joinUps = $DB->getCol("SELECT COUNT(id) FROM (SELECT * from joinups WHERE userid='" . $ID . "' GROUP BY run) as uJoinups"); $joinUps = $joinUps[0]; $haulingRuns = $DB->getCol("SELECT COUNT(id) FROM hauled WHERE hauler='" . $ID . "'"); $haulingRuns = $haulingRuns[0]; $timeMining = $DB->getCol("SELECT SUM(parted - joined) FROM joinups WHERE userid='" . $ID . "' AND parted >1"); $timeMining = $timeMining[0]; $timesKicked = $DB->getCol("SELECT COUNT(id) FROM joinups WHERE userid='" . $ID . "' AND status='1'"); $timesKicked = $timesKicked[0]; $timesRemoved = $DB->getCol("SELECT COUNT(id) FROM joinups WHERE userid='" . $ID . "' AND status='2'"); $timesRemoved = $timesRemoved[0]; $timesBanned = $DB->getCol("SELECT COUNT(id) FROM joinups WHERE userid='" . $ID . "' AND status='3'"); $timesBanned = $timesBanned[0]; $timesCharity = $DB->getCol("SELECT COUNT(id) FROM (SELECT * from joinups WHERE userid='" . $ID . "' GROUP BY run) as uJoinups WHERE userid='" . $ID . "' AND charity='1'"); $timesCharity = $timesCharity[0]; $tmec = $DB->getCol("SELECT AVG(tmec) FROM runs WHERE isOfficial = 1"); $tmecJoined = $DB->getCol("SELECT AVG(runs.tmec) FROM joinups, runs WHERE joinups.userid='" . $ID . "' AND joinups.run = runs.id AND runs.endtime > 0 AND runs.isOfficial = 1"); $tmecNotJoined = $DB->getCol("SELECT AVG(runs.tmec) FROM joinups, runs WHERE joinups.userid='" . $ID . "' AND joinups.run <> runs.id AND runs.endtime > 0 AND runs.isOfficial = 1"); $tmecDiff = $tmecJoined[0] - $tmecNotJoined[0]; $stats->addRow(); $stats->addCol("Mining operations joined:"); if ($miningRunsJoined > 0) { $stats->addCol(number_format($joinUps, 0)); } else { $stats->addCol("never joined."); } $stats->addRow(); $stats->addCol("Total operations joinups:"); if ($OpjoinUps > 0) { $stats->addCol(number_format($OpjoinUps, 0)); } else { $stats->addCol("never joined."); } $stats->addRow(); $stats->addCol("Hauling runs:"); if ($haulingRuns > 0) { $stats->addCol(number_format($haulingRuns, 0)); } else { $stats->addCol("never hauled."); } $stats->addRow(); $stats->addCol("Time spent mining:"); if ($timeMining > 0) { $stats->addCol(numberToString($timeMining)); } else { $stats->addCol("never mined."); } $stats->addRow(); $stats->addCol("Average TMEC:"); $stats->addCol(number_format($tmec[0], 3)); $stats->addRow(); $stats->addCol("Average TMEC on Ops <b>with</b> " . $username . ":"); $stats->addCol(number_format($tmecJoined[0], 3)); $stats->addRow(); $stats->addCol("Average TMEC on Ops <b>without</b> " . $username . ":"); $stats->addCol(number_format($tmecNotJoined[0], 3)); $stats->addRow(); $stats->addCol("TMEC difference:"); if ($tmecDiff >= 0) { $stats->addCol("<font color=\"#00ff00\">" . number_format($tmecDiff, 3), true . "</font>"); } else { $stats->addCol("<font color=\"#ff0000\">" . number_format($tmecDiff, 3), true . "</font>"); } $stats->addRow(); $stats->addCol("Times removed from OP:"); $stats->addCol(number_format($timesRemoved, 0)); $stats->addRow(); $stats->addCol("Times kicked from OP:"); $stats->addCol(number_format($timesKicked, 0)); $stats->addRow(); $stats->addCol("Times banned from OP:"); $stats->addCol(number_format($timesBanned, 0)); $stats->addRow(); $stats->addCol("Times declared charity:"); $stats->addCol(number_format($timesCharity, 0)); /* * Assemble the heavy-duty SQL query. * It is dynamic because this way we can easily add ores from * config-system.php to the system without code rewrite. */ /* global $DBORE; global $ORENAMES; foreach ($DBORE as $ORE) { $new = $ORE; if ($last) { $SQLADD .= "SUM(" . $last . ") AS total" . $last . ", "; } $last = $new; } $SQLADD .= "SUM(" . $last . ") AS total" . $last . " "; $SQL = "SELECT " . $SQLADD . " FROM hauled WHERE hauler='" . $ID . "'"; // Now query it. $totalOREDB = $DB->query("$SQL"); if (DB::isError($totalOREDB)) { * * This is not what you would really want to do in * your program. It merely demonstrates what kinds * of data you can get back from error objects. * echo 'Standard Message: ' . $totalOREDB->getMessage() . "\n"; echo '\n '; echo 'Standard Code: ' . $totalOREDB->getCode() . "\n"; echo '\n '; echo 'DBMS/User Message: ' . $totalOREDB->getUserInfo() . "\n"; echo '\n '; echo 'DBMS/Debug Message: ' . $totalOREDB->getDebugInfo() . "\n"; echo '\n '; exit; } // Create table. $totalOre_table = new table(2, true); $totalOre_table->addHeader(">> Total ore hauled"); // Loop through the result (single result!) if ($totalOREDB->numRows() > 0) { while ($totalORE = $totalOREDB->fetchRow()) { // Now check each ore type. foreach ($ORENAMES as $ORE) { // And ignore never-hauled ore if ($totalORE[total . $ORE] > 0) { // We got some ore! $totalOre_table->addRow(); $totalOre_table->addCol("<img width=\"20\" height=\"20\" src=\"./images/ores/" . $ORE . ".png\">Total " . $ORE . " hauled:"); $totalOre_table->addCol(number_format($totalORE[total . $ORE])); $gotOre = true; } } } if ($gotOre) { $oretable_r = "<br>" . $totalOre_table->flush(); } } */ // Image thingy. // We serve small images IGB. global $IGB; global $IGB_VISUAL; if ($IGB && $IGB_VISUAL) { $image = "<img src=\"portrait:" . $api->getCharacterID() . "\" SIZE=\"128\">"; } else { $image = $profile->getImage("large"); } $picTable = new table(true, 1); $picTable->addHeader(">> Picture of " . $username); $picTable->addRow(); $picTable->addCol($image); $imageTable = $picTable->flush(); // About if ($profile->GetAbout() && !$profile->isOwn()) { $aboutTable = new table(1, true); $aboutTable->addHeader(">> " . $username . " says..."); $aboutTable->addRow(); $aboutTable->addCol(nl2br($profile->GetAbout())); $aboutTable = "<br>" . $aboutTable->flush(); } if ($profile->isOwn()) { $aboutTable = new table(1, true); $aboutTable->addHeader(">> Enter a public viewable text here"); $aboutTable->addRow(); $form = "<form action=\"index.php\" method=\"POST\">"; $form .= "<input type=\"hidden\" name=\"check\" value=\"true\">"; $form .= "<input type=\"hidden\" name=\"action\" value=\"modprofile\">"; $form .= "<input type=\"hidden\" name=\"id\" value=\"" . $ID . "\">"; $aboutTable->addCol("<textarea rows=\"18\" cols=\"80\" name=\"about\">" . $profile->GetAbout() . "</textarea>"); $aboutTable->addHeaderCentered("<input type=\"submit\" name=\"submit\" value=\"Update about\">"); $aboutTable = "<br>" . $form . $aboutTable->flush() . "</form>"; } // quick "jump to" -thingy. $peeps = $DB->query("SELECT DISTINCT username,id FROM users WHERE deleted = 0 AND canLogin = 1 ORDER BY username ASC"); if ($peeps->numRows() > 0) { while ($p = $peeps->fetchRow()) { if ($ID == $p[id]) { $pdm .= "<option SELECTED value=\"" . $p[id] . "\">" . ucfirst($p[username]) . " (current)</option>"; } else { $pdm .= "<option value=\"" . $p[id] . "\">" . ucfirst($p[username]) . "</option>"; } } $pdm = "<select name=\"id\">" . $pdm . "</select></form>"; $quickChooser = new table(1, true); $quickChooser->addHeader(">> Quick jump to profile"); $quickChooser->addRow(); $quickChooser->addCol($pdm); $quickChooser->addHeaderCentered("<input type=\"submit\" name=\"submit\" value=\"Switch\">"); $quickChooser = "<form action=\"index.php\" method=\"GET\"><input type=\"hidden\" name=\"action\" value=\"profile\">" . $quickChooser->flush() . "</form>"; } $page = "<h2>View profile</h2>" . $quickChooser . $imageTable . "<br>" . $table->flush() . "<br>" . $stats->flush() . $oretable_r . $aboutTable; return $page; }
function listUser() { global $DB; global $MySelf; global $IGB; global $TIMEMARK; global $IGB_VISUAL; // Are we allowed to peek into peoples files? if (!$MySelf->canSeeUsers()) { makeNotice("You are not allowed to do this!", "error", "forbidden"); } // Is the supplied ID truly numeric? if (!is_numeric($_GET[id])) { makeNotice("Why would you do such a thing? Are you evil at heart? Lets assume its a \"mistake\" for now..", "warning", "*cough*", "index.php?action=editusers", "I'm sorry..."); } else { $id = (int) $_GET[id]; } // Query the database. $users = $DB->query("select * from users where id='{$id}' AND deleted='0' limit 1"); // Build the tables. while ($row = $users->fetchRow()) { $table = new table(2, true); $table->addHeader(">> Managing user " . ucfirst($row[username])); $username = ucfirst($row[username]); $table->addRow(); $table->addCol("ID:"); $table->addCol(str_pad("{$row['id']}", 5, "0", STR_RIGHT_PAD)); $table->addRow(); $table->addCol("Username:"******"<input type=\"text\" name=\"username\" value=\"" . $uname_temp . "\">"; $confi_temp = "<input type=\"checkbox\" name=\"username_check\" value=\"true\">"; $table->addCol($field_temp . " (changing username tick here also: " . $confi_temp . ")"); } else { $table->addCol(ucfirst($row[username])); } $table->addRow(); $table->addCol("eMail:"); $table->addCol("<input type=\"text\" size=\"40\" name=\"email\" value=\"" . ($row[email] == "" ? 'no email supplied' : $row[email]) . "\">"); $table->addRow(); $table->addCol("Password:"******"<input type=\"password\" size=\"40\" name=\"password\">"); // Ranks System $RanksDS = $DB->query("SELECT * FROM ranks ORDER BY rankOrder ASC"); $rankCount = $RanksDS->numRows(); if ($rankCount >= 1) { // We have at least 1 rank. while ($rank = $RanksDS->fetchRow()) { if ($rank[rankid] == $row[rank]) { // The current rank is selected. $rank_pdm .= "<option SELECTED value=\"{$rank['rankid']}\">{$rank['name']}</option>"; } else { // The others of course, are not. $rank_pdm .= "<option value=\"{$rank['rankid']}\">{$rank['name']}</option>"; } } $rankColumn = "<select name=\"rank\">" . $rank_pdm . "</select>"; } else { // No rank has been set yet. $rankColumn = "There are no ranks. Go create some!"; } $table->addRow(); $table->addCol("Rank:"); $table->addCol($rankColumn); $table->addRow(); $table->addCol("Last login:"******"{$row['lastlogin']}" < 10) { $table->addCol("never"); } else { $table->addCol(date("d.m.y H:i:s", $row[lastlogin])); } $table->addRow(); $table->addCol("Credits:"); $table->addCol(number_format(getCredits($row[id]), 2) . " ISK"); // Is the account confirmed? if ("{$row['confirmed']}" == "0") { $table->addRow(); $table->addCol("Account confirmed:"); $table->addCol("This account has <b>not</b> been confirmed yet."); $table->addRow(); $table->addCol("Confirm account:"); $table->addCol("<input type=\"checkbox\" name=\"confirm\" value=\"true\"> Tick box to confirm account. <br><br>This is a one-way action only. Once an account" . " has been confirmed you can not unconfirm it. Tho you can block or delete it." . " Be careful not to confirm an account by accident - you could allow a non-authorized third party to access your MiningBuddy!"); $table->addRow(); $table->addCol("Account confirmed:"); // Give a red light if user has not even verified himself. if ("{$row['emailvalid']}" == "0") { $table->addCol("<b>WARNING!</b><br> The User has not yet verified this email yet! If you choose to enable" . " this account at this time, be very sure that you know the person requesting the account!", array("bgcolor" => "#662222")); } else { $table->addCol("<br><br><b>The user validated the email address.</b><br>"); } } else { $table->addRow(); $table->addCol("This account has been confirmed."); if ("{$row['emailvalid']}" == "0") { $table->addCol("<font color=\"#ff0000\">WARNING!</b></font><br> The User has not verified this email but the account has been confirmed!"); // Add a "confirm email" checkbox. $table->addRow(); $table->addCol("Mark users email as valid:"); $table->addCol("<input type=\"checkbox\" name=\"SetEmailValid\" value=\"true\">"); } else { $table->addCol("The user validated the supplied email address."); } } /* * API Goodness */ $api = new api($row[id], true); $apit = new table(2, true); $apit->addHeader(">> Api information for " . ucfirst($row[username])); $apit->addRow(); $apit->addCol("API Key in database:"); if ($api->getApiID() && $api->getApiKey()) { $apit->addCol(yesno(1, true)); $apit->addRow(); $apit->addCol("API valid:"); $apit->addCol(yesno($api->valid(), true)); if ($api->valid()) { $apit->addRow(); $apit->addCol("Character ID:"); $apit->addCol($api->getCharacterID()); $apit->addRow(); $apit->addCol("Validated on:"); $apit->addCol(date("d.m.Y H:i:s", $api->validatedOn())); } $apit->addRow(); $apit->addCol("Remove API key from database:"); $apit->addCol("[<a href=\"index.php?action=delapi&id={$id}\">delete api key</a>]"); } else { $apit->addCol(yesno(0)); } // Permissions matrix $perms = array("canLogin" => "log in", "canJoinRun" => "join mining Ops", "canCreateRun" => "create new mining Ops", "canCloseRun" => "close mining Ops", "canDeleteRun" => "delete mining Ops", "canAddHaul" => "haul from/to mining Ops", "canSeeEvents" => "view scheduled events", "canDeleteEvents" => "can delete events", "canEditEvents" => "add and delete scheduled events", "canChangePwd" => "change his own password", "canChangeEmail" => "change his own email", "canChangeOre" => "manage ore prices and enable/disable them.", "canAddUser" => "add new accounts", "canSeeUsers" => "see other accounts", "canDeleteUser" => "delete other accounts.", "canEditRank" => "edit other peoples ranks.", "canManageUser" => "grant and take permissions.", "isOfficial" => "create official mining runs (with payout).", "isAdmin" => "edit site settings.", "isLottoOfficial" => "administrate the lottery", "canPlayLotto" => "play Lotto!", "isAccountant" => "edit other users credits.", "optIn" => "User has opt-in to eMails."); // Create a seperate permissions table. $perm_table = new table(2, true); $perm_table->addHeader(">> " . ucfirst($row[username]) . " has permission to... "); $perm_keys = array_keys($perms); $LoR = 1; foreach ($perm_keys as $key) { if ($LoR) { $perm_table->addRow(); } if ($row[$key]) { $perm_table->addCol("<input type=\"checkbox\" name=\"{$key}\" checked> " . $perms[$key]); } else { $perm_table->addCol("<input type=\"checkbox\" name=\"{$key}\"> " . $perms[$key]); } $LoR = 1 - $LoR; } if (!$LoR) { $perm_table->addCol(); } // Delete User $perm_table->addRow(); $perm_table->addCol("<hr>", array("colspan" => 2)); $perm_table->addRow(); $perm_table->addCol("Delete user:"******"<input type=\"checkbox\" name=\"delete\" value=\"true\"> Tick box to delete the user permanently."); $perm_table->addRow(); $perm_table->addCol("<hr>", array("colspan" => 2)); // Commit changes button. $perm_table->addHeaderCentered("<input type=\"submit\" name=\"send\" value=\"Commit changes\">", array("colspan" => 2, "align" => "center")); } $form .= "<form action=\"index.php\" method=\"POST\">"; $form .= "<input type=\"hidden\" name=\"id\" value=\"" . $_GET[id] . "\">"; $form .= "<input type=\"hidden\" name=\"check\" value=\"true\">"; $form .= "<input type=\"hidden\" name=\"action\" value=\"edituser\">"; // Show all logins. $logins = getLogins($id); // Show failed logins. $failed_logins = showFailedLogins("15", idToUsername($id)); /* * Transactions. */ if ($MySelf->isAccountant()) { $acc = new table(2, true); $acc->addHeader(">> Create transaction to user " . ucfirst(idToUsername($id))); $acc->addRow(); $acc->addCol("Credit to:"); $acc->addCol($username); $acc->addRow(); $acc->addCol("Authorization by:"); $acc->addCol(ucfirst($MySelf->getUsername())); $acc->addRow(); $acc->addCol("Time of Transaction:"); $acc->addCol(date("r", $TIMEMARK)); $acc->addRow(); $acc->addCol("Withdrawal or deposit:"); $pdm = "<select name=\"wod\">"; $pdm .= "<option value=\"0\">Deposit (give money)</option>"; $pdm .= "<option SELECTED value=\"1\">Withdrawal (take money)</option>"; $pdm .= "</select>"; $acc->addCol($pdm); $acc->addRow(); $acc->addCol("Amount:"); $acc->addCol("<input size=\"8\" type=\"text\" name=\"amount\"> ISK"); $acc->addRow(); $acc->addCol("Reason:"); $pdm = "<select name=\"reason1\">"; $pdm .= "<option>requested payout</option>"; $pdm .= "<option SELECTED>normal payout</option>"; $pdm .= "<option>payout of loan</option>"; $pdm .= "<option>manual deposit</option>"; $pdm .= "<option>cash recived</option>"; $pdm .= "</select>"; $acc->addCol($pdm . " -or- <input type=\"text\" name=\"reason2\">"); $acc->addHeaderCentered("<input type=\"submit\" name=\"submit\" value=\"Authorize transaction\">"); $transBox = "<form action=\"index.php\" method=\"POST\">"; $transBox .= $acc->flush(); $transBox .= "<input type=\"hidden\" name=\"id\" value=\"" . $_GET[id] . "\">"; $transBox .= "<input type=\"hidden\" name=\"check\" value=\"true\">"; $transBox .= "<input type=\"hidden\" name=\"action\" value=\"transaction\">"; $transBox .= "</form>"; } $page = "<h2>Managing user details</h2>" . $form . $table->flush() . "<br>" . $apit->flush() . "<br>" . $perm_table->flush() . "</form>" . $transBox; $transactions = getTransactions($id); if ($transactions) { $page .= $transactions; } // Add login table if we have more than 0 logins. if ($logins) { if ($transactions) { $page .= "<br>"; } $page .= $logins; } $page .= $failed_logins; // Return the page. return $page; }
function payout() { // Some globals needed. global $DB; global $TIMEMARK; global $MySelf; global $IGB; global $IGB_VISUAL; // Are we allowed to do this? if (!$MySelf->isAccountant()) { makeNotice("You are not an accountant to your corporation. Access denied.", "error", "Access denied"); } /* * Amount of ISK owned. */ $iskOwned = new table(2, true); $iskOwned->addHeader(">> Outstanding ISK"); // Load all unique members from the database. $uniqeMembers = $DB->query("SELECT DISTINCT id FROM users WHERE deleted='0' ORDER BY username ASC"); // Create a row for each member. while ($id = $uniqeMembers->fetchRow()) { $playerCreds = getCredits($id['id']); // We need this later on... $allPeeps[$id['id']] = ucfirst(idToUsername($id['id'])); // if the member has more or less than zero isk, list him. if ($playerCreds != 0) { $iskOwned->addRow(); $iskOwned->addCol("<a href=\"index.php?action=showTransactions&id=" . $id['id'] . "\">" . $allPeeps[$id['id']] . "</a>"); $iskOwned->addCol(number_format($playerCreds, 2) . " ISK"); } } // Show the total isk owned. $outstanding = totalIskOwned(); $iskOwned->addRow("#060622"); $iskOwned->addCol(">> Total Outstanding ISK:"); $iskOwned->addCol(totalIskOwned() . " ISK"); /* * Show a drop down menu to create a menu to see everyones transaction log. */ $freeSelect = new table(2, true); $freeSelect->addHeader(">> Lookup specific transaction log"); // Create a PDM for all the peoples. foreach ($allPeeps as $peep) { $pdm .= "<option value=\"" . array_search($peep, $allPeeps) . "\">{$peep}</option>"; } $freeSelect->addRow(); $freeSelect->addCol("Show log of ", array("align" => "right")); $freeSelect->addCol("<select name=\"id\">{$pdm}</select>"); $freeSelect->addHeaderCentered("<input type=\"submit\" name=\"submit\" value=\"Lookup log in Database\">"); unset($pdm); /* * Show current requests */ $requests = $DB->query("SELECT * FROM payoutRequests WHERE payoutTime IS NULL ORDER BY time DESC"); if ($IGB && $IGB_VISUAL) { $table = new table(6, true); } else { $table = new table(5, true); } $table->addHeader(">> Pending payout requests"); $table->addRow("#060622"); $table->addCol("request"); $table->addCol("applicant"); if ($IGB && $IGB_VISUAL) { $table->addCol("right click menu"); } $table->addCol("time"); $table->addCol("amount"); $table->addCol("Payout"); while ($request = $requests->fetchRow()) { if ($IGB && $IGB_VISUAL) { $api = new api($request['applicant']); // $profile = new profile($request['applicant']); if ($api->valid() && ($IGB && $IGB_VISUAL)) { $rcm = " [<a href=\"showinfo:1378//" . $api->getCharacterID() . "\">RCM</a>]"; } } $table->addRow(); $table->addCol("#" . str_pad($request['request'], "5", "0", STR_PAD_LEFT)); $table->addCol("<a href=\"index.php?action=showTransactions&id={$request['applicant']}\">" . ucfirst(idToUsername($request['applicant'])) . "</a>"); if ($IGB && $IGB_VISUAL) { $table->addCol($rcm); } $table->addCol(date("d.m.y H:i:s", $request['time'])); if (getCredits($request['applicant']) < $request['amount']) { $class .= "red"; } if ($IGB && $IGB_VISUAL) { $table->addCol("<input type=\"text\" class=\"{$class}\" name=\"dumb\" readonly value=\"" . number_format($request['amount'], 2) . "\"> ISK"); } else { $table->addCol(number_format($request['amount'], 2) . " ISK", array("class" => $class)); } // Can the user still cover his request with cash? $table->addCol("<input type=\"checkbox\" name=\"" . $request['request'] . "\" value=\"true\">"); $haveRequest = true; //} else { // $table->addCol("<i>not enough ISK</i>"); //} } $table->addHeaderCentered("<input type=\"submit\" name=\"submit\" value=\"Mark as paid\">"); $funnyForm = "<form action=\"index.php\" method=\"POST\">"; $funnyForm .= "<input type=\"hidden\" name=\"check\" value=\"true\">"; $funnyForm .= "<input type=\"hidden\" name=\"action\" value=\"payout\">"; $funnyForm .= $table->flush(); $funnyForm .= "</form>"; /* * Show fulfilled requests */ if (is_numeric($_GET['page']) && $_GET['page'] > 0) { $page = "LIMIT " . $_GET['page'] * 20 . ", 20"; } elseif ($_GET['page'] == "all") { $page = ""; } else { $page = "LIMIT 20"; } $requests = $DB->query("SELECT * FROM payoutRequests WHERE payoutTime IS NOT NULL ORDER BY time DESC {$page}"); $table_done = new table(6, true); $table_done->addHeader(">> Fulfilled payout requests"); $table_done->addRow("#060622"); $table_done->addCol("request"); $table_done->addCol("applicant"); $table_done->addCol("time"); $table_done->addCol("amount"); $table_done->addCol("Payout time"); $table_done->addCol("Authorized by"); while ($request = $requests->fetchRow()) { $table_done->addRow(); $table_done->addCol("#" . str_pad($request['request'], "5", "0", STR_PAD_LEFT)); $table_done->addCol("<a href=\"index.php?action=showTransactions&id={$request['applicant']}\">" . ucfirst(idToUsername($request['applicant'])) . "</a>"); $table_done->addCol(date("d.m.y H:i:s", $request['time'])); $table_done->addCol(number_format($request['amount'], 2) . " ISK"); $table_done->addCol(date("d.m.y H:i:s", $request['payoutTime'])); $table_done->addCol(ucfirst(idToUsername($request['banker']))); $haveOldRequests = true; } // The "show this many payouts"-part. $count = $DB->getCol("SELECT COUNT(request) FROM payoutRequests WHERE payoutTime IS NOT NULL"); $countSteps = floor($count[0] / 20); $showMore = "Switch to page >> "; for ($i = 1; $i <= $countSteps; $i++) { $thisStep = str_pad($i, 2, "0", STR_PAD_LEFT); $showMore .= "[<a href=\"index.php?action=payout&page=" . $thisStep . "\">" . $thisStep . "</a>] "; } $showMore .= "[<a href=\"index.php?action=payout&page=all\">All</a>] "; $table_done->addHeader($showMore); $html = "<h2>Manage Payouts</h2>" . $iskOwned->flush() . "<br><br>"; $html .= "<form action=\"index.php\" method=\"GET\">" . $freeSelect->flush() . "<input type=\"hidden\" name=\"action\" value=\"showTransactions\"></form><br>"; if ($haveRequest) { $html .= $funnyForm . "<br>"; } else { $html .= "<i>No open requests.</i><br><br>"; } if ($haveOldRequests) { $html .= $table_done->flush(); } else { $html .= "<br><i>No payouts at all.</i>"; } return $html; }
function makePreferences() { // I kid you not. All needed. global $PREFS; global $VERSION; global $SITENAME; global $TIMEMARK; global $DB; global $MySelf; /* * Cantimer Settings */ $cantimer_table = new table(2, true); $cantimer_table->addHeader(">> Preferences for Cantimer"); // Can see my own cans. $cantimer_table->addRow(); if ($PREFS->getPref("CanMyCans")) { $cantimer_table->addCol("<input type=\"checkbox\" CHECKED name=\"CanMyCans\" value=\"true\">"); } else { $cantimer_table->addCol("<input type=\"checkbox\" name=\"CanMyCans\" value=\"true\">"); } $cantimer_table->addCol("Tick box to see your own cans."); // Can see the add cans form. $cantimer_table->addRow(); if ($PREFS->getPref("CanAddCans")) { $cantimer_table->addCol("<input type=\"checkbox\" CHECKED name=\"CanAddCans\" value=\"true\">"); } else { $cantimer_table->addCol("<input type=\"checkbox\" name=\"CanAddCans\" value=\"true\">"); } $cantimer_table->addCol("Tick the add can form."); // Can See cans beloning to same run. $cantimer_table->addRow(); if ($PREFS->getPref("CanRunCans")) { $cantimer_table->addCol("<input type=\"checkbox\" CHECKED name=\"CanRunCans\" value=\"true\">"); } else { $cantimer_table->addCol("<input type=\"checkbox\" name=\"CanRunCans\" value=\"true\">"); } $cantimer_table->addCol("Tick to see cans beloning to your MiningOp."); // Can see all cans. $cantimer_table->addRow(); if ($PREFS->getPref("CanAllCans")) { $cantimer_table->addCol("<input type=\"checkbox\" CHECKED name=\"CanAllCans\" value=\"true\">"); } else { $cantimer_table->addCol("<input type=\"checkbox\" name=\"CanAllCans\" value=\"true\">"); } $cantimer_table->addCol("Tick if you want to see all cans."); $cantimer_table->addHeaderCentered("<input type=\"submit\" name=\"submit\" value=\"Update Can Timer settings\">"); /* * Opt In/Out of emails Setting */ $opt_table = new table(2, true); $opt_table->addHeader(">> Your eMail settings"); $opt_table->addRow(); if ($MySelf->optInState()) { $opt_table->addCol("<input type=\"checkbox\" CHECKED name=\"optIn\" value=\"true\">"); } else { $opt_table->addCol("<input type=\"checkbox\" name=\"optIn\" value=\"true\">"); } $opt_table->addCol("Tick this to recive eMails from MiningBuddy. You will get eMails that will inform you about new events entered into the system, Mining Run reciepts and the occasional CEO email."); $opt_table->addHeaderCentered("<input type=\"submit\" name=\"submit\" value=\"Update your eMail preferences\">"); /* * Show/hide inofficial runs */ $sir_table = new table(2, true); $sir_table->addHeader(">> Show/Hide inofficial runs"); $sir_table->addRow(); if ($PREFS->getPref("sirstate")) { $sir_table->addCol("<input type=\"checkbox\" CHECKED name=\"sir\" value=\"true\">"); } else { $sir_table->addCol("<input type=\"checkbox\" name=\"sir\" value=\"true\">"); } $sir_table->addCol("Tick the box to show non-official mining operations. Your own inofficial mining runs are still shown, however."); $sir_table->addHeaderCentered("<input type=\"submit\" name=\"submit\" value=\"Update your settings\">"); /* * Update eMail address. */ if ($MySelf->canChangeEmail()) { $email_table = new table(2, true); $email_table->addHeader(">> Update your eMail address"); $email_table->addRow("#060622"); $email_table->addCol("Your email is needed to send password hints and event news.", array("colspan" => 2)); // Query the oracle. $email_table->addRow(); $email = $DB->getCol("select email from users where username = '******' AND deleted='0' limit 1"); $email_table->addCol("Current eMail:"); $email_table->addCol("<input type=\"text\" readonly value=\"" . $email[0] . "\">"); $email_table->addRow(); $email_table->addCol("New eMail:"); $email_table->addCol("<input type=\"text\" name=\"email\" maxlength=\"100\">"); $email_table->addHeaderCentered("<input type=\"submit\" name=\"change\" value=\"Update your eMail\">"); } /* * Change password. */ if ($MySelf->canChangePwd()) { $password_table = new table(2, true); $password_table->addHeader(">> Change your password"); $password_table->addRow("#060622"); $password_table->addCol("Its always a good idea to change your password frequently. Your password is " . "stored in an encrypted form; no one will ever be able to read it.", array("colspan" => "2")); $password_table->addRow(); $password_table->addCol("Changing password for:"); $password_table->addCol(ucfirst($MySelf->getUsername())); $password_table->addRow(); $password_table->addCol("Your current password:"******"<input type=\"password\" name=\"password\" maxlength=\"20\">"); $password_table->addRow(); $password_table->addCol("Set a new password:"******"<input type=\"password\" name=\"password1\" maxlength=\"20\">"); $password_table->addRow(); $password_table->addCol("Verify your new password:"******"<input type=\"password\" name=\"password2\" maxlength=\"20\">"); $password_table->addHeaderCentered("<input type=\"submit\" name=\"change\" value=\"Update your password\">"); } // Assemble the html. $page = "<h2>Your Preferences</h2>"; $page .= "<form action=\"index.php\" method=\"POST\">"; $page .= $cantimer_table->flush(); $page .= "<input type=\"hidden\" name=\"action\" value=\"changecanpage\">"; $page .= "<input type=\"hidden\" name=\"check\" value=\"check\"></form>"; $page .= "<form action=\"index.php\" method=\"POST\">"; $page .= $opt_table->flush(); $page .= "<input type=\"hidden\" name=\"check\" value=\"check\">"; $page .= "<input type=\"hidden\" name=\"action\" value=\"optIn\"></form>"; $page .= "<form action=\"index.php\" method=\"POST\">"; $page .= $sir_table->flush(); $page .= "<input type=\"hidden\" name=\"check\" value=\"check\">"; $page .= "<input type=\"hidden\" name=\"action\" value=\"sirchange\"></form>"; if ($MySelf->canChangeEmail()) { $page .= "<form action=\"index.php\" method=\"post\">"; $page .= $email_table->flush(); $page .= "<input type=\"hidden\" name=\"action\" value=\"changeemail\">"; $page .= "<input type=\"hidden\" name=\"check\" value=\"check\">"; $page .= "</form>"; } if ($MySelf->canChangePwd()) { $page .= "<form action=\"index.php\" method=\"post\">"; $page .= $password_table->flush(); $page .= "<input type=\"hidden\" name=\"action\" value=\"changepw\">"; $page .= "<input type=\"hidden\" name=\"check\" value=\"check\">"; $page .= "<input type=\"hidden\" name=\"username\" value=\"%%USERNAME%%\">"; $page .= "</form>"; } // Api Keys // Load possible current keys. $api = new api($MySelf->getID()); $api_key = $api->getApiKey(); $api_id = $api->getApiID(); if (!$api->valid()) { $api->authorizeApi(); } // Do the api table. $api_table = new table(2, true); $api_table->addHeader(">> Api key management"); $api_table->addRow(); $api_table->addCol("Here you can supply your limited-access API-Key. Its used for quick-login for now.", array("colspan" => 2)); if ($api_id && $api->valid()) { $s1 = "<input type =\"hidden\" name=\"apiID\" value=\"{$api_id}\">{$api_id}"; } else { $s1 = "<input type=\"text\" name=\"apiID\" value=\"{$api_id}\">"; $doApiLink = true; } if ($api_key && $api->valid()) { $s2 = "<input type =\"hidden\" name=\"apiKey\" value=\"{$api_key}\">{$api_key}"; } else { $s2 = "<input type=\"text\" size=\"80\" name=\"apiKey\" value=\"{$api_key}\">"; $doApiLink = true; } $api_table->addRow(); $api_table->addCol("API ID:"); $api_table->addCol($s1); $api_table->addRow(); $api_table->addCol("Verification Code:"); $api_table->addCol($s2); // Add the API link to eve online. global $IGB; global $IGB_VISUAL; if ($doApiLink && (!$IGB || $IGB && $IGB_VISUAL)) { $api_table->addRow(); $api_table->addCol("Get your API key here:"); $api_table->addCol("<a href=\"http://support.eveonline.com/api/default.asp\">http://support.eveonline.com/api/default.asp</a>"); } if ($api_key) { $api_table->addRow(); $api_table->addCol("API Key validated:"); if (!$api->valid()) { $hint = " (If your key is not validated, hit update API key button.)"; } $api_table->addCol(yesno($api->valid(), yes) . $hint); if ($api->valid()) { $api_table->addRow(); $api_table->addCol("Validated on:"); $api_table->addCol(date("d.m.Y H:i:s", $api->validatedOn())); $api_table->addRow(); $api_table->addCol("Next verification at:"); $api_table->addCol(date("d.m.Y H:i:s", $api->nextValidation())); $api_table->addRow(); $api_table->addCol("API keys are valid for:"); $days = getConfig("api_keys_valid"); if ($days <= 1) { $days = "1 day."; } else { $days = $days . " days."; } $api_table->addCol($days); $api_table->addRow(); $api_table->addCol("Character ID:"); $api_table->addCol($api->getCharacterID()); } $api_table->addRow(); $api_table->addCol("Remove Key:"); $api_table->addCol("<input type=\"checkbox\" name=\"deleteKey\" value=\"true\"> Tick box to remove the API key from the Database."); } $api_table->addHeaderCentered("<input type=\"submit\" name=\"update_api\" value=\"Update API Key\">"); $api_form .= "<form action=\"index.php\" method=\"POST\">"; $api_form .= $api_table->flush(); $api_form .= "<input type=\"hidden\" name=\"action\" value=\"update_api\">"; $api_form .= "<input type=\"hidden\" name=\"check\" value=\"check\"></form>"; $page .= $api_form; // We are done here. return $page; }