Chronoz
-
Posts
107 -
Joined
-
Last visited
Posts posted by Chronoz
-
-
I am reading your last 7 posts, and I really have no clue on what you are talking about. You have a SQL file with the contribution, you need to execute it. Do it.
The question "what do I put on each field" has no answer since you have to put nothing, you just need to execute those SQL instructions on phpmyadmin or whatever you use. Any more questions?
It's fine I found another add-on!
Nope, no more unanswered questions!
thanks for your time!
Yes, and "Bumps" will get ignored every time.Noticed!
Thanks for your time
Steven
-
Bump
I've searched and still noone has ever asked this question!
How unlucky!
Steven
-
No one has the answer?
I've looked everywhere! =..(
-
-
Hello!
I'm looking threw this forum and I cant find that someone has asked a question about this
I'm doing the SQL part and it says to
Ive done SQLs before but what do I put in each field?
Like in:
Field: idx_products_id
Type: what do I put here?
Length/Values: if necesary
etc...
I'm sorry to ask such a question but I'm just missing it, and if I just put in idx_products_id and leave everything as default it gives me a popup message saying that "this is not a number" because I have VARCHAR selected in Type
Thanks for your help!
Steven
Hello again, I dont have any errors, but I still cant figure out that above part.
And I started to browse the first few pages to see if I can find an answer to this following question: How can I make a row of 3 items because I only want to feature 6 items in 2 rows of 3 and 3.
If I set a 6 item only in the admin I get a row of 4 then 2.
I saw someone in the begining asking my question but the other way around! haha! How to add 4 products in one row, and I also saw a person asking how can he make 1 product in 1 row and for it to go downwards, etc.
Any help is much appreciated!
Thanks! :D
-
I ran into the same problem and this solved it for me as well and is probably worth repeating:
I downloaded the package 'Featured Products 161 with STS 453 instructions' and installed everything but did not have the Featured Products section show up on my store's homepage. I repeated the entire install thinking I missed something with no luck.
Following Didgemandu's suggestion I went to the submission titled: 'featured.php now showing products from all nested subcategories' and uploaded the file: includes/modules/featured.php and the Featured Products displayed properly on my homepage.
I was browsing some new parts of this forum and I found it! Perfect!
Thanks for the help!
-
Ok, so I finished installing everything, no error messages anywhere, just that when I try to add something to Featured items they do not appear, I guess it's because of the above post I made.
-
Hello!
I'm looking threw this forum and I cant find that someone has asked a question about this
I'm doing the SQL part and it says to
alter table featured add index idx_products_id (products_id);Ive done SQLs before but what do I put in each field?
Like in:
Field: idx_products_id
Type: what do I put here?
Length/Values: if necesary
etc...
I'm sorry to ask such a question but I'm just missing it, and if I just put in idx_products_id and leave everything as default it gives me a popup message saying that "this is not a number" because I have VARCHAR selected in Type
Thanks for your help!
Steven
-
Ok, I have question on how to use this add-on:
I have a policy where if they have 120 points then can redeem 6$ and if they have 400 points they can redeem 20$ but how can I set it up where as if they had 400 points and they only wanted to spend 120 points?
Also how can I only make them choose between 120 and 400?
Is that even posible with this add on?
thanks
Steven
-
I got it!
When i check out, it appears the option now, what it was was the following:
The Auto expire points and reminder HAVE to be in blank if you dont want to use them, I had them set to 0
duh!
-
Ok I found a flaw, I thought I had it down, but it was too good to be true, heres a SS
Even though under Configuration/Points/RewardsV2.00 in my admin panel I have the Enable customers to Redeem points at checkout? selected at True it still doesnt appear when I check out an item, any help?
-
Ok, I just did it in www.mysite.com... works fine, but it was the very first thing i did!
Made a new database
Uploaded the Oscommerce RC2
Installed it
Went straight to my phpadmin and follwed the SQL steps
Then I went to the ADMIN part and made sure that under Modules I had the +install button
was there!
This is how I did it when I made it under www.mysite.com/catalog
And when I had trouble it was when I had other add ons installed already
-
But what has me bugged is this +install button you are talking about. The only play I remember seeing any type of install button is in the payment modules.
Yeap thats the one im talking about
Chances are the included modified files are for a different version of OSC...Just to be sure are on the same page I hope that you are using points and rewards v20d-corrected + french version? That is the one that I used and everything went pretty well as expected.
Ill download the +french cuz Im using another one
Thanks for the tips!
But you did mention:
What do you mean by that?You just have to make sure you coorect the paths in your configure files.Thanks!
Appreciate your help! :D
-
You cant used the modifed files.
I tried replacing the files that I have now, I cant access my admin page.
I remade a database and before I installed the oscommerce RC2 I replaced the files then installed, I cant acccess admin nor catalog, I get error messages
No good
-
Would it have to do with me making my website under: www.mysite.com instead of www.mysite.com/catalog?
When I did it with www.mysite.com/catalog I was able to at least see the +install button under my Admin page
And now that I make it www.mysite.com everything is fine besides the fact that I cant even see the +install button.
I doubt but just to throw an idea that popped up
-
What I'm goin to do is start a fresh website and add everything that is in the folder called modified files and then add the other files
See how that goes!
-
Steven
With you redoing everything step by step and still not seeing it I have to say without seeing everything for myself I am kind of at a loss to tell you where to look. Maybe someone else can jump on this thread and help you.
Have you had any success installing any other addons?
Yea, I've done a template for the site, Meta Tags, and Thumb images.
I'm going to double check the catalog part, but I know for sure the admin part is perfect because I doubled checked that already.
If you want David I can give you my info and you can hop on and check it out aswell, if you want to, if not no worries. I'll PM you the info. Let me know! :D
Thanks for all your help!
Steven
-
When I tried to uninstall everything and my whole website got messed up and the database went to the garbage, so I redid everything and now my only problem is that under Modules/Order Total the Redemption Points is not even there as before I couldnt install it and now its not there. <_<
I checked everything, I might be missing something but I have no idea what it is!
Any ideas David?
-
Ok, cool! Will do! I'll let you know!
Thanks David!
-
Bump, tried again today and I still cant install it, thats weird.
I thought that problem could be that I was xfered to a SSL server but I was able to install it the first time I did it, then I removed everything and did it again and in the mean time I was xfering pages to the SSL server (includes/configure.php) but I dont think that has to do with anything.
Any ideas what this could be?
-
*sigh* <_<
Im having a problem now
In the my admin panel under Modules/Order Total Modules I cant install the Points Redeemptions, I click on the install and the page refreshes and it stays with the "+ install" icon and I check my shopping cart and it doesnt appear.
I redid this step only thinking that this has to do with that part, I might be wrong.
Any ideas?
Thanks in advanced!
ADMIN STEP = 1. open admin/orders.php This will add a quick pending points conformation check box. To be used when confirming order or updating order status. This option will only show up when there are pending points for that order and only if Auto Credit Pending Points is set to "false". **note that this step has 2 parts** Find... (start at aprox. line 54 to 55) $customer_notified = '1'; } ... and add after..... ######## Points/Rewards Module V2.00 BOF ################## if ((isset($HTTP_POST_VARS['confirm_points']) && ($HTTP_POST_VARS['confirm_points'] == 'on'))||(isset($HTTP_POST_VARS['delete_points']) && ($HTTP_POST_VARS['delete_points'] == 'on'))) { $comments = ENTRY_CONFIRMED_POINTS . $comments; $customer_query = tep_db_query("SELECT customer_id, points_pending from " . TABLE_CUSTOMERS_POINTS_PENDING . " WHERE points_status = 1 AND points_type = 'SP' AND orders_id = '" . $oID . "'"); $customer_points = tep_db_fetch_array($customer_query); if (tep_db_num_rows($customer_query)) { if (tep_not_null(POINTS_AUTO_EXPIRES)){ $expire = date('Y-m-d', strtotime('+ '. POINTS_AUTO_EXPIRES .' month')); tep_db_query("UPDATE " . TABLE_CUSTOMERS . " SET customers_shopping_points = customers_shopping_points + '". $customer_points['points_pending'] ."', customers_points_expires = '". $expire ."' WHERE customers_id = '". (int)$customer_points['customer_id'] ."'"); } else { tep_db_query("UPDATE " . TABLE_CUSTOMERS . " SET customers_shopping_points = customers_shopping_points + '". $customer_points['points_pending'] ."' WHERE customers_id = '". (int)$customer_points['customer_id'] ."'"); } if (isset($HTTP_POST_VARS['delete_points']) && ($HTTP_POST_VARS['delete_points'] == 'on')) { tep_db_query("DELETE FROM " . TABLE_CUSTOMERS_POINTS_PENDING . " WHERE orders_id = '" . $oID . "' AND points_type = 'SP' LIMIT 1"); } if (isset($HTTP_POST_VARS['confirm_points']) && ($HTTP_POST_VARS['confirm_points'] == 'on')) { tep_db_query("UPDATE " . TABLE_CUSTOMERS_POINTS_PENDING . " SET points_status = 2 WHERE orders_id = '" . $oID . "' AND points_type = 'SP' LIMIT 1"); } } } ######## Points/Rewards Module V2.00 EOF ################## still at the same file . Find... (aprox. line 340) <td valign="top"><?php echo tep_image_submit('button_update.gif', IMAGE_UPDATE); ?></td> ... and add after..... <!-- // Points/Rewards Module V2.00 check_box_bof //--> <?php $p_status_query = tep_db_query("SELECT points_status FROM " . TABLE_CUSTOMERS_POINTS_PENDING . " WHERE points_status = 1 AND points_type = 'SP' AND orders_id = '" . $oID . "'"); if (tep_db_num_rows($p_status_query)) { echo '<tr><td class="main"><b>' . ENTRY_NOTIFY_POINTS . '</b> ' . ENTRY_QUE_POINTS . tep_draw_checkbox_field('confirm_points', '', false) . ' ' . ENTRY_QUE_DEL_POINTS . tep_draw_checkbox_field('delete_points', '', false) . ' </td></tr>'; } ?> <!-- // Points/Rewards Module V2.00 check_box_eof //-->
-
Forget it! I did it! WOW! I cant believe it! Amazing and I'm new at this stuff! WOW!!
Thanks for the help David! Appreciate it! =D
-
Steven
Make sure you run the sql statement for your database. That should fix your errors below
Thanks David for the response!
Ok, I tried to follow the steps for the SQL, its my first time and I dont have any training so I think I did it right, I browsed the Rows that were there just to get an idea and seems like everything is well. Looks good.
But I only have one question how do I do this step:
## Table structure for table 'customers_points_pending'
#
DROP TABLE IF EXISTS customers_points_pending;
CREATE TABLE customers_points_pending (
unique_id INT(11) NOT NULL AUTO_INCREMENT,
customer_id INT(11) NOT NULL DEFAULT '0',
orders_id INT(11) NOT NULL DEFAULT '0',
points_pending DECIMAL(15,2) NOT NULL DEFAULT '0.00',
points_comment VARCHAR(200),
date_added DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
points_status INT(1) NOT NULL DEFAULT '1',
points_type VARCHAR(2) NOT NULL DEFAULT 'SP',
PRIMARY KEY (unique_id)
) TYPE=MyISAM;
Thats the only part I havent been able to figure out <_<
Thanks in advanced!
Steve
-
The file I downloaded was ## POINTS AND REWARDS MODULE V2.0d ## CORRECTED Phosky 19 Jul 2006
Featured Product Support v1.5.4
in General Add-Ons Support
Posted
I understand, but if you really read my posts you could see that my real problem was with the rows not with SQL, because I didnt get any errors anywhere so it wasnt as important.
It's funny how easy it is to notice when someone is talking with there gut.
Oh I will enjoy my new add-on ;)
Thanks!
Steven