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>";
}
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>";
}
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";
}
}
}
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>";
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\">×</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>";
}
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>";
}