View Single Post
  #1  
Old 08-25-2014, 10:41 AM
Abronsyth's Avatar
Abronsyth Abronsyth is offline
A Headache Embodied
 
Join Date: Aug 2011
Location: NY
Posts: 1,011
Gender: Male
Credits: 117,525
Abronsyth is on a distinguished road
Default Resetting Adoptables

If you're site is fully up and running, you hopefully will never have to do this. However, if your site is still a work in progress, such as mine, and you have to completely wipe adoptables, levels, images, and/or owned adoptables, then this may be helpful.

For this we're going to be using PHPMyAdmin for, well, everything. Don't worry, it's not difficult, just time consuming!

1. Access PHPMyAdmin
>>> You can do this by going into your host, website control panel, and either go directly to PHPMyAdmin or go into MySQL databases and get into PHPMyAdmin through there.

2. Deleting Adoptables
>>> First, find the table "prefix_adoptables," then check the box next to all adoptables, or just hit check all, and then delete those.

3. Reset Auto_Increment
>>> If you don't do this, it can seriously mess up adoptable id's and such. So, now your going to go to Operations > Table Options > auto_increment, and replace that number with "1". And hit go!

4. Finish It Up
>>> Now repeat steps two and three for these tables: prefix_levels, prefix_owned_adoptables, prefix_adoptables_conditons, and prefix_filesmap.

Congrats, now you can start uploading images and creating pets on a clean slate :)
__________________
My Mods Site (1.3.4, 2020 Mods)

Last edited by Abronsyth; 08-25-2014 at 07:55 PM. Reason: Whoops, missed on table!
Reply With Quote