Register Page VSRO files

08/18/2020 04:47 skorpionabgbg#1
Hello evryone !!!
Ihave problem with register page on my server and thath is the last step before push hem public for fun with people :)
I have the files for reg but cant start corecly ... if anyone can assist me i will be greatfull to hem and will give items for fun in server
If anyone can or wanna help me pm here ty for time :) :) :)
08/18/2020 20:05 florian0#2
Quote:
Originally Posted by skorpionabgbg View Post
If anyone can or wanna help me pm here ty for time :) :) :)
Why PM. Explaining our problem and solving it publicly will help others in the future.
08/19/2020 01:03 skorpionabgbg#3
i will post files thath i use for reg page when i set database user and pw and when i try push with xampp i get stack overflow i will upload pictures and php codes later...

There we are i use thath files:
index.php
<?php
/* Simple registration page for silkroad server, by Chernobyl
* Settings are at _inc/config.php
* If you get an mssql connection error, while defining totally correct data
* Just use older ntwdblib.dll for your webserver
*/
require_once('_inc/security.class.php');
require_once('_inc/config.php');

if(!isset($_POST['submit']))
{
echo "<table border='1'>
<form method='post'>
<td>Username</td><td><input type='text' name='username' maxlength='16'></td><tr/>
<td>Password[1]</td><td><input type='password' name='pw1' maxlength='32'></td><tr/>
<td>Password[2]</td><td><input type='password' name='pw2' maxlength='32'></td><tr/>
<td></td><td><input type='submit' name='submit' value='Register'></td>
</form>
</table>";
}
else
{
if(is_array($user) == true) $err[] = "Username is array, n00p";
if(is_array($pass1) == true) $err[] = "Pw1 is array, n00p";
if(is_array($pass2) == true) $err[] = "Pw2 is array, n00p";
if(strlen($_POST['username']) < 3) $msg[] = "Username too short";
if(strlen($_POST['username']) > 16)$msg[] = "Username too long";
if(strlen($_POST['pw1']) < 6) $msg[] = "Password [1] too short";
if(strlen($_POST['pw1']) > 32)$msg[] = "Password [1] too long";
if(strlen($_POST['pw2']) < 6) $msg[] = "Password [2] too short";
if(strlen($_POST['pw']) > 32) $msg[] = "Password [2] too long";
if($_POST['pw1'] != $_POST['pw2']) $msg[] = "Passwords are not the same";

$sec = new security();

if($sec->is_secure($_POST['username']) == false) $msg[] = "Username contains forbidden symbols";
if($sec->is_secure($_POST['pw1']) == false) $msg[] = "Password [1] contains forbidden symbols";
if($sec->is_secure($_POST['pw2']) == false) $msg[] = "Password [2] contains forbidden symbols";

if(count($msg) > 0)
{
for($i = 0; $i < count($msg); $i++)
{
echo $msg[$i]."<br/>";
}
return;
}
else
{
//checking damn mssql stuff
$accountExists = mssql_num_rows(mssql_query("select StrUserID from TB_User where StrUserID='$_POST[username]'"));
if($accountExists > 0) echo "Account with such username already exists<br/>";
else
{
$pwd = md5($_POST['pw1']);
mssql_query("insert into TB_User(StrUserID,password,sec_primary,sec_content ) values('$_POST[username]','$pwd','3','3')");
echo "Account successfully created<br/>";
}
}

}
?>

security.class.php

<?php
class security
{
function is_secure($string)
{
$pattern = "#[^a-zA-Z0-9_\-]#";
if(preg_match($pattern,$string)==true)return false;
else
return true;
}
}
?>

config.php

<?php

$cfg['sql_host'] = "\SQLEXPRESS";
$cfg['sql_user'] = "sa";
$cfg['sql_pass'] = "1234";
$cfg['sql_db'] = "SRO_VT_ACCOUNT";


$sqlLink = mssql_connect($cfg[sql_host],$cfg[sql_user],$cfg[sql_pass]);
if(!$sqlLink) die("MSSQL server is not accessable, why should we try to select database ?");
else
{
mssql_select_db($cfg[sql_db],$sqlLink);
}
?>


when i start with xampp i get thath error:


Fatal error: Uncaught Error: Call to undefined function mssql_connect() in C:\xampp\htdocs\register\_inc\config.php:9 Stack trace: #0 C:\xampp\htdocs\register\index.php(8): require_once() #1 {main} thrown in C:\xampp\htdocs\register\_inc\config.php on line 9
anyone know what is this ?
08/19/2020 19:30 Piskota#4
Quote:
Originally Posted by skorpionabgbg View Post
i will post files thath i use for reg page when i set database user and pw and when i try push with xampp i get stack overflow i will upload pictures and php codes later...

There we are i use thath files:
index.php
<?php
/* Simple registration page for silkroad server, by Chernobyl
* Settings are at _inc/config.php
* If you get an mssql connection error, while defining totally correct data
* Just use older ntwdblib.dll for your webserver
*/
require_once('_inc/security.class.php');
require_once('_inc/config.php');

