kevbev16

No at the beginning i purchased for 299 euros the version which included, "non- open source code", which i now realise means the files were encrypted. so at that time i had NO php files. the software included so many problems the list of features that did not function were far more than those that actually worked. i tried getting these problems solved with their technical support but it was like hitting my head against a brick wall. after 6 months or so of talking to them trying to get the problem solved i realised i had 2 options; either scrap the script and cut my loses or buy the, "enterprise version" for 1999 euros and try to get the problems fixed myself. once i had paid this, i realised that the reason why they could never solve my problems was becuase the php coding was awful and it includes no programming for the features i talked about in the previous post. they then basically said they knew how to solve the problems but they wanted more money as it was classed as customization. so in answer to your question, at one point the files were encrypted and then when i paid for the enterprise package they become de-crytped, and now i am left with a useless script. i hope that clears things up. kevin

i just wanted to warn you about buying from AJ square. AJ squares' auction software is the worst php script I have ever bought. AJ squares website looks very professional and the demos are fantastic but when you buy the package for 299 euros you are not given, any php files thus you basically can't edit anything on the site. Nearly all the features it states as having do not function properly. I have spent a year trying to solve the problems with their, "customer support", which I can categorically say is the most ineffective waste of time. They have managed to solve hardly any problems. As the site does not actually function properly and you do not have any php files, you cannot try and solve the problems thus the website is obsolete. You will have to pay an extra 1999 euros to actually get the, "open source code", which is basically the wrong name for decrypted files. The problems that you face when buying this, "enterprise package" for just under 2000 euros. Firstly, the bidding system does not work properly; for the price of 1999 euros, you would expect it to have a proxy bidding system. The search engine does not work. It does not recognised when an auction has ended thus bidding can still occur after an item has expired. The payment system from user to user does not function. It will not recognised if someone has paid. The whole format of a, “Dutch auction” does not work. The number of errors is endless. The php script itself is appallingly written and I have had several developers look at it, and they all commented about how unprofessionally written it was. I WOULD ADVISE ANYONE LOOKING TO BUY THIS SCRIPT, PLEASE DON'T! I have been completely ripped off and after asking for a refund they were extremely rude, which was the contrast of their friendly behaviour before I gave them the money. BEWARE, STAY AWAY FROM ANY AJ SQUARE PRODUCTS, despite how professional they may look on the demos. IF you want to test the validity of the company, try calling their, "American headquarters" and prepare to get forwarded to an Indian office, which is where they actually operate.

sorry this has come from another topic but it revolves around the search engine on my sitehttp://www.bid4tackle.com/search.php there are alot of problems with this page. firstly, if you select the "buy it now" box and then type in "fox" at the search box to the left it shows all "fox" products independant of whether they are "buy it now". this also seems to be the case when you type in the item condition as "New" or "old" it will display all items called "fox" even though they are not that condition. this would suggest that it is searching for the name in the search box and ignoring and ticks that have been made in the "search options" section. likewise if you search for price "0" to "£100" and also tick "buy it now" it will display all "buy it now" items despite not being in that price bracket. finally, when you select the location box and tick the "worldwide" or "europe" box it does not show the UK for some reason. it is searching for the posting location rather than te users regestration area. i understand there is loads there to do but if anyone could help me i would be very grateful if($mode=="searchlist") { if($_REQUEST[chk]=="yes") { $sql="select * from placing_item_bid where bid_starting_date <= now() and status='Active' and selling_method!='want_it_now' and selling_method!='ads' and "; if($_REQUEST[chkitemspriced]) { $chkitemspriced=$_REQUEST[chkitemspriced]; $max_cur=$_REQUEST[txtpricedfrom]; $min_cur=$_REQUEST[txtpricedto]; $sql.=" (min_bid_amount >= $max_cur and min_bid_amount <= $min_cur) and "; } if($_REQUEST[chkitemscondition]) { $chkitemscondition=$_REQUEST[chkitemscondition]; $itmcnd=$_REQUEST[cboitemcondition]; $sql.=" item_specify=\"$itmcnd\" and "; } if($_REQUEST[chkbuyitnow]) { $chkbuyitnow=$_REQUEST[chkbuyitnow]; $show="buy"; $sql.=" selling_method='fix' and "; } if($_REQUEST[chkitemslistedsingle]) { $chkitemslistedsingle=$_REQUEST[chkitemslistedsingle]; $show="bid"; $sql.=" selling_method='Auction' and "; } if($_REQUEST[chkitemslisteddouble]) { $chkitemslisteddouble=$_REQUEST[chkitemslisteddouble]; $show="bid"; $sql.=" selling_method='dutch_auction' and "; } if($_REQUEST[chklisted]) { $show="bid"; $sql.=" payment_gateway='' and "; } if($_REQUEST[chklocation]) { $chklocation=$_REQUEST[chklocation]; $ship=$_REQUEST[cbolocation]; $show="bid"; if($ship==1) { $sql.=" shipping_route like \"%$ship%\" and "; } else { $sql.=" shipping_route like \"%$ship%\" and "; } } } $sql=rtrim($sql," and ")." and expire_date >=now()"; //echo $sql; } Kind regards, Kevin [attachment deleted by admin]

Thanks for your help so far- i am very grateful. How can the search box on the left hand side be changed so it functions in the same way as the one at the top of the page that workshttp://www.bid4tackle.com/search.php there are so many problems with that left hand column tick box search. firstly, if you select the "buy it now" box and then type in "fox" at the search box to the left it shows all "fox" products independant of whether they are "buy it now". this also seems to be the case when you type in the item condition as "New" or "old" it will display all items called "fox" even though they are not that condition. this would suggest that it is searching for the name in the search box and ignoring and ticks that have been made in the "search options" section. likewise if you search for price "0" to "£100" and also tick "buy it now" it will display all "buy it now" items despite not being in that price bracket. finally, when you select the location box and tick the "worldwide" or "europe" box it does not show the UK for some reason. i understand there is loads there to do but if anyone could help me i would be very grateful (i have attached the relevant files. the search.php is the main one to focus on but the problems with the homepage search, may lie in the index_top.php file (near the bottom) cheers kev [attachment deleted by admin]

