Publish quotes by your customers

[Al Brookbanks]

Name: extended_customers_quotes.zip

Version: 1.0

Author: Stijn Jammaers

Short Description: Publish quotes by your customers

Long Description:

This is a mod that comes with 8 php files but is easy to setup. You publish 1 or more quotes in a new table, every quote has a link to a page that shows the complete list of quotes.Your customers can add quotes and these will be sent to your adminsection ! ( so no emailstuff) In your admin you can review these quotes and deside to publish / edit or delete these quotes. There is also an option to add quotes or news yourself (including images etc)

[Download File]

[Guest]

There seems to be a problem with this mod...

When trying to add a quote from admin panel, it gives:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /www/shop/admin/add_quotes.php on line 28



Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /www/shop/admin/add_quotes.php on line 38

When i insert a column from phpadmin it shows perfectly, and when i try to give feedback as a customer it looks like it is working, but nothing gets added to the DB.

[Guest notset4life]

I installed this mod, but....

Where exactly does a customer ADD A QUOTE?

[Guest stijnj]

hi notset4life

Where exactly does a customer ADD A QUOTE?

well, the customer needs to visit the show_quotes page by clicking on the allready published quotes, then on the bottom of that page there's a link 'click here to submit your quote'

now i now thats two links before you can exually leave your quote as a customer

wich is pretty much but at the time when i was writting this mod i thought i need some quotes from customers who are interessted in my site and they will find the links.

Now , if you like you can make a direct link to 'add a quote''

e.g. in the ' information' table (where 's contact us , privacy policy etc..)

to do this :

open information.php

find about line 45

echo"<b>$la_stats_prods</b> $total_prod<br>

                <b>$la_stats_cats</b> $total_cat<br>

                <b>$la_stats_hits</b> $quan_hits<br>

                <b>$la_stats_prices</b> $currency_desc<br> ;}

and replace that with

echo"<b>$la_stats_prods</b> $total_prod<br>

                <b>$la_stats_cats</b> $total_cat<br>

                <b>$la_stats_hits</b> $quan_hits<br>

                <b>$la_stats_prices</b> $currency_desc<br>

                <img src='images/bullet.gif' border='0'><a href='feedback.php'> $la_mod_quote_add</a>"

                ;}

i hope this helps

Stijn

[Guest Magic-Touch]

There seems to be a problem with this mod...

When trying to add a quote from admin panel, it gives:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /www/shop/admin/add_quotes.php on line 28



Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /www/shop/admin/add_quotes.php on line 38

When i insert a column from phpadmin it shows perfectly, and when i try to give feedback as a customer it looks like it is working, but nothing gets added to the DB.

I have the same problem & errors messages... Still trying to figure out a fix for that problem, but it's difficult for me since I'm begining with PHP & SQL...

Anyone have any idea how to solve that problem ???

Thanks in advance

Stephane

PS.: Great script, and great MODs everyone !!! :lol:

[Guest Smokey]

The install file lets you make 2 tables in your database.

store_quotes and store_custquotes

In the add_quotes.php its looking twice for store__cust_quotes

Change this to the real name off the table. Probably store_quotes

Cheers Smokey

[Guest]

hello !

The install file lets you make 2 tables in your database.

store_quotes and store_custquotes

In the add_quotes.php its looking twice for store__cust_quotes

Change this to the real name off the table. Probably store_quotes

i have already do that, but still got errors

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in c:\apache\htdocs\cube\admin\add_quotes.php on line 20

Document added successfully!

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in c:\apache\htdocs\cube\admin\add_quotes.php on line 30

LIne 20 $row_max = mysql_fetch_array($max_query);

Line 30 while($row = mysql_fetch_array($result))

btw, nice hack! i love it, thx for the help b4

[Guest]

Look at a previous post I have made about this MOD.

Simon and myself have written a TUT on how to fix all these problems.

Chris

[Guest]

the correct expression is (line 27 /admin/add_quotes.php):

$max_query = mysql_query("SELECT max(custdoc_id) as max_id FROM ".$prefix."store_custquotes");

notice doc_id changes to custdoc_id

and store_cust_quotes changes to store_cust_quotes

Regs, Mikkatec

[Guest]

here is the whole lot, i realised there are a few changes..(lines 27-43 in /admin/add_quotes.php)

$max_query = mysql_query("SELECT max(custdoc_id) as max_id FROM ".$prefix."store_custquotes");

$row_max = mysql_fetch_array($max_query);

$value = $row_max['max_id'];

$doc_id_val = $value+1;

$sql_insert = mysql_query("insert into ".$prefix."store_quotes set doc_name='$doc_name', doc_content='$doc_content', doc_id=

echo"<p align=\"center\">$la_add_doc_success</p>";

$sql = "select * from ".$prefix."store_quotes where doc_id='$doc_id_val'";

$result = mysql_query ($sql);

while($row = mysql_fetch_array($result)){

$doc_name=$row["doc_name"];

$doc_id=$row["doc_id"];

$doc_content=$row["doc_content"];}

Regs, Davor

[Guest]

http://www.cubecart.com/site/forums/index.php?showtopic=3332 - just for future reference to all the people that want this MOD.

[Guest twisted]

So is this all fixed in the currently available download package? Or do the changes still need to be made?

[Guest twisted]

What happened to stijnj's testimonials mod? I can't seem to find it anywhere [yeah...again, I know. I'm trusting y'all will find this one for me too]

:)