[Help] Problems with website

[EddyM]

Fatal error: Call to undefined function mssql_connect() in C:\xampp\htdocs\config.php on line 12

Where is the problem ? I can't use any website
SQL 2008 , Xampp 1.7.7

I want to try to use DarksWeb 0.3

 

[RaFa]

As far as I remember XAMPP 1.7.1 was the last version to support the mssql_* functions.
You can check Damian's post which provided code to define those functions again using the SQL Server PHP extension;

Guide on how to add SQL Server drivers.

 

[EddyM]

So i need to use XAMPP 1.7.1 ?

 

[RaFa]

Either that or you should add Damian's code to the website.

 

[EddyM]

Now i install XAMP 1.7.1 and website shows - Couldn't connect to SQL Server!

 

[RaFa]

Check you configuration. User/pass, are you connection through named pipe or IP?

 

[EddyM]

I change config.php. Maybe i doing something wrong when i install XAMPP 1.7.1
I always use appserv before

 

[RaFa]

If you locate the mssql_connect function, I guess that you will see something like:

mssql_connect(arguments...) or die('Couldn't connect to SQL Server! ');

Can you remove "or die('Couldn't connect to SQL Server! ')" and give us the output then?

 

[EddyM]

Now it's ok. But page loading very slowly

 

[RaFa]

If your server is offline (game server), there might be huge timeout on the server status indicator. Search for fsockopen and check the fifth argument. Set it to 0.1 or something like that.

 

[EddyM]

Server is online..
And website don't show how many Total accounts, Total characters, Online... And rankings

 

[RaFa]

Okay, I have just realized what happened.

Go back to the mssql_connect...

mssql_connect(arguments...) or die('Couldn't connect to SQL Server! ');

And change it to:

mssql_connect(arguments...);
die(); // THIS SHOULD STAY!!

 

[EddyM]

Parse error: parse error in C:\xampp\htdocs\config.php on line 12

 

[RaFa]

Post your config.php here. Remove your SQL password!!

 

[EddyM]

OK

 

[RaFa]

Use that. Error should be displayed in your website. You can share the error here.

<?php
if(!defined('inIndex')){ header('Location: ../'); exit(); }

//Sql server detailes
error_reporting(E_ALL ^E_NOTICE ^E_WARNING);

$web['dbhost'] = '127.0.0.1';
$web['database'] = 'MuOnline';
$web['dbuser'] = 'sa';
$web['dbpassword'] = '';

$dbc = mssql_connect($web['dbhost'], $web['dbuser'], $web['dbpassword']);
die("Couldn't connect to SQL Server!"); 
$selected = mssql_select_db($web['database'],$dbc) or die("Couldn't open database"); 

// Website config settings
$web['title'] = 'MuOnline Server'; // Website title
$web['template'] = 'templates/3/'; // Website Template
$web['forum'] = 'http://forumlink.com/'; // Forum link
$web['vote'] = 'http://votelink.com/'; // Vote link
$web['md5'] = 0; // 1=>md5 ON and 0=> md5 OFF

//DownLoad settings
$web['client1desc'] = 'AidaMU Online Client [310mb]. '; // Client 1 Description
$web['client1link'] = 'http://downloadlink.com/'; // Client 1 link
$web['client1name'] = '[FULL] AidaMU Online client '; // Client 1 Name

$web['client2desc'] = 'AidaMU Online Client2 [310mb]. '; // Client 2 Description
$web['client2link'] = 'http://downloadlink.com/'; // Client 2 link
$web['client2name'] = '[FULL] AidaMU Online client2 '; // Client 2 Name

$web['client3desc'] = 'AidaMU Online Client3 [310mb]. '; // Client 3 Description
$web['client3link'] = 'http://downloadlink.com/'; // Client 3 link
$web['client3name'] = '[FULL] AidaMU Online client3 '; // Client 3 Name

//Setings for statistics
$web['servername'] = "AidamMU"; // Server name
$web['serverversion'] = "1.05X";  // Server Version here
$web['exp'] = "50x"; // Server xp
$web['drop'] = "50%"; // Server drop

//Setings for add stats
$web['max_stats'] = 32767; // the maximum stats character can add in add stats
$web['have_dl'] = 1; // 1=>if the server have dark lord and 0=> don't have

//Setings for reset character
$web['max_resets']='80'; // max resets
$web['reset_level']='350'; // reset level
$web['zen_for_res']='20000000'; // how mutch 1 reset will cost
$web['points_per_res']='500'; // points per reset
$web['clear_stats']=1; // Clear Stats after reset: 1=> YES || 0=> No

//Setings for reset character bonus
$web['zen_res_type']=0; // if 1=> zen cost will increase every reset || if 0=> disable(normal)
$web['cl_bns_points']=0; // bonus points for every class 1=> ON || 0=>OFF
$web['points_for_sm']=300; // points for dw,sm and grm 
$web['points_for_bk']=400; // points for dk,bk and  bm
$web['points_for_me']=500; // points for elf,me and he
$web['points_for_mg']=600; // points for mg and dum 
$web['points_for_dl']=700; // points for dl and le

//Setings for grand reset
$web['max_gresets']='80'; // max grand resets
$web['gr_resets']='35'; // resets needed for a grand reset
$web['zen_for_gres']='20000000'; // how mutch a grand reset will cost

//Setings for pk clear
$web['zen_for_pk']='15000000'; // how mutch will pk clear cost
$web['zen_pk_type']=0; // if 1=> zen cost will increase every pk level || if 0=> disable(normal)

//Setings for reset stats
$web['zen_for_rstats']='15000000'; // how mutch will reset stats cost

 

[EddyM]

Couldn't connect to SQL Server!

 

[dota-sdso]

Fill these variables properly:

$web['dbhost'] = '127.0.0.1';
$web['database'] = 'MuOnline';
$web['dbuser'] = 'sa';
$web['dbpassword'] = '';

If the website is running slow, go to SQL server configuration manager and
Enable TCP/IP and pipes as shown on the picture

 

[Dea7h]

?

 

[EddyM]

Fill these variables properly:

$web['dbhost'] = '127.0.0.1';
$web['database'] = 'MuOnline';
$web['dbuser'] = 'sa';
$web['dbpassword'] = '';

If the website is running slow, go to SQL server configuration manager and
Enable TCP/IP and pipes as shown on the picture

I did..