[C#]The Arcane Development Thread

kevin_owner · 10/26/2010, 14:19

This is how your loginserver should look like if you haven't modified anything.
These 3 lines mean:
Login Server Started...
Connected with the database...
News list ready...

(Google translate ftw

)

If you have this output you can connect with a client to it and login. You don't need a gameserver running to start the client or to login. So if your login server works you can try to login if you get a C9 Error when you trie to login your loginserver works correctly

cuz that error means that he couldn't find the gameserver

CrystalCoder · 10/26/2010, 14:29

wow thank kevin this is what he display me
but if gameserver not load so object ingame not load right?

CrystalCoder · 10/26/2010, 14:31

what error you get and if its the problem of me
so i looking at microsoft

kevin_owner · 10/26/2010, 14:58

Quote:

Originally Posted by fukmaka

if you need any help with translating hungarian stuff to english, just pm me, i can help you

I've got almost everything translated to english google translate did a pretty great job

Quote:

Originally Posted by carra

now work...
edit: but idk how to use use microsoft sql server menegement studio express 2005 :| )

edit2:

what i need add here?

and when click open database.bik ... nothing happened

You don't need to open the database.bik at this window this is the login screen to login to the database these are the data you need for the database.ini and server.ini to login

The first thing you have to select is the server name if you have a sql server running on your pc it'll be in that list select one

the second one is what you choice in the installation but i think that SQL Server Authentication work with:
Username: sa
password: 1234 (or let the password field empty)

kevin_owner · 10/26/2010, 15:17

Quote:

Originally Posted by carra

and what i need write in server name?

edit: cuz i write in "server name" - silkroad and say error...

There should be a server in the list when you press that little black arrow

Quote:

Originally Posted by ReaLLiF

this ur db?

How i do ?

Restore? Or Backup (Bullshit SQL 2008)

Yeah create a database and restore it and restore by device or file if i remember correctly. There are tons of guides how to restore a .bak database

btw, there are a few stored procedures and some other trash cuz i created this database in sql server 2000 and that one was very bugged at my pc so i used the incomplete server .bak deleted all those tables and created this one.

kevin_owner · 10/26/2010, 15:46

Quote:

Originally Posted by carra

you can add me skype?
and come in my pc for help me plss

sorry but i don't have time for that and my skype and other things are for private use (same thing i said in my previous post)

Quote:

Originally Posted by mage200

kevin my database dont have
storge items and etc only:
dbo.hotkeys
dbo.karakterler
dbo.news
dbo.server
dbo.serverlar
dbo.users

can you upload me the db your using?

I've uploaded my database:

This is the database i've uploaded the rest doesn't work properly cuz my database is still INCOMPLETE.

