영삼이의 전문 정보 발행처

Android 도 SQLite 를 사용하니 결과는 마찬가지라고 생각되지만 Android 에서 테스트해 보질 않아서 장담 할 수는 없을 것 같다.

암튼...SQLite 가 원래 영어, 한글 순으로 정렬을 해버린다..-_-;
기획자들의 요구사항은 한글, 영어다..

어쩌할까...생각을 해보다..생각을 접고 구글링한다..

when 을 이용하여 처리한 방법이 있다..(select절에 when사용 처음 해본다..)

[NSString stringWithFormat:@"SELECT idx, title, writer_doc, writer_img, download_reg_date, download_end_date, free_yn, tidx, vidx, gidx, title_sub, abs(vidx) as vid, case when substr(title, 1, 1) BETWEEN 'ㄱ' AND '힣' then 1 else 4 end as number FROM cartoon GROUP BY title, vid ORDER BY number %@, title %@, vid %@ LIMIT %d", orderby, orderby, orderby, limit]

abs(vidx)는 vidx값이 문자열이라 정렬하기 위해서 int형으로 변환했다...
문자열을 int 로 변경하는 convert 함수가 이놈이 맞는지 모르지만..암튼 된다.-_-;

그리고 한글, 영문 정렬.. 
when substr(title, 1, 1) BETWEEN 'ㄱ' AND '힣' then 1 else 4 end as number 

title의 첫글자를 substr 한 후 그값이  'ㄱ'에서 '힣' 사이에 속하면 1 아니면 4로 
셋팅한 후 정렬할때 number를 기준으로 정렬한다..

- (NSString *)stringFromTimeInterval:(NSTimeInterval)interval {

    NSInteger ti = (NSInteger)interval;

    NSInteger seconds = ti % 60;

    NSInteger minutes = (ti / 60) % 60;

    NSInteger hours = (ti / 3600);

    return [NSString stringWithFormat:@"%02i:%02i:%02i", hours, minutes, seconds];

}

- 윈도우즈를 위한 미디어 플레이어

- 간단한 플레이어

http://mpui.sourceforge.net/index.php?page=about

About MPlayer and MPUI

MPlayer is arguably the best media player application of the world. Is is almost strictly monolithic, which means that it mainly consists of a single 7 MB executable that already contains all necessary codecs – for most files, it does not need any external codecs to be installed. If you want to know more about this wonderful program, please visit the MPlayer homepage.

The roots of MPlayer are in the Unix environment, and it shows in the way MPlayer is used: There is no graphical user interface, or at least none worth mentioning. Instead, MPlayer completely relies on a well-crafted command line interface and powerful keyboard shortcuts. While this is perfectly OK for Unix enthusiasts, Mac and Windows users prefer nice and more or less colorful graphical interfaces. There is already a »semi-official« OS X port, but up to now, no such project exists for the Windows platform.

This is where MPUI comes into play. It is a small program for Windows that takes the command-line hassle off you. Instead, you will get a no-frills, straight-to-the-point GUI that resembles the venerable Windows Media Player 6. It does not support every feature of MPlayer – there are just too many of them – but it is a solid »workhorse« media player tool suitable for most, if not all, everyday needs.

Features

MPlayer and MPUI, when teamed up, offer the following features:

• A media player with a clean and simple interface.
• Plays hundreds of different video and audio formats, including MPEG-1, -2 and -4 (DivX), H.264, MP3, Ogg Vorbis and AAC. For most media files, no additional codecs are needed. (This is because MPlayer is not one of the uncounted DirectShow players – the codecs are directly integrated into MPlayer.exe.)
• MPUI and MPlayer together are just about 3.5 MB in size.
• The most important MPlayer options (aspect ratio, deinterlacing, and postprocessing) can be configured without typing in cryptic command-line options. (But if you want or need some non-standard options, you can still add them by hand.)
• Support for multiple audio and subtitle tracks on DVDs.
• Combines MPlayer's cool keyboard navigation with a mouse-controlled seekbar.
• Plays files, network streams and discs (such as (S)VCD or DVD). Drag&Drop supported.
• Multilingual user interface.
• No installation is required to use MPUI/MPlayer. Simply copy the two .exe files into a directory of your choice an run MPUI.
• Using a special autorun.inf file, self-playing DivX CDs can be made. This adds only 3.5 MB to your CD, and on the computer playing the disc, no codecs need to be installed.
• Both programs are free, licensed under the GNU General Public License.

몇 십년간 보드게임으로 인기를 누려 왔던 스토리를 아이폰에 적용한 게임입니다. '부자아빠 가난한아빠'를 저술한 작가도 이 게임을 아주 극찬 했습니다. 현재 아이튠즈 게임 카테고리 상위권에 있습니다.

무료

카테고리: 게임

등록일: 2011.11.11

버전: 1.0.8

크기: 60.3 MB

언어: 한국어, 영어, 일본어

개발자: M&M GAMES Corp

© M&M Games

4+ 등급

요구사항: iPhone 3GS, iPhone 4, iPhone 4S, iPod touch (3세대), iPod touch (4세대) 및 iPad와(과) 호환됩니다. iOS 4.2 버전 이상이 필요합니다.
아이튠즈 링크 :  http://itunes.apple.com/kr/app/id477076603?mt=8 바로가기

스크립트를 이용하는방법
<SCRIPT LANGUAGE="JavaScript" TYPE="text/javascript">
<!--
// [/iPhone/i]  OS가 iPhone
// [/iPod/i]  OS가 iPod
// [/Symbian/i]  OS가 심비안
// [/Windows CE/i] OS가 윈도우모바일
// [/BlackBerry/i] OS가 블랙베리 
// [/Android/i]  OS가 안드로이드일 경우
if( (navigator.userAgent.match(/iPhone/i)) ||
(navigator.userAgent.match(/iPod/i)) ||
(navigator.userAgent.match(/Symbian/i)) ||
(navigator.userAgent.match(/Windows CE/i)) ||
(navigator.userAgent.match(/BlackBerry/i)) ||
(navigator.userAgent.match(/Android/i)))
{
window.location.href='./photo.php'; // 저중 하나라도 조건이 만족하면 /m/index.php 로 이동한다.
} 
//-->
</SCRIPT>

php를 이용하는방법
<?
$T = $_SERVER['HTTP_USER_AGENT'];
if(strrpos($T,"Android") || strrpos($T,"iPhone"))
{
if(strrpos($T,"SHW-M180S")) // 갤럭시 탭
{
  $goMobile = "No";
}
else
{
  $goMobile = "Yes";
}
}

if($goMobile == "Yes")
{
?>
<SCRIPT LANGUAGE="JavaScript" TYPE="text/javascript">
<!--
  window.location.href='m1.php';
//-->
</SCRIPT>
<?
}
?>
먼저 $T로 브라우져의 정보를 알아낸다음...
그것으로 처리 하면 된다.