Page 1 of 1

Tracking Signed Up Users

Posted: Thu Aug 17, 2017 2:06 pm
by pigskin9798
Just curious how other commissioners are keeping track of the users that are signing up for your pool.
I am planning on running a Survival pool this year and I noticed that some important info gets encrypted within the database.

I wondering why the email address is getting encrypted? How am I supposed to contact people in my league when I can't see their email address?
Maybe I'm missing something - Is there an option to turn that off within the config file?

Let me know if you have any suggestions.
Thanks!

Re: Tracking Signed Up Users

Posted: Thu Aug 17, 2017 8:05 pm
by giz83
Login as Admin and edit the Account to see the current email address.
My Account ▼
> Edit Profile

Re: Tracking Signed Up Users

Posted: Sun Aug 20, 2017 7:39 pm
by raider_nation
I am not sure if this helps but I added a few mods to my site. One being a page to display all users, their email and Contact Information. Place it in your root directory. To access it, in the url enter yoursite.xxx/playerContacts.asp. If you know how to edit asp pages you can add it to the Administration drop down for the admin user.

-I can not add any attachment. Always says extension is not allowed. Any help?

zip it is.

Re: Tracking Signed Up Users

Posted: Sun Aug 20, 2017 7:48 pm
by philwojo
Try and zip the file up and add it. I don't allow .asp extension to be added as it could be used in bad ways.

Re: Tracking Signed Up Users

Posted: Mon Aug 21, 2017 7:29 am
by pigskin9798
Thanks raider_nation, I added it the administration menu.
I see it display 3 fields for Username, email, and Contact info.
Are you manually entering the Contact Information field or are you getting that info during the user sign up?

Re: Tracking Signed Up Users

Posted: Mon Aug 21, 2017 1:51 pm
by raider_nation
Yes, that is correct. On my sign up page I added a field (I used the Contact Info field) to require them to provide who invited them to join the pool. A "Invited By" field. That way I know who to track down and get their entry few. :D

FYI, I also have a page (work in progress) that will show me who has not made a pick for the week and the ability to send out an email to all of them.

Re: Tracking Signed Up Users

Posted: Thu Aug 31, 2017 2:23 pm
by kingmullet
raider_nation, I would love to get a copy of that page when you get it going. It would be a huge timesaver.

Re: Tracking Signed Up Users

Posted: Fri Sep 01, 2017 7:35 am
by kingmullet
raider_nation, do you have a copy of the signup page with that mod? Did you also add that field to the db as well?

Re: Tracking Signed Up Users

Posted: Mon Sep 04, 2017 10:16 am
by raider_nation
Here are my 2 pages. The signup page has a field called Invited By, I just store that in the db field Contact Info.

The page to list all users that have not made a survivor pick for the week works except for week 1. It does work after week one when all users are listed in the survivorstatus table. I am not good enough at sql to fix it. Any help re-writing that sql command would be greatly appreciated.

Re: Tracking Signed Up Users

Posted: Tue Sep 05, 2017 9:49 am
by kingmullet
nice!!!! Thanks buddy!