Category talk:WelcomeBotResearch

From Wikipedia, the free encyclopedia

You have new messages (last change).

Please sign below if interested in helping out. Thanks.

  1. frummer 08:03, 29 December 2006 (UTC)
  2. --TeckWizTalkContribs@ 23:22, 30 December 2006 (UTC)
  3. Just H 03:13, 31 December 2006 (UTC) curious on the stats.
  4. Queezbo, a.k.a.  Sean Lotz  talk  03:30, 31 December 2006 (UTC)
  5. Hagerman(talk) 06:00, 1 January 2007 (UTC)
  6. Tlim7882 (talk • contribs • count) 10:10, March 31, 2007 (UTC)
  7. ElectricEye (talk) 17:04, 8 January 2007 (UTC)
  8. theblueflamingoSpeak 21:57, 11 January 2007 (UTC) I greet users anyway, and if people are going to use the info, then I'll gladly use it.
  9. Navou banter 00:49, 4 February 2007 (UTC)
  10. -- Piotr Konieczny aka Prokonsul Piotrus | talk  18:06, 28 February 2007 (UTC)

Contents

[edit] cooperating... sort of

Hello. I was asked to use the Welcome123 template. But I really like my own welcome message. So I added the category WelcomeBotResearch to it, along with info about "Adoptme." Now, I know that means that my welcome template will show up on the list on the category page. That might be annoying. BUT, it will be at the end of the list, after all the user talk pages, so it should not confuse things too much, I think. If this is a problem, let me know on my talk page and I will change what I am doing.  Sean Lotz  talk  03:03, 31 December 2006 (UTC)

It's not a problem. However, there is a simple solution - put the category inside <includeonly>/</includeonly> tags. Eli Falk 11:39, 7 February 2007 (UTC)

[edit] Collecting Data

I'm going to write an IRC bot tomorrow that will cache live data from the Wikipedia IRC Recent Changes channel into a local SQL database. Just from storing information from that channel, we'll be able to determine:

  • Did the user contribute at all
  • Did the user continue contributing after a week.
  • Did the user become blocked.
  • Did the user create a user page.

The remaining 3 points of interest could be determined by pulling diffs from Wikipedia, however, it would have to go through the bot approval process. As a result, I'll initially create an application that tracks the four points listed above. If that proves to be useful, I'll proceed to request permission for a non-editing bot, which will probably be speedily approved.

I'll create a web interface that you will be able to use to run queries on the data the bot has collected. Perhaps we can use the web interface to list the users that should be welcomed? For instance, you could run a query that shows all users that have...

  • not been welcomed,
  • not been blocked,
  • been a member for at least a week,
  • and made more than 10 contributions.

You could adjust the various parameters that you search by and store the query for later use. Then you would be able to click on each of the users in the list to jump to the edit screen for their talk page. Any feedback?

Best, Hagerman(talk) 06:20, 1 January 2007 (UTC)

Update: The IRC bot is live and has begun storing data into my local MySQL server. I have begun writing a front-end to the database which should be ready to go later this evening. For advanced users, I've created a MySQL user account with SELECT permissions to the database. Feel free to run whatever kind of queries you'd like as often as you'd like. The database can be accessed at:
Host: WIKISOAP.COM (72.185.243.180)
Port: 3306
Username: welcome
Password: guest
Database: welcome
A brief overview of the schema...
USERS TABLE Stores the users that have been created and caches some numerical counts for easier querying.
USER_ID: Local ID number assigned to the user when the account was created.
USERNAME: The username registered by the user on Wikipedia.
CREATED_DTM: The time the user's account was created (in GMT -5:00).
ACTION_DTM: The time the user last created or edited a page (in GMT -5:00).
USERPAGE_EXISTS: Does the user have a user page? (0 = NO; 1 = YES).
USERTALKPAGE_EXISTS: Does the user have a talk page? (0 = NO; 1 = YES).
NEWPAGE_COUNT: The number of times the user has created an article.
EDITPAGE_COUNT: The number of times the user has edited an article.
BLOCK_EXISTS: Is the user currently blocked? (0 = NO; 1 = YES).
BLOCK_COUNT: The number of times the user has been blocked.
BLOCKS TABLE Stores records on the user's block history.
USER_ID: Local ID number assigned to the user when the account was created.
STATUS: In this record was the user blocked (1) or unblocked (0)?
ACTION_DTM: The time the action was performed (in GMT -5:00).
EDITS TABLE Stores records on the user's edit history.
USER_ID: Local ID number assigned to the user when the account was created.
ARTICLE: The name of the article that was edited.
ACTION_DTM: The time the action was performed (in GMT -5:00).
NEW TABLE Stores records on the user's page creation history.
USER_ID: Local ID number assigned to the user when the account was created.
ARTICLE: The name of the article that was created.
ACTION_DTM: The time the action was performed (in GMT -5:00).
Please let me know if you encounter any problems. I'll post another update as soon as the web interface is ready to go. Best, Hagerman(talk) 22:22, 1 January 2007 (UTC)
Wow. I doubt I will be taking advantage of this info directly any time soon, but I want to say Thanks for your work. This should prove very interesting indeed.  Sean Lotz  talk  03:19, 2 January 2007 (UTC)
Likewise. It's impressive, but I have no clue what you just said. Just H 20:58, 3 January 2007 (UTC)

[edit] WelcomeBOT

I just received a visit from someone or somebot that put a whole load of junk on my User:discussions page. It might be great for some who are completely new to this but is it really necessary? Maybe a little clause at the bottom saying its been placed there by a bot and somebot won't be offended if you revert everything?--Shakujo 06:01, 31 January 2007 (UTC)

Your welcome was added by a user, not a bot. The Category:WelcomeBotResearch is automatically added to the welcoming template on user talk pages. Nishkid64 02:23, 4 February 2007 (UTC)
You misunderstood. I think you need to make it explicitly clear that things were added by an automated program (new users won't necessarily know what a bot is) and that if said user so wishes these are the steps to remove such additions.--Shakujo 01:10, 5 February 2007 (UTC)
They aren't added by a bot though. User's posts these messages for new people. I believe this category is to see if having a bot welcome people would be useful. However, real people post messages as of now. --TeckWizParlateContribs@ 01:15, 5 February 2007 (UTC)
You can see who put the message, or any message, on your page by checking the edit history of that page. Xiner (talk, email) 21:12, 14 February 2007 (UTC)
the research is yeilding very important information, we are from drawing the conclusion of our efforts as of now. we're waiting for hagerman to come back in. frummer 08:56, 23 February 2007 (UTC)

[edit] Any stats yet?

I got a nice welcome page on my user talk page. It's got all the links I need, and some I didn't know about, and they're all in one handy place. So thanks for that.

Have you got any stats yet? I'd be interested to know how many new users get the welcome page, and how many new users make more than X edits (where x is a number of your choice.)

Kind Regards. DanBeale 11:27, 6 March 2007 (UTC)

[edit] Categorising user talk pages

As the category presumably has to be on the user's talk page or the whole thing won't work, you need to bear in mind that you're adding it to the talk pages of very new users. As it's transcluded from the welcome template, it doesn't appear in the talk page history. So when one clicks on the category, there needs to be a very clear explanation of what the category's for, and where they can find out more (ie, this talk page). It took me a few minutes to find out this is where autocategorising every new user (a terrible idea) had been "decided". Neil (not Proto ►) 07:22, 11 March 2007 (UTC)

[edit] My welcome template

May I place users welcomed by User:Od Mishehu/welcome in this category? If not, how should I change it so I can? Od Mishehu 11:06, 20 March 2007 (UTC)

Retrieved from "http://en.wikipedia.org../../../w/e/l/Category_talk%7EWelcomeBotResearch_a3f9.html"