[Request] One from LEKI and can't find

[FirefoxAurora]

as title say i show last night or yesterday one online players with server status based on php and can't find. can some1 help me?

(i keep trying to find it)

[Pauler]

as title say i show last night or yesterday one online players with server status based on php and can't find. can some1 help me?

(i keep trying to find it)

 

I coded one now:

 

test.php

<?php

include('connect.php');

$query = mysql_query("SELECT * FROM characters WHERE online=1");

$count = 0;

while ($row = mysql_fetch_row($query)) {

$count++;

}

echo "There are " + $count + " players online.";

?>

 

connect.php

<?php
$connect = mysql_connect("localhost", "root", "password");
mysql_select _db($connect, "l2jdb");
?>

[FirefoxAurora]

thank you dude! let me check if work ;D

if it works correct (as i see will work)

when i reach 200 posts i will give you karma! :D <3 <3 (h)

[FirefoxAurora]

<?php
$connect = mysql_connect("localhost", "root", "mysql");
mysql_select _db($connect, "l2Register");
?>

 

on that code gave me error on mysql_select _db and i did mysql_select_db and fixed

but on other code gave me an error at  while ($row = mysql_fetch_row($query)) {

(at mysql_fetch_row)

 

 

[Pauler]

<?php
$connect = mysql_connect("localhost", "root", "mysql");
mysql_select _db($connect, "l2Register");
?>

 

on that code gave me error on mysql_select _db and i did mysql_select_db and fixed

but on other code gave me an error at  while ($row = mysql_fetch_row($query)) {

(at mysql_fetch_row)

 

 

What error?

[FirefoxAurora]

<?php
$connect = mysql_connect("localhost", "root", "mysql");
mysql_select _db($connect, "l2Register");
?>

 

on that code gave me error on mysql_select _db and i did mysql_select_db and fixed

but on other code gave me an error at  while ($row = mysql_fetch_row($query)) {

(at mysql_fetch_row)

[Pauler]

 

Yeah dude I saw that. You have to tell me what the error says.

[FirefoxAurora]

Warning: mysql_select_db() expects parameter 1 to be string, resource given in C:\Program Files (x86)\Ampps\www\Lineage 2 Olympus\connect.php on line 3

 

Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in C:\Program Files (x86)\Ampps\www\Lineage 2 Olympus\index.php on line 57

0

[Pauler]

Ok, sorry I tested the code and I did some mistakes. I havent coded in PHP something for a long time.

 

mysql_fetch_row should better be mysql_fetch_assoc

 

And mysql_select_db($connect, "l2jdb"); should be mysql_select_db("l2jdb", $connect);

[FirefoxAurora]

Ok, sorry I tested the code and I did some mistakes. I havent coded in PHP something for a long time.

 

mysql_fetch_row should better be mysql_fetch_assoc

 

And mysql_select_db($connect, "l2jdb"); should be mysql_select_db("l2jdb", $connect);

 

I love you so much!! (h)

when i reach 200 posts i will give you +1 karma! :)