User Statistics Requests V ## Admin 09/23/21 (Thu) 02:07:47 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.
Anonymous 09/23/21 (Thu) 02:44:18 No. 8552 >>8553
request
Anonymous 09/23/21 (Thu) 02:46:59 No. 8553 >>8554
>>8552 12 on ip, 267 on whitelist token
Anonymous 09/23/21 (Thu) 02:49:40 No. 8554
>>8553 can't believe I have 12 on this IP
thank you
Anonymous 09/23/21 (Thu) 02:56:18 No. 8555 >>8556
lay it on me
Anonymous 09/23/21 (Thu) 03:47:44 No. 8557
do me. i'm curious
Anonymous 09/23/21 (Thu) 03:50:01 No. 8558
84,
Anonymous 09/23/21 (Thu) 05:06:56 No. 8559
(´・ω・｀)
Anonymous 09/23/21 (Thu) 11:05:21 No. 8560
>>8556 Hey that's more than I thought.
Anonymous 11/12/21 (Fri) 09:41:06 No. 8792 >>8802
request
Anonymous 11/12/21 (Fri) 10:11:55 No. 8793 >>8802
request
Anonymous 11/13/21 (Sat) 04:42:43 No. 8802 >>9188
>>8792 1
>>8793 I 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=" | 270 |et (0.01 sec) count(*) from posts_jp where wl_token=" | 53 |et (0.00 sec) count(*) from posts_ec where wl_token=" | 332 | Anonymous 01/17/22 (Mon) 05:23:18 No. 9188
>>8802 you can do the query using php like this:
($wl_token){listBoards(); '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()); Anonymous 06/14/22 (Tue) 21:38:23 No. 10051 >>10068
request
Anonymous 06/15/22 (Wed) 09:48:12 No. 10083 >>10084
>>10068 only 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
Anonymous 06/15/22 (Wed) 09:50:15 No. 10084
>>10083 I can only see what's on your current IP and what still exists on the site
Anonymous 06/15/22 (Wed) 09:51:12 No. 10085
like right now your IP just changed so you're back to one post
Anonymous 06/15/22 (Wed) 09:52:08 No. 10086
If I count up what I think is your IP range it's something like 16
Anonymous 06/15/22 (Wed) 11:19:48 No. 10089 >>10090
request
Anonymous 06/15/22 (Wed) 12:43:00 No. 10091
That's not a lot, I need to spam.
Anonymous 06/15/22 (Wed) 12:46:01 No. 10092
numbers come from slow boards where posts don't get bumped off much
Anonymous 06/15/22 (Wed) 15:29:49 No. 10096 >>10102
request
Anonymous 06/16/22 (Thu) 02:45:44 No. 10102 >>10103 >>10104
>>10095 319
>>10096 Tracking your VIP token
90 + 1095 + 1 + 47 + 21 + 16 + 254
Without it: 1
Anonymous 11/03/22 (Thu) 05:14:06 No. 10948 >>10949
Pretty sure my IP is dynamic and changing a bunch now... How many do I have?
Anonymous 11/03/22 (Thu) 12:04:01 No. 10949
>>10948 tracking the token
+------------+ ) | 145 | 141 | 131 | 154 | 100 | 241 | 1679 | 269 | 175 | 39 | 760 | 11 | Anonymous 05/29/23 (Mon) 01:54:59 No. 11798
Been using this token since March 4, how many posts have I made with it since then?
Anonymous 08/10/23 (Thu) 02:41:27 No. 11867
Curious again, how many do I have? IP/token
Anonymous 08/10/23 (Thu) 18:28:09 No. 11868
I hope I have the sql query somewhere
Anonymous 08/10/23 (Thu) 18:49:00 No. 11869
select tokens.board , tokens.qty as "Token quantity" , ip.qty as "IP quantity" from oll" as board, count( * ) as qty from posts_poll where wl_token = "TOKEN" "sum" as board, count( * ) as qty from posts_sum where wl_token = "TOKEN" "spg" as board, count( * ) as qty from posts_spg where wl_token = "TOKEN" ect "aut" as board, count( * ) as qty from posts_aut where wl_token = "TOKEN" ect "win" as board, count( * ) as qty from posts_win where wl_token = "TOKEN" "jp" as board, count( * ) as qty from posts_jp where wl_token = "TOKEN" "qa" as board, count( * ) as qty from posts_qa where wl_token = "TOKEN" "cry" as board, count( * ) as qty from posts_cry where wl_token = "TOKEN" ect "secret" as board, count( * ) as qty from posts_secret where wl_token like "TOKEN"ect "trans" as board, count( * ) as qty from posts_trans where wl_token = "TOKEN" "ec" as board, count( * ) as qty from posts_ec where wl_token = "TOKEN" "f" as board, count( * ) as qty from posts_f where wl_token = "TOKEN") as tokens "poll" as board, count( * ) as qty from posts_poll where wl_token = "IP" "sum" as board, count( * ) as qty from posts_sum where ip = "IP" "spg" as board, count( * ) as qty from posts_spg where ip = "IP" "aut" as board, count( * ) as qty from posts_aut where ip = "IP" "win" as board, count( * ) as qty from posts_win where ip = "IP" "jp" as board, count( * ) as qty from posts_jp where ip = "IP" "qa" as board, count( * ) as qty from posts_qa where ip = "IP" "cry" as board, count( * ) as qty from posts_cry where ip = "IP" "secret" as board, count( * ) as qty from posts_secret where ip = "IP" "trans" as board, count( * ) as qty from posts_trans where ip = "IP" "ec" as board, count( * ) as qty from posts_ec where ip = "IP" "f" as board, count( * ) as qty from posts_f where ip = "IP") as ip on tokens.board = ip.board ;
Anonymous 08/10/23 (Thu) 18:49:18 No. 11870 >>11871
+--------+----------------+-------------+ Token quantity | IP quantity |----+-------------+ | 78 | 0 | | 8 | 0 | | 77 | 0 | | 0 | 0 | | 19 | 0 | | 128 | 2 | | 752 | 1 | | 37 | 0 | 110 | 0 | 4 | 0 | | 9 | 0 | | 1 | 0 |----+-------------+
Anonymous 02/18/25 (Tue) 09:32:06 No. 13100 >>13101
count my bans freak
Anonymous 02/18/25 (Tue) 10:57:07 No. 13102 >>13104
how can the ban counter be at almost 2 million when the total post count over all boards isnt anywhere close
Anonymous 02/18/25 (Tue) 10:59:56 No. 13103
hmm... when you ban IP ranges does that count as like 65536 bans for 123.123.*.*