SHARE
TWEET

Untitled

a guest Aug 21st, 2019 102 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. DELIMITER ;;
  2. CREATE TRIGGER busqueda AFTER INSERT ON activas_ips FOR EACH ROW BEGIN
  3. IF NOT EXISTS(SELECT IP FROM datos_Mall activas_ips WHERE IP = New.IP)
  4. BEGIN
  5. INSERT INTO aa_cloud_avanced
  6. (Email, Whatsapp, Prefijo_Whatsapp_Country, IP, SQL_USER, SQL_PASS, MyIP_Web, MySQL_USER, MySQL_PASS, Usuario, Contrasenia, Status, Verifi, DEV, Contrasenia_panel, activo, web_host, tipo_panel, fecha, vps_USER, vps_PASS, Nombre_Dueno_web, Apellidos_Dueno_web, Hosting_PhPmyadmin_User, Hosting_PhPmyadmin_Pass, Hosting_PhPmyadmin_IP, TLF_1_AUT, TLF_2_AUT, TLF_3_AUT, Facebook_1, Facebook_2, Facebook_3, Tipo_Plan, nameserver, UserWP, PassWP, Skype, Discord)
  7. VALUES
  8. (New.Email, New.Whatsapp, New.Prefijo_Whatsapp_Country, New.IP, New.SQL_USER, New.SQL_PASS, New.MyIP_Web, New.MySQL_USER, New.MySQL_PASS, New.Usuario, New.Contrasenia, New.Status, New.Verifi, New.DEV, New.Contrasenia_panel, New.activo, New.web_host, New.tipo_panel, New.fecha, New.vps_USER, New.vps_PASS, New.Nombre_Dueno_web, New.Apellidos_Dueno_web, New.Hosting_PhPmyadmin_User, New.Hosting_PhPmyadmin_Pass, New.Hosting_PhPmyadmin_IP, New.TLF_1_AUT, New.TLF_2_AUT, New.TLF_3_AUT, New.Facebook_1, New.Facebook_2, New.Facebook_3, New.Tipo_Plan, New.nameserver, New.UserWP, New.PassWP, New.Skype, New.DiscordNew.);
  9. END
  10.  
  11. END
  12. ;;
  13. DELIMITER ;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top