08-02-2009, 07:19 AM
Because it seems people just keep adopting a bunch of mine and while I've only used up one mb of my database out of 100, it's only been 3 days and I'd hate to run out of room in the future.
08-02-2009, 07:19 AM
08-02-2009, 07:32 AM
Yes, you can by hard-coding this value into the script. Please see this post which describes how to limit the number of adoptions per user to 1 per user.
To set the number, in the provided code find:
Replace 0 with the number for the maximum adoptables a user can have.
Also, if database space is filling up fast you can clear the contents of your adopts_vote_voters table. Be sure to clear it late in the day though as it keeps track of who voted to level up an adoptable and if you clear it mid-day some people can vote for a pet twice in a day, but the data from old dates is not needed anymore.
You can clear by running this query in PHPMyAdmin:
Brandon
To set the number, in the provided code find:
PHP Code:
if($num > 0){
Replace 0 with the number for the maximum adoptables a user can have.
Also, if database space is filling up fast you can clear the contents of your adopts_vote_voters table. Be sure to clear it late in the day though as it keeps track of who voted to level up an adoptable and if you clear it mid-day some people can vote for a pet twice in a day, but the data from old dates is not needed anymore.
You can clear by running this query in PHPMyAdmin:
Code:
DELETE FROM adopts_vote_votersBrandon
08-02-2009, 07:34 AM
08-11-2010, 04:14 PM
12-30-2010, 05:25 PM