".date("H:i",strtotime($content["lastmodified"]))." | encode($content["keyword"])."">".($content["title"] == "" ? $content["keyword"] : $content["title"])." | 22.393 $sql = "SELECT keyword, MAX(id) AS id FROM ".$xoopsDB->prefix("wiwimod")." WHERE lastmodified<'".date("Y-m-d H:i:s", time() - 61 * 24 * 3600)."' GROUP BY keyword";
Probably the only one I would hesitate to change is the last one preceded by "$sql", and it may be ok to change it. Perhaps someone else who knows better will say.
Good luck!
...
3
Just going for the "Lazarus Award for Resurected Threads" for this month Just got two things to say: 1. "Thanks jfmoore" - seriously, you saved me a lot of searching ![](https://xoops.org/uploads/smil3dbd4d6422f04.gif) 2. "Eek!" jfmoore was correct about the files and places to amend the date format. Having just FUBARed my wiwimod tables in the db I should like to amend the advice above to the following: --------------------------- Index.php - 13.708 bytes - Fri, 24.06.05 at 15:45 - Wiwimod 12.040 'lastmodified' => date("d.m.y", strtotime($pageObj->lastmodified)), --------------------------- Wiwipdf.php - 4.427 bytes - Fri, 08.04.05 at 11:05 - Wiwimod 1.690 'lastmodified' => date("d.m.y", strtotime($pageObj->lastmodified)), --------------------------- listpages.php - 6.124 bytes - Mon, 16.05.05 at 22:05 - WiwimodAdmin 5.278 <td>'.date("d.m.y", @strtotime($pageArr[$i]->lastmodified)).'td> --------------------------- wiwimod_recent.php - 1.443 bytes - Tue, 07.06.05 at 22:30 - WiwimodBlocks 1.035 $link['lastmodified'] = date("d.m.y", strtotime($content["lastmodified"])); --------------------------- wiwimod_showpage.php - 3.501 bytes - Tue, 10.05.05 at 22:41 - WiwimodBlocks 1.700 $block['lastmodified'] = date("d.m.y", strtotime($pageObj->lastmodified)); 2.835 $block['lastmodified'] = date("d.m.y", strtotime($pageObj->lastmodified)); --------------------------- wiwiRevision.class.php - 24.872 bytes - Tue, 07.06.05 at 18:47 - WiwimodClass 3.811 [color=FF0000]date("Y-m-d H:i:s")[/color], //-- lastmodified is Now 4.834 [color=FF0000]date("Y-m-d H:i:s")[/color], 13.360 '"".date("d.m.y", strtotime($counter))." | "', 13.442 '" ".date("H:i",strtotime($content["lastmodified"]))." | encode($content["keyword"])."">".($content["title"] == "" ? $content["keyword"] : $content["title"])." | 22.393 $sql = "SELECT keyword, MAX(id) AS id FROM ".$xoopsDB->prefix("wiwimod")." WHERE lastmodified<'".[color=FF0000]date("Y-m-d H:i:s"[/color], time() - 61 * 24 * 3600)."' GROUP BY keyword";
Do not under any circumstances alter the three instances of code written in red type as this will alter the way that the "last update date" is written to the database. Trust me, you do not want to see what happens if you do
It's okay to change all of the others, though ![](https://xoops.org/uploads/smil3dbd4d6422f04.gif)
TFF backups
341 user(s) are online (123 user(s) are browsing Support Forums)
Members: 0
Guests: 341
more...
Stats |
Goal: |
$100.00 |
Due Date: |
Aug 31 |
Gross Amount: |
$0.00 |
Net Balance: |
$0.00 |
Left to go: |
$100.00 |
|
| |