Announcement

Collapse
No announcement yet.

SQL prob?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • SQL prob?

    hi.. i read sticky about the 3 ways to run a query.. and i understood it.. i think.. so lets do an example.. in the install file of a hack it said add sql quieries in sql.txt
    and the sql.txt is
    Code:
    DROP TABLE IF EXISTS lockdown;
    CREATE TABLE `lockdown` (
      `hackid` int(10) NOT NULL auto_increment,
      `threadid` int(10) unsigned NOT NULL default '0',
      `firstpostid` int(10) unsigned NOT NULL default '0',
      `forumsid` int(10) NOT NULL default '0',
      `langueid` int(3) NOT NULL default '0',
      `userid` int(10) NOT NULL default '0',
      `username` varchar(50) NOT NULL default '',
      `dateline` int(10) NOT NULL default '0',
      `catid` int(4) NOT NULL default '0',
      `version_vb` varchar(10) NOT NULL default '',
      `version_hack` varchar(10) NOT NULL default '',
      `title` varchar(100) NOT NULL default '',
      `description` mediumtext NOT NULL,
      `installation` varchar(4) NOT NULL default '',
      `queries` varchar(4) NOT NULL default '',
      `templates_news` varchar(4) NOT NULL default '',
      `templates_mod` varchar(4) NOT NULL default '',
      `files_add` varchar(4) NOT NULL default '',
      `files_mod` varchar(4) NOT NULL default '',
      `phrases` varchar(4) NOT NULL default '',
      `attachmentid` varchar(50) NOT NULL default '',
      `nb_install` int(10) NOT NULL default '0',
      `postuser` varchar(250) NOT NULL default '',
      `postuserid` int(10) NOT NULL default '0',
      `version` varchar(10) NOT NULL default '',
      `installer` varchar(4) NOT NULL default '',
      `installs` int(5) NOT NULL default '0',
      `updated` int(10) NOT NULL default '0',
      `addonid` int(10) unsigned NOT NULL default '0',
      PRIMARY KEY  (`hackid`)
    ) TYPE=MyISAM;
     
    DROP TABLE IF EXISTS lockdown_install;
    CREATE TABLE `lockdown_install` (
      `installid` int(10) NOT NULL auto_increment,
      `userid` int(10) NOT NULL default '0',
      `username` varchar(50) NOT NULL default '',
      `hackid` int(10) NOT NULL default '0',
      `threadid` int(10) NOT NULL default '0',
      PRIMARY KEY  (`installid`)
    ) TYPE=MyISAM;
     
    DROP TABLE IF EXISTS lockdown_userarea;
    CREATE TABLE `lockdown_userarea` (
      `areaid` int(10) NOT NULL auto_increment,
      `userid` int(10) NOT NULL default '0',
      `username` varchar(50) NOT NULL default '',
      `hackid` int(10) NOT NULL default '0',
      `threadid` int(10) NOT NULL default '0',
      `downcount` int(10) NOT NULL default '0',
      `attachmentid` int(10) NOT NULL default '0',
      `title` varchar(100) NOT NULL default '',
      `version_vb` varchar(10) NOT NULL default '',
      `version_hack` varchar(10) NOT NULL default '',
      `updated` int(10) NOT NULL default '0',
      PRIMARY KEY  (`areaid`)
    ) TYPE=MyISAM;
     
    ALTER TABLE `thread` ADD `showfirstpost` smallint(6) NOT NULL default '0';
    ALTER TABLE `forum` ADD `hack_poster` smallint(3) NOT NULL default '0';
    ALTER TABLE `forum` ADD `hack_poster_private` smallint(3) NOT NULL default '0'
    which one is the line i need to enter in my phpadmin to run the query?
    or how can i run these queries?

  • #2
    You need to run all of that, if you need help for code modifications you should ask on vBulletin.org.

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...
    X