Mysidia Adoptables Support Forum

Mysidia Adoptables Support Forum (http://www.mysidiaadoptables.com/forum/index.php)
-   Questions and Supports (http://www.mysidiaadoptables.com/forum/forumdisplay.php?f=18)
-   -   SQL help (http://www.mysidiaadoptables.com/forum/showthread.php?t=712)

Blue Icebox 04-21-2009 12:45 AM

SQL help
 
I've noticed this part of the SQL:
Code:

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
Code:

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

RE: SQL help
 
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

RE: SQL help
 
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

RE: SQL help
 
Quote:

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

RE: SQL help
 
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

RE: SQL help
 
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

RE: SQL help
 
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

RE: SQL help
 
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

RE: SQL help
 
nevermind. I found it at lang.php


All times are GMT -5. The time now is 09:42 AM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.