vb impex mess

[StuntFactoryX]

ok i have a noob mess. a few months back i used impex to move servers. i know it was a mistake after the fact. however everything was working great except i lost my banned user group. when i put all my imported users in, it droped everyone into the registered user group. well i fixed my admins. made a new user group for banned users.

well this is where it gets ugly. i installed photopost. everything went fine. later on i installed classifieds. almost same script. it was a nightmare. i had to run the install. wouldnt intergrate. then i went into phpmyadmin and some setting were off in there but were correct in the install script. after that the next hurdle was i had no classified admin permissions. went into phpmyadmin and it so i could get permission. the user group id numbers were off.fixed that admin user group id number. when i got into the classified admin cp there is a link to update user groups in there to intergrate w/ vb. did that. they all appered but users waiting email confirmation. next hurdle is it wouldnt let users place adds even though i had permission set. so i went back into phpmyadmin and looked. all the new users groups updated but the id numbers were off. fixed all them but i im still missing users waiting email confirmation. and it dosent make sense why my database dosent update correctly or all the way. im assuming all my problems start w/ my tables are off in vb3.5.4 and its rolling down hill. how can i get my tables correct? my user group numbers are all over the place. and my other concern is why wont the classified update to the vb database fully? if i was to use that repair optimise tables? or is there somthing in phpmyadmin that will update everything? or do i have a unfixable mess?