auto action

I am a chat room

I want after register of user insert a row into chat room table

I can do by auto action ?

do must save 2 qery ?

select (internal) and insert(external) ?


select :

Type : query
Triggers : onBeforeFirstLogin
Access : All register users
Query :
declare @i int,@u nvarchar,@e nvarchar,@p nvarchar;
select @i='id',@u='username',@e='email',@p='password' from '#__users'

Mode : Internal


insert :

Type : query
Triggers : onBeforeFirstLogin
Access : Allregisteruser

Query :

declare @i int,@u nvarchar,@e nvarchar,@p nvarchar;
insert into 'pch_user' ('id','login','email','password') values (@i,@u,@e,@p)

Mode : External
Host : localhost
Username : name
Password : ppp
Database : ddd
Charset : utf-8
Table Prefix : jos_

Duplicate thread. Please see reply below.

www.joomlapolis.com/forum/153-professional-member-support/188799-about-auto-action#188799

Thread locked.