Ejemplos de DB_FIELD_DATE en PHP

Ejemplo n.º 1

Archivo: theme_idea.php Proyecto: povrazor/ludumdare

function themeIdea_GetDetail($event_id, $user_id = 0, $threshold = null, $query_suffix = ";")
{
    if ($user_id) {
        return db_QueryFetch("SELECT id,theme,parent,user,score," . DB_FIELD_DATE('timestamp') . "\n\t\t\tFROM " . SH_TABLE_PREFIX . SH_TABLE_THEME_IDEA . " \n\t\t\tWHERE node=? AND user=?" . $query_suffix, $event_id, $user_id);
    } else {
        if (isset($threshold)) {
            return db_QueryFetch("SELECT id,theme,parent,user,score," . DB_FIELD_DATE('timestamp') . "\n\t\t\t\tFROM " . SH_TABLE_PREFIX . SH_TABLE_THEME_IDEA . " \n\t\t\t\tWHERE node=? AND score>=?" . $query_suffix, $event_id, $threshold);
        } else {
            return db_QueryFetch("SELECT id,theme,parent,user,score," . DB_FIELD_DATE('timestamp') . "\n\t\t\t\tFROM " . SH_TABLE_PREFIX . SH_TABLE_THEME_IDEA . " \n\t\t\t\tWHERE node=?" . $query_suffix, $event_id);
        }
    }
}

Ejemplo n.º 2

Archivo: user_core.php Proyecto: povrazor/ludumdare

function user_GetByMail($mail, $query_suffix = ";")
{
    $ret = db_QueryFetchFirst("SELECT id,node,mail," . DB_FIELD_DATE('created') . ",hash,HEX(secret) AS secret,auth_key," . DB_FIELD_DATE('last_auth') . "\n\t\tFROM " . SH_TABLE_PREFIX . SH_TABLE_USER . " \n\t\tWHERE mail=?\n\t\tLIMIT 1" . $query_suffix, $mail);
    return db_ParseRow($ret, _SH_USER_ROW_MAP);
}