-
Posts
620 -
Joined
-
Last visited
Posts posted by custodian
-
-
I don't know if this would not make it show or not (tables can be funny like that).. but initially looking at this part
<tr>
<td class="main"><b><?php echo ENTRY_PAYMENT_METHOD; ?></b></td>
<td class="main"><?php echo $order->info['payment_method']; ?></td>
<tr>
<td class="main"><b><?php echo ENTRY_CUSTOMER_NOTES; ?></b></td>
<td><i><?php
//query to grab the notes
$cust_notes_query = tep_db_query("select customers_id, customers_notes from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$cID . "'");
$cust_notes = tep_db_fetch_array($cust_notes_query);
//end query
echo $cust_notes['customers_notes']; ?></i></td>
</tr>
I think that should be
<tr>
<td class="main"><b><?php echo ENTRY_PAYMENT_METHOD; ?></b></td>
<td class="main"><?php echo $order->info['payment_method']; ?></td>
</tr>
<tr>
<td class="main"><b><?php echo ENTRY_CUSTOMER_NOTES; ?></b></td>
<td><i><?php
//query to grab the notes
$cust_notes_query = tep_db_query("select customers_id, customers_notes from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$cID . "'");
$cust_notes = tep_db_fetch_array($cust_notes_query);
//end query
echo $cust_notes['customers_notes']; ?></i></td>
</tr>
-
Works. Now I did that to my own account on our website. I checked the message and hit delete. all it does is log me out and take me back to the logon screen. I cannot remove the message.
OK, for those you that may have the same issue. Do the following
In account.php in the Customers Private Message section look for
echo '<form action=' . $_SERVER['PHP_SELF'] . ' method="post">';
and change it to
// echo '<form action=' . $_SERVER['PHP_SELF'] . ' method="post">';
echo '<form method="post">';
You only need to change this if it's logging you out
-
In admin, go to the customer list.
Click on a customer to go into their details.
You will see the Private Message Box under the newsletter option in their details.
Currently the Customer Private Messages is only for leaving the customer messages - the customer can always email you if needed, but if you can't get in contact with them you're stuck with calling them (if you have a phone number).
I'll work something into a future release for the customer replying, possible taking them to the contact us page with auto populating.
-
Thanks for the reply,
At the Catalog:
I was thinking of a new page with the message, when I click on the link "You have a new message", becouse if the message is big then it destroies the design/layout and fills the hole page...
And the same in Admin: In customer listing a link for "Nr. og messages" and open in a new window
thanks alot
The message size destroying your layout/design is from the site layout itself.
In the catalog/account.php where you placed
<!-- BEGIN Private Message v1.0 --> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td class="main"><b><?php echo PRIVATE_MESSAGES_TITLE; ?></b></td> </tr> </table> <table border="0" cellspacing="0" cellpadding="2" class="infoBox" width="100%"> <tr class="infoBoxContents"><td align="left"> <?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?> <?php $result = tep_db_query("select customers_private_messages from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$customer_id . " '"); $result_array = tep_db_fetch_array($result); if ($result_array['customers_private_messages'] != "") { echo PRIVATE_MESSAGES_YES . "<P>" . $result_array['customers_private_messages']; echo '<form action=' . $_SERVER['PHP_SELF'] . ' method="post">'; echo '<input type="submit" name="submit" value="Delete Message">'; echo '</form>'; if (isset($_POST['submit'])) { tep_db_query("UPDATE " . TABLE_CUSTOMERS . " SET customers_private_messages = ('') where customers_id ='" . (int)$customer_id . "'"); echo PRIVATE_MESSAGES_DELETED; } } else { echo PRIVATE_MESSAGES_NO; } ?> </td></tr></table> <!-- END Private Messages -->
Adjust the the following items in red according to your site layout. You may choose to make them a fixed width and not a percentage. I choose percentage as the stock default layout has this in the middle of the left and right colum, therefore the 100% would take advantage of the most area it could before wrapping the text. And I also aligned it left to ensure the text was left justified. Your layout could be different, or your customization could be creating a conflict.
<tr>
<td><table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr>
<td class="main"><b><?php echo PRIVATE_MESSAGES_TITLE; ?></b></td>
</tr>
</table>
<table border="0" cellspacing="0" cellpadding="2" class="infoBox" width="100%">
<tr class="infoBoxContents"><td align="left">
Also depending on your site layout you may want to adjust, remove or add the <table> arrangements
-
Is that you entire file?
I have atleast another 25 lines in my file after where you left off?
Did you just snip it, or was that all of it?
-
Well done :) Very good contribution
Is there any way to display just a link "you have one privat message" not the hole message in catalog and also in admin?...
thanks
What are you looking for? Possibly a link that pop's open a window with the message?
Do you want the same thing in Admin or to simply not see the message preview at all?
-
Henry,
I beleive that in the installation instruction you forgot to add /admin/includes/languages/[language]/customer.php file with the following tag:
HEADING_CUSTOMERS_PRIVATE_MESSAGES
Because in the admin section that is what you see. So I re-read your installation file (as well as the previous version) but none of them talk about /admin/includes/languages/[language]/customer.php. Can you update your installation file to reflect this?
For those who need to know, the quick fix is this:
Open /admin/includes/languages/[language]/customer.php and just before ?> add this -
define('HEADING_CUSTOMERS_PRIVATE_MESSAGES', 'Private Messages');
Save and upload.
Thanks for an awesome contribution!
Rolly
Thanks Rolly - I guess I should stay away from last minute changes when it's 3am >_<
-
I found the problem. :) For some reason I removed a from in part of the code.
Glad you found it.
-
Hello custodian ! Thank you for your great work .
I made the same function on my site long time ago , BUT yours much more neat and professional.
I added this to index page .
If adding this messages to account page , I think would be better to place some note on index page ,for registered visitors , to view the massege
btw I got error on admin/custommerce.php
<td class="main"> <?php if ($processed == true) { echo $cInfo->customers_private_messages . tep_draw_hidden_field('customers_private_messages'); } else { echo tep_draw_textarea_field('customers_private_messages', 'soft', '75', '5', ($cInfo->customers_private_messages)); } ?></td>
there was BR tag after last bracket , so I removed it , but maybe possible just placed it after ?> .
again , thank you
Miclosh
The message location was a draw - My users go to their account page automatically after login,so I opted to place it there AND my index is busy enough :)
I plan on adding a notifier into application_top so that they'll know when they have a message if they are currently logged in.
The <BR> tags were from my editor, it was attempting to maintain layout by adding them. I though I got them all - thanks for the heads up... I fix that now.
-
If you click on the customer you want and select edit and go into their account details.. at the bottom of the screen you don't see a text box to enter the notes?
-
Error in v1.0 SQL entry
Was listed as
ALTER TABLE customers ADD private_messages LONGTEXT NOT NULL;
should have been
ALTER TABLE customers ADD customers_private_messages LONGTEXT NOT NULL;
v1.1 corrects with some other trivial corrections
-
It's currently running on my site.
I have included 4 screen shots in the contribution - one of each screen/phase from my site to show how it works and what is looks like.
-
this sounds really neat! :)
is there an option for global messages (such as, sending every customer the same message - like a sale notification)
do you have a sample site we can see this in action at?
"Broadcast" and "Clear All" are two features that I am working on and will have in a later release.
-
Customer Private Messages
==================
I designed this contribution in order to provide an additional means of communication between ourselves and the customers. Customers entered inaccurate or false email addresses; which thereby breaks down the means of interacting with the customer. Invoices fail to reach their destination for many reason, email errors, they moved, change ISP's, exceed mail quota's, do not check their email often or intentionally provided a false email.
Additionally there are reasons which do not warrant an email, and sending an email for certain issues may be deemed unprofessional or simply nagging in nature.
I needed a means to notify the customer when they would login that their email address is not correct and we cannot contact them, or a simple
"We've added the other items that you requested to your order"
"Happy Birthday - We'd like to give you...."
The uses are endless.
How it works and what it does
=====================
Once they login successfully and are forwarded to their account information, they will see any Messages that you may have left for them. If there are no messages, it will also inform them of this. I was debating having the box not displayed if there were no messages, but I felt that if they knew there is a messaging system it may remind them to look at it and not quickly skip over it, so if no messages are found it will say so.
**********************************************
Please DO NOT post enhancements, questions, suggestions to the contribution section. My effort is to keep this as clear, straightforward and as easy to understand and install as possible. If you have suggestions, comments or improvements, please post to the forum. I will implement them with future releases. Thank you for understanding and respecting my wishes.
**********************************************
-
For one of my clients I wrote a modfication that, after a successful checkout, will encrypt and store the customer's card number for future checkouts. On the next checkout, the customer has a choice of entering a new card number or selecting "Use this card: XXXXXXXXXXXX1234" where it will then checkout using the customer's stored number. It was fairly simple, requiring a new payment module for submitting the stored numbers through the store's default CC module and a modification to checkout_process.php
But, remember that you are assuming huge liabilities by doing this. If your server gets hacked and they get those numbers, you're screwed. Only if you're going to invest in the security measures necessary to keep that server safe, don't bother with it.
I'd be quite interested in that mod as well -
-
Your issue is that you do not have the site at a fixed width.
When I make my browser window smaller, your web page should not shrink with it, but it does.
Try what I said on your site and then go to mine and try the same thing. You'll see the difference.
It enables the page to hold it's forrmatting.
They way you have it, when the sub cat are displayed, the page needs more room, so instead of narrowing the center (where the products are listed), instead it wraps the right colum over to the left side.
Meanwhile all that empty whitespace isn't being utilized for contracting and expanding.
You need to have the entire site wrapped in a table with a fixed width of around 700px to 750px
Also depending on the layout changes you've done, you may have certain tables already set at minimums that are to large. Other than the main table for the site, its usually a good practice to use % for inner table - to avoid them pushing the others too far - which rearranges the layout as you are seeing.
-
Hello All,
I am really interested in installing this contribution:
Manual Order Entry
contribution 585
The problem is that it is not compatible with the latest version of OSC. It returns
tep_array_merg
errors when installed.
Is there an updated version?
Thanks.
Steve
I useOrder Entry and also have the latest OSC - it works fine. No errors. Therefore I'd guess that you have installed incorrectly or have another contrib interfering.
-
I have installed Paypal. When a customer goes to use it, the payment module opens in the same window which then the customer doesnt finish the checkout process because they are not redirected back to the checkout. Where do I put in the HTML _blank for it to open in a seperate smaller window. And if you could give me the correct HTML lines to use.
Thanks in advance
Mels
Install the PayPal IPN contirbution
-
That's fantastic!
I'll need to give this a try tonight during some scheduled down-time.
I often need to note on the account coments what was removed due to being out of stock or back ordered.
Will this list the price as $0.00 also?
Not that it needs to be, just cusrious as what to expect.
-
I am having an issue with my coolmenu. It was working yesterday but I made some changes and I can't figure out where I messed it up. My coolmenu is showing on the main page and on shipping, contact, conditions, etc but when you click on a category or any subcategory it is a blank menu. Can someone let me know which file I would need to adjust to fix this? I'm pretty sure I know what code I need to add, just need to know what file controls this. If you need me to post a particular file, let me know. Thanks in advance!!! Here's my website so you can see what I mean:
The link is password protected, can't get in.
-
I am curious as to what instances one would need to change an order, when the customer has alreay paid for their order for there to be an order to edit?
I use it mainly for refund/adjustments - Items sell out fairly fast and sometimes I need to refund an item that is no logner available but has been ordered and paid for.
The only thing I do wish I could do is edit the invoice and have it show 0 (instead of removing it), this way they would know what they ordered, but also know that it was not included in their order (Backordered - out of stock - etc...)
-
Yeah, I changed zip, state and city also
Still having this issue?
-
I also want to add an image manager (auto generate thumbs). Is there a mod in particular that stands out for this?
OTF w/GD is highly recommended
Get it here
-
This contirb (header tags) is one of ony two contribs that I absolutely could not get to work and I just gave up.
My product_info was the same, I even thought it was something I did, so I went through it again (3 times) and ever time the same. If an answer is found to this persons problem, please post it in detail here so that I may try once again.
HELP "1054 - Unknown column 'cc_cvv' in 'field list'
in General Add-Ons Support
Posted
See this
http://www.oscommerce.com/forums/lofiversion/i...hp/t132093.html