Changeset 13 for trunk/include/functions_category.inc.php

Timestamp:

May 17, 2003, 1:42:03 PM (21 years ago)

Author:

z0rglub

Message:

* empty log message *

File:

• trunk/include/functions_category.inc.php (modified) (13 diffs)

trunk/include/functions_category.inc.php

@@ -17 +17 @@
 function get_subcats_id( $cat_id )
 {
-  global $prefixeTable;
-                
   $restricted_cat = array();
   $i = 0;
                 
-  $query = "select id";
-  $query.= " from $prefixeTable"."categories";
-  $query.= " where id_uppercat = $cat_id;";
+  $query = 'select id';
+  $query.= ' from '.PREFIX_TABLE.'categories';
+  $query.= ' where id_uppercat = '.$cat_id;
+  $query.= ';';
   $result = mysql_query( $query );
   while ( $row = mysql_fetch_array( $result ) )
@@ -41 +40 @@
 function check_restrictions( $category_id )
 {
-  global $user,$lang,$prefixeTable;
+  global $user,$lang;
 
   if ( is_user_allowed( $category_id, $user['restrictions'] ) > 0 )
@@ -58 +57 @@
 function check_cat_id( $cat )
 {
-  global $page,$prefixeTable;
+  global $page;
+
   unset( $page['cat'] );
   if ( isset( $cat ) )
@@ -64 +64 @@
     if ( is_numeric( $cat ) )
     {
-      $query = "select id from $prefixeTable"."categories where id = $cat;";
+      $query = 'select id';
+      $query.= ' from '.PREFIX_TABLE.'categories';
+      $query.= ' where id = '.$cat;
+      $query. ';';
       $result = mysql_query( $query );
       if ( mysql_num_rows( $result ) != 0 )
@@ -81 +84 @@
 function display_cat( $id_uppercat, $indent, $restriction, $tab_expand )
 {
-  global $prefixeTable,$user,$lang,$conf,$page,$vtp,$handle;
+  global $user,$lang,$conf,$page,$vtp,$handle;
   
   $query = 'select name,id,date_dernier,nb_images,dir';
-  $query.= ' from '.$prefixeTable.'categories';
+  $query.= ' from '.PREFIX_TABLE.'categories';
   $query.= ' where id_uppercat';
   if ( $id_uppercat == "" )
@@ -202 +205 @@
 function get_nb_subcats( $id )
 {
-  global $prefixeTable,$user;
+  global $user;
                 
   $query = 'select count(*) as count';
-  $query.= ' from '.$prefixeTable.'categories';
+  $query.= ' from '.PREFIX_TABLE.'categories';
   $query.= ' where id_uppercat = '.$id;
   for ( $i = 0; $i < sizeof( $user['restrictions'] ); $i++ )
@@ -219 +222 @@
 function get_total_image( $id, $restriction )
 {
-  global $prefixeTable;
-                
   $total = 0;
                 
   $query = 'select id,nb_images';
-  $query.= ' from '.$prefixeTable.'categories';
+  $query.= ' from '.PREFIX_TABLE.'categories';
   $query.= ' where id_uppercat';
   if ( !is_numeric( $id ) )
@@ -260 +261 @@
 function get_cat_info( $id )
 {
-  global $prefixeTable;
-                
   $cat = array();
   $cat['name'] = array();
                 
   $query = 'select nb_images,id_uppercat,comment,site_id,galleries_url,dir';
-  $query.= ' from '.$prefixeTable.'categories as a';
-  $query.= ', '.$prefixeTable.'sites as b';
+  $query.= ' from '.PREFIX_TABLE.'categories as a';
+  $query.= ', '.PREFIX_TABLE.'sites as b';
   $query.= ' where a.id = '.$id;
   $query.= ' and a.site_id = b.id;';
@@ -285 +284 @@
   {
     $query = 'select name,dir,id_uppercat';
-    $query.= ' from '.$prefixeTable.'categories';
+    $query.= ' from '.PREFIX_TABLE.'categories';
     $query.= ' where id = '.$row['id_uppercat'].';';
     $row = mysql_fetch_array( mysql_query( $query ) );
@@ -360 +359 @@
 function initialize_category( $calling_page = 'category' )
 {
-  global $prefixeTable,$page,$lang,$user,$conf;
+  global $page,$lang,$user,$conf;
   
   if ( isset( $page['cat'] ) )
@@ -398 +397 @@
 
         $query = 'select count(*) as nb_total_images';
-        $query.= ' from '.$prefixeTable.'images';
+        $query.= ' from '.PREFIX_TABLE.'images';
         $query.= $page['where'];
         $query.= ';';
@@ -409 +408 @@
         $page['title'] = $lang['favorites'];
 
-        $page['where'] = ', '.$prefixeTable.'favorites';
+        $page['where'] = ', '.PREFIX_TABLE.'favorites';
         $page['where'].= ' where user_id = '.$user['id'];
         $page['where'].= ' and image_id = id';
       
         $query = 'select count(*) as nb_total_images';
-        $query.= ' from '.$prefixeTable.'favorites';
+        $query.= ' from '.PREFIX_TABLE.'favorites';
         $query.= ' where user_id = '.$user['id'];
         $query.= ';';
@@ -429 +428 @@
 
         $query = 'select count(*) as nb_total_images';
-        $query.= ' from '.$prefixeTable.'images';
+        $query.= ' from '.PREFIX_TABLE.'images';
         $query.= $page['where'];
         $query.= ';';