ceinj
Posts: 10
|
| Posted: 04/04/2011, 9:11 AM |
|
I have two types of users - dealers and vendors. I want to validate their login with different tables. It seems that CCS wants to use only a single table per project for validation. And CCS seems to put the code in the common library in the root location.
So I split my code into two projects but because the two projects share the same "root" location on my server. The login procedures in each project overwrite each other.
Can this be done?
I'm using CCS 3.2.0.6 Has this been fixed in a later version?
Can I get security code to accept an SQL statement instead of a table?
|
 |
 |
jjrjr2
Posts: 131
|
| Posted: 04/04/2011, 1:10 PM |
|
Hot to sure why you would want to do this...
CCS sopports security groups for users so you could have dealers & vendors all in one table.
Why do U want 2 tables???
_________________
John Real - More CodeCharge Studio Support at - http://CCSElite.com
Real Web Development At: http://RealWebDevelopment.us |
|
|
|
ceinj
Posts: 10
|
| Posted: 04/04/2011, 1:50 PM |
|
Reasons for 2 tables:
1. Legacy data with login creditial in each file/table
2. Dealer & Vendor data similar but not identical so a single table would waste a lot of space
3. Add a third table just for security seems like as much work to keep it synchronized that to get this to work like I want
4. If I could use SQL in security module, it would make the 2 files look like one.
|
|
|
|
damian
Posts: 838
|
| Posted: 04/04/2011, 3:00 PM |
|
the only simple way to do this is to have the login page and base code in separate sub directories. that is at least what i do. i have seen other far more complex methods if you search these forums.
_________________
if you found this post useful take the time to help someone else.... :)
|
|
|
|
ceinj
Posts: 10
|
| Posted: 04/04/2011, 3:15 PM |
|
I've tried to put the code in subdirectories but result was unsuccessful. Could you share the steps you took to do that?
|
|
|
|
damian
Posts: 838
|
| Posted: 04/04/2011, 3:43 PM |
|
sorry - i created two projects one in a sub directory.
there are common areas they can both access - keep your security groups distinct across both tables.
the session variables are for the server not a sub directory so if i login on either vendor or supplier it will still create CCUserID and CCGroupID etc which if set correctly will allow me access to the appropriate pages and content.
_________________
if you found this post useful take the time to help someone else.... :)
|
|
|
|
damian
Posts: 838
|
| Posted: 04/04/2011, 3:47 PM |
|
Quote ceinj:
Reasons for 2 tables:
1. Legacy data with login creditial in each file/table
2. Dealer & Vendor data similar but not identical so a single table would waste a lot of space
3. Add a third table just for security seems like as much work to keep it synchronized that to get this to work like I want
4. If I could use SQL in security module, it would make the 2 files look like one.
additionally -
1. is the legacy data still updated from other sources? if not unshackle yourself...
2. lots of wasted space is probably really not that relevant. the db is very efficient - if you are wasting a little space it probably has no significant affect on performance, scalability or real disk usage...
3. it might be a lot of work - ccs might save you enough time to make that worthwhile?
4. sorry - beyond me :)
_________________
if you found this post useful take the time to help someone else.... :)
|
|
|
|
deepakraj011
Posts: 4
|
| Posted: 04/05/2011, 3:57 AM |
|
poda punnaku pasangula
|
|
|
|
