http://eqitems.13th-floor.org/phpBB2/ eqitems forum kyle@13th-floor.org kyle@13th-floor.org Fri, 21 Nov 2008 06:27:01 GMT 120 http://eqitems.13th-floor.org/phpBB2/viewtopic.php?p=1360#1360 ksmith
Posted: Mon Nov 03, 2008 4:12 pm (GMT 0)
Topic Replies: 1

Tome of Foray Rk. II

MAGIC ITEM LORE ITEM NO TRADE Level Needed: Skill: Hand To Hand Mana Cost: 0 Combat Effect: Assaults your target with a flurry of savage attacks. WT: 0.1 Size: SMALL Class: BST Race: ALL

Done.
]]> ksmith ksmith Mon, 03 Nov 2008 16:12:27 GMT http://eqitems.13th-floor.org/phpBB2/viewtopic.php?p=1359#1359 ksmith
Posted: Mon Nov 03, 2008 4:07 pm (GMT 0)
Topic Replies: 4

Nilwean wrote:

While you're at it, the most recent set of icons would be nice.

Edit: nevermind, icons are updated.
]]> ksmith ksmith Mon, 03 Nov 2008 16:07:00 GMT http://eqitems.13th-floor.org/phpBB2/viewtopic.php?p=1358#1358 Nilwean
Posted: Sat Nov 01, 2008 11:54 pm (GMT 0)
Topic Replies: 4

While you're at it, the most recent set of icons would be nice.
]]> Nilwean Nilwean Sat, 01 Nov 2008 23:54:31 GMT http://eqitems.13th-floor.org/phpBB2/viewtopic.php?p=1357#1357 KyrosKrane
Posted: Wed Oct 29, 2008 3:16 am (GMT 0)
Topic Replies: 4

Speaking of common.inc:

$aug_restrictions array, around line 514:

14 => "1h Slash, 1h Blunt, or Hand to Hand Only"

http://eqitems.13th-floor.org/item.php?id=48766 has this restriction in-game
]]> KyrosKrane KyrosKrane Wed, 29 Oct 2008 03:16:00 GMT http://eqitems.13th-floor.org/phpBB2/viewtopic.php?p=1356#1356 Skurge
Subject: Spells and Tomes don't show class(es)<br /> Posted: Mon Oct 27, 2008 12:01 pm (GMT 0)
Topic Replies: 1

http://eqitems.13th-floor.org/item.php?id=117921

http://eqitems.13th-floor.org/item.php?id=118888
]]> Skurge Skurge Mon, 27 Oct 2008 12:01:49 GMT http://eqitems.13th-floor.org/phpBB2/viewtopic.php?p=1355#1355 ksmith
Posted: Mon Oct 27, 2008 1:13 am (GMT 0)
Topic Replies: 4

Updated
]]> ksmith ksmith Mon, 27 Oct 2008 01:13:34 GMT http://eqitems.13th-floor.org/phpBB2/viewtopic.php?p=1354#1354 KyrosKrane
Subject: Update to +damage<br /> Posted: Sun Oct 26, 2008 11:43 pm (GMT 0)
Topic Replies: 4

In common.inc, the $element_type array needs updating:

global $element_type;
$element_type = array(
1 => "Magic",
2 => "Fire",
3 => "Cold",
4 => "Poison",
5 => "Disease",
6 => "Chromatic",
7 => "Prismatic",
);


http://eqitems.13th-floor.org/item.php?id=48773 shows chromatic damage.

http://eqitems.13th-floor.org/item.php?id=48782 shows prismatic damage.

I can't find any items that have corruption damage.
]]> KyrosKrane KyrosKrane Sun, 26 Oct 2008 23:43:46 GMT http://eqitems.13th-floor.org/phpBB2/viewtopic.php?p=1353#1353 KyrosKrane
Posted: Sat Oct 25, 2008 2:20 pm (GMT 0)
Topic Replies: 7

Heh, I guess I should have said they used to give me problems. =) A couple of years back, I found another post on here that gave some Perl code to handle them, and I was able to adapt that to PHP. If I need to import the DB to a spreadsheet, I usually just go in and manually delete those three items (along with a few thousand others so it fits in Excel's 65K record limit); they're almost never relevant to what I need.
]]> KyrosKrane KyrosKrane Sat, 25 Oct 2008 14:20:31 GMT http://eqitems.13th-floor.org/phpBB2/viewtopic.php?p=1352#1352 ksmith
Posted: Fri Oct 24, 2008 5:43 am (GMT 0)
Topic Replies: 7

