only existing username/email can register account

[mr_snappyz]

Hi,

Is it possible to use Joomla 1.7 and Fabrik 3 to allow account registration only for users who their username/email is already in database?

I want to create 'online peer review app' for my school...
this app required student to mark/review only members of their group.
This mean, 1 group have 5 members,total groups is about 10.
So i wanted to use J1.7 ACL/group features and fabrik 3..it should be just a simple app..

any advice?

 

[cheesegrits]

When you say "already in database", do you mean in the Joomla user table, or some other table?

-- hugh

 

[mr_snappyz]

Thanks for your respond Hugh.

I have a list of student name and email ,matrix no. etc in excel, so i think i'll import them in other table.

 

[mr_snappyz]

Any idea how to do this? Thanks..

 

[mr_snappyz]

Friendly bump

 

[rob]

you would have to use the php validation plugin and roll your own database query to work out if the name/email was stored in your lookup table. Return true if it is, otherwise return false.

The php validation would be something along the lines of this:

$db = JFactory::getDbo();
$q = $db->getQuery(true);
$q->select('count(email)')->from('yourlookuptable')->where('email = ' . $db->Quote($data);

$db->setQuery($q);
return $db->loadResult() == 0 ? false : true;

 

[mr_snappyz]

Thank you very much Rob..I'll give a try..