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

07-14-2006, 07:10 AM
|
AX Classic Developer
|
|
Join Date: May 2006
Location: filler
Posts: 2,049
|
|
You can also dump spawns, and grids;
spawn2, spawnentry, spawngroup, grid, grid_entries. This is how I started with my LoY Zones.
If you do, could you PM me these separatly? I already sourced what you had posted.
|

07-14-2006, 07:53 AM
|
Hill Giant
|
|
Join Date: Mar 2005
Posts: 165
|
|
that would be very helpful for all the zones that people pull from Cavedudes Db to merge with peq put them all together on one dl sight.
I have already merge cavedudes DB to Peq (which was tedious to do all at once would have been easier the way Angelox told me to do it hehe). And now i am going zone by zone adding missing spawns and fixng spawns that are untargetable adding loot tables and faction.
|

07-14-2006, 08:10 AM
|
Fire Beetle
|
|
Join Date: Jul 2006
Posts: 13
|
|
Sounds like tallerin is ahead of both of us... any way we can coordinate and or work together? This way were not all doing the same thing.
|

07-15-2006, 10:09 AM
|
AX Classic Developer
|
|
Join Date: May 2006
Location: filler
Posts: 2,049
|
|
Quote:
Originally Posted by SCROFT
Sounds like tallerin is ahead of both of us... any way we can coordinate and or work together? This way were not all doing the same thing.
|
My website belongs to me and is always on - if anyone is interested, we can arrange something for posting sql work, I'm a terrible web artist, If anyone can do better, I'll let them do the posting too.
|

07-15-2006, 12:03 PM
|
Hill Giant
|
|
Join Date: Jun 2006
Posts: 117
|
|
Same, i have my own website but im not a web designer by a long shot. I would be happy to post my work elsewhere. I can make a basic page with links to all the stuff.
You can usually find me on irc or in game.
|

07-15-2006, 08:45 PM
|
Sarnak
|
|
Join Date: May 2005
Posts: 58
|
|
Perhaps Ive been up too long and it's going in one ear and out the other , but how exactly do you take the NPC info of one zone and turn it into a SQL file that someone else can source into thier database ? And how could you do that with NPC loot tables if two people are using the same version database , just giving them a SQL file to be able to update the loot tables of npc's in a particular zone ? I've been trying to come up with a SQL file that can just be sourced into an existing database that updates loot tables that Ive done. I've been working on getting loot tables of zones to be as close to live as I can , but just don't know enough about SQL to get it to work I guess. Thanks in advance for any help !!! It's very much appreciated !
|
 |
|
 |

07-16-2006, 02:08 AM
|
AX Classic Developer
|
|
Join Date: May 2006
Location: filler
Posts: 2,049
|
|
Quote:
Originally Posted by EliteSting
Perhaps Ive been up too long and it's going in one ear and out the other , but how exactly do you take the NPC info of one zone and turn it into a SQL file that someone else can source into thier database ? And how could you do that with NPC loot tables if two people are using the same version database , just giving them a SQL file to be able to update the loot tables of npc's in a particular zone ? I've been trying to come up with a SQL file that can just be sourced into an existing database that updates loot tables that Ive done. I've been working on getting loot tables of zones to be as close to live as I can , but just don't know enough about SQL to get it to work I guess. Thanks in advance for any help !!! It's very much appreciated !
|
All of this can be done, you just have to navigate these forums better. To me, loot tables are the toughest, but Sesmar also posted a solution to that in this same thread. I think we are all staying cose to live as can be , without packet collectors.
What you need to keep in mind is how to keep your work easy to access. On my last Dulak dump, I easily picked off my loot-table work, since I tagged them all with the zone-id.
|
 |
|
 |

07-15-2006, 10:06 AM
|
AX Classic Developer
|
|
Join Date: May 2006
Location: filler
Posts: 2,049
|
|
Quote:
Originally Posted by tallerin
that would be very helpful for all the zones that people pull from Cavedudes Db to merge with peq put them all together on one dl sight.
I have already merge cavedudes DB to Peq (which was tedious to do all at once would have been easier the way Angelox told me to do it hehe). And now i am going zone by zone adding missing spawns and fixng spawns that are untargetable adding loot tables and faction.
|
I didn't realize this tell later also, I have a pile of work already done, that I need to fix - at least we are getting somewhere, by sharing our stuff now - I'm trying to make my zones more "complete" before I post them, But I get stuck a lot on things I don't know how to do, and, am learning.
|

07-14-2006, 08:27 AM
|
Hill Giant
|
|
Join Date: Jun 2006
Posts: 117
|
|
in the version you DL'd
npc_types
Spawn2
Spawngroup
Merchantlist
doors
Added:
SpawnEntries
grid
gridentries
SQL pack is updated with the missing data, and i created a FIX for the stuff that anyone DL' d prior to this fix here
Thanks for the heads up man, i forgot to add one of my notepads together...hehe
|

07-14-2006, 11:07 AM
|
AX Classic Developer
|
|
Join Date: May 2006
Location: filler
Posts: 2,049
|
|
Quote:
Originally Posted by Thristam
in the version you DL'd
npc_types
Spawn2
Spawngroup
Merchantlist
doors
Added:
SpawnEntries
grid
gridentries
SQL pack is updated with the missing data, and i created a FIX for the stuff that anyone DL' d prior to this fix here
Thanks for the heads up man, i forgot to add one of my notepads together...hehe
|
All working now, thanks - I never really looked at how much was done by Cavedude in PoK. I noticed the portal to Gulf of Gunthark is not there, but this is probably because it was a recent addition. also, how would i go about getting the return-books to work?
|
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 06:29 PM.
|
|
 |
|
 |
|
|
|
 |
|
 |
|
 |