Logout script

hldan1

i am current ly making an online browserbaser mafia game and need some help with a problem i hav. the problem is when users login other people can log in to there acount at the same time. is there a script that can stop 2 people logging in to an acount at the same time as i dnt want people on my game getting hacked.

Also once someone logs out is there a script that could put someting into the database so noone can log onto that acount for 5 minutes.

Thanks
Daniel

Cailean

you could put a 'logged in' column in the table that holds the user information... as the user logs in or out, column would toggle, etc.

For the 5min rule, put a 'last_login' field in the same table...fill it with a timestamp each time the user logs in... in your login script, if less than 300 seconds has elapsed, the login fails.

I'm not sure if this is such a good idea, though... what if a user logs out accidentally, or 'gets logged out' by some system problem on their end... IE gets confused and quits, or something. Then, they have to wait? That would drive me nuts! My $0.02.

hldan1

if i create the loggedin row in the datbase how what would i put in my php so people cant log on to someones acount when there logged on

Cailean

In your login script, you would pull the value of 'logged in' in your DB query ... if 'yes' (or '1' or 'true' or whatever you want) then the login fails, if the value is 'no' (or '0' or 'false' etc.) then the login continues -- remembering that once the login is approved, the value must be updated in the DB.

If you post your code, we can maybe show you what needs to go where.

Also, be careful not to confuse 'row' and 'column' when talking about database values or we'll all get confused... a 'column' is a field in your DB table the holds some data. A row is a series of data from a series of columns in you table. The terms 'column' and 'field' are fairly interchangable. A 'row' is also sometimes referred to as a 'record'.

hldan1

thanks i have posted the code below

<?
session_start(); 

if (!empty($_SESSION['username'])){
echo "<META HTTP-EQUIV=\"Refresh\" CONTENT=\"0; URL=../WWM.php\">";
exit;
}
if ($_GET['login'] == true){
header("Cache-control: private"); 
include 'db.php'; 


if (!$_SESSION['username'] || !$_SESSION['email']){
$username = $_POST['username']; 
$password = $_POST['password'];
$username = strip_tags($username);
$password = strip_tags($password);
$ip = $REMOTE_ADDR;
$domain = $_SERVER['REMOTE_ADDR'];



if((!$username) || (!$password)){ 
    echo "You have not submitted one or more fields <br />"; 
}



///check INFO
$sql = mysql_query("SELECT * FROM users WHERE username='$username' AND password='$password' AND activated='1' LIMIT 1"); 
$login_check = mysql_num_rows($sql); 

/////check if there alive or dead

if ($login_check > '0'){





    ini_set(session.cookie_lifetime, "3600");
    session_register('username'); 
    $_SESSION['username'] = $username; 
    session_register('email_address'); 
    $_SESSION['email_address'] = $email_address; 






     $timestamp = time(); 
$timeout = $timestamp-$timeoutseconds; 
$cool = gmdate('Y-m-d h:i:s');
mysql_query("UPDATE users SET lastlogin='$cool' WHERE username='$username'");
mysql_query("UPDATE users SET online='$timestamp' WHERE username='$username'");

mysql_query("UPDATE users SET ip='$domain' WHERE username='$username'");



    header("Location: WWM.php"); 

} else { 
    echo "We are sorry but you could not be logged in.!<br /> 
    Please try again!<br />"; 
    include 'index.php'; 
}}}
?> 

<html>
<head>
<title></title>


<STYLE>
INPUT{
	font-family: arial;

font-size: 12px;
color: #000000;
background-color: #CC0000;

}
FONT
{
    font-family: arial;
    font-size: 12px;

}
</STYLE>
<HEAD>



</head>

<?php
if (!$lang){
$lang='Eng';
}
if ($lang == 'Eng'){
$wel = 'Welcome to worldwidemafia, An online mafia experience. <br>
Gangsters lead the life of crime for a reason,<br> Money, Respect and Power.<br>
Unlucky for them there’s only one way out,<br> the staircase to hell. <br> When you log in please use Case Sensitive.<br><b>All players who were banned are now un-banned.  <br>Make sure this dosent happen to any of you sorry about this.</b>';

}
?>





<body bgcolor="#808080" text="#000000" leftMargin=0 topMargin=0 marginheight="0" marginwidth="0"  link="#000000" vlink="#000000" alink="#000000">
<table width="998" border="0" cellspacing="0" cellpadding="0" height="324">
  <tr> 
    <td width="595" background="layout/b.gif" height="101" align="left" colspan="2"> 
      <p><font size="12" face="Verdana, Courier New, Arial">
      &nbsp;&nbsp;</font></p>      </td>
    <td background="layout/r.gif" height="98" width="411" align="left"><A HREF="index.php?lang=Eng"><img border="0"  src="images/langs/eng.gif"></a><A HREF="index.php?lang=Nl"><img border="0"  src="images/langs/nl.gif"></a>&nbsp;<tr> 
    <td align="center" valign="middle" height="162" width="191" rowspan="3">&nbsp;</td>

<td align="center" valign="middle" height="54" width="331">&nbsp;</td>

<td align="center" valign="middle" height="162" width="484" rowspan="3">
<font face="Arial"><? echo "$wel"; ?>
</font></td>

  </tr>


  <tr> 
    <td align="center" height="180" width="337" bordercolorlight="#000000" bordercolordark="#000000" style="border: 0px solid #000000" background="layout/tbg.gif"> 
              <font size="2" face="Verdana, Courier New, Arial">

          <br>
          &nbsp;</font><p align="right"><form action='?login=true' method=post>
<font color="#FFFFFF" size="2" face="Verdana, Courier New, Arial"><?php if ($lang == 'Nl'){ echo "Spelernaam:"; }else{ echo "Username:";} ?>
          <input name="username" id="username" size="20"  style="border: 1px solid #000000; float:right"></font></p>
<p align="right"> 
          <font size="2" face="Verdana, Courier New, Arial" color="#FFFFFF">
          <br>
<?php if ($lang == 'Nl'){ echo "Wachtwoord:"; }else{ echo "Password:"; }?> </font> 
          <font color="#FFFFFF"> 
          <input type="password" name="password" id="password" size="20" style="border: 1px solid #000000; float:right"></font></p>
<p><font color="#FFFFFF"><br>
</font>
          <input type=submit value="Login" style="border: 1px solid #000000"></td>
</form>
  </tr>
  <tr> 

<td align="center" height="62" width="337" bordercolorlight="#000000" bordercolordark="#000000" style="border: 0px solid #000000">
         <A HREF="register.php?lang=<?php echo "$lang"; ?>"><img border="0"  src="layout/reg.gif" width="150" height="25"></a>
         <A HREF="contact.php?lang=<?php echo "$lang"; ?>"><img border="0" src="layout/cont.gif" width="150" height="25"></a>
         <A HREF="faq.php?lang=<?php echo "$lang"; ?>"><img border="0" src="layout/faq.gif" width="150" height="25"></a>
         <A HREF="lost.php?lang=<?php echo "$lang"; ?>"><img border="0" src="layout/lost.gif" width="150" height="25"></a></td>

  </tr>
  <tr> 

	</font>
	</td>

  </tr>
</table>
</body>
</html>