No trade to attunable

[Kingly_Krab]

He just wanted spells.

##This goes in global_player.pl
sub EVENT_LEVEL_UP
{
quest::scribespells($ulevel, $ulevel -1);
}

Trying not to over-complicate things for him so he can learn, c0ncrete's script is pretty complex for someone who is just starting out.
This is from 2004, no longer valid as some things have changed, like the existence of Drakkin and some column names have changed.

[xplodr]

How would I access the database so that I can see those tables? Right now I am just using EOC browser based editor from Akkadius. Thanks!

[Kingly_Krab]

You can download Navivat here. Upon opening it up click 'Connection' then 'MySQL'. The Connection Name can be anything you want, set the hostname to localhost, port to 3306, user name to root, password to whatever the password to your database is. Like below.

Host Name/IP Address: localhost
Port: 3306
User Name: root
Password: PASSWORD HERE

[xplodr]

When I click connection it asks for Connection name, Host Name/IP Address, then has a drop down menu for SQL Server Authentication or Windows, then username and password. I don't see a place to select port or anywhere to click MySQL after connection :(

PS: Oh and it times out after filling it out with what i do have.

[Kingly_Krab]

Are you on an Administrator account? Did you download the version for MySQL? I've never seen an issue as such.

[xplodr]

I must have had a different version, once i removed it and downloaded the one from your link it worked fine. So I got in and took a look at the starting zones and the starting items, but as far as i can tell it's already setup to go tot he starting cities. But when a new toon is created they go to the tutorial, and from what ic an tell the starting items list has the tattered note you turn in for the noobie tunic, but none of the characters i created actually have that, they all have a weapon, lantern, bag, food and bandages.

[Kingly_Krab]

Well, there's 2 settings in the 'rule_values' table, here's how you adjust them. Change XXXX to your Zone's ID.

/*Adjusting settings in rule_vales for start zones.*/
UPDATE rule_values SET World:TutorialZoneID = XXXX;
UPDATE rule_values SET World:SoFStartZoneID = XXXX;

[xplodr]

is there any way to just bypass tutorial so they start in the old school starting points? like human bard starts in south qeynos in front of the bard guild or does it all have to be handled manually?

[Kingly_Krab]

Hmmm, this may work for disabling the ability to go to the Tutorial Zone.

/*Change Tutorial Zone capability to 'false' from 'true'.*/
UPDATE rule_values SET rule_value = 'false' WHERE rule_name = 'World:EnableTutorialButton';

[xplodr]

Nice! That worked. Can you tell me how I can disable expansions? So I can build a time-locked progression type thing?

[Kingly_Krab]

Yeah, there is, although I don't quite understand how it works there is a setting in the rule_values table that deals with expansions, you could also just cap the level and require beyond the cap level for entry to those zones, just my two cents.

/*Select the expansion rule in rule_values.*/
SELECT * FROM rule_values WHERE rule_name LIKE 'World:ExpansionSettings';

[xplodr]

sorry, i missed your response. So I capped the level at 50, do I have to manually set all other zones to 51+ or something?

[Kingly_Krab]

Yes, you have to manually set the ones you do not want them to access before level 51 to a required level of 51 in the zones table.

EDIT: Off-topic, but what is the name of your server? I would like to check it out, or is it not public?

[xplodr]

It's locked ATM but it's called Fixed EQ.

[xplodr]

When all is said and done, it will be a 1 char per IP with 1 bot (3 created) legit server with standard peq difficulty. I have modified the loot drop tables for starter zones and out lying zones to drop improved gear (like the Halloween special items. example clockwork bauble etc.) so that the initial 1-30 grind is more fun by having better chance for gearing up. I also modified dungeon drops to make more sense like blackburrow's onyx earring has ac hp and a few more stats. not much like 4ac and 10hp etc. i also added some minor hp/ac/mana/dmg augs to the 30-40 mob table along with a low chance (like .25%) to some minor fabled items (<40hp) so people can gear up a little bit while grinding. I plan on adding the 40-75hp fabled items at a .25% chance for levels 40-50 and adjusting all the dungeon loot for vanilla so it makes more sense for the difficulty and removing dumb things like +wis on SK leggings from PoFear.