[C#]The Arcane Development Thread

[kevin_owner]

The database will be released when it's done. Idk when it's done just WAIT. I'm having some problems with the storage and buying stuff it just doesn't work. no error no crash. I've to find to that problem

[kevin_owner]

Originally Posted by asdfasdfjklhj

I have a question pls don't be anngy^^
What's the different from mysql and mssql?

It's just another database
mssql = Microsoft Sql server
mysql = uuhm just mysql I think

They are both Relational databases just like oracle.
but mysql is most used for web 90% (or something like that)off all websites are running php + mysql. But they are both just good database systems

@mage200 There are some little differences in the sql syntax. for example the like operator mssql uses & and mysql uses % if i remeber correctly.

[Xsense]

Update to karaktler database

Change name from
Berserkerbar
Berserkerspeed

To
berserkbar
berserkspeed

[Xsense]

I hope a moderator can clean this topic up.
This is development not a questioning forum on howto create a server.
When its done, its done
And a guide will be posted. And so will the files / database.
So just stay on topic (DEVELOPMENT).

[Xsense]

Update information

SAVED_SKILLS
Contains
Skill1, Skill2 etc etc etc.....
So i dont know how long that thing will be but yeah..

[kevin_owner]

Originally Posted by Xsense

Update information

SAVED_SKILLS
Contains
Skill1, Skill2 etc etc etc.....
So i dont know how long that thing will be but yeah..

pff lyzerk is the worst db coder ever
It's so inefficient to save the skills like that. His previous release with a mysql db had skill1 till skill500
and i saw in the code this:

                ms = new MsSQL("SELECT * FROM saved_skills WHERE owner='" + Karakter.Information.CharacterID + "'");
                using (SqlDataReader reader = ms.Read())
                {
                    while (reader.Read())
                    {
                        Karakter.Stat.Skill.AmountSkill = reader.GetInt32(2);
                        for (int i = 1; i <= Karakter.Stat.Skill.AmountSkill; i++)
                            Karakter.Stat.Skill.Skill[i] = reader.GetInt32(i + 2);

So it's just the amount of skills which determine how many columns there are.

pff It'll be much better to re-code that part it's just such a bad way to save this data

[Xsense]

Originally Posted by kevin_owner

pff lyzerk is the worst db coder ever
It's so inefficient to save the skills like that. His previous release with a mysql db had skill1 till skill500
and i saw in the code this:

                ms = new MsSQL("SELECT * FROM saved_skills WHERE owner='" + Karakter.Information.CharacterID + "'");
                using (SqlDataReader reader = ms.Read())
                {
                    while (reader.Read())
                    {
                        Karakter.Stat.Skill.AmountSkill = reader.GetInt32(2);
                        for (int i = 1; i <= Karakter.Stat.Skill.AmountSkill; i++)
                            Karakter.Stat.Skill.Skill[i] = reader.GetInt32(i + 2);

So it's just the amount of skills which determine how many columns there are.

pff It'll be much better to re-code that part it's just such a bad way to save this data

Yeah i saw that
A better way would be

skill_owner
skill_id
skill_level

.... anyways it is what it is

[Miki Maus]

Xsense, did u get the files working without errors? May i ask for them? just the bin folder + configs no db no anything..

[Xsense]

Originally Posted by Miki Maus

Xsense, did u get the files working without errors? May i ask for them? just the bin folder + configs no db no anything..

I did , no errors .
Withouth db it wont work.
So you need all of it together.
I will upload when i finish the spawn issue, and set the skill data part correctly.

[Miki Maus]

Originally Posted by Xsense

I did , no errors .
Withouth db it wont work.
So you need all of it together.
I will upload when i finish the spawn issue, and set the skill data part correctly.

whats the spawn issue? maybe i can help.

btw i am digging that sql file now:

CREATE TABLE `char_skills` (
`SkillNr` int(11) NOT NULL AUTO_INCREMENT,
`CharID` int(15) NOT NULL,
`OtherName` char(64) DEFAULT NULL,
`SkillID` varchar(25) NOT NULL,
PRIMARY KEY (`SkillNr`,`SkillID`)
) ENGINE=MyISAM AUTO_INCREMENT=415 DEFAULT CHARSET=latin1;

[ensar00]

Originally Posted by Xsense

I did , no errors .
Withouth db it wont work.
So you need all of it together.
I will upload when i finish the spawn issue, and set the skill data part correctly.

this means you will share all fixed source and db? when u complete it

[kevin_owner]

ensar00 how many times does it needs to be said.
All the files + database and all the stuff you need WILL BE RELEASED

and @MikiMaus that sql file isn't for this emu.

[Xsense]

Yes i will share it when its done.

@miki
No that is mysql.
I allready know the issues and how to fix them.
I will also create updates for the server, as the item mall for example only allows some to be bought , and several things that should have been added.

Just wait patiently and all will be released

[Miki Maus]

Originally Posted by Xsense

Yes i will share it when its done.

@miki
No that is mysql.
I allready know the issues and how to fix them.
I will also create updates for the server, as the item mall for example only allows some to be bought , and several things that should have been added.

Just wait patiently and all will be released

**** i know it is mysql lol already converted it to mssql atm, but this is kinda pointless only some structure is almost same as arcane.. i made attempt to rebuild the db b4 but got bored lol..

[Xsense]

Update:

Characters / creation / silk / items / skills / done...
Only thing left is npc's
Then i will release a guide / download for it.