[C#]The Arcane Development Thread

[kevin_owner]

Originally Posted by Xsense

Thanks for that
Going to set it to default value in database.


Item info

                    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;

I was also busy with the char_items and i got it working I'd a wrong value
my table looks like this:

id -> int
owner -> int
itemid -> int
itemnumber -> varchar(50)
plusvalue -> tinyint
slot -> tinyint
type -> tinyint
quantity -> smallint
durability -> int
inavatar -> int

[Xsense]

nope no problems so far
Ive posted the table above.

Though on creation of item using gm command
It crashes so need to check table again

Edit:
Just testing spawning etc...
Still crashing on item creation so going to continue work and stop messing around

[kevin_owner]

Originally Posted by Xsense

nope no problems so far
Ive posted the table above.

Though on creation of item using gm command
It crashes so need to check table again

Your table isn't the same as my table. But i'll check the gm console in a minute

btw, screen ingame with equipment


owh and i also have a instant return scroll in my inventory with a quantity of 10 so my table seems to work

EDIT: Item creation works with the GM Console

[Xsense]

Originally Posted by kevin_owner

Your table isn't the same as my table. But i'll check the gm console in a minute

btw, screen ingame with equipment


owh and i also have a instant return scroll in my inventory with a quantity of 10 so my table seems to work

EDIT: Item creation works with the GM Console

Mind posting the table
Hope i wasnt to far of with it

[kevin_owner]

Originally Posted by Xsense

Mind posting the table
Hope i wasnt to far of with it

I've posted it at the previous page

id -> int
owner -> int
itemid -> int
itemnumber -> varchar(50)
plusvalue -> tinyint
slot -> tinyint
type -> tinyint
quantity -> smallint
durability -> int
inavatar -> int

I got to find that that option to extract a table as a query thing this way s*cks you have to manually type everything

btw, i'm now creating the storage table

and @ensar00 please be patient. The database isn't completely finished yet i think it's almost complete but we got to test things to see if it works
Sure when it's done it'll be released

EDIT:
oke i think i found it:

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[char_items](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[owner] [int] NULL,
	[itemid] [int] NULL,
	[itemnumber] [varchar](50) NULL,
	[plusvalue] [tinyint] NULL,
	[slot] [tinyint] NULL,
	[type] [tinyint] NULL,
	[quantity] [smallint] NULL,
	[durability] [int] NULL,
	[inavatar] [bigint] NULL,
 CONSTRAINT [PK_char_items] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[char_items] ADD  CONSTRAINT [DF_char_items_itemid]  DEFAULT ((0)) FOR [itemid]
GO

ALTER TABLE [dbo].[char_items] ADD  CONSTRAINT [DF_char_items_plusvalue]  DEFAULT ((0)) FOR [plusvalue]
GO

ALTER TABLE [dbo].[char_items] ADD  CONSTRAINT [DF_char_items_type]  DEFAULT ((0)) FOR [type]
GO

ALTER TABLE [dbo].[char_items] ADD  CONSTRAINT [DF_char_items_quantity]  DEFAULT ((1)) FOR [quantity]
GO

ALTER TABLE [dbo].[char_items] ADD  CONSTRAINT [DF_char_items_durability]  DEFAULT ((30)) FOR [durability]
GO

ALTER TABLE [dbo].[char_items] ADD  CONSTRAINT [DF_char_items_inavatar]  DEFAULT ((0)) FOR [inavatar]
GO

mabye this will be more usefull

[Xsense]

Why share a incomplete database?
Wont help you right now.

Continuing work now on spawning the objects etc...

[kevin_owner]

Originally Posted by Xsense

Why share a incomplete database?
Wont help you right now.

@kevin
Im working on moving items right now

        void ItemMove(byte fromSlot, byte toSlot, short quantity)
        {
            Global.slotItem fromItem = GetItem((uint)Karakter.Information.CharacterID, fromSlot,false);
            Global.slotItem toItem = GetItem((uint)Karakter.Information.CharacterID, toSlot, false);

yeah some things aren't correctly I can move my item in my inventory but i can't buy things or store things at the storage. And I'm getting an error in that error list.txt

[27-10-2010 14:32:41] Object reference not set to an instance of an object. ->    at Game.Systems.InGameSuccess() in \src\GameServer\Game\Private\Character.cs:line 272
   at Game.Systems.oPCode(Decode de) in \src\GameServer\Game\Systems.cs:line 73

[kevin_owner]

Originally Posted by juggler_001

Would you share the database kevin

Dude are you blind? Xsense just said it.
Why share a incomplete database?
Wont help you right now.

read before you post something.

EDIT:

Originally Posted by dipointed

Poorly my client keeps crashing at ingame request.
I guessed smn of you had the same problem.
How did you solve it?
My char_items table works properly

Well i solved it when i removed all the records of the table char_items cuz there was the problem for me

[kevin_owner]

Originally Posted by dipointed

Mhh.. doesn't work for me.
Could you make a karakterler dump of your table..?
Probably I've got an error inside (but I guess not)

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[karakterler](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[account] [nvarchar](50) NOT NULL,
	[name] [nvarchar](50) NOT NULL,
	[chartype] [int] NOT NULL,
	[volume] [tinyint] NOT NULL,
	[level] [tinyint] NOT NULL,
	[strength] [smallint] NOT NULL,
	[intelligence] [smallint] NOT NULL,
	[attribute] [smallint] NOT NULL,
	[hp] [int] NOT NULL,
	[mp] [int] NOT NULL,
	[gold] [bigint] NOT NULL,
	[experience] [bigint] NOT NULL,
	[spbar] [int] NOT NULL,
	[sp] [int] NOT NULL,
	[gm] [tinyint] NOT NULL,
	[xsect] [tinyint] NULL,
	[ysect] [tinyint] NULL,
	[unknown3] [nvarchar](50) NULL,
	[xpos] [int] NULL,
	[ypos] [int] NULL,
	[zpos] [int] NULL,
	[s_hp] [int] NOT NULL,
	[s_mp] [int] NOT NULL,
	[min_phyatk] [int] NULL,
	[max_phyatk] [int] NULL,
	[min_magatk] [int] NULL,
	[max_magatk] [int] NULL,
	[phydef] [smallint] NULL,
	[magdef] [smallint] NULL,
	[hit] [smallint] NULL,
	[parry] [smallint] NULL,
	[unknown] [nvarchar](50) NULL,
	[walkspeed] [int] NULL,
	[runspeed] [int] NULL,
	[berserkerspeed] [int] NULL,
	[berserkerbar] [tinyint] NULL,
	[unknown2] [nvarchar](50) NULL,
	[mag_absord] [smallint] NULL,
	[phy_absord] [smallint] NULL,
	[savearea] [tinyint] NULL,
	[title] [tinyint] NULL,
	[deleted] [tinyint] NULL,
	[deletedtime] [datetime] NULL
) ON [PRIMARY]

GO

ALTER TABLE [dbo].[karakterler] ADD  CONSTRAINT [DF_karakterler_level]  DEFAULT ((1)) FOR [level]
GO

ALTER TABLE [dbo].[karakterler] ADD  CONSTRAINT [DF_karakterler_strength]  DEFAULT ((20)) FOR [strength]
GO

ALTER TABLE [dbo].[karakterler] ADD  CONSTRAINT [DF_karakterler_intelligence]  DEFAULT ((20)) FOR [intelligence]
GO

ALTER TABLE [dbo].[karakterler] ADD  CONSTRAINT [DF_karakterler_attribute]  DEFAULT ((0)) FOR [attribute]
GO

ALTER TABLE [dbo].[karakterler] ADD  CONSTRAINT [DF_karakterler_hp]  DEFAULT ((200)) FOR [hp]
GO

ALTER TABLE [dbo].[karakterler] ADD  CONSTRAINT [DF_karakterler_mp]  DEFAULT ((200)) FOR [mp]
GO

ALTER TABLE [dbo].[karakterler] ADD  CONSTRAINT [DF_karakterler_gold]  DEFAULT ((0)) FOR [gold]
GO

ALTER TABLE [dbo].[karakterler] ADD  CONSTRAINT [DF_karakterler_expirience]  DEFAULT ((0)) FOR [experience]
GO

ALTER TABLE [dbo].[karakterler] ADD  CONSTRAINT [DF_karakterler_sbpar]  DEFAULT ((0)) FOR [spbar]
GO

ALTER TABLE [dbo].[karakterler] ADD  CONSTRAINT [DF_karakterler_sp]  DEFAULT ((0)) FOR [sp]
GO

ALTER TABLE [dbo].[karakterler] ADD  CONSTRAINT [DF_karakterler_gm]  DEFAULT ((0)) FOR [gm]
GO

ALTER TABLE [dbo].[karakterler] ADD  CONSTRAINT [DF_karakterler_xsect]  DEFAULT ((168)) FOR [xsect]
GO

ALTER TABLE [dbo].[karakterler] ADD  CONSTRAINT [DF_karakterler_ysect]  DEFAULT ((98)) FOR [ysect]
GO

ALTER TABLE [dbo].[karakterler] ADD  CONSTRAINT [DF_karakterler_xpos]  DEFAULT ((966)) FOR [xpos]
GO

ALTER TABLE [dbo].[karakterler] ADD  CONSTRAINT [DF_karakterler_ypos]  DEFAULT ((1090)) FOR [ypos]
GO

ALTER TABLE [dbo].[karakterler] ADD  CONSTRAINT [DF_karakterler_zpos]  DEFAULT ((40)) FOR [zpos]
GO

ALTER TABLE [dbo].[karakterler] ADD  CONSTRAINT [DF_karakterler_s_hp]  DEFAULT ((200)) FOR [s_hp]
GO

ALTER TABLE [dbo].[karakterler] ADD  CONSTRAINT [DF_karakterler_s_mp]  DEFAULT ((200)) FOR [s_mp]
GO

ALTER TABLE [dbo].[karakterler] ADD  CONSTRAINT [DF_karakterler_walkspeed]  DEFAULT ((50)) FOR [walkspeed]
GO

ALTER TABLE [dbo].[karakterler] ADD  CONSTRAINT [DF_karakterler_runspeed]  DEFAULT ((50)) FOR [runspeed]
GO

ALTER TABLE [dbo].[karakterler] ADD  CONSTRAINT [DF_karakterler_berserkerspeed]  DEFAULT ((50)) FOR [berserkerspeed]
GO

ALTER TABLE [dbo].[karakterler] ADD  CONSTRAINT [DF_karakterler_berserkerbar]  DEFAULT ((0)) FOR [berserkerbar]
GO

ALTER TABLE [dbo].[karakterler] ADD  CONSTRAINT [DF_karakterler_mag_absord]  DEFAULT ((0)) FOR [mag_absord]
GO

ALTER TABLE [dbo].[karakterler] ADD  CONSTRAINT [DF_karakterler_phy_absord]  DEFAULT ((0)) FOR [phy_absord]
GO

ALTER TABLE [dbo].[karakterler] ADD  CONSTRAINT [DF_karakterler_savearea]  DEFAULT ((1)) FOR [savearea]
GO

ALTER TABLE [dbo].[karakterler] ADD  CONSTRAINT [DF_karakterler_title]  DEFAULT ((1)) FOR [title]
GO

ALTER TABLE [dbo].[karakterler] ADD  CONSTRAINT [DF_karakterler_deleted]  DEFAULT ((0)) FOR [deleted]
GO

ALTER TABLE [dbo].[karakterler] ADD  CONSTRAINT [DF_karakterler_deletedtime]  DEFAULT ('10.10.2010') FOR [deletedtime]
GO

[Xsense]

ok item movement done all works fine.
Now to see storage / spawns

[coderska]

Test this db

[Ghost in Flames]

Originally Posted by coderska

Test this db

with what mssql version you made it?

[xXRobinXx]

Originally Posted by coderska

Test this db

I'm having problems importing this one.

The Results are:

Msg 102, Level 15, State 1, Line 1
Falsche Syntax in der Nähe von '='.
Msg 103, Level 15, State 4, Line 63649
Bezeichner (beginnend mit 'Warlord', '0');
INSERT INTO `items_alt` VALUES ('226', '226', 'ITEM_CH_BOW_04_C', '3', '6', '6', '0', '121500', '1254', '1881',') ist zu lang. Die maximal zulässige Länge beträgt 128.
Msg 105, Level 15, State 1, Line 63649
Kein schließendes Anführungszeichen nach der Zeichenfolge 'Warlord', '0');
INSERT INTO `items_alt` VALUES ('226', '226', 'ITEM_CH_BOW_04_C', '3', '6', '6', '0', '121500', '1254', '1881', '.

€dit:


The Query in Line:

Line 63649

INSERT INTO `items_alt` VALUES ('225', '225', 'ITEM_CH_BOW_04_B', '3', '6', '6', '0', '88500', '1123', '1684', '1549', '30975', '26', '1', '2', '59', '72', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '180', '101', '106', '122', '132', '161', '170', '195', '211', '508', '536', '614', '665', '813', '857', '982', '1064', '69', '85', '2', '12', '-1', '\"Warlord', '0');

Should perhabs be that:

INSERT INTO `items_alt` VALUES ('225', '225', 'ITEM_CH_BOW_04_B', '3', '6', '6', '0', '88500', '1123', '1684', '1549', '30975', '26', '1', '2', '59', '72', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '180', '101', '106', '122', '132', '161', '170', '195', '211', '508', '536', '614', '665', '813', '857', '982', '1064', '69', '85', '2', '12', '-1', 'Warlord', '0');

[Miki Maus]

Originally Posted by coderska

Test this db

wondering why 16mb.. is it complete one?

edit, well it seems like there's loads of tables we werent even wondering about..

[kevin_owner]

probably not the tables names and column names doesn't match with the names in the code or mabye is it an other version and is it correct but did somone changed to names to make his emu sort of unique.

EDIT: Xsense is right It is for mysql and just the whole thing doesn't match with this emu