I recently found a tip to minimize Vista Booting Time. When Vista boots up it uses only one core of your CPU. If you have a multicore CPU based system you can do a quick modification.
Click Start -> type “msconfig”
This screen will appear. Select the 2nd tab (boot).
The click Advanced options Add Change processor value to 2 or 4, depending on your hardware.
First of all i d like to remind that In most new pc configurations Vista cant be installed in 4gb systems. You have to uninstal 2gb and then when Windows setup is complete you can use the other 2gb.
How to Enable More Than 3.5 GB of Memory in 32-Bit Windows Vista
You’re probably wondering why I picked a number as horrible as 3.5GB? Why not 4GB? Well, there’s a really technical explanation for this but to make a long explanation short, 32-bit operating systems can only handle up to 4GB of memory. In fact, this number may vary but I stuck with 3.5 GB. Along with the RAM, you also have other memory-mapped devices such as your video cards. The memory used counts towards the 4GB virtual memory address capacity of a 32-bit operating system. But actually, the world does not end at 4,096 megabytes for 32-bit Windows Vista users anymore because the Arsgeek is here to save the day.
If you’ve accidentally bought 4GB of RAM, this may be a good idea. And I say may because many 32-bit operating systems begin to lose efficiency as they surpass the 4GB mark. For that reason, if you have less than 3GB RAM, it’s not necessarily the best idea to go out and buy some more RAM. If you want to utilize more RAM (between 8GB and 128GB), you can always switch to 64-bit Windows Vista. Alright, enough babbling. Let’s get started.
Steps:
1) Access cmd: Click on the Start Pearl > type cmd in the Search Bar > and press Ctrl + Shift + Enter (this allows you to run cmd in administrative mode)
2) Type BCDEdit /set PAE forceenable
“BCDEdit is a boot configuration editor for the command line. Using the above command you’ve just enabled Physical Address Extension (PAE) which can address memory larger than 4 GB. ” – Arsgeek
Source: Arsgeek
If you’re using XHTML, add this:
<link rel="shortcut icon" href="/favicon.ico" type="image/x-icon" />
If you’re using HTML, add this instead:
<link rel="shortcut icon" href="/favicon.ico" type="image/x-icon">
Here is a nice tutorial to make your own favicons in PhotoshopSupport.
This is a list of the most common used mySQL Commands
|
General Commands |
|
|---|---|
| USE database_name | |
| Change to this database. You need to change to some database when you first connect to MySQL. | |
| SHOW DATABASES | |
| Lists all MySQL databases on the system. | |
| SHOW TABLES [FROM database_name] | |
| Lists all tables from the current database or from the database given in the command. | |
| DESCRIBE table_name | |
| SHOW FIELDS FROM table_name | |
| SHOW COLUMNS FROM table_name | |
| These commands all give a list of all columns (fields) from the given table, along with column type and other info. | |
| SHOW INDEX FROM table_name | |
| Lists all indexes from this tables. | |
| SET PASSWORD=PASSWORD(‘new_password’) | |
| Allows the user to set his/her own password. | |
| Table Commands | |
| CREATE TABLE table_name (create_clause1, create_clause2, …) | |
| Creates a table with columns as indicated in the create clauses. | |
| create_clause | |
| column name followed by column type, followed optionally by modifiers. For example, “gene_id INT AUTO_INCREMENT PRIMARY KEY” (without the quotes) creates a column of type integer with the modifiers described below. | |
| create_clause modifiers | |
|
|
| DROP TABLE table_name | |
| Removes the table from the database. Permanently! So be careful with this command! | |
| ALTER TABLE table_name ADD (create_clause1, create_clause2, …) | |
| Adds the listed columns to the table. | |
| ALTER TABLE table_name DROP column_name | |
| Drops the listed columns from the table. | |
| ALTER TABLE table_name MODIFY create_clause | |
| Changes the type or modifiers to a column. Using MODIFY means that the column keeps the same name even though its type is altered. MySQL attempts to convert the data to match the new type: this can cause problems. | |
| ALTER TABLE table_name CHANGE column_name create_clause | |
| Changes the name and type or modifiers of a column. Using CHANGE (instead of MODIFY) implies that the column is getting a new name. | |
| ALTER TABLE table_name ADD INDEX [index_name] (column_name1, column_name2, …) | |
| CREATE INDEX index_name ON table_name (column_name1, column_name2, …) | |
| Adds an index to this table, based on the listed columns. Note that the order of the columns is important, because additional indexes are created from all subsets of the listed columns reading from left to write. The index name is optional if you use ALTER TABLE, but it is necesary if you use CREATE INDEX. Rarely is the name of an index useful (in my experience). | |
| Data Commands | |
| INSERT [INTO] table_name VALUES (value1, value2, …) | |
| Insert a complete row of data, giving a value (or NULL) for every column in the proper order. | |
| INSERT [INTO] table_name (column_name1, column_name2, …) VALUES (value1, value2, …) | |
| INSERT [INTO] table_name SET column_name1=value1, column_name2=value2, … | |
| Insert data into the listed columns only. Alternate forms, with the SET form showing column assignments more explicitly. | |
| INSERT [INTO] table_name (column_name1, column_name2, …) SELECT list_of_fields_from_another_table FROM other_table_name WHERE where_clause | |
| Inserts the data resulting from a SELECT statement into the listed columns. Be sure the number of items taken from the old table match the number of columns they are put into! | |
| DELETE FROM table_name WHERE where_clause | |
| Delete rows that meet the conditions of the where_clause. If the WHERE statement is omitted, the table is emptied, although its structure remains intact. | |
| UPDATE table_name SET column_name1=value1, column_name2=value2, … [WHERE where_clause] | |
| Alters the data within a column based on the conditions in the where_clause. | |
| LOAD DATA LOCAL INFILE ‘path to external file’ INTO TABLE table_name | |
| Loads data from the listed file into the table. The default assumption is that fields in the file are separated by tabs, and each data record is separated from the others by a newline. It also assumes that nothing is quoted: quote marks are considered to be part of the data. Also, it assumes that the number of data fields matches the number of table columns. Columns that are AUTO_INCREMENT should have NULL as their value in the file. | |
| LOAD DATA LOCAL INFILE ‘path to external file’ [FIELDS TERMINATED BY 'termination_character'] [FIELDS ENCLOSED BY 'quoting character'] [LINES TERMINATED BY 'line termination character'] FROM table_name | |
| Loads data from the listed file into the table, using the field termination character listed (default is tab \t), and/or the listed quoting character (default is nothing), and/or the listed line termination chacracter (default is a newline \n). | |
| SELECT column_name1, column_name2, … INTO OUTFILE ‘path to external file’ [FIELDS TERMINATED BY 'termination_character'] [FIELDS ENCLOSED BY 'quoting character'] [LINES TERMINATED BY 'line termination character'] FROM table_name [WHERE where_clause] | |
Allows you to move data from a table into an external file. The field and line termination clauses are the same as for LOAD above. Several tricky features:
|
|
|
|
|
| Privilege Commands | |
| Most of the commands below require MySQL root access | |
| GRANT USAGE ON *.* TO user_name@localhost [IDENTIFIED BY 'password'] | |
| Creates a new user on MySQL, with no rights to do anything. The IDENTIFED BY clause creates or changes the MySQL password, which is not necessarily the same as the user’s system password. The @localhost after the user name allows usage on the local system, which is usually what we do; leaving this off allows the user to access the database from another system. User name NOT in quotes. | |
| GRANT SELECT ON *.* TO user_name@localhost | |
| In general, unless data is supposed to be kept private, all users should be able to view it. A debatable point, and most databases will only grant SELECT privileges on particular databases. There is no way to grant privileges on all databses EXCEPT specifically enumerated ones. | |
| GRANT ALL ON database_name.* TO user_name@localhost | |
| Grants permissions on all tables for a specific database (database_name.*) to a user. Permissions are for: ALTER, CREATE, DELETE, DROP, INDEX, INSERT, SELECT, UPDATE. | |
| FLUSH PRIVILEGES | |
| Needed to get updated privileges to work immediately. You need RELOAD privileges to get this to work. | |
| SET PASSWORD=PASSWORD(‘new_password’) | |
| Allows the user to set his/her own password. | |
| REVOKE ALL ON [database_name.]* FROM user_name@localhost | |
| Revokes all permissions for the user, but leaves the user in the MySQL database. This can be done for all databases using “ON *”, or for all tables within a specific databse, using “ON database_name.*”. | |
| DELETE FROM mysql.user WHERE user=’user_name@localhost’ | |
| Removes the user from the database, which revokes all privileges. Note that the user name is in quotes here. | |
| UPDATE mysql.user SET password=PASSWORD(‘my_password’) WHERE user=’user_name’ | |
| Sets the user’s password. The PASSWORD function encrypts it; otherwise it will be in plain text. | |
| SELECT user, host, password, select_priv, insert_priv, shutdown_priv, grant_priv FROM mysql.user | |
| A good view of all users and their approximate privileges. If there is a password, it will by an encrytped string; if not, this field is blank. Select is a very general privlege; insert allows table manipulation within a database; shutdown allows major system changes, and should only be usable by root; the ability to grant permissions is separate from the others. | |
| SELECT user, host, db, select_priv, insert_priv, grant_priv FROM mysql.db | |
| View permissions for individual databases. | |
So check out this code…..
if(1== 1)
{
header(“Location: index.php”);
}
header(“Location: http://www.google.com”);
This simple code will be expected to redirect to index.php since 1==1 is always true. And for a weird reason it returns to redirect to www.google.com.
Maybe for a reason i didn’t quite understand this, but it should be written like this
if(1== 1)
{
header(“Location: index.php”);
}
else
{
header(“Location: http://www.google.com”);
}
As mentioned before the only logical explanation is that this command is a client side command that means the script doesn’t stop from being executed till end. My guess is that header location, first of all has to be executed before anything has sent to html output, so it does fill the html with this line
.
This is a utility to convert text to valid html or ulr characters and back.
click picture to download
I ve been using Vista for some time now. I run into several weird problems. Finally I got everything fixed. Here is a list of some. Hoping i ll be able to save someones hours of searching.
1. Vista cant work well with network printers
And I mean it. If you are setting a new PC for your office that needs to do a lot of printing jobs from network shared printers maybe you should use XP instead. Long pauses are experienced when trying to find the network printer. No actual solution about that.
But I have a quick tip for you!!
Solution: If some programs like (photoshop, corel X4 suite) do 10-15 seconds to open a small document the solution is pretty Simple. Just change the default printer to a local printer (even a virtual pdf writer).
2. Vista’s thumbnails and video codecs
I run to a very weird problem. I was close to a clean format. I downloaded a video an dropped it to the desktop. After this the explorer repeatedly did not respond. I couldn’t to actually anything without explorer running. I realized after an hour that I had to go with command prompt to C:\Users\me\Desktop locate and delete the file. So i did and the problem vanished. No explorer restarts!!! Weird heee? I guess windows didnt have the correct code to make tha thumbnail of the video file placed in my desktop.
3. Vista slow Start up.
I thought that the Avast was real heavy and I experienced lately a slow boot time.
Solution: Pretty Simple check if you have dead links in Programs\Startup , QuickLaunch, and pined items in Start Menu. Check also the start up programs, start type ‘msconfig’ and go to the Startup Tab.
I dont know about you but i love Vista !!!!
Mozilla is for many reasons the favorite browsers for all web developers. To use it faster you need to know its keyboard shortcuts.
A new hard-disk is on the market. Look at WD site to
see allso the a nice 3D display of this drive.
see it’s full specs
jGrowl is a nicely developed pluggin, hopefully in a mature version 1.10(for now), for displaying messages like this in your browser
The style is similar to the way that OS X’s Growl Framework works.
Here u can download the pluggin
http://plugins.jquery.com/project/jgrowl