Sitemizde de kullandığımız, vazgeçilmez görsel editörümüz FCKeditör'ün 2.6.6 sayılı sürümü yayınlandı.
Özellikle güvenlik nedenleriyle bu sürüme geçilmesi öneriliyor.
FCKeditor 2.6.6 yı aÅŸağıdaki resmi tıklayarak indirebilirsiniz.

Ayrıntılı bilgiler aşağıda:

Version 2.6.6 (Download Zip or GZip from Sourceforge.net)

http://sourceforge.net/projects/fckeditor/files/FCKeditor/2.6.6/FCKeditor_2.6.6.tar.gz/download

veya

http://sourceforge.net/projects/fckeditor/files/FCKeditor/2.6.6/FCKeditor_2.6.6.zip/download linkini de kullanabilirsiniz.

Açık kaynaklı Ofis Programı Open Office

Google Web tabanlı iÅŸletim sistemi Chrome OS'u geliÅŸtiricilere test için gönderdi. Ve tabii hemen torrent aÄŸlarından indirilebilir hale geldi.
Bazı ekranlar ve bilgiler aşağıda:

The public debut of Google Chrome OS today has the press abuzz over the potential of the new web-based operating system. And now that it’s open sourced, you have the chance to try it out for yourself. Unfortunately, most people aren’t ready to undertake the daunting task of actually taking Google’s recently open-sourced code and turning that into a bootable computer. So we’ve put together a step-by-step guide to doing this, for free, in around 15 minutes (depending on how long it takes to download the OS itself). No, this won’t get your computer booting Chrome OS natively (and frankly, you probably wouldn’t want to yet anyway). But it will get it up and running in a virtual machine using the free software VirtualBox, which is available for Macs, PCs, and Linux.

First, a few caveats: we didn’t create the Chrome OS build ourselves — it was downloaded from BitTorrent. In theory it could possibly have been tweaked by some malicious hacker to steal your Google account information (this is unlikely, but who knows). There’s an easy fix if you’re worried though: just go make a throwaway Gmail account, and use that to play around with the OS. Also note that because this is running in a virtual machine, you’re probably not going to be seeing great performance (like that 7 second boot time). But it’s more than good enough to get a feel for the OS for yourself.

First, you need to get an image of Chrome OS. You can do that using this torrent. You can also try out the build that GDGT has uploaded, which worked fine in our test as well. If you get the torrent version, you’ll see it’s in a .BZ2 format. You’ll need to extract it. Macs should be able to do this automatically, but for Windows you may need a tool like Win Rar.

Once that’s done, download a version of VirtualBox for whatever OS you’re running on here and install it. After registering (or declining to) you’ll be met with a screen like this. Click the button that says “New” in the upper left hand corner. We’re going to be making a new virtual machine.:

 

 

You’ll enter a wizard like this. Hit next.
 

 

Go ahead and title the OS whatever you’d like. For the operating system, choose Linux, with Ubuntu as the version (other setups could potentially work, but this is the only one we’ve gotten working).
 

 

Choose how much memory to allocate to this virtual machine. This will be dependent on how much memory you have in your computer. The more, the better, but if you choose too much your real computer will become unstable/very slow.
 

 

Here’s the tricky part (fortunately it isn’t very tricky). You don’t want to create a new hard disk, instead, you want to use an existing hard disk. Don’t choose one from the drop down menu either — you’re going to want to hit the folder icon just to the right of that to enter the ‘virtual media manager’.

 

 

Hit the ‘Add’ button.
 

 

Now you have to find the Chrome OS image you downloaded earlier. This is probably on your desktop or in your downloads folder. Once you’ve found it, hit ‘Open’.

 

 

Hit ‘Select’ once you reach this window.
 

 

Almost there. Make sure ‘use existing hard disk’ is checked. Hit next.
 

 

Hit ‘Finish’

 

 

You’re done! Hit Start. Hopefully the screen will go black, but only for a little while (this could be anywhere from 10 seconds to a minute or so, depending on how fast your computer is).
 

 

Once you’re in, you’ll see a splash screen for ‘Chromium’ (which is what Google calls dev builds of Chrome). To login, you’ll need to enter a valid Google Account ID. Your standard Gmail account should work, but as we said before, this build of ChromeOS came from bittorrent, so you may want to use a throw away account like we did in the screenshots below (you can make one here).

 

 

You’re in. Now time to explore. To be honest, everything looks quite similar to Google’s Chrome browser, but there are a few key differences. Note the battery life indicator and options menu in the far upper right. Also try playing around with the ‘New Window’ functions — you’ll find that it’s difficult (if not impossible) to navigate between multiple windows. And be wary of the Bookmarks manager. As far as I can tell, there’s no easy way to get out of it — you’ll have to manually create a new bookmark, which will kick you back into the browser mode once you click it. Oh, and good luck finding the ’shut down’ button, because we sure can’t.
 

 

 

 

You probably won’t need it, but the shared user password for this install (which you’d need for functions like sudo) is ‘chromeos’ according to the torrent’s listing on ThePirateBay.

get widgetminimize get widgetminimize

CrunchBase Information

Google Chrome OS

Company:	Google
Website:	chrome.blogspot.com/2009/07/goog...

Google Chrome OS is a PC operating system. Announced on July 7, 2009, the operating system will be open source and targeted at netbooks. Learn More

Company:	Google
Website:	chrome.blogspot.com/2009/07/goog...

Google Chrome OS is a PC operating system. Announced on July 7, 2009, the operating system will be open source and targeted at netbooks. Learn More

Information provided by CrunchBase

ALTER TABLE komutunu kullanarak veritabanlarına yeni veri alanlarının nasıl ekleneceÄŸini aÅŸağıda açıklamaya çalıştım.

Şu şekilde bir sql yapımızın olduğunu varsayalım.
Not: örnek oscommerce veri yapısından alınmıştır.
 

Bu veritabanına ait verilerin bir kısmı ÅŸöyledir.

DROP TABLE IF EXISTS `countries`;
CREATE TABLE IF NOT EXISTS `countries` (
  `countries_id` int(11) NOT NULL AUTO_INCREMENT,
  `countries_name` varchar(64) COLLATE utf8_turkish_ci NOT NULL DEFAULT '',
  `countries_iso_code_2` char(2) COLLATE utf8_turkish_ci NOT NULL DEFAULT '',
  `countries_iso_code_3` char(3) COLLATE utf8_turkish_ci NOT NULL DEFAULT '',
  `address_format_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`countries_id`),
  KEY `IDX_COUNTRIES_NAME` (`countries_name`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=1 ;

Veriler:

INSERT INTO `countries` (`countries_id`, `countries_name`, `countries_iso_code_2`, `countries_iso_code_3`, `address_format_id`) VALUES
(1, 'Afghanistan', 'AF', 'AFG', 1),
(2, 'Albania', 'AL', 'ALB', 1),
(3, 'Algeria', 'DZ', 'DZA', 1),
(4, 'American Samoa', 'AS', 'ASM', 1),
(5, 'Andorra', 'AD', 'AND', 1),
(6, 'Angola', 'AO', 'AGO', 1),
(7, 'Anguilla', 'AI', 'AIA', 1);

Yukarıda Ülke verilerinin bir kaydı tutulmaktadır.
Sırasıyla şu veriler işlenmektedir.
Kayıt No,
Ülkenin Uluslarası Adı,
Ä°ki harfli Ülke Kodu, (Örnek: Türkiye için tr)
Üç harfli Ülke Kısaltması,  (Örnek: Türkiye için TUR)
Adres formatını gösteren bir deÄŸer.

Biz bu alanların arasına Ülkenin Yerel Dildeki ismini de eklemek isteyelim.
Bu alanı `countries_local_name` değişkeni ile tanımlamak ve veritabanında da `countries_name` veri alanının hemen ardından gelmesini istiyoruz.
Yapmamız gereken işlemler aşağıda.

phpmyadmin içerisinden SQL bölümüne girerek aÅŸağıdaki satırı SQL satırlarının girildiÄŸi alana yapıştırın ve GÄ°T düÄŸmesini tıklayın.
 

ALTER TABLE countries ADD countries_local_name VARCHAR(64) NOT NULL DEFAULT '' AFTER countries_name ;

 
Aynı ÅŸeyi php kodu içinden çağırmak istersek de ÅŸu kodu kullanıyoruz.
 

$sql = "ALTER TABLE countries ADD countries_local_name VARCHAR(64) NOT NULL DEFAULT '' AFTER countries_name ;";

Sonuç aÅŸağıda:
 

DROP TABLE IF EXISTS `countries`;
CREATE TABLE IF NOT EXISTS `countries` (
  `countries_id` int(11) NOT NULL AUTO_INCREMENT,
  `countries_name` varchar(64) COLLATE utf8_turkish_ci NOT NULL DEFAULT '',
  `countries_local_name` varchar(64) COLLATE utf8_turkish_ci NOT NULL DEFAULT '',
  `countries_iso_code_2` char(2) COLLATE utf8_turkish_ci NOT NULL DEFAULT '',
  `countries_iso_code_3` char(3) COLLATE utf8_turkish_ci NOT NULL DEFAULT '',
  `address_format_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`countries_id`),
  KEY `IDX_COUNTRIES_NAME` (`countries_name`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=1 ;

--
-- Tablo döküm verisi `countries`
--

INSERT INTO `countries` (`countries_id`, `countries_name`, `countries_local_name`, `countries_iso_code_2`, `countries_iso_code_3`, `address_format_id`) VALUES
(1, 'Afghanistan', 'Afganistan', 'AF', 'AFG', 1),
(2, 'Albania', '', 'AL', 'ALB', 1),
(3, 'Algeria', '', 'DZ', 'DZA', 1),
(4, 'American Samoa', 'Amerikan Samoası', 'AS', 'ASM', 1),
(5, 'Andorra', '', 'AD', 'AND', 1),
(6, 'Angola', '', 'AO', 'AGO', 1),
(7, 'Anguilla', '', 'AI', 'AIA', 1),
(8, 'Antarctica', 'Antartika', 'AQ', 'ATA', 1),
(9, 'Antigua and Barbuda', '', 'AG', 'ATG', 1),
(10, 'Argentina', 'Arjantin', 'AR', 'ARG', 1),
(11, 'Armenia', 'Ermenistan', 'AM', 'ARM', 1);

`countries_name` alanının yanına ülkenin yerel adını görüntülemekte kullanacağımız `countries_local_name` alanını baÅŸarıyla ekledik.

Artık yerel sayfalarımızı görüntülerken istediÄŸimiz eÄŸer ülkenin yerel dildeki adını göstermekse, `countries_local_name` alanının içeriÄŸini çağırmak yeterli olacaktır.

 

Sitemizde de kullandığımız, vazgeçilmez görsel editörümüz FCKeditör'ün 2.6.4.1 sayılı sürümü yayınlandı.
Özellikle güvenlik nedenleriyle bu sürüme geçilmesi öneriliyor.
FCKeditor 2.6.4.1 i aşağıdaki resmi tıklayarak indirebilirsiniz.

Ayrıntılı bilgiler aşağıda:

Version 2.6.4.1 (Download Zip or GZip from Sourceforge.net)

Fixed Bugs:

• Security release, upgrade is highly recommended. For more details see CVE-2009-2265.