Migrate

dylanb

I currently use Peregrine Badges and Reactions on my VanillaBoard (2.1) and I was wondering if there was any way to migrate the data from that to work with YAGA. Is this possible?

peregrine

some of the data like insert date of badge is not trapped with peregrine badges.

alot of the badges could easily be transferred by just setting the requisite badges in YAGA and it would auto fill e.g. number of years on forum, no of comments etc. so, that would be a non-issue (excepts for award dates).

As far as reactions, all reaction are stored in

PeregrineReactions table

             ->Column('UserID',    
            ->Column('InsertUserID',    
            ->Column('CommentID',    
            ->Column('DiscussionID',   

            ->Column('DateInserted',    
            ->Column('ReactionType',   

Probably wouldn't be too difficult (since I wouldn't be involved

• I leave it up to hgtonight to make a Yaga Porter
• since he caused my beloved Peregrine Reactions and Peregrine Badges, to become addons of a bygone dark ages

• by virtue of creating the uber-app YAGA.

• i hold no grudge - since his app is far superior.

• the one advantage I gain from all this I have been released from support of my two antiquities.

the last coffin nail for Peregrine Badges and Reactions, oh the horror!

peregrine

you could try setting up the YAGA to reflect some of the Badges first.

and then disable Peregrine Badges and see where you are at.

then you could work on the reactions aspect.

peregrine

I heard thru the grapevine that a script may soon be available.

On that day please take a few moments of silence when mourning the loss of Peregrine Badges and Reactions, its dog-eat-dog world.

hgtonight

I will write an actual plugin when I get some free time, but here is what you need to do:

1. Make a db backup.

2. Create similar reactions in Yaga by running the following SQL against your db:

   TRUNCATE `GDN_Action`;
   INSERT INTO `GDN_Action` (`ActionID` ,`Name` ,`Description` ,`Tooltip` ,`CssClass` ,`AwardValue` ,`Permission` ,`Sort`)
   VALUES ('1', 'Funny', 'This has made me laugh!', 'This has made me laugh!', 'ReactWink', '1', 'Yaga.Reactions.Add', NULL),
   ('2', 'Wow', 'This is awesome', 'This is awesome', 'ReactStar2', '1', 'Yaga.Reactions.Add', NULL),
   ('3', 'Scholarly', 'This made me think', 'This made me think', 'ReactBrightnessMedium', '1', 'Yaga.Reactions.Add', NULL),
   ('4', 'Artistic', 'This has some great imagery', 'This has some great imagery', 'ReactLeaf', '1', 'Yaga.Reactions.Add', NULL);
   

3. Transfer existing PeregrineReactions to Yaga.Reactions by running the following SQL against your db:

   INSERT INTO `GDN_Reaction` (`InsertUserID`, `ActionID`, `ParentID`, `ParentType`, `ParentAuthorID`, `DateInserted`)
   SELECT pr.`InsertUserID`, pr.`ReactionType`, pr.`DiscussionID`, "discussion", pr.`UserID`, pr.`DateInserted` FROM `GDN_PeregrineReactions` pr WHERE pr.`DiscussionID` IS NOT NULL;
   
   INSERT INTO `GDN_Reaction` (`InsertUserID`, `ActionID`, `ParentID`, `ParentType`, `ParentAuthorID`, `DateInserted`)
   SELECT pr.`InsertUserID`, pr.`ReactionType`, pr.`CommentID`, "comment", pr.`UserID`, pr.`DateInserted` FROM `GDN_PeregrineReactions` pr WHERE pr.`CommentID` IS NOT NULL;
   

4. Take a break!

peregrine

hg scripted a solution:

tears of joy, tears of sadness. I'm so confused. head bowed. 5 seconds of silence.

I bid goodbye to the PB and PR plugins. When vanilla 2.0.x is gone, I will have PeregrineBadges sent off on a viking ship for a plugin funeral pyre. Ticket will be on sale at a later date, if you want to attend.

hg, there was no sobbing reaction, so I gave you an awesome.