vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Add-On Releases - Post Edit History (PEH) (https://vborg.vbsupport.ru/showthread.php?t=132708)

Surviver 11-27-2006 10:00 PM

Post Edit History (PEH)
 
Edithistory (1.5.0 B 3)

What does this Modification?
This Modification saves a version of a post if someone edits it. If there are saved edits for a post, you can view the "Post History" and you are able to restore old posts.
Also you can compare saved versions of a post.

Installation
Installation-Instructions are included in the zip-File

What's new in Version 1.5.0 B 2?

In this version i made a lot of improvement: eg. I've overwritten the code, the Ajax Compare function now works properly (Screen #3) and I implented a function to mass restore posts of a user. (Screen #6)

Screenshots

#1
Attachment 71292

#2
Attachment 71293

#3 (Compare saved version)
Attachment 71294

#4 (Usergroup Permissions)
Attachment 71295

#5
Attachment 71296

#6 (Mass Restore posts of a user)
Attachment 71297

Not translated yet
- Admin Help

[HR]ss[/HR]
I only get a blank page after the update, waht can I do?

See the new FAQ
[HR]ss[/HR]

Regards
Surviver

PS: I'm very sorry about my bad english ;)

PPS:If you use it, please klick install!

Masiello 11-28-2006 04:11 PM

Thanks, wow my first post!

Stoebi 11-28-2006 04:25 PM

Thx a lot :)

Nice work!

iran.gs 11-28-2006 04:41 PM

Nice, Installed

.Tim 11-28-2006 11:11 PM

Very nice! I made a slight change to the phrase and position. I think it looks better there (for those using the legacy postbit). If anyone else wants to do it I just added the text after:

Code:

<if condition="$show['postcount']">#<a href="showpost.php?$session[sessionurl]p=$post[postid]&amp;postcount=$post[postcount]" target="new" rel="nofollow" id="postcount$post[postid]" name="$post[postcount]"><strong>$post[postcount]</strong></a></if>

COBRAws 11-29-2006 12:18 AM

What's the difference with this one by Lieva?
https://vborg.vbsupport.ru/showthread.php?t=105989

Viper007Bond 11-29-2006 02:07 AM

Quote:

Originally Posted by COBRAws (Post 1127714)
What's the difference with this one by Lieva?
https://vborg.vbsupport.ru/showthread.php?t=105989

That one is for vB 3.5.x and doesn't work properly with vB 3.6.x. ;)

Viper007Bond 11-29-2006 02:32 AM

Installed on my test install and works great!

I did change the "edit_history_edit_bit" template though:

Code:

<tr>
        <td class="tcat" width="45%" colspan="3">$vbphrase[new]</td>
        <td class="tcat" width="45%" colspan="3">$vbphrase[old]</td>
</tr>

to...

Code:

<tr>
        <td class="tcat" width="10%" colspan="2">&nbsp;</td>
        <td class="tcat" width="45%" colspan="2">$vbphrase[new]</td>
        <td class="tcat" width="45%" colspan="2">$vbphrase[old]</td>
</tr>

Makes the headers line up a lot better. :)

I also changed the "&" in the URL to "&amp;" to make it validate. ;)

Viper007Bond 11-29-2006 03:01 AM

Hmm, seems you're missing a "TABLE_PREFIX" somewhere:

Code:

Database error in vBulletin 3.6.4:

Invalid SQL:
        SELECT edithistory.*, user.*, edithistory.dateline as editdate FROM
                                                vb_edithistory as edithistory
                                                LEFT JOIN user as user ON(user.userid = edithistory.edituserid)
                                                WHERE edithistory.postid = 361324
                                                ORDER BY editid DESC;

MySQL Error  : Table 'finalgear_vb.user' doesn't exist
Error Number : 1146
Date        : Wednesday, November 29th 2006 @ 05:00:39 AM
Script      : http://forums.finalgear.com/edithistory.php?do=viewedithistory&postid=361324
Referrer    :
IP Address  : [removed]
Username    : Viper007Bond
Classname    : vb_database


Surviver 11-29-2006 03:48 AM

Quote:

Originally Posted by .Tim (Post 1127656)
Very nice! I made a slight change to the phrase and position. I think it looks better there (for those using the legacy postbit). If anyone else wants to do it I just added the text after:

Code:

<if condition="$show['postcount']">#<a href="showpost.php?$session[sessionurl]p=$post[postid]&amp;postcount=$post[postcount]" target="new" rel="nofollow" id="postcount$post[postid]" name="$post[postcount]"><strong>$post[postcount]</strong></a></if>

Thank you for this, looks cool :)

Quote:

Originally Posted by COBRAws (Post 1127714)
What's the difference with this one by Lieva?
https://vborg.vbsupport.ru/showthread.php?t=105989

This Hack is for 3.6.x :P

Quote:

Originally Posted by Viper007Bond (Post 1127775)
That one is for vB 3.5.x and doesn't work properly with vB 3.6.x. ;)

Quote:

Originally Posted by Viper007Bond (Post 1127790)
Installed on my test install and works great!

I did change the "edit_history_edit_bit" template though:

Code:

<tr>
        <td class="tcat" width="45%" colspan="3">$vbphrase[new]</td>
        <td class="tcat" width="45%" colspan="3">$vbphrase[old]</td>
</tr>

to...

Code:

<tr>
        <td class="tcat" width="10%" colspan="2">&nbsp;</td>
        <td class="tcat" width="45%" colspan="2">$vbphrase[new]</td>
        <td class="tcat" width="45%" colspan="2">$vbphrase[old]</td>
</tr>

Makes the headers line up a lot better. :)

I also changed the "&" in the URL to "&amp;" to make it validate. ;)

Ok, cachged in the New Version :)

Quote:

Originally Posted by Viper007Bond (Post 1127812)
Hmm, seems you're missing a "TABLE_PREFIX" somewhere:

Code:

Database error in vBulletin 3.6.4:

Invalid SQL:
        SELECT edithistory.*, user.*, edithistory.dateline as editdate FROM
                                                vb_edithistory as edithistory
                                                LEFT JOIN user as user ON(user.userid = edithistory.edituserid)
                                                WHERE edithistory.postid = 361324
                                                ORDER BY editid DESC;

MySQL Error  : Table 'finalgear_vb.user' doesn't exist
Error Number : 1146
Date        : Wednesday, November 29th 2006 @ 05:00:39 AM
Script      : http://forums.finalgear.com/edithistory.php?do=viewedithistory&postid=361324
Referrer    :
IP Address  : [removed]
Username    : Viper007Bond
Classname    : vb_database


Thank you for reporting that, fixed in Version 1.1.6


Greetings Surviver



*updated*

Viper007Bond 11-29-2006 04:13 AM

Quote:

Originally Posted by Surviver (Post 1127822)
Thank you for reporting that, fixed in Version 1.1.6

Not fixed. I dunno if it failed to install correctly or what (I run a good sized forum and it mighta timed out while altering a table? *shrugs*).

Code:

Database error in vBulletin 3.6.4:

Invalid SQL:
        SELECT edithistory.*, user.*, edithistory.dateline as editdate FROM
                                                vb_edithistory as edithistory
                                                LEFT JOIN user as user ON(user.userid = edithistory.edituserid)
                                                WHERE edithistory.postid = 361324
                                                ORDER BY editid DESC;

MySQL Error  : Table 'finalgear_vb.user' doesn't exist
Error Number : 1146
Date        : Wednesday, November 29th 2006 @ 06:12:09 AM
Script      : http://forums.finalgear.com/edithistory.php?do=viewedithistory&postid=361324
Referrer    : http://forums.finalgear.com/showthread.php?t=15110
IP Address  : [removed]
Username    : Viper007Bond
Classname    : vb_database


COBRAws 11-29-2006 04:46 AM

Quote:

Originally Posted by Surviver (Post 1127822)
This Hack is for 3.6.x :P[/B]

I think you should say its a port of X hack ;)

Surviver 11-29-2006 10:33 AM

Quote:

Originally Posted by COBRAws (Post 1127843)
I think you should say its a port of X hack ;)

No, it isn't ;)

Surviver 11-29-2006 10:37 AM

Quote:

Originally Posted by Viper007Bond (Post 1127829)
Not fixed. I dunno if it failed to install correctly or what (I run a good sized forum and it mighta timed out while altering a table? *shrugs*).



Code:

Database error in vBulletin 3.6.4:

Invalid SQL:
        SELECT edithistory.*, user.*, edithistory.dateline as editdate FROM
                                                vb_edithistory as edithistory
                                                LEFT JOIN user as user ON(user.userid = edithistory.edituserid)
                                                WHERE edithistory.postid = 361324
                                                ORDER BY editid DESC;

MySQL Error  : Table 'finalgear_vb.user' doesn't exist
Error Number : 1146
Date        : Wednesday, November 29th 2006 @ 06:12:09 AM
Script      : http://forums.finalgear.com/edithistory.php?do=viewedithistory&postid=361324
Referrer    : http://forums.finalgear.com/showthread.php?t=15110
IP Address  : [removed]
Username    : Viper007Bond
Classname    : vb_database


Ok, noew its really fixed, i attached the wrng file :alien:

captainslater 11-29-2006 11:13 AM

Thx Surviver, installed :)

Viper007Bond 11-29-2006 05:32 PM

Quote:

