Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/Code)
 Auction 2.0		  New Topic  Reply to Topic
 Printer Friendly
Next Page
Author Previous Topic Topic Next Topic
Page: of 11

superskytten1
New Member

Denmark
94 Posts
Posted - 11 June 2010 :  23:47:37  Show Profile  Reply with Quote
i have just install Auction 2.0, but i cannot see the Auction in the admin sektion. have i done something wrong

Classicmotorcycling
Development Team Leader

Australia
2084 Posts
Posted - 12 June 2010 :  01:36:36  Show Profile  Reply with Quote
No, there is no Admin functions for this yet....
Cheers,

David Greening
Go to Top of Page

superskytten1
New Member

Denmark
94 Posts
Posted - 12 June 2010 :  04:15:24  Show Profile  Reply with Quote
thank you for the information, have a nice day
Go to Top of Page

richfed
Average Member

United States
999 Posts
Posted - 18 June 2010 :  06:55:32  Show Profile  Visit richfed's Homepage  Reply with Quote
I have this installed on my forum, but it's not yet been used, so I am unfamiliar as to functions. I see, reading through another thread, that there has been a little spat over this MOD's development. Surely, I don't want to stir the pot AT ALL. Classicmotorcycling, I am using Version 2.0 as downloaded at SnitzBitz. I simply want to use your MOD as intended. I am a bit confused, though, as to whether or not this MOD has a PayPal function in it that works. Would appreciate feedback. Thanks ...

The MOD, by the way, installed flawlessly and easily!
Rich
[size=1]A Complete Idiot's Guide to MOD Implementation || On the Trail of the Last of the Mohicans[/size=1]
Go to Top of Page

Classicmotorcycling
Development Team Leader

Australia
2084 Posts
Posted - 18 June 2010 :  18:14:45  Show Profile  Reply with Quote
I have not added the PayPal and do not see a need to add the PayPay as the Auction is between the Seller and the Winner bidder (which most do not have PayPal) and they can work out their own payment system, be it PayPal or what ever else they deceide to use.

Before you know it if you put in a payment system and the winning bidder doesn't receive their item, the seller says they did not get payment, then you will start to get blamed for providing the payment option that doesn't work or even better that you are stealling payments, hench why I do not want anything to do with the payment interface.

It is just a service that you (all that decide to use any MODS) as a forum owner need to understand that it is just that, an extra service for your members and not a replacement for the professional stuff out there which makes money from those services.
Cheers,

David Greening
Go to Top of Page

Sean Sounds
Starting Member

20 Posts
Posted - 23 June 2010 :  16:44:30  Show Profile  Reply with Quote
I get an error when leaving feedback for the first time:

Microsoft VBScript runtime error '800a01a8'

Object required

auction_sendfeedback.asp, line 422

the error appears below the footer and refers to this line:

set rsNamegrab = my_Conn.Execute(strSql)


The same error is produced on line 196 which has the same line entry when trying to do other things like leaving feedback when feedback has been left or not being the winner or buyer, etc.

Can anyone help?

I have the latest forum with no modifications to the auction 2.0 auction_sendfeedback.asp file or the auction_feedback.asp file.

Thanks in advance.
Go to Top of Page

Sean Sounds
Starting Member

20 Posts
Posted - 25 June 2010 :  10:59:44  Show Profile  Reply with Quote
Issue resolved. Replaced all the WriteFooter() (except for the last one) after each response message with Response.end.
Go to Top of Page

Classicmotorcycling
Development Team Leader

Australia
2084 Posts
Posted - 26 June 2010 :  02:04:40  Show Profile  Reply with Quote
Auction Mod 2.0 (auction_sendfeedback.asp) updated after looking at the feedback system and response.end added after the WriteFooter() (except for the last one). Also added for the categories to be added to the forum default.asp with the count of the items in each categories.

Hopefully I will be updating over the week-end to have admin functions.
Cheers,

David Greening
Go to Top of Page

thermal_seeker
Junior Member

United Kingdom
430 Posts
Posted - 26 June 2010 :  04:43:15  Show Profile  Reply with Quote
should there be a notification for the winning bidder??
No good at coding, but I can plough a field !!
Go to Top of Page

Classicmotorcycling
Development Team Leader

Australia
2084 Posts
Posted - 27 June 2010 :  00:46:31  Show Profile  Reply with Quote
No, only when the user has been out bid.
quote:
Originally posted by thermal_seeker

should there be a notification for the winning bidder??


Also so others know, I have released Auction Mod 2.5 with Administration functions. I have tested on MS SQL and Access and works well.

Cheers,

David Greening
Go to Top of Page

richfed
Average Member

