Good morning, everyone. Well, good morning, everyone in Australia. Good evening, I think, to Sam, where you are in the Bay Area. I assume it's sort of pre-dinner time, so we're getting everyone at the very different ends of the day for this session. Can I please welcome everyone to the breakfast session of day two of the ANU Crawford Leadership Forum. Thank you so much for joining us. Before we proceed, I do want to acknowledge and thank the traditional owners from where I join you today in Ngunnawal Country. Before we enter the discussion today, I'd like to go through a few housekeeping things. I'm sorry, I'm sure you've heard these so many times by now. If you do want to raise a question, please just put that in the chat, raise your hand either on screen or via Zoom. Samantha and I are going to have a chat, basically for about probably 15 minutes, depending on how much we can eke out of our disagreements on things. And then we will open up to questions from the floor. So if you have something that you want to interject with, just keep that in mind. And there'll be plenty of time to question both of us, but particularly Samantha because she is very much the expert here. So I will introduce Samantha. She is an expert, a very well published and very well cited expert in disinformation and misinformation. She's based at the Stanford Internet Observatory and Digital City Civil Society Lab. She writes on technology in society, media, foreign influence, and I guess how we really wrangle with the internet and social media in international relations and in governing domestic politics. So I'm going to start by asking Sam a question that I think really gets to the core difference of how different researchers view social media. I'm very sorry to say to myself, I'm very much a domestic politics person. I look at elections. I look at how we can change voters minds on things. Samantha is coming to this from very much the perspective of foreign influence. So from my perspective, social media doesn't matter, right? People have their political views and their political preferences form so young that jumping onto Twitter or jumping onto Facebook shouldn't matter. That's the very sort of conservative domestic politics view. But Samantha, convince me why social media matters. Yeah, and Jill, thank you so much for that introduction and hi, good morning everyone in Australia. Yeah, it is a little before dinner here, so hopefully you don't hear my tummy grumbling through the microphone. That's such a such a great kind of question to kick us off is like, what is actually new and important here about social media. Because, you know, Jill, I think you pointed out like people consume a wide variety of information from so many different sources where influenced by our friends were influenced by our families and, you know, our political ideologies aren't something that, you know, we read one piece of news and all of a sudden we've changed our mind on an entire like contentious issue it's something that happens slowly over time, if at all. So, yeah, this is kind of really the million dollar question here is like what's actually new about social media and as social media has it disrupted our information landscape our interpersonal relations enough to kind of affect these growing trends in polarization. And so there's a number of different theories and arguments out there around the effect that social media can have on polarization. First, some of you might have heard of this term before has to do with filter bubbles. And so that's the idea that social media algorithms themselves they're reinforcing a particular point of view, because we know that algorithms have personalized content, and they personalized content based on people's data, which will collect all kinds of information about like our political preferences, our various interest interests and make big big inferences about who we are as people and who we are as voters. And then the algorithms will feed in that content that already pits our preferences to our news feed so we're continuously seeing, you know, either right leaning or left leaning content. That's kind of like the first theory around the way that social media might influence polarization because if you're only seeing content politically left or politically right. That goes to those diversity points that help make democracy work and might, you know, challenge your own kind of biases and whatnot. The second theory is that it's not actually the algorithms but it's the way that social media structures group interactions. So this is the theory around echo chambers where I'm going to, I already have a group of friends that are particularly, you know, politically leaning one way or another, I'm going to follow those people, I'm going to interact with them. I'm going to stay in this echo chamber where I'm not necessarily being exposed to other kinds of people with diverse views around politics and therefore will polarize society that way because people are self selecting into various groups. And then the third kind of theory around social media and polarization has to do sort of again related to the algorithms but the way that they promote certain kinds of content over others, not necessarily political but this really has to do with the different kinds of polarization that we're talking about as well because there's ideological polarization, which has to do with, you know, we can't agree on political ideologies and then there's affective polarization, which is the idea that I, you know, as one political ideology don't like you as a person who has a different political ideology that means so that's affective polarization. And this is where attention economics kind of come into play because algorithms might promote negative content they might promote conspiratorial content they might promote content that is like very rumorous or slanderous and that stuff tends to go viral and very far on social media and so we're constantly being exposed to the other side, or people who are do not share our same political values as, you know, being negative and being bad affective polarization might therefore increase and so those are kind of three theories and to be honest Jill I think a lot of the literature is very kind of there are studies that will show both sides for all of these things we don't necessarily have good answers as to you know this is exactly you know social media for sure is promoting agro chambers or as for sure promoting filter bubbles, or as for sure you know, feeding us this negative kind of content through attention economics that is leading directly to polarization but these are kind of like the three theories that people tend to point to when we're thinking about hey, what's actually new here about social media, and how could this be changing how we view other political ideologies and how we view others. Let's talk a little bit more about effective polarization is I didn't know you were going to bring that up. And I love the theory of effective polarization well I hate it from a democratic sense but it's probably something that a lot of the audience hasn't really come across because it's a little bit inside baseball still. And it's this idea that we have a sense of identity about the party that we like, or the social group that we identify with so. I'm an academic and I'm a cricket fan, and I live in Canberra and all of these things make up my identity, but effective polarization is a little bit more embedded it's a little bit more angry. And it taps into this idea that we don't just like our in group but we often hate the out group. And while this can sound really kind of aggressive in confronting it's not always it's not always so much the case. It might just be that as much as I like to see my party win at an election, I also kind of like to see another party lose. And that's in conventional political science, something that we thought didn't matter so much. There's the sort of the classic study of negative advertising and sort of emotional advertising in political science and election campaign suggests that when people see too much of this kind of angry emotion from candidates or from political parties, they tune out. It might make us it might have influenced our vote but most of what it does is make us less likely to care generally, but something about algorithms and social media feeds off this right and so you mentioned this in your last point because I think this is one area where we can instinctively get the feel that social media does matter we do see angrier content and we do see this more effective with an a content more than we see boring kind of long form headlines, you know, explainers or think pieces about Afghanistan for instance so what what role does the do the platforms have here, you know, and they are they really to blame in pushing this viral click baby effective kind of content. Yeah, so you know I think it is definitely you know we can think of the new role of technology here and the role of the algorithms, because for sure 100% they are playing a role at the end of the day social media companies are businesses and they are businesses that are built on attention to economics and surveillance capitalism where you take a whole bunch of data about people you feed it into your algorithm so that their people's attention stay on their screen longer so you're constantly scrolling on your phone. And that time in that time you can deliver advertisements to them or sell users data to other parties who want to advertise to to various users across the platforms and so there is an actual economic incentive for this kind of content to go viral. That being said, it's also because we as people tend to like this content. You know, people do like there are lots of studies out there that show that emotional content tends to go much further and much farther on the internet than plain old facts. And you know this doesn't always necessarily have to be negative emotions like if we think of cat videos or those like cute animal videos like that's why they tend to get shared online a lot because they elicit a positive emotional response and people and then people will go on and share that kind of content, but negative emotions tend to have a much stronger effect on people and so that's why they'll often go farther than some of the happier content that we see online so you know part of it is for sure the social media platforms and you know I don't kind of like absolve them of their like role in really promoting this kind of content but you also can't take the human factor out of it as well. So you mentioned facts there and that gets us to our next point. Can you explain the difference between disinformation and misinformation because again this is very inside baseball but something that we get hung up on in the discipline. And again sort of bring it back to the role of platforms here in you, I guess helping us to pass disinformation and misinformation as you know as humble kind of audiences. So, typically in the literature or you know in general when we're thinking about misinformation. We're thinking about content that might be spread online that people might not necessarily know is false. So there's like a question of intent behind the different definitions of misinformation disinformation misinformation there's kind of like no ill intent to misinform people by sharing this kind of content, whereas disinformation there is some kind of intent to to misinform people and so we tend to talk about disinformation in the context of influence for an influence operations online because you know you have a state by actor that is purposefully injecting certain kinds of false information into the social media ecosystem and trying to get other people than to pick that up and share it maybe as misinformation because they might not realize that is actually true and so it can kind of like change depending on the actual intent of the person. It makes it like really tricky definitionally because you know intent is something that's really really hard to measure. But usually when we're talking about those two different terms we're thinking really about like the intent behind the sender of the message. So and again you mentioned, so you mentioned state actors there right so we're escalating very quickly from from me sending around a meme that is a little bit wrong to you know to Russia trying to meddle with our elections. And I guess this is, this is again a huge definitional problem when we're talking about this stuff because we are talking about an enormous range of actors and while you know attention may focus on Russia and Trump and whatever but a lot of this is sort of happening down low. And that's, I guess, you know the kind of the feeling for a lot of us I think that the horse is bolted. So how can I stop my auntie on Facebook from sharing anti backs means, but at the same time, you know be worried about election integrity in in a way that we understand, for instance, you know, or some kind of state versus state, you know conflict that's happening by a Facebook. How does, how does Facebook grapple with that as a company. And, you know, I think this is such a hard question where we constantly see the platforms really struggling to, you know, implement any kind of meaningful change to their algorithms to their business models to their systems because it is a hard question and you know whenever we're dealing with anything that has to do with speech. There's a lot of interpretation there's a lot of gray area. We're not only working in one language but you know Facebook is a global company with, you know, billion users that are not only speaking English but are speaking a lot of very localized dialects that are going to have different, you know, terms for hate and so on and so forth and so moderating all of that at scale is a huge undertaking that's full of all kinds of trade offs. So, in terms of, you know, what the platforms can actually do about it it's it's a very difficult question and you know I think a lot of when we're thinking about misinformation in particular which so often can feed into polarization and this affective polarization, you know, it's, you know, the platforms play a role here but you know we have to also think about citizens we have to think about government responses, it's really like a challenge, you know the fight for democracy is really something that we have to fight at all levels. The government's got, you know, if you know this is a big if I agree with that but if if there are state actors around the world looking at Russia. And, you know, I guess being impressed by by their internet activities you know by these sort of labs of citizens that they have pumping out disinformation. Is there a way to put that journey back in the bottle. Probably not. I think, you know, especially given like how ubiquitous and how important social media is for news consumption for entertainment for, you know, interpersonal connections for life for everybody really. I think it's like going to be really hard to put that G back back into the box and this is you know really one of the newest friends for this kind of interference and you know compared to traditional media, like traditional kind of methods for spreading propaganda.  You know, if we think about the data that you can collect about like how well your messages might be spreading and breaching certain kind of audiences. And that kind of information is incredibly valuable to propagandists right because you can do a B testing you can see which messages work with certain kinds of audiences. You couldn't do that in the past if you were dropping leaflets out of a plane like during World War two or whatever. You know who picked up your leaflet and why the message might have resonated that person with social media we can do that and you know we can target very specific communities of people with very fine tuned interest because of all the data that there is about us so it's kind of general socio demographic information anymore it's you know does this person like does this person like guns or do they like guns and live in the south and are between certain ages and like so on and so forth you can pull in so many different kinds of factors and because we have so much data about people you can do these kind of like big data analysis looking for various trends across these communities to really tailor that message and so all this to really like say kind of you know people who are spreading disinformation purposefully and using social media to do it are a lot more empowered now because of this technology than they were in the past. So the optimist in me says well you know the barriers to entry or lower for propagandists and they get more easily hit their KPIs because they have all these amazing metrics. But again something that we know from studying voters is that it's sort of a garbage in garbage out thing and if you're not really putting time and effort into persuading us then the benefits are low right so I guess the you know again and maybe it's a little bit polyannery shock me but if it's not changing voters minds then why do we care. Yeah, I think what it's one of the effects that it's really having is that it's not necessarily changing people's minds but it's giving, first of all, a lot of ideas that the fringe of the political spectrum that people do hold it's giving them a megaphone and it's making them seem a lot louder than they actually are and that loudness then allows other people that might share those political values to join on and to like bandwagon on to various cause and so it's kind of connecting people at the fringes a lot more than in the past because now they have a Facebook page or a group that they can join. They have an audience on Twitter with various hashtags that they can use. And so yeah not only like allowing these people to kind of come together at the fringes but then amplifying that kind of back into the mainstream, and then mainstream media, and others will often pick up these narratives and share them people will share and we kind of talked about this earlier because if something is kind of conspiratorial or room, like a rumor, people like that kind of content and so it's very much like a vicious cycle, I think and so even though it might not necessarily be changing people's minds immediately, I think, you know the slow day to day effects that seeing this kind of content over and over, and increasingly having these fringe ideas amplified can slowly start to widen that divide between people. I have a question in the chat that touches on that idea of how social media brings people together but can also sort of driver a wedge I guess between different groups and and that gets us back again I think to this idea of effective polarization because in groups and in groups do matter. So the question is from Sandra and she asked you know what do you think about linking polarization in the long observed reduction in social cohesion or what we might call social capital in the sort of Putnam concept like conceptualization and bowling alone and how we're sort of, you know we're atomizing as a society. In other words, social media provides a platform for social cohesion, when social cohesion expressed by active involvement in community groups has reduced or broken down. But it also permits an intensity and focus because of the way that uses a certain content which is exactly the point that you were just making, you know we'd be remiss to talk about social media today and not, you know, not touch on the fact that we're all here via that Samantha's here from San Francisco, the rest of us are here from our lockdown houses in Australia. There is something about the social media, about social media and these platforms and the way that it does bring people together. Yeah, definitely and I usually like to cite the Putnam article of bowling alone as you know. Yeah, why we like to, you know, and also like thinking about these trends more broadly than just social media that but you know polarization is something that has been happening before the internet and before mobile phones. We've had these kinds of growing trends, but social media can amplify a lot of these features just because of its various affordances the way that it like networks people and can bring like minded people together to opt into their groups. Okay, so you just mentioned affordances which is something that I only really learned about in the last couple of years and it's this idea that for some of us, social media is easy, you know we have the skills. We have that we can jump online we know how to download an app we know how to speak in the kind of way that the social media. You know fosters and then to enter debates online that you know that can create social capital or social creation. Can you touch on affordances and and how this are differently distributed across platforms and I guess how the different platforms sort of lend themselves to different types of social creation. Yeah, definitely so um yeah so I'll take kind of like the three biggest ones I think I'll do Twitter, we can do Facebook and we can do YouTube and yeah we'll throw a tech talk in there too. It's kind of all overlap in in various ways. So, you know when we're thinking about like Twitter and social cohesion and affordances, the way that, for example, the news feed and hashtags are structured. You can join certain group conversations using various hashtags that organize topics and conversations pretty much that are happening on Twitter and so that's one way that we tend to see some social cohesion happening, because they're very open and hashtags are very like can be read and viewed by everybody. I'd say that you know you don't have as like strong of an effect as you would say in like a private Facebook group where you're inviting members to join, or you might get vetted before you can actually participate in this kind of group chat on on the Facebook platform, whereas you know Twitter, any it's pretty open so anybody can can join it so you might have like some diverging opinions and things like that too it's much more conversational and so on and so forth. Facebook, when we're thinking about social cohesion and the way that it brings people together what is unique about it again is this kind of group feature or like even the pages as well. The pages are essentially run by one person that will push content to users, and then groups are things that anybody can kind of participate in and people will join pages or groups, based on their interests. You know they can be, you know about cats or they can be about politics they can be about vaccine misinformation or they can be about climate disinformation so there's all kinds of topics that people will join in and out of there. TikTok is a really interesting platform, because it's out the way I don't know how many people are on TikTok that are on this call but it's kind of you know we tend to think about TikTok as like one of the new forms for disinformation and all this kind of stuff, because it reaches a lot of younger generations the content is very viral, and it's not as it's kind of a new kit on the block so they don't have a lot of the same kind of like practices that a lot of other social media companies have and capacity as well. So, we tend to think of this as being you know some of the new fronts and TikTok algorithm will essentially you know you just scroll through constantly seeing a different videos it's organized by hashtags the same way that. Twitter is but it's less kind of group groupie and more based on tailoring content to particular users and so you kind of get social cohesion in the sense that you are targeted as being a person that you know might like dog content and therefore all you're going to get is dog content. We actually see a lot of news organizations and even like state backed media, like Russian state backed media creating accounts on TikTok and creating this kind of fun video content that will introduce children or teams to like what's going on in Syria. And so there can be like political angles and stuff like that on TikTok content as well. So very interesting fascinating space I'm kind of rambling right now but the point is that. It's really terrifying whenever I wonder under TikTok it feels like the Wild West and so I'm part of me feels like relieved that it's not just you know me approaching 40 but on the other hand, that feels like it's, you know, like it's going to foment a lot of potential polarization in kids. Yeah, you know, I think I was just like kind of scrolling through some of the channels like content earlier. And it's just so fascinating because it is kind of like very intro one to one fun content that's very much done in the way of other content that is appealing to younger generations, very catchy. And, you know, it's it's, it's just really interesting how they're like framing a lot of this disinformation to newer generations and this is the stuff that will, you know, when people are young, they're still forming their political identities in various ways and so it's just a fascinating phenomenon and something an area that needs a lot more research. This is great as the parent of a 14 year old and I'm not at all, not at all relieved by learning about this. And now I would be a very terrible employee if I didn't read my bosses, the Vice Chancellor is here, my bosses comments in the chat. Brian says that from his vantage point, the internet has disintermediated the curation of information and knowledge. So where we're kind of we kind of act as the gatekeepers, you know, information provision is becoming a lot more democratic.  And thank you Brian for keeping me on my toes. And that now the ecosystem, we have an ecosystem where information is ubiquitous and requires each just each citizen to make individual decisions about how they interact with it. How do we help citizens connect to information in a way that supports valid information and expertise and no I don't think you're being too elite for thinking this Brian I think what what we find in a lot of media curation is that people are time poor. And it can help us pass information, particularly in this sort of ubiquitous information environment where we're drowning in information. Anything that can help us to pass that and to sort the good from the bad is useful and the moment that that role is probably, well at least on social media is really passing from journalists and from editors and producers to platforms and algorithms. It sounds very kind of the robots are coming to get us but is that the case Sam or is, you know, would you, would you portray that differently. Yeah, for me, you know, I think, I think some theories from psychology can help us a lot here when we think of the difference between like system one and system two processing where I always get them backwards system to is, I should Google this. The slower slower and fast. I'm pretty sure system two is the slow one and system one is the fast one. So when we're system one when we're fast processing, we tend to not pay very much attention to the facts we tend to have an emotional reaction to the content and a lot of Facebook, or social media content in general is really designed to feed into that system one processing because of attention economics, you know, it's the stuff that just elicits an emotional reaction from us and so we tend to, you know, think with make decisions about things based on how we feel about them. So for a system to processing is this, or whatever the slower one is the slow processing that we do. That's when we start to stop, take a second, think rationally about what we're seeing and process it and come to more logical decisions about what we're reading and how that relates to us in our values. And social media does not promote that kind of slow, engaging, rational kind of content, because it's constantly just scroll more and more and more and more and more spend more time read things, watch more videos. And so, if we're thinking about solutions to get people to, like, be more rational about what they're consuming online. So the solutions really get to tailoring content or giving people content that will force them to engage in this kind of like slower rational processing opposed to the quick emotional processing that happens and so for me really. And it's not about slapping labels on to content because this is something that we see a lot of the platforms doing now it's labeling mis and disinformation online, labeling election related content and linking, you know, users to go to voting information centers, labeling things as fact checked. A lot of the studies actually show that these kind of practices have a lot of unintended consequences, and are not actually making people more rational readers of news. Instead, for me the problem again really just comes down to the business model of these platforms and the ways that algorithms promote a lot of this fast thinking content this emotional kind of content. So if we're out of that, then I think we're actually going to be able to see people be more critical and what they're reading online and help develop a lot of those skills that people need to navigate the wealth of information that now is made available to us. The interventions, the kinds of can you sort of elaborate on the kinds of things that you're talking about the kinds of things that we could insert. I guess into the platforms or into the ecosystem that might reduce polarization or might stimulate sort of critical responses or what we call sort of cognitive reflection. So, I think the co-pancher in the chat has asked about the sort of the viability of getting platforms to tell consumers how reliable the information is, or you know, the source of the information is something else that we talk about. So, you know, we talk about fact checking. We talk about these sorts of cognitive reflection tests where you know you every now and then you sort of ask to reflect on what you've just read. What are the things that break that kind of attention economic cycle. What can you just give us a quick overview of the different, the different possible interventions and what we know about them so far. Yeah, so generally speaking, there's so many different kinds of interventions that platforms have introduced to combat a lot of these problems. You mentioned labeling fact checking initiatives. We can talk about investments in news journalism that's something that we've seen a lot of the platforms do recently. There have been some algorithmic changes to downgrade certain kinds of content over others. If we, I guess we could start maybe with labeling because that's kind of one of the big ones that I see a lot of platforms do, especially, you know, in the lead up to elections is introducing a lot of these election related labels and kind of related to this is like the third party fact checking because platforms will partner with third party fact checkers and then label content that has been reviewed by the third party fact checkers as being false or misleading or, you know, whatever the appropriate label is and so when we're thinking about labeling as a strategy to reduce mis and disinformation and therefore kind of combat polarization that way. Labeling tends to have a lot of unintended consequences. And so one of the studies on labeling has shown that if you label content, it tends to decrease people's overall trust in all news. So it's not just that we're making people critical readers of news from maybe fringe or far right or far left websites, but we're actually making people skeptical of professional news as well. And so that might not necessarily be good either because you know we want people to have high trust in professional media and professional journalism to an extent. So labeling can also if everything is labeled but a piece of mis or disinformation makes it through unlabeled. That can also have a negative consequence because people is called researchers who did the study call it the implied truth effect where content that is false but unlabel is sort of trusted as being true. So if platforms just mislabel something they miss a piece of content that's going through their automated filters, people might interpret that mis or disinformation as actually being true because it's not labeled. So one area where labeling does help is that if users are given a prompt that something has been like back checked as false or as misleading, they might not actually share it. So that's one of the positive sides of these labeling kind of studies is that we can actually reduce the amount of sharing of mis and disinformation by labeling content. But you know we have to kind of think about some of these unintended consequences as well when it comes to the labeling practices. And you know and so I think you know fact checking kind of goes in hand in hand with a lot of those responses for me I think the most promising things that we've seen platforms do and do relatively well that I think you know they could do more of has to do with like investments in news and journalism. For example, removing paywalls for people who want to access local news. I think that's a really great initiative because you know one thing about the internet to is that it's made information free and nobody wants to pay for news anymore if you can just find something else online for free. But newsrooms need that kind of subscription they need that paywall to help fund a lot of their work. We can't just completely cut off their modes of financing right and so by platforms kind of covering the paywalls or like the some of the paywall costs for users to access that content. That's something that is positive and can help educate users because now they're not going to if they click on an article that they want to read, they don't have to worry about the paywall anymore they can actually just read and access that professionally produced information. The other area that I think they can do more in again has to do with the the algorithms because they've, you know, made several attempts at, you know, tweaking their algorithms to maybe not share as much political content and news feeds and the lead up to elections but then, you know, the question is how do you define the digital and there's just so much stuff kind of around either the way that this negative viral content test is spread that I think platforms really need to do more in but they're just disincentivized not to because it's their business model. Thank you so much Samantha for for being here. Thank you for coming, you know, for our breakfast and your pre dinner. Thank you so much everyone who's attended thank you to the Crawford School and to the ANU for putting this on. Any more questions that you want to ask Samantha I'm sure you can get in touch with her either on Twitter or via email stalker on Facebook. I'm a don't stalker on Facebook. If you want to get in touch with me. I don't know why you would but I'm very easy to find. We will let everyone go and have their breakfast now thank you so much and we'll see you for the final panels in the leadership forum this morning.


