Jump to content

[SOLVED] SQL script won't run


seanstuart

Recommended Posts

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

}
?>

 

:(

Link to comment
Share on other sites

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> 
      

 

 

 

Link to comment
Share on other sites

 

<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

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.