General Question

[Kevin Clark]

It tells you in the link I posted in my first reply.

[anthies]

Look, I find that line in install.xml. Where do I need to copy that line to? That's the only problem I assume.

Look here:

[Kevin Clark]

You didn't have to search the raw code for it. It's in the xml document right above where I screenshotted it earlier.

As I said (twice), it tells you in the article I linked to in my first reply.
You need to paste that query in to the SQL query box in phpmyadmin.

[anthies]

You didn't have to search the raw code for it. It's in the xml document right above where I screenshotted it earlier.

As I said (twice), it tells you in the article I linked to in my first reply.
You need to paste that query in to the SQL query box in phpmyadmin.

Yeah, well I have downloaded phpmyadmin3.2.2-all-languages but that's not the program. Where can I get the program so that I can proceed further?

Now I need to untar / unzip that to my server directory root: /xxx.ycn-hosting.com. Right?

Then I need to use this config.sample.inc.php to something:

Code: Select all

<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
* phpMyAdmin sample configuration, you can use it as base for
* manual configuration. For easier setup you can use setup/
*
* All directives are explained in Documentation.html and on phpMyAdmin
* wiki <http://wiki.phpmyadmin.net>.
*
* @version $Id: config.sample.inc.php 12304 2009-03-24 12:56:58Z nijel $
* @package phpMyAdmin
*/

/*
* This is needed for cookie based authentication to encrypt password in
* cookie
*/
$cfg['blowfish_secret'] = ''; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

/*
* Servers configuration
*/
$i = 0;

/*
* First server
*/
$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysqli if your server has it */
$cfg['Servers'][$i]['extension'] = 'mysql';

/* rajk - for blobstreaming */
$cfg['Servers'][$i]['bs_garbage_threshold'] = 50;
$cfg['Servers'][$i]['bs_repository_threshold'] = '32M';
$cfg['Servers'][$i]['bs_temp_blob_timeout'] = 600;
$cfg['Servers'][$i]['bs_temp_log_threshold'] = '32M';

/* User for advanced features */
// $cfg['Servers'][$i]['controluser'] = 'pma';
// $cfg['Servers'][$i]['controlpass'] = 'pmapass';
/* Advanced phpMyAdmin features */
// $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
// $cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
// $cfg['Servers'][$i]['relation'] = 'pma_relation';
// $cfg['Servers'][$i]['table_info'] = 'pma_table_info';
// $cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
// $cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
// $cfg['Servers'][$i]['column_info'] = 'pma_column_info';
// $cfg['Servers'][$i]['history'] = 'pma_history';
// $cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';
/* Contrib / Swekey authentication */
// $cfg['Servers'][$i]['auth_swekey_config'] = '/etc/swekey-pma.conf';

/*
* End of servers configuration
*/

/*
* Directories for saving/loading files from server
*/
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';

?>


[Kevin Clark]

You shouldn't need to install phpmyadmin. Your site controls should already have it.
Ask your hosts how to get to it.

[anthies]

Yes, I got it:

Evgeny says:
http://phpmyadmin.ycn-hosting.com (the same login details as the MySQL login details in your cpanel)

So what do I need to do after that, though. I'm slow to learn as you may have noticed. Now I need to copy that ALTER line to somewhere which you've posted twice (the same line) to put into SQL query.

[Kevin Clark]

Get to your database in phpmyadmin
At the top of the page there is a button with SQL written on it.
Click that and you'll get a box pop up.
Paste that ALTER line in to the box.
Press go.

[anthies]

Final question.

Is this right? I'm at the general page:


Then I clicked on Databases and SQL:


Now I copy the ALTER line and press Go? And that's it for today?

Edited:

I did as I was told to and there was an error occured:

Code: Select all

Error
SQL query:

ALTER TABLE  `phpbb_users` ADD  `user_profile_xfire` VARCHAR( 255 ) NOT NULL DEFAULT  ''

MySQL said:

#1046 - No database selected

So what is exactly the name of the database I need to select?

[Kevin Clark]

Click anthais2 on the left.
You'll see a big list of all the tables of the database in the main window.

A phpBB3 installation only has 62 tables so it looks like you have more than one board or other software using that database.

