bfh website

TheLittlePeach · Aug 24, 2019

to use this you must have configured the backend

here http://forum.ragezone.com/f857/bfh-complete-backend-server-1165278/

here we will have the website set up and ready to use
and the uniserver (program similar to xampp)
but it's portable and works better

after download files you open uniserver and start apache and xampp

(uniserver are using root username and 1234 for pw (of databae) so you need to put this in env files of you backend)

open uniserver

go to "view www" to see the website and "phpMyadmin" to see the database

( I no need to learn how to create one account in the website.....)

after creating the website account
you need to get sessioniD to join the game

you find this in DB

"game_heroes" and seach for you game name
and copy the session id

And put in you .bat to start the game

website files : https://drive.google.com/open?id=1QTVxalUqF1H1Dzi_SOrUQ364JJ1KLcek

Flyer8472 · Aug 24, 2019

The webpage gives me ERROR 500 with no clue what is that problem when i try to register... Also it is not creating any account.

TheLittlePeach · Aug 25, 2019

You used the uniserver ? just start apache and mysql and try

open uniserver folder
In WWW
And edit env file of website

look in db host and put you ip or 127.0.0.1

Flyer8472 · Aug 25, 2019

TheLittlePeach said:
You used the uniserver ? just start apache and mysql and try
open uniserver folder
In WWW
And edit env file of website

look in db host and put you ip or 127.0.0.1

Of course i am.

Yep the env. file was that

thx it is working now.

TheLittlePeach · Aug 26, 2019

Flyer8472 said:
Of course i am.

Yep the env. file was that thx it is working now.

If need more help just type here or in my discord

wipoosarapon · Aug 28, 2019

why store i have problem it show running

Flyer8472 · Aug 28, 2019

The store is not working in this one. The client will freeze/crash

TheLittlePeach · Aug 28, 2019

Flyer8472 said:
The store is not working in this one. The client will freeze/crash

no have store yet

TheLittlePeach said:
If need more help just type here or in my discord

no store yet

Flyer8472 · Aug 29, 2019

Iknow that this is not working i was telling to wipoosarapon

nicolasn1 · Aug 31, 2019

MySQL database working admin panel / serverlist and news 85% done.

-- phpMyAdmin SQL Dump
-- version 4.6.6
--
You must be registered to see links

--
-- Host: 127.0.0.1:3306
-- Generation Time: 29-Ago-2019 às 20:40
-- Versão do servidor: 5.6.35
-- PHP Version: 7.1.1

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `goheroes`
--
CREATE DATABASE IF NOT EXISTS `goheroes` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE `goheroes`;

-- --------------------------------------------------------

--
-- Estrutura da tabela `audits`
--

