예제 #1
0
function notify_status($new_status)
{
    global $mysql;
    $bid = $_POST['bid'];
    $bug_date = $_POST['bug_date'];
    $bug = $_POST['bug'];
    $from = "SYSTEM";
    $to = $_POST['name'];
    $charid = getPlayerID($_POST['name']);
    $subject = "Bug Report Status Update";
    $note = $_POST['optional_note'];
    $body = "This is a system generated message to notify you that the status of your bug report has changed.\nDo not reply to this message.\n\nBug ID: " . $bid . "\nNew Status: " . $new_status . "\nBug Date: " . $bug_date . "\nBug: " . $bug;
    if ($note) {
        $body .= "\nAdmin Note: " . $note;
    }
    $query = "INSERT INTO mail (`charid`,`timestamp`,`from`,`subject`,`body`,`to`,`status`) VALUES ({$charid},UNIX_TIMESTAMP(NOW()),\"{$from}\",\"{$subject}\",\"{$body}\",\"{$to}\",1)";
    $mysql->query_no_result($query);
}
예제 #2
0
        echo $x % 2 == 0 ? "BBBBBB" : "AAAAAA";
        ?>
">
            <td align="center" width="5%"><?php 
        echo $v['hid'];
        ?>
</td>
            <td align="center" width="10%"><a href="index.php?editor=account&acctid=<?php 
        echo getAccountID($v['account']);
        ?>
"><?php 
        echo $v['account'];
        ?>
</a></td>
            <td align="center" width="15%"><a href="index.php?editor=player&playerid=<?php 
        echo getPlayerID($v['name']);
        ?>
"><?php 
        echo $v['name'];
        ?>
</a></td>
            <td align="center" width="15%"><?php 
        echo $v['zone'] ? $v['zone'] : "N/A";
        ?>
</td>
            <td align="center" width="20%"><?php 
        echo $v['date'];
        ?>
</td>
            <td align="center" width="25%"><?php 
        echo substr($v['hacked'], 0, 23);
