Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[PHP + MySQL] Users Online, Members Online, and MySQL Login

Canadian
Loyal Member
Joined
Dec 4, 2007
Messages
1,936
Reaction score
96
Okay, so here, I need help with 3 different things.

1) I want a code to display how many guests are viewing the homepage or whole site entirely. (I'll put those code on homepage)

2) I want a code to display how many members are logged onto the MySQL Database.

3) I want a MySQL login to add to my site, so people login to the forum on the homepage. And when logged in, it must say "Wecome, Username!"

Can anyone help?

Also, in the code, where I have to enter the MySQL details, please display like "MySQL User", "MySQL Pass", MySQL DB" in the code, so I know where to place MySQL information.
 
Experienced Elementalist
Joined
Apr 7, 2005
Messages
254
Reaction score
0
I think you just need help with MySQL-queries.
For 1:
PHP:
$q = "SELECT COUNT(*) FROM sessions WHERE user_logged = 0";

For 2:
Same like no.1 but with user_logged = 1.

For 3:
For bridge authorizations you must know how your forum stores passwords. In vBulletin its md5(md5($password)) as i think, in IPB - md5($password + $salt);
 
Back
Top