View Single Post
  #5  
Old 10-21-2019, 01:08 PM
Kingly_Krab
Administrator
 
Join Date: May 2013
Location: United States
Posts: 1,603
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