Thread Rating:
  • 12 Vote(s) - 4.33 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[For 1.8] Thank You/Like System v3.3.2 + MyAlerts support
You have to look to the added templates:
Quote:Templates Added:
Your THEME >thankyoulike
  • Template containing The block with the list of users who have Thanked/Liked a post for the default view.

[i]Your THEME >thankyoulike_classic[/i]
  • Template containing The block with the list of users who have Thanked/Liked a post for the classic view.

[i]Your THEME >thankyoulike_expcollapse[/i]
  • Template For the Expand/Collapse image which Expands/Collapses the block of Thank Yous/Likes

[i]Your THEME >thankyoulike_button_add[/i]
  • Template for the button to add Thank You/Like. If you do not want to use an image, change it to text here.

[i]Your THEME >thankyoulike_button_del[/i]
  • Template for the button to delete Thank You/Like. If you do not want to use an image, change it to text here.

[i]Your THEME >thankyoulike_users[/i]
  • Template for the list of users who have Thanked/Liked a post

[i]Your THEME >thankyoulike_postbit[/i]
  • Template for the block of Thanks Given/Thanks Received in the postbit

[i]Your THEME >thankyoulike_memprofile[/i]Template for the section added to user's profile which shows the number of Thank Yous/Likes stats.

If there is no code, take a look to the added templates in the mybb default theme and copy the corresponding code to your own theme template. It's all from my memory, so I'm not 100% sure.

Hello community,
 
first, many thanks for this great plugin Smile
 
We has just updated from 1.805 to 1.812, unfortunalety we lost all our database entries (nearly all, except _ggt_tables - these are reduced by half). The table columns tyl_unumtyls, tyl_unumrcvtyls and tyl_unumptyls in table mybb_users now shows 0 for each user.

Latest database backup from 1.805 with tyl release #15 (think so) exists.

In the german mybb forum, one user wrote that data restoration isn`t possible:
https://www.mybb.de/forum/thread-31367-p...#pid220153

Can`t believe it, that would be not funny...


Another user told about to restore only the _ggt_ tables
https://www.mybb.de/forum/thread-31367-p...#pid220550
 
Hm, can'tbelieve it, too....that would be strange.I think the _ggt_ tables could be any references to the users, but i really don't know.
But my common sense is shure for one thing: The likes will be saved in the user table.

Now, what is the right procedure now, maybe the following would be the right solution?

In phpmyadmin:

At first, choose the data from the backup:

SELECT tyl_unumtyls, tyl_unumrcvtyls, tyl_unumptyls FROM mybb_users


Then export to sql file, i get:

INSERT INTO `mybb_users` (`tyl_unumtyls`, `tyl_unumrcvtyls`, `tyl_unumptyls`) VALUES
(x, y, z),
(0,0,0),
....and so on...
(0, 0, 0);


Now I have to drop the table columns from live database:

ALTER TABLE mybb_users DROP COLUMN tyl_unumtyls, tyl_unumrcvtyls, tyl_unumptyls


Afterwards, execute the dump that was generated to the sql file (INSERT INTO...).

The last step is to export the ggt tables from the backup, delete them in the live database and import the export to live database, similarly as before.
...eventually delete new registered users that have been added after the update of the board to ensure that the number of entries is correct...?

Can it really be so simple?
Or maybe i should rather work with Mysql UPDATE? If so, how is this exactly to do?
Reply


Messages In This Thread
RE: Thank You/Like System v1.9.1 - by OMID_HXC - 04-06-2015, 08:26 PM
RE: Thank You/Like System v1.9.1 - by Eldenroot - 04-06-2015, 08:34 PM
RE: Thank You/Like System v1.9.1 - by expat - 04-07-2015, 05:57 AM
RE: Thank You/Like System v1.9.1 - by Whiteneo - 04-07-2015, 09:03 AM
RE: Thank You/Like System v1.9.1 - by Eldenroot - 04-07-2015, 03:17 PM
RE: Thank You/Like System v1.9.1 - by DrXotick - 04-08-2015, 12:01 PM
RE: Thank You/Like System v1.9.1 - by meetdilip - 04-08-2015, 12:50 PM
RE: Thank You/Like System v1.9.1 - by Sazze - 04-08-2015, 12:50 PM
RE: Thank You/Like System v1.9.1 - by bekircem - 04-08-2015, 01:22 PM
RE: Thank You/Like System v1.9.1 - by Eldenroot - 04-08-2015, 02:33 PM
RE: Thank You/Like System v1.9.1 - by bekircem - 04-08-2015, 03:56 PM
RE: Thank You/Like System v1.9.1 - by DrXotick - 04-08-2015, 06:25 PM
RE: Thank You/Like System v1.9.1 - by Eldenroot - 04-08-2015, 06:28 PM
RE: Thank You/Like System v1.9.1 - by Supryk - 04-08-2015, 07:38 PM
RE: Thank You/Like System v1.9.1 - by Eldenroot - 04-08-2015, 07:40 PM
RE: Thank You/Like System v1.9.1 - by bekircem - 04-08-2015, 09:39 PM
RE: Thank You/Like System v1.9.1 - by Eldenroot - 04-08-2015, 09:42 PM
RE: Thank You/Like System v1.9.1 - by bekircem - 04-08-2015, 09:57 PM
RE: Thank You/Like System v1.9.1 - by Eldenroot - 04-09-2015, 06:54 AM
RE: Thank You/Like System v1.9.1 - by bekircem - 04-09-2015, 11:31 AM
RE: Thank You/Like System v1.9.1 - by Eldenroot - 04-09-2015, 03:17 PM
RE: Thank You/Like System v1.9.1 - by DrXotick - 04-09-2015, 06:54 PM
RE: Thank You/Like System v1.9.1 - by Eldenroot - 04-09-2015, 09:16 PM
RE: Thank You/Like System v1.9.1 - by Whiteneo - 04-10-2015, 06:58 AM
RE: Thank You/Like System v1.9.1 - by Eldenroot - 04-10-2015, 02:10 PM
RE: Thank You/Like System v1.9.1 - by DrXotick - 04-10-2015, 08:52 AM
RE: Thank You/Like System v1.9.1 - by Whiteneo - 04-12-2015, 02:42 AM
RE: Thank You/Like System v1.9.1 - by Eldenroot - 04-12-2015, 09:52 AM
RE: Thank You/Like System v1.9.1 - by ytt - 04-13-2015, 04:10 PM
RE: Thank You/Like System v1.9.1 - by Eldenroot - 04-13-2015, 04:33 PM
RE: Thank You/Like System v1.9.1 - by ytt - 04-13-2015, 04:34 PM
RE: Thank You/Like System v1.9.1 - by Eldenroot - 04-13-2015, 04:37 PM
RE: Thank You/Like System v1.9.1 - by ytt - 04-13-2015, 04:41 PM
RE: Thank You/Like System v1.9.1 - by Gershon - 04-13-2015, 05:14 PM
RE: Thank You/Like System v1.9.1 - by Eldenroot - 04-13-2015, 07:21 PM
RE: Thank You/Like System v1.9.1 - by ytt - 04-13-2015, 07:42 PM
RE: Thank You/Like System v1.9.1 - by Eldenroot - 04-13-2015, 07:44 PM
RE: Thank You/Like System v1.9.1 - by Eldenroot - 04-14-2015, 06:04 AM
RE: Thank You/Like System v1.9.1 - by Gershon - 04-14-2015, 03:49 PM
RE: Thank You/Like System v1.9.1 - by Eldenroot - 04-14-2015, 03:54 PM
RE: Thank You/Like System v1.9.1 - by andrewjs18 - 04-15-2015, 07:01 AM
RE: Thank You/Like System v1.9.1 - by Eldenroot - 04-15-2015, 08:54 AM
RE: Thank You/Like System v1.9.1 - by andrewjs18 - 04-15-2015, 04:49 PM
RE: Thank You/Like System v1.9.1 - by Gershon - 04-15-2015, 04:48 PM
RE: Thank You/Like System v1.9.1 - by Eldenroot - 04-15-2015, 05:22 PM
RE: Thank You/Like System v1.9.1 - by Whiteneo - 04-15-2015, 10:33 PM
RE: Thank You/Like System v1.9.1 - by tzameti13 - 04-16-2015, 05:28 AM
RE: Thank You/Like System v1.9.1 - by Eldenroot - 04-16-2015, 07:16 AM
RE: Thank You/Like System v1.9.1 - by tzameti13 - 04-16-2015, 07:23 AM
RE: Thank You/Like System v1.9.1 - by Eldenroot - 04-16-2015, 07:25 AM
RE: Thank You/Like System v1.9.1 - by tzameti13 - 04-16-2015, 07:43 AM
RE: Thank You/Like System v1.9.1 - by Eldenroot - 04-16-2015, 08:18 AM
RE: Thank You/Like System v1.9.1 - by numygroup - 04-16-2015, 11:30 AM
RE: Thank You/Like System v1.9.1 - by jesuite - 04-17-2015, 03:16 PM
RE: Thank You/Like System v1.9.1 - by Eldenroot - 04-17-2015, 03:45 PM
RE: Thank You/Like System v1.9.1 - by jesuite - 04-17-2015, 05:18 PM
RE: Thank You/Like System v1.9.1 - by Eldenroot - 04-18-2015, 02:12 PM
RE: Thank You/Like System v1.9.1 - by jesuite - 04-18-2015, 03:16 PM
RE: Thank You/Like System v1.9.1 - by Eldenroot - 04-18-2015, 03:21 PM
RE: Thank You/Like System v1.9.1 - by Eldenroot - 04-19-2015, 05:53 PM
RE: Thank You/Like System v1.9.11 + MyAlerts support - by Bradley Varol - 05-20-2016, 07:10 AM
RE: Thank You/Like System v1.9.11 + MyAlerts support - by Bradley Varol - 05-20-2016, 04:57 PM
RE: Thank You/Like System v1.9.11 + MyAlerts support - by Bradley Varol - 05-21-2016, 06:07 PM
RE: Thank You/Like System v2.1.0 + MyAlerts support - by searcher - 10-13-2017, 06:23 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)