Member Avatar for braane

Hi,

This is my first post here, I know I probably don't have the acceptance of the community yet or anything, but I really need help with this.

I payed someone to make a custom php website for me... it includes lots of things that I had requested. The only problem is, when we were discussing what to put in the forum I never told the guy that I would need the ability to sticky a thread.

What piece of code would I need to add to my script in order to make a thread sticky.

I will go ahead and post the whole code if it is needed... I guess that would be a good way to share my info for information in return. (the script is rather good)

I really only know the basics of php, so you will need to bare with me.

<? include('includes/config.php'); ?>
<?
    // Variables
    $user_id = $_SESSION['logged_id'];
    $get_user = mysql_query("SELECT admin FROM users WHERE id='$user_id'") or die(mysql_error());
    if (mysql_num_rows($get_user) != 0) {
        $user_admin = mysql_result($get_user,0,'admin');
    }
    $time = time();
    // Forum GETs
    $g_forum = $_GET['forum'];
    $g_topic = $_GET['topic'];
    $g_post = $_GET['post'];
    $g_do = $_GET['do'];

    if ($_SESSION['logged_is'] == true) {
        // POST - New Topic
        if (isset($_POST['ntopic_title'])) {
            $ntopic_title = mysql_real_escape_string($ntopic_title);
            $ntopic_content = mysql_real_escape_string($ntopic_content);
            if ($ntopic_title != "" && $ntopic_content != "") {
                $ins_topic = mysql_query("INSERT INTO f_topics (forum, title, posted, author) VALUES ('$g_forum','$ntopic_title','$time','$user_id')");
                $get_topic = mysql_query("SELECT id FROM f_topics WHERE title='$ntopic_title' ORDER BY id DESC LIMIT 1");
                $topic_id = mysql_result($get_topic,0,'id');
                $ins_post = mysql_query("INSERT INTO f_posts (topic, forum, author, posted, message) VALUES ('$topic_id','$g_forum','$user_id','$time','$ntopic_content')");
                header("Location: forums.php?topic=".$topic_id);
            } else {
                $page_error = "You must enter ALL fields!";
            }
        }
        
        // POST - New Post
        if (isset($_POST['npost_content'])) {
            $npost_content = mysql_real_escape_string($npost_content);
            $npost_title = mysql_real_escape_string($npost_title);
            if ($npost_content != "") {
                $upd_topic = mysql_query("UPDATE f_topics SET posted=$time WHERE id=$g_topic");
                $get_forum = mysql_query("SELECT forum FROM f_topics WHERE id=$g_topic");
                $topic_forum = mysql_result($get_forum,0,'forum');
                $ins_post = mysql_query("INSERT INTO f_posts (topic, forum, author, posted, message, title) VALUES ('$g_topic','$topic_forum','$user_id','$time','$npost_content','$npost_title')");
                $get_posts = mysql_query("SELECT * FROM f_posts WHERE topic=$g_topic");
                $entry_count = mysql_num_rows($get_posts);
                if ($entry_count != 0) {
                    $page_count = ceil($entry_count/10);
                } else {
                    $page_count = 1;
                }
                header("Location: forums.php?topic=".$g_topic."&page=".$page_count);
            } else {
                $page_error = "You must enter ALL fields!";
            }
        }
        
        // POST - Edit Post
        if (isset($_POST['epost_content'])) {
            $epost_content = mysql_real_escape_string($epost_content);
            if ($epost_content != "") {
                $get_topic = mysql_query("SELECT topic, author FROM f_posts WHERE id=$g_post");
                $post_author = mysql_result($get_topic,0,'author');
                if ($post_author == $user_id || $user_admin == true) {
                    $post_topic = mysql_result($get_topic,0,'topic');
                    $upd_post = mysql_query("UPDATE f_posts SET message='$epost_content' WHERE id=$g_post");
                    header("Location: forums.php?topic=".$post_topic);
                } else {
                    header("Location: forums.php?do=editpost&id=".$g_post);
                }
            } else {
                $page_error = "You must enter ALL fields!";
            }
        }
        
        // DELETE Post
        if ($g_do == "delete") {
            if ($g_post != "") {
                $del_post = mysql_query("DELETE FROM f_posts WHERE id=$g_post");
                header('Location: forums.php?topic='.$g_topic);                
            } else {
                $del_topic = mysql_query("DELETE FROM f_topics WHERE id=$g_topic");
                $del_post = mysql_query("DELETE FROM f_posts WHERE topic=$g_topic");
                header('Location: forums.php?forum='.$g_forum);              
            }
        }
        
        // POST - Move Forum
        if (isset($_POST['move_forum']) && $user_admin == true) {
            $upd_topic = mysql_query("UPDATE f_topics SET forum='$move_forum' WHERE id=$g_topic");
            $upd_posts = mysql_query("UPDATE f_posts SET forum='$move_forum' WHERE forum=$g_forum");
            header('Location: forums.php?forum='.$move_forum);
        }
        
        // CLOSE/OPEN Topics
        if ($g_do == "close") {
            $upd_topic = mysql_query("UPDATE f_topics SET closed=1 WHERE id=$g_topic");
            header('Location: forums.php?forum='.$g_forum);
        }
        if ($g_do == "open") {
            $upd_topic = mysql_query("UPDATE f_topics SET closed=0 WHERE id=$g_topic");
            header('Location: forums.php?forum='.$g_forum);
        }
    }
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN">
<html lang="en">
<head>
    <? include('parts/head.php'); ?>
