vb.org Archive
Page 7 of 40 « First 56 7 8917 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)

divided_by_fear 12-05-2005 11:45 AM
if you start getting into scrolling stuff that really slows sites down... i would def. uninstall if this goes scroilling....

loonytune15 12-05-2005 12:06 PM
No just an option to include it, naturally you can turn it off if you dont want it on. Or even if it included a box at the bottom that changes the affiliate every 10 seconds or so..

Snake 12-05-2005 12:23 PM
Hey I got a little feature-suggestion:

-Commenting system

divided_by_fear 12-05-2005 12:25 PM
Quote:
Originally Posted by loonytune15
No just an option to include it, naturally you can turn it off if you dont want it on. Or even if it included a box at the bottom that changes the affiliate every 10 seconds or so..

why wouldnt you just go with it like he has it on the vbadvanced module each time you refresh it shows a different site... cause when you have it changeing like that it will slow things down

divided_by_fear 12-05-2005 12:26 PM
Quote:
Originally Posted by Aftermath
Hey I got a little feature-suggestion:

-Commenting system

yeah that would really be nice to see... this way other users can basiclly see what they think and feel about the other site

Stephen3 12-05-2005 03:03 PM
request for category , porsible ??

pauloo 12-05-2005 03:36 PM
Quote:
Originally Posted by Stephen3
request for category , porsible ??
Good idea :nervous: ,I want too a category

Than you for this good hack !

Snake 12-05-2005 03:36 PM
Yeah site category (such as Gaming, Movies, etc) - that would be nice too!

derekivey 12-05-2005 07:37 PM
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.

divided_by_fear 12-05-2005 07:38 PM
yeah it has came a long way since i first installed it doing nice work....

loonytune15 12-05-2005 11:46 PM
Quote:
Originally Posted by derekivey
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 12-06-2005 12:16 AM
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 12-06-2005 12:32 AM
Hmm looks like your missing part of the query.

Try this:

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

loonytune15 12-06-2005 12:45 AM
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 12-06-2005 01:27 AM
Hmm, looks like your missing that field also, run these queries:
[sql]
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`;
[/sql]

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

loonytune15 12-06-2005 01:30 AM
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 12-06-2005 01:42 AM
If you know who voted, and for what site, you can easily add their votes by editing the database..

Allan 12-06-2005 08:19 AM
error:

Code:
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 12-06-2005 09:51 AM
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 12-06-2005 10:38 AM
Code:
Invalid SQL:
ALTER TABLE `toplist_sites` ADD `status` VARCHAR( 20 ) DEFAULT 'active' NOT NULL AFTER `out`;;

Allan 12-06-2005 06:37 PM
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 12-06-2005 06:46 PM
Huh? What link?

Also,
[sql]
ALTER TABLE `toplist_sites` ADD `status` VARCHAR( 20 ) DEFAULT 'active' NOT NULL AFTER `out`;;
[/sql]

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

Allan 12-06-2005 07:20 PM
this link for example:

Code:
<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 12-06-2005 07:58 PM
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 12-06-2005 08:32 PM
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.




Quote:
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 12-06-2005 08:46 PM
Quote:
Originally Posted by 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.

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

File Attach: French Language for Version 1.0.4 ;)

derekivey 12-06-2005 08:58 PM
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.

[sql]
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`;
[/sql]

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 12-06-2005 09:04 PM
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:

Quote:
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 12-06-2005 09:05 PM
Quote:
Originally Posted by 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.

[sql]
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`;
[/sql]

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 12-06-2005 09:11 PM
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 12-06-2005 09:33 PM
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 12-07-2005 12:35 AM
Ok, I'll take a look and see if I have that problem. I'll get back to you about it.

Derek

derekivey 12-07-2005 12:40 AM
Hmm, I can't reproduce that. Make sure you have 'Email When A New Site Is Added That Requires Validation' set to 'No'.

Dan 12-07-2005 01:12 AM
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 ;)

[high]* Dan clicks install[/high]

derekivey 12-08-2005 01:34 AM
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 12-08-2005 04:52 PM
OK the hack has been updated. It's working fine now.

loonytune15 12-09-2005 12:50 AM
thats good news :)

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

derekivey 12-09-2005 12:53 AM
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 12-09-2005 01:01 AM
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 12-09-2005 01:33 AM
Yeah I'll have an option for that.

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


All times are GMT. The time now is 09:35 AM.
Page 7 of 40 « First 56 7 8917 Last »
Show 40 post(s) from this thread on one page

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

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01693 seconds
  • Memory Usage 1,827KB
  • 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
  • (3)bbcode_code_printable
  • (8)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete