vb.org Archive

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)

derekivey 07-23-2006 02:21 PM

If you just transfered everything, you shouldn't have to reinstall the Toplist itself. If you want to do a fresh install, just delete the product, and delete any Toplist_ tables that vB's product manager left, and import the XML file again to install.

Derek

Lena Starling 07-23-2006 03:19 PM

The hack was actually uninstalled during the move, it's just those tables stuck around...

How do I remove the tables?

Izza 07-23-2006 06:52 PM

After installing the toplist hack. I am unable to set permissions . I get a database error.
Having looked in the database I have no toplist permissions column.

I have set the toplist up on our test site which works flawlessy .

Any ideas whats going wrong?


the database error I get is


Database error in vBulletin 3.5.4:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Administrators',
`description` = '',
`usertitle` = 'Administrator',
`opentag` = '<span style=\"color: red;\">',
`closetag` = '</span>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`forumpermissions` = '1048575',
`attachlimit` = '5000000',
`pmquota` = '500',
`pmpermissions` = '3',
`pmsendmax` = '5',
`calendarpermissions` = '63',
`wolpermissions` = '31',
`adminpermissions` = '3',
`genericpermissions` = '205520831',
`genericoptions` = '31',
`profilepicmaxwidth` = '120',
`profilepicmaxheight` = '150',
`profilepicmaxsize` = '200000',
`avatarmaxwidth` = '120',
`avatarmaxheight` = '150',
`avatarmaxsize` = '200000',
`toplistpermissions` = '1'
WHERE usergroupid=6;

MySQL Error : Unknown column 'toplistpermissions' in 'field list'
Error Number : 1054
Date : Sunday, July 23rd 2006 @ 08:48:09 PM
Script : http://www.iz-grafix.co.uk/forums/admincp/usergroup.php
Referrer : http://www.iz-grafix.co.uk/forums/ad...&usergroupid=6
IP Address : ********
Username : ********
Classname : vb_database

derekivey 07-24-2006 01:26 AM

Quote:

Originally Posted by Lena Starling
The hack was actually uninstalled during the move, it's just those tables stuck around...

How do I remove the tables?

Execute the following code in PHPMyAdmin...

[sql]DELETE TABLE IF EXISTS toplist_categories;
DELETE TABLE IF EXISTS toplist_clicks;
DELETE TABLE IF EXISTS toplist_ratings;
DELETE TABLE IF EXISTS toplist_reports;
DELETE TABLE IF EXISTS toplist_sites;[/sql]

If you have a table prefix, don't forget to add that to each of the lines above.

After that has been done, reinstall the Toplist hack and let me know if you have anymore problems.

Quote:

Originally Posted by Izza
After installing the toplist hack. I am unable to set permissions . I get a database error.
Having looked in the database I have no toplist permissions column.

I have set the toplist up on our test site which works flawlessy .

Any ideas whats going wrong?


the database error I get is


Database error in vBulletin 3.5.4:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Administrators',
`description` = '',
`usertitle` = 'Administrator',
`opentag` = '<span style=\"color: red;\">',
`closetag` = '</span>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`forumpermissions` = '1048575',
`attachlimit` = '5000000',
`pmquota` = '500',
`pmpermissions` = '3',
`pmsendmax` = '5',
`calendarpermissions` = '63',
`wolpermissions` = '31',
`adminpermissions` = '3',
`genericpermissions` = '205520831',
`genericoptions` = '31',
`profilepicmaxwidth` = '120',
`profilepicmaxheight` = '150',
`profilepicmaxsize` = '200000',
`avatarmaxwidth` = '120',
`avatarmaxheight` = '150',
`avatarmaxsize` = '200000',
`toplistpermissions` = '1'
WHERE usergroupid=6;

MySQL Error : Unknown column 'toplistpermissions' in 'field list'
Error Number : 1054
Date : Sunday, July 23rd 2006 @ 08:48:09 PM
Script : http://www.iz-grafix.co.uk/forums/admincp/usergroup.php
Referrer : http://www.iz-grafix.co.uk/forums/ad...&usergroupid=6
IP Address : ********
Username : ********
Classname : vb_database

