 | phpbb 2.0.18 |  |
 Posted: 11/08/2005 2:16 AM |
 |
|
|
|
|
| Site Admin |
| Posts |
30756 |
| Word Cnt. |
2,628,678 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
 |
|
|
|
Joined: Sep 25, 2004
Local time: 7:22 PM
Location: St Pete, FL
|
|
|
|
|
 |
The following is how you apply your code manually to your phpMyAdmin database. You can get into your database through your CPanel by clicking on phpMyAdmin. Follow the following instructions:
I'm sure that every host is different. I will tell you how I run my queries manually and hopefully it will be close to what you have available to you. The following may or may not be similar to what you have...
Log into your domain Control Panel and find the database icons. You should be able to find the phpMyAdmin icon. Click on it...
Hopefully that will log you into your phpAdmin panel. You may need to provide a username and password...
In the phpMyAdmin panel, click on the Databases hyperlink...
Hopefully that should take you where you can select your database. You may only have one. Select your database hyperlink...
That should open up the display of all the tables in your database. Ignore them. Somewhere on the page, you should see something similar to this:
Click on the SQL tab to display something like the following where you can copy all of the SQL commands in at once:
Click on the Go button and the queries will be run. If all goes well, you will be told that the commands were executed successfully. Otherwise you will see a screen that tells you which command failed. If the columns that you are trying to add already exist, a duplicate will not be added...
 |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] phpbb 2.0.18 | |
| Posted: 11/08/2005 2:28 AM |
|
|
|
|
|
| Citation |
| Posts |
2152 |
| Word Cnt. |
78,257 |
| BDay |
Jun 15 |
| Sign |
Gemini |
| Sex |
|
|
|
|
Joined: Apr 22, 2005
Local time: 9:22 AM
Location: Upside down
|
|
|
|
|
|
Slightly different but managed to do it ok.
I just installed yesterday/today mod so how I do I change the colours now  |
|
|
|
|
| Back to Top |
|
|
| phpbb 2.0.18 | |
| Posted: 11/08/2005 2:58 AM |
|
|
|
|
|
| Site Admin |
| Posts |
30756 |
| Word Cnt. |
2,628,678 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 7:22 PM
Location: St Pete, FL
|
|
|
|
|
|
You can run this in EM:
| Code:
|
##############################################################
## MOD Title: Today As/Yesterday As Coloration
## MOD Author: Nightrider < N/A > (N/A) http://4fxearth.net/phpBB2/
## MOD Description: Adds color to the Today As/Yesterday As Text
##
## MOD Version: 1.0.0
##
## Installation Level: Easy
## Installation Time: ~1 Minutes
##
## Files To Edit: 2
## templates/subSilver/subSilver.css
## language/lang_english/lang_main.php
##
## Included Files: n/a
##
##############################################################
## For security purposes, please check: http://www.phpbb.com/mods/
## for the latest version of this MOD. Although MODs are checked
## before being allowed in the MODs Database there is no guarantee
## that there are no security problems within the MOD. No support
## will be given for MODs not found within the MODs Database which
## can be found at http://www.phpbb.com/mods/
##############################################################
##
## Author Notes:
##
## If you want different colors than what I have chosen, you will
## want to change the hex values for .todayat and .yesterdayat
## in your template css file(s). You can create different text
## colors for each template installed on your board...
##
##############################################################
##
## MOD History:
##
## 2005-10-20 - Version 1.0.0
## - Initial Release
##
##############################################################
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD
##############################################################
#
#-----[ OPEN ]------------------------------------------------
#
templates/subSilver/subSilver.css
#
#-----[ FIND ]------------------------------------------------
# The actual line will be longer
#
@import url("formIE.css");
#
#-----[ AFTER, ADD ]------------------------------------------------
# You would change the Hex value settings if you prefer different colors...
.todayat { font-size : 10px; color : #FF6600; }
.yesterdayat { font-size : 10px; color : #330066; }
#
#-----[ OPEN ]------------------------------------------------
#
language/lang_english/lang_main.php
#
#-----[ FIND ]------------------------------------------------
#
$lang['Today_at'] = "Today at %s"; // %s is the time
$lang['Yesterday_at'] = "Yesterday at %s"; // %s is the time
#
#-----[ REPLACE WITH ]------------------------------------------------
#
$lang['Today_at'] = "<span class=todayat><b>Today</b></span> %s"; // %s is the time
$lang['Yesterday_at'] = "<span class=yesterdayat><b>Yesterday</b></span> %s"; // %s is the time
#
#-----[ SAVE/CLOSE ALL FILES ]--------------------------------
#
# EoM
|
|
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] phpbb 2.0.18 | |
| Posted: 11/08/2005 4:06 AM |
|
|
|
|
|
| Citation |
| Posts |
2152 |
| Word Cnt. |
78,257 |
| BDay |
Jun 15 |
| Sign |
Gemini |
| Sex |
|
|
|
|
Joined: Apr 22, 2005
Local time: 9:22 AM
Location: Upside down
|
|
|
|
|
|
| ok got that installed ok. I opened the css file of my current template but can't see where to change the colours. I'm guessing it changed it in the subsilver template to the same colours you have here on your board. I would like the same colours because they stand out better. |
|
|
|
|
| Back to Top |
|
|
| phpbb 2.0.18 | |
| Posted: 11/08/2005 4:24 AM |
|
|
|
|
|
| Site Admin |
| Posts |
30756 |
| Word Cnt. |
2,628,678 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 7:22 PM
Location: St Pete, FL
|
|
|
|
|
|
Ok, your subPortal template was special. The code that went into the subPortal.css file needed to go into your overall_header.tpl file. It's fixed now...
 |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] phpbb 2.0.18 | |