예제 #3
0
파일: mail.php 프로젝트: Xackery/EQEmuEOC
function send_message()
{
    global $mysql;
    $subject = $_POST['subject'];
    $body = $_POST['body'];
    $charid = getPlayerID($_POST['to_text']);
    $to = $_POST['to_text'];
    $from = $_POST['from_text'];
    $query = "INSERT INTO mail (`charid`,`timestamp`,`from`,`subject`,`body`,`to`,`status`) VALUES ({$charid},UNIX_TIMESTAMP(NOW()),\"{$from}\",\"{$subject}\",\"{$body}\",\"{$to}\",1)";
    $mysql->query_no_result($query);
}
예제 #4
0
    foreach ($hackers as $hackers => $v) {
        ?>
          <tr bgcolor="#<?php 
        echo $x % 2 == 0 ? "BBBBBB" : "AAAAAA";
        ?>
">
            <td align="center" width="5%"><?php 
        echo $v['hid'];
        ?>
</td>
            <td align="center" width="10%"><?php 
        echo getAccountID($v['account']) ? "<a href=\"index.php?editor=account&acctid=" . getAccountID($v['account']) . "\">" . $v['account'] . "</a>" : $v['account'];
        ?>
</td>
            <td align="center" width="15%"><?php 
        echo getPlayerID($v['name']) ? "<a href=\"index.php?editor=player&playerid=" . getPlayerID($v['name']) . "\">" . $v['name'] . "</a>" : $v['name'];
        ?>
</td>
            <td align="center" width="15%"><?php 
        echo $v['zone'] ? $v['zone'] : "N/A";
        ?>
</td>
            <td align="center" width="20%"><?php 
        echo $v['date'];
        ?>
</td>
            <td align="center" width="25%"><a title="<?php 
        echo $v['hacked'];
        ?>
"><?php 
        echo substr($v['hacked'], 0, 23);
예제 #5
0
          <td width="5%">&nbsp;</td>
        </tr>
<?php 
    $x = 0;
    foreach ($players as $player) {
        ?>
        <tr bgcolor="#<?php 
        echo $x % 2 == 0 ? "BBBBBB" : "AAAAAA";
        ?>
">
          <td align="center"><?php 
        echo $player['id'];
        ?>
</td>
          <td align="center"><a href="index.php?editor=player&playerid=<?php 
        echo getPlayerID($player['name']);
        ?>
"><?php 
        echo $player['name'];
        ?>
</a></td>
          <td align="center"><a href="index.php?editor=account&acctid=<?php 
        echo $player['account_id'];
        ?>
"><?php 
        echo getAccountName($player['account_id']);
        ?>
</a></td>
          <td align="center"><?php 
        echo $classes[$player['class']];
        ?>
예제 #6
0
<?php

include_once "GCM_Loader.php";
$db = new BaseDB();
$gameName = $_REQUEST['gameName'];
if (isset($_REQUEST['email'])) {
    $email = $_REQUEST['email'];
} else {
    $email = '';
}
$gcmRegistrationId = $_REQUEST['gcmRegistrationId'];
$clanID = $_REQUEST['clanID'];
$retArray = array();
// Does player exist in the table
$exist = doesPlayerExist($gameName, $clanID);
$playerID = getPlayerID($gameName, $clanID);
if ($playerID === null) {
    echo json_encode([$retArray = array("responseOK" => false, "responseMessage" => "No such player")]);
    goto EndOfFile;
}
if ($exist === true) {
    // Update the existing record
    $sql = "\n            UPDATE gcm_users\n            SET email = '{$email}', gcm_regid = '{$gcmRegistrationId}'\n            WHERE game_name = '{$gameName}'\n        ";
    $result = $db->dbQuery($sql);
    if ($result == false) {
        echo json_encode([$retArray = array("responseOK" => false, "responseMessage" => dbGetErrorMsg())]);
    } else {
        echo json_encode(array($retArray = array("responseOK" => true, "responseMessage" => 'Record Updated Successfully')));
    }
} else {
    // Create a new record
예제 #7
0
         include 'view/loginSplash.php';
     }
 } else {
     if ($action == 'create') {
         include 'view/createUser.php';
     } else {
         if ($action == 'create_user') {
             $playerName = filter_input(INPUT_POST, 'username');
             $playerPassword = filter_input(INPUT_POST, 'password');
             $value = checkUserName($playerName);
             if ($value[0] == 1) {
                 $create_error = 'Username is already in use. Please try another name.';
                 include 'view/createUser.php';
             } else {
                 addUser($playerName, $playerPassword);
                 $value2 = getPlayerID($playerName, $playerPassword);
                 $_SESSION['id'] = $value2[0];
                 addPuzzles($_SESSION['id']);
                 include 'view/loginSplash.php';
             }
         } else {
             if ($action == 'logout') {
                 $login_error = 'Thank you for playing. You have successfully logged out.';
                 include 'view/login.php';
             } else {
                 if ($action == 'delete_splash') {
                     include 'view/delete_user.php';
                 } else {
                     if ($action == 'delete_user') {
                         $playerID = $_SESSION['id'];
                         deleteUser($playerID);
예제 #8
0
        <tr>
          <td align="center"><strong><?echo ($sort == 1) ? "ID <img src='images/sort_red.bmp' border='0' width='8' height='8'/>" : "<a href='index.php?editor=player&sort=1" . (($filter['status'] == "on") ? $filter['url'] : "") . "'>ID <img src='images/sort_green.bmp' border='0' width='8' height='8' title='Sort by ID'/></a>";?></strong></td>
          <td align="center"><strong><?echo ($sort == 2) ? "Name <img src='images/sort_red.bmp' border='0' width='8' height='8'/>" : "<a href='index.php?editor=player&sort=2" . (($filter['status'] == "on") ? $filter['url'] : "") . "'>Name <img src='images/sort_green.bmp' border='0' width='8' height='8' title='Sort by Name'/></a>";?></strong></td>
          <td align="center"><strong><?echo ($sort == 3) ? "Account <img src='images/sort_red.bmp' border='0' width='8' height='8'/>" : "<a href='index.php?editor=player&sort=3" . (($filter['status'] == "on") ? $filter['url'] : "") . "'>Account <img src='images/sort_green.bmp' border='0' width='8' height='8' title='Sort by Account'/></a>";?></strong></td>
          <td align="center"><strong><?echo ($sort == 4) ? "Class <img src='images/sort_red.bmp' border='0' width='8' height='8'/>" : "<a href='index.php?editor=player&sort=4" . (($filter['status'] == "on") ? $filter['url'] : "") . "'>Class <img src='images/sort_green.bmp' border='0' width='8' height='8' title='Sort by Class'/></a>";?></strong></td>
          <td align="center"><strong><?echo ($sort == 5) ? "Level <img src='images/sort_red.bmp' border='0' width='8' height='8'/>" : "<a href='index.php?editor=player&sort=5" . (($filter['status'] == "on") ? $filter['url'] : "") . "'>Level <img src='images/sort_green.bmp' border='0' width='8' height='8' title='Sort by Level'/></a>";?></strong></td>
          <td width="5%">&nbsp;</td>
        </tr>
<?$x=0;
foreach($players as $player):?>
        <tr bgcolor="#<? echo ($x % 2 == 0) ? "BBBBBB" : "AAAAAA";?>">
          <td align="center"><?php 
echo $player['id'];
?>
</td>
          <td align="center"><a href="index.php?editor=player&playerid=<?echo getPlayerID($player['name'])?>"><?php 
echo $player['name'];
?>
</a></td>
          <td align="center"><a href="index.php?editor=account&acctid=<?php 
echo $player['account_id'];
?>
"><?echo getAccountName($player['account_id'])?></a></td>
          <td align="center"><?php 
echo $classes[$player['class']];
?>
</td>
          <td align="center"><?php 
echo $player['level'];
?>
</td>