Poll

15 Years of Skylanders, Have You Played Any?
View Results

Character Guidebook

    Edit"; else echo "
  • Create
    • "; }*/ ?>
      '; } ?>
    • A
    • B
    • C
    • D
    • E
    • F
    • G
    • H
    • I
    • J
    • K
    • L
    • M
    • N
    • O
    • P
    • Q
    • R
    • S
    • T
    • U
    • V
    • W
    • X
    • Y
    • Z
      • num_rows($db->query("SELECT * FROM `profiles`")); $updated = $db->fetch_assoc($db->query("SELECT MAX(`updated`) AS `updated` FROM `profiles`")); $updated = date("d/m/Y H:i", process_time($updated['updated'])); ?>

    Welcome to the darkSpyro Character Guidebook for the Spyro games. Select a letter from above to search by name, or click on a game below to see all the characters that appeared in it.

    The Guidebook is now complete with characters in the database.

    The last update to the Guidebook was .

    '; echo '

    Top Viewed Profiles

    '; echo '
      '; // JOIN!!! //$ten_query = $db->query("SELECT `name`, `image` FROM `profiles` WHERE `views` > 0 ORDER BY `views` DESC LIMIT 10"); $month_ago = strtotime(date("Y", $now).'-'.(date("n", $now) - 1).'-'. date("j", $now)); $ten_query = $db->query("SELECT profile_id, COUNT(profile_id) AS `visits` FROM `profiles_visit` WHERE `time` > '$month_ago' GROUP BY `profile_id` ORDER BY `visits` DESC LIMIT 10"); //$ten_query = $db->query("SELECT COUNT(T1.profile_id) AS `visits`, T2.* FROM `profiles_visit` T1 INNER JOIN `profiles` T2 ON T1.profile_id = T2.id WHERE `time` > '$month_ago' GROUP BY `profile_id` ORDER BY `visits` DESC LIMIT 10"); while ($tt_row = $db->fetch_assoc($ten_query)) { $ten_row = $db->fetch_assoc($db->query("SELECT * FROM `profiles` WHERE `id` = '{$tt_row['profile_id']}'")); //$ten_row = $tt_row; $q++; echo '' . $ten_row['name'] . ''; } echo '
    '; echo '
'; /* if ($dark_user_id == 1) { echo '
'; $new_query = $db->query("SELECT `name`, `image`, `other`, `species` FROM `profiles` ORDER BY RAND() LIMIT 3"); echo ''; while ($new_row = $db->fetch_assoc($new_query)) { echo ''; $file_jpg = "images/".$new_row['image'].".jpg"; $file_png = "images/".$new_row['image'].".png"; if (file_exists($file_jpg) || file_exists($file_png)) { if (file_exists($file_jpg)) { $file_name = $file_jpg; } else if (file_exists($file_png)) { $file_name = $file_png; } echo ''; } echo ''; echo ''; if ($new_row['other'] != '') { echo ''; $other_text = ''; $max_words = 20; $words = preg_split("/[\s,]+/", $new_row['other']); echo ''; echo ''; } } echo '
'.$new_row['name'].''.$new_row['name'].'
'; if (count($words) < $max_words + 1) { echo $new_row['other']; } else { for ($i = 0; $i < $max_words; $i++) { echo $words[$i].' '; } echo '...'; } echo '
'; echo '
'; } else { */ echo '
'; echo '

Random Profiles

'; echo '
    '; $new_query = $db->query("SELECT `name`, `image` FROM `profiles` ORDER BY RAND() LIMIT 10"); while ($new_row = $db->fetch_assoc($new_query)) { $p++; echo '' . $new_row['name'] . ''; } echo '
'; echo '
'; //} ?>
query("SELECT * FROM `profiles_games` ORDER BY `sorting` ASC"); while ($rows = $db->fetch_assoc($games)) { echo "\n" . ' ' . $rows['title'] . ''; } ?>