[request] Hourly credits

[jamo]

Could someone write me php file that will do the following:

-after 1 hour, the user receives 1000 credits.
-the user does not have to be online to receive the credits
-if the user has more than 15000 credits, no credits will be added


start with this:

<?php
UPDATE users SET credits = '1000' WHERE id = '1';
?>

you can also use sleep(seconds here); for the part where it waits an hour.

thanks!

 

[Kryptos]

You should seriously learn PHP before "making a CMS", also adding features doesn't mean that the CMS is yours. Putting all those things aside, here's the code you should use.

<?php 
dbquery("UPDATE users SET credits = '1000' WHERE credits < 1000"); ?>

That's the query, you have to do other things, example, in uber you have to do after the query $core->Mus('updateCredits', 'All');

All the credits for that query goes to meth0d, do NOT claim this as your own.

Hope you learned something out of this.

 

[jamo]

Won't that just make it so you allways have atleast 1000 credits? I'd prefer to have it like in the first post description. I know a bit of php but i don't understand the mysql query.

And i'll give you credits if I use your code >.>

 

[Kryptos]

That's because you also have to add a code in the Emulator. If you take a look at uberEmulator you'll see.

 

[jamo]

Ive seen this working 100% cms sided. And with your code... how would you set the time? and it looks like its setting the credits to 1000 rather than adding 1000 correct me if i'm wrong.

 

[Kryptos]

That is setting the users credits to 1000 IF they have less than 1000.

 

[jamo]

I already knew how to do that. Is that what I asked for?

 

[Kryptos]

No, I just though it would help you make what you want since you're a newbie in PHP/MySQL, sorry to waste my time.

 

[jamo]

Well i don't know how to add credits instead of set them.