Newbie Spellweaver
- Joined
- Feb 3, 2015
- Messages
- 30
- Reaction score
- 11
Thanks man!, i've added your PHP7 code.
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!Nothing appears on the screen. :/
You must be registered to see links
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:You must be registered to see links
<?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>
What PHP version are you running?Nothing appears on the screen. :/
You must be registered to see links
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 charmThis 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
Did you run de updated SQL file?Yes, i read the readme.
First PHP 7.0, now 5.6. Same problem, no page. None of them work. :/
SQL:You must be registered to see links
Errors on:You must be registered to see links
I'm sorry for the work you're taking to help me. :/
ALTER TABLE `nieuws` ADD `titel_en` VARCHAR(255) NOT NULL AFTER `id`;
INSERT INTO `settings` (`setting`, `value`, `globaldef`) VALUES ('editorLanguage', 'en-EN', 1);
-- 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 */;
Thanks! I can login now, but... still dont show pages. :/
The error:You must be registered to see links
The line:You must be registered to see links
This error happens when I click to fight (on the map). After that no page works anymore.
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];
}
<?
#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>
<?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>
<?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>
<?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>
<?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>
<?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>';
}
?>
<?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>
Hello! Thanks for this .
I have this problems but I don't know why, can you help me?
You must be registered to see links
thanks!
How to delete google re-captcha system ? How to register without captcha ?
Thanks.
You must be registered to see links
see: http://forum.ragezone.com/f705/release-pokeworld-major-improved-poka-1137712/index3.html#post8822292