devonbnice

I'm still learning sql, and i cant say i like it very much lol, But my question is how would i go about creating a users2 table? Thanks for the help! Devon.

I didnt forget i have just been busy since the holidays.

@SilvaTungDevil, It is 9 more columns that would be added to the users table.

@Sethenor2, It's random, if you win the pets health will still slightly go down. and if you lose you will lose quite abit more health. each dog you can fight causes different damage.

Screenies added.

Hey everyone, Over time I've noticed people how much people like and love the pet modification and always seams to be in demand. I had some time, and figured i would code one and sell it cheap. So basically, When you first start you will have to choose from 1 of 5 dogs, each having their own unique starting stats. After that you will be brought the main screen where everything is available to you. Mod Includes: - Pet name - Pet health - Pet energy - Pet happy - Pet strength - Pet speed - Pet intellegence Each of these stats have your their own personal role in the whole script. Features: - Train Animal - Play With - Upgrades - Feed - Heal - Fight You can train your dogs strength, speed, and intel exchange for the dogs energy and happy. You can play with the dog in exchange for some of your energy. You can buy upgrades for the dog to increase its max happy and energy. Feeding the dog will give it a passive increase in energy. for cash healing the dog will bring its health back to 100% for cash Fighting the dog and placing wagers against it will earn you money. Be careful if the dogs health reaches 0% it will die and all your time spent will the dog will be gone and you will have to restart. There are 4 different dogs, your dog can fight, each of them having there won preset stats. Recap: - The main objective of this script is give the players something else to do, and train an animal and when they think its strong enough they can fight it and make money. Requirements: To run this script all you will need is one PHP file, and a few sql updates to the users table. If you have any further question please post below or leave me a message, If you are interested in buying this script please mail, and i can give you a tour of a the script and give a feel for it, to see if you would like to have it or not. Thank you, Devon Nice. SCREENSHOTS http://www.imageurlhost.com/images/e4tcm8tgvqpn9vd818.jpg

this looks to be a very easy way for players to become rich really fast, as in all they would have to do is refresh the page over and over again.

Hey, everyone I've been making mods and what not, but i was think i would ask the community if they had any ideas for a mod that hasnt yet been done before. Please post your ideas i would love to hear them. - Devon.

Yes I've finished it quite sometime ago, its probably been done for about 2 months now lol. I kinda been working on other things. Im still making tweaks to it, trying to improve it. It all turned out the way i planned. I'll release on here one of these days. Devon.

I guess i could of done that :p I just put them on different lines, because it helps me read it better. Just a personal thing.

Thanks for the feedback guys, really appericate it. And yes sweetboy25 the varible $int is the chance of them getting the bomb I have it set to select a random number between 1,100 and if the number lands on 1,50,100, They will get the bomb. if its any other number, it will just continue on with the original explore. Also, Illusions i have it set like that because if someone gets the bomb the sql gets set to 1 until they pick a wire. its pretty much for if someone clicks the city and backs out, and goes back to the city, they will still have to defuse the bomb before they will be able to continue on with the rest of the city. Lets say you click CITY and you get the bomb, the bomb sql is now set to 1, and will not be set back to 0 until they cut a wire. also, if the person doesnt have a bomb and they try and type explore.php?cut=red,blue, or green in the address box. the script will stop since they arnt even suppose to be cutting a wire anyway.

