XoopsModules25x /
smallworld
| @@ 29-43 (lines=15) @@ | ||
| 26 | * Get oldest message in Db |
|
| 27 | * @returns time |
|
| 28 | */ |
|
| 29 | public function oldestMsg() |
|
| 30 | { |
|
| 31 | global $xoopsDB; |
|
| 32 | $date = 0; |
|
| 33 | $sql = 'SELECT * FROM ' . $xoopsDB->prefix('smallworld_messages') . ' ORDER BY created LIMIT 1'; |
|
| 34 | $result = $xoopsDB->queryF($sql); |
|
| 35 | $counter = $xoopsDB->getRowsNum($result); |
|
| 36 | if ($counter >= 1) { |
|
| 37 | while ($sqlfetch = $xoopsDB->fetchArray($result)) { |
|
| 38 | $date = $sqlfetch['created']; |
|
| 39 | } |
|
| 40 | } |
|
| 41 | ||
| 42 | return $date; |
|
| 43 | } |
|
| 44 | ||
| 45 | /** |
|
| 46 | * Get average messages sent per day |
|
| @@ 488-501 (lines=14) @@ | ||
| 485 | * Get version number of xim if exists |
|
| 486 | * @return int $version |
|
| 487 | */ |
|
| 488 | function smallworld_XIMversion() |
|
| 489 | { |
|
| 490 | global $xoopsDB; |
|
| 491 | $sql = 'SELECT version FROM ' . $xoopsDB->prefix('modules') . " WHERE dirname = 'xim'"; |
|
| 492 | $result = $xoopsDB->queryF($sql); |
|
| 493 | if ($xoopsDB->getRowsNum($result) > 0) { |
|
| 494 | while ($r = $xoopsDB->fetchArray($result)) { |
|
| 495 | $version = $r['version']; |
|
| 496 | } |
|
| 497 | } else { |
|
| 498 | $version = 0; |
|
| 499 | } |
|
| 500 | return $version; |
|
| 501 | } |
|
| 502 | ||
| 503 | /* |
|
| 504 | * Input: Message Id, |
|
