Pozdravljeni,

Potreboval bi malo pomoči oz. predlogov glede izdelave custom API-ja ki komunicira z mysql bazo in se nahaja na cpanel shared hostingu...

Na ta API se bodo povezovale custom embedded naprave:

72 MHz 32-bit ARM 7 Processor

16MB RAM and 4.5MB FLASH

GPRS/3G Modem

Ker nisem nikoli ničesar programiral v php-ju bi vas prosil če preverite primer kode in poveste kaj ni ok oz. kaj bi vi spremenili...

XML ki bi ga naprava poslala za prijavo v sistem bi bil:

<?xml version='1.0' encoding="iso-8859-1" ?>

<packet>

    <mac_address>00:00:00:00:00:00</mac_address>

    <serial>000000</serial>

    <hostname>testdevice</hostname>

    <model>devmodel</model>

    <sw_version>1.00.0000</sw_version>

    <hw_version>1.00</hw_version>

</packet>

Koda login skripte pa bi izgledala takole:

<?php

    include('config.php');



    function getClientIPAddress()

    {

        if (!empty($_SERVER['HTTP_CLIENT_IP']))

        {

            $ip=$_SERVER['HTTP_CLIENT_IP'];

        }

        elseif (!empty($_SERVER['HTTP_X_FORWARDED_FOR']))

        {

            $ip=$_SERVER['HTTP_X_FORWARDED_FOR'];

        }

        else

        {

            $ip=$_SERVER['REMOTE_ADDR'];

        }

        return $ip;

    }



    $db = mysql_connect($dbhost, $dbuser, $dbpasswd);

    mysql_select_db ($dbname) or die ("Cannot connect to database");

    mysql_query("SET NAMES 'utf8'");



    libxml_use_internal_errors(true);

    $request_xml = new SimpleXMLElement($HTTP_RAW_POST_DATA);

    if (!$request_xml)

    {

        echo "Failed loading XML\n";

        foreach(libxml_get_errors() as $error)

        {

            echo "\t", $error->message;

        }

    }

    else

    {

        $sql = "SELECT id, active, REPLACE(UUID(),'-', '') AS session FROM devices WHERE mac_address='" . $request_xml->mac_address . "' AND serial='" . $request_xml->serial . "' AND hostname='" . $request_xml->hostname . "'";

        $result = mysql_query($sql);

        $device = mysql_fetch_object($result);



        $response_xml = new SimpleXMLElement("<?xml version='1.0' encoding=\"iso-8859-1\" ?><packet></packet>");

        $response_xml->addChild('device_id', $device->id);

        $response_xml->addChild('active', $device->active);

        $response_xml->addChild('session', $device->session);



        if(is_null($device->id))

        {

            header('Content-Type: text/xml');

            echo $response_xml->asXML();

        }

        else

        {

            if($device->active = 1)

            {

                mysql_query("UPDATE devices SET status='01', dt_last_online=Now(), session='" . $device->session . "', sw_version='" . $request_xml->sw_version . "', hw_version='" . $request_xml->hw_version . "', ip_address='" . getClientIPAddress() . "' WHERE id=" . $device->id . ";");

                mysql_query("INSERT INTO events (dt, device_id, event, response, description) VALUES (Now(), " . $device->id . ", '0001', '01', '" . $device->session . "');");

                header('Content-Type: text/xml');

                echo $response_xml->asXML();

            }

            else

            {

                mysql_query("UPDATE devices SET status='02', dt_last_online=Now(), session='', sw_version='" . $request_xml->sw_version . "', hw_version='" . $request_xml->hw_version . "', ip_address='" . getClientIPAddress() . "' WHERE id=" . $device->id . ";");

                mysql_query("INSERT INTO events (dt, device_id, event, response, description) VALUES (Now(), " . $device->id . ", '0001', '02', '');");

                header('Content-Type: text/xml');

                echo $response_xml->asXML();

            }

        }

    }

    mysql_close($db);

?>

Response bo XML dokument ki izgleda takole:

<?xml version='1.0' encoding="iso-8859-1" ?>

<packet>

    <device_id>25638</device_id>

    <status>1</status>

    <session>c4cb465cd3a211e087f6006438a934f5</session>

</packet>

Torej kaj bi vi spremenili in zakaj? Kje sem ga lomil? Za kakršnokoli pomoč vam bom hvaležen.

Ali še kdo dobiva message box ob vsakem obisku katerekoli podstrani?

Recimo v messageboxu je notri link:

http://www.internetmojster.com/novice/new.html

Oz link enak strani kot si jo obiskal...

Imam en problemček in sicer ko v Administrativnem delu v joomli(1.5.20) grem na zavihek:

"Pomoč" -> "Info. o sistemu" mi ne odpre strani ampak vrže error. Gledal sem forume pa ne najdem nobene pametne rešitve. Včasih mi je zadeva delala BP.

Apache: 2.2.16

PHP: 5.3.3

MySQL: 5.0.90

Napaka:

Internal Server Error



The server encountered an internal error or misconfiguration and was unable to complete your request.



Please contact the server administrator, webmaster@carpc.si and inform them of the time the error occurred, and anything you might have done that may have caused the error.



More information about this error may be available in the server error log.



Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

Poizkusil sem uploadati vse datoteke na novo vendar ne pomaga.

Sprememba jezika v eng. tudi ne pomaga.

Kakšna ideja kako bi popravil napako?