Pliki serwerowe Shakes&Fidget by ZeuSXp

Norbertsons · 20 Sierpnia 2015

@Norbertsons

Pobierz moje pliki i zmień system na dtrive i podmień req.

Bazę danych weź gila.

#NO Karolevsky · 20 Sierpnia 2015

@Norbertsons

Próbuję teraz po raz dziesiąty chyba dziś, plików Zeusa...

Na hostuj gry.

Mówiłeś, o jakiś cyferkach, napisz na pw ;D !

ZeuSXP · 20 Sierpnia 2015

Jest rozwiazanie tego problemu. Jednak jest ono dość kosztowne ( <<<Nie mam na myśli $ ).

Norbertsons · 20 Sierpnia 2015

@ZeuSXP

No właśnie :P.

I tak oni nigdy sami się nie skapną .

GILUxDILU · 20 Sierpnia 2015

@Norbertsons

Próbuję teraz po raz dziesiąty chyba dziś, plików Zeusa...

Na hostuj gry.

Mówiłeś, o jakiś cyferkach, napisz na pw ;D !

Jak opiszesz mi problem na gg to za free Ci pomogę.

gks0770 · 20 Sierpnia 2015

odpaliłem pliki u siebie, i nie rozumiem jaki problem macie żeby ujawnić rozwiązanie, proszę was , nie róbcie z siebie pro programistów jak nie umiecie pomagać

#NO Karolevsky · 21 Sierpnia 2015

Gks wbij na gg ;D !

Pomożesz ty chociaż ?

ZeuSXP · 21 Sierpnia 2015

Aktualizacja WERSJA: 3.0

LionePL · 21 Sierpnia 2015

@ZeuSXP

Działa już w tych plikach wybór profesji, oraz rasy ?

ZeuSXP · 22 Sierpnia 2015

A czemu miał by nie działać.

LionePL · 22 Sierpnia 2015

@ZeuSXP

Wydaję się wszystko być okej, ale gdy wchodzę na serwer pisze na czerwono : Błąd połączenia z serwerem.serwerem.Wiesz jak to

naprawić ?

Norbertsons · 22 Sierpnia 2015

@LionePL

O czym ty mówisz ?

Ta opcja działała już w pierwszej wersji :unsure:.

ZeuSXP · 22 Sierpnia 2015

@LionePL

Może coś źle podałeś podczas instalacji,

LionePL · 22 Sierpnia 2015

@ZeuSXP

Gdy robię serwer na hostujgry, to wpisać localhost na samej górze, czy sql210.hostuj-gry.tk ?

Gdy wrzucam requesta, to niby wszystko jest okej, ale w plikach go nie ma...

Co może być przyczyną ?

Inne requesty działają poprawnie.

ZeuSXP · 22 Sierpnia 2015

Nie pamiętam dokładnie jaki host bazy ma hostuj-gry.tk. Ale w panelu napewno będzie pisać.

LionePL · 22 Sierpnia 2015

@ZeuSXP

Właśnie to zrobiłem, lecz gdy wchodzę na serwer, wyskakuje na czerwono napis : Błąd połączenia z serwerem.

A do tego, gdy wrzucam twojego requesta do plików, to niby jest wszystko okej, ale go nie ma...

Norbertsons · 22 Sierpnia 2015

@LionePL

Może ten host ma ograniczenia na rozmiar jednego pliku?

ZeuSXP · 26 Sierpnia 2015

Refresh :{

TenyPL · 26 Sierpnia 2015

Jak wejsc w panel administratora ?

konkra25 · 26 Sierpnia 2015

domena/panel

Ɖasty · 27 Sierpnia 2015

Witam panowie mam problema wszystko pieknie wgrane ale jednak błąd powiecie w czym problem

dołączam screena

ZeuSXP · 29 Sierpnia 2015

@dasty
Pewnie podałeś domenę ze slash np : "domena.pl/" a powinno być "domena.pl".

Sprawdz to.

Nitr0o · 29 Sierpnia 2015

?><?php  ini_set('display_errors', '0'); if(filesize("../client_cfg.php") > 0 AND filesize("../connect.php") > 0 AND filesize("../panel/dbc.php") > 0) { echo"<meta http-equiv='refresh' content='0; URL=../index.php'>"; exit(); } function instaldb($polaczenie, $typ, $zlotostart, $grzybystart) { $sql[0] =""; $sql[1] ="
CREATE TABLE IF NOT EXISTS `witch` (
  `id` bigint(20) unsigned NOT NULL,
  `work` tinyint(4) NOT NULL DEFAULT '0',
  `id_donation` tinyint(4) NOT NULL DEFAULT '1',
  `progress` bigint(20) NOT NULL DEFAULT '0',
  `users` bigint(20) NOT NULL DEFAULT '10000',
  `scroll_1` int(11) NOT NULL DEFAULT '51',
  `scroll_2` int(11) NOT NULL,
  `scroll_3` int(11) NOT NULL,
  `scroll_4` int(11) NOT NULL,
  `scroll_5` int(11) NOT NULL,
  `scroll_6` int(11) NOT NULL,
  `scroll_7` int(11) NOT NULL,
  `scroll_8` int(11) NOT NULL,
  `scroll_9` int(11) NOT NULL,
  `scroll_10` int(11) NOT NULL,
  `scroll_1_time` bigint(24) NOT NULL DEFAULT '1436778900',
  `scroll_2_time` bigint(24) NOT NULL,
  `scroll_3_time` bigint(24) NOT NULL,
  `scroll_4_time` bigint(24) NOT NULL,
  `scroll_5_time` bigint(24) NOT NULL,
  `scroll_6_time` bigint(24) NOT NULL,
  `scroll_7_time` bigint(24) NOT NULL,
  `scroll_8_time` bigint(24) NOT NULL,
  `scroll_9_time` bigint(24) NOT NULL,
  `scroll_10_time` bigint(24) NOT NULL,
  `scroll_max` int(11) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;"; $sql[2] ="
CREATE TABLE IF NOT EXISTS `banned_ips` (
  `id` int(20) NOT NULL,
  `ip` varchar(30) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;"; $sql[3] = " 
CREATE TABLE IF NOT EXISTS `game_settings` (
  `id` int(11) unsigned NOT NULL,
  `setting` varchar(255) NOT NULL,
  `value` varchar(255) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=46 DEFAULT CHARSET=latin1;"; $sql[4] ="
INSERT INTO `game_settings` (`id`, `setting`, `value`) VALUES
(1, 'EVENT', '0'),
(2, 'TYP_SERWERA', '".$typ."'),
(4, 'FILL_EPIC', '50'),
(3, 'FILL', '25'),
(7, 'MUSH_CHANCE', '10'),
(8, 'MUSH_CHANCE_EVENT', '100'),
(9, 'MUSH_DROP_FOUND', '1'),
(10, 'GAMBLER', '33'),
(11, 'ITEMGEN_CHANCE_EPIC_TAVERN', '5'),
(12, 'ITEMGEN_CHANCE_EPIC_TOILET', '65'),
(13, 'ITEMGEN_CHANCE_EPIC_DUNGEON', '100'),
(14, 'ITEMGEN_CHANCE_EPIC_SHOP', '5'),
(15, 'ITEMGEN_CHANCE_EPIC_EVENTEXTRA', '5'),
(16, 'ITEMGEN_PMUSH_EPIC', '25'),
(17, 'ITEMGEN_PMUSH_TWOSTATS', '15'),
(18, 'ITEMGEN_PMUSH_LIFEPOT', '15'),
(19, 'ITEMGEN_P_MIDDLE_FROM', '1'),
(20, 'ITEMGEN_P_LARGE_FROM', '10'),
(21, 'ITEMGEN_P_SMALL_UNTIL', '3'),
(22, 'ITEMGEN_PGOLD_WEAPON', '100'),
(23, 'ITEMGEN_PGOLD_NWEAPON', '80'),
(24, 'ITEMGEN_PGOLD_P_SMALL', '19'),
(25, 'ITEMGEN_PGOLD_P_MIDDLE', '15'),
(26, 'ITEMGEN_PGOLD_P_LARGE', '22'),
(27, 'ITEMGEN_PGOLD_P_LIFE', '25'),
(28, 'ITEMGEN_PGOLD_FOUND', '15'),
(31, 'SHOP_GTOP_MULTI', '6000'),
(32, 'SHOP_GTOP_SHROOM', '49'),
(33, 'SHOP_GTOP_SHROOM_L', '299'),
(34, 'SHOP_GTOP_SHROOM_XL', '999'),
(35, 'SERVER_RESTART', '1437912000'),
(36, 'FILL_POTION', '10');"; $sql[5] ="
CREATE TABLE IF NOT EXISTS `guilds` (
  `guild_id` int(11) NOT NULL,
  `name` tinytext COLLATE utf8_general_ci NOT NULL,
  `description` text COLLATE utf8_general_ci NOT NULL,
  `arms` varchar(50) COLLATE utf8_general_ci NOT NULL,
  `chat` text COLLATE utf8_general_ci NOT NULL,
  `leader_id` int(11) NOT NULL,
  `honor` int(11) NOT NULL DEFAULT '100',
  `silver` bigint(20) NOT NULL DEFAULT '1000',
  `mushroom` int(11) NOT NULL DEFAULT '0',
  `fortress` smallint(6) NOT NULL DEFAULT '10',
  `treasure` smallint(6) NOT NULL DEFAULT '1',
  `instructor` smallint(6) NOT NULL DEFAULT '1',
  `dung` tinyint(4) NOT NULL DEFAULT '0',
  `catapult` smallint(1) NOT NULL DEFAULT '0',
  `portal_act` int(11) NOT NULL DEFAULT '1',
  `portal_monster` int(11) NOT NULL DEFAULT '1',
  `portal_hp` bigint(20) NOT NULL DEFAULT '1003472384',
  `portal_reset` varchar(30) COLLATE utf8_general_ci NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;"; $sql[6] ="
CREATE TABLE IF NOT EXISTS `guild_attacks` (
  `attack_id` int(11) NOT NULL,
  `guild_id` int(11) NOT NULL,
  `target_id` int(11) NOT NULL,
  `initiater_id` int(11) NOT NULL,
  `attack_time` int(11) NOT NULL,
  `fight` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;"; $sql[7] ="
CREATE TABLE IF NOT EXISTS `guild_attacks_archive` (
  `attack_id` int(11) NOT NULL,
  `guild_id` int(11) NOT NULL,
  `target_id` int(11) NOT NULL,
  `fight_data` longtext COLLATE utf8_general_ci NOT NULL,
  `fight_data_reverse` longtext COLLATE utf8_general_ci NOT NULL,
  `success` text COLLATE utf8_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;"; $sql[8] ="
CREATE TABLE IF NOT EXISTS `guild_chat` (
  `msg_id` int(11) NOT NULL,
  `guild_id` int(11) NOT NULL,
  `sender_id` int(11) NOT NULL,
  `reciver_id` int(11) NOT NULL,
  `time` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `type` int(1) NOT NULL DEFAULT '0',
  `msg` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;"; $sql[9] ="
CREATE TABLE IF NOT EXISTS `guild_donate` (
  `donate_id` int(11) DEFAULT NULL,
  `guild_id` int(11) NOT NULL,
  `donator_id` int(11) NOT NULL,
  `type` int(1) NOT NULL,
  `amount` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;"; $sql[10] ="
CREATE TABLE IF NOT EXISTS `guild_invites` (
  `invite_id` int(11) NOT NULL,
  `guild_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;"; $sql[11] ="
CREATE TABLE IF NOT EXISTS `items` (
  `id` int(11) NOT NULL,
  `enchant` bigint(50) NOT NULL DEFAULT '0',
  `enchant_power` varchar(50) NOT NULL DEFAULT '0',
  `item_type` tinyint(4) NOT NULL,
  `item_id` smallint(6) NOT NULL,
  `dmg_min` int(11) NOT NULL,
  `dmg_max` int(11) NOT NULL,
  `atr_type_1` tinyint(4) NOT NULL,
  `atr_type_2` tinyint(4) NOT NULL,
  `atr_type_3` tinyint(4) NOT NULL,
  `atr_val_1` int(11) NOT NULL,
  `atr_val_2` int(11) NOT NULL,
  `atr_val_3` int(11) NOT NULL,
  `gold` int(11) NOT NULL,
  `mush` int(11) NOT NULL,
  `toilet` int(1) NOT NULL DEFAULT '0',
  `lvl` int(11) NOT NULL DEFAULT '0',
  `slot` tinyint(4) NOT NULL,
  `owner_id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;"; $sql[12] ="
CREATE TABLE IF NOT EXISTS `items_fidget` (
  `id` int(11) NOT NULL,
  `item_type` tinyint(4) NOT NULL,
  `item_id` smallint(6) NOT NULL,
  `dmg_min` int(11) NOT NULL DEFAULT '0',
  `dmg_max` int(11) NOT NULL DEFAULT '0',
  `atr_type_1` int(11) NOT NULL,
  `atr_type_2` int(11) NOT NULL DEFAULT '0',
  `atr_type_3` int(11) NOT NULL DEFAULT '0',
  `atr_val_1` int(11) NOT NULL,
  `atr_val_2` int(11) NOT NULL DEFAULT '0',
  `atr_val_3` int(11) NOT NULL DEFAULT '0',
  `gold` int(11) NOT NULL DEFAULT '0',
  `mush` int(11) NOT NULL DEFAULT '0',
  `slot` int(11) NOT NULL,
  `owner_id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;"; $sql[13] ="
CREATE TABLE IF NOT EXISTS `items_shakes` (
  `id` int(11) NOT NULL,
  `item_type` tinyint(4) NOT NULL,
  `item_id` smallint(6) NOT NULL,
  `dmg_min` int(11) NOT NULL DEFAULT '0',
  `dmg_max` int(11) NOT NULL DEFAULT '0',
  `atr_type_1` int(11) NOT NULL,
  `atr_type_2` int(11) NOT NULL DEFAULT '0',
  `atr_type_3` int(11) NOT NULL DEFAULT '0',
  `atr_val_1` int(11) NOT NULL,
  `atr_val_2` int(11) NOT NULL DEFAULT '0',
  `atr_val_3` int(11) NOT NULL DEFAULT '0',
  `gold` int(11) NOT NULL DEFAULT '0',
  `mush` int(11) NOT NULL DEFAULT '0',
  `slot` int(11) NOT NULL,
  `owner_id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;"; $sql[14] ="
CREATE TABLE IF NOT EXISTS `items_tavern` (
  `id` int(11) NOT NULL,
  `item_type` tinyint(4) NOT NULL,
  `item_id` smallint(6) NOT NULL,
  `dmg_min` int(11) NOT NULL DEFAULT '0',
  `dmg_max` int(11) NOT NULL DEFAULT '0',
  `atr_type_1` int(11) NOT NULL,
  `atr_type_2` int(11) NOT NULL DEFAULT '0',
  `atr_type_3` int(11) NOT NULL DEFAULT '0',
  `atr_val_1` int(11) NOT NULL,
  `atr_val_2` int(11) NOT NULL DEFAULT '0',
  `atr_val_3` int(11) NOT NULL DEFAULT '0',
  `gold` int(11) NOT NULL DEFAULT '0',
  `mush` int(11) NOT NULL DEFAULT '0',
  `quest` int(11) NOT NULL,
  `owner_id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;"; $sql[15] ="
CREATE TABLE IF NOT EXISTS `messages` (
  `msg_id` int(11) NOT NULL,
  `sender_id` int(11) NOT NULL,
  `reciver_id` int(11) NOT NULL,
  `time` bigint(20) NOT NULL,
  `subject` tinytext NOT NULL,
  `msg` text NOT NULL,
  `read` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;"; $sql[16] ="
CREATE TABLE IF NOT EXISTS `timebased_system` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `wert` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;"; $sql[17] ="
CREATE TABLE IF NOT EXISTS `tower_helper_items` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `tower_helper` tinyint(4) NOT NULL,
  `item_type` tinyint(4) NOT NULL,
  `item_id` smallint(6) NOT NULL,
  `dmg_min` int(11) NOT NULL,
  `dmg_max` int(11) NOT NULL,
  `atr_type_1` tinyint(4) NOT NULL,
  `atr_type_2` tinyint(4) NOT NULL,
  `atr_type_3` tinyint(4) NOT NULL,
  `atr_val_1` int(11) NOT NULL,
  `atr_val_2` int(11) NOT NULL,
  `atr_val_3` int(11) NOT NULL,
  `gold` int(11) NOT NULL,
  `mush` int(11) NOT NULL,
  `slot` tinyint(4) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;"; $sql[18] ="
CREATE TABLE IF NOT EXISTS `user_data` (
  `user_id` int(11) NOT NULL,
  `user_name` tinytext COLLATE utf8_general_ci NOT NULL,
  `password` tinytext COLLATE utf8_general_ci NOT NULL,
  `lvl` int(11) NOT NULL DEFAULT '1',
  `silver` bigint(20) NOT NULL DEFAULT '".$zlotostart."',
  `email` tinytext COLLATE utf8_general_ci NOT NULL,
  `email_validate` int(1) NOT NULL DEFAULT '1',
  `last_ip` varchar(30) COLLATE utf8_general_ci NOT NULL,
  `last_activ` varchar(30) COLLATE utf8_general_ci NOT NULL,
  `usysclass` varchar(3) COLLATE utf8_general_ci NOT NULL DEFAULT '1',
  `gchat_last` int(11) NOT NULL DEFAULT '0',
  `gattack_last` int(11) NOT NULL DEFAULT '0',
  `next_code` varchar(30) COLLATE utf8_general_ci NOT NULL DEFAULT '0',
  `next_dreset` varchar(30) COLLATE utf8_general_ci NOT NULL DEFAULT '0',
  `changed_class` varchar(3) COLLATE utf8_general_ci NOT NULL DEFAULT '0',
  `face1` smallint(4) NOT NULL,
  `face2` smallint(4) NOT NULL,
  `face3` smallint(4) NOT NULL,
  `face4` smallint(4) NOT NULL,
  `face5` smallint(4) NOT NULL,
  `face6` smallint(4) NOT NULL,
  `face7` smallint(4) NOT NULL,
  `face8` smallint(4) NOT NULL,
  `face9` smallint(4) NOT NULL,
  `face10` smallint(4) NOT NULL,
  `golden_frame` smallint(4) NOT NULL DEFAULT '0',
  `mushroom` int(50) NOT NULL DEFAULT '".$grzybystart."',
  `kupon` smallint(4) NOT NULL DEFAULT '0',
  `ssid` tinytext COLLATE utf8_general_ci NOT NULL,
  `reg_date` bigint(20) NOT NULL,
  `donor` enum('yes','no') COLLATE utf8_general_ci NOT NULL DEFAULT 'no',
  `warned` enum('yes','no') COLLATE utf8_general_ci NOT NULL DEFAULT 'no',
  `enabled` enum('yes','no') COLLATE utf8_general_ci NOT NULL DEFAULT 'yes',
  `class` tinyint(4) NOT NULL,
  `race` tinyint(4) NOT NULL,
  `gender` tinyint(4) NOT NULL,
  `thirst` smallint(6) NOT NULL DEFAULT '2500',
  `attr_str` int(11) NOT NULL DEFAULT '10',
  `attr_agi` int(11) NOT NULL DEFAULT '10',
  `attr_int` int(11) NOT NULL DEFAULT '10',
  `attr_wit` int(11) NOT NULL DEFAULT '10',
  `attr_luck` int(11) NOT NULL DEFAULT '10',
  `honor` int(11) NOT NULL DEFAULT '100',
  `dungeon_1` tinyint(4) NOT NULL DEFAULT '0',
  `dungeon_2` tinyint(4) NOT NULL DEFAULT '0',
  `dungeon_3` tinyint(4) NOT NULL DEFAULT '0',
  `dungeon_4` tinyint(4) NOT NULL DEFAULT '0',
  `dungeon_5` tinyint(4) NOT NULL DEFAULT '0',
  `dungeon_6` tinyint(4) NOT NULL DEFAULT '0',
  `dungeon_7` tinyint(4) NOT NULL DEFAULT '0',
  `dungeon_8` tinyint(4) NOT NULL DEFAULT '0',
  `dungeon_9` tinyint(4) NOT NULL DEFAULT '0',
  `dungeon_10` tinyint(4) NOT NULL DEFAULT '0',
  `dungeon_11` tinyint(4) NOT NULL DEFAULT '0',
  `dungeon_12` tinyint(4) NOT NULL DEFAULT '0',
  `dungeon_13` tinyint(4) NOT NULL DEFAULT '0',
  `tower_level` tinyint(4) NOT NULL DEFAULT '1',
  `copycat_lvl` varchar(11) COLLATE utf8_general_ci NOT NULL DEFAULT '150:150:150',
  `copycat_str` varchar(100) COLLATE utf8_general_ci NOT NULL DEFAULT '2056:887:884',
  `copycat_dex` varchar(100) COLLATE utf8_general_ci NOT NULL DEFAULT '884:861:1543',
  `copycat_int` varchar(100) COLLATE utf8_general_ci NOT NULL DEFAULT '861:1546:862',
  `copycat_wit` varchar(100) COLLATE utf8_general_ci NOT NULL DEFAULT '1417:1417:1418',
  `copycat_luck` varchar(100) COLLATE utf8_general_ci NOT NULL DEFAULT '1118:1118:1121',
  `guild_id` smallint(6) DEFAULT '0',
  `g_silverspent` bigint(20) NOT NULL,
  `g_mushroomspent` bigint(20) NOT NULL,
  `guild_rank` tinyint(4) NOT NULL DEFAULT '0',
  `guild_join_time` bigint(100) NOT NULL DEFAULT '0',
  `guild_attack` tinyint(4) NOT NULL DEFAULT '0',
  `guild_defend` tinyint(4) NOT NULL DEFAULT '0',
  `guild_portal` varchar(30) COLLATE utf8_general_ci NOT NULL DEFAULT '0',
  `mount` tinyint(4) NOT NULL DEFAULT '0',
  `mount_dur` bigint(20) NOT NULL DEFAULT '0',
  `user_desc` text CHARACTER SET utf8 NOT NULL,
  `medal_gladiator` int(11) NOT NULL DEFAULT '0',
  `medal_adventurer` int(11) NOT NULL DEFAULT '0',
  `medal_employment` int(11) NOT NULL DEFAULT '0',
  `medal_commerce` int(11) NOT NULL DEFAULT '0',
  `medal_bravery` int(11) NOT NULL DEFAULT '0',
  `medal_friendship` int(11) NOT NULL DEFAULT '0',
  `status` tinyint(4) NOT NULL DEFAULT '0',
  `status_end` int(11) NOT NULL DEFAULT '0',
  `status_extra` tinyint(4) NOT NULL DEFAULT '0',
  `quest_gold_1` int(11) NOT NULL DEFAULT '127',
  `quest_location_1` tinyint(4) DEFAULT '4',
  `quest_location_2` tinyint(4) NOT NULL DEFAULT '8',
  `quest_location_3` tinyint(4) NOT NULL DEFAULT '19',
  `quest_exp_1` int(11) NOT NULL DEFAULT '57',
  `quest_dur_1` int(11) NOT NULL DEFAULT '1',
  `quest_reward_1` int(11) NOT NULL DEFAULT '0',
  `quest_gold_2` int(11) NOT NULL DEFAULT '93',
  `quest_exp_2` int(11) NOT NULL DEFAULT '198',
  `quest_dur_2` int(11) NOT NULL DEFAULT '3',
  `quest_reward_2` int(11) NOT NULL DEFAULT '0',
  `quest_gold_3` int(11) NOT NULL DEFAULT '21',
  `quest_exp_3` int(11) NOT NULL DEFAULT '210',
  `quest_dur_3` int(11) NOT NULL DEFAULT '2',
  `quest_reward_3` int(11) NOT NULL DEFAULT '0',
  `exp` bigint(20) NOT NULL DEFAULT '0',
  `dungeon_time` bigint(20) NOT NULL DEFAULT '0',
  `arena_time` bigint(20) NOT NULL DEFAULT '0',
  `beers` int(5) NOT NULL DEFAULT '0',
  `quest_reroll_time` bigint(20) NOT NULL DEFAULT '0',
  `shop_reroll_time` bigint(20) NOT NULL DEFAULT '0',
  `toilet_time` bigint(20) NOT NULL DEFAULT '0',
  `toilet` tinyint(1) NOT NULL DEFAULT '0',
  `toilet_full` tinyint(1) NOT NULL DEFAULT '0',
  `fill_level` int(11) NOT NULL DEFAULT '0',
  `fill_level_next` int(11) NOT NULL DEFAULT '150',
  `aura` tinyint(3) NOT NULL DEFAULT '0',
  `potion_id1` int(11) NOT NULL,
  `potion_id2` int(11) NOT NULL,
  `potion_id3` int(11) NOT NULL,
  `potion_value1` int(11) NOT NULL,
  `potion_value2` int(11) NOT NULL,
  `potion_value3` int(11) NOT NULL,
  `potion_time1` bigint(20) NOT NULL,
  `potion_time2` bigint(20) NOT NULL,
  `potion_time3` bigint(20) NOT NULL,
  `magic_mirror` varchar(13) COLLATE utf8_general_ci NOT NULL DEFAULT '0000000000000',
  `album_level` int(11) NOT NULL DEFAULT '0',
  `album_data` varchar(30) COLLATE utf8_general_ci NOT NULL,
  `portal_act` int(1) NOT NULL DEFAULT '1',
  `portal_monster` int(2) NOT NULL DEFAULT '1',
  `portal_hp` bigint(20) NOT NULL DEFAULT '35938800',
  `portal_time` varchar(4) COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `portal_reset` varchar(30) COLLATE utf8_general_ci NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;"; $sql[19] ="
CREATE TABLE IF NOT EXISTS `user_fights` (
  `fight_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `target_id` int(11) NOT NULL,
  `success` text COLLATE utf8_general_ci NOT NULL,
  `honor` int(11) NOT NULL,
  `fight_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;"; $sql[20] ="
CREATE TABLE IF NOT EXISTS `vouchers` (
  `id` int(11) NOT NULL,
  `code` varchar(10) NOT NULL,
  `type` varchar(30) NOT NULL DEFAULT 'mushroom',
  `amount` varchar(30) NOT NULL,
  `used` varchar(300) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;"; $sql[21] ="
INSERT INTO `witch` (`id`, `work`, `id_donation`, `progress`, `users`, `scroll_1`, `scroll_2`, `scroll_3`, `scroll_4`, `scroll_5`, `scroll_6`, `scroll_7`, `scroll_8`, `scroll_9`, `scroll_10`, `scroll_1_time`, `scroll_2_time`, `scroll_3_time`, `scroll_4_time`, `scroll_5_time`, `scroll_6_time`, `scroll_7_time`, `scroll_8_time`, `scroll_9_time`, `scroll_10_time`, `scroll_max`) VALUES
(1, 1, 1, 0, 1, 51, 101, 71, 91, 41, 61, 81, 31, 11, 51, 1436778900, 1436778900, 1436778900, 1436778900, 1436778900, 1436778900, 1436778900, 1436778900, 1436778900, 1436778900, 9);
"; $sql[22] ="
ALTER TABLE `ajaxchat`
  ADD PRIMARY KEY (`id`);

"; $sql[23] ="
ALTER TABLE `banned_ips`
  ADD PRIMARY KEY (`id`);
"; $sql[24] ="
ALTER TABLE `game_settings`
  ADD PRIMARY KEY (`id`);

"; $sql[25] ="
ALTER TABLE `guilds`
  ADD PRIMARY KEY (`guild_id`);

"; $sql[26] ="
ALTER TABLE `guild_attacks`
  ADD PRIMARY KEY (`attack_id`);

"; $sql[27] ="
ALTER TABLE `guild_attacks_archive`
  ADD PRIMARY KEY (`attack_id`);

"; $sql[28] ="
ALTER TABLE `guild_chat`
  ADD PRIMARY KEY (`msg_id`);

"; $sql[29] ="
ALTER TABLE `guild_invites`
  ADD PRIMARY KEY (`invite_id`);

"; $sql[30] ="
ALTER TABLE `items`
  ADD PRIMARY KEY (`id`);

"; $sql[31] ="
ALTER TABLE `items_fidget`
  ADD PRIMARY KEY (`id`);

"; $sql[32] ="
ALTER TABLE `items_shakes`
  ADD PRIMARY KEY (`id`);

"; $sql[33] ="
ALTER TABLE `items_tavern`
  ADD PRIMARY KEY (`id`);

"; $sql[34] ="
ALTER TABLE `messages`
  ADD PRIMARY KEY (`msg_id`);

"; $sql[35] ="
ALTER TABLE `timebased_system`
  ADD PRIMARY KEY (`id`);

"; $sql[36] ="
ALTER TABLE `tower_helper_items`
  ADD PRIMARY KEY (`id`);

"; $sql[37] ="
ALTER TABLE `user_data`
  ADD PRIMARY KEY (`user_id`);

"; $sql[38] ="
ALTER TABLE `user_fights`
  ADD PRIMARY KEY (`fight_id`);

"; $sql[39] ="
ALTER TABLE `vouchers`
  ADD PRIMARY KEY (`id`);

"; $sql[40] ="
ALTER TABLE `witch`
  ADD PRIMARY KEY (`id`);"; $sql[41] ="
ALTER TABLE `ajaxchat`
  MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT;
"; $sql[41] ="
ALTER TABLE `banned_ips`
  MODIFY `id` int(20) NOT NULL AUTO_INCREMENT;
"; $sql[42] ="
ALTER TABLE `game_settings`
  MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT;
"; $sql[43] ="
ALTER TABLE `guilds`
  MODIFY `guild_id` int(11) NOT NULL AUTO_INCREMENT;
"; $sql[44] ="
ALTER TABLE `guild_attacks`
  MODIFY `attack_id` int(11) NOT NULL AUTO_INCREMENT;
"; $sql[45] ="
ALTER TABLE `guild_chat`
  MODIFY `msg_id` int(11) NOT NULL AUTO_INCREMENT;
"; $sql[46] ="
ALTER TABLE `guild_invites`
  MODIFY `invite_id` int(11) NOT NULL AUTO_INCREMENT;
"; $sql[47] ="
ALTER TABLE `items`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
"; $sql[48] ="
ALTER TABLE `items_fidget`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
"; $sql[49] ="
ALTER TABLE `items_shakes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
"; $sql[50] ="
ALTER TABLE `items_tavern`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
"; $sql[51] ="
ALTER TABLE `messages`
  MODIFY `msg_id` int(11) NOT NULL AUTO_INCREMENT;
"; $sql[52] ="
ALTER TABLE `timebased_system`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
"; $sql[53] ="
ALTER TABLE `tower_helper_items`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
"; $sql[54] ="
ALTER TABLE `user_data`
  MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT;
"; $sql[55] ="
ALTER TABLE `user_fights`
  MODIFY `fight_id` int(11) NOT NULL AUTO_INCREMENT;
"; $sql[56] ="
ALTER TABLE `vouchers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
"; $sql[57] ="
ALTER TABLE `witch`
  MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT;"; for($i=1; $i<58;$i ++) { $test[$i] = $polaczenie->query($sql[$i]); if($i == 57) { return true; } } } function instalclient($adres) { $dane = "1	pl
2	http://img.playa-games.com/res/sfgame/
3	http://img.playa-games.com/res/sfgame/
7	".$adres."
8	http://".$adres."/
9	0
10	http://www.mpcforum.pl/topic/1455193-pliki-sfgame-by-zeusxp/
11	#
12	#
13	#
14	http://forum.sfgame.pl/showthread.php?t=30239
17	3
18	sfgame
21	3
23	1
25	http://".$adres."/request.php?req=%1&random=%2
29	[email protected]
30	http://".$adres."/payment/papaya44.swf
31	http://".$adres."/payment/papaya_cfg.php
32	1
34	2
35	#pomoc
42	1
43	555
48	http://img.playa-games.com/res/sfgame/
46	pl/de/cs/en
47	polish/dutch/czech/english
52	facebook:9152/twitter:9154
53	1:default_phandler
53	166:default_phandler
53	188:default_phandler
53	197:default_phandler
54	0
55	
56	http:///html_payment.php?playerid=&eventid=&country=&androidversion=&store=
57	7
58	0"; $creq = fopen("../client_cfg.php", "a"); flock($creq, 2); fwrite($creq, $dane); flock($creq, 3); fclose($creq); return true; } function instalpanel($sql, $panel) { $sqldane = explode('/', $sql); $host = $sqldane[0]; $login = $sqldane[1]; $haslo = $sqldane[2]; $baza = $sqldane[3]; $pdane = explode('/', $panel); $plogin = $pdane[0]; $phaslo = $pdane[1]; $dane = '<?php
$LOGINp = "'.$plogin.'";
$HASLOp = "'.$phaslo.'";
function dbc()
{
 mysql_connect("'.$host.'", "'.$login.'", "'.$haslo.'") or die(mysql_error());
 mysql_select_db("'.$baza.'") or die(mysql_error());
}
?>'; $creq = fopen("../panel/dbc.php", "a"); flock($creq, 2); fwrite($creq, $dane); flock($creq, 3); fclose($creq); return true; } if(isset($_POST['instaluj'])) { $host = htmlspecialchars($_POST['host']); $login = htmlspecialchars($_POST['login']); $haslo = htmlspecialchars($_POST['haslo']); $baza = htmlspecialchars($_POST['baza']); $adres = htmlspecialchars($_POST['adres']); $plogin = htmlspecialchars($_POST['plogin']); $phaslo = htmlspecialchars($_POST['phaslo']); $typserwera = htmlspecialchars($_POST['typserwera']); if(empty($host) OR empty($login) OR empty($baza) OR empty($adres) OR empty($plogin) OR empty($phaslo) OR empty($typserwera)) { $error = "Proszę uzupełnić wszystkie pola"; } else { if(strlen($plogin) < 4) { $error = "Login do panelu musi zawierac conajmniej 4 znaki."; } else if(strlen($phaslo)< 4) { $error = "Hasło do panelu musi zawierac conajmniej 4 znaki."; } else { $polaczenie = @ mysqli($host, $login, $haslo, $baza); if ($polaczenie->connect_errno!=0) { $error_connect = $polaczenie->connect_errno; switch($error_connect) { case 1044: $error = "Baza danych o takiej nazwie nie istrnieje!"; break; case 1045: $error = "Hasło do bazy danych jest nie poprawne!"; break; case 2002: $error = "Błędny Host bazy danych!"; break; } } else { $dane = '<?php
try 
{
$db = new PDO("mysql:host='.$host.';dbname='.$baza.';charset=utf8", "'.$login.'", "'.$haslo.'");
}
catch (Exception $e) 
{
exit();
}
?>'; $creq = fopen("../connect.php", "a"); flock($creq, 2); fwrite($creq, $dane); flock($creq, 3); fclose($creq); $sql = $host."/".$login."/".$haslo."/".$baza; $panel = $plogin."/".$phaslo; switch($typserwera) { case "Easy": $typ = 3; $grzybystart = 250; $zlotostart = 10000; break; case "Medium": $typ = 2; $grzybystart = 100; $zlotostart = 1000; break; case "Hard": $typ = 1; $grzybystart = 50; $zlotostart = 100; break; } instaldb($polaczenie, $typ, $zlotostart, $grzybystart); instalpanel($sql, $panel); instalclient($adres); $error = "<font color='lime' style='bold' size='4' >Instalacja przebiegła pomyślnie<br>Przekierowywanie.....</font>"; echo '<meta http-equiv="Refresh" content="2; url=../index.php" />'; } } } } ?>
<!DOCTYPE html>
<html>
<head>
<title>Instalacja:  Zbieranie Danych</title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta http-equiv="expires" content="0">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="pragma" content="no-cache">
<meta name="audience" content="All">
<meta content="ZeuSXP" name="author"></meta>
<meta name="robots" content="noindex, nofollow, noarchive">
<style>
body {
	background-repeat: no-repeat;
	background-position: center top;
	background-color: black;
	background-attachment: fixed;
}

.tableinborder {
	background-color: #212121;
	border-left: 1px  #454545 solid;
	border-top: 1px  #454545 solid;
	border-right: 1px  #454545 solid;
}
.tablecat {
	font-size:18px;
	color: #a4a4a4;
}
.tableb {
 color: #ACB1BC;
 background-color: #212121;
}
.tablea {
 color: #ACB1BC;
 background-color: #2B2B2B;
 border-left: 1px  #454545 solid;
 border-right: 1px  #454545 solid;
 text-align: left;
 max-width:150px;
 word-wrap:break-word;
 padding:10px;
}

.input {
	color:silver;
    padding: 4px;
    border-width: 1px;
    border-style: solid;
    border-color: green;
    background: none repeat scroll 0% 0% #3A3A3A;
    border-radius: 2px;  
	width:130px;
}

.input:hover,:focus
{
	border-color: #33ff00;
}


.button {
		background-color: #006600;
        background-repeat: repeat-x;
        background-attachment: scroll;
        background-position: center top;
        background-clip: border-box;
        background-origin: padding-box;
        background-size: auto auto;
		border-style: solid;
		border-color: #212121;
		border-image: none;
		border-width: 1px 1px 0px;
		border-radius: 3px;
		box-shadow: 0px 1px 0px 0px #5C5C5C inset, 0px 2px 3px rgba(0, 0, 0, 0.2);
		color: black;
		text-shadow: 0px -1px 0px #191919;
		font: 300 16px/30px Helvetica,Arial,sans-serif;
		height: 30px;
		padding: 0px 10px;
		text-align: center;
		min-width: 125px;
		display: inline-block;
		cursor: pointer;
}
.button:hover
{
	background-color: #009900;
}

.error
{
	color:red;
	font-size:20px;
	font-style:bold;
}
</style>
</head>
<body>
	
	<center><div id="error" name="error" class="error"><?php  if(isset($error)) { echo "<BR><BR>".$error; } else { echo"<BR><BR><BR>"; } ?></div></center>
	<center><b><font color="gold" size="3">Wersja:</font> <font color="red" size="4">[</font><font color="lime" size="3">3.0<font color="red" size="4">]</font></font></b></center>
	<br>
			<br>
			<form action="instal.php" method="post">
				<table align="center" border="0" cellpadding="4" cellspacing="1" class="tableinborder" summary="none" width="300px">
					<tr>
						<td colspan="2" align="center" class="tablecat">Zbieranie danych: </td>
					</tr>
					<tr>
						<td width="100px" align="left" class="tableb">Host SQL: </td>
								<td align="center" class="tablea">
										<input type="text" class="input" name="host" /> <img src="info.png"  title="Adres serwera mysql" />
								</td>
					</tr>
					
					<tr>
						<td width="100px" align="left" class="tableb">Login SQL:</td>
								<td align="center" class="tablea">
										<input type="text" class="input" name="login" /> <img src="info.png"  title="Login administratora bazy danych" />
								</td>
					</tr>
					<tr>
						<td width="100px" align="left" class="tableb">Hasło SQL:</td>
								<td align="center" class="tablea">
										<input type="password" class="input" name="haslo" /> <img src="info.png"  title="Hasło administratora bazy danych" />
								</td>
					</tr>
					<tr>
						<td width="100px" align="left" class="tableb">Baza SQL:</td>
								<td align="center" class="tablea">
										<input type="text" class="input" name="baza" /> <img src="info.png"  title="Nazwa bazy danych" />
								</td>
					</tr>
					<tr>
						<td width="100px" align="left" class="tableb">Adres Serwera:</td>
								<td align="center" class="tablea">
										<input type="text" class="input" name="adres" /> <img src="info.png"  title="Adres do naszego serwera." />
								</td>
					</tr>
					<tr>
						<td width="100px" align="left" class="tableb">Login do Panelu:</td>
								<td align="center" class="tablea">
										<input type="text" maxlength="30" class="input" name="plogin" /> <img src="info.png" title="Login który będziesz podawał/a podczas logowania do panelu administratora." />
								</td>
					</tr>
					<tr>
						<td width="100px" align="left" class="tableb">Hasło do Panelu:</td>
								<td align="center" class="tablea">
										<input type="password"  maxlength="30"  class="input" name="phaslo" /> <img src="info.png"  title="Hasło które będziesz podawał/a podczas logowania do panelu administratora." />
								</td>
					</tr>
					<tr>
						<td width="100px" align="left" class="tableb">Typ Serwera:</td>
								<td align="center" class="tablea">
										<input type="radio" name="typserwera" value="Hard" />Hard<br>
										<input type="radio" name="typserwera" value="Medium" />Medium<br>
										<input type="radio" name="typserwera" value="Easy" />Easy<br>
								</td>
					</tr>
					<tr>
						<td colspan="2" align="center" class="tablecat">
							<input type="submit" value="Instaluj" class="button" id="next"  />
							<input type="hidden" name="instaluj" value="yes"  />
						</td>
					</tr>
					
			</table>
		</form>
	<br><br>
	<center><font color="silver" size="3"><b>Instalator SFGame by: </b><a href="http://www.mpcforum.pl/user/1340437-zeusxp/" target="_blank" ><b><font color="lime" size="3" >ZeuSxp</font></b></a></center>
</body>
</html>

Takie php-kiddie bym powiedział... Pelno gowna takiego jakim jest norbi

arsoliet · 29 Sierpnia 2015

?><?php  ini_set('display_errors', '0'); if(filesize("../client_cfg.php") > 0 AND filesize("../connect.php") > 0 AND filesize("../panel/dbc.php") > 0) { echo"<meta http-equiv='refresh' content='0; URL=../index.php'>"; exit(); } function instaldb($polaczenie, $typ, $zlotostart, $grzybystart) { $sql[0] =""; $sql[1] ="
CREATE TABLE IF NOT EXISTS `witch` (
  `id` bigint(20) unsigned NOT NULL,
  `work` tinyint(4) NOT NULL DEFAULT '0',
  `id_donation` tinyint(4) NOT NULL DEFAULT '1',
  `progress` bigint(20) NOT NULL DEFAULT '0',
  `users` bigint(20) NOT NULL DEFAULT '10000',
  `scroll_1` int(11) NOT NULL DEFAULT '51',
  `scroll_2` int(11) NOT NULL,
  `scroll_3` int(11) NOT NULL,
  `scroll_4` int(11) NOT NULL,
  `scroll_5` int(11) NOT NULL,
  `scroll_6` int(11) NOT NULL,
  `scroll_7` int(11) NOT NULL,
  `scroll_8` int(11) NOT NULL,
  `scroll_9` int(11) NOT NULL,
  `scroll_10` int(11) NOT NULL,
  `scroll_1_time` bigint(24) NOT NULL DEFAULT '1436778900',
  `scroll_2_time` bigint(24) NOT NULL,
  `scroll_3_time` bigint(24) NOT NULL,
  `scroll_4_time` bigint(24) NOT NULL,
  `scroll_5_time` bigint(24) NOT NULL,
  `scroll_6_time` bigint(24) NOT NULL,
  `scroll_7_time` bigint(24) NOT NULL,
  `scroll_8_time` bigint(24) NOT NULL,
  `scroll_9_time` bigint(24) NOT NULL,
  `scroll_10_time` bigint(24) NOT NULL,
  `scroll_max` int(11) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;"; $sql[2] ="
CREATE TABLE IF NOT EXISTS `banned_ips` (
  `id` int(20) NOT NULL,
  `ip` varchar(30) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;"; $sql[3] = " 
CREATE TABLE IF NOT EXISTS `game_settings` (
  `id` int(11) unsigned NOT NULL,
  `setting` varchar(255) NOT NULL,
  `value` varchar(255) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=46 DEFAULT CHARSET=latin1;"; $sql[4] ="
INSERT INTO `game_settings` (`id`, `setting`, `value`) VALUES
(1, 'EVENT', '0'),
(2, 'TYP_SERWERA', '".$typ."'),
(4, 'FILL_EPIC', '50'),
(3, 'FILL', '25'),
(7, 'MUSH_CHANCE', '10'),
(8, 'MUSH_CHANCE_EVENT', '100'),
(9, 'MUSH_DROP_FOUND', '1'),
(10, 'GAMBLER', '33'),
(11, 'ITEMGEN_CHANCE_EPIC_TAVERN', '5'),
(12, 'ITEMGEN_CHANCE_EPIC_TOILET', '65'),
(13, 'ITEMGEN_CHANCE_EPIC_DUNGEON', '100'),
(14, 'ITEMGEN_CHANCE_EPIC_SHOP', '5'),
(15, 'ITEMGEN_CHANCE_EPIC_EVENTEXTRA', '5'),
(16, 'ITEMGEN_PMUSH_EPIC', '25'),
(17, 'ITEMGEN_PMUSH_TWOSTATS', '15'),
(18, 'ITEMGEN_PMUSH_LIFEPOT', '15'),
(19, 'ITEMGEN_P_MIDDLE_FROM', '1'),
(20, 'ITEMGEN_P_LARGE_FROM', '10'),
(21, 'ITEMGEN_P_SMALL_UNTIL', '3'),
(22, 'ITEMGEN_PGOLD_WEAPON', '100'),
(23, 'ITEMGEN_PGOLD_NWEAPON', '80'),
(24, 'ITEMGEN_PGOLD_P_SMALL', '19'),
(25, 'ITEMGEN_PGOLD_P_MIDDLE', '15'),
(26, 'ITEMGEN_PGOLD_P_LARGE', '22'),
(27, 'ITEMGEN_PGOLD_P_LIFE', '25'),
(28, 'ITEMGEN_PGOLD_FOUND', '15'),
(31, 'SHOP_GTOP_MULTI', '6000'),
(32, 'SHOP_GTOP_SHROOM', '49'),
(33, 'SHOP_GTOP_SHROOM_L', '299'),
(34, 'SHOP_GTOP_SHROOM_XL', '999'),
(35, 'SERVER_RESTART', '1437912000'),
(36, 'FILL_POTION', '10');"; $sql[5] ="
CREATE TABLE IF NOT EXISTS `guilds` (
  `guild_id` int(11) NOT NULL,
  `name` tinytext COLLATE utf8_general_ci NOT NULL,
  `description` text COLLATE utf8_general_ci NOT NULL,
  `arms` varchar(50) COLLATE utf8_general_ci NOT NULL,
  `chat` text COLLATE utf8_general_ci NOT NULL,
  `leader_id` int(11) NOT NULL,
  `honor` int(11) NOT NULL DEFAULT '100',
  `silver` bigint(20) NOT NULL DEFAULT '1000',
  `mushroom` int(11) NOT NULL DEFAULT '0',
  `fortress` smallint(6) NOT NULL DEFAULT '10',
  `treasure` smallint(6) NOT NULL DEFAULT '1',
  `instructor` smallint(6) NOT NULL DEFAULT '1',
  `dung` tinyint(4) NOT NULL DEFAULT '0',
  `catapult` smallint(1) NOT NULL DEFAULT '0',
  `portal_act` int(11) NOT NULL DEFAULT '1',
  `portal_monster` int(11) NOT NULL DEFAULT '1',
  `portal_hp` bigint(20) NOT NULL DEFAULT '1003472384',
  `portal_reset` varchar(30) COLLATE utf8_general_ci NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;"; $sql[6] ="
CREATE TABLE IF NOT EXISTS `guild_attacks` (
  `attack_id` int(11) NOT NULL,
  `guild_id` int(11) NOT NULL,
  `target_id` int(11) NOT NULL,
  `initiater_id` int(11) NOT NULL,
  `attack_time` int(11) NOT NULL,
  `fight` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;"; $sql[7] ="
CREATE TABLE IF NOT EXISTS `guild_attacks_archive` (
  `attack_id` int(11) NOT NULL,
  `guild_id` int(11) NOT NULL,
  `target_id` int(11) NOT NULL,
  `fight_data` longtext COLLATE utf8_general_ci NOT NULL,
  `fight_data_reverse` longtext COLLATE utf8_general_ci NOT NULL,
  `success` text COLLATE utf8_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;"; $sql[8] ="
CREATE TABLE IF NOT EXISTS `guild_chat` (
  `msg_id` int(11) NOT NULL,
  `guild_id` int(11) NOT NULL,
  `sender_id` int(11) NOT NULL,
  `reciver_id` int(11) NOT NULL,
  `time` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `type` int(1) NOT NULL DEFAULT '0',
  `msg` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;"; $sql[9] ="
CREATE TABLE IF NOT EXISTS `guild_donate` (
  `donate_id` int(11) DEFAULT NULL,
  `guild_id` int(11) NOT NULL,
  `donator_id` int(11) NOT NULL,
  `type` int(1) NOT NULL,
  `amount` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;"; $sql[10] ="
CREATE TABLE IF NOT EXISTS `guild_invites` (
  `invite_id` int(11) NOT NULL,
  `guild_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;"; $sql[11] ="
CREATE TABLE IF NOT EXISTS `items` (
  `id` int(11) NOT NULL,
  `enchant` bigint(50) NOT NULL DEFAULT '0',
  `enchant_power` varchar(50) NOT NULL DEFAULT '0',
  `item_type` tinyint(4) NOT NULL,
  `item_id` smallint(6) NOT NULL,
  `dmg_min` int(11) NOT NULL,
  `dmg_max` int(11) NOT NULL,
  `atr_type_1` tinyint(4) NOT NULL,
  `atr_type_2` tinyint(4) NOT NULL,
  `atr_type_3` tinyint(4) NOT NULL,
  `atr_val_1` int(11) NOT NULL,
  `atr_val_2` int(11) NOT NULL,
  `atr_val_3` int(11) NOT NULL,
  `gold` int(11) NOT NULL,
  `mush` int(11) NOT NULL,
  `toilet` int(1) NOT NULL DEFAULT '0',
  `lvl` int(11) NOT NULL DEFAULT '0',
  `slot` tinyint(4) NOT NULL,
  `owner_id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;"; $sql[12] ="
CREATE TABLE IF NOT EXISTS `items_fidget` (
  `id` int(11) NOT NULL,
  `item_type` tinyint(4) NOT NULL,
  `item_id` smallint(6) NOT NULL,
  `dmg_min` int(11) NOT NULL DEFAULT '0',
  `dmg_max` int(11) NOT NULL DEFAULT '0',
  `atr_type_1` int(11) NOT NULL,
  `atr_type_2` int(11) NOT NULL DEFAULT '0',
  `atr_type_3` int(11) NOT NULL DEFAULT '0',
  `atr_val_1` int(11) NOT NULL,
  `atr_val_2` int(11) NOT NULL DEFAULT '0',
  `atr_val_3` int(11) NOT NULL DEFAULT '0',
  `gold` int(11) NOT NULL DEFAULT '0',
  `mush` int(11) NOT NULL DEFAULT '0',
  `slot` int(11) NOT NULL,
  `owner_id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;"; $sql[13] ="
CREATE TABLE IF NOT EXISTS `items_shakes` (
  `id` int(11) NOT NULL,
  `item_type` tinyint(4) NOT NULL,
  `item_id` smallint(6) NOT NULL,
  `dmg_min` int(11) NOT NULL DEFAULT '0',
  `dmg_max` int(11) NOT NULL DEFAULT '0',
  `atr_type_1` int(11) NOT NULL,
  `atr_type_2` int(11) NOT NULL DEFAULT '0',
  `atr_type_3` int(11) NOT NULL DEFAULT '0',
  `atr_val_1` int(11) NOT NULL,
  `atr_val_2` int(11) NOT NULL DEFAULT '0',
  `atr_val_3` int(11) NOT NULL DEFAULT '0',
  `gold` int(11) NOT NULL DEFAULT '0',
  `mush` int(11) NOT NULL DEFAULT '0',
  `slot` int(11) NOT NULL,
  `owner_id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;"; $sql[14] ="
CREATE TABLE IF NOT EXISTS `items_tavern` (
  `id` int(11) NOT NULL,
  `item_type` tinyint(4) NOT NULL,
  `item_id` smallint(6) NOT NULL,
  `dmg_min` int(11) NOT NULL DEFAULT '0',
  `dmg_max` int(11) NOT NULL DEFAULT '0',
  `atr_type_1` int(11) NOT NULL,
  `atr_type_2` int(11) NOT NULL DEFAULT '0',
  `atr_type_3` int(11) NOT NULL DEFAULT '0',
  `atr_val_1` int(11) NOT NULL,
  `atr_val_2` int(11) NOT NULL DEFAULT '0',
  `atr_val_3` int(11) NOT NULL DEFAULT '0',
  `gold` int(11) NOT NULL DEFAULT '0',
  `mush` int(11) NOT NULL DEFAULT '0',
  `quest` int(11) NOT NULL,
  `owner_id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;"; $sql[15] ="
CREATE TABLE IF NOT EXISTS `messages` (
  `msg_id` int(11) NOT NULL,
  `sender_id` int(11) NOT NULL,
  `reciver_id` int(11) NOT NULL,
  `time` bigint(20) NOT NULL,
  `subject` tinytext NOT NULL,
  `msg` text NOT NULL,
  `read` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;"; $sql[16] ="
CREATE TABLE IF NOT EXISTS `timebased_system` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `wert` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;"; $sql[17] ="
CREATE TABLE IF NOT EXISTS `tower_helper_items` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `tower_helper` tinyint(4) NOT NULL,
  `item_type` tinyint(4) NOT NULL,
  `item_id` smallint(6) NOT NULL,
  `dmg_min` int(11) NOT NULL,
  `dmg_max` int(11) NOT NULL,
  `atr_type_1` tinyint(4) NOT NULL,
  `atr_type_2` tinyint(4) NOT NULL,
  `atr_type_3` tinyint(4) NOT NULL,
  `atr_val_1` int(11) NOT NULL,
  `atr_val_2` int(11) NOT NULL,
  `atr_val_3` int(11) NOT NULL,
  `gold` int(11) NOT NULL,
  `mush` int(11) NOT NULL,
  `slot` tinyint(4) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;"; $sql[18] ="
CREATE TABLE IF NOT EXISTS `user_data` (
  `user_id` int(11) NOT NULL,
  `user_name` tinytext COLLATE utf8_general_ci NOT NULL,
  `password` tinytext COLLATE utf8_general_ci NOT NULL,
  `lvl` int(11) NOT NULL DEFAULT '1',
  `silver` bigint(20) NOT NULL DEFAULT '".$zlotostart."',
  `email` tinytext COLLATE utf8_general_ci NOT NULL,
  `email_validate` int(1) NOT NULL DEFAULT '1',
  `last_ip` varchar(30) COLLATE utf8_general_ci NOT NULL,
  `last_activ` varchar(30) COLLATE utf8_general_ci NOT NULL,
  `usysclass` varchar(3) COLLATE utf8_general_ci NOT NULL DEFAULT '1',
  `gchat_last` int(11) NOT NULL DEFAULT '0',
  `gattack_last` int(11) NOT NULL DEFAULT '0',
  `next_code` varchar(30) COLLATE utf8_general_ci NOT NULL DEFAULT '0',
  `next_dreset` varchar(30) COLLATE utf8_general_ci NOT NULL DEFAULT '0',
  `changed_class` varchar(3) COLLATE utf8_general_ci NOT NULL DEFAULT '0',
  `face1` smallint(4) NOT NULL,
  `face2` smallint(4) NOT NULL,
  `face3` smallint(4) NOT NULL,
  `face4` smallint(4) NOT NULL,
  `face5` smallint(4) NOT NULL,
  `face6` smallint(4) NOT NULL,
  `face7` smallint(4) NOT NULL,
  `face8` smallint(4) NOT NULL,
  `face9` smallint(4) NOT NULL,
  `face10` smallint(4) NOT NULL,
  `golden_frame` smallint(4) NOT NULL DEFAULT '0',
  `mushroom` int(50) NOT NULL DEFAULT '".$grzybystart."',
  `kupon` smallint(4) NOT NULL DEFAULT '0',
  `ssid` tinytext COLLATE utf8_general_ci NOT NULL,
  `reg_date` bigint(20) NOT NULL,
  `donor` enum('yes','no') COLLATE utf8_general_ci NOT NULL DEFAULT 'no',
  `warned` enum('yes','no') COLLATE utf8_general_ci NOT NULL DEFAULT 'no',
  `enabled` enum('yes','no') COLLATE utf8_general_ci NOT NULL DEFAULT 'yes',
  `class` tinyint(4) NOT NULL,
  `race` tinyint(4) NOT NULL,
  `gender` tinyint(4) NOT NULL,
  `thirst` smallint(6) NOT NULL DEFAULT '2500',
  `attr_str` int(11) NOT NULL DEFAULT '10',
  `attr_agi` int(11) NOT NULL DEFAULT '10',
  `attr_int` int(11) NOT NULL DEFAULT '10',
  `attr_wit` int(11) NOT NULL DEFAULT '10',
  `attr_luck` int(11) NOT NULL DEFAULT '10',
  `honor` int(11) NOT NULL DEFAULT '100',
  `dungeon_1` tinyint(4) NOT NULL DEFAULT '0',
  `dungeon_2` tinyint(4) NOT NULL DEFAULT '0',
  `dungeon_3` tinyint(4) NOT NULL DEFAULT '0',
  `dungeon_4` tinyint(4) NOT NULL DEFAULT '0',
  `dungeon_5` tinyint(4) NOT NULL DEFAULT '0',
  `dungeon_6` tinyint(4) NOT NULL DEFAULT '0',
  `dungeon_7` tinyint(4) NOT NULL DEFAULT '0',
  `dungeon_8` tinyint(4) NOT NULL DEFAULT '0',
  `dungeon_9` tinyint(4) NOT NULL DEFAULT '0',
  `dungeon_10` tinyint(4) NOT NULL DEFAULT '0',
  `dungeon_11` tinyint(4) NOT NULL DEFAULT '0',
  `dungeon_12` tinyint(4) NOT NULL DEFAULT '0',
  `dungeon_13` tinyint(4) NOT NULL DEFAULT '0',
  `tower_level` tinyint(4) NOT NULL DEFAULT '1',
  `copycat_lvl` varchar(11) COLLATE utf8_general_ci NOT NULL DEFAULT '150:150:150',
  `copycat_str` varchar(100) COLLATE utf8_general_ci NOT NULL DEFAULT '2056:887:884',
  `copycat_dex` varchar(100) COLLATE utf8_general_ci NOT NULL DEFAULT '884:861:1543',
  `copycat_int` varchar(100) COLLATE utf8_general_ci NOT NULL DEFAULT '861:1546:862',
  `copycat_wit` varchar(100) COLLATE utf8_general_ci NOT NULL DEFAULT '1417:1417:1418',
  `copycat_luck` varchar(100) COLLATE utf8_general_ci NOT NULL DEFAULT '1118:1118:1121',
  `guild_id` smallint(6) DEFAULT '0',
  `g_silverspent` bigint(20) NOT NULL,
  `g_mushroomspent` bigint(20) NOT NULL,
  `guild_rank` tinyint(4) NOT NULL DEFAULT '0',
  `guild_join_time` bigint(100) NOT NULL DEFAULT '0',
  `guild_attack` tinyint(4) NOT NULL DEFAULT '0',
  `guild_defend` tinyint(4) NOT NULL DEFAULT '0',
  `guild_portal` varchar(30) COLLATE utf8_general_ci NOT NULL DEFAULT '0',
  `mount` tinyint(4) NOT NULL DEFAULT '0',
  `mount_dur` bigint(20) NOT NULL DEFAULT '0',
  `user_desc` text CHARACTER SET utf8 NOT NULL,
  `medal_gladiator` int(11) NOT NULL DEFAULT '0',
  `medal_adventurer` int(11) NOT NULL DEFAULT '0',
  `medal_employment` int(11) NOT NULL DEFAULT '0',
  `medal_commerce` int(11) NOT NULL DEFAULT '0',
  `medal_bravery` int(11) NOT NULL DEFAULT '0',
  `medal_friendship` int(11) NOT NULL DEFAULT '0',
  `status` tinyint(4) NOT NULL DEFAULT '0',
  `status_end` int(11) NOT NULL DEFAULT '0',
  `status_extra` tinyint(4) NOT NULL DEFAULT '0',
  `quest_gold_1` int(11) NOT NULL DEFAULT '127',
  `quest_location_1` tinyint(4) DEFAULT '4',
  `quest_location_2` tinyint(4) NOT NULL DEFAULT '8',
  `quest_location_3` tinyint(4) NOT NULL DEFAULT '19',
  `quest_exp_1` int(11) NOT NULL DEFAULT '57',
  `quest_dur_1` int(11) NOT NULL DEFAULT '1',
  `quest_reward_1` int(11) NOT NULL DEFAULT '0',
  `quest_gold_2` int(11) NOT NULL DEFAULT '93',
  `quest_exp_2` int(11) NOT NULL DEFAULT '198',
  `quest_dur_2` int(11) NOT NULL DEFAULT '3',
  `quest_reward_2` int(11) NOT NULL DEFAULT '0',
  `quest_gold_3` int(11) NOT NULL DEFAULT '21',
  `quest_exp_3` int(11) NOT NULL DEFAULT '210',
  `quest_dur_3` int(11) NOT NULL DEFAULT '2',
  `quest_reward_3` int(11) NOT NULL DEFAULT '0',
  `exp` bigint(20) NOT NULL DEFAULT '0',
  `dungeon_time` bigint(20) NOT NULL DEFAULT '0',
  `arena_time` bigint(20) NOT NULL DEFAULT '0',
  `beers` int(5) NOT NULL DEFAULT '0',
  `quest_reroll_time` bigint(20) NOT NULL DEFAULT '0',
  `shop_reroll_time` bigint(20) NOT NULL DEFAULT '0',
  `toilet_time` bigint(20) NOT NULL DEFAULT '0',
  `toilet` tinyint(1) NOT NULL DEFAULT '0',
  `toilet_full` tinyint(1) NOT NULL DEFAULT '0',
  `fill_level` int(11) NOT NULL DEFAULT '0',
  `fill_level_next` int(11) NOT NULL DEFAULT '150',
  `aura` tinyint(3) NOT NULL DEFAULT '0',
  `potion_id1` int(11) NOT NULL,
  `potion_id2` int(11) NOT NULL,
  `potion_id3` int(11) NOT NULL,
  `potion_value1` int(11) NOT NULL,
  `potion_value2` int(11) NOT NULL,
  `potion_value3` int(11) NOT NULL,
  `potion_time1` bigint(20) NOT NULL,
  `potion_time2` bigint(20) NOT NULL,
  `potion_time3` bigint(20) NOT NULL,
  `magic_mirror` varchar(13) COLLATE utf8_general_ci NOT NULL DEFAULT '0000000000000',
  `album_level` int(11) NOT NULL DEFAULT '0',
  `album_data` varchar(30) COLLATE utf8_general_ci NOT NULL,
  `portal_act` int(1) NOT NULL DEFAULT '1',
  `portal_monster` int(2) NOT NULL DEFAULT '1',
  `portal_hp` bigint(20) NOT NULL DEFAULT '35938800',
  `portal_time` varchar(4) COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `portal_reset` varchar(30) COLLATE utf8_general_ci NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;"; $sql[19] ="
CREATE TABLE IF NOT EXISTS `user_fights` (
  `fight_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `target_id` int(11) NOT NULL,
  `success` text COLLATE utf8_general_ci NOT NULL,
  `honor` int(11) NOT NULL,
  `fight_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;"; $sql[20] ="
CREATE TABLE IF NOT EXISTS `vouchers` (
  `id` int(11) NOT NULL,
  `code` varchar(10) NOT NULL,
  `type` varchar(30) NOT NULL DEFAULT 'mushroom',
  `amount` varchar(30) NOT NULL,
  `used` varchar(300) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;"; $sql[21] ="
INSERT INTO `witch` (`id`, `work`, `id_donation`, `progress`, `users`, `scroll_1`, `scroll_2`, `scroll_3`, `scroll_4`, `scroll_5`, `scroll_6`, `scroll_7`, `scroll_8`, `scroll_9`, `scroll_10`, `scroll_1_time`, `scroll_2_time`, `scroll_3_time`, `scroll_4_time`, `scroll_5_time`, `scroll_6_time`, `scroll_7_time`, `scroll_8_time`, `scroll_9_time`, `scroll_10_time`, `scroll_max`) VALUES
(1, 1, 1, 0, 1, 51, 101, 71, 91, 41, 61, 81, 31, 11, 51, 1436778900, 1436778900, 1436778900, 1436778900, 1436778900, 1436778900, 1436778900, 1436778900, 1436778900, 1436778900, 9);
"; $sql[22] ="
ALTER TABLE `ajaxchat`
  ADD PRIMARY KEY (`id`);

"; $sql[23] ="
ALTER TABLE `banned_ips`
  ADD PRIMARY KEY (`id`);
"; $sql[24] ="
ALTER TABLE `game_settings`
  ADD PRIMARY KEY (`id`);

"; $sql[25] ="
ALTER TABLE `guilds`
  ADD PRIMARY KEY (`guild_id`);

"; $sql[26] ="
ALTER TABLE `guild_attacks`
  ADD PRIMARY KEY (`attack_id`);

"; $sql[27] ="
ALTER TABLE `guild_attacks_archive`
  ADD PRIMARY KEY (`attack_id`);

"; $sql[28] ="
ALTER TABLE `guild_chat`
  ADD PRIMARY KEY (`msg_id`);

"; $sql[29] ="
ALTER TABLE `guild_invites`
  ADD PRIMARY KEY (`invite_id`);

"; $sql[30] ="
ALTER TABLE `items`
  ADD PRIMARY KEY (`id`);

"; $sql[31] ="
ALTER TABLE `items_fidget`
  ADD PRIMARY KEY (`id`);

"; $sql[32] ="
ALTER TABLE `items_shakes`
  ADD PRIMARY KEY (`id`);

"; $sql[33] ="
ALTER TABLE `items_tavern`
  ADD PRIMARY KEY (`id`);

"; $sql[34] ="
ALTER TABLE `messages`
  ADD PRIMARY KEY (`msg_id`);

"; $sql[35] ="
ALTER TABLE `timebased_system`
  ADD PRIMARY KEY (`id`);

"; $sql[36] ="
ALTER TABLE `tower_helper_items`
  ADD PRIMARY KEY (`id`);

"; $sql[37] ="
ALTER TABLE `user_data`
  ADD PRIMARY KEY (`user_id`);

"; $sql[38] ="
ALTER TABLE `user_fights`
  ADD PRIMARY KEY (`fight_id`);

"; $sql[39] ="
ALTER TABLE `vouchers`
  ADD PRIMARY KEY (`id`);

"; $sql[40] ="
ALTER TABLE `witch`
  ADD PRIMARY KEY (`id`);"; $sql[41] ="
ALTER TABLE `ajaxchat`
  MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT;
"; $sql[41] ="
ALTER TABLE `banned_ips`
  MODIFY `id` int(20) NOT NULL AUTO_INCREMENT;
"; $sql[42] ="
ALTER TABLE `game_settings`
  MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT;
"; $sql[43] ="
ALTER TABLE `guilds`
  MODIFY `guild_id` int(11) NOT NULL AUTO_INCREMENT;
"; $sql[44] ="
ALTER TABLE `guild_attacks`
  MODIFY `attack_id` int(11) NOT NULL AUTO_INCREMENT;
"; $sql[45] ="
ALTER TABLE `guild_chat`
  MODIFY `msg_id` int(11) NOT NULL AUTO_INCREMENT;
"; $sql[46] ="
ALTER TABLE `guild_invites`
  MODIFY `invite_id` int(11) NOT NULL AUTO_INCREMENT;
"; $sql[47] ="
ALTER TABLE `items`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
"; $sql[48] ="
ALTER TABLE `items_fidget`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
"; $sql[49] ="
ALTER TABLE `items_shakes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
"; $sql[50] ="
ALTER TABLE `items_tavern`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
"; $sql[51] ="
ALTER TABLE `messages`
  MODIFY `msg_id` int(11) NOT NULL AUTO_INCREMENT;
"; $sql[52] ="
ALTER TABLE `timebased_system`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
"; $sql[53] ="
ALTER TABLE `tower_helper_items`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
"; $sql[54] ="
ALTER TABLE `user_data`
  MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT;
"; $sql[55] ="
ALTER TABLE `user_fights`
  MODIFY `fight_id` int(11) NOT NULL AUTO_INCREMENT;
"; $sql[56] ="
ALTER TABLE `vouchers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
"; $sql[57] ="
ALTER TABLE `witch`
  MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT;"; for($i=1; $i<58;$i ++) { $test[$i] = $polaczenie->query($sql[$i]); if($i == 57) { return true; } } } function instalclient($adres) { $dane = "1	pl
2	http://img.playa-games.com/res/sfgame/
3	http://img.playa-games.com/res/sfgame/
7	".$adres."
8	http://".$adres."/
9	0
10	http://www.mpcforum.pl/topic/1455193-pliki-sfgame-by-zeusxp/
11	#
12	#
13	#
14	http://forum.sfgame.pl/showthread.php?t=30239
17	3
18	sfgame
21	3
23	1
25	http://".$adres."/request.php?req=%1&random=%2
29	[email protected]
30	http://".$adres."/payment/papaya44.swf
31	http://".$adres."/payment/papaya_cfg.php
32	1
34	2
35	#pomoc
42	1
43	555
48	http://img.playa-games.com/res/sfgame/
46	pl/de/cs/en
47	polish/dutch/czech/english
52	facebook:9152/twitter:9154
53	1:default_phandler
53	166:default_phandler
53	188:default_phandler
53	197:default_phandler
54	0
55	
56	http:///html_payment.php?playerid=&eventid=&country=&androidversion=&store=
57	7
58	0"; $creq = fopen("../client_cfg.php", "a"); flock($creq, 2); fwrite($creq, $dane); flock($creq, 3); fclose($creq); return true; } function instalpanel($sql, $panel) { $sqldane = explode('/', $sql); $host = $sqldane[0]; $login = $sqldane[1]; $haslo = $sqldane[2]; $baza = $sqldane[3]; $pdane = explode('/', $panel); $plogin = $pdane[0]; $phaslo = $pdane[1]; $dane = '<?php
$LOGINp = "'.$plogin.'";
$HASLOp = "'.$phaslo.'";
function dbc()
{
 mysql_connect("'.$host.'", "'.$login.'", "'.$haslo.'") or die(mysql_error());
 mysql_select_db("'.$baza.'") or die(mysql_error());
}
?>'; $creq = fopen("../panel/dbc.php", "a"); flock($creq, 2); fwrite($creq, $dane); flock($creq, 3); fclose($creq); return true; } if(isset($_POST['instaluj'])) { $host = htmlspecialchars($_POST['host']); $login = htmlspecialchars($_POST['login']); $haslo = htmlspecialchars($_POST['haslo']); $baza = htmlspecialchars($_POST['baza']); $adres = htmlspecialchars($_POST['adres']); $plogin = htmlspecialchars($_POST['plogin']); $phaslo = htmlspecialchars($_POST['phaslo']); $typserwera = htmlspecialchars($_POST['typserwera']); if(empty($host) OR empty($login) OR empty($baza) OR empty($adres) OR empty($plogin) OR empty($phaslo) OR empty($typserwera)) { $error = "Proszę uzupełnić wszystkie pola"; } else { if(strlen($plogin) < 4) { $error = "Login do panelu musi zawierac conajmniej 4 znaki."; } else if(strlen($phaslo)< 4) { $error = "Hasło do panelu musi zawierac conajmniej 4 znaki."; } else { $polaczenie = @ mysqli($host, $login, $haslo, $baza); if ($polaczenie->connect_errno!=0) { $error_connect = $polaczenie->connect_errno; switch($error_connect) { case 1044: $error = "Baza danych o takiej nazwie nie istrnieje!"; break; case 1045: $error = "Hasło do bazy danych jest nie poprawne!"; break; case 2002: $error = "Błędny Host bazy danych!"; break; } } else { $dane = '<?php
try 
{
$db = new PDO("mysql:host='.$host.';dbname='.$baza.';charset=utf8", "'.$login.'", "'.$haslo.'");
}
catch (Exception $e) 
{
exit();
}
?>'; $creq = fopen("../connect.php", "a"); flock($creq, 2); fwrite($creq, $dane); flock($creq, 3); fclose($creq); $sql = $host."/".$login."/".$haslo."/".$baza; $panel = $plogin."/".$phaslo; switch($typserwera) { case "Easy": $typ = 3; $grzybystart = 250; $zlotostart = 10000; break; case "Medium": $typ = 2; $grzybystart = 100; $zlotostart = 1000; break; case "Hard": $typ = 1; $grzybystart = 50; $zlotostart = 100; break; } instaldb($polaczenie, $typ, $zlotostart, $grzybystart); instalpanel($sql, $panel); instalclient($adres); $error = "<font color='lime' style='bold' size='4' >Instalacja przebiegła pomyślnie<br>Przekierowywanie.....</font>"; echo '<meta http-equiv="Refresh" content="2; url=../index.php" />'; } } } } ?>
<!DOCTYPE html>
<html>
<head>
<title>Instalacja:  Zbieranie Danych</title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta http-equiv="expires" content="0">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="pragma" content="no-cache">
<meta name="audience" content="All">
<meta content="ZeuSXP" name="author"></meta>
<meta name="robots" content="noindex, nofollow, noarchive">
<style>
body {
	background-repeat: no-repeat;
	background-position: center top;
	background-color: black;
	background-attachment: fixed;
}

.tableinborder {
	background-color: #212121;
	border-left: 1px  #454545 solid;
	border-top: 1px  #454545 solid;
	border-right: 1px  #454545 solid;
}
.tablecat {
	font-size:18px;
	color: #a4a4a4;
}
.tableb {
 color: #ACB1BC;
 background-color: #212121;
}
.tablea {
 color: #ACB1BC;
 background-color: #2B2B2B;
 border-left: 1px  #454545 solid;
 border-right: 1px  #454545 solid;
 text-align: left;
 max-width:150px;
 word-wrap:break-word;
 padding:10px;
}

.input {
	color:silver;
    padding: 4px;
    border-width: 1px;
    border-style: solid;
    border-color: green;
    background: none repeat scroll 0% 0% #3A3A3A;
    border-radius: 2px;  
	width:130px;
}

.input:hover,:focus
{
	border-color: #33ff00;
}


.button {
		background-color: #006600;
        background-repeat: repeat-x;
        background-attachment: scroll;
        background-position: center top;
        background-clip: border-box;
        background-origin: padding-box;
        background-size: auto auto;
		border-style: solid;
		border-color: #212121;
		border-image: none;
		border-width: 1px 1px 0px;
		border-radius: 3px;
		box-shadow: 0px 1px 0px 0px #5C5C5C inset, 0px 2px 3px rgba(0, 0, 0, 0.2);
		color: black;
		text-shadow: 0px -1px 0px #191919;
		font: 300 16px/30px Helvetica,Arial,sans-serif;
		height: 30px;
		padding: 0px 10px;
		text-align: center;
		min-width: 125px;
		display: inline-block;
		cursor: pointer;
}
.button:hover
{
	background-color: #009900;
}

.error
{
	color:red;
	font-size:20px;
	font-style:bold;
}
</style>
</head>
<body>
	
	<center><div id="error" name="error" class="error"><?php  if(isset($error)) { echo "<BR><BR>".$error; } else { echo"<BR><BR><BR>"; } ?></div></center>
	<center><b><font color="gold" size="3">Wersja:</font> <font color="red" size="4">[</font><font color="lime" size="3">3.0<font color="red" size="4">]</font></font></b></center>
	<br>
			<br>
			<form action="instal.php" method="post">
				<table align="center" border="0" cellpadding="4" cellspacing="1" class="tableinborder" summary="none" width="300px">
					<tr>
						<td colspan="2" align="center" class="tablecat">Zbieranie danych: </td>
					</tr>
					<tr>
						<td width="100px" align="left" class="tableb">Host SQL: </td>
								<td align="center" class="tablea">
										<input type="text" class="input" name="host" /> <img src="info.png"  title="Adres serwera mysql" />
								</td>
					</tr>
					
					<tr>
						<td width="100px" align="left" class="tableb">Login SQL:</td>
								<td align="center" class="tablea">
										<input type="text" class="input" name="login" /> <img src="info.png"  title="Login administratora bazy danych" />
								</td>
					</tr>
					<tr>
						<td width="100px" align="left" class="tableb">Hasło SQL:</td>
								<td align="center" class="tablea">
										<input type="password" class="input" name="haslo" /> <img src="info.png"  title="Hasło administratora bazy danych" />
								</td>
					</tr>
					<tr>
						<td width="100px" align="left" class="tableb">Baza SQL:</td>
								<td align="center" class="tablea">
										<input type="text" class="input" name="baza" /> <img src="info.png"  title="Nazwa bazy danych" />
								</td>
					</tr>
					<tr>
						<td width="100px" align="left" class="tableb">Adres Serwera:</td>
								<td align="center" class="tablea">
										<input type="text" class="input" name="adres" /> <img src="info.png"  title="Adres do naszego serwera." />
								</td>
					</tr>
					<tr>
						<td width="100px" align="left" class="tableb">Login do Panelu:</td>
								<td align="center" class="tablea">
										<input type="text" maxlength="30" class="input" name="plogin" /> <img src="info.png" title="Login który będziesz podawał/a podczas logowania do panelu administratora." />
								</td>
					</tr>
					<tr>
						<td width="100px" align="left" class="tableb">Hasło do Panelu:</td>
								<td align="center" class="tablea">
										<input type="password"  maxlength="30"  class="input" name="phaslo" /> <img src="info.png"  title="Hasło które będziesz podawał/a podczas logowania do panelu administratora." />
								</td>
					</tr>
					<tr>
						<td width="100px" align="left" class="tableb">Typ Serwera:</td>
								<td align="center" class="tablea">
										<input type="radio" name="typserwera" value="Hard" />Hard<br>
										<input type="radio" name="typserwera" value="Medium" />Medium<br>
										<input type="radio" name="typserwera" value="Easy" />Easy<br>
								</td>
					</tr>
					<tr>
						<td colspan="2" align="center" class="tablecat">
							<input type="submit" value="Instaluj" class="button" id="next"  />
							<input type="hidden" name="instaluj" value="yes"  />
						</td>
					</tr>
					
			</table>
		</form>
	<br><br>
	<center><font color="silver" size="3"><b>Instalator SFGame by: </b><a href="http://www.mpcforum.pl/user/1340437-zeusxp/" target="_blank" ><b><font color="lime" size="3" >ZeuSxp</font></b></a></center>
</body>
</html>

Takie php-kiddie bym powiedział... Pelno gowna takiego jakim jest norbi

Po co wszystko masz tak? Ja bym bazę dał do pliku np. baza.sql i napisał 10 linijkowy skrypt na import bazy danych. Po co się trudzić, rozpisywać?

Nitr0o · 29 Sierpnia 2015

Po co wszystko masz tak? Ja bym bazę dał do pliku np. baza.sql i napisał 10 linijkowy skrypt na import bazy danych. Po co się trudzić, rozpisywać?

To jest skrypt instalacyjny zeusa, sklejony z ~5 poradnikow, i wyglada jak gowno

Zaloguj się

👋 Witaj na MPCForum!

Pliki serwerowe Shakes&Fidget by ZeuSXp

Rekomendowane odpowiedzi

Zarchiwizowany