MOD REQUEST/QUESTION: Simple forum based off the review code?

It is funny you posted this topic, I've been thinking of a "blueprint" of how to do this. I haven't coded anything though -- I'm still working out the logistics.

From looking at the tutorial -- you want to link up "author" with fanfiction_authors.uid.

You need to attach the forum to the eFiction templates to make it "look" like eFic (ignore the styling in the tutorial) and this way, you  can also take advantage of isMEMBER and isADMIN and USERUID etc to add in your forum.

e.g.  (this is not all of them, just examples)

author column becomes an int value:

  author int NOT NULL default '',

$getthreads hooks up to fanfiction_authors

$getthreads="SELECT *, a.penname from forumtutorial_posts LEFT JOIN fanfiction_authors as a ON a.uid = author WHERE parentid='0' ORDER BY lastrepliedto DESC";

...

  $getthreads3[penname]=strip_tags($getthreads3[penname]);

...

<td><a href=""$url/viewuser.php?uid=$getthreads3[author"]" title="$getthreads3[penname]">$getthreads3[penname]</a></td>

post.php and reply.php: I'm going to assume you're only allowing members to post. So you can scrap the $_POST['name'] business and adding it as a field. What you need to do is, instead, use USERUID and isMEMBER to insert the member's UID number into the "author" column.

And... hopefully that should be voila.

Let me know if you have any issues.

Thanks, that was basically my idea. It seemed simple enough. And yes, I only want members posting, we've had spam issues when we left even the reviews open. I suspect this will take a lot of tweeking, but it seems doable. My one thought with the review code would be the ability to delete posts, because after having tried this out it didn't seem I had any admin abilities. So if I can piece together that tutorial with some of the review code, maybe I can make it where Admins can delete posts.

Thanks for the advice, I'm going to try this out tonight, and I'd love to see whatever developments you have with yours. I'm not a fan of bridging because when it comes to upgrading you get stuck once again with having to update two scripts, one of which shares a user list with the other and things get messy. I feel like this would make more sense, I can upgrade and the tables will be all efic tables getting fixed while my forum tables remain the same.

For deleting posts, you can just have something like this:

<?php

$delete = (isset($_GET["delete"]) && is_numeric($_GET["delete"] ? abs($_GET["delete"]) : null);

if ($delete) { // if there is a record ID
 if (check_admin()) { // made up function -- check if the person deleting CAN delete
  $get = dbquery("SELECT postid FROM forum WHERE postid = '$delete'"); // check to see if the post exists
  if (dbnumrows($get) > 0) { // record found
   $del = dbquery("DELETE FROM forum WHERE postid = '$delete'"); 
   if ($del)
    print "<p>Post successfully deleted.</p>";
  }
  else { // no record found
   print "<p>No record found.</p>";
  }
 }
}

else { // id not numeric
 print "<p>No record found.</p>";
}
?>

Written from top of head; obviously you'll have to modify and integrate it somewhere that uses eFic coding. Say it's attached to an admin.php, it'll "work" on admin.php?delete=2 or something. Yesss.

I was wondering if you ever got this idea to work??? 

I tried it out, but so far no luck getting it to be anything close to a smooth intergration. The forum is minimal and getting it to be something that an admin can moderate is probably beyond what I'm capable of. I may have another look at it soon. If and when I get it running I'll post it as a mod, but I'll be the first to admit this forum script is so basic it might not even be entirely worth it.

@sullenriot, hey, I just e-mailed you.

Hey Elle,

I received your email and responded. Thanks a million!

Hey, can post a step by step how to do it? It would be very useful, and
Mod can officially add

Thanks:).
Tomas.