PDA

View Full Version : SQL help


Blue Icebox
04-21-2009, 12:45 AM
I've noticed this part of the SQL:
INSERT INTO adopts_settings (name, value) VALUES ('themeurl', 'templates/default/template.html');
INSERT INTO adopts_settings (name, value) VALUES ('browsertitle', 'This is the site title as pulled from the DB');
INSERT INTO adopts_settings (name, value) VALUES ('sitename', 'Your site name goes here.');
INSERT INTO adopts_settings (name, value) VALUES ('admincontact', 'any@email.com');
INSERT INTO adopts_settings (name, value) VALUES ('slogan', 'Test Slogan');
INSERT INTO adopts_settings (name, value) VALUES ('gdimages', 'yes');
INSERT INTO adopts_settings (name, value) VALUES ('usealtbbcode', 'yes');
INSERT INTO adopts_settings (name, value) VALUES ('systememail', 'any@email.com');

and
INSERT INTO adopts_content (page, title, date, content, level) VALUES ('index', 'This is the index page', 'Jan-10-1999', 'This is a sample article. All of this text you can change in the script admin control panel.','');
INSERT INTO adopts_content (page, title, date, content, level) VALUES ('tos', 'This is the Terms of Service Page', 'Jan-10-1999', 'Put your terms of service here. All of this text you can change in the script admin control panel.','');

do you have to manually change those? Or will it change automatically once you set it up? Can you change them? Why or why not?[hr]
Can I change the Jan-10-1999 to Apr-18-2009?
What happens if you change it yourself?
I know your only supposed to change the 2nd part...

Ashje
04-21-2009, 04:46 AM
1) Yes.
2) No.
3) Yes.
4) To customise your adoptables page. You can change it in the MyPHP Admin or in the site's adoptable CP.

Blue Icebox
04-21-2009, 07:40 PM
You mean admin cp...

So the emails can be changed by yourself?
like the ones that say any@email.com

right?[hr]
What's a browsertitle?[hr]
Can you edit things...
not "edit" edit but this is what I mean:

I don't like the aim, yim, ect on the profile. Can I take that off and add another thing called "about" and "other pets"? How do you connect things to the bbcode editor?[hr]
Can I change some things around? I really need to do it![hr]
on
INSERT INTO adopts_groups VALUES ('', 'rootadmins', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes');
INSERT INTO adopts_groups VALUES ('', 'admins', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes');
INSERT INTO adopts_groups VALUES ('', 'registered', 'yes', 'yes', 'no', 'no', 'no', 'no', 'no', 'no');
INSERT INTO adopts_groups VALUES ('', 'artists', 'yes', 'yes', 'yes', 'yes', 'yes', 'no', 'no', 'no');
what does each yes and noes stand for?

mugwumpr
04-21-2009, 09:41 PM
INSERT INTO adopts_groups VALUES ('', 'rootadmins', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes');
INSERT INTO adopts_groups VALUES ('', 'admins', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes');
INSERT INTO adopts_groups VALUES ('', 'registered', 'yes', 'yes', 'no', 'no', 'no', 'no', 'no', 'no');
INSERT INTO adopts_groups VALUES ('', 'artists', 'yes', 'yes', 'yes', 'yes', 'yes', 'no', 'no', 'no');
what does each yes and noes stand for?

The yesses and noes are what access each group can or cannot have. Check the table under "add new user group" to see what order things are in.

Ashje
04-22-2009, 02:14 AM
1. Yes.
2. I do not have the update yet but I'm guessing it's the name of the site that appears in the browser.
3. Yes, in your DB. It must be done manually.
4. Change which things?
5. They stand for access to the ACP, ability to adopt certain creatures, etc. To check what they stand for more accurately, look at the adopts_groups table in your MyPHP Admin.

Blue Icebox
04-23-2009, 12:22 AM
Um... what happens if I changed Admin into Owner?

What else do I have to edit?
What should I do if I want to add another group called "Mods"?

Ashje
04-23-2009, 12:25 AM
1. Nothing, the name just changes.
2. I don't have the script but you shouldn't have to edit anything.
3. Go to your ACP and edit user groups and add a new one.

Blue Icebox
04-24-2009, 12:19 AM
To me, the coding is too confusing. Is there a way to change the titles of all those automatic titles and instructions? is it in /inc/functions.php ? Please tell me!

Blue Icebox
04-24-2009, 01:43 AM
nevermind. I found it at lang.php