hello everyone.. i just try transfer an l2j-oneo to l2j-dot i make a backup then edit tables of l2j-dot for insert l2joneo tables... all work fine... ;) but i can't enter into de game with any characters i get this error in console:

unknow column 'hero' in 'field list'

some idea? tx for read

go to the table characters,

 

press right click , design table

 

find the column hero , and delete it. :)

 

go to the table characters,

 

press right click , design table

 

find the column hero , and delete it. :)

 

well stefou you mean delete table but for read i see he have error unknow column 'hero' in 'field list' so how to delete column yes him don't have column in DB i think he need add this column not deelte :S anyway i wrong correct me

well stefou you mean delete table but for read i see he have error unknow column 'hero' in 'field list' so how to delete column yes him don't have column in DB i think he need add this column not deelte :S anyway i wrong correct me

 

ok if i need add column hero

what code i need?

ALTER TABLE `characters` ADD `hero` decimal(1) NOT NULL default 0 ;

is correct?

 

 

Stefoulis15 i dont have hero column in characters table :S c-error are correct?

ok if i need add column hero

what code i need?

ALTER TABLE `characters` ADD `hero` decimal(1) NOT NULL default 0 ;

is correct?

 

 

Stefoulis15 i dont have hero column in characters table :S c-error are correct?

 

no look in my pack for example have a table named heroes just put ID of character there and fun done

 

DROP TABLE IF EXISTS `heroes`;

CREATE TABLE `heroes` (

  `char_id` decimal(11,0) NOT NULL default '0',

  `char_name` varchar(45) NOT NULL default '',

  `class_id` decimal(3,0) NOT NULL default '0',

  `count` decimal(3,0) NOT NULL default '0',

  `played` decimal(1,0) NOT NULL default '0',

  PRIMARY KEY  (`char_id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

ok both are wrong jejeej i just add hero table and work fine :P tx for helpme

 

one thing more and close thread

how i can change title colors for GM/Admin? l2jdot dont have any command for that

some idea!

see ya!

ok both are wrong jejeej i just add hero table and work fine :P tx for helpme

 

one thing more and close thread

how i can change title colors for GM/Admin? l2jdot dont have any command for that

some idea!

see ya!

well you can do it adding some info in config server maybe have some special configuration in gameserver read there and maybe you found something :)

well you can do it adding some info in config server maybe have some special configuration in gameserver read there and maybe you found something :)

 

l2jdot dont have any option for get admin title color only name

l2jarchid have a sql for that but.. i can make work in l2jdot

maybe i need compile an l2jdot pack.. but.. what is the code... omg!

l2jdot dont have any option for get admin title color only name

l2jarchid have a sql for that but.. i can make work in l2jdot

maybe i need compile an l2jdot pack.. but.. what is the code... omg!

you can get the code from pack of L2ONEO by me preconfigured mate good luck