Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers

Support::Windows Servers Support forum for Windows EQEMu users.

Reply
 
Thread Tools Display Modes
  #1  
Old 10-18-2019, 12:40 PM
strugglegenerator's Avatar
strugglegenerator
Hill Giant
 
Join Date: May 2012
Location: Minnesota
Posts: 231
Question char_create_combinations (Vah Shir)

I've been successful at removing all undesired race/class combinations from my char_create_combinations table except Vah Shir.

Whenever I select to create a new character, it always picks a random race/class combo to start. Sometimes that random race will be Vah Shir, even though I've removed every reference to race ID 130 (Vah Shir) from the char_create_combinations table.

I do have Luclin enabled, but only because I want to use the AA's. I don't want the Vah Shir.

If I try to forcibly make a Vah Shir, I can't, which is good. This is ONLY happening when EQ picks the random race/class combo after selecting an empty character slot.

Is it not possible to remove Vah Shir from the character selection screen's "Random" race/class selection?
Reply With Quote
  #2  
Old 10-18-2019, 09:27 PM
chrsschb's Avatar
chrsschb
Dragon
 
Join Date: Nov 2008
Location: GA
Posts: 905
Default

You have to remove Vah Shir from char_create_combinations and from char_create_point_allocations, then reboot.
__________________
Clumsy's World: Resurgence
Clumsy's World [2006-2012]
Reply With Quote
  #3  
Old 10-21-2019, 11:49 AM
strugglegenerator's Avatar
strugglegenerator
Hill Giant
 
Join Date: May 2012
Location: Minnesota
Posts: 231
Question

Thank you chrsschb.

Since I've already removed Vah Shir, Drakkin and Froglok from the char_create_combinations table, I'm left with a lot of unnecessary ID's in the char_create_point_allocations table.

I've been trying to figure out which ID's in the char_create_point_allocations table are for Vah Shir, Drakkin and Froglok so I can remove them, but it's proving to be quite difficult.

I made a list of all the ID's that are still in use in the char_create_combinations table and compared that to the 108 rows of char_create_point_allocation ID's that are still existing and I found that the following ID's do not exist in my char_create_combinations table, so I THINK I can safely delete them from char_create_point_allocations and achieve my desired result of no selectable Vah Shir, Drakkin or Froglok during the "Random" race selection of character select:

ID's that I THINK I need to remove from char_create_point_allocations are:
0, 1, 12, 59, 65, 66, 69, 70, 71, 75, 76, 77, 78, 79, 80, 86-108

Does this sound right or am I way off? I couldn't find a good resource that cross referenced the two tables together, so this is the best I could come up with.
Reply With Quote
  #4  
Old 10-21-2019, 01:00 PM
strugglegenerator's Avatar
strugglegenerator
Hill Giant
 
Join Date: May 2012
Location: Minnesota
Posts: 231
Default

Ok I think I figured it out after looking at my original database from back in June 2019 before I removed any of the races or classes in the char_create_combinations table. My research indicates that the following ID's in the char_create_combinations table will corresponding to the correct ID's in the char_create_point_allocations table for removing Vah Shir, Drakkin, Frogloks, Berserkers and Beastlords:

Vah Shir (Race ID 130)
Remove the following ID's from char_create_point_allocations table:
75-80

Froglok (Race ID 330)
Remove the following ID's from char_create_point_allocations table:
86-93

Drakkin (Race ID 522)
Remove the following ID's from char_create_point_allocations table:
94-106

Beastlord/Berserker
Remove the following ID's from char_create_point_allocations table:
0, 1, 12, 59, 65, 70, 71, 76, 77
Reply With Quote
  #5  
Old 10-21-2019, 01:08 PM
Kingly_Krab
Administrator
 
Join Date: May 2013
Location: United States
Posts: 1,589
Default

The new wiki at http://eqemu.gitbook.io has all the database documentation.


As far as the allocations, if you look in the char_create_combinations table you'll notice that it uses the allocation identifier from char_create_point_allocations. So if you already deleted those rows, you'll have a hard time mapping them manually.

This query should pull all the ones you don't need anymore.


Code:
SELECT * FROM `char_create_point_allocations` WHERE `id` NOT IN
 (SELECT `allocation_id` FROM `char_create_combinations`);
https://eqemu.gitbook.io/database-sc...nt_allocations

https://eqemu.gitbook.io/database-sc...e_combinations
Reply With Quote
  #6  
Old 10-21-2019, 02:15 PM
strugglegenerator's Avatar
strugglegenerator
Hill Giant
 
