Search found 190 matches

by AhmedBR
2018-06-20 19:53
Forum: AppGini Plugins
Topic: Translating months and days in SPM´s datepicker
Replies: 6
Views: 1428

Re: Translating months and days in SPM´s datepicker

try using this in the hook init

sql("SET lc_time_names=es_ES", $eo);

https://dev.mysql.com/doc/refman/8.0/en ... pport.html


Hope this works for you ;)
by AhmedBR
2018-05-07 20:21
Forum: Tips And Tricks
Topic: scrollable table in table view
Replies: 5
Views: 1099

Re: scrollable table in table view

Thanks for sharing. Works great :D
by AhmedBR
2017-11-01 15:09
Forum: Advanced Customizations > Hooks
Topic: Concat text + field + text in hook
Replies: 3
Views: 1120

Re: Concat text + field + text in hook

You need to make the field as Readonly in Appgini.

and use sql udpate to set the value in your database, something like this:

Code: Select all

sql("update `YOURTABLE` set `YOURFEILD` = 'THE VALUE YOU WANT' where `ID` = {$data['ID']}", $eo);
by AhmedBR
2017-10-20 01:07
Forum: Bugs/annoyances
Topic: Empty screen - link from Menu to table
Replies: 7
Views: 3440

Re: Empty screen - link from Menu to table

What is opened is CSS styles, you must be using something like firebug or something.
Take a look at Soruces in your screen, if nothing is there, then use a browser with no plugin (extension) installed the page source should appear.
by AhmedBR
2017-10-09 21:16
Forum: Advanced Customizations > Hooks
Topic: Track logins in a database instead of a log file
Replies: 16
Views: 10217

Re: Track logins in a database instead of a log file

try your code without the "my" at this line:

Code: Select all

sql("INSERT INTO 'LogIns' ('IP', 'Name', 'Date', 'Time', 'GroupID') VALUES ('$ip', '$username', '$date', '$time', '$group')", $eo);
See if this solves your problem.
by AhmedBR
2017-10-05 11:49
Forum: Bugs/annoyances
Topic: Empty screen - link from Menu to table
Replies: 7
Views: 3440

Re: Empty screen - link from Menu to table

USe right click on the empty page and select View Page Source (or something similar in your browser).

At almost the very far bottom of the source code you will find what is causing the problem.
usually one of these two: mysql syntax error or missing fields.
by AhmedBR
2017-09-24 17:31
Forum: Feature Suggestions
Topic: Hide seconds
Replies: 1
Views: 1237

Re: Hide seconds

You can do this by using Data Format option for the field.
Did you try that?
by AhmedBR
2017-09-24 17:29
Forum: Getting Started
Topic: MySql2AppGini does not save the generated project
Replies: 6
Views: 2063

Re: MySql2AppGini does not save the generated project

Which folder are you trying to save the file to?

Because usually you get this message if you try to save the file to C:, C:\Windows\System etc.)
by AhmedBR
2017-09-23 17:55
Forum: Advanced Customizations > Others
Topic: Difference in euro - Negative value but appgini marks 0
Replies: 2
Views: 1149

Re: Difference in euro - Negative value but appgini marks 0

Check UNSIGNED, if specified, disallows negative values.
by AhmedBR
2017-09-20 12:52
Forum: Bugs/annoyances
Topic: BUG SUM Auto-fill appgini 5.62
Replies: 2
Views: 1625

Re: BUG SUM Auto-fill appgini 5.62

The problem is that Appgini SUM the ID of the prices and not the prices itself. I had a similar problem, here is the work around I use: 1. Leave the price as Null (that is do not reference the other table). 2. Use Left Join (this table + the table that has the price and update the price using ini ho...
by AhmedBR
2017-09-08 12:46
Forum: Advanced Customizations > Others
Topic: Automatic value
Replies: 2
Views: 1360

Re: Automatic value

Check the Data Type of the Field, I use VarChar (40) and works fine. (use more than 40 if necessary).
by AhmedBR
2017-08-31 20:12
Forum: Advanced Customizations > Hooks
Topic: Force Password change
Replies: 1
Views: 990

Re: Force Password change

I have an idea,use the login function to do the redirect.

take a look at this topic:
viewtopic.php?f=4&t=1348

Give it a try ;)
by AhmedBR
2017-06-27 21:03
Forum: Advanced Customizations > Hooks
Topic: Due date
Replies: 11
Views: 4830

Re: Due date

Just a warning you could NULL other alerts this way.
You should COMBINE BOTH lines in one IF sql update.

In other words you should check for status of 30 days and 365 in same IF formula.
by AhmedBR
2017-06-27 15:24
Forum: Advanced Customizations > Hooks
Topic: Due date
Replies: 11
Views: 4830

Re: Due date

Glad it works ;)
Have a nice day
by AhmedBR
2017-06-27 12:11
Forum: Advanced Customizations > Hooks
Topic: Due date
Replies: 11
Views: 4830

Re: Due date

The Code looks fine to me, check the following: Data Type your are using for Data_Consegna has to be DATE.
Check if you have expired dates, maybe all the dates are less than one year (use like 30 days to check if this is not the problem).
by AhmedBR
2017-06-26 22:54
Forum: Advanced Customizations > Hooks
Topic: Due date
Replies: 11
Views: 4830

Re: Due date

You should the code right after this line:

Code: Select all

function Gestione_Ordini_init(&$options, $memberInfo, &$args){
by AhmedBR
2017-06-19 22:12
Forum: Advanced Customizations > Hooks
Topic: after update hook
Replies: 8
Views: 2867

Re: after update hook

I can see two possible problems: too many null values, and some results with nothing between comas! Let´s narrow things down (this is my simple way of solving these kind of problems): Use JUST the following in your hook (do not forget to double check table and field names in my formula): sql("Update...
by AhmedBR
2017-06-19 12:56
Forum: Advanced Customizations > Hooks
Topic: after update hook
Replies: 8
Views: 2867

Re: after update hook

I believe the error is in The table name: `wdcd.wdcd_WDCD` should be `wdcd_WDCD` or the correct name of your table. check it out and see if this solves the problem. ;)
by AhmedBR
2017-06-17 19:32
Forum: Bugs/annoyances
Topic: Save Record, get a blank screen
Replies: 1
Views: 1087

Re: Save Record, get a blank screen

use the mouse right button and select "View Page Source" you will find the problem usually at the end of the page.
Most likely Mysql statement error.
by AhmedBR
2017-06-17 19:29
Forum: Advanced Customizations > Hooks
Topic: after update hook
Replies: 8
Views: 2867

Re: after update hook

When you get a blank screen, use the mouse and select "View Page Source" this will show you what is causing this blank page. Usually an error in your MYSQL statement. You did not copy the code as is from here, right? (the code is just an example to what you should do, you need to complete it, that i...
by AhmedBR
2017-06-13 22:08
Forum: Advanced Customizations > Hooks
Topic: after update hook
Replies: 8
Views: 2867

Re: after update hook

I usually use something like this:

Code: Select all

sql("update `wdcd_WDCD` set WDCD= {$data['WDCD']}, ICV= {$data['WDCD']} etc.....

        where `OpID ` = {$data['OpID ']}", $eo);
Might not be the most elegant way, but works fine for me. ;)
by AhmedBR
2017-06-11 23:04
Forum: Getting Started
Topic: German Language Files
Replies: 2
Views: 1532

Re: German Language Files

Hi, you can find the language files at this link:
http://www.bigprof.com/appgini/download-language-files

Have a nice day
Ahmed