DELIMITER ;;
CREATE TRIGGER busqueda AFTER INSERT ON activas_ips FOR EACH ROW BEGIN
IF NOT EXISTS(SELECT IP FROM datos_Mall activas_ips WHERE IP = New.IP)
BEGIN
INSERT INTO aa_cloud_avanced
(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)
VALUES
(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.);
END

END
;;
DELIMITER ;