Sourcecode in Global/objectFunctions.js:
1: function pingUpdatedSites() {
2: var c = getDBConnection("antville");
3: var dbError = c.getLastError();
4: if (dbError) {
5: app.log("Error establishing DB connection: " + dbError);
6: return;
7: }
8:
9: var query = "select SITE_ALIAS from AV_SITE where SITE_ISONLINE = 1 and SITE_ENABLEPING = 1 and (SITE_LASTUPDATE > SITE_LASTPING or SITE_LASTPING is null)";
10: var rows = c.executeRetrieval(query);
11: var dbError = c.getLastError();
12: if (dbError) {
13: app.log("Error executing SQL query: " + dbError);
14: return;
15: }
16:
17: while (rows.next()) {
18: var site = root.get(rows.getColumnItem("SITE_ALIAS"));
19: app.log("Notifying weblogs.com for updated site '" + site.alias + "' (id " + site._id + ")");
20: site.ping();
21: }
22:
23: rows.release();
24: return;
25: }
|