Jump to content

Recommended Posts

  • 3 months later...
Posted (edited)

Tried adding this ; kept showing up --

Login:

Char:

Map:

Online: Can't connect to local MySQL server through socket '/tmp/mysqld.sock' (2)

Edited by Ron
  • 4 weeks later...
  • 2 months later...
  • 6 years later...
  • 11 months later...
Posted
On 6/23/2019 at 9:34 AM, ittiphol said:

user online is not work how to fix it

thank you.

x2. Player Online no work.

  • 3 weeks later...
  • 1 year later...
Posted (edited)

sudo apt-get install php-mysql

dont forget to install it 

 

This is for msqli php7 dudes like myself

function PlayerCount() {
		
		Global $Srv_Host, $Srv_Username,$Srv_Password,$Srv_Database;           
		$mysqli = new mysqli($Srv_Host, $Srv_Username, $Srv_Password, $Srv_Database);
		if ($mysqli -> connect_errno) {
			echo "Failed to connect to MySQL: " . $mysqli -> connect_error;
			exit();
		}
		$count = 0;
		if ($result = $mysqli -> query("SELECT COUNT(*) as total FROM `char` WHERE online = '1'")) {
			$request_list_row = $result->fetch_row();
			echo ' ',$request_list_row[0];
		    // Free result set
		    $result -> free_result();
		} else {
			echo 0;
		}

		$mysqli -> close();
    }

 

Edited by arcada
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...