|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Development::Feature Requests Post suggestions/feature requests here. |
11-27-2006, 02:39 AM
|
Fire Beetle
|
|
Join Date: Jul 2006
Posts: 23
|
|
Aug Pool/Bird Bath
Anyone got a working code of adding a bird bath to old bazaar??
|
11-28-2006, 01:45 AM
|
Demi-God
|
|
Join Date: Jul 2006
Posts: 1,552
|
|
Search. There are many tips on adding aug forges already posted here.
|
12-14-2006, 11:33 AM
|
Hill Giant
|
|
Join Date: Dec 2006
Posts: 110
|
|
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
|
12-15-2006, 07:29 AM
|
Demi-God
|
|
Join Date: Jul 2006
Posts: 1,552
|
|
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
|
12-15-2006, 07:36 AM
|
Hill Giant
|
|
Join Date: Dec 2006
Posts: 110
|
|
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
|
12-17-2006, 11:05 PM
|
Fire Beetle
|
|
Join Date: Jul 2006
Posts: 23
|
|
and for older SQL's?
|
07-21-2017, 06:26 PM
|
Hill Giant
|
|
Join Date: Feb 2008
Posts: 189
|
|
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
|
07-22-2017, 08:09 PM
|
Sarnak
|
|
Join Date: Jun 2017
Posts: 30
|
|
This raises a question for me....anyone still have the old bazaar zone file or cshome or any of those other 'hidden' zones possibly?
|
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 11:23 PM.
|
|
|
|
|
|
|
|
|
|
|
|
|