Printf Inventory

List of all printf(), sprintf(), etc. formats strings mentioned in the code..

ValueCountFile:Line
'mysqli:host=%s;dbname=%s'
1
  • /roxlauncher/environmentexplorer.php
'<li class="%s"><a class="page-link" href="%s"%s>%s</a></li>'
1
  • /src/Pagerfanta/TwitterBootstrap4Template.php
"
            SELECT
                COUNT(*) cnt
            FROM
                members m,
                geonames g
            WHERE
                m.status = 'Active'
                AND m.MaxGuest >= 1
                AND m.IdCity = g.geonameId
                AND g.country = '%s'"
1
  • /build/places/places.model.php
"select members_groups_subscribed.id as IdSubscribe,IdThread,IdSubscriber from members_groups_subscribed where IdGroup=%d and IdSubscriber=%d"
1
  • /build/forums/forums.model.php
"select members_threads_subscribed.id as IdSubscribe,IdThread,IdSubscriber from members_threads_subscribed where IdThread=%d and IdSubscriber=%d"
1
  • /build/forums/forums.model.php
"AND `forums_threads`.`IdGroup` = '%d' "
1
  • /build/forums/forums.model.php
"%d%05d"
1
  • /lib/sphinx-2.2.10/sphinxapi.php
"searchd command v.%d.%d older than client's v.%d.%d, some options might not work"
1
  • /lib/sphinx-2.2.10/sphinxapi.php
"%.3f"
1
  • /lib/sphinx-2.2.10/sphinxapi.php
'Instances of "%s" are not supported.'
1
  • /src/Provider/UserProvider.php
'Username "%s" isn\'t unique.'
1
  • /src/Provider/UserProvider.php
'<li class="%s"><a class="page-link ajaxload" href="%s"%s>%s</a></li>'
1
  • /src/Pagerfanta/TwitterBootstrap4AjaxTemplate.php
'%s.%s = %s'
1
  • /src/Doctrine/Filter/LanguageFilter.php
"
DELETE
FROM members_threads_subscribed
WHERE id=%d
AND UnSubscribeKey='%s'
            "
1
  • /build/forums/forums.model.php
'$receiver must be an instance of %s or %s.'
1
  • /src/Service/Mailer.php
$uploadDirectory . 'placeholder_%d_%d.png'
1
  • /src/Controller/GalleryController.php
'Sent %d messages'
1
  • /src/Command/SendMassmailCommand.php
'Sent %d messages, skipped %d messages'
1
  • /src/Command/SendNotificationsCommand.php
'User with username "%s" not found.'
1
  • /src/Command/RefreshTokensExpireCommand.php
'RefreshTokens for user <comment>%s</comment> successfully expired.'
1
  • /src/Command/RefreshTokensExpireCommand.php
'%d'
1
  • /src/Model/DonateModel.php
'%s/translations'
1
  • /src/Model/TranslationModel.php
'%s/data/gallery/member%s/'
1
  • /src/Model/MemberDataExtractor/GalleryItemsExtractor.php
'private/%s.html.twig'
1
  • /src/Model/MemberDataExtractor/AbstractExtractor.php
'No routes found for "%s".'
1
  • /tools/routing/requestrouter.class.php
"
DELETE
FROM members_threads_subscribed
WHERE IdSubscriber=%d
AND IdThread=%d
            "
1
  • /build/forums/forums.model.php
"SELECT    `forums_posts`.`id` AS `postid`,`forums_posts`.`id` as IdPost, UNIX_TIMESTAMP(`create_time`) AS `posttime`,  `message`,
    `OwnerCanStillEdit`,`IdContent`,  `forums_threads`.`id` AS `threadid`,   `forums_threads`.`title`,
    `ThreadVisibility`,
    `ThreadDeleted`,
    `PostVisibility`,
    `PostDeleted`,
    `ThreadDeleted`,
    `forums_threads`.`IdTitle`,`forums_threads`.`IdGroup`,   `IdWriter`,   `members`.`Username` AS `OwnerUsername`, `groups`.`Name` AS `GroupName`,    `geonames`.`country`
        FROM (forums_posts, members, forums_threads, addresses)
