Toplist

[loonytune15]

Category system is on my list of things to add. I also plan to add an option that allows you to add a random site to the forum home, note this will be optional and can be turned off in the AdminCP.

Sounds good, both be very good additions. Will serve well as an affiliate hack.

[loonytune15]

ok I have had to run the last 2 queries above and with the last one I got this error.
An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: 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 ';

ALTER TABLE `toplist_sites` ADD `votes` INT( 10 ) DEFAULT

It still wont show any ratings.
in the admin cp under toplist sites, it dont show the ratings either, but when you click to view the individual site, it shows in there.

[derekivey]

Hmm looks like your missing part of the query.

Try this:


ALTER TABLE `toplist_sites` ADD `votes` INT( 10 ) DEFAULT '0' NOT NULL AFTER `rating_total`;

[loonytune15]

nope that didn't work either..
An error occurred while attempting to execute your query. The following information was returned.
error number: 1054
error desc: Unknown column 'rating_total' in 'toplist_sites'
I got that error running that on its own.

I changed the other query and got the first error again.

[derekivey]

Hmm, looks like your missing that field also, run these queries:

ALTER TABLE `toplist_sites` ADD `rating_total` INT( 10 ) DEFAULT '0' NOT NULL AFTER `out`;
ALTER TABLE `toplist_sites` ADD `votes` INT( 10 ) DEFAULT '0' NOT NULL AFTER `rating_total`;
ALTER TABLE `toplist_sites` ADD `rating_average` INT( 10 ) DEFAULT '0' NOT NULL AFTER `votes`;


Sorry for the trouble, not sure why the plugin system didn't execute those queries. Once you run those it should work.

[loonytune15]

I am idiot, I didn't realize that these needed to be run seperately.

All seems to work now except it wont accpt the earlier attempts at voting.

[derekivey]

If you know who voted, and for what site, you can easily add their votes by editing the database..

[Allan]

error:


Database error in vBulletin 3.5.0:

Invalid SQL:
ALTER TABLE `toplist_sites` ADD `rating_total` INT( 10 ) DEFAULT '0' NOT NULL AFTER `out`;;

MySQL Error : Duplicate column name 'rating_total'
Error Number : 1060
Date : Tuesday, December 6th 2005 @ 11:17:47 AM
Script : http://www.xxxxxxx.com/xxxxxx/admincp/plugin.php
Referrer : http://www.xxxxxxx.com/xxxxxx/admincp/plugin.php?do=productadd
IP Address : 82.xxxxx.0.xxxx
Username : xxxxxxxx
Classname : vb_database

[derekivey]

That means you already have that one in the database, just edit the .xml file and remove that query from the install code, and try it again, it should work after you do that.

[Allan]

Invalid SQL:
ALTER TABLE `toplist_sites` ADD `status` VARCHAR( 20 ) DEFAULT 'active' NOT NULL AFTER `out`;;

[Allan]

So i work now, i'm changed manual in database the query

Good, i'm a error, the link which the hack gives us does not work home and to the others also, the page di link is white and reloads ceaselessly

[derekivey]

Huh? What link?

Also,

ALTER TABLE `toplist_sites` ADD `status` VARCHAR( 20 ) DEFAULT 'active' NOT NULL AFTER `out`;;


There are 2 ;'s in that, that is why it didn't work.

[Allan]

this link for example:


<a href="http://www.yoursite.com/forum/in.php?id=1" target="_BLANK">yoursite</a>


don't work, reload, and reload, and reload etc ....

[derekivey]

Did you set your IN Click URL in the AdminCP on the settings page? You need to set it to like your forums url or your main site's url.

[puertoblack2003]

i have one problem i followed instruction in the other post but did not work maybe you can look at this when trying the rating system.




database error in vBulletin 3.5.1:

Invalid SQL:
SELECT * FROM toplist_ratings WHERE site_id='1' && username='xxxxxx;

MySQL Error : Table 'puertotech.toplist_ratings' doesn't exist
Error Number : 1146
Date : Tuesday, December 6th 2005 @ 02:30:00 PM
Script : http://www.xxxxxxxxx/toplist.php?do=rate&id=1
Referrer : http://xxxxxxxx/toplist.php
IP Address : xxx.xxxx.xxxx
Username : love
Classname : vb_database

[Allan]

Did you set your IN Click URL in the AdminCP on the settings page? You need to set it to like your forums url or your main site's url.


So Derekivey, i'm stupid :p, i work !

File Attach: French Language for Version 1.0.4 ;)

[derekivey]

Thanks for Translating it Allan :).

@nievesidenshop:

Manually execute these queries in the AdminCP or PHPMyAdmin, sorry for the inconvenience, for some reason the product system isn't executing them.


CREATE TABLE `YOUR_TABLE_PREFIX_toplist_ratings` (
`id` int(10) NOT NULL auto_increment,
`site_id` int(10) NOT NULL default '0',
`username` varchar(255) NOT NULL default '',
`rating` int(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;

ALTER TABLE `YOUR_TABLE_PREFIX_toplist_sites` ADD `rating_total` INT( 10 ) DEFAULT '0' NOT NULL AFTER `out`;

ALTER TABLE `YOUR_TABLE_PREFIX_toplist_sites` ADD `votes` INT( 10 ) DEFAULT '0' NOT NULL AFTER `rating_total`;

ALTER TABLE `YOUR_TABLE_PREFIX_toplist_sites` ADD `rating_average` INT( 10 ) DEFAULT '0' NOT NULL AFTER `votes`;


Please replace YOUR_TABLE_PREFIX_ with the prefix you use for your tables (if you use one, if not just delete YOUR_TABLE_PREFIX_).

[puertoblack2003]

ok having problems now..trying to uninstalled and reinstalled producted?

uninstalled ok, when trying to reinstall got this error:

Database error in vBulletin 3.5.1:

Invalid SQL:
ALTER TABLE toplist_sites ADD `status` VARCHAR( 20 ) DEFAULT 'active' NOT NULL AFTER `out`;;

MySQL Error : Duplicate column name 'status'
Error Number : 1060
Date : Tuesday, December 6th 2005 @ 03:01:35 PM
Script : http://www.xxx.com/admincp/plugin.php
Referrer : http://www.xxx.com/admincp/plugin.php?do=productadd
IP Address : 1xx.xxx.xxxx.
Username : LOVE
Classname : vb_database

[puertoblack2003]

Thanks for Translating it Allan :).

@nievesidenshop:

Manually execute these queries in the AdminCP or PHPMyAdmin, sorry for the inconvenience, for some reason the product system isn't executing them.


CREATE TABLE `YOUR_TABLE_PREFIX_toplist_ratings` (
`id` int(10) NOT NULL auto_increment,
`site_id` int(10) NOT NULL default '0',
`username` varchar(255) NOT NULL default '',
`rating` int(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;

ALTER TABLE `YOUR_TABLE_PREFIX_toplist_sites` ADD `rating_total` INT( 10 ) DEFAULT '0' NOT NULL AFTER `out`;

ALTER TABLE `YOUR_TABLE_PREFIX_toplist_sites` ADD `votes` INT( 10 ) DEFAULT '0' NOT NULL AFTER `rating_total`;

ALTER TABLE `YOUR_TABLE_PREFIX_toplist_sites` ADD `rating_average` INT( 10 ) DEFAULT '0' NOT NULL AFTER `votes`;


Please replace YOUR_TABLE_PREFIX_ with the prefix you use for your tables (if you use one, if not just delete YOUR_TABLE_PREFIX_).


yea didn't see this message...ok i did run that but it was still giving me an error so i uninstalled it and try to installed it again and the error below ...soory didn't see that..

[derekivey]

Ok, for those of you who had problems with the database, I have uploaded a new zip file. Please try importing the .xml file in it. I had the install code set for version 1.0.3, when it should have been 1.0.4. It should now execute the queries. If anyone still has problems, please let me know.

Thanks,
Derek

[puertoblack2003]

ok wow that was close got it to work.. new product and all working great 1 thing i notice maybe minor to validated site i should receive email which i chose to do never received it.. i'll play around with it ....THANKS FOR YA HELP :rolleyes:

[derekivey]

Ok, I'll take a look and see if I have that problem. I'll get back to you about it.

Derek

[derekivey]

Hmm, I can't reproduce that. Make sure you have 'Email When A New Site Is Added That Requires Validation' set to 'No'.

[Dan]

I've been looking for something like this to switch my old topsites list over to, and I love when things are integrated with vB so thanks ;)

* Dan clicks install

[derekivey]

No Problem.

BTW everyone, I plan to have another release out later this week for more features in my to do list. Depends though if I have lots of school work, if I do, It might get delayed till like next week sometime.

[Snake]

OK the hack has been updated. It's working fine now.

[loonytune15]

thats good news :)

Also can we have a feature added so Admin can add in as many sites as they want please?

[derekivey]

Yeah, I'll add that into the AdminCP. I'm also thinking about having it show who added the site to everyone on the Toplist page.

[loonytune15]

can that be made an option as well the admin can set please?

Is the add-on for the forum home ready to be added as well?

[derekivey]

Yeah I'll have an option for that.

Yes, the forum home addon will be in the next release.

[derekivey]

Hey, did you want something like this? See the attached image below please.

I have the images in a marquee and they are all hyperlinked to the out url for each image...

Thanks,
Derek

[Xtrato]

Thats GREAT!

[Sean James]

Hey, did you want something like this? See the attached image below please.

I have the images in a marquee and they are all hyperlinked to the out url for each image...

Thanks,
Derek

That would be great.

[loonytune15]

that would be nice, hope to see it added in soon.

[derekivey]

Yup, it will be in the next version. I will release the next version as soon as I finish the categories part.

[divided_by_fear]

will this be a on and off feature? cause i personaly dont like scrolling it slows things down with the marquee.... and what was included in the update yesterday anything major

[derekivey]

There was no update yesterday, I just edited my post. Also, yes I have a option in the AdminCP to enable/disable that feature.

[divided_by_fear]

thats cool yeah i dont personally like the marquee plus its no where near html complaint and makes it laggy on site with alot of supporters... cant wait to see your next update though cause its just been getting better and better

[derekivey]

Yeah, this is turning into a pretty nice hack :)

[AWI]

Gracias Amigo, installed on 3.5.2 and so far so good.

[loonytune15]

Can it also be included a section so as we can show our own affiliation buttons for peeps to use?
I have 5 buttons available and I need to go to each site to let them know to use it.

[derekivey]

Yeah I can prolly do that. I'll try and add it in this version also.

[RichieBoy67]

This is awesome but I want it for 3.07!!! :)

