vb.org Archive - Toplist

Page 18 of 40

« First

Last »

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)

- - Toplist (https://vborg.vbsupport.ru/showthread.php?t=98646)

chriszep

04-25-2006 08:38 AM

hello when I upload product-toplist.xml

i have this

Quote:

atabase error in vBulletin 3.5.3:

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, April 25th 2006 @ 11:36:24 AM
Script : http://www.xxxxxxxxxxxxxx.com/forums/admincp/plugin.php
Referrer : http://www.xxxxxxxxxxxxxx.com/forums...?do=productadd
IP Address : xxxxxxxxxxxxxxxxxxx
Username : xxxxxxxxxxxxxxxxxxxxxxxx
Classname : vb_database

Thanks

derekivey

04-25-2006 09:49 AM

Try removing that query from the install code in the XML file and try reimporting it again, or if there are no sites on your toplist yet, you can drop all of the toplist_* tables and reimport.

Derek

Ramsesx

04-25-2006 11:36 AM

Quote:

Originally Posted by derekivey

Are you running the latest version (1.0.7) of my hack? It looks like you are missing the views field. If you are not upgraded yet, please upgrade, but if you did, just execute this query in vB's admincp or PHPMyAdmin.
[sql]ALTER TABLE `vb3_toplist_sites` ADD `views` INT( 25 ) UNSIGNED NOT NULL;[/sql]

Derek

Sorry, you're right I don't have the latest version.
One wish for a next version, could you make an option for disabling the rating system because I have some user rating the concurrent sites bad.
Thank you

derekivey

04-25-2006 06:49 PM

Sure, I will add that option. I might also add a banning option.

Derek

cat4m

04-26-2006 01:14 AM

I keep getting this error when I try to add an image to the site :
Warning: getimagesize(/home/lovespir/public_html/loveforum/images/toplist/buttons/sites/trcv75d4FUtp179je4ne): failed to open stream: No such file or directory in /admincp/toplist_admin.php on line 393
Can anyone help at all. I have been looking through the thread but cant find anything that works. Thanks in advance.

derekivey

04-26-2006 09:53 AM

Make sure the /images/toplist/buttons/sites folder exists and is writable (chmod 777).

chriszep

04-27-2006 09:08 AM

Quote:

Originally Posted by derekivey

Try removing that query from the install code in the XML file and try reimporting it again, or if there are no sites on your toplist yet, you can drop all of the toplist_* tables and reimport.

Derek

ok I made it but another error with duplicate

Quote:

Database error in vBulletin 3.5.3:

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 : Thursday, April 27th 2006 @ 12:07:11 PM
Script : http://xxxxxxxxxxxxxxx/forums/admincp/plugin.php
Referrer : http://xxxxxxxxxxxxxxxxxxxx/forums/a...?do=productadd
IP Address : xxxxx
Username : Cxxxx
Classname : vb_database

how to uninstall everything in the data base ?

derekivey

04-27-2006 10:05 AM

You have to use PHPMyAdmin to remove all the toplist_* tables, and there is a field in the usergrouppermissions table.

Derek

cat4m

04-28-2006 04:48 PM

Quote:

Originally Posted by derekivey

Make sure the /images/toplist/buttons/sites folder exists and is writable (chmod 777).

How do I make it writable ? And what is chmod 777 ? Sorry I dont know much about this. Everything else is working but the image picture.

derekivey

04-28-2006 06:41 PM

There should be a feature in your FTP program to let you give it write permissions. If you can't find it talk to your webhosting provider. They should be able to help you out.

Derek

cat4m

04-29-2006 12:16 PM

I will try to sort it out myself because my host takes about 2 weeks to reply to any of my queries. I dont know anything about ftp programs but i will see what I can find in the cpanel.

derekivey

04-29-2006 12:53 PM

cPanel's file manager lets you change the permissions also. Just click on the files, and then in the right frame there should be a link that says Change Permissions.

Derek

cat4m

04-29-2006 09:35 PM

Thanks very much for your help

cat4m

04-29-2006 09:47 PM

Sorry mate, tried to do what you said and it still dont work so I am going to uninstall the lot tomorrow. Thanks for your help anyway.

ubblite

05-03-2006 11:34 PM

A few problems with this Toplist hack:

When adding a site and not selecting any image, I get this:
Warning: unlink(images/toplist/buttons/sites/8) [function.unlink]: No such file or directory in /add_site.php on line 356

Also, in CMPS the image shows up even if: "Show Site Images on Forum Home?" is checked No. It would be nice if this feature worked in CMPS.

Thanks

derekivey

05-04-2006 12:53 AM

I don't get that error at all on my dev board, but if you want you can do this file edit so it doesn't come up at all...

Open add_site.php:

Find (all of these):

PHP Code:


		
			
unlink("images/toplist/buttons/sites/".$key);

Replace With (some already have the @, only do it for the ones that dont):

PHP Code:


		
			
@unlink("images/toplist/buttons/sites/".$key);

Also, I haven't had a chance to update the CMPS module, I will have a new version out soon to have that option supported.

Derek

GNDI	05-04-2006 02:17 AM

When I try to enter the toplist from the board i get the follwing message:

Quote:

you do not have permission to access this page. This could be due to one of several reasons:

1. Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
2. If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.

I'll don't think that is cool :confused:

GNDI	05-04-2006 02:23 AM

Ok found the soluution in the "Usergroups" under admincp you have forgotten to write this in your readme.html file

derekivey

05-04-2006 02:28 AM

No, it's in the readme file. It's step 4 in the instructions...

Derek

ubblite

05-04-2006 03:13 AM

Quote:

Originally Posted by derekivey

I don't get that error at all on my dev board, but if you want you can do this file edit so it doesn't come up at all...

Open add_site.php:

Find (all of these):

PHP Code:


		
			
unlink("images/toplist/buttons/sites/".$key);

Replace With (some already have the @, only do it for the ones that dont):

PHP Code:


		
			
@unlink("images/toplist/buttons/sites/".$key);

Also, I haven't had a chance to update the CMPS module, I will have a new version out soon to have that option supported.

Derek

ok, I did what you suggested but now when I leave this blank: Image (Optional):, the next page displays this:

"Sorry, The image cannot be added! The width and height of it exceeded the limit on this toplist. Please try again."

So basically it's the same problem as before - I can't enter any site without an image.

Ramsesx

05-05-2006 12:38 AM

Hi derek, I changed my site to a new server and new domain now I get this error:

PHP Code:


		
			
Database error in vBulletin 3.5.4:



Invalid SQL:

UPDATE vb3_toplist_sites SET out=out+1 WHERE id='27';



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 'out=out+1 WHERE id='27'' at line 1

Error Number : 1064

Date         : Friday, May 5th 2006 @ 03:37:23 AM

Script       : http://www.mydomain.de/forum/out.php?id=27

Referrer     : http://www.mydomain.de/index.php

IP Address   : 87.123.18.57

Username     : MC

Classname    : vb_database

Please can you give me a hint where i need to look? Thank you.

derekivey

05-05-2006 01:55 AM

I'm not too sure. I would have to take a look at it. Can you please PM me the URL to your site so I can take a look?

Thanks,
Derek

ubblite

05-05-2006 09:20 AM

derekivey,

Any luck with a solution to my above posted problem?

Thanks

derekivey

05-05-2006 09:42 AM

Can you PM me a link to your site as well so I can look at it?

Thanks,
Derek

chriszep

05-08-2006 10:19 AM

Quote:

Originally Posted by derekivey

You have to use PHPMyAdmin to remove all the toplist_* tables, and there is a field in the usergrouppermissions table.

Derek

ok I have done it , remove everything with "toplist" (made a search in PHPMyAdmin ) and remove field in the usergrouppermissions table.
now when I ulpload the product , i have this :

Quote:

Database error in vBulletin 3.5.3:

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 : Monday, May 8th 2006 @ 01:18:09 PM
Script : http://xxxxxxxxxxxxxxxxxxxx/forums/admincp/plugin.php
Referrer : http://xxxxxxxxxxxxxxxx/forums/admin...?do=productadd
IP Address : xxxxxxxxxxxxxxxxxxxxx
Username : xxxxxxxxxxxxxx
Classname : vb_database

thanks ;)

derekivey

05-08-2006 07:14 PM

Remove that code from the install code and try again.

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

lasor

05-11-2006 09:48 AM

Excellent Job Thanks....

One question on frontpage is the anyway to open links in new window. I have selected this option in the acp options and it works fine on my toplist page but the links on the frontpage do not open in new window?

Thanks

derekivey

05-11-2006 06:44 PM

The CMPS module might not have that yet, I'm not sure if I added it or not. You can easilly add it by editing the module's template though.

Derek

lasor

05-11-2006 06:58 PM

Thanks for that...But can give me a little more of a clue..Sorry Im not an 100% upto date with vBulletin and coding...

Thanks again

lasor

05-12-2006 11:50 AM

Another really cool option would be the ability to disable indevidual banners from being displaid on the front page. I am pretty sure there must be a pretty simple way of doing this...

derekivey

05-12-2006 04:29 PM

I'll try to add this as well. One question though, do you mean disable certain sites from showing on the module or what?

Derek

lasor

05-12-2006 08:01 PM

Thanks for that...What I mean it would be great if you could select which banners where to be displaid on the frontpage marquee. I am not refering to the actual top list page that is fine as it is... but it would be great to be able to select which banners are displaid in the marquee on the frontpage...I hope I am making sense.

Thanks

azn_romeo_4u

05-13-2006 02:03 PM

anyone have any more demo's of this hack in live preview mode?

derekivey

05-13-2006 03:19 PM

Quote:

Originally Posted by lasor

I'll take a look at adding that in the next version.

Quote:

Originally Posted by azn_romeo_4u

anyone have any more demo's of this hack in live preview mode?

http://www.spacialhosting.com/toplist.php

dendrob

05-18-2006 02:16 PM

Here's another demo:

http://www.orchidboard.com/community/toplist.php

Derek, any possibility of counting all pageviews from all visitors, not just from users.

ie. My ultimate scenario:
You have a site listed in your toplist, that site has a rank button that changes...say today they're ranked #7 and that rank is seen on their own webpage on the button, so 7.gif is displayed on their page. In addition in toplist they will be ranked as #7 and the total number of pageviews will show all the pageviews that their site has received. Ranking would of course be by pageviews received and it would be ranked daily, or weekly or something. This is how it works on vivariumforum.com but the topsite is not integrated with the forum. It's nice to have sites ranked according to their true popularity, not just the popularity from within the list of members. I hope I'm making sense.

AArdvark has a great topsite, but it's not integrated into VB, which sucks. If you could add some of the features this mod would clean house!!!!

derekivey

05-18-2006 06:44 PM

Quote:

Originally Posted by dendrob

I'll prolly add that. Haven't been working on the hack because I've been really busy with school. Hopefully I can release a new version soon though.

Derek

dendrob

05-18-2006 06:50 PM

You will make me very happy!!! I am sure that others will find that feature extremely useful too, especially that it will reflect the true statistic of how the listed site is really ranking according to unique traffic.

derekivey

05-18-2006 06:52 PM

Hopefully this weekend I can work on it...

Konstantinos

05-21-2006 04:13 PM

i cant add image i get error that file format is . it doesnt work right i only can add image when edit the button.

also i want Enter the maximum number of sites you want your users to have listed. this setting per usergroup admin to be able to add more sites than the members

derekivey

05-21-2006 06:33 PM

Quote:

Originally Posted by Konstantinos

What type of image are you adding?

Also I don't understand your second problem. Please clarify.

Thanks,
Derek

All times are GMT. The time now is 06:17 PM.

Page 18 of 40

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03258 seconds Memory Usage 1,846KB 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 (5)bbcode_php_printable (13)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)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
Messages: