| Nov 22, 2009 |
I understand how theese stuff works now (the time() function and stuff).But is it possible to make it update without a user being online =? Or must the script be loaded by a user, to run?
you can either raise 0.08 hp per minute or you can raise 5 HP per hor which is better if you ask me...
CODE <?php $cpass=insert_your_own_password_here; $revive=$_GET["revive"]; if ($revive == $cpass) { mysql_query("update players set hp=hp+5"); print "Revive Complete"; exit; } ?> now go to cron jobs in cpanel...let's say that the above code is in your www/ folder named revive.php write CODE lynx -dump http://yourgameurl.com/folder/revive.php?revive=insert_your_own_password_here > /dev/null and set it to hourly(to do that script every hour) did that help?i hope it did! Eggie
It helped a bit, Thanks. But, how do I do it without the cron jobs =?
Don't update it all the time, only when the value is required. You would just need to remember the last time the value is updated, calculate how many minutes have passed, and then set the new value accordingly. Not only will you put less load on the server, but you will also avoid using cron jobs
Let's suppose you have already retrieved $health and $updated. The first variable contain the current health, and the second when the health was last updated (UNIX timestamp). CODE $currentTime = time(); // we need this in order to calculate how much time has passed $difference = $currentTime - $updated; $addHealth = floor($difference / 3600) // we need to know how many hours have passed - we get an round value (though it is a "float" number) by using floor() $addHealth = (int) $addHealth * 5 // this is how much health will be added, if you add 5HP per hour - I'm not sure whether (int) is necessary, but better safe than sory $health += $addHealth; if ($health > 100) { $health = 100; } // we don't want the health to go over 100! $updated = time(); // we also need to update the alteration time. Now you would just need to enter the new value of $health and $updated into the database, without the need to read them again in this script. I have not tested this code, so it might not work properly.
why don't you want to work with cron jobs...it's not that hard...you have the script i wrote for you and you just need to adjust it and it will be over...
i always like helping people with something i know and that's what i ask from other people...to help me if i have problems
Cron jobs can be useful at times, but here they would be too much. You would have a script that runs every sixty seconds and updates all the players. Sure, for only several players it is OK, but just imagine updating several thousands of players - it would definitely put immense load on the server (unnecessary load, that is).
oh...i didn't know it's that much....but i only learned to do it with cron jobs so i posted that script before...i'm a newbie in scripting so i really don't know about that...(i'm currently getting my register script to work and helping bhupinunder with his game)
@pyost:you have msn???if you do pls send me PM with it..i need help asap
kill me if you want.. but I still don't understand xD
You mean that the "$Health" is the mysql_query for the current health and that the "$updated" is for the "last time the health was updated" colum = Both is mysql_queries =? Latest Entries
I understand how theese stuff works now
 (the time() function and stuff).But is it possible to make it update without a user being online =? Or must the script be loaded by a user, to run?
*Sigh* I thought you would be able to add in bits of code here and there to make it custom but apparently you A: Didn't read my post's content or B: Simply didn't understand it.
I (being a lazy programmer) forgot Step 6 in my example but I listed it above in the content but just not in the example. Anyway after $CH=...; you should add if($CH>280){$CH=280;} now if you have subtract simply add (after the same check) if($CH<0){$CH=0;} This will limit the $CH var to either 280 or 0 you could use both but I that is only if your mysql database stored a negative variable before and when you added the time the variable was still negative (or the value before was greater then 280 if you are subtracting). Hopefully you checked that on your attack script otherwise you will have some problems. Thanks, Sparkx
You just want to update a value every minute you may need to just check with the database (as vujsa said before). This is quite simple to achieve. I use this method often here is a basic blueprint of what is going to occur:
-Step 1: only call when asked (so if selected for attack script or profile). I suggest that you make it into A: a function or B: just make it a require friendly page. Easy in easy out est. est. -Such as you put in the $username=$name; --> Require --> $Current_health=$currenthealth. -Step 2: Select for database where username=$username and extract two entries HP and TimeUD (time Updated). -Step 3: Time() - TimeUD = TimeB (Time between). -Step 4: TimeB*Rate (should be a number you could however put in an equation for health)=HPA (HP Added). -Step 5: HP+HPA=NHP(New HP). -Step 6: Simple if If(NHP>100){NHP=100;} -Step 7: Update Database with Time() (from above). Update Database with NHP. -Step 8: Finally just set $currenthealth and finish. With that said you 'should' be able to figure it out. Basically we are NOT updating the database each minute but rather each time we need to. Then we are simply getting the value. Just change a few things to decrease health over time (stabbed and loosing blood, slowly dieing over time est.). Here is my Untested Example (Change it accordingly): CODE <?php //In: $username //Out: $CH //Only use once each load //Require with require(); See Manual. $row = mysql_fetch_array(mysql_query("SELECT * FROM replace_w_db WHERE UserN='$username'") or die(mysql_error())); $currentHP=$row['HP']; $LUT=$row['LastUpdatedTime']; $currentTime=Time(); $TD=$currentTime-$LUT; $HPD=$TD*0.1;//0.1 HP gain per secound. $CH=$currentHP+$HPD;//Add HP (change to - if subtract). //Update DB $result = mysql_query("UPDATE replace_w_db SET HP='$CH' WHERE UserN='$username'") or die(mysql_error()); $result = mysql_query("UPDATE replace_w_db SET LastUpdatedTime='$currentTime' WHERE UserN='$username'") or die(mysql_error()); //Finish off. ?> It should work (hopefully). If not, you know how to PM. Good Luck, Sparkx EDIT: Spelling + Grammar Error fixed. Oh ya and if you want every minute just divide $TD by 60 ex: $TD=$TD/60; (insert just after:$TD=...
vujsa. the value is still not updating ?
the $full_hours_passed sometimes reaches 0, and then the $hp_increase and the $new_update_time reaches nothing (not even 0). look: CODE 1203101853 current_time 1203101821 last_update_time 32 time_difference 0.533333333333 hours_passed 0 full_hours_passed 32 remaining_seconds new_update_time hp_increase 60 frequency 10 increment And this: CODE 1203105671 current_time 1203105541 last_update_time 130 time_difference 2.16666666667 hours_passed 2 full_hours_passed 10 remaining_seconds 1203105661 new_update_time 20 hp_increase 60 frequency 10 increment but this is a lot later.. 2 full_hours_passed = 20 hp_increase.
Similar Topics
Keywords : make, database, raise, minute,
Serial Numbering for output contents of mysql in php table (4) Hello there, I'm looking for some education. How would you show the serial numbering for How to properly store passwords in a database (8) Every article I've read on the internet so far suggests using MD5 or SHA1 to "encrypt" passwords Regarding PHP supported database format (5) There are different database backends supported by PHP. However, most of us probably use MySQL and No MySQL or any other database (6) Hi everybody. This is my 3rd script, but this dont use MySQL It does this: divide the site in Wont INSERT into the database (13) hey well can some one helpme make this code work it won't INSERT INTO THE DATABSE CODE # (3) How I can to connet to DB in PHP?.... Looking for make, database, raise, minute,
|
 How To Make A Value In The Database Raise Every Minute. |
Affordable Web Hosting, Low cost Web Hosting - ComputingHost.com
