Does anyone know why I get this error using L2 Account ZS 2.0 shared by GodOfAden.

 

Fatal error: Call to undefined function mssql_connect() in /home/rl2int64/public_html/account/functionspw.php on line 24

 

There's the error line 24

 

$dbconnect = mssql_connect ($dbaddress, $dbuser, $dbpass);

 

 

Config.php settings are ok .

 

/*SQL IP Address			
$CONFIG['dbaddress'] = "the_ip_of_the_srv_where_is_installed_sql_database";

/*SQL Username				
$CONFIG['dbuser'] = "my_sql_user";

/*SQL Password				
$CONFIG['dbpass'] = "my_sql_password";

/*Lineage II Database Database Name	[Default: lin2db]*/
$CONFIG['dbdbname'] = "lin2db";

/*Lineage II World Database Name	[Default: lin2world]	*/
$CONFIG['worlddbname'] = "lin2world";

/*Maximum Accounts Per Email		[Default: 1 (0 for disabled.)]*/
$CONFIG['maxemail'] = "0";

 

I searched a lot for that error but didn't find anything to solve it.

As you can see in the error , your site can't connect to mysql.

 

Are you sure that you have the port 80 opened and the config.php to be set correctly?

Yes mate. Port 80 opened on the server where is the sqldb running but i got the same error.

Yes mate. Port 80 opened on the server where is the sqldb running but i got the same error.

 

Are you sure that your db name is lin2db ? Cause in your configs this is the default.

Yes, as you know that's the default db (lin2db). Or should i change the lin2db to dbo.user_account (the accounts table from lin2db) ? Thanks.

Probably your php environment doesn't have mssql extension enabled.

Check this in php.ini

extension=php_mssql.dll it's enabled in php.ini. That doesn't solve the problem...it's there any options that i can try?

extension=php_mssql.dll it's enabled in l2.ini. That doesn't solve the problem...it's there any options that i can try?

 

L2.ini?

wtf?

 

check your webserver's php extensions, like he said.

php.ini

 

 

Clearly you are trying to call an undefined function, ergo mssql is not enabled.

LoL

 

Install apache + php and conf mssqlserver.

The problem is that his php.ini has the";" symbol, so your mssql drivers on your apache are disabled. Find in the php.ini the mssql commented lines and delete the ";" symbol to uncomment, restart apache and you're done.