PHP Result_Error Examples

Example #1

File: _match_close.php Project: ryall/pikpik

<?php

// ==================================================
// Initialise variables for the operation.
// ==================================================
$sid = $stream_values["sid"];
$pass = $stream_values["pass"];
$state = $STATUS_CLOSED;
// ==================================================
// Check the credentials of the session.
// ==================================================
// Verify the session ID.
// Verify the password.
// ==================================================
// Set the session state to closed.
// ==================================================
$query = SQL_Query($mysql_database, "UPDATE matchmaking SET state = {$state} WHERE sid = '{$sid}' AND pass = '******'");
if (!$query) {
    Result_Error($ERROR_QUERY_FAILED);
}
Result_Success();

Example #2

File: _match_list.php Project: ryall/pikpik

// ==================================================
$gid = $stream_values["gid"];
$limit = min($stream_values["limit"], $MAX_RESULTS);
// ==================================================
// Mark all expired sessions as closed.
// ==================================================
$query = SQL_Query($mysql_database, "UPDATE matchmaking SET state = {$STATUS_TIMEOUT} WHERE state = {$STATUS_ACTIVE} AND expiry < {$current_time}");
// ==================================================
// Find all relevant sessions.
// ==================================================
$query = SQL_Query($mysql_database, "SELECT sid, ip, title, tslots, uslots, info " . "FROM matchmaking " . "WHERE gid = '{$gid}' " . "AND state = {$STATUS_ACTIVE} " . "AND expiry > {$current_time} " . "LIMIT {$limit}");
if (!$query) {
    Result_Error($ERROR_QUERY_FAILED);
}
$num_results = SQL_GetNumRows($query);
if (!$num_results) {
    Result_Error($ERROR_NO_RESULTS);
}
Result_Success();
Result_Value("results", $num_results);
$index = 0;
while ($row = SQL_FetchRow($query)) {
    Result_Value("sid:" . $index, $row['sid']);
    Result_Value("ip:" . $index, $row['ip']);
    Result_Value("title:" . $index, $row['title']);
    Result_Value("tslots:" . $index, $row['tslots']);
    Result_Value("uslots:" . $index, $row['uslots']);
    Result_Value("info:" . $index, $row['info']);
    $index++;
}
SQL_FreeQueryResult($query);