Check which table prefix is the phpBB3 board (you can find that in the config.php file if you don't know it).

Click SQL at the top
Paste in the query.

NOTE:
See where the query says
ALTER TABLE `phpbb_users
If your table prefix is not phpbb_ you'll need to change that.

Press go

[anthies]

Where's the config.php file? Oh gosh, this has been such a tremendous day.
Also do I need to mark / subscribe all the phpbb tables? There's a lot of them, this is one example: phpbb_config.

In my phpmyadmin3.2.2-all-languages I see only config.sample.inc.php.
Do I now need to untar / unzip that to http://phpmyadmin.ycn-hosting.com? Oh, but how?

[Kevin Clark]

The config.php file is in the forum folder where you were doing the file edits.

No you don't need to select/subscribe any tables.
The query you're entering says which table it needs to change.

If you have a config table called phpbb_config then it's likely your prefix is already phpbb_

So just paste the query, hit go and see what happens.

[anthies]

Code: Select all

<?php
// phpBB 3.0.x auto-generated configuration file
// Do not change anything in this file!
$dbms = 'mysql';
$dbhost = 'localhost';
$dbport = '21';
$dbname = 'www_anthais2';
$dbuser = 'www_anthais2';
$dbpasswd = 'SORRY HAD TO LET YOU BE UNAWARE';
$table_prefix = 'phpbb_';
$acm_type = 'file';
$load_extensions = '';

@define('PHPBB_INSTALLED', true);
// @define('DEBUG', true);
// @define('DEBUG_EXTRA', true);
?>

Is that it?

And now I should type this ALTER TABLE `phpbb_users` ADD `user_profile_xfire` VARCHAR( 255 ) NOT NULL DEFAULT ''; into Run SQL query/queries on database www_anthais2 and I'd get the xfire_mod to work?

After I did that, it told:

Your SQL query has been executed successfully (Query took 0.0442 sec)

SQL query:
ALTER TABLE `phpbb_users` ADD `user_profile_xfire` VARCHAR( 255 ) NOT NULL DEFAULT '';

Seems to be working, whuh? See below:



How would I make the xfire_mod visible at http://www.xxx.ycn-hosting.com/phpBB3/? I know somewhere in ACP I need to activate the mod. So what do I need to do at next?

Many thanks in advance and for being so patient with me, I owe you big time, Kevin Clark.

[Kevin Clark]

You have run the SQL query correctly. Well done. Gold star

As for the MOD not showing up, check all your edits and then post in the topic for that MOD.
It looks like it should show up in your user control panel > profile section.
Check there first.

[Pony99CA]

[code]
$dbname = 'www_anthais2';
$dbuser = 'www_anthais2';
$dbpasswd = [REMOVED];

Did you really just paste your database username and password in public? That's probably not a good idea.

As it sounds like you're a newbie to this, you might want to try running the basic forum and getting some experience before trying to make MODs. I can't believe how patient Kevin was; my policy is that I try to answer something three times and then give up, so huge props to Kevin.

Steve

[anthies]

Nope, I didn't reveal my password, that is why I posted SORRY HAD TO LET YOU BE UNAWARE.
Doesn't matter if I revealed my username.

Edited: It works only on my default Xtreme Style (that means Xtreme Blue). Why not on Xtreme Green? I have the same ucp_profile_profile.info.html and memberlist.view but still not showing up on the Xtreme Green Style.

Here are a couple of screenshots:

/xxx.ycn-hosting.com/phpBB3/styles/X-Treme Green/template
http://i1010.photobucket.com/albums/af2 ... /green.jpg
http://i1010.photobucket.com/albums/af2 ... rofile.jpg

/xxx.ycn-hosting.com/phpBB3/styles/X-Treme/template
http://i1010.photobucket.com/albums/af2 ... s/blue.jpg
http://i1010.photobucket.com/albums/af2 ... rofile.jpg

The problem is that it doesn't show up on Xtreme Green, only on Xtreme Blue. If you recognized, in the first screenshots of these styles, the ucp_profile_profile.info.html files are the same. Unlike the second screenshots. So is there any way of getting it on Xtreme Green?