11153ca

1Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@18558d2 [ con
2nectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@1bd
3747e [ acquireIncrement -> 3, autoCommitOnClose -> true, connectionTesterClassNa
4me -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, factoryClassLocation ->
5null, forceIgnoreUnresolvedTransactions -> false, idleConnectionTestPeriod -> 60
6, initialPoolSize -> 1, maxIdleTime -> 600, maxPoolSize -> 5, maxStatements -> 1
700, minPoolSize -> 1, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataS
8ource@18a47e0 [ description -> null, driverClass -> null, factoryClassLocation -
9> null, jdbcUrl -> jdbc:mysql://localhost/l2jdbnew, properties -> {user=root, pa
10ssword=password} ] , propertyCycle -> 300, testConnectionOnCheckout -> false ] ,
11 factoryClassLocation -> null, numHelperThreads -> 3 ]
12GameServer listening on IP:* Port 7777
13Maximum Numbers of Connected Players: 100
14[S] 1c SunRise
15ID Factory could not be initialized correctly:java.lang.ArrayIndexOutOfBoundsExc
16eption: 268436089
17Could not read object IDs from DB. Please run convertData.
18Exception in thread "main" java.lang.Exception: Could not initialize the ID fact
19ory
20        at net.sf.l2j.gameserver.GameServer.<init>(GameServer.java:197)
21        at net.sf.l2j.Server.main(Server.java:73)
22Press any key to continue . . .
23
24/*
25SQLyog v4.05
26Host - 4.1.11-nt : Database - l2jdbnew
27*********************************************************************
28Server version : 4.1.11-nt
29*/
30
31
32create database if not exists `l2jdbnew`;
33
34USE `l2jdbnew`;
35
36/*Table structure for table `l2jdbnew`.`characters` */
37
38drop table if exists `l2jdbnew`.`characters`;
39
40CREATE TABLE `characters` (
41  `account_name` varchar(13) default NULL,
42  `obj_Id` decimal(11,0) NOT NULL default '0',
43  `char_name` varchar(35) default NULL,
44  `level` decimal(11,0) default NULL,
45  `maxHp` decimal(11,0) default NULL,
46  `curHp` decimal(18,0) default NULL,
47  `maxMp` decimal(11,0) default NULL,
48  `curMp` decimal(18,0) default NULL,
49  `acc` decimal(11,0) default NULL,
50  `crit` decimal(10,0) default NULL,
51  `evasion` decimal(11,0) default NULL,
52  `mAtk` decimal(11,0) default NULL,
53  `mDef` decimal(11,0) default NULL,
54  `mSpd` decimal(11,0) default NULL,
55  `pAtk` decimal(11,0) default NULL,
56  `pDef` decimal(11,0) default NULL,
57  `pSpd` decimal(11,0) default NULL,
58  `runSpd` decimal(11,0) default NULL,
59  `walkSpd` decimal(11,0) default NULL,
60  `str` decimal(11,0) default NULL,
61  `con` decimal(11,0) default NULL,
62  `dex` decimal(11,0) default NULL,
63  `_int` decimal(11,0) default NULL,
64  `men` decimal(11,0) default NULL,
65  `wit` decimal(11,0) default NULL,
66  `face` decimal(11,0) default NULL,
67  `hairStyle` decimal(11,0) default NULL,
68  `hairColor` decimal(11,0) default NULL,
69  `sex` decimal(11,0) default NULL,
70  `heading` decimal(11,0) default NULL,
71  `x` decimal(11,0) default NULL,
72  `y` decimal(11,0) default NULL,
73  `z` decimal(11,0) default NULL,
74  `movement_multiplier` decimal(9,8) default NULL,
75  `attack_speed_multiplier` decimal(10,9) default NULL,
76  `colRad` decimal(10,9) default NULL,
77  `colHeight` decimal(10,9) default NULL,
78  `exp` decimal(11,0) default NULL,
79  `sp` decimal(11,0) default NULL,
80  `karma` decimal(11,0) default NULL,
81  `pvpkills` decimal(11,0) default NULL,
82  `pkkills` decimal(11,0) default NULL,
83  `clanid` decimal(11,0) default NULL,
84  `maxload` decimal(11,0) default NULL,
85  `race` decimal(11,0) default NULL,
86  `classid` decimal(11,0) default NULL,
87  `deletetime` decimal(11,0) default NULL,
88  `cancraft` decimal(11,0) default NULL,
89  `title` varchar(15) default NULL,
90  `allyId` decimal(11,0) default NULL,
91  `rec_have` int(3) NOT NULL default '0',
92  `rec_left` int(3) NOT NULL default '0',
93  `accesslevel` decimal(4,0) default NULL,
94  `online` decimal(1,0) default NULL,
95  PRIMARY KEY  (`obj_Id`)
96) ENGINE=InnoDB DEFAULT CHARSET=latin1;
97
98/*Data for the table `l2jdbnew`.`characters` */
99
100insert into `l2jdbnew`.`characters` values ('',0,'',(null),(null),(null),(null),(null),(null),(null),(null),(null),(null),(null),(null),(null),(null),(null),(null),(null),(null),(null),(null),(null),(null),(null),(null),(null),(null),(null),(null),(null),(null),(null),(null),(null),(null),(null),(null),(null),(null),(null),(null),(null),(null),(null),(null),(null),'',(null),0,0,(null),(null)),('valo',268435463,'Valo',15,1412,1412,1015,320,135,40,122,30,239,1333,10,155,385,117,81,22,27,21,41,39,20,2,0,0,0,55748,44922,42742,-3493,1.00000000,1.000000000,7.000000000,22.000000000,1010812486,83609,73,1,41,0,62500,0,10,0,0,'GoogleMaster',0,0,34,100,0),('hexatest',268435475,'Xu',14,588,196,165,107,84,44,79,4,73,200,12,192,417,138,96,40,43,30,21,25,11,0,1,3,1,5152,18395,145017,-3069,1.00000000,1.000000000,8.000000000,23.000000000,215599,5121,0,0,0,268435827,81900,0,0,0,0,'*censored*',0,0,3,0,0),('lucky',268435485,'Lucky',5,318,118,84,84,67,132,62,2,44,200,5,127,477,138,96,40,43,30,21,25,11,0,2,2,0,31877,-92403,253412,-3361,1.00000000,1.000000000,9.000000000,23.000000000,4141,138,0,0,0,0,81900,0,0,0,0,'',0,0,0,0,0),('cheeseh',268435488,'cheeseh',14,349,269,369,86,69,81,61,12,103,1212,5,125,385,122,85,22,27,21,41,39,20,2,4,2,0,9489,15365,137621,-3518,1.00000000,1.000000000,7.000000000,22.000000000,209827,762,0,0,0,0,62500,0,10,0,0,'',0,0,3,0,0),('hellokeyti',268435501,'HelloKeyti',1,198,152,48,46,66,485,66,1,42,200,4,64,363,138,96,40,43,30,21,25,11,1,5,3,1,7355,-70818,257492,-3110,1.00000000,1.000000000,8.000000000,23.000000000,1,0,0,0,0,0,81900,0,0,0,0,'',0,0,0,0,0),('virt',268435518,'virt',4,160,98,58,36,75,92,75,3,43,378,6,116,437,139,97,36,36,35,23,26,14,1,4,1,1,25413,45525,48376,-3450,1.00000000,1.000000000,7.000000000,23.000000000,2590,87,0,0,0,0,73000,1,18,0,0,'',0,0,0,0,0),('toolmantim',268435528,'TimTheToolman',5,345,302,87,87,70,87,70,3,45,164,8,117,414,136,95,39,45,29,20,27,10,2,2,3,0,29158,115124,-178195,-905,1.00000000,1.000000000,9.000000000,18.000000000,4135,135,0,0,0,0,83000,4,53,0,0,'',0,0,0,0,0),('takedown',268435546,'Erevain',11,357,357,141,141,80,91,72,4,98,249,11,182,433,158,110,41,32,34,25,26,12,2,1,1,0,64080,45360,49069,-3059,1.00000000,1.000000000,7.000000000,24.000000000,78185,969,0,0,0,0,69000,2,31,0,0,'',0,0,3,0,0),('desert_runner',268435554,'DesertRunner',13,400,114,159,83,82,91,74,4,85,249,13,212,433,158,110,41,32,34,25,26,12,2,1,3,0,7685,-28900,115928,-3599,1.00000000,1.000000000,7.000000000,24.000000000,164774,3124,0,0,0,0,69000,2,31,0,0,'',0,0,3,0,0),('paracell',268435557,'Lithena',3,186,141,68,68,69,137,72,3,43,249,5,115,495,158,110,41,32,34,25,26,12,1,4,2,1,2233,23807,14930,-3644,1.00000000,1.000000000,7.000000000,23.000000000,1093,32,0,0,0,0,69000,2,31,0,0,'',0,0,0,0,0),('meatwod',268435564,'MeatWod',10,516,516,133,133,80,43,75,3,47,164,13,132,355,136,95,39,45,29,20,27,10,0,1,3,1,4555,120627,-181999,-1981,1.00000000,1.000000000,5.000000000,19.000000000,63492,983,0,0,0,0,83000,4,53,0,1,'',0,0,3,0,0),('mjear',268435596,'mjear',11,357,216,141,85,77,137,80,4,84,249,22,174,335,158,110,41,32,34,25,26,12,2,4,2,0,39317,18823,145048,-2768,1.00000000,1.000000000,7.000000000,24.000000000,74022,957,0,0,0,0,69000,2,31,0,0,'',0,0,3,0,0),('asino1',268435602,'Mucek',7,227,223,204,184,67,40,62,10,51,1212,5,83,385,122,85,22,27,21,41,39,20,0,3,0,0,22211,-84176,243382,-3634,1.00000000,1.000000000,7.000000000,22.000000000,12038,405,0,0,0,0,62500,0,10,0,0,'',0,0,0,0,0),('jester',268435625,'Jester',15,367,227,455,61,75,40,70,20,128,1212,12,169,330,122,85,22,27,21,41,39,20,2,0,0,0,34738,-28616,115775,-3681,1.00000000,1.000000000,7.000000000,22.000000000,284895,1012,0,0,0,0,62500,0,10,0,0,'',0,0,3,0,0),('nullformat',268435655,'Transplant',9,353,253,123,62,80,92,72,4,70,378,9,127,437,165,115,36,36,35,23,26,14,1,0,0,1,189,51452,71543,-3673,1.00000000,1.000000000,7.000000000,23.000000000,40000,1066,0,0,0,0,73000,1,18,0,0,'',0,0,0,0,0),('dopey',268435679,'dopay',1,198,142,48,43,66,485,66,1,42,200,4,64,363,138,96,40,43,30,21,25,11,0,0,0,0,40662,-72283,256713,-3118,1.00000000,1.000000000,9.000000000,23.000000000,1,0,0,0,0,0,81900,0,0,0,0,'',0,0,0,0,0),('mudie',268435689,'conny',9,251,230,247,207,73,41,60,8,88,2034,4,85,395,131,91,21,25,24,37,40,23,1,1,0,0,46093,46017,51729,-2813,1.00000000,1.000000000,7.000000000,24.000000000,36499,189,0,0,0,0,62400,1,25,0,0,'',0,0,0,0,0),('gautts',268435702,'Argon',1,209,175,51,51,66,469,66,1,43,164,4,64,357,136,95,39,45,29,20,27,10,0,0,0,0,1492,107136,-175018,-409,1.00000000,1.000000000,9.000000000,18.000000000,1,0,0,0,0,0,83000,4,53,0,0,'',0,0,0,0,0),('gautts',268435708,'Darkone',15,618,300,174,25,80,88,72,6,86,200,17,166,417,138,96,40,43,30,21,25,11,2,2,0,0,1007,18419,144988,-3071,1.00000000,1.000000000,9.000000000,23.000000000,271277,622,0,0,0,0,81900,0,0,0,0,'',0,0,3,0,0),('havelok',268435719,'Baphomet',10,263,224,271,43,72,41,67,11,89,1007,4,113,392,129,90,23,24,23,44,37,19,2,4,2,1,19740,10841,17960,-4558,1.00000000,1.000000000,7.000000000,23.000000000,57456,1015,0,0,0,0,61000,2,38,0,0,'',0,0,3,0,0),('lapisangelkni',268435727,'Myshno',1,116,96,88,59,60,428,60,6,48,2034,1,43,325,131,91,21,25,24,37,40,23,2,0,3,0,0,43648,40352,-3430,1.00000000,1.000000000,7.000000000,24.000000000,0,0,0,0,0,0,62400,1,25,0,0,'',0,0,0,0,0),('takedown',268435778,'Lasathain',4,163,157,155,137,66,41,61,9,49,1007,4,60,392,129,90,23,24,23,44,37,19,2,1,3,0,19955,12181,16675,-3726,1.00000000,1.000000000,7.000000000,24.000000000,2299,95,0,0,0,0,61000,2,38,0,0,'',0,0,0,0,0),('jackal',268435795,'JaCKaL',8,229,180,213,159,65,82,65,12,76,1007,5,103,392,129,90,23,24,23,44,37,19,2,1,1,0,53391,19007,144370,-3100,1.00000000,1.000000000,7.000000000,24.000000000,20336,26,0,0,0,0,61000,2,38,0,0,'',0,0,0,0,0),('cursedone',268435811,'Hycondrias',7,217,217,215,105,71,41,66,8,75,2034,4,62,395,131,91,21,25,24,37,40,23,1,3,3,0,19825,29141,71907,-3782,1.00000000,1.000000000,7.000000000,24.000000000,15079,479,0,0,0,0,62400,1,25,0,0,'',0,0,0,0,0),('696969',268435887,'alphonse',18,707,707,201,201,83,485,51,2,148,135,9,361,246,93,65,40,43,30,21,25,11,2,1,0,0,2684,79627,150538,-3520,1.00000000,1.000000000,9.000000000,23.000000000,540625,12861,0,0,0,0,81900,0,0,0,0,'',0,0,3,-100,0),('havelok',268435896,'Mogwan',6,250,250,96,96,75,91,67,3,69,249,6,139,433,158,110,41,32,34,25,26,12,2,1,3,1,18243,67233,110360,-3715,1.00000000,1.000000000,7.000000000,23.000000000,8984,41,0,0,0,0,69000,2,31,0,0,'',0,0,0,0,0),('carl',268435926,'Carl',4,206,206,170,169,65,40,60,6,52,1096,9,60,381,125,87,25,31,20,31,42,21,0,3,2,0,33954,-50028,-110377,-237,1.00000000,1.000000000,7.000000000,27.000000000,1663,51,0,0,0,0,68000,3,49,0,0,'',0,0,0,0,0),('taos05',268435943,'Taos',7,213,213,198,166,69,41,64,10,75,1007,4,79,392,129,90,23,24,23,44,37,19,2,2,1,1,32538,7069,17939,-4389,1.00000000,1.000000000,7.000000000,23.000000000,14912,432,0,0,0,0,61000,2,38,0,0,'',0,0,0,0,0),('sid',268435982,'oldman',3,277,277,69,69,73,43,68,2,44,164,6,115,414,136,95,39,45,29,20,27,10,2,0,2,0,7360,109599,-174455,-559,1.00000000,1.000000000,9.000000000,18.000000000,400,26,0,0,0,0,83000,4,53,0,0,'',0,0,0,0,0),('banshee343',268435987,'FryLock',9,262,262,233,35,69,40,64,9,52,1212,4,63,385,122,85,22,27,21,41,39,20,0,0,0,0,25822,-82447,250425,-3625,1.00000000,1.000000000,7.000000000,22.000000000,43953,1309,0,0,0,0,62500,0,10,0,0,'',0,0,0,0,0),('vicbitter',268436003,'PissedBitsh',1,113,0,84,39,58,424,58,9,47,1007,1,43,319,129,90,23,24,23,44,37,19,0,0,0,1,60879,27643,10457,-4235,1.00000000,1.000000000,7.000000000,23.000000000,1,0,0,0,0,0,61000,2,38,0,0,'',0,0,0,0,0),('mrcrowley',268436022,'JamieM',6,250,236,204,171,67,40,62,7,80,1096,5,61,381,125,87,25,31,20,31,42,21,2,2,0,0,61755,-42307,-107747,-1746,1.00000000,1.000000000,7.000000000,27.000000000,8515,239,0,0,0,0,68000,3,49,0,0,'',0,0,0,0,0),('virt',268462970,'Virtical',7,176,176,158,124,71,41,66,8,62,2034,4,84,395,123,86,21,25,24,37,40,23,1,0,3,1,24781,44949,42711,-3492,1.00000000,1.000000000,7.000000000,23.000000000,12309,520,0,0,0,0,62400,1,25,0,0,'',0,0,0,0,0),('rawr',268463031,'SpammTimus',5,214,0,65,65,66,85,66,3,45,249,9,117,402,120,84,40,47,26,18,27,12,1,0,3,0,65434,-44278,-120479,-254,1.00000000,1.000000000,11.000000000,28.000000000,5342,154,0,0,0,0,87000,3,44,0,0,'',0,0,0,0,0),('valo',268463304,'FighterTest',3,160,157,51,51,65,132,68,2,43,200,5,115,477,122,85,40,43,30,21,25,11,2,2,2,0,55689,-74537,252739,-3341,1.00000000,1.000000000,9.000000000,23.000000000,538,34,0,0,0,0,81900,0,0,0,0,'',0,0,0,0,0),('valo',268463326,'OrcNoob',5,214,98,65,65,66,85,66,2,65,249,6,117,402,120,84,40,47,26,18,27,12,1,1,1,0,44967,-44447,-120746,-236,1.00000000,1.000000000,11.000000000,28.000000000,3510,104,0,0,0,0,87000,3,44,0,0,'',0,0,0,0,0),('rawr',268463373,'McMuffinIII',5,147,91,140,86,67,41,54,10,60,1007,4,91,392,122,85,23,24,23,44,37,19,2,1,3,1,946,12181,16675,-3626,1.00000000,1.000000000,7.000000000,23.000000000,5072,145,0,0,0,0,61000,2,38,0,0,'',0,0,0,0,0);
101