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

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!
http://cs618530.vk.me/v618530675/1a9db/v_DjNI2_zRI.jpg

Quote:

---

Originally Posted by aphexman

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!
http://cs618530.vk.me/v618530675/1a9db/v_DjNI2_zRI.jpg

---

Options>Designer> uncheck Prevent table from recreation

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

- - - Updated - - -

http://puu.sh/bQxtl/1e8b8a7559.png



ok now my DBServer dont start

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.

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,?,?,?,?,?,?)}

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:DNMembership DBID:DragonNest


'09:15:27' CreateDB Fail

- - - Updated - - -

Quote:

---

Originally Posted by lovelezzz

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

---

what u did to solve

- - - Updated - - -

ok i solve the problem this issue is because odbc users

http://puu.sh/bRfsN/5b24df1239.png

If you really try and work with the files, you could get pretty far. :fanny:
http://puu.sh/bRyis/880f69f7ad.jpg
Skill particles for Bringer fixed as well
http://puu.sh/bRBfJ/05f1c44c9f.jpg

Quote:

---

Originally Posted by DimSight

If you really try and work with the files, you could get pretty far. :fanny:
http://puu.sh/bRyis/880f69f7ad.jpg
Skill particles for Bringer fixed as well
http://puu.sh/bRBfJ/05f1c44c9f.jpg

---

wich exe are you using?

ok now i got this error

http://puu.sh/bRP7i/ffb2a51151.jpg


in DNLoginServer i can see


http://puu.sh/bRP9y/52a7cb9d6c.png



logerror

Quote:

---

'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

---

Quote:

---

Originally Posted by lego990

ok now i got this error

http://puu.sh/bRP7i/ffb2a51151.jpg


in DNLoginServer i can see


http://puu.sh/bRP9y/52a7cb9d6c.png



logerror

---

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

Quote:

---

Originally Posted by DimSight

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:P_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)

- - - Updated - - -

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

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

- - - Updated - - -

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!
http://cs618022.vk.me/v618022675/1b669/OWbb7u_Q4Lc.jpg

- - - Updated - - -

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!

http://cs618022.vk.me/v618022675/1b670/EiN_z80dNSA.jpg



@inyAccountLevelCode = 99/100 is GM 0- users

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

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


thanks for help

Quote:

---

Originally Posted by lego990

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

http://forum.ragezone.com/f853/relea...-code-1029348/

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

Quote:

---

Originally Posted by Oktavina01

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

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!

http://cs618022.vk.me/v618022675/1b669/OWbb7u_Q4Lc.jpg

can anyone can help me to fix this problem?.. it says "Login Error"
http://i.imgur.com/J3l86Le.jpg

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:DNMembership


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


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


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


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


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


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


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


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


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


'00:01:02' QueryGetDatabaseVersion Success!! WorldDB Ip:127.0.0.1 Port:1433 DBName:DNWorld, DBID:DragonNest


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


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


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


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


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


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


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


'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...

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

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

my little mobs dont attack .. this bug is killing me (me not my char hehe)

also

i will make a layout on photoshop if anyone have interest in development the code, ask
sory for my bad english

anyone care to post for specific guide in editing DNT files?
had the DNT to Table converter but dont know where to edit and what to edit?
opened maptable dnt and try to edit portals, dont know where to start O_o

can't create buckup first post page 42 with screen pls help!

my problem with "Login Error" has been Resolved, but now i'm have a problem with enter to Portal. I'm close the portal but nothing happen, anyone Can help me with my new problem? ...

yey... problem solved.... :D:

Quote:

---

Originally Posted by Ardi Kurniawan

my problem with "Login Error" has been Resolved, but now i'm have a problem with enter to Portal. I'm close the portal but nothing happen, anyone Can help me with my new problem? ...

---

i think is a problem with the client
I THINK ok?

- - - Updated - - -

how i can add skill points