Фотоархив

Источник: Личный архив О. С. Козлова

1983.

db_connect() getQueryParam(): id=486 mysql_query: SELECT id FROM addr where ip='18.216.123.120';
getRow(): SELECT id FROM addr where ip='18.216.123.120'; result: OK mysql_query: SELECT mode FROM addr where id='1021234';
getValue(): SELECT mode FROM addr where id='1021234'; result: OK User not logged in or cookies disabled Addr_id: 1021234; Addr_mode: 1 case ADDR_TESTING mysql_query: SELECT time FROM addr where id='1021234';
getValue(): SELECT time FROM addr where id='1021234'; result: OK Cookies disabled mysql_query: UPDATE addr SET mode='2' WHERE id = 1021234;
setValue(): UPDATE addr SET mode='2' WHERE id = 1021234; result: OK URI: /foto/?id=486 Script: /foto/index.php Query: ID=486 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: INSERT INTO `blob` (`key`, `value`) VALUES ('vkCache', '1713589684.405206');
lockVkCache(1): INSERT INTO `blob` (`key`, `value`) VALUES ('vkCache', '1713589684.405206'); result: OK mysql_query: SELECT userId FROM vkSources WHERE exclude=0 ORDER BY lastRead LIMIT 1;
getRow(): SELECT userId FROM vkSources WHERE exclude=0 ORDER BY lastRead LIMIT 1; result: OK Getting posts for user 2786097. vk.api method: wall.get mysql_query: SELECT `value` FROM `blob` WHERE `key` = 'vk'
getRow(): SELECT `value` FROM `blob` WHERE `key` = 'vk' result: OK Checking vk access token... Expired vk access token missing or expiredmysql_query: UPDATE vkSources SET lastRead=1713589682, state='no updates (0 old posts)', exclude=0 WHERE userId=2786097;
cacheVkPost(): UPDATE vkSources SET lastRead=1713589682, state='no updates (0 old posts)', exclude=0 WHERE userId=2786097; result: OK mysql_query: DELETE FROM `blob` WHERE `key` = 'vkCache';
lockVkCache(): DELETE FROM `blob` WHERE `key` = 'vkCache'; result: OK mysql_query: SELECT foto.* FROM foto WHERE id = 486 ORDER BY sdate, foto.id;
getDivAdv(): SELECT foto.* FROM foto WHERE id = 486 ORDER BY sdate, foto.id; result: OK mysql_query: SELECT person.id, lname, fname, mname, pre, name, post FROM foto2person, person WHERE foto2person.id = 486 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 = 486 AND foto2person.person_id=person.id AND 0 >= person.rights ORDER BY ord; result: OK mysql_query: SELECT * FROM foto2source WHERE id=486;
getSources(): SELECT * FROM foto2source WHERE id=486; result: OK mysql_query: SELECT * FROM link WHERE type <> 'a' AND id=0
getRow(): SELECT * FROM link WHERE type <> 'a' AND id=0 result: OK mysql_query: SELECT person.id, lname, fname, mname, pre, name, post FROM foto2person, person WHERE foto2person.id = 486 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 = 486 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 = 486;
getMaterials4foto(): SELECT material.href, material.title FROM material, foto2material WHERE foto2material.material_id = material.id AND foto2material.id = 486; result: OK getQueryParam(): id=486 mysql_query: SELECT series.* FROM series, foto2series WHERE series.id = foto2series.series_id AND foto2series.id = 486;
getSeeAlsoSeries(): SELECT series.* FROM series, foto2series WHERE series.id = foto2series.series_id AND foto2series.id = 486; result: OK mysql_query: SELECT id FROM uri where uri='/foto/?id=486';
getRow(): SELECT id FROM uri where uri='/foto/?id=486'; result: OK mysql_query: SELECT COUNT(*) from user where creation_time > '1713503283';
getDateCounter(): SELECT COUNT(*) from user where creation_time > '1713503283'; result: OK