[SOLVED] Auto Actions insert in external DB - Solved

$option = array(); //prevent problems $option['driver'] = 'mysql'; // Database driver name $option['host'] = 'localhost'; // Database host name $option['user'] = 'XXXXXXXXXXX'; // User for database authentication $option['password'] = 'XXXXXXXXXXX'; // Password for database authentication $option['database'] = 'XXXXX_idevs'; // Database name $option['prefix'] = ''; // Database prefix (may be empty) $db = JDatabaseDriver::getInstance( $option ); $db = JFactory::getDbo(); // Get a db connection. $query = $db->getQuery(true); // Create a new query object. $columns = array('id', 'username', 'approved', 'f_name', 'l_name', 'email', 'type', 'level', 'signup¬_date'); // Insert columns. $values = array([userid], [username], 1, [firstname], [lastname], [email], 1, 1, date()); // Insert values. // Prepare the insert query. $query ->insert($db->idevaff_affiliates('XXXXX_idevs')) ->columns($db-> idevaff_affiliates ($columns)) ->values(implode(',', $values)); // Set the query using our newly populated query object and execute it. $db->setQuery($query); $db->execute();

INSERT INTO `idevaff_affiliates` (`username`, `approved`, `payable`, `f_name`, `l_name`, `email`, `address_1`, `city`, `state`, `zip`, `country`, `phone`, `type`, `level`, `signup_date`, `ip`) VALUES ("[username]", 1, "[name]", "[firstname]", "[lastname]", "[email]", "[address]", "[city]", "[state]", "[zipcode]", "[country]", "[phone]", 1, 1, NOW()+0, "[registeripaddr]"); INSERT INTO `idevaff_tiers` (`parent`, `child`) VALUES ("[cb_sponsor]", "[cb_member]");