Sometimes you need to update values incrementally in your WordPress database. You might for example have an upvote feature to which you automatically add points in an incremental fashion.
It was surprisingly hard to find examples of how to do this using Wpdb. But here’s an example of doing just that:
/* Have to use wpdb->query instead of wpdb->update because the latter assumes strings */
$results = $wpdb->query($wpdb->prepare("UPDATE foodsenglish SET popularity = popularity + 1 WHERE dbID = %d", $foodIdToSendThePointFor), ARRAY_A);
Blender, being the Swiss-army-knife -tool that it is, can also do video editing. Setting up a video editing layout is easier than ever with the new “Workspace” -system of Blender. Simply click on the + button at the end of the workspace tabs and choose Video Editing –> Video Editing. Here’s a picture:
When using Blender as a video editor, a couple of questions immediately come to mind:
How do I perform a cut? Answer: Simply press K.
How do I perform a ripple delete (an edit in which the gap of the deleted content is automatically closed)? Answer: There is no ripple edit feature at the moment, but it can still be done very quickly by hitting “Del” to delete, then “Page up” to jump the playhead to the previous cut and finally “Backspace” to “Close gap”.
How can I “render the timeline” for better playback performance? Answer: The best way might be to create Proxies. In the Proxy workflow, Blender will create new, better performing versions of your video files and use them for better work speed. These are the steps you need to take to enable Proxies in Blender Video Editor:
First find the Proxy Panel. It lives usually on the right side of the Sequencer (timeline looking panel). Select the clips you want to create a proxy for in the sequence. Click on “Set selected strip proxies” to set these clips up for proxy creation. It will ask for a desired proxy resolution. Then click “Rebuild Proxy and Timecode Indices”. Blender should now start creating the proxy files, next to your original files (although this location can be changed in the settings). It might take a while, but after it’s done, your playback should be much better.
Thanks to 3DTudor for this quick tip that can greatly speed up your texturing workflow! It’s based on first activating the Node Wrangler addon (comes with Blender) and then hitting shift+ctrl+T. The principled shader should be selected when you hit the shortcut.
I’m currently working on a project in which I need to create a lot of vector drawings. After trying Inkscape for a moment and having some frustrations with the user interface there, I decided to return to my favorite software: Blender. In this post I will document the things I learn while using the grease pencil tool to create vector art in Blender.
Sometimes you need to create many elements so that each one of them gets a unique, incrementing number. You probably already know about VS Code’s Emmet capabilities which let you type something like .myClass*5 to automatically create five divs with the class “myClass”. So the output of that would be:
For the first time in my career I encountered a video file that had two different resolutions. The beginning of the video was SD resolution and after 15 frames it jumped to a resolution of 1080p. VLC player was able to correctly switch the resolution during playback and it displayed the two different resolutions also in the codec information window. But Premiere Pro didn’t understand the file properly and never switched to the higher resolution portion of it. That was a problem because I wanted to use the high resolution in my edit.