[C#]The Arcane Development Thread

Page 14 of 17 « First 41213 14 1516 Last »
10/27/2010 15:16 kevin_owner#196
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
10/27/2010 15:20 kevin_owner#197
Quote:
Originally Posted by asdfasdfjklhj View Post
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.
10/27/2010 15:24 Xsense#198
Update to karaktler database

Change name from
Berserkerbar
Berserkerspeed

To
berserkbar
berserkspeed
10/27/2010 15:29 Xsense#199
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).
10/27/2010 15:43 Xsense#200
Update information

SAVED_SKILLS
Contains
Skill1, Skill2 etc etc etc.....
So i dont know how long that thing will be but yeah..
10/27/2010 15:51 kevin_owner#201
Quote:
Originally Posted by Xsense View Post
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:D
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:
Code:
                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
10/27/2010 15:59 Xsense#202
Quote:
Originally Posted by kevin_owner View Post
pff lyzerk is the worst db coder ever:D
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:
Code:
                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 :)
10/27/2010 16:28 Miki Maus#203
Xsense, did u get the files working without errors? May i ask for them? just the bin folder + configs no db no anything..
10/27/2010 16:29 Xsense#204
Quote:
Originally Posted by Miki Maus View Post
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.
10/27/2010 16:32 Miki Maus#205
Quote:
Originally Posted by Xsense View Post
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:
Quote:
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;
10/27/2010 16:33 ensar00#206
Quote:
Originally Posted by Xsense View Post
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
10/27/2010 16:37 kevin_owner#207
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.
10/27/2010 16:38 Xsense#208
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
10/27/2010 16:40 Miki Maus#209
Quote:
Originally Posted by Xsense View Post
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
damn 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..
10/27/2010 16:59 Xsense#210
Update:

Characters / creation / silk / items / skills / done...
Only thing left is npc's
Then i will release a guide / download for it.
Page 14 of 17 « First 41213 14 1516 Last »