Jump to content

Phillyman

Clients
  • Posts

    876
  • Joined

  • Last visited

  • Days Won

    2

Reputation Activity

  1. Agree
    Phillyman got a reaction from SJ77 in White Screen When I Change PHP To 8.1   
    Ha, thanks for the help. This was less painful then last months task of enabling NGINX and setting up an SSL cert to point to a subdomain with a port number. 15+ years of running a website and I still feel like I know nothing!
  2. Like
    Phillyman got a reaction from SeNioR- in PAID - Count IP Pages Revisions by Member, Write to Profile Field   
    In Database Revisions for IP Pages, it keeps track of revision numbers and who made each revision. I would like a mod that counts the revisions for each unique contributor. Then writes that sum back to a profile field I have setup.
     
    User 4418 made 2,339 edits.
     
    Right now I am manually doing this task by outputting the data from PHPMyAdmin, then manipulating in CSV with Powershell, then creating SQL statements to drop it back in. PM me if you are interested.
     

  3. Like
    Phillyman got a reaction from SeNioR- in PAID - Count IP Pages Revisions by Member, Write to Profile Field   
    I wish this was native, we have a wiki in IPB and I feel like it is neglected. It is such a powerful part of the suite. It should function more like Wikipedia for rewarding contributors. Sure Badges counts new pages added, but totally ignores edits which are equally important!
     

  4. Haha
    Phillyman reacted to Randy Calvert in PAID - Count IP Pages Revisions by Member, Write to Profile Field   
    While I can’t help with the request, I just wanted to say hello to a fellow neighbor in the Alexandria, VA area. 🙂
  5. Like
    Phillyman got a reaction from Senior2323 in Delete Mass Pending Invoices   
    How can I delete in mass, pending invoices. Someone was hitting my site creating invoices, made about 1500 pages worth of them, each page has like 20 of them. They used the same name on all of them, I just want to purge those pending invoices from my database records.
  6. Like
    Phillyman got a reaction from Senior2323 in Delete Mass Pending Invoices   
    yeah we need a pending cleanup, like a task to delete pending invoices after X days, or captcha on the invoice generation page.
  7. Like
    Phillyman got a reaction from Senior2323 in Delete Mass Pending Invoices   
    Oh my god, that may have been what was happening to me!!!!!
    The same day, I had like 41 guests that did $1 charges. I just figured I got mentioned somewhere, never put them together!
  8. Like
    Phillyman got a reaction from Senior2323 in Delete Mass Pending Invoices   
    Should be donate or buy, what if you have a cheap $5 product, and they just hammer that all day long
  9. Like
    Phillyman got a reaction from Senior2323 in Delete Mass Pending Invoices   
    I am just going to have another button for Paypal for guest donations.
  10. Like
    Phillyman got a reaction from Senior2323 in Delete Mass Pending Invoices   
    Somewhat, I mean if I want people to be able to donate crypto, I have to have something for that anyhow. So might as well give an option for account-less donations.
  11. Like
    Phillyman got a reaction from AlexJ in Delete Mass Pending Invoices   
    yeah we need a pending cleanup, like a task to delete pending invoices after X days, or captcha on the invoice generation page.
  12. Like
    Phillyman got a reaction from JohnDar in Delete Mass Pending Invoices   
    Oh my god, that may have been what was happening to me!!!!!
    The same day, I had like 41 guests that did $1 charges. I just figured I got mentioned somewhere, never put them together!
  13. Like
    Phillyman reacted to opentype in Feature request: More options for the Pages database relationship field   
    The Pages database relationship field is great for collecting more complex data that doesn’t fit in simple lists. But the field is not very user-friendly. 
    First of all, it would be great to bring back more input options as in 3.4. At the moment, we only have the “type-ahead” input. But that means users need to know what record they want to link to upfront and they need to learn that they have to start typing to find it. For the majority of databases (which don’t have thousands of entries) a drop-down menu would be a better choice. It would clearly tell the users their choices without any guesswork about the entries or how to get to them. 
    But my main problem is the fact that the field has no option to deal with missing entries. As admin I understand it and can deal with it, but for the users, it’s way too confusing. The field should show an option to create a missing entry, preferably inline without having to leave the page. Real-world example: A user creates an entry in a book database with links to an author and a publisher database. If an author is not yet available in the author database, it should be possible to create the external author entry instantly and preselect it right from the form creating the book entry. That’s what users would expect. I can’t tell them: first go to database B, C, D, and E and check if your related entries already exist and manually create them if necessary. Only then go to the main database to create your record A which links to B, C, D, and E. 
  14. Like
    Phillyman got a reaction from m_shahpiri in [Bug] Profile fields IPS 4.6.6   
    Can confirm this on my site as well, lost all my custom profile fields....

     
    Which should be like Xbox, PSN, Steam icons....
     
     
     
  15. Like
    Phillyman reacted to Yamamura in [Bug] Profile fields IPS 4.6.6   
    «To apply the patch, please visit support in your Admin CP and select the "Optional Update" item shown»
  16. Like
    Phillyman reacted to MMXII in Give Pages Some Love - Achievements for Wiki Modifications!   
    Yes, please! For IPS5, please add a ton of easy-to-use functionality so that we can build great looking pages with much coding-knowledge. Layouts, containers, boxes, everything with WYSIWYG, permission-based displaying... you can basically go through the whole Wordpress/Joomla/Drupal catalog. There is so much room for a true Pages app!
  17. Like
    Phillyman got a reaction from sobrenome in Give Pages Some Love - Achievements for Wiki Modifications!   
    I grew impatient, so I rigged some recognition of my own. Follow at your own risk, and only after you have made backups!
     
    Go into ibf_cms_database_revisions from inside of PhpMyAdmin and export these two fields to a CSV file....
    `revision_id` `revision_member_id` You will end up with a CSV that looks something like this.....once saved open in Excel and save as a Tab Delimited file (Revisions.txt), store it in C:\Temp

     
    Basically Record 19, updated by member 1, Record 20 updates by member 1...etc
    Well this is no good, I dont want to count how many times Member 1 edited a record, that could be thousands of times.....
    Lets use AutoHotKey to do some logic on this.....
    #NoEnv ; Recommended for performance and compatibility with future AutoHotkey releases. ; #Warn ; Enable warnings to assist with detecting common errors. SendMode Input ; Recommended for new scripts due to its superior speed and reliability. SetWorkingDir %A_ScriptDir% ; Ensures a consistent starting directory. COUNT = 0 PrevID = 9999999 Loop, read, C:\TEMP\Revisions.txt { StringSplit, LineArray, A_LoopReadLine, %A_Tab% RevisID := LineArray1 MembID := LineArray2 If MembID = %PrevID% { COUNT++ } else { COUNT++ FileAppend, UPDATE ``ibf_core_pfields_content`` SET ``field_44``='%COUNT%' WHERE ``member_id``='%PrevID%';`n, %A_ScriptDir%\Revisions-SQL.txt Count = 0 } PrevID := MembID } MSGBOX, Done!  
    So I wrote a small script to read the tab delimited data and then write out SQL commands to drop the final numbers back into a custom profile field. In my case it ended up being field_44, which is a profile field that can't be edited by my members.
    In the end I get a bunch of SQL commands to use in PHPMyAdmin, which now I can see who had how many revisions across all my databases.
    UPDATE `ibf_core_pfields_content` SET `field_44`='5053' WHERE `member_id`='1'; Now we know that member 1 had 5053 database revisions.
    On the profile field side, I just created a text profile field, prevented members from editing it, and set the formatting like this.....
    <span class='fc'><img src="/images/database.png" alt="{$title}" title="{$title} - {$content}"></span> and now the database revisions show up on my profiles. Now if I could only learn how to do this automatically with PHP and Cron jobs 🤣
    Again, check your tables, fields and backup before you try any of this.

     
  18. Agree
    Phillyman got a reaction from Umaar in Give Pages Some Love - Achievements for Wiki Modifications!   
    Sometimes I feel like poor little Pages gets no love, the built in Wiki feature is worth its weight in gold. To be able to stand up databases and leverage our members to create/modify those pages....is a HUGE feature. Lets try to flesh out the recognition of our member when they add in information. Right now we can assign points and achievements for creating records, but generally, if I am standing up a huge database....I want to have control over the initial record creation.
    Why?
    Well lets take video games, its very easy to go grab a list of every Nintendo Entertainment System game ever released in the USA. However, if I let USERS create those records, generally there may be duplicates, because when it comes to "The Legend of Zelda", how are we handling that name? Under T for The? Under L for Legend? So I generally pick the naming scheme and then dump in the records in mass. But then its up to members to add in the information of said records. But we currently do not recognize revisions in any meaningful way.
    Lets look at Wikipedia...
    https://en.wikipedia.org/wiki/The_Legend_of_Zelda
    If you go to that page, you can drop down to the revisions....
    https://en.wikipedia.org/w/index.php?title=The_Legend_of_Zelda&action=history
    and you can then see who the contributors are, and drill down further....
    https://en.wikipedia.org/wiki/User:Sergecross73
    We can then see the following under his wikipedia profile....

    As you can see, very easy to see this user has made 76,400+ contributions to Wikipedia....along with many other automatically recognized "stats". People like to be recognized for their hardwork, even when its just a few mentions on their profile of their accomplishments on a site.
     
  19. Like
    Phillyman got a reaction from sobrenome in Give Pages Some Love - Achievements for Wiki Modifications!   
    Sometimes I feel like poor little Pages gets no love, the built in Wiki feature is worth its weight in gold. To be able to stand up databases and leverage our members to create/modify those pages....is a HUGE feature. Lets try to flesh out the recognition of our member when they add in information. Right now we can assign points and achievements for creating records, but generally, if I am standing up a huge database....I want to have control over the initial record creation.
    Why?
    Well lets take video games, its very easy to go grab a list of every Nintendo Entertainment System game ever released in the USA. However, if I let USERS create those records, generally there may be duplicates, because when it comes to "The Legend of Zelda", how are we handling that name? Under T for The? Under L for Legend? So I generally pick the naming scheme and then dump in the records in mass. But then its up to members to add in the information of said records. But we currently do not recognize revisions in any meaningful way.
    Lets look at Wikipedia...
    https://en.wikipedia.org/wiki/The_Legend_of_Zelda
    If you go to that page, you can drop down to the revisions....
    https://en.wikipedia.org/w/index.php?title=The_Legend_of_Zelda&action=history
    and you can then see who the contributors are, and drill down further....
    https://en.wikipedia.org/wiki/User:Sergecross73
    We can then see the following under his wikipedia profile....

    As you can see, very easy to see this user has made 76,400+ contributions to Wikipedia....along with many other automatically recognized "stats". People like to be recognized for their hardwork, even when its just a few mentions on their profile of their accomplishments on a site.
     
  20. Agree
    Phillyman got a reaction from SorteX in Coinbase Commerce Gateway - Support Topic   
    Also wondering if this mod will be updated for 4.6.
  21. Like
    Phillyman got a reaction from AlexJ in Give Pages Some Love - Achievements for Wiki Modifications!   
    Sometimes I feel like poor little Pages gets no love, the built in Wiki feature is worth its weight in gold. To be able to stand up databases and leverage our members to create/modify those pages....is a HUGE feature. Lets try to flesh out the recognition of our member when they add in information. Right now we can assign points and achievements for creating records, but generally, if I am standing up a huge database....I want to have control over the initial record creation.
    Why?
    Well lets take video games, its very easy to go grab a list of every Nintendo Entertainment System game ever released in the USA. However, if I let USERS create those records, generally there may be duplicates, because when it comes to "The Legend of Zelda", how are we handling that name? Under T for The? Under L for Legend? So I generally pick the naming scheme and then dump in the records in mass. But then its up to members to add in the information of said records. But we currently do not recognize revisions in any meaningful way.
    Lets look at Wikipedia...
    https://en.wikipedia.org/wiki/The_Legend_of_Zelda
    If you go to that page, you can drop down to the revisions....
    https://en.wikipedia.org/w/index.php?title=The_Legend_of_Zelda&action=history
    and you can then see who the contributors are, and drill down further....
    https://en.wikipedia.org/wiki/User:Sergecross73
    We can then see the following under his wikipedia profile....

    As you can see, very easy to see this user has made 76,400+ contributions to Wikipedia....along with many other automatically recognized "stats". People like to be recognized for their hardwork, even when its just a few mentions on their profile of their accomplishments on a site.
     
  22. Like
    Phillyman got a reaction from Sonya* in Give Pages Some Love - Achievements for Wiki Modifications!   
    I grew impatient, so I rigged some recognition of my own. Follow at your own risk, and only after you have made backups!
     
    Go into ibf_cms_database_revisions from inside of PhpMyAdmin and export these two fields to a CSV file....
    `revision_id` `revision_member_id` You will end up with a CSV that looks something like this.....once saved open in Excel and save as a Tab Delimited file (Revisions.txt), store it in C:\Temp

     
    Basically Record 19, updated by member 1, Record 20 updates by member 1...etc
    Well this is no good, I dont want to count how many times Member 1 edited a record, that could be thousands of times.....
    Lets use AutoHotKey to do some logic on this.....
    #NoEnv ; Recommended for performance and compatibility with future AutoHotkey releases. ; #Warn ; Enable warnings to assist with detecting common errors. SendMode Input ; Recommended for new scripts due to its superior speed and reliability. SetWorkingDir %A_ScriptDir% ; Ensures a consistent starting directory. COUNT = 0 PrevID = 9999999 Loop, read, C:\TEMP\Revisions.txt { StringSplit, LineArray, A_LoopReadLine, %A_Tab% RevisID := LineArray1 MembID := LineArray2 If MembID = %PrevID% { COUNT++ } else { COUNT++ FileAppend, UPDATE ``ibf_core_pfields_content`` SET ``field_44``='%COUNT%' WHERE ``member_id``='%PrevID%';`n, %A_ScriptDir%\Revisions-SQL.txt Count = 0 } PrevID := MembID } MSGBOX, Done!  
    So I wrote a small script to read the tab delimited data and then write out SQL commands to drop the final numbers back into a custom profile field. In my case it ended up being field_44, which is a profile field that can't be edited by my members.
    In the end I get a bunch of SQL commands to use in PHPMyAdmin, which now I can see who had how many revisions across all my databases.
    UPDATE `ibf_core_pfields_content` SET `field_44`='5053' WHERE `member_id`='1'; Now we know that member 1 had 5053 database revisions.
    On the profile field side, I just created a text profile field, prevented members from editing it, and set the formatting like this.....
    <span class='fc'><img src="/images/database.png" alt="{$title}" title="{$title} - {$content}"></span> and now the database revisions show up on my profiles. Now if I could only learn how to do this automatically with PHP and Cron jobs 🤣
    Again, check your tables, fields and backup before you try any of this.

     
  23. Agree
    Phillyman got a reaction from Jimi Wikman in Give Pages Some Love - Achievements for Wiki Modifications!   
    Sometimes I feel like poor little Pages gets no love, the built in Wiki feature is worth its weight in gold. To be able to stand up databases and leverage our members to create/modify those pages....is a HUGE feature. Lets try to flesh out the recognition of our member when they add in information. Right now we can assign points and achievements for creating records, but generally, if I am standing up a huge database....I want to have control over the initial record creation.
    Why?
    Well lets take video games, its very easy to go grab a list of every Nintendo Entertainment System game ever released in the USA. However, if I let USERS create those records, generally there may be duplicates, because when it comes to "The Legend of Zelda", how are we handling that name? Under T for The? Under L for Legend? So I generally pick the naming scheme and then dump in the records in mass. But then its up to members to add in the information of said records. But we currently do not recognize revisions in any meaningful way.
    Lets look at Wikipedia...
    https://en.wikipedia.org/wiki/The_Legend_of_Zelda
    If you go to that page, you can drop down to the revisions....
    https://en.wikipedia.org/w/index.php?title=The_Legend_of_Zelda&action=history
    and you can then see who the contributors are, and drill down further....
    https://en.wikipedia.org/wiki/User:Sergecross73
    We can then see the following under his wikipedia profile....

    As you can see, very easy to see this user has made 76,400+ contributions to Wikipedia....along with many other automatically recognized "stats". People like to be recognized for their hardwork, even when its just a few mentions on their profile of their accomplishments on a site.
     
  24. Agree
    Phillyman got a reaction from Unienc in Improve achievements system : repeatable rules   
    I like this, because lets say once you set up the following....
     
    Signed in 1 day in a row Signed in 7 days in a row Signed in 31 days in a row Signed in 90 days in a row Signed in 180 days in a row Signed in 365 days in a row Once a member gets thru that, there is nothing more to gain, unless admins keep expanding it indefinitely.  Or to your point, you let them repeat.
    This member has won "Signed in for 7 days" three times!
    etc...
  25. Agree
    Phillyman got a reaction from Unienc in Give Pages Some Love - Achievements for Wiki Modifications!   
    Sometimes I feel like poor little Pages gets no love, the built in Wiki feature is worth its weight in gold. To be able to stand up databases and leverage our members to create/modify those pages....is a HUGE feature. Lets try to flesh out the recognition of our member when they add in information. Right now we can assign points and achievements for creating records, but generally, if I am standing up a huge database....I want to have control over the initial record creation.
    Why?
    Well lets take video games, its very easy to go grab a list of every Nintendo Entertainment System game ever released in the USA. However, if I let USERS create those records, generally there may be duplicates, because when it comes to "The Legend of Zelda", how are we handling that name? Under T for The? Under L for Legend? So I generally pick the naming scheme and then dump in the records in mass. But then its up to members to add in the information of said records. But we currently do not recognize revisions in any meaningful way.
    Lets look at Wikipedia...
    https://en.wikipedia.org/wiki/The_Legend_of_Zelda
    If you go to that page, you can drop down to the revisions....
    https://en.wikipedia.org/w/index.php?title=The_Legend_of_Zelda&action=history
    and you can then see who the contributors are, and drill down further....
    https://en.wikipedia.org/wiki/User:Sergecross73
    We can then see the following under his wikipedia profile....

    As you can see, very easy to see this user has made 76,400+ contributions to Wikipedia....along with many other automatically recognized "stats". People like to be recognized for their hardwork, even when its just a few mentions on their profile of their accomplishments on a site.
     
×
×
  • Create New...