7 Classes Level 70 Cap Server Files + Database + Client + Tutorial

aphexman · Sep 28, 2014

Pls help me with screen if u can at PM

at screen i cant save my changes!

how i can do this (I set up server and all worked now i want find the way to solve the troubles but the first i need full access to database)
p.s.If we do not help each other, then we can't fix the server files! you remember that!

protocolbeta - 7 Classes Level 70 Cap Server Files + Database + Client + Tutorial - RaGEZONE Forums

Alin1337 · Sep 28, 2014

aphexman said:
Pls help me with screen if u can at PM

at screen i cant save my changes!

how i can do this (I set up server and all worked now i want find the way to solve the troubles but the first i need full access to database)
p.s.If we do not help each other, then we can't fix the server files! you remember that!

Options>Designer> uncheck Prevent table from recreation

lego990 · Sep 28, 2014

please help me
my servers dont up, just pop and gone

ok now my DBServer dont start

LeSwrd · Sep 28, 2014

If you're not reading the entire thread or not looking around the forum for outside help then don't comment. Many problems are now being posted on this thread and are not being answered due to the fact that they've been answered before in previous post. Please refrain from posting problems that have already been solved. Search around.

TheBow · Sep 28, 2014

anyone can help for this ?

logs :

'09:56:25' ServiceManager Connected(127.0.0.1, 8501) Connecting..

'09:56:25' [OnConnected:ServiceManager] Socket:12856

'15:26:19' ID:admin, Password:admin

'15:26:19' SQLError: #SQLExecute # (42000) 8144, [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure or function P_Login has too many arguments specified.

'15:26:19' Query:{?=CALL dbo.P_Login(N'admin',N'192.168.1.100',-376731393,0,7,24,0,'2014',N'admin',?,?,?,?,?,?,?,0,?,2,?,0,?,?,?,?,?,?)}

'15:26:23' ID:admin, Password:admin

'15:26:23' SQLError: #SQLExecute # (42000) 8144, [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure or function P_Login has too many arguments specified.

'15:26:23' Query:{?=CALL dbo.P_Login(N'admin',N'192.168.1.100',-376731393,0,7,24,0,'2014',N'admin',?,?,?,?,?,?,?,0,?,2,?,0,?,?,?,?,?,?)}

'15:26:26' ID:admin, Password:admin

'15:26:26' SQLError: #SQLExecute # (42000) 8144, [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure or function P_Login has too many arguments specified.

'15:26:26' Query:{?=CALL dbo.P_Login(N'admin',N'192.168.1.100',-376731393,0,7,24,0,'2014',N'admin',?,?,?,?,?,?,?,0,?,2,?,0,?,?,?,?,?,?)}

'15:39:02' ID:test123, Password:test123

'15:39:03' SQLError: #SQLExecute # (42000) 8144, [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure or function P_Login has too many arguments specified.

'15:39:03' Query:{?=CALL dbo.P_Login(N'test123',N'192.168.1.100',-376731388,0,7,24,0,'2014',N'test123',?,?,?,?,?,?,?,0,?,2,?,0,?,?,?,?,?,?)}

lego990 · Sep 28, 2014

i search around but no one have this problem

i found this on log

'09:15:27' SQLError #SQLDriveConnect # (08001) 14, [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Conexao invalida.

'09:15:27' SQL Reconnect Error~! (T:0 W:0

0) DBName

'09:15:27' [QueryGetDatabaseVersion] CheckConnect Fail

'09:15:27' [Query Over Time:[Membership]P_GetDatabaseVersion] ThreadID:7868 time=5502 ms
'09:15:27' QueryGetDatabaseVersion Failed!! Ip:127.0.0.1 Port:1433 DBName

NMembership DBID

ragonNest

'09:15:27' CreateDB Fail

lovelezzz said:
the problem has been fixed..just use protocol for mssqlserver^^,btw thx for your concern^^

what u did to solve

ok i solve the problem this issue is because odbc users

DimSight · Sep 28, 2014

If you really try and work with the files, you could get pretty far. :fanny:

Skill particles for Bringer fixed as well

SePhII2oth · Sep 28, 2014

DimSight said:
If you really try and work with the files, you could get pretty far. :fanny:

Skill particles for Bringer fixed as well

wich exe are you using?

lego990 · Sep 28, 2014

ok now i got this error

in DNLoginServer i can see

logerror

'18:53:38' ID:teste, Password:testeteste

'18:53:38' [Auth] BeginAuth (REQ) - Result:0, nAccountDBID:1642 (teste) LogOutDate(2014-9-28 18:47)

'18:53:38' LogServer Fail(127.0.0.1, 30000)

'18:53:39' SQLError: #SQLExecute# (01000) 10054, [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionWrite (send()).

