Фотоархив

8982. 15 мая 2017. Защита Д.Стефановича.

Владимир Абрамович Гуревич.

См. тажке: Защита Д.Стефановича 15.5.2017

db_connect() getQueryParam(): id=8982 mysql_query: SELECT id FROM addr where ip='18.116.239.195';
getRow(): SELECT id FROM addr where ip='18.116.239.195'; result: OK mysql_query: SELECT mode FROM addr where id='1020334';
getValue(): SELECT mode FROM addr where id='1020334'; result: OK User not logged in or cookies disabled Addr_id: 1020334; Addr_mode: 1 case ADDR_TESTING mysql_query: SELECT time FROM addr where id='1020334';
getValue(): SELECT time FROM addr where id='1020334'; result: OK Cookies disabled mysql_query: UPDATE addr SET mode='2' WHERE id = 1020334;
setValue(): UPDATE addr SET mode='2' WHERE id = 1020334; result: OK URI: /photo8982 Script: /foto/index.php Query: ID=8982 Referer: mysql_query: SELECT `value` FROM `blob` WHERE `key` = 'vkAutoCache'
getRow(): SELECT `value` FROM `blob` WHERE `key` = 'vkAutoCache' result: OK mysql_query: SELECT `value` FROM `blob` WHERE `key` = 'vkCache'
getRow(): SELECT `value` FROM `blob` WHERE `key` = 'vkCache' result: OK mysql_query: SELECT foto.* FROM foto WHERE id = 8982 ORDER BY sdate, foto.id;
getDivAdv(): SELECT foto.* FROM foto WHERE id = 8982 ORDER BY sdate, foto.id; result: OK mysql_query: SELECT person.id, lname, fname, mname, pre, name, post FROM foto2person, person WHERE foto2person.id = 8982 AND foto2person.person_id=person.id AND 0 >= person.rights ORDER BY ord;
getPeople(): SELECT person.id, lname, fname, mname, pre, name, post FROM foto2person, person WHERE foto2person.id = 8982 AND foto2person.person_id=person.id AND 0 >= person.rights ORDER BY ord; result: OK mysql_query: SELECT * FROM foto2source WHERE id=8982;
getSources(): SELECT * FROM foto2source WHERE id=8982; result: OK mysql_query: SELECT person.id, lname, fname, mname, pre, name, post FROM foto2person, person WHERE foto2person.id = 8982 AND foto2person.person_id=person.id AND 0 >= person.rights ORDER BY ord;
getPeople(): SELECT person.id, lname, fname, mname, pre, name, post FROM foto2person, person WHERE foto2person.id = 8982 AND foto2person.person_id=person.id AND 0 >= person.rights ORDER BY ord; result: OK mysql_query: SELECT material.href, material.title FROM material, foto2material WHERE foto2material.material_id = material.id AND foto2material.id = 8982;
getMaterials4foto(): SELECT material.href, material.title FROM material, foto2material WHERE foto2material.material_id = material.id AND foto2material.id = 8982; result: OK getQueryParam(): id=8982 mysql_query: SELECT series.* FROM series, foto2series WHERE series.id = foto2series.series_id AND foto2series.id = 8982;
getSeeAlsoSeries(): SELECT series.* FROM series, foto2series WHERE series.id = foto2series.series_id AND foto2series.id = 8982; result: OK mysql_query: SELECT id FROM uri where uri='/photo8982';
getRow(): SELECT id FROM uri where uri='/photo8982'; result: OK mysql_query: SELECT COUNT(*) from user where creation_time > '1713431543';
getDateCounter(): SELECT COUNT(*) from user where creation_time > '1713431543'; result: OK