Changeset 10 for trunk/category.php


Ignore:
Timestamp:
May 17, 2003, 12:49:14 PM (22 years ago)
Author:
z0rglub
Message:

* empty log message *

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/category.php

    r9 r10  
    5454  $page['tab_expand'] = array();
    5555  $query = 'select id';
    56   $query.= ' from '.$prefixeTable.'categories';
     56  $query.= ' from '.PREFIX_TABLE.'categories';
    5757  $query.= ' where id_uppercat is null;';
    5858  $result = mysql_query( $query );
     
    126126  // searching the number of favorite picture
    127127  $query = 'select count(*) as count';
    128   $query.= ' from '.$prefixeTable.'favorites';
     128  $query.= ' from '.PREFIX_TABLE.'favorites';
    129129  $query.= ' where user_id = '.$user['id'].';';
    130130  $result = mysql_query( $query );
     
    241241  $query = 'select id,file,date_available,comment,';
    242242  $query.= ' author,tn_ext,name,filesize,width,height,cat_id';
    243   $query.= ' from '.$prefixeTable.'images';
     243  $query.= ' from '.PREFIX_TABLE.'images';
    244244  $query.= $page['where'];
    245245  $query.= $conf['order_by'];
     
    340340      $vtp->addSession( $handle, 'nb_comments' );
    341341      $query = 'select count(*) as nb_comments';
    342       $query.= ' from '.$prefixeTable.'comments';
     342      $query.= ' from '.PREFIX_TABLE.'comments';
    343343      $query.= ' where image_id = '.$row['id'];
    344344      $query.= ';';
     
    374374 
    375375  $query = 'select id,name,dir,date_dernier';
    376   $query.= ' from '.$prefixeTable.'categories';
     376  $query.= ' from '.PREFIX_TABLE.'categories';
    377377  $query.= ' where id_uppercat = '.$page['cat'];
    378378  $query.= ' order by rank;';
     
    398398   
    399399    $query = 'select file,tn_ext';
    400     $query.= ' from '.$prefixeTable.'images';
     400    $query.= ' from '.PREFIX_TABLE.'images';
    401401    $query.= ' where cat_id = '.$cat_row['id'];
    402402    $query.= ' order by rand()';
Note: See TracChangeset for help on using the changeset viewer.