Jump to content
  • 0

[Help]Class Trader Dissapear


Question

Posted

Hello, I'm using L2jFrozen 1118rev, and I have one problem. I spawn roy the cat(31228), he working perfectly, but after server restart he disappear and it exist in db, spawnlist. With other NPC's is everything right. GameServer doesn't show any errors. What should I do?

 

10 answers to this question

Recommended Posts

  • 0
Posted

gameserver/config/functions/l2jfrozen.properties

lines 39-52

# --------------------------
#  Custom Tables -
# --------------------------
# Enable / Disable custom tables.
# The rest of the custom tables are already activated.

# Custom Spawnlist Table
CustomSpawnlistTable = True

# Gm Spawn gets saved on custom_spawnlist Table?
SaveGmSpawnOnCustom = True

# Gm Spawn gets deleted on custom_spawnlist Table?
DeleteGmSpawnOnCustom = True
  • 0
Posted

There is a stupid config to save (custom) spawns in database. You have to search for it. I don't know the config name, nor directory. Else wait till someone who was/is using frozen reply with the exact place.

  • 0
Posted (edited)

Like SweeTs said 

Go to Config/Functions and open l2jfrozen.properties

and find this line
 

 

# Custom Spawnlist Table

CustomSpawnlistTable = True
 
Edit : Damn Spirako xD
Edited by Alexi
  • 0
Posted (edited)
 

not solved! Still dissapear's!

It must work, otherwise you need to intall some custom spawn table. I will not be surprised if it's necessary..

 

Also, don't expect changes if you had server running.

Edited by SweeTs
  • 0
Posted

 

 
 

It must work, otherwise you need to intall some custom spawn table. I will not be surprised if it's necessary..

 

Also, don't expect changes if you had server running.

 

 

 

Well, there is already custom spawn table, other custom npcs working perfectly, and don't disappear after server restart.

  • 0
Posted (edited)

Search for another config then, class master related. I bet there is :happyforever:

 

Such a lol pack.

Edited by SweeTs
  • 0
Posted

I saw one error today.

ERROR SpawnTable: Could not store spawn in the DB
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '4755' for key 'PRIMARY'
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
        at java.lang.reflect.Constructor.newInstance(Unknown Source)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
        at com.mysql.jdbc.Util.getInstance(Util.java:382)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1039)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3603)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)
        at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1362)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:989)
        at com.l2jfrozen.gameserver.datatables.sql.SpawnTable.addNewSpawn(SpawnTable.java:314)
        at com.l2jfrozen.gameserver.handler.admincommandhandlers.AdminSpawn.spawnMonster(AdminSpawn.java:293)
        at com.l2jfrozen.gameserver.handler.admincommandhandlers.AdminSpawn.useAdminCommand(AdminSpawn.java:173)
        at com.l2jfrozen.gameserver.network.clientpackets.SendBypassBuildCmd.runImpl(SendBypassBuildCmd.java:76)
        at com.l2jfrozen.gameserver.network.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:77)
        at com.l2jfrozen.gameserver.network.L2GameClient.run(L2GameClient.java:1213)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)
  • 0
Posted

ERROR SpawnTable

Duplicate entry '4755' for key 'PRIMARY'

 

You already have a spawnlist with this id in your spawnlist table , if you tried to add something just change the id.

  • 0
Posted

ERROR SpawnTable

Duplicate entry '4755' for key 'PRIMARY'

 

You already have a spawnlist with this id in your spawnlist table , if you tried to add something just change the id.

 

