• Unfortunately, we have experienced significant hard drive damage that requires urgent maintenance and rebuilding. The forum will be a state of read only until we install our new drives and rebuild all the configurations needed. Please follow our Facebook page for updates, we will be back up shortly! (The forum could go offline at any given time due to the nature of the failed drives whilst awaiting the upgrades.) When you see an Incapsula error, you know we are in the process of migration.

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.
 
Newbie Spellweaver
Joined
Aug 10, 2018
Messages
5
Reaction score
0


execute the sql db..that is the key.
 
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