flav's scripts

flav · Aug 6, 2008

This are the scripts I made for my server, I think all of them are already released but I made these on my own because I ever make things like that on my own. If you are going to make your own CMS you can use these scripts... Oh yea and btw, this scripts are fixed which most others which I tested aren't... Like 90% of the others have the bug that you once have to log in before you can use things like Password changing, I fixed it in my scripts!

Ok, don't know what else, just have fun with it!

connect.txt
This file is included in all files which requires the database, don't forget to change the settings...

Code:

<?php
$ms_host = "localhost"; //host
$ms_user = "root"; //user
$ms_password = ""; //password
$ms_database = "odinms"; //database

mysql_connect("$ms_host","$ms_user","$ms_password"); //connect
mysql_select_db("$ms_database"); //select database
?>

sign_up.php
This is the formular part of the sign up page... this doesn't need the "-" in the birthday, it asks for year, month and day in an own field

Code:

Here you can create your own account in only one step. Join us!
<br>
<br>
<form method="post" action="sign_up_2.php">
<table>
<tr>
<td>
<b>login id:</b>
</td>
<td>
<input type="text" name="login_id" maxlength="12">
</td>
</tr>
<tr>
<td>
<b>password:</b>
</td>
<td>
<input type="password" name="password" maxlength="12">
</td>
</tr>
<tr>
<td>
<b>birthday:</b>
</td>
<td>
<input type="text" name="birthday_year" maxlength="4" value="YYYY" style="width:64"><input type="text" name="birthday_month" maxlength="2" value="MM" style="width:32"><input type="text" name="birthday_day" maxlength="2" value="DD" style="width:32">
</td>
</tr>
<tr>
<td>
</td>
<td>
<input type="submit" value="Sign Up">
</td>
</tr>
</table>
</form>

sign_up_2.php
This is the second part of the sign up pages, it saves the data of the formular into the database or gives out errors.

Code:

<?php
include("connect.txt");

$login_id = $_POST["login_id"];
$password = sha1($_POST["password"]);
$birthday_year = $_POST["birthday_year"];
$birthday_month = $_POST["birthday_month"];
$birthday_day = $_POST["birthday_day"];

$check_account = mysql_query("SELECT * FROM accounts WHERE name = '$login_id'");
$check_account_2 = mysql_num_rows($check_account);

if ($login_id == "") {
	echo "
	Please enter a login ID.
	<br>
	<a href='javascript:history.back()'>Back</a>
	";
} elseif ($password == "da39a3ee5e6b4b0d3255bfef95601890afd80709") {
	echo "
	Please enter a password.
	<br>
	<a href='javascript:history.back()'>Back</a>
	";
} elseif ($birthday_year == "" OR $birthday_month == "" OR $birthday_day == "") {
	echo "
	Please enter your birthday.
	<br>
	<a href='javascript:history.back()'>Back</a>
	";
} elseif ($check_account_2 > 0) {
	echo "
	This login ID does already exist, please choose another login ID.
	<br>
	<a href='javascript:history.back()'>Back</a>
	";
} else {
	$create = "INSERT INTO accounts (name,password,birthday,nxCash) VALUES ('$login_id','$password','$birthday_year''-''$birthday_month''-''$birthday_day','5000')";
	mysql_query($create) OR DIE(mysql_error());
	echo "
	Your account has been created and you received 5,000 NX Cash.
	<br>
	<a href='javascript:history.back()'>Back</a>
	";
}
?>

change_password.php
The formular part of the change password site...

Code:

