BZLDGAYc

1	  API.getStore().update(false, "INSERT INTO `stats1`(`id`, `uuid`, `lastName`, `jablka`, `pandorki`, `kills`, `stone`) VALUES (NULL, '" + getUuid() + "','" + getLastName() + "','" + getApple() + "','" + getPandora() + "','" + getKills() + "','" + getStone() + "')");
2
3	  API.getStore().update(now, "UPDATE `stats1` SET `lastName`='" + getLastName() + "',`jablka`='" + getApple() + "',`pandorki`='" + getPandora() + "',`kills`='" + getKills() + "',`stone`='" + getStone() + "' WHERE `uuid`='" + getUuid() + "'");
4
5
6	  API.getStore().update(false, "DELETE FROM `stats1` WHERE `uuid` = '" + getUuid() + "'");
7
8stats1.sql
9
10-- phpMyAdmin SQL Dump
11-- version 4.2.11
12-- http://www.phpmyadmin.net
13--
14-- Host: 127.0.0.1
15-- Czas generowania: 21 Lut 2015, 14:17
16-- Wersja serwera: 5.6.21
17-- Wersja PHP: 5.6.3
18
19SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
20SET time_zone = "+00:00";
21
22
23/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
24/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
25/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
26/*!40101 SET NAMES utf8 */;
27
28
29-- --------------------------------------------------------
30
31--
32-- Struktura tabeli dla tabeli `mh_users`
33--
34
35
36CREATE TABLE IF NOT EXISTS `stats1` (
37  `id` int(10) NOT NULL AUTO_INCREMENT,
38  `uuid` varchar(36) NOT NULL,
39  `lastName` varchar(16) NOT NULL,
40  `pandorki` int(10) NOT NULL,
41  `kills` int(10) NOT NULL,
42  `stone` int(10) NOT NULL,
43  `jablka` int(10) NOT NULL,
44  PRIMARY KEY (`uuid`),
45  UNIQUE KEY `id` (`id`)
46);
47
48-- --------------------------------------------------------
49
50--
51
52/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
53/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
54/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;