View Full Version : Major Additions - microAUCTIONS (Auction Classifieds)
MaryTheG(r)eek
12-28-2009, 10:00 PM
*** Link Removed ***
MaryTheG(r)eek
12-29-2009, 04:56 PM
You can find a demo at:
http://www.microhellas.com/dev4/auctions.php
Login:
Username: demouser
Password: demopass
Maria
Kolbi
12-29-2009, 05:14 PM
Thank you!
Big-Pete
12-29-2009, 05:23 PM
Thanks Maria :)
ragtek
12-29-2009, 05:34 PM
WOW, very nice, but is it sooo hard to use the actiontemplates?
Also you could just use the pm datamanager instead of // Get visitor's data for message to Seller
$visitor_get = getRecordById("user",$visitorid,"userid");
$visitor_username = $visitor_get["username"];
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "pmtext
SET fromuserid = '$visitorid',
fromusername = '$visitor_username',
title = '$title',
message = '$bodytext',
touserarray = '',
iconid = '0',
dateline = '$timenow',
showsignature = '0',
allowsmilie = '1',
reportthreadid = '0'");
$messageid=$vbulletin->GPC['pmtextid'] = $db->insert_id();
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "pm
SET pmtextid = '$messageid',
userid = '$sellerid',
folderid = '0',
messageread = '0',
parentpmid = '0'");
$msguserid=$vbulletin->GPC['pmid'] = $db->insert_id();
$vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET pmunread=pmunread+1 WHERE userid=$sellerid");
I can only write every time: I really like your add-ons(the ideas), but the code is often very horrible
goblues
12-29-2009, 05:48 PM
You can modify the code to meet your needs, but you can't share this modification.
Maria
Does mean What I think it means? We can't share any addons for this mod?
Tagged for future use :up:
MaryTheG(r)eek
12-29-2009, 06:01 PM
Does mean What I think it means? We can't share any addons for this mod?
You understood perfectly. You can do anything you like for your own use, but that all. Your modifications should be used for your site(s) and just for it.
Maria
MaryTheG(r)eek
12-29-2009, 06:14 PM
WOW, very nice, but is it sooo hard to use the actiontemplates?I can only write every time: I really like your add-ons(the ideas), but the code is often very horrible
Actually I do believe that my code is very smart. That's why my mods are so easy upgradable to all versions.
By the way, a question. By using the datamanager I've to follow permissions rules for messages (eg Receive PMs or not, Ignore lists etc)? I think yes. But this is what I want to avoid. I want to give to those who have turn off PMs to avoid messages from forums, to be able to receive message for their auctions.
In my early days here some users were reporting me because my code was "unsecure". Now you're coming by saying that my code is horrible. My questions are:
Is it secure?
Does it works as it must work?
Is it fast?I do believe that all answers are YES!!. So, feel free to get my ideas (really I've so many), and let my code out. Finally not all vB users are users with the top websites or with the thousands members. I'm hobbist coder, and I'm posting my mods targeting to hobbists webmasters.
Maria
BlackJacket
12-29-2009, 06:22 PM
Definitely something i could use.
Thanks!
Vaupell
12-29-2009, 06:25 PM
Great work, i am impressed.
Thumbs up, rated 5 stars and motm.
unfortunally i have no use for it,
but this is just great seing people actually doing the hard work :D
BBR-APBT
12-29-2009, 06:29 PM
Very Nice I would rather have the Classifieds with out the auctions. Still very nice.
Rated and nominated even though I have no use for it.
ragtek
12-29-2009, 06:43 PM
By the way, a question. By using the datamanager I've to follow permissions rules for messages (eg Receive PMs or not, Ignore lists etc)? I think yes. But this is what I want to avoid. I want to give to those who have turn off PMs to avoid messages from forums, to be able to receive message for their auctions.
If you set the overridequota, it will work;)
$botpermissions = 2;
$pmdm =& datamanager_init('PM', $vbulletin, ERRTYPE_ARRAY);
$pmdm->set('fromuserid', 1);
$pmdm->set('fromusername', 'username');
$pmdm->set('title', 'title of message');
$pmdm->set('message', "youre message");
$pmdm->set_recipients('newuser', $botpermissions);
$pmdm->set('dateline', TIMENOW);
$pmdm->overridequota = true;
$pmdm->save();
Very Nice I would rather have the Classifieds with out the auctions. Still very nice.
Rated and nominated even though I have no use for it.
What he said. =) It looks really nice, I don't have much use for the auctions right now. But the classifieds I could use. I might be able to work with this though, we'll see.
Tagged for now!
You understood perfectly. You can do anything you like for your own use, but that all. Your modifications should be used for your site(s) and just for it.
Maria
Actually, there's two different things here.
Someone per your usage rules cannot modify YOUR code and give it to someone else. Fair enough.
But what they CAN do is write an add-on that plugs into your code or otherwise uses your database, etc. That is all their own code. So his question about add-ons, yes you can write your own add-ons and give them out to anyone you want. It's your code. You just can't modify the code posted here.
Gnoll
12-29-2009, 07:05 PM
i'm runnig a mmorpg discuss site , and i want to make a info part about prepaid cards , premiums etc ...
--------------------------------------------------------
can we edit this part
Buy it for x | Bid at least x | Contact Seller
to
Buy It* | Find Similar** | Contact Seller ( via PM - i think its core )
* > redirect to company site or product link
** > based on keywords or first keyword
VonDoom
12-29-2009, 08:14 PM
Can this be used as a simple classifieds script without the auctions? Either way great work tagged for future use
Verionia
12-30-2009, 03:55 AM
Hi I would like to know if I can use images for the products and if fees are deducted/given to owner of site from users who auction like ebay.com?
Can the auction part be disabled for a classified section? I would like both an auction and classified mod for my site. Thanks
MaryTheG(r)eek
12-30-2009, 05:16 AM
Very Nice I would rather have the Classifieds with out the auctions. Still very nice.
Rated and nominated even though I have no use for it.
Should be a Pro version with many advanced features. One of them should give to users the ability to choose between Classified Ad or Auction when post it.
Maria
MaryTheG(r)eek
12-30-2009, 05:17 AM
Hi I would like to know if I can use images for the products and if fees are deducted/given to owner of site from users who auction like ebay.com?
Can the auction part be disabled for a classified section? I would like both an auction and classified mod for my site. Thanks
Read my post #19
Maria
MaryTheG(r)eek
12-30-2009, 05:19 AM
What he said. =) It looks really nice, I don't have much use for the auctions right now. But the classifieds I could use. I might be able to work with this though, we'll see.
Tagged for now!
Read my post #19
Maria
BBR-APBT
12-30-2009, 05:36 AM
Should be a Pro version with many advanced features. One of them should give to users the ability to choose between Classified Ad or Auction when post it.
Maria
Suggestion before you do that part.
Can the admin have the option to turn on and off the auction side. If the admin turned it on then users get the option to choose. This way the admin can turn off the auctions all together.
MaryTheG(r)eek
12-30-2009, 05:51 AM
Suggestion before you do that part.
Can the admin have the option to turn on and off the auction side. If the admin turned it on then users get the option to choose. This way the admin can turn off the auctions all together.
It's already done:D Available options for Admin: Classifieds or Auctions or Both, but thank you for your suggestion.
Maria
blake247
12-30-2009, 06:00 AM
Tagged. Thanks for the great work Maria!
argothiusz
12-30-2009, 07:36 AM
Tagged. Very well done :)
zelnik
12-30-2009, 08:05 AM
It's already done:D Available options for Admin: Classifieds or Auctions or Both, but thank you for your suggestion.
Maria
Hi Maria,
Great mod and any idea when the Pro version will be available?
Since vbclassifieds looks like it will not be updated for vb4 I believe there is a big market place for a classifieds that isn't expensive like photopost classifieds
MaryTheG(r)eek
12-30-2009, 08:23 AM
Hi Maria,
Great mod and any idea when the Pro version will be available?
Since vbclassifieds looks like it will not be updated for vb4 I believe there is a big market place for a classifieds that isn't expensive like photopost classifieds
I don't like to broke the rules of this site which dosen't allows post related to anything commercial, you must go to:
http://www.microhellas.com/main/showthread.php?1-About-the-PRO-version
Thank you
Maria
dede1
12-30-2009, 09:51 AM
Dankt fine werk
masons
12-30-2009, 01:09 PM
I love it! http://www.otakuniverse.net/auctions.php
messengermatt
12-30-2009, 02:46 PM
Hi loving this mod although i would like some help on how to customise it to meet my needs - i am looking to remove some of the bid fields where people make new listings as i want it to be more classified targetted
messengermatt
12-30-2009, 02:55 PM
also i have just done a test uninstall and got the following error:
Database error in vBulletin 4.0.0:
Invalid SQL:
DROP TABLE
`microauctions_categories`, `microauctions_items`,
`microauctions_item_photos`, `microauctions_item_bids`,
`microauctions_bookmarks`, `microauctions_hits`,
`microauctions_reports`, `microauctions_item_files`,
`microauctions_item_shipping`, `microauctions_item_payments`;
MySQL Error : Unknown table 'microauctions_categories,microauctions_items,micr oauctions_item_photos,microauctions_item_bids,micr o'
Error Number : 1051
Request Date : Wednesday, December 30th 2009 @ 04:54:35 PM
Error Date : Wednesday, December 30th 2009 @ 04:54:35 PM
Script : http://acereptiles.co.uk/forums/admincp/plugin.php?do=productkill
Referrer : http://acereptiles.co.uk/forums/admincp/plugin.php?do=productdelete&productid=microauctions&s=
IP Address : 91.108.95.144
Username : ****
Classname : vB_Database
MySQL Version : 5.0.87-community
MaryTheG(r)eek
12-30-2009, 04:17 PM
also i have just done a test uninstall and got the following error:
Database error in vBulletin 4.0.0:
Invalid SQL:
DROP TABLE
`microauctions_categories`, `microauctions_items`,
`microauctions_item_photos`, `microauctions_item_bids`,
`microauctions_bookmarks`, `microauctions_hits`,
`microauctions_reports`, `microauctions_item_files`,
`microauctions_item_shipping`, `microauctions_item_payments`;
MySQL Error : Unknown table 'microauctions_categories,microauctions_items,micr oauctions_item_photos,microauctions_item_bids,micr o'
Error Number : 1051
Request Date : Wednesday, December 30th 2009 @ 04:54:35 PM
Error Date : Wednesday, December 30th 2009 @ 04:54:35 PM
Script : http://acereptiles.co.uk/forums/admincp/plugin.php?do=productkill
Referrer : http://acereptiles.co.uk/forums/admincp/plugin.php?do=productdelete&productid=microauctions&s=
IP Address : 91.108.95.144
Username : ****
Classname : vB_Database
MySQL Version : 5.0.87-community
The first thing that I'm testing in my mods, is installing and unistalling them, as I know how terrible is to get errors there or worst leaving rubishes behind.
I rechecked my code right now, and it works fine. But, by seeing that you're not using table prefix, came in my mind something that I read at vbulletin.com -> Projects -> Bugs, for some errors that users found when they don't use table prefixes. I didn't read the post, so I'm not sure what's the problem.
In any case, you can click Edit on the right of microAUCTIONS, remove the uninstall code (right block), and then remove the table with phpMyAdmin.
Maria
Burnt
12-30-2009, 08:29 PM
When I post an auction it says posting the auction then goes to a white blank screen.. It shows up but have to load the site back up.. Also hitting My Auctions also takes you to a white screen. as does Bid History...
Another edit when you try to delete the item takes you to another white screen..
.........../auctions.php?do=deleteitem&itemid=1
........../auctions.php?do=myitems
........../auctions.php?do=mybids
And then when trying to uninstall the mess.. got the same error that was posted up above..
ndahiya
12-30-2009, 09:39 PM
Microhellas, great mod, but again, too heavy for my intended use. i am looking for a basic classifieds addon (no need for auctions, payments etc). the pro version is a good idea, but it would be a bit like using a hammer to kill a fly. wonder if you plan to release a classifieds only lite version. i do not mind making a (financial) contribution if that is the bottleneck...
ndahiya
Dr.osamA
12-31-2009, 12:55 AM
Waiting for gold
reserved
thanx maria
MaryTheG(r)eek
12-31-2009, 05:34 AM
When I post an auction it says posting the auction then goes to a white blank screen.. It shows up but have to load the site back up.. Also hitting My Auctions also takes you to a white screen. as does Bid History...
Another edit when you try to delete the item takes you to another white screen..
.........../auctions.php?do=deleteitem&itemid=1
........../auctions.php?do=myitems
........../auctions.php?do=mybids
And then when trying to uninstall the mess.. got the same error that was posted up above..
3 missing procedures... I know it and I've wrote that they're missing 3 parts now. I'll post the Beta version today. As for uninstallation, works fine for me. The first point that I'm testing in my mods, is installing and uninstalling them.
Maria
WEBDosser
12-31-2009, 05:53 AM
Waiting for gold too
reserved
thanx maria
dale09
12-31-2009, 05:58 AM
Tagged...
i was playing around on the demo, and noticed a few links that are not correct. when your viewing an auction the following links on the bottom "Buy it for 400.00 $ | Bid at least 0.00 $ | Contact Seller" all link to http://www.microhellas.com/dev4/
MaryTheG(r)eek
12-31-2009, 06:13 AM
Tagged...
i was playing around on the demo, and noticed a few links that are not correct. when your viewing an auction the following links on the bottom "Buy it for 400.00 $ | Bid at least 0.00 $ | Contact Seller" all link to http://www.microhellas.com/dev4/
I've removed it from the version that I've released here;) As these links work with javascript I had to duplicate them, something not so good for the resources.
Maria
MaryTheG(r)eek
12-31-2009, 07:41 AM
If you don't mind to spend some of your valuable time registering to my site, I'll really appreciate to vote in my poll:
http://www.microhellas.com/main/showthread.php?3-What-best-fits-your-needs
something that will helps me a lot to understand what is most need in the trading market.
Thank you
Maria
MaryTheG(r)eek
12-31-2009, 04:34 PM
For those who're interesting for Classifieds rather than Auctions, I'll release microCLASSIFIEDS on Sunday or max on Monday as I need a day to finish microAUCTIONS first of all.
Maria
bigtime
12-31-2009, 05:21 PM
Excellent! Thanks.
Crazyfruitbat
01-01-2010, 01:13 AM
I'm afraid I had the same uninstall issues too
MaryTheG(r)eek
01-01-2010, 05:00 PM
*** ATTENTION ***
All prior posts are reffering to Alpha version.
From here and then are for the stable Beta 4.1.0
Maria
micheal332001
01-01-2010, 05:45 PM
Very Nice I would rather have the Classifieds with out the auctions. Still very nice.
Rated and nominated even though I have no use for it.
Hi Maria,
Great mod and any idea when the Pro version will be available?
Since vbclassifieds looks like it will not be updated for vb4 I believe there is a big market place for a classifieds that isn't expensive like photopost classifieds
Microhellas, great mod, but again, too heavy for my intended use. i am looking for a basic classifieds addon (no need for auctions, payments etc). the pro version is a good idea, but it would be a bit like using a hammer to kill a fly. wonder if you plan to release a classifieds only lite version. i do not mind making a (financial) contribution if that is the bottleneck...
ndahiya
Maria's old classifieds script will be updated to vb4.0 soon as this is being done now.
As for the members that have said that maria's code is heavy and horrable is out of line as she works hard to give everyone some great add-ons to there sites.
When a coder heres things like this for there hard work puts them down and makes them think twice about making mods for release here.
People here or on any other site should be thinking how much work goes into making these scripts and thanking the coders that make these for you.
Most of the members that put add-ons down dont even know how to code,
they cannot code even in html not alone php or java.
So say thankyou to members that make these scripts for your use as they have put in alot of time to make these for you.
micheal332001
01-01-2010, 05:46 PM
By the way Maria great script i will be using this for my site.
kf4eok
01-02-2010, 03:02 AM
Just what I have been looking for, I just wish the Pro verson was out.
Thanks
kf4eok
01-02-2010, 03:04 AM
I have a question. When I go to post a auction, then chose a category there is nothing there. How do I make the category list?
MaryTheG(r)eek
01-02-2010, 06:54 AM
I have a question. When I go to post a auction, then chose a category there is nothing there. How do I make the category list?
From your admincp:D You can add unlimited level categories.
Maria
MaryTheG(r)eek
01-02-2010, 08:14 AM
I'm so happy to say, that someone from IP: 77.54.237.148 is wasting his time to crash my microAUCTIONS in my demo installatin. Below you'll find some of his attempts:
SELECT * FROM vb4_microauctions_items WHERE active=1 AND sold=0 AND categoryid IN (5, 6, 7, 8, 9, 10, 11, 12, 13) AND (keywords LIKE '';$r = select * from vb4_user;$rr=mysql_fetch_array($r);print_r($rr);%' OR keywords LIKE '%';$r = select * from vb4_user;$rr=mysql_fetch_array($r);print_r($rr);%' OR keywords LIKE '%';$r = select * from vb4_user;$rr=mysql_fetch_array($r);print_r($rr);') ORDER BY ends ASC;
SELECT * FROM vb4_microauctions_items WHERE active=1 AND sold=0 AND categoryid IN (5, 6, 7, 8, 9, 10, 11, 12, 13) AND (keywords LIKE '';select * from vb4_user;mysql_fetch_array%' OR keywords LIKE '%';select * from vb4_user;mysql_fetch_array%' OR keywords LIKE '%';select * from vb4_user;mysql_fetch_array') ORDER BY ends ASC;
SELECT * FROM vb4_microauctions_items WHERE active=1 AND sold=0 AND categoryid IN (5, 6, 7, 8, 9, 10, 11, 12, 13) AND (keywords LIKE ';';select * from vb4_user;%' OR keywords LIKE '%;';select * from vb4_user;%' OR keywords LIKE '%;';select * from vb4_user;') ORDER BY ends ASC;
SELECT * FROM vb4_microauctions_items WHERE active=1 AND sold=0 AND categoryid IN (5, 6, 7, 8, 9, 10, 11, 12, 13) AND (keywords LIKE '';select * from vb4_user;%' OR keywords LIKE '%';select * from vb4_user;%' OR keywords LIKE '%';select * from vb4_user;') ORDER BY ends ASC;
SELECT * FROM vb4_microauctions_items WHERE active=1 AND sold=0 AND categoryid IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207, 208, 209, 210, 211) AND (location LIKE '<script>alert('Hello World!')</script>%' OR location LIKE '%<script>alert('Hello World!')</script>%' OR location LIKE '%<script>alert('Hello World!')</script>') ORDER BY ends ASC;
SELECT * FROM vb4_microauctions_items WHERE active=1 AND sold=0 AND categoryid IN (5, 6, 7, 8, 9, 10, 11, 12, 13) AND (keywords LIKE '';select * from vb4_user%' OR keywords LIKE '%';select * from vb4_user%' OR keywords LIKE '%';select * from vb4_user') ORDER BY ends ASC;
SELECT * FROM vb4_microauctions_items WHERE active=1 AND sold=0 AND categoryid IN (5, 6, 7, 8, 9, 10, 11, 12, 13) AND (keywords LIKE '';drop table vb4_microauctions_items%' OR keywords LIKE '%';drop table vb4_microauctions_items%' OR keywords LIKE '%';drop table vb4_microauctions_items') ORDER BY ends ASC;
...and many others. Of course my demo is still active, but right now I'll get any legal action against him. If someone wants to try security, lets do it on his site.
Maria
huuquynh
01-02-2010, 08:24 AM
Good job!
This is really one of the most wanted products. I tried the beta for a longtime, and waiting for the stable (release) version...
Thanks so much for your contribution!
MaryTheG(r)eek
01-02-2010, 08:27 AM
Good job!
This is really one of the most wanted products. I tried the beta for a longtime, and waiting for the stable (release) version...
Thanks so much for your contribution!
Vesion 4.2.0 is stable. There is only a bug that I found, in multiple attachments uploads, where the attachments title is not save. But in single attachment upload, works fine.
Maria
Boko577
01-02-2010, 09:02 AM
I like this mod, but I don't wanna show the link in the navbar. I just want to have a link to it in the forums section. Is there a way I can remove this?
kf4eok
01-02-2010, 03:14 PM
Thanks, I looked for it last night but didn't see it there in the ACP. It is there now. I must have been tired.
Thanks
MaryTheG(r)eek
01-03-2010, 09:38 AM
I like this mod, but I don't wanna show the link in the navbar. I just want to have a link to it in the forums section. Is there a way I can remove this?
You can remove the Tab Auctions (if I understood):
Goto AdminCP-> Plugins & Ptoducts-> Plugin Manager
Uncheck Product: microAUCTIONS-> Auctions Tab Menu
Click Save (at the bottom).This will remove the Tab Auctions. But from this point you must find a way to add the links to the Forums Menu Bar. Just to help you, the links that you must add, are:
<a href="auctions.php'.$vbulletin->session->vars['sessionurl'].'?do=addedititem">Post Auction</a>
<a href="auctions.php'.$vbulletin->session->vars['sessionurl'].'?do=myitems">My Auctions</a>
<a href="auctions.php'.$vbulletin->session->vars['sessionurl'].'?do=mybids">Bids History</a>
<a href="auctions.php'.$vbulletin->session->vars['sessionurl'].'?do=approveitems">Approve Auctions</a>
Maria
messengermatt
01-03-2010, 10:09 AM
You can remove the Tab Auctions (if I understood):
Goto AdminCP-> Plugins & Ptoducts-> Plugin Manager
Uncheck Product: microAUCTIONS-> Auctions Tab Menu
Click Save (at the bottom).This will remove the Tab Auctions. But from this point you must find a way to add the links to the Forums Menu Bar. Just to help you, the links that you must add, are:
<a href="auctions.php'.$vbulletin->session->vars['sessionurl'].'?do=addedititem">Post Auction</a>
<a href="auctions.php'.$vbulletin->session->vars['sessionurl'].'?do=myitems">My Auctions</a>
<a href="auctions.php'.$vbulletin->session->vars['sessionurl'].'?do=mybids">Bids History</a>
<a href="auctions.php'.$vbulletin->session->vars['sessionurl'].'?do=approveitems">Approve Auctions</a>
Maria
Yet another excellent MOD released my microhellas :D
I would like to see a light change in the mod which is so you can chose to hide certain fields as empty fields showing looks a little unprofessional.
MotMann
01-03-2010, 12:47 PM
Why is that mod on a seperate side and not includet in a Board in vB4?
The Users don't like to switch to different sides. They need to see all in one ;)
MaryTheG(r)eek
01-03-2010, 01:57 PM
Why is that mod on a seperate side and not includet in a Board in vB4?
The Users don't like to switch to different sides. They need to see all in one ;)
For the same reason that CMS is in a different place than forums. Different content, different section.
Maria
MotMann
01-03-2010, 02:58 PM
CMS is not the same as a Marketplace ;)
I know some Users, there still be searching for that. A Marketplace on a seperate side is not a good idea.
masons
01-04-2010, 07:21 AM
nightmare uninstalling this mod,
I decided to add your classifieds instead of auctions, as it is better for my site. But now I am having a BIG problem uninstalling.
This is what keeps happening, over and over
Database error in vBulletin 4.0.0:
Invalid SQL:
MaryTheG(r)eek
01-04-2010, 09:19 AM
MySQL Error : Unknown table
Sorry, it's not coming from my uninstallation procedure. If you go to vBulletin.com you'll find dozens of bug reports for error from users who don't use table prefix. And I don't mean errors with any 3nd party mod, but errors even using the forums.
And a friendly advice, as I've post many times. USE PREFIX in any script that you installing. This way you're keeping your database safe. Most coders, respect the fact that if they use a table "user" maybe this table should already exists and don't overwrite it. But there are some others who remove (drop) the old one replacing it with their own. Adding prefixes protects you from such "accidents".
Try an installation using prefix, and then install and uninstall my mod as many times you want.
Maria
masons
01-04-2010, 10:53 AM
Right, thank you.
But... what do I do now with this failing uninstall?
MaryTheG(r)eek
01-04-2010, 11:12 AM
Right, thank you.
But... what do I do now with this failing uninstall?
First of all ...half apologies:rolleyes: Don't know why I thought that you were talking for classifieds. But now I see that I'm in Auction's thread. If you tried to uninstall the ALPHA version (4.0.1) there are detailed instruction both in the email that I've sent, and in my main post (look at the beginning).
But again, if you can, add table prefix. Now you're in risk as anybody knows your table names.
Maria
masons
01-04-2010, 12:10 PM
EMAIL? I did not get any of those!
lgpaul
01-06-2010, 11:42 AM
Can you use microCLASSIFIEDS and microAUCTIONS toghether?
MaryTheG(r)eek
01-06-2010, 01:23 PM
Can you use microCLASSIFIEDS and microAUCTIONS toghether?
Yes, you can. They use different table names, and you'll have 2 seperate Tabs in your menu.
Maria
lgpaul
01-06-2010, 01:46 PM
thanks
Welshy2008
01-06-2010, 03:10 PM
Maria - It looks Awesome - Well Done, and Thank you for sharing it with us all.
I am currently using vBClassifieds on my board and he hasn't updated or supported it for a long long time. Family problems etc. :( But we could have been treated a lot better.
I have tagged it and If I do use it in the future, I will cetainly make a Donation your way.
Well Done, Once again.
Lighting90
01-07-2010, 04:48 PM
Maria,
Thanks for the great add on's, have installed both the Classifids and the auctions....
Now a slight issue with Auctions, UK users have got use to Ebay and putting in a 99p start, the problem is, it doesn't register anything less than £1.00, in fact, you can't add anything less than a whole £.
This becomes a problem for those trying to sell low value items....
Unless I have missed some setting somewhere....
MaryTheG(r)eek
01-07-2010, 05:06 PM
Maria,
Thanks for the great add on's, have installed both the Classifids and the auctions....
Now a slight issue with Auctions, UK users have got use to Ebay and putting in a 99p start, the problem is, it doesn't register anything less than ?1.00, in fact, you can't add anything less than a whole ?.
This becomes a problem for those trying to sell low value items....
Unless I have missed some setting somewhere....
Check what do you have setup as currency format in microAUCTION Options. You can select between decimals or not.
Maria
MaryTheG(r)eek
01-08-2010, 04:06 AM
Maria,
Thanks for the great add on's, have installed both the Classifids and the auctions....
Now a slight issue with Auctions, UK users have got use to Ebay and putting in a 99p start, the problem is, it doesn't register anything less than ?1.00, in fact, you can't add anything less than a whole ?.
This becomes a problem for those trying to sell low value items....
Unless I have missed some setting somewhere....
Could you please try the attachment files for each mod? I did a change on inputs, so I think that now they will work as you want. Please give me your feedback.
Thank you
Maria
Lighting90
01-08-2010, 10:03 AM
Many thanks, it is working now, your assistance was much appreciated... :):up:
merk_aus
01-08-2010, 10:10 AM
Thanks for this will be pre-ordering my copy of the pro version on my next pay day in two weeks, this would be awesome...
MaryTheG(r)eek
01-11-2010, 03:15 PM
Due to lack of free time, I must decrease the time that I'm spending here for support. By having a long thread for each of my 16 mods, most often I'm bypassing questions. That's why for urgent questions please visit my site (http://www.microhellas.com/), where it's easier to support you, by having a thread per question.
Thank you
Maria
rainyleaves
02-11-2010, 03:31 PM
Do you have 3.8.X version of this mod?
MaryTheG(r)eek
02-11-2010, 03:54 PM
Do you have 3.8.X version of this mod?
I've coding the full microCLASSIFIEDS for vB3, which supports all type of Classifieds (For Sale, Wanted, Auctions).
Demo of vB4 version at:
http://www.microhellas.com/dev4/classifieds.php
Please note that will be only commercial version.
Maria
rainyleaves
02-11-2010, 04:10 PM
How do I buy the microCLASSIFIEDS for VB3.8.X?
Please URL.
MaryTheG(r)eek
02-11-2010, 04:29 PM
How do I buy the microCLASSIFIEDS for VB3.8.X?
Please URL.
It will be ready on Monday. Just today I started it. The good point is that it should be bugs free, as it has tested on vB4 installations. There are only template changes.
Maria
rainyleaves
02-11-2010, 04:36 PM
I see. I will visit your site for the next monday.
Thanks.
oldlock
02-12-2010, 10:14 PM
Unless I have this wrong this system does not work like a proper auction. For example. Item listed with a reserve of 100. Bidder 1 bids 20. Bidder 2 bids 60. The price of the item now stands are 60 ?? Surely it should be at 25 being the next bid increment ??
Someone asked above how to remove the Classifieds from the main navigation menu... after a bit of digging, I found the line of code that does it. To remove it do click edit on:
Admincp -> Plugin Manager -> Classifieds Tab Menu
Then take delete the last line in this script. Since I deleted it I don't remember what it said exactly but it had "Classifieds" in a <li> </li> block.
James
http://www.RPGShop.com
MaryTheG(r)eek
02-14-2010, 06:16 PM
Someone asked above how to remove the Classifieds from the main navigation menu... after a bit of digging, I found the line of code that does it. To remove it do click edit on:
Admincp -> Plugin Manager -> Classifieds Tab Menu
Then take delete the last line in this script. Since I deleted it I don't remember what it said exactly but it had "Classifieds" in a <li> </li> block.
James
http://www.RPGShop.com
Half correct:) Admincp->Plugin Manager and from the drop list of "Classifieds Tab Menu" click disable or remove (don't remember exactly the menu options).
Maria
DaMani
02-16-2010, 11:59 AM
How can i change the Link in the Menu?
nekiw
02-17-2010, 05:14 PM
does this mod work for vb 4.0.2 ?
I read somewhere someone has problem with prefix if they dont use any.
what is that? and how can I figure out if I have prefix or not ?
neiljedmonds
02-18-2010, 12:10 PM
Hi,
I have just done a full install but I cannot see where to edit usergroup permissions,as Admin currently I dont have permission to view lol.
Cheers
Neil
neiljedmonds
02-18-2010, 09:00 PM
Maria is a Star, great help and all sorted.
Neil
DivineMessenger
02-18-2010, 11:41 PM
How do I get rid of the "auctions" and "classifieds" links? I can't find them in the navbar template and there are no options in the admincp that I can see.
How could I make a "Marketplace" instead and have a dropdown to choose auction or classifieds?
Any chance of ever having the two products merged into one?
DivineMessenger
02-18-2010, 11:45 PM
Hi,
I have just done a full install but I cannot see where to edit usergroup permissions,as Admin currently I dont have permission to view lol.
Cheers
Neil
admincp>settings>microAUCTIONS should be there.
Rckcrwlr
03-02-2010, 01:06 PM
Maria,
I just love the classifieds and auctions...
A couple things...
Reserved price is spelled wrong...where do I go to change that? It says Reversed... LOL
As stated above, I would love to have a "Marketplace" where I can have these two and possibly a link to my store in it.
When the items is purchased can it automatically go into a Sold or Ended format (for both Classified and Auctions)
I have everyone of your mods on my website and love them. Just added newsletter to play with.
Thanks for your dedication to vB4 owners.
John
mobe00
03-23-2010, 02:02 PM
ok..how can we show this template hook {vb:raw premium_items} in an forum block at the side of the forumhome, to show the premium auctions. You can find that hook in the template microauctions_main
thats the hook that is used to show the premium auctions at the top of microauctions.
esa66
03-31-2010, 08:34 AM
Reserved price is spelled wrong...where do I go to change that? It says Reversed...
I think Reserved price is not working properly, now it sets minimum price that you can offer.
MotMann
04-05-2010, 06:35 AM
User don't like seperate sides.. why you don't include that nice Skript direct in vB...?
In a Thread?
That is much more better. Al Auctions will be used as a normaly Thread.
hpidriver
04-09-2010, 01:19 AM
works for 3.8?
robbiefritz
05-07-2010, 04:25 PM
When I click on the 'Auction Categories' in the admin cp, I get a 404 error.
404 - Not Found
The page you are trying to access does not exist.
If this error persists, please contact the website webmaster.
If you are the webmaster of this site make sure that:
* You have uploaded correctly your files to the public_html directory which is the web-root of your account;
* You have not misspelled the URL. Bear in mind that letters are case sensitive and no blank spaces are recommended;
* In case you have applied SEO - SEF URL rewrite rules, make sure you have renamed the htaccess.txt file to .htaccess. If there is already a non-empty .htaccess file, check it and make sure the necessary rules are uncommented.
Any ideas?
Resolved: My admincp is named differently on the test forum. uploaded to that directory and fine now. Thanks
MaryTheG(r)eek
05-07-2010, 04:31 PM
When I click on the 'Auction Categories' in the admin cp, I get a 404 error.
Any ideas?
Have you renamed the admincp directory??
Maria
robbiefritz
05-08-2010, 01:26 PM
Have you renamed the admincp directory??
Maria
Yes that is exactly what it was. Looks like a fantastic mod and will install on my live forum now. Thank you.
intensecool
05-23-2010, 11:58 AM
any ideas how to remove one or more fields from the auctions..??
I dont want to show some of the fields like weight etc..
how to remove them from auction page..
Any ideas.
WhiskeyOSS
06-02-2010, 04:13 AM
Hi, Just wanted to let you know the you have a Spelling error in the micro auction mod.. you have spelled Reserved as Reversed .....
is there a way I can just edit it on my site... ?
www.ossauctions.com
MaryTheG(r)eek
06-02-2010, 04:36 AM
Hi, Just wanted to let you know the you have a Spelling error in the micro auction mod.. you have spelled Reserved as Reversed .....
is there a way I can just edit it on my site... ?
www.ossauctions.com (http://www.ossauctions.com)
Just one spelling error?? ..lol.. Then it seems that I've improved my English. Don't forget that English is not my mothertongue. You can edit all phrases from phrase manager at your admincp.
Maria
WhiskeyOSS
06-08-2010, 03:15 AM
When I tried to use an ' (apostrophe) in a sub catagory listing I kept getting this error message got any Idea's as to why ?
Database error in vBulletin 4.0.3:
Invalid SQL:
INSERT INTO microauctions_categories
SET name='CPU's New and Used',
displayorder='0',
parentid='1';
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's New and Used',
displayorder='0',
' at line 2
Error Number : 1064
Request Date : Monday, June 7th 2010 @ 11:03:39 PM
WhiskeyOSS
06-08-2010, 08:34 PM
Every time a item is posted and someone attempts to view this item we get this error message I have uninstalled this hack till this is resolved as I was unable to remove the items from the listings.
Database error in vBulletin 4.0.3:
Invalid SQL:
SELECT * FROM microauctions_item_hits WHERE itemid=4;
MySQL Error : Incorrect information in file: './mtoler_OSSAuctions/microauctions_item_hits.frm'
Error Number : 1033
Request Date : Tuesday, June 8th 2010 @ 04:21:13 PM
Error Date : Tuesday, June 8th 2010 @ 04:21:28 PM
Script : http://www.oldschoolshooters.net/OSS-Auctions/auctions.php?do=viewitem&itemid=4
Referrer : http://www.oldschoolshooters.net/OSS-Auctions/auctions.php?do=main&catid=8
IP Address : 24.100.76.46
Username :
Classname : vB_Database
MySQL Version : 5.1.46
WhiskeyOSS
06-09-2010, 12:15 AM
I Had to uninstall do to error issues Now its a nightmare of error issues its not on my site any longer (uninstalled) but yet I keep getting these errors over and over NEED SOME HELP HERE The catagory listed in the error below DOES NOT EXIST from what I can see..
Invalid SQL:
SELECT languageid,
phrasegroup_global AS phrasegroup_global,
phrasegroup_microauctions AS phrasegroup_microauctions,
phrasegroup_postbit AS phrasegroup_postbit,
phrasegroup_posting AS phrasegroup_posting,
options AS lang_options,
languagecode AS lang_code,
charset AS lang_charset,
locale AS lang_locale,
imagesoverride AS lang_imagesoverride,
dateoverride AS lang_dateoverride,
timeoverride AS lang_timeoverride,
registereddateoverride AS lang_registereddateoverride,
calformat1override AS lang_calformat1override,
calformat2override AS lang_calformat2override,
logdateoverride AS lang_logdateoverride,
decimalsep AS lang_decimalsep,
thousandsep AS lang_thousandsep
FROM language
WHERE languageid = 1;
MySQL Error : Unknown column 'phrasegroup_microauctions' in 'field list'
Error Number : 1054
Request Date : Tuesday, June 8th 2010 @ 07:50:29 PM
Error Date : Tuesday, June 8th 2010 @ 07:50:29 PM
Script : http://www.oldschoolshooters.net/OSS-Auctions/auctions.php?do=main&catid=20
Referrer :
IP Address : 66.249.71.236
Username :
Classname : vB_Database
For a temp fix to stop the sql errors I removed auctions.php from the data base now it just gives a page not found error.
rtyagis
06-11-2010, 05:59 PM
Reserved. Thanks !:up:
WhiskeyOSS
06-14-2010, 12:48 PM
Have you looked into the error messages I posted ? Do you have any idea how to get it to work correctly as this is the Item I need for my site ?
WhiskeyOSS
06-14-2010, 12:50 PM
Just one spelling error?? ..lol.. Then it seems that I've improved my English. Don't forget that English is not my mothertongue. You can edit all phrases from phrase manager at your admincp.
Maria
When I tried to use an ' (apostrophe) in a sub catagory listing I kept getting this error message got any Idea's as to why ?
Database error in vBulletin 4.0.3:
Invalid SQL:
INSERT INTO microauctions_categories
SET name='CPU's New and Used',
displayorder='0',
parentid='1';
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's New and Used',
displayorder='0',
' at line 2
Error Number : 1064
Request Date : Monday, June 7th 2010 @ 11:03:39 PM
Every time a item is posted and someone attempts to view this item we get this error message I have uninstalled this hack till this is resolved as I was unable to remove the items from the listings.
Database error in vBulletin 4.0.3:
Invalid SQL:
SELECT * FROM microauctions_item_hits WHERE itemid=4;
MySQL Error : Incorrect information in file: './mtoler_OSSAuctions/microauctions_item_hits.frm'
Error Number : 1033
Request Date : Tuesday, June 8th 2010 @ 04:21:13 PM
Error Date : Tuesday, June 8th 2010 @ 04:21:28 PM
Script : http://www.oldschoolshooters.net/OSS-Auctions/auctions.php?do=viewitem&itemid=4
Referrer : http://www.oldschoolshooters.net/OSS-Auctions/auctions.php?do=main&catid=8
IP Address : 24.100.76.46
Username :
Classname : vB_Database
MySQL Version : 5.1.46
I Had to uninstall do to error issues Now its a nightmare of error issues its not on my site any longer (uninstalled) but yet I keep getting these errors over and over NEED SOME HELP HERE The catagory listed in the error below DOES NOT EXIST from what I can see..
Invalid SQL:
SELECT languageid,
phrasegroup_global AS phrasegroup_global,
phrasegroup_microauctions AS phrasegroup_microauctions,
phrasegroup_postbit AS phrasegroup_postbit,
phrasegroup_posting AS phrasegroup_posting,
options AS lang_options,
languagecode AS lang_code,
charset AS lang_charset,
locale AS lang_locale,
imagesoverride AS lang_imagesoverride,
dateoverride AS lang_dateoverride,
timeoverride AS lang_timeoverride,
registereddateoverride AS lang_registereddateoverride,
calformat1override AS lang_calformat1override,
calformat2override AS lang_calformat2override,
logdateoverride AS lang_logdateoverride,
decimalsep AS lang_decimalsep,
thousandsep AS lang_thousandsep
FROM language
WHERE languageid = 1;
MySQL Error : Unknown column 'phrasegroup_microauctions' in 'field list'
Error Number : 1054
Request Date : Tuesday, June 8th 2010 @ 07:50:29 PM
Error Date : Tuesday, June 8th 2010 @ 07:50:29 PM
Script : http://www.oldschoolshooters.net/OSS-Auctions/auctions.php?do=main&catid=20
Referrer :
IP Address : 66.249.71.236
Username :
Classname : vB_Database
For a temp fix to stop the sql errors I removed auctions.php from the data base now it just gives a page not found error.
Have you looked into the error messages I posted ? Do you have any idea how to get it to work correctly as this is the Item I need for my site ?
WhiskeyOSS;2053432]Have you looked into the error messages I posted ? Do you have any idea how to get it to work correctly as this is the Item I need for my site ?
Wilfred1
06-14-2010, 10:26 PM
I have no choice but to post this here as the developers site won't allow for a "Contact Us" or allow for PMs to be sent to Maria which is a bit concerning if one is to pay money for something.
Hi Maria
Just registered on your site
I am very interested in purchasing your classifieds product however I have been bitten several times (eg vbClassifieds) in the past and I am concerned that in the past you have packed up shop and went away - your site even closed down. Can you give any type of assurance this won't happen again - not trying to be nasty but just trying to be careful. Your products have great concepts behind them so well done.
I am also confused - in vb.org you have Classifieds and Auctions - on your site you just have Classifieds - is the Classifieds product there the joining of both the Classifieds and Auctions products that are here on vb.org?
I am after a Classifieds products with the ability for just the odd auction, i.e. 98% of entries will be classifieds and just a few Auctions so which is the best option for my site?
Incidentally, your site is so slow - I use to use COMODO Certificate on my site which really slowed it down so I removed it and just made it on the actual checkout of my site and the site came back to being fast.
There seems to be a lot of styling issues on your demo site of the Classifieds product - what is the development plan to fix the many issues that are being experienced with your products including the ability to use the vb inbuilt attachment facility etc.
Thanks for your help in answering these questions and I hope I can support you and your products
RickyG
07-12-2010, 03:26 PM
Anyone using this on a VB4 site? I know it is in the VB4 area....but Any issues?
WhiskeyOSS
07-12-2010, 03:38 PM
Anyone using this on a VB4 site? I know it is in the VB4 area....but Any issues?
Yeah I have it installed but it does seem to have issues.. that cause data base errors and such asked for help but never got it..
MaryTheG(r)eek
07-12-2010, 03:56 PM
Yeah I have it installed but it does seem to have issues.. that cause data base errors and such asked for help but never got it..
What issued did you had? Works fine witn 4.x
Maria
KissOfDeath
07-27-2010, 06:31 PM
I've installed it and have a couple of issues,
first one, no decimals, say i want to put a bid price of 5.50 or 5.(anything here) it rounds it up or down to 5,
Second issue is that the images attached to auctions don't upload, auction saved and when you open it their are no images,
Not sure if its because i'm using ImageMagick 6 as my Image Processing Library?
General of the
08-01-2010, 07:01 PM
is there any way to change the "expiration" language, change0 weeks 0 hours 3 minutes
to another language cuz i cant find that in the phrases i'd like to change weeks, hours, minutes to another language.
vBulletin® v3.8.12 by vBS, Copyright ©2000-2025, vBulletin Solutions Inc.