Online Users Page


QN

New Blog Entry In Todd's Film Reviews!
More..

X27

Administrator
Joined on 4/5/13
Level 17


Accomplishments

 Joined SocialCu.be in the first year

QuickNote stars received: 6

Biography

D/C++/C#/Java/PHP/JS dev
I made some games on here and randomly fix bugs.

My github page:
https://github.com/ArthurCose

Add me on discord to get programming help/chat/complain:
Konstinople#7692

Recent QuickNotes


View All

Options

Wall

17X27
7 months ago
Roblox 👀
17X27
8 months ago
Made a super basic extension for anyone who suffers when controlling videos using arrow keys + space bar on YouTube.

I actually made it over a year ago, but only just set up content to satisfy Google's requirements for posting to the store. Had a friend create the logo, and quickly created the "screenshots" for the store listing.

I feel like something has been/should've been made by now for this, I just couldn't find anything.
17X27
8 months ago
@execle silently making amazing QNs
17X27
8 months ago
I thought Wikipedia was upset about something and changed their logo to various drawings of computers crying.

17X27
10 months ago
Game streaming services should advertise the reliability of their cloud saves more lol
17X27
11 months ago
Black is a color.

Hue != color
1IcecreamSheep 11 months ago
Hewwo! I'm new! I'm @X27's bf. Nice to meet you all! (◍•ᴗ•◍)✧*。
17X27
12 months ago
Made a discord bot to automatically remove ifunny/reddit watermarks from images.

https://github.com/ArthurCose/croppable-watermark-remover

Lmk if one of these already exists, since I only made it because I couldn't find an existing bot.
60.:A-MAN:.
12 months ago
@X27 (and anyone interested) here's the difference between the canvas (on Chrome) and the server's QN output. 1 is the output, 2 is what the browser canvas displayed.
17X27
1 year ago
Made a contribution to a small project months ago, got my role on their discord channel changed to developer, haven't messed with it in a while since the main dev hasn't shown interest anymore.

Now I'm getting a bunch of PMs about "my" game >.<
17X27
1 year ago
Hoping docker can give me a proper Apache setup that I can feel happy about, but also don't want to spend days setting up and learning it lol

I'll get it eventually
17X27
1 year ago
We really have a hashtag feature that tells us there's no hashtag feature huh
17X27
1 year ago
The more I mess with Apache, the more I think about throwing it out and rewriting everything with something else.
17X27
1 year ago
Anyone know if there's something like tagged templates from js, in php?

Hoping to transform something like this:
`SELECT * FROM MyTable WHERE Something=${"abc"} AND SomethingElse=${1}`


Into something like this:
{
    $stmt = $Conn->prepare("SELECT * FROM MyTable WHERE Something=? AND SomethingElse=?");
    $stmt->bindParam(1, $param[0], PDO::PARAM_STR);
    $stmt->bindParam(2, $param[1], PDO::PARAM_INT);
    $stmt->execute();

    return $stmt->fetch();
}


I've got an example of how it can be done in js, and it will output to the console to show it's working/what it does.
Bottom half is what actually matters:

class PDO {
  static PARAM_STR = "PARAM_STRING";
  static PARAM_INT = "PARAM_INT";
  // other types...

  prepare(query) {
    return new PreparedStatement(query);
  }
}

class PreparedStatement {
  constructor(query) {
    console.log(query);
  }

  bindParam(parameter, variable, dataType) {
    console.log(parameter, variable, dataType);
  }
}

// set up fake connection
const Conn = new PDO();


// actual meat of what i'm trying to show
function safeQuery(strings, ...params) {
  const query =
    strings.join("?") + (strings.length == params.length ? "?" : "");

  const stmt = Conn.prepare(query);

  for (let i = 0; i < params.length; i++) {
    const value = params[i];
    let type;

    // prob a better way to do this, like a dictionary
    switch (typeof value) {
      case "string":
        type = PDO.PARAM_STR;
        break;
      case "number":
        // we could resolve into other types like double, float
        // esp in php
        type = PDO.PARAM_INT;
        break;
      default:
      // error handling bla bla
    }

    stmt.bindParam(i + 1, value, type);
  }
}

safeQuery`SELECT * FROM MyTable WHERE Something=${"abc"} AND SomethingElse=${1}`;


Would make writing queries + converting possibly unsafe ones way easier.
17X27
1 year ago
Has anyone checked out Sudomemo? Their website is a lot better since I've last looked at it, really amazed it's still around.
v3.2