Huppy
03-16-2019, 03:05 AM
If anyone wants to be lazy in setting up their classic doors, zone_points, etc., I dumped some tables from an older database that was using most of the older versions of (available) zones, along with character creation, start zones and starting items.(Frogloks, Drakkins and Beserkers have been removed from character creation choices).
Patronizing reminder: BACKUP YOUR DATABASE BEFORE SOURCING THESE IN! Zip download includes the following files:
README.txt
char_create_combinations.sql
doors.sql
start_zones.sql
starting_items.sql
zone_points.sql
http://tinyurl.com/ClassicPackTables
If you've taken the initiative to learn about running sql queries, it can speed some tasks up in a big way. For example, if you wanted to temporarily disable all the PoK books in all the classic zones, you could run this query, changing the name to something unique to disable it. (POKTELE500 is the original working name) This will disable all 31 classic PoK books around Norrath.(They won't show up in client).
UPDATE doors SET name = 'POKTELE500NULL' WHERE name LIKE 'POKTELE500';
Then, when you want to enable them again, you revert the names back to original.
UPDATE doors SET name = 'POKTELE500' WHERE name LIKE 'POKTELE500NULL';
Patronizing reminder: BACKUP YOUR DATABASE BEFORE SOURCING THESE IN! Zip download includes the following files:
README.txt
char_create_combinations.sql
doors.sql
start_zones.sql
starting_items.sql
zone_points.sql
http://tinyurl.com/ClassicPackTables
If you've taken the initiative to learn about running sql queries, it can speed some tasks up in a big way. For example, if you wanted to temporarily disable all the PoK books in all the classic zones, you could run this query, changing the name to something unique to disable it. (POKTELE500 is the original working name) This will disable all 31 classic PoK books around Norrath.(They won't show up in client).
UPDATE doors SET name = 'POKTELE500NULL' WHERE name LIKE 'POKTELE500';
Then, when you want to enable them again, you revert the names back to original.
UPDATE doors SET name = 'POKTELE500' WHERE name LIKE 'POKTELE500NULL';