Tag Archives: scripting

scripting

Godot – files in C# in Godot game engine.

Today I tested a new source code with the Godot game engine. The source code recognizes the drag and drop operation for text and image files.

C#
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
using Godot;
using System;
using System.Collections.Generic;
using System.IO;
public partial class DragAndDropImport : Control
{
private Sprite2D _imageSprite2D;
private Label _textLabel;
// Called when the node enters the scene tree for the first time.
public override void _Ready()
{
_textLabel = GetNode<Label>("VBoxContainer/Panel/Text");
_imageSprite2D = GetNode<Sprite2D>("VBoxContainer/Panel/Image");
ConnectFilesDroppedSignal();
}
private bool FileIsText(string fileName)
{
if(Path.GetExtension(fileName).ToLower().Equals(".txt"))
{
return true;
}
return false;
}
private bool FileIsImage(string fileName)
{
List<string> imageExtensions = new List<string> {".png",".jpg",".jpeg",".bmp",".svg",".svgz",".tga",".webp"};
foreach(var image in imageExtensions)
{
if (Path.GetExtension(fileName).ToLower().Equals(image))
{
return true;
}
}
return false;
}
 
private void LoadSprite2DTextureFromDisk(string imagePath, Sprite2D sprite)
{
Image img = new Image();
if(img.Load(imagePath) == Error.Ok) {
var texture = ImageTexture.CreateFromImage(img);
sprite.Texture = texture;
sprite.Centered = false;
}
else {
_textLabel.Text = "Could not load the image from " + imagePath;
};
}
private void ConnectFilesDroppedSignal() {
var rootNode = GetTree().Root;
rootNode.FilesDropped += OnFilesDropped;
}
 
public void OnFilesDropped (string[] files) {
_textLabel.Text = string.Empty;
if(FileIsText(files[0])) {
string text = File.ReadAllText(files[0]);
_textLabel.Text = text;
}
else if (FileIsImage(files[0])) {
LoadSprite2DTextureFromDisk(files[0], _imageSprite2D);
}
else
{
_textLabel.Text = "\"" + Path.GetFileName(files[0]) +"\"" + "Is not a .txt or supported image file.";
}
// print message on Godot console
//GD.Print("The files was dropped, first file is " + files[0]);
}
// Called every frame. 'delta' is the elapsed time since the previous frame.
public override void _Process(double delta)
{
}
}

Google Apps Script – reading and store feeds from feedly website – part 055.

You need to have an account with feeds on feedly.com and create a on this website. Open your google drive , create a new spreadsheet and open the Google Apps Script editor. This will allow to use this source code and the result of the running will be add into your spreadsheet:

JavaScript
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
function getFeedlyFeeds() {
  // your User ID-ul
  var userId = "";
  // your Access Token-ul
  var accessToken = "";
 
  var apiUrl = "https://cloud.feedly.com/v3/"; // URL for API Feedly
 
  //GET all feeds
  var response = UrlFetchApp.fetch(apiUrl + "streams/contents?streamId=user/" + userId + "/category/global.all", {
    headers: {
      Authorization: "Bearer " + accessToken
    },
    muteHttpExceptions: true
  });
 
  // check HTTP answer
  var statusCode = response.getResponseCode();
  if (statusCode === 200) {
    var responseData = JSON.parse(response.getContentText());
    // store data into items
    var items = responseData.items;
 
    // sorting
    items.sort(function(a, b) {
      var dateA = new Date(a.published);
      var dateB = new Date(b.published);
      return dateA - dateB;
    });
 
    // iterations for feeds
    for (var i = 0; i < items.length; i++) {
      var item = items[i];
      var title = item.title;
      var url = item.canonicalUrl || item.originId;
      var published = new Date(item.published);
 
      // create sheet name
      var sheetName = published.toISOString().split("T")[0];
 
      // get sheet
      var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(sheetName);
 
      // if sheet is not exist then create it
      if (!sheet) {
        sheet = SpreadsheetApp.getActiveSpreadsheet().insertSheet(sheetName);
        sheet.getRange("A1").setValue("Feed Title");
        sheet.getRange("B1").setValue("Feed URL");
        sheet.getRange("C1").setValue("Published Date");
      }
 
      // add feeds
      var lastRow = sheet.getLastRow();
      sheet.getRange(lastRow + 1, 1).setValue(title);
      sheet.getRange(lastRow + 1, 2).setValue(url);
      sheet.getRange(lastRow + 1, 3).setValue(published);
    }
  } else {
    Logger.log("Error HTTP: " + statusCode);
  }
}

Google Apps Script – get notification from GitHub account – part 054.

Today I will show you a Google Apps Script that resizes all images from a Google document up to 16 cm. Create a new document add some images, and from the main menu select the script editor and add this script with your google_document_id and the size of the images in cm.

JavaScript
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
function resizeImagesInGoogleDoc() {
  // Replace this with the ID of your Google Docs document
  var docId = "google_document_id";
  
  var doc = DocumentApp.openById(docId);
  var body = doc.getBody();
  var images = body.getImages();
  
  for (var i = 0; i < images.length; i++) {
    var image = images[i];
    var width = image.getWidth();
    var height = image.getHeight();
    var ratio = height / width;
    var newWidthInCm = 16.0; // Set the new width of the image in centimeters
    var newWidthInPixels = Math.round(newWidthInCm * 28.3465); // Convert centimeters to pixels using the DPI of Google Docs
    
    image.setWidth(newWidthInPixels);
    image.setHeight(Math.round(newWidthInPixels * ratio));
  }
}

Google Apps Script – get notification from GitHub account – part 053.

You need to have a GitHub account. Create a new token by following these steps: Go to your GitHub settings. Click on “Developer settings”. Click on “Personal access tokens”. Click on “Generate new token”. Select the scopes you want the token to have (in this case, make sure to select the “notifications” scope). Click on… Read More »

Google Apps Script – search YouTube by query and date – part 051.

This simple example tutorial shows how to get a list of videos from youtube based on a query search. The query is defined like this with the q for word of search, a published after date, and more …

1
2
3
4
5
6
7
8
{
    q: 'python',
    type: 'video',
    eventType: 'completed',
    maxResults: 25,
    order: 'date',
    publishedAfter: '2022-07-10T00:00:00Z'
  }

This is the source code:

JavaScript
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
function search_query(id) {
var results = YouTube.Search.list('id,snippet', {
    q: 'python',
    type: 'video',
    eventType: 'completed',
    maxResults: 25,
    order: 'date',
    publishedAfter: '2022-07-10T00:00:00Z'
  });
 
  var data = [];
  for(var i = 0; i < results.items.length; i++) {
    Logger.log(results.items[i].snippet.title);
  }
}

This is the result of running my source code:… Read More »

Google Apps Script – Google Analytics API usage limit error – part 051.

1
2
3
GoogleJsonResponseException: API call to youtube.channels.list failed with error:
The request cannot be completed because you have exceeded your
<a href="/youtube/v3/getting-started#quota">quota</a>.

… indicating that you have reached the usage limit for the YouTube API. for each A.P.I. comes a different limit of usage, on the case of YouTube API, each user is assigned a set of quota units per day, which can be used to make requests to the A.P.I. and once the usage limit… Read More »