</head>
<body>
    <div id='wrapper'>
        <? include('parts/header.php'); ?>
        <div id='content'>
            <div id='content_left'>
                <div id='content_text'>
                    <?
                        // Paging
                        $current_page = $_GET['page'];
                        if ($current_page == "") {
                            $current_page = 1;
                        }
                        $off_start = ($current_page - 1)*10;
                        // Page Location
                        $page_location = $_SERVER['REQUEST_URI'];
                        if (strstr($page_location,"?") == false) {
                            $page_location .= "?";
                        } else {
                            $page_location .= "&";
                        }   
                        // Show Forums
                        if ($g_forum == "" && $g_topic == "" && $g_post == "") {
                            $done = true;
                            print("<h5>FORUMS</h5>");
                            print("<br /><table><tr align='center'><td width='200'><h4>FORUM</h4></td><td width='100'><h4>TOPICS</h4></td><td width='100'><h4>POSTS</h4></td><td width='200'><h4>LAST POST</h4></td></tr>");
                            $get_forums = mysql_query("SELECT * FROM f_forums ORDER BY sort") or die(mysql_error());
                            while($row = mysql_fetch_array($get_forums)) {
                                $forum_id = $row['id'];
                                $forum_title = $row['title'];
                                $forum_desc = $row['description'];
                                // Topic Count
                                $get_topics = mysql_query("SELECT id FROM f_topics WHERE forum=$forum_id") or die(mysql_error());
                                $topic_count = mysql_num_rows($get_topics);
                                // Post Count
                                $get_posts = mysql_query("SELECT id FROM f_posts WHERE forum=$forum_id");
                                $post_count = mysql_num_rows($get_posts);
                                // Last Post
                                $get_post = mysql_query("SELECT * FROM f_posts WHERE forum=$forum_id ORDER BY posted DESC LIMIT 1");
                                if (mysql_num_rows($get_post) != 0) {
                                    $post_posted = date('M. j Y, g:i A', mysql_result($get_post,0,'posted'));
                                    $post_author = mysql_result($get_post,0,'author');
                                    $post_topic = mysql_result($get_post,0,'topic');
                                    $get_author = mysql_query("SELECT username FROM users WHERE id=$post_author");
                                    $author_name = mysql_result($get_author,0,'username');
                                    $get_topic = mysql_query("SELECT title FROM f_topics WHERE id=$post_topic");
                                    $topic_title = mysql_result($get_topic,0,'title');
                                    print("<table><tr align='center'><td width='200'><b><a href='forums.php?forum=".$forum_id."'>".$forum_title."</a></b><br />".$forum_desc."</td><td width='100'>".$topic_count."</td><td width='100'>".$post_count."</td><td width='200'>".$post_posted."<br />by ".$author_name."<br />in <a href='forums.php?topic=".$post_topic."'><b>".$topic_title."</b></a></td></tr>");
                                } else {
                                    print("<table><tr align='center'><td width='200'><b><a href='forums.php?forum=".$forum_id."'>".$forum_title."</a></b><br />".$forum_desc."</td><td width='100'>".$topic_count."</td><td width='100'>".$post_count."</td><td width='200'>&nbsp;<br /><i>No Posts Found</i><br />&nbsp;</td></tr>");
                                }
                            }
                            print("</table>");
                        }
                        // Show Topics
                        if ($g_forum != "" && $g_do == "") {
                            $done = true;
                            $get_forum = mysql_query("SELECT * FROM f_forums WHERE id=$g_forum");
                            $forum_title = mysql_result($get_forum,0,'title');
                            print("<h5><a href='forums.php'>FORUMS</a> > VIEWING ".strtoupper($forum_title)."</h5>");
                            print("<center><table><tr><td align='right' colspan='5' width='600'><form method='POST'><input class='button' type='button' value='New Topic' onClick=\"window.location.href='forums.php?do=newtopic&forum=".$g_forum."'\"/></form></td></tr><tr align='center'><td width='150'><br><h4>TOPIC</h4></td><td width='70'><br><h4>POSTS</h4></td><td width='70'><br><h4>VIEWS</h4></td><td width='110'><br><h4>STARTER</h4></td><td width='200'><br><h4>LAST POST</h4></td></tr>");
                            $get_topics_count = mysql_query("SELECT * FROM f_topics WHERE forum=$g_forum");
                            $entr
  • 2 Contributors
  • 1 Reply
  • 79 Views
  • 18 Hours Discussion Span
  • Latest Post Latest Post by pritaeas
Member Avatar for pritaeas

As far as I can see from your file, you'll need an extra column in f_topics (sticky), which you can use in the ORDER BY on line 169.

Then you will need to add a checkbox to a new post allowing it to be set as sticky.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.