install.php (PARTE1 DEL SCRIPT)
$q1 = "INSERT INTO re2_settings VALUES ('1', 'My Real Estate', 'My Real Estate', 'real estate, sales, rent, for rent, for sale, house, houses, appartment, appartments, studio, studios, rooms', 'Find property for sale and rent', '
[email protected]', '1234 My Street/r/n Red Deer, Alberta /r /nCanada', '
[email protected]', '12345', '<strong>User Agreement</strong><br> <p><br>The information presented by this siteis deemed to be accurate, but it has not been independently verified. We make no guarantee, warranty or representation. It is the user\'s responsibility to independently confirm accuracy and completeness. </p><p>User Conduct<br>User agrees to abide by all applicable local, state, national and foreign laws, treatises and regulations in connection with the service. The user agrees to not transmit or post information that is harmful to other members.</p<p>Termination<br>This website in its sole discretion, may terminate user\'s password, account or use of the service and remove and discard any data within the service if user fails to comply with this Agreement. User may terminate the service upon notice to this website at any time; however, user will not receive a refund of any portion of fees paid. Upon termination, user\'s rights to use the service, web solutions, domain name, design and associate technologies will also terminate. </p><p>Indemnification<br>User shall indemnify and hold e1solutions and its parents, subsidiaries, affiliates, officers, directors, employees, attorneys, and agents, harmless from and against any and all claims, costs, damages, losses, liabilities, and expenses (including attorneys\' fees and costs) arising out of, or in connection with user\'s use of the service (including the content) or breach of this Agreement. </p><p>Limitation of Liability<br>In no event shall this website aggregate liability exceed the amount actually paid by user in the twelve (12) month period immediately preceding the event giving rise to such a claim. In no event shall e1 Solutions be liable to anyone for any indirect, punitive, special, exemplary, incidental, consequential or other damages of any type or kind arising out of, or in any way connected with this service, including but not limited to user\'s use or inability to use the service or for any content obtained from or through the service, even if e1 solutions has been previously advised of the possibility of such damages. </p><p><br></p>', '', '', '')";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);
$q1 = "DROP TABLE IF EXISTS re2_stats";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);
$q1 = "CREATE TABLE re2_stats (
BannerID int(10) NOT NULL default '0',
impressions int(10) NOT NULL default '0',
clicks int(10) NOT NULL default '0',
mydate int(10) NOT NULL default '0',
ip varchar(50) NOT NULL default '')";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);
$q1 = "DROP TABLE IF EXISTS re2_subcategories";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);
$q1 = "CREATE TABLE re2_subcategories (
SubcategoryID int(10) NOT NULL auto_increment,
SubcategoryName varchar(255) NOT NULL default '',
CategoryID int(10) NOT NULL default '0',
PRIMARY KEY (SubcategoryID))";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);
$q1 = "INSERT INTO re2_subcategories VALUES (3, 'Apartments/Suites', 4)";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);
$q1 = "INSERT INTO re2_subcategories VALUES (4, 'Duplexes/Houses', 4)";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);
$q1 = "INSERT INTO re2_subcategories VALUES (5, 'Farms/Lots and Acreages', 4)";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);
$q1 = "INSERT INTO re2_subcategories VALUES (6, 'Garages & Parking Space', 4)";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);
$q1 = "INSERT INTO re2_subcategories VALUES (7, 'Mobile Homes', 4)";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);
$q1 = "INSERT INTO re2_subcategories VALUES (8, 'Out of Town', 4)";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);
$q1 = "INSERT INTO re2_subcategories VALUES (9, 'Room and Board/Rooms', 4)";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);
$q1 = "INSERT INTO re2_subcategories VALUES (10, 'Shared Accomodation', 4)";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);
$q1 = "INSERT INTO re2_subcategories VALUES (11, 'Storage Space', 4)";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);
$q1 = "INSERT INTO re2_subcategories VALUES (12, 'Townhouses/Condos', 4)";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);
$q1 = "INSERT INTO re2_subcategories VALUES (13, 'Vacation Rentals', 4)";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);
$q1 = "INSERT INTO re2_subcategories VALUES (14, 'Wanted to Rent', 4)";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);
$q1 = "INSERT INTO re2_subcategories VALUES (15, 'Commercial/Industrial', 3)";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);
$q1 = "INSERT INTO re2_subcategories VALUES (16, 'Duplexes/Houses', 3)";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);
$q1 = "INSERT INTO re2_subcategories VALUES (17, 'Farms/Ranches', 3)";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);
$q1 = "INSERT INTO re2_subcategories VALUES (18, 'Income Properties', 3)";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);
$q1 = "INSERT INTO re2_subcategories VALUES (19, 'Lots/Acreages', 3)";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);
$q1 = "INSERT INTO re2_subcategories VALUES (20, 'Mobile Homes', 3)";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);
$q1 = "INSERT INTO re2_subcategories VALUES (21, 'New Homes', 3)";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);
$q1 = "INSERT INTO re2_subcategories VALUES (22, 'Opem Houses', 3)";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);
$q1 = "INSERT INTO re2_subcategories VALUES (23, 'Real Estate Services', 3)";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);
$q1 = "INSERT INTO re2_subcategories VALUES (24, 'Vacation Property', 3)";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);
$q1 = "INSERT INTO re2_subcategories VALUES (25, 'Wanted', 3)";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);
$q1 = "DROP TABLE IF EXISTS re2_types";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);
$q1 = "CREATE TABLE re2_types (
TypeID int(10) NOT NULL auto_increment,
TypeName varchar(100) NOT NULL default '',
PRIMARY KEY (TypeID),
UNIQUE KEY TypeName(TypeName))";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);
$q1 = "INSERT INTO re2_types VALUES (20, 'Farm')";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);
$q1 = "INSERT INTO re2_types VALUES (19, 'Acreage')";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);
$q1 = "INSERT INTO re2_types VALUES (18, 'Ranch')";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);
$q1 = "INSERT INTO re2_types VALUES (17, 'Townhouse')";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);
$q1 = "INSERT INTO re2_types VALUES (16, 'Rooms')";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);
$q1 = "INSERT INTO re2_types VALUES (15, 'Mobile Home')";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);
$q1 = "INSERT INTO re2_types VALUES (14, 'Lot')";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);
$q1 = "INSERT INTO re2_types VALUES (13, 'Land')";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);
$q1 = "INSERT INTO re2_types VALUES (12, 'Industrial')";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);
$q1 = "INSERT INTO re2_types VALUES (11, 'Houses')";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);
$q1 = "INSERT INTO re2_types VALUES (10, 'Condo')";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);
$q1 = "INSERT INTO re2_types VALUES (8, 'Commercial')";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);
$q1 = "INSERT INTO re2_types VALUES (9, 'Appartments')";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);
echo "<center><br><br><br><font face=tahoma, verdana, helvetica, arial size=2 color=black><b>The database tables was installed successfully!<br><br>Delete this file from your server!</b></font></center>";
?>