Databases
StackOverflow2013
Postsdbo
POOnly update messages when there is a connection
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POOnly update messages when there is a connection
    primarykey
    data
    text
    <p>I built a site display messages, so the msgloader.js updates the messages every 10 seconds from admin. The client displays this site on a screen constantly.</p> <p>The problem is that sometimes the internet connection is not so good, the display got disconnected and the msgloader.js still updates the messages, in the end the screen freeze (the reason I know is that there is a clock on the site as well, the clock gets time from the local machine, it simply freeze at a time until we refresh the page which is an issue). </p> <p>I suspect this freeze issue is because there is too much script running and the machine ram has been taken up.</p> <p>BACK TO THE QUESTION, Is there any way we can set the below code into update messages every 10 seconds when there is an internet connection, otherwise update messages every hour/two when there is no internet connection.</p> <p>Any help is appreciated. Thanks.</p> <pre><code>-------------------------------------------------------------------- Update the data for the static sections -------------------------------------------------------------------- */ function updateSection(sect) { setTimeout('updateSection(' + sect + ')', 10000); //alert('updateSection: ' + sect); var ajax = new sack(); ajax.requestFile = 'ajax/getMessages.php?section='+sect; ajax.method = 'post'; /*ajax.onError = whenError;*/ ajax.onCompletion = whenComplete; ajax.runAJAX(); /* function whenError() { alert('Could not return getMessages values. &lt;br /&gt;Please notify the system administrator.'); }*/ function whenComplete() { var messages = ajax.response; var messages1 = messages.split('---'); var num_messages = messages1[0]; //alert('Num Lines: ' + num_messages ); var messages_list = messages1[1]; //alert('MESSAGES: '+messages); var msg_data_array = messages_list.split('::'); var i=0; switch(sect) { case 1: for(i=0;i&lt;=num_messages;i++) { var j = i + 1; icon_to_use = 'icon'+j; // Set icon class var icon = document.getElementById('icon_' + sect + '_' + j); icon_to_use.className = 'icon_pointer'; // Set message text // ------------------------------------------- var msgtext_array = msg_data_array[i].split('##'); // Here's the title // ------------------------------------------- var msgtext_1a = msgtext_array[1]; // Here's the text // ------------------------------------------- var msgtext_1 = msgtext_array[2]; // Set the title space // ------------------------------------------- var msg_1a = document.getElementById('msg_text_' + sect + '_' + j + 'a'); // Set the text space // ------------------------------------------- var msg_1 = document.getElementById('msg_text_' + sect + '_' + j); // Write in the title // ------------------------------------------- msg_1a.innerHTML = msgtext_1a; msg_1.innerHTML = "&lt;img src='[url_of_image]' /&gt; " + msgtext_1; // Write in the text // ------------------------------------------- msg_1.innerHTML = (msgtext_1) ? separator + msgtext_1 : msgtext_1; //msg_1a.style.borderBottom="2px solid white"; msg_1a.style.borderBottom="2px solid white"; msg_1.style.borderBottom="2px solid white"; } break; default: break; } // DEBUG if(debug) { debugReport ( 'updateSection():ID: '+msg_id+ '&lt;br /&gt;'+'updateSection():TIMEOUT: '+timeout+ '&lt;br /&gt;'+'ROTATE: '+rotate ); } else { debugReset(); } } } /* </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USgrumpypanda
    1. USgrumpypanda
    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
    1. VO
      singulars
      1. POOnly update messages when there is a connection
      1. This table or related slice is empty.
      1. VTUpMod
    1. COIf you move the `setTimeout` into the complete handler you'll only ever have one outstanding Ajax request at a time.
      singulars
      1. POOnly update messages when there is a connection
      1. USnnnnnn
    2. COHi nnn, I tried to move it, but the js still updates the messages every 10 seconds. Is there any way I can set it update every 10 secs when there is a connection, and an hour when there is no connection? Thanks.
      singulars
      1. POOnly update messages when there is a connection
      1. USgrumpypanda
 

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