Newbie Spellweaver
- Joined
- Feb 3, 2015
- Messages
- 30
- Reaction score
- 11
Thanks man!, i've added your PHP7 code.
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature currently requires accessing the site using the built-in Safari browser.
Nothing appears on the screen. :/
https://i.imgur.com/VaTp4KN.png
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: https://gyazo.com/e5eaf6e91b67f4756c6773bc5dceabe1
<?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. :/
https://i.imgur.com/VaTp4KN.png
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: https://i.imgur.com/taXeztw.png
Errors on: https://i.imgur.com/XMx88zO.png
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: https://i.imgur.com/6gNCLhV.png
The line: https://i.imgur.com/9prp95T.png
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?
https://puu.sh/xZqlE/a76cc67cee.png
thanks!
How to delete google re-captcha system ? How to register without captcha ?
Thanks.