Chrispee `s Repack of Back :D :D

[dancol]

the teleporter still doenst work for me. i can startup the server, but only without teleporter.dll file!!! plz help mE!!

[Chrispee]

it should work just fine do some of you are getting this error

[atradies35]

Love your repack it is the first new one that i have had great sucess with. Thanks for your hard work on it. I have a problem with in game mail here is the sql error i get.

Sql query failed due to [Column count doesn't match value count at row 1], Quer
: [REPLACE INTO mailbox VALUES(1,0,14,14,"test mail","today test",1,'',0,41,977
42771,975050771,0,0,0)]

I also had a problem with the graveyards table. When you died in game it sent you to another area. I found a fix for it but dont remember who i got it from. Just run this script i found below as a query in navicat.

UPDATE graveyards SET ZoneId = 1

Now when you die you go to the nearest graveyard. I also had a problem with characters loosing their quests when they log out of the server. The sql fix for this is below. All you have to do is run it in navicat as well.

DROP TABLE IF EXISTS `questlog`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `questlog` (
`player_guid` bigint(20) unsigned NOT NULL DEFAULT '0',
`quest_id` bigint(20) unsigned NOT NULL DEFAULT '0',
`slot` int(20) unsigned NOT NULL DEFAULT '0',
`time_left` bigint(20) NOT NULL DEFAULT '0',
`explored_area1` bigint(20) unsigned NOT NULL DEFAULT '0',
`explored_area2` bigint(20) unsigned NOT NULL DEFAULT '0',
`explored_area3` bigint(20) unsigned NOT NULL DEFAULT '0',
`explored_area4` bigint(20) unsigned NOT NULL DEFAULT '0',
`mob_kill1` bigint(20) NOT NULL DEFAULT '0',
`mob_kill2` bigint(20) NOT NULL DEFAULT '0',
`mob_kill3` bigint(20) NOT NULL DEFAULT '0',
`mob_kill4` bigint(20) NOT NULL DEFAULT '0',
PRIMARY KEY (`player_guid`,`quest_id`)
) ENGINE=MyISAM AUTO_INCREMENT=33067588 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `questlog`
--

LOCK TABLES `questlog` WRITE;
/*!40000 ALTER TABLE `questlog` DISABLE KEYS */;
/*!40000 ALTER TABLE `questlog` ENABLE KEYS */;
UNLOCK TABLES;

This by far is one of the best repacks i have tried yet. Thanks alot and keep up the good work.

[atradies35]

I was further messing around with the mailbox tables in navicat and did a sql dump of mailbox table and mailbox_insert_queue. I then deleted both tables and then readded the mailbox table only and tested it. Works just fine without the mailbox_insert_queue. I have been trying to fix this for the last two weeks. Hope this helps anyone else that may have the same issue. Thanks again for the repack.

[xaverz]

Enchants working?? recipes?

[Chrispee]

check out my new repack mate its a bit old now

[atradies35]

I do have the new repack sorry i posted this in the worng section. Just hope i was helpfull. Thanks.

[atradies35]

xaverz

Enchants working?? recipes?

Yes they are working just fine. I do have the server live and online as well just need to figure out how to get registration pages and all working.