United States
999 Posts
Posted - 27 June 2010 :  07:00:27  Show Profile  Visit richfed's Homepage  Reply with Quote
Excellent ... thanks, David!
Rich
[size=1]A Complete Idiot's Guide to MOD Implementation || On the Trail of the Last of the Mohicans[/size=1]
Go to Top of Page

Classicmotorcycling
Development Team Leader

Australia
2084 Posts
Posted - 27 June 2010 :  07:08:13  Show Profile  Reply with Quote
Rich,

You just need to copy the new files over the ones that you have to get the new functions, and no need the upgreade the data if you where previously running version 2.0. There is a few more enhancments in it including counting the items in each category.
Cheers,

David Greening
Go to Top of Page

richfed
Average Member

United States
999 Posts
Posted - 27 June 2010 :  09:36:23  Show Profile  Visit richfed's Homepage  Reply with Quote
Thanks --- so I do not have to run the .dbs setup again? That would be good, as I had altered it [the version 2.0 one] to create my own custom categories. It looks like everything is OK, but I am not 100% sure as the auction is not being used yet.
Rich
[size=1]A Complete Idiot's Guide to MOD Implementation || On the Trail of the Last of the Mohicans[/size=1]
Go to Top of Page

Webbo
Average Member

United Kingdom
982 Posts
Posted - 03 July 2010 :  10:55:33  Show Profile  Visit Webbo's Homepage  Reply with Quote
Hi David,

I've tried implementing this using a MySql database and get the following errors when running the dbs set up file:

quote:
Dropping Table..
DROP TABLE FORUM_AUCTIONBIDS

Table dropped succesfully
--------------------------------------------------------------------------------

Dropping Table..
DROP TABLE FORUM_AUCTIONITEMS

Table does not exist
--------------------------------------------------------------------------------

Dropping Table..
DROP TABLE FORUM_AUCTIONFEEDBACK

Table does not exist
--------------------------------------------------------------------------------

Dropping Table..
DROP TABLE FORUM_AUCTIONCATEGORIES

Table does not exist
--------------------------------------------------------------------------------

Creating table(s)...
CREATE TABLE FORUM_AUCTIONBIDS( AUCTIONID int NOT NULL , BUYER int NULL , MAXPRICE varchar(10) NULL , BIDTIME varchar(20) NULL )
Table created succesfully

--------------------------------------------------------------------------------

Creating table(s)...
CREATE TABLE FORUM_AUCTIONITEMS( AUCTIONID INT (11) DEFAULT '' NOT NULL auto_increment , AUCTIONCATID int NULL , SELLER int NOT NULL , ITEMNAME varchar(150) NOT NULL , ITEMDESC text NOT NULL , IMGURL varchar(150) NULL , OPENINGBID varchar(10) NULL , CURRENTBID varchar(10) NULL , STARTDATE varchar(20) NOT NULL , ENDDATE varchar(20) NOT NULL ,KEY FORUM_AUCTIONITEMS_AUCTIONID(AUCTIONID))
CREATE TABLE FORUM_AUCTIONITEMS( AUCTIONID INT (11) DEFAULT '' NOT NULL auto_increment , AUCTIONCATID int NULL , SELLER int NOT NULL , ITEMNAME varchar(150) NOT NULL , ITEMDESC text NOT NULL , IMGURL varchar(150) NULL , OPENINGBID varchar(10) NULL , CURRENTBID varchar(10) NULL , STARTDATE varchar(20) NOT NULL , ENDDATE varchar(20) NOT NULL ,KEY FORUM_AUCTIONITEMS_AUCTIONID(AUCTIONID))
-2147467259 | [MySQL][ODBC 5.1 Driver][mysqld-5.1.44-community-log]Invalid default value for 'AUCTIONID'

--------------------------------------------------------------------------------

Creating table(s)...
CREATE TABLE FORUM_AUCTIONFEEDBACK( AUCTIONID int NOT NULL , BUYERID int NULL , SELLERID int NULL , BUYERSCORE int NULL , SELLERSCORE int NULL , BUYERCOMMENT varchar(50) NULL , SELLERCOMMENT varchar(50) NULL , DATEBUYER varchar(20) NULL , DATESELLER varchar(20) NULL )
Table created succesfully

--------------------------------------------------------------------------------

