Please login or register.

Login with username, password and session length
Advanced search  

News:

Get quality web hosting, virtual private servers, reseller web hosting, and dedicated servers from www.webhostfreaks.com or www.serverpowered.com!

Maintenance Notice

PHPFreaks has successfully moved to a new Dedicated Server, hosted by Server Powered. Please help support future upgrades by Donating.
Pages: [1] 2  All

Author Topic: mysq and php math function help  (Read 133 times)

0 Members and 1 Guest are viewing this topic.

Jiraiya

  • Enthusiast
  • Offline Offline
  • Gender: Male
  • Posts: 163
    • View Profile
mysq and php math function help
« on: November 16, 2008, 07:03:49 PM »
i want a to have a fighting like system in the game i am making. like in the mysql table
there are npc enemys for players to fight against to train there characters. the npc enemys have preset health Skill(what is used to determine strength basically its just subtracting the skill from the enemys health and keep doing that until the one of them dies by having there health reach zero. and when a player kills a npc enemy i want the player to gain a set amount of "skill" points and cash to add to there character profiles any idea were i should start? im new to using php and mysql but im learning
Logged

gaza165

  • Enthusiast
  • Offline Offline
  • Gender: Male
  • Posts: 242
    • View Profile
    • WWW
Re: mysq and php math function help
« Reply #1 on: November 16, 2008, 07:13:02 PM »
Talk to Twister, he is currently in the process of making 'i think' a similar game..

apologies if i have got that wrong.
Logged

Twister1004

  • Enthusiast
  • Offline Offline
  • Gender: Male
  • Posts: 115
  • PHP 5.2.1 MySQL 5.0
    • View Profile
Re: mysq and php math function help
« Reply #2 on: November 16, 2008, 07:13:20 PM »
I figured out the hard way, you can't make a game like that if you are new to PHP SQL and MySQL. It will eat you alive! *rawr!*

I would say you need to know how to alter stuff in the database  by Update and stuff.

secondly I would go for the train thingy.

thirdly (Lol, I know) I would go for the different kinds of skills.
Logged
Playing with SQL and PHP is what I'm good at ^_~
PHP - 6 months / HTML - 6 months / CSS - 6 months / SQL - 6 months / MySQL  - 6 months / Javascript - Just now started! =D

~-*!@#If you help me, then you can definitely say it was time well spent and be happy to help someone with less knowledge of you!#@!*-~

Twister1004

  • Enthusiast
  • Offline Offline
  • Gender: Male
  • Posts: 115
  • PHP 5.2.1 MySQL 5.0
    • View Profile
Re: mysq and php math function help
« Reply #3 on: November 16, 2008, 07:15:22 PM »
Actually, Gaza, I'm not. xD. Its for a game called Fable. I'm just wanting to make a calculator so I can get the exact about of EXP with out using a RL Calculator.
Logged
Playing with SQL and PHP is what I'm good at ^_~
PHP - 6 months / HTML - 6 months / CSS - 6 months / SQL - 6 months / MySQL  - 6 months / Javascript - Just now started! =D

~-*!@#If you help me, then you can definitely say it was time well spent and be happy to help someone with less knowledge of you!#@!*-~

Jiraiya

  • Enthusiast
  • Offline Offline
  • Gender: Male
  • Posts: 163
    • View Profile
Re: mysq and php math function help
« Reply #4 on: November 16, 2008, 07:15:56 PM »
I still need to get this thing up somehow
Logged

Twister1004

  • Enthusiast
  • Offline Offline
  • Gender: Male
  • Posts: 115
  • PHP 5.2.1 MySQL 5.0
    • View Profile
Re: mysq and php math function help
« Reply #5 on: November 16, 2008, 07:17:51 PM »
Well First you need to give the a default value of their HP, MP, skill power, and all that junk =)
Logged
Playing with SQL and PHP is what I'm good at ^_~
PHP - 6 months / HTML - 6 months / CSS - 6 months / SQL - 6 months / MySQL  - 6 months / Javascript - Just now started! =D

