Key tips for the spin tool:
-3d cursor location will be the center point of the spin
-3d viewport orientation matters
-select the spin direction from the top bar
-hold ctrl to snap to increments
Increment integer value in a database field using WPDB
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 Video Editor Tips
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.
Quick PBR texture setup with Node Wrangler
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.
Using Blender as a vector drawing program
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.
Continue reading “Using Blender as a vector drawing program”Colorize or tint an SVG image with CSS
This is a quick example of how you can tint an svg image even if it’s added to the page externally (it’s not an inline svg):
Continue reading “Colorize or tint an SVG image with CSS”Increment number when creating multiple html elements using emmet
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:
Continue reading “Increment number when creating multiple html elements using emmet”How to check paper wallet balance by scanning the QR code with Mycelium
Do you need to verify the balance of a paper wallet but do not feel like manually typing the address to a blockchain explorer?
Continue reading “How to check paper wallet balance by scanning the QR code with Mycelium”Dealing with a multiresolution .mov file
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.
Continue reading “Dealing with a multiresolution .mov file”