- Timestamp:
- Dec 10, 2010, 5:48:18 PM (13 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
extensions/NBC_UserAdvManager/trunk/include/functions.inc.php
r8065 r8072 363 363 $page['filtered_users'] = get_ghosts_autotasks(); 364 364 365 // Ghost accounts auto deletion366 if ((isset($conf_UAM[22]) and $conf_UAM[22] == 'true') and (isset($conf_UAM[23]) and $conf_UAM[23] == 'true'))367 365 { 368 366 foreach($page['filtered_users'] as $listed_user) … … 1426 1424 * @param : User id 1427 1425 * 1428 * @return : Bool1429 *1430 1426 */ 1431 1427 function ForceValidation($id) … … 1436 1432 1437 1433 $conf_UAM = unserialize($conf['UserAdvManager']); 1438 1439 $query = " 1440 SELECT COUNT(*) 1441 FROM ".USER_CONFIRM_MAIL_TABLE." 1442 WHERE user_id = '".$id."' 1443 ;"; 1444 list($count) = pwg_db_fetch_row(pwg_query($query)); 1445 1446 if ($count == 1) 1447 { 1448 $query = " 1449 SELECT user_id, status, date_check 1450 FROM ".USER_CONFIRM_MAIL_TABLE." 1451 WHERE user_id = '".$id."' 1452 ;"; 1453 $data = pwg_db_fetch_assoc(pwg_query($query)); 1454 1455 if (!empty($data) and isset($data['user_id']) and !isset($data['date_check'])) 1456 { 1457 list($dbnow) = pwg_db_fetch_row(pwg_query('SELECT NOW();')); 1458 1459 $query = " 1434 1435 if (isset($conf_UAM[1]) and $conf_UAM[1] == 'true') 1436 { 1437 list($dbnow) = pwg_db_fetch_row(pwg_query('SELECT NOW();')); 1438 1439 $query = " 1460 1440 UPDATE ".USER_CONFIRM_MAIL_TABLE." 1461 1441 SET date_check='".$dbnow."' 1462 WHERE user_id = '".$data['user_id']."' 1442 WHERE user_id = '".$id."' 1443 ;"; 1444 pwg_query($query); 1445 1446 if ($conf_UAM[2] <> -1) 1447 { 1448 $query = " 1449 DELETE FROM ".USER_GROUP_TABLE." 1450 WHERE user_id = '".$id."' 1451 AND group_id = '".$conf_UAM[2]."' 1463 1452 ;"; 1464 1453 pwg_query($query); 1465 1466 if ($conf_UAM[2] <> -1) 1467 { 1468 $query = " 1454 } 1455 1456 if ($conf_UAM[3] <> -1) 1457 { 1458 $query = " 1469 1459 DELETE FROM ".USER_GROUP_TABLE." 1470 WHERE user_id = '".$data['user_id']."' 1471 AND group_id = '".$conf_UAM[2]."' 1472 ;"; 1473 pwg_query($query); 1474 } 1475 1476 if ($conf_UAM[3] <> -1) 1477 { 1478 $query = " 1479 DELETE FROM ".USER_GROUP_TABLE." 1480 WHERE user_id = '".$data['user_id']."' 1460 WHERE user_id = '".$id."' 1481 1461 AND group_id = '".$conf_UAM[3]."' 1482 1483 1462 ;"; 1463 pwg_query($query); 1484 1464 1485 1465 $query = " 1486 1466 INSERT INTO ".USER_GROUP_TABLE." 1487 1467 (user_id, group_id) 1488 1468 VALUES 1489 ('".$ data['user_id']."', '".$conf_UAM[3]."')1490 ;"; 1491 1492 1493 1494 if (($conf_UAM[4] <> -1 or isset($data['status'])))1495 1496 1469 ('".$id."', '".$conf_UAM[3]."') 1470 ;"; 1471 pwg_query($query); 1472 } 1473 1474 if ($conf_UAM[4] <> -1) 1475 { 1476 $query = " 1497 1477 UPDATE ".USER_INFOS_TABLE." 1498 SET status = '".(isset($data['status']) ? $data['status'] : $conf_UAM[4])."' 1499 WHERE user_id = '".$data['user_id']."' 1500 ;"; 1501 pwg_query($query); 1502 } 1503 // Refresh user's category cache 1504 invalidate_user_cache(); 1505 return true; 1478 SET status = '".$conf_UAM[4]."' 1479 WHERE user_id = '".$id."' 1480 ;"; 1481 pwg_query($query); 1506 1482 } 1507 } 1483 } 1484 elseif (isset($conf_UAM[1]) and $conf_UAM[1] == 'local') 1485 { 1486 list($dbnow) = pwg_db_fetch_row(pwg_query('SELECT NOW();')); 1487 1488 if ($conf_UAM[2] <> -1) 1489 { 1490 $query = " 1491 DELETE FROM ".USER_GROUP_TABLE." 1492 WHERE user_id = '".$id."' 1493 AND group_id = '".$conf_UAM[2]."' 1494 ;"; 1495 pwg_query($query); 1496 } 1497 1498 if ($conf_UAM[3] <> -1) 1499 { 1500 $query = " 1501 DELETE FROM ".USER_GROUP_TABLE." 1502 WHERE user_id = '".$id."' 1503 AND group_id = '".$conf_UAM[3]."' 1504 ;"; 1505 pwg_query($query); 1506 1507 $query = " 1508 INSERT INTO ".USER_GROUP_TABLE." 1509 (user_id, group_id) 1510 VALUES 1511 ('".$id."', '".$conf_UAM[3]."') 1512 ;"; 1513 pwg_query($query); 1514 } 1515 1516 if ($conf_UAM[4] <> -1) 1517 { 1518 $query = " 1519 UPDATE ".USER_INFOS_TABLE." 1520 SET status = '".$conf_UAM[4]."' 1521 WHERE user_id = '".$id."' 1522 ;"; 1523 pwg_query($query); 1524 } 1525 } 1508 1526 } 1509 1527
Note: See TracChangeset
for help on using the changeset viewer.