Changeset 1735

Show
Ignore:
Timestamp:
05/17/08 01:30:23 (8 months ago)
Author:
tinyau
Message:

Modified the SQL statements which valid for MySQL/SQLite/PostgreSQL.

Files:
1 modified

Legend:

Unmodified
Added
Removed

  • trunk/htdocs/system/classes/tags.php

    r1731 r1735  
    1515    public static function get() 
    1616    { 
    17         $tags= DB::get_results( 'SELECT t.id AS id, t.tag_text AS tag, t.tag_slug AS slug, COUNT(tp.tag_id) AS count FROM {tags} t INNER JOIN {tag2post} tp ON t.id=tp.tag_id GROUP BY tag, slug ORDER BY tag ASC' ); 
     17        $tags= DB::get_results( 'SELECT t.id AS id, t.tag_text AS tag, t.tag_slug AS slug, COUNT(tp.tag_id) AS count FROM {tags} t INNER JOIN {tag2post} tp ON t.id=tp.tag_id GROUP BY id, tag, slug ORDER BY tag ASC' ); 
    1818        return $tags; 
    1919    } 
    … …  
    2626    public static function get_one($tag) 
    2727    { 
    28         return DB::get_row( 'SELECT t.id AS id, t.tag_text AS tag, t.tag_slug AS slug, COUNT(tp.tag_id) AS count FROM {tags} t LEFT JOIN {tag2post} tp ON t.id=tp.tag_id WHERE tag_slug = ? OR t.id = ? GROUP BY id', array( Utils::slugify( $tag ), $tag ) ); 
     28        return DB::get_row( 'SELECT t.id AS id, t.tag_text AS tag, t.tag_slug AS slug, COUNT(tp.tag_id) AS count FROM {tags} t LEFT JOIN {tag2post} tp ON t.id=tp.tag_id WHERE tag_slug = ? OR t.id = ? GROUP BY id, tag, slug', array( Utils::slugify( $tag ), $tag ) ); 
    2929    } 
    3030 
    … …  
    108108     **/ 
    109109    public static function max_count() { 
    110         return DB::get_value( 'SELECT count( t2.post_id ) AS max FROM {tags} t, {tag2post} t2 WHERE t2.tag_id = t.id GROUP BY t.id ORDER BY count( t2.post_id ) DESC LIMIT 0, 1' ); 
     110        return DB::get_value( 'SELECT count( t2.post_id ) AS max FROM {tags} t, {tag2post} t2 WHERE t2.tag_id = t.id GROUP BY t.id ORDER BY count( t2.post_id ) DESC LIMIT 1' ); 
    111111    } 
    112112 
    … …  
    130130    public static function get_by_text($tag) 
    131131    { 
    132         return DB::get_row( 'SELECT t.id AS id, t.tag_text AS tag, t.tag_slug AS slug, COUNT(tp.tag_id) AS count FROM {tags} t INNER JOIN {tag2post} tp ON t.id=tp.tag_id WHERE tag_text = ? GROUP BY id', array($tag) ); 
     132        return DB::get_row( 'SELECT t.id AS id, t.tag_text AS tag, t.tag_slug AS slug, COUNT(tp.tag_id) AS count FROM {tags} t INNER JOIN {tag2post} tp ON t.id=tp.tag_id WHERE tag_text = ? GROUP BY id, tag, slug', array($tag) ); 
    133133    } 
    134134 
    135135    public static function get_by_slug($tag) 
    136136    { 
    137         return DB::get_row( 'SELECT t.id AS id, t.tag_text AS tag, t.tag_slug AS slug, COUNT(tp.tag_id) AS count FROM {tags} t INNER JOIN {tag2post} tp ON t.id=tp.tag_id WHERE tag_slug = ? GROUP BY id', array($tag) ); 
     137        return DB::get_row( 'SELECT t.id AS id, t.tag_text AS tag, t.tag_slug AS slug, COUNT(tp.tag_id) AS count FROM {tags} t INNER JOIN {tag2post} tp ON t.id=tp.tag_id WHERE tag_slug = ? GROUP BY id, tag, slug', array($tag) ); 
    138138    } 
    139139 
    140140    public static function get_by_id($tag) 
    141141    { 
    142         return DB::get_row( 'SELECT t.id AS id, t.tag_text AS tag, t.tag_slug AS slug, COUNT(tp.tag_id) AS count FROM {tags} t INNER JOIN {tag2post} tp ON t.id=tp.tag_id WHERE id = ? GROUP BY id', array($tag) ); 
     142        return DB::get_row( 'SELECT t.id AS id, t.tag_text AS tag, t.tag_slug AS slug, COUNT(tp.tag_id) AS count FROM {tags} t INNER JOIN {tag2post} tp ON t.id=tp.tag_id WHERE id = ? GROUP BY id, tag, slug', array($tag) ); 
    143143    } 
    144144}