Источник: Личный архив В. А. Чернушенко
Предыдущий кадр | Комментарии | Следующий кадр
| |
© Пётр Трубинов, 2004–2024. |
888 |
Предложения спонсоров «Капелланина»: |
db_connect() getQueryParam(): id=997 getQueryParam(): sort=sdate getQueryParam(): person=9 mysql_query: SELECT id FROM addr where ip='18.116.43.119';error log
getRow(): SELECT id FROM addr where ip='18.116.43.119'; result: OK mysql_query: SELECT mode FROM addr where id='1020380';
getValue(): SELECT mode FROM addr where id='1020380'; result: OK User not logged in or cookies disabled Addr_id: 1020380; Addr_mode: 1 case ADDR_TESTING mysql_query: SELECT time FROM addr where id='1020380';
getValue(): SELECT time FROM addr where id='1020380'; result: OK Cookies disabled mysql_query: UPDATE addr SET mode='2' WHERE id = 1020380;
setValue(): UPDATE addr SET mode='2' WHERE id = 1020380; result: OK URI: /foto/?id=997&person=9&sort=sdate Script: /foto/index.php Query: ID=997&PERSON=9&SORT=SDATE 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', '1713405962.391306');
lockVkCache(1): INSERT INTO `blob` (`key`, `value`) VALUES ('vkCache', '1713405962.391306'); 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 -147188. 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... Valid. Expires 2024-04-18 07:27:50 Got 10. mysql_query: SELECT id FROM vkCache WHERE userId='-147188' AND postId='4383'
getRow(): SELECT id FROM vkCache WHERE userId='-147188' AND postId='4383' result: OK mysql_query: INSERT INTO vkSources (userId, lastRead, exclude) VALUES (-147188, 1713405960, 0) ON DUPLICATE KEY UPDATE lastRead=1713405960;
addUser(): INSERT INTO vkSources (userId, lastRead, exclude) VALUES (-147188, 1713405960, 0) ON DUPLICATE KEY UPDATE lastRead=1713405960; result: OK mysql_query: UPDATE vkSources SET lastRead=1713405960, state='no updates (10 old posts)', exclude=0 WHERE userId=-147188;
cacheVkPost(): UPDATE vkSources SET lastRead=1713405960, state='no updates (10 old posts)', exclude=0 WHERE userId=-147188; 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, foto2person WHERE foto.id = foto2person.id AND foto2person.person_id=9 ORDER BY sdate, foto.id;
getDivAdv(): SELECT foto.* FROM foto, foto2person WHERE foto.id = foto2person.id AND foto2person.person_id=9 ORDER BY sdate, foto.id; result: OK mysql_query: SELECT person.id, lname, fname, mname, pre, name, post FROM foto2person, person WHERE foto2person.id = 1965 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 = 1965 AND foto2person.person_id=person.id AND 0 >= person.rights ORDER BY ord; result: OK mysql_query: SELECT person.id, lname, fname, mname, pre, name, post FROM foto2person, person WHERE foto2person.id = 875 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 = 875 AND foto2person.person_id=person.id AND 0 >= person.rights ORDER BY ord; result: OK mysql_query: SELECT person.id, lname, fname, mname, pre, name, post FROM foto2person, person WHERE foto2person.id = 5630 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 = 5630 AND foto2person.person_id=person.id AND 0 >= person.rights ORDER BY ord; result: OK mysql_query: SELECT person.id, lname, fname, mname, pre, name, post FROM foto2person, person WHERE foto2person.id = 153 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 = 153 AND foto2person.person_id=person.id AND 0 >= person.rights ORDER BY ord; result: OK mysql_query: SELECT person.id, lname, fname, mname, pre, name, post FROM foto2person, person WHERE foto2person.id = 222 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 = 222 AND foto2person.person_id=person.id AND 0 >= person.rights ORDER BY ord; result: OK mysql_query: SELECT person.id, lname, fname, mname, pre, name, post FROM foto2person, person WHERE foto2person.id = 9052 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 = 9052 AND foto2person.person_id=person.id AND 0 >= person.rights ORDER BY ord; result: OK mysql_query: SELECT person.id, lname, fname, mname, pre, name, post FROM foto2person, person WHERE foto2person.id = 993 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 = 993 AND foto2person.person_id=person.id AND 0 >= person.rights ORDER BY ord; result: OK mysql_query: SELECT person.id, lname, fname, mname, pre, name, post FROM foto2person, person WHERE foto2person.id = 221 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 = 221 AND foto2person.person_id=person.id AND 0 >= person.rights ORDER BY ord; result: OK mysql_query: SELECT person.id, lname, fname, mname, pre, name, post FROM foto2person, person WHERE foto2person.id = 9055 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 = 9055 AND foto2person.person_id=person.id AND 0 >= person.rights ORDER BY ord; result: OK mysql_query: SELECT person.id, lname, fname, mname, pre, name, post FROM foto2person, person WHERE foto2person.id = 997 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 = 997 AND foto2person.person_id=person.id AND 0 >= person.rights ORDER BY ord; result: OK mysql_query: SELECT person.id, lname, fname, mname, pre, name, post FROM foto2person, person WHERE foto2person.id = 112 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 = 112 AND foto2person.person_id=person.id AND 0 >= person.rights ORDER BY ord; result: OK mysql_query: SELECT person.id, lname, fname, mname, pre, name, post FROM foto2person, person WHERE foto2person.id = 10 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 = 10 AND foto2person.person_id=person.id AND 0 >= person.rights ORDER BY ord; result: OK mysql_query: SELECT person.id, lname, fname, mname, pre, name, post FROM foto2person, person WHERE foto2person.id = 7827 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 = 7827 AND foto2person.person_id=person.id AND 0 >= person.rights ORDER BY ord; result: OK mysql_query: SELECT * FROM foto2source WHERE id=997;
getSources(): SELECT * FROM foto2source WHERE id=997; 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 = 997 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 = 997 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 = 997;
getMaterials4foto(): SELECT material.href, material.title FROM material, foto2material WHERE foto2material.material_id = material.id AND foto2material.id = 997; result: OK getQueryParam(): id=997 mysql_query: SELECT series.* FROM series, foto2series WHERE series.id = foto2series.series_id AND foto2series.id = 997;
getSeeAlsoSeries(): SELECT series.* FROM series, foto2series WHERE series.id = foto2series.series_id AND foto2series.id = 997; result: OK mysql_query: SELECT id FROM uri where uri='/foto/?id=997&person=9&sort=sdate';
getRow(): SELECT id FROM uri where uri='/foto/?id=997&person=9&sort=sdate'; result: OK mysql_query: SELECT COUNT(*) from user where creation_time > '1713319561';
getDateCounter(): SELECT COUNT(*) from user where creation_time > '1713319561'; result: OK