Hallo Leute ich realese mal die register page da ist noch mehr dabei vielicht könnte es ja twillight oder so fixxen
quelle PHP - MSSQL Connect (for A Game Server) | DreamInCode.net
PHP
QUOTE
<link rel="stylesheet" href="style.css" type="text/css">
<center>
<?php
function passConvert($password)
{
$encar = array('!'=>'95', '"'=>'88', '#'=>'9D', '$'=>'4C', '%'=>'F2', '&'=>'3E', '\''=>'BB', '('=>'C0', ')'=>'7F', '*'=>'18', '+'=>'70', ','=>'A6', '-'=>'E2', '.'=>'EC', '/'=>'77',
'0'=>'2C', '1'=>'3A', '2'=>'4A', '3'=>'91', '4'=>'5D', '5'=>'7A', '6'=>'29', '7'=>'BC', '8'=>'6E', '9'=>'D4', ':'=>'40', ';'=>'17', '<'=>'2E', '='=>'CB', '>'=>'72', '?'=>'9C',
'@'=>'A1', 'A'=>'FF', 'B'=>'F3', 'C'=>'F8', 'D'=>'9B', 'E'=>'50', 'F'=>'51', 'G'=>'6D', 'H'=>'E9', 'I'=>'9A', 'J'=>'B8', 'K'=>'84', 'L'=>'A8', 'M'=>'14', 'N'=>'38', 'O'=>'CE',
'P'=>'92', 'Q'=>'5C', 'R'=>'F5', 'S'=>'EE', 'T'=>'B3', 'U'=>'89', 'V'=>'7B', 'W'=>'A2', 'X'=>'AD', 'Y'=>'71', 'Z'=>'E3', '['=>'D5', '\\'=>'BF', ']'=>'53', '^'=>'28', '_'=>'44',
'`'=>'33', 'a'=>'48', 'b'=>'DB', 'c'=>'FC', 'd'=>'09', 'e'=>'1F', 'f'=>'94', 'g'=>'12', 'h'=>'73', 'i'=>'37', 'j'=>'82', 'k'=>'81', 'l'=>'39', 'm'=>'C2', 'n'=>'8D', 'o'=>'7D',
'p'=>'08', 'q'=>'4F', 'r'=>'B0', 's'=>'FE', 't'=>'79', 'u'=>'0B', 'v'=>'D6', 'w'=>'23', 'x'=>'7C', 'y'=>'4B', 'z'=>'8E', '{'=>'06', '|'=>'5A', '}'=>'CC', '~'=>'62');
$newpass = "0x";
for ($i = 0; $i < strlen($password); $i++)
{
$newpass .= $encar[$password[$i]];
}
return $newpass;
}
if ($_POST["gogogo"])
{
$err = "";
if (!$_POST["accname"]) $err .= "<font color='red'><b>Enter an ID <br>\n";
if (!$_POST["accpass1"]) $err .= "<font color='red'><b>Enter an Password <br>\n";
if (!$_POST["accpass2"]) $err .= "<font color='red'><b>Repeat Password <br>\n";
if (!$_POST["charname"]) $err .= "<font color='red'><b>Type your character name <br>\n";
if ($err == "")
{
if ($_POST["accpass1"] != $_POST["accpass2"])
$err .= "<font color='red'><b>Passwords does not match! <br>\n";
}
if ($err == "")
{
// using standard windows authentication, whwn you use a password, use this line
// $msconnect = mssql_connect("localhost", "username", "pass");
$msconnect = mssql_connect("70.95.186.120");
$msdb = mssql_select_db("kal_auth", $msconnect);
$cpass = passConvert($_POST["accpass1"]);
$query = "INSERT INTO Login ([ID], [PWD], [Birth], [Type], [ExpTime]) VALUES('".$_POST["accname"]."', $cpass , '19190101', '0', '4000')";
//echo $query;
$acccreate = mssql_query($query);
if ($acccreate)
{
$uid = mssql_result(mssql_query("SELECT [UID] from Login WHERE [ID]='".$_POST["accname"]."'"),0,0);
mssql_close() or die('failed closing mssql');
if ($_POST["charclass"] == 0)
{
$curhp = '183';
$curmp = '165';
$wepid = '1';
}
elseif ($_POST["charclass"] == 1)
{
$curhp = '148';
$curmp = '215';
$wepid = '90';
}
elseif ($_POST["charclass"] == 2)
{
$curhp = '147';
$curmp = '174';
$wepid = '22';
}
// the same as last time
$msconnect = mssql_connect("70.95.186.120");
$msdb = mssql_select_db("kal_db", $msconnect);
$query = "INSERT INTO Player ([UID], [Admin], [Name], [Class], [Specialty], [Level], [Contribute], [Exp], [GID], [GRole], [Strength], [Health], [Intelligence], [Wisdom], [Dexterity], [CurHP], [CurMP], [PUPoint], [SUPoint], [Killed], [Map], [X], [Y], [Z], [Face], [Hair], [RevivalId], [Rage])
VALUES('$uid','0','".$_POST["charname"]."','".$_POST["charclass"]."','1','1','0','0','0','0','0','0','0','".$_POST["wis"]."','0','$curhp','$curmp','65','0','0','0','257304','259299','16131','".$_POST["charface"]."','".$_POST["charhair"]."','0','0')";
//echo $query;
mssql_query($query);
// RECALL PLAYER ID
$pid = mssql_result(mssql_query("SELECT PID FROM Player WHERE Name='".$_POST["charname"]."'"),0,0);
// RECALL ITEM ID
$re = mssql_query("SELECT IID FROM item order by IID desc");
if ($re == TRUE)
$iid = 0;
else
$iid = mssql_result($re, 0, 0);
$iid++;
// INSERT G1 WEAPON
mssql_query("INSERT INTO Item ([PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [UpgrRate], [UpgrLevel], [Protect], [XAttack], [XMagic], [XDefense], [XHit], [XDodge]) VALUES ('$pid','$iid','$wepid','0','0','1','3','3','0','0','0','0','0','0','0','0','0')");
// INSERT SKILLZ
if($_POST["charclass"] == 1){ mssql_query("INSERT INTO Skill ([PID], [Index], [Level]) VALUES ('$pid','4','1')"); }
mssql_query("INSERT INTO Skill ([PID], [Index], [Level]) VALUES ('$pid','0','1')");
mssql_query("INSERT INTO Skill ([PID], [Index], [Level]) VALUES ('$pid','1','1')");
mssql_query("INSERT INTO Skill ([PID], [Index], [Level]) VALUES ('$pid','11','1')");
mssql_query("INSERT INTO Quest ([PID], [Quest], [Flag], [Clear]) VALUES ('$pid','9001','1','0')");
$_POST["accname"] = "";
$_POST["charname"] = "";
$_POST["str"] = "";
$_POST["hlt"] = "";
$_POST["int"] = "";
$_POST["wis"] = "";
$_POST["agi"] = "";
$err = "<b>Your account has been made you can login now!</b>";
}
else echo "something's wrong tongue.gif";
mssql_close() or die('failed closing mssql');
}
}
?>
<title>Registration Page -Yomo- Private Server</title>
</head>
<body bgcolor="#1b1f2b" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table id="Table_01" width="800" height="601" border="0" cellpadding="0" cellspacing="0">
<tr>
<td colspan="11">
<img src="images/register_01.gif" width="800" height="166" alt=""></td>
</tr>
<tr>
<td colspan="2" rowspan="4">
<img src="images/register_02.gif" width="133" height="92" alt=""></td>
<td>
<a href="../index.html">
<img src="images/register_03.gif" width="185" height="21" border="0" alt=""></a></td>
<td rowspan="4">
<img src="images/register_04.gif" width="4" height="92" alt=""></td>
<td colspan="3">
<a href="../register.php">
<img src="images/register_05.gif" width="181" height="21" border="0" alt=""></a></td>
<td rowspan="4">
<img src="images/register_06.gif" width="4" height="92" alt=""></td>
<td>
<a href="../rank.php">
<img src="images/register_07.gif" width="181" height="21" border="0" alt=""></a></td>
<td colspan="2" rowspan="4">
<img src="images/register_08.gif" width="112" height="92" alt=""></td>
</tr>
<tr>
<td rowspan="3">
<img src="images/register_09.gif" width="185" height="71" alt=""></td>
<td colspan="3">
<img src="images/register_10.gif" width="181" height="41" alt=""></td>
<td rowspan="3">
<img src="images/register_11.gif" width="181" height="71" alt=""></td>
</tr>
<tr>
<td rowspan="2">
<img src="images/register_12.gif" width="23" height="30" alt=""></td>
<td>
<img src="images/register_13.gif" width="135" height="19" alt=""></td>
<td rowspan="2">
<img src="images/register_14.gif" width="23" height="30" alt=""></td>
</tr>
<tr>
<td>
<img src="images/register_15.gif" width="135" height="11" alt=""></td>
</tr>
<tr>
<td rowspan="2">
<img src="images/register_16.gif" width="45" height="342" alt=""></td>
<td colspan="9" background="images/register_17.gif" width="734" height="285" alt=""><center><form method="post" action="index.php">
<table>
<tr>
<td></td><td><?= $err ?></td>
</tr>
<tr>
<td>ID:</td><td><input type="text" name="accname" value="<?= $_POST["accname"] ?>" maxlength="12"></td>
</tr>
<tr>
<td>Password:</td><td><input type="password" name="accpass1" maxlength="8"></td>
</tr>
<tr>
<td>Repeat Password:</td><td><input type="password" name="accpass2" maxlength="8"></td>
</tr>
<tr><td> </td></tr>
<tr>
<td>Character name:</td><td><input type="text" name="charname" value="<?= $_POST["charname"] ?>" maxlength="12"></td>
</tr>
<tr>
<td>Character class:</td>
<td>
<table>
<tr><td>Knight </td><td><input type="radio" name="charclass" value="0" checked></td></tr>
<tr><td>Mage </td><td><input type="radio" name="charclass" value="1"></td></tr>
<tr><td>Archer </td><td><input type="radio" name="charclass" value="2"></td></tr>
<tr><td><input type="hidden" value="Default stats: Knight 18 16 8 8 10 || Mage 8 10 18 16 8 || Archer 14 10 8 10 18 (+5 to distribute)"></td></tr>
</table>
</td>
</tr>
<tr>
<td>Face:</td>
<td>
<select name="charface">
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
</select>
</td>
</tr>
<tr>
<td>Hair:</td>
<td>
<select name="charhair">
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
</select>
</td>
</tr>
<tr>
<td><input type="submit" name="gogogo" value="Create"></td>
</tr>
</table>
</form></td>
<td rowspan="2">
<img src="images/register_18.gif" width="21" height="342" alt=""></td>
</tr>
<tr>
<td colspan="9">
<img src="images/register_19.gif" width="734" height="57" alt=""></td>
</tr>
<tr>
<td>
<img src="images/spacer.gif" width="45" height="1" alt=""></td>
<td>
<img src="images/spacer.gif" width="88" height="1" alt=""></td>
<td>
<img src="images/spacer.gif" width="185" height="1" alt=""></td>
<td>
<img src="images/spacer.gif" width="4" height="1" alt=""></td>
<td>
<img src="images/spacer.gif" width="23" height="1" alt=""></td>
<td>
<img src="images/spacer.gif" width="135" height="1" alt=""></td>
<td>
<img src="images/spacer.gif" width="23" height="1" alt=""></td>
<td>
<img src="images/spacer.gif" width="4" height="1" alt=""></td>
<td>
<img src="images/spacer.gif" width="181" height="1" alt=""></td>
<td>
<img src="images/spacer.gif" width="91" height="1" alt=""></td>
<td>
<img src="images/spacer.gif" width="21" height="1" alt=""></td>
</tr>
</table>
</body>
</html>
and here is the page that gives the error...
QUOTE
<link rel="stylesheet" href="style.css" type="text/css">
<center>
<?php
$mssql_connect = ("localhost" "Trenton Cayetano" "yellow92");
$mssql_select_db = ("kal_db" $mssql_connect);
$plist = "SELECT * FROM Player ORDER BY {UID}"
$pplist = mssql_query($plist);
echo "<table width='400' height='1'><tr valign='top'>";
echo "<td width='5%'><b>Name</b></td><td width='5%'><b>Class</b></td><td width='5%'><b>Level</b></td></tr><tr valign='top'>";
while($list = mssql_fetch_array($pplist)){
if($list['Class'] == "0"){
$char = "Knight";
}
elseif($list['Class'] == "1"){
$char = "Mage";
}
else
$char = "Archer";
echo "<td width='5%'>";
echo $list[Name];
echo "</td>";
echo "<td width='5%'>";
echo $char;
echo "</td>";
echo "<td width='5%'>";
echo $list[Level];
echo "</td></tr><tr>";
}
echo "</tr></table>";
?>
</center>
Alles anzeigen