Sweet Hack Man!!! Thanks for your hard work..

[loonytune15]

cool then i look forward to the next version being released.

[derekivey]

This is awesome but I want it for 3.07!!! :)

Sweet Hack Man!!! Thanks for your hard work..

I was going to port it to 3.0.x, but had problems, perhaps sometime when I have time I will try porting it again.

[mindfrost82]

After upgrading to the most recent version, I'm having a problem with the links it provides.

If I go to edit a site, they all show the in.php?id=1. The ID number doesn't change.

If I go into the AdminCP, the Site ID is different for each one.

So if the ID in the link always shows as 1, won't the "in" links all get counted towards the site with ID 1?

Is there a way to fix this?

[derekivey]

I suggest you try reimporting the xml file (select yes to overwrite), and perhaps reuploading the php files for the hack. Let me know if that helps at all.

[mindfrost82]

I suggest you try reimporting the xml file (select yes to overwrite), and perhaps reuploading the php files for the hack. Let me know if that helps at all.

Tried that, same result.

[derekivey]

Can you give me a URL to your site so I can take a look? If you don't want to post the URL here, you can PM me it if you want.

Thanks,
Derek

[mindfrost82]

The direct link to the TopList is: http://www.naughtyconfessions.net/toplist.php

It works fine for the out.php links.

If you edit a site and click on the button after you're done editing, the link that appears in the box to link back is wrong, it always shows id=1.

It works fine for new sites that are added...just not the sites I had before the upgrade.

I also get this MySQL error when I try to rate a site:

MySQL Error : Table 'database.toplist_ratings' doesn't exist

[Nova2k]

Hi,

This is my first time install of this hack, when i run the XML file i get the following error.
Database error in vBulletin 3.5.2:

Invalid SQL:

INSERT INTO setting
(varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, product)
VALUES
(
'toplist_enabled',
'toplist_options',
'1',
'1',
'free',
'yesno',
10,
0,
1,
'toplist'
),
(
'disabled_message',
'toplist_options',
'The Toplist is Currently Disabled. Please Come Back Later.',
'The Toplist is Currently Disabled. Please Come Back Later.',
'free',
'textarea',
20,
0,
1,
'toplist'
),
(
'toplist_ranking_method',
'toplist_options',
'0',
'0',
'number',
'<select name=\\\"setting[$setting[varname]]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\r\n<option value=\\\"0\\\" \" . iif($setting[\'value\']==0,\'selected=\"selected\"\') . \">In Hits</option>\r\n<option value=\\\"1\\\" \" . iif($setting[\'value\']==1,\'selected=\"selected\"\') . \">Out Hits</option>\r\n<option value=\\\"2\\\" \" . iif($setting[\'value\']==2,\'selected=\"selected\"\') . \">Rating</option>\r\n</select>',
30,
0,
1,
'toplist'
),
(
'toplist_count_out_from_guests',
'toplist_options',
'0',
'0',
'free',
'yesno',
40,
0,
1,
'toplist'
),
(
'toplist_limit_out_clicks',
'toplist_options',
'1',
'1',
'free',
'yesno',
50,
0,
1,
'toplist'
),
(
'toplist_out_click_limit',
'toplist_options',
'1',
'1',
'free',
'',
60,
0,
1,
'toplist'
),
(
'toplist_limit_in_clicks',
'toplist_options',
'1',
'1',
'free',
'yesno',
70,
0,
1,
'toplist'
),
(
'toplist_in_click_limit',
'toplist_options',
'1',
'1',
'free',
'',
80,
0,
1,
'toplist'
),
(
'toplist_allowed_user_groups',
'toplist_options',
'2,5,6,7',
'2,5,6,7',
'free',
'',
90,
0,
1,
'toplist'
),
(
'toplist_allow_member_edit',
'toplist_options',
'1',
'1',
'free',
'yesno',
100,
0,
1,
'toplist'
),
(
'toplist_allowed_to_moderate',
'toplist_options',
'5,6,7',
'5,6,7',
'free',
'',
110,
0,
1,
'toplist'
),
(
'',
'toplist_options',
'1',
'1',
'free',
'yesno',
120,
0,
1,
'toplist'
),
(
'toplist_open_in_new_window',
'toplist_options',
'1',
'1',
'free',
'yesno',
120,
0,
1,
'toplist'
),
(
'toplist_disable_html',
'toplist_options',
'1',
'1',
'free',
'yesno',
130,
0,
1,
'toplist'
),
(
'toplist_moderate_sites',
'toplist_options',
'0',
'0',
'free',
'yesno',
140,
0,
1,
'toplist'
),
(
'toplist_email_new_validation',
'toplist_options',
'0',
'0',
'free',
'yesno',
150,
0,
1,
'toplist'
),
(
'toplist_email_users',
'toplist_options',
'1',
'1',
'free',
'',
160,
0,
1,
'toplist'
),
(
'toplist_pm_new_validation',
'toplist_options',
'0',
'0',
'free',
'yesno',
170,
0,
1,
'toplist'
),
(
'toplist_pm_from_user',
'toplist_options',
'1',
'1',
'free',
'',
180,
0,
1,
'toplist'
),
(
'toplist_pm_users',
'toplist_options',
'1',
'1',
'free',
'',
190,
0,
1,
'toplist'
),
(
'sites_per_page',
'toplist_options',
'15',
'15',
'free',
'',
200,
0,
1,
'toplist'
),
(
'toplist_in_redirect_url',
'toplist_options',
'',
'',
'free',
'',
210,
0,
1,
'toplist'
),
(
'toplist_number_of_sites',
'toplist_options',
'1',
'1',
'free',
'',
220,
0,
1,
'toplist'
),
(
'toplist_max_height',
'toplist_options',
'31',
'31',
'free',
'',
230,
0,
1,
'toplist'
),
(
'toplist_max_width',
'toplist_options',
'88',
'88',
'free',
'',
240,
0,
1,
'toplist'
),
(
'toplist_popup_height',
'toplist_options',
'220',
'220',
'free',
'',
250,
0,
1,
'toplist'
),
(
'toplist_popup_width',
'toplist_options',
'250',
'250',
'free',
'',
260,
0,
1,
'toplist'
);

MySQL Error : Duplicate entry '' for key 1
Error Number : 1062
Date : Wednesday, December 14th 2005 @ 08:01:19 PM
Script : http://www.robscorner.com/forum/admincp/plugin.php
Referrer : http://www.robscorner.com/forum/admincp/plugin.php?do=productadd
IP Address : *********
Username : ByteDevil
Classname : vb_database

I have checked the database and there is no Topsite tables of any topsite data in the database before the install.

Thanks for this great hack cant wait to get it working.

[derekivey]

@mindfrost82, can you please provide me with a test account also? Thx.
@Nova2k, try uninstalling and reimporting and see if it works.

[Nova2k]

I re-downloaded the package uploaded all the files again and reinstalled package but i'm still getting the same error.

:ermm:

[derekivey]

If you want to PM me admin details, I can take a look, also PHPMyAdmin details would be helpful but it's up to you.

[croportal]

can u please tell me,

example: i go to this toplist and i submit my site, will i get the link code with banner to put on my site.

and users from my site can rate top list

[derekivey]

