No.8551
Referring to the post at
>>>/poll/1597 you can use this thread to request statistic information about your current IP.
Items such as post counts and etc.
No.8552
request
No.8553
>>855212 on ip, 267 on whitelist token
No.8554
>>8553can't believe I have 12 on this IP
thank you
No.8555
lay it on me
No.8557
do me. i'm curious
No.8558
84,
but you have posts on the site since 2020. Can only count what's on the site right now.
No.8559
(´・ω・｀)
No.8560
>>8556Hey that's more than I thought.
No.8792
request
No.8793
request
No.8802
>>87921
>>8793I lost the SQL to do it. Ask me again if you want me to remake it so it gives a full site count.
mysql> select count(*) from posts_qa where wl_token="
+----------+
| count(*) |
+----------+
| 270 |
+----------+
1 row in set (0.01 sec)
mysql> select count(*) from posts_jp where wl_token="
+----------+
| count(*) |
+----------+
| 53 |
+----------+
1 row in set (0.00 sec)
mysql> select count(*) from posts_ec where wl_token="
+----------+
| count(*) |
+----------+
| 332 |
+----------+
No.9188
>>8802you can do the query using php like this:
function calcToken($wl_token){
$boards = listBoards();
$query = 'SELECT SUM(`top`) FROM (';
foreach ($boards as &$_board) {
$query .= sprintf("SELECT COUNT(ip) AS `top` FROM ``posts_%s`` WHERE `wl_token` = '%s' UNION ALL ", $_board['uri'], $wl_token);
}
$query = preg_replace('/UNION ALL $/', ') AS `posts_all`', $query);
$query = query($query) or error(db_error());
return (int)$total = number_format($query->fetchColumn());
}
No.10051
request
No.10083
>>10068only 4? thats a bit strange, I’ve lived in 3 different places since I started using this site so I knew it would be low but I recently went back to the place where I first started. I mostly lurk but even then 4 seems more like the total number of posts since I moved back instead of total at this place. Maybe something has changed in the internet since I’ve last been here
No.10084
>>10083I can only see what's on your current IP and what still exists on the site
No.10085
like right now your IP just changed so you're back to one post
No.10086
If I count up what I think is your IP range it's something like 16
No.10089
request
No.10091
That's not a lot, I need to spam.
No.10092
numbers come from slow boards where posts don't get bumped off much
No.10096
request
No.10102
>>10095319
>>10096Tracking your VIP token
90 + 1095 + 1 + 47 + 21 + 16 + 254
Without it: 1
No.10948
Pretty sure my IP is dynamic and changing a bunch now... How many do I have?
No.10949
>>10948tracking the token
+------------+
| count( * ) |
+------------+
| 145 |
| 141 |
| 131 |
| 154 |
| 100 |
| 241 |
| 1679 |
| 269 |
| 175 |
| 39 |
| 760 |
| 11 |
+------------+
No.11798
Been using this token since March 4, how many posts have I made with it since then?
No.11867
Curious again, how many do I have? IP/token
No.11868
I hope I have the sql query somewhere
No.11869
select tokens.board , tokens.qty as "Token quantity" , ip.qty as "IP quantity" from
(select "poll" as board, count( * ) as qty from posts_poll where wl_token = "TOKEN"
union select "sum" as board, count( * ) as qty from posts_sum where wl_token = "TOKEN"
union select "spg" as board, count( * ) as qty from posts_spg where wl_token = "TOKEN"
union select "aut" as board, count( * ) as qty from posts_aut where wl_token = "TOKEN"
union select "win" as board, count( * ) as qty from posts_win where wl_token = "TOKEN"
union select "jp" as board, count( * ) as qty from posts_jp where wl_token = "TOKEN"
union select "qa" as board, count( * ) as qty from posts_qa where wl_token = "TOKEN"
union select "cry" as board, count( * ) as qty from posts_cry where wl_token = "TOKEN"
union select "secret" as board, count( * ) as qty from posts_secret where wl_token like "TOKEN"
union select "trans" as board, count( * ) as qty from posts_trans where wl_token = "TOKEN"
union select "ec" as board, count( * ) as qty from posts_ec where wl_token = "TOKEN"
union select "f" as board, count( * ) as qty from posts_f where wl_token = "TOKEN") as tokens
join (select "poll" as board, count( * ) as qty from posts_poll where wl_token = "IP"
union select "sum" as board, count( * ) as qty from posts_sum where ip = "IP"
union select "spg" as board, count( * ) as qty from posts_spg where ip = "IP"
union select "aut" as board, count( * ) as qty from posts_aut where ip = "IP"
union select "win" as board, count( * ) as qty from posts_win where ip = "IP"
union select "jp" as board, count( * ) as qty from posts_jp where ip = "IP"
union select "qa" as board, count( * ) as qty from posts_qa where ip = "IP"
union select "cry" as board, count( * ) as qty from posts_cry where ip = "IP"
union select "secret" as board, count( * ) as qty from posts_secret where ip = "IP"
union select "trans" as board, count( * ) as qty from posts_trans where ip = "IP"
union select "ec" as board, count( * ) as qty from posts_ec where ip = "IP"
union select "f" as board, count( * ) as qty from posts_f where ip = "IP") as ip on tokens.board = ip.board ;
No.11870
+--------+----------------+-------------+
| board | Token quantity | IP quantity |
+--------+----------------+-------------+
| poll | 78 | 0 |
| sum | 8 | 0 |
| spg | 77 | 0 |
| aut | 0 | 0 |
| win | 19 | 0 |
| jp | 128 | 2 |
| qa | 752 | 1 |
| cry | 37 | 0 |
| secret | 110 | 0 |
| trans | 4 | 0 |
| ec | 9 | 0 |
| f | 1 | 0 |
+--------+----------------+-------------+