[C#]The Arcane Development Thread

10/25/2010 17:18 moldi#106
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
Quote:
[Only registered and activated users can see links. Click Here To Register...]
10/25/2010 17:24 kevin_owner#107
Quote:
Originally Posted by Miki Maus View Post
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
10/25/2010 18:09 moldi#108
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:[Only registered and activated users can see links. Click Here To Register...]



EDIT: how can i connect to server? When i try to connect with edxloader it`s come with a chinesse error.
10/25/2010 18:43 kevin_owner#109
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:)
10/25/2010 19:00 kevin_owner#110
C4 or C5 is wrong pass or username. at least I think.

and the password has md5 if I saw it correctly.
10/25/2010 20:53 kevin_owner#111
I've a question does anyone else has a problem with the datareader thing
I'm often getting this error:
Code:
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.
10/25/2010 21:04 LastThief#112
@kevin owner

i got kartkelr db send me your db and i will add it and your database.ini too
10/25/2010 21:09 penelopee#113
@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
10/25/2010 21:48 Shane¸#114
Quote:
Originally Posted by kevin_owner View Post
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:)
Quote:
Originally Posted by kevin_owner View Post
C4 or C5 is wrong pass or username. at least I think.

and the password has md5 if I saw it correctly.
Quote:
Originally Posted by kevin_owner View Post
I've a question does anyone else has a problem with the datareader thing
I'm often getting this error:
Code:
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 [Only registered and activated users can see links. Click Here To Register...] button:facepalm:
password has MD5 hashing ( but only capital letters ), C5 is wrong pw.
Did you try to get some info's from the webserver?
10/25/2010 21:55 kevin_owner#115
Quote:
Originally Posted by .Shane. View Post
Use the [Only registered and activated users can see links. Click Here To Register...] button:facepalm:
password has MD5 hashing ( but only capital letters ), C5 is wrong pw.
Did you try to get some info's from the webserver?
:facepalm: 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
10/25/2010 23:57 Mostafa Khater#116
@kevin_owner do you have the right data folder? hmm the client 1.702 data files..
please attach it zipped or rared
10/26/2010 00:03 kevin_owner#117
Quote:
Originally Posted by Mostafa Khater View Post
@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.
10/26/2010 00:44 polat2587#118
im error im edx loader lounch end error help me
[Only registered and activated users can see links. Click Here To Register...]
10/26/2010 00:58 kevin_owner#119
Quote:
Originally Posted by polat2587 View Post
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:
Code:
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
Code:
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
10/26/2010 03:04 3lyka#120
Im stuck with "there is already an open DataReader"

MultipleActiveResultSets=True; dont help