It gives you HTML code for a link, but you can edit the template and change the code to be HTML code for a banner if you want. For the next release, I plan on implementing a system that lets the user choose what they want... Users can click the link and it redirects them to the toplist or whatever page you specified in the AdminCP, and it counts their "In Hit" towards your site.

Derek

[Yorixz]

I'm wondering, could you also make a little addon for this beautiful hack so templates will be grouped? There are quite a lot of templates so it'll be very nice to have them under a single title :).

[Warrior]

I didn't see it in the screen shots... where does this program give the linking URL to the other site? Or does it count all incoming links referred from their domain automatically? Do they need a unique URL for linking? :confused: Can you please post a screenshot of this?

[croportal]

i also cannot see the screenshot of user get link to put on page

[derekivey]

I'm wondering, could you also make a little addon for this beautiful hack so templates will be grouped? There are quite a lot of templates so it'll be very nice to have them under a single title :).

Already added :). It's in the next release.

I didn't see it in the screen shots... where does this program give the linking URL to the other site? Or does it count all incoming links referred from their domain automatically? Do they need a unique URL for linking? :confused: Can you please post a screenshot of this?

I'll post some screenshots in a few minutes.

[derekivey]

Here is the screenshot:

[croportal]

Here is the screenshot:


that is in this version or..

[derekivey]

The stuff in the screenshot is already in the latest version. I'm talking about the template group stuff in the Style manager, that isn't in this version, it's in the next one which I am releasing in a few days.

[Xtrato]

could you make it to give you a html link that has an image i think people really would like and use that more. I can make an image if you like(for your MOD)?

[derekivey]

Yeah, can you make a few images in different sizes for this? I plan to add this feature in my next version when it's done, just make them in these sizes for now:


88x31
125x125
180x150
Maybe a 468x60 one, not sure though...
Thanks!

[Warrior]

Here is the screenshot:
When they go to edit their account - will it show them their URL again? I mean, what if they don't copy the HTML right after signing up... they will need this linking information available 24/7

[croportal]

Yeah, can you make a few images in different sizes for this? I plan to add this feature in my next version when it's done, just make them in these sizes for now:


88x31
125x125
180x150
Maybe a 468x60 one, not sure though...
Thanks!



this is a great idea, just great,

4 combination of banner to put on web site, just great.

thanks

[Warrior]

This is what I am referring to - they can get the HTML every time they hit to edit the link... see attachment...

Also, can you tell me why the text inputs are not using the CSS format that every other page uses (as well as the text area in the same page for instance) - with the light blue background color...

[derekivey]

This is what I am referring to - they can get the HTML every time they hit to edit the link... see attachment...

Also, can you tell me why the text inputs are not using the CSS format that every other page uses (as well as the text area in the same page for instance) - with the light blue background color...

I'll take a look and fix it. It will be in the next version also.

[derekivey]

By the way all, I just updated my to do list in the first post, ignore how it says Last Update: Today, it says that when the posts gets updated.

[Xtrato]

Yeah, can you make a few images in different sizes for this? I plan to add this feature in my next version when it's done, just make them in these sizes for now:


88x31
125x125
180x150
Maybe a 468x60 one, not sure though...
Thanks!

180x150 is really big but i can make something.

EDIT i added one tell me if its "to much"

[Warrior]

I'll take a look and fix it. It will be in the next version also.
Well... I noticed when you submit to edit a site, the linking information is there... you just have to "edit" to get at it. By plugging it in, like my last post - you end up seeing it twice on the following screen. So I changed it again - now its just a By-The-Way column that shows the URL without HTML... this column would be a nice editable feature via the admincp for messages to affiliates. See attached...

BTW - this is a great product... I have something similar in CGI but this is a better integration...

[Hoffi]

My Members add Banners that are too big. Isn't there an Image-Size-control?

[divided_by_fear]

yeah there is in the admim section... it lets you chose the biggest size you want to allow

[derekivey]

Yup, see Toplist Options in the Toplist Category on the left menu of the AdminCP.

[divided_by_fear]

is there a way to set this up so guest cant see that page until they register? cause they can view /toplist.php with out registering

[derekivey]

Yeah, I'll add an option for that in the next release also.

[divided_by_fear]

thank you

[loonytune15]

One thing I have just noticed, in the random site box, the ranking doesn't change. eg on mine bluepearl is ranked #1 but in the random box it says its ranked only #5.

Another bug to be fixed..

[divided_by_fear]

the rank changes its just not right lol cause i have my site on the ranking lol its saying im 3 and i made sure mine always stays ontop... it will tell me im ranked #3 when im ranked #1...

[divided_by_fear]

ill post a image showing what i mean look at the ranking the top one is on the /toplist.php page


http://img489.imageshack.us/img489/6534/sitetrue6dn.jpg


ok now this one is on my main page on my index


http://img489.imageshack.us/img489/2962/sitemain5ag.jpg


just take a look at the rank thats the only problem i see

edit: i like your header loonytune15

[loonytune15]

yup thats my prob as well.

Thanks bud

[divided_by_fear]

also on the /toplist.php the Random Site on the top the rank is wrong there too

[Rukas]

Has anyone got a vbadvanced module for this that would show the top 5 or so?

[derekivey]

Yup, I fixed that on my site, it will be released in the next version as well, sorry about that.

[divided_by_fear]

ahhh no need to be sorry derekivey it happens just thankful to have a coder that works on there mods and updates them

[derekivey]

Sorry for the delay with this release, I've been having problems with getting it to show the correct rank of the site when you filter by categories. I might just take away the rank temporarily when you filter by categories if I can't get it to work.

[divided_by_fear]

i say take away the rank cause they should be able to tell which is the number 1 site from toplist.php page it shows the rank correct on the bottom but not on the random... that aint really a major thing in my opion.. but i would like to see the categories... that would be a nice feature

[derekivey]

Yeah, I'm thinking about having it not show the rank when you view by a certain category. It shouldnt really be needed.

[divided_by_fear]

hey its your mod no one can tell you what to do... i mean i like the mod the rank dont phase me at all cause it does display correct on the bottom for the main part im goingto remove the rank from mine now and see how it looks it may even look better on the random

[divided_by_fear]

just a idea maybe instead of having the rank there have it show which category its listed in...

[croportal]

hy, when you will release this:

Planned features for a later release:

* Add ability to add Categories [ In Progress ]
* Allow users to upload their images instead of just putting in a URL [ Flagged for a later release (not sure how to do it, yet) ]
* Random Site on FORUMHOME [ In Progress ]
* Add Choice of Multiple Banners, and a link, for them to add to their site. [ Flagged for a later release ]
* Fix a few template bugs [ Done ]
* Fix input fields to have vB CSS [ Done ]
* Fix Random Site Rank Bug [ Done ]
* Make the hack Valid XHTML 1.0 Transitional [ Done ]
* Whatever else is suggested

thanks, this hack is awesome

[derekivey]

No date set, but it should be in a few days. Now that I am off school for Christmas break, I have more time to work on this.

[croportal]

great, i caint wait to be release

[divided_by_fear]

derekivey is to busy helping me with my mods lol joking nah cant waitto see what you have planed looking forward to his excellent work

[loonytune15]

hmm another bug i think i have found.

I have the option enabled that lets the user who submitted a site to be able to edit it, but for some reason they keep getting the following error:
Sorry, You cannot Edit this Site. You Might be Seeing this Error for a Few Reasons:

* This Site Was Not Added by you, and therefore you cannot Edit it.
* The Board Administratior has Chosen to Not Allow Sites to be Edited.

You Should Contact an Administrator to Find Out Why you Cannot Edit this Site.

Any ideas?

[derekivey]

Not sure at the moment, I will have to look into it further and see. I'll get back to you on this.

Derek

[derekivey]

Ok, I have confirmed and fixed that bug. It will be available in the next release.

If you want to fix it now heres what to do:

OPEN delete_site.php

FIND:

$sql = "SELECT * FROM " . TABLE_PREFIX . "toplist_sites WHERE id='".$_GET['id']."'";

REPLACE WITH:

if($_REQUEST['do'] == "delete") {
$sql = "SELECT * FROM " . TABLE_PREFIX . "toplist_sites WHERE id='".$_POST['id']."'";
} else {
$sql = "SELECT * FROM " . TABLE_PREFIX . "toplist_sites WHERE id='".$_GET['id']."'";
}


OPEN edit_site.php

FIND:

$sql = "SELECT * FROM " . TABLE_PREFIX . "toplist_sites WHERE id='".$_GET['id']."'";

REPLACE WITH

if($_REQUEST['do'] == "edit") {
$sql = "SELECT * FROM " . TABLE_PREFIX . "toplist_sites WHERE id='".$_POST['id']."'";
} else {
$sql = "SELECT * FROM " . TABLE_PREFIX . "toplist_sites WHERE id='".$_GET['id']."'";
}

[loonytune15]

awesome thanks

[derekivey]

