Major Additions - SR Classifieds 1.0.2 Light

Brought to you by:
DopeGFX
-----------------------------------------------------------------
LOGOS | WEBSITES | SKINS | HTML | PHP(Limited) | AND MUCH MUCH MORE!
-----------------------------------------------------------------
In Conjunction With
SiteResort

**Attention**
This hack is now being released as a "Lite" version. All existing features are still there, do not worry. However, a premium version is comming soon and will have even more features. This hack will continue to be supported. The only difference is that a premium version is comming shortly with more features.

**Copyright**
This script cannot be redistributed, reproduced, or published in any way unless given permission my the author (me). Modifying this script and sharing your modification elsewhere without the author's knowledge is not allowed as well. The following text on the script is not to be taken off:

SR Classifieds, By www.siteresort.com

**Before Making An Add on **
Please consult with me before making an add on to this hack. As it is my work and such, the add ons that you are trying to make for it may be in the next release and/or premium version.


[high]Changelog:[/high]
4-13-06
* Security patch while editing ads (there was a little hole) All that needs to be done is reuploading sr_classifieds.php

[high]Changelog:[/high]
4-11-06
* Admins can delete feedback
* User profile fixed (minor template issues)
* Ad type shown in adbit
* No more error message when saving field

[high]Changelog:[/high]
4-9-06
* There was a problem with a code that made it so that if you didn't have an image in an ad and then edited that ad to include an image, it overwrote noimage.gif (which is not good!). This was fixed!
* Ad ID Number now shows in an ad
* Price now shows in an ad

What does this do?
This hack gives you a classified ad system. Multiple categories can be created and users can post ads in these categories. Other users can then rate them and give them feedback accordingly.

What features does this hack provide?

• Main page with statistics, categories, recent activity, etc.
• Ability to arrange ads in categories
• Categories can have their own images
• See how many total, closed, and open ads are in each category.
• Ratings and category counts are automatically rebuilt
• After the timeframe of the ad is up, the ad is closed
• Add new classified ads with images, description, title, and more!
• Users have their own page where feedback and such shows.
• Paypal button is automatically generated if the user enters a paypal email address. Clicking this button will allow the user to buy whatever the other user is selling.
• Add extra fields to ads
• Ability to edit and delete ads
• Control everything from the amount of results showing per page in searches, to the size of thumbnails.
• GIF, JPG, and PNG images are supported.
• Search through ads
• And much much more!

What does this hack require?
Template Edits: 3
Products Imported: 1

[high]6 Easy Steps[/high]
Step 1. Import the following product: product-sr_classifieds.xml
Step 2. Upload the files in the upload folder.
Step 3. CHMOD the sr_classifieds/uploaded folder and sr_classifieds/uploaded/thumbnails folder to 777
Step 4. Do the edits located below
Step 5. Update newly added usergroup permissions and options
Step 6. Enjoy the hack.

[high]F.A.Q[/high]
Q. How can i reserve the premium version?
A. Send me a message here on the forums or email me at gio@dopegfx.com


Don't forget to click INSTALL

[high]As always, feel free to make a donation to:[/high]
gio@dopegfx.com

[Gio~Logist]

I found the problem for the usergroup permissions.. one second.

ZIP UPDATED

Wow. I was setting one permission in usergroup settings and then calling the wrong one in the file lol. Sorry about that guys.

If you already have this installed just either uninstall the product and reupload files and product or run this query:

ALTER TABLE ". TABLE_PREFIX ."usergroup DROP sr_classifieds

And then re upload just product.

Feel free to PM me if you need help. It was my dumb mistake anyways

[nix]

Fixed.

[Gio~Logist]

Originally Posted by nix

Fixed.

Sorry about that Nix. I tend to look over little things like this sometimes.

[nix]

NP. Glad I could help.

Two small suggestions.

1. Feature for seller/trader to set ad to sold or traded.

2. A link to buy item (if paypal giving) when viewing the actual ad.

[KTBleeding]

Just to let you know:

I had to take a look at the install code to fix an error I was getting after running the query you posted above.. but I believe I have that sorted.

Noticed this in the installer:

$vbulletin->db->query_write("
CREATE TABLE IF NOT EXISTS `sr_classifieds_ratings` (
  `rateid` int(10) unsigned NOT NULL auto_increment,
  `ratedid` int(10) unsigned NOT NULL default '0',
  `raterid` int(10) unsigned NOT NULL default '0',
  `rating` int(2) NOT NULL default '0',
  `comment` varchar(250) NOT NULL default '',
  `type` varchar(20) NOT NULL default '',
  `adid` int(10) unsigned NOT NULL default '0',
  `dateline` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`rateid`)
) TYPE=MyISAM
");


$vbulletin->db->query_write("
CREATE TABLE IF NOT EXISTS `sr_classifieds_uploads` (
  `classifiedid` int(10) unsigned NOT NULL default '0',
  `image` varchar(250) NOT NULL default 'noimage.gif'
) TYPE=MyISAM;
");

They should have ". TABLE_PREFIX ." assigned, correct?

[Gio~Logist]

Originally Posted by KTBleeding

Just to let you know:

I had to take a look at the install code to fix an error I was getting after running the query you posted above.. but I believe I have that sorted.

Noticed this in the installer:

$vbulletin->db->query_write("
CREATE TABLE IF NOT EXISTS `sr_classifieds_ratings` (
  `rateid` int(10) unsigned NOT NULL auto_increment,
  `ratedid` int(10) unsigned NOT NULL default '0',
  `raterid` int(10) unsigned NOT NULL default '0',
  `rating` int(2) NOT NULL default '0',
  `comment` varchar(250) NOT NULL default '',
  `type` varchar(20) NOT NULL default '',
  `adid` int(10) unsigned NOT NULL default '0',
  `dateline` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`rateid`)
) TYPE=MyISAM
");


$vbulletin->db->query_write("
CREATE TABLE IF NOT EXISTS `sr_classifieds_uploads` (
  `classifiedid` int(10) unsigned NOT NULL default '0',
  `image` varchar(250) NOT NULL default 'noimage.gif'
) TYPE=MyISAM;
");

They should have ". TABLE_PREFIX ." assigned, correct?

Ah yes. That's not a major issue as far as functionability is concerned, however, it should be there. I added it and updated the zip

[KTBleeding]

Bug report time:

I have uploaded an image when adding an ad, but it is only displaying the "noimage.gif" rather than the uploaded image.

I looked in the /sr_classifieds/uploaded folder, and the image was uploaded correctly, just not being displayed.

EDIT:

Nevermind. Now it's showing up.. Hm.

[Gio~Logist]

Originally Posted by KTBleeding

Bug report time:

I have uploaded an image when adding an ad, but it is only displaying the "noimage.gif" rather than the uploaded image.

I looked in the /sr_classifieds/uploaded folder, and the image was uploaded correctly, just not being displayed.

EDIT:

Nevermind. Now it's showing up.. Hm.

lol. It's ok... it's late.. I understand

[arossphoto]

Sorry, but I'm a bit lost. I just installed this, have set user permissions and turned SR Classfieds on, but all I get is the link in the nav bar that takes me to sr_classifieds.php. I don't see any of the administrative features and don't know how to create cats or new ads.

Thanks,

Andrew

[Gio~Logist]

Originally Posted by arossphoto

Sorry, but I'm a bit lost. I just installed this, have set user permissions and turned SR Classfieds on, but all I get is the link in the nav bar that takes me to sr_classifieds.php. I don't see any of the administrative features and don't know how to create cats or new ads.

Thanks,

Andrew

You create cats in the admincp and post new ads in the main page (once categories are added).