Jiraiya Posted November 17, 2008 Share Posted November 17, 2008 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 Quote Link to comment Share on other sites More sharing options...
gaza165 Posted November 17, 2008 Share Posted November 17, 2008 Talk to Twister, he is currently in the process of making 'i think' a similar game.. apologies if i have got that wrong. Quote Link to comment Share on other sites More sharing options...
Twister1004 Posted November 17, 2008 Share Posted November 17, 2008 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. Quote Link to comment Share on other sites More sharing options...
Twister1004 Posted November 17, 2008 Share Posted November 17, 2008 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. Quote Link to comment Share on other sites More sharing options...
Jiraiya Posted November 17, 2008 Author Share Posted November 17, 2008 I still need to get this thing up somehow Quote Link to comment Share on other sites More sharing options...
Twister1004 Posted November 17, 2008 Share Posted November 17, 2008 Well First you need to give the a default value of their HP, MP, skill power, and all that junk =) Quote Link to comment Share on other sites More sharing options...
gaza165 Posted November 17, 2008 Share Posted November 17, 2008 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... Quote Link to comment Share on other sites More sharing options...
.josh Posted November 17, 2008 Share Posted November 17, 2008 http://www.phpfreaks.com/tutorial/php-basic-database-handling Quote Link to comment Share on other sites More sharing options...
Jiraiya Posted November 17, 2008 Author Share Posted November 17, 2008 i already have all the npc stats set in a database Quote Link to comment Share on other sites More sharing options...
Twister1004 Posted November 17, 2008 Share Posted November 17, 2008 Now you will need to get them out of the database and alter them as nessarry. Quote Link to comment Share on other sites More sharing options...
Jiraiya Posted November 17, 2008 Author Share Posted November 17, 2008 thats what i need help with Quote Link to comment Share on other sites More sharing options...
Twister1004 Posted November 17, 2008 Share Posted November 17, 2008 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) Quote Link to comment Share on other sites More sharing options...
Jiraiya Posted November 17, 2008 Author Share Posted November 17, 2008 i have no clue were to start with this any ideas please Quote Link to comment Share on other sites More sharing options...
Barand Posted November 17, 2008 Share Posted November 17, 2008 When you are out of your depth move to the shallow end and start with something simpler. Quote Link to comment Share on other sites More sharing options...
Jiraiya Posted November 17, 2008 Author Share Posted November 17, 2008 but this is what i have left to really get done Quote Link to comment Share on other sites More sharing options...
Jiraiya Posted November 17, 2008 Author Share Posted November 17, 2008 can anyone help me on this? Quote Link to comment Share on other sites More sharing options...
Barand Posted November 17, 2008 Share Posted November 17, 2008 http://www.sitepoint.com/article/publishing-mysql-data-web/ Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.