I am forced to delay the release of this hack. Today my site and all the other sites on the server, including my host's site, got suspended because of a billing issue our host is having. So right now I have no access to my board to work on the hack, so therefore I have to delay the release of it.

Sorry all.

Derek

[divided_by_fear]

ahhh thats sucks hit me up i have space for you :)

[derekivey]

Lol, I hope the server doesn't get wiped. I don't have a backup of the changes I made to the Toplist. Thanks for the offer though divided_by_fear...

[Xtrato]

If you need any hosting for this hack you can always Pm me.

[derekivey]

Thanks for the offers guys. Hopefully this will be taken care of tomorrow. I'm hoping lol.

[loonytune15]

as we all are, hate to see your hard work go to waste..

[derekivey]

Ok guys, good news, my hosting is now back up. There was a small mix up with the billing between my host and the datacenter where he gets the server at. I'm aiming at releasing the new version around Thursday.

Derek

[divided_by_fear]

thats cool good luck with everything cant wait to see whats new

[derekivey]

Change of plans guys, I should have version 1.0.5 out by tomorrow sometime :) because I got a lot of it done tonight.

[divided_by_fear]

hell yeah sweet i cant wait to check it out... what things have change? this way i know which of my codes to copy or not lol cause i edited the code around alot

[derekivey]

All the files except in.php and out.php have changed lol. Also, all of the templates have been changed so I could make them XHTML complient. This version is going to be a pretty major release lol.

[loonytune15]

well i'm looking forward to the release, hope to see it when i come online tommorrow.

[divided_by_fear]

All the files except in.php and out.php have changed lol. Also, all of the templates have been changed so I could make them XHTML complient. This version is going to be a pretty major release lol.


hell yeah ill just copy the work ive done and redo it... i still thing on the part where it gives the code to them you should add the image above that in another table and still have the code under it makes it look so much nicer and they can see what there copying

[derekivey]

Version 1.0.5 Released! Please follow the install.txt file on how to upgrade or install. Let me know if theres any problems.

Derek

[divided_by_fear]

damn lol i just had wrte that lol you must have been typing the same time i was :)

[derekivey]

Here are some more screenshots...

[divided_by_fear]

i needd to see if you could paste the template Toplist i edited mine lol i wanted to basicly start fresh think i should just revert it?

[derekivey]

Yes, you can just revert it.

[divided_by_fear]

allso i see when you edit the site you can chose the Categories but do they show on the page anywhere?

[derekivey]

No, right now you can only select the category through the drop down. I am thinking of showing what category they are in under their name in the Toplist.

[divided_by_fear]

ahh never mind i see it after revert lol

[divided_by_fear]

yeah that would be nice i like it how it is now its very nice i have a custom request lol... i wanted to remove the go button and use a image how and where do i change that?

[derekivey]

You would edit the 'Toplist' template, not sure what code you would use to have it be an image though.

[divided_by_fear]

yeah im going to mess with it now.. its just a matter i think of changing a lil coding around :)

[mindfrost82]

I get a vB database error when I try to edit a site from within the admincp. If you click on edit, it'll bring you the site info fine, then when you click on the button when you're finished I get a db error.

[divided_by_fear]

this is how i changed mie up to change the go to a image

<input type="image" src="disturbed/buttons/lastpost.gif" alt="Select A Category" />

[derekivey]

I get a vB database error when I try to edit a site from within the admincp. If you click on edit, it'll bring you the site info fine, then when you click on the button when you're finished I get a db error.

Whats the error you get?

[divided_by_fear]

hmm i didnt get no error i just edited my site and it said Site Edited Successfully

[derekivey]

Yeah, I don't get it either.

[mindfrost82]

Whats the error you get?

nvalid SQL:
UPDATE toplist_sites SET
name='Forum Topsites',
url='http://www.forumtopsites.com/in.php?site=1109036166',
description='Toplist Site',
image='',
`in`='2',
out='16',
rating_total='',
rating_average='',
votes='',
status='active',
cid='1' WHERE id='6';

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

[derekivey]

Make sure you have rating_total, rating_average, and votes filled in. Thats probably why you are getting that error.

[divided_by_fear]

i think pretty much u have this mode top notch only thing i can think of now lol is maybe add the Categories to the table for each... but other then that there aint much more you can ask for with it lol its working perfect and it has many features... maybe you could tweak my block that i used on my site to have it where people can link you easier on vbadvanced... its basiclly like a php nuke link us block

[derekivey]

I'm planning on adding to the next release the option to add many different images they can put on their site. Also, one of the images will have their rank, in hits, out hits, and rating.

[divided_by_fear]

damn cant wait to see that lol i wonder how that will be done

[divided_by_fear]

found a bug i think when you go to edit a site on the main page(edit_site.php) ok when it gives you the link back to the site so they can get hits its not right... like for example my buddy just asked me for his code again cause i have it where they cant edit them ok and his site id is 14 and its showing 13 and it would give hits for another site then...

here is what i mean this is the code it gives

<a href="http://www.blah.com/in.php?id=13" target="_BLANK"><img src='http://www.blah.com/images/blah.gif' border='0'></a>

when in admin his Site ID is 14 why would that do this?

[derekivey]

I'll take a look and relea e a patch if I can confirm it.

Derek

[derekivey]

Ok, bug fixed. Just upload the attached edit_site.php file and overwrite the old one, and replace the Toplist_HTML_Code template with the following code:

<if condition="THIS_SCRIPT == add_site">
$vbphrase[toplist_add_successful]<br />
<if condition="$vbulletin->options['toplist_moderate_sites'] == 1">
$vbphrase[toplist_sites_moderated]<br />
<else />
$vbphrase[toplist_sites_shown_instantly]<br />
</if>
<else />
$vbphrase[toplist_edit_successful]<br />
</if>
$vbphrase[toplist_html_code_message]:<br />
<if condition="THIS_SCRIPT == add_site">
<textarea cols="40" rows="4"><a href="$vboptions[bburl]/in.php?id=$sr[id]" target="_BLANK">$_POST[sitename]</a></textarea>
<else />
<textarea cols="40" rows="4"><a href="$vboptions[bburl]/in.php?id=$id" target="_BLANK">$_POST[sitename]</a></textarea>
</if>


Let me know if you have any problems. I also updated the zip file attached to the first post for those of you who haven't installed this hack yet.

Derek

[XtremeOffroad]

What an easy Install, Seems to work ok so far, One thing though, Is there any way to change the order of the catagories without rewriting them? I forgot to add one and to place it towards the top I needed to rewrite all the existing cats, Hope that made sense.
BTW Clicks install.

[derekivey]

Not yet, I think I'll add a display order feature to the next version. Sorry about that.

[XtremeOffroad]

Not yet, I think I'll add a display order feature to the next version. Sorry about that.

Fantastic, Other then that This is a GREAT feature I was hoping to find.
Also on the code for members to add how would I change it to say Vote for us or something similar? rather then just my site name.

[derekivey]

Hi, You would just edit the Toplist_HTML_Code template I believe.

EDIT: Yeah, just open that template and change all instances of $_POST[sitename] to Vote for Us! or something.

[XtremeOffroad]

Hi, You would just edit the Toplist_HTML_Code template I believe.

EDIT: Yeah, just open that template and change all instances of $_POST[sitename] to Vote for Us! or something.

I'll give it a shot tomorrow, Thanks.

[loonytune15]

Mate this is working great, Congrats on all your hard work.

Divided, how did you do that vbacmps module? I would like to add something like that into mine aswell..

Also derekivey any chance in the next release we could have at the bottom of the toplist page somethig saying here are our buttons and how to add to the list or something like that?

[derekivey]

Yeah, I'll see about adding that. Can you give me a better example of what you mean?

[loonytune15]

Umm like a box at the bottom of the page in which the admin can add through the admincp any images that the other sites can use for us.

eg this thread has all my buttons in it.
http://www.monster-designs.com/forums/showthread.php?t=1048

So i'd like it to be shown in the toplist area...

On another note has the same error about the rankings been fixed in the toplist random site on the vbacmps been fixed?

[derekivey]

Ok, I'll take a look.

Yes the rankings in the vbacmps module have been fixed.

[loonytune15]

Also can we have an option in the admin cp for adding in sites please?

[derekivey]

Yup, that is going to be in the next release.

[georg1000]

hello,
coud you please help me with the following problem: If I activate the toplist in forumhome, and the users click on one of the banners, the desired hp opens in the same browser window. I would like a new window to open for the new hp.

In the ACP I have activated "open in new window". This works fine in the "toplist site", but not in "forumhome".

Thanks,

Georg

[derekivey]

Hi,

Sorry about that. It's a bug. Heres how to fix it.

Open: Toplist_Sites_Code template

FIND:

<a href="$vboptions[bburl]/out.php?id=$timage[id]">


Replace With:

<a href="$vboptions[bburl]/out.php?id=$timage[id]" target="_BLANK">


Save the template.

Derek

[georg1000]

Thanks a lot.

Georg

