activate sms notification for all accounts?

[mediavista]

how to tick all accounts/ make all accounts to activate sms notification?
modifing all accounts one by one is painfull

[emakundi]

I think it's best to run a SQL script that will enable and copy the mobile numbers of clients to the aktuel sms tables

…

On Tue, 1 Jan 2019, 12:57 mediavista ***@***.*** wrote: how to tick all accounts/ make all accounts to activate sms notification? modifing all accounts one by one is painfull — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#105>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ADlQCLooX3-Chq8JhsAQfHo3lDNQ2JpLks5u-zEZgaJpZM4Zl1Vd> .

[mediavista]

anyone can help me to enable on all accounts using sql script?

[emakundi]

@mediavista Share with me your clients ID Numbers i will create a script for you. just fetch the clients ID numbers only also go to tblcustomfields and let me know what does this fieldname id's are 1. Send Sms 2. GSM Number

…

On 4 Jan 2019, at 05:10, mediavista ***@***.***> wrote: anyone can help me to enable on all accounts using sql script? — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#105 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ADlQCEV89365nB4fERShqzSe6PL46At3ks5u_rgBgaJpZM4Zl1Vd>.

[mediavista]

@emakundi i just want to 'tick' on all account only, GSM Number field already exist on by my previous module, so i don't need to edit GSM Number

this is my client ID number https://www.dropbox.com/s/ciek20w14e29nn3/clients_export_20190104.csv?dl=0
This is table for Send SMS https://www.dropbox.com/s/zgdv0wlnork5lmj/1.JPG?dl=0
This is table/cliend ID that i have edited them manually https://www.dropbox.com/s/fwgcancaxe1w9cq/2.JPG?dl=0

[emakundi]

@mediavista

If all the numbers are updated on this module(not WHMCS default Customer filed) what you need to do is update the Send SMS field to on.

Here are the simple procedure

1. Check on what id number is Send Sms row have on tblcustomfields table ( e.g number 1 )
2. go to tblcustomfieldsvalues table and run the below sql script

UPDATE tblcustomfieldsvalues SET value='on' WHERE fieldid = 1

Assuming your field ID = 1.

[emakundi]

@shibby and @mediavista I think this issue should be closed