+<<<<<<< HEAD
<?php\r
/*\r
* Nucleus: PHP/MySQL Weblog CMS (http://nucleuscms.org/)\r
// these methods shouldn't be called directly\r
function readFromDatabase() {\r
$query = 'SELECT ikarmapos, ikarmaneg FROM '.sql_table('item').' WHERE inumber=' . $this->itemid;\r
- $res = sql_query($query);\r
- $obj = sql_fetch_object($res);\r
+ $res = DB::getRow($query);\r
\r
- $this->karmapos = $obj->ikarmapos;\r
- $this->karmaneg = $obj->ikarmaneg;\r
+ $this->karmapos = $res['ikarmapos'];\r
+ $this->karmaneg = $res['ikarmaneg'];\r
$this->inforead = 1;\r
}\r
\r
\r
function writeToDatabase() {\r
$query = 'UPDATE '.sql_table('item').' SET ikarmapos=' . $this->karmapos . ', ikarmaneg='.$this->karmaneg.' WHERE inumber=' . $this->itemid;\r
- sql_query($query);\r
+ DB::execute($query);\r
}\r
\r
// checks if a vote is still allowed for an IP\r
function isVoteAllowed($ip) {\r
- $query = 'SELECT * FROM '.sql_table('karma')." WHERE itemid=$this->itemid and ip='".sql_real_escape_string($ip)."'";\r
- $res = sql_query($query);\r
- return (sql_num_rows($res) == 0);\r
+ $query = 'SELECT * FROM '.sql_table('karma')." WHERE itemid={$this->itemid} and ip=". DB::quoteValue($ip);\r
+ $res = DB::getResult($query);\r
+ return ($res->rowCount() == 0);\r
}\r
\r
// save IP in database so no multiple votes are possible\r
function saveIP() {\r
- $query = 'INSERT INTO '.sql_table('karma').' (itemid, ip) VALUES ('.$this->itemid.",'".sql_real_escape_string(serverVar('REMOTE_ADDR'))."')";\r
- sql_query($query);\r
+ $query = 'INSERT INTO ' . sql_table('karma') .' (itemid, ip) VALUES (' . $this->itemid . ','. DB::quoteValue(serverVar('REMOTE_ADDR')) .')';\r
+ DB::execute($query);\r
}\r
}\r
\r
?>\r
+=======
+<?php
+/*
+ * Nucleus: PHP/MySQL Weblog CMS (http://nucleuscms.org/)
+ * Copyright (C) 2002-2009 The Nucleus Group
+ *
+ * This program is free software; you can redistribute it and/or
+ * modify it under the terms of the GNU General Public License
+ * as published by the Free Software Foundation; either version 2
+ * of the License, or (at your option) any later version.
+ * (see nucleus/documentation/index.html#license for more info)
+ */
+/**
+ * Class representing the karma votes for a certain item
+ *
+ * @license http://nucleuscms.org/license.txt GNU General Public License
+ * @copyright Copyright (C) 2002-2009 The Nucleus Group
+ * @version $Id: KARMA.php 1812 2012-05-01 14:59:07Z sakamocchi $
+ */
+class Karma
+{
+ // id of item about which this object contains information
+ var $itemid;
+
+ // indicates if the karma vote info has already been intialized from the DB
+ var $inforead;
+
+ // amount of positive/negative votes
+ var $karmapos;
+ var $karmaneg;
+
+ function KARMA($itemid, $initpos = 0, $initneg = 0, $initread = 0) {
+ // itemid
+ $this->itemid = intval($itemid);
+
+ // have we read the karma info yet?
+ $this->inforead = intval($initread);
+
+ // number of positive and negative votes
+ $this->karmapos = intval($initpos);
+ $this->karmaneg = intval($initneg);
+ }
+
+ function getNbPosVotes() {
+ if (!$this->inforead) $this->readFromDatabase();
+ return $this->karmapos;
+ }
+ function getNbNegVotes() {
+ if (!$this->inforead) $this->readFromDatabase();
+ return $this->karmaneg;
+ }
+ function getNbOfVotes() {
+ if (!$this->inforead) $this->readFromDatabase();
+ return ($this->karmapos + $this->karmaneg);
+ }
+ function getTotalScore() {
+ if (!$this->inforead) $this->readFromDatabase();
+ return ($this->karmapos - $this->karmaneg);
+ }
+
+ function setNbPosVotes($val) {
+ $this->karmapos = intval($val);
+ }
+ function setNbNegVotes($val) {
+ $this->karmaneg = intval($val);
+ }
+
+
+ // adds a positive vote
+ function votePositive() {
+ $newKarma = $this->getNbPosVotes() + 1;
+ $this->setNbPosVotes($newKarma);
+ $this->writeToDatabase();
+ $this->saveIP();
+ }
+
+ // adds a negative vote
+ function voteNegative() {
+ $newKarma = $this->getNbNegVotes() + 1;
+ $this->setNbNegVotes($newKarma);
+ $this->writeToDatabase();
+ $this->saveIP();
+ }
+
+
+
+ // these methods shouldn't be called directly
+ function readFromDatabase() {
+ $query = 'SELECT ikarmapos, ikarmaneg FROM '.sql_table('item').' WHERE inumber=' . $this->itemid;
+ $res = DB::getRow($query);
+
+ $this->karmapos = $res['ikarmapos'];
+ $this->karmaneg = $res['ikarmaneg'];
+ $this->inforead = 1;
+ }
+
+
+ function writeToDatabase() {
+ $query = 'UPDATE '.sql_table('item').' SET ikarmapos=' . $this->karmapos . ', ikarmaneg='.$this->karmaneg.' WHERE inumber=' . $this->itemid;
+ DB::execute($query);
+ }
+
+ // checks if a vote is still allowed for an IP
+ function isVoteAllowed($ip) {
+ $query = 'SELECT * FROM '.sql_table('karma')." WHERE itemid={$this->itemid} and ip=". DB::quoteValue($ip);
+ $res = DB::getResult($query);
+ return ($res->rowCount() == 0);
+ }
+
+ // save IP in database so no multiple votes are possible
+ function saveIP() {
+ $query = 'INSERT INTO ' . sql_table('karma') .' (itemid, ip) VALUES (' . $this->itemid . ','. DB::quoteValue(serverVar('REMOTE_ADDR')) .')';
+ DB::execute($query);
+ }
+}
+
+?>
+>>>>>>> skinnable-master