Jump to content

Recommended Posts

  • 6 months later...
  • 1 month later...
Posted

i always get such error:

 

 

Error

 

SQL query:

 

(

'9416', 'Dynasty Plate', 'chest', 'false', 'heavy', '7620', 'wood', 's', '0', '-1', '219', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0'

), (

'9421', 'Dynasty Gaiters', 'legs', 'false', 'heavy', '3260', 'wood', 's', '0', '-1', '137', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0'

), (

'9422', 'Dynasty Helm', 'head', 'false', 'none', '550', 'wood', 's', '0', '-1', '89', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0'

), (

'9423', 'Dynasty Gloves', 'gloves', 'false', 'none', '540', 'wood', 's', '0', '-1', '59', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0'

), (

'9424', 'Dynasty Boots', 'feet', 'false', 'none', '1110', 'wood', 's', '0', '-1', '59', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0'

), (

'9425', 'Dynasty Leather', 'chest', 'false', 'light', '7620', 'wood', 's', '0', '-1', '219', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0'

), (

'9428', 'Dynasty Leather Pants', 'legs', 'false', 'light', '3260', 'wood', 's', '0', '-1', '137', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0'

), (

'9429', 'Dynasty Leather Helm', 'head', 'false', 'none', '550', 'wood', 's', '0', '-1', '89', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0'

), (

'9430', 'Dynasty Leather Gloves', 'gloves', 'false', 'none', '540', 'wood', 's', '0', '-1', '59', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0'

), (

'9431', 'Dynasty Leather Shoes', 'feet', 'false', 'none', '1110', 'wood', 's', '0', '-1', '59', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0'

), (

'9432', 'Dynasty Robe', 'chest', 'false', 'magic', '7620', 'wood', 's', '0', '-1', '219', '0', '257', '0', '0', 'true', 'true', 'true', 'true', '0', '0'

), (

'9437', 'Dynasty Pants', 'legs', 'false', 'magic', '3260', 'wood', 's', '0', '-1', '137', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0'

), (

'9438', 'Dynasty Cap', 'head', 'false', 'none', '550', 'wood', 's', '0', '-1', '89', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0'

), (

'9439', 'Dynasty Mittens', 'gloves', 'false', 'none', '540', 'wood', 's', '0', '-1', '59', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0'

), (

'9440', 'Dynasty Slippers', 'feet', 'false', 'none', '1110', 'wood', 's', '0', '-1', '59', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0'

);

 

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 ''9416', 'Dynasty Plate', 'chest', 'false', 'heavy', '7620', 'wood', 's', '0', '-' at line 1

[ Back ]

 

have the same error how i have to add this stuf ??

Posted

take from ur database the sqls of imperial crusader armor and replace the id and the name. then add this to ur base and it will work.

 

u get this error cause the "boxes" at the table are lees or more than the table can "read".

  • 4 months later...
  • 2 weeks later...
Posted

It works.... Big thx but i need xml's with good stats becose these armors now raise only p def.

yes TheMental please share us the xml file with the corrently stats!please!!
  • 3 months later...
  • 3 weeks later...
  • 1 year later...
Guest
This topic is now closed to further replies.



  • Posts

    • To all first time buyers we give a bonus + 10% of the order. 
    • 🔥 Looking for a powerful, clean, and player-friendly Auction House system for your Lineage 2 server? This fully-featured module is ready to plug into your project and provide your players with a modern, centralized marketplace!   💼 What is it? A complete Auction House system designed for fixed-price item sales between players. Forget about private stores and spammed zones—this system offers a smooth, secure, and offline-friendly way to buy and sell items across your server.   Photo Library: https://imgur.com/a/zLlUQbW   ✅ Main Features: 🔹 Fixed-Price Listings Only: Players list items at a set price. No bidding, no delays—just fast, clean trades. 🔹 Multi-Currency Support: Works with Adena, event coins, custom currencies—fully configurable. 🔹 Dynamic Interface: Players can filter items by name, type, and price. Easy-to-use HTML layout with smooth pagination. 🔹 Sell While Offline: Post items and receive payments even if you're not online—true passive trading. 🔹 Safety First: Full validation: no equipped/augmented/restricted items unless allowed. Prevents scams, mispricing, and listing errors. 🔹 Expiration Timer (Optional): Set listing time limits. Expired items go to warehouse/mail automatically. 🔹 Spam & Duplication Protection: Prevents multiple listings of identical items and unnecessary database load. 🔹 Performance Optimized: Clean, indexed SQL structure. No lag or bloating even with thousands of listings.   ⚙️ Plug & Play Clean Java code (compatible with aCis & derivatives). Easy setup with full instructions and sample configurations. Includes SQL, HTML files, and all Java classes – fully working out of the box.   💰 Pricing & Contact 📦 50 euro - One-time purchase with full support for setup & basic customization. 💬 Contact me here via PM or on Discord: @Luminous 🔐 Serious buyers only – source is clean, secure, and tested on live servers.     Give your server the next-level economy it deserves. No more chaotic trade zones. No more confusion. Just clean, efficient, server-wide trading.
    • We are certainly not an ambulance, but we will definitely cure you of blacklists and empty pockets. Live freely with SX! Each of you will receive a trial version of SX to familiarize yourself with the product, all you have to do is post in this thread
    • 166 pisses on their heads any day of the week though
    • Thnx for share, i can't pm u for password  
  • Topics

×
×
  • Create New...