[SHARE] Shaiya Server with Video Guide

Anyone can help - me ? i can start the game with game.exe with 127.0.0.1

anyone know fix ? i gave try all =/

Quote:

---

Originally Posted by maisqueporra

Anyone can help - me ? i can start the game with game.exe with 127.0.0.1

anyone know fix ? i gave try all =/

---

Try putting in the name of your computer. I had to do that instead of using 127.0.0.1 as well. Had the same error come up. You can find the computer name by right clicking on My Computer and looking at properties. Check the Computer Name tab and enter the Full computer name. I fixed mine that way.

Quote:

---

Originally Posted by THENBA1

i have a problem
- i create guild success but when i restart my server my guild is lose
- i add buddy success buy when i exit game my buddy list is lose

how to fix them

---

see logs ,change store procs,design tables

Quote:

---

Originally Posted by maisqueporra

Anyone can help - me ? i can start the game with game.exe with 127.0.0.1

anyone know fix ? i gave try all =/

---

It is necessary to remove GG and correctly to put a quantity of yours IP addresses. Actions HEX at you are not correct. The file is spoiled.

d{-_-}b

Quote:

---

Originally Posted by reflax

i swear people are lazy lol

add this
DECLARE @InPassword2 varchar(32)

change your query to match this
SELECT @UserUID=UserUID, @Status=Status, @InPassword2=Pw, @Leave=Leave FROM Users_Master WHERE UserID = @UserID

somewhere in there add this
IF ( @InPassword <> @InPassword2 )
BEGIN
SET @Status = -1
END

presto... or you can use bits of their code and add md5 passwords instead to make it more secure.

---

To Twilight

Quote:

---

just edit
usp_Try_GameLogin_Taiwan
.

---

Help
I open server but not use md5 passwords .

You help me pots code in usp_Try_GameLogin_Taiwan of you. Plz

-------
sorry not good eng

Quote:

---

Originally Posted by g2server

To Twilight



Help
I open server but not use md5 passwords .

You help me pots code in usp_Try_GameLogin_Taiwan of you. Plz

-------
sorry not good eng

---

Study to understand language store proc's because in the further you should correct and other errors.
:rolleyes:

Does anyone know what to change in User_Master to give Admin WITHOUT using /adminopen? I know ow to use admin open command, but would like to have some legit GM / GS in game without everyone being GM / GS.

PassFix_PROC.rar

is login Show " Account doesn't exist "


:?:


is not check pass :$:

Quote:

---

Originally Posted by g2server

PassFix_PROC.rar

is login Show " Account doesn't exist "


:?:


is not check pass :$:

---

check your table.. bcoz in store proc use
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

Quote:

---

Originally Posted by MMachor

Does anyone know what to change in User_Master to give Admin WITHOUT using /adminopen? I know ow to use admin open command, but would like to have some legit GM / GS in game without everyone being GM / GS.

---

Users_Master
Status = 16 or Status = 32 or Status = 48 or Status = 64 or Status = 80

Staus = GM Level /adminopen not use

Twilight, thank you. I had found the 16, but not the others. Hopefully last question.... In earlier posts I used what you had said to enable the Desert and Jungle maps. Thank you, it worked great. I can use /cmove to get there, but was wondering if you knew how to set a portal to take you there without using the /cmove command? I also wanted to throw out a thank you to ZeroSignal for the Python tools. They work great and are extremely useful. I do a lot of reverse engineering myself so I know the work that went into developing those. :thumbup:

Lesson: Pswd check...
For understanding as it works we shall create temporary procedure LoginCheck in PS_UserData database.

Code:

---

CREATE PROCEDURE [dbo].[LoginCheck]
@UserUID        int = 0,
@UserID        varchar(18),
@InPassword        varchar(32)
AS
SET NOCOUNT ON
DECLARE
@UUID        int,
@UID        varchar(18),
@Leave tinyint,
@Status smallint,
@ChPw  varchar(50),
@Check        int
SET @Status = -1
SET @Check = 1
SELECT @UUID=UserUID, @UID=UserID, @Status=Status, @Leave=Leave FROM Users_Master WHERE UserID = @UserID

-- NotExist User OR Leave User
IF( @UserUID <> @UUID OR @Leave = 1 OR @UserID <> @UID)
BEGIN
SET @Status = -3
PRINT 'NotExist User OR Leave User'
RETURN -1;
END

-- Check Password
SELECT @UserUID=UserUID,@ChPw=Pw FROM Users_Master WHERE UserID = @UserID
IF ( @InPassword <> @ChPw)
BEGIN
PRINT 'Not the correct password!'+' your password - ' + @InPassword + ', your password in database - ' + @ChPw
RETURN -1;
END
PRINT 'PASSWORD  - OK'+' your password - ' + @InPassword + ', your password in database - ' + @ChPw
SET NOCOUNT OFF
GO

---

From table Users_Master it is remembered three parameters for further use - UserUID, UserID, Pw
In Query Analyzer we choose base PS_UserData and in window Query we write an example: exec LoginCheck 1, ' test1 ', ' test '
Explanation:
1- it UserUID
test1 - login
test - password

PS:
I hope you will start to understand as this all works and further will correct other procedures

Quote:

---

Originally Posted by MMachor

Twilight, thank you. I had found the 16, but not the others. Hopefully last question.... In earlier posts I used what you had said to enable the Desert and Jungle maps. Thank you, it worked great. I can use /cmove to get there, but was wondering if you knew how to set a portal to take you there without using the /cmove command? I also wanted to throw out a thank you to ZeroSignal for the Python tools. They work great and are extremely useful. I do a lot of reverse engineering myself so I know the work that went into developing those. :thumbup:

