| Index: trunk/tools/wsor/newbie_warnings/queries.sql |
| — | — | @@ -48,3 +48,41 @@ |
| 49 | 49 | ON reciever.user_id = nt.user_id |
| 50 | 50 | GROUP BY reciever.user_id, reciever.user_name; |
| 51 | 51 | |
| | 52 | +SELECT |
| | 53 | + reciever.user_id, |
| | 54 | + reciever.user_name, |
| | 55 | + count(*) AS messages_waiting |
| | 56 | +FROM ( |
| | 57 | +SELECT DISTINCT p.page_title |
| | 58 | +FROM revision r |
| | 59 | +INNER JOIN page p |
| | 60 | + ON r.rev_page = p.page_id |
| | 61 | +WHERE r.rev_user = 6396742 |
| | 62 | +AND p.page_namespace = 3 |
| | 63 | +) AS tp |
| | 64 | +INNER JOIN user reciever |
| | 65 | + ON reciever.user_name = REPLACE(tp.page_title, "_", " ") |
| | 66 | +INNER JOIN user_newtalk nt |
| | 67 | + ON reciever.user_id = nt.user_id |
| | 68 | +GROUP BY reciever.user_id, reciever.user_name; |
| | 69 | + |
| | 70 | +SELECT |
| | 71 | + NULL AS user_id, |
| | 72 | + tp.page_title AS user_name, |
| | 73 | + count(*) AS messages_waiting |
| | 74 | +FROM ( |
| | 75 | +SELECT DISTINCT p.page_title |
| | 76 | +FROM revision r |
| | 77 | +INNER JOIN page p |
| | 78 | + ON r.rev_page = p.page_id |
| | 79 | +WHERE r.rev_user = 6396742 |
| | 80 | +AND p.page_namespace = 3 |
| | 81 | +) AS tp |
| | 82 | +INNER JOIN user_newtalk nt |
| | 83 | + ON tp.page_title = nt.user_ip |
| | 84 | +GROUP BY tp.page_title; |
| | 85 | + |
| | 86 | + |
| | 87 | + |
| | 88 | + |
| | 89 | + |
| Index: trunk/tools/wsor/vandal_tools/queries.sql |
| — | — | @@ -0,0 +1,6 @@ |
| | 2 | +CREATE TABLE halfak.huggle_revert_20110115 |
| | 3 | +SELECT r.rev_id |
| | 4 | +FROM revision r |
| | 5 | +INNER JOIN halfak.revert_20110115 rvt |
| | 6 | + ON r.rev_id = rvt.revision_id |
| | 7 | +WHERE r.rev_comment LIKE "%([[WP:HG]])%"; |
| Index: trunk/tools/wsor/vandal_conversion/R/loader/load_editor_first_and_last.R |
| — | — | @@ -3,7 +3,7 @@ |
| 4 | 4 | |
| 5 | 5 | |
| 6 | 6 | load_editor_first_and_last = function(verbose=T, reload=F){ |
| 7 | | - filename = paste(DATA_DIR, "en.editor_first_and_last.20.tsv", sep="/") |
| | 7 | + filename = paste(DATA_DIR, "en.editor_first_and_last.20.fixed.tsv", sep="/") |
| 8 | 8 | if(!exists("EDITOR_FIRST_AND_LAST")){ |
| 9 | 9 | EDITOR_FIRST_AND_LAST <<- NULL |
| 10 | 10 | } |