[Guide] How to Setup Mir3 GSP Files

smoochy boys on tour
Status
Not open for further replies.

Azura

Mir3 Coder & Adviser
Legendary
Mar 12, 2005
3,249
111
300
The maximum level is 56? That is impossible to do more than set?

In SQL.. Database -> Programmability -> Stored Procedures -> msp_character_update


declare @MaxLvl int=56

edit this
 

Azura

Mir3 Coder & Adviser
Legendary
Mar 12, 2005
3,249
111
300
whats the SQL Code to delete characters for trying to bug report on a server?

---------- Post Merged at 04:40 PM ---------- Previous Post was at 04:39 PM ----------



whats the SQL Code to delete characters for trying to bug report on a server?

Hopefully moderators will sort you out on here too sooner rather than later, you'll probably give them grief too after.
 

ventus

LOMCN Veteran
Veteran
Oct 17, 2013
925
132
105
For those of you getting errors creating and deleting characters here are the correct stored procedures for character create and delete. I already posted them on another thread but I guess it can be added to the main post :)

Character create
Code:
USE [Game]
GO
/****** Object:  StoredProcedure [dbo].[msp_character_create]    Script Date: 7/19/2016 4:30:50 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:        <Author,,Name>
-- Create date: <Create Date,,>
-- Description:    <Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[msp_character_create]
    -- Add the parameters for the stored procedure here
     (@mir_userid nvarchar(25), @char_name nvarchar(30), @char_hair tinyint, @char_sex tinyint, @char_job tinyint)

AS 
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;

    --100- 未知错误
    --101 无法创建超过4个角色
    --102 该角色名已经存在
    --103 该角色名已经存在
    --104+ 未知错误
    --110
    --111
    --112
    --113
    --114

    declare @charcount int

    --if(dbo.vmsf_CheckMainDB()==0) --是否为主数据库 1=yes,0-no
    --begin
    --     OPENQUERY (linked_server ,'query')
    --end

    ----------
    
    --if (dbo.vmsf_CheckLoginId(@mir_userid)=0) --检查用户ID是否存在 并且未被封号(1=ok,0=no)
    --    return 100
    --
    --if exists (select 1 from TBL_GlobalCharacter where FLD_CHARACTERNAME = @char_name) --检查角色名是否已经存在
    --    return 102
    
    declare @errorcode int
    --
    --EXEC @errorcode=[RAccount].[Account].[dbo].[rmsp_character_create] @mir_userid=@mir_userid,@char_name=@char_name
    
    if(@errorcode>0)
    return @errorcode

    select @charcount=count(1) from TBL_CHARACTER where FLD_UserId=@mir_userid and FLD_DELETED=0
    if(@charcount>=4)    --检查拥有角色是否达到4个
        return 101

    -- Insert statements for procedure here
    INSERT into TBL_CHARACTER (
                FLD_CHARACTER, FLD_USERID, FLD_DELETED,FLD_UPDATEDATETIME, FLD_DBVERSION,
                FLD_MAPNAME,FLD_CX, FLD_CY, FLD_DIR, FLD_HAIR,
                FLD_HAIRCOLORR, FLD_HAIRCOLORG, FLD_HAIRCOLORB,FLD_SEX, FLD_JOB, 
                FLD_LEVEL, FLD_GOLD,FLD_HOMEMAP, FLD_HOMEX, FLD_HOMEY, FLD_PKPOINT,
                FLD_ALLOWPARTY, FLD_FREEGULITYCOUNT, FLD_ATTACKMODE,FLD_FIGHTZONEDIE, FLD_BODYLUCK, 
                FLD_INCHEALTH,FLD_INCSPELL, FLD_INCHEALING, FLD_BONUSAPPLY,FLD_BONUSPOINT, 
                FLD_HUNGRYSTATE, FLD_TESTSERVERRESETCOUNT,
                FLD_CGHUSETIME, FLD_ENABLEGRECALL, FLD_BYTES_1, FLD_HORSERACE, FLD_MAKEDATE)
                VALUES
                ( @char_name, @mir_userid, 0, GETDATE(), 0,
                '', 0, 0, 0, @char_hair,
                0, 0, 0, @char_sex, @char_job,
                0, 0,'', 0, 0,
                0, 0, 0, 0, 0,
                0, 0, 0, 0, 0,
                0, 0, 0, 0, 0,
                0, 0, GETDATE())
    --insert into TBL_GlobalCharacter (FLD_CHARACTERNAME) values (@char_name)
    select FLD_CHARACTER=@char_name, FLD_JOB=@char_job, FLD_HAIR=@char_hair, FLD_LEVEL=0, FLD_SEX=@char_sex
    return 0


END

and

Character Deleting
Code:
USE [Game]
GO
/****** Object:  StoredProcedure [dbo].[msp_character_delete]    Script Date: 7/19/2016 4:33:01 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:        <Author,,Name>
-- Create date: <Create Date,,>
-- Description:    <Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[msp_character_delete]
    -- Add the parameters for the stored procedure here
     (@mir_userid nvarchar(21) , @char_name nvarchar(30), @user_password nvarchar(30))
AS
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;

    -- Insert statements for procedure here
    --101- 删除过程中出现了一个错误
    --102 您输入的密码是无效的
    --103+ 删除过程中出现了一个错误
    --insert into TBL_Temp_LOG (FLD_P1,FLD_P2,FLD_P3,FLD_P4,FLD_P5)  values('msp_character_delete',@mir_userid,@char_name,@user_password,GETDATE())

    UPDATE TBL_CHARACTER SET FLD_DELETED=1 WHERE  FLD_CHARACTER=@char_name and FLD_USERID=@mir_userid and  EXISTS(select  FLD_PASSWORD from GSPAccount.dbo.TBL_ACCOUNT where  FLD_USERID=@mir_userid and FLD_PASSWORD=@user_password)
    --101 
    --return 102

    --UPDATE TBL_CHARACTER SET FLD_DELETED=1 WHERE  FLD_CHARACTER=@char_name and FLD_DELETED=0 and FLD_USERID=@mir_userid  and  exists(select FLD_USERID from  [RAccount].[Account].[dbo].[TBL_ACCOUNT] where FLD_USERID=@mir_userid  and FLD_PASSWORD=@user_password)
    --select 102

    if(@@ROWCOUNT>0)
    begin
        --EXEC [RAccount].[Account].[dbo].[rmsp_character_delete] @mir_userid=@mir_userid,@char_name=@char_name 
        update TBL_GlobalCharacter set FLD_deleted=1 where FLD_CharacterName=@char_name
        return 0
    end
    else
    begin
        return 102
    end

    SET NOCOUNT OFF;


END
 

imkill41

Dedicated Member
Dedicated Member
Jan 18, 2016
30
0
32
Why not this Hyun moon Temple, Departed Valley is your position?
 

Far

tsniffer
Staff member
Developer
May 19, 2003
20,172
30
2,767
540
i 'think' he means why doesn't your server have the moon abyss maps, and only contains up to Departed Valley maps? Not sure what departed valley maps are tho :S
 

azhj2000

Dedicated Member
Dedicated Member
Sep 21, 2011
10
0
28
IP address is not 127.0.0.1 how to set?

---------- Post Merged at 09:33 AM ---------- Previous Post was at 09:33 AM ----------

IP address is not 127.0.0.1 how to set?

---------- Post Merged at 09:51 AM ---------- Previous Post was at 09:33 AM ----------

Set the LAN IP address 192.168.0.1, the machine can enter the account of other computers on the input interface, without any hints.
 

Azura

Mir3 Coder & Adviser
Legendary
Mar 12, 2005
3,249
111
300
Okay so an issue for the files which I have noticed is that the GameGates kick clients randomly. Maybe a packet issue or something else.

This is what is causing the exe disconnects, anyone else noticing this issue?
 

ventus

LOMCN Veteran
Veteran
Oct 17, 2013
925
132
105
Okay so an issue for the files which I have noticed is that the GameGates kick clients randomly. Maybe a packet issue or something else.

This is what is causing the exe disconnects, anyone else noticing this issue?
Could it be caused by the error when people enter their passwords incorrectly? Says theres an SQL connect error, maybe this error causes problems with sql causing the disconnections which seem random. Just a shot in the dark, these files are frustrating...
 

Azura

Mir3 Coder & Adviser
Legendary
Mar 12, 2005
3,249
111
300
Could it be caused by the error when people enter their passwords incorrectly? Says theres an SQL connect error, maybe this error causes problems with sql causing the disconnections which seem random. Just a shot in the dark, these files are frustrating...

Nope its for when clients are ingame doing normal stuff, they will randomly get disconnected and a message popup in the GameGate

Log:2016-07-26 12:33:00,Server Kick Client>>>,**.**.***.**:5169 (For Example)
 

ventus

LOMCN Veteran
Veteran
Oct 17, 2013
925
132
105
Ah I havnt had very many people connect to my test server so I havnt run into that yet. I wonder if Dj has these issues on Uncharted :O

Edit*

Theres multiple gate .exes included with these files, have you tried using the ones with the larger filesize? I think one was 21kb while the other was 22kb off the top of my head.
 
Last edited:

DjDarkBoyZ

Dev
Golden Oldie
Aug 11, 2006
1,065
228
260
127.Ø.Ø.1
Ah I havnt had very many people connect to my test server so I havnt run into that yet. I wonder if Dj has these issues on Uncharted :O

Edit*

Theres multiple gate .exes included with these files, have you tried using the ones with the larger filesize? I think one was 21kb while the other was 22kb off the top of my head.

I dont have this issue.
The gates come with the files are very buggy. :P
 
Status
Not open for further replies.