Revision history for Mod024fHighScores


Revision [23259]

Last edited on 2016-05-20 07:38:47 by JavaWoman [Replaces old-style internal links with new pipe-split links.]
Additions:
**[[http://web.archive.org/web/20040820215257/http://www.wakkawiki.com/ChrisTessmer | ChrisTessmer]]**
[[http://web.archive.org/web/20040820214927/http://www.wakkawiki.com/HighScores | HighScores @ WakkaWiki]]
You can see this [[http://web.archive.org/web/20040811013910/http://www.wakkawiki.com/WakkaActions | WakkaAction]] in action at [[http://web.archive.org/web/20040821064554/http://christessmer.com/ahd/wiki/wakka.php?wakka=HighScores | http://christessmer.com/ahd/wiki/wakka.php?wakka=HighScores]] //(archived)//
-- [[http://web.archive.org/web/20040820215257/http://www.wakkawiki.com/ChrisTessmer | ChrisTessmer]]
Deletions:
**[[http://web.archive.org/web/20040820215257/http://www.wakkawiki.com/ChrisTessmer ChrisTessmer]]**
[[http://web.archive.org/web/20040820214927/http://www.wakkawiki.com/HighScores HighScores @ WakkaWiki]]
You can see this [[http://web.archive.org/web/20040811013910/http://www.wakkawiki.com/WakkaActions WakkaAction]] in action at [[http://web.archive.org/web/20040821064554/http://christessmer.com/ahd/wiki/wakka.php?wakka=HighScores http://christessmer.com/ahd/wiki/wakka.php?wakka=HighScores]] //(archived)//
-- [[http://web.archive.org/web/20040820215257/http://www.wakkawiki.com/ChrisTessmer ChrisTessmer]]

Revision [19279]

Edited on 2008-01-28 00:14:45 by JavaWoman [Modified links pointing to docs server]

No Differences

Revision [17199]

Edited on 2007-07-07 13:59:05 by JavaWoman [standardized link to WakkaWiki origin]
Additions:
**[[http://web.archive.org/web/20040820215257/http://www.wakkawiki.com/ChrisTessmer ChrisTessmer]]**
[[http://web.archive.org/web/20040820214927/http://www.wakkawiki.com/HighScores HighScores @ WakkaWiki]]
Deletions:
[[http://web.archive.org/web/20040820215257/http://www.wakkawiki.com/ChrisTessmer ChrisTessmer]]
[[http://web.archive.org/web/20040820214927/http://www.wakkawiki.com/HighScores Wakka Wiki HighScores]]

Revision [17164]

Edited on 2007-07-07 07:06:07 by JavaWoman [web.archive.org link for christessmer.com]
Additions:
You can see this [[http://web.archive.org/web/20040811013910/http://www.wakkawiki.com/WakkaActions WakkaAction]] in action at [[http://web.archive.org/web/20040821064554/http://christessmer.com/ahd/wiki/wakka.php?wakka=HighScores http://christessmer.com/ahd/wiki/wakka.php?wakka=HighScores]] //(archived)//
~&This wiki is no longer publicly accessible; the only access I could get was at the root: http://christessmer.com/; link changed to archived version --JavaWoman
Deletions:
You can see this [[WakkaActions WakkaAction]] in action at [[http://christessmer.com/ahd/wiki/wakka.php?wakka=HighScores]]
~&This wiki is no longer publicly accessible; the only access I could get was at the root: http://christessmer.com/ --JavaWoman

Revision [17159]

Edited on 2007-07-07 06:40:32 by JavaWoman [web.archive.org links for wakkawiki.com]
Additions:
[[http://web.archive.org/web/20040820215257/http://www.wakkawiki.com/ChrisTessmer ChrisTessmer]]
[[http://web.archive.org/web/20040820214927/http://www.wakkawiki.com/HighScores Wakka Wiki HighScores]]
Deletions:
Chris Tessmer
[[http://web.archive.org/web/20030304203213/http://www.wakkawiki.com/HighScores Wakka Wiki HighScores]]

Revision [17136]

Edited on 2007-07-07 03:28:31 by JavaWoman [archive.org wakkawiki links]
Additions:
[[http://web.archive.org/web/20030304203213/http://www.wakkawiki.com/HighScores Wakka Wiki HighScores]]
-- [[http://web.archive.org/web/20040820215257/http://www.wakkawiki.com/ChrisTessmer ChrisTessmer]]
Deletions:
http://www.wakkawiki.com/HighScores
-- ChrisTessmer

Revision [17135]

Edited on 2007-07-07 03:15:30 by JavaWoman [added note about Chris Tessmer's site]
Additions:
~&This wiki is no longer publicly accessible; the only access I could get was at the root: http://christessmer.com/ --JavaWoman

Revision [16963]

Edited on 2007-05-31 23:27:31 by JsnX [Reverted]
Additions:
2) The table formatting I used is pretty wretched //( 's .. yuck!)//; I just wanted results, //fast//. If anyone wants to make it cleaner or prettier (like using the CSS of the site to generate attractive alternating colored rows or something), by all means... GoForIt.
== Here's how to install it: ==
Create ''actions/highscores.php'':
%%(php)
<?php
# highscores.php {{HighScores}}
# by Chris Tessmer
# 19 Dec 2002
# license: GPL
$str = 'SELECT Count(*) AS cnt, `name` FROM ';
$str .= $this->config["table_prefix"] . 'users, ' ;
$str .= $this->config["table_prefix"].'pages ';
$str .= "WHERE `name` = `owner` AND `latest` = 'Y' AND `comment_on` = '' GROUP BY name ORDER BY cnt DESC;";
$rankQuery = $this->Query( $str );
$str = 'SELECT COUNT(*) FROM '.$this->config["table_prefix"].'pages WHERE `latest` = \'Y\' AND `comment_on` = \'\' ';
$totalQuery = $this->Query( $str );
$total = mysql_result($totalQuery, 0);
print( "<blockquote><table>" );
$i = 0;
while( $row = mysql_fetch_array($rankQuery) )
{
$i++;
$str = '<tr>';
$str .= "<td>$i.  </td>";
$str .= '<td>'. $this->Format( $row["name"] ) .'</td>';
$str .= '<td> </td>';
$str .= '<td>    </td>';
$str .= '<td>'.$row["cnt"].'</td>';
$str .= '<td>    </td>';
$str .= '<td>'. round( ($row["cnt"]/$total)*100, 2).'% </td>';
$str .= '</tr>';
print( $str );
}
print( "</table></blockquote>" );
?>
%%
To use it, insert the text ##""{{HighScores}}""## into any page that you want the list to show up in.
-- ChrisTessmer
Ranking by bytes: change count(*) by sum(length(body)) in SQL queries..
-- VictorManuelVarela (2003-03-13 23:47:36)
Deletions:
2) The table formatting I used is pretty wretched //(

Revision [16762]

Edited on 2007-05-31 10:45:04 by EqeQwp [Reverted]
Additions:
2) The table formatting I used is pretty wretched //(
Deletions:
2) The table formatting I used is pretty wretched //( 's .. yuck!)//; I just wanted results, //fast//. If anyone wants to make it cleaner or prettier (like using the CSS of the site to generate attractive alternating colored rows or something), by all means... GoForIt.
== Here's how to install it: ==
Create ''actions/highscores.php'':
%%(php)
<?php
# highscores.php {{HighScores}}
# by Chris Tessmer
# 19 Dec 2002
# license: GPL
$str = 'SELECT Count(*) AS cnt, `name` FROM ';
$str .= $this->config["table_prefix"] . 'users, ' ;
$str .= $this->config["table_prefix"].'pages ';
$str .= "WHERE `name` = `owner` AND `latest` = 'Y' AND `comment_on` = '' GROUP BY name ORDER BY cnt DESC;";
$rankQuery = $this->Query( $str );
$str = 'SELECT COUNT(*) FROM '.$this->config["table_prefix"].'pages WHERE `latest` = \'Y\' AND `comment_on` = \'\' ';
$totalQuery = $this->Query( $str );
$total = mysql_result($totalQuery, 0);
print( "<blockquote><table>" );
$i = 0;
while( $row = mysql_fetch_array($rankQuery) )
{
$i++;
$str = '<tr>';
$str .= "<td>$i.  </td>";
$str .= '<td>'. $this->Format( $row["name"] ) .'</td>';
$str .= '<td> </td>';
$str .= '<td>    </td>';
$str .= '<td>'.$row["cnt"].'</td>';
$str .= '<td>    </td>';
$str .= '<td>'. round( ($row["cnt"]/$total)*100, 2).'% </td>';
$str .= '</tr>';
print( $str );
}
print( "</table></blockquote>" );
?>
%%
To use it, insert the text ##""{{HighScores}}""## into any page that you want the list to show up in.
-- ChrisTessmer
Ranking by bytes: change count(*) by sum(length(body)) in SQL queries..
-- VictorManuelVarela (2003-03-13 23:47:36)

Revision [127]

The oldest known version of this page was created on 2004-04-04 23:28:16 by JsnX [Reverted]
Valid XHTML :: Valid CSS: :: Powered by WikkaWiki