Azura
Mir3 Coder & Adviser
- 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
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
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.
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
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
Why not this Hyun moon Temple, Departed Valley is your position?
View attachment 17483
What reason is this?
Can i run these files on Windows xp VirtualMachine?
thank you
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...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...
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