Join Date: May 2012
Location: Minnesota
Posts: 231
Default

Thanks for all the help, but even after removing all references to Vah Shir from both tables, I am still able to make a Vah Shir. Quite frustrating, as I was hopeful this was the missing link. (yes, I restarted the server)
Reply With Quote
  #7  
Old 10-21-2019, 03:04 PM
Huppy's Avatar
Huppy
Demi-God
 
Join Date: Oct 2010
Posts: 1,333
Default

Those 3 tables control the options/choices for toons at startup. It works for everyone else. If it's not working for you, then something is screwed up. Check your rule_values table also. World:UseClientBasedExpansionSettings false

char_create_combinations
char_create_point_allocations
start_zones
__________________
Hanging out at Antonica.World
Reply With Quote
  #8  
Old 10-21-2019, 07:05 PM
strugglegenerator's Avatar
strugglegenerator
Hill Giant
 
Join Date: May 2012
Location: Minnesota
Posts: 231
Default

I triple checked all 3 of those tables and I have removed Vah Shir, Drakkin, Froglok, Berserker, and Beastlord from all of them. There is not a single 1 I missed.

I also have World:UseClientBasedExpansionSettings false.

I know you say it works for everyone else, but it doesn't work for me. Is there anything else I could try?
Reply With Quote
  #9  
Old 10-21-2019, 07:06 PM
Kingly_Krab
Administrator
 
Join Date: May 2013
Location: United States
Posts: 1,589
Default

Some stuff is hard-coded and is only disabled server-side and not visually.
Reply With Quote
  #10  
Old 10-21-2019, 07:10 PM
Huppy's Avatar
Huppy
Demi-God
 
Join Date: Oct 2010
Posts: 1,333
Default

Sorry struggle, I have no idea what's happening on your end. It can probably be a number of different reasons, but I guess it all depends on your whole DB setup, what client you are using, etc. If you want easy way to start troubleshooting, first install a fresh database, get it updated and then make those relevant changes to see what happens. If it works, then you know the issue is somewhere in the affected database.
__________________
Hanging out at Antonica.World
Reply With Quote
  #11  
Old 10-21-2019, 07:53 PM
strugglegenerator's Avatar
strugglegenerator
Hill Giant
 
Join Date: May 2012
Location: Minnesota
Posts: 231
Default

All good. I am just going to disable Luclin completely by putting World:ExpansionSettings = 2. That's the only way it stops happening. I was just hoping I could somehow keep AA's but without the Vah Shir, Beastlord, etc.

Thank you everyone for the help, at least I learned a lot from you all =)
Reply With Quote
  #12  
Old 10-21-2019, 08:15 PM
Huppy's Avatar
Huppy
Demi-God
 
Join Date: Oct 2010
Posts: 1,333
Default

You give up too easy. People do that when they get impatient. I remember back when I was having to learn a lot of basics, one time I spent 3 full days looking for a solution to a problem and, in the end, it was a simple "typo" of one measly little character in that infamous alphabet of ours, lol
__________________
Hanging out at Antonica.World
Reply With Quote
  #13  
Old 10-21-2019, 08:28 PM
strugglegenerator's Avatar
strugglegenerator
Hill Giant
 
Join Date: May 2012
Location: Minnesota
Posts: 231
Default

I've literally tried everything I could think of, plus every suggestion provided on this forum. It appears to be a hard coded thing, which I have no way of altering since I am terrible with code. I'm sure one day I'll take a look at it again, but for now I can rest easy knowing I gave it 110% and found nothing that would achieve my desired result.
Reply With Quote
  #14  
Old 10-21-2019, 08:52 PM
Huppy's Avatar
Huppy
Demi-God
 
Join Date: Oct 2010
Posts: 1,333
Default

I tried to replicate your issue (somewhat), using an RoF2 client. I removed the vah shir from the create tables, and it would NOT let me create a vah shir toon. This is with all expansions enabled. You will notice that option disabled on the char select screen.

__________________
Hanging out at Antonica.World
Reply With Quote
  #15  
Old 10-22-2019, 06:27 AM
strugglegenerator's Avatar
strugglegenerator
Hill Giant
 
Join Date: May 2012
Location: Minnesota
Posts: 231
Default

Thanks for posting this Huppy. I think we are getting to the root of the issue now. I use the Titanium client, so it looks like these methods don't work for Titanium, but they do work for RoF2.

Thank you for all the help, I truly appreciate it! =)
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 09:14 AM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3