We are going to start out with a series of slides and follow that with a video. Of course, the slides and also the video are silent. We will provide the narration. And we hope that what we can do, although it's not totally adequate, but what we hope to do is show you a slice of what it's like to be on orbit and to conduct a mission, a fantastic mission such as STS-80. So if we could queue up the first slide, we'll get started. Well, the one thing we know is that you can't have a mission until you have a patch. And I was assigned as patch chairman on this flight, so my goal was to come up with a patch that told a little bit of story about the mission. And before I get started, I can't necessarily take credit for this design logo. Mike Sanny, who was an artist for Lockheed Martin, has moved back east now, came up with this design. But what this design tells you in the center top portion of the patch is Orchya Spa Satellite, the spectrograph astronomy satellite that we deployed on day one. Connected it at the bottom of the three red lines, which are a portion of the astronaut symbol, and those are there to represent in fact the astronaut office involvement with these satellites. The two satellites we took up were both free flyers and for a large portion did a lot of science on their own. But we would like to emphasize our portion in getting in there and help conducting the science. The bottom portion of that is the Wake Shield Satellite that the story was deeply involved with the entire time it was deployed. You'll notice in the dark blue background there are stars, there are 16 white stars representing a day for each, one star for each day of the flight. There's also two larger blue stars, which were to represent the EVAs. And I've got to tell you now, when I put those on, I was also hopeful that we would wind up with the record duration mission. So if you count those two, that's 18 days and in fact that's what our mission turned out to be. Pretty clever. I did that on my last flight and we didn't get that extra day. And then lastly, around the perimeter, the gray area where the names are encompassed, if you look at that and kind of remove the shuttle, you'll see a sea. And it's kind of appropriate that that sea stands for Columbia. The commander, Corporal, also enjoyed that sea. And then obviously the center of the patch, what we really wanted to tell also was the space shuttle mission and there's the on orbit configuration of the space shuttle while we conducted the science. We can go on to the next slide. We took off on a beautiful day in the afternoon in Florida and this is probably about three seconds into the flight by the time we get to the top of the tower we're going 120 miles per hour. But the real excitement for the crew is during those last three or four seconds prior to the booster's light. I think NASA does a countdown so that it can make the crew more scared when it comes time for the boosters to light. But we were in the hooping and hollering mode at this point. One of the first activities during the mission was the deployment of the Orpheus Spa spacecraft. We grappled the spas about three and a half hours into the flight and we were set up for a seven hour deploy. We ended up deploying about eight and a half hours to get some of the ground configuration corrected before we did the actual deploy. But Orpheus Spa is a spacecraft that was born out of a joint agreement between NASA and the German space agency and it consists of the Spa's carrier and the Orpheus suite of telescopes and instruments built in the United States and in Germany and they take ultraviolet spectra or look at light of higher energy than optical light of things like stars in our own galaxy, other galaxies and also look at the material between the stars to get a better understanding of the star formation process. Well along with the deploy came a fairly large photo TV requirement overhead and that helped to make our day one not only busy but very busy and this is a photo of Tom in the middle of that nest and as a matter of fact along with that went a five record set up. He's holding a checklist and I'd like to mention Martha May she designed this checklist and without her help we would have never pulled this off like we did. We'll skip ahead a bit here to flight day four and we were busy here deploying the wake shield facility our other prime payload on the flight and I'm operating the RMS controls at the aft flight deck looking back into the payload bay and we deployed the wake shield after a long period of orbiter free drift where we didn't fire the orbiter's thrusters to keep contamination of the wake shield's experimental side to a minimum and it was a very nice ballet designed by our friends in mission control to put together this ballet and choreograph the release of the wake shield while we maneuvered the satellite to the various positions on the arm required to get it in deploy configuration. Here you can see the wake shield being unbirthed from the payload bay and we removed it from the protective cone in the back of the payload bay that kept the experimental surface the growth surfaces free from contamination during the launch pad stay of the ascent in the early part of orbit and as we lift it up here we go into a complicated sequence of maneuvers to clean off the experimental bottom of the wake shield or the wake side of the satellite and story will tell us a bit more about that science. Here's the wake shield after Thomas released it management the wake shield program and the science that's conducted on it is out at the University of Houston it's manufactured right across the water there in South Shore Harbor by spacecraft industries a wake shield is a satellite to study the manufacture of semiconductor materials out there in a perfect vacuum of 10 to the minus 14 it's a battery operated it has thermal passive system it has its own attitude a termination system that looks at Earth horizon and it controls its attitude with torquers the orange structures that you can see magnetic torquers and a reaction control wheel it performed absolutely perfectly on this mission operating wake shield we do that using portable computers I used a pilot seat here and I strapped two personal computers to the pilot seat and it looked something like a pipe organ where you had different kinds of keyboards one of those computers was used for monitoring the system and the other was for sending commands to it the scientists and mission specialists on the mission were real excited about the science on going on the wake shield but the pilots were pretty excited about the fact we get a rendezvous with it to pick it back up so here's taco at the aff station on rendezvous today on flight day 7 the wake shield had accomplished all the science it attempted during this mission which was a pretty aggressive schedule and tacos at the aff station flying that rendezvous on flight day 7 it's not a one person show getting rendezvoused with an orbiting satellite of course it's a team of scores of people on the ground and in flight and each crew member's got a job to do and in the case of this flight we wanted to take some independent measures of the distance of the satellite and the rate that it was closing on us and we use a police laser speed gun to do that that's exactly what that is it's something you may have seen face to face in your everyday walk of life and it's a very accurate machine and we had Tammy stretched out across the cockpit looking up at the two satellites on each of the rendezvous measuring their speed and the distance from us meanwhile somebody has to run the show while I'm back having fun doing the flying and up until the time that we take over the manual flying Rommel here in the commander's seat did the trajectory adjustment burns that are used to get us right on track to be ready to rendezvous with the whichever satellite we're going after and he also monitors all the systems on board Columbia which I might point out we're working perfectly and gave us no trouble at all here's a shot of the wake shield just after grapple and we're swinging it from the grapple position into the payload bay again to be birthed on flight day 7 in the background there it's a very pretty view of the Pacific Ocean the Gulf of California on the right and the island off the coast of the Baja Peninsula is the island of the guardian angels in Mexico and we had a spectacular view of the wake shield orbiter and the earth below throughout all of these phases of the flight and it just takes your breath away when you're trying to work in the payload bay and something goes skimming by in the background is spectacular as this here we have our wake shield RMS operator Tom did all of the RMS operations on the wake shield and here he's performing some attached ops meaning the arm is attached to wake shield the day after we did the retrieval and you can see the wake shield through the aft window and the tail and of course all of this is done against the backdrop of the earth as we orbit around it this slide's in here to represent some of the mid-deck science experiments we had on board and especially mid-flight days 7, 8, 9 or so we had a pretty large host of mid-deck experiments the one that Tammy is working here is called Vue CPL it's a capillary pumped loop which the concept of it is to try to prove out that we can in fact pump a loop to remove heat from instruments in space without using a mechanical pump but rather using the fluid mechanics properties as well as heat to drive it prior to doing a space walk we do an extensive checkout of the instruments and the life support systems on the back several days before going to do the EVA we also configure and un-stow all the tools and arrange them in the airlock so that we've choreographed that tool flow before going out the door this is EVA day here and Tammy's getting suited up and you can see me in the picture too my hand down there to the left putting on Tammy's glove getting suited up all the suits, all the tools everything we did on board performed absolutely flawlessly and they were ready to support a space walk well as everyone knows a screw and a mechanism in the hatch precluded us from performing the EVAs and Tom and I had a lot of creative ideas about how we might actually get that hatch open and we also had a number of tools on board not just the EVA tools but the IFM tools and so we went looking through the bag of tricks and chose a hammer and a crowbar which also might be used as a chisel and took this photograph and just as if we were going to go and take one more crack at the hatch before we called it a day providing up the slides to see who will talk about them it's normally a democratic process but the vote in this case was four to one that I would be the one end up talking about this washing your hair on orbit turns out it's not much different than washing your hair down here especially for you story especially for me but you don't want to put too much stuff on it because you haven't got that much water to get it off but it's somewhat like washing a car you get too much soap on it down here but some people wash their cars and other people polish them and Tammy took the liberty of converting some of the orbiter air conditioner system to her own personal hairdryer and she was hands down the one that needed a hairdryer the most on board what we'd like to do now is go ahead and show you some of the earth observation slides that we've got and this one just came out beautifully and all five of us claim we're the ones that took it but what this is the red sea on the left side and from the leg of the cyanide from the red sea the Suez canal is on the right just above it is the Nile delta Cairo is in there there are some pyramids in there we actually shot the pyramids from space and fortunately for me the pyramids are very close to what I thought where I thought the pyramids were so they didn't come out in my slides and then the Nile you can see the Nile above the red sea with the large band in it also I'd just like to point out the curvature of the earth and something that's always stuck out to me is how black space is it is absolutely the starkest blackest black I've ever seen especially next to the earth we spend a lot of our time over water in an equatorial or 28 degree inclined orbit and most of the time you just pay attention to the clouds only in passing however late in the flight on a couple of our wave off days we glanced down in the Indian Ocean while we were strapped into our seats waiting for the orbit burn that never came and saw Cyclone Daniella here in the Indian Ocean off the east coast of Madagascar and we watched this storm over a couple of successive days and were able to get some pictures of this hurricane down in the southern hemisphere the eye is very well defined there and penetrates right down to the sea surface and the other detail that you might notice is that the spiral bands of this storm are in a clockwise direction and that's just the opposite of hurricanes up here in the northern hemisphere so you can really see Coriolis forces that work in the different hemispheres and this was the only big hurricane we saw in 18 days so we managed to grab it at the end of the flight thanks to the extension days this is a view of one of the islands in the Bahamas, the Great Exuma Island and to the right on the dark portion you can see the tongue of the ocean the depth of that water is about 3000 feet and as the depth close to the island is about 10 feet so there's a tremendous gradient in depth over a very short distance I must say that I am always struck in particular by the coastlines when I view the earth from orbit the blues and greens around the chain of islands in the Bahamas is extraordinarily beautiful and I wish that you could all enjoy such a view this is probably the winner of the most photographed spot award it's Mount Everest the highest peak on the planet just a bit over 29,000 feet and it's the large mountain right at the center of the picture with a very large shadow going off to the upper right to the right of this picture is the high plateau of Tibet average altitude about 3 miles above sea level and stretching towards Mount Everest is a very deep V shaped valley that makes it easy for us to walk right up to the left to Mount Everest in the center of the picture and surrounding the mountain are a number of glaciers coated with boulders that you can see in the fine detail in some of our pictures off to the left would be the Indian side of the subcontinent here and of course Mount Everest is shoved up to the heights it's reached because India's sliding from the left is cramming into the Asiatic continent and thrusting these mountains skyward one of the prettiest things that we saw anywhere on the planet this is a view of Mount Pinatubo which is a volcano in the Philippines on the island of Luzon it erupted several years ago and we continue to photograph it and of note in this photograph down in the lower left corner is Clark air base you can just see the runway running sort of up to the left and down to the right and the mud flows that are coming down from this mountain after the eruption a lot of the vegetation was removed and so the mountain is eroding at a more rapid pace and would be normal for an older mountain that has all of its vegetation in place the earth observation scientists here at JSC track successive photographs of places like this and can use that to determine how ecologically various areas of the world are being affected by the changes that have occurred to them sometimes we go after very specific targets on the earth with our earth observation photos we have a list that's sent up each day from mission control with our targets for the day the best opportunities for looking at change on the globe for example or weather phenomenon sometimes we just shoot the pictures for aesthetics and here we are way out over the Pacific ocean well west of Christmas Island and well southwest of Hawaii over nowhere in particular but the sun was going down to the west and we caught the cloud layers of gold and glow there and it's just one of the prettiest sites the clouds here are almost three dimensional as they float above the surface of the Pacific here and we had a keen eye for these shots thanks to story I think he was more aesthetically inclined than the rest of us in his views out the window and he always called attention to spectacular sites like these this is the island of Oahu one of the islands in the Hawaiian chain that is a well eroded extinct we passed over the Hawaiian chain every day we got a lot of good photos of it because a lot of times it was clear and also we passed over the islands during the cruel wake period and when the earth was lit at this point at the very bottom of the slide there you can see a straight structure on the bottom shoreline that is Honolulu International Airport Hickam Air Force Base you can see the body of water on the bottom that is Pearl Harbor the very right lower is a diamond head in the beach up from that is Waikiki Beach the very top of the slide is Waimea Bay the North Shore where they have a very large surf some personal thoughts on that slide is I do have a boy that lives down there in the bottom and Honolulu off to the right I was stationed in the Marine Corps there 40 years ago we did wave off two extra days and that brought us to a landing well here we are on flight day 15 having rendezvoused with the Orpheus spas and preparing to retrieve it one thing you might notice about this spacecraft is that it's equipped with some black and white dots and those dots were used as part of the space vision system experiment which is basically a camera and some computer smarts that looks at the position of these dots like a spacecraft and determines things like position and attitude very very accurately and we're hoping to use the space vision system when we construct the space station and so we wanted to perform some tests on that system and the Orpheus spas folks were kind enough to let us use their spacecraft as a test bed but on flight day 15 we did rendezvous with Orpheus and retrieved it after 14 successful days of data acquisition on a variety of astronomical objects here we are on what we thought was landing day we got a tremendous amount of practice at deorbit preparation but story and I were responsible for suiting up our crew members and then of course ourselves and here you can see we have our commander suited up in preparation for his landing of the shuttle actually a couple days later and we're all very proud of him for the smile on story space he's very excited about the prospects of waving off all good things have to come to an end we didn't have to land on flight day we actually had enough fuel on board Columbia to fly 3 or 4 more days we were out of some of the undergarments that you might want to use for successful days and we were also running a little bit of short on food we had lots of food that maybe Yule Gibbons would like but we were kind of short on the basics and entrees but we weren't ready to land we were happy where we were I think by around the 10th or 11th day we were very acclimated to 0G and to living in this little environment of the space shuttle and enjoying it very much and having such a great time that we could have gone on for much longer that we were given was about 15 minutes prior to sunrise it goes in the books officially as a day landing but it looked dark enough to me to log it in my personal log book as a night landing and so it did give us a beautiful view and here we are as we are approaching touchdown with the xenon lights illuminating us from behind and you can see the humidity in the Florida air has turned into some vapor let's switch off this slide, Taco I'd just like to add that as pilots Taco and I are trained for months and months, hundreds of landings and practices to try to touch down hopefully within plus 10 minus 15 knots of the speed that we're supposed to touch down and the point we touch down can vary on this day we're supposed to touch down around 3100 feet Taco won't mention it but what I'd like to tell you is he absolutely nailed it we touched down at 3100 feet we touched down inside two knots of the touchdown speed and what along came with that was a touchdown that was so smooth that as I was calling off the speeds I really wasn't certain if we touched down or not but I knew because my HUD moded into the touchdown mode and I felt a little bit of vibration which were the wheels spinning up on the roll out so I'd just like to add that Taco absolutely nailed that and I figured it was worth 100 more instead of a 20 that's it for our slide presentation and as soon as you can cue it up we're ready for the video there it is while Columbia said on the launch pad the five of us were having breakfast and then getting suited up here I am waving to the kids Rommel is just about to go through the pressure check of his launch and entry suit and that's what Tammy is doing here as well these suits are not totally uncomfortable but they're not the kind of thing that you'd like to wear here's time for any extended period of time and getting into and out of them is not real pleasant so it was nice that we launched on the first day it would have been well it was a reasonable trade to have to get in and out of the suit two or three times in order to get the extra couple of days on orbit launch day was absolutely a beautiful day something new to me on my last flight I climbed in the vehicle several times before we went anywhere we had a light and six seconds prior to lift off the vehicle stack goes through its twang but when the solids light like this there's no dent in your mind you're going somewhere we had a cadence, Tom started it he said 102-102 the computers were in mode 102 I said auto, auto, pitch and roll yes we're in auto and not CSS and Taco was supposed to say there goes the tower but by the time he could say there goes the tower the tower had already gone and we're doing more than 100 miles an hour for the solids what's interesting they've got 550 tons of propellant and they're burning that propellant at the rate of about 5 tons per second so that explains why they're giving us about 6 million pounds of thrust at this point at about 150,000 feet they detach we're going about 3,000 miles an hour here and once they detach on the solids it's a pretty rough vibrant ride and then it becomes a very smooth ride from there to orbit first order of business after getting to orbit is to convert our rocket ship into a laboratory or a satellite deployment platform in this case and so we swing open the payload bay doors about an hour and a half after getting to orbit Taco is working with Rommel to convert the computers over to on orbit mode while we're getting ready in the back to check out the arm and get the satellite out of the bay we are we grapple the spa satellite about three and a half hours into the flight and some checks were performed by the crew and the ground and here we are taking the satellite out of the payload bay and maneuvering to the release position Tom of course is assisting me here with the arm everyone in the crew was involved in the rendezvous in the RMS deploys but SPAS was a model satellite the spacecraft performed flawlessly the group of folks that we worked with in Germany were just incredible we worked with incredibly professional and enjoyable to work with so we were pleased to be part of the SPAS the Orpheus SPAS mission here we are maneuvering again the SPAS to the release position once SPAS is in the release position in our window for release opens this is the end effector view we maneuvered the arm we release the spacecraft maneuvered the arm away from the SPAS and then very shortly there after approximately one minute taco fire some jets on the orbiter so that we would induce a separation velocity between the orbiter and SPAS and send it on its two week mission of astronomical observations here we are on the mid-deck and this is the same second year I had mentioned earlier running the capillary pump loop experiment and here you can see it and this is about as exciting as it ever got but it was a tremendous experiment run by the University of Maryland out in the payload bay we had the space experiment module a gas can type experiment with 10 experiments provided by students in high schools and colleges around the country and they use microgravity to great effect on our 18 day flight now here you see the sequence of bringing the wake shield out of the protective cone in the back of the payload bay protecting the source cells the material onto the wafer growth surfaces on the wake side of wake shield this is again flight day 4 and the first place we took the wake shield satellite was over the port side pointing into the ram direction so that the contamination on the bottom of the shield here would be cleaned off by atomic oxygen and orbit after a couple of hours during free drift while we cleaned the wake side of the satellite we then swung it over to the other side of the payload bay to check out the attitude control system and so we were doing a constant series of RMS maneuvers with some pauses in between while the shuttle oscillated slowly in free drift getting ready for the deploy sequence and here we go over to the other side of the payload bay towards the ADACS checkout or the attitude system checkout location you can see the Sahara sweeping by in the background Tom was saying here we maneuver the arm and study where the wake shield thinks it is in terms of its attitude determination system and we watch the responses of the satellite to the RMS after going to the ADACS deploy and then we go to a deploy position Tom has dropped it here we study the attitude determination and control system its performance for one minute we did get into a little higher reaction speed here than planned and as well we had an 8 degree roll excursion and so the wake shield community wanted to study this response for a few minutes longer we did observe to watch the clearance with the AFTV cameras I'm waiting here to to start the thrusters they're Colgas nitrogen thrusters and here the wake shield is thrusting away from the orbiter it's a 20 minute burn here are the two satellites in formation with each other after wake shield they're about 15 or 18 miles apart at that point and we're going to fly between those two to rendezvous with wake shield as you can see we do need to eat on board but you can define your own kitchen table upside down or not and we do have to keep things clean Rommel here is vacuuming one of the filters it collects a little bit of dust on it we just vacuum the dust off of it one of several filters in the crew compartment flight deck we have all of our TV recording studio set up four separate recorders to record SVS data that Tammy talked about earlier and all of this data was shipped back to the ground after landing we had a number of orbiter jet burns to keep us in the proper position with these two satellites some of them were fairly long as you can see that from the exhaust over the nose there and we use the computers to tell us what to burn but then we make the burns manually and you can see how the firing of these little rockets shake the vehicle you can see the computer on the glare shield sliding around a little bit what we're looking through there is the little gun sight we got the reticle turned down fairly dim so that we can see outside well and wake shield was showing up in the gun sight and we're flying up closer to it again we manually are flying and you can see Tammy in the window next to me taking sightings with the police laser when we get it down over the payload bay it's time for Tom to go to work and grapple it it's remarkable how smoothly our pilots brought this spacecraft into the payload bay envelope I'd never seen another spacecraft in orbit before and this one was remarkable in its stability taco practiced right underneath it and then we rotate the RMS end effector get it into the right orientation for grapple and then it's just a matter of going and closing the grapple pin and not bumping the satellite out of the way in the process here we are closing over the grapple pin with the end effector we trigger the snares and then bring the wake shield back aboard after its three days of material science one strap to the arm we can bring it back down into the payload bay and we even use it the next day for some space vision system experiments our flight deck teamwork is very important as we bring it down into the payload bay we even had space vision system here providing us birthing cues in addition to the usual TV camera RMS digitals that we use for standard payloads wake shield was really a joy to operate on the arm Tammy is here with one of our long lens telephotos Hasselblad camera and we'll show you a few views of the earth in the movie here too hygiene is important in space also so destroyer was getting a little bit shaggy so he's getting a little bit of a trim and a polish here also I think you can define our crew as works well together when we had an oisering spill everybody chipped in to help clean that spill up as many of you know story was making his sixth flight on the US space shuttle and while we were on orbit he passed over a thousand hours of time in the space shuttle so we came up with this patch that says master of space and presented it to him in a little ceremony on board here we are in the mid-deck the day before the flight day 10 scheduled EVA applying anaphoag to our helmets and also getting our tools in the proper configuration in anticipation for the EVA in the next day Tom here has the shuttle power tool and I'm holding the news station power tool that has some enhanced capability but as you can see is quite a bit larger than the shuttle power tool we spent several hours getting our tools in the proper configuration and everything that was laid out to make EVA day go much more smoothly and efficiently Tom is donning his lower torso assembly and it's always a bit of a squeeze getting into those pants and shortly you'll see my head pop out of the the upper torso and story of course was instrumental in getting us suited up and prepared to go out the door the crew got into the airlock the RMS got in position to view crew egress we went to open the hatch the handle rotated about 35 degrees and came to a hard stop this happened over and over again more times than I can count and unfortunately we were never able to open the outer airlock hatch and the EVAs were cancelled for the flight well we wanted to get off on time so that we could get you all home for Thanksgiving but you can probably blame me on that because this is my third Thanksgiving in space but here we are eating a traditional turkey I had flown during Thanksgiving with John Blaha back in 89 I wanted to fly in space again and I did get to fly with him but on different vehicles you all were nice enough to patch us in with him the moon from out there in space is very similar to the moon you can watch this moon grow to a totally full moon this is a shot of flight day 15 and this is a day when rendezvous in with Orpheus to bring it back the taco was kind enough we swapped roles during this rendezvous so I was at the AF station and taco was in the Ford station until, and now you notice tacos in the picture until we got within 100 feet and then he took it for the proxops and the grapple the landing job with the rendezvous they put the spacecraft very very steady into the end effector camera all that was left to do was a quick maneuver and a grapple of the Orpheus spas a post grapple we did do a number of maneuvers in support of some space station experiments testing our SPS system and making sure that we could get very good position in attitude information out of the space vision system to facilitate some of the space station construction activities and this is our final birthing of the spas let's take you back outside we're gonna give you some camera views of the earth always in the background as we maneuvered the spacecraft during our long flight looking down we can see some very delicate linear dunes in western Algeria in the great western sand sea of the Sahara this is a very early morning view of the resulting of the dunes by the wind a little bit farther to the east is a big outcropping of black volcanic rock it's dark gray because of iron and manganese in the rocks and the typhoon dunes that are there on the right side the thumb shaped dune field is red because of the iron in the sand grains reflecting light in a different way and it's a very beautiful dune field bumping up against the hard rock of the mountains there over central Africa we saw a lot of burning going on indicating from the rain forest area in central Africa combined with the grasslands there this is one of the hot topics we were looking for from space we saw a lot of burning not only here but also in Australia because it's the dry season there beautiful real time sunset from earth orbit and now it's time for entry we've got a small camera hand held in the cockpit that allows us to pan around and show you the orange pink aerodynamic heating outside the front cockpit windows we go through about Mach 15 out the back windows you can see the plasma tail trailing us behind as the hot plasma streams around the orbiter and goes back over the tail it's a spectacular light show during that time where you saw the plasma trail behind us we were tilted up at an angle of attack of about 40 degrees here we are looking out through a camera over the nose of the vehicle and now the angle of attack is much lower and we're flying more like an airplane it is dark overhead so the only way to see us was with an infrared camera and that's what you see in the upper right inset in this view we continue to have the camera that's looking over the nose operate all the way to landing and you see some lights on the ground and you can see clearly why I called it a night landing and just up towards the upper right and moving to center you can see the dim outline of a long thin light area which is the runway we are diving towards a set of lights about a mile and a half short of the runway which are lit up by strobe lights and at about 2,000 feet we start to pull out to shallow our steep dive angle which is 18 degrees up to that point to more of an airliner type glide slope so we can land at about 300 feet Rommel put the landing gear down and this is our view as we are finishing that that preflair on the left is a string of lights with a little ball next to it which we are trying to line up and keep in the center so as to cross the runway at the right height at the threshold and with the xenon lights providing the bright glow on each side of us here is the touchdown viewed from the camera at the far end of the runway you can see the vapor trails being turned up in the humid Florida air at about 200 knots on the ground Rommel deployed the drag shoot and at 185 knots we started the nose down to make a to get all three wheels on the runway and we will start steering down trying to stay on the centerline of the runway because it is nothing more embarrassing to have the final photos of the vehicle not on the centerline it is also helpful to stay out of the mud in the weeds at about 60 knots we release the drag shoot so it still has a good aerodynamic force on it to get away from the vehicle so it doesn't damage the engine bells this is after all a reusable spacecraft it was the 21st flight of Columbia the 80th flight of the space shuttle program and that is the end of our presentation thank you very much


