SPECIFICATION /  FAQ

1.

The function file_get_contents(../xml?sql=your_query) when receiving xml, does not work. URL in function file_get_contents() must not contain any spaces, use %20 instead of a space. Also URL must not contain sign %, use %25 Example: echo file_get_contents("http://autopatrul.ru/xml/xml?code=qmFdi84mSg&sql=select%20*%20from%20main");

2.	Why request select * from main where model_name LIKE '%accord%' does not work? Use select * from main where model_name LIKE '%25accord%25'

3.	Why request select * from main where color='#белый' does not work? Use select * from main where color='%23белый'

4.	How to choose hieroglyphs? incorrectly: select * from main where color='ｼﾃｲ' right: select * from main where color='%26%2365404;%26%2365411;%26%2365394;'

5.	Long SQL-query fails. In these cases, use the method POST. GET method can transmit more than 4096 bytes of information.

1.

Why can not collect data on the site, and then output them to make fewer requests? Because lot data change rather often and you will not achieve complete synchronization. With frequent synchronization, loading will be high, but that is not included in the tariff plans. Thus, your implementation should be a request-response without keeping of all data on your side.

2.	How to make constant link to the lot that user opened? After extracting information on lot save photos and data lot on your side, indicating a permanent link pointing to your site.

3.	How to prohibit to search bots to create pressures on the auctions (robot.txt and <noindex> not help)? When outputing, use links of types <script>var lnk='lot';document.write('<a href=" '+lnk+''+'.htm">LOT 6350</a>');</script>

4.

I am using output based on a subdomain (universal interface like http://jpcenter.ru/?lang=en), but I would like to manage the bids myself. To create an account of manager, link "Make a bid" is organized inside the lot http://your_site.com/bids.php?id=58674 where id - number of entries in the table main. Then the script bids.php extracts parameters lot through SQL2XML and a request for its logic in your personal office, located on your site.

5.

How to extract detailed statistics [year/rate/mileage_range(0-25,25-50 ,..,>150)/average_price/min/max/number_of_lots] by one SQL-request? SELECT year,rate,mil_st, AVG(finish),MIN(finish),MAX(finish),COUNT(*) from stats where model_name='corolla' and marka_name='toyota' group by rate,mil_st,year order by year DESC,rate,mil_st

© «AJ-System», 2010   Consultations and site connection: +7 (4232) 67-72-41 english, russian. Skype: mihail_kruglov