Jump to content

Recommended Posts

Posted

Full build dont create login, game and tools folder D:

It's too hard copy those folder from Dist? Or add the function on build.xml to copy from Dist to Build? I do not see the problem unless you are lazy to do it.

Posted (edited)

CREATE TABLE IF NOT EXISTS `character_variables` (
	`obj_id` INT NOT NULL DEFAULT '0',
	`type` VARCHAR(86) NOT NULL DEFAULT '0',
	`name` VARCHAR(86) CHARACTER SET UTF8 NOT NULL DEFAULT '0',
	`value` VARCHAR(4000) CHARACTER SET UTF8 NOT NULL DEFAULT '0',
	`expire_time` bigint(20) NOT NULL DEFAULT '0',
	UNIQUE KEY `prim` (`obj_id`,`type`,`name`),
	KEY `obj_id` (`obj_id`),
	KEY `type` (`type`),
	KEY `name` (`name`),
	KEY `value` (`value`),
	KEY `expire_time` (`expire_time`)
) ENGINE=MyISAM;


I got a Error whit this if itry to put install database?

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table '11.character_variables' doesn't exist

if try to instal the missing character_variables i got this eror:

[Err] 1071 - Specified key was too long; max key length is 1000 bytes
[Err] CREATE TABLE IF NOT EXISTS `character_variables` (
	`obj_id` INT NOT NULL DEFAULT '0',
	`type` VARCHAR(86) NOT NULL DEFAULT '0',
	`name` VARCHAR(86) CHARACTER SET UTF8 NOT NULL DEFAULT '0',
	`value` VARCHAR(4000) CHARACTER SET UTF8 NOT NULL DEFAULT '0',
	`expire_time` bigint(20) NOT NULL DEFAULT '0',
	UNIQUE KEY `prim` (`obj_id`,`type`,`name`),
	KEY `obj_id` (`obj_id`),
	KEY `type` (`type`),
	KEY `name` (`name`),
	KEY `value` (`value`),
	KEY `expire_time` (`expire_time`)
) ENGINE=MyISAM;
[Msg] Finished - Unsuccessfully

somewone got a good character_variables Execule Batch File for me.

 

Somewone to help to fix this please

Edited by Attila
Posted
CREATE TABLE IF NOT EXISTS `character_variables` (
	`obj_id` INT NOT NULL DEFAULT '0',
	`type` VARCHAR(86) NOT NULL DEFAULT '0',
	`name` VARCHAR(86) CHARACTER SET UTF8 NOT NULL DEFAULT '0',
	`value` VARCHAR(4000) CHARACTER SET UTF8 NOT NULL DEFAULT '0',
	`expire_time` bigint(20) NOT NULL DEFAULT '0',
	UNIQUE KEY `prim` (`obj_id`,`type`,`name`),
	KEY `obj_id` (`obj_id`),
	KEY `type` (`type`),
	KEY `name` (`name`),
	KEY `value` (`value`),
	KEY `expire_time` (`expire_time`)
) ENGINE=MyISAM;


I got a Error whit this if itry to put install database?

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table '11.character_variables' doesn't exist

if try to instal the missing character_variables i got this eror:

[Err] 1071 - Specified key was too long; max key length is 1000 bytes
[Err] CREATE TABLE IF NOT EXISTS `character_variables` (
	`obj_id` INT NOT NULL DEFAULT '0',
	`type` VARCHAR(86) NOT NULL DEFAULT '0',
	`name` VARCHAR(86) CHARACTER SET UTF8 NOT NULL DEFAULT '0',
	`value` VARCHAR(4000) CHARACTER SET UTF8 NOT NULL DEFAULT '0',
	`expire_time` bigint(20) NOT NULL DEFAULT '0',
	UNIQUE KEY `prim` (`obj_id`,`type`,`name`),
	KEY `obj_id` (`obj_id`),
	KEY `type` (`type`),
	KEY `name` (`name`),
	KEY `value` (`value`),
	KEY `expire_time` (`expire_time`)
) ENGINE=MyISAM;
[Msg] Finished - Unsuccessfully

somewone got a good character_variables Execule Batch File for me.

 

Somewone to help to fix this please

 

 

Problem is key on `value` field. It's overkill MySQL indexing rules. Fix your key.

Posted

any one can help me disable Quiz event?

 

Have you checked the config folder at least? Have you read them?

 

Because everything is there!

Posted (edited)

Have you checked the config folder at least? Have you read them?

 

Because everything is there!

can you help me? i looked on config forlder but about Quiz event i not finded enithing..

 

https://ibb.co/idpRUv

 

need help to disable it

Edited by kreis
Posted (edited)

Problem is key on `value` field. It's overkill MySQL indexing rules. Fix your key.

yes tanks i made it to inpoer the character_variables

But now I see this every time ?

Some help here please

 

Have you checked the config folder at least? Have you read them?

 

Because everything is there!

thanks

Edited by Attila

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

    • Lineage 2 Interlude Developer – Cliente + Datapack Hola, soy developer especializado en Lineage 2 Interlude con experiencia tanto en cliente como datapack/core. ✔ Desarrollo datapack (Java, scripts, quests, balance PvP/PvE) ✔ Fixes core / geodata / exploits ✔ Sistemas custom (events, Olympiad, instancias, mods PvP) ✔ Cliente: interface mods, system patches, .dat edits, UI personalizada ✔ Optimización y estabilidad de servidor ✔ Trabajo freelance o colaboración fija Si necesitáis soporte dev o mejoras para vuestro servidor Interlude, podéis contactarme por DM. Portfolio y ejemplos disponibles bajo petición.
    • THEY DON’T COME BACK FOR NO REASON. HERE’S WHY Our clients come from different countries and with very different tasks. But the strongest indicator of quality is simple — when a client comes back **for a second time**. This case is exactly that. The client returned with a request for a **German ID**. The requirement was clear: a document **in a male hand**, with a natural live scene and correct geographic context. What we did: ▪ accepted source files and data without unnecessary bureaucracy ▪ selected a **real street**, not a generic background ▪ built a print-ready mockup with correct scene logic ▪ sent it for approval ▪ after confirmation, delivered the **final file for printing** No templates. No “good enough”. Only solutions tailored to a specific task. Result: ▪ mockup approved on the first try ▪ client fully satisfied ▪ stays in touch We work **worldwide** — and that’s exactly why clients return. Contact us › TG: @mustang_service ( https:// t.me/ mustang_service ) › Channel: Mustang Service ( https:// t.me/ +6RAKokIn5ItmYjEx ) *All data is published with the client’s consent.* #redraw #verification #documents #case #ID
    • Lineage 2 Interlude Developer – Cliente + Datapack Hola, soy developer especializado en Lineage 2 Interlude con experiencia tanto en cliente como datapack/core. ✔ Desarrollo datapack (Java, scripts, quests, balance PvP/PvE) ✔ Fixes core / geodata / exploits ✔ Sistemas custom (events, Olympiad, instancias, mods PvP) ✔ Cliente: interface mods, system patches, .dat edits, UI personalizada ✔ Optimización y estabilidad de servidor ✔ Trabajo freelance o colaboración fija Si necesitáis soporte dev o mejoras para vuestro servidor Interlude, podéis contactarme por DM. Portfolio y ejemplos disponibles bajo petición.
  • 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..