ЗЫ регистрация пользователя только вручную администратором возможна.
надеюсь я ответил корректно на вопросы, если нет, то перенесите пожалуйста тему в раздел PHP
English version manual
Program dbscript 3.6 (c) dj - alex. Instructions and documentation version 0.90
This manual is not enough adapted to version 2.2
red indicated that it should be correct
What is Dbscript? - On-line catalog (database):
Dbscript it - the program allows you to edit the line with a full administration access levels. (As to the databases and to separate fields).
When you connect to your site \ database our service you are making it more efficient and useful.
There are several options for the program:
1.This is independent program through which you can start a service on your hosting.
2.Servis, which is run and maintained on our hosting.
About the projects:
For what it may be useful --
-easy to change the database of online games
for home-collection drives such as access to it only for their own people.
, for the simultaneous work of people from different cities over the filling and the contents of one database in one place.
-for advertisements of goods shop on the Internet
-for hosting files
-You can continue to invent their own.
Advantages of the program:
+ does not require any knowledge of programming languages.
+ You can appoint and dismiss editors and to regulate access rights in a wide range.
+ each user has personal preferences on the site, some of which can change independently.
+ detailed logs, you can always see what is sought or made on site
+ You can always click No to restore the pre-archived table
+ You can use cross-references to the links between tables
+ for the service is not required site
+ commercial version of the program allows you to book your own modules.
+ service under any circumstances, does not keep on your computer, no data, except for the cache.
Benefits of service:
To the advantage of the program adds the following features:
+ our servers are working 24\7, there is technical support.
+ geolocation data management and users of the site is of no importance
+ You do not want to buy your own server, all in one place.
+ You do not need to install the software anywhere, it is accessible from any internet connected computer.
+ if you like, you can use with your SQL Server
Used during programming languages:
Php, Html, Sql (MySQL), Javascript (DHTML)
For the user with the service you want:
The computer of 486 DX 66Mhz to the modern
The availability of the Internet, at least 28K modem
The presence of the keyboard and mouse
The presence of the head, hands and ability to work with a computer.
For the server you want to:
Computer OS: Linux or Windows or BSD based
Internet channel of 256kbit, the more the better.
The speed of 1GHz processor, 512MB of memory (Optimal 2ggts, 2yadra, 2GB)
The existence of / dev / hands / dev / brain and the ability to customize Web services.
-Availability of a web server with Apache2, Php 5, Mysql 5, Zend optimizer 3.2.6 or higher.
Tested operating systems:
Ubuntu 7.10 i386, Kubuntu 8.04 LTS i386, Windows XP 32bit SP2, Windows 2003 SP
Mandriva 2008, Mandriva 2009.0, Asp Linux 12, Alt Linux 4
Unfortunately the list of all supported versions of programs, browsers and operating systems still incomplete.
Found on the possibility of incompatibility will be corrected.
Tested and supported browsers
Firefox 2,3 - full support
Internet Explorer 5,6,7 - full support.
Maxthon 1.5 - Full support
Opera 9 - full support.
Konqueror 4.2.2 - Full support
Note: Some browsers need to switch encoding for Russian text.
Note: Internet explorer 8 cannot be tested until not exist normal Linux installer.
On the traffic flow:
The program was created with a 28.8k modem connection
Ie modem on a single page takes 2 seconds.
Of course when you first enter or change the configuration a little more time, because cached graphics.
For a typical search operation, read-modify-preserving spent approximately 70kb. (Depending on configuration, type of content and size of the table output can be changed, this result is obtained at the request consisting of 150 fields.).
The amount is included with the option «saving bandwidth in the design»
For owners of SQL servers in our hosting:
To use the program to your server data requires access to the mysql server dj. .
For her work, create a user and the necessary legal rights, and do not forget to configure your password.
Port sql open only for this server, otherwise you may have problems with security.
Available rights: SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, SHOW DB.
Personal restrictions on the execution of commands is inline recommended use it and not limit service.
See a list of versions and ways to connect closer to the end of the document.
The composition of the program, a list of modules and configurations
admin. php - administrative module contains many functions.
dblinker. php - plug-ins of new databases to the existing list.
r. php - executable module, the issuance of the data, execution of commands
w. php - module change database format SQL, CSV (DAT), the main tools
edit. php - authentication module.
Str0.php - module switching pages
Index. php, main. php - starting (entry) page
dbscore. lib - contains the core of the program.
Includes the following but not limited to: Sign and verify the level of access, processing of comments and pictures, format sql support and dat, the functions to work with the file system, the module log and rollback module comments, support for multiple languages...
_conf - a folder containing all the settings for programs and databases include:
property. cfg - the configuration program and databases *
sitedata. cfg - site configuration, user data *
pages. cfg - setup of pages and the methods for connecting to them
denywords. cfg - list of banned words and their use
dbdata. cfg - a list of configured connections to database tables
gmdata. cfg - a list of users and their rights and personal preferences.*
styles. cfg - setting styles for users of the service
langset. cfg - Conformity selectable language options language is defined by default.
_data - the folder containing the database and CSV headers SQL databases.
_langdb - the entire text of the program
_templates _ico - Graphics
* - If the damage of this important file, the program attempts to roll back to its previous state automatically.
*. dat - data base for the internal format used for the
total amount of code more than 4500 lines
Installation Guide \ Installation manual
Installing dbscript as a service (for our web hosting)
1.Ustanovka and launch the service starts only after payment and may take 1-4 days.
2. You choose a username and password for administrative access, and the terms of access (users) to the service.
3. You need to provide data on the structure of tables, their title, and finished the table or in a format Excel.
It is desirable to provide a list of users, if you plan to use the SQL, it will have a list of prohibited teams. You can choose the format of posted data, or data to inform its SQL Server to be used in conjunction with our service.
* Installing Updates may take different times directly related to the complexity.
Ubuntu 7.10 i386, Kubuntu 8.04 LTS i386, Windows XP 32bit SP2, Windows 2003 SP
Mandriva 2008, Mandriva 2009.0, Asp Linux 12, Alt Linux 4
Unfortunately the list of all supported versions of programs, browsers and operating systems still incomplete.
Found on the possibility of incompatibility will be corrected.** The precustomizing settings
When you install the service, you can request the installation of any of these settings
Company name, color scheme of service, additional pages, preferred language of service, and their list
Presets pages Presets bases and / or users.
Give the file containing the database to be connected,
Most of the settings you can change after you connect.
When ordering a site with a service you can ask for less service.
Installing dbscript in the form of a personal copy (not on our hosting)
Step 1: Make sure you have the necessary software to run the Web service. (see requirements above)
Step 2: Unpack the archive in the desired folder on the server.
Note: You can also create multiple copies of the script, giving them a common configuration when they are in the same folder. Script checks the configuration files starting with the folder «above level», and then only in his own. Ie Adding gmdata. cfg not in the script folder _conf, and on creating a «1 level up» you provide common user for all copies of the program.
Step 3: Run installer. php
Note: If your server is called local host and you put the script in a folder dbscript that treatment might look like this
http://localhost/dbscript/installer. php
The installer will help you make the basic settings are not necessary and will ask some important questions, drop is not recommended. The default settings are for mysql (root without a password and user password TEST c TEST)
Step 4:
Activation (4 options):
Option 0.Aktivatsiya not in the open-source version of the script. (just skip this paragraph)
1.dlya version of the commercial version, select a version of your payment and send me activation code. Please specify what e-mail, and a nickname to register key.
Option 2.Dlya nonprofit version simply send the activation code and send me mail with this code, and specify how you found this script. You can e-mail \ username for the registration key.
For items 1 and 2. see the note on the activation (bottom).
Option 3.Avtomaticheskaya activation can be found: As the demo and an online demo (not recommended!) Versions, as a test version, and for the regular version for Linux.
Step 5: You need to go to a manager of database and add the existing database that you want available through your service. When installing the access level 0 database will be available for viewing without registration.
Step 6: Add other users. At the service there is no system авторегистрации (or prohibited)
To go to the Administration need to click one button in the left menu, this menu - basic. The new version is available Menu button right on top.
Log directly available to the script name: admin. php
For older versions, it is important to:
Typically by default in all releases are the login and password that type TEST - TEST or TEST - 0000
If you could do it then can begin to work with dbscript!!! Congratulations!
A note on the activation:
When you install a personal copy dbscript you can get request for the serial number of the license, he asked automatically if it is missing or not valid.
The resulting serial number should be inserted in the field after the activation number and click verify.
After the activation would have to be on the menu entry (or Menu), insert the key program. He sent in the form of a file.
* The program is able to remember a few numbers of activation, if the server hardware or software changes, but in the event of a change of rooms to be changed and the activation key.
* If you had an old demo or test version of the old key is removed automatically.
* If you want to switch to another version of the program and received activation key
or an updated copy of your key does not match the command-deactivate. deactivate and activate, or your room. deactivate_all (important: remove all the serial numbers and keys).
* If you want to change the key only - then rename or delete key dbs. key in _conf /. Then, whenever you install a new key.
Start using \ Starting using dbscript
In Dbscript 2 types of menus.
The first one you see after installation, it will be left in the new versions of the Menu button on the top right menu is available new. In any case, you will be in the following paragraphs:
Administration - management of the service in general, see «Modules»
Found on the possibility of incompatibility will be corrected. My Accountyour personal profile and settings, see «Modules»
Search - Using the data usually begins with a search, see «Modules»
Editor - see «Modules»
Manager database - managing the real database and register them in the service, see «Modules»
File Manager - work with the file system on the server where the service, see «Modules»
Overall notebook - notebook common to all users
Test - Automatic check of all the configurations and settings. Perhaps in part to correct some errors. We recommend that you regularly carry out its.
Version of the service - including not only the kernel version, and versions of all the internal modules.
About me - contains information about the program.
Author - information about the author.
Modules of the program and a description of them (opportunities) \ Modules and it's prorepties
The principle of the project (official, briefly)
At the entrance to any page of the program is loaded the kernel, which loads all the necessary configuration and passes all the input data relevant scripts methods GET and POST.
Usually, at the entrance to a site in the left frame shows the menu map, and in the right runs the selected program module. The menu can be switched off.
Manipulating variables, you can create a reference to an operation, or advanced search.
Search (show) (getfile. php, r. php)
In the search, you can see and otobrazhetsya menu with a list of groups (if permitted), a list of tables that list the types of search, a window to enter the desired value, additional options and click the search itself.
Module search can also take command (list. Help).
Search can be operated in several modes of slightly different, but similar in general.
(In the administrative mode are also displayed additional features and commands).
Viewing is capable of "inaccurate" search, so you can find the object, not even memorize their full names search mechanism able to compare characters in different registers, or search for the word on his part and give the data found in tabular form.
Multi seach - you can type in your search through more than one meaning, and they will be displayed in one window (if allowed)
The subject may have a comment or a picture.
In the search for possible opening of the photo (image) or text comments recorded for each database in a separate folder (imyabazy + scr). (if any)
In the search results appear on the right side reduced image (to increase), and click the comment, which can be opened or read comments on this site waiting for pop-up hints. File names are identified by a code or set the column format for images, etc. is set in the configuration.
Editors and administrators can click Edit directly in the search engines. (Red, right).
Also, the editors can delete directly from the search point for the massive problems (ticks), and editing header.
Additional options:
Search Type (see below)
Show # of lines - allows you to change the number of lines per page.
Sorting allows you to sort the selected field, for the DAT tables can be sorted only on the first field.
To select the active mode only «to select the field» (7)
Disabling comments. And the drawings - no comment:)
Only the whole field - the results of throws that could also be found as part of the whole input value.
List of search modes:
The names of types of search can be redefined!
By title, by code, category, all at once, which was elected on an important field, select the field, all fields on the comments (10. Rather than 9).
1-st mode (the title)
Using the search by name (the column is determined by the editor, or admin, the default value - 1)
A comparison of line with the content database, (only the column name), if there are any - are displayed.
2-nd mode (by code)
Request code - looks for a digital code (no figures are for the headlines and skip). (column is determined by the editor, or admin, the default value - 0, ie the physical first column)
Non-numerical values of this regime can not be found (such as «128 256» - there is a gap, i486 - there is a letter)
Very useful for table 3 mode 1 category.
** Note - You can add in the future disable checking only digits.
3rd mode (by category)
Table as a SQL
similar to normal search, but is designed for groups within the tables
mode! 101 displays a list of all the teams are in the form of links.
Table as a CSV, DAT, CFG
similar to normal search, but is designed for groups within the tables
mode! 101 displays a list of all the teams are in the form of links.
1-category (in alt. versii may be referred to as mode-5)
A search for a given category, for it is any non-numerical value. Used in the database where all objects have a unique index.
2-nd category (main)
Used in case of non-unique indexes. A framework for the hierarchical structure of up to 2 levels of nesting. Able to search for any of the columns.
3rd category
Also that the 2-I and with the mechanism for verifying the 3rd column.
Especially all the features of mode 3 added module produces checking the availability of titles and issuing them as buttons Administrator can solve the users, but by default it is only available to him. Running this module, you can simply giving the command! 101.
4-I category, the same as the first category, but selects a column of data from the search object if it gets into the process module seach this weight system!
4-th mode (all at once)
A full display of the content database, regardless of the query text. Only the administration can work in this mode by default. This mode gives the maximum load and the traffic is due to complete over the entire base. Do not give it to all users, although you can set a limit to the maximum search results.
5-th mode ( «best») (favorite)
For each database can have its own list. For each user, too.
6-th mode (on the important fields)
A search for the values imposed on all speakers described the administrator.
There are three ways to work this mode, search for all the columns, and search all columns except specified, and search all the columns (autotransition mode 8). More information - (see admin)
7-th mode (select the field)
Same as the 6 th but given the choice of one column from the list to search. It is important - the column is limited to the list of authorized administrator. At the very administration set lists do not work. (available for all columns)
8-th mode (all fields)
Search all fields, it is important to be careful, because by entering 1 for example, you can not find something that is planned.
10-th mode (by comments)
Search for all comments pertaining to this database.
Creating a hand-held links to display values!
http://localhost/dj/site/r. php? tbl=11&m=7.5&vID=Onyxia&vID2 =
tbl - the number of tables
m - an indication of a search mode, 7 for treatment after the decimal part, you can specify the number of columns.
VID - ID or name that you want to find
VID2 - ID or name for the second main column is required if the table there are 2 main speakers.
Important: if the table is, but the administrator has not identified - immediately inform him of this.
Work with the editor to the table makes 2 main speakers without setting facing the loss of data.
Search in Unregistered Mode
Will be visible only to those tables and the base is allowed to watch without rights.
The program is written in order to maximize user-friendly operation. Just write the name of the desired object (just not too small, that there were no false matches), select the database to search, select the search type and click Search.
Administration (admin. php)
My Accountyour personal preferences
Editor (w. php)
Manager database (dblinker. php)
File manager (filemgr. php)
Bug Service
If you make a mistake and want to get it further explanation - dial. Errors, and then locate it in the list.
Although advised to write it on this forum.
If you find a bug \ bug \ deficit - write to *****@***ru marked - Error in the progamme dbscript and version number. You can also visit my topic at Mangos. ru or 1wow. ru
In the service if allowed reports to be sent to the server - available BUG button next to the button menu.
Complaints are checked regularly.
Found on the possibility of incompatibility will be corrected.
|
Из за большого объема этот материал размещен на нескольких страницах:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 |
