EQEmulator Forums - Fixed db.sql errors in 44dr1.zip

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Archive::Database/World Building (https://www.eqemulator.org/forums/forumdisplay.php?f=625)

- - Fixed db.sql errors in 44dr1.zip (https://www.eqemulator.org/forums/showthread.php?t=7490)

Fixed db.sql errors in 44dr1.zip

http://edwardpinniger.bctalk.net/eq/44dr1.zip
The db.sql in 44dr1.zip had an error in the zone table (the "weather" value was in the table structure,
but missing from the data). I've fixed this now so it should source in without any errors. (I've tested it
and it seems to work OK).
This -may- also get weather working properly (I've set the weather flags for rain or snow in the zones that have
it) but I haven't tested this yet.

Awesome work Drawde, I'll whip up a new DB to take a looksie today ^_^

- Xelnagan

comparing db.sql with update44dr1.sql

comparing db.sql with update44dr1.sql i noticed a small difference:

using update44dr1.sql, a field 'notes' is created in table 'tradeskillrecipe' because of this line:

Quote:

ALTER TABLE `tradeskillrecipe` ADD COLUMN `notes` TEXT after `i10`;

using db.sql, that field won't be created:

Quote:

CREATE TABLE tradeskillrecipe (
id int(11) NOT NULL auto_increment,
tradeskill smallint(6) NOT NULL default '0',
skillneeded smallint(6) NOT NULL default '0',
trivial smallint(6) NOT NULL default '0',
product smallint(6) NOT NULL default '0',
product2 smallint(6) NOT NULL default '0',
failproduct smallint(6) NOT NULL default '0',
productcount smallint(6) NOT NULL default '0',
i1 smallint(6) NOT NULL default '0',
i2 smallint(6) NOT NULL default '0',
i3 smallint(6) NOT NULL default '0',
i4 smallint(6) NOT NULL default '0',
i5 smallint(6) NOT NULL default '0',
i6 smallint(6) NOT NULL default '0',
i7 smallint(6) NOT NULL default '0',
i8 smallint(6) NOT NULL default '0',
i9 smallint(6) NOT NULL default '0',
i10 smallint(6) NOT NULL default '0',
PRIMARY KEY (id),
UNIQUE KEY id (id),
UNIQUE KEY name (product)
) TYPE=MyISAM;

My question: is that field required or not?

OK, I'll found the answer:

I looked at worlddata1.1 db and in fact that field is used (-> comments). Here's an example out of tradeskillrecipe.txt:

Quote:

#ID,tradeskill,skillneeded,trivial,product,product 2,failproduct,productcount,i1,i2,i3,i4,i5,i6,i7,i8 ,i9,i10,comments
INSERT INTO tradeskillrecipe VALUES (3003,64,82,82,8502,0,0,5,8066,8060,8055,8050,0,0, 0,0,0,0,'CLASS 3 Wood Point Arrow');

Its not required for the code to work, but its required to insert the record into the database.

IE: The code does not use that field, its just an informational field

Knew there would be something else I missed.. I'll fix that error too and post here when I've uploaded the new fixed version.

Also, if the inventory/cursor bug has been fixed (I think BigPull mentioned it had) would anyone mind sending me some compiled binaries with the latest CVS? I'll include them in the updated 44dr1.zip.

I'll see about getting you a few binaries this evening sometime Drawde.

Drawde is there a fix for the GM item bug in 4.4 ??

For some reason no one can keep the GM items they have won in 4.4 but they can in 4.3... Only reason i'm useing 4.3 right now is because of that, otherwise I would use 4.4..

King Mortenson
SySop Raid Addicts (Semi Legit)

Still at Column 1

getting the same at column 1 error at the end

The GM item bug is not a bug, it is a fix to prevent normal players from getting GM items.

Why create an item, flag it as GM, and give it to players if it's not intended to be a GM player?

Are you saying GM's are being stripped of the GM items? If so, thats a bug.

Are normal characters being stripped of GM flagged items? If so, thats intention.

Please clarify

he runs semi-legit and he doesnt want people to summon godly item (flagged GM), and make mob drop GM item reward or quest giver give GM item.

u know like krushers

So you want the check in one place but not the other.. I got ya..

Ah I see, Well the intention is cool I guess but not how my server is going to work. What purpose would quests be if people could summon the rewards ??? or summon the parts to the quest??? Thats why I have the items that they can't summon awarded too them... Makes it worth it for them to do the quest.....

But we're figuring it out atm, got my coders working on it..

Thanks for the quick responses though :)

What's the purpose in requiring any work to be done in semi-legit? Questing takes too long: gimme!!