| Author |
 Topic  |
|
|
atonioz
Starting Member
Greece
4 Posts |
 Posted - 07 July 2009 : 05:30:27
|
Hello
I just "installed" Snitz Forum. I have a login question. I m using an aplication and i want my users through that one to press the link of snitz and auto log them into snitz using the same user name as the primary app.
Do i need to modify default.asp or some other ? any simple guidness would be really apreciated |
|
|
Etymon
Advanced Member
United States
2396 Posts |
|
|
atonioz
Starting Member
Greece
4 Posts |
Posted - 07 July 2009 : 07:22:49
|
Really everyone refer to another topic...i m searching for like 2 hours... no straight answer!! Has anyone done that or u still looking ?
ruirib told "The solution to your problem (which does not seem to be the mod (universal login), Etymon) can vary. You can change the code to use your data (can be a solution that needs some work from you) or, depending on the database to use, make your DB look like what the code expects it to be. This is more easily done with SQL Server, but can be possible with MySQL, though I must admit that I don't know the MySQL support for triggers and views that well.<"
Anyone done something similar, give some guiding where do edit the code ? a step to step or something :D |
 |
|
|
Roger Fredriksson
Average Member
Sweden
556 Posts |
|
|
Etymon
Advanced Member
United States
2396 Posts |
Posted - 07 July 2009 : 08:24:35
|
quote:
Originally posted by atonioz
Really everyone refer to another topic...i m searching for like 2 hours... no straight answer!! Has anyone done that or u still looking
You have been here so far for 2 posts, and you are already getting upset with anyone who tries to help because you can't get the code you want for free.
YOUR attitude is precisely why you can't easily find what you want ... because folks before you have also wanted things now and free and then gotten angry when they can get it. This has made the mod coders, even me, feel unappreciated!
Why should anyone do something for you for free if all you are going to do is bite the hand that feeds you? Come on, really?!
|
Edited by - Etymon on 07 July 2009 08:30:33 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
atonioz
Starting Member
Greece
4 Posts |
Posted - 07 July 2009 : 09:17:47
|
You got me wrong there Etymon , i m not getting upset or angry with anyone. I m just using simple english to describe my problem (cuz i come from a country that english isn't my mother language). Really sorry if i offended ya or anyone else, that wasn't my purpose. I didn't ask someone to do the work for me i just asked for a start.
Ruirib,
i m using a program(lets call it NAS). Nas has lots of users and each user have a username and a password, everytime a user logs in, a new sessionID is created each time in the DB(sql2005). Inside nas i want to attach a link to Snitz Forum. When the user press on the link i want to bypass the current login of snitz and automatically log him in with the same user name tha he has on NAS. I found a way of attaching the sessionID into the link
exmp. http://localhost/forum/default.asp?id={DAD89A30-D463-4398-8879-33D96F38827E}
I can use that sessionID to retrieve the user name with an sql query.
Now that i have the username, where do i have to work on to pass it into Snitz and by pass the login system. Shall i use the login.asp ?
and something last
from the
http://localhost/forum/default.asp?id={DAD89A30-D463-4398-8879-33D96F38827E}
how can i take only the code inside {}
something like :
fName = Request["id"].ToString() |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 07 July 2009 : 09:39:48
|
The problem is not just logging in. There are also stuff related to user's profiles, getting access to user ids and all, and there are a few files that access the snitz member tables. With SQL 2005, you could just create an adequate view and some instead of triggers to insert, update and delete records and no changes would be required to the Snitz code.
|
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
atonioz
Starting Member
Greece
4 Posts |
Posted - 07 July 2009 : 09:49:36
|
Well i created a view
create view FORUM_MEMBERS as
SELECT [SecurityUserID] as [MEMBER_ID]
,[ActiveFlag] as [M_STATUS]
,[UserName] as [M_NAME]
,[UserName] as [M_USERNAME]
,'e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855' as [M_PASSWORD]
, Spre.InternalEmailAddress as [M_EMAIL]
,'' as [M_COUNTRY]
,'' as [M_HOMEPAGE]
,'' as [M_SIG]
, 1 as [M_VIEW_SIG]
, 1 as [M_SIG_DEFAULT]
,1 as [M_DEFAULT_VIEW]
,'' as [M_LEVEL]
,'' as [M_AIM]
,'' as [M_ICQ]
,'' as [M_MSN]
,'' as [M_YAHOO]
,'' as [M_POSTS]
,'' as [M_DATE]
,'' as [M_LASTHEREDATE]
,'' as [M_LASTPOSTDATE]
,'' as [M_TITLE]
,'' as [M_SUBSCRIPTION]
,'' as [M_HIDE_EMAIL]
,'' as [M_RECEIVE_EMAIL]
,'' as [M_LAST_IP]
,'' as [M_IP]
,'' as [M_FIRSTNAME]
,'' as [M_LASTNAME]
,'' as [M_OCCUPATION]
,'' as [M_SEX]
,'' as [M_AGE]
,'' as [M_DOB]
,'' as [M_HOBBIES]
,'' as [M_LNEWS]
,'' as [M_QUOTE]
,'' as [M_BIO]
,'' as [M_MARSTATUS]
,'' as [M_LINK1]
,'' as [M_LINK2]
,'' as [M_CITY]
,'' as [M_STATE]
,'' as [M_PHOTO_URL]
,'' as [M_KEY]
,'' as [M_NEWEMAIL]
,'' as [M_PWKEY]
,'' as [M_SHA256]
,'' as [M_ALLOWEMAIL]
FROM [HC].[dbo].[SysSecurityUser] as SS
inner join [HC].[dbo].Person as Per on SS.UserPartyID =Per.PartyID
inner join [HC].[dbo].[SysSecurityUserPreference] Spre on Spre.UserPartyID=SS.UserPartyID
where [ExternalFlag]=0
i Inted to use
select sysSecurityUser.UserName
from sysSecurityUser
inner join sysSecuritySession on sysSecuritySession.UserPartyId=sysSecurityUser.UserPartyId
where sysSecuritySession.SessionID=' the one i will get from the link'
SOrry if im frustrating ya :D maybe i messed up my mind.
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 07 July 2009 : 09:55:23
|
| I would say that you will need more than that. For fields that don't exist on your database, I suggest that you create another table, with the missing fields and you will have to fill in some of those fields. Then add the instead of triggers to deal with the inserts, updates and deletions, cause some of the fields will have to be updatable. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
| |
Topic |
|
|
|
Topic Locked
