Omnimaga
Calculator Community => Other Calc-Related Projects and Ideas => Topic started by: flyingfisch on October 28, 2013, 12:27:45 pm
-
I have been thinking about doing this for a while, and I wanted to get some feedback before I invest a lot of time and effort into it.
I was thinking that it would be cool to have a web tool that would allow artists to upload sprites in png form with a name and possibly tags, and then the server-side software would convert it to SourceCode-style sprites, and upload it to the server. Programmers could then search the site for sprites that they need, and have the sprite data ready to copy and paste into their programs.
What do you think?
-
There is already open Game Art (http://opengameart.com)
-
well, first of all, that domain name looks like its for sale, and secondly, I don't think it would give you sprite data to copy/paste into a program, would it?
-
My bad, it's .org (http://opengameart.org)
-
Oh, ok :)
EDIT:
I thought that maybe it would be nice to have a calc centered version of that, but let me know if it would be worth the effort, that's why I made this thread ;)
-
Totally worth it IMO.
-
That is a pretty awesome idea IMO! :D
-
I think I will make a poll. If more are for than against, I'll do it. ;)
-
lol, i can't see anybody being against it >.<
-
Mmmh. Sincerely why not!
-
poll added :)
lol, i can't see anybody being against it >.<
No, but it may not be worth the effort since Open Game Art would do everything this would except having copy/paste sprite data.
-
But I bet it would still be fun to program it, even though it already exists :)
-
PixelScape (http://clrhome.org/pix/) Does some of that, so maybe you could propose something like this to Deep Thought who I believe worked on Omnimaga's new image uploader, too. Maybe he could allow users to upload images that included tags to the repository, then have PixelScape be able to search the repository (as well as anybody on Omnimaga looking for images in the uploader), then the user could click the one they want and options for copy/pasting it to the editor, or directly reading it in some format for source code.
-
We could also make a site that takes sprites from OGA and convert them to code. Combine it to a userscript and you're all set. :D
-
YOu and your usercripts infected me! Hurrah for userscripts!
But OGA don't have standards, many files are zipped, some sprites aren't ngrid aligned and so on...
-
Then let's just run our own DB ! :D
-
PixelScape (http://clrhome.org/pix/) Does some of that, so maybe you could propose something like this to Deep Thought who I believe worked on Omnimaga's new image uploader, too. Maybe he could allow users to upload images that included tags to the repository, then have PixelScape be able to search the repository (as well as anybody on Omnimaga looking for images in the uploader), then the user could click the one they want and options for copy/pasting it to the editor, or directly reading it in some format for source code.
Yup, deep wrote the image uploader, i host and maintain it, and because i host it it can't really be linked easily to pixelscape, different servers...and the image uploader doesn't use a database of any kind.
-
PixelScape (http://clrhome.org/pix/) Does some of that, so maybe you could propose something like this to Deep Thought who I believe worked on Omnimaga's new image uploader, too. Maybe he could allow users to upload images that included tags to the repository, then have PixelScape be able to search the repository (as well as anybody on Omnimaga looking for images in the uploader), then the user could click the one they want and options for copy/pasting it to the editor, or directly reading it in some format for source code.
Well, since TakeFlight and ClrHome are partners, and this project is going to be cross-platform, I see no reason why I shouldn't talk to Deep about it. :)
-
Will it be able to support more than 4 shades of gray? I'd like to put my deliciously colroed sprites in it! :p
-
Will it be able to support more than 4 shades of gray? I'd like to put my deliciously colroed sprites in it! :p
I think we could do that. :)
but really, the first thing we need is the source code for sourcecoder, or maybe kerm could make some sort of api. Otherwise, I suppose I could try writing an image converter from scratch...
-
Of course, but it will only work for color calcs (though we can have a greyscale converter).
-
It would work like sourcecoder, ideally.
-
i think this would be nice
-
OK, I am going to PM kerm for the sourcecoder source code, we'll see how it goes. :)
-
I definitively think that it would be nice to have a place where we can convert sprites to various format. Either we could bug Kerm so he adds more formats to Source Coder. It would be nice if we could have multiple formats, that's for sure, such as xLIBC. Currently, SourceCoder lacks certain formats such as xLIBC and 3-bit PRIZM pictures.
Else, a public domain calculator sprite database with various formats is a good idea, although I think it would be nice if they were also posted on Omni, so people don't miss out on them.
-
Else, a public domain calculator sprite database with various formats is a good idea, although I think it would be nice if they were also posted on Omni, so people don't miss out on them.
Hmm? I don't think I understand... what about posting on omni?
My idea is to have a one stop calc sprite database. The homepage would have a searchbar, and popular sprites below it. The search bar would be a live search, so that as you type the sprites are filtered.
When you click on a sprite, it takes you to a page with the sprites description, other sprites by the same author, and all the supported formats for the sprite, ready to copy/paste into your code.
This makes it easy both for artists and programmers. The programmers simply search for what they need, and the copy/paste the code. Artists only need to upload an image, and it is automatically converted to the various sprite formats.
I may also make a sprite requests section.
Any other ideas?
-
Well I mean if someone creates a brand new site to create a big sprites database, but nobody posts their creations in the pixel art sub-forum here as a result, it would suck, since many people might only check one site and miss their creations. Hence why it would be nice to suggest uploaders to share their creations on Omni/Cemetech/etc.
-
A possibility would be to link it in the Omni navbar.
-
A possibility would be to link it in the Omni navbar.
speeking of which, the image uploader and the radio should be linked there >.<
-
/me pokes admins about it
-
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
-
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?
-
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.
-
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.
-
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...
-
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.
-
OK, I am awaiting a reply from kerm.
It sounds like he'll give me the source code though. :)
-
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. :)
-
why does this SQL code throw an error instead of creating a table?
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?
-
i thought it was only CURDATE, not CURDATE().
Also, maybe a key has a conflicting name?
-
Running it in PHPMyAdmin gives me this:
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)
);
#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
-
What about "NOW()" instead of CURDATE ?
-
NOW() and NOW also give the same error.
-
how about int(11) instead of int
-
still have errors:
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)
)
#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. :(
-
try without these other datatypes, just to see ? (lua*)
-
No errors with this:
CREATE TABLE sprites (
luazm_data text NOT NULL
)
This does give an error though:
CREATE TABLE sprites (
date_uploaded datetime NOT NULL DEFAULT CURDATE()
)
#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()
)' at line 2
EDIT:
Figured it out. With MySQL, in every case other than CURRENT_TIMESTAMP, the default value has to be constant.
http://dev.mysql.com/doc/refman/4.1/en/data-type-defaults.html
So this works:
CREATE TABLE sprites (
date_uploaded TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
)
-
OK, asking the community a question here:
Would it be more convenient for you if Open Sprite Library used OpenID, so you can login with Google or Facebook, or would you rather that I implemented a built-in login system?
-
I would prefer a built-in system as I do not like logging in with other accounts somewhere.....I prefer having many accounts :)
-
I would prefer a built-in system as I do not like logging in with other accounts somewhere.....I prefer having many accounts :)
Well that makes 2 of you, you and Kerm. So I guess I will implement a login system unless I get opposition. :)
-
Yeah I prefer sites to use their own account system. ;)
-
How about you make that you have to have an google+ account to be able to view the pics, seing that youtube can pull such stuff off for comments/me hides due to sarcasm
-
OK, the login system is implemented, and the url is now http://osl.cemetech.net (thanks Kerm!).
Todo:
- Comment system
- Custom search engine
- Most of the front-end
- Adding more sprite formats than luazm and Prizm C 16 Bit
If you want to try out the site, that's fine, just be aware that it is currently in an alpha state, and the database may be reset at any time.
Register: http://osl.cemetech.net/login.php
Upload Sprites: http://osl.cemetech.net/uploadsprite.php
Test Page (check this out for sneak peaks on what I am currently working on ;)): http://osl.cemetech.net/test.php
Login: http://osl.cemetech.net/login.php
View uploaded sprites: http://osl.cemetech.net/viewsprite.php?id=<sprite id> (try 1 and 2, when more sprites are uploaded, try others. It does not fail very gracefully though.)
-
(you may want to edit your post to link to the real register page :P )
Also, yay, gravatar :P
And I never got a verification email.....
anyways, it is looking nice so far! (yay, i got user id 2)
-
Meh, that (http://osl.cemetech.net/register.php) was easy to find! :p
Damnit, failed the spambot detection. TI stands for Titanium too!
Error on uploadsprite.
-
(you may want to edit your post to link to the real register page :P )
Also, yay, gravatar :P
And I never got a verification email.....
anyways, it is looking nice so far! (yay, i got user id 2)
umm, no email verification, the question is enough i think. Though maybe I should have a welcome email sent...
-
I tried this and it's pretty cool. It might be a good idea to rephrase the e-mail validation thing so that we don't think we're supposed to get an e-mail, though, although I guess in its current form, the message might at least discourage people from using fake e-mails.
-
I tried this and it's pretty cool. It might be a good idea to rephrase the e-mail validation thing so that we don't think we're supposed to get an e-mail, though, although I guess in its current form, the message might at least discourage people from using fake e-mails.
Well, the email needs to be valid for the "Forgot Password" function which i have yet to implement.
Thanks for the feedback guys, I'll try to keep up work on this :)
EDIT:
Have to work on comments, need to make more sprite generators. Besides that, this project is almost finished. Please report bugs!
I am thinking of making an API so that other sites can integrate with OSL, what kind of functions would you like? I was thinking one that would return an XML of all search results given a query would be good, let me know. :)
-
I keep getting "400 Bad Request" :/
-
Do you still get it? Maybe you were trying to access a page I was working on or something...
-
I am still getting the error, on each page. The rest says, "Your browser sent a request that this server could not understand."
-
I am still getting the error, on each page. The rest says, "Your browser sent a request that this server could not understand."
According to Kerm, this is a problem with cemetech's cookies. Try using this address until he fixes it: openspritelibrary.tk
-
Created account and uploaded something to test. (It seems like it doesn't support BMP format though.)
-
BMP is obsolete, though. Aside from monochrome color depth, which can be handy for providing very small calc screenshots (even more than GIFs and PNGs), BMP is just ridiculously large for any kind of image sharing and is heavily discouraged.
-
Yes, at this point at least, PNG is the only supported image format.
I will be gone for most of today, but what I need now is a PHP function to convert 24-bit RGB (as inputs $r, $g, $b) to grayscale. If someone could write one for me (or google it for me) I'd appreciate it. See ya all either later today or tomorrow.
-
I started populating it with my sprites, and it won't get my font image, which is 64*64.
Will you plan to add a kind of sprite sheet?
-
Yeah uploading sprite sheets is a must IMO.
-
You should look into the max cookie length accepted, today i had to clear all my cookies on *.cemetech.net because osl refused my connection due to sending too many cookies.
-
That, and exporting for Axe and z80Asm (and I don't even talk for n-bits export)
-
I will be gone for most of today, but what I need now is a PHP function to convert 24-bit RGB (as inputs $r, $g, $b) to grayscale. If someone could write one for me (or google it for me) I'd appreciate it. See ya all either later today or tomorrow.
isn't converting to greyscale as simple as just calculating the average of the r, g and b values?
-
No, some colors are visibly less visible than others. Yellow is less visible than magenta or cyan for instance.
-
Sorry to necro post, but I just read this topic, went (first page mention) to http://opengameart.org/ and saw a calculator 8x8 sprite dungeon by Eiyeron and just wanted to say that it's pretty funny! :D
(http://opengameart.org/content/8x8-4-gray-dungeon-set)