Jump to content
Sign in to follow this  
Snowman

[CONTRIBUTION] osC Helpdesk v1.0

Recommended Posts

One other thing Steve.

 

When you submit a ticket and you havent fiulled out all the details,

why does the next page create tiny text boxes and not give you the priority options??

 

Seems like a little bug.

 

Also the 3 warnings about forgetting your message or name etc, all sits on the same line, so this could do with being seperated on future releases.

 

CC.

Share this post


Link to post
Share on other sites

Ok, last thing for me tonight.

 

Where do you find the email address that the email to the customer is sent FROM?

 

Currently it is set to support@yourstore.com.

 

where can I find this to change it??

 

Thanks

 

CC.

Share this post


Link to post
Share on other sites

Its stored in the SQL

 

INSERT INTO configuration VALUES ('', 'Support Email Address', 'SUPPORT_EMAIL_ADDRESS', 'support@yourstore.com', 'Support email address', 1, '99', '', '', NULL, NULL);

 

It should come up on the store configuration page in admin

Share this post


Link to post
Share on other sites

I did the part where Steve says:

 

in helpdesk_submit.php change all references of

 

FILENAME_HELPDESK_LOGIN

 

to

 

FILENAME_HELPDESK_SUBMIT

 

I do not understand very clearly this other part:

----------------------------

Now do the same for the other two files in the catalog side of the mod replacing FILENAME_HELPDESK_SUBMIT with FILENAME_HELPDESK_STATUS and FILENAME_HELPDESK_REOPEN, respectively

 

and then for all files find:

 

<title><?php echo $breadcrumb->trail_title(' » '); ?></title>

 

and change back to:

 

<title><?php echo TITLE; ?></title>

 

This should solve the issuses for almost all users....

 

I will repackage an improved version when i get a chance...

-----------------------

What file is Steve referring to? What section if it is on helpdesk_submit.php?

 

I did read what he said. Prior I do a post I read because in many occacions we are able to find an answer. But I'm still having problems. Maybe, is because my level of knowledge is too limited to understand some things with basic intructions rather than detailed ones.

-----------------------

I will appreciate everyone's help on it.

As for the javascript, what java code are you talking about Steve? Sorry, I did not get that one either :(

 

Note: For changing the email address of the default user installed with the database I when to the Database itself and changed it from inside.

Share this post


Link to post
Share on other sites

Steve,

 

In my case, I was able to edit that default user from admin section :wink:

 

but my problem with the catalog section and not able to add more users from the admin section still persist.

Can you be generous and tell me in details what part of the mysql I need to change? Or just paste the sql code in here as it is complete without anything missing? That way I will get it! sorry I haven't got it yet. Maybe is a day I come up dump :wink:

 

By the way, what did you mean with the javascript code? Where is it?

And lastly I got lost on the other changes when you say"

Now do the same for the other two files in the catalog side of the mod replacing FILENAME_HELPDESK_SUBMIT with FILENAME_HELPDESK_STATUS and FILENAME_HELPDESK_REOPEN, respectively "

 

What file is that one? What line number approx.?

Thanks for your help,

 

 

Brian

Share this post


Link to post
Share on other sites

Mate calm down...

 

We get it that you dont get it!

If you babble too much in your comments people will get bored of reading and you are in danger of getting no answers at all.

 

Now...

 

Do you use phpmyadmin?

If you do, go to it and bring up your database.

From there go to the helpdesk table, the edit. Once in the helpdesk table you will see a field called id, just rename this to ticket_id and you wont have the confliction anymore.

 

The javascript is the bit at the bottom of the 3 catalog files.

it says this:

<script language="JavaScript" src="menu.js"></script>

<script language="JavaScript" src="menu_items.js"></script>

<script language="JavaScript" src="menu_tpl.js"></script>

<script language="JavaScript">

<!--

new menu (MENU_ITEMS, MENU_POS, MENU_STYLES);

//->

</script>

 

Just go in and get rid of that code completely.

All it does at present is cause erros on your page.

 

Regarding the breadcrumb error, you may not need to do this, or you may need to it depends on your snapshot of OSC.

Go into it and tell me do you have this line near the top of your scripts, i.e. the 3 main catalog files again:

 

$location = ' » <a href="' . tep_href_link(FILENAME_HELPDESK_SUBMIT, '', 'NONSSL') . '" class="headerNavigation">' . NAVBAR_TITLE . '</a>';

 

Or, do you have this bit:

 

$breadcrumb->add(NAVBAR_TITLE, tep_href_link(FILENAME_HELPDESK_REOPEN, '', 'NONSSL'));

 

Once you have figured that, come back and tell me.

From there we can sort out the right code for your snapshot.

 

ok?

 

CC.

Share this post


Link to post
Share on other sites

Thanks CC!

 

Your explanation was very detailed and easy to follow. I fixed the mysql and took away the javascript codes.

THe other code for breadcrumb is correct I guess. I have:

$breadcrumb->add(NAVBAR_TITLE, tep_href_link(FILENAME_HELPDESK_REOPEN, '', 'NONSSL'));

 

============================

But I still have the same problem! Blank page for helpdesk_status.php and for Submit a Ticket link is: http://www.mysite.com/catalog/FILENAME_HELPDESK_SUBMIT

 

What else would be wrong? I have carefully triple check on all details in the readme txt, delete the two mysql tables of helpdesk v1.0 and install them again plus much more, but I don't go out of that stage.

 

If you believe there would be something else to try?

Thanks,

 

Brian

Share this post


Link to post
Share on other sites

Ok.

 

Glad that worked.

 

When I mentioned this line:

 

$breadcrumb->add(NAVBAR_TITLE, tep_href_link(FILENAME_HELPDESK_REOPEN, '', 'NONSSL'));

 

I didnt mean in the helpdesk files. I meant in any other files within OSC, like for instance the account.php file.

 

go into this and check to see if you can find this line of code.

If it is this:

 

$breadcrumb->add(NAVBAR_TITLE, tep_href_link(FILENAME_HELPDESK_REOPEN, '', 'NONSSL'));

 

then you need this as your title line:

 

<title><?php echo $breadcrumb->trail_title(' » '); ?></title>

 

But if it is this:

 

$location = ' » <a href="' . tep_href_link(FILENAME_HELPDESK_SUBMIT, '', 'NONSSL') . '" class="headerNavigation">' . NAVBAR_TITLE . '</a>';

 

the you need this as your title line:

 

<title><?php echo TITLE; ?></title>

 

If you mix and match you will get nothing but a blank page, so make sure you get this right.

 

Once you have done this, all problems should be solved.

 

If not then please post your enitre account.php file here and I will take a look to see what you have.

then we can come to a conclusion.

 

I guess at least you must be learning something here, hey?

 

CC.

Share this post


Link to post
Share on other sites

Thanks:)

 

