Pinup Popper Multiple Game Removal

[jackblotto]

I'm pushing my SSD drive storage limits which may or may not be affecting performance and giving me no space to add new games so I decided to go through my VPX games and see how many I never play and could get rid of vs just buying some bigger drives. I found that by removing a bunch of games (tables files and their associate B2S files) I could get a bunch of space back.  The problem then is removing a lot of tables (like a couple of hundred) from the Pinup Popper DB all at once via the gui can be cumbersome. There are a few short threads on this but nothing that I'm comfortable with using. I came up with an idea that I'm wondering if somebody could tell me if it could work?

 

Go through the gui and simply "tag" the games being removed by putting "DELETE-" or something at the beginning of the game name for every table; like DELETE-2001 or DELETE-Astro.  Then maybe using sql cmds in the DB editor in Popper Setup run "delete from playlistdetails WHERE GameName LIKE "%DELETE-%" and "delete from games WHERE GameName LIKE "%DELETE-%". I'm not a sql or Pinup Popper expert so not sure whether this would work. It would still be a bit cumbersome but vs manually deleting each game, maybe this could be faster if it works?

 

Other ideas?

 

Thanks, D

 

[jackblotto]

I tried this strategy and it worked well I believe. I changed my plan and used the Author field as it was empty and quicker to get to with the mouse. I also used DELETEIT as my input, though it would work with any char string as log as the sql query didn't catch other records you didn't want it to. The sql statement query I used is below. The "%" weren't needed since DELETEIT was the only characters in the field, but just in case there was it would still find my search string. Before doing any work on the Pinup Popper DB, be sure to do a backup first.

 

    delete from games WHERE Author LIKE "%DELETEIT%"

 

It didn't seem I needed to do the following that was recommended elsewhere, seems like once I deleted the game it was cleared from all lists automatically. In fact, I just got an error.

 

    delete from playlistdetails WHERE Author LIKE "%DELETEIT%"

 

I was able to individually add my string to the Author field and delete all the games (about 250 or so) from Pinup Popper in about 45 minutes.  This only affects the Pinup Popper DB, it doesn't remove the game files (which I did to save space) from the SSD drive or the Pinup Popper files specific to the games.

 

Cheers, D