already tryied that.

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


  • Posts

    • 🔥 HF Rework Multi-Proff x10 is coming! ⚔️ New Samurai Crow Client ⚔️ Reworked Systems & Progression ⚔️ Updated Instances ⚔️ Classic Multeria Atmosphere 🧪 Pre-OBT is already live! 📅 Official OBT: June 29 🚀 Launch: July 3 🐞 Report bugs during testing and earn valuable rewards at launch! See you on the battlefield! https://rework.multeria.world/
    • PlayCMS - это удобная система управления веб-сайтом, разработанная специально для игровых проектов Lineage 2. CMS позволяет быстро запустить полнофункциональный серверный сайт с регистрацией игроков, личным кабинетом, новостями, рейтингами, магазином, модулями и гибкой панелью администратора. Система ориентирована на владельцев серверов Lineage 2, которым нужен красивый, функциональный и понятный сайт без лишних сложностей.  PlayCMS уже предоставляет базовые функции для управления проектами, такие как публикация новостей, настройка страниц, работа с пользователями, подключение шаблонов, а также установка модулей и плагинов. Ключевые особенности PlayCMS: — удобная административная панель; — регистрация и авторизация игроков; — учетная запись пользователя; — новостные и информационные страницы; — рейтинги игроков и кланов; — поддержка шаблонов дизайна; — установка модулей и плагинов через административную панель; — магазин цифровых продуктов; — категории продуктов; — возможность добавить фавикон; — защита лицензии для административной панели; — адаптация для игровых проектов Lineage 2; — возможность расширения функционала в соответствии с потребностями сервера. PlayCMS подходит как для новых игровых проектов, так и для существующих серверов, которым нужен удобный сайт с современным дизайном и интуитивно понятным управлением. Система проста в настройке и поддерживает индивидуальные шаблоны, дополнительные плагины и модули, что позволяет вам развивать свой сайт параллельно с развитием сервера. PlayCMS — это готовое решение для владельцев серверов Lineage 2, которым нужен красивый, быстрый и функциональный сайт. Демоверсия —  https://demo.playcms.ru/ Я разработчик этого чуда. Я готов выслушать конструктивную критику, а также ваши предложения по улучшению движка. Кроме того, я пишу модули любой сложности для этой CMS. Свяжитесь со мной: Telegram — @playcms       EN   PlayCMS is a user-friendly website management system designed specifically for Lineage 2 gaming projects. The CMS allows you to quickly launch a fully functional server website with player registration, personal account, news, ratings, a store, modules, and a flexible admin panel. The system is focused on Lineage 2 server owners who need a beautiful, functional, and clear website without unnecessary complexity. PlayCMS already provides basic features for project management, such as publishing news, customizing pages, working with users, connecting templates, and installing modules and plugins. Key Features of PlayCMS: — a convenient administrative panel; — player registration and authorization; — user account; — news and information pages; — player and clan ratings; — support for design templates; — installation of modules and plugins through the admin panel; — digital product store; — product categories; — ability to add a favicon; — license protection for the admin panel; — adaptation for Lineage 2 game projects; — the ability to expand functionality to meet the needs of the server. PlayCMS is suitable for both new gaming projects and existing servers that require a user-friendly website with a modern appearance and intuitive management. The system is easy to configure and supports individual templates, additional plugins, and modules, allowing you to develop your website alongside your server. PlayCMS is a ready-made solution for Lineage 2 server owners who need a beautiful, fast, and functional website. Demo - https://demo.playcms.ru/ I am the developer of this miracle. I am ready to listen to constructive criticism, as well as your suggestions for improving the engine. I also write modules of any complexity for this cms. Contact me: Telegram - @playcms   Скачать\Download : https://drive.google.com/file/d/15Az9WVDD4SQNyOPAsXMU4-mGHOiA_U_d/view     Added a new module "Wheel of Fortune" to the demo version.  PlayCMS Fortune Wheel - module "Wheel of Fortune" for Play CMS Purpose: - adds a Lineage 2-style wheel of fortune to the user's personal account; - displays in the personal account on top of the balance and warehouse block; - supports prizes: Adena, Coin of Luck, premium account, common items, empty slots; - before submitting the form, shows the animation of the wheel spinning; - if there are no attempts, it displays the "No attempts" modal window; - the won gift is automatically added to the user's inventory; - adds a separate "Wheel of Fortune" section to the admin panel; - in the admin panel, you can edit slots, Item ID, quantity, drop chance, attempts, and the price of purchasing attempts using your balance.
    • To increase visibility and make sure your offer reaches the right audience, I'd recommend exploring the tools at CS2WH. They have a Deals Bot that might help you track market prices and adjust your strategy on the fly. I'm finding their resources super helpful for keeping tabs on the trading scene. Plus, they emphasize safety and provide insights on legal skin trading, which is crucial for maintaining credibility.
  • 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..