· 10 years ago · Jul 03, 2016, 05:39 PM
1-- Adminer 4.2.5 MySQL dump
2
3SET NAMES utf8;
4SET time_zone = '+00:00';
5SET foreign_key_checks = 0;
6SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
7
8INSERT INTO `account` (`id`, `username`, `sha_pass_hash`, `sessionkey`, `v`, `s`, `email`, `joindate`, `last_ip`, `failed_logins`, `locked`, `last_login`, `active_realm_id`, `expansion`, `mutetime`, `locale`, `os`) VALUES
9(1, 'LOLEE', '8301316d0d8448a34fa6d0c6bf1cbfa2b4a1a93a', '74317A60459354827DCBBB6A25A268CE23D2FAE9B59B9D6A819A0086ECF1150EFA314F3039DA4723', '5AF175E12368C8DA1FAEE99564A1D548BD1E8D93C9212821F9F5EE9DE8F3F7A9', '9789255D90C666635D105D8EB9FB5F38A1AF01884D7F5D5C501C5D3AD15D20CD', 'anatomy97@seznam.cz', '2013-02-18 05:44:12', '31.192.89.26', 0, 0, '2016-06-12 10:00:30', 0, 1, 0, 0, 'Win'),
10(2, 'ADMIN', '262de4517df30f585ee0e570062be0f70563feec', '77934C8DEA968958CDE77BB227250968702B0BF16EAFEB0E0BBE1A5DA8F11916DD3852198D8B206F', '36A2E7AD870BF95D214872C2DE5912FB2595B5EDB461BCCB7A1883A758E91854', 'E5BFABFA0ED13F1C302DB1A564E7DAEBD62EB162C13BF31D82FE5CAD79F6AA4D', NULL, '2015-10-18 14:04:28', '84.245.107.8', 0, 0, '2016-06-12 16:10:07', 0, 1, 0, 0, 'Win'),
11(79, 'MURKO', 'c64d1ef0fc42bec3d98382fd3fee139dc5243412', '4E0194C839EC3A6C28016AEFE9509B6F539799D076A67004755B525306ACB22CD1565F098C97C163', '032AB305F3AD6566CBD31194AEAB4166ED1CF8D207809EE22D9F59EE87C440F5', 'F8C39EFE61DD1BB48F87CBC0F53D3E778BD714994AD139066E5A3171BBE6EBEB', NULL, '2016-05-31 07:49:56', '217.119.117.131', 0, 0, '2016-06-12 09:41:54', 0, 1, 0, 0, 'Win'),
12(78, 'TEST', '3d0d99423e31fcc67a6745ec89d70d700344bc76', 'DD74186A48FB2F9CD06DE60E5A58A2E395CE857E80BF5884D33433EA7CF85F650196E18E1E97802D', '31F4D27271BC7C1948F4769317906BD31FD0A5803F600FDC476C1C3063F40F54', 'E871F78D5E7B78C5C31783CB1BFF304F0C4A40321B4CF391BF47952FC3744583', NULL, '2016-05-30 16:19:16', '95.103.0.11', 0, 0, '2016-06-08 16:18:01', 0, 1, 0, 0, 'Win'),
13(80, 'PATO', '7c5120989ba0c836802617556e42da9d7ecddbbb', 'F290DBFDC098737BF272BFD2DFE02DEA4E4FA1200D083CFBC1924C63EEF0AC8E981051650AF488EA', '3F6690604E43B86ABF1B1E4C64FAD1BB15D2695C5E00834C54BB66C42FA4714F', 'E70659333FA8CEECD9BCF337AE4A964B164C4F50165F7AE226BD69BB2B1731A1', NULL, '2016-05-31 08:14:13', '84.245.107.8', 0, 0, '2016-06-10 19:02:20', 0, 1, 0, 0, 'Win'),
14(82, 'PURSUIT', 'd32b107f08ab38f08cbef0517fc843244816f4cb', 'A1255F39451BB8951D8607D542CDA85636153892968145BD1C9E90B1DD8777C54924E35D6E8B1B5E', '789BD09266184DD2FC14E5F3F4ED1E24F16C0A4358AD1852DDA85F2EE66229FC', 'DF5344753B0F4873B5DD5534C7141F2B91670981DC63235853F13EBB4335E817', NULL, '2016-05-31 20:03:05', '25.108.92.68', 0, 0, '2016-06-05 08:40:31', 0, 1, 0, 0, 'Win'),
15(81, 'ZERO', 'f43e830163a451383c341fe50317cec7e08032b1', NULL, NULL, NULL, NULL, '2016-05-31 10:26:21', '127.0.0.1', 0, 0, '0000-00-00 00:00:00', 0, 1, 0, 0, ''),
16(83, 'DRUMS', '967d5678914923615600957d02812e43682306c9', 'A922EE1CD92A06B5DCF778A28740617DCA7D8D3FD6B24DFEC30973E3F4AB4D15DF3F012B30C767CB', '611A663653D35E470BF66527EFBDBE76964C5564AF0A1725570CB7527267E9E0', 'E93F666159AF8D09E97E6B0ABCA3E762C6A58BCB89380769DE41F01390C843C7', NULL, '2016-06-01 15:50:50', '178.253.154.104', 0, 0, '2016-06-09 18:36:34', 0, 1, 0, 0, 'Win'),
17(84, 'SUCHAR', 'aac07b4611a272a84cdbd14667e132d42198f48f', '1ED84D21A800FA158FF68AC1D6C6DE3429D52C8FD3468F2C6FC86F0F8D0C426F97ADE5B25ACE64CE', '6C01CDDC646833551EFBBF0523FAA0E108C033379DCD1B8F5A195CE87500A2B3', 'EFB7D85C756F41CA5000D2C3A2E9C871DFE57C63A64005776E73B0017B46E4E9', NULL, '2016-06-01 15:51:50', '25.73.64.57', 0, 0, '2016-06-01 21:44:12', 0, 1, 0, 0, 'Win'),
18(85, 'DROMEDAR', '54c04ff5ee18aa7a12c964dc5772b472cce3e6f6', '9950813D2AF37916BE71376F222BC8CA909B42E7B452FA63D84D48455DB3DA00A8E8330FD9ADAC42', '4F5AC39A69E109337FBE79A5BB32DF19EC4A50DBB52724418DE5557AF7E3E13F', 'C10873DEB71BFE02DCD82E61ECE70C6AA279BB5282A704CAECDBD810A55A2E05', NULL, '2016-06-01 15:53:32', '25.30.240.123', 0, 0, '2016-06-01 15:53:53', 0, 1, 0, 0, 'Win'),
19(86, 'PCC', '42fddf3a97bf92ab9a1eead9f00291a3dd4bb243', '4DC6DC4714C8B53E41CDFEFB1DF73792BE1FE763FE496A7BA4DC4CE821662DCBB5A4394A94FFB6E5', '42C5B1FC217973E7BB8CE57CED17B1CC584815EE34802F5C8EB51F62FF58DE46', 'D566BEA1A61617A1C2CD4AEDC44CE4CF0B82889393B4AED1806C9B1D3BCFFD87', NULL, '2016-06-01 15:53:34', '25.93.142.172', 0, 0, '2016-06-01 15:54:10', 0, 1, 0, 0, 'Win'),
20(87, 'AIWORI', 'd3e228971a9089048c7183e352678d313110b28b', '2C97771B812A05B5B37AA83408A42B62FA64B4A4DAFCE88EBE45AE1D25B4C8645EF305940AA159FD', '66EC8D8413A5DCB914ACDE94A8D860DA28E217669A56F7F0AD986390BFF06CB3', 'CCAB1E2ACDD0015FC98AB3F0DAA38EAC278581172E3E76E6DDFB3B0D54981F89', NULL, '2016-06-06 14:13:27', '91.148.25.245', 0, 0, '2016-06-12 11:06:47', 0, 1, 0, 0, 'Win'),
21(88, 'WRATHBORNE', '172344d959d640bb56b7a919079eccb29991334a', '1116A27BAA945CE34D80B6E770F37854B23B5855AEC57A2EA558C81174718DE197982350DD4B5478', '83427363200B30E5780E0AC0BF67542786ED1F2859B82BFB48EEE78BB20C4A7F', 'D0B4604E886988906280901A5F30BDAC41B95C26AFC1FD87B437D4F220B316E7', NULL, '2016-06-07 17:12:00', '37.221.251.252', 0, 0, '2016-06-12 10:31:03', 0, 1, 0, 0, 'Win'),
22(89, 'ROZMA', 'cb8a64f7d493a033edcec69849d82bddca6f5198', '21AA7FAB3BACC1AE9678A41A249D076D052054CE962C429EBED60E2FAFB5FF2AE91C277BBD2E9A8B', '555F4AD60BA9CAA31FDC7346F7C70A724302311650ED689EF5F625FEBCD6340A', 'B68CF7713697DE7F524804112940899A6E4BBB892B3560281CFC63E6F1A8AA6F', NULL, '2016-06-07 17:12:21', '77.240.178.1', 0, 0, '2016-06-12 12:54:17', 0, 1, 0, 0, 'Win'),
23(92, 'ENKO', 'c42abcb685419a1355bc26be6e78ef6d20a3fac0', NULL, NULL, NULL, NULL, '2016-06-07 17:33:37', '127.0.0.1', 0, 0, '0000-00-00 00:00:00', 0, 1, 0, 0, ''),
24(90, 'MAEGO', '7614e3244fa4700271584627cd7376d8bd18d0bb', '6914B2E7A30F0D1105975453EE5F7662EE1BC4A7DB623E78D59C8C5DF9579DF9E1D2DBFC6744D877', '5307E83488E672700301FE27339C90AB3551A721A456F4E6870500E021175647', 'FC297BCFB23B55D97140F47717B7F987320AC26F63A3E9933D47E93ED51C6541', NULL, '2016-06-07 17:23:59', '109.230.6.66', 0, 0, '2016-06-09 18:28:25', 0, 1, 0, 0, 'Win'),
25(91, 'ENERHY', '3d6bf5b4d1822c2fa757c281d756439665d8a061', NULL, '29A5F8B90803E60CC8BCDDB0E494CE8AECD529F584F6009B538990CD2010C3AD', '8F04D29C5DC4972510A5C670BBFE7A0A1F26E15EBDBE60EF20BB296E1CE67959', NULL, '2016-06-07 17:24:32', '127.0.0.1', 0, 0, '0000-00-00 00:00:00', 0, 1, 0, 0, ''),
26(93, 'MATESEK', '5cbf75b56a6e445f3bc54d85f2d435da2f22a2d4', '2F5FE475BAA1A0939D95EFF175EC2BBD55D0D9DC788AD6555351104E029D3583863C048E6D35DA17', '2EB67A45DB4BA19E87FF6E554FA1F6F351EA15616D4607CC096C96C3A64315A5', 'F89261C2C78700BBF0721928A6098028118DBD6F41D44AF4A3320EF5C9D3C0EB', NULL, '2016-06-07 17:35:48', '25.89.31.180', 0, 0, '2016-06-07 18:15:35', 0, 1, 0, 0, 'Win'),
27(94, 'CAMARO', 'a32158e086d88c28c998e1211c42ca98bd7c788e', '1FDBE30213EC728FE2DDC336C483165E24B57E47C54FA0F63DE6F50AF201FF1431019A8765470E54', '0D4FC0E3F8DA9DACB5568B93D39D2C8DBBDBD914FBA5FFC6724D3EACACF9C585', 'E879E54C29DFDFA58DDCDC8E93FDA77B16A3D03483B9269CC508E9B5D1F2477D', NULL, '2016-06-07 17:36:13', '178.255.168.88', 0, 0, '2016-06-09 18:49:16', 0, 1, 0, 0, 'Win'),
28(95, 'DONTCRY', 'd5fcf9c62705fc6652b63437012fef3ed16aaf07', '703C37F3DC8214726307D00689A3362E9F790AEDC905F7A6D301BC9A0D34CE865FA7416F2283D339', '781ECC9B51AF5DED50E87254273748B9BBBCA18063D0EA6EC7BC3E8FED497D32', 'E3AD139CA56721258F4AAE3644CFF948058481F3D8FEF374BC903685062C1E51', NULL, '2016-06-07 17:38:36', '85.159.105.6', 0, 0, '2016-06-12 16:10:48', 0, 1, 0, 0, 'Win'),
29(105, 'nowakis', '3f01e56fb404c922e3641ee846d2c1295b656522', NULL, NULL, NULL, 'nowis92@seznam.cz', '2016-06-11 20:50:35', '127.0.0.1', 0, 0, '0000-00-00 00:00:00', 0, 1, 0, 0, ''),
30(96, 'KALISKO', '29455d313f4662546c11d8e30d55626049e9a2bf', '85E21BA1BB1A72AE0312CA97ECD95D7D9EA698DACC8533A42AE0C8BABF2AB906985D611826920FD7', '4312172938A97B4F9B8FAE7C733CDAE8EFDEA360BA751A5779431C2D05984C4F', 'C808B8FDD1E36C1842F25CB366186056B9181AE3E19BABB7888CD321A74C8D21', NULL, '2016-06-09 16:36:24', '95.103.247.144', 0, 0, '2016-06-09 18:29:05', 0, 1, 0, 0, 'Win'),
31(97, 'TOM000', '127edcbcf54ecd80abbe3dd52c68abc1946ee204', '3F00E59D4E46FCE860381753920B2A6A88A049FEE7BA063DFBCEF21E386F563D901E024699CED619', '57EDFACC29C9C6B7265420750AD86B9DD0680DF94B624160638B5AA458705B30', 'E0B66A2A355D20106BDA16FD39EBF17618FA4953668ECA457C9852FF1AB1D423', NULL, '2016-06-09 16:44:56', '93.181.119.232', 0, 0, '2016-06-09 19:38:34', 0, 1, 0, 0, 'Win'),
32(98, 'MAMLSS', 'c060b0e56ff3ea70af28a4801d22fa75691654ef', NULL, NULL, NULL, NULL, '2016-06-09 16:49:24', '127.0.0.1', 0, 0, '0000-00-00 00:00:00', 0, 1, 0, 0, ''),
33(99, 'BUFFO', '896e0ad8b5cf3154b115dfb339e95a9b2dd36e33', 'F8892B70122E352EB9891804C823FED857952ADFA1CE00A95FB9E71CAC2C74CE1455FCF64FCD1EB9', '549B35AC0870E1E42EA7C5401DC5B127974C3105CF4A2971D082679D70DA7E41', 'B1469D74CBA29DC081DC00D9F3422AC82F38F1C344EF84FA560538B0BEB99D1B', NULL, '2016-06-09 16:49:58', '95.103.1.71', 0, 0, '2016-06-09 19:48:10', 0, 1, 0, 0, 'Win'),
34(100, 'GANJA50', 'a11881bdc73daca218abd0a516dea4cefefcb0fc', '42D5EAF8C8FB010A55A71C1191D64D47FB85B3E0ED6AD74800E9840A1788FE1B5F7113BB3C7A9F9F', '45316C59805418810D7D961B1B7A25E304A03CBB23E043CC9F36965E0F16B8A7', 'CCED478C9ADC6825B6FBB42467C25469297789509E5482970545A76B342221EB', NULL, '2016-06-09 16:51:53', '95.90.227.188', 0, 0, '2016-06-09 19:48:11', 0, 1, 0, 0, 'Win'),
35(101, 'PANENKA', '25345a5adc7e491a5a8d20bdfa335fec7d6ec185', '5323DBEF6560D0171EF9BFB2BAB9D411658F570F10C1665D35D665B1647B039E4697AD958C028DBD', '1CDE9414EA7102D055AC75723A7916B6E28D69FC0E8C98BC098006A7DE71E8E9', 'DE429775084372D08DCFA5001F05DB856A3BDF9B6D7736E5C55B88B512EEDF17', NULL, '2016-06-09 16:51:57', '88.212.36.49', 0, 0, '2016-06-09 18:41:33', 0, 1, 0, 0, 'Win'),
36(102, 'OMNID', 'f0a1688548395c90b2381be20d602b05243734e7', '48EE3A9FBC97C1E53F58D262B084BBAC3836C108BB6EEE9EA653F03B1805DA0C3A4EF30D914936C3', '6281ADFA7056A6149D8BF1E94C071DCA54E4FC3826E09E2483251A2D8BAD5D43', 'C1C2BB0A7A451A8BDEE0D395815D499BF299D7AE78B31B5B8F2EF026E0976E49', NULL, '2016-06-09 17:21:55', '84.245.107.8', 0, 0, '2016-06-12 14:57:05', 0, 1, 0, 0, 'Win'),
37(103, 'DEATHMETUS', '56037ebfd73f4096d12ae4dca691d1d273dfb5b4', 'F7EFA895B75F96A49E3CC669ABA2998C39533AE0E9DBFA66B9CD1576A29374FDC0835ED39BB6A28D', '2B3803B0EB1ABA1DFF43280F642D8633A940971342D0CEACE343537C74F95889', '84F2F9CB5B8FA2F7987BD30949C5561B1CC0E7E8975ABC780E129022B7F5D91D', NULL, '2016-06-09 17:24:39', '176.101.176.23', 0, 0, '2016-06-09 20:00:28', 0, 1, 0, 0, 'Win'),
38(104, 'DAKON123', '2d58cde893a6463c4fe8b631e2efba7195df37c3', '8AE89314B61850FB0D3BE84E3B064C682AE7BCCDF55B1062CC318B23E77521AF43FA1E00E0138123', '7F5778AD90C516A30589E8969A28BF2D9E8D96F8936969A7FA05A3933364F51A', 'E92B994C0C2B8F897900CD1FBC8EC019847B735B230514F38F6DBE750B2908B7', NULL, '2016-06-09 19:06:15', '84.21.97.169', 0, 0, '2016-06-09 19:55:27', 0, 1, 0, 0, 'Win'),
39(106, 'Lorny', '78e702e6ce43d00e6994cf8952a30e5aa0341acd', NULL, NULL, NULL, 'Krakenisko@centrum.sk', '2016-06-11 20:59:06', '127.0.0.1', 0, 0, '0000-00-00 00:00:00', 0, 1, 0, 0, ''),
40(107, 'mandzaks', '3cfd2b58000155800e487ef3da2d069c0f8ab2c1', NULL, NULL, NULL, 'steve.mandzak@gmail.com', '2016-06-11 21:03:25', '127.0.0.1', 0, 0, '0000-00-00 00:00:00', 0, 1, 0, 0, ''),
41(108, 'Tipekg', '456cd34f94486700d5e31501fbbc137f80d85725', NULL, NULL, NULL, 'tipekg@azet.sk', '2016-06-11 21:44:40', '127.0.0.1', 0, 0, '0000-00-00 00:00:00', 0, 1, 0, 0, ''),
42(109, 'oldbrothers', 'a076ccfe772c9c855ade88030946e14af14c7608', NULL, NULL, NULL, 'killer4433@azet.sk', '2016-06-11 22:48:42', '127.0.0.1', 0, 0, '0000-00-00 00:00:00', 0, 1, 0, 0, ''),
43(110, 'Rizek', '5122e852b094cac88d00f812e15ff461e8d09f3f', NULL, NULL, NULL, 'Marc14@seznam.cz', '2016-06-11 23:11:50', '127.0.0.1', 0, 0, '0000-00-00 00:00:00', 0, 1, 0, 0, ''),
44(111, 'blabos', '8ab80f8740ea197ba02b085636267372a2c39c13', NULL, NULL, NULL, 'mrbootik@seznam.cz', '2016-06-12 05:08:06', '127.0.0.1', 0, 0, '0000-00-00 00:00:00', 0, 1, 0, 0, ''),
45(112, 'Smudla', 'd556b90b2f737fa31a961cabf1166b3bf3566e9f', NULL, NULL, NULL, 'letoun937@seznam.cz', '2016-06-12 08:06:23', '127.0.0.1', 0, 0, '0000-00-00 00:00:00', 0, 1, 0, 0, ''),
46(114, 'cmudla', 'f9cae967b9fdec4ff72348a0a9335b40029752d5', NULL, NULL, NULL, 'griperko@centrum.sk', '2016-06-12 10:12:32', '127.0.0.1', 0, 0, '0000-00-00 00:00:00', 0, 1, 0, 0, ''),
47(113, 'vamber', 'c66437529199183662ff4724a56f5fa0dfde72e7', NULL, NULL, NULL, 'vambeond@seznam.cz', '2016-06-12 08:59:29', '127.0.0.1', 0, 0, '0000-00-00 00:00:00', 0, 1, 0, 0, '');
48
49INSERT INTO `account_access` (`id`, `gmlevel`, `RealmID`) VALUES
50(79, 50, -1),
51(80, 50, -1),
52(81, 50, -1),
53(1, 100, -1),
54(2, 50, -1),
55(87, 50, -1),
56(95, 50, -1);
57
58
59
60
61INSERT INTO `logs` (`time`, `realm`, `type`, `string`) VALUES
62(1464693412, 1, 0, 'Realm running as realm ID 1'),
63(1464693412, 1, 0, 'Using World DB: ODB 0.0.3 UP1 for OregonCore rev.55'),
64(1464693412, 1, 0, 'Will clear `logs` table of entries older than 1209600 seconds every 10 minutes.'),
65(1464693412, 1, 0, 'Using DataDir ./'),
66(1464693412, 1, 0, 'WORLD: VMap support included. LineOfSight:1, getHeight:1, indoorCheck:1, PetLOS:1'),
67(1464693412, 1, 0, 'WORLD: VMap data directory is: ./vmaps'),
68(1464693412, 1, 0, 'WORLD: MMap pathfinding enabled.'),
69(1464693412, 1, 0, 'Loading Oregon strings...'),
70(1464693412, 1, 0, '>> Loaded 762 Oregon strings from table oregon_string'),
71(1464693412, 1, 0, 'Initialize data stores...'),
72(1464693412, 1, 0, '>> Initialized 60 data stores'),
73(1464693412, 1, 0, 'Using enUS DBC Locale as default. All available DBC locales: enUS '),
74(1464693412, 1, 0, 'Loading Script Names...'),
75(1464693412, 1, 0, 'Loading Instance Template...'),
76(1464693428, 1, 0, 'Realm running as realm ID 1'),
77(1464693428, 1, 0, 'Using World DB: ODB 0.0.3 UP1 for OregonCore rev.55'),
78(1464693428, 1, 0, 'Will clear `logs` table of entries older than 1209600 seconds every 10 minutes.'),
79(1464693428, 1, 0, 'Using DataDir ./'),
80(1464693428, 1, 0, 'WORLD: VMap support included. LineOfSight:1, getHeight:1, indoorCheck:1, PetLOS:1'),
81(1464693428, 1, 0, 'WORLD: VMap data directory is: ./vmaps'),
82(1464693428, 1, 0, 'WORLD: MMap pathfinding enabled.'),
83(1464693428, 1, 0, 'Loading Oregon strings...'),
84(1464693428, 1, 0, '>> Loaded 762 Oregon strings from table oregon_string'),
85(1464693428, 1, 0, 'Initialize data stores...'),
86(1464693428, 1, 0, '>> Initialized 60 data stores'),
87(1464693428, 1, 0, 'Using enUS DBC Locale as default. All available DBC locales: enUS '),
88(1464693428, 1, 0, 'Loading Script Names...'),
89(1464693428, 1, 0, 'Loading Instance Template...'),
90(1464693436, 1, 0, 'Realm running as realm ID 1'),
91(1464693436, 1, 0, 'Using World DB: ODB 0.0.3 UP1 for OregonCore rev.55'),
92(1464693436, 1, 0, 'Will clear `logs` table of entries older than 1209600 seconds every 10 minutes.'),
93(1464693436, 1, 0, 'Using DataDir ./'),
94(1464693436, 1, 0, 'WORLD: VMap support included. LineOfSight:1, getHeight:1, indoorCheck:1, PetLOS:1'),
95(1464693436, 1, 0, 'WORLD: VMap data directory is: ./vmaps'),
96(1464693436, 1, 0, 'WORLD: MMap pathfinding enabled.'),
97(1464693436, 1, 0, 'Loading Oregon strings...'),
98(1464693436, 1, 0, '>> Loaded 762 Oregon strings from table oregon_string'),
99(1464693436, 1, 0, 'Initialize data stores...'),
100(1464693437, 1, 0, '>> Initialized 60 data stores'),
101(1464693437, 1, 0, 'Using enUS DBC Locale as default. All available DBC locales: enUS '),
102(1464693437, 1, 0, 'Loading Script Names...'),
103(1464693437, 1, 0, 'Loading Instance Template...'),
104(1464693450, 1, 0, 'Realm running as realm ID 1'),
105(1464693450, 1, 0, 'Using World DB: ODB 0.0.3 UP1 for OregonCore rev.55'),
106(1464693450, 1, 0, 'Will clear `logs` table of entries older than 1209600 seconds every 10 minutes.'),
107(1464693450, 1, 0, 'Using DataDir ./'),
108(1464693450, 1, 0, 'WORLD: VMap support included. LineOfSight:1, getHeight:1, indoorCheck:1, PetLOS:1'),
109(1464693450, 1, 0, 'WORLD: VMap data directory is: ./vmaps'),
110(1464693450, 1, 0, 'WORLD: MMap pathfinding enabled.'),
111(1464693450, 1, 0, 'Loading Oregon strings...'),
112(1464693450, 1, 0, '>> Loaded 762 Oregon strings from table oregon_string'),
113(1464693450, 1, 0, 'Initialize data stores...'),
114(1464693450, 1, 0, '>> Initialized 60 data stores'),
115(1464693450, 1, 0, 'Using enUS DBC Locale as default. All available DBC locales: enUS '),
116(1464693450, 1, 0, 'Loading Script Names...'),
117(1464693450, 1, 0, 'Loading Instance Template...'),
118(1464693663, 1, 0, 'Realm running as realm ID 1'),
119(1464693663, 1, 0, 'Using World DB: ODB 0.0.3 UP1 for OregonCore rev.55'),
120(1464693663, 1, 0, 'Will clear `logs` table of entries older than 1209600 seconds every 10 minutes.'),
121(1464693663, 1, 0, 'Using DataDir ./'),
122(1464693663, 1, 0, 'WORLD: VMap support included. LineOfSight:1, getHeight:1, indoorCheck:1, PetLOS:1'),
123(1464693663, 1, 0, 'WORLD: VMap data directory is: ./vmaps'),
124(1464693663, 1, 0, 'WORLD: MMap pathfinding enabled.'),
125(1464693663, 1, 0, 'Loading Oregon strings...'),
126(1464693663, 1, 0, '>> Loaded 762 Oregon strings from table oregon_string'),
127(1464693663, 1, 0, 'Initialize data stores...'),
128(1464693663, 1, 0, '>> Initialized 60 data stores'),
129(1464693663, 1, 0, 'Using enUS DBC Locale as default. All available DBC locales: enUS '),
130(1464693663, 1, 0, 'Loading Script Names...'),
131(1464693663, 1, 0, 'Loading Instance Template...');
132
133DROP TABLE IF EXISTS `news`;
134CREATE TABLE `news` (
135 `id` int(11) NOT NULL AUTO_INCREMENT,
136 `title` text NOT NULL,
137 `author` text NOT NULL,
138 `date` text NOT NULL,
139 `text` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
140 PRIMARY KEY (`id`)
141) ENGINE=InnoDB DEFAULT CHARSET=latin1;
142
143INSERT INTO `news` (`id`, `title`, `author`, `date`, `text`) VALUES
144(1, 'Novinka #1 EN', 'Patrik', '22.2.2012', 'Text EN'),
145(2, 'Novinka #2 EN', 'Janko', '23.3.2016', 'Text EN');
146
147DROP TABLE IF EXISTS `novinky`;
148CREATE TABLE `novinky` (
149 `id` int(11) NOT NULL AUTO_INCREMENT,
150 `title` text NOT NULL,
151 `author` text NOT NULL,
152 `date` text NOT NULL,
153 `text` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
154 PRIMARY KEY (`id`)
155) ENGINE=InnoDB DEFAULT CHARSET=latin1;
156
157INSERT INTO `novinky` (`id`, `title`, `author`, `date`, `text`) VALUES
158(1, 'Predpokladaný Å¡tart serveru', 'Murko', '12.06.2015', 'KeÄže sa veľa z vás pýta kedy bude server spustený, tak Vám dávame odpoveÄ. Predpokladaný Å¡tart serveru je teda o 10 dnÃ, to znamená 22.6 o 19:00. Ak sa nieÄo zmenÃ, alebo tak, budeme vás informovaÅ¥. Je to predpokladaný Å¡tart. Okrem toho, vÄera sme nahodili novú verziu webu, ktorá je funkÄná, do konca dňa by mala fungovaÅ¥ na 100% aj s fórom. \r\n\r\n<img alt=\"apokaliptic\" src=\"http://apokalipticwow.eu/img/start.png\" />');
159
160INSERT INTO `paypal_prices` (`id`, `Price`, `Credits`) VALUES
161(2, 115, 100),
162(3, 230, 200),
163(5, 520, 500),
164(8, 950, 1000);
165
166INSERT INTO `paysettings` (`id`, `SMS`, `PayPal`, `SMS_keyword`, `PayPal_email`) VALUES
167(1, 1, 1, 'anthelion', 'anthelion@vitprokop.cz');
168
169INSERT INTO `realmcharacters` (`realmid`, `acctid`, `numchars`) VALUES
170(1, 1, 2),
171(1, 77, 0),
172(1, 2, 9),
173(1, 78, 3),
174(1, 79, 8),
175(1, 80, 2),
176(1, 81, 0),
177(1, 82, 7),
178(1, 83, 3),
179(1, 84, 4),
180(1, 85, 1),
181(1, 86, 1),
182(1, 87, 3),
183(1, 88, 3),
184(1, 89, 2),
185(1, 90, 1),
186(1, 91, 0),
187(1, 92, 0),
188(1, 93, 1),
189(1, 94, 1),
190(1, 95, 3),
191(1, 96, 1),
192(1, 97, 2),
193(1, 98, 0),
194(1, 99, 1),
195(1, 100, 1),
196(1, 101, 1),
197(1, 102, 1),
198(1, 103, 1),
199(1, 104, 1);
200
201INSERT INTO `realmlist` (`id`, `name`, `address`, `port`, `icon`, `realmflags`, `timezone`, `allowedSecurityLevel`, `population`, `realmbuilds`) VALUES
202(1, 'ApokalipticWoW', '62.210.24.31', 8085, 1, 0, 1, 5, 0.04, '8606 ');
203
204INSERT INTO `sms_prices` (`id`, `Price`, `Credits`) VALUES
205(1, '99.00', 78),
206(2, '79.00', 50),
207(3, '50.00', 40),
208(4, '30.00', 30),
209(5, '20.00', 20),
210(6, '10.00', 15),
211(7, '3.00', 10);
212
213INSERT INTO `vip_credits` (`id`, `idn`, `Credits`) VALUES
214(1, 1, 91);
215
216INSERT INTO `vip_general` (`id`, `UpMsg`, `ServerName`) VALUES
217(1, 'Amethyst is the most wonderful gem.', 'Blizzard Entertiment');
218
219
220INSERT INTO `vip_orders` (`id`, `idn`, `character_guid`, `package_id`, `completed`) VALUES
221(1, 1, 1, 2, 1),
222(2, 1, 1, 2, 1),
223(3, 1, 1, 2, 1),
224(4, 1, 1, 3, 1);
225
226INSERT INTO `vip_packages` (`id`, `Name`, `Credits`, `Obsah`) VALUES
227(2, 'G12', '250', 'T11, G3, CM 1'),
228(3, 'Náhlavnà Sada S4', '659', 'Sada helem S4 pro všechny Classy');
229
230
231INSERT INTO `vip_sms` (`id`, `code`, `price`, `valid`) VALUES
232(1, 'aXc96AsM', '99.00', 0),
233(2, 'd2mpif', '50.00', 0);
234
235-- 2016-06-12 17:02:34