CB DB Lookup Field plugin 1.0 Released

rnomis
OFFLINE
New Member
Posts: 19
Thanks: 0
Karma: 0

12 years 1 month ago - 12 years 1 month ago #194158 by rnomis

Replied by rnomis on topic Re: CB DB Lookup Field plugin 1.0 Released

Hi Nick,

OK, managed to mangle my way through thanks.

I now have the table looking similar to the Wiki.

I have 4 registration codes and I have tested it out by registering a new member and all works smoothly.

I see that each code can only be used once.
What I want to do is for each different code, I want to create many users with different access. For example, everyone entering hello1 should be a Registered User and those entering hello2 should be editors etc.

Can it be done? If so, how can I do this?

Thanks

Simon

Last edit: 12 years 1 month ago by rnomis.

Please Log in to join the conversation.

nant
Team Member
OFFLINE
Posts: 25531
Thanks: 1834
Karma: 877

12 years 1 month ago #194187 by nant

Replied by nant on topic Re: CB DB Lookup Field plugin 1.0 Released

rnomis wrote: Hi Nick,

OK, managed to mangle my way through thanks.

I now have the table looking similar to the Wiki.

I have 4 registration codes and I have tested it out by registering a new member and all works smoothly.

I see that each code can only be used once.
What I want to do is for each different code, I want to create many users with different access. For example, everyone entering hello1 should be a Registered User and those entering hello2 should be editors etc.

Can it be done? If so, how can I do this?

Thanks

Simon

You should be able to create an auto action to do this. See tutorials for examples.

--
Nick (nant)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Tutorials + Search the forums
For more add-ons and support: Upgrade your membership
Links: Community Builder - Languages - Adv/Pro/Dev membership - CBSubs Paid Subscriptions - GPL Templates - Hosting

Visit my CB Profile - Send me a Private Message (PM)

Please Log in to join the conversation.

rnomis
OFFLINE
New Member
Posts: 19
Thanks: 0
Karma: 0

12 years 1 month ago #194194 by rnomis

Replied by rnomis on topic Re: CB DB Lookup Field plugin 1.0 Released

Thanks Nick I will look at this later.
I didn't explain very well in my question. Could I just clarify if each code can be used just once or can it be used more than once?
For example, if I just wanted one code for everyone to use for registration, I could just email it from an existing mailing list outside of Joomla.

From the example used in the Wiki, once a code has been used once, it cannot be used again.

Sorry to be a pain but sql is a bit of a mystery to me :-)

Simon

Please Log in to join the conversation.

nant
Team Member
OFFLINE
Posts: 25531
Thanks: 1834
Karma: 877

12 years 1 month ago #194198 by nant

Replied by nant on topic Re: CB DB Lookup Field plugin 1.0 Released

Just remove all references to userid in wiki.

This means your table does not need to have a userid column and your queries do not need to have the AND 'userid' = '0' parts and the 'userid' = '[userid]' part.

Please Log in to join the conversation.

rnomis
OFFLINE
New Member
Posts: 19
Thanks: 0
Karma: 0

12 years 1 month ago #194202 by rnomis

Replied by rnomis on topic Re: CB DB Lookup Field plugin 1.0 Released

Great, thanks for your help.

I need to ask a question about AutoActions as the example I looked at doesn't seem to work. I will go to the right forum.

I have started documenting the steps taken for the registration codes including screenshots and the Mysql statement needed to create the table. It may help people at my level to get started.

Would it help if I posted these? Where/how should I do this if you think this a good idea?

Please Log in to join the conversation.

nant
Team Member
OFFLINE
Posts: 25531
Thanks: 1834
Karma: 877

12 years 1 month ago #194204 by nant

Replied by nant on topic Re: CB DB Lookup Field plugin 1.0 Released

please start new thread in professional support area.

The following user(s) said Thank You: rnomis

Please Log in to join the conversation.

Moderators: beat, nant, krileon

Time to create page: 0.218 seconds

CB DB Lookup Field plugin 1.0 Released

Search

Login / Logout

Menu

User Menu