public function GetTop3()
 {
     global $whichUser;
     $myDBConnector = new DBConnector();
     $dbARY = $myDBConnector->infos();
     $connection = new mysqli($dbARY[0], $dbARY[1], $dbARY[2], $dbARY[3]);
     if ($connection->connect_error) {
         return false;
     } else {
         $connection->set_charset("utf8");
         $ress0 = $connection->query("SELECT * FROM users WHERE userName = '******'");
         if ($ress0->num_rows == 0) {
             echo "<script type=\"text/javascript\"> window.location='oops.php'; </script>";
         }
         $query = "SELECT * FROM `threads` WHERE threadWriter='{$whichUser}' ORDER BY `threadPoint` DESC LIMIT 3 ";
         $results = $connection->query($query);
         if ($results->num_rows < 3) {
             return false;
         } else {
             $returnAry = array();
             while ($curResult = $results->fetch_assoc()) {
                 $returnAry[] = $curResult["threadPicture"];
                 $returnAry[] = $curResult["threadName"];
                 $returnAry[] = $curResult["threadID"];
             }
             return $returnAry;
         }
     }
 }
 public function ConversationsToHTML()
 {
     global $conversationsInfos;
     $myDBConnector = new DBConnector();
     $dbARY = $myDBConnector->infos();
     $connection = new mysqli($dbARY[0], $dbARY[1], $dbARY[2], $dbARY[3]);
     if ($connection->connect_error) {
         echo "Database bağlantı hatası";
     } else {
         $query = "SELECT * FROM conversations WHERE (user1=\"" . $conversationsInfos["Pour Qui"] . "\" OR user2=\"" . $conversationsInfos["Pour Qui"] . "\") ORDER BY lastDate DESC ";
         $results = $connection->query($query);
         if ($results->num_rows == 0) {
             echo "<div style=\"margin:2%;background-color:#e6e6e6;color:#6e6e6e;font-size:18px;font-family: Verdana,Geneva,sans-serif;\">";
             echo "Henüz mesajlaşmamışsınz.";
             echo "</div>";
         } else {
             while ($curResult = $results->fetch_assoc()) {
                 if ($curResult["user1"] == $conversationsInfos["Pour Qui"]) {
                     $other = $curResult["user2"];
                 } else {
                     $other = $curResult["user1"];
                 }
                 $ary = array($other, $conversationsInfos["Pour Qui"], $conversationsInfos["Pour Qui"]);
                 $myConversation = new Conversation($ary);
                 $myConversation->ConversationToHTML();
             }
         }
         $connection->close();
     }
 }
 public function loadStep($stepNo)
 {
     global $threadInfos;
     $threadID = $threadInfos['Thread ID'];
     $myDBConnector = new DBConnector();
     $dbARY = $myDBConnector->infos();
     $connection = new mysqli($dbARY[0], $dbARY[1], $dbARY[2], $dbARY[3]);
     if ($connection->connect_error) {
         return "CONNECT_ERR";
     } else {
         /* database'e girdik */
         $sqlRequest = "SELECT * FROM steps WHERE (threadID='{$threadID}' AND stepNo='{$stepNo}')";
         if ($result = $connection->query($sqlRequest)) {
             $ary = array();
             $row = $result->fetch_assoc();
             $ary[0] = $row["stepNo"];
             $strx1 = str_replace('\\"', '"', $row["baslik"]);
             $strx2 = str_replace("\\'", "'", $strx1);
             $ary[1] = $strx2;
             $ary[2] = $row["resimLink"];
             $str1 = str_replace('\\"', '"', $row["icerik"]);
             $str2 = str_replace("\\'", "'", $str1);
             $ary[3] = $str2;
             $myStep = new Step($ary);
             return $myStep;
         } else {
             return "QUERY_ERR";
         }
         $connection->close();
     }
 }
 public function Find()
 {
     $myDBConnector = new DBConnector();
     $dbARY = $myDBConnector->infos();
     $myQuery = "SELECT MAX(usedID) FROM usedIDs";
     $connection = new mysqli($dbARY[0], $dbARY[1], $dbARY[2], $dbARY[3]);
     if ($connection->connect_error) {
         return -1;
     }
     /* database'e girdik */
     $result = $connection->query($myQuery);
     if ($result->num_rows != 0) {
         $curResult = $result->fetch_assoc();
         $newResult = $curResult["MAX(usedID)"];
         $newResult = (int) $newResult;
         $newResult = $newResult + 1;
     } else {
         $newResult = 1;
     }
     if ($connection->query("INSERT INTO usedIDs(usedID) VALUES (" . $newResult . ")") === TRUE) {
         $connection->close();
         return $newResult;
     }
     $connection->close();
     return -1;
 }
 public function Activate()
 {
     global $code;
     echo "<div  style=\"margin-top:10%;padding:3%;font-family:Verdana,Geneva,sans-serif;font-size:20px;background-color:#e6e6e6;border:1px solid #c7d0d5;border-radius:15px;width: 100%; max-width:100%;color:#6e6e6e;height:250px;\">";
     echo "<img src=\"images/headerfil2.jpg\" style=\"max-width:60px;\"/>";
     echo "<br/>";
     if (isset($_SESSION["user_name"])) {
         $usr = $_SESSION["user_name"];
         $myDBConnector = new DBConnector();
         $dbARY = $myDBConnector->infos();
         $connection = new mysqli($dbARY[0], $dbARY[1], $dbARY[2], $dbARY[3]);
         if ($connection->connect_error) {
             echo "Veritabanı bağlantı sorunu.";
         } else {
             $query = "UPDATE users SET activation=\"OK\" WHERE ( userName=\"" . $usr . "\" AND activationCode=\"" . $code . "\")";
             if ($connection->query($query) === TRUE) {
                 echo "Üyeliğiniz başarıyla aktive edildi.";
             } else {
                 echo "Veritabanı hatası.";
             }
         }
     } else {
         echo "Üyeliğinizi aktive etmeden önce giriş yapmalısınız.";
     }
     echo "<br/><br/>";
     echo "<button id=\"anasayfaya_don_buttonu\" class=\"btn btn-primary\">";
     echo "Anasayfaya git";
     echo "</button>";
     echo "<br/>";
     echo "</div>";
     echo "<script type=\"text/javascript\">";
     echo "\n\t\t\t\t\$(document).ready(function(){\n\t\t\t\t\t\$('#anasayfaya_don_buttonu').click(function(){\n\t\t\t\t\t\twindow.location.replace(\"http://www.serinhikaye.com\");\n\t\t\t\t\t});\n\t\t\t\t});\n\t\t\t";
     echo "</script>";
 }
