Deleting Pennames???

[rleeq]

I have recently been discovered by the writers from India. This is no problem in and of itself. The problem is they don't seem to understand that the same guidelines apply to pen names as apply to author names. Is there some way to remove all of these improper pen names at one time or do I have to go through the drudgery of searching the database and deleting them one at a time?

[GardenSimply]

R'Lee,

When dealing with names (as opposed to keywords) it is far more difficult to root this out. Some of the Indians on my sites use their full name (pen or otherwise) but some don't. I usually just go into the database and browse. I go to the end of the list first and just start either changing (according to their profile) if I have the time... if not, they simply get deleted. You can delete up to fifty at a time this way if needs be.

[joebrochin]

Hi, If I catch it when they sign up I go in and delete the penname only. I also decline articles submitted under that penname.
I stopped sweating accepting articles orginating from India, in fact I am trying to prevent them altogether. I waste a lot of time on articles from authors who write their articles like the below:

-- my article is deleted in your site why is happend every time

[marvinko]

Here's something that may help in this matter.

Below is a little code that we use to weed out phoney pennames or the ones that do not follow our guidelines. Basically, it brings up the last 100 pennames that have been added to your directory. Included is the removal link for the penname plus the removal link for the account (if you so wish).

This file should be in your admin folder, and you should be logged into your admin panel when you use it.

The code is as follows:

Code: Select all

<?php
// Make a MySQL Connection
include("../setup.php");

$link = mysql_connect($dbhost, $dbuser, $dbpasswd)
  or die ("Could not connect to MySQL");

mysql_select_db ($dbname)
  or die ("Could not select database $dbname");

$result = mysql_query("SELECT * FROM prefix_penname ORDER BY pen_id DESC LIMIT 100")
or die(mysql_error()); 

$penname = $row['pen_name'];
$userid = $row['user_id'];
$penid = $row['pen_id'];

echo "<table border='1'>";
echo "<tr> <th>Pen Name</th> <th>User ID</th> <th>Delete Penname</th>  <th>Delete Account</th> </tr>";
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
   // Print out the contents of each row into a table
   echo "<tr><td>";
   echo $row['pen_name'];
   echo "</td><td>";
   echo $row['user_id'];
   echo "</td><td>";
   echo "<a target=\"_blank\" href=\"http://www.yoursite.com/admin/userprofile.php?act=delpenname&id=";
   echo $row['pen_id'];
   echo "&userid=";
   echo $row['user_id'];   
   echo "\">Delete ";
                     echo $row['pen_name'];
                     echo " </a>";
   echo "</td><td>";
   echo "<a target=\"_blank\" href=\"http://www.yoursite.com/admin/listauthors.php?act=remove&id=";
   echo $row['user_id'];   
   echo "\">Delete ";
   echo $row['user_id'];   
                     echo " </a>";
   echo "</td></tr>";
}

echo "</table>";
?>


To use the code .... replace the areas of "yoursite" with your own domain name url.

Also if you use a different "prefix_" for your penname table ... that'll have to be changed also.

It's nothing flashy here, but a nice little tool to use daily or so, to weed out phonies.

Hope that helps.

[GardenSimply]

From within AD, if you delete the penname, it deletes all articles associated with this penname. I've been doing a lot like Joe, deleting the penname along with all the articles.

THEN, I 'unregister' the account so they cannot submit more articles, and if they do register again, they have to use a different email address. It's not fool proof, but it helps.

Marvin, THANKS for that little script. This save a BUNCH of time. And if anyone wants to know, when you delete the penname using this script, it does in fact delete all articles associated with it. HooRah!

Thank you Marvin!

[rleeq]

The last in this series. Yesterday Marvinko and I finally got the script running correctly. It took a little time because I set up my database little different that it should be set up.
Well no matter for that. I want to thank Marvinko for all his help getting things set up. It's a pleasure to work with knowledgeable people.

Thanks Marvinko

R'

[vijay]

However, you can practically make your account ineffective by deleting all of the stories and blanking your profile... you could change your penname but unfortunately... all of your reviews and forum posts would still be there...

It shouldn't matter too much if you have a dormant account lying around... because the history is quite hard to trace of one's old account...

____________________________________________________________________________
buy wow accounts | wow account