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 #173329 is a reply to message #173328]

Sun, 03 April 2011 15:26

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

Karma:

Member

On 4/3/2011 10:12 AM, Mr. B-o-B cried from the depths of the abyss:
> 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)
> }
>

My Bad. This should actually be && and not ||

> 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: Fri Sep 20 19:16:32 GMT 2024

Total time taken to generate the page: 0.04782 seconds