![]() ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=63 Table structure for table `rm_usersrvchangehistory`ĬREATE TABLE IF NOT EXISTS `rm_usersrvchangehistory` ( Dumping routines for database 'radius'Īdd mySQL table where records will be saved.Ĭreate file name rmsrvchangetable.sql and paste following date - phpMyAdmin SQL Dump INSERT INTO rm_usersrvchangehistory (datetime, username, newsrvid, oldsrvid, firstname, lastname, mobile) VALUES (NOW(), new.username, new.srvid, old.srvid, new.firstname, new.lastname, new.mobile) 1- mySQL TriggerĬreate file name srvchangetriggers.sql and paste following data Then the trigger will add user info like old service id, new service id, user name, mobile etc in this table upon srvid change.įirst create mySQL trigger which will be executed once there will be changes made in srvid column in rm_users table. then we will create mysql table which will hold all these info. We will create mysql trigger that will be executed every time srvid column will be changed in rm_users table. Although this function is builtin in RM, but with customized scripts we can do other functions as well. ![]() ![]() ![]() We want to send email/sms alert to user about his service package change with old/new package name details.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |