help creating a forum

Oel

I will com with some problems on the way if u can help me then it would be NICE!!

i'll start with 2 problems

showing that a user havent seen or have seen a topic

and Unknown column 'rid' in 'field list' this text keeps coming up on one of the sites

leatherback

Set a marker
So, you are calling a colum rid which doesn't exist.

Can be more specific without having some clue on how things are setup.

Oel

I have build the forum with mysql and php!
I need some kind of function which shows that marker?

kikki

Hiya,
Few weeks ago I've done my own forum, codes are MESSED UP, but works.. 🙂
(trust me it's waste of TIME, installing phpbb is much easier..)

letz see here.. ok, so u want to show if there is a new topic or not, right?

a) List topics (do a query chk, and use list() function to list)
b) chk out this code.. if u have this table ofcourse.. 🙂 (this might not work on ur system, but here is the IDEA..)

//mysql table:
CREATE TABLE `forum_readtopics` (
  `id` int(11) NOT NULL auto_increment,
  `forum_id` text NOT NULL,
  `topic_id` text NOT NULL,
  `username` varchar(50) NOT NULL default '',
  `new_post` char(1) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=45 ;



<?php
		//Chk new/old topics!
		$TopicRead = "SELECT * FROM forum_readtopics WHERE username='$Logged_username' AND topic_id='$idA' AND new_post='0'";
		if(mysql_num_rows(mysql_query($TopicRead)) > 0)
		{
		//oldtopic
		echo '<img src="images/oldtopic.gif" width="20" height="20">';
		}else{
		//newtopic
		echo '<img src="images/newtopic.gif" width="20" height="20">';
		}		

	?>

Oel

a) List topics (do a query chk, and use list() function to list)

dont understand this:S

but useful untill now

Oel

the thing i need is how i can make a topic an old topic

Oel

This is what ive done!

mysql_query("INSERT INTO `forum_readtopics` (`forum_id`,`topic_id`,`username`,`new_post`) VALUES ('$forum_id','$topic_id','$username','0')");

But wont this fill the table up?

Oel

ive found out how the table wouldnt become full, using this code everytime a post is done

mysql_query("DELETE FROM `forum_readtopics` WHERE topic_id = $topic_id");

BUT I DO HAVE ANOTHER PROBLEM🙁

How can u insert the codes and smileys into the "writing box" by clicking on then! like on other forums

kikki

This way I list the topics... as I said b4, this is a mess.. might not work on ur system so this is just to show the idea..

##########Grabbing Topics###############
//poorly lol..

<?php
//connect to mysql
include 'dbconfig.php';

//---------------------------------!
//I'm grabbing sessions here to see whats the current forum
@session_start();

$Selected_forum_id = $_GET['f'];
$forum_idd2 = $Selected_forum_id;

$_SESSION['$forum_idd2'] = $forum_idd2;
@session_register("forum_idd2"); 
$forum_idd2++; 

//---------------------------------!


