fixtwin Posted April 26, 2013 Share Posted April 26, 2013 I've got a tricky situation here, After the update from 5.1. to 5.2.3 the usernames for client's service doesn't appear anymore in the client's profiles nor in the mysql database. All the usernames for clients subscribed before this update are in MySQL: This is the output for "select * from tblhosting where regdate='2013-04-26'" query: For the new clients: | 7727 | 5938 | 7310 | 2 | 0 | 2013-04-26 | | paypal | 11.95 | 11.05 | Monthly | 2013-05-26 | 2013-05-26 | Active | | | | | 0 | | | 0000-00-00 | | | | | 0 | 0 | 0 | 0 | 0000-00-00 00:00:00 | For the old ones: | 6713 | 4952 | 6318 | 2 | 0 | 2013-02-26 | | hostedpro | 23.85 | 23.85 | Quarterly | 2013-05-26 | 2013-05-26 | Active | qejnrjph | Sr9QXm1inBoC5hZowoSN5Jr7dRO0IU+JAeJK3b+E | | | 0 | | | 0000-00-00 | | | | | 0 | 0 | 0 | 0 | 0000-00-00 00:00:0 As you can see there is now username for the new clients. However! The script which runs on hook is able to create the client's service using WHMCS's automatic usernames So the script successfully uses this username but it is not saved in the DB. The script looks like this: $d=mysql_query("insert into addme values('".$vars["params"]["username"]."', '".$vars["params"]["clientsdetails"]["email"]."', ".$vars["params"]["pid"].", '".$vars["params"]["clientsdetails"]["language"]."')"); mysql_close($db37); and it runs on "create_pre_module" The Enable Random Usernames is enabled and everything worked fine with the 5.1 version. Does someone have an idea of what could happen? 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.