onyxtacular
Forum Replies Created
-
I went to the site homepage and downloaded the current version and uploaded to the site. I was asked if I wanted to replaced the current plugin…YES. and it worked out great.
Love this plugin!
I would like to try removing the plugin and then add it back. I’m concern about losing the reports once I remove the plugin. I checked but don’t see and information on saving the reports, I would like some info on the best course of action.
Thank you.
Forum: Plugins
In reply to: [EZ SQL Reports Shortcode Widget and DB Backup] wildcard on usernameon the last command I received the error: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘– INTERVAL 180 DAY AND DATE(NOW()) ORDER BY InvoiceDate DESC’ at line 1
————————————————————
I am sorry the confusion. I neglected to mention I was running the query as the administrator and it really had nothing to do with it save it gave and error where my username was shorten by three characters.
———————————————–
I hope this clears things up:
“In my scenario The current customerID and username is 90120”
the customer id on my local sql system is 90120 and the wordpress username is 90120The additional usernames on wordpress would be 90120JAN, 90120FEB, 90120MAR and I want all for wordpress users to get access to the invoices that 90120 is able to see including the original wordpress user: 90120
my goal is to have any username with a base of 90120 see the output that username 90120 sees.
Forum: Plugins
In reply to: [EZ SQL Reports Shortcode Widget and DB Backup] wildcard on usernameHi Eli,
The full query with the modification you provided.
select SalesOrderNumber , InvoiceNumber , InvoiceDate , NetAmount, Freight, Tax, InvoiceTotal FROM
Invoiceswhere InvoiceDate BETWEEN DATE(NOW()) – INTERVAL 180 DAY AND DATE(NOW()) and CustomerID = ‘ <?php substr($current_user->user_login, 0, -3) ?>’ order by InvoiceDate descWhen trying to run the query I got this error:
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘IAMAT” order by InvoiceDate desc’ at line 1
my username is IAMATONE – is lessen by 3
In my scenario The current customerID and username is 90120
the additional usernames would be 90120JAN, 90120FEB, 90120MAR and I want all for users to get access to the invoices that 90120 is able to see.
Thanks for the quick reply.
- This reply was modified 5 years, 7 months ago by onyxtacular.
Forum: Plugins
In reply to: [Contact Form 7] Contact forms not sending after WP/PHP updateThanks!… I will check it out.
Forum: Plugins
In reply to: [EZ SQL Reports Shortcode Widget and DB Backup] limit report by loginnameFound it listed here….just had to read through a few more pages:
select * FROM ‘tablename’ where CustomerID = <?php $current_user->user_login ?>
ty
Forum: Plugins
In reply to: [Custom Content Shortcode] parse error on activationThanks Eliot, working great now. I will pass these comments on to my hosting company.
Thanks that will get me started.
Thanks for the quick response 🙂
Is there a way for me to change this link to go to another site? This whole site is the member’s website. I want to send them back to another site.
Thanks,
OnyxGreat plugin!!
Adding a linking feature would help me out greatly. I created a member’s only site. When the members logout I would like to give the the chance to get back into the public site.