Comments by Gatsby29 - CodeProject

Gatsby29 3-Nov-18 13:13pm View

Deleted

Ok i figured out this one after few hours of trying. Its problem with movieurl. When i change movieurl in something alse, for example title, than it sudenly works. I dont know is it good way to do this but it works :)

Gatsby29 28-Sep-18 5:01am View

I alredy did that, and when i make new query to check version it say that i use 2017 version

Gatsby29 24-Jan-18 10:25am View

This is exactly what i needed

Gatsby29 24-Jan-18 9:40am View

Thank you guys it work good now. I just watched many tutorials and in each utotrial they do it different i want to achieve that i have Register and login form with hashed password, mail confirmation, password recovery and save it all in database with date time and login form with roles (admin and users) with option remember me. And after login i want to show user data like name , surname , profile image etc... Cant find anywhere this example so i must combine different tutorials and than from time to time i have problems when i dont know what to do. I have several projects where i test it.
If someone know some good place for good tutorials about my goal please post it, thank you a lot.

Gatsby29 24-Jan-18 8:33am View

Thank you mate for your concern and long answer. I am just beginner and i am trying to do this app for practice, later i will implement hashing and other stuffs. Just trying to make this basic login work right and i have problem in this if statement or filling data table i am not sure even with good sql command not working.

Gatsby29 23-Jan-18 14:10pm View

I am just trying to display user data from database, usually i use hash.

Gatsby29 23-Jan-18 12:21pm View

Thank you sir

Gatsby29 23-Jan-18 12:20pm View

Thank you sir i believe this is what i need but i am new in this so i dont know exactly how to use this on my example.

Gatsby29 23-Jan-18 10:58am View

USE [register]
GO
/****** Object: StoredProcedure [dbo].[Validate_User] Script Date: 23.1.2018. 16:58:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[Validate_User]
@Email NVARCHAR(20),
@Password NVARCHAR(20)
AS
BEGIN
SET NOCOUNT ON;
DECLARE @UserId INT, @LastLoginDate DATETIME

SELECT @UserId = UserId, @LastLoginDate = LastLoginDate
FROM Users WHERE Email = @Email AND [Password] = @Password

IF @UserId IS NOT NULL
BEGIN
IF NOT EXISTS(SELECT UserId FROM UserActivation WHERE UserId = @UserId)
BEGIN
UPDATE Users
SET LastLoginDate = GETDATE()
WHERE UserId = @UserId
SELECT @UserId [UserId] -- User Valid
END
ELSE
BEGIN
SELECT -2 -- User not activated.
END
END
ELSE
BEGIN
SELECT -1 -- User invalid.
END
END

Gatsby29 22-Jan-18 16:20pm View

Thank you a lot it works great

Comments by Gatsby29 (Top 10 by date)