Originally Posted by Surviver (Post 1127996)
Ok, noew its really fixed, i attached the wrng file :alien:

Yay, works great now! :D

I made the cron daily though as it's not super important that excess post histories be removed for me ASAP. :)

KidCharlemane 12-01-2006 01:23 AM

How long are old posts saved? Im assuming this is configurable? I dont see any documentation with the hack so I'm asking here.

Viper007Bond 12-01-2006 03:16 AM

Quote:

Originally Posted by KidCharlemane (Post 1129116)
How long are old posts saved?

As long as the original posts exists. Why would you want it another way?

KidCharlemane 12-01-2006 04:03 AM

Well, because it seems like it would add a lot of database bloat on large forums.

Viper007Bond 12-01-2006 09:14 AM

Quote:

Originally Posted by KidCharlemane (Post 1129195)
Well, because it seems like it would add a lot of database bloat on large forums.

It's a separate database table and it doesn't add any extra queries when viewing posts. Where's the bloat in that? I mean sure, it adds extra filesize to the database, but are you that pressed for space?

beduino 12-01-2006 10:37 AM

Hello Surviver!
Really the hack is awesome :D
And the video !!!!!!!!!!!!!!!!!!! :) I love it! Final is funny too ;)
All the best
Beduino

Surviver 12-01-2006 11:31 AM

Quote:

Originally Posted by Viper007Bond (Post 1129172)
As long as the original posts exists. Why would you want it another way?

Quote:

Originally Posted by KidCharlemane (Post 1129195)
Well, because it seems like it would add a lot of database bloat on large forums.

Quote:

Originally Posted by Viper007Bond (Post 1129292)
It's a separate database table and it doesn't add any extra queries when viewing posts. Where's the bloat in that? I mean sure, it adds extra filesize to the database, but are you that pressed for space?

You can activate/deactivate ist per Usergroup and Forum ;)

You can ever run the Cron, maybe once a wekk or once a day ;)

Greetings SUrviver

Surviver 12-01-2006 08:27 PM

Update !

Code:

v 1.1.6
        [F] Fixed table Prefix Bug
        [+] Some Templatecachnges

v 1.1.7
        [+] New Option: BBCode Type
        [+] Edithistory Results will now be paginated

v 1.1.8
        [+] Added Advanced WOL support
        [+] Edits can now be deleted
        [+] New Usergrouppermissions

v 1.1.9
        [+] Some hooks added


Protonus 12-01-2006 09:32 PM

Thank you SO much !! This is awesome!

ninjamaster 12-01-2006 10:35 PM

thanks nice work

dfe 12-02-2006 07:12 PM

Who all can see the edit histories? Can you set it so that admin/moderators are the only users who can see the edits and history?

Surviver 12-02-2006 08:20 PM

Quote:

Originally Posted by dfe (Post 1130220)
Who all can see the edit histories? Can you set it so that admin/moderators are the only users who can see the edits and history?

You must activate it in the forums you want.

The Permissions you can set up in the Usergroup manager, there are some Settings aviable:

Code:

Can view own Edithistory
Yes No
Can view all Edithistory       
Yes No
Can restore own Edithistorys       
Yes No
Can restore all Edithistorys       
Yes No
Log Edits done by this Group ?       
Yes No
Can delete own edits ?       
Yes No
Can delete all edits ?       
Yes No


DannyMilner 12-02-2006 09:07 PM

Great idea, I will be installing...

Nathan2006 12-03-2006 01:16 AM

Thank you Surviver,

This is really good this version :D

Install

Just 1 small problem, How do I make the text full on the edit history (Screeshot added)

Thank you :)

Surviver 12-03-2006 04:27 AM

Quote:

Originally Posted by Nathan2006 (Post 1130423)
Thank you Surviver,

This is really good this version :D

Install

Just 1 small problem, How do I make the text full on the edit history (Screeshot added)

Thank you :)

Mmmh, ist does work for me ...

Has you installed a hack like bbcode permissions ?

Greetings Surviver

Nathan2006 12-03-2006 04:32 AM

Quote:

Originally Posted by Surviver (Post 1130508)
Mmmh, ist does work for me ...

Has you installed a hack like bbcode permissions ?

Greetings Surviver

Hi,