'18:53:39' Query:{?=CALL dbo.P_GetDWCCharacterID(1642,10080)}

'18:53:42' LogServer(127.0.0.1, 30000) Connecting..

'18:53:43' LogServer Fail(127.0.0.1, 30000)

'18:53:47' LogServer(127.0.0.1, 30000) Connecting..

'18:53:48' LogServer Fail(127.0.0.1, 30000)

'18:53:52' LogServer(127.0.0.1, 30000) Connecting..

'18:53:53' LogServer Fail(127.0.0.1, 30000)

'18:53:57' LogServer(127.0.0.1, 30000) Connecting..

'18:53:58' LogServer Fail(127.0.0.1, 30000)

'18:53:58' [Auth] ResetAuth (REQ) - Result:0, nAccountDBID:1642, TID:6256

DimSight · Sep 28, 2014

lego990 said:
ok now i got this error

in DNLoginServer i can see

logerror

Check your SQL server. Make sure user DragonNest has ownership to DNWorld, DNStaging, DNServerLog, DNGSM, and DNMembership.

lego990 · Sep 28, 2014

DimSight said:
Check your SQL server. Make sure user DragonNest has ownership to DNWorld, DNStaging, DNServerLog, DNGSM, and DNMembership.

i change the ChannelInfo ip and port, now i can log

but at character creation i got disconnect

[Query Over Time

_AddMaterializedItem] ThreadID:8244 time=1221 ms
[Query Over Time:QueryAddCharacter] Total time=0.000000
[Auth] ResetAuth (REQ) - Result:0, nAccountDBID:1643, TID:6940
[ADBID:1643, SID:3918235923] RequestCreateCharacter State Mismatch(state:3)

Ok let me get this straight, I changed the ip of this line

<Server ID = "1" IP = "192.168.56.1" Name = "TEST" WorldMaxUser = "150" DefaultChannelCount = "1" DefaultMaxUser = "150">
<VillageServerInfo ID = "1" IP = "127.0.0.1" Port = "14300">

I changed the publicserver showing the gameserver and the same port for .bat client, connected but do not know if this correct

aphexman · Sep 29, 2014

Ty a lot for reply to my previous post!!!!!!

Pls help me again!
i can't create a DB backup
where i need check settings to save backup at other location?
user DragonNest is owner!

it is from me to u! For DATABASE from first(1) page! use it to create account it work!
but i need ur help! reading my posts PLS!

@inyAccountLevelCode = 99/100 is GM 0- users

If u reply to my post i give u cash command!
Go help each other!

lego990 · Sep 29, 2014

Everything is going ok except mobs because he dont atack
its because i'm GM? or something like that?

thanks for help

Oktavina01 · Sep 29, 2014

lego990 said:
Everything is going ok except mobs because he dont atack
its because i'm GM? or something like that?

thanks for help

nope, GM or normal mobs should attack, check your script

Andre Ycl · Sep 29, 2014

http://forum.ragezone.com/f853/release-register-account-sql-code-1029348/

For Fix Register SQL And Web.
Using Username And Password Worked..

lego990 · Sep 29, 2014

Oktavina01 said:
nope, GM or normal mobs should attack, check your script

what script? i think is because the ipserver at /server
or i going to crazy thinking about it

aphexman · Sep 29, 2014

Pls help me again!
i can't create a DB backup
where i need check settings to save backup at other location?
user DragonNest is owner!

Ardi Kurniawan · Sep 29, 2014

can anyone can help me to fix this problem?.. it says "Login Error"

J3l86L - 7 Classes Level 70 Cap Server Files + Database + Client + Tutorial - RaGEZONE Forums

it's the logs
'00:01:02' [Thread-Start] WorkerThread - TID : 5592

'00:01:02' Iocp Initialize Sucess(3000)

[Thread-Start] UpdateThread - TID : 5460

[Thread-Start] ReconnectThread - TID : 6500

[Thread-Start] WorkerThread - TID : 2964

'00:01:02' LogServer(127.0.0.1, 30000) Connecting..

'00:01:02' >> [T:0, WorldID:0] 127.0.0.1:1433

NMembership

'00:01:02' QueryGetDatabaseVersion Success!! Ip:127.0.0.1 Port:1433 DBName

NMembership DBID

ragonNest

'00:01:02' >> [T:1, WorldID:0] 127.0.0.1:1433

NMembership

'00:01:02' >> [T:2, WorldID:0] 127.0.0.1:1433

NMembership

'00:01:02' >> [T:3, WorldID:0] 127.0.0.1:1433

NMembership

'00:01:02' >> [T:4, WorldID:0] 127.0.0.1:1433

NMembership

