[Help needed] L2 Off Account manager

[Boxan]

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.

[Commodus]

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?

[Boxan]

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

[Commodus]

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.

[Boxan]

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.

[rodox]

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

Check this in php.ini

[Boxan]

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?

[mcbigmac]

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.

[Dr.House]

LoL

 

Install apache + php and conf mssqlserver.

[Sighed]

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.