Author Topic: Open Sprite Library  (Read 11584 times)

0 Members and 1 Guest are viewing this topic.

Offline DJ Omnimaga

  • Now active at https://codewalr.us
  • CoT Emeritus
  • LV15 Omnimagician (Next: --)
  • *
  • Posts: 55816
  • Rating: +3151/-232
  • CodeWalrus founder & retired Omnimaga founder
    • View Profile
    • CodeWalrus
Re: Open Sprite Library
« Reply #30 on: October 30, 2013, 04:08:25 pm »
A possibility would be to link it in the Omni navbar.
speeking of which, the image uploader and the radio should be linked there >.<
And vice-versa. :P
In case you are wondering where I went, I left Omni back in 2015 to form CodeWalrus due to various reasons explained back then, but I stopped calc dev in 2016 and am now mostly active on the CW Discord server at https://discord.gg/cuZcfcF


Bandcamp|Reverbnation|Facebook|Youtube|Twitter

Offline Juju

  • Incredibly sexy mare
  • Coder Of Tomorrow
  • LV13 Extreme Addict (Next: 9001)
  • *************
  • Posts: 5730
  • Rating: +500/-19
  • Weird programmer
    • View Profile
    • juju2143's shed
Re: Open Sprite Library
« Reply #31 on: October 30, 2013, 04:15:29 pm »
That would actually be a nice idea. People would upload their art in source format or in Axe format or whatever and people would download them converted in all the applicable formats, along with a HTML-generated preview. Can I help?
« Last Edit: October 30, 2013, 04:15:39 pm by Juju »

Remember the day the walrus started to fly...

I finally cleared my sig after 4 years you're happy now?
THEGAME
This signature is ridiculously large you've been warned.

The cute mare that used to be in my avatar is Yuki Kagayaki, you can follow her on Facebook and Tumblr.

Offline DJ Omnimaga

  • Now active at https://codewalr.us
  • CoT Emeritus
  • LV15 Omnimagician (Next: --)
  • *
  • Posts: 55816
  • Rating: +3151/-232
  • CodeWalrus founder & retired Omnimaga founder
    • View Profile
    • CodeWalrus
Re: Open Sprite Library
« Reply #32 on: October 30, 2013, 04:42:29 pm »
It would be cool if you could. Just keep in mind, though: For the time being, xLIBC only allows 128x64 sprite sheets and 80x60 background pics. As a result, converting an individual sprite is impossible.
In case you are wondering where I went, I left Omni back in 2015 to form CodeWalrus due to various reasons explained back then, but I stopped calc dev in 2016 and am now mostly active on the CW Discord server at https://discord.gg/cuZcfcF


Bandcamp|Reverbnation|Facebook|Youtube|Twitter

Offline Streetwalrus

  • LV12 Extreme Poster (Next: 5000)
  • ************
  • Posts: 3820
  • Rating: +80/-8
    • View Profile
Re: Open Sprite Library
« Reply #33 on: November 01, 2013, 01:29:56 pm »
That would actually be a nice idea. People would upload their art in source format or in Axe format or whatever and people would download them converted in all the applicable formats, along with a HTML-generated preview. Can I help?
Hmm, I think more something like upload a PNG or a BMP.
send it

Offline tpt1234567890

  • LV3 Member (Next: 100)
  • ***
  • Posts: 45
  • Rating: +0/-0
    • View Profile
Re: Open Sprite Library
« Reply #34 on: November 01, 2013, 04:56:50 pm »
That would actually be a nice idea. People would upload their art in source format or in Axe format or whatever and people would download them converted in all the applicable formats, along with a HTML-generated preview. Can I help?
Hmm, I think more something like upload a PNG or a BMP.

I think it should be either PNG, BMP, JPEG, or GIF images...

Offline Streetwalrus

  • LV12 Extreme Poster (Next: 5000)
  • ************
  • Posts: 3820
  • Rating: +80/-8
    • View Profile
Re: Open Sprite Library
« Reply #35 on: November 01, 2013, 06:22:57 pm »
Definitely not JPEG which is only for photos though GIF can be cool for animated sprites. They're not very convenient to make though so you might as well upload all the frames as a sprite sheet. But for the heck of it we should support all the widespread formats out there.
send it

Offline flyingfisch

  • I'm 1337 now!
  • Members
  • LV10 31337 u53r (Next: 2000)
  • **********
  • Posts: 1620
  • Rating: +94/-17
  • Testing, testing, 1...2...3...4...5...6...7...8..9
    • View Profile
    • Top Page Website Design
Re: Open Sprite Library
« Reply #36 on: November 06, 2013, 10:42:55 am »
OK, I am awaiting a reply from kerm.

It sounds like he'll give me the source code though. :)



Quote from: my dad
"welcome to the world of computers, where everything seems to be based on random number generators"



The Game V. 2.0

Offline flyingfisch

  • I'm 1337 now!
  • Members
  • LV10 31337 u53r (Next: 2000)
  • **********
  • Posts: 1620
  • Rating: +94/-17
  • Testing, testing, 1...2...3...4...5...6...7...8..9
    • View Profile
    • Top Page Website Design
Re: Open Sprite Library
« Reply #37 on: November 09, 2013, 12:34:10 pm »
OK, kerm says that his code would probably make my work harder as it isn't very well documented, so I am going to write my own code. :)



Quote from: my dad
"welcome to the world of computers, where everything seems to be based on random number generators"



The Game V. 2.0

