01-20-2012, 02:40 AM
im using navicat i go to execute the lcep2.sql and i hit start and this is what is says any help pls.
bytes
[Err] -- phpMyAdmin SQL Dump
-- version 3.4.5
-- 2
--
-- Host: localhost
-- Erstellungszeit: 12. Jan 2012 um 00:58
-- Server Version: 5.5.16
-- PHP-Version: 5.3.8
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Datenbank: `lc`
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `t_bigpet`
--
CREATE TABLE IF NOT EXISTS `t_bigpet` (
`a_index` int(11) unsigned NOT NULL AUTO_INCREMENT,
`a_type` int(11) NOT NULL,
`a_level` int(11) NOT NULL DEFAULT 1,
`a_name` varchar(50) NOT NULL,
`a_curhp` int(11) NOT NULL DEFAULT 100,
`a_maxhp` int(11) NOT NULL DEFAULT 100,
`a_str` int(11) NOT NULL DEFAULT 0,
`a_dex` int(11) NOT NULL DEFAULT 0,
`a_con` int(11) NOT NULL DEFAULT 0,
`a_int` int(11) NOT NULL DEFAULT 0,
`a_exp` int(32) NOT NULL,
`a_skills` varchar(255) NOT NULL,
`a_levels` varchar(255) NOT NULL,
`a_aicom1` varchar(255) NOT NULL,
`a_aicom2` varchar(255) NOT NULL,
`a_aicom3` varchar(255) NOT NULL,
PRIMARY KEY (`a_index`),
KEY `a_index` (`a_index`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `t_castle`
--
CREATE TABLE IF NOT EXISTS `t_castle` (
`a_index` int(11) NOT NULL,
`a_guild` int(32) NOT NULL,
`a_tax` int(11) NOT NULL,
`a_tomb` tinyint(1) NOT NULL,
`a_tomb0` int(11) NOT NULL,
`a_tomb1` int(11) NOT NULL,
`a_time` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `t_characters`
--
CREATE TABLE IF NOT EXISTS `t_characters` (
`a_index` int(11) unsigned NOT NULL AUTO_INCREMENT,
`a_user_index` int(11) NOT NULL,
`a_charname` varchar(16) NOT NULL,
`a_class` int(1) NOT NULL,
`a_face` int(1) NOT NULL,
`a_hair` int(1) NOT NULL,
`a_level` int(11) NOT NULL,
`a_curhp` int(11) NOT NULL,
`a_maxhp` int(11) NOT NULL,
`a_curmp` int(11) NOT NULL,
`a_maxmp` int(11) NOT NULL,
`a_str` int(11) NOT NULL,
`a_dex` int(11) NOT NULL,
`a_int` int(11) NOT NULL,
`a_con` int(11) NOT NULL,
`a_curexp` bigint(22) NOT NULL,
`a_maxexp` bigint(22) NOT NULL,
`a_sp` bigint(22) NOT NULL,
`a_charcreation` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`a_wearing_id` varchar(255) NOT NULL,
`a_wearing_plus` varchar(255) NOT NULL,
`a_good_evil` int(11) NOT NULL,
`a_pkvalue` int(11) NOT NULL,
`a_reputation` int(11) NOT NULL,
`a_statpoints` int(11) NOT NULL DEFAULT 0,
`a_skill_id` varchar(255) NOT NULL,
`a_skill_level` varchar(255) NOT NULL,
`a_c2_helm` int(11) NOT NULL DEFAULT 0,
`a_c2_shirt` int(11) NOT NULL DEFAULT 0,
`a_c2_weapon` int(31) NOT NULL DEFAULT 0,
`a_c2_pants` int(11) NOT NULL DEFAULT 0,
`a_c2_shield` int(11) NOT NULL DEFAULT 0,
`a_c2_gloves` int(11) NOT NULL DEFAULT 0,
`a_c2_boots` int(11) NOT NULL DEFAULT 0,
`a_c2_wing` int(11) NOT NULL DEFAULT 0,
`a_job` int(1) NOT NULL DEFAULT 0,
`a_title` int(11) NOT NULL DEFAULT 0,
`a_hp_gentime` int(11) NOT NULL DEFAULT 18000,
`a_mp_gentime` int(11) NOT NULL DEFAULT 18000,
`a_hpgenpow` int(11) NOT NULL DEFAULT 6,
`a_mpgenpow` int(11) NOT NULL DEFAULT 6,
`a_raid` int(11) NOT NULL DEFAULT 0,
`a_char_active` int(11) NOT NULL DEFAULT 0,
`a_friendlist_colour` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (`a_index`),
KEY `a_index` (`a_index`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `t_event`
--
CREATE TABLE IF NOT EXISTS `t_event` (
`a_index` int(11) NOT NULL,
`a_event` int(11) NOT NULL,
`a_eventname` varchar(255) NOT NULL,
`a_enabled` tinyint(1) NOT NULL,
`a_start` datetime NOT NULL
[Msg] Finished - Unsuccessfully
--------------------------------------------------