Author Topic: code for clean up the shoutbox at once (Read 7204 times)

Devil jimmy · « **on:** March 13, 2011, 04:36:45 PM »

smf 1.1.13 sportal 2.3.3

I need help with a script
I have written a code for to clean up the shoutbox at once
everything works well, but
I have two boxes, a shout for the team and one for everyone
with the code they are both cleaned
I want to clean up the shout with ID 15 and not both
does anyone know how to solve this
Here is the code I made

Code: [Select]

<?php

$forum_version = 'SMF 1.1.13';

// Get everything started up...
define('SMF', 1);
@set_magic_quotes_runtime(0);
error_reporting(E_ALL);
$time_start = microtime();

foreach (array('db_character_set') as $variable)
	if (isset($GLOBALS[$variable]))
		unset($GLOBALS[$variable]);

// Load the settings...
require_once(dirname(__FILE__) . '/Settings.php');
if (empty($db_persist))
	$db_connection = @mysql_connect($db_server, $db_user, $db_passwd);
else
	$db_connection = @mysql_pconnect($db_server, $db_user, $db_passwd);

// Show an error if the connection couldn't be made.
if (!$db_connection || !@mysql_select_db($db_name, $db_connection))
	db_fatal_error();

$sql = "TRUNCATE smf_sp_shouts";
$result = mysql_query($sql);

echo "De shoutbox is met succes opgeruimd, de groeten Jimmy";
?>

I've also created an HTML block with a button that is visible just above the shoutbox

Code: [Select]

<html>
<body>
<p>
</a><a href="http://www.*********.be/cleanshoutbox.php"target="_blank">
<img src="SHOUT_OPRUIMEN.png" alt="Shout Opruimen" width="110" height="16" />
</a></p>
</body>
</html>

everything works perfectly
if someone wants to use it, they only need
change this prefix to their own$ sql = "TRUNCATE smf_sp_shouts"
and the text after the echo because it is Dutch
do this in a php file and call it cleanshoutbox.php place it in the root of your forum

for the block code change the link to the image of the button

this is my first self-written code
If errors or suggestions to improve
let me know

AngelinaBelle · « **Reply #1 on:** March 17, 2011, 05:04:06 PM »

I hope only administrator can see these blocks.
Whenever you are doing SQL, you have to think about the security of your forum.

What you want is a "WHERE" clause -- take a look at the struction of the sp_shouts table to see the fields available.

Devil jimmy · « **Reply #2 on:** March 18, 2011, 04:24:52 PM »

indeed, this block is only visible to admin
thanks for the warning but I thought there

Quote from: AngelinaBelle on March 17, 2011, 05:04:06 PM

What you want is a "WHERE" clause -- take a look at the struction of the sp_shouts table to see the fields available.

glad you chose to view and
thanks for the tip
I will take a closer look
and break my head over it

AngelinaBelle · « **Reply #3 on:** March 25, 2011, 10:28:52 AM »

Already, this button might be very useful to someone. I am going to move it to custom coding, to help people find it.

S@ffz · « **Reply #4 on:** July 03, 2011, 10:53:59 AM »

I have been searching this forum high and low for a mod like this.
Will there ever be anupdate for it so it can run with latest version
SP and SMF?

flybox · « **Reply #5 on:** July 12, 2011, 01:51:07 PM »

I have 2.0 RC5 can someone send me the files required and where to put them?

Deezel · « **Reply #6 on:** July 29, 2011, 04:40:31 PM »

This is a great idea and i KNOW many forum owners who would love to get their hands on it.
Just curious if you sorted it out yet?

Old Fossil · « **Reply #7 on:** July 29, 2011, 07:03:07 PM »

Underdog has added a mod which empties the shoutbox.

Custom Coding is where you can find it ( I hope).

Works like a treat.

Simple Portal Archived Forum

User Info

Who's Online

Shoutbox

Team Blog

Recent Posts

Author Topic: code for clean up the shoutbox at once (Read 7204 times)

Devil jimmy

code for clean up the shoutbox at once

AngelinaBelle

Re: code for clean up the shoutbox at once

Devil jimmy

Re: code for clean up the shoutbox at once

AngelinaBelle

Re: code for clean up the shoutbox at once

S@ffz

Re: code for clean up the shoutbox at once

flybox

Re: code for clean up the shoutbox at once

Deezel

Re: code for clean up the shoutbox at once

Old Fossil

Re: code for clean up the shoutbox at once