I have the solution!
"ORDER BY gbdate"
means arder a string value ASC or DESC.
In Sept 2001 the length of the Unix-timestamp changed...
All you have to do:
take your easybook.php (components/com_easybook) and replace the existing code from line 475 with the following code:
$date_format = '%Y%m%d';
# Modified by Thomas Mader - Beginn
if ($is_editor) {
$database->setQuery( "SELECT *, FROM_UNIXTIME( gbdate, '".$date_format."') AS newdate FROM #__easybook"
. "\nORDER BY newdate $eb_sorting"
. "\nLIMIT $start,$eb_perpage"
/*
$database->setQuery( "SELECT * FROM #__easybook"
. "\nORDER BY gbdate $eb_sorting"
. "\nLIMIT $start,$eb_perpage" */
);
} else {
$database->setQuery( "SELECT *, FROM_UNIXTIME( gbdate, '".$date_format."') AS newdate FROM #__easybook"
. "\nWHERE published = 1"
. "\nORDER BY newdate $eb_sorting"
. "\nLIMIT $start,$eb_perpage"
/*
$database->setQuery( "SELECT * FROM #__easybook"
. "\nWHERE published = 1"
. "\nORDER BY gbdate $eb_sorting"
. "\nLIMIT $start,$eb_perpage"
*/
);
Hi again,
I tried to change the cource-code again, cause with a new editor i found the correct part to be changed. but after that, the guestbook didn't work any more, there's the following error:
Parse error: syntax error, unexpected $end in /srv/www/htdocs/web228/html/planetflorida/components/com_easybook/easybook.php on line 746
Line 746 is the last line with "?>".
Any idea, what's the problem?
UPDATE:
Found a solution, but don't ask me, what the problem was. I now use notepad++ as editor, and with this I easily found the correct line for making the changes. At the first, I deleted the old code and pasted the new one completely, containing the old code as comments. Didn't work. Now I took a close look at the differences between new and old code and just changed the parts that have changed. What I got for me looked the same as the first procedure, just the comments are missing. Don't find any other difference, but now it works. If you have problems by changing the code too, try it this way, may be it will work at you too.