Jump to content

User talk:Cryptic/archive-13

Page contents not supported in other languages.
From Wikipedia, the free encyclopedia

This is an old revision of this page, as edited by Levivich (talk | contribs) at 02:02, 19 May 2019 (BLP counts: Replying to Cryptic (using reply-link)). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.


rollback script

Hi Cryptic, just saw your message about this. I'm not sure where to put it. I put it in my common.css but it didn't seem to do anything. I don't know of my .js stuff can interfere - that's a bit of a mess but I just put up with the error messages now. Thanks. Doug Weller talk 15:01, 4 January 2019 (UTC)[reply]

I don't see anything in your common.js that would interfere. The css will only affect rollback links added by Mediawiki itself, so it won't do anything about ones added by Twinkle. Twinkle might interfere with the Mediawiki ones, too - I don't use it, so can't be sure. —Cryptic 15:16, 4 January 2019 (UTC)[reply]
I misunderstood the discussion. I like having the rollback link in my watchlist as it shows me if an edit is the latest edit. Unless there's something else that will do the same thing, which wouldn't surprise me, I'd rather take the risk of accidental rollback. Thanks for the quick reply. Doug Weller talk 15:38, 4 January 2019 (UTC)[reply]

Deletion of Klassroom.

Dear Cryptic, you have deleted the page Klassroom citing no reliable source and not of importance (A.7)

However the wiki page has multiple sources including news articles and is also a affiliated educational institute which is exempt from section A.7

Requesting you to kindly republish the page or provide guidance as to how can it be restored. Thanks! — Preceding unsigned comment added by Nadude (talkcontribs) 10:03, 5 January 2019 (UTC)[reply]

It had routine announcements that it was seeking funding. Those are not news articles in any reasonable sense, and they verified almost nothing in the article. It's also not an educational institution in any sense. See WP:CORP for our inclusion criteria. —Cryptic 11:01, 5 January 2019 (UTC)[reply]

Dear Cryptic,

All the given links are of news portals, and facts auch as number of centers, financial holding structure of the company, list of investors has bene provided in those articles. While the headline of the news article suggests about fund raising, the same wasn't mentioned anywhere in the wiki article. In fact all the facts and figures quoted on the wiki page have been memtioned clearly in the news articles, which were used as citations.

Kindly assist in page restoration.

Thanks! — Preceding unsigned comment added by Nadude (talkcontribs) 18:18, 5 January 2019 (UTC)[reply]

I'm not going to restore this. Your avenue of appeal is WP:Deletion review. —Cryptic 13:45, 7 January 2019 (UTC)[reply]

Polyisobutene listed at Redirects for discussion

An editor has asked for a discussion to address the redirect Polyisobutene. Since you had some involvement with the Polyisobutene redirect, you might want to participate in the redirect discussion if you have not already done so. Thryduulf (talk) 14:43, 6 January 2019 (UTC)[reply]

your assistance please...

Erica Procunier is an alumnus of the Canadian Film Centre's prestigious residency program.

I request userification of Erica Procunier, an expired {{prod}} you deleted. If, after an examination I don't think an article is likely, I'll speedy delete the userified version.

Thanks! Geo Swan (talk) 19:28, 8 January 2019 (UTC)[reply]

