Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Feature Requests

Development::Feature Requests Post suggestions/feature requests here.

Reply
 
Thread Tools Display Modes
  #1  
Old 11-27-2006, 02:39 AM
ChUzZ
Fire Beetle
 
Join Date: Jul 2006
Posts: 23
Default Aug Pool/Bird Bath

Anyone got a working code of adding a bird bath to old bazaar??
Reply With Quote
  #2  
Old 11-28-2006, 01:45 AM
John Adams
Demi-God
 
Join Date: Jul 2006
Posts: 1,552
Default

Search. There are many tips on adding aug forges already posted here.
Reply With Quote
  #3  
Old 12-14-2006, 11:33 AM
Aerewen
Hill Giant
 
Join Date: Dec 2006
Posts: 110
Default

im not 100% sure but i think this was a birdbath... i didnt log in to check it tho but i believe it was the only object i placed in that zone
Code:
INSERT INTO `object` VALUES ([int:id],[int:zone number],[float:x],[float:y],[float:z],[float:heading],0,0,IT10714_ACTORDEF,53,1115,0,0,0,0,0,0,0,0,0,0,0,0);
If not... please post and say it's not one lol and then remove the line from your database to get rid of whatever random object i just made you create :P
Reply With Quote
  #4  
Old 12-15-2006, 07:29 AM
John Adams
Demi-God
 
Join Date: Jul 2006
Posts: 1,552
Default

Quote:
Originally Posted by Aerewen
Code:
INSERT INTO `object` VALUES ([int:id],[int:zone number],[float:x],[float:y],[float:z],[float:heading],0,0,IT10714_ACTORDEF,53,1115,0,0,0,0,0,0,0,0,0,0,0,0);
I think your SQL statement is a little off. What are all those [type:var]'s doing in your VALUES statement? Might be yet another thing I do not know about MySQL
Reply With Quote
  #5  
Old 12-15-2006, 07:36 AM
Aerewen
Hill Giant
 
Join Date: Dec 2006
Posts: 110
Default

ah yeah sorry those brackets are to be replaced with the values you want to use...

[float] means type in the x-position of the object as a floating point 90.52 or whatever

same for y and z

[int:id] is the object's id, i believe entering 0 should auto select a new value using MySQL if that field is set to auto increment

[float:heading] is the rotation for the object, which determines which way it will face.

Easiest way to get this info is, login to the EQEMU server, #zone to the zone u want it in

walk to where you want it to be placed, and type #loc

use those values for x, y, z, and heading
Reply With Quote
  #6  
Old 12-17-2006, 11:05 PM
ChUzZ
Fire Beetle
 
Join Date: Jul 2006
Posts: 23
Default

and for older SQL's?
Reply With Quote
  #7  
Old 07-21-2017, 06:26 PM
Fridgecritter
Hill Giant
 
Join Date: Feb 2008
Posts: 189
Default

Super old post, but I did some searching and couldn't find an updated version of this so here's the code to insert a birdbath in PoK near the soul binder. Just make sure you change the id number to one not being used, or change it to 0 for next number? I just put in the next highest number manually.

Code:
UPDATE `object` SET `id`='228455', `zoneid`='202', `version`='0', `xpos`='-146.24', `ypos`='-190.69', `zpos`='-159.12', `heading`='100', `itemid`='0', `charges`='0', `objectname`='IT10714_ACTORDEF', `type`='53', `icon`='1142', `unknown08`='98', `unknown10`='1152', `unknown20`='0', `unknown24`='2143052781', `unknown60`='0', `unknown64`='0', `unknown68`='0', `unknown72`='0', `unknown76`='-1', `unknown84`='-1', `size`='100', `tilt_x`='0', `tilt_y`='0', `display_name`=NULL WHERE (`id`='228455') LIMIT 1
Reply With Quote
  #8  
Old 07-22-2017, 08:09 PM
Baelu
Sarnak
 
Join Date: Jun 2017
Posts: 30
Default

This raises a question for me....anyone still have the old bazaar zone file or cshome or any of those other 'hidden' zones possibly?
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 02:23 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3