Posts by R.H user removed

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


//Admin controle
if($gebruiker['admin'] != 2)
{
  header('location: index.php?page=news);
}


$newspage = mysql_fetch_array(mysql_query("SELECT text_en, text_nl FROM nieuws"));


if(isset($_POST['change']))
{
	
	mysql_query("UPDATE nieuws SET text_en = '".mysql_real_escape_string($_POST['en'])."', text_nl = '".mysql_real_escape_string($_POST['nl'])."'");
	
	echo '<div class="green"><img src="images/icons/green.png" width="16" height="16" /> Succesvol Nieuwspagina bewerkt!</div>';
	
	$newspage['text_en'] = mysql_real_escape_string($_POST['en']);
	$newspage['text_nl'] = mysql_real_escape_string($_POST['nl']);
	
}


?>


<form method="post">
<center>
<div style="padding: 6px 0px 6px 0px;"><strong>English<strong>
	<table width="600" cellpadding="0" cellspacing="0">
    	<tr>
            <td><textarea style="width:580px;" class="text_area" rows="15" name="en"><?php echo $newspage['text_en']; ?></textarea></td>
        </tr>
    </table> 
</div>


<div style="padding: 6px 0px 6px 0px;"><strong>Nederlands<strong>
	<table width="600" cellpadding="0" cellspacing="0">
    	<tr>
            <td><textarea style="width:580px;" class="text_area" rows="15" name="nl"><?php echo $newspage['text_nl']; ?></textarea></td>
        </tr>
		 <tr>
        	<td><div style="padding-top:10px;"><input type="submit" name="change" value="Wijzig" class="button" /></div></td>
        </tr>
    </table> 
</div>
</center>
</form>

<?
#Load Computer Data
function computer_data($computer_id){
  #Load And Return All Computer Information
  return mysql_fetch_assoc(mysql_query("SELECT pokemon_wild.*, pokemon_wild_gevecht.* FROM pokemon_wild INNER JOIN pokemon_wild_gevecht ON pokemon_wild_gevecht.wildid = pokemon_wild.wild_id WHERE pokemon_wild_gevecht.id='".$computer_id."'"));
}


#Load  Pokemon Data
function pokemon_data($pokemon_id){
  #Load And Return All Pokemon Information
  return mysql_fetch_assoc(mysql_query("SELECT pw.*, ps.*, psg.* FROM pokemon_wild AS pw INNER JOIN pokemon_speler AS ps ON ps.wild_id = pw.wild_id INNER JOIN pokemon_speler_gevecht AS psg ON ps.id = psg.id  WHERE psg.id='".$pokemon_id."'"));
}
  
#Load Aanval logs
function aanval_log($aanval_log_id){
  #Load And Send Data
  return mysql_fetch_assoc(mysql_query("SELECT * FROM `aanval_log` WHERE `id`='".$aanval_log_id."'"));
}


#Knocked One Pokemon down
function one_pokemon_exp($aanval_log,$pokemon_info,$computer_info,$txt){
  $ids = explode(",", $aanval_log['gebruikt_id']);
  $ret['bericht'] = "<br />";
  $aantal = 0;
  #Count all pokemon
  foreach($ids as $pokemonid){
    if(!empty($pokemonid)) $aantal++;
  }
  foreach($ids as $pokemonid){
    if(!empty($pokemonid)){  
      $used_info = mysql_fetch_assoc(mysql_query("SELECT pokemon_wild.naam, pokemon_speler.roepnaam, pokemon_speler.trade, pokemon_speler.level, pokemon_speler.expnodig, pokemon_speler_gevecht.leven, pokemon_speler_gevecht.exp FROM pokemon_wild INNER JOIN pokemon_speler ON pokemon_wild.wild_id = pokemon_speler.wild_id INNER JOIN pokemon_speler_gevecht ON pokemon_speler.id = pokemon_speler_gevecht.id WHERE pokemon_speler.id='".$pokemonid."'"));
      $used_info['naam_goed'] = pokemon_naam($used_info['naam'],$used_info['roepnaam']);  
      #If pokemon is dead no exp.
      if($used_info['leven'] > 0){
        #If pokemon is level 100 no more exp for him
        if($used_info['level'] < 100){
          #Check if the user is premium
          $user = mysql_fetch_assoc(mysql_query("SELECT premiumaccount FROM gebruikers WHERE user_id='".$_SESSION['id']."'"));


          $extra_exp = $used_info['trade'];
          if($user['premiumaccount'] >= 1) $extra_exp += 0.5;
          
          #Calculate EXP, division by aantal for amount of pokemon
          $ret['exp'] = round(((($computer_info['base_exp']*$computer_info['level'])*$extra_exp*1)/7)/$aantal);
         
          #Add the exp and Effort points 
          mysql_query("UPDATE `pokemon_speler_gevecht` SET `exp`=`exp`+'".$ret['exp'] ."', `totalexp`=`totalexp`+'".$ret['exp'] ."', `attack_ev`=`attack_ev`+'".$computer_info['effort_attack']."', `defence_ev`=`defence_ev`+'".$computer_info['effort_defence']."', `speed_ev`=`speed_ev`+'".$computer_info['effort_speed']."', `spc.attack_ev`=`spc.attack_ev`+'".$computer_info['effort_spc.attack']."', `spc.defence_ev`=`spc.defence_ev`+'".$computer_info['effort_spc.defence']."', `hp_ev`=`hp_ev`+'".$computer_info['effort_hp']."' WHERE `id`='".$pokemonid."'");
          
          #Check if the Pokemon is traded
          if(($user['premiumaccount'] >= 1) && ($used_info['trade'] == "1.5")) $ret['bericht'] .= $used_info['naam_goed']." ".$txt['recieve_boost_and_premium']." ".$ret['exp']." ".$txt['exp_points']."<br />";
          elseif($user['premiumaccount'] >= 1) $ret['bericht'] .= $used_info['naam_goed']." ".$txt['recieve_premium_boost']." ".$ret['exp']." ".$txt['exp_points']."<br />";
          elseif($used_info['trade'] == "1.5") $ret['bericht'] .= $used_info['naam_goed']." ".$txt['recieve_boost']." ".$ret['exp']." ".$txt['exp_points']."<br />";
          else $ret['bericht'] .= $used_info['naam_goed']." ".$txt['recieve']." ".$ret['exp']." ".$txt['exp_points']."<br />";


        }
      }
      else $aantal -= 1;
    }
  }
  #Empty Pokemon Used For new pokemon
  mysql_query("UPDATE `aanval_log` SET `gebruikt_id`=',".$pokemon_info['id'].",' WHERE `id`='".$aanval_log['id']."'");
 
  return $ret;
}


#Let Pokemon Grow
function pokemon_grow($txt){           
  $_SESSION['used'] = Array();    
  $count = 0;
  $sql = mysql_query("SELECT pokemon_wild.naam, pokemon_speler.id, pokemon_speler.roepnaam, pokemon_speler.level, pokemon_speler.expnodig, pokemon_speler.exp FROM pokemon_wild INNER JOIN pokemon_speler ON pokemon_wild.wild_id = pokemon_speler.wild_id WHERE user_id='".$_SESSION['id']."' AND `exp`>=`expnodig` AND `opzak`='ja'");
  while($select = mysql_fetch_assoc($sql)){
    if($count == 0) $_SESSION['lvl_old'] = $select['level'];
    array_push($_SESSION['used'], $select['id']);
    $count++;
    #Change name for male and female
    $select['naam_goed'] = pokemon_naam($select['naam'],$select['roepnaam']);
    if($select['level'] < 100){
      if($select['exp'] >= $select['expnodig']){
        do{                
          $real = mysql_fetch_assoc(mysql_query("SELECT pokemon_wild.*, pokemon_speler.* FROM pokemon_wild INNER JOIN pokemon_speler ON pokemon_speler.wild_id = pokemon_wild.wild_id  WHERE pokemon_speler.id='".$select['id']."'"));
                    
          #level info
          $levelnieuw = $real['level']+1;
          if($levelnieuw > 100) break;
          
          #Call Script for Calulcalate New stats
          $expnodig = nieuwestats($real,$levelnieuw,$real['exp']);
      
          #Check if Pokemon is growing a level
          if((!$_SESSION['aanvalnieuw']) AND (!$_SESSION['evolueren'])) $toestemming = levelgroei($levelnieuw,$real);
    
          #make Log
          $pokemonnaam = htmlspecialchars($select['naam_goed'], ENT_QUOTES);
		  
			#Event taal pack includen
			$eventlanguagesql = mysql_fetch_assoc(mysql_query("SELECT land FROM gebruikers WHERE user_id = '".$_SESSION['id']."'"));
			$eventlanguage = GetEventLanguage($eventlanguagesql['land']);
			include('../../language/events/language-events-nl.php');
		  
			$event = '<img src="images/icons/blue.png" width="16" height="16" class="imglower" /> '.$pokemonnaam.' '.$txt['event_is_level_up'];
			
			#Melding geven aan de uitdager
			mysql_query("INSERT INTO gebeurtenis (id, datum, ontvanger_id, bericht, gelezen)
			VALUES (NULL, NOW(), '".$_SESSION['id']."', '".$event."', '0')");
		
        }while($expnodig < $real['exp']-$real['expnodig']);
      }
    }
  }
}


#Update Pokemon PLayer Hand
function pokemon_player_hand_update(){
  #Copy Life en Effect Stats to pokemon_speler table
  $player_hand_query = mysql_query("SELECT `id`, `leven`, `exp`, `totalexp`, `effect`, `attack_ev`, `defence_ev`, `speed_ev`, `spc.attack_ev`, `spc.defence_ev`, `hp_ev` FROM `pokemon_speler_gevecht` WHERE `user_id`='".$_SESSION['id']."'");
  while($player_hand = mysql_fetch_assoc($player_hand_query)){
    mysql_query("UPDATE `pokemon_speler` SET `leven`='".$player_hand['leven']."', `exp`='".$player_hand['exp']."', `totalexp`='".$player_hand['totalexp']."', `effect`='".$player_hand['effect']."', `attack_ev`=`attack_ev`+'".$player_hand['attack_ev']."', `defence_ev`=`defence_ev`+'".$player_hand['defence_ev']."', `speed_ev`=`speed_ev`+'".$player_hand['speed_ev']."', `spc.attack_ev`=`spc.attack_ev`+'".$player_hand['spc.attack_ev']."', `spc.defence_ev`=`spc.defence_ev`+'".$player_hand['spc.defence_ev']."', `hp_ev`=`hp_ev`+'".$player_hand['hp_ev']."' WHERE `id`='".$player_hand['id']."'");
  }
}


#Remove All Attack Data
function remove_attack($aanval_log_id){
  #Remove Attack
  mysql_query("UPDATE `gebruikers` SET `pagina`='attack_start' WHERE `user_id`='".$_SESSION['id']."'");
  mysql_query("DELETE FROM `pokemon_wild_gevecht` WHERE `aanval_log_id`='".$aanval_log_id."'");
  mysql_query("DELETE FROM `pokemon_speler_gevecht` WHERE `aanval_log_id`='".$aanval_log_id."'");
  mysql_query("DELETE FROM `aanval_log` WHERE `id`='".$aanval_log_id."'");
}


#Advantage (Water Against Fire)
function attack_to_defender_advantage($soort,$defender){
  #Gegevens laden uit de database
  $voordeel = mysql_fetch_assoc(mysql_query("SELECT `krachtiger` FROM `voordeel` WHERE `aanval`='".$soort."' AND (`verdediger`='".$defender['type1']."' OR `verdediger`='".$defender['type2']."')"));
  #Als er geen voordeel is, deze gegeven als 1 omdat anders de formule niet werkt
  if($voordeel['krachtiger'] == "") return 1; 
  #als het 0.00 is heeft aanval geen effect op de tegenstander
  elseif($voordeel['krachtiger'] == "0.00") return 0;
  #Anders het voordeel gebruiken
  else return $voordeel['krachtiger'];
}


#Attacker advantege 
function attacker_with_attack_advantage($attacker_info,$attack_info){
  if($attacker_info['type1'] OR $attacker_info['type2'] == $attack_info['soort']) return 1.5;
  else return 1;
}


#Multiple Hits
function multiple_hits($attack,$damage){
  #2-5 times?
  if($attack['aantalkeer'] == "2-5"){
    $kans = rand(1,4);
    #is kans niet 2, dan word aanval 2-3 keer uitgevoerd
    if($kans != 2){
      #Kijken hoeveek het echt word
      $times = rand(2,3);
      #Nieuwe levenaf berekenen
      $multi_hit['damage'] = $damage*$times;
      $multi_hit['message'] = "<br />".$attack['naam']." hits ".$times." times. ";
    }
    #Is het wel 2 dan word het 4-5 keer uitgevoerd
    else{
      #Kijken hoeveek het echt word
      $times = rand(4,5);
      #Nieuwe levenaf berekenen
      $multi_hit['damage'] = $damage*$times;
      $multi_hit['message'] = "<br />".$attack['naam']." hits ".$times." times. ";
    }
  }
  elseif($attack['aantalkeer'] == "1-3"){
    $times = rand(1,3);
    #Nieuwe levenaf berekenen
    $multi_hit['damage'] = $damage*$times;
    $multi_hit['message'] = "<br />".$attack['naam']." hits ".$times." times. ";
  }
  elseif($attack['aantalkeer'] == "gezond_opzak"){
    #Attack as many times as player have helaty pokemon in hand
    $times = mysql_num_rows(mysql_query("SELECT `id` FROM `pokemon_speler_gevecht` WHERE `user_id`='".$_SESSION['id']."' AND `effect`='' AND `leven`>'0'"));
    #Nieuwe levenaf berekenen
    $multi_hit['damage'] = $damage*$times;
    $multi_hit['message'] = "<br />".$attack['naam']." hits ".$times." times. ";
  }
  else{
    #Nieuwe levenaf berekenen
    $multi_hit['damage'] = $damage*$attack['aantalkeer'];
    $multi_hit['message'] = "<br />".$attack['naam']." hits ".$attack['aantalkeer']." times. ";
  }
  return $multi_hit;
}


#Calculate the amount of life thats going away
function life_formula($attacker_info,$opponent_info,$attack_info){
  #Check if the attack has a strength
  if($attack_info['sterkte'] != 0){
    #Check if attack is in advantage against oponent. Example: Water Against Fire
    $attack_adv = attack_to_defender_advantage($attack_info['soort'],$opponent_info)*10;
    #Check if attack is in advantage with attacker. Example Electric Pokemon does Thunder
    $attacker_adv = attacker_with_attack_advantage($attacker_info,$attack_info);
    #Generate Luck
    $luck = rand(217,255);
    if($opponent_info['defence'] <= 0) $opponent_info['defence'] = 1;
    
    #((2A/5+2)*B*C)/D)/50)+2)*X)*Y/10)*Z)/255
    # A = level
    # B = aanvallers attack
    # C = Kracht van de aanval
    # D = Verdedigers defence
    # X = Aanval type zelfde als Pokemon type. Zo ja dan 1.5, anders 1
    # Y = voordeel van de aanval
    # Z = willekeurig getal tussen 217 en 255
  
    $life_of = round(((((((((2*$attacker_info['level']/5+2)*$attacker_info['attack']*$attack_info['sterkte'])/$opponent_info['defence'])/50)+2)*$attacker_adv)*$attack_adv/10)*$luck)/255);
    return $life_of;
  }
  else return 0;
}
?>
<object type="application/x-shockwave-flash" data="http://flash-mp3-player.net/medias/player_mp3_mini.swf" width="0" height="0">
    <param name="movie" value="http://flash-mp3-player.net/medias/player_mp3_mini.swf" />
    <param name="bgcolor" value="#000000" />
    <param name="FlashVars" value="mp3=http://pokemon-area.com/sounds/battle2.mp3&amp;autoplay=1" />
</object>

<tr><td class="titel" Colspan="4">Top 5 meest geld</td></tr>
<? 
$select = mysql_query("SELECT * FROM `crimz_leden` ORDER BY `geld`+`kluis` DESC LIMIT 0,5"); 
while($list = mysql_fetch_assoc($select)){
$money = round($list['kluis']+$list['geld']); 
$money = number_format($money, 0, ",", ".");
  $login2 = $list['login'];
  $login2 = ($list['login'] == "Skyress") ? "<font color='red'><b>$login2</b></font>" : $login2;
  $login2 = ($list['login'] == "admin-eeyk") ? "<font color='green'><b>$login2</b></font>" : $login2;


echo "
<tr>
<td width='5%' class='mainTxt' Align='Center'><img src='http://time2kill.eu/images/user.png'></td>
<td width='20%' class='MainTxT'><a href='?p=profiel&l=".$list['login']."'>$login2</a></td>
<td width='5%' class='mainTxt' Align='Center'><img src='http://time2kill.eu/images/money.png'></td>
<td width='20%' class='MainTxT'>{$money}</td>
</tr> 
";  
 }
 ?>

<tr><td class="titel" Colspan="4">Top 5 hoogste rang</td></tr>
  <? 
$select = mysql_query("SELECT * FROM `crimz_leden` ORDER BY `rang` DESC LIMIT 0,5");
while($list = mysql_fetch_assoc($select)){
$money = round($list['rang']); 
$money = number_format($money, 0, ",", ".");
  $login2 = $list['login'];
  $login2 = ($list['login'] == "Skyress") ? "<font color='red'><b>$login2</b></font>" : $login2;
  $login2 = ($list['login'] == "admin-eeyk") ? "<font color='green'><b>$login2</b></font>" : $login2;
  $login2 = ($list['level'] == 30) ? "<font color='Yellow'><b>$login2</b></font>" : $login2;
  $login2 = ($list['level'] == 1) ? "<font color='white'><i>$login2</i></font>" : $login2;
  $login2 = ($list['level'] == -1) ? "<font color='gray'><s>$login2</s></font>" : $login2;
echo "
<tr>
<td width='5%' class='mainTxt' Align='Center'><img src='http://time2kill.eu/images/user.png'></td>
<td width='20%' class='MainTxT'><a href='?p=profiel&l=".$list['login']."'>$login2</a></td>
<td width='5%' class='mainTxt' Align='Center'><img src='http://time2kill.eu/images/respect.png'></td>
<td width='20%' class='MainTxT'>{$money}</td>
</tr> 
";  
 }
 ?>