[RESOLVED] Php/Mysql forum coding help

[trickytiger]

hi, can someone please help me code a forum in php & mysql that does the following:

1. Clickable smileys when posting and shows them in the post
2. Membership system (login/logout)
3. The members that are currently online
4. Memberlist
5. Shows number of guests and number of members online
6. Able to search forums
7. Category system
8. Templating system
9. Say logged in as:
10. Private Messaging system

I would just download one like phpbb, but I need to know the code so I can add more features later on.

[gufmn]

Read the tutorials, start wirting code, then ask for more specific help when you get stuck.

I'm not sure you understand the time it will take to do what your asking. If this is your first project, it's a huge undertaking.

[trickytiger]

I know it takes a long time to code and are willing to spend months coding it, do you know of any tutorials that may help me?

[Weedpacket]

http://www.phpbuilder.com/columns/index.php3?cat=6&subcat=42

[trickytiger]

thanks for the help, when I get a working version up and running i'll post a link here so you can see my work.

[trickytiger]

I forgot to mention i'm coding this from an old version that I made, i'm recoding because I cut the php to far away from the html by making the server parse all the html and couldn't get the php back inside html areas without including it in an iframe.

[trickytiger]

i've fixed it so you can add php inside html, but I can't figure out how to add a category system and pm system, can anyone help me with these?

[thorpe]

this board is more about helping you fix specific code issues. we dont do tutorials, there are thousands already around. have you tried searching?

[trickytiger]

yes I have, but I haven't been able to find any yet

[trickytiger]

ok, i've written a script to enter the categories into the database, except when I go to add a category it comes up with this error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

here is the code for it:

##### CATEGORIES #####
if($action == "categories" && $HTTP_POST_VARS['submit'] == "") {
    cp_categories_header();

$query = mysql_query('SELECT * FROM cmf_categories ORDER BY dorder') or die(mysql_error());
while($categories = mysql_fetch_array($query)) {
    cp_categories_row($category);
}	

cp_categories_footer();

}

if($action == "categories" && $HTTP_POST_VARS['submit'] != "") {
	$query = mysql_query("SELECT * FROM $db_categories") or die(mysql_error());
	while($categories = mysql_fetch_array($query)) {
		$name = "name$categories[cid]";
		$name = "${$name}";
		$dorder = "dorder$categories[cid]";
		$dorder = "${$dorder}";
		$delete = "delete$categories[cid]";
		$delete = "${$delete}";

	if($delete != "") {
		mysql_query("DELETE FROM $db_categories WHERE cid='$delete'") or die(mysql_error());
	}

	mysql_query("UPDATE $db_categories SET name='$name', dorder='$dorder' WHERE cid='$categories[cid]'") or die(mysql_error());
}

if($newname != "") {
	mysql_query("INSERT INTO $db_categories VALUES ('', '$newname', '$newdorder', '', '')") or die(mysql_error());
}

echo "Categories updated successfully.";
}

can someone please help me fix this error?

[gufmn]

Have you tried echoing the query to see if it's an obvious error? Should also be able to see if your vars are getting set properly.

[trickytiger]

i'll try an echo now and tell you what happens

[trickytiger]

ok, I tried an echo, but nothing changed

[trickytiger]

ok, I changed something and now I have this error: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/facta/public_html/cmforum/admin.php on line 33
A fatal MySQL error occured.
Query:
Error: (1064) You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'VALUES ('', 'Test', '', '')' at line 1

here is the new code:

##### CATEGORIES #####
if($action == "categories" && $HTTP_POST_VARS['submit'] == "") {
    cp_categories_header();

$query = mysql_query('SELECT * FROM cmf_categories ORDER BY dorder') or die(mysql_error());
while($categories = mysql_fetch_array($query)) {
    cp_categories_row($category);
}	

cp_categories_footer();

}

if($action == "categories" && $HTTP_POST_VARS['submit'] != "") {
	$query = mysql_query("SELECT * FROM $db_categories");
	while($categories = mysql_fetch_array($query)) {
		$name = "name$categories[cid]";
		$name = "${$name}";
		$dorder = "dorder$categories[cid]";
		$dorder = "${$dorder}";
		$delete = "delete$categories[cid]";
		$delete = "${$delete}";

	if($delete != "") {
		mysql_query("DELETE FROM $db_categories WHERE cid='$delete'") or die(mysql_error());
	}

	mysql_query("UPDATE $db_categories SET name='$name', dorder='$dorder' WHERE cid='$categories[cid]'") or die(mysql_error());
}

if($newname != "") {
	mysql_query("INSERT INTO $db_categories VALUES ('', '$newname', '$newdorder', '')") or die("<b>A fatal MySQL error occured</b>.\n<br />Query: " . $query . "<br />\nError: (" . mysql_errno() . ") " . mysql_error());
}

echo "Categories updated successfully.";
}

[trickytiger]

ok, now I can add categories, but when I go to edit them, the text boxes are blank, and when I go to delete them, it says: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/facta/public_html/cmforum/admin.php on line 33
Categories updated successfully.

but doesn't delete them

[trickytiger]

the error is now gone, I just can't figure out how to show the categories in the admin cp or delete them, can anyone help?

[trickytiger]

i've just managed to fix this problem myself 🙂

[trickytiger]

here is a link to my forum: http://www.fact-connexion.com/cmforum/

feel free to sign up and test it out, or even use it on your own site