Sorting Tables In Pinup Popper V2

[@guyh3403]

I switched to active sql lists a while back and never looked back. Thanks for all your efforts in creating all these video's sir.

[@scampana4864]

Great stuff! Thanks for sharing! In this update the SQL contains emuid=1...This means it is only sorting your tables for emuid1, not all emulators if you want a globally alphabetised list. You can determine you emuid by launching PinupMenuSetup and select the Popper Setup Tab, then click you Emulators button. EMUID # is in the top right corner. If you want a global list across all emulators then remove "emuid=1 and" entirely from the script above and all tables across all emulators will be sorted. ( select * from games where GameName like "a%" and visible=1) Hope that helps!

[@richardm2065]

That's a big help! Just setting this up myself.....pretty cool stuff! I have a question if someone has a moment to help me out. Looking to filter a few emulators out of the SQL. I'm not familiar with SQL....tried playing with some commands and didn't get no where. Namely, I want to filter out FX3 Games from the SQL pull alphabetically (Which is emuid=3 for me). Any advice on the command to enter and try out would be greatly appreciated! I used a "cheat sheet" and played with commands but, couldn't figure out the magical language to use.

[@soundscape2k]

Thanks for this. If anyone wants to create an alphabetical playlist that includes games from all emulators you can use the following example: select * from games where GameDisplay like "a%" and visible=1 order by GameDisplay asc

[@Eric196910]

Wow, thank you so much for your explanation. Is was pulling my hair out of what to change, cause I did not get the tables in alphabetical order when I selected a letter. With your explanation it does work. Thanks

[@richardm2065]

Hey @Soundscape2k Any advice on a SQL command to eliminate a playlist from this? Like FX3 for example. I have a few emulators I'd like to not include like Jukebox, and FX3 in the playlist pull. Any advice is super appreciated.....I'm not familiar with SQL.

[@MajorFrenchy]

Me neither i am sorry. Maybe ask in VPC Discord. In the popper section, someone will know.

[@richardm2065]

@@MajorFrenchy Thanks for the reply. I'll give that a go!

[@oaksho]

You explain these gems so well MF I really enjoy watching your vids. I must confess though I have not made any alterations to my cab for a year or so now. Thanks for keeping us up to date with the latest news and advise. All the best Tony

[@marcoshepner6349]

Once again: thanks for sharing your knowledge !!!

[@jamos5710]

Only thing I would add to that query is order by asc example: select * from games where emuid=1 and GameName like "a%" and visible=1 order by GameName asc

[@kuneytercero]

thank you very much, really a great help

[@jamos5710]

also found out you should really use GameDisplay instead of GameName as that is what is displayed on your wheel (called screen name in editor). game Names can vary wildly based on the author (ie a acdc table was named dc) example: select * from games where emuid=1 and GameDisplay like "a%" and visible=1 order by GameDisplay asc

[@jeremygrieff]

Nice job, thanks Major!

[@MajorFrenchy]

Discrace to the hobby

[@LeosLounge24]

This is awesome! I was looking for something like this for quite sometime and am so glad for this tutorial. I did have one question regarding the SQL for numbers, I did use the script you used (select * from games where emuid=1 and GameName like "a%" and visible=1), but for tables that have a numerical value (007 Goldeneye) what do you place in exchange for the letter 'A' ? Thanks again for this! **edit will do just a separate playlist for numbers since there aren’t that many 👍🏼

[@richardabkstorm9009]

Thank you for this!! 👍🙏

[@scorpio6819]

Hello , Great video as always 👍

[@jamesingram7151]

Very handy, will add this to my to do thanks

[@michel-ftb]

Great and thanks for this auto and work fine, for the table star with a number what have to write for all table in one wheel ? Thanks for help

[@benfrawley415]

I was just thinking, surely when you do this, it essentially changes some config file in Pinup Popper.? I would like to see a menu that seraches by Brand, Year, Name, etc. I wondered if the file with all the changes could then be shared. Personally I think Pinup Popper should have these search options by default. BTW, thanks for all your videos, they are such a great help.

[@MajorFrenchy]

Feel free to suggest your changes to Nailbusters. He is always looking to improve his software. He hangs out on the Discord and he has a Friday Tech talk on Twitch every week

[@wryker]

Question - I put this under the Virtual Pinball playlist but the A-Z icon appears about 5 icons from the one that appears when selecting Virtual Pinball (goes to the first table 007). I'd like to have the A-Z in the top wheel but I want to choose what games it pulls from. Meaning - if I put the A-Z at the top w/the other playlists - will it pull from VP, FP, Zac etc or, I prefer, is there a way to have it only pull from the tables under the Virtual Pinball playlist?

[@Tech-Freak]

thx so much

[@Eric196910]

I have set this up with all the letters from a to z, but when I add a new table, let's say 'Centaur'. Then the table is set at the letter C. So far all is ok, but the table is at the end of C. After let's say the 'Countdown' table. How can I get the table in the letter C and also sort it well? I hope you understand my question. I can not figure it out the good way. Please help

[@dprice06468]

As always, great work Major! One quick question, tho. I've searched mameinabox.com for these alphabet wheel images, but see can't find them. Can you direct us to your alphabet wheel images? Keep up the great work!

[@MajorFrenchy]

There is a link in the description.

[@scampana4864]

Could you make a wheel for 0-9? To cover the tables like 300 which have numbers? Thank you!!

[@Zorrow174]

try something like: select * from games where emuid=1 and visible=1 and GameDisplay < "A"

[@scampana4864]

@@Zorrow174 thx David I’ll try that SQL tomorrow. That will help. I was asking Major Frenchy for a wheel to match the others for 0-9.

[@scampana4864]

@@Zorrow174 I tried this and it works if I change GameDispkay to GameName! I just modified the emuid piece to search across my entire games database. I basically look at all games except for a certain emuid which is jukebox.Now I'm going to try to create a wheel which will match the others!

[@MajorFrenchy]

Yeah sorry man the wheel theme I used did not have numbers.

[@scampana4864]

@@MajorFrenchy thx I’ll try to make one based on what you shared. Btw checkout the update to my comment back to Dave...The number sql works for me just had to modify what he sent slightly

[@richardshelton5471]

So the sql query is picking all games that are in the VPX emulator. Is there a way to select only those games which are part of another playlist such as VPX? I have many games of the same type but only 1 will be in my playlist so I only want to see that 1 game and not the replicas.

[@MajorFrenchy]

i am not sure Richard, you can ask the question in our discord, Nailbuster is there and will know the answer.

[@MRNBricks]

That guide on vpinball has gone away, bummer. Was it posted elsewhere? Also, any idea of the code to sort by release decade if it’s in the game title? Thanks.

[@brentslane1]

Quick question... how do I include my FP tables as well? I know that's emuid 4, how do I write the code to include emuid 1 and 4?

[@sandysavard8030]

Is there a way to also have the usual wheels that are included when selecting a table like the record / Dmd / playfield / etc. Not sure how to get this done so that after selection , those options are available like in the Normal Table selection Menu. 👍

[@MajorFrenchy]

I am sorry i don't understand your question

[@EliasBarberoCano]

Pin up popper and managing media files...wow nothing you can enjoy the most.. next update a dwarf will come out of the screen and will kick your balls tough and hard during record with ffmpeg or draggin your media and you have 20 files plus your media file..enjoy it!!

[@studlygoorite5955]

This works great, thanks!!