Restore deleted member/profile

[1759]

How do you restore a forum member who has deleted his profile?

The member has re-registered with the same name- how do you re-associate the name with the old posts which are in the same name?

[Aether]

Unless you have a backup of the database, you can't get his old profile back, but it sounds like you only want to reassociate his old posts with his new profile...

If you haven't got any other guest posts, you can just put in a php code that says:

Code Select Expand

<?php
include_once("Settings.php");

   $conn=mysql_connect($db_server,$db_user,$db_pass);
   if(!$conn) {
      die ("Could not connect to MySQL");
   }
   mysql_select_db($db_name,$conn) or die ("Could not open the requested database");

$user_get_query=mysql_query("SELECT ID_MEMBER FROM ".$db_prefix."members WHERE membername='INSERT USERNAME HERE'");
$user_get=mysql_fetch_assoc($user_get_query);

mysql_query("UPDATE ".$db_prefix."messages SET ID_MEMBER='".addslashes($user_get['ID_MEMBER'])."' WHERE ID_MEMBER='-1'");
?>


Copy that into NotePad, replace where it says INSERT USERNAME HERE with the members user name, save it as a ".php" file and upload it into your main yabbse folder (where Settings.php is). Run it, then delete it.

If you DO have other guest posts, it's more complicated... :S
If you have access to phpMyAdmin, use that to edit the posts he made, and just set all the ID_MEMBER to his ID_MEMBER of his posts. You have to do that in the messages table, and you can find out his ID_MEMBER by looking in members...

If you can't use either of these ways, it's more complicated and I don't know how best to help you...

Good Luck!

[David]

Change this to use the membername column and then guests don't matter.

WHERE ID_MEMBER='-1'

[1759]

Thanks folks!

[charlottezweb]

I'm trying to utilize this script to restore an account that was just deleted.

That script is returning:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user: 'xxxx_xxxx@localhost' (Using password: NO) in /home/xxxx/public_html/yabbse/restoreuser.php on line 4
Could not connect to MySQL

Can I enter the connection settings directly instead of using the php variables for them?  I don't understand why it's not connecting otherwise...would my admin pword have to mirror the db pword?

Thanks!
Jason

[[Unknown]]

Try putting the script in the YaBB SE directory.

All passwords should be the MySQL/database passwords.

-[Unknown]

[charlottezweb]

It's in the yabbse root already...

Jason

[charlottezweb]

Any other suggestions from anyone?  

Jason

[Ben_S]

try chaning the include to the full path to your settings.php or ./Settings.php

[charlottezweb]

I just tried the entire path and your second suggestion with no luck...I'm wondering if it has something to do with the "using password:no" part...??

Jason

[Douglas]

I came across that myself.

If it's reading the DB variables in the mod file, the DB variables need to be globalized in the call to connect to the database.

[charlottezweb]

I came across that myself.

If it's reading the DB variables in the mod file, the DB variables need to be globalized in the call to connect to the database.

Wow, I know there's some important info there, alas you're over my head

I'm not following you on the mod file variables, or the globalizing of the db variables part    

Since this isn't a safe file to keep accessible anyway, isn't there some syntax I could use in the mysql connect part to just type in the username passwords myself rather than using the yabb-defined variables?  Maybe that would be a more simple approach?

Or even better, would the middle part of the script run as a query in phpmyAdmin as it is?

Thanks!
Jason

[Douglas]

Okay, do this then

<?php
include_once("Settings.php");
global $db_server, $db_user, $db_pass, $db_name, $db_prefix;

  $conn=mysql_connect($db_server,$db_user,$db_pass);
  if(!$conn) {
     die ("Could not connect to MySQL");
  }
  mysql_select_db($db_name,$conn) or die ("Could not open the requested database");

$user_get_query=mysql_query("SELECT ID_MEMBER FROM ".$db_prefix."members WHERE membername='INSERT USERNAME HERE'");
$user_get=mysql_fetch_assoc($user_get_query);

mysql_query("UPDATE ".$db_prefix."messages SET ID_MEMBER='".addslashes($user_get['ID_MEMBER'])."' WHERE ID_MEMBER='-1'");
?>

Follow the directions in the original post, just add the global line in.  It should work then.  

[charlottezweb]

I see what you're saying.  It didn't work, but I see what you're saying

Jason

[Douglas]

Jason, what error messages are you getting?  I'd love to see this work for you, so I'll help you out as much as I can.