Jump to content

Community

Phillyman

+Clients
  • Posts

    801
  • Joined

  • Last visited

1 Follower

About Phillyman

Recent Profile Visitors

23,488 profile views

Phillyman's Achievements

  1. 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.
  2. 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...
  3. 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.
  4. Yeah that was my next thought, do I have to modify a template. Or write a nightly dump of everyones points into a uneditable custom profile field.
  5. Love the points system, I see where it tells me how many points until my next rank. But where does my point total show? Is there a way for my users to see how their points totals happened, like I can see in the AdminCP?
  6. Just curious if under General Configuration >> Social Profiles if I can add/modify these? I have no idea what a Xing is, but I would like for Telegram, Discord or OnlyFans to be selectable. How hard is it to modify these, or should I just go add what I need into the template itself?
  7. Just thinking more about this. This might actually make Badges/Achievements catch up faster. Lets say you have 20,000 members, if the badges run backwards to check if they have been acquired, they only need to hit the highest achievement and then the system would know to give all the lower acheivements as well. So if right now the system goes like this.... Member 1, Does he have 1 post? If so give achievement 1 post Member 1, Does he have 10 posts, If so give achievement 10 posts ..... Member 1, Does he have 100,000 posts, if so give achievement 100,000 posts Well that means Member 1 has to be run thru each level to see if he has met the condition. However if the badges are grouped, You could work backwards from 100,000 and lets say he only has 55,000 posts, then the check only has to do the following.... Member 1, Does he have 100,000 posts, if so give him achievement 100,000 posts Member 1, Does he have 50,000 posts, if so give him achievement 50,000 posts Condition met, Automatically skip/give 1-25,000 If so, this could possibly speed up rebuilds against large communities with large amounts of badges/achievements.
  8. So I love the new achievement, badges, ranks system. I plan to create the following badges Created 1 Topic, 10, 25, 50, 100, 250, 500, 1000, 2500, 5000, 10,000, etc... Replied to 1 Topic, 10, 25, 50, 100, 250, 500, 1000, 2500, 5000, 10,000, etc... Uploaded 1 Image, 10, 25, 50, 100, 250, 500, 1000, 2500, 5000, 10,000, etc... Gave 1 Reaction, 10, 25, 50, 100, 250, 500, 1000, 2500, 5000, 10,000, etc... Submitted 1 File, 10, 25, 50, 100, 250, 500, 1000, 2500, 5000, 10,000, etc... Signed in for 1 day, 7 days, 1 Month, 3 Months, 6 months, 12 Months, 24 Months concurrently Anyhow, this is obviously going to lead to a TON of badges, My community has been running IPB since 2005. I want to give credit for past items created. So I would say let us create groups, put similar rules into those groups, and then choose to ONLY show the highest badge earned. So a user with 500 topics would only show the 500 Topics badge, and not the 6 previous badges. It's a given that if you have the 500 topics badge, that you would also have the 250, 100, 50....etc.
  9. You would think after 15 years of running IPB that I would have absorbed some of this. But I generally don't fuss with the skins.
  10. Can I download the official 4.6.3 skin from somewhere and reupload it to my site as a copy and put that back in place?
  11. Just rolled from 4.4.10 to 4.6.3, Trying to figure out what is causing this.... https://www.retromags.com/profile/1-phillyman/ And I am trying to see if these are bugs with padding? https://www.retromags.com/gallery/image/39424-tokyopop-issue-01-augustseptember-1999/ Seems like odd things have no top padding, or no left padding.
  12. Also wondering if this mod will be updated for 4.6.
  13. Oh if this could tie into Nexus and let users cash out 50,000 of their points for a $50 Coupon code..........
  14. Thanks for the quick reply, no rush. I just am planning my upgrade from 4.4.X and have a few mods that I need to know if I am taking into the future or looking for other ways to accomplish. 🙂
×
×
  • Create New...

Important Information

We use technologies, such as cookies, to customise content and advertising, to provide social media features and to analyse traffic to the site. We also share information about your use of our site with our trusted social media, advertising and analytics partners. See more about cookies and our Privacy Policy