I've done a lot of things from my phone, including painfully navigating complex tasks through a remote/gui session (not fun), but I'd lose my mind if I had to type long queries in with that keyboard LOL, maybe you're using some voice-to-text? (fyi-you might have broke the other link when fixing the image  (missing the .tx t now)) I realize the numbers are small but I had to look at why there was a difference.. I partly wasn't being specific enough on my date/time, so with my new query: (tables and field names are modified for security purposes - call me paranoid if you must)select distinct author from PostsTable
left join MeritTable on PostsTable.author=MeritTable.merit-to
where postdatetime between 2022-01-01 00:00:00 AND 2023-01-01 00:00:00
AND MeritTable.merit-date between 2022-01-01 00:00:00 AND 2023-01-01 00:00:00
order by author asc ^ Note: I had to remove the single quotes in the code above or it would trigger cloudflare's security feature and block me.  I'm getting 5,313 results now ( updated the .txt), but diff checker is still showing differences between your data and BPIP's: BPIP has 9 ids listed that you don't have, you have some ids listed that BPIP doesn't have and some duplicates (also resulting in 9).. explanations: -- The 9 BPIP listed, which were not in your list:
1- 413 - bg002h posted in 2022 and received merit. 2- 30747 - Vod posted in 2022 and received merit. 3- 63363 - smiletyson posted in 2022 and received merit4- 3406889 - Salamande posted in 2022 and received merit5- 3457634 - SpenserReed posted in 2022 and received merit6- 3473890 - M__SUFYAN posted in 2022 and received merit7- 3509533 - ChillyMatthew posted in 2022 and received merit8- 3520784 - fedesse posted in 2022 and received merit9- 3525938 - RobbyN789 posted in 2022 and received merit-- The 9 you have listed, which BPIP didn't:
1,2,3,4- Your list contained duplicates for 161364, 487418, 938833, 1980983 which increased the count (name changes & maybe a character encoding issue) 5- 949407 - the post this user did in 2022 doesn't exist in BPIP's DB, I'm assuming there was a parser issue here where it didn't get picked up. 6- 2848088 - no merit is shown being given in 2022 for this user (doesn't exist in BPIP's merit log), the user does have 1 merit on the account currently but it looks like the post isn't there anymore for me to verify. 7- 3414189 - same situation as #6..! 8- 3455838 - BPIP has record of this in the merit log, but the post itself doesn't exist in the posts table so this account didn't make it in BPIP's list. 9- 3520394 - similar situation as #8 |
|
|
|
In the midst of so many options, I think I'll opt for this one. Since it only includes active users who have received merits. Right @ibminer?
To be as specific as possible, the 5,300 would be any user with a post created in 2022 (which wasn't deleted quickly), who also received merit in 2022Thanks again for everyone's help. I hope that later you will like the statistics that I will present with these data.  Don't let us down.  |
|
|
|
I'm not too familiar with them as I tend to avoid them like the plague, can you sideload applications without their store?
Without being on the app store, iOS devices would need to be jailbroken first, which most people don't do. MacOS can install anything mac compatible (sometimes with security settings to allow them). |
|
|
|
Aside from the notifications standpoint, I'm not sure it even needs an app.
Just someone who's good at writing mobile friendly CSS and someone who can use simple machines and knows how it functions. This might just be a simple machines issue too that it's taken so long to get a "mobile friendly" stylesheet.
I looked into doing this once a while back, it seemed like something people wanted, but with a responsive epochtalk always looming on the horizon, it never seemed worth putting time into since it would just get replaced. There are ways to convert the tables down to something similar to index cards using CSS & media queries, similar to what I did with the longer report tables on BPIP ( basically this), which I think would help convert the majority of the site down to at least fit on a mobile device, probably with minimal changes to the code itself. I've just never dove into it and tried, it wasn't too difficult to apply to BPIP's tables but this site is probably more problematic, and I'm sure there would be some hiccups along the way. |
|
|
|
Yep, I apparently muffed a copy/paste on the sample users above, thanks again LoyceV. I think you made a mistake on AverageGlabella, who made many posts (and is listed in your list). The other 3 users posted spam/malware ( 1, 2, 3), and MindlessElectron must have gotten to them before your scraper saw them. They're also banned, so it doesn't matter. I also want to join the party…  Day 1: I'm in love with your strut Day 2: I'm in love with your strut Day 3: I'm in love with your strut And guess what? I'm in love with your strut.  (I'm straight btw - "objectify, but don't cross the line!" =P).. I couldn't help myself. - maybe NSFW.edit: had to fix the lyrics!  Idk why it’s a lot lower than LoyceV’s. My query ended on 12-31-2022 so you might have 1 more day of results than what I posted from BPIP. The main differences I see between LoyceV and BPIP seems to be the users who had posts quickly removed before BPIP picked them up (you probably have these), and while doing a difference check, I had ran into a handful of users with posts in 2023 not 2022, which would not be in your list.. but I only spot checked maybe 10-15 accounts. With 2 parsers usually running I'm surprised BPIP didn't see these deleted posts but the parsers run multiple jobs checking various things at various intervals so quickly deleted posts may not get picked up by the time a parser checks the new post area. |
|
|
|
I can do that  I have data on all users, and it's easy to check which files have been edited (meaning: they made a post) since January 1st, 2022 (Amsterdam time, this includes users active in 2023): see this file. If you don't want to include banned users, see this file. If you ever want an update: remind me of this post: find -type f -newermt '2022-01-01' | cut -d'/' -f3 | cut -d'.' -f1 | sort -n > ~/loyce.club/other/tmp/joker_josue.txt
comm -23 <(sort ~/loyce.club/other/tmp/joker_josue.txt) <(sort ~/loyce.club/bans/banned.txt) | sort -n > ~/loyce.club/other/tmp/joker_josue_not_banned.txt Thank you Sir! I ended up running some queries anyway, numbers didn't match up with your data because it looks like there are users in your list who have not made a post, and BPIP's list would not include anyone in 2023. I kept the queries simple but this is what I'm seeing: LoyceV's https://loyce.club/other/tmp/joker_josue.txt -- (55,937 results) some examples of users with no posts (28452, 14624, 392646, 28877) BPIP https://bpip.org/active_in_2022.txt -- (51,791 results) https://bpip.org/active_in_2022_and_received_merit_in_2022.txt -- (5,300 results) |
|
|
|
|
^ certificate has expired
|
|
|
|
I would like to know if you can get me a list of all users who were active in 2022.
Or else a link where you have that information.
Are you trying to go by the 'last active' date of a profile, or if an account made a post in 2022? It might be more accurate with the latter for BPIP, since a parser wouldn't check inactive profiles for the 'last active' date (unless a manual refresh is done), it is ultimately looking for an account to make a post... so there could have been profiles that were inactive but logged in at some point in 2022, but if they didn't make a post, BPIP likely wouldn't have updated the 'last active' field unless manual refreshes were being done on specific accounts. I may be able to query for a list of every user who made a post in 2022 but I'm not sure if that's what you are looking for or not. |
|
|
|
(im white but i see the preferential/un-preferential treatment of certain people)
You're seeing class treatment of people with money and connections.. a black guy with money and connections would have been treated in a similar fashion. If Will Smith or dare I say Bill Cosby did the same thing as SBF, he'd be treated the same. Stop making everything about race. *smh* Ross is in jail for how long? Must be because he's black.. oh wait, he's not.. nope, they were able to get his funds and didn't need him, and he had no real connections with powerful people, the color of his skin didn't matter. As for SBF, more disappointment in the justice system.. we're heading towards this: .. aaand he's gone. |
|
|
|
In accordance with your preference not to rank (which there is already a kind of ranking), maybe instead list the top 50 or something like that by alphabetical order or some other criteria that just puts "them" in the group of "bad boys (or girls)" but does not subdivide within the group... I just noticed that I had using the word "them." hahahahahaha..
I'm not saying I have a strong preference to not rank the top least trusted, I just don't mind the negative ranks stopping at a dead-end.. which already sort of creates a group at the dead-end of currently 3 accounts. Nobody is perfect, but you know you don't have to be a bad boy or girl to be cool, right JJG? Regardless, based on how BPIP stands now, the bad list would probably be deemed as the top 100 least trusted, based on their feedback score (which can be sorted on the "Trusted" column on the main page). |
|
|
|
Within 20 seconds after getting him out of the car, they have a tazer out and pepper spray, as he is talking calmly to them and trying to get them to settle down. Within 48 seconds, they're pepper spraying him, he reacts, they then taze him and let him go (so they don't get shocked themselves) and he starts running for his life. I wish he would have just rolled onto his stomach and let these guys get over their power trip, but I think in his head he thought he was complying by being on the ground, and kept trying to talk to them. Long story short, once they catch up to him, they brutally beat the shit out of the guy, and he dies later in the hospital. How would five black policemen mercilessly beat up a black man until he was mortally injured without sympathy or a brotherly love? It might be possible that white officers would have stopped them from this senseless killing.
At one point, even calling him "bro" as they beat him and kicked him in the head on the ground. In video 3, one cop was pissed off that he got pepper sprayed in his own face and went back out of anger to attack the guy and take his pain out on him, with a baton, while shouting "Imma baton the fuck out of you", aiming for his head (video 2 shows where he is aiming). AFTER this, two cops hold the guys hands behind him while a 3rd full force punches him in the face 5 times until he couldn't stand anymore. Didn't look like the first time they've done this TBH, it was a brutal beating, and they seemed to enjoy talking about it after, they didn't seem to see anything wrong with what they had just done to another human being. The amount of riots that would be happening right now if these were white cops would be through the roof. They apparently pulled this dude over because he was driving towards incoming traffic (no video shows this of course), he apparently didn't stop for them initially (also not shown), and then eventually he is seen stopped at a red light trying to get back home, he was 80-100 yards from his house, probably why he got up and tried running home and calling for his Mom. Still kinda crazy to see something like this post-George Floyd, but I do think it sheds light on the fact that (IMO) it's not about race, even with Floyd I don't think it was, it's about authority, control and over-use of power, which cops can easily let get to their heads and disregard a human as a human, which is a problem. |
|
|
|
I'm still looking into the S/R issue.
Took a closer look at this myself and there is not really an "issue" per se, unless it makes more sense to change it, but similar to the Most Merited report, currently the ratios are calculated using unique send/receivers and not the sum of merit:  So in the case of GazetaBitcoin, currently it ends up being: (277 times merit was sent to unique/distinct users) / (231 times merit was sent from unique/distinct users) = which is where the 1.20 (rounded) ratio comes in.
I know it's nitpicking, but may the worst of them "win"!
Part of me sees what you are saying, and part of me feels like there shouldn't be a 'winner' in the sense that currently they all end up at the same dead-end of shame. I feel like some of these guys might take some sort of pride in being worse then another, and I'd rather not cater to it, but that's just my opinion. |
|
|
|
And regarding the other two issues I raised (the ones from 1. and 2.) do you have any news?
#2 would be seen as the same issue as #3, the popup window just shows a smaller set of the data, so both arewere showing number of meriters, not the total merit received. -- But the DB was modified last night, so both the popup window and mostemerit.aspx reports should now be displaying the total merit received (and column name/header text will be updated in the near future) #1: ~I'm still looking into the S/R issue.
It's like the refreshed number of merits is reflected only on the bpip profile page and does not propagate through the rest of the website. I am not sure if same happens also with the other badges / ladders.
The general stats on a profile page will get updated instantly when a refresh profile happens, as this updates the main profile table in the DB... but ranks are done through a procedure at regular intervals to all top users, and it would include all badges getting updated at once. For resource/performance purposes, allowing a refresh profile button to recalculate the ranks of thousands of users might not be worth it. |
|
|
|
I hope this helps.
Thank you, if I had any sMerit, I'd send some. So I may have initially misinterpreted what this report was pulling a while back when creating the "info" box on it. It looks like this report is actually calculating the number of times a post was merited, which is apparently why the column was named "Times Merited", not total merit received, so the wording here may be confusing. Currently the Helena Yu post "Cybersecurity subforum" is showing 6 on the report page (link is for last 48 hours, since I'm a day behind on your post ) - this report would offer the same data that this popup window pulls from, in a longer form. 6 because there are 6 users who have sent merit to it. Not sure if this deserves a new report or if we should change this one to actually count the total merit received? It doesn't appear to be unique users though, as it is showing '19' on this post, but I'm only counting 18 people.. so I'm guessing the same person merit'd 2 times which is giving the 19. edit: ^ Actually, there are more than 1 users who have given merit more than once so I think the inconsistency here may have been me not refreshing the page but the parser picking up another merit'er... or the merit happened before 48 hours.. so I do think it is supposed to be unique users, but I haven't delved back into the code to check on this one yet, just my observation. |
|
|
|
|
This is a pretty messed up way to go, but judging by the pictures, if he hadn't been grabbing them all by the throats all the time.. maybe things might have turned out differently.
|
|
|
|
Humans been controlled since the day that they was civilized, the truth has been so heavily politicized If you don't know who's controlling you and killing all the little guys, find out who you're not allowed to criticize Black folks who were never ever actual slaves, fighting with white folks who ain't actual Nazis Controlled by rich folks who use the news to make hate, while elite folks control all the political parties It's a big lie, tryna make you pick sides, tryna make you burn the cities down and kill each other - they got sick minds Big lies, defund the police so that there's big crime, then take away our freedom to restore order they let die Play with people, turn men into women, make the counterculture mainstream to mix up the system Change the pronouns, if gender is a spectrum, so is privilege, I know poor white folks and black celebrities with millions They starve you with a lack of information, and only give you facts through a branded corporation Distort your worldview with an algorithm that changes, based on propaganda curated for your engagement ~~ We can't be free, can't have no peace till we're on the same team But y'all are sheep -- glued to screens -- just part of the machine Y'all are sheeple -- what do y'all believe? To all my sheeple -- nothing's what it seems ~~ Hollywood been rotting your brain, controlling your mouth, you say "Lit", "Fleek", "Bet", "Cap" -- they tryna dumb you down They endorse whatever narrative is popular to shout and use minorities in movies for diversity clout Two sides on the spectrum, but ain't none of 'em honest, took the red pill and the blue pill, spit 'em both in the garbage Being woke used to mean you understood you're a target and now it's having two good legs and never taking a step forward If you agree, it's free speech, disagree, it's hate speech - erase it if it came from anywhere except the mainstream Trump supporters labeled as the racists, but that can't be, Lincoln was Republican, and that's who ended slavery Science been politicized, it's easy to see - a mask became a symbol of which side you believe But you'll never cure a sickness till you cure all the greed, because the problem with our natural immunity is it's free Society is broke and want you locked inside a cubicle, addicted to pornography, liquor, and pharmaceuticals Tell you that you're fat and poor and you were never beautiful, then tweet how much they love you when they hear about your funeral ~~ We can't be free, can't have no peace till we're on the same team But y'all are sheep -- glued to screens -- just part of the machine Y'all are sheeple -- what do y'all believe? To all my sheeple -- nothing's what it seems ~~ If they can't convince you, they confuse you, they want you dumb or dead, they divided you by race, religion, income, and sex Made everybody right or left, the hatred got so intense, if the other side likes oxygen, you'll put a bag on your head And the conspiracy theories labeled as misinformation, it's just the terrifying truth that scares the hell out the nation The system treating you like trash, and you got rifles to aim with, just imagine how they'll treat you when your guns get confiscated George Orwell, 1984 was his last lecture, George called 'em thought police, now we call 'em fact-checkers Government surveillance tryna catch you, they don't ask questions, mass incarceration equals capital for cash investments The system isn't broke, it's working fine, oppressive and chaotic is how it was designed They say if we ain't doing nothing wrong, there's nothing to hide, while their agenda and intelligence is completely classified They don't teach you rights in school, you never learned 'em at all, 'cause they're easy to remove if you don't know what they are The only people you can rule are the criminal ones, so they force you into corners till you're breaking the law ~~ We can't be free, can't have no peace till we're on the same team But y'all are sheep -- glued to screens -- just part of the machine Y'all are sheeple -- what do y'all believe? To all my sheeple -- nothing's what it seems ~~ Reference: Tom MacDonald - Sheeple |
|
|
|
right you are in 1993 you are 18 the girl is 17 you are in New York been with the girl 2 years. cross the border to nj while driving over the George Washington Bridge she was giving you a BJ as soon as the car goes into NJ you become guilty of statutory rape and you violate the Mann act a federal law a racist NJ trooper pull you over and now you a black teenager are facing 5-10 for starry rape and 20 for Mann act violation total of 35-30.
I hear what you're saying but that's a pretty unique story.. there are many more situations of sexual assault then the story you describe here, and I'm not really comfortable describing them. I'd guess a story like this is nowhere near the majority of effected criminals. Look I know the discussion is chipmixer not extended punishments after the fact. I can simply say if you are in the USA and you do chipmaker you paint a target on your back.
Well with this line of thinking, we've had a target on our back ever since we registered an account here.. even simply using Tor would paint a target on you because it is also used by plenty of criminals, and there are plenty of Tor nodes run by governments. This forum also has criminals and you're here supporting it... but you don't feel comfortable using a mixer? All I'm saying is just because someone uses a service for a bad purpose, it doesn't mean the service itself is bad. There are plenty of legit services all over the world being manipulated by criminals, shutting them all down isn't the answer. |
|
|
|
It also required that repeat sex offenders receive a sentence of life in prison.
Megan's law: https://www.law.cornell.edu/wex/megan%27s_lawhttps://www.law.cornell.edu/rio/citation/Pub._L._104-145I don't see it saying anything about the requirement of a life sentence? If you are saying a public sex offender registry is a "punishment" equivalent to incarceration (you said "time served" was altered - FUD! lol), or even something like community service, then we may have to agree to disagree.. as I wouldn't see a public registry like this in the same way I'd see a sentence adjustment that effects the freedom of an individual or their criminal status. Megan's law was able to punish all prior pedophiles if they were still in prison.
You call it a punishment, but maybe it's just a sincere effort to protect the public and discourage repeat sex offenders. *shrug* So I guess the best we could ever expect is some sort of public registry of bitcoiners using mixers if governments could decipher who all of them were?.. of course, we'd have to assume the public will care about this as much as they do the sexual assault of minors for it to ever happen. |
|
|
|
|
^ Sounds like Phillip may be referring to the reduction of sentences for illegal crimes committed, which is a much different thing then going back and making something that was legal suddenly illegal at a previous point in time and issuing a sentence, and/or imposing stricter sentences at a later point in the future, these I don't believe have ever been done in the US.
|
|
|
|
It's not like I didn't hint at it or anything Well, I know for a fact that the factoids have had some recent updates. ~ This was ibminer's effort.
I initiated the idea, but the content of the factoids themselves was somewhat of a joint effort! Happy to help get BPIP some of the recognition it deserves. My understanding is anyone who can see the donators section including VIPs can request a permanent factoid slot with minimal limitations, but outside of that anyone can suggest factoids that would be useful to forum users. Whether they get added or not is probably based on how useful they actually are to the forum or its users. ..and here they are with links! Hope you enjoy your cool glass of..  |
|
|
|
|
Show Posts
