[Released][EN][V1.2]NosTale Register Page

01/31/2017 17:20 kurtmac#16
how i set connection to xampp
this error
Something went wrong while connecting to MSSQL

my config

<?php
$dbhostname = "127.0.0.1"; //MsSQl Server Addres
$db = array(
"Database" => "opennos", // Database Name
"Uid" => "nosczech", //Database User
"PWD" => "bilokej" // Database Password;
);

thx for help
02/01/2017 00:13 Fizo55#17
You do not activate the sql server connection you must enable the 2
02/11/2017 15:11 kurtmac#18
not work !
this is my config

<?php
$dbhostname = "127.0.0.1"; //MsSQl Server Addres
$db = array(
"Database" => "opennos", // Database Name
"Uid" => "river", //Database User
"PWD" => "riverguns" // Database Password;
);

how enable ?
this is php conf
; Windows Extensions
; Note that ODBC support is built in, so no dll is needed for it.
; Note that many DLL files are located in the extensions/ (PHP 4) ext/ (PHP 5+)
; extension folders as well as the separate PECL DLL download (PHP 5+).
; Be sure to appropriately set the extension_dir directive.
;
extension=php_bz2.dll
extension=php_curl.dll
extension=php_sqlsrv_7_ts_x64.dll
extension=php_sqlsrv_7_nts_x64.dll
;extension=php_com_dotnet.dll
;extension=php_enchant.dll
extension=php_fileinfo.dll
;extension=php_ftp.dll
extension=php_gd2.dll
extension=php_gettext.dll
extension=php_gmp.dll
extension=php_intl.dll
extension=php_imap.dll
;extension=php_interbase.dll
extension=php_ldap.dll
extension=php_mbstring.dll
extension=php_exif.dll ; Must be after mbstring as it depends on it
extension=php_mysqli.dll
;extension=php_odbc.dll
extension=php_openssl.dll
;extension=php_pdo_firebird.dll
extension=php_pdo_mysql.dll
;extension=php_pdo_oci.dll
;extension=php_pdo_odbc.dll
;extension=php_pdo_pgsql.dll
extension=php_pdo_sqlite.dll
;extension=php_pgsql.dll
;extension=php_phpdbg_webhelper.dll
;extension=php_shmop.dll

