Members online

[Verwijderd]

Nu heb ik een goed werkende website : http://music4ever.servemp3.com/

Alleen is mijn vraag, hoe koppel ik nu als een user ingelogged is, dit aan het onderstaande members online script?


Inlogscript :
<?php

$user_hostname = "localhost";
$user_username = "db";
$user_password = "db";
$user_database = "db_db";

$connect = mysql_connect("$user_hostname", "$user_username", "$user_password");
mysql_select_db("$user_database", $connect);

session_start();

if(!isset($username)) {

echo "<form method=\"POST\" action=$PHP_SELF>

<table>
<tr>
<td>Username:</td>
<td><input type=\"text\" name=\"username\" size=\"10\"></td>
</tr>
<tr>
<td>Password:</td>
<td><input type=\"password\" name=\"password\" size=\"10\"></td>
</tr>
<tr>
<td colspan=\"8\">
<p align=\"center\"><input type=\"submit\" value=\"Submit\" name=\"submit\"></td>
</tr>
</table>

</form>";
exit;
}

session_register("username");
session_register("password");

$sql = "SELECT * FROM users WHERE username = \"$username\" AND password = \"$password\"";
$result = @mysql_query($sql) or die("No.");

if(mysql_num_rows($result) == "0") {

session_unregister("username");
session_unregister("password");

echo "
<br><br>Dit is de verkeerde username of password,
<br>Klik <a href=url>hier</a> om opnieuw in te loggen\n";
exit;

}
if(isset($username)) {
?>
<SCRIPT>

function redirect()
{
window.location = "url.php"
}

setTimeout("redirect();", 1)
</SCRIPT>
<?
}
?>


---------------------------------------------------------------------------------------------------------
Members online script :
<?
function doUsersOnline() {
global $REMOTE_ADDR;

$db = new db;
$auth = new authenticate;
$now = time();
$expire = $now - 600;
$query = "DELETE FROM useronline WHERE timestamp < $expire";
$db->db_query($query);
if($auth->checkLogin()) {
$username = $auth->getName();
} else {
$username = "-1";
}

$query = "SELECT ip,username FROM useronline WHERE ip='$REMOTE_ADDR'";
$result = $db->db_query($query);
if(($db->db_numrows($result)) == 0) {
$query = "INSERT useronline (timestamp,ip,username) VALUES ($now,'$REMOTE_ADDR','$username')";
$db->db_query($query);
} else {
$row = $db->db_fetch_array($result);
if ($row['username'] != $username) {
$query = "UPDATE useronline SET username='".$username."' WHERE ip='".$REMOTE_ADDR."'";
$db->db_query($query);}
}
$query = "SELECT timestamp FROM useronline WHERE username='-1'";
$result = $db->db_query($query);
$guests = $db->db_numrows($result);
$query = "SELECT username FROM useronline WHERE username <> '-1'";
$result = $db->db_query($query);
$members = $db->db_numrows($result);
for($i=0;$i < $members;$i++) {
$row = $db->db_fetch_array($result);
$membernames[$i] = $row['username'];
}
$returnarray = array($guests,$members,$membernames);
return $returnarray;
}
?>
#####sql table schema
CREATE TABLE useronline (
timestamp int(11) NOT NULL default '0',
ip varchar(40) NOT NULL default '',
username varchar(30) NOT NULL default '',
PRIMARY KEY (timestamp,ip),
KEY timestamp (timestamp),
KEY ip (ip)
) TYPE=MyISAM;

[gorgi_19]

Wat lukt je zelf niet?

En verder zal het me niet verbazen als het niet gaat werken ivm Register Globals.

[ Voor 66% gewijzigd door gorgi_19 op 24-09-2003 22:37 ]

[whoami]

Hoi.

Welkom in P&W. Mag ik je vragen om eens onze FAQ en de Quickstart te lezen?

P&W is een forum waar er van de topicstarter ook enige inzet en zelfwerkzaamheid verwacht wordt om het probleem op te lossen.
Het is geen forum waar je zomaar je probleem kunt dumpen met de source, en dan maar kunt verwachten dat iemand anders het voor jou gaat gaan schrijven.