public function testSaveBlankRecord()
{
$user = new MyUser();
$user->state('TDIRTY');
$user->save();
$this->assertTrue(isset($user['id']) && $user['id']);
}
*/
class Badges
{
public static $badgelist = array(1 => array("title" => "Autobiograph", "medal" => 3, "desc" => "Hat sein Benutzerprofil vervollständigt", "key" => "b%b_u%u"), 2 => array("title" => "Bürgerpolizist", "medal" => 3, "desc" => "Hat einen Beitrag gemeldet", "key" => "b%b_u%u"), 3 => array("title" => "Schreiberling", "medal" => 3, "desc" => "Hat die erste Frage gestellt", "key" => "b%b_u%u"), 4 => array("title" => "Helfer", "medal" => 3, "desc" => "Hat die erste Antwort geschrieben", "key" => "b%b_u%u"), 5 => array("title" => "Blabberer", "medal" => 3, "desc" => "Hat die erste Kommentar geschrieben", "key" => "b%b_u%u"), 6 => array("title" => "Callboy", "medal" => 3, "desc" => "Hilft Usern auch über Skype", "key" => "b%b_u%u"), 9 => array("title" => "Kritiker", "medal" => 3, "desc" => "Bewertete einen Beitrag negativ / downvote", "key" => "b%b_u%u"), 10 => array("title" => "Redakteur", "medal" => 3, "desc" => "Editiere einen Beitrag", "key" => "b%b_u%u"), 21 => array("title" => "Elementare Frage", "medal" => 1, "desc" => "Stellte eine Frage mit mindestens 500 Views", "key" => "b%b_u%u_q%q"), 24 => array("title" => "Gute Frage", "medal" => 2, "desc" => "Frage wurde mindestens 3mal positiv bewertet / upvoted", "key" => "b%b_u%u_q%q"), 31 => array("title" => "Wichtige Frage", "medal" => 2, "desc" => "Stellte eine Frage mit mindestens 250 Views", "key" => "b%b_u%u_q%q"), 41 => array("title" => "Populäre Frage", "medal" => 3, "desc" => "Stellte eine Frage mit mindestens 150 Views", "key" => "b%b_u%u_q%q"), 51 => array("title" => "Tolle Antwort", "medal" => 3, "desc" => "Antwort wurde 3mal positiv bewertet / upvoted", "key" => "b%b_u%u_a%a"), 52 => array("title" => "Gute Antwort", "medal" => 2, "desc" => "Antwort wurde 10mal positiv bewertet / upvoted", "key" => "b%b_u%u_a%a"), 53 => array("title" => "Großartige Antwort", "medal" => 1, "desc" => "Antwort wurde 25mal positiv bewertet / upvoted", "key" => "b%b_u%u_a%a"));
public static function add($badge, $user = null, $data = array())
{
if ($user == null) {
$user = MyUser::id();
}
if (!isset(self::$badgelist[$badge + 0])) {
throw new Exception("Badge existiert nicht! (" . ($badge + 0) . ")");
}
$binfo = self::$badgelist[$badge + 0];
$db = new SQL(0);
$w = array();
$w["keyID"] = $binfo["key"];
$w["keyID"] = str_replace(array("%b", "%u", "%q", "%a"), array($badge + 0, $user + 0, isset($data["question"]) ? $data["question"] : 0, isset($data["answer"]) ? $data["answer"] : 0), $w["keyID"]);
$w["user"] = $user + 0;
$w["badge"] = $badge + 0;
$w["medal"] = $binfo["medal"];
$w["dt_received"] = time();
if (isset($data["question"])) {
$w["question"] = $data["question"] + 0;
}
$db->CreateUpdate(0, 'user_badges', $w);
switch ($w["medal"]) {
case 1:
$db->cmd(0, 'UPDATE LOW_PRIORITY IGNORE user_list as T1 SET award_gold = (SELECT count(*) FROM user_badges WHERE user= T1.id AND medal=1) WHERE id={0} LIMIT 1', true, array($w["user"]));
break;
case 2:
$db->cmd(0, 'UPDATE LOW_PRIORITY IGNORE user_list as T1 SET award_silver = (SELECT count(*) FROM user_badges WHERE user= T1.id AND medal=2) WHERE id={0} LIMIT 1', true, array($w["user"]));
break;
case 3:
$db->cmd(0, 'UPDATE LOW_PRIORITY IGNORE user_list as T1 SET award_bronce = (SELECT count(*) FROM user_badges WHERE user= T1.id AND medal=3) WHERE id={0} LIMIT 1', true, array($w["user"]));
public static function allread($data)
{
if (!MyUser::isloggedin()) {
throw new APIException("Nicht angemeldet...", 100);
}
$db = new SQL(0);
$db->cmd(0, 'DELETE * FROM user_notification WHERE user = {0}', true, array(MyUser::id()));
return true;
}
?>
</span></a>
)
</span>
<a class="logout" href="<?php
echo get_path("/account/signout");
?>
"><?php
echo _e("logout");
?>
</a>
<?php
} else {
?>
<a class="gotologin" href="<?php
echo get_path("/account/signin");
?>
"><?php
echo _e("Hello, please register");
?>
</a>
<?php
}
?>
<a class="help" href="<?php
echo get_path("/help");
?>
" title="<?php
echo _e("help");
?>
"><?php
public static function CountNew()
{
$db = new SQL(0);
$v = $db->cmdvalue(0, 'SELECT count(*) as Anzahl FROM mails WHERE to_user={0} AND is_read="0" LIMIT 0,1', array(MyUser::id()));
return $v + 0;
}
public function mormTearDown()
{
$this->sql->queryDB(MyUser::dropTable());
}
<?php
if (isset($_POST["act"]) and $_POST["act"] == "save") {
$w["id"] = $params["user_id"];
if (!preg_match("`^[A-Za-z0-9\\_\\.]{2,}\$`", $_POST["username"])) {
PageEngine::AddErrorMessage("save", "Ungültiges Format für den Usernamen");
} elseif (UsernameAlreadyInUse($_POST["username"], MyUser::id())) {
PageEngine::AddErrorMessage("save", "Username bereits vergeben");
} else {
$w["username"] = $_POST["username"];
}
$w["prename"] = $_POST["prename"];
$w["familyname"] = $_POST["familyname"];
$w["website"] = $_POST["website"];
$w["location"] = $_POST["location"];
$w["country"] = $_POST["country"];
$w["language"] = $_POST["language"];
$w["FlattrUID"] = trim($_POST["FlattrUID"]);
$w["SkypeID"] = trim($_POST["SkypeID"]);
$w["GooglePlus"] = trim($_POST["GooglePlus"]);
$w["PayPal_email"] = $_POST["PayPal_email"];
$w["show_country"] = (isset($_POST["show_country"]) and $_POST["show_country"] == "1" ? 1 : 0);
$d = $_POST["birthday_year"] . "-" . $_POST["birthday_month"] . "-" . $_POST["birthday_day"];
if (!preg_match("`^[0-9\\?]{4}-[0-9\\?]{2}-[0-9\\?]{2}\$`", $d)) {
PageEngine::AddErrorMessage("save", "Ungültiges Geburtsdatum");
} else {
$w["birthday"] = $d;
}
$w["biography"] = $_POST["text"];
$db = new SQL(0);
$db->CreateUpdate(0, "user_list", $w);
}
}
//print_r($_GET);
}
function OpenIDAddLogin($openIdentifier, $data)
{
$userlist = $openIdentifier;
$db = new SQL(0);
$w = array();
$w["username"] = $userlist;
$w["provider"] = "openid";
$w["user"] = MyUser::id();
$db->CreateUpdate(0, 'user_login', $w);
PageEngine::AddSuccessMessage("openid", "Zugriffsart hinzugefügt");
}
function OpenIDRegisterLogin($openIdentifier, $data)
{
$userlist = $openIdentifier;
$db = new SQL(0);
$row = $db->cmdrow(0, 'SELECT * FROM user_login WHERE username="******" AND provider="openid" LIMIT 0,1', array($userlist));
if (!isset($row["username"])) {
$db->cmd(0, 'INSERT IGNORE INTO user_list ');
$w = array();
if (isset($data["nickname"])) {
$w["username"] = $data["nickname"] . "#" . rand(0, 99999);
} else {
$w["username"] = "******" . rand(0, 99999);
}
$w["email_standard"] = $data["email"];
if (isset($data["language"])) {
if (!isset($_GET["tag"])) {
$_GET["tag"] = "";
}
$g = explode(",", $_GET["tag"] . "," . $_POST["tags"]);
foreach (tags2array($_POST["tags"]) as $a) {
if (trim($a) == "") {
continue;
}
$w3 = array();
$w3["question"] = $frageid;
$w3["tag"] = $a;
$db->CreateUpdate(0, "question_tags", $w3);
}
$_SESSION["myuser"]["lastwritten"]["question"][$frageid] = true;
Karma::RuleAction("CREATE_QUESTION", array("user" => MyUser::id(), "question" => $frageid));
Badges::add(3, MyUser::id(), array("question" => $frageid));
//Erste Frage geschrieben
@file_get_contents("www.google.com/webmasters/tools/ping?sitemap=" . urlencode(SiteConfig::val("baseurl") . "sitemap.xml"));
$m = SiteConfig::get(0);
if ($m["twitter"]["consumer"]["secret"] . "" != "" && $m["twitter"]["access"]["secret"] . "" != "") {
try {
$twitter = new Twitter($m["twitter"]["consumer"]["key"], $m["twitter"]["consumer"]["secret"]);
$twitter->setOAuthToken($m["twitter"]["access"]["key"]);
$twitter->setOAuthTokenSecret($m["twitter"]["access"]["secret"]);
$url = API_urlshortener::add(Question::PermalinkByData($w3["question"], $w["title"]));
if (strlen($w["title"]) > 100) {
$tweet = substr($w["title"], 0, 100) . "... " . $url . " #wikihelp";
} else {
$tweet = substr($w["title"], 0, 100) . " " . $url . " #wikihelp";
}
$twitter->statusesUpdate($tweet);
?>
</div>
<strong><?php
echo _e("tags:");
?>
</strong><br/>
<input class="fld_tags big" autocomplete="off" type="text" name="tags" size="50" value="<?php
echo isset($_POST["tags"]) ? html($_POST["tags"]) : (isset($_GET["tag"]) ? html($_GET["tag"]) . ',' : '');
?>
" placeholder="tag1, tag2, tag3, ..."/>
<p><?php
echo _e("Tags are short keywords, with no spaces within. Up to 5 tags can be used.");
?>
</p>
<div id="previewer" class="editor-preview" style="display: block; "></div>
<div class="question-options">
<div class="checkbox" title="<?php
echo _e("Wenn Du community-wiki auswählst, werden auf die Frage und Antworten keine Bewertungspunkte vergeben, der Name des Autors wird nicht angezeigt.");
?>
"> <input type="checkbox" name="wiki" id="id_wiki" value="1"> <label for="id_wiki"><?php
echo _e("Community Wiki (Karma wird nicht gezählt, und andere können den Beitrag editieren)");
?>
</label></div>
<div class="checkbox" title="<?php
echo _e("Kreuze an wenn du deinen Namen bei einer Frage nicht anzeigen lassen möchtest");
?>
"> <input type="checkbox" <?php
echo !MyUser::isloggedin() ? 'disabled="disabled" CHECKED="CHECKED"' : "";
?>
name="ask_anonymously" id="id_ask_anonymously" value="1"> <label for="id_ask_anonymously"><?php
PageEngine::runController("answer_edit", array("id" => $treffer[1] + 0));
PageEngine::html("page_answer_edit", array("id" => $treffer[1] + 0));
exit(1);
}
}
if (preg_match("@^/badges/([0-9]+)/[^\\/]+(/[a-z]+)?\$@", $_SERVER["REQUEST_URIpure"], $treffer)) {
PageEngine::html("page_badgeprofile", array("badge_id" => $treffer["1"] + 0));
exit(1);
}
if (preg_match("@^/tags/(.*?)(/[a-z\\/]+)?\$@", $_SERVER["REQUEST_URIpure"], $treffer)) {
switch (isset($treffer[2]) ? $treffer[2] : "/info") {
case "/info":
PageEngine::runController("tags_info", array("id" => $treffer[1]));
PageEngine::html("page_tags_info", array("id" => $treffer[1]));
exit(1);
case "/info/edit":
if ((!MyUser::isloggedin() or MyUser::getKarmaPoints() < 2500) and !MyUser::hasAdminRight()) {
PageEngine::html("page_error_karma", array("karma" => 2500));
}
PageEngine::runController("tags_infoedit", array("id" => $treffer[1]));
PageEngine::html("page_tags_infoedit", array("id" => $treffer[1]));
exit(1);
case "/synonyms":
PageEngine::runController("tags_synonyms", array("id" => $treffer[1]));
PageEngine::html("page_tags_synonyms", array("id" => $treffer[1]));
exit(1);
}
}
Observer::Raise("Error_404", array("path" => $_SERVER["REQUEST_URIpure"]));
PageEngine::html("page_404");
exit(1);
<?php
$db = new SQL(0);
$rows = $db->cmdrows(0, 'SELECT T1.badge, count(*) as Anzahl, T2.user FROM user_badges as T1 LEFT JOIN user_badges as T2 ON T1.badge = T2.badge AND T2.user="******" GROUP BY T1.badge', array(MyUser::id() + 0));
$badges = array();
foreach ($rows as $row) {
$badges[$row["badge"]] = $row;
}
PageEngine::html("html_head");
PageEngine::html("header");
?>
<div id="Content" class="content-wrapper">
<article class="ContentLeft">
<h1>Auszeichnungen</h1>
<p>Rege Teilnahme mit qualitativ hochwertigen Fragen und Antworten führt zum Erhalt von Auszeichnungen in Form von Abzeichen.</p>
<p>Hier unten findest Du eine Liste der möglichen Auszeichnungen und die Häufigkeit, mit der das Abzeichen bisher verliehen wurde. Hast Du noch mehr Ideen für tolle Abzeichen? Dann gib uns bitte ein <a href="<?php
echo get_path("/feedback");
?>
" rel="nofollow" target="_blank">Feedback</a></p>
<table class="MedalTable">
<?php
foreach (Badges::$badgelist as $key => $value) {
echo '<tr><td>';
if (isset($badges[$key]["user"])) {
echo '<img src="' . get_path("/skins/default/images/layout/yes.png") . '" height="32" TITLE="Sie haben bereits diese Auszeichnung"/>';
}
echo '</td><td><a href="' . get_path("/badges/" . $key . "/" . html($value["title"])) . '" class="awardmedal"><span class="award' . $value["medal"] . '">' . html($value["title"]) . '</span></a> x ' . (isset($badges[$key]["Anzahl"]) ? $badges[$key]["Anzahl"] + 0 : 0) . '</td>';
echo '<td class="desc">' . html($value["desc"]) . '</td>';
echo '</tr>';
}
?>
<div id="Content" class="content-wrapper PageUserprofile">
<article class="vcard contact hcard">
<h1 class="search-result-summary"><?php
echo _e("{0}'s Profil-Übersicht", array(0 => $info["username"]));
?>
</h1>
<?php
PageEngine::html("box_userprofile_navi", array("id" => $info["id"], "name" => $info["username"]));
?>
<table class="wrapper"><tr style="vertical-align: top;">
<td style="text-align: center;">
<div class="box_gravatar" style="width:140px; height:140px margin-bottom: 10px; position: relative;">
<img class="profile photo" src="http://www.gravatar.com/avatar/<?php
echo md5($info["email_standard"]);
?>
?s=140&d=identicon" style="border: #EEE 1px solid; padding: 5px; border-radius: 3px; ">
<?php
if (isset($info["right"]) and $info["right"] == "expert") {
echo '<img src="' . get_path("/skins/default/images/icons/expert.png") . '" TITLE="Experte für dieses Thema" style="position: absolute; width: 70px; height: 70px; bottom: -35px; right: -35px;"/>';
}
?>
</div>
<a class="gravatar link" href="https://de.gravatar.com/emails/" target="_blank" rel="nofollow">Bild ändern</a>
<p class="karma"><span class="points"><?php
echo $info["karma"];
?>
</span><span class="txt">Karma</span></p>
</td>
public static function accept($data)
{
$out = array();
if (!MyUser::isloggedin()) {
throw new APIException("User ist nicht angemeldet.", 100);
}
if (!isset($data["answer"])) {
throw new APIException("Benötigter Parameter fehlt (answer).", 50);
}
$db = new SQL(0);
$info = $db->cmdrow(0, 'SELECT * FROM answers WHERE id={0} LIMIT 0,1', array($data["answer"] + 0));
if (!isset($info["id"])) {
throw new APIException("Diese Antwort existiert nicht (mehr)", 300);
}
if ($info["right_answer"] == "1") {
throw new APIException("Dies ist bereits die beste Antwort", 330);
}
$qinfo = $db->cmdrow(0, 'SELECT * FROM questions WHERE id={0} LIMIT 0,1', array($info["question"] + 0));
if (!isset($qinfo["id"])) {
throw new APIException("Diese Frage existiert nicht (mehr)", 300);
}
if ($qinfo["is_closed"] == "1") {
throw new APIException("Diese Frage ist bereits geschlossen", 310);
}
if ($qinfo["author"] != MyUser::id()) {
throw new APIException("Dies ist nicht ihre Frage", 320);
}
if ($info["author"] == MyUser::id() and MyUser::getKarmaPoints() < 50) {
throw new APIException("Deine eigene Antwort darf erst ab 50 Karma Punkten die beste Antwort sein", 210);
}
$db->cmd(0, 'UPDATE answers SET right_answer = "1" WHERE id={0} LIMIT 1', true, array($info["id"]));
$db->cmd(0, 'UPDATE questions SET is_answered = "1" WHERE id={0} LIMIT 1', true, array($info["question"]));
if (MyUser::id() != $info["author"]) {
Karma::RuleAction("ACCEPT_ANSWER", array("user" => $info["author"], "question" => $info["question"], "answer" => $info["id"]));
}
if (MyUser::id() != $info["author"] && $info["is_bounty"] == "1") {
Bounty::Release($info["question"], $info["author"]);
}
//Gib dem Autor die Bounty
return true;
}
public static function setbounty($data)
{
if (!MyUser::isloggedin()) {
throw new APIException("User ist nicht angemeldet.", 100);
}
$data["karma"] = floor(string2::vall($data["karma"] + 0));
$data["bitcoin"] = string2::vall($data["bitcoin"] + 0);
$data["EUR"] = string2::vall($data["EUR"] + 0);
$db = new SQL(0);
if ($data["karma"] > 0) {
if (MyUser::getKarmaPoints() < 75) {
throw new APIException("Du benötigst 75 Karma-Punkte um eine Karma Bounty zu geben.", 200);
}
if (MyUser::getKarmaPoints() < $data["karma"] + 0) {
throw new APIException("Du hast nur " . MyUser::getKarmaPoints() . " Karma Punkte zu verschenken!", 200);
}
$w = array();
$w["question"] = $data["question"] + 0;
$w["user"] = MyUser::id();
$w["amount"] = $data["karma"];
$w["currency"] = "kar";
$w["dt_created"] = time();
$db->Create(0, 'question_bounty', $w);
Karma::add(MyUser::id(), 5, 0 - $w["amount"], $w["question"]);
}
if ($data["bitcoin"] > 0) {
throw new APIException("Sie haben nicht genügend Bitcoin Guthaben.", 610);
}
if ($data["EUR"] > 0) {
throw new APIException("Sie haben nicht genügend Euro Guthaben.", 710);
}
}
private static function _load()
{
if (!self::isloggedin()) {
return false;
}
$db = new SQL(0);
self::$_usercache = $db->cmdrow(0, 'SELECT * FROM user_list WHERE id={0} LIMIT 0,1', array(self::id()));
}
$info = $db->cmdrow(0, 'SELECT * FROM tag_details WHERE tag = "{0}" LIMIT 0,1', array($params["id"]));
PageEngine::html("html_head", array("title" => $params["id"], "index" => isset($info["long_desc"])));
PageEngine::html("header");
?>
<div id="Content" class="content-wrapper PageUserprofile">
<article class="ContentLeft">
<?php
PageEngine::html("box_tags_navi", array("tag" => $params["id"]));
?>
<h1 class="search-result-summary"><?php
echo _e("Infos for Tag '{0}'", array(0 => $params["id"]));
?>
</h1>
<?php
BBCode::render(isset($info["long_desc"]) ? $info["long_desc"] : "", true);
if (!isset($info["long_desc"]) or trim($info["long_desc"]) == "") {
echo '<p class="noTagDescription">' . _e("Dieser Tag hat aktuell noch keine Erklärung. Ab 2500 Karma Punkten kannst Du diesen Artikel erstellen und so anderen Usern helfen oder einen kurzen Einblick in das Thema bieten.") . '</p>';
}
if (MyUser::isloggedin() and MyUser::getKarmaPoints() >= 2500 or MyUser::hasAdminRight()) {
echo '<a href="' . get_path("/tags/" . urlencode($params["id"]) . "/info/edit") . '"><button class="blue" type="button">' . _e("edit") . '</button></a>';
}
?>
</article>
<aside class="ContentRight">
<div style="text-align: center;">
<?php
$count = $db->cmdvalue(0, 'SELECT count(*) FROM question_tags WHERE tag="{0}" LIMIT 0,1', array($params["id"]));
echo '<span style="color: #808185; font-size: 30px; font-weight:bold;">' . number_format($count, 0, ",", ".") . '</span>';
">Übersicht</a></li>
<?php
if (MyUser::id() == $params["id"]) {
?>
<li><a href="<?php
echo UserProfile::ProfilePermaLink($params["id"], $params["name"], "inbox");
?>
">Postfach</a></li>
<?php
}
?>
<li><a href="<?php
echo UserProfile::ProfilePermaLink($params["id"], $params["name"], "karma");
?>
">Karma</a></li>
<li><a href="<?php
echo UserProfile::ProfilePermaLink($params["id"], $params["name"], "badges");
?>
">Abzeichen</a></li>
<?php
if (MyUser::hasAdminRight()) {
echo '<li><a href="' . UserProfile::ProfilePermaLink($params["id"], $params["name"], "rights") . '">Rechte</a></li>';
}
?>
</ul>
<div class="clearfix"></div>
<style>
ul.navibar { display: block; margin-bottom: 15px; background-color: #EFF5F6; height: 30px; line-height: 30px; font-family: Georgia,serif; font-size: 16px; padding: 0px 0px 0px 10px; border-radius: 5px; }
ul.navibar li { list-style: none; float: left; padding: 0px 10px; border-left: 1px solid #D0E1E4; }
ul.navibar li:first-child { border-left: none; }
ul.navibar li a { color: #7EA9B3; }
$w2 = array();
$w2["id"] = $info["id"];
$w2["title"] = $_POST["title"];
$w2["question"] = $_POST["text"];
$w2["author"] = MyUser::id();
$w2["tags"] = implode(",", tags2array($_POST["tags"]));
$w2["date_edited"] = time();
$w2["date_action"] = time();
$w2["user_action"] = MyUser::id() + 0;
$db->CreateUpdate(0, 'questions', $w2);
$db->cmd(0, 'DELETE FROM `question_tags` WHERE question={0}', true, array($info["id"]));
foreach (tags2array($_POST["tags"]) as $a) {
$w3 = array();
$w3["question"] = $info["id"];
$w3["tag"] = $a;
$db->CreateUpdate(0, "question_tags", $w3);
}
Badges::add(10, MyUser::id());
//Erfolg Redakteur: Editiere einen Beitrag
header("Location: " . Question::PermalinkByData($info["id"], $info["title"]));
exit(1);
}
function tags2array($text)
{
$g = explode(",", $text);
$out = array();
for ($i = 0; $i < min(5, count($g)); $i++) {
$out[] = trim(strtolower($g[$i]));
}
return $out;
}
// check if it is regular user
if ($user_type == "r") {
echo "<table width='100%' align='center'>";
echo "<tr>";
echo "<td align='right' style='color: #C15BAF; font-size: 24px;'>Welcome" . $user_name . "! Press here to <a href='logout.php'>logout!</a></td>";
echo "</tr>";
echo "</table>";
} else {
if ($user_type == "a") {
header("location: admin.php");
} else {
echo "Login in error";
}
}
// show user business plan information
$myUser = new MyUser(Hostname, DB - username, password, Database - Name);
$myUser->connect();
// start with a new line
// get the number of business plan
$number_of_business_plan = $myUser->get_number_of_business_plan($user_name);
echo "<table width='80%' align='center'>";
echo "<tr>";
echo "<td style='text-align: center; font-size: 36px'>You have " . $number_of_business_plan . " Business Plans</td></tr>";
echo "<tr>";
echo "<td><table width='100%' border='1' cellpadding='1' cellspacing='0'>";
echo "<tr style='text-align: center; font-size: 24px;'>";
echo "<td width='30%'>Name</td>";
echo "<td>Description</td>";
echo "</tr>";
// print out the plan information
$business_plan = $myUser->get_business_plan_information($user_name);
<p><?php
echo _e("Bitte gebe einen aussagekräftigen Titel für die Frage ein.");
?>
</p>
<?php
PageEngine::html("box_editor", array("placeholder" => _h("Schreibe hier deine Frage noch ein wenig ausführlicher..."), "value" => isset($_POST["text"]) ? $_POST["text"] : $info["question"]));
?>
<strong><?php
echo _e("tags:");
?>
</strong><br/>
<input class="gblue" autocomplete="off" type="text" name="tags" size="50" placeholder="tag1, tag2, tag3, ..." value="<?php
echo html($info["tags"]);
?>
"/>
<p><?php
echo _e("Tags sind kurze Schlüsselwörter, die Deine Frage beschreiben. Du kannst bis zu 5 Begriffe jeweils mit Komma nennen.");
?>
</p>
<b><?php
echo _e("Zusammenfassung der Überarbeitung:");
?>
</b>
<INPUT class="gblue" type="text" name="change_summary" value="" placeholder="Rechtschreibfehler, Tippfehler korrigiert, Grammatik, Stil verbessert, ..."/>
<p><?php
echo _e("Bitte gebe eine kurze Beschreibung deiner Überarbeitung ein (z.B. Rechtschreibung, Tippfehler korrigiert, Grammatik, Stil verbessert) (Freiwillige Angabe)");
?>
<?php
$db = new SQL(0);
if (MyUser::isloggedin()) {
$db->cmd(0, 'INSERT LOW_PRIORITY IGNORE INTO user_action SET user={0}, last_action = {0} ON DUPLICATE KEY UPDATE last_action ={1}', true, array(MyUser::id(), time()));
}
} else {
$w["isSPAM"] = -2;
}
} catch (Exception $ex) {
}
}
$db->CreateUpdate(0, 'answers', $w);
$answerID = $db->LastInsertKey();
$db->cmd(0, 'UPDATE questions SET date_action={1},user_action="{2}", count_answers = (SELECT count(*) FROM answers WHERE question=questions.id) WHERE id={0} LIMIT 1', true, array($w["question"], time(), MyUser::id() + 0));
$_SESSION["myuser"]["lastwritten"]["answers"][$answerID] = true;
Karma::RuleAction("CREATE_ANSWER", array("user" => MyUser::id(), "question" => $w["question"], "answer" => $answerID));
Badges::add(4, MyUser::id(), array("question" => $w["question"]));
//Erste Antwort geschrieben
}
}
if (isset($_POST["act"]) and $_POST["act"] == "addComment") {
if (strlen($_POST["comment"]) >= 10 and MyUser::isloggedin()) {
$w = array();
$db = new SQL(0);
$w["question"] = $_POST["question"] + 0;
$w["answer"] = $_POST["answer"] + 0;
$w["text"] = $_POST["comment"];
$w["created"] = time();
$w["user"] = MyUser::id();
$db->CreateUpdate(0, 'comments', $w);
$a = $db->LastInsertKey();
Badges::add(5, MyUser::id(), array("question" => $w["question"]));
//Erster Kommentar geschrieben
@header("Location: #comment-" . $a);
}
}
/**
* testFindAllRecursiveWithHabtm method
*
* @return void
*/
public function testFindAllRecursiveWithHabtm()
{
$this->loadFixtures('MyCategoriesMyUsers', 'MyCategoriesMyProducts', 'MyCategory', 'MyUser', 'MyProduct');
$MyUser = new MyUser();
$MyUser->recursive = 2;
$result = $MyUser->find('all', array('order' => 'MyUser.id ASC'));
$expected = array(array('MyUser' => array('id' => '1', 'firstname' => 'userA'), 'MyCategory' => array(array('id' => '1', 'name' => 'A', 'MyProduct' => array(array('id' => '1', 'name' => 'book'))), array('id' => '3', 'name' => 'C', 'MyProduct' => array(array('id' => '2', 'name' => 'computer'))))), array('MyUser' => array('id' => '2', 'firstname' => 'userB'), 'MyCategory' => array(array('id' => '1', 'name' => 'A', 'MyProduct' => array(array('id' => '1', 'name' => 'book'))), array('id' => '2', 'name' => 'B', 'MyProduct' => array(array('id' => '1', 'name' => 'book'), array('id' => '2', 'name' => 'computer'))))));
$this->assertEquals($expected, $result);
}
<div class="answer answer-<?php
echo $row["id"];
?>
<?php
echo $row["author"] == MyUser::id() ? "myanswer" : "";
?>
<?php
echo $row["isSPAM"] > 0 ? "SPAManswer" : "";
?>
" rel="<?php
echo $row["id"];
?>
" style="margin-bottom:10px;">
<div class="vote-buttons">
<div id="answer-img-upvote-<?php
echo $row["id"];
?>
" class="answer img-upvote post-vote <?php
echo $row["MyVote"] == "1" ? "active" : "";
?>
"></div>
<div id="aswer-vote-number-<?php
echo $row["id"];
?>
" class="answer vote-number <?php
echo $row["count_votes"] > 0 ? "positive" : "";
?>
<?php
echo $row["count_votes"] < 0 ? "negative" : "";
?>
" title="Aktuelle Anzahl Bewertungen"><?php
