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

Stasis

Newbie Spellweaver
Joined
Aug 10, 2018
Messages
5
Reaction score
0
what table you add in stored procedure?
 

neilshot123

Junior Spellweaver
Joined
May 10, 2014
Messages
140
Reaction score
9
Stasis said:
add GameTime3 on UserInfo
Click to expand...



i alreay add gametime3

user_gametimecvt what is store procedure of this?



You must be registered to see links


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.
 

Stasis

Newbie Spellweaver
Joined
Aug 10, 2018
Messages
5
Reaction score
0
You must be registered to see links


execute the sql db..that is the key.
 

neilshot123

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
 

Stasis

Newbie Spellweaver
Joined
Aug 10, 2018
Messages
5
Reaction score
0
neilshot123 said:
Known bug first login all attack or skill no damage after relogin the damage will show
Click to expand...

execute the original SQL (database)., so that it will run 100%

read all syntax. analyse it.
 
J

jubet

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:
You must log in or register to reply here.