Clean/Empty Private Server Database Files

Quote:

YOU MUST START YOUR USER_IDS FROM: '08053118000306' THEN ADD ONE FOR EVERY USER.. DONT ASK WHY I DONT KNOW!

Maybe I know why... it could've been this:

maybe the field is set to: automaticnummering and it has a primary key

which means the ID will keep nummering from 00000000000001 to god knows where.... And it will keep nummering that way even though you delete them. For example:

User ID:______Name of someone:_____Product:
1____________John________________Dildo
2____________Eric_________________Condom
3____________Angela_______________Vibrator


whenever you remove Angela from the database the user ID will be keep nummering... Which means your new user will be:

User ID:______Name of someone:_____Product:
1____________John________________Dildo
2____________Eric_________________Condom
4____________Picolo_______________A bag of chips

*I cant use spaces so I'm using the _ instead if you dont mind :)*

How to fix it: recreate the table lol :)
First remove the whole table and then recreate it in some kind of database program...
After that do exactly the same as the makers of the database did...
Create a autonummering column with a primary key and create all the other columns like the original creators of the database did...

(I know this because I had to make some databases for school :)... Eather ways... If you want to solve that problem you will be having to do it the hard way :S)

Quote:

Originally Posted by Hylkutje Maybe I know why... it could've been this: maybe the field is set to: automaticnummering and it has a primary key which means the ID will keep nummering from 00000000000001 to god knows where.... And it will keep nummering that way even though you delete them. For example: User ID:______Name of someone:_____Product: 1____________John________________Dildo 2____________Eric_________________Condom 3____________Angela_______________Vibrator whenever you remove Angela from the database the user ID will be keep nummering... Which means your new user will be: User ID:______Name of someone:_____Product: 1____________John________________Dildo 2____________Eric_________________Condom 4____________Picolo_______________A bag of chips *I cant use spaces so I'm using the _ instead if you dont mind :)* How to fix it: recreate the table lol :) First remove the whole table and then recreate it in some kind of database program... After that do exactly the same as the makers of the database did... Create a autonummering column with a primary key and create all the other columns like the original creators of the database did... (I know this because I had to make some databases for school :)... Eather ways... If you want to solve that problem you will be having to do it the hard way :S)

how do i Create a autonummering column with a primary key?

he deleted his mastercodes hahahahha
restore db !

Quote:

Originally Posted by janvier123 he deleted his mastercodes hahahahha restore db !

really funny guy isnt him?! listen man, i dont make jokes about your problems or what u do... when i create this topic i was looking for help, not for some jerk to come here laught about what im trying to do... if u know how to work with the SQL, good for you, i dont, so if u cant help me DONT POST ANYTHING HERE!
spare me of ur dumb comments.

actualy your the 2nd guy that does it, so you could read that post (search it)

Quote:

Originally Posted by janvier123 actualy your the 2nd guy that does it, so you could read that post (search it)

i tried and didnt found anything... so i decided to make one, if u knew that y didint u just posted here the topic's link instead making jokes about it. this a asking help topic not a asking jokes topic