Jump to content

Recommended Posts

  • 3 weeks later...
Posted

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

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

Posted

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 .

Posted

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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.




×
×
  • Create New...