Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Website register problem :S

Newbie Spellweaver
Joined
Mar 30, 2007
Messages
18
Reaction score
0
I have a problem with my website, i use the website from Kessss.
When i want to register and i already put in my name and password it gives the folowing error:

Fatal error: Call to undefined function mssql_connect() in C:\wamp\www\myservername\register.php on line 56

i changed localhost to my ip and put in my password in the register.php
but it wont work
thanks for your help.
 
Newbie Spellweaver
Joined
Mar 30, 2007
Messages
18
Reaction score
0
No no sorry i know what u mean but where can i find it? Can i find it by SQLServer 2000? Or is it the ID and pw i filled in with the KalOnline database and login server?
 
Upvote 0
Newbie Spellweaver
Joined
Mar 30, 2007
Messages
18
Reaction score
0
Ok i solved it but now there is another problem:
Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: root in C:\xampp\htdocs\kaal\register.php on line 56

Warning: mssql_select_db(): supplied argument is not a valid MS SQL-Link resource in C:\xampp\htdocs\kaal\register.php on line 57

Warning: mssql_query() [function.mssql-query]: message: Invalid object name 'Login'. (severity 16) in C:\xampp\htdocs\kaal\register.php on line 63

Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampp\htdocs\kaal\register.php on line 63

line 56 i posted above
line 57: $msdb = mssql_select_db("KAL_AUTH", $msconnect);
line 63: $acccreate = mssql_query($query);
 
Upvote 0
Newbie Spellweaver
Joined
Nov 6, 2007
Messages
87
Reaction score
0
why did you call the select_db function as a variable? this way it never selected a db :\ just take off the $msdb.
and can you post the whole code? this way it will e a lot easier for us to help you, and do it between php tags :p
 
Upvote 0
Newbie Spellweaver
Joined
Mar 30, 2007
Messages
18
Reaction score
0
oke this is my code:

PHP:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>KaalOnline</title>
<style type="text/css">
<!--
.Stil1 {color: #FFFFFF}
body,td,th {
	color: #FFFFFF;
}
body {
	background-color: #5c6368;
}
-->
</style>
</head>
<?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 ($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("my_id", "my_pw", "my_pw");
		$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');

		

			//echo $query;
			
	
			$_POST["accname"] = "";
			$_POST["str"] = "";
			$_POST["hlt"] = "";
			$_POST["int"] = "";
			$_POST["wis"] = "";
			$_POST["agi"] = "";												
							
			$err = "<b><font color=\"#00FF00\">Acc created ! If you have any problems, contact us.</font></b>";				
							
		}
		else echo "Somethings Wrong!!  :P";
		mssql_close() or die('failed closing mssql');	

	}
	
}




?>
      
      
  <title></title>
<body>

<form method="post" action="register.php">
  <table>
    <tr>
      <td></td><td><?= $err ?></td>
	  </tr>
    <tr>
      <td><span class="Stil1">ID:</span></td>
      <td><input type="text" name="accname" value=""<?= $_POST["accname"] ?><maxlength="12"></td>
    </tr>
    <tr>
      <td><span class="Stil1">Password:</span></td>
      <td><input type="password" name="accpass1" maxlength="8"></td>		
    </tr>
    <tr>
      <td><span class="Stil1">Repeat Password:</span></td>
      <td><input type="password" name="accpass2" maxlength="8"></td>
    </tr>
    
    <tr><td> </td></tr>
    
    <tr>
      	  </tr>
    <tr>
      					
		      </table>
		  </td>
	  </tr>	
    
    <tr>
      
		    </td>
	  </tr>
    
    <tr>
      <td><input type="submit" name="gogogo" value="Create"></td>
	  </tr>
  </table>
  
</form>
</body>
</html><!-- tab end -->
<body>
</body>
</html>
 
Upvote 0
Live Now, Work Later
Joined
Sep 12, 2006
Messages
153
Reaction score
4
try deatharts registration, its most probably the safest and easiest one to setup:

 
Upvote 0
Newbie Spellweaver
Joined
Mar 30, 2007
Messages
18
Reaction score
0
How do i set this up whith the site from Kassss the one that i have now? And where do i have to fill in my id and password from mysql?
 
Upvote 0
Custom Title Activated
Loyal Member
Joined
Oct 6, 2006
Messages
1,490
Reaction score
3
include it xD

and btw o_O
Code:
[COLOR=#ff8000]// configuration
[/COLOR][COLOR=#0000bb]$config [/COLOR][COLOR=#007700]= array(
    [/COLOR][COLOR=#dd0000]'db_username' [/COLOR][COLOR=#007700]=> [/COLOR][COLOR=#dd0000]'sa'[/COLOR][COLOR=#007700], [/COLOR][COLOR=#ff8000]// database username
    [/COLOR][COLOR=#dd0000]'db_password' [/COLOR][COLOR=#007700]=> [/COLOR][COLOR=#dd0000]''[/COLOR][COLOR=#007700],   [/COLOR][COLOR=#ff8000]// database password
    [/COLOR][COLOR=#dd0000]'db_dsn'      [/COLOR][COLOR=#007700]=> [/COLOR][COLOR=#dd0000]''[/COLOR][COLOR=#007700],   [/COLOR][COLOR=#ff8000]// system DSN to the database[/COLOR]
you need some glasses?
 
Upvote 0
Back
Top