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

Timestamp:

Oct 23, 2004, 7:56:46 PM (20 years ago)

Author:

z0rglub

Message:

• refactoring of comments.php

• creation of function get_thumbnail_src used everywhere a thumbnail must be displayed

• creation of function parse_comment_content (used in comments.php and picture.php)

• concerning undefined index on arrays retrieved in database, instead of testing possibly unset values, use of @ operator (smarter...)

• add pre tag in default.css stylesheet for debugging purpose (need to have left aligned text)

File:

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

trunk/include/functions_category.inc.php

@@ -346 +346 @@
 function get_complete_dir( $category_id )
 {
-  return get_site_url( $category_id ).get_local_dir( $category_id );
+  return get_site_url($category_id).get_local_dir($category_id);
 }
 
@@ -384 +384 @@
     $database_dirs[$row['id']] = $row['dir'];
   }
-  foreach ( $upper_array as $id ) {
+  foreach ($upper_array as $id)
+  {
     $local_dir.= $database_dirs[$id].'/';
   }
@@ -393 +394 @@
 // retrieving the site url : "http://domain.com/gallery/" or
 // simply "./galleries/"
-function get_site_url( $category_id )
+function get_site_url($category_id)
 {
   global $page;
 
-  $query = 'SELECT galleries_url';
-  $query.= ' FROM '.SITES_TABLE.' AS s,'.CATEGORIES_TABLE.' AS c';
-  $query.= ' WHERE s.id = c.site_id';
-  $query.= ' AND c.id = '.$category_id;
-  $query.= ';';
-  $row = mysql_fetch_array( mysql_query( $query ) );
+  $query = '
+SELECT galleries_url
+  FROM '.SITES_TABLE.' AS s,'.CATEGORIES_TABLE.' AS c
+  WHERE s.id = c.site_id
+    AND c.id = '.$category_id.'
+;';
+  $row = mysql_fetch_array(mysql_query($query));
   return $row['galleries_url'];
 }