SELECT items.id AS item_id, name_english AS name, type, subtype, price_buy, weight/10 AS weight, defense, `range`, slots, refineable, cost, cp_itemshop.id AS shop_item_id, IFNULL(price_sell, FLOOR(price_buy/2)) AS price_sell, view, attack, location_head_low, location_right_hand, location_garment, location_right_accessory, location_armor, location_left_hand, location_shoes, location_left_accessory, location_head_top, location_head_mid, location_costume_head_top, location_costume_head_mid, location_costume_head_low, location_costume_garment, location_ammo, location_shadow_armor, location_shadow_weapon, location_shadow_shield, location_shadow_shoes, location_shadow_right_accessory, location_shadow_left_accessory, origin_table FROM osro.items LEFT OUTER JOIN osro.cp_itemshop ON cp_itemshop.nameid = items.id WHERE 1=1 GROUP BY items.id, cp_itemshop.id
Всего обнаружено 6173 записей на 309 странице. Отображение результата 101-120.
| Item ID ▲ | Name | Type | SubType | Equip Locations | NPC Buy | NPC Sell | Weight | Attack ▲ | Defense ▲ | Range | Slots | Refineable | For Sale | Custom | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 606 |  |
Aloevera | Расходники (свитки) | None | None | 1,500 | 750 | 10 | 0 | 0 | 0 | 0 | No | No | No |
| 607 |  |
Yggdrasil Berry | Лечение | None | None | 5,000 | 2,500 | 30 | 0 | 0 | 0 | 0 | No | No | No |
| 608 |  |
Yggdrasil Seed | Лечение | None | None | 5,000 | 2,500 | 30 | 0 | 0 | 0 | 0 | No | No | No |
| 609 |  |
Amulet | Используемые (ящик стрел) | None | None | 100 | 50 | 10 | 0 | 0 | 0 | 0 | No | No | No |
| 610 |  |
Yggdrasil Leaf | Расходники (свитки) | None | None | 4,000 | 2,000 | 10 | 0 | 0 | 0 | 0 | No | No | No |
| 611 |  |
Magnifier | Расходники (свитки) | None | None | 40 | 20 | 5 | 0 | 0 | 0 | 0 | No | No | No |
| 612 |  |
Mini Furnace | Используемые (ящик стрел) | None | None | 150 | 75 | 20 | 0 | 0 | 0 | 0 | No | No | No |
| 613 |  |
Iron Hammer | Используемые (ящик стрел) | None | None | 1,000 | 500 | 20 | 0 | 0 | 0 | 0 | No | No | No |
| 614 |  |
Golden Hammer | Используемые (ящик стрел) | None | None | 3,000 | 1,500 | 30 | 0 | 0 | 0 | 0 | No | No | No |
| 615 |  |
Oridecon Hammer | Используемые (ящик стрел) | None | None | 5,000 | 2,500 | 40 | 0 | 0 | 0 | 0 | No | No | No |
| 616 |  |
Old Card Album | Используемые (ящик стрел) | None | None | 10,000 | 5,000 | 5 | 0 | 0 | 0 | 0 | No | No | No |
| 617 |  |
Old Purple Box | Используемые (ящик стрел) | None | None | 10,000 | 5,000 | 20 | 0 | 0 | 0 | 0 | No | No | No |
| 618 |  |
Worn Out Scroll | Используемые (ящик стрел) | None | None | 50 | 25 | 2 | 0 | 0 | 0 | 0 | No | No | No |
| 619 |  |
Unripe Apple | Используемые (ящик стрел) | None | None | 1,000 | 500 | 5 | 0 | 0 | 0 | 0 | No | No | No |
| 620 |  |
Orange Juice | Используемые (ящик стрел) | None | None | 1,500 | 750 | 5 | 0 | 0 | 0 | 0 | No | No | No |
| 621 |  |
Bitter Herb | Используемые (ящик стрел) | None | None | 20 | 10 | 5 | 0 | 0 | 0 | 0 | No | No | No |
| 622 |  |
Rainbow Carrot | Используемые (ящик стрел) | None | None | 2,500 | 1,250 | 5 | 0 | 0 | 0 | 0 | No | No | No |
| 623 |  |
Earthworm the Dude | Используемые (ящик стрел) | None | None | 4,000 | 2,000 | 5 | 0 | 0 | 0 | 0 | No | No | No |
| 624 |  |
Rotten Fish | Используемые (ящик стрел) | None | None | 2,500 | 1,250 | 5 | 0 | 0 | 0 | 0 | No | No | No |
| 625 |  |
Rusty Iron | Используемые (ящик стрел) | None | None | 100 | 50 | 5 | 0 | 0 | 0 | 0 | No | No | No |
Главная
Соцсети
Скачать
Личный кабинет
База знаний
Сервер