Hi, my name is Pivan Lukumhan, and I'm Adrienne O'Rourke. We're here at the Barry Elks Lodge for the Vermont GOP's watch party here on Election Good Night. And we are going to watch the results come in, and we hope to get to talk to some folks that are here tonight. And we are thankful for Orca Media for providing the tech service today. Hi there, I'm Pivan Lukumhan. It is Election Night here in downtown Barry. We are at the Elks Lodge, and this is the watch party for the Vermont GOP. Standing next to me is John Clark, candidate for the Senate in Orange County. Do you want to say a few words, and how's it going tonight? Well, it's been a long haul, and I think we're all sort of excited to have it over with, for better or for worse. It's a very tiring ordeal. But I really want to reach out to thank all my supporters and everybody who runs. I mean, in this democratic process, it really is a state where the tail can wag the dog, and regular Vermonters can run and be involved and have a chance of winning. And I think maybe we'll take some seats tonight, is my hope, whether or not I do. Well you told me earlier that you're quite new to politics, and tell us how you got into it, and what you hope to achieve as an average citizen going into politics. Well I got involved a few years ago just trying to shape a conservative message that was more moderate, more in between Phil Scott and Donald Trump for conservatives. And to try to appeal to Vermonters on conservative issues that would unify people rather than divide us. And I ran two years ago against Phil Scott, and we had almost 40 people run with me, several of them won. And so that's kind of the foundation that I ran with, but it's kind of a, I've been called a rural populist, and I kind of like that. I mean, I know there are negative connotations to that. But I think people want authenticity, and they want people who they can trust. And that's what brings me to the party, as a person who was before that Democrat for most of my life. So I'm kind of a walk away. That makes sense. Yeah, and if you do win this election, you've got two years. What do you hope to accomplish? Well, I think that we've got some real problems to tackle that require centrists from both the left and the right to come together. And I've actually been outspoken and supported some Democrats who understand the fiscal problems facing us, particularly with our pensions. Our government's too big. Our schools are the second most expensive in the country as a function of our income. And our government's growing faster than the underlying economy. And we can't simply be dependent on tourism and handouts from the federal government as Vermonters. We need to rebuild our economy. And I believe that we can do that, believe it or not, not solely, but a lot with farming and building along those strengths and even agritourism. I mean, our tourism industry as well is built on farming. And we're losing our farms and not just our dairy farms. So we have a huge opportunity with increased inflation and fertilizer and fuel costs to start exporting food again, like the way we did. And there's actually a huge business plan right there. Great. As you heard me say. Yes, but we're talking to a whole new audience here. And what are your hopes for the Vermont GOP in general? So as a party? Well, it's a good question. There's an increasing division on the left, which we saw, particularly in the Molly Gray, Becca Ballant Race. But elsewhere, there's there's really an increasing division there. And on the on the right, there's been a division for some years, which is evidenced by Phil Scott and Donald Trump, who themselves have never exactly been allies. And so there's a middle there. And it has been my goal for several years. And we're trying to see it take shape to form a GOP post Phil Scott, post Donald Trump, not wishing death on anybody. But when those those those personalities are in the past, perhaps we can repair Vermont's GOP because it's created a real division. And nobody wants to donate to this party because either they hate Phil Scott and love Donald Trump or they hate Donald Trump and they love Phil Scott. So why would you give to the party that you see? So it's created a real a hole in the conservatism. I believe in a two party system. We've had essentially a progressive one party system right now. I think we only have six Republican senators, maybe seven. That's not very balanced. And that's why we have such a, you know, the governor has been unable many times to resist veto overrides. So we need more balance. So that balance, I think, comes from a conservative party that's reshaped around a more centrist, traditionally conservative list of platform issues. I love public access television. I wish more people would produce for it. More people would get involved watching it. And it's a huge opportunity because freedom of speech is the core of any sound and growing culture in society. So thank you for doing what you do. Thank you for joining us. I'll let you get back to your party. Thank you. I haven't even started my party. Thank you. Thank you, guys. Thanks for coming out tonight. Obviously, it's been a little over half an hour since the polls have closed. So I just want to thank you all. I know so many of you. We've got some candidates here. We've had folks who have volunteered. Town chairs, county chairs. Thank you guys for coming out and doing all the work that has taken to get up to this point. So thank you. I'm excited. I think tonight is going to be a good night for Republicans across the country, for sure. We are going to have a red wave. I think we look across the border at New York and New Hampshire. Some of these other Senate races. There's a lot for Republicans to be excited about. The most important thing for us to be excited about is the food has been served. So if you haven't had a chance, make sure you grab some of the appetizers. These have been prepared by the Vermont Young Republicans. We have an incredible, let's give them a round of applause. I know Sam Douglas, chair of the Vermont Young Republicans, offered to do the food for tonight. So make sure you say a quick thank you to him. And we're just going to be watching and waiting for results to come in. But also we've got our longtime Republican former state legislator, Tom Koch, wanted to make an announcement. So go ahead, Tom. Well, I have a tradition of reporting the results from Barrie Town, which is often one of the first towns to report. And I hope that the returns from across the state are better than they are from Barrie Town. I have some bad news to report. The Democrats put forth an Emerge Vermont candidate who had over $10,000 funded mainly from Burlington. She worked very hard around the town. I have to admit that. And the bad news is that we only beat her by 600 votes. So our new representative, the top vote getter was Topper McFawn. And about 100 votes behind him was our new representative, Gina Galfetti. And I know she's going to do a super job. So that's the news from Barrie Town. Also, Paul Bean did pretty well. He came in at third, actually. But that's understandable because we have a local candidate from Barrie Town who came in first. And Cummings got 1,839 votes. Paul Bean got 1,829 votes.  So we're hopeful for Paul tonight. I have the tape here. I haven't actually looked at all of it because I grabbed it and came down here. Joe Benning, 22, 24. David Zuckerman, 13, 16.  Phil Scott, 3,040. Brenda Siegel, 458. So it's a good start for the night. Let's hope we keep it up. Sorry for the bad news. All right, so yeah, make sure you grab those. That is good news. To start, I joked with Tommy. Really had me going there for a minute. But so those are our first two contested wins that we know about. Republicans keep the two seats in Barrie Town, re-electing Topper McFawn, and also electing Gina Galfetti to replace Rob LeClaire. So there's our first two on the board. Please, we'll have some more music and make sure you get some food. As we get more updates, we'll let you know. Good evening. I'm Paivon Lukumhan here at the Barrie Elks Lodge in downtown Barrie. We are at the Vermont GOP Election Night Watch Party. And standing next to me is Erica Reddick. And I'll let her introduce herself and tell me what office you're running for and what you're looking forward to tonight. Yeah. Oh, are you holding it? I'll hold it. OK. My name is Erica Reddick. I am the Libertarian Party candidate for Congress. I also have the support and endorsement from the majority of the GOP apparatus here in Vermont, especially for folks who don't know the young man who does have the R behind his name is not actually a Republican. But I was very blessed to also have received the Libertarian Party endorsement. And so the thing that I'm most excited about is that I would say, number one, the Libertarian Party is going to become a major party here in Vermont tonight with my candidacy. So that's pretty exciting. So can you tell me a little bit more about the Libertarian Party and how it's different from the GOP? Yeah, great question. The Libertarian Party, much like the GOP, is very focused on liberty. So it's really about freedom, bodily autonomy, and just making sure that the government is in the right place in its citizens' lives. So they tend to be a little bit more focused on differently on social issues. So whereas the Libertarian Party has always been pro-gay marriage where the GOP was not previously, the Libertarian Party is also pro-cannabis. And so that's one thing that the GOP is not for. So they tend to be a little bit more liberal on social issues than the GOP does. That's probably the main difference. And remind me which congressional seat are you running for? Well, Vermont, the Vermont US House. US House seat, yeah. So we just have the one. And what was your motivation for running for that position? Great question. My motivation for running for Congress was just seeing our country running off of a cliff. I'm an accountant by trade. That's what I've done for much of the last 20 years. So I knew that this inflation spike was coming when those stimulus checks came out. I knew what was going to happen to the supply chain when they started shutting down, doing lockdowns, and things like that. And sure enough, it did happen. And then we see that our leadership is lying to us and saying, oh, no, inflation isn't there. It's transitory. And all this other stuff. And you're like, why are you not telling the American people the truth about what's going on? And selling our strategic oil reserve, the botched withdrawal from Afghanistan. I know. So I feel like our current leadership, while they may be well-intentioned, don't seem to understand the consequences of their decisions. And the American people deserve folks who are a little bit more stable and will take more caution and care before changing our institutions. Great. One last question. Let's keep it quick. Because I know, we got the wrap-up sign over here. So the Congress is large. And sometimes it moves really slowly. And sometimes it takes a while to make a name for yourself. What do you hope to accomplish in your first term if you get this seat? My goal is going to be, I'm going to submit three bills for consideration. One is going to be for term limits for federal officials. Another is going to be for a balanced budget, so no more deficit spending. Just run in the black card for $6 trillion a year, or whatever it is. And single-issue bills. So instead of these 10,000-page omnibus spending packages that they just stuff in, single-issue bill, one appropriation, one topic, these are items that are bipartisan, that Democrats, progressives, and Republicans all across the board, libertarians, everyone agree that that's how you can help restore accountability, transparency, and integrity to Washington. Thank you so much. We've been talking with Eric Oretik, who is on the ballot for the US House in Congress. Thank you so much for joining us. Thank you so much. I appreciate it. Yeah, no problem. Have a good night. Yes, hi, guys. Hi there. It's Paivon Lukaman here at the Berry Elks Lodge in downtown Berry. We are at the Vermont GOP election watch party. I'm standing here with Paul Dame, chair of the Vermont GOP. And the polls are closed. And the results are trickling in. Can you tell me what we've got, what we've seen so far? Yeah, so far, the first-only results that we have are from Berrytown, where we had Representative Topper McFawn running for reelection. And his previous seatmate, Robb LeClaire, had retired. So we had a new Republican running in that race, Gina Galfetti. And Gina was successful. So Republicans have retained that second seat in Berrytown. So the first news of the night is good news. So we just hope that it keeps coming. Great. I heard from my co-host over there that both Topper and Gina were doing a pretty rigorous door-to-door canvas campaign. Yeah, that's really what we recommend for all of our candidates. It's the best way to make sure that you get to know your district and the people that you're representing, and making sure that you're able to listen to what their concerns are so that you know how to represent them. And that's something that Topper McFawn has been doing for years. And so it's been great in that two-seat district to have an established veteran like Topper, who knows the area, who knows the legislature, and to have Gina kind of come in working with Topper to reproduce those results that are working for him. Yeah, so as the night rolls on, what other major or what other races are you really keeping a keen eye on? Yeah, I think we're keeping an eye on certainly a couple of our incumbents, like Vicki Strong up in Orleans or Samantha LeFave, who's here tonight to make sure that we keep the Republicans that we have that have been in there. And then we're also looking to kind of expand the map. I think there's a couple of opportunities we have up in Franklin County with a new Fairfax Georgia district that has Carolyn Branigan coming back and Ashley Bartley. So and we're keeping an eye here in Washington County on Paul Bean. He ran a very vigorous campaign for state senate. And in Washington County, you get to vote for three. So we're hoping that despite the fact there are two incumbent Democrats, there's an open seat. We're hoping that Paul, as a younger vermoner, is able to get in and be a voice for younger vermoners in the Vermont Senate. I've seen quite a lot of his signs around. Yeah, so let's touch back on something you were talking about, this new district. How has redistricting affected the campaigning? Well, in some places, the districts look very similar to what they had before. So in some places, there's not large changes. In other places, especially as you get into Chittenden County, where more of the population is, we had to do some redistricting because there's more people living there, so they need more reps. And then the other side of that is places like the Northeast Kingdom, Caledonia, Orleans, Essex County, lost some representation. So that has been kind of moving the map around a little bit. In some places, there's probably one place that's created an opportunity for Republicans in the Senate. It looks like we've got a good chance of getting a Republican Senate candidate out of this new district around Milton. And then in some other places, it certainly hurt us, a place like Vicki Strong I mentioned before. We kind of cut that district in half and cut Vicki off from some of the support that she's enjoyed for almost 12 years as a state rep up there. Yeah, so it looks like there's a pretty dedicated crowd here. What do you think about or how are you, as the chair, cultivating the future of the GOP here in Vermont? Well, I think the future starts now. And so we're going to take whatever the results are here tonight, take a careful look at those to identify where we had some good candidates and good districts, where maybe we came short a little bit and try to start looking for high quality candidates in more districts. That's one of the downsides we've had this year. We just didn't recruit as many candidates as I would have liked. And so that's something that we've got to start on right away looking at 2024. What do you find people are attracted to with the GOP? And so why would they enroll to run? Yeah, I think some of the things that we've heard is just the cost of living is just getting very difficult in Vermont. A lot of people just having a hard time filling in their gas tank, filling their home heating tank, just concerns about taxes affordability in general. And those are the kind of folks who have been looking to get involved in the Republican Party to be a little bit more of a balancing force in Montpelier. Anything else you want to say as we get back to watching the election results? No, I think we'll keep an eye on results as they come in. And thanks again for being here. Absolutely, thank you. We've been talking with Paul Dames, chair of the Vermont GOP. And we're here in downtown Barry at the Elk Slodge. And we're watching the results roll in. So thanks for joining us. All right, I've got results from two more races, some good news and some bad news. Unfortunately, Tom Kelly was not able to secure a seat here in Barry City. So the Democrats have retained both of those seats, incumbent Peter Anthony won that one. And we weren't able to flip that seat. The good news is Penny DeMar won in Franklin 7. And Republicans have retained that seat where Felicia Leffler had retired. So both parties basically had a draw there retaining the seats of vacancies. So that's all we've got so far. Well, we got some more news out of Franklin County in the brand new Georgia Fairfax District. Republicans picked up a seat. And we've got Caroline Brannigan and Ashley Bartley. And that was a seat that was held by an independent and now is in Republican control. So that's our first pickup of the night.


