Question Query Question

[Optimus]

Hello. I ran abe thanks modification on my board as a likes system (changed the phrases). Is it possible to store the thanks from that mod as Likes in your mod? Or when they are imported are they only listed as thanks? If not, is there a query where I can move the "thanks" stored in advanced post thanks/like into the "Likes" table?

 

[Fillip H.]

The first thing you're going to want to do is access phpMyAdmin and write down the value of the highest entryid column in the dbtech_thanks_entry table.

Alternatively, you could run this query:

SELECT MAX(entryid) FROM dbtech_thanks_entry

Then, once you've imported all the Thanks from Abe's mod, run the following query:

UPDATE dbtech_thanks_entry SET varname = 'likes' WHERE varname = 'thanks' AND entryid > X

where X is the number you found in the previous step.

 

[Optimus]

Thanks for the reply. The highest value was 61990. I ran the query and it didn't work unfortunately. A few days ago I began to manually change the varnames of each thanks to say likes, I only did about 200, but could that be the reason why the query didn't work? Do all the entries have to be in the thanks varname before I can transfer them to likes? Or do you think I need to disable the modification before running the query?

 

[Optimus]

Never mind, I figured it out. I just had to put a "<" where ">" is. Thanks for the assistance!

 

[Fillip H.]

I was under the impression you had not attempted to run the importer previously and that you had an existing database of only new entries