예제 #6
0
 public function DigerSahane()
 {
     $myDBConnector = new DBConnector();
     $dbARY = $myDBConnector->infos();
     $connection = new mysqli($dbARY[0], $dbARY[1], $dbARY[2], $dbARY[3]);
     if (!$connection->connect_error) {
         $connection->set_charset("utf8");
         $results = $connection->query("SELECT * FROM threads ORDER BY threadPoint DESC LIMIT 8 OFFSET 10 ");
         while ($curres = $results->fetch_assoc()) {
             $threadID5 = $curres["threadID"];
             $threadDate5 = $curres["threadDate"];
             $threadWriter5 = $curres["threadWriter"];
             $threadCategory5 = $curres["threadCategory"];
             $threadPicture5 = $curres["threadPicture"];
             $stepCount5 = $curres["stepCount"];
             $threadName5 = $curres["threadName"];
             $threadPoint5 = $curres["threadPoint"];
             $myThread5 = new Thread(array($threadID5, $threadDate5, $threadWriter5, $threadCategory5, $threadPicture5, $stepCount5, $threadName5, $threadPoint5));
             $myThread5->ThreadToPetitHTML();
         }
         echo "<div id=\"moreBestDiv\"></div>";
         echo "<div style=\"margin:2%;\">";
         echo "<form id=\"loadMoreBestForm\" method=\"post\" action=\"loadMoreBest.php\">";
         echo "<input id=\"loadMoreBestOffset\" name=\"loadMoreBestOffset\" style=\"display:none;\" value=\"" . $results->num_rows . "\"/>";
         echo "<button id=\"loadMoreBestButton\" class=\"btn btn-block btn-success\">";
         echo "<i id=\"loadMoreBestSpinner\" style=\"display:none;\" class=\"fa fa-refresh fa-spin\"></i>";
         echo "<span id=\"loadMoreBestTXT\">";
         echo "Daha fazla göster";
         echo "</span>";
         echo "</button>";
         echo "</form>";
         echo "</div>";
     }
 }
 public function Find2()
 {
     $myDBConnector = new DBConnector();
     $dbARY = $myDBConnector->infos();
     $connection = new mysqli($dbARY[0], $dbARY[1], $dbARY[2], $dbARY[3]);
     if ($connection->connect_error) {
         return false;
     } else {
         $connection->set_charset("utf8");
         $query1 = "SELECT count(distinct threadWriter) FROM threads WHERE threadCategory = \"Alakasız\"";
         $query2 = "SELECT count(distinct threadWriter) FROM threads WHERE threadCategory = \"Bilim/Kültür\" ";
         $query3 = "SELECT count(distinct threadWriter) FROM threads WHERE threadCategory = \"Sosyal ilişkiler\"";
         $query4 = "SELECT count(distinct threadWriter) FROM threads WHERE threadCategory = \"Sağlık/Spor\"";
         $query5 = "SELECT count(distinct threadWriter) FROM threads WHERE threadCategory = \"Yemek/İçmek\"";
         $query6 = "SELECT count(distinct threadWriter) FROM threads WHERE threadCategory = \"Bilgisayar/Elektronik\"";
         $query7 = "SELECT count(distinct threadWriter) FROM threads WHERE threadCategory = \"Sanat/Eğlence\"";
         $res1 = $connection->query($query1);
         $res2 = $connection->query($query2);
         $res3 = $connection->query($query3);
         $res4 = $connection->query($query4);
         $res5 = $connection->query($query5);
         $res6 = $connection->query($query6);
         $res7 = $connection->query($query7);
         $res1_assoc = $res1->fetch_assoc();
         $res2_assoc = $res2->fetch_assoc();
         $res3_assoc = $res3->fetch_assoc();
         $res4_assoc = $res4->fetch_assoc();
         $res5_assoc = $res5->fetch_assoc();
         $res6_assoc = $res6->fetch_assoc();
         $res7_assoc = $res7->fetch_assoc();
         $connection->close();
         return array($res1_assoc["count(distinct threadWriter)"], $res2_assoc["count(distinct threadWriter)"], $res3_assoc["count(distinct threadWriter)"], $res4_assoc["count(distinct threadWriter)"], $res5_assoc["count(distinct threadWriter)"], $res6_assoc["count(distinct threadWriter)"], $res7_assoc["count(distinct threadWriter)"]);
     }
 }
 public function LoadMessages()
 {
     global $conversationInfos;
     $myDBConnector = new DBConnector();
     $dbARY = $myDBConnector->infos();
     $connection = new mysqli($dbARY[0], $dbARY[1], $dbARY[2], $dbARY[3]);
     if ($connection->connect_error) {
         echo "Database bağlantı hatası";
     } else {
         mysqli_set_charset($connection, "utf8");
         $query = "SELECT * FROM messages WHERE ((From_msg='" . $conversationInfos["User1"] . "' AND To_msg='" . $conversationInfos["User2"] . "') OR (From_msg='" . $conversationInfos["User2"] . "' AND To_msg='" . $conversationInfos["User1"] . "'))";
         $results = $connection->query($query);
         $num = $results->num_rows;
         echo "<form style=\"display:none;\" id=\"offsetForm_" . $conversationInfos["other"] . "\" method=\"post\" action=\"instantmessage.php?usr1=" . $conversationInfos["User1"] . "&usr2=" . $conversationInfos["User2"] . "&monitor=" . $conversationInfos["WhoIsMonitoring"] . "\">";
         echo "<input name=\"offset\" id=\"offset_" . $conversationInfos["other"] . "\" style=\"display:none;\" type=\"text\" value=\"" . $num . "\"/>";
         echo "</form>";
         while ($curResult = $results->fetch_assoc()) {
             if ($conversationInfos["WhoIsMonitoring"] == $curResult["From_msg"]) {
                 $mode = "EvSahibi";
             } else {
                 $mode = "Deplasman";
             }
             $myMessage = new Message(array($curResult["MessageDate"], $curResult["From_msg"], $curResult["To_msg"], $curResult["Message"], $mode, $curResult["Read_msg"]));
             $myMessage->MessageToHTML();
         }
         $connection->close();
     }
 }
 public function BoardRightUpToHTML()
 {
     global $infos;
     $myIndexSocial = new IndexSocial();
     echo "<div id=\"catcher2\" style=\"border:1px solid #c7d0d5; border-radius:15px;\">";
     $myIndexSocial->IndexSocialToHTML();
     echo "</div>";
     echo "<div id=\"sticky2\" style=\"margin-top:2%;width:100%;\">";
     $myDBConnector = new DBConnector();
     $dbARY = $myDBConnector->infos();
     $connection = new mysqli($dbARY[0], $dbARY[1], $dbARY[2], $dbARY[3]);
     $connection->set_charset("utf8");
     $query = "SELECT * FROM threads WHERE threadCategory=\"" . $infos['boardCategory'] . "\" ORDER BY rand() LIMIT 2";
     $results2 = $connection->query($query);
     while ($curResult2 = $results2->fetch_assoc()) {
         $threadID2 = $curResult2["threadID"];
         $threadDate2 = $curResult2["threadDate"];
         $threadWriter2 = $curResult2["threadWriter"];
         $threadCategory2 = $curResult2["threadCategory"];
         $threadPicture2 = $curResult2["threadPicture"];
         $stepCount2 = $curResult2["stepCount"];
         $threadName2 = $curResult2["threadName"];
         $threadPoint2 = $curResult2["threadPoint"];
         $myThread2 = new Thread(array($threadID2, $threadDate2, $threadWriter2, $threadCategory2, $threadPicture2, $stepCount2, $threadName2, $threadPoint2));
         $myThread2->ThreadToPetitHTML();
     }
     echo "</div>";
     echo "<script>";
     echo "\n\t\t\$(document).ready(function(){\n\t\t\tif (\$(window).width()<=1028)\n\t\t\t{\n\t\t\t\t\$('#catcher2').remove();\n\t\t\t\t\$('#sticky2').remove();\n\t\t\t\t\$('#random_for_mobile').show();\n\t\t\t}\n\t\t});\n\tvar wid = \$('#sticky2').width();\n\tfunction isScrolledTo(elem) {\n    var docViewTop = \$(window).scrollTop(); //num of pixels hidden above current screen\n    var docViewBottom = docViewTop + \$(window).height();\n \n    var elemTop = \$(elem).offset().top; //num of pixels above the elem\n    var elemBottom = elemTop + \$(elem).height();\n \n    return ((elemTop <= docViewTop));\n}\n\n\tvar catcher = \$('#catcher2');\nvar sticky = \$('#sticky2');\n\n\t\$(window).scroll(function() {\n\tif (\$(window).width()>1028){\n    if(isScrolledTo(sticky)) {\n        sticky.css('position','fixed');\n        sticky.css('top','100px');\n\tsticky.css('max-width',wid);\n\t\$('#sticky_footer_div').show(500);\n    }\n\t\n    var stopHeight = catcher.offset().top + catcher.height(); \n\t  if ( stopHeight > sticky.offset().top) {\n        sticky.css('position','absolute');\n        sticky.css('top',stopHeight-70);\n\t\$('#sticky_footer_div').hide(500);\n    }\n}\n});\n\t\t";
     echo "</script>";
 }
 public function YazarBasliklariToHTML()
 {
     global $yazarAdi;
     $myDBConnector = new DBConnector();
     $dbARY = $myDBConnector->infos();
     $connection = new mysqli($dbARY[0], $dbARY[1], $dbARY[2], $dbARY[3]);
     if ($connection->connect_error) {
         echo "Database'e bağlantı sorunu";
     } else {
         $connection->set_charset("utf8");
         echo "<div style=\"overflow:auto;border:1px solid #c7d0d5;border-radius:15px;background-color:#e6e6e6;width:100%;margin-top:4%;font-size:19px;font-family: 'Josefin Sans', sans-serif;color:#cb7c7a;max-width:100%;\">";
         echo "<div style=\"margin-top:5%;text-align:left;margin-right:5%;margin-left:5%;font-size:19px;font-family: 'Josefin Sans', sans-serif;color:#cb7c7a;\">";
         echo "<p style=\"word-wrap:break-word;text-align:left;width:80%;max-width:80%;\">";
         echo "Aynı yazardan bazı süper başlıklar";
         echo "</p>";
         echo "<hr style=\"border:1px solid #c7d0d5;\"/>";
         echo "</div>";
         $res = $connection->query("SELECT * from threads where threadWriter='{$yazarAdi}' ORDER BY threadPoint LIMIT 10");
         while ($curres = $res->fetch_assoc()) {
             $threadID5 = $curres["threadID"];
             $threadDate5 = $curres["threadDate"];
             $threadWriter5 = $curres["threadWriter"];
             $threadCategory5 = $curres["threadCategory"];
             $threadPicture5 = $curres["threadPicture"];
             $stepCount5 = $curres["stepCount"];
             $threadName5 = $curres["threadName"];
             $threadPoint5 = $curres["threadPoint"];
             $myThread5 = new Thread(array($threadID5, $threadDate5, $threadWriter5, $threadCategory5, $threadPicture5, $stepCount5, $threadName5, $threadPoint5));
             $myThread5->ThreadToPetitHTML();
         }
         echo "</div>";
         $connection->close();
     }
 }
 public function IndexGuncelToHTML()
 {
     $myDBConnector = new DBConnector();
     $dbARY = $myDBConnector->infos();
     $connection = new mysqli($dbARY[0], $dbARY[1], $dbARY[2], $dbARY[3]);
     $connection->set_charset("utf8");
     echo "<div style=\"margin:2%;background-color:#e6e6e6;border-bottom:1px solid #c7d0d5;\">";
     echo "<p style=\"font-size:20px;word-wrap:break-word;color:#cb7c7a;font-family: 'Josefin Sans', sans-serif;\">";
     echo "Güncel panolar";
     echo "</p>";
     echo "</div>";
     echo "<div style=\"\">";
     $results = $connection->query("SELECT * FROM boards ORDER BY boardID DESC LIMIT 6 OFFSET 0");
     while ($boardInfos = $results->fetch_assoc()) {
         $myBoard = new Board(array($boardInfos['boardID'], $boardInfos['boardName'], $boardInfos['boardCategory'], $boardInfos['boardCreator'], $boardInfos['boardImage'], $boardInfos['boardDate']));
         $myBoard->BoardToPetitHTML();
     }
     echo "</div>";
     echo "<div id=\"x\" style=\"margin:2%;background-color:#e6e6e6;border-bottom:1px solid #c7d0d5;\">";
     echo "<p style=\"font-size:20px;word-wrap:break-word;color:#cb7c7a;font-family: 'Josefin Sans', sans-serif;\">";
     echo "Güncel içerikler";
     echo "</p>";
     echo "</div>";
     echo "<div style=\"\">";
     if (!$connection->connect_error) {
         $results = $connection->query("SELECT * FROM threads ORDER BY threadID DESC LIMIT 12 OFFSET 0 ");
         while ($curres = $results->fetch_assoc()) {
             $threadID5 = $curres["threadID"];
             $threadDate5 = $curres["threadDate"];
             $threadWriter5 = $curres["threadWriter"];
             $threadCategory5 = $curres["threadCategory"];
             $threadPicture5 = $curres["threadPicture"];
             $stepCount5 = $curres["stepCount"];
             $threadName5 = $curres["threadName"];
             $threadPoint5 = $curres["threadPoint"];
             $myThread5 = new Thread(array($threadID5, $threadDate5, $threadWriter5, $threadCategory5, $threadPicture5, $stepCount5, $threadName5, $threadPoint5));
             $myThread5->ThreadToPetitHTML();
         }
         echo "<div id=\"moreBestDiv\"></div>";
         echo "<div style=\"\">";
         echo "<form id=\"loadMoreBestForm\" method=\"post\" action=\"loadMoreRecentIndex.php\">";
         echo "<input id=\"loadMoreBestOffset\" name=\"loadMoreBestOffset\" style=\"display:none;\" value=\"" . $results->num_rows . "\"/>";
         echo "<button id=\"loadMoreBestButton\" class=\"btn btn-block btn-success\">";
         echo "<i id=\"loadMoreBestSpinner\" style=\"display:none;\" class=\"fa fa-refresh fa-spin\"></i>";
         echo "<span id=\"loadMoreBestTXT\">";
         echo "Daha fazla göster";
         echo "</span>";
         echo "</button>";
         echo "</form>";
         echo "</div>";
     }
     echo "</div>";
     echo "<script type=\"text/javascript\">";
     echo "\n\t\t\t\$(window).scroll(function(){\n\t\t\t\tvar p = \$('#x');\n\t\t\t\tvar pos = p.position();\n\t\t\t\tvar windowpos = \$(window).scrollTop();\n\t\t\t\tif (windowpos >= pos.top) {\n\t\t\t\t\t\$('#indexStickyFooter').fadeIn(500);\n\t\t\t\t}\n\t\t\t\telse\n\t\t\t\t\t\$('#indexStickyFooter').fadeOut(500);\n\t\t\t});\n\t\t\t\$('#loadMoreBestButton').click(function(e){\n\t\t\t\te.preventDefault();\n\t\t\t\t\$('#loadMoreBestTXT').hide();\n\t\t\t\t\$('#loadMoreBestSpinner').show();\n\t\t\t\t\$('#loadMoreBestForm').ajaxForm({\n\t\t\t\t\tsuccess : function(msg){\n\t\t\t\t\t\t\$('#loadMoreBestTXT').show();\n\t\t\t\t\t\t\$('#loadMoreBestSpinner').hide();\n\t\t\t\t\t\tnewoffset = msg.charAt(0);\n\t\t\t\t\t\toldoffset = \$('#loadMoreBestOffset').val();\n\t\t\t\t\t\toldint = parseInt(oldoffset);\n\t\t\t\t\t\tnewint = parseInt(newoffset);\n\t\t\t\t\t\tif (newint==0)\n\t\t\t\t\t\t{\n\t\t\t\t\t\t\t\$('#loadMoreBestTXT').html(\"Hepsi yüklendi\");\n\t\t\t\t\t\t\t\$('#loadMoreBestButton').attr(\"disabled\",true);\n\t\t\t\t\t\t}\n\t\t\t\t\t\t\$('#loadMoreBestOffset').val(oldint+newint);\n\t\t\t\t\t\tmsg2 = msg.substring(1);\n\t\t\t\t\t\t\$('#moreBestDiv').append(msg2);\n\t\t\t\t\t},\n\t\t\t\t\terror : function(){\n\n\t\t\t\t\t}\n\t\t\t\t}).submit();\n\t\t\t});\t\n\t\t";
     echo "</script>";
 }