Welcome back to the channel. I was looking through Stack Overflow to see some questions and some answers and I landed on this wordpress challenge so I picked it up because it looked interesting and it's something that I've looked at before and I thought why not take on the challenge and really help out. The challenge is this person has a table that has a brand model color and mileage of the different cars in the different rows and they want to be able to view this information in a custom post type and probably also exhibit that information from the custom post type onto the front end. The big challenge they do have is that this information is coming from a firm straight into a database. So how do they do this? How would you do this? So we're going to tackle this in a number of steps and we're going to make sure that we actually make it work. So what do we do? We're going to come here and we're going to open a plugin as always and we're going to call this a Stack Over question that will be our plugin and then of course we're going to drag and drop that into our editor and then we'll start by creating a PHP file with the same name open PHP then we shall use a startup plugin to help us open that so we'll call it stackover question and then I'll change this to my URL and then we shall just have the name we'll just say take your place, move stuff from the DB to the custom table to CPTs, our version one that will be that will be all good. I'll just make it this GPL 2 and save this. So we've opened up our plugin. The next few things that we're going to do is let's plan this out and highlight it inside steps. What do I mean by that? First we're going at the custom post type that will allow us to have our information after the post type we're also going to add some meta boxes because if we look at these these are properties of a custom post type if the car is the custom post type we'll have brand, model, car and kilometer these are small pieces of information which I think belong inside meta boxes so we'll open meta boxes for them to be exact and after opening four of those we're going to also add another row onto this table so that we have a unique so we'll add a column or in databases that's called a field we'll add a field for auto IDs and these are the very IDs we shall query for we shall first of all get our custom post types, pick the auto field that has ID that has been saved as a meta box so we'll make these five so we'll get that meta box we'll filter out and say these particular custom post types don't have these IDs and we're going to check our database table to see if there any other fields that don't have similar IDs as the meta post that has been saved in the CPTs so once we find those then we shall use our SQL to only get back the rows that don't have similar IDs registered and then those will be auto inserted inside our CPTs so that's what we're going to do so we'll get those IDs filter the table of course contrasting with saved meta ID in CPT so that's what we're going to do about four steps relatively long but we'll be able to make it and we'll do it very well so our first step is we're going to make custom post type and the good thing is that the person here has added a custom post type so we're going to just copy that so that when we paste back the information we're giving them exactly what they do need so the next thing that we're going to do is that we're going to copy their meta boxes and we're going to add those meta boxes to our code so I'll paste this here let's see what we have inside our dashboard so we'll go to install plugins inside our dashboard and we're going to activate our stack of a question plugin after activating it we'll see we have a custom post type here of the portal so once we go to our post type we see that it's empty we don't have any post types when we click add new we have our custom post type but we don't see any meta boxes here meaning there is a problem already with our meta boxes so we look at this and we'll see what is needed so when we look at our meta box we'll see we have the id for the meta box we have the title for it we have a callback function there is no way we're going to be getting that field so we remove this pasting argument and then we see this is called car reviews which should be the post or the screen and this is wrong the post type registered here is called auto so we'll need to change this to auto as well this is no more so meaning the fields will be right here under the editor and then high for priority so let's reload that and we see we've made some corrections to make sure that we have our fields here so we have the karmic we have also the model so what we're going to do now is we're going to have five fields so i'll just duplicate this to make them two let me increase the real estate we have here so we have the make we have the model we're going to have i'll just look again at our database that we're going to have here so we have color and then we have the mileage so the mileage will be in kilometers we don't need to throw off that unique ID also in here but if we want we can as well just show it and say ID so we'll call this a UID so this step is done and we'll tick off two pieces to be done so i'll just cut this and move this along the way so that we tick off whatever we need and we're done so we've done the custom post type i'll remove this i'll also remove this here because we are still in php there's no need to escape it so we've done the meta boxes now what we need to do is we need to add a column and field inside our database so we're going to make a similar database inside our php myadmin so we'll go for localhost slash php myadmin and we'll go to our cc cc database and we're going to create a table here which we shall call garage of course it would be prudent for us to add the wp underscore which is the prefix at this time but we can just also leave it plainly but for now let me just add that prefix we're going to have four columns actually five columns at that so we'll click go to add the columns so the first thing that we need is going to be an id the id will be an integer we can give it a length and say maybe it will be 120 i would never know how many fields there will be it should be always not now it will be auto increment so it will become our primary id and i think that is good enough the next thing that we need to do is we need to have a brand so we'll have a brand which will be a text we can give it a 120 we need to have our model here which is also similarly going to be a text we'll give it 120 and that will be okay we need to have a color which will also be a text that runs through then finally we are going to have our mileage which should be kilometers so i'll keep it the same as we have here so we have km which is our kilometer it's an integer so once we are done with this we are going to hit our save to actually get our wp garage so when i go inside here you will see that we have our table that has all this information so we're going to insert some fields inside here so since this is auto incrementing we can ignore it but we need to add the different brand so we need to have a fiat fiat panda black so our kilometers will be that we'll have a fiat well it will be a panda model and it will be color black this is not the best way to work with your database but just populating it so that it's actually working well so i'll hit go to have that and then i'm going to do the next piece of information which is opel kosa red so we shall also go back to enter and we'll have an opel to be a kosa it will be red in color and it will have this mileage so we hit go and go again and this is inserted so we'll go to our wp garage you'll actually see that we have our fiat and this information has been put in twice so what i'm going to do is just get rid of these two rows i'll say yes so we have our id and we have this as three so i'll just change this to two but even if it was three it would work so we have a table here which is similar to this the only difference is that we have a primary key of id that is allowing us to work with our garage database table much better because we need a primary key in any table you need a primary key so what we are going to do next is we are going to start querying our custom post type to check if there are any post types that have a metadata that is saved and is similar to the id so let's get to that so what i'm going to do here is i'm going to open up a function and i'm going to call it check for similar meta IDs that will be our function now inside this function we are actually going to start querying so we'll need to use the wp query and to make this clean i'll just call it a techie press underscore check bla bla bla now this function is going to of course start off with a clean id array so we'll say id array in CPT is going to equal to an empty array so this is the new of writing PHP arrays if you're not familiar you could be used to having this array and that it works the same way it's just that the square brackets are the new we are doing it so we'll just leave it as that for backward compatibility and the next thing we're going to do is we're going to query for all autos so we'll say our arguments are going to equal to an array semicolon and we're going to look for the post type post not post t so we're looking for post type which is called auto as we have which registered here auto in the post type when registering it so we need auto the posts per page and so we're going to get all the ones that available so we'll get a minus one here i'll make this wpc friendly that is a wordpress coding standard friendly now once we have our arguments the next thing we're going to do is we're going to say let's get our wordpress loop and it's equal to a new wordpress query class so we bring the wordpress query class in here and we say we'll pass in our arguments from here so we have our loop and then we'll say while we have any loops so while loop have posts if our while loop has any posts here actually come here and say the loop will be the post so the next thing that we're going to do is we're going to get our id cpt here and we're going to chain onto it or we're going to say it is equal to now we need to add the square brackets here to show that it's the array we're adding onto we're going to say get meta get post meta and what we need here is the id so we'll say get the id which is available to us as a function inside the loop so we can get the id and we're going to get the key which we shall call id when we are saving it and we're going to say this should be true because we want it to be single we don't want it to be an array and then eventually we're going to return our id arrays in cpt so this function is just querying for all the post types posts of auto and then it's looking for post meta called id and then saving this inside inside an array so we have an array of ids here now the next thing that we're going to do is actually going to query our database and find out if there any ids that are similar to what is in this array and we're going to remove those ids and only get the ones that do not exist inside this particular array so we are going to open up a function and this function we're going to call a techie press underscore query garage table and we're going to pass in our information now what this function essentially is going to do is that we're going to pass in our global of wpdb and wpdb is a global variable that passes in the whole class for working with wordpress databases it allows us to have clean methods of instead of using like mysql prepare and all of that everything comes out clean in wordpress when we use this global for our database so we're going to say our database table name garage and we can add the table prefix to it here at the beginning and what we're going to do is we're going to use the wordpress the wpdb we need to get the prefix so that will give us the prefix and we shall chain it onto the garage the reason why we get this wp is because all these other tables were having wp and you never know what they use at the end of the day we'll use this table either changing the prefixes and so on so we need to have that uniformity that's why i gave it the wp underscore garage here and that's why we're using the prefix here so that in the future when the prefix is changed we still have this available for working and it can still do well so the next thing that we're going to do is actually use mysql at this point and we're going to say that we need to return some sort of results we are going to get these results by saying we're going to check our database and inside our database we're going to use a sql here so we need double brackets here so we need double quotations so we're going to use wpdb and we're going to chain onto it a method that is part of that class and that method is called get results and get results of course will need to be fed in with the parameters that are needed and the parameters that are needed here are actually sql so we're going to do the select so you need to have some knowledge of sql it's a select it's all from our table name so we'll bring in our function here our variable here so we're going to get all the results from here and we are going to actually return them as results so for now let's just test some of these things to see how they do work out so i'm going to use a wordpress hook which is called a wp and what this hook does is that every time you're working with wordpress it actually is hit so what we're going to do here is we're going to vadamp this so i'm going to first copy this place this here and we can vadamp it to see what's going to happen but we know of course we're going to have zero so there is no need for me to do this for now but we can also just query this can query our database table to see what results are actually returned so let me duplicate this and let me vadamp what we get here so go to the end and save this let's come back to our back end just hit the same piece and you'll see that here we get back an array of data and let me just show this better and we'll see that we have an id of one which is a string we have the brand fiat modopanda and so on and we have our secondary of information that is for the brand opel modokosa and so on so we're getting all our information back from the database safely inside wordpress so this is working out well as the function that we need the next step that we're going to do is that we need to juxtapose what we have here and what we get back here remember we said we're going to exclude the ids that are returned from here because that particular custom post type is already saved so we don't need to have the ids that are in here coming from of course this id we're going to save this id as a part of the custom post type so as we adjust with that metadata we'll need to remove that particular information so how do I tackle this we're now going to start working on our next function that actually is going to insert into the custom post type so I'll begin a function here and I'm going to call it a techie press insert into auto cpt and that will be a function and the first thing that we're going to do is that we're going to use the wp insert post function of wordpress that takes in an array of information and also takes in an error but for now we'll take this away because we are not going to error we're going to have definite data so we'll use that so what we need to do is have a post array here so I'll just copy this and start it from up here now of course this will be an array we close it off with a semicolon but we need values that are going to be passed in here so let me just check this array function here and we'll see what it looks like in our wordpress codex and we see that this helps us to insert our data post by adding new data and the parameters it needs is an id needs a post author now the id of course will be auto entered so it needs a post author these are optional fields it needs a date which will be added it needs a title so we'll use a title we need a post status our post status will be published because one then instantly published we don't want to leave them as drafts and then we'll use the post type that we're going to be pasting this information is auto not post but auto and then of course we'll need to add a meta input remember we said we're going to save all the other small information inside our meta input so those are the pieces of information that we need right now uh let me just add them here so what we're going to need is we're going to need a post title we're going to need meta input we're going to need a post type we're sending this information we're also going to need a post status for what our post will look like after that information is added so let me add these in single quotes and then i'm now going to chain on our post title so our post title for now we shall strip shall use the wp strip all tags and then essentially what we're going to call this particular field is when we get our information from the database we shall say whatever that result will be we are going to chain on and say let this be the model because if you look at this information coming back we have a string here called model so we're going to have the brand and the model coming fast as the name so we'll have result model and then i'm going to chain on the brand so brand and then model will be our title i'll just add a space in here to make that look a lot better so we'll have something like opel kosa will be the name of that we can also add on the mileage if we want to there is no problem with that so we can do the something here and then we'll just make this in our camp so that's what we'll need next thing that we're going to do is we're going to chain here let's not forget the comma we'll need to add the meta input and this is going to be in an array of data add a comma here now in our meta input we're actually going to have about four items so i'll just copy this here pass them here so what we're going to need first of all as metadata is we're going to need our id which will allow us to have something that is unique remember this is the id that we'll use to contrast against all the information coming in from this particular function where we query the CPTs and get the metadata stored as id so we need to save this id here and we shall equate that to our id so result id put a comma here and then let me duplicate this three times so we'll have a brand i'll make this a small b we'll have a model small m and then finally we'll have our kilometer this will be a small k brand that's fine add a comma we'll add a comma after our model and then we're going to add our kilometer here and also add a comma to keep it friendly with wordpress and then we just need to do the same thing here and add and chain the different pieces of information so we know that our post type will be auto so single quotes auto that's where we need to send that information then here we'll also add single quotes and say we need this to be published so save this here now we're getting that information and then we are sending it inside our post type but no post type will be created here even if we run this particular function so i'll run this here i'll change that so even if we run wp action we're not going to get anything because this will be broken there is no reference for this so what we need to do at this point is we need to go back and start querying our database and then compare the two pieces of information so we're going to have a variable here which we shall call available in CPT array and it's going to equal to this particular function take a press check for similar meta IDs probably this is is not the best name to be descriptive here but that's the function that we'll need and that is going to give us the information so we can actually vadam this to see what's coming in so i'll just vadam this information here copy press this and then i'm going to do a die that will allow us to kill our process from here and we shall not post anything inside our pieces here so if i come back the same place here you will see we have an array of zero so we need to actually check that and say if it is zero then abcd is going to happen or abcd is not going to happen so we already have an array of meta IDs already showing us here so what we need to do is actually we need to pass these meta ID arrays inside our query garage table so we're going to bring this here as a function and we're going to pass in our available car in the CPT because we want to receive it here so i'll pass this as an argument in here so that we can readily receive it here and the next thing that i'm going to do is that i'm going to call this as our database results so we want our database results to come here so i'll use this to i'll actually just vadam it here to see what we get back so inside our database here we are going to do a variation in terms of the queries that we do if the car available in CPT array is equal to zero or is null or is equal to a string of zero or is empty we are going to run this straight up we're going to get our results as this however if we have some values in our array of the CPT array then we're going to run a different kind of SQL query so let me do this first and foremost so we'll get this here and say if then run this so we will say our results are equal to that and we shall return results that's what we shall return but what are we querying for what's the if we're going to say if this is equal to null so we'll put null first and then we say it should be of the same type and it should be equal to that we are also going to say all if it's empty if it's equal to zero as a figure we can also add another condition to make sure that it is right all it's a string of zero as we see here we have an array of zero that came back let me wrap this so that we can read it we can also say if what we are getting here if this car available array is actually empty so we can also say if it is empty so I'll paste this here take this off if it is empty then we run this and get our results otherwise so we'll say else else we're going to have a different way of meaning if it's empty or zero that's it if it has some figures in it then it's going to be something different so otherwise we shall return results but we're first of all going to use a different SQL uh to query for our data so first things first is we shall write and say our IDs will equal to and we're going to use an implode method here to get our data out so we use that implode and we're going to say we want to strip over particular information so we want to get the commas out so single quotes here we'll get the commas we want to take the commas out and the space and we want to take those out from our car CPT variable that's the first thing that we want to do then what we're going to do next is we're going to write an SQL statement and say our SQL will actually equal to double quotes terminate that and say it's going equal to select all from and we shall bring in our table name and we are going we're going to get all the rows from our table name where the ID if you remember our ID where the ID here is actually not in so it's not in and then we shall pass in those arguments whereby we are talking of the IDs these IDs that we implode have to be in here so for example if we have two or three or four those will have to be taken out so that's why we add our IDs inside here so once we have our SQL ready here we're going to use this method and say our results will equal to this but at this point we're just going to pass in our SQL because we have set it out as a variable so we'll just pass in our SQL we have in both cases results returning and we save these as a database so let's see what happens we'll save this come back and reload and you see it brings back all to arrays from inside our database that is good so that is brilliant now we're going to just use i'll comment this out and say since our results come back as an array we're going to use a for each statement so we'll say for each so for each database results as result as a single result at that point we are going to get all of this here and then we're going to move it inside our for each statement so for each result that comes back we are going to get all the information that comes back as a result brand as a result model as a result kilometer as we are seeing it from here then we are looping through that and inserting that as a post so let's save this and see what happens so i'll reload this and reload it again and you'll see that we get our pale cosa coming back with the number and fiat panda coming back as that if i reload this over and over and over and over and over again you're going to see that we don't get any other results coming in because we are exclusively checking for whether they are similar ids with this metadata so let me just click inside one of this let me edit it this data is not showing here so let's show it so that we can be about actually confirm that it is true so inside our value here i'm going to open some php tags echo and say get post meta which is what we need now inside this we shall just be able to say get the id get the id the function and then we're going to pass in the metadata we want to get the id here and then we're going to say this is true and of course pass a semicolon and save this so we're just echoing out what has already been saved so when i save this let me reload this oh this is get post meta sorry get post meta and when we reload this you'll see that we have our two actually here i'll just copy this paste it in the different fields and we'll paste in their respective ids and you'll see that it actually works out so here we have run brand have model we have color and then finally we have km for kilometer or mileage reload this you'll see this information shows up here apart from color which we didn't save here so i reload this and will have color and this will be related to color i'll spell this right and save this so this is not working out well let me trash this and delete it from our trash this will also help us see whether our code is logically right so you will see that it automatically fetches it again and when we see fiat panda it doesn't have this so i'll also trash this automatically it has been fetched again so we have fiat panda and we have our color black here and we have our pale red here so we only have two post types in our databases here so even if we made a mistake it would automatically come back and we just need to clean our trash to make sure everything is okay so we have our two pieces here it means our code is working out well it's not duplicating any post types as adding them but rather it's giving us all our information coming out really neatly and well here so we couldn't decide to just make these fields read on this so that nobody is tempted to feel like you know what i can actually edit this content so we can add a read only field here which is a part of html and this is just for user experience so if i reload this you'll see that these are grayed out somebody knows they are not going to be able to edit them even if they type they cannot edit them so everything is actually working out well and nice now i can make this code a little more improved because right here when we were querying our database results we were checking to see what comes back so if we check in our database and there is no information coming back there is no need for us to run this code right here so i'm just going to use this a function that we have here paste it here because it's more or less similar to what's happening and i'm going to say the database results if the database results are either now or zero or a string of zero or it's empty then all we need to do is actually return we don't do anything otherwise if it's more then we get to add more information from here so let's test this out i'll leave this vandam so that we can see more so what we're going to do is we're going to manually add another field here to insert a row so we'll just say maybe Toyota and then we'll add Mitsubishi Toyota Mitsubishi is one company i'm not really good with cars so Toyota Mitsubishi and we'll say it's a pickup and we'll say maybe it is white then it has a mileage of whatever that is and hit go so we'll pass that in let's check our WP garage we'll see it's duplicated it we'll just leave only one here so we have it five here a reload just to check you see our database covered back with zero as a field but let me allow this to pass through so reload this so we can actually see that our test is broken the first time it returns all the data but the second time it's not returning it because something is broken so let me just troubleshoot this let's check for database vandam database that's returning zero but that should be impossible because the database is supposed to return some information let's look for the available in CPT array so reload we have our two variables we have one and two showing up here so what could be the problem so let me just vadam here and see what we get for ideas we have one and two and they look really weird it's a string let's see what happens let's try to check if we can get back any database results and reload here we'll actually see that we get back one item in our array of mitsubishi pickup and kilometers and all of that so this is working out well it has contrasted everything that needed to be contrasted and sure thing everything is working out well so i'll save this we can take out all of this that is vadamping to leave our code clean and let's see if it passes this test because the Libby results will not be negative let's see if it actually saves our auto our post so when we hit it you'll see that we have our Toyota Metsubishi pickup and when we edit that it has a UID it has everything it's just working out fine and it's fantastic it's actually working out the way that i expected it to be so that is one way you can save this information is already saved in the CPTs you can actually throw this on the front and and use it in any way that you want to so go ahead try it out see let me know how you've enjoyed this code let me know if it has been helpful if it has pointed out some things to you and that's how we can work with the database so i was adding flat data here but maybe in the next video i could show you how you can make your own form that sends the data directly from the front end inside your database what do i mean i want us to automate this whole process of you saying i want to insert a row and then say i want to add a Toyota and the Toyota will be a Corolla and it will be a saloon car saloon car it's a saloon car already so this could be blue and it could have a mileage of just a few kilometers i'll add this so one of the things that we've been realizing is when we go to her table we see we've added the information twice i don't want that to happen i just want it to be only once just to test our code again if we hit this here you'll see that it actually has four pieces and we have our Toyota Corolla with all our information so it's working out very well um it's relatively performant and this is all the code that we needed so let me know what you think about this if you'd like to see more of issues like this uh tackled and cleaned out let me know uh what you think you could share your own trouble that you're having so thank you for watching uh subscribe to the channel if you haven't yet subscribed to it because we have very many interesting things coming like the video and share it with your friends thank you for watching and enjoy yourself


