[kevinnguyen]

03-15-03 at 12:36 AM LangTuDaTinh said this in Post #702

PHP Code:


//- Add a new table 

CREATE TABLE `quiz_comments` (
  `cid` int(10) NOT NULL auto_increment,
  `quizid` int(10) NOT NULL default '0',
  `userid` int(25) NOT NULL default '0',
  `date` int(11) NOT NULL default '0',
  `comments` text NOT NULL,
  PRIMARY KEY  (`cid`),
  KEY `cid` (`cid`),
  KEY `userid` (`userid`),
  KEY `id` (`quizid`)
) TYPE=MyISAM;

//- find in quiz.php --------------

MORE WITH THIS SCORE

//- add above it-------------------


// ------------------------------------- DELETE COMMENTS START--------------------------------------------
if ($action=="delcomment") 
{
    if ($bbuserinfo['usergroupid']==6)
        {
            $DB_site->query("DELETE FROM quiz_comments
                         WHERE cid = '$cid'");
                           
        }
     eval("standardredirect(\"".gettemplate("quiz_comments_delete")."\",\"quiz.php?s=$session[sessionhash]&quizid=$quizid\");");

}

if ($action=="savecomment")
    {
        $time = time();
         $quiz = $DB_site->query("INSERT INTO quiz_comments (cid, quizid, userid, date , comments) 
                            VALUES (NULL,".intval($quizid).", ".intval($userid).", ".time().", '".addslashes($comments)."')");
        eval("standardredirect(\"".gettemplate("redirect_postthanks")."\",\"quiz.php?s=$session[sessionhash]&quizid=$quizid\");");
    }


// ------------------------------------- DELETE COMMENTS END --------------------------------------------


//- find in quiz.php --------------

    $time = time();
    eval("dooutput(\"".gettemplate("quiz_display")."\");");


//- add above it-------------------


//////////////////////////////////////////////////////////////////////////////////////////////////////////
    $quizcommentr = $DB_site->query("SELECT r.comments, r.date, r.cid,
                                             u.userid, u.username
                                      FROM quiz_comments r, user u
                                      WHERE r.quizid = ".intval($quizid)."
                                        AND r.userid = u.userid
                                      ORDER BY r.cid ASC
                                      ");

        while ($quizcomment = $DB_site->fetch_array($quizcommentr)) 
            {
                $quizcomment[comments] = bbcodeparse(stripslashes($quizcomment[comments]));
                $cid=$quizcomment[cid];
                  $quizcomment[date] = vbdate("$dateformat, $timeformat", $quizcomment[date]);
                  
                if ($bbuserinfo[usergroupid]==6) 
                    {
                        $quizcommentdel ="<smallfont color=\"#008080\">[<a href=\"quiz.php?s=$session[sessionhash]&quizid=$quizid&action=delcomment&cid=$cid\">Delete</a>]</smallfont>";
                    }  
                if($quizcomment[comments]!="")
                    {
                          eval("\$quizdisplaybit .= \"".gettemplate("quiz_comments_displaybit")."\";");
                    }
 
            }
                eval("\$quiz_display = \"".gettemplate("quiz_comments_display")."\";");

           

//////////////////////////////////////////////////////////////////////////////////////////////////////////


ADD NEW TEMPLATES


//------------ADD NEW "quiz_comments_delete 

Comment deleted successfully, you will return to the quiz.



//------------ADD NEW "quiz_comments_display 

  <table width="100%" cellpadding="4" cellspacing="0" border="0" bgcolor="#9999FF">
    <tr bgcolor="#9999FF">
      <td colspan="2" width="100%" valign="middle"><normalfont color="#000000"><b>Quiz Discussion</b></normalfont></td>
    </tr>

    $quizdisplaybit

  </table>

//------------ADD NEW "quiz_comments_displaybit"

  <tr bgcolor="#13486D" >
    <td width="100%" valign="left"><smallfont color="#008080"> Posted by: <a href="member.php?s=$session[sessionhash]&action=getinfo&userid=$quizcomment[userid]"><b>$quizcomment[username]</a></b> on $quizcomment[date] </smallfont></td><td valign="right">$quizcommentdel</td>
  </tr>

  <tr width="90%" bgcolor="#1C5780">

    <td colspan="2" width="100%" valign="left"><normalfont>$quizcomment[comments]</normalfont></td>
  </tr> 


did wat your told but dun see anything! why?