Sql Timers

[Scex]

Imagine i have a basic rpg, and i want to click buy soldier..

 

I would like each soldier to take 5 minutes to make, is there anyway i can set it up so that a timer appears with 5minutes until production.. and then after 5 minutes UPDATE the database rather than straight away?

 

Hope this makes sense.

[Mchl]

Several ways to do it.

One could be, save current timestamp + 5 minutes. Then the next time you check this record, if the timestamp has gone into past, add a soldier.

[Scex]

Great thanks for the quick reply!

So what kind of code would i use?

And wouldn't this be difficult if there was many different timers for different things/different times?

 

Would i use something like this

 

$thetime=date("U");

    $timelimit=$thetime-300*1;

 

 

 

...

 

}

        if($thetime<300)

        {

          print "$thetime";

        }

        else

        {

          $updateactions="Update users set lastaction='$thetime' where ID='$userstats3[iD]'";

          mysql_query($updateactions) or die("Could not update actions");

 

 

[Mchl]

I think you should just create a table, called `production_queue` or something

 

Into  this table insert

- player ID

- production item ID

- time of production end

 

Now every time player checks his/hers army or anything, check for items in production queue, that have been already produced, and add them to players inventory (don't forget to remove them from queue)

 

BTW:

date("U") is the same as time()

[Scex]

CREATE TABLE PRODUCTION (

  ID int(11) NOT NULL auto_increment,

  prodcutionid varchar(255) NOT NULL default '',

  prodtime int(10) NOT NULL default '',

  PRIMARY KEY  (ID)

 

Does this seem right?

 

[Mchl]

Prodtime should be DATETIME or TIMESTAMP. Use time types to store time. Saves a lot of hassle.

 

Also, how are you going to identify the user and the item produced?

[Scex]

When the user signs up ill insert the id into that table aswell as users, or ill make a new insert called username and insert it into that..

 

As for product ids.. i dont know.

[Mchl]

Well... you should have a table for users, where each user has his ID

Another table for products, where each product has ID

 

And then when you want assign production of item 4 for user 6 you just insert their IDs into production queue

[Scex]

Im really confused :S

 

Could you possibly write the code even a snippet of it

 

ill give you the body hang on

 

this is the main buyarmy.php page

 

 

_<?

_{include ('connect.php');} 

_{session_start();}

_?>

 

_{<link rel="stylesheet" href="style.css" type="text/css">}

 

_<?php

_{if (isset($_SESSION['player']))}

  _{

    _{$player=$_SESSION['player'];}

    _{$userstats="SELECT * from km_users where playername='$player'";}

    _{$userstats2=mysql_query($userstats) or die("Could not get user stats");}

    _{$userstats3=mysql_fetch_array($userstats2);}

    _{if($userstats3[dead]=='Yes')}

    _{

      _{print "You have been slain by $userstats3[killer]<br>";}

      _{print "<form action='revive.php' method='post'>";}

      _{print "<input type='hidden' name='ID' value='$userstats3[iD]'>";}

      _{print "<input type='submit' name='revives' value='revive'></form>";}

    _}

    _else

    _{

      _{$updaterefresh="update km_users set justattacked=0 where ID='$userstats3[iD]'";}

      _{mysql_query($updaterefresh) or die("Died");}

      _{print "<center><table class='maintable'>";}

      _{print "<tr class='headline'><td>";} 

      _{print "<center><b>Welcome warrior, $player. So you have come to rid the world of evil monsters, do not take on more than you can handle! Monsters are listed in order of increasing difficulty.</b></center>";}

      _{print "</td></tr></table></center><br><br>";}

 

_{print "<align='center'><table class='tableone'><tr class='headline' size='100%'><td><center>Tarenza Training Grouds</center></td></tr>";}

_{print "<tr class='center'><td>";}

_{print "<table class='littletable'><tr class='headline'><td><center>Buy Attack</center></td></tr>";}

_{print "<tr class='left'><td width='25%'>";}

_{print "Each troop Cost gold and each village can support a max of 15,000 troops:<br><br>";}

     

 

_{print "<font color='red'>Attacking Units:</font> <br><br>";}

 

 

_{print "<align='center'><table width='100%' class='maintable'>";}

_{print "<tr class='left'><td>";}

_{print "<img src='../images/warrior.jpg' height='100' width='75'></img></td><td>";}

_{print "You have <font color='red'>$userstats3[warr]</font> Warriors, what do you wish to do?<br>";}

_{print "Note: Warrior Attack gain is <font color='red'>50</font><br>";}

_{print "Your Current attack power is $userstats3[ovatk]<br><br>";}

_{print "<form action='buywarr.php?ID=$userstats3[iD]' method='post'>";}

_{print " <input type='text' name='warr' size='6'>";}

_{print "<input type='submit' name='submit' value='Buy Warriors'></form>";}

_{print "<form action='sellwarr.php?ID=$userstats3[iD]' method='post'>";}

_{print " <input type='text' name='warrs' size='6'>";}

_{print "<input type='submit' name='submit' value='Sell Warriors'></form></td>";}

_{print "</table></align><br>";}

 

_{include ('stats.php');}

 

 

_{print "<table class='maintable'>";}

      _{print "<tr class='headline'><td><center>Attacked!!</center></td></tr>";}

      _{print "<tr class='mainrow'><td>";}

      _{if($userstats3[numberattck]>0)}

      _{

        _{print "<font color='red'>You have survived $userstats3[numberattck] attacks since your last login.</font><br><br>";}

        _{$resets="update km_users set numberattck='0' where playername='$player'";}

        _{mysql_query($resets) or die("could not query");}

      _}

      _{print "</td></tr></table><br><br>";}

      _{$getbattlerecords="SELECT * from km_battlerecords where victimid='$userstats3[iD]'";}

      _{$getbattlerecords2=mysql_query($getbattlerecords) or die("Could not get battlerecords");}

      _{print "<table class='maintable'>";}

      _{print "<tr class='headline'><td colspan='4'><center>Battle records since last login</center></td></tr>";}

      _{print "<tr class='mainrow'><td>Attacker ID</td><td>Attacker name</td><td>Result</td><td>Land lost</td></tr>";}

      _{while($getbattlerecords3=mysql_fetch_array($getbattlerecords2))}

      _{

        _{print "<tr class='mainrow'><td>$getbattlerecords3[attid]</td><td>$getbattlerecords3[attname]</td><td>$getbattlerecords3[result]</td><td>$getbattlerecords3[landlost]</td></tr>";}

      _}

      _{print "</table><br><br>";}

      _{$delrecords="Delete from km_battlerecords where victimid='$userstats3[iD]'";}

      _{mysql_query($delrecords) or die("Could not delete battle records");}

      _{print "Sean";}

    _}

  _}

_else

  _{

    _{print "Sorry, not logged in  please <A href='login.php'>Login</a><br>";}

 

  _}

 

_?>

 

 

This is the buywarr.php

 

_<?php

 

_{include 'connect.php';}

_{session_start();}

_?>

_<center>

 

_{<iframe marginwidth="0" marginheight="0" width="468" height="60" scrolling="no" frameborder="0" src="http://rcm.amazon.com/e/cm?t=arcadeportal&p=13&o=1&l=bn1&browse=1000&mode=books&f=ifr">}

 

 

_{<MAP NAME="boxmap-p13"><AREA SHAPE="RECT" COORDS="379, 50, 460, 57" HREF="http://rcm.amazon.com/e/cm/privacy-policy.html?o=1" ><AREA COORDS="0,0,10000,10000" HREF="http://www.amazon.com/exec/obidos/redirect-home/arcadeportal" ></MAP><img src="http://rcm-images.amazon.com/images/G/01/rcm/468x60.gif" width="468" height="60" border="0" usemap="#boxmap-p13" alt="Shop at Amazon.com">}

 

 

_</iframe>

 

_{</center><br><br>}

_{<link rel="stylesheet" href="style.css" type="text/css">}

_<?php

_{if (isset($_SESSION['player']))}

  _{

    _{$player=$_SESSION['player'];}

    _{$userstats="SELECT * from km_users where playername='$player'";}

    _{$userstats2=mysql_query($userstats) or die("Could not get user stats");}

    _{$userstats3=mysql_fetch_array($userstats2);}

    _{if(isset($_POST['submit']))}

    _{

        _{$warr=$_POST['warr'];}                 

        _{$warr=strip_tags($warr);}

        _{$warrcost=2000;}

_{$warrt=$warr*50;}

_{$totalcost=$warr*$warrcost;}

        _$limit=$max;

_$max=15000;

        _{$threshold=date("U")-60*1;}   

        _{$thetime=date("U");} 

        _{print "<center>";}

        _{print "<table class='maintable'>";}

        _{print "<tr class='headline'><td><center>Tarenza Warrior Grounds</center></td></tr>";}

        _{print "<tr class='mainrow'><td>";}

        _if($warr<0)

        _{

          _{die("You cannot buy negative units");}

        _}

       

        _{else if($totalcost>$userstats3[gold])}

        _{

          _{die("You do not have that much gold, go back to <A href='index.php'>Main page</a>");}

        _}

        _{else if($warr+$userstats3[arc]+$userstats3[war]+$userstats3[pal]+$userstats3[warr]+$userstats3[bes]+$userstats3[cha]+$userstats3[ram]>$max)}

        _{

          _{die("You cannot have more than $max units per village, go back to <A href='index.php'>Main</a>");}

        _}

        _{else if($userstats3[lastaction]>$threshold)}

        _{

          _{die("You have to wait 1 minute after an attack to buy troops, go back to <A href='index.php'>Main</a>.");}

        _}

        _{else if($warr<=15000)}

        _{

          _{$getarmy="update km_users set gold=gold-'$totalcost', ovatk=ovatk+'$warrt', warr=warr+'$warr' where ID='$userstats3[iD]'";}

          _{mysql_query($getarmy) or die("Can't get Warriors");}

          _{print "$warr Warriors purchased. Go back to <A href='buyarmy.php'>Recruitment</a>.";}

        _}

        _{print "</td></tr></table>";}

 

 

 

    _}

  _}

_else

  _{

    _{print "Sorry, not logged in  please <A href='login.php'>Login</a><br>";}

 

  _}

 

_?>

 

 

My users table

 

_{users (}

  _{ID bigint(21) NOT NULL auto_increment,}

  _{playername varchar(15) NOT NULL default '',}

  _{password varchar(255) NOT NULL default '',}

  _{email varchar(255) NOT NULL default '',}

  _{ovpoints bigint(21) NOT NULL default '0',}

  _{attacked bigint(20) NOT NULL default '0',}

  _{attackers int(10) NOT NULL default '0',}

  _{fort int(10) NOT NULL default '0',}

  _{bg int(10) NOT NULL default '0',}

  _{townhall int(10) NOT NULL default '0',}

  _{smithy int(10) NOT NULL default '0',}

  _{stable int(10) NOT NULL default '0',}

  _{arena int(10) NOT NULL default '0',}

  _{tmill int(10) NOT NULL default '0',}

  _{imill int(10) NOT NULL default '0',}

  _{cmill int(10) NOT NULL default '0',}

  _{timber int(10) NOT NULL default '0',}

  _{iron int(10) NOT NULL default '0',}

  _{coal int(10) NOT NULL default '0',}

  _{warr bigint(20) NOT NULL default '0',}

  _{ram bigint(20) NOT NULL default '0',}

  _{scar bigint(20) NOT NULL default '0',}

  _{bes bigint(20) NOT NULL default '0',}

  _{cha bigint(20) NOT NULL default '0',}

  _{scout bigint(20) NOT NULL default '0',}

  _{trojan bigint(20) NOT NULL default '0',}

  _{virus bigint(20) NOT NULL default '0',}

  _{arc bigint(20) NOT NULL default '0',}

  _{warl bigint(20) NOT NULL default '0',}

  _{guar bigint(20) NOT NULL default '0',}

  _{validated int(11) NOT NULL default '0',}

  _{validkey varchar(255) NOT NULL default '',}

  _{PRIMARY KEY  (ID)}