View Single Post
  #14 (permalink)  
Old 03-20-2008, 06:01 PM
tbones tbones is offline
Constant Pligger
 
Join Date: Apr 2007
Posts: 1,071
Thanks: 53
Thanked 25 Times in 23 Posts
Quote:
Originally Posted by NewsHeatDotCom View Post
PHP Code:
//New Code to Truly Kill the User
$db->query('DELETE FROM `' table_votes '` WHERE `vote_user_id` = "'.$_GET["id"].'"');
$db->query('DELETE FROM `' table_saved_links '` WHERE `saved_user_id` = "'.$_GET["id"].'"');
$db->query('DELETE FROM `' table_trackbacks '` WHERE `trackback_user_id` = "'.$_GET["id"].'"');
$db->query('DELETE FROM `' table_friends '` WHERE `friend_id` = "'.$_GET["id"].'"');
$db->query('DELETE FROM `' table_messages '` WHERE `sender` = "'.$_GET["id"].'"');
$db->query('DELETE FROM `' table_messages '` WHERE `receiver` = "'.$_GET["id"].'"');
$db->query('DELETE FROM `' table_pageviews '` WHERE `pv_user_id` = "'.$_GET["id"].'"');
$db->query('DELETE FROM `' table_comments '` WHERE `comment_user_id` = "'.$_GET["id"].'"');
$db->query('DELETE FROM `' table_links '` WHERE `link_author` = "'.$_GET["id"].'"');
$db->query('DELETE FROM `' table_users '` WHERE `user_id` = "'.$_GET["id"].'"'); 
I guess no one ever thought about this relations :) By the way: Does trackback work at your installation?

Furthermore, I would prefer to see the pageview information at the summary pages next to age, author and so on. By this, all relevant information would be in one spot. Do you see any change to realize it, at least IF this story has been visited?
Reply With Quote