carlos123 Posted June 24, 2003 Share Posted June 24, 2003 i have installed helpdesk.php support ticket v1b. I get the same error about coustomer ID : 1064 - You have an error in your SQL syntax near 'select * from support_tickets where customers_id = '2' and ticket_status='1'' at line 1 select count(select * from support_tickets where customers_id = '2' and ticket_status='1' order by ticket_date DESC) as total [TEP STOP] same thing for both.. Quote Link to comment Share on other sites More sharing options...
kunoichi Posted July 11, 2003 Share Posted July 11, 2003 Henri, I wanted to say thank you so very much for writing such a wonderful script. Your instructions were very easy to follow. (After having failed at installing the PDF Catalog Generator, I was feeling a bit down . . .) Your script is the perfect addition to my upcoming store! Best wishes! ~ Kunoichi Quote Kunoichi [email protected] "The secret principle of Taijutsu is to know the foundations of peace." Link to comment Share on other sites More sharing options...
rimshot Posted August 19, 2003 Share Posted August 19, 2003 I would like to thank you too Henri. You've really made a wonderful thing. I want to hug you, really. i just have one question. is there a way that the store admin could get an email everytime someone creates a support ticket? did i overlook something? Thanks in advance, -Andrew Quote Link to comment Share on other sites More sharing options...
henri Posted August 19, 2003 Author Share Posted August 19, 2003 As i recall there isn't an email send (cause my customer don't want's to get >20mails a day). But simply adding a mailfunktion shouldn't be the problem. Cu Henri Quote Link to comment Share on other sites More sharing options...
Guest Posted August 19, 2003 Share Posted August 19, 2003 I visited the site: http://62.146.28.232/ All works perfect. I tryed install in 2.2MS2. I puted all files in the directories and what is writed in the readme. Im my Admin area, I dind't see the link to the "SupportTicket" as in the http://62.146.28.232/ Can you help me? Thanks. Quote Link to comment Share on other sites More sharing options...
henri Posted August 22, 2003 Author Share Posted August 22, 2003 The admin has the some installtion as the catalog. Did you forget this? Cu Henri Quote Link to comment Share on other sites More sharing options...
Guest Posted August 22, 2003 Share Posted August 22, 2003 The admin has the some installtion as the catalog.Did you forget this? Cu Henri Yes, I forgot :oops: Now is perfect, thanks :D Quote Link to comment Share on other sites More sharing options...
PropioWeb Posted August 22, 2003 Share Posted August 22, 2003 Hey Henri, Great Contribution. One question though. If I'm logged in as a customer and try to create a ticket it automatically puts in the name and email. Right? But if I'm logged in as an Affilliate it does not. Is there some code that I can add to make this work equally as well? Thanks. Quote Samuel Mateo, Jr. osC 2.2 MS2 Installed Mods: WYSIWYG HTMLArea 1.7 | Basic Template System 1.0 | osC-Affiliate | OSC-SupportTicket Featured Products 1.3 | LoginBox 5.2 | LatestNews 1.1.3 | Extras for IE Link to comment Share on other sites More sharing options...
tails2k Posted August 22, 2003 Share Posted August 22, 2003 Henri! Great Job, super easy and just what I was looking for. I do see a small problem when I update a ticket and it sends the email back.... You can view the changes at: /osc/catalog/ticket_view.php?tlid=1T5f8X0b9D5Y7J it does not include the www..... would this be a problem with my OSC settings or with the ticket system? Quote Link to comment Share on other sites More sharing options...
henri Posted August 22, 2003 Author Share Posted August 22, 2003 Hmm, you mean sending theupdatey via admin? Check if HTTP_CATALOG_SERVER is set in the admin/includs/configure.php Cu Henri Quote Link to comment Share on other sites More sharing options...
PropioWeb Posted August 25, 2003 Share Posted August 25, 2003 Hey Henri,Great Contribution. One question though. If I'm logged in as a customer and try to create a ticket it automatically puts in the name and email. Right? But if I'm logged in as an Affilliate it does not. Is there some code that I can add to make this work equally as well? Thanks. Yes, No, Maybe? Quote Samuel Mateo, Jr. osC 2.2 MS2 Installed Mods: WYSIWYG HTMLArea 1.7 | Basic Template System 1.0 | osC-Affiliate | OSC-SupportTicket Featured Products 1.3 | LoginBox 5.2 | LatestNews 1.1.3 | Extras for IE Link to comment Share on other sites More sharing options...
henri Posted August 25, 2003 Author Share Posted August 25, 2003 @PropioWeb: Overread you question. :oops: But if I'm logged in as an Affilliate it does not. Is there some code that I can add to make this work equally as well? Not yet, but changing the ticket_create.php should be easy. Look at the lines after: // Customer is logged in: and add it for the affiliate Quote Link to comment Share on other sites More sharing options...
PropioWeb Posted August 25, 2003 Share Posted August 25, 2003 Look at the lines after: // Customer is logged in: and add it for the affiliate In Which File? @PropioWeb: Overread you question. Thats okay. I do that sometimes too. :D Quote Samuel Mateo, Jr. osC 2.2 MS2 Installed Mods: WYSIWYG HTMLArea 1.7 | Basic Template System 1.0 | osC-Affiliate | OSC-SupportTicket Featured Products 1.3 | LoginBox 5.2 | LatestNews 1.1.3 | Extras for IE Link to comment Share on other sites More sharing options...
henri Posted August 25, 2003 Author Share Posted August 25, 2003 Look at the lines after: // Customer is logged in: and add it for the affiliate In Which File? Not yet, but changing the ticket_create.php should be easy. you must just add a similar select if an affiliate is logged in. Quote Link to comment Share on other sites More sharing options...
PropioWeb Posted August 25, 2003 Share Posted August 25, 2003 I'm sorry I don't know much about php. I'm leaning as I go along, especially with osC and PostNuke which I'm using more off lately as well. I don't know where to get the if statement from. Thanks for your help. Quote Samuel Mateo, Jr. osC 2.2 MS2 Installed Mods: WYSIWYG HTMLArea 1.7 | Basic Template System 1.0 | osC-Affiliate | OSC-SupportTicket Featured Products 1.3 | LoginBox 5.2 | LatestNews 1.1.3 | Extras for IE Link to comment Share on other sites More sharing options...
henri Posted August 25, 2003 Author Share Posted August 25, 2003 Something like this: // Customer is logged in: if (tep_session_is_registered('customer_id')) { $customer_query = tep_db_query("select?customers_firstname, customers_lastname,?customers_email_address from " . TABLE_CUSTOMERS . " where customers_id = '" . $customer_id . "'"); $customer = tep_db_fetch_array($customer_query); } else if (tep_session_is_registered('affiliate_id')) { $customer_query = tep_db_query("select?affiliate_firstname, affiliate_lastname,?affiliate_email_address from " . TABLE_AFFILIATE_AFFILIATE . " where affiliate_id = '" . $affiliate_id . "'"); } Quote Link to comment Share on other sites More sharing options...
PropioWeb Posted August 25, 2003 Share Posted August 25, 2003 1146 - Table 'nisi_cart.TABLE_AFFILIATE_AFFILIATE' doesn't exist select affiliate_firstname, affiliate_lastname, affiliate_email_address from TABLE_AFFILIATE_AFFILIATE where affiliate_id = '2' [TEP STOP] This is a DB error, right? Did I do something wrong? BTW. I have a complete Spanish translation of your files. If you want I will zip em up and send them to you. Quote Samuel Mateo, Jr. osC 2.2 MS2 Installed Mods: WYSIWYG HTMLArea 1.7 | Basic Template System 1.0 | osC-Affiliate | OSC-SupportTicket Featured Products 1.3 | LoginBox 5.2 | LatestNews 1.1.3 | Extras for IE Link to comment Share on other sites More sharing options...
tails2k Posted August 25, 2003 Share Posted August 25, 2003 Hmm, you mean sending theupdatey via admin?Check if HTTP_CATALOG_SERVER is set in the admin/includs/configure.php Cu Henri That was it... thanks! Quote Link to comment Share on other sites More sharing options...
PropioWeb Posted August 25, 2003 Share Posted August 25, 2003 1146 - Table 'nisi_cart.TABLE_AFFILIATE_AFFILIATE' doesn't exist select affiliate_firstname, affiliate_lastname, affiliate_email_address from TABLE_AFFILIATE_AFFILIATE where affiliate_id = '2' [TEP STOP] This is a DB error, right? Did I do something wrong? BTW. I have a complete Spanish translation of your files. If you want I will zip em up and send them to you. I figured out. It was calling a nonexisting table (TABLE_AFFILIATE_AFFILIATE) so I renamed it to the correct one which is "affiliate_affiliate" but it still does not work. The Name and Email fields stay blank. Quote Samuel Mateo, Jr. osC 2.2 MS2 Installed Mods: WYSIWYG HTMLArea 1.7 | Basic Template System 1.0 | osC-Affiliate | OSC-SupportTicket Featured Products 1.3 | LoginBox 5.2 | LatestNews 1.1.3 | Extras for IE Link to comment Share on other sites More sharing options...
henri Posted August 25, 2003 Author Share Posted August 25, 2003 Was an idea how the the code could look like ;) TABLE_AFFILIATE_AFFILIATE -> TABLE_AFFILIATE Quote Link to comment Share on other sites More sharing options...
henri Posted August 25, 2003 Author Share Posted August 25, 2003 Remember: Do not post code you didn't test. ;) Still untested // Customer is logged in:? ? if (tep_session_is_registered('customer_id')) { ? ? $customer_query = tep_db_query("select?customers_firstname, customers_lastname,?customers_email_address from " . TABLE_CUSTOMERS . " where customers_id = '" . $customer_id . "'"); ? ? $customer = tep_db_fetch_array($customer_query); ? } else if (tep_session_is_registered('affiliate_id')) { $customer_query = tep_db_query("select?affiliate_firstname as customers_firstname, affiliate_lastname as customers_lastname,?affiliate_email_address as ?customers_email_address from " . TABLE_AFFILIATE . " where affiliate_id = '" . $affiliate_id . "'"); ? ? $customer = tep_db_fetch_array($customer_query); } Quote Link to comment Share on other sites More sharing options...
henri Posted August 25, 2003 Author Share Posted August 25, 2003 BTW. I have a complete Spanish translation of your files. If you want I will zip em up and send them to you. :) Simply upload it at the contribution area. A new release is not planned at the moment, so there is the best place at the moment. Quote Link to comment Share on other sites More sharing options...
PropioWeb Posted August 25, 2003 Share Posted August 25, 2003 Remember: Do not post code you didn't test. ;) Still untested // Customer is logged in:? ? if (tep_session_is_registered('customer_id')) { ? ? $customer_query = tep_db_query("select?customers_firstname, customers_lastname,?customers_email_address from " . TABLE_CUSTOMERS . " where customers_id = '" . $customer_id . "'"); ? ? $customer = tep_db_fetch_array($customer_query); ? } else if (tep_session_is_registered('affiliate_id')) { $customer_query = tep_db_query("select?affiliate_firstname as customers_firstname, affiliate_lastname as customers_lastname,?affiliate_email_address as ?customers_email_address from " . TABLE_AFFILIATE . " where affiliate_id = '" . $affiliate_id . "'"); ? ? $customer = tep_db_fetch_array($customer_query); } Sorry, this did not work either. I wish I knew a little more php so I could figure it out. But thanks a lot for you help. Quote Samuel Mateo, Jr. osC 2.2 MS2 Installed Mods: WYSIWYG HTMLArea 1.7 | Basic Template System 1.0 | osC-Affiliate | OSC-SupportTicket Featured Products 1.3 | LoginBox 5.2 | LatestNews 1.1.3 | Extras for IE Link to comment Share on other sites More sharing options...
PropioWeb Posted August 25, 2003 Share Posted August 25, 2003 BTW. I have a complete Spanish translation of your files. If you want I will zip em up and send them to you. :) Simply upload it at the contribution area. A new release is not planned at the moment, so there is the best place at the moment. OK! Will do. :D Quote Samuel Mateo, Jr. osC 2.2 MS2 Installed Mods: WYSIWYG HTMLArea 1.7 | Basic Template System 1.0 | osC-Affiliate | OSC-SupportTicket Featured Products 1.3 | LoginBox 5.2 | LatestNews 1.1.3 | Extras for IE Link to comment Share on other sites More sharing options...
erisen Posted August 26, 2003 Share Posted August 26, 2003 Hello Henri, Thank you very much. Easy to install. Works Perfectly. One comment about the support system that incorporates email interaction: It needed to use the aliases, and people like myself who are using virtual hosts, were not very much in luck installing it properly.. One question: Which affiliate contribution did you happen to install? Mehmet. Quote GALATASARAY RULES! ultrAslan - ultrAslan - ultrAslan Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.