[13:25:23] [telegram] https://tools-static.wmflabs.org/bridgebot/ef12c0b4/file_13493_oga.ogg [16:33:03] [telegram] Hello to everyone in here! [16:35:08] [telegram] Hey! (re @Antoni: Hello to everyone in here!) [16:39:38] [telegram] Hello Abdul! a bit of introduction, My name is Antoni Mtavangu from Wikimedia community user group Tanzania. Nice to connect with you all here! (re @abdulmalikkambarov: Hey!) [16:56:08] [telegram] Hello to everyone, [16:56:09] [telegram] I'm Georges from Wikimedia Cameroon. [16:59:08] [telegram] Hi again, greetings from Wikimedians of the Uzbek language User Group! :) (re @Antoni: Hello Abdul! a bit of introduction, My name is Antoni Mtavangu from Wikimedia community user group Tanzania. Nice to connect wit...) [16:59:32] [telegram] That's nice to hear! ))) (re @Geugeor: Hello to everyone, [16:59:33] [telegram] I'm Georges from Wikimedia Cameroon.) [17:44:27] [telegram] wow..nice to connect with you from Uzbek Language User Group! (re @abdulmalikkambarov: Hi again, greetings from Wikimedians of the Uzbek language User Group! :)) [17:44:39] [telegram] Hello Wikimedians, [17:44:40] [telegram] [17:44:42] [telegram] I am writing in the capacity as a Product Ambassador on behalf of the Campaigns Team at the Wikimedia Foundation. [17:44:43] [telegram] [17:44:45] [telegram] The Wikimedia Foundation Campaigns team focuses on building and improving tools for campaign organizers and participants. We want to make sure it is easier for everyone to organize campaigns, such as Art+Feminism or Wiki Loves Africa, and that it is easier to have a rewarding experience as a participant. We will be making some changes, and we would love to hear your feedback! [17:44:46] [telegram] [17:44:48] [telegram] First project: Event registration: We are currently working on creating an event registration system, so you can easily register participants on-wiki event pages. This system would be integrated with the Programs and Events Dashboard. Please check out thehttps://meta.wikimedia.org/wiki/Campaigns/Fouhttps://meta.wikimedia.org/wiki/Talk:Campaigns/Fohttps://meta.wikimedia.org/wiki/User:AMtavangu_(WMF)t_Team/Registr [17:44:49] [telegram] Antonihttps://meta.wikimedia.org/wiki/Campaigns/Foundation_Prohttps://wikimediafoundation.org/s : Product Ambassador for the Swahili community [17:44:51] [telegram] M. Bachounda : Product Ambassador for the Arabic community [17:44:52] [telegram] Georges Fodouop : Product Ambassador for the French Community [17:44:54] [telegram] If you want to learn more about the team and its projects, please subscribe to our newsletter! [17:44:55] [telegram] [17:44:57] [telegram] Thank you! [17:44:58] [telegram] Antoni Mtavangu -(on behalf of) [17:45:00] [telegram] Campaigns team, Wikimedia Foundation. [20:18:47] [telegram] https://en.wikipedia.org/w/api.php?action=query&format=json&list=usercontribs&ucuser=Jimbo%20Wales [20:18:48] [telegram] How to get from this link api [20:18:49] [telegram] Adds or remove characters of each page? [21:03:23] [telegram] And [21:03:24] [telegram] What is revid? [21:03:25] [telegram] What is parentid? (re @M: https://en.wikipedia.org/w/api.php?action=query&format=json&list=usercontribs&ucuser=Jimbo%20Wales [21:03:27] [telegram] How to get from this link ap...) [21:43:50] [telegram] revid is revision id [21:44:00] [telegram] parent id is revid of the previous revision [21:46:06] [telegram] you can ad ucprop sizediff for that (re @M: https://en.wikipedia.org/w/api.php?action=query&format=json&list=usercontribs&ucuser=Jimbo%20Wales [21:46:07] [telegram] How to get from this link ap...) [21:46:18] [telegram] https://tools-static.wmflabs.org/bridgebot/6433618e/file_13518.jpg [21:49:06] [telegram] https://fa.wikipedia.org/wiki/ویژه:آزمایش_رابط_برنامه‌نویسی#action=query&format=json&list=usercontribs&utf8=1&ucuser=Jimbo Wales&ucprop=ids|title|timestamp|comment|size|flags|sizediff [22:10:07] [telegram] Thanks bohdan dear [22:10:09] [telegram] But sizediff doesn't give: [22:10:10] [telegram] old len [22:10:12] [telegram] new len [22:10:13] [telegram] What i do? (re @Thecladis: you can add ucprop sizediff for that) [22:10:51] [telegram] I want old len character [22:10:52] [telegram] And new len character [22:25:20] [telegram] well take size and subtract sizediff [22:25:36] [telegram] unless parent id is 0 [22:29:20] [telegram] I think be very complex (re @Thecladis: unless parent id is 0) [22:30:27] [telegram] Because revisions are too many [22:30:53] [telegram] huh? (re @M: Because revisions are too many) [22:31:56] [telegram] why complex? if parent id is 0 this means that it is a revision that creates the page, so there is no previous size. (re @M: I think be very complex) [22:32:41] [telegram] as to the amount of revisions it should not matter, obviously you will be doing it in a for loop or something [22:35:57] [telegram] Because there are many different page [22:35:58] [telegram] And i should seperate one by one page that that's rev id be for special page (re @Thecladis: why complex? if parent id is 0 this means that it is a revision that creates the page, so there is no previous size.) [22:37:02] [telegram] define "special page" [22:37:47] [telegram] I mean is Not special page in mediawiki (re @jeremy_b: define "special page") [22:38:27] [telegram] well, if API does not suite your needs it might be that writing a custom SQL query is a better idea, but in the end it depends on what you want to achieve and what you are comfortable working with (re @M: Because there are many different page [22:38:28] [telegram] And i should seperate one by one page that that's rev id be for special page) [22:38:48] [telegram] one cannot edit a special page, so you won't see them in contributions (re @M: I mean is Not special page in mediawiki) [22:39:23] [telegram] and anyway the page ID is negative right? (re @Thecladis: one cannot edit a special page, so you won't see them in contributions) [22:39:58] [telegram] for what? special pages? no idea out the top of my head [22:40:13] [telegram] Please give me sql text for this and functions (re @Thecladis: well, if API does not suite your needs it might be that writing a custom SQL query is a better idea, but in the end it depends o...) [22:40:18] [telegram] but I couldn't tell if special meant Mediawiki special page or a was just used as an adjective. [22:40:32] [telegram] yes. I'm pretty sure (re @Thecladis: for what? special pages? no idea out the top of my head) [22:41:36] [telegram] there is a non-zero chance that I might be in the mood of writing it later, but I cannot give you a promise. Please try to write it yourself at [[quarry😏] (re @M: Please give me sql text for this and functions) [22:41:45] [telegram] meh [22:41:52] [telegram] NS_SPECIAL is -1, so special pages can sometimes be considered to be in a negative namespace (probably depends on which parts of the code you ask); I don’t think anything assigns them a page ID though [22:42:01] [telegram] quarry.wmcloud.org/ (re @Thecladis: there is a non-zero chance that I might be in the mood of writing it later, but I cannot give you a promise. Please try to write...) [22:42:35] [telegram] well, ns wise sure, just like Media is -2… (re @lucaswerkmeister: NS_SPECIAL is -1, so special pages can sometimes be considered to be in a negative namespace (probably depends on which parts of...) [22:42:39] [telegram] ohhhh NS not page ID. ooops :-) (re @lucaswerkmeister: NS_SPECIAL is -1, so special pages can sometimes be considered to be in a negative namespace (probably depends on which parts of...) [22:42:51] [telegram] How do i learn sql in mediawiki? (re @Thecladis: there is a non-zero chance that I might be in the mood of writing it later, but I cannot give you a promise. Please try to write...) [22:43:16] [telegram] There is documents? [22:43:42] [telegram] well basically you learn sql and apply it to mediawiki. at Quarry at the top there is "Database tables" link that references the necessary documentation about the tables MediaWiki uses [22:44:08] [telegram] what I recommend just select a single row from each of the tables of interest and see what it contains [22:44:32] [telegram] as to learning SQL, well, something basic like https://www.w3schools.com/sql/ is a good start [22:44:40] [telegram] I don't know structure of mediawiki database and tables and fields (re @Thecladis: well basically you learn sql and apply it to mediawiki. at Quarry at the top there is "Database tables" link that references the...) [22:45:06] [telegram] yes, that is exactly why I have told you where to find the relevant documentation [22:45:32] [telegram] https://tools-static.wmflabs.org/bridgebot/52eb57ef/file_13530.jpg [22:46:21] [telegram] 🙏🙏 thanks [22:46:22] [telegram] But if there is api very good (re @Thecladis: yes, that is exactly why I have told you where to find the relevant documentation) [22:48:24] [telegram] well the task that you seem to want to achieve can be done by using either API or SQL, it is just that in case of API you need to write some code that will do some post processing, while in case of SQL it might be possible to tailor output that would already have all the data you need. That said that will probably take the same amount of work [22:50:11] [telegram] 👍👍🙏 (re @Thecladis: well the task that you seem to want to achieve can be done by using either API or SQL, it is just that in case of API you need t...) [22:52:05] [telegram] I'm still unclear what the task is. just make a list of revs and sizes? (re @Thecladis: well the task that you seem to want to achieve can be done by using either API or SQL, it is just that in case of API you need t...) [22:52:57] [telegram] well it seems so, though he also wants to group them by pages I think [22:53:27] [telegram] but I am only guessing in what direction he is moving, no clear idea myself [22:59:00] [telegram] I found this api [22:59:01] [telegram] https://m.mediawiki.org/wiki/API:RecentChanges [22:59:03] [telegram] This is like as before api? (re @Thecladis: well it seems so, though he also wants to group them by pages I think) [23:04:20] [telegram] well it is an api that shows recent changes, the previous one was showing user's contributions [23:05:09] [telegram] I set username and given list of user (re @Thecladis: well it is an api that shows recent changes, the previous one was showing user's contributions) [23:06:30] [telegram] rcuser [23:07:55] [telegram] For get changes of character of page [23:07:57] [telegram] This api is better or before? (re @Thecladis: well it is an api that shows recent changes, the previous one was showing user's contributions) [23:10:13] [telegram] it depends on what you need. recent changes only contains the last 90 or so days [23:10:24] [telegram] so if you need all user's edits it won't have them [23:11:09] [telegram] 🙏 thanks (re @Thecladis: so if you need all user's edits it won't have them)