No pets?

[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!

[lerxst2112]

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

[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?

[Akkadius]

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]

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]

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:

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

[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

[Akkadius]

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]

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

[Akkadius]

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

Yep. No problem

[Jeknos]

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]

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

[Serryon123]

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]

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]

*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 >_<

[bad_captain]

I would check you logs to see if it mentions not being able load from a table in the db. Then check the sql in the svn for the pets update a couple of months ago.

[Serryon123]

Ok well working on this last and today, we've come to the conclusion (if this is possible) that our spell file is not linking up to our database when it comes to PETS only. We can cast other spells fine, pets r in the db in both the pets table and the npc_types table.. I have the latest updates. Anyone have ANY clue what is going on here? Thanks in advance.

EDIT:: Just tried to export the whole spells table and use that spell file, still nothing :(

[Serryon123]

where can i find my logs at?

[Serryon123]

2069_required_pets.sql, I sourced that in already is that what your talking about?

EDIT: I just re sourced that in n everything rebooted and still getting Unable to find data for pet skel_pet_16

[Serryon123]

omg! I got it! If anyone is having this problem, what happened was this error Unable to find data for pet skel_pet_16 Was trying to pull it from db so i tried everything and looked through my spells.. Well I opened my Allias Spell editor. Sure enough that was correct.... I look into the pets table of my database, theres an extra under. It looked like this Unable to find data for pet skel_pet_16 _ All I did was go under pets table remove the underscore reboot and it worked, and thanks everyone for the suggestions!