<?php
    //header('Content-type: image/png');
    mysql_connect("192.168.1.100", "root", "root");
    mysql_select_db("RSCEmulation");

    $query = mysql_query("SELECT `user`, `haircolour`, `topcolour`, `trousercolour`, `skincolour`, `headsprite`, `bodysprite`, `avatar_items` FROM `rscd_players` WHERE `avatar_items` IS NOT NULL");

    while ($r = mysql_fetch_assoc($query)) {
        $avatar_items = explode(";", $r['avatar_items']);
        foreach ($avatar_items as $item) {
            $temp = explode(":", $item);
            if ($item != null)
                $items[$temp[0]] = $temp[1];
        }
        $items = array_flip($items);




        $config['sprite_path'] = './';

        $config['appear_tpl'] = 'Sprite-{sprite}-SkinColor-{skin_colour}-Overlay-{overlay}';

        $char_props = array(
            'appearance' => array(
                'skin_colour' => $r['skincolour'],
                'hair_colour' => $r['haircolour'],
                'top_colour' => $r['topcolour'],
                'trouser_colour' => $r['trousercolour'],
                'head_sprite' => $r['headsprite'],
                'body_sprite' => $r['bodysprite']
            ),
            'wield' => $items
        );


        $skin_armour = array(308, 309, 310, 311, 312, 313, 407);
        $char_image = imagecreatetruecolor(64, 102);

        if (isset($char_props['wield'][11]))
            add_sprite($config['sprite_path'] . '/wield/' . $char_props['wield'][11] . '.png');

        if (isset($char_props['wield'][1])) {
            if (in_array($char_props['wield'][1], $skin_armour))
                add_sprite($config['sprite_path'] . '/wield/special/' . $char_props['wield'][1] . 'sc' . $char_props['appearance']['skin_colour'] . '.png');
            else
                add_sprite($config['sprite_path'] . '/wield/' . $char_props['wield'][1] . '.png');
        } else
            add_sprite($config['sprite_path'] . '/appearance/' . format_tpl(array($char_props['appearance']['body_sprite'], $char_props['appearance']['skin_colour'], $char_props['appearance']['top_colour'])) . '.png');

        if (isset($char_props['wield'][6]))
            add_sprite($config['sprite_path'] . '/wield/' . $char_props['wield'][6] . '.png');

        if (isset($char_props['wield'][10]))
            add_sprite($config['sprite_path'] . '/wield/' . $char_props['wield'][10] . '.png');

        if(isset($char_props['wield'][2]))
            add_sprite($config['sprite_path'] . '/wield/' . $char_props['wield'][2] . '.png');
        else
            add_sprite($config['sprite_path'] . '/appearance/' . format_tpl(array(3, 0, $char_props['appearance']['trouser_colour'])) . '.png');

        if (isset($char_props['wield'][9]))
            add_sprite($config['sprite_path'] . '/wield/' . $char_props['wield'][9] . '.png');

        if (isset($char_props['wield'][7]))
            add_sprite($config['sprite_path'] . '/wield/' . $char_props['wield'][7] . '.png');

        if (isset($char_props['wield'][8]))
            add_sprite($config['sprite_path'] . '/wield/' . $char_props['wield'][8] . '.png');

        if (isset($char_props['wield'][0]))
            add_sprite($config['sprite_path'] . '/wield/' . $char_props['wield'][0] . '.png');
        else
            add_sprite($config['sprite_path'] . '/appearance/' . format_tpl(array($char_props['appearance']['head_sprite'], $char_props['appearance']['skin_colour'], $char_props['appearance']['hair_colour'])) . '.png');

        if (isset($char_props['wield'][5]))
            add_sprite($config['sprite_path'] . '/wield/' . $char_props['wield'][5] . '.png');

        if (isset($char_props['wield'][4]))
            add_sprite($config['sprite_path'] . '/wield/' . $char_props['wield'][4] . '.png');

        if (isset($char_props['wield'][3]))
            add_sprite($config['sprite_path'] . '/wield/' . $char_props['wield'][3] . '.png');

        imagecolortransparent($char_image, imagecolorallocate($char_image, 0, 0, 0));


        ob_start(); imagepng($char_image); $pngimagedata = ob_get_contents(); ob_end_clean();
        //echo imagepng($char_image);
        echo "UPDATE `rscd_players` SET `avatar` = '0x" . bin2hex($pngimagedata) . "' WHERE `username` = 'Kryptix'";

        mysql_query("UPDATE `rscd_players` SET `avatar` = '0x" . bin2hex($pngimagedata) . "' WHERE `username` = 'Kryptix'");

        imagedestroy($char_image);
    }

        function add_sprite($loc) {
            global $char_image;

            $spr_add = imagecreatefrompng($loc);
            imagecopy($char_image, $spr_add, 0, 0, 0, 0, 64, 102);
            imagedestroy($spr_add);
        }

        function format_tpl($prop) {
            global $config;

            $search = array('{sprite}', '{skin_colour}', '{overlay}');
            $tpl = str_replace($search, $prop, $config['appear_tpl']);

            return $tpl;
        }
?>