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 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 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 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>";
}
$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>";
echo "<div style=\"margin:2%;\">";
echo "<form id=\"categoryTariheGoreSiralaForm\" method=\"post\" action=\"categoryTariheGoreSiralaLoadMore.php?cat=" . $cat . "\">";
echo "<input style=\"display:none;\" type=\"text\" id=\"categoryTarieGoreSiralaOffset\" name=\"categoryTarieGoreSiralaOffset\" value=\"" . $offset . "\"/>";
echo "<button id=\"categoryTariheGoreSiralaButton\" class=\"btn btn-block btn-success\"><i id=\"categoryTariheGoreSiralaSpinner\" style=\"display:none;\" class=\"fa fa-refresh fa-spin\"></i><span id=\"categoryTariheGoreSiralaTXT\">Daha fazla göster</span></button>";
echo "</form>";
echo "</div>";
echo "<script type=\"text/javascript\">";
echo "\n\t\t\t\$('#categoryTariheGoreSiralaButton').click(function(e){\n\t\t\t\te.preventDefault();\n\t\t\t\t\$('#categoryTariheGoreSiralaTXT').hide();\n\t\t\t\t\$('#categoryTariheGoreSiralaSpinner').show();\n\t\t\t\t\$('#categoryTariheGoreSiralaForm').ajaxForm({\n\t\t\t\t\tsuccess : function(msg)\n\t\t\t\t\t{\n\t\t\t\t\t\t\$('#categoryTariheGoreSiralaTXT').show();\n\t\t\t\t\t\t\$('#categoryTariheGoreSiralaSpinner').hide();\n\t\t\t\t\t\toldoffset = \$('#categoryTarieGoreSiralaOffset').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\$('#categoryTariheGoreSiralaTXT').html('Hepsi yüklendi');\n\t\t\t\t\t\t\t\$('#categoryTariheGoreSiralaButton').attr(\"disabled\", true);\n\t\t\t\t\t\t}\n\t\t\t\t\t\t\$('#categoryTarieGoreSiralaOffset').val(oldint+newint);\n\t\t\t\t\t\tmsg2 = msg.substring(1);\n\t\t\t\t\t\t\$('#categoryTarieGoreSiralaMoreDataDIV').append(msg2);\n\t\t\t\t\t},\n\t\t\t\t\terror : function()\n\t\t\t\t\t{\n\t\t\t\t\t\t\n\t\t\t\t\t}\n\t\t\t\t}).submit();\n\t\t\t});\n\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>";
}
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>";
}
}