Hey guys, welcome to SS Unit X to see this side and this is continuation of SQL Server real-time scenarios So today we are going to see how we can validate the first time login and second how we can validate login with the encrypted data So basically in the last video we have seen how we can do the encrypt and decrypt inside the SQL Server on the data level So if you haven't watched that video, so I would strongly recommend to watch that video You can get the link right on the top side Now go to on the SQL Server and we will try to implement these two So if you have remember in the last video we have created this login detail table And here we are having four columns, first is the business entity ID Second will be the login ID Third will be the login ID hash value And fourth will be the password So these four columns will be going to have over here Now we need to create one more column on this So that we can alter the table So that will be like alter table Then the login details And here we could add one more column And that column will be going to have flag as integer So this will be going to indicate if user is going to login the first time or not So we can execute that And now let me try to execute this So as of now it is having blank values on this flag Now go to here and let me try to create one SP And that SP will be going to take two input parameters First is the login ID and second will be the password For example, if user is going to login on the UI side So that user will be going to supply the user ID and password And this SP will be going to check if that user is login the first time or not If user login the first time then we can return one If user is successfully login then we can return two Otherwise we can return zero So it will be going to return three status So let me try to create the SP Let me try to comment this code first And after that we will try to create the SP So let me try to create Then we can specify proc Then proc name So as proc we can start with that Then we can call this SP as Validate login users like that Now let me try to have two input parameters The first parameter value that is login ID So we can have this login ID And the data type of this should be Wirecare 1000 Next will be the password So we can have this password And after that this will have Wirecare 1000 again Now it looks good We can start our SP Like that Now Here first we need to check If user is login the first time or not So for that how we can check that So basically we can declare a variable And that variable will have flag And data type should be integer And default value we can set this as zero Now Here what we need to do as If you have remember the hash key For the decrypt or encrypt is SSUnitec So this will be the hash key value Now what we need to do first We need to check if Exist Then we need to check select One from our table So table is login details And here we need to check Where login ID Hash value Should be equals to With the login ID From the input parameter And password should be equals to At the rate password So this will be going to check And flag is none It means we are going to login The first time on the system And we need to check one more thing Like and at the rate password value This value should be SSUnitec At the rate one to three Now it seems good Now what we need to do here We can have begin Then we can set At the rate flag value That should be one And we can have like and So we have done for the first time login Let me try to copy this code We are going to check For the second time Or for the validate purpose So here instead of using this Flag and this password We can directly remove that And it seems good now But here as we have already know These two values are the encrypted values So we need to do the decryption on this value So how we can do that For that we can call the function As the decrypt By pass pass So here the first that will be the Has key value So that value is SSUnitec We can specify directly over here And after that we can close the bracket Now we need to do the convert On this as well So we can cast this And here let me have this as And where can 1000 Now everything looks good Let me try to copy this And paste that in the password And instead of the login id We can have the password Now let me try to Copy these two lines And use the same on the Below check So here If this value is going to satisfy Then we can have this as 2 So now it seems good And We can directly Select this Add the rate Flag value And call this as Status Now everything looks good But here we need to focus one thing First it is going to check for this And second we are going to check for this But we don't want to Check these two again and again If user is going to login the first time Then it will check only the first code And will return from there So how we can do that So here we can create a scope with the SSU And colon And here We can directly use the Go to SSU And Here We can directly use Go to SSU So this is the standard that you could follow So what this SP is going to do First it is going to take two input parameters Like login id and password And here we have declared this variable That is Add rate flag and value default is 0 Now it is going to check If the login details table Will found this login id and password And after that if the flag value is null And Password is SSU to take Add rate 123 Then on that scenario We can directly go On this and say Flag value as 1 And we can directly jump to the SSU Without executing this second code If user has been logged in And change the password And in the second time for example He made the change on the password And in the third time he made the password again With the SSU But this flag value Will be going to change And it should not be null So this first condition will not be satisfied So it will go on the second code And here it will be going to check If that value is satisfied with the login id and password Then it will be going to set flag as 2 And will return directly right here So let me try to execute this So everything looks good Now let me try to execute this sp So how we can do that Here we can call this Execute and after that we can call this sp And after that here We can specify the login id and password So for the login id and password First let me try to Select this and execute So for the login id let me try to Compete this login id And for the password Obviously it should be SSUnitecAddRed123 Because this is going to login In the first time So that's why it is returning 1 If we have 1, 2, 3, 1 again So it should be going to return as 2 Because we don't have any password With the SSUnitec1 So by using this flag July person can check If the flag values are 0, 1 and 2 So accordingly he can Directly jump and navigate Between the pages that That person is created So here I hope you have Understood how we can check for the First time login and How we can check for the Validate So we will be going to check if We will be going to get the Status of this as 1 So it means the user will be Going to login as the first time So we will need to create one more SP and on that SP We need to create the update statement Where we will directly update This login detail table So that we will see in the next video Thank you so much for watching this video If you like this video please subscribe Our channel to get many more videos And don't forget to press the bell icon To get the notification of our Newly uploaded videos See you in the next video


