AppGini Community Forums

Yes, that works!

Thanks!!

Hi Olaf, I added the following to footer-extras.php file: <?php $script_name = basename($_SERVER['PHP_SELF']); if($script_name == 'index.php' && isset($_GET['signIn'])){ ?> <style> body{ background: url("hooks/logo.jpg") no-repeat fixed center center; background-size: 60% } </style> <?php } ?> As a ...

Thank you both. Your answers clarified my confused mind

Hello, Could someone explain to me the sqlValue() function? I'm looking for a way to send an SQL statement (something like "select * from table1 where col1=123") from a hook and store the response in a variable. I thought the sqlValue function would to that, but it doesn't look like it. Is it a PHP ...

The issue seems to be resolved now, but I don't really know why or what caused it. I emptied the folder of the application on the server and uploaded a fresh regenerated copy. I can now access the Admin Area again. I tried this approach before, but the difference was that I did not first delete the ...

Olaf,
I have already tried that approach (as mentioned above), but although the user becomes admin (by changing the groupID), he does not get the "Admin Area" button! He gets to see all the tables, but not that button. It seems like only the "admin" user gets it.
Thanks

No I didn't, but I will now.
Thanks

I also tried to give another user admin rights by changing the groupID field in the membership_users table from 3 to 2, but all that changed was that now that user got access to all the tables, but not the Admin Area button. Anyone know how to manually make a user full admin?

... forgot to mention that I also changed the hash in the config.php file accordingly.

I manually changed the password for the admin account (in the membership_users table), and was able to login, but still the admin area button logs me out!

I checked the hash in the config.php file for the admin account. It was different (and much smaller in length) than the one in the membership_users table. So I copied that hash to the table. I was able to login (as before), but when I looked at the table again, the hash in the table changed back to ...

Thanks Olaf, but where do I put this code?

Yes, I did reload all the files after the upgrade.
I unfortunately do not know how to trace the $_SESSION[‘memberID’]. How do I do it?
Thanks

I thought if I copied the hash of the admin account from the table into the config.php, it would help, but it made no difference. I still could login to the application, but as soon as I click on the admin area button I get logged out.
When are the credentials in the config.php file used?

It looks like "Forgot your password" does not work for the admin account, and I cannot go into the admin area (the reason for this post) to change the password there (catch 22 situation)... As suggested above, what if I change the password (MD5 hash) of the admin account in the membership_users tabl...

You mean at the sign in page, select "Forgot your password"?

Thanks Olaf.
a) I checked and the users are not banned.
b) If I create a user and set the password as you suggest, where do I tell the application to use that user instead (which AppGini file)?
Thanks

Hi,

Thanks for your reply. Yes, I have tried all of the above. I also tried different machines and OS's (Windows, MacOS, iPad). They all show the same behavior.

Thanks

Hello, I had not accessed the site in a while, but yesterday I logged in (as admin) and then clicked on the "Admin Area" button (to do some user/group management), but instead of taking me to the admin area, I was logged out! I tried re-generating the code, but that didn't help. I was using version ...

... and how did you insert the screenshot in the post Jan? I can't seem to manage.

All resolved! After reading your reply googling and playing around, I managed to resolve everything by using the following: $j('#Field1').prop('readonly', 'readonly'); /* input fields */ $j("#Field2").attr('disabled',true); /* check boxes */ setTimeout('$j("#s2id_Field3-container").select2("readonly...

Thanks Jan,
I have a very stupid and ignorant question :
Where should the output of the console.log() appear? I don't see it when I refresh the browser.
Thanks

Hi, I use Chrome and Edge. The code screenshot is from Notepad++. You can download the screenshots from here: https://www.dropbox.com/s/y0wjn6u6l9vn8xg/shot1.jpg?dl=0 Screenshot from Notepad++ showing the two lines that do no t work (countrykey and Gender); https://www.dropbox.com/s/8wqb7tjamepbwvf/...

Hi, My Participants table has the following two fields: countrykey which calls on a lookup table; and Gender which allows a selection between Male and Female (not lookup) So I added the following, but they both don't work: $j("#countrykey-container").attr('disabled',true); $j("#Gender-container").at...

Ok. Now that this is fixed for input fields, how can I do it also for dropdowns and checkboxes?