SecurityAssist 'users.sql' file

Dear Jason, Ray or Anna,

Please could you help us out a little bit when you get a moment?

When you purchase Security Assist, there are some tutorials to work through which use the blue_sky_music.sql database as the practice database.

In the tutorial videos it refers to a 'users' table which is required to proceed with the tutorial. The blue_sky_music.sql doesn't have a 'users' table, and the solution pack available from WITHIN the SecurityAssist support files page doesn't contain a 'users.sql' file to help create the table.

Maybe this is intentional to encourage us to investigate creating tables in mySql ourselves, but it might be useful to have the SQL included in the pack that is available from WITHIN the SecurityAssist support files area - or better still, to have the table already available in the blue_sky_music.sql so that the tutorial videos may be followed through without having to sort this out.

I have been adapting the users.sql available in the User Registration Solution Pack which is a seperate download (for me, anyway) on my mywebassist/downloadcenter page.

It just took quite a while to find it. I think this would be helpful.

Thanks

You can use the Visitors table that is included in the Blue Sky music SQL file.

Neil,

We have a number of different Solution Recipes for our products that use the Blue Sky Music database. However, some of these Solution Recipes were created quite a long time ago, and the database may have changed slightly. In most cases, a simple question such as "where is the users table?" here on the forums, would guide you in the appropriate direction. You should probably avoid directing posts to specific WebAssist employees since there are a number of Community Experts here that could be helpful and get you a response faster.

Also, keep in mind that the User Registration Solution Pack, is not included with the purchase of SecurityAssist or the Extension Library, so the Solution Recipes for SecurityAssist may not lineup perfectly with the database the Solution Pack uses. Although, the process should be the same, and you should still be able to succeed.

We are working hard to improve documentation and streamline Solution Recipes to be more helpful. However, we have a lot of them and they can take some time to update, so you may still see some minor inconsistencies in the near future.

Many thanks Neil,

I appreciate your reply, informative, helpful, and explaining the situation without making me feel like an idiot. The problem I have been having - and why I have been getting so wound up in regard to:

Originally Said By: Neil Beadle

  In most cases, a simple question such as "where is the users table?" here on the forums, would guide you in the appropriate direction.  

can be demonstrated - I think - at this thread: showthread.php?t=4994 , where such an enquiry leads to a maze of misinformation - and not the straight-forward informative reply that you suggest. I admit to my part in that.

I think you are absolutely right, and in any thread, a reply like yours will be entirely welcome and appreciated by me. It just doesn't seem to pan out that way with some of the other threads.

Anyway, thanks for that. Now I have to go off and contemplate the depressing prospect of climbing off my high-horse and showing a little humilty following some disaterously over-reactionary posts I've made, and (still only slightly at this early stage) regret.

Cheers,

Neil H

Well I'm just a little tired of you playing judge and jury over the competence of the people trying to help, so I'm going to spend my time elsewhere until you get yourself straightened out. It's impossible to carry on a helpful thread with someone when someone else keeps butting in and derailing it.

Sorry we don't live up to your standards.

To Neil,

I had a bit of confusion with this too, but I cannot ever criticize the web assist team because they are the most helpful compared to other sites that I have downloaded extensions from. Most of the other companies don't even have a help forum, or help of any kind, I won't give names.

Anyway I worked out that the solution recipie uses two different sites.

The first section of the solution recepie "security assist wizard tutoral" uses the users table that is unfortunately not available for download. This section of the tutorial describes the process of allowing users to register themselves on the site.

The second section of the solution recipie "access levels" uses a visitor table and has it's pages created by data assist. This is for if you want to control user registration and assign password and user names for user. When creating the pages this way you would need to assign SHAI ENCRYPTION during the data assist wizard and afterwards use security assist wizard to create the login and logout pages.

But back to the main issue you can recreate the user table like this

log into mysql adminstrator>
create a new table>

the table field look roughly like this

userID Not Null INTEGER Auto Increment PRIMARY KEY
firstname Not Null VARCHAR(60)
lastname Not Null VARCHAR(60)
username Not Null VARCHAR(60)
password Not Null VARCHAR(40)
userLevel Not Null INTEGER

userLevel will be a foriegn key, so you would also need to create the userLevel table

userLevelID Not Null INTEGER Auto Increament PRIMARY KEY
description Not Null VARCHAR(100)

the user level entries should be-

1. Visitors
2. Power Users
3. Administrators

This is how access values are recognised when you apply access levels.

Hope this helps

Many thanks for that jenkolaka,

I'll save this post for a little later. I'm not sure people understand just how technically incapable I am. I haven't got to grips with foreign keys and the like yet, but have ordered a couple of books to hopefully get me going!

(I honestly didn't expect to have to know this stuff).

I'll have another bash at it when I learn a bit more from the books, and feel able to ask questions here in the hope of understanding the answers.

Your post looks like it will be perfect for when that time (hopefully) comes. I have copied and pasted it into a text file, and put it in my Security Assist folder for later. I appreciate the time and attention you put into it.


Office Guy,

Helpful threads are all I'm after. I'm sorry you see a search for clarity as butting in and derailment. I can't help that; perhaps when you're less tired, you will be able to appreciate that. As I've said before, I do appreciate the help you've given and your input to the threads. Incidentally, in the thread I assume you are referring to, my input resulted in confirmation that a certain file - referred to in a tutorial - did not in fact exist, and successfully elicited advice on an alternative solution, whereas your input comprised insisting that the non-existent file did in fact exist. So I'm confused as to your definition of derailment. Perhaps you should review it. You should perhaps also say 'I' rather than 'we' regarding standards.

Neil H

Your welcome Neil,

If you need any more help, just post. I am a beginner too so it may be easier to explain things more in-depth simply because I know the exact problem you are having.

Good Luck