Reply to Thread

Post a reply to the thread: tst

Your Message

Click here to log in

4p4 51la K3T1g4 d4l4m paNc451l4 (huRuf P dAn I b354R)?

 

You may choose an icon for your message from this list

Additional Options

  • Will turn www.example.com into [URL]http://www.example.com[/URL].

Rate Thread

You may rate this thread from 1-star (Terrible) to 5-stars (Excellent) if you wish to do so.

Topic Review (Newest First)

  • 01-12-11, 00:07
    Dont
    delik.
  • 30-11-11, 08:29
    Dont
    select karyawan.id_karyawan, karyawan.nama_blk, departement.id_location, id_departemen
    from karyawan JOIN departement
    using (id_departemen);

    =================================

    select karyawan.id_karyawan, karyawan.nama_blk, departement.id_location, id_departemen
    from karyawan JOIN departement
    using (id_departemen);

    =================================

    select k.id_karyawan, k.nama_blk, d.id_location, id_departemen
    from karyawan k JOIN departement d
    using (id_departemen);

    [memberikan alias untuk mempermudah dan menimialkan tulisan pada kolom]

    =================================

    select k.id_karyawan, k.nama_blk, k.id_departemen, d.id_departemen, d.id_location
    from karyawan k join departement d
    ON (k.id_departemen = d.id_departemen)

    =================================

    select k.nama_blk emp, m.nama_blk mgr
    from karyawan k JOIN karyawan m
    on (k.id_manager = m.id_karyawan)

    =================================

    select id_karyawan, location_name
    from karyawan k
    JOIN departement d
    ON d .id_departemen = k.id_departemen
    JOIN location l
    ON d.id_location = l.id_location;

    =================================

    select k.nama_blk, k.id_departemen, d.nama_departemen
    from karyawan k LEFT OUTER JOIN departement d
    ON (k.id_departemen = d.id_departemen);

    =================================

    select k.nama_blk, k.id_departemen, d.nama_departemen
    from karyawan k RIGHT OUTER JOIN departement d
    ON (k.id_departemen = d.id_departemen);

    =================================

    select k.nama_blk, k.id_departemen, d.nama_departemen
    from karyawan k full OUTER JOIN departement d
    ON (k.id_departemen = d.id_departemen);

    =================================

    select nama_blk, nama_departemen
    from karyawan
    CROSS JOIN departement;
  • 30-11-11, 08:29
    Dont
    create table jenis_barang
    (
    kode_jenis number(2),
    nama_jenis varchar(20)
    )

    =========================

    Insert into jenis_barang values (30, 'Alat Tulis');
    Insert into jenis_barang values (31, 'Alat Komputer');
    Insert into jenis_barang values (32, 'Lain-lain');

    =========================

    alter table jenis_barang
    add constraint kodejenis_PK primary key (kode_jenis)

    =========================

    alter table jenis_barang
    add(kd_jenis number(2))

    =========================

    update jenis_barang
    set kode_jenis = 30
    where jumlah_barang = 10

    =========================







    =========================

    UPDATE JENIS_BARANG
    SET JUMLAH_BARANG = 10
    WHERE NAMA_JENIS = 'Alat Tulis'

    =========================

    UPDATE JENIS_BARANG
    SET JUMLAH_BARANG = 20
    WHERE NAMA_JENIS = 'Alat Komputer'

    =========================

    UPDATE JENIS_BARANG
    SET JUMLAH_BARANG = 30
    WHERE NAMA_JENIS = 'lain-lain'

    =========================

    Alter ada 3

    add(nambah), modify(merubah) & drop(menghapus)
    contoh add:

    menambahkan kolom record GOL_GAJI dengan tipe Varchar2(3) pada
    alter table karyawan
    add(gol_gaji) varchar2(3))

    =========================

    mengubah tipe gol_gaji yang tadi menjadi varchar2(5)

    alter table karyawan
    modify (gol_gaji varchar2(5))

    =========================

    mengubah name gol_gaji menjadi golongan_gaji

    alter table karyawan
    rename column gol_gaji to golongan_gaji

    =========================

    menghapus kolom

    alter table karyawan
    drop column golongan_gaji

    =========================

    menghapus record

    delete from jenis_barang
    where nama_jenis ='Lain-lain'

    ========================

    alter table karyawan
    add constraint IDkaryawan_PK primary key (ID_KARYAWAN)
  • 30-11-11, 08:28
    Dont
    SELECT * FROM negara

    INSERT INTO negara VALUES ('CA', 'Canada', 02)


    select distinct kode_negara
    from negara;
    (menampilkan negara yang double menjadi 1)

    --------------------------------------------------


    CREATE TABLE KARYAWAN
    (
    ID_KARYAWAN NUMBER (6) ,
    NAMA_DEPAN VARCHAR2 (20) ,
    NAMA_BLK VARCHAR2 (25) ,
    EMAIL VARCHAR2 (12) ,
    TELEPON VARCHAR2 (12) ,
    TGL_MASUK DATE ,
    JOB_ID VARCHAR2 (10) ,
    GAJI NUMBER (8,2) ,
    ID_MANAGER NUMBER (6) ,
    ID_DEPARTEMEN NUMBER (4)
    )



    desc karyawan



    INSERT INTO karyawan VALUES (100, 'Steven', 'King', 'Sking', '5528510', '17 June 1987', 'AD_PRES',24000, NULL, 90);
    INSERT INTO karyawan VALUES (101, 'Neena', 'Kochar', 'nkochar', '5527845', '21 sep 1989', 'AD_VP',17000, NULL, 80);
    INSERT INTO karyawan VALUES (102, 'Lex', 'De Haan', 'Idehaan', '5787645', '13 Jan 1993', 'IT_PROG',9000, NULL, 60);
    INSERT INTO karyawan VALUES (103, 'Anthony', 'Gunawan', 'Lachesis', '825100029', '13 June 1992', 'SQL_PROG',15000,NULL, 80);



    SELECT id_karyawan, nama_depan, nama_blk,
    id_departemen
    FROM KARYAWAN
    WHERE id_departemen = 90



    SELECT id_karyawan, nama_depan, nama_blk,
    id_departemen
    FROM KARYAWAN
    WHERE nama_depan = 'Neena'



    SELECT nama_blk, id_departemen
    FROM karyawan
    WHERE email = 'Idehaan'



    SELECT id_karyawan, nama_depan, gaji
    FROM KARYAWAN
    WHERE Gaji IN (17000, 25000 , 15000)
  • 30-11-11, 00:04
    Dont
    Quote Originally Posted by d07.RiV View Post
    DotA Replay Manager is a tool for browsing Warcraft III replays with additional features for parsing DotA replays. I've been developing it for over 3 years now and it is currently one of the most powerful parsers around.

    Download the latest version (2.10) at
    Mediafire: dotareplay2_10.zip (2.46 MB)
    Project page: DotA Replay Manager

    [tab]
    Features|Screenshots|Changelog|Bugs/crashes?
    * Explorer-like replay browser (tree view+list fiew) with functions for copy/paste/drag-and-drop, delete/rename and creating folders.
    * Organize replays by folder or by date
    * Auto-copying new replays (from LastReplay.w3g) and batch copying existing replays
    * Replay search with a lot of options like game name, length, map version, player names and heroes
    * Viewing replays directly from internet (if a URL is supplied)
    * Displays a list of replays with statistics for player or hero

    * DotA data is fully loaded from the map, so when a new version of DotA is released the program will automatically read the new data
    * Displays extended game information and list of players with score, lane, item build
    * Colored chat log with lots of game messages; search and filtering is supported
    * Timeline view - displays *estimated* hero movement over time - an animated version of the replay with many features.
    * Hero builds - skill and item orders
    * Action charts - including different action types, group hotkeys used, and APM over time graph.
    * Gold and experience timeline graphs
    * Presentation tab - format the replay info in plain text mode, forum BB codes or HTML
    * Shows hero pool for -rd/-cd and bans/picks for -cd/-cm
    * Full action log with graphical information for in-depth replay analyzis
    {|}


    {|}
    **2.10**
    - Added back/forward buttons for easier browsing. I haven't tested this feature extensively, expect bugs
    - Added "Replay options" button in game info tab, containing the options to modify replay (as it was before),
    delete replay and create backup
    - Fixed morphing heroes such as Dragon Knight sometimes not being detected correctly
    **2.09**
    - Added ExtPresent tab for new script-based Presentation. Sample script is included, see readme for
    syntax description
    - Updated playdota forum icons (:cm
    - Now shows final items for older replays
    - Fixed a couple small bugs
    **2.08**
    - Added hero icons to gold and experience graphs
    - Added zoom to gold and experience graphs
    - Added kill details to player info tab
    - Fixed APM chart
    - Added option to show empty slots in game info tab
    **2.07**
    - Updated for 6.70
    - Fixed several bugs as reported on forums and by Blasz:
    Runes names in game chat and in timeline are now displayed properly
    Fixed hero levels sometimes being incorrect in game info tab
    Fixed several icons
    And others
    **2.06**
    - Fixed a bug that made opening replays much slower
    - Improved support for AI replays - now shows heroes and items of AI players
    - Improved learned ability detection
    - Fixed multiple assists in game chat/timeline
    **2.05b**
    - Fixed compatibility with new maps
    - Added final item build to game info tab, added tooltips for icons
    - Added "Find prev" button in chat log
    - Fixed copying text in action log, enabled multiple selection
    **2.05**
    - Fixed chat log search to be case insensitive
    - Added search for Action Log
    - Added rightclick menu for Action Log that allows copying lines
    - Fixed "Copy name" option from rightclick menu in game info tab (it used to copy broken text)
    - Added assists to "Copy stats" option from rightclick menu in game info tab
    - Added "Copy matchup" button on game info tab, copies list of players and heroes in one line
    - Fixed some crashes
    - Fixed gold timeline (integer overflow ftl)
    - Finally added drag-and-drop support for folder view (tree view still doesn't support it)
    - Fixed draft view to work for -cm (note that dota is bugged atm and only lists sentinel picks/bans
    in -cd)
    - Added streaks and kill combos to game chat and timeline view (use Chat Filters button on top
    right to hide them)
    - Added support for -switch mode, colors in chat now correctly display the player's current color and
    it doesn't say "has been killed by his teammate" incorrectly anymore
    - Using blink dagger doesn't drop wards all over the timeline picture as much; the solution is still
    temporary and needs more replay data to work correctly
    - Added assists to game chat (disabled by an option in Settings), note that dota is bugged atm and doesn't
    store this information correctly
    - Removed the 8192 size limit on cache; gamecache now uses game date/time as a key instead of filename,
    this should remove duplicate replays, there is a very low chance that two different replays have the same
    date/time. As a side effect gamecache file may grow very large, delete it and cache replays again if it
    causes trouble
    - Fixed hero chart to show correct heroes and games
    - Added game mode filter to hero chart (suggested by tk1)
    - Added buildings to Timeline view, they should correctly disappear when they are destroyed. Timeline view
    is now resizable, map image has been updated to the latest version. Dead heroes now disappear correctly
    - Fixed odd time marks in graph views (e.g -0:58 to -1:00)
    - Added PlayDota smiley tags for items (assuming urn will be :urn: when it is added)
    **2.04**
    - Happy New Year
    - Fixed some bugs
    - Fixed hero chart a little, it now shows the heroes in the correct order as they appear in taverns
    - Updated to 6.65 (the only difference between this and automaticaly loading data is that icons
    will update properly)
    - Added support for new replay data: roshan, aegis, runes, correct gamemode, hero levels (affects
    xp timeline)
    - Now recognizes game start (creep spawn) and adjusts lane detection accordingly, added option to
    show all times relative to creep spawn like in actual game
    - Fixed scepter recipe and items purchased in the side shops
    - Added Draft tab, showing hero pool for -cd and bans/picks for -cd/-cm (sorry, haven't tested this
    at all since I don't have any 6.65 -cd replays, so if it doesn't I'll hotfix it later)
    - Added Action log tab, which shows a very detailed low level log of the game (I'll add search function
    for it soon). It shows hero/item/ability/etc icons and names wherever applicable, player colors
    etc, and works with any map, not only dota (the map must be in your wc3 folder under the name
    specified in the replay). Loading map and re-parsing the replay takes about 10 seconds. Mech nerds rejoice!
    - Haven't fixed crashes yet, I'll work for it soon
    **2.03**
    - Fixed various crashes
    - Fixed Sven's icon in hero chart (reported by Jager)
    - Fixed other heroes' skills appearing in build view
    **2.02b**
    - Added colored names/hero names in timeline tab as well
    - Fixed techies icon and a few others
    **2.02**
    - From now on, instead of resources.mpq the program will come with patch.mpq and when you run
    it the first time it will merge the two files - don't rename anything yourself. This way map
    data you loaded yourself will not be erased after every patch
    - Fixed some more bugs in reading player stats
    - Added an option to show hero names in chat log
    - Colored player names in chat events (e.g. hero kills)
    - Added chat search function (by text or by player)
    - Added chat filters (e.g. only show hero kills)
    - Updated the list of forum icons for Presentation tab (like uck
    - Added a set of forum icons for playdota.com
    **2.01b**
    - Fixed to correctly read recipes again
    **2.01**
    - Fixed major bug that prevented players and stats from loading correctly
    - Fixed to work with 6.60+
    - Fixed a bug that prevented upgradeable skills from registering correctly
    (e.g. all ultimates affected by scepter, Ogre Magi abilities etc.)
    - Changed hero chart a little to accomodate 9 taverns
    **2.00**
    - Major rewrite, the program now reads all DotA data from the map
    - Hero kills, tower/rax kills etc. are now shown in game chat
    - Added "Use D-A forum icons" in Presentation tab, which forces the program to use dota-allstars
    forum icons for heroes (e.g. :cmai: )
    {|}
    Report bugs in this thread please, I don't check my e-mail very often.
    If, however, you have specific replays which cause crashes, please e-mail them to [email protected]
    [/tab]
    asdasd
  • 29-11-11, 22:04
    Dont

Posting Permissions

  • You may post new threads
  • You may post replies
  • You may post attachments
  • You may edit your posts
  •