Page MenuHomePhabricator
Paste P894

echo-show-alert usage
ActivePublic

Authored by Legoktm on Jul 7 2015, 12:50 AM.
legoktm@terbium:~$ foreachwikiindblist /srv/mediawiki/large.dblist sql.php /home/legoktm/echo-alert.sql --slave=any
-----------------------------------------------------------------
arwiki
-----------------------------------------------------------------
arwiki: stdClass Object
arwiki: (
arwiki: [count(*)] => 59
arwiki: )
-----------------------------------------------------------------
cawiki
-----------------------------------------------------------------
cawiki: stdClass Object
cawiki: (
cawiki: [count(*)] => 7
cawiki: )
-----------------------------------------------------------------
cebwiki
-----------------------------------------------------------------
cebwiki: stdClass Object
cebwiki: (
cebwiki: [count(*)] => 1
cebwiki: )
-----------------------------------------------------------------
commonswiki
-----------------------------------------------------------------
commonswiki: stdClass Object
commonswiki: (
commonswiki: [count(*)] => 191
commonswiki: )
-----------------------------------------------------------------
dewiki
-----------------------------------------------------------------
dewiki: stdClass Object
dewiki: (
dewiki: [count(*)] => 350
dewiki: )
-----------------------------------------------------------------
enwiki
-----------------------------------------------------------------
enwiki: stdClass Object
enwiki: (
enwiki: [count(*)] => 3646
enwiki: )
-----------------------------------------------------------------
enwikinews
-----------------------------------------------------------------
enwikinews: stdClass Object
enwikinews: (
enwikinews: [count(*)] => 10
enwikinews: )
-----------------------------------------------------------------
enwikisource
-----------------------------------------------------------------
enwikisource: stdClass Object
enwikisource: (
enwikisource: [count(*)] => 13
enwikisource: )
-----------------------------------------------------------------
enwiktionary
-----------------------------------------------------------------
enwiktionary: stdClass Object
enwiktionary: (
enwiktionary: [count(*)] => 30
enwiktionary: )
-----------------------------------------------------------------
eswiki
-----------------------------------------------------------------
eswiki: stdClass Object
eswiki: (
eswiki: [count(*)] => 168
eswiki: )
-----------------------------------------------------------------
fawiki
-----------------------------------------------------------------
fawiki: stdClass Object
fawiki: (
fawiki: [count(*)] => 27
fawiki: )
-----------------------------------------------------------------
frwiki
-----------------------------------------------------------------
frwiki: stdClass Object
frwiki: (
frwiki: [count(*)] => 132
frwiki: )
-----------------------------------------------------------------
frwikisource
-----------------------------------------------------------------
frwikisource: stdClass Object
frwikisource: (
frwikisource: [count(*)] => 4
frwikisource: )
-----------------------------------------------------------------
frwiktionary
-----------------------------------------------------------------
frwiktionary: stdClass Object
frwiktionary: (
frwiktionary: [count(*)] => 4
frwiktionary: )
-----------------------------------------------------------------
idwiki
-----------------------------------------------------------------
idwiki: stdClass Object
idwiki: (
idwiki: [count(*)] => 23
idwiki: )
-----------------------------------------------------------------
incubatorwiki
-----------------------------------------------------------------
incubatorwiki: stdClass Object
incubatorwiki: (
incubatorwiki: [count(*)] => 5
incubatorwiki: )
-----------------------------------------------------------------
itwiki
-----------------------------------------------------------------
itwiki: stdClass Object
itwiki: (
itwiki: [count(*)] => 113
itwiki: )
-----------------------------------------------------------------
jawiki
-----------------------------------------------------------------
jawiki: stdClass Object
jawiki: (
jawiki: [count(*)] => 459
jawiki: )
-----------------------------------------------------------------
kowiki
-----------------------------------------------------------------
kowiki: stdClass Object
kowiki: (
kowiki: [count(*)] => 95
kowiki: )
-----------------------------------------------------------------
metawiki
-----------------------------------------------------------------
metawiki: stdClass Object
metawiki: (
metawiki: [count(*)] => 76
metawiki: )
-----------------------------------------------------------------
mgwiktionary
-----------------------------------------------------------------
mgwiktionary: stdClass Object
mgwiktionary: (
mgwiktionary: [count(*)] => 0
mgwiktionary: )
-----------------------------------------------------------------
mkwiki
-----------------------------------------------------------------
mkwiki: stdClass Object
mkwiki: (
mkwiki: [count(*)] => 0
mkwiki: )
-----------------------------------------------------------------
nlwiki
-----------------------------------------------------------------
nlwiki: stdClass Object
nlwiki: (
nlwiki: [count(*)] => 70
nlwiki: )
-----------------------------------------------------------------
nowiki
-----------------------------------------------------------------
nowiki: stdClass Object
nowiki: (
nowiki: [count(*)] => 9
nowiki: )
-----------------------------------------------------------------
plwiki
-----------------------------------------------------------------
plwiki: stdClass Object
plwiki: (
plwiki: [count(*)] => 41
plwiki: )
-----------------------------------------------------------------
ptwiki
-----------------------------------------------------------------
ptwiki: stdClass Object
ptwiki: (
ptwiki: [count(*)] => 102
ptwiki: )
-----------------------------------------------------------------
rowiki
-----------------------------------------------------------------
rowiki: stdClass Object
rowiki: (
rowiki: [count(*)] => 15
rowiki: )
-----------------------------------------------------------------
ruwiki
-----------------------------------------------------------------
ruwiki: stdClass Object
ruwiki: (
ruwiki: [count(*)] => 227
ruwiki: )
-----------------------------------------------------------------
shwiki
-----------------------------------------------------------------
shwiki: stdClass Object
shwiki: (
shwiki: [count(*)] => 0
shwiki: )
-----------------------------------------------------------------
srwiki
-----------------------------------------------------------------
srwiki: stdClass Object
srwiki: (
srwiki: [count(*)] => 9
srwiki: )
-----------------------------------------------------------------
svwiki
-----------------------------------------------------------------
svwiki: stdClass Object
svwiki: (
svwiki: [count(*)] => 24
svwiki: )
-----------------------------------------------------------------
trwiki
-----------------------------------------------------------------
trwiki: stdClass Object
trwiki: (
trwiki: [count(*)] => 54
trwiki: )
-----------------------------------------------------------------
ukwiki
-----------------------------------------------------------------
ukwiki: stdClass Object
ukwiki: (
ukwiki: [count(*)] => 19
ukwiki: )
-----------------------------------------------------------------
viwiki
-----------------------------------------------------------------
viwiki: stdClass Object
viwiki: (
viwiki: [count(*)] => 11
viwiki: )
-----------------------------------------------------------------
warwiki
-----------------------------------------------------------------
warwiki: stdClass Object
warwiki: (
warwiki: [count(*)] => 0
warwiki: )
-----------------------------------------------------------------
wikidatawiki
-----------------------------------------------------------------
wikidatawiki: stdClass Object
wikidatawiki: (
wikidatawiki: [count(*)] => 48
wikidatawiki: )
-----------------------------------------------------------------
zhwiki
-----------------------------------------------------------------
zhwiki: stdClass Object
zhwiki: (
zhwiki: [count(*)] => 199
zhwiki: )
-----------------------------------------------------------------
zhwiktionary
-----------------------------------------------------------------
zhwiktionary: stdClass Object
zhwiktionary: (
zhwiktionary: [count(*)] => 2
zhwiktionary: )
legoktm@terbium:~$ cat echo-alert.sql
select count(*) from user_properties where up_property ='echo-show-alert' and up_value=0;

Event Timeline

Legoktm edited the content of this paste. (Show Details)Jul 7 2015, 12:50 AM
Legoktm changed the title of this paste from untitled to echo-show-alert usage.
Legoktm updated the paste's language from autodetect to autodetect.
Shizhao updated the paste's language from autodetect to shell.Dec 29 2016, 4:12 AM