---

http://de.www.shaiya.aeriagames.com/node/414

Quote:

---

Originally Posted by Twilight

Lesson: Pswd check...
For understanding as it works we shall create temporary procedure LoginCheck in PS_UserData database.

Code:

---

CREATE PROCEDURE [dbo].[LoginCheck]
@UserUID    int = 0,
@UserID    varchar(18),
@InPassword    varchar(32)
AS
SET NOCOUNT ON
DECLARE
@UUID    int,
@UID    varchar(18),
@Leave tinyint,
@Status smallint,
@ChPw  varchar(50),
@Check    int
SET @Status = -1
SET @Check = 1
SELECT @UUID=UserUID, @UID=UserID, @Status=Status, @Leave=Leave FROM Users_Master WHERE UserID = @UserID
 
-- NotExist User OR Leave User
IF( @UserUID <> @UUID OR @Leave = 1 OR @UserID <> @UID)
BEGIN
SET @Status = -3
PRINT 'NotExist User OR Leave User'
RETURN -1;
END
 
-- Check Password
SELECT @UserUID=UserUID,@ChPw=Pw FROM Users_Master WHERE UserID = @UserID
IF ( @InPassword <> @ChPw)
BEGIN
PRINT 'Not the correct password!'+' your password - ' + @InPassword + ', your password in database - ' + @ChPw
RETURN -1;
END
PRINT 'PASSWORD  - OK'+' your password - ' + @InPassword + ', your password in database - ' + @ChPw
SET NOCOUNT OFF
GO

---

From table Users_Master it is remembered three parameters for further use - UserUID, UserID, Pw
In Query Analyzer we choose base PS_UserData and in window Query we write an example: exec LoginCheck 1, ' test1 ', ' test '
Explanation:
1- it UserUID
test1 - login
test - password

PS:
I hope you will start to understand as this all works and further will correct other procedures

---

it login error Accout doesn't exist. T_T


-----------------------------------------------------------------------------------


This code me

Code:

---


/*==================================================
@date 2007-12-04
@brief Login Proc( Taiwan )
==================================================*/
CREATE  Proc 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,
@ChPw  varchar(50),
@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 =1
--------------------------------------------------
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
PRINT 'NotExist User OR Leave User'
END
PRINT 'USER EXIST!'
BEGIN
 -- Check Password
 --EXEC OMG_GameWeb.dbo.sp_OmgLoginSuccessCheck @UserID, @InPassword, @Check output
 IF ( @@ERROR = 0 )
 BEGIN
  IF( @Check <> 1 )
  BEGIN
  SET @Status = -1
  END
 END
 ELSE
 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
*/
-- 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
END
SET NOCOUNT OFF
GO

---

Quote:

---

Originally Posted by g2server

it login error Accout doesn't exist. T_T

---

Create new login use my test reg scripts.. and test again
Change 1.php
$myUser = "DBuser";
$myPass = "DBpasswd";

server me open long time 3 day. Don't Register code to md5 pass

- -
i have 1000 account no md5 pass

T_T

Quote:

---

Originally Posted by g2server

server me open long time 3 day. Don't Register code to md5 pass

- -
i have 1000 account no md5 pass

T_T

---

this script create no md5

page regis i have but

database server bug pass login.
For example,
ID. 1234.
PASS 1234.
Server can be accessed by entering anything.

if you are having account don't exist error
try to change your password for a smaller one
--------------------------
Thanks Twilight, i fixed my pass error now :D

Quote:

---

Originally Posted by metalknuxx

if you are having account don't exist error
try to change your password for a smaller one
--------------------------
Thanks Twilight, i fixed my pass error now :D

---

Where ( try to change your password for a smaller one) ?

Quote:

---

Originally Posted by g2server

it login error Accout doesn't exist. T_T


-----------------------------------------------------------------------------------


This code me

Code:

---


/*==================================================
@date 2007-12-04
@brief Login Proc( Taiwan )
==================================================*/
CREATE  Proc 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,
@ChPw  varchar(50),
@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 =1
--------------------------------------------------
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
PRINT 'NotExist User OR Leave User'
END
PRINT 'USER EXIST!'
BEGIN
 -- Check Password
 --EXEC OMG_GameWeb.dbo.sp_OmgLoginSuccessCheck @UserID, @InPassword, @Check output
 IF ( @@ERROR = 0 )
 BEGIN
  IF( @Check <> 1 )
  BEGIN
  SET @Status = -1
  END
 END
 ELSE
 BEGIN
  SET @Status = -1
 END
   SELECT @UserUID=UserUID,@ChPw=Pw FROM Users_Master WHERE UserID = @UserID

IF ( @InPassword <> @ChPw)
            BEGIN
                RETURN -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
*/
-- 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
END
SET NOCOUNT OFF
GO

---

---

add this text bold shrift ....scroll down code text

ok. i make is
But
affter add this text bold

it login error Accout doesn't exist

Quote:

---

Originally Posted by g2server

ok. i make is
But
affter add this text bold

it login error Accout doesn't exist

---

Create NEW account and test.. and check enter language from keyboard

change your account's password for a more shot password
example: rfrrff
or 12332456
:)

Quote:

---

Originally Posted by Twilight

Create NEW account and test.. and check enter language from keyboard

---

ok.... sory Mr.Twilight.

WoWWWWWWWWW

login all account is ok

Thx you more .....

Quote:

---

Originally Posted by g2server

Oh..... is New accout ok.

but accouct olde will can't login

---

All defaults logins should be blocked or destroyed differently you will hack