TTCOMMUNITY V1.3 :) SEO friendly forums, notification improvements and more!!...

**spiderwebs** · 10.01.13, 09:54

glad you doing great with your script

**arnage** · 10.01.13, 14:51

Nice.

Who is blane7?

Just a little tip. Maybe you could add time for shoutbox to delete shouts it self,
add time in table:

PHP Code:


CREATE TABLE IF NOT EXISTS `shout` (

  `id` mediumint(9) NOT NULL AUTO_INCREMENT,

  `user` text NOT NULL,

  `message` text NOT NULL,

  `time` int(10) NOT NULL,

  PRIMARY KEY (`id`)

) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

... and check it for some period of time, for me its 24h:

PHP Code:


$past24time = time() - (24 * 60 * 60);

$query = mysql_query('SELECT * FROM `shout` WHERE `time` < '.$past24time.'');

    if (mysql_num_rows($query))

        @mysql_query('DELETE FROM `shout` WHERE `time` < '.$past24time.'');

And close mysql connection somewhere, maybe in the bottom of foot.php is the quickest.

**kevk3v** · 10.01.13, 16:10

Thanks mate, every shout has its own id from 1 to whatever, so they can check if the shouts are more than a number and delete the last one like this...

I totally forgot that btw... but i will add it in the next release

PHP Code:


<?php



$sql = mysql_query("SELECT * FROM shout");



///below will check if there are more than 15 shouts, and delete the last 1...

///15 shouts = 5 pages, 3 per page....



if(mysql_num_rows($sql)>15)

{



$query = mysql_query("SELECT * FROM shout ORDER BY id ASC LIMIT 1");

$id = mysql_fetch_assoc($query);



$last_id = $id["id"]; ///the very last shout



mysql_query("DELETE FROM shout WHERE id='$last_id'");



////done =] just add in shoutbox.php after include("inc/head.php");



}

?>

btw, i'm using a persistent connection ;)

Who is blane7?

and that i dont know lol

**arnage** · 10.01.13, 18:26

Np mate, you are welcome, i'm sure that your head is full with stuff about the script, its hard to think on everything.

Anyway this is how i wrote shoutbox for my guest book service script so maybe you or someone get some idea. I think that names of vars and functions are pretty much intuitive, but if someone don't understand something just ask. I've just change a few table names... ;)

This is listing.

PHP Code:


            // Some code before...

            if ($bookc['showshout'] > 0) {

                echo '<div class="center">'.PHP_EOL;



                $past24time = realtime() - (24 * 60 * 60);

                $query = mysql_query('SELECT * FROM `table_shoutbox` WHERE `row_time` < '.$past24time.' AND `gb` = '.$id.'');

                if (mysql_num_rows($query))

                    @mysql_query('DELETE FROM `table_shoutbox` WHERE `row_time` < '.$past24time.' AND `gb` = '.$id.'');



                $showshouts = 3;

                $shoutquery = mysql_query('SELECT * FROM `table_shoutbox` WHERE `gb` = '.$id.' ORDER BY `table_shoutbox`.`row_time` DESC LIMIT '.$showshouts.'');

                if (mysql_num_rows($shoutquery)) {

                    while ($shoutdata = mysql_fetch_array($shoutquery)) {

                        $shoutid = realint($shoutdata['sbid']);

                        $shouttime = realint($shoutdata['time']);

                        $shoutname = $shoutdata['name'];

                        $shoutmessage = $shoutdata['message'];

                        if ($bookc['smilesin'] == 1) {

                            $shoutmessage = smilies($shoutmessage);

                        }

                        echo formattime('H:i,s', $shouttime, $booktz).' <b>'.$shoutname.'</b>: '.$shoutmessage.'';

                        if ($bookadmin || is_admin() || is_mod()) {

                            echo ' <a href="./gb.php?a=admin&amp;shoutDel&amp;shouted='.$shoutid.'&amp;id='.$id.'">[del]</a>'.PHP_EOL;

                        }

                        echo '<hr style="border: 1px outset #595955;">';

                    }

                } else {

                    echo 'No messages<br/>';

                }

                echo PHP_EOL.'<a href="./gb.php?a=addshout&amp;id='.$id.'" class="buttom">Shout</a>'.PHP_EOL;

                echo '|<a href="./gb.php?a=shouthistory&amp;id='.$id.'">History</a>';

                echo '</div>'.PHP_EOL;

            }

            // And the rest of page...

And these are add pages and listing history.

PHP Code:


            /* Add shout and list history pages */

 elseif ($a == 'addshout') {

            if (isset($_POST['shoutbox']) && $_POST['shoutbox'] == 'Shout') {

                $name = isset($_POST['shoutboxname']) ? cutstr(convert($_POST['shoutboxname']), 30) : '';

                $message = isset($_POST['shoutboxmessage']) ? ((mb_strlen($_POST['shoutboxmessage'], 'UTF-8') < 200)

                ? convert($_POST['shoutboxmessage']) : cutstr(convert($_POST['shoutboxmessage']), 200)."...")

                : '';

                $message = nonl($message);



                $shoutboxerror = false;

                if ($name == '' || $message == '') {

                    $shoutboxerror = '<b>Please enter your nick and message!</b><br/>';

                }

                $shoutflood = realtime() - 60;

                $floodquery = mysql_query('SELECT `row_time` FROM `table_shoutbox` WHERE '

                                        .'`gb` = '.$id.' AND `ip` = "'.get_user_ip().'" AND `browser` = "'.get_user_agent().'" AND `row_time` > '.$shoutflood.'');

                if (mysql_num_rows($floodquery)) {

                    $result = mysql_fetch_assoc($floodquery);

                    $flood = realtime() - $result['time'];

                    $shoutboxerror = '<b>You will be able to write again in '.formattime('s', $flood).' seconds.</b><br/>';

                }

                if (empty($shoutboxerror)) {



                    sleep(1);



                    @mysql_query('INSERT INTO `table_shoutbox` VALUES '

                    .'(\'\', \'\', '.$id.', "'.$name.'", "'.$message.'", "'.get_user_ip().'", "'.get_user_agent().'", "'.realtime().'")');

                    $insertid = mysql_insert_id();

                    @mysql_query("UPDATE `table_shoutbox` SET `sbid` = ".$insertid." WHERE `id` = ".$insertid."");



                    location('./gb.php?id='.$id.'');



                } else {



                    sleep(1);



                    bookhead('Error');

                    echo '<div class="center">'.$shoutboxerror.'</div>'.PHP_EOL;

                        unset($shoutboxerror);

                    echo '<div class="center">'.PHP_EOL;

                    echo '<form method="post" action="./gb.php?a=addshout&amp;id='.$id.'" enctype="multipart/form-data">'.PHP_EOL;

                    echo '<div>'.PHP_EOL;

                    echo '<b>Nick:</b> <br/> <input type="text" name="shoutboxname" size="15" maxlength="30" value=""/><br/>'.PHP_EOL;

                    echo '<b>Message:</b> <br/> <input type="text" name="shoutboxmessage" size="30" maxlength="200" value=""/><br/>'.PHP_EOL;

                    echo '<input type="submit" name="shoutbox" value="Shout"/>'.PHP_EOL;

                    echo '</div>'.PHP_EOL;

                    echo '</form>'.PHP_EOL;

                    echo '</div>';

                    bookfoot();



                }

            } else {



                bookhead('ShoutBox');

                echo '<div class="center">'.PHP_EOL;

                echo '<form method="post" action="./gb.php?a=addshout&amp;id='.$id.'" enctype="multipart/form-data">'.PHP_EOL;

                echo '<div>'.PHP_EOL;

                echo '<b>Nick:</b> <br/> <input type="text" name="shoutboxname" size="15" maxlength="30" value=""/><br/>'.PHP_EOL;

                echo '<b>Message:</b> <br/> <input type="text" name="shoutboxmessage" size="30" maxlength="200" value=""/><br/>'.PHP_EOL;

                echo '<input type="submit" name="shoutbox" value="Shout"/>'.PHP_EOL;

                echo '</div>'.PHP_EOL;

                echo '</form>'.PHP_EOL;

                echo '</div>';

                bookfoot();



            }

        } elseif ($a == 'shouthistory') {

            $bookcs = mysql_fetch_array(mysql_query('SELECT * FROM `table_book_conf` WHERE `gb` = '.$id.''));

            $shoutsonpage = realint($bookcs['mesonpage']);



            $count = mysql_query('SELECT COUNT(*) FROM `table_shoutbox` WHERE `gb` = '.$id.'');

            $counter = realint(mysql_result($count, 0));

            $all = ceil($counter / $shoutsonpage);

            $page = isset($_GET['page']) ? realint($_GET['page']) : 1;

            $cshout = $page * $shoutsonpage - $shoutsonpage;

            if ($page > $all) $page = $all;

            $start = $page == 1 ? 0 : ($page - 1) * $shoutsonpage;



            bookhead('ShoutBox History');

            echo '<div class="center">'.PHP_EOL;

            if (isset($bookadmin)) {

                echo '<a href="./index.php?a=panel&amp;gbEdit&amp;id='.$id.'">Go to <b>'.$bookcs['title'].'</b> settings</a><br/>'.PHP_EOL;

                echo 'Shouts are automaticly deleted after 24 hours when its posted.<br/>'.PHP_EOL;

            }

            echo '<a href="'.gokey('./going.php?', $bookcs['urlsite']).'"><span class="si_y">'.$bookcs['sitename'].'</span></a> | '.$bookcs['title'].''.PHP_EOL;

            echo '</div>'.PHP_EOL;



            $shouthistory = mysql_query('SELECT * FROM `table_shoutbox` WHERE `gb` = '.$id.' ORDER BY `table_shoutbox`.`row_time` DESC LIMIT '.$start.', '.$shoutsonpage.'');

            if (mysql_num_rows($shouthistory)) {

                $i = 0;

                while ($shoutdata = mysql_fetch_array($shouthistory)) {

                    $shoutid = realint($shoutdata['sbid']);

                    $shouttime = realint($shoutdata['time']);

                    $shoutname = $shoutdata['name'];

                    $shoutmessage = $shoutdata['message'];

                    if ($bookcs['smilesin'] == 1) {

                        $shoutmessage = smilies($shoutmessage);

                    }

                    $cshout++;

                    $div = ($i % 2 == 0) ? 'maintitle' : 'ttitle';

                    $i++;

                    echo '<div class="'.$div.'">'.PHP_EOL;

                    echo '#'.$cshout.'. '.formattime('H:i,s', $shouttime, $booktz).' <b>'.$shoutname.'</b>: '.$shoutmessage.'';

                    if ($bookadmin || is_admin() || is_mod()) {

                        echo ' <a href="./gb.php?a=admin&amp;shoutDel&amp;shouted='.$shoutid.'&amp;id='.$id.'">[del]</a>'.PHP_EOL;

                    }

                    echo '<br/>';

                    echo '</div>'.PHP_EOL;

                }

                if ($counter > $shoutsonpage) {

                    navigation('./gb.php?a=shouthistory&amp;id='.$id.'&amp;', $page, $all);

                }

            } else {

                echo 'No messages<br/>';

            }

            echo '<div class="center"><a href="./gb.php?a=default&amp;id='.$id.'">'.$bookcs['title'].'</a></div>';

            bookfoot();



        }

?>

Of course, any suggestions are welcome.

**kevk3v** · 10.01.13, 18:40

Thanks

i definitely got an idea, flood related lol...

**arnage** · 10.01.13, 18:54

Welcome. Cool.

**hi_jakkk** · 12.01.13, 17:12

very nice sir

**kevk3v** · 12.01.13, 18:16

Originally posted by hi_jakkk View Post

very nice sir

thank yew

**kevk3v** · 16.01.13, 15:36

Nice!, thanks will do!

**~~Lynjun02~~** · 19.01.13, 00:01

I cant InstalL it bitch

**kevk3v** · 19.01.13, 03:44

Hmmm well, that's good.
It should stay that way...

**softwarefreak** · 20.01.13, 03:38

Originally posted by Lynjun02 View Post

I cant InstalL it bitch

Sir, pls watch your words.

Look we are so gentle & polite, not even abusing u back asshole lol

**kevk3v** · 20.01.13, 05:25

I guess this was for what i told barbara on facebook, what goes around comes around lol

**francis11** · 21.01.13, 14:57

How to fix this error?? Kindly help me..

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, admin@localhost and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log

TTCOMMUNITY V1.3 :) SEO friendly forums, notification improvements and more!!...

TTCOMMUNITY V1.3 :) SEO friendly forums, notification improvements and more!!...

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment