Предложения спонсоров «Капелланина»: |
debug info
db_connect()
getRow(): SELECT id FROM addr where ip='18.232.31.206'; result: OK
getValue(): SELECT mode FROM addr where id='911086'; result: OK
getRow(): SELECT id FROM addr where ip='18.232.31.206'; result: OK
getValue(): SELECT mode FROM addr where id='911086'; result: OK
User not logged in or cookies disabled
Addr_id: 911086; Addr_mode: 1
case ADDR_TESTING
getValue(): SELECT time FROM addr where id='911086'; result: OK
Cookies disabled
setValue(): UPDATE addr SET mode='2' WHERE id = 911086; result: OK
getQueryParam(): id=644
getRow(): SELECT * FROM person WHERE id=644 AND 0 >= person.rights; result: OK
getRow(): SELECT byear, ddate, dmonth, dyear FROM person WHERE id = 644; result: OK
getRow(): SELECT * FROM person WHERE id = 644 AND 0 >= rights; result: OK
getAcademInfo(): SELECT * FROM person2course WHERE person=644; result: OK
getRelatives4Person: SELECT id, lname, fname, mname, type FROM person, person2person WHERE id2=id AND id1=644 AND 0 >= rights order by start; result: OK
getActivities(): SELECT * FROM activity WHERE person_id = 644; result: OK
getRelatives4Person: SELECT id, lname, fname, mname, type FROM person, person2person WHERE id1=id AND id2=644 AND 0 >= rights order by lname, fname, mname; result: OK
getEvents4Person(): SELECT event.* FROM person2event, event WHERE person=644 AND event.id=person2event.event AND sdate >= '2023-1-27' GROUP BY event.id ORDER BY sdate ASC; result: OK
getEvents4Person(): SELECT event.* FROM person2event, event WHERE person=644 AND event.id=person2event.event AND sdate < '2023-1-27' GROUP BY event.id ORDER BY sdate DESC; result: OK
getMaterials4Person(): SELECT material_id FROM person2material WHERE person2material.id=644 ORDER BY type DESC; result: OK
getSources(): SELECT * FROM person2source WHERE id=644; result: OK
getThumbnails4Person(): SELECT id FROM foto2person WHERE foto2person.person_id = 644; result: OK
getThumbnails4Person(): SELECT * FROM foto WHERE id in (179, 279, 283, 822, 1395, 1526, 1527, 1528, 1529) ORDER BY sdate, id; result: OK
getPeople(): SELECT person.id, lname, fname, mname, pre, name, post FROM foto2person, person WHERE foto2person.id = 1526 AND foto2person.person_id=person.id AND 0 >= person.rights ORDER BY ord; result: OK
getPeople(): SELECT person.id, lname, fname, mname, pre, name, post FROM foto2person, person WHERE foto2person.id = 1527 AND foto2person.person_id=person.id AND 0 >= person.rights ORDER BY ord; result: OK
getPeople(): SELECT person.id, lname, fname, mname, pre, name, post FROM foto2person, person WHERE foto2person.id = 1528 AND foto2person.person_id=person.id AND 0 >= person.rights ORDER BY ord; result: OK
getPeople(): SELECT person.id, lname, fname, mname, pre, name, post FROM foto2person, person WHERE foto2person.id = 1529 AND foto2person.person_id=person.id AND 0 >= person.rights ORDER BY ord; result: OK
getPeople(): SELECT person.id, lname, fname, mname, pre, name, post FROM foto2person, person WHERE foto2person.id = 179 AND foto2person.person_id=person.id AND 0 >= person.rights ORDER BY ord; result: OK
getPeople(): SELECT person.id, lname, fname, mname, pre, name, post FROM foto2person, person WHERE foto2person.id = 283 AND foto2person.person_id=person.id AND 0 >= person.rights ORDER BY ord; result: OK
getPeople(): SELECT person.id, lname, fname, mname, pre, name, post FROM foto2person, person WHERE foto2person.id = 279 AND foto2person.person_id=person.id AND 0 >= person.rights ORDER BY ord; result: OK
getPeople(): SELECT person.id, lname, fname, mname, pre, name, post FROM foto2person, person WHERE foto2person.id = 822 AND foto2person.person_id=person.id AND 0 >= person.rights ORDER BY ord; result: OK
getPeople(): SELECT person.id, lname, fname, mname, pre, name, post FROM foto2person, person WHERE foto2person.id = 1395 AND foto2person.person_id=person.id AND 0 >= person.rights ORDER BY ord; result: OK
printContactInfo(): SELECT * FROM contacts4person WHERE id = 644 ORDER BY type; result: OK
getRow(): SELECT * FROM person WHERE id=644 AND 0 >= person.rights; result: OK
getRow(): SELECT id FROM uri where uri='/id644'; result: OK
getDateCounter(): SELECT COUNT(*) from user where creation_time > '1674699377'; result: OK
error log