[00:09:36] <[LS]#8872> 🔥 [00:45:36] Look at Template:abbr. There's also date templates on wikipedia that might help. Which calendar systems are you converting for? [01:09:19] They are custom ones as part of an RP community, so existing standards wouldn't work [01:47:09] Either learn Lua or get good at {{#expr:}} parser functions. Which one is easiest depends on how good of a programmer you are. [01:47:09] https://meta.miraheze.org/wiki/%23expr:Template: [02:06:08] Added {{delete}} to the page. [02:06:08] https://meta.miraheze.org/wiki/Template:delete [02:06:09] [02:59:42] <[LS]#8872> What license are yall publising under and why? [04:39:07] CC BY SA 4.0 [04:39:13] <:EpicFaceMH:912930767972225095> [07:19:40] Hello! [07:19:51] is there a way to make the "headings" clickable? [07:20:01] ffos database - (That section) [08:40:51] doubtful, tried to give it link brackets? [08:47:24] <:DoneMH:775407710400675940> Thank you very much [12:27:18] [1/2] Not easily, I did manage myself to have "headers" with links on my wiki by injecting some extra HTML code using JS (and even in my case hide the 2nd level, since I just wanted a singular first level link to click with no content below it xD). So yeah you can do a LOT if you are willing to dive into the world of JS, but it is not an easy task. If [12:27:18] [2/2] you are up for attempting it, make a thread in #support with it(unless you can figure it out yourself ofc :P), as it may get a bit technical. I do have a few things to take care of right now, so be a bit patient until I get time for it. [12:28:58] and no @theoneandonlylegroom MediaWiki:Sidebar does not accept most normal wikitext, including [[ ]] [12:28:58] https://meta.miraheze.org/wiki/_ [12:29:10] yee, thought so [12:29:28] I think it's possible only w/ Cosmos navigation [12:30:39] turn first level headers into links I mean [12:32:12] Well as I said above it is possible with some JS as well (I am using Timeless, but I see no reason it wouldn't work on any other skin too), whether cosmos have some easier options I can't speak for though [12:33:39] [1/2] mean like w/o JS [12:33:40] [2/2] Cosmos navigation uses its own MediaWiki page and it's identical to how navigation is defined on FANDOM [12:34:15] the rest skins have only default MediaWiki:Sidebar [12:34:27] Never had a Fandom wiki myself either so that doesn't tell me much 😛 [12:35:10] I got there not long before they rebranded into FANDOM, idk what's wring was w/ "wikia" [12:35:21] lame [12:36:17] Mm I think I'm gonna focus on the more important sections of the wiki [12:37:26] I'd suggest, maybe make that header into actually the first link of its section, and just name the header into something more general [12:37:58] [1/3] like [12:37:58] [2/3] The database [12:37:58] [3/3] * ffos ... [13:17:41] Hey Miraheze, I had a bot set up by CosmicAlpha which seems to have died yesterday. Linking Discord to IRC. How should I go about getting that resolved? [13:20:45] CA left Miraheze and we had it down too [13:21:14] someone more in the know might help or give proper direction [13:56:21] How goes Miraheze? [13:58:50] I'd say quiet today [15:21:03] /auth [15:38:15] Pokey: you'll want to contact voic to get the invite link [15:38:18] void* [15:38:49] MacFan4000: We already have a bot which was running, and still appears to be present [15:39:31] the bot on the discord side was deleted and so a new replacement one has to be added to the server [15:40:09] the irc bot will still be there yes [15:40:53] MacFan4000: So it has been... I will investigate why that happened, thank you for the pointer for whom to contact [15:59:57] what to investigate? [16:18:22] if i've made a bar chart, how would i remove all the key underneath it that shows what colour is what thing? [19:40:24] Reception closed Amanda's request [19:40:29] was it accepted? [19:41:06] yes [19:41:09] ah I'm blind, it is successful [19:41:21] well, congrats to Amanda [19:41:52] also since I am now effectivly the only member of the mediawiki team, I have decided that the 1.40 upgrade will not happen [19:42:39] @owenrb, @orduin: consider this a request for an emergency board meeting to resolve some sort of acknowledgement and have a plan for SRE [19:44:00] We're already in discussions between us [19:44:22] Not a board meeting specifically but actively talking [19:44:41] @owenrb I would like either a board meeting or an out of meeting resolution [19:44:45] With some indication [19:45:01] No informal comments, a progress update that the board are committing too [19:47:12] We are considering our options and engaging those that remain in a form of volunteering capacity to decide what the best course forward is and manage things responsibly [19:56:07] I've had my bid for Global Sysop fail on account of not reaching the necessary support ratio of 80%, but more CVT members in advanced positions are badly needed [19:56:33] As a result, even though it may be a little early, I may post another request within one or two weeks [19:56:52] I would support temporary appointment, if there is a valid provision for it. [19:57:14] @notaracham don't think there is [19:57:25] But I may hold off on another run until a course forward has been announced [19:57:26] Put it out for everyone to see [19:57:42] I also left a message at https://rhinosf1.com/miraheze [20:01:17] man [20:02:14] @theoneandonlylegroom yes? [20:03:18] idk, just an interjectiom [20:06:34] I'd discuss plans and maybe even panama, but jokes about palindromes in general seem like they'd be in poor taste. [20:10:04] If we're discussing Latin American countries, we better talk about Mexico [20:10:15] The opioid crisis in the U.S. is out of control [20:15:42] That's for #offtopic [20:15:44] For now [20:16:12] 4 Wiki Creators 3 SRE 2 meta sysops 1 steward and 0 meta bureaucrats [20:17:43] MacFan4000: not much more to loose [20:18:56] Reception resigned [20:19:07] yes [20:19:18] Prr skibidi dop dop yes yes [20:19:29] https://tenor.com/view/sultan-belly-dance-fat-guy-dance-gif-27637837 [20:20:01] @Hey Türkiye what [20:20:25] I feel a bit upset now. [20:20:31] I'm getting my daily dose it's just fun 😄 [20:20:37] Probably best to take offtopic stuff to #offtopic as usual [20:20:39] don't take it seriously [20:20:40] Not... again... 😦 [20:20:54] right man, totally the good time for that in main chat [20:21:03] Ooh, how goes your wikis? [20:21:17] While we still got a Miraheze, let's stay on topic [20:21:33] my aim was to activate the chat a bit lol 😄 [20:21:50] I managed to make my main page better! [20:22:03] mine? [20:22:12] exactly. Let's continue our Miraheze. [20:22:39] Yes, how goes it? [20:22:43] I don't think we got anything left to save [20:23:01] Miraheze is on life support [20:23:10] In ICU at the moment [20:23:12] What will it save? [20:23:23] Miraheze would not be likely to survive unless we can get more SRE volunteers [20:23:36] As suggested, interjections of the ski di bop bop variety need to go to off-topic. [20:24:27] You can look at Turkish developers, here php language is taught in informatics schools [20:24:35] MacFan4000: why have you stayed? [20:24:51] [1/3] well, on pause right now, except for updating news section [20:24:52] [2/3] I'm still doing the thing for journalist who contacted me, and I can't migrate now because of that + the wiki is still getting higher than usual numbers in google, which personally makes me happy [20:24:52] [3/3] it's frustrating what's happening now w/ the MH, very fucking unfortunate timing [20:24:52] if i go to informatics high school i will learn php so i can attend SRE (maybe) [20:24:53] I do not want Miraheze to die on me. MWZip already has [20:25:04] Yeah I'm not sure there's enough time [20:25:08] I figure somebody needs to be able to help with dumps and such [20:25:13] We need more SRE yesterday [20:25:23] @eytirth prepare for the worst [20:25:35] I can not help, I can barely set up basic MediaWiki [20:25:53] [1/3] well, on pause right now, except for updating news section [20:25:53] [2/3] I'm still doing the thing for journalist who contacted me, and I can't migrate now because of that + the wiki is still getting higher than usual numbers in google, which personally makes me happy [20:25:54] [3/3] it's frustrating what's happening now w/ the MH, very fucking unfortunate timing [20:26:05] MacFan4000: I know you are probably close but could you consider maybe action short of resigning? Like saying you'll only help with things that keep the lights on or allow users to leave [20:26:05] As this point, the Board should just release a statement and tell people to migrate elsewhere as well as possibly transfer whatever surplus funds there may be. [20:26:16] I only understand from Discord Bots. If I knew the PHP language, I would definitely join SRE. [20:26:33] I asked Owen earlier for the board to resolve a formal response [20:26:49] well shit [20:27:10] It should not be given to wikitiade at all [20:27:13] Absolutely no. If miraheze does the funds should be given back to who ever donates [20:27:33] Sre and board are currently discussing the next course of action [20:27:43] The funds should definitely not go to another project for sure. As for direct refunds that's also not really an option [20:27:49] Absolutely yes, we need to get our users back to MH. For example, I find Raidarr's global ban unfair. [20:28:05] But I don't think it's great to speculate. It's best to let the Board discuss and propose a solution [20:28:05] If Miraheze collapses, unless it's bought out, then my understanding is funds would go to the state @paladox [20:28:17] for a wind-down we would also have to decide what happens to hardware that we own in addition to the funds [20:28:31] Could sell hardware [20:28:33] Well I don’t know but people seemingly causing a panic and thus the community brought into has caused irreparable damage [20:28:41] Any assets left when a company closes fall to the state [20:28:45] Hardware would have to wiped and handled per GDPR and data protection laws [20:28:54] Doubt selling is an option [20:28:57] @paladox there is no mediawiki team left bar MacFan4000 [20:29:08] Who just said he's only there to help with dumps [20:29:17] [20:29:28] Although hasn't expressly committed to only essential work [20:29:35] I’m not going to waste my time on a project where people keep going on about miraheze collapse which in itself would lead to its collapse. [20:29:36] Can't we declare an emergency? [20:29:38] It’s demoralising [20:29:46] I don't think there's need to be alarmed though and it's best to wait for the Board'd decision rather than speculate about what might or might not happen [20:29:50] @paladox Can we please ta;lk about my main page then [20:29:54] Agent technically still has access (they haven't fully committed to resigning) [20:30:02] @Hey Türkiye there's no way to declare an emergency [20:30:10] technically, yeah, but I don't expect to remain too much longer [20:30:11] THat makes me happy as I managed to make it look nice [20:30:19] am i gonna have to swap all my stuff to a different wiki? [20:30:23] just helping in some low level tasks but I'll probably fully resign soon [20:30:50] 😦 [20:30:54] @Jokerj Maybe. [20:31:01] Agent, MacFan4000: could you commit to only keeping us online or helping people leave then? [20:31:04] Wouldnt be an unreasonable thing to look into [20:31:12] sure [20:31:15] any recommendations? [20:31:16] It is collapsing [20:31:26] The time is up for most people [20:31:38] i've also been continuing to work on SSL requests [20:31:45] @Jokerj: WikiTide is the natural successor [20:31:46] Agent [20:31:48] Agent, hey [20:31:55] No. 😢 [20:31:57] Agent: thanks [20:31:59] I would not recommend WikiTide [20:32:06] So what's happening with Miraheze? [20:32:13] Why? [20:32:14] please don't quit, i will cry 😭 [20:32:17] 😭 [20:32:27] Nothing for now, it may dissolve soon though [20:32:29] MacFan4000: I wouldn't bother with them although if you are. Wiki.fossbots.org is a dead domain if the cert exists still [20:32:31] Miraheze should not be closed, resignations should not increase. [20:32:37] I have major concerns over their commitment to data protection, they lack legal policies, and their draft ToU is currently illegal [20:32:42] I gave my life to Miraheze. [20:32:45] @Nion extreme shortage of volunteers makes it very hard to maintain the farm [20:32:54] Statements like that aren't very pertinent tbh [20:33:02] Only here because a wiki I use says it'll close because no one edited it in over 60 days which is weird because it's an active wiki (AVID) [20:33:11] You realize the US have very different laws, and thats where it is basex. [20:33:13] If I may make any recommendation regarding discussion topics, I would like folks to discuss technical volunteer recruitment [20:33:22] Well... maybe I can help people move wikis [20:33:30] is there a way to backup all my stuff? [20:33:33] But the resignation of serious names deeply upsets Miraheze. [20:33:35] I would have to use front end stuff though [20:33:45] Indeed, but the ToU is near copy and paste of Miraheze's which means in the US, it's not valic [20:33:46] Special:DataDump, ask SRE to make an image dump [20:34:02] Hey @Tali64 can you give me your email? [20:34:06] Its also a brand new project, things are still being worked out, things take time [20:34:08] WikiTeam will be able to help migrate people [20:34:13] Lol [20:34:16] peki ne görüşme? [20:34:20] OK, will DM you [20:34:43] Wow, got a DM [20:34:50] Shouldn't launch into a project hastily, accepting the handling of customers and love environment with no due consideration [20:35:02] in admin sidebar there is wiki dump lin [20:35:06] DataDump for XML is very easy to use. Current SRE members can also quite easily provide dumps for public wikis and upload them to archive.org. But once again I think it's best to wait for an official decision rather than speculate and jump to the worst conclusions. Nothing will be shut down over night [20:35:08] At this point this channel has become just a PR channel for Wikitide. Not nice, guys [20:35:16] How exactly do you think Miraheze started? It didnt happen overnight [20:35:19] I will be recommend Song against WikiTiade. Folks they’ll have the same issues as miraheze, you’ll be wasting your time. Especially with the people that caused the damage rn to miraheze. [20:35:30] Miraheze needs to recover. This arrangement does not go well. [20:35:32] I think AVID is migrating to WikiTide [20:35:34] @moskyx: it was proposed as an alternative as it's the only one that really exists [20:35:37] In a much more controlled way than this [20:35:48] Most people left fandom [20:35:49] Not really [20:35:50] Why re you advocating for that? [20:35:52] ShoutWiki is dying [20:36:03] Miraheze works fine but then again idk much about what happens behind the scenes [20:36:04] what do i then do with said dump, just let it happen then i can download it later? [20:36:13] Planning behind Miraheze was months [20:36:19] It formed from a site whose money was stolen and redirected to pornhub [20:36:28] As I said, there's not really any point to making such obvious wishful statements, they don't add much to the discussion. I understand you're trying to be helpful but such comments aren't very pertinent [20:36:39] This [20:36:50] Because those SRE left that aren't doing much should be honest about what they will do [20:37:00] shoutwiki also has advertisements unless you pay [20:37:03] I don't get why so many people feel the need to constantly repeat this is the end. Give it a rest, the feeling is that there are many people personally interested in this to happen [20:37:11] It’s simple [20:37:17] So what are we gonna do? [20:37:31] Wait for a statement from the board on next steps [20:37:39] I still haven't been able to solve the issue. I would appreciate it if NotAracham enlightened me. [20:37:42] panic at this point is pointless, we won't know until we know [20:37:44] Just wait for the board to do their job [20:37:56] Board to do what exactly [20:37:57] The Board will decide. There's little point in inflaming things and speculating here really. It doesn't do any good [20:38:04] You should have a disaster recovery plan anyway [20:38:10] That's just good practice [20:38:12] Test it [20:38:16] You keep saying that but then interject about prepare for the worse and to go over to wikitiade l [20:38:24] Folks can make contingency plans as they see fit, an ounce of preparation is never a bad thing, and hopefully you won't have to use it. [20:38:30] WikiTide* [20:38:49] @paladox the board are responsible for the company and have to address the issues with volunteer numbers [20:39:11] @notaracham I would appreciate it if you could shed some light on the matter for me. [20:39:27] I've already stated that I would like to at least pursue the idea of recruiting more technical volunteers. I would like to ask that this channel redirect efforts in this direction. [20:39:47] No need to panic, MH doesn't look like able to sunk anytime soon [20:40:07] Go LTS and all the upgrade problems instantly solved [20:40:08] We’ve been trying to recruit for years, I honestly dont know how the current situation will change anything [20:40:21] what do i do after the dump? [20:40:46] The dump contains articles and revisions so you can import them to another service if you want to. But for now Miraheze is up and functioning [20:41:06] Oh and the other farm is better? [20:41:07] ah ok, thanks! [20:41:25] We don't know that [20:41:28] It's a reset [20:41:32] We actually do [20:41:44] It's also the only good option that isn't Miraheze [20:41:52] Absolutely no [20:41:56] @paladox you don't have a crystal ball [20:41:58] can we please not argue? [20:41:59] There unfortunately are no good options here [20:42:04] The people with perms/still holding a volunteer position should either put the channel in slowmode and deal with actual issues or not engage. Just throwing fuel to the fire at this point. No matter if you want Miraheze to come out of this scarred but alive or hope it collapses after people pull out, this kind of chaotic bs isn't helping anyone. [20:42:07] Frankly, I don’t know, at this point I don’t think anything could be worse then a farm thats at a point pf uncertainty [20:42:19] [1/2] TL;DR: Reception123 resigned on good terms but reduced the technical team to few enough people that concerns were raised. Despite lack of people, there is sufficient funding for lights to stay on at MH for some time. [20:42:20] [2/2] Folks are doing lots of doomsaying, but I'd ask that we wait to see how the board would like to proceed. Void (a current board member) has suggested they'd like to pursue attracting enough technical talent to resume expansion of the project. [20:42:20] Is there any good wiki farm other than Miraheze and WikiTide/WikiForge ? [20:42:26] Technical volunteers are hard to find. Because it is necessary to know the PHP language and everyone turned to money. [20:42:31] Least worst then [20:42:42] I agree. Personally I don't think this discussion is going in a very meaningful direction and it's basically the same things being repeated. [20:42:46] I guess people would have to go to fandom even though I hate it. [20:42:50] Slow mode engaged [20:42:54] I'm talking to my Turkish developer friends, it's all about money [20:43:02] There is no good alternative to miraheze [20:43:03] Yes, I can't imagine many going back to fandom [20:43:21] Slowmode has been enabled and I would suggest reading @notaracham's message that I pinned above. [20:43:38] https://www.mediawiki.org/wiki/Hosting_services heres the list of hosts [20:44:33] ^Most of the list either paid or don't give you full freedom like MH [20:44:38] keep your heads in the cold [20:45:04] Yes, I also partially switched to Fandom, because there are no active Turks in Miraheze [20:45:10] I self host now [20:45:27] Self hosting is good if you have the skills/money [20:45:32] No page is even edited by anyone else. It is imperative that we introduce Miraheze. [20:45:57] I had 6 wikis disabled by Raidarr just because they were inactive. Switched to Fandom on some wikis. [20:45:59] With regards to recruitment, the idea I had was a global notice with a recruitment link. We'd also need to setup some landing page listing tasks that need to be done (probably based on [[Miraheze Vacancies]]). Could also slide a link into the footer. [20:45:59] https://meta.miraheze.org/wiki/Miraheze_Vacancies [20:46:00] [20:46:19] sounds good [20:46:23] Well, for those intersed in self hosting dormains I think are £30-100 a year, and RamNode servers are $5+ a month [20:46:32] I did try that during my time as EM. Maybe now if people realize that the situation is really dire there might be more luck with that. [20:46:59] I'd recommend also expanding the scope of my recruitement notice on Phabricator to include other positions (not only Software Dev) [20:47:18] the thing with that is that it's not easy for everyone to self-host [20:47:23] man, I gotta sleep soon but I imagine there's gonna be 500+ messages when I'll wake up lol [20:47:32] Same here... [20:47:36] Special:CentralNotice? [20:47:40] Not like you're gonna miss much tbf [20:47:48] Yep, reduce stress for SRE is very important [20:47:56] Phabricator is separate from CentralNotice [20:47:58] I've never seen the server this active since a few days ago [20:48:00] Bu reklamı Bence CentralNotice'de daha fazla yayınlayabiliriz. [20:48:11] Ay, turkish) [20:48:13] well it seems negative press attracts more people than positive... [20:48:25] I think we can post this ad more on CentralNotice. [20:49:12] I did say before "Self hosting is good if you have the skills/money" [20:49:46] Either way, it has not come to pass yet the times-to-time are not set in stone. [20:49:48] [[phab:]] It's not a very active place. It will be useful to write in CentralNotice, because there is no developer [20:49:48] https://meta.miraheze.org/wiki/phab: [20:49:49] [20:50:15] I kinda wonder what the Tarot would say [20:50:29] It's crazy how much has changed in the past few months; only four months ago, I was a new wiki creator and it seemed like Miraheze was stable and had the potential to last forever; now, there's a severe shortage of volunteers and people are talking about Miraheze collapsing, but at least I have more experience as a wiki creator [20:51:04] And, in Miraheze, the recession got a lot worse. it is imperative that we reduce the stagnation, that Miraheze is introduced to the world (Conference etc.) [20:51:07] [1/2] As someone who is the only bridge between the wiki of a community I'm part of and Mira Meta, I've got to say that all that the constant arguing in circles does for those of us who don't have a horse in the "race" is kill hopes that either Miraheze or the new splinter websites are gonna make it long-term. It just makes everyone look like a-ho [20:51:07] [2/2] les. [20:51:21] I was thinking of holding a conference. [20:51:56] Maybe things will get better. The times-to-come are not set in stone [20:52:30] Any chance to learn code and join SRE? [20:52:32] Well, the issue is most of the issue lies in things that have been issues for years now, and they are just now coming to light in full force, so its hard for people who havent been around for multiple years to fully grasp whats going on [20:53:01] Even having visual studio code helps Miraheze develop further, Vsc because it suggests code. [20:53:13] I only know some CSS sorry [20:53:16] I know a decent amount of CSS and a little bit of JavaScript, but not enough to be an SRE member [20:53:41] Ponder, freelancers [20:54:10] I know there are free PHP code tutorials on youtube. (JS and Css are also required of course) [20:54:17] me and SQL don't go well together [20:54:19] I know a cople of places where low low budget freelancer hiring is possable [20:54:26] Kind of why these kinds of discussions shouldn't be happening live in #general [20:54:45] I took Miraheze down with bad SQL, don't worry 🙂 [20:55:38] Sadly, thats really the only place they could occur, some of us have exhausted other avenues [20:55:45] I once took down the entire bank system accidentally starting a very performance heavy task while another person was creating a heavy dump for another system [20:56:09] Haha! [20:56:23] Maybe I didn't try hard enough but I have asked if there was anyone who was interested in joining SRE many times before. It's definitely not a problem that started now but now it's just way worse [20:57:42] Yeah we've been unable to recruit for years [20:57:52] We've just had numbers until this last week [20:57:55] If everyone here had medium-high PHP, JS, and CSS code knowledge, everyone would be a member of SRE. [20:58:00] Uhhhh I’m not sure what you expect when volunteers have to run the place without being paid [20:58:13] but not enough money, knowledge, VSC [20:58:35] Not at all. It takes much more than that I'm afraid [20:58:36] It’s like a no shit situation that it’s not a very attractive thing especially as we don’t have a lot of funds so don’t have a lot to spend on servers. And our traffic is growing putting strain on the servers [20:58:59] But yes obviously it's not attractive to many [20:59:20] What else? [21:00:06] Well first of all knowing mediawiki, Linux command line, how things work at Miraheze [21:00:14] You have to spend your life for more. [21:00:16] Well, may be some Freelancer that would do it for a CV [21:00:20] SQL, Linux knowledge is also good to have knowlodge of [21:00:32] I think MH is fine as it stands. There are server issues but [21:00:41] Yeah I forgot SQL as well [21:00:56] But a newcomer can't simply come either, there also needs to be a level of trust [21:01:53] The ideal case would be many volunteers each doing a little bit (since people obviously have IRL commitments) but the actual situation is and has been a few people having to do a lot [21:02:18] The problem is it requires people working for free [21:02:19] https://meta.miraheze.org/wiki/Miraheze_Vacancies has more information about each role and what skills are needed [21:02:54] Then there’s the fact that there’s not much you can really do with the servers because of costs. There’s bad performance sometime with loading pages. [21:05:22] Hmmm, I wondered why the servers was so slow [21:05:42] Well we have limited funds but like 200k visits per day [21:06:26] Will you remember me? [21:10:38] Sure, you have a very unique authorship model, it was neat getting to here more about how your community/circle of authors operated. [21:11:45] Thank you... [21:17:28] Read https://rhinosf1.com/miraheze [21:18:56] Hmmmm. I kinda wonder if putting out volunteer jobs on a cople of freelancring servers I am in would help [21:19:14] I can DM the servers if you think it could help [21:56:07] well, good night [21:56:37] G'night [22:41:36] Ending slow mode, thanks all. [23:01:30] Well, to save server resources, we have a poll at ATTwiki to remove Visual Editor. It's been up a couple days and so far it's unanimous to remove it. [23:16:23] That wouldn’t be using any resources. VS uses the built in parser thing in MW [23:16:37] Doesn’t require its own service anymore (which we got rid of) [23:16:59] Don't try to dissuade me with facts. We're helping! [23:17:45] We are looking at other extensions though. Is there a way to see how many people are using a skin? [23:18:38] Not particularly [23:38:17] [1/2] this would do it: [23:38:17] [2/2] > SELECT up_value, count(up_value) FROM user_properties left join user ON up_user = user_id WHERE up_property = 'skin' and user_touched > '20220000000000' GROUP BY up_value; [23:39:02] ... assuming user_touched is updated by central auth. hm.