/**
 * Verify credentials for a MySQL database. Assumes we are connecting to BitNami's DB.
 * @param string Username
 * @param string Password
 * @return int 0 if successful, >0 on error. Will push an error string to the stack if >0.
 */

Function mysql_connect
  Pop $R1 ; Password
  Pop $R0 ; Username

  SetOutPath $PLUGINSDIR
  File "inst-resources\mysqlutil.php"

  nsExec::ExecToLog '"$stack_instdir\php\php.exe" "$PLUGINSDIR\mysqlutil.php" $db_port "$R0" "$R1"'
  Delete "$PLUGINSDIR\mysqlutil.php"
  ; just be done; nsExec's result is on the top of the stack.
FunctionEnd

/**
 * Create a MySQL database and grant privileges on it to the given user.
 * @param string User to connect with
 * @param string Password to connect with
 * @param string Database name
 * @param string New user
 * @param string New user's password
 */

Function mysql_create_db
  Pop $R5 ; Password
  Pop $R4 ; User
  Pop $R3 ; Database
  Pop $R1 ; Password
  Pop $R0 ; Username
  
  ReadINIStr $R2 "$stack_instdir\properties.ini" "MySQL" "mysql_root_directory"
  IfFileExists "$R2\data\$R3" 0 DatabaseDoesNotExist
    MessageBox MB_YESNO|MB_ICONQUESTION|MB_DEFBUTTON2 "The database $\"$R3$\" already exists. Do you want to delete and recreate it?$\n$\nIf you choose No, Setup will not alter MySQL's permissions, and you may need to set up permissions manually." IDYES +2
      Return
    
  DatabaseDoesNotExist:
  
  SetOutPath $PLUGINSDIR
  File "inst-resources\mysqlutil.php"
  
  nsExec::ExecToLog '"$stack_instdir\php\php.exe" "$PLUGINSDIR\mysqlutil.php" $db_port "$R0" "$R1" \
                     "DROP DATABASE IF EXISTS `$R3`; \
                      CREATE DATABASE `$R3`; \
                      GRANT ALL PRIVILEGES ON `$R3`.* TO `$R4`@localhost \
                        IDENTIFIED BY $\'$R5$\' WITH GRANT OPTION;"'
  Delete "$PLUGINSDIR\mysqlutil.php"
FunctionEnd