[georg1000]

I've got one more problem:

The toplist is generating a wrong code for the users that want to integrate this code into their hp as an html-link

Example: User with the HP: "Die kleinen Teufel von Langenzersdorf" ("the little devils of Langenzersdorf")

this code is being generated:

<a href="http://www.sporthundeforum.at//in.php?id=1" target="_BLANK">Die kleinen Teufel von Langenzersdorf</a>

it should be this one instead:

<a href="http://www.sporthundeforum.at//in.php?id=1" target="_BLANK">1.Österreichisches Sporthundeforum</a>

How could I possibly fix this problem?

thanxx,
Georg

[derekivey]

Thats a bug lol. I had it saying the site name, it should probably be changed to the site with the toplist's name. You can fix it by doing this...

Open: Toplist_HTML_Code

Find & Replace all Instances of:

$_POST[sitename]


With:

$vboptions[bbtitle]


Sorry about that.

Derek

[georg1000]

https://vborg.vbsupport.ru/external/2006/01/10.gif

[loonytune15]

thanks for the forumhome fix, I have updated mine.

[loonytune15]

I have had a request from my members, Can they have it so when they mouseover the maquee of the toplists ites at the bottom of the forum, that it stops?

[derekivey]

Sure, I'll add that.

[loonytune15]

any chance of a fix till the next update is released?

[derekivey]

Sure, I'll take a look and see about releasing one.

[derekivey]

Ok, heres the fix:

OPEN: FORUMHOME

FIND:

<marquee direction="$vboptions[toplist_forumhome_marquee_direction]" width="100%" scrollamount="$vboptions[toplist_forumhome_marquee_scrollamount]">$toplist_images</marquee>


REPLACE WITH:

<marquee direction="$vboptions[toplist_forumhome_marquee_direction]" width="100%" onMouseover="this.scrollAmount=0" onMouseout="this.scrollAmount=$vboptions[toplist_forumhome_marquee_scrollamount]">$toplist_images</marquee>


Let me know if you have any problems.

[derekivey]

Hey guys,

Heres a preview of the new dynamic image feature that shows their rank, in hits, out hits, and rating.

http://www.derek.modbb.com/forums/images/toplist/buttons/dynamic/image.png?id=10

The image it is on is just a test image I made, it will come with the Toplist, you can make your own. It's pretty crappy because I suck at making gfx lol. If anyone wants to make a better one, I will include it in the Toplist instead of mine. That one is 100x100.

Derek

[loonytune15]

thanks for the maquee fix. Drop into my website, one of my designers may be able to help you out with that image.

[foreverdarkness]

Every time i try to do the update and import the new product, i check the allow overwrite but it keeps saying the different sql databases already exist...I have even deleted every part of the toplist from my database and I still get the same errors. Please help!!!

[derekivey]

Can you paste the error for me please?

Thanks.

[foreverdarkness]

Database error in vBulletin 3.5.0:

Invalid SQL:

INSERT INTO vb3_setting
(varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, product)
VALUES
(
'toplist_enabled',
'toplist_options',
'1',
'1',
'free',
'yesno',
10,
0,
1,
'toplist'
),
(
'disabled_message',
'toplist_options',
'The Toplist is Currently Disabled. Please Come Back Later.',
'The Toplist is Currently Disabled. Please Come Back Later.',
'free',
'textarea',
20,
0,
1,
'toplist'
),
(
'toplist_ranking_method',
'toplist_options',
'0',
'0',
'number',
'<select name=\\\"setting[$setting[varname]]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\r\n<option value=\\\"0\\\" \" . iif($setting[\'value\']==0,\'selected=\"selected\"\') . \">In Hits</option>\r\n<option value=\\\"1\\\" \" . iif($setting[\'value\']==1,\'selected=\"selected\"\') . \">Out Hits</option>\r\n<option value=\\\"2\\\" \" . iif($setting[\'value\']==2,\'selected=\"selected\"\') . \">Rating</option>\r\n</select>',
30,
0,
1,
'toplist'
),
(
'toplist_count_out_from_guests',
'toplist_options',
'0',
'0',
'free',
'yesno',
40,
0,
1,
'toplist'
),
(
'toplist_limit_out_clicks',
'toplist_options',
'1',
'1',
'free',
'yesno',
50,
0,
1,
'toplist'
),
(
'toplist_out_click_limit',
'toplist_options',
'1',
'1',
'free',
'',
60,
0,
1,
'toplist'
),
(
'toplist_limit_in_clicks',
'toplist_options',
'1',
'1',
'free',
'yesno',
70,
0,
1,
'toplist'
),
(
'toplist_in_click_limit',
'toplist_options',
'1',
'1',
'free',
'',
80,
0,
1,
'toplist'
),
(
'toplist_allowed_user_groups',
'toplist_options',
'2,5,6,7',
'2,5,6,7',
'free',
'',
90,
0,
1,
'toplist'
),
(
'toplist_allow_member_edit',
'toplist_options',
'1',
'1',
'free',
'yesno',
100,
0,
1,
'toplist'
),
(
'toplist_allowed_to_moderate',
'toplist_options',
'5,6,7',
'5,6,7',
'free',
'',
110,
0,
1,
'toplist'
),
(
'',
'toplist_options',
'1',
'1',
'free',
'yesno',
120,
0,
1,
'toplist'
),
(
'toplist_open_in_new_window',
'toplist_options',
'1',
'1',
'free',
'yesno',
120,
0,
1,
'toplist'
),
(
'toplist_disable_html',
'toplist_options',
'1',
'1',
'free',
'yesno',
130,
0,
1,
'toplist'
),
(
'toplist_moderate_sites',
'toplist_options',
'0',
'0',
'free',
'yesno',
140,
0,
1,
'toplist'
),
(
'toplist_email_new_validation',
'toplist_options',
'0',
'0',
'free',
'yesno',
150,
0,
1,
'toplist'
),
(
'toplist_email_users',
'toplist_options',
'1',
'1',
'free',
'',
160,
0,
1,
'toplist'
),
(
'toplist_pm_new_validation',
'toplist_options',
'0',
'0',
'free',
'yesno',
170,
0,
1,
'toplist'
),
(
'toplist_pm_from_user',
'toplist_options',
'1',
'1',
'free',
'',
180,
0,
1,
'toplist'
),
(
'toplist_pm_users',
'toplist_options',
'1',
'1',
'free',
'',
190,
0,
1,
'toplist'
),
(
'sites_per_page',
'toplist_options',
'15',
'15',
'free',
'',
200,
0,
1,
'toplist'
),
(
'toplist_in_redirect_url',
'toplist_options',
'',
'',
'free',
'',
210,
0,
1,
'toplist'
),
(
'toplist_number_of_sites',
'toplist_options',
'1',
'1',
'free',
'',
220,
0,
1,
'toplist'
),
(
'toplist_max_height',
'toplist_options',
'31',
'31',
'free',
'',
230,
0,
1,
'toplist'
),
(
'toplist_max_width',
'toplist_options',
'88',
'88',
'free',
'',
240,
0,
1,
'toplist'
),
(
'toplist_popup_height',
'toplist_options',
'220',
'220',
'free',
'',
250,
0,
1,
'toplist'
),
(
'toplist_popup_width',
'toplist_options',
'250',
'250',
'free',
'',
260,
0,
1,
'toplist'
),
(
'toplist_show_forumhome_images',
'toplist_options',
'0',
'0',
'free',
'yesno',
270,
0,
1,
'toplist'
),
(
'toplist_forumhome_marquee_direction',
'toplist_options',
'left',
'left',
'free',
'',
280,
0,
1,
'toplist'
),
(
'toplist_forumhome_marquee_scrollamount',
'toplist_options',
'5',
'5',
'free',
'',
290,
0,
1,
'toplist'
),
(
'toplist_forumhome_number_of_images',
'toplist_options',
'0',
'0',
'free',
'',
300,
0,
1,
'toplist'
);

MySQL Error : Duplicate entry '' for key 1
Error Number : 1062
Date : Sunday, January 8th 2006 @ 03:45:03 PM

This is the error I get when importing the product and selecting to overwrite the existing one.

In my admin panel everything is there except toplist options...and on the toplist.php there is no place to add a site to it.

[derekivey]

Hi,

Can you PM me admin access details, and PHPMyAdmin info please so I can take a look?

Thanks,
Derek

[foreverdarkness]

I got that error fixed that i post i now have a different error. It is when i try to go to the toplist.php page. It works fine when its disabled but when enabled i get this error.


At the top of the page it says
Warning: Division by zero in /toplist.php on line 146

Warning: Division by zero in /includes/functions.php on line 1809

then

Database error in vBulletin 3.5.0:

Invalid SQL:
SELECT * FROM vb3_toplist_sites WHERE status='active' ORDER BY `in` DESC LIMIT 0,;

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 '' at line 1
Error Number : 1064
Date : Sunday, January 8th 2006 @ 08:39:35 PM
Script : http://www.foreverdarkness.com/forum/toplist.php

