|
|
|
 |
 |
 |
 |
|
 |
 |
|
 |
 |
|
 |
|
| Development::Database/World Building World Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc. |

07-21-2006, 02:07 AM
|
|
Hill Giant
|
|
Join Date: Jun 2006
Posts: 117
|
|
Found a POK book missing for Misty Ticket. Here is the insert for it.
Code:
INSERT INTO doors VALUES (9765,77,'misty','POKTELE500',-528.88,-1268.26,11.00,504.00,58,0,0,0,0,0,0,0,'poknowledge',-73.00,-419.000,-157.70,255.00,0,0,100);
|

07-27-2006, 11:29 AM
|
|
Forum Guide
|
|
Join Date: Jul 2005
Posts: 473
|
|
Does anyone have the book from Tranquility to Knowledge?
|

07-30-2006, 01:50 AM
|
|
Demi-God
|
|
Join Date: Jan 2005
Posts: 1,109
|
|
Quote:
|
Originally Posted by hayward6
Does anyone have the book from Tranquility to Knowledge?
|
Code:
INSERT INTO `doors` VALUES (10766, 62, 'poknowledge', 'POKPTPORT500', -147.699, -332.22, -155.998, 0, 58, 0, 0, 0, 0, 0, 0, 11, 'potranquility', -1463, 774, -877, 131, 0, 0, 100);
INSERT INTO `doors` VALUES (9209, 1, 'potranquility', 'POKTELE500', 774.53, -1439.2, -876.76, 384, 58, 0, 0, 0, 0, 0, 0, 0, 'poknowledge', -296.43, -147.05, -157.25, 384, 0, 0, 100);
__________________
__________________________________________________ _____________________________________
I speak english like a spanish cow..., I speak spanish like a english pudding...
But I try to speak good french !!! (Non au langage SMS sur forum)
http://eqfroggy.new.fr : Froggy French Server Website.
|

07-30-2006, 06:41 AM
|
|
Forum Guide
|
|
Join Date: Jul 2005
Posts: 473
|
|
Quote:
|
Originally Posted by Belfedia
Code:
INSERT INTO `doors` VALUES (10766, 62, 'poknowledge', 'POKPTPORT500', -147.699, -332.22, -155.998, 0, 58, 0, 0, 0, 0, 0, 0, 11, 'potranquility', -1463, 774, -877, 131, 0, 0, 100);
INSERT INTO `doors` VALUES (9209, 1, 'potranquility', 'POKTELE500', 774.53, -1439.2, -876.76, 384, 58, 0, 0, 0, 0, 0, 0, 0, 'poknowledge', -296.43, -147.05, -157.25, 384, 0, 0, 100);
|
Thats strange... I get duplicate entry errors. I better go make sure I didn't just miss the book, or do I need to somehow remove the entries I have?
|

07-30-2006, 06:50 AM
|
|
Discordant
|
|
Join Date: May 2006
Posts: 356
|
|
Quote:
|
Originally Posted by hayward6
Thats strange... I get duplicate entry errors. I better go make sure I didn't just miss the book, or do I need to somehow remove the entries I have?
|
The POK to Tranquility SHOULD be there if you have pok mobs installed. The other one from Tranquility to POK, at least in my case, is using a duplicate ID number 9209. You will have to put it in manually with a new id.
|

07-30-2006, 10:05 PM
|
|
Demi-God
|
|
Join Date: Jan 2005
Posts: 1,109
|
|
My sql command allow
Teleport Pok to tranquility (first line)
Teleport Tranquility to pok (Second line)
If this tp already exist, you must delete them before use my commands...
or use REPLACE in place of INSERT.
__________________
__________________________________________________ _____________________________________
I speak english like a spanish cow..., I speak spanish like a english pudding...
But I try to speak good french !!! (Non au langage SMS sur forum)
http://eqfroggy.new.fr : Froggy French Server Website.
|

08-12-2006, 06:45 AM
|
|
Discordant
|
|
Join Date: May 2006
Posts: 458
|
|
Thanks a bunch, Thristam. 
|
| Thread Tools |
|
|
| Display Modes |
Hybrid Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 02:40 AM.
|
|
 |
|
 |
|
|
|
 |
|
 |
|
 |