hello everybody,

i'm looking for an small auction script plugin for links_sql 2.1.1.

the script should use the links_sql-user-table and users for login-information. that means if someone is logged in in links_sql as a user, he should be able to use immediately the auction.

the best thing for my uses (maybe not for others) would be, if all registered users (in the links_sql) are allowed to make a bid, but only the admin is allowed to start new auctions (or some kind of auction validation, so that i am able to delete all auctions that are not mine).

my idea is to have an auction area for link-owners where they can make bids on my advertising areas. so the price for an e.g. monthly banner in one of my directories categories is made my an user-exclusive auction.

if anyone has some kind of auction-script-plugin for links_sql 2.1.1 please respond, send me a message or a mail.

Regards,
Manu

Shopping Portal Shop-Netz.de® | Partnerprogramme | Flugreisen & Billigflüge | KESTERMEDIA e.K. | European Affiliate Marketing Forum.

I had been working on something, a basic auction, that had the look of ebay, but did not end at a specific time. The problem was timing on the database, so what I had built in was adding an x-factor to the closing time. Any bid that was placed in the last n-minutes added x-minutes to the closing time. Again, the problem I had was queuing, and to do it right there would have to be a transaction queue, something mysql doesn't support. The "time" of the bid is the time entered into the transaction queue, not the time the action was posted to the mysql database, so that if there was a delayed posting, it still would handle each transaction in turn, and apply the bid/extend process to each transaction as taken from the queue.

It was actually fairly simple. I might be able to dig up the code. It was for 1.13, but if I remember, it didn't do anything "funny". It might only need header information.

1) used the links user table /login information to decide if a user was allowed to bid/post (no other checking)

2) used a links category as "auction" and if category name was "Auction" it took actions based on that. In a way it was a predecessor to the arbitrary tables system, but it was flat out stupid <G>.

3) It kept a log of bids/proxy/etc

4) did not handle dutch auctions yet

5) ... more, but that is all I can remember.

I post this, because I'm not sure that it will do what you want, as you listed it. I'd have to fix it up a bit, as well, and it was *not* a plug in. Meaning, the table had to be created manually, and the script/templates copied over manually, but like all my programs at that time, it was in one script that "added on" to Links, without changing anything in links.


PUGDOG� Enterprises, Inc.

The best way to contact me is to NOT use Email.
Please leave a PM here.

hi pugdog,

ok. that's not exactly what i want, but sounds good so far.

the only thing that is not very practical i think (for me and also for other users) is that your code uses a category of the directory.

as far as i know there is no chance to hide the category for common users, so that only logged in users or link-owners are able to see the "auction category".

but by the way, an auction script would be a very good one for the portfolio of GT. they have Mail, Forum, Autorespond etc. an auction would be a very good idea... but i don't want to bring this on their minds yet, not as long as i am still waiting for the community plugin ;-)

Regards,
Manu

Shopping Portal Shop-Netz.de® | Partnerprogramme | Flugreisen & Billigflüge | KESTERMEDIA e.K. | European Affiliate Marketing Forum.