[derekivey]

Check to make sure sites per page in the Toplist options isn't set to 0.

[foreverdarkness]

Check to make sure sites per page in the Toplist options isn't set to 0.

I dont see where that is located...it is not in my toplist options and I also searched it in my database and could not find it. Please help.

[derekivey]

Should be at http://www.yourdomain.com/forums/admincp/options.php?do=options&dogroup=toplist_options

Try finding Sites Per Page on that page. If it's not there, you need to reimport the xml file because your settings must be missing then.

[foreverdarkness]

Actually there was an error in the xlp product file...duplicate part at the end.

<setting varname="" displayorder="120">
<datatype>free</datatype>
<optioncode>yesno</optioncode>
<defaultvalue>1</defaultvalue>
</setting>
<setting varname="toplist_open_in_new_window" displayorder="120">
<datatype>free</datatype>
<optioncode>yesno</optioncode>
<defaultvalue>1</defaultvalue>

cause the error i originally had up top.

[derekivey]

Thanks for pointing that out. Zip file has been updated.

[foreverdarkness]

Thanks for pointing that out. Zip file has been updated.

You are very welcome...For a while there i thought i was going nuts...but then i noticed that. I was like duh...i saw it like 10 times before i realized it.

[derekivey]

Now I gotta find out why it's exporting an extra setting lol.

[CSS59]

subscribed

[BigSoccer Tech.]

subscribed

it seems the in and out.php file hits are very slow with a big lag. what can be done to speed them up?

[uzman59]

i want to ask something how can i add image ???

[derekivey]

it seems the in and out.php file hits are very slow with a big lag. what can be done to speed them up?
They shouldn't be lagging. Can you post or PM the url to your forum so I can take a look?

i want to ask something how can i add image ???
What kind of image? Like an image that they can use to put on their site to advertise your Toplist?

[BigSoccer Tech.]

They shouldn't be lagging. Can you post or PM the url to your forum so I can take a look?



http://www.bigsoccer.com/forum/toplist.php

[2fast4ya]

Okay, I'm having a major issue with this hack, maybe it's me... maybe others haven't taken the time to notice it...

When people submit there site, it gives them a link for them to my site, for them to put on theres... but ... one, the link doesn't work... and two, the title of the link is THERE site....

ive made images to show you what i mean, becaus ei know what im saying sounds confusing...

take a look

http://www.chowcow.com/one.jpg


They are submitting vegasimports.com on my forum... everything goes smooth here... but take a look at the next image.
--------



http://www.chowcow.com/two.jpg

As you can see on the second image... the code says the text is "VegasImports.com" -- well, why would they link to my site on their site... but leave the text vegasimports?? that makes no sense. and something else is wrong w/ the code, because the link DOES NOT work.

please help me. thank you.

[2fast4ya]

okay... i fixed the reason why there site name was being posted instead of my own...

i went into the tempelate manager, and edited the tempelate - Toplist_HTML_Code - i changed:

$vbphrase[toplist_html_code_message]:<br />
<textarea cols="40" rows="4"><a href="$vboptions[bburl]/in.php?id=$sr[id]" target="_BLANK">$_POST[sitename]</a></textarea>

to

$vbphrase[toplist_html_code_message]:<br />
<textarea cols="40" rows="4"><a href="$vboptions[bburl]/in.php?id=$sr[id]" target="_BLANK">my site's name here</a></textarea>

now... the link still doesnt work, but displays correctly... if you cut and copy this:

http://www.chowcow.com/forum/in.php?id=2

which is what was created in order to keep track the ID... it doesn't work.. it just keeps refreshing the page...

whats wrong here guys?

[derekivey]

http://www.bigsoccer.com/forum/toplist.php

Hi,

It looks like it appears to be lagging because your server seems kind of slow to me. That might be why this is happening. I tried on my public and test site and it doesn't appear to be lagging for me.


okay... i fixed the reason why there site name was being posted instead of my own...

i went into the tempelate manager, and edited the tempelate - Toplist_HTML_Code - i changed:

$vbphrase[toplist_html_code_message]:<br />
<textarea cols="40" rows="4"><a href="$vboptions[bburl]/in.php?id=$sr[id]" target="_BLANK">$_POST[sitename]</a></textarea>

to

$vbphrase[toplist_html_code_message]:<br />
<textarea cols="40" rows="4"><a href="$vboptions[bburl]/in.php?id=$sr[id]" target="_BLANK">my site's name here</a></textarea>

now... the link still doesnt work, but displays correctly... if you cut and copy this:

http://www.chowcow.com/forum/in.php?id=2 (http://www.chowcow.com/forum/in.php?id=2)

which is what was created in order to keep track the ID... it doesn't work.. it just keeps refreshing the page...

whats wrong here guys?
Did you set the IN hit url in Toplist options, in the AdminCP?

[Sean James]

Just updated to the latest version of this script and everything is working fine, except on the toplist page the random site tables does not show the button.

http://www.bluepearl-design.com/forums/toplist.php

[Gayble]

Installed. Love it! :)

[2fast4ya]

Did you set the IN hit url in Toplist options, in the AdminCP?

ahhh a simple solution... i feel so stupid. thank you sir

[derekivey]

Just updated to the latest version of this script and everything is working fine, except on the toplist page the random site tables does not show the button.

http://www.bluepearl-design.com/forums/toplist.php
Did you modify any of the Toplist templates? If so, try reverting the 'Toplist' one and see if that works. If not, please try using it on the default vB style and see if it works on that.

Installed. Love it! :)
Click install please. Thanks :).

ahhh a simple solution... i feel so stupid. thank you sir
No Problem :).

[derekivey]

My Midterms at school are now over. I should have more time to work on this and hopefully get version 1.0.6 released in a few days :). I plan on also adding the feature that lets them upload buttons so they don't have to link to them.

[Allan]

I would translate this version 1.0.6 ;)

[derekivey]

Thanks Allan. It should be released within a few days.

[tasarimdunyasi]

hi derekivey,

I congratulate to you. Very good job! I'm waiting for new version..

[Twigz]

Hi,
Great hack, Just one problem I am noticing. When One of my Members try to submit there site info, they com to a blank white Page and then either have to hit the Back button use the url to get back to the forums.. Everything else is working great with it. any suggestions?

-Twigz *Click's Install*

[derekivey]

Make sure the templates were added to your skin(s). If you want me to look at it, please PM the url of your site and admin details so I can check it out for you.

Derek

[derekivey]

Also just so everyone knows my progress of version 1.0.6, I am pretty much done, I just have to finish adding the image hosting feature. vB's Product installer will automatically copy all of the current site images to your server and leave the image link in the database in case this needs to be redone.

[Twigz]

Also just so everyone knows my progress of version 1.0.6, I am pretty much done, I just have to finish adding the image hosting feature. vB's Product installer will automatically copy all of the current site images to your server and leave the image link in the database in case this needs to be redone.

Pm sent!
Thanks ..

[derekivey]

Yup, just got it. Looking into the problem right now for you.

Derek

[derekivey]

Hi, I just tried adding a site and it added fine. Does it work for you?

[Twigz]

Hi, I just tried adding a site and it added fine. Does it work for you?

Yes, seems to be working fine Now.. Thank you for whatever you did..
Great hack & Support.

-Twigz

[derekivey]

Yes, seems to be working fine Now.. Thank you for whatever you did..
Great hack & Support.

-Twigz

No Problem, I didn't do anything lol.

[derekivey]

Ok, This hack should be released by tomorrow (Sunday), I just have to add a AdminCP page to manage the uploaded images and stuff. The rest is complete.

Derek

[derekivey]

Version 1.0.6 has been released. Please see the first post for the changes in this one. Follow the readme file carefully to install or upgrade.

[derekivey]

HOW TO: Editing the Dynamic Image

You may be wondering how you edit the included Dynamic image in this hack. Here is a simple how to, to do it.

OPEN: images/toplist/buttons/dynamic/image.png

FIND:
chdir('/home/derek/public_html/vbtest');

You need to change '/home/derek/public_html/vbtest' to the path to your forum. Make sure it looks like that though.

Next, if you want to change the background image, simply make a png image and overwrite background.png with it.

If you want to change the color of the text in the dynamic image, you would edit this line:
$color = imagecolorallocate($image, 0, 0, 255);

0, 0, 255 are the RGB values for the colors. You need to change them to the color you want, the current one is blue.

Now scroll to the bottom until you find a line like this:
imagestring($image, $font, 44, 28, $rank, $color);

For each of those lines, you will need to change the 2 numbers so that each each thing is aligned with the right part of the image. See my included dynamic image as an example. The first number is the x value, and the second one is the y value.

I hope this little how to helps you edit your image better, sorry if it's kind of confusing.

Derek

[Allan]

This version is stable for translate ?

[derekivey]

Yes, I have tested it thoroughly before I released it.

[loonytune15]

good good, uploading now :D

