|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Support::Windows Servers Support forum for Windows EQEMu users. |
08-04-2013, 11:24 AM
|
Dragon
|
|
Join Date: Dec 2007
Posts: 658
|
|
I loaded up PoK in its own zone.exe so that I could read the log for the zone as stuff happened. When you try to spawn a mercenary, it prints out "Error loading NPCs from database. Bad query: #1054: Unknown column 'vwMercNpcTypes.special_abilities' in 'field list.'" That's not surprising since the table vwMercNpcTypes doesn't exist in my database. Is there any way to get those tables since I cannot find them in the source?
|
08-04-2013, 11:52 AM
|
Dragon
|
|
Join Date: May 2010
Posts: 966
|
|
Better question, do mercs even need special abilities?
This is a very recent change and you can modify the SQL that was used to convert npc_types to convert the merc table.
Edit: Reading your post again, that is a view not a table. The relevant table is merc_stats. That table need converted the same as the npc_types was.then the code that uses that table will need modified the same as the rest of the attack code was modified.
|
08-04-2013, 12:07 PM
|
Developer
|
|
Join Date: May 2011
Posts: 108
|
|
you would need to source in source_views.sql that comes along in the daily dump. That would create the views.
|
08-04-2013, 12:53 PM
|
Dragon
|
|
Join Date: Dec 2007
Posts: 658
|
|
I added in the field "special_abilities" to merc_stats. I didn't bother populating it with anything because every entry in the specialattks field was empty. After adding special_abilties, I modified vwMercNpcTypes to also include special_abilities from the merc_stats table. After doing that, I was able to spawn a mercenary without being given any errors. I don't know how stable of a fix that is, but it appears to be working.
|
08-04-2013, 02:49 PM
|
Dragon
|
|
Join Date: May 2010
Posts: 966
|
|
Instead of adding the column, you should rename the column and change the type to match npc_types. If they at wall empty then that is even less to worry about. Maybe it was added for customization down the road.
Once I get home tonight I will change it on my server and then post a SQL once I confirm it.
|
08-04-2013, 03:38 PM
|
|
Developer
|
|
Join Date: Dec 2012
Posts: 515
|
|
That seemed to work for me as well Randymarsh. Thanks
|
08-04-2013, 04:48 PM
|
Developer
|
|
Join Date: May 2011
Posts: 108
|
|
only thing I noticed missing on my end is stance info in the stance window.
|
08-04-2013, 08:30 PM
|
Dragon
|
|
Join Date: May 2010
Posts: 966
|
|
ok made this to help anyone having problems.
I ran these on a clean DB from this morning's /release. When I went to hire a merc there was nothing listed. I'll try and look into that later because the merc tables are populated.
Merc SPecial Abilities: http://pastebin.com/6gpx9RGM
Fix the View: http://pastebin.com/dXfrkFmd
Update Liaisons: http://pastebin.com/s7i5vWLk
|
08-11-2013, 10:10 AM
|
Fire Beetle
|
|
Join Date: Sep 2011
Posts: 26
|
|
Just got around to checking this thread again and I'm glad to see I'm not the only one who likes mercs and that you guys were looking into it.
I sourced in the .sqls you provided, sorvani, and mercs spawn now for me too. I haven't given them a run through to see if that have any issues, but they are at least available now and appear to be behaving properly so far. Thank you guys, for your efforts.
|
08-15-2013, 09:36 PM
|
Developer
|
|
Join Date: Feb 2009
Location: Cincinnati, OH
Posts: 512
|
|
I just tested this and was also able to get mercs to spawn for me. I will try to get the sql sourced in this weekend.
I also had the correct data show up at the merchant, so that works. I'm not sure what problem you may be having, sorvani.
|
08-15-2013, 09:49 PM
|
Dragon
|
|
Join Date: May 2010
Posts: 966
|
|
Me either and I have not had the free time to look into it.
|
08-16-2013, 12:09 PM
|
Hill Giant
|
|
Join Date: Sep 2008
Location: So. California
Posts: 219
|
|
After applying Sorvani's code everything worked, but when I went to work on my backup server and applied everything I got nothing, I had forgotten to set mercs = true in the rule values, sometimes its the silly stuff...
|
10-11-2013, 12:47 PM
|
|
Developer
|
|
Join Date: Mar 2003
Posts: 1,497
|
|
Do mercs usually have special abilities like double hit?
|
10-11-2013, 11:58 PM
|
Developer
|
|
Join Date: Feb 2009
Location: Cincinnati, OH
Posts: 512
|
|
Code:
[Mon Feb 25 00:46:15 2013] [DPS Melee Merc] pierces A jord militis for 27 points of damage.
[Mon Feb 25 00:46:15 2013] [DPS Melee Merc] pierces A jord militis for 15 points of damage.
[Mon Feb 25 00:46:15 2013] [DPS Melee Merc] pierces A jord militis for 49 points of damage.
[Mon Feb 25 00:46:15 2013] [DPS Melee Merc] pierces A jord militis for 15 points of damage.
I have logs with many rounds with 4 attacks. I'm not sure if they get any other types, but I know they can more than double.
|
10-11-2013, 11:59 PM
|
|
Developer
|
|
Join Date: Mar 2003
Posts: 1,497
|
|
Ok, so then it makes sense to leave special abilities in the code.
|
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 09:19 AM.
|
|
|
|
|
|
|
|
|
|
|
|
|