[C#]The Arcane Development Thread

Page 13 of 17 « First 31112 13 1415 Last »
10/27/2010 14:00 kevin_owner#181
Quote:
Originally Posted by Xsense View Post
Thanks for that
Going to set it to default value in database.


Item info
Code:
                    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:

Code:
id -> int
owner -> int
itemid -> int
itemnumber -> varchar(50)
plusvalue -> tinyint
slot -> tinyint
type -> tinyint
quantity -> smallint
durability -> int
inavatar -> int
10/27/2010 14:03 Xsense#182
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 ;)

[Only registered and activated users can see links. Click Here To Register...]
10/27/2010 14:07 kevin_owner#183
Quote:
Originally Posted by Xsense View Post
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
[Only registered and activated users can see links. Click Here To Register...]

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
10/27/2010 14:11 Xsense#184
Quote:
Originally Posted by kevin_owner View Post
Your table isn't the same as my table. But i'll check the gm console in a minute

btw, screen ingame with equipment
[Only registered and activated users can see links. Click Here To Register...]

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
10/27/2010 14:16 kevin_owner#185
Quote:
Originally Posted by Xsense View Post
Mind posting the table :)
Hope i wasnt to far of with it
I've posted it at the previous page

Code:
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:D

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:
Code:
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
10/27/2010 14:28 Xsense#186
Why share a incomplete database?
Wont help you right now.

Continuing work now on spawning the objects etc...
10/27/2010 14:35 kevin_owner#187
Quote:
Originally Posted by Xsense View Post
Why share a incomplete database?
Wont help you right now.

@kevin
Im working on moving items right now
Code:
        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
Code:
[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
10/27/2010 14:37 kevin_owner#188
Quote:
Originally Posted by juggler_001 View Post
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:
Quote:
Originally Posted by dipointed View Post
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
10/27/2010 14:45 kevin_owner#189
Quote:
Originally Posted by dipointed View Post
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)
Code:
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
10/27/2010 14:49 Xsense#190
ok item movement done :) all works fine.
Now to see storage / spawns
[Only registered and activated users can see links. Click Here To Register...]
10/27/2010 14:52 coderska#191
Test this db
[Only registered and activated users can see links. Click Here To Register...]
10/27/2010 15:02 Ghost in Flames#192
Quote:
Originally Posted by coderska View Post
Test this db
[Only registered and activated users can see links. Click Here To Register...]
with what mssql version you made it?
10/27/2010 15:03 xXRobinXx#193
Quote:
Originally Posted by coderska View Post
Test this db
[Only registered and activated users can see links. Click Here To Register...]
I'm having problems importing this one.

The Results are:

Code:
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

Code:
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:

Code:
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');
10/27/2010 15:06 Miki Maus#194
Quote:
Originally Posted by coderska View Post
Test this db
[Only registered and activated users can see links. Click Here To Register...]
wondering why 16mb.. is it complete one?

edit, well it seems like there's loads of tables we werent even wondering about..
10/27/2010 15:10 kevin_owner#195
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
Page 13 of 17 « First 31112 13 1415 Last »