Looks like the product installer didn't add the column to the usergroup table.

Execute the following SQL in PHPMyAdmin.

[sql]ALTER TABLE usergroup ADD toplistpermissions INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL;[/sql]

Be sure to add your table prefix to that if you have one.

Derek

Izza 07-24-2006 07:56 AM

Thanks for the quick reply though it didn't fix my problem.

After running the query I got this error

Error
SQL query:

ALTER TABLE usergroup ADD toplistpermissions INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL ;

MySQL said:

#1060 - Duplicate column name 'arcadepermissions'

derekivey 07-24-2006 03:20 PM

Hmm, thats weird. Can you open PHPMyAdmin, and see if there are two columns called arcadepermissions, and see if the toplistpermissions column is there at all?

Thanks,
Derek

Izza 07-24-2006 06:40 PM

I don't have more than one arcadepermissions table and still don't have a toplistpermissions table either.

What I did see was this below, should I have multiple index files?, the error at the bottom makes me think not.

https://vborg.vbsupport.ru/

Dj. Gargamel 07-25-2006 06:26 AM

Hello Derek - today I noticed we are having another problem - few days ago I have installed the newest version of mod - our toplist is using ranking method by views - today I saw that one user was raising the counter views continously within 5 min - of course his site was raising up in the toplist also I looked closely to other sites and noticed that there is second site with very strange views record

we are having counts form guests disabled, there is a Limit The Number Of Clicks Out For Each User and it is set to 1, we also turn on Limit The Number Of Clicks In For Each IP Address - so why this not situation is going on - maybe this option are only for In Hits and Out Hits ??

derekivey 07-25-2006 01:09 PM

Quote:

Originally Posted by Izza
I don't have more than one arcadepermissions table and still don't have a toplistpermissions table either.

What I did see was this below, should I have multiple index files?, the error at the bottom makes me think not.

http://www.iz-grafix.co.uk/mt/arcadepermissions.gif

Don't worry about indexes... Click structure at the top to see if they are there.

Quote:

Originally Posted by Dj. Gargamel
Hello Derek - today I noticed we are having another problem - few days ago I have installed the newest version of mod - our toplist is using ranking method by views - today I saw that one user was raising the counter views continously within 5 min - of course his site was raising up in the toplist also I looked closely to other sites and noticed that there is second site with very strange views record

we are having counts form guests disabled, there is a Limit The Number Of Clicks Out For Each User and it is set to 1, we also turn on Limit The Number Of Clicks In For Each IP Address - so why this not situation is going on - maybe this option are only for In Hits and Out Hits ??

Yeah those options are only for clicks in and out. Maybe I should add a setting to either count uniques or count all page views. I can probably make it so when it's set to uniques, have it only count them once in a certain time period (say 1 day or what ever). What do you think?

Derek

Dj. Gargamel 07-25-2006 03:23 PM

Quote:

Originally Posted by derekivey
Yeah those options are only for clicks in and out. Maybe I should add a setting to either count uniques or count all page views. I can probably make it so when it's set to uniques, have it only count them once in a certain time period (say 1 day or what ever). What do you think?

Derek

It would be perfect -
I would like to ask how is views ranking method counted - is it summary of in out and views ??

thanks again for such fantastic support

gamelandz 07-25-2006 04:40 PM

How do I change the look of the list? I want to remove the in and the out column?

gamelandz 07-25-2006 07:05 PM

why are the words "Delete Site ]" showing up in my description? I am not logged in and unregistered users can't delete listings

ProjectCamaro 07-26-2006 02:51 AM

It works but I get this error at the top of the forum:

Quote:

Parse error: syntax error, unexpected '"', expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/u1/projectcamaro/html/forum/toplist.php(555) : eval()'d code on line 54

