Convert this MySQL?

Want to share what MODs you've gotten to work with EM? Happy about all the time your're saving? Want to say "thanks"? Here's the place.
Forum rules
DO NOT give out any FTP passwords to anyone! There is no reason to do so! If you need help badly enough, create a temporary FTP account that is restricted to only the files that you need help with and give the information for that. Giving out FTP information can be very dangerous!
Locked
SKnight579
Registered User
Posts: 2
Joined: Thu Apr 20, 2006 2:41 pm

Convert this MySQL?

Post by SKnight579 » Thu Apr 20, 2006 2:43 pm

Hey,

I was wondering if someone can help me out, I came across a mod I really want to use, but it gives me this as the MySQL code:

Code: Select all

CREATE TABLE phpbb_FTP (
  field_id mediumint(8) NOT NULL auto_increment,
  input_name varchar(255) default 'NULL',
  input_description varchar(225) default 'NULL',
  output varchar(255) default 'NULL',
  format_output_start varchar(255) default NULL,
  format_output_end varchar(255) default NULL,
  cat_id varchar(255) default NULL,
  require_field varchar(10) default '0',
  textbox_cols varchar(10) default '40',
  textbox_rows varchar(10) default '2',
  format_input_start varchar(255) default NULL,
  format_input_end varchar(255) default NULL,
  type varchar(10) default '0',
  PRIMARY KEY  (field_id)
) TYPE=MyISAM;

CREATE TABLE phpbb_FTP_categories (
  cat_id mediumint(8) unsigned NOT NULL auto_increment,
  cat_title varchar(100) default NULL,
  forum_id varchar(100) default NULL,
  cat_order mediumint(8) unsigned NOT NULL default '0',
  notice varchar(255) default NULL,
  subject_name varchar(255) default NULL,
  subject_desc varchar(255) default NULL,
  user_id varchar(100) default NULL,
  user_text varchar(100) default '0',
  post_notice text,
  auth varchar(5) default '0',
  group_id varchar(5) default NULL,
  auth_reply char(3) default '0',
  PRIMARY KEY  (cat_id),
  KEY cat_order (cat_order,
) TYPE=MyISAM;

CREATE TABLE phpbb_FTP_checkboxes (
  cb_id mediumint(8) unsigned NOT NULL auto_increment,
  field_id mediumint(8) unsigned NOT NULL default '0',
  cb_text varchar(255) NOT NULL default '',
  cb_description varchar(255) NOT NULL default '',
  PRIMARY KEY  (cb_id),
  KEY field_id (field_id),
) TYPE=MyISAM;

CREATE TABLE phpbb_FTP_dropdown (
  dd_id mediumint(8) unsigned NOT NULL auto_increment,
  field_id mediumint(8) unsigned NOT NULL default '0',
  dd_text varchar(255) NOT NULL default '',
  dd_description varchar(255) NOT NULL default '',
  PRIMARY KEY  (dd_id),
  KEY field_id (field_id),
) TYPE=MyISAM;
My Problem is, Easymod can't run that. I was wondering if you could re-type it so that easymod can? I'm not good enough yet to do so myself, or manually put in the info. I'm very toucy about messing with the database, I really don't want to loose the entire board over this :-)

Thanks for your help!

-SKnight579

SKnight579
Registered User
Posts: 2
Joined: Thu Apr 20, 2006 2:41 pm

Re: Convert this MySQL?

Post by SKnight579 » Sun Apr 23, 2006 6:58 pm

Anyone? Please?

User avatar
markus_petrux
Registered User
Posts: 376
Joined: Fri Jun 18, 2004 10:58 pm
Location: Girona, Catalunya (Spain)
Contact:

Re: Convert this MySQL?

Post by markus_petrux » Mon Apr 24, 2006 10:58 am

It contains syntax errors. Try contacting the MOD author.

Then you could tell EM to execute the SQL statements by putting them into the MOD template, within a SQL section. See this for further info:
http://www.phpbb.com/kb/article.php?article_id=39" target="_blank

Locked