Creating table(s)...
CREATE TABLE FORUM_AUCTIONCATEGORIES( AUCTIONCATID INT (11) DEFAULT '' NOT NULL auto_increment , CATEGORYNAME varchar(50) NULL , CATEGORYDESCRIPTION text NULL ,KEY FORUM_AUCTIONCATEGORIES_AUCTIONCATID(AUCTIONCATID))
CREATE TABLE FORUM_AUCTIONCATEGORIES( AUCTIONCATID INT (11) DEFAULT '' NOT NULL auto_increment , CATEGORYNAME varchar(50) NULL , CATEGORYDESCRIPTION text NULL ,KEY FORUM_AUCTIONCATEGORIES_AUCTIONCATID(AUCTIONCATID))
-2147467259 | [MySQL][ODBC 5.1 Driver][mysqld-5.1.44-community-log]Invalid default value for 'AUCTIONCATID'

--------------------------------------------------------------------------------

Adding new records..
INSERT INTO FORUM_AUCTIONCATEGORIES (CATEGORYNAME,CATEGORYDESCRIPTION) VALUES ('Motor','All types of Motor vehicles')
INSERT INTO FORUM_AUCTIONCATEGORIES (CATEGORYNAME,CATEGORYDESCRIPTION) VALUES ('Motor','All types of Motor vehicles')
-2147217865 | [MySQL][ODBC 5.1 Driver][mysqld-5.1.44-community-log]Table 'dbs_name.forum_auctioncategories' doesn't exist

--------------------------------------------------------------------------------

Adding new records..
INSERT INTO FORUM_AUCTIONCATEGORIES (CATEGORYNAME,CATEGORYDESCRIPTION) VALUES ('Homewares','All types of Homewares')
INSERT INTO FORUM_AUCTIONCATEGORIES (CATEGORYNAME,CATEGORYDESCRIPTION) VALUES ('Homewares','All types of Homewares')
-2147217865 | [MySQL][ODBC 5.1 Driver][mysqld-5.1.44-community-log]Table 'dbs_name.forum_auctioncategories' doesn't exist

--------------------------------------------------------------------------------

Adding new records..
INSERT INTO FORUM_AUCTIONCATEGORIES (CATEGORYNAME,CATEGORYDESCRIPTION) VALUES ('Computers and Internet','All Computers and Internet related items including software and domain names')
INSERT INTO FORUM_AUCTIONCATEGORIES (CATEGORYNAME,CATEGORYDESCRIPTION) VALUES ('Computers and Internet','All Computers and Internet related items including software and domain names')
-2147217865 | [MySQL][ODBC 5.1 Driver][mysqld-5.1.44-community-log]Table 'dbs_name.forum_auctioncategories' doesn't exist

--------------------------------------------------------------------------------

Adding new records..
INSERT INTO FORUM_AUCTIONCATEGORIES (CATEGORYNAME,CATEGORYDESCRIPTION) VALUES ('Entertainment','All types of Entertainment including hardware and including concert tickets')
INSERT INTO FORUM_AUCTIONCATEGORIES (CATEGORYNAME,CATEGORYDESCRIPTION) VALUES ('Entertainment','All types of Entertainment including hardware and including concert tickets')
-2147217865 | [MySQL][ODBC 5.1 Driver][mysqld-5.1.44-community-log]Table 'dbs_name.forum_auctioncategories' doesn't exist

--------------------------------------------------------------------------------

Adding new records..
INSERT INTO FORUM_AUCTIONCATEGORIES (CATEGORYNAME,CATEGORYDESCRIPTION) VALUES ('Collectables','All types of Collectable Items including Antiques')
INSERT INTO FORUM_AUCTIONCATEGORIES (CATEGORYNAME,CATEGORYDESCRIPTION) VALUES ('Collectables','All types of Collectable Items including Antiques')
-2147217865 | [MySQL][ODBC 5.1 Driver][mysqld-5.1.44-community-log]Table 'dbs_name.forum_auctioncategories' doesn't exist

--------------------------------------------------------------------------------

Adding new records..
INSERT INTO FORUM_AUCTIONCATEGORIES (CATEGORYNAME,CATEGORYDESCRIPTION) VALUES ('All Other','All Other types of Items not listed')
INSERT INTO FORUM_AUCTIONCATEGORIES (CATEGORYNAME,CATEGORYDESCRIPTION) VALUES ('All Other','All Other types of Items not listed')
-2147217865 | [MySQL][ODBC 5.1 Driver][mysqld-5.1.44-community-log]Table 'dbs_name.forum_auctioncategories' doesn't exist

--------------------------------------------------------------------------------



I'm not sure if you have tested it on MySql and could sure do with some help as the Auction mod looks like something we could make use of

Regards,

Dave
Edited by - Webbo on 03 July 2010 10:57:07
Go to Top of Page

Classicmotorcycling
Development Team Leader

Australia
2084 Posts
Posted - 03 July 2010 :  17:56:26  Show Profile  Reply with Quote
I have just done a basic test on MySQL (at my Test Site) and I get the following when running the dbs file:


