Log in Register FAQ Memberlist Search Welcome to RCF - WHF Forum Index
alt : test.swf
Welcome to RCF - WHF
4fx3.gif 
calendar_open_closeCalendar 
Manual SQL Code Advice Please!
Post new topic   Reply to topic View previous topic :: View next topic
Welcome to RCF - WHF Forum Index -> Area 51 - phpBB & Easymod Tech Support Add To Bookmarks
Manual SQL Code Advice Please!
PostPosted: 10/01/2006 1:46 PM Reply with quote
Citation
Karen
Citation
Posts 1253
Word Cnt. 68,166
BDay Nov 9
Sign Scorpio
Sex Sex:Female
Joined: Jan 06, 2006
Local time: 1:36 PM
greatbrE.gif
Hiya!

I was trying to follow the above instructions but as my phpMyAdmin is different and it would be the first time doing this I'm very nervous so wanted to double check!

OK I don't have a link to my database - I have this when I first log in.



The SQL query I want to do is INSERT INTO phpbb_config (config_name, config_value) VALUES ('bbcode_html_group', '-1');
so (not sure if this is right) I went to actual link which is down the left hand side

If I click on that I then get this -


(here's the bottom bit)


Apart from not knowing if this is where I should be entering the command there is already something written in the box - do I ignore that and put the command in after it?...do I delete what's already there?...or am I completely in the wrong place and thank goodness I asked first  Dancing

The mod I'm trying to do is the one where it allows admin only to post in HTML - I want to do a clickable link to our contact details but without it actually showing our email addresses.
Back to Top
View user's profile Find all posts by Karen Send private message   Visit poster's website Phoogle Map
Re: Manual SQL Code Advice Please!
PostPosted: 10/01/2006 5:08 PM Reply with quote
Site Admin
Nightrider
Site Admin
Posts 30757
Word Cnt. 2,628,690
BDay Jul 28
Sign Leo
Sex Sex:Male
Joined: Sep 25, 2004
Local time: 9:36 AM
Location: St Pete, FL
peace.gif
You are doing everything correctly so far.  Just overwrite the SQL code that is in the window with your INSERT INTO query, then press the Go button at the bottom and the query will be applied to your phpbb_config table...

There is an alternative that you might want to consider.  You can paste your query(s) in the following Window and create a file that you can upload and run from your browser.  That way you wouldn't need to go into phpMyAdmin any longer...

MySQL to PHP Converter

After storing the php file on your PC, you would upload it to your forum root and run it in your browser.   The path would look something like this if you named the file db_update.php:

Code:
http://www.babydreamz.net/forums/db_update.php

headbang
Back to Top
View all pictures posted by this userView user's profile Find all posts by Nightrider Send private message   AIM Address Yahoo Messenger Phoogle Map ICQ Number
Re: Manual SQL Code Advice Please!
PostPosted: 10/02/2006 8:48 AM Reply with quote
Citation
Karen
Citation
Posts 1253
Word Cnt. 68,166
BDay Nov 9
Sign Scorpio
Sex Sex:Female
Joined: Jan 06, 2006
Local time: 1:36 PM
greatbrE.gif
Oooh thanks!

I will do that  headbang
Back to Top
View user's profile Find all posts by Karen Send private message   Visit poster's website Phoogle Map
Re: Manual SQL Code Advice Please!
PostPosted: 10/02/2006 9:12 PM Reply with quote
Site Admin
Nightrider
Site Admin
Posts 30757
Word Cnt. 2,628,690
BDay Jul 28
Sign Leo
Sex Sex:Male
Joined: Sep 25, 2004
Local time: 9:36 AM
Location: St Pete, FL
peace.gif
Karen, did you get it to work???

dontknow
Back to Top
View all pictures posted by this userView user's profile Find all posts by Nightrider Send private message   AIM Address Yahoo Messenger Phoogle Map ICQ Number
 Post new topic  Reply to topic
Information
Welcome to RCF - WHF Forum Index -> Area 51 - phpBB & Easymod Tech Support

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 cannot attach files in this forum
You cannot download files in this forum
All times are GMT - 5 Hours

Page 1 of 1


Add To Bookmarks

 
  
  


  Google

Powered by phpBB © 2001, 2005 phpBB Group

Page generation time: 0.0737s (PHP: 60% - SQL: 40%) - SQL queries: 39 - GZIP disabled - Debug on