Newbie Spellweaver
- Joined
- Aug 28, 2013
- Messages
- 18
- Reaction score
- 1
as i can say.. i used the phoenix client ... i tried everything i can i go to the lobby then i logout i got the USP Error but here's the mini - tip
look the
that's what you need to change
go to the SQL > Your GameServer Database > Programmibility > Stored Procedures > dbo.usp_logout > Right Click > Modify
Then set the code at the top from line from the ALTER PROCEDURE [dbo].[usp_logout]
to the DECLARE @ChannelNum INT;
tobe
then execute the script..
then .. i gtg i will be right back a few more hours from school to upload a a video.
Code:
2013/09/11 14:01:21 - usp_logout : 74, usp_logout servernum(int)(18) usernum(int)(3375) uid(varchar)(testerlant) nickName(varchar)(원피스는내꺼) exp(int)(197061) channelNum(int)(-1)
Code:
servernum(int)(18) usernum(int)(3375) uid(varchar)(testerlant) nickName(varchar)(원피스는내꺼) exp(int)(197061) channelNum(int)(-1)
go to the SQL > Your GameServer Database > Programmibility > Stored Procedures > dbo.usp_logout > Right Click > Modify
Then set the code at the top from line from the ALTER PROCEDURE [dbo].[usp_logout]
to the DECLARE @ChannelNum INT;
tobe
Code:
ALTER PROCEDURE [dbo].[usp_logout]
@servernum INT,
@usernum INT,
@uid varchar,
@nickName varchar,
@exp int,
@channelNum int
AS
SET NOCOUNT ON
EXEC dbo.usp_LogTranCount @@procid
UPDATE UserInfoLogin
SET fdServerNum = 0, fdLastLogoutTime = GETDATE() WHERE fdUserNum = @usernum;
DECLARE @userid VARCHAR(50);
DECLARE @usernickname VARCHAR(50);
DECLARE @gamemoney INT;
then .. i gtg i will be right back a few more hours from school to upload a a video.
Last edited: