[C#]The Arcane Development Thread

Page 10 of 17 « First 89 10 1112 Last »
10/26/2010 14:19 kevin_owner#136
[Only registered and activated users can see links. Click Here To Register...]
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:D)

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
10/26/2010 14:29 CrystalCoder#137
wow thank kevin this is what he display me
but if gameserver not load so object ingame not load right?
10/26/2010 14:31 CrystalCoder#138
what error you get and if its the problem of me
so i looking at microsoft
10/26/2010 14:58 kevin_owner#139
Quote:
Originally Posted by fukmaka View Post
if you need any help with translating hungarian stuff to english, just pm me, i can help you :p
I've got almost everything translated to english google translate did a pretty great job:)
Quote:
Originally Posted by carra View Post
now work...
edit: but idk how to use use microsoft sql server menegement studio express 2005 :| :))

edit2:

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

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)
10/26/2010 15:17 kevin_owner#140
Quote:
Originally Posted by carra View Post
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 View Post
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.
10/26/2010 15:46 kevin_owner#141
Quote:
Originally Posted by carra View Post
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 View Post
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:
[Only registered and activated users can see links. Click Here To Register...]

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.
10/26/2010 16:11 kevin_owner#142
Quote:
Originally Posted by mage200 View Post
ok kevin i am sorry i dont mean crazy you.
hmm now i start the game some strange error
here is picture:
[IMG][Only registered and activated users can see links. Click Here To Register...][/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:rolleyes: 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)
10/26/2010 16:15 kevin_owner#143
Quote:
Originally Posted by LastThief View Post
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

?
10/26/2010 16:56 LastThief#144
Quote:
Originally Posted by kevin_owner View Post
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 ?
10/26/2010 17:26 kevin_owner#145
Quote:
Originally Posted by LastThief View Post
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.
10/26/2010 17:42 Xsense#146
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" +
10/26/2010 17:49 Xsense#147
Quote:
Originally Posted by kevin_owner View Post
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.
10/26/2010 17:56 kevin_owner#148
Quote:
Originally Posted by Xsense View Post
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.
10/26/2010 18:01 Xsense#149
Quote:
Originally Posted by kevin_owner View Post
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.
10/26/2010 18:12 dipointed#150
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.
Page 10 of 17 « First 89 10 1112 Last »