5
This chart shows you a list of common MIME types and their corresponding file extensions.
|
18
Changing the domain for your wordpress site? Log into phpMyAdmin and load the wordpress database.
Make a backup!!!!
Click the SQL Tab. Copy and paste the code below into notepad.
Find and Replace OldSite.com with the name of your old domain name. Find and replace NewSite.com with the new domain name. DO NOT include the http:// or the www.! Only the actual domain name itself!!
Once that is done, copy and paste from notepad into the SQL tab of phpMyAdmin.
{code type=”php”}
update wp_options set option_value = replace(option_value, ‘OldSite.com’, ‘NewSite.com’);
update wp_sitemeta set meta_value = replace(meta_value, ‘OldSite.com’, ‘NewSite.com’);
update wp_blogs set domain = replace(domain, ‘OldSite.com’, ‘NewSite.com’);
update wp_usermeta set meta_value = replace(meta_value, ‘OldSite.com’, ‘NewSite.com’);
{/code}
{code type=”php”}
update wp_postmeta set meta_value = replace(meta_value, ‘OldSite.com’, ‘NewSite.com’);
update wp_posts set guid = replace(guid, ‘OldSite.com’, ‘NewSite.com’);
update wp_posts set post_content = replace(post_content, ‘OldSite.com’, ‘NewSite.com’);
update wp_comments set comment_author_url = replace(comment_author_url, ‘OldSite.com’, ‘NewSite.com’);
{/code}
If you are changing the domain name on a network install (multi-site):
After you have done all the above, find and replace wp_ with wp_2_ etc. etc.
Finally; dont forget to edit the wp-config.php file as the domain name is “hard coded” in there as well.
19
One of the greatest applications we have every used is Notepad++ – It is without a doubt, the most versatile tool!
A quick way to comment out settings in css!
{code type=php} Find: margin(.*):(.*);
Replace: /*margin\1:\2;*/ {/code}
{code type=php} Find: padding(.*):(.*);
Replace: /*padding\1:\2;*/ {/code}
{code type=php} Find: width:(.*);
Replace: /*width:\1;*/ {/code}
If you have a bunch of variables defined and want to include an if statement try this
{code type=php} Find:
(.*) = (.*);
Replace:
if (empty(\2)) { \1 = “N / A”; } else { \1 = \2; }
if (!empty(\2)) { \1 = \2; } else { \1 = “N / A”; }
if (isset(\2)) { \1 = “N / A”; } else { \1 = \2; }
if (!isset(\2)) { \1 = \2; } else { \1 = “N / A”; }
{/code}
19
100 Series : The requested action is being taken. Expect a reply before proceeding with a new command.
|
200 Series : Command okay.
|
300 Series : The command has been accepted, but the requested action is being held pending receipt of further information.
|
400 Series : The command was not accepted and the requested action did not take place. The error condition is temporary, however, and the action may be requested again.
|
500 Series : The command was not accepted and the requested action did not take place.
|
22
{code type=php}
mysql_query(“DROP DATABASE `databasename`”);
//this will drop a database
mysql_query(“DROP TABLE `tablename`”);
//will permanently remove a table
mysql_query(“TRUNCATE TABLE `tablename`”);
//this will remove all rows inside the table
mysql_query(“ALTER TABLE `tablename` CHANGE `fieldname` `newfieldname` type DEFAULT ‘default value’ NOT NULL”);
//alter a tables field attributes
mysql_query(“ALTER TABLE `tablename` RENAME `newtablename` ;”);
//this will change a tables name
mysql_query(“ALTER TABLE `tablename` DROP `fieldname` ;”);
//this remove a field from inside the table
{/code}
6
SQL & PhpMyAdmin work lovely together. Here we can find and replace text in a database. This does not replace the whole filed with our replacement string, rather, it searches each field for our ‘Find These Words’ string. If it is found, it will replace only ‘find these words’ with ‘replace with these words’ while leaving the rest of the words in the field alone.
This is very helpful if you have misspellings, a name change, or phone number change.
Here is the SQL Syntax:
{code type=php}update TABLE_NAME set FIELD_NAME = replace(FIELD_NAME, ‘find these words’, ‘replace with these words’);{/code}
Click the image to see where the Table_name and Field_name are located.
How to check to make sure you are going to get the expected results.
Find all entries that have a comma {code type=php}SELECT * FROM table_name WHERE field_name LIKE ‘%,%’{/code} If you get what you expected then you can run this to do that actual replacement {code type=php}update table_name set field_name = replace(field_name, ‘,’, ”);{/code}
Find all entries that have an aprostrophie {code type=php}SELECT * FROM table_name WHERE field_name LIKE ‘%\’%'{/code} If you get what you expected then you can run this to do that actual replacement {code type=php}update table_name set field_name = replace(field_name, ‘\”, ”);{/code}
Find all entries that have an double quote {code type=php}SELECT * FROM table_name WHERE field_name LIKE ‘%”%’{/code} If you get what you expected then you can run this to do that actual replacement {code type=php}update table_name set field_name = replace(field_name, ‘”‘, ”);{/code}
Find all entries that have a forward slash {code type=php}SELECT * FROM table_name WHERE field_name LIKE ‘%/%’{/code} If you get what you expected then you can run this to do that actual replacement {code type=php}update table_name set field_name = replace(field_name, ‘/’, ”);{/code}
6
Meta Data
If the Robots META Tag is missing, or if there is no content, or the robot terms are not specified, then the robot terms will be assumed to be "index, follow" (e.g.
"all") which is the default indexing behavior for most major search engine spiders.
Block Robots:
{code type=php}<meta name=”robots” content=”noindex, noarchive, nofollow” />
<meta name=”robots” content=”nosnippet” />{/code}
Google: {code type=php}<meta content=”NOODP” name=”GOOGLEBOT” />{/code}
Yahoo! {code type=php}<meta content=”NOYDIR” name=”Slurp” />{/code}
MSN and Live Search:{code type=php}<meta content=”NOODP” name=”msnbot” />{/code}
Other Tags:
{code type=php}<meta http-equiv=”Content-Type” content=”text/html” />{/code}
{code type=php}<meta name=”keywords” content=”FremontTech, ‘Computer Repair’,'Web Design’” />{/code}
{code type=php}<meta name=”zipcode” content=”68025″ />{/code}
{code type=php}<meta name=”author” content=”FremontTech” />{/code}
6
Language Strings in either plain text or primed for sql db entry.
ISO 639 language codes
aa Afar
ab Abkhazian
ae Avestan
af Afrikaans
ak Akan
am Amharic
an Aragonese
ar Arabic
as Assamese
av Avaric
ay Aymara
az Azerbaijani
ba Bashkir
be Belarusian
bg Bulgarian
bh Bihari
bi Bislama
bm Bambara
bn Bengali
bo Tibetan
br Breton
bs Bosnian
ca Catalan
ce Chechen
ch Chamorro
co Corsican
cr Cree
cs Czech
cv Chuvash
cy Welsh
da Danish
de German
dv Divehi
dz Dzongkha
ee Ewe
el Greek
en English
en_US American English
en_GB British English
en_AU Australian English
eo Esperanto
es Spanish
et Estonian
eu Basque
fa Persian
ff Fulah
fi Finnish
fj Fijian
fo Faroese
fr French
fr_BE Walloon
fy Frisian
ga Irish
gd Gaelic
gl Gallegan
gn Guarani
gu Gujarati
gv Manx
ha Hausa
he Hebrew
hi Hindi
ho Hiri Motu
hr Croatian
ht Haitian
hu Hungarian
hy Armenian
hz Herero
ia Interlingua
id Indonesian
ie Interlingue
ig Igbo
ii Sichuan Yi
ik Inupiaq
io Ido
is Icelandic
it Italian
iu Inuktitut
ja Japanese
jv Javanese
ka Georgian
kg Kongo
ki Kikuyu
kj Kuanyama
kk Kazakh
kl Greenlandic
km Khmer
kn Kannada
ko Korean
kr Kanuri
ks Kashmiri
ku Kurdish
kw Cornish
kv Komi
ky Kirghiz
la Latin
lb Luxembourgish
lg Ganda
li Limburgan
ln Lingala
lo Lao
lt Lithuanian
lu Luba-Katanga
lv Latvian
mg Malagasy
mh Marshallese
mi Maori
mk Macedonian
ml Malayalam
mn Mongolian
mo Moldavian
mr Marathi
ms Malay
mt Maltese
my Burmese
na Nauru
nb Norwegian Bokmaal
nd Ndebele, North
ne Nepali
ng Ndonga
nl Dutch
nl_BE Flemish
nn Norwegian Nynorsk
no Norwegian
nr Ndebele, South
nv Navajo
ny Chichewa
oc Occitan
oj Ojibwa
om Oromo
or Oriya
os Ossetian
pa Panjabi
pi Pali
pl Polish
ps Pushto
pt Portuguese
qu Quechua
rm Raeto-Romance
rn Rundi
ro Romanian
ru Russian
rw Kinyarwanda
sa Sanskrit
sc Sardinian
sd Sindhi
se Northern Sami
sg Sango
si Sinhalese
sk Slovak
sl Slovenian
sm Samoan
sn Shona
so Somali
sq Albanian
sr Serbian
ss Swati
st Sotho, Southern
su Sundanese
sv Swedish
sw Swahili
ta Tamil
te Telugu
tg Tajik
th Thai
ti Tigrinya
tk Turkmen
tl Tagalog
tn Tswana
to Tonga
tr Turkish
ts Tsonga
tt Tatar
tw Twi
ty Tahitian
ug Uighur
uk Ukrainian
ur Urdu
uz Uzbek
ve Venda
vi Vietnamese
vo Volapuk
wa Walloon
wo Wolof
xh Xhosa
yi Yiddish
yo Yoruba
za Zhuang
zh Chinese
zu Zulu
(‘ab’,'Abkhazian’),
(‘ae’,'Avestan’),
(‘af’,'Afrikaans’),
(‘ak’,'Akan’),
(‘am’,'Amharic’),
(‘an’,'Aragonese’),
(‘ar’,'Arabic’),
(‘as’,'Assamese’),
(‘av’,'Avaric’),
(‘ay’,'Aymara’),
(‘az’,'Azerbaijani’),
(‘ba’,'Bashkir’),
(‘be’,'Belarusian’),
(‘bg’,'Bulgarian’),
(‘bh’,'Bihari’),
(‘bi’,'Bislama’),
(‘bm’,'Bambara’),
(‘bn’,'Bengali’),
(‘bo’,'Tibetan’),
(‘br’,'Breton’),
(‘bs’,'Bosnian’),
(‘ca’,'Catalan’),
(‘ce’,'Chechen’),
(‘ch’,'Chamorro’),
(‘co’,'Corsican’),
(‘cr’,'Cree’),
(‘cs’,'Czech’),
(‘cv’,'Chuvash’),
(‘cy’,'Welsh’),
(‘da’,'Danish’),
(‘de’,'German’),
(‘dv’,'Divehi’),
(‘dz’,'Dzongkha’),
(‘ee’,'Ewe’),
(‘el’,'Greek’),
(‘en’,'English’),
(‘en_us’,'US English’),
(‘en_gb’,'BritishEnglish’),
(‘en_au’,'Australian English’),
(‘eo’,'Esperanto’),
(‘es’,'Spanish’),
(‘et’,'Estonian’),
(‘eu’,'Basque’),
(‘fa’,'Persian’),
(‘ff’,'Fulah’),
(‘fi’,'Finnish’),
(‘fj’,'Fijian’),
(‘fo’,'Faroese’),
(‘fr’,'French’),
(‘fr_be’,'Walloon’),
(‘fy’,'Frisian’),
(‘ga’,'Irish’),
(‘gd’,'Gaelic’),
(‘gl’,'Gallegan’),
(‘gn’,'Guarani’),
(‘gu’,'Gujarati’),
(‘gv’,'Manx’),
(‘ha’,'Hausa’),
(‘he’,'Hebrew’),
(‘hi’,'Hindi’),
(‘ho’,'Hiri Motu’),
(‘hr’,'Croatian’),
(‘ht’,'Haitian’),
(‘hu’,'Hungarian’),
(‘hy’,'Armenian’),
(‘hz’,'Herero’),
(‘ia’,'Interlingua’),
(‘id’,'Indonesian’),
(‘ie’,'Interlingue’),
(‘ig’,'Igbo’),
(‘ii’,'Sichuan Yi’),
(‘ik’,'Inupiaq’),
(‘io’,'Ido’),
(‘is’,'Icelandic’),
(‘it’,'Italian’),
(‘iu’,'Inuktitut’),
(‘ja’,'Japanese’),
(‘jv’,'Javanese’),
(‘ka’,'Georgian’),
(‘kg’,'Kongo’),
(‘ki’,'Kikuyu’),
(‘kj’,'Kuanyama’),
(‘kk’,'Kazakh’),
(‘kl’,'Greenlandic’),
(‘km’,'Khmer’),
(‘kn’,'Kannada’),
(‘ko’,'Korean’),
(‘kr’,'Kanuri’),
(‘ks’,'Kashmiri’),
(‘ku’,'Kurdish’),
(‘kw’,'Cornish’),
(‘kv’,'Komi’),
(‘ky’,'Kirghiz’),
(‘la’,'Latin’),
(‘lb’,'Luxembourgish’),
(‘lg’,'Ganda’),
(‘li’,'Limburgan’),
(‘ln’,'Lingala’),
(‘lo’,'Lao’),
(‘lt’,'Lithuanian’),
(‘lu’,'Luba-Katanga’),
(‘lv’,'Latvian’),
(‘mg’,'Malagasy’),
(‘mh’,'Marshallese’),
(‘mi’,'Maori’),
(‘mk’,'Macedonian’),
(‘ml’,'Malayalam’),
(‘mn’,'Mongolian’),
(‘mo’,'Moldavian’),
(‘mr’,'Marathi’),
(‘ms’,'Malay’),
(‘mt’,'Maltese’),
(‘my’,'Burmese’),
(‘na’,'Nauru’),
(‘nb’,'Norwegian Bokmaal’),
(‘nd’,'Ndebele North’),
(‘ne’,'Nepali’),
(‘ng’,'Ndonga’),
(‘nl’,'Dutch’),
(‘nl_BE’,'Flemish’),
(‘nn’,'Norwegian Nynorsk’),
(‘no’,'Norwegian’),
(‘nr’,'Ndebele South’),
(‘nv’,'Navajo’),
(‘ny’,'Chichewa’),
(‘oc’,'Occitan’),
(‘oj’,'Ojibwa’),
(‘om’,'Oromo’),
(‘or’,'Oriya’),
(‘os’,'Ossetian’),
(‘pa’,'Panjabi’),
(‘pi’,'Pali’),
(‘pl’,'Polish’),
(‘ps’,'Pushto’),
(‘pt’,'Portuguese’),
(‘qu’,'Quechua’),
(‘rm’,'Raeto-Romance’),
(‘rn’,'Rundi’),
(‘ro’,'Romanian’),
(‘ru’,'Russian’),
(‘rw’,'Kinyarwanda’),
(‘sa’,'Sanskrit’),
(‘sc’,'Sardinian’),
(‘sd’,'Sindhi’),
(‘se’,'Northern Sami’),
(‘sg’,'Sango’),
(‘si’,'Sinhalese’),
(‘sk’,'Slovak’),
(‘sl’,'Slovenian’),
(‘sm’,'Samoan’),
(‘sn’,'Shona’),
(‘so’,'Somali’),
(‘sq’,'Albanian’),
(‘sr’,'Serbian’),
(‘ss’,'Swati’),
(‘st’,'Sotho Southern’),
(‘su’,'Sundanese’),
(‘sv’,'Swedish’),
(‘sw’,'Swahili’),
(‘ta’,'Tamil’),
(‘te’,'Telugu’),
(‘tg’,'Tajik’),
(‘th’,'Thai’),
(‘ti’,'Tigrinya’),
(‘tk’,'Turkmen’),
(‘tl’,'Tagalog’),
(‘tn’,'Tswana’),
(‘to’,'Tonga’),
(‘tr’,'Turkish’),
(‘ts’,'Tsonga’),
(‘tt’,'Tatar’),
(‘tw’,'Twi’),
(‘ty’,'Tahitian’),
(‘ug’,'Uighur’),
(‘uk’,'Ukrainian’),
(‘ur’,'Urdu’),
(‘uz’,'Uzbek’),
(‘ve’,'Venda’),
(‘vi’,'Vietnamese’),
(‘vo’,'Volapuk’),
(‘wa’,'Walloon’),
(‘wo’,'Wolof’),
(‘xh’,'Xhosa’),
(‘yi’,'Yiddish’),
(‘yo’,'Yoruba’),
(‘za’,'Zhuang’),
(‘zh’,'Chinese’),
(‘zu’,'Zulu’);
6
This is just a quick reference for how many seconds are in x-Minutes, Days, Months, Years etc.
|
Seconds
|
In
|
Unit
|
|
|
|
|
|
60
|
1
|
Minute(s)
|
|
300
|
5
|
Minute(s)
|
|
600
|
10
|
Minute(s)
|
|
900
|
15
|
Minute(s)
|
|
1800
|
30
|
Minute(s)
|
|
2700
|
45
|
Minute(s)
|
|
3600
|
60
|
Minute(s)
|
|
|
|
|
|
3600
|
1
|
Hour(s)
|
|
7200
|
2
|
Hour(s)
|
|
10800
|
3
|
Hour(s)
|
|
14400
|
4
|
Hour(s)
|
|
18000
|
5
|
Hour(s)
|
|
36000
|
10
|
Hour(s)
|
|
39600
|
11
|
Hour(s)
|
|
43200
|
12
|
Hour(s)
|
|
46800
|
13
|
Hour(s)
|
|
50400
|
14
|
Hour(s)
|
|
54000
|
15
|
Hour(s)
|
|
57600
|
16
|
Hour(s)
|
|
64800
|
18
|
Hour(s)
|
|
72000
|
20
|
Hour(s)
|
|
79200
|
22
|
Hour(s)
|
|
86400
|
24
|
Hour(s)
|
|
|
|
|
|
86400
|
1
|
Day(s)
|
|
172800
|
2
|
Day(s)
|
|
259200
|
3
|
Day(s)
|
|
345600
|
4
|
Day(s)
|
|
432000
|
5
|
Day(s)
|
|
518400
|
6
|
Day(s)
|
|
604800
|
7
|
Day(s)
|
|
|
|
|
|
604800
|
1
|
Week(s)
|
|
1209600
|
2
|
Week(s)
|
|
1814400
|
3
|
Week(s)
|
|
2419200
|
4
|
Week(s)
|
|
|
|
|
|
2548800
|
1
|
Month mean average
|
|
2628000
|
1
|
Month range average
|
|
|
|
|
|
2419200
|
1
|
Month (February)
|
|
2505600
|
1
|
Month (February leap year)
|
|
2592000
|
1
|
Month (April, June, September, November)
|
|
2678400
|
1
|
Month (January, March, May, July, August, October, December)
|
|
|
|
|
|
10512000
|
1
|
Quarter (3 month mean average)
|
|
|
|
|
|
31536000
|
12
|
Months
|
6
To Find your exact agent copy this
{code type=js}javascript:alert(navigator.userAgent){/code}
into your address bar (like it was a website address).
|
Version token |
Description |
|---|---|
| MSIE 8.0 | Internet Explorer 8 |
| MSIE 7.0 | Internet Explorer 7 |
| MSIE 7.0b | Internet Explorer 7 (Beta 1 pre-release only) |
| MSIE 6.0 | Microsoft Internet Explorer 6 |
| MSIE 6.0b | Internet Explorer 6 (pre-release) |
| MSIE 5.5 | Internet Explorer 5.5 |
| MSIE 5.01 | Internet Explorer 5.01 |
| MSIE 5.0 | Internet Explorer 5 |
| MSIE 5.0b1 | Internet Explorer 5 (pre-release) |
| MSIE 4.01 | Internet Explorer 4.01 |
Platform tokens describe your operating system. The following table lists Internet Explorer platform tokens for the last several versions of Windows.
| Platform token | Description |
|---|---|
| Windows NT 6.1 | Windows 7 Server 2008 R2 |
| Windows NT 6.0 | Windows Vista Windows 2008 Server |
| Windows NT 5.2 | Windows Server 2003 Windows XP x64 Edition |
| Windows NT 5.1 | Windows XP |
| Windows NT 5.01 | Windows 2000 Service Pack 1 (SP1) |
| Windows NT 5.0 | Windows 2000 |
| Windows NT 4.0 | Microsoft Windows NT 4.0 |
| Windows 98; Win 9x 4.90 |
Windows Millennium Edition (Windows Me) |
| Windows 98 | Windows 98 |
| Windows 95 | Windows 95 |
| Windows CE | Windows CE |
Certain optional components can also modify the user-agent string; the following table shows common ones. Be aware that many other applications also modify the user-agent string. Because of this, a comprehensive list is not possible. If you find additional tokens in your user-agent string, you should investigate them in more detail.
| Token | Description |
|---|---|
| .NET CLR | .NET Framework common language run time, followed by the version number. |
| SV1 | Internet Explorer 6 with enhanced security features (Windows XP SP2 and Windows Server 2003 only). |
| Tablet PC | Tablet services are installed; number indicates the version number. |
| Win64; IA64 | System has a 64-bit processor (Intel). |
| Win64; x64 | System has a 64-bit processor (AMD). |
| WOW64 | A 32-bit version of Internet Explorer is running on a 64-bit processor. |
Web Dev & Graphic Design
FremontTech Web StudioWeb Development & Design
FremontTech Is Fremont Nebraskas Premier Web Development & Design Studio
Read More...
FremontTech Pixel LabGraphic Design & Photography
FremontTech Has An Advanced High Tech Graphic Studio
Read More...
Computer Tech & Hosting
Computer & Electronic Repair
FremontTech Has A Over 15 Years of Computer Tech Experience
Read More...Website Hosting
FremontTech not only builds websites but we can host them as well!
Read More...
Web Studio
Computer Repair
Pixel Lab
Code Reference
Twitter
Facebook
Subscribe
Follow US