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; }
<?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())); }
$w["email_standard"] = $_GET["openid_ext1_value_email"]; $w["dt_registered"] = time(); $db->Create(0, 'user_list', $w); $userid = $db->LastInsertKey(); $w2["username"] = $username; $w2["provider"] = "google"; $w2["user"] = $userid; $db->Create(0, 'user_login', $w2); $row = $db->cmdrow(0, 'SELECT * FROM user_login WHERE username="******" AND provider="google" LIMIT 0,1', array($username)); } MyUser::loginload($row["user"]); header("Location: " . get_path("/?t=" . time())); exit(1); //http://127.0.0.1:8082/askbot/account/signin?action=login_google_response&openid.ns=http%3A%2F%2Fspecs.openid.net%2Fauth%2F2.0&openid.mode=id_res&openid.op_endpoint=https%3A%2F%2Fwww.google.com%2Faccounts%2Fo8%2Fud&openid.response_nonce=2012-10-29T22%3A16%3A45ZxLgZyEdIOppIAw&openid.return_to=http%3A%2F%2F127.0.0.1%3A8082%2Faskbot%2Faccount%2Fsignin%3Faction%3Dlogin_google_response&openid.invalidate_handle=ABSmpf6DNMw&openid.assoc_handle=AMlYA9VO0cDrs_DCb7dwBpWED9qHF0QtHhjdwcLQRwhuf_oHmGjGBQ_d&openid.signed=op_endpoint%2Cclaimed_id%2Cidentity%2Creturn_to%2Cresponse_nonce%2Cassoc_handle%2Cns.ext1%2Cext1.mode%2Cext1.type.firstname%2Cext1.value.firstname%2Cext1.type.email%2Cext1.value.email%2Cext1.type.language%2Cext1.value.language%2Cext1.type.lastname%2Cext1.value.lastname&openid.sig=3H3PjRiFw6w2proHrClS7ChQwWI%3D&openid.identity=https%3A%2F%2Fwww.google.com%2Faccounts%2Fo8%2Fid%3Fid%3DAItOawlJe3brb90Yfk7l938jJsrK9Rv0i7vj_6Q&openid.claimed_id=https%3A%2F%2Fwww.google.com%2Faccounts%2Fo8%2Fid%3Fid%3DAItOawlJe3brb90Yfk7l938jJsrK9Rv0i7vj_6Q&openid.ns.ext1=http%3A%2F%2Fopenid.net%2Fsrv%2Fax%2F1.0&openid.ext1.mode=fetch_response&openid.ext1.type.firstname=http%3A%2F%2Faxschema.org%2FnamePerson%2Ffirst&openid.ext1.value.firstname=Andreas&openid.ext1.type.email=http%3A%2F%2Faxschema.org%2Fcontact%2Femail&openid.ext1.value.email=investmentinformatiker%40googlemail.com&openid.ext1.type.language=http%3A%2F%2Faxschema.org%2Fpref%2Flanguage&openid.ext1.value.language=en&openid.ext1.type.lastname=http%3A%2F%2Faxschema.org%2FnamePerson%2Flast&openid.ext1.value.lastname=Kasper } function DoOpenIDLogin($url) { $openid = new LightOpenID($_SERVER["HTTP_HOST"]); if (!$openid->mode) { $openid->identity = $url; $openid->optional = array("namePerson/friendly", "namePerson", "namePerson/first", "contact/email", "birthDate", "person/gender", "contact/postalCode/home", "contact/country/home", "pref/language"); header('Location: ' . $openid->authUrl()); exit(1); } if ($openid->validate()) {
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); } }
?> </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
} 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); } }
<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)"); ?>
$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>';
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);
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; }
if (MyUser::getKarmaPoints() >= 50) { PageEngine::html("box_commenteditor", array("question" => $info["id"], "answer" => -1)); } ?> </div> <style> h2.comment-title { font-weight: bold;font-size: 23px; color: #7EA9B3; width: 200px; font-family: 'Yanone Kaffeesatz',Arial,sans-serif; } .tabBar a { color: #7EA9B3; line-height: 20px; } .tabBar a.active { color: #4A757F; } .tabBar a:hover { color: #4A757F; } .ThankYou { color: #606060; font-style: italic; text-align: left; font-size:10px; } .vote-buttons { text-align: center; } .box_bounties { display: block; border: 1px solid #ff8000; background: #ffa030 url(<?php echo get_path("/skins/default/images/icons/bounty.png"); ?> ) no-repeat left center; background-size:32px; line-height:32px; padding: 2px 2px 2px 34px; margin-bottom:2px; border-radius: 4px; } .box_bounties .bounty.BTC { background: url(<?php echo get_path("/skins/default/images/icons/bitcoin.png"); ?> ) no-repeat right center; font-weight:bold; font-size:16px; color:#404040; background-size:16px; padding-right: 17px; margin-right:10px; } .box_bounties .bounty.karma { background: url(<?php echo get_path("/skins/default/images/icons/karma.png"); ?> ) no-repeat right center; font-weight:bold; font-size:16px; color:#404040; background-size:16px; padding-right: 17px; margin-right:10px; } .box_bounties .bounty.EUR { font-weight:bold; font-size:16px; color:#404040; background-size:16px; margin-right:10px;} </style> <script> $(document).ready(function() { $(".post-vote.question.img-upvote").css("cursor","pointer").click(function() {