Hey everyone, This is my first time posting a mod on here. I've been coding my game and have made quite abit of mods. I figured i would go ahead and give this one out. It's nothing major, just a little addon to the explore. Basically what it does is, when someone goes the city, there is a chance of running into a bomb which then you will have to defuse, or end up in the hospital. Although if you do defuse it, you will receive a small cash bonus. First Copy and paste this into your explore.php (at the top) ///////////////////////////////////////////////////////////////// /////////////////////////BOMB DEFUSE//////////////////////////// //////////////////**Created by: Devon Nice**/////////////////// ////////////////////////////////////////////////////////////// $int = mt_rand(1,100); $time = mt_rand(10,30); $money = mt_rand(500,5000); $wire = mt_rand(1,3); if ( $_GET['cut'] == 'red' ) { if ( $ir['bomb'] < 1 ) { print " What are you doing? "; print " <hr>> [url='explore.php']Back[/url]<hr>"; exit; } print "[b]You cut the red wire.[/b]<hr> "; if ( $wire == 1 ) { mysql_query("UPDATE users SET money = {$ir['money']} + $money WHERE userid=$userid"); mysql_query("UPDATE users SET bomb = 0 WHERE userid=$userid"); print "After closing your eyes and cutting the wire, nothing happens. Looks like you got lucky this time. <font color=darkgreen>[b]+ \$".number_format($money)."[/b]</font> "; print " <hr>> [url='explore.php']Continue[/url]<hr>"; exit; } else { mysql_query("UPDATE users SET hospital = $time WHERE userid=$userid"); mysql_query("UPDATE users SET hospreason = 'Severe burns' WHERE userid=$userid"); mysql_query("UPDATE users SET bomb = 0 WHERE userid=$userid"); print "You close your eyes and cut the wire.. <font color=darkred>[b]BOOM![/b]</font> [i]You are now in the hospital for $time minutes for severe burns.[/i]"; print " <hr>> [url='explore.php']Continue[/url]<hr>"; exit; } } if ( $_GET['cut'] == 'blue' ) { if ( $ir['bomb'] < 1 ) { print " What are you doing? "; print " <hr>> [url='explore.php']Back[/url]<hr>"; exit; } print "[b]You cut the blue wire.[/b]<hr> "; if ( $wire == 2 ) { mysql_query("UPDATE users SET money = {$ir['money']} + $money WHERE userid=$userid"); mysql_query("UPDATE users SET bomb = 0 WHERE userid=$userid"); print "After closing your eyes and cutting the wire, nothing happens. Looks like you got lucky this time. <font color=darkgreen>[b]+ \$".number_format($money)."[/b]</font> "; print " <hr>> [url='explore.php']Continue[/url]<hr>"; exit; } else { mysql_query("UPDATE users SET hospital = $time WHERE userid=$userid"); mysql_query("UPDATE users SET hospreason = 'Severe burns' WHERE userid=$userid"); mysql_query("UPDATE users SET bomb = 0 WHERE userid=$userid"); print "You close your eyes and cut the wire.. <font color=darkred>[b]BOOM![/b]</font> [i]You are now in the hospital for $time minutes for severe burns.[/i]"; print " <hr>> [url='explore.php']Continue[/url]<hr>"; exit; } } if ( $_GET['cut'] == 'green' ) { if ( $ir['bomb'] < 1 ) { print " What are you doing? "; print " <hr>> [url='explore.php']Back[/url]<hr>"; exit; } print "[b]You cut the green wire.[/b]<hr> "; if ( $wire == 3 ) { mysql_query("UPDATE users SET money = {$ir['money']} + $money WHERE userid=$userid"); mysql_query("UPDATE users SET bomb = 0 WHERE userid=$userid"); print "After closing your eyes and cutting the wire, nothing happens. Looks like you got lucky this time. <font color=darkgreen>[b]+ \$".number_format($money)."[/b]</font> "; print " <hr>> [url='explore.php']Continue[/url]<hr>"; exit; } else { mysql_query("UPDATE users SET hospital = $time WHERE userid=$userid"); mysql_query("UPDATE users SET hospreason = 'Severe burns' WHERE userid=$userid"); mysql_query("UPDATE users SET bomb = 0 WHERE userid=$userid"); print "You close your eyes and cut the wire.. <font color=darkred>[b]BOOM![/b]</font> [i]You are now in the hospital for $time minutes for severe burns.[/i]"; print " <hr>> [url='explore.php']Continue[/url]<hr>"; exit; } } if ( $int == 1 OR $int == 50 OR $int == 100 OR $ir['bomb'] == 1 ) { mysql_query("UPDATE users SET bomb = 1 WHERE userid=$userid"); print "[b]While walking around the city, you come across an activated bomb![/b]<hr> "; print "Simple, cut a wire and hope it deactivates the bomb, if not you may find yourself in the hospital. <hr>"; print "<table width=20%><th bgcolor=#505050>BOMB</th><tr> <td bgcolor=#505050>[url='?cut=red'][img=images/redwire.png][/url]</td><tr> <td bgcolor=#505050>[url='?cut=blue'][img=images/bluewire.png][/url]</td><tr> <td bgcolor=#505050>[url='?cut=green'][img=images/greenwire.png][/url]</td><tr> <th bgcolor=#505050>Select a wire</th></table>"; print "<hr>> [url='index.php']Back[/url]<hr>"; exit; } //////////////////////////////////////////////////////////// /////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////   SQL [mysql] ALTER TABLE `users` ADD `bomb` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0 [/mysql] That should be it. Any further question let me know. If anyone wants to colab and make a mod, please leave me a message. Thank you, Devon

