** 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]

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

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

[ManJones]

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

Hmm anyone have any other ideas ? :)

[devn00b]

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

[ManJones]

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]

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/index.php?act=ST&f=2&t=328&s=6017ef2b22aabda24790283f179bbfec

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

[Raahb]

I tried that MySQL Front but I still can't really figure out what to do. I also tried deleting the item.sql from the 3.13 addon and replacing it with the items.sql from this thread and using the install.bat that came with 3.13. No luck so far.

[inferno222]

I think this will work, it's what I did, and I *think* it worked, and have had no problems after doing it.

Delete items table in mySql Front
Move items.sql to mysql/bin folder
Go to MYSQL/bin folder, open mysql.exe

type 'use eq'
then type 'source items.sql'

let it scroll, and when it's done, close mysql.exe

then you're done..of course I have no idea if this worked or not, since I know jack sh!t about mysql, but I seem to be able to find more PoP items, and of course everything works fine.

can any of you mysql genius' let us know if that even works?

[Trumpcard]

That works fine..


Folks, I don't want to get on a rant, but if you are going to run a server, you REALLY need to learn SQL a bit and some basic mysql syntax. Not having any idea how the database works is going to frustrate you to no end.

There are TONS of mysql tutorials on the web, use some of them and get an understanding of how to manage the database, believe me, you're lives will be much better.


The EASY way to do this.

1) Copy the new items.sql to the C:\mysql\bin directory
2) Open a DOS command window (if you dont know how to do this, there are instructions out there)
3) cd c:\mysql\bin
4) type 'mysql' This opens the mysql interface.
5) use eq;
6) drop table items;
7) source items.sql;


Thats it, and it doesnt require any external tools. Here are a few mysql commands to get you started, but if you are going to run your own server, for goodness sake learn a bit about the tools we use to manage it. We arent a basic mysql forum! I don't mind a few mysql questions here or there, but these forums shouldnt be filled with 100 questions on 'how do i use mysql'. There is TONS out there on managing a mysql database, use google and find a few, print them out, read them in the toilet.

Basic Commands:

show databases; //shows all databases installed on your mysql instance
use <database>; //sets that as the active database
show tables; //shows all currently defined tables in the database you selected
describe tablename; //gives you a description of the format of the table
select * from <tablename>; //displays all records in the indicated tablename


If you're going to run an eqemu server, learn to use the tools.. Anyone that says 'I want to run a server, but I don't want to have to learn all this new computer stuff ' really should stick to playing on someone elses server.

Please keep in mind I'm not picking on anyone, I'm just telling you, going to run your own server? LEARN MYSQL ! It's not hard at all ;-)

[bobmook]

an even better gui is mysqlyog available at this address http://www.webyog.com/sqlyog/download2.php

In order to add the items table using mysqlyog you'd drop the table then just browse to the items.sql file from the tools- run batch file and run it.
In mysqlfront I think there's a query analyzer built in so you'd run the items.sql from there.
These are just ways of doing what Trumpcard explained though a gui and it has been my experience that at times the mysql gui's don't run sql scripts correctly, so caveat emptor.