Jump to content

Recommended Posts

Posted
[Err] 1366 - Incorrect decimal value: 'false' for column 'item_skill_id' at row 1

[Err] INSERT INTO `armor` VALUES

('10000', 'Titanium Plate Helmet', 'head', 'false', 'heavy', '7620', 'wood', 's', '0', '-1', '219', '0', '0', '0', '0', 'false', 'false', 'true', 'true', '0', '0'),

('10001', 'Titanium Plate Armor', 'fullarmor', 'false', 'heavy', '3260', 'wood', 's', '0', '-1', '137', '0', '0', '0', '0', 'false', 'false', 'true', 'true', '0', '0'),

('10002', 'Titanium Plate Gloves', 'gloves', 'false', 'heavy', '550', 'wood', 's', '0', '-1', '89', '0', '0', '0', '0', 'false', 'false', 'true', 'true', '0', '0'),

('10003', 'Titanium Plate Boots', 'feet', 'false', 'heavy', '540', 'wood', 's', '0', '-1', '59', '0', '0', '0', '0', 'false', 'false', 'true', 'true', '0', '0'),

('10004', 'Titanium Leather Helmet', 'head', 'false', 'light', '1110', 'wood', 's', '0', '-1', '59', '0', '0', '0', '0', 'false', 'false', 'true', 'true', '0', '0'),

('10005', 'Titanium Leather Armor', 'fullarmor', 'false', 'light', '7620', 'wood', 's', '0', '-1', '219', '0', '0', '0', '0', 'false', 'false', 'true', 'true', '0', '0'),

('10006', 'Titanium Leather Gloves', 'gloves', 'false', 'light', '3260', 'wood', 's', '0', '-1', '137', '0', '0', '0', '0', 'false', 'false', 'true', 'true', '0', '0'),

('10007', 'Titanium Leather Boots', 'feet', 'false', 'light', '550', 'wood', 's', '0', '-1', '89', '0', '0', '0', '0', 'false', 'false', 'true', 'true', '0', '0'),

('10008', 'Titanium Mentlle Helmet', 'head', 'false', 'magic', '540', 'wood', 's', '0', '-1', '59', '0', '0', '0', '0', 'false', 'false', 'true', 'true', '0', '0'),

('10009', 'Titanium Mentlle', 'fullarmor', 'false', 'magic', '1110', 'wood', 's', '0', '-1', '59', '0', '0', '0', '0', 'false', 'false', 'true', 'true', '0', '0'),

('10010', 'Titanium Mentlle Gloves', 'gloves', 'false', 'magic', '7620', 'wood', 's', '0', '-1', '219', '0', '257', '0', '0', 'false', 'false', 'true', 'true', '0', '0'),

('10011', 'Titanium Mentlle Shoes', 'feet', 'false', 'magic', '3260', 'wood', 's', '0', '-1', '137', '0', '0', '0', '0', 'false', 'false', 'true', 'true', '0', '0');

[Msg] Finished - Unsuccessfully

-------------------------------------------------- some body help please ?

 

 

 

 

hey "BaM" look this!

 

('10000', 'Titanium Plate Helmet', 'head', 'false', 'heavy', '7620', 'wood', 's', '0', '-1', '219', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '', '-1', '-1', '-1');
('10001', 'Titanium Plate Armor', 'fullarmor', 'false', 'heavy', '3260', 'wood', 's', '0', '-1', '137', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '', '-1', '-1', '-1');
('10002', 'Titanium Plate Gloves', 'gloves', 'false', 'heavy', '550', 'wood', 's', '0', '-1', '89', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '', '-1', '-1', '-1');
('10003', 'Titanium Plate Boots', 'feet', 'false', 'heavy', '540', 'wood', 's', '0', '-1', '59', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '', '-1', '-1', '-1');
('10004', 'Titanium Leather Helmet', 'head', 'false', 'light', '1110', 'wood', 's', '0', '-1', '59', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '', '-1', '-1', '-1');
('10005', 'Titanium Leather Armor', 'fullarmor', 'false', 'light', '7620', 'wood', 's', '0', '-1', '219', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '', '-1', '-1', '-1');
('10006', 'Titanium Leather Gloves', 'gloves', 'false', 'light', '3260', 'wood', 's', '0', '-1', '137', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '', '-1', '-1', '-1');
('10007', 'Titanium Leather Boots', 'feet', 'false', 'light', '550', 'wood', 's', '0', '-1', '89', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '', '-1', '-1', '-1');
('10008', 'Titanium Mentlle Helmet', 'head', 'false', 'magic', '540', 'wood', 's', '0', '-1', '59', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '', '-1', '-1', '-1');
('10009', 'Titanium Mentlle', 'fullarmor', 'false', 'magic', '1110', 'wood', 's', '0', '-1', '59', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '', '-1', '-1', '-1');
('10010', 'Titanium Mentlle Gloves', 'gloves', 'false', 'magic', '7620', 'wood', 's', '0', '-1', '219', '0', '257', '0', '0', 'true', 'true', 'true', 'true', '', '-1', '-1', '-1');
('10011', 'Titanium Mentlle Shoes', 'feet', 'false', 'magic', '3260', 'wood', 's', '0', '-1', '137', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '', '-1', '-1', '-1');

 

test this sql and put the results!

  • 1 month later...
  • 2 weeks later...
  • 2 weeks later...
Guest
This topic is now closed to further replies.



  • Posts

    • Hi players ! Meet our project Lineage 2 Hiro Classic ! A low rate classic pvp oriented with many features. No pay to win, RB/AoE, group clan pvp castle etc ...  Dynamic rates, RB Xp 4x and soon massive update with auto farm ! Join now !  https://www.lineage2hiro.com/ Can't wait to see you online !
    • 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
  • Topics

×
×
  • Create New...