Create function newid ( id int(8)) returns int(8)
begin
declare newid int(8);
select gs.user_id into newid from sjames_gssite.phpbb_users gs left join development.phpbb_users dev on dev.username=gs.username where (select username from development.phpbb_users where user_id = id ) = dev.username ;
return newid;
end