function loadSQLData() { global $database; $sqlLines = explode("\n", file_get_contents("modules/ChapADay.sql")); for ($index = 0; $index < sizeof($sqlLines); $index++) { $sql = $sqlLines[$index]; $database->setQuery($sql); $database->query(); } } function getTodaysMessageText() { global $database; $database->setQuery("select message " . "from jos_bible_chap_a_day " . "where id = (select min(id)+mod(TO_DAYS(NOW())+795, count(*)) messageId " . "from jos_bible_chap_a_day)"); $rows = $database->loadObjectList(); if ($rows) { return $rows[0]->message; } else { return null; } } $message = getTodaysMessageText(); if ($message == null) { loadSQLData(); $message = getTodaysMessageText(); } echo "<div align=center>" . textBibleReferencesToLinks($message) . "</div>"; ?> <address>por Norman Berry - 1911-2001</address>
/** */ function botMosBibleRef($published, &$row, &$params, $page = 0) { $row->text = textBibleReferencesToLinks($row->text); return true; }