if(!isset($_POST['submit']))
{
echo "<table border='1'>
<form method='post'>
<td>Username</td><td><input type='text' name='username' maxlength='16'></td><tr/>
<td>Password[1]</td><td><input type='password' name='pw1' maxlength='32'></td><tr/>
<td>Password[2]</td><td><input type='password' name='pw2' maxlength='32'></td><tr/>
<td></td><td><input type='submit' name='submit' value='Register'></td>
</form>
</table>";
}
else
{
if(is_array($user) == true) $err[] = "Username is array, n00p";
if(is_array($pass1) == true) $err[] = "Pw1 is array, n00p";
if(is_array($pass2) == true) $err[] = "Pw2 is array, n00p";
if(strlen($_POST['username']) < 3) $msg[] = "Username too short";
if(strlen($_POST['username']) > 16)$msg[] = "Username too long";
if(strlen($_POST['pw1']) < 6) $msg[] = "Password [1] too short";
if(strlen($_POST['pw1']) > 32)$msg[] = "Password [1] too long";
if(strlen($_POST['pw2']) < 6) $msg[] = "Password [2] too short";
if(strlen($_POST['pw']) > 32) $msg[] = "Password [2] too long";
if($_POST['pw1'] != $_POST['pw2']) $msg[] = "Passwords are not the same";

$sec = new security();

if($sec->is_secure($_POST['username']) == false) $msg[] = "Username contains forbidden symbols";
if($sec->is_secure($_POST['pw1']) == false) $msg[] = "Password [1] contains forbidden symbols";
if($sec->is_secure($_POST['pw2']) == false) $msg[] = "Password [2] contains forbidden symbols";

if(count($msg) > 0)
{
for($i = 0; $i < count($msg); $i++)
{
echo $msg[$i]."<br/>";
}
return;
}
else
{
//checking damn mssql stuff
$accountExists = mssql_num_rows(mssql_query("select StrUserID from TB_User where StrUserID='$_POST[username]'"));
if($accountExists > 0) echo "Account with such username already exists<br/>";
else
{
$pwd = md5($_POST['pw1']);
mssql_query("insert into TB_User(StrUserID,password,sec_primary,sec_content ) values('$_POST[username]','$pwd','3','3')");
echo "Account successfully created<br/>";
}
}

}
?>

security.class.php

<?php
class security
{
function is_secure($string)
{
$pattern = "#[^a-zA-Z0-9_\-]#";
if(preg_match($pattern,$string)==true)return false;
else
return true;
}
}
?>

config.php

<?php

$cfg['sql_host'] = "\SQLEXPRESS";
$cfg['sql_user'] = "sa";
$cfg['sql_pass'] = "1234";
$cfg['sql_db'] = "SRO_VT_ACCOUNT";


$sqlLink = mssql_connect($cfg[sql_host],$cfg[sql_user],$cfg[sql_pass]);
if(!$sqlLink) die("MSSQL server is not accessable, why should we try to select database ?");
else
{
mssql_select_db($cfg[sql_db],$sqlLink);
}
?>


when i start with xampp i get thath error:


Fatal error: Uncaught Error: Call to undefined function mssql_connect() in C:\xampp\htdocs\register\_inc\config.php:9 Stack trace: #0 C:\xampp\htdocs\register\index.php(8): require_once() #1 {main} thrown in C:\xampp\htdocs\register\_inc\config.php on line 9
anyone know what is this ?
Its so ugly... Next time take a screenshot or something like that because that cleaner you know...I guess its missing mssql extension
08/20/2020 00:30 elmagico321#5
Quote:
Originally Posted by skorpionabgbg View Post

Fatal error: Uncaught Error: Call to undefined function mssql_connect() in C:\xampp\htdocs\register\_inc\config.php:9 Stack trace: #0 C:\xampp\htdocs\register\index.php(8): require_once() #1 {main} thrown in C:\xampp\htdocs\register\_inc\config.php on line 9
anyone know what is this ?


here is a topic you can find what to do [Only registered and activated users can see links. Click Here To Register...]
08/21/2020 14:39 skorpionabgbg#6
xmm maybe some module from xampp not start or not accsesable this topic you show me doznt help me ;(
08/23/2020 00:11 elmagico321#7
Quote:
Originally Posted by skorpionabgbg View Post
xmm maybe some module from xampp not start or not accsesable this topic you show me doznt help me ;(
then you didn't read it well

so simply you can do 2 things
1st trying to find an old ver of the xamp which working with php 5.5 or older
2nd change the connection type from mysql to mysqli or use the pdo
08/25/2020 11:55 skorpionabgbg#8
ok ty for info i will try thath steps ;)

i install old xamp and try and again get error
Fatal error: Call to undefined function mssqli_connect() in C:\xampp\htdocs\register\_inc\config.php on line 9
xmm..

the wronge code is:
$sqlLink = mssqli_connect($cfg[sql_host],$cfg[sql_user],$cfg[sql_pass]);
08/25/2020 23:21 elmagico321#9
Quote:
Originally Posted by skorpionabgbg View Post
ok ty for info i will try thath steps ;)

i install old xamp and try and again get error
Fatal error: Call to undefined function mssqli_connect() in C:\xampp\htdocs\register\_inc\config.php on line 9
xmm..

the wronge code is:
$sqlLink = mssqli_connect($cfg[sql_host],$cfg[sql_user],$cfg[sql_pass]);
just enable the mysqli extension
08/26/2020 01:03 skorpionabgbg#10
haw to do thath ?