- Timestamp:
- Sep 14, 2012, 11:01:08 PM (12 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
extensions/UserAdvManager/trunk/include/functions.inc.php
r17892 r17918 136 136 // ---------------------------------------------------------------------------------------------- 137 137 SetPermission($register_user['id']);// Set to "waiting" group or status until admin validation 138 139 // This is to set UAM_validated field to false in #_users table - Usefull if no "waiting" group or status is set 140 // ------------------------------------------------------------------------------------------------------------- 141 SetUnvalidated($register_user['id']); 138 142 } 139 143 // Sending registration confirmation by email … … 262 266 $user_idsOK[] = $user['id']; 263 267 264 $query = "265 UPDATE ".CONFIG_TABLE."266 SET value = \"".implode(',', $user_idsOK)."\"267 WHERE param = 'UserAdvManager_Redir';";268 $query = ' 269 UPDATE '.CONFIG_TABLE.' 270 SET value = "'.implode(',', $user_idsOK).'" 271 WHERE param = "UserAdvManager_Redir";'; 268 272 269 273 pwg_query($query); … … 318 322 if (!empty($_POST['use_new_pwd'])) 319 323 { 320 $typemail = 2; // Confirmation email on user profile update - With information email if checked324 $typemail = 2; // Confirmation email on user profile update - With information email 321 325 322 326 // Password enforcement control … … 357 361 { 358 362 SetPermission($user['id']);// Set to "waiting" group or status until user validation 363 SetUnvalidated($user['id']); // Set UAM_validated field to false in #_users table 359 364 $confirm_mail_need = true; 360 365 } … … 365 370 { 366 371 SetPermission($user['id']);// Set to "waiting" group or status until admin validation 372 SetUnvalidated($user['id']); // Set UAM_validated field to false in #_users table 367 373 $confirm_mail_need = false; 368 374 } … … 586 592 list($dbnow) = pwg_db_fetch_row(pwg_query('SELECT NOW();')); 587 593 588 $query = "589 UPDATE ".USER_LASTVISIT_TABLE."590 SET lastvisit= '".$dbnow."'591 WHERE user_id = ' ".$user_id."'592 ; ";594 $query = ' 595 UPDATE '.USER_LASTVISIT_TABLE.' 596 SET lastvisit="'.$dbnow.'" 597 WHERE user_id = '.$user_id.' 598 ;'; 593 599 pwg_query($query); 594 600 … … 597 603 // Delete user from all groups 598 604 // --------------------------- 599 $query = "600 DELETE FROM ".USER_GROUP_TABLE."601 WHERE user_id = ' ".$user_id."'605 $query = ' 606 DELETE FROM '.USER_GROUP_TABLE.' 607 WHERE user_id = '.$user_id.' 602 608 AND ( 603 group_id = '".$conf_UAM[2]."'609 group_id = "'.$conf_UAM[2].'" 604 610 OR 605 group_id = '".$conf_UAM[3]."'611 group_id = "'.$conf_UAM[3].'" 606 612 ) 607 ; ";613 ;'; 608 614 pwg_query($query); 609 615 … … 612 618 if ($conf_UAM[26] <> -1) 613 619 { 614 $query = "615 UPDATE ".USER_INFOS_TABLE."616 SET status = '".$conf_UAM[26]."'617 WHERE user_id = ' ".$user_id."'618 ; ";620 $query = ' 621 UPDATE '.USER_INFOS_TABLE.' 622 SET status = "'.$conf_UAM[26].'" 623 WHERE user_id = '.$user_id.' 624 ;'; 619 625 pwg_query($query); 620 626 } … … 624 630 if ($conf_UAM[25] <> -1) 625 631 { 626 $query = "627 INSERT INTO ".USER_GROUP_TABLE."632 $query = ' 633 INSERT INTO '.USER_GROUP_TABLE.' 628 634 (user_id, group_id) 629 635 VALUES 630 (' ".$user_id."', '".$conf_UAM[25]."')631 ; ";636 ('.$user_id.', "'.$conf_UAM[25].'") 637 ;'; 632 638 pwg_query($query); 633 639 } … … 637 643 if ($conf_UAM[37] <> -1) 638 644 { 639 $query = "640 UPDATE ".USER_INFOS_TABLE."641 SET level = '".$conf_UAM[37]."'642 WHERE user_id = ' ".$user_id."'643 ; ";645 $query = ' 646 UPDATE '.USER_INFOS_TABLE.' 647 SET level = "'.$conf_UAM[37].'" 648 WHERE user_id = '.$user_id.' 649 ;'; 644 650 pwg_query($query); 645 651 } … … 651 657 // Set reminder true 652 658 // ----------------- 653 $query = "654 UPDATE ".USER_LASTVISIT_TABLE."655 SET reminder = 'true'656 WHERE user_id = ' ".$user_id."'657 ; ";659 $query = ' 660 UPDATE '.USER_LASTVISIT_TABLE.' 661 SET reminder = "true" 662 WHERE user_id = '.$user_id.' 663 ;'; 658 664 pwg_query($query); 659 665 … … 663 669 UPDATE '.USER_CONFIRM_MAIL_TABLE.' 664 670 SET date_check = NULL 665 WHERE user_id = "'.$user_id.'"671 WHERE user_id = '.$user_id.' 666 672 ;'; 667 673 pwg_query($query); … … 757 763 // Get current user informations 758 764 // ----------------------------- 759 $query = "765 $query = ' 760 766 SELECT id, username, mail_address 761 FROM ".USERS_TABLE."762 WHERE id = ' ".$user['id']."'763 ; ";767 FROM '.USERS_TABLE.' 768 WHERE id = '.$user['id'].' 769 ;'; 764 770 $data = pwg_db_fetch_assoc(pwg_query($query)); 765 771 … … 811 817 // Get current user informations 812 818 // ----------------------------- 813 $query = "819 $query = ' 814 820 SELECT id, username, mail_address 815 FROM ".USERS_TABLE."816 WHERE id = ' ".$user_id."'817 ; ";821 FROM '.USERS_TABLE.' 822 WHERE id = '.$user_id.' 823 ;'; 818 824 $data = pwg_db_fetch_assoc(pwg_query($query)); 819 825 … … 1087 1093 } 1088 1094 1089 if ( 1095 if (isset($conf_UAM[1]) and $conf_UAM[1] == 'true' and $confirm) // Add confirmation link ? 1090 1096 { 1091 1097 $infos2 = array … … 1218 1224 // Set reminder true 1219 1225 // ----------------- 1220 $query = "1221 UPDATE ".USER_CONFIRM_MAIL_TABLE."1222 SET reminder = 'true'1223 WHERE user_id = ' ".$user_id."'1224 ; ";1226 $query = ' 1227 UPDATE '.USER_CONFIRM_MAIL_TABLE.' 1228 SET reminder = "true" 1229 WHERE user_id = '.$user_id.' 1230 ;'; 1225 1231 pwg_query($query); 1226 1232 … … 1270 1276 // Set reminder true 1271 1277 // ----------------- 1272 $query = "1273 UPDATE ".USER_CONFIRM_MAIL_TABLE."1274 SET reminder = 'true'1275 WHERE user_id = ' ".$user_id."'1276 ; ";1278 $query = ' 1279 UPDATE '.USER_CONFIRM_MAIL_TABLE.' 1280 SET reminder = "true" 1281 WHERE user_id = '.$user_id.' 1282 ;'; 1277 1283 pwg_query($query); 1278 1284 … … 1596 1602 { 1597 1603 $id = generate_key(16); 1598 $query = "1604 $query = ' 1599 1605 SELECT COUNT(*) 1600 FROM ".USER_CONFIRM_MAIL_TABLE."1601 WHERE id = ' ".$id."'1602 ; ";1606 FROM '.USER_CONFIRM_MAIL_TABLE.' 1607 WHERE id = '.$id.' 1608 ;'; 1603 1609 list($count) = pwg_db_fetch_row(pwg_query($query)); 1604 1610 … … 1628 1634 if (isset($Confirm_Mail_ID)) 1629 1635 { 1630 $query = "1636 $query = ' 1631 1637 SELECT status 1632 FROM ".USER_INFOS_TABLE."1633 WHERE user_id = ' ".$user_id."'1634 ; ";1638 FROM '.USER_INFOS_TABLE.' 1639 WHERE user_id = '.$user_id.' 1640 ;'; 1635 1641 list($status) = pwg_db_fetch_row(pwg_query($query)); 1636 1642 1637 $query = "1638 INSERT INTO ".USER_CONFIRM_MAIL_TABLE."1643 $query = ' 1644 INSERT INTO '.USER_CONFIRM_MAIL_TABLE.' 1639 1645 (id, user_id, mail_address, status, date_check) 1640 1646 VALUES 1641 ( '".$Confirm_Mail_ID."', '".$user_id."', '".$email."', '".$status."', null)1642 ; ";1647 ("'.$Confirm_Mail_ID.'", '.$user_id.', "'.$email.'", "'.$status.'", null) 1648 ;'; 1643 1649 pwg_query($query); 1644 1650 1645 1651 // Delete user from all groups 1646 1652 // --------------------------- 1647 $query = "1648 DELETE FROM ".USER_GROUP_TABLE."1649 WHERE user_id = ' ".$user_id."'1653 $query = ' 1654 DELETE FROM '.USER_GROUP_TABLE.' 1655 WHERE user_id = '.$user_id.' 1650 1656 AND ( 1651 group_id = '".$conf_UAM[2]."'1657 group_id = "'.$conf_UAM[2].'" 1652 1658 OR 1653 group_id = '".$conf_UAM[3]."'1659 group_id = "'.$conf_UAM[3].'" 1654 1660 ) 1655 ; ";1661 ;'; 1656 1662 pwg_query($query); 1657 1663 … … 1660 1666 if (!is_admin() and $conf_UAM[7] <> -1) 1661 1667 { 1662 $query = "1663 UPDATE ".USER_INFOS_TABLE."1664 SET status = '".$conf_UAM[7]."'1665 WHERE user_id = ' ".$user_id."'1666 ; ";1668 $query = ' 1669 UPDATE '.USER_INFOS_TABLE.' 1670 SET status = "'.$conf_UAM[7].'" 1671 WHERE user_id = '.$user_id.' 1672 ;'; 1667 1673 pwg_query($query); 1668 1674 } … … 1672 1678 if (!is_admin() and $conf_UAM[2] <> -1) 1673 1679 { 1674 $query = "1675 INSERT INTO ".USER_GROUP_TABLE."1680 $query = ' 1681 INSERT INTO '.USER_GROUP_TABLE.' 1676 1682 (user_id, group_id) 1677 1683 VALUES 1678 (' ".$user_id."', '".$conf_UAM[2]."')1679 ; ";1684 ('.$user_id.', "'.$conf_UAM[2].'") 1685 ;'; 1680 1686 pwg_query($query); 1681 1687 } … … 1685 1691 if (!is_admin() and $conf_UAM[35] <> -1) 1686 1692 { 1687 $query = "1688 UPDATE ".USER_INFOS_TABLE."1689 SET level = '".$conf_UAM[35]."'1690 WHERE user_id = ' ".$user_id."'1691 ; ";1693 $query = ' 1694 UPDATE '.USER_INFOS_TABLE.' 1695 SET level = "'.$conf_UAM[35].'" 1696 WHERE user_id = '.$user_id.' 1697 ;'; 1692 1698 pwg_query($query); 1693 1699 } 1700 1701 // Set UAM_validated field to false in #_users table 1702 // ------------------------------------------------- 1703 SetUnvalidated($user_id); 1694 1704 1695 1705 return get_absolute_root_url().UAM_PATH.'ConfirmMail.php?key='.$Confirm_Mail_ID.'&userid='.$user_id; … … 1713 1723 // Groups cleanup 1714 1724 // -------------- 1715 $query = "1716 DELETE FROM ".USER_GROUP_TABLE."1717 WHERE user_id = ' ".$user_id."'1725 $query = ' 1726 DELETE FROM '.USER_GROUP_TABLE.' 1727 WHERE user_id = '.$user_id.' 1718 1728 AND ( 1719 group_id = '".$conf_UAM[2]."'1729 group_id = "'.$conf_UAM[2].'" 1720 1730 OR 1721 group_id = '".$conf_UAM[3]."'1731 group_id = "'.$conf_UAM[3].'" 1722 1732 ) 1723 ; ";1733 ;'; 1724 1734 pwg_query($query); 1725 1735 1726 1736 if (!is_admin() and $conf_UAM[7] <> -1) // Set status 1727 1737 { 1728 $query = "1729 UPDATE ".USER_INFOS_TABLE."1730 SET status = '".$conf_UAM[7]."'1731 WHERE user_id = ' ".$user_id."'1732 ; ";1738 $query = ' 1739 UPDATE '.USER_INFOS_TABLE.' 1740 SET status = "'.$conf_UAM[7].'" 1741 WHERE user_id = '.$user_id.' 1742 ;'; 1733 1743 pwg_query($query); 1734 1744 } … … 1736 1746 if (!is_admin() and $conf_UAM[2] <> -1) // Set group 1737 1747 { 1738 $query = "1739 INSERT INTO ".USER_GROUP_TABLE."1748 $query = ' 1749 INSERT INTO '.USER_GROUP_TABLE.' 1740 1750 (user_id, group_id) 1741 1751 VALUES 1742 (' ".$user_id."', '".$conf_UAM[2]."')1743 ; ";1752 ('.$user_id.', "'.$conf_UAM[2].'") 1753 ;'; 1744 1754 pwg_query($query); 1745 1755 } … … 1747 1757 if (!is_admin() and $conf_UAM[35] <> -1) // Set privacy level 1748 1758 { 1749 $query = "1750 INSERT INTO ".USER_INFOS_TABLE."1759 $query = ' 1760 INSERT INTO '.USER_INFOS_TABLE.' 1751 1761 (user_id, level) 1752 1762 VALUES 1753 (' ".$user_id."', '".$conf_UAM[35]."')1754 ; ";1763 ('.$user_id.', "'.$conf_UAM[35].'") 1764 ;'; 1755 1765 pwg_query($query); 1756 1766 } … … 1776 1786 if (isset($Confirm_Mail_ID)) 1777 1787 { 1778 $query = "1779 UPDATE ".USER_CONFIRM_MAIL_TABLE."1780 SET id = '".$Confirm_Mail_ID."'1781 WHERE user_id = ' ".$user_id."'1782 ; ";1788 $query = ' 1789 UPDATE '.USER_CONFIRM_MAIL_TABLE.' 1790 SET id = "'.$Confirm_Mail_ID.'" 1791 WHERE user_id = '.$user_id.' 1792 ;'; 1783 1793 pwg_query($query); 1784 1794 1785 $query = "1786 UPDATE ".USER_INFOS_TABLE."1787 SET registration_date = '".$dbnow."'1788 WHERE user_id = ' ".$user_id."'1789 ; ";1795 $query = ' 1796 UPDATE '.USER_INFOS_TABLE.' 1797 SET registration_date = "'.$dbnow.'" 1798 WHERE user_id = '.$user_id.' 1799 ;'; 1790 1800 pwg_query($query); 1791 1801 … … 1807 1817 list($dbnow) = pwg_db_fetch_row(pwg_query('SELECT NOW();')); 1808 1818 1809 $query = "1810 UPDATE ".USER_LASTVISIT_TABLE."1811 SET lastvisit = '".$dbnow."', reminder = 'true'1812 WHERE user_id = ' ".$user_id."'1813 ; ";1819 $query = ' 1820 UPDATE '.USER_LASTVISIT_TABLE.' 1821 SET lastvisit = "'.$dbnow.'", reminder = "true" 1822 WHERE user_id = '.$user_id.' 1823 ;'; 1814 1824 pwg_query($query); 1815 1825 } … … 1822 1832 function DeleteConfirmMail($user_id) 1823 1833 { 1824 $query = "1825 DELETE FROM ".USER_CONFIRM_MAIL_TABLE."1826 WHERE user_id = ' ".$user_id."'1827 ; ";1834 $query = ' 1835 DELETE FROM '.USER_CONFIRM_MAIL_TABLE.' 1836 WHERE user_id = '.$user_id.' 1837 ;'; 1828 1838 pwg_query($query); 1829 1839 } … … 1835 1845 function DeleteLastVisit($user_id) 1836 1846 { 1837 $query = "1838 DELETE FROM ".USER_LASTVISIT_TABLE."1839 WHERE user_id = ' ".$user_id."'1840 ; ";1847 $query = ' 1848 DELETE FROM '.USER_LASTVISIT_TABLE.' 1849 WHERE user_id = '.$user_id.' 1850 ;'; 1841 1851 pwg_query($query); 1842 1852 } … … 1865 1875 unset($values[array_search($user_id, $values)]); 1866 1876 1867 $query = "1868 UPDATE ".CONFIG_TABLE."1869 SET value = \"".implode(',', $values)."\"1870 WHERE param = 'UserAdvManager_Redir';";1877 $query = ' 1878 UPDATE '.CONFIG_TABLE.' 1879 SET value = "'.implode(',', $values).'" 1880 WHERE param = "UserAdvManager_Redir";'; 1871 1881 1872 1882 pwg_query($query); … … 1893 1903 $conf_UAM_ConfirmMail = unserialize($conf['UserAdvManager_ConfirmMail']); 1894 1904 1895 $query = "1905 $query = ' 1896 1906 SELECT COUNT(*) 1897 FROM ".USER_CONFIRM_MAIL_TABLE."1898 WHERE id = ' ".$id."'1899 ; ";1907 FROM '.USER_CONFIRM_MAIL_TABLE.' 1908 WHERE id = '.$id.' 1909 ;'; 1900 1910 list($count) = pwg_db_fetch_row(pwg_query($query)); 1901 1911 1902 1912 if ($count == 1) 1903 1913 { 1904 $query = "1914 $query = ' 1905 1915 SELECT user_id, status, date_check 1906 FROM ".USER_CONFIRM_MAIL_TABLE."1907 WHERE id = ' ".$id."'1908 ; ";1916 FROM '.USER_CONFIRM_MAIL_TABLE.' 1917 WHERE id = '.$id.' 1918 ;'; 1909 1919 $data = pwg_db_fetch_assoc(pwg_query($query)); 1910 1920 1911 1921 if (!empty($data) and isset($data['user_id']) and is_null($data['date_check'])) 1912 1922 { 1913 $query = "1923 $query = ' 1914 1924 SELECT registration_date 1915 FROM ".USER_INFOS_TABLE."1916 WHERE user_id = ' ".$data['user_id']."'1917 ; ";1925 FROM '.USER_INFOS_TABLE.' 1926 WHERE user_id = '.$data['user_id'].' 1927 ;'; 1918 1928 list($registration_date) = pwg_db_fetch_row(pwg_query($query)); 1919 1929 … … 1966 1976 if ($conf_UAM[2] <> -1) // Delete user from unvalidated users group 1967 1977 { 1968 $query = "1969 DELETE FROM ".USER_GROUP_TABLE."1970 WHERE user_id = ' ".$data['user_id']."'1971 AND group_id = '".$conf_UAM[2]."'1972 ; ";1978 $query = ' 1979 DELETE FROM '.USER_GROUP_TABLE.' 1980 WHERE user_id = '.$data['user_id'].' 1981 AND group_id = "'.$conf_UAM[2].'" 1982 ;'; 1973 1983 pwg_query($query); 1974 1984 } … … 1976 1986 if ($conf_UAM[3] <> -1) // Add user to validated users group 1977 1987 { 1978 $query = "1979 INSERT INTO ".USER_GROUP_TABLE."1988 $query = ' 1989 INSERT INTO '.USER_GROUP_TABLE.' 1980 1990 (user_id, group_id) 1981 1991 VALUES 1982 (' ".$data['user_id']."', '".$conf_UAM[3]."')1983 ; ";1992 ('.$data['user_id'].', "'.$conf_UAM[3].'") 1993 ;'; 1984 1994 pwg_query($query); 1985 1995 } … … 1987 1997 if (($conf_UAM[4] <> -1 or isset($data['status']))) // Change user's status 1988 1998 { 1989 $query = "1990 UPDATE ".USER_INFOS_TABLE."1991 SET status = '".(isset($data['status']) ? $data['status'] : $conf_UAM[4])."'1992 WHERE user_id = ' ".$data['user_id']."'1993 ; ";1999 $query = ' 2000 UPDATE '.USER_INFOS_TABLE.' 2001 SET status = "'.(isset($data['status']) ? $data['status'] : $conf_UAM[4]).'" 2002 WHERE user_id = '.$data['user_id'].' 2003 ;'; 1994 2004 pwg_query($query); 1995 2005 } … … 1997 2007 if (($conf_UAM[36] <> -1 or isset($data['level']))) // Change user's privacy level 1998 2008 { 1999 $query = "2000 UPDATE ".USER_INFOS_TABLE."2001 SET level = '".(isset($data['level']) ? $data['level'] : $conf_UAM[36])."'2002 WHERE user_id = ' ".$data['user_id']."'2003 ; ";2009 $query = ' 2010 UPDATE '.USER_INFOS_TABLE.' 2011 SET level = "'.(isset($data['level']) ? $data['level'] : $conf_UAM[36]).'" 2012 WHERE user_id = '.$data['user_id'].' 2013 ;'; 2004 2014 pwg_query($query); 2005 2015 } … … 2043 2053 if ($conf_UAM[2] <> -1) // Delete user from unvalidated users group 2044 2054 { 2045 $query = "2046 DELETE FROM ".USER_GROUP_TABLE."2047 WHERE user_id = ' ".$data['user_id']."'2048 AND group_id = '".$conf_UAM[2]."'2049 ; ";2055 $query = ' 2056 DELETE FROM '.USER_GROUP_TABLE.' 2057 WHERE user_id = '.$data['user_id'].' 2058 AND group_id = "'.$conf_UAM[2].'" 2059 ;'; 2050 2060 pwg_query($query); 2051 2061 } … … 2053 2063 if ($conf_UAM[3] <> -1) 2054 2064 { 2055 $query = "2056 DELETE FROM ".USER_GROUP_TABLE."2057 WHERE user_id = ' ".$data['user_id']."'2058 AND group_id = '".$conf_UAM[3]."'2059 ; ";2065 $query = ' 2066 DELETE FROM '.USER_GROUP_TABLE.' 2067 WHERE user_id = '.$data['user_id'].' 2068 AND group_id = "'.$conf_UAM[3].'" 2069 ;'; 2060 2070 pwg_query($query); 2061 2071 2062 $query = "2063 INSERT INTO ".USER_GROUP_TABLE."2072 $query = ' 2073 INSERT INTO '.USER_GROUP_TABLE.' 2064 2074 (user_id, group_id) 2065 2075 VALUES 2066 (' ".$data['user_id']."', '".$conf_UAM[3]."')2067 ; ";2076 ('.$data['user_id'].', "'.$conf_UAM[3].'") 2077 ;'; 2068 2078 pwg_query($query); 2069 2079 } … … 2071 2081 if (($conf_UAM[4] <> -1 or isset($data['status']))) // Change user's status 2072 2082 { 2073 $query = "2074 UPDATE ".USER_INFOS_TABLE."2075 SET status = '".(isset($data['status']) ? $data['status'] : $conf_UAM[4])."'2076 WHERE user_id = ' ".$data['user_id']."'2077 ; ";2083 $query = ' 2084 UPDATE '.USER_INFOS_TABLE.' 2085 SET status = "'.(isset($data['status']) ? $data['status'] : $conf_UAM[4]).'" 2086 WHERE user_id = '.$data['user_id'].' 2087 ;'; 2078 2088 pwg_query($query); 2079 2089 } … … 2081 2091 if (($conf_UAM[36] <> -1 or isset($data['level']))) // Change user's privacy level 2082 2092 { 2083 $query = "2084 UPDATE ".USER_INFOS_TABLE."2085 SET level = '".(isset($data['level']) ? $data['level'] : $conf_UAM[36])."'2086 WHERE user_id = ' ".$data['user_id']."'2087 ; ";2093 $query = ' 2094 UPDATE '.USER_INFOS_TABLE.' 2095 SET level = "'.(isset($data['level']) ? $data['level'] : $conf_UAM[36]).'" 2096 WHERE user_id = '.$data['user_id'].' 2097 ;'; 2088 2098 pwg_query($query); 2089 2099 } … … 2108 2118 2109 2119 /** 2110 * Function called from UAM_admin.php to force usersvalidation by admin2120 * Function called from UAM_admin.php for manual validation by admin 2111 2121 * 2112 2122 * @param : User id 2113 2123 * 2114 2124 */ 2115 function ForceValidation($id) 2116 { 2117 global $conf; 2118 2119 $conf_UAM = unserialize($conf['UserAdvManager']); 2120 2121 if (isset($conf_UAM[1]) and $conf_UAM[1] == 'true') 2122 { 2123 list($dbnow) = pwg_db_fetch_row(pwg_query('SELECT NOW();')); 2124 2125 $query = " 2126 UPDATE ".USER_CONFIRM_MAIL_TABLE." 2127 SET date_check='".$dbnow."' 2128 WHERE user_id = '".$id."' 2129 ;"; 2130 pwg_query($query); 2131 } 2132 2133 if ($conf_UAM[2] <> -1) // Delete user from waiting group 2134 { 2135 $query = " 2136 DELETE FROM ".USER_GROUP_TABLE." 2137 WHERE user_id = '".$id."' 2138 AND group_id = '".$conf_UAM[2]."' 2139 ;"; 2125 function ManualValidation($id) 2126 { 2127 global $conf; 2128 2129 $conf_UAM = unserialize($conf['UserAdvManager']); 2130 2131 if (isset($conf_UAM[1]) and $conf_UAM[1] == 'true') // Set date of validation 2132 { 2133 list($dbnow) = pwg_db_fetch_row(pwg_query('SELECT NOW();')); 2134 2135 $query = ' 2136 UPDATE '.USER_CONFIRM_MAIL_TABLE.' 2137 SET date_check="'.$dbnow.'" 2138 WHERE user_id = '.$id.' 2139 ;'; 2140 pwg_query($query); 2141 } 2142 2143 if ($conf_UAM[2] <> -1) // Delete user from waiting group 2144 { 2145 $query = ' 2146 DELETE FROM '.USER_GROUP_TABLE.' 2147 WHERE user_id = '.$id.' 2148 AND group_id = "'.$conf_UAM[2].'" 2149 ;'; 2150 pwg_query($query); 2151 } 2152 2153 if ($conf_UAM[3] <> -1) // Set user's valid group 2154 { 2155 $query = ' 2156 DELETE FROM '.USER_GROUP_TABLE.' 2157 WHERE user_id = '.$id.' 2158 AND group_id = "'.$conf_UAM[3].'" 2159 ;'; 2160 pwg_query($query); 2161 2162 $query = ' 2163 INSERT INTO '.USER_GROUP_TABLE.' 2164 (user_id, group_id) 2165 VALUES 2166 ('.$id.', "'.$conf_UAM[3].'") 2167 ;'; 2168 pwg_query($query); 2169 } 2170 2171 if ($conf_UAM[4] <> -1) // Set user's valid status 2172 { 2173 $query = ' 2174 UPDATE '.USER_INFOS_TABLE.' 2175 SET status = "'.$conf_UAM[4].'" 2176 WHERE user_id = '.$id.' 2177 ;'; 2178 pwg_query($query); 2179 } 2180 2181 if ($conf_UAM[36] <> -1) // Set user's valid privacy level 2182 { 2183 $query = ' 2184 UPDATE '.USER_INFOS_TABLE.' 2185 SET level = "'.$conf_UAM[36].'" 2186 WHERE user_id = '.$id.' 2187 ;'; 2188 pwg_query($query); 2189 } 2190 2191 // Set UAM_validated field to True in #_users table 2192 $query = ' 2193 UPDATE '.USERS_TABLE.' 2194 SET UAM_validated = "true" 2195 WHERE id = '.$id.' 2196 ;'; 2140 2197 pwg_query($query); 2141 }2142 2143 if ($conf_UAM[3] <> -1) // Set user's valid group2144 {2145 $query = "2146 DELETE FROM ".USER_GROUP_TABLE."2147 WHERE user_id = '".$id."'2148 AND group_id = '".$conf_UAM[3]."'2149 ;";2150 pwg_query($query);2151 2152 $query = "2153 INSERT INTO ".USER_GROUP_TABLE."2154 (user_id, group_id)2155 VALUES2156 ('".$id."', '".$conf_UAM[3]."')2157 ;";2158 pwg_query($query);2159 }2160 2161 if ($conf_UAM[4] <> -1) // Set user's valid status2162 {2163 $query = "2164 UPDATE ".USER_INFOS_TABLE."2165 SET status = '".$conf_UAM[4]."'2166 WHERE user_id = '".$id."'2167 ;";2168 pwg_query($query);2169 }2170 2171 if ($conf_UAM[36] <> -1) // Set user's valid privacy level2172 {2173 $query = "2174 UPDATE ".USER_INFOS_TABLE."2175 SET level = '".$conf_UAM[36]."'2176 WHERE user_id = '".$id."'2177 ;";2178 pwg_query($query);2179 }2180 2198 } 2181 2199 … … 2544 2562 $conf_UAM = unserialize($conf['UserAdvManager']); 2545 2563 2546 $query = "2564 $query = ' 2547 2565 SELECT registration_date 2548 FROM ".USER_INFOS_TABLE."2549 WHERE user_id = ' ".$id."'2550 ; ";2566 FROM '.USER_INFOS_TABLE.' 2567 WHERE user_id = '.$id.' 2568 ;'; 2551 2569 list($registration_date) = pwg_db_fetch_row(pwg_query($query)); 2552 2570 … … 2765 2783 2766 2784 /** 2785 * SetUnvalidated 2786 * Set UAM_validated field to false in #_users table 2787 * 2788 **/ 2789 function SetUnvalidated($user_id) 2790 { 2791 $query =' 2792 UPDATE '.USERS_TABLE.' 2793 SET UAM_validated = "false" 2794 WHERE id = '.$user_id.' 2795 LIMIT 1 2796 ;'; 2797 2798 pwg_query($query); 2799 } 2800 2801 2802 /** 2767 2803 * UAM_Set_PwdReset 2768 2804 * Action in user_list to set a password reset for a user
Note: See TracChangeset
for help on using the changeset viewer.