Web Hosting Forum | Lunarpages


*
Welcome, Guest. Please login or register.
Did you miss your activation email?



Login with username, password and session length
May 24, 2012, 09:57:28 AM

Pages: [1]   Go Down
  Print  
Author Topic: Web Protect "Database" Question - Alphabetical Ord  (Read 382 times)
ethanw
Pong! (the videogame) Master
*****
Offline Offline

Posts: 21


WWW
« on: May 28, 2003, 01:40:53 PM »

I guess this is topic is neither here nor there, but it fits better into security than databases.

I have a list of subscribers to my site in Web Protect. Is there any way to get that list in alphabetical order??? Every time I have to delete a subscriber, I have to scroll through the entire list and hope that I can find it.
Logged

nathanf
Spacescooter Operator
*****
Offline Offline

Posts: 45


« Reply #1 on: June 12, 2003, 09:08:51 AM »

Hi,

Out of curiosity, how many users do you have in your list?

You could try going into the "passwd" file that is located at / .htpasswds / main /  and then copy all of your users and passwords out of there, put them into a spreadsheet program such as Excel and then alphabetize them by username, then copy that back into your "passwd" file again. But first you have to separate the usernames and passwords into columns. So I recommend first copying the contents of the "passwd" file into a text file (minus the period at the end of the password for your very last person so that you can add that back in when you put the ordered list back intot he "passwd" file again), save that, then open it up in your favourite spreadsheet program, but all I have is Excel, so what you do in that program is when you open the text file you'll get a pop-up window to help you import the file, leave all of the defaults (delmination, etc) and hit Next, then for separation leave the tabulation box checked and then click other and put in the : (colon) it will then show you the split, neatly putting your usernames and passwords into separate columns, then hit Next, leave the default, and then Finish. That's it for that part.... then highlight your two columns, then click on the Data menu, and the first option you get is Sort, click that, sort by column A ascending, hit OK, and your entire list has been alphabetized. Copy all of that, put it back into your "passwd" file and stick the period at the end of it, then upload it back to right place and you should be all set. In the future you can just do all of your user management in your spreadsheet  Smile

Yeah, I know that perhaps this looks like a drawn out process, but it's all I could think of and once you know how to do it, it's quite fast to do.

Please don't forget to tell me how many people you have in your list because I'm on the verge of doing what you're doing or getting a php solution set up.

Cheers,
Nathan
Logged
ethanw
Pong! (the videogame) Master
*****
Offline Offline

Posts: 21


WWW
« Reply #2 on: June 12, 2003, 09:22:16 AM »

There are 330 on the list. I'll use WordPerfect to do the sort since it can sort two columns while keeping the password along with the username (or vice versa). But first I have to find / .htpasswds / main /

Thanks for the reply. I'll tell you how it turns out in a day or two. Deadline for new article is tomorrow: first things first.

Ethan
Logged

nathanf
Spacescooter Operator
*****
Offline Offline

Posts: 45


« Reply #3 on: June 12, 2003, 09:41:08 AM »

Quote
first things first


Ah! A 7 habits man! Good stuff!  Very Happy

To find /.htpasswds / main /  is very straight-forward. Probably easiest if I explain how to find it by using CPanel. Open up CPanel, then File Manager, and then .htpasswds should be the second directory that you see, right underneath .htmltemplates.

Wow! 330 people on the list! I had read that one can only use a password protected folder for a max of 50... guess I was mis-informed. When you are done that article that you are working on, I would be grateful to hear how you manage your users... did you assign all of your users a random password, and when you first started it up, how did you tell all of them what their username and password would be? As it stands, I've about 100 users that I would need to make passwords for and then send EACH of them a unique email to tell them their login info. What did you do?

Thanks,
Nathan
Logged
ethanw
Pong! (the videogame) Master
*****
Offline Offline

Posts: 21


WWW
« Reply #4 on: June 12, 2003, 10:03:37 AM »

Thanks, Nathan, I've blocked and copied your first line and emailed it to myself. (My email files are an amazing conglomeration of almost 8 years worth of "notes to self," most now indecipherable.)

As for how I set usernames and passwords for my subscribers, it has to do with "personal" information that they send when thet subscribe to my site. It can be a combination of name and company or names and dates. I set them: they don't have a choice. And I already use Quattro Pro (a Corel spreadsheet) to keep track of the database. Actually, there are two spreadsheets, one with current subscribers and one with those who haven't renewed. And, obviously, you can have more than 300. I wish I had 500 except for the demands that subscribers get to make on me as part of their subscriptions. (See web site - benefits of subscriptions.)

As for Steven Covey, I predate him and 6 of his ideas by about 20 years. Nothing new under the sun. Take stimulus-response psychology of the 40's for example. Goes back to Isaac Newton and his cookies: for every action, there's an equal and opposite reaction. Now if I could only parlay all of this into a small fortune...

Ethan
Logged

Pages: [1]   Go Up
  Print  
 
Jump to: