Re uploads/remakes

Bаne · 01/18/2012, 23:47

Hey guys, I know some devs are removing there stuff, this is hard on servers who really really need it...So I will re upload and remake what is removed, and post it here.

First off: IP ban: Information, bans IP's by table, was created by LittleProHacker, and I have made no changes to it, since none are needed...

Second: Dupe fix made by EC: Infromation, prevents dupeing on servers, was made by EC and has small changes made by me. To get this to work, just add in the parts that are missing to your DB.

Game login - Tawian

PHP Code:


			
USE [PS_UserData]

&#8230;

@UserUID        int = -1,
@LoginType      smallint = 1,
@LoginTime      datetime = NULL
 
AS
 
SET NOCOUNT ON
 
DECLARE 

@Leave         tinyint,
@Status         smallint,

@CompanyIP     varchar(15),
@TempIP     varchar(15),
@Check        int,
@LeaveDate  datetime

/*==================================================
-1    Invalid ID and Password
-2    Can't connect with the account since it's not selected as free challenger
-3    Account doesn't exist
-4    ID inprocess of termination follwing user's request.
-5    Your account is blocked now.  You can't log into the game.
-6    Your account is blocked now.  You can't log into the game.
-7    Account still restricted
==================================================*/
 
SET @Status =         -1
SET @LoginTime =     GETDATE()

--------------------------------------------------
SET @CompanyIP =     '61.107.81'
SET @UserIP =        LTRIM( RTRIM(@UserIP) )
--------------------------------------------------
SET @Check = 0
--------------------------------------------------

SELECT @UserUID=[UserUID], @Status=[Status], @Leave=[Leave], @LeaveDate=LeaveDate 
FROM Users_Master 
WHERE UserID = @UserID AND Pw = @InPassword

-- NotExist User OR Leave User
IF( @UserUID = 0)
BEGIN
    SET @Status = -3
END
ELSE IF (@Leave = 1) --This blocks a logged in account from being kicked
BEGIN
    SET @Status = -5
END
ELSE IF (DATEDIFF(SECOND, @LeaveDate, GETDATE()) < 6)--This is the time delay
BEGIN
    SET @Status = -7
END

...

-- Select 
SELECT @Status AS Status, @UserUID AS UserUID

-- Log Insert
IF( @Status = 0 OR @Status = 16 OR @Status = 32 OR @Status = 48 OR @Status = 64 OR @Status = 80 )
BEGIN
    UPDATE Users_Master SET Leave = 1, JoinDate = GETDATE() WHERE UserUID = @UserUID
END
SET NOCOUNT OFF

Insert action log -

PHP Code:


			
USE [PS_userdata]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER        Proc [dbo].[usp_Try_GameLogout_R]

@UserUID int,
@SessionID bigint,
@LogoutType smallint = 0,
@ErrType int = 0

AS
SET NOCOUNT ON

DECLARE @LogTime datetime
DECLARE @Sql nvarchar(4000)
DECLARE @yyyy varchar(4)
DECLARE @mm varchar(2)
DECLARE @dd varchar(2)
DECLARE @LogType bit    -- Login:0, Logout:1

SET @LogType = 1
SET @LogTime = GETDATE()
SET @yyyy = DATEPART(yyyy, @LogTime)
SET @mm = DATEPART(mm, @LogTime)
SET @dd = DATEPART(dd, @LogTime)

IF( LEN(@mm) = 1 )
BEGIN
    SET @mm = '0' + @mm
END

IF( LEN(@dd) = 1 )
BEGIN
    SET @dd = '0' + @dd
END

UPDATE Users_Master SET Leave = 0, LeaveDate = GETDATE() WHERE UserUID = @UserUID

UPDATE PS_GameLog.dbo.UserLog
SET LogoutTime=@LogTime, LogoutType=@LogoutType, LogoutErrType=@ErrType
WHERE UserUID=@UserUID AND SessionID=@SessionID

SET NOCOUNT OFF

Try Gamelogout

PHP Code:


			
USE [PS_GameLog]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER  Proc [dbo].[usp_Insert_Action_Log_E]

&#8230;

AS

DECLARE @CharLeave int

SET @yyyy = datepart(yyyy, @ActionTime)
SET @mm = datepart(mm, @ActionTime)
SET @dd = datepart(dd, @ActionTime)
SET @CharLeave = 1

IF @ActionType = '116'--Trade Item-remove item from originator
BEGIN
    WAITFOR DELAY '00:00:05'--Time delay to give the duper time to log out fully
    
    SELECT @CharLeave=Leave
    FROM PS_userdata.dbo.Users_Master
    WHERE UserUID=@UserUID

    IF @CharLeave=0
    BEGIN
        EXEC PS_GameData.dbo.usp_Save_Char_Item_Del_E @CharID=@CharID, @IDList=@Value1
    END
END

IF @ActionType = '164'--Trade Gold-remove gold from originator
BEGIN

    WAITFOR DELAY '00:00:05'--Time delay to give the duper time to log out fully

    SELECT @CharLeave=Leave
    FROM PS_userdata.dbo.Users_Master
    WHERE UserUID=@UserUID

    IF @CharLeave=0
    BEGIN
        UPDATE PS_GameData.dbo.Chars
        SET [Money]=@Value2
        WHERE PS_GameData.dbo.Chars.CharID=@CharID
    END
END

SET @Sql = N'
INSERT INTO PS_GameLog.dbo.ActionLog
(UserID, UserUID, CharID, CharName, CharLevel, CharExp, MapID,  PosX, PosY, PosZ, ActionTime, ActionType, 
Value1, Value2, Value3, Value4, Value5, Value6, Value7, Value8, Value9, Value10, Text1, Text2, Text3, Text4)
VALUES(@UserID, @UserUID, @CharID, @CharName, @CharLevel, @CharExp, @MapID, @PosX, @PosY, @PosZ, @ActionTime, @ActionType, 
@Value1, @Value2, @Value3, @Value4, @Value5, @Value6, @Value7, @Value8, @Value9, @Value10, @Text1, @Text2, @Text3, @Text4)'

EXEC sp_executesql @Sql, 
N'@UserID varchar(18), @UserUID int, @CharID int, @CharName varchar(50), 
@CharLevel tinyint, @CharExp int, @MapID smallint, @PosX real, @PosY real, @PosZ real, @ActionTime datetime, @ActionType tinyint, 
@Value1 bigint, @Value2 int, @Value3 int, @Value4 bigint, @Value5 int, @Value6 int, @Value7 int, @Value8 int, 
@Value9 int, @Value10 int, @Text1 varchar(100), @Text2 varchar(100), @Text3 varchar(100), @Text4 varchar(100)',
@UserID, @UserUID, @CharID, @CharName, @CharLevel, @CharExp, @MapID, @PosX, @PosY, @PosZ, @ActionTime, @ActionType, 
@Value1, @Value2, @Value3, @Value4, @Value5, @Value6, @Value7, @Value8, @Value9, @Value10, @Text1, @Text2, @Text3, @Text4

sondo81 · 01/19/2012, 00:10

why upload it again? Hundreds have loaded and 2-3 behind a thank you ....

I think it would be much more well-functioning server if some were simply grateful for what they get here for free!

My server works great for more than 12 months!

DDO attack like A. .. makes me not care

I mean if people here a little longer would hold together to share their successes and take other successes would like my anti DDO there would be more good than bad server day by day!

so long i dont share any of my .... sry

ip ban and ip range ban Fix!

webside ban and ip ban with range Fix!

DDo or synflood defence for win webserver 2003 and 2008 r2 Fix!

JohnHeatz · 01/19/2012, 07:07

What you say is true, yet, after noticing some of the "best" known admins/devs actually engaging a war against servers that oppose theirs, makes you wonder a lot of things.

We are here to help the community, not to start wars, and as far as someone can code something, it is legal, and old releases that were removed are totally free to be re-uploaded because at one time they were released so that means many people got them already and they can use them to help, it would be the exact same thing if they sent the files to their friends to help them.