Babe What are you doing? I can't do this anymore, Brian You know what time it is. I can't do this anymore. It has been five years and nothing has changed Candy We just moved in with each other. Oh, please My name is on the lease. Everything is in my name.  Hmm. This is what you're looking for Give my phone come and get it then Can you stop playing give my phone come and get it Brian? You won't play this game.  I can play games, too unlock your phone Come on. Can you stop playing what I said? unlock your phone If not, I'm done Come on. Can you why you always trying to start something? Why can't we just have a nice weekend for once? unlock Your phone Really Brian?  Huh You couldn't even post a picture we took you have to understand that you have a guilt you have to understand that you have a guilt and You have to have the audacity To use your guilt and you have to use your guilt The way that it makes sense to you. That's the other thing is that when you're doing this work You using your guilt you can't just be about What are you doing? I'm trying to write this paper for school. How's it going? It's going well, but you know writer's block, so I Don't know Brian, did you hear me? Yeah? Hungry man You cook so I Just said I had a paper do Look, there's leftovers in the fridge just turn something in there candy Yes, Brian You really ain't cook anything. Oh my goodness.   No, she messaged me the other day and said you hadn't come and by in a minute to get baby Michael Because y'all got into some kind of argument. I told her that I would talk to you today, but um My thing is What I'm trying to figure out is where were you all those times when you say he was gonna go to her house to see baby Michael hmm Or how about all those times when you say he was gonna go to your father's house and spend the night with baby Michael Brian, where were you? Huh?  It's a yes or no question Are you still messing with Michelle or not? Brian no, oh Big be getting mad If you was telling the truth then why'd you have to lie? You know what I'm out of here and where you gonna see in the morning tomorrow morning, then where are you staying? Don't worry about it. Brian if you leave I'm done Brian Let's call him Like


