[GSP] Finally I fixed ranking system.

sh5002

Loyal Member
Loyal Member
Feb 9, 2017
82
9
20
Finally I fixed ranking system. and add storage



My server has rebirth system.
and then I sorted Rebirth>Level>Exp.

huh. I have tried several hundred to solve this problem.
maybe 1 months...
but.The solution to the problem was too easy.:confusion:
It feels like a fool.....

and add storage
[video=youtube_share;2peL_w2sp70]https://youtu.be/2peL_w2sp70[/video]
 
Last edited:

sh5002

Loyal Member
Loyal Member
Feb 9, 2017
82
9
20
And the solution is??
easy.
1st check
stored procedures select rank's data n item's data.

maybe rankdata must be exists.
so i made querry for insert.
and then running a job server program.
Then the data is registered in the sql.
and then delete or comment out insert querry.

end.


나의 SM-N916S 의 Tapatalk에서 보냄
 
Last edited:

Fub4r

Dedicated Member
Dedicated Member
Jan 13, 2005
242
45
75
Added ingame titles, working on the premium titles from wecash store atm, but having no luck with premium storage...
 

sh5002

Loyal Member
Loyal Member
Feb 9, 2017
82
9
20
Added ingame titles, working on the premium titles from wecash store atm, but having no luck with premium storage...

i made storage by accident.
2nd storage's item type is 100, WX(storage 1 is W)
It is necessary to change the IF syntax.
Perhaps this is what you need.

premium titles?
1st line name
2nd line premium title
3rd line castle owner guild name

is that right?

wow. I try that . but not working.

i changed data type int to nvarchar at Fld_usertitle .

giveusertitleex a b (a=usertitle, b=expiretime)

If I enter a something,but 2nd line is output my charname.

can u help me that?

this is my query

Code:
USE [Game]
GO
/****** Object:  StoredProcedure [dbo].[msp_usertitle_update]    Script Date: 2017-06-04 오후 05:10:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[msp_usertitle_update]


	(@char_name nvarchar(30),@usertitle nvarchar(30),@expiretime datetime)
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;
	
	if exists (select * from tbl_usertitle where FLD_CHARACTER= @char_name)
	begin
	
	update TBL_usertitle set FLD_CHARACTER=@char_name, FLD_usertitle=@usertitle , fld_expiretime=@expiretime where FLD_CHARACTER=@char_name
	select * from TBL_USERTITLE where fld_character=@char_name
	end
	else


	insert into TBL_USERTITLE(FLD_CHARACTER,FLD_USERTITLE,FLD_EXPIRETIME) values (@char_name,@usertitle,@expiretime)
	select * from TBL_USERTITLE where fld_character=@char_name


	if(@@ROWCOUNT>0)
	return 0
	else
	return 1 


	SET NOCOUNT OFF;


END

ps. Do u know how to change charnamecolor npc script??
 
Last edited: