<br /><?<br /><br />require("main.inc.php");<br />$i = 0;<br /> $query = "<br /> SELECT U_Groups, U_Number, U_Username<br /> FROM {$config['tbprefix']}Users<br /> WHERE U_Groups NOT LIKE '%-3-%'<br /> ";<br /> $sth = $dbh -> do_query($query);<br /> while(list($groups,$number,$username) = $dbh -> fetch_array($sth)) {<br /> $newgroups = $groups."3-";<br /> $newgroups_q = addslashes($newgroups);<br /> $query = "<br /> UPDATE {$config['tbprefix']}Users<br /> SET U_Groups = '$newgroups_q'<br /> WHERE U_Number = $number<br /> ";<br /> $stj = $dbh -> do_query($query);<br /> echo "$username was $groups and was reset to $newgroups <br />";<br /> $i++;<br /> }<br /> <br /> echo "Done - updated $i users.<br />";<br /> <br /> ?><br />
