timestamp

[ghqwerty]

as you might no i am setting up a limit on how many times a user can extort someone in a given time.

 

i have added the column 'last_extortion' however whenever i try and update it to the current timestamp it wont change.

 

could someone please show me how to update it ? whether using time() or date()

[dezkit]

http://www.tizag.com/mysqlTutorial/mysqlupdate.php

[ghqwerty]

i know how to do that but when i do

 

mysql_query("update members set last_extortion = ". date('Y-m-d H:i:s') ." where id = '". $_SESSION['id']."'");

then it doesnt change anything.

[dezkit]

$result = mysql_query("UPDATE members SET last_extortion='".date('Y-m-d H:i:s')."' WHERE id = '". $_SESSION['id']."' ") 
or die(mysql_error()); 

 

Try this.

[ghqwerty]

thanks

[ghqwerty]

i have another problem now

 

when drawing on that information in the table how to i put it in date() format ?

 

so i could do

if((date('y-m-d H:I:S') - $last_time) > $seconds_gap)

 

if yes then do extortion if no then show an error message like - "You can only extort once every x minutes. You have to wait y more minutes/seconds"

[ghqwerty]

does anyone know ?

[Fruct0se]

If you pull $last_time from the DB in the format date('y-m-d H:I:S') then this will work for you.

$last_time = strtotime($last_time);
if((time() - $last_time) > $seconds_gap)

 

[ghqwerty]

now that the servers are back up i now have a 3rd problem lol

 

im getting this error whenever i 'extort' someone

 

Warning: strtotime() expects parameter 1 to be string, resource given in /home/a2350935/public_html/extortion.php on line 95

 

 

this is how im using it

 

$last_time = mysql_query("select last_extortion from members where id = '".$_SESSION['id']."'") or die(mysql_error());
												$last_time = strtotime($last_time);													
												$length = 10;
												$seconds_gap = $length * 60;

[ghqwerty]

changed to

 

$last_time = mysql_query("select last_extortion from members where id = '".$_SESSION['id']."'") or die(mysql_error());
												$last_time1 = mysql_fetch_array($last_time);
												$last_time2 = $last_time1['last_extortion'];
												$last_time = strtotime($last_time2);													
												$length = 10;
												$seconds_gap = $length * 60;													
												if((time() - $last_time) > $seconds_gap){

 

 

but now whenever i try and extort someone i get

 

'You can only extort once every 10 minutes. You have to wait 1225107713 seconds.'

[sammeh]

I would get rid of the date() and use mktime() it's a lot better for time comparison!