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)

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


All times are GMT. The time now is 02:58 AM.

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.02047 seconds
  • Memory Usage 1,748KB
  • 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
  • (1)bbcode_code_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (4)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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