Uploading to MySQL problem

[ric0h]

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.