CREATE TABLE `audits` (
`created_at` date NOT NULL,
`user_id` int(11) NOT NULL,
`permission` int(11) NOT NULL,
`action` int(11) NOT NULL,
`ip_address` int(11) NOT NULL,
`log` int(11) NOT NULL,
`updated_at` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estrutura da tabela `authentication_tokens`
--

CREATE TABLE `authentication_tokens` (
`id` int(10) UNSIGNED NOT NULL,
`token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`user_id` int(10) UNSIGNED NOT NULL,
`additional` text COLLATE utf8mb4_unicode_ci NOT NULL,
`expire_at` datetime NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Extraindo dados da tabela `authentication_tokens`
--

-- --------------------------------------------------------

--
-- Estrutura da tabela `comments`
--

CREATE TABLE `comments` (
`id` int(10) UNSIGNED NOT NULL,
`user_id` int(10) UNSIGNED NOT NULL,
`topic_id` int(10) UNSIGNED NOT NULL,
`comment` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Estrutura da tabela `downloads`
--

CREATE TABLE `downloads` (
`id` int(10) UNSIGNED NOT NULL,
`user_id` int(10) UNSIGNED NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Extraindo dados da tabela `downloads`
--

INSERT INTO `downloads` (`id`, `user_id`, `created_at`, `updated_at`) VALUES
(1, 19, '2019-08-29 03:20:18', '2019-08-29 03:20:18'),
(2, 19, '2019-08-29 03:20:23', '2019-08-29 03:20:23');

-- --------------------------------------------------------

--
-- Estrutura da tabela `forums`
--

CREATE TABLE `forums` (
`id` int(10) UNSIGNED NOT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` text COLLATE utf8mb4_unicode_ci NOT NULL,
`user_id` int(10) UNSIGNED NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Estrutura da tabela `friend_requests`
--

CREATE TABLE `friend_requests` (
`id` int(10) UNSIGNED NOT NULL,
`sender` int(10) UNSIGNED NOT NULL,
`receiver` int(10) UNSIGNED NOT NULL,
`status` enum('pending','accepted','declined') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Estrutura da tabela `game_heroes`
--

CREATE TABLE `game_heroes` (
`heroID` int(11) NOT NULL,
`heroName` varchar(50) NOT NULL,
`online` tinyint(1) NOT NULL DEFAULT '0',
`ip_address` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`user_id` int(11) NOT NULL,
`hero_stats` text NOT NULL,
`sessionID` varchar(48) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Extraindo dados da tabela `game_heroes`
--

INSERT INTO `game_heroes` (`heroID`, `heroName`, `online`, `ip_address`, `created_at`, `updated_at`, `deleted_at`, `user_id`, `hero_stats`, `sessionID`) VALUES
(2, '1234', 0, NULL, NULL, NULL, NULL, 2, '{"c_ft":"","c_team":"","c_hrc":"","c_hrs":"","c_skc":"","c_ltp":"9790.0000","c_ltm":"9790.0000","c_fhrs":"","c_slm":"0.0000","cdm":"","edm":"","c_kit":"","c_wallet_hero":"14.0000","c_wallet_valor":"","games":"","elo":"","level":"","xp":"","ct":"","ki":"","dt":"","su":"","win":"","los":"","fi":"","hi":"","rs":"","ts":"","ss":"","cs":"","prs":"","ppt":"","c_tut":"","awybt":"","dmc":"","gsco":"","expts":"","bnspt":"","aw":{},"mid":{"0":"6000.0000","1":"6000.0000","2":"6000.0000"},"c_mid":{},"c_cmid":{},"m0c":{},"m1c":{},"m2c":{},"c_wmid":{"0":"0.0000","1":"0.0000","2":"0.0000"},"startLVL":"","roundXP":"","roundBXP":"","roundVP":"","roundBVP":"","roundHP":"","roundPP":"","roundBPP":"","totalPP":"","cpc":"","cpa":"","cpd":"","rc":"","ks":"","ds":"","ft_rs":{},"ft_ki":{},"ft_dt":{},"ft_win":{},"ft_los":{},"fc_rs":{},"fc_ki":{},"fc_dt":{},"fc_win":{},"fc_los":{},"m_ct":{},"m_win":{},"m_los":{},"tv":{},"kv":{},"dfv":{},"kvr":{},"dstrv":{},"div":{},"tw":{},"twk":{},"kw":{},"dfw":{},"sw":{},"hw":{},"dww":{},"kk":{},"kkb":{},"ka":"","he":"","drka":"","c_apr":["10","1330"],"c_emo":[],"c_eqp":["3167","0","0","3155","0","0","0","0","0","0"],"c_items":["2003","2026","2027","2028","2031","2032","2033","2046","2047","2048","2055","2056","2057","2091","2141","2142","2149","2153","2157","2158","2160","2162","2164","2166","2168","2170","2171","2174"],"ige":{}}', '1'),
(3, 'bianca', 0, '172.19.0.1', '2019-01-28 02:22:49', '2019-01-28 02:22:49', NULL, 12, '{"c_ft":"0","c_team":"1","c_hrc":"1","c_hrs":"122","c_skc":"3","c_ltp":"9787.0000","c_ltm":"9337.0000","c_fhrs":"","c_slm":"2.0000","cdm":"","edm":"","c_kit":"2","c_wallet_hero":"","c_wallet_valor":"","games":"","elo":"1000","level":"1","xp":"","ct":"","ki":"","dt":"","su":"","win":"","los":"","fi":"","hi":"","rs":"","ts":"","ss":"","cs":"","prs":"","ppt":"","c_tut":"","awybt":"","dmc":"","gsco":"","expts":"","bnspt":"","aw":{},"mid":{},"c_mid":{},"c_cmid":{},"m0c":{},"m1c":{},"m2c":{},"c_wmid":{},"startLVL":"","roundXP":"","roundBXP":"","roundVP":"","roundBVP":"","roundHP":"","roundPP":"","roundBPP":"","totalPP":"","cpc":"","cpa":"","cpd":"","rc":"","ks":"","ds":"","ft_rs":{},"ft_ki":{},"ft_dt":{},"ft_win":{},"ft_los":{},"fc_rs":{},"fc_ki":{},"fc_dt":{},"fc_win":{},"fc_los":{},"m_ct":{},"m_win":{},"m_los":{},"tv":{},"kv":{},"dfv":{},"kvr":{},"dstrv":{},"div":{},"tw":{},"twk":{},"kw":{},"dfw":{},"sw":{},"hw":{},"dww":{},"kk":{},"kkb":{},"ka":"","he":"","drka":"","c_apr":[],"c_emo":[],"c_eqp":["3184","0","0","3155","0","0","0","0","0","0"],"c_items":[],"ige":{}}', '12'),
(4, 'jovempan', 0, '172.19.0.1', '2019-01-28 05:05:48', '2019-01-28 05:05:48', NULL, 12, '{"c_ft":"130","c_team":"1","c_hrc":"2","c_hrs":"120","c_skc":"8","c_ltp":"9936.0000","c_ltm":"9337.0000","c_fhrs":"","c_slm":"2.0000","cdm":"","edm":"","c_kit":"2","c_wallet_hero":"0.0000","c_wallet_valor":"","games":"","elo":"1000","level":"1","xp":"","ct":"","ki":"","dt":"","su":"","win":"","los":"","fi":"","hi":"","rs":"","ts":"","ss":"","cs":"","prs":"","ppt":"","c_tut":"","awybt":"","dmc":"","gsco":"","expts":"","bnspt":"","aw":{},"mid":{},"c_mid":{},"c_cmid":{},"m0c":{},"m1c":{},"m2c":{},"c_wmid":{},"startLVL":"","roundXP":"","roundBXP":"","roundVP":"","roundBVP":"","roundHP":"","roundPP":"","roundBPP":"","totalPP":"","cpc":"","cpa":"","cpd":"","rc":"","ks":"","ds":"","ft_rs":{},"ft_ki":{},"ft_dt":{},"ft_win":{},"ft_los":{},"fc_rs":{},"fc_ki":{},"fc_dt":{},"fc_win":{},"fc_los":{},"m_ct":{},"m_win":{},"m_los":{},"tv":{},"kv":{},"dfv":{},"kvr":{},"dstrv":{},"div":{},"tw":{},"twk":{},"kw":{},"dfw":{},"sw":{},"hw":{},"dww":{},"kk":{},"kkb":{},"ka":"","he":"","drka":"","c_apr":["10","1226","1284","1294","1309","1344"],"c_emo":[],"c_eqp":["3050","3166","3171","2095","2051","2064","2039","2028","2003","2153"],"c_items":["2003","2026","2027","2028","2031","2032","2033","2036","2037","2038","2039","2046","2047","2048","2050","2051","2055","2056","2057","2060","2061","2062","2063","2064","2091","2092","2093","2094","2095","2149","2153","2157","2158","2160","2162","2164","2166","2168","2170","2171","2174"],"ige":{}}', '12'),
(5, 'celular', 0, '172.19.0.1', '2019-01-28 05:23:24', '2019-01-28 05:23:24', NULL, 12, '{"c_ft":"102","c_team":"2","c_hrc":"2","c_hrs":"0","c_skc":"7","c_ltp":"9936.0000","c_ltm":"9337.0000","c_fhrs":"","c_slm":"2.0000","cdm":"","edm":"","c_kit":"0","c_wallet_hero":"","c_wallet_valor":"","games":"","elo":"1000","level":"1","xp":"","ct":"","ki":"","dt":"","su":"","win":"","los":"","fi":"","hi":"","rs":"","ts":"","ss":"","cs":"","prs":"","ppt":"","c_tut":"","awybt":"","dmc":"","gsco":"","expts":"","bnspt":"","aw":{},"mid":{},"c_mid":{},"c_cmid":{},"m0c":{},"m1c":{},"m2c":{},"c_wmid":{},"startLVL":"","roundXP":"","roundBXP":"","roundVP":"","roundBVP":"","roundHP":"","roundPP":"","roundBPP":"","totalPP":"","cpc":"","cpa":"","cpd":"","rc":"","ks":"","ds":"","ft_rs":{},"ft_ki":{},"ft_dt":{},"ft_win":{},"ft_los":{},"fc_rs":{},"fc_ki":{},"fc_dt":{},"fc_win":{},"fc_los":{},"m_ct":{},"m_win":{},"m_los":{},"tv":{},"kv":{},"dfv":{},"kvr":{},"dstrv":{},"div":{},"tw":{},"twk":{},"kw":{},"dfw":{},"sw":{},"hw":{},"dww":{},"kk":{},"kkb":{},"ka":"","he":"","drka":"","c_apr":["1355"],"c_emo":[],"c_eqp":["3172","3196","0","0","0","0","0","0","0","0"],"c_items":[],"ige":{}}', '12'),
(6, 'coroahehe', 0, '172.19.0.1', '2019-01-30 00:25:41', '2019-01-30 00:25:41', NULL, 13, '{"c_ft":"0","c_team":"2","c_hrc":"5","c_hrs":"82","c_skc":"2","c_ltp":"10013.0000","c_ltm":"9790.0000","c_fhrs":"","c_slm":"12.0000","cdm":"","edm":"","c_kit":"1","c_wallet_hero":"","c_wallet_valor":"","games":"","elo":"1000","level":"1","xp":"","ct":"","ki":"","dt":"","su":"","win":"","los":"","fi":"","hi":"","rs":"","ts":"","ss":"","cs":"","prs":"","ppt":"","c_tut":"0.0000","awybt":"","dmc":"","gsco":"","expts":"","bnspt":"","aw":{},"mid":{},"c_mid":{},"c_cmid":{},"m0c":{},"m1c":{},"m2c":{},"c_wmid":{},"startLVL":"","roundXP":"","roundBXP":"","roundVP":"","roundBVP":"","roundHP":"","roundPP":"","roundBPP":"","totalPP":"","cpc":"","cpa":"","cpd":"","rc":"","ks":"","ds":"","ft_rs":{},"ft_ki":{},"ft_dt":{},"ft_win":{},"ft_los":{},"fc_rs":{},"fc_ki":{},"fc_dt":{},"fc_win":{},"fc_los":{},"m_ct":{},"m_win":{},"m_los":{},"tv":{},"kv":{},"dfv":{},"kvr":{},"dstrv":{},"div":{},"tw":{},"twk":{},"kw":{},"dfw":{},"sw":{},"hw":{},"dww":{},"kk":{},"kkb":{},"ka":"","he":"","drka":"","c_apr":["0"],"c_emo":[],"c_eqp":["0","0","0","0","0","0","0","0","0","0"],"c_items":[],"ige":{}}', '123'),
(7, '5656565', 0, '172.19.0.1', '2019-01-30 00:55:18', '2019-01-30 00:55:18', NULL, 13, '{"c_ft":"132","c_team":"1","c_hrc":"1","c_hrs":"0","c_skc":"7","c_ltp":"10013.0000","c_ltm":"9790.0000","c_fhrs":"","c_slm":"0.0000","cdm":"","edm":"","c_kit":"2","c_wallet_hero":"","c_wallet_valor":"","games":"","elo":"1000","level":"1","xp":"","ct":"","ki":"","dt":"","su":"","win":"","los":"","fi":"","hi":"","rs":"","ts":"","ss":"","cs":"","prs":"","ppt":"","c_tut":"1.0000","awybt":"","dmc":"","gsco":"","expts":"","bnspt":"","aw":{},"mid":{},"c_mid":{},"c_cmid":{},"m0c":{},"m1c":{},"m2c":{},"c_wmid":{"0":"6000.0000"},"startLVL":"","roundXP":"","roundBXP":"","roundVP":"","roundBVP":"","roundHP":"","roundPP":"","roundBPP":"","totalPP":"","cpc":"","cpa":"","cpd":"","rc":"","ks":"","ds":"","ft_rs":{},"ft_ki":{},"ft_dt":{},"ft_win":{},"ft_los":{},"fc_rs":{},"fc_ki":{},"fc_dt":{},"fc_win":{},"fc_los":{},"m_ct":{},"m_win":{},"m_los":{},"tv":{},"kv":{},"dfv":{},"kvr":{},"dstrv":{},"div":{},"tw":{},"twk":{},"kw":{},"dfw":{},"sw":{},"hw":{},"dww":{},"kk":{},"kkb":{},"ka":"","he":"","drka":"","c_apr":["10"],"c_emo":["5000","5007","5016","0","0","0","0","0","0"],"c_eqp":["3051","3010","0","3155","0","0","0","0","0","0"],"c_items":[],"ige":{}}', '123'),
(8, 'niuijh', 0, '172.19.0.1', '2019-01-30 00:55:44', '2019-01-30 00:55:44', NULL, 13, '{"c_ft":"130","c_team":"1","c_hrc":"4","c_hrs":"122","c_skc":"8","c_ltp":"9790.0000","c_ltm":"9337.0000","c_fhrs":"","c_slm":"2.0000","cdm":"","edm":"","c_kit":"0","c_wallet_hero":"","c_wallet_valor":"","games":"","elo":"1000","level":"1","xp":"","ct":"","ki":"","dt":"","su":"","win":"","los":"","fi":"","hi":"","rs":"","ts":"","ss":"","cs":"","prs":"","ppt":"","c_tut":"","awybt":"","dmc":"","gsco":"","expts":"","bnspt":"","aw":{},"mid":{},"c_mid":{},"c_cmid":{},"m0c":{},"m1c":{},"m2c":{},"c_wmid":{"0":"6000.0000"},"startLVL":"","roundXP":"","roundBXP":"","roundVP":"","roundBVP":"","roundHP":"","roundPP":"","roundBPP":"","totalPP":"","cpc":"","cpa":"","cpd":"","rc":"","ks":"","ds":"","ft_rs":{},"ft_ki":{},"ft_dt":{},"ft_win":{},"ft_los":{},"fc_rs":{},"fc_ki":{},"fc_dt":{},"fc_win":{},"fc_los":{},"m_ct":{},"m_win":{},"m_los":{},"tv":{},"kv":{},"dfv":{},"kvr":{},"dstrv":{},"div":{},"tw":{},"twk":{},"kw":{},"dfw":{},"sw":{},"hw":{},"dww":{},"kk":{},"kkb":{},"ka":"","he":"","drka":"","c_apr":[],"c_emo":["5000","5007","5016","0","0","0","0","0","0"],"c_eqp":["3002","3014","2141","3155","0","0","0","0","0","0"],"c_items":[],"ige":{}}', '123'),
(9, 'consegui', 0, '172.19.0.1', '2019-01-30 05:05:51', '2019-01-30 05:05:51', NULL, 13, '{"c_ft":"106","c_team":"2","c_hrc":"3","c_hrs":"83","c_skc":"7","c_ltp":"9790.0000","c_ltm":"9790.0000","c_fhrs":"","c_slm":"1.0000","cdm":"","edm":"","c_kit":"2","c_wallet_hero":"","c_wallet_valor":"","games":"","elo":"1000","level":"1","xp":"","ct":"","ki":"","dt":"","su":"","win":"","los":"","fi":"","hi":"","rs":"","ts":"","ss":"","cs":"","prs":"","ppt":"","c_tut":"1.0000","awybt":"","dmc":"","gsco":"","expts":"","bnspt":"","aw":{},"mid":{},"c_mid":{},"c_cmid":{},"m0c":{},"m1c":{},"m2c":{},"c_wmid":{},"startLVL":"","roundXP":"","roundBXP":"","roundVP":"","roundBVP":"","roundHP":"","roundPP":"","roundBPP":"","totalPP":"","cpc":"","cpa":"","cpd":"","rc":"","ks":"","ds":"","ft_rs":{},"ft_ki":{},"ft_dt":{},"ft_win":{},"ft_los":{},"fc_rs":{},"fc_ki":{},"fc_dt":{},"fc_win":{},"fc_los":{},"m_ct":{},"m_win":{},"m_los":{},"tv":{},"kv":{},"dfv":{},"kvr":{},"dstrv":{},"div":{},"tw":{},"twk":{},"kw":{},"dfw":{},"sw":{},"hw":{},"dww":{},"kk":{},"kkb":{},"ka":"","he":"","drka":"","c_apr":["1341"],"c_emo":[],"c_eqp":["3197","3161","0","0","0","0","0","0","0","0"],"c_items":[],"ige":{}}', '123'),
(10, 'conqueer', 0, '172.19.0.1', '2019-01-30 05:07:42', '2019-01-30 05:07:42', NULL, 10, '{"c_ft":"130","c_team":"1","c_hrc":"4","c_hrs":"124","c_skc":"8","c_ltp":"9938.0000","c_ltm":"10006.0000","c_fhrs":"","c_slm":"0.0000","cdm":"","edm":"","c_kit":"2","c_wallet_hero":"","c_wallet_valor":"","games":"","elo":"1000","level":"1","xp":"","ct":"","ki":"","dt":"","su":"","win":"","los":"","fi":"","hi":"","rs":"","ts":"","ss":"","cs":"","prs":"","ppt":"","c_tut":"","awybt":"","dmc":"","gsco":"","expts":"","bnspt":"","aw":{},"mid":{},"c_mid":{},"c_cmid":{},"m0c":{},"m1c":{},"m2c":{},"c_wmid":{},"startLVL":"","roundXP":"","roundBXP":"","roundVP":"","roundBVP":"","roundHP":"","roundPP":"","roundBPP":"","totalPP":"","cpc":"","cpa":"","cpd":"","rc":"","ks":"","ds":"","ft_rs":{},"ft_ki":{},"ft_dt":{},"ft_win":{},"ft_los":{},"fc_rs":{},"fc_ki":{},"fc_dt":{},"fc_win":{},"fc_los":{},"m_ct":{},"m_win":{},"m_los":{},"tv":{},"kv":{},"dfv":{},"kvr":{},"dstrv":{},"div":{},"tw":{},"twk":{},"kw":{},"dfw":{},"sw":{},"hw":{},"dww":{},"kk":{},"kkb":{},"ka":"","he":"","drka":"","c_apr":["10","1347"],"c_emo":[],"c_eqp":["3050","3166","0","0","0","0","0","0","0","0"],"c_items":[],"ige":{}}', '1234'),
(11, 'chora', 0, NULL, NULL, NULL, NULL, 10, '{"c_ft":"130","c_team":"2","c_hrc":"4","c_hrs":"124","c_skc":"8","c_ltp":"10006.0000","c_ltm":"9790.0000","c_fhrs":"","c_slm":"0.0000","cdm":"","edm":"","c_kit":"2","c_wallet_hero":"3.0000","c_wallet_valor":"","games":"","elo":"1000","level":"1","xp":"","ct":"","ki":"","dt":"","su":"","win":"","los":"","fi":"","hi":"","rs":"","ts":"","ss":"","cs":"","prs":"","ppt":"","c_tut":"","awybt":"","dmc":"","gsco":"","expts":"","bnspt":"","aw":{},"mid":{"2":"6000.0000"},"c_mid":{},"c_cmid":{},"m0c":{},"m1c":{},"m2c":{},"c_wmid":{"0":"0.0000","1":"0.0000","2":"0.0000"},"startLVL":"","roundXP":"","roundBXP":"","roundVP":"","roundBVP":"","roundHP":"","roundPP":"","roundBPP":"","totalPP":"","cpc":"","cpa":"","cpd":"","rc":"","ks":"","ds":"","ft_rs":{},"ft_ki":{},"ft_dt":{},"ft_win":{},"ft_los":{},"fc_rs":{},"fc_ki":{},"fc_dt":{},"fc_win":{},"fc_los":{},"m_ct":{},"m_win":{},"m_los":{},"tv":{},"kv":{},"dfv":{},"kvr":{},"dstrv":{},"div":{},"tw":{},"twk":{},"kw":{},"dfw":{},"sw":{},"hw":{},"dww":{},"kk":{},"kkb":{},"ka":"","he":"","drka":"","c_apr":["396"],"c_emo":[],"c_eqp":["3036","3028","3160","0","0","0","0","0","0","0"],"c_items":["2003","2026","2027","2028","2029","2030","2031","2032","2033","2034","2035","2046","2047","2048","2049","2055","2056","2057","2058","2059","2091","2092","2093","2094","2095","2149","2152","2153","2155","2156","2159","2161","2163","2165","2167","2169","2172","2173"],"ige":{}}', '1234'),
(12, 'TERRIBLE', 0, '172.19.0.1', '2019-01-30 08:53:29', '2019-01-30 08:53:29', NULL, 16, '{"c_ft":"131","c_team":"2","c_hrc":"1","c_hrs":"0","c_skc":"3","c_ltp":"9337.0000","c_ltm":"9936.0000","c_fhrs":"","c_slm":"0.0000","cdm":"","edm":"","c_kit":"2","c_wallet_hero":"15","c_wallet_valor":"","games":"","elo":"1000","level":"1","xp":"","ct":"","ki":"","dt":"","su":"","win":"","los":"","fi":"","hi":"","rs":"","ts":"","ss":"","cs":"","prs":"","ppt":"","c_tut":"","awybt":"","dmc":"","gsco":"","expts":"","bnspt":"","aw":{},"mid":{},"c_mid":{},"c_cmid":{},"m0c":{},"m1c":{},"m2c":{},"c_wmid":{},"startLVL":"","roundXP":"","roundBXP":"","roundVP":"","roundBVP":"","roundHP":"","roundPP":"","roundBPP":"","totalPP":"","cpc":"","cpa":"","cpd":"","rc":"","ks":"","ds":"","ft_rs":{},"ft_ki":{},"ft_dt":{},"ft_win":{},"ft_los":{},"fc_rs":{},"fc_ki":{},"fc_dt":{},"fc_win":{},"fc_los":{},"m_ct":{},"m_win":{},"m_los":{},"tv":{},"kv":{},"dfv":{},"kvr":{},"dstrv":{},"div":{},"tw":{},"twk":{},"kw":{},"dfw":{},"sw":{},"hw":{},"dww":{},"kk":{},"kkb":{},"ka":"","he":"","drka":"","c_apr":[],"c_emo":[],"c_eqp":["3184","0","0","3155","0","0","0","0","0","0"],"c_items":[],"ige":{}}', '12345'),
(13, 'lavarloucas', 0, '::1', '2019-01-31 01:27:35', '2019-01-31 01:27:35', NULL, 17, '{"c_ft":"106","c_team":"2","c_hrc":"4","c_hrs":"82","c_skc":"3","c_ltp":"9936.0000","c_ltm":"10013.0000","c_fhrs":"","c_slm":"1.0000","cdm":"","edm":"","c_kit":"1","c_wallet_hero":"","c_wallet_valor":"","games":"","elo":"1000","level":"1","xp":"","ct":"","ki":"","dt":"","su":"","win":"","los":"","fi":"","hi":"","rs":"","ts":"","ss":"","cs":"","prs":"","ppt":"","c_tut":"1.0000","awybt":"","dmc":"","gsco":"","expts":"","bnspt":"","aw":{},"mid":{},"c_mid":{},"c_cmid":{},"m0c":{},"m1c":{},"m2c":{},"c_wmid":{},"startLVL":"","roundXP":"","roundBXP":"","roundVP":"","roundBVP":"","roundHP":"","roundPP":"","roundBPP":"","totalPP":"","cpc":"","cpa":"","cpd":"","rc":"","ks":"","ds":"","ft_rs":{},"ft_ki":{},"ft_dt":{},"ft_win":{},"ft_los":{},"fc_rs":{},"fc_ki":{},"fc_dt":{},"fc_win":{},"fc_los":{},"m_ct":{},"m_win":{},"m_los":{},"tv":{},"kv":{},"dfv":{},"kvr":{},"dstrv":{},"div":{},"tw":{},"twk":{},"kw":{},"dfw":{},"sw":{},"hw":{},"dww":{},"kk":{},"kkb":{},"ka":"","he":"","drka":"","c_apr":[],"c_emo":[],"c_eqp":["3179","0","0","0","0","0","0","0","0","0"],"c_items":[],"ige":{}}', '123456'),
(14, 'jon', 0, '::1', '2019-01-31 01:42:29', '2019-01-31 01:42:29', NULL, 18, '{"c_ft":"109","c_team":"2","c_hrc":"1","c_hrs":"85","c_skc":"5","c_ltp":"9790.0000","c_ltm":"9337.0000","c_fhrs":"","c_slm":"2.0000","cdm":"","edm":"","c_kit":"1","c_wallet_hero":"","c_wallet_valor":"","games":"","elo":"1000","level":"1","xp":"","ct":"","ki":"","dt":"","su":"","win":"","los":"","fi":"","hi":"","rs":"","ts":"","ss":"","cs":"","prs":"","ppt":"","c_tut":"","awybt":"","dmc":"","gsco":"","expts":"","bnspt":"","aw":{},"mid":{},"c_mid":{},"c_cmid":{},"m0c":{},"m1c":{},"m2c":{},"c_wmid":{},"startLVL":"","roundXP":"","roundBXP":"","roundVP":"","roundBVP":"","roundHP":"","roundPP":"","roundBPP":"","totalPP":"","cpc":"","cpa":"","cpd":"","rc":"","ks":"","ds":"","ft_rs":{},"ft_ki":{},"ft_dt":{},"ft_win":{},"ft_los":{},"fc_rs":{},"fc_ki":{},"fc_dt":{},"fc_win":{},"fc_los":{},"m_ct":{},"m_win":{},"m_los":{},"tv":{},"kv":{},"dfv":{},"kvr":{},"dstrv":{},"div":{},"tw":{},"twk":{},"kw":{},"dfw":{},"sw":{},"hw":{},"dww":{},"kk":{},"kkb":{},"ka":"","he":"","drka":"","c_apr":[],"c_emo":[],"c_eqp":["3179","3197","0","0","0","0","0","0","0","0"],"c_items":[],"ige":{}}', '12345678'),
(15, 'itowashitanab', 0, '::1', '2019-01-31 01:56:07', '2019-01-31 01:56:07', NULL, 18, '{"c_ft":"131","c_team":"2","c_hrc":"1","c_hrs":"0","c_skc":"3","c_ltp":"9936.0000","c_ltm":"9337.0000","c_fhrs":"","c_slm":"2.0000","cdm":"","edm":"","c_kit":"2","c_wallet_hero":"9.0000","c_wallet_valor":"","games":"","elo":"1000","level":"1","xp":"","ct":"","ki":"","dt":"","su":"","win":"","los":"","fi":"","hi":"","rs":"","ts":"","ss":"","cs":"","prs":"","ppt":"","c_tut":"","awybt":"","dmc":"","gsco":"","expts":"","bnspt":"","aw":{},"mid":{"2":"6000.0000"},"c_mid":{},"c_cmid":{},"m0c":{},"m1c":{},"m2c":{},"c_wmid":{"0":"0.0000","1":"0.0000","2":"0.0000"},"startLVL":"","roundXP":"","roundBXP":"","roundVP":"","roundBVP":"","roundHP":"","roundPP":"","roundBPP":"","totalPP":"","cpc":"","cpa":"","cpd":"","rc":"","ks":"","ds":"","ft_rs":{},"ft_ki":{},"ft_dt":{},"ft_win":{},"ft_los":{},"fc_rs":{},"fc_ki":{},"fc_dt":{},"fc_win":{},"fc_los":{},"m_ct":{},"m_win":{},"m_los":{},"tv":{},"kv":{},"dfv":{},"kvr":{},"dstrv":{},"div":{},"tw":{},"twk":{},"kw":{},"dfw":{},"sw":{},"hw":{},"dww":{},"kk":{},"kkb":{},"ka":"","he":"","drka":"","c_apr":["16","181","313","1061"],"c_emo":[],"c_eqp":["3036","3161","3007","2028","2153","2033","2095","2048","2059","2003"],"c_items":["2003","2026","2027","2028","2031","2032","2033","2046","2047","2048","2055","2056","2057","2058","2059","2091","2092","2093","2094","2095","2149","2153","2155","2156","2159","2161","2163","2165","2167","2169","2172","2173"],"ige":{}}', 'japa'),
(16, 'kawasavawakiwa', 0, '::1', '2019-01-31 01:57:04', '2019-01-31 01:57:04', NULL, 18, '{"c_ft":"131","c_team":"1","c_hrc":"1","c_hrs":"0","c_skc":"3","c_ltp":"9790.0000","c_ltm":"9790.0000","c_fhrs":"","c_slm":"0.0000","cdm":"","edm":"","c_kit":"2","c_wallet_hero":"0.0000","c_wallet_valor":"","games":"","elo":"1000","level":"1","xp":"","ct":"","ki":"","dt":"","su":"","win":"","los":"","fi":"","hi":"","rs":"","ts":"","ss":"","cs":"","prs":"","ppt":"","c_tut":"","awybt":"","dmc":"","gsco":"","expts":"","bnspt":"","aw":{},"mid":{},"c_mid":{},"c_cmid":{},"m0c":{},"m1c":{},"m2c":{},"c_wmid":{},"startLVL":"","roundXP":"","roundBXP":"","roundVP":"","roundBVP":"","roundHP":"","roundPP":"","roundBPP":"","totalPP":"","cpc":"","cpa":"","cpd":"","rc":"","ks":"","ds":"","ft_rs":{},"ft_ki":{},"ft_dt":{},"ft_win":{},"ft_los":{},"fc_rs":{},"fc_ki":{},"fc_dt":{},"fc_win":{},"fc_los":{},"m_ct":{},"m_win":{},"m_los":{},"tv":{},"kv":{},"dfv":{},"kvr":{},"dstrv":{},"div":{},"tw":{},"twk":{},"kw":{},"dfw":{},"sw":{},"hw":{},"dww":{},"kk":{},"kkb":{},"ka":"","he":"","drka":"","c_apr":["183","478","479"],"c_emo":[],"c_eqp":["3050","3200","3008","2028","2153","2036","2095","2151","2064","2003"],"c_items":["2003","2026","2027","2028","2031","2032","2033","2036","2046","2047","2048","2050","2051","2052","2053","2055","2056","2057","2060","2061","2062","2063","2064","2091","2092","2093","2094","2095","2149","2151","2153","2157","2158","2160","2162","2164","2166","2168","2170","2171","2174"],"ige":{}}', 'japa'),

-- --------------------------------------------------------

--
-- Estrutura da tabela `game_player_regions`
--

CREATE TABLE `game_player_regions` (
`userid` int(11) NOT NULL,
`region` varchar(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Estrutura da tabela `game_player_server_preferences`
--

CREATE TABLE `game_player_server_preferences` (
`userid` int(11) NOT NULL,
`gid` int(11) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Estrutura da tabela `game_server_stats`
--

CREATE TABLE `game_server_stats` (
`userId` int(11) NOT NULL,
`email` int(11) NOT NULL,
`gid` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estrutura da tabela `game_stats`
--

CREATE TABLE `game_stats` (
`id` int(10) UNSIGNED NOT NULL,
`user_id` int(10) UNSIGNED NOT NULL,
`heroID` int(10) UNSIGNED NOT NULL,
`statsKey` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`statsValue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`heroName` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Extraindo dados da tabela `game_stats`
--

INSERT INTO `game_stats` (`id`, `user_id`, `heroID`, `statsKey`, `statsValue`, `created_at`, `updated_at`, `heroName`) VALUES
(1, 19, 17, '123', '100', '2019-08-29 03:00:00', '2019-08-29 03:00:00', 0);

-- --------------------------------------------------------

--
-- Estrutura da tabela `games`
--

CREATE TABLE `games` (
`gid` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`game_ip` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
`game_port` int(11) NOT NULL,
`game_version` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
`status_join` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`status_mapname` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL,
`players_connected` int(11) NOT NULL,
`players_joining` int(11) NOT NULL,
`players_max` int(11) NOT NULL DEFAULT '32',
`team_1` int(11) NOT NULL DEFAULT '0',
`team_2` int(11) NOT NULL DEFAULT '0',
`team_distribution` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Estrutura da tabela `hwid_bans`
--

CREATE TABLE `hwid_bans` (
`hero_id` int(11) NOT NULL,
`counter` int(11) NOT NULL,
`hwid` int(11) NOT NULL,
`date` int(11) NOT NULL,
`until` int(11) NOT NULL,
`reason` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estrutura da tabela `lifetime_stats`
--

CREATE TABLE `lifetime_stats` (
`stat` int(11) NOT NULL,
`gid` int(11) NOT NULL,
`userId` int(11) NOT NULL,
`email` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `lifetime_stats`
--

INSERT INTO `lifetime_stats` (`stat`, `gid`, `userId`, `email`) VALUES
(1, 1, 17, 0);

-- --------------------------------------------------------

--
-- Estrutura da tabela `news`
--

CREATE TABLE `news` (
`title` text NOT NULL,
`text` text NOT NULL,
`date` date NOT NULL,
`user_id` int(11) NOT NULL,
`updated_at` date NOT NULL,
`created_at` date NOT NULL,
`id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=REDUNDANT;

--
-- Extraindo dados da tabela `news`
--

INSERT INTO `news` (`title`, `text`, `date`, `user_id`, `updated_at`, `created_at`, `id`) VALUES
('test html', '<p>test de hoje mais uma vez</p>', '2019-08-29', 19, '2019-08-29', '2019-08-29', 0);

-- --------------------------------------------------------

--
-- Estrutura da tabela `password_resets`
--

CREATE TABLE `password_resets` (
`email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Extraindo dados da tabela `password_resets`
--

INSERT INTO `password_resets` (`email`, `token`, `created_at`) VALUES
('plsdonthackme@gmail.com', '$2y$10$STTxd6g2mVuqVxLXOyHGQOj97pF7w7LT.9/F.lP3qgd37AKL6PnJy', '2017-12-10 02:56:49');

-- --------------------------------------------------------

--
-- Estrutura da tabela `permission_role`
--

CREATE TABLE `permission_role` (
`permission_id` int(10) UNSIGNED NOT NULL,
`role_id` int(10) UNSIGNED NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Extraindo dados da tabela `permission_role`
--

INSERT INTO `permission_role` (`permission_id`, `role_id`) VALUES
(1, 1),
(2, 1),
(3, 1),
(4, 1),
(5, 1),
(6, 1),
(7, 1),
(8, 1),
(9, 1),
(10, 1),
(11, 1),
(12, 1),
(13, 1),
(14, 1),
(15, 1),
(16, 1),
(17, 1),
(18, 1),
(19, 1);

-- --------------------------------------------------------

--
-- Estrutura da tabela `permissions`
--

CREATE TABLE `permissions` (
`id` int(10) UNSIGNED NOT NULL,
`slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Extraindo dados da tabela `permissions`
--

INSERT INTO `permissions` (`id`, `slug`, `description`) VALUES
(1, 'game.createhero', NULL),
(2, 'game.unlimitedheroes', NULL),
(3, 'game.login', NULL),
(4, 'game.matchmake', NULL),
(5, 'admin.dashboard', 'admin'),
(6, 'user.update', NULL),
(7, 'user.add', NULL),
(8, 'user.delete', NULL),
(9, 'user.roles', NULL),
(10, 'user.ban', NULL),
(11, 'forum.topic', NULL),
(12, 'forum.post', NULL),
(13, 'forum.comment', NULL),
(14, 'forum.delete', NULL),
(15, 'forum.manage', NULL),
(16, 'news.manage', NULL),
(17, 'news.add', NULL),
(18, 'audit.manage', NULL),
(19, 'game.multipleheroes', NULL);

-- --------------------------------------------------------

--
-- Estrutura da tabela `players`
--

CREATE TABLE `players` (
`user_id` int(11) NOT NULL,
`username` varchar(50) NOT NULL,
`password` varchar(50) NOT NULL,
`game_token` varchar(50) DEFAULT NULL,
`prefer_server` int(11) DEFAULT NULL,
`selected_heroID` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Extraindo dados da tabela `players`
--

INSERT INTO `players` (`user_id`, `username`, `password`, `game_token`, `prefer_server`, `selected_heroID`) VALUES
(6, 'aldo', 'aldo', 'aldo', NULL, NULL),
(7, 'aldo2', 'banana', 'banana', NULL, NULL),
(8, 'bfhgamer', 'japa', 'japa', NULL, NULL),
(9, 'SomeUser', '1234', '1234', NULL, 9),
(11, 'OtherUser', '123', '123', NULL, 11),

-- --------------------------------------------------------

--
-- Estrutura da tabela `role_user`
--

CREATE TABLE `role_user` (
`user_id` int(10) UNSIGNED NOT NULL,
`role_id` int(10) UNSIGNED NOT NULL,
`expire_at` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Extraindo dados da tabela `role_user`
--

INSERT INTO `role_user` (`user_id`, `role_id`, `expire_at`) VALUES
(19, 1, NULL),
(19, 2, NULL),
(20, 1, NULL);

-- --------------------------------------------------------

--
-- Estrutura da tabela `roles`
--

CREATE TABLE `roles` (
`id` int(10) UNSIGNED NOT NULL,
`title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Extraindo dados da tabela `roles`
--

INSERT INTO `roles` (`id`, `title`, `slug`) VALUES
(1, 'Administrator', 'administrator'),
(2, 'awokenlead', 'awokenlead'),
(3, 'staff', 'staff'),
(4, 'awokendev', 'awokendev'),
(20, 'Admin', 'admin');

-- --------------------------------------------------------

--
-- Estrutura da tabela `servers`
--

CREATE TABLE `servers` (
`server_id` int(11) NOT NULL,
`soldier_name` varchar(50) DEFAULT NULL,
`account_username` varchar(50) DEFAULT NULL,
`account_password` varchar(50) DEFAULT NULL,
`api_key` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Extraindo dados da tabela `servers`
--

INSERT INTO `servers` (`server_id`, `soldier_name`, `account_username`, `account_password`, `api_key`) VALUES
(1, 'MargeSimpson', 'MargeSimpson', 'MargeSimpson', 'MargeSimpson'),

-- --------------------------------------------------------

--
-- Estrutura da tabela `user_friends`
--

CREATE TABLE `user_friends` (
`id` int(10) UNSIGNED NOT NULL,
`user_id` int(10) UNSIGNED NOT NULL,
`friend_id` int(10) UNSIGNED NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Estrutura da tabela `user_revive`
--

CREATE TABLE `user_revive` (
`user_id` int(11) NOT NULL,
`revive_id` int(11) NOT NULL,
`revive_name` int(11) NOT NULL,
`revive_email` int(11) NOT NULL,
`revive_role` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estrutura da tabela `users`
--

CREATE TABLE `users` (
`id` int(10) UNSIGNED NOT NULL,
`username` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`birthday` date NOT NULL,
`language` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'enUS',
`country` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`notifications` mediumtext COLLATE utf8mb4_unicode_ci,
`ip_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`game_token` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Extraindo dados da tabela `users`
--

INSERT INTO `users` (`id`, `username`, `email`, `birthday`, `language`, `country`, `password`, `remember_token`, `created_at`, `updated_at`, `notifications`, `ip_address`, `game_token`) VALUES
(1, 'MargeSimpson', 'game-server@gmail.com', '2017-12-06', 'enUS', 'Brazil', '$2y$10$0MXqXXfdsNpJXqb0Ee7QNetGOww7sZ.GdL3ppNPl2lXbYc.D1pDQS', 'EHYHyYtbWPE0Tl1UuZvaZX1hhMU49jDV3GjBoyfZASH6OAaXWpSgk9fIf5Ze', NULL, '2019-08-29 18:55:06', '[]', '127.0.0.1', 'MargeSimpson'),
(2, 'lok', 'eeee@gmail.com', '1996-07-31', 'enUS', '', '1234', NULL, '2017-12-10 02:37:43', '2019-08-29 18:55:06', '[]', NULL, '1234'),
(3, 'Kiop', '1234@gmail.com', '1997-07-31', 'enUS', '', '$2y$10$yqc94mokmEtovgK1oXjoOeAN2/14iacs9BKDu.qokd8NWN4GoeGM2', NULL, '2017-12-10 02:59:21', '2019-08-29 18:55:06', '[]', NULL, '123'),
(4, 'diego', 'syn@gmail.com', '2018-01-27', 'fr', 'FR', 'diego', NULL, '2018-01-27 07:19:31', '2019-08-29 18:55:06', '[]', NULL, '434334'),
(7, 'aldo2', 'aldo2@email.com', '1980-07-21', 'enUS', '', '$2y$10$bQN2f08GJCMjukkpUn.EneU3GJ6PG7Bl11pJ2hSIOxZFhhsW57ynK', NULL, '2019-01-06 04:48:35', '2019-08-29 18:55:06', '[]', '26.36.195.228', 'banana'),
(5, 'caio', '22232@gmail.com', '1997-07-31', 'enUS', '', '$2y$10$M9RiC3XlhebivlXRPXeccupEZ2aajmfS4UMwiPICLeNkhsCYdI5Qe', NULL, '2018-01-30 03:11:10', '2018-01-30 04:52:54', '{"news":false}', '127.0.0.1', '6CUMvXUu6HNBajzR3wEtLwzfF4EgIrCJ'),
(6, 'aldo', 'aldo@email.com', '1980-07-21', 'enUS', '', '$2y$10$oLU58YbnAU0Rz7I7niVFZu4.CjPLJDCsTcBJB//yOGMzQo7CheNSq', NULL, '2019-01-06 03:11:42', '2019-08-29 18:55:06', '[]', NULL, 'aldo'),
(8, 'bfhgamer', 'bfhgamer@email.com', '1998-10-12', 'enUS', '', '$2y$10$E5jEGPKiNSC9r8Ih.Z.Owe/GnwCBBTurmji6mbuJxc2YI.QvSTJm.', NULL, '2019-01-06 04:50:56', '2019-08-29 18:55:06', '[]', NULL, 'japa'),
(9, 'japa', 'japa@email.com', '1983-03-21', 'enUS', '', '$2y$10$mlHm0kMrQTqx0Q5M5HpsyOkk5km53ZXJXi0lLkAAovg9AMn0AYBOa', 'ctjfri8us6gzRifWzV7gPDJHdusZTeeTzmp04ylJp13ZaE7lyXljL6UmIpZP', '2019-01-20 06:34:08', '2019-08-29 18:55:06', '[]', NULL, NULL),
(10, 'dev', 'dev@email.com', '1992-08-21', 'enUS', '', '$2y$10$vW783q3GkTPvECEji546DuU5l.6uwPaq28TIxn..ai71qxLga7YAi', NULL, '2019-01-20 06:37:03', '2019-08-29 18:55:06', '[]', NULL, NULL),
(11, 'teste', 'teste@email.com', '1992-01-21', 'enUS', '', '$2y$10$/x58zz6nYY9ONyyDQVLYv.SiUJbRs6phBzgh3s9kXoTF.VMtHQ/Ce', 'UTku5Y6PZKhr6UIdjMmymNPyZqX5wSE3EBvjjFA21Xt2kuCaauq3kGHLBKyd', '2019-01-27 02:46:16', '2019-08-29 18:55:06', '[]', '::1', 'jaGCFcGOHh1yVl4rDZ3Zy11S8j0E6ZKw'),
(12, 'breno', 'breno@email.com', '1991-01-21', 'enUS', '', '$2y$10$5Z8df4jFbNwUxSmFLjDl6.Jg0FJgkc4FPjPswIjNHY1dWB01nfFgu', 'eCunpZ8a3robWUqWIVl1EPcQO9f8531xSZOfRCyxQrqqQXQeWjdbG7e5WFeF', '2019-01-28 02:08:27', '2019-08-29 18:55:06', '[]', NULL, NULL),
(13, 'lgopt', 'lgopt@email.com', '1991-01-21', 'enUS', '', '$2y$10$F6klXNC1NoKMJkFosuN4DejT7P45U3y/gYbf5LJ92kdpSs22DeNuW', 'HCP4tK9GECTUVi7yWu3JxZWjCaF4eBtAzb6lh8IzkO1xCGabCZ6FDvqTCkK0', '2019-01-30 00:25:15', '2019-08-29 18:55:06', '[]', NULL, NULL),
(14, 'sorriso', 'sorriso@email.com', '1991-01-21', 'enUS', '', '$2y$10$wxaPBHdZnHaJn63BqTQEYuv3v2DLFgYHG2ehb7lGUnP3BN3X3cnK6', NULL, '2019-01-30 05:07:27', '2019-08-29 18:55:06', '[]', NULL, NULL),
(15, 'lgopt1234', 'lgopt1234@email.com', '1991-01-21', 'enUS', '', '$2y$10$XcJroP8znw8UZ4rPiR3QCObT04qwQA7g2nXtRD9kME6DnpWfxnbI6', NULL, '2019-01-30 08:07:35', '2019-08-29 18:55:06', '[]', NULL, NULL),
(16, 'quit', 'quit@email.com', '1991-01-21', 'enUS', '', '$2y$10$7CcCBPy12VeyCc4NM8/V5.w67gbsi8ua2cG2IAC0nc6loPPRm44xu', 'c1otZ4iTtCzaJATlvchPl2i0iXyUIjRfslTg7KKf0WOJfDZuxKaZOTdOZZzK', '2019-01-30 08:52:52', '2019-08-29 18:55:06', '[]', '172.19.0.1', 'o2y2mNh9LEzEwn75CFI6qacDzZ84nKnQ'),
(17, 'vagina', 'vagina@email.com', '1991-01-21', 'enUS', '', '$2y$10$l4VohEY/Wck6nG1Z.3mBzedi6/6lAsPduy/mzylicSr/MKVC5U.pS', 'x2PQLl0ef1sZjmj8Fcwnf3AkGKUMVq8KUCwuCpvT8QGoJtCXRGiPrWn9aal8', '2019-01-31 01:27:16', '2019-08-29 18:55:06', '[]', '::1', 'skU5Cc20e3OHFbluBlcul7Ekss2rwdpO'),
(18, 'jon', 'jon@email.com', '1991-01-21', 'enUS', '', '$2y$10$0MXqXXfdsNpJXqb0Ee7QNetGOww7sZ.GdL3ppNPl2lXbYc.D1pDQS', 'nYshJwO9NsC460WVUd5NAbLCEB8L9XxIImayrJY8mSzNXT3BnguuPVNw5xeF', '2019-01-31 01:41:50', '2019-08-29 18:55:06', '[]', '127.0.0.1', 'Cgsz3INoTUiyIciqVoyT7neWpnFdRdhJ'),

--
-- Indexes for dumped tables
--

--
-- Indexes for table `authentication_tokens`
--
ALTER TABLE `authentication_tokens`
ADD PRIMARY KEY (`id`),
ADD KEY `authentication_tokens_user_id_foreign` (`user_id`);

--
-- Indexes for table `comments`
--
ALTER TABLE `comments`
ADD PRIMARY KEY (`id`),
ADD KEY `comments_user_id_foreign` (`user_id`),
ADD KEY `comments_topic_id_foreign` (`topic_id`);

--
-- Indexes for table `downloads`
--
ALTER TABLE `downloads`
ADD PRIMARY KEY (`id`);

--
-- Indexes for table `forums`
--
ALTER TABLE `forums`
ADD PRIMARY KEY (`id`),
ADD KEY `forums_user_id_foreign` (`user_id`);

--
-- Indexes for table `friend_requests`
--
ALTER TABLE `friend_requests`
ADD PRIMARY KEY (`id`),
ADD KEY `friend_requests_sender_foreign` (`sender`),
ADD KEY `friend_requests_receiver_foreign` (`receiver`);

--
-- Indexes for table `game_heroes`
--
ALTER TABLE `game_heroes`
ADD PRIMARY KEY (`heroID`);

--
-- Indexes for table `game_player_regions`
--
ALTER TABLE `game_player_regions`
ADD PRIMARY KEY (`userid`);

--
-- Indexes for table `game_player_server_preferences`
--
ALTER TABLE `game_player_server_preferences`
ADD PRIMARY KEY (`userid`,`gid`);

--
-- Indexes for table `game_stats`
--
ALTER TABLE `game_stats`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `game_stats_user_id_heroid_statskey_unique` (`user_id`,`heroID`,`statsKey`);

--
-- Indexes for table `games`
--
ALTER TABLE `games`
ADD PRIMARY KEY (`gid`);

--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
ADD KEY `password_resets_email_index` (`email`);

--
-- Indexes for table `permission_role`
--
ALTER TABLE `permission_role`
ADD KEY `permission_role_permission_id_foreign` (`permission_id`),
ADD KEY `permission_role_role_id_foreign` (`role_id`);

--
-- Indexes for table `players`
--
ALTER TABLE `players`
ADD PRIMARY KEY (`user_id`);

--
-- Indexes for table `role_user`
--
ALTER TABLE `role_user`
ADD KEY `role_user_user_id_foreign` (`user_id`),
ADD KEY `role_user_role_id_foreign` (`role_id`);

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
ADD PRIMARY KEY (`id`);

--
-- Indexes for table `servers`
--
ALTER TABLE `servers`
ADD PRIMARY KEY (`server_id`);

--
-- Indexes for table `user_friends`
--
ALTER TABLE `user_friends`
ADD PRIMARY KEY (`id`),
ADD KEY `user_friends_user_id_foreign` (`user_id`),
ADD KEY `user_friends_friend_id_foreign` (`friend_id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `users_username_unique` (`username`),
ADD UNIQUE KEY `users_email_unique` (`email`),
ADD UNIQUE KEY `users_game_token_unique` (`game_token`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `authentication_tokens`
--
ALTER TABLE `authentication_tokens`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `comments`
--
ALTER TABLE `comments`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `downloads`
--
ALTER TABLE `downloads`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `forums`
--
ALTER TABLE `forums`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `friend_requests`
--
ALTER TABLE `friend_requests`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `game_heroes`
--
ALTER TABLE `game_heroes`
MODIFY `heroID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;
--
-- AUTO_INCREMENT for table `game_stats`
--
ALTER TABLE `game_stats`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=119;
--
-- AUTO_INCREMENT for table `players`
--
ALTER TABLE `players`
MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;
--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;
--
-- AUTO_INCREMENT for table `servers`
--
ALTER TABLE `servers`
MODIFY `server_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `user_friends`
--
ALTER TABLE `user_friends`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;--
-- Database: `phpmyadmin`
--
CREATE DATABASE IF NOT EXISTS `phpmyadmin` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
USE `phpmyadmin`;

-- --------------------------------------------------------

--
-- Estrutura da tabela `pma__bookmark`
--

CREATE TABLE `pma__bookmark` (
`id` int(11) NOT NULL,
`dbase` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`user` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`label` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
`query` text COLLATE utf8_bin NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Bookmarks';

-- --------------------------------------------------------

--
-- Estrutura da tabela `pma__central_columns`
--

CREATE TABLE `pma__central_columns` (
`db_name` varchar(64) COLLATE utf8_bin NOT NULL,
`col_name` varchar(64) COLLATE utf8_bin NOT NULL,
`col_type` varchar(64) COLLATE utf8_bin NOT NULL,
`col_length` text COLLATE utf8_bin,
`col_collation` varchar(64) COLLATE utf8_bin NOT NULL,
`col_isNull` tinyint(1) NOT NULL,
`col_extra` varchar(255) COLLATE utf8_bin DEFAULT '',
`col_default` text COLLATE utf8_bin
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Central list of columns';

-- --------------------------------------------------------

--
-- Estrutura da tabela `pma__column_info`
--

CREATE TABLE `pma__column_info` (
`id` int(5) UNSIGNED NOT NULL,
`db_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
`table_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
`column_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
`comment` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
`mimetype` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
`transformation` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`transformation_options` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`input_transformation` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`input_transformation_options` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Column information for phpMyAdmin';

-- --------------------------------------------------------

--
-- Estrutura da tabela `pma__designer_settings`
--

CREATE TABLE `pma__designer_settings` (
`username` varchar(64) COLLATE utf8_bin NOT NULL,
`settings_data` text COLLATE utf8_bin NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Settings related to Designer';

-- --------------------------------------------------------

--
-- Estrutura da tabela `pma__export_templates`
--

CREATE TABLE `pma__export_templates` (
`id` int(5) UNSIGNED NOT NULL,
`username` varchar(64) COLLATE utf8_bin NOT NULL,
`export_type` varchar(10) COLLATE utf8_bin NOT NULL,
`template_name` varchar(64) COLLATE utf8_bin NOT NULL,
`template_data` text COLLATE utf8_bin NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Saved export templates';

--
-- Extraindo dados da tabela `pma__export_templates`
--

INSERT INTO `pma__export_templates` (`id`, `username`, `export_type`, `template_name`, `template_data`) VALUES
(1, 'root', 'database', 'heroes', '{"quick_or_custom":"quick","what":"sql","structure_or_data_forced":"0","table_select[]":["authentication_tokens","comments","downloads","failed_jobs","forums","friend_requests","games","game_heroes","game_player_regions","game_player_server_preferences","game_servers","game_server_client","game_server_player_stats","game_server_regions","game_server_stats","game_stats","jobs","migrations","news","password_resets","permissions","permission_role","roles","role_user","topics","users","user_discords","user_friends","user_signatures"],"table_structure[]":["authentication_tokens","comments","downloads","failed_jobs","forums","friend_requests","games","game_heroes","game_player_regions","game_player_server_preferences","game_servers","game_server_client","game_server_player_stats","game_server_regions","game_server_stats","game_stats","jobs","migrations","news","password_resets","permissions","permission_role","roles","role_user","topics","users","user_discords","user_friends","user_signatures"],"table_data[]":["authentication_tokens","comments","downloads","failed_jobs","forums","friend_requests","games","game_heroes","game_player_regions","game_player_server_preferences","game_servers","game_server_client","game_server_player_stats","game_server_regions","game_server_stats","game_stats","jobs","migrations","news","password_resets","permissions","permission_role","roles","role_user","topics","users","user_discords","user_friends","user_signatures"],"output_format":"sendit","onserver":"saveit","filename_template":"__DB__-db_%Y-%m-%d","remember_template":"on","charset":"utf-8","compression":"none","maxsize":"","codegen_structure_or_data":"data","codegen_format":"0","csv_separator":",","csv_enclosed":""","csv_escaped":""","csv_terminated":"AUTO","csv_null":"NULL","csv_structure_or_data":"data","excel_null":"NULL","excel_edition":"win","excel_structure_or_data":"data","htmlword_structure_or_data":"structure_and_data","htmlword_null":"NULL","json_structure_or_data":"data","latex_caption":"something","latex_structure_or_data":"structure_and_data","latex_structure_caption":"Structure of table @TABLE@","latex_structure_continued_caption":"Structure of table @TABLE@ (continued)","latex_structure_label":"tabTABLE@-structure","latex_relation":"something","latex_comments":"something","latex_mime":"something","latex_columns":"something","latex_data_caption":"Content of table @TABLE@","latex_data_continued_caption":"Content of table @TABLE@ (continued)","latex_data_label":"tabTABLE@-data","latex_null":"\\\\textit{NULL}","mediawiki_structure_or_data":"structure_and_data","mediawiki_caption":"something","mediawiki_headers":"something","ods_null":"NULL","ods_structure_or_data":"data","odt_structure_or_data":"structure_and_data","odt_relation":"something","odt_comments":"something","odt_mime":"something","odt_columns":"something","odt_null":"NULL","pdf_report_title":"","pdf_structure_or_data":"structure_and_data","phparray_structure_or_data":"data","sql_include_comments":"something","sql_header_comment":"","sql_compatibility":"NONE","sql_structure_or_data":"structure_and_data","sql_create_table":"something","sql_auto_increment":"something","sql_create_view":"something","sql_procedure_function":"something","sql_create_trigger":"something","sql_backquotes":"something","sql_type":"INSERT","sql_insert_syntax":"both","sql_max_query_size":"50000","sql_hex_for_binary":"something","sql_utc_time":"something","texytext_structure_or_data":"structure_and_data","texytext_null":"NULL","xml_structure_or_data":"data","xml_export_events":"something","xml_export_functions":"something","xml_export_procedures":"something","xml_export_tables":"something","xml_export_triggers":"something","xml_export_views":"something","xml_export_contents":"something","yaml_structure_or_data":"data","quick_export_onserver":null,"quick_export_onserver_overwrite":null,"":null,"lock_tables":null,"onserver_overwrite":null,"as_separate_files":null,"csv_removeCRLF":null,"csv_columns":null,"excel_removeCRLF":null,"excel_columns":null,"htmlword_columns":null,"json_pretty_print":null,"ods_columns":null,"sql_dates":null,"sql_relation":null,"sql_mime":null,"sql_use_transaction":null,"sql_disable_fk":null,"sql_views_as_tables":null,"sql_metadata":null,"sql_create_database":null,"sql_drop_table":null,"sql_if_not_exists":null,"sql_truncate":null,"sql_delayed":null,"sql_ignore":null,"texytext_columns":null}'),
(2, 'root', 'database', 'import', '{"quick_or_custom":"quick","what":"sql","structure_or_data_forced":"0","table_select[]":["authentication_tokens","comments","downloads","failed_jobs","forums","friend_requests","games","game_heroes","game_player_regions","game_player_server_preferences","game_servers","game_server_client","game_server_player_stats","game_server_regions","game_server_stats","game_stats","jobs","migrations","news","password_resets","permissions","permission_role","roles","role_user","topics","users","user_discords","user_friends","user_signatures"],"table_structure[]":["authentication_tokens","comments","downloads","failed_jobs","forums","friend_requests","games","game_heroes","game_player_regions","game_player_server_preferences","game_servers","game_server_client","game_server_player_stats","game_server_regions","game_server_stats","game_stats","jobs","migrations","news","password_resets","permissions","permission_role","roles","role_user","topics","users","user_discords","user_friends","user_signatures"],"table_data[]":["authentication_tokens","comments","downloads","failed_jobs","forums","friend_requests","games","game_heroes","game_player_regions","game_player_server_preferences","game_servers","game_server_client","game_server_player_stats","game_server_regions","game_server_stats","game_stats","jobs","migrations","news","password_resets","permissions","permission_role","roles","role_user","topics","users","user_discords","user_friends","user_signatures"],"output_format":"sendit","onserver":"saveit","filename_template":"__DB__-db_%Y-%m-%d","remember_template":"on","charset":"utf-8","compression":"none","maxsize":"","codegen_structure_or_data":"data","codegen_format":"0","csv_separator":",","csv_enclosed":""","csv_escaped":""","csv_terminated":"AUTO","csv_null":"NULL","csv_structure_or_data":"data","excel_null":"NULL","excel_edition":"win","excel_structure_or_data":"data","htmlword_structure_or_data":"structure_and_data","htmlword_null":"NULL","json_structure_or_data":"data","latex_caption":"something","latex_structure_or_data":"structure_and_data","latex_structure_caption":"Structure of table @TABLE@","latex_structure_continued_caption":"Structure of table @TABLE@ (continued)","latex_structure_label":"tabTABLE@-structure","latex_relation":"something","latex_comments":"something","latex_mime":"something","latex_columns":"something","latex_data_caption":"Content of table @TABLE@","latex_data_continued_caption":"Content of table @TABLE@ (continued)","latex_data_label":"tabTABLE@-data","latex_null":"\\\\textit{NULL}","mediawiki_structure_or_data":"structure_and_data","mediawiki_caption":"something","mediawiki_headers":"something","ods_null":"NULL","ods_structure_or_data":"data","odt_structure_or_data":"structure_and_data","odt_relation":"something","odt_comments":"something","odt_mime":"something","odt_columns":"something","odt_null":"NULL","pdf_report_title":"","pdf_structure_or_data":"structure_and_data","phparray_structure_or_data":"data","sql_include_comments":"something","sql_header_comment":"","sql_compatibility":"NONE","sql_structure_or_data":"structure_and_data","sql_create_table":"something","sql_auto_increment":"something","sql_create_view":"something","sql_procedure_function":"something","sql_create_trigger":"something","sql_backquotes":"something","sql_type":"INSERT","sql_insert_syntax":"both","sql_max_query_size":"50000","sql_hex_for_binary":"something","sql_utc_time":"something","texytext_structure_or_data":"structure_and_data","texytext_null":"NULL","xml_structure_or_data":"data","xml_export_events":"something","xml_export_functions":"something","xml_export_procedures":"something","xml_export_tables":"something","xml_export_triggers":"something","xml_export_views":"something","xml_export_contents":"something","yaml_structure_or_data":"data","quick_export_onserver":null,"quick_export_onserver_overwrite":null,"":null,"lock_tables":null,"onserver_overwrite":null,"as_separate_files":null,"csv_removeCRLF":null,"csv_columns":null,"excel_removeCRLF":null,"excel_columns":null,"htmlword_columns":null,"json_pretty_print":null,"ods_columns":null,"sql_dates":null,"sql_relation":null,"sql_mime":null,"sql_use_transaction":null,"sql_disable_fk":null,"sql_views_as_tables":null,"sql_metadata":null,"sql_create_database":null,"sql_drop_table":null,"sql_if_not_exists":null,"sql_truncate":null,"sql_delayed":null,"sql_ignore":null,"texytext_columns":null}'),
(3, 'root', 'database', 'new.sql', '{"quick_or_custom":"quick","what":"sql","structure_or_data_forced":"0","table_select[]":["authentication_tokens","comments","downloads","forums","friend_requests","games","game_heroes","game_player_regions","game_player_server_preferences","game_stats","password_resets","permissions","permission_role","players","roles","role_user","servers","users","user_friends"],"table_structure[]":["authentication_tokens","comments","downloads","forums","friend_requests","games","game_heroes","game_player_regions","game_player_server_preferences","game_stats","password_resets","permissions","permission_role","players","roles","role_user","servers","users","user_friends"],"table_data[]":["authentication_tokens","comments","downloads","forums","friend_requests","games","game_heroes","game_player_regions","game_player_server_preferences","game_stats","password_resets","permissions","permission_role","players","roles","role_user","servers","users","user_friends"],"output_format":"sendit","onserver":"saveit","filename_template":"__DB__-db_%Y-%m-%d","remember_template":"on","charset":"utf-8","compression":"none","maxsize":"","codegen_structure_or_data":"data","codegen_format":"0","csv_separator":",","csv_enclosed":""","csv_escaped":""","csv_terminated":"AUTO","csv_null":"NULL","csv_structure_or_data":"data","excel_null":"NULL","excel_edition":"win","excel_structure_or_data":"data","htmlword_structure_or_data":"structure_and_data","htmlword_null":"NULL","json_structure_or_data":"data","latex_caption":"something","latex_structure_or_data":"structure_and_data","latex_structure_caption":"Structure of table @TABLE@","latex_structure_continued_caption":"Structure of table @TABLE@ (continued)","latex_structure_label":"tabTABLE@-structure","latex_relation":"something","latex_comments":"something","latex_mime":"something","latex_columns":"something","latex_data_caption":"Content of table @TABLE@","latex_data_continued_caption":"Content of table @TABLE@ (continued)","latex_data_label":"tabTABLE@-data","latex_null":"\\\\textit{NULL}","mediawiki_structure_or_data":"structure_and_data","mediawiki_caption":"something","mediawiki_headers":"something","ods_null":"NULL","ods_structure_or_data":"data","odt_structure_or_data":"structure_and_data","odt_relation":"something","odt_comments":"something","odt_mime":"something","odt_columns":"something","odt_null":"NULL","pdf_report_title":"","pdf_structure_or_data":"structure_and_data","phparray_structure_or_data":"data","sql_include_comments":"something","sql_header_comment":"","sql_compatibility":"NONE","sql_structure_or_data":"structure_and_data","sql_create_table":"something","sql_auto_increment":"something","sql_create_view":"something","sql_procedure_function":"something","sql_create_trigger":"something","sql_backquotes":"something","sql_type":"INSERT","sql_insert_syntax":"both","sql_max_query_size":"50000","sql_hex_for_binary":"something","sql_utc_time":"something","texytext_structure_or_data":"structure_and_data","texytext_null":"NULL","xml_structure_or_data":"data","xml_export_events":"something","xml_export_functions":"something","xml_export_procedures":"something","xml_export_tables":"something","xml_export_triggers":"something","xml_export_views":"something","xml_export_contents":"something","yaml_structure_or_data":"data","quick_export_onserver":null,"quick_export_onserver_overwrite":null,"":null,"lock_tables":null,"onserver_overwrite":null,"as_separate_files":null,"csv_removeCRLF":null,"csv_columns":null,"excel_removeCRLF":null,"excel_columns":null,"htmlword_columns":null,"json_pretty_print":null,"ods_columns":null,"sql_dates":null,"sql_relation":null,"sql_mime":null,"sql_use_transaction":null,"sql_disable_fk":null,"sql_views_as_tables":null,"sql_metadata":null,"sql_create_database":null,"sql_drop_table":null,"sql_if_not_exists":null,"sql_truncate":null,"sql_delayed":null,"sql_ignore":null,"texytext_columns":null}');

-- --------------------------------------------------------

--
-- Estrutura da tabela `pma__favorite`
--

CREATE TABLE `pma__favorite` (
`username` varchar(64) COLLATE utf8_bin NOT NULL,
`tables` text COLLATE utf8_bin NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Favorite tables';

-- --------------------------------------------------------

--
-- Estrutura da tabela `pma__history`
--

CREATE TABLE `pma__history` (
`id` bigint(20) UNSIGNED NOT NULL,
`username` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
`db` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
`table` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
`timevalue` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`sqlquery` text COLLATE utf8_bin NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='SQL history for phpMyAdmin';

-- --------------------------------------------------------

--
-- Estrutura da tabela `pma__navigationhiding`
--

CREATE TABLE `pma__navigationhiding` (
`username` varchar(64) COLLATE utf8_bin NOT NULL,
`item_name` varchar(64) COLLATE utf8_bin NOT NULL,
`item_type` varchar(64) COLLATE utf8_bin NOT NULL,
`db_name` varchar(64) COLLATE utf8_bin NOT NULL,
`table_name` varchar(64) COLLATE utf8_bin NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Hidden items of navigation tree';

-- --------------------------------------------------------

--
-- Estrutura da tabela `pma__pdf_pages`
--

CREATE TABLE `pma__pdf_pages` (
`db_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
`page_nr` int(10) UNSIGNED NOT NULL,
`page_descr` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='PDF relation pages for phpMyAdmin';

-- --------------------------------------------------------

--
-- Estrutura da tabela `pma__recent`
--

CREATE TABLE `pma__recent` (
`username` varchar(64) COLLATE utf8_bin NOT NULL,
`tables` text COLLATE utf8_bin NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Recently accessed tables';

--
-- Extraindo dados da tabela `pma__recent`
--

INSERT INTO `pma__recent` (`username`, `tables`) VALUES
('root', '[{"db":"goheroes","table":"audits"},{"db":"goheroes","table":"news"},{"db":"goheroes","table":"permission_role"},{"db":"goheroes","table":"permissions"},{"db":"goheroes","table":"role_user"},{"db":"goheroes","table":"roles"},{"db":"goheroes","table":"game_heroes"},{"db":"goheroes","table":"users"},{"db":"goheroes","table":"servers"},{"db":"goheroes","table":"players"}]');

-- --------------------------------------------------------

--
-- Estrutura da tabela `pma__relation`
--

CREATE TABLE `pma__relation` (
`master_db` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
`master_table` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
`master_field` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
`foreign_db` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
`foreign_table` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
`foreign_field` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Relation table';

-- --------------------------------------------------------

--
-- Estrutura da tabela `pma__savedsearches`
--

CREATE TABLE `pma__savedsearches` (
`id` int(5) UNSIGNED NOT NULL,
`username` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
`db_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
`search_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
`search_data` text COLLATE utf8_bin NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Saved searches';

-- --------------------------------------------------------

--
-- Estrutura da tabela `pma__table_coords`
--

CREATE TABLE `pma__table_coords` (
`db_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
`table_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
`pdf_page_number` int(11) NOT NULL DEFAULT '0',
`x` float UNSIGNED NOT NULL DEFAULT '0',
`y` float UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Table coordinates for phpMyAdmin PDF output';

-- --------------------------------------------------------

--
-- Estrutura da tabela `pma__table_info`
--

CREATE TABLE `pma__table_info` (
`db_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
`table_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
`display_field` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Table information for phpMyAdmin';

-- --------------------------------------------------------

--
-- Estrutura da tabela `pma__table_uiprefs`
--

CREATE TABLE `pma__table_uiprefs` (
`username` varchar(64) COLLATE utf8_bin NOT NULL,
`db_name` varchar(64) COLLATE utf8_bin NOT NULL,
`table_name` varchar(64) COLLATE utf8_bin NOT NULL,
`prefs` text COLLATE utf8_bin NOT NULL,
`last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Tables'' UI preferences';

--
-- Extraindo dados da tabela `pma__table_uiprefs`
--

INSERT INTO `pma__table_uiprefs` (`username`, `db_name`, `table_name`, `prefs`, `last_update`) VALUES
('root', 'heroes', 'game_stats', '{"sorted_col":"`game_stats`.`user_id` ASC"}', '2019-01-02 05:58:48'),
('root', 'new', 'game_heroes', '{"sorted_col":"`user_id` DESC"}', '2019-01-07 01:09:09');

-- --------------------------------------------------------

--
-- Estrutura da tabela `pma__tracking`
--

CREATE TABLE `pma__tracking` (
`db_name` varchar(64) COLLATE utf8_bin NOT NULL,
`table_name` varchar(64) COLLATE utf8_bin NOT NULL,
`version` int(10) UNSIGNED NOT NULL,
`date_created` datetime NOT NULL,
`date_updated` datetime NOT NULL,
`schema_snapshot` text COLLATE utf8_bin NOT NULL,
`schema_sql` text COLLATE utf8_bin,
`data_sql` longtext COLLATE utf8_bin,
`tracking` set('UPDATE','REPLACE','INSERT','DELETE','TRUNCATE','CREATE DATABASE','ALTER DATABASE','DROP DATABASE','CREATE TABLE','ALTER TABLE','RENAME TABLE','DROP TABLE','CREATE INDEX','DROP INDEX','CREATE VIEW','ALTER VIEW','DROP VIEW') COLLATE utf8_bin DEFAULT NULL,
`tracking_active` int(1) UNSIGNED NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Database changes tracking for phpMyAdmin';

-- --------------------------------------------------------

--
-- Estrutura da tabela `pma__userconfig`
--

CREATE TABLE `pma__userconfig` (
`username` varchar(64) COLLATE utf8_bin NOT NULL,
`timevalue` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`config_data` text COLLATE utf8_bin NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='User preferences storage for phpMyAdmin';

--
-- Extraindo dados da tabela `pma__userconfig`
--

INSERT INTO `pma__userconfig` (`username`, `timevalue`, `config_data`) VALUES
('root', '2019-08-29 19:40:08', '{"Export\\/file_template_table":"__TABLE__-tabel_%Y-%m-%d","Export\\/file_template_database":"__DB__-db_%Y-%m-%d","lang":"pt","Export\\/file_template_server":"__SERVER__-mysql_%Y-%m-%d"}');

-- --------------------------------------------------------

--
-- Estrutura da tabela `pma__usergroups`
--

CREATE TABLE `pma__usergroups` (
`usergroup` varchar(64) COLLATE utf8_bin NOT NULL,
`tab` varchar(64) COLLATE utf8_bin NOT NULL,
`allowed` enum('Y','N') COLLATE utf8_bin NOT NULL DEFAULT 'N'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='User groups with configured menu items';

-- --------------------------------------------------------

--
-- Estrutura da tabela `pma__users`
--

CREATE TABLE `pma__users` (
`username` varchar(64) COLLATE utf8_bin NOT NULL,
`usergroup` varchar(64) COLLATE utf8_bin NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Users and their assignments to user groups';

--
-- Extraindo dados da tabela `pma__users`
--

INSERT INTO `pma__users` (`username`, `usergroup`) VALUES
('pma', ''),
('root', '');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `pma__bookmark`
--
ALTER TABLE `pma__bookmark`
ADD PRIMARY KEY (`id`);

--
-- Indexes for table `pma__central_columns`
--
ALTER TABLE `pma__central_columns`
ADD PRIMARY KEY (`db_name`,`col_name`);

--
-- Indexes for table `pma__column_info`
--
ALTER TABLE `pma__column_info`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `db_name` (`db_name`,`table_name`,`column_name`);

--
-- Indexes for table `pma__designer_settings`
--
ALTER TABLE `pma__designer_settings`
ADD PRIMARY KEY (`username`);

--
-- Indexes for table `pma__export_templates`
--
ALTER TABLE `pma__export_templates`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `u_user_type_template` (`username`,`export_type`,`template_name`);

--
-- Indexes for table `pma__favorite`
--
ALTER TABLE `pma__favorite`
ADD PRIMARY KEY (`username`);

--
-- Indexes for table `pma__history`
--
ALTER TABLE `pma__history`
ADD PRIMARY KEY (`id`),
ADD KEY `username` (`username`,`db`,`table`,`timevalue`);

--
-- Indexes for table `pma__navigationhiding`
--
ALTER TABLE `pma__navigationhiding`
ADD PRIMARY KEY (`username`,`item_name`,`item_type`,`db_name`,`table_name`);

--
-- Indexes for table `pma__pdf_pages`
--
ALTER TABLE `pma__pdf_pages`
ADD PRIMARY KEY (`page_nr`),
ADD KEY `db_name` (`db_name`);

--
-- Indexes for table `pma__recent`
--
ALTER TABLE `pma__recent`
ADD PRIMARY KEY (`username`);

--
-- Indexes for table `pma__relation`
--
ALTER TABLE `pma__relation`
ADD PRIMARY KEY (`master_db`,`master_table`,`master_field`),
ADD KEY `foreign_field` (`foreign_db`,`foreign_table`);

--
-- Indexes for table `pma__savedsearches`
--
ALTER TABLE `pma__savedsearches`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `u_savedsearches_username_dbname` (`username`,`db_name`,`search_name`);

--
-- Indexes for table `pma__table_coords`
--
ALTER TABLE `pma__table_coords`
ADD PRIMARY KEY (`db_name`,`table_name`,`pdf_page_number`);

--
-- Indexes for table `pma__table_info`
--
ALTER TABLE `pma__table_info`
ADD PRIMARY KEY (`db_name`,`table_name`);

--
-- Indexes for table `pma__table_uiprefs`
--
ALTER TABLE `pma__table_uiprefs`
ADD PRIMARY KEY (`username`,`db_name`,`table_name`);

--
-- Indexes for table `pma__tracking`
--
ALTER TABLE `pma__tracking`
ADD PRIMARY KEY (`db_name`,`table_name`,`version`);

--
-- Indexes for table `pma__userconfig`
--
ALTER TABLE `pma__userconfig`
ADD PRIMARY KEY (`username`);

--
-- Indexes for table `pma__usergroups`
--
ALTER TABLE `pma__usergroups`
ADD PRIMARY KEY (`usergroup`,`tab`,`allowed`);

--
-- Indexes for table `pma__users`
--
ALTER TABLE `pma__users`
ADD PRIMARY KEY (`username`,`usergroup`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `pma__bookmark`
--
ALTER TABLE `pma__bookmark`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `pma__column_info`
--
ALTER TABLE `pma__column_info`
MODIFY `id` int(5) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `pma__export_templates`
--
ALTER TABLE `pma__export_templates`
MODIFY `id` int(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `pma__history`
--
ALTER TABLE `pma__history`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `pma__pdf_pages`
--
ALTER TABLE `pma__pdf_pages`
MODIFY `page_nr` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `pma__savedsearches`
--
ALTER TABLE `pma__savedsearches`
MODIFY `id` int(5) UNSIGNED NOT NULL AUTO_INCREMENT;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

View attachment 2019-08-29.txt

TheLittlePeach · Aug 31, 2019

TY for update

I miss my website and sql working 100%
you can upload the .sql ? is more easy

nicolasn1 · Oct 25, 2019

After some time,

I managed to recover the blackfyre themed files applied 75% and website works 95% !
working and not with unedited theme 100%

To work 100% you need to create some tables in the
database, unfortunately not yet found.
I would post too

good luck

You must be registered to see links

TheLittlePeach · Oct 30, 2019

ty for the release

DanVancez · May 25, 2021

oh wow, this makes me never want to try and build my own site

the1Domo · May 26, 2021

bro that's not what this is about this game has a lot of features. Battlefield Heroes uses the website for a lot of the communication it's kind of like the API for the game. you also use the website for character creation and character management which you have to literally reconnect flash files to get the character creation to work. it's funny when people post with lack of knowledge acting like they know what they're talkin about.

Welcome!

bfh website

TheLittlePeach

Newbie Spellweaver

Flyer8472

----

TheLittlePeach

Newbie Spellweaver

Flyer8472

----

TheLittlePeach

Newbie Spellweaver

wipoosarapon

Banned

Flyer8472

----

TheLittlePeach

Newbie Spellweaver

Flyer8472

----

nicolasn1

Junior Spellweaver

Attachments

TheLittlePeach

Newbie Spellweaver

nicolasn1

Junior Spellweaver

TheLittlePeach

Newbie Spellweaver

DanVancez

Initiate Mage

the1Domo

Founder of EvilSource

About Us

Online statistics

Forum statistics

RaGEZONE Sponsor