Jump to content

Service's username doesnt saved in Database


fixtwin

Recommended Posts

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?

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated