Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

EP7 Classic Gameplay Source/Gui/Server Files/sQL db

Junior Spellweaver
Joined
May 10, 2014
Messages
140
Reaction score
9
add GameTime3 on UserInfo



i alreay add gametime3

user_gametimecvt what is store procedure of this?





please share the convert time to battle points store procedure of user_gametimecvt thanks.

who encounter this error on db after logout
DB:42000, NativeError:8180, [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared.
 
Initiate Mage
Joined
Aug 10, 2018
Messages
5
Reaction score
0


execute the sql db..that is the key.
 
Junior Spellweaver
Joined
May 10, 2014
Messages
140
Reaction score
9
Known bug first login all attack or skill no damage after relogin the damage will show
 
Banned
Banned
Joined
Mar 21, 2013
Messages
225
Reaction score
18
for those who are looking for user_register stored procedure, execute this SQL script

Code:
[COLOR=#0000ff]USE[/COLOR] [RanUser]
[COLOR=#0000ff]GO[/COLOR]
[COLOR=#008000]/****** Object:  StoredProcedure [dbo].[user_register]    Script Date: 6/21/2018 10:06:35 PM ******/[/COLOR]
[COLOR=#0000ff]SET[/COLOR] ANSI_NULLS [COLOR=#0000ff]ON[/COLOR]
[COLOR=#0000ff]GO[/COLOR]
[COLOR=#0000ff]SET[/COLOR] QUOTED_IDENTIFIER [COLOR=#0000ff]ON[/COLOR]
[COLOR=#0000ff]GO[/COLOR]






[COLOR=#008000]-- =============================================[/COLOR]
[COLOR=#008000]-- Author:		JayArray[/COLOR]
[COLOR=#008000]-- Create date: 09-07-2018[/COLOR]
[COLOR=#008000]-- Description:	user_register[/COLOR]
[COLOR=#008000]-- =============================================[/COLOR]
[COLOR=#0000ff]CREATE PROCEDURE[/COLOR] [dbo].[user_register] 
	[COLOR=#008000]-- Add the parameters for the stored procedure here[/COLOR]
	@szUserId [COLOR=#0000ff]varchar[/COLOR] ([COLOR=#ff8c00]20[/COLOR]),
	@szUserPass [COLOR=#0000ff]varchar[/COLOR] ([COLOR=#ff8c00]20[/COLOR]),
	@szUserPass2 [COLOR=#0000ff]varchar[/COLOR] ([COLOR=#ff8c00]20[/COLOR]),
	@szUserEmail [COLOR=#0000ff]varchar[/COLOR] ([COLOR=#ff8c00]50[/COLOR]),
	@nReturn [COLOR=#0000ff]int OUTPUT[/COLOR]


[COLOR=#0000ff]AS[/COLOR]


[COLOR=#0000ff]BEGIN[/COLOR]
	[COLOR=#008000]-- SET NOCOUNT ON added to prevent extra result sets from[/COLOR]
[COLOR=#008000]	-- interfering with SELECT statements.[/COLOR]
	[COLOR=#0000ff]SET[/COLOR] NOCOUNT [COLOR=#0000ff]ON[/COLOR];
	[COLOR=#0000ff]SET[/COLOR] @nReturn = [COLOR=#ff8c00]0[/COLOR];


	[COLOR=#008000]-- Insert statements for procedure here[/COLOR]
	[COLOR=#0000ff]BEGIN[/COLOR]
		[COLOR=#0000ff]INSERT INTO[/COLOR] UserInfo	        ( UserID,		       UserPass,	       UserPass2,		UserEmail	)
		[COLOR=#0000ff]VALUES[/COLOR]					( @szUserId,	@szUserPass,	@szUserPass2,	@szUserEmail	)


		[COLOR=#0000ff]SET[/COLOR] @nReturn = [COLOR=#ff8c00]12[/COLOR];
	[COLOR=#0000ff]END[/COLOR]
[COLOR=#0000ff]END[/COLOR]
 
Last edited:
Junior Spellweaver
Joined
May 10, 2014
Messages
140
Reaction score
9
Can you share your glogicserver?

leakerthegreat - EP7 Classic Gameplay Source/Gui/Server Files/sQL db - RaGEZONE Forums


who have pk ui separated source?
 
Back
Top