Raftaar : I have a User/CPU controlled , made with a cron that actualize the cpu-pkms every day.
You had to make a script that fill a table Ej. player-trainer with the player id or name and another script that fill that table whit this player pkms , i make this in my game that is a port of PKM Arena.
Trainer :
PHP Code:
<?php
$who = mysql_query("SELECT * FROM gebruikers WHERE user_id >= '1' ORDER BY user_id ASC");
while($attk = mysql_fetch_assoc($who)){
$prijs = round(($attk['silver'] / 100) * rand(10,30));
mysql_query("INSERT INTO `trainer` (`id`, `naam`, `badge`, `gymnaam`, `wereld`, `gebied`, `rank`, `prijs`) VALUES
('', '".$atk[username]."', '', '','', 'All', '0', '".$prijs."')");
}
?>
Trainer Poke :
PHP Code:
<?php
$who = mysql_query("SELECT * FROM trainer WHERE id >= '109' ORDER BY id ASC");
while($attk = mysql_fetch_assoc($who)){
$user = mysql_query("SELECT * FROM gebruikers WHERE username='".$attk['naam']."' ORDER BY user_id ASC");
while($attk2 = mysql_fetch_assoc($user)){
$digi1 = mysql_fetch_assoc(mysql_query("SELECT * FROM pokemon_speler WHERE user_id='".$attk2['user_id']."' AND `opzak_nummer`='1' ORDER BY user_id ASC"));
$digi2 = mysql_fetch_assoc(mysql_query("SELECT * FROM pokemon_speler WHERE user_id='".$attk2['user_id']."' AND `opzak_nummer`='2' ORDER BY user_id ASC"));
$digi3 = mysql_fetch_assoc(mysql_query("SELECT * FROM pokemon_speler WHERE user_id='".$attk2['user_id']."' AND `opzak_nummer`='3' ORDER BY user_id ASC"));
$digi4 = mysql_fetch_assoc(mysql_query("SELECT * FROM pokemon_speler WHERE user_id='".$attk2['user_id']."' AND `opzak_nummer`='4' ORDER BY user_id ASC"));
$digi5 = mysql_fetch_assoc(mysql_query("SELECT * FROM pokemon_speler WHERE user_id='".$attk2['user_id']."' AND `opzak_nummer`='5' ORDER BY user_id ASC"));
$digi6 = mysql_fetch_assoc(mysql_query("SELECT * FROM pokemon_speler WHERE user_id='".$attk2['user_id']."' AND `opzak_nummer`='6' ORDER BY user_id ASC"));
$digi7 = mysql_fetch_assoc(mysql_query("SELECT * FROM pokemon_wild WHERE evolutie='2' ORDER BY RAND ()"));
$digi8 = mysql_fetch_assoc(mysql_query("SELECT * FROM pokemon_wild WHERE evolutie='2' ORDER BY RAND ()"));
if($digi2['wild_id'] == '') $digi2['wild_id'] = $digi7['wild_id'];
if($digi3['wild_id'] == '') $digi3['wild_id'] = $digi8['wild_id'];
echo '<table><tr><td>'.$attk['id'].'</td><td>'.$attk['naam'].'</td><td>'.$digi1['wild_id'].'</td><td>'.$digi2['wild_id'].'</td><td>'.$digi3['wild_id'].'</td><td>'.$digi4['wild_id'].'</td><td>'.$digi5['wild_id'].'</td><td>'.$digi6['wild_id'].'</td></tr>';
mysql_query("INSERT INTO `trainer_pokemon` (`id`, `trainer_id`, `pokemonwild_id`) VALUES
('', '".$attk['id']."', '".$digi1['wild_id'].",".$digi2['wild_id'].",".$digi3['wild_id'].",".$digi4['wild_id'].",".$digi5['wild_id'].",".$digi6['wild_id']."')");
}}
?>
Is a POC i made this way and work - To fight make a script like to TRAINER.PHP
Originally Posted by Raftaar