~-*!@#If you help me, then you can definitely say it was time well spent and be happy to help someone with less knowledge of you!#@!*-~

gaza165

  • Enthusiast
  • Offline Offline
  • Gender: Male
  • Posts: 242
    • View Profile
    • WWW
Re: mysq and php math function help
« Reply #6 on: November 16, 2008, 07:19:33 PM »
Sorry Twister, i just assumed that you guys were doing the same game. It seems that you both know what your talking about...

good luck with it all...
Logged

Crayon Violent

  • Global Moderator
  • Freak!
  • *
  • Offline Offline
  • Posts: 6,962
    • View Profile
Re: mysq and php math function help
« Reply #7 on: November 16, 2008, 07:21:56 PM »
http://www.phpfreaks.com/tutorial/php-basic-database-handling
Logged
I'm for rent!

Current hobby!

Jiraiya

  • Enthusiast
  • Offline Offline
  • Gender: Male
  • Posts: 163
    • View Profile
Re: mysq and php math function help
« Reply #8 on: November 16, 2008, 07:22:53 PM »
i already have all the npc stats set in a database
Logged

Twister1004

  • Enthusiast
  • Offline Offline
  • Gender: Male
  • Posts: 115
  • PHP 5.2.1 MySQL 5.0
    • View Profile
Re: mysq and php math function help
« Reply #9 on: November 16, 2008, 07:26:15 PM »
Now you will need to get them out of the database and alter them as nessarry.
Logged
Playing with SQL and PHP is what I'm good at ^_~
PHP - 6 months / HTML - 6 months / CSS - 6 months / SQL - 6 months / MySQL  - 6 months / Javascript - Just now started! =D

~-*!@#If you help me, then you can definitely say it was time well spent and be happy to help someone with less knowledge of you!#@!*-~

Jiraiya

  • Enthusiast
  • Offline Offline
  • Gender: Male
  • Posts: 163
    • View Profile
Re: mysq and php math function help
« Reply #10 on: November 16, 2008, 07:29:11 PM »
thats what i need help with
Logged

Twister1004

  • Enthusiast
  • Offline Offline
  • Gender: Male
  • Posts: 115
  • PHP 5.2.1 MySQL 5.0
    • View Profile
Re: mysq and php math function help
« Reply #11 on: November 16, 2008, 07:32:19 PM »
I would recommend you read the page Crayon Violent wrote.

You will need to know how to do all the MySQL, SQL, and PHP functions with that.

SELECT - Take out out of the database
UPDATE - Update an existing column
ALTER - Change something in the database (Add to or something)
Logged
Playing with SQL and PHP is what I'm good at ^_~
PHP - 6 months / HTML - 6 months / CSS - 6 months / SQL - 6 months / MySQL  - 6 months / Javascript - Just now started! =D

~-*!@#If you help me, then you can definitely say it was time well spent and be happy to help someone with less knowledge of you!#@!*-~

Jiraiya

  • Enthusiast
  • Offline Offline
  • Gender: Male
  • Posts: 163
    • View Profile
Re: mysq and php math function help
« Reply #12 on: November 16, 2008, 08:07:50 PM »
i have no clue were to start with this any ideas please
Logged

Barand

  • Sen . (ile || sei)
  • Global Moderator
  • 'Mind Boggling!'
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 15,095
  • php 4.3/5.1 MySql 5.0.1
    • View Profile
Re: mysq and php math function help
« Reply #13 on: November 16, 2008, 08:12:41 PM »
When you are out of your depth move to the shallow end and start with something simpler.
Logged
|baaGrid| easy data tables - and more
|baaChart| easy line, column and pie charts
|baaSelect| generate js and php code for dynamic linked dropdowns

Jiraiya

  • Enthusiast
  • Offline Offline
  • Gender: Male
  • Posts: 163
    • View Profile
Re: mysq and php math function help
« Reply #14 on: November 16, 2008, 08:14:33 PM »
but this is what i have left to really get done
Logged
Pages: [1] 2  All
 

Page created in 0.054 seconds with 19 queries.