you are a genius!! i have just tried it again and it works when i did it before i tested it from the homepage, http://www.bid4tackle.com and it doesn't seem to work from there for some reason. it does however work from http://www.bid4tackle.com/search.php (the top search box only) thank you for your help. would the problem to the search engine on the homepage lie in the homepage file. thank you so much kev

hi Mike, Sorry i didn't really explain the problem very well. at the moment the script currently searches for continous words/phrasess. so on my website, if some one wants to search for "fox holdall" in a search it will not show up because it is not isolating them as seperate words.so i want it to search for key words so, "fox" + "holdall" and then match it up with the key words in the title.http://www.bid4tackle.com/detail.php?item_id=752 at the moment if you search for, "fox holdall" it will not work because you have to type in a continuous set of words e.g. "fox evolution" or "3 rod holdall" and i want to ge trid of this. Kind regards, Kevin

i gave that code a try but it did not seem to work. i have tried for over 6 months to get some help from AJ square but quite frankly their service is appauling. They keep telling me there is nothing they can do. Kind regards, Kevin

I bought this auction script and the search engine does not work properly. at the moment it is searching for exact phrases/words they continue on from each other so if you look on my website at http://www.bid4tackle.com/detail.php?item_id=752 it is called "Fox Evolution 3 Rod Holdall " at the moment you would have to search for the exact continuous words so "fox Evolution 3 Rod Holdall" or "fox evolution 3 rod" or "fox evolution" i.e. any keywords which follow each other e.g. "3 rod holdall". i want it to search for keywords so it would appear if you searched for "fox", "evolution" ... or key words which are not continuous so "fox" + "rod holdall" or "evolution" +"Holdall"etc. i am only 18 and know very little about php if you could help i would be much appreciative. if($mode=="keysearch") { if(!empty($key_word)) { $key_word=trim($key_word); $sql="select * from user_registration where user_name='$key_word' "; $table=mysql_query($sql); if($row=mysql_fetch_array($table)) { $user_id = $row['user_id']; } $sql="select * from placing_item_bid where status=\"Active\" and selling_method!=\"want_it_now\" and selling_method!=\"ads\" and (item_title like \"%$key_word%\" or detailed_descrip like \"%$key_word%\" or item_id=\"$key_word\" or user_id=\"$user_id\") and bid_starting_date <= now() and "; } else { $sql="select * from placing_item_bid where status=\"Active\" and selling_method!=\"want_it_now\" and selling_method!=\"ads\" and bid_starting_date <= now() and expire_date>=now()"; } if(!empty($show)) { if($show=="all") $sql.=" ( selling_method= \"auction\" or selling_method= \"dutch_auction\" or selling_method= \"fix\" ) "; else if($show=="bid") $sql.=" ( selling_method= \"auction\" or selling_method= \"dutch_auction\") "; else if($show=="buy") $sql.=" selling_method=\"fix\" "; } $sql=rtrim($sql," and "); $save_sql=$sql; $save_sql=$sql; } some one has already told me that the person who coded this is a bit mad. someone esle said try : $sql="select * from user_registration where user_name LIKE '%".$key_word."%' "; but that did not work. i have attached the other relevant files [attachment deleted by admin]

I bought this auction script and the search engine does not work properly. at the moment it is searching for exact phrases/words they continue on from each other so if you look on my website at http://www.bid4tackle.com/detail.php?item_id=752 it is called "Fox Evolution 3 Rod Holdall " at the moment you would have to search for the exact continuous words so "fox Evolution 3 Rod Holdall" or "fox evolution 3 rod" or "fox evolution" i.e. any keywords which follow each other e.g. "3 rod holdall". i want it to search for keywords so it would appear if you searched for "fox", "evolution" ... or key words which are not continuous so "fox" + "rod holdall" or "evolution" +"Holdall"etc. i am only 18 and know very little about php if you could help i would be much appreciative. if($mode=="keysearch") { if(!empty($key_word)) { $key_word=trim($key_word); $sql="select * from user_registration where user_name='$key_word' "; $table=mysql_query($sql); if($row=mysql_fetch_array($table)) { $user_id = $row['user_id']; } $sql="select * from placing_item_bid where status=\"Active\" and selling_method!=\"want_it_now\" and selling_method!=\"ads\" and (item_title like \"%$key_word%\" or detailed_descrip like \"%$key_word%\" or item_id=\"$key_word\" or user_id=\"$user_id\") and bid_starting_date <= now() and "; } else { $sql="select * from placing_item_bid where status=\"Active\" and selling_method!=\"want_it_now\" and selling_method!=\"ads\" and bid_starting_date <= now() and expire_date>=now()"; } if(!empty($show)) { if($show=="all") $sql.=" ( selling_method= \"auction\" or selling_method= \"dutch_auction\" or selling_method= \"fix\" ) "; else if($show=="bid") $sql.=" ( selling_method= \"auction\" or selling_method= \"dutch_auction\") "; else if($show=="buy") $sql.=" selling_method=\"fix\" "; } $sql=rtrim($sql," and "); $save_sql=$sql; $save_sql=$sql; } some one has already told me that the person who coded this is a bit mad. someone esle said try : $sql="select * from user_registration where user_name LIKE '%".$key_word."%' "; but that did not work. i have attached the [attachment deleted by admin]