LEFT JOIN `groups` ON (`forums_threads`.`IdGroup` = `groups`.`id`)
LEFT JOIN `geonames` ON (addresses.IdCity = geonames.geonameId)
WHERE `forums_posts`.`IdWriter` = %d AND `forums_posts`.`IdWriter` = `members`.`id`
AND `forums_posts`.`threadid` = `forums_threads`.`id`
AND addresses.IdMember = members.id AND addresses.rank = 0
AND ($this->PublicThreadVisibility)
AND ($this->PublicPostVisibility)
AND ($this->PostGroupsRestriction)
ORDER BY `posttime` DESC"
1
  • /build/forums/forums.model.php
"
SELECT
    members_threads_subscribed.id AS IdSubscribe,
    IdThread,
    IdSubscriber,
    Username from members,
    members_threads_subscribed
WHERE members.id=members_threads_subscribed.IdSubscriber
AND members_threads_subscribed.id=%d
AND UnSubscribeKey='%s'
            "
1
  • /build/forums/forums.model.php
"
SELECT
    `forums_posts`.`id` AS `postid`,
    UNIX_TIMESTAMP(`create_time`) AS `posttime`,
    `message`,
    `IdContent`,
    `members`.`Username` AS `OwnerUsername`,
    `IdWriter`,
     forums_threads.`id` as `threadid`,
    `PostVisibility`,
    `PostDeleted`,
    `ThreadDeleted`,
    `OwnerCanStillEdit`,
    `geonames`.`name` as `city`,
    `geonamescountries`.`name` as `country`,
    `IdGroup`
FROM forums_posts, forums_threads, members, addresses
LEFT JOIN `geonames` ON (addresses.IdCity = `geonames`.`geonameId`)
LEFT JOIN `geonamescountries` ON (geonames.country = `geonamescountries`.`country`)
WHERE `forums_posts`.`threadid` = '%d' AND `forums_posts`.`IdWriter` = `members`.`id`
AND addresses.IdMember = members.id AND addresses.rank = 0
 AND `forums_posts`.`threadid`=`forums_threads`.`id`
    and ({$this->PublicPostVisibility})
    and ({$this->PublicThreadVisibility})
    and ({$this->PostGroupsRestriction})
    and ThreadDeleted <> 'Deleted'
    And PostDeleted <> 'Deleted'
ORDER BY `posttime` DESC
LIMIT %d
            "
1
  • /build/forums/forums.model.php
"
            SELECT
                COUNT(*) cnt
            FROM
                members m,
                geonames g
            WHERE
                m.status = 'Active'
                AND m.MaxGuest >= 1
                AND m.IdCity = g.geonameId
                AND g.country = '%s'
                AND g.admin1 = '%s'"
1
  • /build/places/places.model.php
"
            SELECT
                COUNT(*) cnt
            FROM
                members m
            WHERE
                m.status = 'Active'
                AND m.MaxGuest >= 1
                AND m.IdCity = %s"
1
  • /build/places/places.model.php
"
            SELECT SQL_CALC_FOUND_ROWS
                m.BirthDate,
                m.HideBirthDate,
                m.Accomodation,
                m.idCity,
                m.username,
                IF(m.ProfileSummary != 0, 1, 0) AS HasProfileSummary
            FROM
                geonames g,
                members m
            WHERE
                m.Status = 'Active'
                AND m.MaxGuest >= 1
                AND g.geonameId = m.idCity
                AND g.country = '%s'
            ORDER BY
                m.Accomodation ASC, HasProfileSummary DESC, m.LastLogin DESC"
1
  • /build/places/places.model.php
"
            SELECT SQL_CALC_FOUND_ROWS
                m.BirthDate,
                m.HideBirthDate,
                m.Accomodation,
                m.username,
                m.idCity,
                IF(m.ProfileSummary != 0, 1, 0) AS HasProfileSummary
            FROM
                geonames g,
                members m
            WHERE
                m.Status = 'Active'
                AND m.MaxGuest >= 1
                AND m.idCity = g.geonameId
                AND g.admin1 = '%2\$s'
                AND g.country = '%1\$s'
                AND g.fclass = 'P'
            ORDER BY
                m.Accomodation ASC, HasProfileSummary DESC, m.LastLogin DESC"
1
  • /build/places/places.model.php
"
            SELECT SQL_CALC_FOUND_ROWS
                m.BirthDate,
                m.HideBirthDate,
                m.Accomodation,
                m.username,
                m.idCity,
                IF(m.ProfileSummary != 0, 1, 0) AS HasProfileSummary
            FROM
                geonames g,
                members m
            WHERE
                m.Status = 'Active'
                AND m.MaxGuest >= 1
                AND m.IdCity = g.geonameId
                AND g.geonameId = '%s'
            ORDER BY
                m.Accomodation ASC, HasProfileSummary DESC, m.LastLogin DESC"
