[ArcEMU][WhyDB] Daily Server Updates [09-08-08][12:48AM]

Bumpzorz! I really need help!

Edit: It happened again now, but this time on Rev702! This is ridiculous! It worked for some time after i deleted the databases and started over again... And now, it suddenly starts crashing again! I restarted the server because I wasn't able to create any characters, I immediately got disconnected when I created one. This sucks monkeyballs, I'm thinking of dropping this stupid ArcEMU that doesn't seem to work AT ALL and try something else...

Edit2: Found the problem! It's WhyDB205! 204 = creature_spawns doesn't work, 205 = access violation...this sucks so hard.

Edit3: THIS IS SO FUCKED UP!! Tried 204 now = access violation, WHAT am I doing wrong?! Ultra-sigh.

i just d/l Rev692 and i have extracted the 2.4.3 dbc files and put it into the core but when i run arcemu-world it says they are wrong format..am i doing something wrong?

Does anyone else have problems with Channeling spells ? is this a DB problem or Core?

Okey does more people have this problem?
I would like to fix this ;)

Quote:

---

Originally Posted by _SWE_

Bumpzorz! I really need help!

Edit: It happened again now, but this time on Rev702! This is ridiculous! It worked for some time after i deleted the databases and started over again... And now, it suddenly starts crashing again! I restarted the server because I wasn't able to create any characters, I immediately got disconnected when I created one. This sucks monkeyballs, I'm thinking of dropping this stupid ArcEMU that doesn't seem to work AT ALL and try something else...

Edit2: Found the problem! It's WhyDB205! 204 = creature_spawns doesn't work, 205 = access violation...this sucks so hard.

Edit3: THIS IS SO FUCKED UP!! Tried 204 now = access violation, WHAT am I doing wrong?! Ultra-sigh.

---

The only thing you could did wrong is that you used old dbc files.
Shouldnt what could be it else.

Quote:

---

Originally Posted by Bloodshed2007

i just d/l Rev692 and i have extracted the 2.4.3 dbc files and put it into the core but when i run arcemu-world it says they are wrong format..am i doing something wrong?

---

New SVN : svn://arcemu.info/svn/arcemu

Thanks for sharing

Quote:

---

Originally Posted by minhocoke

New SVN : svn://arcemu.info/svn/arcemu

---

I am using the latest DB and Core now and problem solved :)

when loading you get error world.instance_bosse does not exist

is it very important ??
and is here sunfury ( sunwell dont know hows it called)
and does illidan entrance is not bugged ??

how iam able to get item ids ??????

Sunwell is there, and illidan is not bugged anymore.

Quote:

---

Originally Posted by darksideris

when loading you get error world.instance_bosse does not exist

is it very important ??
and is here sunfury ( sunwell dont know hows it called)
and does illidan entrance is not bugged ??

---

Forgot to update the map SQL so i just put the script here
Make a notepad with this text:

Code:

---

DELETE FROM `instances`;
CREATE TABLE `instanceids` (
  `playerguid` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  `mapid` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  `mode` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  `instanceid` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY  (`playerguid`,`mapid`,`mode`),
  KEY `ix_instanceid` (`playerguid`)
) ENGINE=MyISAM /*!40100 DEFAULT CHARSET=latin1 COMMENT='Player / InstanceID - Reference Table'*/;
ALTER TABLE `instances` ADD COLUMN `persistent` TINYINT NOT NULL DEFAULT '0';
ALTER TABLE `groups` ADD COLUMN `instanceids` TEXT NOT NULL;

---

Save it as .sql and execute it in your character DB this wont give errors

Can you compile the sun++ script bin too plz

Okey i will give it a try last attements failed.

Quote:

---

Originally Posted by minhocoke

Can you compile the sun++ script bin too plz

---

Ok I have a problem
I'm Using WhyDB and when I try to add a NPC from .sql file in world db I'm getting this error:

Code:

---

[Err] 1062 - Duplicate entry '822334' for key 1
[Err] INSERT INTO `creature_names` VALUES ('822334', 'Teleporter NPC', '', '0', '0', '7', '0', '0', '0', '0', '17544', '0', '0', '0', '1', '1', '1', '0');
[Msg] Finished - Unsuccessfully
--------------------------------------------------

---

Can sombody tell me what I'm doing wrong?
Thx.
Sorry from being soo noob :|
Sorry for my bad eng

Your code is out of date for this DB.

Quote:

---

Originally Posted by vxvexa

Ok I have a problem
I'm Using WhyDB and when I try to add a NPC from .sql file in world db I'm getting this error:

Code:

---

[Err] 1062 - Duplicate entry '822334' for key 1
[Err] INSERT INTO `creature_names` VALUES ('822334', 'Teleporter NPC', '', '0', '0', '7', '0', '0', '0', '0', '17544', '0', '0', '0', '1', '1', '1', '0');
[Msg] Finished - Unsuccessfully
--------------------------------------------------

---

Can sombody tell me what I'm doing wrong?
Thx.
Sorry from being soo noob :|
Sorry for my bad eng

---

Can someone give me a character DB for the WhyDB 205 ? Thanks.

Quote:

---

Originally Posted by ovidel

Can someone give me a character DB for the WhyDB 205 ? Thanks.

---

try these..

whats this sun++?

It's like Moon++ scripts. It gives some scripted bosses etc to your server.

Quote:

---

Originally Posted by Bloodshed2007

whats this sun++?

---

oh ok...

having trouble with latest core...the logonserver.exe keeps shutting down...

Execute this to your World DB

Code:

---

DELETE FROM `instances`;
CREATE TABLE `instanceids` (
  `playerguid` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  `mapid` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  `mode` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  `instanceid` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY  (`playerguid`,`mapid`,`mode`),
  KEY `ix_instanceid` (`playerguid`)
) ENGINE=MyISAM /*!40100 DEFAULT CHARSET=latin1 COMMENT='Player / InstanceID - Reference Table'*/;
ALTER TABLE `instances` ADD COLUMN `persistent` TINYINT NOT NULL DEFAULT '0';
ALTER TABLE `groups` ADD COLUMN `instanceids` TEXT NOT NULL;

---

Quote:

---

Originally Posted by Bloodshed2007

oh ok...

having trouble with latest core...the logonserver.exe keeps shutting down...

---

Quote:

---

Originally Posted by Astrup

Execute this to your World DB

Code:

---

DELETE FROM `instances`;
CREATE TABLE `instanceids` (
  `playerguid` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  `mapid` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  `mode` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  `instanceid` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY  (`playerguid`,`mapid`,`mode`),
  KEY `ix_instanceid` (`playerguid`)
) ENGINE=MyISAM /*!40100 DEFAULT CHARSET=latin1 COMMENT='Player / InstanceID - Reference Table'*/;
ALTER TABLE `instances` ADD COLUMN `persistent` TINYINT NOT NULL DEFAULT '0';
ALTER TABLE `groups` ADD COLUMN `instanceids` TEXT NOT NULL;

---

---

errm... Mistake?? It's CHAR db :P

In the future releases can you please compile SunLUAScripting.dll aswell?

Yup then i think he just did something wrong because it works fine for me.

Quote:

---

Originally Posted by deejdd

errm... Mistake?? It's CHAR db :P

---