I think he is looking for a script of some sort that will update the client notice on multiple servers with the same info as server 1 (for example). As explained, currently you would have to log into each server to update the client notice manager. Basically a global client manager.
To answer your question StefanMNS, currently there is no such script.
Running through it in my head right now, it should be very simple to create.
To answer your question StefanMNS, currently there is no such script.
Running through it in my head right now, it should be very simple to create.
- Create new Client Notice
- Parse list of all of your mysql servers and connection info
- Connect server 1 => UPDATE x_accounts ac_notice_tx WHERE ac_reseller_fk = 'n'; (n = reseller user ID #)
- Connect server 2 => UPDATE x_accounts ac_notice_tx WHERE ac_reseller_fk = 'n'; (n = reseller user ID #)
- Connect server 3 => UPDATE x_accounts ac_notice_tx WHERE ac_reseller_fk = 'n'; (n = reseller user ID #)
- ---repeat until end of server list---