[C#]The Arcane Development Thread

Quote:

Originally Posted by carra - HeavyLegend? what db you use for open login server and game server?

please stop spamming, he use mssql database , like original silkroad serverfiles.

Quote:

Originally Posted by moldi please stop spamming, he use mssql database , like original silkroad serverfiles.

ok... srry

Heavy will you release this "?

not leeching but because i made db and i got plenty of errors so i want to analyse the db

[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]

nothing is impossible :mofo:

msn [Only registered and activated users can see links. Click Here To Register...]

@up show your "server" table .

@LastThief Open Gameserver/game/file/fileload.cs and delete LoadObjectMastery.

@heavy

plenty errors on making don`t know really how to fix it and i want to take look at the db will you share ?

can anybody share this db?

[Only registered and activated users can see links. Click Here To Register...]

:P so now lets got to the karakterler db^^

Someone remember that Lyzerk did another C# emu in the past based on MySQL? Well I was thinking that since the same person did it, he probably used the same structure on the tables. I mounted the old lyzerk db. Since I can't pass the damn db connection (why I suck so much at mssql?! T_T) I will share it here, might can help you guys ^^

karakterler:
[Only registered and activated users can see links. Click Here To Register...]

serverlar (server on the actual db):
[Only registered and activated users can see links. Click Here To Register...]

i can translate. My from turkey ;)

Maybee that CharDatabase works!

USE [SREMU]
GO
/****** by Traumfänger (cp-g.de)
/****** Objekt: Table [dbo].[karakterler] Skriptdatum: 10/23/2010 23:31:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[karakterler](
[id] [int] NOT NULL,
[account] [text] COLLATE Latin1_General_CI_AS NOT NULL,
[name] [text] COLLATE Latin1_General_CI_AS NOT NULL,
[model] [int] NOT NULL,
[volume] [smallint] NOT NULL,
[level] [smallint] 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,
[expirience] [bigint] NOT NULL,
[sbpar] [int] NOT NULL,
[sp] [int] NOT NULL,
[gm] [smallint] NOT NULL,
[xsect] [smallint] NOT NULL,
[ysect] [smallint] NOT NULL,
[xpos] [int] NOT NULL,
[ypos] [int] NOT NULL,
[zpos] [int] NOT NULL,
[s_hp] [int] NOT NULL,
[s_mp] [int] NOT NULL,
[min_phyatk] [int] NOT NULL,
[max_phyatk] [int] NOT NULL,
[min_magatk] [int] NOT NULL,
[max_magatk] [int] NOT NULL,
[phydef] [smallint] NOT NULL,
[magdef] [smallint] NOT NULL,
[hit] [smallint] NOT NULL,
[parry] [smallint] NOT NULL,
[unknown] [nvarchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
[walkspeed] [int] NOT NULL,
[runspeed] [int] NOT NULL,
[berserkerspeed] [int] NOT NULL,
[berserkerbar] [smallint] NOT NULL,
[unknown2] [nvarchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
[mag_absord] [smallint] NOT NULL,
[phy_absord] [smallint] NOT NULL,
[savearea] [smallint] NOT NULL,
[title] [smallint] NOT NULL,
[deleted] [smallint] NOT NULL,
[deletedtime] [datetime] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

Credits to [Only registered and activated users can see links. Click Here To Register...]

Maybee that CharDatabase works!

Credits to [Only registered and activated users can see links. Click Here To Register...]

Attached the web server. =)

Quote:

Originally Posted by Synx7 Someone remember that Lyzerk did another C# emu in the past based on MySQL? Well I was thinking that since the same person did it, he probably used the same structure on the tables. I mounted the old lyzerk db. Since I can't pass the damn db connection (why I suck so much at mssql?! T_T) I will share it here, might can help you guys ^^ karakterler: [Only registered and activated users can see links. Click Here To Register...] serverlar (server on the actual db): [Only registered and activated users can see links. Click Here To Register...]

I believe these 2 tables r exactly the same which is on the arcane needed, because when i was remaking db on my own i did notice exactly the same tables -.-

anyway you guys were talking about skip the mastery.txt ... do that... you won't be able to lvlup the masteries:awesome: