Gossamer Forum
Home : Products : Gossamer Links : Pre Sales :

Re: SQL - Problem

Quote Reply
Re: SQL - Problem In reply to
The problem is more complicated:

I need only one passwort, together with ID (or maybe a second field secureID) i test, if someone is allowed to access.

But i need more than 1 place where he could go.

Cause i have a lot of work and wont stay at one small problem too long, i have this solutions (maybe a better one at the finish)

One special field (value comes from the category he is registered in) holding the main-access-area for a user.
For every other area i use only one field; if someone want access to other areas he could choose from a field-menu:
With javascript i should get a forminput like: 1-2-5, means he wants access to area 1,2 and five.

When user know want access he calls a script testing on ID and paassword then takes value from the first field:
if pool=1 then printout: http://gaga/1.htm
if pool=2 then printout: http://gaga/2.htm
...

Then take the field-value from access (here 1-2-5) and put values in an aray, sort them and do a loop:

if array 0 till end:
if array(i) = 1 then printout http://gaga2/1.htm
...


The clou on this is a special apache-mod asking for referer with .htaccess:
No referer - no access
referer=http://gaga - access


Maybe this is too much work, it will be possible to do in the next hours,
for doing new tables and the perl-code for this im still not good enough ...

Robert

But i will read about "normalizing" this morning befor going sleep :-)









Subject Author Views Date
Thread SQL - Problem Robert 3117 Jul 27, 2000, 4:21 PM
Thread Re: SQL - Problem
pugdog 3046 Jul 28, 2000, 11:56 AM
Post Re: SQL - Problem
Robert 3029 Jul 28, 2000, 4:22 PM