EQEmulator Home
>
EQEmulator Forums
>
Search Forums
Search Results
User Name
Remember Me?
Password
Home
Forums
Register
Members List
Today's Posts
Search
Search Forums
Show Threads
Show Posts
Advanced Search
Go to Page...
Showing results 1 to 22 of 22
Search took
0.00
seconds.
Search:
Posts Made By:
ksmith
Forum:
Archive::News
05-27-2004, 06:02 AM
Replies:
108
US Draft
Views:
25,852
Posted By
ksmith
Here is the rationale behind HR 163: ...
Here is the rationale behind HR 163:
[quote]Congressman Pete Stark January 8, 2003 (http://www.house.gov/stark/documents/108th/univdraftstate.html)
It is my understanding that out of the 435...
Forum:
Support::Packetcollector
03-08-2004, 05:05 PM
Replies:
6
New item fields on test
Views:
5,498
Posted By
ksmith
The last two fields are haste and damage shield I...
The last two fields are haste and damage shield I believe... I haven't gotten any items from test with haste or an innate DS effect, so I can't say for certain.
Forum:
Support::Packetcollector
03-06-2004, 01:48 PM
Replies:
6
New item fields on test
Views:
5,498
Posted By
ksmith
New item fields on test
5 fields have been added to the end of the item data:
attack, regen, manaregen, unknown, unknown
Error: item 68802 has 116 fields
Aegis of Blackscales
MAGIC ITEM LORE ITEM NO DROP
Slot:...
Forum:
Archive::Packetcollector
03-04-2004, 07:51 AM
Replies:
13
The fields in dumpeditems.sql and what they mean
Views:
7,244
Posted By
ksmith
DoT Shielding is the field after endur. So...
DoT Shielding is the field after endur. So if/when unknown116 shows up, that's the one.
Forum:
Archive::Packetcollector
03-04-2004, 02:51 AM
Replies:
13
The fields in dumpeditems.sql and what they mean
Views:
7,244
Posted By
ksmith
I call it augrestrict $aug_restrictions =...
I call it augrestrict
$aug_restrictions = array(
1 => "Armor Only",
2 => "Weapons Only",
3 => "1H Weapons Only",
4 => "2H Weapons Only",
5 => "1H Slash...
Forum:
Archive::Packetcollector
01-23-2004, 10:40 AM
Replies:
1
unknown113
Views:
2,991
Posted By
ksmith
unknown113
I believe it's related to the tribute system that's going in with GoD. It seems to be roughly based on the item's price field.
Note: this shows it as unk106 because that's what it is in my item...
Forum:
Archive::Packetcollector
11-21-2003, 09:00 AM
Replies:
13
The fields in dumpeditems.sql and what they mean
Views:
7,244
Posted By
ksmith
# recommended skill if ($recskill >...
# recommended skill
if ($recskill > 0)
{
$skillname = ($itemtype == "Armor") ? "Defense" : $itemtype;
print "Recommended skill of "....
Forum:
Archive::Packetcollector
11-19-2003, 03:38 AM
Replies:
3
fields unknown97 & unknown98
Views:
3,095
Posted By
ksmith
I PMd LE about the LDoN fields 9/26. ...
I PMd LE about the LDoN fields 9/26.
unknown097 = ldon theme
unknown098 = ldon price
unknown099 = ldon sold
Additionally:
unknown076 = extradmgskill
Forum:
Archive::Packetcollector
10-21-2003, 04:57 AM
Replies:
14
Bug hunt
Views:
4,747
Posted By
ksmith
As pointed out...
As pointed out (http://www.everquestserver.com/forums/viewtopic.php?t=10694#54942) by ric0h, elemdmgtype and elemdmgamt are reversed in the database.
Forum:
Archive::Packetcollector
10-21-2003, 04:54 AM
Replies:
18
New and updated items appearing in DB: is this a good sign?
Views:
5,530
Posted By
ksmith
Sure looks like it . See...
Sure looks like it . See http://www.everquestserver.com/item.php?id=NzM4NjAuOTIwMTU1NTc= for an example. The real item is
Sparkling Shortsword
MAGIC ITEM LORE ITEM NO DROP
Slot: PRIMARY...
Forum:
Archive::Packetcollector
10-21-2003, 04:50 AM
Replies:
18
New and updated items appearing in DB: is this a good sign?
Views:
5,530
Posted By
ksmith
Look at...
Look at http://www.everquestserver.com/item.php?id=MTAzMzE5Ljc1MTE2ODk= the updated date is 2003-09-12 , this is from before the data structure change that added those four new flags. Now look at...
Forum:
Archive::Packetcollector
10-21-2003, 01:11 AM
Replies:
18
New and updated items appearing in DB: is this a good sign?
Views:
5,530
Posted By
ksmith
Elemental damage is in there. That's what ...
Elemental damage is in there. That's what elemdmgamt and elemdmgtype are.
Also: stackable = (spellid == -1 && charges == 1)
Forum:
Archive::Database/World Building
10-17-2003, 04:03 AM
Replies:
20
item db
Views:
6,981
Posted By
ksmith
If that wasn't directed at my example, ignore...
If that wasn't directed at my example, ignore this.
mysql> SELECT id,classes,name FROM items WHERE classes & 128 LIMIT 10;
+-------+---------+----------------------------+
| id | classes |...
Forum:
Archive::Database/World Building
10-17-2003, 02:26 AM
Replies:
20
item db
Views:
6,981
Posted By
ksmith
Don't make things more complicated than they need...
Don't make things more complicated than they need to be. MySQL lets you use '&' in WHERE statements.
SELECT id,name FROM items WHERE classes & 1 AND itemtype = 10;
To save you time, here is a...
Forum:
Archive::Packetcollector
10-10-2003, 06:30 AM
Replies:
14
Bug hunt
Views:
4,747
Posted By
ksmith
With the 10/09 patch, 4 new fields have been...
With the 10/09 patch, 4 new fields have been added at the end of the item data. The lore text field no longer begins with special characters to indicate lore, artifact, etc. The first of the four...
Forum:
Archive::Packetcollector
10-01-2003, 04:52 AM
Replies:
14
Bug hunt
Views:
4,747
Posted By
ksmith
The value of the field is the item id of the...
The value of the field is the item id of the first item to use that charmfile. It is a static value.
Forum:
Archive::Packetcollector
10-01-2003, 04:02 AM
Replies:
14
Bug hunt
Views:
4,747
Posted By
ksmith
Here's a listing of all the items I have where...
Here's a listing of all the items I have where that field is non-zero:
UNK ID Name
===== ===== ==================
35001 35008 - Intricate Wooden Figurine
40346 40346 -...
Forum:
Archive::Packetcollector
10-01-2003, 02:55 AM
Replies:
14
Bug hunt
Views:
4,747
Posted By
ksmith
Bug hunt
Compare Planar Traveler's Manual (lucy) (http://lucy.fnord.net/itemraw.html?id=28745) and Planar Traveler's Manual (eqemu) (http://www.eqemulator.net/item.php?id=OTI0MzQuNjc5MzQ0ODU=)
There is a...
Forum:
Archive::Packetcollector
10-01-2003, 02:35 AM
Replies:
7
Collector Ran Fine. Question on structure.
Views:
3,475
Posted By
ksmith
Curious. I'll have to pick one up and take a...
Curious. I'll have to pick one up and take a look at it.
Forum:
Archive::Packetcollector
10-01-2003, 01:57 AM
Replies:
7
Collector Ran Fine. Question on structure.
Views:
3,475
Posted By
ksmith
I'm curious as to which items had non-numeric...
I'm curious as to which items had non-numeric data in combateffects.
Forum:
Archive::Packetcollector
10-01-2003, 01:41 AM
Replies:
7
Collector Ran Fine. Question on structure.
Views:
3,475
Posted By
ksmith
combateffects should be an int. See item 5760 -...
combateffects should be an int. See item 5760 - Earring of Xaoth Kor (http://www.eqemulator.net/item.php?id=MTg1MjIuMzA4MzMyOA==)
Forum:
Archive::Packetcollector
10-01-2003, 01:36 AM
Replies:
5
Any Plan to sniff Augments?
Views:
3,315
Posted By
ksmith
Itemtype 54 are augments, it would be nice to see...
Itemtype 54 are augments, it would be nice to see that added to the dropdown list.
Showing results 1 to 22 of 22
Forum Jump
User Control Panel
Private Messages
Subscriptions
Who's Online
Search Forums
Forums Home
General
General::General Discussion
General::Server Discussion
General::News
General::News::Polls
Support
Support::General Support
Idiot Posters
Spell Support
Support::Windows Servers
Support::Linux Servers
Support::Packetcollector
Support::MiniLogin
Quests
Quests::Q&A
Quests::Custom
Quests::Completed
Quests::Submissions
Quests::Plugins & Mods
Quests::need work
Quests::LUA
Development
Development::Development
Development::Bots
Development: Custom Code
Development::Server Code Submissions
Development::Feature Requests
Development::Bugs
Development::Bug Reports
Development::Database/World Building
Development::Tools
Development::GeorgeS's Tools
EQEmu Operations Center
KayotRO
Old Eq
OpenZone
OpenZone:: Q&A
Simple Client
OpenZone::Tutorials
OpenZone::Bug Reporting
Misc
Misc::Off Topic
Misc::Screenshots
Archives
Archive::Support
Archive::General Support
Archive::Windows Servers
Archive::Linux Servers
Archive::Tutorials/Howto's
Tutorials--Outdated Use the Wiki
Tutorial ALL NEW PEOPLE READ THIS
Tutorials::Discussion
Tutorials::Requests
Tutorials::Submissions
Tutorials::Needs work
Archive::Packetcollector
Archive::Development
Archive::Development
Archive::Bugs
Archive::Tools
Archive::Quests
Archive::Database/World Building
EQ2 Development
Archive::Misc
Archive::Off Topic
Archive::Screenshots
OpenEQ
OpenEQ::General Discussion
OpenEQ::Support
OpenEQ::Development
OpenEQ::Bug reporting
OpenEQ::Plugins
All times are GMT -4. The time now is
01:52 AM
.
-- Default Style
---- EQEmulator
EQEmulator
-
Archive
-
Top
Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a
Creative Commons License
.
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by
Bluepearl Design
and
vBulletin Templates
- Ver3.3