http://skystudio-editor.tk/"]Skystudio is a database editor which aims to be compatible with Project Skyfire I started a few months ago. It can fully create or modify Creatures, Game-objects, Quests and basic Loot + much more soon! Finally, the first stable release is out  While you're here, like my Facebook page.
Download: - http://www.mediafire.com/?2tt5rgrcre50as5"]Mediafire - Check the site often for Executable and Data updates!
If you require more details; check the website. Try it out and don't forget to post back Enjoy.
Some screens:
- Login; Yes, It has offline mode !
- Quest
- Editing a vendor; Import can pull vendor data off wowhead!
- Full Creature editor; Auto Mod calculators, Import from wowhead, random stat generator for quick customs. Works like a charm
<?php
/*
Very important! You need to run SQL update!
ALTER TABLE `account` ADD `reset_password` VARCHAR( 50 ) NOT NULL;
*/
/*Config*/
require_once ( 'config.php');
$conn = mysql_connect($host, $user, $pass, $realmd) or die('Connection failed: ' . mysql_error());
$config = array(
'path_to_thisfile' => 'http://www.fantasywow.es/lol/ownage/wow/pass_recovery.php', // Example: http://mysite.com/lol/ownage/wow/
'email_from' => 'webmaster@fantasywow.es', // Who should the email be sent from ?
'email_subject' => 'Recupera tu contraseña!', // Subject of the mail ??
);
function sha_password($user,$pass){
$user = strtoupper($user);
$pass = strtoupper($pass);
return SHA1($user.':'.$pass);
}
function random_string($counts){
$str = "abcdefghijklmnopqrstuvwxyz";//Count 0-25
for($i=0;$i<$counts;$i++){
if ($o == 1){
$output .= rand(0,9);
$o = 0;
}else{
$o++;
$output .= $str[rand(0,25)];
}
}
return $output;
}
$realmd_bc_new_connect = mysql_connect($realmd[db_host],$realmd[db_username],$realmd[db_password]);
$selectdb = mysql_select_db($realmd[db_name],$realmd_bc_new_connect);
if ($_GET[h] && $_GET[h] != '' && $_GET[h] != '0'){
$output_random_pass = random_string(10);
$query = mysql_query("SELECT username FROM `account` WHERE reset_password='$_GET[h]'");
$res = mysql_fetch_array($query);
if (mysql_num_rows($query) == 1){
echo "Hi $res[username], Your password is: $output_random_pass. Please change your password fast as possible.";
$pass_hash = sha_password($res[username],$output_random_pass);
mysql_query("UPDATE `account` SET sha_pass_hash='$pass_hash' WHERE reset_password='$_GET[h]'");
mysql_query("UPDATE `account` SET reset_password='' WHERE username='$res[username]'");
}else{
echo "Error.";
}
}else{
?>
<?php
//this is where user fill in and send by email
if ($_POST[password_takeback]){
$check_security = mysql_query("SELECT id FROM `account` WHERE username='$_POST[username]' AND email='$_POST'");
if (isset($_POST['username']) && isset($_POST['email']) && mysql_num_rows($check_security) == 1){
$rand = random_string(40);
mysql_query("UPDATE `account` SET reset_password='$rand' WHERE username='$_POST[username]'");
$to = $_POST["email"];
$from = "From: $config[email_from]";
$subject = $config[email_subject];
$message= "Hi $_POST[username], you have submitted a password recovery on our site. IF YOU DIDNT SUBMIT A PASSWORD REQUEST JUST DELETE THIS MAIL!. Please follow this link to complete the operation: $config[path_to_thisfile]?h=$rand";
mail($to, $subject, $message, $from); // This work if you have configured your php.ini file to send email, !on linux its default.
echo "An Email has been sent to you, please follow the email to complete the process.";
}else{
echo "Incorrect details, Please be sure that you submitted right Email and Username to your account";
}
}else{
?>
<form action="<?php echo $_SERVER[PHP_SELF]; ?>" method="POST">
Tu Email:
<input type="text" name="email">
Tu Usuario:
<input type="text" name="username">
<input name="password_takeback" type="submit" value="Recuperar Contraseña">
</form>
<?php
}
}// End GET
?>
2c2:
<?php
// MySQL
//Añadir el fondo deseado
echo "<body background='./imagenes/fondo.jpg' text='white'>";
$WoWHostname = ""; // MySQL server address
$WoWUsername = ""; // MySQL username
$WoWPassword = ""; // MySQL password
$CharacterDatabase = ''; // TC characters database
$RealmDatabase = ''; // TC relamd database
$WorldDatabase = ''; // TC world database
$CharacterDatabaseEncoding = 'utf8'; // database character encoding
/*
*/
// DO NOT EDIT BELOW HERE IF YOU DON'T KNOW WHAT IT IS!!!
$WoWconn = mysql_connect($WoWHostname, $WoWUsername, $WoWPassword) or die('Connection failed: ' . mysql_error());
mysql_select_db($CharacterDatabase, $WoWconn) or die('Select DB failed: ' . mysql_error());
$sql = "SELECT * FROM `characters` WHERE `online` = 1 ORDER BY `name`";
$result = mysql_query($sql, $WoWconn) or die('Query failed: ' . mysql_error());
$count = 0;
?>
<?php
// 5º parte
$link = mysql_connect($WoWHostname, $WoWUsername, $WoWPassword);
$db_selected = mysql_select_db($CharacterDatabase, $link);
$sql = "SELECT `arena_team`.`name`, `arena_team`.`arenateamid`, `arena_team_stats`.`arenateamid`, `arena_team_stats`.`rating` FROM $CharacterDatabase.`arena_team`, $CharacterDatabase.`arena_team_stats` WHERE `arena_team_stats`.`arenateamid` = `arena_team`.`arenateamid` AND `arena_team`.`type` = '2' ORDER BY `arena_team_stats`.`rating` DESC LIMIT 30"; //Comando de rankin arenas 2c2 top10
$result = mysql_query($sql);
if (!$result) {
die('Invalid query: ' . mysql_error()); // en caso de error...
}
mysql_close($link); //Cerrar comando de rankin 2c2
$row = mysql_fetch_row($result);
$i=1;
echo "<br><br><br>";
echo "<h2>Rankin 2c2</h2>";
echo "<br>";
echo "<table border=0><tr><td>";
echo "<h4>Nombre del grupo</h4></td><td><h4>Puntos de grupo</h4></td></tr>";
while ($row != NULL) // Si hay algun resultado => proceder / ningun resultado => nada
{
echo "<tr><td>";
echo $row[0];
echo "</td><td>";
echo $row[3];
echo "</td></tr>";
$row = mysql_fetch_row($result);
}
echo "</table>";
// Fin parte 5
// Funciona:
?>
3c3:
<?php
// MySQL
//Añadir el fondo deseado
echo "<body background='./imagenes/fondo.jpg' text='white'>";
$WoWHostname = ""; // MySQL server address
$WoWUsername = ""; // MySQL username
$WoWPassword = ""; // MySQL password
$CharacterDatabase = ''; // TC characters database
$RealmDatabase = ''; // TC relamd database
$WorldDatabase = ''; // TC world database
$CharacterDatabaseEncoding = 'utf8'; // database character encoding
/*
*/
// DO NOT EDIT BELOW HERE IF YOU DON'T KNOW WHAT IT IS!!!
$WoWconn = mysql_connect($WoWHostname, $WoWUsername, $WoWPassword) or die('Connection failed: ' . mysql_error());
mysql_select_db($CharacterDatabase, $WoWconn) or die('Select DB failed: ' . mysql_error());
$sql = "SELECT * FROM `characters` WHERE `online` = 1 ORDER BY `name`";
$result = mysql_query($sql, $WoWconn) or die('Query failed: ' . mysql_error());
$count = 0;
?>
<?php
// 5º parte
$link = mysql_connect($WoWHostname, $WoWUsername, $WoWPassword);
$db_selected = mysql_select_db($CharacterDatabase, $link);
$sql = "SELECT `arena_team`.`name`, `arena_team`.`arenateamid`, `arena_team_stats`.`arenateamid`, `arena_team_stats`.`rating` FROM $CharacterDatabase.`arena_team`, $CharacterDatabase.`arena_team_stats` WHERE `arena_team_stats`.`arenateamid` = `arena_team`.`arenateamid` AND `arena_team`.`type` = '3' ORDER BY `arena_team_stats`.`rating` DESC LIMIT 30"; //Comando de rankin arenas 2c2 top10
$result = mysql_query($sql);
if (!$result) {
die('Invalid query: ' . mysql_error()); // en caso de error...
}
mysql_close($link); //Cerrar comando de rankin 2c2
$row = mysql_fetch_row($result);
$i=1;
echo "<br><br><br>";
echo "<h2>Rankin 3c3</h2>";
echo "<br>";
echo "<table border=0><tr><td>";
echo "<h4>Nombre del grupo</h4></td><td><h4>Puntos de grupo</h4></td></tr>";
while ($row != NULL) // Si hay algun resultado => proceder / ningun resultado => nada
{
echo "<tr><td>";
echo $row[0];
echo "</td><td>";
echo $row[3];
echo "</td></tr>";
$row = mysql_fetch_row($result);
}
echo "</table>";
// Fin parte 5
// Funciona:
?>
5c5:
<?php
// MySQL
//Añadir el fondo deseado
echo "<body background='./imagenes/fondo.jpg' text='white'>";
$WoWHostname = ""; // MySQL server address
$WoWUsername = ""; // MySQL username
$WoWPassword = ""; // MySQL password
$CharacterDatabase = ''; // TC characters database
$RealmDatabase = ''; // TC relamd database
$WorldDatabase = ''; // TC world database
$CharacterDatabaseEncoding = 'utf8'; // database character encoding
/*
*/
// DO NOT EDIT BELOW HERE IF YOU DON'T KNOW WHAT IT IS!!!
$WoWconn = mysql_connect($WoWHostname, $WoWUsername, $WoWPassword) or die('Connection failed: ' . mysql_error());
mysql_select_db($CharacterDatabase, $WoWconn) or die('Select DB failed: ' . mysql_error());
$sql = "SELECT * FROM `characters` WHERE `online` = 1 ORDER BY `name`";
$result = mysql_query($sql, $WoWconn) or die('Query failed: ' . mysql_error());
$count = 0;
?>
<?php
// 5º parte
$link = mysql_connect($WoWHostname, $WoWUsername, $WoWPassword);
$db_selected = mysql_select_db($CharacterDatabase, $link);
$sql = "SELECT `arena_team`.`name`, `arena_team`.`arenateamid`, `arena_team_stats`.`arenateamid`, `arena_team_stats`.`rating` FROM $CharacterDatabase.`arena_team`, $CharacterDatabase.`arena_team_stats` WHERE `arena_team_stats`.`arenateamid` = `arena_team`.`arenateamid` AND `arena_team`.`type` = '5' ORDER BY `arena_team_stats`.`rating` DESC LIMIT 30"; //Comando de rankin arenas 2c2 top10
$result = mysql_query($sql);
if (!$result) {
die('Invalid query: ' . mysql_error()); // en caso de error...
}
mysql_close($link); //Cerrar comando de rankin 2c2
$row = mysql_fetch_row($result);
$i=1;
echo "<br><br><br>";
echo "<h2>Rankin 5c5</h2>";
echo "<br>";
echo "<table border=0><tr><td>";
echo "<h4>Nombre del grupo</h4></td><td><h4>Puntos de grupo</h4></td></tr>";
while ($row != NULL) // Si hay algun resultado => proceder / ningun resultado => nada
{
echo "<tr><td>";
echo $row[0];
echo "</td><td>";
echo $row[3];
echo "</td></tr>";
$row = mysql_fetch_row($result);
}
echo "</table>";
// Fin parte 5
// Funciona:
?>