I have a model from Source Filmmaker that has a bunch of different textures. It's all imported and ready to be textured using Blender nodes, but since there are so many objects (over 40) in this particular model, I figure it would be a waste of time to manually reshade/texture every single material which could take several hours. Instead, I could just write a simple script that could read the texture VMT files (from SFM) which define what each texture file is for (diffuse, bumpmap, etc.) in batch and create all the Blender shaders nodes automagically once the .blend file is there. The snag is .blend is a binary file, and I can't read it or edit it in a text editor. Is there any way at all to create Blender nodes programmatically (i.e. not inside the Blender GUI but perhaps importing other things or using addons?)
How can I define the different properties of an Cycles/Eevee material? Such things as glossy, glass, diffuse, RGB-color, emissive via python scripting?
Mysql Pivot rows into dynamic columns with unknown number of columns I have an output of a query as follows:  bid  | code | amount        | ----------------------------- 2915 | BF   |   -10700.00   | 2915 | YQ   |   -300.00     | 2915 | YR   |   0.00        | 2915 | YM   |   0.00        | 2915 | WO   |   -153.00     | 2915 | IN   |   -329.00     | 2915 | K3   |   0.00        | 2915 | CUTE |   -50.00      | -----------------------------   I need to convert the values in code column to individual columns with column name as corresponding code and amount shall be the value.  bid  | BF       | YQ     | ... | CUTE  | ---------------------------------------- 2915 | -10700.00| -300.00| ... | -50.00|   The issue is that the result of my initial query has dynamic codes and hence need to generate columns accordingly.  Already tried the following logic but couldn't achieve the goal:   , ,   All the above links use some expression or the other to generate the columns.   My original resulting rows are result of simple select on multiple joined tables, and has no calculation or expression scope.  Kindly suggest some pointer or hint on how to achieve this.  Many thanks in advance. What character / attack / stage combination can get me a combo of 100? For the first two challenge panels, I just used my golden hammers on the "get a combo of x," but now I'm seeing on challenge panel 3, the game expects you to get a combo of 100! I can barely get past a combo of 9 without the counter resetting. What character / stage combination can get you a combo of 100? Are there multiple, so I can more easily get the "get a total combo of 400 across all characters" challenge?  Additionally, what exactly constitutes a combo? Sometimes my combos are cut short and sometimes they're longer, so I must not understand how they're tracked. Creating image with specific latitude/longitude positions using GDAL? I have an ASCII file with latitude, longitude, and data_val in the following format.  35-13.643782N, 080-57.190157W, 118.6 ...   I have a GeoTiff image file, and I can easily view it.  I want to place a "pin" (can be a dot/flag/star or whatever is easiest) on the image at the specific latitude/longitude position found in the ASCII file.  Here is what I've managed to do so far:  My source image looks like this:  Driver: GTiff/GeoTIFF Files: /tmp/Charlotte SEC 100.tif Size is 16867, 12358 Coordinate System is: PROJCS["Lambert Conformal Conic",     GEOGCS["NAD83",         DATUM["North_American_Datum_1983",             SPHEROID["GRS 1980",6378137,298.2572221010042,                 AUTHORITY["EPSG","7019"]],             AUTHORITY["EPSG","6269"]],         PRIMEM["Greenwich",0],         UNIT["degree",0.0174532925199433],         AUTHORITY["EPSG","4269"]],     PROJECTION["Lambert_Conformal_Conic_2SP"],     PARAMETER["standard_parallel_1",38.66666666666666],     PARAMETER["standard_parallel_2",33.33333333333334],     PARAMETER["latitude_of_origin",34.11666666666667],     PARAMETER["central_meridian",-78.75],     PARAMETER["false_easting",0],     PARAMETER["false_northing",0],     UNIT["metre",1,         AUTHORITY["EPSG","9001"]]] Origin = (-365041.822331817995291,240536.419747152860509) Pixel Size = (42.334586069440391,-42.334898968590878) Metadata:   AREA_OR_POINT=Area   TIFFTAG_DATETIME=2016:06:24 12:46:45   TIFFTAG_RESOLUTIONUNIT=2 (pixels/inch)   TIFFTAG_SOFTWARE=Adobe Photoshop CS5 Windows   TIFFTAG_XRESOLUTION=300   TIFFTAG_YRESOLUTION=300 Image Structure Metadata:   COMPRESSION=LZW   INTERLEAVE=BAND Corner Coordinates: Upper Left  ( -365041.822,  240536.420) ( 82d48'55.43"W, 36d13' 4.92"N) Lower Left  ( -365041.822, -282638.262) ( 82d35'10.11"W, 31d30'17.00"N) Upper Right (  349015.641,  240536.420) ( 74d51'46.40"W, 36d13'26.16"N) Lower Right (  349015.641, -282638.262) ( 75d 4'55.60"W, 31d30'36.99"N) Center      (   -8013.091,  -21050.921) ( 78d50'12.11"W, 33d55'36.35"N) Band 1 Block=16867x1 Type=Byte, ColorInterp=Palette   Color Table (RGB with 256 entries)     0: 255,255,255,255 ...   Here is what I've managed to cobble together in Python:  from osgeo import gdal, osr  src_filename = '/tmp/Charlotte SEC 100.tif' dst_filename = '/tmp/foo.tiff'  # Opens source dataset src_ds = gdal.Open(src_filename) format = "GTiff" driver = gdal.GetDriverByName(format)  # Open destination dataset dst_ds = driver.CreateCopy(dst_filename, src_ds, 0)  # Specify raster location through geotransform array # (upperleftx, scalex, skewx, upperlefty, skewy, scaley) # Scale = size of one pixel in units of raster projection # this example below assumes 100x100 gt = [-365041.822, 100, 0, 240536.420, 0, -100]  # Set location dst_ds.SetGeoTransform(gt)  # Get raster projection epsg = 4269            # http://spatialreference.org/ref/sr-org/lambert_conformal_conic_2sp/ srs = osr.SpatialReference() srs.ImportFromEPSG(epsg) dest_wkt = srs.ExportToWkt()  # Set projection dst_ds.SetProjection(dest_wkt)  # Close files dst_ds = None src_ds = None   But, I can't quite figure out how to place a "red dot" at 35-13.643782N, 080-57.190157W  I'm having to learn some new details here (nomenclature about GIS). Grant Select on a view not base table when base table is in a different database I have a view which is selecting rows from a table in a different database.  I'd like to grant select access to the view, but not direct access to the base table.  The view has a where clause restricting the number of rows.  Can I grant select to the view and not the base table, or do I need to switch to a stored procedure? I would rather not do it the latter way. Setting Zero values back to NULL How do high traffic sites service more than 65535 TCP connections? How to check whether a JavaScript variable defined in cross-browser way?  I ran into this problem when writing some JavaScript utilizing FireBug logging. I wrote some code like below:  function profileRun(f) {     // f: functions to be profiled     console.profile(f.constructor);     f();     console.profileEnd(f.constructor); }   It works fine in FireFox/FireBug, but it reports error in IE8 RC1. So, I'd like to do some checking whether console variable exists in the execution environment.  Below code works fine in FireFox, but not in IE8 RC1.   function profileRun(f) {     if (console != undefined) {         console.profile(f.constructor);     }      f();      if (console != undefined) {         console.profileEnd(f.constructor);     } }   However, if I do it this way. It works in IE8 RC1. Why?   function profileRun(f) {     if (window.console != undefined) {         console.profile(f.constructor);     }      f();      if (window.console != undefined) {         console.profileEnd(f.constructor);     } }   Is there any cross-browser way to check it? What software do you use to keep up to date on literature, and if Google Scholar, how do you avoid information overload? xcode4 doesn't support Perforce? leaflet geojson coordinate problem I just started to play with leflet/geojson a little. But my coordinates are not rendered properly and I have no clue what is going on.  My coordinates are: 52.23943, 4.97599. They work correct with the setView function.  var map = L.map('leaflet_map').setView([52.23943, 4.97599], 15);   But using a geojasonFeature they are, hmmm, 'projected', somewhere east of Somalia.  var geojsonFeature = {             "type": "Feature",             "properties": {             "name": "Coors Field",             "amenity": "Baseball Stadium",             "popupContent": "This is where the Rockies play!"             },             "geometry": {                 "type": "Point",                 "coordinates": [52.23943, 4.97599]             }         };         var myLayer = L.geoJson().addTo(map);         myLayer.addData(geojsonFeature).bindPopup("I am a gjson point.");   Anyone who knows what is happening here?  EDIT  Out of pure curiosity I changed the coordinates around [4.976143930893815,52.23925499011473] and the point appears at its correct location. A known bug!? Why is the empty set considered an interval? Install GNOME Shell extensions from terminal Is there a way to install GNOME extensions from terminal, for example dash to dock? The way I do it now is to go into Ubuntu Software app store and install it. Donating winning lottery ticket to 501(c)3 Private Foundation: cost-basis deduction + full tax free redemption for foundation? US 501(c)3 Private Foundations are typically controlled by the primary donator, so that is a nice perk, but in exchange for that perk I realize the tax deductions for donating are significantly lowered than for charities. Aside from being lower, the tax code doesn't recognize appreciated property and only allows for a deduction based on the donating taxpayer's cost-basis: ie. the price they paid for the property no matter its current market value.  When there is a significant delta of price paid vs current redeemable value, it seems this can still be a perk for the donating taxpayer in some circumstances, such as with lottery tickets that are known winners already.  If the donating taxpayer pays $1 for the ticket. Their cost basis is $1. If the ticket is now worth $100,000,000 but has not been redeemed, is it accurate that the donating taxpayer can donate this to their private foundation for a deduction at cost basis, and the private foundation can redeem the $100,000,000 ticket completely exempt from all lottery withholding income taxes?   (Other taxes unique to private foundations are known and outside the scope of this question.)  Most literature I can find is about appreciated marketable securities, and occasionally real estate. It doesn't seem that the tax code specifies any distinction between property, but it also doesn't seem the answer to this question is part of the general collective conscious even if it really is that obvious if my understanding is already correct. Converting expressions to polynomial form Is it ever bad to use \left and \right? For mathematics, is it ever disadvantageous to use \left(  and \right)  in equations?  I can't see any way that doing this would hinder the typesetting, so why isn't () just converted into \left( \right) automatically? This would save a lot of typing.  Cheers! How can I override the OnBeforeUnload dialog and replace it with my own? I need to warn users about unsaved changes before they leave a page (a pretty common problem). window.onbeforeunload = handler  This works but it raises a default dialog with an irritating standard message that wraps my own text. I need to either completely replace the standard message, so my text is clear, or (even better) replace the entire dialog with a modal dialog using jQuery. So far I have failed and I haven't found anyone else who seems to have an answer. Is it even possible? Javascript in my page: &lt;script type=&quot;text/javascript&quot;&gt;        window.onbeforeunload = closeIt; &lt;/script&gt;  The closeIt() function: function closeIt() {   if (changes == &quot;true&quot; || files == &quot;true&quot;)   {       return &quot;Here you can append a custom message to the default dialog.&quot;;   } }  Using jQuery and jqModal I have tried this kind of thing (using a custom confirm dialog): $(window).beforeunload(function () {     confirm('new message: ' + this.href + ' !', this.href);     return false; });  which also doesn't work - I cannot seem to bind to the beforeunload event. Q&A Identification of seldom man-made physical objects not being piece of art? Is SE Q&amp;A format relevant for "identification of seldom physical objects observed in real world"?  Questions like "I do not know function of this object (picture) - which purpose does it have?"  In many cases I suppose these question could have civil engineering or handcraft i.e. cultural/historical background. In second case "SE history" might be okay. For first case, I do not know. Three inches of snow is/are expected? I'm thinking that the singular verbs "is" and "has" are correct below because we're referring to a singular lump of precipitation. Although the subject "inches" is plural, I think the singular verbs are correct below. We wouldn't say, "Fifty dollars are a lot of money." I think this is basically the same concept.  Good for the singular verbs below?  One to 3 inches of snow "is" expected. (Not: ... are expected.)  Ten inches of snow "has" fallen. (Not: ... have fallen.) How does two-weapon fighting work? I'm quite confused about attacking with two weapons in both hands and wondering what is required to be able to do to (in Pathfinder).  1. Base Attack Bonus Looking at the base attack bonus tables for different classes (e.g. the ) it seems like up to +5 you get only one attack per full action but starting from base-attack-bonus of +6 you get a second attack with +1.  2. Feats There is a feat . The existence of the feat sounds like you could not do two-weapon-fighting without it. However, in the description of "normal" it says:     If you wield a second weapon in your off hand, you can get one extra attack per round with that weapon. When fighting in this way you suffer a –6 penalty with your regular attack or attacks with your primary hand and a –10 penalty to the attack with your off hand. If your off-hand weapon is light, the penalties are reduced by 2 each.   3. Core Rulebook Chapter about combat If I understand the  it says that you need a full-round action do attack with both weapons in two hands.  So how do these things interact? Can I only attack with my off-hand weapon if my base-attack-bonus is high enough that I get second one with +1?  If not, how does the "multiple attacks from high base-attack-bonus" interact with dual-wielding? Assuming I reached a state of base-attack-bonus with +11/+6/+1 and have a full-round action to attack. Does that mean I can either attack with my primary weapon three times or use the primary weapon and off-hand weapon to attack only twice? Why would I then ever choose dual-wielding? Or can I attack three times with both weapons (leading to a total of 6 attacks with heavy malus) Or would I get 3 attacks with the primary weapon + 1 attack with the off-hand weapon? If so, what attack bonus do I have to use for each of the attacks? How can I prove the inequality $|xy|\leq\frac{1}{2}(x^2+y^2)$  I have tried substitute $x,y$ for numbers, which turns out right, but I don't know how to reason here.  Thanks in advance!