Well, I'm looking at it now and for ex. at account.php I found that instead of 'NONSSL' it says 'SSL'. Should this make a difference?

Here I'm pasting the code:

====================================

require('includes/application_top.php');

 

if (!tep_session_is_registered('customer_id')) {

$navigation->set_snapshot();

tep_redirect(tep_href_link(FILENAME_LOGIN, '', 'SSL'));

}

 

require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_ACCOUNT);

 

$breadcrumb->add(NAVBAR_TITLE, tep_href_link(FILENAME_ACCOUNT, '', 'SSL'));

====================================

But I'm not currently using SSL on this account because where I have it I do not have SSL. I'm installing it there to get it done and then have it installed at another server with same cpanel but with ssl. There is where I'll have the store.

 

Let me know if I should change everywhere where I see SSL for NONSSL.

Yes as you can see I have $breadcrumb->.

 

 

Brian

Share this post


Link to post
Share on other sites

No dont go changing anything like that, it is already there for a reason.

 

Problem here is I am not familiar with $breadcrumb.

So judging by thi I would try the following:

 

Go into helpdesk_submit.php and if it reads this:

 

<title><?php echo $breadcrumb->trail_title(' » '); ?></title>

 

Then chage it to this:

 

<title><?php echo TITLE; ?></title>

 

the reupload it and try it.

 

If however it currently says this:

 

<title><?php echo TITLE; ?></title>

 

Then change it to this and test it:

 

<title><?php echo $breadcrumb->trail_title(' » '); ?></title>

 

If that still doesn't work we will have to dig deeper and get Steve involved again.

Maybe even try and do a clean install from the script again, and put in what you already know.

 

CC.

Share this post


Link to post
Share on other sites

the breadcrumb logic varies between earlier snapshots and newer ones...you just need to change it over if your code varies from what is currently there.

 

only the 3 files in the catalog directory need to be checked for this.

Share this post


Link to post
Share on other sites

Ok forgive me but ive read this whole thread and am still stuck on this one.

 

Submit a ticket link is like this:

http://store.shaolin-venoms.com/Venom-Stor...HELPDESK_SUBMIT

 

Then i went to the file directly:

http://store.shaolin-venoms.com/Venom-Stor...desk_submit.php

 

Results:

 

Fatal error: Failed opening required 'includes/languages/english/FILENAME_HELPDESK_SUBMIT' (include_path='.:/php/includes:/usr/share/php') in /home/virtual/site2/fst/var/www/html/Venom-Store/helpdesk_submit.php on line 15

 

File: helpdesk_submit.php of /includes/languages/english exists

 

Did the change FILENAME_HELPDESK_LOGIN to FILENAME_HELPDESK_SUBMIT and the rest looks like it already has been changed.

 

Here is a piece of the catalog/ helpdesk_submit.php file.

 

  require('includes/application_top.php');



 require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_HELPDESK_SUBMIT);



 $breadcrumb->add(NAVBAR_TITLE, tep_href_link(FILENAME_HELPDESK_SUBMIT, '', 'NONSSL'));

