** NEW UPDATED ITEM DB **

[devn00b]

Everyone thanks Divide (on #eqemu) for this great update. she didnt realy want recognition for it but =P to that...so everyone thank her if ya like it.

Im just posting it and putting it on my ftp.

Some of the changes include:

20 PoP Items,
Locked and Edited all GM Items
Removed all Hacked Weapons
Fixed 10 Crash Weapons
Fixxed 384 dly122 Weapons
Fixed Bard Epic
Fixxed the Bane DMg on 6 items

http://nctimes.net/~threeofus/items01032003.zip

[ManJones]

What do you mean GM items locked and edited?

[ManJones]

Is there any other way to do it other than just sourcing it in and listening to thousands of beeps because of all the duplicate errors?

[feedgood]

Fixed items are great! thanks

Is there any other way to do it other than just sourcing it in and listening to thousands of beeps because of all the duplicate errors?

Maybe theres a better way to do it but I just opened the SQL and replaced all 'INSERT' with 'REPLACE' in a notepad program and sourced it. I'm not sure if doing that puts in the PoP/new items or not, but I don't have PoP so I don't care. :P

[ManJones]

Originally Posted by feedgood

Fixed items are great! thanks

Maybe theres a better way to do it but I just opened the SQL and replaced all 'INSERT' with 'REPLACE' in a notepad program and sourced it. I'm not sure if doing that puts in the PoP/new items or not, but I don't have PoP so I don't care. :P

I started that in notepad myself, thanks. Umm how long did it take to complete, mine should be done tomorrow at this rate

[feedgood]

Actually I used OpenOffice.org, it replaces all that stuff quickly. However I wouldn't suggest doing what I said because it seems like it messed with my DB a little and I'm missing a bunch of items .

[ManJones]

Originally Posted by feedgood

Actually I used OpenOffice.org, it replaces all that stuff quickly. However I wouldn't suggest doing what I said because it seems like it messed with my DB a little and I'm missing a bunch of items .

Hmm anyone have any other ideas ?

[devn00b]

easy nuff..just drop yer item database and then reload the new items db.

[ManJones]

Originally Posted by /dev/n00b

easy nuff..just drop yer item database and then reload the new items db.

If you dont mind , how do i drop my items db?

[ManJones]

Hmmm all the GM gear seem to be maxed out at +125 evreything now, Is this normal?

[a_Guest03]

It seems normal to me; I've seen the items. Only GMs can summon or trade them or give them away. It's like a prize. So, not everyone is going to get one. Therefore, if that prize is suitable to give, then what's the big deal if it's that great?

[ManJones]

Originally Posted by a_Guest03

It seems normal to me; I've seen the items. Only GMs can summon or trade them or give them away. It's like a prize. So, not everyone is going to get one. Therefore, if that prize is suitable to give, then what's the big deal if it's that great?

Before item update though they were much lower stats .

[Raahb]

I'm not exactly sure how to do this. Could someone help me by posting a newbie guide to doing this? I have the newest addon(3.13 I think).

[DeletedUser]

Mysql Front
http://mysqlfront.venturemedia.de/

It lets you connect to your mysql, open databases and add,drop,etc. to them.
Easier to manage mysql with.

Oh yeah, the website is a forum so if your a lazy little newbie.
Download links are here:
http://mysqlfront.venturemedia.de/in...90283f179bbfec

[Lurker_005]

An up and comming replacement for the (unfortunatly) discontinued mySQL-Front is myFrontend also on the same messageboard. The official mySQL site also has mySQL Control Center that also gets the job done.