[C#]The Arcane Development Thread

[moldi]

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.

[carra]

Originally Posted by moldi

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

ok... srry

[LastThief]

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

[ruancarlosbr]

nothing is impossible

msn

[CraYu]

@up show your "server" table .

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

[LastThief]

@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 ?

[tahsincan]

can anybody share this db?

[chea77er]

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

[Kape7]

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 **** db connection (why I suck so much at mssql?! T_T) I will share it here, might can help you guys ^^

karakterler:


serverlar (server on the actual db):

[xnukex77]

i can translate. My from turkey

[huisasiwdomu]

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

[huisasiwdomu]

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

[Kape7]

Attached the web server. =)

[Miki Maus]

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 **** db connection (why I suck so much at mssql?! T_T) I will share it here, might can help you guys ^^

karakterler:


serverlar (server on the actual db):

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 -.-

[Shane¸]

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