Yes I have Advanced BBCode Permissions installed :(

I just disabled it and it worked great.

Is there anyway to overcome this problem without removing the other hack?

Thank you for you're reply :)

Surviver 12-03-2006 07:10 AM

Quote:

Originally Posted by Nathan2006 (Post 1130510)
Hi,

Yes I have Advanced BBCode Permissions installed :(

I just disabled it and it worked great.

Is there anyway to overcome this problem without removing the other hack?

Thank you for you're reply :)

This Hack makes Prolems, i've written some Hacks with parsing bbcode (guestboo, this and an other), and all didn't work with this Hack.

I dont know hy, but i use the vBulletin Standard to parse bbCode.

It seems that the other Hack has a bu, i've heared about it often ;)

Greetings SUrviver

Viper007Bond 12-03-2006 11:23 PM

Seems there's still SQL issues, this time with your cron. :(

Code:

Invalid SQL:
                                                              DELETE edithistory
                                                              FROM vb_edithistory as edithistory
                                                              LEFT JOIN vb_post as vb_post ON(vb_post.postid = vb_edithistory.postid)
                                                              WHERE vb_post.postid IS NULL;
MySQL Error  : Unknown table 'vb_edithistory' in on clause
Error Number : 1109
Date        : Sunday, December 3rd 2006 @ 12:18:02 PM
Script      : http://forums.finalgear.com/ajax_cron.php?rand=764482
Referrer    : http://forums.finalgear.com/showthre...=13083&page=36
IP Address  : 83.160.166.100
Username    : Unregistered
Classname    : vb_database

ajax_cron.php is an AJAX replacement for the built in image cron, but that shouldn't be affecting this. It's the same thing, it just runs the crons as JS rather than images. ;)

Nathan2006 12-04-2006 12:40 AM

Quote:

Originally Posted by Surviver (Post 1130580)
This Hack makes Prolems, i've written some Hacks with parsing bbcode (guestboo, this and an other), and all didn't work with this Hack.

I dont know hy, but i use the vBulletin Standard to parse bbCode.

It seems that the other Hack has a bu, i've heared about it often ;)

Greetings SUrviver

its not that much of a problem really lol I only have a few members who use different fonts and colors ;)

Thanks for your reply tho :)

COBRAws 12-04-2006 12:49 AM

Quote:

Originally Posted by Surviver (Post 1127991)
No, it isn't ;)

Oh, ok sorry.

So whats the difference with the 3.5 Post Edit History Viewer hack? Because I'll update soon and dont know if I need to switch or stay.

Thanks!

Surviver 12-04-2006 12:08 PM

Quote:

Originally Posted by Viper007Bond (Post 1131277)
Seems there's still SQL issues, this time with your cron. :(

Code:

Invalid SQL:
                                                              DELETE edithistory
                                                              FROM vb_edithistory as edithistory
                                                              LEFT JOIN vb_post as vb_post ON(vb_post.postid = vb_edithistory.postid)
                                                              WHERE vb_post.postid IS NULL;
MySQL Error  : Unknown table 'vb_edithistory' in on clause
Error Number : 1109
Date        : Sunday, December 3rd 2006 @ 12:18:02 PM
Script      : http://forums.finalgear.com/ajax_cron.php?rand=764482
Referrer    : http://forums.finalgear.com/showthre...=13083&page=36
IP Address  : 83.160.166.100
Username    : Unregistered
Classname    : vb_database

ajax_cron.php is an AJAX replacement for the built in image cron, but that shouldn't be affecting this. It's the same thing, it just runs the crons as JS rather than images. ;)

Yes, this is a konow bug, it will be fixed in Version 1.2.0 ;)

Quote:

Originally Posted by COBRAws (Post 1131307)
Oh, ok sorry.

So whats the difference with the 3.5 Post Edit History Viewer hack? Because I'll update soon and dont know if I need to switch or stay.

Thanks!

I don't know the other Hack very good, but with this Hack you have Usergroupsettings, Forumsettings, You can restore Posts and some more ;)


-----

Greetings Surviver

Surviver 12-09-2006 02:11 PM

New Version in the first Post !!

Viper007Bond 12-09-2006 02:31 PM

Cool!

Surviver 12-09-2006 02:59 PM

Quote:

Originally Posted by Viper007Bond (Post 1135161)
Cool!

I hope all will work fine now :)

Viper007Bond 12-09-2006 03:26 PM

Sadly, it doesn't. :(

Code:

Database error in vBulletin 3.6.4:
Invalid SQL:
INSERT INTO vb_edithistory
      (postid, oldtitle, newtitle, oldtxt, newtxt, newreason, oldreason, dateline, edituserid, editusername)
VALUES
      ((366862, '', '', '[post contents removed]', '', '', 1165684492, 13306, '[username removed]');
MySQL Error  : Unknown column 'newreason' in 'field list'
Error Number : 1054
Date        : Saturday, December 9th 2006 @ 05:14:52 PM
Script      : http://forums.finalgear.com/editpost...&postid=366862
Referrer    :
IP Address  : [removed]
Username    : [removed]
Classname    : vb_database

Did you make sure to add in upgrade code that'd ALTER the table?


All times are GMT. The time now is 07:53 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01668 seconds
  • Memory Usage 1,876KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (15)bbcode_code_printable
  • (25)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete