Author Topic: Open Sprite Library  (Read 39082 times)

0 Members and 1 Guest are viewing this topic.

Offline Adriweb

  • Editor
  • LV10 31337 u53r (Next: 2000)
  • **********
  • Posts: 1708
  • Rating: +229/-17
    • View Profile
    • TI-Planet.org
Re: Open Sprite Library
« Reply #45 on: November 13, 2013, 09:26:39 am »
try without these other datatypes, just to see ? (lua*)
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 #46 on: November 13, 2013, 09:29:24 am »
No errors with this:

Code: [Select]
CREATE TABLE sprites (
            luazm_data text NOT NULL
            )

This does give an error though:
Code: [Select]
CREATE TABLE sprites (
            date_uploaded datetime NOT NULL DEFAULT CURDATE()
            )

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()
            )' 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:
Code: [Select]
CREATE TABLE sprites (
            date_uploaded TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
            )
« Last Edit: November 13, 2013, 09:37:18 am 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 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 #47 on: November 13, 2013, 12:09:20 pm »
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?



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: 7920
  • Rating: +374/-13
  • Derpy Hooves
    • View Profile
    • My website! (You might lose the game)
Re: Open Sprite Library
« Reply #48 on: November 13, 2013, 12:14:29 pm »
I would prefer a built-in system as I do not like logging in with other accounts somewhere.....I prefer having many accounts :)

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 #49 on: November 13, 2013, 12:17:46 pm »
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. :)



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 Streetwalrus

  • LV12 Extreme Poster (Next: 5000)
  • ************
  • Posts: 3821
  • Rating: +80/-8
    • View Profile
Re: Open Sprite Library
« Reply #50 on: November 13, 2013, 01:21:38 pm »
Yeah I prefer sites to use their own account system. ;)

Offline Sorunome

  • Fox Fox Fox Fox Fox Fox Fox!
  • Support Staff
  • LV13 Extreme Addict (Next: 9001)
  • *************
  • Posts: 7920
  • Rating: +374/-13
  • Derpy Hooves
    • View Profile
    • My website! (You might lose the game)
Re: Open Sprite Library
« Reply #51 on: November 13, 2013, 01:55:14 pm »
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
* Sorunome hides due to sarcasm

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 #52 on: November 13, 2013, 09:27:19 pm »
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.)



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: 7920
  • Rating: +374/-13
  • Derpy Hooves
    • View Profile
    • My website! (You might lose the game)
Re: Open Sprite Library
« Reply #53 on: November 14, 2013, 10:40:55 am »
(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)

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

Offline Eiyeron

  • Urist McEiyolobster
  • LV10 31337 u53r (Next: 2000)
  • **********
  • Posts: 1430
  • Rating: +130/-10
  • (-_(//));
    • View Profile
    • Rétro-Actif : Rétro/Prog/Blog
Re: Open Sprite Library
« Reply #54 on: November 14, 2013, 02:33:05 pm »
Meh, that was easy to find! :p

Damnit, failed the spambot detection. TI stands for Titanium too!

Error on uploadsprite.
« Last Edit: November 14, 2013, 02:34:59 pm by Eiyeron »

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 #55 on: November 14, 2013, 02:38:52 pm »
(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...



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 DJ Omnimaga

  • Clacualters are teh gr33t
  • CoT Emeritus
  • LV15 Omnimagician (Next: --)
  • *
  • Posts: 55943
  • Rating: +3154/-232
  • CodeWalrus founder & retired Omnimaga founder
    • View Profile
    • Dream of Omnimaga Music
Re: Open Sprite Library
« Reply #56 on: November 14, 2013, 10:30:01 pm »
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.

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 #57 on: November 15, 2013, 09:14:07 am »
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. :)
« Last Edit: November 15, 2013, 11:32:16 am 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 Xeda112358

  • they/them
  • Moderator
  • LV12 Extreme Poster (Next: 5000)
  • ************
  • Posts: 4704
  • Rating: +719/-6
  • Calc-u-lator, do doo doo do do do.
    • View Profile
Re: Open Sprite Library
« Reply #58 on: November 15, 2013, 11:32:46 am »
I keep getting "400 Bad Request" :/

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 #59 on: November 15, 2013, 11:54:36 am »
Do you still get it? Maybe you were trying to access a page I was working on or something...



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