попробуй свой install-код заменить на этот:
<?php
if ($_GET['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(8) 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 ('PHP')");
SQLact("query", "INSERT INTO freelancers_cats (categories) VALUES ('Website Design')");
SQLact("query", "INSERT INTO freelancers_cats (categories) VALUES ('Graphic Design')");
SQLact("query", "INSERT INTO freelancers_cats (categories) VALUES ('PERL')");
SQLact("query", "INSERT INTO freelancers_cats (categories) VALUES ('Windows')");
SQLact("query", "INSERT INTO freelancers_cats (categories) VALUES ('Other Programming')");
SQLact("query", "INSERT INTO freelancers_cats (categories) VALUES ('Operating')");
SQLact("query", "INSERT INTO freelancers_cats (categories) VALUES ('Javascript')");
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(8) 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(8) 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(8) 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(8) 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', 'admin@popscript.com', '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', 'admin@popscript.com', '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(8) 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
}
?>