MemoryX2 Posted January 9, 2013 Share Posted January 9, 2013 Hi, Is it possible, or are their scripts to change client ID's? I want to re-number mine. I know that I could modify the data base but then I have to modify for each client + orders for each client + products for each client + domains for each client. At least that is what I think, if I am wrong please advise me. The reason I ask is it would be great if my client number started at 1 and then continued to x number of clients without spaces for past testing and past customers. Currently I do not have an accurate number of clients because of tests I have run etc. Any help on this is appreciated! Thanks! 0 Quote Link to comment Share on other sites More sharing options...
WHMCS JamesX Posted January 9, 2013 Share Posted January 9, 2013 The number of clients that you have in your database is equal to the number of rows within the clients table. With that said, you can find out that number by either of the following: Clients -> View/Search Clients ___ Records Found, Page _ of _ The number of records is the number of clients in the database. [*]Utilities -> System -> Database Status The number of rows for the "tblclients" table is the number of clients in the database. 0 Quote Link to comment Share on other sites More sharing options...
MemoryX2 Posted January 9, 2013 Author Share Posted January 9, 2013 The number of clients that you have in your database is equal to the number of rows within the clients table. With that said, you can find out that number by either of the following: Clients -> View/Search Clients ___ Records Found, Page _ of _ The number of records is the number of clients in the database. [*]Utilities -> System -> Database Status The number of rows for the "tblclients" table is the number of clients in the database. Thanks! That is a good idea. I haven't thought about that. It is not exactly what I was looking for but will work. Thanks Again, Kyle 0 Quote Link to comment Share on other sites More sharing options...
webadpro Posted January 11, 2013 Share Posted January 11, 2013 A custom field could Also work. 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.