gfycat fix + deep discord integration

fixes up the issue with gfycat creation

the big deal here though is the discord integration.  once you put in your token, you enable discord integration.

whenever you favorite, runner up, organize or splooge an item, your pgv3 client will post a message to a specific #porn-something channel. the bot will see this message, and post a summary to the #porn channel. the splooge feature is especially fun.

a bot on the discord server will track these events and begin building a master porn database. for example, you can query the bot for stats

!top 3 star splooges

will give you the top 3 stars and their splooge counts.

!splooges

will give a message indication the total number of stars and their summed splooges

and this is just the beginning!

when you organize a star, the stars information is posted to discord.  the bot will at some point read this information, and insert it into a server side master porn database.  then, anyone will be able to hit a button in PG, and pull that information down from the discord bot into their PG.

enjoy guys.  this discord thing is going to be really, really cool.

PGV3 v3.19.6169.40132 (crash fix update) + (bot fix update)

https://discord.gg/WS5c5QS

73 thoughts on “gfycat fix + deep discord integration

  1. I have win 8.1 and can’t install PGV3 software. When I click on .exe file nothing happens and don’t get any errors. Only in task manager I can see, that .exe file shows for split second after I run it, but immediately status changes into “suspended” and it disappears. I tried to turn off my antivirus program, make exceptions with windows firewall and defender, but It didn’t helped. I don’t have any problems with another executable files. Windows is up to date.

    Like

  2. The greater than or equals and less than or equals for searching by rating both only work like a regular greater than of less than.

    Like

  3. New version looks incredible, great job! A few quick questions:

    1. Is there any way (or will be) to import an existing database from the old version 1.1.0.0?

    2. Is there (or will be) any way to manually edit the default thumbnail generated for non wmv/avi scenes? (such as dragging a pic onto it, like the old version)

    3. Given that I only use vlc anyway, is there (or will there) a way to either deactivate the autoplay when opening a scene or even replace it with an image/screenshot?

    (I realize of course that the amazing new version is still brand new and this stuff is probably not that simple to do)

    Like

  4. How can i make thumbnails for flv scenes? because internal player doesn’t play them. Also i did the google api thing but it doesn’t seem to do anything.

    Like

    1. the internal player is basically windows media player. unfortunately WMP cannot play FLVs 😦

      the google api thing will automatically search for an image when you add a new tag. it also lets you hit the “G” in the details view for a non-scene item and get some images.

      Like

  5. Your API instructions are horrible. I think the images are out of order even. I have made an API key once before for Youtube/Kodi and it wasn’t hard for me, but this; i cannot decipher.

    just a suggestion.

    Like

  6. Wow, this is really coming together! I was having some crashing issues with some of the earlier versions, but this new one works pretty much flawlessly. I can see myself spending a lot of time with this. Thanks so much for your work!

    Like

  7. Hi man, like what you did with the app, I am a .net developer and i am interested to assist with one or more topics, shoot me an email if you are interested

    Like

  8. Updating my collection for the first time in a while and I can’t find American, or USA under nationality. My list ends with Israel, seems like a lot of nationalities are missing.

    Like

  9. Help; I add themes to a website. When I add the website to a scene, the themes do not always show up. The problem occurs when I change websites. So I add 50 scenes from Blowjob Ninjas no problem, the I ad 50 scenes from Tug Jobs and no themes. I add the website and themes, themes are different for each website.

    Like

  10. The program always crashes when I try to create or load a database, the last version has the same problem. So I’m using the version 3.18.6131.13330 😦

    Like

      1. I don’t know how to do this, ’cause I can’t load a database. So I only have access to the homepage. When I try to create a new database, the program creates the file ‘pg_db.db’, but crashes after this. And if I try to load this database file in a older version, crashes too.

        Like

  11. Hey, man. Thanks for the Pornganizer, it’s a neat tool.

    Just wanted to tell you about a bug I’ve found: I have some JAV and their file names are in Japanese, plus the code between brackets. Problem is, when I tried to add a category to a bunch of DVDs, they all lost their punctuation (brackets and hyphens). I’m gonna have to rename a lot of shit…
    Here’s a screenshot to illustrate my point: https://imgur.com/a/eT0cO
    Something else: it looks like the option to have the player start in fullscreen isn’t working. At least, it’s not working for me (I’m using MPC).

    I also wanted to know, can you separate your DVDs into different categories, with one per page? Like, page 1 would be your Amateur stuff, page 2 is gonzo, page 3 is feature films…
    Another thing that would be nice as well, would be a dark theme for the program. All that white is hurting my eyes.
    Oh, and as someone said, you should be able to tag DVDs and their scenes should inherit their “mother’s” tags.
    Off the top of my head, that’s it. Thanks again for your work!

    Like

    1. PG removes punctuation from the names of scenes imported into PG. it’s part of the auto tagging process.
      If you are using MPC, PG runs something like ‘mpc.exe myfavoritescene.mp4 /fullscreen’. you can test that on command line. here’s the code: https://gist.github.com/anonymous/3c0fa2cd9ed1f49cbca32354c0650841
      the code that displays DVDs is the exact same as the code that displays all the other types of items. what you are asking for is a big job, not going to happen anytime soon.
      if you tag a dvd with a theme, scenes you then that with that dvd will inherit the theme.

      Like

  12. Slight problem I like to add themes to websites, since the websites I use usually have a common theme, such as handjobs or blowjobs. This system had been working great. But the latest website I added does not add the themes to the scenes.

    Like

  13. This update fails to detect mostly of mine .mp4 videos and i can’t find a solution to that, hope to see a better format support in the future updates

    Like

    1. i have a library of ~15k scenes the majority of which are MP4’s. do your files end in .MP4 instead of .mp4? someone reported recently that capitals make a difference, i will fix it in a future update. otherwise there should be no issues with mp4s.

      Like

  14. I have a complaint, more a pet peeve. One named stars are found in other star details. For instance Their is Charlie, Charlie Lane, and Charlie Kane. I find Charlies videos in all 3 spots, and sometimes I even find Lane and Kane mixed up (this very well could be my fault). I have tried adding a second name, Smith, Jones etc, but then Google has the wrong image. I would suggest that PG does not make changes to the Star part of the database. This would probably be difficult to program, since PG adds tags automatically. Maybe there is someway it can identify single name stars.

    Like

    1. I’ve had problems similar to this as well, mostly with categories though. Eagerly awaiting an update that gives us the ability to give a scene exclusions so it’s not tagged incorrectly.

      Like

  15. Got a few suggestions which I think other would also like.

    1) Filter duplicate themes on scenes. This won’t just reduce the massive amount of entries in the database but it will also reduce the length of the window flyout so that we don’t have to scroll to see categories.

    I made the following SQL Query to do this:

    ALTER TABLE “main”.”SceneDescriptors” RENAME TO “_SceneDescriptors_old”;

    CREATE TABLE “main”.”SceneDescriptors” (
    “Id” INTEGER PRIMARY KEY AUTOINCREMENT,
    “SceneId” INTEGER,
    “DescriptorId” INTEGER,
    CONSTRAINT “fkey0” FOREIGN KEY (“DescriptorId”) REFERENCES “Descriptors” (“Id”),
    CONSTRAINT “fkey1” FOREIGN KEY (“SceneId”) REFERENCES “Scenes” (“Id”),
    UNIQUE (“DescriptorId” ASC, “SceneId” ASC) ON CONFLICT REPLACE
    )
    ;

    INSERT INTO “main”.”SceneDescriptors” (“Id”, “SceneId”, “DescriptorId”) SELECT “Id”, “SceneId”, “DescriptorId” FROM “_SceneDescriptors_old”;

    UPDATE “main”.”sqlite_sequence” SET seq = 0 WHERE name = ‘SceneDescriptors’;

    2) When updating a Star with a Theme to apply it to all the Scenes contraining that Star

    3) Add Star Scene count. So that I can arrange Stars by the number of Scenes they are in.

    Currently I’ve used the “PlayCount” column in the table Stars to be able to achieve this.

    I did a manual update by selecting the results from the following SQL Query:

    SELECT
    Stars.Id,
    Name,
    count(*)
    FROM Stars
    INNER JOIN SceneStars on Stars.Id == SceneStars.StarId
    GROUP BY
    Name
    ORDER BY Stars.Id ASC;

    NOTE: If you want to update yours from reading this comment I advice you to make sure there is no Stars with 0 Scenes by making sure the Stars row count and the SQL query’s row count is the same..

    4) Remember the first Porganizer version 1 on the Stars tab, you had a alphabetical filter to select Stars starting with an A or B etc. Can you add this filter again please? there is just to many stars starting with A

    Like

    1. 1) dont understand this. if there are duplicates in the table, it’s a bug.
      2) yeah its on my list
      3) i want to do this, its just not so easy to do well. the way PG is structured, it does 99% of database reads on startup and then operates purely from memory. to do counts properly, i’ll have to monitor for changes in real time and adjust.
      4) you can already do this with the advanced search interface. just type A into the name search box. it’s not as accessible as V1, but i don’t really want to add that bar to v3, it takes up too much space and its hard to make it look nice.

      Like

  16. No, I’m not using the ffmpeg dll. I am using NReco.VideoConverter.dll. I however tried to start PG without it and unfortunately the issues remains.

    Like

  17. Bug Report; When Opening Star Flyout it takes up the whole screen and only way to close it is to minimize PG then Maximize PG. The flyout window is no smaller and can see main window behind it and can close flyout.

    Like

  18. If you tag a DVD with a certain category, the next time you start PG it is gone. Also, the DVD doesn’t seem to inherit the categories of its scenes. Stars are inherited and sometimes Website, but never categories for some reason.

    Like

  19. Adding or renaming stars causes the program to freeze for up to a minute. During this minute hundreds of temp journal files are generated while updating the database all at once.

    Like

  20. Adding or renaming a star causes it to freeze for sometimes over a minute. I’ve noticed that there is hundreds of journal files bieng created in this process as its accessing the database.

    Like

  21. If I add a theme to a website shouldn’t all the scenes in that website also add that theme? And on the website page search/filters there is no theme omnibox.

    Like

  22. PG has been working great with all the single scenes that I’ve imported, but as I’ve started to add my DVDs to the database I have come across somewhat of an issue: Even though I know I’ve tagged a certain pornstar in a particular DVD, PG doesn’t return any results for that star using the search menu in the DVD section. But if I first click on the DVD where I know the star is tagged, and then go back and do the search, I get a hit. Has anyone else experienced this??? I would like to solve this somehow before I continue to enter my entire collection in to PG, since it basically becomes pointless if I can’t search the collection properly anyway.

    Like

  23. 1. is there any user guide posted somewhere? This programs looks really fun but i am having a hard time learning it.

    2. how do we use the google search? i have created the API and put the API key into PG. I don’t know what i am supposed to do from within PG to make use of that API.

    3. Building the star/actress database is going to take a long time.
    I am searching their photos on web browser, find the correct picture with correct dimensions, save it to disk and than load it into PG. Then i copy-pasted their bios from web browsers to PG.
    Is there any faster way than switching back and forth between web browsers and PG?

    4. Is there any “database” available for download that are already pre-populated with tags, descriptors, star pictures and bios, etc ? So we don’t just build from zero-empty database. somekind of test or sample db, maybe?

    Like

    1. 1. joining the discord server and asking for help is probably the closest thing to a user guide
      2. once you have a valid key input into PG, new tags you create automatically fetch an image
      3. star bios take a long time. with the google key, you aren’t forced to manually search out an image, but the google results are not always so great. i have some concepts for a scraper to auto fill the bio but its nowhere near ready.
      4. someone posted one a while back but i never checked it out.

      Like

      1. I use IAFD.com for bio information. PG is so good because it is customizable you can input just what you will use, and use any tags you want.

        Like

  24. Any way to remove duplicates? I had ~1500 scenes in my database, but to save space, I ended up using Handbrake to transcode them into something with slightly lower resolution and higher compression. However, I kept all the filenames and extensions the same, so the database had no issues finding and playing the files from within PGV3. Except when I went to add new scenes, by dragging the folder in, like I usually do, it detected ALL the scenes as new scenes. Any ideas on a quick way to clean this up?

    Like

    1. no easy way. duplicates are detected by file hash. when you modified the files, the hash changed. you can avoid the problem by not adding the newly modified files, but that is clearly not ideal.

      Like

      1. Hm…crap. Cuz I transcoded probably 90% of my library. It would have been SOMEWHAT simple to go through and manually delete the newly added scenes that are duplicates. But removing the NEW scenes just means that they’re re-added when I rescan the folder contents. Any way to update those file hashes? Otherwise I’m essentially starting from scratch, since I’ll lose all categories attached to scenes and all stars attached to scenes that weren’t autodetected,

        Like

  25. A couple of related suggestions, Add Not to and/or button. For examples Blowjobs NOT blondes. So only blowjobs without blondes would be shown. And if possible more than one of these buttons. So You could say Blowjobs and Handjobs and swallowing Not redheads.

    Like

    1. what you are suggesting is very difficult to implement. i would basically have to redesign the filter system to allow you to build an equation ((blondes AND (blowjobs OR anal)) + (NOT readheads). not going to happen anytime soon.

      Like

  26. Hi how can I test if Discord is working? Also I have seen people upload stars to Discord, how can I download them? I wasn’t sure where to post these questions on Discord, so I am asking here. Hope this is alright.

    Like

  27. Halp, the installer crashes right away and gives this error message (in Windows 7 64 bit):

    Problem signature:
    Problem Event Name: CLR20r3
    Problem Signature 01: PGV3(1).exe
    Problem Signature 02: 3.19.6166.34761
    Problem Signature 03: 582f9a74
    Problem Signature 04: PresentationFramework
    Problem Signature 05: 4.0.30319.34295
    Problem Signature 06: 570dcae6
    Problem Signature 07: 7fec
    Problem Signature 08: fb
    Problem Signature 09: System.Windows.Markup.XamlParse
    OS Version: 6.1.7601.2.1.0.768.3
    Locale ID: 1033
    Additional Information 1: dce6
    Additional Information 2: dce642eadbf91bc0ae6ab820ad6e3b42
    Additional Information 3: bc49
    Additional Information 4: bc493e2b2491f55b158d12f9ff60fecd

    Like

    1. the purpose of creating gfycats and gifs is exactly that, to create gfycats and gifs. they are fun. hopefully at some point in the future they will be able to be used as thumbnails. also, if you have discord integration setup, your gifs are automatically posted for all to enjoy 🙂

      Like

  28. Custom images don’t seem to be working, and my database takes about four times as long to load as compared with the version of PG from October 13 (version 3.18.6131.13330).

    Like

    1. the database taking longer to load (especially four times longer) doesn’t make much sense to me. nothing has changed so drastically as to affect that. do you use a lot of web url’s for item images? i’ve noticed that sometime this can bog down the startup process.

      Like

      1. Yes I do use quite a few web urls for images, but i dont think that’s the problem, since when I switch back to the older version everything loads fast again.

        Like

                1. ??? wtf. i can do 15000 scenes in ~30 seconds. something is really wrong.

                  can you make a new database, dump in those 75 scenes, and without making any other changes, test load times again?

                  Like

                  1. I’ve created a new database with those scenes only, and the result is the same. The problem appears only when I add a 4k scene in 60fps

                    Like

                    1. i have more than 75 4k 60 fps scenes within my library of 5k scenes, so this is a tough one for me. the next version will improve some loading issues, but they are mostly related to scene tags, and you are saying you have the same issue with only the raw scenes. its possible your computer is just slow, but since you are able to play 4k video, this seems unlikely. also, the real work generating thumbnails is only done against wmv, mkv, avi files, otherwise it just uses windows thumbnail cache. are you using the ffmpeg dll? if so, try removing it.

                      Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s