Search results

I can do most of this but it seems like there is a large amount of instruction missing... Am the only one? How do I call from INIT? and where do I put these files in the PBO?

this is an incredible tool, it will allow me to use so many more admins as i wouldnt have to give them any crazy access to the DB or FTP . Please help me get this going on HFB server. i have uploaded it to my ftp server and have entered the correct information. but how then do i use it, only way...

I use this scheduler and it all works great except for when it gets to the restart alerts.. and the restart command. Any ideas why it fails there? <?xml version="1.0"?> <Scheduler> <!--*** INTERNAL COMMANDS ***--> <!--Heart Beat Check--> <job id="0"> <time>010000</time>...

how do i go about running that tool manually?

not sure what happens when i restart my server, it just has a restart button on my panel from HFB.com i would like to find the bat though and see whats going. do you have an qualms with start.bat? i'm going to go dig mine up and see what it does.

-- delete characters DELETE FROM survivor WHERE is_dead = 1 I've tried this, same error as when i try to do it manually. Some delete, others say this.... #1451 - Cannot delete or update a parent row: a foreign key constraint fails (`user-234`.`instance_deployable`, CONSTRAINT...

final result, thank you for your help. its good to be able to bounce ideas off of people. thanks for your original code most importantly. -- clean up any deployed items DELETE FROM id USING instance_deployable id JOIN survivor s ON id.owner_id = s.id WHERE s.last_updated < now() - INTERVAL 21...

Actually, come to think of it. What i really want to do is remove all of the profiles of players who have not been on in 3 weeks. but more importantly remove all of the IS DEAD = 1 players in survivor tab. i have figured out how to clean up all the other tables such as deployable and vehicle...

returned 0, maybe there are none older than a month.. come to think of it i did wipe the server at the end of december. how would you write the original script to clean up things older than lets say 21 days

sleepy

can you format it as you did the first one. i am doing quite well with bliss but i am no DBA

This is wonderful, but when i run it i get this. My server has been up for more than a month at this point and has tons of useless old player info. -- clean up any deployed items DELETE FROM id USING instance_deployable id JOIN survivor s ON id.owner_id = s.id WHERE s.last_updated < now( ) -...