Tuesday, October 31, 2006
1 okt 06 Actually using no VARCHAR or BLOB types results in a fixed row size For carirekan
Actually using no VARCHAR or BLOB types results in a fixed row size. Otherwise CHAR and VARCHAR are the same. Se the below for a more exact definition.
You can check the format used for a table with isamchk -d. <http://greateventsupport.com/freehand/freehand-lessons/index.html>
MySQL has three different table formats:
1. Fixed length tables;
o The default format.
o All non packed columns are space filled
o Very quick.
o Easy to cash
o Easy to reconstruct if crashed (Of course this only theoretical :-) because records are on fixed positions.
o Don't have to be reorganized unless a huge number of records are deleted.
2. Dynamic tables
o Is used if there exists any VARCHAR or BLOB columns in table.
o All strings are dynamic (except if length < 3).
o Each record is preceded with a bitmap for which columns are not empty (this isn't the same as null columns).
o Each string is saved with a length byte + string. If string is zero length or a number is zero it takes no extra place (just the zero length bit for each column).
o Each record is uses exactly the needed record space. If a record gets larger it's split into as many pieces as needed.
o Takes little disk space.
o <http://greateventsupport.com/flash/distorting/draggable-window.html>
o If records are changed a lot, isamchk -r should be run now and then to reorganize the table. This is to get a better layout. Use isamchk -ei table_name for some statistics.
o Not as easy to reconstruct because a record may be in many pieces and a link may be missing.
o The expected row length for dynamic sized records is: 3 + (number_of_columns + 7) / 8 + (number of char columns) + packed_size_of_number_columns + length_of_strings + (null_columns + 7) / 8. There will be a penalty of 6 bytes for each link. A dynamic record will be linked whenever a update causes a enlargement of the record. Each new link will be at least 20 bytes, so the next enlargement will probably go in the same link. If not there will be another link. You may check how many links there are with isamchk -ed. All links may be removed with isamchk -r.
<http://greateventsupport.com/freehand/undoing-actions/uninstalling-freehand.html>
3. Compressed tables (this is only with UNIREG/pack_isam)
o Read only tables.
o Takes very little disk space. Minimizes disk usage.
o Each record is compressed separately (very little access overhead)
o Can handle fixed or dynamic length records (but no BLOB:s).
o Can be uncompressed with isamchk
Friday, October 20, 2006
20 okt 06 You want to move a movie clip in front of or behind another movie clip For carirekan
Problem
You want to move a movie clip in front of or behind another movie clip, button, or text field.
Solution
proudly present <http://greateventsupport.com/filezilla/local-file-list/menus-and-toolbars.html>
Use layers or the arrangement commands to adjust the order of instances at authoring time.
Use the swapDepths( ) method to change the stacking order of any two instances at runtime.
Discussion
proudly present <http://greateventsupport.com/filezilla/proxy/site-manager.html>
When you are working with multiple movie clip, button, and/or text field instances on the stage at the same time, you need to be aware of their stacking order. For example, if you have a movie clip that is supposed to animate behind a text field, you need to make sure that the text field appears in front of the movie clip. You can make these kinds of adjustments at authoring time either by placing the instances on different layers and arranging the layer order or by changing the order using the arrangement commands. You can move an instance forward or back by selecting the instance and then choosing Modify Arrange Bring Forward/Send Back/Bring to Front/Send to Back.
The authoring time techniques work just fine when you want to maintain a constant stacking order of all the instances in the movie. But when you want the order to change, you need to use ActionScript to effect that change at runtime using the swapDepths( ) method. In some cases, it is important that you be able to programmatically change the depths of instances in this way. For example, if you create a puzzle in which the user can drag the pieces around on stage, you want to make sure that the piece that is currently being dragged appears on top of all the other pieces. <http://greateventsupport.com/filezilla/file-views/index.html>
In order to understand how to use swapDepths( )a relatively easy methodyou first need to understand how Flash determines stacking order. For the convenience of the developer, Flash uses layers within the authoring environment. However, the exported SWF does not contain any information about layers. Instead, it knows only about depths: whole number values determining the stacking order. Every instance in the movie is assigned its own depth whether you assign it explicitly using the attachMovie( ), duplicateMovieClip( ), createEmptyMovieClip( ), or createTextField( ) methods, or whether it is done automatically for all authoring time instances. But regardless of how the instances are created, they all must have a unique depth. The depth determines the stacking order in which they appear on the stage. An instance of greater depth appears on top of an instance of lesser depth.
<http://greateventsupport.com/filezilla/asciibinary/configuration.html>
You can use the swapDepths( ) method to switch the depths of any two instances. You should invoke the method from one of the instances, and pass a reference to the other instance to the method as a parameter. For instance, if you want to switch the depths of two movie clips on the same timeline named mSquare and mCircle, your code could look like this:
mSquare.swapDepths(mCircle);
The preceding example could also be written:
mCircle.swapDepths(mSquare);
Both the examples result in the same thingthe two movie clip instances change positions in the stacking order.
<http://greateventsupport.com/freehand/replacing-missing/resources-learning-freehand.html>
There are many scenarios in which you may want to change the stacking order of instances in your movie. One common example was mentioned earlierensuring that the movie clip that is selected or being dragged appears on top of all the other instances. And another example is that of creating animations that appear to move in three dimensions. For example, if you have two movie clips that appear to spin in a loop along the z-axis (meaning they seem to move back into the screen), you need to make sure that the movie clip that is currently appearing to be nearer to the viewer has a higher depth.
Here is a simple example with two movie clip instances named circle and square on the main timeline. The two movie clips are slightly overlapping. The circle movie clip has the following actions:
<http://greateventsupport.com/freehand/freehand-lessons/index.html>
mCircle.onPress = function():Void {
this.swapDepths(mSquare);
};
In this example, each time the user clicks the circle, the circle and square appear to change order. You can also create a slightly more intelligent system by which the circle is always brought to the front of the square when it is clicked by adding a conditional statement that uses the getDepth( ) method to compare the current depths of the two movie clips. In this slightly modified code, the depths are changed only if the depth of mCircle is not already greater than the depth of mSquare:
Tuesday, October 10, 2006
10 okt 06 PHP's "root directory" on the server For carirekan
PHP's "root directory" on the server. Only used if non-empty. If PHP is configured with safe mode,
no files outside this directory are served.
engineboolean
This directive is really only useful in the Apache module version of PHP. It is used by sites that
would like to turn PHP parsing on and off on a per-directory or per-virtual server basis. By putting
php3_engine off in the appropriate places in the httpd.conf file, PHP can be enabled or
disabled.
error_logstring
<http://greateventsupport.com/filezilla/local-file-list/menus-and-toolbars.html>
Name of file where script errors should be logged. If the special value syslog is used, the errors
are sent to the system logger instead. On UNIX, this means syslog(3) and on Windows NT it means
the event log. The system logger is not supported on Windows 95.
error_reportinginteger
Set the error reporting level. The parameter is an integer representing a bit field. Add the values of
the error reporting levels you want.
Table 3-1. Error Reporting Levels
bit value enabled reporting
1 normal errors
2 normal warnings
4 parser errors
8 non-critical style-related warnings
The default value for this directive is 7 (normal errors, normal warnings and parser errors are shown).
open_basedirstring
<http://greateventsupport.com/fireworks/changing-paths-appearance/changing-swatch-groups.html>
Limit the files that can be opened by PHP to the specified directory-tree.
When a script tries to open a file with, for example, fopen or gzopen, the location of the file is
<http://greateventsupport.com/filezilla/local-file-list/menus-and-toolbars.html>
checked. When the file is outside the specified directory-tree, PHP will refuse to open it. All
symbolic links are resolved, so it's not possible to avoid this restriction with a symlink