rilee16
-
Posts
2 -
Joined
-
Last visited
Never
Posts posted by rilee16
-
-
Hello i'm here to ask some help about a project game , here is a reborn system.
But the problem is i can't use MSSQL script to do this , i need to convert into ODBC. I hope i can get some help here..
Here is the sql script :
<?phpif (isset($_POST['submitchange'])) {
$user = $_SESSION['username'];
$CharName = $_POST['charname'];
$mssql->dbClose();
$mssql->dbOpen($conf->accountDbName);
$TB_User = $mssql->dbQuery("select * FROM TB_User where StrUserID = '$user'");
while($row = sqlsrv_fetch_array($TB_User, SQLSRV_FETCH_ASSOC)) {
$JID = $row['JID'];
}
$mssql->dbClose();
$mssql->dbOpen($conf->shardDbName);
$_Char = $mssql->dbQuery("select * FROM _Char where Charname16 = '$CharName'");
while($row = sqlsrv_fetch_array($_Char, SQLSRV_FETCH_ASSOC)) {
$CharID = $row['CharID'];
$Strength = $row['Strength'];
$Intellect = $row['Intellect'];
$Reborns = $row['Reborns'];
$CurLevel = $row['CurLevel'];
}
$_User = $mssql->dbQuery("SELECT COUNT(*) FROM _User WHERE UserJID = '$JID' and CharID = '$CharID'");
if( sqlsrv_fetch( $_User ) === false) {
die( print_r( sqlsrv_errors(), true));
}
$_User_Row = sqlsrv_get_field( $_User, 0);
if ($_User_Row = 1) {
if ($Reborns == 0 and $CurLevel == 120)
{
$_0 = $mssql->dbQuery("UPDATE _Char set CurLevel = 1 , MaxLevel = 1 , Strength = 30 , Intellect = 30 , RemainSkillPoint = 0 , ExpOffset = 0,RemainStatPoint = 0, Reborns = 1 WHERE CharName16 = '$CharName'");
$_0_1 = $mssql->dbQuery("DELETE FROM _CharSkill WHERE CharID = '$CharID'");
$_0_2 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 1, 1)");
$_0_3 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 2, 1)");
$_0_4 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 40, 1)");
$_0_5 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 70, 1)");
$_0_6 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 8419, 1)");
$_0_7 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 8420, 1)");
$_0_8 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 8421, 1)");
$_0_9 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 9354, 1)");
$_0_10 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 9355, 1)");
$_0_11 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 9944, 1)");
$_0_12 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 10625, 1)");
$_0_13 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 11162, 1)");
$_0_14 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 11526, 1)");
$_0_15 = $mssql->dbQuery("UPDATE _CharSkillmMstery set Level = 0 WHERE CharID = '$CharID'");
}
elseif ($Reborns == 1 and $CurLevel == 120)
{
$_1 = $mssql->dbQuery("UPDATE _Char set CurLevel = 1 , MaxLevel = 1 , Strength = 40 , Intellect = 40 , RemainSkillPoint = 0 , Reborns = 2 , ExpOffset = 0 , RemainStatPoint = 0 WHERE CharName16 = '$CharName'");
$_1_1 = $mssql->dbQuery("DELETE FROM _CharSkill WHERE CharID = '$CharID'");
$_1_2 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 1, 1)");
$_1_3 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 2, 1)");
$_1_4 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 40, 1)");
$_1_5 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 70, 1)");
$_1_6 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 8419, 1)");
$_1_7 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 8420, 1)");
$_1_8 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 8421, 1)");
$_1_9 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 9354, 1)");
$_1_10 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 9355, 1)");
$_1_11 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 9944, 1)");
$_1_12 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 10625, 1)");
$_1_13 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 11162, 1)");
$_1_14 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 11526, 1)");
$_1_15 = $mssql->dbQuery("UPDATE _CharSkillmastery set Level = 0 WHERE CharID = '$CharID'");
}
elseif ($Reborns == 2 and $CurLevel == 120)
{
$_2 = $mssql->dbQuery("UPDATE _Char set CurLevel = 1 , MaxLevel = 1 , Strength = 50 , Intellect = 50 , RemainSkillPoint = 0 , Reborns = 3 , ExpOffset = 0 , RemainStatPoint = 0 WHERE CharName16 = '$CharName'");
$_2_1 = $mssql->dbQuery("DELETE FROM _CharSkill WHERE CharID = '$CharID'");
$_2_2 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 1, 1)");
$_2_3 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 2, 1)");
$_2_4 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 40, 1)");
$_2_5 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 70, 1)");
$_2_6 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 8419, 1)");
$_2_7 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 8420, 1)");
$_2_8 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 8421, 1)");
$_2_9 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 9354, 1)");
$_2_10 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 9355, 1)");
$_2_11 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 9944, 1)");
$_2_12 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 10625, 1)");
$_2_13 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 11162, 1)");
$_2_14 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 11526, 1)");
$_2_15 = $mssql->dbQuery("UPDATE _CharSkillmastery set Level = 0 WHERE CharID = '$CharID'");
}
elseif ($Reborns == 3 and $CurLevel == 120)
{
$_3 = $mssql->dbQuery("UPDATE _Char set CurLevel = 1 , MaxLevel = 1 , Strength = 60 , Intellect = 60 , RemainSkillPoint = 0 , Reborns = 4 , ExpOffset = 0 , RemainStatPoint = 0 WHERE CharName16 = '$CharName'");
$_3_1 = $mssql->dbQuery("DELETE FROM _CharSkill WHERE CharID = '$CharID'");
$_3_2 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 1, 1)");
$_3_3 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 2, 1)");
$_3_4 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 40, 1)");
$_3_5 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 70, 1)");
$_3_6 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 8419, 1)");
$_3_7 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 8420, 1)");
$_3_8 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 8421, 1)");
$_3_9 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 9354, 1)");
$_3_10 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 9355, 1)");
$_3_11 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 9944, 1)");
$_3_12 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 10625, 1)");
$_3_13 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 11162, 1)");
$_3_14 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 11526, 1)");
$_3_15 = $mssql->dbQuery("UPDATE _CharSkillmastery set Level = 0 WHERE CharID = '$CharID'");
}
elseif ($Reborns == 4 and $CurLevel == 120)
{
$_4 = $mssql->dbQuery("UPDATE _Char set CurLevel = 1 , MaxLevel = 1 , Strength = 70 , Intellect = 70 , RemainSkillPoint = 0 , Reborns = 5 , ExpOffset = 0 , RemainStatPoint = 0 WHERE CharName16 = '$CharName'");
$_4_1 = $mssql->dbQuery("DELETE FROM _CharSkill WHERE CharID = '$CharID'");
$_4_2 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 1, 1)");
$_4_3 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 2, 1)");
$_4_4 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 40, 1)");
$_4_5 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 70, 1)");
$_4_6 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 8419, 1)");
$_4_7 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 8420, 1)");
$_4_8 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 8421, 1)");
$_4_9 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 9354, 1)");
$_4_10 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 9355, 1)");
$_4_11 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 9944, 1)");
$_4_12 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 10625, 1)");
$_4_13 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 11162, 1)");
$_4_14 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 11526, 1)");
$_4_15 = $mssql->dbQuery("UPDATE _CharSkillmastery set Level = 0 WHERE CharID = '$CharID'");
}
elseif ($Reborns == 5 and $CurLevel == 120)
{
$_5 = $mssql->dbQuery("UPDATE _Char set CurLevel = 1 , MaxLevel = 1 , Strength = 80 , Intellect = 80 , RemainSkillPoint = 0 , Reborns = 6 , ExpOffset = 0 , RemainStatPoint = 0 WHERE CharName16 = '$CharName'");
$_5_1 = $mssql->dbQuery("DELETE FROM _CharSkill WHERE CharID = '$CharID'");
$_5_2 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 1, 1)");
$_5_3 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 2, 1)");
$_5_4 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 40, 1)");
$_5_5 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 70, 1)");
$_5_6 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 8419, 1)");
$_5_7 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 8420, 1)");
$_5_8 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 8421, 1)");
$_5_9 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 9354, 1)");
$_5_10 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 9355, 1)");
$_5_11 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 9944, 1)");
$_5_12 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 10625, 1)");
$_5_13 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 11162, 1)");
$_5_14 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 11526, 1)");
$_5_15 = $mssql->dbQuery("UPDATE _CharSkillmastery set Level = 0 WHERE CharID = '$CharID'");
}
elseif ($Reborns == 6 and $CurLevel == 120)
{
$_6 = $mssql->dbQuery("UPDATE _Char set CurLevel = 1 , MaxLevel = 1 , Strength = 90 , Intellect = 90 , RemainSkillPoint = 0 , Reborns = 7 , ExpOffset = 0 , RemainStatPoint = 0 WHERE CharName16 = '$CharName'");
$_6_1 = $mssql->dbQuery("DELETE FROM _CharSkill WHERE CharID = '$CharID'");
$_6_2 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 1, 1)");
$_6_3 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 2, 1)");
$_6_4 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 40, 1)");
$_6_5 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 70, 1)");
$_6_6 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 8419, 1)");
$_6_7 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 8420, 1)");
$_6_8 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 8421, 1)");
$_6_9 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 9354, 1)");
$_6_10 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 9355, 1)");
$_6_11 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 9944, 1)");
$_6_12 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 10625, 1)");
$_6_13 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 11162, 1)");
$_6_14 = $mssql->dbQuery("INSERT INTO _CharSkill (CharID, SkillID, Enable) VALUES ('$CharID', 11526, 1)");
$_6_15 = $mssql->dbQuery("UPDATE _CharSkillmastery set Level = 0 WHERE CharID = '$CharID'");
}
elseif($Reborns == 7)
{
echo "Du hast bereits 7 Reborns ! ";
}
if ( $CurLevel !== 120)
{
echo 'Du bist nicht level 120 ! ';
}
}else{
echo "Das ist nicht dein Character!";
}
} else {
echo '<div class="page-body newsblock">';
echo '<div class="news-title">';
echo 'Reborn ur Char:';
echo '</div>';
echo '<div class="news-content">';
echo '<form method="post">';
echo 'Charactername:<br />';
echo '<input onfocus="clearText(this);" style="background: rgba(0,0,0,0.5);width:220px;border-radius: 6px 6px 6px 6px;" type="text" maxlength="16" name="charname" value="charactername" /><br />';
echo '<br />';
echo '<input style="height:32px;vertical-align:middle;" class="button" type="submit" value="Submit" name="submitchange" />';
echo '</form>';
echo '</div>';
echo '</div>';
}
?>
<?phpclass mssql {
var $config = "config.inc.php";
var $sqlLink;
var $sqlQuery;
var $rowCount;
var $arr;
function dbOpen($dbName) {
if (!$this->sqlLink) {
include_once("$this->config");
global $mssql_server;
$db = array("Database"=>"$dbName");
$this->mssql_server = $mssql_server;
$this->sqlLink = sqlsrv_connect($mssql_server, $db);
if (!$this->sqlLink) {
echo "Error: Connection to the database couldn't be established. <br />";
}
return;
} else {
exit;
}
}
function dbClose() {
sqlsrv_close($this->sqlLink);
}
function dbQuery($string) {
$this->sqlQuery = sqlsrv_query($this->sqlLink, $string);
if(!$this->sqlQuery){
echo "Error: Query execution failed. <br />";
die( print_r( sqlsrv_errors(), true));
}
return $this->sqlQuery;
}
}
?>
<?phpinclude("mssql.class.php");
$mssql_server = "\SQLEXPRESS";
class Config {
var $shardDbName = "db"; //shard database name
var $accountDbName = "db"; // account database name
Need help to convert SQL to ODBC.
in Microsoft SQL - MSSQL
Posted
Question is : Someone can convert this script to ODBC ?