Example #1
6
 public function search($for_text)
 {
     global $search_params;
     $search_params = words($for_text);
     $wrds = array();
     foreach ($search_params as $param) {
         array_push($wrds, "stem = '{$param}'");
     }
     $word_sql = "SELECT * from words where 'join(" or ", {$wrds})'";
     global $search_words;
     $search_words = mysql_query($word_sql);
     $tables = array();
     $joins = array();
     $ids = array();
     foreach ($search_words as $w => $index) {
         array_push($tables, "locations loc{$index}");
         array_push($joins, "loc{$index}.page_id = loc({$index}+1).page_id");
         array_push($ids, "loc{$index}.word_id = {$w}.id");
     }
     array_pop($joins);
     global $common_select;
     $common_select = "from join(', ', {$tables}) where join(', ', ({$joins} + {$ids})) group by loc0.page_id";
     array_slice(rank(), 0, $searchLimit);
 }
Example #2
5
            } else {
                $output = "Invalid rank";
            }
            return $output;
        }
        $id = $_REQUEST['id'];
        $q_user = mysql_query("SELECT id, real_name, username, rank, email, info, timezone FROM {$table_admins} WHERE id = '{$id}'");
        print $header;
        while ($edit = mysql_fetch_object($q_user)) {
            if ($edit->rank == 0) {
                $rank = "";
            } else {
                $rank = '			<tr>
				<td align="right" valign="top">Rank:</td>
				<td><select name="edit_rank">
					<option value="' . $edit->rank . '">' . rank($edit->rank) . '</option>
					<option></option>
				<option value="10">Primary admin</option>
				<option value="20">Secondary admin</option>
				<option value="30">Restricted admin</option>
				<option value="40">Priviledged user</option>
				<option value="50">Normal user</option>
				<option value="60">Restricted user</option>
				</select><div class="small"><i style="color: red;">*</i>( See bottom of page for details )</div></td>
			</tr>';
            }
            print '<div class="title">Editing a user</div><br />
			<form action="admin.php?updating_user=1&amp;id=' . $edit->id . '" method="post" name="edit_user">
			<table>
			<tr>
				<td valign="top" align="right">Name:</td>
Example #3
2
function recc($num, $exc, $clst, $mstar, $mrev, $mmp)
{
    $res = rank($exc, $clst, $mstar, $mrev, $mmp);
    if (empty($res)) {
        return array();
    }
    return array_slice($res, 0, min($num, count($res)));
}
Example #4
1
        $query2 = mysql_query("SELECT * FROM `comments` WHERE `news_id`='" . $result['id'] . "' ORDER BY `id` DESC");
        $check2 = mysql_num_rows($query2);
        $avy = $result['avatar'];
        echo "Here you can view the current news.<br><table border='1' width='90%' style='border: 1px solid black;' cellpadding='1' cellspacing='1' align='center'>\n<tr><td width='90%' style='border: 1px solid black;' colspan='2'>Title: " . $result['title'] . "</td></tr>\n<tr><td width='30%' style='border: 1px solid black;'>Avatar</td><td width='60%' style='border: 1px solid black;'>News Post</td></tr>\n<tr><td width='30%' style='border: 1px solid black;'><img src='images/sprites/";
        echo $avy;
        echo ".png' alt='Avatar' /></td><td width='60%' style='border: 1px solid black;'>";
        echo parseBBCode($result['post']);
        echo "</td></tr>\n<tr><td width='30%' style='border: 1px solid black;'>Posted By</td><td width='60%' style='border: 1px solid black;'>" . $result['poster'] . "</td></tr>\n<tr><td width='30%' style='border: 1px solid black;'>Date Posted</td><td width='60%' style='border: 1px solid black;'>" . $result['date'] . "th</td></tr>\n<tr><td width='30%' style='border: 1px solid black;'>Time Posted</td><td width='60%' style='border: 1px solid black;'>" . $result['time'] . "</td></tr>\n<tr><td width='90%' style='border: 1px solid black;' colspan='2'><a href=''>News Comments (x" . $check2 . ")</a></td></tr>\n</table><br>";
        echo "<br><div id='load'><a style='cursor: pointer;' onclick=\"loadXMLDoc('postcomment.php');\">Post a Comment</a></div><br>";
        while ($row = mysql_fetch_array($query2)) {
            echo "<table border='1' width='90%' cellpadding='1' cellspacing='1' style='border: 1px solid black;' align='center'>\n<tr><td width='30%' style='border: 1px solid black;'>Post ID: #";
            echo $row['id'];
            echo "</td><td width='60%' style='border: 1px solid black;'>Posted By: ";
            echo $row['poster'];
            echo "(";
            echo rank($row['rank']);
            echo ")</td></tr>";
            if ($row['poster'] == $_SESSION['name']) {
                echo "<tr><td width='90%' style='border: 1px solid black;' colspan='2'><a href=\"?select=edit&id=" . $row['id'] . "\">Edit Comment</a></td></tr>";
            } else {
                echo "";
            }
            echo "<tr><td width='30%' style='border: 1px solid black;'><img src='images/sprites/";
            echo $row['avatar'];
            echo ".png' alt='Post Avatar' /></td><td width='60%' style='border: 1px solid black;'>";
            echo parseBBCode($row['comment']);
            echo "</td></tr></table><br>";
        }
    } else {
    }
} else {
Example #5
1
     $link6 = "<a href='battle.php?select=create&opp=" . $r6['id'] . "'>Slot 6</a>";
 } else {
     $slot6 = "images/maps/nothing.png";
     $stats6 = "Empty";
     $link6 = "Slot 6";
 }
 $sb = mysql_query("SELECT * FROM `pokemon` WHERE `owner`='" . $result['name'] . "' AND `position`='box'");
 $cb = mysql_num_rows($sb);
 echo "<table width='90%' cellpadding='1' cellspacing='1' style='border: 1px solid black;' align='center'>\n<tr><td width='90%' style='border: 1px solid black;' colspan='6'>" . $result['name'] . "'s Profile</td></tr>\n<tr><td width='90%' style='border: 1px solid black;' colspan='6'><img src=\"images/sprites/" . $result['avatar'] . ".png\" alt='Avatar' /></td></tr>\n<tr><td width='90%' style='border: 1px solid black;' colspan='6'><a href=\"trade.php?select=choose&id=" . $result['id'] . "\">Trade with " . $result['name'] . "</a></td></tr>\n<tr><td width='30%' style='border: 1px solid black;' colspan='2'>User ID</td><td width='60%' colspan='4' style='border: 1px solid black;'>#" . $result['id'] . "</td></tr>\n<tr><td width='30%' style='border: 1px solid black;' colspan='2'>User Email</td><td width='60%' style='border: 1px solid black;' colspan='4'>";
 if ($result['emailopt'] == "Show") {
     echo $result['email'];
 } else {
     echo "<i>Hidden</i>";
 }
 echo "</td></tr>\n<tr><td width='30%' colspan='2' style='border: 1px solid black;'>User Rank</td><td colspan='4' width='60%' style='border: 1px solid black;'>";
 echo rank($result['rank']);
 echo "</td></tr>\n<tr><td width='90%' colspan='6' style='border: 1px solid black;'>User Signature</td></tr>\n<tr><td width='90%' colspan='6' style='border: 1px solid black;'>";
 echo parseBBCode($result['sig']);
 echo "</td></tr>\n<tr><td width='90%' colspan='6' style='border: 1px solid black;'>User's Party</td></tr>\n<tr><td width='16%' colspan='1' style='border: 1px solid black;' onmouseover=\"gettip('{$slot1}')\" onmouseout=''>" . $link1 . "</td><td width='16%' colspan='1' style='border: 1px solid black;' onmouseover=\"gettip('{$slot2}')\" onmouseout=''>" . $link2 . "</td><td width='16%' colspan='1' style='border: 1px solid black;' onmouseover=\"gettip('{$slot3}')\" onmouseout=''>" . $link3 . "</td><td width='16%' colspan='1' style='border: 1px solid black;' onmouseover=\"gettip('{$slot4}')\" onmouseout=''>" . $link4 . "</td><td width='16%' colspan='1' style='border: 1px solid black;' onmouseover=\"gettip('{$slot5}')\" onmouseout=''>" . $link5 . "</td><td width='16%' colspan='1' style='border: 1px solid black;' onmouseover=\"gettip('{$slot6}')\" onmouseout=''>" . $link6 . "</td></tr>\n<tr><td width='16%' colspan='1' style='border: 1px solid black;'>" . $stats1 . "</td><td width='16%' colspan='1' style='border: 1px solid black;'>" . $stats2 . "</td><td width='16%' colspan='1' style='border: 1px solid black;'>" . $stats3 . "</td><td width='16%' colspan='1' style='border: 1px solid black;'>" . $stats4 . "</td><td width='16%' colspan='1' style='border: 1px solid black;'>" . $stats5 . "</td><td width='16%' colspan='1' style='border: 1px solid black;'>" . $stats6 . "</td></tr>\n<tr><td width='90%' colspan='6' style='border: 1px solid black;' id='tip' height='90'><font color='red'>Mouse over one of the slots to see which pokemon is there.</font></td></tr>\n<tr><td width='100%' colspan='6' style='border: 1px solid black;'>User Box</td></tr>\n<tr><td width='100%' colspan='6' style='border: 1px solid black;'>";
 if ($cb >= "1") {
     while ($rowb = mysql_fetch_array($sb)) {
         $sdb = mysql_query("SELECT * FROM `data` WHERE `name`='" . $rowb['name'] . "'");
         $rdb = mysql_fetch_array($sdb);
         echo "<a href='battle.php?select=create&opp=";
         echo $rowb['id'];
         echo "'><img src='images/sprites/icons/";
         echo $rdb['icon'];
         echo ".gif' alt='' onmouseover=\"Tip('";
         echo $rdb['name'];
         echo " - Level: ";
         echo $rowb['level'];
Example #6
0
function rank($parent_id)
{
    $sql = 'SELECT item_id FROM plugin_docman_item WHERE parent_id = ' . $parent_id . ' ORDER BY rank, item_id';
    $rank = 0;
    $req = mysql_query($sql) or die(mysql_error() . '<br>' . $sql);
    while ($data = mysql_fetch_assoc($req)) {
        $sql = 'UPDATE plugin_docman_item SET rank = ' . $rank++ . ' WHERE item_id = ' . $data['item_id'];
        mysql_query($sql) or die(mysql_error() . '<br>' . $sql);
        rank($data['item_id']);
    }
}
 $views = $r1['views'];
 $update = $views + 1;
 $query = mysql_query("UPDATE `posts` SET `views`='" . $update . "' WHERE `id`='" . $r1['id'] . "'");
 echo "<table width='98%' cellpadding='1' cellspacing='1' align='center' style='border: 1px solid black; text-align: left;'>\n<tr><td width='100%' style='border: 1px solid black;' colspan='2'><a href='../boards'>Index</a> --> <a href='../boards/viewforum.php?id=" . $r1['forum'] . "'>" . $r5['name'] . "</a> --> " . $r1['title'] . "</td></tr>\n<tr><td width='100%' style='border: 1px solid black;' colspan='2'>Topic: " . $r1['title'] . "</td></tr>\n<tr><th width='30%' style='border: 1px solid black;'>User Info</th><th width='60%' style='border: 1px solid black;'>Post</th></tr>\n<tr><td width='30%' style='border: 1px solid black;'><a href='../profile.php?id=" . $r2['id'] . "'><b>" . $r2['name'] . "</b></a><br>";
 echo rank($r2['rank']);
 echo "<br><img src='../images/sprites/" . $r2['avatar'] . ".png' alt='avy' /></td><td width='60%' valign='top' style='border: 1px solid black; text-align: left;'>";
 echo parseBBCode($r1['post']);
 echo "<br><br>______________<br>";
 echo parseBBCode($r2['sig']);
 echo "</td></tr></table><br><br>";
 $q3 = mysql_query("SELECT * FROM `posts` WHERE `type`='post' AND `topic`='" . $r1['id'] . "'");
 while ($row = mysql_fetch_array($q3)) {
     $q4 = mysql_query("SELECT * FROM `users` WHERE `name`='" . $row['poster'] . "'");
     $r4 = mysql_fetch_array($q4);
     echo "<table width='98%' cellpadding='1' cellspacing='1' align='center' style='border: 1px solid black; text-align: left;'>\n<tr><th width='30%' style='border: 1px solid black;'>User Info</th><th width='60%' style='border: 1px solid black;'>Post</th></tr>\n<tr><td width='30%' style='border: 1px solid black;'><a href='../profile.php?id=" . $r4['id'] . "'><b>" . $r4['name'] . "</b></a><br>";
     echo rank($r4['rank']);
     echo "<br><img src='../images/sprites/" . $r4['avatar'] . ".png' alt='avy' /></td><td width='60%' valign='top' style='border: 1px solid black; text-align: left;'>";
     echo parseBBCode($row['post']);
     echo "</td></tr></table><br><br>";
 }
 if (isset($_POST['submit'])) {
     $comment = safe($_POST['comment']);
     if ($comment == '') {
         echo "Please enter a reply.";
     } else {
         mysql_query("INSERT INTO `posts` (`poster`, `post`, `type`, `topic`, `forum`) VALUES ('" . $_SESSION['name'] . "', '" . $comment . "', 'post', '" . $r1['id'] . "', '" . $r5['id'] . "')") or die(mysql_error());
         $time = time();
         mysql_query("UPDATE `posts` SET `lastpost`='" . $time . "' WHERE `id`='" . $var . "'");
         echo "Reply posted!";
     }
 } else {
Example #8
0
<?php

require_once 'commandLine.inc';
require_once "{$IP}/extensions/wikihow/thumbratings/ThumbRatingsMaintenance.class.php";
$wgUser = User::newFromName('Votebot');
$calculationDuration = 14;
$numToCalc = 1000;
$cmd = $argv[0];
if ($cmd == "iterations") {
    numIterations();
} elseif ($cmd == "rank") {
    rank();
}
function rank()
{
    global $numToCalc, $calculationDuration;
    $trMaint = new ThumbRatingsMaintenance();
    // Set num to the number of articles to rank.  Ranks articles never ranked or ranked > 2 weeks ago
    $lowDate = wfTimestamp(TS_MW, strtotime("-{$calculationDuration} day", strtotime(date('Ymd', time()))));
    $trMaint->rankArticles($numToCalc, $lowDate);
}
// How many articles should we rank tonight assuming we process all the articles over a two week period?
// Figure out the number of iterations to call rankArticles assuming 1k articles are ranked per iteration
function numIterations()
{
    global $calculationDuration, $numToCalc;
    $totalRatedArticles = ThumbRatingsMaintenance::getRatedArticlesCount();
    echo ceil($totalRatedArticles / $calculationDuration / $numToCalc);
}
Example #9
0
function search($for_text)
{
    $search_params = words($for_text);
    $wrds = array();
    foreach ($search_params as $param) {
        $param = mysql_real_escape_string($param);
        array_push($wrds, "stem = '{$param}'");
    }
    $var1 = join(" OR ", $wrds);
    $word_sql = "SELECT * from words where {$var1}";
    global $search_words;
    $words_query = mysql_query($word_sql) or die(mysql_error());
    $num_rows = mysql_num_rows($words_query);
    if ($num_rows == 0) {
        die("<div class =\"no-results\">Lo sentimos pero no tenemos resultados para \"{$for_text}\". Por favor intenta de nuevo con otra frase o palabra clave.</div>");
    }
    $tables = array();
    $joins = array();
    $ids = array();
    $index = 0;
    while ($row = mysql_fetch_array($words_query)) {
        $search_words[$index] = $row;
        array_push($tables, "locations loc{$index}");
        $j = $index + 1;
        array_push($joins, "loc{$index}.page_id = loc{$j}.page_id");
        $w = $row['id'];
        array_push($ids, "loc{$index}.word_id = {$w}");
        $index++;
    }
    array_pop($joins);
    global $common_select;
    $var2 = join(', ', $tables);
    $var3 = join(' and ', array_merge($joins, $ids));
    $common_select = "from {$var2} where {$var3} group by loc0.page_id";
    $result = rank();
    return $result;
}
Example #10
0
<script src="diagram.js"></script>
<table>
<tr>
<td><div id=diagram_no1 style="width:750px; height:300px; background-image: url('images/judgegirl_logo_bg.gif'); background-position: center center; background-repeat: no-repeat;"></div></td>
<td>
<table style='text-align:center' border="2" cellspacing="0" cellpadding="2">
<tr><th>Rank</th><th>Count</th></tr>
<?php 
$Ranklist = array("A+", "A", "A-", "B+", "B", "B-", "C+", "C", "C-", "F");
unset($RankCnt);
foreach ($scoreFreq as $s => $c) {
    $r = rank($s);
    if ($RankCnt[$r] == NULL) {
        $RankCnt[rank($s)] = $c;
    } else {
        $RankCnt[rank($s)] += $c;
    }
}
foreach ($Ranklist as $r) {
    echo "<tr><td>{$r}</td><td>";
    if ($RankCnt[$r] == NULL) {
        echo 0;
    } else {
        echo $RankCnt[$r];
    }
    echo "</td></tr>\n";
}
?>
</table>
</td>
</tr>
Example #11
0
}
// Flush any currently open buffers.
while (ob_get_level() > 0) {
    ob_end_flush();
}
ob_start();
$gPageid = $pageData['pageid'];
$gLabel = $pageData['label'];
$gCrawlid = $pageData['crawlid'];
$url = $pageData['url'];
$urlencoded = urlencode($url);
$wptid = $pageData['wptid'];
$wptrun = $pageData['wptrun'];
$onLoad = $pageData['onLoad'];
$renderStart = $pageData['renderStart'];
$gRank = rank($url, $gPageid);
$wptServer = wptServer();
$harfileWptUrl = wptHarFileUrl($wptid, $wptrun, 0);
?>
<!doctype html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title><?php 
echo genTitle(htmlentities($url));
?>
</title>

<?php 
echo headfirst();
?>
Example #12
0
    $ServerName = mysqli_real_escape_string($BF4stats, $_GET['server']);
    echo '
	<table class="prettytable">
	<tr>
	<td class="tablecontents" colspan="6"><center>Ranks in ' . $ServerName . '</center></td>
	</tr>
	<tr>
	';
} else {
    echo '
	<table class="prettytable">
	<tr>
	<td class="tablecontents" colspan="6"><center>Ranks in ' . $clan_name . '\'s Servers</center></td>
	</tr>
	<tr>
	';
}
// if there is a ServerID, this is a server stats page
if (!empty($ServerID)) {
    // get this player's ranks
    // input as: server id, soldier, db, game id
    rank($ServerID, $valid_ids, $PlayerID, $BF4stats, $GameID);
} else {
    // get this player's ranks
    // input as: server id, soldier, db, game id
    rank($ServerID, $valid_ids, $PlayerID, $BF4stats, $GameID);
}
echo '
</tr>
</table>
';