Another full PHP website package

**FragFrog** · 22-12-04

Originally Posted by arlfrosty99

Awesome reply but, you missed my point. For those who know where to start or even have a slight idea will be able to work through this and do "exactly" what you said. Even a lazy man could make the packages work by copy and pasting the code where it needs to be. The fact of the matter is that not "everyone" knows anything about PHP let alone HTML.

Absolutely right, and IMHO is this a good point for someone like that to start learning. For those who don't feel like putting that much effort into a website there are always the about 3 other packages released by others with an easier to use interface :)

Not everyone has the knowledge that we think they should. It was just a opinion and hope I didn't start nothing by it. I just felt that it would be cool to see someone put that much work into a project since we haven't had anyone do anything like that for a while.

Any other time, sure, but fact is I really don't have the time to teach everyone how to use this, or create individual pages to fit peoples needs. Currently working very hard on running my own server as well as preparing it to be the official RageZone server (just got word from the boss ;)), so I kind'a hoped people would pick this up and went on developing it themselfs. Most of my work the past few weeks consisted of getting all the pages to have the same layout and I-frame compatible, continueing that way with new functions should be very simple since most of the standart framework can be simply copy-pasted.

Yes you do, and you'll always be my hero.. Well, until the next one takes over. Minas kicks ass...

Where the hell did that quote come from? :icon6:

**ZeRaTuL88** · 23-12-04

Originally Posted by Ambuhed

for our old method to reset use the package without reward of fragfrog and then edit reset_reward_done-php with this

Code:

