PHP ba_db_fetch_assoc函数代码示例

function GetBookingTypeAvailability($eventid, $bookingtype, $spaces)
{
    //Returns -1 if no booking allowed
    //Returns 1 if booking allowed
    //Returns 0 if booking will be placed in queue as speaces are full.
    global $link, $today, $db_prefix;
    $sql = "select count(itItemID) from {$db_prefix}items where itTicket = 1 and itAvailableFrom <= '{$today}' and itAvailableTo >= '{$today}' and itAvailability in ('All', '{$bookingtype}') and itEventID = {$eventid}";
    $result = ba_db_query($link, $sql);
    $TicketTypeAvailable = ba_db_fetch_row($result);
    $TicketTypeAvailableCount = $TicketTypeAvailable[0];
    if ($TicketTypeAvailableCount == 0 && $bookingtype != "All") {
        return -1;
    }
    $sql = "select count(bkID) as BookingCount from {$db_prefix}bookings where bkInQueue = 0 and bkEventID = {$eventid} ";
    if ($bookingtype != "All") {
        $sql .= " and bkBookAs = '{$bookingtype}'";
    }
    $result = ba_db_query($link, $sql);
    $BookingCount = ba_db_fetch_assoc($result);
    $BookingCount = $BookingCount['BookingCount'];
    if ($BookingCount >= $spaces) {
        if (QUEUE_OVER_LIMIT) {
            return 0;
        } else {
            return -1;
        }
    }
    return 1;
}

</p>

