[C#]The Arcane Development Thread

[moldi]

so, after hours of searching i found the problem, it`s all about data files ( itemdata_xxxx ). I deleted something from itemdata_5000 and i make it . So, did someone know why only at me it gave error if the itemdata_xxxx is bigger ?

here a pic

[kevin_owner]

Originally Posted by Miki Maus

try without this: AND deleted != '1' or set it AND deleted = '0' maybe will work i'm not sure

yeah indeed that's a good alternative. The first thing i did was to remove that and that gave me a characterlisting() error so i'll try some other things.

moldi you need the data files from the 1.702 ksro client which is included in the .rar file in one of my previous posts. mabye that's your problem

[moldi]

So, i just delete some items from itemdata_xxx and i make it work. But the problem is , how i can put the rest of items to be readed? I mean, to be in game? If i delete them... A pic:



EDIT: how can i connect to server? When i try to connect with edxloader it`s come with a chinesse error.

[kevin_owner]

Well you need those files to play this game normal mabye is it somewith the size of some values with int32 and int64 my os is a 64-bit mabye yours is 32-bit and are those integers too long to load.

and about your other problem. be sure that you checked mutliclient on your edxloader thing. I'd the same problem and checked multiclient and it started

[kevin_owner]

C4 or C5 is wrong pass or username. at least I think.

and the password has md5 if I saw it correctly.

[kevin_owner]

I've a question does anyone else has a problem with the datareader thing
I'm often getting this error:

There is already an open DataReader ossociated with this Command which must be closed first

I've to change the place where the datareader closes to make it work without an error.

[LastThief]

@kevin owner

i got kartkelr db send me your db and i will add it and your database.ini too

[penelopee]

@last thief , would you release your db ? if you fix and add some more?

(trying to make db XD)

EDIT : @ last thief , this was my question ^^ ," if you comlpete it , then you release it ?" was my basic question , Ty alot for all workers here !!! +1 for all

Greatz: Penelopee

[Shane¸]

Originally Posted by kevin_owner

Well you need those files to play this game normal mabye is it somewith the size of some values with int32 and int64 my os is a 64-bit mabye yours is 32-bit and are those integers too long to load.

and about your other problem. be sure that you checked mutliclient on your edxloader thing. I'd the same problem and checked multiclient and it started

Originally Posted by kevin_owner

C4 or C5 is wrong pass or username. at least I think.

and the password has md5 if I saw it correctly.

Originally Posted by kevin_owner

I've a question does anyone else has a problem with the datareader thing
I'm often getting this error:

There is already an open DataReader ossociated with this Command which must be closed first

I've to change the place where the datareader closes to make it work without an error.

Use the button
password has MD5 hashing ( but only capital letters ), C5 is wrong pw.
Did you try to get some info's from the webserver?

[kevin_owner]

Originally Posted by .Shane.

Use the button
password has MD5 hashing ( but only capital letters ), C5 is wrong pw.
Did you try to get some info's from the webserver?

uuhm i can't help that there was spam between my posts which is deleted I responded to other people.
and no i haven't tried the webserver I get this error when the Characterlisting() is called exactly at the point where it wants to load the items which has the characters wearing

[Mostafa Khater]

@kevin_owner do you have the right data folder? hmm the client 1.702 data files..
please attach it zipped or rared

[kevin_owner]

Originally Posted by Mostafa Khater

@kevin_owner do you have the right data folder? hmm the client 1.702 data files..
please attach it zipped or rared

Here you are. I don't know if the mastery.txt is the good one it loads but I don't know if it works.

[polat2587]

im error im edx loader lounch end error help me

[kevin_owner]

Originally Posted by polat2587

im error im edx loader lounch end error help me

Check mutliclient on your edx loader and it'll start.

and for the people we also having the "there is already an open DataReader" error add this: "MultipleActiveResultSets=True;" to you database.ini or server.ini i don't know which one i added it at both and the error is gone.

EDIT: Who are still trying to create the server or users table I think I got those 2 table working.

server:

id -> int
serverid -> smallint
name -> varchar(50)
users_current -> smallint
users_max -> smallint
state -> tinyint
ip -> varchar(20)
port -> smallint
type -> tinyint


make id auto increment
serverid = own choice for example 1
name = server name for example 'test'
users_current = 0
users_max = max users in server for example '500'
state = 0 for check, 1 for online
ip = ip of the gameserver for example '127.0.0.1'
port = port of the gameserver for example '15780'
type = no idea I let this one 0

userid -> int
id -> varchar(50)
password -> varchar(50)
blocked -> tinyint
online -> tinyint
unkown -> int
silk -> int
gold -> bigint


userid = auto increment
id = username you want to use to login
password = password to login
blocked = make this one 0
online = make this one 0
unkown = i have no idea what this column does i created this one to have enough columns
silk = the amount of silk
gold = the amount of gold

One thing about the password in the users table be sure this one is md5 with uppercase or else you'll get a (C5) error. So if you want 'admin' as your password the md5 will be like this:
21232F297A57A5A743894A0E4A801FC3

[3lyka]

Im stuck with "there is already an open DataReader"

MultipleActiveResultSets=True; dont help