Hi all!
I noticed that you can not use the name of a (ingame) deleted character again. So I made a script to delete characters online.
deletechar.php
deletechar2.phpPHP Code:<?php
session_start();
unset($_SESSION['ContinueOK']);
unset($_SESSION['Username']);
//This script was created by Diumelia for ragezone forums.
ini_set('display_errors', 0);
$connection = mssql_connect('YOURHOST', 'sa', 'YOURPASSWORD'); // <<== Change YOURHOST and YOURPASSWORD
if(!connection || !mssql_select_db('ACCOUNT_DBF', $connection))
{
die('Unable to connect or select database!');
}
$checkusername = $_POST['Username'];
$query = mssql_query("SELECT account FROM ACCOUNT_TBL WHERE account = '$checkusername'");
$result = mssql_fetch_row($query);
$query2 = mssql_query("SELECT password FROM ACCOUNT_TBL WHERE account = '$checkusername'");
$resultpass = mssql_fetch_row($query2);
$password = $_POST['Password'];
$checkpassword = md5('nForceIsGay' . $password);
if(isset($_POST['submit'])){
if($_POST['Username'] == ""){
$error = '<font color="red">Please enter a username.</font>';
}
else if($_POST['Username'] != $result[0]){
$error = '<font color="red">This username doesn\'t exist</font>';
}
else if($_POST['Password'] == ""){
$error = '<font color="red">Please enter a password.</font>';
}
else if($checkpassword != $resultpass[0]){
$error = '<font color="red">Please enter the correct password.</font>';
}
else{
$_SESSION['Username'] = $checkusername;
$_SESSION['ContinueOK'] = "True";
header("Location: deletechar2.php");
}
}
echo '<form action="deletechar.php" method="post">';
echo 'Username: <input type="text" name="Username" /><br /><br />';
echo 'Password: <input type="password" name="Password" /><br /><br />';
echo '<input type="submit" name="submit" value="Continue" />';
echo '</form>';
echo $error;
?>
Instructions:PHP Code:<?php
session_start();
//ini_set('display_errors', 0);
$connection = mssql_connect('YOURHOST', 'sa', 'YOURPASSWORD'); // <<== Change YOURHOST and YOURPASSWORD
if(!connection || !mssql_select_db('CHARACTER_01_DBF', $connection))
{
die('Unable to connect or select database!');
}
$Username = $_SESSION['Username'];
$query1 = mssql_query("SELECT m_szName FROM CHARACTER_TBL WHERE account = '$Username' AND playerslot = '0'");
$result1 = mssql_fetch_array($query1);
$query2 = mssql_query("SELECT m_szName FROM CHARACTER_TBL WHERE account = '$Username' AND playerslot = '1'");
$result2 = mssql_fetch_array($query2);
$query3 = mssql_query("SELECT m_szName FROM CHARACTER_TBL WHERE account = '$Username' AND playerslot = '2'");
$result3 = mssql_fetch_array($query3);
if($_SESSION['ContinueOK'] == "True"){
if(isset($_POST['submit'])){
if($_POST['checkbox1'] == "checked"){
mssql_query("DELETE FROM CHARACTER_TBL WHERE m_szName = '$result1[0]'");
$error1 = '<font color="green">' . $result1[0] . ' was succesfully removed.</font><br />';
}
if($_POST['checkbox2'] == "checked"){
mssql_query("DELETE FROM CHARACTER_TBL WHERE m_szName = '$result2[0]'");
$error2 = '<font color="green">' . $result2[0] . ' was succesfully removed.</font><br />';
}
if($_POST['checkbox3'] == "checked"){
mssql_query("DELETE FROM CHARACTER_TBL WHERE m_szName = '$result3[0]'");
$error3 = '<font color="green">' . $result3[0] . ' was succesfully removed.</font>';
}
unset($_SESSION['ContinueOK']);
unset($_SESSION['Username']);
$error4 = 'You will be redirected to the login page in 3 seconds.';
echo '<script type="text/javascript">';
echo 'setTimeout("window.location=\'deletechar.php\'",3000);';
echo '</script>';
}
$ShowResult1 = 'Slot1: <input type="checkbox" name="checkbox1" value="checked" />' . $result1[0] . '<br /><br />';
$ShowResult2 = 'Slot2: <input type="checkbox" name="checkbox2" value="checked" />' . $result2[0] . '<br /><br />';
$ShowResult3 = 'Slot3: <input type="checkbox" name="checkbox3" value="checked" />' . $result3[0] . '<br /><br />';
if(empty($result1[0])){
$ShowResult1 = "";
}
if(empty($result2[0])){
$ShowResult2 = "";
}
if(empty($result3[0])){
$ShowResult3 = "";
}
echo '<form action="deletechar2.php" method="post">';
echo $ShowResult1;
echo $ShowResult2;
echo $ShowResult3;
echo '<input type="submit" name="submit" value="Delete" />';
echo '</form>';
echo $error1;
echo $error2;
echo $error3;
echo $error4;
}
else{
echo '<center><font color="red">This page is not accessible if you don\'t enter your ingame username and password.</font></center>';
echo '<center><font color="red"><a href="deletechar.php">Click here to enter your username and password.</a></font></center>';
}
?>
#1: Change YOURHOST AND YOURPASSWORD in BOTH scripts!
#2: Save the first script as deletechar.php and the second script as deletechar2.php in THE SAME FOLDER!
#3: Enjoy!
Credits:
Credits go to me, myself and I. :P:
