database

[DAVC]

any help me this problem  http://img441.imageshack.us/img441/5454/neimenovana.png

[fdLP.]

check for syntax in armor.sql , we cant know whats going on , pack ? Rev ? try updating

[DAVC]

i use  L2Dot_401.7z

 

[jossoo]

try to exucute batch file manual...its in the folder Sql in your server pack...

to to navicat and execute it..

[jaz]

i add manually armor in my navicat but problem

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 24

[Err] CREATE TABLE `armor` (

  `item_id` int(11) NOT NULL default '0',

  `name` varchar(70) default NULL,

  `bodypart` varchar(15) NOT NULL default '',

  `crystallizable` varchar(5) NOT NULL default '',

  `armor_type` varchar(5) NOT NULL default '',

  `weight` int(5) NOT NULL default '0',

  `material` varchar(15) NOT NULL default '',

  `crystal_type` varchar(4) NOT NULL default '',

  `avoid_modify` int(1) NOT NULL default '0',

  `duration` int(3) NOT NULL default '0',

  `p_def` int(3) NOT NULL default '0',

  `m_def` int(2) NOT NULL default '0',

  `mp_bonus` int(3) NOT NULL default '0',

  `price` int(11) NOT NULL default '0',

  `crystal_count` int(4) default NULL,

  `sellable` varchar(5) default NULL,

  `dropable` varchar(5) default NULL,

  `destroyable` varchar(5) default NULL,

  `tradeable` varchar(5) default NULL,

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

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

  PRIMARY KEY  (`item_id`)

) TYPE=MyISAM;

[Msg] Finished - Unsuccessfully

--------------------------------------------------

[fdLP.]

try updating , no errors for me