Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Dekaron > Dekaron Private Server
You last visited: Today at 13:03

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



Any experts help me fix this MSQL2008

Discussion on Any experts help me fix this MSQL2008 within the Dekaron Private Server forum part of the Dekaron category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Mar 2007
Posts: 149
Received Thanks: 10
Any experts help me fix this MSQL2008

This is error. i had old Register Page script try to connect on (Baica123 1clickSV) msql 2008 keep saying issued


$con = mssql_connect($mssql['host'],$mssql['user'],$mssql['pass']);


Can you share me REG page for msql2008 or how to fix it anything help and thank you...
NeedHelpAti is offline  
Old 05/12/2020, 00:03   #2
 
GekkoDE's Avatar
 
elite*gold: 87
Join Date: Aug 2012
Posts: 130
Received Thanks: 16
$con = mssql_connect('ip',user','pass');
GekkoDE is offline  
Old 05/12/2020, 02:04   #3
 
elite*gold: 0
Join Date: Mar 2007
Posts: 149
Received Thanks: 10
Quote:
Originally Posted by GekkoDE View Post
$con = mssql_connect('ip',user','pass');

hmm dun get it BUT i tried like this
$con = mssql_connect('127.0.0.1'],$mssql['sa'],$mssql['123456');
Parse error: syntax error, unexpected ']' in C:\xampp\htdocs\registerNO.php on line 80

and i tried with not edit got this error
Fatal error: Call to undefined function mssql_connect() in C:\xampp\htdocs\register.php on line 84

This is Original Scrip
Quote:
<?php
$IP = $_SERVER["REMOTE_ADDR"];
$server = "Dont edit the IP";

$mssql = array(
'host' => "127.0.0.1",
'user' => "sa",
'pass' => "1234"
);

function anti_injection($sql) {
$sql = preg_replace(sql_regcase("/(from|select|insert|delete|where|drop table|show tables|#|\*|--|\\\\)/"),"",$sql);
$sql = trim($sql);
$sql = strip_tags($sql);
$sql = addslashes($sql);
return $sql;
}


echo "<center>";

if($_POST['activ'] == '1') {

$accname = anti_injection($_POST['accname']);
$accmail = anti_injection($_POST['accmail']);

$accpass1 = anti_injection($_POST['accpass1']);
$accpass2 = anti_injection($_POST['accpass2']);
$_SERVER = anti_injection($_SERVER['REMOTE_ADDR']);

$con = mssql_connect($mssql['host'],$mssql['user'],$mssql['pass']);

$result1 = mssql_query("SELECT * FROM account.dbo.USER_PROFILE WHERE user_id = '".$accname."'",$con);
$result2 = mssql_query("SELECT * FROM account.dbo.Tbl_user WHERE user_id = '".$accname."'",$con);
$result3 = mssql_query("SELECT * FROM account.dbo.Tbl_user WHERE user_mail = '".$accmail."'",$con);

$row1 = mssql_num_rows($result1);
$row2 = mssql_num_rows($result2);
$row3 = mssql_num_rows($result3);

$dk_time=strftime("%y%m%d%H%M%S");
list($usec1, $sec1) = explode(" ",microtime());
$dk_user_no=$dk_time.substr($usec1,2,2);


if(empty($accname) || empty($accpass1) || empty($accpass2)|| empty($accname) || empty($accmail)) {
echo "<br>You didnt fill in all fields&nbsp;<a href='javascript:history.back()'>Go Back</a>";
} elseif($row1 > '0' || $row2 > '0') {
echo "<br>This Account name already exists.&nbsp;<a href='javascript:history.back()'>Go Back</a>";
} elseif($row3 > '0') {
echo "<br>This E-Mail is already in use.&nbsp;<a href='javascript:history.back()'>Go Back</a>";
} elseif($accpass1 != $accpass2) {
echo "<br>The passwords did not match&nbsp;<a href='javascript:history.back()'>Go Back</a>";
} elseif($accpass1 == $accname) {
echo "<br>Account name and password are the same.&nbsp;<a href='javascript:history.back()'>Go Back</a>";
} elseif(!preg_match("/^[0-9a-zA-Z]{3,15}$/i", $accname)) {
echo "<br>Enter a account name only with 0-9 , a-z and A-Z.&nbsp;<a href='javascript:history.back()'>Go Back</a>";
} elseif(!preg_match("/^[0-9a-zA-Z]{3,15}$/i", $accpass1)) {
echo "<br>Enter a password only with 0-9 , a-z and A-Z.&nbsp;<a href='javascript:history.back()'>Go Back</a>";
} elseif(!preg_match("/^\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*$/i",$accmail)) {
echo "<br>Your e-Mail is not correct.&nbsp;<a href='javascript:history.back()'>Go Back</a>";
} elseif(strlen($accname) < 3 || strlen($accname) > 15) {
echo "<br>The Accountname must at least 3 indications long and may maximally 15 indications long.&nbsp;<a href='javascript:history.back()'>Go Back</a>";
} elseif(strlen($accpass1) < 3 || strlen($accpass1) > 15) {
echo "<br>The Password must at least 3 indications long and may maximally 15 indications long.&nbsp;<a href='javascript:history.back()'>Go Back</a>";
} else {

$accpass = md5($accpass1);

mssql_query("INSERT INTO account.dbo.USER_PROFILE (user_no,user_id,user_pwd,resident_no,user_type,lo gin_flag,login_tag,ipt_time,login_time,logout_time ,user_ip_addr,server_id) VALUES ('$dk_user_no','".$accname."','".$accpass."','8010 11000000','1','0','Y','".$date."',null,null,null,' 000')",$con);
mssql_query("INSERT INTO account.dbo.Tbl_user (user_no,user_id,user_pwd,user_mail,user_answer,us er_question,IP) VALUES ('$dk_user_no','".$accname."','".$accpass1."','".$ accmail."','0','0','$IP')",$con);

echo "<center><b>The Account Was Successfully Created. Have Fun !</font></b></center><br><br>";
echo "<center>Here is your login info again:</font></center>";
echo "<center>Your account name is: </font><b>".$accname."</b></center>";
echo "<center>Your password is: </font><b>".$accpass1."</b></center>";
echo "<center>Your Email is: </font><b>".$accmail."</b></center>";
echo "<center>Your IP is: </font><b>".$IP."</b></center>";
echo "<br>Thank You for Joined Twisted Dekaron<span><br>Do Not Lose This Info, You May Write Is Down And Hide It</span></font>";
}

} else {

$con = mssql_connect($mssql['host'],$mssql['user'],$mssql['pass']);
$result1 = mssql_query("SELECT * FROM account.dbo.USER_PROFILE",$con);
$row1 = mssql_num_rows($result1);

echo "<div class='accountsteps'><center>We Have ".$row1." Registed Accounts On Our Server<br>Join Us</font></center><br></div>";
echo "<form action='".$_SEVER['PHP_SELF']."' method='POST'>";
echo "<center><table>";
echo "<br><tr><td><b>Account ID: </font></b></td><td><input type='text' name='accname' maxlength='15'></td></tr>";
echo "<tr><td><b>Account Password: </font></b></td><td><input type='password' name='accpass1' maxlength='15'></td></tr>";
echo "<tr><td><b><b>Confirm Password: </font></b></td><td><input type='password' name='accpass2' maxlength='15'></td></tr>";
echo "<tr><td><b>Account Email: </font></b></td><td><input type='text' name='accmail' maxlength='50'></td></tr>";
echo "<tr><td>&nbsp;</td><td>&nbsp;</td></tr>";
echo "<tr><td colspan='2' align='center'>
<input type='hidden' name='activ' value='1'>
<input type='submit' value='Create Account'></td></tr>";
echo "</table></center>";
echo "</form>";

}

echo "</center>";

?>
NeedHelpAti is offline  
Old 05/12/2020, 03:01   #4
 
PyrexiaStudios's Avatar
 
elite*gold: 0
Join Date: Feb 2011
Posts: 150
Received Thanks: 74
You need to install the MSSQL drivers for MSSQL 2008
PyrexiaStudios is offline  
Old 05/12/2020, 04:25   #5
 
Farius~'s Avatar
 
elite*gold: 0
Join Date: Jun 2013
Posts: 555
Received Thanks: 318
¿For what reason u use Sql Server 2008?
Farius~ is offline  
Old 05/12/2020, 22:15   #6
 
elite*gold: 0
Join Date: Jul 2015
Posts: 876
Received Thanks: 258
MS connect

If your dekaron server connect with MSSQL that mean all is fine.

Bot when you use PHP you should know what php version your web server use.

If you server use for example: 7.1.x then your apache must load correct .dll

here you will read more about that
[DEV]Dekaron is offline  
Old 05/13/2020, 01:34   #7
 
elite*gold: 0
Join Date: Mar 2007
Posts: 149
Received Thanks: 10
thx yaall for the help i got it fix by Baica123 thx SER,,,,,
NeedHelpAti is offline  
Reply


Similar Threads Similar Threads
[04.09.13] GigaByte v2.6 [FIX, FIX, FIX, FIX AND FIX]
09/11/2013 - WarRock Hacks, Bots, Cheats & Exploits - 79 Replies
http://www.elitepvpers.com/forum/warrock-hacks-bot s-cheats-exploits/2843300-11-09-gigabyte-public-v2 -7-a.html
[HELP]Experts or Semi-Experts help me out
07/17/2012 - SRO Private Server - 3 Replies
I appreciate any help i can get. So far i got my Vsro Server (1.88) working. Just a few steps missing, so if anyone could help me out ?! 1st: Language I got the Silkroad_TestIn Client. The language is vietnamese i guess, any solution how to change that one into english ? 2nd: Undestroyable Item I tried to figure out which option i need to change so an item wont be destroyed using alchemy, i know it should be in refobjitem, but thats all i figured out.



All times are GMT +1. The time now is 13:03.


Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.