I need help!

[Dragon Blade]

Hello all, I have been lately very busy and I have been rushing things. Now I have time, I need help to change the MCCodes V1 timezone into the UK Time. Also how to make the userid start again instead of the id being missing, I deleted someone. So when I register it fills up the missing ID's.

[sniko]

Add this in the main file. Perhaps mysql.php (I think that it was it's called in v1)

date_default_timezone_set('Europe/London'); #Set default timezone

 

Don't use TRUNCATE unless you want to remove all records.

ALTER TABLE  `users` AUTO_INCREMENT =1; #Sort out the auto_increment values (userid)
TRUNCATE TABLE `users`; #Empty the whole table

 

:)

Edited June 14, 2013 by sniko

[Dragon Blade]

Thanks Sniko! It works!

[Dayo]

as for auto increment i would not bother filling the one id as it could cause more problems then you want i.e. have you deleted all the user stats for that id so when a user joins up he dosent automaticly have for example 10000000 strength the only time i would set auto increment back to 0/1 if i was deleting the whole DB

[Dragon Blade]

I deleted the users, userstats field. So its alright :)

[Djkanna]

I deleted the users, userstats field. So its alright :)

Inventory and any other tables that link directly to the userid field of users?

[Dragon Blade]

And yes :')