Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> General/Other Stuff
Author Message
phoenix-cms
Worker
Worker



Joined: Aug 05, 2005
Posts: 139

PostPosted: Thu Oct 13, 2005 7:52 am Reply with quote

hi i need to transfer ll my cash_mod points that has variable user_points into nukes points

here are the table differences

user_points decimal(11,0)

points int(10)

whats the best way to copy the points part over without doing this by hand

thanks

steve

_________________
Evo 3.0 Developer & nukecops.com Admin
Image
coming soon [ Only registered users can see links on this board! Get registered or login! ] Smile 
View user's profile Send private message Send e-mail
phoenix-cms







PostPosted: Thu Oct 13, 2005 7:55 am Reply with quote

should i drop nuke table and rename and drop ?
 
phoenix-cms







PostPosted: Thu Oct 13, 2005 8:02 am Reply with quote

something like this drop field points and do this

ALTER TABLE `nuke_users` CHANGE `user_points` `points` INT( 10 ) NOT NULL DEFAULT '1'

is that best way to do it
 
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> General/Other Stuff

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©