SportsGalore

All my services on cart are subscriptions using full automation, if there is someone with an inactive account without any invoice thats just a record/client table i don't need to keep (or at least have the option to purge) I guess i'm just wanting a way to separate the active "paid" clients from the bogus clients and dummy emails some try to sign up as just to "look" and do nothing else, just would be nice to do a bit of housekeeping and clear out any records that are: 1 not verified their email, 2 have no invoice past or present 3 are inactive the three things above together are just a client name/record I just don't need to keep & helps me keep it tidy thats all

Thanks Chris, wow thats 3 years old who can i pay to develop one haha

I see there is a commercial addon for this already, but not compatible with 7.1.0 do whmcs have any plans to add this feature into upcoming releases ? it would really take the whole package to the next level, and would be sweeeet if owners could assign different forum access based on what service/product the client is activated for & have a single sign in etc

I'll be defo adding this, thanks so much!

Thanks for the reply, seems odd that we have optimise database options, but the most basic of housekeeping tasks like keeping our system clean of unused accounts is not possible...It's not a space saving option, more towards keeping a tidy platform thats all I'm sure the powers that be at whmcs could slot in some automation for this, it can do everything else perfectly, but it cannot mass remove fake or unused accounts created.....seems odd thats all

Hi All, It seems that there isn't a way to mass remove inactive client accounts from within Whmcs, (i mean accounts that have signed up but just have 0/0 for products or services) but does anyone have a solution to this instead of having to manually go through every inactive account and hit the delete button for each ? any info / tip or solution would be appreciated as I want to keep my DB tidy! I really think this ability should be included in the next update and a cron for remove/delete inactive accounts after 60 days would resolve it for all instead of inactive users taking up space in the tables. Thanks

is there a commercial script that can do this as my coding skills are not great? maybe you could quote on this post which is where i'm trying to get to if that is your expertise ? http://forums.whmcs.com/showthread.php?113371-Looking-for-a-Hook-expert-)-to-help-with-coding

Hi Kian, Thanks for your help pal, I see the random generated username & password though so shouldn't the system be doing this "save/allocate" for me when i activate a pending order ? if i activate and then go into the invoice the username & password fields are blank, i use to sell "items" rather than service/hostings all i need to do is have the systems generated random username & password saved into that invoice detail for that client for that purchase when i activate, nothing else to happen etc i see i can include this if it saves via these varibles on the welcome Username {$service_username} Password {$service_password} but i'm not actually enabling a "service", i just want a per purchase random username & password for each product to save so i can use it to give to the client on welcome email for that product ordered after it goes active etc

PS I have enabled auto release and i see a random username & password below the pending invoice which is perfect, but on activate these details don't get saved on the invoice, so therefore I cannot include them on the auto welcome email or use them etc, they just seem to vanish after i manually activate the pending invoice ?? any tips or advice most welcome

I deal with products only, is there a way to have the system auto generate a username & password for a product? i see there is an random username/password option to do this but it only looks like it is related to a domain/service type buy option & not just a product (non service) Can a hook do this for basic product purchase also ? I need an additional random username/password generated for each product item purchased on the cart so that I can include that on the welcome email after purchase & link that with auth to use the product for each client etc can you advise please ? Thanks Nick

I added hook to hook folder and the code you advised to template clientproducts & productdescriptions but i can still select and add a product to cart logging in & using an unverified account test which template file do i put your **{$verificationid}** in to stop them seeing/adding products to cart if not email verified ? cheers

I paid for my stripe module, best $18 i've ever spent

When a product is purchased for a membership duration i then have to manually login to another URL and add the details manually as per below to add the client. what I want to do is fully automate this after I manually activate the purchased product in WMCMS, so when i activate their product, it auto signs/sends info into the other site where the form page is located (i don't mind including my site login inside php etc) Then I just want to use the clients WHMCS email as the passed $username the clients WHMCS password as the passed $password If they purchased a 1 month product (pid=1), when it activates it looks to select form option value 16 If they purchased a 3 month product (pid=2), when it activates it looks for form option value 17 If they purchased a 6 month product (pid=3), when it activates it looks for form option value 18 If they purchased a 12 month product pid=8, when it activates it looks for form option value 19 in textarea name= I would like the full name of the client sent to that value then i want it to somehow submit to add the client to that page form & exit/disconnect Can someone tell me if this is possible? I don't have any coding skills lol but I hear hooks can do amazing things, if this can be done please can you tell me ? and what I would have to look at doing ? any info or thoughts appreciated from the hook guru's Cheers