Parse error: syntax error, unexpected '"', expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/u1/projectcamaro/html/forum/toplist.php(555) : eval()'d code on line 54

derekivey 07-26-2006 03:27 AM

Quote:

Originally Posted by Dj. Gargamel
It would be perfect -
I would like to ask how is views ranking method counted - is it summary of in out and views ??

thanks again for such fantastic support

No, it's the page views, the number of views in the views column, that includes all out hits to that site, as well as page views that are counted if the site owner adds the tracking code to their site.

Quote:

Originally Posted by gamelandz
How do I change the look of the list? I want to remove the in and the out column?

You would have to edit the Toplist, Toplist_1, and Toplist_2 templates to remove those.

Quote:

Originally Posted by gamelandz
why are the words "Delete Site ]" showing up in my description? I am not logged in and unregistered users can't delete listings

Did you try the fix in this post"]https://vborg.vbsupport.ru/showpost.php?p=1033169&postcount=945]post[/url]?

Quote:

Originally Posted by ProjectCamaro
It works but I get this error at the top of the forum:

Try the fix I mentioned above...

ProjectCamaro 07-26-2006 05:08 AM

Quote:

Originally Posted by derekivey
Try the fix I mentioned above...

Thank you, that fixed it. :cool:

derekivey 07-26-2006 12:59 PM

Quote:

Originally Posted by ProjectCamaro
Thank you, that fixed it.

No Problem :)

DementedMindz 07-26-2006 05:53 PM

derek i just thought of something that might be nice... say you dont allow buttons or banners on your toplist via admincp maybe have it where when you shut that setting off and it will shut it off on addsite cause if you shut it off right now it still shows on addsite... also whats the biggest banner size you would recommend?

derekivey 07-27-2006 02:41 AM

I will add that to the next version. I recommend small banner sizes because if you did big ones, you would probably have to modify the templates so they would fit better, but the size is entirely up to you.

Derek

ProjectCamaro 07-27-2006 05:38 AM

Quick question. I have the marquee at the bottom of the forum right now and I have two questions. Is there a way to make it when someone clicks on one of the banner's at the bottom that it'll open the link in a new window instead of the same one and is there a way to change the text right above the marquee that says "Toplist Sites:" to something unique?
Thank you again, it's working great for me.

derekivey 07-27-2006 02:34 PM

1) Yes, edit the Toplist_Forum_Home template (I think it's called that).
2) Yes, search for that phrase in vB's phrase manager and put something in for the English translation field.

Derek

hilfe-forum 08-03-2006 11:27 AM

Hi can you help me?

i get this error:

Parse error: parse error, unexpected '\"', expecting T_STRING or T_VARIABLE or T_NUM_STRING in /var/www/www1/rechner2/wwwneu/vbulletin/toplist.php(555) : eval()'d code on line 54



Line 54 is: <if condition="$sr['votes'] == 1">


it?s the original Temlate

vB Ver. = 3.5.3

derekivey 08-03-2006 02:42 PM

Quote:

Originally Posted by hilfe-forum
Hi can you help me?

i get this error:

Parse error: parse error, unexpected '\"', expecting T_STRING or T_VARIABLE or T_NUM_STRING in /var/www/www1/rechner2/wwwneu/vbulletin/toplist.php(555) : eval()'d code on line 54



Line 54 is: <if condition="$sr['votes'] == 1">


it?s the original Temlate

vB Ver. = 3.5.3

Try this... https://vborg.vbsupport.ru/showpost....&postcount=945

ProjectCamaro 08-03-2006 02:50 PM

Quote:

Originally Posted by derekivey
1) Yes, edit the Toplist_Forum_Home template (I think it's called that).
2) Yes, search for that phrase in vB's phrase manager and put something in for the English translation field.

Derek

Ok I was able to get the phrase changed with no problem. What do I edit in that template to make the links open in new window's? Sorry I'm really not the best at this as you can tell.

derekivey 08-03-2006 11:19 PM

Sorry wrong template... The template you need to edit is Toplist_Sites_Code.

Find:
PHP Code:

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

Replace With:
PHP Code:

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

Not sure why I didn't make it open in a new window but that will be included in the next version.

Derek

derekivey 08-03-2006 11:20 PM

BTW guys, When I release the next version, I will have it for 3.5 and 3.6.

Derek

gamelandz 08-03-2006 11:33 PM

Quote:

Did you try the fix in this post"]https://vborg.vbsupport.ru/showpost.php?p=1033169&postcount=945]post[/url]?
that worked....thanks a million

derekivey 08-04-2006 04:19 AM

No Problem :).

Shazz 08-04-2006 05:00 AM

Quote:

Originally Posted by derekivey
BTW guys, When I release the next version, I will have it for 3.5 and 3.6.

Derek

W00t!@

*adds it to the list
________
Toyota TF106 history

derekivey 08-04-2006 02:18 PM

You should be able to use the current version on 3.6, I haven't found any problems so far.

Derek

ambrosious 08-06-2006 02:03 AM

Quote:

Originally Posted by Griffin80
i have just updated this script to the latest version, but when i edit the usergroup pemissions i get this error:



Thanks

I get the same error, do not know where to look to solve it, anyone got any ideas?

ambrosious 08-06-2006 03:53 AM

Nevermind, fixed.

ProjectCamaro 08-07-2006 01:54 AM

Quote:

Originally Posted by derekivey
Sorry wrong template... The template you need to edit is Toplist_Sites_Code.

Find:
PHP Code:

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

Replace With:
PHP Code:

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

Not sure why I didn't make it open in a new window but that will be included in the next version.

Derek

Awesome, works perfectly!! Thank you for the help, it's now setup just the way I personally like it for my website so I'll leave you alone now. :D

derekivey 08-07-2006 01:14 PM

Quote:

Originally Posted by ProjectCamaro
Awesome, works perfectly!! Thank you for the help, it's now setup just the way I personally like it for my website so I'll leave you alone now. :D

No Problem :)

Clyde1967 08-09-2006 12:10 AM

I am having problems with images displaying for toplist.All the settings appear to be correct but they wont display,also my avatars are not displaying as well.Any help would be much appreciated.

loonytune15 08-09-2006 05:03 AM

I have a suggestion for the next release..

On the Forumhome where it says "Toplist:" , can we have after that how many sites are in the toplist, and have the word toplist, able to be linked to the toplist?

ZeroX Prodigy 08-09-2006 03:04 PM

Great modification Derek! Works perfectly, and can't wait for the next versions!

derekivey 08-09-2006 05:01 PM

Quote:

Originally Posted by Clyde1967
I am having problems with images displaying for toplist.All the settings appear to be correct but they wont display,also my avatars are not displaying as well.Any help would be much appreciated.

Not sure about your avatars, because this doesn't mess with user's avatars, but can you PM me a link to your site so I can take a look at the toplist?

Quote:

Originally Posted by loonytune15
I have a suggestion for the next release..

On the Forumhome where it says "Toplist:" , can we have after that how many sites are in the toplist, and have the word toplist, able to be linked to the toplist?

Sounds good, I will include that in the next release.

Quote:

Originally Posted by Forum Dude
Great modification Derek! Works perfectly, and can't wait for the next versions!

Thanks, I appreciate the feedback :).

gamelandz 08-09-2006 08:50 PM

ok here are my problems: I did a fresh install and this is what is happening:

1. View my toplist
2. when a registered user ads a ad.....how do they edit it? (i hve permissions set that they can edit)

what do i do?

derekivey 08-10-2006 03:52 AM

What happens when they try to edit? Or is the link not showing?

gamelandz 08-10-2006 08:31 AM

the link is not showing


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

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.02852 seconds
  • Memory Usage 1,860KB
  • 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
  • (4)bbcode_php_printable
  • (22)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