/[drupal]/contributions/modules/roledelay/roledelay.module
ViewVC logotype

Diff of /contributions/modules/roledelay/roledelay.module

Parent Directory Parent Directory | Revision Log Revision Log | View Revision Graph Revision Graph | View Patch Patch

revision 1.3, Wed Jul 26 16:36:09 2006 UTC revision 1.3.2.1, Wed May 14 00:26:45 2008 UTC
# Line 1  Line 1 
1  <?php  <?php
2  // $Id$  // $Id: roledelay.module,v 1.3 2006/07/26 16:36:09 handelaar Exp $
3    
4  /**  /**
5   * hook_settings() implementation   * hook_settings() implementation
# Line 104  function roledelay_cron() { Line 104  function roledelay_cron() {
104      $role = variable_get('roledelay_role1', 'none');      $role = variable_get('roledelay_role1', 'none');
105    
106      // we use time() here because we store the wait timestamp value in the db, not the created timestamp      // we use time() here because we store the wait timestamp value in the db, not the created timestamp
107      $results = db_query("SELECT u.name, r.* FROM {roledelay1} r LEFT JOIN {users} u ON u.uid = r.uid WHERE waitstamp < %d", time());      $results = db_query("SELECT u.name, r.* FROM {roledelay1} r LEFT JOIN {users} u ON u.uid = r.uid WHERE waitstamp < %d AND u.uid != 0", time());
108      while($u = db_fetch_object($results)) {      while($u = db_fetch_object($results)) {
109        $count = db_fetch_object(db_query("SELECT count(*) AS count FROM {users_roles} WHERE uid = %d AND rid = %d", $u->uid, $role));        $count = db_fetch_object(db_query("SELECT count(*) AS count FROM {users_roles} WHERE uid = %d AND rid = %d", $u->uid, $role));
110        if(!$count->count) {        if(!$count->count) {
# Line 119  function roledelay_cron() { Line 119  function roledelay_cron() {
119      // process the second stage if we have the second role delay stage setup      // process the second stage if we have the second role delay stage setup
120      if(variable_get('roledelay_role2', 'none') != 'none') {      if(variable_get('roledelay_role2', 'none') != 'none') {
121        $role = variable_get('roledelay_role2', 'none');        $role = variable_get('roledelay_role2', 'none');
122        $results = db_query("SELECT u.name, r.* FROM {roledelay2} r LEFT JOIN {users} u ON u.uid = r.uid WHERE waitstamp < %d", time());        $results = db_query("SELECT u.name, r.* FROM {roledelay2} r LEFT JOIN {users} u ON u.uid = r.uid WHERE waitstamp < %d AND u.uid != 0", time());
123        while($u = db_fetch_object($results)) {        while($u = db_fetch_object($results)) {
124          $count = db_fetch_object(db_query("SELECT count(*) AS count FROM {users_roles} WHERE uid = %d AND rid = %d", $u->uid, $role));          $count = db_fetch_object(db_query("SELECT count(*) AS count FROM {users_roles} WHERE uid = %d AND rid = %d", $u->uid, $role));
125          if(!$count->count) {          if(!$count->count) {

Legend:
Removed from v.1.3  
changed lines
  Added in v.1.3.2.1

  ViewVC Help
Powered by ViewVC 1.1.2