예제 #12
0
 public function contributorCount()
 {
     global $boardInfos;
     $myDBConnector = new DBConnector();
     $dbARY = $myDBConnector->infos();
     $connection = new mysqli($dbARY[0], $dbARY[1], $dbARY[2], $dbARY[3]);
     $query = "SELECT distinct(contributor) FROM contributions WHERE boardID =\"" . $boardInfos['boardID'] . "\"";
     $results = $connection->query($query);
     return $results->num_rows;
 }
 public function SuggestionsBarToHTML()
 {
     $myIndexSocial = new IndexSocial();
     echo "<div style=\"border:1px solid #c7d0d5; border-radius:15px;\">";
     $myIndexSocial->IndexSocialToHTML();
     echo "</div>";
     global $sinf;
     $myDBConnector = new DBConnector();
     $dbARY = $myDBConnector->infos();
     $connection2 = new mysqli($dbARY[0], $dbARY[1], $dbARY[2], $dbARY[3]);
     if ($connection2->connect_error) {
         echo "Database'e bağlantı sorunu";
     } else {
         $connection2->set_charset("utf8");
         echo "<div style=\"border:1px solid #c7d0d5;border-radius:15px;margin-top:3%;overflow:auto;height:100%;width:100%;max-width:100%;background-color:#e6e6e6;\">";
         echo "<div style=\"margin-top:5%;text-align:left;margin-right:5%;margin-left:5%;font-size:19px;font-family: 'Josefin Sans', sans-serif;color:#cb7c7a\">";
         echo "<p style=\"word-wrap:break-word;text-align:left;width:80%;max-width:80%;\">";
         echo "İlginizi çekebilecek başlıklar";
         echo "</p>";
         echo "<hr style=\"border:1px solid #c7d0d5;\"/>";
         echo "</div>";
         $quelloThreddo = $connection2->real_escape_string($sinf['quelleThread']);
         $sugQuery = "SELECT * FROM threads WHERE threadCategory =\"" . $sinf['quelleCategorie'] . "\" AND threadName<>\"" . $quelloThreddo . "\" ORDER BY RAND() LIMIT 30";
         $results2 = $connection2->query($sugQuery);
         while ($curResult2 = $results2->fetch_assoc()) {
             $threadID2 = $curResult2["threadID"];
             $threadDate2 = $curResult2["threadDate"];
             $threadWriter2 = $curResult2["threadWriter"];
             $threadCategory2 = $curResult2["threadCategory"];
             $threadPicture2 = $curResult2["threadPicture"];
             $stepCount2 = $curResult2["stepCount"];
             $threadName2 = $curResult2["threadName"];
             $threadPoint2 = $curResult2["threadPoint"];
             $myThread2 = new Thread(array($threadID2, $threadDate2, $threadWriter2, $threadCategory2, $threadPicture2, $stepCount2, $threadName2, $threadPoint2));
             $myThread2->ThreadToPetitHTML();
         }
         $sugQuery = "SELECT * FROM threads WHERE threadCategory <>\"" . $sinf['quelleCategorie'] . "\" AND threadName<>\"" . $quelloThreddo . "\" ORDER BY RAND() LIMIT 10";
         $results2 = $connection2->query($sugQuery);
         while ($curResult2 = $results2->fetch_assoc()) {
             $threadID2 = $curResult2["threadID"];
             $threadDate2 = $curResult2["threadDate"];
             $threadWriter2 = $curResult2["threadWriter"];
             $threadCategory2 = $curResult2["threadCategory"];
             $threadPicture2 = $curResult2["threadPicture"];
             $stepCount2 = $curResult2["stepCount"];
             $threadName2 = $curResult2["threadName"];
             $threadPoint2 = $curResult2["threadPoint"];
             $myThread2 = new Thread(array($threadID2, $threadDate2, $threadWriter2, $threadCategory2, $threadPicture2, $stepCount2, $threadName2, $threadPoint2));
             $myThread2->ThreadToPetitHTML();
         }
         echo "</div>";
         $connection2->close();
     }
 }
 public function UserThreadsToHTML()
 {
     global $whichUsr;
     echo "<div style=\"margin-top:2%;\">";
     $myDBConnector = new DBConnector();
     $dbARY = $myDBConnector->infos();
     $connection = new mysqli($dbARY[0], $dbARY[1], $dbARY[2], $dbARY[3]);
     if ($connection->connect_error) {
         echo "Database'e bağlantı sorunu";
     } else {
         $connection->set_charset("utf8");
         $res0 = $connection->query("SELECT * from threads where threadWriter= '{$whichUsr}'");
         $totalCount = $res0->num_rows;
         $res = $connection->query("SELECT * from threads where threadWriter='{$whichUsr}' ORDER BY threadPoint DESC LIMIT 6");
         $curCount = $res->num_rows;
         while ($curres = $res->fetch_assoc()) {
             $threadID5 = $curres["threadID"];
             $threadDate5 = $curres["threadDate"];
             $threadWriter5 = $curres["threadWriter"];
             $threadCategory5 = $curres["threadCategory"];
             $threadPicture5 = $curres["threadPicture"];
             $stepCount5 = $curres["stepCount"];
             $threadName5 = $curres["threadName"];
             $threadPoint5 = $curres["threadPoint"];
             $myThread5 = new Thread(array($threadID5, $threadDate5, $threadWriter5, $threadCategory5, $threadPicture5, $stepCount5, $threadName5, $threadPoint5));
             $myThread5->ThreadToPetitHTML();
         }
         $connection->close();
     }
     echo "<div id=\"more_data_div\" style=\"\">";
     echo "</div>";
     echo "<div style=\"margin:2%;\">";
     if ($totalCount != 0) {
         echo "<form method =\"post\" id =\"userThreadsForm\" action=\"usrThreadsLoadMore.php?usr="******"\">";
         echo "<input name=\"offsetUsrThread\" id=\"offsetUsrThread\" value=\"" . $curCount . "\" style=\"display:none;\" />";
         echo "<input name=\"totalUsrThread\" id=\"totalUsrThread\" value=\"" . $totalCount . "\" style=\"display:none;\" />";
         echo "<button id=\"loadMoreDataButton\" class=\"btn btn-block btn-success\" style=\"\">";
         echo "<i id=\"loadMoreThreadSpinner\" style=\"display:none;\" class=\"fa fa-refresh fa-spin\"></i>";
         echo "<span id=\"loadMoreDataTXT\"> Daha fazla göster </span>";
         echo "</button>";
         echo "</form>";
     } else {
         echo "<span style=\"font-family: 'Josefin Sans', sans-serif;font-size:18px;color:#6e6e6e;\"> Bu yazar henüz başlık oluşturmamış. </span>";
     }
     echo "</div>";
     echo "</div>";
     echo "<script type=\"text/javascript\">";
     echo "\n\t\t\t\$('#loadMoreDataButton').click(function(e){\n\t\t\t\te.preventDefault();\n\t\t\t\t\$('#loadMoreDataTXT').hide();\n\t\t\t\t\$('#loadMoreThreadSpinner').show();\n\t\t\t\t\$('#userThreadsForm').ajaxForm({\n\t\t\t\t\tsuccess : function(msg){\n\t\t\t\t\t\t\$('#loadMoreDataTXT').show();\n\t\t\t\t\t\t\$('#loadMoreThreadSpinner').hide();\n\t\t\t\t\t\toldoffset = \$('#offsetUsrThread').val();\n\t\t\t\t\t\tnewoffset = msg.charAt(0);\n\t\t\t\t\t\toldint = parseInt(oldoffset);\n\t\t\t\t\t\tnewint = parseInt(newoffset);\n\t\t\t\t\t\tif (newint==0)\n\t\t\t\t\t\t{\n\t\t\t\t\t\t\t\$('#loadMoreDataTXT').html('Hepsi yüklendi');\n\t\t\t\t\t\t\t \$('#loadMoreDataButton').attr(\"disabled\", true);\n\t\t\t\t\t\t}\n\t\t\t\t\t\t\$('#offsetUsrThread').val(oldint+newint);\n\t\t\t\t\t\tmsg2 = msg.substring(1);\n\t\t\t\t\t\t\$('#more_data_div').append(msg2);\n\t\t\t\t\t\t\n\t\t\t\t\t},\n\t\t\t\t\terror : function(){\n\n\t\t\t\t\t}\n\t\t\t\t}).submit();\n\t\t\t});\n\t\t";
     echo "</script>";
 }
 public function Find()
 {
     global $whichThread;
     $myDBConnector = new DBConnector();
     $dbARY = $myDBConnector->infos();
     $connection = new mysqli($dbARY[0], $dbARY[1], $dbARY[2], $dbARY[3]);
     if ($connection->connect_error) {
         return "?";
     } else {
         $query = "SELECT * FROM favoriler WHERE threadID='{$whichThread}'";
         $result = $connection->query($query);
         $connection->close();
         return $result->num_rows;
     }
 }
 public function Find()
 {
     global $threadID;
     $myDBConnector = new DBConnector();
     $dbARY = $myDBConnector->infos();
     $connection = new mysqli($dbARY[0], $dbARY[1], $dbARY[2], $dbARY[3]);
     if ($connection->connect_error) {
         return false;
     } else {
         $query = "SELECT count(comment) FROM `comments` WHERE threadID =  " . $threadID;
         $results = $connection->query($query);
         $resassoc = $results->fetch_assoc();
         $connection->close();
         return $resassoc["count(comment)"];
     }
 }
 public function YorumHesapla()
 {
     global $whichUsr;
     $query = "SELECT count(writerName) FROM comments WHERE writerName='{$whichUsr}'";
     $myDBConnector = new DBConnector();
     $dbARY = $myDBConnector->infos();
     $connection = new mysqli($dbARY[0], $dbARY[1], $dbARY[2], $dbARY[3]);
     if ($connection->connect_error) {
         return "?";
     } else {
         $results = $connection->query($query);
         $resultAssoc = $results->fetch_assoc();
         if (isset($resultAssoc["count(writerName)"])) {
             return $resultAssoc["count(writerName)"];
         }
         return 0;
     }
 }
 public function FindForUpMenu()
 {
     global $MessageSeenFinderInfos;
     $myDBConnector = new DBConnector();
     $dbARY = $myDBConnector->infos();
     $connection = new mysqli($dbARY[0], $dbARY[1], $dbARY[2], $dbARY[3]);
     if ($connection->connect_error) {
         return "CONNECT_ERR";
     } else {
         $query = "SELECT * FROM messages WHERE (Read_msg = 'NO' AND To_msg='" . $MessageSeenFinderInfos["To"] . "')";
         $results = $connection->query($query);
         $connection->close();
         if ($results->num_rows > 0) {
             return "YES";
         } else {
             return "NO";
         }
     }
 }
