seanstuart

justr installed phpauction, but get this error message on index page.......... any pointers? Sean

is anyone able to help?

http://demo.linkbidscript.com/

sorry...! when a link is submitted i class it as a item

these are my other tables.. NO item table! DROP TABLE IF EXISTS `adsense`; CREATE TABLE `adsense` ( `adsenseid` int(4) NOT NULL auto_increment, `adsensecode` longtext NOT NULL, UNIQUE KEY `adsenseid` (`adsenseid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; ------------------------------------ CREATE TABLE `confset` ( `indc` int(4) NOT NULL auto_increment, `path` varchar(255) NOT NULL default '/', `paypal` varchar(255) NOT NULL default 'yourname@paypal.com', `paypalcurrency` varchar(255) NOT NULL default 'USD', `contactmail` varchar(255) NOT NULL default 'yourname@yourdomain.com', `adminmail` varchar(255) NOT NULL default 'yourname@yourdomain.com', `currency` varchar(255) NOT NULL default '1', `minbid` varchar(9) NOT NULL default '1.00', `minup` varchar(9) NOT NULL default '1.00', `currencymail` varchar(255) NOT NULL default '1', `pathmail` varchar(255) NOT NULL default '/', `frommail` varchar(255) NOT NULL default 'yourname@yourdomain.com', `contactmailsubject` varchar(255) NOT NULL default 'message from yoursite.com', `domainname` varchar(255) NOT NULL default 'www.yourdomain.com', `sitetitle` varchar(255) NOT NULL default 'Your Site Title Slogan', `custom` varchar(255) NOT NULL default '', `lbdtemplate` varchar(255) NOT NULL default 'default', `alphacat` char(1) NOT NULL default 'C', `prenabled` char(1) NOT NULL default 'Y', `screenshot` char(1) NOT NULL default 'Y', `buymailsubject` varchar(255) NOT NULL default 'Your submission at LinkBidScript.com', `buymailmessage` longtext NOT NULL, `bidmailsubject` varchar(255) NOT NULL default 'Thank you for your bid!', `bidmailmessage` longtext NOT NULL, `pr_google` char(1) NOT NULL default 'Y', `pr_yahoo` char(1) NOT NULL default 'Y', `pr_msn` char(1) NOT NULL default 'Y', `pr_alexa` char(1) NOT NULL default 'Y', `prp_latest` char(1) NOT NULL default 'Y', `prp_category` char(1) NOT NULL default 'Y', `prp_details` char(1) NOT NULL default 'Y', `prp_home` char(1) NOT NULL default 'Y', `prp_links` char(1) NOT NULL default 'Y', `prp_list` char(1) NOT NULL default 'Y', `prp_search` char(1) NOT NULL default 'Y', `cntIM` char(1) NOT NULL default 'N', UNIQUE KEY `indc` (`indc`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; ---------------------------------------------- CREATE TABLE `currency` ( `curid` int(4) NOT NULL auto_increment, `curenc` varchar(255) NOT NULL default '', `cursign` varchar(255) NOT NULL default '', UNIQUE KEY `curid` (`curid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; --------------------------------------------- CREATE TABLE `do_ban` ( `do_do` int(4) NOT NULL auto_increment, `do_ban` varchar(255) NOT NULL default '', `do_enable` varchar(255) NOT NULL default 'Y', UNIQUE KEY `do_do` (`do_do`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; ------------------------------------------ CREATE TABLE `google_cse` ( `cse_id` int(4) NOT NULL auto_increment, `cse_main` longtext, `cse_on` char(1) NOT NULL default 'Y', UNIQUE KEY `cse_id` (`cse_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; ---------------------------------------------- CREATE TABLE `ig_admin` ( `adid` int(4) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `pass` varchar(255) NOT NULL default '', `email` varchar(255) NOT NULL default '', UNIQUE KEY `adid` (`adid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=0 AUTO_INCREMENT=13 ; --------------------------------------------- CREATE TABLE `ip_ban` ( `ip_id` int(4) NOT NULL auto_increment, `ip_ip` varchar(255) NOT NULL default '', `ip_enable` varchar(255) NOT NULL default 'Y', UNIQUE KEY `ip_id` (`ip_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; ----------------------------------------------- CREATE TABLE `linknumber` ( `lnbid` int(4) NOT NULL auto_increment, `lnbhome` varchar(255) NOT NULL default '5', `lnbcategory` varchar(255) NOT NULL default '2', `lnbalphabet` varchar(255) NOT NULL default '2', `lnbtoplinks` varchar(255) NOT NULL default '30', `lnbnewlinks` varchar(255) NOT NULL default '30', UNIQUE KEY `lnbid` (`lnbid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -------------------------------------------- CREATE TABLE `main` ( `dtu` int(4) NOT NULL auto_increment, `categ` varchar(255) NOT NULL default '', `email` varchar(255) NOT NULL default '', `site` varchar(255) NOT NULL default '', `title` varchar(255) NOT NULL default '', `descr1` varchar(255) NOT NULL default '', `descr2` longtext NOT NULL, `mdesc` varchar(255) NOT NULL default '', `mword` varchar(255) NOT NULL default '', `deeptf` varchar(255) NOT NULL default 'Deep Link 1', `deepts` varchar(255) NOT NULL default 'Deep Link 2', `deeptt` varchar(255) NOT NULL default 'Deep Link 3', `dfurl` varchar(255) NOT NULL default 'http://', `dsurl` varchar(255) NOT NULL default 'http://', `dturl` varchar(255) NOT NULL default 'http://', `bid` int(4) NOT NULL default '0', `stad` date NOT NULL default '0000-00-00', `stod` date NOT NULL default '0000-00-00', `stup` date NOT NULL default '0000-00-00', `avail` varchar(255) NOT NULL default '', `paid` varchar(255) NOT NULL default '', `ujbid` varchar(255) NOT NULL default '', `maincategory` varchar(255) NOT NULL default '17', `google` varchar(255) NOT NULL default '', `yahoo` varchar(255) NOT NULL default '', `msn` varchar(255) NOT NULL default '', `alexa` varchar(255) NOT NULL default '', `pr_date` date default NULL, UNIQUE KEY `dtu` (`dtu`), KEY `bid` (`bid`), KEY `bid_2` (`bid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=154 ; --------------------------------------------

table structure..... CREATE TABLE `categorylisting` ( `catlistid` int(4) NOT NULL auto_increment, `categoryname` varchar(255) NOT NULL default '', `categtitle` varchar(255) NOT NULL default '', `categdescription` varchar(255) NOT NULL default '', `categkeyword` varchar(255) NOT NULL default '', `categenable` char(1) NOT NULL default 'Y', `categseoname` varchar(255) NOT NULL default '', `parentid` int(11) NOT NULL default '0', `categauxC` varchar(255) NOT NULL default '', UNIQUE KEY `catlistid` (`catlistid`) ) TYPE=MyISAM AUTO_INCREMENT=38 ;

my existing code looks like this........ <?php do { ?> <li><a href="<?php echo("$path");?><?php echo $row_categRL['categseoname']; ?>/"><?php echo $row_categRL['categoryname']; ?></a></li> <?php $row_categRL = mysql_fetch_assoc($categRL); if (!isset($nested_categRL)) { $nested_categRL= 1; } } while ($row_categRL); ?>

i have would like to know how to code a query..... I have a categories section and when a item is added to a category it shows a number next to it to show how many items are in that category.... blogs (1) and so on. thanks Sean!

this is how the origonal script looks at add_menu_item.php... and edit_menu_item.php will i have to these and how would i call it? <?php require_once("access.php"); require_once(LIB_PATH."Restaurant.php"); require_once(LIB_PATH."Menu.php"); require_once(LIB_PATH."MenuSection.php"); require_once(LIB_PATH."MenuItem.php"); $restaurant_id = Sanitize::data($_GET['restaurant_id'], "integer"); $menu_id = Sanitize::data($_GET['menu_id'], "integer"); $section_id = Sanitize::data($_GET['section_id'], "integer"); if($restaurant_id == 0){ $error_message = "You must select a restaurant, prior to be able to add a menu item!"; }elseif($menu_id == 0){ $error_message = "You must select a menu, prior to be able to add a menu item!"; }else{ $restaurant_obj = new Restaurant($restaurant_id); if($restaurant_obj->user_id == $_SESSION['logged_user_id']){ $menu_obj = new Menu($restaurant_id); //get the menu sections $menu_sections = MenuSection::allMenuSections($menu_obj->menu_id); if(multiArraySearchValue($menu_sections, 'section_id', $section_id) >= 0){ /** * Determinate does the form was submited. */ if($_SERVER['REQUEST_METHOD'] == "POST"){ /** * Intance the restaurant object */ $mi_obj = new MenuItem(); /** * Sanitize the posted values. */ $item_name = Sanitize::data($_POST['item_name'], "string"); $item_description = Sanitize::data($_POST['item_description'], "string"); $item_price = Sanitize::data($_POST['item_price'], "float"); $item_order = Sanitize::data($_POST['item_order'], "string"); $section_id = Sanitize::data($_POST['section_id'], "integer"); /** * Set the object properties. */ $mi_obj->setMember("item_name", $item_name); $mi_obj->setMember("item_description", $item_description); $mi_obj->setMember("item_price", $item_price); $mi_obj->setMember("item_order", $item_order); $mi_obj->setMember("section_id", $section_id); /** * Try to add the new menu section to the database. */ if($mi_obj->add($error_message)){ /** * Redirect the user to the "thank you" page. */ header("location: restaurant.php?id=$restaurant_id"); exit; } } }else{ //this menu section do not belongs to the current logged user $error_message = "You must create at least one menu section, prior to be able to add a menu item!"; } }else{ //this menu restaurant do not belongs to the current logged user header("location: index.php"); exit; } if(! $item_status) $item_status = 1; /** * Get the menu sections array. */ $menu_sections = MenuSection::allMenuSections($menu_id); $select_section = get_select_box_db('0', $section_id, "section_id", $menu_sections, 'section_name', 'section_id', '---select---', 'base', ''); } $form_title = "Add a new menu item"; $website_title = "Add menu item - ".$_SESSION['settings']['site_title']; $website_description = $_SESSION['settings']['site_description']; $site_keywords = $_SESSION['settings']['site_keywords']; require_once(WEB_TEMPLATES."HeaderTemplate.php"); require_once(WEB_TEMPLATES."MenuItemManageTemplate.php"); require_once(WEB_TEMPLATES."FooterTemplate.php"); ?>

I am working with a CMS Restaurant system, I would like to allow owners to have an option to select currency type e.g [ $,£ and €, ] what would be the easyest way to achieve this without having to edit lots of files? regards Sean

if (isset($_POST['sb1'])){ form now displays, but still just clears input fields.... ???

is this correct, as i get a blank screen..... if (isset($_POST['sb1'] == "submit")){ sean

I try to login to admin, but when I submit form it just clears its self???? form code.... <?php include_once("../lib/config.php"); include_once(LIB_PATH."Admin.php"); /** * Set the variable, which holds the error message, to an empty variable. */ $error = ""; if($_SERVER['REQUEST_METHOD'] == "POST"){ /** * Sanitize the posted data - remove any html code, if submited, remove "whote" spaces, cast to "string" data type. */ $admin_username = Sanitize::data($_POST['admin_username'], 'string'); $admin_password = Sanitize::data($_POST['admin_password'], 'string'); if(empty($admin_username)){ $error = "Type your username, please!"; }elseif(empty($admin_password)){ $error = "Type your password, please!"; }else{ $admin_obj = new Admin(); if($admin_obj->login($admin_username, $admin_password, &$error)){ //the user is logged successfully, redirect him to the protected area header("location: index.php"); exit; } } } ?> <html> <head> <title>Admin area</title> <link href="../public/style/admin_styles.css" type="text/css" rel="stylesheet" /> </head> <body> <form method="post" action="login.php"> <table align="center" style="margin-top: 10%" class="base"> <tr> <td colspan="2" align="center" class="title">Admin Login Form</td> </tr> <tr> <td colspan="2" align="center" class="error"><?php echo $error; ?></td> </tr> <tr> <td>Username:</td> <td><input type="text" name="admin_username" size="25" value="<?php echo $admin_username; ?>" /></td> </tr> <tr> <td>Password:</td> <td><input type="password" name="admin_password" size="25" /></td> </tr> <tr> <td> </td> <td><input type="submit" name="sb1" value="Submit" /></td> </tr> <tr> <td colspan="2" style="padding-top: 30px"> <a href="forgot_password.php" class="base_link">Forgot password?</a> </td> </tr> </table> </form> </body> </html> admin.php......... <?php include("config.php"); /** * This class is created to handle the admin user functionalities, such as login, forgot password, edit profile. * * @package Takeout&Delivery Module * @author Venelin Manchev * @link http://www.php-developers.net * @version 0.1 */ class Admin { /** * Admin Id number */ var $admin_id; /** * Admin username */ var $admin_username; /** * Admin password */ var $admin_password; /** * Admin email address */ var $admin_email; function Admin($id= 0){ /** * Get the database connection. */ global $db; if($id > 0){ /** * Build the SQL query to grab the admin user info and to set the object properties. */ $sql = "SELECT * from tdm_admin where admin_id = '$id' "; if(!$db->Query($sql)){ logMyErrors(__FILE__, __CLASS__, __METHOD__, __LINE__, $db->Error()); return false; }else{ $admin_array = $db->RecordsArray(MYSQL_ASSOC); if(is_array($admin_array)){ if(count($admin_array) == 1){ foreach($admin_array['0'] as $key=>$value){ $this->$key = $value; } }else{ return false; } } } } } /** * Admin login functionality * * @param string $username Admin username value, posted via the login form. * @param string $password Admin password value, posted via the login form. * @param string &$error_message Error message on failure, passed by reference. * @return boolean True on success, False on failure. If true, a session variable admin_id will hold the admin id number value. */ function login($username, $password, &$error_message) { /** * Get the database connection */ global $db; $sql = "SELECT admin_id, admin_password from tdm_admin where admin_username = '$username' "; if(!$db->Query($sql)){ logMyErrors(__FILE__, __CLASS__, __METHOD__, __LINE__, $db->Error()); return false; }else{ $db->MoveFirst(); $result_data = $db->Row(); if($result_data->admin_id > 0){ if($result_data->admin_password != md5($password)){ $error_message = "Wrong password!"; return false; }else{ $_SESSION['admin_id'] = $result_data->admin_id; return true; } }else{ $error_message = "Wrong username!"; return false; } } } /** * Admin logout functionality * * @return boolean True on successful logout, false otherwise. */ function logout() { session_unset("admin_id"); session_unregister("admin_id"); session_destroy(); } /** * Update an admin account * * @param int $admin_id Admin account id number to update. * @param string &$error Error message text, passed by reference. * @return boolean True on success, false otherwise. */ function updateAdmin($admin_id, &$error){ /** * Get the database connection */ global $db; /** * Validate the posted data. */ if(empty($this->admin_username)){ $error = "Type the username, please!"; return false; }elseif(empty($this->p1)){ $error = "Type the password, please!"; return false; }elseif(empty($this->p2)){ $error = "Confirm the password, please!"; return false; }elseif($this->p1 != $this->p2){ $error = "Retype and confirm the password, please!"; return false; }elseif(!checkEmailAddress($this->admin_email)){ $error = "Type a correct email address, please!"; return false; }else{ /** * Build the SQL query string. */ $sql = "UPDATE tdm_admin set admin_username = '$this->admin_username', admin_password = MD5('$this->p1'), admin_email = '$this->admin_email' "; if(!$db->Query($sql)){ $error = $db->Error(); return false; }else{ return true; } } } /** * Set a new value for object property. */ function setMember($name, $value) { $this->$name = $value; } /** * This method handle the forgot password process. * * The admin user must submit his username. In case of match, the system will generate a new password, will assign it as MD5-encripted hash to the admin account and will send an email to the admin email address with the new password. * *@param string $username Admin username value, submited via the forgot password form. *@param string &$error_message Error message text, passed by reference. *@return boolean True on success, false otherwise. */ function forgotPassword($username, &$error_message) { /** * Get the database connection. */ global $db; $sql = "select * from tdm_admin where admin_username = '$username' "; if(!$db->Query($sql)){ logMyErrors(__FILE__, __CLASS__, __METHOD__, __LINE__, $db->Error()); }else{ $db->MoveFirst(); $result_data = $db->Row(); if($result_data->admin_id > 0){ //generate the new password $new_password = self::generatePassword(); //save the new password $sql = "update tdm_admin set admin_password = MD5('$new_password') where admin_id = '$result_data->admin_id' "; if(!$db->Query($sql)){ logMyErrors(__FILE__, __CLASS__, __METHOD__, __LINE__, $db->Error()); }else{ //get the TXT template $txt_template = file_get_contents(EMAIL_TEMPLATES."admin_forgot.txt"); //setup the template variables $tpl_variables = array("{website}", "{username}", "{password}", "{login_url}"); //setup the template values $tpl_values = array(WEBSITE_DOMAIN, $username, $new_password, ADMIN_LOGIN_URL); //parse the template $txt_message = str_replace($tpl_variables, $tpl_values, $txt_template); //send the new password sendMime($_SESSION['settings']['contact_email'], $_SESSION['settings']['contact_email'], $result_data->admin_email, '', '', 3, 'New password', $txt_message, $html_message); return true; } }else{ $error_message = "Wrong username!"; return false; } } } /** * This method generate a new password. * * In case of forgotten password, we need a new one, geenrated on a random manier. * @access private * @return string New password string. */ function generatePassword() { //generate a random md5 hash $md5_hash = md5(crypt(time())); //the password should be no more than 6 chars in length $new_password = substr($md5_hash, 0, 6); return $new_password; } } ?> >

my version of mysql did not like .................... ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=2 ; now sorted thanks..... Sean

I get a #1064 sytax error::::: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'collate latin1_general_ci NOT NULL default '', `admin_passwo -- -- Table structure for table `tdm_admin` -- CREATE TABLE `tdm_admin` ( `admin_id` int(10) NOT NULL auto_increment, `admin_username` varchar(100) collate latin1_general_ci NOT NULL default '', `admin_password` varchar(32) collate latin1_general_ci NOT NULL default '', `admin_email` varchar(255) collate latin1_general_ci NOT NULL default '', PRIMARY KEY (`admin_id`), KEY `admin_username` (`admin_username`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=2 ; -- -- Dumping data for table `tdm_admin` -- INSERT INTO `tdm_admin` VALUES (1, 'admin', '21232f297a57a5a743894a0e4a801fc3', 'support@php-developers.net'); -- -------------------------------------------------------- [code] regards Sean [/code]

error in log [Tue Jan 01 17:46:08 2008] [error] PHP Notice: Undefined variable: sql_mode in c:\\AppServ\\www\\freelance\\act.php on line 5 [Tue Jan 01 17:46:08 2008] [error] PHP Notice: Undefined variable: sql_mode in c:\\AppServ\\www\\freelance\\act.php on line 15 [Tue Jan 01 17:46:08 2008] [error] PHP Notice: Undefined variable: sql_mode in c:\\AppServ\\www\\freelance\\act.php on line 25 [Tue Jan 01 17:46:09 2008] [error] PHP Notice: Undefined variable: sql_mode in c:\\AppServ\\www\\freelance\\act.php on line 5 [Tue Jan 01 17:46:09 2008] [error] PHP Notice: Undefined variable: sql_mode in c:\\AppServ\\www\\freelance\\act.php on line 15 [Tue Jan 01 17:46:09 2008] [error] PHP Notice: Undefined variable: sql_mode in c:\\AppServ\\www\\freelance\\act.php on line 25 [Tue Jan 01 17:46:09 2008] [error] PHP Notice: Undefined variable: sql_mode in c:\\AppServ\\www\\freelance\\act.php on line 5 [Tue Jan 01 17:46:09 2008] [error] PHP Notice: Undefined variable: sql_mode in c:\\AppServ\\www\\freelance\\act.php on line 15 [Tue Jan 01 17:46:09 2008] [error] PHP Notice: Undefined variable: sql_mode in c:\\AppServ\\www\\freelance\\act.php on line 25 [Tue Jan 01 17:46:09 2008] [error] PHP Notice: Undefined variable: sql_mode in c:\\AppServ\\www\\freelance\\act.php on line 5 [Tue Jan 01 17:46:09 2008] [error] PHP Notice: Undefined variable: sql_mode in c:\\AppServ\\www\\freelance\\act.php on line 15 [Tue Jan 01 17:46:09 2008] [error] PHP Notice: Undefined variable: sql_mode in c:\\AppServ\\www\\freelance\\act.php on line 25 [Tue Jan 01 17:46:09 2008] [error] PHP Notice: Undefined variable: sql_mode in c:\\AppServ\\www\\freelance\\act.php on line 5 [Tue Jan 01 17:46:09 2008] [error] PHP Notice: Undefined variable: sql_mode in c:\\AppServ\\www\\freelance\\act.php on line 15 [Tue Jan 01 17:46:09 2008] [error] PHP Notice: Undefined variable: sql_mode in c:\\AppServ\\www\\freelance\\act.php on line 25 [Tue Jan 01 17:46:10 2008] [error] PHP Notice: Undefined variable: sql_mode in c:\\AppServ\\www\\freelance\\act.php on line 5 [Tue Jan 01 17:46:10 2008] [error] PHP Notice: Undefined variable: sql_mode in c:\\AppServ\\www\\freelance\\act.php on line 15 [Tue Jan 01 17:46:10 2008] [error] PHP Notice: Undefined variable: sql_mode in c:\\AppServ\\www\\freelance\\act.php on line 25 [Tue Jan 01 17:46:10 2008] [error] PHP Notice: Undefined variable: sql_mode in c:\\AppServ\\www\\freelance\\act.php on line 5 [Tue Jan 01 17:46:10 2008] [error] PHP Notice: Undefined variable: sql_mode in c:\\AppServ\\www\\freelance\\act.php on line 15 [Tue Jan 01 17:46:10 2008] [error] PHP Notice: Undefined variable: sql_mode in c:\\AppServ\\www\\freelance\\act.php on line

part2 of admin_install.php code <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: deposit2checkout<br> Description: 2Checkout deposit mode configures PHP Freelancers to allow users to deposit money into their account by a secure 2Checkout credit card payment (you must first have a 2Checkout account).<br> Recommended: Enabled<br> <select name="newdeposit2checkout"><option ' . $yyy . ' value="enabled"> Enabled <option ' . $nnn . ' value=""> Disabled </select> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: depositpaypal<br> Description: PayPal deposit mode configures PHP Freelancers to allow users to deposit money into their account by a secure PayPal credit or debit card payment (you must first have a PayPal account which you provided in the variable "ppemailaddr").<br> Recommended: Enabled<br> <select name="newdepositpaypal"><option ' . $yyyy . ' value="enabled"> Enabled <option ' . $nnnn . ' value=""> Disabled </select> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: depositnotify<br> Description: Deposit notify mode configures PHP Freelancers to send you an email whenever a user makes a PayPal (if enabled) or 2Checkout (if enabled) money deposit into their account.<br> Recommended: Enabled<br> <select name="newdepositnotify"><option ' . $yyyyy . ' value="enabled"> Enabled <option ' . $nnnnn . ' value=""> Disabled </select> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: depositccurl<br> Description: If you did not want to use 2Checkout, but do want to use some other credit card processor for deposits, provide the complete URL/web address here. The deposit will not automatically <br> [amount] will be replaced by the total deposit amount including fees.<br> [username] will be replaced by the username of the user making the deposit.<br> [type] will be replaced by the user\'s account type.<br> Example: http://www.mypayment processor.com/cgi-bin/purchase.cgi?uid=12345&total=[amount]&customer=[username]&acctype=[type]<br> <input type="text" name="newdepositccurl" size="63" value="' . $depositccurl . '"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: depositccper<br> Description: If you enabled 2Checkout or some other credit card processor for deposits, provide the percentage fee which will be added to the deposit amount before paying.<br> Example: 5.5<br> <input type="text" name="newdepositccper" size="6" value="' . $depositccper . '"> % </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: depositccfee<br> Description: If you enabled 2Checkout or some other credit card processor for deposits, provide the pure dollar fee which will be added to the deposit amount before paying.<br> Example: 0.45<br> ' . $currencytype . '' . $currency . ' <input type="text" name="newdepositccfee" size="6" value="' . $depositccfee . '"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: depositccpay<br> Description: If you enabled 2Checkout deposits, provide the URL to where the payment will be processed (DO NOT include the sid). The URL should match the one supplied in the example but this is just incase it ever changes.<br> Example: https://www.2checkout.com/cgi-bin/buyers/cartpurchase1.2c?sid=<br> <input type="text" name="newdepositccpay" size="63" value="' . $depositccpay . '"> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: depositccsid<br> Description: If you enabled 2Checkout deposits, you must provide your sid for the deposit amount to be transferred into your 2Checkout account when the user makes the payment.<br> Example: 14387<br> <input type="text" name="newdepositccsid" size="6" value="' . $depositccsid . '"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: depositccaut<br> Description: If you enabled 2Checkout deposits, the 2Checkout automatic deposit configures PHP Freelancers to get the amount (without fees) the user depositted and to automatically be added to the users\' account.<br> Recommended: Disabled<br> <select name="newdepositccaut"><option ' . $yyyyyy . ' value="enabled"> Enabled <option ' . $nnnnnn . ' value=""> Disabled </select> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: depositppper<br> Description: If you enabled PayPal deposits, provide the percentage fee which will be added to the deposit amount before paying.<br> Example: 2.9<br> <input type="text" name="newdepositppper" size="6" value="' . $depositppper . '"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: depositppfee<br> Description: If you enabled PayPal deposits, provide the pure dollar fee which will be added to the deposit amount before paying.<br> Example: 0.30<br> ' . $currencytype . '' . $currency . ' <input type="text" name="newdepositppfee" size="6" value="' . $depositppfee . '"> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: depositppaut<br> Description: If you enabled PayPal deposits, the PayPal automatic deposit configures PHP Freelancers to get the amount (without fees) the user depositted and to automatically be added to the users\' account.<br> Recommended: Disabled<br> <select name="newdepositppaut"><option ' . $yyyyyyy . ' value="enabled"> Enabled <option ' . $nnnnnnn . ' value=""> Disabled </select> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: depositmail<br> Description: Mail deposit mode configures PHP Freelancers to allow users to deposit money into their account by check (all information needed are the address variables and companyname).<br> Recommended: Enabled<br> <select name="newdepositmail"><option ' . $yyyyyyyy . ' value="enabled"> Enabled <option ' . $nnnnnnnn . ' value=""> Disabled </select> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: depositmlfee<br> Description: If you enabled check deposits, provide the pure dollar fee which will be added to the deposit amount before paying.<br> Example: 1<br> ' . $currencytype . '' . $currency . ' <input type="text" name="newdepositmlfee" size="6" value="' . $depositmlfee . '"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: depositother<br> Description: Other deposit mode configures PHP Freelancers to allow users to deposit money into their account by some other deposit method you specify (if you enable this, be sure to upload a file named "payment.php" to the directory inwhich PHP Freelancers is, containing the details of the other deposit method, and how to use it).<br> Recommended: Disabled<br> <select name="newdepositother"><option ' . $yyyyyyyyy . ' value="enabled"> Enabled <option ' . $nnnnnnnnn . ' value=""> Disabled </select> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: feedbackcmax<br> Description: The maximum number of characters a user can type as feedback when providing feedback on another user.<br> Example: 500<br> <input type="text" name="newfeedbackcmax" size="6" value="' . $feedbackcmax . '"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: projectper<br> Description: The percentage of a "freelancers" bid that is charged as a project commission fee to their account, this is split in half if they are a "guarenteed programmer", and the commission fee that is charged is this or projectfee, whichever is greater.<br> Example: 12<br> <input type="text" name="newprojectper" size="3" value="' . $projectper . '"> % </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: projectfee<br> Description: The pure dollar ammount that is charged as a project commission fee to the winning bidder\'s account, this is split in half if they are a "guarenteed programmer", and the commission fee that is charged is this or projectper, whichever is greater.<br> Example: 8<br> ' . $currencytype . '' . $currency . ' <input type="text" name="newprojectfee" size="5" value="' . $projectfee . '"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: projectper2<br> Description: The percentage of a "freelancers" bid that is charged as a project commission fee to the project creator\'s account, this is split in half if they are a "guarenteed webmaster", and the commission fee that is charged is this or projectfee2, whichever is greater.<br> Example: 7<br> <input type="text" name="newprojectper2" size="3" value="' . $projectper2 . '"> % </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: projectfee2<br> Description: The pure dollar ammount that is charged as a project commission fee to the project creator\'s account, this is split in half if they are a "guarenteed webmaster", and the commission fee that is charged is this or projectper2, whichever is greater.<br> Example: 2<br> ' . $currencytype . '' . $currency . ' <input type="text" name="newprojectfee2" size="5" value="' . $projectfee2 . '"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: withdrawcfee<br> Description: The pure dollar amount that is charged (subtracted from the total withdrawal) when a user withdraws money from their account by check.<br> Example: 1<br> ' . $currencytype . '' . $currency . ' <input type="text" name="newwithdrawcfee" size="3" value="' . $withdrawcfee . '"> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: withdrawpaypal<br> Description: PayPal withdraw mode configures PHP Freelancers to allow users to withdraw money from their account by a secure PayPal credit or debit card payment (you must first have a PayPal account).<br> Recommended: Enabled<br> <select name="newwithdrawpaypal"><option ' . $yyyyyyyyyy . ' value="enabled"> Enabled <option ' . $nnnnnnnnnn . ' value=""> Disabled </select> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: withdrawpfee<br> Description: If you enabled the PayPal withdraw mode, provide the pure dollar amount that is charged (subtracted from the total withdrawal) when a user withdraws money from their account by PayPal.<br> Example: 1<br> ' . $currencytype . '' . $currency . ' <input type="text" name="newwithdrawpfee" size="4" value="' . $withdrawpfee . '"> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: withdrawwire<br> Description: Bank wire withdraw mode configures PHP Freelancers to allow users to withdraw money from their account by a secure bank wire payment (you must first have a bank account).<br> Recommended: Enabled<br> <select name="newwithdrawwire"><option ' . $yyyyyyyyyyy . ' value="enabled"> Enabled <option ' . $nnnnnnnnnnn . ' value=""> Disabled </select> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: withdrawwfee<br> Description: If you enabled the bank wire withdraw mode, provide the pure dollar amount that is charged (subtracted from the total withdrawal) when a user withdraws money from their account by bank wire.<br> Example: 20<br> ' . $currencytype . '' . $currency . ' <input type="text" name="newwithdrawwfee" size="6" value="' . $withdrawwfee . '"> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: withdrawother<br> Description: Other withdraw mode configures PHP Freelancers to allow users to withdraw money from their account by an other payment (you must first in most cases have an account with them).<br> Recommended: Enabled<br> <select name="newwithdrawother"><option ' . $yyyyyyyyyyyy . ' value="enabled"> Enabled <option ' . $nnnnnnnnnnnn . ' value=""> Disabled </select> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: withdrawofee<br> Description: If you enabled the other withdraw mode, provide the pure dollar amount that is charged (subtracted from the total withdrawal) when a user withdraws money from their account by other means.<br> Example: 1<br> ' . $currencytype . '' . $currency . ' <input type="text" name="newwithdrawofee" size="6" value="' . $withdrawofee . '"> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: withdrawonam<br> Description: If you enabled the other withdraw mode, provide the name of this other withdraw mode that users will see and be able to choose from.<br> Example: Western Union Transfer<br> <input type="text" name="newwithdrawonam" size="38" value="' . $withdrawonam . '"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: withdrawoins<br> Description: If you enabled the other withdraw mode, provide the instructions that users will have to follow of what to insert into an input box when they choose the other withdraw mode for a withdrawal.<br> Example: Provide your name and address please.<br> <textarea name="newwithdrawoins" rows="8" cols="52" wrap="off">' . $withdrawoins . '</textarea> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: withdrawmini<br> Description: Choose the minimum withdraw amount a user can specify to make a withdrawal.<br> Example: 25<br> ' . $currencytype . '' . $currency . ' <input type="text" name="newwithdrawmini" size="5" value="' . $withdrawmini . '"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: withdrawnotify<br> Description: Withdraw notify mode configures PHP Freelancers to notify you whenever a user makes a withdrawal request.<br> Recommended: Enabled<br> <select name="newwithdrawnotify"><option ' . $yyyyyyyyyyyyy . ' value="enabled"> Enabled <option ' . $nnnnnnnnnnnnn . ' value=""> Disabled </select> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: multiplecats<br> Description: Multiple category mode configures PHP Freelancers to allow "freelancers" to choose multiple categories to be experts of, and project creator\'s can choose multiple categories for their projects.<br> Recommended: Enabled<br> <select name="newmultiplecats"><option ' . $yyyyyyyyyyyyyy . ' value="enabled"> Enabled <option ' . $nnnnnnnnnnnnnn . ' value=""> Disabled </select> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: featuredcost<br> Description: This is the cost that will be subtracted from a user\'s account balance if they want their project to be listed as a featured one. Example: 10<br> ' . $currencytype . '' . $currency . ' <input type="text" name="newfeaturedcost" size="5" value="' . $featuredcost . '"> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: mprojectdays<br> Description: The maximum number of days that a project creator can enter for how long they can wait for the project completion and when the project will expire.<br> Example: 90<br> <input type="text" name="newmprojectdays" size="5" value="' . $mprojectdays . '"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: projectudays<br> Description: The days when a project will be classed as "urgent" and will display an urgent image beside the project name.<br> Example: 0-1-2-3<br> This example shows that if the project only has 0-3 days until expiry, it will display the urgent image beside the name.<br> <textarea name="newprojectudays" rows="8" cols="52" wrap="off">' . $projectudays . '</textarea> "> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: forumnextnum<br> Description: The number of subjects on the main message board to be showed per page.<br> Example: 25<br> <input type="text" name="newforumnextnum" value="' . $forumnextnum . '" size="3"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: maxextend<br> Description: The maximum amount of days a project can be extended at a time.<br> Example: 7<br> <input type="text" name="newmaxextend" value="' . $maxextend . '" size="3"> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: userportfolio<br> Description: User Portfolio mode configures PHP Freelancers to allow freelancers to upload images/screenshots of their previous works to their profile.<br> Recommended: Disabled<br> <select name="newuserportfolio"><option ' . $yyyyyyyyyyyyyyy . ' value="enabled"> Enabled <option ' . $nnnnnnnnnnnnnnn . ' value=""> Disabled </select> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: refreturn1<br> Description: The URL to where a user will be redirected once they follow a Buyer referal link and a cookie has been set.<br> Example: http://' . $HTTP_HOST . '<br> <input type="text" name="newrefreturn1" value="' . $refreturn1 . '" size="45"> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: refreturn2<br> Description: The URL to where a user will be redirected once they follow a Freelancer referal link and a cookie has been set.<br> Example: http://' . $HTTP_HOST . '<br> <input type="text" name="newrefreturn2" value="' . $refreturn2 . '" size="45"> </font></div></td> </tr> <tr> <td bgcolor="#005075" align="center" valign="middle"> <input type="submit" name="submit" value="Update Setup Variables"> </font></td> </tr> </table> </form> <form action="index.php" method="post"> <input type="hidden" name="pass" value="' . $pass . '"> <input type="submit" value="Back to Admin..."> </font> </form> </center> </body> </html>'; } else { SQLact("query", "DELETE FROM freelancers_cats"); SQLact("query", "UPDATE freelancers_setup SET siteurl='$newsiteurl', toplayout='$newtoplayout', bottomlayout='$newbottomlayout', emailheader='$newemailheader', emailfooter='$newemailfooter', emailaddress='$newemailaddress', companyname='$newcompanyname', fsbamount='$newfsbamount', bsbamount='$newbsbamount', frefamount='$newfrefamount', brefamount='$newbrefamount', address='$newaddress', city='$newcity', state='$newstate', zipcode='$newzipcode', currency='$newcurrency', currencytype='$newcurrencytype', buyer='$newbuyer', buyers='$newbuyers', freelancer='$newfreelancer', freelancers='$newfreelancers', mode='$newmode', adminpass='$newadminpass', attachmode='$newattachmode', attachmaxi='$newattachmaxi', attachpath='$newattachpath', attachurl='$newattachurl', catname='$newcatname', pcat1='$newpcat1', pcat1val='$newpcat1val', pcat2='$newpcat2', pcat2val='$newpcat2val', pcat3='$newpcat3', pcat3val='$newpcat3val', balexpdays='$newbalexpdays', balmaxdays='$newbalmaxdays', tableborder='$newtableborder', tablecellsp='$newtablecellsp', tablecellpa='$newtablecellpa', tablecolort='$newtablecolort', tablecolorh='$newtablecolorh', tablecolor1='$newtablecolor1', tablecolor2='$newtablecolor2', ppemailaddr='$newppemailaddr', deposit2checkout='$newdeposit2checkout', depositpaypal='$newdepositpaypal', depositnotify='$newdepositnotify', depositccurl='$newdepositccurl', depositccper='$newdepositccper', depositccfee='$newdepositccfee', depositccpay='$newdepositccpay', depositccsid='$newdepositccsid', depositccaut='$newdepositccaut', depositppper='$newdepositppper', depositppfee='$newdepositppfee', depositppaut='$newdepositppaut', depositmail='$newdepositmail', depositmlfee='$newdepositmlfee', depositother='$newdepositother', feedbackcmax='$newfeedbackcmax', projectper='$newprojectper', projectfee='$newprojectfee', projectper2='$newprojectper2', projectfee2='$newprojectfee2', withdrawcfee='$newwithdrawcfee', withdrawpaypal='$newwithdrawpaypal', withdrawpfee='$newwithdrawpfee', withdrawwire='$newwithdrawwire', withdrawwfee='$newwithdrawwfee', withdrawother='$newwithdrawother', withdrawofee='$newwithdrawofee', withdrawonam='$newwithdrawonam', withdrawoins='$newwithdrawoins', withdrawmini='$newwithdrawmini', withdrawnotify='$newwithdrawnotify', multiplecats='$newmultiplecats', featuredcost='$newfeaturedcost', mprojectdays='$newmprojectdays', projectudays='$newprojectudays', forumnextnum='$newforumnextnum', maxextend='$newmaxextend', userportfolio='$newuserportfolio', refreturn1='$newrefreturn1', refreturn2='$newrefreturn2'"); $categories = explode("~", $newcategories); for ($i=0;$i<count($categories);$i++) { SQLact("query", "INSERT INTO freelancers_cats (categories) VALUES ('" . $categories[$i] . "')"); } echo '<center> Setup Variables successfully updated.<br> <form action="admin_install.php" method="post"> <input type="hidden" name="pass" value="' . $newadminpass . '"> <input type="submit" value="Back to Setup Variables Customization..."> </form><br><br> <form action="index.php" method="post"> <input type="hidden" name="pass" value="' . $pass . '"> <input type="submit" value="Back to Admin..."> </form> </center>'; } } ?>

<?php require "../vars.php"; require "../cron.php"; if (!$pass || $pass !== $adminpass) { echo '<html> <head> <title> Access Unauthorized </title> </head> <body> <font color="red"><b>Access Denied: You are not authorized to view this page.</b></font> </body> </html>'; } else { if (!$submit) { if ($mode == "demo") { $y = "SELECTED"; } else { $n = "SELECTED"; } if ($attachmode == "enabled") { $yy = "SELECTED"; } else { $nn = "SELECTED"; } if ($deposit2checkout == "enabled") { $yyy = "SELECTED"; } else { $nnn = "SELECTED"; } if ($depositpaypal == "enabled") { $yyyy = "SELECTED"; } else { $nnnn = "SELECTED"; } if ($depositnotify == "enabled") { $yyyyy = "SELECTED"; } else { $nnnnn = "SELECTED"; } if ($depositccaut == "enabled") { $yyyyyy = "SELECTED"; } else { $nnnnnn = "SELECTED"; } if ($depositppaut == "enabled") { $yyyyyyy = "SELECTED"; } else { $nnnnnnn = "SELECTED"; } if ($depositmail == "enabled") { $yyyyyyyy = "SELECTED"; } else { $nnnnnnnn = "SELECTED"; } if ($depositother == "enabled") { $yyyyyyyyy = "SELECTED"; } else { $nnnnnnnnn = "SELECTED"; } if ($withdrawpaypal == "enabled") { $yyyyyyyyyy = "SELECTED"; } else { $nnnnnnnnnn = "SELECTED"; } if ($withdrawwire == "enabled") { $yyyyyyyyyyy = "SELECTED"; } else { $nnnnnnnnnnn = "SELECTED"; } if ($withdrawother == "enabled") { $yyyyyyyyyyyy = "SELECTED"; } else { $nnnnnnnnnnnn = "SELECTED"; } if ($withdrawnotify == "enabled") { $yyyyyyyyyyyyy = "SELECTED"; } else { $nnnnnnnnnnnnn = "SELECTED"; } if ($multiplecats == "enabled") { $yyyyyyyyyyyyyy = "SELECTED"; } else { $nnnnnnnnnnnnnn = "SELECTED"; } if ($userportfolio == "enabled") { $yyyyyyyyyyyyyyy = "SELECTED"; } else { $nnnnnnnnnnnnnnn = "SELECTED"; } $result = SQLact("query", "SELECT * FROM freelancers_cats"); while ($row=@SQLact("fetch_array", $result)) { $categories .= '~' . $row[categories]; } $categories = substr($categories, 1); echo ' <html lang="en-us"> <head> <title> Customize Setup Variables </title> <style type="text/css"> <!-- .line {background-color: #005075} a { text-decoration: none} a:hover { color: 00C3E9; text-decoration: underline} td {font-family:tahoma, verdana, helvetica, arial; font-size:11; font-weight:regular; text-decoration:none} --> </style> <script language="JavaScript" type="text/javascript"> function stopError() { return false; } window.onError=stopError(); </script> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"></head> <body bgcolor="#FFFFFF"> <center> Customize Setup Variables</font><br> <br> </font> <form action="index.php" method="post"> <input type="hidden" name="pass" value="' . $pass . '"> <input type="submit" value="Back to Admin..."> </font> </form> <form action="admin_install.php" method="post"> <input type="hidden" name="pass" value="' . $pass . '"> </font> <table width="598" border="0" cellspacing="0" cellpadding="15"> <tr> <td width="592" align="center" valign="middle" bgcolor="#D5D6D8"> <div align="left">Name: siteurl<br> Description: The complete directory URL to PHP Freelancers (DO NOT include the trailing slash).<br> Example: ' . $siteurl . '<br> <input type="text" name="newsiteurl" size="60" value="' . $siteurl . '"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: emailheader<br> Description: The contents of the header which will be placed on the top of all emails sent by PHP Freelancers (HTML tags aren\'t allowed). In all emails sent by PHP Freelancers, below this email header will be "----------", followed by the message contents.<br> Example: E-Mail Header<br> <textarea name="newemailheader" rows="8" cols="52" wrap="off">' . $emailheader . '</textarea> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: emailfooter<br> Description: The contents of the footer which will be placed on the bottom of all emails sent by PHP Freelancers (HTML tags aren\'t allowed). In all emails sent by PHP Freelancers, above this email footer will be "----------", and then the message contents.<br> Example: E-Mail Footer<br> <textarea name="newemailfooter" rows="8" cols="52" wrap="off">' . $emailfooter . '</textarea> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: emailaddress<br> Description: The main email address that you want to use for all matters involving PHP Freelance and emails.<br> Example: you@you.com<br> <input type="text" name="newemailaddress" size="45" value="' . $emailaddress . '"> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: companyname<br> Description: The name of your company/organization that will be used as the default website name of everything.<br> Example: Freelance Web<br> <input type="text" name="newcompanyname" size="35" value="' . $companyname . '"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: fsbamount<br> Description: The account signup bonus that "freelancers" will receive when they create an account at your website (a decimal is allowed).<br> Example: 1.00<br> ' . $currencytype . '' . $currency . ' <input type="text" name="newfsbamount" size="9" value="' . $fsbamount . '"> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: bsbamount<br> Description: The account signup bonus that "buyers" will receive when they create an account at your website (a decimal is allowed).<br> Example: 2.50<br> ' . $currencytype . '' . $currency . ' <input type="text" name="newbsbamount" size="9" value="' . $bsbamount . '"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: frefamount<br> Description: The referal amount a user will receive when they refer a "freelancer" and the "freelancer" successfully creates an account at your website (a decimal is allowed).<br> Example: 0.25<br> ' . $currencytype . '' . $currency . ' <input type="text" name="newfrefamount" size="9" value="' . $frefamount . '"> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: brefamount<br> Description: The referal amount a user will receive when they refer a "buyer" and the "buyer" successfully creates at your website (a decimal is allowed).<br> Example: 1<br> ' . $currencytype . '' . $currency . ' <input type="text" name="newbrefamount" size="9" value="' . $brefamount . '"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: address<br> Description: If you choose to allow deposits by check, this is the street address where the check will be sent to.<br> Example: #1-999 Terror Ave.<br> <input type="text" name="newaddress" size="48" value="' . $address . '"> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: city<br> Description: If you choose to allow deposits by check, this is the city where the check will be sent to.<br> Example: Terrorville<br> <input type="text" name="newcity" size="30" value="' . $city . '"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: state<br> Description: If you choose to allow deposits by check, this is the state/province where the check will be sent to (abbreviations allowed).<br> Example: Tekno Terrors<br> <input type="text" name="newstate" size="23" value="' . $state . '"> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: zipcode<br> Description: If you choose to allow deposits by check, this is the zip/postal code where the check will be sent to.<br> Example: Z9Z 9Z9<br> <input type="text" name="newzipcode" size="20" value="' . $zipcode . '"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: currency<br> Description: The currency symbol of all money amounts shown on pages of PHP Freelancers.<br> Example: $<br> <input type="text" name="newcurrency" size="3" value="' . $currency . '"> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: currencytype<br> Description: The type of the currency of all money amounts shown on pages of PHP Freelancers (leave this blank if there aren\'t multiple types of your selected currency).<br> Example: US<br> <input type="text" name="newcurrencytype" size="8" value="' . $currencytype . '"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: buyer<br> Description: The official name that all "buyers" will be represented by.<br> Example: Buyer<br> <input type="text" name="newbuyer" size="17" value="' . $buyer . '"> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: buyers<br> Description: The plural version of the official name that all "buyers" will be represented by.<br> Example: Buyer<font color="red">s</font><br> <input type="text" name="newbuyers" size="19" value="' . $buyers . '"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: freelancer<br> Description: The official name that all "freelancers" will be represented by.<br> Example: Freelancer<br> <input type="text" name="newfreelancer" size="22" value="' . $freelancer . '"> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: freelancers<br> Description: The plural version of the official name that all "freelancers" will be represented by.<br> Example: Freelancer<font color="red">s</font><br> <input type="text" name="newfreelancers" size="24" value="' . $freelancers . '"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: mode<br> Description: Demo mode configures PHP Freelancers to run in "test" mode, meaning that no deposits will actually be charged, attachments will not be allowed, etc.<br> Recommended: Disabled<br> <select name="newmode"><option ' . $y . ' value="demo"> Enabled <option ' . $n . ' value=""> Disabled </select> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: adminpass<br> Description: The only password which will be allowed to access the admin pages (index.php and admin_install.php).<br> Example: mypass999<br> <input type="text" name="newadminpass" size="11" value="' . $adminpass . '"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: attachmode<br> Description: Attach mode configures PHP Freelancer to allow "buyers" to upload files that are relevant to their project when creating a new project. This often involves a need for a lot of diskspace on your website.<br> Recommended: Disabled<br> <select name="newattachmode"><option ' . $yy . ' value="enabled"> Enabled <option ' . $nn . ' value=""> Disabled </select> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: attachmaxi<br> Description: If you enabled project attachments above, you can limit the size of the attachment in bytes.<br> Example: 50000<br> <input type="text" name="newattachmaxi" size="8" value="' . $attachmaxi . '"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: attachpath<br> Description: If you enabled project attachments above, you must specify the full path to where the attachments will be uploaded to (DO NOT include a trailing slash). You MUST CHMOD this directory\'s permissions to 777!<br> Example: /home/mywebsite/public_html/freelancers/uploads<br> <input type="text" name="newattachpath" size="60" value="' . $attachpath . '"> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: attachurl<br> Description: If you enabled project attachments above, you must specify the full directory URL to where attachments will be uploaded to (DO NOT include a trailing slash). You MUST CHMOD this directory\'s permissions to 777!<br> Example: ' . $siteurl . '/uploads<br> <input type="text" name="newattachurl" size="60" value="' . $attachurl . '"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: catname<br> Description: This is the title of the categories inwhich "freelancers" choose to become experts of and "buyers" select as categories involving their project.<br> Example: Job Type<br> <input type="text" name="newcatname" size="19" value="' . $catname . '"> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: categories<br> Description: These are the categories inwhich "freelancers" choose to become experts of and "buyers" select as relevencies to their project (separate the categories by a "~", except without the quotes).<br> Example: Tests~Demos~Uploads~Attachments<br> <textarea name="newcategories" rows="8" cols="52" wrap="off">' . $categories . '</textarea> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: pcat1<br> Description: If you want an extra category selection for "buyers" to select from when creating a project, provide the name of this extra category.<br> Example: Location<br> <input type="text" name="newpcat1" size="26" value="' . $pcat1 . '"> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: pcat1val<br> Description: If you chose to have an extra category above, provide the selections that can be made for that extra category (separate the categories by "***", except without the quotes).<br> Example: Washington, DC***Ottawa, ON***Mexico City, Mexico<br> <textarea name="newpcat1val" rows="8" cols="52" wrap="off">' . $pcat1val . '</textarea> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: pcat2<br> Description: If you want a second extra category selection for "buyers" to select from when creating a project, provide the name of that second extra category.<br> Example: Website Status<br> <input type="text" name="newpcat2" size="26" value="' . $pcat2 . '"> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: pcat2val<br> Description: If you chose to have a second extra category above, provide the selections that can be made for that second extra category (separate the categories by "***", except without the quotes).<br> Example: Active***Under Construction***Inactive<br> <textarea name="newpcat2val" rows="8" cols="52" wrap="off">' . $pcat2val . '</textarea> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: pcat3<br> Description: If you want a third extra category selection for "buyers" to select from when creating a project, provide the name of that third extra category.<br> Example: Project Size<br> <input type="text" name="newpcat3" size="26" value="' . $pcat3 . '"> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: pcat3val<br> Description: If you chose to have a third extra category above, provide the selections that can be made for that third extra category (separate the categories by "***", except without the quotes).<br> Example: Huge***Large***Average***Small***Tiny<br> <textarea name="newpcat3val" rows="8" cols="52" wrap="off">' . $pcat3val . '</textarea> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: balexpdays<br> Description: Specify the days when users will receive automatic warnings of a balance lower than ' . $currencytype . '' . $currency . '0.00 in their account (separate the categories by a "-", except without the quotes). The last warning day should be 1 below the low balance maximum day.<br> Example: 25-26-27-28-29<br> <input type="text" name="newbalexpdays" size="37" value="' . $balexpdays . '"> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: balmaxdays<br> Description: Specify the day when users will receive an automatic account suspension message (they will be suspended) of a balance lower than ' . $currencytype . '' . $currency . '0.00 in their account and will remain suspended until they add funds enough to make their account balance a positive number.<br> Example: 30<br> <input type="text" name="newbalmaxdays" size="4" value="' . $balmaxdays . '"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: tableborder<br> Description: The border that will be placed on all tables in PHP Freelancers.<br> Example: 0<br> <input type="text" name="newtableborder" size="3" value="' . $tableborder . '"> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: tablecellsp<br> Description: The cell spacing amount that will be placed inbetween all cells on all tables in PHP Freelancers.<br> Example: 0<br> <input type="text" name="newtablecellsp" size="3" value="' . $tablecellsp . '"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: tablecellpa<br> Description: The cell padding amount that will be placed on all cells on all table in PHP Freelancers.<br> Example: 2<br> <input type="text" name="newtablecellpa" size="3" value="' . $tablecellpa . '"> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: tablecolort<br> Description: The color of the text that will be placed on all headers of tables in PHP Freelancers (color codes are allowed).<br> Example: #CCCCCC<br> <input type="text" name="newtablecolort" size="21" value="' . $tablecolort . '"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: tablecolorh<br> Description: The color of the header that will be placed on the top of all tables in PHP Freelancers (color codes are allowed).<br> Example: #000000<br> <input type="text" name="newtablecolorh" size="21" value="' . $tablecolorh . '"> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: tablecolor1<br> Description: The background color of the first row of data shown on most tables in PHP Freelancers (color codes are allowed).<br> Example: #EFEFEF<br> <input type="text" name="newtablecolor1" size="21" value="' . $tablecolor1 . '"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: tablecolor2<br> Description: The background color of the second row of data shown on most tables in PHP Freelancers (color codes are allowed).<br> Example: #CCCCCC<br> <input type="text" name="newtablecolor2" size="21" value="' . $tablecolor2 . '"> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: ppemailaddr<br> Description: The PayPal email address that users pay when depositting money into their account (if you enabled PayPal deposits), and when the user clicks on the PayPal link, they will be taken to the referral signup referred by this email address (if you don\'t have a PayPal account, use the one shown in the example).<br> Example: user@domain.com<br> <input type="text" name="newppemailaddr" size="45" value="' . $ppemailaddr . '"> </font></div></td> </tr>

I have just installed php freelacers script, managed to install db setup, but when I get the link to set admin $vars I just get a blank page instead of admin... install code below. <?php if ($setup == "go") { require "vars.php"; $ress = SQLact("query", "SELECT * FROM freelancers_count"); $num_rows = @SQLact("num_rows", $ress); if ($num_rows==0) { SQLact("query", "CREATE TABLE freelancers_announcements (date VARCHAR(10) NOT NULL, date2 VARCHAR(10) NOT NULL, announce BLOB NOT NULL, announce2 BLOB NOT NULL)"); SQLact("query", "INSERT INTO freelancers_announcements (date, date2, announce, announce2) VALUES ('', '', '', '')"); SQLact("query", "CREATE TABLE freelancers_archived (date VARCHAR(250) NOT NULL, date2 INT(10) NOT NULL, username VARCHAR(250) NOT NULL, atype VARCHAR(10) NOT NULL, wtype VARCHAR(200) NOT NULL, amount VARCHAR(12) NOT NULL, namount VARCHAR(12) NOT NULL)"); SQLact("query", "CREATE TABLE freelancers_bans (ip VARCHAR(250) NOT NULL, reason BLOB NOT NULL)"); SQLact("query", "CREATE TABLE freelancers_bids (username VARCHAR(250) NOT NULL, status VARCHAR(9) NOT NULL, id VARCHAR(12) NOT NULL, project VARCHAR(250) NOT NULL, special VARCHAR( NOT NULL, amount VARCHAR(10) NOT NULL, delivery VARCHAR(4) NOT NULL, date VARCHAR(20) NOT NULL, details BLOB NOT NULL, date2 INT(10) NOT NULL, chosen VARCHAR(250) NOT NULL, outbid CHAR(1) NOT NULL)"); SQLact("query", "CREATE TABLE freelancers_cats (categories VARCHAR(250) NOT NULL)"); SQLact("query", "INSERT INTO freelancers_cats (categories) VALUES ('Buiders')"); SQLact("query", "INSERT INTO freelancers_cats (categories) VALUES ('Electricans')"); SQLact("query", "INSERT INTO freelancers_cats (categories) VALUES ('Plumbers')"); SQLact("query", "INSERT INTO freelancers_cats (categories) VALUES ('Joiners')"); SQLact("query", "INSERT INTO freelancers_cats (categories) VALUES ('Roofers')"); SQLact("query", "INSERT INTO freelancers_cats (categories) VALUES ('Groundworkers')"); SQLact("query", "INSERT INTO freelancers_cats (categories) VALUES ('Earthworks')"); SQLact("query", "INSERT INTO freelancers_cats (categories) VALUES ('Painters')"); SQLact("query", "CREATE TABLE freelancers_count (count VARCHAR(12) NOT NULL)"); SQLact("query", "INSERT INTO freelancers_count (count) VALUES ('102402089011')"); SQLact("query", "CREATE TABLE freelancers_cron (lastday VARCHAR( NOT NULL)"); $today = date("Ymd"); SQLact("query", "INSERT INTO freelancers_cron (lastday) VALUES ('$today')"); SQLact("query", "CREATE TABLE freelancers_deposits (username VARCHAR(250) NOT NULL, atype VARCHAR(10) NOT NULL, amount VARCHAR(20) NOT NULL, total VARCHAR(20) NOT NULL, oid VARCHAR(12) NOT NULL, ptype VARCHAR(6) NOT NULL, status VARCHAR( NOT NULL)"); SQLact("query", "CREATE TABLE freelancers_edittemp (email VARCHAR(250) NOT NULL, id VARCHAR(10) NOT NULL, username VARCHAR(250) NOT NULL, atype VARCHAR(10) NOT NULL)"); SQLact("query", "CREATE TABLE freelancers_forum (pid VARCHAR(12) NOT NULL, froom VARCHAR(250) NOT NULL, acctype VARCHAR(10) NOT NULL, date VARCHAR(18) NOT NULL, date2 VARCHAR(10) NOT NULL, private VARCHAR(250) NOT NULL, privatetype VARCHAR(10) NOT NULL, message BLOB NOT NULL, mid VARCHAR(10) NOT NULL)"); SQLact("query", "CREATE TABLE freelancers_logins (username VARCHAR(250) NOT NULL, date VARCHAR(10) NOT NULL, atype VARCHAR(10) NOT NULL)"); SQLact("query", "CREATE TABLE freelancers_profits (amount VARCHAR(20) NOT NULL, type VARCHAR(10) NOT NULL, type2 VARCHAR(6) NOT NULL, month CHAR(2) NOT NULL, year VARCHAR(10) NOT NULL)"); SQLact("query", "CREATE TABLE freelancers_programmers (username VARCHAR(250) NOT NULL, password VARCHAR(250) NOT NULL, company VARCHAR(250) NOT NULL, categories BLOB NOT NULL, rate VARCHAR(10) NOT NULL, profile BLOB NOT NULL, notify VARCHAR(250) NOT NULL, id VARCHAR(12) NOT NULL, email VARCHAR(250) NOT NULL, special VARCHAR(4) NOT NULL, ip VARCHAR(250) NOT NULL, wname VARCHAR(250) NOT NULL, waddress VARCHAR(250) NOT NULL, wcity VARCHAR(250) NOT NULL, wzip VARCHAR(250) NOT NULL, wemail VARCHAR(250) NOT NULL, wbankyourname VARCHAR(250) NOT NULL, wbankname VARCHAR(250) NOT NULL, wbankaddress VARCHAR(250) NOT NULL, wbankaddress2 VARCHAR(250) NOT NULL, wbankcity VARCHAR(200) NOT NULL, wbankstate VARCHAR(150) NOT NULL, wbankcountry VARCHAR(185) NOT NULL, wbankzip VARCHAR(20) NOT NULL, wbankaccnum VARCHAR(220) NOT NULL, wbankcode VARCHAR(140) NOT NULL, wbankacctype CHAR(2) NOT NULL, wothercontent BLOB NOT NULL, portfolio BLOB NOT NULL)"); SQLact("query", "CREATE TABLE freelancers_projects (chosen VARCHAR(250) NOT NULL, status VARCHAR(9) NOT NULL, id VARCHAR(12) NOT NULL, date2 INT(10) NOT NULL, project VARCHAR(250) NOT NULL, special VARCHAR( NOT NULL, categories BLOB NOT NULL, expires VARCHAR(4) NOT NULL, budgetmin VARCHAR(250) NOT NULL, budgetmax VARCHAR(250) NOT NULL, creation VARCHAR(10) NOT NULL, ctime VARCHAR(5) NOT NULL, creator VARCHAR(250) NOT NULL, description BLOB NOT NULL, attachment VARCHAR(250) NOT NULL, pcat1val BLOB NOT NULL, pcat2val BLOB NOT NULL, pcat3val BLOB NOT NULL)"); SQLact("query", "CREATE TABLE freelancers_ratings (username VARCHAR(250) NOT NULL, rating CHAR(2) NOT NULL, ratedby VARCHAR(250) NOT NULL, projid VARCHAR(12) NOT NULL, projname VARCHAR(250) NOT NULL, projdate VARCHAR(20) NOT NULL, comments BLOB NOT NULL, type VARCHAR(10) NOT NULL, status VARCHAR(5) NOT NULL, type2 VARCHAR(10) NOT NULL)"); SQLact("query", "CREATE TABLE freelancers_refunds (id VARCHAR(10) NOT NULL)"); SQLact("query", "CREATE TABLE freelancers_setup (siteurl VARCHAR(250) NOT NULL, toplayout BLOB NOT NULL, bottomlayout BLOB NOT NULL, emailheader BLOB NOT NULL, emailfooter BLOB NOT NULL, emailaddress VARCHAR(250) NOT NULL, companyname VARCHAR(250) NOT NULL, bsbamount VARCHAR(250) NOT NULL, fsbamount VARCHAR(250) NOT NULL, frefamount VARCHAR(250) NOT NULL, brefamount VARCHAR(250) NOT NULL, address VARCHAR(250) NOT NULL, city VARCHAR(250) NOT NULL, state VARCHAR(250) NOT NULL, country VARCHAR(250) NOT NULL, zipcode VARCHAR(250) NOT NULL, currency VARCHAR(250) NOT NULL, currencytype VARCHAR(250) NOT NULL, buyer VARCHAR(250) NOT NULL, buyers VARCHAR(250) NOT NULL, freelancer VARCHAR(250) NOT NULL, freelancers VARCHAR(250) NOT NULL, mode VARCHAR(4) NOT NULL, adminpass VARCHAR(250) NOT NULL, attachmode VARCHAR( NOT NULL, attachmaxi VARCHAR(15) NOT NULL, attachpath VARCHAR(250) NOT NULL, attachurl VARCHAR(250) NOT NULL, catname VARCHAR(250) NOT NULL, pcat1 VARCHAR(250) NOT NULL, pcat1val BLOB NOT NULL, pcat2 VARCHAR(250) NOT NULL, pcat2val BLOB NOT NULL, pcat3 VARCHAR(250) NOT NULL, pcat3val BLOB NOT NULL, balexpdays VARCHAR(250) NOT NULL, balmaxdays VARCHAR(10) NOT NULL, tableborder CHAR(2) NOT NULL, tablecellsp CHAR(2) NOT NULL, tablecellpa CHAR(2) NOT NULL, tablecolort VARCHAR(250) NOT NULL, tablecolorh VARCHAR(250) NOT NULL, tablecolor1 VARCHAR(250) NOT NULL, tablecolor2 VARCHAR(250) NOT NULL, ppemailaddr VARCHAR(250) NOT NULL, deposit2checkout VARCHAR(7) NOT NULL, depositpaypal VARCHAR(7) NOT NULL, depositccurl VARCHAR(250) NOT NULL, depositccper VARCHAR(5) NOT NULL, depositccfee VARCHAR(5) NOT NULL, depositccpay VARCHAR(250) NOT NULL, depositccsid VARCHAR(10) NOT NULL, depositccaut VARCHAR(7) NOT NULL, depositppper VARCHAR(5) NOT NULL, depositppfee VARCHAR(5) NOT NULL, depositppaut VARCHAR(7) NOT NULL, depositmail VARCHAR(7) NOT NULL, depositmlfee VARCHAR(5) NOT NULL, depositother VARCHAR(7) NOT NULL, depositnotify VARCHAR(7) NOT NULL, feedbackcmax VARCHAR(10) NOT NULL, projectper VARCHAR(10) NOT NULL, projectfee VARCHAR(10) NOT NULL, projectper2 VARCHAR(10) NOT NULL, projectfee2 VARCHAR(10) NOT NULL, withdrawcfee VARCHAR(10) NOT NULL, withdrawpaypal VARCHAR(7) NOT NULL, withdrawpfee VARCHAR(10) NOT NULL, withdrawwire VARCHAR(7) NOT NULL, withdrawwfee VARCHAR(10) NOT NULL, withdrawother VARCHAR(7) NOT NULL, withdrawofee VARCHAR(10) NOT NULL, withdrawonam VARCHAR(250) NOT NULL, withdrawoins BLOB NOT NULL, withdrawmini VARCHAR(10) NOT NULL, withdrawnotify VARCHAR(7) NOT NULL, multiplecats VARCHAR(7) NOT NULL, featuredcost VARCHAR(60) NOT NULL, mprojectdays VARCHAR(5) NOT NULL, projectudays VARCHAR(250) NOT NULL, forumnextnum VARCHAR(100) NOT NULL, maxextend CHAR(3) NOT NULL, userportfolio VARCHAR(7) NOT NULL, refreturn1 VARCHAR(250) NOT NULL, refreturn2 VARCHAR(250) NOT NULL)"); SQLact("query", "INSERT INTO freelancers_setup (siteurl, toplayout, bottomlayout, emailheader, emailfooter, emailaddress, companyname, bsbamount, fsbamount, frefamount, brefamount, address, city, state, country, zipcode, currency, currencytype, buyer, buyers, freelancer, freelancers, mode, adminpass, attachmode, attachmaxi, attachpath, attachurl, catname, pcat1, pcat1val, pcat2, pcat2val, pcat3, pcat3val, balexpdays, balmaxdays, tableborder, tablecellsp, tablecellpa, tablecolort, tablecolorh, tablecolor1, tablecolor2, ppemailaddr, deposit2checkout, depositpaypal, depositccurl, depositccper, depositccfee, depositccpay, depositccsid, depositccaut, depositppper, depositppfee, depositppaut, depositmail, depositmlfee, depositother, depositnotify, feedbackcmax, projectper, projectfee, projectper2, projectfee2, withdrawcfee, withdrawpaypal, withdrawpfee, withdrawwire, withdrawwfee, withdrawother, withdrawofee, withdrawonam, withdrawoins, withdrawmini, withdrawnotify, multiplecats, featuredcost, mprojectdays, projectudays, forumnextnum, maxextend, userportfolio, refreturn1, refreturn2) VALUES ('" . $url . "', '<title>Freelance</title>My Header<p>Buyers: <a href=\"webmasters.php?new=user\">Sign Up</a> - <a href=\"webmasters.php?new=project\">Create Project</a> - <a href=\"webmasters.php?login=now\">Manage Account</a> - <a href=\"webmasters.php?logout=now\">Sign Out</a><br>Freelancers: <a href=\"freelancers.php?new=user\">Sign Up</a> - <a href=\"freelancers.php?login=now\">Manage Account</a> - <a href=\"freelancers.php?logout=now\">Sign Out</a><br>General: <a href=\"search.php?showstatus=open\">View Open Projects</a> - <a href=\"search.php\">Find A Project</a> - <a href=\"send.php\">Send Message</a><hr>', '<hr><br>My Footer', 'E-Mail Header', 'E-Mail Footer', 'neo@cyberia.ca', 'Freelance', '5.00', '1.00', '0.25', '0.75', 'Demo Address', 'Demo City', 'Demo State', 'Demo Country', 'Demo Zip/Postal Code', '\$', 'US', 'Buyer', 'Buyers', 'Freelancer', 'Freelancers', 'demo', 'admin', 'enabled', '59200', '/home/user/public_html/attachments', '" . $url . "/attachments', 'Job Type', 'Location', 'Someplace, 4U***Nowhere, IC***Everywhere, UN', '', '', '', '', '25-26-27-28-29', '30', '0', '0', '2', '#000000', '#CCCCCC', '#EFEFEF', '#CCCCCC', 'neo@cyberia.ca', 'enabled', 'enabled', '', '5.5', '0.45', 'https://www.2checkout.com/cgi-bin/buyers/cartpurchase1.2c?sid=', '14387', 'enabled', '2.9', '0.30', 'enabled', 'enabled', '1', 'enabled', 'enabled', '200', '7', '9.00', '3', '1.00', '1.00', 'enabled', '1.00', 'enabled', '20.00', 'enabled', '1.00', 'Western Union Transfer', 'Provide your name and address please.', '25.00', 'enabled', 'enabled', '10.00', '90', '0-1-2-3', '10', '7', '', '$url', '$url')"); SQLact("query", "CREATE TABLE freelancers_subjects (pid VARCHAR(12) NOT NULL, subject BLOB NOT NULL, date VARCHAR(20) NOT NULL, date2 INT(10) NOT NULL)"); SQLact("query", "CREATE TABLE freelancers_suspends (ip VARCHAR(250) NOT NULL, reason BLOB NOT NULL)"); SQLact("query", "CREATE TABLE freelancers_temp (email VARCHAR(250) NOT NULL, id VARCHAR(12) NOT NULL)"); SQLact("query", "CREATE TABLE freelancers_transactions (amount VARCHAR(250) NOT NULL, details BLOB NOT NULL, username VARCHAR(250) NOT NULL, type VARCHAR(10) NOT NULL, balance VARCHAR(50) NOT NULL, date VARCHAR(100) NOT NULL, date2 INT(10) NOT NULL)"); SQLact("query", "CREATE TABLE freelancers_webmasters (username VARCHAR(250) NOT NULL, password VARCHAR(250) NOT NULL, company VARCHAR(250) NOT NULL, email VARCHAR(250) NOT NULL, bidnotify CHAR(1) NOT NULL, id VARCHAR(12) NOT NULL, ip VARCHAR(250) NOT NULL, special VARCHAR(250) NOT NULL, wname VARCHAR(250) NOT NULL, waddress VARCHAR(250) NOT NULL, wcity VARCHAR(250) NOT NULL, wzip VARCHAR(250) NOT NULL, wemail VARCHAR(250) NOT NULL, wbankyourname VARCHAR(250) NOT NULL, wbankname VARCHAR(250) NOT NULL, wbankaddress VARCHAR(250) NOT NULL, wbankaddress2 VARCHAR(250) NOT NULL, wbankcity VARCHAR(200) NOT NULL, wbankstate VARCHAR(150) NOT NULL, wbankcountry VARCHAR(185) NOT NULL, wbankzip VARCHAR(20) NOT NULL, wbankaccnum VARCHAR(220) NOT NULL, wbankcode VARCHAR(140) NOT NULL, wbankacctype CHAR(2) NOT NULL, wothercontent BLOB NOT NULL)"); SQLact("query", "CREATE TABLE freelancers_withdrawals (date VARCHAR(250) NOT NULL, date2 INT(10) NOT NULL, username VARCHAR(250) NOT NULL, atype VARCHAR(10) NOT NULL, wtype VARCHAR(200) NOT NULL, amount VARCHAR(12) NOT NULL, name VARCHAR(250) NOT NULL, address VARCHAR(250) NOT NULL, city VARCHAR(250) NOT NULL, zip VARCHAR(250) NOT NULL, email VARCHAR(250) NOT NULL, bankyourname VARCHAR(250) NOT NULL, bankname VARCHAR(250) NOT NULL, bankaddress VARCHAR(250) NOT NULL, bankaddress2 VARCHAR(250) NOT NULL, bankcity VARCHAR(200) NOT NULL, bankstate VARCHAR(150) NOT NULL, bankcountry VARCHAR(185) NOT NULL, bankzip VARCHAR(20) NOT NULL, bankaccnum VARCHAR(220) NOT NULL, bankcode VARCHAR(140) NOT NULL, bankacctype CHAR(2) NOT NULL, status VARCHAR( NOT NULL, othercontent BLOB NOT NULL, wfee VARCHAR(12) NOT NULL, namount VARCHAR(12) NOT NULL)") or die ("You must first customize the MySQL connections in vars.php to match yours or this script will not be setup!"); SQLact("query", "CREATE TABLE freelancers_escrow (id varchar(250) NOT NULL,webmaster varchar(250) NOT NULL, programmer varchar(250) NOT NULL, amount varchar(250) NOT NULL, PRIMARY KEY (id,webmaster)) TYPE=MyISAM"); echo 'SUCCESS: Your MySQL has now been successfully setup!<br> Now, <a href="' . $url . 'control/admin_install.php?pass=admin">click here</a> to finish the setup process by filling out the admin fields, etc.<br>'; } else { echo 'ERROR: This file has already been run successfully <a href="' . $url . 'control/admin_install.php?pass=admin">click here</a> to finish the setup process by filling out the admin fields, etc.<br><br>'; } } else { ?> Only Run Once or all data will be over written. <a href="install.php?setup=go">Click here</a> to install.<br>. <?php } ?> admin_install.php ...... below

<td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: tablecolorh<br> Description: The color of the header that will be placed on the top of all tables in PHP Freelancers (color codes are allowed).<br> Example: #000000<br> <input type="text" name="newtablecolorh" size="21" value="' . $tablecolorh . '"> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: tablecolor1<br> Description: The background color of the first row of data shown on most tables in PHP Freelancers (color codes are allowed).<br> Example: #EFEFEF<br> <input type="text" name="newtablecolor1" size="21" value="' . $tablecolor1 . '"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: tablecolor2<br> Description: The background color of the second row of data shown on most tables in PHP Freelancers (color codes are allowed).<br> Example: #CCCCCC<br> <input type="text" name="newtablecolor2" size="21" value="' . $tablecolor2 . '"> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: ppemailaddr<br> Description: The PayPal email address that users pay when depositting money into their account (if you enabled PayPal deposits), and when the user clicks on the PayPal link, they will be taken to the referral signup referred by this email address (if you don\'t have a PayPal account, use the one shown in the example).<br> Example: user@domain.com<br> <input type="text" name="newppemailaddr" size="45" value="' . $ppemailaddr . '"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: deposit2checkout<br> Description: 2Checkout deposit mode configures PHP Freelancers to allow users to deposit money into their account by a secure 2Checkout credit card payment (you must first have a 2Checkout account).<br> Recommended: Enabled<br> <select name="newdeposit2checkout"><option ' . $yyy . ' value="enabled"> Enabled <option ' . $nnn . ' value=""> Disabled </select> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: depositpaypal<br> Description: PayPal deposit mode configures PHP Freelancers to allow users to deposit money into their account by a secure PayPal credit or debit card payment (you must first have a PayPal account which you provided in the variable "ppemailaddr").<br> Recommended: Enabled<br> <select name="newdepositpaypal"><option ' . $yyyy . ' value="enabled"> Enabled <option ' . $nnnn . ' value=""> Disabled </select> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: depositnotify<br> Description: Deposit notify mode configures PHP Freelancers to send you an email whenever a user makes a PayPal (if enabled) or 2Checkout (if enabled) money deposit into their account.<br> Recommended: Enabled<br> <select name="newdepositnotify"><option ' . $yyyyy . ' value="enabled"> Enabled <option ' . $nnnnn . ' value=""> Disabled </select> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: depositccurl<br> Description: If you did not want to use 2Checkout, but do want to use some other credit card processor for deposits, provide the complete URL/web address here. The deposit will not automatically <br> [amount] will be replaced by the total deposit amount including fees.<br> [username] will be replaced by the username of the user making the deposit.<br> [type] will be replaced by the user\'s account type.<br> Example: http://www.mypayment processor.com/cgi-bin/purchase.cgi?uid=12345&total=[amount]&customer=[username]&acctype=[type]<br> <input type="text" name="newdepositccurl" size="63" value="' . $depositccurl . '"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: depositccper<br> Description: If you enabled 2Checkout or some other credit card processor for deposits, provide the percentage fee which will be added to the deposit amount before paying.<br> Example: 5.5<br> <input type="text" name="newdepositccper" size="6" value="' . $depositccper . '"> % </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: depositccfee<br> Description: If you enabled 2Checkout or some other credit card processor for deposits, provide the pure dollar fee which will be added to the deposit amount before paying.<br> Example: 0.45<br> ' . $currencytype . '' . $currency . ' <input type="text" name="newdepositccfee" size="6" value="' . $depositccfee . '"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: depositccpay<br> Description: If you enabled 2Checkout deposits, provide the URL to where the payment will be processed (DO NOT include the sid). The URL should match the one supplied in the example but this is just incase it ever changes.<br> Example: https://www.2checkout.com/cgi-bin/buyers/cartpurchase1.2c?sid=<br> <input type="text" name="newdepositccpay" size="63" value="' . $depositccpay . '"> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: depositccsid<br> Description: If you enabled 2Checkout deposits, you must provide your sid for the deposit amount to be transferred into your 2Checkout account when the user makes the payment.<br> Example: 14387<br> <input type="text" name="newdepositccsid" size="6" value="' . $depositccsid . '"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: depositccaut<br> Description: If you enabled 2Checkout deposits, the 2Checkout automatic deposit configures PHP Freelancers to get the amount (without fees) the user depositted and to automatically be added to the users\' account.<br> Recommended: Disabled<br> <select name="newdepositccaut"><option ' . $yyyyyy . ' value="enabled"> Enabled <option ' . $nnnnnn . ' value=""> Disabled </select> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: depositppper<br> Description: If you enabled PayPal deposits, provide the percentage fee which will be added to the deposit amount before paying.<br> Example: 2.9<br> <input type="text" name="newdepositppper" size="6" value="' . $depositppper . '"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: depositppfee<br> Description: If you enabled PayPal deposits, provide the pure dollar fee which will be added to the deposit amount before paying.<br> Example: 0.30<br> ' . $currencytype . '' . $currency . ' <input type="text" name="newdepositppfee" size="6" value="' . $depositppfee . '"> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: depositppaut<br> Description: If you enabled PayPal deposits, the PayPal automatic deposit configures PHP Freelancers to get the amount (without fees) the user depositted and to automatically be added to the users\' account.<br> Recommended: Disabled<br> <select name="newdepositppaut"><option ' . $yyyyyyy . ' value="enabled"> Enabled <option ' . $nnnnnnn . ' value=""> Disabled </select> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: depositmail<br> Description: Mail deposit mode configures PHP Freelancers to allow users to deposit money into their account by check (all information needed are the address variables and companyname).<br> Recommended: Enabled<br> <select name="newdepositmail"><option ' . $yyyyyyyy . ' value="enabled"> Enabled <option ' . $nnnnnnnn . ' value=""> Disabled </select> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: depositmlfee<br> Description: If you enabled check deposits, provide the pure dollar fee which will be added to the deposit amount before paying.<br> Example: 1<br> ' . $currencytype . '' . $currency . ' <input type="text" name="newdepositmlfee" size="6" value="' . $depositmlfee . '"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: depositother<br> Description: Other deposit mode configures PHP Freelancers to allow users to deposit money into their account by some other deposit method you specify (if you enable this, be sure to upload a file named "payment.php" to the directory inwhich PHP Freelancers is, containing the details of the other deposit method, and how to use it).<br> Recommended: Disabled<br> <select name="newdepositother"><option ' . $yyyyyyyyy . ' value="enabled"> Enabled <option ' . $nnnnnnnnn . ' value=""> Disabled </select> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: feedbackcmax<br> Description: The maximum number of characters a user can type as feedback when providing feedback on another user.<br> Example: 500<br> <input type="text" name="newfeedbackcmax" size="6" value="' . $feedbackcmax . '"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: projectper<br> Description: The percentage of a "freelancers" bid that is charged as a project commission fee to their account, this is split in half if they are a "guarenteed programmer", and the commission fee that is charged is this or projectfee, whichever is greater.<br> Example: 12<br> <input type="text" name="newprojectper" size="3" value="' . $projectper . '"> % </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: projectfee<br> Description: The pure dollar ammount that is charged as a project commission fee to the winning bidder\'s account, this is split in half if they are a "guarenteed programmer", and the commission fee that is charged is this or projectper, whichever is greater.<br> Example: 8<br> ' . $currencytype . '' . $currency . ' <input type="text" name="newprojectfee" size="5" value="' . $projectfee . '"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: projectper2<br> Description: The percentage of a "freelancers" bid that is charged as a project commission fee to the project creator\'s account, this is split in half if they are a "guarenteed webmaster", and the commission fee that is charged is this or projectfee2, whichever is greater.<br> Example: 7<br> <input type="text" name="newprojectper2" size="3" value="' . $projectper2 . '"> % </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: projectfee2<br> Description: The pure dollar ammount that is charged as a project commission fee to the project creator\'s account, this is split in half if they are a "guarenteed webmaster", and the commission fee that is charged is this or projectper2, whichever is greater.<br> Example: 2<br> ' . $currencytype . '' . $currency . ' <input type="text" name="newprojectfee2" size="5" value="' . $projectfee2 . '"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: withdrawcfee<br> Description: The pure dollar amount that is charged (subtracted from the total withdrawal) when a user withdraws money from their account by check.<br> Example: 1<br> ' . $currencytype . '' . $currency . ' <input type="text" name="newwithdrawcfee" size="3" value="' . $withdrawcfee . '"> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: withdrawpaypal<br> Description: PayPal withdraw mode configures PHP Freelancers to allow users to withdraw money from their account by a secure PayPal credit or debit card payment (you must first have a PayPal account).<br> Recommended: Enabled<br> <select name="newwithdrawpaypal"><option ' . $yyyyyyyyyy . ' value="enabled"> Enabled <option ' . $nnnnnnnnnn . ' value=""> Disabled </select> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: withdrawpfee<br> Description: If you enabled the PayPal withdraw mode, provide the pure dollar amount that is charged (subtracted from the total withdrawal) when a user withdraws money from their account by PayPal.<br> Example: 1<br> ' . $currencytype . '' . $currency . ' <input type="text" name="newwithdrawpfee" size="4" value="' . $withdrawpfee . '"> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: withdrawwire<br> Description: Bank wire withdraw mode configures PHP Freelancers to allow users to withdraw money from their account by a secure bank wire payment (you must first have a bank account).<br> Recommended: Enabled<br> <select name="newwithdrawwire"><option ' . $yyyyyyyyyyy . ' value="enabled"> Enabled <option ' . $nnnnnnnnnnn . ' value=""> Disabled </select> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: withdrawwfee<br> Description: If you enabled the bank wire withdraw mode, provide the pure dollar amount that is charged (subtracted from the total withdrawal) when a user withdraws money from their account by bank wire.<br> Example: 20<br> ' . $currencytype . '' . $currency . ' <input type="text" name="newwithdrawwfee" size="6" value="' . $withdrawwfee . '"> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: withdrawother<br> Description: Other withdraw mode configures PHP Freelancers to allow users to withdraw money from their account by an other payment (you must first in most cases have an account with them).<br> Recommended: Enabled<br> <select name="newwithdrawother"><option ' . $yyyyyyyyyyyy . ' value="enabled"> Enabled <option ' . $nnnnnnnnnnnn . ' value=""> Disabled </select> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: withdrawofee<br> Description: If you enabled the other withdraw mode, provide the pure dollar amount that is charged (subtracted from the total withdrawal) when a user withdraws money from their account by other means.<br> Example: 1<br> ' . $currencytype . '' . $currency . ' <input type="text" name="newwithdrawofee" size="6" value="' . $withdrawofee . '"> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: withdrawonam<br> Description: If you enabled the other withdraw mode, provide the name of this other withdraw mode that users will see and be able to choose from.<br> Example: Western Union Transfer<br> <input type="text" name="newwithdrawonam" size="38" value="' . $withdrawonam . '"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: withdrawoins<br> Description: If you enabled the other withdraw mode, provide the instructions that users will have to follow of what to insert into an input box when they choose the other withdraw mode for a withdrawal.<br> Example: Provide your name and address please.<br> <textarea name="newwithdrawoins" rows="8" cols="52" wrap="off">' . $withdrawoins . '</textarea> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: withdrawmini<br> Description: Choose the minimum withdraw amount a user can specify to make a withdrawal.<br> Example: 25<br> ' . $currencytype . '' . $currency . ' <input type="text" name="newwithdrawmini" size="5" value="' . $withdrawmini . '"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: withdrawnotify<br> Description: Withdraw notify mode configures PHP Freelancers to notify you whenever a user makes a withdrawal request.<br> Recommended: Enabled<br> <select name="newwithdrawnotify"><option ' . $yyyyyyyyyyyyy . ' value="enabled"> Enabled <option ' . $nnnnnnnnnnnnn . ' value=""> Disabled </select> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: multiplecats<br> Description: Multiple category mode configures PHP Freelancers to allow "freelancers" to choose multiple categories to be experts of, and project creator\'s can choose multiple categories for their projects.<br> Recommended: Enabled<br> <select name="newmultiplecats"><option ' . $yyyyyyyyyyyyyy . ' value="enabled"> Enabled <option ' . $nnnnnnnnnnnnnn . ' value=""> Disabled </select> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: featuredcost<br> Description: This is the cost that will be subtracted from a user\'s account balance if they want their project to be listed as a featured one. Example: 10<br> ' . $currencytype . '' . $currency . ' <input type="text" name="newfeaturedcost" size="5" value="' . $featuredcost . '"> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: mprojectdays<br> Description: The maximum number of days that a project creator can enter for how long they can wait for the project completion and when the project will expire.<br> Example: 90<br> <input type="text" name="newmprojectdays" size="5" value="' . $mprojectdays . '"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: projectudays<br> Description: The days when a project will be classed as "urgent" and will display an urgent image beside the project name.<br> Example: 0-1-2-3<br> This example shows that if the project only has 0-3 days until expiry, it will display the urgent image beside the name.<br> <textarea name="newprojectudays" rows="8" cols="52" wrap="off">' . $projectudays . '</textarea> "> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: forumnextnum<br> Description: The number of subjects on the main message board to be showed per page.<br> Example: 25<br> <input type="text" name="newforumnextnum" value="' . $forumnextnum . '" size="3"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: maxextend<br> Description: The maximum amount of days a project can be extended at a time.<br> Example: 7<br> <input type="text" name="newmaxextend" value="' . $maxextend . '" size="3"> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: userportfolio<br> Description: User Portfolio mode configures PHP Freelancers to allow freelancers to upload images/screenshots of their previous works to their profile.<br> Recommended: Disabled<br> <select name="newuserportfolio"><option ' . $yyyyyyyyyyyyyyy . ' value="enabled"> Enabled <option ' . $nnnnnnnnnnnnnnn . ' value=""> Disabled </select> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: refreturn1<br> Description: The URL to where a user will be redirected once they follow a Buyer referal link and a cookie has been set.<br> Example: http://' . $HTTP_HOST . '<br> <input type="text" name="newrefreturn1" value="' . $refreturn1 . '" size="45"> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: refreturn2<br> Description: The URL to where a user will be redirected once they follow a Freelancer referal link and a cookie has been set.<br> Example: http://' . $HTTP_HOST . '<br> <input type="text" name="newrefreturn2" value="' . $refreturn2 . '" size="45"> </font></div></td> </tr> <tr> <td bgcolor="#005075" align="center" valign="middle"> <input type="submit" name="submit" value="Update Setup Variables"> </font></td> </tr> </table> </form> <form action="index.php" method="post"> <input type="hidden" name="pass" value="' . $pass . '"> <input type="submit" value="Back to Admin..."> </font> </form> </center> </body> </html>'; } else { SQLact("query", "DELETE FROM freelancers_cats"); SQLact("query", "UPDATE freelancers_setup SET siteurl='$newsiteurl', toplayout='$newtoplayout', bottomlayout='$newbottomlayout', emailheader='$newemailheader', emailfooter='$newemailfooter', emailaddress='$newemailaddress', companyname='$newcompanyname', fsbamount='$newfsbamount', bsbamount='$newbsbamount', frefamount='$newfrefamount', brefamount='$newbrefamount', address='$newaddress', city='$newcity', state='$newstate', zipcode='$newzipcode', currency='$newcurrency', currencytype='$newcurrencytype', buyer='$newbuyer', buyers='$newbuyers', freelancer='$newfreelancer', freelancers='$newfreelancers', mode='$newmode', adminpass='$newadminpass', attachmode='$newattachmode', attachmaxi='$newattachmaxi', attachpath='$newattachpath', attachurl='$newattachurl', catname='$newcatname', pcat1='$newpcat1', pcat1val='$newpcat1val', pcat2='$newpcat2', pcat2val='$newpcat2val', pcat3='$newpcat3', pcat3val='$newpcat3val', balexpdays='$newbalexpdays', balmaxdays='$newbalmaxdays', tableborder='$newtableborder', tablecellsp='$newtablecellsp', tablecellpa='$newtablecellpa', tablecolort='$newtablecolort', tablecolorh='$newtablecolorh', tablecolor1='$newtablecolor1', tablecolor2='$newtablecolor2', ppemailaddr='$newppemailaddr', deposit2checkout='$newdeposit2checkout', depositpaypal='$newdepositpaypal', depositnotify='$newdepositnotify', depositccurl='$newdepositccurl', depositccper='$newdepositccper', depositccfee='$newdepositccfee', depositccpay='$newdepositccpay', depositccsid='$newdepositccsid', depositccaut='$newdepositccaut', depositppper='$newdepositppper', depositppfee='$newdepositppfee', depositppaut='$newdepositppaut', depositmail='$newdepositmail', depositmlfee='$newdepositmlfee', depositother='$newdepositother', feedbackcmax='$newfeedbackcmax', projectper='$newprojectper', projectfee='$newprojectfee', projectper2='$newprojectper2', projectfee2='$newprojectfee2', withdrawcfee='$newwithdrawcfee', withdrawpaypal='$newwithdrawpaypal', withdrawpfee='$newwithdrawpfee', withdrawwire='$newwithdrawwire', withdrawwfee='$newwithdrawwfee', withdrawother='$newwithdrawother', withdrawofee='$newwithdrawofee', withdrawonam='$newwithdrawonam', withdrawoins='$newwithdrawoins', withdrawmini='$newwithdrawmini', withdrawnotify='$newwithdrawnotify', multiplecats='$newmultiplecats', featuredcost='$newfeaturedcost', mprojectdays='$newmprojectdays', projectudays='$newprojectudays', forumnextnum='$newforumnextnum', maxextend='$newmaxextend', userportfolio='$newuserportfolio', refreturn1='$newrefreturn1', refreturn2='$newrefreturn2'"); $categories = explode("~", $newcategories); for ($i=0;$i<count($categories);$i++) { SQLact("query", "INSERT INTO freelancers_cats (categories) VALUES ('" . $categories[$i] . "')"); } echo '<center> Setup Variables successfully updated.<br> <form action="admin_install.php" method="post"> <input type="hidden" name="pass" value="' . $newadminpass . '"> <input type="submit" value="Back to Setup Variables Customization..."> </form><br><br> <form action="index.php" method="post"> <input type="hidden" name="pass" value="' . $pass . '"> <input type="submit" value="Back to Admin..."> </form> </center>'; } } ?> regards Sean

Now I have a new problem, stage 2 of install gives me a blank page instead of set admin $vars heres the code....in two parts <?php require "../vars.php"; require "../cron.php"; if (!$pass || $pass !== $adminpass) { echo '<html> <head> <title> Access Unauthorized </title> </head> <body> <font color="red"><b>Access Denied: You are not authorized to view this page.</b></font> </body> </html>'; } else { if (!$submit) { if ($mode == "demo") { $y = "SELECTED"; } else { $n = "SELECTED"; } if ($attachmode == "enabled") { $yy = "SELECTED"; } else { $nn = "SELECTED"; } if ($deposit2checkout == "enabled") { $yyy = "SELECTED"; } else { $nnn = "SELECTED"; } if ($depositpaypal == "enabled") { $yyyy = "SELECTED"; } else { $nnnn = "SELECTED"; } if ($depositnotify == "enabled") { $yyyyy = "SELECTED"; } else { $nnnnn = "SELECTED"; } if ($depositccaut == "enabled") { $yyyyyy = "SELECTED"; } else { $nnnnnn = "SELECTED"; } if ($depositppaut == "enabled") { $yyyyyyy = "SELECTED"; } else { $nnnnnnn = "SELECTED"; } if ($depositmail == "enabled") { $yyyyyyyy = "SELECTED"; } else { $nnnnnnnn = "SELECTED"; } if ($depositother == "enabled") { $yyyyyyyyy = "SELECTED"; } else { $nnnnnnnnn = "SELECTED"; } if ($withdrawpaypal == "enabled") { $yyyyyyyyyy = "SELECTED"; } else { $nnnnnnnnnn = "SELECTED"; } if ($withdrawwire == "enabled") { $yyyyyyyyyyy = "SELECTED"; } else { $nnnnnnnnnnn = "SELECTED"; } if ($withdrawother == "enabled") { $yyyyyyyyyyyy = "SELECTED"; } else { $nnnnnnnnnnnn = "SELECTED"; } if ($withdrawnotify == "enabled") { $yyyyyyyyyyyyy = "SELECTED"; } else { $nnnnnnnnnnnnn = "SELECTED"; } if ($multiplecats == "enabled") { $yyyyyyyyyyyyyy = "SELECTED"; } else { $nnnnnnnnnnnnnn = "SELECTED"; } if ($userportfolio == "enabled") { $yyyyyyyyyyyyyyy = "SELECTED"; } else { $nnnnnnnnnnnnnnn = "SELECTED"; } $result = SQLact("query", "SELECT * FROM freelancers_cats"); while ($row=@SQLact("fetch_array", $result)) { $categories .= '~' . $row[categories]; } $categories = substr($categories, 1); echo ' <html lang="en-us"> <head> <title> Customize Setup Variables </title> <style type="text/css"> <!-- .line {background-color: #005075} a { text-decoration: none} a:hover { color: 00C3E9; text-decoration: underline} td {font-family:tahoma, verdana, helvetica, arial; font-size:11; font-weight:regular; text-decoration:none} --> </style> <script language="JavaScript" type="text/javascript"> function stopError() { return false; } window.onError=stopError(); </script> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"></head> <body bgcolor="#FFFFFF"> <center> Customize Setup Variables</font><br> <br> </font> <form action="index.php" method="post"> <input type="hidden" name="pass" value="' . $pass . '"> <input type="submit" value="Back to Admin..."> </font> </form> <form action="admin_install.php" method="post"> <input type="hidden" name="pass" value="' . $pass . '"> </font> <table width="598" border="0" cellspacing="0" cellpadding="15"> <tr> <td width="592" align="center" valign="middle" bgcolor="#D5D6D8"> <div align="left">Name: siteurl<br> Description: The complete directory URL to PHP Freelancers (DO NOT include the trailing slash).<br> Example: ' . $siteurl . '<br> <input type="text" name="newsiteurl" size="60" value="' . $siteurl . '"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: emailheader<br> Description: The contents of the header which will be placed on the top of all emails sent by PHP Freelancers (HTML tags aren\'t allowed). In all emails sent by PHP Freelancers, below this email header will be "----------", followed by the message contents.<br> Example: E-Mail Header<br> <textarea name="newemailheader" rows="8" cols="52" wrap="off">' . $emailheader . '</textarea> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: emailfooter<br> Description: The contents of the footer which will be placed on the bottom of all emails sent by PHP Freelancers (HTML tags aren\'t allowed). In all emails sent by PHP Freelancers, above this email footer will be "----------", and then the message contents.<br> Example: E-Mail Footer<br> <textarea name="newemailfooter" rows="8" cols="52" wrap="off">' . $emailfooter . '</textarea> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: emailaddress<br> Description: The main email address that you want to use for all matters involving PHP Freelance and emails.<br> Example: you@you.com<br> <input type="text" name="newemailaddress" size="45" value="' . $emailaddress . '"> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: companyname<br> Description: The name of your company/organization that will be used as the default website name of everything.<br> Example: Freelance Web<br> <input type="text" name="newcompanyname" size="35" value="' . $companyname . '"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: fsbamount<br> Description: The account signup bonus that "freelancers" will receive when they create an account at your website (a decimal is allowed).<br> Example: 1.00<br> ' . $currencytype . '' . $currency . ' <input type="text" name="newfsbamount" size="9" value="' . $fsbamount . '"> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: bsbamount<br> Description: The account signup bonus that "buyers" will receive when they create an account at your website (a decimal is allowed).<br> Example: 2.50<br> ' . $currencytype . '' . $currency . ' <input type="text" name="newbsbamount" size="9" value="' . $bsbamount . '"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: frefamount<br> Description: The referal amount a user will receive when they refer a "freelancer" and the "freelancer" successfully creates an account at your website (a decimal is allowed).<br> Example: 0.25<br> ' . $currencytype . '' . $currency . ' <input type="text" name="newfrefamount" size="9" value="' . $frefamount . '"> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: brefamount<br> Description: The referal amount a user will receive when they refer a "buyer" and the "buyer" successfully creates at your website (a decimal is allowed).<br> Example: 1<br> ' . $currencytype . '' . $currency . ' <input type="text" name="newbrefamount" size="9" value="' . $brefamount . '"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: address<br> Description: If you choose to allow deposits by check, this is the street address where the check will be sent to.<br> Example: #1-999 Terror Ave.<br> <input type="text" name="newaddress" size="48" value="' . $address . '"> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: city<br> Description: If you choose to allow deposits by check, this is the city where the check will be sent to.<br> Example: Terrorville<br> <input type="text" name="newcity" size="30" value="' . $city . '"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: state<br> Description: If you choose to allow deposits by check, this is the state/province where the check will be sent to (abbreviations allowed).<br> Example: Tekno Terrors<br> <input type="text" name="newstate" size="23" value="' . $state . '"> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: zipcode<br> Description: If you choose to allow deposits by check, this is the zip/postal code where the check will be sent to.<br> Example: Z9Z 9Z9<br> <input type="text" name="newzipcode" size="20" value="' . $zipcode . '"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: currency<br> Description: The currency symbol of all money amounts shown on pages of PHP Freelancers.<br> Example: $<br> <input type="text" name="newcurrency" size="3" value="' . $currency . '"> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: currencytype<br> Description: The type of the currency of all money amounts shown on pages of PHP Freelancers (leave this blank if there aren\'t multiple types of your selected currency).<br> Example: US<br> <input type="text" name="newcurrencytype" size="8" value="' . $currencytype . '"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: buyer<br> Description: The official name that all "buyers" will be represented by.<br> Example: Buyer<br> <input type="text" name="newbuyer" size="17" value="' . $buyer . '"> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: buyers<br> Description: The plural version of the official name that all "buyers" will be represented by.<br> Example: Buyer<font color="red">s</font><br> <input type="text" name="newbuyers" size="19" value="' . $buyers . '"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: freelancer<br> Description: The official name that all "freelancers" will be represented by.<br> Example: Freelancer<br> <input type="text" name="newfreelancer" size="22" value="' . $freelancer . '"> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: freelancers<br> Description: The plural version of the official name that all "freelancers" will be represented by.<br> Example: Freelancer<font color="red">s</font><br> <input type="text" name="newfreelancers" size="24" value="' . $freelancers . '"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: mode<br> Description: Demo mode configures PHP Freelancers to run in "test" mode, meaning that no deposits will actually be charged, attachments will not be allowed, etc.<br> Recommended: Disabled<br> <select name="newmode"><option ' . $y . ' value="demo"> Enabled <option ' . $n . ' value=""> Disabled </select> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: adminpass<br> Description: The only password which will be allowed to access the admin pages (index.php and admin_install.php).<br> Example: mypass999<br> <input type="text" name="newadminpass" size="11" value="' . $adminpass . '"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: attachmode<br> Description: Attach mode configures PHP Freelancer to allow "buyers" to upload files that are relevant to their project when creating a new project. This often involves a need for a lot of diskspace on your website.<br> Recommended: Disabled<br> <select name="newattachmode"><option ' . $yy . ' value="enabled"> Enabled <option ' . $nn . ' value=""> Disabled </select> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: attachmaxi<br> Description: If you enabled project attachments above, you can limit the size of the attachment in bytes.<br> Example: 50000<br> <input type="text" name="newattachmaxi" size="8" value="' . $attachmaxi . '"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: attachpath<br> Description: If you enabled project attachments above, you must specify the full path to where the attachments will be uploaded to (DO NOT include a trailing slash). You MUST CHMOD this directory\'s permissions to 777!<br> Example: /home/mywebsite/public_html/freelancers/uploads<br> <input type="text" name="newattachpath" size="60" value="' . $attachpath . '"> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: attachurl<br> Description: If you enabled project attachments above, you must specify the full directory URL to where attachments will be uploaded to (DO NOT include a trailing slash). You MUST CHMOD this directory\'s permissions to 777!<br> Example: ' . $siteurl . '/uploads<br> <input type="text" name="newattachurl" size="60" value="' . $attachurl . '"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: catname<br> Description: This is the title of the categories inwhich "freelancers" choose to become experts of and "buyers" select as categories involving their project.<br> Example: Job Type<br> <input type="text" name="newcatname" size="19" value="' . $catname . '"> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: categories<br> Description: These are the categories inwhich "freelancers" choose to become experts of and "buyers" select as relevencies to their project (separate the categories by a "~", except without the quotes).<br> Example: Tests~Demos~Uploads~Attachments<br> <textarea name="newcategories" rows="8" cols="52" wrap="off">' . $categories . '</textarea> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: pcat1<br> Description: If you want an extra category selection for "buyers" to select from when creating a project, provide the name of this extra category.<br> Example: Location<br> <input type="text" name="newpcat1" size="26" value="' . $pcat1 . '"> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: pcat1val<br> Description: If you chose to have an extra category above, provide the selections that can be made for that extra category (separate the categories by "***", except without the quotes).<br> Example: Washington, DC***Ottawa, ON***Mexico City, Mexico<br> <textarea name="newpcat1val" rows="8" cols="52" wrap="off">' . $pcat1val . '</textarea> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: pcat2<br> Description: If you want a second extra category selection for "buyers" to select from when creating a project, provide the name of that second extra category.<br> Example: Website Status<br> <input type="text" name="newpcat2" size="26" value="' . $pcat2 . '"> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: pcat2val<br> Description: If you chose to have a second extra category above, provide the selections that can be made for that second extra category (separate the categories by "***", except without the quotes).<br> Example: Active***Under Construction***Inactive<br> <textarea name="newpcat2val" rows="8" cols="52" wrap="off">' . $pcat2val . '</textarea> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: pcat3<br> Description: If you want a third extra category selection for "buyers" to select from when creating a project, provide the name of that third extra category.<br> Example: Project Size<br> <input type="text" name="newpcat3" size="26" value="' . $pcat3 . '"> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: pcat3val<br> Description: If you chose to have a third extra category above, provide the selections that can be made for that third extra category (separate the categories by "***", except without the quotes).<br> Example: Huge***Large***Average***Small***Tiny<br> <textarea name="newpcat3val" rows="8" cols="52" wrap="off">' . $pcat3val . '</textarea> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: balexpdays<br> Description: Specify the days when users will receive automatic warnings of a balance lower than ' . $currencytype . '' . $currency . '0.00 in their account (separate the categories by a "-", except without the quotes). The last warning day should be 1 below the low balance maximum day.<br> Example: 25-26-27-28-29<br> <input type="text" name="newbalexpdays" size="37" value="' . $balexpdays . '"> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: balmaxdays<br> Description: Specify the day when users will receive an automatic account suspension message (they will be suspended) of a balance lower than ' . $currencytype . '' . $currency . '0.00 in their account and will remain suspended until they add funds enough to make their account balance a positive number.<br> Example: 30<br> <input type="text" name="newbalmaxdays" size="4" value="' . $balmaxdays . '"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: tableborder<br> Description: The border that will be placed on all tables in PHP Freelancers.<br> Example: 0<br> <input type="text" name="newtableborder" size="3" value="' . $tableborder . '"> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: tablecellsp<br> Description: The cell spacing amount that will be placed inbetween all cells on all tables in PHP Freelancers.<br> Example: 0<br> <input type="text" name="newtablecellsp" size="3" value="' . $tablecellsp . '"> </font></div></td> </tr> <tr> <td bgcolor="#EEEEEF" align="center" valign="middle"> <div align="left">Name: tablecellpa<br> Description: The cell padding amount that will be placed on all cells on all table in PHP Freelancers.<br> Example: 2<br> <input type="text" name="newtablecellpa" size="3" value="' . $tablecellpa . '"> </font></div></td> </tr> <tr> <td bgcolor="#D5D6D8" align="center" valign="middle"> <div align="left">Name: tablecolort<br> Description: The color of the text that will be placed on all headers of tables in PHP Freelancers (color codes are allowed).<br> Example: #CCCCCC<br> <input type="text" name="newtablecolort" size="21" value="' . $tablecolort . '"> </font></div></td> </tr> <tr>

Thanks for your help regards Sean

or can anyone help to extract the SQL so I can dump it into phpmyadmin ?

can anyone tell me why this script will not run on my machine ???? <?php if ($setup == "go") { require "vars.php"; $ress = SQLact("query", "SELECT * FROM freelancers_count"); $num_rows = @SQLact("num_rows", $ress); if ($num_rows==0) { SQLact("query", "CREATE TABLE freelancers_announcements (date VARCHAR(10) NOT NULL, date2 VARCHAR(10) NOT NULL, announce BLOB NOT NULL, announce2 BLOB NOT NULL)"); SQLact("query", "INSERT INTO freelancers_announcements (date, date2, announce, announce2) VALUES ('', '', '', '')"); SQLact("query", "CREATE TABLE freelancers_archived (date VARCHAR(250) NOT NULL, date2 INT(10) NOT NULL, username VARCHAR(250) NOT NULL, atype VARCHAR(10) NOT NULL, wtype VARCHAR(200) NOT NULL, amount VARCHAR(12) NOT NULL, namount VARCHAR(12) NOT NULL)"); SQLact("query", "CREATE TABLE freelancers_bans (ip VARCHAR(250) NOT NULL, reason BLOB NOT NULL)"); SQLact("query", "CREATE TABLE freelancers_bids (username VARCHAR(250) NOT NULL, status VARCHAR(9) NOT NULL, id VARCHAR(12) NOT NULL, project VARCHAR(250) NOT NULL, special VARCHAR( NOT NULL, amount VARCHAR(10) NOT NULL, delivery VARCHAR(4) NOT NULL, date VARCHAR(20) NOT NULL, details BLOB NOT NULL, date2 INT(10) NOT NULL, chosen VARCHAR(250) NOT NULL, outbid CHAR(1) NOT NULL)"); SQLact("query", "CREATE TABLE freelancers_cats (categories VARCHAR(250) NOT NULL)"); SQLact("query", "INSERT INTO freelancers_cats (categories) VALUES ('Buiders')"); SQLact("query", "INSERT INTO freelancers_cats (categories) VALUES ('Electricans')"); SQLact("query", "INSERT INTO freelancers_cats (categories) VALUES ('Plumbers')"); SQLact("query", "INSERT INTO freelancers_cats (categories) VALUES ('Joiners')"); SQLact("query", "INSERT INTO freelancers_cats (categories) VALUES ('Roofers')"); SQLact("query", "INSERT INTO freelancers_cats (categories) VALUES ('Groundworkers')"); SQLact("query", "INSERT INTO freelancers_cats (categories) VALUES ('Earthworks')"); SQLact("query", "INSERT INTO freelancers_cats (categories) VALUES ('Painters')"); SQLact("query", "CREATE TABLE freelancers_count (count VARCHAR(12) NOT NULL)"); SQLact("query", "INSERT INTO freelancers_count (count) VALUES ('102402089011')"); SQLact("query", "CREATE TABLE freelancers_cron (lastday VARCHAR( NOT NULL)"); $today = date("Ymd"); SQLact("query", "INSERT INTO freelancers_cron (lastday) VALUES ('$today')"); SQLact("query", "CREATE TABLE freelancers_deposits (username VARCHAR(250) NOT NULL, atype VARCHAR(10) NOT NULL, amount VARCHAR(20) NOT NULL, total VARCHAR(20) NOT NULL, oid VARCHAR(12) NOT NULL, ptype VARCHAR(6) NOT NULL, status VARCHAR( NOT NULL)"); SQLact("query", "CREATE TABLE freelancers_edittemp (email VARCHAR(250) NOT NULL, id VARCHAR(10) NOT NULL, username VARCHAR(250) NOT NULL, atype VARCHAR(10) NOT NULL)"); SQLact("query", "CREATE TABLE freelancers_forum (pid VARCHAR(12) NOT NULL, froom VARCHAR(250) NOT NULL, acctype VARCHAR(10) NOT NULL, date VARCHAR(18) NOT NULL, date2 VARCHAR(10) NOT NULL, private VARCHAR(250) NOT NULL, privatetype VARCHAR(10) NOT NULL, message BLOB NOT NULL, mid VARCHAR(10) NOT NULL)"); SQLact("query", "CREATE TABLE freelancers_logins (username VARCHAR(250) NOT NULL, date VARCHAR(10) NOT NULL, atype VARCHAR(10) NOT NULL)"); SQLact("query", "CREATE TABLE freelancers_profits (amount VARCHAR(20) NOT NULL, type VARCHAR(10) NOT NULL, type2 VARCHAR(6) NOT NULL, month CHAR(2) NOT NULL, year VARCHAR(10) NOT NULL)"); SQLact("query", "CREATE TABLE freelancers_programmers (username VARCHAR(250) NOT NULL, password VARCHAR(250) NOT NULL, company VARCHAR(250) NOT NULL, categories BLOB NOT NULL, rate VARCHAR(10) NOT NULL, profile BLOB NOT NULL, notify VARCHAR(250) NOT NULL, id VARCHAR(12) NOT NULL, email VARCHAR(250) NOT NULL, special VARCHAR(4) NOT NULL, ip VARCHAR(250) NOT NULL, wname VARCHAR(250) NOT NULL, waddress VARCHAR(250) NOT NULL, wcity VARCHAR(250) NOT NULL, wzip VARCHAR(250) NOT NULL, wemail VARCHAR(250) NOT NULL, wbankyourname VARCHAR(250) NOT NULL, wbankname VARCHAR(250) NOT NULL, wbankaddress VARCHAR(250) NOT NULL, wbankaddress2 VARCHAR(250) NOT NULL, wbankcity VARCHAR(200) NOT NULL, wbankstate VARCHAR(150) NOT NULL, wbankcountry VARCHAR(185) NOT NULL, wbankzip VARCHAR(20) NOT NULL, wbankaccnum VARCHAR(220) NOT NULL, wbankcode VARCHAR(140) NOT NULL, wbankacctype CHAR(2) NOT NULL, wothercontent BLOB NOT NULL, portfolio BLOB NOT NULL)"); SQLact("query", "CREATE TABLE freelancers_projects (chosen VARCHAR(250) NOT NULL, status VARCHAR(9) NOT NULL, id VARCHAR(12) NOT NULL, date2 INT(10) NOT NULL, project VARCHAR(250) NOT NULL, special VARCHAR( NOT NULL, categories BLOB NOT NULL, expires VARCHAR(4) NOT NULL, budgetmin VARCHAR(250) NOT NULL, budgetmax VARCHAR(250) NOT NULL, creation VARCHAR(10) NOT NULL, ctime VARCHAR(5) NOT NULL, creator VARCHAR(250) NOT NULL, description BLOB NOT NULL, attachment VARCHAR(250) NOT NULL, pcat1val BLOB NOT NULL, pcat2val BLOB NOT NULL, pcat3val BLOB NOT NULL)"); SQLact("query", "CREATE TABLE freelancers_ratings (username VARCHAR(250) NOT NULL, rating CHAR(2) NOT NULL, ratedby VARCHAR(250) NOT NULL, projid VARCHAR(12) NOT NULL, projname VARCHAR(250) NOT NULL, projdate VARCHAR(20) NOT NULL, comments BLOB NOT NULL, type VARCHAR(10) NOT NULL, status VARCHAR(5) NOT NULL, type2 VARCHAR(10) NOT NULL)"); SQLact("query", "CREATE TABLE freelancers_refunds (id VARCHAR(10) NOT NULL)"); SQLact("query", "CREATE TABLE freelancers_setup (siteurl VARCHAR(250) NOT NULL, toplayout BLOB NOT NULL, bottomlayout BLOB NOT NULL, emailheader BLOB NOT NULL, emailfooter BLOB NOT NULL, emailaddress VARCHAR(250) NOT NULL, companyname VARCHAR(250) NOT NULL, bsbamount VARCHAR(250) NOT NULL, fsbamount VARCHAR(250) NOT NULL, frefamount VARCHAR(250) NOT NULL, brefamount VARCHAR(250) NOT NULL, address VARCHAR(250) NOT NULL, city VARCHAR(250) NOT NULL, state VARCHAR(250) NOT NULL, country VARCHAR(250) NOT NULL, zipcode VARCHAR(250) NOT NULL, currency VARCHAR(250) NOT NULL, currencytype VARCHAR(250) NOT NULL, buyer VARCHAR(250) NOT NULL, buyers VARCHAR(250) NOT NULL, freelancer VARCHAR(250) NOT NULL, freelancers VARCHAR(250) NOT NULL, mode VARCHAR(4) NOT NULL, adminpass VARCHAR(250) NOT NULL, attachmode VARCHAR( NOT NULL, attachmaxi VARCHAR(15) NOT NULL, attachpath VARCHAR(250) NOT NULL, attachurl VARCHAR(250) NOT NULL, catname VARCHAR(250) NOT NULL, pcat1 VARCHAR(250) NOT NULL, pcat1val BLOB NOT NULL, pcat2 VARCHAR(250) NOT NULL, pcat2val BLOB NOT NULL, pcat3 VARCHAR(250) NOT NULL, pcat3val BLOB NOT NULL, balexpdays VARCHAR(250) NOT NULL, balmaxdays VARCHAR(10) NOT NULL, tableborder CHAR(2) NOT NULL, tablecellsp CHAR(2) NOT NULL, tablecellpa CHAR(2) NOT NULL, tablecolort VARCHAR(250) NOT NULL, tablecolorh VARCHAR(250) NOT NULL, tablecolor1 VARCHAR(250) NOT NULL, tablecolor2 VARCHAR(250) NOT NULL, ppemailaddr VARCHAR(250) NOT NULL, deposit2checkout VARCHAR(7) NOT NULL, depositpaypal VARCHAR(7) NOT NULL, depositccurl VARCHAR(250) NOT NULL, depositccper VARCHAR(5) NOT NULL, depositccfee VARCHAR(5) NOT NULL, depositccpay VARCHAR(250) NOT NULL, depositccsid VARCHAR(10) NOT NULL, depositccaut VARCHAR(7) NOT NULL, depositppper VARCHAR(5) NOT NULL, depositppfee VARCHAR(5) NOT NULL, depositppaut VARCHAR(7) NOT NULL, depositmail VARCHAR(7) NOT NULL, depositmlfee VARCHAR(5) NOT NULL, depositother VARCHAR(7) NOT NULL, depositnotify VARCHAR(7) NOT NULL, feedbackcmax VARCHAR(10) NOT NULL, projectper VARCHAR(10) NOT NULL, projectfee VARCHAR(10) NOT NULL, projectper2 VARCHAR(10) NOT NULL, projectfee2 VARCHAR(10) NOT NULL, withdrawcfee VARCHAR(10) NOT NULL, withdrawpaypal VARCHAR(7) NOT NULL, withdrawpfee VARCHAR(10) NOT NULL, withdrawwire VARCHAR(7) NOT NULL, withdrawwfee VARCHAR(10) NOT NULL, withdrawother VARCHAR(7) NOT NULL, withdrawofee VARCHAR(10) NOT NULL, withdrawonam VARCHAR(250) NOT NULL, withdrawoins BLOB NOT NULL, withdrawmini VARCHAR(10) NOT NULL, withdrawnotify VARCHAR(7) NOT NULL, multiplecats VARCHAR(7) NOT NULL, featuredcost VARCHAR(60) NOT NULL, mprojectdays VARCHAR(5) NOT NULL, projectudays VARCHAR(250) NOT NULL, forumnextnum VARCHAR(100) NOT NULL, maxextend CHAR(3) NOT NULL, userportfolio VARCHAR(7) NOT NULL, refreturn1 VARCHAR(250) NOT NULL, refreturn2 VARCHAR(250) NOT NULL)"); SQLact("query", "INSERT INTO freelancers_setup (siteurl, toplayout, bottomlayout, emailheader, emailfooter, emailaddress, companyname, bsbamount, fsbamount, frefamount, brefamount, address, city, state, country, zipcode, currency, currencytype, buyer, buyers, freelancer, freelancers, mode, adminpass, attachmode, attachmaxi, attachpath, attachurl, catname, pcat1, pcat1val, pcat2, pcat2val, pcat3, pcat3val, balexpdays, balmaxdays, tableborder, tablecellsp, tablecellpa, tablecolort, tablecolorh, tablecolor1, tablecolor2, ppemailaddr, deposit2checkout, depositpaypal, depositccurl, depositccper, depositccfee, depositccpay, depositccsid, depositccaut, depositppper, depositppfee, depositppaut, depositmail, depositmlfee, depositother, depositnotify, feedbackcmax, projectper, projectfee, projectper2, projectfee2, withdrawcfee, withdrawpaypal, withdrawpfee, withdrawwire, withdrawwfee, withdrawother, withdrawofee, withdrawonam, withdrawoins, withdrawmini, withdrawnotify, multiplecats, featuredcost, mprojectdays, projectudays, forumnextnum, maxextend, userportfolio, refreturn1, refreturn2) VALUES ('" . $url . "', '<title>Freelance</title>My Header<p>Buyers: <a href=\"webmasters.php?new=user\">Sign Up</a> - <a href=\"webmasters.php?new=project\">Create Project</a> - <a href=\"webmasters.php?login=now\">Manage Account</a> - <a href=\"webmasters.php?logout=now\">Sign Out</a><br>Freelancers: <a href=\"freelancers.php?new=user\">Sign Up</a> - <a href=\"freelancers.php?login=now\">Manage Account</a> - <a href=\"freelancers.php?logout=now\">Sign Out</a><br>General: <a href=\"search.php?showstatus=open\">View Open Projects</a> - <a href=\"search.php\">Find A Project</a> - <a href=\"send.php\">Send Message</a><hr>', '<hr><br>My Footer', 'E-Mail Header', 'E-Mail Footer', 'neo@cyberia.ca', 'Freelance', '5.00', '1.00', '0.25', '0.75', 'Demo Address', 'Demo City', 'Demo State', 'Demo Country', 'Demo Zip/Postal Code', '\$', 'US', 'Buyer', 'Buyers', 'Freelancer', 'Freelancers', 'demo', 'admin', 'enabled', '59200', '/home/user/public_html/attachments', '" . $url . "/attachments', 'Job Type', 'Location', 'Someplace, 4U***Nowhere, IC***Everywhere, UN', '', '', '', '', '25-26-27-28-29', '30', '0', '0', '2', '#000000', '#CCCCCC', '#EFEFEF', '#CCCCCC', 'neo@cyberia.ca', 'enabled', 'enabled', '', '5.5', '0.45', 'https://www.2checkout.com/cgi-bin/buyers/cartpurchase1.2c?sid=', '14387', 'enabled', '2.9', '0.30', 'enabled', 'enabled', '1', 'enabled', 'enabled', '200', '7', '9.00', '3', '1.00', '1.00', 'enabled', '1.00', 'enabled', '20.00', 'enabled', '1.00', 'Western Union Transfer', 'Provide your name and address please.', '25.00', 'enabled', 'enabled', '10.00', '90', '0-1-2-3', '10', '7', '', '$url', '$url')"); SQLact("query", "CREATE TABLE freelancers_subjects (pid VARCHAR(12) NOT NULL, subject BLOB NOT NULL, date VARCHAR(20) NOT NULL, date2 INT(10) NOT NULL)"); SQLact("query", "CREATE TABLE freelancers_suspends (ip VARCHAR(250) NOT NULL, reason BLOB NOT NULL)"); SQLact("query", "CREATE TABLE freelancers_temp (email VARCHAR(250) NOT NULL, id VARCHAR(12) NOT NULL)"); SQLact("query", "CREATE TABLE freelancers_transactions (amount VARCHAR(250) NOT NULL, details BLOB NOT NULL, username VARCHAR(250) NOT NULL, type VARCHAR(10) NOT NULL, balance VARCHAR(50) NOT NULL, date VARCHAR(100) NOT NULL, date2 INT(10) NOT NULL)"); SQLact("query", "CREATE TABLE freelancers_webmasters (username VARCHAR(250) NOT NULL, password VARCHAR(250) NOT NULL, company VARCHAR(250) NOT NULL, email VARCHAR(250) NOT NULL, bidnotify CHAR(1) NOT NULL, id VARCHAR(12) NOT NULL, ip VARCHAR(250) NOT NULL, special VARCHAR(250) NOT NULL, wname VARCHAR(250) NOT NULL, waddress VARCHAR(250) NOT NULL, wcity VARCHAR(250) NOT NULL, wzip VARCHAR(250) NOT NULL, wemail VARCHAR(250) NOT NULL, wbankyourname VARCHAR(250) NOT NULL, wbankname VARCHAR(250) NOT NULL, wbankaddress VARCHAR(250) NOT NULL, wbankaddress2 VARCHAR(250) NOT NULL, wbankcity VARCHAR(200) NOT NULL, wbankstate VARCHAR(150) NOT NULL, wbankcountry VARCHAR(185) NOT NULL, wbankzip VARCHAR(20) NOT NULL, wbankaccnum VARCHAR(220) NOT NULL, wbankcode VARCHAR(140) NOT NULL, wbankacctype CHAR(2) NOT NULL, wothercontent BLOB NOT NULL)"); SQLact("query", "CREATE TABLE freelancers_withdrawals (date VARCHAR(250) NOT NULL, date2 INT(10) NOT NULL, username VARCHAR(250) NOT NULL, atype VARCHAR(10) NOT NULL, wtype VARCHAR(200) NOT NULL, amount VARCHAR(12) NOT NULL, name VARCHAR(250) NOT NULL, address VARCHAR(250) NOT NULL, city VARCHAR(250) NOT NULL, zip VARCHAR(250) NOT NULL, email VARCHAR(250) NOT NULL, bankyourname VARCHAR(250) NOT NULL, bankname VARCHAR(250) NOT NULL, bankaddress VARCHAR(250) NOT NULL, bankaddress2 VARCHAR(250) NOT NULL, bankcity VARCHAR(200) NOT NULL, bankstate VARCHAR(150) NOT NULL, bankcountry VARCHAR(185) NOT NULL, bankzip VARCHAR(20) NOT NULL, bankaccnum VARCHAR(220) NOT NULL, bankcode VARCHAR(140) NOT NULL, bankacctype CHAR(2) NOT NULL, status VARCHAR( NOT NULL, othercontent BLOB NOT NULL, wfee VARCHAR(12) NOT NULL, namount VARCHAR(12) NOT NULL)") or die ("You must first customize the MySQL connections in vars.php to match yours or this script will not be setup!"); SQLact("query", "CREATE TABLE freelancers_escrow (id varchar(250) NOT NULL,webmaster varchar(250) NOT NULL, programmer varchar(250) NOT NULL, amount varchar(250) NOT NULL, PRIMARY KEY (id,webmaster)) TYPE=MyISAM"); echo 'SUCCESS: Your MySQL has now been successfully setup!<br> Now, <a href="' . $url . 'control/admin_install.php?pass=admin">click here</a> to finish the setup process by filling out the admin fields, etc.<br>'; } else { echo 'ERROR: This file has already been run successfully <a href="' . $url . 'control/admin_install.php?pass=admin">click here</a> to finish the setup process by filling out the admin fields, etc.<br><br>'; } } else { ?> Only Run Once or all data will be over written. <a href="install.php?setup=go">Click here</a> to install.<br>. <?php } ?>