Jump to content
MaxCheaters Official Group on Discord
Top.MaxCheaters.com is now OPEN – Lineage 2 Top Listing

GmShop Freya

mathuza

By mathuza
in Server Shares & Files [L2J]

 Share

Recommended Posts

  • 3 weeks later...
ProbL3m Newbie

ProbL3m

Posted
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

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

c2duo Rookie

c2duo

Posted
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 .

hawryszka Newbie

hawryszka

Posted
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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing


  • Posts

    • Adenland
      Professional Client & Datapack Editors by AdenLand Team

      By Adenland · Posted

      Greetings, MaxCheaters community! We are the development team behind projects like AdenLand, Classic GvE, TinyEssence, PvPEssence, and several others. Over the years of managing high-traffic servers, we’ve built our own ecosystem of tools for datapack and client editing, simply because standard software often failed to meet our production needs or was too slow. Today, we are opening access to these professional solutions for our colleagues in the dev scene. You can explore our suite of editors and utilities here: 👉 https://la2.tools/ Why choose our tools? Battle-Tested: This software is used daily to maintain and update our own live projects. Efficiency: Designed to automate routine tasks that usually take hours or even days. Stability: Built to handle complex client/server structures where generic tools often crash. We are ready to provide consultations on integrating these tools into your development workflow to make your process faster and more secure.  
    • Atom
      Java Coding Services

      By Atom · Posted

      There is such a topics based on java html services!
    • L2ElixirOfficial
      [L2J] L2Elixir

      By L2ElixirOfficial · Posted

      L2Elixir – Patch 9 Is Live! Since November 28, when L2Elixir officially opened, we’ve been here consistently and with dedication. We sincerely thank everyone who continues to support this major effort to bring back the true legacy of L2Elixir, even after 18+ years. It truly makes us happy to see many old players reunite, just like in the old days, and enjoy the game the way it was meant to be played: without RMT, without bug abusers, and without “paid” clans/CPs that disappear after a month. We continue with vision, stability, and respect for the community. Wishing everyone to Have fun! Changelogs: 🏆 Olympiad Olympiad every Monday & Friday (last day: Friday). Fixed an issue with wrong Class ID caused by the Class Change service. ⚔️ Territory Wars Territory Wars will now be held every Tuesday to increase PvP activity. 🛡️ Antibot General updates and additional security improvements implemented. 🔧 Items Augmentation & Attribute are now allowed on PvP weapons. Implemented Premium Coupon (15 Days) (currently not available). 🎉 Events An Auto Event will begin early morning (05:00) for NA players. 💻 Client Added EXP zones to the Map → Hunting Zones section. Renamed them to “XP Bonus” so they appear at the top of the list.   Website: https://l2elixir.org/ Discord: https://discord.gg/5ydPHvhbxs
    • CerusL2
      Essence 'mobius' datapack developer

      By CerusL2 · Posted

      I haven't work in Essence but I have transformed mobius projects into fully stable projects, reach out to me in Discord @cerus0130
    • bomarket
      CS2 | Buying skins: up to 98% | Buff/UU Sourcing: 1%

      By bomarket · Posted

      Bump

  • Topics

×
×
  • Create New...

Important Information

This community uses essential cookies to function properly. Non-essential cookies and third-party services are used only with your consent. Read our Privacy Policy and We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue..