Fixed db.sql errors in 44dr1.zip

[Drawde]

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.

[xelnagan]

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

- Xelnagan

[Mauritius]

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:

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


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

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?

[Mauritius]

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:

#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');


8)

[Trumpcard]

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

[Drawde]

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.

[Drawde]

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.

[Trumpcard]

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

[Mortenson721]

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)

[Velosity]

getting the same at column 1 error at the end

[Trumpcard]

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

[haloboycs]

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

[Trumpcard]

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

[Mortenson721]

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 :)

[a_Guest03]

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

[bpogue99]

Trump, I didn't think that GM only items were given out to only GM players. They were items that were special and could only be given out 'BY' a GM, but anyone could weild the item if they got it. Those items were of course lore no drop and often class/race specific, but if a GM decided my level 1 cleric needed such an item, they could give it to me. No? I never actually ever received a GM item so I wouldn't know first hand, just looking for clarification is all.

bill

[xelnagan]

A traditional GM item would be Verdant Chain Gloves(GM gloves), in-game these would be flagged so that only a GM character can have them. Event items, however, are normal in the database. Hence, if summoning abilities were there in EQLive you could get any item you want, even artifacts. The proposed solution is to create a EQLive type item control enviroment. That way, no summoning can be done, and a GM can give out items as is.

- Xelnagan

[Drawde]

Are you still going to send me those files, TC?
As I said, once I've got them, and tested them, I'll post them here along with an updated DB (fixed the tradeskill notes value as well as the zone weather value now).

[bpogue99]

Ah, yes, event items! Thanks for the clarification on that. I never got an event item either <sniff>, but then, my character has everything it needs now hehe. Thanks again!