Jump to content

jair101

Clients
  • Posts

    1,217
  • Joined

  • Last visited

  • Days Won

    1

jair101 last won the day on August 26 2018

jair101 had the most liked content!

2 Followers

Recent Profile Visitors

9,839 profile views
  1. I am doing a new server and wanted to start from scratch, which is different from my previous test environment (I haven't used it in a while). In a hindsight, it shouldn't have been an issue to keep the old test url, but now I already have the lets encrpypt certificates, web server, etc configuration, all with the new url. I guess I can redo that if it is too much effort for you, I thought that the strict rule was just for the main website url, which won't change.
  2. @Marc Stridgen, may I tag along here with the same request? My licensed URL is community.com, my current test url is devtest.community.com. I need to change it to devtest2.community.com and I am unable to do so. Appreciate the help.
  3. Fair enough, this is the case for today. However, I already see that v5 is introducing major changes to the development, I vaguely remember that all plugins need to be made in an app. I've been also burned with custom plugins and apps before. Furthermore, I will be needing my database on regular basis regardless, simply to have a copy outside of IPS environment - as much as I trust their backups, it is a good practice to keep a recent copy at an independent place. Once a month I hope is reasonable. Anyway, thanks for the feedback all, my main question was whether this could be done with Pages or API, I guess it won't be easy, I'll think about it a bit more.
  4. No, I meant that I can execute my queries on the database copy that you provide, I won't be needing you to import it back. Once I have it, I can simply hardcode the values in the Pages block that vizualizes the chart. Now, if providing me a copy of the database once a month will also be expensive, I would have to reconsider my entire strategy from scratch.
  5. Thanks. This is my last resort and possibly unacceptable. Doing this on my own will be a bit of a challenge, depending on 3rd party as well. If there is no some creative solution, I would probably request my database monthly, run the queries offline and update the data manually. Or maybe stick to the self hosted for the foreseeable future.
  6. It is about time that we migrate our community to the cloud. I think it will be mostly fine, but there is one key functionality that right now we do through creating auxillary database table and updating it through an event on a daily basis. This is all done directly in the database and once moving to the cloud I won't have access to it... So I am wondering what is the best way to do that. OK, a bit more details. We are travel oriented community and I have created 200+ Yes/No profile fields the users can toggle for each country they have visited. It looks like this in the profile: https://imgur.com/cCeNNCm So once a day, I am executing a database request that imports the data from the custom profiles in an extra database table with the following columns: id,field_name,iso_code,count 1,field_27,AT,135 2,field_36,DE,1047 etc.. This extra table ensures the mapping between field name, iso code and number of users that have visited the particular country. The query that generates that looks like this: TRUNCATE countries_map; Insert into countries_map (ISO, cntvis) select 'AU', sum(field_27) from core_pfields_content; Insert into countries_map (ISO, cntvis) select 'AT', sum(field_28) from core_pfields_content; Insert into countries_map (ISO, cntvis) select 'AZ', sum(field_29) from core_pfields_content; Insert into countries_map (ISO, cntvis) select 'AL', sum(field_30) from core_pfields_content; Insert into countries_map (ISO, cntvis) select 'DZ', sum(field_31) from core_pfields_content; Insert into countries_map (ISO, cntvis) select 'AS', sum(field_32) from core_pfields_content; Insert into countries_map (ISO, cntvis) select 'VI', sum(field_33) from core_pfields_content; ..... I need this extra query and extra table (countries_map), because we tried to do it by joining the results of 240 queries together and the speed was not pretty. So this query is executed once a day, truncates and populates this table, we are not concerned with live updates for visited countries so once a day is fine. This is all then fed in to this page created with the help of Pages and google geocharts that shows the most visited countries by our members: https://magelanci.com/atlas/ This is a core functionality for our community and I definitely need to find a way to do the same in the cloud without direct database access. So what is the best way to do that? Some magic through the REST API? Store the auxiliary table in Pages database and somehow update/obtain data from it? I cannot think of how to do that... Maybe I can commission some developer to do an app for me for this functionality, however I have been burned a bit by disappearing developers, so I'd rather use core IPS functionality. All ideas and suggestions will be appreciated, this is kind of a blocker for our migration to Cloud, which I definitely need to do as I don't have the time to admin my dedicated server responsibly.
  7. OK, fair point. In this case I think I would take the hit of having the content indexed with 2 weeks delay.
  8. I think there is already a method for Google to bypass the restrictions, based on user agent. At least this mod have this functionality:
  9. I am considering some actions to entice people to register/subscribe etc. based on the date availability of forum content. In a simplest terms imagine that guests will be able to see only topics and replies from up to 2 weeks ago. A large banner will inform them that if they want to access the latest content and engage with the community they need to register/become premium member, etc. Does this sounds like something that is easy to achieve through third party app/plugin? Tagging @DawPi as it seems that you have dived in to guest limits area, though not exactly in this respect ๐Ÿ™‚
  10. Seriously ๐Ÿ˜• Custom member titles are part of the profile identify, please make sure there is an option we can preserve them somehow. I guess the query to copy them from member title to profile field shouldn't be overly complicated, can someone from the expirienced devs advise on that?
  11. Going a step further, the invoice pdf can be sent as attachment via email, this is becoming a standard as it can be easily forwarded to the relevant department or event automated:
  12. Looks awesome ๐Ÿ™‚ Are we going to be able to award users retroactively or all users will start from 0 once the system is enabled? Ditto for if/when new achievement rules are added later?
  13. Any further details how points can be obtained? Is it going to be through regular content creation - i.e. number of posts, articles, images, etc.? Or it will be more flexible, for example based on where the topic is located (post in professional category might be worth more than one in humor section), or based on word count or number of attachments? Even better if we can set the weight of points ourselves ๐Ÿ™‚
  14. Any idea how many of those are spam and how many legit accounts though?
  15. @Paul E., is SQL the only thing you have offloaded outside of Compute Engine? What about object storage, elasticsearch, redis?
ร—
ร—
  • Create New...