Entire content was '''Erica Procunier''' is a [[Canada|Canadian]] film and television composer.<ref>{{Cite web|url = http://www.imdb.com/name/nm2421501/?ref_=fn_al_nm_1}}</ref> She has composed for [[And Now a Word from Our Sponsor]]. External links to www.ericaprocunier.com, IMDB again, and cfccreates.com/alumni/658. Want the categories? —Cryptic 20:33, 8 January 2019 (UTC)[reply]

Deletion of Jq_(programming_language)

I can't understand this deletion. Wikipedia has lost the page for the open source language JQ. Jordinas (talk) 07:11, 22 January 2019 (UTC)[reply]

@Jordinas: (talk page stalker) FYI the reason was Expired PROD, concern was: The only reference is primary, as are all external links. No indication that this is more than a personal project. Article was created by Jordinas, whose contributions all involve adding links to jq from other pages; COI likely.. ([https://en.wikipedia.org/w/index.php?title=Special:Log&logid=96412147 deletion log). If you do indeed have a COI, I suggest declaring it. If you intend to recreate the page, I would also suggest submitting it to AfC rather than creating it in mainspace. Just my 2 cents. If you are just someone who codes in Jq and wanted to right about it, then feel free to disregard. --DannyS712 (talk) 07:15, 22 January 2019 (UTC)[reply]

Hi, the jq language was, indeed, at one time very much a personal project of [[1]|Stephen Dolan], however, it isn't just a personal project any longer, and I don't see why it should matter if it was anyways, as jq is a very popular language. jq has two current maintainers not the original author, and has had quite a few [[2]|contributors]. jq is ranked at #46 on the [[3]|Rosetta Code rankings], for whatever that is worth. The fact that jq continues to be hosted at a personal repository on GitHub is hardly important, as it is trivial to create an organization for a personal project -- the complaint here appears to be purely about style, that the homepage being on a personal GitHub is somehow bad. As to COI, I don't see it. Was it Stephen Dolan who created it? I don't know who [[User:Jordinas]|Jordinas] is, but, if it is the GitHub user [[4]|fadado], then that is just a fan of the language. FWIW, [[User:Cryptonector]|I] am one of the current maintainers of jq, which you can see by looking at the commit history. — Preceding unsigned comment added by Cryptonector (talkcontribs) 23:41, 23 January 2019 (UTC)[reply]

A barnstar for you!

The Technical Barnstar
For this answer. Not a hard thing to answer if you know it, but that's something that's going to be super, super helpful to me in the future. Headbomb {t · c · p · b} 21:47, 4 February 2019 (UTC)[reply]

90.224.198.15

Could you please revoke talkpage access from user:90.224.198.15 . CLCStudent (talk) 20:13, 5 February 2019 (UTC)[reply]

ArbCom

Yes, bingo, many thanks! GiantSnowman 11:40, 6 February 2019 (UTC)[reply]

NPP Query

Can you kindly write a query about retrieving the following data:-

  • I would wish to see the the date of flag-removal and the reason behind it, (as indicated in the log).
  • I would be also interested in knowing the date of perm-grant and the reason; for doing so.
  • All the users who are currently indefinitely blocked and/or globally locked but have the NPP flag. Additionally, the date and the block-reasons or lock-reasons.

Thanks! WBGconverse 19:02, 6 February 2019 (UTC)[reply]

quarry:query/33247 for the first three bullets. This is only accurate for grants/revocations in November 2012 or later, when the log format changed; I don't remember offhand when the patroller group was added, but I think it was well after that. Also doesn't account for promotions to sysop, so there's probably false positives.
I haven't looked into how locked users are represented in the db before, so that'll be later. —Cryptic 02:37, 7 February 2019 (UTC)[reply]

Blocked patrollers are at quarry:query/33250. quarry:query/33249 shows there's no globally-locked users with NPP on enwiki. If there were, you could get the lock log with something like

SELECT /*...other stuff...*/, log_timestamp, log_user_text, log_params, comment_text
/*...*/
JOIN metawiki_p.logging_logindex
	ON log_title = CONCAT(/* user_name from user_groups join user query */, '@global');
JOIN metawiki_p.comment
	ON log_comment_id = comment_id
WHERE log_type='globalauth'
	AND log_action='setstatus'
	AND log_params LIKE '%lock%'

though, really, there's never going to be more than one at a time, and that only if someone were really remiss, and it'd be easier to go to meta and search the logs directly. —Cryptic 04:33, 7 February 2019 (UTC)[reply]

Thank you for being so fast and so efficient:-) Your help is appreciated! WBGconverse 12:39, 8 February 2019 (UTC)[reply]

Arbitration

Hi Cryptic, Can you please advise me how to close the arbitration case for Future.perf? Thanks in advance - Stevepeterson (talk) 02:26, 25 February 2019 (UTC)[reply]

@Stevepeterson: Better that you don't try yourself; the arbitrators are a bit territorial. Just add something like "I withdraw this request." to the end of your statement. —Cryptic 02:47, 25 February 2019 (UTC)[reply]
Never mind, I see you've already done so. Just give it some time. —Cryptic 02:51, 25 February 2019 (UTC)[reply]
Great , thank you so much. Stevepeterson (talk) 03:08, 25 February 2019 (UTC)[reply]

Mike Bailey (wrestler)

Hi,

I contacted Kurykh on 02/14 and he is not active. Can you help me please (if not just say : NO but I just want an answer).

--Sismarinho (talk) 15:10, 1 March 2019 (UTC)[reply]

No, I can't; admins don't have the authority to just undelete articles deleted at AFD on their own say-so. You need to take this to WP:Deletion review. —Cryptic 22:11, 1 March 2019 (UTC)[reply]
I'll consider that you don't want to help me. I'm french, I dont don't know what I must do and your answer will not help me. I stop thixs message now because I'm anger against you.--Sismarinho (talk) 09:20, 2 March 2019 (UTC)[reply]

Restoration of wiki page Matthew Tee Kai Woon

Dear Cryptic, I want to help fix the page for 'Matthew Tee Kai Woon' it seems like it had citation, reference, copy paste issues. I believe I can fix these issues and resubmit it to you for your consideration. Hoping for a positive reply from your side. Regards, Mansoor Mansooriqbalnagori (talk) 07:52, 5 March 2019 (UTC)[reply]

The article was deleted as a copyright violation. It can't be restored and fixed iteratively; you have to start a new article from scratch (for which you don't need my permission). —Cryptic 08:58, 5 March 2019 (UTC)[reply]

Thanks for prompt reply. Mansooriqbalnagori (talk) 09:03, 5 March 2019 (UTC)[reply]

why do you think this page should be deleted? — Preceding unsigned comment added by Dudeboy7 (talkcontribs) 08:46, 7 March 2019 (UTC)[reply]

The previous version I deleted a year ago, or the revisions I hid today? —Cryptic 11:04, 7 March 2019 (UTC)[reply]

Thank you. 2601:188:180:1481:65F5:930C:B0B2:CD63 (talk) 15:47, 7 April 2019 (UTC)[reply]

Flagging a sandbox that may be of interest to you, related to your deletion of Zcode. — billinghurst sDrewth 23:45, 17 April 2019 (UTC)[reply]

Hi, there's already a draft for this article. Please check if it passes AFC. Thanks. Draft:Love You Two

Rama Arbitration Case

You were recently listed as a party to a request for arbitration. The Arbitration Committee has accepted that request for arbitration and an arbitration case has been opened at Wikipedia:Arbitration/Requests/Case/Rama. Evidence that you wish the arbitrators to consider should be added to the evidence subpage, at Wikipedia:Arbitration/Requests/Case/Rama/Evidence. Please add your evidence by May 10, 2019, which is when the evidence phase closes. You can also contribute to the case workshop subpage, Wikipedia:Arbitration/Requests/Case/Rama/Workshop. For a guide to the arbitration process, see Wikipedia:Arbitration/Guide to arbitration. For the Arbitration Committee, -- Amanda (aka DQ) 19:41, 2 May 2019 (UTC)[reply]

Delivered by: MediaWiki message delivery (talk) 19:41, 2 May 2019 (UTC)[reply]

Previous listing as a party

My apologies for the above section stating that you are a party. You are not, I made a mistake with the template. -- Amanda (aka DQ) 19:51, 2 May 2019 (UTC)[reply]

ArbCom 2019 special circular

Icon of a white exclamation mark within a black triangle
Administrators must secure their accounts

The Arbitration Committee may require a new RfA if your account is compromised.

View additional information

This message was sent to all administrators following a recent motion. Thank you for your attention. For the Arbitration Committee, Cameron11598 03:02, 4 May 2019 (UTC) Template:Z152[reply]

Is it possible for me to get a userspace copy of this deleted article? This subject came up in dinner conversation recently and I was surprised that he did not have an article. A quick news search leads me to believe there's a strong case for notability. ~Kvng (talk) 18:26, 4 May 2019 (UTC)[reply]

No better than the draft version. Full text (by Studs88) was: —Cryptic 02:36, 6 May 2019 (UTC)[reply]
Jay Shetty is a public speaker who gives motivational speeches to several corporate, educational and charity institutions.He lives in London,work for Accenture company as Digital Strategy, Innovation & Social Branding + Meditation/Lifestyle Coach.He is an active member of his local temple and organizes festivals attended by over 60,000 people.He also coaches corporate individuals in mindfulness and was invited to coach 1000 consultants at Twickenham Rugby Stadium in 2014.He had organised food distribution programs and Sewa Day initiatives[1].
  1. ^ "Jay Shetty | Asian Professional Awards". www.theprofessionalawards.com. Retrieved 2016-03-31.

Administrator account security (Correction to Arbcom 2019 special circular)

ArbCom would like to apologise and correct our previous mass message in light of the response from the community.

Since November 2018, six administrator accounts have been compromised and temporarily desysopped. In an effort to help improve account security, our intention was to remind administrators of existing policies on account security — that they are required to "have strong passwords and follow appropriate personal security practices." We have updated our procedures to ensure that we enforce these policies more strictly in the future. The policies themselves have not changed. In particular, two-factor authentication remains an optional means of adding extra security to your account. The choice not to enable 2FA will not be considered when deciding to restore sysop privileges to administrator accounts that were compromised.

We are sorry for the wording of our previous message, which did not accurately convey this, and deeply regret the tone in which it was delivered.

For the Arbitration Committee, -Cameron11598 21:03, 4 May 2019 (UTC) Template:Z83[reply]

BLP counts

Hi Cryptic. I forked your queries [5] [6] and I was wondering if you had a moment to look them over and let me know if I'm "doing it right", or missing anything, and whether you think these numbers are "real" (accurate)?

Thanks! Levivich 06:01, 17 May 2019 (UTC)[reply]

Nothing wrong with the queries per se (the ones I spot-checked, anyway). Checking for infoboxes happens to work very well for footballers, since both players and managers use the same infobox, and the infobox is very consistently used. I have no idea how consistently the other infoboxes you're checking for are used, though - you may be better off looking for category intersections, for which Petscan is the tool of choice. If nothing else, it should provide a useful crosscheck. —Cryptic 10:06, 17 May 2019 (UTC)[reply]
Thanks for the response and spot-checking. Petscan seems to crap out for Category:Living people (large categories?), and I can't figure out how to do category intersections on Quarry, or how to search for categories and subcategories. E.g., Living people+Office-holders. The quarry documentation and example scripts don't seem to have the answer. Is there's a help file somewhere I should RTFM? Should I post on RAQ? Thanks again. Levivich 22:14, 18 May 2019 (UTC)[reply]
Direct category intersections are easy - you'd do something like
SELECT COUNT(*)
FROM page
JOIN categorylinks c1
    ON c1.cl_from = page_id
JOIN categorylinks c2
    ON c2.cl_from = page_id
WHERE c1.cl_to = 'Living_people'
    AND c2.cl_to = 'Office_holders';
(and maybe add a "AND page_namespace = 0" to limit it to mainspace pages, though there should only be mainspace pages in Category:Living people anyway).
Subcategories are less straightforward, and if there's an efficient way to do it besides either enumerating the subcategories manually (like "AND c2.cl_to IN ('Subcategory_name_1', 'Subcategory_name_2', 'Subcategory_name_3')") or doing a text match on them (like "AND c2.cl_to LIKE '%_politicians'"), then I don't know it.
The quarry documentation and other query examples on meta mostly assume that you already know SQL and just aren't familiar with the Mediawiki database schema, so there's no FM I'm aware of for you to R to get better specifically at Wikipedia queries. WP:RAQ is reasonably well-watched by knowledgeable folks despite being underutilized; posting there's a good idea. —Cryptic 01:49, 19 May 2019 (UTC)[reply]
Thank you, that's very helpful! --Levivich 02:02, 19 May 2019 (UTC)[reply]