1
  • /build/places/places.model.php
"SELECT * FROM (
            SELECT
                a.admin1 admin1, a.name region, 0 ispreferred, 0 isshort, 'geo' source
            FROM
                geonames a
            WHERE
                a.country = '%1\$s'
                AND a.fcode = 'ADM1'
            UNION SELECT
                ga.admin1 admin1, a.alternatename region, a.ispreferred ispreferred, a.isshort isshort, 'alt' source
            FROM
                geonames ga,
                geonamesalternatenames a
            WHERE
                ga.geonameId = a.geonameId
                AND ga.country = '%1\$s'
                AND ga.fcode = 'ADM1'
                AND a.isoLanguage = '%2\$s'
            ORDER BY
                admin1, isshort DESC, ispreferred DESC, source ASC, region ASC) x
            GROUP BY
                admin1
            "
1
  • /build/places/places.model.php
"
            SELECT
                COUNT(m.id) number,
                g.admin1 admin1
            FROM
                members m,
                geonames g
            WHERE
                g.country = '%1\$s'
                AND g.fclass = 'P'
                AND g.geonameId = m.IdCity
                AND m.Status = 'Active'
                AND m.MaxGuest >= 1
            GROUP BY
                g.admin1"
1
  • /build/places/places.model.php
"
            SELECT
                a.admin1, a.country
            FROM
                geonames a
            WHERE
                a.fcode = 'ADM1'
                AND a.admin1 = '%1\$s'
                AND a.country = '%2\$s'"
1
  • /build/places/places.model.php
"SELECT * FROM (
            SELECT geonameId, city, ispreferred,isshort, source,count(m.id) NbMember
            FROM (
                SELECT * from (
                    SELECT g.geonameId geonameId, a.alternatename city,
                        a.ispreferred ispreferred, a.isshort isshort, 'alt' source
                    FROM
                        geonamesalternatenames a,
                        geonames g
                    WHERE
                        g.country = '%1\$s'
                        AND g.admin1 = '%2\$s'
                        AND g.geonameId = a.geonameId
                        AND a.isoLanguage = '%3\$s'
                    ORDER BY isshort DESC, ispreferred DESC
                ) allA
            GROUP BY geonameId
            ) AByGid,
            members m
            WHERE m.idcity = AByGid.geonameId
                AND m.status = 'Active'
                AND m.MaxGuest >= 1
            GROUP BY geonameId
            UNION SELECT
                g.geonameId g, g.name AS city, 0 ispreferred, 0 isshort, 'geo' source, COUNT(m.id) NbMember
            FROM
                geonames g,
                members m
            WHERE
                g.country = '%1\$s'
                AND g.admin1 = '%2\$s'
                AND g.geonameId = m.IdCity
                AND m.status = 'Active'
                AND m.MaxGuest >= 1
            GROUP BY
                geonameId
            ORDER BY
                geonameId, isshort DESC, ispreferred DESC, source ASC, city ASC) ag
            GROUP BY
                geonameId
            "
1
  • /build/places/places.model.php
"%3.2f"
1
  • /build/admin/treasurer/templates/admintreasurer.column_col3.php
'This XML document is invalid, likely due to invalid characters. XML error: %s at line %d, column %d'
1
  • /build/admin/templates/simplepie/library/SimplePie.php
'Key "%s" found in %s at line %d'
1
  • /tools/translations/extractor.php
"UPDATE `forums_posts` SET `message` = '%s', `last_edittime` = NOW(), `last_editorid` = '%d', `edit_count` = `edit_count` + 1 WHERE `id` = '%d'"
1
  • /build/forums/forums.model.php
"%d"
1
  • /build/donate/donate.model.php
"
            SELECT
                `forums_posts`.`id` AS `postid`,
                forums_posts.id as IdPost,
                UNIX_TIMESTAMP(create_time) AS posttime,
                message,
                IdContent,
                IdWriter,
                geonames.name AS city,
                geonamescountries.name AS country,
                forums_posts.threadid,
                OwnerCanStillEdit,
                members.Username as OwnerUsername,
                PostVisibility,
                PostDeleted,
                forums_threads.IdGroup
            FROM
                forums_threads,
                forums_posts
            LEFT
                JOIN members ON forums_posts.IdWriter = members.id
            LEFT JOIN
                addresses AS a ON a.IdMember = members.id AND a.rank = 0
            LEFT JOIN
                geonames ON a.IdCity = geonames.geonameId
            LEFT JOIN
                geonamescountries ON geonames.country = geonamescountries.country
            WHERE
                forums_posts.threadid = '%d'
                AND forums_posts.threadid=forums_threads.id
                AND ({$this->PublicPostVisibility})
                AND ({$this->ThreadGroupsRestriction})
            ORDER BY
                posttime {$order}
            LIMIT %d, %d"
1
  • /build/forums/forums.model.php
"
INSERT INTO `forums_posts` ( `threadid`, `create_time`, `message`,`IdWriter`,`IdFirstLanguageUsed`,`PostVisibility`)
VALUES ('%d', NOW(), '%s','%d',%d,'%s')
            "
1
  • /build/forums/forums.model.php
"%s %3.2f"
1
  • /build/donate/templates/donate_list.php
", `last_postid` = '%d'"
1
  • /build/forums/forums.model.php
"
SELECT
    `forums_posts`.`threadid`,
    `forums_threads`.`first_postid`,
    `forums_threads`.`last_postid`,
    `forums_threads`.`expiredate`,
    `forums_threads`.`stickyvalue`
FROM `forums_posts`
LEFT JOIN `forums_threads` ON (`forums_posts`.`threadid` = `forums_threads`.`id`)
WHERE `forums_posts`.`id` = '%d'
                "
1
  • /build/forums/forums.model.php
"
UPDATE `forums_threads`
SET `title` = '%s'
WHERE `id` = '%d' "
1
  • /build/forums/forums.model.php
"%.1f MB"
2
  • /build/gallery/templates/uploadform.php
  • /build/members/templates/editprofile_form_basics.php
'%09d'
2
  • /modules/mail/lib/multipart.lib.php
  • /modules/mail/lib/multipart.lib.php
' rel="%s"'
2
  • /src/Pagerfanta/TwitterBootstrap4AjaxTemplate.php
  • /src/Pagerfanta/TwitterBootstrap4Template.php
'%u'
2
  • /build/admin/templates/simplepie/library/SimplePie/gzdecode.php
  • /build/admin/templates/simplepie/library/SimplePie/gzdecode.php
"%01.1f"
2
  • /build/admin/word/templates/adminwordshowlist.column_col3.php
  • /build/admin/word/templates/adminwordshowstatistics.column_col3.php
"%07.0f"
2
  • /lib/sphinx-2.2.10/sphinxapi.php
  • /lib/sphinx-2.2.10/sphinxapi.php
'<li class="%s"><span class="page-link">%s</span></li>'
2
  • /src/Pagerfanta/TwitterBootstrap4AjaxTemplate.php
  • /src/Pagerfanta/TwitterBootstrap4Template.php
'%%%02X'
2
  • /build/admin/templates/simplepie/library/SimplePie/IRI.php
  • /build/admin/templates/simplepie/library/SimplePie/IRI.php
"%4d (%3.1f%%)"
3
  • /build/polls/templates/seeresults.php
  • /build/polls/templates/seeresults.php
  • /build/polls/templates/seeresults.php
"%.0f"
5
  • /lib/sphinx-2.2.10/sphinxapi.php
  • /lib/sphinx-2.2.10/sphinxapi.php
  • /lib/sphinx-2.2.10/sphinxapi.php
  • /lib/sphinx-2.2.10/sphinxapi.php
  • /lib/sphinx-2.2.10/sphinxapi.php
"%u"
12
  • /lib/sphinx-2.2.10/sphinxapi.php
  • /lib/sphinx-2.2.10/sphinxapi.php
  • /lib/sphinx-2.2.10/sphinxapi.php
  • /lib/sphinx-2.2.10/sphinxapi.php
  • /lib/sphinx-2.2.10/sphinxapi.php
  • /lib/sphinx-2.2.10/sphinxapi.php
  • /lib/sphinx-2.2.10/sphinxapi.php
  • /lib/sphinx-2.2.10/sphinxapi.php
  • /lib/sphinx-2.2.10/sphinxapi.php
  • /lib/sphinx-2.2.10/sphinxapi.php
  • /lib/sphinx-2.2.10/sphinxapi.php
  • /lib/sphinx-2.2.10/sphinxapi.php