[CN - 2012] dbo.tMinorsPlaytime

[DentalFloss]

Anyway to turn it off beside manually adding someone to it?

[MentaL]

[hannesa]

Yes.
One of the easiest way to bypass this should be to alter the usp_China_getMinorsPlaytime procedure like this:

ALTER PROCEDURE [dbo].[usp_China_getMinorsPlaytime]
    @NuserNo int
,    @nRet    int = 0 output
AS
BEGIN
    SET NOCOUNT ON
    
    DECLARE @isAdult    bit = 1
    DECLARE @playtime   bigint = 0
/*    DECLARE @logoutDate datetime
    
    SET @nRet = 0
    
    SELECT @isAdult = bIsAdult, @playtime = nPlaytime, @logoutDate = dLogoutDate 
      FROM tMinorsPlaytime WITH(UPDLOCK, HOLDLOCK)
     WHERE nUserNo = @NuserNo
    IF @logoutDate IS NULL OR DATEADD(hour, 5, @logoutDate) <= GETDATE() BEGIN
        BEGIN TRAN
        
        SET @playtime = 0
        
        UPDATE tMinorsPlaytime 
           SET nPlaytime = @playtime
         WHERE nUserNo = @NuserNo
        IF @@ERROR <> 0 OR @@ROWCOUNT <> 1 BEGIN
            ROLLBACK TRAN
            SET @nRet = -1111
            RETURN
        END
        
        COMMIT TRAN
    END    */
    
    SELECT @isAdult AS bIsAdult, @playtime AS nPlaytime
END

But really, why you should disable it, why not simply use the given procedures to create a new User and automatically add those rows/values?
There are many predefined stored procedures to do all the tasks you need to do.

[Myth]

I'll be a nice guy today (good mood) and give you the low-down on the easier solution, aka SELECT 1, 0 use above but scrap everything and simply return with pre-defined data, saves tables/space in your database.



Tl;dr: Edit this to SELECT 1, 0

[hannesa]

Yes youre right but i thought that could be easier to learn from (maybe not).

[DentalFloss]

Thanks for all your help!

[fiestanerd69]

Closing this thread seeing as the issue has been resolved. @DentalFloss please use the thanks button next time.