Item system

[Psychotic_Carp]

Apparently setting all the modifiers to 0 will cause the above

Inventar needs to be changed

[XChrisX]

Well this is not really a fault of the system, but a fault of the person which creates the buff...

Buffs are quite complex things and not all combinations will lead to a fully functioning code.

Setting modifiers to zero is done only once in the whole core (for the 4th dark arts specialty use) and should therefore only be applied to very mighty items.

I cannot think of a system, which would check, if a buff ist working...

If you do this in the mount editor, your system will break as well...

[SpRouCyT]

Code:

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unclosed quote @ 1692
STR: `
SQL: --
-- Data for table `item`
--

INSERT INTO `item` (`class`, `name`, `description`, `gold`, `gems`, `weight`, `droppable`, `level`, `dragonkills`, `buffid`, `link`, `hide`, `customvalue`, `activationhook`, `findchance`, `loosechance`, `dkloosechance`) VALUES
('Loot', 'Rusty Knife', 'A small, rusty knife which appears to still carry some stains of dried blood.', 10, 0, 0, 1, 0, 0, 0, '', 0, '', '', 100, 25, 99),
('Loot', 'Gauntlet', 'A light, damaged gauntlet.`n\r\nIt seems it belonged to a larger piece of armor before.', 230, 0, 0, 1, 3, 2, 0, '', 0, '', '', 80, 80, 100),
('Loot', 'Small Leatherbag', 'A small bag made from black leather.`n\r\nSome coins still ring in it.', 50, 0, 0, 1, 1, 0, 0, '', 0, '', '', 75, 50, 99),
('Loot', 'Necklace', 'A seemingly worthless necklace with strange symbols engraved on its front.', 20, 0, 0, 1, 1, 0, 0, '', 0, '', '', 100, 80, 99),
('Loot', 'Quiver', 'An old quiver with a good dozen of mostly broken arrows.`n\r\nSuch a fine piece of work so shattered...', 380, 0, 0, 1, 1, 0, 0, '', 0, '', '', 100, 100, 100),
('Loot', 'Stone', 'Small, round, grey, heavy...`n\r\nNot really interesting.', 3, 0, 0, 1, 1, 0, 0, '', 0, '', '0', 100, 100, 100),
('Loot', 'Potshard', 'A small potshard. YOu recognize some mysterious runes painted on it.', 80, 0, 0, 1, 1, 0, 0, '', 0, '', '', 100, 100, 100),
('Loot', 'Gammon', 'Approximately one pound of gammon, wrapped in fatty paper. Perhaps not the best, but it'll keep you from starving.', 140, 0, 0, 1, 1, 0, 0, '', 0, '', '', 100, 100, 100),
('Loot', 'Runestone', 'A very heavy and almost totally black stone with some notches at one side. Perfectly oval and exactly the size to carry it in one hand.`n\r\nThe perfect circle gracing its front seems to shine in light purple.', 800, 3, 250, 0, 10, 10, 0, '', 0, '', '0', 35, 90, 100);
       

SQL query:

-- -- Data for table `item` -- INSERT INTO `item` (`class`, `name`, `description`, `gold`, `gems`, `weight`, `droppable`, `level`, `dragonkills`, `buffid`, `link`, `hide`, `customvalue`, `activationhook`, `findchance`, `loosechance`, `dkloosechance`) VALUES ('Loot', 'Rusty Knife', 'A small, rusty knife which appears to still carry some stains of dried blood.', 10, 0, 0, 1, 0, 0, 0, '', 0, '', '', 100, 25, 99), ('Loot', 'Gauntlet', 'A light, damaged gauntlet.`n\r\nIt seems it belonged to a larger piece of armor before.', 230, 0, 0, 1, 3, 2, 0, '', 0, '', '', 80, 80, 100), ('Loot', 'Small Leatherbag', 'A small bag made from black leather.`n\r\nSome coins still ring in it.', 50, 0, 0, 1, 1, 0, 0, '', 0, '', '', 75, 50, 99), ('Loot', 'Necklace', 'A seemingly worthless necklace with strange symbols engraved on its front.', 20, 0, 0, 1, 1, 0, 0, '', 0, '', '', 100, 80, 99), ('Loot', 'Quiver', 'An old quiver with a good dozen of mostly broken arrows.`n\r\nSuch a fine piece of work so shattered...', 380, 0, 0, 1, 1, 0, 0, '', 0, '', '', 100, 100, 100), ('Loot', 'Stone', 'Small, round, grey, heavy...`n\r\nNot really interesting.', 3, 0, 0, 1, 1, 0, 0, '', 0, '', '0', 100, 100, 100), ('Loot', 'Potshard', 'A small potshard. YOu recognize some mysterious runes painted on it.', 80, 0, 0, 1, 1, 0, 0, '', 0, '', '', 100, 100, 100), ('Loot', 'Gammon', 'Approximately one pound of gammon, wrapped in fatty paper. Perhaps not the best, but it'll keep you from starving.', 140, 0, 0, 1, 1, 0, 0, '', 0, '', '', 100, 100, 100), ('Loot', 'Runestone', 'A very heavy and almost totally black stone with some notches at one side. Perfectly oval and exactly the size to carry it in one hand.`n\r\nThe perfect circle gracing its front seems to shine in light purple.', 800, 3, 250, 0, 10, 10, 0, '', 0, '', '0', 35, 90, 100);

MySQL said: Documentation
#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'll keep you from starving.', 140, 0, 0, 1, 1, 0, 0, '', 0, '',
[ Back ]

i install, but when i try to run sql, ERROR

here i have a table intem and items

help  me

[Sichae]

Chris, you need your addslashes in there. Otherwise, the inserting of the field ends prematurely.

[SpRouCyT]

Chris, you need your addslashes in there. Otherwise, the inserting of the field ends prematurely.

sory but i didn´t undertood

[XChrisX]

Chris, you need your addslashes in there. Otherwise, the inserting of the field ends prematurely.

Yes, well... ***** englisch with it's apostrophees... *waaah* There! Again! *g*

I'll check the SQL file...

[SpRouCyT]

Yes, well... ***** englisch with it's apostrophees... *waaah* There! Again! *g*

I'll check the SQL file...

to install the nodule, i need to rum SQL?  i.m wanting, tanks a lot, its a good mod

[SpRouCyT]

...

i need this moduel, help please

[XChrisX]

Updated the System... same Link.

Fixed some bugs and (THANKS to DaveS) some spelling mistakes!

One known bug: If you create an invalid buff, the fights will hang up in an endless loop.

Accidently removed the items.sql for some basic items...  

If anybody has this (broken) file, please send it to me!
Thanks!

[SpRouCyT]

do you want the OLD file??? i have

how can i send to you?

ad my msn and i send to you

sproucyt@hotmail.com

tanks for fixed

[SpRouCyT]

is it?

[Brother Dave Thompson]

One known bug: If you create an invalid buff, the fights will hang up in an endless loop.

Can you give us an example of a valid buff? All I want is a simple healing item, and I can't get one to work.

[Eliwood]

INSERT INTO `itembuffs` VALUES (1, 'Healing Level 1', 'Healing', 1, 0, 1, 1, 1, 1, 1, 1, 0, 0, 25, 1, 0, 0, 0, 0, '`#You regenerate!', '', '', '', 0, 0, 0);

(Its healing 25 points)

[XChrisX]

So, it's been a long while since the last update...

And since then a lot has changed.
It's not the appearance of the module... But the module has been streamlined to work faster and use the data caching feature.
So it should work faster - especially on larger servers.
Also some minor bugs have been fixed.

Re-Download at http://dragonprime.net/users/XChrisX/itemsystem.zip

[Dannic]

I've probably installed this incorrectly somehow.  But I am getting this.

Code:

SELECT item.itemid AS itemid, item.name AS name, COUNT(inventory.itemid) AS quantity, inventory.sellvaluegold AS sellvaluegold, inventory.sellvaluegems AS sellvaluegems
               FROM inventory
               INNER JOIN item ON item.itemid = inventory.itemid
               WHERE inventory.userid = 1
                  AND item.class = 'Loot'
                  AND item.sellable <> 0
               GROUP BY item.itemid
               ORDER BY
                  item.class ASC,
                  item.name ASC

Unknown column 'inventory.sellvaluegold' in 'field list'
Call Stack:
1: db_query("SELECT item.itemid AS ite...") called from /logd/lib/itemhandler.php on line 430
2: shopnav("runmodule.php?module=basi...", "Loot", true, "1", true) called from /logd/modules/basicitemshop.php on line 112
3: basicitemshop_run() called from /logd/runmodule.php on line 32