Profile Enhancements - vBulletin Self Delete - Allow users to self-delete their profile

What is vBulletin-Self Delete:

This addon allows your users to self delete their profile in your forum. While the process for this goes on, you can use additional settings like cool down time, conformation code, move to another usergroup instead of 'hard deleting' and much more.

The users are (depends on your settings) getting deleted right away or while a hourly cronjob is running in the background.

Installation:

Upload all files you can find in the 'upload' folder to your server and import the product file in admincp. Then you check the usergroup permissions and the settings under admincp -> 'Settings' -> 'Options' -> 'User Profile: Self Delete'

If you habe TMS installed in your forum, you are down with the installation. If you dont use TMS, then you have to change the 'navbar' template manually. For manual changed open the template 'navbar' and search for:

PHP Code:

<vb:if condition="$show['notices'] AND THIS_SCRIPT != 'register'"> 


About that code, enter this code:

PHP Code:

<vb:if condition="$show['selfdeleteinfo']">
    <form action="vbselfdelete" method="post" id="notices" class="notices">
        <ol>
            <li class="restore" id="navbar_notice_1">
                {vb:rawphrase vbselfdelete_remember_to_stop_deletion, {vb:raw show.selfdeleteremain}}
            </li>
        </ol>
    </form>
</vb:if> 


That's it.

General:

This addon has been coded with best knowledge but there still might be bugs. You use this addon at your own risk.

Copyright, Branding and Sponsor:

It is NOT allowed to remove or change the copyright, branding or the sponsor of this addon in any ways. If you would like to get a branding free version of this addon, then you can buy it by writing a personal message to me here at vbulletin.org.

Please notice the sponsor of this addon:

Opel-Problemforum.de - Opel Tipps und Tricks

[KevinL]

Originally Posted by Vossi

Yes, I don't see another usefull way of doing it otherwise.

I'm not sure I understand. It would be more useful to move them manually or to have them automatically moved back to their usergroup they were in before asking to be deleted? I would think to have them moved automatically would be more useful no?

Thank you for the reply!

[MrD]

Hi,

Originally Posted by Vossi

Yes, I don't see another usefull way of doing it otherwise.

at the VBouncer Addon, there are an Option that Users where moved Back in the Usergroups if there have the Mailadress verified.

Maybe this is an Idea for Future Versions

[Elixar]

Just a random question: Is there a way to have them delete their profile, but hide it from the public and still have it visible to Staff?

[AllenBAN]

when will this work for V 4.2.2 cos id like to use it

[MrD]

This Addon Works fine with 4.2.x

[Hostboard]

Throws a DB error with 4.2.5
I know were talking an older modification but does anyone have it working or a quick fix?


Database error in vBulletin 4.2.5:
Invalid SQL:
CREATE TABLE vbselfdelete_user (
id int(11) NOT NULL auto_increment,
username varchar(255) NOT NULL default '',
userid int(11) unsigned NOT NULL default '0',
dateline int(10) unsigned NOT NULL default '0',
status smallint(1) unsigned NOT NULL default '0',
deltime int(10) unsigned NOT NULL default '0',
delcode varchar(255) default NULL,
cooldown smallint(1) unsigned NOT NULL default '0',
reason text,
PRIMARY KEY (id)
) TYPE=MyISAM;
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 12
Error Number : 1064
Request Date : Thursday, June 29th 2017 @ 02:02:40 PM
Error Date : Thursday, June 29th 2017 @ 02:02:45 PM
Script : http://www.MyDomain.com/forums/ACP/p...=productimport
Referrer : http://www.MyDomain.com/forums/ACP/p...?do=productadd
IP Address : xxx.xxx.xxx.xxx
Username : UserID
Classname : vB_Database_MySQLi
MySQL Version : 10.1.10-MariaDB
Server : xxx.xxx.7.194
User Agent :

[z3r0]

Originally Posted by Hostboard

Throws a DB error with 4.2.5
I know were talking an older modification but does anyone have it working or a quick fix?


Database error in vBulletin 4.2.5:
Invalid SQL:
CREATE TABLE vbselfdelete_user (
id int(11) NOT NULL auto_increment,
username varchar(255) NOT NULL default '',
userid int(11) unsigned NOT NULL default '0',
dateline int(10) unsigned NOT NULL default '0',
status smallint(1) unsigned NOT NULL default '0',
deltime int(10) unsigned NOT NULL default '0',
delcode varchar(255) default NULL,
cooldown smallint(1) unsigned NOT NULL default '0',
reason text,
PRIMARY KEY (id)
) TYPE=MyISAM;
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 12
Error Number : 1064
Request Date : Thursday, June 29th 2017 @ 02:02:40 PM
Error Date : Thursday, June 29th 2017 @ 02:02:45 PM
Script : http://www.MyDomain.com/forums/ACP/p...=productimport
Referrer : http://www.MyDomain.com/forums/ACP/p...?do=productadd
IP Address : xxx.xxx.xxx.xxx
Username : UserID
Classname : vB_Database_MySQLi
MySQL Version : 10.1.10-MariaDB
Server : xxx.xxx.7.194
User Agent :

Try this - https://vborg.vbsupport.ru/showpost....0&postcount=20

[Paul M]

TYPE is old MySQL (MariaDB) syntax, no longer supported, change it to ENGINE.

[Hostboard]

Thank you, that did the trick