예제 #19
0
 public function isSocial()
 {
     if (isset($_SESSION["user_name"])) {
         $usrname = $_SESSION["user_name"];
         $myDBConnector = new DBConnector();
         $dbARY = $myDBConnector->infos();
         $connection = new mysqli($dbARY[0], $dbARY[1], $dbARY[2], $dbARY[3]);
         if (!$connection->connect_error) {
             $query = "SELECT * FROM users WHERE userName = \"" . $usrname . "\"";
             $results = $connection->query($query);
             $resassoc = $results->fetch_assoc();
             if ($resassoc["userPass"] == "fbuser" || $resassoc["userPass"] == "twtuser") {
                 return "YES";
             } else {
                 return "NO";
             }
         } else {
             return "NO";
         }
     } else {
         return "NO";
     }
 }
<?php

include_once "classes/Thread.class.php";
include_once "classes/DBConnector.class.php";
$cat = $_GET["cat"];
if ($cat == "si") {
    $cat = "Sosyal ilişkiler";
}
$myDBConnector = new DBConnector();
$dbARY = $myDBConnector->infos();
$connection = new mysqli($dbARY[0], $dbARY[1], $dbARY[2], $dbARY[3]);
if ($connection->connect_error) {
    echo "Bağlantı hatası.";
} else {
    $connection->set_charset("utf8");
    $query = "SELECT * from threads WHERE threadCategory=\"" . $cat . "\" ORDER BY threadID DESC LIMIT 8";
    $results = $connection->query($query);
    $offset = $results->num_rows;
    while ($curres = $results->fetch_assoc()) {
        $threadID5 = $curres["threadID"];
        $threadDate5 = $curres["threadDate"];
        $threadWriter5 = $curres["threadWriter"];
        $threadCategory5 = $curres["threadCategory"];
        $threadPicture5 = $curres["threadPicture"];
        $stepCount5 = $curres["stepCount"];
        $threadName5 = $curres["threadName"];
        $threadPoint5 = $curres["threadPoint"];
        $myThread5 = new Thread(array($threadID5, $threadDate5, $threadWriter5, $threadCategory5, $threadPicture5, $stepCount5, $threadName5, $threadPoint5));
        $myThread5->ThreadToPetitHTML();
    }
    echo "<div id=\"categoryTarieGoreSiralaMoreDataDIV\"></div>";
예제 #21
0
 public function commentsToHTML()
 {
     global $contentThreadID;
     $myDBConnector = new DBConnector();
     $dbARY = $myDBConnector->infos();
     $connection = new mysqli($dbARY[0], $dbARY[1], $dbARY[2], $dbARY[3]);
     $myCommenter = new Commenter($contentThreadID);
     $myCommenter->CommenterToHTML();
     echo " <div id=\"comments_wrapper\" style=\"margin-bottom:2%;padding-bottom:1%;margin-top:1%;border:1px solid #c7d0d5;border-radius:15px;width:100%;max-width:100%;background-color:#e6e6e6;\">";
     echo "<div id=\"comments_header_div\" style=\"padding-top:1%;border-bottom:1px solid #c7d0d5;\">";
     echo "<p style=\"color:#cb7c7a;margin-left:2%;font-size:23px;font-family: 'Josefin Sans', sans-serif;\">";
     echo "Yorumlar ";
     echo "<a id=\"yorum_genisletici_a\" style=\"margin-right:3%;float:right;\" href=\"javascript:void(0)\">";
     echo "<img style=\"width:30px;\" id=\"yorum_genisletici_img\" src=\"images/genislet1.gif\" onmouseover=\"this.src='images/genislet2.gif';\" onmouseout=\"this.src='images/genislet1.gif';\" alt=\"genişlet\" title=\"Ferah bir şekilde gör\">";
     echo "</a>";
     echo "</p>";
     echo "</div>";
     echo "<div id=\"comments_commnt_div\" style=\"max-height:203px;overflow:auto;\">";
     if ($connection->connect_error) {
         echo "Database bağlantı sorunu";
     } else {
         $connection->set_charset("utf8");
         $i = 0;
         $querro = "SELECT * FROM comments WHERE threadID=" . $contentThreadID;
         $resso = $connection->query($querro);
         while ($curresso = $resso->fetch_assoc()) {
             $i++;
             $myComment = new Comment(array($curresso["writerName"], $curresso["comment"], $curresso["commentDate"], $curresso["threadID"]));
             $myComment->CommentToHTML();
         }
         if ($i == 0) {
             echo "<br/><p style=\"margin-left:2%;font-size:15px;font-family: 'Josefin Sans', sans-serif;\"> Bu başlıkla alakalı bir yorum girilmemiş </p>";
         }
     }
     echo "</div>";
     echo "</div>";
     echo "<div class=\"modal fade\" id=\"CommentsModal\" tabindex=\"-1\" role=\"dialog\" aria-labelledby=\"basicModal\" aria-hidden=\"true\">";
     echo "<div class=\"modal-dialog\">";
     echo "<div class=\"modal-content\" style=\"background-color:#e6e6e6;\">";
     echo "<div class=\"modal-header\" style=\"background-color:#e6e6e6;border-bottom:1px solid #c7d0d5;\">";
     echo "<p style=\"color:#ec583a;margin-left:4%;font-size:23px;font-family: 'Josefin Sans', sans-serif;\">";
     echo "<button type=\"button\" class=\"close\" data-dismiss=\"modal\" aria-label=\"Close\"><span aria-hidden=\"true\">&times;</span></button>";
     echo "<img src=\"images/headerfil2.jpg\" style=\"margin-right:2%;max-width:10%;\"/>";
     echo "Yorumlar";
     echo "</p>";
     echo "</div>";
     echo "<div class=\"modal-body\" style=\"background-color:#e6e6e6;\">";
     $resso2 = $connection->query($querro);
     while ($curresso2 = $resso2->fetch_assoc()) {
         $myComment2 = new Comment(array($curresso2["writerName"], $curresso2["comment"], $curresso2["commentDate"], $curresso2["threadID"]));
         $myComment2->CommentToHTMLBigSize();
     }
     if ($i == 0) {
         echo "<br/><p style=\"margin-left:2%;font-size:15px;font-family: 'Josefin Sans', sans-serif;\"> Bu başlıkla alakalı bir yorum girilmemiş </p>";
     }
     echo "</div>";
     echo "</div>";
     echo "</div>";
     echo "</div>";
     echo "<script style=\"text/javascript\">";
     echo "\n\t\t\t\t\$(document).ready(function(){\n\t\t\t\t\tvar element = document.getElementById('comments_commnt_div');\n\t\t\t\t\telement.scrollTop = element.scrollHeight;\n\t\t\t\t\t\$('#yorum_genisletici_a').click(function(){\n\t\t\t\t\t\t\$('#CommentsModal').modal(\"toggle\");\n\t\t\t\t\t});\n\n\n\t\t\t\t});\n\t\t\t";
     echo "</script>";
 }
예제 #22
0
 public function SearchToHTML()
 {
     global $query;
     $query = htmlspecialchars($query);
     $myDBConnector = new DBConnector();
     $dbARY = $myDBConnector->infos();
     $connection = new mysqli($dbARY[0], $dbARY[1], $dbARY[2], $dbARY[3]);
     echo "<div style=\"background-color:#e6e6e6;border:1px solid #c7d0d5; border-radius:15px;\">";
     echo "<div style=\"margin:2%;\">";
     echo "<p style=\"color:#ec583a;word-wrap:break-word;font-family: 'Josefin Sans', sans-serif;font-size:20px;\">";
     echo "\"" . $query . "\" için arama sonuçları";
     echo "</p>";
     echo "</div>";
     echo "<ul class=\"nav nav-tabs\" style=\"margin:2%;font-family: 'Josefin Sans', sans-serif;font-size:17px;\">";
     echo "<li class=\"active\"><a href=\"#\" id=\"searchThreadsLink\" data-toggle=\"tab\">Başlıklar</a></li>";
     echo "<li class=\"\"><a href=\"#\" id=\"searchWritersLink\" data-toggle=\"tab\">Yazarlar</a></li>";
     echo "</ul>";
     echo "<div class=\"tab-content\">";
     echo "<div class=\"tab-pane-active\" id=\"searchThreadsDIV\">";
     echo "<div style=\"\">";
     if ($connection->connect_error) {
         echo "Database'e bağlantı sorunu";
     } else {
         $connection->set_charset("utf8");
         $searchQuery = "SELECT * FROM threads WHERE threadName LIKE '%{$query}%' ORDER BY threadPoint desc LIMIT 8";
         $results = $connection->query($searchQuery);
         $offsetCount = $results->num_rows;
         if ($offsetCount == 0) {
             echo "<div style=\"margin:2%;\"><p style=\"color:#6e6e6e;word-wrap:break-word;font-family: 'Josefin Sans', sans-serif;font-size:17px;\"> Böyle bir başlık bulunamadı. </p></div>";
         }
         while ($curres = $results->fetch_assoc()) {
             $threadID5 = $curres["threadID"];
             $threadDate5 = $curres["threadDate"];
             $threadWriter5 = $curres["threadWriter"];
             $threadCategory5 = $curres["threadCategory"];
             $threadPicture5 = $curres["threadPicture"];
             $stepCount5 = $curres["stepCount"];
             $threadName5 = $curres["threadName"];
             $threadPoint5 = $curres["threadPoint"];
             $myThread5 = new Thread(array($threadID5, $threadDate5, $threadWriter5, $threadCategory5, $threadPicture5, $stepCount5, $threadName5, $threadPoint5));
             $myThread5->ThreadToPetitHTML();
         }
         echo "<div id=\"searchMoreThreadMoreDataDiv\"></div>";
         if ($offsetCount != 0) {
             echo "<div style=\"margin:2%;\">";
             echo "<form id=\"searchMoreThreadForm\" action=\"searchMoreThread.php?query=" . $query . "\" method=\"post\">";
             echo "<input style=\"display:none;\" name=\"showMoreSuggestionOffset\" id=\"showMoreSuggestionOffset\" value=\"" . $offsetCount . "\"/>";
             echo "<button id=\"showMoreSuggestionButton\" class=\"btn btn-block btn-success\"><i id=\"searchMoreThreadSpinner\" style=\"display:none;\" class=\"fa fa-refresh fa-spin\"></i><span id=\"searchMoreThreadTXT\"> Daha fazla göster </span> </button>";
             echo "</form>";
             echo "</div>";
         }
     }
     echo "</div>";
     echo "</div>";
     echo "<div class=\"tab-pane\" id=\"searchWritersDIV\">";
     echo "<div style=\"margin:2%;\">";
     $searchWriterQuery = "SELECT * FROM users WHERE userName LIKE '%{$query}%'";
     $writerresults = $connection->query($searchWriterQuery);
     while ($wcurres = $writerresults->fetch_assoc()) {
         echo "<p style=\";word-wrap:break-word;font-family: 'Josefin Sans', sans-serif;font-size:15px;\">";
         echo "<a href=\"user.php?name=" . $wcurres["userName"] . "\">" . $wcurres["userName"] . "</a>";
         echo "</p>";
     }
     if ($writerresults->num_rows == 0) {
         echo "<p style=\"color:#6e6e6e;word-wrap:break-word;font-family: 'Josefin Sans', sans-serif;font-size:17px;\"> Böyle bir yazar bulunamadı.</p>";
     }
     echo "</div>";
     echo "</div>";
     echo "</div>";
     echo "</div>";
     echo "<script type=\"text/javascript\">";
     echo "\n\t\t\$('#searchThreadsLink').click(function(){\n\t\t\t\$('#searchWritersDIV').attr('class','tab-pane');\n\t\t\t\$('#searchThreadsDIV').attr('class','tab-pane-active');\n\t\t});\n\t\t\$('#searchWritersLink').click(function(){\n\t\t\t\$('#searchThreadsDIV').attr('class','tab-pane');\n\t\t\t\$('#searchWritersDIV').attr('class','tab-pane-active');\n\t\t});\n\t\t\$('#showMoreSuggestionButton').click(function(e){\n\t\t\te.preventDefault();\n\t\t\t\$('#searchMoreThreadTXT').hide();\n\t\t\t\$('#searchMoreThreadSpinner').show();\n\t\t\t\$('#searchMoreThreadForm').ajaxForm({\n\t\t\t\tsuccess : function(msg){\n\t\t\t\t\t\$('#searchMoreThreadSpinner').hide();\n\t\t\t\t\t\$('#searchMoreThreadTXT').show();\n\t\t\t\t\toldoffset = \$('#showMoreSuggestionOffset').val();\n\t\t\t\t\tnewoffset = msg.charAt(0);\n\t\t\t\t\toldint = parseInt(oldoffset);\n\t\t\t\t\tnewint = parseInt(newoffset);\n\t\t\t\t\tif (newint==0)\n\t\t\t\t\t{\n\t\t\t\t\t\t\$('#searchMoreThreadTXT').html('Hepsi yüklendi');\n\t\t\t\t\t\t\$('#showMoreSuggestionButton').attr(\"disabled\", true);\n\t\t\t\t\t}\n\t\t\t\t\t\$('#showMoreSuggestionOffset').val(oldint+newint);\n\t\t\t\t\tmsg2 = msg.substring(1);\n\t\t\t\t\t\$('#searchMoreThreadMoreDataDiv').append(msg2);\n\t\t\t\t},\n\t\t\t\terror : function(){\n\n\t\t\t\t}\t\n\t\t\t}).submit();\t\t\n\t\t});\n\t";
     echo "</script>";
 }