Offline flyingfisch

  • I'm 1337 now!
  • Members
  • LV10 31337 u53r (Next: 2000)
  • **********
  • Posts: 1620
  • Rating: +94/-17
  • Testing, testing, 1...2...3...4...5...6...7...8..9
    • View Profile
    • Top Page Website Design
Re: Open Sprite Library
« Reply #38 on: November 12, 2013, 06:24:21 pm »

why does this SQL code throw an error instead of creating a table?

Code: [Select]
CREATE TABLE "sprites" (
            id int NOT NULL auto_increment,
            name varchar(30) NOT NULL,
            uploader varchar(30) NOT NULL,
            tags varchar(255) NOT NULL,
            date_uploaded datetime NOT NULL DEFAULT CURDATE(),
            luazm_data text NOT NULL,
            prizm_data_16bit text NOT NULL,
            PRIMARY KEY (id)
            );

I have determined that there is something wrong with CURDATE(), but I got that line from a w3schools tutorial so I think it should work?



Quote from: my dad
"welcome to the world of computers, where everything seems to be based on random number generators"



The Game V. 2.0

Offline Sorunome

  • Fox Fox Fox Fox Fox Fox Fox!
  • Support Staff
  • LV13 Extreme Addict (Next: 9001)
  • *************
  • Posts: 7917
  • Rating: +373/-13
  • Derpy Hooves
    • View Profile
    • My website! (You might lose the game)
Re: Open Sprite Library
« Reply #39 on: November 12, 2013, 06:27:24 pm »
i thought it was only CURDATE, not CURDATE().
Also, maybe a key has a conflicting name?

THE GAME
Also, check out my website
If OmnomIRC is screwed up, blame me!
Click here to give me an internet!

Offline flyingfisch

  • I'm 1337 now!
  • Members
  • LV10 31337 u53r (Next: 2000)
  • **********
  • Posts: 1620
  • Rating: +94/-17
  • Testing, testing, 1...2...3...4...5...6...7...8..9
    • View Profile
    • Top Page Website Design
Re: Open Sprite Library
« Reply #40 on: November 12, 2013, 06:31:10 pm »
Running it in PHPMyAdmin gives me this:
Code: [Select]
CREATE TABLE "sprites" (
            id int NOT NULL auto_increment,
            name varchar(30) NOT NULL,
            uploader varchar(30) NOT NULL,
            tags varchar(255) NOT NULL,
            date_uploaded datetime NOT NULL DEFAULT CURDATE,
            luazm_data text NOT NULL,
            prizm_data_16bit text NOT NULL,
            PRIMARY KEY (id)
            );

Code: [Select]
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"sprites" (
            id int NOT NULL auto_increment,
            name varch' at line 1
« Last Edit: November 12, 2013, 06:31:17 pm by flyingfisch »



Quote from: my dad
"welcome to the world of computers, where everything seems to be based on random number generators"



The Game V. 2.0

Offline Adriweb

  • Editor
  • LV10 31337 u53r (Next: 2000)
  • **********
  • Posts: 1708
  • Rating: +229/-17
    • View Profile
    • TI-Planet.org
Re: Open Sprite Library
« Reply #41 on: November 12, 2013, 06:45:47 pm »
What about "NOW()" instead of CURDATE ?
My calculator programs
TI-Planet.org co-admin.
TI-Nspire Lua programming : Tutorials  |  API Documentation

Offline flyingfisch

  • I'm 1337 now!
  • Members
  • LV10 31337 u53r (Next: 2000)
  • **********
  • Posts: 1620
  • Rating: +94/-17
  • Testing, testing, 1...2...3...4...5...6...7...8..9
    • View Profile
    • Top Page Website Design
Re: Open Sprite Library
« Reply #42 on: November 12, 2013, 07:15:29 pm »
NOW() and NOW also give the same error.



Quote from: my dad
"welcome to the world of computers, where everything seems to be based on random number generators"



The Game V. 2.0

Offline Sorunome

  • Fox Fox Fox Fox Fox Fox Fox!
  • Support Staff
  • LV13 Extreme Addict (Next: 9001)
  • *************
  • Posts: 7917
  • Rating: +373/-13
  • Derpy Hooves
    • View Profile
    • My website! (You might lose the game)
Re: Open Sprite Library
« Reply #43 on: November 13, 2013, 03:20:29 am »
how about int(11) instead of int

THE GAME
Also, check out my website
If OmnomIRC is screwed up, blame me!
Click here to give me an internet!

Offline flyingfisch

  • I'm 1337 now!
  • Members
  • LV10 31337 u53r (Next: 2000)
  • **********
  • Posts: 1620
  • Rating: +94/-17
  • Testing, testing, 1...2...3...4...5...6...7...8..9
    • View Profile
    • Top Page Website Design
Re: Open Sprite Library
« Reply #44 on: November 13, 2013, 09:22:50 am »
still have errors:

Code: [Select]
CREATE TABLE sprites (
            id int(11) NOT NULL auto_increment,
            name varchar(30) NOT NULL,
            uploader varchar(30) NOT NULL,
            tags varchar(255) NOT NULL,
            date_uploaded datetime NOT NULL DEFAULT CURDATE(),
            luazm_data text NOT NULL,
            prizm_data_16bit text NOT NULL,
            PRIMARY KEY (id)
            )

Code: [Select]
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CURDATE(),
            luazm_data text NOT NULL,
            prizm_data_16bit ' at line 6


BTW, MySQL error reporting is even worse than PHP's. :(



Quote from: my dad
"welcome to the world of computers, where everything seems to be based on random number generators"



The Game V. 2.0