Changeset 21652 for extensions/event_cats/include/evntcats_main_funcs.inc.php

Timestamp:

Mar 17, 2013, 3:55:39 PM (11 years ago)

Author:

mistic100

Message:

replace mysql_* by pwg_db_* and correct errors inherited by mysql return values

File:

• extensions/event_cats/include/evntcats_main_funcs.inc.php (modified) (7 diffs)

extensions/event_cats/include/evntcats_main_funcs.inc.php

@@ -77 +77 @@
  */
 function ec_image_exists($cat, $img) {
-  return (mysql_fetch_row(pwg_query("
+  $r = pwg_query("
     SELECT *
     FROM `".IMAGE_CATEGORY_TABLE."` 
     WHERE `category_id` = ".$cat."
      AND `image_id` = ".$img
-  )) !== false);
+  );
+  return (bool)pwg_num_rows($r);
 }
 
@@ -207 +208 @@
   if (defined('ADD_PAGES_TABLE')) {
     $res = pwg_query("SELECT `id`, `title` FROM `".ADD_PAGES_TABLE."`;");
-    while ($r = mysql_fetch_array($res)) {
+    while ($r = pwg_db_fetch_assoc($res)) {
       $a = (is_in($r['title'], '/user_id=')) ?
        explode('/user_id=' , $r['title']) : array($r['title']);
@@ -281 +282 @@
     ORDER BY `id`
   ");
-  while ($r = mysql_fetch_assoc($q))
+  while ($r = pwg_db_fetch_assoc($q))
    $ec_lists['ec_table'][intval($r['id'])] = $r;
   
@@ -395 +396 @@
   // certain group (in groups, level (friends, family, contacts),
   // or user status (generic))
-  $types_entry_exists = (($t = mysql_fetch_row(pwg_query("
+  $r = pwg_query("
     SELECT `arg2`
     FROM `".EVNTCATS_TABLE."`
@@ -402 +403 @@
       AND `arg2` IS NOT NULL
     LIMIT 1;
-  "))) !== false);
-  $ec_lists['types_granted'] = ($types_entry_exists) ? $t[0] : 0;
+  ");
+  if (pwg_db_num_rows($r)) {
+    $types_entry_exists = true;
+    list($ec_lists['types_granted']) = pwg_db_fetch_row($r);
+  }
+  else {
+    $types_entry_exists = false;
+    $ec_lists['types_granted'] = 0;
+  }
   
   return $types_entry_exists;
@@ -495 +503 @@
           AND `user_id` > 2;
       ");
-      while ($row = mysql_fetch_array($result)) {
+      while ($row = pwg_db_fetch_assoc($result)) {
         if (!isset($user_granted_from_type[$row['level']])) {
           $user_granted_from_type[$row['level']] = array();
@@ -534 +542 @@
         AND `user_id` > 2;
     ");
-    while ($row = mysql_fetch_array($result)) {
+    while ($row = pwg_db_fetch_assoc($result)) {
       if (!isset($granted_groups[$row['group_id']])) {
         $granted_groups[$row['group_id']] = array();