help me with conf site wont connect to my sql server :(
02/15/2017 15:17 kurtmac#19
"opennos", // Database Name "Uid" => "river", //Database User "PWD" => "riverguns" // Database Password; ); $hosturl = "25.107.144.3"; //Your host patch eg [Only registered and activated users can see links. Click Here To Register...] (without last slash " / ") ----- MUST BE STTED! $title = "NosCzech"; //site title ----- MUST BE SETTED! $norplaymail = "[Only registered and activated users can see links. Click Here To Register...]"; // noreplay mail eg "[Only registered and activated users can see links. Click Here To Register...]" /////////////////////////////////////////// ////Do you want to display footer ? //// ////True = yes | False = no //// /////////////////////////////////////////// $footer = true; /////////////////////////////////////////// ////Do you want to display ToS ? //// ////True = yes | False = no //// /////////////////////////////////////////// $displaytos = false; $toslink = ""; //link to your ToS page eg "//mywebsite.com/tos.html" (please use // instead of http or https !!!) $pplink = ""; //link to your Privacy Policy page eg "//mywebsite.com/pp.html" (please use // instead of http or https !!!) /////////////////////////////////////////// ////Do you want to enable forgot ? /// ////true = yes | false = no /// /////////////////////////////////////////// $forgot = false; /////////////////////////////////////////////// ////Do you want to send verification mail ? /// ////true = yes | false = no /// /////////////////////////////////////////////// $sendverification = false; /////////////////////////////////////////// ////Do you want to use Google CAPTCHA ? /// ////true = yes | false = no /// /////////////////////////////////////////// $usecaptcha = false; //if you want to use google captcha you can get secret key and public key there [Only registered and activated users can see links. Click Here To Register...] $captchapublickey = ""; //If yes , put your PUBLIC key there (site key its called on google page's) $captchasecret = ""; //If yes, put your SECRET key there /////////////////////////////////////////// $dl['name1'] = ""; //Set Download Name for 1st Link $dl['1'] = ""; //Download link 1 OPTIONAL $dl['name2'] = ""; //Download Name for 2nd Link $dl['2'] = ""; //Download link 2 OPTIONAL /////////////////////////////////////////// ////Do you want to enable login ? /// ////true = yes | false = no /// /////////////////////////////////////////// //That mean to allow users to login in ther account and they can change his password, or email, ofc you my config this... $login = true; //Allow login to site $notifymail = true; //Send notification to mail for each login, if account are accesed a mail will be send to his address with some information. $lcpw = false; //Allow change password ////Below setting are under development /// ////Please DO NOT TURN ON! /// $lce = false; //Allow change email /////////////////////////////////////////////////////////////////////////////////////////////////////////// ////////////////////////////////////////DONT TUCH BELOW LINE/////////////////////////////////////////////// /////////////////////////////////////////////////////////////////////////////////////////////////////////// $mssql = sqlsrv_connect($dbhostname, $db); if(!$mssql) die('Something went wrong while connecting to MSSQL'); if(empty($dbhostname)) die("
Server its not configurate. Please check config.php
Configrate your database please!

"); if(empty($title)) die("
Configuration incomplete. check config.php
check title!!!

"); if(empty($hosturl)) die("
Configuration incomplete. check config.php
Check host url

"); if($usecaptcha == true && empty($captchapublickey) && empty($captchasecret)) die("
Configuration incomplete. check config.php
Check Google Captcha

"); if($displaytos == true && empty($toslink) && empty($pplink)) die("
Configuration incomplete. check config.php
Check ToS or Privacy Policy

"); else { require_once('recaptcha/autoload.php'); $recaptcha = new \ReCaptcha\ReCaptcha($captchasecret); } function thisword($word) { $badword = array("drop", "insert", "update", "delete", "alter", "index", "truncate", "'", '"'); $badreplace = array("***", "***", "****", "***", "****", "***", "*****", "*", "*"); $clean = str_replace($badword,$badreplace,$word); return $clean; } function cleanthis($data) { $iclean = filter_var($data, FILTER_SANITIZE_STRING); $iclean = thisword($iclean); $iclean = htmlentities($iclean, ENT_QUOTES); return $iclean; } ?>
I have all extensions
[MSSQL]
mssql.allow_persistent=On
mssql.max_persistent=-1
mssql.max_links=-1
mssql.min_error_severity=10
mssql.min_message_severity=10
mssql.compatability_mode=On
mssql.secure_connection=On

;
extension=php_sqlsrv_7_nts.dll
extension=php_sqlsrv_7_ts.dll
extension=php_bz2.dll
extension=php_curl.dll
extension=php_fileinfo.dll
;extension=php_ftp.dll
extension=php_gd2.dll
extension=php_gettext.dll
;extension=php_gmp.dll
;extension=php_intl.dll
;extension=php_imap.dll
;extension=php_interbase.dll
;extension=php_ldap.dll
extension=php_mbstring.dll
extension=php_exif.dll ; Must be after mbstring as it depends on it
;extension=php_mysqli.dll
;extension=php_oci8_12c.dll ; Use with Oracle Database 12c Instant Client
;extension=php_openssl.dll
;extension=php_pdo_firebird.dll
;extension=php_pdo_mysql.dll
;extension=php_pdo_oci.dll
extension=php_pdo_odbc.dll
extension=php_pdo_pgsql.dll
;extension=php_pdo_sqlite.dll
extension=php_pgsql.dll
;extension=php_shmop.dll

and say Something fucking went wrong while connecting to MSSQL

in sql server Allow remote Connections is allowed

SQL Server and windows auth is enabled

Why saying this shit Something went wrong while connecting to MSSQL

<?php
$dbhostname = "localhost"; //MsSQl Server Addres
$db = array(
"Database" => "opennos", // Database Name
"Uid" => "river", //Database User
"PWD" => "riverguns" // Database Password;
);

problem has solved

and now i have this problem

require_once('config.php'); if(!isset($_COOKIE['passkey'])) setcookie("passkey", "", time()-3600); $secret = rand(1, 100) . rand(1, 100) . rand(1, 100) . rand(1, 100) . rand(1, 100) . rand(1, 100) . rand(1, 100) . $title . rand(1,100); $secret = hash("sha512", $secret); setcookie("passkey", $secret); $headers = apache_request_headers(); if(isset($headers['If-Modified-Since'])) { if(strtotime($headers['If-Modified-Since']) < time() - 43200) { header('HTTP/1.1 304 Not Modified'); Header("Cache-Control: private"); exit; } } ?>
02/25/2017 03:45 SindonyX#20
I have this error: Fatal error: Call to undefined sqlsrv_connect () function in C:\xampp\htdocs\config.php on line 59

I installed all .dll and added all extensions necessary in php.ini somebody could help me..?
02/25/2017 11:51 Fizo55#21
Install xamp version 7.0.1 ...
02/25/2017 16:40 SindonyX#22
Quote:
Originally Posted by hugo50000 View Post
Install xamp version 7.0.1 ...
Fatal error: Uncaught Error: Call to undefined function sqlsrv_connect() in C:\xampp\htdocs\config.php:59 Stack trace: #0 C:\xampp\htdocs\index.php(2): require_once() #1 {main} thrown in C:\xampp\htdocs\config.php on line 59
02/25/2017 16:48 Fizo55#23
You dont install the extensions for sql server.
02/25/2017 17:13 DuckDuckGoose0815#24
Quote:
Originally Posted by SindonyX View Post
Fatal error: Uncaught Error: Call to undefined function sqlsrv_connect() in C:\xampp\htdocs\config.php:59 Stack trace: #0 C:\xampp\htdocs\index.php(2): require_once() #1 {main} thrown in C:\xampp\htdocs\config.php on line 59
Try to install the SQL_server extensions for php there are several videos for it :)
02/26/2017 15:09 SindonyX#25
Quote:
Originally Posted by DuckDuckGoose0815 View Post
Try to install the SQL_server extensions for php there are several videos for it :)
I installed all .dll and added all extensions necessary in php.ini...

The same error still appears..
02/26/2017 15:13 FI0w#26
Quote:
Originally Posted by SindonyX View Post
I installed all .dll and added all extensions necessary in php.ini...

The same error still appears..
use IIS
03/06/2017 13:21 NosBreak#27
Install Page-register in Xampp with php7 and put dlls in PHP.ini and Not connect.. Fix pls? :/
03/06/2017 21:52 @LRevolution#28
Please stop posting on this topic and let it die, this register page is 100% not safe, the code is bad and the creator even left the ship, don't even consider using this.