ok a couple of probs.

First i got some error messages when importing the new product file, did it again but didn't get the message again so i couldn't copy it.

Also the topsites are no longer showing in the forumhome. I have the setting enabled to allow it on the forumhome.

I also am having probs with the images and the fact they are no longer there, some of the ones have saved but others have lost the paths to them. I tried uploading the site images but it wont work either.

Also their is no option to have a remote linked image.

[am-fs]

Great Job...........Derekivey :up:

I am haveing a slight problem

I used 468x60 banners and now you have added the button option only.

Is there any way to get it back the option to put the banner under the site title?
I know you recommend smaller images but i dont really want to use the button option. THe banners make it easy to surf the sites.....IMO

Another thing, is there away to remove a vote from a member with out editing the Total Ratings & Average?

I have a member that likes to play jokes and went around and gave some site negitive votes, even tho i corrected it on the Total Rating & Average, its not tallying it up right.

EXP. site had 4 (5 star votes) and 1 ( 3 star) , i remove the 3 star vote and any site that just has 1 vote is rated higher.

Again, thanks for this wonderful hack :)

[derekivey]

Wehn you installed the product it should have ran some code that copied the images over to your server. Are you guys sure it didn't do that?

[klaush]

Wehn you installed the product it should have ran some code that copied the images over to your server. Are you guys sure it didn't do that?

Yes, sure.

I noticed another problem, when trying to fix the missing banners. I can?t upload them to the default directory, even if the permissions are given to upload gif, jpeg and png.

Any idea, derekivey?

[SpiderFive]

The images are on the server , but some of them will not show in the toplist

[derekivey]

Ok, those of you who are having problems with the random site addon showing up on the forum home, open the FORUMHOME template and find:

<if condition="$show['birthdays']">

Right above it add:

<!-- Toplist -->

That should fix it.

For those of you having problems with images not showing up can you please give me the url to your site so that I may take a look?

@am-fs that is currently not a feature. When you fix the total rating, you will need to subtract 1 from the total votes. You should be able to do this when you edit the site.

Thanks,
Derek

[derekivey]

I have fixed the problem some of you have been having with images not showing up. Please upload the attached toplist_image.php file and be sure to overwrite the old one.

I am also uploading a new zip file with this fix in it, in the first post.

Let me know if you have any problems.

Thanks,
Derek

[klaush]

Sorry, here is my problem not solved:

Sorry, your image could not be uploaded because the format of it is not allowed. Allowed formats are GIF, JPEG, and PNG

The format of the file you uploaded is image/jpeg.

Please go back and select a new image or leave the image field blank.Site Edited Successfully.

The image is o.k., so what could be the reason?

Thanks for your fast help!

[SpiderFive]

I have fixed the problem some of you have been having with images not showing up. Please upload the attached toplist_image.php file and be sure to overwrite the old one.

I am also uploading a new zip file with this fix in it, in the first post.

Let me know if you have any problems.

Thanks,
Derek
Thanks

[derekivey]

Sorry, here is my problem not solved:

Sorry, your image could not be uploaded because the format of it is not allowed. Allowed formats are GIF, JPEG, and PNG

The format of the file you uploaded is image/jpeg.

Please go back and select a new image or leave the image field blank.Site Edited Successfully.

The image is o.k., so what could be the reason?

Thanks for your fast help!

Hi,

I'll take a look for you and get back to you on this.

Derek

[derekivey]

Ok, Open add_site.php, edit_site.php, and toplist_admin.php (2 instances), and find a line like this:

if ($image_type == "image/gif" OR $image_type == "image/pjpeg" OR $image_type == "image/x-png")

Replace it with:

if ($image_type == "image/gif" OR $image_type == "image/pjpeg" OR $image_type == "image/jpeg" OR $image_type == "image/x-png")


Let me know if you have anymore problems. I will be updating the zip file in the first post also for this.

Derek

[klaush]

Ok, Open add_site.php, edit_site.php, and toplist_admin.php (2 instances), and find a line like this:

if ($image_type == "image/gif" OR $image_type == "image/pjpeg" OR $image_type == "image/x-png")

Replace it with:

if ($image_type == "image/gif" OR $image_type == "image/pjpeg" OR $image_type == "image/jpeg" OR $image_type == "image/x-png")


Let me know if you have anymore problems. I will be updating the zip file in the first post also for this.

Derek

YEP, that did it!:-)

Thanks a lot!

[derekivey]

Your welcome :). Thank You for reporting that!

[loonytune15]

Ok, those of you who are having problems with the random site addon showing up on the forum home, open the FORUMHOME template and find:

<if condition="$show['birthdays']">

Right above it add:

<!-- Toplist -->

That should fix it.
Derek

Has this been fixed in the product?

[derekivey]

Nothing needs to be changed on the product. All you have to do is edit the FORUMHOME template (which comes w/ vBulletin), and it will show up.

Derek

[yayvb]

Awesome Hack!!!!

[tasarimdunyasi]

So i work now, i'm changed manual in database the query

Good, i'm a error, the link which the hack gives us does not work home and to the others also, the page di link is white and reloads ceaselessly


how change manual? I living this problem now and ı don't know how change..

please help me?

[derekivey]

What? Everything is fixed in the latest version. Can you please clarify?

Thanks,
Derek

[puertoblack2003]

What? Everything is fixed in the latest version. Can you please clarify?

Thanks,
Derek

lol.. :rolleyes: .he's talking about error message whe you upload button to site i have that as well whe i get online to site i'll post it up i have to hurray cause after error it redirect back to page..only that happens when uploading button from file folder on the pc.... :ermm:

[derekivey]

Ok, please post the error for me then and I will get it fixed.

Thanks,
Derek

[ChrisBaktis]

I have edited the templates a little to fit my site but I was wondering how I can eliminate the Button...I took out the option of uploading one by just removing that option in the Add A Site emplate - how can I remove that column so when a user looks at the Top List the red X doesnt show....

Any Help?

[ChrisBaktis]

figured it out.

[derekivey]

Ok, Glad you figured it out. Just make sure to backup your changes when you upgrade to later versions, because most of the time the templates change between versions.

Derek

[hohleweg]

hi
i have install the hack and its great
BUT
look <a href="http://www.buggy125.de/forum/in.php?id=1" target="_BLANK">Mein Hobby der Buggy!</a>

and / or
http://www.buggy125.de/forum/in.php?id=1

