Page 1 of 1

working with Q&A captcha Answers?

Posted: Sun Dec 04, 2016 8:18 pm
by matrixer
Hi folks,

is someone able to help here?

I would like to have some of my user their username as a possible answer for the Q&A plugin, so they can invite people and give them access with their own username.

Question 1) Is there an easy way to 'insert' all usernames of a specific group as captcha answers?

Question 2) Is there a way to record the given answer somewhere unter the user in sql?

Needless to say I hate playing with the DB as I am afraid to break everything... and I have no idea where to start... so if someone has maybe already such or a a similar solution - please let me know?

Thanks in advance

Re: working with Q&A captcha Answers?

Posted: Sun Dec 04, 2016 8:20 pm
by Lumpy Burgertushie
only one user can have a username at a time.
not sure what you are trying to accomplish.
maybe do a search in the extensions forums for "invite" or "invatation" extension.


robert

Re: working with Q&A captcha Answers?

Posted: Sun Dec 04, 2016 9:13 pm
by stevemaury
He wants the referring member's username to be the Q&A answer.

How about just giving the members a code number they can give out that is the answer to the Q&A ("Enter membership referral code")? If you want to credit a member with the referral, add a Custom profile field (Username of member who referred you).

Re: working with Q&A captcha Answers?

Posted: Sun Dec 04, 2016 10:51 pm
by matrixer
Hi guys,

Thanks for beeingso swift...

stevemaury: this is a absolute minimalistic solution - what about a more "sophisticated" solution as described in my initial post - is anyone able and willing to guide me to this solution?

Re: working with Q&A captcha Answers?

Posted: Mon Dec 05, 2016 12:18 am
by Lumpy Burgertushie
you may find that some people don't really understand what you are trying to do.

my guess above and then steve's guess apparently didn't quite hit the mark.


to me it sounds like you are trying to do something that phpbb is not realy designed to do.

that doesn't mean it can't be done, it just may mean that it will take a lot of coding and changing etc.


robert

Re: working with Q&A captcha Answers?

Posted: Mon Dec 05, 2016 4:02 am
by stevemaury
Make your Q&A question "Enter referring member's username."

Then run the following SQL ( Executing SQL Queries in phpMyAdmin ):

Code: Select all

SELECT username FROM phpbb_users WHERE user_type <> 2;
If your table prefix is not phpbb_ change accordingly.

Export the output of the query as CSV, open the output in a text editor and replace the commas with a carriage return/linefeed. Then paste the resulting list into the Q&A Answers box.

As you get more referred members, you will have to add their usernames. Just rinse and repeat the above.

Re: working with Q&A captcha Answers?

Posted: Mon Dec 05, 2016 9:19 am
by matrixer
Heeheheey Stevemaury.... it works!!! Thank you thank you thank you :-)

Part 1 accomplished - how difficult would it be to create Part 2?

Basically I could create an additional field in the user table.. I am sure I can find out how, but can you help me writing the code to "save" the newly registered user's answer in that table, so I can check who invited who?

Lumpy, I can understand your point of view... but isn'it that almost everyone here is trying to do something with phpBB which by design the standard install is not able to... I mean that explains the ext section.

And apart this... is not everyone here trying to offer their user the "ahaaa effect" - meaning: fulfilling their wishes while designing the best website (or web service) of this planet :-)

Or is this the behavior of a Wix customer hahahaha... let me know what you think!

And apart this: I don't believe any of my requests for support or design are far-fetched - I don't believe I have this creativity... no, I think these are things I saw somewhere on the internet and/ or people have told me of these ideas. No more no less :-)

Re: working with Q&A captcha Answers?

Posted: Mon Dec 05, 2016 4:33 pm
by stevemaury
Not as elegant, but much easier would be to add a required custom profile field on the registration page where the registrant must also enter the referring member's username. Then a query would give you all the referral info.

Re: working with Q&A captcha Answers?

Posted: Sun Dec 11, 2016 10:03 am
by matrixer
Hi Steve

Is there any code I can apply so the Q&A answer will be written in that custom profile field?

Thanks
Matrixer

Re: working with Q&A captcha Answers?

Posted: Sun Dec 11, 2016 5:34 pm
by stevemaury
Probably, but that would be an extension request. We are now (if we weren't before) beyond the scope of basic phpBB support. I think you are getting involved in lot of work for not much return. Registering users already have to confirm their password and their email. Is it really so hard for them to type in the referring username twice? They could just cut and paste.

Re: working with Q&A captcha Answers?

Posted: Mon Dec 12, 2016 8:56 am
by matrixer
ok.. I have requested an extension and hopefully someone has mercy :lol: