FUDforum: comp.lang.php » Hourly script

Home » Imported messages » comp.lang.php » Hourly script

Show: Today's Messages :: Polls :: Message Navigator

Re: Hourly script [message #173328 is a reply to message #173324]

Sun, 03 April 2011 15:12

Mr. B-o-B
Messages: 42
Registered: April 2011

Karma:

Member

Jerry Stuckle cried from the depths of the abyss...

> On 4/3/2011 7:03 AM, Luuk wrote:
>> On 03-04-2011 04:00, Jerry Stuckle wrote:
>>> And what happens when the script times out? Or it crashes? Or the
>>> server is rebooted? Or the host kills it because it's been running for
>>> so long? Or any of a hundred other things which can go wrong?
>>
>> The script that actually send a message (an email-message in this case)
>> should of course mark the message a being send.
>>
>> A restart of the script should skipp all messages that already have been
>> send...
>>
>>
>>
>
> And how is it to know? How is it going to keep track of messages?

This is not at all a problem. Assuming the OP has access to mysql(or
another sql db), or at least the ability to create a table in the db then
the script should create a temp table to store all the message that need
to be sent. One of the keys should be something like "message_sent".
When the script re-runs it should check for the temp table, if it exists
continue with message sending otherwise (new batch of messages ) create a
new temp table & populate with the message list.

Then in a nutshell the script will query the temp table
"SELECT * FROM temp WHERE message_sent <> 'yes'";

Start iteration on the above results.
After each message is send, update the message record to message_sent =
'yes' or however you want to mark it as flagged.

At the start of the script note the time of the script start. Calculate
endtime +59 minutes from start time. Also set a $messages_sent var to
0. Each message should ++ this var. Each iteration should check the time
first not to exceed 60 minutes or 200 messages sent.

if ($end_time >= $right_now_loop_time || $messages_sent <= 200) {
proceed to send messages
$messages_sent++
update table query to mark message as sent
}
else{
exit(0)
}

You should also incorporate a nrow check on the table into the script.
Once the last stored record(message) is processed(sent) the temp table
should be dropped & exit the script.

This entire process can of course be done using a file to store the
messages on the localfile system as well (if db not available).

> Yes, there are ways - but the op mentioned nothing about these. And if the
> script is killed, potentially hundreds of messages could go unsent.

Negative. It's not rocket science. This is not really a problem if one
takes 25 seconds to think it over. Unfortunately you only gave it a
couple seconds before you decided that the very easy is impossible.

Report message to a moderator

[Message index]

		Hourly script By: Question Boy on Sat, 02 April 2011 17:38
		Re: Hourly script By: Jerry Stuckle on Sat, 02 April 2011 17:40
		Re: Hourly script By: Question Boy on Sat, 02 April 2011 17:42
		Re: Hourly script By: Jerry Stuckle on Sat, 02 April 2011 17:56
		Re: Hourly script By: Luuk on Sat, 02 April 2011 17:54
		Re: Hourly script By: Eli the Bearded on Sat, 02 April 2011 17:58
		Re: Hourly script By: P E Schoen on Sat, 02 April 2011 20:37
		Re: Hourly script By: Mr. B-o-B on Sat, 02 April 2011 22:18
		Re: Hourly script By: Jerry Stuckle on Sun, 03 April 2011 00:09
		Re: Hourly script By: Mr. B-o-B on Sun, 03 April 2011 00:18
		Re: Hourly script By: Jerry Stuckle on Sun, 03 April 2011 02:00
		Re: Hourly script By: Luuk on Sun, 03 April 2011 11:03
		Re: Hourly script By: Jerry Stuckle on Sun, 03 April 2011 12:46
		Re: Hourly script By: Mr. B-o-B on Sun, 03 April 2011 15:12
		Re: Hourly script By: Mr. B-o-B on Sun, 03 April 2011 15:26
		Re: Hourly script By: Jerry Stuckle on Sun, 03 April 2011 18:01
		Re: Hourly script By: Mr. B-o-B on Sun, 03 April 2011 14:22
		Re: Hourly script By: Jerry Stuckle on Sun, 03 April 2011 18:09
		Re: Hourly script By: Mr. B-o-B on Sun, 03 April 2011 19:23
		Re: Hourly script By: Jerry Stuckle on Sun, 03 April 2011 20:04
		Re: Hourly script By: Mr. B-o-B on Sun, 03 April 2011 23:59
		Re: Hourly script By: Jerry Stuckle on Mon, 04 April 2011 00:49
		Re: Hourly script By: Mr. B-o-B on Mon, 04 April 2011 00:55
		Re: Hourly script By: Mr. B-o-B on Mon, 04 April 2011 00:57
		Re: Hourly script By: Jerry Stuckle on Mon, 04 April 2011 00:50
		Re: Hourly script By: Mr. B-o-B on Mon, 04 April 2011 00:56
		Re: Hourly script By: Jerry Stuckle on Mon, 04 April 2011 01:51
		Re: Hourly script By: Michael Fesser on Sun, 03 April 2011 03:02
		Re: Hourly script By: Jerry Stuckle on Sun, 03 April 2011 12:53
		Re: Hourly script By: Jerry Stuckle on Sun, 03 April 2011 00:06
		Re: Hourly script By: Jim Higgins on Sat, 02 April 2011 23:18
		Re: Hourly script By: Question Boy on Sat, 02 April 2011 23:56
		Re: Hourly script By: Captain Paralytic on Mon, 04 April 2011 13:43

Previous Topic:	Stats comp.lang.php (last 7 days)
Next Topic:	Firefox PHP error report

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 02:44:36 GMT 2024

Total time taken to generate the page: 0.04653 seconds