sondo81 · 01/21/2012, 03:19

ok John i´ll will give alle my tool hints and secrets i know !

just ask for and i try to help!

Svinseladden · 02/29/2012, 15:42

from the first i get a few errors:

Quote:

Msg 102, Level 15, State 1, Line 3
Incorrect syntax near '&'.
Msg 137, Level 15, State 1, Line 34
Must declare the scalar variable "@LoginTime".
Msg 137, Level 15, State 2, Line 38
Must declare the scalar variable "@UserIP".
Msg 137, Level 15, State 1, Line 43
Must declare the scalar variable "@UserUID".
Msg 137, Level 15, State 2, Line 48
Must declare the scalar variable "@UserUID".
Msg 156, Level 15, State 1, Line 52
Incorrect syntax near the keyword 'ELSE'.
Msg 102, Level 15, State 1, Line 61
Incorrect syntax near '.'.
Msg 137, Level 15, State 2, Line 64
Must declare the scalar variable "@UserUID".
Msg 137, Level 15, State 2, Line 69
Must declare the scalar variable "@UserUID".
Msg 102, Level 15, State 1, Line 71
Incorrect syntax near 'OFF'.

'

and yea i know you said just need to add the stuff you don't have. BUT

i don't have @LeaveDate datetime at all. so this stuff never fit :-(

i think i tried all i can here but still not working.. this is mine

Quote:

USE [PS_UserData]
GO
/****** Object: StoredProcedure [dbo].[usp_Try_GameLogin_Taiwan] Script Date: 02/29/2012 06:41:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
/****** Object: Stored Procedure dbo.usp_Try_GameLogin_Taiwan Script Date: 2008-6-7 18:34:05 ******/

/*================================================= =
@date 2007-12-04
@brief Login Proc( Taiwan )
================================================== */

ALTER Proc [dbo].[usp_Try_GameLogin_Taiwan]

@UserID varchar(18),
@InPassword varchar(32),

@SessionID bigint,
@UserIP varchar(15),

-- 罹晦梱雖 ?蹂? 檣濠, 釭該雖朝頂睡滲熱

@UserUID int = 0,
@LoginType smallint = 1,
@LoginTime datetime = NULL

AS

SET NOCOUNT ON

DECLARE

@Leave tinyint,
@Status smallint,

@CompanyIP varchar(15),
@TempIP varchar(15),
@Check int

SET @Status = -1
SET @LoginTime = GETDATE()

--------------------------------------------------
SET @CompanyIP = '61.107.81'
SET @UserIP = LTRIM( RTRIM(@UserIP) )
--------------------------------------------------
SET @Check = 0
--------------------------------------------------

SELECT @UserUID=UserUID, @Status=Status, @Leave=Leave FROM Users_Master WHERE UserID = @UserID

-- NotExist User OR Leave User
IF( @UserUID = 0 OR @Leave = 1 )
BEGIN
SET @Status = -3
END
ELSE
BEGIN
-- Check Password
EXEC dbo.sp_LoginSuccessCheck @UserID, @InPassword, @Check output
IF ( @@ERROR = 0 )
BEGIN
IF( @Check <> 1 )
BEGIN
SET @Status = -1
END
END
ELSE
BEGIN
SET @Status = -1
END

/* Old
SET @InEnPassword = master.dbo.fn_md5(@InPassword)
IF ( @InEnPassword <> @EnPassword )
BEGIN
SET @Status = -1
END
*/
END

-- BlockUser Check
IF( (@Status >= 2) AND (@Status <= 6) )
BEGIN
-- Get Block Limit Date AND Replace date text
DECLARE @BlockEndDate datetime
SELECT @BlockEndDate = BlockEndDate FROM Users_Block WHERE UserUID = @UserUID
IF ( @@ROWCOUNT <> 0 )
BEGIN
-- Block Release
IF ( @BlockEndDate <= @LoginTime )
BEGIN
SET @Status = 0
UPDATE Users_Master SET Status = @Status WHERE UserUID = @UserUID
END
END
END

