|
You last visited: Today at 13:43
Advertisement
Ultimate mode
Discussion on Ultimate mode within the Shaiya Private Server forum part of the Shaiya category.
12/22/2012, 16:04
|
#1
|
elite*gold: 0
Join Date: May 2011
Posts: 26
Received Thanks: 1
|
Ultimate mode
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
|
#2
|
elite*gold: 0
Join Date: Oct 2012
Posts: 104
Received Thanks: 151
|
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
|
#3
|
elite*gold: 0
Join Date: Jun 2011
Posts: 218
Received Thanks: 153
|
|
|
|
12/22/2012, 18:14
|
#4
|
elite*gold: 0
Join Date: May 2011
Posts: 26
Received Thanks: 1
|
Not working for me
I have episode 4.5 server
|
|
|
12/22/2012, 18:18
|
#5
|
elite*gold: 0
Join Date: Apr 2011
Posts: 216
Received Thanks: 127
|
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:
Might wanna use seach engine just like I did to find this for you.
Regards.
|
|
|
12/22/2012, 18:54
|
#6
|
elite*gold: 0
Join Date: May 2011
Posts: 26
Received Thanks: 1
|
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
|
#7
|
elite*gold: 10
Join Date: May 2012
Posts: 1,857
Received Thanks: 2,627
|
it should be inserted into sql
|
|
|
12/22/2012, 19:08
|
#8
|
elite*gold: 0
Join Date: Jun 2011
Posts: 218
Received Thanks: 153
|
эхх ты нубяра санта
|
|
|
12/22/2012, 19:20
|
#9
|
elite*gold: 0
Join Date: May 2011
Posts: 26
Received Thanks: 1
|
omfg
Есть такое. Затупил не по детски
|
|
|
12/22/2012, 23:32
|
#10
|
elite*gold: 150
Join Date: Apr 2010
Posts: 9,739
Received Thanks: 8,977
|
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
|
|
|
|
Similar Threads
|
Automatically allow ultimate mode
12/16/2012 - Shaiya Private Server - 8 Replies
Hello, Im wondering where the location to set ultimate mode unlocked automatically, when you create an account, rather than needing to make HM then relogging. If its in the psgame or DB somewhere I just need to be pointed in the right direction, Although im pretty sure ive looked everywhere in the DB...
Thanks :)
|
Change easy mode to ultimate mode in database
12/08/2012 - Shaiya Private Server - 3 Replies
Hello.
Any1 knows where can i change the easy mode to ultimate mode in database of any Character?
Greetings.
|
gunz The Ultimate God Mode
11/30/2010 - GunZ - 47 Replies
ok here goes this hack is very good for ppl who want to pretend they r god. with the ultimate god mode (u must wear certin items for the ultimate god mode).
Highlights of the hack:
-Renerd x2, Walcom S5 x2, and the Nico r2 ALL HAVE 1,800,000 BULLETS (no blanks) with the normal magizenes.they all also give you +25,000 HP and AP.
-all medpacks and repair kits have 100/100 kits.
-the Canox FG1 and FG2 both have 100/100 granades.
|
[Frage] Hard- und Ultimate-Mode
10/18/2010 - Shaiya - 6 Replies
Hi,
ich und nen kumpel waren auf der suche nach nem neuen free mmorpg und sind dabei auf shaiya gestoßen...
haben dann auch chars im hard mode hochgezogen bis auf lvl 20, aber als wir dann erfahren haben das man mit dem hard-mode nur ein levelcap bis 40 hat (Stimmt das?), und somit das eigentliche max-level 60 nur mit ultimate mode zu erreichen ist aufgehört.
meine fragen nun,
- Kann man mit dem Hard-Mode bis lvl 60 spielen?
- Welche Möglichkeiten gibt es aktuell, um eine...
|
All times are GMT +2. The time now is 13:43.
|
|