No pets?

Serryon123 · #1 03-14-2012, 04:29 PM

I had a question wondering if anyone had a fix, i have a fresh db and sourced everything in specifically the pets table, yet whenever I try to summon ANY kind of pet, theres no data found for them. Any ideas? Ive checked the spells specifically and the db and have actually summoned the npc ID the pet is supposed to be but the spells wont summon them. Thanks!

lerxst2112 · #2 03-14-2012, 07:34 PM

Did you source all of the required updates in trunk\EQEmuServer\utils\sql\svn?

Serryon123 · #3 03-14-2012, 07:51 PM

I believe so. I can try and just re source everything, but is there a faster then doing "source C:\blah\blah\blah\blah\blah\x.sql" for EVERY thing in there?

**Akkadius** · #4 03-14-2012, 08:02 PM

Quote:

Originally Posted by Serryon123

I believe so. I can try and just re source everything, but is there a faster then doing "source C:\blah\blah\blah\blah\blah\x.sql" for EVERY thing in there?

The update has the revision number appended to the .sql script, you'll need to source everything from the last revision you believe you were using last.

Serryon123 · #5 03-14-2012, 08:04 PM

Ok great thanks im going to do that then. 1 more thing, would u be able to tell me how to change my starting zone and locs all at once? trheres like 345 rows cut and pasting suuucks!

**Akkadius** · #6 03-14-2012, 08:12 PM

Quote:

Originally Posted by Serryon123

Ok great thanks im going to do that then. 1 more thing, would u be able to tell me how to change my starting zone and locs all at once? trheres like 345 rows cut and pasting suuucks!

You can change your starting zone for Titanium clients in the 'variables' table, you have to add an entry called 'startzone' and then in the value is your short name of the zone.

For SoF clients and up you change it in the `rules_values` table with the rule name of 'World:SoFStartZoneID', you set the value to be the zone ID name.

Otherwise if you really do want to change all of the values in the `start_zones` table you can do something like this:

Code:

UPDATE `start_zones` SET `x` = somevalue, `y` = somevalue, `z` = somevalue, `id` = somevalue;

Serryon123 · #7 03-14-2012, 08:14 PM

Ah cool thanks a lot Akka. Yea man I already had this update sourced its all duplicate entrys.. So any ideas on the pets? My server has leveling content i REALLY dont want to have to make every pet in the game by hand >_< haha

**Akkadius** · #8 03-14-2012, 08:16 PM

Quote:

Originally Posted by Serryon123

Ah cool thanks a lot Akka. Yea man I already had this update sourced its all duplicate entrys.. So any ideas on the pets? My server has leveling content i REALLY dont want to have to make every pet in the game by hand >_< haha

Any pets that PEQ doesn't have in the database you will have to make yourself. There's nothing that automatically makes your pets... right now anyways

Serryon123 · #9 03-14-2012, 08:26 PM

Dam! Ok thanks, and btw that starter zone query u gave me we figured out and worked like a charm

thanks again!

**Akkadius** · #10 03-14-2012, 08:29 PM

Quote:

Originally Posted by Serryon123

Dam! Ok thanks, and btw that starter zone query u gave me we figured out and worked like a charm

thanks again!

Yep. No problem

Jeknos · #11 03-14-2012, 08:55 PM

Quote:

Originally Posted by Serryon123

I had a question wondering if anyone had a fix, i have a fresh db and sourced everything in specifically the pets table, yet whenever I try to summon ANY kind of pet, theres no data found for them. Any ideas? Ive checked the spells specifically and the db and have actually summoned the npc ID the pet is supposed to be but the spells wont summon them. Thanks!

If I'm reading this correctly, you only copied in the pets table? Pets are linked to npc_types so you won't be able to summon one without having the pet in npc_types as well.

Serryon123 · #12 03-14-2012, 09:03 PM

Im pretty sure i did it all, but ill try that as well and post back ty!

Serryon123 · #13 03-14-2012, 09:08 PM

I cant find a solid just npc_types.sql file anywhere in my trunk folder, the other 1s that have some type of npc in the file name ive sourced

lerxst2112 · #14 03-14-2012, 11:17 PM

You need to source the base peq database, this includes all the tables for npcs, pets, etc.

Then you source load_player.sql, and if you use bots, load_bots.sql

Then you source all of the required updates newer than the peq database version, and any optional updates newer than the peq database version that you're interested in.

At no time do you source specific individual tables.

Serryon123 · #15 03-15-2012, 02:59 AM

*sigh* yea i did all that and I just got the most updated rev n sourced it in rebooted server tried to cast and STILL no pets.. this is frustrating because i dont want to start all our hard work over.. Then again id prefer not to make every classes pet >_<