seanstuart Posted December 23, 2007 Share Posted December 23, 2007 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 } ?> Quote Link to comment https://forums.phpfreaks.com/topic/82934-solved-sql-script-wont-run/ Share on other sites More sharing options...
seanstuart Posted December 23, 2007 Author Share Posted December 23, 2007 or can anyone help to extract the SQL so I can dump it into phpmyadmin ? Quote Link to comment https://forums.phpfreaks.com/topic/82934-solved-sql-script-wont-run/#findComment-421811 Share on other sites More sharing options...
xiao Posted December 23, 2007 Share Posted December 23, 2007 Is that the whole code? Do you use REGISTER_GLOBALS? else replace if ($setup == "go") { with if ($_GET['setup'] == "go") { Quote Link to comment https://forums.phpfreaks.com/topic/82934-solved-sql-script-wont-run/#findComment-421813 Share on other sites More sharing options...
seanstuart Posted December 23, 2007 Author Share Posted December 23, 2007 Thanks for your help regards Sean Quote Link to comment https://forums.phpfreaks.com/topic/82934-solved-sql-script-wont-run/#findComment-421816 Share on other sites More sharing options...
xiao Posted December 23, 2007 Share Posted December 23, 2007 No problem. Did it work? Or was it something else? Quote Link to comment https://forums.phpfreaks.com/topic/82934-solved-sql-script-wont-run/#findComment-421818 Share on other sites More sharing options...
seanstuart Posted December 30, 2007 Author Share Posted December 30, 2007 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> Quote Link to comment https://forums.phpfreaks.com/topic/82934-solved-sql-script-wont-run/#findComment-425961 Share on other sites More sharing options...
seanstuart Posted December 30, 2007 Author Share Posted December 30, 2007 <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 Quote Link to comment https://forums.phpfreaks.com/topic/82934-solved-sql-script-wont-run/#findComment-425963 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.