In today's video I'm gonna be showing you guys seven different ways on how to lace your Air Jordan 5's. So if you've never owned a pair of Jordan 5's or you're looking to do a new style, this just might be the video for you. And if you didn't know by now, my name is DJ, and this is the DNA show. So first things first, this is how the shoe looks like when it comes dead stock fresh out the box, but I want to do a little twist.  So let's go ahead and get started with style number one. And that's actually going to be the dead stock look, which is this right here. So what people typically do is they loosen the bib just a little bit because there's excess laces that come hanging out of the side like this, right? So what they're gonna do is just loosen this up and then pull a little bit on each side. That way they can actually fit their foot inside of the shoe. And then all they do is tuck the laces right back in and put the shoe on and rock them. So after seeing that dead stock look, how do you feel about it? Me personally, I never really rock my fives like that, but I know a lot of people like to. So I had to show you guys. Making the style number two. This one used to be one of my personal favorites and we call this the loose fit. So what we're gonna do again is pull the laces out right here and see how the bib is upside down. What we want to do is pull the bib all the way off of the laces. We're gonna loosen these up just a little bit and then we're gonna actually take these laces right here and pull them out from the top loop. So now they're only down here on the bottom. They're gonna put this on the front end like this and run it through the bottom, the back end of the bib. Now that we have the bib right here, we're gonna throw it through the top. So now we're gonna come in and just let the laces hang a little bit on the sides, maybe a couple inches down just like this. Then we're gonna pull the bib, tighten it just a little bit. That way we got some slack. And then loosen down the rest of the laces right here on the bottom end of the foot. So that way you have that really, really loose fit on the shoe. You kind of got the bib still kind of vibing up inside of there, but it's that really loose vibe. It's kind of gonna look something like this. So let's see what these look like on foot. This is probably one of my most commonly rock styles when it comes to the Air Jordan 5, but I have been low key switching it up a little bit over the past few years, which we'll get into in the next couple of styles. But next we're gonna go with the bow top. Hey real quick, if you guys are getting any value out of this video, make sure you guys hit that like button and I want to let you know I have a full community of dedicated sneakerheads looking to take their game to the next level and investing in the shoes, growing their collections. So if you guys are interested in that, make sure you hit the link down below in the description.  I'm looking forward to seeing you guys on the inside. All right, let's get back to the video. So for the next style, we want to make sure that the bib is off and then we have the laces up here to this white piece here. And now we're gonna go to the top end of the shoe, just right here, the next hole up. So we're gonna cross over, going from inside out, just like all the other laces are at the bottom end of the foot. And then we're gonna put the bib through here. So we're gonna go through the bottom, back through the top, just like we did earlier, bottom, back through the top. Okay. Now we want to cut some slack on it and then loosen it up. That way we got some room to put our foot inside of the shoe because when it's too tight like that, it's just look kind of drunk. It don't look too good. You don't want the bow tie to be too big, right? So you gotta make sure you slack it up just a little bit. Okay. That's cool. Now we're gonna put a bow tie on top of the bib right here. It's gonna look something like this once you put your foot in it. So let's go ahead and try these on foot and see what they look like. So this isn't one of my personal preferences, but I have definitely seen a lot of people rock with this style. Again, I have no problem with it, just not for me. Let me know how you guys feel about this style down below. Let's take it to the next style. So coming out of our dead stock look right here, we have the shoelaces sticking out at the top end.  So really all we're gonna do is just loosen it up and rock them without the bib on there. This is either the loose or the bow tie. You can go either way. We're gonna loosen it up real good and see what that looks like. So it's kind of, kind of have that little sloppy style to it right there. We're gonna try this one on foot, see what it looks like, and then we'll tie it up with a bow tie and see what that looks like as well. Now I've seen a lot of people rock with this style simply because it's a lot easier without having to worry about the bib or falling off or loosening it up or pulling your shoestring down or whatever it may be. It's easier to just throw the shoe on, tie them up, or leave them super loose. I've definitely rocked these before with the loose fit without the bib on them. But it's a Jordan 5 and I feel like you've got to have it, which brings the next one because I think this one is actually kind of cool. And that's gonna be putting the lace lock at the front of the shoe, similar to the Jordan 6.5. So this is actually two different pieces right here and what you can do is pull the red piece out of here and you got your plastic piece. So we're gonna get rid of the plastic piece and we're just gonna use the red piece and it has a little Nike air right here on the top of it. So what we wanna do is actually put this upward right here. So we're gonna have to unlace the entire shoe and lace it back up real quick and I'll show you guys what it looks like. So what we're gonna wanna do is feed the lace right here through the shoe lock and pull this through and then we're gonna make this even throughout the lace. That way it's in the center of the laces and then we can put this inside and start lacing these joints up. So we're gonna start from the outside and work our way in, pull through. Same thing with this one on the same side. Just like the regular desktop look, except for now, we have the lace lock inside of there. So we're gonna pull these through and we're gonna make sure that this is even and we wanna make sure that that Nike logo is showing on the top of the lace lock because one side doesn't have a logo on it and the other side does. So it looks dope when it's got that Nike logo sticking out right there. Bang, just like that. Okay, so now we're at the top and you got two options just like earlier. You can let it hang down a couple of inches on the side and loosen it up or you can tighten it up and put a bow tie here on the top and rock it with the bow tie like this. So let me know what you guys think about this style down below. I know it's a little bit work with un-lacing the shoe and lacing it all the way back up, but it doesn't take too long. And I think it's a pretty good look, nice little switch up. We typically see this done on the Jordan 6, but you can also do it on the Jordan 5. Another one to consider as well is moving this lace lock up into the center of the foot just in the middle of these laces. Now let's take it to the final style. Every single time we do a lacing tutorial, we gotta put the bars in there. What do I mean by the bars? I'm talking about the bars. All the laces, we gotta put the bars. So we got the laces on both opposite sides right here.  And then we're gonna pull through to the opposite side, bang, bang. And let this sit.  And then we're gonna pull through to the opposite side to the third hole. Bang, bang. All right, so from three, we're gonna go to five and pull it through. And then from two over here, we're gonna go to four. So it's eyes and evens, all the way up, switching sides, pulling through. You see we got the bars going right here. We got three, four bars right here. Then we go from four to six, bang, bang, pull through. We're gonna take the one from five right here.  I'm gonna take this one all the way to the top. See what that looks like. There's gonna be a lace showing, so we're gonna skip that one. I've never seen this done before. So we're gonna tuck this in, actually, below the tongue. So once you get to the five right there, then with six, we're gonna go across to six, bang, bang, pull through. And as you can see right here, we got the bar style. Now, I ain't seen this too often, so I'm looking forward to see what this looks like on foot. What you guys think? Drop a comment down below in the comment section. You know we always gotta finish the video with the bars. So if you guys wanna see lacing tutorials on any other Jordan Retros or other sneakers, make sure you check out the playlist that I have for you guys as well. I'm slowly getting it done with every single retro. We're gonna have a video with a bunch of different styles for every single one for y'all. So make sure you guys check that out. I hope you guys enjoyed this. I'll see you in another one. All right y'all, I'm out. I will never let you down. If you made it this far to the video and you're still thinking about it, hit the link down below in the description. Get set up, join the community. I'm excited to see you on the inside. We got a live meetup coming very soon and hopefully you guys are gonna be there. If not, we have one every single month. Plus community giveaways, we're giving away shoes every single month. There's definitely a lot of knowledge and networking on the inside as well. And I'm looking forward to helping more people buy their first property simply because of sneakers. I'm here to help you. If you want any help, make sure you guys sign up and I'll see you guys on the inside. Listen my D.A. baby, don't let your choice out. Yo, if you guys made it to the end of this video, drop a comment down below and let me know. Which one do you like more? The Fire Red or the Metallic Five? This has always been a hard debate. I really love the Fire Red, but I rock the Metallics more. So I'm gonna go with the Metallic Fire for this one. I'd like to make what I'm a winner today. I would never let you down and send my DNA. The only choice I'd like to make what I'm a winner today. I was made for it. Listen to D.A. baby.