Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - flyingfisch

Pages: 1 ... 4 5 [6] 7 8 ... 119
76
Other Calc-Related Projects and Ideas / Re: Open Sprite Library
« 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. :)

77
Other Calc-Related Projects and Ideas / Re: Open Sprite Library
« 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?

78
Other Calc-Related Projects and Ideas / Re: Open Sprite Library
« 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
            )

79
Other Calc-Related Projects and Ideas / Re: Open Sprite Library
« 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. :(

80
Site Feedback and Questions / Re: "._."
« on: November 12, 2013, 09:09:00 pm »
Just think how if he removes it or changes it, this thread will make no sense since it would be filled with the new face or just the ASCII one. :P


Well, to clarify for posterity, this is what we're talking about:

81
Other Calc-Related Projects and Ideas / Re: Open Sprite Library
« on: November 12, 2013, 07:15:29 pm »
NOW() and NOW also give the same error.

82
Other Calc-Related Projects and Ideas / Re: Open Sprite Library
« 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

83
Other Calc-Related Projects and Ideas / Re: Open Sprite Library
« 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?

84
triple necro.... wut?

85
Site Feedback and Questions / Re: "._."
« on: November 12, 2013, 05:31:39 pm »
Even if you have to just remove it without replacing, please get rid of this smiley: ._.

I can't stand it, and I don't see how it resembles the ASCII at all.

86
It's sad that not a single PRIZM game made it into this post...
* flyingfisch needs to start programming again.

87
Other Calc-Related Projects and Ideas / Re: Open Sprite Library
« 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. :)

88
Miscellaneous / Re: Quick Survey About You and Omnimaga.
« on: November 06, 2013, 06:15:30 pm »
1) How did you first learn about Omnimaga and what aspect influenced you to stay?
A link on UCF, IIRC. Programming and geekness I guess.

2) Do you feel as if we have similarities outside of programming naturally. If so, what are they? (i.e. MLP fans)
I think a love of science and math. At least for most of us it seems. Also geek gaming, like text-based RPG's and chess.

3) For what reason(s) do you frequent Omnimaga over other sites like Cemetech or TIPlanet? (Or vise-versa)
I frequent UCF, Cemetech, Omnimaga, and Casiopeia exactly the same amount because all those sites are pinned tabs, and automatically open whenever I open firefox. They never get closed. But I probably am more partial to UCF because I am an admin there, and Cemetech because it seems more PRIZM dev happens there. But I check all the sites about the same amount.

4) Do you consider the community of Omnimaga to have a main goal(s)? (if so, what are they?)
Not sure. Getting people to realize how much fun programming is?

5) How do you feel your relationship is with other members?
Good, I guess. Some more than others, obviously.

6) Do you find that Omnimaga (and calc programming) has helped you in the outside world?
Calc programming has, yes. I don't know about omnimaga specifically though.

7) What is your favorite inside joke/lingo?  (i.e. Holy Necropost Batman!  or Welcome peanuts etc.)
Not really sure I have one. I used to be really into that but now it seems a bit spammy. Though I do joke like that sometimes, don't get me wrong.

8 ) What country are you from?
Come on, haven't you heard about the NSA? (jk, just look at my profile)
If you have any questions or ideas for new questions, feel free to ask or let me know Smiley

89
Other Calc-Related Projects and Ideas / Re: Open Sprite Library
« 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. :)

90
News / Re: Casio PRIZM OS 2.00 released
« on: November 05, 2013, 07:39:26 am »
What can vectors do on this OS? Does this add some extra BASIC commands for drawing or is it purely for maths?
Not sure...


Also, Probability Simulator is pretty cool.

Pages: 1 ... 4 5 [6] 7 8 ... 119