Skip to main content ↑ ↓

Show Posts

This section allows you to view all Show Posts made by this member. Note that you can only see Show Posts made in areas you currently have access to.

Messages - claudiomg

1
Questions / Re: How to create an update page with an invisible
"@claudiomg would you be so kind to tell me where did you find the "custom code" part?"
Check the image below


"I understand the code can be changed manually and it gets overwritten when doing a Publish... and i know you can exclude a file to be re-generated... but then the code will not be updated if you change something in the GUI editor is not that right?"
Yes, you are right. If you uncheck a file, this file will not be re-generated. If you need to update the GUI in the editor, you will need to change the file manually.
Because of that, I suggest that you use the custom code field. This way, you don't need to uncheck the file. The file will be always regenerated and your modifications in the custom code field will be preserved.

"Is there any way of adding some INCLUDE/REQUIRE statement in the GUI so the file can be regenerated and you can keep your code?"
I don't know if it is possible to do that.
2
Questions / Include third party plugin on PhpRad
Hi, there is any way to integrate a third-party plugin on PHPRad?
I want to use the plugin below
https://www.tawk.to/

I also want to add Google Analytics too.
To add Google Analytics, I just need to add this snippet of code in any part of the page.

<!-- Google Analytics -->
<script>
(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
})(window,document,'script','https://www.google-analytics.com/analytics.js','ga');
ga('create', 'UA-XXXXX-Y', 'auto');
ga('send', 'pageview');
</script>
<!-- End Google Analytics -->

The only way to use it is editing manually or there is an alternative way to do that by using some field or form on PhpRad?
3
Questions / Re: How to create an update page with an invisible
I was able to create a new button without the need to change the view.
I just copy the 'delete' button code and use its code on with a field, I was able to use the code in the 'CustomCode' property

But I need to create a special function in the page's controller.
I just use one of the functions that are already created, then I copy and modify the code to fit my needs.
Every time I made a change, the project is published, my special function controller is overwritten (erased it), but after that, I find out that is possible to uncheck the controller in the Publish option, this way the controller code is not overwritten anymore.

Thanks for the explanation.
4
Questions / How to treat Mysql Error with unique constraint violation
I have a unique constraint in one of my tables in the database.

UNIQUE KEY `url_de_busca` (`url_de_busca`,`id_usuarios`),

This unique constraint forbids that two rows have the same values in these two fields.

When the user inserts a value that is already in the database, the following error appears



The error is correct, but I want to know how can I show a friendly error screen.

How can I do that?
5
Questions / How to create an update page with an invisible
Hi, I'd like to change behavior on the list screen, see image below



The edit button on that page must update only a single field on the database instead of open a new screen to allow the user to edit the values.

The field called 'active' by default has a value of 1, it must update the field with a value 0.

And after that, load the list again, the list doesn't show rows that have the 'active' field with a value of 0 (I do that using SQL).

How can I create a action button and create a custom SQL to update the row value?
7
Questions / How use the parameter USER_ID in sql query
I want to create a sql query using the USER_ID (Active User ID that is logged in)

Check the image below



I write the number 2, but I want to use the USER_ID, if I change the number 2 to USER_ID or $USER_ID, the query fails, how can I use correctly the USER_ID in a query?