Uploading to MySQL problem

mrclose · #1 10-26-2003, 03:50 PM

Im not understanding what IP has been banned error means when I run Packetcollecter. here is the output

C:\EQEMU>packetcollector -dbh localhost -dbu mrclose -dbp ***** -dbd dump -item
table items 192.168.0.86
Loaded item: Backpack (17005)
Sniffin on '\Device\Packet_{4EC2D608-B473-4452-A9D1-E4AAEF104468}', net=192.168.
0.0, target=192.168.0.86 (192.168.0.86)
Got signal: 2
Using database 'dump' at localhost, User: mrclose, Password: Yes
You cannot upload to the EQEmu database. Your IP has been banned.
Not connected. Cannot upload items.
Not connected. Cannot upload texts.

Any insight would be grateful

ric0h · #2 10-26-2003, 10:30 PM

same here. is this a new feature to block submitters submitting items to databases other than yours? :lol:

:

mrclose · #3 10-27-2003, 12:34 AM

Oh No I sure hope not!

Merth · #4 10-27-2003, 03:10 AM

Instead of this:

Quote:

C:\EQEMU>packetcollector -dbh localhost -dbu mrclose -dbp ***** -dbd dump -item

Try this:

Quote:

C:\EQEMU>packetcollector your.ip.here.com

ric0h · #5 10-27-2003, 05:06 AM

Quote:

Originally Posted by mrclose

Im not understanding what IP has been banned error means when I run Packetcollecter. here is the output

C:\EQEMU>packetcollector -dbh localhost -dbu mrclose -dbp ***** -dbd dump -item
table items 192.168.0.86
Loaded item: Backpack (17005)
Sniffin on '\Device\Packet_{4EC2D608-B473-4452-A9D1-E4AAEF104468}', net=192.168.
0.0, target=192.168.0.86 (192.168.0.86)
Got signal: 2
Using database 'dump' at localhost, User: mrclose, Password: Yes
You cannot upload to the EQEmu database. Your IP has been banned.
Not connected. Cannot upload items.
Not connected. Cannot upload texts.

Any insight would be grateful

Well, you need to have a table named banned_list to be able to get past that. The PC queries against it and if it gets a match for user() or just an error, then you get bailed out.

To make things even better, PC's item table layout is dynamic, and it gets it's from a table named column_names at the main sql server.

Not going to tell how to get that data though, developers should be eager to share it, but aren't.

Merth · #6 10-27-2003, 07:13 AM

Quote:

Not going to tell how to get that data though, developers should be eager to share it, but aren't.

Anybody can peek in eq_packet_structs.h and see for themselves ..

We aren't eager to share that? You know something I don't?

ric0h · #7 10-27-2003, 10:59 AM

Merth,

I was talking about column_names and the items@items.eqemulator.net's db password.

:twisted:

mrclose · #8 10-27-2003, 11:53 AM

Thank you for the input but it appears I need the coumn name used to create the table.

mrclose · #9 10-27-2003, 12:26 PM

Now I get this.... What piece of the pie am I missing here? What is the DB table structure the program needs please?

C:\DOWNLOADS\TEST>packetcollector -dbh localhost -dbu ****** -dbp camaro -dbd d
ump -itemtable items 192.168.0.86
Loaded item: Backpack (17005)
Sniffin on '\Device\NPF_{446659FC-9C9F-40F7-BE79-FCF0987147E8}', net=0.0.168.192
, target=192.168.0.86 (192.168.0.86)
Got signal: 2
Using database 'dump' at localhost, User: mrclose, Password: Yes
Uploading items to table: 'items'
Getting column names..
Error getting field names: Unknown column 'seq' in 'field list'
Uploading texts to table: 'texts_dump'
0 texts added, 0 updated, 0 unchanged.

Edgar1898 · #10 10-27-2003, 01:03 PM

Why do you want to collect items only for yourself when you could collect for the community also? The item db is shared fully its not like we are hoarding the data. I'm not sure why that option was ever added, but there is no reason to use it as everyone is better off using the public items db. As for the passwd to the items db, why do you need the passwd? There is no reason to give it out.

mrclose · #11 10-27-2003, 01:55 PM

It seems with the new cvs release there is no DB that works with it. I was hoping to port some items into it. Nothing sinister here really. If a sourcable item list was readily available I wouldnt need to do this.

Edgar1898 · #12 10-27-2003, 02:10 PM

yah you not looked at the site in the past 2 months? Our public item db is the most up-to-date you can get and its freely available. Thats why that option to set your own db is pointless, one user couldnt possibly get a full database.

mrclose · #13 10-27-2003, 03:35 PM

Public item db? that works with the latest cvs? I guess its under my nose and I am blind? Where is it?

#14 10-27-2003, 03:38 PM

right on the main page found here http://www.everquestserver.com/main.php
on the left hand side is a link titled collected items. click that link down at the bottom is another link called Latest item DB.

mrclose · #15 10-27-2003, 03:42 PM

So this DB work with cvs 5?