Hurrah Lurker, my zones start again !
|
database update for doors
Lurker_005: don't worry about the destination: zone, x, y, z
I've completed all of that already and the POK and all POKTELE500 doors will port you within millimeters of your destination door. I have not included "dest_heading" as you'll notice it is still "0". Hope it helps out. A new doors.zip file can be accessed directly at: http://my.core.com/~tgarland/doors.zip I know its not as nice looking as yours but it is in the same order anyhow =) Everyone will have to drop their doors table manually unless you care to fix this part I'm more of a Systems/Networking Guru and only an enthusiast of Programming =) Soulfood |
Re: database update for doors
Quote:
Just add the following to the start of your sql file: DROP TABLE IF EXISTS doors; CREATE TABLE doors ( id int(11) NOT NULL auto_increment, doorid smallint(4) NOT NULL default '0', zone varchar(16) NOT NULL default '', name varchar(16) NOT NULL default '', pos_y float NOT NULL default '0', pos_x float NOT NULL default '0', pos_z float NOT NULL default '0', heading float NOT NULL default '0', opentype smallint(4) NOT NULL default '0', guild smallint(4) NOT NULL default '0', lockpick smallint(4) NOT NULL default '0', keyitem int(11) NOT NULL default '0', triggerdoor smallint(4) NOT NULL default '0', triggertype smallint(4) NOT NULL default '0', doorisopen smallint(4) NOT NULL default '0', liftheight int(4) NOT NULL DEFAULT '0', dest_zone varchar(16) default "NONE", dest_x float default 0, dest_y float default 0, dest_z float default 0, dest_heading float default 0, PRIMARY KEY (id) ) TYPE=MyISAM; |
Thanks of gratitude
WOOOT Ya Bud!!!
I've learned more about databases and MySql then I ever really wanted to know I've sourced enough times that the fat lady sang and died LMAO. Major Thanks, Soulfood |
Re: Thanks of gratitude
Quote:
|
Quote:
|
Lurker_005 about doors
Lurker_005,
Heya bud. I know you didnt make the doors teleport that is what I added to them at the following weblink in this post. Been working hard on these doors at the web-url I posted earlier. The destinations are in that zip file. But there are 2 things that must be fixed and I can only get one of them. 1) All the POK[zone_abbreviation]PORT500 and POKTELE500 type's must be set with open_type=58 not 57 or places like "The Nexus" you will not be able to left click, right click or walk onto to zone. Using open_type=58 makes these doors left click to port to dest_zone, dest_x, dest_y, dest_z, dest_heading. 2) No matter what I do with FreportW I cannot get the POKTELE500_DMSPRITEDEF to present itself as POKTELE500 as I can in the other zones that I've have tested. Side_note: You must have destination (zone) bare minimum to use database safe_coords or my preference of dest_zone, dest_x, dest_y, dest_z which I have already set so your standing to any given side of the POK[*]500 doortype, depending on which side the dest_x had an added +5.0 in order not to zone ontop of the destination objects[doors]. Download the zip file and take a look I'm going to put what I have so far up there as of right now =) hope you have better luck than me. http://my.core.com/~tgarland/doors.zip Thanks for all the work you've been putting into this project it makes it well worth it =) Soulfood. |
In case its of help Lurker_005
I've taken the zone.exe that was running during entry into the Freeport West zone and the world.exe logs from their respective dos windows hope posting will shed some light.
[Status] CURRENT_ZONE_VERSION: EQEMu 0.4.4-DR1 [Error] CURRENT_ZONE_VERSION: EQEMu 0.4.4-DR1 [Status] Loading Variables [Status] Loading zone names [Status] Loading items EMuShareMem.dll loaded. [Status] Loading npcs [Status] Loading npc faction lists [Status] Loading loot tables [Status] Loading doors [Status] FileLoadSPDat() Loading spells from spells_en.txt [Status] FileLoadSPDat() spells loaded: 3568 [Status] Loading guilds [Status] Loading factions [Status] Loading corpse timers [Status] Loading what ever is left [Status] Entering sleep mode Connected to worldserver: localhost:9000 Init: Loading zone lists, zone state or spawn list, player corpsesZonepoints loa ded into memory , timezone data - Done. ZoneID = 202; Time Offset = 0 Couldn't find/read ./cfg/poknowledge.cfg. (returning -1) Couldn't find/read ./cfg/poknowledge.cfg. (returning -1) Corrupt (or nonexistant) zhdr file ./cfg/poknowledge.cfg -- fread count = -1 (sh ould be 170) Using default zone header data... [Status] Loading Objects from DB... Loading zones doors...done. Petition 0 pettime = 0 ----------- Zone server 'poknowledge' listening on port:8000 ----------- [Status] Zone Bootup: poknowledge (202) Default weather type for zone is 1 Weather changes in 2884 seconds. (weather is now 1) [Error] Script error 113343 Parser::LoadScript() Error, runaway quote Received Message SyncWorldTime Time Broadcast Packet: EQTime [10:27 am] [Status] 253404 New client from ip:127.0.0.1 port:1682 Loaded playerprofile for Pantora - size: 8460/8460 Loaded alt_adv_table for Pantora - size: 258/258 Setting stats for BL Pet for Race: 130 Summoning BeastLord Pet: + Setting stats for BL Pet for Race: 10 Summoning BeastLord Pet: + Setting stats for BL Pet for Race: 130 Summoning BeastLord Pet: + Setting stats for BL Pet for Race: 2 Summoning BeastLord Pet: + Pantora casting #261, slot=6, invslot=65535 Unknown SpawnAppearance type: 0x0013 value: 0x00000002 above two lines are from the spell_list slot #6 with spell being "Levitate" if that makes a difference during your scan of this data Setting stats for BL Pet for Race: 130 Summoning BeastLord Pet: + Setting stats for BL Pet for Race: 2 Summoning BeastLord Pet: + Setting stats for BL Pet for Race: 130 Summoning BeastLord Pet: + 0: B3 01 00 00 00 00 50 00 - 00 00 00 00 01 00 00 00 | ......P......... 16: E7 03 00 00 | .... 0: B3 01 00 00 00 00 FF FF - 00 00 00 00 01 00 00 00 | ................ 16: 01 00 00 00 | .... 0: B3 01 00 00 00 00 05 01 - 00 00 00 00 00 00 00 00 | ................ 16: E7 03 00 00 | .... 0: B3 01 00 00 00 00 FF FF - 00 00 00 00 00 00 00 00 | ................ 16: 01 00 00 00 | .... Zone request for:Pantora to: freportw(9) Player at x:-234 y:-448 z:-151.6 Zoning to specified cords: freportw (9), x=77, y=-682, z=-34.8048 Zoning player to:freportw (9) x:77 y:-682 z:-34.8048 Setting stats for BL Pet for Race: 130 Summoning BeastLord Pet: + Player attempting to delete spawn: Pantora Flushing Queue! Queue Flushed! Client disconnected (cs=d): Pantora Dropping client: Process=false, ip=127.0.0.1, port=1682 Automatic shutdown [Status] Zone Shutdown: poknowledge (202) Zone shutdown: going to sleep [Status] CURRENT_WORLD_VERSION:EQEMu 0.4.4-DR1 [Error] CURRENT_WORLD_VERSION:EQEMu 0.4.4-DR1 Loading Variables, zone names & items... EMuShareMem.dll loaded. Loading items from database... ...done. LoginServer.ini read. Loading guild ranks...done. Loading EQ time of day..."./eqtime.cfg" is NOT a vaild EQTime file. File version is 0; EQTime version is 1000 - failed. Deleted 0 stale player corpses from database. Deleted -1 stale player backups from database. Formatting drive C: TCP listening on: localhost:9000 World server listening on: localhost:9000 Connected to LoginServer: localhost:5999 12839 New TCP connection: 127.0.0.1:1668 12849 New TCP connection: 127.0.0.1:1669 12849 New TCP connection: 127.0.0.1:1670 12849 New TCP connection: 127.0.0.1:1671 12849 New TCP connection: 127.0.0.1:1672 New zoneserver: #1 127.0.0.1:1668 12859 New TCP connection: 127.0.0.1:1673 New zoneserver: #2 127.0.0.1:1673 New zoneserver: #3 127.0.0.1:1672 New zoneserver: #4 127.0.0.1:1671 New zoneserver: #5 127.0.0.1:1670 New zoneserver: #6 127.0.0.1:1669 Zoneserver SetConnectInfo: 127.0.0.1:1668: localhost:8000 Zoneserver SetConnectInfo: 127.0.0.1:1669: localhost:7997 Zoneserver SetConnectInfo: 127.0.0.1:1670: localhost:7996 Zoneserver SetConnectInfo: 127.0.0.1:1671: localhost:7999 Zoneserver SetConnectInfo: 127.0.0.1:1672: localhost:7995 Zoneserver SetConnectInfo: 127.0.0.1:1673: localhost:7998 69971 New client from ip: 127.0.0.1 port: 1676 Logged in: Local: eqemu Sending list of guilds Unknown opcode: 0x3541 size:2056 Unknown opcode: 0x3941 size:2056 Error: InflatePacket: inflate() returned -3 'unknown compression method' Packet contents:Pantora Attempting autobootup of necropolis (123) for Pantora Zoneserver SetZone: localhost:7999 necropolis (123) Enter world: Pantora: necropolis (123) Broadcasting a world time update Zoneserver SetZone: localhost:7999 necropolis (123) Client disconnected Removing client from ip:127.0.0.1 port:1676 Zoneserver SetZone: localhost:8000 poknowledge (202) Broadcasting a world time update 265182 New client from ip: 127.0.0.1 port: 1680 Logged in: Local: eqemu Unknown opcode: 0x3541 size:2056 Unknown opcode: 0x3941 size:2056 Error: InflatePacket: inflate() returned -3 'unknown compression method' Packet contents:Pantora Enter world: Pantora: poknowledge (202) Zoneserver SetZone: localhost:8000 poknowledge (202) Zoneserver SetZone: localhost:7999 (0) Zoneserver SetZone: localhost:7999 (0) Client disconnected Removing client from ip:127.0.0.1 port:1680 Zoneserver SetZone: localhost:7998 freportw (9) Broadcasting a world time update Zoneserver SetZone: localhost:8000 (0) 362311 New client from ip: 127.0.0.1 port: 1684 Logged in: Local: eqemu Zoneserver SetZone: localhost:8000 (0) Unknown opcode: 0x3541 size:2056 Unknown opcode: 0x3941 size:2056 Error: InflatePacket: inflate() returned -3 'unknown compression method' Packet contents:Pantora Enter world: Pantora: freportw (9) Zoneserver SetZone: localhost:7998 freportw (9) Client disconnected Removing client from ip:127.0.0.1 port:1684 475784 New client from ip: 127.0.0.1 port: 1688 Logged in: Local: eqemu Sending list of guilds Zoneserver SetZone: localhost:7998 (0) Zoneserver SetZone: localhost:7998 (0) Unknown opcode: 0x3541 size:2056 Unknown opcode: 0x3941 size:2056 Client disconnected Removing client from ip:127.0.0.1 port:1688 127.0.0.1:1672: TCPConnection::RecvData(): Error: 10054 Removing zoneserver from ip:0.0.0.0 port:0 (localhost:7995) 127.0.0.1:1670: TCPConnection::RecvData(): Error: 10054 Removing zoneserver from ip:0.0.0.0 port:0 (localhost:7996) 127.0.0.1:1669: TCPConnection::RecvData(): Error: 10054 Removing zoneserver from ip:0.0.0.0 port:0 (localhost:7997) 127.0.0.1:1673: TCPConnection::RecvData(): Error: 10054 Removing zoneserver from ip:0.0.0.0 port:0 (localhost:7998) 127.0.0.1:1671: TCPConnection::RecvData(): Error: 10054 Removing zoneserver from ip:0.0.0.0 port:0 (localhost:7999) I'm currently up to date with the CVS as it stands at SourceForge.net I may have to downstep the branch I'm not certain if that is the issue with Freeport West's Portal/Door either. Sorry for the long input thought it would be better to put it in down to closing zones.exe out =) Soulfood |
Need Help
Ok this is my db im using with the code that luker put in for the doors and it works fine but when i used the second code the doors were all moved 90 degrees can someone help me. Ok here is the db with moving mobs and krushers items db beta 5 with pok 85% done. Ok when i try to upload my db i get this error so i cant show you
|
database
jdankanyin,
Re-download my doors database I have at my weblink http://my.core.com/~tgarland/doors.zip Then open mysql and resource this doors.sql file. If your still having a problem please make certain that you have a fresh download since I just uploaded it as of this post and that you have verify at the top of the file doors.sql it will say the following# MySQL-Front Dump 2.5 # # -------------------------------------------------------- # Server version 4.0.13-nt If it does not say this you have the wrong load of my doors.sql zip-file. If you are running MySql version lower than 4.0.13 and there is an incompatability issue leave a post I check this forum frequently and will work on making just the commands to update the database without changing it. ALWAYS MAKE A BACKUP OF YOUR DATABASE BEFORE "SOURCING" NEW FILES INTO IT. Thanks Soulfood |
doors ?
:o Hey i already got it but i was saying that the first part worked great but when i added yours it made all my doors be 90 degrees off that was it . Also this is where my servers and desk are for my computers.
|
doors 90degrees off
jdankanyin,
Sorry about them being off by 90degrees I do not have the know how to fix it. You can use Lurker_005's door_db or hope someone here can help out fixing it. I wish I knew why. Still in Freeport West the portal to POK does not show up on my system, just an FYI kinda thing if its the same for you I am unsure since my doors are not at a 90degree change. Hoping Lurker_005 see's this one =) Soulfood. |
soulfood I was tired last night and didn't notice that I skiped some posts. I didn't see your doors.zip till today :p
Good news is I was tired from working with doors. Mostly what you had done in your doors file :p Anyhow some of the changes you made I think were causing problems. Specifically changing the doorid field. That has to be unique for each door in the zone. This may be why you had problems with the freport book. As for the doors being 90 deg???? The rest of the files data is identical to mine. I can only guess it has to do with a different CVS version. Anyhow, I'll post another copy of the doors this weekend with more stuff working. Regarding that, I know there was a request for the Tower of frozen shadow. Someone want to get a list of locs from, and too, also the key item# or at least name. If someone wants to make the changes and post them that would be great. I would prefer they be in an update format with comments for each section or zone. here is a line from one I have done. Code:
UPDATE doors SET dest_zone="Tox" ,dest_y=-2344.14 ,dest_x=295.884 ,dest_z=-47 ,dest_heading=371.01 WHERE zone LIKE "PoKnowledge" AND name LIKE "POKPPORT500"; |
EEGAADS I hate doors LMAO
Lurker_005,
Sorry about changing the unique door id's I was so tired of Freeport West I was trying alot of things with that zone and forgot to reset the unique door id's I was playing with. Thanks for catching it. I'll take your doors.zip and add the id's to my database until this weekend. If I can be of any assistance with this database don't hesitate to point me in a direction or two. I'd love the opportunity. =) Keepin it real Soulfood |
Well I worked on the doors some more, give these a try.
http://lurker.eqemu.net/DBFiles/doors-06142003.zip It has Plane of Knowledge books (to and from) some plane of tranquility ones, a first go at tower of frozen shadow, and 2 non working elevators :( Let me know what you find. I probably won't be working on this any more today, but perhaps sunday... |
| All times are GMT -4. The time now is 09:05 AM. |
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.