Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> How To's
Author Message
perfect-games
Regular
Regular


Joined: Oct 28, 2004
Posts: 84

PostPosted: Sun Jun 12, 2005 6:16 pm Reply with quote

hi guys well i a litlle stuck ,
let me explain ok i making up some upgrade scripts for my v3 > v4 but i need to alter and drop i tried 5 different ways but cant seem to get it right.

here the original code from v3

INSERT INTO nuke_bbconfig VALUES ('max_smilies', '10');

now i need to drop it

i have tried alter and drop, alter , where value and drop

how should i write it....

just tring to make the upgrade clean as possible

thanks
 
View user's profile Send private message
Raven
Site Admin/Owner


Joined: Aug 27, 2002
Posts: 17077

PostPosted: Sun Jun 12, 2005 6:50 pm Reply with quote

Have you checked syntax at Only registered users can see links on this board! Get registered or login! ?
 
View user's profile Send private message
perfect-games
PostPosted: Sun Jun 12, 2005 7:21 pm Reply with quote

i have the reference chm doc but cant seem to find a function that does it,
strange these phpbb mods install but dont want to uninstall
 
perfect-games
PostPosted: Sun Jun 12, 2005 7:42 pm Reply with quote

do i need to drop the whole nuke_bbconfig to do this ?
 
Raven
PostPosted: Sun Jun 12, 2005 7:45 pm Reply with quote

DELETE FROM nuke_bbconfig WHERE config_name='max_smilies';
 
perfect-games
PostPosted: Sun Jun 12, 2005 8:33 pm Reply with quote

thank you raven was driving me crazy could not work out how to do it, never droped an insert before
thanks RavensScripts
 
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> How To's

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 ©