EQEmulator Forums - Easy Start Zone Tutorial

I read the wiki and while it went a long way to get me where I wanted I still had to figure some things out.

My goals here were:

to set the start zone to PoK
HAve toon zone in a certain spot in PoK.
disable tutorial button
remove any chance that a new toon can zone into tutorial from character select - Ever, even if button=false command doesnt work
remove options for starting in classic zones
allow users to see PoKnowledge in the drop down from character create screen

1. Logged in and verified zone ID (PoK Zone ID = 202) and LOC for PoK

2. Take a .sql dump of the below tables for backup purposes and so you can go back to default if you want:

start_zones
char_create_combinations
rule_values

3. following the current Wiki Add the following to rule_values:

Code:

1        World:TitaniumStartZoneID        202        

10        World:TitaniumStartZoneID        202        

1        World:SofStartZoneID        202        

10      World:SofStartZoneID        202

4. Open notepad or notepad++ and add the below and save as .sql
Note: Remember I wanted to change the tutorial ID just incase the button=false doesnt work in the future. As a result I changed the max level to 255 since it was changed to pok. This is 100% optional (last two lines below):

Code:

UPDATE `peq`.`start_zones` SET `zone_id`='202' Where `select_rank`='50';

UPDATE `peq`.`start_zones` SET `start_zone`='202' Where `select_rank`='50';

UPDATE `peq`.`char_create_combinations` SET `start_zone`='202' Where `start_zone`='394';

UPDATE `peq`.`start_zones` SET `x`='-285' Where `select_rank`='50';

UPDATE `peq`.`start_zones` SET `y`='-148' Where `select_rank`='50';

UPDATE `peq`.`start_zones` SET `z`='-159' Where `select_rank`='50';

UPDATE `peq`.`start_zones` SET `heading`='53.8' Where `select_rank`='50';

UPDATE `peq`.`rule_values` SET `rule_value`='false' Where `rule_name`='World:EnableTutorialButton';

UPDATE `peq`.`rule_values` SET `rule_value`='202' Where `rule_name`='World:TutorialZoneID';

UPDATE `peq`.`rule_values` SET `rule_value`='255' Where `rule_name`='World:MaxLevelForTutorial';

5. open command prompt.
mysql -uusername -ppassword
use databasename
source c:\wherever you saved the file\file.sql

6. Run the below Delete .sql lines. You can save them both in notepad as .sql or just run from cmd
(Note: this is to remove the classic zone selection from character creation)

Code:

DELETE FROM char_create_combinations WHERE start_zone > '202';

DELETE FROM char_create_combinations WHERE start_zone < '202';

save tables, restart server... and have fun. You will note then if tutorial is seleted it will display zonning into "mines of glooming..." it will auto zone into Pok at the location you wanted to be in instead in this case thus avoiding tutorial.

Not sure if this helps anyone but I thought I'd share as I am not the only one making a complete custom server in addition to classic.