<table class = 'sortable' border = 1>
<tr>
<th>Player ID</th>
<th>OOC First Name</th>
<th>OOC Surname</th>
<th>E-mail</th>
<th>Car Registration</th>
<th>Character Name</th>
<th colspan = '4'>Actions</th>
</tr>
<?php 
//$bNone is True if no rows were displayed
$bNone = True;
while ($row = ba_db_fetch_assoc($result)) {
    echo "<tr class = 'highlight'><td>" . PID_PREFIX . sprintf('%03s', $row['plPlayerID']);
    if ($row['plPassword'] == 'ACCOUNT DISABLED') {
        echo " (account disabled)";
    }
    echo "</td>";
    echo "<td>" . htmlentities(stripslashes($row["plFirstName"])) . "</td>\n";
    echo "<td>" . htmlentities(stripslashes($row["plSurname"])) . "</td>\n";
    $sMail = htmlentities(stripslashes($row["plEmail"]));
    echo "<td><a href = 'mailto:{$sMail}'>{$sMail}</a></td>\n";
    echo "<td>" . htmlentities(stripslashes($row["plCarRegistration"])) . "</td>\n";
    echo "<td>" . htmlentities(stripslashes($row["chName"])) . "</td>\n";
    echo "<td><a href = 'admin_edit_ooc.php?pid=" . $row['plPlayerID'] . "'>edit OOC data</a></td>\n";
    echo "<td><a href = 'admin_edit_ic.php?pid=" . $row['plPlayerID'] . "'>edit IC data</a></td>\n";
    echo "<td><a href = 'admin_viewdetails.php?pid=" . $row['plPlayerID'] . "'>view OOC &amp; IC details</a></td>\n";
    echo "<td><a href = 'admin_pw_reset.php?pid=" . $row['plPlayerID'] . "'>reset password</a></td></tr>\n";

<h2><?php 
echo htmlentities(stripslashes($eventinfo['evEventName']));
?>
</h2>

<p>
Required for the pre-booked characters:
</p>

<h3>Booked Item Summary</h3>

<?php 
$sql = "select itDescription, itAvailability, ifnull(sum(biQuantity),0) as itBookingCount from {$db_prefix}items left outer join {$db_prefix}bookingitems on itItemID = biItemID inner join {$db_prefix}bookings on bkID = biBookingID where itEventID = {$eventid} and  bkDatePaymentConfirmed <> '' AND bkDatePaymentConfirmed <> '0000-00-00' group by itItemID";
$result = ba_db_query($link, $sql);
echo "<table><tr><th>Item name</th><th>Availability</th><th>Booking Count</th></tr>";
while ($itembooking = ba_db_fetch_assoc($result)) {
    echo "<tr><td>" . $itembooking['itDescription'] . "</td><td>" . $itembooking['itAvailability'] . "</td><td>" . $itembooking['itBookingCount'] . "</td></tr>";
}
echo "</table>";
echo "<h3>Power Cards</h3>\n";
echo "<p>{$iCards} Power cards per day\n<br>";
echo $iHerbLore * 5 . " Herb cards\n</p>\n";
echo "<h3>Lore Sheets</h3>\n";
echo "<p>{$iSenseMagic} Sense Magic lore sheets<br>\n";
echo "{$iEvaluate} Evaluate lore sheets<br>\n";
echo "{$iPotionLore} Potion Lore lore sheets<br>\n";
echo "{$iPoisonLore} Poison Lore lore sheets<br>\n";
echo "{$iRecForgery} Recognise Forgery lore sheets<br>\n";
echo "{$iHerbLore} Herb Lore lore sheets<br>\n</p>\n";
echo "<h3>Other</h3>\n";
echo "<p>{$iTranslate} characters have the Translate Named Script OSP<br>\n";

     //Mark as paid.
     //Custom value is the bookingid
     //Don't set bkAmountExpected, and we add to amount paid, allowing potential for partial payments in future.
     $custom = (int) $custom;
     $sql = "UPDATE {$db_prefix}bookings SET bkDatePaymentConfirmed = '" . date('Y-m-d') . "', bkAmountPaid = bkAmountPaid + " . $payment_amount . " WHERE bkID = " . $custom;
     //Run UPDATE query to set paid date
     ba_db_query($link, $sql);
     //Mark bunk as allocated if one was requested
     $sql = "UPDATE {$db_prefix}bookings SET bkBunkAllocated = 1 WHERE bkBunkRequested = 1 and bkID = " . $custom;
     //Run UPDATE query to set assign bunk
     ba_db_query($link, $sql);
 }
 //Get details for e-mail
 $sql_select = "SELECT plFirstName, plSurname, plEmail FROM {$db_prefix}players WHERE plPlayerID = " . $item_number;
 $result = ba_db_query($link, $sql_select);
 $row = ba_db_fetch_assoc($result);
 //Send e-mail
 $sBody = "Your payment for the upcoming event has been received.\n";
 if (PAYPAL_AUTO_MARK_PAID) {
     $sBody .= "You are now fully booked.\n\n";
 } else {
     $sBody .= "You will be fully booked once your booking has been confirmed by a system administrator.\n\n";
 }
 $sBody .= "Thank you.\n\n";
 $sBody .= "Player ID: " . PID_PREFIX . sprintf('%03s', $iPlayerID) . "\n";
 $sBody .= "OOC Name: " . $row['plFirstName'] . " " . $row['plSurname'];
 if ($bEmailPaymentReceived) {
     mail($row['plEmail'], SYSTEM_NAME . ' - payment received', $sBody, "From:" . SYSTEM_NAME . " <" . EVENT_CONTACT_MAIL . ">");
 }
 //Clear any payment requests for this booking
 $sql = "delete from {$db_prefix}paymentrequests where prBookingID = " . $custom;

        }
        //Do not redirect if there are any warnings (required fields not filled in, etc)
        if ($sWarn == '') {
            //Make up URL & redirect
            $sURL = fnSystemURL() . "admin_viewdetails.php?pid={$admin_player_id}&green=" . urlencode("OOC details updated");
            header("Location: {$sURL}");
        }
    } else {
        $sWarn = "There was a problem updating the OOC details";
        LogError("Error updating OOC information (admin_edit_ooc.php). Player ID: {$admin_player_id}");
    }
}
//Get existing details if there are any
$sql = "SELECT plFirstName, " . "plSurname, " . "AES_DECRYPT(pleAddress1, '{$key}') AS dAddress1, " . "AES_DECRYPT(pleAddress2, '{$key}') AS dAddress2, " . "AES_DECRYPT(pleAddress3, '{$key}') AS dAddress3, " . "AES_DECRYPT(pleAddress4, '{$key}') AS dAddress4, " . "AES_DECRYPT(plePostcode, '{$key}') AS dPostcode, " . "AES_DECRYPT(pleTelephone, '{$key}') AS dTelephone, " . "AES_DECRYPT(pleMobile, '{$key}') AS dMobile, " . "plEmail, " . "plDOB, " . "AES_DECRYPT(pleMedicalInfo, '{$key}') AS dMedicalInfo, " . "plEmergencyName, " . "AES_DECRYPT(pleEmergencyNumber, '{$key}') AS dEmergencyNumber, " . "plEmergencyRelationship, " . "plCarRegistration, " . "plDietary, " . "plNotes, " . "plAdminNotes, " . "plEventPackByPost, " . "plRefNumber, " . "plMarshal " . "FROM {$db_prefix}players WHERE plPlayerID = {$admin_player_id}";
$result = ba_db_query($link, $sql);
$playerrow = ba_db_fetch_assoc($result);
include '../inc/inc_head_html.php';
include '../inc/inc_js_forms.php';
?>

