Serendipity Forums

Code: Select all

    $query = "UPDATE {$serendipity['dbPrefix']}entries SET $field=$field+1, last_modified=". $lm ." WHERE id='". (int)$entry_id ."'";

Code: Select all

    if ( $rs === false ) {
        return false;
    }

Code: Select all

SELECT c.*, e.title, a.email as authoremail, a.mail_comments, e.timestamp AS entry_timestamp, e.last_modified AS entry_last_modified
                FROM adamgre_bluegarterDbcomments c
                LEFT JOIN adamgre_bluegarterDbentries e ON (e.id = c.entry_id)
                LEFT JOIN adamgre_bluegarterDbauthors a ON (e.authorid = a.authorid)
                WHERE c.id = '9345289'

Code: Select all

        $cid = serendipity_db_insert_id('comments', 'id');

Code: Select all

SELECT currval('adamgre_bluegarterDbcomments_id_seq'::text) AS id

Code: Select all

SELECT max(id) from adamgre_bluegarterdbcomments

or if this function is supposed to show the next available id:
SELECT max(id) + 1 from adamgre_bluegarterdbcomments

Code: Select all

function serendipity_db_insert_id($table = '', $id = '') {
    global $serendipity;
    if (empty($table) || empty($id)) {
        // BC - will/should never be called with empty parameters!
        return pg_last_oid($serendipity['dbLastResult']);
    } else {
        //$query = "SELECT currval('{$serendipity['dbPrefix']}{$table}_{$id}_seq'::text) AS {$id}";
        $query = "SELECT max({$id}) as {$id} from {$serendipity['dbPrefix']}{$table}";
        if($res === false){
            return pg_last_oid($serendipity['dbLastResult']); // BC - should not happen!
        } else {
            $insert_id = pg_fetch_array($res, 0, PGSQL_ASSOC);
            return $insert_id[$id];
        }
    }
}