Here you can change your password.
<br>
(You have to be logged out if you want to do this or it won't work!)
<br>
<br>
<form method="post" action="change_password_2.php">
<table>
<tr>
<td>
<b>login id:</b> 
</td>
<td>
<input type="text" name="login_id" maxlength="12">
</td>
</tr>
<tr>
<td>
<b>old password:</b> 
</td>
<td>
<input type="password" name="old_password" maxlength="12">
</td>
</tr>
<tr>
<td>
<b>new password:</b> 
</td>
<td>
<input type="password" name="new_password" maxlength="12">
</td>
</tr>
<tr>
<td>
</td>
<td>
<input type="submit" value="Change Password">
</td>
</tr>
</table>
</form>

change_password_2.php
The second part of the change password site which changes the password...

Code:

<?php
include("connect.txt");

$login_id = $_POST["login_id"];
$old_password = $_POST["old_password"];
$new_password = $_POST["new_password"];

$resultsalt = mysql_query("SELECT salt FROM accounts WHERE name = '$login_id'");

if ($row = mysql_fetch_array($resultsalt)) {
	do {
		$salt = $row["salt"];
	}
	while ($row = mysql_fetch_array($resultsalt));
}

if ($salt == "") {
	$old_password_sha = hash("sha1",$old_password);
	$new_password_sha = hash("sha1",$new_password);
} else {
	$old_password_sha = hash("sha512",$old_password . $salt);
	$new_password_sha = hash("sha512",$new_password . $salt);
}

$check_login_id = mysql_query("SELECT * FROM accounts WHERE name = '$login_id'");
$check_login_id_2 = mysql_num_rows($check_login_id);

$check_old_password = mysql_query("SELECT * FROM accounts WHERE name = '$login_id' AND password = '$old_password_sha'");
$check_old_password_2 = mysql_num_rows($check_old_password);

if ($login_id == "") {
	echo "
	Please enter your login ID.
	<br>
	<a href='javascript:history.back()'>Back</a>
	";
} elseif ($old_password == "") {
	echo "
	Please enter your old password.
	<br>
	<a href='javascript:history.back()'>Back</a>
	";
} elseif ($new_password == "") {
	echo "
	Please enter a new password.
	<br>
	<a href='javascript:history.back()'>Back</a>
	";
} elseif ($check_login_id_2 < 1) {
	echo "
	This login ID does not exist.
	<br>
	<a href='javascript:history.back()'>Back</a>
	";
} else {
	if ($check_old_password_2 < 1) {
		echo "
		The old password is not correct.
		<br>
		<a href='javascript:history.back()'>Back</a>
		";
	} else {
		$change_password = "UPDATE accounts SET password = '$new_password_sha' WHERE name = '$login_id'";
		mysql_query("$change_password") or DIE(mysql_error());
		echo "
		Your password has been changed.
		<br>
		<a href='javascript:history.back()'>Back</a>
		";
	}
}
?>

buy_nx_cash.php
The formular part of the site to buy 5k nx cash...

Code:

Here you can buy 5,000 NX Cash for 5,000,000 Mesos.<br>
(You have to be logged out if you want to do this or it won't work!)
<br>
<br>
<form method="post" action="buy_nx_cash_2.php">
<table>
<tr>
<td>
<b>login id:</b> 
</td>
<td>
<input type="text" name="login_id" maxlength="12">
</td>
</tr>
<tr>
<td>
<b>password:</b> 
</td>
<td>
<input type="password" name="password" maxlength="12">
</td>
</tr>
<tr>
<td>
<b>character:</b> 
</td>
<td>
<input type="text" name="character" maxlength="12">
</td>
</tr>
<tr>
<td>
</td>
<td>
<input type="submit" value="Buy NX Cash">
</td>
</tr>
</table>
</form>

buy_nx_cash_2.php
This checks the data etc. and decrease the meso amount to increase the nxcash amount...

Code:

<?php
include("connect.txt");

$login_id = $_POST["login_id"];
$password = $_POST["password"];
$character = $_POST["character"];

$resultsalt = mysql_query("SELECT salt FROM accounts WHERE name = '$login_id'");

if ($row = mysql_fetch_array($resultsalt)) {
	do {
		$salt = $row["salt"];
	}
	while ($row = mysql_fetch_array($resultsalt));
}

if ($salt == "") {
	$password_sha = hash("sha1",$password);
} else {
	$password_sha = hash("sha512",$password . $salt);
}

$check_login_id = mysql_query("SELECT * FROM accounts WHERE name = '$login_id'");
$check_login_id_2 = mysql_num_rows($check_login_id);

$check_password = mysql_query("SELECT * FROM accounts WHERE name = '$login_id' AND password = '$password_sha'");
$check_password_2 = mysql_num_rows($check_password);

$check_character = mysql_query("SELECT * FROM characters WHERE name = '$character'");
$check_character_2 = mysql_num_rows($check_character);

if ($login_id == "") {
	echo "
	Please enter your login ID.
	<br>
	<a href='javascript:history.back()'>Back</a>
	";
} elseif ($password == "") {
	echo "
	Please enter your password.
	<br>
	<a href='javascript:history.back()'>Back</a>
	";
} elseif ($character == "") {
	echo "
	Please enter your character.
	<br>
	<a href='javascript:history.back()'>Back</a>
	";
} elseif ($check_login_id_2 < 1) {
	echo "
	This login ID does not exist.
	<br>
	<a href='javascript:history.back()'>Back</a>
	";
} else {
	if ($check_password_2 < 1) {
		echo "
		The password is not correct.
		<br>
		<a href='javascript:history.back()'>Back</a>
		";
	} else {
		if ($check_character_2 < 1) {
			echo "
			This character does not exist.
			<br>
			<a href='javascript:history.back()'>Back</a>
			";
		}
		else {
			while ($account = mysql_fetch_assoc($check_login_id)) {
				while ($character_2 = mysql_fetch_assoc($check_character)) {
					$mesos = $character_2["meso"] - 5000000;
					$nx_cash = $account["nxCash"] + 5000;
					if ($account["id"] == $character_2["accountid"]) {
						if ($character_2["meso"] < 5000000) {
							echo "
							You do not have enough Mesos.
							<br>
							<a href='javascript:history.back()'>Back</a>
							";
						} else {
							$update_mesos = "UPDATE characters SET meso = '$mesos' WHERE name = '$character'";
							mysql_query("$update_mesos") or DIE(mysql_error());
							$update_nx_cash = "UPDATE accounts SET nxCash = '$nx_cash' WHERE name = '$login_id'";
							mysql_query("$update_nx_cash") or DIE(mysql_error());
							echo "
							You have bought 5,000 NX Cash for 5,000,000 Mesos.
							<br>
							<a href='javascript:history.back()'>Back</a>
							";
						}
					} else {
						echo "
						This character is not yours.
						<br>
						<a href='javascript:history.back()'>Back</a>
						";				
					}
				}
			}
		}
	}
}
?>

gift_nx_cash.php
After your users are able to buy nx cash they maybe want to share their nx cash? The formular part to gift nx cash...

Code:

Here you can buy 5,000 NX Cash for 5,000,000 Mesos for someone else.
<br>
(You and the receiver have to be logged out if you want to do this or it won't work!)
<br>
<br>
<form method="post" action="gift_nx_cash_2.php">
<table>
<tr>
<td>
<b>login id:</b> 
</td>
<td>
<input type="text" name="login_id" maxlength="12">
</td>
</tr>
<tr>
<td>
<b>password:</b> 
</td>
<td>
<input type="password" name="password" maxlength="12">
</td>
</tr>
<tr>
<td>
<b>your character:</b> 
</td>
<td>
<input type="text" name="your_character" maxlength="12">
</td>
</tr>
<tr>
<td>
<b>receiver's character:</b> 
</td>
<td>
<input type="text" name="receivers_character" maxlength="12">
</td>
</tr>
<tr>
<td>
</td>
<td>
<input type="submit" value="Gift NX Cash">
</td>
</tr>
</table>
</form>

gift_nx_cash_2.php
Second part... bla bla you know already!

Code:

<?php
include("connect.txt");

$login_id = $_POST["login_id"];
$password = $_POST["password"];
$your_character = $_POST["your_character"];
$receivers_character = $_POST["receivers_character"];

$resultsalt = mysql_query("SELECT salt FROM accounts WHERE name = '$login_id'");

if ($row = mysql_fetch_array($resultsalt)) {
	do {
		$salt = $row["salt"];
	}
	while ($row = mysql_fetch_array($resultsalt));
}

if ($salt == "") {
	$password_sha = hash("sha1",$password);
} else {
	$password_sha = hash("sha512",$password . $salt);
}

$check_login_id = mysql_query("SELECT * FROM accounts WHERE name = '$login_id'");
$check_login_id_2 = mysql_num_rows($check_login_id);

$check_password = mysql_query("SELECT * FROM accounts WHERE name = '$login_id' AND password = '$password_sha'");
$check_password_2 = mysql_num_rows($check_password);

$check_your_character = mysql_query("SELECT * FROM characters WHERE name = '$your_character'");
$check_your_character_2 = mysql_num_rows($check_your_character);

$check_receivers_character = mysql_query("SELECT * FROM characters WHERE name = '$receivers_character'");
$check_receivers_character_2 = mysql_num_rows($check_receivers_character);

while ($check_receivers_login_id = mysql_fetch_assoc($check_receivers_character)) {
	$check_receivers_login_id_2 = mysql_query("SELECT * FROM accounts WHERE id = '$check_receivers_login_id[accountid]'");
}

if ($login_id == "") {
	echo "
	Please enter your login ID.
	<br>
	<a href='javascript:history.back()'>Back</a>
	";
} elseif ($password == "") {
	echo "
	Please enter your password.
	<br>
	<a href='javascript:history.back()'>Back</a>
	";
} elseif ($your_character == "") {
	echo "
	Please enter your character.
	<br>
	<a href='javascript:history.back()'>Back</a>
	";
} elseif ($receivers_character == "") {
	echo "
	Please enter receivers character.
	<br>
	<a href='javascript:history.back()'>Back</a>
	";
} elseif ($check_login_id_2 < 1) {
	echo "
	This login ID does not exist.
	<br>
	<a href='javascript:history.back()'>Back</a>
	";
} else {
	if ($check_password_2 < 1) {
		echo "
		The password is not correct.
		<br>
		<a href='javascript:history.back()'>Back</a>
		";
	} else {
		if ($check_your_character_2 < 1) {
			echo "
			This character (yours) does not exist.
			<br>
			<a href='javascript:history.back()'>Back</a>
			";
		}
		else {
			if ($check_receivers_character_2 < 1) {
				echo "
				This character (receivers) does not exist.
				<br>
				<a href='javascript:history.back()'>Back</a>
				";
			} else {
				while ($account = mysql_fetch_assoc($check_login_id)) {
					while ($character = mysql_fetch_assoc($check_your_character)) {
						while ($account_2 = mysql_fetch_assoc($check_receivers_login_id_2)) {
							$mesos = $character["meso"] - 5000000;
							$nx_cash = $account_2["nxCash"] + 5000;
							if ($account["id"] == $character["accountid"]) {
								if ($character["meso"] < 5000000) {
									echo "
									You do not have enough Mesos.
									<br>
									<a href='javascript:history.back()'>Back</a>
									";
								} else {
									$update_mesos = "UPDATE characters SET meso = '$mesos' WHERE name = '$your_character'";
									mysql_query("$update_mesos") or DIE(mysql_error());
									$update_nx_cash = "UPDATE accounts SET nxCash = '$nx_cash' WHERE id = $account_2[id]";
									mysql_query("$update_nx_cash") or DIE(mysql_error());
									echo "
									You have bought 5,000 NX Cash for 5,000,000 Mesos for $receivers_character.
									<br>
									<a href='javascript:history.back()'>Back</a>
									";
								}
							} else {
								echo "
								This character is not yours.
								<br>
								<a href='javascript:history.back()'>Back</a>
								";
							}				
						}
					}
				}
			}
		}
	}
}
?>

*[NOTICE] Look into the code and search for the amounts to change them...*

reset_exp.php
For negative EXP... formular part...

Code:

Here you can reset your EXP if it is a negative amount.
<br>
(You have to be logged out if you want to do this or it won't work!)
<br>
<br>
<form method="post" action="reset_exp_2.php">
<table>
<tr>
<td>
<b>login id:</b> 
</td>
<td>
<input type="text" name="login_id" maxlength="12">
</td>
</tr>
<tr>
<td>
<b>password:</b> 
</td>
<td>
<input type="password" name="password" maxlength="12">
</td>
</tr>
<tr>
<td>
<b>character:</b> 
</td>
<td>
<input type="text" name="character" maxlength="12">
</td>
</tr>
<tr>
<td>
</td>
<td>
<input type="submit" value="Reset EXP">
</td>
</tr>
</table>
</form>

reset_exp_2.php
...this sets the EXP of the user to 0!

Code:

<?php
include("connect.txt");

$login_id = $_POST["login_id"];
$password = $_POST["password"];
$character = $_POST["character"];

$resultsalt = mysql_query("SELECT salt FROM accounts WHERE name = '$login_id'");

if ($row = mysql_fetch_array($resultsalt)) {
	do {
		$salt = $row["salt"];
	}
	while ($row = mysql_fetch_array($resultsalt));
}

if ($salt == "") {
	$password_sha = hash("sha1",$password);
} else {
	$password_sha = hash("sha512",$password . $salt);
}

$check_login_id = mysql_query("SELECT * FROM accounts WHERE name = '$login_id'");
$check_login_id_2 = mysql_num_rows($check_login_id);

$check_password = mysql_query("SELECT * FROM accounts WHERE name = '$login_id' AND password = '$password_sha'");
$check_password_2 = mysql_num_rows($check_password);

$check_character = mysql_query("SELECT * FROM characters WHERE name = '$character'");
$check_character_2 = mysql_num_rows($check_character);

if ($login_id == "") {
	echo "
	Please enter your login ID.
	<br>
	<a href='javascript:history.back()'>Back</a>
	";
} elseif ($password == "") {
	echo "
	Please enter your password.
	<br>
	<a href='javascript:history.back()'>Back</a>
	";
} elseif ($character == "") {
	echo "
	Please enter your character.
	<br>
	<a href='javascript:history.back()'>Back</a>
	";
} elseif ($check_login_id_2 < 1) {
	echo "
	This login ID does not exist.
	<br>
	<a href='javascript:history.back()'>Back</a>
	";
} else {
	if ($check_password_2 < 1) {
		echo "
		The password is not correct.
		<br>
		<a href='javascript:history.back()'>Back</a>
		";
	} else {
		if ($check_character_2 < 1) {
			echo "
			This character does not exist.
			<br>
			<a href='javascript:history.back()'>Back</a>
			";
		}
		else {
			while ($account = mysql_fetch_assoc($check_login_id)) {
				while ($character_2 = mysql_fetch_assoc($check_character)) {
					if ($account["id"] == $character_2["accountid"]) {
						$reset_exp = "UPDATE characters SET exp = '0' WHERE name = '$character'";
						mysql_query("$reset_exp") or DIE(mysql_error());
						echo "
						Your EXP has been reseted.
						<br>
						<a href='javascript:history.back()'>Back</a>
						";
					} else {
						echo "
						This character is not yours.
						<br>
						<a href='javascript:history.back()'>Back</a>
						";				
					}
				}
			}
		}
	}
}
?>

log_out.php
Formular part for already logged in fix...

Code:

Here you can log out if it says that your account is already logged in.
<br>
<br>
<form method="post" action="log_out_2.php">
<table>
<tr>
<td>
<b>login id:</b> 
</td>
<td>
<input type="text" name="login_id">
</td>
</tr>
<tr>
<td>
<b>password:</b> 
</td>
<td>
<input type="password" name="password" maxlength="12">
</td>
</tr>
<tr>
<td>
</td>
<td>
<input type="submit" value="Log Out">
</td>
</tr>
</table>
</form>

log_out_2.php
The script part...

Code:

<?php
include("connect.txt");

$login_id = $_POST["login_id"];
$password = $_POST["password"];

$resultsalt = mysql_query("SELECT salt FROM accounts WHERE name = '$login_id'");

if ($row = mysql_fetch_array($resultsalt)) {
	do {
		$salt = $row["salt"];
	}
	while ($row = mysql_fetch_array($resultsalt));
}

if ($salt == "") {
	$password_sha = hash("sha1",$password);
} else {
	$password_sha = hash("sha512",$password . $salt);
}

$check_login_id = mysql_query("SELECT * FROM accounts WHERE name = '$login_id'");
$check_login_id_2 = mysql_num_rows($check_login_id);

$check_password = mysql_query("SELECT * FROM accounts WHERE name = '$login_id' AND password = '$password_sha'");
$check_password_2 = mysql_num_rows($check_password);

if ($login_id == "") {
	echo "
	Please enter your login ID.
	<br>
	<a href='javascript:history.back()'>Back</a>
	";
} elseif ($password == "") {
	echo "
	Please enter your password.
	<br>
	<a href='javascript:history.back()'>Back</a>
	";
} elseif ($check_login_id_2 < 1) {
	echo "
	This login ID does not exist.
	<br>
	<a href='javascript:history.back()'>Back</a>
	";
} else {
	if ($check_password_2 < 1) {
		echo "
		The password is not correct.
		<br>
		<a href='javascript:history.back()'>Back</a>
		";
	} else {
		mysql_query("UPDATE accounts SET loggedin = '0' WHERE name = '$login_id'");
		echo "
		You have been loged out.
		<br>
		<a href='javascript:history.back()'>Back</a>
		";
	}
}
?>

ranking.php
My ranking system, I add avatars and pages soon, for now it's a ranking which shows 10 users (you can easily change the limit) and doesn't show GM's and banned accounts...

Code:

<?php
include("connect.txt");

$rank = 1;
$limit = 100;

$check_character = mysql_query("SELECT * FROM characters WHERE gm = 0 ORDER BY level DESC,exp DESC");

echo "
<table cellpadding='5'>
<tr>
<td align='center'>
<b>Rank</b>
</td>
<td align='center'>
<b>Character Name</b>
</td>
<td align='center'>
<b>World</b>
</td>
<td align='center'>
<b>Job</b>
</td>
<td align='center'>
<b>Level</b>
</td>
<td align='center'>
<b>PVP Kills</b>
</td>
<td align='center'>
<b>PVP Deaths</b>
</td>
<td align='center'>
<b>Fame</b>
</td>
</tr>
";

while ($character=mysql_fetch_assoc($check_character)) {
	$check_account = mysql_query("SELECT * FROM accounts WHERE id = '$character[accountid]'");
	$account = mysql_fetch_array($check_account);

	if ($character[job] == 0) {
		$job = "<img src='images/job_beginner.gif' title='Beginner'>";
	} elseif ($character[job] == 100 OR $character[job] == 110 OR $character[job] == 120 OR $character[job] == 130 OR $character[job] == 111 OR $character[job] == 121 OR $character[job] == 131 OR $character[job] == 112 OR $character[job] == 122 OR $character[job] == 132) {
		$job = "<img src='images/job_warrior.gif' title='Warrior'>";
	} elseif ($character[job] == 200 OR $character[job] == 210 OR $character[job] == 220 OR $character[job] == 230 OR $character[job] == 211 OR $character[job] == 221 OR $character[job] == 231 OR $character[job] == 212 OR $character[job] == 222 OR $character[job] == 232) {
		$job = "<img src='images/job_magician.gif' title='Magician'>";
	} elseif ($character[job] == 300 OR $character[job] == 310 OR $character[job] == 320 OR $character[job] == 311 OR $character[job] == 321 OR $character[job] == 312 OR $character[job] == 322) {
		$job = "<img src='images/job_bowman.gif' title='Bowman'>";
	} elseif ($character[job] == 400 OR $character[job] == 410 OR $character[job] == 420 OR $character[job] == 411 OR $character[job] == 421 OR $character[job] == 412 OR $character[job] == 422) {
		$job = "<img src='images/job_thief.gif' title='Thief'>";
	}

	if ($rank > $limit) {
		echo "
		";
	} elseif ($account[banned] > 0 OR $account[tempban] > 0) {
		echo "
		";
	} else {
		echo "
		<tr>
		<td align='center'>
		<b>$rank</b>
		</td>
		<td align='center'>
		$character[name]
		</td>
		<td align='center'>
		<img src='images/world_scania.gif' title='Scania'>
		</td>
		<td align='center'>
		$job
		</td>
		<td align='center'>
		$character[level]
		<br>
		<font style='font-size:10px'>($character[exp])</font>
		</td>
		<td align='center'>
		$character[pvpkills]
		</td>
		<td align='center'>
		$character[pvpdeaths]
		</td>
		<td align='center'>
		$character[fame]
		</td>
		</tr>
		";
		$rank++;
	}
}

echo "
</table>
";
?>

info.php
for me it's index.php because i put the infos on my start page... this shows informations about the server... online or offline, created accounts, banned accounts, created characters, exp/meso/drop/bossdrop rate, game and homepage revision... you have to fill out, exp/meso/drop/bossdrop rate and game/homepage revision on your own (if somebody need i will add : how many game masters are on the server, which game masters are online, which users are online)...

Code:

<?php
$online_users = mysql_query("SELECT * FROM accounts WHERE loggedin > 0");
$online_users_2 = mysql_num_rows($online_users);

$status = @fsockopen($ms_host,8484,$errno,$errstr,15);
if (!$status) {
	$status_2 = "
	<b style='color:#FF0000'>offline</b>
	";
} else {
	$status_2 = "
	<b>Status:</b> <b style='color:#00FF00'>online</b>
	<br>
	<b>Online Users:</b> $online_users_2 / 100
	";
}
@fclose($status);

$created_accounts = mysql_query("SELECT * FROM accounts");
$created_accounts_2 = mysql_num_rows($created_accounts);

$created_accounts_banned = mysql_query("SELECT * FROM accounts WHERE banned > 0");
$created_accounts_banned_2 = mysql_num_rows($created_accounts_banned);

$created_characters = mysql_query("SELECT * FROM characters");
$created_characters_2 = mysql_num_rows($created_characters);

echo "
$status_2
<br>
<br>
<b>Created Accounts:</b> $created_accounts_2
<br>
 <b>Banned Accounts:</b> $created_accounts_banned_2</b>
<br>
<b>Created Characters:</b> $created_characters_2
<br>
<br>
<b>EXP Rate:</b> xEXP RATE
<br>
<b>MESO Rate:</b> xMESO RATE
<br>
<b>DROP Rate:</b> xDROP RATE
<br>
<b>BOSS DROP Rate:</b> xBOSS DROP RATE
<br>
<br>
<b>Game Revision:</b> REVISION (v0.55) [REPACK]
<br>
<b>Homepage Revision:</b> REVISION
";
?>

ihatehaxor · Aug 6, 2008

Re: [release] flav's scripts

isnt this more like a cms?

flav · Aug 6, 2008

Re: [release] flav's scripts

this are only the scripts which you can easily put into a cms, that are the designless scripts

ihatehaxor · Aug 6, 2008

Re: [release] flav's scripts

ok.
thanks for the release

Ritx · Aug 6, 2008

Re: [release] flav's scripts

Nice scripts.

flav · Aug 6, 2008

Re: [release] flav's scripts

ty, i made more but i deleted all unimportant... if you want me to make more scripts tell me

later i make a reborn script and another script which nobody has yet i'm sure that nobody has it yet

xiaochris · Aug 8, 2008

Re: [release] flav's scripts

great job ^^ ! looks like i dont have to code it! thanks. got msn ? Would like to have all the scripts u scripted

flav · Aug 8, 2008

Re: [release] flav's scripts

currently that are all, i had more but i deleted the other they were un important also i didn't work two weeks on my serve and start working on it a bit now and then i make good scripts but yea you can add me and i tell you when i have new scripts

[email protected]

megoesrawr · Aug 8, 2008

Re: [release] flav's scripts

That's pretty nice O_O

flav · Aug 8, 2008

Re: [release] flav's scripts

thanks...
this was the first time that i started to work with mysql at php

at beginning had some problems with buy nx and gift nx but then all worked fine

i think i also have all important error messages added

DkWar · Aug 8, 2008

Re: [release] flav's scripts

lol ok how abt this idea.. instead of releasing the scripts, try make a cms with all the scripts den name it "FCMS"

flav · Aug 8, 2008

Re: [release] flav's scripts

already made some cms but didn't release any of them yet

i will make a new cms soon which i will release, the problem is that i worked too much on my website that i have to work more on my server now before i will work on the website again

DkWar · Aug 8, 2008

Re: [release] flav's scripts

lol kayz its up to u anyways

fen92 · Aug 8, 2008

Re: [release] flav's scripts

Warning: include(connect.txt) [function.include]: failed to open stream: No such file or directory in C:\xampp\htdocs\change_password_2.php on line 2

Warning: include() [function.include]: Failed opening 'connect.txt' for inclusion (include_path='.;C:\xampp\php\pear\') in C:\xampp\htdocs\change_password_2.php on line 2

Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\xampp\htdocs\change_password_2.php on line 8

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in C:\xampp\htdocs\change_password_2.php on line 8

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\change_password_2.php on line 10

Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\xampp\htdocs\change_password_2.php on line 25

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in C:\xampp\htdocs\change_password_2.php on line 25

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\change_password_2.php on line 26

Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\xampp\htdocs\change_password_2.php on line 28

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in C:\xampp\htdocs\change_password_2.php on line 28

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\change_password_2.php on line 29
This login ID does not exist.
Back

Help tis error ? . For change pass

flav · Aug 8, 2008

Re: [release] flav's scripts

Don't forget that the scripts includes connect.txt which connects to your database. Put connect.txt in the same folder as change_password_2.php and don't forget to configure connect.txt!

Code:

<?php
$ms_host = "localhost"; //host
$ms_user = "root"; //user
$ms_password = ""; //password
$ms_database = "odinms"; //database

mysql_connect("$ms_host","$ms_user","$ms_password"); //connect
mysql_select_db("$ms_database"); //select database
?>

jeremywillo · Aug 9, 2008

Re: [release] flav's scripts

Very useful thanks

Savage · Aug 9, 2008

Re: [release] flav's scripts

Nice scripts.
+1

Traitor · Aug 9, 2008

Re: [release] flav's scripts

Looks like a lot of your scripts are insecure.

Superfun · Aug 9, 2008

Re: [release] flav's scripts

Why calling it connect.txt
So can everbody hack in your mysql database lol.

flav · Aug 10, 2008

Re: [release] flav's scripts

Superfun said:
Why calling it connect.txt
So can everbody hack in your mysql database lol.

This is just an example, I self called mine something like "asfdasdfasdfasdfsad.txt" so it doesn't matter if it's .php or .txt file as long as they don't know the file name, does it?

flav's scripts

Elite Diviner

Custom Title Activated

Elite Diviner

Custom Title Activated

Newbie Spellweaver

Elite Diviner

Newbie Spellweaver

Elite Diviner

Legendary Battlemage

Elite Diviner

Newbie Spellweaver

Elite Diviner

Newbie Spellweaver

Newbie Spellweaver

Elite Diviner

Newbie Spellweaver

¯\_(ツ)_/¯

You've got my respect!

The Omega

Elite Diviner

RaGEZONE Sponsor

About RaGEZONE

Forum Statistics

RaGEZONE Partners