Aug Pool/Bird Bath

ChUzZ · #1 11-27-2006, 02:39 AM

Anyone got a working code of adding a bird bath to old bazaar??

John Adams · #2 11-28-2006, 01:45 AM

Search. There are many tips on adding aug forges already posted here.

Aerewen · #3 12-14-2006, 11:33 AM

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

John Adams · #4 12-15-2006, 07:29 AM

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

Aerewen · #5 12-15-2006, 07:36 AM

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

ChUzZ · #6 12-17-2006, 11:05 PM

and for older SQL's?

Fridgecritter · #7 07-21-2017, 06:26 PM

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

Baelu · #8 07-22-2017, 08:09 PM

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