--- Log opened Thu Jul 27 00:00:15 2023 02:12 -!- Netsplit *.net <-> *.split quits: @xray, @Dolemite, @eryc, @Shadow404, aestetix, @Mirage, Synx_, ware, ZachGibbens, @_NSAKEY, (+2 more, use /NETSPLIT to show all of them) 02:19 -!- Netsplit over, joins: @Mirage, @xray, @eryc, ware, @the_greatArtiste, @Dolemite, @_NSAKEY, Synx_, PigBot, @Shadow404 (+2 more) 03:00 < aestetix> Dolemite: it's not a left or a right thing 03:00 < aestetix> It's a "congress is too old" thing 03:00 < aestetix> Look at Feinstein 06:14 <@Dolemite> mr0ning, be0tches and h0ez! 06:24 * aestetix hugs Dolemite 07:18 <@Dolemite> Yay, shit show! 07:18 <@Dolemite> https://gizmodo.com/twitter-x-elon-musk-vaccine-bronny-james-fact-check-1850678981 07:18 < PigBot> Twitter Deletes Its Own Fact Check of Elon's Vaccine Tweet (at gizmodo.com) https://tinyurl.com/27zp63zt 07:19 <@Dolemite> I'm so glad I had good timing and sold all of my TSLA when it nearly hit $300/share, again 08:09 <@Mirage> Was that make, lose, or break even? 08:13 <@Dolemite> Mirage: I was down less than about $30 total at that point. Then RCL had their earnings call this morning and my portfolio jumped +$1,500. 08:15 <@Dolemite> Wow. The Witcher s03e06 definitely doesn't disappoint. 10:33 < Evilpig> there is a new trend on youtube, or at least new to me. girls doing clothes try ons? so that isn't new, but this particular one is "transparent tops tryons" so i'm looking at boobs and it isn't censored in any way 10:35 < Evilpig> https://www.youtube.com/watch?v=NQT7fzH3IM4 Here you go, I shouldn't have to say NSFW after that description 10:35 < PigBot> See-Through/Transparent Lingerie and Clothes | Try-On Haul | At The Mall - YouTube (at www.youtube.com) https://tinyurl.com/2765utzb 11:08 <@Mirage> If everyone in the 'trend' is similar to her, I'd say it's because they can't make it as camgirls 11:51 < Evilpig> https://www.prekindle.com/promo/id/532452769901214335 11:51 < PigBot> Uncle Kracker Tickets, Thursday, August 31 2023 | Prekindle (at www.prekindle.com) https://tinyurl.com/27pmj7rv 12:28 <@Dagmar> That bitch had the chance to mark her content age-restricted and she did not 12:28 <@Dagmar> That's fuckin' weak 12:33 < Evilpig> there's aparently a bunch of those 12:36 < Evilpig> If y'all have contact details for cindy, wish her happy birthday 12:40 < Evilpig> heh, have you seen the poster for the final season of Harley Quinn yet? 12:40 < Evilpig> lol 12:49 < Evilpig> someone walking around on a beach in portugal, right now. https://www.youtube.com/watch?v=SQGAA1HZDHg 12:50 < PigBot> MUST SEE - BEACHES OF PORTUGAL | Portugal 2023 - YouTube (at www.youtube.com) https://tinyurl.com/286v4my2 13:11 <@Dagmar> Yeah that's someone being slightly pervy 13:12 <@Dagmar> It's clear that from the contact information and suggestions the "trying on clothes" girl had that she _does_ have an onlyfans somewhere, or something shadier going on 13:12 <@Dagmar> ...but her stuff is _definitely_ not appropriate for 13-year-olds 13:14 < Evilpig> very likely. I didn't bother to go find her profile or anything. just looked up and saw boobs and went back to this project 13:20 <@Dagmar> Good god it's hot outsode 13:21 <@Mirage> I don't wanna hear it 13:28 < Evilpig> I gotta learn perl at somepoint. Dagmar, mirage... how to? this is the sql statement: INSERT INTO usbdevices SET uniqueid=, usbdeviceid=, usb_date= ON DUPLICATE KEY UPDATE usb_date=; 13:29 < Evilpig> my $sth= $dbh->prepare("insert into usbdevices(uniqueid, usbdevice, usb_date) values(?,?,?)"); 13:29 < Evilpig> $sth->execute($uniqueid, $usbdev->first_child_text, $filedate); 13:29 < Evilpig> how do you handle the value for the update with that context? 13:31 <@Dagmar> You just repeat it to the function call 13:32 <@Dagmar> prepare('INSERT INTO usbdevices SET uniqueid = ?, usbdeviceid = ?, usb_date = ? ON DUPLICATE KEY UPDATE usb_date = ?'); and then execute with $filedate in the list twice (in the appropriate order) 13:32 <@Dagmar> Ther'es nothing terribly magical about prepared statements 13:33 <@Dagmar> THANK GOD 13:33 <@Dagmar> So, that would be execute($uniqueid, $usbdev->first_child_text, $filedate, $filedate); 13:34 < Evilpig> okay that's what I was just about to do. trying to stick within the style that this dude has laid out and me and perl aren't super kosher 13:34 <@Dagmar> Yeah well, I'm over here getting so deep into that shit I'm approaching the point where I have to create an access _table_ in mysql just to manage roles 13:35 <@Dagmar> ...and roles aren't as flexible as I thought. Once a user@host is assigned a role, that's _all_ the access it gets 13:35 <@Dagmar> I originally thought it was additive 13:35 <@Dagmar> So, if I want to be able to throw a user in there and have them magically get access to multiple databases/tables, I'm going to have to do some on update shit on a table that goes and applies grants and stuff 13:36 < Evilpig> due to the outcome of a recent security exercise we're being asked to identify a bunch of usb devices in the enviornment and that is involving updating this database and the process around it is heavy 13:36 <@Dagmar> Plus I finally decided I have to spin up a separate DB host for the access controls for the _other_ systems I've developed 13:38 <@Dagmar> I've got the data in one database (which no one is allowed to read), some stored procedures to check if a user has a given right through an access matrix in a second database (which has like three functions and one procedure in it), and then the utility procedures/functions for manipulalating the access control databae in a _third_ database 13:39 <@Dagmar> The general idea being that the worst that could happen if someone gets ahold of the credentials for the accesscontrol_api database is that they'd be able to very slowly enumerate who has what access and that's about it 13:39 <@Dagmar> ...but at least I made this flexible enough that I'll _never have to write another one_ 13:39 <@Dagmar> Users get assigned roles. Roles are linked to lists of named rights. 13:40 <@Dagmar> Users can have more than one role assigned to them in these tables, so I'm sort of reinventing Bell-Lapadula shit 13:41 <@Dagmar> ...but it does at least simplify checking to see if a user is allowed to view DHCP lease information down to just one fuckin' subroutine call in a perl libray 13:41 <@Dagmar> ...and I can stick the credentials to access _that_ table in the damn library and not worry about it 13:42 <@Dagmar> Anything/everything called from the accesscontrol_api database will result in an entry in the activitylog table 14:13 <@Mirage> May 2024...seriously? Granted given the judge I'm suprised she didn't just roll over for him and leave it unset 14:23 <@Dagmar> At least it's before the election 14:24 <@Dagmar> They're almost certain to try many times to push that date forward even further 14:25 <@Dagmar> Either way, for someone to commit these particular crimes and not be in jail _immediately_ is virtually unheard of 20:35 < Evilpig> the second season of good omens is out 22:02 <@Mirage> heh. Might have to print this. https://www.thingiverse.com/thing:6107191 22:02 < PigBot> Cat - fuck off by RolandvonBismarck - Thingiverse (at www.thingiverse.com) https://tinyurl.com/2b6hjnn7 23:07 < Evilpig> lol --- Log closed Fri Jul 28 00:00:17 2023