Changeset 7066


Ignore:
Timestamp:
Oct 1, 2010, 10:33:48 PM (10 years ago)
Author:
LucMorizur
Message:

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

Location:
extensions/event_cats
Files:
6 edited

Legend:

Unmodified
Added
Removed
  • extensions/event_cats/admin/autolog_entries.inc.php

    r4470 r7066  
    104104          elseif ($a == 3) { // Image
    105105            $url_end.= ($url_end == '') ? '' : '&amp;img='.$arg2;
    106             $t = mysql_fetch_row(pwg_query("
     106            $t = pwg_db_fetch_row(pwg_query("
    107107             SELECT `name`, `file`
    108108             FROM `".IMAGES_TABLE."`
  • extensions/event_cats/admin/template/duplication.tpl

    r6269 r7066  
    8787        </td>
    8888      </tr>
    89     </table>
     89    </table><br />
    9090    <input class = "submit" type = "submit" name = "ec_duplic_conf_submit" value = "{'Save dup. config btn'|@translate}" />
    9191  </fieldset>
     
    103103      <li><label><input type = "checkbox" name = "deny_groups[]" value = "{$id}" /> {$all_groups[$id]}</label></li>
    104104      {/foreach}
    105     </ul>
     105    </ul><br />
    106106    <input class = "submit" type = "submit" name = "deny_groups_submit" value = "{'Deny to groups btn'|@translate}" />
    107107  </fieldset>
     
    113113      <li><label><input type = "checkbox" name = "grant_groups[]" value = "{$id}"> {$all_groups[$id]}</label></li>
    114114      {/foreach}
    115     </ul>
     115    </ul><br />
    116116    <input class = "submit" type = "submit" name = "grant_groups_submit" value = "{'Grant to groups btn'|@translate}" />
    117117  </fieldset>
     
    129129        <li><label><input type = "checkbox" name = "deny_types[]" value = "{$id}" /> {$all_types[$id]}</label></li>
    130130      {/foreach}
    131     </ul>
     131    </ul><br />
    132132    <input class = "submit" type = "submit" name = "deny_types_submit" value = "{'Deny to types btn'|@translate}" />
    133133  </fieldset>
     
    143143        <li><label><input type = "checkbox" name = "grant_types[]" value = "{$id}" /> {$all_types[$id]}</label></li>
    144144      {/foreach}
    145     </ul>
     145    </ul><br />
    146146    <input class = "submit" type = "submit" name = "grant_types_submit" value = "{'Grant to types btn'|@translate}" />
    147147  </fieldset>
     
    155155      <li><label><input type = "checkbox" name = "deny_users[]" value = "{$id}" /> {$all_users[$id]}</label></li>
    156156      {/foreach}
    157     </ul>
     157    </ul><br />
    158158    <input class = "submit" type = "submit" name = "deny_users_submit" value = "{'Deny to users btn'|@translate}" />
    159159  </fieldset>
     
    176176      <li><label><input type = "checkbox" name = "grant_users[]" value = "{$id}"> {$all_users[$id]}</label></li>
    177177      {/foreach}
    178     </ul>
     178    </ul><br />
    179179    <input class = "submit" type = "submit" name = "grant_users_submit" value = "{'Grant to users btn'|@translate}" />
    180180  </fieldset>
  • extensions/event_cats/include/ec_conf.inc.php

    r4553 r7066  
    3737// following instructions :
    3838/*
    39 $t = mysql_fetch_row(pwg_query("
     39$t = pwg_db_fetch_row(pwg_query("
    4040  SELECT `value`
    4141  FROM `".CONFIG_TABLE."`
     
    124124$t = array(); $u = '0'; $v = false;
    125125if ($v = (
    126   ($t = mysql_fetch_row(pwg_query("
     126  ($t = pwg_db_fetch_row(pwg_query("
    127127    SELECT `value`
    128128    FROM `".CONFIG_TABLE."`
  • extensions/event_cats/include/evntcats_admin_funcs.inc.php

    r4472 r7066  
    137137    $t2 = 0; $t3 = false; $t4 = false;
    138138    while ( // The check is executed once at minimum
    139       !($t3 = mysql_fetch_row(pwg_query("
     139      !($t3 = pwg_db_fetch_row(pwg_query("
    140140        SELECT `id`
    141141        FROM `".GROUPS_TABLE."`
     
    274274          AND `user_id` = '$ec_user_id';
    275275      ");
    276       while ($row = mysql_fetch_array($result))
     276      while ($row = pwg_db_fetch_assoc($result))
    277277       $granteds[$row['cat_id']][] = $row['user_id'];
    278278      $inserts = array();
     
    553553  $arg2p = ($arg2 == 'NULL') ? 'IS NULL' : ' = '.$arg2;
    554554  $ec_user_idp = ($ec_user_id == 'NULL') ? 'IS NULL' : ' = '.$ec_user_id;
    555   if (($t1 = mysql_fetch_row(pwg_query("
     555  if (($t1 = pwg_db_fetch_row(pwg_query("
    556556    SELECT `id`
    557557    FROM `".EVNTCATS_TABLE."`
     
    571571  if ($del_other) {
    572572    if ((
    573       $t1 = mysql_fetch_row(pwg_query("
     573      $t1 = pwg_db_fetch_row(pwg_query("
    574574        SELECT `code`
    575575        FROM `".EVNTCATS_TABLE."`
     
    583583       AND `id` <> ".$_POST['ec_entry_sel']
    584584    );
    585     while ($t2 = mysql_fetch_row($r)) if (!ec_delete_entry_OK($t2[0]))
     585    while ($t2 = pwg_db_fetch_row($r)) if (!ec_delete_entry_OK($t2[0]))
    586586     return false;
    587587  }
     
    662662function ec_delete_entry_OK($ec_id) {
    663663  global $page;
    664   if (count($t = mysql_fetch_row(pwg_query("
     664  if (count($t = pwg_db_fetch_row(pwg_query("
    665665    SELECT `code`
    666666    FROM `".EVNTCATS_TABLE."`
  • extensions/event_cats/include/evntcats_main_funcs.inc.php

    r4486 r7066  
    7777 */
    7878function ec_image_exists($cat, $img) {
    79   return (mysql_fetch_row(pwg_query("
     79  return (pwg_db_fetch_row(pwg_query("
    8080    SELECT *
    8181    FROM `".IMAGE_CATEGORY_TABLE."`
     
    190190  if (defined('ADD_PAGES_TABLE')) {
    191191    $res = pwg_query("SELECT `id`, `title` FROM `".ADD_PAGES_TABLE."`;");
    192     while ($r = mysql_fetch_array($res)) {
     192    while ($r = pwg_db_fetch_assoc($res)) {
    193193      $a = (is_in($r['title'], '/user_id=')) ?
    194194       explode('/user_id=' , $r['title']) : array($r['title']);
     
    264264    ORDER BY `id`
    265265  ");
    266   while ($r = mysql_fetch_assoc($q))
     266  while ($r = pwg_db_fetch_assoc($q))
    267267   $ec_lists['ec_table'][intval($r['id'])] = $r;
    268268 
     
    378378  // certain group (in groups, level (friends, family, contacts),
    379379  // or user status (generic))
    380   $types_entry_exists = (($t = mysql_fetch_row(pwg_query("
     380  $types_entry_exists = (($t = pwg_db_fetch_row(pwg_query("
    381381    SELECT `arg2`
    382382    FROM `".EVNTCATS_TABLE."`
     
    478478          AND `user_id` > 2;
    479479      ");
    480       while ($row = mysql_fetch_array($result)) {
     480      while ($row = pwg_db_fetch_assoc($result)) {
    481481        if (!isset($user_granted_from_type[$row['level']])) {
    482482          $user_granted_from_type[$row['level']] = array();
     
    517517        AND `user_id` > 2;
    518518    ");
    519     while ($row = mysql_fetch_array($result)) {
     519    while ($row = pwg_db_fetch_assoc($result)) {
    520520      if (!isset($granted_groups[$row['group_id']])) {
    521521        $granted_groups[$row['group_id']] = array();
  • extensions/event_cats/main.inc.php

    r7064 r7066  
    243243    ");
    244244    $insert = array();
    245     while ($row = mysql_fetch_assoc($result))
     245    while ($row = pwg_db_fetch_assoc($result))
    246246     $insert[] = "(".$new_user['id'].",".$row['cat_id'].")";
    247247    if (!empty($insert)) pwg_query("
     
    257257    ");
    258258    $insert = array();
    259     while ($row = mysql_fetch_assoc($result))
     259    while ($row = pwg_db_fetch_assoc($result))
    260260     $insert[] = "(".$new_user['id'].",".$row['group_id'].")";
    261261    if (!empty($insert)) pwg_query("
     
    271271    ");
    272272    $insert = array();
    273     while ($row = mysql_fetch_assoc($result))
     273    while ($row = pwg_db_fetch_assoc($result))
    274274     $insert[] = "(".$new_user['id'].",".$row['level'].")";
    275275    if (!empty($insert)) pwg_query("
Note: See TracChangeset for help on using the changeset viewer.