[Release]Web Register

Quote:

Originally Posted by Schwap copy the php.ini into this folder: C:\xampp\php extract the files from sandolkakos into this folder: C:\xampp\htdocs\ u reach the registration in ur webbrowser following this link: Code: http://localhost/ the attached txt is my ini, just change txt to ini

Quote:

Originally Posted by ProfNerwosol First thanks go to sandolkakos. Without his post I'd never have done it. Too lazy ;p I used sandolkakos php script and modified it a bit. Now it call stored procedure in PS_UserData which inserts all the values. It's easier this way and less error prone. Two files index.php & processor.php are the ones to use. Extra txt file contains procedure. I modified few little things. Just open the procedure (the file has same name), copy paste from the text file and Execute. (the procedure I am talking about is stored in PS_UserData, edit it). Make sure your php has mssql support turned on. If you are running it on your PC.

Quote:

Originally Posted by remnikali i have that reg but its not working to me <?php $dbhost = '85.25.149.186'; $dpuser = 'Shaiya'; $dbpass = 'Shaiya123'; $ip = $_SERVER['REMOTE_ADDR']; $login = trim($_POST['login']); $pass = trim($_POST['pass']); $repass = trim($_POST['passp']); $pwq = ''; $email = ''; ye always a problem Warning: mssql_select_db() [function.mssql-select-db]: message: The server principal "INDIA160\IUSR_remnikalija" is not able to access the database "PS_UserData" under the current security context. (severity 14) in C:\inetpub\vhosts\india160.server4you.net\httpdocs \processor.php on line 21 Warning: mssql_select_db() [function.mssql-select-db]: Unable to select database: PS_UserData in C:\inetpub\vhosts\india160.server4you.net\httpdocs \processor.php on line 21 Connection to database could not be established!

Quote:

Originally Posted by ProfNerwosol If you are running the script on your computer it is better to use computer name. Change $dbhost to: $dbhost = $_ENV["USER_DOMAIN"]; MSSQL server name is pretty much the name of your computer.

Quote:

Originally Posted by Apocalypsist I'm getting an error in SQL. Does anyone know how to fix this error, I have prof.'s files the ep4 ones and it says this when i run the query: Msg 208, Level 16, State 6, Procedure sp_CreateOmgGMGameAccount, Line 27 Invalid object name 'dbo.sp_CreateOmgGMGameAccount'. Apparently it doesn't exist, so anyone know whats up?

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go


/****** Object:  Stored Procedure dbo.sp_CreateOmgGMGameAccount    Script Date: 2008-6-7 18:29:10 ******/
ALTER   PROCEDURE [dbo].[sp_CreateOmgGMGameAccount] 
	@UserUID int,
	@GameAccount varchar(18),
	@OneTimePassword varchar(32),
	@DelCharPwd varchar(50)

AS

Declare 
	@myRowCounts int

BEGIN
	--SET NOCOUNT OFF;

	IF NOT EXISTS(Select * From GameAccountTBL with (nolock) Where GameAccount=@GameAccount )	
		BEGIN
			Insert Into GameAccountTBL (UserUID,GameAccount,OneTimePassword,OTPExpireDate,DelCharPwd)
				Values (@UserUID,@GameAccount,@OneTimePassword,'2050/1/1',@DelCharPwd)

			SET @myRowCounts = @@ROWCOUNT;

			SET @OneTimePassword = Right(@OneTimePassword + 'gyyg' ,18);
			
			Return @myRowCounts	
		END


END

Quote:

Originally Posted by ShaiyaUnited sandolkakos Need u help .. can u pm me ur mail =)