Jump to content
  • 0

Question

Posted

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

8 answers to this question

Recommended Posts

  • 0
Posted

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
  • 0
Posted

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?

  • 0
Posted

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;

  • 0
Posted

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!

  • 0
Posted

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 :)
  • 0
Posted

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!

  • 0
Posted

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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



  • Posts

    • ElmoreLab Harbor - Eternal C1 x1: ✅ https://harbor.elmorelab.com ElmoreLab Harbor - Eternal C1 x1 - is an exclusive server of the Eternal C1 chronicles from the top project ElmoreLab Harbor.   A unique server of its kind, on which everyone will have maximum pleasure, such as oldschool players who dream of nostalgia and to feel the warmest and classic C1 chronicles, as well as experienced players who are tired of thousands unbalanced servers of late chronicles. Due to the professional corrections of the balance system and the HONEST gameplay system - on this server, EVERY player will feel like in their own, warm and cozy Harbor C1. Let's return to the origins of L2 - back to 2004 in C1! ❤️   ⭐ Server characteristics:   STRICTLY 1 window, NO BOXES Bans for RMT and bots/cheats No donations with benefits Unique and high-quality PTS-build from Master Toma Professional corrections and full class-balance Reworked economy and closed all abuses Improved animations and all aspects of the game Exclusive HD-client with high-quality textures Experienced administration and management Fixed all bugs, geodata, exploits and holes Maximum sociality due to the 1-box system Discovering, exploring and researching Big online International server Nostalgia and oldschool-feelings   Rates: x1 Server start: 14.02.2025   The server is at the final stages of development and preparation for release. Information on the server will be updated, soon the patchnotes and changes/edits will be posted. Don't miss the legendary and epic experience on the best server in the last 20 years! ❤️ Join our C1-forum with a lot of information about server and active discussions.   ⭐ Website: https://harbor.elmorelab.com   ✅ Forum: https://forum-harbor.elmorelab.com   💥 Telegram: https://t.me/l2harbor https://t.me/l2harbor_chat   ⚡ Discord: https://discord.gg/harborelmorelab
    • yeah ok, if you say what is fuctional 100% i can't say something different 😛  but if someone find hard to compile it or get vs and all that things i have here one more simple way here to put overlay in your own server or to change your window name with few money.
    • I've been using this for 2 years now with no issues from Discord. I don't use ogg.dll either. This one works with any l2.exe too; I don’t see any difference between them.
    • hmm.. ok i just see that, is different code first of all. My sources is totally different based in other way, with else libraries.  I have access to modify everything even to make the clock to stop show how many time users play in server. 1) so maybe keep some personal info more hide. 2) i dont use ogg.dll 3) i create it and give it ready + support to install it. Plus what is mine can working with what ever .exe you want not just l2 with same simple method. And i am sure if you try this source to compile it, after 3 hours discord will like shadowban your API too thats my source
  • Topics

×
×
  • Create New...