Author Topic: Open Sprite Library (Read 39325 times)

DJ Omnimaga · « **Reply #30 on:** October 30, 2013, 04:08:25 pm »

Quote from: Sorunome on October 30, 2013, 02:07:03 pm

Quote from: Streetwalker on October 30, 2013, 01:57:44 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.

Juju · « **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?

DJ Omnimaga · « **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.

Streetwalrus · « **Reply #33 on:** November 01, 2013, 01:29:56 pm »

Quote from: Juju 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?

Hmm, I think more something like upload a PNG or a BMP.

tpt1234567890 · « **Reply #34 on:** November 01, 2013, 04:56:50 pm »

Quote from: Streetwalker on November 01, 2013, 01:29:56 pm

Quote from: Juju 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?
Hmm, I think more something like upload a PNG or a BMP.

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

Streetwalrus · « **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.

flyingfisch · « **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.

flyingfisch · « **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.

flyingfisch · « **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?

Sorunome · « **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?

flyingfisch · « **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

Adriweb · « **Reply #41 on:** November 12, 2013, 06:45:47 pm »

What about "NOW()" instead of CURDATE ?

flyingfisch · « **Reply #42 on:** November 12, 2013, 07:15:29 pm »

NOW() and NOW also give the same error.

Sorunome · « **Reply #43 on:** November 13, 2013, 03:20:29 am »

how about int(11) instead of int

flyingfisch · « **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.

Author Topic: Open Sprite Library (Read 39325 times)

DJ Omnimaga

Re: Open Sprite Library

Juju

Re: Open Sprite Library

DJ Omnimaga

Re: Open Sprite Library

Streetwalrus

Re: Open Sprite Library

tpt1234567890

Re: Open Sprite Library

Streetwalrus

Re: Open Sprite Library

flyingfisch

Re: Open Sprite Library

flyingfisch

Re: Open Sprite Library

flyingfisch

Re: Open Sprite Library

Sorunome

Re: Open Sprite Library

flyingfisch

Re: Open Sprite Library

Adriweb

Re: Open Sprite Library

flyingfisch

Re: Open Sprite Library

Sorunome

Re: Open Sprite Library

flyingfisch

Re: Open Sprite Library