:)
- Joined
- Sep 21, 2007
- Messages
- 282
- Reaction score
- 10
Lool they looks like Mazinger Z.. Im gonna test this .. Thank you .. +1 thanks to you
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!Create ODBC -> Administrative Tools -> Data Sources (ODBC) -> System DSN -> ADD Mysql 2005
yes I know..that... Im talking about WHAT ARE THE NAMES.. lol raycrash1 and raycrash2?
I think it uses ODBC buy what´s the name of? T_T
Edit:
AquaLung told me that he doesnt used any ODBC.. then..
whan can we do? xD
I take wrong ID xD
Greetings
Ranslsad
I haven't been able to get the server to connect to the db
I haven't been able to get the server to connect to the db
It connects for me using MSSQL 2000 SP4.
AquaLung
.
23:11:27 :: db test start
[B][COLOR="Red"]23:11:27 :: SQL Server Message 5701: Changed database context to 'master'.[/COLOR][/B]
23:11:27 :: -------------- raycrash DB Ok ----------------------
23:11:27 :: db test end
23:11:27 :: SQL Server Message 170: Line 1: Incorrect syntax near 'use'.
[COLOR="Magenta"]23:11:27 :: DB-Library Error 10007: General SQL Server error: Check messages from the SQL Server.[Edit: maybe it uses MD5?][/COLOR]
23:11:27 :: Error:Db.cpp:ExecDB():dbsqlexec():charid:0
23:11:27 :: use
23:11:27 :: Error:raycrashmain.cpp:ms_use_db():ExecDB():charid:0
23:11:27 :: -------------- raycrash Server Start ---------------
But we do all you do and nothings happens..
I will try again starting by 0..
Edit:
Nothings..
I will say what i do..
First Download files ( -.-" ) and Eng Client
Then i create new DB called raycrash1 and 2.. restore DB...
Then i configure Inis with IP 127.0.0.1 and SQL Username and pass...
Then i configure client with my ip 127.0.0.1 and i try connect it says
invalid username...
Edit2:
Watching in Server log... i saw some line that looks rare...
Code:23:11:27 :: db test start [B][COLOR="Red"]23:11:27 :: SQL Server Message 5701: Changed database context to 'master'.[/COLOR][/B] 23:11:27 :: -------------- raycrash DB Ok ---------------------- 23:11:27 :: db test end 23:11:27 :: SQL Server Message 170: Line 1: Incorrect syntax near 'use'. [COLOR="Magenta"]23:11:27 :: DB-Library Error 10007: General SQL Server error: Check messages from the SQL Server.[Edit: maybe it uses MD5?][/COLOR] 23:11:27 :: Error:Db.cpp:ExecDB():dbsqlexec():charid:0 23:11:27 :: use 23:11:27 :: Error:raycrashmain.cpp:ms_use_db():ExecDB():charid:0 23:11:27 :: -------------- raycrash Server Start ---------------
Edit3:
I think you got the SQL Server configured diff of us ones.. i installed yesterday and no changes..
What is you SQL Config -.-"?
Greetings
Ranslsad
That same error show's in my log, so it's not keeping you from logging in. I will post my configs.
AquaLung
.
[Server Info]
AppName=Billing Server
port=15511
RefreshTime=60000
TimeCheck=600000
NewLogCheckTime=3600000
BillingFlag=0
LoginLog=1
CheckValid=0
[DB Info]
ServerNum=1
Server=127.0.0.1
AdminUser=1
UserName=sa
Password=*YOUR SA PASSWORD*
dbName=raycrash
-------------I N F O-------------------------
NewLogCheckTime=3600000
* Server
+ Billing DB Server IP
* dbName
+ Billing DB name
* BillingFlag
-Flag on is Calculate User's Gamming Time
-Prepare Database table Person_BillingInfo for Billing on
+ Billing on : 1
+ Billing off : 0
* LoginLog : File Logging
- Prepare "LoginLog" Directory for LoginLog on
- Prepare Database table FailLogin for LoginLog on (Login Fail Count)
+ LoginLog on : 1
+ LoginLog off : 0
* CheckValid
- 0 is Normal User
- 1 is can't login user because for some reason
+ CheckValid on : 1
+ CheckValid off : 0
-------------------------------------------
[Server]
Number=1
Server1=192.168.0.5
[DB Info]
Server=127.0.0.1
UserName=sa
Password=*YOUR SA PASSWORD*
AppName=rcmainserver
dbname=raycrash
[MSG Server Info]
user_accept_ip = 192.168.0.5
server_accept_ip=127.0.0.1
tcpport=11014
udpport=11013
servertcpport=11015
[Main Server Info]
ID=1
Server=192.168.0.5
udp_port=11017
[Rank Server Info]
Server=192.168.0.5
tcp_port=11016
udp_port=11018
[Game Server Info]
ID=1
Here are my ini's:
192.168.0.5 is my server's IP Address
Billing config.ini
Code:[Server Info] AppName=Billing Server port=15511 RefreshTime=60000 TimeCheck=600000 NewLogCheckTime=3600000 BillingFlag=0 LoginLog=1 CheckValid=0 [DB Info] ServerNum=1 Server=127.0.0.1 AdminUser=1 UserName=sa Password=*YOUR SA PASSWORD* dbName=raycrash -------------I N F O------------------------- NewLogCheckTime=3600000 * Server + Billing DB Server IP * dbName + Billing DB name * BillingFlag -Flag on is Calculate User's Gamming Time -Prepare Database table Person_BillingInfo for Billing on + Billing on : 1 + Billing off : 0 * LoginLog : File Logging - Prepare "LoginLog" Directory for LoginLog on - Prepare Database table FailLogin for LoginLog on (Login Fail Count) + LoginLog on : 1 + LoginLog off : 0 * CheckValid - 0 is Normal User - 1 is can't login user because for some reason + CheckValid on : 1 + CheckValid off : 0 -------------------------------------------
Billing NTService.ini
Code:[Server] Number=1 Server1=192.168.0.5
raycrash.ini in server folder and in system32 folder
Code:[DB Info] Server=127.0.0.1 UserName=sa Password=*YOUR SA PASSWORD* AppName=rcmainserver dbname=raycrash [MSG Server Info] user_accept_ip = 192.168.0.5 server_accept_ip=127.0.0.1 tcpport=11014 udpport=11013 servertcpport=11015 [Main Server Info] ID=1 Server=192.168.0.5 udp_port=11017 [Rank Server Info] Server=192.168.0.5 tcp_port=11016 udp_port=11018 [Game Server Info] ID=1
In the above configs, I combined both raycrash1 and raycrash2 DB's into 1 but I get the same results both ways.
AquaLung
.
Cheers for the release, anyone interested in a sectin yet?