I mean i can code it, i know i could. But im not familiar with securing or anything like that. pretty much the only thing i know how to secure are $_Post with the htmlspecialchar. bit Other then that im pretty securing retarded. lol

I'm just going to create whole new table called "hunt" and add all the columns such as kills, animals, upgrades, etc. Making more then one php file doesn't seam like a bad idea, but if i can just add it all into one file why not, you know? I just dont know if what i'd want to to with the scripts when im finished. i could sell it and make some money off of it, but then again if i do that, then other games would have it, but if i just kept it, then it would make my game somewhat unique, know what i mean? Idk i have yet to start the coding process. Having some help with securing and what not would amazing. I though of a new idea. tho too instead of only being able to purchase one gun, maybe have a shop of guns that would have variation of stats like, - Distance - Power - Weight - Stability Idk, Like i said if anyone has any good ideas please post them. - Devon.

Hey everyone, most of you, if not all do not know me. But here in the next 2-3 days. i will begin the coding. But, I've not made up my mind weather or not i wanna give this script away, sell it, or just keep it for myself. You guys can post below what i should do. But, Right now i am currently coming up with all my ideas and plans for the scripts. Most likely the whole entire hunting script will be all in one PHP file. Here are my plans and are most likely gonna happen, if i think of more ideas, or if there are any more ideas you guys would like in the script just post below. but here it goes.. I'm making a hunting script which will allow the players to go hunting and earn money (obviously). Before they would be able to hunt they would first have to purchase a license either with money or points (crystals). After that they will have full access to the script, what they would want to do first before they could actually hunt is first buy a gun from the "Hunt Lodge". There will also be classes (experience wise). When they first start they will start at "Class D" then the more they hunt the more experience they will gain. The classes are D, C, B, A. At class D you will be able to hunt the animals, Rabbits and Squirrels. once they go up to the next class they would have the option to hunt "White Tail" then class B "Buck", then Class A "Black Bear". You feel me? alright then in the hunting lodge you will also be able to purchase clothing and upgrades for your weapon. which will increase your chances of getting that kill. But of coarse before you can hunt you have to have tags. so before you can hunt you will have to go to the lodge and buy tags for each animal you wish to hunt. how the hunting bid will work is all based on chance and luck but the more upgrades you have the higher you chances for getting a kill. But of coarse before you can shoot a gun you have to have bullets for it. So back to the lodge you will have to purchase bullets for you guns. After you make your kills, you will either collect the hide or meat or maybe even both. What you can do with that is take your winnings to the lodge and sell it for cash. Or if you get a nice big buck you can add it to your trophy case :) yes, a trophy case will be in the script aswell. that is where you can see your biggest kill and best game kill. now of coarse the size of the animal and all will be based on random variables. now just for a recap of what all the script will include. ------------------------------------ > Hunting lodge - Buy Gun - Buy upgrades - Buy bullets - Buy License - Buy Tags - Sell Meat and Hide > Trophy Case - Your best kill - Best animal killed > Statistics Bullets shot - Animals killed - Rabbits killed - Squirrals killed - (And so on..) > Go Hunt here you would choose which animal you want to hunt.   What do you guys think? does it sound good, or should i discard it and never make it? Have any ideas to improve it or make it better, please post below. - Devon Nice

thanks :D so simple but that seams to be what most people forger :p

Hello, I'm not very familiar with sql. I do alright with php. But I'm trying to create a table that could be added into users. that would have to values such as 1 and 2. I'm trying to do this so the users can have some customization free to have the game display how they want it. such as the default would be the number 1 in the table/column (whatever its called.) and if they wanted to turn it off then it would update the table/column and replace the number 1 with the number 2.   so when im coding with php. I can just use "if" statements. EX. If ($ir['profilesetup'] == 1 ) { Rest of code here } if ($ir['profilesetup'] == 2 ) { Code Here. } Im sure you guys get what im saying. I just dont know how to create the sql bid. could anyone paste here how i would set this up? Where every you name the column/table just put "NAMEHERE" Thanks very much :) - Devon.