[C#]The Arcane Development Thread

Quote:

Originally Posted by kevin_owner Aha oke but do you run your gameserver in debug mode cuz i'm also having problems with a program in debug mode to read .txt files and silkroad doesn't have a default login you have to create one in the users table Well I don't have any suggestion(cuz I don't know much about opcodes. I'm still trying to figure out how those things work and how i can write a packet reader in c++) but I have a little question. In the Private.cs about line 86 there is this query: Code: MsSQL ms = new MsSQL("SELECT TOP 4 * FROM karakterler WHERE account='" + name + "' AND deleted != '1'"); does this one work for you or did you changed it? cuz i'd to change it to 'deleted = 0'

 MsSQL ms = new MsSQL("SELECT * FROM karakterler WHERE account='" + name + "'");

Quote:

Originally Posted by mage200 ok i can enter game interface but no servers strange error in loginserver gameserver isnt run here picture: [IMG][Only registered and activated users can see links. Click Here To Register...][/IMG]

Quote:

Originally Posted by kevin_owner I also got the char creating working at the moment The displaying failed when it tries to load the char_items I think that my char_items table is wrong My char_items table looks like this: Code: id -> int (and auto increment) itemnumber -> varchar itemid -> int owner -> int plusvalue -> int slot - > int type -> int quantity -> int durability -> int inavatar -> int could this be correct?

	[id] [int] NULL,
	[itemid] [varchar](50) NULL,
	[plusvalue] [int] NULL,
	[durability] [int] NULL,
	[owner] [int] NULL,
	[itemnumber] [varchar](50) NULL,
	[slot] [tinyint] NULL,
	[type] [bigint] NULL,
	[inavatar] [bigint] NULL,
	[quantity] [bigint] NULL

Quote:

Originally Posted by kevin_owner Hmmm i don't think that your table is correct.  Spoiler Code: public static void PrivateItemPacket(PacketWriter Writer, int id, byte iType, byte max, byte avatar) { try { List<byte> slots = new List<byte>(); MsSQL ms = new MsSQL("SELECT * FROM char_items WHERE owner='" + id + "' AND type='" + iType + "' AND slot >= '0' AND slot <= '" + max + "' AND inavatar='" + avatar + "'"); using (SqlDataReader reader = ms.Read()) { int count = ms.Count(); Console.WriteLine(count); Writer.Byte(count); while (reader.Read()) { if (reader.GetInt32(2) != 0) { if (!slots.Exists(delegate(byte bk) { return bk == reader.GetByte(5); })) { slots.Add(reader.GetByte(5)); Console.WriteLine("I've added slots.add() value = " + reader.GetByte(5)); } else { Console.WriteLine("item bug found::{0}::{1}::{2}::{3}", avatar, reader.GetByte(5), reader.GetInt32(2), id); } Writer.DWord(reader.GetInt32(2)); Writer.Byte(reader.GetByte(4)); } } } ms.Close(); } catch (Exception ex) { Console.WriteLine("PrivateItemPacket()::Error.."); deBug.Write(ex); } } This is the PrivateItemPacket thing which is called twice in the Charlisting function. But I can't find which column it want's as the 5th and 6th one. I assume that the 3rd column would be the itemid. So the 5th and 6th ones are both byte. so my question is did anyone find out which column does those things want i've tried my combinations and the client crashes when there is a char_item available so i thinkt that means wrong packet:rolleyes:

Quote:

Originally Posted by moldi When i press start to enter in game, my client crashes suddenly. Does you know the resolv? BTW, i have a ideea, Would a moderator create a thread when we can post the errors and problems? Because this thread is for developing not for questions xD.

Quote:

Originally Posted by kevin_owner Hmmm i don't think that your table is correct.  Spoiler Code: public static void PrivateItemPacket(PacketWriter Writer, int id, byte iType, byte max, byte avatar) { try { List<byte> slots = new List<byte>(); MsSQL ms = new MsSQL("SELECT * FROM char_items WHERE owner='" + id + "' AND type='" + iType + "' AND slot >= '0' AND slot <= '" + max + "' AND inavatar='" + avatar + "'"); using (SqlDataReader reader = ms.Read()) { int count = ms.Count(); Console.WriteLine(count); Writer.Byte(count); while (reader.Read()) { if (reader.GetInt32(2) != 0) { if (!slots.Exists(delegate(byte bk) { return bk == reader.GetByte(5); })) { slots.Add(reader.GetByte(5)); Console.WriteLine("I've added slots.add() value = " + reader.GetByte(5)); } else { Console.WriteLine("item bug found::{0}::{1}::{2}::{3}", avatar, reader.GetByte(5), reader.GetInt32(2), id); } Writer.DWord(reader.GetInt32(2)); Writer.Byte(reader.GetByte(4)); } } } ms.Close(); } catch (Exception ex) { Console.WriteLine("PrivateItemPacket()::Error.."); deBug.Write(ex); } } This is the PrivateItemPacket thing which is called twice in the Charlisting function. But I can't find which column it want's as the 5th and 6th one. I assume that the 3rd column would be the itemid. So the 5th and 6th ones are both byte. so my question is did anyone find out which column does those things want i've tried my combinations and the client crashes when there is a char_item available so i thinkt that means wrong packet:rolleyes: UPDATE: I just got the tables right (see screen) one guy wears a body armor now [Only registered and activated users can see links. Click Here To Register...] Code: id -> int owner -> int itemid -> int quantity -> int slot -> tinyint plusvalue -> tinyint itemnumber -> varchar durability -> int type -> bigint inavatar -> bigint I don't know if all the columns are in the right position with the right data type but for the char listing this works. so GetInt32(2) == itemid GetByte(4) == slot GetByte(5) == tinyint So easy if you think about it the client only needs the item id which slot it is and the plusvalue to show those items correctly xD

Quote:

Originally Posted by Xsense I am now at spawncheck :) So making progress Fixed the table , ive used yours above indeed slot was 5 etc. But now i need to check spawncheck :) so im past endload Edit1: Good job on that table :) Thanks from me

Quote:

Originally Posted by kevin_owner nice one You're are just a bit faster than me i'm also ingame. My char_items table still gives some problems so it isn't correct. btw, My proof: [Only registered and activated users can see links. Click Here To Register...]

Quote:

Originally Posted by kevin_owner xsect = 168 ysect = 98 xpos = 966 ypos = 1090 zpos = 40 I got this from CSREMU this where his default values:P

                    slotItem.dbID = reader.GetInt32(0);
                    slotItem.ID = reader.GetInt32(2);
                    slotItem.PlusValue = reader.GetByte(4);
                    slotItem.Type = reader.GetByte(6);
                    slotItem.Amount = reader.GetInt16(7);
                    slotItem.Durability = reader.GetInt32(8);
                    slotItem.Slot = slot;