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:
using db.sql, that field won't be created:

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

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..

hehe
 

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!!

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

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

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

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!