Forum Code

Anon

Hi I'm writing a forum in php. I have written a few pages and I can view posts and add a reply to existing posts but I can't add a new topic.
At the moment I have a topic_id and an id in the mysql table. The id is set on auto_increment so that it is unique to any post with the same topic_id which works fine for adding reply's.
Now I need to be able to add new posts which I will use a separtete file for but I can't use auto_increment again.
I just need the script to add a new number one above the highest existing (topic_id field) without using auto_increment.

Is there a way of doing this?

Thanks in advance,

Danny Hill

andreash

Try

mysql_query("Select max(topic_id) from forum");

That will select the highest topic_id in the db.

Anon

I just started PHP and am also making a forum script. I have made it so the layout is 100% completly customizable.

Right now I'm just getting into SQL so the script uses ascii text files to store stuff but this will need to change...

Each forum on the board(I'm doing a multi forums board script) theres a directory(fourm0, forum1, etc) with a file topics.dat this file holds the title and and number for every topic. then theres a series of files(topic0.dat, topic1.dat, etc) in this folder containing all the data for that topic.

I have two lines for every topic in the topics.dat file so to add a topic I choose the number of lines in topics.dat and divide by 2.

Anon

You might wanna consider:

http://www.phorum.org 😛

Anon

Andreas,
Thanks for the reply, I can now add 1 to this number and insert into the table,

Thanks Again,

Danny

Anon

Just one more point of a forum code I can't get. When displaying all messages how do I make it so that new topics display differently to replies.
I would like it to display like so:

(Bullet)New Topic
(Bullet)Re: New topic
(Bullet)Re: New topic

(Bullet)Different topic
(Bullet)Re: Different topic

I can get it to display in the correct order and everything but at the moment it displays (with the bullets):

New topic
Re: new topic
Re:..etc

The results in the same topic will have the same topic_id so I need the code to display results with the same topic_id differently to how it displays them with a different topic_id.
Can this be done?

andreash

Do you mean like I have on my forum?
http://hillberg.nu/imacsidan/forum

Then its just two have two loops.
The first one for the topics, and the second inside the first for the replies.

This is just ex.
From the mysql table you get 4 topics ($topics = "4"😉

This is what I use.

for ($i = $topics; $i > 0; $i--) {
// I did the for loop this way to get it to DESC the selection of the topics.
// Then select the posts from mysql where the topic matches $i.
// Then the selection of posts.

	$l = mysql_query("Select * from forum where thread='$i' order by post");

	for ($r = 1; $r <= $post_num; $r++) {
	// Gets the entries, I use mysql_fetch_array
	$info = mysql_fetch_array($l);

		echo $info[somefield];

	}

}
I hope I did explain correctly, I didn't use the accuall code from my forum, just the one in my head.
And Crazytoon, the thing is that you want to do it yourself.
If you don't understand what I'm saying I can give you the forum code I have.

Good Luck!

Anon

Thats true.. i just wanted to tell about the option so maybe he/she can get it and see how they did it.. i learn from ppl code all the time.. but I do see your point 🙂

Anon

I use a diferent method of displaying threads. I display a list like:

Topic one
New topic
Hi guys

you click one and it shows that topic and all replies to it.

Anon

Hi,

Just tried to create code to this but I'm having no luck.
Once the max number has been called from the table forum I need to add 1 to the result and then insert the new number into the table. I have tried numerous codes but none of them work.

What is the code for doing this, I can insert data, the difficult bit is adding 1 to the result.

andreash

When you have the nr from the mysql just add 1, like this...

The nr from mysql = $nr = "12";

Then simply put
++$nr;

And the $nr should now be set to 13.

Anon

Thanks for the reply. Got a code to work about 2 seconds before I received the e-mail about your message.
Tonights challenge is getting the messages to display using your other message.

Thanks Again,

Danny

Anon

The last question - promise.

I have everything up and running correctly now except one thing.
When entering a message into the text area it completely ignores any line breaks. For instance I enter:

Welcome to

Plane Mad

Something else

It appears as:

Welcome to Plane Mad Something else

How do I get it to appear exactly how I entered it?

Thanks everyone for all of your help with this.

andreash

Use str_replace for that.

Like this...

$message = str_replace("\n","<br>",$message);

That should fix you problem. And ask away if you have any more questions, I'm happy you help.