PHP RedeemedCode::get_by_sql Examples

Example #1

File: redeemed_codes_xml.php Project: NemOry/KellyEscapeGameWebPanel

    if ($searchOper == 'eq') {
        $searchString = $searchString;
    }
    if ($searchOper == 'bw' || $searchOper == 'bn') {
        $searchString .= '%';
    }
    if ($searchOper == 'ew' || $searchOper == 'en') {
        $searchString = '%' . $searchString;
    }
    if ($searchOper == 'cn' || $searchOper == 'nc' || $searchOper == 'in' || $searchOper == 'ni') {
        $searchString = '%' . $searchString . '%';
    }
    $where = "{$searchField} {$ops} '{$searchString}'";
    $redeemed_codes = RedeemedCode::get_by_sql("SELECT * FROM " . T_REDEEMED_CODES . " WHERE " . $where . " ORDER BY {$sidx} {$sord} LIMIT {$start} , {$limit}");
} else {
    $redeemed_codes = RedeemedCode::get_by_sql("SELECT * FROM " . T_REDEEMED_CODES . " ORDER BY {$sidx} {$sord} LIMIT {$start} , {$limit}");
}
header("Content-type: text/xml;charset=utf-8");
$s = "<?xml version='1.0' encoding='utf-8'?>";
$s .= "<rows>";
$s .= "<page>" . $page . "</page>";
$s .= "<total>" . $total_pages . "</total>";
$s .= "<records>" . $count . "</records>";
foreach ($redeemed_codes as $redeemed_code) {
    $s .= "<row id='" . $redeemed_code->id . "'>";
    $s .= "<cell></cell>";
    $s .= "<cell>" . $redeemed_code->code_id . "</cell>";
    $s .= "<cell>" . Code::get_by_id($redeemed_code->code_id)->code . "</cell>";
    $s .= "<cell>" . Code::get_by_id($redeemed_code->code_id)->item . "</cell>";
    $s .= "<cell>" . Code::get_by_id($redeemed_code->code_id)->value . "</cell>";
    $s .= "<cell>" . Code::get_by_id($redeemed_code->code_id)->message . "</cell>";