[REQUEST] Small Error Log Mod

[Joseph Fung]

Could someone slap this together for me?

I need to have a mod to split the error log into multiple pages (only 30 to 50 entries per page).

I did this for the SE2 code I put together, but I don't have the time to really put it together for a 1.4 board, and I really want it here  I just had to wait over a minute to load yabb.info's error log.

[Chris Cromer]

Open Errors.php and search for:

Code Select Expand

   global $db_prefix,$cgi,$txt,$imagesdir,$color,$yytitle;
and replace it with:

Code Select Expand

   global $db_prefix,$cgi,$txt,$imagesdir,$color,$yytitle,$page;
Then look for:

Code Select Expand

   $request = mysql_query("SELECT ID_ERROR,IP,url,memberName,logTime,message FROM {$db_prefix}log_errors ORDER BY logTime");
   print<<<EOT
The replace it with this:

Code Select Expand

       $page = ($page == '0' || $page == '')?'1':$page;
        $ammount = ($page*30)-30;

        $request = mysql_query("SELECT COUNT(*) as error_count FROM {$db_prefix}log_errors");
        $error_count = mysql_fetch_array($request);
        $errors = ceil($error_count[error_count]/30);
        $counter = '1';
        while ($errors != '0') {
                if ($page == $counter) {
                        $pages .= " [$page]";
                }
                else {
                        $pages .= " <a href=\"$scripturl?action=viewErrorLog;page=$counter\">$counter</a>";
                }
                $errors--;
                $counter++;
        }

   $request = mysql_query("SELECT ID_ERROR,IP,url,memberName,logTime,message FROM {$db_prefix}log_errors ORDER BY logTime LIMIT $ammount,30");
   print<<<EOT
<b>Pages:</b> $pages
I used 30 as the number of how many errors on each page.

[Nemesis]

Chris I tested this on my board, it stop at 30 and wouldnt give me an next page... FYI

[Chris Cromer]

Found the problem it was with the mysql_num_rows part, I changed the code above and it works now.

I attached a picture so you can see it.

[Gobalopper]

How about a way to sort by error type?

[Chris Cromer]

As Joseph said:

slap this together

I am not making a full mod out of this, just some quick code to make pages.

[Nemesis]

Okay I tested it, works great, good job Chris.

Joseph I already did changes for you here at YaBB.info

I backup Error.php to Error.old, Since I don't have access to admin to test it. Then upload the changed Error.php to Chris code.  

[Joseph Fung]

test

[Joseph Fung]

test

[Nemesis]

Nice mod you added Joseph.