Home Community Mys-Script Creative Off-Topic |
|
|
Thread Tools | Display Modes |
|
#1
|
||||
|
||||
Help: Change all users at once? [Answered]
Please move this to The Webmaster Bat-Cave, I put this in the wrong section, sorry!
( I may figure this out on my own :P ) Note: This isn't very related to the adoptable script, I'm making a game that is using the adoptable script as a... template you might say to run the game. Okay, I am trying to make it so a user gets 100 Cash every five minutes, I've got it so the script/file will run every five minutes, I just can't get all the users getting 100 Cash. Only one user at a time, I'm trying to take the "User list" and have that update the user accounts resources, but, that doesn't seem to be working. :/ Here is the code that is suppose to be updating the users' resources: PHP Code:
|
#2
|
||||
|
||||
RE: Help: Change all users at once?
You're running 3 queries per user - that's a lot. I'd update them all in one query.
$query = "UPDATE ".$prefix."users SET cash='".$cashs."' AND metal='".$metals."' AND fuel='".$fuels."' WHERE username='".$user."'"; Next, are you running a cronjob? I have no idea how to get those set up (won't work on my own adoptables site -.-) but if you are and you need help, I'm sure someone else can help. :) |
#3
|
||||
|
||||
RE: Help: Change all users at once?
I've been wondering how to do multiple of those in one go, thanks! Yeah, I'm running a Cron Job that runs every 5 minutes. ( And still is even though the .php file won't work. ) If you want, I could try to help you get the Cron Job to work, it took my a bit to understand it ( plus some help ).
|
#4
|
|||
|
|||
RE: Help: Change all users at once?
you need to use a loop to run though all users to do what you are trying to do, otherwise you will run through the first user only over & over till you time out & chrash your server.
Sea |
#5
|
||||
|
||||
RE: Help: Change all users at once?
How would I do that though? What's the code?
|
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to change the oder of users adoptables? [Answered] | Tezna | Questions and Supports | 3 | 12-04-2009 11:09 AM |
nadopt.php Access Denied Message for users/guests [ANSWERED] | arlecchina | Questions and Supports | 3 | 07-18-2009 01:48 PM |
How do I change the Top 10 list to Top 20? [Answered] | zhiichiro | Questions and Supports | 4 | 05-25-2009 08:38 PM |
How to change alternate percentage? [Answered] | lollicat | Questions and Supports | 1 | 05-23-2009 10:31 AM |
change password and change email | Blackmagic | Questions and Supports | 5 | 03-05-2009 03:13 AM |
What's New? |
What's Hot? |
What's Popular? |