|
|
![](/forums/images/Darkness/misc/spacer.gif) |
![](/forums/images/Darkness/misc/spacer.gif) |
![](/forums/images/Darkness/misc/spacer.gif) |
![](/forums/images/Darkness/misc/q1.jpg) |
|
![](/forums/images/Darkness/misc/q1-1.jpg) |
![](/forums/images/Darkness/misc/q4.jpg) |
|
![](/forums/images/Darkness/misc/q4-1.jpg) |
![](/forums/images/Darkness/misc/a1.jpg) |
|
![](/forums/images/Darkness/misc/a1-1.jpg) |
|
Archive::Packetcollector Archive area for Packetcollector's posts that were moved here after an inactivity period of 90 days. |
![Old](/forums/images/Darkness/statusicon/post_old.gif)
10-26-2003, 03:50 PM
|
Fire Beetle
|
|
Join Date: May 2003
Posts: 15
|
|
Uploading to MySQL problem
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
__________________
A man is just a man.
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
10-26-2003, 10:30 PM
|
Sarnak
|
|
Join Date: Oct 2003
Posts: 32
|
|
same here. is this a new feature to block submitters submitting items to databases other than yours? :lol: ![Confused](http://www.eqemulator.net/forums/images/smilies/icon_confused.gif) :
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
10-27-2003, 12:34 AM
|
Fire Beetle
|
|
Join Date: May 2003
Posts: 15
|
|
Sigh
Oh No I sure hope not! ![Shocked](http://www.eqemulator.net/forums/images/smilies/icon_eek.gif)
__________________
A man is just a man.
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
10-27-2003, 03:10 AM
|
Dragon
|
|
Join Date: May 2003
Location: Seattle, WA
Posts: 609
|
|
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
|
|
![](/forums/images/Darkness/misc/a4.gif) |
|
![](/forums/images/Darkness/misc/a6.gif) |
![Old](/forums/images/Darkness/statusicon/post_old.gif)
10-27-2003, 05:06 AM
|
Sarnak
|
|
Join Date: Oct 2003
Posts: 32
|
|
Re: Uploading to MySQL problem
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.
|
![](/forums/images/Darkness/misc/a1.gif) |
|
![](/forums/images/Darkness/misc/a3.gif) |
![Old](/forums/images/Darkness/statusicon/post_old.gif)
10-27-2003, 07:13 AM
|
Dragon
|
|
Join Date: May 2003
Location: Seattle, WA
Posts: 609
|
|
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?
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
10-27-2003, 10:59 AM
|
Sarnak
|
|
Join Date: Oct 2003
Posts: 32
|
|
Merth,
I was talking about column_names and the items@items.eqemulator.net's db password.
![Wink](http://www.eqemulator.net/forums/images/smilies/icon_wink.gif) :twisted:
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
10-27-2003, 11:53 AM
|
Fire Beetle
|
|
Join Date: May 2003
Posts: 15
|
|
Column Names
Thank you for the input but it appears I need the coumn name used to create the table.
__________________
A man is just a man.
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
10-27-2003, 12:26 PM
|
Fire Beetle
|
|
Join Date: May 2003
Posts: 15
|
|
Now this
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.
__________________
A man is just a man.
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
10-27-2003, 01:03 PM
|
Senior Member Former EQEmu Developer Current EQ2Emu Lead Developer
|
|
Join Date: Dec 2002
Posts: 1,065
|
|
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.
__________________
Lethal Encounter
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
10-27-2003, 01:55 PM
|
Fire Beetle
|
|
Join Date: May 2003
Posts: 15
|
|
Because...
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. ![Confused](http://www.eqemulator.net/forums/images/smilies/icon_confused.gif)
__________________
A man is just a man.
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
10-27-2003, 02:10 PM
|
Senior Member Former EQEmu Developer Current EQ2Emu Lead Developer
|
|
Join Date: Dec 2002
Posts: 1,065
|
|
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.
__________________
Lethal Encounter
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
10-27-2003, 03:35 PM
|
Fire Beetle
|
|
Join Date: May 2003
Posts: 15
|
|
Oh?
Public item db? that works with the latest cvs? I guess its under my nose and I am blind? Where is it?
__________________
A man is just a man.
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
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.
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
10-27-2003, 03:42 PM
|
Fire Beetle
|
|
Join Date: May 2003
Posts: 15
|
|
OK cool
So this DB work with cvs 5?
__________________
A man is just a man.
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 02:30 AM.
|
|
![](/forums/images/Darkness/misc/s1.jpg) |
|
![](/forums/images/Darkness/misc/s1-1.jpg) |
|
|
|
![](/forums/images/Darkness/misc/z1.jpg) |
|
![](/forums/images/Darkness/misc/z1-1.jpg) |
|
![](/forums/images/Darkness/misc/side3.jpg) |