Advance blue voda form processor

svenand1938 · #1 08-02-2007, 08:07 AM

After filling out the processor installation form and hitting "install now I recieve the message "could not connect to the database server" what to do?
Doors-of-hope-ministries.org

navaldesign · #2 08-02-2007, 09:57 AM

In the ABVFP installation panel, there is a yellow ? beside each field. Click there to get help.

Make sure you have created the database, created the user, and ADDED the user to the ABVFP related database

svenand1938 · #3 08-02-2007, 03:27 PM

I have done that, and checked the upload there is one note though, "make sure that all files have permissions 644" and I have no clue what that is all about

navaldesign · #4 08-02-2007, 04:10 PM

Sometimes FTP changes the deafault permissions from 644 to something else, so i suggest that you check the files permissions.
Connect with FTP, go in the ABVFP folder, and right click on the files, from the right click menu select "Permissions" and make sure they are 644, if not change them to be so

svenand1938 · #5 08-02-2007, 05:50 PM

Well I did that and now I am not permitted in

This is the message:
You don't have permission to access /ABVFP/dbts_install.php on this server.

navaldesign · #6 08-02-2007, 05:59 PM

You have, somehow, changed the permissions of the files or of the entire folder.
The folder needs to be 755, the files inside it must be 644. Check it.

svenand1938 · #7 08-02-2007, 09:19 PM

all files are 644 and folder755 and still getting "could not connect to the database server"

svenand1938 · #8 08-02-2007, 09:33 PM

I got it, the user name in data base didnt match.

luis arana · #9 10-04-2007, 01:12 AM

Hello, thanks in advance, I can´t make work the upload field in my form and now I am trying to instal AVBFP so it can be easy, I am having trouble to create the data base and the user. What I kave done is create a folder named ABVFP in the folder cpanel, but then how do i add a user?

thanks, I made all the things posted in adding an uploadform post..and I didn´t have results

Luis

navaldesign · #10 10-04-2007, 07:32 AM

The user is not added to the folder, but to the database. You need to create a database, in your Cpanel, then you create a user (you assign a username and a password) then you add this user to that database. Please watch this tutorial: http://www.vodahost.com/demowolf/cpa...eatemysql.html

luis arana · #11 10-06-2007, 05:45 PM

Than you, I correct them

Now I have an other problem, when I receive the email the link of the URL for the archive in my data base is not completly underlined, I make bigger the browse button so I can have more characters but this don´t fix it.

How can I make to make URL appears complete underlined in my Email?

navaldesign · #12 10-06-2007, 05:58 PM

Does your URLs contain blank spaces ? If yes, the URLs will be broken anyway.

The browse button dimensions have nothing to do with it.

luis arana · #13 10-08-2007, 06:53 PM

Ok, now ther is nothing to do with that, What i have done now is add more upload files and it is happening that they are uploaded but the link does not appears in my mail.

i have the following to add to my mail:

//Sending Email to form owner
$mailto = "info@ideaspersonales.com";
$mailsubj = "COTIZACION";
$mailhead = "From: $email\n";
reset ($HTTP_POST_VARS);
$mailbody = "Datos del cliente y link de archivos :\n";
while (list ($key, $val) = each ($HTTP_POST_VARS))
{
if ($key!="submit")
{
$mailbody .= "$key : $val\n";
}
}
$mailbody .= "File Link 1: $upload_URL\n"; //
$mailbody .= "File Link 2: $upload2_URL\n"; //
$mailbody .= "File Link 3: $upload3_URL\n"; //
$mailbody .= "If any link is broken, please copy and paste it in your browser's address bar\n";
mail($mailto, $mailsubj, $mailbody, $mailhead);
header("Location: uploadaction.html");

navaldesign · #14 10-08-2007, 08:44 PM

This is obviously a script that you have created using pieced from here and there, but it will not work. the routine that uploads the file to your site is NOT in there. Use the code in How to upload a file using a form or use Advanced BlueVoda Form Processor or you will not be able to upload your files.

luis arana · #15 10-09-2007, 04:14 PM

Navaldesign I don´t paste all the script, now here it is complete, all files are in my public folder named uploads, thay are only not appearing in my email, just the first one, I will paste my e mail received under the php script:

<?php
// Receiving variables
@$email = addslashes($_POST['email']);
@$upload_Name = $_FILES['upload']['name'];
@$upload_Size = $_FILES['upload']['size'];
@$upload_Temp = $_FILES['upload']['tmp_name'];
@$upload2_Name = $_FILES['upload2']['name'];
@$upload2_Size = $_FILES['upload2']['size'];
@$upload2_Temp = $_FILES['upload2']['tmp_name'];
@$upload3_Name = $_FILES['upload3']['name'];
@$upload3_Size = $_FILES['upload3']['size'];
@$upload3_Temp = $_FILES['upload3']['tmp_name'];
// Validation for max file size
if ($upload_Size>0)
{
if( $upload_Size >1000000)
{
//delete file
unlink($upload_Temp);
header("Location: error.html");
exit;
}
}
if ($upload2_Size>0)
{
if( $upload2_Size >1000000)
{
//delete file
unlink($upload2_Temp);
header("Location: error.html");
exit;
}
}
if ($upload3_Size>0)
{
if( $upload3_Size >1000000)
{
//delete file
unlink($upload3_Temp);
header("Location: error.html");
exit;
}
}
if ($upload_Size>0)
{
$uploadFile = "uploads/".$upload_Name ;
@move_uploaded_file( $upload_Temp , $uploadFile);
chmod($uploadFile, 0644);
$upload_URL = "http://www.ideaspersonales.com/uploads/".$upload_Name ;
}
if ($upload2_Size>0)
{
$uploadFile = "uploads/".$upload2_Name ;
@move_uploaded_file( $upload2_Temp , $uploadFile);
chmod($uploadFile, 0644);
$upload_URL = "http://www.ideaspersonales.com/uploads/".$upload2_Name ;
}
if ($upload3_Size>0)
{
$uploadFile = "uploads/".$upload3_Name ;
@move_uploaded_file( $upload3_Temp , $uploadFile);
chmod($uploadFile, 0644);
$upload_URL = "http://www.ideaspersonales.com/uploads/".$upload3_Name ;
}
//Sending Email to form owner
$mailto = "info@ideaspersonales.com";
$mailsubj = "COTIZACION";
$mailhead = "From: $email\n";
reset ($HTTP_POST_VARS);
$mailbody = "Datos del cliente y link de archivos :\n";
while (list ($key, $val) = each ($HTTP_POST_VARS))
{
if ($key!="submit")
{
$mailbody .= "$key : $val\n";
}
}
$mailbody .= "File Link 1: $upload_URL\n";
$mailbody .= "File Link 2: $upload2_URL\n";
$mailbody .= "File Link 3: $upload3_URL\n";
$mailbody .= "If any link is broken, please copy and paste it in your browser's address bar\n";
mail($mailto, $mailsubj, $mailbody, $mailhead);
header("Location: thankyou_page.html");
?>

THIS IS THE MAIL I RECEIVED (HOW CAN I CHANGE THE ORDER THE DATA IS IN MY MAIL? THEY ARE NOT IN THE ORDER I WANT:

Datos del cliente y link de archivos :
email : foxjicuri********.com
cantidad_2 : 3
lacre2 :
cantidad3 : 6
azulejos3 :
otro_motivo_de_contacto : ll
Envíar_a_Domicilio :
tazas :
cantidad : 3
name : julio
File Link 1: http://www.ideaspersonales.com/uploads/piñas.jpg
File Link 2:
File Link 3:
If any link is broken, please copy and paste it in your browser's address bar

Thank´s for everything!
Luis Arana

navaldesign · #16 10-09-2007, 04:47 PM

Use the following:

<?php

// Set file size limit

$size_limit = 1000000; // Set it to whatever size you want in Bytes
// Receiving variables
@$email = addslashes($_POST['email']);
@$upload_Name = $_FILES['upload']['name'];
$upload_Name_Name = str_replace(" ", "_", $upload_Name);
@$upload_Size = $_FILES['upload']['size'];
@$upload_Temp = $_FILES['upload']['tmp_name'];
@$upload2_Name = $_FILES['upload2']['name'];
$upload2_Name_Name = str_replace(" ", "_", $upload2_Name);
@$upload2_Size = $_FILES['upload2']['size'];
@$upload2_Temp = $_FILES['upload2']['tmp_name'];
@$upload3_Name = $_FILES['upload3']['name'];
$upload3_Name_Name = str_replace(" ", "_", $upload3_Name);
@$upload3_Size = $_FILES['upload3']['size'];
@$upload3_Temp = $_FILES['upload3']['tmp_name'];

// Validation for existing file and max file size

if ($upload_Size>0 and $upload_Size <= $size_limit)
{
$uploadFile = "uploads/".$upload_Name ;
@move_uploaded_file( $upload_Temp , $uploadFile);
chmod($uploadFile, 0644);
$upload_URL = "http://www.ideaspersonales.com/uploads/".$upload_Name ;
}
if ($upload2_Size>0 and $upload2_Size <= $size_limit)
{
$uploadFile = "uploads/".$upload2_Name ;
@move_uploaded_file( $upload2_Temp , $uploadFile);
chmod($uploadFile, 0644);
$upload2_URL = "http://www.ideaspersonales.com/uploads/".$upload2_Name ;
}
if ($upload3_Size>0 and $upload3_Size <= $size_limit)
{
$uploadFile = "uploads/".$upload3_Name ;
@move_uploaded_file( $upload3_Temp , $uploadFile);
chmod($uploadFile, 0644);
$upload3_URL = "http://www.ideaspersonales.com/uploads/".$upload3_Name ;
}
//Sending Email to form owner
$mailto = "info@ideaspersonales.com";
$mailsubj = "COTIZACION";
$mailhead = "From: $email\n";
reset ($HTTP_POST_VARS);
$mailbody = "Datos del cliente y link de archivos :\n";
while (list ($key, $val) = each ($HTTP_POST_VARS))
{
if ($key!="submit")
{
$mailbody .= "$key : $val\n";
}
}
$mailbody .= "File Link 1: $upload_URL\n";
$mailbody .= "File Link 2: $upload2_URL\n";
$mailbody .= "File Link 3: $upload3_URL\n";
mail($mailto, $mailsubj, $mailbody, $mailhead);
header("Location: thankyou_page.html");
?>

I have changed the code so if a file name contains whitespaces (blanks) the script will replace them with an underscore, so links should not result broken anymore.

To change the order of the data in your email (as well as the TAB order of your form fields) follow this simple procedure:

Right click on the field you want first, and select "Move to front".
repeat for all fields, in the order you want them to appear. include your submit and reset buttons.

Why don't you simply use ABVFP ?

It will do what you want, without need for coding.