Changeset 587 for trunk/picture.php

Timestamp:

Oct 30, 2004, 5:42:29 PM (20 years ago)

Author:

z0rglub

Message:

• function mysql_query replaced by pwg_query : the same with debugging features

• by default, DEBUG is set to 0 (off)

File:

• trunk/picture.php (modified) (19 diffs)

trunk/picture.php

@@ -38 +38 @@
 }
 //---------------------------------------- incrementation of the number of hits
-$query = 'UPDATE '.IMAGES_TABLE.' SET hit=hit+1';
-$query.= ' WHERE id='.$_GET['image_id'];
-$query.= ';';
-@mysql_query( $query );
+$query = '
+UPDATE '.IMAGES_TABLE.'
+  SET hit = hit+1
+  WHERE id = '.$_GET['image_id'].'
+;';
+@pwg_query( $query );
 //-------------------------------------------------------------- initialization
 initialize_category( 'picture' );
@@ -52 +54 @@
   '.$conf['order_by'].'
 ;';
-$result = mysql_query( $query );
+$result = pwg_query( $query );
 $page['num'] = 0;
 $belongs = false;
@@ -112 +114 @@
 $query.= ';';
 
-$result = mysql_query( $query );
+$result = pwg_query( $query );
 $indexes = array('prev', 'current', 'next');
 
@@ -226 +228 @@
     AND element_id = '.$_GET['image_id'].'
 ;';
-  mysql_query($query);
+  pwg_query($query);
   $query = '
 INSERT INTO '.RATE_TABLE.'
@@ -233 +235 @@
   ('.$user['id'].','.$_GET['image_id'].','.$_GET['rate'].')
 ;';
-  mysql_query($query);
+  pwg_query($query);
 
   // update of images.average_rate field
@@ -241 +243 @@
   WHERE element_id = '.$_GET['image_id'].'
 ;';
-  $row = mysql_fetch_array(mysql_query($query));
+  $row = mysql_fetch_array(pwg_query($query));
   $query = '
 UPDATE '.IMAGES_TABLE.'
@@ -247 +249 @@
   WHERE id = '.$_GET['image_id'].'
 ;';
-  mysql_query($query);
+  pwg_query($query);
 }
 //--------------------------------------------------------- favorite management
@@ -256 +258 @@
   $query.= ' AND image_id = '.$picture['current']['id'];
   $query.= ';';
-  $result = mysql_query( $query );
+  $result = pwg_query( $query );
   
   if ( $_GET['add_fav'] == 1 )
@@ -264 +266 @@
     $query.= ' ('.$picture['current']['id'].','.$user['id'].')';
     $query.= ';';
-    $result = mysql_query( $query );
+    $result = pwg_query( $query );
   }
   if ( !$_GET['add_fav'] and $page['cat'] == 'fav' )
@@ -302 +304 @@
     $query.= " WHERE username = '".$author."'";
     $query.= ';';
-    $row = mysql_fetch_array( mysql_query( $query ) );
+    $row = mysql_fetch_array( pwg_query( $query ) );
     if ( $row['user_exists'] == 1 )
     {
@@ -320 +322 @@
     $query.= " AND author = '".$author."'";
     $query.= ';';
-    if ( mysql_num_rows( mysql_query( $query ) ) == 0
+    if ( mysql_num_rows( pwg_query( $query ) ) == 0
          or $conf['anti-flood_time'] == 0 )
     {
@@ -337 +339 @@
       }
       $query.= ');';
-      mysql_query( $query );
+      pwg_query( $query );
       // information message
       $message = $lang['comment_added'];
@@ -371 +373 @@
   $query.= ' WHERE id = '.$_GET['del'];
   $query.= ';';
-  mysql_query( $query );
+  pwg_query( $query );
 }
 
@@ -503 +505 @@
   $query.= ' FROM '.FAVORITES_TABLE.' WHERE image_id = '.$_GET['image_id'];
   $query.= ' AND user_id = '.$user['id'].';';
-  $result = mysql_query( $query );
+  $result = pwg_query( $query );
   $row = mysql_fetch_array( $result );
   if (!$row['nb_fav'])
@@ -713 +715 @@
   WHERE element_id = '.$picture['current']['id'].'
 ;';
-  $row = mysql_fetch_array(mysql_query($query));
+  $row = mysql_fetch_array(pwg_query($query));
   if ($row['count'] == 0)
   {
@@ -746 +748 @@
 $query.= '
 ;';
-$result = mysql_query($query);
+$result = pwg_query($query);
 $categories = '';
 while ($row = mysql_fetch_array($result))
@@ -871 +873 @@
     AND element_id = '.$_GET['image_id'].'
 ;';
-  $result = mysql_query($query);
+  $result = pwg_query($query);
   if (mysql_num_rows($result) > 0)
   {
@@ -922 +924 @@
   $query.= " AND validated = 'true'";
   $query.= ';';
-  $row = mysql_fetch_array( mysql_query( $query ) );
+  $row = mysql_fetch_array( pwg_query( $query ) );
   
   // navigation bar creation
@@ -951 +953 @@
   $query.= ' ORDER BY date ASC';
   $query.= ' LIMIT '.$page['start'].', '.$conf['nb_comment_page'].';';
-  $result = mysql_query( $query );
+  $result = pwg_query( $query );
                 
   while ( $row = mysql_fetch_array( $result ) )