i came in continuous loop :-(

why?
greet jo

[MoveOver.cc]

Firstly excellent idea and sorry if this question has already been asked.

I have uploaded all the files as per in the instructions etc etc.

When I click on toplist from the home page then either click on "edit site" "delete site", "rate site" or click the link for the site, it either tells me the page cannot be found or the screen is shown for about half a second then you dont see it.

Any help please as I am pretty new to this.

[derekivey]

hi
i have install the hack and its great
BUT
look

and / or


i came in continuous loop :-(

why?
greet jo

You did not set the IN url in the Toplist Settings, in the AdminCP. Please do so, and it should work.

Firstly excellent idea and sorry if this question has already been asked.

I have uploaded all the files as per in the instructions etc etc.

When I click on toplist from the home page then either click on "edit site" "delete site", "rate site" or click the link for the site, it either tells me the page cannot be found or the screen is shown for about half a second then you dont see it.

Any help please as I am pretty new to this.
Can you PM me the url to your forum so I can see?

Thanks,
Derek

[puertoblack2003]

hey i updated the hack to newer version but was having problem when you upload files from picture folder and was giving me error message..but what i did was i revert everything back to version 5 since that version i had no problems everything looks good but when i edited certain things to the toplist site this is the error message i was getting...

MySQL Error : Unknown column 'rating_total' in 'field list'
Error Number : 1054
Date : Saturday, February 4th 2006 @ 04:26:09 PM
Script : http://www.xxxxxxx.com/admincp/toplist_admin.php
Referrer : http://www.puertotech.com/admincp/toplist_admin.php?do=edit&id=1
IP Address : xxxx.xxxx.xxxx.xxx
Username : puertoblack2003
Classname : vb_database

can you help please

[puertoblack2003]

hey i updated the hack to newer version but was having problem when you upload files from picture folder and was giving me error message..but what i did was i revert everything back to version 5 since that version i had no problems everything looks good but when i edited certain things to the toplist site this is the error message i was getting...

MySQL Error : Unknown column 'rating_total' in 'field list'
Error Number : 1054
Date : Saturday, February 4th 2006 @ 04:26:09 PM
Script : http://www.xxxxxxx.com/admincp/toplist_admin.php
Referrer : http://www.puertotech.com/admincp/toplist_admin.php?do=edit&id=1
IP Address : xxxx.xxxx.xxxx.xxx
Username : puertoblack2003
Classname : vb_database

can you help please



edited:...lol...nevermind after reading through this book :rolleyes: i found the problem and was resolved....i executed queries in page 16 verse 234 :rolleyes: thanks

[derekivey]

Ok, No problem, glad you got it working. Also do you remember what kind of errors it gave you when you tried uploading the images?

[puertoblack2003]

Ok, No problem, glad you got it working. Also do you remember what kind of errors it gave you when you tried uploading the images?

sorry D, i think i spoke to soon..but was to tired last night and had to give this a break...as far as the error message can't find my text files because i normally save the error .some how i didn't save it ,it was just when u upload a pic file from home pc file to server it was then giving me the error message that i was unable to upload....now back to the error for the rating..on page 16 verse 234 i followed the instruction to run queries..i ran the queries but when i want to rated a site i get that same error ..i'm stuck what else do you want me to look at.
Database error in vBulletin 3.5.1:

Invalid SQL:
SELECT * FROM toplist_ratings WHERE site_id='1' && username='puertoblack2003';

MySQL Error : Table 'puertotech.toplist_ratings' doesn't exist
Error Number : 1146
Date : Sunday, February 5th 2006 @ 08:56:52 AM
Script : http://www.loveforlife.com/toplist.php?do=rate&id=1
Referrer :
IP Address : xxxxx.xxxx.xxx
Username : xxxxxxxxxxxxx
Classname : vb_database

believe me i was read through the hole thread here.. :ermm:

comment: also i ran the queries and seem to be in there i double checked everything just waiting for you i'm stuck :ermm:

[derekivey]

For some reason it looks like the SQL table for the ratings didn't get created. Try executing this code in PHPMyAdmin, or vB's query page in the AdminCP.


CREATE TABLE `toplist_ratings` (
`id` int(10) NOT NULL auto_increment,
`site_id` int(10) NOT NULL default '0',
`username` varchar(255) NOT NULL default '',
`rating` int(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;


Also if you have a table prefix, be sure to add that to the table name also.

Derek

[forumsoup.com]

Just wondering, because I really don't know. Why would a site have a toplist?

[puertoblack2003]

For some reason it looks like the SQL table for the ratings didn't get created. Try executing this code in PHPMyAdmin, or vB's query page in the AdminCP.


CREATE TABLE `toplist_ratings` (
`id` int(10) NOT NULL auto_increment,
`site_id` int(10) NOT NULL default '0',
`username` varchar(255) NOT NULL default '',
`rating` int(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;


Also if you have a table prefix, be sure to add that to the table name also.

Derek



got to love u man...lol... :rolleyes: it worked know i have to figure out how to resolve the new version....error message will keep you informed

[derekivey]

Just wondering, because I really don't know. Why would a site have a toplist?

They are mainly used to let users post their site and help get traffic to the different sites. Also at the same time they put a link on their site to your and it counts the hits in.

got to love u man...lol... :rolleyes: it worked know i have to figure out how to resolve the new version....error message will keep you informed

Ok, please let me know if you see the error again.

Thanks,
Derek

[tasarimdunyasi]

hi,

first:

when i delete a site using admin panel, i see that message:

Warning: unlink(/**************public_html/images/toplist/buttons/sites/forumbit_14): No such file or directory in /*****cp/toplist_admin.php on line 646
deleting succesfull..


second:

when I'm adding a new site, toplist looks like that althoug i don't use a picture. why it try to screen image although i use blank: http://img291.imageshack.us/img291/7020/example7px.jpg

sorry for my english. :(

thanks

[Guest210212002]

Installed and working almost perfectly. Couple of questions:

- Where do I edit/add the missing image in the attached pic?

- How do I set the allowed image types? I made the edits to the files in post 463, but it still wants "JPEG" instead of "JPG".

Thanks!

[derekivey]

hi,

first:

when i delete a site using admin panel, i see that message:

Warning: unlink(/**************public_html/images/toplist/buttons/sites/forumbit_14): No such file or directory in /*****cp/toplist_admin.php on line 646
deleting succesfull..


second:

when I'm adding a new site, toplist looks like that althoug i don't use a picture. why it try to screen image although i use blank: http://img291.imageshack.us/img291/7020/example7px.jpg

sorry for my english. :(

thanks

Just ignore the error, that just means the file isn't there. I will make it not show the error in the next release.

Also can you PM me the url to your forum and a test account so that I can try the 2nd thing? It shouldn't be showing anything if you leave the image field blank.

Installed and working almost perfectly. Couple of questions:

- Where do I edit/add the missing image in the attached pic?

- How do I set the allowed image types? I made the edits to the files in post 463, but it still wants "JPEG" instead of "JPG".

Thanks!

For the image to show, you need to edit the images/toplist/buttons/dynamic/image.png file in a text editor such as notepad. You need to change the path from what I have to your path. See this post (https://vborg.vbsupport.ru/showpost.php?p=885450&postcount=450) for more info.

For your second question, did you add $image_type == "image/jpg" to the if statement?

Derek

[Guest210212002]

Thanks for the quick reply Derek. Got the broken image sorted out, thanks very much. :D

For the JPEG problem, I don't want ".jpeg" at all, so I changed all the instances listed from ' OR $image_type == "image/jpeg"' to OR $image_type == "image/jpg". I assume that should have worked as well, no?

[derekivey]

Wait, so you are saying you are removing .jpeg as well as .jpg? If so removing those should do the trick.

I'm kind of confused, sorry.

Derek

[Guest210212002]

I'm trying to disallow "jpeg" and allow "jpg". ;)


Sorry, your image could not be uploaded because the format of it is not allowed. Allowed formats are GIF, JPEG, and PNG

The format of the file you uploaded is .

Please go back and select a new image or leave the image field blank.



It's odd that it's not even recognizing the file format.

From add_site:

if ($image_type == "image/gif" OR $image_type == "image/pjpeg" OR $image_type == "image/jpeg" OR $image_type == "image/x-png")
{
$length = 20;
$key_chars = 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVW XYZ0123456789';
$rand_max = strlen($key_chars) - 1;


Edit_site:


if ($image_type == "image/gif" OR $image_type == "image/pjpeg" OR $image_type == "image/jpeg" OR $image_type == "image/x-png")
{
$length = 20;
$key_chars = 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVW XYZ0123456789';
$rand_max = strlen($key_chars) - 1;


Admin:


if ($image_type == "image/gif" OR $image_type == "image/pjpeg" OR $image_type == "image/jpeg" OR $image_type == "image/x-png")
{
$length = 20;
$key_chars = 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVW XYZ0123456789';
$rand_max = strlen($key_chars) - 1;

for ($i = 0; $i < $length; $i++)


And


if ($image_type == "image/gif" OR $image_type == "image/pjpeg" OR $image_type == "image/jpeg" OR $image_type == "image/x-png")
{
$length = 20;
$key_chars = 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVW XYZ0123456789';
$rand_max = strlen($key_chars) - 1;


Is it possible to just remove the check altogether?

[derekivey]

Yeah, just remove the following code in each file:

if ($image_type == "image/gif" OR $image_type == "image/pjpeg" OR $image_type == "image/jpeg" OR $image_type == "image/x-png")
{

and this part... it looks a little different in each file so you may have to search a little for it.

else
{
$vbphrase['toplist_incorrect_image_format'] = str_replace('[1]', $image_type, $vbphrase['toplist_incorrect_image_format']);
$html = $vbphrase['toplist_incorrect_image_format'];
eval('print_output("' . fetch_template('Toplist_Add_Site') . '");');
}


That should remove the check, make sure to backup the files first in case anything goes wrong.

Derek

[Guest210212002]

But my code looks correct otherwise, eh? :\

I do like the check, just not sure why it isn't working.

Btw, making those edits hoses the page. It kills the if loop.

[Guest210212002]

Well, I got it half working. I added:

OR $image_ext = ".jpg" to the statement.

If I add a site, it accepts the image, but the image shows up as a red X. If I edit that same site and readd the same image, it works. I'm looking at the loop for add and edit, and they look identical.

/me scratches his head

[derekivey]

Can you paste me the if statement that you have?

[Guest210212002]

if ($image_type == "image/gif" OR $image_type == "image/pjpeg" OR $image_type == "image/jpeg" OR $image_type == "image/x-png" OR $image_ext == ".jpg" OR $image_type == "image/jpg")

[derekivey]

Try this:

if ($image_type == "image/gif" OR $image_type == "image/x-png" OR $image_type == "image/jpg")


Derek

[yayvb]

Recently my users have been asking questions regarding their anonymity as far as IP addresses are concerned. I've taken several precautions against ip's being logged, but now someone wants to know what keeps track of things coming in and out if IPs aren't logged. Are they being logged somewhere? haha, if so probably can't really disable that, and wouldn't want to i guess for incoming to the site atleast. :(

My next step is to see if phpadsnew logs ip addresses, I'm sure my cpanel stat software does too.

[derekivey]

Hi,

The IP Addresses are stored in the toplist_clicks table. Thats basically the only way to keep track of who clicked in. They are only stored there for In clicks, not out clicks. I don't see why your users would care though because even your web server logs all ip addresses that go to your site...

Derek