?>

 

<title><?php echo $breadcrumb->trail_title(' » '); ?></title>

 

BTW, in the admin section the helpdesk lasts a very short time (like 2 or 3 clicks).

Share this post


Link to post
Share on other sites

Did you define FILENAME_HELPDESK_SUBMIT in application_top ?

 

 

<title><?php echo $breadcrumb->trail_title(' » '); ?></title>

 

Hey, I recognize that code :!: Happy to see someone liked it :D


"It's a damn poor mind that can only think of one way to spell a word."

-- Andrew Jackson

Share this post


Link to post
Share on other sites

Catalog side of aplication_top:

 

  define('FILENAME_HELPDESK_SUBMIT', 'helpdesk_submit.php');

 define('FILENAME_HELPDESK_STATUS', 'helpdesk_status.php');

 define('FILENAME_HELPDESK_REOPEN', 'helpdesk_reopen.php');

 

Like that you mean?

Share this post


Link to post
Share on other sites

Ok i see what i did i put the admin application_top in the catalog side or something like that.

 

It doesnt do that no more but now when clicked nuthing shows but a blank page.

 

Im check it all again.

Share this post


Link to post
Share on other sites

I havent got a clue on why when you click on Submit a Ticket or Check a Ticket shows nuthing but a blank page.

 

Ive checked everything.

all "FILENAME_HELPDESK_LOGIN" was change to "FILENAME_HELPDESK_SUBMIT" and check with a folder file scanner too.

 

Checked all the modified flie and reuploaded the added files with no effect.

Share this post


Link to post
Share on other sites

In helpdesk_submit.php find:

 

$breadcrumb->add(NAVBAR_TITLE, tep_href_link(FILENAME_HELPDESK_SUBMIT));

Changed to:

$location = ' » <a href="' . tep_href_link(FILENAME_HELPDESK_SUBMIT, '', 'NONSSL') . '" class="headerNavigation">' . NAVBAR_TITLE . '</a>';

 

<title><?php echo TITLE; ?></title>

Change to:

<title><?php echo $breadcrumb->trail_title(' » '); ?></title>

 

OK its working now that i made thoes changes.

Is these changes for before the mid september snapshot or after?

 

Since its working i get an error of:

Line 563 'menu' is undefined.

Ill search this thread again for that.

Share this post


Link to post
Share on other sites

It works now:)

 

After making the changes you addressed me to, It works for me :lol:

I still need some work to do for it and for the whole store (design stuff).

 

Thanks once again,

 

 

Brian

Share this post


Link to post
Share on other sites

I did a test submit ticket and this shows:

 

1054 - Unknown column 'ticket_id' in 'field list'

 

SELECT ticket_id FROM helpdesk WHERE name = 'michale' AND problem = 'y5ethn';

 

[TEP STOP]

Share this post


Link to post
Share on other sites

Oh man i thought i had ticket_id in my sql.

 

Ok, last 2 issues is that in the helpdask admin you dont stay logged in long enough to navigate (2 or 3 clicks and you have to relogin).

 

Whenever you click on the helpdesk options in the left colum:

"Helpdesk Admin

View Tickets

Closed Tickets

Search Tickets

Add User

Edit User

Delete User"

you have to relogin all the time and each time you do your brought back to "helpdesk.php" with the following option:

 

Features------------------------Admin Features

View Open Tickets-------------Edit Helpdesk User

View Closed Tickets

Search Tickets(s)

 

Thats all i ever see.

 

Is this working the way it should?

Share this post


Link to post
Share on other sites

Ok since in folder admin/ index.php is:

 

<?php if($usern == 'admin') { ?>

 

i changed in the sql file:

 

INSERT INTO helpdesk_members VALUES ('admin','

 

Works now.

Share this post


Link to post
Share on other sites

Hello Illicious,

 

I have been following your messages posted here to verify. It looks you are an advanced user :)

 

I have a question to ask you?

In an above message you talk about a problem with login everytime you click on add edit and so on. I have the same error.

 

I checked on admin/index.php and I cannot fine the string you talked about in here?

========================

Ok since in folder admin/ index.php is:

 

Code:

<?php if($usern == 'admin') { ?>

 

 

i changed in the sql file:

 

Code:

INSERT INTO helpdesk_members VALUES ('admin','

 

 

Works now.

=======================

What string is it where you find <?php if($usern == 'admin') { ?>

I do not see a way to delete tickets other than doing it manually at the db as for now.

Thanks,

 

Brian

Share this post


Link to post
Share on other sites

Im not really an advanced user. :( I just take things step by step. :)

 

Looking at how you figured out the admin thing then i dont understand your question if do you have one.

 

Anyways glad to help.

Share this post


Link to post
Share on other sites

Ill post a fixed up version as soon as i get a chance...ive got a lot on my plate at the moment

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×