vb.org Archive
Page 1 of 13 1 2311 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Major Additions - SR Classifieds 1.0.2 Light (https://vborg.vbsupport.ru/showthread.php?t=112504)

Gio~Logist 04-08-2006 10:00 PM
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

https://vborg.vbsupport.ru/external/2006/07/12.gif

Gio~Logist 04-08-2006 11:33 PM
Here are some screenshots.

Gio~Logist 04-08-2006 11:36 PM
More Screenshots.

glorify 04-09-2006 12:09 AM
Will this work with all 3.5's and also, what are the drawbacks if any used in conjunction with vbadvanced?

Gio~Logist 04-09-2006 12:14 AM
Quote:
Originally Posted by glorify
Will this work with all 3.5's and also, what are the drawbacks if any used in conjunction with vbadvanced?
It should work with any version and i don't see any drawbacks. I may actually plan on creating a vb module for this.

bada_bing 04-09-2006 12:15 AM
Wow this looks SWEET.. To bad I have itrader installed and hate to try and migrate systems.... Will look at this for my other site...

glorify 04-09-2006 12:15 AM
Sweet. Also, Can you define the extra fields to only one specific forum?

Gio~Logist 04-09-2006 12:18 AM
Quote:
Originally Posted by glorify
Sweet. Also, Can you define the extra fields to only one specific forum?
Yes.

Gio~Logist 04-09-2006 12:18 AM
Quote:
Originally Posted by bada_bing
Wow this looks SWEET.. To bad I have itrader installed and hate to try and migrate systems.... Will look at this for my other site...
Would it help if i made a system that would conver all itrader ratings to SR Classified ratings?

glorify 04-09-2006 12:30 AM
When updating usergroup permissions, they don't save, I get:

Quote:
Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /includes/class_core.php on line 635

Gio~Logist 04-09-2006 12:34 AM
Quote:
Originally Posted by glorify
When updating usergroup permissions, they don't save, I get:
This may be something with your site and another hack. I tried updating permissions on both my site and someone else's and got no error. However, i will look into this.

Also, remember that support is only given to those who click install.

glorify 04-09-2006 12:35 AM
Cool--let me know, I will be interested in premium as well if I can get this up and running.

nix 04-09-2006 12:38 AM
Getting this error when creating a field for a cat.

Code:
nvalid SQL:

                SELECT title, image, description, categoryid, usergroups, banned, display
                FROM sr_classifieds_category
                ORDER BY categoryid DESC;

MySQL Error  : Unknown column 'usergroups' in 'field list'
Error Number : 1054

Gio~Logist 04-09-2006 12:38 AM
Quote:
Originally Posted by glorify
Cool--let me know, I will be interested in premium as well if I can get this up and running.
Feel free to PM me with your site info and such so that i can take a look. I am 99% sure that it's just something wrong with your site in general.

Gio~Logist 04-09-2006 12:40 AM
Quote:
Originally Posted by nix
Getting this error when creating a field for a cat.

Code:
nvalid SQL:

                SELECT title, image, description, categoryid, usergroups, banned, display
                FROM sr_classifieds_category
                ORDER BY categoryid DESC;

MySQL Error  : Unknown column 'usergroups' in 'field list'
Error Number : 1054
Oops. That shouldn't be there. Zip will be updated now. Sorry about that.

Zip Updated

Just reupload the sr_classifieds_admin.php file and all should be fine.

nix 04-09-2006 12:48 AM
Code:
Warning: getimagesize(): Read error! in /sr_classifieds.php on line 616
And getting a red X for an image that I believe is part of the item image. But I didn't upload one.

this is the link its looking for. /forums/sr_classifieds/uploaded/

Gio~Logist 04-09-2006 12:59 AM
Quote:
Originally Posted by nix
Code:
Warning: getimagesize(): Read error! in /sr_classifieds.php on line 616
And getting a red X for an image that I believe is part of the item image. But I didn't upload one.

this is the link its looking for. /forums/sr_classifieds/uploaded/
It's supposed to put an image by default, did it not?

I just checked on my site and i had a little problem with it not setting a default image. I will update the zip. To fix this on your existing ad, just upload any image or delete and redo the ad.

Zip updated, you can just reupload sr_classifieds.php if you'd like.

Also, i just fixed a problem where if your image was the default image, it deleted the default image when the ad was deleted. This isn't good because then you will have no default image! Anyways, the problem with that has been fixed as well. If the Last Update: date shows green to you, then make sure to re-install the hack by overwriting products and files!.

dilbert 04-09-2006 01:09 AM
:( I bought PhotoPost classifieds and paid for the branding free option and form the pics you posted, this looks better.

nix 04-09-2006 01:09 AM
Thanks! Working good so far.

Just a very minor bug (I think its one), in the user group permissions there isn't a title for the field for the classifieds. Its just blank.

Just had this after editing a field.

Code:
Database error in vBulletin 3.5.4:

Invalid SQL:
UPDATE sr_classifieds_fields
                                                                                SET        title = 'Stepping',
                                                                                        description = 'Stepping of the CPU',
                                                                                        type = 'text',
                                                                                        size = '100',
                                                                                        options= '',
                                                                                        category = '1',
                                                                                        display = '1',
                                                                                        WHERE fieldid = 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 'WHERE fieldid = 1' at line 9
Error Number : 1064
Also, I don't see the administrative Tools like in your screenshot #3. I updated the usergroup permissions also.

KTBleeding 04-09-2006 01:13 AM
Oh wow.. thanks for making this.

My site I'm working on needs one, and I didn't want to have to do it myself. :)

Good job, will install when I get around to.. installing it. :x

Gio~Logist 04-09-2006 01:25 AM
Quote:
Originally Posted by nix
Thanks! Working good so far.

Just a very minor bug (I think its one), in the user group permissions there isn't a title for the field for the classifieds. Its just blank.

Just had this after editing a field.

Code:
Database error in vBulletin 3.5.4:

Invalid SQL:
UPDATE sr_classifieds_fields
                                                                                SET        title = 'Stepping',
                                                                                        description = 'Stepping of the CPU',
                                                                                        type = 'text',
                                                                                        size = '100',
                                                                                        options= '',
                                                                                        category = '1',
                                                                                        display = '1',
                                                                                        WHERE fieldid = 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 'WHERE fieldid = 1' at line 9
Error Number : 1064
Also, I don't see the administrative Tools like in your screenshot #3. I updated the usergroup permissions also.
That's just an uneeded comma. Replace the sr_classifieds_admin.php with the one i uploaded here. I will update the zip now.

nix 04-09-2006 01:32 AM
Get this when saving the field.

Code:
could not find phrase 'sr_classifieds_x_fieldsaved'.
Also, any ideas on the admin tools?

Gio~Logist 04-09-2006 01:40 AM
Zip Updated. Just a phrase i forgot to add.

KTBleeding 04-09-2006 01:46 AM
Tried to add a custom field.. ran into this part:

Quote:
Categories To Include This InPlease enter the ID's of the categories in which you'd like to have these options included in, seperated by a comma. Leave this blank for it to be in all forums.
Ex: 1,2,3
But the field next to that is a drop down.. not a text field. So we can't enter 1,2,3.. we are only able to select one category.

nix 04-09-2006 01:50 AM
Quote:
Originally Posted by gio~logist
Zip Updated. Just a phrase i forgot to add.
Uploaded everything and reinstalled the product-sr_classifieds.xml and the pharse still isnt there.

Still bug with admin tools. also, is there a way for the seller to change the add to sold?

Gio~Logist 04-09-2006 02:03 AM
Quote:
Originally Posted by nix
Uploaded everything and reinstalled the product-sr_classifieds.xml and the pharse still isnt there.

Still bug with admin tools. also, is there a way for the seller to change the add to sold?
I am going to see if i make the option for the user to close it himself.

As for admin tools, what do you mean?

Gio~Logist 04-09-2006 02:03 AM
Quote:
Originally Posted by KTBleeding
Tried to add a custom field.. ran into this part:



But the field next to that is a drop down.. not a text field. So we can't enter 1,2,3.. we are only able to select one category.
It's only one for the light version.

nix 04-09-2006 02:08 AM
Quote:
Originally Posted by gio~logist
I am going to see if i make the option for the user to close it himself.

As for admin tools, what do you mean?
I don't see the administrative Tools like in your screenshot #3 (in the screenshot folder). I updated the usergroup permissions also. So basicly I cannot edit or delete ads.

Gio~Logist 04-09-2006 02:14 AM
Quote:
Originally Posted by nix
I don't see the administrative Tools like in your screenshot #3 (in the screenshot folder). I updated the usergroup permissions also. So basicly I cannot edit or delete ads.
If you edited the usergroup permissions accordingly or you are the maker of the ad, it should show fine. It's showing on my site.

KTBleeding 04-09-2006 02:29 AM
Quote:
Originally Posted by gio~logist
If you edited the usergroup permissions accordingly or you are the maker of the ad, it should show fine. It's showing on my site.
I can confirm that they are not displaying also.

My permissions are set correctly.

Gio~Logist 04-09-2006 02:30 AM
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:
Code:
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 :p

nix 04-09-2006 02:50 AM
Fixed.

Gio~Logist 04-09-2006 02:50 AM
Quote:
Originally Posted by nix
Fixed.
Sorry about that Nix. I tend to look over little things like this sometimes.

nix 04-09-2006 02:53 AM
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 04-09-2006 02:54 AM
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:
Code:
$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 04-09-2006 02:59 AM
Quote:
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:
Code:
$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 :p

KTBleeding 04-09-2006 03:19 AM
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. :p

EDIT:

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

Gio~Logist 04-09-2006 03:38 AM
Quote:
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. :p

EDIT:

Nevermind. Now it's showing up.. Hm.
lol. It's ok... it's late.. I understand :p

arossphoto 04-09-2006 04:35 AM
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 04-09-2006 04:36 AM
Quote:
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).


All times are GMT. The time now is 05:03 PM.
Page 1 of 13 1 2311 Last »
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01886 seconds
  • Memory Usage 1,871KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (10)bbcode_code_printable
  • (20)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete