Need to hire someone ASAP for an integration

[ladyfyre]

Ok all, I posted a request a few days ago for a two fold need....but one of those needs has just taken a major priority, and I now need it ASAP.

The attached file is a .pl script which is used for subscription access maintenance for a paid area. It is designed to work with an .htaccess file, but it is also designed with a db option in mind.

I need someone to find a way to tie this into the VB structure, so that on sucessful payment, the user is moved from one usergroup to another...and on expiration of their billing (or cancellation), the user is then put back into the "registered" usergroup.

PLEASE help me out on this one...I can pay via Paypal or Credit Card.

Actually...after looking one more time, this might not be so bad after all.....

It only really uses two validation variables: username and password. These do NOT have anything to do with the user's username and password that they use to access the boards. They are simply the payment verification info.

Sooooo......

If we can add two fields into the user's data table, for username and password, and get the .pl file to pass them to our vb database, then it would simply be a matter of setting up a "upgrade" page link in the user's profile which would ask them to confirm their payment username and passcode (although this would have to be set up so that no two board handles could be upgraded based on the same username/password combo from the payment module to prevent password sharing.

The confirm would upgrade them into the usergroup....and upon expiration of the account, the username/password would have to be looked up and the attached user account moved back into the registered usergroup.

[Paul]

I am so confused as to what you're trying to do :D

Where does the username/password combination confirming payment come from? Some sort of 3rd party billing site? Is that what this perl script integrates with?

Or does this perl file allow you to set access? Changing a user's usergroup is simple, requiring a few lines of code. Please help me understand this further.

P.S. - I don't particularly like the idea of charging for help :D

[ladyfyre]

Thanks for answering!!!!!! I was starting to lose hope....

The script works with a 3rd party billing site. When a person signs up for a membership, the site accesses that script, and the script is supposed to write the username & password (both randomly selected) to a data file which the .htaccess file calls to. Problem is, i am not trying to secure a directory....so the .htaccess method does NO good. What i am trying to accomplish, is to get the system to automatically upgrade a user to a set usergroup when they sign up, and then when the system deletes their access due to cancellation, have them returned to the standard registered users group.

[treszoks]

Since the user/pass from this script does not match the vb user/pass, how will you relate them together? I see a method of doing this, but it might require an additional script to work. I could alter the perl one to add the user/pass info to another db table. Then the vb person who signed up would go to another script to type in the user/pass for this account and it would automatically upgrade their vb usergroup. Deleting would be slightly more difficult, but it could probably be added directly to the perl script to alter the matching vb-stored user/pass info and modify their usergroup. Do you have the perl DBI installed so you can accesss mysql?

[ladyfyre]

To address the first question of how to relate them together:

Ok...my mind tends to work a little different, so feel free to correct me if i am wrong here (i am not a programmer, just a self taught webmistress who dabbles in picking up new stuff)....anyway, here is what i was thinking:

Add a field into the user data table to hold the subscription username value for that userid.

Upon signing up, the member is directed to a URL you determine in the verotel's site CP....preferably a private .htaccessed directory. In that directory, make the index.php a script which will ask them for 4 things: Their board username and password (although it would be great if it would auto-detect the ones who have cookies enabled), and their payment username and password (sent to them by verotel).

That script would confirm against the data file the verotelrum.pl script has already added them into, and in the case of the username/password matching, the system would add V-paymentID# into the paymentID field in their userdata....and upgrade them to the proper usergroup. In the event of a mismatch, it would simply give them a wrong password error.

On the removal of an account, it would simply search the userbase for the payment code from the field, and upon finding it, would delete the usercode, and move them back into the registered usergroup.

Don't know if any of this makes sense to anyone but me though.

Perl DBI?? i THINK so.....but honestly am not positive. This is, however a colocated server..and since i own it, i can add pretty much anything i need to.

[treszoks]

That's pretty much exactly what I said. Shouldn't be too hard to setup.

[ladyfyre]

very cool :)

thank you VERY much for looking into this for me!!!

[treszoks]

Were you wanting me to help you with this or do you have it taken care of?

[ladyfyre]

i definitely want you to help me with this!!!! please let me know what you need from me in order to get started.

[Scott MacVicar]

Or you could just add one column called membersareaaccess and use mod_auth_mysql so that they could use the same username and password :)

I sent you an icq amber in case you havent read it.

[wolfyman]

I posted a thread over at vb.com that shows a bit more on how verotel works - what's the status of this thread?

http://www.vbulletin.com/forum/showthread.php?t=192961