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
Alles anzeigen
quelle PHP - MSSQL Connect (for A Game Server) | DreamInCode.net
PHP-Quellcode
- 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>