Antonio

Add new...
 
Added a discussion 

Is there a block with the profiles with the most followers?

Otherwise someone could tell me the sql query to get the list with the most followers. I have currently created a block with the users with the most visits but I want the same with the followers.

This is the query I do so far: $sql = "SELECT * FROM `bx_persons_data` WHERE `picture` > 0 ORDER BY `views` DESC LIMIT 25";

  • 251
    • Hello AntonioΒ  !

      By default. there is no such block. And your query will show the most "viewable" persons.

      πŸ’“0 πŸ˜†0 😲0 πŸ˜₯0 😠0 0
      • Hi LeonidSΒ 

        Could you help me with the query to get the most followed?

        πŸ’“0 πŸ˜†0 😲0 πŸ˜₯0 😠0 0
        • You may use the query from the Analytics app (modules/boonex/analytics/classes/BxAnalyticsDb.php):

          $sQuery = "SELECT `sys_profiles`.`content_id` AS `object_id`, `sys_profiles`.`type` , COUNT(`sys_profiles_conn_subscriptions`.`id`) AS `value` FROM `sys_profiles_conn_subscriptions`

          INNER JOIN `sys_profiles` ON `sys_profiles`.`id` = `sys_profiles_conn_subscriptions`.`content` WHERE sys_profiles.type='" . $sModuleName . "' AND `sys_profiles_conn_subscriptions`.`added` >= :datefrom AND `sys_profiles_conn_subscriptions`.`added` <= :dateto GROUP BY `sys_profiles`.`content_id`, `sys_profiles`.`type` ORDER BY COUNT(`sys_profiles_conn_subscriptions`.`id`) DESC LIMIT 0," . intval(getParam('bx_analytics_items_count'));


          πŸ’“0 πŸ˜†0 😲0 πŸ˜₯0 😠0 0
          Not logged in users can't 'Comments Post'.
          Added a discussion 

          Instead of adding a block with all the feeds I want a wall with only the channels.

          Would it be possible?

          • 227
          Added a discussion 

          After moving my UNA installation from a subdomain to the main domain I have the following errors:

          In studio

          Refused to apply style from '<URL>' because its MIME type ('text/html') is not a supported stylesheet MIME type, and strict MIME checking is enabled.

          gzip_loader.php?file=bx_templ_js_318fc208c7e02f2702b4eb39e9e8b1c5.js:13 JQMIGRATE: Migrate is installed, version 1.4.1

          plesk-ui-library.min.js:1 Failed to load resource: the server responded with a status of 404 ()

          vendors.js:1 Failed to load resource: the server responded with a status of 404 ()

          app.js:1 Failed to load resource: the server responded with a status of 404 ()

          uat.js:1 Failed to load resource: the server responded with a status of 404 ()

          main.js:1 Failed to load resource: the server responded with a status of 404 ()

          plesk-ui-library.min.js:1 Failed to load resource: the server responded with a status of 404 ()

          vendors.js:1 Failed to load resource: the server responded with a status of 404 ()

          main.js:1 Failed to load resource: the server responded with a status of 404 ()

          uat.js:1 Failed to load resource: the server responded with a status of 404 ()

          app.js:1 Failed to load resource: the server responded with a status of 404 ()

          plesk-ui-library.min.js:1 Failed to load resource: the server responded with a status of 404 ()

          vendors.js:1 Failed to load resource: the server responded with a status of 404 ()

          main.js:1 Failed to load resource: the server responded with a status of 404 ()

          uat.js:1 Failed to load resource: the server responded with a status of 404 ()

          app.js:1 Failed to load resource: the server responded with a status of 404 ()

          plesk-ui-library.min.js:1 Failed to load resource: the server responded with a status of 404 ()

          vendors.js:1 Failed to load resource: the server responded with a status of 404 ()

          main.js:1 Failed to load resource: the server responded with a status of 404 ()

          uat.js:1 Failed to load resource: the server responded with a status of 404 ()

          app.js:1 Failed to load resource: the server responded with a status of 404 ()

          plesk-ui-library.min.js:1 Failed to load resource: the server responded with a status of 404 ()

          vendors.js:1 Failed to load resource: the server responded with a status of 404 ()

          main.js:1 Failed to load resource: the server responded with a status of 404 ()

          uat.js:1 Failed to load resource: the server responded with a status of 404 ()

          app.js:1 Failed to load resource: the server responded with a status of 404 ()

          plesk-ui-library.min.js:1 Failed to load resource: the server responded with a status of 404 ()

          vendors.js:1 Failed to load resource: the server responded with a status of 404 ()

          main.js:1 Failed to load resource: the server responded with a status of 404 ()

          uat.js:1 Failed to load resource: the server responded with a status of 404 ()

          app.js:1 Failed to load resource: the server responded with a status of 404 ()

          plesk-ui-library.min.js:1 Failed to load resource: the server responded with a status of 404 ()

          vendors.js:1 Failed to load resource: the server responded with a status of 404 ()

          main.js:1 Failed to load resource: the server responded with a status of 404 ()

          uat.js:1 Failed to load resource: the server responded with a status of 404 ()

          app.js:1 Failed to load resource: the server responded with a status of 404 ()

          plesk-ui-library.min.js:1 Failed to load resource: the server responded with a status of 404 ()

          vendors.js:1 Failed to load resource: the server responded with a status of 404 ()

          main.js:1 Failed to load resource: the server responded with a status of 404 ()

          uat.js:1 Failed to load resource: the server responded with a status of 404 ()

          app.js:1 Failed to load resource: the server responded with a status of 404 ()

          plesk-ui-library.min.js:1 Failed to load resource: the server responded with a status of 404 ()

          vendors.js:1 Failed to load resource: the server responded with a status of 404 ()

          main.js:1 Failed to load resource: the server responded with a status of 404 ()

          uat.js:1 Failed to load resource: the server responded with a status of 404 ()

          app.js:1 Failed to load resource: the server responded with a status of 404 ()

          plesk-ui-library.min.js:1 Failed to load resource: the server responded with a status of 404 ()

          vendors.js:1 Failed to load resource: the server responded with a status of 404 ()

          main.js:1 Failed to load resource: the server responded with a status of 404 ()

          uat.js:1 Failed to load resource: the server responded with a status of 404 ()

          app.js:1 Failed to load resource: the server responded with a status of 404 ()

          plesk-ui-library.min.js:1 Failed to load resource: the server responded with a status of 404 ()

          vendors.js:1 Failed to load resource: the server responded with a status of 404 ()

          main.js:1 Failed to load resource: the server responded with a status of 404 ()

          uat.js:1 Failed to load resource: the server responded with a status of 404 ()

          app.js:1 Failed to load resource: the server responded with a status of 404 ()

          plesk-ui-library.min.js:1 Failed to load resource: the server responded with a status of 404 ()

          vendors.js:1 Failed to load resource: the server responded with a status of 404 ()

          main.js:1 Failed to load resource: the server responded with a status of 404 ()

          uat.js:1 Failed to load resource: the server responded with a status of 404 ()

          app.js:1 Failed to load resource: the server responded with a status of 404 ()

          plesk-ui-library.min.js:1 Failed to load resource: the server responded with a status of 404 ()

          vendors.js:1 Failed to load resource: the server responded with a status of 404 ()

          main.js:1 Failed to load resource: the server responded with a status of 404 ()

          uat.js:1 Failed to load resource: the server responded with a status of 404 ()

          app.js:1 Failed to load resource: the server responded with a status of 404 ()


          What can be the motive?

          • 282
            • Clearing cache should fix it. Clear cache via studio or better thru cpanel file manager. if not try to make new dB and user import your SQL file then update header.inc.php.


              If still having issues you can pm me site access I'll be happy to help you with troubleshooting your site.

              πŸ’“0 πŸ˜†0 😲0 πŸ˜₯0 😠0 0
              • It is very strange, the installation of Una works correctly in the subdomain, but if I move it to the domain it does not work.Β 

                In the main domain I have a Dolphin installation.

                In v2.domain.com I migrated to UNA and everything works correctly.

                How could i redirect in main domain's .htacces to v2.domain and keep seo?


                πŸ’“0 πŸ˜†0 😲0 πŸ˜₯0 😠0 0
                • Simply change header.inc.php URL from your main dolphin to your Una subdomain url.


                  For SEO as what I've read.


                  Google’s algorithms will recognize your subdomains as sites separate from your main domain, and rank them individually

                  πŸ’“0 πŸ˜†0 😲0 πŸ˜₯0 😠0 0
                  Not logged in users can't 'Comments Post'.
                  Added a product 

                  We perform personalized programming and design works. We work with UNA. We will always find the best solution for you.

                  Below it is shown, for you to get an idea, some works and general rates:

                  CUSTOMIZED THEME+SPLASH – 450€/500$ (ΒΏΒΏΒΏ5 to 6 days completions) Β Β 

                  IOS & ANDROID REBRAND - 750€/1000$Β 

                  Monthly Maintenance: from 250€/300$ to 1000??? (depending on the conditions and hours agreed)Β 

                  CUSTOM PHO FEATURES – 15€/20$ HOUR

                  Loose hours: 15€/20$

                  If you have any doubt do not hasite and contac us :_____ for a personal budget wit zero compromise.


                  • 435
                  Added a discussion 

                  Why is it that when I do a search for top profiles it doesn't return anything?

                  In a html block I use {~bx_persons:browse_recent_profiles[]~} and it works correctly.

                  Instead {~bx_persons:browse_top_profiles[]~} it does not return anything

                  • 297
                  Achievements

                  Jedi

                  Total points: 817.5

                  282.7 point(s) to reach
                  Info
                  Friends count:
                  Followers count:
                  Full Name:
                  Antonio
                  Membership
                  Premium
                  Antonio Products
                  Antonio Discussions
                  •  ·  251
                  •  · 
                  Is there a block with the profiles with the most followers?Otherwise someone could tell me the sql q…
                  •  · 
                  •  · 
                  •  · You may use the query from the Analytics app (modules/boonex/analytics/classes/BxAnalyticsDb.php):$s…
                  •  ·  227
                  Instead of adding a block with all the feeds I want a wall with only the channels.Would it be possib…
                  •  ·  282
                  •  · 
                  After moving my UNA installation from a subdomain to the main domain I have the following errors:In …
                  •  · 
                  •  · 
                  •  · Simply change header.inc.php URL from your main dolphin to your Una subdomain url.For SEO as what I'…
                  •  ·  297
                  Why is it that when I do a search for top profiles it doesn't return anything?In a html block I use …
                  •  ·  231
                  •  · 
                  I wanted to know if it is possible to log in with the username instead of with the email
                  •  · 
                  •  · 
                  •  · Ok, thx
                  •  ·  264
                  •  · 
                  Embedly works correctly on my site in the pc version when you add the url directly on the froala edi…
                  •  · 
                  •  · 
                  •  · checked, on una.io page it doesn't work either

                  UNA - Network Infrastructure for Communities

                  Close