<h1><?php 
echo TITLE;
?>
 - Admin OOC Edit</h1>

<?php 
if ($sWarn != '') {
    echo "<p class = 'warn'>{$sWarn}</p>";
}
?>

' /></td></tr>
<tr><td>Staff Bunks</td><td><input type='text' name='txtStaffBunks' value='<?php 
echo $eventinfo['evStaffBunks'];
?>
' /></td></tr>
<tr><td>Total Bunks</td><td><input type='text' name='txtTotalBunks' value='<?php 
echo $eventinfo['evTotalBunks'];
?>
' /></td></tr>
<tr><td>Event Items<br>To allow players to get a reduction, add an item with a negative price (eg &quot;Pot washing: -10&quot;)</td><td>
<table id='itemtable'>
<tr><th>Item name</th><th>Availability</th><th>Ticket</th><th>Meal</th><th>Bunk</th><th>From</th><th>To</th><th>Cost</th><th>Multiple</th><th>Mandatory</th></tr>
<?php 
$sql = "Select * from {$db_prefix}items where itEventID = {$eventid}";
$result = ba_db_query($link, $sql);
while ($item = ba_db_fetch_assoc($result)) {
    echo "<tr id='rowItem" . $item['itItemID'] . "'>";
    echo "<td><input type='hidden' name='hItemID" . $item['itItemID'] . "' value='" . $item['itItemID'] . "'/>";
    echo "<input type='text' name='txtItemDescription" . $item['itItemID'] . "' value='" . $item['itDescription'] . "' /></td>";
    echo "<td><select name='cboAvailability" . $item['itItemID'] . "'>";
    echo "<option ";
    if ($item['itAvailability'] == 'All') {
        echo 'selected ';
    }
    echo "value='All'>All</option>";
    echo "<option ";
    if ($item['itAvailability'] == 'Player') {
        echo 'selected ';
    }
    echo "value='Player'>Player</option>";
    echo "<option ";

        $queuereason = "your character is not a member of the default faction.";
    }
    //Deal with being over the limit
    if (QUEUE_OVER_LIMIT) {
        if ($bookinginfo['bkBookAs'] == "Player") {
            $spaces = $eventinfo['evPlayerSpaces'];
        }
        if ($bookinginfo['bkBookAs'] == "Monster") {
            $spaces = $eventinfo['evMonsterSpaces'];
        }
        if ($bookinginfo['bkBookAs'] == "Staff") {
            $spaces = $eventinfo['evStaffSpaces'];
        }
        $limitsql = "select count(bkID) as BookingCount from {$db_prefix}bookings where bkInQueue = 0 and bkBookAs ='" . $bookinginfo['bkBookAs'] . "' and bkEventID = {$eventid} ";
        $limitresult = ba_db_query($link, $limitsql);
        $BookingCount = ba_db_fetch_assoc($limitresult);
        $BookingCount = $BookingCount['BookingCount'];
        if ($BookingCount > $spaces) {
            $bookinginfo['bkInQueue'] = 1;
            $queuereason = "there are no spaces remaining of your booking type.";
        }
    }
}
if ($bookinginfo['bkInQueue'] == 0) {
    if ($bookingtotal > 0) {
        echo "<table class='payment'>";
        echo "<tr><td>Pay Later</td><td><a href='start.php'>Pay later</a></td></tr>";
        if (USE_PAY_PAL) {
            echo "<tr><td>Pay balance of &pound;{$bookingtotal} via Paypal:</td><td>";
            generatePaypalButton("Event booking - " . $bookinginfo['evEventName'] . " (" . PID_PREFIX . sprintf('%03s', $PLAYER_ID) . ")", $PLAYER_ID, $bookingtotal, $bookinginfo['bkID']);
            echo "</td></tr>";

 $iYear = substr($dPaid, 0, 4);
 $iMonth = substr($dPaid, 5, 2);
 $iDate = substr($dPaid, 8, 2);
 $sPaid = "{$iDate}-{$iMonth}-{$iYear}";
 echo '"' . $sPaid . '",';
 //Amounts paid
 echo '"' . $row['bkAmountPaid'] . '",';
 echo '"' . $row['bkAmountExpected'] . '",';
 //OSPs - one per column
 if (USE_SHORT_OS_NAMES) {
     $osps = ba_db_query($link, "SELECT ospShortName as ospExportName, otOspID, otAdditionalText FROM {$db_prefix}ospstaken, {$db_prefix}osps " . "WHERE otPlayerID = {$row['plPlayerID']} AND ospID = otOspID ORDER BY ospShortName");
 } else {
     $osps = ba_db_query($link, "SELECT ospName as ospExportName, otOspID, otAdditionalText FROM {$db_prefix}ospstaken, {$db_prefix}osps " . "WHERE otPlayerID = {$row['plPlayerID']} AND ospID = otOspID ORDER BY ospName");
 }
 $sOSList = "";
 while ($record = ba_db_fetch_assoc($osps)) {
     $sOSList .= '"' . stripslashes($record['ospExportName']);
     if ($record['otAdditionalText'] != "") {
         $sOSList .= " (" . stripslashes($record['otAdditionalText']) . ")";
     }
     $sOSList .= '",';
     //Extra spell card OSPs
     if ($record['otOspID'] == 6) {
         $iCards = $iCards + 4;
     }
     if ($record['otOspID'] == 7) {
         $iCards = $iCards + 8;
     }
     if ($record['otOspID'] == 3) {
         $iCards = $iCards + 12;
     }

if ($row['plFirstName'] == '' || $row['plSurname'] == '') {
    $bAllOOCInfo = False;
}
if ($row['dAddress1'] == '' || $row['plEmergencyName'] == '') {
    $bAllOOCInfo = False;
}
if ($row['dEmergencyNumber'] == '' || $row['plEmergencyRelationship'] == '') {
    $bAllOOCInfo = False;
}
if ($row['plCarRegistration'] == '' || $row['plDietary'] == 'Select one') {
    $bAllOOCInfo = False;
}
//Get bookings details. Determine if player is booked
$booking_sql = "SELECT * FROM {$db_prefix}bookings WHERE bkPlayerID = {$PLAYER_ID}";
$booking_result = ba_db_query($link, $booking_sql);
$booking_row = ba_db_fetch_assoc($booking_result);
$sOOC = $booking_row['bkDateOOCConfirmed'];
if ($sOOC == '' || $sOOC == '0000-00-00') {
    $bConfirmed = False;
} else {
    $bConfirmed = True;
}
if (strtolower($_POST['btnSubmit']) == 'edit' && CheckReferrer('ooc_view.php')) {
    //Make up URL
    $sURL = fnSystemURL() . 'ooc_form.php';
    header("Location: {$sURL}");
} elseif (strtolower($_POST['btnSubmit']) == 'confirm' && CheckReferrer('ooc_view.php')) {
    $sDate = date('Y-m-d');
    //Check if player already has an entry in bookings table
    $sql = "SELECT * FROM {$db_prefix}bookings WHERE bkPlayerID = {$PLAYER_ID}";
    $result = ba_db_query($link, $sql);

    } else {
        echo $cellstart . formatdata($row['chAncestor'], $bHTML) . $cellend . $separator;
    }
    echo $cellstart . formatdata($row['chNotes'], $bHTML) . $cellend . $separator;
    //Get OSPs
    $db_prefix = DB_PREFIX;
    $ospSql = "SELECT otID, ospName, otAdditionalText FROM {$db_prefix}osps, {$db_prefix}ospstaken " . "WHERE otPlayerID = " . $row['plPlayerID'] . " AND otospID = ospID order by ospName";
    $rOSPs = ba_db_query($link, $ospSql);
    echo $cellstart;
    while ($record = ba_db_fetch_assoc($rOSPs)) {
        $celldata = $record['ospName'];
        if ($record['otAdditionalText'] != "") {
            $celldata .= " (" . $record['otAdditionalText'] . ")";
        }
        echo formatdata($celldata, $bHTML) . '; ';
    }
    echo $cellend . $separator;
    //Get skills
    $db_prefix = DB_PREFIX;
    $skSql = "SELECT stSkillID, skName FROM {$db_prefix}skills, {$db_prefix}skillstaken " . "WHERE stPlayerID = " . $row['plPlayerID'] . " AND stSkillID = skID order by skName";
    $rSkills = ba_db_query($link, $skSql);
    echo $cellstart;
    while ($record = ba_db_fetch_assoc($rSkills)) {
        echo formatdata($record['skName'], $bHTML) . '; ';
    }
    echo $cellend . $rowend;
}
if ($_GET['action'] == 'view') {
    echo "</table>\n";
    include '../inc/inc_foot.php';
}

function resetExpectedAmount($bookingid)
{
    global $today, $db_prefix, $link;
    $sql = "select sum(biQuantity * itItemCost) as Expected from {$db_prefix}bookingitems inner join {$db_prefix}items on biItemID = itItemID where biBookingID = {$bookingid}";
    $result = ba_db_query($link, $sql);
    $expected = ba_db_fetch_assoc($result);
    $expected = $expected['Expected'];
    $sql = "update {$db_prefix}bookings set bkAmountExpected = {$expected} where bkID = {$bookingid}";
    $result = ba_db_query($link, $sql);
}

}
if ($PLAYER_ID != 0) {
    if ($sOOC == '' || $sOOC == '0000-00-00') {
        echo "<li><a href = '{$CSS_PREFIX}ooc_form.php'>OOC information</a></li>\n";
    } else {
        echo "<li><a href = '{$CSS_PREFIX}ooc_view.php'>OOC information</a></li>\n";
    }
    if ($sDateIC == '' || $sDateIC == '0000-00-00') {
        echo "<li><a href = '{$CSS_PREFIX}ic_form.php'>IC information</a></li>\n";
    } else {
        echo "<li><a href = '{$CSS_PREFIX}ic_view.php'>IC information</a></li>\n";
    }
    //Show link to admin page if user is an admin or root user
    $sql = "SELECT plAccess FROM " . DB_PREFIX . "players WHERE plPlayerID = {$PLAYER_ID}";
    $result = ba_db_query($link, $sql);
    $inc_head_html_row = ba_db_fetch_assoc($result);
    if ($inc_head_html_row['plAccess'] == 'admin' || ROOT_USER_ID == $PLAYER_ID) {
        echo "<li><a href = '{$CSS_PREFIX}admin/admin.php'>Admin</a></li>\n";
    }
}
echo "</ul>";
echo "</div>";
if (($inc_head_html_row['plAccess'] == 'admin' || ROOT_USER_ID == $PLAYER_ID) && $PLAYER_ID != 0) {
    //Check for install & NON_WEB directories
    if (file_exists(dirname($_SERVER["SCRIPT_FILENAME"]) . "/install")) {
        echo "<span class = 'sans-warn'>The <a href = 'install/'>install</a> directory is present. It should be removed if the system is live</span><br />";
    }
    if (file_exists(dirname($_SERVER["SCRIPT_FILENAME"]) . "/NON_WEB")) {
        echo "<span class = 'sans-warn'>The NON_WEB directory is present. It should be removed</span><br />";
    }
}

 | Bitsand.  If not, see <http://www.gnu.org/licenses/>.
 +---------------------------------------------------------------------------*/
include 'inc/inc_head_db.php';
include 'inc/inc_head_html.php';
$bookingid = (int) htmlentities(stripslashes($_GET['BookingID']));
if ($bookingid == 0) {
    $bookingid = (int) htmlentities(stripslashes($_POST['BookingID']));
}
$sql = "Select * FROM {$db_prefix}bookings inner join {$db_prefix}events on evEventID = bkEventID where bkPlayerID = {$PLAYER_ID} and bkID = " . $bookingid;
$result = ba_db_query($link, $sql);
if (ba_db_num_rows($result) == 0) {
    $sMsg = "You cannot view this booking";
    $sURL = fnSystemURL() . 'start.php?warn=' . urlencode($sMsg);
    header("Location: {$sURL}");
}
$bookinginfo = ba_db_fetch_assoc($result);
if ($_POST['cancel'] != null) {
    $sURL = fnSystemURL() . 'booking.php?BookingID=' . $bookingid;
    header("Location: {$sURL}");
} else {
    if ($_POST['delete'] != null || $_POST['rebook'] != null) {
        $sql = "DELETE FROM {$db_prefix}bookingitems WHERE biBookingID = " . $bookingid;
        ba_db_query($link, $sql);
        $sql = "DELETE FROM {$db_prefix}paymentrequests WHERE prBookingID = " . $bookingid;
        ba_db_query($link, $sql);
        $sql = "DELETE FROM {$db_prefix}bookings WHERE bkID = " . $bookingid;
        ba_db_query($link, $sql);
        if ($_POST['delete'] != null) {
            $sMsg = "Your booking has been cancelled for " . htmlentities(stripslashes($bookinginfo['evEventName']));
            $sURL = fnSystemURL() . 'start.php?warn=' . urlencode($sMsg);
            header("Location: {$sURL}");