mantisbt/admin install.php,1.15,1.16 schema.php,1.5,1.6

Update of /cvsroot/mantisbt/mantisbt/admin
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv15367/admin

Modified Files:
        install.php schema.php 
Log Message:
fix for 0006021: Mantis installation issues under sql server
  - simplified query in config_api.php


Index: install.php
===================================================================
RCS file: /cvsroot/mantisbt/mantisbt/admin/install.php,v
retrieving revision 1.15
retrieving revision 1.16
diff -u -d -r1.15 -r1.16
--- install.php 25 Jul 2005 22:42:39 -0000      1.15
+++ install.php 30 Jul 2005 18:10:40 -0000      1.16
@@ -57,7 +57,7 @@
        # --------
        # create an SQLArray to insert data
        function InsertData( $p_table, $p_data ) {
-               $query = "INSERT INTO " . $p_table . " VALUES " . $p_data;
+               $query = "INSERT INTO " . $p_table . $p_data;
                return Array( $query );
        }
 

Index: schema.php
===================================================================
RCS file: /cvsroot/mantisbt/mantisbt/admin/schema.php,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -d -r1.5 -r1.6
--- schema.php  5 Jul 2005 23:48:49 -0000       1.5
+++ schema.php  30 Jul 2005 18:10:40 -0000      1.6
@@ -338,6 +338,7 @@
 $upgrade[] = 
Array('CreateIndexSQL',Array('idx_access',config_get('mantis_user_table'),'access_level'));
 
 $upgrade[] = Array('InsertData', Array( config_get('mantis_user_table'), 
-    "(1, 'administrator', '', 'root@localhost', 
'63a9f0ea7bb98050796b649e85481845', '2003-02-16 02:03:48', '2004-07-08 
23:59:22', 1, 1, 90, 3, 0, 0, MD5(NOW()))" )
-    );
+    "(username, realname, email, password, date_created, last_visit, enabled, 
protected, access_level, login_count, lost_password_request_count, 
failed_login_count, cookie_string) VALUES 
+        ('administrator', '', 'root@localhost', 
'63a9f0ea7bb98050796b649e85481845', NOW(), NOW(), 1, 1, 90, 3, 0, 0, '" . 
+             md5( mt_rand( 0, mt_getrandmax() ) + mt_rand( 0, mt_getrandmax() 
) ) . md5( time() ) . "')" ) );
 ?>
\ No newline at end of file



-------------------------------------------------------
SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
from IBM. Find simple to follow Roadmaps, straightforward articles,
informative Webcasts and more! Get everything you need to get up to
speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click