<style type="text/css">
<!--
.style1 {
color: #FF0000;
font-size: 14px;
**
-->
</style>
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="1" style="border-left:1px solid #666666;border-right:1px solid #666666"></td>
</tr>
</table>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="img/css.css" rel="stylesheet" type="text/css">
<p>
<style type="text/css">
<!--
.style1 {color: #FF0000 **
.style2 {color: #FF0000 **
.Estilo5 {color: #666666**
.Estilo6 {font-size: larger**
.Estilo8 {color: #FF0000; font-weight: bold**
-->
</style><body leftmargin="0" topmargin="0">
<?php
require 'config.php';
$name = stripslashes($_POST['name']);
$login = stripslashes($_POST['login']);
$lvlreq = 349;
$newlvl = 1;
$exp = 0;
$money = 50000000

?>

<?php

		   $conn = mssql_connect("$dbhost","$dbuser","$dbpasswd");
   mssql_select_db('MuOnline', $conn);

		$query_reset = mssql_query("SELECT * FROM Character WHERE Name = '".$_POST['name']."' AND AccountID = '".$_POST['login']."'");
		while($row_reset = mssql_fetch_array($query_reset))
		{
		$resetcount = $row_reset['Resets'];
		$resetplus = $resetcount + 1;
		$value_points = 350 * $resetplus;
		$stat_points = 26;
		**
		if (mssql_num_rows(mssql_query("SELECT * FROM Character WHERE Name = '".$_POST['name']."' AND AccountID = '".$_POST['login']."'")) > 0) {
			$row = mssql_fetch_array(mssql_query("SELECT * FROM Character WHERE Name = '".$_POST['name']."' AND AccountID = '".$_POST['login']."'"));
			if ($row['cLevel'] > '349') {
			if ($row['Money'] > $money) {
					$money_total = $row['Money'] - $money ;
					$query = mssql_query("
									UPDATE Character SET cLevel = '$newlvl' WHERE Name = '".$_POST['name']."'  AND AccountID = '".$_POST['login']."'
									UPDATE Character SET money = '$money_total' WHERE Name = '".$_POST['name']."'  AND AccountID = '".$_POST['login']."'
									UPDATE Character SET Experience = '$exp' WHERE Name = '".$_POST['name']."'  AND AccountID = '".$_POST['login']."'
									UPDATE Character SET LevelUpPoint = '$value_points' WHERE Name = '".$_POST['name']."'  AND AccountID = '".$_POST['login']."'
									UPDATE Character SET Strength = '$stat_points' WHERE Name = '".$_POST['name']."'  AND AccountID = '".$_POST['login']."'
									UPDATE Character SET Dexterity = '$stat_points' WHERE Name = '".$_POST['name']."'  AND AccountID = '".$_POST['login']."'
									UPDATE Character SET Vitality = '$stat_points' WHERE Name = '".$_POST['name']."'  AND AccountID = '".$_POST['login']."'
									UPDATE Character SET Energy = '$stat_points' WHERE Name = '".$_POST['name']."'  AND AccountID = '".$_POST['login']."'
									UPDATE Character SET Resets = Resets+1 WHERE Name = '".$_POST['name']."'  AND AccountID = '".$_POST['login']."'");
					if (!$query) {
						echo "<font color='0099FF'><font size='2'>Character Reset could not be properly preformed. Database threw an error.";
					** else {
						echo "<font color='0099FF'><font size='2'>".$_POST['name']." is successfully Reseted..";
					**
				** else {
					echo "<font color='0099FF'><font size='2'>Character Reset could not be preformed. Not enough zen.";
					echo "<br>Actual (".$row['Money'].") - Needed ($money)";
				**
			** else {
				echo "<font color='0099FF'><font size='2'>Character Reset could not be preformed. Your not Level 350.";
			**
		** else {
			echo "<font color='0099FF'><font size='2'>Character Reset could not be performed. Character ".$_POST['name']." or the Login given do not match.";
		**

?>
</p>
<div align="center">
<table width="67%" height="339" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<tr>
</td>
</tr>
</table>
</div>
</body>
</html>
</body>
</html>

As my server is a "Fast" server, the reset is done quicky so there's no way i'm giving a reward :P but, this reset, what does it do? it just drops u to lvl 1 with the old stats or it does something else? (i'd realy like to know PHP just to help and not posting stuff like this but this is like chinise to me :P)
i'd be thankfull if you help me :D

**FragFrog** · 23-12-04

The script I provided on the bottom of the first page just resets users. His script also makes it cost 5M zen :)

**arlfrosty99** · 23-12-04

Originally Posted by FragFrog

Absolutely right, and IMHO is this a good point for someone like that to start learning. For those who don't feel like putting that much effort into a website there are always the about 3 other packages released by others with an easier to use interface :)

Back to what I said in the first place. ""Not everyone know where to start. Let alone "HOW" to start"". I highly doubt you jumped right into PHP without any knowledge of HTML. I believe it "could" be done. I'm not saying you didn't. I'm just saying that it's "HIGHLY" unlikely. If you did, more power to you :)

Originally Posted by FragFrog

Any other time, sure, but fact is I really don't have the time to teach everyone how to use this, or create individual pages to fit peoples needs. Currently working very hard on running my own server as well as preparing it to be the official RageZone server (just got word from the boss ;)), so I kind'a hoped people would pick this up and went on developing it themselfs. Most of my work the past few weeks consisted of getting all the pages to have the same layout and I-frame compatible, continueing that way with new functions should be very simple since most of the standart framework can be simply copy-pasted.

Congrats on being the Official RZ MU Server (nice pick, Mental). I'm not saying your work was bad. I'm just saying that it's been a while since we've had anyone build a all-around package. You have to admit, it would be pretty nice to see a package with a bit more variation. Your work by far is appreciated, and I encourage you to keep up the good work (Like my encouragement is ever needed anyway, but whatever..). It was just a opinion attached to the Great Job and thanks for your efforts speech that I was trying to put out there.

Originally Posted by FragFrog

Where the hell did that quote come from? :icon6:

My bad, I got a bit carried away on the Quotes

In closing, I would like to say... Continue to kick ass u.. bad ass mod u..

Lets also call it enough on the off topic chat before we confuse someone.

**ZeRaTuL88** · 23-12-04

hey Frag, i get this error when i try to reset, Parse error: parse error in c:\appserv\www\reset_reward_done.php on line 47
my line 47 reads like this:

PHP Code:

 while($row_reset = mssql_fetch_array($query_reset))

i like "customized" mi reset page to show only the reset options and not the Reward ones. My opties_reset.php is like this:

PHP Code:


<html>

<head>

<LINK REL="StyleSheet" HREF="style.css" TYPE="text/css">

</head>

<body>

<?PHP include("config.php"); ?>

<table border="0" cellspacing="0" cellpadding="0" width="480">

  <tr>

    <td> <p><font size='5'><b>Reset</b></font> 

<form name='form1' method='post' action='reset_reward_done.php'>

 
<table width="100%" border="0" cellspacing="0" cellpadding="0">

<tr>

<td width="17%">&nbsp;</td>

<td colspan="3">&nbsp;</td>

</tr>

<tr>

<td height="19"> <div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Nombre de

usuario: </font></div></td>

<td colspan="3"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">

<input name="login" type="text" id="login" maxlength="10">

Este es tu nombre de usuario.</font></td>

</tr>

<tr>

<td height="26"><div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Nombre del

personaje:</font></div></td>

<td colspan="3"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">

<input name="name" type="text" id="name" maxlength="10">

Este es el nombre de tu PJ.</font></td>

</tr>

 
<tr>

<td height="26"><div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Password:</font></div></td>

<td colspan="3"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">

 <input name="oldpwd" type="password" id="oldpwd" maxlength="10">

Este es tu Password</font></td>

</tr>

<tr>

 
<tr>

<td><div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"></font></div></td>

<td width="15%">&nbsp;</td>

<td width="12%"><input type="submit" name="Submit" value="Submit"></td>

<td width="56%"><input type="reset" name="Submit2" value="Reset"></td>

</tr>

</table>

</form>

      </p>

      </td>

  </tr>

</table>

</body>

</html>

Argetinian people play my server that's why some things are in spanish :P

Anyway You RULE! and thnx for your help :D
(sry for bad english :P)

**FragFrog** · 23-12-04

Originally Posted by ZeRaTuL88

hey Frag, i get this error when i try to reset, Parse error: parse error in c:\appserv\www\reset_reward_done.php on line 47
my line 47 reads like this:

PHP Code:

 while($row_reset = mssql_fetch_array($query_reset))

i like "customized" mi reset page to show only the reset options and not the Reward ones. My opties_reset.php is like this:

That line 47 is not in my scripts, so I'm not sure what you're trying to do with it, but I see 2 possible errors with it:

1. on equations, use '==' -> $row_reset == mssql_fetch_array($query_reset))
2. you can't compare a variable with an array AFAIK, do a fetch_row_results

But better ask the one who provided that script, prolly something simple.. ;)

**TakaShi^^** · 23-12-04

Just Use it,Or See my Guide,FragFrog Make this Script for people who like it,not ur nonsense reply

**ZeRaTuL88** · 23-12-04

Sry to bother again T_T but i dl the reset_reward_done.rar FragFrog posted but, it still gives me error, the error looks like this: Parse error: parse error in c:\appserv\www\reset_reward_done.php on line 99
i did not change anything on the files because i wanted to test it first... but it still gives me error, can anyone help me?

Thnx in advance

**FragFrog** · 23-12-04

Stupid forum.. won't let me post a right bracket! :chair:

Anyway, remove it so line 99 now reads this:
echo "$name is successfully resetted and has been rewarded likewise.";

**ZeRaTuL88** · 23-12-04

Thak you a lot!! It Worked!!! THANKS!!!

**Ambuhed** · 24-12-04

frag frog pliz can input on this code the sql inject checker?pliz help me i need
i dont dont know how add that sql inject checker can i do that for me?

Code:

<style type="text/css">
<!--
.style1 {
color: #FF0000;
font-size: 14px;
**
-->
</style>
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="1" style="border-left:1px solid #666666;border-right:1px solid #666666"></td>
</tr>
</table>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="img/css.css" rel="stylesheet" type="text/css">
<p>
<style type="text/css">
<!--
.style1 {color: #FF0000 **
.style2 {color: #FF0000 **
.Estilo5 {color: #666666**
.Estilo6 {font-size: larger**
.Estilo8 {color: #FF0000; font-weight: bold**
-->
</style><body leftmargin="0" topmargin="0">
<?php
require 'config.php';
$name = stripslashes($_POST['name']);
$login = stripslashes($_POST['login']);
$lvlreq = 349;
$newlvl = 1;
$exp = 0;
$money = 50000000
?>
<?php
$conn = mssql_connect("$dbhost","$dbuser","$dbpasswd");
mssql_select_db('MuOnline', $conn);
$query_reset = mssql_query("SELECT * FROM Character WHERE Name = '".$_POST['name']."' AND AccountID = '".$_POST['login']."'");
while($row_reset = mssql_fetch_array($query_reset))
{
$resetcount = $row_reset['Resets'];
$resetplus = $resetcount + 1;
$value_points = 350 * $resetplus;
$stat_points = 26;
**
if (mssql_num_rows(mssql_query("SELECT * FROM Character WHERE Name = '".$_POST['name']."' AND AccountID = '".$_POST['login']."'")) > 0) {
$row = mssql_fetch_array(mssql_query("SELECT * FROM Character WHERE Name = '".$_POST['name']."' AND AccountID = '".$_POST['login']."'"));
if ($row['cLevel'] > '349') {
if ($row['Money'] > $money) {
$money_total = $row['Money'] - $money ;
$query = mssql_query("
UPDATE Character SET cLevel = '$newlvl' WHERE Name = '".$_POST['name']."'  AND AccountID = '".$_POST['login']."'
UPDATE Character SET money = '$money_total' WHERE Name = '".$_POST['name']."'  AND AccountID = '".$_POST['login']."'
UPDATE Character SET Experience = '$exp' WHERE Name = '".$_POST['name']."'  AND AccountID = '".$_POST['login']."'
UPDATE Character SET LevelUpPoint = '$value_points' WHERE Name = '".$_POST['name']."'  AND AccountID = '".$_POST['login']."'
UPDATE Character SET Strength = '$stat_points' WHERE Name = '".$_POST['name']."'  AND AccountID = '".$_POST['login']."'
UPDATE Character SET Dexterity = '$stat_points' WHERE Name = '".$_POST['name']."'  AND AccountID = '".$_POST['login']."'
UPDATE Character SET Vitality = '$stat_points' WHERE Name = '".$_POST['name']."'  AND AccountID = '".$_POST['login']."'
UPDATE Character SET Energy = '$stat_points' WHERE Name = '".$_POST['name']."'  AND AccountID = '".$_POST['login']."'
UPDATE Character SET Resets = Resets+1 WHERE Name = '".$_POST['name']."'  AND AccountID = '".$_POST['login']."'");
if (!$query) {
echo "<font color='0099FF'><font size='2'>Character Reset could not be properly preformed. Database threw an error.";
** else {
echo "<font color='0099FF'><font size='2'>".$_POST['name']." is successfully Reseted..";
**
** else {
echo "<font color='0099FF'><font size='2'>Character Reset could not be preformed. Not enough zen.";
echo "<br>Actual (".$row['Money'].") - Needed ($money)";
**
** else {
echo "<font color='0099FF'><font size='2'>Character Reset could not be preformed. Your not Level 350.";
**
** else {
echo "<font color='0099FF'><font size='2'>Character Reset could not be performed. Character ".$_POST['name']." or the Login given do not match.";
**
?>
</p>
<div align="center">
<table width="67%" height="339" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<tr>
</td>
</tr>
</table>
</div>
</body>
</html>
</body>
</html>

ty so much fragfrog pliz do it for me and all ppl needing that..

**cwquek** · 24-12-04

Thank you FragFrog. I m using it on my server now.

**floridasucks** · 25-12-04

it shows Your Login does not exist in our database. Please go back and try again.
My charcter exist .. i tried a few character with lvl 350 and over 200M non gm and gm
i made a table called Reset
i added the columns
"Name", data type "nvarchar"
"Armor", data type "int"
"Weapon", data type "int"
"Wing", data type "int"
"Ring", data type "int"
"Pendant", data type "int"
"Shield", data type "int"
"Resets", data type "int"
the rest of options are working jus this one and most important is not i copied the config.php to the 3 reset folders (armor,wing,weapon) but still not working
btw do i have to add a default value like 0? do i ahve to make a folder for it like Website cant i jus put it directly on the htdocs so ppl cant view what folders i ahve

**TakaShi^^** · 25-12-04

Ok SImple Just FOllow Tis Guide Below by daemon_px

Ok guys, I'm doing this step by step, while I'm installing Appserv 2.4.0 (get it at Appserv ,this pack comes with Apache, PHP and MySQL.
In this guide I'm not using MySQL, as IO* PHP MU Web Center is designed to work with Microsoft SQL Server, and if people have trouble using it as it is, i wonder if I'd go around asking to change scripts.
Let's move on:

1. Installing Apache webserver & PHP Support:
Just follow on-screen instructions regarding where to Install, in the Setup Type, choose Custom.
Untick phpMyAdmin And MYSQL
Note: DUN UNTICK Apache and PHP.

Next, type in your server name: something like www.mydomain.com or just leave it as localhost.
If localhost is chosen, the webserver will work only locally.
Remember that you can't just come up with a servername, it has to be registered and working DNS.
You can get free DNS with "auto" update for dynamic IPs from http://www.no-ip.com or http://www.no-ip.com/ (I won't give any help on this, read the sites FAQ's).
Type in the server admin e-mail (probably it's your's), and the port where it sould be listening for conections. If possible, just leave it 80.
------------------- my config for this dialog ------------------------
server name: e-daemon.gotdns.org
server admin email: services.admin@e-daemon.gotdns.org
port: 80
----------------------------------------------------------------------------
Click next, and setup will finish.On the last dialog, let it start apache. No need to start MySQL, as it hasn't been installed.
Now, if you type your chosen server name (localhost or whatever) in your web browser, you'll get a wellcome page from AppServ.
- !!!!!!!!!!!!!!! Your webserver is now running !!!!!!!!!!!!!!!!!!
////////////////////////////////////**********************\\\\\\\\\\\\\\\\\\\\\\\\\\\\ \\\\
2. Configure PHP so it works with SQL (No more "Line 9 error")
I think this is where most people get in trouble, but that's just because they haven't read IO* readme that goes with the webpage files.
Let's open the php.ini file (it's in your windows dir - for me it's "C:\WINNT\php.ini" ). Use notepad to open it, disable word wrap, so you can check line numbers on the status bar.
*In line 576, where it reads
;extension=php_mssql.dll
take the leading ";"
Save the file, close, and restart Apache (If you haven't done it allready, bring up apache monitor - it's in your start menu\AppServ\Apache Control Server - it's easyer to stop/start apache this way).

Now you can extract the files from Website(FragFrog)New Package(Extract to C:appserv/www/here
3. Configure Webcenter and/or your SQL server so they work with each other
After extracting the files, let's open config.php in notepad.

===================In Config.PhP=================

<?php
//=========== FragFrog's MU WebCenter ===============
// Welcome to FrogMu's WebCenter, originally based on
// IO*'s files and editted and modified by FragFrog
//=========== FragFrog's Mu WebCenter ================

//============== USER EDITABLE AREA ===================
// Enter the username to connect to the db
$dbuser = "sa";

// Enter the password for the SQL Server
$dbpasswd = "";====>Change Tis to ur PassWord

//Admin Login
$alogin = ""; ===>U can use sa

//Admin Password
$apass = ""; ===>Change Tis to ur PassWord

================================================== ======
In Order to View it,It Should be as Example http://lala.no-ip.org/Website/
Change Lala.no-ip.org to ur dns name ^^ Ok after tis Done ^^

2nd thing:Please copy config.php after u have edited it and paste in Weapon Folder,Wing Folder and Armour Folder which look like tis ===>Website\weapon,Website\wing,Website\armor

2. The resets counter

Open the SQL manager. Go to your MuOnline database,
select tables, rightmousebutton and click
'New Table...' Add the following columns:

"Name", data type "nvarchar"
"Armor", data type "int"
"Weapon", data type "int"
"Wing", data type "int"
"Ring", data type "int"
"Pendant", data type "int"
"Shield", data type "int"
"Resets", data type "int"

Then click the 'Table and Index properties'
button, topleft next to the 'save' button.
Enter "Resets" as a table name.

All Credit Go to FragFroG

**Street~bb** · 25-12-04

i like it

Another full PHP website package

LinkBack

Thread Tools

Yay, someone saved my life

Anyway Stop saying so much problem,FragFrog is Good enough to release his/her script.

Thank u.

Reset a character not working

Read!!!!!

Posting Permissions