-- Admin IP Check(2006-02-21)
/*
IF( @Status = 16 OR @Status = 32 OR @Status = 48 OR @Status = 64 OR @Status = 80 )
BEGIN
SET @TempIP = LEFT(@UserIP, 9)
IF( @TempIP <> @CompanyIP )
BEGIN
SET @Status = -999
END
END
*/
--Check for IP ban, if so set the status of the user to banned.
IF(SELECT COUNT([Row]) FROM [PS_UserData].[dbo].[BannedIPs] where [banIP] = @UserIP) > 0
BEGIN
SET @Status = -5
UPDATE Users_Master SET Status = @Status WHERE UserUID = @UserUID
END

UPDATE Users_Master SET UserIP = @UserIP WHERE UserUID = @UserUID

-- Select
SELECT @Status AS Status, @UserUID AS UserUID

-- Log Insert
IF( @Status = 0 OR @Status = 16 OR @Status = 32 OR @Status = 48 OR @Status = 64 OR @Status = 80 )
BEGIN
EXEC usp_Insert_LoginLog_E @SessionID=@SessionID, @UserUID=@UserUID, @UserIP=@UserIP, @LogType=0, @LogTime=@LoginTime, @LoginType=@LoginType

if @useruid=(select useruid from PS_userdata.dbo.UserLoginStatus
where useruid=@useruid)
update PS_userdata.dbo.UserLoginStatus
set loginstatus=1,LoginTime=@LoginTime,LogoutTime=@Log inTime,loginSession=@SessionID,lastplaytime=0, LastIP=@UserIP
where useruid=@useruid
else
insert into PS_userdata.dbo.UserLoginStatus(useruid,userid,log instatus,logintime,logouttime,loginsession,lastpla ytime, LastIP) values(@useruid,@userid,1,@LoginTime,@LoginTime,@S essionID,0, @UserIP)

END
SET NOCOUNT OFF

what can i do?

script number 2 gives me this error:

Msg 207, Level 16, State 1, Procedure usp_Try_GameLogout_R, Line 38
Invalid column name 'LogoutTime'.
Msg 207, Level 16, State 1, Procedure usp_Try_GameLogout_R, Line 38
Invalid column name 'LogoutErrType'.

here is mine:

Quote:

USE [PS_UserData]
GO
/****** Object: StoredProcedure [dbo].[usp_Try_GameLogout_R] Script Date: 02/29/2012 15:46:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER Proc [dbo].[usp_Try_GameLogout_R]

@UserUID int,
@SessionID bigint,
@LogoutType smallint = 0,
@ErrType int = 0

AS
SET NOCOUNT ON

DECLARE @LogTime datetime
DECLARE @Sql nvarchar(4000)
DECLARE @yyyy varchar(4)
DECLARE @mm varchar(2)
DECLARE @dd varchar(2)
DECLARE @LogType bit -- Login:0, Logout:1

SET @LogType = 1
SET @LogTime = GETDATE()
SET @yyyy = DATEPART(yyyy, @LogTime)
SET @mm = DATEPART(mm, @LogTime)
SET @dd = DATEPART(dd, @LogTime)

IF( LEN(@mm) = 1 )
BEGIN
SET @mm = '0' + @mm
END

IF( LEN(@dd) = 1 )
BEGIN
SET @dd = '0' + @dd
END

UPDATE Users_Master SET Leave = 0, LeaveDate = GETDATE() WHERE UserUID = @UserUID

SET NOCOUNT OFF

and 3:

here is mine:

Quote:

USE [PS_GameLog]
GO
/****** Object: StoredProcedure [dbo].[usp_Insert_Action_Log_E] Script Date: 02/29/2012 15:48:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

/****** Object: Stored Procedure dbo.usp_Insert_Action_Log_E FIXED ********.com Twilight ******/

ALTER Proc [dbo].[usp_Insert_Action_Log_E]

@UserID varchar(18),
@UserUID int,
@CharID int,
@CharName varchar(50),
@CharLevel tinyint,
@CharExp int,
@MapID smallint,
@PosX real,
@PosY real,
@PosZ real,
@ActionTime varchar(50),
@ActionType tinyint,
@Value1 bigint = null,
@Value2 int = null,
@Value3 int = null,
@Value4 bigint = null,
@Value5 int = null,
@Value6 int = null,
@Value7 int = null,
@Value8 int = null,
@Value9 int = null,
@Value10 int = null,
@Text1 varchar(100) = '',
@Text2 varchar(100) = '',
@Text3 varchar(100) = '',
@Text4 varchar(100) = '',
@Sql nvarchar(4000) = '',
@yyyy varchar(4) = '',
@mm varchar(2) = '',
@dd varchar(2) = '',
@Bucket smallint = -1

AS
DECLARE @CharLeave int

SET @yyyy = datepart(yyyy, @ActionTime)
SET @mm = datepart(mm, @ActionTime)
SET @dd = datepart(dd, @ActionTime)
SET @CharLeave = 1

IF @ActionType = '116'
BEGIN
WAITFOR DELAY '00:00:05'

SELECT @CharLeave=Leave
FROM PS_userdata.dbo.Users_Master
WHERE UserUID=@UserUID

IF @CharLeave=0
BEGIN
EXEC PS_GameData.dbo.usp_Save_Char_Item_Del_E @CharID=@CharID, @IDList=@Value1
END
END

IF @ActionType = '164'
BEGIN

WAITFOR DELAY '00:00:05'

SELECT @CharLeave=Leave
FROM PS_userdata.dbo.Users_Master
WHERE UserUID=@UserUID

IF @CharLeave=0
BEGIN
UPDATE PS_GameData.dbo.Chars
SET [Money]=@Value2
WHERE PS_GameData.dbo.Chars.CharID=@CharID
END
END

IF (@ActionType = 114 and @Value2 = 100200)
Begin
Update PS_Userdata.dbo.Users_Master SET Point = Point + @Value4 * 100 WHERE UserID = @UserID
END

SET @Sql = N'
INSERT INTO PS_GameLog.dbo.ActionLog
(UserID, UserUID, CharID, CharName, CharLevel, CharExp, MapID, PosX, PosY, PosZ, ActionTime, ActionType,
Value1, Value2, Value3, Value4, Value5, Value6, Value7, Value8, Value9, Value10, Text1, Text2, Text3, Text4)
VALUES(@UserID, @UserUID, @CharID, @CharName, @CharLevel, @CharExp, @MapID, @PosX, @PosY, @PosZ, @ActionTime, @ActionType,
@Value1, @Value2, @Value3, @Value4, @Value5, @Value6, @Value7, @Value8, @Value9, @Value10, @Text1, @Text2, @Text3, @Text4)'

EXEC sp_executesql @Sql,
N'@UserID varchar(18), @UserUID int, @CharID int, @CharName varchar(50),
@CharLevel tinyint, @CharExp int, @MapID smallint, @PosX real, @PosY real, @PosZ real, @ActionTime datetime, @ActionType tinyint,
@Value1 bigint, @Value2 int, @Value3 int, @Value4 bigint, @Value5 int, @Value6 int, @Value7 int, @Value8 int,
@Value9 int, @Value10 int, @Text1 varchar(100), @Text2 varchar(100), @Text3 varchar(100), @Text4 varchar(100)',
@UserID, @UserUID, @CharID, @CharName, @CharLevel, @CharExp, @MapID, @PosX, @PosY, @PosZ, @ActionTime, @ActionType,
@Value1, @Value2, @Value3, @Value4, @Value5, @Value6, @Value7, @Value8, @Value9, @Value10, @Text1, @Text2, @Text3, @Text4

i hade this but ppl never got the loggon error but lost alot of items. about everything in the game that was traded got lost there a litle vile so i need to find the problem LOL (removed it right now tho..)