PHP sql_db::sql_return_on_error示例

        $sql = "UPDATE " . PREFIX . "config SET\n\t\t\t\tconfig_value = '" . $db->sql_escape($HTTP_POST_VARS['server_port']) . "'\n\t\t\t\tWHERE config_name = 'server_port'";
        $result = $db->sql_query($sql);
        $sql = "UPDATE " . PREFIX . "config SET\n\t\t\t\tconfig_value = '" . $db->sql_escape($HTTP_POST_VARS['script_path']) . "'\n\t\t\t\tWHERE config_name = 'script_path'";
        $result = $db->sql_query($sql);
        $sql = "UPDATE " . PREFIX . "config SET\n\t\t\t\tconfig_value = '" . $db->sql_escape($HTTP_POST_VARS['session_length']) . "'\n\t\t\t\tWHERE config_name = 'session_length'";
        $result = $db->sql_query($sql);
        $template->assign_block_vars('ok', array());
    }
}
/*
 * Load backup status
 */
$save_status = '';
$saved_now = false;
$sql = 'SELECT * FROM ' . PREFIX . 'ctracker_backup WHERE config_name = \'ct_last_backup\'';
$db->sql_return_on_error(true);
$result = $db->sql_query($sql);
$db->sql_return_on_error(false);
if (!$result) {
    $save_status = 'no configuration backup available';
} else {
    $saved_now = true;
    while ($row = $db->sql_fetchrow($result)) {
        $backup[$row['config_name']] = $row['config_value'];
    }
    $save_status = gmdate('d.m.Y - H:i', $backup['ct_last_backup']);
}
/*
* Send some vars to the template
*/
$template->assign_vars(array('YEAR' => date(Y), 'BACKUP' => $save_status, 'PHP_EXT' => PHP_EXT, 'RESTORE_OUTPUT' => $saved_now ? '<a href="emergency.php?mode=restore" style="color:#FDFF00">&raquo; Click here to restore configuration table now! &laquo;</a>' : ''));