I recommend you having a look at netquery. You can download a xoops version from their website. I think it might be even better of what you are looking for... ;)

PS: it also helps agains spam. It's an amazing tool!

Regards

Ok, I think I should start from the beginning...

I'm trying to accomplish is to make a humble hack for having a "invite xoops only" like it is talked in this post.

So... Using the profile module that comes in xoops 2.4.4 installation, I want to add the necessary php lines in that module that would help me to compare "user_referal" (which is going to be an invitacion code filled by the user) with another database field named "user_refnumber" (that can be in the same table) and it's gonna be filled with an invite code generator (another module that Im trying to create).

Example of how it should work:

1) A registered user goes to the "module - invite generator"
2) He or she generates a random string of 5 letters and 2 numbers (or any other combination) that is stored in "user_refnumber"
3) The invitation string is sended by email to his/her friend
4) When his/ her friend is trying to sing up, the registration form (of the profile module) asks the friend for the invitation code.
5) The code that is filled by his/her friend (user_referal) is now compared with the one that the module generated (user_refnumber). If they are the same, the registration process can continue... If not, it stops.
6) After the email account confirmation of the new user, the stored "user_refnumber" is deleted from the data base.

I know how to do some of the things of this process with my very basic php knoweadge, but I need help comparing fields in the profile module and deleting the "user_refnumber" after the new user's email is confirmed.

I more or less have a future code for the "module - invite generator". It's from another source that is not xoops... still have to convert it.

Please, give me a hand on this. I will be glad to share any of the results that I can get (hopfully a new very crapy module that could evolve into something nicer...) ;)

Thank you =)

Keep reading the next post for the explanation of the idea "how the module should work"...

Hello there!

I was wondering if someone could give me a hint of how to compare a value in a created database field of the "profile" module on the register form (xoops 2.4.4) with another database field in a secure way..

For example:

1. I create the field named "user_referal" on "profile" module, that users are able to see in the register form (visible)
2. I create another field, that users cannot see, named "user_refnumber" (not visible)
3. On the register form, when users sign up, mysql compares "user_referal" value with "user_refnumber" value. If these values are not exactly the same the register process stops and a message is displayed

I have an idea of how to do it from an empty php document, but Im not sure how I could do it on xoops or in that xoops module and how to use its functions or variables. Any help/tips will be deeply appreciated.

Thank you in advance for your time!

Regards from Madrid (Spain)