Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[RELEASE] Pokeworld - a major improved Pokémon-SKY spinoff

Initiate Mage
Joined
Sep 21, 2017
Messages
14
Reaction score
0
Help me I sent all the files to my site but even then nothing appears the page is always blank Look here at the link: Pkmorigin.a0001.net
 
Initiate Mage
Joined
Sep 21, 2017
Messages
14
Reaction score
0
I am having an error in globaldef.php


Notice: Undefined variable: db in /home/vol13_1/byethost14.com/b14_20732101/pkmorigin.a0001.net/htdocs/includes/globaldefs.php on line 16

Fatal error: Uncaught Error: Call to a member function prepare() on null in /home/vol13_1/byethost14.com/b14_20732101/pkmorigin.a0001.net/htdocs/includes/globaldefs.php:16 Stack trace: #0 /home/vol13_1/byethost14.com/b14_20732101/pkmorigin.a0001.net/htdocs/index.php(12): include_once() #1 {main} thrown in /home/vol13_1/byethost14.com/b14_20732101/pkmorigin.a0001.net/htdocs/includes/globaldefs.php on line 16
 
Initiate Mage
Joined
Sep 21, 2017
Messages
14
Reaction score
0
Help me



I'm trying to put this game on my site but i'm getting it because it say:
Notice: Undefined variable: db in /home/vol13_1/byethost14.com/b14_20732101/pkmorigin.a0001.net/htdocs/includes/globaldefs.php on line 16

Fatal error: Call to a member function prepare() on null in /home/vol13_1/byethost14.com/b14_20732101/pkmorigin.a0001.net/htdocs/includes/globaldefs.php on line 16
 
Initiate Mage
Joined
Feb 3, 2016
Messages
2
Reaction score
1
Hey, Thanks for sharing! Question - Why in the Pokemon Center my "dead" pokemons doesnt shown..Screenshot:
 
Initiate Mage
Joined
Sep 21, 2017
Messages
6
Reaction score
0
Nothing appears on the screen. :/
 
Junior Spellweaver
Joined
Feb 27, 2012
Messages
188
Reaction score
19
Nothing appears on the screen. :/

This could be a Database issue, seems like you did not run the upgraded SQL.
Do other pages work?

Run this in PHPMyAdmin
Code:
ALTER TABLE `nieuws` ADD `titel_en` VARCHAR(255) NOT NULL AFTER `id`;
INSERT INTO `settings` (`setting`, `value`, `globaldef`) VALUES ('editorLanguage', 'en-EN', 1);


Hey, Thanks for sharing! Question - Why in the Pokemon Center my "dead" pokemons doesnt shown..Screenshot:

replace the code in your Pokemoncenter.php with:
Code:
<?php
#Script laden zodat je nooit pagina buiten de index om kan laden
include("includes/security.php");

#Als je geen pokemon bij je hebt, terug naar index.
if ($gebruiker['in_hand'] == 0) header('Location: index.php');

$page = 'pokemoncenter';
#Goeie taal erbij laden voor de page
include_once('language/language-pages.php');

#Als er op de heal knop gedrukt word
if (isset($_POST['heal'])) {
    #Teller op 0 zetten voor het tellen van de pokemon
    $count = 0;
    #Voor alle enabelde checkboxen tellen welke aangevinkt zijn
    $missieAlert = 1;
    for ($i = 0; $i <= $_POST['teller']; $i++) {
        #Makkelijke naam toewijzen
        $pokeid = $_POST['pokemonid' . $i];
        #Kijken als $pokeid numeriek is voor het tellen van de pokemon.
        if (is_numeric($pokeid)) {
            #Is het nummeriek er 1 bij optellen
            if ($gebruiker['admin'] == 1) $count = 1;
            elseif ($gebruiker['premiumaccount'] >= 1) $count = 10;
            else $count = 10;
        }
        #Voor alle pokemon leven op 100% zetten en effect weghalen
        $healAll = $db->prepare("UPDATE `pokemon_speler` SET `leven`=`levenmax`, `effect`='' WHERE `id`=:pokeId");
        $healAll->bindValue(':pokeId', $pokeid, PDO::PARAM_INT);
        $healAll->execute();
        //complete mission 1
        if ($gebruiker['missie_1'] == 0) {
            $completeMission = $db->prepare("UPDATE `gebruikers` SET `missie_1`=1, `silver`=`silver`+50,`rankexp`=rankexp+50 WHERE `user_id`=:uid");
            $completeMission->bindValue(':uid', $gebruiker['user_id'], PDO::PARAM_INT);
            $completeMission->execute();

            if ($missieAlert == 1) {
                echo showToastr("info", "Je hebt een missie behaald!");
            }
            $missieAlert++;
        }
    }

    #Pokemon center tijden opstellen

    if ($gebruiker['premiumaccount'] > 0) {
        $tijdnu = date('Y-m-d H:i:s', strtotime('-1 hour'));
    } else {
        $tijdnu = date('Y-m-d H:i:s');
    };
    #Tijden opslaan
    $saveTimes = $db->prepare("UPDATE `gebruikers` SET `pokecentertijdbegin`=:timeNow, `pokecentertijd`=:countTime WHERE `user_id`=:uid");
    $saveTimes->bindValue(':timeNow', $tijdnu);
    $saveTimes->bindValue(':countTime', $count);
    $saveTimes->bindValue(':uid', $_SESSION['id'], PDO::PARAM_INT);
    $saveTimes->execute();
    #Is er geen tijd, dus ook geen pokemon opgegeven, dan bericht niet laten zien

    if (($count == 10) OR ($count == 20) OR ($count == 30) OR ($count == 40) OR ($count == 50) OR ($count == 60)) {
        $wat = "seconden";
    }


    if ($gebruiker['premiumaccount'] > 0) {
        $error = '<div class="green">' . $txt['success_pokecenter_premium'] . '</div><br/><br/>';
    } else {
        $error = '<div class="green">' . $txt['success_pokecenter'] . ' ' . $count . ' ' . $wat . '.</div><br/><br/>';
    }

}
?>
<script language="javascript">
    var checked = 0;

    function checkAll() {
        checked = !checked;
        for (i = 0; i < document.pokecenter.elements.length; i++) {
            if (document.pokecenter.elements[i].name != 'niet') {
                document.pokecenter.elements[i].checked = checked;
            }
        }
    }
</script>
<?php if (isset($_POST['heal'])) echo $error; ?>
<center>
    <table width="520" cellpadding="0" cellspacing="0">
        <form method="post" name="pokecenter">
            <tr>
                <td colspan="5">
                    <center>
                        <?php
                        if ($gebruiker['premiumaccount'] > 0) echo $txt['title_text_premium'];
                        else echo $txt['title_text_normal'];
                        ?>

                    </center>
                    <br/><br/>
                </td>
            </tr>
            <tr>
                <td width="140" rowspan="8" valign="top"><img src="http://forum.ragezone.com/images/pokemoncenter.gif"></td>
                <td width="60" class="top_first_td" align="center"><input type="checkbox" onClick="checkAll()"></td>
                <td width="100" class="top_td">
                    <center><?php echo $txt['who']; ?></center>
                </td>
                <td width="260" class="top_td"><?php echo $txt['health']; ?></td>
            </tr>
            <?
            #Pokemon query ophalen
            for ($teller = 1; $pokemon = $pokemon_sql->fetch(PDO::FETCH_ASSOC); $teller++) {
                #Gegevens juist laden voor de pokemon
                $pokemon = pokemonei($pokemon);
                $pokemon['naam'] = pokemon_naam($pokemon['naam'], $pokemon['roepnaam']);

                echo "<tr>";
                #Als pokemon geen baby is
                if ($pokemonei['ei'] != 1)
                    echo '<td class="normal_first_td"><center><input type="checkbox" state="enabled" name="pokemonid' . $teller . '" value="' . $pokemon['id'] . '"/></center></td>
          		<input type="hidden" name="teller" value="' . $teller . '">';
                else
                    echo '<td class="normal_first_td"><center><input type="checkbox" id="niet' . $i . '" name="niet" disabled/></center></td>';

                echo '<td class="normal_td"><center><img src="' . $pokemon['animatie'] . '" width="32" height="32"></center></td>';
                #Als pokemon geen baby is
                if ($pokemonei['ei'] != 1)
                    echo '<td class="normal_td"><div class="bar_red">
				  		<div class="progress" style="width: ' . $pokemon['levenprocent'] . '%"></div>
			  		</div></td>';

                else echo "<td class='normal_td'>" . $txt['nvt'] . "</td>";

                echo "</tr>";

            }
            ?>
            <tr>
                <td colspan="4">
                    <button type="submit" name="heal" class="button"><?php echo $txt['button']; ?></button>
                </td>
                </td>
            </tr>
        </form>
    </table>
</center>

That will solve your problem, it should still be cleaned up, but for now you can use it to heal your Pokemon :)
 
Initiate Mage
Joined
Feb 3, 2016
Messages
2
Reaction score
1
This could be a Database issue, seems like you did not run the upgraded SQL.
Do other pages work?

Run this in PHPMyAdmin
Code:
ALTER TABLE `nieuws` ADD `titel_en` VARCHAR(255) NOT NULL AFTER `id`;
INSERT INTO `settings` (`setting`, `value`, `globaldef`) VALUES ('editorLanguage', 'en-EN', 1);




replace the code in your Pokemoncenter.php with:
Code:
<?php
#Script laden zodat je nooit pagina buiten de index om kan laden
include("includes/security.php");

#Als je geen pokemon bij je hebt, terug naar index.
if ($gebruiker['in_hand'] == 0) header('Location: index.php');

$page = 'pokemoncenter';
#Goeie taal erbij laden voor de page
include_once('language/language-pages.php');

#Als er op de heal knop gedrukt word
if (isset($_POST['heal'])) {
    #Teller op 0 zetten voor het tellen van de pokemon
    $count = 0;
    #Voor alle enabelde checkboxen tellen welke aangevinkt zijn
    $missieAlert = 1;
    for ($i = 0; $i <= $_POST['teller']; $i++) {
        #Makkelijke naam toewijzen
        $pokeid = $_POST['pokemonid' . $i];
        #Kijken als $pokeid numeriek is voor het tellen van de pokemon.
        if (is_numeric($pokeid)) {
            #Is het nummeriek er 1 bij optellen
            if ($gebruiker['admin'] == 1) $count = 1;
            elseif ($gebruiker['premiumaccount'] >= 1) $count = 10;
            else $count = 10;
        }
        #Voor alle pokemon leven op 100% zetten en effect weghalen
        $healAll = $db->prepare("UPDATE `pokemon_speler` SET `leven`=`levenmax`, `effect`='' WHERE `id`=:pokeId");
        $healAll->bindValue(':pokeId', $pokeid, PDO::PARAM_INT);
        $healAll->execute();
        //complete mission 1
        if ($gebruiker['missie_1'] == 0) {
            $completeMission = $db->prepare("UPDATE `gebruikers` SET `missie_1`=1, `silver`=`silver`+50,`rankexp`=rankexp+50 WHERE `user_id`=:uid");
            $completeMission->bindValue(':uid', $gebruiker['user_id'], PDO::PARAM_INT);
            $completeMission->execute();

            if ($missieAlert == 1) {
                echo showToastr("info", "Je hebt een missie behaald!");
            }
            $missieAlert++;
        }
    }

    #Pokemon center tijden opstellen

    if ($gebruiker['premiumaccount'] > 0) {
        $tijdnu = date('Y-m-d H:i:s', strtotime('-1 hour'));
    } else {
        $tijdnu = date('Y-m-d H:i:s');
    };
    #Tijden opslaan
    $saveTimes = $db->prepare("UPDATE `gebruikers` SET `pokecentertijdbegin`=:timeNow, `pokecentertijd`=:countTime WHERE `user_id`=:uid");
    $saveTimes->bindValue(':timeNow', $tijdnu);
    $saveTimes->bindValue(':countTime', $count);
    $saveTimes->bindValue(':uid', $_SESSION['id'], PDO::PARAM_INT);
    $saveTimes->execute();
    #Is er geen tijd, dus ook geen pokemon opgegeven, dan bericht niet laten zien

    if (($count == 10) OR ($count == 20) OR ($count == 30) OR ($count == 40) OR ($count == 50) OR ($count == 60)) {
        $wat = "seconden";
    }


    if ($gebruiker['premiumaccount'] > 0) {
        $error = '<div class="green">' . $txt['success_pokecenter_premium'] . '</div><br/><br/>';
    } else {
        $error = '<div class="green">' . $txt['success_pokecenter'] . ' ' . $count . ' ' . $wat . '.</div><br/><br/>';
    }

}
?>
<script language="javascript">
    var checked = 0;

    function checkAll() {
        checked = !checked;
        for (i = 0; i < document.pokecenter.elements.length; i++) {
            if (document.pokecenter.elements[i].name != 'niet') {
                document.pokecenter.elements[i].checked = checked;
            }
        }
    }
</script>
<?php if (isset($_POST['heal'])) echo $error; ?>
<center>
    <table width="520" cellpadding="0" cellspacing="0">
        <form method="post" name="pokecenter">
            <tr>
                <td colspan="5">
                    <center>
                        <?php
                        if ($gebruiker['premiumaccount'] > 0) echo $txt['title_text_premium'];
                        else echo $txt['title_text_normal'];
                        ?>

                    </center>
                    <br/><br/>
                </td>
            </tr>
            <tr>
                <td width="140" rowspan="8" valign="top"><img src="http://forum.ragezone.com/images/pokemoncenter.gif"></td>
                <td width="60" class="top_first_td" align="center"><input type="checkbox" onClick="checkAll()"></td>
                <td width="100" class="top_td">
                    <center><?php echo $txt['who']; ?></center>
                </td>
                <td width="260" class="top_td"><?php echo $txt['health']; ?></td>
            </tr>
            <?
            #Pokemon query ophalen
            for ($teller = 1; $pokemon = $pokemon_sql->fetch(PDO::FETCH_ASSOC); $teller++) {
                #Gegevens juist laden voor de pokemon
                $pokemon = pokemonei($pokemon);
                $pokemon['naam'] = pokemon_naam($pokemon['naam'], $pokemon['roepnaam']);

                echo "<tr>";
                #Als pokemon geen baby is
                if ($pokemonei['ei'] != 1)
                    echo '<td class="normal_first_td"><center><input type="checkbox" state="enabled" name="pokemonid' . $teller . '" value="' . $pokemon['id'] . '"/></center></td>
                  <input type="hidden" name="teller" value="' . $teller . '">';
                else
                    echo '<td class="normal_first_td"><center><input type="checkbox" id="niet' . $i . '" name="niet" disabled/></center></td>';

                echo '<td class="normal_td"><center><img src="' . $pokemon['animatie'] . '" width="32" height="32"></center></td>';
                #Als pokemon geen baby is
                if ($pokemonei['ei'] != 1)
                    echo '<td class="normal_td"><div class="bar_red">
                          <div class="progress" style="width: ' . $pokemon['levenprocent'] . '%"></div>
                      </div></td>';

                else echo "<td class='normal_td'>" . $txt['nvt'] . "</td>";

                echo "</tr>";

            }
            ?>
            <tr>
                <td colspan="4">
                    <button type="submit" name="heal" class="button"><?php echo $txt['button']; ?></button>
                </td>
                </td>
            </tr>
        </form>
    </table>
</center>

That will solve your problem, it should still be cleaned up, but for now you can use it to heal your Pokemon :)
Thank you bro! works like a charm ;)
 
Initiate Mage
Joined
Sep 21, 2017
Messages
6
Reaction score
0
Yes, i read the readme.
First PHP 7.0, now 5.6. Same problem, no page. None of them work. :/
 
Junior Spellweaver
Joined
Feb 27, 2012
Messages
188
Reaction score
19
Yes, i read the readme.
First PHP 7.0, now 5.6. Same problem, no page. None of them work. :/
Did you run de updated SQL file?
Homepage could be like this if you did not run it.

If this doesnt work either, turn on error reporting in the index.php and show us a screenshot with the messages :)

Verstuurd vanaf mijn SM-G920F met Tapatalk
 
Initiate Mage
Joined
Sep 21, 2017
Messages
6
Reaction score
0
SQL:
Errors on:

I'm sorry for the work you're taking to help me. :/
 
Junior Spellweaver
Joined
Feb 27, 2012
Messages
188
Reaction score
19
SQL:
Errors on:

I'm sorry for the work you're taking to help me. :/

No problem mate.

For the error message on the News:
Go to your PHPMyAdmin > SQL and run this:
Code:
ALTER TABLE `nieuws` ADD `titel_en` VARCHAR(255) NOT NULL AFTER `id`;
INSERT INTO `settings` (`setting`, `value`, `globaldef`) VALUES ('editorLanguage', 'en-EN', 1);

this wil solve most of your issue :closedeyes:



For the others:
Here are the updated Wild attack files (will work with PHP 7.* now):
View attachment Pokeworld.zip

Here is the SQL for the 'voordeel' table which everybody is missing.
No data is in it, but it will solve some errors in the battles.

Code:
 -- phpMyAdmin SQL Dump
-- version 4.5.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Gegenereerd op: 28 sep 2017 om 22:38
-- Serverversie: 10.1.16-MariaDB
-- PHP-versie: 7.0.9

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


/*!40101 SET     [USER=1333464006]old[/USER]_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET     [USER=1333464006]old[/USER]_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET     [USER=1333464006]old[/USER]_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `pokemonhunters`
--

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

--
-- Tabelstructuur voor tabel `voordeel`
--

CREATE TABLE `voordeel` (
  `id` int(11) NOT NULL,
  `krachtiger` int(11) NOT NULL,
  `aanval` int(11) NOT NULL,
  `verdediger` int(11) NOT NULL,
  `soort` int(11) NOT NULL,
  `type1` int(11) NOT NULL,
  `type2` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*!40101 SET CHARACTER_SET_CLIENT     [USER=1333464006]old[/USER]_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS     [USER=1333464006]old[/USER]_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION     [USER=1333464006]old[/USER]_COLLATION_CONNECTION */;

