![[Script] PHP Mssql Stats Laranja Perfeitos](https://www.elitepvpers.com/forum/iconimages/shaiya-pserver-guides-releases/script-php-mssql-stats-laranja-perfeitos_ltr.gif){kind=small}
The Very Time I tried this script and I decided to write this
Item a receber o Stats Laranja Perfeitos
Item Stats receiving the Perfect Orange
Pagina Para Escolher o Stats Laranja Perfeitos
Stats Page To Choose the Perfect Orange
Resultado Do Stats Laranja Perfeitos
Perfect Result Of Orange Stats
Resultado Do Item
Results Of Item
Em Armas Não Recebe HP SP MP
Not in Arms Receives HP SP MP
Para que suas armas nao receba HP SP MP vc deve mudar a coluna "Server" em Item.SData Para "3"
For their weapons not receive HP SP MP you should change the column "Server" in Item.SData For "3"
Para as Roupas receberem Todos Stats Você deve Editar a Coluna "Server" para "4" de todas as roupas do Item.SData
Clothing For All Stats You should receive Edit Column "Server" to "4" all the clothes Item.SData
Segue o Codigo Abaixo Das Edições:
Below follows the Code Of Editions:
PHP Code:
<?php
//Script modificado para adicionar Stats Laranja Perfeitos nos itens equipaveis os creditos
require_once('recaptchalib.config.php');
require_once('recaptchalib.php');
require_once('db.config.php');
$user_ip = $_SERVER['REMOTE_ADDR'];
$username = isset($_POST['username']) ? mssql_escape_string(trim($_POST['username'])) : '';
$password = isset($_POST['password']) ? mssql_escape_string(trim($_POST['password'])) : '';
$password2 = isset($_POST['password2']) ? mssql_escape_string(trim($_POST['password2'])) : '';
$itemIDV= 38110; // ID Do item que deseja usar Como Pagamento . (Crie um Item A Sua Escolha e adicione o ID dele Aqui).
require_once('db.php');
$resx = mssql_query("SELECT * FROM PS_UserData.dbo.Users_Master WHERE UserID = '$username'");
$detailx = mssql_fetch_array($resx);
$resx2 = mssql_query("SELECT * FROM PS_GameData.dbo.UserStoredItems WHERE UserUID= (SELECT [UserUID] FROM PS_UserData.dbo.Users_Master WHERE UserID='$username') AND (Slot = '0')");
$detailx2 = mssql_fetch_array($resx2);
$resx3 = mssql_query("SELECT * FROM PS_GameDefs.dbo.Items WHERE (ItemID = '$detailx2[ItemID]')");
$detailx3 = mssql_fetch_array($resx3);
// Remove the @ symbol here to see what the SQL error message is when running the above query in $sql.
$level2 = "$detailx3[ReqWis]";
switch( $level2 )// este switch é para adicionar modificar o bonus stats dos já existente nos itens.
{
case 1:$bb = '01';break;
case 2:$bb = '02';break;
case 3:$bb = '03';break;
case 4:$bb = '04';break;
case 5:$bb = '05';break;
case 6:$bb = '06';break;
case 7:$bb = '07';break;
case 8:$bb = '08';break;
case 9:$bb = '09';break;
case 11:$bb = '11';break;
case 12:$bb = '12';break;
case 13:$bb = '13';break;
case 14:$bb = '14';break;
case 15:$bb = '15';break;
case 16:$bb = '16';break;
case 17:$bb = '17';break;
case 18:$bb = '18';break;
case 19:$bb = '19';break;
case 20:$bb = '20';break;
case 21:$bb = '21';break;
case 22:$bb = '22';break;
case 23:$bb = '23';break;
case 24:$bb = '24';break;
case 25:$bb = '25';break;
case 26:$bb = '26';break;
case 27:$bb = '27';break;
case 28:$bb = '28';break;
case 29:$bb = '29';break;
case 30:$bb = '30';break;
case 31:$bb = '31';break;
case 32:$bb = '32';break;
case 33:$bb = '33';break;
case 34:$bb = '34';break;
case 35:$bb = '35';break;
case 36:$bb = '36';break;
case 37:$bb = '37';break;
case 38:$bb = '38';break;
case 39:$bb = '39';break;
case 40:$bb = '40';break;
case 41:$bb = '41';break;
case 42:$bb = '42';break;
case 43:$bb = '43';break;
case 44:$bb = '44';break;
case 45:$bb = '45';break;
case 46:$bb = '46';break;
case 47:$bb = '47';break;
case 48:$bb = '48';break;
case 49:$bb = '49';break;
case 50:$bb = '50';break;
}
$stat1 = $_POST['stat1'];
$Str ='00';$Dex ='00';$Rec ='00';$Wis ='00';$Int ='00';$Luc ='00';$HP ='00';$MP ='00';$SP ='00';$En ='00';
switch( $stat1 )
{
case Str:$Str = ''.$bb.'';break;
case Dex:$Dex = ''.$bb.'';break;
case Rec:$Rec = ''.$bb.'';break;
case Wis:$Wis = ''.$bb.'';break;
case Int:$Int = ''.$bb.'';break;
case Luc:$Luc = ''.$bb.'';break;
}
$stat2 = $_POST['stat2'];
switch( $stat2 )
{
case Str:$Str = ''.$bb.'';break;
case Dex:$Dex = ''.$bb.'';break;
case Rec:$Rec = ''.$bb.'';break;
case Wis:$Wis = ''.$bb.'';break;
case Int:$Int = ''.$bb.'';break;
case Luc:$Luc = ''.$bb.'';break;
}
$stat3 = $_POST['stat3'];
switch( $stat3 )
{
case Str:$Str = ''.$bb.'';break;
case Dex:$Dex = ''.$bb.'';break;
case Rec:$Rec = ''.$bb.'';break;
case Wis:$Wis = ''.$bb.'';break;
case Int:$Int = ''.$bb.'';break;
case Luc:$Luc = ''.$bb.'';break;
}
$stat4 = $_POST['stat4'];
switch( $stat4 )
{
case HP:$HP = ''.$bb.'';break;
case MP:$MP = ''.$bb.'';break;
case SP:$SP = ''.$bb.'';break;
}
$errors = array();
$success = false;
if(isset($_POST) && !empty($_POST)){
require_once('db.php');
// Validar Nome de Usuario.
$useruid = mssql_query("SELECT UserID,Pw FROM PS_UserData.dbo.Users_Master WHERE UserID = '{$username}'");
if(empty($username)){
$errors[] = 'Please provide a user name.';
}else if(strlen($username) < 3 || strlen($username) > 16){
$errors[] = 'User name must be between 3 and 16 characters in length.';
}else if(ctype_alnum($username) === false){
$errors[] = 'User name must consist of numbers and letters only.';
}else if (mssql_num_rows($useruid) == 0){
$errors[] = 'usuario nao existe.';
}
// Validar Senha do Usuario.
$useruid1 = mssql_query("SELECT UserID,Pw FROM PS_UserData.dbo.Users_Master WHERE UserID = '{$username}' and PW = '{$password}'");
if(empty($password)){
$errors[] = 'Please provide a password.';
}else if(strlen($password) < 3 || strlen($password) > 16){
$errors[] = 'Password must be between 3 and 16 characters in length.';
}else if (mssql_num_rows($useruid1) == 0){
$errors[] = 'Senha incorreta.';
}
// Evitar Status repetidos.
if($stat1 == $stat2){$errors[] = 'Escolha um stat diferente.'; }
if($stat1 == $stat3){$errors[] = 'Escolha um stat diferente.'; }
if($stat2 == $stat3){$errors[] = 'Escolha um stat diferente.'; }
// Checar Se Usuario esta online.
$result = @mssql_query("SELECT * FROM [PS_GameData].[dbo].[Chars] c INNER JOIN [PS_UserData].[dbo].[Users_Master] u ON c.UserID='{$username}' WHERE c.LoginStatus=1");
if(@mssql_num_rows($result)){
$errors[] = '<strong>Você deve fechar o jogo para continuar....</strong>';
}
//Aviso se o item esta presente no slot '1' do Deposito.
$res02 = mssql_query("SELECT ItemID FROM PS_GameData.dbo.UserStoredItems WHERE UserUID= (SELECT [UserUID] FROM PS_UserData.dbo.Users_Master WHERE UserID='$username') AND (Slot = '1') AND (ItemID = '{$itemIDV}')");
$resz2 = mssql_query("SELECT * FROM PS_GameData.dbo.UserStoredItems WHERE UserUID= (SELECT [UserUID] FROM PS_UserData.dbo.Users_Master WHERE UserID='$username') AND (Slot = '1')");
$detailz2 = mssql_fetch_array($resz2);
$resz3 = mssql_query("SELECT * FROM PS_GameDefs.dbo.Items WHERE (ItemID = '$detailz2[ItemID]')");
$detailz3 = mssql_fetch_array($resz3);
$resz4 = mssql_query("SELECT * FROM PS_GameDefs.dbo.Items WHERE (ItemID = '{$itemIDV}')");
$detailz4 = mssql_fetch_array($resz4);
$ItemName4= "$detailz4[ItemName]";
$ItemName= "$detailz3[ItemName]";
$count= "$detailz2[Count]";
if(empty($itemIDV)){
$errors[] = 'Please provide a password.';
}else if (mssql_num_rows($res02) == 0){
$errors[] = 'O Item <u>'.$ItemName.'</u> Não é Valido Para Continuar... <br /> Adicione o Item: <u>'.$ItemName4.'</u> No Segundo Slot do Deposito .';
}
// Validate reCAPTCHA. This is to prevent someone botting account creation.
$response = recaptcha_check_answer($recaptcha_private_key,$_SERVER['REMOTE_ADDR'],$_POST['recaptcha_challenge_field'],$_POST['recaptcha_response_field']);
if(!$response->is_valid){
if($response->error == 'incorrect-captcha-sol'){
$errors['recaptcha'] = 'Letras do reCAPTCHA Estao incorretos';
}else{
$errors['recaptcha'] = $response->error;
}
}
//Leitura e Gravação na DB.
if(count($errors) == 0){
$res22 = mssql_query("SELECT * FROM PS_GameData.dbo.UserStoredItems WHERE UserUID= (SELECT [UserUID] FROM PS_UserData.dbo.Users_Master WHERE UserID='$username') AND (Slot = '0')");
$detail22 = mssql_fetch_array($res22);
$res33 = mssql_query("SELECT * FROM PS_GameDefs.dbo.Items WHERE (ItemID = '$detail22[ItemID]')");
$detail33 = mssql_fetch_array($res33);
// Aqui Dará o numero do Server Do Item No Caso o Server 4 Receberá HP MP SP e o Server 3 Não Receberá HP MP SP ( Modifique seu Item.SData )
$zr=0;
switch( $zr )
{
case 0:$ru = "00";break;
}
$sv= "$detail33[Server]";
switch( $sv )
{
case 3:$ok = "$Str$Dex$Rec$Wis$Int$Luc$ru$ru$ru$ru";break;
case 4:$ok = "$Str$Dex$Rec$Wis$Int$Luc$HP$MP$SP$ru";break;
}
$res = mssql_query("SELECT * FROM PS_UserData.dbo.Users_Master WHERE UserID = '$username'");
$detail = mssql_fetch_array($res);
$del = 'DELETE FROM PS_GameData.dbo.UserStoredItems WHERE
CharID in (SELECT CharID FROM PS_GameData.dbo.Chars WHERE UserUID=' . $row1['UserUID'] . ')';
$res2 = mssql_query("SELECT * FROM PS_GameData.dbo.UserStoredItems WHERE UserUID= (SELECT [UserUID] FROM PS_UserData.dbo.Users_Master WHERE UserID='$username') AND (Slot = '0')");
$detail2 = mssql_fetch_array($res2);
$del3= $count-1; // Aqui Remove a Quantia De Item Do Slot'1'. No caso removerá 1 item do Monte.
$res3 = mssql_query("SELECT * FROM PS_GameDefs.dbo.Items WHERE (ItemID = '$detail2[ItemID]')");
$detail3 = mssql_fetch_array($res3);
$del = "DELETE FROM PS_GameData.dbo.UserStoredItems WHERE ItemID = '$itemIDV' AND Count='1' AND UserUID=(SELECT [UserUID] FROM PS_UserData.dbo.Users_Master WHERE UserID='$username') AND (Slot = '1') ";
$sql2 = "UPDATE PS_GameData.dbo.UserStoredItems SET Count ='$del3' WHERE UserUID= (SELECT [UserUID] FROM PS_UserData.dbo.Users_Master WHERE UserID='$username') AND (Slot = '1')";
$sql = "UPDATE PS_GameData.dbo.UserStoredItems SET Craftname = '$ok' WHERE UserUID= (SELECT [UserUID] FROM PS_UserData.dbo.Users_Master WHERE UserID='$username') AND (Slot = '0')";
// Remove the @ symbol here to see what the SQL error message is when running the above query in $sql.
if($result3 = @mssql_query($del)){$success = "Excluido";
}else{ $errors[] = 'Falha ao limpar!'; }
if($result2 = @mssql_query($sql2)){ $success = "Limpo";
}else{ $errors[] = 'Falha ao limpar!'; }
if($result = @mssql_query($sql)){ $success = "O Item<strong> '{$detail3[ItemName]}' </strong>Foi Modificado com sucesso Nos Seguintes Stats:<br />Str:$Str<br />Dex:$Dex<br />Rec:$Rec<br />Wis:$Wis<br />Int:$Int<br />Luc:$Luc<br />HP:$HP<br />MP:$MP<br />SP:$SP<br />";
}else{
// This means the insert statement is probably not valid for your database. Fix the query or fix your database, your choice ;)
$errors[] = 'Falha ao criar sua conta, tente novamente!';
}
}
}
// Determine which view to show.
if($success === false){
require_once('SLP.view.php');
}else{
require_once('success.view.php');
}
?>
Sorry For Not Speaking English^^
Se Desejar ver uma demonstração veja em meu site:
If You want to see a demonstration on my site:
![[GM]SkyLine.™'s Avatar](https://www.elitepvpers.com/forum/customavatars/avatar5006420_8.gif){kind=avatar}
Thanks 
