Maple-Europa.de Fan Forum

CREATE TABLE `item_stat_accessory` (
`ID` int(10) unsigned NOT NULL,
`reqJob` int(10) unsigned NOT NULL,
`reqLevel` int(10) unsigned NOT NULL,
`reqSTR` int(10) unsigned NOT NULL,
`reqDEX` int(10) unsigned NOT NULL,
`reqINT` int(10) unsigned NOT NULL,
`reqLUK` int(10) unsigned NOT NULL,
`incSTR` int(10) unsigned NOT NULL,
`incDEX` int(10) unsigned NOT NULL,
`incINT` int(10) unsigned NOT NULL,
`incLUK` int(10) unsigned NOT NULL,
`incEVA` int(10) unsigned NOT NULL,
`incPDD` int(10) unsigned NOT NULL,
`incMMP` int(10) unsigned NOT NULL,
`incMDD` int(10) unsigned NOT NULL,
`incMHP` int(10) unsigned NOT NULL,
`incJump` int(10) unsigned NOT NULL,
`incSpeed` int(10) unsigned NOT NULL,
`tuc` int(10) unsigned NOT NULL,
`only` int(10) unsigned NOT NULL,
`tradeBlock` int(10) unsigned NOT NULL,
`price` int(10) unsigned NOT NULL,
`cash` int(10) unsigned NOT NULL,
`notSale` int(10) unsigned NOT NULL,
`timeLimited` int(10) unsigned NOT NULL,
`reqPOP` int(10) unsigned NOT NULL,
`tradeAvailable` int(10) unsigned NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `maps_alt` (`monster`,`anz`) VALUES
(100100,12),
(100101,19),
(1110100,12),
(1110101,15),
(1120100,5),
(1130100,9),
(1140100,5),
(120100,,
(1210100,15),
(1210101,9),
(1210102,1,
(1210103,6),
(130100,16),
(130101,23),
(2100100,2),
(2100101,2),
(2100102,2),
(2100103,3),
(2100104,2),
(2100105,2),
(2100106,3),
(2100107,2),
(2100108,2),
(210100,20),
(2110200,20),
(2110300,4),
(2110301,3),
(2130100,1,
(2130103,12),
(2220000,1),
(2220100,,
(2230100,10),
(2230101,16),
(2230102,7),
(2230103,9),
(2230104,2),
(2230105,3),
(2230106,2),
(2230107,2),
(2230108,2),
(2230109,2),
(2230110,3),
(2230111,2),
(2230200,3),
(2300100,5),
(3000000,4),
(3000001,4),
(3000005,9),
(3000006,2),
(3100101,3),
(3100102,3),
(3110100,4),
(3110101,10),
(3110102,6),
(3110300,2),
(3110301,2),
(3110302,3),
(3110303,2),
(3210100,4),
(3210200,2),
(3210201,2),
(3210202,2),
(3210203,9),
(3210204,4),
(3210205,10),
(3210206,6),
(3210207,1),
(3210208,3),
(3210450,3),
(3210800,9),
(3220000,1),
(3220001,1),
(3230100,3),
(3230101,4),
(3230102,5),
(3230103,2),
(3230104,2),
(3230200,4),
(3230300,7),
(3230302,,
(3230303,3),
(3230304,4),
(3230305,5),
(3230306,2),
(3230307,3),
(3230308,3),
(3230400,11),
(3230405,2),
(4110300,2),
(4110301,1),
(4110302,2),
(4130100,1),
(4130101,2),
(4130102,1),
(4130103,1),
(4220000,1),
(4230100,,
(4230101,,
(4230102,4),
(4230103,2),
(4230104,3),
(4230105,1),
(4230106,5),
(4230107,6),
(4230108,4),
(4230109,6),
(4230110,3),
(4230111,7),
(4230112,4),
(4230113,2),
(4230114,2),
(4230115,2),
(4230116,4),
(4230117,3),
(4230118,3),
(4230119,5),
(4230120,,
(4230121,6),
(4230123,2),
(4230124,2),
(4230125,3),
(4230126,3),
(4230200,2),
(4230201,3),
(4230300,3),
(4230400,1),
(4230500,2),
(4230501,3),
(4230502,3),
(4230503,2),
(4230504,2),
(4230505,2),
(4230506,4),
(4230600,2),
(4240000,4),
(4250000,3),
(4250001,3),
(5090000,2),
(5090001,1),
(5100000,5),
(5100002,3),
(5100003,6),
(5100004,3),
(5100005,5),
(5110300,1),
(5110301,3),
(5110302,2),
(5120000,2),
(5120001,2),
(5120002,2),
(5120003,2),
(5120100,1),
(5120500,3),
(5120501,4),
(5120502,2),
(5120503,3),
(5120504,3),
(5120505,4),
(5120506,3),
(5130100,4),
(5130101,6),
(5130102,4),
(5130103,2),
(5130104,7),
(5130105,3),
(5130107,4),
(5130108,4),
(5140000,10),
(5150000,2),
(5150001,5),
(5200000,7),
(5200001,4),
(5200002,4),
(5220000,1),
(5220002,2),
(5220003,3),
(5250000,2),
(5250001,3),
(5250002,1),
(5300000,4),
(5300001,4),
(5300100,2),
(5400000,3),
(6090000,4),
(6090001,3),
(6090003,1),
(6090004,3),
(6110300,1),
(6110301,3),
(6130100,2),
(6130101,1),
(6130103,1),
(6130200,1),
(6130202,2),
(6130203,3),
(6130204,3),
(6130207,3),
(6130208,4),
(6130209,3),
(6220000,2),
(6220001,1),
(6230100,2),
(6230200,1),
(6230300,1),
(6230400,1),
(6230401,1),
(6230500,1),
(6230600,3),
(6230601,2),
(6230602,5),
(6300000,3),
(6300005,1),
(6300100,2),
(6400000,3),
(6400100,1),
(7090000,1),
(7110300,1),
(7110301,2),
(7130000,3),
(7130001,3),
(7130002,2),
(7130003,2),
(7130004,2),
(7130010,1),
(7130020,3),
(7130100,4),
(7130101,2),
(7130102,2),
(7130103,2),
(7130104,3),
(7130200,2),
(7130300,1),
(7130400,1),
(7130401,1),
(7130402,1),
(7130500,3),
(7130501,3),
(7130600,2),
(7130601,2),
(7140000,1),
(7160000,1),
(7220000,1),
(7220001,1),
(7220002,2),
(8090000,1),
(8110300,1),
(8130100,1),
(8140000,3),
(8140001,3),
(8140002,2),
(8140100,1),
(8140101,5),
(8140102,5),
(8140103,5),
(8140110,3),
(8140111,2),
(8140200,1),
(8140300,1),
(8140500,2),
(8140600,1),
(8140700,2),
(8140701,3),
(8140702,1),
(8140703,1),
(8141000,1),
(8141100,1),
(8141300,2),
(8142000,1),
(8142100,1),
(8143000,1),
(8150000,1),
(8150100,1),
(8150101,1),
(8150200,6),
(8150201,5),
(8150300,5),
(8150301,5),
(8150302,5),
(8160000,1),
(8170000,1),
(8180000,1),
(8180001,1),
(8190000,3),
(8190002,3),
(8190003,3),
(8190004,4),
(8200000,14),
(8200001,1),
(8200002,1),
(8200003,2),
(8200004,2),
(8200005,1),
(8200006,1),
(8200007,2),
(8200008,2),
(8200009,1),
(8200010,1),
(8200011,2),
(8200012,2),
(8220000,1),
(8220001,1),
(8220002,1),
(8220003,1),
(8220004,1),
(8220005,1),
(8220006,1),
(8500002,1),
(8510000,1),
(8800002,1),
(8810018,1),
(8820000,0),
(9300003,1),
(9300012,1),
(9300028,1),
(9300039,1),
(9300119,1),
(9300139,1),
(9300182,1),
(9300215,1),
(9300274,2),
(9500317,1),

$von = $libr * 1000;
$bis = $libr;
$bis .= 9999;