| Posted: 11/08/2005 4:31 AM |
|
|
|
|
|
| Citation |
| Posts |
2152 |
| Word Cnt. |
78,257 |
| BDay |
Jun 15 |
| Sign |
Gemini |
| Sex |
|
|
|
|
Joined: Apr 22, 2005
Local time: 9:22 AM
Location: Upside down
|
|
|
|
|
|
That's why I couldn't find the darn thing.
Looks great. Thanks.
Hmmm now what else can I add? lol |
|
|
|
|
| Back to Top |
|
|
| phpbb 2.0.18 | |
| Posted: 11/08/2005 4:43 AM |
|
|
|
|
|
| Site Admin |
| Posts |
30756 |
| Word Cnt. |
2,628,678 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 7:22 PM
Location: St Pete, FL
|
|
|
|
|
|
If all overall_header.tpl files were the same, I could write the MOD so that it added the code to both places in order to cover all the bases. But the overall_header.tpl files sometimes look like your subPortal template and other times look like your AussieAviator template. If you open them both up in your editor, you will be able to quickly see what I'm referring to...
|
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] phpbb 2.0.18 | |
| Posted: 11/08/2005 4:56 AM |
|
|
|
|
|
| Citation |
| Posts |
2152 |
| Word Cnt. |
78,257 |
| BDay |
Jun 15 |
| Sign |
Gemini |
| Sex |
|
|
|
|
Joined: Apr 22, 2005
Local time: 9:22 AM
Location: Upside down
|
|
|
|
|
|
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] phpbb 2.0.18 | |
| Posted: 11/08/2005 5:09 AM |
|
|
|
|
|
| Citation |
| Posts |
2152 |
| Word Cnt. |
78,257 |
| BDay |
Jun 15 |
| Sign |
Gemini |
| Sex |
|
|
|
|
Joined: Apr 22, 2005
Local time: 9:22 AM
Location: Upside down
|
|
|
|
|
|
| changed it to orange. |
|
|
|
|
| Back to Top |
|
|
| phpbb 2.0.18 | |
| Posted: 11/08/2005 5:16 AM |
|
|
|
|
|
| Site Admin |
| Posts |
30756 |
| Word Cnt. |
2,628,678 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 7:22 PM
Location: St Pete, FL
|
|
|
|
|
|
Orange doesn't look much better, if at all...
 |
|
|
|
|
| Back to Top |
|
|
| Information | |
|
Contact
EZStyle
iRadio
Login for PMs
Links
Register
Calendar
ImageShack
Putfile
TinyURL
CommonDreams