Парсер XML — различия между версиями
Admin (обсуждение | вклад) (Новая страница: «'''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-BoldMT;mso-bidi-font-family: TimesNewRomanPS-BoldMT;color:black">Название</span>''' '''<span st…») |
Admin (обсуждение | вклад) |
||
Строка 1: | Строка 1: | ||
− | '''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-BoldMT;mso-bidi-font-family: | + | '''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-BoldMT;mso-bidi-font-family: TimesNewRomanPS-BoldMT;color:black">Название</span>''' |
− | TimesNewRomanPS-BoldMT;color:black">Название</span>''' | + | |
− | '''<span style="font-size:12.0pt;mso-bidi-font-family:TimesNewRomanPS-BoldMT;color:black" | + | '''<span style="font-size:12.0pt;mso-bidi-font-family:TimesNewRomanPS-BoldMT;color:black" />''' |
− | ''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | ''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">alawar_xml_parser.php </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">– инструмент для парсинга партнерского XML Алавар.</span> |
− | TimesNewRomanPS-ItalicMT;color:black">alawar_xml_parser.php </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPSMT;color:black">– инструмент для парсинга партнерского XML Алавар.</span> | ||
− | '''<span lang="EN-US" style="font-size:12.0pt;mso-bidi-font-family:TimesNewRomanPS-BoldMT;color:black; | + | '''<span lang="EN-US" style="font-size:12.0pt;mso-bidi-font-family:TimesNewRomanPS-BoldMT;color:black; mso-ansi-language:EN-US" />''' |
− | mso-ansi-language:EN-US" | ||
− | '''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-BoldMT;mso-bidi-font-family: | + | '''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-BoldMT;mso-bidi-font-family: TimesNewRomanPS-BoldMT;color:black">Синтаксис</span>''' |
− | TimesNewRomanPS-BoldMT;color:black">Синтаксис</span>''' | + | |
− | '''<span style="font-size:12.0pt;mso-bidi-font-family:TimesNewRomanPS-BoldMT;color:black" | + | '''<span style="font-size:12.0pt;mso-bidi-font-family:TimesNewRomanPS-BoldMT;color:black" />''' |
− | ''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | ''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">alawar_xml_parser.php --pid=pid –dbhost=dbhost |
− | TimesNewRomanPS-ItalicMT;color:black">alawar_xml_parser.php --pid=pid –dbhost=dbhost | ||
–dbuser=dbuser –dbpass=dbpass –</span>'' | –dbuser=dbuser –dbpass=dbpass –</span>'' | ||
+ | |||
− | ''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | ''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">dbname=dbname [recreatetables | fetch]</span>'' |
− | TimesNewRomanPS-ItalicMT;color:black">dbname=dbname [recreatetables | fetch]</span>'' | + | |
− | '''<span lang="EN-US" style="font-size:12.0pt;mso-bidi-font-family:TimesNewRomanPS-BoldMT;color:black; | + | '''<span lang="EN-US" style="font-size:12.0pt;mso-bidi-font-family:TimesNewRomanPS-BoldMT;color:black; mso-ansi-language:EN-US" />''' |
− | mso-ansi-language:EN-US" | ||
− | '''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-BoldMT;mso-bidi-font-family: | + | '''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-BoldMT;mso-bidi-font-family: TimesNewRomanPS-BoldMT;color:black">Информация</span>''' |
− | TimesNewRomanPS-BoldMT;color:black">Информация</span>''' | + | |
− | '''<span lang="EN-US" style="font-size:12.0pt;mso-bidi-font-family:TimesNewRomanPS-BoldMT;color:black; | + | '''<span lang="EN-US" style="font-size:12.0pt;mso-bidi-font-family:TimesNewRomanPS-BoldMT;color:black; mso-ansi-language:EN-US"> |
− | mso-ansi-language:EN-US"> | + | </span>''' |
− | ''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | ''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">alawar_xml_parser.php </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">– инструмент для разбора XML партнерской программы |
− | TimesNewRomanPS-ItalicMT;color:black">alawar_xml_parser.php </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">– инструмент для разбора XML партнерской программы | ||
Алавар.</span> | Алавар.</span> | ||
+ | |||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; color:black">Позволяет разобрать данные отгружаемые партнерам и вставить их в структуру |
− | 12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; | ||
− | color:black">Позволяет разобрать данные отгружаемые партнерам и вставить их в структуру | ||
таблиц</span> | таблиц</span> | ||
+ | |||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; color:black">MySQL. Строит следующие таблицы БД:</span> |
− | 12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; | + | |
− | color:black">MySQL. Строит следующие таблицы БД:</span> | ||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; color:black">1) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT; mso-bidi-font-family:TimesNewRomanPS-ItalicMT;color:black">ala-xml-dictionaries</span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">, для словарей жанров и рейтинов</span> |
− | 12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; | + | |
− | color:black">1) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT; | ||
− | mso-bidi-font-family:TimesNewRomanPS-ItalicMT;color:black">ala-xml-dictionaries</span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">, для словарей жанров и рейтинов</span> | ||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; color:black">2) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT; mso-bidi-font-family:TimesNewRomanPS-ItalicMT;color:black">ala-xml-files</span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">, для информации о файлах игр</span> |
− | 12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; | + | |
− | color:black">2) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT; | ||
− | mso-bidi-font-family:TimesNewRomanPS-ItalicMT;color:black">ala-xml-files</span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">, для информации о файлах игр</span> | ||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; color:black">3) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT; mso-bidi-font-family:TimesNewRomanPS-ItalicMT;color:black">ala-xml-images</span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">, для информации о графике игр</span> |
− | 12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; | + | |
− | color:black">3) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT; | ||
− | mso-bidi-font-family:TimesNewRomanPS-ItalicMT;color:black">ala-xml-images</span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">, для информации о графике игр</span> | ||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; color:black">4) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT; mso-bidi-font-family:TimesNewRomanPS-ItalicMT;color:black">ala-xml-items</span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">, для информации об играх</span> |
− | 12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; | + | |
− | color:black">4) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT; | ||
− | mso-bidi-font-family:TimesNewRomanPS-ItalicMT;color:black">ala-xml-items</span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">, для информации об играх</span> | ||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; color:black">5) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT; mso-bidi-font-family:TimesNewRomanPS-ItalicMT;color:black">ala-xml-related</span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">, для хранения связей между играми</span> |
− | 12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; | + | |
− | color:black">5) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT; | ||
− | mso-bidi-font-family:TimesNewRomanPS-ItalicMT;color:black">ala-xml-related</span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">, для хранения связей между играми</span> | ||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; color:black">6) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT; mso-bidi-font-family:TimesNewRomanPS-ItalicMT;color:black">ala-xml-screenshots</span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">, для информации о скриншотах игр</span> |
− | 12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; | + | |
− | color:black">6) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT; | ||
− | mso-bidi-font-family:TimesNewRomanPS-ItalicMT;color:black">ala-xml-screenshots</span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">, для информации о скриншотах игр</span> | ||
− | + | | |
− | |||
− | '''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-BoldMT;mso-bidi-font-family: | + | '''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-BoldMT;mso-bidi-font-family: TimesNewRomanPS-BoldMT;color:black">Примеры</span>''' |
− | TimesNewRomanPS-BoldMT;color:black">Примеры</span>''' | + | |
− | + | | |
− | |||
− | ''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | ''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black;mso-ansi-language:EN-US">./alawar_xml_parser.php |
− | TimesNewRomanPS-ItalicMT;color:black;mso-ansi-language:EN-US">./alawar_xml_parser.php | ||
–dbhost=localhost –dbuser=root –dbpass=pwd –dbname=mydb</span>'' | –dbhost=localhost –dbuser=root –dbpass=pwd –dbname=mydb</span>'' | ||
+ | |||
− | ''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | ''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">recreatetables</span>'' |
− | TimesNewRomanPS-ItalicMT;color:black">recreatetables</span>'' | + | |
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; color:black">Выполнит соединение с сервером MySQL и пересоздаст структуру таблиц |
− | 12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; | ||
− | color:black">Выполнит соединение с сервером MySQL и пересоздаст структуру таблиц | ||
для хранения</span> | для хранения</span> | ||
+ | |||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; color:black">данных партнерского XML. В случае если указанные таблицы уже существуют |
− | 12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; | ||
− | color:black">данных партнерского XML. В случае если указанные таблицы уже существуют | ||
они будут</span> | они будут</span> | ||
+ | |||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; color:black">созданы заново и данные, хранящиеся в них, будут стерты.</span> |
− | 12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; | + | |
− | color:black">созданы заново и данные, хранящиеся в них, будут стерты.</span> | ||
− | ''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | ''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black;mso-ansi-language:EN-US">./alawar_xml_parser.php |
− | TimesNewRomanPS-ItalicMT;color:black;mso-ansi-language:EN-US">./alawar_xml_parser.php | ||
–pid=1234 –dbhost=localhost –dbuser=root –dbpass=pwd –</span>'' | –pid=1234 –dbhost=localhost –dbuser=root –dbpass=pwd –</span>'' | ||
+ | |||
− | ''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | ''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">dbname=mydb fetch</span>'' |
− | TimesNewRomanPS-ItalicMT;color:black">dbname=mydb fetch</span>'' | + | |
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; color:black">Выполнит соединение с сервером MySQL, закачает партнерский XML с сервера</span> |
− | 12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; | + | |
− | color:black">Выполнит соединение с сервером MySQL, закачает партнерский XML с сервера</span> | ||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; color:black">export.alawar.ru?pid=1234, и обновит данные в таблицах.</span> |
− | 12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; | + | |
− | color:black">export.alawar.ru?pid=1234, и обновит данные в таблицах.</span> | ||
− | + | | |
− | |||
− | '''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-BoldMT;mso-bidi-font-family: | + | '''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-BoldMT;mso-bidi-font-family: TimesNewRomanPS-BoldMT;color:black">Опции</span>''' |
− | TimesNewRomanPS-BoldMT;color:black">Опции</span>''' | + | |
− | + | | |
− | |||
− | ''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | ''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">–pid </span>'''''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-BoldMT;mso-bidi-font-family: TimesNewRomanPS-BoldMT;color:black">– </span>'''<span style="font-size:12.0pt; font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; color:black">Идентификатор партнера</span> |
− | TimesNewRomanPS-ItalicMT;color:black">–pid </span>'''''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-BoldMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-BoldMT;color:black">– </span>'''<span style="font-size:12.0pt; | ||
− | font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; | ||
− | color:black">Идентификатор партнера</span> | ||
− | ''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | ''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">–dbhost </span>'''''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-BoldMT;mso-bidi-font-family: TimesNewRomanPS-BoldMT;color:black">– </span>'''<span style="font-size:12.0pt; font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; color:black">Хост сервера MySQL</span> |
− | TimesNewRomanPS-ItalicMT;color:black">–dbhost </span>'''''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-BoldMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-BoldMT;color:black">– </span>'''<span style="font-size:12.0pt; | ||
− | font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; | ||
− | color:black">Хост сервера MySQL</span> | ||
− | ''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | ''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">–dbuser </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">– Имя учетной записи для подключения к серверу |
− | TimesNewRomanPS-ItalicMT;color:black">–dbuser </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">– Имя учетной записи для подключения к серверу | ||
MySQL</span> | MySQL</span> | ||
+ | |||
− | ''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | ''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">–dbpass </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">– Пароль учетной записи для подключения к серверу |
− | TimesNewRomanPS-ItalicMT;color:black">–dbpass </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">– Пароль учетной записи для подключения к серверу | ||
MySQL</span> | MySQL</span> | ||
+ | |||
− | ''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | ''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">–dbname </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">– Имя базы данных</span> |
− | TimesNewRomanPS-ItalicMT;color:black">–dbname </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPSMT;color:black">– Имя базы данных</span> | ||
− | ''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | ''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">recreatetables </span>'''''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-BoldMT;mso-bidi-font-family: TimesNewRomanPS-BoldMT;color:black">– </span>'''<span style="font-size:12.0pt; font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; color:black">Пересоздает таблицы базы данных</span> |
− | TimesNewRomanPS-ItalicMT;color:black">recreatetables </span>'''''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-BoldMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-BoldMT;color:black">– </span>'''<span style="font-size:12.0pt; | ||
− | font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; | ||
− | color:black">Пересоздает таблицы базы данных</span> | ||
− | ''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | ''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">fetch </span>'''''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-BoldMT;mso-bidi-font-family: TimesNewRomanPS-BoldMT;color:black">– </span>'''<span style="font-size:12.0pt; font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; color:black">Закачивает партнерский XML и обновляет данные в базе</span> |
− | TimesNewRomanPS-ItalicMT;color:black">fetch </span>'''''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-BoldMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-BoldMT;color:black">– </span>'''<span style="font-size:12.0pt; | ||
− | font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; | ||
− | color:black">Закачивает партнерский XML и обновляет данные в базе</span> | ||
− | + | | |
− | |||
− | '''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-BoldMT;mso-bidi-font-family: | + | '''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-BoldMT;mso-bidi-font-family: TimesNewRomanPS-BoldMT;color:black">Структура таблиц</span>''''''<span lang="EN-US" style="font-size:12.0pt;mso-bidi-font-family:TimesNewRomanPS-BoldMT;color:black; mso-ansi-language:EN-US" />''' |
− | TimesNewRomanPS-BoldMT;color:black">Структура таблиц</span>''' | ||
− | + | | |
− | |||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; color:black">Поля таблиц соответствуют значениям и аттрибутам элементов XML.</span> |
− | 12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; | + | |
− | color:black">Поля таблиц соответствуют значениям и аттрибутам элементов XML.</span> | ||
− | ''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | ''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black;mso-ansi-language:EN-US">1) |
− | TimesNewRomanPS-ItalicMT;color:black;mso-ansi-language:EN-US">1) | + | ala-xml-dictionaries – </span>''''<span style="font-size:12.0pt;font-family: TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT;color:black">жанры</span><span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black;mso-ansi-language:EN-US"> </span><span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">и</span><span style="font-size:12.0pt; font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; color:black;mso-ansi-language:EN-US"> </span><span style="font-size:12.0pt; font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; color:black">рейтинги</span>'' |
− | ala-xml-dictionaries – </span>''<span style="font-size:12.0pt;font-family: | + | |
− | TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT;color:black">жанры</span><span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black;mso-ansi-language:EN-US"> </span><span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">и</span><span style="font-size:12.0pt; | ||
− | font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; | ||
− | color:black;mso-ansi-language:EN-US"> </span><span style="font-size:12.0pt; | ||
− | font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; | ||
− | color:black">рейтинги</span> | ||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">Catalog, varchar(20) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">– код каталога, возможные значения:</span> |
− | 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-ItalicMT;color:black">Catalog, varchar(20) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">– код каталога, возможные значения:</span> | ||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">– </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">casualpcgames</span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">, - pc игры</span> |
− | 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">– </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-ItalicMT;color:black">casualpcgames</span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">, - pc игры</span> | ||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">– </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">onlinegames</span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">, - флеш игры</span> |
− | 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">– </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-ItalicMT;color:black">onlinegames</span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">, - флеш игры</span> | ||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">DictionaryCode, varchar(20) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">– код списка словарей, возможные значения:</span> |
− | 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-ItalicMT;color:black">DictionaryCode, varchar(20) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">– код списка словарей, возможные значения:</span> | ||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">– </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">all-games</span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">, - все игры</span> |
− | 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">– </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-ItalicMT;color:black">all-games</span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">, - все игры</span> | ||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">– </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">Genre</span>''<span style="font-size: 12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; color:black">, - игры разбитые по жанрам</span> |
− | 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">– </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-ItalicMT;color:black">Genre</span>''<span style="font-size: | ||
− | 12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; | ||
− | color:black">, - игры разбитые по жанрам</span> | ||
− | <span lang="EN-US" style="font-size:12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol; | + | <span lang="EN-US" style="font-size:12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol; color:black;mso-ansi-language:EN-US">– </span>''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black;mso-ansi-language:EN-US">Rating</span>''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black;mso-ansi-language:EN-US">, - </span><span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">рейтинги</span><span style="font-size:12.0pt; font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; color:black;mso-ansi-language:EN-US"> </span><span style="font-size:12.0pt; font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; color:black">игр</span> |
− | color:black;mso-ansi-language:EN-US">– </span>''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-ItalicMT;color:black;mso-ansi-language:EN-US">Rating</span>''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black;mso-ansi-language:EN-US">, - </span><span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">рейтинги</span><span style="font-size:12.0pt; | ||
− | font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; | ||
− | color:black;mso-ansi-language:EN-US"> </span><span style="font-size:12.0pt; | ||
− | font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; | ||
− | color:black">игр</span> | ||
− | <span lang="EN-US" style="font-size:12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol; | + | <span lang="EN-US" style="font-size:12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol; color:black;mso-ansi-language:EN-US">• </span>''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black;mso-ansi-language:EN-US">DictionaryItemCode, |
− | color:black;mso-ansi-language:EN-US">• </span>''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | varchar(20) </span>''''<span lang="EN-US" style="font-size:12.0pt;font-family: TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT;color:black; mso-ansi-language:EN-US">– </span><span style="font-size:12.0pt;font-family: TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT;color:black">код</span><span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black;mso-ansi-language:EN-US"> </span><span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">словаря</span>'' |
− | TimesNewRomanPS-ItalicMT;color:black;mso-ansi-language:EN-US">DictionaryItemCode, | + | |
− | varchar(20) </span>''<span lang="EN-US" style="font-size:12.0pt;font-family: | ||
− | TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT;color:black; | ||
− | mso-ansi-language:EN-US">– </span><span style="font-size:12.0pt;font-family: | ||
− | TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT;color:black">код</span><span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black;mso-ansi-language:EN-US"> </span><span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">словаря</span> | ||
− | <span lang="EN-US" style="font-size:12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol; | + | <span lang="EN-US" style="font-size:12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol; color:black;mso-ansi-language:EN-US">• </span>''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black;mso-ansi-language:EN-US">DictionaryItemName, |
− | color:black;mso-ansi-language:EN-US">• </span>''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | varchar(255) </span>''''<span lang="EN-US" style="font-size:12.0pt;font-family: TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT;color:black; mso-ansi-language:EN-US">– </span><span style="font-size:12.0pt;font-family: TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT;color:black">название</span><span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black;mso-ansi-language:EN-US"> </span><span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">словаря</span>'' |
− | TimesNewRomanPS-ItalicMT;color:black;mso-ansi-language:EN-US">DictionaryItemName, | + | |
− | varchar(255) </span>''<span lang="EN-US" style="font-size:12.0pt;font-family: | ||
− | TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT;color:black; | ||
− | mso-ansi-language:EN-US">– </span><span style="font-size:12.0pt;font-family: | ||
− | TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT;color:black">название</span><span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black;mso-ansi-language:EN-US"> </span><span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">словаря</span> | ||
− | <span lang="EN-US" style="font-size:12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol; | + | <span lang="EN-US" style="font-size:12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol; color:black;mso-ansi-language:EN-US">• </span>''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black;mso-ansi-language:EN-US">Element, int(11) </span>''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black;mso-ansi-language:EN-US">– </span><span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">идентификатор</span><span style="font-size:12.0pt; font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; color:black;mso-ansi-language:EN-US"> </span><span style="font-size:12.0pt; font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; color:black">игры</span> |
− | color:black;mso-ansi-language:EN-US">• </span>''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-ItalicMT;color:black;mso-ansi-language:EN-US">Element, int(11) </span>''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black;mso-ansi-language:EN-US">– </span><span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">идентификатор</span><span style="font-size:12.0pt; | ||
− | font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; | ||
− | color:black;mso-ansi-language:EN-US"> </span><span style="font-size:12.0pt; | ||
− | font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; | ||
− | color:black">игры</span> | ||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">Value, int(11) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">– значение игры в данном словаре</span> |
− | 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-ItalicMT;color:black">Value, int(11) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">– значение игры в данном словаре</span> | ||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; color:black">2) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT; mso-bidi-font-family:TimesNewRomanPS-ItalicMT;color:black">ala-xml-files </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">– дистрибутивы игр</span> |
− | 12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; | + | |
− | color:black">2) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT; | ||
− | mso-bidi-font-family:TimesNewRomanPS-ItalicMT;color:black">ala-xml-files </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">– дистрибутивы игр</span> | ||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">ItemID, int(11) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">– идентфикатор игры</span> |
− | 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-ItalicMT;color:black">ItemID, int(11) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">– идентфикатор игры</span> | ||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">Type, varchar(20) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">– тип файла, возможные значения:</span> |
− | 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-ItalicMT;color:black">Type, varchar(20) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">– тип файла, возможные значения:</span> | ||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">– </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">distrib </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">– дистрибутив игры</span> |
− | 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">– </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-ItalicMT;color:black">distrib </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">– дистрибутив игры</span> | ||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">Timestamp, int(11) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">– unix-timestamp даты последней модификации файла</span> |
− | 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-ItalicMT;color:black">Timestamp, int(11) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">– unix-timestamp даты последней модификации файла</span> | ||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">Name, varchar(255) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">– имя файла</span> |
− | 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-ItalicMT;color:black">Name, varchar(255) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">– имя файла</span> | ||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">Size, varchar(20) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">– размер файла, строка для отображения, например |
− | 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | ||
− | TimesNewRomanPS-ItalicMT;color:black">Size, varchar(20) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">– размер файла, строка для отображения, например | ||
13Mb</span> | 13Mb</span> | ||
+ | |||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">Url, varchar(255) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">– url файла</span> |
− | 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-ItalicMT;color:black">Url, varchar(255) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">– url файла</span> | ||
− | ''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | ''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">3) ala-xml-images </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">– графика игр</span> |
− | TimesNewRomanPS-ItalicMT;color:black">3) ala-xml-images </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPSMT;color:black">– графика игр</span> | ||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">ItemID, int(11) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">– идентфикатор игры</span> |
− | 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-ItalicMT;color:black">ItemID, int(11) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">– идентфикатор игры</span> | ||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">Type, varchar(20) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">– тип графики, возможные значения:</span> |
− | 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-ItalicMT;color:black">Type, varchar(20) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">– тип графики, возможные значения:</span> | ||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">– </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">icon44x44</span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">, - иконка размером 44 на 44 на белом фоне</span> |
− | 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">– </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-ItalicMT;color:black">icon44x44</span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">, - иконка размером 44 на 44 на белом фоне</span> | ||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">– </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">icon44x44bg</span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">, - иконка размером 44 на 44 с фоном</span> |
− | 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">– </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-ItalicMT;color:black">icon44x44bg</span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">, - иконка размером 44 на 44 с фоном</span> | ||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">– </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">icon100x100</span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">, - иконка размером 100 на 100 на белом фоне</span> |
− | 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">– </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-ItalicMT;color:black">icon100x100</span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">, - иконка размером 100 на 100 на белом фоне</span> | ||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">– </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">icon100x100bg</span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">, - иконка размером 100 на 100 с фоном</span> |
− | 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">– </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-ItalicMT;color:black">icon100x100bg</span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">, - иконка размером 100 на 100 с фоном</span> | ||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">– </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">logo190x140</span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">, - логотип игры размером 190 на 140</span> |
− | 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">– </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-ItalicMT;color:black">logo190x140</span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">, - логотип игры размером 190 на 140</span> | ||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">– </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">banner586x152</span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">, - баннер игры размером 586 на 152</span> |
− | 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">– </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-ItalicMT;color:black">banner586x152</span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">, - баннер игры размером 586 на 152</span> | ||
− | <span lang="EN-US" style="font-size:12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol; | + | <span lang="EN-US" style="font-size:12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol; color:black;mso-ansi-language:EN-US">• </span>''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black;mso-ansi-language:EN-US">Width, |
− | color:black;mso-ansi-language:EN-US">• </span>''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | varchar(20) </span>''''<span lang="EN-US" style="font-size:12.0pt;font-family: TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT;color:black; mso-ansi-language:EN-US">– </span><span style="font-size:12.0pt;font-family: TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT;color:black">ширина</span>'' |
− | TimesNewRomanPS-ItalicMT;color:black;mso-ansi-language:EN-US">Width, | + | |
− | varchar(20) </span>''<span lang="EN-US" style="font-size:12.0pt;font-family: | ||
− | TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT;color:black; | ||
− | mso-ansi-language:EN-US">– </span><span style="font-size:12.0pt;font-family: | ||
− | TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT;color:black">ширина</span> | ||
− | <span lang="EN-US" style="font-size:12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol; | + | <span lang="EN-US" style="font-size:12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol; color:black;mso-ansi-language:EN-US">• </span>''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black;mso-ansi-language:EN-US">Height, |
− | color:black;mso-ansi-language:EN-US">• </span>''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | varchar(255) </span>''''<span lang="EN-US" style="font-size:12.0pt;font-family: TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT;color:black; mso-ansi-language:EN-US">– </span><span style="font-size:12.0pt;font-family: TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT;color:black">высота</span>'' |
− | TimesNewRomanPS-ItalicMT;color:black;mso-ansi-language:EN-US">Height, | + | |
− | varchar(255) </span>''<span lang="EN-US" style="font-size:12.0pt;font-family: | ||
− | TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT;color:black; | ||
− | mso-ansi-language:EN-US">– </span><span style="font-size:12.0pt;font-family: | ||
− | TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT;color:black">высота</span> | ||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">Timestamp, int(11) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">– unix-timestamp даты последней модификации графического</span> |
− | 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-ItalicMT;color:black">Timestamp, int(11) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">– unix-timestamp даты последней модификации графического</span> | ||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; color:black">файла</span> |
− | 12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; | + | |
− | color:black">файла</span> | ||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">Url, int(11) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">– url графического файла</span> |
− | 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-ItalicMT;color:black">Url, int(11) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">– url графического файла</span> | ||
− | ''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | ''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">4) ala-xml-items </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">– игры</span> |
− | TimesNewRomanPS-ItalicMT;color:black">4) ala-xml-items </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPSMT;color:black">– игры</span> | ||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">ID, int(11) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">– идентфикатор игры</span> |
− | 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-ItalicMT;color:black">ID, int(11) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">– идентфикатор игры</span> | ||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">Catalog, varchar(20) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">– код каталога</span> |
− | 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-ItalicMT;color:black">Catalog, varchar(20) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">– код каталога</span> | ||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">Language, varchar(2) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">– код языка экспорта</span> |
− | 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-ItalicMT;color:black">Language, varchar(2) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">– код языка экспорта</span> | ||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">Name, varchar(255) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">– название игры</span> |
− | 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-ItalicMT;color:black">Name, varchar(255) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">– название игры</span> | ||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">SymbolCode, varchar(255) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">– url-безопасный символьный код игры</span> |
− | 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-ItalicMT;color:black">SymbolCode, varchar(255) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">– url-безопасный символьный код игры</span> | ||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">Locale, varchar(2) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">– локализация игры</span> |
− | 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-ItalicMT;color:black">Locale, varchar(2) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">– локализация игры</span> | ||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">ReleaseDate, date </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">– дата выхода игры</span> |
− | 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-ItalicMT;color:black">ReleaseDate, date </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">– дата выхода игры</span> | ||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">Width, int(11) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">– рекомендуемая ширина страницы с флеш игрой</span> |
− | 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-ItalicMT;color:black">Width, int(11) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">– рекомендуемая ширина страницы с флеш игрой</span> | ||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">Height, int(11) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">– рекомендуемая высота страницы с флеш игрой</span> |
− | 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-ItalicMT;color:black">Height, int(11) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">– рекомендуемая высота страницы с флеш игрой</span> | ||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">SwfWidth, int(11) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">– ширина флеш игры</span> |
− | 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-ItalicMT;color:black">SwfWidth, int(11) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">– ширина флеш игры</span> | ||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">SwfHeight, int(11) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">– высота флеш игры</span> |
− | 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-ItalicMT;color:black">SwfHeight, int(11) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">– высота флеш игры</span> | ||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">PageUrl, varchar(255) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">– url на страницу с флеш игрой</span> |
− | 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-ItalicMT;color:black">PageUrl, varchar(255) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">– url на страницу с флеш игрой</span> | ||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">Embed, text </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">– html-тэг embed для включения флеш игры на произвольную |
− | 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | ||
− | TimesNewRomanPS-ItalicMT;color:black">Embed, text </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">– html-тэг embed для включения флеш игры на произвольную | ||
страницу</span> | страницу</span> | ||
+ | |||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">Description45, varchar(45) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">– описание игры длиной в 45 символов</span> |
− | 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-ItalicMT;color:black">Description45, varchar(45) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">– описание игры длиной в 45 символов</span> | ||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">Description80, varchar(80) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">– описание игры длиной в 80 символов</span> |
− | 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-ItalicMT;color:black">Description80, varchar(80) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">– описание игры длиной в 80 символов</span> | ||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">Description450, text </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">– описание игры длиной в 450 символов</span> |
− | 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-ItalicMT;color:black">Description450, text </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">– описание игры длиной в 450 символов</span> | ||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">Description2000, text </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">– описание игры длиной в 2000 символов</span> |
− | 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-ItalicMT;color:black">Description2000, text </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">– описание игры длиной в 2000 символов</span> | ||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">OrderUrl, varchar(255) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">– url на страницу покупки игры</span> |
− | 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-ItalicMT;color:black">OrderUrl, varchar(255) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">– url на страницу покупки игры</span> | ||
− | ''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | ''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">5) ala-xml-related </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">– связи между играми</span> |
− | TimesNewRomanPS-ItalicMT;color:black">5) ala-xml-related </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPSMT;color:black">– связи между играми</span> | ||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">ItemID, int(11) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">– идентификатор игры</span> |
− | 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-ItalicMT;color:black">ItemID, int(11) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">– идентификатор игры</span> | ||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">RelatedID, int(11) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">– идентификатор связанной игры</span> |
− | 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-ItalicMT;color:black">RelatedID, int(11) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">– идентификатор связанной игры</span> | ||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">Code, varchar(20) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">– тип связи, возможные значения:</span> |
− | 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-ItalicMT;color:black">Code, varchar(20) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">– тип связи, возможные значения:</span> | ||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">– </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">series</span>''<span style="font-size: 12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; color:black">, - связь между играми одной линейки</span> |
− | 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">– </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-ItalicMT;color:black">series</span>''<span style="font-size: | ||
− | 12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; | ||
− | color:black">, - связь между играми одной линейки</span> | ||
− | <span lang="EN-US" style="font-size:12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol; | + | <span lang="EN-US" style="font-size:12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol; color:black;mso-ansi-language:EN-US">– </span>''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black;mso-ansi-language:EN-US">pal</span>''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black;mso-ansi-language:EN-US">, - People Also Like</span> |
− | color:black;mso-ansi-language:EN-US">– </span>''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-ItalicMT;color:black;mso-ansi-language:EN-US">pal</span>''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black;mso-ansi-language:EN-US">, - People Also Like</span> | ||
− | <span lang="EN-US" style="font-size:12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol; | + | <span lang="EN-US" style="font-size:12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol; color:black;mso-ansi-language:EN-US">– </span>''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black;mso-ansi-language:EN-US">onlinegames</span>''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black;mso-ansi-language:EN-US">, - </span><span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">флеш</span><span style="font-size:12.0pt; font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; color:black;mso-ansi-language:EN-US"> </span><span style="font-size:12.0pt; font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; color:black">версия</span><span lang="EN-US" style="font-size:12.0pt;font-family: TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT;color:black; mso-ansi-language:EN-US"> pc </span><span style="font-size:12.0pt;font-family: TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT;color:black">игры</span> |
− | color:black;mso-ansi-language:EN-US">– </span>''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-ItalicMT;color:black;mso-ansi-language:EN-US">onlinegames</span>''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black;mso-ansi-language:EN-US">, - </span><span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">флеш</span><span style="font-size:12.0pt; | ||
− | font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; | ||
− | color:black;mso-ansi-language:EN-US"> </span><span style="font-size:12.0pt; | ||
− | font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; | ||
− | color:black">версия</span><span lang="EN-US" style="font-size:12.0pt;font-family: | ||
− | TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT;color:black; | ||
− | mso-ansi-language:EN-US"> pc </span><span style="font-size:12.0pt;font-family: | ||
− | TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT;color:black">игры</span> | ||
− | <span lang="EN-US" style="font-size:12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol; | + | <span lang="EN-US" style="font-size:12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol; color:black;mso-ansi-language:EN-US">– </span>''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black;mso-ansi-language:EN-US">casualpcgames</span>''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black;mso-ansi-language:EN-US">, - pc </span><span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">версия</span><span style="font-size:12.0pt; font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; color:black;mso-ansi-language:EN-US"> </span><span style="font-size:12.0pt; font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; color:black">флеш</span><span style="font-size:12.0pt;font-family:TimesNewRomanPSMT; mso-bidi-font-family:TimesNewRomanPSMT;color:black;mso-ansi-language:EN-US"> </span><span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">игры</span> |
− | color:black;mso-ansi-language:EN-US">– </span>''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-ItalicMT;color:black;mso-ansi-language:EN-US">casualpcgames</span>''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black;mso-ansi-language:EN-US">, - pc </span><span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">версия</span><span style="font-size:12.0pt; | ||
− | font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; | ||
− | color:black;mso-ansi-language:EN-US"> </span><span style="font-size:12.0pt; | ||
− | font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; | ||
− | color:black">флеш</span><span style="font-size:12.0pt;font-family:TimesNewRomanPSMT; | ||
− | mso-bidi-font-family:TimesNewRomanPSMT;color:black;mso-ansi-language:EN-US"> </span><span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">игры</span> | ||
− | <span lang="EN-US" style="font-size:12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol; | + | <span lang="EN-US" style="font-size:12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol; color:black;mso-ansi-language:EN-US">• </span>''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black;mso-ansi-language:EN-US">Weight, int(11) </span>''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black;mso-ansi-language:EN-US">– </span><span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">вес</span><span style="font-size:12.0pt; font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; color:black;mso-ansi-language:EN-US"> </span><span style="font-size:12.0pt; font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; color:black">связи</span> |
− | color:black;mso-ansi-language:EN-US">• </span>''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-ItalicMT;color:black;mso-ansi-language:EN-US">Weight, int(11) </span>''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black;mso-ansi-language:EN-US">– </span><span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">вес</span><span style="font-size:12.0pt; | ||
− | font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; | ||
− | color:black;mso-ansi-language:EN-US"> </span><span style="font-size:12.0pt; | ||
− | font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; | ||
− | color:black">связи</span> | ||
− | ''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | ''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black;mso-ansi-language:EN-US">6) |
− | TimesNewRomanPS-ItalicMT;color:black;mso-ansi-language:EN-US">6) | + | ala-xml-screenshots </span>''''<span lang="EN-US" style="font-size:12.0pt; font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; color:black;mso-ansi-language:EN-US">– </span><span style="font-size:12.0pt; font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; color:black">скриншоты</span><span style="font-size:12.0pt;font-family:TimesNewRomanPSMT; mso-bidi-font-family:TimesNewRomanPSMT;color:black;mso-ansi-language:EN-US"> </span><span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">игр</span>'' |
− | ala-xml-screenshots </span>''<span lang="EN-US" style="font-size:12.0pt; | + | |
− | font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; | ||
− | color:black;mso-ansi-language:EN-US">– </span><span style="font-size:12.0pt; | ||
− | font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; | ||
− | color:black">скриншоты</span><span style="font-size:12.0pt;font-family:TimesNewRomanPSMT; | ||
− | mso-bidi-font-family:TimesNewRomanPSMT;color:black;mso-ansi-language:EN-US"> </span><span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">игр</span> | ||
− | <span lang="EN-US" style="font-size:12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol; | + | <span lang="EN-US" style="font-size:12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol; color:black;mso-ansi-language:EN-US">• </span>''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black;mso-ansi-language:EN-US">ItemID, int(11) </span>''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black;mso-ansi-language:EN-US">– </span><span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">идентификатор</span><span style="font-size:12.0pt; font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; color:black;mso-ansi-language:EN-US"> </span><span style="font-size:12.0pt; font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; color:black">игры</span> |
− | color:black;mso-ansi-language:EN-US">• </span>''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-ItalicMT;color:black;mso-ansi-language:EN-US">ItemID, int(11) </span>''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black;mso-ansi-language:EN-US">– </span><span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">идентификатор</span><span style="font-size:12.0pt; | ||
− | font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; | ||
− | color:black;mso-ansi-language:EN-US"> </span><span style="font-size:12.0pt; | ||
− | font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; | ||
− | color:black">игры</span> | ||
− | <span lang="EN-US" style="font-size:12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol; | + | <span lang="EN-US" style="font-size:12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol; color:black;mso-ansi-language:EN-US">• </span>''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black;mso-ansi-language:EN-US">ScreenshotID, |
− | color:black;mso-ansi-language:EN-US">• </span>''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | int(11) </span>''''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPSMT; mso-bidi-font-family:TimesNewRomanPSMT;color:black;mso-ansi-language:EN-US">– </span><span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">идентификатор</span><span style="font-size:12.0pt; font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; color:black;mso-ansi-language:EN-US"> </span><span style="font-size:12.0pt; font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; color:black">скриншота</span>'' |
− | TimesNewRomanPS-ItalicMT;color:black;mso-ansi-language:EN-US">ScreenshotID, | + | |
− | int(11) </span>''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPSMT; | ||
− | mso-bidi-font-family:TimesNewRomanPSMT;color:black;mso-ansi-language:EN-US">– </span><span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">идентификатор</span><span style="font-size:12.0pt; | ||
− | font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; | ||
− | color:black;mso-ansi-language:EN-US"> </span><span style="font-size:12.0pt; | ||
− | font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; | ||
− | color:black">скриншота</span> | ||
− | <span lang="EN-US" style="font-size:12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol; | + | <span lang="EN-US" style="font-size:12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol; color:black;mso-ansi-language:EN-US">• </span>''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black;mso-ansi-language:EN-US">Type, varchar(20) |
− | color:black;mso-ansi-language:EN-US">• </span>''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | </span>''''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPSMT; mso-bidi-font-family:TimesNewRomanPSMT;color:black;mso-ansi-language:EN-US">– </span><span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">типа</span><span style="font-size:12.0pt; font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; color:black;mso-ansi-language:EN-US"> </span><span style="font-size:12.0pt; font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; color:black">скриншота</span>'' |
− | TimesNewRomanPS-ItalicMT;color:black;mso-ansi-language:EN-US">Type, varchar(20) | + | |
− | </span>''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPSMT; | ||
− | mso-bidi-font-family:TimesNewRomanPSMT;color:black;mso-ansi-language:EN-US">– </span><span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">типа</span><span style="font-size:12.0pt; | ||
− | font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; | ||
− | color:black;mso-ansi-language:EN-US"> </span><span style="font-size:12.0pt; | ||
− | font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; | ||
− | color:black">скриншота</span> | ||
− | <span lang="EN-US" style="font-size:12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol; | + | <span lang="EN-US" style="font-size:12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol; color:black;mso-ansi-language:EN-US">• </span>''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black;mso-ansi-language:EN-US">Width, int(11) </span>''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black;mso-ansi-language:EN-US">– </span><span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">ширина</span><span style="font-size:12.0pt; font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; color:black;mso-ansi-language:EN-US"> </span><span style="font-size:12.0pt; font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; color:black">скриншота</span> |
− | color:black;mso-ansi-language:EN-US">• </span>''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-ItalicMT;color:black;mso-ansi-language:EN-US">Width, int(11) </span>''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black;mso-ansi-language:EN-US">– </span><span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">ширина</span><span style="font-size:12.0pt; | ||
− | font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; | ||
− | color:black;mso-ansi-language:EN-US"> </span><span style="font-size:12.0pt; | ||
− | font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; | ||
− | color:black">скриншота</span> | ||
− | <span lang="EN-US" style="font-size:12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol; | + | <span lang="EN-US" style="font-size:12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol; color:black;mso-ansi-language:EN-US">• </span>''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black;mso-ansi-language:EN-US">Height, int(11) </span>''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black;mso-ansi-language:EN-US">– </span><span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">высота</span><span style="font-size:12.0pt; font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; color:black;mso-ansi-language:EN-US"> </span><span style="font-size:12.0pt; font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; color:black">скриншота</span> |
− | color:black;mso-ansi-language:EN-US">• </span>''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | |
− | TimesNewRomanPS-ItalicMT;color:black;mso-ansi-language:EN-US">Height, int(11) </span>''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black;mso-ansi-language:EN-US">– </span><span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">высота</span><span style="font-size:12.0pt; | ||
− | font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; | ||
− | color:black;mso-ansi-language:EN-US"> </span><span style="font-size:12.0pt; | ||
− | font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; | ||
− | color:black">скриншота</span> | ||
− | <span lang="EN-US" style="font-size:12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol; | + | <span lang="EN-US" style="font-size:12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol; color:black;mso-ansi-language:EN-US">• </span>''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black;mso-ansi-language:EN-US">Timestamp, |
− | color:black;mso-ansi-language:EN-US">• </span>''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | + | int(11) </span>''''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPSMT; mso-bidi-font-family:TimesNewRomanPSMT;color:black;mso-ansi-language:EN-US">– |
− | TimesNewRomanPS-ItalicMT;color:black;mso-ansi-language:EN-US">Timestamp, | + | unix-timestamp </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT; mso-bidi-font-family:TimesNewRomanPSMT;color:black">даты</span><span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black;mso-ansi-language:EN-US"> </span><span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">последней</span><span style="font-size:12.0pt; font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; color:black;mso-ansi-language:EN-US"> </span><span style="font-size:12.0pt; font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; color:black">модификации</span><span style="font-size:12.0pt;font-family:TimesNewRomanPSMT; mso-bidi-font-family:TimesNewRomanPSMT;color:black;mso-ansi-language:EN-US"> </span><span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">скриншота</span> |
− | int(11) </span>''<span lang="EN-US" style="font-size:12.0pt;font-family:TimesNewRomanPSMT; | + | |
− | mso-bidi-font-family:TimesNewRomanPSMT;color:black;mso-ansi-language:EN-US">– | ||
− | unix-timestamp </span><span style="font-size:12.0pt;font-family:TimesNewRomanPSMT; | ||
− | mso-bidi-font-family:TimesNewRomanPSMT;color:black">даты</span><span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black;mso-ansi-language:EN-US"> </span><span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">последней</span><span style="font-size:12.0pt; | ||
− | font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; | ||
− | color:black;mso-ansi-language:EN-US"> </span><span style="font-size:12.0pt; | ||
− | font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; | ||
− | color:black">модификации</span><span style="font-size:12.0pt;font-family:TimesNewRomanPSMT; | ||
− | mso-bidi-font-family:TimesNewRomanPSMT;color:black;mso-ansi-language:EN-US"> </span><span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">скриншота</span> | ||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: TimesNewRomanPS-ItalicMT;color:black">Url, varchar(255) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">– url скриншота</span>'''<span lang="EN-US" style="font-size:12.0pt;mso-bidi-font-family:TimesNewRomanPS-BoldMT;color:black; mso-ansi-language:EN-US" />''' |
− | 12.0pt;font-family:OpenSymbol;mso-bidi-font-family:OpenSymbol;color:black">• </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-ItalicMT;mso-bidi-font-family: | ||
− | TimesNewRomanPS-ItalicMT;color:black">Url, varchar(255) </span>''<span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">– url скриншота</span> | ||
− | + | | |
− | |||
− | '''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-BoldMT;mso-bidi-font-family: | + | '''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-BoldMT;mso-bidi-font-family: TimesNewRomanPS-BoldMT;color:black">Требования</span>''' |
− | TimesNewRomanPS-BoldMT;color:black">Требования</span>''' | + | |
− | '''<span lang="EN-US" style="font-size:12.0pt;mso-bidi-font-family:TimesNewRomanPS-BoldMT;color:black; | + | '''<span lang="EN-US" style="font-size:12.0pt;mso-bidi-font-family:TimesNewRomanPS-BoldMT;color:black; mso-ansi-language:EN-US" />''' |
− | mso-ansi-language:EN-US" | ||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; color:black">Для корректной работы программы необходимы PHP >= 4.3.0, PHP 5, |
− | 12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; | ||
− | color:black">Для корректной работы программы необходимы PHP >= 4.3.0, PHP 5, | ||
MySQL.</span> | MySQL.</span> | ||
+ | |||
− | '''<span lang="EN-US" style="font-size:12.0pt;mso-bidi-font-family:TimesNewRomanPS-BoldMT;color:black; | + | '''<span lang="EN-US" style="font-size:12.0pt;mso-bidi-font-family:TimesNewRomanPS-BoldMT;color:black; mso-ansi-language:EN-US" />''' |
− | mso-ansi-language:EN-US" | ||
− | '''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-BoldMT;mso-bidi-font-family: | + | '''<span style="font-size:12.0pt;font-family:TimesNewRomanPS-BoldMT;mso-bidi-font-family: TimesNewRomanPS-BoldMT;color:black">О программе</span>''' |
− | TimesNewRomanPS-BoldMT;color:black">О программе</span>''' | + | |
− | + | | |
− | |||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; color:black">Данная программа предназначена для участников партнерской программы |
− | 12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; | ||
− | color:black">Данная программа предназначена для участников партнерской программы | ||
Алавар</span> | Алавар</span> | ||
+ | |||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; color:black">(</span><span style="font-size:12.0pt;font-family:TimesNewRomanPSMT; mso-bidi-font-family:TimesNewRomanPSMT;color:#000081">http://partner.alawar.ru</span><span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: TimesNewRomanPSMT;color:black">), и является инструментом обработки формата экспорта |
− | 12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; | ||
− | color:black">(</span><span style="font-size:12.0pt;font-family:TimesNewRomanPSMT; | ||
− | mso-bidi-font-family:TimesNewRomanPSMT;color:#000081">http://partner.alawar.ru</span><span style="font-size:12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family: | ||
− | TimesNewRomanPSMT;color:black">), и является инструментом обработки формата экспорта | ||
игрового</span> | игрового</span> | ||
+ | |||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; color:black">контента. Основная функция программы – синхронизация игровой базы данных |
− | 12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; | ||
− | color:black">контента. Основная функция программы – синхронизация игровой базы данных | ||
Алавар с базой</span> | Алавар с базой</span> | ||
+ | |||
− | <span style="font-size: | + | <span style="font-size: 12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; color:black">данных участника партнерской программы.</span> |
− | 12.0pt;font-family:TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT; | + | |
− | color:black">данных участника партнерской программы.</span> | ||
− | <span style="font-size:12.0pt;line-height:115%;font-family: | + | <span style="font-size:12.0pt;line-height:115%;font-family: TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT;color:black" /> |
− | TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT;color:black">Copyright | + | |
+ | <span style="font-size:12.0pt;line-height:115%;font-family: TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT;color:black">Copyright | ||
© 2010 Alawar Entertainment, Inc.</span> | © 2010 Alawar Entertainment, Inc.</span> | ||
− | <br> | + | <br> |
Версия 10:19, 4 мая 2010
Название
<span style="font-size:12.0pt;mso-bidi-font-family:TimesNewRomanPS-BoldMT;color:black" />
alawar_xml_parser.php – инструмент для парсинга партнерского XML Алавар.
<span lang="EN-US" style="font-size:12.0pt;mso-bidi-font-family:TimesNewRomanPS-BoldMT;color:black; mso-ansi-language:EN-US" />
Синтаксис
<span style="font-size:12.0pt;mso-bidi-font-family:TimesNewRomanPS-BoldMT;color:black" />
alawar_xml_parser.php --pid=pid –dbhost=dbhost –dbuser=dbuser –dbpass=dbpass –
dbname=dbname [recreatetables | fetch]
<span lang="EN-US" style="font-size:12.0pt;mso-bidi-font-family:TimesNewRomanPS-BoldMT;color:black; mso-ansi-language:EN-US" />
Информация
alawar_xml_parser.php – инструмент для разбора XML партнерской программы Алавар.
Позволяет разобрать данные отгружаемые партнерам и вставить их в структуру
таблиц
MySQL. Строит следующие таблицы БД:
1) ala-xml-dictionaries, для словарей жанров и рейтинов
2) ala-xml-files, для информации о файлах игр
3) ala-xml-images, для информации о графике игр
4) ala-xml-items, для информации об играх
5) ala-xml-related, для хранения связей между играми
6) ala-xml-screenshots, для информации о скриншотах игр
Примеры
./alawar_xml_parser.php –dbhost=localhost –dbuser=root –dbpass=pwd –dbname=mydb
recreatetables
Выполнит соединение с сервером MySQL и пересоздаст структуру таблиц
для хранения
данных партнерского XML. В случае если указанные таблицы уже существуют
они будут
созданы заново и данные, хранящиеся в них, будут стерты.
./alawar_xml_parser.php
–pid=1234 –dbhost=localhost –dbuser=root –dbpass=pwd –
dbname=mydb fetch
Выполнит соединение с сервером MySQL, закачает партнерский XML с сервера
export.alawar.ru?pid=1234, и обновит данные в таблицах.
Опции
–pid – Идентификатор партнера
–dbhost – Хост сервера MySQL
–dbuser – Имя учетной записи для подключения к серверу
MySQL
–dbpass – Пароль учетной записи для подключения к серверу
MySQL
–dbname – Имя базы данных
recreatetables – Пересоздает таблицы базы данных
fetch – Закачивает партнерский XML и обновляет данные в базе
'Структура таблиц'<span lang="EN-US" style="font-size:12.0pt;mso-bidi-font-family:TimesNewRomanPS-BoldMT;color:black; mso-ansi-language:EN-US" />
Поля таблиц соответствуют значениям и аттрибутам элементов XML.
1)
ala-xml-dictionaries – ''жанры и рейтинги
• Catalog, varchar(20) – код каталога, возможные значения:
– casualpcgames, - pc игры
– onlinegames, - флеш игры
• DictionaryCode, varchar(20) – код списка словарей, возможные значения:
– all-games, - все игры
– Genre, - игры разбитые по жанрам
– Rating, - рейтинги игр
• DictionaryItemCode,
varchar(20) ''– код словаря
• DictionaryItemName,
varchar(255) ''– название словаря
• Element, int(11) – идентификатор игры
• Value, int(11) – значение игры в данном словаре
2) ala-xml-files – дистрибутивы игр
• ItemID, int(11) – идентфикатор игры
• Type, varchar(20) – тип файла, возможные значения:
– distrib – дистрибутив игры
• Timestamp, int(11) – unix-timestamp даты последней модификации файла
• Name, varchar(255) – имя файла
• Size, varchar(20) – размер файла, строка для отображения, например
13Mb
• Url, varchar(255) – url файла
3) ala-xml-images – графика игр
• ItemID, int(11) – идентфикатор игры
• Type, varchar(20) – тип графики, возможные значения:
– icon44x44, - иконка размером 44 на 44 на белом фоне
– icon44x44bg, - иконка размером 44 на 44 с фоном
– icon100x100, - иконка размером 100 на 100 на белом фоне
– icon100x100bg, - иконка размером 100 на 100 с фоном
– logo190x140, - логотип игры размером 190 на 140
– banner586x152, - баннер игры размером 586 на 152
• Width,
varchar(20) ''– ширина
• Height,
varchar(255) ''– высота
• Timestamp, int(11) – unix-timestamp даты последней модификации графического
файла
• Url, int(11) – url графического файла
4) ala-xml-items – игры
• ID, int(11) – идентфикатор игры
• Catalog, varchar(20) – код каталога
• Language, varchar(2) – код языка экспорта
• Name, varchar(255) – название игры
• SymbolCode, varchar(255) – url-безопасный символьный код игры
• Locale, varchar(2) – локализация игры
• ReleaseDate, date – дата выхода игры
• Width, int(11) – рекомендуемая ширина страницы с флеш игрой
• Height, int(11) – рекомендуемая высота страницы с флеш игрой
• SwfWidth, int(11) – ширина флеш игры
• SwfHeight, int(11) – высота флеш игры
• PageUrl, varchar(255) – url на страницу с флеш игрой
• Embed, text – html-тэг embed для включения флеш игры на произвольную
страницу
• Description45, varchar(45) – описание игры длиной в 45 символов
• Description80, varchar(80) – описание игры длиной в 80 символов
• Description450, text – описание игры длиной в 450 символов
• Description2000, text – описание игры длиной в 2000 символов
• OrderUrl, varchar(255) – url на страницу покупки игры
5) ala-xml-related – связи между играми
• ItemID, int(11) – идентификатор игры
• RelatedID, int(11) – идентификатор связанной игры
• Code, varchar(20) – тип связи, возможные значения:
– series, - связь между играми одной линейки
– pal, - People Also Like
– onlinegames, - флеш версия pc игры
– casualpcgames, - pc версия флеш игры
• Weight, int(11) – вес связи
6)
ala-xml-screenshots ''– скриншоты игр
• ItemID, int(11) – идентификатор игры
• ScreenshotID,
int(11) ''– идентификатор скриншота
• Type, varchar(20)
''– типа скриншота
• Width, int(11) – ширина скриншота
• Height, int(11) – высота скриншота
• Timestamp,
int(11) '–
unix-timestamp даты последней модификации скриншота
• Url, varchar(255) – url скриншота<span lang="EN-US" style="font-size:12.0pt;mso-bidi-font-family:TimesNewRomanPS-BoldMT;color:black; mso-ansi-language:EN-US" />
Требования
<span lang="EN-US" style="font-size:12.0pt;mso-bidi-font-family:TimesNewRomanPS-BoldMT;color:black; mso-ansi-language:EN-US" />
Для корректной работы программы необходимы PHP >= 4.3.0, PHP 5, MySQL.
<span lang="EN-US" style="font-size:12.0pt;mso-bidi-font-family:TimesNewRomanPS-BoldMT;color:black; mso-ansi-language:EN-US" />
О программе
Данная программа предназначена для участников партнерской программы Алавар
(http://partner.alawar.ru), и является инструментом обработки формата экспорта
игрового
контента. Основная функция программы – синхронизация игровой базы данных
Алавар с базой
данных участника партнерской программы.
<span style="font-size:12.0pt;line-height:115%;font-family: TimesNewRomanPSMT;mso-bidi-font-family:TimesNewRomanPSMT;color:black" />
Copyright © 2010 Alawar Entertainment, Inc.