'00:01:02' >> [T:5, WorldID:0] 127.0.0.1:1433

NMembership

'00:01:02' >> [T:6, WorldID:0] 127.0.0.1:1433

NMembership

'00:01:02' >> [T:7, WorldID:0] 127.0.0.1:1433

NMembership

'00:01:02' >> [T:0, WorldID:1] 127.0.0.1:1433

NWorld

'00:01:02' QueryGetDatabaseVersion Success!! WorldDB Ip:127.0.0.1 Port:1433 DBName

NWorld, DBID

ragonNest

'00:01:02' >> [T:1, WorldID:1] 127.0.0.1:1433

NWorld

'00:01:02' >> [T:2, WorldID:1] 127.0.0.1:1433

NWorld

'00:01:02' >> [T:3, WorldID:1] 127.0.0.1:1433

NWorld

'00:01:02' >> [T:4, WorldID:1] 127.0.0.1:1433

NWorld

'00:01:02' >> [T:5, WorldID:1] 127.0.0.1:1433

NWorld

'00:01:02' >> [T:6, WorldID:1] 127.0.0.1:1433

NWorld

'00:01:02' >> [T:7, WorldID:1] 127.0.0.1:1433

NWorld

'00:01:02' [0] Listen Socket ¡íy¨ù¨¬ PORT=7000 SocketPoolSize=10

'00:01:02' MasterAcceptPort (7000)

'00:01:02' Application Initialize Success

'00:01:02' [Thread-Start] MainThread - PID ; 1484, TID : 6588

'00:01:02' [1] Listen Socket ¡íy¨ù¨¬ PORT=14300 SocketPoolSize=3000

'00:01:02' ClientAcceptPort (14300)

'00:01:03' LogServer Fail(127.0.0.1, 30000)

'00:01:04' [OnAccept:Master] Socket:996, Ip:127.0.0.1

'00:01:04' [OnConnected:Master] Socket:996

'00:01:04' PRE-[MALO_REGIST] 9dd1030 WorldID:1

'00:01:04' OK-[MALO_REGIST] 9dd1030 WorldID:1

'00:01:07' LogServer(127.0.0.1, 30000) Connecting..

'00:01:07' ServiceManager Connected(127.0.0.1, 8501) Connecting..

'00:01:07' [OnAccept:ServiceManager] Socket:13036, Ip:127.0.0.1

'00:01:07' [OnConnected:ServiceManager] Socket:13036

'00:01:08' LogServer Fail(127.0.0.1, 30000)

'00:01:12' LogServer(127.0.0.1, 30000) Connecting..

'00:01:13' LogServer Fail(127.0.0.1, 30000)

'00:01:17' LogServer(127.0.0.1, 30000) Connecting..

'00:01:18' LogServer Fail(127.0.0.1, 30000)

'00:01:22' LogServer(127.0.0.1, 30000) Connecting..

'00:01:23' LogServer Fail(127.0.0.1, 30000)

'00:01:27' LogServer(127.0.0.1, 30000) Connecting..

'00:01:28' LogServer Fail(127.0.0.1, 30000)

'00:01:32' LogServer(127.0.0.1, 30000) Connecting..
.
.
.
'00:11:46' ID:ardi, Password:12345678

'00:11:47' SQLError: #SQLExecute # (42000) 8144, [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure or function P_Login has too many arguments specified.

'00:11:47' Query:{?=CALL dbo.P_Login(N'ardi',N'127.0.0.1',-385865963,0,7,24,0,'2014',N'12345678',?,?,?,?,?,?,?,0,?,2,?,0,?,?,?,?,?,?)}

'00:11:47' LogServer(127.0.0.1, 30000) Connecting..

'00:11:48' LogServer Fail(127.0.0.1, 30000)

Please Replay... thanks before

Problem Resolved... I'm edit some query in P_Login...

Andre Ycl · Sep 29, 2014

make sure your database already modified...
you can fix it.

Ardi Kurniawan · Sep 29, 2014

there's any post to help me to fix it?.. sorry i'm bad in SQL and Database analysis.

7 Classes Level 70 Cap Server Files + Database + Client + Tutorial

Newbie Spellweaver

Legendary Battlemage

Newbie Spellweaver

Junior Spellweaver

Junior Spellweaver

Newbie Spellweaver

Newbie Spellweaver

Newbie Spellweaver

Newbie Spellweaver

Newbie Spellweaver

Newbie Spellweaver

Newbie Spellweaver

Newbie Spellweaver

🚫

Experienced Elementalist

Newbie Spellweaver

Newbie Spellweaver

Newbie Spellweaver

Experienced Elementalist

Newbie Spellweaver

RaGEZONE Sponsor

About RaGEZONE

Forum Statistics

RaGEZONE Partners