Skip to content

GmShop Freya

Featured Replies

I have some wrong in file spawnlist ! Help me plz ????

awsome! thanks for share! keep up!

  • 3 weeks later...

i have this error [Err] 1054 - Unknown column 'armor' in 'field list'

[Err] INSERT INTO npc

  (`id`, `idTemplate`, `name`, `serverSideName`, `title`, `serverSideTitle`, `class`, `collision_radius`, `collision_height`, `level`, `sex`, `type`, `attackrange`, `hp`, `mp`, `hpreg`, `mpreg`, `str`, `con`, `dex`, `int`, `wit`, `men`, `exp`, `sp`, `patk`, `pdef`, `matk`, `mdef`, `atkspd`, `aggro`, `matkspd`, `rhand`, `lhand`, `armor`, `enchant`, `walkspd`, `runspd`, `isUndead`, `dropHerbGroup`, `basestats`)

VALUES

  (10002, 10, 'GM Shop', 1, 'GM Shop', 1, 'LineageMonster.wererat_01te', 14.00, 25.00, 35, 'male', 'L2Merchant', 40, 773, 366, 7.11, 1.84, 40, 43, 30, 21, 20, 20, 2470, 145, 159, 170, 111, 113, 230, 500, 333, 0, 0, 0, 0, 80, 120, 0, 1, 1);

[Msg] Finished - Unsuccessfully

--------------------------------------------------

can u share it somewhere else cuz i cant download it from that site

when i try to install it from console in navicat it said me Unknown column 'armor' in 'field list'  what must i change in order to work perfectly?

omg the shop is the best i have ever seen i will try it now ty man!!!!!

great npc,hope it has many items like gm shop :)

wow good work :) really nice and useful

i have this error [Err] 1054 - Unknown column 'armor' in 'field list'

[Err] INSERT INTO npc

  (`id`, `idTemplate`, `name`, `serverSideName`, `title`, `serverSideTitle`, `class`, `collision_radius`, `collision_height`, `level`, `sex`, `type`, `attackrange`, `hp`, `mp`, `hpreg`, `mpreg`, `str`, `con`, `dex`, `int`, `wit`, `men`, `exp`, `sp`, `patk`, `pdef`, `matk`, `mdef`, `atkspd`, `aggro`, `matkspd`, `rhand`, `lhand`, `armor`, `enchant`, `walkspd`, `runspd`, `isUndead`, `dropHerbGroup`, `basestats`)

VALUES

  (10002, 10, 'GM Shop', 1, 'GM Shop', 1, 'LineageMonster.wererat_01te', 14.00, 25.00, 35, 'male', 'L2Merchant', 40, 773, 366, 7.11, 1.84, 40, 43, 30, 21, 20, 20, 2470, 145, 159, 170, 111, 113, 230, 500, 333, 0, 0, 0, 0, 80, 120, 0, 1, 1);

[Msg] Finished - Unsuccessfully

--------------------------------------------------

 

same problem sql problem insert armor .

awsome share :) gj ty :)

Amazing GMSHOP thanks for share mate.. good job

Hello.

I trying that gm shop for my own prizes for items. When i done i can't buy some items , looks on screens i marked on red what is wrong , and after buy items only 3 are in inv. Its only 1 ex ,coz i have more the same problems with other items.

shot00000fc.jpg

here is my xml file:

<?xml version='1.0' encoding='utf-8'?>

<!-- S-84 Armor -->
<!-- © 2010 by mathuza -->
<!-- Opicional Set PVP -->

