| 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 |
| 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) { |
| 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) { |