You are viewing page 1 of 202.
Steadfast

What is a Resurrection Body? (April 19, 2021)

By Timothy R Butler | Posted at 8:56 PM

What does it mean to be resurrected? We have lots of ideas, but are they what God is actually promising? As we continue through 1 Corinthians 15 this week, we get to that central point — and struggle — with the doctrine of the resurrection of the dead. It’s so important to understand so that we can approach life and death with the hope God gives us.

Sunday Devotional

52 Verses, 52 Books, 52 Weeks (Week 16: Joel)

By Timothy R Butler | Posted at 8:20 PM

Do the Bible’s prophecies of the end times tell us anything in our present situations? Yes, yes, indeed they do and I think about that as I turn to Joel this week. One of the things I really like about doing this 52 week journey wherein each week we look at a different book of the Bible is that it is making me share from books of the Bible I don’t turn to very often, such as Joel. But all of God’s Word is “profitable for teaching, for reproof, for correction, and for training in righteousness, that the man of God may be complete, equipped for every good work” (2 Tim 3:16 ESV) and the book of Joel has reassuring things for us to hear!

Steadfast

Spare Parts of Belief? (April 12, 2021)

By Timothy R Butler | Posted at 8:29 PM

This week on Steadfast, I looked at the promise of resurrection for each of us. Many in our society would accept a lot of Jesus’ teachings and yet discount the resurrection as just a comforting myth to help us cope with death. Paul has speaks very clearly in the next part of 1 Cor. 15 on why that cannot be.

Sunday Devotional

52 Verses, 52 Books, 52 Weeks (Week 15: Exodus)

By Timothy R Butler | Posted at 7:48 PM

Melanie takes on the next part of our this Week at Little Hills devotional series, this time turning us to Exodus for encouragement about the God who is there with us throughout life. Take a listen — you’ll be encouraged!

TestyTim

A Look at the Weeylite Sprite 20 Light Kit

The Impressively Light Lights for Photo and Video

By Timothy R Butler | Posted at 9:30 PM

If you are new to photography or videography, it is easy to overlook the importance of lighting in producing truly great results. Advances driven by machine learning photography from Apple and Google are seriously reducing the utter necessity of lighting in many situations, but if you are aiming for the best quality video, pushing your live stream into pro territory or leveraging light for artistic photography, lighting gear is your friend. And an affordable set from the maker of Viltrox lenses is a really good way to get started.

Steadfast

The Evergreen Hope of Easter (April 5, 2021)

By Timothy R Butler | Posted at 8:44 PM

The hope of Easter is based on the foundation that Jesus intended to, was able to and did accomplish salvation for us. For my new Steadfast series — “Alive” — I turn to the hope we find in 1 Corinthians 15 regarding Jesus’s resurrection.

Sunday Devotional

52 Verses, 52 Books, 52 Weeks (Week 14: Mark)

By Timothy R Butler | Posted at 7:45 PM

For Easter Sunday, I thought it would be good to turn to the Gospel of Mark’s ending (the shorter, ending — not the longer one we find in the manuscripts behind the KJV). The thing I love about this ending is that it fits with our own experience: we know the women overcome their fear, but Mark leaves us to dwell in it for awhile. I’ll share why I think he does that in the video. Happy Easter! He is Risen!

He is Risen!

By Timothy R Butler | Posted at 12:40 PM

Christ is Risen! “But in fact Christ has been raised from the dead, the firstfruits of those who have fallen asleep. For as by a man came death, by a man has come also the resurrection of the dead.” — 1 Cor. 15:20-21 (ESV)

Image

Good Friday

By Timothy R Butler | Posted at 12:23 PM

“For one will scarcely die for a righteous person—though perhaps for a good person one would dare even to die— but God shows his love for us in that while we were still sinners, Christ died for us.” (Rom. 5:7-8 ESV)

Journey through Jesus’s sacrifice with Little Hills.

Image

Resetting MySQL Primary Key in Chronological Order

By Timothy R Butler | Posted at 11:53 AM

As longtime readers of asisaid know, this blog — and my other sites — run a custom content management system called SAFARI that I started writing way back in 1999. For a long time, SAFARI evaded spam comments simply because most spammers targeted WordPress and other vastly more common CMSes. However, at some point in the mid-2010’s as I started serving as a pastor and professor, this blog went into something of a hibernation and the spammers went crazy with it. I later implemented more serious anti-spam measures, but there were already thousands of junk comments to deal with. I recently realized that my panicked hacking away at the comments back then wiped out nearly 4,000 early comments to the blog that were not spam.

I wanted to restore them from a backup I dug up, but since more comments have been posted since then, the unique id number given to each comment had been given away to other comments. The database table that stores the comments is set to auto-increment the ids, so I could remove the ids from the backed up comments before restoring them, but the result bugged me: older comments that were restored had higher id numbers than the newer comments. It didn’t ruin the function, but it bugged me.

So, I looked for a way to regenerate the unique ids and to do so in chronological order. I combined several of the answers on this Stack Overflow page to achieve the desired result:

SET @count = 0;
ALTER TABLE `uninet_comments` DROP `cid`;
ALTER TABLE `uninet_comments` ADD `cid` int UNSIGNED NOT NULL FIRST;
UPDATE `uninet_comments` SET `uninet_comments`.`cid` = @count:= @count + 1 ORDER BY `gmt` ASC;
ALTER TABLE `uninet_comments` ADD PRIMARY KEY(`cid`);

I figured I would share the queries I used in case anyone else needs to accomplish the same thing on a database.

You are viewing page 1 of 202.