Ultimate mode

12/22/2012 16:04 .Santa.#1
Hello everyone, I can not find a topic in which it was written as open ultimate mode without creating hard mode character. Please tell me the link.
12/22/2012 16:08 VolterKnecht#2
Use this Script.


CREATE Proc usp_Read_User_MaxGrow_R

@ServerID tinyint,
@UserUID int

AS

SET NOCOUNT ON

IF NOT EXISTS(SELECT GROW FROM CHARS WHERE ServerID=@ServerID AND UserUID=@UserUID AND GROW <= 3 )
BEGIN
UPDATE UserMaxGrow SET MaxGrow = 3 WHERE ServerID=@ServerID AND UserUID=@UserUID AND Country <= 1
END

IF EXISTS(SELECT GROW FROM CHARS WHERE ServerID=@ServerID AND UserUID=@UserUID AND GROW = 3 AND LEVEL >= 0)
BEGIN
UPDATE UserMaxGrow SET MaxGrow = 3 WHERE ServerID=@ServerID AND UserUID=@UserUID
END

IF EXISTS(SELECT GROW FROM CHARS WHERE ServerID=@ServerID AND UserUID=@UserUID AND GROW = 3 AND LEVEL >= 0)
BEGIN
UPDATE UserMaxGrow SET MaxGrow = 3 WHERE ServerID=@ServerID AND UserUID=@UserUID
END

SELECT Country,MaxGrow FROM UserMaxGrow WHERE ServerID=@ServerID AND UserUID=@UserUID

SET NOCOUNT OFF
GO
12/22/2012 16:09 Murik13#3
[Only registered and activated users can see links. Click Here To Register...]
12/22/2012 18:14 .Santa.#4
Not working for me :(
I have episode 4.5 server
12/22/2012 18:18 STIV123#5
Code:
INSERT INTO [PS_GameData].[dbo].[UserMaxGrow]
 ([ServerID],[UserUID],[Country],[MaxGrow],[Del])
 VALUES(1,(SELECT UserUID FROM [PS_UserData].[dbo].[Users_Master] WHERE UserID = @username),2,3,0)

That should work.


Credits to: Omega

From post: [Only registered and activated users can see links. Click Here To Register...]


Might wanna use seach engine just like I did to find this for you.


Regards.
12/22/2012 18:54 .Santa.#6
I do not know where it should be inserted. I understand that the file processor.php but where? I tried to insert the end of the document like this:
Code:
<?php

$ip = $_SERVER['REMOTE_ADDR'];
$userid = trim($_POST['userid']);
$pass = trim($_POST['pass']);
$repass = trim($_POST['passp']);
$email = trim($_POST['email']);
$cash_point = 0;

// Connection with MSSQL server
$conn=mssql_connect('127.0.0.1','shaiya','shaiya123');
$db = mssql_select_db('PS_UserData',$conn) or die("MSSQL Conection Error!");


$res = mssql_query("SELECT UserID FROM  PS_UserData.dbo.Users_Master WHERE (UserID) = ('".$userid."')");
if (mssql_num_rows($res)) 
	{
	echo "Логин уже существует.";
	}
	else
	{
	if ($pass != $repass)  
		{
		echo 'Пароли не совпадают.';
		}
		else
		{
	
                // Check Last UserUID Number
				$checkuseruid = "SELECT Max(UserUID) AS max FROM PS_UserData.dbo.Users_Master";
				$resultado = mssql_query($checkuseruid);
				$captura = mssql_fetch_array($resultado);
				$UserUID = $captura["max"]+1;
				
				// Insert Start
				$query1 =  mssql_query("INSERT INTO Users_Master (UserUID,UserID,Pw,JoinDate,Admin,AdminLevel,UseQueue,Status,Leave,LeaveDate,UserType,Point,EnPassword,UserIp) VALUES ('".$UserUID."','".$userid."','".$pass."',getdate(),'0','0','0','0','0',getdate(),'1','".$cash_point."','0','".$ip."')");
				if ( $query1 == 1 )
				{
					$query2 = "exec OMG_GameWeb.dbo.sp_CreateOmgGMGameAccount '".$UserUID."','".$userid."','".$pass."','0'";
					$rresult2 = mssql_query($query2) or die("Create GameAccountTBL Error!");
				
					$query3 = mssql_query("INSERT INTO Users_Detail (UserID,UserUID,UserName,PwQuestion,PwAnswer,Email,NewsLetter,Sms,AdultAuth,EmailAuth) VALUES ('".$userid."','".$UserUID."','Real Name','vopros','otvet','".$email."','0','0','0','0')");
					if ( $query3 == 1 )
					{
						$query4 = mssql_query("INSERT INTO Users_Block (UserUID,BlockEndDate) VALUES ('".$UserUID."',getdate())");
						if ( $query4 == 1 )
						{
							echo "Account created!.<br /><br /><b>Login:</b> $userid<br><b>Pass:</b> $pass";
						}
						else
						{
							echo "Create Users_Block Error!";
						}
					}
					else
					{
						echo "Create Users_Detail Error!";
					}
				}
				else
				{
					echo "Create Users_Master Error!";
					$query5 =  mssql_query("INSERT INTO PS_GameData.dbo.UserMaxGrow (ServerID,UserUID,Country,MaxGrow,Del) VALUES (1,(SELECT UserUID FROM PS_UserData.dbo.Users_Master] WHERE UserID = @username),2,3,0)");
				}
		}
	}
	
?>
But nothing happened: (
12/22/2012 19:05 TeddyBear94#7
it should be inserted into sql :facepalm:
12/22/2012 19:08 Murik13#8
эхх ты нубяра санта
12/22/2012 19:20 .Santa.#9
omfg :facepalm:
Есть такое. Затупил не по детски :)
12/22/2012 23:32 JohnHeatz#10
Well, your question has been answered, but actually there is a thread in which this is explained, please use the FAQs sticky thread next time ;)