Mini Mods - Quick User Delete In PostBit

My site gets spam bots alot and i'm always too lazy to go into the admincp and find the username and delete it. so i wrote this.

It injects a image into the postbit around the online/infraction images.

Find this in "POSTBIT/postbit legacy" whichever you use.

<if condition="$show['infractionlink']"><a href="infraction.php?$session[sessionurl]do=report&amp;p=$post[postid]" rel="nofollow"><img class="inlineimg" src="$stylevar[imgdir_button]/infraction.gif" alt="<phrase 1="$post[username]">$vbphrase[add_infraction_for_x]</phrase>" border="0" /></a></if>

Add this under that part

<if condition="$bbuserinfo[userid] == YOURUSERID">
<a href="admincp/user.php?do=remove&amp;u=$post[userid]" rel="nofollow"><img class="inlineimg" src="YOURDELETEUSERIMAGEURL" alt="<phrase 1="$post[username]">delete user</phrase>" border="0" /></a>
</if>

Only problem is it doesnt redirect you back to the thread, If anyone would like to tell me how to do that itd be great.

[Dream]

But then there's all user attachments, etc, etc info

[thincom2000]

Well if you don't know which tables have `userid` in them, you'll be running a lot of queries depending on your forum, but you can do this (I recommend testing on a backup database first):

PHP Code:

$db->hide_errors();
$all_tables = $db->query_read("SHOW TABLES");

$getall = $db->fetch_array($all_tables);
$db->free_result($all_tables);

foreach ($getall AS $get_all)
{
    $create_query = "DELETE FROM $get_all WHERE `userid` = " . $vbulletin->GPC['userid'];
    $getro = $db->query_write($create_query);
    echo "Deleted User #" . $getro['userid'] . " from $get_all.<br />";
    $db->free_result($getro);
}
unset($get_all, $getall, $create_query);

$db->show_errors(); 


That should delete every database entry associated with a particular userid. (You will end up with orphaned posts if they started any threads).

You could technically do it in ONE query, but I think the whole query might fail and stop if the `userid` field doesn't exist in one of the tables.

[HMBeaty]

Originally Posted by cerjam

why waste the space in the memberlist for 300 banned spam bots? this is so much cleaner. and if nothing else, someone can learn to make a postbit hack from this

I already did

User Management

[cerjam]

Nice hack redline, my thread and im marking out to you..lol. Nice though.

[Atakan KOC]

Thanks....