I'm not sure if every table type is right, but since there is no data in it at the moment it will only fix some minor error messages in your console...
Table is not needed to make battles fully working
so i'll probably delete the code in the attack files which are calling the queries.
 

Attachments

You must be registered for see attachments list
Last edited:
Initiate Mage
Joined
Sep 21, 2017
Messages
6
Reaction score
0
Thanks! I can login now, but... still dont show pages. :/

The error:
The line:

This error happens when I click to fight (on the map). After that no page works anymore.
 
Initiate Mage
Joined
Feb 3, 2015
Messages
30
Reaction score
11
Thanks! I can login now, but... still dont show pages. :/

The error:
The line:

This error happens when I click to fight (on the map). After that no page works anymore.

I think you still are on the wrong PHP version, however replace the function with this one:

Code:
function [COLOR=#990000]computer_naam[/COLOR]([COLOR=teal]$old[/COLOR]){
    [COLOR=#999988][I]//Staat er een f/m achter de naam Male/Female Character maken[/I][/COLOR]
    if ([COLOR=#999999]preg_match[/COLOR]([COLOR=#BB8844]'/\s/'[/COLOR], [COLOR=teal]$old[/COLOR])) {
        [COLOR=teal]$pokemon[/COLOR] = [COLOR=#999999]explode[/COLOR]([COLOR=#BB8844]" "[/COLOR], [COLOR=teal]$old[/COLOR]);
        if([COLOR=teal]$pokemon[/COLOR][[COLOR=#009999]1[/COLOR]] == [COLOR=#BB8844]"f"[/COLOR])
            return [COLOR=teal]$pokemon[/COLOR][[COLOR=#009999]0[/COLOR]].[COLOR=#BB8844]" ♀"[/COLOR];
        elseif([COLOR=teal]$pokemon[/COLOR][[COLOR=#009999]1[/COLOR]] == [COLOR=#BB8844]"m"[/COLOR])
            return [COLOR=teal]$pokemon[/COLOR][[COLOR=#009999]0[/COLOR]].[COLOR=#BB8844]" ♂"[/COLOR];
        else return [COLOR=teal]$old[/COLOR];
    }
    [COLOR=#999988][I]//Naam bevat geen spatie[/I][/COLOR]
    else return [COLOR=teal]$old[/COLOR];
}
 
Junior Spellweaver
Joined
Feb 27, 2012
Messages
188
Reaction score
19
Market.php PHP 7.* ready :)
Code:
<?
#Script laden zodat je nooit pagina buiten de index om kan laden
include("includes/security.php");

if (($gebruiker['rank'] < 5) && ($_GET['shopitem'] == 'attacks')) header('Location: index.php?page=pokemarket');

$page = 'market';
#Goeie taal erbij laden voor de page
include_once('language/language-pages.php');

#Kijken of je nog wel een itemplek overhebt
if ($gebruiker['item_over'] < 1) {
    echo '<div class="blue">' . $txt['alert_itemplace'] . '</div>';
}
?>
<?
#Ruimte vast stellen Per item.
#Vast stellen welke items nog te koop zijn.
if ($gebruiker['itembox'] == 'Red box') $ruimte['max'] = 250;
elseif ($gebruiker['itembox'] == 'Blue box') $ruimte['max'] = 100;
elseif ($gebruiker['itembox'] == 'Yellow box') $ruimte['max'] = 50;
elseif ($gebruiker['itembox'] == 'Bag') $ruimte['max'] = 20;

#Pagina's opbouwen
switch ($_GET['shopitem']) {
#Als er op balls geklikt word. Het volgende laten zien
case "balls":
$sql = $db->prepare("SELECT `id`, `naam`, `silver`, `gold`, `omschrijving_en` FROM `markt` WHERE `soort`='balls'");
$sql->execute();
#Als er op de knop gedrukt word
if (isset($_POST['balls'])) {
    $gebruiker_silver = $gebruiker['silver'];
    $gebruiker_gold = $gebruiker['gold'];
    #Laden voor de verwerking van de informatie
    for ($i = 1; $i <= $_POST['teller']; $i++) {
        #Item id opvragen
        $itemid = $_POST['id' . $i];
        #Aantal opvragen van het itemid
        $aantal = $_POST['aantal' . $itemid];
        #Als er geen aantal is
        if (empty($aantal)) $niksingevoerd = True;
        elseif (!is_numeric($aantal)) $niksingevoerd = True;
        #Als er wel een aantal is
        elseif (!empty($aantal)) {
            #Item gegevens laden
            $itemgegevensSQL = $db->prepare("SELECT `naam`, `silver`, `gold` FROM `markt` WHERE `id`=:itemId");
            $itemgegevensSQL->bindValue(':itemId', $itemid);
            $itemgegevensSQL->execute();
            $itemgegevens = $itemgegevensSQL->fetch(PDO::FETCH_ASSOC);
            #silver of gold berekenen voor de balls
            if ($itemgegevens['naam'] == 'Master ball') {
                $goldd = $aantal * ($itemgegevens['gold'] / 1);
            } else $silverr = $aantal * ($itemgegevens['silver'] / 1);
            #itemruimte over berekenen
            $ruimteover = $ruimte['max'] - $gebruiker['items'];
            #Kijken als het silver er wel voor is
            if (($gebruiker_silver < $silverr) OR ($gebruiker_gold < $goldd)) {
                echo '<div class="red">' . $txt['alert_not_enough_money'] . '</div>';
            } elseif ($aantal < 0)
                echo '<div class="red">' . $txt['alert_not_enough_money'] . '</div>';
            elseif (!ctype_digit($aantal))
                echo '<div class="red">' . $txt['alert_not_enough_money'] . '</div>';
            #Als speler niet genoeg ruimte heeft voor de balls
            elseif ($ruimteover < $aantal) {
                if ($aantal > 1) $netheid = "'s";
                echo '<div class="red">' . $txt['alert_itembox_full_1'] . ' ' . $ruimteover . ' ' . $itemgegevens['naam'] . $netheid . ' ' . $txt['alert_itembox_full_2'] . '</div>';
            } else {
                #Opslaan
                $totalesilver += $silverr;
                $gebruiker_silver -= $silverr;
                $totalegold += $goldd;
                $gebruiker_gold -= $goldd;

                $updateItem = $db->prepare("UPDATE `gebruikers_item` SET `" . $itemgegevens['naam'] . "`=`" . $itemgegevens['naam'] . "`+:aantal WHERE `user_id`=:uid");
                $updateItem->bindValue(':aantal', $aantal);
                $updateItem->bindValue(':uid', $_SESSION['id']);
                $updateItem->execute();
                echo '<div class="green">' . $txt['success_market'] . ' ' . $itemgegevens['naam'] . ' ' . $aantal . 'x gekocht.</div>';
            }
            $welingevoerd = True;
        }
    }
    #silver opslaan
    $updateMoney = $db->prepare("UPDATE `gebruikers` SET `silver`=`silver`-:silver, gold=gold-:gold WHERE `user_id`=:uid");
    $updateMoney->bindValue(':silver', $totalesilver);
    $updateMoney->bindValue(':gold', $totalegold);
    $updateMoney->bindValue(':uid', $_SESSION['id']);
    $updateMoney->execute();

    if (!$welingevoerd) {
        if ($niksingevoerd) {
            echo '<div class="red">' . $txt['alert_nothing_selected'] . '</div>';
        }
    }
}
?>

<table width="660" cellpadding="0" cellmargin="0">
    <tr>
        <td width="120" rowspan="54" valign="top"><img src="http://forum.ragezone.com/images/market.gif"/></td>
    </tr>
    <?php #Form starten
    echo '<form method="POST" name="balls">
	  <tr>
	  	<td>';

    for ($j = 1; $select = $sql->fetch(PDO::FETCH_ASSOC); $j++) {
        if ($select['naam'] == "Master ball") {
            $icon = 'gold';
            $prijs = number_format(round($select['gold']), 0, ",", ".");

        } else {
            $icon = 'silver';
            $prijs = number_format(round($select['silver']), 0, ",", ".");
        }
        echo '<div style="padding:10px; float:left;">
		  <table width="80" class="greyborder">
		  	<tr>
				<td><center><input type="hidden" name="teller" value="' . $j . '">
				<input type="hidden" name="id' . $j . '" value="' . $select['id'] . '">
				<img src="http://forum.ragezone.com/images/items/' . $select['naam'] . '.png" width=24 height=24 /></center></td>
			</tr>
			<tr>
				<td><span class="smalltext"><center>' . $select['naam'] . '</center></span></td>
			</tr>
			<tr>
				<td><span class="smalltext"><center><img src="http://forum.ragezone.com/images/icons/' . $icon . '.png" alt="' . $icon . '" title="' . $icon . '" style="margin-bottom:-3px;"> ' . $prijs . '</center></span></td>
			</tr>
			<tr>
				<td><div class="smalltext" style="padding-top:5px;"><center><a href="#" class="tooltip" onMouseover="showhint(\'' . $select['omschrijving_en'] . '\', this)">[?]</a></center></div></td>
			</tr>
			<tr>
				<td><div style="padding-top:5px;"><center><input type="text" maxlength="2" class="text_short" name="aantal' . $select['id'] . '" placeholder="0" style="float:none;" /></center></div></td>
			</tr>
		  </table>
		  </div>';
    }
    echo '</td></tr>';
    ?>
    <tr>
        <td>
            <div style="padding-left:10px;">
                <button type="submit" name="balls" class="button"><?php echo $txt['button_balls']; ?></button>
            </div>
        </td>
    </tr>
    </form>

    <?
    #Einde balls
    break;
    #Als er op potions geklikt word, het volgende laten zien
    case "potions":
    $sql = $db->prepare("SELECT `id`, `naam`, `silver`,`gold`, `omschrijving_en` FROM `markt` WHERE `soort`='potions'");
    $sql->execute();
    #Als er op de knop gedrukt word
    if (isset($_POST['potions'])) {
        $gebruiker_silver = $gebruiker['silver'];
        #Laden voor de verwerking van de informatie
        for ($i = 1; $i <= $_POST['teller']; $i++) {
            #Item id opvragen
            $itemid = $_POST['id' . $i];
            #Aantal opvragen van het itemid
            $aantal = $_POST['aantal' . $itemid];
            #Als er geen aantal is
            if (empty($aantal)) $niksingevoerd = True;
            elseif (!is_numeric($aantal)) $niksingevoerd = True;
            #Als er wel een aantal is
            elseif (!empty($aantal)) {
                $niksingevoerd = False;
                #Gegevens laden van de te kopen item
                $itemgegevensSQL = $db->prepare("SELECT `naam`, `silver` FROM `markt` WHERE `id`=:itemId");
                $itemgegevensSQL->bindValue(':itemId', $itemid);
                $itemgegevensSQL->execute();
                $itemgegevens = $itemgegevensSQL->fetch(PDO::FETCH_ASSOC);

                #Prijs bereken voor het aantal potions.
                $silverr = $aantal * ($itemgegevens['silver'] / 1);
                #itemruimte over berekenen
                $ruimteover = $ruimte['max'] - $gebruiker['items'];
                #Kijken als er wel genoeg silver is.
                if ($gebruiker_silver < $silverr) {
                    echo '<div class="red">' . $txt['alert_not_enough_money'] . '</div>';
                } elseif ($aantal < 0)
                    echo '<div class="red">' . $txt['alert_not_enough_money'] . '</div>';
                elseif (!ctype_digit($aantal))
                    echo '<div class="red">' . $txt['alert_not_enough_money'] . '</div>';
                #Kijken als speler nog wel ruimte heeft voor de potions
                elseif ($ruimteover < $aantal) {
                    if ($aantal > 1) $netheid = "'s";
                    echo '<div class="red">' . $txt['alert_itembox_full_1'] . ' ' . $ruimteover . ' ' . $itemgegevens['naam'] . $netheid . ' ' . $txt['alert_itembox_full_2'] . '</div>';
                } else {
                    #Opslaan
                    $totalesilver += $silverr;
                    $gebruiker_silver -= $silverr;
                    $saveSilver = $db->prepare("UPDATE `gebruikers_item` SET `" . $itemgegevens['naam'] . "`=`" . $itemgegevens['naam'] . "`+:aantal WHERE `user_id`=:uid");
                    $saveSilver->bindValue(':aantal', $aantal);
                    $saveSilver->bindValue(':uid', $_SESSION['id']);
                    $saveSilver->execute();

                    echo '<div class="green">' . $txt['success_market'] . ' ' . $itemgegevens['naam'] . ' ' . $aantal . 'x gekocht.</div>';
                }
                $welingevoerd = True;
            }
        }
        #silver opslaan
        $updateSilver = $db->prepare("UPDATE `gebruikers` SET `silver`=`silver`-:silver WHERE `user_id`=:uid");
        $updateSilver->bindValue(':silver', $totalesilver);
        $updateSilver->bindValue(':uid', $_SESSION['id']);
        $updateSilver->execute();

        #Als wel ingevoerd een waarde heeft/true is
        if (!$welingevoerd) {
            #Als niksingevoerd TRUE is
            if ($niksingevoerd) {
                echo '<div class="red">' . $txt['alert_nothing_selected'] . '</div>';
            }
        }
    }
    ?>
    <table width="660" cellpadding="0" cellmargin="0">
        <tr>
            <td width="120" rowspan="54" valign="top"><img src="http://forum.ragezone.com/images/market.gif"/></td>
        </tr>
        <?php #Form starten
        echo '<form method="POST" name="potions">
	  		<tr>
			  <td>';

        for ($j = 1; $select = $sql->fetch(PDO::FETCH_ASSOC); $j++) {
            $prijs = number_format(round($select['silver']), 0, ",", ".");
            echo '<div style="padding:10px; float:left;">
		  <table width="80" class="greyborder">
		  	<tr>
				<td><center><input type="hidden" name="teller" value="' . $j . '">
				<input type="hidden" name="id' . $j . '" value="' . $select['id'] . '">
				<img src="http://forum.ragezone.com/images/items/' . $select['naam'] . '.png" width=24 height=24 /></center></td>
			</tr>
			<tr>
				<td><span class="smalltext"><center>' . $select['naam'] . '</center></span></td>
			</tr>
			<tr>
				<td><span class="smalltext"><center><img src="http://forum.ragezone.com/images/icons/silver.png" alt="Silver" title="Silver" style="margin-bottom:-3px;"> ' . $prijs . '</center></span></td>
			</tr>
			<tr>
				<td><div class="smalltext" style="padding-top:5px;"><center><a href="#" class="tooltip" onMouseover="showhint(\'' . $select['omschrijving_en'] . '\', this)">[?]</a></center></div></td>
			</tr>
			<tr>
				<td><div style="padding-top:5px;"><center><input type="text" maxlength="2" class="text_short" name="aantal' . $select['id'] . '" placeholder="0" style="float:none;" /></center></div></td>
			</tr>
		  </table>
		  </div>';
        }
        echo '</td></tr>';
        ?>
        <tr>
            <td>
                <div style="padding-left:10px;">
                    <button type="submit" name="potions" class="button"><?php echo $txt['button_potions']; ?></button>
                </div>
            </td>
        </tr>
        </form>

        <?
        #Potions sluiten
        break;
        #Als er op items geklikt word. Het volgende laten zien
        case "items":

        $sql = $db->prepare("SELECT `id`, `naam`, `silver`,`gold`, `omschrijving_en` FROM `markt` WHERE `soort`='items' AND `naam` != 'Bag' AND `naam` != 'Badge case'");
        $sql->execute();
        #Als er op de knop gedrukt word
        if (isset($_POST['items'])) {
            #Gegevens laden van het item
            $itemgegevensSQL = $db->prepare("SELECT `naam`, `silver`,`gold` FROM `markt` WHERE `naam`=:productName");
            $itemgegevensSQL->bindValue(':productName', $_POST['productnaam']);
            $itemgegevensSQL->execute();
            $itemgegevens = $itemgegevensSQL->fetch(PDO::FETCH_ASSOC);
            #Als er niks aangvinkt is.
            if (empty($_POST['productnaam'])) $niksingevoerd = True;
            #heeft speler nog geen pokedex maar wil het wel de chip kopen?
            elseif (($gebruiker['Pokedex'] == 0) AND ($itemgegevens['naam'] == "Pokedex chip")) {
                $welingevoerd = False;
                echo '<div class="blue">' . $txt['alert_pokedex_chip'] . '</div>';
            } elseif (($gebruiker['Pokedex'] == 0) AND ($itemgegevens['naam'] == "Pokedex zzchip")) {
                $welingevoerd = False;
                echo '<div class="blue">' . $txt['alert_pokedex_chip'] . '</div>';
            } elseif ($itemgegevens['naam'] == 'Pokedex zzchip' and $gebruiker['gold'] < $itemgegevens['gold']) {
                $welingevoerd = False;
                echo '<div class="red">' . $txt['alert_not_enough_money'] . '</div>';
            } #Heeft speler niet genoeg silver?
            elseif ($gebruiker['silver'] < $itemgegevens['silver'] and $itemgegevens['naam'] != 'Pokedex zzchip') {
                $welingevoerd = False;
                echo '<div class="red">' . $txt['alert_not_enough_money'] . '</div>';
            } #Alles is goed
            else {
                $welingevoerd = True;
                $type = explode(" ", $itemgegevens['naam']);
                #Kijken als het te kopen type een box is
                if ($type[1] == "box") {
                    $saveItem = $db->prepare("UPDATE `gebruikers_item` SET `itembox`='" . $itemgegevens['naam'] . "' WHERE `user_id`=:uid");
                    $saveItem->bindValue(':uid', $_SESSION['id']);
                    $saveItem->execute();
                    #Het is geen box
                } else {
                    #Is er geen ruimte voor het te kopen item?
                    if ($ruimte['max'] <= $gebruiker['items']) {
                        $welingevoerd = False;
                        $itemboxvol = True;
                    } #Er is wel ruimte en dus opslaan
                    else {
                        $saveItem = $db->prepare("UPDATE `gebruikers_item` SET `" . $itemgegevens['naam'] . "`='1' WHERE `user_id`=:uid");
                        $saveItem->bindValue(':uid', $_SESSION['id']);
                        $saveItem->execute();
                    }
                }
                #Als itembox niet vol is
                if (!$itemboxvol) {
                    #Opslaan
                    if ($itemgegevens['gold'] != 0) {
                        $updateGold = $db->prepare("UPDATE `gebruikers` SET `gold`=`gold`-:gold WHERE `user_id`=:uid");
                        $updateGold->bindValue(':gold', $itemgegevens['gold']);
                        $updateGold->bindValue(':uid', $_SESSION['id']);
                        $updateGold->execute();
                    } else {
                        $updateSilver = $db->prepare("UPDATE `gebruikers` SET `silver`=`silver`-:silver WHERE `user_id`=:uid");
                        $updateSilver->bindValue(':silver', $itemgegevens['silver']);
                        $updateSilver->bindValue(':uid', $_SESSION['id']);
                        $updateSilver->execute();
                    }
                    echo '<div class="green">' . $txt['success_market'] . ' ' . $itemgegevens['naam'] . ' gekocht.</div>';
                }
            }
            #Als wel ingevoerd een waarde heeft/true is
            if (!$welingevoerd) {
                #Als niksingevoerd TRUE is
                if ($niksingevoerd) {
                    echo '<div class="red">' . $txt['alert_nothing_selected'] . '</div>';
                } #Bericht als itembox vol is
                elseif ($itemboxvol) {
                    echo '<div class="red">' . $txt['alert_not_enough_place'] . '</div>';
                }
            }
        }

        $disabled['1'] = 'disabled';
        $disabled['2'] = 'disabled';
        $disabled['3'] = 'disabled';

        #Ruimte vast stellen Per item. Vast stellen welke items nog te koop zijn.
        if (($gebruiker['itembox'] == 'Blue box') OR ($itemgegevens['naam'] == 'Blue box')) {
            $disabled['3'] = '';
        } elseif (($gebruiker['itembox'] == 'Yellow box') OR ($itemgegevens['naam'] == 'Yellow box')) {
            $disabled['2'] = '';
            $disabled['3'] = '';
        } elseif (($gebruiker['itembox'] == 'Bag') OR ($itemgegevens['naam'] == 'Bag')) {
            $disabled['1'] = '';
            $disabled['2'] = '';
            $disabled['3'] = '';
        }
        ?>
        <table width="660" cellpadding="0" cellmargin="0">
            <tr>
                <td width="120" rowspan="54" valign="top"><img src="http://forum.ragezone.com/images/market.gif"/></td>
            </tr>
            <?php #Form starten
            echo '<form method="POST" name="items">
	  		<tr>
				<td>';

            for ($j = 1; $select = $sql->fetch(PDO::FETCH_ASSOC); $j++) {
                if ($select['naam'] == "Pokedex zzchip") {
                    $icon = 'gold';
                    $prijs = number_format(round($select['gold']), 0, ",", ".");
                } else {
                    $icon = 'silver';
                    $prijs = number_format(round($select['silver']), 0, ",", ".");
                }

                #kijken als gebruiker het item al heeft of als het gekochte item gelijk als als de naam die er voor komt.
                if (($gebruiker[$select['naam']] == 1) || (($itemgegevens['naam'] == $select['naam']) AND ($welingevoerd))) #Als speler item al heeft deze disabelen
                    $disabled[$j] = 'disabled';
                echo '<div style="padding:10px; float:left;">
		  <table width="80" class="greyborder">
		  	<tr>
				<td><center><img src="http://forum.ragezone.com/images/items/' . $select['naam'] . '.png" width=24 height=24 /></center></td>
			</tr>
			<tr>
				<td><span class="smalltext"><center>' . $select['naam'] . '</center></span></td>
			</tr>
			<tr>
				<td><span class="smalltext"><center><img src="http://forum.ragezone.com/images/icons/' . $icon . '.png" alt="Silver" title="Silver" style="margin-bottom:-3px;">' . $prijs . '</center></span></td>
			</tr>
			<tr>
				<td><div class="smalltext" style="padding-top:5px;"><center><a href="#" class="tooltip" onMouseover="showhint(\'' . $select['omschrijving_en'] . '\', this)">[?]</a></center></div></td>
			</tr>
			<tr>
				<td><div style="padding-top:5px;"><center><input type="radio" name="productnaam" value="' . $select['naam'] . '" ' . $disabled[$j] . '></center></div></td>
			</tr>
		  </table>
		  </div>';
            }
            echo '</td></tr>';
            ?>
            <tr>
                <td>
                    <div style="padding-left:10px;">
                        <button type="submit" name="items" class="button"><?php echo $txt['button_items']; ?></button>
                    </div>
                </td>
            </tr>
            </form>

            <?
            #items sluiten
            break;
            #Als er op special items geklikt word. Het volgende laten zien
            case "specialitems":
            $sql = $db->prepare("SELECT `id`, `naam`, `silver`, `gold`, `omschrijving_en` FROM `markt` WHERE `soort`='special items' OR `soort`='rare candy'");
            $sql->execute();
            #Als er op de knop gedrukt word
            if (isset($_POST['specialitems'])) {
                $gebruiker_silver = $gebruiker['silver'];
                $gebruiker_gold = $gebruiker['gold'];
                #Laden voor de verwerking van de informatie
                for ($i = 1; $i <= $_POST['teller']; $i++) {
                    #Item id opvragen
                    $itemid = $_POST['id' . $i];
                    #Aantal opvragen van het itemid
                    $aantal = $_POST['aantal' . $itemid];
                    #Als er geen aantal is
                    if (empty($aantal)) $niksingevoerd = True;
                    elseif (!is_numeric($aantal)) $niksingevoerd = True;
                    #Als er wel een aantal is
                    elseif (!empty($aantal)) {
                        #Item gegevens laden
                        $itemgegevensSQL = $db->prepare("SELECT `naam`, `silver`, `gold` FROM `markt` WHERE `id`=:itemId");
                        $itemgegevensSQL->bindValue(':itemId', $itemid);
                        $itemgegevensSQL->execute();
                        $itemgegevens = $itemgegevensSQL->fetch(PDO::FETCH_ASSOC);
                        #silver of gold berekenen voor de balls
                        if ($itemgegevens['naam'] == 'Rare candy') $goldd = $aantal * ($itemgegevens['gold'] / 1);
                        else $silverr = $aantal * ($itemgegevens['silver'] / 1);
                        #itemruimte over berekenen
                        $ruimteover = $ruimte['max'] - $gebruiker['items'];
                        #Kijken als het silver er wel voor is
                        if (($gebruiker_silver < $silverr) OR ($gebruiker_gold < $goldd)) {
                            echo '<div class="red">' . $txt['alert_not_enough_money'] . '</div>';
                        } elseif ($aantal < 0)
                            echo '<div class="red">' . $txt['alert_not_enough_money'] . '</div>';
                        elseif (!ctype_digit($aantal))
                            echo '<div class="red">' . $txt['alert_not_enough_money'] . '</div>';
                        #Kijken als speler nog wel ruimte heeft voor de potions
                        elseif ($ruimteover < $aantal) {
                            if ($aantal > 1) $netheid = "'s";
                            echo '<div class="red">' . $txt['alert_itembox_full_1'] . ' ' . $ruimteover . ' ' . $itemgegevens['naam'] . '' . $netheid . ' ' . $txt['alert_itembox_full_2'] . '</div>';
                        } else {
                            #Opslaan
                            $totalesilver += $silverr;
                            $gebruiker_silver -= $silverr;
                            $totalegold += $goldd;
                            $gebruiker_gold -= $goldd;
                            #mysql_query("UPDATE `gebruikers` SET `silver`=`silver`-'".$silverr."' WHERE `user_id`='".$_SESSION['id']."'");
                            $saveSilver = $db->prepare("UPDATE `gebruikers_item` SET `" . $itemgegevens['naam'] . "`=`" . $itemgegevens['naam'] . "`+:aantal WHERE `user_id`=:uid");
                            $saveSilver->bindValue(':aantal', $aantal);
                            $saveSilver->bindValue(':uid', $_SESSION['id']);
                            $saveSilver->execute();
                            echo '<div class="green">' . $txt['success_market'] . ' ' . $itemgegevens['naam'] . ' ' . $aantal . 'x gekocht.</div>';
                        }
                        $welingevoerd = True;
                    }
                }
                #silver opslaan
                $updateSilver = $db->prepare("UPDATE `gebruikers` SET `silver`=`silver`-:silver, `gold`=`gold`-:gold WHERE `user_id`=:uid");
                $updateSilver->bindValue(':silver', $totalesilver);
                $updateSilver->bindValue(':gold', $totalegold);
                $updateSilver->bindValue(':uid', $_SESSION['id']);
                $updateSilver->execute();

                #Als wel ingevoerd een waarde heeft/true is
                if (!$welingevoerd) {
                    #Als niksingevoerd TRUE is
                    if ($niksingevoerd) {
                        echo '<div class="red">' . $txt['alert_nothing_selected'] . '</div>';
                    }
                }
            }
            ?>
            <table width="660" cellpadding="0" cellmargin="0">
                <tr>
                    <td width="120" rowspan="54" valign="top"><img src="http://forum.ragezone.com/images/market.gif"/></td>
                </tr>

                <?php #Form starten
                echo '<form method="POST" name="specialitems">
	  		<tr>
				<td>';

                for ($j = 1; $select = $sql->fetch(PDO::FETCH_ASSOC); $j++) {
                    if ($select['naam'] == "Rare candy") {
                        $icon = 'gold';
                        $prijs = number_format(round($select['gold']), 0, ",", ".");
                    } else {
                        $icon = 'silver';
                        $prijs = number_format(round($select['silver']), 0, ",", ".");
                    }
                    echo '<div style="padding:10px; float:left;">
		  <table width="80" class="greyborder">
		  	<tr>
				<td><center><input type="hidden" name="teller" value="' . $j . '">
				<input type="hidden" name="id' . $j . '" value="' . $select['id'] . '">
				<img src="http://forum.ragezone.com/images/items/' . $select['naam'] . '.png" width=24 height=24 /></center></td>
			</tr>
			<tr>
				<td><span class="smalltext"><center>' . $select['naam'] . '</center></span></td>
			</tr>
			<tr>
				<td><span class="smalltext"><center><img src="http://forum.ragezone.com/images/icons/' . $icon . '.png" alt="' . $icon . '" title="' . $icon . '" style="margin-bottom:-3px;"> ' . $prijs . '</center></span></td>
			</tr>
			<tr>
				<td><div class="smalltext" style="padding-top:5px;"><center><a href="#" class="tooltip" onMouseover="showhint(\'' . $select['omschrijving_en'] . '\', this)">[?]</a></center></div></td>
			</tr>
			<tr>
				<td><div style="padding-top:5px;"><center><input type="text" maxlength="2" class="text_short" name="aantal' . $select['id'] . '" placeholder="0" style="float:none;" /></center></div></td>
			</tr>
		  </table>
		  </div>';
                }
                echo '</td></tr>';
                ?>
                <tr>
                    <td>
                        <div style="padding-left:10px;">
                            <button type="submit" name="specialitems"
                                    class="button"><?php echo $txt['button_spc_items']; ?></button>
                        </div>
                    </td>
                </tr>
                </form>

                <?
                #items sluiten
                break;
                #Als er op special items geklikt word. Het volgende laten zien
                case "stones":
                $sql = $db->prepare("SELECT `id`, `naam`, `silver`, `omschrijving_en` FROM `markt` WHERE `soort`='stones'");
                $sql->execute();
                #Als er op de knop gedrukt word
                if (isset($_POST['stones'])) {
                    $gebruiker_silver = $gebruiker['silver'];
                    #Laden voor de verwerking van de informatie
                    for ($i = 1; $i <= $_POST['teller']; $i++) {
                        #Item id opvragen
                        $itemid = $_POST['id' . $i];
                        #Aantal opvragen van het itemid
                        $aantal = $_POST['aantal' . $itemid];
                        #Als er geen aantal is
                        if (empty($aantal)) $niksingevoerd = False;
                        elseif (!is_numeric($aantal)) $niksingevoerd = False;
                        #Als er wel een aantal is
                        elseif (!empty($aantal)) {
                            #Item gegevens laden
                            $itemgegevensSQL = $db->prepare("SELECT `naam`, `silver` FROM `markt` WHERE `id`=:itemId");
                            $itemgegevensSQL->bindValue(':itemId', $itemid);
                            $itemgegevensSQL->execute();
                            $itemgegevens = $itemgegevensSQL->fetch(PDO::FETCH_ASSOC);

                            #silver berekenen voor de balls
                            $silverr = $aantal * ($itemgegevens['silver'] / 1);
                            #itemruimte over berekenen
                            $ruimteover = $ruimte['max'] - $gebruiker['items'];
                            #Kijken als het silver er wel voor is
                            if ($gebruiker_silver < $silverr) {
                                echo '<div class="red">' . $txt['alert_not_enough_money'] . '</div>';
                            } elseif ($aantal < 0)
                                echo '<div class="red">' . $txt['alert_not_enough_money'] . '</div>';
                            elseif (!ctype_digit($aantal))
                                echo '<div class="red">' . $txt['alert_not_enough_money'] . '</div>';
                            #Kijken als speler nog wel ruimte heeft voor de potions
                            elseif ($ruimteover < $aantal) {
                                if ($aantal > 1) $netheid = "'s";
                                echo '<div class="red">' . $txt['alert_itembox_full_1'] . ' ' . $ruimteover . ' ' . $itemgegevens['naam'] . '' . $netheid . ' ' . $txt['alert_itembox_full_2'] . '</div>';
                            } else {
                                #Opslaan
                                $totalesilver += $silverr;
                                $gebruiker_silver -= $silverr;
                                #mysql_query("UPDATE `gebruikers` SET `silver`=`silver`-'".$silverr."' WHERE `user_id`='".$_SESSION['id']."'");
                                $updateSilver = $db->prepare("UPDATE `gebruikers_item` SET `" . $itemgegevens['naam'] . "`=`" . $itemgegevens['naam'] . "`+:aantal WHERE `user_id`=:uid");
                                $updateSilver->bindValue(':uid', $_SESSION['id']);
                                $updateSilver->bindValue(':aantal', $aantal);
                                $updateSilver->execute();
                                echo '<div class="green">' . $txt['success_market'] . ' ' . $itemgegevens['naam'] . ' ' . $aantal . 'x gekocht.</div>';

                            }
                            $welingevoerd = True;
                        }
                    }
                    #silver opslaan
                    $saveSilver = $db->prepare("UPDATE `gebruikers` SET `silver`=`silver`-:silver WHERE `user_id`=:uid");
                    $saveSilver->bindValue(':silver', $totalesilver);
                    $saveSilver->bindValue(':uid', $_SESSION['id']);
                    $saveSilver->execute();
                    #Als wel ingevoerd een waarde heeft/true is
                    if (!$welingevoerd) {
                        #Als niksingevoerd TRUE is
                        if ($niksingevoerd) {
                            echo '<div class="red">' . $txt['alert_nothing_selected'] . '</div>';
                        }
                    }
                }
                ?>
                <table width="660" cellpadding="0" cellmargin="0">
                    <tr>
                        <td width="120" rowspan="54" valign="top"><img src="http://forum.ragezone.com/images/market.gif"/></td>
                    </tr>
                    <?php #Form starten
                    echo '<form method="POST" name="stones">
	  		<tr>
				<td>';

                    for ($j = 1; $select = $sql->fetch(PDO::FETCH_ASSOC); $j++) {
                        $prijs = number_format(round($select['silver']), 0, ",", ".");
                        echo '<div style="padding:10px; float:left;">
		  <table width="80" class="greyborder">
		  	<tr>
				<td><center><input type="hidden" name="teller" value="' . $j . '">
				<input type="hidden" name="id' . $j . '" value="' . $select['id'] . '">
				<img src="http://forum.ragezone.com/images/items/' . $select['naam'] . '.png" width=24 height=24 /></center></td>
			</tr>
			<tr>
				<td><span class="smalltext"><center>' . $select['naam'] . '</center></span></td>
			</tr>
			<tr>
				<td><span class="smalltext"><center><img src="http://forum.ragezone.com/images/icons/silver.png" alt="Silver" title="Silver" style="margin-bottom:-3px;"> ' . $prijs . '</center></span></td>
			</tr>
			<tr>
				<td><div class="smalltext" style="padding-top:5px;"><center><a href="#" class="tooltip" onMouseover="showhint(\'' . $select['omschrijving_en'] . '\', this)">[?]</a></center></div></td>
			</tr>
			<tr>
				<td><div style="padding-top:5px;"><center><input type="text" maxlength="2" class="text_short" name="aantal' . $select['id'] . '" placeholder="0" style="float:none;" /></center></div></td>
			</tr>
		  </table>
		  </div>';
                    }
                    echo '</td></tr>';
                    ?>
                    <tr>
                        <td>
                            <div style="padding-left:10px;">
                                <button type="submit" name="stones"
                                        class="button"><?php echo $txt['button_stones']; ?></button>
                            </div>
                        </td>
                    </tr>
                    </form>

                    <?
                    #Special items sluiten
                    break;

                    #Als er op potions geklikt word, het volgende laten zien
                    case "attacks":


                    if (empty($_GET['subpage'])) $subpage = 1;
                    else $subpage = $_GET['subpage'];

                    #Max aantal pokemon per pagina
                    $max = 20;
                    $aantal_attacks = 92;
                    $aantal_paginas = ceil($aantal_attacks / $max);
                    if ($aantal_paginas == 0) $aantal_paginas = 1;
                    $pagina = $subpage * $max - $max;
                    $sql = $db->prepare("SELECT markt.id, markt.naam, silver, markt.omschrijving_en, tmhm.type1 , tmhm.type2
								FROM `markt`
								INNER JOIN tmhm
								ON markt.id = tmhm.id
								WHERE `soort`='tm' 
								LIMIT " . $pagina . ", " . $max);
                    $sql->execute();

                    #Als er op de knop gedrukt word
                    if (isset($_POST['tm'])) {
                        $gebruiker_silver = $gebruiker['silver'];

                        $itemid = $_POST['id' . $i];
                        #Aantal opvragen van het itemid
                        $aantal = $_POST['aantal' . $itemid];

                        echo $aantal;
                        #Laden voor de verwerking van de informatie
                        for ($i = 1; $i <= $_POST['teller']; $i++) {
                            #Item id opvragen
                            $itemid = $_POST['id' . $i];
                            #Aantal opvragen van het itemid
                            $aantal = $_POST['aantal' . $itemid];
                            #Als er geen aantal is
                            if (empty($aantal)) $niksingevoerd = True;
                            elseif (!is_numeric($aantal)) $niksingevoerd = True;
                            #Als er wel een aantal is
                            elseif (!empty($aantal)) {
                                $niksingevoerd = False;
                                #Gegevens laden van de te kopen item
                                $itemSQL = $db->prepare("SELECT `naam`, `silver` FROM `markt` WHERE `id`=:itemId");
                                $itemSQL->bindValue(':itemId', $itemid);
                                $itemSQL->execute();
                                $itemgegevens = $itemSQL->fetch(PDO::FETCH_ASSOC);

                                #Prijs bereken voor het aantal potions.
                                $silverr = $aantal * ($itemgegevens['silver'] / 1);
                                #itemruimte over berekenen
                                $ruimteover = $ruimte['max'] - $gebruiker['items'];
                                #Kijken als er wel genoeg silver is.
                                if ($gebruiker_silver < $silverr) {
                                    echo '<div class="red">' . $txt['alert_not_enough_money'] . '</div>';
                                } elseif ($aantal < 0)
                                    echo '<div class="red">' . $txt['alert_not_enough_money'] . '</div>';
                                elseif (!ctype_digit($aantal))
                                    echo '<div class="red">' . $txt['alert_not_enough_money'] . '</div>';
                                #Kijken als speler nog wel ruimte heeft voor de potions
                                elseif ($ruimteover < $aantal) {
                                    if ($aantal > 1) $netheid = "'s";
                                    echo '<div class="red">' . $txt['alert_itembox_full_1'] . ' ' . $ruimteover . ' ' . $itemgegevens['naam'] . '' . $netheid . ' ' . $txt['alert_itembox_full_2'] . '</div>';
                                } else {
                                    #Opslaan
                                    $totalesilver += $silverr;
                                    $gebruiker_silver -= $silverr;
                                    $updateSilver = $db->prepare("UPDATE `gebruikers_tmhm` SET `" . $itemgegevens['naam'] . "`=`" . $itemgegevens['naam'] . "`+:aantal WHERE `user_id`=:uid");
                                    $updateSilver->bindValue(':aantal', $aantal);
                                    $updateSilver->bindValue(':uid', $_SESSION['id']);
                                    $updateSilver->execute();
                                    echo '<div class="green">' . $txt['success_market'] . ' ' . $itemgegevens['naam'] . ' ' . $aantal . 'x gekocht.</div>';
                                }
                                $welingevoerd = True;
                            }
                        }
                        #silver opslaan
                        $saveSilver = $db->prepare("UPDATE `gebruikers` SET `silver`=`silver`-:silver WHERE `user_id`=:uid");
                        $saveSilver->bindValue(':silver', $totalesilver);
                        $saveSilver->bindValue(':uid', $_SESSION['id']);
                        $saveSilver->execute();

                        #Als wel ingevoerd een waarde heeft/true is
                        if (!$welingevoerd) {
                            #Als niksingevoerd TRUE is
                            if ($niksingevoerd) {
                                echo '<div class="red">' . $txt['alert_nothing_selected'] . '</div>';
                            }
                        }
                    }
                    ?>
                    <table width="660" cellpadding="0" cellmargin="0">
                        <tr>
                            <td width="120" rowspan="54" valign="top"><img src="http://forum.ragezone.com/images/market.gif"/></td>
                        </tr>
                        <?php #Form starten
                        echo '<form method="POST" name="tm">
	  		<tr>
			  <td>';

                        for ($j = 1; $select = $sql->fetch(PDO::FETCH_ASSOC); $j++) {

                            if ($select['type2'] == $select['type1']) $type = $select['type1'];
                            else $type = $select['type1'] . ' en ' . $select['type2'];

                            $prijs = number_format(round($select['silver']), 0, ",", ".");
                            echo '<div style="padding:10px; float:left;">
		  <table width="80" class="greyborder">
		  	<tr>
				<td><center><input type="hidden" name="teller" value="' . $j . '">
				<input type="hidden" name="id' . $j . '" value="' . $select['id'] . '">
				<img src="http://forum.ragezone.com/images/items/Attack_' . $select['type2'] . '.png" alt="' . $select['type1'] . ' type attack" title="' . $select['type1'] . ' type attack" width=24 height=24 /></center></td>
				

				</tr>
			<tr>
				<td><span class="smalltext"><center>' . $select['naam'] . '</center></span></td>
			</tr>
			<tr>
				<td><span class="smalltext"><center><img src="http://forum.ragezone.com/images/icons/silver.png" alt="Silver" title="Silver" style="margin-bottom:-3px;"> ' . $prijs . '</center></span></td>
			</tr>
			<tr>
				<td><div class="smalltext" style="padding-top:5px;"><center><a href="#" class="tooltip" onMouseover="showhint(\'' . $select['omschrijving_en'] . '<br />' . $type . ' ' . $txt['market_attack_types'] . '\', this)">[?]</a></center></div></td>
			</tr>
			<tr>
				<td><div style="padding-top:5px;"><center><input type="text" maxlength="2" class="text_short" name="aantal' . $select['id'] . '" placeholder="0" style="float:none;" /></center></div></td>
			</tr>
		  </table>
		  </div>';
                        }
                        echo '</td></tr>';
                        ?>
                        <tr>
                            <td>
                                <div style="padding-left:10px;">
                                    <button type="submit" name="tm"
                                            class="button"><?php echo $txt['button_attacks']; ?></button>
                                </div>
                            </td>
                        </tr>
                        </form>

                        <?
                        #Pagina systeem
                        $links = false;
                        $rechts = false;
                        echo '<tr><td><center><br /><div class="sabrosus">';
                        if ($subpage == '1') {
                            echo '<span class="disabled"> < </span>';
                        } else {
                            $back = $subpage - 1;
                            echo '<a href="' . $_SERVER['PHP_SELF'] . '?page=' . $_GET['page'] . '&shopitem=' . $_GET['shopitem'] . '&subpage=' . $back . '"> < </a>';
                        }
                        for ($i = 1; $i <= $aantal_paginas; $i++) {

                            if ((2 >= $i) && ($subpage == $i)) {
                                echo '<span class="current"> ' . $i . ' </span>';
                            } elseif ((2 >= $i) && ($subpage != $i)) {
                                echo '<a href="' . $_SERVER['PHP_SELF'] . '?page=' . $_GET['page'] . '&shopitem=' . $_GET['shopitem'] . '&subpage=' . $i . '"> ' . $i . ' </a>';
                            } elseif (($aantal_paginas - 2 < $i) && ($subpage == $i)) {
                                echo '<span class="current"> ' . $i . ' </span>';
                            } elseif (($aantal_paginas - 2 < $i) && ($subpage != $i)) {
                                echo '<a href="' . $_SERVER['PHP_SELF'] . '?page=' . $_GET['page'] . '&shopitem=' . $_GET['shopitem'] . '&subpage=' . $i . '"> ' . $i . ' </a>';
                            } else {
                                $max = $subpage + 3;
                                $min = $subpage - 3;
                                if ($page == $i) {
                                    echo '<span class="current"> ' . $i . ' </span>';
                                } elseif (($min < $i) && ($max > $i)) {
                                    echo '<a href="' . $_SERVER['PHP_SELF'] . '?page=' . $_GET['page'] . '&shopitem=' . $_GET['shopitem'] . '&subpage=' . $i . '"> ' . $i . ' </a>';
                                } else {
                                    if ($i < $subpage) {
                                        if (!$links) {
                                            echo '...';
                                            $links = True;
                                        }
                                    } else {
                                        if (!$rechts) {
                                            echo '...';
                                            $rechts = True;
                                        }
                                    }

                                }
                            }
                        }
                        if ($aantal_paginas == $subpage) {
                            echo '<span class="disabled"> > </span>';
                        } else {
                            $next = $subpage + 1;
                            echo '<a href="' . $_SERVER['PHP_SELF'] . '?page=' . $_GET['page'] . '&shopitem=' . $_GET['shopitem'] . '&subpage=' . $next . '"> > </a>';
                        }
                        echo "</div></center></td></tr>";

                        ?>

                        <?
                        #Attack sluiten
                        break;

                        #Als er op pokemon geklikt word, het volgende laten zien
                        case "pokemon":

                        $sql = $db->prepare("SELECT markt.id, markt.pokemonid, markt.silver, markt.gold, markt.omschrijving_en, pokemon_wild.zeldzaamheid
							FROM markt
							INNER JOIN pokemon_wild
							ON markt.pokemonid = pokemon_wild.wild_id
							WHERE markt.soort='pokemon'
							AND markt.beschikbaar = '1'
							AND pokemon_wild.wereld = :wereld");
                        $sql->bindValue(':wereld', $gebruiker['wereld']);
                        $sql->execute();

                        #Als er op de knop gedrukt word
                        if (isset($_POST['pokemon'])) {
                            #Gegevens laden van het item
                            $itemgegevensSQL = $db->prepare("SELECT `id`, `pokemonid`, `silver`, `gold`, `beschikbaar` FROM `markt` WHERE `id`=:productId");
                            $itemgegevensSQL->bindValue(':productId', $_POST['productid']);
                            $itemgegevensSQL->execute();
                            $itemgegevens = $itemgegevensSQL->fetch(PDO::FETCH_ASSOC);
                            #Als er niks aangvinkt is.
                            if (empty($_POST['productid'])) {
                                echo '<div class="red">' . $txt['alert_nothing_selected'] . '</div>';
                            } #Is het product nog in stock?
                            elseif ($itemgegevens['beschikbaar'] != 1) {
                                echo '<div class="red">' . $txt['alert_not_in_stock'] . '</div>';
                            } #Heeft speler niet genoeg silver?
                            elseif (($gebruiker['silver'] < $itemgegevens['silver']) OR ($gebruiker['gold'] < $itemgegevens['gold'])) {
                                echo '<div class="red">' . $txt['alert_not_enough_money'] . '</div>';
                            } #Heeft speler nog ruimte in hand?
                            elseif ($gebruiker['in_hand'] > 5) {
                                echo '<div class="red">' . $txt['alert_hand_full'] . '</div>';
                            } #Alles is goed
                            else {
                                #tijd van nu fixen
                                $tijd = date('Y-m-d H:i:s');
                                $opzak_nummer = $gebruiker['in_hand'] + 1;
                                #Willekeurige pokemon laden, en daarvan de gegevens

                                $randomPokeData = $db->prepare("SELECT wild_id, naam, groei, attack_base, defence_base, speed_base, `spc.attack_base`, `spc.defence_base`, hp_base, aanval_1, aanval_2, aanval_3, aanval_4 FROM pokemon_wild WHERE wild_id = :pokeId");
                                $randomPokeData->bindValue(':pokeId', $itemgegevens['pokemonid']);
                                $randomPokeData->execute();
                                $query = $randomPokeData->fetch(PDO::FETCH_ASSOC);

                                #De willekeurige pokemon in de pokemon_speler tabel zetten
                                $randomPokemon = $db->prepare("INSERT INTO `pokemon_speler` (`wild_id`, `aanval_1`, `aanval_2`, `aanval_3`, `aanval_4`) SELECT `wild_id`, `aanval_1`, `aanval_2`, `aanval_3`, `aanval_4` FROM `pokemon_wild` WHERE `wild_id`=:wildId");
                                $randomPokemon->bindValue(':wildId', $query['wild_id']);
                                $randomPokemon->execute();
                                #id opvragen van de insert hierboven
                                $pokeid = $db->lastInsertId();

                                #Karakter kiezen
                                $karakterSQL = $db->prepare("SELECT * FROM `karakters` ORDER BY rand() limit 1");
                                $karakterSQL->execute();
                                $karakter = $karakterSQL->fetch(PDO::FETCH_ASSOC);

                                #Expnodig opzoeken en opslaan
                                $experienceSQL = $db->prepare("SELECT `punten` FROM `experience` WHERE `soort`=:groei AND `level`='6'");
                                $experienceSQL->bindValue(':groei', $query['groei']);
                                $experienceSQL->execute();
                                $experience = $experienceSQL->fetch(PDO::FETCH_ASSOC);

                                #Pokemon IV maken en opslaan
                                #Iv willekeurig getal tussen 1,31. Ik neem 2 omdat 1 te weinig is:P
                                $attack_iv = rand(2, 31);
                                $defence_iv = rand(2, 31);
                                $speed_iv = rand(2, 31);
                                $spcattack_iv = rand(2, 31);
                                $spcdefence_iv = rand(2, 31);
                                $hp_iv = rand(2, 31);

                                #Stats berekenen
                                $attackstat = round((((($query['attack_base'] * 2 + $attack_iv) * 5 / 100) + 5) * 1) * $karakter['attack_add']);
                                $defencestat = round((((($query['defence_base'] * 2 + $defence_iv) * 5 / 100) + 5) * 1) * $karakter['defence_add']);
                                $speedstat = round((((($query['speed_base'] * 2 + $speed_iv) * 5 / 100) + 5) * 1) * $karakter['speed_add']);
                                $spcattackstat = round((((($query['spc.attack_base'] * 2 + $spcattack_iv) * 5 / 100) + 5) * 1) * $karakter['spc.attack_add']);


                                $spcdefencestat = round((((($query['spc.defence_base'] * 2 + $spcdefence_iv) * 5 / 100) + 5) * 1) * $karakter['spc.defence_add']);
                                $hpstat = round(((($query['hp_base'] * 2 + $hp_iv) * 5 / 100) + 5) + 10);

                                #Alle gegevens van de pokemon opslaan
                                $updatePokemon = $db->prepare("UPDATE `pokemon_speler` SET `level`='5', `karakter`=:characterName, `expnodig`=:expNodig, `user_id`=:uid, `opzak`='ja', `opzak_nummer`=:opzakNummer, `ei`='1', `ei_tijd`=:tijd, `attack_iv`=:attackIv, `defence_iv`=:defenceIv, `speed_iv`=:speedIv, `spc.attack_iv`=:spcattackIv, `spc.defence_iv`=:spcdefenceIv, `hp_iv`=:hpIv, `attack`=:attackstat, `defence`=:defencestat, `speed`=:speedstat, `spc.attack`=:spcattackstat, `spc.defence`=:spcdefencestat, `levenmax`=:hpstat, `leven`=:hpstat WHERE `id`=:pokeId");
                                $updatePokemon->bindValue(':characterName', $karakter['karakter_naam']);
                                $updatePokemon->bindValue(':expNodig', $experience['punten']);
                                $updatePokemon->bindValue(':uid', $_SESSION['id']);
                                $updatePokemon->bindValue(':opzakNummer', $opzak_nummer);
                                $updatePokemon->bindValue(':tijd', $tijd);
                                $updatePokemon->bindValue(':attackIv', $attack_iv);
                                $updatePokemon->bindValue(':defenceIv', $defence_iv);
                                $updatePokemon->bindValue(':speedIv', $speed_iv);
                                $updatePokemon->bindValue(':spcattackIv', $spcattack_iv);
                                $updatePokemon->bindValue(':spcdefenceIv', $spcdefence_iv);
                                $updatePokemon->bindValue(':hpIv', $hp_iv);
                                $updatePokemon->bindValue(':attackstat', $attackstat);
                                $updatePokemon->bindValue(':defencestat', $defencestat);
                                $updatePokemon->bindValue(':speedstat', $speedstat);
                                $updatePokemon->bindValue(':spcattackstat', $spcattackstat);
                                $updatePokemon->bindValue(':spcdefencestat', $spcdefencestat);
                                $updatePokemon->bindValue(':hpstat', $hpstat);
                                $updatePokemon->bindValue(':pokeId', $pokeid);
                                $updatePokemon->execute();
                                ##################EINDE POKEMON GEVEN

                                $updateMarket = $db->prepare("UPDATE markt SET beschikbaar = '0' WHERE id = :item");
                                $updateMarket->bindValue(':item', $itemgegevens['id']);
                                $updateMarket->execute();

                                $updateUser = $db->prepare("UPDATE gebruikers SET silver = silver-:silver, gold = gold-:gold, aantalpokemon = aantalpokemon+'1' WHERE user_id = :uid");
                                $updateUser->bindValue(':silver', $itemgegevens['silver']);
                                $updateUser->bindValue(':gold', $itemgegevens['gold']);
                                $updateUser->bindValue(':uid', $_SESSION['id']);
                                $updateUser->execute();

                                echo '<div class="green">' . $txt['success_market'] . ' ' . $txt['success_bought_pokemon'] . ' gekocht.</div>';
                            }
                        }
                        ?>
                        <table width="660" cellpadding="0" cellmargin="0">
                            <tr>
                                <td width="120" rowspan="54" valign="top"><img src="http://forum.ragezone.com/images/market.gif"/></td>
                            </tr>
                            <?php if ($sql->rowCount() == 0) {
                                echo '<tr><td><center>' . $txt['out_of_stock_1'] . ' ' . $gebruiker['wereld'] . ' ' . $txt['out_of_stock_2'] . '</div></tr></center>';
                            } else {

                                #Form starten
                                echo '<form method="post">
	  		<tr>
				<td>';
                                for ($j = 1; $select = $sql->fetch(PDO::FETCH_ASSOC); $j++) {
                                    if ($select['gold'] == 0) {
                                        $img = 'silver';
                                        $prijs = number_format(round($select['silver']), 0, ",", ".");
                                    }
                                    if ($select['silver'] == 0) {
                                        $img = 'gold';
                                        $prijs = number_format(round($select['gold']), 0, ",", ".");
                                    }
                                    if ($select['zeldzaamheid'] == 1) $name = $txt['not_rare'];
                                    elseif ($select['zeldzaamheid'] == 2) $name = $txt['middle_rare'];
                                    else $name = $txt['rare'];

                                    echo '<div style="padding:10px; float:left;">
  		  <table width="80" class="greyborder">
  		  	<tr>
  				<td><center><img src="http://forum.ragezone.com/images/icons/egg2.gif" width=16 height=16 /></center></td>
  			</tr>
  			<tr>
  				<td><span class="smalltext"><center>' . $name . '</center></span></td>
  			</tr>
  			<tr>
  				<td><span class="smalltext"><center><img src="http://forum.ragezone.com/images/icons/' . $img . '.png" alt="' . $img . '" title="' . $img . '" style="margin-bottom:-3px;"> ' . $prijs . '</center></span></td>
  			</tr>
  			<tr>
  				<td><div class="smalltext" style="padding-top:5px;"><center><a href="#" class="tooltip" onMouseover="showhint(\'' . $select['omschrijving_en'] . '\', this)">[?]</a></center></div></td>
  			</tr>
  			<tr>
  				<td><div style="padding-top:5px;"><center><input type="radio" name="productid" value="' . $select['id'] . '"></center></div></td>
  			</tr>
  		  </table>
  		  </div>';
                                }
                                echo '</td></tr>';
                                ?>
                                <tr>
                                    <td>
                                        <div style="padding-left:10px;">
                                            <button type="submit" name="pokemon"
                                                    class="button"><?php echo $txt['button_pokemon']; ?></button>
                                        </div>
                                    </td>
                                </tr>
                                </form>
                            <?php }
                            break;
                            }
                            ?>
                        </table>

Events.php
Code:
<?php
#Script laden zodat je nooit pagina buiten de index om kan laden
include("includes/security.php");

$page = 'events';
#Goeie taal erbij laden voor de page
include_once('language/language-pages.php');
?>

<script language="javascript">
    var checked = 0;

    function checkAll() {
        checked = !checked;
        for (i = 0; i < document.gebeurtenis.elements.length; i++)
            document.gebeurtenis.elements[i].checked = checked;
    }
</script>
<form method="post" name="gebeurtenis">
    <?
    #Alle ongelezen gebeurtenisse op gelezen zetten
    if ($event_new > 0) {
        $everythingRead = $db->prepare("UPDATE `gebeurtenis` SET `gelezen`='1' WHERE `ontvanger_id`=:uid");
        $everythingRead->bindValue(':uid', $_SESSION['id'], PDO::PARAM_INT);
        $everythingRead->execute();
    }

    if ($gebruiker['premiumaccount'] > 0) {
        $toegestaan = 50;
    } else {
        $toegestaan = 25;
    }

    #Gebeurtenissen wissen wat niet in de lijst staan
    $hoeveelSQL = $db->prepare("SELECT COUNT(id) AS nu FROM gebeurtenis WHERE ontvanger_id = :uid");
    $hoeveelSQL->bindValue(':uid', $_SESSION['id'], PDO::PARAM_INT);
    $hoeveelSQL->execute();
    $hoeveel = $hoeveelSQL->fetch(PDO::FETCH_ASSOC);

    if ($toegestaan < $hoeveel['nu']) {
        $delete = $hoeveel['nu'] - $toegestaan;
        mysql_query("DELETE FROM gebeurtenis WHERE ontvanger_id=:uid ORDER BY id ASC LIMIT :deleteEvent");
        $deleteEvent = $db->prepare();
        $deleteEvent->bindValue(':uid', $_SESSION['id'], PDO::PARAM_INT);
        $deleteEvent->bindValue(':deleteEvent', $delete);
        $deleteEvent->execute();

    }

    if (isset($_POST['verwijder'])) {
        #teller starten
        $teller = 0;
        #Als er wel een post id is
        if (isset($_POST['eventid'])) {
            foreach ($_POST['eventid'] as $eventid) {
                #Alle ontvangen id's verwijderen
                $deleteEverything = $db->prepare("DELETE FROM `gebeurtenis` WHERE `id`=:eventId AND `ontvanger_id`=:uid");
                $deleteEverything->bindValue(':eventId', $eventid, PDO::PARAM_INT);
                $deleteEverything->bindValue(':uid', $_SESSION['id'], PDO::PARAM_INT);
                $deleteEverything->execute();

                if ($eventid >= 1) $geselecteerd = true;
                $teller++;
            }
        } #Als er geen post id is deze error
        else
            echo '<div class="red">' . $txt['alert_nothing_selected'] . '</div><br/><br/>';

        #Tekst opstellen
        $tekst = $txt['alert_more_events_deleted'];
        if ($teller == 1)
            $tekst = $txt['alert_one_event_deleted'];

        #Als er berichten verwijderd zijn
        if ($geselecteerd) echo '<div class="green">' . $tekst . '</div><br/><br/>';
    }

    echo '<center><table width="660" cellpadding="0" cellspacing="0">
  			<tr>
			  <td width="30" class="top_first_td"><input type="checkbox" onClick="checkAll()"></td>
			  <td width="130" class="top_td">' . $txt['date-time'] . '</td>
			  <td width="500" class="top_td">' . $txt['event'] . '</td>
			</tr>';

    #Gegevens laden
    $event_sql = $db->prepare("SELECT `id`, `datum`, `ontvanger_id`, `bericht`, `gelezen` FROM `gebeurtenis` WHERE `ontvanger_id`=:uid and `type` NOT LIKE 'catch' ORDER BY `id` DESC LIMIT 0 , $toegestaan");
    $event_sql->bindValue(':uid', $_SESSION['id'], PDO::PARAM_INT);
    $event_sql->execute();

    $event_count = $event_sql->columnCount();

    #Lijst opbouwen per bericht gaat vanzelf
    while ($events = $event_sql->fetch(PDO::FETCH_ASSOC)) {
        #Datum mooi fixen
        $datum = explode("-", $events['datum']);
        $tijd = explode(" ", $datum[2]);
        $datum = $tijd[0] . "-" . $datum[1] . "-" . $datum[0] . ", " . $tijd[1];
        $datum_finished = substr_replace($datum, "", -3);

        echo '<tr>
				<td class="normal_first_td"><input type="checkbox" name="eventid[]" value="' . $events['id'] . '"></td>
				<td class="normal_td">' . $datum_finished . '</td>
				<td class="normal_td">' . $events['bericht'] . '</td>
			  </tr>';
    }
    if ($event_count == 0) {
        echo '<tr>
				<td colspan="3" class="normal_first_td">' . $txt['no_events'] . '</td>
			  </tr>';
    }

    ?>
    </tr>
    <tr>
        <td colspan="3">
            <div style="padding-top:15px;">
                <button type="submit" name="verwijder" class="button"><?php echo $txt['button']; ?></button>
            </div>
        </td>
    </tr>
    </table>
</form>
</center>

Notepad.php
Code:
<?PHP

#Script laden zodat je nooit pagina buiten de index om kan laden
include("includes/security.php");

?>
<link href="includes/summernote/bootstrap.css" rel="stylesheet">
<link href="includes/summernote/summernote.css" rel="stylesheet">
<script>
    $(document).ready(function () {
        $('#summernote').summernote({
            theme: 'yeti',
            lang: "<?=GLOBALDEF_EDITORLANGUAGE?>",
            toolbar: [
                ['style', ['style']],
                ['font', ['bold', 'italic', 'underline', 'clear']],
                ['fontname', ['fontname']],
                ['color', ['color']],
                ['para', ['ul', 'ol', 'paragraph']],
                ['height', ['height']],
                ['table', ['table']],
                ['insert', ['link', 'picture', 'video', 'hr']],
                ['view', ['fullscreen']]
            ]
        });
    });
</script>
Als je iets niet wil vergeten kan je het in je notepad zetten.<br/><br/>
<form method="post">

    <?PHP
    $SqlCount = $db->prepare("SELECT id FROM notes WHERE `user_id`=:uid");
    $SqlCount->bindValue(':uid', $_SESSION['id'], PDO::PARAM_INT);
    $SqlCount->execute();

    if (isset($_POST['update'])) {

        $dirty_html_tekst = $_POST['notitie'];
        require_once 'includes/htmlpurifier/library/HTMLPurifier.auto.php';

        $config = HTMLPurifier_Config::createDefault();
        $purifier = new HTMLPurifier($config);
        $tekst = $purifier->purify($dirty_html_tekst);

        if ($tekst == '') {
            echo showAlert('red', 'Je hebt niks ingevuld.');
        } else {

            if ($SqlCount->rowCount() >= 1) {
                // UPDATE
                $updateNotepad = $db->prepare("UPDATE notes SET text=:text, postdate=NOW() WHERE `user_id`=:uid");
                $updateNotepad->bindValue(':text', $tekst);
                $updateNotepad->bindValue(':uid', $_SESSION['id'], PDO::PARAM_INT);
                $updateNotepad->execute();

                echo showAlert('green', 'Kladblok is vernieuwd!');
            } else {
                // INSERT
                $insertNotepad = $db->prepare("INSERT INTO notes(user_id,text,postdate) VALUES(:uid, :text, NOW())");
                $insertNotepad->bindValue(':uid', $_SESSION['id'], PDO::PARAM_INT);
                $insertNotepad->bindValue(':text', $tekst);
                $insertNotepad->execute();

                echo showAlert('green', 'Kladblok is aangemaakt!');
            }
        }
    }

    $qNotes = $db->prepare("SELECT * FROM notes WHERE `user_id`=:uid");
    $qNotes->bindValue(':uid', $_SESSION['id'], PDO::PARAM_INT);
    $qNotes->execute();
    if ($qNotes->rowCount() > 0) {
        $sNotes = $qNotes->fetch(PDO::FETCH_ASSOC);
    } else {
        $sNotes['text'] = '';
    }
    ?>
    <tr>
        <td class=inhoud>
            <textarea name="notitie" id="summernote" class="text_area"><?= $sNotes['text'] ?></textarea><br><br>
            <button type="submit" name="update" class="button">Updaten</button>
        </td>
    </tr>


</form>

Jail.php
Code:
<?php
//include dit script als je de pagina alleen kunt zien als je ingelogd bent.	
include('includes/security.php');

$page = 'jail';
//Goeie taal erbij laden voor de page
include_once('language/language-pages.php');
?>

<center>

    <table width="600" border="0">
        <tr>
            <td>
                <center><?php echo $txt['title_text']; ?><br/></center>
            </td>
        </tr>
    </table>
    <br/>

    <table width="600" border="0" cellpadding="0" cellspacing="0">
        <?php
        #JOUW KLOK dus van session naam
        $tijdgevangenisoverjou = strtotime($gebruiker['gevangenistijdbegin']);
        $tijdgevangenisoverjou = $tijdgevangenisoverjou + $gebruiker['gevangenistijd'];
        $tijdgevangenisnujou = strtotime(date('Y-m-d H:i:s'));
        $tijdgevangenisjou = $tijdgevangenisoverjou - $tijdgevangenisnujou;

        if (isset($_POST['bust'])) {
            $jailBustSQL = $db->prepare("SELECT username, land, gevangenistijd, gevangenistijdbegin FROM `gebruikers` WHERE `user_id`=:uid");
            $jailBustSQL->bindValue(':uid', $_POST['id']);
            $jailBustSQL->execute();
            $jail_bust = $jailBustSQL->fetch(PDO::FETCH_ASSOC);

            $kans = rand(0, 100);
            $jail_tijd_over = strtotime($jail_bust['gevangenistijdbegin']) + $jail_bust['gevangenistijd'];
            $jail_tijd_nu2 = date('Y-m-d H:i:s');
            $jail_tijd_nu = strtotime(date('Y-m-d H:i:s'));
            $jail_tijd_check = $jail_tijd_over - $jail_tijd_nu;
            $jail_tijd = $jail_tijd_check * 2;
            $jail_tijd_mooi = date("i:s", $jail_tijd);

            if ($jail_bust['gevangenistijd'] == 0)
                echo '<div class="blue">' . $txt['alert_already_broke_out'] . '</div>';
            elseif ($jail_tijd_check < 0)
                echo '<div class="blue">' . $txt['alert_already_free'] . '</div>';
            elseif ($kans <= 20) {
                echo '<div class="green">' . $txt['success_bust'] . '</div>';

                $updateJailTime = $db->prepare("UPDATE `gebruikers` SET `gevangenistijd`='0' WHERE `user_id`=:uid");
                $updateJailTime->bindValue(':uid', $_POST['id']);
                $updateJailTime->execute();

                #Event taal pack includen
                $eventlanguage = GetEventLanguage($jail_bust['land']);
                include('language/events/language-events-' . $eventlanguage . '.php');

                #Gebeurtenis Sturen Naar De speler die is uitgebroken
                $event = '<img src="http://forum.ragezone.com/images/icons/blue.png" width="16" height="16" class="imglower"> ' . $gebruiker['username'] . ' ' . $txt['event_bust'];

                #Melding geven aan de uitdager

                $updateEvent = $db->prepare("INSERT INTO gebeurtenis (id, datum, ontvanger_id, bericht, gelezen)
		VALUES (NULL, NOW(), :ontvanger, :message, '0')");
                $updateEvent->bindValue(':ontvanger', $_POST['id']);
                $updateEvent->bindValue(':message', $event);
                $updateEvent->execute();

                #Rank erbij doen
                rankerbij('jail', $txt);
            } else {
                echo '<div class="red">' . $txt['alert_bust_failed_1'] . ' ' . $jail_tijd_mooi . ' ' . $txt['alert_bust_failed_2'] . '</div>';
                $updateJailTime = $db->prepare("UPDATE `gebruikers` SET `gevangenistijdbegin`=:jailTimeNow, `gevangenistijd`=:jailTime WHERE `user_id`=:uid");
                $updateJailTime->bindValue(':jailTimeNow', $jail_tijd_nu2);
                $updateJailTime->bindValue(':jailTime', $jail_tijd);
                $updateJailTime->bindValue(':uid', $_SESSION['id']);
                $updateJailTime->execute();

                $tijdgevangenisjou = $jail_tijd;
            }
            unset($_POST['bust']);
        }

        if (isset($_POST['koop'])) {
            $jailKoopSQL = $db->prepare("SELECT username, land, gevangenistijd, gevangenistijdbegin FROM `gebruikers` WHERE `user_id`=:uid");
            $jailKoopSQL->bindValue(':uid', $_POST['id']);
            $jailKoopSQL->execute();
            $jail_koop = $jailKoopSQL->fetch(PDO::FETCH_ASSOC);

            $jail_tijd_over = strtotime($jail_koop['gevangenistijdbegin']) + $jail_koop['gevangenistijd'];
            $jail_tijd_nu = strtotime(date('Y-m-d H:i:s'));
            $jail_tijd = $jail_tijd_over - $jail_tijd_nu;
            $jail_kosten = $jail_tijd * 4;

            if ($jail_koop['gevangenistijd'] == 0)
                echo '<div class="blue">' . $txt['alert_already_broke_out'] . '</div>';
            elseif ($jail_tijd < 0)
                echo '<div class="blue">' . $txt['alert_already_free'] . '</div>';
            elseif ($jail_kosten < 0)
                echo '<div class="blue">' . $txt['alert_already_free'] . '</div>';
            elseif ($gebruiker['silver'] < $jail_kosten)
                echo '<div class="red">' . $txt['alert_not_enough_silver'] . '</div>';
            else {
                echo '<div class="green">' . $txt['success_bought'] . ' <img src="http://forum.ragezone.com/images/icons/silver.png" title="Silver"> ' . highamount($jail_kosten) . '</div>';

                $updateSilver = $db->prepare("UPDATE `gebruikers` SET `silver`=`silver`-:jailCosts WHERE `user_id`=:uid");
                $updateSilver->bindValue(':jailCosts', $jail_kosten);
                $updateSilver->bindValue(':uid', $_SESSION['id']);
                $updateSilver->execute();

                $updateJailTime = $db->prepare("UPDATE `gebruikers` SET `gevangenistijd`='0' WHERE `user_id`=:uid");
                $updateJailTime->bindValue(':uid', $_POST['id']);
                $updateJailTime->execute();
                #Event taal pack includen
                $eventlanguage = GetEventLanguage($jail_koop['land']);
                include('language/events/language-events-' . $eventlanguage . '.php');

                $event = '<img src="http://forum.ragezone.com/images/icons/blue.png" width="16" height="16" class="imglower"> ' . $gebruiker['username'] . ' ' . $txt['event_bought'] . ' <img src="http://forum.ragezone.com/images/icons/silver.png" title="Silver"> ' . highamount($jail_kosten) . ' silver.';

                #Melding geven aan de uitdager
                $updateEvent = $db->prepare("INSERT INTO gebeurtenis (id, datum, ontvanger_id, bericht, gelezen)
		VALUES (NULL, NOW(), :ontvanger, :message, '0')");
                $updateEvent->bindValue(':ontvanger', $_POST['id']);
                $updateEvent->bindValue(':message', $event);
                $updateEvent->execute();
            }
            unset($_POST['koop']);
        }

        $kijker_injail = 0;
        $injail = 0;
        $jailsql = $db->prepare("SELECT `user_id`, `username`, `wereld`, `land`, `gevangenistijd`, `gevangenistijdbegin`, COUNT(DISTINCT `user_id`) AS \"aantal\" FROM `gebruikers` WHERE `gevangenistijd`!='' AND `gevangenistijd`!='0' AND `wereld`=:wereld GROUP BY `user_id`");
        $jailsql->bindValue(':wereld', $gebruiker['wereld']);
        $jailsql->execute();
        while ($row = $jailsql->fetch(PDO::FETCH_ASSOC)) {
            $tijdgevangenisover = strtotime($row['gevangenistijdbegin']);
            $tijdgevangenisover = $tijdgevangenisover + $row['gevangenistijd'];
            $tijdgevangenisnu = strtotime(date('Y-m-d H:i:s'));
            $tijdgevangenis = $tijdgevangenisover - $tijdgevangenisnu;

            if ($tijdgevangenis > 0) {
                $injail++;
                if ($injail == 1) {
                    echo '<tr>
            <td width="50" class="top_first_td">' . $txt['#'] . '</td>
            <td width="100" class="top_td">' . $txt['username'] . '</td>
            <td width="50" class="top_td">' . $txt['country'] . '</td>
            <td width="120" class="top_td">' . $txt['time'] . '</td>
            <td width="80" class="top_td">' . $txt['cost'] . '</td>
            <td width="100" class="top_td">' . $txt['buy_out'] . '</td>
            <td width="100" class="top_td">' . $txt['bust'] . '</td>	
          </tr>';
                }

                if ($_SESSION['naam'] == $row['username']) {
                    $kijker_injail = 1;

                    echo '<form method="post">
            	<tr>
            		<td class="normal_first_td">' . $injail . '.</td>
            		<td class="normal_td"><a href="index.php?page=profile&player=' . $row['username'] . '">' . $row['username'] . '</a></td>
            		<td class="normal_td"><img src="http://forum.ragezone.com/images/flags/' . $row['land'] . '.png"></td>
            		<td class="normal_td"><span id="minuten' . $injail . '"> </span><span id="seconden' . $injail . '"</span></td>
            		<td class="normal_td"><img src="http://forum.ragezone.com/images/icons/silver.png" title="Silver" style="margin-bottom:-3px;"> <span id="kosten' . $injail . '"></span></td>
            		<td class="normal_td"><input type="submit" name="koop" value="' . $txt['button_buy'] . '" class="button_mini" id="koopuitt[' . $injail . ']"></td>
            		<td class="normal_td"><input type="submit" name="bust" value="' . $txt['button_bust'] . '" class="button_mini" disabled></td>
            		<input type="hidden" name="id" value="' . $row['user_id'] . '">
            	</tr>
          </form>';
                } elseif ($tijdgevangenisjou > 0) {
                    echo '<tr>
            	<td class="normal_first_td">' . $injail . '.</td>
            	<td class="normal_td"><a href="index.php?page=profile&player=' . $row['username'] . '">' . $row['username'] . '</a></td>
            	<td class="normal_td"><img src="http://forum.ragezone.com/images/flags/' . $row['land'] . '.gif"></td>
            	<td class="normal_td"><span id="minuten' . $injail . '"> </span><span id="seconden' . $injail . '"</span></td>
            	<td class="normal_td"><img src="http://forum.ragezone.com/images/icons/silver.png" title="Silver" style="margin-bottom:-3px;"> <span id="kosten' . $injail . '"></span></td>
            	<td class="normal_td">--</td>
            	<td class="normal_td">--</td>
            	<input type="hidden" name="id" value="' . $row['user_id'] . '">
          	</tr>';
                } else {
                    echo '<form method="post">
            	<tr>
            		<td class="normal_first_td">' . $injail . '.</td>
           			<td class="normal_td"><a href="index.php?page=profile&player=' . $row['username'] . '">' . $row['username'] . '</a></td>
            		<td class="normal_td"><img src="http://forum.ragezone.com/images/flags/' . $row['land'] . '.gif"></td>
            		<td class="normal_td"><span id="minuten' . $injail . '"> </span><span id="seconden' . $injail . '"</span></td>
           			<td class="normal_td"><img src="http://forum.ragezone.com/images/icons/silver.png" title="Silver" style="margin-bottom:-3px;"> <span id="kosten' . $injail . '"></span></td>
            		<td class="normal_td"><input type="submit" name="koop" value="' . $txt['button_buy'] . '" class="button_mini" id="koopuitt[' . $injail . ']"></td>
            		<td class="normal_td"><input type="submit" name="bust" value="' . $txt['button_bust'] . '" class="button_mini" id="bustoutt[' . $injail . ']"></td>
            		<input type="hidden" name="id" value="' . $row['user_id'] . '">
            	</tr>
          </form>';
                }

                echo "<script type='text/javascript'>
        var tijd" . $injail . " = " . $tijdgevangenis . ";
        function aftellen" . $injail . "() {
          var time" . $injail . " = tijd" . $injail . ";
          var kosten" . $injail . " = 4*time" . $injail . ";
          var min" . $injail . " = time" . $injail . " / 60;
          var mins" . $injail . " = Math.floor(min" . $injail . ");
          var gehadmin" . $injail . " = mins" . $injail . " * 60;
          var moetnog" . $injail . " = time" . $injail . " - gehadmin" . $injail . ";   

          if(moetnog" . $injail . " < 10) var secs" . $injail . " = '0'+moetnog" . $injail . ";
          else var secs" . $injail . " = moetnog" . $injail . ";      

          tijd" . $injail . " -= 1;
          if(tijd" . $injail . " < 0){
            document.getElementById('minuten" . $injail . "').innerHTML = 'Vrij';
            document.getElementById('seconden" . $injail . "').innerHTML = '';
            document.getElementById('kosten" . $injail . "').innerHTML = '0,00';
            document.getElementById('koopuitt['+" . $injail . "+']').style.display='block';
            document.getElementById('bustoutt['+" . $injail . "+']').style.display='block';
          }          

          else{
            document.getElementById('minuten" . $injail . "').innerHTML = mins{$injail} +' mins and ';
            document.getElementById('seconden" . $injail . "').innerHTML = secs{$injail} + ' secs';
            document.getElementById('kosten" . $injail . "').innerHTML = kosten{$injail}+',00';
          }          

          setTimeout('aftellen{$injail}()', 1000);
        }
		
        setTimeout('aftellen" . $injail . "()', 1000);
        </script>";
            }
        }

        if ($injail == 0) echo '<strong>' . $txt['nobody_injail_1'] . ' ' . $gebruiker['wereld'] . ' ' . $txt['nobody_injail_2'] . '</strong>';
        ?>
    </table>
</center>

items.php -> don't know if i released this before already..
Code:
<?php
#Script laden zodat je nooit pagina buiten de index om kan laden
include("includes/security.php");

$page = 'items';
#Goeie taal erbij laden voor de page
include_once('language/language-pages.php');

#Something is sold

#query
$itemdataSQL = $db->prepare("SELECT gebruikers_item.*, gebruikers_tmhm.*
                         FROM gebruikers_item
                         INNER JOIN gebruikers_tmhm
                         ON gebruikers_item.user_id = gebruikers_tmhm.user_id
                         WHERE gebruikers_item.user_id = :uid");
$itemdataSQL->bindValue(':uid', $_SESSION['id'], PDO::PARAM_INT);
$itemdataSQL->execute();
$itemdata = $itemdataSQL->fetch(PDO::FETCH_ASSOC);


if (isset($_POST['verkoop'])) {
    $selectSQL = $db->prepare("SELECT `naam`, `soort`, `silver`, `gold` FROM `markt` WHERE `naam`=:name");
    $selectSQL->bindValue(':name', $_POST['name'], PDO::PARAM_STR);
    $selectSQL->execute();
    $select = $selectSQL->fetch(PDO::FETCH_ASSOC);

    if ($select['soort'] == "items") $_POST['amount'] = 1;
    if (empty($_POST['amount']))
        $error = '<div class="red">' . $txt['alert_no_amount'] . '</div>';
    elseif ($select['naam'] == "Alte Krone")
        $error = '<div class="red">Dit item kan niet worden verkocht.</div>';
    elseif ($_POST['amount'] == 0)
        $error = '<div class="red">' . $txt['alert_no_amount'] . '</div>';
    elseif (!is_numeric($_POST['amount']))
        $error = '<div class="red">' . $txt['alert_no_amount'] . '</div>';
    elseif ($_POST['amount'] > $itemdata[$select['naam']])
        $error = '<div class="red">' . $txt['alert_too_much_items_selected'] . '</div>';

    else {
        if (($select['naam'] == 'Meisterball') OR ($select['naam'] == 'Rare candy') OR ($select['naam'] == 'Heat') OR ($select['naam'] == 'Fan') OR ($select['naam'] == 'Mow') OR ($select['naam'] == 'Wash') OR ($select['naam'] == 'Frost') OR ($select['naam'] == 'D-Meteorit') OR ($select['naam'] == 'S-Meteorit') OR ($select['naam'] == 'A-Meteorit') OR ($select['naam'] == 'Megastein')) {
            $bedrag_gold = $_POST['amount'] * ($select['gold'] / 2);
            $price = number_format($bedrag_gold, 2, ',', '');
            $show = '<img src="images/icons/gold.png" title="Gold"> ' . $bedrag_gold;
        } else {
            $bedrag = $_POST['amount'] * ($select['silver'] / 2);
            $price = number_format($bedrag, 2, ',', '');
            $show = '<img src="images/icons/silver.png" title="Silver"> ' . $price;
        }

        if ($select['soort'] == "tm") {
          $lessTM = $db->prepare("UPDATE `gebruikers_tmhm` SET `:name`=`:name`-:amount WHERE `user_id`=:uid");
          $lessTM->bindValue(':name', $_POST['name'], PDO::PARAM_STR);
          $lessTM->bindValue(':amount', $_POST['amount'], PDO::PARAM_INT);
          $lessTM->bindValue(':uid', $_SESSION['id'], PDO::PARAM_INT);
          $lessTM->execute();
        } else {
            $lessItem = $db->prepare("UPDATE `gebruikers_item` SET `:name`=`:name`-:amount WHERE `user_id`=:uid");
            $lessItem->bindValue(':amount', $_POST['amount'], PDO::PARAM_INT);
            $lessItem->bindValue(':name', $_POST['name'], PDO::PARAM_STR);
            $lessItem->bindValue(':uid', $_SESSION['id'], PDO::PARAM_INT);
            $lessItem->execute();
        }

        $updateMoney = $db->prepare("UPDATE `gebruikers` SET `silver`=`silver`+:bedrag, `gold`=`gold`+:bedrag_gold WHERE `user_id`=:uid");
        $updateMoney->bindValue(':bedrag', $bedrag);
        $updateMoney->bindValue(':bedrag_gold', $bedrag_gold);
        $updateMoney->bindValue(':uid', $_SESSION['id']);
        $updateMoney->execute();

        $error = '<div class="green">' . $txt['success_items'] . ' ' . $show . '</div>';
        #Load new data
        $itemdataSQL = $db->prepare("SELECT gebruikers_item.*, gebruikers_tmhm.* FROM gebruikers_item INNER JOIN gebruikers_tmhm ON gebruikers_item.user_id = gebruikers_tmhm.user_id WHERE gebruikers_item.user_id = :uid");
        $itemdataSQL->bindValue(':uid', $_SESSION['id'], PDO::PARAM_INT);
        $itemdataSQL->execute();
        $itemdata = $itemdataSQL->fetch(PDO::FETCH_ASSOC);


    }
}
if (isset($_POST['winkel'])) {

    //check if item on stock
    if($itemdata[$_POST['name']]){

        $product = $_POST['name'];

        if((int)$_POST['prijs']){

            $currencyCheck = false;

            if($_POST['currency'] == 1){

                $currencyCheck = 'gold';

            } elseif($_POST['currency'] == 2){

                $currencyCheck = 'silver';

            }

            if($currencyCheck){

                $getProduct = $db->prepare("SELECT `naam`, `soort`, `silver`, `gold` FROM markt WHERE naam = :item");
                $getProduct->bindValue(':item', $_POST['name'], PDO::PARAM_STR);
                $getProduct->execute();
                $getProduct = $getProduct->fetch();

                if($getProduct['soort'] == 'tm' or $getProduct['soort'] == 'hm') {

                    $targetTable = 'gebruikers_tmhm';

                }else {

                    $targetTable = 'gebruikers_item';

                }

                $st = $db->prepare("UPDATE `" . $targetTable . "` SET `" . $getProduct['naam'] . "`=`" . $getProduct['naam'] . "`-'1' WHERE `user_id`=:user_id;
                       INSERT INTO `gebruikers_store` (`user_id` ,`soort` ,`item`,`prijs`,`currency`)
                        VALUES (:user_id, :soort, :item, :prijs, :currency)");
                $st->bindValue(':user_id', $_SESSION['id'], PDO::PARAM_INT);
                $st->bindValue(':soort', $getProduct['soort'], PDO::PARAM_STR);
                $st->bindValue(':item', $getProduct['naam'], PDO::PARAM_STR);
                $st->bindValue(':prijs', $_POST['prijs'], PDO::PARAM_INT);
                $st->bindValue(':currency', $currencyCheck, PDO::PARAM_STR);

                $st->execute();

                echo showAlert("green","Je hebt succesvol ".$getProduct['naam']." in je winkel geplaatst.")."<br/><br/>"; refresh(3,"?page=items");

            } else {

                echo showAlert('red','Geef op of je het item voor gold of silver wil verkopen.').'<br/><br/>';

            }

        } else {

            echo showAlert('red','Geef een prijs op.').'<br/><br/>';

        }

    }

}

#alle gegevens ophalen voor alle opties
$marktsql = $db->prepare("SELECT `id`, `soort`, `naam`, `silver`, `gold`, `omschrijving_nl` FROM markt ORDER BY soort ASC, id ASC");
$marktsql->execute();

if ($gebruiker['itembox'] == 'Red box') $ruimte['max'] = 250;
elseif ($gebruiker['itembox'] == 'Blue box') $ruimte['max'] = 100;
elseif ($gebruiker['itembox'] == 'Yellow box') $ruimte['max'] = 50;
elseif ($gebruiker['itembox'] == 'Green box') $ruimte['max'] = 500;
elseif ($gebruiker['itembox'] == 'Bag') $ruimte['max'] = 20;

?>

<center>
    <?php echo '<img src="images/items/' . $gebruiker['itembox'] . '.png"> ' . $txt['title_text_1'] . ' nog <strong>' . $gebruiker['item_over'] . '</strong> van <strong>' . $ruimte['max'] . '</strong> plaatsen vrij. <img src="images/items/' . $gebruiker['itembox'] . '.png">'; ?></center>
<br/>
<?
if ($error) echo $error;
$balls = 0;
$potions = 0;
$items = 0;
$arceus = 0;
$spcitems = 0;
$stones = 0;
$megastones = 0;
$bag_seen = False;
while ($result = $marktsql->fetch(PDO::FETCH_ASSOC)) {
    #Show Megastons
    if ($result['soort'] == "megastone") {
        if ($itemdata[$result['naam']] > 0) {
            $megastones++;
            if ($megastones == 1) {
                echo '<center>';
                echo '
            <table width="100%" border="0" cellspacing="0" cellpadding="0" class="item-box">
            <tr>
              <td colspan="5" class="item-title" style="text-align:center;text-shadow:1px 1px #000; color:#424242; font-size:18px;" align="center" valign="top"><h3>Megastones</h3></td>
            </tr>
            <tr>
              <td class="top_first_td"> </td>
              <td class="top_td">' . $txt['name'] . '</td>
              <td class="top_td">' . $txt['number'] . '</td>
              <td class="top_td">' . $txt['sellprice'] . '</td>
            </tr>
          ';
            }
            $megaImage = str_replace(" ", "_", $result['naam']);
            echo '
          <form method="post" name="1">
            <tr style="border-top: thin solid #93c7a6;">
              <td class="normal_first_td"><img src="images/megastones/' . strtolower($megaImage) . '.png" alt="' . $result['naam'] . '"style="max-width:24px;max-height:24px;" /></td>
              <td class="normal_td"><a href="?page=viewitem&id=' . $result['id'] . '" style="text-decoration:underline;">' . $result['naam'] . '</a></td>
              <td class="normal_td">' . $itemdata[$result['naam']] . '</td>
              <td class="normal_td">geen</td>
              <input type="hidden" name="name" value="' . $result['naam'] . '">
              <input type="hidden" name="amount" value="1"/>
            </tr>
            <tr>
              <td colspan="5">
              <input type="number" name="prijs" class="text_long" value=""/>
              <select class="text_long" name="currency">
                  <option value="1">Gold</option>
                  <option value="2">Silver</option>
                </select><br/><br/>
              <button type="submit" name="winkel"
                            class="button_mini" style="margin-right: 5px;">Verkoop in winkel</button>
              <a name="use_stone" href="?page=includes/use_stone&name=' . $result['naam'] . '" style="margin-right:5px;" class="button_mini pull-right">' . $txt['button_use'] . '</a>
              </td>
            </tr>
          </form>
        ';
        }
    }
    #Show Pokeballs
    if ($result['soort'] == "balls") {
        if ($itemdata[$result['naam']] > 0) {
            $balls++;
            if ($balls == 1) {
                echo '<center>';
                echo '
            <table width="100%" border="0" cellspacing="0" cellpadding="0" class="item-box">
            <tr>
              <td colspan="5" class="item-title" style="text-align:center;text-shadow:1px 1px #000; color:#424242; font-size:18px;" align="center" valign="top"><h3>' . $txt['balls'] . '</h3></td>
            </tr>
            <tr>
              <td class="top_first_td"> </td>
              <td class="top_td">' . $txt['name'] . '</td>
              <td class="top_td">' . $txt['number'] . '</td>
              <td class="top_td">' . $txt['sellprice'] . '</td>
            </tr>
          ';
            }
            if ($result['naam'] == 'Meisterball') {
                $prijs = $result['gold'] / 2;
                $price = number_format($prijs, 2, ',', '');
                $munt = 'gold';
            } else {
                $prijs = $result['silver'] / 2;
                $price = number_format($prijs, 2, ',', '');
                $munt = 'silver';
            }
            echo '
          <form method="post" name="1">
            <tr style="border-top: thin solid #93c7a6;">
              <td class="normal_first_td"><img src="images/items/' . $result['naam'] . '.png" alt="' . $result['naam'] . '"style="max-width:24px;max-height:24px;" /></td>
              <td class="normal_td"><a href="?page=viewitem&id=' . $result['id'] . '" style="text-decoration:underline;">' . $result['naam'] . '</a></td>
              <td class="normal_td">' . $itemdata[$result['naam']] . '</td>
              <td class="normal_td"><img src="images/icons/' . $munt . '.png" title="' . $munt . '" style="margin-bottom:-3px;" /> ' . $price . '</td>
              <input type="hidden" name="name" value="' . $result['naam'] . '">
              <input type="hidden" name="amount" value="1"/>
            </tr>
            <tr>
              <td colspan="5">
              <input type="number" name="prijs" class="text_long" value=""/>
              <select class="text_long" name="currency">
                  <option value="1">Gold</option>
                  <option value="2">Silver</option>
                </select><br/><br/>
              <button type="submit" name="winkel"
                            class="button_mini" style="margin-right: 5px;">Verkoop in winkel</button>
                            <button type="submit" name="verkoop" class="button_mini pull-right">' . $txt['button_sell'] . '</button></td>
            </tr>
          </form>
        ';
        }
    } #Show Potions
    elseif ($result['soort'] == "potions") {
        if ($itemdata[$result['naam']] > 0) {
            $potions++;
            if ($potions == 1) {
                echo '
            </table>
            <div class="item-footer"></div>
            <br />
            <table width="100%" border="0" cellspacing="0" cellpadding="0" class="item-box">
            <tr>
              <td colspan="6" class="item-title" style="text-align:center;text-shadow:1px 1px #000; color:#424242; font-size:18px;" align="center" valign="top"><h3>' . $txt['potions'] . '</h3></td>
            </tr>
            <tr>
              <td class="top_first_td"> </td>
              <td class="top_td">' . $txt['name'] . '</td>
              <td class="top_td">' . $txt['number'] . '</td>
              <td class="top_td">' . $txt['sellprice'] . '</td>
            </tr>
          ';
            }
            $prijs = $result['silver'] / 2;
            $price = number_format($prijs, 2, ',', '');
            echo '
          <form method="post">
            <tr style="border-top: thin solid #93c7a6;">
              <td class="normal_first_td"><img src="images/items/' . $result['naam'] . '.png" alt="' . $result['naam'] . '" style="max-width:24px;max-height:24px;" /></td>
              <td class="normal_td"><a href="?page=viewitem&id=' . $result['id'] . '" style="text-decoration:underline;">' . $result['naam'] . '</a></td>
              <td class="normal_td">' . $itemdata[$result['naam']] . '</td>
              <td class="normal_td"><img src="images/icons/silver.png" title="Silver" style="margin-bottom:-3px;" /> ' . $price . '</td>
              <input type="hidden" name="wat" value="use_potion">
              <input type="hidden" name="name" value="' . $result['naam'] . '">
              <input type="hidden" name="amount" value="1"/>
              </td>
            </tr>
            <tr>
              <td colspan="5">
              <input type="number" name="prijs" class="text_long" value=""/>
              <select class="text_long" name="currency">
                  <option value="1">Gold</option>
                  <option value="2">Silver</option>
                </select><br/><br/>
              <button type="submit" name="winkel"
                            class="button_mini" style="margin-right: 5px;">Verkoop in winkel</button>
                            <button type="submit" name="verkoop" class="button_mini pull-right">' . $txt['button_sell'] . '</button>
              <a name="use_potion" href="?page=includes/use_potion&name=' . $result['naam'] . '" style="margin-right:5px;" class="button_mini pull-right">' . $txt['button_use'] . '</a>
              </td>
            </tr>
          </form>
        ';
        }
    } #Show Items
    elseif ($result['soort'] == "items") {
        if ($itemdata[$result['naam']] > 0) {
            $items++;
            if ($items == 1) {
                echo '
          </table>
          <div class="item-footer"></div>
          <br />
          <table width="100%" cellspacing="0" cellpadding="0" class="item-box">
            <tr>
              <td colspan="5" class="item-title" style="text-align:center;text-shadow:1px 1px #000; color:#424242; font-size:18px;" align="center" valign="top"><h3>' . $txt['items'] . '</h3></td>
            </tr>
            <tr>
              <td class="top_first_td"> </td>
              <td class="top_td">' . $txt['name'] . '</td>
              <td class="top_td">' . $txt['number'] . '</td>
              <td class="top_td">' . $txt['sellprice'] . '</td>
            </tr>';
            }
            if ($result['naam'] == 'Badge case') {
                echo '
			 <tr>
              <td class="normal_first_td"><img src="images/items/' . $result['naam'] . '.png" alt="' . $result['naam'] . '"/></td>
              <td class="normal_td">' . $result['naam'] . '</td>
              <td class="normal_td">1</td>
              <td class="normal_td"> -- </td>
            </tr>';
            }

            $prijs = $result['silver'] / 2;
            $price = number_format($prijs, 2, ',', '');
            $price = "<img src='images/icons/silver.png' title='Silver'> " . $price;
            if ($result['naam'] != 'Badge case') {
                echo '
          <form method="post">
            <tr style="border-top: thin solid #93c7a6;">
              <td class="normal_first_td"><img src="images/items/' . $result['naam'] . '.png" alt="' . $result['naam'] . '" style="max-width:24px;max-height:24px;" /></td>
              <td class="normal_td"><a href="?page=viewitem&id=' . $result['id'] . '" style="text-decoration:underline;">' . $result['naam'] . '</a></td>
              <td class="normal_td">1</td>
              <td class="normal_td">' . $price . '</td>
              <input type="hidden" name="name" value="' . $result['naam'] . '">
            </tr>
            <tr>
              <td colspan="4">
              <input type="number" name="prijs" class="text_long" value=""/>
              <select class="text_long" name="currency">
                  <option value="1">Gold</option>
                  <option value="2">Silver</option>
                </select><br/><br/>
              <button type="submit" name="winkel"
                            class="button_mini" style="margin-right: 5px;">Verkoop in winkel</button>
                            <button type="submit" name="verkoop" class="button_mini pull-right">' . $txt['button_sell'] . '</button></td>
            </tr>
          </form>
        ';
            }
        }
    } #Show Special Items
    elseif (($result['soort'] == "special items") || ($result['soort'] == "mega") || ($result['soort'] == "krone") || ($result['soort'] == "newyear") || ($result['soort'] == "narceus") || ($result['soort'] == "rare candy")) {
        if ($itemdata[$result['naam']] > 0) {
            $spcitems++;
            if ($spcitems == 1) {
                echo '
            </table>
            <div class="item-footer"></div>
            <br />
            <table width="100%" border="0" cellspacing="0" cellpadding="0" class="item-box">
              <tr>
                <td colspan="6" class="item-title" style="text-align:center;text-shadow:1px 1px #000; color:#424242; font-size:18px;" align="center" valign="top"><h3>' . $txt['spc_items'] . '</h3></td>
              </tr>
              <tr>
                <td class="top_first_td"> </td>
                <td class="top_td">' . $txt['name'] . '</td>
                <td class="top_td">' . $txt['number'] . '</td>
                <td class="top_td">' . $txt['sellprice'] . '</td>
              </tr>';
            }
            if ($result['soort'] == 'rare candy') {
                $prijs = round($result['gold'] / 2);
                $price = number_format($prijs, 2, ',', '');
                $munt = 'gold';
                echo '
            <form method="post">
              <tr style="border-top: thin solid #93c7a6;">
                <td class="normal_first_td"><img src="images/items/' . $result['naam'] . '.png" alt="' . $result['naam'] . '" style="max-width:24px;max-height:24px;" /></td>
                <td class="normal_td"><a href="?page=viewitem&id=' . $result['id'] . '" style="text-decoration:underline;">' . $result['naam'] . '</a></td>
                <td class="normal_td">' . $itemdata[$result['naam']] . '</td>
                <td class="normal_td"><img src="images/icons/' . $munt . '.png" title="' . $munt . '" style="margin-bottom:-3px;" /> ' . $price . '</td>
                <input type="hidden" name="name" value="' . $result['naam'] . '">
                <input type="hidden" name="amount" value="1"/>
              </tr>
              <tr>
                <td colspan="4">
              <input type="number" name="prijs" class="text_long" value=""/>
              <select class="text_long" name="currency">
                  <option value="1">Gold</option>
                  <option value="2">Silver</option>
                </select><br/><br/>
              <button type="submit" name="winkel"
                            class="button_mini" style="margin-right: 5px;">Verkoop in winkel</button>
                            <button type="submit" name="verkoop" class="button_mini pull-right">' . $txt['button_sell'] . '</button>
                <a name="use_rarecandy" href="?page=includes/use_rarecandy&name=' . $result['naam'] . '" style="margin-right:5px;" class="button_mini pull-right">' . $txt['button_use'] . '</a>
                </td>
              </tr>
            </form>';
            } elseif ($result['naam'] == 'Megastein') {
                $prijs = $result['gold'] / 2;
                $price = number_format($prijs, 2, ',', '');
                $munt = 'gold';
                echo '
            <form method="post">
              <tr style="border-top: thin solid #93c7a6;">
                <td class="normal_first_td"><img src="images/items/' . $result['naam'] . '.png" alt="' . $result['naam'] . '" style="max-width:24px;max-height:24px;" /></td>
                <td class="normal_td"><a href="?page=viewitem&id=' . $result['id'] . '" style="text-decoration:underline;">' . $result['naam'] . '</a></td>
                <td class="normal_td">' . $itemdata[$result['naam']] . '</td>
                <td class="normal_td"><img src="images/icons/' . $munt . '.png" title="' . $munt . '" style="margin-bottom:-3px;" /> ' . $price . '</td>
                <input type="hidden" name="name" value="' . $result['naam'] . '">
                <input type="hidden" name="amount" value="1"/>
              </tr>
              <tr>
                <td colspan="4"><button type="submit" name="verkoop" class="button_mini pull-right">' . $txt['button_sell'] . '</button></td>
              </tr>
            </form>';
            } elseif ($result['soort'] == 'narceus') {
                $prijs = $result['silver'] / 2;
                $price = number_format($prijs, 2, ',', '');
                $munt = 'silver';
                echo '
            <form method="post">
              <tr style="border-top: thin solid #93c7a6;">
                <td class="normal_first_td"><img src="images/items/' . $result['naam'] . '.png" alt="' . $result['naam'] . '"style="max-width:24px;max-height:24px;" /></td>
                <td class="normal_td"><a href="?page=viewitem&id=' . $result['id'] . '" style="text-decoration:underline;">' . $result['naam'] . '</a></td>
                <td class="normal_td">' . $itemdata[$result['naam']] . '</td>
                <td class="normal_td"><img src="images/icons/' . $munt . '.png" title="' . $munt . '" style="margin-bottom:-3px;" /> ' . $price . '</td>
                <input type="hidden" name="name" value="' . $result['naam'] . '">
                <input type="hidden" name="amount" value="1"/>
              </tr>
              <tr>
                <td colspan="4">
              <input type="number" name="prijs" class="text_long" value=""/>
              <select class="text_long" name="currency">
                  <option value="1">Gold</option>
                  <option value="2">Silver</option>
                </select><br/><br/>
              <button type="submit" name="winkel"
                            class="button_mini" style="margin-right: 5px;">Verkoop in winkel</button>
                            <button type="submit" name="verkoop" class="button_mini pull-right">' . $txt['button_sell'] . '</button>
                <a name="use_arceus" href="?page=includes/use_arceus&name=' . $result['naam'] . '" style="margin-right:5px;" class="button_mini pull-right">' . $txt['button_use'] . '</a>
                </td>
              </tr>
            </form>';
            } elseif ($result['soort'] == 'krone') {
                $prijs = $result['gold'] / 2;
                $price = number_format($prijs, 2, ',', '');
                $munt = 'gold';
                echo '
            <form method="post">
              <tr style="border-top: thin solid #93c7a6;">
                <td class="normal_first_td"><img src="images/items/' . $result['naam'] . '.png" alt="' . $result['naam'] . '"style="max-width:24px;max-height:24px;" /></td>
                <td class="normal_td"><a href="?page=viewitem&id=' . $result['id'] . '" style="text-decoration:underline;">' . $result['naam'] . '</a></td>
                <td class="normal_td">' . $itemdata[$result['naam']] . '</td>
                <td class="normal_td"><img src="images/icons/' . $munt . '.png" title="' . $munt . '" style="margin-bottom:-3px;" /> ' . $price . '</td>
                <input type="hidden" name="name" value="' . $result['naam'] . '">
                <input type="hidden" name="amount" value="1"/>
              </tr>
              <tr>
                <td colspan="4">
              <input type="number" name="prijs" class="text_long" value=""/>
              <select class="text_long" name="currency">
                  <option value="1">Gold</option>
                  <option value="2">Silver</option>
                </select><br/><br/>
              <button type="submit" name="winkel"
                            class="button_mini" style="margin-right: 5px;">Verkoop in winkel</button>
                            <button type="submit" name="verkoop" class="button_mini pull-right">' . $txt['button_sell'] . '</button>
                <input type="submit" value="Verkoop" style="margin-right:5px;" class="button_mini pull-right"></td>
              </tr>
            </form>';
            } else {
                $prijs = $result['silver'] / 2;
                $price = number_format($prijs, 2, ',', '');
                $munt = 'silver';
                echo '
            <form method="post">
              <tr style="border-top: thin solid #93c7a6;">
                <td class="normal_first_td"><img src="images/items/' . $result['naam'] . '.png" alt="' . $result['naam'] . '" style="max-width:24px;max-height:24px;" /></td>
                <td class="normal_td"><a href="?page=viewitem&id=' . $result['id'] . '" style="text-decoration:underline;">' . $result['naam'] . '</a></td>
                <td class="normal_td">' . $itemdata[$result['naam']] . '</td>
                <td class="normal_td"><img src="images/icons/silver.png" title="Silver" style="margin-bottom:-3px;" /> ' . $price . '</td>
                <input type="hidden" name="name" value="' . $result['naam'] . '">
                <input type="hidden" name="amount" value="1"/>
              </tr>
              <tr>
                <td colspan="4">
              <input type="number" name="prijs" class="text_long" value=""/>
              <select class="text_long" name="currency">
                  <option value="1">Gold</option>
                  <option value="2">Silver</option>
                </select><br/><br/>
              <button type="submit" name="winkel"
                            class="button_mini" style="margin-right: 5px;">Verkoop in winkel</button>
                            <button type="submit" name="verkoop" class="button_mini pull-right">' . $txt['button_sell'] . '</button>
                <a name="use_spcitem" href="?page=includes/use_spcitem&name=' . $result['naam'] . '" style="margin-right:5px;" class="button_mini pull-right">' . $txt['button_use'] . '</a>
                </td>
              </tr>
            </form>';
            }
        }
    } #Show Special Items
    elseif ($result['soort'] == "stones") {
        if ($itemdata[$result['naam']] > 0) {
            $stones++;
            if ($stones == 1) {
                echo '
            </table>
            <div class="item-footer"></div>
            <br />
            <table width="100%" border="0" cellspacing="0" cellpadding="0" class="item-box">
              <tr>
                <td colspan="6" class="item-title" style="text-align:center;text-shadow:1px 1px #000; color:#424242; font-size:18px;" align="center" valign="top"><h3>' . $txt['stones'] . '</h3></td>
              </tr>
              <tr>
                <td class="top_first_td">' . $txt['#'] . '</td>
                <td class="top_td">' . $txt['name'] . '</td>
                <td class="top_td">' . $txt['number'] . '</td>
                <td class="top_td">' . $txt['sellprice'] . '</td>
              </tr>
          ';
            }
            if ($result['naam'] == 'Fan' OR $result['naam'] == 'Mow' OR $result['naam'] == 'Megastein' OR $result['naam'] == 'Heat' OR $result['naam'] == 'Frost' OR $result['naam'] == 'Wash' OR $result['naam'] == 'A-Meteorit' OR $result['naam'] == 'D-Meteorit' OR $result['naam'] == 'S-Meteorit') {
                $prijs = $result['gold'] / 2;
                $price = number_format($prijs, 2, ',', '');
                $munt = 'gold';
                echo '
            <form method="post">
              <tr style="border-top: thin solid #93c7a6;">
                <td class="normal_first_td"><img src="images/items/' . $result['naam'] . '.png" alt="' . $result['naam'] . '" style="max-width:24px;max-height:24px;" /></td>
                <td class="normal_td"><a href="?page=viewitem&id=' . $result['id'] . '" style="text-decoration:underline;">' . $result['naam'] . '</a></td>
                <td class="normal_td">' . $itemdata[$result['naam']] . '</td>
                <td class="normal_td"><img src="images/icons/' . $munt . '.png" title="' . $munt . '" style="margin-bottom:-3px;" /> ' . $price . '</td>
                <input type="hidden" name="name" value="' . $result['naam'] . '">
                <input type="hidden" name="amount" value="1"/>
              </tr>
              <tr>
                <td colspan="4">
              <input type="number" name="prijs" class="text_long" value=""/>
              <select class="text_long" name="currency">
                  <option value="1">Gold</option>
                  <option value="2">Silver</option>
                </select><br/><br/>
              <button type="submit" name="winkel"
                            class="button_mini" style="margin-right: 5px;">Verkoop in winkel</button>
                            <button type="submit" name="verkoop" class="button_mini pull-right">' . $txt['button_sell'] . '</button>
                <a name="use_rarecandy" href="?page=includes/use_rarecandy&name=' . $result['naam'] . '" style="margin-right:5px;" class="button_mini pull-right">' . $txt['button_use'] . '</a>
                </td>
              </tr>
            </form>';
            } else {
                $prijs = $result['silver'] / 2;
                $price = number_format($prijs, 2, ',', '');
                $munt = 'silver';
                echo '
            <form method="post">
              <tr style="border-top: thin solid #93c7a6;">
                <td class="normal_first_td"><img src="images/items/' . $result['naam'] . '.png" alt="' . $result['naam'] . '" style="max-width:24px;max-height:24px;" /></td>
                <td class="normal_td"><a href="?page=viewitem&id=' . $result['id'] . '" style="text-decoration:underline;">' . $result['naam'] . '</a></td>
                <td class="normal_td">' . $itemdata[$result['naam']] . '</td>
                <td class="normal_td"><img src="images/icons/silver.png" title="Silver" style="margin-bottom:-3px;" /> ' . $price . '</td>
                <input type="hidden" name="name" value="' . $result['naam'] . '">
                <input type="hidden" name="amount" value="1"/>
              </tr>
            <tr>
              <td colspan="4">
              <input type="number" name="prijs" class="text_long" value=""/>
              <select class="text_long" name="currency">
                  <option value="1">Gold</option>
                  <option value="2">Silver</option>
                </select><br/><br/>
              <button type="submit" name="winkel"
                            class="button_mini" style="margin-right: 5px;">Verkoop in winkel</button>
                            <button type="submit" name="verkoop" class="button_mini pull-right">' . $txt['button_sell'] . '</button>
              <a name="use_spcitem" href="?page=includes/use_stone&name=' . $result['naam'] . '" style="margin-right:5px;" class="button_mini pull-right">' . $txt['button_use'] . '</a>
              </td>
            </tr>
            </form>';
            }
        }
    } #Show Special Items
    elseif ($result['soort'] == "tm") {

        $inaam = $result['naam'];

        $tmsqlQuery = $db->prepare("SELECT `type2` FROM tmhm WHERE `naam` = :name");
        $tmsqlQuery->bindValue(':name', $inaam, PDO::PARAM_STR);
        $tmsqlQuery->execute();
        $tmsql = $tmsqlQuery->fetch(PDO::FETCH_ASSOC);

        if ($itemdata[$result['naam']] > 0) {
            $tm++;
            if ($tm == 1) {
                echo '
            </table>
            <div class="item-footer"></div>
            <br />
            <table width="100%" border="0" cellspacing="0" cellpadding="0" class="item-box">
              <tr>
                <td colspan="6" class="item-title" style="text-align:center;text-shadow:1px 1px #000; color:#424242; font-size:18px;" align="center" valign="top"><h3>' . $txt['tm'] . '</h3></td>
              </tr>
              <tr>
                <td class="top_first_td">' . $txt['#'] . '</td>
                <td class="top_first_td"><b>' . $txt['name'] . '</b></td>
                <td class="top_td"><b>' . $txt['number'] . '</b></td>
                <td class="top_td"><b>' . $txt['sellprice'] . '</b></td>
              </tr>';
            }
            $prijs = $result['silver'] / 2;
            $price = number_format($prijs, 2, ',', '');
            echo '
          <form method="post">
            <tr style="border-top: thin solid #93c7a6;">
              <td class="normal_first_td"><img src="images/items/Attack_' . $tmsql['type2'] . '.png" alt="' . $result['naam'] . '" style="max-width:24px;max-height:24px;" /></td>
              <td class="normal_td"><a href="?page=viewitem&id=' . $result['id'] . '" style="text-decoration:underline;">' . $inaam . '</a></td>
              <td class="normal_td">' . $itemdata[$result['naam']] . '</td>
              <td class="normal_td"><img src="images/icons/silver.png" title="Silver" style="margin-bottom:-3px;" /> ' . $price . '</td>
              <input type="hidden" name="name" value="' . $inaam . '">
              <input type="hidden" name="amount" value="1"/>
            </tr>
            <tr>
              <td colspan="4">
              <input type="number" name="prijs" class="text_long" value=""/>
              <select class="text_long" name="currency">
                  <option value="1">Gold</option>
                  <option value="2">Silver</option>
                </select><br/><br/>
              <button type="submit" name="winkel"
                            class="button_mini" style="margin-right: 5px;">Verkoop in winkel</button>
                            <button type="submit" name="verkoop" class="button_mini pull-right">' . $txt['button_sell'] . '</button>
              <a name="use_attack" href="?page=includes/use_attack&name=' . $result['naam'] . '" style="margin-right:5px;" class="button_mini pull-right">' . $txt['button_use'] . '</a>
              </td>
            </tr>
          </form>';
        }
    } #Show Special HM
    elseif ($result['soort'] == "hm") {

        $inaam = $result['naam'];

        if ($inaam == 'HM01') $type = 'Grass';
        elseif ($inaam == 'HM02') $type = 'Flying';
        elseif ($inaam == 'HM03' || $inaam == 'HM07' || $inaam == 'HM08') $type = 'Water';
        elseif ($inaam == 'HM04' || $inaam == 'HM06') $type = 'Fighting';
        else $type = 'Electric';


        if ($itemdata[$result['naam']] > 0) {
            $hm++;
            if ($hm == 1) {
                echo '
            </table>
            <div class="item-footer"></div>
            <br />
            <table width="100%" border="0" cellspacing="0" cellpadding="0" class="item-box">
              <tr>
                <td colspan="4" class="item-title" style="text-align:center;text-shadow:1px 1px #000; color:#424242; font-size:18px;" align="center" valign="top"><h3>' . $txt['hm'] . '</h3></td>
              </tr>
              <tr>
                <td class="top_first_td">' . $txt['#'] . '</td>
                <td class="top_td">' . $txt['name'] . '</td>
                <td class="top_td">' . $txt['number'] . '</td>
                <td class="top_td">' . $txt['sellprice'] . '</td>
              </tr>
          ';
            }
            $prijs = $result['silver'] / 2;
            $price = number_format($prijs, 2, ',', '');
            echo '
          <form method="post">
            <tr style="border-top: thin solid #93c7a6;">
              <td class="normal_first_td"><img src="images/items/Attack_' . $type . '.png" alt="' . $result['naam'] . '" style="max-width:24px;max-height:24px;" /></td>
              <td class="normal_td"><a href="?page=viewitem&id=' . $result['id'] . '" style="text-decoration:underline;">' . $inaam . '</a></td>
              <td class="normal_td">1</td>
              <td class="normal_td"> -- </td>
			  <input type="hidden" name="name" value="' . $inaam . '">
              <input type="hidden" name="amount" value="1"/>
            </tr>
             <tr>
              <td colspan="4">
              <input type="number" name="prijs" class="text_long" value=""/>
              <select class="text_long" name="currency">
                  <option value="1">Gold</option>
                  <option value="2">Silver</option>
                </select><br/><br/>
              <button type="submit" name="winkel"
                            class="button_mini" style="margin-right: 5px;">Verkoop in winkel</button>
              <a name="use_attack" href="?page=includes/use_attack&name=' . $result['naam'] . '" style="margin-right:5px;" class="button_mini pull-right">' . $txt['button_use'] . '</a>
              </td>
            </tr>
          </form>';
        }
    }
}
?>
</table>
<div class="item-footer"></div>
</center>



And another post because i can't post anymore in my last one:

search-user.php
Code:
<?php
//Script laden zodat je nooit pagina buiten de index om kan laden
include("includes/security.php");

$page = 'search-user';
//Goeie taal erbij laden voor de page
include_once('language/language-pages.php');
?>

    <form method="post">
        <center>
            <table width="660" border="0">
                <tr>
                    <td>
                        <center><?php echo $txt['title_text']; ?><br/><br/></center>
                    </td>
                </tr>
                <tr>
                    <td>
                        <center>
                            <table width="300" border="0">
                                <tr>
                                    <td><strong><?php echo $txt['username']; ?></strong></td>
                                    <td><input name="username" type="text" value="" class="text_long"/></td>
                                    <td><input name="submit1" type="submit" value="<?php echo $txt['button']; ?>"
                                               class="button_mini"/></td>
                                </tr>
                            </table>
                        </center>
                    </td>
                </tr>
            </table>
        </center>
    </form>
    <br/>

<?
//als er een geen naam in de post zit
if (isset($_GET['player'])) $_POST['username'] = $_GET['player'];

//Pagina nummer opvragen
$subpage = 1;
if (isset($_GET['subpage'])) $subpage = $_GET['subpage'];

//Als er word gezocht op spelernaam
if (isset($_POST['username'])) {
    //Max aantal leden per pagina
    $max = 50;
    $pagina = $subpage * $max - $max;
    //Spelernaam schoonmaken, en er een % teken achterzetten voor het zoek systeem
    $spelernaam = $_POST['username'];
    //Leden tellen
    $query = $db->prepare("SELECT `user_id` FROM gebruikers WHERE account_code='1' AND `username`=:playerName");
    $query->bindValue(':playerName', $spelernaam);
    $query->execute();

    $aantal_leden = $query->rowCount();
    $aantal_paginas = ceil($aantal_leden / $max);
    if ($aantal_paginas == 0) $aantal_paginas = 1;
    //Is er wel een speler naam op gegeven, zo ja dan verder
    echo '
  	<table width="660" cellpadding="0" cellspacing="0">
      <tr>
        <td width="70" class="top_first_td">' . $txt['#'] . '</td>
        <td width="180" class="top_td">' . $txt['username'] . '</td>
        <td width="110" class="top_td">' . $txt['country'] . '</td>
        <td width="180" class="top_td">' . $txt['rank'] . '</td>
        <td width="120" class="top_td">' . $txt['status'] . '</td>
      </tr>';

    //Gegevens laden van het ingetoetste spelernaam
    $dbresSQL = $db->prepare("SELECT user_id, username, wereld, online, rank, land, premiumaccount FROM gebruikers WHERE account_code='1' AND `username`=:playerName ORDER BY username LIMIT " . $pagina . ", " . $max);
    $dbresSQL->bindValue('playerName', $spelernaam);
	$dbresSQL->execute();


  //Lijst opbouwen per lid gaat vanzelf
  for ($j = $pagina + 1; $gegevens = $dbresSQL->fetch(PDO::FETCH_ASSOC); $j++) {
      $strong = '';
      $strongg = '';
      $star = '';
      $plaatje = "images/icons/status_offline.png";
      $online = $txt['offline'];

      //Kijken als je er zelf tussen zit, dan moet het dik gedrukt zijn.
      if ($gegevens['username'] == $_SESSION['naam']) {
          //Strong mee geven, moet zo omdat anders de link niet werkt
          $strong = "<strong>";
          $strongg = "</strong>";
      }

      if ($gegevens['premiumaccount'] > 0)
          $star = '<img src="images/icons/lidbetaald.png" width="16" height="16" border="0" alt="Premiumlid" title="Premiumlid" style="margin-bottom:-3px;">';

      //Tijd voor plaatje
      if (($gegevens['online'] + 300) > time()) {
          $plaatje = "images/icons/status_online.png";
          $online = $txt['online'];
      }

      $rank = rank($gegevens['rank']);

      echo '
      <tr>
        <td class="normal_first_td">' . $j . '.</td>
        <td class="normal_td">' . $strong . '<a href="?page=profile&player=' . $gegevens['username'] . '">' . $gegevens['username'] . $star . '</a>' . $strongg . '</td>
        <td class="normal_td"><img src="images/flags/' . $gegevens['land'] . '.png"></td>
        <td class="normal_td">' . $rank['ranknaam'] . '</td>
        <td class="normal_td"><img src="' . $plaatje . '" width="18" height="15" />' . $online . '</td>
      </tr>';
  }
  echo "<tr><td> </td></tr>";
  
  //Pagina systeem
  $links = false;
  $rechts = false;
  echo '<tr><td colspan=6><center><div class="sabrosus">';
  if ($subpage == 1)
      echo '<span class="disabled"> < </span>';
  else {
      $back = $subpage - 1;
      echo '<a href="' . $_SERVER['PHP_SELF'] . '?page=' . $_GET['page'] . '&subpage=' . $back . '&player=' . $_POST['username'] . '"> < </a>';
  }
  for ($i = 1; $i <= $aantal_paginas; $i++) {
      if ((2 >= $i) && ($subpage == $i))
          echo '<span class="current">' . $i . '</span>';
      elseif ((2 >= $i) && ($subpage != $i))
          echo '<a href="' . $_SERVER['PHP_SELF'] . '?page=' . $_GET['page'] . '&subpage=' . $i . '&player=' . $_POST['username'] . '">' . $i . '</a>';
      elseif (($aantal_paginas - 2 < $i) && ($subpage == $i))
          echo '<span class="current">' . $i . '</span>';
      elseif (($aantal_paginas - 2 < $i) && ($subpage != $i))
          echo '<a href="' . $_SERVER['PHP_SELF'] . '?page=' . $_GET['page'] . '&subpage=' . $i . '&player=' . $_POST['username'] . '">' . $i . '</a>';
      else {
          $max = $subpage + 3;
          $min = $subpage - 3;
          if ($subpage == $i)
              echo '<span class="current">' . $i . '</span>';
          elseif (($min < $i) && ($max > $i))
              echo '<a href="' . $_SERVER['PHP_SELF'] . '?page=' . $_GET['page'] . '&subpage=' . $i . '&player=' . $_POST['username'] . '">' . $i . '</a>';
          else {
              if ($i < $subpage) {
                  if (!$links) {
                      echo '...';
                      $links = True;
                  }
              } else {
                  if (!$rechts) {
                      echo '...';
                      $rechts = True;
                  }
              }
          }
      }
  } 
  if ($aantal_paginas == $subpage)
      echo '<span class="disabled"> > </span>';
  else {
      $next = $subpage + 1;
      echo '<a href="' . $_SERVER['PHP_SELF'] . '?page=' . $_GET['page'] . '&subpage=' . $next . '&player=' . $_POST['username'] . '"> > </a>';
  }
  echo '</div></center></td></tr>
</table>';
}
?>

lvl-choose.php
Code:
<?php
//Script laden zodat je nooit pagina buiten de index om kan laden
include("includes/security.php");

//Vanaf rank 16 page beschikbaar:
if ($gebruiker['rank'] < 18) header('Location: index.php?page=home');
if ($gebruiker['premiumaccount'] < 1) header('Location: index.php?page=home');

$page = 'lvl-choose';
//Goeie taal erbij laden voor de page
include_once('language/language-pages.php');

$check_1;
$check_2;
$check_3;
$check_4;
$check_5;
$lvl_choose = $gebruiker['lvl_choose'];

if ((isset($_POST['submit'])) && (isset($_POST['lvl']))) {
    $updateLevel = $db->prepare("UPDATE `gebruikers` SET `lvl_choose`=:level WHERE `user_id`=:uid");
    $updateLevel->bindValue(':level', $_POST['lvl']);
    $updateLevel->bindValue(':uid', $_SESSION['id']);
    $updateLevel->execute();
    echo '<div class="blue"><img src="images/icons/blue.png"> ' . $txt['success_lvl_choose'] . '</div>';
    $lvl_choose = $_POST['lvl'];
}

if ($lvl_choose === '5-20') $check_1 = "checked";
elseif ($lvl_choose === '20-40') $check_2 = "checked";
elseif ($lvl_choose === '40-60') $check_3 = "checked";
elseif ($lvl_choose === '60-80') $check_4 = "checked";
elseif ($lvl_choose === '80-100') $check_5 = "checked";

?>

<center>
    <div style="padding-bottom:20px;"><?php echo $txt['title_text']; ?></div>
    <form method="post">
        <table width="150">
            <tr>
                <td width="75"><strong>
                        <center><?php echo $txt['#']; ?></center>
                    </strong></td>
                <td width="75"><strong><?php echo $txt['level']; ?></strong></td>
            </tr>
            <tr>
                <td>
                    <center><input type="radio" name="lvl" value="5-20" <? echo $check_1; ?>/></center>
                </td>
                <td><?php echo $txt['5-20']; ?></td>
            </tr>
            <tr>
                <td>
                    <center><input type="radio" name="lvl" value="20-40" <? echo $check_2; ?>/></center>
                </td>
                <td><?php echo $txt['20-40']; ?></td>
            </tr>
            <tr>
                <td>
                    <center><input type="radio" name="lvl" value="40-60" <? echo $check_3; ?>/></center>
                </td>
                <td><?php echo $txt['40-60']; ?></td>
            </tr>
            <tr>
                <td>
                    <center><input type="radio" name="lvl" value="60-80" <? echo $check_4; ?>/></center>
                </td>
                <td><?php echo $txt['60-80']; ?></td>
            </tr>
            <tr>
                <td>
                    <center><input type="radio" name="lvl" value="80-100" <? echo $check_5; ?>/></center>
                </td>
                <td><?php echo $txt['80-100']; ?></td>
            </tr>
            <tr>
                <td colspan="2">
                    <center><input type="submit" name="submit" value="<?php echo $txt['button']; ?>"
                                   class="button_mini"/></center>
                </td>
            </tr>
        </table>
    </form>
</center>


Will be uploading more fixes as soon as i have the time :)!

Enjoy! :8:
 
Initiate Mage
Joined
Jun 1, 2013
Messages
5
Reaction score
0
Hello! Thanks for this :).

I have this problems but I don't know why, can you help me?

darkshifty - [RELEASE] Pokeworld - a major improved Pokémon-SKY spinoff - RaGEZONE Forums




thanks!
 
Initiate Mage
Joined
Feb 3, 2015
Messages
30
Reaction score
11
Hello! Thanks for this :).

I have this problems but I don't know why, can you help me?

darkshifty - [RELEASE] Pokeworld - a major improved Pokémon-SKY spinoff - RaGEZONE Forums




thanks!

Your directories aren't writable or your settings table is incomplete.



How to delete google re-captcha system ? How to register without captcha ?

Thanks.

see: http://forum.ragezone.com/f705/release-pokeworld-major-improved-poka-1137712/index3.html#post8822292
 
Back
Top