Mysidia Adoptables Support Forum  

Home Community Mys-Script Creative Off-Topic
Go Back   Mysidia Adoptables Support Forum > Mysidia Adoptables > Questions and Supports

Notices

Reply
 
Thread Tools Display Modes
  #1  
Old 04-21-2009, 12:45 AM
Blue Icebox Blue Icebox is offline
Member
 
Join Date: Jan 2009
Posts: 45
Credits: 5,037
Blue Icebox
Default 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...
Reply With Quote
  #2  
Old 04-21-2009, 04:46 AM
Ashje Ashje is offline
Member
 
Join Date: Jan 2009
Posts: 179
Credits: 10,015
Ashje
Default 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.
Reply With Quote
  #3  
Old 04-21-2009, 07:40 PM
Blue Icebox Blue Icebox is offline
Member
 
Join Date: Jan 2009
Posts: 45
Credits: 5,037
Blue Icebox
Default 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?
Reply With Quote
  #4  
Old 04-21-2009, 09:41 PM
mugwumpr mugwumpr is offline
Member
 
Join Date: Apr 2009
Posts: 41
Credits: 4,503
mugwumpr
Default 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.
Reply With Quote
  #5  
Old 04-22-2009, 02:14 AM
Ashje Ashje is offline
Member
 
Join Date: Jan 2009
Posts: 179
Credits: 10,015
Ashje
Default 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.
Reply With Quote
  #6  
Old 04-23-2009, 12:22 AM
Blue Icebox Blue Icebox is offline
Member
 
Join Date: Jan 2009
Posts: 45
Credits: 5,037
Blue Icebox
Default 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"?
Reply With Quote
  #7  
Old 04-23-2009, 12:25 AM
Ashje Ashje is offline
Member
 
Join Date: Jan 2009
Posts: 179
Credits: 10,015
Ashje
Default 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.
Reply With Quote
  #8  
Old 04-24-2009, 12:19 AM
Blue Icebox Blue Icebox is offline
Member
 
Join Date: Jan 2009
Posts: 45
Credits: 5,037
Blue Icebox
Default 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!
Reply With Quote
  #9  
Old 04-24-2009, 01:43 AM
Blue Icebox Blue Icebox is offline
Member
 
Join Date: Jan 2009
Posts: 45
Credits: 5,037
Blue Icebox
Default RE: SQL help

nevermind. I found it at lang.php
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -5. The time now is 04:36 AM.

Currently Active Users: 266 (0 members and 266 guests)
Threads: 4,080, Posts: 32,024, Members: 2,016
Welcome to our newest members, jolob.
BETA





What's New?

What's Hot?

What's Popular?


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
vBCommerce I v2.0.0 Gold ©2010, PixelFX Studios
vBCredits I v2.0.0 Gold ©2010, PixelFX Studios
Emoticons by darkmoon3636