===========================================================
.___ __ __
_________________ __ __ __| _/|__|/ |_
/ ___\_` __ \__ \ | | \/ __ | | \\_ __\
/ /_/ > | \// __ \| | / /_/ | | || |
\___ /|__| (____ /____/\____ | |__||__|
/_____/ \/ \/
grep rough audit - static analysis tool
v2.8 written by @Wireghoul
=================================[justanotherhacker.com]===
davical-1.1.9.3/htdocs/always.php-200-if ( @file_exists('/etc/davical/'.$_SERVER['SERVER_NAME'].'-conf.php') ) {
davical-1.1.9.3/htdocs/always.php:201: include('/etc/davical/'.$_SERVER['SERVER_NAME'].'-conf.php');
davical-1.1.9.3/htdocs/always.php-202-}
##############################################
davical-1.1.9.3/htdocs/always.php-206-else if ( @file_exists('/usr/local/etc/davical/'.$_SERVER['SERVER_NAME'].'-conf.php') ) {
davical-1.1.9.3/htdocs/always.php:207: include('/usr/local/etc/davical/'.$_SERVER['SERVER_NAME'].'-conf.php');
davical-1.1.9.3/htdocs/always.php-208-}
##############################################
davical-1.1.9.3/htdocs/always.php-309-$qry = new AwlQuery( 'SELECT schema_major, schema_minor, schema_patch FROM awl_db_revision ORDER BY schema_id DESC LIMIT 1;' );
davical-1.1.9.3/htdocs/always.php:310:if ( $qry->Exec('always',__LINE__,__FILE__) && $row = $qry->Fetch() ) {
davical-1.1.9.3/htdocs/always.php:311: $c->schema_version = doubleval( sprintf( '%d%03d.%03d', $row->schema_major, $row->schema_minor, $row->schema_patch) );
davical-1.1.9.3/htdocs/always.php:312: $c->wanted_version = doubleval( sprintf( '%d%03d.%03d', $c->want_dbversion[0], $c->want_dbversion[1], $c->want_dbversion[2]) );
davical-1.1.9.3/htdocs/always.php-313- $c->schema_major = $row->schema_major;
##############################################
davical-1.1.9.3/htdocs/setup.php-313- $qry = new AwlQuery($sql);
davical-1.1.9.3/htdocs/setup.php:314: if ( $qry->Exec('setup',__LINE__,__FILE__) && $s = $qry->Fetch() ) {
davical-1.1.9.3/htdocs/setup.php-315- $row = sprintf('<td align="center">%s</td><td align="center">%s</td><td align="center">%s</td>',
##############################################
davical-1.1.9.3/htdocs/tz.php-27-$code_file = sprintf( 'tz/%s.php', $action );
davical-1.1.9.3/htdocs/tz.php:28:if ( ! @include_once( $code_file ) ) {
davical-1.1.9.3/htdocs/tz.php-29- $request->PreconditionFailed(400, "supported-action", 'The action "'.$action.'" is not understood.', 'urn:ietf:params:xml:ns:timezone-service' );
##############################################
davical-1.1.9.3/htdocs/admin.php-27-$code_file = sprintf( 'ui/%s-%s.php', $component, $action );
davical-1.1.9.3/htdocs/admin.php:28:if ( ! @include_once( $code_file ) ) {
davical-1.1.9.3/htdocs/admin.php-29- $c->messages[] = sprintf(
##############################################
davical-1.1.9.3/zonedb/update-tzdata.sh-24-vzic --pure --olson-dir tzdata --output-dir vtimezones
davical-1.1.9.3/zonedb/update-tzdata.sh:25:echo "Olson `echo $TZDATAFILE | cut -f1 -d.`" >vtimezones/primary-source
##############################################
davical-1.1.9.3/testing/watch-port-80.sh-13- if [ -z "${IP}" ]; then
davical-1.1.9.3/testing/watch-port-80.sh:14: IP="`ip addr show dev ${IFACE} | grep ' inet ' | tr -s ' ' | cut -f3 -d' ' | cut -f1 -d'/'`"
davical-1.1.9.3/testing/watch-port-80.sh-15- fi
##############################################
davical-1.1.9.3/testing/watch-port-80.sh-28-
davical-1.1.9.3/testing/watch-port-80.sh:29:if [ "`stat --format='%s' \"${DUMPFILE}\"`" -le 230 ] ; then
davical-1.1.9.3/testing/watch-port-80.sh-30- rm "${DUMPFILE}"
##############################################
davical-1.1.9.3/testing/regression_reporting.sh-39- # I encountered a bug in xmlstarlet where small sections of large files are not properly escaped if inserted directly :/
davical-1.1.9.3/testing/regression_reporting.sh:40: perl -pi -e 'BEGIN {$diff = `xmlstarlet esc < "'"${REGRESSION}/diffs/${TEST}"'"`} s/xxxPERL_REPLACE_THIS_WITH_THE_ESCAPED_DIFFxxx/$diff/g' "$REPORTFILE"
davical-1.1.9.3/testing/regression_reporting.sh-41- fi
##############################################
davical-1.1.9.3/testing/run_regressions.sh-200- [ -f "${T}" ] || break
davical-1.1.9.3/testing/run_regressions.sh:201: TEST="`basename ${T} .test`"
davical-1.1.9.3/testing/run_regressions.sh:202: TESTNUM="`echo ${TEST} | cut -f1 -d'-'`"
davical-1.1.9.3/testing/run_regressions.sh-203- TESTNUM="${TEST/-*}"
##############################################
davical-1.1.9.3/testing/test-RRULE-v2.php-57- // printf( "%s\n", $qry->querystring);
davical-1.1.9.3/testing/test-RRULE-v2.php:58: if ( $qry->Exec("test") && $qry->rows() > 0 ) {
davical-1.1.9.3/testing/test-RRULE-v2.php-59- $i = 0;
##############################################
davical-1.1.9.3/scripts/sync-remote-caldav.php-179-
davical-1.1.9.3/scripts/sync-remote-caldav.php:180: $qry = new AwlQuery('SELECT collection_id, dav_displayname AS displayname, dav_etag AS getctag FROM collection WHERE dav_name = :collection_dav_name', array(':collection_dav_name' => $args->local_collection_path) );
davical-1.1.9.3/scripts/sync-remote-caldav.php:181: if ( $qry->Exec('sync-pull',__LINE__,__FILE__) && $qry->rows() > 0 ) {
davical-1.1.9.3/scripts/sync-remote-caldav.php-182- $local_calendar = $qry->Fetch();
##############################################
davical-1.1.9.3/scripts/sync-remote-caldav.php-273- array(':collection_dav_name' => $args->local_collection_path) );
davical-1.1.9.3/scripts/sync-remote-caldav.php:274:if ( $qry->Exec('sync-pull',__LINE__,__FILE__) && $qry->rows() > 0 ) {
davical-1.1.9.3/scripts/sync-remote-caldav.php-275- $local_etags = array();
##############################################
davical-1.1.9.3/scripts/sync-remote-caldav.php-347- $local_fname = $args->local_collection_path . $fname;
davical-1.1.9.3/scripts/sync-remote-caldav.php:348: $qry = new AwlQuery('DELETE FROM caldav_data WHERE caldav_type!=\'VTODO\' and dav_name = :dav_name', array( ':dav_name' => $local_fname ) );
davical-1.1.9.3/scripts/sync-remote-caldav.php-349- $qry->Exec('sync_pull',__LINE__,__FILE__);
##############################################
davical-1.1.9.3/scripts/sync-remote-caldav.php-364-
davical-1.1.9.3/scripts/sync-remote-caldav.php:365: $qry = new AwlQuery('SELECT collection_id, dav_displayname AS displayname, dav_etag AS getctag FROM collection WHERE dav_name = :collection_dav_name', array(':collection_dav_name' => $args->local_collection_path) );
davical-1.1.9.3/scripts/sync-remote-caldav.php:366: if ( $qry->Exec('sync-pull',__LINE__,__FILE__) && $qry->rows() > 0 ) {
davical-1.1.9.3/scripts/sync-remote-caldav.php-367- $local_calendar = $qry->Fetch();
##############################################
davical-1.1.9.3/scripts/tz-update.php-86- $tzrow = null;
davical-1.1.9.3/scripts/tz-update.php:87: $qry = new AwlQuery('SELECT * FROM timezones WHERE tzid=:tzid', array(':tzid' => $tzid));
davical-1.1.9.3/scripts/tz-update.php:88: if ( $qry->Exec('tz/update',__LINE__,__FILE__) && $qry->rows() > 0 ) {
davical-1.1.9.3/scripts/tz-update.php-89- $tzrow = $qry->Fetch();
##############################################
davical-1.1.9.3/scripts/tz-update.php-150- $params = array(':tzid' => $tzid, ':alias' => $alias );
davical-1.1.9.3/scripts/tz-update.php:151: $qry = new AwlQuery('SELECT * FROM tz_aliases JOIN timezones USING(our_tzno) WHERE tzid=:tzid AND tzalias=:alias', $params);
davical-1.1.9.3/scripts/tz-update.php:152: if ( $qry->Exec('tz/update', __LINE__, __FILE__) && $qry->rows() < 1 ) {
davical-1.1.9.3/scripts/tz-update.php:153: $qry->QDo('INSERT INTO tz_aliases(our_tzno,tzalias) SELECT our_tzno, :alias FROM timezones WHERE tzid = :tzid', $params);
davical-1.1.9.3/scripts/tz-update.php-154- $added_aliases++;
##############################################
davical-1.1.9.3/scripts/tz-update.php-165- $current_zones = array();
davical-1.1.9.3/scripts/tz-update.php:166: if ( $qry->Exec('tz/updatecheck',__LINE__,__FILE__) && $qry->rows() > 0 ) {
davical-1.1.9.3/scripts/tz-update.php-167- while( $row = $qry->Fetch() )
##############################################
davical-1.1.9.3/scripts/refresh-alarms.php-118-$qry = new AwlQuery( $sql );
davical-1.1.9.3/scripts/refresh-alarms.php:119:if ( $qry->Exec() && $qry->rows() ) {
davical-1.1.9.3/scripts/refresh-alarms.php-120- while( $alarm = $qry->Fetch() ) {
##############################################
davical-1.1.9.3/scripts/archive-old-events.php-146-if ( $qry->Exec(__CLASS__, __LINE__, __FILE__) ) {
davical-1.1.9.3/scripts/archive-old-events.php:147: $qry->QDo('SELECT collection_id FROM collection WHERE dav_name = ?', $collection_dav_name );
davical-1.1.9.3/scripts/archive-old-events.php-148- if ( $qry->rows() != 1 ) {
##############################################
davical-1.1.9.3/scripts/archive-old-events.php-154-
davical-1.1.9.3/scripts/archive-old-events.php:155: $qry->QDo('SELECT collection_id FROM collection WHERE dav_name = ?', $collection_archive );
davical-1.1.9.3/scripts/archive-old-events.php-156- if ( $qry->rows() != 1 ) {
##############################################
davical-1.1.9.3/scripts/davical-cli-313- my $entfuncq = $dbh->quote($_[0]);
davical-1.1.9.3/scripts/davical-cli:314: my $stmt = "SELECT user_no FROM usr WHERE username = "."$entfuncq"." LIMIT 1;";
davical-1.1.9.3/scripts/davical-cli-315- syslog $syslog_priority, "Logueando consulta para instancia Davical para dominio $dominio : ---$stmt----" if ($verbose==1);
##############################################
davical-1.1.9.3/scripts/davical-cli-340- ## Se quotea el valor del ID de usuario del que obtener el id. Nos lo pasan al llamar a la funcion
davical-1.1.9.3/scripts/davical-cli:341: my $stmt = "SELECT principal_id FROM principal WHERE user_no = "."$entfuncq"." LIMIT 1;";
davical-1.1.9.3/scripts/davical-cli-342- syslog $syslog_priority, "Logueando consulta para instancia Davical para dominio $dominio : ---$stmt----" if ($verbose==1);
##############################################
davical-1.1.9.3/scripts/davical-cli-367- ## Se quotea el valor del ID de principal de usuario del que obtener el id de usuario. Nos lo pasan al llamar a la funcion
davical-1.1.9.3/scripts/davical-cli:368: my $stmt = "SELECT user_no FROM principal WHERE principal_id = "."$entfuncq"." LIMIT 1;";
davical-1.1.9.3/scripts/davical-cli-369- syslog $syslog_priority, "Logueando consulta para instancia Davical para dominio $dominio : ---$stmt----" if ($verbose==1);
##############################################
davical-1.1.9.3/scripts/davical-cli-394- ## Se quotea el valor del ID de usuario del que obtener el nombre de usuario. Nos lo pasan al llamar a la funcion
davical-1.1.9.3/scripts/davical-cli:395: my $stmt = "SELECT username FROM usr WHERE user_no = "."$entfuncq"." LIMIT 1;";
davical-1.1.9.3/scripts/davical-cli-396- syslog $syslog_priority, "Logueando consulta para instancia Davical para dominio $dominio : ---$stmt----" if ($verbose==1);
##############################################
davical-1.1.9.3/scripts/davical-cli-421- ## Se quotea el valor del ID de usuario del que obtener el tipo de principal que es. Nos lo pasan al llamar a la funcion
davical-1.1.9.3/scripts/davical-cli:422: my $stmt = "SELECT principal_type_desc FROM ((usr LEFT JOIN principal USING (user_no)) LEFT JOIN role_member USING (user_no)) LEFT JOIN principal_type ON (principal_type_id = type_id) WHERE user_no = "."$entfuncq"." AND active = 't' and role_no IS DISTINCT FROM '1' LIMIT 1;";
davical-1.1.9.3/scripts/davical-cli-423- syslog $syslog_priority, "Logueando consulta para instancia Davical para dominio $dominio : ---$stmt----" if ($verbose==1);
##############################################
davical-1.1.9.3/scripts/davical-cli-490- ## Se quotea el valor del ID de usuario del que obtener que colecciones tiene. Nos lo pasan al llamar a la funcion
davical-1.1.9.3/scripts/davical-cli:491: my $stmt = "SELECT dav_name,is_addressbook,collection_id FROM collection WHERE user_no = "."$entfuncq".";";
davical-1.1.9.3/scripts/davical-cli-492- syslog $syslog_priority, "Logueando consulta para instancia Davical para dominio $dominio : ---$stmt----" if ($verbose==1);
##############################################
davical-1.1.9.3/scripts/davical-cli-536- ## Se quotea el valor del ID de principal para el que sacar permisos externos en otras colecciones. Nos lo pasan al llamar a la funcion
davical-1.1.9.3/scripts/davical-cli:537: my $stmt = "SELECT privileges FROM grants WHERE to_principal = "."$entfuncq"." AND by_principal = "."$entfuncq2"." LIMIT 1;";
davical-1.1.9.3/scripts/davical-cli-538- syslog $syslog_priority, "Logueando consulta para instancia Davical para dominio $dominio : ---$stmt----" if ($verbose==1);
##############################################
davical-1.1.9.3/scripts/davical-cli-558- ## Se quotea el valor del ID de principal para el que sacar permisos externos en otras colecciones. Nos lo pasan al llamar a la funcion
davical-1.1.9.3/scripts/davical-cli:559: my $stmt = "SELECT privileges FROM grants WHERE to_principal = "."$entfuncq"." AND by_collection = "."$entfuncq2"." LIMIT 1;";
davical-1.1.9.3/scripts/davical-cli-560- syslog $syslog_priority, "Logueando consulta para instancia Davical para dominio $dominio : ---$stmt----" if ($verbose==1);
##############################################
davical-1.1.9.3/scripts/davical-cli-592- ## Se quotea el valor del id de usuario y nombre completo de la coleccion para obtener un id de coleccion. Nos lo pasan al llamar a la funcion
davical-1.1.9.3/scripts/davical-cli:593: my $stmt = "SELECT collection_id FROM collection WHERE user_no = "."$entfuncq"." AND dav_name = "."$entfuncq2"." LIMIT 1;";
davical-1.1.9.3/scripts/davical-cli-594- syslog $syslog_priority, "Logueando consulta para instancia Davical para dominio $dominio : ---$stmt----" if ($verbose==1);
##############################################
davical-1.1.9.3/scripts/davical-cli-620- my $entfuncq = $dbh->quote($_[0]);
davical-1.1.9.3/scripts/davical-cli:621: my $stmt = "SELECT dav_name FROM collection WHERE collection_id = "."$entfuncq"." LIMIT 1;";
davical-1.1.9.3/scripts/davical-cli-622- syslog $syslog_priority, "Logueando consulta para instancia Davical para dominio $dominio : ---$stmt----" if ($verbose==1);
##############################################
davical-1.1.9.3/scripts/davical-cli-652- my $colec_usu_opquetoca = "";
davical-1.1.9.3/scripts/davical-cli:653: my $stmt = "SELECT parent_container,dav_name,user_no,collection_id FROM collection WHERE default_privileges = "."'$perm_read'".";";
davical-1.1.9.3/scripts/davical-cli-654- syslog $syslog_priority, "Logueando consulta para instancia Davical para dominio $dominio : ---$stmt----" if ($verbose==1);
##############################################
davical-1.1.9.3/scripts/davical-cli-679- $contador = 0;
davical-1.1.9.3/scripts/davical-cli:680: $stmt = "SELECT parent_container,dav_name,user_no,collection_id FROM collection WHERE default_privileges = "."'$perm_readwrite'".";";
davical-1.1.9.3/scripts/davical-cli-681- syslog $syslog_priority, "Logueando consulta para instancia Davical para dominio $dominio : ---$stmt----" if ($verbose==1);
##############################################
davical-1.1.9.3/scripts/davical-cli-700- $contador = 0;
davical-1.1.9.3/scripts/davical-cli:701: $stmt = "SELECT principal_id FROM principal WHERE (default_privileges = '".$perm_read."' OR default_privileges = '".$perm_readwrite."');";
davical-1.1.9.3/scripts/davical-cli-702- syslog $syslog_priority, "Logueando consulta para instancia Davical para dominio $dominio : ---$stmt----" if ($verbose==1);
##############################################
davical-1.1.9.3/scripts/davical-cli-756- my $colec_usu_opquetoca = "";
davical-1.1.9.3/scripts/davical-cli:757: my $stmt = "SELECT user_no FROM collection WHERE (default_privileges = '".$perm_read."' OR default_privileges = '".$perm_readwrite."') AND collection_id = '".$_[0]."' LIMIT 1;";
davical-1.1.9.3/scripts/davical-cli-758- syslog $syslog_priority, "Logueando consulta para instancia Davical para dominio $dominio : ---$stmt----" if ($verbose==1);
##############################################
davical-1.1.9.3/scripts/davical-cli-782-
davical-1.1.9.3/scripts/davical-cli:783: my $stmt = "SELECT principal_id FROM principal WHERE (default_privileges = '".$perm_read."' OR default_privileges = '".$perm_readwrite."') AND user_no = '".$userid_para_comp_principal."';";
davical-1.1.9.3/scripts/davical-cli-784- syslog $syslog_priority, "Logueando consulta para instancia Davical para dominio $dominio : ---$stmt----" if ($verbose==1);
##############################################
davical-1.1.9.3/scripts/davical-cli-815-sub ver_permisos_defecto_colecc {
davical-1.1.9.3/scripts/davical-cli:816: my $stmt = "SELECT default_privileges FROM collection WHERE (default_privileges = '".$perm_read."' OR default_privileges = '".$perm_readwrite."') AND collection_id = '".$_[0]."' LIMIT 1;";
davical-1.1.9.3/scripts/davical-cli-817- syslog $syslog_priority, " Logueando consulta para instancia Davical para dominio $dominio : ---$stmt----" if ($verbose==1);
##############################################
davical-1.1.9.3/scripts/davical-cli-849- ## Se quotea el valor del ID de principal para el que sacar permisos externos en otras principals. Nos lo pasan al llamar a la funcion
davical-1.1.9.3/scripts/davical-cli:850: my $stmt = "SELECT to_principal,privileges FROM grants WHERE by_collection = "."$entfuncq"." AND to_principal = "."$entfuncq2".";";
davical-1.1.9.3/scripts/davical-cli-851- syslog $syslog_priority, "Logueando consulta para instancia Davical para dominio $dominio : ---$stmt----" if ($verbose==1);
##############################################
davical-1.1.9.3/scripts/davical-cli-872-sub existen_perm_defecto_princ {
davical-1.1.9.3/scripts/davical-cli:873: my $stmt = "SELECT default_privileges FROM dav_principal WHERE (default_privileges = '".$perm_read."' OR default_privileges = '".$perm_readwrite."') AND principal_id = '".$_[0]."' LIMIT 1;";
davical-1.1.9.3/scripts/davical-cli-874- syslog $syslog_priority, " Logueando consulta para instancia Davical para dominio $dominio : ---$stmt----" if ($verbose==1);
##############################################
davical-1.1.9.3/scripts/davical-cli-905- ## Se quotea el valor del ID de principal para el que sacar permisos externos en otras colecciones. Nos lo pasan al llamar a la funcion
davical-1.1.9.3/scripts/davical-cli:906: my $stmt = "SELECT by_collection,privileges FROM grants WHERE to_principal = "."$entfuncq"." AND by_collection IS NOT NULL;";
davical-1.1.9.3/scripts/davical-cli-907- syslog $syslog_priority, "Logueando consulta para instancia Davical para dominio $dominio : ---$stmt----" if ($verbose==1);
##############################################
davical-1.1.9.3/scripts/davical-cli-930- ## Se quotea el valor del ID de principal para el que sacar permisos externos en otras principals. Nos lo pasan al llamar a la funcion
davical-1.1.9.3/scripts/davical-cli:931: my $stmt = "SELECT to_principal,privileges FROM grants WHERE by_collection = "."$entfuncq"." AND to_principal != "."$entfuncq2".";";
davical-1.1.9.3/scripts/davical-cli-932- syslog $syslog_priority, "Logueando consulta para instancia Davical para dominio $dominio : ---$stmt----" if ($verbose==1);
##############################################
davical-1.1.9.3/scripts/davical-cli-955- ## Se quotea el valor del ID de principal para el que sacar permisos externos en otras principals. Nos lo pasan al llamar a la funcion
davical-1.1.9.3/scripts/davical-cli:956: my $stmt = "SELECT to_principal,privileges FROM grants WHERE by_collection = "."$entfuncq"." AND to_principal IS NOT NULL;";
davical-1.1.9.3/scripts/davical-cli-957- syslog $syslog_priority, "Logueando consulta para instancia Davical para dominio $dominio : ---$stmt----" if ($verbose==1);
##############################################
davical-1.1.9.3/scripts/davical-cli-981- ## Se quotea el valor del ID de principal para el que sacar permisos externos en otras principals. Nos lo pasan al llamar a la funcion
davical-1.1.9.3/scripts/davical-cli:982: my $stmt = "SELECT to_principal,privileges FROM grants WHERE by_principal = "."$entfuncq"." AND privileges != '000000000000000000000000';";
davical-1.1.9.3/scripts/davical-cli-983- syslog $syslog_priority, "Logueando consulta para instancia Davical para dominio $dominio : ---$stmt----" if ($verbose==1);
##############################################
davical-1.1.9.3/scripts/davical-cli-1053- my $entfuncq = $dbh->quote($_[0]);
davical-1.1.9.3/scripts/davical-cli:1054: my $stmt = "SELECT to_principal FROM grants WHERE to_principal = "."$entfuncq".";";
davical-1.1.9.3/scripts/davical-cli-1055- syslog $syslog_priority, "Logueando consulta para instancia Davical para dominio $dominio : ---$stmt----" if ($verbose==1);
##############################################
davical-1.1.9.3/scripts/davical-cli-1077- ## Se quotea el valor del ID de la coleccion de la que saber de QUE tipo es. Nos lo pasan al llamar a la funcion
davical-1.1.9.3/scripts/davical-cli:1078: my $stmt = "SELECT is_addressbook FROM collection WHERE collection_id = "."$entfuncq"." LIMIT 1;";
davical-1.1.9.3/scripts/davical-cli-1079- syslog $syslog_priority, "Logueando consulta para instancia Davical para dominio $dominio : ---$stmt----" if ($verbose==1);
##############################################
davical-1.1.9.3/scripts/davical-cli-1298- ## Se quotea el valor del ID de usuario del que obtener los ID de coleccion. Nos lo pasan al llamar a la funcion
davical-1.1.9.3/scripts/davical-cli:1299: my $stmt = "SELECT collection_id FROM collection WHERE user_no = "."$entfuncq".";";
davical-1.1.9.3/scripts/davical-cli-1300- syslog $syslog_priority, "Logueando consulta para instancia Davical para dominio $dominio : ---$stmt----" if ($verbose==1);
##############################################
davical-1.1.9.3/scripts/davical-cli-1331- ## Se quotea el valor del ID de usuario del que obtener los ID de coleccion. Nos lo pasan al llamar a la funcion
davical-1.1.9.3/scripts/davical-cli:1332: my $stmt = "SELECT collection_id FROM collection WHERE dav_name = "."$entfuncq"." LIMIT 1;";
davical-1.1.9.3/scripts/davical-cli-1333- syslog $syslog_priority, "Logueando consulta para instancia Davical para dominio $dominio : ---$stmt----" if ($verbose==1);
##############################################
davical-1.1.9.3/scripts/davical-cli-1407-
davical-1.1.9.3/scripts/davical-cli:1408: $stmt = "DELETE FROM collection WHERE dav_name="."$entfuncq".";";
davical-1.1.9.3/scripts/davical-cli-1409- syslog $syslog_priority, "Logueando consulta para instancia Davical para dominio $dominio : ---$stmt----" if ($verbose==1);
##############################################
davical-1.1.9.3/scripts/davical-cli-1422- ## Se quotea el valor del ID de grupo y ID de miembro que borrar del grupo del ID. Nos lo pasan al llamar a la funcion
davical-1.1.9.3/scripts/davical-cli:1423: $stmt = "DELETE FROM group_member WHERE group_id="."$entfuncq"." AND member_id="."$entfuncq2".";";
davical-1.1.9.3/scripts/davical-cli-1424- syslog $syslog_priority, "Logueando consulta para instancia Davical para dominio $dominio : ---$stmt----" if ($verbose==1);
##############################################
davical-1.1.9.3/scripts/davical-cli-1458- ## Se quotea el valor del ID de principal que dar de baja. Nos lo pasan al llamar a la funcion
davical-1.1.9.3/scripts/davical-cli:1459: my $stmt = "DELETE FROM dav_principal WHERE principal_id="."$entfuncq".";";
davical-1.1.9.3/scripts/davical-cli-1460- syslog $syslog_priority, "Logueando consulta para instancia Davical para dominio $dominio : ---$stmt----" if ($verbose==1);
##############################################
davical-1.1.9.3/scripts/davical-cli-1517-
davical-1.1.9.3/scripts/davical-cli:1518: my $stmt = "SELECT group_id FROM group_member WHERE member_id = "."$entfuncq".";";
davical-1.1.9.3/scripts/davical-cli-1519- syslog $syslog_priority, "Logueando consulta para instancia Davical para dominio $dominio : ---$stmt----" if ($verbose==1);
##############################################
davical-1.1.9.3/scripts/davical-cli-1543- ## Se quotea el valor del ID de grupo del que obtener que miembros tiene. Nos lo pasan al llamar a la funcion
davical-1.1.9.3/scripts/davical-cli:1544: my $stmt = "SELECT member_id FROM group_member WHERE group_id = "."$entfuncq".";";
davical-1.1.9.3/scripts/davical-cli-1545- syslog $syslog_priority, "Logueando consulta para instancia Davical para dominio $dominio : ---$stmt----" if ($verbose==1);
##############################################
davical-1.1.9.3/scripts/davical-cli-1599-
davical-1.1.9.3/scripts/davical-cli:1600: my $stmt = "SELECT group_id,member_id from group_member where group_id="."$entfuncq2"." and member_id="."$entfuncq"." LIMIT 1;";
davical-1.1.9.3/scripts/davical-cli-1601- syslog $syslog_priority, "Logueando consulta para instancia Davical para dominio $dominio : ---$stmt----" if ($verbose==1);
##############################################
davical-1.1.9.3/scripts/davical-cli-1652- {
davical-1.1.9.3/scripts/davical-cli:1653: $stmt = "UPDATE collection SET default_privileges = NULL WHERE collection_id="."$entfuncq".";";
davical-1.1.9.3/scripts/davical-cli-1654- syslog $syslog_priority, "Logueando consulta para instancia Davical para dominio $dominio : ---$stmt----" if ($verbose==1);
##############################################
davical-1.1.9.3/scripts/davical-cli-1662- my $entfuncq2 = $dbh->quote($permbin);
davical-1.1.9.3/scripts/davical-cli:1663: $stmt = "UPDATE collection SET default_privileges = "."$entfuncq2"." WHERE collection_id="."$entfuncq".";";
davical-1.1.9.3/scripts/davical-cli-1664- syslog $syslog_priority, "Logueando consulta para instancia Davical para dominio $dominio : ---$stmt----" if ($verbose==1);
##############################################
davical-1.1.9.3/scripts/davical-cli-1686- {
davical-1.1.9.3/scripts/davical-cli:1687: $stmt = "UPDATE dav_principal SET default_privileges = '000000001111111000100000' WHERE principal_id="."$entfuncq".";";
davical-1.1.9.3/scripts/davical-cli-1688- syslog $syslog_priority, "Logueando consulta para instancia Davical para dominio $dominio : ---$stmt----" if ($verbose==1);
##############################################
davical-1.1.9.3/scripts/davical-cli-1695- comprobar_error_variable_texto($permbin, $mensaje_fallo_gen);
davical-1.1.9.3/scripts/davical-cli:1696: $stmt = "UPDATE dav_principal SET default_privileges = "."$entfuncq2"." WHERE principal_id="."$entfuncq".";";
davical-1.1.9.3/scripts/davical-cli-1697- syslog $syslog_priority, "Logueando consulta para instancia Davical para dominio $dominio : ---$stmt----" if ($verbose==1);
##############################################
davical-1.1.9.3/scripts/davical-cli-1741-
davical-1.1.9.3/scripts/davical-cli:1742: my $stmt = "DELETE FROM grants WHERE by_principal="."$entfuncq2"." AND to_principal="."$entfuncq".";";
davical-1.1.9.3/scripts/davical-cli-1743- syslog $syslog_priority, "Logueando consulta para instancia Davical para dominio $dominio : ---$stmt----" if ($verbose==1);
##############################################
davical-1.1.9.3/scripts/davical-cli-1851- ## Se quota el valor del id de principal y coleccion sobre la que quitar permisos... Nos lo pasan al llamar a la funcion.
davical-1.1.9.3/scripts/davical-cli:1852: my $stmt = "DELETE FROM grants WHERE by_collection="."$entfuncq2"." AND to_principal = "."$entfuncq".";";
davical-1.1.9.3/scripts/davical-cli-1853- syslog $syslog_priority, "Logueando consulta para instancia Davical para dominio $dominio : ---$stmt----" if ($verbose==1);
##############################################
davical-1.1.9.3/scripts/davical-cli-1860- ## Se quota el valor del id de principal y coleccion sobre la que quitar permisos... Nos lo pasan al llamar a la funcion.
davical-1.1.9.3/scripts/davical-cli:1861: my $stmt = "UPDATE collection SET dav_displayname="."$entfuncq2"." WHERE collection_id="."$entfuncq".";";
davical-1.1.9.3/scripts/davical-cli-1862- syslog $syslog_priority, "Logueando consulta para instancia Davical para dominio $dominio : ---$stmt----" if ($verbose==1);
##############################################
davical-1.1.9.3/scripts/davical-cli-1910- $usercorriendo = `/usr/bin/whoami | /usr/bin/tr -d '\n'`;
davical-1.1.9.3/scripts/davical-cli:1911: my $lineappid = `/bin/ps auxwww | grep '$usercorriendo' | grep '$pidpadre' | grep -v 'grep'`;
davical-1.1.9.3/scripts/davical-cli-1912- syslog $syslog_priority, "La linea lineappid vale ----$lineappid------";
##############################################
davical-1.1.9.3/inc/log_caldav_action.php-32- $qry = new AwlQuery($sql, $uid);
davical-1.1.9.3/inc/log_caldav_action.php:33: if($qry->Exec('log_caldav_action', __LINE__, __FILE__) && $qry->rows() > 0 && $row = $qry->Fetch()) { $summary = $row->summary; }
davical-1.1.9.3/inc/log_caldav_action.php-34-
##############################################
davical-1.1.9.3/inc/log_caldav_action.php-48- $qry = new AwlQuery($sql, $uid);
davical-1.1.9.3/inc/log_caldav_action.php:49: if($qry->Exec('log_caldav_action', __LINE__, __FILE__) && $qry->rows() > 0 && $row = $qry->Fetch()) { $summary = $row->summary; }
davical-1.1.9.3/inc/log_caldav_action.php-50-
##############################################
davical-1.1.9.3/inc/CalDAVRequest.php-341- $qry = new AwlQuery( $sql, $params );
davical-1.1.9.3/inc/CalDAVRequest.php:342: if ( $qry->Exec('caldav',__LINE__,__FILE__) && $qry->rows() == 1 && ($row = $qry->Fetch()) ) {
davical-1.1.9.3/inc/CalDAVRequest.php-343- if ( $row->dav_name == $this->path."/" ) {
##############################################
davical-1.1.9.3/inc/CalDAVRequest.php-380-
davical-1.1.9.3/inc/CalDAVRequest.php:381: $qry = new AwlQuery( "SELECT * FROM collection WHERE dav_name = :dav_name", array( ':dav_name' => $matches[1] ) );
davical-1.1.9.3/inc/CalDAVRequest.php:382: if ( $qry->Exec('caldav',__LINE__,__FILE__) && $qry->rows() == 1 && ($row = $qry->Fetch()) ) {
davical-1.1.9.3/inc/CalDAVRequest.php-383- $this->collection_id = $row->collection_id;
##############################################
davical-1.1.9.3/inc/CalDAVRequest.php-559- $qry = new AwlQuery( $sql, $params );
davical-1.1.9.3/inc/CalDAVRequest.php:560: if ( $qry->Exec('caldav',__LINE__,__FILE__) && $permission_result = $qry->Fetch() )
davical-1.1.9.3/inc/CalDAVRequest.php-561- $this->privileges |= bindec($permission_result->perm);
##############################################
davical-1.1.9.3/inc/CalDAVRequest.php-706-
davical-1.1.9.3/inc/CalDAVRequest.php:707: $qry = new AwlQuery('SELECT * FROM locks WHERE opaquelocktoken = :lock_token', array( ':lock_token' => $lock_token ) );
davical-1.1.9.3/inc/CalDAVRequest.php-708- if ( $qry->Exec('caldav',__LINE__,__FILE__) ) {
##############################################
davical-1.1.9.3/inc/vcard.php-90- $params = array( ':dav_id' => $dav_id );
davical-1.1.9.3/inc/vcard.php:91: $qry->QDo('DELETE FROM addressbook_address_adr WHERE dav_id = :dav_id', $params );
davical-1.1.9.3/inc/vcard.php-92- foreach( $addresses AS $adr ) {
##############################################
davical-1.1.9.3/inc/vcard.php-132- $params = array( ':dav_id' => $dav_id );
davical-1.1.9.3/inc/vcard.php:133: $qry->QDo('DELETE FROM addressbook_address_tel WHERE dav_id = :dav_id', $params );
davical-1.1.9.3/inc/vcard.php-134- foreach( $telephones AS $tel ) {
##############################################
davical-1.1.9.3/inc/vcard.php-163- $params = array( ':dav_id' => $dav_id );
davical-1.1.9.3/inc/vcard.php:164: $qry->QDo('DELETE FROM addressbook_address_email WHERE dav_id = :dav_id', $params );
davical-1.1.9.3/inc/vcard.php-165- foreach( $emails AS $email ) {
##############################################
davical-1.1.9.3/inc/auth-functions.php-106- if ( !empty($v['name']) ) {
davical-1.1.9.3/inc/auth-functions.php:107: $qry = new AwlQuery( 'SELECT 1 FROM collection WHERE dav_name = :dav_name', array( ':dav_name' => $principal->dav_name().$v['name'].'/') );
davical-1.1.9.3/inc/auth-functions.php-108- if ( !$qry->Exec() ) {
##############################################
davical-1.1.9.3/inc/auth-functions.php-256-
davical-1.1.9.3/inc/auth-functions.php:257: $qry = new AwlQuery('SELECT * FROM usr WHERE user_no = :user_no', array(':user_no' => $usr->user_no) );
davical-1.1.9.3/inc/auth-functions.php:258: if ( $qry->Exec('Login',__LINE__,__FILE__) && $qry->rows() == 1 ) {
davical-1.1.9.3/inc/auth-functions.php-259- $type = "UPDATE";
##############################################
davical-1.1.9.3/inc/auth-functions.php-283- if ( $type != 'INSERT' ) $params[':user_no'] = $usr->user_no;
davical-1.1.9.3/inc/auth-functions.php:284: $qry = new AwlQuery( sql_from_object( $usr, $type, 'usr', 'WHERE user_no= :user_no' ), $params );
davical-1.1.9.3/inc/auth-functions.php-285- $qry->Exec('Login',__LINE__,__FILE__);
##############################################
davical-1.1.9.3/inc/auth-functions.php-338- if ( isset($c->authenticate_hook['config']['where']) )
davical-1.1.9.3/inc/auth-functions.php:339: $andwhere = ' AND '.$c->authenticate_hook['config']['where'];
davical-1.1.9.3/inc/auth-functions.php-340- else
##############################################
davical-1.1.9.3/inc/auth-functions.php-342-
davical-1.1.9.3/inc/auth-functions.php:343: $qry = new AwlQuery('SELECT '.$cols.' FROM usr WHERE lower(username) = :username '. $andwhere, array( ':username' => strtolower($username) ));
davical-1.1.9.3/inc/auth-functions.php-344- $authconn = $qry->SetConnection($c->authenticate_hook['config']['connection'], ($persistent ? array(PDO::ATTR_PERSISTENT => true) : null));
##############################################
davical-1.1.9.3/inc/auth-functions.php-355-
davical-1.1.9.3/inc/auth-functions.php:356: if ( $qry->Exec('Login',__LINE__,__FILE__) && $qry->rows() == 1 ) {
davical-1.1.9.3/inc/auth-functions.php-357- $usr = $qry->Fetch();
##############################################
davical-1.1.9.3/inc/Principal.php-223- $qry = new AwlQuery( $sql, $params );
davical-1.1.9.3/inc/Principal.php:224: if ( $qry->Exec('Principal',__LINE__,__FILE__) && $qry->rows() == 1 && $row = $qry->Fetch() ) {
davical-1.1.9.3/inc/Principal.php-225- $this->exists = true;
##############################################
davical-1.1.9.3/inc/Principal.php-396- $this->dead_properties = array();
davical-1.1.9.3/inc/Principal.php:397: $qry = new AwlQuery('SELECT property_name, property_value FROM property WHERE dav_name= :dav_name', array(':dav_name' => $this->dav_name()) );
davical-1.1.9.3/inc/Principal.php-398- if ( $qry->Exec('Principal') ) {
##############################################
davical-1.1.9.3/inc/Principal.php-413- $this->collections = array();
davical-1.1.9.3/inc/Principal.php:414: $qry = new AwlQuery('SELECT * FROM collection WHERE user_no= :user_no', array(':user_no' => $this->user_no()) );
davical-1.1.9.3/inc/Principal.php-415- if ( $qry->Exec('Principal') ) {
##############################################
davical-1.1.9.3/inc/caldav-POST.php-66- dbg_error_log( 'POST', 'try to resolve local attendee %s', $localname);
davical-1.1.9.3/inc/caldav-POST.php:67: $qry = new AwlQuery('SELECT fullname, email FROM usr WHERE user_no = (SELECT user_no FROM principal WHERE type_id = 1 AND user_no = (SELECT user_no FROM usr WHERE lower(username) = (text(:username)))) UNION SELECT fullname, email FROM usr WHERE user_no IN (SELECT user_no FROM principal WHERE principal_id IN (SELECT member_id FROM group_member WHERE group_id = (SELECT principal_id FROM principal WHERE type_id = 3 AND user_no = (SELECT user_no FROM usr WHERE lower(username) = (text(:username))))))', array(':username' => strtolower($localname)));
davical-1.1.9.3/inc/caldav-POST.php:68: if ( $qry->Exec('POST',__LINE__,__FILE__) && $qry->rows() >= 1 ) {
davical-1.1.9.3/inc/caldav-POST.php-69- dbg_error_log( 'POST', 'resolved local name %s to %d individual attendees', $localname, $qry->rows());
##############################################
davical-1.1.9.3/inc/caldav-POST.php-87- $params = array( ':session_principal' => $session->principal_id, ':scan_depth' => $c->permission_scan_depth, ':email' => $attendee_email );
davical-1.1.9.3/inc/caldav-POST.php:88: $qry = new AwlQuery('SELECT pprivs(:session_principal::int8,principal_id,:scan_depth::int) AS p, username FROM usr JOIN principal USING(user_no) WHERE lower(usr.email) = lower(:email)', $params );
davical-1.1.9.3/inc/caldav-POST.php:89: if ( !$qry->Exec('POST',__LINE__,__FILE__) ) $request->DoResponse( 501, 'Database error');
davical-1.1.9.3/inc/caldav-POST.php-90- if ( $qry->rows() > 1 ) {
davical-1.1.9.3/inc/caldav-POST.php-91- // Unlikely, but if we get more than one result we'll do an exact match instead.
davical-1.1.9.3/inc/caldav-POST.php:92: if ( !$qry->QDo('SELECT pprivs(:session_principal::int8,principal_id,:scan_depth::int) AS p, username FROM usr JOIN principal USING(user_no) WHERE usr.email = :email', $params ) )
davical-1.1.9.3/inc/caldav-POST.php-93- $request->DoResponse( 501, 'Database error');
##############################################
davical-1.1.9.3/inc/caldav-POST.php-95- /** Sigh... Go back to the original case-insensitive match */
davical-1.1.9.3/inc/caldav-POST.php:96: $qry->QDo('SELECT pprivs(:session_principal::int8,principal_id,:scan_depth::int) AS p, username FROM usr JOIN principal USING(user_no) WHERE lower(usr.email) = lower(:email)', $params );
davical-1.1.9.3/inc/caldav-POST.php-97- }
##############################################
davical-1.1.9.3/inc/caldav-ACL.php-158- $qry = new AwlQuery('SELECT privileges FROM grants '.$where, $sqlparms);
davical-1.1.9.3/inc/caldav-ACL.php:159: if ( $qry->Exec('ACL',__LINE__,__FILE__) && $qry->rows() == 1 && $current = $qry->Fetch() ) {
davical-1.1.9.3/inc/caldav-ACL.php-160- $sql = 'UPDATE grants SET privileges=:privileges::INT::BIT(24) '.$where;
##############################################
davical-1.1.9.3/inc/caldav-ACL.php-170- Principal::cacheDelete('dav_name',$grantee->dav_name());
davical-1.1.9.3/inc/caldav-ACL.php:171: Principal::cacheFlush('principal_id IN (SELECT member_id FROM group_member WHERE group_id = ?)', array($grantee_id));
davical-1.1.9.3/inc/caldav-ACL.php-172- }
##############################################
davical-1.1.9.3/inc/caldav-REPORT-principal.php-31- foreach( $qry_props AS $k1 => $v1 ) {
davical-1.1.9.3/inc/caldav-REPORT-principal.php:32: if ( $subwhere != "" ) $subwhere .= " OR ";
davical-1.1.9.3/inc/caldav-REPORT-principal.php-33- switch( $v1->GetNSTag() ) {
##############################################
davical-1.1.9.3/inc/caldav-REPORT-principal.php-60- if ( $subwhere != "" ) {
davical-1.1.9.3/inc/caldav-REPORT-principal.php:61: $where .= sprintf( "%s(%s)", ($where == "" ? "" : $clause_joiner), $subwhere );
davical-1.1.9.3/inc/caldav-REPORT-principal.php-62- }
davical-1.1.9.3/inc/caldav-REPORT-principal.php-63-}
davical-1.1.9.3/inc/caldav-REPORT-principal.php:64:if ( $where != "" ) $where = "WHERE $where";
davical-1.1.9.3/inc/caldav-REPORT-principal.php-65-$sql = "SELECT * FROM dav_principal $where ORDER BY principal_id LIMIT 100";
##############################################
davical-1.1.9.3/inc/caldav-REPORT-principal.php-75-$responses = array();
davical-1.1.9.3/inc/caldav-REPORT-principal.php:76:if ( $qry->Exec("REPORT",__LINE__,__FILE__) && $qry->rows() > 0 ) {
davical-1.1.9.3/inc/caldav-REPORT-principal.php-77- while( $row = $qry->Fetch() ) {
##############################################
davical-1.1.9.3/inc/DAVPrincipal.php-165- $this->group_member_set = array();
davical-1.1.9.3/inc/DAVPrincipal.php:166: $qry = new AwlQuery('SELECT usr.username FROM group_member JOIN principal ON (principal_id=member_id) JOIN usr USING(user_no) WHERE usr.active=true AND group_id = :group_id ORDER BY principal.principal_id ', array( ':group_id' => $this->principal_id) );
davical-1.1.9.3/inc/DAVPrincipal.php:167: if ( $qry->Exec('DAVPrincipal') && $qry->rows() > 0 ) {
davical-1.1.9.3/inc/DAVPrincipal.php-168- while( $member = $qry->Fetch() ) {
##############################################
davical-1.1.9.3/inc/DAVPrincipal.php-174- $this->group_membership = array();
davical-1.1.9.3/inc/DAVPrincipal.php:175: $qry = new AwlQuery('SELECT usr.username FROM group_member JOIN principal ON (principal_id=group_id) JOIN usr USING(user_no) WHERE usr.active=true AND member_id = :member_id UNION SELECT usr.username FROM group_member LEFT JOIN grants ON (to_principal=group_id) JOIN principal ON (principal_id=by_principal) JOIN usr USING(user_no) WHERE usr.active=true AND member_id = :member_id and by_principal != member_id ORDER BY 1', array( ':member_id' => $this->principal_id ) );
davical-1.1.9.3/inc/DAVPrincipal.php:176: if ( $qry->Exec('DAVPrincipal') && $qry->rows() > 0 ) {
davical-1.1.9.3/inc/DAVPrincipal.php-177- while( $group = $qry->Fetch() ) {
##############################################
davical-1.1.9.3/inc/DAVPrincipal.php-209- $qry = new AwlQuery($sql, $params);
davical-1.1.9.3/inc/DAVPrincipal.php:210: if ( $qry->Exec('DAVPrincipal') && $qry->rows() > 0 ) {
davical-1.1.9.3/inc/DAVPrincipal.php-211- while( $relationship = $qry->Fetch() ) {
##############################################
davical-1.1.9.3/inc/DAVPrincipal.php-227- $qry = new AwlQuery($sql, $params ); // reuse $params assigned for earlier query
davical-1.1.9.3/inc/DAVPrincipal.php:228: if ( $qry->Exec('DAVPrincipal') && $qry->rows() > 0 ) {
davical-1.1.9.3/inc/DAVPrincipal.php-229- while( $relationship = $qry->Fetch() ) {
##############################################
davical-1.1.9.3/inc/caldav-PROPPATCH.php-167- $existing_grants = array();
davical-1.1.9.3/inc/caldav-PROPPATCH.php:168: $qry->QDo('SELECT to_principal, privileges FROM grants WHERE by_principal = :by_principal', $sqlparams);
davical-1.1.9.3/inc/caldav-PROPPATCH.php-169- while ( $row = $qry->Fetch() ) {
##############################################
davical-1.1.9.3/inc/caldav-PROPPATCH.php-204- Principal::cacheDelete('dav_name',$to_principal->dav_name());
davical-1.1.9.3/inc/caldav-PROPPATCH.php:205: Principal::cacheFlush('principal_id IN (SELECT member_id FROM group_member WHERE group_id = ?)', array($to_principal->principal_id()));
davical-1.1.9.3/inc/caldav-PROPPATCH.php-206- }
##############################################
davical-1.1.9.3/inc/caldav-PROPPATCH.php-224- $sqlparams[':to_principal'] = $id;
davical-1.1.9.3/inc/caldav-PROPPATCH.php:225: $qry->QDo($sql.' WHERE to_principal=:to_principal AND by_principal=:by_principal', $sqlparams);
davical-1.1.9.3/inc/caldav-PROPPATCH.php-226- dbg_error_log("PROPPATCH", "group-member-set: %s is no longer granted %s access to %s", $id, $type, $dav_resource->getProperty('username'));
##############################################
davical-1.1.9.3/inc/caldav-PROPPATCH.php-268- $params = array( ':tzid' => $tzid );
davical-1.1.9.3/inc/caldav-PROPPATCH.php:269: $qry = new AwlQuery('SELECT 1 FROM timezones WHERE tzid = :tzid', $params );
davical-1.1.9.3/inc/caldav-PROPPATCH.php:270: if ( $qry->Exec('PUT',__LINE__,__FILE__) && $qry->rows() == 0 ) {
davical-1.1.9.3/inc/caldav-PROPPATCH.php-271- $params[':olson_name'] = $calendar->GetOlsonName($tz);
##############################################
davical-1.1.9.3/inc/caldav-PROPPATCH.php-349- $existing_grants = array();
davical-1.1.9.3/inc/caldav-PROPPATCH.php:350: $qry->QDo('SELECT privileges, to_principal FROM grants WHERE by_principal = :by_principal', $sqlparams);
davical-1.1.9.3/inc/caldav-PROPPATCH.php-351- while( $row = $qry->Fetch() ) {
##############################################
davical-1.1.9.3/inc/caldav-PROPPATCH.php-374- $sqlparams[':to_principal'] = $to_principal->principal_id();
davical-1.1.9.3/inc/caldav-PROPPATCH.php:375: $qry->QDo($sql.'WHERE by_principal = :by_principal AND to_principal = :to_principal', $sqlparams);
davical-1.1.9.3/inc/caldav-PROPPATCH.php-376-
##############################################
davical-1.1.9.3/inc/caldav-PROPPATCH.php-392- if ( $dav_resource->IsCollection() && $dav_resource->IsCalendar() && ! $dav_resource->IsBinding() ) {
davical-1.1.9.3/inc/caldav-PROPPATCH.php:393: $qry->QDo('UPDATE collection SET timezone = NULL WHERE dav_name = :dav_name', array( ':dav_name' => $dav_resource->dav_name()) );
davical-1.1.9.3/inc/caldav-PROPPATCH.php-394- require_once("instance_range.php");
##############################################
davical-1.1.9.3/inc/caldav-DELETE.php-25- $params = array( ':collection_id' => $id );
davical-1.1.9.3/inc/caldav-DELETE.php:26: $qry = new AwlQuery('SELECT child.collection_id AS child_id FROM collection child JOIN collection parent ON (parent.dav_name = child.parent_container) WHERE parent.collection_id = :collection_id', $params );
davical-1.1.9.3/inc/caldav-DELETE.php:27: if ( $qry->Exec('DELETE',__LINE__,__FILE__) && $qry->rows() > 0 ) {
davical-1.1.9.3/inc/caldav-DELETE.php-28- while( $row = $qry->Fetch() ) {
##############################################
davical-1.1.9.3/inc/caldav-DELETE.php-32-
davical-1.1.9.3/inc/caldav-DELETE.php:33: if ( $qry->QDo("SELECT write_sync_change(collection_id, 404, caldav_data.dav_name) FROM caldav_data WHERE collection_id = :collection_id", $params )
davical-1.1.9.3/inc/caldav-DELETE.php:34: && $qry->QDo("DELETE FROM property WHERE dav_name LIKE (SELECT dav_name FROM collection WHERE collection_id = :collection_id) || '%'", $params )
davical-1.1.9.3/inc/caldav-DELETE.php:35: && $qry->QDo("DELETE FROM locks WHERE dav_name LIKE (SELECT dav_name FROM collection WHERE collection_id = :collection_id) || '%'", $params )
davical-1.1.9.3/inc/caldav-DELETE.php:36: && $qry->QDo("DELETE FROM caldav_data WHERE collection_id = :collection_id", $params )
davical-1.1.9.3/inc/caldav-DELETE.php:37: && $qry->QDo("DELETE FROM collection WHERE collection_id = :collection_id", $params ) ) {
davical-1.1.9.3/inc/caldav-DELETE.php-38- @dbg_error_log( "DELETE", "DELETE (collection): User: %d, ETag: %s, Path: %s", $session->user_no, $request->etag_if_match, $request->path);
##############################################
davical-1.1.9.3/inc/caldav-DELETE.php-60-
davical-1.1.9.3/inc/caldav-DELETE.php:61: if ( $qry->QDo("DELETE FROM dav_binding WHERE dav_name = :dav_name", $params )
davical-1.1.9.3/inc/caldav-DELETE.php-62- && $qry->Commit() ) {
##############################################
davical-1.1.9.3/inc/caldav-DELETE.php-95- $params = array( ':dav_id' => $dav_resource->resource_id() );
davical-1.1.9.3/inc/caldav-DELETE.php:96: if ( $qry->QDo("DELETE FROM property WHERE dav_name = (SELECT dav_name FROM caldav_data WHERE dav_id = :dav_id)", $params )
davical-1.1.9.3/inc/caldav-DELETE.php:97: && $qry->QDo("DELETE FROM locks WHERE dav_name = (SELECT dav_name FROM caldav_data WHERE dav_id = :dav_id)", $params )
davical-1.1.9.3/inc/caldav-DELETE.php:98: && $qry->QDo("SELECT write_sync_change(collection_id, 404, caldav_data.dav_name) FROM caldav_data WHERE dav_id = :dav_id", $params )
davical-1.1.9.3/inc/caldav-DELETE.php:99: && $qry->QDo("DELETE FROM caldav_data WHERE dav_id = :dav_id", $params ) ) {
davical-1.1.9.3/inc/caldav-DELETE.php-100-
##############################################
davical-1.1.9.3/inc/caldav-REPORT-principal-match.php-59-$responses = array();
davical-1.1.9.3/inc/caldav-REPORT-principal-match.php:60:if ( $qry->Exec("REPORT",__LINE__,__FILE__) && $qry->rows() > 0 ) {
davical-1.1.9.3/inc/caldav-REPORT-principal-match.php-61- while( $row = $qry->Fetch() ) {
##############################################
davical-1.1.9.3/inc/schedule-functions.php-89- $qry = new AwlQuery($sql, $organizer_principal->user_no(), $uid);
davical-1.1.9.3/inc/schedule-functions.php:90: if ( !$qry->Exec('schedule',__LINE__,__FILE__) || $qry->rows() < 1 ) {
davical-1.1.9.3/inc/schedule-functions.php-91- dbg_error_log( 'schedule', 'Could not find original event from organizer - giving up on REPLY.' );
##############################################
davical-1.1.9.3/inc/schedule-functions.php-306- $qry = new AwlQuery($sql, $attendee_principal->user_no(), $uid);
davical-1.1.9.3/inc/schedule-functions.php:307: if ( !$qry->Exec('schedule',__LINE__,__FILE__) || $qry->rows() < 1 ) {
davical-1.1.9.3/inc/schedule-functions.php-308- dbg_error_log( 'schedule', 'Could not find ATTENDEE copy of original event - not trying to DELETE it!' );
##############################################
davical-1.1.9.3/inc/caldav-REPORT-multiget.php-67-
davical-1.1.9.3/inc/caldav-REPORT-multiget.php:68:$where = " WHERE caldav_data.collection_id = " . $collection->resource_id();
davical-1.1.9.3/inc/caldav-REPORT-multiget.php:69:$where .= " AND caldav_data.dav_name IN ( $href_in ) ";
davical-1.1.9.3/inc/caldav-REPORT-multiget.php-70-
##############################################
davical-1.1.9.3/inc/caldav-REPORT-multiget.php-88-$qry = new AwlQuery( $sql . $where, $params );
davical-1.1.9.3/inc/caldav-REPORT-multiget.php:89:if ( $qry->Exec('REPORT',__LINE__,__FILE__) && $qry->rows() > 0 ) {
davical-1.1.9.3/inc/caldav-REPORT-multiget.php-90- while( $dav_object = $qry->Fetch() ) {
##############################################
davical-1.1.9.3/inc/DAVResource.php-378- $qry = new AwlQuery( $sql, $params );
davical-1.1.9.3/inc/DAVResource.php:379: if ( $qry->Exec('DAVResource') && $qry->rows() == 1 && ($row = $qry->Fetch()) ) {
davical-1.1.9.3/inc/DAVResource.php-380- $this->collection = $row;
##############################################
davical-1.1.9.3/inc/DAVResource.php-409- $qry = new AwlQuery( $base_sql . ' dav_name = :raw_path', $params );
davical-1.1.9.3/inc/DAVResource.php:410: if ( $qry->Exec('DAVResource') && $qry->rows() == 1 && ($row = $qry->Fetch()) ) {
davical-1.1.9.3/inc/DAVResource.php-411- $this->collection = $row;
##############################################
davical-1.1.9.3/inc/DAVResource.php-461- $qry = new AwlQuery( $sql, $params );
davical-1.1.9.3/inc/DAVResource.php:462: if ( $qry->Exec('DAVResource',__LINE__,__FILE__) && $qry->rows() == 1 && ($row = $qry->Fetch()) ) {
davical-1.1.9.3/inc/DAVResource.php-463- $this->collection = $row;
##############################################
davical-1.1.9.3/inc/DAVResource.php-627- $qry = new AwlQuery( $sql, $params );
davical-1.1.9.3/inc/DAVResource.php:628: if ( $qry->Exec('DAVResource') && $qry->rows() > 0 ) {
davical-1.1.9.3/inc/DAVResource.php-629- $this->exists = true;
##############################################
davical-1.1.9.3/inc/DAVResource.php-647-
davical-1.1.9.3/inc/DAVResource.php:648: $qry = new AwlQuery('SELECT property_name, property_value FROM property WHERE dav_name= :dav_name', array(':dav_name' => $this->dav_name) );
davical-1.1.9.3/inc/DAVResource.php-649- if ( $qry->Exec('DAVResource') ) {
##############################################
davical-1.1.9.3/inc/DAVResource.php-1017- $qry = new AwlQuery( $sql, $params );
davical-1.1.9.3/inc/DAVResource.php:1018: if ( $qry->Exec('DAVResource',__LINE__,__FILE__) && $qry->rows() ) {
davical-1.1.9.3/inc/DAVResource.php-1019- while( $ticket = $qry->Fetch() ) {
##############################################
davical-1.1.9.3/inc/DAVResource.php-1357- $qry = new AwlQuery($sql, $params );
davical-1.1.9.3/inc/DAVResource.php:1358: if ( !$qry->Exec() || !$row = $qry->Fetch() ) {
davical-1.1.9.3/inc/DAVResource.php-1359- if ( !$qry->QDo('SELECT new_sync_token( 0, :collection_id) AS sync_token', $params) ) throw new Exception('Problem with database query');
##############################################
davical-1.1.9.3/inc/DAVResource.php-1400- array( ':parent_name' => $this->collection->parent_container ) );
davical-1.1.9.3/inc/DAVResource.php:1401: if ( $qry->Exec('DAVResource') && $qry->rows() > 0 && $parent = $qry->Fetch() ) {
davical-1.1.9.3/inc/DAVResource.php-1402- if ( $parent->is_calendar == 't' )
##############################################
davical-1.1.9.3/inc/DAVResource.php-1452- ':principal_id' => $this->principal->principal_id() ) );
davical-1.1.9.3/inc/DAVResource.php:1453: if ( $qry->Exec('DAVResource') && $qry->rows() > 0 ) {
davical-1.1.9.3/inc/DAVResource.php-1454- $by_collection = null;
##############################################
davical-1.1.9.3/inc/DAVResource.php-1604- $parents = array();
davical-1.1.9.3/inc/DAVResource.php:1605: if ( $qry->Exec('DAVResource',__LINE__,__FILE__) && $qry->rows() > 0 ) {
davical-1.1.9.3/inc/DAVResource.php-1606- while( $row = $qry->Fetch() ) {
##############################################
davical-1.1.9.3/inc/caldav-REPORT-sync-collection.php-61-$qry = new AwlQuery($sql, $params);
davical-1.1.9.3/inc/caldav-REPORT-sync-collection.php:62:if ( !$qry->Exec("REPORT",__LINE__,__FILE__) || $qry->rows() <= 0 ) {
davical-1.1.9.3/inc/caldav-REPORT-sync-collection.php-63- $request->DoResponse( 500, translate("Database error") );
##############################################
davical-1.1.9.3/inc/caldav-REPORT-sync-collection.php-96- LEFT JOIN addressbook_resource USING (dav_id)
davical-1.1.9.3/inc/caldav-REPORT-sync-collection.php:97: WHERE collection.collection_id = :collection_id $hide_older $hide_todo
davical-1.1.9.3/inc/caldav-REPORT-sync-collection.php-98- ORDER BY collection.collection_id, caldav_data.dav_id
##############################################
davical-1.1.9.3/inc/caldav-REPORT-sync-collection.php-108- LEFT JOIN addressbook_resource USING (dav_id)
davical-1.1.9.3/inc/caldav-REPORT-sync-collection.php:109: WHERE collection.collection_id = :collection_id $hide_older $hide_todo
davical-1.1.9.3/inc/caldav-REPORT-sync-collection.php-110- AND sync_time >= (SELECT modification_time FROM sync_tokens WHERE sync_token = :sync_token)
##############################################
davical-1.1.9.3/inc/HTTPAuthSession.php-361- array( ':user_no' => $this->user_no) );
davical-1.1.9.3/inc/HTTPAuthSession.php:362: if ( $qry->Exec('BasicAuth') && $qry->rows() > 0 ) {
davical-1.1.9.3/inc/HTTPAuthSession.php-363- while( $role = $qry->Fetch() ) {
##############################################
davical-1.1.9.3/inc/caldav-REPORT-cardquery.php-279-$params = array();
davical-1.1.9.3/inc/caldav-REPORT-cardquery.php:280:$where = ' WHERE caldav_data.collection_id = ' . $target_collection->resource_id();
davical-1.1.9.3/inc/caldav-REPORT-cardquery.php-281-if ( is_array($qry_filters) ) {
##############################################
davical-1.1.9.3/inc/caldav-REPORT-cardquery.php-294- if ( $appended_where_counter == 0 ) {
davical-1.1.9.3/inc/caldav-REPORT-cardquery.php:295: $where .= ' AND (' . $filter_fragment_sql;
davical-1.1.9.3/inc/caldav-REPORT-cardquery.php-296- $params = $filter_fragment['params'];
davical-1.1.9.3/inc/caldav-REPORT-cardquery.php-297- } else {
davical-1.1.9.3/inc/caldav-REPORT-cardquery.php:298: $where .= ' ' . $qry_filters_combination . ' ' . $filter_fragment_sql;
davical-1.1.9.3/inc/caldav-REPORT-cardquery.php-299- $params = array_merge( $params, $filter_fragment['params'] );
##############################################
davical-1.1.9.3/inc/caldav-REPORT-cardquery.php-323-$qry = new AwlQuery( $sql, $params );
davical-1.1.9.3/inc/caldav-REPORT-cardquery.php:324:if ( $qry->Exec("cardquery",__LINE__,__FILE__) && $qry->rows() > 0 ) {
davical-1.1.9.3/inc/caldav-REPORT-cardquery.php-325- while( $address_object = $qry->Fetch() ) {
##############################################
davical-1.1.9.3/inc/caldav-PROPFIND.php-145- array(':this_dav_name' => $bound_from));
davical-1.1.9.3/inc/caldav-PROPFIND.php:146: if( $qry->Exec('PROPFIND',__LINE__,__FILE__) && $qry->rows() > 0 ) {
davical-1.1.9.3/inc/caldav-PROPFIND.php-147- while( $binding = $qry->Fetch() ) {
##############################################
davical-1.1.9.3/inc/caldav-PROPFIND.php-173-
davical-1.1.9.3/inc/caldav-PROPFIND.php:174: if( $qry->Exec('PROPFIND',__LINE__,__FILE__) && $qry->rows() > 0 ) {
davical-1.1.9.3/inc/caldav-PROPFIND.php-175- while( $subcollection = $qry->Fetch() ) {
##############################################
davical-1.1.9.3/inc/caldav-PROPFIND.php-231- $sql .= 'LEFT JOIN collection USING(collection_id,user_no) LEFT JOIN principal USING(user_no) ';
davical-1.1.9.3/inc/caldav-PROPFIND.php:232: $sql .= 'WHERE collection.dav_name = :collection_dav_name '.$time_limit_clause.' '.$todo_clause.' '.$privacy_clause;
davical-1.1.9.3/inc/caldav-PROPFIND.php-233- if ( isset($c->strict_result_ordering) && $c->strict_result_ordering ) $sql .= " ORDER BY caldav_data.dav_id";
davical-1.1.9.3/inc/caldav-PROPFIND.php-234- $qry = new AwlQuery( $sql, array( ':collection_dav_name' => $bound_from) );
davical-1.1.9.3/inc/caldav-PROPFIND.php:235: if( $qry->Exec('PROPFIND',__LINE__,__FILE__) && $qry->rows() > 0 ) {
davical-1.1.9.3/inc/caldav-PROPFIND.php-236- while( $item = $qry->Fetch() ) {
##############################################
davical-1.1.9.3/inc/always.php.in-200-if ( @file_exists('/etc/davical/'.$_SERVER['SERVER_NAME'].'-conf.php') ) {
davical-1.1.9.3/inc/always.php.in:201: include('/etc/davical/'.$_SERVER['SERVER_NAME'].'-conf.php');
davical-1.1.9.3/inc/always.php.in-202-}
##############################################
davical-1.1.9.3/inc/always.php.in-206-else if ( @file_exists('/usr/local/etc/davical/'.$_SERVER['SERVER_NAME'].'-conf.php') ) {
davical-1.1.9.3/inc/always.php.in:207: include('/usr/local/etc/davical/'.$_SERVER['SERVER_NAME'].'-conf.php');
davical-1.1.9.3/inc/always.php.in-208-}
##############################################
davical-1.1.9.3/inc/always.php.in-309-$qry = new AwlQuery( 'SELECT schema_major, schema_minor, schema_patch FROM awl_db_revision ORDER BY schema_id DESC LIMIT 1;' );
davical-1.1.9.3/inc/always.php.in:310:if ( $qry->Exec('always',__LINE__,__FILE__) && $row = $qry->Fetch() ) {
davical-1.1.9.3/inc/always.php.in:311: $c->schema_version = doubleval( sprintf( '%d%03d.%03d', $row->schema_major, $row->schema_minor, $row->schema_patch) );
davical-1.1.9.3/inc/always.php.in:312: $c->wanted_version = doubleval( sprintf( '%d%03d.%03d', $c->want_dbversion[0], $c->want_dbversion[1], $c->want_dbversion[2]) );
davical-1.1.9.3/inc/always.php.in-313- $c->schema_major = $row->schema_major;
##############################################
davical-1.1.9.3/inc/external-fetch.php-56- $qry = new AwlQuery( $sql, $params );
davical-1.1.9.3/inc/external-fetch.php:57: if ( $qry->Exec('DAVResource') && $qry->rows() > 0 && $row = $qry->Fetch() ) {
davical-1.1.9.3/inc/external-fetch.php-58- $curl = curl_init ( $row->external_url );
##############################################
davical-1.1.9.3/inc/external-fetch.php-69- dbg_error_log("external", "checking external resource for remote changes " . $row->external_url );
davical-1.1.9.3/inc/external-fetch.php:70: $ics = curl_exec ( $curl );
davical-1.1.9.3/inc/external-fetch.php-71- $info = curl_getinfo ( $curl );
##############################################
davical-1.1.9.3/inc/external-fetch.php-75- // BUGlet: should track server-time instead of local-time
davical-1.1.9.3/inc/external-fetch.php:76: $qry = new AwlQuery( 'UPDATE collection SET modified=NOW() WHERE collection_id = :cid', array ( ':cid' => $row->collection_id ) );
davical-1.1.9.3/inc/external-fetch.php-77- $qry->Exec('DAVResource');
##############################################
davical-1.1.9.3/inc/external-fetch.php-86- curl_setopt ( $curl, CURLOPT_HEADER, false );
davical-1.1.9.3/inc/external-fetch.php:87: $ics = curl_exec ( $curl );
davical-1.1.9.3/inc/external-fetch.php-88- if ( is_string ( $ics ) && strlen ( $ics ) > 20 ) {
##############################################
davical-1.1.9.3/inc/external-fetch.php-122- dbg_error_log("external", "checking if external resource needs update");
davical-1.1.9.3/inc/external-fetch.php:123: if ( $qry->Exec('DAVResource') && $qry->rows() > 0 && $row = $qry->Fetch() ) {
davical-1.1.9.3/inc/external-fetch.php-124- if ( $row->bind_id != 0 ) {
##############################################
davical-1.1.9.3/inc/drivers_ldap.php-528-
davical-1.1.9.3/inc/drivers_ldap.php:529: $qry = new AwlQuery( "UPDATE dav_principal set type_id = 3 WHERE username=:group ",array(':group'=>$group) );
davical-1.1.9.3/inc/drivers_ldap.php-530- $qry->Exec('sync_LDAP',__LINE__,__FILE__);
##############################################
davical-1.1.9.3/inc/drivers_ldap.php-549- foreach ( $add_users as $member ){
davical-1.1.9.3/inc/drivers_ldap.php:550: $qry = new AwlQuery( "INSERT INTO group_member SELECT g.principal_id AS group_id,u.principal_id AS member_id FROM dav_principal g, dav_principal u WHERE g.username=:group AND u.username=:member",array (':group'=>$group,':member'=>$member) );
davical-1.1.9.3/inc/drivers_ldap.php-551- $qry->Exec('sync_LDAP_groups',__LINE__,__FILE__);
##############################################
davical-1.1.9.3/inc/drivers_ldap.php-558- foreach ( $remove_users as $member ){
davical-1.1.9.3/inc/drivers_ldap.php:559: $qry = new AwlQuery( "DELETE FROM group_member USING dav_principal g,dav_principal m WHERE group_id=g.principal_id AND member_id=m.principal_id AND g.username=:group AND m.username=:member",array (':group'=>$group,':member'=>$member) );
davical-1.1.9.3/inc/drivers_ldap.php-560- $qry->Exec('sync_LDAP_groups',__LINE__,__FILE__);
##############################################
davical-1.1.9.3/inc/drivers_ldap.php-572- } else {
davical-1.1.9.3/inc/drivers_ldap.php:573: $qry = new AwlQuery( 'UPDATE dav_principal SET user_active=FALSE WHERE username=:group AND type_id = 3',array(':group'=>$group) );
davical-1.1.9.3/inc/drivers_ldap.php-574- $qry->Exec('sync_LDAP',__LINE__,__FILE__);
##############################################
davical-1.1.9.3/inc/caldav-PUT-functions.php-156-
davical-1.1.9.3/inc/caldav-PUT-functions.php:157: if( $qry->Exec('PUT',__LINE__,__FILE__) && $qry->rows() == 1 ) {
davical-1.1.9.3/inc/caldav-PUT-functions.php-158- $collection = $qry->Fetch();
##############################################
davical-1.1.9.3/inc/caldav-PUT-functions.php-346- $qry = new AwlQuery($sql,$organizer_principal->user_no(), $uid);
davical-1.1.9.3/inc/caldav-PUT-functions.php:347: if ( !$qry->Exec('PUT',__LINE__,__FILE__) || $qry->rows() < 1 ) {
davical-1.1.9.3/inc/caldav-PUT-functions.php-348- dbg_error_log( 'PUT', 'Could not find original event from organizer - giving up on REPLY.' );
##############################################
davical-1.1.9.3/inc/caldav-PUT-functions.php-428- $qry = new AwlQuery($sql,$attendee_principal->user_no(), $uid);
davical-1.1.9.3/inc/caldav-PUT-functions.php:429: if ( !$qry->Exec('PUT',__LINE__,__FILE__) || $qry->rows() < 1 ) {
davical-1.1.9.3/inc/caldav-PUT-functions.php-430- dbg_error_log( 'PUT', "Could not find attendee's event %s", $uid );
##############################################
davical-1.1.9.3/inc/caldav-PUT-functions.php-531- dbg_error_log( 'PUT', 'try to resolve local attendee %s', $localname);
davical-1.1.9.3/inc/caldav-PUT-functions.php:532: $qry = new AwlQuery('SELECT fullname, email FROM usr WHERE user_no = (SELECT user_no FROM principal WHERE type_id = 1 AND user_no = (SELECT user_no FROM usr WHERE lower(username) = (text(:username)))) UNION SELECT fullname, email FROM usr WHERE user_no IN (SELECT user_no FROM principal WHERE principal_id IN (SELECT member_id FROM group_member WHERE group_id = (SELECT principal_id FROM principal WHERE type_id = 3 AND user_no = (SELECT user_no FROM usr WHERE lower(username) = (text(:username))))))', array(':username' => strtolower($localname)));
davical-1.1.9.3/inc/caldav-PUT-functions.php:533: if ( $qry->Exec('PUT',__LINE__,__FILE__) && $qry->rows() >= 1 ) {
davical-1.1.9.3/inc/caldav-PUT-functions.php-534- dbg_error_log( 'PUT', 'resolved local name %s to %d individual attendees', $localname, $qry->rows());
##############################################
davical-1.1.9.3/inc/caldav-PUT-functions.php-621- $qry = new AwlQuery($sql,$schedule_target->user_no(), $uid);
davical-1.1.9.3/inc/caldav-PUT-functions.php:622: if ( !$qry->Exec('PUT',__LINE__,__FILE__) || $qry->rows() < 1 ) {
davical-1.1.9.3/inc/caldav-PUT-functions.php-623- dbg_error_log( 'PUT', "Could not find event in attendee's calendars" );
##############################################
davical-1.1.9.3/inc/caldav-PUT-functions.php-720- $qry = new AwlQuery($sql,$schedule_target->user_no(), $uid);
davical-1.1.9.3/inc/caldav-PUT-functions.php:721: if ( !$qry->Exec('PUT',__LINE__,__FILE__) || $qry->rows() < 1 ) {
davical-1.1.9.3/inc/caldav-PUT-functions.php-722- dbg_error_log( 'PUT', "Could not find event in attendee's calendars" );
##############################################
davical-1.1.9.3/inc/caldav-PUT-functions.php-817- $qry = new AwlQuery( $sql, array( ':dav_name' => $path) );
davical-1.1.9.3/inc/caldav-PUT-functions.php:818: if ( ! $qry->Exec('PUT',__LINE__,__FILE__) ) rollback_on_error( $caldav_context, $user_no, $path, 'Database error in: '.$sql );
davical-1.1.9.3/inc/caldav-PUT-functions.php-819- if ( ! $qry->rows() == 1 ) {
##############################################
davical-1.1.9.3/inc/caldav-PUT-functions.php-912- // Get the dav_id for this row
davical-1.1.9.3/inc/caldav-PUT-functions.php:913: $qry->QDo('SELECT dav_id FROM caldav_data WHERE dav_name = :dav_name ', array(':dav_name' => $dav_name));
davical-1.1.9.3/inc/caldav-PUT-functions.php-914- if ( $qry->rows() == 1 && $row = $qry->Fetch() ) {
##############################################
davical-1.1.9.3/inc/caldav-PUT-functions.php-929- $params[':dav_name'] = $dav_name;
davical-1.1.9.3/inc/caldav-PUT-functions.php:930: $qry->QDo('DELETE FROM caldav_data WHERE collection_id = :collection_id AND dav_name = :dav_name', $params);
davical-1.1.9.3/inc/caldav-PUT-functions.php-931- $qry->QDo('SELECT write_sync_change(:collection_id, 404, :dav_name)', $params);
##############################################
davical-1.1.9.3/inc/caldav-PUT-functions.php-977- $qry = new AwlQuery( $sql, array( ':displayname' => $displayname, ':dav_name' => $path) );
davical-1.1.9.3/inc/caldav-PUT-functions.php:978: if ( ! $qry->Exec('PUT',__LINE__,__FILE__) ) rollback_on_error( $caldav_context, $user_no, $path, 'Database error on: '.$sql );
davical-1.1.9.3/inc/caldav-PUT-functions.php-979- }
##############################################
davical-1.1.9.3/inc/caldav-PUT-functions.php-1008- $qry = new AwlQuery( $sql, array( ':dav_name' => $path) );
davical-1.1.9.3/inc/caldav-PUT-functions.php:1009: if ( ! $qry->Exec('PUT',__LINE__,__FILE__) ) rollback_on_error( $caldav_context, $user_no, $path, 'Database error on: '.$sql );
davical-1.1.9.3/inc/caldav-PUT-functions.php-1010- if ( ! $qry->rows() == 1 ) {
##############################################
davical-1.1.9.3/inc/caldav-PUT-functions.php-1116- // Get the dav_id for this row
davical-1.1.9.3/inc/caldav-PUT-functions.php:1117: $qry->QDo('SELECT dav_id FROM caldav_data WHERE dav_name = :dav_name ', array(':dav_name' => $dav_data_params[':dav_name']));
davical-1.1.9.3/inc/caldav-PUT-functions.php-1118- if ( $qry->rows() == 1 && $row = $qry->Fetch() ) {
##############################################
davical-1.1.9.3/inc/caldav-PUT-functions.php-1189- $params = array( ':tzid' => $tzid);
davical-1.1.9.3/inc/caldav-PUT-functions.php:1190: $qry = new AwlQuery('SELECT 1 FROM timezones WHERE tzid = :tzid', $params );
davical-1.1.9.3/inc/caldav-PUT-functions.php:1191: if ( $qry->Exec('PUT',__LINE__,__FILE__) && $qry->rows() == 0 ) {
davical-1.1.9.3/inc/caldav-PUT-functions.php-1192- $params[':olson_name'] = $olson;
##############################################
davical-1.1.9.3/inc/caldav-PUT-functions.php-1244- $params[':dav_name'] = $dav_name;
davical-1.1.9.3/inc/caldav-PUT-functions.php:1245: $qry->QDo('DELETE FROM caldav_data WHERE collection_id = :collection_id AND dav_name = :dav_name', $params);
davical-1.1.9.3/inc/caldav-PUT-functions.php-1246- $qry->QDo('SELECT write_sync_change(:collection_id, 404, :dav_name)', $params);
##############################################
davical-1.1.9.3/inc/caldav-PUT-functions.php-1265-function write_alarms( $dav_id, vComponent $ical ) {
davical-1.1.9.3/inc/caldav-PUT-functions.php:1266: $qry = new AwlQuery('DELETE FROM calendar_alarm WHERE dav_id = '.$dav_id );
davical-1.1.9.3/inc/caldav-PUT-functions.php-1267- $qry->Exec('PUT',__LINE__,__FILE__);
##############################################
davical-1.1.9.3/inc/caldav-PUT-functions.php-1328-function write_attendees( $dav_id, vCalendar $ical ) {
davical-1.1.9.3/inc/caldav-PUT-functions.php:1329: $qry = new AwlQuery('DELETE FROM calendar_attendee WHERE dav_id = '.$dav_id );
davical-1.1.9.3/inc/caldav-PUT-functions.php-1330- $qry->Exec('PUT',__LINE__,__FILE__);
##############################################
davical-1.1.9.3/inc/caldav-PUT-functions.php-1410- else {
davical-1.1.9.3/inc/caldav-PUT-functions.php:1411: $qry->QDo('SELECT dav_id, caldav_data FROM caldav_data WHERE dav_name = :dav_name ', array(':dav_name' => $path));
davical-1.1.9.3/inc/caldav-PUT-functions.php-1412- }
##############################################
davical-1.1.9.3/inc/caldav-PUT-functions.php-1578- $params = array( ':tzid' => $tzid);
davical-1.1.9.3/inc/caldav-PUT-functions.php:1579: $qry = new AwlQuery('SELECT 1 FROM timezones WHERE tzid = :tzid', $params );
davical-1.1.9.3/inc/caldav-PUT-functions.php:1580: if ( $qry->Exec('PUT',__LINE__,__FILE__) && $qry->rows() == 0 ) {
davical-1.1.9.3/inc/caldav-PUT-functions.php-1581- $params[':olson_name'] = $olson;
##############################################
davical-1.1.9.3/inc/caldav-PUT-vcard.php-146-
davical-1.1.9.3/inc/caldav-PUT-vcard.php:147: $qry->QDo("SELECT dav_id FROM caldav_data WHERE dav_name = :dav_name ", array(':dav_name' => $params[':dav_name']) );
davical-1.1.9.3/inc/caldav-PUT-vcard.php-148-}
##############################################
davical-1.1.9.3/inc/DAVTicket.php-85- );
davical-1.1.9.3/inc/DAVTicket.php:86: if ( $qry->Exec('DAVTicket',__LINE__,__FILE__) && $qry->rows() == 1 && $t = $qry->Fetch() ) {
davical-1.1.9.3/inc/DAVTicket.php-87- if ( ! $t->expired ) {
##############################################
davical-1.1.9.3/inc/DAVTicket.php-100- if ( isset($this->target_resource_id) ) {
davical-1.1.9.3/inc/DAVTicket.php:101: $qry = new AwlQuery( 'SELECT dav_name FROM caldav_data WHERE dav_id = :dav_id', array(':dav_id' => $this->target_resource_id ) );
davical-1.1.9.3/inc/DAVTicket.php:102: if ( $qry->Exec('DAVTicket',__LINE__,__FILE__) && $qry->rows() == 1 && $r = $qry->Fetch() ) {
davical-1.1.9.3/inc/DAVTicket.php-103- $this->dav_name = $r->dav_name;
##############################################
davical-1.1.9.3/inc/caldav-REPORT-calquery.php-323-else {
davical-1.1.9.3/inc/caldav-REPORT-calquery.php:324: $where = ' WHERE caldav_data.collection_id = ' . $target_collection->resource_id();
davical-1.1.9.3/inc/caldav-REPORT-calquery.php-325- $distinct = '';
##############################################
davical-1.1.9.3/inc/caldav-REPORT-calquery.php-332- if ( $filter_fragment !== false ) {
davical-1.1.9.3/inc/caldav-REPORT-calquery.php:333: $where .= ' '.$filter_fragment['sql'];
davical-1.1.9.3/inc/caldav-REPORT-calquery.php-334- $params = array_merge( $params, $filter_fragment['params']);
##############################################
davical-1.1.9.3/inc/caldav-REPORT-calquery.php-345-if ( isset($c->hide_older_than) && intval($c->hide_older_than > 0) ) {
davical-1.1.9.3/inc/caldav-REPORT-calquery.php:346: $where .= " AND (CASE WHEN caldav_data.caldav_type<>'VEVENT' OR calendar_item.dtstart IS NULL OR calendar_item.rrule IS NOT NULL THEN true ELSE calendar_item.dtstart > (now() - interval '".intval($c->hide_older_than)." days') END) ";
davical-1.1.9.3/inc/caldav-REPORT-calquery.php-347-}
##############################################
davical-1.1.9.3/inc/caldav-REPORT-calquery.php-351-$qry = new AwlQuery( $sql, $params );
davical-1.1.9.3/inc/caldav-REPORT-calquery.php:352:if ( $qry->Exec("calquery",__LINE__,__FILE__) && $qry->rows() > 0 ) {
davical-1.1.9.3/inc/caldav-REPORT-calquery.php-353- while( $dav_object = $qry->Fetch() ) {
##############################################
davical-1.1.9.3/inc/WritableCollection.php-73- else {
davical-1.1.9.3/inc/WritableCollection.php:74: $qry->QDo('SELECT dav_id FROM caldav_data WHERE dav_name = :dav_name ', array(':dav_name' => $path));
davical-1.1.9.3/inc/WritableCollection.php-75- }
##############################################
davical-1.1.9.3/inc/WritableCollection.php-323- function WriteCalendarAlarms( $dav_id, vCalendar $vcal ) {
davical-1.1.9.3/inc/WritableCollection.php:324: $qry = new AwlQuery('DELETE FROM calendar_alarm WHERE dav_id = '.$dav_id );
davical-1.1.9.3/inc/WritableCollection.php-325- $qry->Exec('PUT',__LINE__,__FILE__);
##############################################
davical-1.1.9.3/inc/WritableCollection.php-386- function WriteCalendarAttendees( $dav_id, vCalendar $vcal ) {
davical-1.1.9.3/inc/WritableCollection.php:387: $qry = new AwlQuery('DELETE FROM calendar_attendee WHERE dav_id = '.$dav_id );
davical-1.1.9.3/inc/WritableCollection.php-388- $qry->Exec('PUT',__LINE__,__FILE__);
##############################################
davical-1.1.9.3/inc/WritableCollection.php-440-
davical-1.1.9.3/inc/WritableCollection.php:441: if ( $qry->QDo("SELECT write_sync_change(collection_id, 404, caldav_data.dav_name) FROM caldav_data WHERE dav_name = :dav_name", $params )
davical-1.1.9.3/inc/WritableCollection.php:442: && $qry->QDo("DELETE FROM property WHERE dav_name = :dav_name", $params )
davical-1.1.9.3/inc/WritableCollection.php:443: && $qry->QDo("DELETE FROM locks WHERE dav_name = :dav_name", $params )
davical-1.1.9.3/inc/WritableCollection.php:444: && $qry->QDo("DELETE FROM caldav_data WHERE dav_name = :dav_name", $params ) ) {
davical-1.1.9.3/inc/WritableCollection.php-445- @dbg_error_log( "DELETE", "DELETE: Calendar member %s deleted from calendar '%s'", $member_dav_name, $this->dav_name() );
##############################################
davical-1.1.9.3/inc/WritableCollection.php-492- $changes = array();
davical-1.1.9.3/inc/WritableCollection.php:493: if ( $qry->Exec('WritableCollection') && $qry->rows() ) {
davical-1.1.9.3/inc/WritableCollection.php-494- while( $change = $qry->Fetch() ) {
##############################################
davical-1.1.9.3/inc/iSchedule.php-446- curl_setopt ( $curl, CURLOPT_CUSTOMREQUEST, 'POST' );
davical-1.1.9.3/inc/iSchedule.php:447: $xmlresponse = curl_exec ( $curl );
davical-1.1.9.3/inc/iSchedule.php-448- $info = curl_getinfo ( $curl );
##############################################
davical-1.1.9.3/inc/caldav-BIND.php-55- $qry = new AwlQuery( );
davical-1.1.9.3/inc/caldav-BIND.php:56: $qry->QDo('SELECT collection_id FROM collection WHERE dav_name = :dav_name ', array( ':dav_name' => '/.external/'. md5($href) ));
davical-1.1.9.3/inc/caldav-BIND.php-57- if ( $qry->rows() == 1 && ($row = $qry->Fetch()) ) {
##############################################
davical-1.1.9.3/inc/caldav-BIND.php-61- create_external ( '/.external/'. md5($href) ,true,false );
davical-1.1.9.3/inc/caldav-BIND.php:62: $qry->QDo('SELECT collection_id FROM collection WHERE dav_name = :dav_name ', array( ':dav_name' => '/.external/'. md5($href) ));
davical-1.1.9.3/inc/caldav-BIND.php-63- if ( $qry->rows() != 1 || !($row = $qry->Fetch()) )
##############################################
davical-1.1.9.3/inc/caldav-BIND.php-81- if ( $qry->Exec('BIND',__LINE__,__FILE__) ) {
davical-1.1.9.3/inc/caldav-BIND.php:82: $qry = new AwlQuery( 'SELECT bind_id from dav_binding where dav_name = :dav_name', array( ':dav_name' => $destination_path ) );
davical-1.1.9.3/inc/caldav-BIND.php:83: if ( ! $qry->Exec('BIND',__LINE__,__FILE__) || $qry->rows() != 1 || !($row = $qry->Fetch()) )
davical-1.1.9.3/inc/caldav-BIND.php-84- $request->DoResponse(500,translate('Database Error'));
##############################################
davical-1.1.9.3/inc/drivers_pwauth_pam.php-55-
davical-1.1.9.3/inc/drivers_pwauth_pam.php:56: $pipe = popen(escapeshellarg($program), 'w');
davical-1.1.9.3/inc/drivers_pwauth_pam.php-57- $authinfo = sprintf("%s\n%s\n", $username, $password);
##############################################
davical-1.1.9.3/inc/freebusy-functions.php-46- $qry = new AwlQuery( $sql, $params );
davical-1.1.9.3/inc/freebusy-functions.php:47: if ( $qry->Exec("REPORT",__LINE__,__FILE__) && $qry->rows() > 0 ) {
davical-1.1.9.3/inc/freebusy-functions.php-48- while( $calendar_object = $qry->Fetch() ) {
##############################################
davical-1.1.9.3/inc/DAViCalSession.php-74- // If they don't have a principal_id set then we should re-read from our local database
davical-1.1.9.3/inc/DAViCalSession.php:75: $qry = new AwlQuery('SELECT * FROM dav_principal WHERE username = :username', array(':username' => $u->username) );
davical-1.1.9.3/inc/DAViCalSession.php:76: if ( $qry->Exec() && $qry->rows() == 1 ) {
davical-1.1.9.3/inc/DAViCalSession.php-77- $u = $qry->Fetch();
##############################################
davical-1.1.9.3/inc/DAViCalSession.php-93- $this->roles = array();
davical-1.1.9.3/inc/DAViCalSession.php:94: $sql = 'SELECT role_name FROM roles JOIN role_member ON roles.role_no=role_member.role_no WHERE user_no = '.$this->user_no;
davical-1.1.9.3/inc/DAViCalSession.php-95- $qry = new AwlQuery( $sql );
davical-1.1.9.3/inc/DAViCalSession.php:96: if ( $qry->Exec('DAViCalSession') && $qry->rows() > 0 ) {
davical-1.1.9.3/inc/DAViCalSession.php-97- while( $role = $qry->Fetch() ) {
##############################################
davical-1.1.9.3/inc/DAViCalSession.php-101- // inherit the Admin role
davical-1.1.9.3/inc/DAViCalSession.php:102: $sql = 'SELECT role_name FROM (((group_member JOIN dav_principal first_dav_principal ON group_member.group_id=first_dav_principal.principal_id) JOIN role_member ON first_dav_principal.user_no=role_member.user_no) JOIN roles ON roles.role_no=role_member.role_no) JOIN dav_principal second_dav_principal ON group_member.member_id=second_dav_principal.principal_id WHERE second_dav_principal.user_no = '.$this->user_no;
davical-1.1.9.3/inc/DAViCalSession.php-103- $qry = new AwlQuery( $sql );
davical-1.1.9.3/inc/DAViCalSession.php:104: if ( $qry->Exec('DAViCalSession') && $qry->rows() > 0 ) {
davical-1.1.9.3/inc/DAViCalSession.php-105- while( $role = $qry->Fetch() ) {
##############################################
davical-1.1.9.3/inc/drivers_squid_pam.php-53- $script);
davical-1.1.9.3/inc/drivers_squid_pam.php:54: $auth_result = exec($cmd);
davical-1.1.9.3/inc/drivers_squid_pam.php-55- if ( $auth_result == "OK") {
##############################################
davical-1.1.9.3/inc/ui/collection-edit.php-103- // operation we should only do if the collection timezone has been updated
davical-1.1.9.3/inc/ui/collection-edit.php:104: $tzqry = new AwlQuery( "SELECT timezone FROM collection WHERE collection_id=:id", [ ":id" => $id ] );
davical-1.1.9.3/inc/ui/collection-edit.php-105- $tzqry->Exec('collection-edit',__LINE__,__FILE__);
##############################################
davical-1.1.9.3/inc/ui/collection-edit.php-156- $c->page_title = $editor->Title(translate('Collection').': '.$editor->Value('dav_displayname'));
davical-1.1.9.3/inc/ui/collection-edit.php:157: $entryqry = new AwlQuery( 'SELECT count(*) as count from caldav_data where collection_id='.$editor->Value('collection_id') );
davical-1.1.9.3/inc/ui/collection-edit.php-158- $entryqry->Exec('admin-collection-edit');
##############################################
davical-1.1.9.3/inc/ui/collection-edit.php-162- if ($can_write_collection) {
davical-1.1.9.3/inc/ui/collection-edit.php:163: $externalqry = new AwlQuery( 'SELECT external_url from dav_binding where bound_source_id=:id limit 1', array(':id' => $editor->Value('collection_id') ) );
davical-1.1.9.3/inc/ui/collection-edit.php-164- $externalqry->Exec('external-bind-url');
##############################################
davical-1.1.9.3/inc/ui/collection-edit.php-418- $grantrow->SetSubmitName( 'savegrantrow' );
davical-1.1.9.3/inc/ui/collection-edit.php:419: $grantrow->SetLookup( 'to_principal', 'SELECT principal_id, displayname FROM dav_principal WHERE principal_id NOT IN (SELECT member_id FROM group_member WHERE group_id = '.$id.') ORDER BY displayname' );
davical-1.1.9.3/inc/ui/collection-edit.php-420- if ( $can_write_collection ) {
##############################################
davical-1.1.9.3/inc/ui/principal-edit.php-61- dbg_error_log('admin-principal-edit',':handle_action: Allowed to delete collection %s for principal %d', $_GET['dav_name'], $id );
davical-1.1.9.3/inc/ui/principal-edit.php:62: $qry = new AwlQuery('DELETE FROM collection WHERE dav_name=?;', $_GET['dav_name'] );
davical-1.1.9.3/inc/ui/principal-edit.php-63- if ( $qry->Exec() ) {
##############################################
davical-1.1.9.3/inc/ui/principal-edit.php-87- dbg_error_log('admin-principal-edit',':handle_action: Allowed to delete principal %d -%s', $id );
davical-1.1.9.3/inc/ui/principal-edit.php:88: $qry = new AwlQuery('DELETE FROM dav_principal WHERE principal_id=?', $id );
davical-1.1.9.3/inc/ui/principal-edit.php-89- if ( $qry->Exec() ) {
##############################################
davical-1.1.9.3/inc/ui/principal-edit.php-113- dbg_error_log('admin-principal-edit',':handle_action: Allowed to delete ticket "%s" for principal %d', $_GET['ticket_id'], $id );
davical-1.1.9.3/inc/ui/principal-edit.php:114: $qry = new AwlQuery('DELETE FROM access_ticket WHERE ticket_id=?;', $_GET['ticket_id'] );
davical-1.1.9.3/inc/ui/principal-edit.php-115- if ( $qry->Exec() ) {
##############################################
davical-1.1.9.3/inc/ui/principal-edit.php-140- dbg_error_log('admin-principal-edit',':handle_action: Allowed to delete binding "%s" for principal %d', $_GET['bind_id'], $id );
davical-1.1.9.3/inc/ui/principal-edit.php:141: $qry = new AwlQuery('DELETE FROM dav_binding WHERE bind_id=?;', $_GET['bind_id'] );
davical-1.1.9.3/inc/ui/principal-edit.php-142- if ( $qry->Exec() ) {
##############################################
davical-1.1.9.3/inc/ui/principal-edit.php-522- $sql = 'SELECT principal_id, coalesce(displayname,fullname,username) FROM dav_principal ';
davical-1.1.9.3/inc/ui/principal-edit.php:523: $sql .= 'WHERE principal_id NOT IN (SELECT member_id FROM group_member WHERE group_id = '.$id.') ';
davical-1.1.9.3/inc/ui/principal-edit.php-524- $sql .= 'AND principal_id != '.$id;
##############################################
davical-1.1.9.3/inc/ui/principal-edit.php-625- }
davical-1.1.9.3/inc/ui/principal-edit.php:626: $grantrow->SetLookup( 'to_principal', 'SELECT principal_id, displayname FROM dav_principal WHERE user_active AND principal_id NOT IN (SELECT to_principal FROM grants WHERE by_principal = '.$id.$edit_grant_clause.') ORDER BY fullname' );
davical-1.1.9.3/inc/ui/principal-edit.php-627- if ( $can_write_principal ) {
##############################################
davical-1.1.9.3/inc/ui/principal-edit.php-764- $qry = new AwlQuery( $sql, $params );
davical-1.1.9.3/inc/ui/principal-edit.php:765: if ( $qry->Exec() && $qry->rows() > 0 ) {
davical-1.1.9.3/inc/ui/principal-edit.php-766- $row = $qry->Fetch();
##############################################
davical-1.1.9.3/inc/ui/principal-edit.php-945- }
davical-1.1.9.3/inc/ui/principal-edit.php:946: $qry = new AwlQuery('SELECT dav_name FROM collection where dav_name = :dav_name UNION SELECT dav_name FROM dav_binding WHERE dav_name = :dav_name', array( ':dav_name' => $dav_name) );
davical-1.1.9.3/inc/ui/principal-edit.php:947: if ( $qry->Exec('dav_name') && $qry->rows() > 0 ) {
davical-1.1.9.3/inc/ui/principal-edit.php-948- $c->messages[] = translate('A resource already exists at the destination.');
##############################################
davical-1.1.9.3/inc/ui/principal-edit.php-963- $path = '/.external/' . md5($href);
davical-1.1.9.3/inc/ui/principal-edit.php:964: $qry->QDo('SELECT collection_id FROM collection WHERE dav_name = :dav_name ', array( ':dav_name' => $path ));
davical-1.1.9.3/inc/ui/principal-edit.php-965- if ( $qry->rows() == 1 && ($row = $qry->Fetch()) ) {
##############################################
davical-1.1.9.3/inc/ui/principal-edit.php-984-
davical-1.1.9.3/inc/ui/principal-edit.php:985: $qry->QDo('SELECT collection_id FROM collection WHERE dav_name = :dav_name ', array( ':dav_name' => $path ));
davical-1.1.9.3/inc/ui/principal-edit.php-986- if ( $qry->rows() != 1 || !($row = $qry->Fetch()) ) {
##############################################
davical-1.1.9.3/inc/drivers_imap_pam.php-82- $cmd = "getent passwd '$username'";
davical-1.1.9.3/inc/drivers_imap_pam.php:83: $getent_res = exec($cmd);
davical-1.1.9.3/inc/drivers_imap_pam.php-84- $getent_arr = explode(":", $getent_res);
##############################################
davical-1.1.9.3/inc/caldav-DELTICKET.php-40-
davical-1.1.9.3/inc/caldav-DELTICKET.php:41:$qry = new AwlQuery('DELETE FROM access_ticket WHERE ticket_id=:ticket_id', array( ':ticket_id' => $request->ticket->id() ) );
davical-1.1.9.3/inc/caldav-DELTICKET.php-42-if ( $qry->Exec('DELTICKET', __LINE__, __FILE__) ) {
##############################################
davical-1.1.9.3/inc/vtimezone.php-11- static function getInstance($name) {
davical-1.1.9.3/inc/vtimezone.php:12: $qry = new AwlQuery('SELECT * FROM timezones WHERE tzid = ? ORDER BY active DESC', $name);
davical-1.1.9.3/inc/vtimezone.php:13: if ( $qry->Exec('VTimezone',__LINE__,__FILE__) && $qry->rows() > 0 && $row = $qry->Fetch() ) {
davical-1.1.9.3/inc/vtimezone.php-14- $vtz = new vComponent($row->vtimezone);
##############################################
davical-1.1.9.3/inc/tz/list.php-16-$qry = new AwlQuery('SELECT to_char(max(last_modified),\'YYYY-MM-DD"T"HH24:MI:SS"Z"\') AS dtstamp FROM timezones');
davical-1.1.9.3/inc/tz/list.php:17:if ( $qry->Exec('tz/list',__LINE__,__FILE__) && $qry->rows() > 0 ) {
davical-1.1.9.3/inc/tz/list.php-18- $row = $qry->Fetch();
##############################################
davical-1.1.9.3/inc/tz/list.php-56-$qry = new AwlQuery($sql,$params);
davical-1.1.9.3/inc/tz/list.php:57:if ( $qry->Exec('tz/list',__LINE__,__FILE__) && $qry->rows() > 0 ) {
davical-1.1.9.3/inc/tz/list.php-58- while( $tz = $qry->Fetch() ) {
##############################################
davical-1.1.9.3/inc/tz/list.php-68- }
davical-1.1.9.3/inc/tz/list.php:69: if ( $q2->QDo('SELECT * FROM tz_aliases WHERE our_tzno = ?', array($tz->our_tzno)) ) {
davical-1.1.9.3/inc/tz/list.php-70- while( $alias = $q2->Fetch() ) {
##############################################
davical-1.1.9.3/inc/tz/list.php-73- }
davical-1.1.9.3/inc/tz/list.php:74: if ( !empty($lang) && $q2->QDo('SELECT * FROM tz_localnames WHERE our_tzno = ? AND locale = ?', array($tz->our_tzno, $lang)) && $q2->rows() > 0 ) {
davical-1.1.9.3/inc/tz/list.php-75- while( $local = $q2->Fetch() ) {
##############################################
davical-1.1.9.3/inc/tz/get.php-37-$vtz->AddProperty('TZNAME', $tz->olson_name );
davical-1.1.9.3/inc/tz/get.php:38:if ( $qry->QDo('SELECT * FROM tz_localnames WHERE our_tzno = :our_tzno', array(':our_tzno'=>$tz->our_tzno)) && $qry->rows() ) {
davical-1.1.9.3/inc/tz/get.php-39- while( $name = $qry->Fetch() ) {
##############################################
davical-1.1.9.3/inc/tz/expand.php-166-$qry = new AwlQuery('SELECT to_char(max(last_modified),\'YYYY-MM-DD"T"HH24:MI:SS"Z"\') AS dtstamp FROM timezones');
davical-1.1.9.3/inc/tz/expand.php:167:if ( $qry->Exec('tz/list',__LINE__,__FILE__) && $qry->rows() > 0 ) {
davical-1.1.9.3/inc/tz/expand.php-168- $row = $qry->Fetch();
##############################################
davical-1.1.9.3/inc/caldav-MOVE.php-94- if ( $dest->Exists() ) {
davical-1.1.9.3/inc/caldav-MOVE.php:95: $qry = new AwlQuery( 'DELETE FROM collection WHERE dav_name = :dst_name', array( ':dst_name' => $dst_name ) );
davical-1.1.9.3/inc/caldav-MOVE.php-96- if ( !$qry->Exec('move') ) rollback(500);
##############################################
davical-1.1.9.3/inc/caldav-MOVE.php-116- if ( $dest->Exists() ) {
davical-1.1.9.3/inc/caldav-MOVE.php:117: $qry = new AwlQuery( 'DELETE FROM caldav_data WHERE dav_name = :dst_name', array( ':dst_name' => $dst_name) );
davical-1.1.9.3/inc/caldav-MOVE.php-118- if ( !$qry->Exec('move') ) rollback(500);
##############################################
davical-1.1.9.3/dba/patches/1.2.1a.sql-72-UPDATE calendar_item SET collection_id = collection.collection_id
davical-1.1.9.3/dba/patches/1.2.1a.sql:73: FROM collection WHERE collection.dav_name = regexp_replace( calendar_item.dav_name, '/[^/]+$', '/');
davical-1.1.9.3/dba/patches/1.2.1a.sql-74-ALTER TABLE calendar_item ALTER COLUMN collection_id SET NOT NULL;
##############################################
davical-1.1.9.3/dba/patches/1.2.1a.sql-80-UPDATE caldav_data SET collection_id = collection.collection_id
davical-1.1.9.3/dba/patches/1.2.1a.sql:81: FROM collection WHERE collection.dav_name = regexp_replace( caldav_data.dav_name, '/[^/]+$', '/');
davical-1.1.9.3/dba/patches/1.2.1a.sql-82-ALTER TABLE caldav_data ALTER COLUMN collection_id SET NOT NULL;
##############################################
davical-1.1.9.3/dba/patches/1.2.1.sql-72-UPDATE calendar_item SET collection_id = collection.collection_id
davical-1.1.9.3/dba/patches/1.2.1.sql:73: FROM collection WHERE collection.dav_name = regexp_replace( calendar_item.dav_name, '/[^/]+$', '/');
davical-1.1.9.3/dba/patches/1.2.1.sql-74-ALTER TABLE calendar_item ALTER COLUMN collection_id SET NOT NULL;
##############################################
davical-1.1.9.3/dba/patches/1.2.1.sql-80-UPDATE caldav_data SET collection_id = collection.collection_id
davical-1.1.9.3/dba/patches/1.2.1.sql:81: FROM collection WHERE collection.dav_name = regexp_replace( caldav_data.dav_name, '/[^/]+$', '/');
davical-1.1.9.3/dba/patches/1.2.1.sql-82-ALTER TABLE caldav_data ALTER COLUMN collection_id SET NOT NULL;
##############################################
davical-1.1.9.3/dba/caldav_functions.sql-245-CREATE or REPLACE FUNCTION usr_is_role( INT, TEXT ) RETURNS BOOLEAN AS $$
davical-1.1.9.3/dba/caldav_functions.sql:246: SELECT EXISTS( SELECT 1 FROM role_member JOIN roles USING(role_no) WHERE role_member.user_no=$1 AND roles.role_name=$2 )
davical-1.1.9.3/dba/caldav_functions.sql-247-$$ LANGUAGE sql IMMUTABLE STRICT;
##############################################
davical-1.1.9.3/dba/caldav_functions.sql-902- RETURN QUERY
davical-1.1.9.3/dba/caldav_functions.sql:903: SELECT group_id FROM group_member WHERE member_id = $1
davical-1.1.9.3/dba/caldav_functions.sql-904- UNION
davical-1.1.9.3/dba/caldav_functions.sql-905- SELECT expanded.g_id FROM (SELECT expand_memberships( group_id, $2 - 1) AS g_id
davical-1.1.9.3/dba/caldav_functions.sql:906: FROM group_member WHERE member_id = $1) AS expanded
davical-1.1.9.3/dba/caldav_functions.sql-907- WHERE expanded.g_id IS NOT NULL;
##############################################
davical-1.1.9.3/dba/caldav_functions.sql-909- RETURN QUERY
davical-1.1.9.3/dba/caldav_functions.sql:910: SELECT group_id FROM group_member WHERE member_id = $1;
davical-1.1.9.3/dba/caldav_functions.sql-911- END IF;
##############################################
davical-1.1.9.3/dba/caldav_functions.sql-919- RETURN QUERY
davical-1.1.9.3/dba/caldav_functions.sql:920: SELECT member_id FROM group_member WHERE group_id = $1
davical-1.1.9.3/dba/caldav_functions.sql-921- UNION
davical-1.1.9.3/dba/caldav_functions.sql-922- SELECT expanded.m_id FROM (SELECT expand_members( member_id, $2 - 1) AS m_id
davical-1.1.9.3/dba/caldav_functions.sql:923: FROM group_member WHERE group_id = $1) AS expanded
davical-1.1.9.3/dba/caldav_functions.sql-924- WHERE expanded.m_id IS NOT NULL;
##############################################
davical-1.1.9.3/dba/caldav_functions.sql-926- RETURN QUERY
davical-1.1.9.3/dba/caldav_functions.sql:927: SELECT member_id FROM group_member WHERE group_id = $1;
davical-1.1.9.3/dba/caldav_functions.sql-928- END IF;
##############################################
davical-1.1.9.3/dba/caldav_functions.sql-1200- FROM grants
davical-1.1.9.3/dba/caldav_functions.sql:1201: WHERE by_collection IS NULL AND by_principal != $1
davical-1.1.9.3/dba/caldav_functions.sql:1202: AND by_principal IN (SELECT expand_members(g2.to_principal,$2) FROM grants g2 WHERE g2.by_principal = $1)
davical-1.1.9.3/dba/caldav_functions.sql-1203- ;
##############################################
davical-1.1.9.3/dba/update-davical-database-327- my $command = join ' ', @psql_opts;
davical-1.1.9.3/dba/update-davical-database:328: $last_results = `$command 2>&1 1>/dev/null`;
davical-1.1.9.3/dba/update-davical-database-329-
##############################################
davical-1.1.9.3/dba/create-database.sh-8-
davical-1.1.9.3/dba/create-database.sh:9:DBADIR="`dirname \"$0\"`"
davical-1.1.9.3/dba/create-database.sh-10-
##############################################
davical-1.1.9.3/dba/create-database.sh-43-# Get the major version for PostgreSQL
davical-1.1.9.3/dba/create-database.sh:44:export DBVERSION="`psql -qXAt ${PSQLOPTS} -c "SELECT version();" template1 | cut -f2 -d' ' | cut -f1-2 -d'.'`"
davical-1.1.9.3/dba/create-database.sh-45-
##############################################
davical-1.1.9.3/dba/create-database.sh-71-try_db_user() {
davical-1.1.9.3/dba/create-database.sh:72: [ "XtestX`psql -U "${1}" -qXAt ${PSQLOPTS} -c \"SELECT usename FROM pg_user;\" \"${DBNAME}\" 2>/dev/null`" != "XtestX" ]
davical-1.1.9.3/dba/create-database.sh-73-}
##############################################
davical-1.1.9.3/dba/create-database.sh-176-
davical-1.1.9.3/dba/create-database.sh:177:psql -qX ${PSQLOPTS} ${DBA} -c "UPDATE usr SET password = '**${ADMINPW}' WHERE user_no = 1;" "${DBNAME}"
davical-1.1.9.3/dba/create-database.sh-178-