Auction Mod Version 2.5

Dropping Table..

Table dropped successfully 
--------------------------------------------------------------------------------

Dropping Table..

Table dropped successfully 
--------------------------------------------------------------------------------

Dropping Table..

Table dropped successfully 
--------------------------------------------------------------------------------

Dropping Table..

Table dropped successfully 
--------------------------------------------------------------------------------

Creating table(s)...
CREATE TABLE FORUM_AUCTIONBIDS( AUCTIONID int NOT NULL , BUYER int NULL , MAXPRICE varchar(10) NULL , BIDTIME varchar(20) NULL )
Table created successfully

--------------------------------------------------------------------------------

Creating table(s)...
CREATE TABLE FORUM_AUCTIONITEMS( AUCTIONID INT (11) NOT NULL auto_increment , AUCTIONCATID int NULL , SELLER int NOT NULL , ITEMNAME varchar(150) NOT NULL , ITEMDESC text NOT NULL , IMGURL varchar(150) NULL , OPENINGBID varchar(10) NULL , CURRENTBID varchar(10) NULL , STARTDATE varchar(20) NOT NULL , ENDDATE varchar(20) NOT NULL ,KEY FORUM_AUCTIONITEMS_AUCTIONID(AUCTIONID))
Table created successfully

--------------------------------------------------------------------------------

Creating table(s)...
CREATE TABLE FORUM_AUCTIONFEEDBACK( AUCTIONID int NOT NULL , BUYERID int NULL , SELLERID int NULL , BUYERSCORE int NULL , SELLERSCORE int NULL , BUYERCOMMENT varchar(50) NULL , SELLERCOMMENT varchar(50) NULL , DATEBUYER varchar(20) NULL , DATESELLER varchar(20) NULL )
Table created successfully

--------------------------------------------------------------------------------

Creating table(s)...
CREATE TABLE FORUM_AUCTIONCATEGORIES( AUCTIONCATID INT (11) NOT NULL auto_increment , CATEGORYNAME varchar(50) NULL , CATEGORYDESCRIPTION text NULL ,KEY FORUM_AUCTIONCATEGORIES_AUCTIONCATID(AUCTIONCATID))
Table created successfully

--------------------------------------------------------------------------------

Adding new records..
INSERT INTO FORUM_AUCTIONCATEGORIES (CATEGORYNAME,CATEGORYDESCRIPTION) VALUES ('Motor','All types of Motor vehicles')

Value(s) updated successfully 
--------------------------------------------------------------------------------

Adding new records..
INSERT INTO FORUM_AUCTIONCATEGORIES (CATEGORYNAME,CATEGORYDESCRIPTION) VALUES ('Homewares','All types of Homewares')

Value(s) updated successfully 
--------------------------------------------------------------------------------

Adding new records..
INSERT INTO FORUM_AUCTIONCATEGORIES (CATEGORYNAME,CATEGORYDESCRIPTION) VALUES ('Computers and Internet','All Computers and Internet related items including software and domain names')

Value(s) updated successfully 
--------------------------------------------------------------------------------

Adding new records..
INSERT INTO FORUM_AUCTIONCATEGORIES (CATEGORYNAME,CATEGORYDESCRIPTION) VALUES ('Entertainment','All types of Entertainment including hardware and including concert tickets')

Value(s) updated successfully 
--------------------------------------------------------------------------------

Adding new records..
INSERT INTO FORUM_AUCTIONCATEGORIES (CATEGORYNAME,CATEGORYDESCRIPTION) VALUES ('Collectables','All types of Collectable Items including Antiques')

Value(s) updated successfully 
--------------------------------------------------------------------------------

Adding new records..
INSERT INTO FORUM_AUCTIONCATEGORIES (CATEGORYNAME,CATEGORYDESCRIPTION) VALUES ('All Other','All Other types of Items not listed')

Value(s) updated successfully 
--------------------------------------------------------------------------------


Database setup finished


I did have to make a small change in auction.asp (at line 196) as I had the sorting wrong for MySQL, but now working (Auction MOD 2.5 updated)
Cheers,

David Greening
Go to Top of Page

Webbo
Average Member

United Kingdom
982 Posts
Posted - 05 July 2010 :  02:17:11  Show Profile  Visit Webbo's Homepage  Reply with Quote
Nope, still can't get the dbs file to work for some strange reason, unless it's my version of MySql

I'll try creating the tables manually later

Go to Top of Page
Page: of 11 Previous Topic Topic Next Topic  
Next Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.17 seconds. Powered By: Snitz Forums 2000 Version 3.4.07