Convert vS-Interactive Profiles Comments to Visitor Messages

[zappsan]

Description

This will convert all comments made using the vS-Interactive Profiles to visitor messages.

How to use

Simply upload the convertcomments.php file to your forums' root folder and run it in your browser. Afterwards just delete the file.
NOTE: After you've run the file, don't refresh the page, otherwise you'll get duplicate entries.

Beta?

I've tested this multiple times and it always worked fine for me, so I hope you won't encounter any problems either.
I've still decided to put this in beta stage for a while so I can really be sure everything is working fine.

Use this at your own risk.

[zappsan]

Reserved.

[Zaiaku]

First one to see this one. Finally someone has stepped up to the plate!

[NoDRaC]

can you explain steps?
Firs upgrade 3.70
Then run convert.php
then delete vs-interactive file?

[NoDRaC]

i use it
its working perfect

[teenhut]

Too late :(. I already removed it. lol

[zappsan]

To everyone who has used this: Please post here and tell me if everything has been working correctly.

To the person who rated this with one star: I have no problem with bad ratings but only giving this thread bad rating and not posting a reason is not really gonna help me. If there is problem with my modification or a thing which needs improvement, please let me not so I can take care of it.

can you explain steps?
Firs upgrade 3.70
Then run convert.php
then delete vs-interactive file?
Seems like you figured it out already :)
Yeah, the vS Interactive Profiles shouldn't be uninstalled until the converter has been run, because you need the table of the profile comments and uninstalling will remove it.

i use it
its working perfect
Thanks, please click install :)

Too late :(. I already removed it. lol
Well, if you've got some bold backup from the time you used the vS Profiles, you could try restoring the 'profilecomment' table. My converter shouldn't overwrite the comments you already have made (I still suggest backing them up just to be sure).

[D|ver]

thank you so much for the converter, i hope i'll be able to test it out soon :)

[Thug]

can you make another mod like this but for friends.

[elmati]

everything works fine! :)
thanks m8!

can you make another mod like this but for friends.
i will appreciate that too! :)

[Endurer]

Thanks buddy, I really needed something to convert the profile comments. Much appreciated.

[Adrian Schneider]

Usernames are not escaped in the query, so you can fix this by replacing line 32 with: $postusername=$db->escape_string($comment['username']);

[zappsan]

Usernames are not escaped in the query, so you can fix this by replacing line 32 with: $postusername=$db->escape_string($comment['username']);
Thanks for the tip! I'll add this ASAP.