Jump to content

Skyotica

New Members
  • Posts

    3
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

Skyotica's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. I'm trying to think of the best way to go about doing this: I am going to be adding a challenger to a database and these challengers use weapons. I already am able to add challengers but am thinking of how I should set it up to use weapons. I was thinking of adding a field and just separating each weapon by a comma and using the sql "IN" clause when searching, however; the number of weapons being used is unknown and different. EDIT: Forgot to include that the actual weapon information has a different table than the challenger information. Does anyone know of a function I should research a little or any suggestions? Thanks!
  2. Hello  :), Im programming a random event script and am running into some problems with my logic. The script will allow administrators to add random events to the site with choosing an option on what it does, how much it gives for what it does, and the chance of getting the event. I was going to use a field in the database to hold the query command. $points is the number of points to give the user from the event. I want it to update for the person viewing the page, and this posts a problem because $YourName is a variable stored for the person logged in from the global file. $query123 = "UPDATE `user` SET `point`=`point`+'$points' WHERE `username`='$YourName'" This would cause it to always give it to the admin who added the script versus the actual person viewing it. Any suggestions on how to fix this or another method? If you would like to see more of the code just ask. Thanks, ~Skyotica
  3. Hello, I am trying to fix the search for my site. It is a search for users and item names in the database. The problem is whenever a user submits "ITEM " instead of "ITEM", they recieve a "This item does not exist" message. I have seen many sites that allow users to submit either form of this. How would I be able to achieve this?
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.