aresman Posted July 1, 2005 Share Posted July 1, 2005 Problem sorted.... There was a file missing from the "IF MODIFYING ONLY" files <_< . I downloaded it from the "IF ON CLEAN" files instead. Karen <{POST_SNAPBACK}> Ditto. Thanks for finding it - it was driving me nuts. I think the install package may need to be updated... Quote Link to comment Share on other sites More sharing options...
staykalm Posted July 1, 2005 Share Posted July 1, 2005 Ditto. Thanks for finding it - it was driving me nuts. I think the install package may need to be updated... <{POST_SNAPBACK}> Glad I was of some help instead of asking for it for a change :D Karen Quote If at first you don't succeed, GIVE UP!!!!!! Link to comment Share on other sites More sharing options...
omidhz Posted July 10, 2005 Share Posted July 10, 2005 Hi, Thanks for the great contribution. I just have one problem and that is with the layout of the table. I can't change the layout to look like other tables. here is the link to my create_account.php page: CLICK HERE Please let me know how can I change the table layout (and color) so it looks like other fields on the page. :thumbsup: Quote Regards, Link to comment Share on other sites More sharing options...
t4evay2k Posted July 18, 2005 Share Posted July 18, 2005 Hi all, I am a complete :-" newbie in oscommerce, and am in the process of getting to grips with all this php so please excuse my knowledge! Anyways found this contribution and fits my needs completly. Downloaded the contibution, unzipped it, installed both sets of the files (fresh and modifyed ones), Now onto the hard bit :( mysql and phpmyadmin! i have not a single clue about either! when i log into cpanel i do see mysql, but searched evrywhere and cant find phpmyadmin. The time of this post os 1:45 am after hours of searching through google and oscommerce forums searching for the answer still........ nothing. I managed to download phpmyadmin and thats about it! something about ftp? and also uploading to root directory which makes no sense to me! Would appreciate any help or directions in the right way. Understandable if no1 has the the time to show me as you seem all to be pros... Thanks anyway Regards Ant Quote Link to comment Share on other sites More sharing options...
Guest Posted July 18, 2005 Share Posted July 18, 2005 Ant, Click on MySQL. The page that comes up should have a link to phpMyAdmin near the bottom. -jared Quote Link to comment Share on other sites More sharing options...
Stevo_ Posted July 22, 2005 Share Posted July 22, 2005 Hey guys, When trying to create a new account, i get the error: 1054 - Unknown column 'customers_info_source_id' in 'field list' insert into customers_info (customers_info_id, customers_info_number_of_logons, customers_info_date_account_created, customers_info_source_id) values ('68', '0', now(), '7') [TEP STOP] Also, in admin, When i click onto "Customers" I get the error: 1054 - Unknown column 'customers_info_source_id' in 'field list' insert into customers_info (customers_info_id, customers_info_number_of_logons, customers_info_date_account_created, customers_info_source_id) values ('68', '0', now(), '7') [TEP STOP] I follwed the instructions that mention searching for a duplicate "TABLE_CUSTOMERS_INFO" in catalog\create_account.php However i dont PLEASE HELP! Quote Link to comment Share on other sites More sharing options...
Stevo_ Posted July 24, 2005 Share Posted July 24, 2005 Nevermind, just re-did it and its working fine now . Quote Link to comment Share on other sites More sharing options...
omidhz Posted July 24, 2005 Share Posted July 24, 2005 Hi, Thanks for the great contribution. I just have one problem and that is with the layout of the table. I can't change the layout to look like other tables. here is the link to my create_account.php page: http://bargaincollection.com/shop/create_account.php Please let me know how can I change the table layout (and color) so it looks like other fields on the page. :thumbsup: Quote Regards, Link to comment Share on other sites More sharing options...
sarah1980 Posted August 3, 2005 Share Posted August 3, 2005 Just regarding the SQL queries to be put into the database: can anyone tell me what the consequences would be if, instead of the standard 5 line code provided in the contribution, I entered an additional line into the database and also changed the names of some of the other standard codes: INSERT INTO sources VALUES (1, 'Google'); INSERT INTO sources VALUES (2, 'Yahoo'); INSERT INTO sources VALUES (3, 'A link on another website'); INSERT INTO sources VALUES (4, 'Saw an ad in a magazine'); INSERT INTO sources VALUES (5, 'Referred by a friend'); INSERT INTO sources VALUES (6, 'I am a returning customer'); Would there be any consequence at all or can we simply go ahead and enter as many referral thingies as we like? Quote Link to comment Share on other sites More sharing options...
sarah1980 Posted August 3, 2005 Share Posted August 3, 2005 Just regarding the SQL queries to be put into the database: can anyone tell me what the consequences would be if, instead of the standard 5 line code provided in the contribution, I entered an additional line into the database and also changed the names of some of the other standard codes: INSERT INTO sources VALUES (1, 'Google'); INSERT INTO sources VALUES (2, 'Yahoo'); INSERT INTO sources VALUES (3, 'A link on another website'); INSERT INTO sources VALUES (4, 'Saw an ad in a magazine'); INSERT INTO sources VALUES (5, 'Referred by a friend'); INSERT INTO sources VALUES (6, 'I am a returning customer'); Would there be any consequence at all or can we simply go ahead and enter as many referral thingies as we like? <{POST_SNAPBACK}> Well I modified the table so that it has the above referral sources in it - it didn't seem to do anything to the database. Now, I've modified all the files as required by the contribution instrucitons, but when I get to order_info.php to enter in my name and address details the drop down referral box doesn't appear. When I highlight the section where its supposed to appear, you can see that there is definitely something that's trying to come out (http://www.tallpoppycraft.com/catalog/order_info.php?osCsid=) down between the continue button and the fax number box. If anyone can provide any ideas as to what might be wrong I'd appreciate it! Quote Link to comment Share on other sites More sharing options...
sarah1980 Posted August 3, 2005 Share Posted August 3, 2005 Re my problem in the post just above: I think this has something to do with the fact that I have PWA. If anyone can provide some insttruction on how to get this contribution working with PWA I'd appreciate it. Quote Link to comment Share on other sites More sharing options...
sarah1980 Posted August 6, 2005 Share Posted August 6, 2005 Re my problem in the post just above: I think this has something to do with the fact that I have PWA. If anyone can provide some insttruction on how to get this contribution working with PWA I'd appreciate it. <{POST_SNAPBACK}> Regarding Tim's post of July 11 2004, he has kindly provided me with the code to that will make this referral contribution compatible with PWA. I post the code here with his permission: In catalog/includes/modules/Order_Info_Check.php add: <!-- //rmh referral start --> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td class="main"><b><?php echo CATEGORY_SOURCE; ?></b></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox"> <tr class="infoBoxContents"> <td><table border="0" cellspacing="2" cellpadding="2"> <tr> <td class="main"><?php echo ENTRY_SOURCE; ?></td> <td class="main"><?php echo tep_get_source_list('source', (DISPLAY_REFERRAL_OTHER == 'true' ? true : false)) . ' ' . (tep_not_null(ENTRY_SOURCE_TEXT) ? '<span class="inputRequirement">' . ENTRY_SOURCE_TEXT . '</span>': ''); if ($entry_source_error) { echo ' ' . ENTRY_SOURCE_ERROR; } ?></td> </tr> <?php if (DISPLAY_REFERRAL_OTHER == 'true') { ?> <tr> <td class="main"><?php echo ENTRY_SOURCE_OTHER; ?></td> <td class="main"><?php echo tep_draw_input_field('source_other') . ' ' . (tep_not_null(ENTRY_SOURCE_OTHER_TEXT) ? '<span class="inputRequirement">' . ENTRY_SOURCE_OTHER_TEXT . '</span>': ''); if ($entry_source_other_error) { echo ' ' . ENTRY_SOURCE_OTHER_ERROR; } ?></td> </tr> <?php } ?> </table></td> </tr> </table></td> </tr> <!-- //rmh referral end --> This comes after the section for fax number in my version. i.e. directly after: <?php if ($is_read_only) { echo $account['customers_fax']; } elseif ($processed) { echo $fax . tep_draw_hidden_field('fax'); } else { echo tep_draw_input_field('fax', $account['customers_fax']) . ' ' . ENTRY_FAX_NUMBER_TEXT; } ?></td> </tr> </table></td> </tr> </table></td> </tr> Quote Link to comment Share on other sites More sharing options...
^Pariah^ Posted August 21, 2005 Share Posted August 21, 2005 Awww Crap ! I've had this working for months without issue In the last few days I have done something to kill it And can't seem to understand what Fatal error: Call to undefined function: tep_get_source_list() in /home/leatherandlaceftp/www/catalog/create_account.php on line 534 Any hints muchly appreciated :blush: Quote Link to comment Share on other sites More sharing options...
^Pariah^ Posted August 21, 2005 Share Posted August 21, 2005 Awww Crap ! I've had this working for months without issue In the last few days I have done something to kill it And can't seem to understand what Fatal error: Call to undefined function: tep_get_source_list() in /home/leatherandlaceftp/www/catalog/create_account.php on line 534 Any hints muchly appreciated :blush: <{POST_SNAPBACK}> Call me stupid ! I have been religiously making backups of each file I edit That aint stupid But restoring the wrong one is ! How Embarassment Quote Link to comment Share on other sites More sharing options...
pmaonline Posted August 25, 2005 Share Posted August 25, 2005 hi all, i need to select all users from my table and i made this query SELECT customers .*, address_book .*, sources_other .* FROM customers INNER JOIN address_book ON address_book . customers_id =customers . customers_id JOIN sources_other ON sources_other . customers_id=customers . customers_id WHERE customers . customers_id >500000 but this only selects the customers who has referrals, and i need them all can someone help me ? Thanks. Quote Link to comment Share on other sites More sharing options...
pmaonline Posted August 25, 2005 Share Posted August 25, 2005 hi all, i need to select all users from my table and i made this query SELECT customers .*, address_book .*, sources_other .* FROM customers INNER JOIN address_book ON address_book . customers_id =customers . customers_id JOIN sources_other ON sources_other . customers_id=customers . customers_id WHERE customers . customers_id >500000 but this only selects the customers who has referrals, and i need them all can someone help me ? Thanks. <{POST_SNAPBACK}> i'm sorry this last post - this query don't shows me the referrals from the drop down menu . What's wrong... Quote Link to comment Share on other sites More sharing options...
pmaonline Posted August 25, 2005 Share Posted August 25, 2005 i have this file to export my customers info and i need to export the referrals too : how can i change my file. Thanks. <?php require('includes/application_top.php'); if (!$HTTP_GET_VARS['submit']) { ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//DE"> <html <?php echo HTML_PARAMS; ?>> <head> <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> <title><?php echo TITLE; ?></title> <link rel="stylesheet" type="text/css" href="includes/stylesheet.css"> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#CCCC33"> <!-- header //--> <?php require(DIR_WS_INCLUDES.'header.php'); ?> <!-- header_eof //--> <!-- body //--> <table border="0" width="100%" cellspacing="2" cellpadding="2" > <tr> <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft"> <!-- left_navigation //--> <?php require(DIR_WS_INCLUDES.'column_left.php'); ?> <!-- left_navigation_eof //--> </table></td><td> <!-- body_text //--> <?php echo "<center><font face=verdana size=2>Exportar e Guardar dados dos clientes no seu computador<br> ID superior a 500 000</font><br><br>"; echo '<form action="'. $phpself.'">'; echo '<input type="submit" value="Clientes Novos" name="submit"></form>'; ?> </td> </table> <!-- footer //--> <center><font color="#666666" size="2"></font></center> <!-- footer_eof //--> <br> </body> </html> <?php } else { $fim_linha = chr(13).chr(10); $fim_file = "[FIM]"; $contents5=$fim_file; //final de ficheiro $contents1="primeiro nome;ultimo nome;contribuinte;codigo cliente;email;morada;freguesia;codigo postal;localidade;telefone;newsletter;password;xxx\n"; $user_query = mysql_query('SELECT c. * , adb. * FROM customers AS adb LEFT JOIN address_book AS c ON adb.customers_id = c.customers_id WHERE customers_default_address_id = c.address_book_id and c.customers_id>500000'); while($row = mysql_fetch_array($user_query)) { if ($row[entry_gender]=='m') { $contents.="Masculino".";"; } if ($row[entry_gender]=='f') { $contents.="Feminino".";"; } if ($row[entry_gender]=='') { $contents.=" ".";"; } $contents.=$row[customers_firstname].";"; $contents.=$row[customers_lastname].";"; if( $row[customers_dob]=='0000-00-00 00:00:00') { $contents.="N?o especificado".";"; } else { $contents.=$row[customers_dob].";"; } $contents.=$row[entry_NIF].";"; $contents.=$row[customers_id].";"; $contents.=$row[customers_email_address].";"; $contents.=$row[entry_street_address].";"; $contents.=$row[entry_postcode]." - ".$row[entry_city].";"; $contents.=$row[entry_zone_id].";"; //$contents.=$land.";"; $contents.=$row[customers_telephone].";"; $contents.=$row[customers_newsletter].";"; $contents.=$fim_linha; } Header("Content-Disposition: attachment; filename=clientes_novos.csv"); print $contents; print $contents5; } require(DIR_WS_INCLUDES . 'application_bottom.php'); ?> Quote Link to comment Share on other sites More sharing options...
RObW Posted August 25, 2005 Share Posted August 25, 2005 I think there is a bug in the code - when the DISPLAY_REFERRAL_SOURCE variable is set to false (i.e. 'Display Referral options if "ref=###" is set' is FALSE), the referral form is NEVER displayed. The way I understand the functionality, this variable should cause the form to be hidden ONLY if a ref=xxx referal was supplied. If not supplied, the form should still be displayed. This occurs becuase the variable referral_id is ALWAYS registered, even if it is blank. To fix this: In catalog\includes\application_top.php change //rmh referral start // set the referral id if (!tep_session_is_registered('referral_id') || isset($HTTP_GET_VARS['ref'])) { to //rmh referral start // set the referral id if (!tep_session_is_registered('referral_id') && isset($HTTP_GET_VARS['ref'])) { Cheers Rob Quote Link to comment Share on other sites More sharing options...
pmaonline Posted August 30, 2005 Share Posted August 30, 2005 i have already chaged it but it does the same Quote Link to comment Share on other sites More sharing options...
Guest Posted October 7, 2005 Share Posted October 7, 2005 I also am using PWA and need this to work on a per-order basis. I've inserted the code above (thanks, BTW!) into Order_Info_Check, and I had to make some additional changes to Order_Info_Process to make it required. That's working fine, however, I'm not sure how to get this selection to actually go into the db in the "referral_id" field I created for it in the orders table. Has anyone gotten anything similar working? Thanks. Quote Link to comment Share on other sites More sharing options...
Guest Posted October 8, 2005 Share Posted October 8, 2005 I also am using PWA and need this to work on a per-order basis. I've inserted the code above (thanks, BTW!) into Order_Info_Check, and I had to make some additional changes to Order_Info_Process to make it required. That's working fine, however, I'm not sure how to get this selection to actually go into the db in the "referral_id" field I created for it in the orders table. Has anyone gotten anything similar working? Thanks. Ah, okay, I think I've got it working. Although I haven't even tried dealing with "other" strings yet. I ended up having to put the field in the customers table after all (I thought I could skip the customers table since the customers don't create accounts; I didn't realise its function as a temporary holding place). Also, I had to modify the class in order.php to include this variable. Whee! :-) Quote Link to comment Share on other sites More sharing options...
omidhz Posted October 12, 2005 Share Posted October 12, 2005 Hi, :thumbsup: Thank you all for this great contribution. Could someone please explain how can we add the referral column to the orders.php. It is very hard to get back to the customers.php every time to check where that customer came from. Thank you. :) Quote Regards, Link to comment Share on other sites More sharing options...
VPSsupport Posted November 6, 2005 Share Posted November 6, 2005 (edited) What a handy contribution, many thanks. How would I go about being able to export the referals to this report? CUSTOMER EXPORT Version 1.0 <?php echo "Export and Save Customer Data onto your Local Machine"; echo '<form action="'. $phpself.'">'; echo '<input type="submit" value="Export" name="submit"></form>'; ?> </td> </table> <!-- footer //--> <center><font color="#666666" size="2"></font></center> <!-- footer_eof //--> <br> </body> </html> <?php } else { $contents="Firstname,Lastname,Gender,DOB,Company,Address,Zip,City,State,Country,Phone, Email,Fax\n"; $user_query = mysql_query('select c.*, adb.* from customers as c left join address_book as adb on c.customers_id = adb.customers_id'); while($row = mysql_fetch_array($user_query)) { if ($row[customers_gender]=="m") { $gender = "Male"; } else { $gender = "Female"; } if ($row[entry_country_id] == 81) { $land="Deutschland"; } else { $country_query = mysql_query("select countries_name from countries where countries_id = '" . $row[entry_country_id] . "';"); $landq = mysql_fetch_array($country_query); $land=$landq[countries_name]; } $contents.=$row[customers_firstname].","; $contents.=$row[customers_lastname].","; $contents.=$gender.","; $contents.=$row[customers_dob].","; $contents.=$row[entry_company].","; $contents.=$row[entry_street_address].","; $contents.=$row[entry_postcode].","; $contents.=$row[entry_city].","; $contents.=$row[entry_piva].","; $contents.=$land.","; $contents.=$row[customers_telephone].","; $contents.=$row[customers_email_address].","; $contents.=$row[customers_fax]."\n"; } Header("Content-Disposition: attachment; filename=export.csv"); print $contents; } require(DIR_WS_INCLUDES . 'application_bottom.php'); ?> Edited November 6, 2005 by VPSsupport Quote Regards, Clive Link to comment Share on other sites More sharing options...
Mookie_Jam Posted December 2, 2005 Share Posted December 2, 2005 GREAT Contrib!!! Is there anyway I could have it activated but without been obligatory to be filled up?? I have the problems that the "Other" Referral option must be filled even if they do not choose "other" option.. :( So I would like to have them vidible, but not a must field to be filled :D Anyway, it works fine!!!! :thumbsup: Quote Link to comment Share on other sites More sharing options...
Alley Kat Posted December 2, 2005 Share Posted December 2, 2005 Hi all; I installed the contrib, and all went wel except for one part - it all works except that, although the Referral choice is required, it's not enforced when registering a new account. It doesn't appear on the validation dialogue along with the other fields. I've checked my code, but might be having code blindness now... any pointers would be much appreciated. All works fine, no errors, just no validation/enforcement of the referral source drop-down Cheers, Bill Quote 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.