Databases
StackOverflow2013
Postsdbo
POPHP: execute an action after a given time
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POPHP: execute an action after a given time
    primarykey
    data
    text
    <p>Good morning/afternoon/evening, Internet. I am currently developing a wap game and have encountered a problem: applying long-term effects on other players. Let me explain.</p> <p>If a user uses an 'instant' ability, it is just a normal command link that does <code>executeAbility()</code>; If a user casts a spell, the script does the following: </p> <pre><code>setPlayerState('casting'); sleep($cast_time); executeAbility(); </code></pre> <p>This is but a simple part, though. Now if we go to some more advanced techiques, like putting a curse on a player, I get lost. I've already considered the following possibility:</p> <pre><code>$time=$_SERVER['REQUEST_TIME']; $time_when_the_curse_finishes=$time+$curseDuration; updateEnemyCurses($curseID,$endTime); if ($time&lt;$endTime) removeCurse(); </code></pre> <p>This might look pretty and all, but it doesn't take two things into consideration: if the user logged off and logged back in in 2 hours, he would spend the whole two hours cursed <em>and</em> this method cannot support <em>effect every x seconds for y seconds</em> kind of curses. For example:</p> <p>Curse One. You take 1 damage every 2 seconds for 10 seconds.</p> <p>To summarise, I simply require a tip or two how I could make the line above possible. The curse itself would need to have its time checked globally (not with page reloads) and be able to complete queries (in this case damage ticks) every x seconds until it is removed in 10 seconds.</p> <p>I am thankful in advance for any tips offered here!</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USAM-
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POPHP: execute an action after a given time
      1. USgenesis
      1. VTFavorite
    2. VO
      singulars
      1. POPHP: execute an action after a given time
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POPHP: execute an action after a given time
      1. USPeter Lauris
      1. VTFavorite
    1. COI think you want a cron job...
      singulars
      1. POPHP: execute an action after a given time
      1. USthedaian
    2. COI've thought about cron jobs too, but wouldn't creating files for cron jobs every second for ~1000-4000 people online kill the servers?
      singulars
      1. POPHP: execute an action after a given time
      1. USAM-
    3. COAside: are you using PHP's "sleep()" in your script? In terms of a UX perspective, this might not be a great idea (unless this is an ajaxy call..)
      singulars
      1. POPHP: execute an action after a given time
      1. USjlb
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload