Subversion Repositories cheapmusic

Rev

Rev 86 | Rev 104 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 86 Rev 96
Line 23... Line 23...
23 
    $format = 'Any';
 23 
    $format = 'Any';
24 
    $currency = 'USD'; //bugbug
 24 
    $currency = 'USD'; //bugbug
25 
    $price = 'NULL';
 25 
    $price = 'NULL';
26 
    $url = isset($wlArr->{'url'}) ? "'" . mysqli_real_escape_string($conn, $wlArr->{'url'}) . "'" : "NULL";
 26 
    $url = isset($wlArr->{'url'}) ? "'" . mysqli_real_escape_string($conn, $wlArr->{'url'}) . "'" : "NULL";
27 
    $thumbnail = isset($wlArr->{'thumbnail'}) ? "'" . mysqli_real_escape_string($conn, $wlArr->{'thumbnail'}) . "'" : "NULL";
 27 
    $thumbnail = isset($wlArr->{'thumbnail'}) ? "'" . mysqli_real_escape_string($conn, $wlArr->{'thumbnail'}) . "'" : "NULL";
- 
 
 28 
    $ip = inet_pton($_SERVER['REMOTE_ADDR']);
28 
 
 29 
 
29 
    $sql = "INSERT
 30 
    $sql = "INSERT
30 
            INTO wishlist
 31 
            INTO wishlist
31 
            (id, created, modified, uid, mid, rid, asin, barcode, title, artist, cond, format, currency, price, url, thumbnail)
 32 
            (id, created, ip, modified, uid, mid, rid, asin, barcode, title, artist, cond, format, currency, price, url, thumbnail)
32 
            VALUES (NULL, '$created', '$modified', '$uid', '$mid', '$rid', " . $asin . ", " . $barcode . ", " . $title . ", " . $artist . ", '$cond', '$format', '$currency', '$price', " . $url . ", " . $thumbnail . ")";
 33 
            VALUES (NULL, '$created', '$ip', '$modified', '$uid', '$mid', '$rid', " . $asin . ", " . $barcode . ", " . $title . ", " . $artist . ", '$cond', '$format', '$currency', '$price', " . $url . ", " . $thumbnail . ")";
33 
 
 34 
 
34 
    if ($result = mysqli_query($conn, $sql)) {
 35 
    if ($result = mysqli_query($conn, $sql)) {
35 
        return 0;
 36 
        return 0;
36 
    }
 37 
    }
37 
    else {
 38 
    else {