It's that time of the year again: The flowers are blooming, summer is on the horizon, and your New Year's resolutions may have finally gone all the way out the window – namely, the resolution to set aside more time in your day (consistently) for your yoga practice. If this sounds like you, fret not! For many, coming into the middle part of the year can cause a return to old routines, and between that and the increasingly beautiful weather outside, it's understandable!
1. Take advantage of the beautiful weather!
We all know the trademark empty yoga class on a beautiful day. It's gorgeous out, and no one wants to stay indoors! So, what do you do? Take your practice outside, of course! Find a grassy park in your area perfect for a few downward dogs on your Mysore Practice Rug, or take a look in your local area for outdoor yoga classes. This is a great way to keep your commitment to your practice while enjoying nature.
Meditation and yoga often go hand-in-hand. If you're feeling a bit unmotivated to unroll your mat, try pulling out your Zafu cushion and meditating for 10-15 minutes beforehand instead! The act of simply sitting and meditating can sometimes feel less labor intensive than doing yoga, and the act of taking time for meditation will remind you how awesome that self-care feels – invigorating you with the energy needed to take the step from cushion to mat!
Without the necessary nutrition and hydration, it's easy for pretty much anything to seem nearly impossible! Check in with yourself: Did I eat breakfast this morning? When was the last time I drank a glass of water?
During a busy day, taking a few minutes to hydrate or eat can seem like a low-level priority. But, actually taking those moments can have a huge impact on your energy level for the day, making it easier to accomplish what you need to do and what you want to do. Try preparing your food for the next day the night before, or simply keep some easy and healthy food on hand. Some quick and super healthy options we love? Almonds, bananas, and cheese sticks! Also, make sure that you have a lightweight, reusable water bottle that's easy to grab and go wherever your day takes you.
Making a list of the reasons and ways that you value your yoga practice can be helpful for truly acting on them. Try expanding this by also listing the reasons other self-care actions (such as meditating, eating well, or making sure you get a good night's sleep) are of value to you. This helps us to become more aware of the ways in which those actions feel positive and valuable, and in turn helps make it easier to set aside time in our schedule for them.
If you're feeling stuck in your practice, there's a chance you may be feeling stuck in other ways, too. Whether it's feeling overwhelmed at work, or having another paper to turn in at school, try getting out of your normal routine! Whether it's just for a day, the weekend, or a whole week, it's important to take time for yourself, and going on a spontaneous hiking trip, or taking a sojourn to a yoga spa retreat, can help refresh and reinvigorate your body and mind.
Thanks for taking your time to read this post. Do you want to change the routine and help you stick to your practice with a yoga retreat? Click here for the biggest offering of yoga-focused travel and training courses available on the web!
Carolina is a yoga and meditation enthusiast living in Seattle, WA. She loves creating blog and social media posts for Barefoot Yoga, and has a passion for writing. To see additional posts by Carolina, check out the Barefoot Yoga blog!
For all of your yoga and meditation supply needs, go to BarefootYoga.com today!
Yoga and the wellbeing of our planet have always gone hand-in-hand. The relation comes naturally; it is the place that we live in, and as yogis, we're aware of our union with all living beings on it, we're not separate. Our bodies are made of the elements; we eat, drink and breathe from what the Earth provides. So, we should honor it every day – but especially on Earth Day!
We have the best deals and offers from 3022 organizers all over the world! Get them into your mailbox every week!


text:
Cinemablend
Disney's Hawkeye News
What The New Zelda: Breath Of The Wild Update Contains
By Will Usher published 12 November 17
Nintendo isn't done updating The Legend of Zelda: Breath of the Wild. In fact, the company is prepping for the launch of The Champions Ballad, the latest expansion for the game. The update contains a number of noteworthy additions, including support for some of the brand new Amiibo.
Gamespot rolled out details on the new update for the Nintendo Switch and Wii U versions of The Legend of Zelda: Breath of the Wild version 1.3.3. The update features a few fixes to the game, including improvements to the gameplay, and squashes to a few bugs, like the one preventing the X mark for game overs from being recorded in Hero's Path mode.
Of course, beyond the fixes, there has been some much-anticipated support for four new Amiibo figurines, including the ones based on the heroes of the Divine Beast. Each Amiibo will grant you a specific buff within the game and can be used once every 24 hours.
The Daruk Amiibo will give you a level 1 flame guard, while Mipha's Amiibo will give you a level 1 swim speed-up. Urbosa's Amiibo will give you electricity resistance and Revali will grant you cold resistance.
While the buffs are only for level 1 protection, they could definitely come in handy when playing the game and facing off against some of the Divine Beast bosses. They can be extremely difficult if you're not sure how to take them on, but with the extra buffs, it will make it a heck of a lot easier.
There's also a bonus quest that's been added to the game. The side-quest includes special armor pieces from Monolith Soft's Xenoblade Chronices 2, the upcoming action-RPG that's due out for the Nintnedo Switch.
Players will be able to unlock Rex's armor by collecting all the pieces to complete the entire set.
Nintendo has been periodically updating The Legend of Zelda: Breath of the Wild throughout the year since its release on March 3rd alongside the launch of the Nintendo Switch. One of the biggest complaints about the game on both the Wii U and Switch is that the game oftentimes run sub-30fps. The game also had some odd slowdown at times that disrupted the flow of the gameplay.
It's not like Nintendo to have a game that lacks proper performance optimization, but Breath of the Wild was just one of those really big games.
For gamers who are still playing it, the upcoming Champions Ballad will extend the gameplay even further. The expansion is only available for those who purchased the season pass for the game, and it will further the backstory involving Princess Zelda.
The expansion will also include a brand new dungeon for players to explore, along with additional gear to outfit Link with. The game was already jam-packed with tons of content, but with the next expansion, things will get even bigger for the title. Nintendo is definitely looking at having a GOTY on its hands with The Legend of Zelda: Breath of Wild, with or without the expansion packs. For now, though, gamers can experience the updates via 1.3.3 right now.
Will Usher
Staff Writer at CinemaBlend.
CINEMABLEND NEWSLETTER
Your Daily Blend of Entertainment News
Thank you for signing up to CinemaBlend. You will receive a verification email shortly.
Keira Knightley's Best Movies And How To Watch Them
Why 90 Day Fiancé: Before The 90 Days' Ben Might Be The Latest Catfish Victim
11 Great Movies Like Encanto: What To Watch If You Like The Disney Movie
How Survivor 41 Finalist Xander Hastings Feels About Dating Following His Stint On The Show
Matt Damon And Ben Affleck Reveal It Was Kevin Smith Who Saved Good Will Hunting
Cinemablend is part of Future US Inc, an international media group and leading digital publisher. Visit our corporate site.
2021 new movie releases
2021 netflix premiere schedule
2021 tv and streaming premiere
Stay in & stream
To 3d or not to 3d

redpajama_set_name: RedPajamaCommonCrawl


text:
Book Reviews / Stitch Elsewhere
[Stitch Elsewhere] "Rupert Wong and the Ends of the Earth" Review @ Strange Horizons
September 15, 2017 September 15, 2017 Stitch1 Comment
To the gods and ghouls that he cooks for, Rupert Wong is little more than a mouthy piece of meat. At best, the titular character of Cassandra Khaw's gloriously gory series hardly registers as anything more than an annoyance. At worst, he's viewed as a tool to be used up, until he can only serve as fuel and food for divinity.
Part of Abaddon Books's shared "Gods and Monsters" universe, the sequel to Khaw's 2015 novella Rupert Wong: Cannibal Chef, Rupert Wong and the Ends of the Earth plucks main-character Rupert Wong from the familiarity of his life in Kuala Lumpur, dropping him headfirst into a conflict between some heavy hitters of the Greek pantheon and members of a mysterious organization known as Vanquis. Persona non grata in his hometown due to events in the previous book that lead members of his own pantheon to view him as a traitor, Rupert is removed from everything that is familiar and is transplanted, rather abruptly, to a dreary London neighborhood that seems downright lousy with Greek gods and figures from other European mythologies.
There are two huge things that Cassandra Khaw does in Rupert Wong and the Ends of the Earth that make the book—and the characters that inhabit it—too interesting to walk away from. First, there's what drew me to Khaw's writing in the first place: how she writes about flesh and food in a way that makes reading about the go-to nourishment of ghouls and gods a chilling, but captivating experience. Then there's the way that Khaw writes the remains of the Greek pantheon struggling to gain a foothold in a world that has largely written them off as obsolete—and whose new gods are far less open to sharing.
If you've been paying attention to me at any point over the past year, you probably noticed that I'm a bit… fixated on cannibalism in fiction. From Tokyo Ghoul to Hannibal to an actual non-fiction book about how very natural cannibalism is, I've been hip deep in media and non-fiction centering the subject. It's been great and gross!
Back in 2015, author Cassandra Khaw (who happens to be one of my pals on top of being a fantastic writer) wrote a novella called Rupert Wong Cannibal Chef and I've been a huge fan ever since. And when the sequel came out this year, well… I just had to review it. When else would I get to talk about one of my favorite writers's work, cannibalism, and Greek mythology?
Head on over to Strange Horizons to read my review of Cassandra Khaw's gloriously gory Rupert Wong and the Ends of the Earth today!
book review, cannibalism, Cassandra Khaw, Rupert Wong
Rayne: A Racist Rando on my Lucifer Review
Luke Cage – Looks Like A Cinnamon Roll…
One thought on "[Stitch Elsewhere] "Rupert Wong and the Ends of the Earth" Review @ Strange Horizons"
I gotta get this book. I enjoyed the other Rupert Wong books. This one sounds like fun.
Interesting! I too seem to have a fascination with cannibalism, from studying The Donner Party, to the movie Ravenous.


text:
Eagle Mountain hydropower project clears another hurdle
The huge power plant would draw billions of gallons of groundwater from a desert aquifer.
Sammy Roth
Federal officials rejected two appeals to a planned hydropower plant near Joshua Tree National Park on Thursday, bringing the much-maligned project one step closer to reality.
The 1,300-megawatt power plant would draw about nine billion gallons of groundwater from an aquifer beneath the Chuckwalla Valley, which critics say would harm threatened species, disrupt fragile ecosystems and damage a critical water supply. The project's proponents counter that it would help California build more clean energy by banking excess electricity generated by solar and wind farms when supply exceeds demand, and then releasing that electricity when demand exceeds supply.
The Federal Energy Regulatory Commission granted a license for the hydroelectric plant in June 2014, but the National Park Service and a local group known as the Desert Protection Society quickly petitioned for a rehearing and a stay of the decision. After more than a year of silence, the commission threw out those appeals on Thursday, rejecting claims that its environmental analysis was inadequate.
"This area is very important for the desert tortoise, for golden eagles, and for bighorn sheep," said David Lamfrom, California desert program director for the nonprofit National Parks Conservation Association. "Nobody's denying that this area is incredibly important."
The Current: Want to stay updated on water and energy news?
Critics have long maintained that the commission's environmental review process was insufficient, because for years, the company that owned the land wouldn't let the company proposing the hydropower project onto its property. As a result, the environmental analysis was based entirely on aerial surveys and publicly available information.
"The entire review was done without anybody stepping foot on the property, which is a grave mistake," Lamfrom said. "How do you know what's there if you haven't been there? How do you know what rare plants are in the ground if you haven't walked the ground?"
The regulatory commission pushed back against those arguments in its decision Thursday, writing in part that the National Park Service "provides no basis for its claim that it will suffer irreparable harm in the absence of further environmental analysis." The agency also said the project is in the public interest since it would "provide a dependable source of electrical energy for the region."
The Los Angeles-based Eagle Crest Energy Company first proposed the project more than two decades ago. The company has insisted the hydropower plant wouldn't harm the aquifer below the Chuckwalla Valley since it would only remove 1 percent of the recoverable water in the basin over the next 50 years.
In shadow of Joshua Tree, debating an old mine's future
Some clean energy advocates support the hydropower project, too.
The question of how to ramp up intermittent renewables like solar and wind — which only generate electricity when the sun shines or the wind blows — has long been a major challenge for California policymakers. Since Gov. Jerry Brown signed a 50 percent clean energy mandate into law earlier this month, that challenge has become more pressing.
Right now, utility companies generally turn to natural gas-fired power plants, which contribute to climate change, to help integrate more solar and wind onto the grid. Some renewable energy experts say "pumped storage" projects like Eagle Mountain can help reduce the need for natural gas.
"As Riverside County continues to increase its role in delivering renewable power to the rest of California, we need to find ways to store energy for use at times when solar and wind are not generating power," county Supervisor John Benoit said in a statement earlier this year. "This project helps make renewable energy sources more viable, and in an environmentally sensitive manner."
The Eagle Mountain area was carved out of the southeast corner of the then-Joshua Tree National Monument more than 60 years ago to allow for industrialist Henry Kaiser to build an iron mine and a town. The mine was shut down in the early 1980s, and for more than 25 years, the Kaiser subsidiary that still owned the site supported a plan to turn it into a massive garbage dump for Los Angeles.
That plan got tied up in court, and eventually Los Angeles backed off. For several years, Kaiser officials still wouldn't sell the land to Eagle Crest. But the two sides struck a deal earlier this year, with Kaiser retaining the right to sell rock and iron ore tailings from the site.
Eagle Mountain hydropower plant takes big step forward
While Eagle Crest now owns the land and has a federal license to build the hydropower plant, several obstacles remain.
For one, the company still needs approval from the federal Bureau of Land Management to build transmission lines across public lands. The agency's Palm Springs office didn't immediately respond to a request for comment on the status of that process Thursday afternoon.
That process could give the National Park Service another venue to press the arguments that the Federal Energy Regulatory Commission rejected. The park service also said earlier this year that it would study whether parts of the Eagle Mountain area should be added to Joshua Tree National Park. The results of that study could inform the Bureau of Land Management's decision, Lamfrom said.
"What we will see is that the very concerns raised by the park service are likely going to be addressed in that study," he said. "We have the opportunity to have a more educated discussion, and we have to make sure we do that."
National Park Service looks at expanding Joshua Tree
Even if the Bureau of Land Management approves the transmission lines, local activists and national parks advocates could try to keep the hydroelectric plant tied up in court. Parts of Eagle Mountain are designated for conservation under the Desert Renewable Energy Conservation Plan, an ongoing state-federal effort that would lay the ground rules for the next 25 years of clean energy development and conservation across California's deserts.
Eagle Crest submitted comments to the Bureau of Land Management asking it to reverse those designations.
Sammy Roth writes about energy and water for The Desert Sun. He can be reached at sammy.roth@desertsun.com, (760) 778-4622 and @Sammy_Roth.


text:
START TRANSACTION;

USE nomsterz_db;

DROP TABLE IF EXISTS nomsterz_db.user;

CREATE TABLE nomsterz_db.user
(
    id 			    int(16) unsigned NOT NULL AUTO_INCREMENT,
    hash 		    varchar(160) NOT NULL DEFAULT '',
    user_type 		varchar(24) NOT NULL DEFAULT '',
    member_id  		int(16) unsigned NOT NULL DEFAULT 0,
    agent 			varchar(240) NOT NULL DEFAULT '',
    ip_address 		int(11) unsigned NOT NULL DEFAULT 0,
	user_status     enum
	                (
		                'Open',
		                'Locked:Excessive-Login-Attempts',
		                'Locked:Excessive-Signup-Attempts',
		                'Locked:Excessive-ForgotLogin-Attempts',
			            'Locked:Excessive-ChangeVerifiedLinkPassword-Attempts',
			            'Locked:Excessive-ChangeOldPassword-Attempts',
			            'Locked:Excessive-LostSignupVerification-Attempts'
	                ) NOT NULL DEFAULT 'Open',
    created 		int(11) unsigned NOT NULL DEFAULT 0,
    last_updated 	int(11) unsigned NOT NULL DEFAULT 0,

    PRIMARY KEY (id),

	KEY ndx1 (hash),
    KEY ndx3 (user_type),
    KEY ndx4 (member_id),
    KEY ndx5 (ip_address),

    KEY ndx4_5 (id,member_id),
    KEY ndx5_3 (id,agent),
    KEY ndx5_6 (id,created),
    KEY ndx5_8 (ip_address,agent)
)
ENGINE=InnoDB
AUTO_INCREMENT=1
DEFAULT CHARSET=utf8
COLLATE=utf8_unicode_ci
;

DROP TABLE IF EXISTS nomsterz_db.member_details;

CREATE TABLE IF NOT EXISTS nomsterz_db.member_details
(
    id     					INT(16) PRIMARY KEY NOT NULL AUTO_INCREMENT ,
    member_id               INT(16) NOT NULL,
    prefix           		varchar (60) DEFAULT '' NOT NULL,
    first_name              varchar (60) NOT NULL,
    mid_name1               varchar (60) DEFAULT '' NOT NULL,
    mid_name2               varchar (60) DEFAULT '' NOT NULL,
    last_name               varchar (60) NOT NULL,
    display_name            varchar (60) DEFAULT '' NOT NULL,
    suffix          		varchar (60) DEFAULT '' NOT NULL,
    gender                  int(1) NOT NULL default 0 COMMENT 'Female => 1, Male => 2, Others => empty|0|, Anything Else => suspicious',
    birth_date              date NOT NULL default '0000-00-00',
    zipcode           	    varchar(8) NOT NULL default '00000',

	personal_summary		varchar (256) DEFAULT '' NOT NULL,
    profile_pic_url			varchar (256) DEFAULT '' NOT NULL,
    personal_website_url	varchar (256) DEFAULT '' NOT NULL,
    linkedin_url			varchar (256) DEFAULT '' NOT NULL,
    google_plus_url			varchar (256) DEFAULT '' NOT NULL,
    twitter_url				varchar (256) DEFAULT '' NOT NULL,
    facebook_url            varchar (256) DEFAULT '' NOT NULL,

    created               int(11) NOT NULL,
    last_updated          int(11) NOT NULL,

	UNIQUE KEY ndx1 (member_id),
	KEY ndx2 (`first_name`, `last_name`),
	KEY ndx3 (`prefix`, `first_name`, `mid_name1`, `mid_name2`, `last_name`, `suffix`),
	KEY ndx4 (`gender`),
	KEY ndx5 (`birth_date`),
	KEY ndx6 (created),
	KEY ndx7 (last_updated)
)
	ENGINE=InnoDB
	AUTO_INCREMENT=1
	DEFAULT CHARSET=utf8
	COLLATE=utf8_unicode_ci
;

DROP TABLE IF EXISTS nomsterz_db.member_status;

CREATE TABLE nomsterz_db.member_status
(
  id 						int(16) NOT NULL AUTO_INCREMENT,
  member_id 				int(16) NOT NULL,
  status 					enum
				            (
					            'ValidMember',
					            'Successful-Signup',
					            'VerifiedEmail',
					            'VerifiedStartupDetails',
					            'BeginFirst90Days',
					            'First90DaysPlus30',
					            'TrialPeriodExpired',
					            'Premium',
					            'Standard',
					            'Basic',
					            'ChangedPassword',
					            'Paused-Member',
					            'Cancelled-Member',
					            'Cancelled-Financial',
					            'Locked:Excessive-Login-Attempts',
					            'Locked:Excessive-Signup-Attempts',
					            'Locked:Excessive-ForgotLogin-Attempts',
					            'Locked:Excessive-ChangeVerifiedLinkPassword-Attempts',
					            'Locked:Excessive-ChangeOldPassword-Attempts',
					            'Locked:Excessive-LostSignupVerification-Attempts'
				            ) NOT NULL,
  created 					int(11) NOT NULL,

  PRIMARY KEY (id),
  KEY ndx1 (member_id),
  KEY ndx2 (created),

  KEY ndx1_s (member_id, status),
  KEY ndx1_2 (member_id, created),

  KEY ndx1_s_2 (member_id, status, created)
)
	ENGINE=InnoDB
	AUTO_INCREMENT=1
	DEFAULT CHARSET=utf8
	COLLATE=utf8_unicode_ci
;

DROP TABLE IF EXISTS nomsterz_db.member;

CREATE TABLE nomsterz_db.member
(
  id 								int(16) NOT NULL AUTO_INCREMENT,
  member_type 			enum('unknown', 'business','customer','agent','guest', 'employee') NOT NULL,
  login_credentials varchar(256) NOT NULL,
  salt1 						varchar(32) NOT NULL,
  salt2 						varchar(32) NOT NULL,
  salt3 						varchar(32) NOT NULL,
  created 					int(11) NOT NULL,
  paused 						int(11) NOT NULL DEFAULT 0,
  cancelled 				int(11) NOT NULL DEFAULT 0,
  last_updated 			int(11) NOT NULL,
  PRIMARY KEY (id),
  KEY ndx2 (created),
  KEY ndx3 (last_updated),
  KEY ndx2m (created,member_type),
  KEY ndx3m (last_updated,member_type),
  KEY ndx4 (salt1,salt2,salt3)
)
	ENGINE=InnoDB
	AUTO_INCREMENT=1
	DEFAULT CHARSET=utf8
	COLLATE=utf8_unicode_ci
;

DROP TABLE IF EXISTS nomsterz_db.member_emails;

CREATE TABLE IF NOT EXISTS nomsterz_db.member_emails
(
    id 				        int(16) NOT NULL AUTO_INCREMENT,
  	member_id 				int(16) NOT NULL,
  	email_address 			varchar(255) NOT NULL,

	verification_sent		tinyint (1) NOT NULL DEFAULT 0,
	verification_sent_on    int(11) NOT NULL DEFAULT 0,

	verified				tinyint (1) NOT NULL DEFAULT 0,
	verified_on 			int(11) NOT NULL DEFAULT 0,

  	created 				int(11) NOT NULL,
  	last_updated			int(11) NOT NULL,

	PRIMARY KEY (id),
  	UNIQUE KEY `ndx1` (member_id,`email_address`),
  	UNIQUE KEY `ndx2` (`email_address`),

  	KEY `ndx3` (`verification_sent`),
  	KEY `ndx4` (`verification_sent_on`),
  	KEY `ndx5` (`verified`),
  	KEY `ndx6` (`verified_on`),

  	KEY `ndx7` (`created`),
  	KEY `ndx8` (`created`,`email_address`),

  	KEY `ndx9` (`last_updated`),
  	KEY `ndx10` (`last_updated`,`email_address`),

  	KEY `ndx11` (`email_address`,`verified`,`verification_sent`,`verification_sent_on`)
)
	ENGINE=InnoDB
	AUTO_INCREMENT=1
	DEFAULT CHARSET=utf8
	COLLATE=utf8_unicode_ci
;

DROP TABLE IF EXISTS nomsterz_db.email_status;

CREATE TABLE nomsterz_db.email_status
(
    id 						int(16) NOT NULL AUTO_INCREMENT,
    email_address 			varchar(256) NOT NULL,
    email_address_status	enum
				            (
					            'AddedUnverified',
					            'VerificationSent',
					            'VerificationSentAgain',
					            'Verified',
					            'Forgot',
					            'LostSignupVerification',
					            'Remembered',
					            'Paused',
					            'MadeDefault',
					            'Deleted',
					            'ChangedPassword',
					            'Locked:Excessive-Login-Attempts',
					            'Locked:Excessive-Signup-Attempts',
					            'Locked:Excessive-ForgotLogin-Attempts',
					            'Locked:Excessive-ChangeVerifiedLinkPassword-Attempts',
					            'Locked:Excessive-ChangeOldPassword-Attempts',
					            'Locked:Excessive-LostSignupVerification-Attempts'
				            ) NOT NULL,
    created 				int(11) NOT NULL,

    PRIMARY KEY (id),
  	KEY ndx1 (email_address),
    KEY ndx2 (created),

  	KEY ndx1_s (email_address,email_address_status),
    KEY ndx1_2 (email_address, created),

    KEY ndx1_s_2 (email_address, email_address_status, created)
)
	ENGINE=InnoDB
	AUTO_INCREMENT=1
	DEFAULT CHARSET=utf8
	COLLATE=utf8_unicode_ci
;

#############################################################################################################

USE nomsterz_utils;

DROP TABLE IF EXISTS nomsterz_utils.ip_bin;

CREATE TABLE nomsterz_utils.ip_bin
(
    id 			    int(16) NOT NULL AUTO_INCREMENT,
    user_id 	    int(16) NOT NULL,
	member_id 		int(16) NOT NULL,
    ip_address 		int(11) unsigned NOT NULL DEFAULT 0,
	ip_status       varchar(160) NOT NULL,
	created 		int(11) NOT NULL,
    last_updated 	int(11) NOT NULL,

    PRIMARY KEY (id),
    KEY ndx1 (user_id),
    KEY ndx2 (member_id),
    KEY ndx3 (ip_address),
    KEY ndx4 (created),
    KEY ndx5 (last_updated),

    KEY ndx3_is (ip_address, ip_status)
)
ENGINE=InnoDB
AUTO_INCREMENT=1
DEFAULT CHARSET=utf8
COLLATE=utf8_unicode_ci
;

DROP TABLE IF EXISTS nomsterz_utils.access_attempt;

CREATE TABLE nomsterz_utils.access_attempt
(
	id 					int(11) unsigned NOT NULL AUTO_INCREMENT,
    user_id 			int(16) unsigned DEFAULT 0,
    attempt_type 		enum
		                (
			                'LoginForm',
			                'LoginCaptchaForm',
			                'SignupForm',
			                'ForgotForm',
			                'LostSignupVerificationForm',
			                'ChangePasswordWithVerifyLinkForm',
			                'ChangePasswordWithOldPasswordForm'
		                ) NOT NULL COMMENT 'This should be the form name. Basically, these are the forms that control access to the application',
    success 			varchar(160) NOT NULL DEFAULT 0 COMMENT '1 => Success, 0 => Fail, Anything else is suspicious...for now',
    attempted_at 		int(11) unsigned NOT NULL DEFAULT 0,

    PRIMARY KEY (id),

	KEY ndx1 (user_id),
	KEY ndx2 (attempt_type),
	KEY ndx3 (success),
	KEY ndx4 (attempted_at),

    KEY ndx1_2 (user_id,attempt_type),
    KEY ndx1_3 (user_id,success),
    KEY ndx2_3 (attempt_type,success),
    KEY ndx2_4 (attempt_type,attempted_at),

    KEY ndx1_2_3 (user_id,attempt_type,success),
    KEY ndx1_2_3_4 (user_id,attempt_type,success,attempted_at)
)
	ENGINE=InnoDB
	AUTO_INCREMENT=1
	DEFAULT CHARSET=utf8
	COLLATE=utf8_unicode_ci
	COMMENT 'Inserts only'
;

DROP TABLE IF EXISTS nomsterz_utils.session;

CREATE TABLE IF NOT EXISTS nomsterz_utils.session
(
    id 				char(32) NOT NULL DEFAULT '',
    name 			char(32) NOT NULL,
    modified 	int(11) DEFAULT NULL,
    lifetime 	int(11) DEFAULT NULL,
    data 			text ,

    PRIMARY KEY (id),

		KEY `ndx1` (`name`),
		KEY `ndx2` (`modified`),
		KEY `ndx3` (`lifetime`),
		KEY `ndx1_2` (`name`,`modified`),
		KEY `ndx1_3` (`name`,`lifetime`)
)
	ENGINE=InnoDB
	AUTO_INCREMENT=1
	DEFAULT CHARSET=utf8
	COLLATE=utf8_unicode_ci
;

DROP TABLE IF EXISTS nomsterz_utils.error;

CREATE TABLE nomsterz_utils.error
(
	`id` 								int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` 					int(16) unsigned DEFAULT 0,
  `err_message` 			varchar(255) NOT NULL DEFAULT '',
  `mvc_namespace` 		varchar(160) NOT NULL DEFAULT '',
  `mvc_controller` 		varchar(160) NOT NULL DEFAULT '',
  `mvc_action` 				varchar(160) NOT NULL DEFAULT '',
  `script_name` 			varchar(240) NOT NULL DEFAULT '',
  `uri` 							varchar(240) NOT NULL DEFAULT '',
  `error_level`  			varchar(8) NOT NULL DEFAULT '',
  `error_time` 				int(11) unsigned DEFAULT 0,
  `cookie_name` 			varchar(24) DEFAULT '',
  `cookie_value` 			varchar(240) DEFAULT '',

  PRIMARY KEY (`id`),

	KEY `ndx1` (`user_id`),
  KEY `ndx2` (`mvc_namespace`),
  KEY `ndx3` (`mvc_controller`),
  KEY `ndx4` (`mvc_action`),
  KEY `ndx5` (`script_name`),
  KEY `ndx6` (`uri`),
  KEY `ndx7` (`error_time`),
  KEY `ndx8` (`cookie_name`),

  KEY `ndx7_2` (`error_time`,`mvc_namespace`),
  KEY `ndx7_3` (`error_time`,`mvc_controller`),
  KEY `ndx7_4` (`error_time`,`mvc_action`),
  KEY `ndx7_6` (`error_time`,`uri`),
  KEY `ndx7_8` (`error_time`,`cookie_name`),

  KEY `ndx7_2_3_4` (`error_time`,`mvc_namespace`,`mvc_controller`,`mvc_action`)
)
	ENGINE=InnoDB
	AUTO_INCREMENT=1
	DEFAULT CHARSET=utf8
	COLLATE=utf8_unicode_ci
;

DROP TABLE IF EXISTS nomsterz_utils.benchmarks;

CREATE TABLE nomsterz_utils.benchmarks
(
	id 						int(11) unsigned NOT NULL AUTO_INCREMENT,
  name 					varchar(160) NOT NULL DEFAULT '',
  value 				varchar(24) NOT NULL DEFAULT '0',
  description 	varchar(160) NOT NULL DEFAULT '',

  PRIMARY KEY (id),

	UNIQUE ndx1 (name),
	KEY ndx2 (name, value)
)
	ENGINE=InnoDB
	AUTO_INCREMENT=1
	DEFAULT CHARSET=utf8
	COLLATE=utf8_unicode_ci
;

DROP TABLE IF EXISTS nomsterz_utils.faq;

CREATE TABLE nomsterz_utils.faq
(
  `id` 						int(16) unsigned NOT NULL AUTO_INCREMENT,
  `category` 			varchar(120)  DEFAULT 'General',
  `title` 				varchar(120),
  `answer`  			text,
  `created` 			int(11) unsigned DEFAULT 0,
  `last_updated` 	int(11) unsigned DEFAULT 0,

  PRIMARY KEY (`id`),

	KEY `ndx1` (`title`),

  KEY `ndx1_c` (`title`, `category`),
  KEY `ndx0_t` (`id`,`created`)
)
	ENGINE=InnoDB
	AUTO_INCREMENT=1
	DEFAULT CHARSET=utf8
	COLLATE=utf8_unicode_ci
;

DROP TABLE IF EXISTS nomsterz_utils.faqhit;

CREATE TABLE nomsterz_utils.faqhit
(
  `id` 						int(16) unsigned NOT NULL AUTO_INCREMENT,
  `faq_id` 				int(16) unsigned NOT NULL ,
  `hit_time` 			int(11) unsigned DEFAULT 0,
  `user_id` 			int(16) unsigned NOT NULL DEFAULT 0,

  PRIMARY KEY (`id`),

	KEY `ndx1` (`faq_id`),
	KEY `ndx2` (`hit_time`),
	KEY `ndx3` (`user_id`),

  KEY `ndx1_2` (`faq_id`, `hit_time`),
  KEY `ndx1_3` (`faq_id`, `user_id`),
  KEY `ndx1_3_2` (`faq_id`, `user_id`, `hit_time`)
)
	ENGINE=InnoDB
	AUTO_INCREMENT=1
	DEFAULT CHARSET=utf8
	COLLATE=utf8_unicode_ci
;

##########################################

DROP TABLE nomsterz_legal.policy;

CREATE TABLE nomsterz_legal.policy
(
  `id`              int(16) NOT NULL AUTO_INCREMENT,
  `content_id`      int(16) NOT NULL,
  `title`           VARCHAR(180) NOT NULL,
  `created`         int(11) NOT NULL,
  `last_updated`    int(11) NOT NULL,

  PRIMARY KEY (`id`),
  KEY `ndx2` (`created`),
  KEY `ndx3` (`last_updated`),
  KEY `ndx2c` (`created`,`content_id`),
  KEY `ndx3c` (`last_updated`,`content_id`)
)
	ENGINE=InnoDB
	AUTO_INCREMENT=1
	DEFAULT CHARSET=utf8
	COLLATE=utf8_unicode_ci
;

DROP TABLE nomsterz_legal.policy_content;

CREATE TABLE nomsterz_legal.policy_content
(
  `id`              int(16) NOT NULL AUTO_INCREMENT,
  `policy_id`       int(16) NOT NULL,
  `heading`         text NOT NULL,
  `content_html`    text NOT NULL,
  `content_text`    text NOT NULL,
  `sequence`        int(3) NOT NULL,
  `created`         int(11) NOT NULL,
  `last_updated`    int(11) NOT NULL,

  PRIMARY KEY (`id`),
  KEY `ndx2` (`created`),
  KEY `ndx3` (`last_updated`),
  KEY `ndx2p` (`created`,`policy_id`),
  KEY `ndx3p` (`last_updated`,`policy_id`)
)
	ENGINE=InnoDB
	AUTO_INCREMENT=1
	DEFAULT CHARSET=utf8
	COLLATE=utf8_unicode_ci
;

COMMIT;

-- EOF

redpajama_set_name: RedPajamaGithub


text:
105.7 Transmitter Fund
Adacia Chambers Waives Right To Hearing In Deadly Stillwater Parade Crash Case
By Associated Press & Paige Willett • Apr 5, 2016
25-year-old Adacia Avery Chambers
Stillwater Police Department
A woman charged with killing four people and injuring dozens of others after crashing her car into spectators at Oklahoma State University's homecoming parade has waived her right to a preliminary hearing.
Adacia Chambers will go on trial for second-degree murder and more than 40 counts of assault and battery in the October 24 crash that prosecutors say was intentional. The counts each carry the possibility of a sentence of life in prison.
Payne County court records show Chambers was advised of her rights Tuesday, then waived her right to a preliminary hearing, which determines whether there is sufficient evidence that a crime occurred and probable cause the defendant committed it.
District Attorney Laura Austin Thomas told The Oklahoman's Kyle Schwab that waiving a preliminary hearing is not unusual.
"The defendant has received a large amount of discovery in this case and will continue to receive everything the state receives. The evidence against this defendant is very strong and compelling."
Chambers' defense attorney Tony Coleman has said she is mentally ill. Schwab writes Chambers told police she was suicidal at the time of the crash.
"Chambers… has a history of suicide attempts, according to a court affidavit. She said she had been treated in the past for mental health issues, police reported.
Chambers' competency to face trial was later brought into question because of the reports of mental illness. In December, a judge ruled that she is competent to face trial and can assist in her defense."
Her next court appearance is scheduled for May 4.
KGOU is a community-supported news organization and relies on contributions from readers and listeners to fulfill its mission of public service to Oklahoma and beyond. Donate online, or by contacting our Membership department.
OSU homecoming tragedy
Judge Rules Oklahoma State Parade Crash Suspect Competent To Stand Trial
By Brian Hardzinski • Dec 10, 2015
Thursday afternoon a Payne County judge ruled Adacia Chambers, the woman accused of crashing her car into a crowd of spectators at Oklahoma State University's homecoming parade in October, is competent to stand trial.
OSU Parade Crash Suspect's BAC Below Legal Limit, Press Wants Gag Order Lifted
By Brian Hardzinski • Nov 23, 2015
Court records indicate the woman accused of driving the car that crashed into a crowd of spectators at Oklahoma State University's homecoming parade a month ago had a blood alcohol content of 0.01.
Adacia Chambers was arrested on suspicion of DUI October 24. Prosecutors say she drove around a barricade and into spectators gathered to watch the parade before crashing into a pole.
Second-Degree Murder Charges Formally Filed Against Oklahoma State Parade Crash Suspect
By Brian Hardzinski • Nov 4, 2015
Payne County District Attorney Laura Thomas formally filed charges Wednesday against the woman accused of crashing her car into a crowd during Oklahoma State University's homecoming parade nearly two weeks ago. Four people died and more than 40 others were injured.
Stillwater resident Adacia Chambers faces four counts of second-degree murder, and 46 counts of felony assault. She's been held in the Payne County Jail on $1 million bond.
Psych Evaluation Ordered For Chambers, Murder Charges Expected Next Month
By Brian Hardzinski & Rachel Hubbard • Oct 26, 2015
The woman held in connection with a traffic collision during Saturday morning's homecoming parade at Oklahoma State University that killed four people and injured dozens more will be charged with second-degree murder.
Updated 2:07 p.m.: Bond set at $1 million, family addresses media
Bond has been set at $1 million for Adacia Chambers, the woman arrested in connection with Saturday's deadly car crash during Oklahoma State University's homecoming parade.


text:
require_relative '../../spec_helper'
require_lib 'reek/smell_detectors/nil_check'

RSpec.describe Reek::SmellDetectors::NilCheck do
  it 'reports the right values' do
    src = <<-RUBY
      def alfa(bravo)
        bravo.nil?
      end
    RUBY

    expect(src).to reek_of(:NilCheck,
                           lines:   [2],
                           context: 'alfa',
                           message: 'performs a nil-check',
                           source:  'string')
  end

  it 'does count all occurrences' do
    src = <<-RUBY
      def alfa(bravo, charlie)
        bravo.nil?
        charlie.nil?
      end
    RUBY

    expect(src).to reek_of(:NilCheck,
                           lines:   [2, 3],
                           context: 'alfa')
  end

  it 'reports nothing when scope includes no nil checks' do
    src = 'def alfa; end'
    expect(src).not_to reek_of(:NilCheck)
  end

  it 'reports when scope uses == nil' do
    src = <<-RUBY
      def alfa(bravo)
        bravo == nil
      end
    RUBY

    expect(src).to reek_of(:NilCheck)
  end

  it 'reports when scope uses === nil' do
    src = <<-RUBY
      def alfa(bravo)
        bravo === nil
      end
    RUBY

    expect(src).to reek_of(:NilCheck)
  end

  it 'reports when scope uses nil ==' do
    src = <<-RUBY
      def alfa(bravo)
        nil == bravo
      end
    RUBY

    expect(src).to reek_of(:NilCheck)
  end

  it 'reports when scope uses a case-clause checking nil' do
    src = <<-RUBY
      def alfa(bravo)
        case bravo
        when nil then puts "Nil"
        end
      end
    RUBY

    expect(src).to reek_of(:NilCheck)
  end

  it 'does not report when scope uses &.' do
    src = <<-RUBY
      def alfa(bravo)
        bravo&.charlie
      end
    RUBY

    expect(src).not_to reek_of(:NilCheck)
  end

  it 'reports all lines when scope uses multiple nilchecks' do
    src = <<-RUBY
      def alfa(bravo)
        bravo.nil?
        @charlie === nil
        delta&.echo
      end
    RUBY

    expect(src).to reek_of(:NilCheck, lines: [2, 3])
  end
end


Did you know that the Bible talks about Jesus being at parties more than it does about him being at church services? Let's learn how to follow Jesus by learning to be party people. Let's serve the best food and drink, let's invite all kinds of people, and let's treat 'em like kings.


Once you are employed as a mechanical engineer, it is imperative that you work hard for better career prospects. The best way to proceed in that direction would be through a mechanical engineering certification. The Six Sigma Certification program can do wonders for a mechanical engineer and brighten their prospects.
So, you are a mechanical engineer who is not very pleased with the way your career is progressing. Perhaps, you were expecting to progress a little further. Well, have you considered doing a mechanical engineering certification?
In today's world, where the competition is so intense, certification programs come in handy to bail you out of trouble. As a mechanical engineer, your prime job is to find solutions for issues in the design and implementation of certain systems on products.
Most of you are required to use live techniques on projects that are running live. Instant results are sometimes required, without which, the product may have to shut down or worse, the plant being shut permanently.
It is a high-stress field, with pressure on you constantly. In America, mechanical engineers must have what is called as licensure. It consists of work experience, proper education, and attending several examinations.
Is the Six-Sigma Program Useful for Mechanical Engineers?
The six-sigma certification program can help you develop your skills and talents. Though you would have learned a lot at college or university and are perhaps employed, you need to understand that a company is going to hire you, only if you can solve problems, live.
Simply put, companies hire candidates who have powerful problem-solving abilities. To be able to get those capabilities, a six-sigma program would be highly recommended for mechanical engineers.
What are the Career Prospects of a Mechanical Engineer with Certifications?
With a mechanical engineering certificate in your hands, you can apply to several industries including the government sector, utility firms, and automobile manufacturers. With the help of further education like an MBA program or Six Sigma certifications, you can see your career prospects widening instantly.
Those of you wanting to become professors or lecturers in colleges or universities might consider getting their doctoral degree. In the United States of America, the mean yearly package of a mechanical engineer is close to $1, 00, and 000.
According to data available, that is going to increase significantly, when compared to other jobs because of the intense competition and tasks. Fields like nanotechnology and oil and gas companies have immense potential for mechanical candidates with the right kind of certifications and talents.
As you can see, the potential for a mechanical engineer to scale the ladder to the top is a possibility provided, he has the right kind of talents, skills, and certification programs up his/her belt.
How Might an Industry Professional (Mechanical Engineering) Benefit From an Advanced Degree?
Engineering is a vast field, which has a breadth of specializations in it. However, the medicinal engineering professional offers an array of opportunities and choices that can fit an individual's abilities and preference. Entering into this profession as a professional can be done by getting several educational pathways. While getting certifications, PhD or an advanced mechanical engineer degree program can help to boost earning power and can also help to lead into job advancement.
In mechanical engineering, pursuing an additional degree brings up an opportunity to stay up to date on the latest emerging technology. The mechanical engineer degree and advanced courses get a student into a deeper dive to improve the quality of work in a particular interest area. Well, it does not only help a student to be the best in the field, but it also shows the recruiters that one is ready to take up the leadership role in the organization.
A second degree can also bring opportunities to specialize in different areas than what you might have studied in the undergraduate career, or in the nuanced speciality of your field.
Most of the professional mechanical engineers try to stay up to date by learning the latest industry trends and practices. While studying an advanced mechanical degree a student can get closer to the action of evolving and new technologies and advancements which may include innovations, research and software.
Mechanical engineering is definitely one of the most popular and every growing field, so you might have to face a lot of competition in every aspect of your career. Meanwhile, there are many new engineers vying for the latest positions, and most of them only pursue an undergraduate degree. To set apart from other engineers you can obtain a PhD or an advanced mechanical engineer degree or you can apply for internships to make yourself ahead in the same role.
While depending on your preferences and skills you can choose from different specialities in engineering that can allow you to gain focus, knowledge and high paid jobs.
Is the Professional Engineer Worth It?
In new age technology, engineering is taking center stage for all industries. Professional engineering exam help engineers to gain a license for performing engineering projects across the industry. If you are an engineering student, you must consider taking a PE license exam for a future career path.
A professional engineer license is an essential tool for engineers who are looking forward to work in the industry that matters public safety. If you have a PE license, you can work with these companies without waiting for license. Also, the PE exam and certification requires hard work and lengthy course study, so it advisable to prepare for the exam before graduation.
There are lots of benefits to professional engineering examination. The examination gives you license to perform your engineering duties with high stature. PE certified engineers gain more respect than any other engineers. If you are holding a PE exam certificate than there are more job scenarios for you in the industry. Companies look for engineers who are more qualified and certified by trusted boards. By taking and clearing professional exams, you can enter into the industry with a higher pay scale and higher authority.
Not all companies look for engineers with PE certificates neither do engineers bother to take the exam. But if you are looking for a higher level of a job like that of a structural engineer or building engineer, you need PE license. PE license assures your employers about your stability and stature. The certification is in addition to your degree, and it is always added a feather to your cap.
PE certification also engineers to take up independent consulting practice, government engineering jobs or open an engineering institution. It opens up more career area for your engineering career path. Professional engineering exam certificate is essential for engineers who are looking for opening their engineering firm and managing public works department. Although, clearing PE exam and certification is long and difficult, but it is totally worth the effort you take up for a bright future.