when it's done i'll release it (if someone isn't faster) but for now that is the database part which kinda works correct.

I've uploaded that one for the people who where stuck at the news, server or users table so they can help to rebuild the rest of the database

This thread is NOT for this help asking and how to create a database if you don't know how to create a database search on google and wait till it's complete with a tutorial on how to use it.

The last 3 pages where too less about the actual progress and more like how can i make a db which is not the point of this whole thread.

kevin_owner · 10/26/2010, 16:11

Quote:

Originally Posted by mage200

ok kevin i am sorry i dont mean crazy you.
hmm now i start the game some strange error
here is picture:
[IMG][/IMG]

Well i've got a tip:
change the gateway port to 15778 and the agent server port to 15780

and check multiclient.

@carra mabye a reinstall helps

and check everything. btw which version do you have of sql server 2005? (shouldn't be a problem every version has a database engine but just in case)

kevin_owner · 10/26/2010, 16:15

Quote:

Originally Posted by LastThief

i got how to connect to db.ini without need of pc name i will make tut soon

that'll be great for the people who are still having problems.

btw, i've a question about the saved_skills table

is this table like:

id
owner
skill
amountskill

or that lame inefficient way like the mysql database version which lyzerk released.
which looked like this:

id
owner
amountskill
skill1
skill2
...
skill500

?

~~LastThief~~ · 10/26/2010, 16:56

Quote:

Originally Posted by kevin_owner

that'll be great for the people who are still having problems.

btw, i've a question about the saved_skills table

is this table like:

id
owner
skill
amountskill

or that lame inefficient way like the mysql database version which lyzerk released.
which looked like this:

id
owner
amountskill
skill1
skill2
...
skill500

?

i think he tried to make the source code shorter by using less strings and instead of using much skills from 1-50 (for example) he used 1 string which saves all skills

btw can you release your last db that char creation work on i can continue from it cause i tried yesterday and its worked but now no !! i don`t know whats the problem anyway when i got your db i will complete it on friday on my spare time do you mind sharing it ?

kevin_owner · 10/26/2010, 17:26

Quote:

Originally Posted by LastThief

i think he tried to make the source code shorter by using less strings and instead of using much skills from 1-50 (for example) he used 1 string which saves all skills

btw can you release your last db that char creation work on i can continue from it cause i tried yesterday and its worked but now no !! i don`t know whats the problem anyway when i got your db i will complete it on friday on my spare time do you mind sharing it ?

I'm also having problems with the creation of a char it. I think it's somethign with the datetime column but i'll send my db to you if i got it working.
I've one record in my table which works but when i add another one it fails and doesn't show anything. I think that there is a something wrong in the table cause when i select that char and press start it fails to send the char data everything is loaded except the endPlayerLoad()

sorry for this crappy english i did some other things while i wrote this so there might be some wrong sentences.

Xsense · 10/26/2010, 17:42

Here is the character table , creation for me works fine.
Now i have to figure out the character listening

Enjoy

Code:

/****** Object:  Table [dbo].[karakterler]    Script Date: 10/26/2010 17:38:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[karakterler](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[account] [varchar](50) NULL,
	[name] [varchar](50) NULL,
	[chartype] [int] NULL,
	[volume] [tinyint] NULL,
	[lvl] [tinyint] NULL,
	[strength] [smallint] NULL,
	[intelligence] [smallint] NULL,
	[attribute] [smallint] NULL,
	[hp] [int] NULL,
	[mp] [int] NULL,
	[gold] [bigint] NULL,
	[xp] [bigint] NULL,
	[spbar] [int] NULL,
	[sp] [int] NULL,
	[gm] [tinyint] NULL,
	[xsec] [tinyint] NULL,
	[ysec] [tinyint] NULL,
	[xpos] [int] NULL,
	[ypos] [int] NULL,
	[zpos] [int] NULL,
	[s_hp] [int] NULL,
	[s_mp] [int] 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,
	[berserk] [tinyint] NULL,
	[berserkb] [tinyint] NULL,
	[unknown3] [nchar](10) NULL,
	[mag_ab] [smallint] NULL,
	[phy_ab] [smallint] NULL,
	[place] [tinyint] NULL,
	[title] [tinyint] NULL,
	[deleted] [tinyint] NULL,
	[deletedtime] [datetime] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

Edit:
Btw, creating a character has little issues.
So ive edited the code in (Character.cs)

Search for:

Code:

+ Math.Round(MagDef) +

Replace it with a simple value for now until fixed.
My example below

Code:

+ "', magdef='" + "4" +

Xsense · 10/26/2010, 17:49

Quote:
Originally Posted by kevin_owner
yeah indeed.
I've made a lot of reference points in my gameserver to see which function it uses at which time so i know which what it needs and where it went wrong. for now it's in the CharacterListen function when it does something with time i'm not sure what that exactly does
Code:
                    TimeSpan ts = Convert.ToDateTime(reader.GetDateTime(43)) - DateTime.Now;
                    double time = ts.TotalMinutes;
                    if (Math.Round(time) > 0)
                    {
                        Writer.Byte(1);
                        Writer.DWord(Math.Round(time));
                    }
                    else
                    {
                        Writer.Byte(0);
                    }
                    if (Math.Round(time) <= 0 && Convert.ToDateTime("01.01.1900 00:00:00") != reader.GetDateTime(43))
                    {
                        MsSQL.UpdateData("UPDATE karakterler SET deleted='1' Where id='" + reader.GetInt32(0) + "'");
                    }
I know it's for a check if the char has to be restored or deleted but i don't know which value it really wants so that's what i got to find out.

I have disabled it / commented it out , its not really needed.
Basicly as you said above it check / updates deletion time of a character.
And updates a character to deleted = true.

If you dont mind sharing , character listening as far as you have got that done.
Saves time reading the code, and continuing for ingame loading.

kevin_owner · 10/26/2010, 17:56

Quote:

Originally Posted by Xsense

I have disabled it / commented it out , its not really needed.
Basicly as you said above it check / updates deletion time of a character.
And updates a character to deleted = true.

If you dont mind sharing , character listening as far as you have got that done.
Saves time reading the code, and continuing for ingame loading.

oke well the charlisting is just reading all the stuff from the database.
The charlisting function is in the Private.cs it only reads the basic info.

Code:

                    Writer.DWord(reader.GetInt32(3));
                    Writer.Text(reader.GetString(2));
                    Writer.Word(0);
                    Writer.Byte(reader.GetByte(4));
                    Writer.Byte(reader.GetByte(5));
                    Writer.LWord(reader.GetInt64(12));
                    Writer.Word(reader.GetInt16(6));
                    Writer.Word(reader.GetInt16(7));
                    Writer.Word(reader.GetInt16(8));
                    Writer.DWord(reader.GetInt32(9));
                    Writer.DWord(reader.GetInt32(10));
TimeSpan ts = Convert.ToDateTime(reader.GetDateTime(43)) - DateTime.Now;

These are things it wants from the database the first lines till reader.GetInt32(10) ain't a problem it reads it but the last line gives a problem i don't know which format the time has to be. I had it working but i have no idea what the problem is at the moment so i'll try different values.

Xsense · 10/26/2010, 18:01

Quote:
Originally Posted by kevin_owner
oke well the charlisting is just reading all the stuff from the database.
The charlisting function is in the Private.cs it only reads the basic info.
Code:
                    Writer.DWord(reader.GetInt32(3));
                    Writer.Text(reader.GetString(2));
                    Writer.Word(0);
                    Writer.Byte(reader.GetByte(4));
                    Writer.Byte(reader.GetByte(5));
                    Writer.LWord(reader.GetInt64(12));
                    Writer.Word(reader.GetInt16(6));
                    Writer.Word(reader.GetInt16(7));
                    Writer.Word(reader.GetInt16(8));
                    Writer.DWord(reader.GetInt32(9));
                    Writer.DWord(reader.GetInt32(10));
TimeSpan ts = Convert.ToDateTime(reader.GetDateTime(43)) - DateTime.Now;
These are things it wants from the database the first lines till reader.GetInt32(10) ain't a problem it reads it but the last line gives a problem i don't know which format the time has to be. I had it working but i have no idea what the problem is at the moment so i'll try different values.

I will read those lines,
And see what i can do, i will share the information as soon as i have it done.
Thanks for letting me know.

@the poster above me,
This is a coding forum, im not sure if this is relevant to the topic.

dipointed · 10/26/2010, 18:12

Actually the client crashes at its own.
The server still runs properly, so I guess the chardata packet will be wrong.

uh yeah btw.
I've seen many of you are posting your character table.
Actually I see there could be some problems as soon as you'll get into the chardata packet.
There are 3 unknown values which I miss in your tables.
Check my dump:

Code:

USE [SREMU]
GO
/*** chartable by dipointed
/****** Objekt:  Table [dbo].[karakterler]    Skriptdatum: 10/26/2010 18:11:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[karakterler](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[account] [nvarchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
	[name] [nvarchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
	[chartype] [int] NOT NULL,
	[volume] [tinyint] NOT NULL,
	[level] [tinyint] NOT NULL CONSTRAINT [DF_karakterler_level]  DEFAULT ((1)),
	[strength] [smallint] NOT NULL CONSTRAINT [DF_karakterler_strength]  DEFAULT ((20)),
	[intelligence] [smallint] NOT NULL CONSTRAINT [DF_karakterler_intelligence]  DEFAULT ((20)),
	[attribute] [smallint] NOT NULL CONSTRAINT [DF_karakterler_attribute]  DEFAULT ((0)),
	[hp] [int] NOT NULL CONSTRAINT [DF_karakterler_hp]  DEFAULT ((200)),
	[mp] [int] NOT NULL CONSTRAINT [DF_karakterler_mp]  DEFAULT ((200)),
	[gold] [bigint] NOT NULL CONSTRAINT [DF_karakterler_gold]  DEFAULT ((0)),
	[expirience] [bigint] NOT NULL CONSTRAINT [DF_karakterler_expirience]  DEFAULT ((0)),
	[sbpar] [int] NOT NULL CONSTRAINT [DF_karakterler_sbpar]  DEFAULT ((0)),
	[sp] [int] NOT NULL CONSTRAINT [DF_karakterler_sp]  DEFAULT ((0)),
	[gm] [tinyint] NOT NULL CONSTRAINT [DF_karakterler_gm]  DEFAULT ((0)),
	[xsect] [tinyint] NULL CONSTRAINT [DF_karakterler_xsect]  DEFAULT ((168)),
	[ysect] [tinyint] NULL CONSTRAINT [DF_karakterler_ysect]  DEFAULT ((98)),
	[unknown3] [nvarchar](50) COLLATE Latin1_General_CI_AS NULL,
	[xpos] [int] NULL CONSTRAINT [DF_karakterler_xpos]  DEFAULT ((966)),
	[ypos] [int] NULL CONSTRAINT [DF_karakterler_ypos]  DEFAULT ((1090)),
	[zpos] [int] NULL CONSTRAINT [DF_karakterler_zpos]  DEFAULT ((40)),
	[s_hp] [int] NOT NULL CONSTRAINT [DF_karakterler_s_hp]  DEFAULT ((200)),
	[s_mp] [int] NOT NULL CONSTRAINT [DF_karakterler_s_mp]  DEFAULT ((200)),
	[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) COLLATE Latin1_General_CI_AS NULL,
	[walkspeed] [int] NULL CONSTRAINT [DF_karakterler_walkspeed]  DEFAULT ((50)),
	[runspeed] [int] NULL CONSTRAINT [DF_karakterler_runspeed]  DEFAULT ((50)),
	[berserkerspeed] [int] NULL CONSTRAINT [DF_karakterler_berserkerspeed]  DEFAULT ((50)),
	[berserkerbar] [tinyint] NULL CONSTRAINT [DF_karakterler_berserkerbar]  DEFAULT ((0)),
	[unknown2] [nvarchar](50) COLLATE Latin1_General_CI_AS NULL,
	[mag_absord] [smallint] NULL CONSTRAINT [DF_karakterler_mag_absord]  DEFAULT ((0)),
	[phy_absord] [smallint] NULL CONSTRAINT [DF_karakterler_phy_absord]  DEFAULT ((0)),
	[savearea] [tinyint] NULL CONSTRAINT [DF_karakterler_savearea]  DEFAULT ((1)),
	[title] [tinyint] NULL CONSTRAINT [DF_karakterler_title]  DEFAULT ((1)),
	[deleted] [tinyint] NULL CONSTRAINT [DF_karakterler_deleted]  DEFAULT ((0)),
	[deletedtime] [datetime] NULL CONSTRAINT [DF_karakterler_deletedtime]  DEFAULT ('10.10.2010')
) ON [PRIMARY]

€: oh yeah I forgot.
Does somebody know what is meant with 'savearea'?
I have no clue where this comes from.