Welcome to Reiki Energy Healing for Horses. For those unfamiliar to me, my name is Anna Twinney. I'm a natural horsemanship clinician, animal communicator and energy healer. Reiki has been part of my life since 1998 and I have been attuning students for a number of years. It became very apparent to me that many of my students didn't feel comfortable in taking their healing to their companions. And so I devised this program to help them along their way. They weren't sure about the behaviour patterns, the signs and signals, the communication, when and how to ask permission, how long the sessions needed to go on for and when it was appropriate to facilitate the healing. And this is how the Healing Horses DVD came about. I chose horses not only because I'm a natural horsemanship clinician, but also because horses are really true and close to my heart. They reflect our authentic self. They help us be authentic. They are our true mirrors. So for the purposes of Reiki, we allow behaviour patterns to come through. Think the individual has had enough Reiki, you can check in that way. So your safety net is your sway test. So if they walk away and they get a bit of water and they want to come back, you can check in. You might think, oh, they've walked the water hole, they're done. They might be in with the sway test. They might be impatient. They could be bored. They could be anything that's not comfortable to them. They might want to eat or something. They might want to go back to their friends. Anything that says, hey, I'm not comfortable on this spot.


What is going on guys welcome back to the channel critical overlord here. We're gonna talk about the recent interview Jason Blum had today sitting down with Phantom entertainment he disclosed tidbits and the definitive reason why we haven't gotten a trailer When we could expect to get the trailer for Halloween kills and he's talked about a plethora of other things but we're just gonna focus on the Halloween kills trailer and my thoughts on that and What I think this means for the film going forward So as we all know halloween kills is still set to be released on October 16th of this year Jason Blum reinforced that in the interview he had 3c films was actually featured in it. He didn't talk about halloween kills I just wanted to again mention the fact that 3c films was involved in a shout-out to 3c films subscribe to his channel and then he went on to talk about how The trailer for halloween kills someone asked him when could we expect the trailer for halloween kills to drop and of course He has heard that question a thousand times and he's been dodging it But if you have that question come up, he's gonna direct directly answer it now, so We are not gonna get anything until universal is a hundred percent certain of when and how they're going to be able to Release this movie. So while October 16th is still the scheduled release date That again is subject to change Depending on the climate we're in in the coming months depending on what's going on in the world depending on how the outbreak is going depending on the level of control Whether it has to do with shutdowns any other implications that may hinder a theatrical release or just an overall income putting this movie out which I pretty sure they want to make a If not more than what they made from the last one because I found that mistaken halloween 2018 is the highest grossing slasher movie at the box office right now currently it holds that record and They want to of course, I'll do that I'll perform what they did with the 2018 film So with all that in mind that adds on to why their little universe will be a little bit hesitant to just go ahead and release Want to have trailers released blumhouse also wanted to have trailers released if the release date of October 16th 2021 is subject to change Which we know if this is a very fluid situation in the reality we're living in right now They're not gonna want to put a trailer out Start up the campaign and then come September a few weeks ahead of schedule or a few weeks ahead of the release Pull the plug and say all halloween kills were delayed till October next year But hey, you know the promotion in the campaign was fun. See you guys next year. They they don't want to do that They don't want to build up build up all this height unless they know for certain the movie's gonna come out my reaction to this is If they know for a fact the movie is coming out in less than a month before its release We it's it's a very good chance. I It's I've never seen a movie done do this actually I have I've seen a movie do this. I think Crawl did this if I'm not mistaken crawls trailer came out just a few short weeks before it came out I might be mistaken in mixing up with another movie But it's very rare that a movie puts its trailer out like a month or a few weeks before its release Especially if it's going to theaters and especially if you have like a backing like with what with halloween kills And the halloween franchise in general the character of michael mires and how iconic it is um We could potentially be looking at us not getting the trailer till September or august Possibly the earliest late july I don't think we're getting the trailer this month a lot of people were thinking we were going to get it this month Talking about it coming out tomorrow. That's of course been shot in the foot With jason blund. That's been that's been brought to a complete halt with this interview he had today with phantom entertainment The likelihood of us getting the trailer this summer is Kind of moderate the earliest I think we'd get it is late july The after that the soon as I can see is getting it is late august late august early september Just in time for a theatrical release, which is a month away um And it'll be really really interesting to see what they do because at that point They'll probably already have a decision made on what they're doing We'll probably find out tidbits of the fact that if the if it does come out like a month before its release We could be looking at two situations a situation where it's going to have a limited theatrical release And then it's just going to go straight to vod It might not go to theaters at all. It might just go straight to vod And they might do something very interesting to of course maximize the amount they could get at the box office From vod uh sales but also keeping in mind that When you have a movie that is released on vod You're heightening the chances of you not getting a return in profit due to do the piracy that's going to go on But in my honest opinion, I feel like Certain movies Such as this I feel like this movie is going to make if it went straight to vod Something I just don't know. I have a pretty good feeling it would make a decent amount in return If it went straight to vod not as much, of course, it would make if it went to theaters Uh, it'd be a severely high difference if it just went to theaters and another situation we could end up looking at is Of course them pulling the plug The the what they could just end up doing if they are going to be pulling the plug if they want to play the part Very very safe We could be looking at a situation where all we get is a teaser trailer All we get is a teaser trailer And if the plug has to be pulled they can pull the plug and we haven't seen too much of the movie Not too much hype has been built around it other than the hype that we as fans and moviegoers are building for ourselves They can just pull the plug is At that point they wouldn't have had a full campaign up and going We just got a a quick teaser to tease people that it's coming soon And then if the release date sticks with this, uh With this october 16th date they can just put it out If it if it gets pulled they don't have too much to worry about because they didn't show too much to get audiences excited They didn't have a full blowing campaign like with a quiet place too And then having the whole thing ruined Not necessarily ruined or tarnished, but it's kind of like you you're doing all this work for nothing They don't want to end up in a situation like that Because when a quiet place too got pulled that was very gut-riching not only for the people involved with the film But of course us as fans who have been waiting to see a sequel to a quiet place since the original came out in 2018 So for all this hype and all this promotion that they have been doing To have the movie get pulled Just when it was about to come out my I was actually scheduled to go see the movie that week when it got pulled I was going to see the movie Not that week, but the week after I was gonna I was going to a And a press screening a invite only press screening to see the movie before it was out to the general public And I got the email that it had been pulled. It would no longer be getting released in theaters this very uh heartbreaking and very disappointing And universal blumhouse like they don't want to end up in a situation like that with halloween and with michael mayers So they're probably going to play it very safe if they do release anything. It'll be minuscule teasers probably clips voiceovers Like they did when they made that that announcement with the fact that we were getting back-to-back sequels They could do something again with that Where it's just a very minuscule 30 minute or a minute and 30 type of clip Maybe something similar to what nea de costa just did with her candy man movie We're not she that the the trailer that just the teaser trailer that just came out for that film Is very brilliant very well done very well put together Cinematography is amazing. You don't see too much of the movie And I feel like what a lot of people are doing is they're coming up with more creative ways to promote their films What I appreciate about this is it's a very creative way to promote your movie without showing too much of it reminding us of the mythos of candy man And at the same time you're not getting us all excited for a movie that might still get pulled from this september release date that it holds Hopefully universal and blumhouse can do something very similar with halloween kills Where we get a teaser trailer that is over two minutes or maybe a little over a minute and 30 seconds where we are just Reinforced the idea of the character of michael mires. We have a voice over From a certain character From cast members other people involved with the project to kind of just heighten the heighten the uh excitement But not at the same time it's a teaser that doesn't show too much For a movie that might get delayed again but I'm still pretty certain this movie will come out in october If anything, I don't think it'll get delayed. I think they might just settle for vod If they do delay it So be it I I do think that they they would risk it with just putting it out on vod because of the fact that Even if the release date is secure We still don't know if amc or regal cinemas are going to be showing these movies now In my honest opinion, they probably are Because they can't afford those two theater chains cannot afford to not be showing movies right now But let me know what you guys think about all this down in the comment section below If you haven't already make sure you subscribe return on post notifications today never miss a video in the description I have links on my social media accounts about facebook twitter and instagram you can message me there to let me know There's any movies news or reviews you let me to cover in the future with all that in mind guys I will see you in the next video


back on it now look he's about to eat it yeah you got it you got it oh my gosh that's your pv today we're going to be fishing with some big swim baits for some really big bass this is actually a pond that i've had a lot of good luck in i timed it perfectly the last few times i came out here and there was a lot of fish on bed and i thought it would be cool to come out here with a swim bait and see if we can get some of these really big bass to pull on this and i also got a little secret in today's video that you guys will find out throughout the episode that's pretty cool i think you guys are really going to enjoy i got this paired up on my kick in their bass x lose combo we have right hand bait casters left hand and also spinning combos if you want to check them out they're only available on kickinthearbass.com i have the link in the description box below and for everybody that has purchased the combo or purchased any merch off of my website i really appreciate you guys thank you so much for the support it really helps me out and it means a lot to me but we're going to go ahead and get after this and see if we can catch some big bass on swim baits let's get after it first things first let's make sure our combos set up tighten our drag down a little bit it is very windy today too guys even if these fish are on bed it's going to be very hard for me to see them or i might have to go into a different spot to where it won't be as windy i think that's fine i usually set my breaks between two and three i'm gonna i'm gonna be honest with y'all most people are probably gonna go between five and eight i like mine between two and three that's just what i'm comfortable with i like my reel to be in a lot looser so we're gonna go ahead and get after it i want to see if we can catch a big one on this mag today you know this is gonna be a lot of fun this is a mag draft you guys know this is one of my favorite swim baits and uh i'm just hoping we get a big one on it swim bait fishing is so much fun but let's go ahead and get after there's some bait popping right there i don't know if you guys saw the there's actually some bait popping right there right before i casted that's a good little sign i don't know what to expect today guys uh hopefully the fishing to be good and hopefully they'll pull on the swim bait you know it's one of those things too that if they're not eating it too well obviously we're gonna have to switch up to something else and try to catch some fish but i'm gonna really give the swim bait some time and see if we can put some big bass on the bank yeah there's a really big one right there i was washing swim off he's boiled too that fish i'm telling you has been there for literally like two months so weird it's definitely not the same fish but there has been like a five plus pounder sitting there for almost every time he's pulled up and he's been so finicky every time i can never catch him i just had a nibble right there that's exactly what that was he just hit the tail of me so now with us knowing that there's more than likely a lot of fish on bed in here guys i'm i'm gonna really stay off of this and keep throwing it there we might be able to trigger a reaction that was more than likely a bass on bed that just nibbled at the tail went and went past them so instead of us walking right up on that fish and spooking them we're gonna stay a little further off kind of play with them here see if maybe we can trigger them to bite i will say i've had experience throwing a mag draft on beds in the past tends to really irritate the bass so it's a very weird way to catch a bed fish but i've done it before and i've actually caught an eight pounder on bed with one it was actually the eight inch one this one's a little small there's definitely a method that i've proved in the past that we might be able to get on really good today oh my gosh wow wow wow wow he saw me and i saw him that was about a six seven pounder guys and i see him right there on the right oh my god there's two of them one of them's even bigger dude oh my goodness you got two big bass what i can't tell what the size of one of them is one of them's freaking megalodon they're both big they do not like this swim day maybe i've seen a skate putt right here and keep casting until i irritate them it might be their bed right up there i think they might have both followed it off which is interesting usually when you're bed fishing with any other normal bait you don't see both fish follow it off bed you usually see maybe one follow it off but having this swim bait with it being such a big profile it irritated both those bass you could tell those were some big ones guys this that was no joke that's what we need to be getting into there are a couple beds up here so i'm assuming one of these beds are those i just wish it wasn't windy so we could have a clear vision on what's going on here all right guys i will say i think it's about to get in the zone right here i think everything's about to shift we're about to have some excitement coming up keep your eyes peeled right here you're about to see some crazy stuff guys i've came to a conclusion and what's going on i don't want to speak too soon these fish look to be as if they're done bedding i think i saw maybe one maybe two after walking about the whole pond but i'd say 95 percent of these fish are done bedding or they're not pushed up on beds i have seen a ton of post spawners of look how skinny that fish is compared to how big they were a couple weeks ago that was awesome to get a bite though and i bet you that this is a fry garter right right to what i was about to say i've seen a lot of these post pond fish and these fry garters just protecting their fry you know you'll see a big group of fry and a big bass around it and that's exactly what we're witnessing that is a nice bass to start off the day on that mag drop he is bleeding a little bit i hooked him in the tongue sometimes it's a little weak spot for a bass but we're gonna go ahead and get him back in the water i'll release him over here what a way to start off the video guys it took us a second but we got us a fish on the bank on the old mag big swim bait action thank you baby there we go let's get it boys by the way if you guys haven't already please hit the like button it really helps out the videos guys and it and it really makes it worth me putting these out and i'd really appreciate it it's as simple as going down there and just pressing the like button if you guys could do that i'd really appreciate it if you guys are new to the channel hit the subscribe button if you're already subscribed hit that little notification bell you know those little things either help out the channel more than you guys would ever know and if you could you know drop a comment down below interact with each other or maybe you guys have some cool video ideas that i could be doing or maybe some tips for me out here you know uh whatever you guys want to comment down below i'd appreciate as well but we're going to continue to fish you know i walked almost this whole pond and i've seen a few fish i've seen a few really big fish but it's just they're not positioned on how we would want to catch them right now i was really expecting to find some more bed fish and that is not what we're finding find a lot of post spawn action and a lot of uh bass protecting their fry which can be a good thing too you know some of this fish get very territorial and very uh predator like when they're around their fry and you tend to catch them really good but none of those fish really wanted to commit to this bait it could be awesome me throwing this big swim bait we're not going to get as many bites oh my good that's a big one i'm about to say that was a freaking bite oh yeah that's a good one boys let's get it baby that's what we want to see he's strong too oh you a strong guy oh he's not as big as he looked out there he's a good one though he's a solid three pounder nice that's a high two pounder i ain't gonna give you three buddy you a nice fish and thank you for buying man and you could tell guys if you go back on the videos from the past couple of weeks and you look at the size of the fish like this fish a couple weeks ago he was a solid you know i'd say three pounds right now he's only about two and a half he might be two and three quarters if we're lucky but while we're on that topic and there money's bleeding i'm about to say he's bleeding we're going to get back in the water that them tongue hits with the hook this best do not react it's not like i get them in the throat look it's just literally in the tongue and they'll cause them fish to bleed it's the weirdest little thing but that is sweet guys look we went from fishing this whole pond we fished almost the whole thing did not have in a bite we had like a nib we had a few followers we saw a few fish to catch in two bass pretty much back to back that's a plus right there and let's uh let's keep this day going wow that is awesome and i will say that this mag gruff feels great on this kicking combo if i was using the eight to ten inch mag i'd say that i'd probably need more of a heavier rod but on this combo this one feels great i think i'm gonna sit here for a second guys i'm really fancast this pocket with a lot of these fish being postponed they've pulled off the bank slightly and a lot of these fish that were right here on the edge of this grass up on bed could have pulled off to more of this edge to more of those points the more out in the middle so oh gosh yeah see we're we're figuring them out you see my rod too don't follow it in right here boy yeah they're these post spawners are hungry too i'll tell you that man let's see if we'll eat me again guys he hit me two good times right there and you see where i casted that's about 10 15 foot off the bank out towards that point we're still in this pocket if you notice that but we're casting further off the bank now you know we're not we're not sitting here flipping a worm up on this grass you know that's one thing i did while fishing a majority of the other side of the pond is i was fishing up shallow you know i was trying to find some of those big old heads that are pushed up in the grass but maybe our best bet is to start throwing out in the middle more off the bank and catch some of these fish that i've moved off you don't want him to see us too much but the part that you want you want to irritate this fish so i'ma watch i'ma really right in front of his nose you see him turn on him now don't move your bait but just reel your line a little bit and just barely shake it he should pick it up right here shake it shake it oh he turned off of you or keep your bait there and just keep doing what you're doing yeah these fish are on bed you're gonna be able to oh he's coming up he's about to eat it he ate it oh sorry all right he's probably not gonna bite again that was about three pounder but there's a there's another one you know what i mean you got a male and a female see the other one now oh yeah he pulled back up he might be be able to bite again this is the one time a year that you can kind of get a fish to bite once you miss him oh my goodness oh my goodness she's finicky you see that we're just gonna keep it there don't do anything just keep it there she's on her nose up to it yeah pop it one little time she she ate it she ate it yeah you got her you got it watch all my rods behind you all right oh my gosh all right you're in a lander right here and i'm gonna grab her for you just let her fight you're good you're good just keep that pressure on her all right you got it that's a monster i can't tell if that's the big one i mean it's a monster don't get me wrong be careful yeah that's a big one that's a big one look at that thing are you scared of it no i can grab that thing grip her hard she's gonna be a little strong she might kick you got it yeah nice that's a big one ain't it that's your pb that is all day long yeah and first fish of the day good job i'm gonna grab that scale i'll be walking she gonna be okay yeah she gonna be all right i mean wear her real quick and then get her back in the water good i think it's probably i did not know she was that big from over here i don't know if she's five yeah she's four four and three quarters four pounds eleven ounces beautiful still a good one yeah what do you think i love her good job that's a big one in it oh she's off that's sweet you know it's crazy that's the small one that was a male that female's bigger yeah big one good job thank you you want to find more yeah do it yeah there's a big bass right there you want to catch it no you get one you want me to catch them real quick you're ready watch this oh my god look at the boil he didn't eat it that was crazy did you see how hard he boiled there yeah they're big that's gotta work on a second so look you know they pulled off so you see all my baits still there yeah like he's back on it now look he's about to eat it okay that's a monster that's a monster oh my gosh the other one's bigger this is the male that's a five six that's not crazy the crazy thing is i think this is the i think this is the the male and that's like a five pounder no way all right guys it's a pretty big bass we got some good ones for for two of our fish i think it's bigger than the last one yeah he's gonna be five yeah yours was 411 it looks bigger i'm gonna take a guess this one's gonna be i think it's gonna be 501 if he's not he's a high four but i think he's five he's 501 yeah look or five two he's five two that's awesome all right five pounder guys we got her a 411 then just got me a solid five two right here that's crazy guys some big bass on bed in florida you gotta love it that's a good one let's get this baby back in the water five two gotta love it there's another big one over there gosh that's a big girl gotta love that right there all five pounders and we have the scale for y'all today i know you guys like that that's my little surprise oh i got one thing's really big i can't tell oh yeah it's a good one you can't tell how big he is he's out there in the middle he's fighting on hey not in that big i mean he's a good one but he's not big he is fighting chunky two found another one on the old worm that's fat it's a really healthy fish nice one he's right out there in the middle oh that's a good one yeah flip one up here nice gosh that's a good one there you go hold him out that's a good one yeah it's a really good one that's like a three three and a half pounder he was far out there you don't fall you're crazy what a release you're professional or something