Announcement

Collapse

The Rules of Pacers Digest

Hello everyone,

Whether your are a long standing forum member or whether you have just registered today, it's a good idea to read and review the rules below so that you have a very good idea of what to expect when you come to Pacers Digest.

A quick note to new members: Your posts will not immediately show up when you make them. An administrator has to approve at least your first post before the forum software will later upgrade your account to the status of a fully-registered member. This usually happens within a couple of hours or so after your post(s) is/are approved, so you may need to be a little patient at first.

Why do we do this? So that it's more difficult for spammers (be they human or robot) to post, and so users who are banned cannot immediately re-register and start dousing people with verbal flames.

Below are the rules of Pacers Digest. After you have read them, you will have a very good sense of where we are coming from, what we expect, what we don't want to see, and how we react to things.

Rule #1

Pacers Digest is intended to be a place to discuss basketball without having to deal with the kinds of behaviors or attitudes that distract people from sticking with the discussion of the topics at hand. These unwanted distractions can come in many forms, and admittedly it can sometimes be tricky to pin down each and every kind that can rear its ugly head, but we feel that the following examples and explanations cover at least a good portion of that ground and should at least give people a pretty good idea of the kinds of things we actively discourage:

"Anyone who __________ is a liar / a fool / an idiot / a blind homer / has their head buried in the sand / a blind hater / doesn't know basketball / doesn't watch the games"

"People with intelligence will agree with me when I say that __________"

"Only stupid people think / believe / do ___________"

"I can't wait to hear something from PosterX when he/she sees that **insert a given incident or current event that will have probably upset or disappointed PosterX here**"

"He/she is just delusional"

"This thread is stupid / worthless / embarrassing"

"I'm going to take a moment to point and / laugh at PosterX / GroupOfPeopleY who thought / believed *insert though/belief here*"

"Remember when PosterX said OldCommentY that no longer looks good? "

In general, if a comment goes from purely on topic to something 'ad hominem' (personal jabs, personal shots, attacks, flames, however you want to call it, towards a person, or a group of people, or a given city/state/country of people), those are most likely going to be found intolerable.

We also dissuade passive aggressive behavior. This can be various things, but common examples include statements that are basically meant to imply someone is either stupid or otherwise incapable of holding a rational conversation. This can include (but is not limited to) laughing at someone's conclusions rather than offering an honest rebuttal, asking people what game they were watching, or another common problem is Poster X will say "that player isn't that bad" and then Poster Y will say something akin to "LOL you think that player is good". We're not going to tolerate those kinds of comments out of respect for the community at large and for the sake of trying to just have an honest conversation.

Now, does the above cover absolutely every single kind of distraction that is unwanted? Probably not, but you should by now have a good idea of the general types of things we will be discouraging. The above examples are meant to give you a good feel for / idea of what we're looking for. If something new or different than the above happens to come along and results in the same problem (that being, any other attitude or behavior that ultimately distracts from actually just discussing the topic at hand, or that is otherwise disrespectful to other posters), we can and we will take action to curb this as well, so please don't take this to mean that if you managed to technically avoid saying something exactly like one of the above examples that you are then somehow off the hook.

That all having been said, our goal is to do so in a generally kind and respectful way, and that doesn't mean the moment we see something we don't like that somebody is going to be suspended or banned, either. It just means that at the very least we will probably say something about it, quite possibly snipping out the distracting parts of the post in question while leaving alone the parts that are actually just discussing the topics, and in the event of a repeating or excessive problem, then we will start issuing infractions to try to further discourage further repeat problems, and if it just never seems to improve, then finally suspensions or bans will come into play. We would prefer it never went that far, and most of the time for most of our posters, it won't ever have to.

A slip up every once and a while is pretty normal, but, again, when it becomes repetitive or excessive, something will be done. Something occasional is probably going to be let go (within reason), but when it starts to become habitual or otherwise a pattern, odds are very good that we will step in.

There's always a small minority that like to push people's buttons and/or test their own boundaries with regards to the administrators, and in the case of someone acting like that, please be aware that this is not a court of law, but a private website run by people who are simply trying to do the right thing as they see it. If we feel that you are a special case that needs to be dealt with in an exceptional way because your behavior isn't explicitly mirroring one of our above examples of what we generally discourage, we can and we will take atypical action to prevent this from continuing if you are not cooperative with us.

Also please be aware that you will not be given a pass simply by claiming that you were 'only joking,' because quite honestly, when someone really is just joking, for one thing most people tend to pick up on the joke, including the person or group that is the target of the joke, and for another thing, in the event where an honest joke gets taken seriously and it upsets or angers someone, the person who is truly 'only joking' will quite commonly go out of his / her way to apologize and will try to mend fences. People who are dishonest about their statements being 'jokes' do not do so, and in turn that becomes a clear sign of what is really going on. It's nothing new.

In any case, quite frankly, the overall quality and health of the entire forum's community is more important than any one troublesome user will ever be, regardless of exactly how a problem is exhibiting itself, and if it comes down to us having to make a choice between you versus the greater health and happiness of the entire community, the community of this forum will win every time.

Lastly, there are also some posters, who are generally great contributors and do not otherwise cause any problems, who sometimes feel it's their place to provoke or to otherwise 'mess with' that small minority of people described in the last paragraph, and while we possibly might understand why you might feel you WANT to do something like that, the truth is we can't actually tolerate that kind of behavior from you any more than we can tolerate the behavior from them. So if we feel that you are trying to provoke those other posters into doing or saying something that will get themselves into trouble, then we will start to view you as a problem as well, because of the same reason as before: The overall health of the forum comes first, and trying to stir the pot with someone like that doesn't help, it just makes it worse. Some will simply disagree with this philosophy, but if so, then so be it because ultimately we have to do what we think is best so long as it's up to us.

If you see a problem that we haven't addressed, the best and most appropriate course for a forum member to take here is to look over to the left of the post in question. See underneath that poster's name, avatar, and other info, down where there's a little triangle with an exclamation point (!) in it? Click that. That allows you to report the post to the admins so we can definitely notice it and give it a look to see what we feel we should do about it. Beyond that, obviously it's human nature sometimes to want to speak up to the poster in question who has bothered you, but we would ask that you try to refrain from doing so because quite often what happens is two or more posters all start going back and forth about the original offending post, and suddenly the entire thread is off topic or otherwise derailed. So while the urge to police it yourself is understandable, it's best to just report it to us and let us handle it. Thank you!

All of the above is going to be subject to a case by case basis, but generally and broadly speaking, this should give everyone a pretty good idea of how things will typically / most often be handled.

Rule #2

If the actions of an administrator inspire you to make a comment, criticism, or express a concern about it, there is a wrong place and a couple of right places to do so.

The wrong place is to do so in the original thread in which the administrator took action. For example, if a post gets an infraction, or a post gets deleted, or a comment within a larger post gets clipped out, in a thread discussing Paul George, the wrong thing to do is to distract from the discussion of Paul George by adding your off topic thoughts on what the administrator did.

The right places to do so are:

A) Start a thread about the specific incident you want to talk about on the Feedback board. This way you are able to express yourself in an area that doesn't throw another thread off topic, and this way others can add their two cents as well if they wish, and additionally if there's something that needs to be said by the administrators, that is where they will respond to it.

B) Send a private message to the administrators, and they can respond to you that way.

If this is done the wrong way, those comments will be deleted, and if it's a repeating problem then it may also receive an infraction as well.

Rule #3

If a poster is bothering you, and an administrator has not or will not deal with that poster to the extent that you would prefer, you have a powerful tool at your disposal, one that has recently been upgraded and is now better than ever: The ability to ignore a user.

When you ignore a user, you will unfortunately still see some hints of their existence (nothing we can do about that), however, it does the following key things:

A) Any post they make will be completely invisible as you scroll through a thread.

B) The new addition to this feature: If someone QUOTES a user you are ignoring, you do not have to read who it was, or what that poster said, unless you go out of your way to click on a link to find out who it is and what they said.

To utilize this feature, from any page on Pacers Digest, scroll to the top of the page, look to the top right where it says 'Settings' and click that. From the settings page, look to the left side of the page where it says 'My Settings', and look down from there until you see 'Edit Ignore List' and click that. From here, it will say 'Add a Member to Your List...' Beneath that, click in the text box to the right of 'User Name', type in or copy & paste the username of the poster you are ignoring, and once their name is in the box, look over to the far right and click the 'Okay' button. All done!

Rule #4

Regarding infractions, currently they carry a value of one point each, and that point will expire in 31 days. If at any point a poster is carrying three points at the same time, that poster will be suspended until the oldest of the three points expires.

Rule #5

When you share or paste content or articles from another website, you must include the URL/link back to where you found it, who wrote it, and what website it's from. Said content will be removed if this doesn't happen.

An example:

If I copy and paste an article from the Indianapolis Star website, I would post something like this:

http://www.linktothearticlegoeshere.com/article
Title of the Article
Author's Name
Indianapolis Star

Rule #6

We cannot tolerate illegal videos on Pacers Digest. This means do not share any links to them, do not mention any websites that host them or link to them, do not describe how to find them in any way, and do not ask about them. Posts doing anything of the sort will be removed, the offenders will be contacted privately, and if the problem becomes habitual, you will be suspended, and if it still persists, you will probably be banned.

The legal means of watching or listening to NBA games are NBA League Pass Broadband (for US, or for International; both cost money) and NBA Audio League Pass (which is free). Look for them on NBA.com.

Rule #7

Provocative statements in a signature, or as an avatar, or as the 'tagline' beneath a poster's username (where it says 'Member' or 'Administrator' by default, if it is not altered) are an unwanted distraction that will more than likely be removed on sight. There can be shades of gray to this, but in general this could be something political or religious that is likely going to provoke or upset people, or otherwise something that is mean-spirited at the expense of a poster, a group of people, or a population.

It may or may not go without saying, but this goes for threads and posts as well, particularly when it's not made on the off-topic board (Market Square).

We do make exceptions if we feel the content is both innocuous and unlikely to cause social problems on the forum (such as wishing someone a Merry Christmas or a Happy Easter), and we also also make exceptions if such topics come up with regards to a sports figure (such as the Lance Stephenson situation bringing up discussions of domestic abuse and the law, or when Jason Collins came out as gay and how that lead to some discussion about gay rights).

However, once the discussion seems to be more/mostly about the political issues instead of the sports figure or his specific situation, the thread is usually closed.

Rule #8

We prefer self-restraint and/or modesty when making jokes or off topic comments in a sports discussion thread. They can be fun, but sometimes they derail or distract from a topic, and we don't want to see that happen. If we feel it is a problem, we will either delete or move those posts from the thread.

Rule #9

Generally speaking, we try to be a "PG-13" rated board, and we don't want to see sexual content or similarly suggestive content. Vulgarity is a more muddled issue, though again we prefer things to lean more towards "PG-13" than "R". If we feel things have gone too far, we will step in.

Rule #10

We like small signatures, not big signatures. The bigger the signature, the more likely it is an annoying or distracting signature.

Rule #11

Do not advertise anything without talking about it with the administrators first. This includes advertising with your signature, with your avatar, through private messaging, and/or by making a thread or post.
See more
See less

URGENT: Does anyone here know how to use MySQL?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • URGENT: Does anyone here know how to use MySQL?

    I'm trying to create a simple, modifiable inventory table for my final project, but I just can't figure out how to properly set up a database. I have watched countless instructional videos and it's just not clicking, and I'm quickly running out of time to get this done...

  • #2
    Re: URGENT: Does anyone here know how to use MySQL?

    Can't help you buddy. Wish I could.

    Comment


    • #3
      Re: URGENT: Does anyone here know how to use MySQL?

      Databases make me feel like I have a learning disability. They completely baffle me.
      “Success is not final, failure is not fatal: it is the courage to continue that counts.” - Winston Churchill

      “If you can't be a good example, then you'll just have to serve as a horrible warning.” - Catherine Aird

      Comment


      • #4
        Re: URGENT: Does anyone here know how to use MySQL?

        Originally posted by Los Angeles View Post
        Databases make me feel like I have a learning disability. They completely baffle me.
        Ditto. I'm going over the instructional vids for the billionth time and am slowly starting to understand some basic stuff, but everything's due before Thursday. I don't know if I can figure it out in time. Looks like it's time to pull some all-nighters...

        Comment


        • #5
          Re: URGENT: Does anyone here know how to use MySQL?

          Originally posted by Shade View Post
          Ditto. I'm going over the instructional vids for the billionth time and am slowly starting to understand some basic stuff, but everything's due before Thursday. I don't know if I can figure it out in time. Looks like it's time to pull some all-nighters...
          When I worked with Kiva Networking as a sales guy, several years ago, the techies there loved MySQL and they all thought Bill Gates was the anti-christ. Find some Linux or Unix lovers and you will probably be 7 degrees of separation from a My SQL afficianado.

          Good Luck!
          “Seventy percent of me talking on the court is personally for me to get me
          motivated and going. Thirty percent is to see if I can get into the opponent’s head.”
          Reggie Miller

          Comment


          • #6
            Re: URGENT: Does anyone here know how to use MySQL?

            No one?

            Comment


            • #7
              Re: URGENT: Does anyone here know how to use MySQL?

              Download the MySQL GUI Tools.

              http://dev.mysql.com/downloads/gui-tools/5.0.html

              MySQL Administrator has a GUI you can use to create user IDs, schema (the DB), tables in the DB, columns in the tables, etc.
              You're caught up in the Internet / you think it's such a great asset / but you're wrong, wrong, wrong
              All that fiber optic gear / still cannot take away the fear / like an island song

              - Jimmy Buffett

              Comment


              • #8
                Re: URGENT: Does anyone here know how to use MySQL?

                You probably already have some sample "create table" SQL. Here's another one:

                Code:
                drop table if exists PACER_GAME;
                
                CREATE TABLE PACER_GAME
                (
                    PACER_GAME_ID MEDIUMINT NOT NULL,
                    SEASON_ID MEDIUMINT NOT NULL,
                    GAME_DATE DATETIME NOT NULL,
                    IS_HOME_GAME MEDIUMINT NOT NULL,
                    OPPONENT VARCHAR(16) NOT NULL,
                    THREAD_POSTED DATETIME,
                    GUESS_THREAD_ID MEDIUMINT,
                    THREAD_CLOSED DATETIME,
                    WINNER_POSTED DATETIME,
                    PACER_SCORE MEDIUMINT,
                    OPPONENT_SCORE MEDIUMINT,
                    PRIMARY KEY(PACER_GAME_ID),
                    FOREIGN KEY (SEASON_ID) REFERENCES SEASON (SEASON_ID)
                );
                You're caught up in the Internet / you think it's such a great asset / but you're wrong, wrong, wrong
                All that fiber optic gear / still cannot take away the fear / like an island song

                - Jimmy Buffett

                Comment


                • #9
                  Re: URGENT: Does anyone here know how to use MySQL?

                  Thanks Doug! I'm gonna check that out.

                  I'm not allowed to use a GUI for my class, but maybe it'll help me understand the code a little better.

                  Btw, does anyone know how to use the source command to load a .sql file into MySQL? I keep getting a syntax error whenever I try:

                  Code:
                  mysql> source randomfile.sql

                  Comment


                  • #10
                    Re: URGENT: Does anyone here know how to use MySQL?

                    I think Shade is one of these guys who will be late to his own funeral.

                    Comment


                    • #11
                      Re: URGENT: Does anyone here know how to use MySQL?

                      Hey Doug, is that the code for the RoboDoug table?

                      Could you (or anyone) give me any tips on how to build a basic inventory table? Basically, I'm looking to construct a table for my gaming cards, so I need variables for the card name, set, value, and quantity.

                      Right now, my basic table looks like this:

                      Code:
                      DROP TABLE IF EXISTS mtgStore;
                      DROP TABLE IF EXISTS card;
                      DROP TABLE IF EXISTS name;
                      DROP TABLE IF EXISTS set;
                      DROP TABLE IF EXISTS value;
                      DROP TABLE IF EXISTS quantity;
                      
                      CREATE TABLE mtgStore (
                      cardID int(11) NOT NULL AUTO_INCREMENT,
                      name varchar(50) default NULL,
                      set varchar(50) default NULL,
                      value varchar(10) default NULL,
                      quantity varchar(5) default NULL,
                      PRIMARY KEY  (cardID)
                      ); 
                      
                      INSERT INTO mtgStore VALUES (
                        null, 'Fulminator Mage', 'Shadowmoor', '11.36', '2'
                      );
                      
                      INSERT INTO mtgStore VALUES (
                        null, 'Vexing Shusher', 'Shadowmoor', '12.10', '0'
                      );
                      
                      INSERT INTO mtgStore VALUES (
                        null, 'Bitterblossom', 'Morningtide', '13.12', '1'
                      );
                      
                      INSERT INTO mtgStore VALUES (
                        null, 'Chameleon Colossus', 'Morningtide', '10.92', '1'
                      );
                      
                      INSERT INTO mtgStore VALUES (
                        null, 'Mutavault', 'Morningtide', '19.51', '1'
                      );
                      
                      INSERT INTO mtgStore VALUES (
                         null, 'Garruk Wildspeaker', 'Lorwyn', '15.39', '1'
                       );
                      
                      INSERT INTO mtgStore VALUES (
                         null, 'Thoughtseize', 'Lorwyn', '14.65', '1'
                       );
                      
                      INSERT INTO mtgStore VALUES (
                          null, 'Pithing Needle', '10th Edition', '11.09', '1'
                        );
                      
                      INSERT INTO mtgStore VALUES (
                         null, 'Tarmogoyf', 'Future Sight', '37.75', '1'
                       );
                      
                      INSERT INTO mtgStore VALUES (
                         null, 'Damnation', 'Planar Chaos', '15.69', '1'
                       );
                      Am I at least on the right path?

                      Comment


                      • #12
                        Re: URGENT: Does anyone here know how to use MySQL?

                        Originally posted by Shade View Post
                        Hey Doug, is that the code for the RoboDoug table?

                        Could you (or anyone) give me any tips on how to build a basic inventory table? Basically, I'm looking to construct a table for my gaming cards, so I need variables for the card name, set, value, and quantity.

                        Right now, my basic table looks like this:

                        Code:
                        DROP TABLE IF EXISTS mtgStore;
                        DROP TABLE IF EXISTS card;
                        DROP TABLE IF EXISTS name;
                        DROP TABLE IF EXISTS set;
                        DROP TABLE IF EXISTS value;
                        DROP TABLE IF EXISTS quantity;
                        
                        CREATE TABLE mtgStore (
                        cardID int(11) NOT NULL AUTO_INCREMENT,
                        name varchar(50) default NULL,
                        set varchar(50) default NULL,
                        value varchar(10) default NULL,
                        quantity varchar(5) default NULL,
                        PRIMARY KEY  (cardID)
                        ); 
                        
                        INSERT INTO mtgStore VALUES (
                          null, 'Fulminator Mage', 'Shadowmoor', '11.36', '2'
                        );
                        
                        INSERT INTO mtgStore VALUES (
                          null, 'Vexing Shusher', 'Shadowmoor', '12.10', '0'
                        );
                        
                        INSERT INTO mtgStore VALUES (
                          null, 'Bitterblossom', 'Morningtide', '13.12', '1'
                        );
                        
                        INSERT INTO mtgStore VALUES (
                          null, 'Chameleon Colossus', 'Morningtide', '10.92', '1'
                        );
                        
                        INSERT INTO mtgStore VALUES (
                          null, 'Mutavault', 'Morningtide', '19.51', '1'
                        );
                        
                        INSERT INTO mtgStore VALUES (
                           null, 'Garruk Wildspeaker', 'Lorwyn', '15.39', '1'
                         );
                        
                        INSERT INTO mtgStore VALUES (
                           null, 'Thoughtseize', 'Lorwyn', '14.65', '1'
                         );
                        
                        INSERT INTO mtgStore VALUES (
                            null, 'Pithing Needle', '10th Edition', '11.09', '1'
                          );
                        
                        INSERT INTO mtgStore VALUES (
                           null, 'Tarmogoyf', 'Future Sight', '37.75', '1'
                         );
                        
                        INSERT INTO mtgStore VALUES (
                           null, 'Damnation', 'Planar Chaos', '15.69', '1'
                         );
                        Am I at least on the right path?
                        Yes, that is one of the RoboDoug tables. There's others.

                        That's the one that holds the Pacers game schedule, and keeps track of what RoboDoug has done for the game - posted the guess thread, closed it, posted the winner. And the score of the game. The guesses are kept in another table, as is the season.

                        In this case, I'm not using auto-increment keys, so my program calculates the PACER_GAME_ID itself.

                        But basically, for that table, I'm doing my inserts about like you:


                        Code:
                        insert into PACER_GAME (PACER_GAME_ID, SEASON_ID, GAME_DATE, IS_HOME_GAME, OPPONENT)
                        values (7009, 1071, '2007-10-31 19:00', '1', 'Washington');
                        insert into PACER_GAME (PACER_GAME_ID, SEASON_ID, GAME_DATE, IS_HOME_GAME, OPPONENT)
                        values (7010, 1071, '2007-11-2 19:00', '1', 'Miami');
                        insert into PACER_GAME (PACER_GAME_ID, SEASON_ID, GAME_DATE, IS_HOME_GAME, OPPONENT)
                        values (7011, 1071, '2007-11-3 20:00', '0', 'Memphis');
                        insert into PACER_GAME (PACER_GAME_ID, SEASON_ID, GAME_DATE, IS_HOME_GAME, OPPONENT)
                        values (7012, 1071, '2007-11-7 19:00', '1', 'L.A. Clippers');
                        insert into PACER_GAME (PACER_GAME_ID, SEASON_ID, GAME_DATE, IS_HOME_GAME, OPPONENT)
                        values (7013, 1071, '2007-11-9 19:00', '0', 'Charlotte');
                        insert into PACER_GAME (PACER_GAME_ID, SEASON_ID, GAME_DATE, IS_HOME_GAME, OPPONENT)
                        values (7014, 1071, '2007-11-10 19:00', '1', 'Denver');
                        And so on... (I actually generate the inserts by using a Perl program to parse the .CSV format schedule that is available on pacers.com...)

                        I use the column names in my insert statement, but that's optional as long as the values match the order of the columns in the table you are inserting into.

                        Are card, name, set, value, and quantity other tables, or the columns in the mtgStore table?

                        Code:
                        DROP TABLE IF EXISTS card;
                        DROP TABLE IF EXISTS name;
                        DROP TABLE IF EXISTS set;
                        DROP TABLE IF EXISTS value;
                        DROP TABLE IF EXISTS quantity;
                        If they are just the columns, then there is no reason to have those statements.

                        I tend not to allow NULL in a column unless it can truly be NULL. For example, the first columns in my table have NOT NULL because it would make no sense to have a game without an opponent. However, the others are nullable because I can have a game that doesn't have a score yet.

                        Hope that helps. I'll be gone for the rest of the night, but I'll check back tomorrow to see if you have any questions.

                        Oh, and "quantity" should probably be a numeric type of some sort...

                        I orginally wrote RoboDoug using MySQL 3.x - if I were writing that DDL (the create table stmt) now, I would probably use the standard SQL data types instead the MySQL extensions. See: http://dev.mysql.com/doc/refman/5.0/...ric-types.html
                        You're caught up in the Internet / you think it's such a great asset / but you're wrong, wrong, wrong
                        All that fiber optic gear / still cannot take away the fear / like an island song

                        - Jimmy Buffett

                        Comment


                        • #13
                          Re: URGENT: Does anyone here know how to use MySQL?

                          You guys might as well be speaking Klingon.
                          “Success is not final, failure is not fatal: it is the courage to continue that counts.” - Winston Churchill

                          “If you can't be a good example, then you'll just have to serve as a horrible warning.” - Catherine Aird

                          Comment


                          • #14
                            Re: URGENT: Does anyone here know how to use MySQL?

                            Originally posted by Doug
                            Are card, name, set, value, and quantity other tables, or the columns in the mtgStore table?
                            This is one of the things I'm actually unsure about. I think they'll need to be other tables, but I'm not sure how to link the tables to get them to output the results I'm looking for.

                            Basically, on the HTML/PHP side, I want to create a page that lists the variables I listed above, probably in a table. I want the user to be able to select a particular card from the inventory, push a button, and go to a second page that displays the results via table output. Basically, similar to a very basic online store interface.

                            Oh, and "quantity" should probably be a numeric type of some sort...
                            I thought it was.

                            Btw, I've been trying to use the "source" command to insert my .sql file with these commands into MySQL so that I don't have to go through the tedious nature of doing everything line-by-line in MySQL, but I keep getting a syntax error when I try. Maybe my .sql file isn't properly formatted...?

                            Comment


                            • #15
                              Re: URGENT: Does anyone here know how to use MySQL?

                              This is jibberish.


                              Comment

                              Working...
                              X