Guest User

Untitled

a guest
Oct 23rd, 2019
115
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.4.10
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Host: localhost
  6. -- Generation Time: Oct 22, 2019 at 07:45 PM
  7. -- Server version: 5.5.37
  8. -- PHP Version: 5.4.27
  9.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. SET time_zone = "+00:00";
  12.  
  13.  
  14. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  15. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  16. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  17. /*!40101 SET NAMES utf8mb4 */;
  18.  
  19. --
  20. -- Database: `Gytis_wwe`
  21. --
  22.  
  23. -- --------------------------------------------------------
  24.  
  25. --
  26. -- Table structure for table `apsaugos_kodas`
  27. --
  28.  
  29. CREATE TABLE IF NOT EXISTS `apsaugos_kodas` (
  30. `ID` int(11) NOT NULL,
  31. `kodas` varchar(4) COLLATE utf8_lithuanian_ci NOT NULL,
  32. `dienos_laikas` int(11) NOT NULL,
  33. `dienos_laikas2` int(11) NOT NULL,
  34. `prizas` int(11) NOT NULL,
  35. `vakar_laimejo_1` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL,
  36. `vakar_laimejo_2` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL,
  37. `vakar_laimejo_3` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL,
  38. `reg` int(11) NOT NULL,
  39. `raw_at` int(11) NOT NULL,
  40. `smack_at` int(11) NOT NULL,
  41. `nxt_at` int(11) NOT NULL,
  42. `max_on` int(11) NOT NULL,
  43. `max_on_siandien` int(11) NOT NULL,
  44. `diena` varchar(11) COLLATE utf8_lithuanian_ci NOT NULL,
  45. `daugiausiai_veiksmu` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL,
  46. `daugiausiai_veiksmu_1` int(11) NOT NULL
  47. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_lithuanian_ci;
  48.  
  49. --
  50. -- Dumping data for table `apsaugos_kodas`
  51. --
  52.  
  53. INSERT INTO `apsaugos_kodas` (`ID`, `kodas`, `dienos_laikas`, `dienos_laikas2`, `prizas`, `vakar_laimejo_1`, `vakar_laimejo_2`, `vakar_laimejo_3`, `reg`, `raw_at`, `smack_at`, `nxt_at`, `max_on`, `max_on_siandien`, `diena`, `daugiausiai_veiksmu`, `daugiausiai_veiksmu_1`) VALUES
  54. ('Admin',1234,500,100,300,'Admin','Admin','Admin',1,1,1,1,1,24,15);
  55. -- --------------------------------------------------------
  56.  
  57. --
  58. -- Table structure for table `balsavimas`
  59. --
  60.  
  61. CREATE TABLE IF NOT EXISTS `balsavimas` (
  62. `ID` int(11) NOT NULL,
  63. `autorius` varchar(30) NOT NULL,
  64. `data` varchar(20) NOT NULL,
  65. `klausimas` varchar(300) NOT NULL,
  66. `atsakymas_1` varchar(200) NOT NULL,
  67. `atsakymas_2` varchar(200) NOT NULL,
  68. `atsakymas_3` varchar(200) NOT NULL
  69. ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
  70.  
  71. --
  72. -- Dumping data for table `balsavimas`
  73. --
  74.  
  75. INSERT INTO `balsavimas` (`ID`, `autorius`, `data`, `klausimas`, `atsakymas_1`, `atsakymas_2`, `atsakymas_3`) VALUES
  76. (1,'Admin','2019.10.22','arba','labas','labas1','labas2','labas3');
  77. -- --------------------------------------------------------
  78.  
  79. --
  80. -- Table structure for table `balsavimo_rezultatai`
  81. --
  82.  
  83. CREATE TABLE IF NOT EXISTS `balsavimo_rezultatai` (
  84. `laikas` int(11) NOT NULL,
  85. `nick` varchar(50) NOT NULL,
  86. `atsakymas` int(11) NOT NULL
  87. ) ENGINE=InnoDB AUTO_INCREMENT=81 DEFAULT CHARSET=utf8;
  88.  
  89. --
  90. -- Dumping data for table `balsavimo_rezultatai`
  91. --
  92.  
  93. INSERT INTO `balsavimo_rezultatai` (`laikas`, `nick`, `atsakymas`) VALUES
  94. ('22:04','Admin','labas1');
  95. -- --------------------------------------------------------
  96.  
  97. --
  98. -- Table structure for table `drabuzine`
  99. --
  100.  
  101. CREATE TABLE IF NOT EXISTS `drabuzine` (
  102. `ID` int(11) NOT NULL,
  103. `kovotojas` varchar(50) NOT NULL,
  104. `kaina` int(11) NOT NULL,
  105. `nr` int(11) NOT NULL
  106. ) ENGINE=InnoDB AUTO_INCREMENT=93 DEFAULT CHARSET=utf8;
  107.  
  108. --
  109. -- Dumping data for table `drabuzine`
  110. --
  111.  
  112. INSERT INTO `drabuzine` (`ID`, `kovotojas`, `kaina`, `nr`) VALUES
  113. (1, 'Seth Rollins', 2, 1),
  114. (2, 'Seth Rollins', 4, 2),
  115. (4, 'Triple H', 2, 1),
  116. (7, 'Seth Rollins', 6, 3),
  117. (8, 'Brock Lesnar', 2, 1),
  118. (9, 'Brock Lesnar', 4, 2),
  119. (10, 'Brock Lesnar', 6, 3),
  120. (11, 'Dolph Ziggler', 2, 1),
  121. (12, 'Dolph Ziggler', 4, 2),
  122. (13, 'Dolph Ziggler', 6, 3),
  123. (14, 'Big Show', 2, 1),
  124. (15, 'Big Show', 4, 2),
  125. (16, 'Big Show', 6, 3),
  126. (17, 'John Cena', 2, 1),
  127. (18, 'Paige', 2, 1),
  128. (19, 'Paige', 4, 2),
  129. (20, 'Paige', 6, 3),
  130. (21, 'Maryse', 2, 1),
  131. (22, 'Maryse', 4, 2),
  132. (23, 'Maryse', 6, 3),
  133. (24, 'Lana', 2, 1),
  134. (25, 'Lana', 4, 2),
  135. (26, 'Lana', 6, 3),
  136. (27, 'Nikki Bella', 2, 1),
  137. (28, 'Nikki Bella', 4, 2),
  138. (29, 'Nikki Bella', 6, 3),
  139. (30, 'Kelly Kelly', 2, 1),
  140. (31, 'Kelly Kelly', 4, 2),
  141. (32, 'Kelly Kelly', 6, 3),
  142. (33, 'Trish Stratus', 2, 1),
  143. (34, 'Trish Stratus', 4, 2),
  144. (35, 'Trish Stratus', 6, 3),
  145. (36, 'John Cena', 2, 2),
  146. (37, 'John Cena', 4, 3),
  147. (38, 'Randy Orton', 2, 1),
  148. (39, 'Randy Orton', 4, 2),
  149. (40, 'Randy Orton', 6, 3),
  150. (41, 'Daniel Bryan', 2, 1),
  151. (42, 'Daniel Bryan', 4, 2),
  152. (43, 'Daniel Bryan', 6, 3),
  153. (47, 'Roman Reigns', 2, 1),
  154. (48, 'Roman Reigns', 4, 2),
  155. (49, 'Roman Reigns', 6, 3),
  156. (50, 'Kofi Kingston', 2, 1),
  157. (51, 'Kofi Kingston', 4, 2),
  158. (52, 'Kofi Kingston', 6, 3),
  159. (53, 'Finn Balor', 2, 1),
  160. (54, 'Finn Balor', 4, 2),
  161. (55, 'Finn Balor', 6, 3),
  162. (59, 'Triple H', 4, 2),
  163. (60, 'Triple H', 6, 3),
  164. (61, 'AJ Styles', 2, 1),
  165. (62, 'AJ Styles', 4, 2),
  166. (63, 'AJ Styles', 6, 3),
  167. (64, 'The Miz', 2, 1),
  168. (65, 'The Miz', 4, 2),
  169. (66, 'The Miz', 6, 3),
  170. (67, 'Jeff Hardy', 2, 1),
  171. (68, 'Jeff Hardy', 4, 2),
  172. (69, 'Jeff Hardy', 6, 3),
  173. (70, 'Dean Ambrose', 2, 1),
  174. (71, 'Dean Ambrose', 4, 2),
  175. (72, 'Dean Ambrose', 6, 3),
  176. (74, 'Torrie Wilson', 2, 1),
  177. (75, 'Torrie Wilson', 4, 2),
  178. (76, 'Torrie Wilson', 6, 3),
  179. (77, 'The Undertaker', 2, 1),
  180. (78, 'The Undertaker', 4, 2),
  181. (79, 'The Undertaker', 6, 3),
  182. (80, 'Zack Ryder', 2, 1),
  183. (81, 'Zack Ryder', 4, 2),
  184. (82, 'Zack Ryder', 6, 3),
  185. (83, 'DDP', 2, 2),
  186. (84, 'Dean Ambrose', 50000, 4),
  187. (85, 'Seth Rollins', 10000, 4),
  188. (86, 'Alexa Bliss ', 2, 1),
  189. (87, 'Alexa Bliss ', 4, 2),
  190. (88, 'Sasha Banks', 10000000, 1),
  191. (89, 'Randy Orton', 1000000, 4),
  192. (90, 'Batista', 1, 1),
  193. (91, 'Eddie Guerrero', 1, 1),
  194. (92, 'Becky Lynch', 50000000, 5);
  195.  
  196. -- --------------------------------------------------------
  197.  
  198. --
  199. -- Table structure for table `duk`
  200. --
  201.  
  202. CREATE TABLE IF NOT EXISTS `duk` (
  203. `ID` int(11) NOT NULL,
  204. `nick` varchar(20) NOT NULL,
  205. `klausimas` text NOT NULL,
  206. `atsakymas` text NOT NULL
  207. ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
  208.  
  209. --
  210. -- Dumping data for table `duk`
  211. --
  212.  
  213. INSERT INTO `duk` (`ID`, `nick`, `klausimas`, `atsakymas`) VALUES
  214. (1, 'Admin', 'Kas yra Level?', 'Level, kitaip tariant, jūsų pagrindinis lygis. Turint didesni lygį, atsiveria didesnės galimybės žaidime.'),
  215. (2, 'Admin', 'Kas yra Energy?', 'Kuo didesnis jūsų Energy tuo didesnė galimybė padaryti didesnė žalą varžovui ringe.');
  216.  
  217. -- --------------------------------------------------------
  218.  
  219. --
  220. -- Table structure for table `komandos`
  221. --
  222.  
  223. CREATE TABLE IF NOT EXISTS `komandos` (
  224. `ID` int(11) NOT NULL,
  225. `vadas` varchar(50) NOT NULL,
  226. `pavadinimas` varchar(50) NOT NULL,
  227. `veiksmai` int(11) NOT NULL,
  228. `kreditai` varchar(5) NOT NULL DEFAULT '0.0',
  229. `pinigai` int(11) NOT NULL,
  230. `viso_veiksmu` int(11) NOT NULL,
  231. `alga` int(11) NOT NULL
  232. ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;
  233.  
  234. --
  235. -- Dumping data for table `komandos`
  236. --
  237.  
  238. INSERT INTO `komandos` (`ID`, `vadas`, `pavadinimas`, `veiksmai`, `kreditai`, `pinigai`, `viso_veiksmu`, `alga`) VALUES
  239.  
  240.  
  241. -- --------------------------------------------------------
  242.  
  243. --
  244. -- Table structure for table `komentarai`
  245. --
  246.  
  247. CREATE TABLE IF NOT EXISTS `komentarai` (
  248. `ID` int(11) NOT NULL,
  249. `nick` varchar(50) NOT NULL,
  250. `kam` varchar(50) NOT NULL,
  251. `zinute` text NOT NULL,
  252. `data` varchar(50) NOT NULL
  253. ) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8;
  254.  
  255. --
  256. -- Dumping data for table `komentarai`
  257. --
  258.  
  259. INSERT INTO `komentarai` (`ID`, `nick`, `kam`, `zinute`, `data`) VALUES
  260.  
  261.  
  262. -- --------------------------------------------------------
  263.  
  264. --
  265. -- Table structure for table `kovos`
  266. --
  267.  
  268. CREATE TABLE IF NOT EXISTS `kovos` (
  269. `ID` int(11) NOT NULL,
  270. `pavadinimas` varchar(50) NOT NULL,
  271. `lygis` int(11) NOT NULL,
  272. `duos_lygio` varchar(10) NOT NULL,
  273. `duos_jegos` varchar(10) NOT NULL,
  274. `duos_vikrumo` varchar(10) NOT NULL,
  275. `duos_pinigu` varchar(10) NOT NULL,
  276. `duos_points` varchar(10) NOT NULL,
  277. `foto` varchar(50) NOT NULL
  278. ) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;
  279.  
  280. --
  281. -- Dumping data for table `kovos`
  282. --
  283.  
  284. INSERT INTO `kovos` (`ID`, `pavadinimas`, `lygis`, `duos_lygio`, `duos_jegos`, `duos_vikrumo`, `duos_pinigu`, `duos_points`, `foto`) VALUES
  285. (1, 'Adam Cole', 1, '0.2', '0.1', '0.1', '10', '0.2', '1.gif'),
  286. (2, 'Aleister Black', 100, '0.3', '0.1', '0.2', '12', '0.2', '2.gif'),
  287. (3, 'Angelo Dawkins', 300, '0.3', '0.2', '0.2', '14', '0.3', '3.gif'),
  288. (4, 'Bobby Fish', 800, '0.4', '0.2', '0.3', '16', '0.3', '4.gif'),
  289. (5, 'Johnny Gargano', 1000, '0.4', '0.3', '0.3', '18', '0.4', '5.gif'),
  290. (6, 'Akam', 2000, '0.5', '0.3', '0.4', '20', '0.4', '6.gif'),
  291. (7, 'Apollo Crews', 3000, '0.5', '0.4', '0.4', '22', '0.5', '7.gif'),
  292. (8, 'Baron Corbin', 4000, '0.6', '0.4', '0.5', '24', '0.5', '8.gif'),
  293. (9, 'Bo Dallas', 5000, '0.6', '0.5', '0.5', '26', '0.6', '9.gif'),
  294. (10, 'Bobby Roode', 6000, '0.7', '0.5', '0.6', '28', '0.6', ''),
  295. (11, 'Curt Hawkins', 7000, '0.7', '0.6', '0.6', '30', '0.7', ''),
  296. (12, 'Big Show', 9000, '0.7', '0.6', '0.7', '35', '0.7', '12.gif'),
  297. (13, 'Braun Strowman', 11000, '0.7', '0.7', '0.7', '38', '0.7', '13.gif'),
  298. (14, 'Brock Lesnar', 13000, '0.8', '0.7', '0.7', '39', '0.7', '14.gif'),
  299. (15, 'Bray Wyatt', 20000, '0.8', '0.7', '0.8', '41', '0.7', '15.gif'),
  300. (16, 'Dean Ambrose', 30000, '0.8', '0.8', '0.8', '41', '0.7', '16.gif'),
  301. (17, 'Goldust', 40000, '0.8', '0.8', '0.9', '41', '0.8', '17.gif'),
  302. (18, 'Dolph Ziggler', 50000, '0.8', '0.9', '0.9', '42', '0.8', '18.gif'),
  303. (19, 'John Cena', 70000, '0.8', '0.9', '1', '44', '0.9', '19.gif');
  304.  
  305. -- --------------------------------------------------------
  306.  
  307. --
  308. -- Table structure for table `kovotojai`
  309. --
  310.  
  311. CREATE TABLE IF NOT EXISTS `kovotojai` (
  312. `ID` int(11) NOT NULL,
  313. `pavadinimas` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL,
  314. `lytis` varchar(10) COLLATE utf8_lithuanian_ci NOT NULL
  315. ) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8 COLLATE=utf8_lithuanian_ci;
  316.  
  317. --
  318. -- Dumping data for table `kovotojai`
  319. --
  320.  
  321. INSERT INTO `kovotojai` (`ID`, `pavadinimas`, `lytis`) VALUES
  322. (1, 'The Miz', 'Vyras'),
  323. (2, 'John Cena', 'Vyras'),
  324. (4, 'Dolph Ziggler', 'Vyras'),
  325. (5, 'Seth Rollins', 'Vyras'),
  326. (6, 'Triple H', 'Vyras'),
  327. (7, 'Kelly Kelly', 'Moteris'),
  328. (8, 'Nikki Bella', 'Moteris'),
  329. (9, 'Lana', 'Moteris'),
  330. (10, 'Maryse', 'Moteris'),
  331. (11, 'Paige', 'Moteris'),
  332. (12, 'Trish Stratus', 'Moteris'),
  333. (13, 'Roman Reigns', 'Vyras'),
  334. (14, 'Kofi Kingston', 'Vyras'),
  335. (15, 'Fin Balor', 'Vyras'),
  336. (16, 'AJ Styles', 'Vyras'),
  337. (17, 'Dean Ambrose', 'Vyras'),
  338. (18, 'Jeff Hardy', 'Vyras'),
  339. (19, 'Randy Orton', 'Vyras'),
  340. (20, 'Daniel Bryan', 'Vyras'),
  341. (21, 'Brock Lesnar', 'Vyras'),
  342. (22, 'Torrie Wilson', 'Moteris'),
  343. (23, 'The Undertaker', 'Vyras'),
  344. (24, 'Zack Ryder', 'Vyras'),
  345. (25, 'Rusev', 'Vyras'),
  346. (26, 'Kewin Owens', 'Vyras'),
  347. (27, 'Rhyno', 'Vyras'),
  348. (28, 'Braun Strowman', 'Vyras'),
  349. (29, 'Becky Lynch', 'Moteris');
  350.  
  351. -- --------------------------------------------------------
  352.  
  353. --
  354. -- Table structure for table `lygos`
  355. --
  356.  
  357. CREATE TABLE IF NOT EXISTS `lygos` (
  358. `ID` int(11) NOT NULL,
  359. `pavadinimas` varchar(50) NOT NULL,
  360. `gm` varchar(50) NOT NULL
  361. ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
  362.  
  363. --
  364. -- Dumping data for table `lygos`
  365. --
  366.  
  367. INSERT INTO `lygos` (`ID`, `pavadinimas`, `gm`) VALUES
  368. (1, 'Raw', 'kingofdeath'),
  369. (2, 'Smackdown', 'lunatic'),
  370. (5, 'Nxt', '');
  371.  
  372. -- --------------------------------------------------------
  373.  
  374. --
  375. -- Table structure for table `naujienos`
  376. --
  377.  
  378. CREATE TABLE IF NOT EXISTS `naujienos` (
  379. `ID` int(11) NOT NULL,
  380. `naujiena` text NOT NULL,
  381. `nick` varchar(20) NOT NULL,
  382. `data` varchar(20) NOT NULL
  383. ) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8;
  384.  
  385. --
  386. -- Dumping data for table `naujienos`
  387. --
  388.  
  389. INSERT INTO `naujienos` (`ID`, `naujiena`, `nick`, `data`) VALUES
  390. (4, 'Pagražintas startui online, ideti superstar foto kovose.', 'Winston', '2019-08-08 / 22:28'),
  391. (5, 'Sukurtas auto kovu pirkimas. Zaideju prasymu padariau. Aptvarkytos kelios klaidos zaidime.', 'Winston', '2019-08-10 / 14:52'),
  392. (6, 'Kredituose įdėta nuovargio limito didinimas.', 'Winston', '2019-08-10 / 18:38'),
  393. (7, 'Patobulintas dienos konkursas. Dabar žinosite 3 vakarykčius buvusius laimėtojus, bei daugiausiai atlikusi žaidėja veiksmų per dieną.', 'Winston', '2019-08-10 / 22:59'),
  394. (8, 'Lygose įdėta papildoma informacija apie kovas ir kaip pasirašyti kontrakta su lyga. Einam paskaityt.', 'Winston', '2019-08-10 / 23:31'),
  395. (9, 'Yra labai aktyvių kovotojų žaidime. Tai pridėjau kovotojų daugiau kovojimo lauke. Taip pat, ir kai kuriuos pasiekimius.', 'Winston', '2019-08-11 / 18:55'),
  396. (10, 'Sukurti kontraktai. Gauti galima kovose. Gave siunciam generaliniui direktoriui. Ir galite registruotis del titulu.', 'Winston', '2019-08-12 / 22:18'),
  397. (11, 'Pagražintas stilius.', 'Winston', '2019-08-13 / 16:11'),
  398. (12, 'Šiandien 20:00 val, dalybos!! Kviečiu visus WWE fanus susirinkti šia valanda.', 'Winston', '2019-08-14 / 14:58'),
  399. (13, 'Nuo šiol matysite žaidejo informacijoje kokioje lygoje priklauso žaidėjas.', 'Winston', '2019-08-15 / 22:07'),
  400. (14, 'Patobulintos komandos, atnaujinimas padarytas vakar, tik šiandien ji rašau. Taip pat eina daryti pervedimus žaidėjams.', 'Winston', '2019-08-16 / 16:11'),
  401. (15, 'Online rekordas 10! Visi gavote kurie buvo po kreditą dovanos iš manęs.', 'Winston', '2019-08-16 / 16:26'),
  402. (16, 'Nuo šiol nuovargi atskaičiuos po -0,5 o nebe -1. Kadangi per dažnai gal kiek tekdavo miegučio eit. Primenu, šiandien 22:00 Lunatic Vs Vipepipe didysis show dėl IC titulo! Prisijunge, gaus visi po 500 points!', 'Winston', '2019-08-16 / 19:52'),
  403. (18, 'Sukurtas sporto klubas. Dabar turėsite kur išleidinėti Money. ;)', 'Winston', '2019-08-18 / 13:01'),
  404. (19, 'Dabar žaidimo topuose, rasite ir lygių topus.', 'Winston', '2019-08-18 / 19:23'),
  405. (20, 'Papildytos komandu funkcijos.', 'Winston', '2019-08-19 / 06:06'),
  406. (21, 'Lygose sudėti mandresni photo titulų užrašams. Ačiū mūsų žaidėjui Hariok!', 'Winston', '2019-08-19 / 20:40'),
  407. (22, 'Sukurta reputacijos davimas zaidejams.', 'Winston', '2019-08-20 / 06:13'),
  408. (23, 'Sutvarkyti pervedimai, buvo pora bugeriu kurie pasinaudojo. Dabar bus ok.', 'Winston', '2019-08-20 / 22:12'),
  409. (24, 'Sukurta balsavimo sistema', 'Winston', '2019-08-21 / 16:58'),
  410. (25, 'Nuo dabar galesite iseiti is komandos', 'Winston', '2019-08-21 / 18:06'),
  411. (26, 'Sukurtas nuovargio limito didinimas. Rasite kovose.', 'Winston', '2019-08-22 / 15:52'),
  412. (27, 'Sukurta žaidimo valdžia. Mieste galėsite peržiurėti.', 'Winston', '2019-08-22 / 17:50'),
  413. (28, 'Online padaryta naujovė. Paspaudus ant šiandien daugiausiai prisijungusiu skaičiaus, jums išmes visa istorija visu dienu kiek ta diena buvo daugiausiai prisijungusiu.', 'Winston', '2019-08-22 / 18:10'),
  414. (29, 'Sukurtas normalus DUK. Kas neaišku, galėsite paklausti administracija padės.', 'Winston', '2019-08-23 / 15:47'),
  415. (30, 'Sutvarkyti pretedentai del titulu.', 'Winston', '2019-09-17 / 20:54'),
  416. (31, 'Padidinti prizai dienos konkurse', 'Winston', '2019-09-17 / 20:55'),
  417. (32, 'Ragistracija išjungta, naujas Savininkas naujos įdėjos naujos mintis greitu metu bus svetainės restartas viskas nuo 0. Prašom grįšti kas pabėgot pagarbiai Naujas Savininkas.', 'Winston', '2019-10-22 / 17:53');
  418.  
  419. -- --------------------------------------------------------
  420.  
  421. --
  422. -- Table structure for table `naujienu_reputacija`
  423. --
  424.  
  425. CREATE TABLE IF NOT EXISTS `naujienu_reputacija` (
  426. `ID` int(11) NOT NULL,
  427. `nick` varchar(20) NOT NULL,
  428. `vertinimas` int(11) NOT NULL,
  429. `kam` int(11) NOT NULL
  430. ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
  431.  
  432. --
  433. -- Dumping data for table `naujienu_reputacija`
  434. --
  435.  
  436. INSERT INTO `naujienu_reputacija` (`ID`, `nick`, `vertinimas`, `kam`) VALUES
  437.  
  438.  
  439. -- --------------------------------------------------------
  440.  
  441. --
  442. -- Table structure for table `online`
  443. --
  444.  
  445. CREATE TABLE IF NOT EXISTS `online` (
  446. `ID` int(11) NOT NULL,
  447. `nick` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL,
  448. `vieta` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL,
  449. `laikas` int(11) NOT NULL,
  450. `online` int(11) NOT NULL,
  451. `narsykle` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL,
  452. `statusas` int(11) NOT NULL
  453. ) ENGINE=InnoDB AUTO_INCREMENT=5168 DEFAULT CHARSET=utf8 COLLATE=utf8_lithuanian_ci;
  454.  
  455. --
  456. -- Dumping data for table `online`
  457. --
  458.  
  459. INSERT INTO `online` (`ID`, `nick`, `vieta`, `laikas`, `online`, `narsykle`, `statusas`) VALUES
  460. (5165, 'Winston', 'Administratoriaus meniu', 1571762724, 1571762424, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWeb', 2),
  461. (5167, 'Admin', 'Žaidime', 1571762807, 1571762507, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWeb', 0);
  462.  
  463. -- --------------------------------------------------------
  464.  
  465. --
  466. -- Table structure for table `online_list`
  467. --
  468.  
  469. CREATE TABLE IF NOT EXISTS `online_list` (
  470. `ID` int(11) NOT NULL,
  471. `online` int(11) NOT NULL,
  472. `data` varchar(20) NOT NULL
  473. ) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=utf8;
  474.  
  475. --
  476. -- Dumping data for table `online_list`
  477. --
  478.  
  479. INSERT INTO `online_list` (`ID`, `online`, `data`) VALUES
  480. (212, 'Admin',2019.10.23);
  481.  
  482. -- --------------------------------------------------------
  483.  
  484. --
  485. -- Table structure for table `parduotuve`
  486. --
  487.  
  488. CREATE TABLE IF NOT EXISTS `parduotuve` (
  489. `ID` int(11) NOT NULL,
  490. `pavadinimas` varchar(50) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL,
  491. `kaina` int(11) NOT NULL
  492. ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
  493.  
  494. --
  495. -- Dumping data for table `parduotuve`
  496. --
  497.  
  498. INSERT INTO `parduotuve` (`ID`, `pavadinimas`, `kaina`) VALUES
  499. (1, 'Mikrafonas', 1),
  500. (4, 'Kede', 4),
  501. (5, 'Kujis', 8);
  502.  
  503. -- --------------------------------------------------------
  504.  
  505. --
  506. -- Table structure for table `pasiekimai`
  507. --
  508.  
  509. CREATE TABLE IF NOT EXISTS `pasiekimai` (
  510. `ID` int(11) NOT NULL,
  511. `reikia` int(11) NOT NULL,
  512. `atlygis` int(11) NOT NULL,
  513. `pasiekimas` int(11) NOT NULL,
  514. `pasiekimo_nr` int(11) NOT NULL
  515. ) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=utf8;
  516.  
  517. --
  518. -- Dumping data for table `pasiekimai`
  519. --
  520.  
  521. INSERT INTO `pasiekimai` (`ID`, `reikia`, `atlygis`, `pasiekimas`, `pasiekimo_nr`) VALUES
  522. (1, 150, 150, 1, 1),
  523. (2, 500, 500, 1, 2),
  524. (3, 1000, 1000, 1, 3),
  525. (4, 2000, 2000, 1, 4),
  526. (5, 3000, 3000, 1, 5),
  527. (6, 4000, 4000, 1, 6),
  528. (7, 5000, 5000, 1, 7),
  529. (8, 6000, 6000, 1, 8),
  530. (14, 7000, 7000, 1, 9),
  531. (15, 150, 150, 2, 1),
  532. (16, 500, 500, 2, 2),
  533. (17, 1000, 1000, 2, 3),
  534. (18, 2000, 2000, 2, 4),
  535. (19, 3000, 3000, 2, 5),
  536. (20, 4000, 4000, 2, 6),
  537. (21, 5000, 5000, 2, 7),
  538. (22, 6000, 6000, 2, 8),
  539. (23, 7000, 7000, 2, 9),
  540. (24, 150, 150, 3, 1),
  541. (25, 500, 500, 3, 2),
  542. (26, 1000, 1000, 3, 3),
  543. (27, 2000, 2000, 3, 4),
  544. (30, 3000, 3000, 3, 5),
  545. (31, 4000, 4000, 3, 6),
  546. (32, 5000, 5000, 3, 7),
  547. (33, 6000, 6000, 3, 8),
  548. (34, 7000, 7000, 3, 9),
  549. (35, 150, 150, 4, 1),
  550. (36, 500, 500, 4, 2),
  551. (37, 1000, 1000, 4, 3),
  552. (38, 2000, 2000, 4, 4),
  553. (39, 3000, 3000, 4, 5),
  554. (40, 4000, 4000, 4, 6),
  555. (41, 5000, 5000, 4, 7),
  556. (42, 6000, 6000, 4, 8),
  557. (43, 7000, 7000, 4, 9),
  558. (44, 8500, 1000, 1, 9),
  559. (45, 10000, 1000, 4, 10),
  560. (46, 15000, 2000, 4, 11),
  561. (47, 25000, 3000, 4, 12),
  562. (48, 40000, 4000, 4, 13),
  563. (49, 60000, 5000, 4, 14),
  564. (50, 15000, 1000, 1, 10),
  565. (51, 20000, 1000, 1, 11),
  566. (52, 40000, 1000, 1, 12),
  567. (53, 60000, 1000, 1, 13),
  568. (54, 80000, 1000, 1, 14),
  569. (55, 100000, 1000, 1, 15);
  570.  
  571. -- --------------------------------------------------------
  572.  
  573. --
  574. -- Table structure for table `pasiulymai`
  575. --
  576.  
  577. CREATE TABLE IF NOT EXISTS `pasiulymai` (
  578. `ID` int(11) NOT NULL,
  579. `nick` varchar(50) NOT NULL,
  580. `zinute` text NOT NULL,
  581. `data` varchar(50) NOT NULL,
  582. `laikas` int(11) NOT NULL,
  583. `busena` varchar(50) NOT NULL
  584. ) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8;
  585.  
  586. --
  587. -- Dumping data for table `pasiulymai`
  588. --
  589.  
  590. INSERT INTO `pasiulymai` (`ID`, `nick`, `zinute`, `data`, `laikas`, `busena`) VALUES
  591.  
  592. -- --------------------------------------------------------
  593.  
  594. --
  595. -- Table structure for table `pasiulymu_vertinimas`
  596. --
  597.  
  598. CREATE TABLE IF NOT EXISTS `pasiulymu_vertinimas` (
  599. `ID` int(11) NOT NULL,
  600. `nr` int(11) NOT NULL,
  601. `nick` varchar(50) NOT NULL,
  602. `vertinimas` int(11) NOT NULL
  603. ) ENGINE=InnoDB AUTO_INCREMENT=150 DEFAULT CHARSET=utf8;
  604.  
  605. --
  606. -- Dumping data for table `pasiulymu_vertinimas`
  607. --
  608.  
  609. INSERT INTO `pasiulymu_vertinimas` (`ID`, `nr`, `nick`, `vertinimas`) VALUES
  610.  
  611.  
  612. -- --------------------------------------------------------
  613.  
  614. --
  615. -- Table structure for table `pokalbiai`
  616. --
  617.  
  618. CREATE TABLE IF NOT EXISTS `pokalbiai` (
  619. `ID` int(11) NOT NULL,
  620. `nick` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL,
  621. `zinute` text COLLATE utf8_lithuanian_ci NOT NULL,
  622. `data` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL,
  623. `laikas` int(11) NOT NULL
  624. ) ENGINE=InnoDB AUTO_INCREMENT=450 DEFAULT CHARSET=utf8 COLLATE=utf8_lithuanian_ci;
  625.  
  626. --
  627. -- Dumping data for table `pokalbiai`
  628. --
  629.  
  630. INSERT INTO `pokalbiai` (`ID`, `nick`, `zinute`, `data`, `laikas`) VALUES
  631.  
  632. -- --------------------------------------------------------
  633.  
  634. --
  635. -- Table structure for table `reputacija`
  636. --
  637.  
  638. CREATE TABLE IF NOT EXISTS `reputacija` (
  639. `ID` int(11) NOT NULL,
  640. `nick` varchar(50) NOT NULL,
  641. `vertinimas` int(11) NOT NULL,
  642. `kam` varchar(50) NOT NULL
  643. ) ENGINE=InnoDB AUTO_INCREMENT=138 DEFAULT CHARSET=utf8;
  644.  
  645. --
  646. -- Dumping data for table `reputacija`
  647. --
  648.  
  649. INSERT INTO `reputacija` (`ID`, `nick`, `vertinimas`, `kam`) VALUES
  650.  
  651.  
  652. -- --------------------------------------------------------
  653.  
  654. --
  655. -- Table structure for table `ringas`
  656. --
  657.  
  658. CREATE TABLE IF NOT EXISTS `ringas` (
  659. `ID` int(11) NOT NULL,
  660. `nick` varchar(50) NOT NULL,
  661. `cempionas` varchar(50) NOT NULL,
  662. `galiojimas` int(11) NOT NULL,
  663. `veiksmas` int(11) NOT NULL
  664. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  665.  
  666. -- --------------------------------------------------------
  667.  
  668. --
  669. -- Table structure for table `ringo_israsas`
  670. --
  671.  
  672. CREATE TABLE IF NOT EXISTS `ringo_israsas` (
  673. `ID` int(11) NOT NULL,
  674. `nr` int(11) NOT NULL,
  675. `veiksmas` text NOT NULL
  676. ) ENGINE=InnoDB AUTO_INCREMENT=676 DEFAULT CHARSET=utf8;
  677.  
  678. --
  679. -- Dumping data for table `ringo_israsas`
  680. --
  681.  
  682. INSERT INTO `ringo_israsas` (`ID`, `nr`, `veiksmas`) VALUES
  683.  
  684.  
  685. -- --------------------------------------------------------
  686.  
  687. --
  688. -- Table structure for table `titulai`
  689. --
  690.  
  691. CREATE TABLE IF NOT EXISTS `titulai` (
  692. `ID` int(11) NOT NULL,
  693. `nick` varchar(50) NOT NULL,
  694. `veiksmai` int(11) NOT NULL,
  695. `titulas` int(11) NOT NULL
  696. ) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8;
  697.  
  698. -- --------------------------------------------------------
  699.  
  700. --
  701. -- Table structure for table `titulo_cempionai`
  702. --
  703.  
  704. CREATE TABLE IF NOT EXISTS `titulo_cempionai` (
  705. `ID` int(11) NOT NULL,
  706. `nick` varchar(50) NOT NULL,
  707. `titulas` int(11) NOT NULL,
  708. `data` varchar(20) NOT NULL
  709. ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;
  710.  
  711. --
  712. -- Dumping data for table `titulo_cempionai`
  713. --
  714.  
  715. INSERT INTO `titulo_cempionai` (`ID`, `nick`, `titulas`, `data`) VALUES
  716.  
  717.  
  718. -- --------------------------------------------------------
  719.  
  720. --
  721. -- Table structure for table `titulo_cempionai_istorija`
  722. --
  723.  
  724. CREATE TABLE IF NOT EXISTS `titulo_cempionai_istorija` (
  725. `ID` int(11) NOT NULL,
  726. `nick` varchar(50) NOT NULL,
  727. `titulas` int(11) NOT NULL,
  728. `data` varchar(50) NOT NULL,
  729. `ateme_is` varchar(50) NOT NULL,
  730. `islaike_dienu` int(11) NOT NULL
  731. ) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;
  732.  
  733. --
  734. -- Dumping data for table `titulo_cempionai_istorija`
  735. --
  736.  
  737. INSERT INTO `titulo_cempionai_istorija` (`ID`, `nick`, `titulas`, `data`, `ateme_is`, `islaike_dienu`) VALUES
  738.  
  739.  
  740. -- --------------------------------------------------------
  741.  
  742. --
  743. -- Table structure for table `titulo_laimetojai`
  744. --
  745.  
  746. CREATE TABLE IF NOT EXISTS `titulo_laimetojai` (
  747. `ID` int(11) NOT NULL,
  748. `titulas` int(11) NOT NULL,
  749. `laimetojas` varchar(50) NOT NULL,
  750. `veiksmai` int(11) NOT NULL
  751. ) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8;
  752.  
  753. --
  754. -- Dumping data for table `titulo_laimetojai`
  755. --
  756.  
  757. INSERT INTO `titulo_laimetojai` (`ID`, `titulas`, `laimetojas`, `veiksmai`) VALUES
  758.  
  759.  
  760. -- --------------------------------------------------------
  761.  
  762. --
  763. -- Table structure for table `topic`
  764. --
  765.  
  766. CREATE TABLE IF NOT EXISTS `topic` (
  767. `ID` int(11) NOT NULL,
  768. `topic` int(11) NOT NULL,
  769. `nick` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL,
  770. `zinute` text COLLATE utf8_lithuanian_ci NOT NULL,
  771. `data` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL
  772. ) ENGINE=InnoDB AUTO_INCREMENT=82 DEFAULT CHARSET=utf8 COLLATE=utf8_lithuanian_ci;
  773.  
  774. --
  775. -- Dumping data for table `topic`
  776. --
  777.  
  778. INSERT INTO `topic` (`ID`, `topic`, `nick`, `zinute`, `data`) VALUES
  779.  
  780. -- --------------------------------------------------------
  781.  
  782. --
  783. -- Table structure for table `uzbaninti`
  784. --
  785.  
  786. CREATE TABLE IF NOT EXISTS `uzbaninti` (
  787. `ID` int(50) NOT NULL,
  788. `nick` varchar(50) NOT NULL,
  789. `laikas` int(11) NOT NULL,
  790. `priezastis` varchar(90) NOT NULL
  791. ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
  792.  
  793. --
  794. -- Dumping data for table `uzbaninti`
  795. --
  796.  
  797. INSERT INTO `uzbaninti` (`ID`, `nick`, `laikas`, `priezastis`) VALUES
  798.  
  799.  
  800. -- --------------------------------------------------------
  801.  
  802. --
  803. -- Table structure for table `uzkulsiai`
  804. --
  805.  
  806. CREATE TABLE IF NOT EXISTS `uzkulsiai` (
  807. `ID` int(11) NOT NULL,
  808. `pavadinimas` varchar(50) NOT NULL,
  809. `lygis` int(11) NOT NULL
  810. ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
  811.  
  812. --
  813. -- Dumping data for table `uzkulsiai`
  814. --
  815.  
  816. INSERT INTO `uzkulsiai` (`ID`, `pavadinimas`, `lygis`) VALUES
  817. (1, 'Pamestas D-Generation komandos daiktas', 150),
  818. (2, 'Velveteen Dream pasiklydo uzkulsiuose', 300),
  819. (3, 'Isgelbek Nikki Bella nuo uzpuoliku', 700),
  820. (4, 'Hardy Boyz panikoje', 1500),
  821. (5, 'Xavier Woods uzsirove', 3000);
  822.  
  823. -- --------------------------------------------------------
  824.  
  825. --
  826. -- Table structure for table `uzkulsiai_isgavimai`
  827. --
  828.  
  829. CREATE TABLE IF NOT EXISTS `uzkulsiai_isgavimai` (
  830. `ID` int(11) NOT NULL,
  831. `nick` varchar(50) NOT NULL,
  832. `nr` int(11) NOT NULL,
  833. `laikas` int(11) NOT NULL
  834. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  835.  
  836. -- --------------------------------------------------------
  837.  
  838. --
  839. -- Table structure for table `veidukai`
  840. --
  841.  
  842. CREATE TABLE IF NOT EXISTS `veidukai` (
  843. `ID` int(10) NOT NULL,
  844. `kodas` text NOT NULL,
  845. `adresas` text NOT NULL
  846. ) ENGINE=InnoDB AUTO_INCREMENT=337 DEFAULT CHARSET=latin1;
  847.  
  848. --
  849. -- Dumping data for table `veidukai`
  850. --
  851.  
  852. INSERT INTO `veidukai` (`ID`, `kodas`, `adresas`) VALUES
  853. (1, ';)', '/snukiai/29445.gif'),
  854. (2, ':)', '/snukiai/28738.gif'),
  855. (3, ':(', '/snukiai/28737.gif'),
  856. (4, ':]', '/snukiai/28739.gif'),
  857. (5, ' ;D', '/snukiai/28751.gif'),
  858. (6, ':*', '/snukiai/29440.gif'),
  859. (7, ':aciu:', '/snukiai/28897.gif'),
  860. (8, ':acute:', '/snukiai/28834.gif'),
  861. (9, ':alive:', '/snukiai/30830.gif'),
  862. (10, ':ax:', '/snukiai/28879.gif'),
  863. (11, ':behappy:', '/snukiai/28901.gif'),
  864. (12, ':bye:', '/snukiai/28837.gif'),
  865. (13, ':bye2:', '/snukiai/30837.gif'),
  866. (14, ':bye3:', '/snukiai/30838.gif'),
  867. (15, ':bo:', '/snukiai/28838.gif'),
  868. (16, ':boredom:', '/snukiai/28839.gif'),
  869. (17, ':cha:', '/snukiai/29434.gif'),
  870. (18, ':cry2:', '/snukiai/28842.gif'),
  871. (19, ' :D', '/snukiai/28745.gif'),
  872. (20, ':fuck:', '/snukiai/29449.gif'),
  873. (21, ':G', '/snukiai/29450.gif'),
  874. (22, ':galvoja:', '/snukiai/28867.gif'),
  875. (23, ':ha:', '/snukiai/28747.gif'),
  876. (24, ':hey:', '/snukiai/29419.gif'),
  877. (25, ':hello:', '/snukiai/29432.gif'),
  878. (26, ':hi:', '/snukiai/28851.gif'),
  879. (27, ':hi2:', '/snukiai/29424.gif'),
  880. (28, ':hihi:', '/snukiai/28924.gif'),
  881. (29, ':hm2:', '/snukiai/30970.gif'),
  882. (30, ':holle:', '/snukiai/31557.gif'),
  883. (31, ':iki:', '/snukiai/29670.gif'),
  884. (32, ':kadaryt:', '/snukiai/28919.gif'),
  885. (33, ':la:', '/snukiai/29435.gif'),
  886. (34, ':labas:', '/snukiai/28782.gif'),
  887. (35, ':lazy:', '/snukiai/29727.gif'),
  888. (36, ':lazy2:', '/snukiai/29820.gif'),
  889. (37, ':lol:', '/snukiai/28752.gif'),
  890. (38, ':lol2:', '/snukiai/28886.gif'),
  891. (39, ':maldauja:', '/snukiai/28785.gif'),
  892. (40, ':memba:', '/snukiai/28859.gif'),
  893. (41, ':nea:', '/snukiai/28862.gif'),
  894. (42, ':no:', '/snukiai/28894.gif'),
  895. (43, ':O', '/snukiai/28890.gif'),
  896. (44, ':ok:', '/snukiai/28864.gif'),
  897. (45, ':P', '/snukiai/31500.gif'),
  898. (46, ':pff:', '/snukiai/29822.gif'),
  899. (47, ':photo:', '/snukiai/28932.gif'),
  900. (48, ':ploja:', '/snukiai/28948.gif'),
  901. (49, ':rofl:', '/snukiai/28757.gif'),
  902. (50, ':rose:', '/snukiai/28866.gif'),
  903. (51, ':S', '/snukiai/31494.gif'),
  904. (52, ':secret:', '/snukiai/28868.gif'),
  905. (53, ':seilius:', '/snukiai/29471.gif'),
  906. (54, ':shy2:', '/snukiai/31547.gif'),
  907. (55, ':sleep:', '/snukiai/28792.gif'),
  908. (56, ':sleepy:', '/snukiai/31571.gif'),
  909. (57, ':smoke:', '/snukiai/28793.gif'),
  910. (58, ':stop:', '/snukiai/28869.gif'),
  911. (59, ':stop2:', '/snukiai/30996.gif'),
  912. (60, ':swoon:', '/snukiai/29478.gif'),
  913. (61, ':taip:', '/snukiai/28798.gif'),
  914. (63, ':unsure:', '/snukiai/28871.gif'),
  915. (64, ':vava:', '/snukiai/28872.gif'),
  916. (65, ':victory:', '/snukiai/28800.gif'),
  917. (66, ':wacko:', '/snukiai/28873.gif'),
  918. (67, ':wait:', '/snukiai/28941.gif'),
  919. (68, ':wall:', '/snukiai/28925.gif'),
  920. (69, ':what:', '/snukiai/28780.gif'),
  921. (70, ':wink:', '/snukiai/28760.gif'),
  922. (71, ':wow:', '/snukiai/28889.gif'),
  923. (72, ':write:', '/snukiai/28858.gif'),
  924. (73, ':xe:', '/snukiai/28801.gif'),
  925. (74, ':xe2:', '/snukiai/28802.gif'),
  926. (75, ':xe3:', '/snukiai/29436.gif'),
  927. (76, ':xi:', '/snukiai/28860.gif'),
  928. (77, ':zzz:', '/snukiai/28909.gif'),
  929. (78, '=)', '/snukiai/28746.gif'),
  930. (79, '=D', '/snukiai/28933.gif'),
  931. (80, '=Q', '/snukiai/30824.gif'),
  932. (81, 'xD', '/snukiai/29839.gif'),
  933. (82, 'xP', '/snukiai/29711.gif'),
  934. (83, ':airkiss:', '/snukiai/28836.gif'),
  935. (84, ':amuras:', '/snukiai/28934.gif'),
  936. (85, ':angel:', '/snukiai/28833.gif'),
  937. (86, ':antranku:', '/snukiai/29683.gif'),
  938. (87, ':balade:', '/snukiai/28936.gif'),
  939. (88, ':blush:', '/snukiai/28742.gif'),
  940. (89, ':buckis:', '/snukiai/30843.gif'),
  941. (90, ':catlove:', '/snukiai/29767.gif'),
  942. (91, ':cute:', '/snukiai/30940.gif'),
  943. (92, ':drovil:', '/snukiai/29677.gif'),
  944. (93, ':drovisi:', '/snukiai/29676.gif'),
  945. (94, ':dukra:', '/snukiai/30976.gif'),
  946. (95, ':eiks:', '/snukiai/29678.gif'),
  947. (96, ':fyfius:', '/snukiai/30931.gif'),
  948. (97, ':flirt:', '/snukiai/29723.gif'),
  949. (98, ':flirt2:', '/snukiai/29791.gif'),
  950. (99, ':flower:', '/snukiai/28904.gif'),
  951. (100, ':gele:', '/snukiai/29844.gif'),
  952. (101, ':getlost:', '/snukiai/29444.gif'),
  953. (102, ':girllove:', '/snukiai/29458.gif'),
  954. (103, ':givekiss:', '/snukiai/29732.gif'),
  955. (104, ':heart:', '/snukiai/28852.gif'),
  956. (105, ':heart2:', '/snukiai/28906.gif'),
  957. (106, ':hug:', '/snukiai/28884.gif'),
  958. (107, ':hug2:', '/snukiai/30946.gif'),
  959. (108, ':inlove:', '/snukiai/28749.gif'),
  960. (109, ':inlove2:', '/snukiai/30870.gif'),
  961. (110, ':inlove3:', '/snukiai/30982.gif'),
  962. (111, ':kiss:', '/snukiai/28854.gif'),
  963. (112, ':kiss2:', '/snukiai/28855.gif'),
  964. (113, ':kiss3:', '/snukiai/29425.gif'),
  965. (114, ':laizekas:', '/snukiai/31562.gif'),
  966. (115, ':love:', '/snukiai/28911.gif'),
  967. (116, ':loveinair:', '/snukiai/29843.gif'),
  968. (117, ':loveyou:', '/snukiai/31501.gif'),
  969. (118, ':lovenot:', '/snukiai/28899.gif'),
  970. (119, ':luw:', '/snukiai/30880.gif'),
  971. (120, ':luw2:', '/snukiai/30958.gif'),
  972. (121, ':mylinemyli:', '/snukiai/28912.gif'),
  973. (122, ':myliu:', '/snukiai/29679.gif'),
  974. (123, ':myliukas:', '/snukiai/29430.gif'),
  975. (124, ':mua:', '/snukiai/29439.gif'),
  976. (125, ':pa:', '/snukiai/29693.gif'),
  977. (126, ':pm2:', '/snukiai/29441.gif'),
  978. (127, ':ponas:', '/snukiai/29465.gif'),
  979. (128, ':pora:', '/snukiai/29466.gif'),
  980. (129, ':porele:', '/snukiai/29467.gif'),
  981. (130, ':puokste:', '/snukiai/30955.gif'),
  982. (131, ':ramune:', '/snukiai/29469.gif'),
  983. (132, ':raustu:', '/snukiai/30899.gif'),
  984. (133, ':roze:', '/snukiai/28913.gif'),
  985. (134, ':shy:', '/snukiai/28758.gif'),
  986. (135, ':sunus:', '/snukiai/30975.gif'),
  987. (136, ':svaja:', '/snukiai/29477.gif'),
  988. (137, ':svaja2:', '/snukiai/30968.gif'),
  989. (138, ':svajoja:', '/snukiai/28896.gif'),
  990. (139, ':tau:', '/snukiai/30916.gif'),
  991. (140, ':ups:', '/snukiai/29482.gif'),
  992. (141, ':utiutiu:', '/snukiai/30887.gif'),
  993. (142, ':vestuves:', '/snukiai/30985.gif'),
  994. (143, ':wub:', '/snukiai/29483.gif'),
  995. (144, ':xmeile:', '/snukiai/29698.gif'),
  996. (145, ':aa:', '/snukiai/29737.gif'),
  997. (146, ':ablom:', '/snukiai/30924.gif'),
  998. (147, ':aciu2:', '/snukiai/29738.gif'),
  999. (148, ':anciukusokis:', '/snukiai/31502.gif'),
  1000. (149, ':angel2:', '/snukiai/29743.gif'),
  1001. (150, ':apalpo:', '/snukiai/28892.gif'),
  1002. (151, ':apkalbos:', '/snukiai/31504.gif'),
  1003. (152, ':ass:', '/snukiai/29746.gif'),
  1004. (153, ':baby:', '/snukiai/28898.gif'),
  1005. (154, ':bai:', '/snukiai/29720.gif'),
  1006. (155, ':be:', '/snukiai/30841.gif'),
  1007. (156, ':beach:', '/snukiai/29751.gif'),
  1008. (157, ':bebe:', '/snukiai/28877.gif'),
  1009. (158, ':bebe2:', '/snukiai/30898.gif'),
  1010. (159, ':bedantis:', '/snukiai/29447.gif'),
  1011. (160, ':bee:', '/snukiai/28741.gif'),
  1012. (161, ':biggrin:', '/snukiai/30833.gif'),
  1013. (162, ':bigsmile:', '/snukiai/30834.gif'),
  1014. (163, ':byta2:', '/snukiai/30954.gif'),
  1015. (164, ':bla:', '/snukiai/30867.gif'),
  1016. (165, ':blum:', '/snukiai/30901.gif'),
  1017. (166, ':boksas:', '/snukiai/29761.gif'),
  1018. (167, ':botagas:', '/snukiai/28893.gif'),
  1019. (168, ':broken2:', '/snukiai/30993.gif'),
  1020. (169, ':burbulai:', '/snukiai/30844.gif'),
  1021. (170, ':cirkas:', '/snukiai/31683.gif'),
  1022. (171, ':clap:', '/snukiai/28743.gif'),
  1023. (172, ':come:', '/snukiai/31000.gif'),
  1024. (173, ':coolboy:', '/snukiai/30847.gif'),
  1025. (174, ':coolgirl:', '/snukiai/30859.gif'),
  1026. (175, ':crazy:', '/snukiai/28744.gif'),
  1027. (176, ':dance:', '/snukiai/28843.gif'),
  1028. (177, ':dance2:', '/snukiai/29776.gif'),
  1029. (178, ':dance3:', '/snukiai/30849.gif'),
  1030. (179, ':dancer:', '/snukiai/28910.gif'),
  1031. (180, ':dancing:', '/snukiai/29686.gif'),
  1032. (181, ':debilas:', '/snukiai/29488.gif'),
  1033. (182, ':dink:', '/snukiai/30850.gif'),
  1034. (183, ':dirol:', '/snukiai/28846.gif'),
  1035. (184, ':doubleup:', '/snukiai/29779.gif'),
  1036. (185, ':download:', '/snukiai/31575.gif'),
  1037. (186, ':drive:', '/snukiai/30851.gif'),
  1038. (187, ':durnas:', '/snukiai/28903.gif'),
  1039. (188, ':duxas:', '/snukiai/29487.gif'),
  1040. (189, ':fau:', '/snukiai/29840.gif'),
  1041. (190, ':fenas:', '/snukiai/29688.gif'),
  1042. (191, ':fyfa:', '/snukiai/29719.gif'),
  1043. (192, ':fyfa2:', '/snukiai/29789.gif'),
  1044. (193, ':fyfuke:', '/snukiai/30862.gif'),
  1045. (194, ':five:', '/snukiai/29675.gif'),
  1046. (195, ':flirtas:', '/snukiai/31552.gif'),
  1047. (196, ':flower2:', '/snukiai/31495.gif'),
  1048. (197, ':freddy:', '/snukiai/31553.gif'),
  1049. (198, ':friends:', '/snukiai/28881.gif'),
  1050. (199, ':girl:', '/snukiai/28942.gif'),
  1051. (200, ':girtas2:', '/snukiai/31497.gif'),
  1052. (201, ':gogo:', '/snukiai/29691.gif'),
  1053. (202, ':good:', '/snukiai/30863.gif'),
  1054. (203, ':greiciau:', '/snukiai/30943.gif'),
  1055. (204, ':haba:', '/snukiai/29674.gif'),
  1056. (205, ':haha:', '/snukiai/28775.gif'),
  1057. (206, ':happy:', '/snukiai/28748.gif'),
  1058. (207, ':happy2:', '/snukiai/28883.gif'),
  1059. (208, ':hehe:', '/snukiai/29805.gif'),
  1060. (209, ':help:', '/snukiai/30854.gif'),
  1061. (210, ':hide:', '/snukiai/30984.gif'),
  1062. (211, ':hmz:', '/snukiai/29806.gif'),
  1063. (212, ':horse:', '/snukiai/31558.gif'),
  1064. (213, ':huh:', '/snukiai/29807.gif'),
  1065. (214, ':yahoo:', '/snukiai/28750.gif'),
  1066. (215, ':yaya:', '/snukiai/30857.gif'),
  1067. (216, ':yatta:', '/snukiai/31498.gif'),
  1068. (217, ':ideja:', '/snukiai/29808.gif'),
  1069. (218, ':yea:', '/snukiai/28778.gif'),
  1070. (219, ':yeah:', '/snukiai/28863.gif'),
  1071. (220, ':juokas:', '/snukiai/28761.gif'),
  1072. (221, ':kaitina:', '/snukiai/31572.gif'),
  1073. (222, ':kalbu:', '/snukiai/29453.gif'),
  1074. (223, ':kapish:', '/snukiai/30974.gif'),
  1075. (224, ':karate:', '/snukiai/31560.gif'),
  1076. (225, ':kaveikt:', '/snukiai/29454.gif'),
  1077. (226, ':king:', '/snukiai/28781.gif'),
  1078. (227, ':kuku:', '/snukiai/29673.gif'),
  1079. (228, ':kulverstis:', '/snukiai/30876.gif'),
  1080. (229, ':kuti:', '/snukiai/30959.gif'),
  1081. (230, ':lab:', '/snukiai/31561.gif'),
  1082. (231, ':laistau:', '/snukiai/29455.gif'),
  1083. (232, ':lankas:', '/snukiai/29457.gif'),
  1084. (233, ':laugh:', '/snukiai/30878.gif'),
  1085. (234, ':laught:', '/snukiai/31563.gif'),
  1086. (235, ':lauzas:', '/snukiai/31681.gif'),
  1087. (236, ':lazda:', '/snukiai/31564.gif'),
  1088. (237, ':lbx:', '/snukiai/31685.gif'),
  1089. (238, ':lenk:', '/snukiai/30879.gif'),
  1090. (239, ':lyzt:', '/snukiai/31565.gif'),
  1091. (240, ':look:', '/snukiai/30989.gif'),
  1092. (241, ':maco:', '/snukiai/31576.gif'),
  1093. (242, ':meistras:', '/snukiai/30991.gif'),
  1094. (243, ':mezgu:', '/snukiai/30885.gif'),
  1095. (244, ':miega:', '/snukiai/31001.gif'),
  1096. (245, ':yes:', '/snukiai/yes.gif'),
  1097. (246, ':25', '/snukiai/25.gif'),
  1098. (247, ':Q', '/snukiai/Q.gif'),
  1099. (248, ':broken:', '/snukiai/broken.gif'),
  1100. (249, ':byta', '/snukiai/byta.gif'),
  1101. (250, ':dry:', '/snukiai/dry.gif'),
  1102. (251, ':rock:', '/snukiai/rock.gif'),
  1103. (252, ':sun:', '/snukiai/sun.gif'),
  1104. (253, ':TPP:', '/snukiai/P.gif'),
  1105. (254, ':TOO:', '/snukiai/O.gif'),
  1106. (255, ':HH:', '/snukiai/H.gif'),
  1107. (256, ':taskas:', '/snukiai/taskas.gif'),
  1108. (257, ':LL:', '/snukiai/L.gif'),
  1109. (258, ':TT:', '/snukiai/T.gif'),
  1110. (279, '(y)', '/snukiai/(y).gif'),
  1111. (280, '(n)', '/snukiai/(n).gif'),
  1112. (281, ':A', '/snukiai/A.gif'),
  1113. (282, ':fp', '/snukiai/fp.gif'),
  1114. (283, ':dull:', '/snukiai/dull.gif'),
  1115. (284, ':giggle:', '/snukiai/giggle.gif'),
  1116. (285, ':fubar:', '/snukiai/fubar.gif'),
  1117. (286, ':dx:', '/snukiai/dx.gif'),
  1118. (287, ':zvengiu:', '/snukiai/zvengiu.gif'),
  1119. (288, ':evil:', '/snukiai/evil.gif'),
  1120. (289, ':kiss4:', '/snukiai/kiss4.gif'),
  1121. (290, ':finger:', '/snukiai/finger.gif'),
  1122. (291, ':trenktas', '/snukiai/trenktas.gif'),
  1123. (292, ':kede:', '/snukiai/kede.gif'),
  1124. (293, ':bakst:', '/snukiai/bakst.gif'),
  1125. (294, ':saudau:', '/snukiai/saudau.gif'),
  1126. (295, ':dziaga:', '/snukiai/dziaga.gif'),
  1127. (296, ':juokiuos:', '/snukiai/juokiuos.gif'),
  1128. (297, ':B', '/snukiai/B.gif'),
  1129. (298, ':oops:', '/snukiai/oops.gif'),
  1130. (299, ':nosis:', '/snukiai/nosis.gif'),
  1131. (300, ':valio:', '/snukiai/valio.gif'),
  1132. (301, ':rock2:', '/snukiai/rock2.gif'),
  1133. (302, ':omg:', '/snukiai/omg.gif'),
  1134. (303, ':bado:', '/snukiai/bado.gif'),
  1135. (304, ':heh:', '/snukiai/heh.gif'),
  1136. (305, ':alus:', '/snukiai/alus.gif'),
  1137. (306, ':dj:', '/snukiai/dj.gif'),
  1138. (307, ':karys:', '/snukiai/karys.gif'),
  1139. (308, ':karys2:', '/snukiai/karys2.gif'),
  1140. (309, ':ne:', '/snukiai/ne.gif'),
  1141. (310, ':teleskopas:', '/snukiai/teleskopas.gif'),
  1142. (311, ':beta:', '/snukiai/beta.gif'),
  1143. (313, ':W', '/snukiai/W.gif'),
  1144. (334, ':N', '/snukiai/N.gif'),
  1145. (335, ':-)', '/snukiai/747.gif'),
  1146. (336, ':labas2:', '/snukiai/labas.gif');
  1147.  
  1148. -- --------------------------------------------------------
  1149.  
  1150. --
  1151. -- Table structure for table `viesbuciai`
  1152. --
  1153.  
  1154. CREATE TABLE IF NOT EXISTS `viesbuciai` (
  1155. `ID` int(11) NOT NULL,
  1156. `nick` varchar(50) NOT NULL,
  1157. `pavadinimas` varchar(50) NOT NULL,
  1158. `kaina` int(11) NOT NULL,
  1159. `lygis` int(11) NOT NULL DEFAULT '1',
  1160. `pinigai` int(11) NOT NULL
  1161. ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;
  1162.  
  1163. --
  1164. -- Dumping data for table `viesbuciai`
  1165. --
  1166.  
  1167. INSERT INTO `viesbuciai` (`ID`, `nick`, `pavadinimas`, `kaina`, `lygis`, `pinigai`) VALUES
  1168.  
  1169.  
  1170. -- --------------------------------------------------------
  1171.  
  1172. --
  1173. -- Table structure for table `zaidejai`
  1174. --
  1175.  
  1176. CREATE TABLE IF NOT EXISTS `zaidejai` (
  1177. `ID` int(11) NOT NULL,
  1178. `nick` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL,
  1179. `pass` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL,
  1180. `lytis` varchar(20) COLLATE utf8_lithuanian_ci NOT NULL,
  1181. `kovotojas` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL,
  1182. `statusas` int(11) NOT NULL,
  1183. `lygis` varchar(10) COLLATE utf8_lithuanian_ci NOT NULL DEFAULT '1',
  1184. `jega` varchar(10) COLLATE utf8_lithuanian_ci NOT NULL DEFAULT '10',
  1185. `vikrumas` varchar(10) COLLATE utf8_lithuanian_ci NOT NULL DEFAULT '15',
  1186. `gyvybe` int(11) NOT NULL DEFAULT '100',
  1187. `energija` varchar(5) COLLATE utf8_lithuanian_ci NOT NULL DEFAULT '100',
  1188. `max_energija` int(11) NOT NULL DEFAULT '100',
  1189. `kreditai` varchar(10) COLLATE utf8_lithuanian_ci NOT NULL DEFAULT '0.0',
  1190. `pinigai` int(11) NOT NULL,
  1191. `uzdirbti_eurai` int(11) NOT NULL,
  1192. `registracija` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL,
  1193. `aktyvumas` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL,
  1194. `ip` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL,
  1195. `narsykle` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL,
  1196. `nuotrauka` varchar(100) COLLATE utf8_lithuanian_ci NOT NULL DEFAULT 'img/nera_nuotraukos.png',
  1197. `apranga` int(11) NOT NULL,
  1198. `nuotaika` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL DEFAULT 'Neutrali',
  1199. `topic` varchar(250) COLLATE utf8_lithuanian_ci NOT NULL DEFAULT 'Topic nenustatytas.',
  1200. `pokalbiai` int(11) NOT NULL,
  1201. `veiksmai` int(11) NOT NULL DEFAULT '20',
  1202. `visi_veiksmai` int(11) NOT NULL,
  1203. `siandien_veiksmai` int(11) NOT NULL,
  1204. `dienos_veiksmai` int(11) NOT NULL,
  1205. `padusimai` int(11) NOT NULL,
  1206. `puolimai` int(11) NOT NULL DEFAULT '20',
  1207. `lygio_pasiekimas` int(11) NOT NULL DEFAULT '1',
  1208. `nepatvirtinta_nuotrauka` varchar(100) COLLATE utf8_lithuanian_ci NOT NULL,
  1209. `lyga` int(11) NOT NULL,
  1210. `lygos_kvietimas` int(11) NOT NULL,
  1211. `points` varchar(5) COLLATE utf8_lithuanian_ci NOT NULL,
  1212. `laimetu_kovu_ringe` int(11) NOT NULL,
  1213. `pralaimetu_kovu_ringe` int(11) NOT NULL,
  1214. `kodas` int(11) NOT NULL,
  1215. `pora` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL,
  1216. `pora_pasiulymas` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL,
  1217. `tag` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL,
  1218. `tag_pasiulymas` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL,
  1219. `online` int(11) NOT NULL,
  1220. `daiktas_1` int(11) NOT NULL,
  1221. `ringo_leidimas` int(11) NOT NULL,
  1222. `miega` int(11) NOT NULL,
  1223. `komanda` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL,
  1224. `komanda_kvietimas` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL,
  1225. `pasiekimas_1` int(11) NOT NULL DEFAULT '1',
  1226. `pasiekimas_2` int(11) NOT NULL DEFAULT '1',
  1227. `pasiekimas_3` int(11) NOT NULL DEFAULT '1',
  1228. `pasiekimas_4` int(11) NOT NULL DEFAULT '1',
  1229. `misija` int(11) NOT NULL DEFAULT '1',
  1230. `vince_mcmahon` int(11) NOT NULL,
  1231. `zack_ryder` int(11) NOT NULL,
  1232. `drake_maverick` int(11) NOT NULL,
  1233. `auto` int(11) NOT NULL,
  1234. `refresh_en` int(11) NOT NULL,
  1235. `komandos_veiksmai` int(11) NOT NULL,
  1236. `algos_veiksmai` int(11) NOT NULL
  1237. ) ENGINE=InnoDB AUTO_INCREMENT=213 DEFAULT CHARSET=utf8 COLLATE=utf8_lithuanian_ci;
  1238.  
  1239. --
  1240. -- Dumping data for table `zaidejai`
  1241. --
  1242.  
  1243. INSERT INTO `zaidejai` (`ID`, `nick`, `pass`, `lytis`, `kovotojas`, `statusas`, `lygis`, `jega`, `vikrumas`, `gyvybe`, `energija`, `max_energija`, `kreditai`, `pinigai`, `uzdirbti_eurai`, `registracija`, `aktyvumas`, `ip`, `narsykle`, `nuotrauka`, `apranga`, `nuotaika`, `topic`, `pokalbiai`, `veiksmai`, `visi_veiksmai`, `siandien_veiksmai`, `dienos_veiksmai`, `padusimai`, `puolimai`, `lygio_pasiekimas`, `nepatvirtinta_nuotrauka`, `lyga`, `lygos_kvietimas`, `points`, `laimetu_kovu_ringe`, `pralaimetu_kovu_ringe`, `kodas`, `pora`, `pora_pasiulymas`, `tag`, `tag_pasiulymas`, `online`, `daiktas_1`, `ringo_leidimas`, `miega`, `komanda`, `komanda_kvietimas`, `pasiekimas_1`, `pasiekimas_2`, `pasiekimas_3`, `pasiekimas_4`, `misija`, `vince_mcmahon`, `zack_ryder`, `drake_maverick`, `auto`, `refresh_en`, `komandos_veiksmai`, `algos_veiksmai`) VALUES
  1244. (212, 'Admin', 'lopas123321', 'Vyras', 'Roman Reigns', 2, '10000', '10000', '10000', 1000, '1000', 100, '10000', 10000, 10000, '2019-08-22 / 19:40', '2019-10-22 19:41', '92.220.1.47', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWeb', 'img/nera_nuotraukos.png', 3, 'Neutrali', '@Admin', 0, 10000, 10000, 500, 500, 1, 200, 1, '', 2, 0, '', 0, 0, 0, '', '', '', '', 37, 0, 0, 0, '', '', 1, 1, 1, 1, 1, 0, 0, 0, 1, 0, 0, 1000);
  1245.  
  1246. -- --------------------------------------------------------
  1247.  
  1248. --
  1249. -- Table structure for table `zaidejai_daiktai`
  1250. --
  1251.  
  1252. CREATE TABLE IF NOT EXISTS `zaidejai_daiktai` (
  1253. `ID` int(11) NOT NULL,
  1254. `nick` varchar(50) NOT NULL,
  1255. `pavadinimas` varchar(50) NOT NULL,
  1256. `kiekis` int(11) NOT NULL,
  1257. `lygis` int(11) NOT NULL DEFAULT '1'
  1258. ) ENGINE=InnoDB AUTO_INCREMENT=327 DEFAULT CHARSET=utf8;
  1259.  
  1260. --
  1261. -- Dumping data for table `zaidejai_daiktai`
  1262. --
  1263.  
  1264. INSERT INTO `zaidejai_daiktai` (`ID`, `nick`, `pavadinimas`, `kiekis`, `lygis`) VALUES
  1265.  
  1266.  
  1267. -- --------------------------------------------------------
  1268.  
  1269. --
  1270. -- Table structure for table `zaidejai_drabuziai`
  1271. --
  1272.  
  1273. CREATE TABLE IF NOT EXISTS `zaidejai_drabuziai` (
  1274. `ID` int(11) NOT NULL,
  1275. `nick` varchar(50) NOT NULL,
  1276. `nr` int(11) NOT NULL
  1277. ) ENGINE=InnoDB AUTO_INCREMENT=127 DEFAULT CHARSET=utf8;
  1278.  
  1279. --
  1280. -- Dumping data for table `zaidejai_drabuziai`
  1281. --
  1282.  
  1283. INSERT INTO `zaidejai_drabuziai` (`ID`, `nick`, `nr`) VALUES
  1284.  
  1285.  
  1286. -- --------------------------------------------------------
  1287.  
  1288. --
  1289. -- Table structure for table `zinutes`
  1290. --
  1291.  
  1292. CREATE TABLE IF NOT EXISTS `zinutes` (
  1293. `ID` int(11) NOT NULL,
  1294. `nick` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL,
  1295. `kam` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL,
  1296. `zinute` text COLLATE utf8_lithuanian_ci NOT NULL,
  1297. `data` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL,
  1298. `busena` int(11) NOT NULL,
  1299. `laikas` int(11) NOT NULL
  1300. ) ENGINE=InnoDB AUTO_INCREMENT=4546 DEFAULT CHARSET=utf8 COLLATE=utf8_lithuanian_ci;
  1301.  
  1302. --
  1303. -- Dumping data for table `zinutes`
  1304. --
  1305.  
  1306. INSERT INTO `zinutes` (`ID`, `nick`, `kam`, `zinute`, `data`, `busena`, `laikas`) VALUES
  1307.  
  1308. --
  1309. -- Indexes for dumped tables
  1310. --
  1311.  
  1312. --
  1313. -- Indexes for table `apsaugos_kodas`
  1314. --
  1315. ALTER TABLE `apsaugos_kodas`
  1316. ADD PRIMARY KEY (`ID`);
  1317.  
  1318. --
  1319. -- Indexes for table `balsavimas`
  1320. --
  1321. ALTER TABLE `balsavimas`
  1322. ADD PRIMARY KEY (`ID`);
  1323.  
  1324. --
  1325. -- Indexes for table `balsavimo_rezultatai`
  1326. --
  1327. ALTER TABLE `balsavimo_rezultatai`
  1328. ADD PRIMARY KEY (`laikas`);
  1329.  
  1330. --
  1331. -- Indexes for table `drabuzine`
  1332. --
  1333. ALTER TABLE `drabuzine`
  1334. ADD PRIMARY KEY (`ID`);
  1335.  
  1336. --
  1337. -- Indexes for table `duk`
  1338. --
  1339. ALTER TABLE `duk`
  1340. ADD PRIMARY KEY (`ID`);
  1341.  
  1342. --
  1343. -- Indexes for table `komandos`
  1344. --
  1345. ALTER TABLE `komandos`
  1346. ADD PRIMARY KEY (`ID`);
  1347.  
  1348. --
  1349. -- Indexes for table `komentarai`
  1350. --
  1351. ALTER TABLE `komentarai`
  1352. ADD PRIMARY KEY (`ID`);
  1353.  
  1354. --
  1355. -- Indexes for table `kovos`
  1356. --
  1357. ALTER TABLE `kovos`
  1358. ADD PRIMARY KEY (`ID`);
  1359.  
  1360. --
  1361. -- Indexes for table `kovotojai`
  1362. --
  1363. ALTER TABLE `kovotojai`
  1364. ADD PRIMARY KEY (`ID`);
  1365.  
  1366. --
  1367. -- Indexes for table `lygos`
  1368. --
  1369. ALTER TABLE `lygos`
  1370. ADD PRIMARY KEY (`ID`);
  1371.  
  1372. --
  1373. -- Indexes for table `naujienos`
  1374. --
  1375. ALTER TABLE `naujienos`
  1376. ADD PRIMARY KEY (`ID`);
  1377.  
  1378. --
  1379. -- Indexes for table `naujienu_reputacija`
  1380. --
  1381. ALTER TABLE `naujienu_reputacija`
  1382. ADD PRIMARY KEY (`ID`);
  1383.  
  1384. --
  1385. -- Indexes for table `online`
  1386. --
  1387. ALTER TABLE `online`
  1388. ADD PRIMARY KEY (`ID`);
  1389.  
  1390. --
  1391. -- Indexes for table `online_list`
  1392. --
  1393. ALTER TABLE `online_list`
  1394. ADD PRIMARY KEY (`ID`);
  1395.  
  1396. --
  1397. -- Indexes for table `parduotuve`
  1398. --
  1399. ALTER TABLE `parduotuve`
  1400. ADD PRIMARY KEY (`ID`);
  1401.  
  1402. --
  1403. -- Indexes for table `pasiekimai`
  1404. --
  1405. ALTER TABLE `pasiekimai`
  1406. ADD PRIMARY KEY (`ID`);
  1407.  
  1408. --
  1409. -- Indexes for table `pasiulymai`
  1410. --
  1411. ALTER TABLE `pasiulymai`
  1412. ADD PRIMARY KEY (`ID`);
  1413.  
  1414. --
  1415. -- Indexes for table `pasiulymu_vertinimas`
  1416. --
  1417. ALTER TABLE `pasiulymu_vertinimas`
  1418. ADD PRIMARY KEY (`ID`);
  1419.  
  1420. --
  1421. -- Indexes for table `pokalbiai`
  1422. --
  1423. ALTER TABLE `pokalbiai`
  1424. ADD PRIMARY KEY (`ID`);
  1425.  
  1426. --
  1427. -- Indexes for table `reputacija`
  1428. --
  1429. ALTER TABLE `reputacija`
  1430. ADD PRIMARY KEY (`ID`);
  1431.  
  1432. --
  1433. -- Indexes for table `ringas`
  1434. --
  1435. ALTER TABLE `ringas`
  1436. ADD PRIMARY KEY (`ID`);
  1437.  
  1438. --
  1439. -- Indexes for table `ringo_israsas`
  1440. --
  1441. ALTER TABLE `ringo_israsas`
  1442. ADD PRIMARY KEY (`ID`);
  1443.  
  1444. --
  1445. -- Indexes for table `titulai`
  1446. --
  1447. ALTER TABLE `titulai`
  1448. ADD PRIMARY KEY (`ID`);
  1449.  
  1450. --
  1451. -- Indexes for table `titulo_cempionai`
  1452. --
  1453. ALTER TABLE `titulo_cempionai`
  1454. ADD PRIMARY KEY (`ID`);
  1455.  
  1456. --
  1457. -- Indexes for table `titulo_cempionai_istorija`
  1458. --
  1459. ALTER TABLE `titulo_cempionai_istorija`
  1460. ADD PRIMARY KEY (`ID`);
  1461.  
  1462. --
  1463. -- Indexes for table `titulo_laimetojai`
  1464. --
  1465. ALTER TABLE `titulo_laimetojai`
  1466. ADD PRIMARY KEY (`ID`);
  1467.  
  1468. --
  1469. -- Indexes for table `topic`
  1470. --
  1471. ALTER TABLE `topic`
  1472. ADD PRIMARY KEY (`ID`);
  1473.  
  1474. --
  1475. -- Indexes for table `uzbaninti`
  1476. --
  1477. ALTER TABLE `uzbaninti`
  1478. ADD PRIMARY KEY (`ID`);
  1479.  
  1480. --
  1481. -- Indexes for table `uzkulsiai`
  1482. --
  1483. ALTER TABLE `uzkulsiai`
  1484. ADD PRIMARY KEY (`ID`);
  1485.  
  1486. --
  1487. -- Indexes for table `uzkulsiai_isgavimai`
  1488. --
  1489. ALTER TABLE `uzkulsiai_isgavimai`
  1490. ADD PRIMARY KEY (`ID`);
  1491.  
  1492. --
  1493. -- Indexes for table `veidukai`
  1494. --
  1495. ALTER TABLE `veidukai`
  1496. ADD PRIMARY KEY (`ID`);
  1497.  
  1498. --
  1499. -- Indexes for table `viesbuciai`
  1500. --
  1501. ALTER TABLE `viesbuciai`
  1502. ADD PRIMARY KEY (`ID`);
  1503.  
  1504. --
  1505. -- Indexes for table `zaidejai`
  1506. --
  1507. ALTER TABLE `zaidejai`
  1508. ADD PRIMARY KEY (`ID`);
  1509.  
  1510. --
  1511. -- Indexes for table `zaidejai_daiktai`
  1512. --
  1513. ALTER TABLE `zaidejai_daiktai`
  1514. ADD PRIMARY KEY (`ID`);
  1515.  
  1516. --
  1517. -- Indexes for table `zaidejai_drabuziai`
  1518. --
  1519. ALTER TABLE `zaidejai_drabuziai`
  1520. ADD PRIMARY KEY (`ID`);
  1521.  
  1522. --
  1523. -- Indexes for table `zinutes`
  1524. --
  1525. ALTER TABLE `zinutes`
  1526. ADD PRIMARY KEY (`ID`);
  1527.  
  1528. --
  1529. -- AUTO_INCREMENT for dumped tables
  1530. --
  1531.  
  1532. --
  1533. -- AUTO_INCREMENT for table `apsaugos_kodas`
  1534. --
  1535. ALTER TABLE `apsaugos_kodas`
  1536. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
  1537. --
  1538. -- AUTO_INCREMENT for table `balsavimas`
  1539. --
  1540. ALTER TABLE `balsavimas`
  1541. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;
  1542. --
  1543. -- AUTO_INCREMENT for table `balsavimo_rezultatai`
  1544. --
  1545. ALTER TABLE `balsavimo_rezultatai`
  1546. MODIFY `laikas` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=81;
  1547. --
  1548. -- AUTO_INCREMENT for table `drabuzine`
  1549. --
  1550. ALTER TABLE `drabuzine`
  1551. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=93;
  1552. --
  1553. -- AUTO_INCREMENT for table `duk`
  1554. --
  1555. ALTER TABLE `duk`
  1556. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
  1557. --
  1558. -- AUTO_INCREMENT for table `komandos`
  1559. --
  1560. ALTER TABLE `komandos`
  1561. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=17;
  1562. --
  1563. -- AUTO_INCREMENT for table `komentarai`
  1564. --
  1565. ALTER TABLE `komentarai`
  1566. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=33;
  1567. --
  1568. -- AUTO_INCREMENT for table `kovos`
  1569. --
  1570. ALTER TABLE `kovos`
  1571. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=20;
  1572. --
  1573. -- AUTO_INCREMENT for table `kovotojai`
  1574. --
  1575. ALTER TABLE `kovotojai`
  1576. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=30;
  1577. --
  1578. -- AUTO_INCREMENT for table `lygos`
  1579. --
  1580. ALTER TABLE `lygos`
  1581. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
  1582. --
  1583. -- AUTO_INCREMENT for table `naujienos`
  1584. --
  1585. ALTER TABLE `naujienos`
  1586. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=33;
  1587. --
  1588. -- AUTO_INCREMENT for table `naujienu_reputacija`
  1589. --
  1590. ALTER TABLE `naujienu_reputacija`
  1591. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=10;
  1592. --
  1593. -- AUTO_INCREMENT for table `online`
  1594. --
  1595. ALTER TABLE `online`
  1596. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5168;
  1597. --
  1598. -- AUTO_INCREMENT for table `online_list`
  1599. --
  1600. ALTER TABLE `online_list`
  1601. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=63;
  1602. --
  1603. -- AUTO_INCREMENT for table `parduotuve`
  1604. --
  1605. ALTER TABLE `parduotuve`
  1606. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
  1607. --
  1608. -- AUTO_INCREMENT for table `pasiekimai`
  1609. --
  1610. ALTER TABLE `pasiekimai`
  1611. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=56;
  1612. --
  1613. -- AUTO_INCREMENT for table `pasiulymai`
  1614. --
  1615. ALTER TABLE `pasiulymai`
  1616. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=51;
  1617. --
  1618. -- AUTO_INCREMENT for table `pasiulymu_vertinimas`
  1619. --
  1620. ALTER TABLE `pasiulymu_vertinimas`
  1621. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=150;
  1622. --
  1623. -- AUTO_INCREMENT for table `pokalbiai`
  1624. --
  1625. ALTER TABLE `pokalbiai`
  1626. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=450;
  1627. --
  1628. -- AUTO_INCREMENT for table `reputacija`
  1629. --
  1630. ALTER TABLE `reputacija`
  1631. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=138;
  1632. --
  1633. -- AUTO_INCREMENT for table `ringas`
  1634. --
  1635. ALTER TABLE `ringas`
  1636. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
  1637. --
  1638. -- AUTO_INCREMENT for table `ringo_israsas`
  1639. --
  1640. ALTER TABLE `ringo_israsas`
  1641. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=676;
  1642. --
  1643. -- AUTO_INCREMENT for table `titulai`
  1644. --
  1645. ALTER TABLE `titulai`
  1646. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=67;
  1647. --
  1648. -- AUTO_INCREMENT for table `titulo_cempionai`
  1649. --
  1650. ALTER TABLE `titulo_cempionai`
  1651. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=14;
  1652. --
  1653. -- AUTO_INCREMENT for table `titulo_cempionai_istorija`
  1654. --
  1655. ALTER TABLE `titulo_cempionai_istorija`
  1656. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=28;
  1657. --
  1658. -- AUTO_INCREMENT for table `titulo_laimetojai`
  1659. --
  1660. ALTER TABLE `titulo_laimetojai`
  1661. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=43;
  1662. --
  1663. -- AUTO_INCREMENT for table `topic`
  1664. --
  1665. ALTER TABLE `topic`
  1666. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=82;
  1667. --
  1668. -- AUTO_INCREMENT for table `uzbaninti`
  1669. --
  1670. ALTER TABLE `uzbaninti`
  1671. MODIFY `ID` int(50) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7;
  1672. --
  1673. -- AUTO_INCREMENT for table `uzkulsiai`
  1674. --
  1675. ALTER TABLE `uzkulsiai`
  1676. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
  1677. --
  1678. -- AUTO_INCREMENT for table `uzkulsiai_isgavimai`
  1679. --
  1680. ALTER TABLE `uzkulsiai_isgavimai`
  1681. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
  1682. --
  1683. -- AUTO_INCREMENT for table `veidukai`
  1684. --
  1685. ALTER TABLE `veidukai`
  1686. MODIFY `ID` int(10) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=337;
  1687. --
  1688. -- AUTO_INCREMENT for table `viesbuciai`
  1689. --
  1690. ALTER TABLE `viesbuciai`
  1691. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=13;
  1692. --
  1693. -- AUTO_INCREMENT for table `zaidejai`
  1694. --
  1695. ALTER TABLE `zaidejai`
  1696. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=213;
  1697. --
  1698. -- AUTO_INCREMENT for table `zaidejai_daiktai`
  1699. --
  1700. ALTER TABLE `zaidejai_daiktai`
  1701. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=327;
  1702. --
  1703. -- AUTO_INCREMENT for table `zaidejai_drabuziai`
  1704. --
  1705. ALTER TABLE `zaidejai_drabuziai`
  1706. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=127;
  1707. --
  1708. -- AUTO_INCREMENT for table `zinutes`
  1709. --
  1710. ALTER TABLE `zinutes`
  1711. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4546;
  1712. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  1713. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  1714. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
RAW Paste Data