<list maintainEnchantment="true">

  <!-- Vesper Breastplate -->
  <item id="1">
    <ingredient id="6673" count="30"/>
    <production id="13432" count="1"/>
    <production id="13438" count="1"/>
    <production id="13137" count="1"/>
    <production id="13439" count="1"/>
    <production id="13440" count="1"/>
  </item>

  <!-- Vesper Breastplate {PvP} -->
  <!-- <item id="2">
    <ingredient id="307" count="1300000000"/>
    <ingredient id="34830" count="300"/>
    <production id="143020" count="1"/>
    <production id="13438" count="1"/>
    <production id="13137" count="1"/>
    <production id="13439" count="1"/>
    <production id="13440" count="1"/>
  </item> -->

  <!-- Vesper Leather Breastplate -->
  <item id="3">
    <ingredient id="6673" count="30"/>
    <production id="13433" count="1"/>
    <production id="13441" count="1"/>
    <production id="13138" count="1"/>
    <production id="13442" count="1"/>
    <production id="13443" count="1"/>
  </item>

  <!-- Vesper Leather Breastplate {PvP} -->
  <!-- <item id="4">
    <ingredient id="307" count="1300000000"/>
    <ingredient id="34830" count="300"/>
    <production id="143021" count="1"/>
    <production id="13441" count="1"/>
    <production id="13138" count="1"/>
    <production id="13442" count="1"/>
    <production id="13443" count="1"/>
  </item> -->

  <!-- Vesper Tunic -->
  <item id="5">
    <ingredient id="6673" count="30"/>
    <production id="13434" count="1"/>
    <production id="13444" count="1"/>
    <production id="13139" count="1"/>
    <production id="134430" count="1"/>
    <production id="13446" count="1"/>
  </item>

  <!-- Vesper Tunic {PvP} -->
  <!-- <item id="6">
    <ingredient id="307" count="1300000000"/>
    <ingredient id="34830" count="300"/>
    <production id="143022" count="1"/>
    <production id="13444" count="1"/>
    <production id="13139" count="1"/>
    <production id="134430" count="1"/>
    <production id="13446" count="1"/>
  </item> -->

  <!-- Vesper Noble Breastplate -->
  <item id="7">
    <ingredient id="6673" count="30"/>
    <production id="134330" count="1"/>
    <production id="13448" count="1"/>
    <production id="13140" count="1"/>
    <production id="13449" count="1"/>
    <production id="134300" count="1"/>
  </item>

  <!-- Vesper Noble Breastplate {PvP} -->
  <!-- <item id="8">
    <ingredient id="34830" count="3000"/>
    <production id="143023" count="1"/>
    <production id="13448" count="1"/>
    <production id="13140" count="1"/>
    <production id="13449" count="1"/>
    <production id="134300" count="1"/>
  </item> -->

  <!-- Vesper Noble Leather Breastplate -->
  <item id="9">
    <ingredient id="6673" count="30"/>
    <production id="13436" count="1"/>
    <production id="134301" count="1"/>
    <production id="13141" count="1"/>
    <production id="134302" count="1"/>
    <production id="134303" count="1"/>
  </item>

  <!-- Vesper Noble Leather Breastplate {PvP} -->
  <!-- <item id="10">
    <ingredient id="307" count="1300000000"/>
    <ingredient id="34830" count="3000"/>
    <production id="143024" count="1"/>
    <production id="134301" count="1"/>
    <production id="13141" count="1"/>
    <production id="134302" count="1"/>
    <production id="134303" count="1"/>
  </item> -->

  <!-- Vesper Noble Tunic -->
  <item id="11">
    <ingredient id="6673" count="30"/>
    <production id="13437" count="1"/>
    <production id="134304" count="1"/>
    <production id="13142" count="1"/>
    <production id="1343030" count="1"/>
    <production id="134306" count="1"/>
  </item>

  <!-- Vesper Noble Tunic {PvP} -->
  <!-- <item id="12">
    <ingredient id="307" count="1300000000"/>
    <ingredient id="34830" count="3000"/>
    <production id="1430230" count="1"/>
    <production id="134304" count="1"/>
    <production id="13142" count="1"/>
    <production id="1343030" count="1"/>
    <production id="134306" count="1"/>
  </item> -->

  <!-- Vesper Shield -->
  <item id="13">
    <ingredient id="6673" count="30"/>
    <production id="13471" count="1"/>
  </item>

  <!-- Vesper Shield -->
  <item id="14">
    <ingredient id="6673" count="30"/>
    <production id="12813" count="1"/>
  </item>


</list>

 

 

Someone can help or fix my problem ? what is wrong i dont know :/

p.s. sorry for my bad eng.

Regards

Create an account or sign in to comment

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.