Support A2Billing :

provided by Star2Billing S.L.

Support A2Billing :
It is currently Thu Mar 28, 2024 9:50 am
VoIP Billing solution


All times are UTC




Post new topic Reply to topic  [ 12 posts ] 
Author Message
 Post subject: One user can signup multiple times with same email address
PostPosted: Mon Nov 24, 2008 1:10 pm 
Offline

Joined: Sun Nov 23, 2008 12:36 am
Posts: 12
Hello,

I spent a few hours searching the forum for an answer to this question, but no luck. I am using the current stable verison A2B 1.3.4. In this version, a single user can signup multiple times with the same email address and same account details like Name, address, phone.....

Is there a way to have the A2Billing sign up interface check the database of existing users and prevent users from signing up again with the same email address multiple times? If not, one user with one email address can signup 10 times to get the promotional free minutes if any.

Regards,
Coolreddy


Top
 Profile  
 
 Post subject:
PostPosted: Mon Nov 24, 2008 5:03 pm 
Offline
Moderator
User avatar

Joined: Thu Jun 22, 2006 2:19 pm
Posts: 2890
Location: Devon, UK
I thought we'd fixed this years ago, but I can find no evidence of that having happened. :-(

The most closely related thread here touches on this topic and then peters out.

For a quick fix you could try adding an 'unique' index to the 'email' column in the 'cc_card' SQL table.


Top
 Profile  
 
 Post subject:
PostPosted: Tue Nov 25, 2008 12:34 am 
Offline

Joined: Sun Nov 23, 2008 12:36 am
Posts: 12
Thanks Stavros! But I have to admit that I am a newbie when it comes to modifying SQL tables. I am a sysadmin and I know just the basics of creating/importing/exporting databases and users. But I am a fast learner.

I would really appreciate if you can give some more steps on how I should go about doing this. These steps need not be the exact commands with the right syntax. Something like a pseudo code would work for me. That way, I don't end up messing my SQL tables. Of course I would do it on a test system first.

Thanks again,
Coolreddy.


Top
 Profile  
 
 Post subject:
PostPosted: Tue Nov 25, 2008 12:48 am 
Offline
Moderator
User avatar

Joined: Thu Jun 22, 2006 2:19 pm
Posts: 2890
Location: Devon, UK
I'm not a big MySQL user but I imagine it would look something like this:
Code:
ALTER TABLE cc_card ADD CONSTRAINT cc_card_email UNIQUE(email);


Top
 Profile  
 
 Post subject:
PostPosted: Wed Nov 26, 2008 2:15 am 
Offline

Joined: Wed Feb 13, 2008 11:11 am
Posts: 224
Thanks very much Stavros,
i have succesfully added unique index to the email colum using phpmyadmin. Any attempt to use same email as already registered is prompting error "Sorry the confirmation email has been sent already, multi-signup are not authorized! Please wait 2 minutes before making any other signup! will look into this to try auto-redirect to a custom page.

Thanks So much Again Man, we have learned alot from you and you have been there to help.
God Bless You


Top
 Profile  
 
 Post subject:
PostPosted: Wed Nov 26, 2008 2:28 am 
Offline

Joined: Sun Nov 23, 2008 12:36 am
Posts: 12
Hi Manugmedia,

That's great it's working for you. Thanks to Stavros for his excellent support!

I have a quick clarification. So you just ran the commad stavros gave "AS IS" and that's it? Nothing else? If I do the following steps would that suffice?

1. mysql -u root -p <password>
2. use <a2billingdb>;
3. ALTER TABLE cc_card ADD CONSTRAINT cc_card_email UNIQUE(email);

Is that it? Please let me know if you had to change anything else.

Also, after this change, if I see an issue and want to revert back to the original setup without the unique email, is there a command to undo this "ALTER TABLE" command?

Regards,
Coolreddy.


Top
 Profile  
 
 Post subject:
PostPosted: Wed Nov 26, 2008 9:48 am 
Offline

Joined: Wed Feb 13, 2008 11:11 am
Posts: 224
Hi Coolready,

the following steps would that suffice?

Quote:
1. mysql -u root -p <password>
2. use <a2billingdb>;
3. ALTER TABLE cc_card ADD CONSTRAINT cc_card_email UNIQUE(email);

Is that it? Please let me know if you had to change anything else.

Sorry Man, the way i have done it is i have phpmyadmin installed on my test server as am yet to learn php.
Once you lauch phpmyadmin, this is the actions i took:

Click on Databases > ma2billing > cc_card > (when here click on browse action) > on top menu click on structure (go down to email field and on our right hand side you will see an action to asign unique index, next to primary index. Click on the "unique" action and you are done. Hope this helps you Man.

I will edit signupconfirmation.php later today to redict the customer back to signup page and display an error message.


Top
 Profile  
 
 Post subject:
PostPosted: Mon Feb 02, 2009 9:16 am 
Offline

Joined: Fri Jan 23, 2009 10:43 am
Posts: 28
Hi all,
I have still the problem that multiple users can register in a2billing with the same mail.
Can anyone help me? I'm trying to install and use phpmyadmin but I'm new in this and I'm not yet able...
Can anyone send me the MySQL file correctly edited for signup once with one mail?
thanks


Top
 Profile  
 
 Post subject: Re: One user can signup multiple times with same email address
PostPosted: Sat Jun 06, 2009 10:55 am 
Offline

Joined: Fri Jan 18, 2008 9:54 pm
Posts: 135
Hello,

Please refer to This


Top
 Profile  
 
 Post subject: Re: One user can signup multiple times with same email address
PostPosted: Tue Jun 09, 2009 8:29 am 
Offline

Joined: Fri Jan 23, 2009 10:43 am
Posts: 28
Swift wrote:
Hello,

Please refer to This


thanks you for your reply...

but I have a question: I found file Class.FormHandler.inc.php in different folders:
/var/www/html/a2billing/lib/Form/Class.FormHandler.inc.php
/var/www/html/a2customer/lib/Form/Class.FormHandler.inc.php
/opt/A2Billing_UI/lib/Form/Class.FormHandler.inc.php
/opt/A2BCustomer_UI/lib/Form/Class.FormHandler.inc.php

which of this 4 files I have to modify?


Top
 Profile  
 
 Post subject: Re: One user can signup multiple times with same email address
PostPosted: Tue Jun 09, 2009 2:39 pm 
Offline

Joined: Fri Feb 27, 2009 5:43 pm
Posts: 33
Location: Germany, Berlin
I guess your files in /opt are the source files...

I would say /var/www/html/a2billing/lib/Form/ is the right location as the signup module is part of the Billing portal and not of the CI.

...


Top
 Profile  
 
 Post subject: Re: One user can signup multiple times with same email address
PostPosted: Tue Jun 09, 2009 3:00 pm 
Offline

Joined: Fri Jan 23, 2009 10:43 am
Posts: 28
sschluet wrote:
I guess your files in /opt are the source files...

I would say /var/www/html/a2billing/lib/Form/ is the right location as the signup module is part of the Billing portal and not of the CI.

...


ok, I'll try to modify file in /var/www/html/a2billing/lib/Form/ folder and I'll update you :)


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 12 posts ] 
VoIP Billing solution


All times are UTC


Who is online

Users browsing this forum: No registered users and 4 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group