|
2
|
1 <?php
|
|
|
2
|
|
|
3 function findGenre($browseNode, &$ID, &$gen)
|
|
|
4 {
|
|
|
5 if($browseNode->Name == "Subjects")
|
|
|
6 {
|
|
|
7 return true;
|
|
|
8 }
|
|
|
9 else
|
|
|
10 {
|
|
|
11 if($browseNode->Ancestors->BrowseNode)
|
|
|
12 {
|
|
|
13 if(findGenre($browseNode->Ancestors->BrowseNode, $ID, $gen) == true)
|
|
|
14 {
|
|
|
15 $gen = $browseNode->Name;
|
|
|
16 $ID = $browseNode->BrowseNodeId;
|
|
|
17
|
|
|
18 //if($browseNode->Name == "Literature & Fiction") //to return one level up the tree as well
|
|
|
19 // return true;
|
|
|
20 }
|
|
|
21 }
|
|
|
22 return false;
|
|
|
23 }
|
|
|
24 }
|
|
|
25
|
|
3
|
26 global $out,$isbn;
|
|
2
|
27 if(isset($_GET['isbn'])){
|
|
|
28 $isbn = $_GET['isbn'];
|
|
|
29 if(isset($_GET['locale'])){
|
|
|
30 $locale=$_GET['locale'];
|
|
|
31
|
|
|
32 switch ($locale) {
|
|
|
33 case "uk":
|
|
|
34 $loc = 1;
|
|
|
35 break;
|
|
|
36 case "us":
|
|
|
37 $loc = 0;
|
|
|
38 break;
|
|
|
39 case "ca":
|
|
|
40 $loc = 2;
|
|
|
41 break;
|
|
|
42 case "de":
|
|
|
43 $loc = 3;
|
|
|
44 break;
|
|
|
45 case "fr":
|
|
|
46 $loc = 4;
|
|
|
47 break;
|
|
|
48 case "":
|
|
|
49 $loc = 0;
|
|
|
50 break;
|
|
|
51 }
|
|
|
52 }
|
|
|
53 else{
|
|
|
54 $loc=0;
|
|
|
55 }
|
|
|
56 $output = "";
|
|
|
57
|
|
|
58 $output .= "<?xml version=\"1.0\" encoding=\"UTF-8\"?>";
|
|
|
59 $output .= "<BookDetails>";
|
|
|
60
|
|
|
61 $proceed = true;
|
|
|
62 include "../../../private/db.php";
|
|
|
63
|
|
|
64 $query = "CALL b_getBookInfo('$isbn', $loc)";
|
|
|
65 //select Timestamp,Title,Author,Binding,DeweyDecimal,ImageURL,SalesRank,PublicationDate,Publisher,Genre1,Genre2,Genre3 from books where ISBN = '$isbn'";
|
|
|
66 //echo $query;
|
|
|
67 $res = mysqli_query($link, $query) or exit( mysqli_error( $link ));
|
|
|
68
|
|
|
69 if ( mysqli_num_rows( $res ) > 0 )
|
|
|
70 {
|
|
|
71 $rows=mysqli_fetch_array($res, MYSQLI_ASSOC);
|
|
|
72 $timestamp=$rows['Timestamp'];
|
|
|
73 //echo $timestamp;
|
|
|
74 date_default_timezone_set('UTC');
|
|
|
75 $dbStamp = strtotime($timestamp);
|
|
|
76 //echo $dbStamp;
|
|
|
77 $unixTime = time();
|
|
|
78 //echo $unixTime;
|
|
|
79 $timeDiff = $unixTime - $dbStamp;
|
|
|
80 //echo $timeDiff;
|
|
|
81
|
|
|
82 if($timeDiff < 2592000) //if it has been updated in the last 30 days
|
|
|
83 {
|
|
|
84 $proceed = false;
|
|
|
85 $output .= "<ISBN>" . $isbn . "</ISBN>";
|
|
|
86 $output .= "<Title>" . htmlspecialchars($rows["Title"]) . "</Title>";
|
|
|
87 $output .= "<Author>" . htmlspecialchars($rows["Author"]) . "</Author>";
|
|
|
88 $output .= "<Binding>" . htmlspecialchars($rows["Binding"]) . "</Binding>";
|
|
|
89 $output .= "<Dewey>" . htmlspecialchars($rows["DeweyDecimal"]) . "</Dewey>";
|
|
|
90 $output .= "<ImageURL>" . htmlspecialchars($rows["ImageURL"]) . "</ImageURL>";
|
|
|
91 $output .= "<SalesRank>" . htmlspecialchars($rows["SalesRank"]) . "</SalesRank>";
|
|
|
92 $output .= "<PublicationDate>" . htmlspecialchars($rows["PublicationDate"]) . "</PublicationDate>";
|
|
|
93 $output .= "<Publisher>" . htmlspecialchars($rows["Publisher"]) . "</Publisher>";
|
|
|
94 $output .= "<Genre1>" . htmlspecialchars($rows["Genre1"]) . "</Genre1>";
|
|
|
95 $output .= "<Genre2>" . htmlspecialchars($rows["Genre2"]) . "</Genre2>";
|
|
|
96 $output .= "<Genre3>" . htmlspecialchars($rows["Genre3"]) . "</Genre3>";
|
|
|
97 $output .= "<ProductGroup>Book</ProductGroup>";
|
|
|
98 }
|
|
|
99 }
|
|
|
100 mysqli_close($link); //do not remove. reset is needed otherwise mysqli_fetch_array doesn't work after first loop
|
|
|
101 include "../../../private/db.php";
|
|
|
102
|
|
|
103 if($proceed == true)
|
|
|
104 {
|
|
|
105 include "aws_signed_request.php";
|
|
|
106 //book does not exist already so look up all the info from browse nodes....
|
|
|
107
|
|
|
108 $Adefault=array(
|
|
|
109 'language' =>'en', //what language to render the page in
|
|
|
110 'locale' =>'us', //which server's products? available: ca,de,fr,jp,uk,us
|
|
|
111 'page' =>1, //first page to show (we are counting from 1 not 0)
|
|
|
112 'operation' =>'ItemLookup', //what to do? //ItemSearch
|
|
|
113 'searchparameter' =>'ItemId', //what kind of search?
|
|
|
114 'searchindex' => 'Books',
|
|
|
115 'searchparameterdata'=>$isbn, //what to search for?
|
|
|
116 'search' =>$isbn,
|
|
|
117 //here some debugging flags you can put at the end of the URL to call this script with, like: '?show_array=true'
|
|
|
118 'show_array' =>false, //debug: show complete incoming array? You can use this to see what other information Amazon is sending
|
|
|
119 'show_url' =>false, //debug: show XML request url to be send to Amazon?
|
|
|
120 'show_xml' =>false, //debug: show incoming XML code from Amazon?
|
|
|
121 );
|
|
|
122 //change the debug options to true if you want to activate them or call the script with '?show_array=true' to see what actual information you're getting from Amazon and how little my standard script is actually showing of it
|
|
|
123
|
|
|
124 $Aassociates_id=array(
|
|
|
125 'uk' => 'bookwhack-21',
|
|
|
126 'us' => 'your02b-20',
|
|
|
127 'ca' => 'book009-20',
|
|
|
128 'de' => 'book04c-21',
|
|
|
129 'fr' => 'book07f-21',
|
|
|
130 );
|
|
|
131
|
|
|
132 $Aserver=array(
|
|
|
133 'ca' => array(
|
|
|
134 'ext' => 'ca' , //Canadian normal server
|
|
|
135 'nor' => 'http://www.amazon.ca' , //Canadian normal server
|
|
|
136 'xml' => 'http://xml.amazon.com' , //Canadian xml server
|
|
|
137 ),
|
|
|
138 'de' => array(
|
|
|
139 'ext' => 'de' , //German normal server
|
|
|
140 'nor' => 'http://www.amazon.de' , //German normal server
|
|
|
141 'xml' => 'http://xml-eu.amazon.com', //German xml server
|
|
|
142 ),
|
|
|
143 'fr' => array(
|
|
|
144 'ext' => 'fr' , //French normal server
|
|
|
145 'nor' => 'http://www.amazon.fr' , //French normal server
|
|
|
146 'xml' => 'http://xml-eu.amazon.com', //French xml server
|
|
|
147 ),
|
|
|
148 'jp' => array(
|
|
|
149 'ext' => 'jp' , //Japanese normal server, not co.jp!
|
|
|
150 'nor' => 'http://www.amazon.co.jp' , //Japanese normal server
|
|
|
151 'xml' => 'http://xml.amazon.com' , //Japanese xml server
|
|
|
152 ),
|
|
|
153 'uk' => array(
|
|
|
154 'ext' => 'co.uk' , //UK normal server
|
|
|
155 'nor' => 'http://www.amazon.co.uk' , //UK normal server
|
|
|
156 'xml' => 'http://xml-eu.amazon.com', //UK xml server
|
|
|
157 ),
|
|
|
158 'us' => array(
|
|
|
159 'ext' => 'com' , //USA normal server
|
|
|
160 'nor' => 'http://www.amazon.com' , //USA normal server
|
|
|
161 'xml' => 'http://xml.amazon.com' , //USA xml server
|
|
|
162 ),
|
|
|
163 );
|
|
|
164
|
|
|
165 $public_key ="AKIAJBXEHTNCU6LLFNIA";
|
|
|
166 $private_key="Dgyv7aR6uGe3OtY95Dj6hHpDS/UEtyboMWpJchYA";
|
|
|
167
|
|
|
168 //for all parameters see if the user has overruled it or use the default
|
|
|
169 foreach ($Adefault as $i=>$d) {
|
|
|
170 $$i=isset($_GET[$i])?$_GET[$i]:$d;
|
|
|
171 }
|
|
|
172
|
|
|
173 $parameters=array(
|
|
|
174 'Operation' =>$operation ,
|
|
|
175 'Keywords' =>urlencode($search) ,
|
|
|
176 "$searchparameter"=>$searchparameterdata ,
|
|
|
177 'ItemPage' =>$page , //which page?
|
|
|
178 'AssociateTag' =>$Aassociates_id[$locale],
|
|
|
179 'ResponseGroup' =>'ItemAttributes,Images,SalesRank,BrowseNodes'
|
|
|
180 );
|
|
|
181
|
|
3
|
182 if ($searchindex!='Books') {
|
|
|
183 // HST did this
|
|
|
184 // Used to be in $parameters init above, but
|
|
|
185 // that caused an error:
|
|
|
186 // If idType equals ASIN, SearchIndex cannot be present
|
|
|
187 //'SearchIndex' =>$searchindex , //Books for example.
|
|
|
188 $parameters['SearchIndex']=$searchindex;
|
|
|
189 }
|
|
|
190
|
|
|
191
|
|
|
192 file_put_contents('/var/ywww/debug/phpDebug',"parms bd: ".
|
|
|
193 print_r($parameters,TRUE)."\n",FILE_APPEND);
|
|
2
|
194
|
|
|
195 $ext=$Aserver[$locale]['ext'];
|
|
|
196 $file_data=$ext;
|
|
|
197 ksort($parameters);
|
|
|
198 foreach ($parameters as $i=>$d) {
|
|
|
199 $file_data.='&'.$i.'='.$d;
|
|
|
200 }
|
|
|
201
|
|
|
202 $url=aws_signed_request($ext,$parameters,$public_key,$private_key);
|
|
|
203 //echo $url;
|
|
|
204
|
|
|
205 $crl = curl_init();
|
|
|
206 $timeout = 5;
|
|
|
207 curl_setopt ($crl, CURLOPT_URL,$url);
|
|
|
208 curl_setopt ($crl, CURLOPT_ENCODING , "gzip");
|
|
|
209 curl_setopt ($crl, CURLOPT_RETURNTRANSFER, 1);
|
|
|
210 curl_setopt ($crl, CURLOPT_CONNECTTIMEOUT, $timeout);
|
|
|
211 $out = curl_exec($crl);
|
|
|
212 curl_close($crl);
|
|
|
213
|
|
|
214 //echo $out;
|
|
|
215
|
|
3
|
216 if (preg_match("<Error>",$out)) {
|
|
|
217 $xml = new SimpleXMLElement($out);
|
|
|
218 $resName=$xml->getName();
|
|
|
219 $code=$xml->Error->Code;
|
|
|
220 file_put_contents('/var/ywww/debug/phpDebug',"Losing gBD: $resName, ".
|
|
|
221 $xml->Error->Code."\n",FILE_APPEND);
|
|
|
222 }
|
|
|
223 else {
|
|
2
|
224 $xml = new SimpleXMLElement($out);
|
|
|
225 //use this xml to pull out the necessary information and save it
|
|
3
|
226 set_error_handler(function () {
|
|
|
227 global $out,$isbn;
|
|
|
228 file_put_contents('/var/ywww/debug/phpDebug',
|
|
|
229 "Caught one bd: ".$isbn,
|
|
|
230 FILE_APPEND);
|
|
|
231 file_put_contents('/var/ywww/debug/phpDebug',
|
|
|
232 print_r($out, TRUE)."\n",
|
|
|
233 FILE_APPEND);
|
|
|
234 } );
|
|
2
|
235
|
|
|
236 $title="";
|
|
|
237 $author="";
|
|
|
238 $binding="";
|
|
|
239 $dewey="";
|
|
|
240 $imageURL="";
|
|
|
241 $salesRank="";
|
|
|
242 $pubDate="";
|
|
|
243 $publisher="";
|
|
|
244
|
|
|
245 $title = $xml->Items->Item->ItemAttributes->Title;
|
|
|
246 $author = $xml->Items->Item->ItemAttributes->Author;
|
|
|
247 $binding = $xml->Items->Item->ItemAttributes->Binding;
|
|
|
248 $dewey = $xml->Items->Item->ItemAttributes->DeweyDecimalNumber;
|
|
|
249 if($dewey == "")
|
|
|
250 $dewey = "null";
|
|
|
251 $imageURL = $xml->Items->Item->MediumImage->URL;
|
|
|
252 $salesRank = $xml->Items->Item->SalesRank;
|
|
|
253 $pubDate = $xml->Items->Item->ItemAttributes->PublicationDate;
|
|
|
254 $publisher = $xml->Items->Item->ItemAttributes->Publisher;
|
|
3
|
255 restore_error_handler();
|
|
2
|
256 /*echo $title;
|
|
|
257 echo $author;
|
|
|
258 echo $binding;
|
|
|
259 echo $dewey;
|
|
|
260 echo $imageURL;
|
|
|
261 echo $salesRank;
|
|
|
262 echo $pubDate;
|
|
|
263 echo $publisher;*/
|
|
|
264
|
|
|
265 $genreID = "";
|
|
|
266 $genre = "";
|
|
|
267 $genArr = array();
|
|
|
268 $g1 = "null";
|
|
|
269 $g2 = "null";
|
|
|
270 $g3 = "null";
|
|
|
271 if(isset($xml->Items->Item->BrowseNodes->BrowseNode)){
|
|
|
272 for($i=0;$i<sizeof($xml->Items->Item->BrowseNodes->BrowseNode);$i++){
|
|
|
273 //sexy recursive function
|
|
|
274 findGenre($xml->Items->Item->BrowseNodes->BrowseNode[$i], $genreID, $genre);
|
|
|
275
|
|
|
276 if($genre != "")
|
|
|
277 $genArr[strval($genreID)] = strval($genre);
|
|
|
278 //$genArr[$i] = array(strval($genreID) => strval($genre));
|
|
|
279
|
|
|
280 //echo $genre;
|
|
|
281 //echo $genreID;
|
|
|
282
|
|
|
283 $genre = "";
|
|
|
284 $genreID = "";
|
|
|
285 }
|
|
|
286
|
|
|
287 $g1 = "null";
|
|
|
288 $g2 = "null";
|
|
|
289 $g3 = "null";
|
|
|
290 $loop = 1;
|
|
|
291
|
|
|
292 foreach ($genArr as $key => $value) {
|
|
|
293 //echo "$key => $value";
|
|
|
294 $queryG = "CALL b_addBrowseNode($key,\"$value\")"; //add the name value pair for genre to new table
|
|
|
295 //echo $queryG;
|
|
|
296 $resG = mysqli_query($link, $queryG);
|
|
|
297
|
|
|
298 switch ($loop) {
|
|
|
299 case 1:
|
|
|
300 $g1 = $key;
|
|
|
301 break;
|
|
|
302 case 2:
|
|
|
303 $g2 = $key;
|
|
|
304 break;
|
|
|
305 case 3:
|
|
|
306 $g3 = $key;
|
|
|
307 break;
|
|
|
308 }
|
|
|
309
|
|
|
310 $loop++;
|
|
|
311 }
|
|
|
312 }
|
|
|
313
|
|
|
314 if($salesRank == "")
|
|
|
315 $salesRank = "null";
|
|
|
316
|
|
|
317 mysqli_close($link); //do not remove. reset is needed otherwise mysqli_fetch_array doesn't work after first loop
|
|
|
318 include "../../../private/db.php";
|
|
|
319
|
|
|
320 $title = strtr($title, '"', "'");
|
|
|
321 $queryInsert = "CALL b_addNewBook(\"$isbn\",\"$title\", \"$author\",\"$binding\",\"$imageURL\", $dewey, $salesRank,\"$pubDate\",\"$publisher\",$g1,$g2,$g3,$loc)";
|
|
|
322 //echo $queryInsert;
|
|
|
323
|
|
|
324 $resG = mysqli_query($link, $queryInsert) or exit( mysqli_error( $link ));
|
|
|
325 mysqli_close($link); //do not remove. reset is needed otherwise mysqli_fetch_array doesn't work after first loop
|
|
|
326
|
|
|
327
|
|
|
328 $output .= "<ISBN>" . htmlspecialchars($isbn) . "</ISBN>";
|
|
|
329 $output .= "<Title>" . htmlspecialchars($title) . "</Title>";
|
|
|
330 $output .= "<Author>" . htmlspecialchars($author) . "</Author>";
|
|
|
331 $output .= "<Binding>" . htmlspecialchars($binding) . "</Binding>";
|
|
|
332 $output .= "<Dewey>" . htmlspecialchars($dewey) . "</Dewey>";
|
|
|
333 $output .= "<ImageURL>" . htmlspecialchars($imageURL) . "</ImageURL>";
|
|
|
334 $output .= "<SalesRank>" . htmlspecialchars($salesRank) . "</SalesRank>";
|
|
|
335 $output .= "<PublicationDate>" . htmlspecialchars($pubDate) . "</PublicationDate>";
|
|
|
336 $output .= "<Publisher>" . htmlspecialchars($publisher) . "</Publisher>";
|
|
|
337 $output .= "<Genre1>" . htmlspecialchars($g1) . "</Genre1>";
|
|
|
338 $output .= "<Genre2>" . htmlspecialchars($g2) . "</Genre2>";
|
|
|
339 $output .= "<Genre3>" . htmlspecialchars($g3) . "</Genre3>";
|
|
|
340 $output .= "<ProductGroup>Book</ProductGroup>";
|
|
|
341 }
|
|
|
342
|
|
|
343 $output .= "</BookDetails>";
|
|
|
344
|
|
|
345 echo $output;
|
|
3
|
346 }
|
|
2
|
347 }
|
|
|
348 ?>
|
