vb.org Archive
Page 2 of 10 1 2 34 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   vBTopSite (https://vborg.vbsupport.ru/showthread.php?t=59447)

sweet22 12-30-2003 09:52 PM
there is no attachment or download for the topsite

Roxie 12-30-2003 10:00 PM
I am having to do the queries manually and I got this error with the first one:

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unclosed quote @ 108
STR: '
SQL: CREATE TABLE topsites_ips (
ipin int(10) NOT NULL auto_increment,
address varchar(14) NOT NULL default \'\',
siteid int(5) NOT NULL default \'0\',
dateadd int(20) NOT NULL default \'0\',
PRIMARY KEY (ipin)
) TYPE=MyISAM
SQL-query :

CREATE TABLE topsites_ips ( ipin int(10) NOT NULL auto_increment, address varchar(14) NOT NULL default \'\', siteid int(5) NOT NULL default \'0\', dateadd int(20) NOT NULL default \'0\', PRIMARY KEY (ipin) ) TYPE=MyISAM

MySQL said:

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 '\'\',
siteid int(5) NOT NULL default \'0\',
dateadd int(20)

Darkwaltz4 12-30-2003 10:06 PM
UGH THIS IS GETTING ANNOYING NOW....blame vbhackmaker, here use this

PHP Code:
CREATE TABLE topsites_ips (
  ipin int(10) NOT NULL auto_increment,
  address varchar(14) NOT NULL default '',
  siteid int(5) NOT NULL default '0',
  dateadd int(20) NOT NULL default '0',
  PRIMARY KEY  (ipin)
) TYPE=MyISAM;

CREATE TABLE topsites_options (
  active tinyint(1) NOT NULL default '0',
  hitson tinyint(1) NOT NULL default '0',
  perpage tinyint(3) NOT NULL default '10',
  daytime tinyint(2) NOT NULL default '1',
  require tinyint(1) NOT NULL default '1',
  buttons varchar(75) NOT NULL default '',
  totalbuttons int(3) NOT NULL default '50',
  resolve tinyint(1) NOT NULL default '0',
  display tinyint(1) NOT NULL default '1',
  htmlallowed varchar(75) NOT NULL default '<b><u><i>',
  bheight tinyint(3) NOT NULL default '0',
  bwidth tinyint(3) NOT NULL default '0',
  bborder tinyint(3) NOT NULL default '0',
  arrows varchar(75) NOT NULL default '',
  rankby varchar(75) NOT NULL default 'todayunique',
  KEY active (active)
) TYPE=MyISAM;

CREATE TABLE topsites_sites (
  siteid int(3) NOT NULL auto_increment,
  siteurl varchar(75) NOT NULL default '',
  sitetitle varchar(75) NOT NULL default '',
  webmaster varchar(30) NOT NULL default '',
  webemail varchar(50) NOT NULL default '',
  sitedescription text NOT NULL,
  sitepassword varchar(30) NOT NULL default '',
  buttonurl varchar(75) NOT NULL default '',
  totalhits int(10) unsigned NOT NULL default '0',
  totalout int(10) unsigned NOT NULL default '0',
  totalunique int(10) unsigned NOT NULL default '0',
  totalin int(10) unsigned NOT NULL default '0',
  todayin int(10) unsigned NOT NULL default '0',
  todayunique int(10) unsigned NOT NULL default '0',
  todayout int(10) unsigned NOT NULL default '0',
  todayhits int(10) unsigned NOT NULL default '0',
  lastreset int(20) NOT NULL default '0',
  lastrank int(20) NOT NULL default '0',
  joindate int(20) NOT NULL default '0',
  active tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (siteid),
  UNIQUE KEY siteurl (siteurl,webmaster,webemail,buttonurl)
) TYPE=MyISAM;

INSERT INTO topsites_options VALUES (0, 0, 10, 1, 1, 'http://YOURSITE/topsites/buttons', 10, 0, 2, '<b><u><i>', 31, 88, 0, 'http://YOURSITE/topsites', 'todayunique');

---------------------------------
find forum/global.php
----
if (!$servertoobusy) {
  require('./admin/sessions.php');
----
replace with
----
if (!$servertoobusy) {
if($PHP_SELF != "/topsites_hit.php") {
  require('./admin/sessions.php');
}

find in admin/index.php
----------
makenavoption("Add","announcement.php?action=add","|");
makenavoption("Modify","announcement.php?action=modify");
makenavselect("Announcements");

add below
// *************************************************
makenavoption("Options","topsites_admin.php?action=options"," | ");
makenavoption("Manage Sites","topsites_admin.php?action=site","<br/>");
makenavoption("Useful Admin Functions","topsites_admin.php?action=functs","<br/>");
makenavoption("Send Emails","topsites_admin.php?action=email"," | ");
makenavoption("View","../topsites.php?page=1","<br/>");
makenavselect("vBTopSite"); 
*sigh* i think i remember why i dont release hacks here, lol

and yeah...............................vb3 is in the process of 'updating the attachment' =_= which means it might not be available until tomarrow...stupid thing. if you click install, ill be able to update you when it returns

Roxie 12-30-2003 10:17 PM
I'm getting errors with all the queries now....I'm going to hold off on installing until you get the file updated. Then I'll try again.

Darkwaltz4 12-30-2003 11:27 PM
Okay, the update is there, i took out the vbhacker stuff, and added all of the instructions which you will need, and that should be everything *heavy sigh* now, this is really ruining my credibility isnt it, lol. Just follow the instructions, vbhacker sucks i just found out, when you are trying to make your own with vbhackmaker.

ULTIMATESSJ 12-30-2003 11:35 PM
One small question

I have my forums installed on a subdomain (for example http://forum.mysite.com). Say i wanted this topsite page to appear on the normal site (example again http://www.mysite.com/topsite.php), what would i need to do?

Darkwaltz4 12-30-2003 11:39 PM
hmmmm....im just guessing, but you might be able to do it if you put the full url into the include file to global.php of your fourms (which it needs to run) however i have a feeling this wont work, because then youll have to edit all the requires in the global.php file....you might try it, but i seriously dont think it will work without some annoyance experienced on your end.

this is one of the problems, which is solved by being free of vb in the version i mentioned above :-p because some people dont like the topsites to be dependant on the forums.

AN-net 12-31-2003 05:51 AM
i seem to be having problems with the second db query>_<

edit:
im having problems with the topsites_options:
specifically:
'require tinyint( 1 ) NOT NULL default '1',
buttons varchar(

Darkwaltz4 12-31-2003 03:32 PM
which version of mysql are you running? the sql statements should all be run through phpmyadmin, after all i used phpmyadmin to render the statements in the first place, lol (using the view dump schema thing)

on a side note, if anyone actually gets this running on their site, mind posting a link? :D i might even list it at the top or something

MindTrix 12-31-2003 03:38 PM
Sounds good, nice job ;)

Hope you get the problems fixed soon


All times are GMT. The time now is 09:49 AM.
Page 2 of 10 1 2 34 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.02135 seconds
  • Memory Usage 1,782KB
  • 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_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (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