"Fossies" - the Fresh Open Source Software Archive

Member "faqadmin/update.txt" (31 Oct 2006, 2162 Bytes) of package /linux/www/old/faqadmin-current.tgz:

    1 Faq Administrator version 3.0 is a PHP4/Mysql message board.
    2 
    3 This is a security patch release!
    4 
    5 
    6 !! SECURITY UPDATE INFORMATION !!
    7 ----------------------------------------------
    8 
    9 A bug has been found that may allow code to be ran on your system.
   10 
   11 IT IS ADVISABLE THAT YOU MOVE YOUR FAQ DIRECTORY TO A LOCATION THAT IS NOT
   12 ACCESSABLE THROUGH THE WEB UNTIL YOU PATCH YOUR FILES!!
   13 
   14 // File replacements
   15 
   16 Current users of Faq Administrator are advised to take the following actions:
   17 
   18 1) DELETE:
   19 
   20 c2.php 
   21 c3.php 
   22 blank.php
   23 faqsend.php 
   24 faq_reply.php
   25 hist_replycount.php
   26 mail.php
   27 reply_count.php
   28 total_asked.php
   29 
   30 2) REPLACE:
   31 
   32 Copy contents of the "patch" directory to your working "faq" directory.
   33 
   34 
   35 END 3.0 SECURITY UPDATE INFORMATION
   36 ----------------------------------------------
   37 
   38 
   39 Versions older than 2.1b will need to continue reading.
   40 
   41 // Existing Database
   42 
   43 1 table has been added to faq_dat
   44 
   45 		redate varchar(18)
   46 
   47 No data restructuring is required other than adding the new table.
   48 
   49 mysql> alter table faq_dat add redate varchar(18);	
   50 
   51 
   52 // Database/Table Layouts
   53 
   54 The following MySQL Databases and Tables are required.
   55 
   56 * To view your current table structures use the following command.
   57 mysql>use faqs;
   58 mysql>describe <table name>
   59 
   60 Update your tables as needed.
   61 
   62 Database  Table	  Columns    values
   63 
   64 faqs
   65 
   66         faq_dat
   67 
   68 		fodr int(11) primary key default 0 auto_increment
   69 		faq_dat text
   70 		faq_user varchar(30) not null
   71 		faq_memo varchar(25) not null
   72 		faq_user_email varchar(30) not null
   73 		faq_date varchar(18)
   74 		email varchar(2) default 'N'
   75 		replies varchar(4) default 0
   76 		faq_fid varchar(5)
   77 		redate varchar(18)
   78 
   79         faq_re_dat
   80 
   81 		refaq_data text
   82 		faq_re_memo varchar(25)
   83 		faq_reuser varchar(30) not null
   84 		faq_reuser_email varchar(30) not null
   85 		refac_date timestamp(14)
   86 		faq_re_fid varchar(5)
   87 		fodr varchar(11)
   88 
   89 	faq_forum
   90 
   91 		fid int(11) primary key default 0 auto_increment
   92 		forum_name varchar(25) not null
   93 		decription text)
   94 
   95 	faq_admin
   96 
   97 		uaid int(11) primary key default 0 auto_increment
   98 		userid varchar(30)
   99 		userpass varchar(14)
  100 
  101 
  102 
  103 Feel free to email either bitfuzzy@campbus.com or faqadmin@campbus.com 
  104 with any questions or problems.