I would like to be able to edit the MySQL tables and the text in the like in the beging you have Welcome to a PHPWebHosting site I don't mind a link at the bottom but i would like to have it able to be changed.
I use mysqladmin.php3 to do this and can't access the data in the tables to change it.
Any help would be greatfully appreciated.
If you want to look at the site http://www.scouthq.net and follow the links.
Thanks for such a great Prog
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
There is a web-based administration tool provided with PHPWebHosting. Just log in as 'admin', and it will take you to the appropriate page (admin.php). From there you can change most of the text and colors and HTML on the site. If you want to change the title on the front page, just edit public_html/index.php. Note that by default the password for admin is 'hardtoguess', which you should have changed before running sql/values.sql. If you didn't, just log in to MySQL and run this line:
UPDATE userinfo SET password = PASSWORD('whatever') WHERE username = 'admin';
If you prefer to use mysqladmin.php3, you will need to access the 'settings' table in the 'phpwebhosting' database. The column names are in plain English, ie HTML_TEXT_BLOCK_MAIN_PAGE would change the text on the main page.
Hope this helps.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
-
2000-11-14
I thank you for that it worked great.
The next thing is what to do about Passwords and Deleting malicous accounts and general editing of users sites.
How do you go about that?
Thanks for help.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
That is one thing PHPWebHosting lacks at the moment. There is no web-based interface for editting user accounts. Each user can change their own password, and edit their groups, but that's about it.
You can, of course, edit the tables by hand. User accounts are stored in the 'userinfo' table. A 'describe userinfo;' will show you the fields. One thing to note is that the passwords are stored encrypted, so you will have to use PASSWORD('thepassword') to store them correctly.
If you want to edit the individual pages, you can edit them in the file system, (vi /path/to/phpwebhosting/public_html/username/whatever.html) but deleting or adding pages in the filesystem doesn't change the way they're displayed on the user/group page.
Making an interface for it all is on the TODO list, but I don't know when I'll get around to adding it.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
-
2000-12-03
Hi You say that the path is like this
(vi /path/to/phpwebhosting/public_html/username/whatever.html)
Is it possible to do a way so that the new users go to a directory called lets say /public_html/users/
so that their directories do not get messed up with the files of /public_html/
Regards
Carlita
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
While it wasn't intended to do this, you can simply set $rootdir = "/path/to/phpwebhosting/public_html/users", and change the two require () statements in main.inc. For example:
I am using the script and loving it.
I would like to be able to edit the MySQL tables and the text in the like in the beging you have Welcome to a PHPWebHosting site I don't mind a link at the bottom but i would like to have it able to be changed.
I use mysqladmin.php3 to do this and can't access the data in the tables to change it.
Any help would be greatfully appreciated.
If you want to look at the site http://www.scouthq.net and follow the links.
Thanks for such a great Prog
There is a web-based administration tool provided with PHPWebHosting. Just log in as 'admin', and it will take you to the appropriate page (admin.php). From there you can change most of the text and colors and HTML on the site. If you want to change the title on the front page, just edit public_html/index.php. Note that by default the password for admin is 'hardtoguess', which you should have changed before running sql/values.sql. If you didn't, just log in to MySQL and run this line:
UPDATE userinfo SET password = PASSWORD('whatever') WHERE username = 'admin';
If you prefer to use mysqladmin.php3, you will need to access the 'settings' table in the 'phpwebhosting' database. The column names are in plain English, ie HTML_TEXT_BLOCK_MAIN_PAGE would change the text on the main page.
Hope this helps.
I thank you for that it worked great.
The next thing is what to do about Passwords and Deleting malicous accounts and general editing of users sites.
How do you go about that?
Thanks for help.
That is one thing PHPWebHosting lacks at the moment. There is no web-based interface for editting user accounts. Each user can change their own password, and edit their groups, but that's about it.
You can, of course, edit the tables by hand. User accounts are stored in the 'userinfo' table. A 'describe userinfo;' will show you the fields. One thing to note is that the passwords are stored encrypted, so you will have to use PASSWORD('thepassword') to store them correctly.
If you want to edit the individual pages, you can edit them in the file system, (vi /path/to/phpwebhosting/public_html/username/whatever.html) but deleting or adding pages in the filesystem doesn't change the way they're displayed on the user/group page.
Making an interface for it all is on the TODO list, but I don't know when I'll get around to adding it.
Hi You say that the path is like this
(vi /path/to/phpwebhosting/public_html/username/whatever.html)
Is it possible to do a way so that the new users go to a directory called lets say /public_html/users/
so that their directories do not get messed up with the files of /public_html/
Regards
Carlita
While it wasn't intended to do this, you can simply set $rootdir = "/path/to/phpwebhosting/public_html/users", and change the two require () statements in main.inc. For example:
require ("$rootdir/html.inc");
becomes
require ("/path/to/phpwebhosting/public_html/html.inc");
Note that groups will be put in /path/to/phpwebhosting/public_html/users/groups/groupname, because both are dependent on the $rootdir location.