The dumps (and EQ back when it sent the serialized item data as text) use '\' to escape special characters just like C and most other programming languages do.

In loaditems.pl the official import script for the nightly database dumps, I specifically have it split on '|' characters that are not immediately preceded by a '\' character. This isn't entirely ideal since it would miss the case of an item name ending with '\\' that is, a literal '\' which is being escaped. However it was simple to implement in perl and it gets the job done.
]]> ksmith ksmith Fri, 24 Oct 2008 05:43:06 GMT http://eqitems.13th-floor.org/phpBB2/viewtopic.php?p=1351#1351 KyrosKrane
Posted: Thu Oct 23, 2008 3:38 pm (GMT 0)
Topic Replies: 7

Those three items are a pain; I know they give me headaches every time I try to import the DB into a spreadsheet or my own database. The good news is that there are already a few solutions for how to handle them programmatically. Sounds like you have to update your import code.

Search the forums here on the item name for some ideas.
]]> KyrosKrane KyrosKrane Thu, 23 Oct 2008 15:38:17 GMT http://eqitems.13th-floor.org/phpBB2/viewtopic.php?p=1350#1350 KyrosKrane
Posted: Thu Oct 23, 2008 3:35 pm (GMT 0)
Topic Replies: 4

You're correct; that's actually a snippet of code I cobbled together from a couple of other, much larger scripts that I use. The earlier parts of those scripts validate recommended and required levels. To be complete, I guess you'd have to insert a check before PreRound to cap the CharLevel at RecLevel.

I'm not sure what you mean about setting stats to zero. Do you mean that if a player dies and delevels, yet is still wearing an item with a required level above his current level, the item will have zero stats? That would be beyond the scope of just calculating the impact of the recommended level; that gets into how you handle the required level.
]]> KyrosKrane KyrosKrane Thu, 23 Oct 2008 15:35:29 GMT http://eqitems.13th-floor.org/phpBB2/viewtopic.php?p=1349#1349 Yoda
Posted: Thu Oct 23, 2008 10:44 am (GMT 0)
Topic Replies: 4

you should change your formula to take into account two things:
* the character_level / rocommanded_level ratio should never get above 1
* the values should be set to zero (or one, don't remember) when the requiered_level isn't reached (can happen when death-develling).
]]> Yoda Yoda Thu, 23 Oct 2008 10:44:01 GMT http://eqitems.13th-floor.org/phpBB2/viewtopic.php?p=1348#1348 Yoda
Subject: Re: database problem<br /> Posted: Thu Oct 23, 2008 10:36 am (GMT 0)
Topic Replies: 7

fyredawn wrote:

[...] iksar left hand=\ iksar left hand =\ iksar right hand=\ [...]

the EQitems database uses | as separator, and there is three items that uses this character in their name. those three items are those three you listed above. this behaviour creates a change of the number of colonns in the structure of the database that makes it unuseable past those three lines.

you have to edit the database everytime you download it to either alter those three names or to remove those three lines.
]]> Yoda Yoda Thu, 23 Oct 2008 10:36:02 GMT http://eqitems.13th-floor.org/phpBB2/viewtopic.php?p=1347#1347 KyrosKrane
Posted: Tue Oct 21, 2008 11:24 am (GMT 0)
Topic Replies: 4

It's actually a bit more complicated, due to at least two issues I've found.

1) If a stat would come out to x.5 (like 19.5 or 217.5), EQ rounds *down*, not up. For any other value, it rounds normally.

2) Recommended stats always have a minimum value of 1.

Here's some Javascript that I use.

Code:

function RecLevelRound( num, CharLevel, RecLevel ) {    PreRound = num * CharLevel / RecLevel;    if (PreRound - Math.floor(PreRound) == 0.5)       PreMax = Math.floor(PreRound);    else       PreMax = Math.round(PreRound);    return Math.max(PreMax, 1); }

I haven't tested this code with negative numbers, though. I'm not sure how EQ rounds those.
]]> KyrosKrane KyrosKrane Tue, 21 Oct 2008 11:24:54 GMT http://eqitems.13th-floor.org/phpBB2/viewtopic.php?p=1346#1346 ksmith
Posted: Mon Oct 20, 2008 6:05 pm (GMT 0)
Topic Replies: 7

The database is mostly used by EQDKP and EQTraders. It's purpose is to be useful to others. I don't support or care what anyone does with the database dumps.

We do not talk about MQ here because it's against the EQ ToS.
]]> ksmith ksmith Mon, 20 Oct 2008 18:05:10 GMT