I want to be able to log in a database any transactions my users perform. For example logging in, requesting a page, downloading a resource, logging out etc.
What is the most practical way to code this? I was thinking of trying to use an include file which would have a function to add a log in the database for each page on the site or when a particular action is performed.
i would like to automitically log when a user signs in, presumably using a seperate Access database. Can anyone point to to a simple way of accomplishing this?
On my site when people log in it changes a field in my database from 0 to 1 the website reads in all users marked as 1 as online.
When the users log off it marks them back to 0 and they are marked as offline unfortunately most people never log off. Whats the easiest way to log them off automatically? I have included some of my code below: This shows the members online: Code:
How do we have a track of users who have logged in? I want to have a table of record with usernames and the status(logged in or logged out).
Whenever the user logs in, the status shud indicate he is logged in and when he logs out the status shud change accordingly. Does anybody know how to do this???
I am using asp codes to connect to my access database. But i have a query in mind. Will my database still work if more than 1 user is logon to edit the database records?
is this a permissions issue that happened at the server side When I go to one of the .asp pages it brings up the "malicious code" prompt,asking whether I should open or save the file. How do I make it so it just executes the file?
My database tables uses two users, namely dbo. and viss. so in sql server 2005, every table has the following name structure:
dbo.members viss.customers etc
In source code, sql queries are used without adding usernames. Like,
INSERT INTO members UPDATE customers
Now I get sql erros as 'invalid tablename members' to solve this I add username to query, like dbo.members. That would solve the problem, but is there an easier way to solve this? Because I'm working with a complicated application and it has allot of files, adjusting each query is an option but any other solution? Code:
I have a database that is setup with a messages table... I have been asked to modify the following script to do the following...
Message ALL Users or Message All Admins or Message Individual Users (with the option to select multiple users - such as 2 or 3) or Message Individual Admins...
The Database is designed with a User table and each user is assigned a "Type" such as "admin" or "user" - can anyone look at the following and give me an idea how to implement this function?
It needs to be setup where the admins and users are seperated so its ok to have two Options boxes that display a users section and a admin section..
I have an intranet which all staff have access to. All staff can log in to the intranet to amend their own personal info. Currently staff have seperate passwords for logging on to their machines (ie ACL on network server) and logging on to the intranet.
Is it possible to have someone automatically logged in to the intranet based on their windows username and password for the domain?
Just wondering if anyone else has tried this. I think I saw this as an option in ASP.NET but my intranet is built using ASP.
I want to create a page in ASP language which gives me information about currently logged users. I thought to do it by this way: when somebody will log in to page, there will be a value of this user id stored in the table among the other fields in the form which are filling in. After clicking on the button "Log off" the value of the user id will be deleted from the MS SQL Server 2000 database. I would do it, but I don`t know how to solve the problem when somebody will close the Internet Explorer window by clicking "x". Then the procedure of deleting a value of user id will not call, and this value will be still stored in the database, so I will not have actual state of currently logged users.Maybe there is another possiblity to do it?
I need to display information a list of Active users on a web site.I can do the count using the global.asa but need to display individual information about each "active user" without writing it all to a database and then pulling it out again.Info I need :
IP Address - Request.ServerVariables("REMOTE_HOST") The page they are on - Request.ServerVariables("SCRIPT_NAME") the page they were on - Request.ServerVariables("HTTP_REFERER")
Can I write this stuff into sessions and call them all out?
I need to authenticate users to enter in a NTLM-protected virtual directory,but I can't pop up a NT-login dialogue box - I can only do a web-based username/password form (my client is a "usability" firm!). After searchingand searching, I finally found up with this solution to use ADSI to authenticate users transparently:
http://www.eggheadcafe.com/articles/20010126.asp
I tried the script and I am able to authenticate that the user exists with the correct password, but when I redirect the user to the virtual directory,the popup box is still popping up! I think what is happening is that I am not actually passing the username/password to the NT server.
Is anybody familiar with using ADSI for NT log in's?Am I on the righttrack?And if so, how do I actually do this so that the NT login boxdoesn't pop up?
I am trying to create a website for students where they have to log in before they can access any of the materials on the site. Therefore the login will be done on the homepage. Providing log in is successful, I then want to be able to track which student downloads which materials. I know how to deal with the login code but am not sure when I create the session variables to track the users. Is this done on the following page? Also do I need to use the global.asa file?
does the session on start event happen the minute the student arrives at the homepage or can I tell it to start once the students have logged in? any advice will be gladly received.
We have an extranet located on one server that users access via a redirect on a URL. To access the extranet, they click on a link and have to enter their windows network logon details.
They then access the extranet which is based on Microsoft Sharepoint Services. I have written customised ASP pages, located on a second server on the same network, but want to use the same windows logon details.
how I create a login page which authenticates users against the servers user manager. I want the login to be a form in my website not a pop up window. I am currently running IIS 5 on a windows 2000 member server.
I'm developing an online shopping cart. Usually the site administrator modifies products etc in the "Store". I want a mechanism for the administrator such that he should be able to view or at-least count the customers or visitors in my "Store" (only in store), users of the other sections should not be counted.
Whenever a user in my store signs out or closes the browser (not properly sign out) or even leaves the "Store" the count should decrement.
I am trying to work out how to set up two counters on my site, one to track guest users and one to track registered users, like most forums show. There are loads of examples showing how to use the global.asa file to do a single active user count, but I can't find anything for my needs.
Has anyone come across such a script, or give me a clue how to write my own? All registered users are marked by a session variable called userLogged - which is true if they have logged in.
I have a login button on all my pages so that users can can login from any page they happen to be on. This is placed on the page using <!--#include file="left.asp"--> At the moment the actual login page always returns the user to the home page. It would be far better if after they had logged in sucessfully that they were sent back to the original page.Can anyone explain the best way to do this?
i am trying out the asp pages on PWS. since my comp is stand alone, desktop PC. i was wondering if i place these on a server and i provide appropriate link to my main asp page then how many users can access the same main page simultaneously? should a code be written for that too? is it only one user can access the (lets say) login page or many users can simultaneously access and query the database as they want to.
Is it possible (and if so how), to show a 'users online' counter on my site(VB ASP)?I have seen lots of site that say, xxx members online and xxx guests online. How can I do this?
Assume I have three types of users. Type I can only Read Posts. Type II can Read and Edit. And Type III can Read, Edit and Delete Posts.
Now to manage this, do I need to make three different users in my DB or should I just use ASP to determine that what permissions should every user have. For example, Type I users will not have the edit and delete button on thier screens and Type II users won't have delete button on their screens and Type three would have all three buttons.
Even if I make different users in my DB (assuming it's necessary for security), so how would I determine that what connection string should I connect a specific user with since we have to give the user name and password on the ADODB connection string?
I have an issue with handling concurrent users in asp page. The server is win 2003.
Asp page calls a dll developed in vc++ for displaying reports from oracle database. Application works fine for less than 10 users .but it fails with object cannot be intialized for more users.
I tested the same application in my m/c for load testing it supports 50 users without problem.
Iam wondering any settings at IIS or OS needs to be checked for supporting more users.