//IF LOGGEDIN
if($session->logged_in){



$rowsPerPage = 20;
$LimitPerPage = 0;
$Limited_Replies = $_GET['start'];

if ($Limited_Replies == '')
{
$Limited_Replies = 0;
}



$Selected_forum_id = $_GET['f'];


$queryE = "SELECT id, topic, replies, author, views, last_post, last_postby, forum_id FROM forum_topics WHERE forum_id='$Selected_forum_id' ORDER BY id DESC LIMIT " . $Limited_Replies . ", " . $rowsPerPage;

// simply execute the query
$resultE = mysql_query($queryE); 


if(mysql_num_rows($resultE) == 0)
{
//if there are no any topics then... 
//echo 'No topics were found!';
}
else
{

// grab the topics.. from mysql
while($rowE = mysql_fetch_array($resultE))
{
    list($idA, $topicA, $repliesA, $authorA, $viewsA, $last_postA, $last_postbyA, $forum_idA) = $rowE; //$id, 

?>	
	<table width="100%" border="0" cellpadding="0" cellspacing="0" background="images/forum/fo2.jpg">
      <tr>
        <td width="40" height="30" align="center" valign="middle">
		<?php
		//Chk new/old posts!
		$TopicRead = "SELECT * FROM forum_readtopics WHERE username='$Logged_Member' AND topic_id='$idA' AND new_post='0'";
		if(mysql_num_rows(mysql_query($TopicRead)) > 0)
		{
		//oldtopic
		echo '<img src="images/oldtopic.gif" width="20" height="20">';
		}else{
		//newtopic
		echo '<img src="images/newtopic.gif" width="20" height="20">';
		}		

	?>
	</td>
	<td width="280" valign="middle" class="topics">&nbsp;&nbsp;<a href="index.php?forum&viewtopic=<?=$idA?>"><?=$topicA?></a>
	</td>
    <td width="70" align="center" valign="middle" class="forum_details"><?=$repliesA?></td>
    <td width="80" align="center" valign="middle" class="users"><a href="index.php?viewprofile=<?=$idA?>"><?=$authorA?></a></td>
    <td width="70" align="center" valign="middle" class="forum_details"><?=$viewsA?></td>
    <td width="120" align="center" valign="middle" class="normal_small">
	<?
	echo $last_postA . '<br>' . '<img src="images/forum/a1.gif">&nbsp;<a href="index.php?forum&viewprofile='.$idA.'"><font class="forum_details">' . $last_postbyA . '</font></a>';

	?>
	</td>
  </tr>
</table>	
<?php
}
}
?>

 <table width="100%" border="0" cellpadding="0" cellspacing="0" align="right">
  <tr>
    <td width="100%" height="25" align="right" valign="middle" class="style2">
	<?php

// need another query to get the total amount of rows in our table
$query = "SELECT count(*) AS COUNT FROM forum_topics WHERE forum_id='" . $_GET['f'] . "'";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
$numrows = $row['COUNT'];


//if there are under 20 topics then don't show!
if ($numrows > 20){


if($Limited_Replies > 0) 
   echo "<a href=\"index.php?forum&f=".$_GET['f']."&start=" . ($Limited_Replies - 20) .
        "\"><b><font class=\"message\"><img src=\"images/l1.gif\" border=\"0\" align=\"absbottom\"></font></b></a>\n";

echo '| ';



//list numbers
$doop = (($numrows) / 20);
//echo '<br>| ';


for ($i = 0; $i < $doop; $i++) {

  $url = "<a href=\"index.php?forum&f=".$_GET['f']."&start=" . (($i * 20));
  echo "<a href=\"$url\"><b>$i</b></a>";
  echo ', ';

}

echo ' |';

//next
if($numrows > ($Limited_Replies + 20))
   echo "&nbsp;&nbsp;<a href=\"index.php?forum&f=".$_GET['f']."&start=" . ($Limited_Replies + 20) .
        "\"><b><font class=\"message\"><img src=\"images/r1.gif\" border=\"0\" align=\"absbottom\"></font></b></a>\n";


}
?>&nbsp;</td>
  </tr>
</table>


<?
}else{
echo '<font class="style1"><br><br><br><br><br><br>Error: Please login to view the forums!</font><br><br><br><br><br>';
echo '<meta http-equiv="refresh" CONTENT="3"; URL="javascript: history.go(-1)">'; 
}
?>

kikki

Oel wrote:
How can u insert the codes and smileys into the "writing box" by clicking on then! like on other forums

Use javascript... OnClick methord.. bit of googling will help on this matter.. 🙂
search for: +insert text +textarea +javascript +onclick

http://www.webdeveloper.com/forum/archive/index.php/t-32799.html

Atomiku

Hmm I dunno if this helps but I can email my small forum code to you if you want

You might be able to learn something from it.

Oel

yeah that would be nice

oel@oelfam.com

and another problem ive worked on whole of this morning

How do u show when peoples online?

Atomiku

To show people who are online, You do something like this:

Step one: Create a table called "Sessions" and have two rows, "User" and "LastVisit"
Step two: When ever a page is visited on your site by a logged in user, You set "LastVisit" to time() where "User" = Logged in user.
Then on the page have a little query that deletes all sessions where lastvisit is more than 5 mins ago. I believe it would be this: MYSQL_QUERY("DELETE FROM sessions WHERE LastVisit > " . (time() - 300));

Hope this helps. If there are any errors, hopefully some other person who is more experienced than me will correct it 🙂

thorpe

buddy, without being rude or anything, but maybe you want to go do a tutorial on the subject. i meen, otherwise your just going to be in here every few days asking questions. its not really going to get you anywhere.

there is a tutorial here that might help you out. really there are lots of little pieces to building a forum. comming in here asking about all of these pieces one by one isn't really how this forum is meant to work.