* @license http://www.gnu.org/licenses/gpl-2.0.html GPL version 2
* @category Stud.IP
*/
class Score
{
var $score; // Score of the user
var $publik; // whether or not the score is published
var $ismyscore; // wheter or not this is my own score
var $title; // Title that refers to the score
var $myscore; // my own Score
var $mygender;
var $score_content_cache = null;
// Konstruktor
function Score($user_id)
{
$this->ismyscore = $this->CheckOwner($user_id);
if ($this->ismyscore){
$this->myscore = $this->GetMyScore();
}
$this->mygender = $this->GetGender($user_id);
$this->title = $this->gettitel($this->myscore, $this->mygender);
$this->publik = $this->CheckScore($user_id);
}
function CheckOwner($user_id)
{
global $user;
if ($user_id == $user->id)
return TRUE;
else
return FALSE;
}
function GetGender($user_id)
{
$db=new DB_Seminar;
$db->query("SELECT geschlecht AS gender FROM user_info WHERE user_id = '$user_id'");
$db->next_record();
return $db->f("gender");
}
function PublishScore()
{
global $user;
$db=new DB_Seminar;
$query = "UPDATE user_info "
." SET score = '$this->myscore'"
." WHERE user_id = '$user->id'";
$db->query($query);
$this->publik = $this->myscore;
}
function KillScore()
{
global $user;
$db=new DB_Seminar;
$query = "UPDATE user_info "
." SET score = 0"
." WHERE user_id = '$user->id'";
$db->query($query);
$this->publik = FALSE;
}
function IsMyScore()
{
return $this->ismyscore;
}
function ReturnMyScore()
{
return $this->myscore;
}
function ReturnMyTitle()
{
return $this->title;
}
function ReturnPublik()
{
return $this->publik;
}
function GetScore($user_id)
{
$db=new DB_Seminar;
$db->query("SELECT score FROM user_info WHERE user_id = '$user_id'");
$db->next_record();
return $db->f("score");
}
function CheckScore($user_id)
{
$db=new DB_Seminar;
$db->query("SELECT score FROM user_info WHERE user_id = '$user_id' AND score > 0");
if ($db->next_record())
return $db->f("score");
else
return FALSE;
}
function doRefreshScoreContentCache()
{
$db = new DB_Seminar("SELECT a.user_id,username FROM user_info a LEFT JOIN auth_user_md5 b USING (user_id) WHERE score > 0");
$s = 0;
while ($db->next_record()){
$this->score_content_cache[$db->f('user_id')]['username'] = $db->f('username');
++$s;
}
if ($s) {
$db->query("SELECT count(u.user_id) as guestcount,u.user_id FROM user_info u INNER JOIN guestbook ON(range_id=u.user_id)
WHERE score > 0 AND guestbook=1 GROUP BY u.user_id ORDER BY NULL");
while ($db->next_record()){
$this->score_content_cache[$db->f('user_id')]['guestcount'] = $db->f('guestcount');
}
$db->query("SELECT count(u.user_id) as newscount,u.user_id FROM user_info u
JOIN news_range nr ON(nr.range_id=u.user_id)
INNER JOIN news n ON nr.news_id=n.news_id
WHERE u.score > 0 AND (" . gmmktime() . "-n.date) <= n.expire
GROUP BY u.user_id
ORDER BY NULL");
while ($db->next_record()){
$this->score_content_cache[$db->f('user_id')]['newscount'] = $db->f('newscount');
}
$db->query("SELECT count(u.user_id) as eventcount,u.user_id FROM user_info u
INNER JOIN calendar_events ON (range_id=u.user_id AND class = 'PUBLIC')
WHERE score > 0 AND " . gmmktime() . " <= end
GROUP BY u.user_id ORDER BY NULL");
while ($db->next_record()){
$this->score_content_cache[$db->f('user_id')]['eventcount'] = $db->f('eventcount');
}
$db->query("SELECT count(u.user_id) AS litcount, u.user_id FROM user_info u INNER JOIN lit_list ON(range_id=u.user_id) INNER JOIN lit_list_content USING ( list_id )
WHERE score > 0 AND visibility = 1 GROUP BY u.user_id ORDER BY NULL");
while ($db->next_record()){
$this->score_content_cache[$db->f('user_id')]['litcount'] = $db->f('litcount');
}
if (get_config('VOTE_ENABLE')){
$db->query("SELECT count(u.user_id) AS votecount,u.user_id FROM user_info u INNER JOIN vote ON(range_id=u.user_id) WHERE score > 0 GROUP BY u.user_id ORDER BY NULL");
while ($db->next_record()){
$this->score_content_cache[$db->f('user_id')]['votecount'] = $db->f('votecount');
}
}
}
return true;
}
/**
*
* @param md5 $user_id
*/
function GetScoreContent($user_id)
{
if (!is_array($this->score_content_cache)){
$this->doRefreshScoreContentCache();
}
$username = $this->score_content_cache[$user_id]['username'];
if ( ($gaeste = $this->score_content_cache[$user_id]['guestcount']) !== null ) {
if ($gaeste == 1)
$tmp = _("Gästebuch mit einem Eintrag");
else
$tmp = sprintf(_("Gästebuch mit %s Einträgen"), $gaeste);
$content .= "![](\"".Assets::image_path('icons/16/blue/guestbook.png')."\")
";
} else {
$content .= "![](\"".$GLOBALS['ASSETS_URL']."images/blank.gif\")
";
}
if ( ($news = $this->score_content_cache[$user_id]['newscount']) ) {
if ($news == 1) {
$tmp = _("Eine persönliche Ankündigung");
} else {
$tmp = sprintf(_("%s persönliche Ankündigungen"), $news);
}
$content .= "![](\"".Assets::image_path('icons/16/blue/breaking-news.png')."\")
";
} else {
$content .= " ";
}
if ( ($vote = $this->score_content_cache[$user_id]['votecount']) ) {
if ($vote == 1) {
$tmp = _("Eine Umfrage");
} else {
$tmp = sprintf(_("%s Umfragen"), $vote);
}
$content .= "![](\"".Assets::image_path('icons/16/blue/vote.png')."\")
";
} else {
$content .= " ";
}
if ( ($termin = $this->score_content_cache[$user_id]['eventcount']) ) {
if ($termin == 1)
$tmp = _("Termin");
else
$tmp = _("Termine");
$content .= "![](\"".Assets::image_path('icons/16/blue/schedule.png')."\")
";
} else {
$content .= " ";
}
if ( ($lit = $this->score_content_cache[$user_id]['litcount']) ) {
if ($lit == 1)
$tmp = _("Literaturangabe");
else
$tmp = _("Literaturangaben");
$content .= "![](\"".Assets::image_path('icons/16/blue/literature.png')."\")
";
} else {
$content .= " ";
}
return $content;
}
/**
* Retrieves the titel for a given studip score
*
* @param integer a score value
* @param integer gender (0: unknown, 1: male; 2: female)
* @return string the titel
*
*/
function gettitel($score, $gender = 0)
{
if ($score)
$logscore = floor(log10($score) / log10(2));
else
$logscore = 0;
if ($logscore > 20)
$logscore = 20;
$titel[0] = array(0 => _("Unbeschriebenes Blatt"), 1 => _("Unbeschriebenes Blatt"));
$titel[1] = array(0 => _("Unbeschriebenes Blatt"), 1 => _("Unbeschriebenes Blatt"));
$titel[2] = array(0 => _("Unbeschriebenes Blatt"), 1 => _("Unbeschriebenes Blatt"));
$titel[3] = array(0 => _("Neuling"), 1 => _("Neuling"));
$titel[4] = array(0 => _("Greenhorn"), 1 => _("Greenhorn"));
$titel[5] = array(0 => _("Anfänger"), 1 => _("Anfängerin"));
$titel[6] = array(0 => _("Einsteiger"), 1 => _("Einsteigerin"));
$titel[7] = array(0 => _("Beginner"), 1 => _("Beginnerin"));
$titel[8] = array(0 => _("Novize"), 1 => _("Novizin"));
$titel[9] = array(0 => _("Fortgeschrittener"), 1 => _("Fortgeschrittene"));
$titel[10] = array(0 => _("Kenner"), 1 => _("Kennerin"));
$titel[11] = array(0 => _("Könner"), 1 => _("Könnerin"));
$titel[12] = array(0 => _("Profi"), 1 => _("Profi"));
$titel[13] = array(0 => _("Experte"), 1 => _("Expertin"));
$titel[14] = array(0 => _("Meister"), 1 => _("Meisterin"));
$titel[15] = array(0 => _("Großmeister"), 1 => _("Großmeisterin"));
$titel[16] = array(0 => _("Idol"), 1 => _("Idol"));
$titel[17] = array(0 => _("Guru"), 1 => _("Hohepriesterin"));
$titel[18] = array(0 => _("Lichtgestalt"), 1 => _("Lichtgestalt"));
$titel[19] = array(0 => _("Halbgott"), 1 => _("Halbgöttin"));
$titel[20] = array(0 => _("Gott"), 1 => _("Göttin"));
return $titel[$logscore][$gender == 2 ? 1 : 0];
}
/**
* Retrieves the score for the current user
*
* @return integer the score
*
*/
function GetMyScore()
{
global $user, $auth;
$user_id=$user->id; //damit keiner schummelt...
// Werte holen...
$db=new DB_Seminar;
$db->query("SELECT count(*) as postings FROM px_topics WHERE user_id = '$user_id' ");
$db->next_record();
$postings=$db->f("postings");
$db->query("SELECT count(*) as dokumente FROM dokumente WHERE user_id = '$user_id' AND range_id <> 'provisional' ");
$db->next_record();
$dokumente=$db->f("dokumente");
$db->query("SELECT count(*) as seminare FROM seminar_user WHERE user_id = '$user_id' ");
$db->next_record();
$seminare=$db->f("seminare");
$db->query("SELECT count(*) as archiv FROM archiv_user WHERE user_id = '$user_id' ");
$db->next_record();
$archiv=$db->f("archiv");
$db->query("SELECT count(*) as institut FROM user_inst WHERE user_id = '$user_id' ");
$db->next_record();
$institut=$db->f("institut");
$db->query("SELECT count(*) as news FROM news WHERE user_id = '$user_id' ");
$db->next_record();
$news=$db->f("news");
$db->query("SELECT count(post_id) as guestcount FROM guestbook WHERE range_id = '$user_id' ");
$db->next_record();
$gaeste = $db->f("guestcount");
$db->query("SELECT count(contact_id) as contactcount FROM contact WHERE user_id = '$user_id' ");
$db->next_record();
$contact = $db->f("contactcount");
// TODO: Count only visible categories.
$db->query("SELECT count(kategorie_id) as katcount FROM kategorien WHERE range_id = '$user_id'");
$db->next_record();
$katcount = $db->f("katcount");
if ($katcount > 50) $katcount = 50;
$db->query("SELECT mkdate FROM user_info WHERE user_id = '$user_id' ");
$db->next_record();
$age = $db->f("mkdate");
if ($age == 0) $age = 1011275740;
$age = (time()-$age)/31536000;
$age = 2 + log($age);
if ($age <1 ) $age = 1;
if (get_config('VOTE_ENABLE')) {
$db->query("SELECT count(*) FROM vote WHERE range_id = '$user_id' AND state IN('active','stopvis')");
$db->next_record();
$vote = $db->f(0)*2;
$db->query("SELECT count(*) FROM vote_user WHERE user_id = '$user_id'");
$db->next_record();
$vote += $db->f(0);
$db->query("SELECT count( DISTINCT (vote_id) )
FROM voteanswers_user
LEFT JOIN voteanswers USING ( answer_id )
WHERE user_id = '$user_id'
GROUP BY user_id");
$db->next_record();
$vote += $db->f(0);
$db->query("SELECT count(*) FROM eval WHERE author_id = '$user_id' AND startdate < UNIX_TIMESTAMP( ) AND (stopdate > UNIX_TIMESTAMP( ) OR startdate + timespan > UNIX_TIMESTAMP( ) OR (stopdate IS NULL AND timespan IS NULL))");
$db->next_record();
$vote += 2*$db->f(0);
$db->query("SELECT count(*) FROM eval_user WHERE user_id = '$user_id'");
$db->next_record();
$vote += $db->f(0);
}
if (get_config('WIKI_ENABLE')) {
$db->query("SELECT count(*) FROM wiki WHERE user_id = '$user_id'");
$db->next_record();
$wiki = $db->f(0);
}
$visits = object_return_views($user_id);
$scoreplugins = PluginEngine::getPlugins('SystemPlugin') + PluginEngine::getPlugins('StandardPlugin');
$pluginscore = 0;
$pluginscount = 0;
foreach ($scoreplugins as $scoreplugin) {
if ($scoreplugin instanceof AbstractStudIPSystemPlugin ||
$scoreplugin instanceof AbstractStudIPStandardPlugin) {
$pluginscore += $scoreplugin->getScore();
$pluginscount++;
}
}
if ($pluginscount > 0) {
$pluginscore = round($pluginscore / $pluginscount);
}
// Die HOCHGEHEIME Formel:
$score = (5*$postings) + (5*$news) + (20*$dokumente) + (2*$institut) + (10*$archiv*$age) + (10*$contact) + (20*$katcount) + (5*$seminare) + (1*$gaeste) + (5*$vote) + (5*$wiki) + (3*$visits);
$score += $pluginscore;
$score = round($score/$age);
if (Avatar::getAvatar($user_id)->is_customized()) {
$score *=10;
}
//Schreiben des neuen Wertes
$query = "UPDATE user_info "
." SET score = '$score'"
." WHERE user_id = '$user_id' AND score > 0";
$db->query($query);
return $score;
}
}