Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
Post Edit History Importer Details »»
Post Edit History Importer
Mod Version: 1.0.1, by Gray Matter (Contributor) Gray Matter is offline
Developer Last Online: Sep 2009 I like it Show Printable Version Email this Page

vB Version: 3.7.0 Rating: (5 votes - 4.40 average) Installs: 15
Released: 24 Dec 2007 Last Update: 03 May 2008 Downloads: 113
Not Supported DB Changes Additional Files Translations  

What is this?

The Post Edit History Importer (PEHI) is just that; an importer script. For those of us who were using Surviver's Post Edit History (PEH) hack, we are now pleased to see this functionality included in the default vBulletin package with the introduction of 3.7.0.

However, the hack's and vBulletin's way of logging post edit histories are somewhat different. So, thus, the need for this importer script arose. In a nutshell, it will import your past edit histories into vBulletin's new system.

What, exactly, does it do?

This script is a seamless import of the edit histories from the PEH hack into vB's system.

There are several key differences between vB's system and the hack's, among which are:
  • vB stores iconid edits, the hack didn't
  • The hack stored edits by comparing them in each record, while vB instead stores the original post once and subsequently all edits in a separate record
This importer will correct any mishaps between the two systems; it will assign postedithistoryids in the exact same order as they would have been if vB had inserted them, it will store original posts in the same way that vB does, it will assign iconids to make up for the missing ones that the hack never logged, and many other things.

If you're truly interested in checking out everything this importer does to make it "vB standard," you can read the code. I've commented enough that it should be discernible.

Anticipated FAQ
Q: Can I use this importer if I already have edit histories in vB's new system?
A: Yes! This importer was designed to import everything seamlessly. After it is done organizing the old histories correctly, it will process new histories before clearing them altogether in order to rearrange them correctly. So, yes, you can.

Q: Which version(s) of the PEH hack is this importer intended for?
A: The importer has only be tested with PEH version 1.2.5. Since I haven't used the new beta version, I do not know the database structure and therefore this importer might not work on that version.

Q: How long does the importer take to do everything?
A: Not very long at all, I promise. But really, it depends on how many histories you have. Personally, I had 21,075 histories from the hack. After inserting the originals (14,033 of them), I ended up with 35,108 records total. How long did it take the importer to do all of that? 2 minutes.

(More to come later if need be...)

Using the importer
To use the importer, just download the .zip file attached, unzip it, and open the 'readme' file. Instructions are included there.

Afterward
After you've used the importer, feel free to post your stats here! I'd love to hear how it worked out for you.

Enjoy!

Download Now

Only licensed members can download files, Click Here for more information.

Screenshots

Click image for larger version

Name:	pehi_1.jpg
Views:	309
Size:	52.7 KB
ID:	73702Click image for larger version

Name:	pehi_2.jpg
Views:	248
Size:	77.8 KB
ID:	73703Click image for larger version

Name:	pehi_3.jpg
Views:	152
Size:	53.1 KB
ID:	73704Click image for larger version

Name:	pehi_4.jpg
Views:	127
Size:	50.0 KB
ID:	73705Click image for larger version

Name:	pehi_5.jpg
Views:	148
Size:	62.4 KB
ID:	73706Click image for larger version

Name:	pehi_6.jpg
Views:	326
Size:	94.9 KB
ID:	73707

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • If you like this modification support the author by donating.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Similar Mod
Mod Developer Type Replies Last Post
Post Edit History (PEH) Surviver vBulletin 3.6 Add-ons 199 25 Jul 2011 19:29

Comments
  #2  
Old 24 Dec 2007, 12:41
Surviver's Avatar
Surviver Surviver is offline
 
Join Date: Feb 2006
Real name: Julian
Nice, Thank you very much. But I don't like the new post history, becaus the edit is only saved if you entere a edit reason.
__________________
vBPoint
Reply With Quote
  #3  
Old 24 Dec 2007, 19:47
Gray Matter Gray Matter is offline
 
Join Date: May 2005
Originally Posted by Surviver View Post
Nice, Thank you very much. But I don't like the new post history, becaus the edit is only saved if you entere a edit reason.
As far as I can tell, you don't have to enter a reason. But it will only save the edit if the "Last edited by" message is shown.

(which yes, I dislike as well )
Reply With Quote
  #4  
Old 24 Dec 2007, 22:58
hocphp hocphp is offline
 
Join Date: Nov 2007
i installed . working hard. thank for upgrade
__________________
Vinarank
php community
Reply With Quote
  #5  
Old 25 Dec 2007, 05:06
Gray Matter Gray Matter is offline
 
Join Date: May 2005
Originally Posted by Mike-D View Post
Does not work what results in getting DB Errors!
I can't really help if you don't post the database error.
Reply With Quote
  #6  
Old 23 Mar 2008, 00:19
FlyBoy73 FlyBoy73 is offline
 
Join Date: Feb 2002
How do you feel this hack will load the system if you have several million posts? Is it very intensive to search this out?

Thanks,
David
Reply With Quote
  #7  
Old 24 Mar 2008, 20:05
Gray Matter Gray Matter is offline
 
Join Date: May 2005
Originally Posted by FlyBoy73 View Post
How do you feel this hack will load the system if you have several million posts? Is it very intensive to search this out?

Thanks,
David
My forum had about 35,000 stored edits when I ran the importer and everything went smoothly.

However, I would suggest you run the importer on a copy of your database, not your live website, first, just to be sure.
Reply With Quote
  #8  
Old 01 May 2008, 03:12
tuwebfacil tuwebfacil is offline
 
Join Date: Jan 2005
I runned the script perfectly, I choose to remove the tables, but once I tried to uninstall the old product from the product page on admincp, I got this error:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Reply With Quote
  #9  
Old 02 May 2008, 21:38
Gray Matter Gray Matter is offline
 
Join Date: May 2005
Ack. I didn't realize that the tables are removed by the uninstall script. Did it uninstall the product okay for you? This isn't going to cause a major problem, I just want to make sure you can uninstall it correctly.

However, I will remove the tables option from the script and just add a message to uninstall the product.
Reply With Quote
  #10  
Old 03 May 2008, 01:54
tuwebfacil tuwebfacil is offline
 
Join Date: Jan 2005
Originally Posted by Gray Matter View Post
Ack. I didn't realize that the tables are removed by the uninstall script. Did it uninstall the product okay for you? This isn't going to cause a major problem, I just want to make sure you can uninstall it correctly.

However, I will remove the tables option from the script and just add a message to uninstall the product.
No bro, I couldn't uninstall the product right.
Any way you can help me out?
Reply With Quote
  #11  
Old 03 May 2008, 15:09
Gray Matter Gray Matter is offline
 
Join Date: May 2005
I think the easiest way to get rid of it for you is to just create a table named "edithistory" and that way the uninstall script won't fail when you try to install it.

To do this, enter your ACP, click on "Execute SQL Query" under 'Maintenance' and enter this in the "Manual Query" field, and then click 'Continue' on the next page:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


Then, go and try to uninstall the product again.
Reply With Quote
  #12  
Old 03 May 2008, 15:19
Gray Matter Gray Matter is offline
 
Join Date: May 2005
The importer has now been updated to only clear the old table and remove its records, rather than remove it entirely. This way, the uninstall script will not fail when someone tries to remove the product.

This importer is also now supported.
Reply With Quote
  #13  
Old 03 May 2008, 23:32
tuwebfacil tuwebfacil is offline
 
Join Date: Jan 2005
Originally Posted by Gray Matter View Post
I think the easiest way to get rid of it for you is to just create a table named "edithistory" and that way the uninstall script won't fail when you try to install it.

To do this, enter your ACP, click on "Execute SQL Query" under 'Maintenance' and enter this in the "Manual Query" field, and then click 'Continue' on the next page:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


Then, go and try to uninstall the product again.
thanks for the support!!

The product has been removed!

thanks again!
Reply With Quote
  #14  
Old 05 May 2008, 16:56
dutchbb dutchbb is offline
 
Join Date: Dec 2003
Omg if I only knew this, just deleted the entire database of PEH because vbulletin introduced it's own
Reply With Quote
  #15  
Old 06 May 2008, 02:43
Gray Matter Gray Matter is offline
 
Join Date: May 2005
Originally Posted by dutchbb View Post
Omg if I only knew this, just deleted the entire database of PEH because vbulletin introduced it's own
I'm sorry to hear that. You don't have a backup or anything you could use? It's a shame to lose all those histories.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
Forum Jump


New To Site? Need Help?

All times are GMT. The time now is 11:46.

Layout Options | Width: Wide Color: