[C#]The Arcane Development Thread

kevin_owner · 10/26/2010, 10:07

Owh yeah i forgot to say that but you need sql server 2005 or higher cause sql server 2000 doesn't support MultipleActiveResultSets.

UPDATE:
Finally some progress They char gets displayed:

btw, joymax is perv all the chars are nude and Nude patch is disabled

~~LastThief~~ · 10/26/2010, 12:17

@up its not completed yet

@kevin i got strange error today O.o i tried to start login and game server and getting error but yesterday it worked fine O.o

xnukex77 · 10/26/2010, 12:24

Quote:

Originally Posted by mage200

hey hmm last thief i think few stuff like config text database are missing can you please upload them for me?

need all

kevin_owner · 10/26/2010, 12:33

Quote:

Originally Posted by LastThief

@up its not completed yet

@kevin i got strange error today O.o i tried to start login and game server and getting error but yesterday it worked fine O.o

I also got that problem a few hours ago my sql service wasn't started and database.ini had a wrong value at the "data source="

@others about those data files Yesterday i've added those files to a post

this one

and the database.ini and server.ini are in the bin folder the only thing you have to do is change the values of those 2 files.

CrystalCoder · 10/26/2010, 12:34

ok i fixed ty LastThief

now i have this issue

[IMG]

[/IMG]

-Corelli · 10/26/2010, 12:38

Quote:

Originally Posted by mage200

ok i fixed ty LastThief

now i have this issue

[IMG][/IMG]

me to

kevin_owner · 10/26/2010, 12:56

Quote:

Originally Posted by ReaLLiF

me to

This:
I also got that problem a few hours ago my sql service wasn't started and database.ini had a wrong value at the "data source="

was my response to LastThief in my previous post to his error but it seems to be that you 2 have to problem so i'll explain this a bit more detailed

Open your task manager and go to the tab services. Search for a name which starts with "MSSQL$"
In my case this one is called "MSSQL$SQLEXPRESS"

This is your sql service. be sure that this one is running.

Now open your database.ini the datbase.ini of the release looks like this:

Code:

[DATABASE]
connection=Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;

As Data Source you can try 2 things the first one is '127.0.0.1' or 'localhost' if this one doesn't work try:
'<Name Of Your PC>/<The MSSQL service name>'

Change '<Name of Your PC>' to the name of your pc for example 'kevin_owner-PC'.
Change the <The MSSQL service name> to the name which is in your task manager service panel after the MSSQL$ part which we just searched for.
so the final Data Source string could look like this:

Code:

'Data Source=kevin_owner-PC/SQLEXPRESS'

if everything went right you now have your data source set.
The next value you need to fill in is the Initial Catalog which is your database. if your database name is silkroad fill in silkroad if your db name is monkey fill in monkey (i'm not gonna explain how to create a database).

the next 2 values you have to fill in are 'User id=' and 'password='
You created this one at the installation of sql server but you can always create a new account (at the security tab if i remember correctly) The default user an password where
username: 'sa'
password: '1234'
but i'm not sure about this one.

So the finished database string could look like this:

Code:

[DATABASE]
connection=Data Source=kevin_owner-PC\SQLEXPRESS;Initial Catalog=silkroad;User Id=sa;Password=1234;MultipleActiveResultSets=True;

There is one new thing in this database.ini which is MultipleActiveResultSets=True;
This one is needed to solve the DataReader already open problem.

Btw, You need to have Sql server 2005 or Higher cuz sql server 2000 doesn't support MultipleActiveResultSets.

I hope this helped

xnukex77 · 10/26/2010, 13:08

Quote:
Originally Posted by kevin_owner
This:
I also got that problem a few hours ago my sql service wasn't started and database.ini had a wrong value at the "data source="

was my response to LastThief in my previous post to his error but it seems to be that you 2 have to problem so i'll explain this a bit more detailed

Open your task manager and go to the tab services. Search for a name which starts with "MSSQL$"
In my case this one is called "MSSQL$SQLEXPRESS"

This is your sql service. be sure that this one is running.

Now open your database.ini the datbase.ini of the release looks like this:
Code:
[DATABASE]
connection=Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;
As Data Source you can try 2 things the first one is '127.0.0.1' or 'localhost' if this one doesn't work try:
'<Name Of Your PC>/<The MSSQL service name>'

Change '<Name of Your PC>' to the name of your pc for example 'kevin_owner-PC'.
Change the <The MSSQL service name> to the name which is in your task manager service panel after the MSSQL$ part which we just searched for.
so the final Data Source string could look like this:
Code:
'Data Source=kevin_owner-PC/SQLEXPRESS'
if everything went right you now have your data source set.
The next value you need to fill in is the Initial Catalog which is your database. if your database name is silkroad fill in silkroad if your db name is monkey fill in monkey (i'm not gonna explain how to create a database).

the next 2 values you have to fill in are 'User id=' and 'password='
You created this one at the installation of sql server but you can always create a new account (at the security tab if i remember correctly) The default user an password where
username: 'sa'
password: '1234'
but i'm not sure about this one.

So the finished database string could look like this:
Code:
[DATABASE]
connection=Data Source=kevin_owner-PC\SQLEXPRESS;Initial Catalog=silkroad;User Id=sa;Password=1234;MultipleActiveResultSets=True;
There is one new thing in this database.ini which is MultipleActiveResultSets=True;
This one is needed to solve the DataReader already open problem.

Btw, You need to have Sql server 2005 or Higher cuz sql server 2000 doesn't support MultipleActiveResultSets.

I hope this helped

can u re-upload db&files ?

carra · 10/26/2010, 13:09

Quote:

Originally Posted by mage200

hmm the service running but i still got this error
maybe i need download something?

you need db for start server

Quote:

Originally Posted by xnukex77

can u re-upload db&files ?

db was not uploaded... kevin,lastthief,..etc are the creators of db....will create a new db

kevin_owner · 10/26/2010, 13:12

Quote:

Originally Posted by mage200

hmm the service running but i still got this error
maybe i need download something?

I don't think you need something else to run it. can you login at your sql server with the same user an password you used in your database.ini?

Quote:

Originally Posted by xnukex77

can u re-upload db&files ?

Well uuhm the db isn't complete yet so it's useless to upload it and the files are just the one of the arcane release but i've added some more output line so see where the program is in the code.

Quote:

Originally Posted by carra

you need db for start server

indeed

kevin_owner · 10/26/2010, 13:30

Owh yeah forgot to say but you need to edit the server.ini too it's the same as database.ini. the only change is the name connection which is connectionstring in server.ini

I've uploaded a little rip of my database (see attachment) this one contains the tables: news, users and server. in all table there is a example record of what you can fill in at the columns. I don't know if everything is correct so don't expect to much

kevin_owner · 10/26/2010, 13:39

Quote:

Originally Posted by carra

what is this?
database demo?

Yeah sort of with this database you can add a news thing in the launcher you ocan add a server and you can login. Mabye that some people who where stuck at some of these points can help to restore the rest of the db.

btw, The password md5 hash must be uppercase!!! if this hash is lowercase it'll give you a c5 error which means wrong usersname or password.

edit: the reason i didn't add those other tables is that they aren't complete and some thing still doesn't work properly

kevin_owner · 10/26/2010, 13:48

Quote:

Originally Posted by carra

but is nice man... gj
and what i need for open db?
MySql and connector mysql? cuz i see have .bak
and other work fine?

you need microsoft sql server 2005 or higher
as far as i know you don't need any connector.

You have to find the option to restore a database in your Microsoft SQL Server Management Studio or how that thing is called.

CrystalCoder · 10/26/2010, 13:55

kevin what is this the database why he say the format worng
and what is gonna help me with the loginserver +gameserver error?

kevin_owner · 10/26/2010, 14:01

@mage200
read:

this post if my.

Code:

[DATABASE]
connection=Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;

This is the .ini in the bin folder which comes with the release.
Change:
MyServerAddres, MyDatabase, MyUsername, MyPassword.
and add this at the end of this file:

Code:

MultipleActiveResultSets=True;

So it'll look like this when you added the line above.

Code:

[DATABASE]
connection=Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;MultipleActiveResultSets=True;

The only thing you have to do is fill it in and you're done