search

shibby / WHMCS-SmsModule

Sms module for WHMCS
GNU General Public License v3.0
52 stars 71 forks source link

activate sms notification for all accounts? #105

Open mediavista opened 5 years ago

mediavista commented 5 years ago

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

emakundi commented 5 years ago

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 <notifications@github.com 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 https://github.com/shibby/WHMCS-SmsModule/issues/105, or mute the thread https://github.com/notifications/unsubscribe-auth/ADlQCLooX3-Chq8JhsAQfHo3lDNQ2JpLks5u-zEZgaJpZM4Zl1Vd .

mediavista commented 5 years ago

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

emakundi commented 5 years ago

@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 notifications@github.com 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 https://github.com/shibby/WHMCS-SmsModule/issues/105#issuecomment-451336221, or mute the thread https://github.com/notifications/unsubscribe-auth/ADlQCEV89365nB4fERShqzSe6PL46At3ks5u_rgBgaJpZM4Zl1Vd.

mediavista commented 5 years ago

@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 commented 5 years ago

@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 commented 5 years ago

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