Online Issue

[Tukas]

Hi,

I got a new template Forsaken_Flynn. I have problem getting online players from database. Using MuCore 1.0.8(Image : Screenshot by Lightshot)



Thanks

[MentaL]

[testers121]

website use odbc or mssql ?

[Tukas]

website use odbc or mssql ?

odbc.

[testers121]

odbc.

change to mssql and should work

[Tukas]

change to mssql and should work

How do I create MySql and connect database from game database to web?

Thanks

[testers121]

How do I create MySql and connect database from game database to web?

Thanks

lol :D

search in config.ini

/*-------------------------------------*\
| MUCore SQL Connection Type: |
| |
| MSSQL : Connect using mssql_conect() |
| ODBC : Connect using odbc |
\*-------------------------------------*/


$core['connection_type'] = "ODBC";

and change to MSSQL

[Tukas]

lol :D

search in config.ini

/*-------------------------------------*\
| MUCore SQL Connection Type: |
| |
| MSSQL : Connect using mssql_conect() |
| ODBC : Connect using odbc |
\*-------------------------------------*/


$core['connection_type'] = "ODBC";

and change to MSSQL

I know how to change that but anyway I got mssql installed on xampp but still doesn't work. It says that my website is offline.

[testers121]

I know how to change that but anyway I got mssql installed on xampp but still doesn't work. It says that my website is offline.

MSSQL - its sql server connection to your database. On xampp is Mysql. Show your config.ini

[KarLi]

@Tukas
what u mean web is offline? u need to use MSSQL first of all on mucore websites.. odbc is used mostly on older files season or something and not recommended because it doesnt connect to all the database areas.

Fix that, tell us why u have problem with mssql what errors u get etc and we will help ya.

[Tukas]

OK so now the MuCore is on MSSQL. But still I receive same value "0" for Online Users... The rest are OK. Guilds,characters,accounts created. But Online just shows 0. Any other options?

Thanks guys!

[FanStar]

OK so now the MuCore is on MSSQL. But still I receive same value "0" for Online Users... The rest are OK. Guilds,characters,accounts created. But Online just shows 0. Any other options?

Thanks guys!

use this codes

mssql_select_db( "MuOnline" );
$on1 = mssql_query("SELECT count(memb___id) from MEMB_STAT where ConnectStat = '1'");
$on = mssql_fetch_row($on1);

<tr>
<td>Online Players</td>
<td align="right"><?=$on[0];?></td>
</tr>

[leorond]

I manipulate rather procedural programming method but try this

("SELECT * FROM MEMB_STAT WHERE ConnectStat = '1' ")

Procedural

$online = mssql_num_rows(mssql_query("SELECT * FROM MEMB_STAT WHERE ConnectStat = '1' "));

echo $online;

- - - Updated - - -

use this codes

counting rows in the database would rather vote for

mssql_num_rows

And do not forget the condition when the number of rows 0!
It could look something like this

if($online < 1) { $online = "0"; }

[Tukas]

Thanks guys, but it seems to be the same.. It doesn't show users online at all..

Screenshot by Lightshot
Screenshot by Lightshot

[leorond]

Create a file test.php and insert this code

<?php
$connect['IP']                    =    "127.0.0.1";    //    server IP
$connect['login']                =    "sa";            //    server login
$connect['pass']                =    "....";        //    server password
$connect['database']            =    "MuOnline";        //    database name
$conn    =    mssql_connect($connect['IP'],    $connect['login'],    $connect['pass'])    or    die("<center>Can't Connect To Database</center>");
$db        =    mssql_select_db($connect['database'],    $conn)    or    die("<center>Can't Connect To Database</center>");

$online = mssql_num_rows(mssql_query("SELECT * FROM MEMB_STAT WHERE ConnectStat = '1' "));

echo "Online:".$online;
?>

Access to this file over a fixed URL address

for example

http://domain.tld/test.php

If you do not print the number of online players, the error is elsewhere.

[Tukas]

Create a file test.php and insert this code

<?php
$connect['IP']                    =    "127.0.0.1";    //    server IP
$connect['login']                =    "sa";            //    server login
$connect['pass']                =    "....";        //    server password
$connect['database']            =    "MuOnline";        //    database name
$conn    =    mssql_connect($connect['IP'],    $connect['login'],    $connect['pass'])    or    die("<center>Can't Connect To Database</center>");
$db        =    mssql_select_db($connect['database'],    $conn)    or    die("<center>Can't Connect To Database</center>");

$online = mssql_num_rows(mssql_query("SELECT * FROM MEMB_STAT WHERE ConnectStat = '1' "));

echo "Online:".$online;
?>

Access to this file over a fixed URL address

for example

http://domain.tld/test.php

If you do not print the number of online players, the error is elsewhere.

Thanks, but it still shows value of 0..