Changeset 7066

Timestamp:

10/01/10 22:33:48 (3 years ago)

Author:

LucMorizur

Message:

[Event Cats] Remove all mysql_ instructions ; add <br /> into duplication.tpl

Location:

extensions/event_cats

Files:

• admin/autolog_entries.inc.php (modified) (1 diff)
• admin/template/duplication.tpl (modified) (7 diffs)
• include/ec_conf.inc.php (modified) (2 diffs)
• include/evntcats_admin_funcs.inc.php (modified) (6 diffs)
• include/evntcats_main_funcs.inc.php (modified) (6 diffs)
• main.inc.php (modified) (3 diffs)

extensions/event_cats/admin/autolog_entries.inc.php

@@ -104 +104 @@
           elseif ($a == 3) { // Image
             $url_end.= ($url_end == '') ? '' : '&img='.$arg2;
-            $t = mysql_fetch_row(pwg_query("
+            $t = pwg_db_fetch_row(pwg_query("
              SELECT `name`, `file`
              FROM `".IMAGES_TABLE."`

extensions/event_cats/admin/template/duplication.tpl

@@ -87 +87 @@
         </td>
       </tr>
-    </table>
+    </table><br />
     <input class = "submit" type = "submit" name = "ec_duplic_conf_submit" value = "{'Save dup. config btn'|@translate}" />
   </fieldset>
@@ -103 +103 @@
       <li><label><input type = "checkbox" name = "deny_groups[]" value = "{$id}" /> {$all_groups[$id]}</label></li>
       {/foreach}
-    </ul>
+    </ul><br />
     <input class = "submit" type = "submit" name = "deny_groups_submit" value = "{'Deny to groups btn'|@translate}" />
   </fieldset>
@@ -113 +113 @@
       <li><label><input type = "checkbox" name = "grant_groups[]" value = "{$id}"> {$all_groups[$id]}</label></li>
       {/foreach}
-    </ul>
+    </ul><br />
     <input class = "submit" type = "submit" name = "grant_groups_submit" value = "{'Grant to groups btn'|@translate}" />
   </fieldset>
@@ -129 +129 @@
         <li><label><input type = "checkbox" name = "deny_types[]" value = "{$id}" /> {$all_types[$id]}</label></li>
       {/foreach}
-    </ul>
+    </ul><br />
     <input class = "submit" type = "submit" name = "deny_types_submit" value = "{'Deny to types btn'|@translate}" />
   </fieldset>
@@ -143 +143 @@
         <li><label><input type = "checkbox" name = "grant_types[]" value = "{$id}" /> {$all_types[$id]}</label></li>
       {/foreach}
-    </ul>
+    </ul><br />
     <input class = "submit" type = "submit" name = "grant_types_submit" value = "{'Grant to types btn'|@translate}" />
   </fieldset>
@@ -155 +155 @@
       <li><label><input type = "checkbox" name = "deny_users[]" value = "{$id}" /> {$all_users[$id]}</label></li>
       {/foreach}
-    </ul>
+    </ul><br />
     <input class = "submit" type = "submit" name = "deny_users_submit" value = "{'Deny to users btn'|@translate}" />
   </fieldset>
@@ -176 +176 @@
       <li><label><input type = "checkbox" name = "grant_users[]" value = "{$id}"> {$all_users[$id]}</label></li>
       {/foreach}
-    </ul>
+    </ul><br />
     <input class = "submit" type = "submit" name = "grant_users_submit" value = "{'Grant to users btn'|@translate}" />
   </fieldset>

extensions/event_cats/include/ec_conf.inc.php

@@ -37 +37 @@
 // following instructions :
 /*
-$t = mysql_fetch_row(pwg_query("
+$t = pwg_db_fetch_row(pwg_query("
   SELECT `value`
   FROM `".CONFIG_TABLE."`
@@ -124 +124 @@
 $t = array(); $u = '0'; $v = false;
 if ($v = (
-  ($t = mysql_fetch_row(pwg_query("
+  ($t = pwg_db_fetch_row(pwg_query("
     SELECT `value`
     FROM `".CONFIG_TABLE."`

extensions/event_cats/include/evntcats_admin_funcs.inc.php

@@ -137 +137 @@
     $t2 = 0; $t3 = false; $t4 = false;
     while ( // The check is executed once at minimum
-      !($t3 = mysql_fetch_row(pwg_query("
+      !($t3 = pwg_db_fetch_row(pwg_query("
         SELECT `id`
         FROM `".GROUPS_TABLE."`
@@ -274 +274 @@
           AND `user_id` = '$ec_user_id';
       ");
-      while ($row = mysql_fetch_array($result))
+      while ($row = pwg_db_fetch_assoc($result))
        $granteds[$row['cat_id']][] = $row['user_id'];
       $inserts = array();
@@ -553 +553 @@
   $arg2p = ($arg2 == 'NULL') ? 'IS NULL' : ' = '.$arg2;
   $ec_user_idp = ($ec_user_id == 'NULL') ? 'IS NULL' : ' = '.$ec_user_id;
-  if (($t1 = mysql_fetch_row(pwg_query("
+  if (($t1 = pwg_db_fetch_row(pwg_query("
     SELECT `id`
     FROM `".EVNTCATS_TABLE."`
@@ -571 +571 @@
   if ($del_other) {
     if ((
-      $t1 = mysql_fetch_row(pwg_query("
+      $t1 = pwg_db_fetch_row(pwg_query("
         SELECT `code`
         FROM `".EVNTCATS_TABLE."`
@@ -583 +583 @@
        AND `id` <> ".$_POST['ec_entry_sel']
     );
-    while ($t2 = mysql_fetch_row($r)) if (!ec_delete_entry_OK($t2[0]))
+    while ($t2 = pwg_db_fetch_row($r)) if (!ec_delete_entry_OK($t2[0]))
      return false;
   }
@@ -662 +662 @@
 function ec_delete_entry_OK($ec_id) {
   global $page;
-  if (count($t = mysql_fetch_row(pwg_query("
+  if (count($t = pwg_db_fetch_row(pwg_query("
     SELECT `code`
     FROM `".EVNTCATS_TABLE."`

extensions/event_cats/include/evntcats_main_funcs.inc.php

@@ -77 +77 @@
  */
 function ec_image_exists($cat, $img) {
-  return (mysql_fetch_row(pwg_query("
+  return (pwg_db_fetch_row(pwg_query("
     SELECT *
     FROM `".IMAGE_CATEGORY_TABLE."` 
@@ -190 +190 @@
   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']);
@@ -264 +264 @@
     ORDER BY `id`
   ");
-  while ($r = mysql_fetch_assoc($q))
+  while ($r = pwg_db_fetch_assoc($q))
    $ec_lists['ec_table'][intval($r['id'])] = $r;
   
@@ -378 +378 @@
   // certain group (in groups, level (friends, family, contacts),
   // or user status (generic))
-  $types_entry_exists = (($t = mysql_fetch_row(pwg_query("
+  $types_entry_exists = (($t = pwg_db_fetch_row(pwg_query("
     SELECT `arg2`
     FROM `".EVNTCATS_TABLE."`
@@ -478 +478 @@
           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();
@@ -517 +517 @@
         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();

extensions/event_cats/main.inc.php

@@ -243 +243 @@
     ");
     $insert = array();
-    while ($row = mysql_fetch_assoc($result))
+    while ($row = pwg_db_fetch_assoc($result))
      $insert[] = "(".$new_user['id'].",".$row['cat_id'].")";
     if (!empty($insert)) pwg_query("
@@ -257 +257 @@
     ");
     $insert = array();
-    while ($row = mysql_fetch_assoc($result))
+    while ($row = pwg_db_fetch_assoc($result))
      $insert[] = "(".$new_user['id'].",".$row['group_id'].")";
     if (!empty($insert)) pwg_query("
@@ -271 +271 @@
     ");
     $insert = array();
-    while ($row = mysql_fetch_assoc($result))
+    while ($row = pwg_db_fetch_assoc($result))
      $insert[] = "(".$new_user['id'].",".$row['level'].")";
     if (!empty($insert)) pwg_query("