Jump to content

stevens

Members
 View Profile  See their activity

  • Posts

    20

  • Joined

  • Last visited

 Content Type 

Everything posted by stevens

  1. stevens
    Works perfectly now!! There was an error as it couldnt find "name" field, so i changed it to "word" and it worked! my fault for changing the name field to word half way through coding!! Thanks a million for your help.
  2. stevens
    Still doesnt work ??? yet there is no error message either. Im lost now, I have no idea why it is not working. Thanks for your help though.
  3. stevens
    [quote author=king arthur link=topic=103338.msg411447#msg411447 date=1154994071] [code] $names_array = explode(",", $names); $result = mysql_query("select id from mytable order by id"); $i = 0; while($row = mysql_fetch_assoc($result)) { $r = mysql_query("update mytable set name=" . $names_array[$i] . " where id=" . $row["id"]); } [/code] See if that works. Obviously change "mytable" to the name of your table.[/quote] Hi, no errors show, but it does not update the database, any ideas? Thanks. This is my code: [quote]$words = $_POST['words']; $connection = mysql_connect($hostname, $user, $pass) or die ("Unable to connect!"); mysql_select_db($db, $connection); if ($words) { $word_array = explode(",", $words); $result = mysql_query("SELECT id FROM details ORDER BY id"); $i = 0; while($row = mysql_fetch_assoc($result)) { $r = mysql_query("UPDATE details SET word=" . $word_array[$i] . " WHERE id=" . $row["id"]); } }[/quote] Do i need to do $i + 1 in the mysql_fetch_assoc? so its adds 1 each row?
  4. stevens
    [quote author=ToonMariner link=topic=103338.msg411424#msg411424 date=1154991425] so if you generate you query string in a doo loop you could do it all pretty quickly. [/quote] How would i do this in a do loop?
  5. stevens
    [quote author=king arthur link=topic=103338.msg411436#msg411436 date=1154991765] Ok, well are all the id fields in contiguous order? Then you could do it as ToonMariner says, with a loop incrementing the id for each query. If not, then pull all the id's out first and then update the rows with names for each id you pulled out. [/quote] Ok I have managed to get all my current names into a text field seperated by a comma (,) Now i need to insert these into the table (yes the id fields are in contiguous order). How can insert these into the db? at the moment they are all stored together in the variable $names seperated by a comma. If i do an explode to seperate each of the names i am going to have to do it 400 times, there must be an easier way?
  6. stevens
    [quote author=ToonMariner link=topic=103338.msg411424#msg411424 date=1154991425] no you would need to change each name individually BUt you can do it in one query. $qry = "UPDATE table SET name = 'tom' WHERE id='1'"; $qry = mysql_query($qry); That is your query to update an individual record. Now you could have: $qry = "UPDATE table SET name = 'tom' WHERE id='1';"; $qry .= "UPDATE table SET name = 'dick' WHERE id='2';"; $qry .= "UPDATE table SET name = 'harry' WHERE id='3';"; $qry = mysql_query($qry); so if you generate you query string in a doo loop you could do it all pretty quickly. [/quote] So i could create a text area and input 400 names seperated by a comma. Then do an explode function on the commas and i would get 400 variables i could insert into the 400 query's. Is that correct?
  7. stevens
    [quote author=king arthur link=topic=103338.msg411422#msg411422 date=1154991347] How are the list of names defined? [/quote] ??? currently i do not have a list of names to input. I was thinking of creating a text field where i could enter the names seperated by a comma and then input this into the query. Is that what you mean?
  8. stevens
    Hi I hope you can help me. I need to update 1 field in every record of my database, how can i do this? I have the following fields in my table: id name address email I want to update the 'name' field in every record in the table (around 400) each with a different name. Could i use something like this: [quote]$query = "UPDATE table SET name = 'tom', name = 'bob', name = 'john', etc...";[/quote] Somehow i dont think the above query will work  :-[, lol. So how can i do this? thanks.
  9. stevens
    Hi everyone and thanks for your help, Unfortunatly none of your answers worked. My database is being called in the config.php for you who were not sure. @wildteen I changed my code to what you posted but still got the same error - Isnt the code you posted the same as what i already had? thanks anyway. [size=18pt][color=red][b]EDIT: I HAVE SORTED IT NOW, I FOUND THE ERROR. THE ERROR WAS THE SECOND QUERY & RESULT NAME. I CHANGED IT TO QUERY2 & RESULT2 AND NO ERRORS  ;D THANKS AGAIN FOR YOUR HELP GUYS[/b][/color][/size]
  10. stevens
    Hi I am running the script below and it works perfectly (updates the database ok) yet displays the following error, please help me undertsand why. Thankyou. (The code is to be run by a cron job to check whether an account has expired) Error Message: [quote]PHP Warning:  mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /2.php on line 9[/quote] Code: [quote]<?php include("config.php"); $connection = mysql_connect($hostname, $user, $pass) or die ("Unable to connect!"); $query = "SELECT * FROM details WHERE order_no != 0"; $result = mysql_db_query($db, $query, $connection) or die ("Could not execute query: $query. " . mysql_error()); while ($newArray = mysql_fetch_assoc($result)) {      $order_no = $newArray['order_no']; $word = $newArray['word'];      $email = $newArray['cust_email'];     $start_date = $newArray['start_date']; $end_date = $newArray['end_date']; $date = date("Y-m-d"); if ($end_date == $date) { $query = "DO QUERY"; $result = mysql_db_query($db, $query, $connection) or die ("Could not execute query: $query. " . mysql_error());     $subject = "YOUR ACCOUNT HAS NOW EXPIRED"; $msg = "THE ACCOUNT YOU HAVE PURCHASED ON ".$domain." HAS NOW EXPIRED\n\n";     mail($email, $subject, $msg, "From: ".$orderemail); } else { $days_left = (strtotime($end_date) - strtotime(date("Y-m-d"))) / (60 * 60 * 24); if ($days_left == '30') {     $subject = "YOUR ACCOUNT IS EXPIRING IN 30 DAYS"; $msg = "THE ACCOUNT YOU HAVE PURCHASED ON ".$domain." IS EXPIRING IN 30 DAYS\n\n";     $msg.= "PLEASE LOGIN TO YOUR MEMBERS ACCOUNT NOW\n\n";     mail($email, $subject, $msg, "From: ".$orderemail); } } echo "$days_left"; } ?> [/quote]
  11. stevens
    D'oh! Thanks.
  12. stevens
    How can i make this return cost_check if they dont match? This doesnt work: [code]if (!$cost_check == $status) {     echo "$cost_check"; } else { echo "ok";      } }[/code]
  13. stevens
    Houdini thankyou for your reply, i understand that now.
  14. stevens
    The status = "test" works fine, but i will change it to == anyway. The problem seems to be with the brackets and || maybe?
  15. stevens
    Hi there is something wrong with my if statement, please let me know what it is!! It doesnt echo denied! Im trying to only get accepted; if status doesnt = "test" and it is authorised. [code] $status = $_POST['status']; if ((!strstr($response, "AUTHORISED"))||($status = "test")) {     echo "denied"; } else {     echo "accepted"; } [/code]
  16. stevens
    Thanks for all your help, i found out the problem was that $_post[id] wasnt being sent correctly. Thanks again.
  17. stevens
    I entered this in phpmyadmin and it worked perfectly: [code]UPDATE table1, table2 SET table1.order_no = table2.order_no, table1.cust_name = table2.cust_name, table1.cust_email = table2.cust_email, table1.cost = table2.cost WHERE temp.order_no = '1' AND details.word = 'someword';[/code] Now im confused... so is it my $post that is wrong? but why would it work when only 1 field is to be updated in the query but not with multiple fields?
  18. stevens
    @craygo: The two tables are basically the same structure so some of the fields are same. There is one field that is a common field (word). @wildbug: I cant understand it because if i do it to update an individual field it works fine, so i presume my $post info is correct, but if i do the query with multiple updates it does not update.
  19. stevens
    Hi i am trying to update one tables fields with the data in another table, i have got this to work for one field but it does not seem to work for multiple fields. This is what i have got to work so far: [code=php:0]$query = "UPDATE table1, table2 SET table1.order_no = table2.order_no WHERE table2.order_no = '$_POST[order_no]' AND table1.id = '$_POST[id]'";[/code] Now the query above only updates the order_no, i need it to update 6 other fields. I tried this query for multiple updates but it did not update any of the fields in table1: [code=php:0]$query = "UPDATE table1, table2 SET table1.order_no = table2.order_no, table1.order_name = table2.order_name, table1.order_id = table2.order_id WHERE table2.order_no = '$_POST[order_no]' AND table1.id = '$_POST[id]'";[/code] Now the only way i can think of doing multiple updates is to do 6 different singular updates or to post all of the table2 fields into vars and then update into table1, but both of these seem to be a long way round. Is there not a query i could run that will update multiple fields in one table using the data from another table? thanks in advance for any reply.
  20. stevens
    Hi im new to PHP [img src=\"style_emoticons/[#EMO_DIR#]/unsure.gif\" style=\"vertical-align:middle\" emoid=\":unsure:\" border=\"0\" alt=\"unsure.gif\" /] I've downloaded a script but cannot get it to work, the problem im having is using the install.php file that is meant to make it easy for me!! basically you start with a terms and conditions page, but when i agree and click ok it just reloads the same page, it does not go to step 2... If anyone can help me i would very gratefully appreciate it, thankyou. [code]<?   function load_sql_file ()   {     $str = '-- phpMyAdmin SQL Dump -- version 2.6.3-pl1 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Nov 29, 2005 at 03:14 AM -- Server version: 4.0.25 -- PHP Version: 4.4.0 -- -- Database: `current` -- -- -------------------------------------------------------- -- -- Table structure for table `adds` -- CREATE TABLE `adds` (   `id` int(11) NOT NULL auto_increment,   `text` text NOT NULL,   `type` tinytext NOT NULL,   PRIMARY KEY  (`id`) ) TYPE=MyISAM AUTO_INCREMENT=13; -- -- Dumping data for table `adds` -- INSERT INTO `adds` VALUES (2, \'2', \'\'); INSERT INTO `adds` VALUES (7, \'<script type="text/javascript"><!-- google_ad_client = "8888888"; google_ad_width = 728; google_ad_height = 90; google_ad_format = "728x90_as"; google_ad_type = "text_image"; google_ad_channel =""; google_color_border = "003366"; google_color_bg = "003366"; google_color_link = "FF6600"; google_color_url = "99CCFF"; google_color_text = "FFFFFF"; //--></script> <script type="text/javascript"   src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>\', \'2\'); INSERT INTO `adds` VALUES (3, \'<iframe src="http://rcm.amazon.com/e/cm?t=hotfoxonline-20&o=1&p=13&l=ez&f=ifr&f=ifr" width="468" height="60" scrolling="no" border="0" frameborder="0" style="border:none;"></iframe>\', \'1\'); INSERT INTO `adds` VALUES (12, \'<iframe width="300" height="250" src="http://www.kontraband.com/showadvertising.asp?type=show_med_rect&nsfw=0" frameborder="no" scrolling="no"></iframe>\', \'3\'); -- -------------------------------------------------------- -- -- Table structure for table `board` -- CREATE TABLE `board` (   `id` int(11) NOT NULL auto_increment,   `user` tinytext NOT NULL,   `title` tinytext NOT NULL,   `text` text NOT NULL,   `time` int(11) NOT NULL default \'0\',   PRIMARY KEY  (`id`) ) TYPE=MyISAM AUTO_INCREMENT=1; -- -- Dumping data for table `board` -- -- -------------------------------------------------------- -- -- Table structure for table `board_view` -- CREATE TABLE `board_view` (   `id` int(11) NOT NULL auto_increment,   `user` tinytext NOT NULL,   `view_id` tinytext NOT NULL,   PRIMARY KEY  (`id`) ) TYPE=MyISAM AUTO_INCREMENT=1; -- -- Dumping data for table `board_view` -- -- -------------------------------------------------------- -- -- Table structure for table `buddy` -- CREATE TABLE `buddy` (   `id` int(11) NOT NULL auto_increment,   `user` tinytext NOT NULL,   `buddy` tinytext NOT NULL,   `user1` tinytext NOT NULL,   `buddy1` tinytext NOT NULL,   `time` int(11) NOT NULL default \'0\',   `type` tinytext NOT NULL,   PRIMARY KEY  (`id`) ) TYPE=MyISAM AUTO_INCREMENT=1; -- -- Dumping data for table `buddy` -- -- -------------------------------------------------------- -- -- Table structure for table `buddy_add` -- CREATE TABLE `buddy_add` (   `id` int(11) NOT NULL auto_increment,   `user` tinytext NOT NULL,   `friend` tinytext NOT NULL,   `time` int(11) NOT NULL default \'0\',   `ip` tinytext NOT NULL,   `type` tinytext NOT NULL,   PRIMARY KEY  (`id`) ) TYPE=MyISAM AUTO_INCREMENT=1; -- -- Dumping data for table `buddy_add` -- -- -------------------------------------------------------- -- -- Table structure for table `chat` -- CREATE TABLE `chat` (   `id` int(11) NOT NULL auto_increment,   `user` tinytext NOT NULL,   `text` text NOT NULL,   `time` int(11) NOT NULL default \'0\',   `ip` tinytext NOT NULL,   `group_id` tinytext NOT NULL,   PRIMARY KEY  (`id`) ) TYPE=MyISAM AUTO_INCREMENT=1; -- -- Dumping data for table `chat` -- -- -------------------------------------------------------- -- -- Table structure for table `comment` -- CREATE TABLE `comment` (   `id` int(11) NOT NULL auto_increment,   `main` tinytext NOT NULL,   `cid` tinytext NOT NULL,   `user` tinytext NOT NULL,   `gbuser` tinytext NOT NULL,   `title` tinytext NOT NULL,   `text` text NOT NULL,   `time` int(11) NOT NULL default \'0\',   `ip` tinytext NOT NULL,   `img` tinytext NOT NULL,   PRIMARY KEY  (`id`) ) TYPE=MyISAM AUTO_INCREMENT=1; -- -- Dumping data for table `comment` -- -- -------------------------------------------------------- -- -- Table structure for table `css` -- CREATE TABLE `css` (   `id` int(11) NOT NULL auto_increment,   `name` tinytext NOT NULL,   `file` tinytext NOT NULL,   `html` tinytext NOT NULL,   `default` tinytext NOT NULL,   PRIMARY KEY  (`id`) ) TYPE=MyISAM AUTO_INCREMENT=18; -- -- Dumping data for table `css` -- INSERT INTO `css` VALUES (1, \'Delight\', \'main\', \'new\', \'\'); INSERT INTO `css` VALUES (7, \'Space\', \'space\', \'new\', \'\'); INSERT INTO `css` VALUES (8, \'Foxness\', \'foxness\', \'new\', \'\'); INSERT INTO `css` VALUES (9, \'Pink\', \'pink\', \'new\', \'\'); INSERT INTO `css` VALUES (10, \'Deviant\', \'deviant\', \'new\', \'\'); INSERT INTO `css` VALUES (11, \'Gt-Affect\', \'gt\', \'new\', \'\'); INSERT INTO `css` VALUES (12, \'Lunar\', \'lunar\', \'new\', \'\'); INSERT INTO `css` VALUES (13, \'Digital Orange\', \'digital_orange\', \'new\', \'\'); INSERT INTO `css` VALUES (15, \'Jessica\', \'jessica\', \'new\', \'\'); INSERT INTO `css` VALUES (16, \'Light\', \'light\', \'new\', \'\'); INSERT INTO `css` VALUES (17, \'FoX Heat\', \'pinoy\', \'new\', \'1\'); -- -------------------------------------------------------- -- -- Table structure for table `favorite` -- CREATE TABLE `favorite` (   `id` int(11) NOT NULL auto_increment,   `user` tinytext NOT NULL,   `user1` tinytext NOT NULL,   `time` int(11) NOT NULL default \'0\',   PRIMARY KEY  (`id`) ) TYPE=MyISAM AUTO_INCREMENT=1; -- -- Dumping data for table `favorite` -- -- -------------------------------------------------------- -- -- Table structure for table `forum` -- CREATE TABLE `forum` (   `id` int(11) NOT NULL auto_increment,   `user` tinytext NOT NULL,   `title` tinytext NOT NULL,   `text` text NOT NULL,   `img` tinytext NOT NULL,   PRIMARY KEY  (`id`) ) TYPE=MyISAM AUTO_INCREMENT=9; -- -- Dumping data for table `forum` -- INSERT INTO `forum` VALUES (1, \'ADMIN\', \'Main Test\', \'Test InFo One\', \'bullunderground.jpg\'); INSERT INTO `forum` VALUES (7, \'\', \'Test 2\', \'Test Test\', \'emoticon.gif\'); INSERT INTO `forum` VALUES (8, \'\', \'Test 3\', \'Test asd asd\', \'radio_waves.gif\'); -- -------------------------------------------------------- -- -- Table structure for table `forum_post` -- CREATE TABLE `forum_post` (   `id` int(11) NOT NULL auto_increment,   `type` tinytext NOT NULL,   `user` tinytext NOT NULL,   `title` tinytext NOT NULL,   `text` text NOT NULL,   `time` int(11) NOT NULL default \'0\',   `ip` tinytext NOT NULL,   `view` int(11) NOT NULL default \'0\',   `update` int(11) NOT NULL default \'0\',   `rating` decimal(3,2) NOT NULL default \'0.00\',   `comment` int(11) NOT NULL default \'0\',   `img` tinytext NOT NULL,   `link` tinytext NOT NULL,   PRIMARY KEY  (`id`) ) TYPE=MyISAM AUTO_INCREMENT=1; -- -- Dumping data for table `forum_post` -- -- -------------------------------------------------------- -- -- Table structure for table `forum_reply` -- CREATE TABLE `forum_reply` (   `id` int(11) NOT NULL auto_increment,   `fid` tinytext NOT NULL,   `user` tinytext NOT NULL,   `text` text NOT NULL,   `time` int(11) NOT NULL default \'0\',   `ip` tinytext NOT NULL,   `type` tinytext NOT NULL,   PRIMARY KEY  (`id`) ) TYPE=MyISAM AUTO_INCREMENT=1; -- -- Dumping data for table `forum_reply` -- -- -------------------------------------------------------- -- -- Table structure for table `forum_view` -- CREATE TABLE `forum_view` (   `id` int(11) NOT NULL auto_increment,   `fid` tinytext NOT NULL,   `user` tinytext NOT NULL,   `time` int(11) NOT NULL default \'0\',   PRIMARY KEY  (`id`) ) TYPE=MyISAM AUTO_INCREMENT=1; -- -- Dumping data for table `forum_view` -- -- -------------------------------------------------------- -- -- Table structure for table `fun` -- CREATE TABLE `fun` (   `id` int(11) NOT NULL auto_increment,   `type` tinytext NOT NULL,   `title` tinytext NOT NULL,   `width` tinytext NOT NULL,   `height` tinytext NOT NULL,   `views` int(11) NOT NULL default \'0\',   `player` tinytext NOT NULL,   `time` int(11) NOT NULL default \'0\',   `link` text NOT NULL,   PRIMARY KEY  (`id`) ) TYPE=MyISAM AUTO_INCREMENT=33; -- -- Dumping data for table `fun` -- INSERT INTO `fun` VALUES (1, \'video\', \'Lindsay Lohan Rap\', \'\', \'\', 11, \'test\', 0, \'http://www.hotfoxonline.com/fun/video/1.swf\'); INSERT INTO `fun` VALUES (2, \'video\', \'Shake That Ass\', \'\', \'\', 2, \'\', 0, \'http://www.hotfoxonline.com/fun/video/2.swf\'); INSERT INTO `fun` VALUES (3, \'video\', \'She Blocked Me\', \'\', \'\', 1, \'\', 0, \'http://www.hotfoxonline.com/fun/video/3.swf\'); INSERT INTO `fun` VALUES (5, \'games\', \'Shinobu\', \'\', \'\', 3, \'\', 0, \'http://www.hotfoxonline.com/fun/games/5.swf\'); INSERT INTO `fun` VALUES (6, \'games\', \'Bouncy The Ball\', \'\', \'\', 1, \'\', 0, \'http://www.hotfoxonline.com/fun/games/6.swf\'); INSERT INTO `fun` VALUES (7, \'video\', \'System Down\', \'\', \'\', 0, \'\', 0, \'http://www.hotfoxonline.com/fun/video/7.swf\'); INSERT INTO `fun` VALUES (8, \'video\', \'Sue All The World\', \'\', \'\', 0, \'\', 0, \'http://www.hotfoxonline.com/fun/video/8.swf\'); INSERT INTO `fun` VALUES (9, \'video\', \'Crazy Bitch\', \'\', \'\', 1, \'\', 0, \'http://www.hotfoxonline.com/fun/video/9.swf\'); INSERT INTO `fun` VALUES (10, \'video\', \'Mario Splat\', \'\', \'\', 1, \'\', 0, \'http://www.hotfoxonline.com/fun/video/10.swf\'); INSERT INTO `fun` VALUES (11, \'video\', \'Numa Numa\', \'\', \'\', 6, \'\', 0, \'http://www.hotfoxonline.com/fun/video/11.swf\'); INSERT INTO `fun` VALUES (12, \'games\', \'Ass Hunter\', \'\', \'\', 2, \'\', 0, \'http://www.hotfoxonline.com/fun/games/12.swf\'); INSERT INTO `fun` VALUES (13, \'games\', \'Boom Volleyball\', \'\', \'\', 3, \'natio\', 0, \'http://www.hotfoxonline.com/fun/games/13.swf\'); INSERT INTO `fun` VALUES (14, \'video\', \'Subliminal Britney \', \'\', \'\', 6, \'\', 0, \'http://www.hotfoxonline.com/fun/video/14.swf\'); INSERT INTO `fun` VALUES (15, \'video\', \'Fat Cat\', \'\', \'\', 8, \'\', 0, \'http://www.hotfoxonline.com/fun/video/15.swf\'); INSERT INTO `fun` VALUES (16, \'video\', \'Banana Phone\', \'\', \'\', 5, \'\', 0, \'http://www.hotfoxonline.com/fun/video/16.swf\'); INSERT INTO `fun` VALUES (18, \'games\', \'Tetris\', \'\', \'\', 7, \'test\', 0, \'http://www.hotfoxonline.com/fun/games/18.swf\'); INSERT INTO `fun` VALUES (32, \'video\', \'Lindsay Rap Test\', \'\', \'\', 2, \'\', 1124768100, \'http://www.hotfoxonline.com/fun/video/1.swf\'); -- -------------------------------------------------------- -- -- Table structure for table `group_forum` -- CREATE TABLE `group_forum` (   `id` int(11) NOT NULL auto_increment,   `group_id` tinytext NOT NULL,   `reply_id` tinytext NOT NULL,   `user` tinytext NOT NULL,   `title` tinytext NOT NULL,   `text` text NOT NULL,   `time` int(11) NOT NULL default \'0\',   `type` tinytext NOT NULL,   `views` int(11) NOT NULL default \'0\',   PRIMARY KEY  (`id`) ) TYPE=MyISAM AUTO_INCREMENT=1; -- -- Dumping data for table `group_forum` -- -- -------------------------------------------------------- -- -- Table structure for table `group_gallery` -- CREATE TABLE `group_gallery` (   `id` int(11) NOT NULL auto_increment,   `group_id` tinytext NOT NULL,   `user` tinytext NOT NULL,   `img` tinytext NOT NULL,   `time` int(11) NOT NULL default \'0\',   `default` tinytext NOT NULL,   `title` tinytext NOT NULL,   PRIMARY KEY  (`id`) ) TYPE=MyISAM AUTO_INCREMENT=1; -- -- Dumping data for table `group_gallery` -- -- -------------------------------------------------------- -- -- Table structure for table `group_invite` -- CREATE TABLE `group_invite` (   `id` int(11) NOT NULL auto_increment,   `type_id` tinytext NOT NULL,   `group_id` tinytext NOT NULL,   `user` tinytext NOT NULL,   `invite` tinytext NOT NULL,   `time` int(11) NOT NULL default \'0\',   PRIMARY KEY  (`id`) ) TYPE=MyISAM AUTO_INCREMENT=1; -- -- Dumping data for table `group_invite` -- -- -------------------------------------------------------- -- -- Table structure for table `group_main` -- CREATE TABLE `group_main` (   `id` int(11) NOT NULL auto_increment,   `user` tinytext NOT NULL,   `title` tinytext NOT NULL,   `headline` tinytext NOT NULL,   `email` tinytext NOT NULL,   `type` tinytext NOT NULL,   `open_join` tinytext NOT NULL,   `hide_group` tinytext NOT NULL,   `mem_invite` tinytext NOT NULL,   `pub_forum` tinytext NOT NULL,   `location` tinytext NOT NULL,   `city` tinytext NOT NULL,   `mem_image` tinytext NOT NULL,   `text` text NOT NULL,   `time` int(11) NOT NULL default \'0\',   `views` int(11) NOT NULL default \'0\',   `edit` int(11) NOT NULL default \'0\',   PRIMARY KEY  (`id`) ) TYPE=MyISAM AUTO_INCREMENT=1; -- -- Dumping data for table `group_main` -- -- -------------------------------------------------------- -- -- Table structure for table `group_member` -- CREATE TABLE `group_member` (   `id` int(11) NOT NULL auto_increment,   `type_id` tinytext NOT NULL,   `group_id` tinytext NOT NULL,   `user` tinytext NOT NULL,   `time` int(11) NOT NULL default \'0\',   PRIMARY KEY  (`id`) ) TYPE=MyISAM AUTO_INCREMENT=1; -- -- Dumping data for table `group_member` -- -- -------------------------------------------------------- -- -- Table structure for table `group_name` -- CREATE TABLE `group_name` (   `id` int(11) NOT NULL auto_increment,   `name` tinytext NOT NULL,   PRIMARY KEY  (`id`) ) TYPE=MyISAM AUTO_INCREMENT=26; -- -- Dumping data for table `group_name` -- INSERT INTO `group_name` VALUES (1, \'Activities\'); INSERT INTO `group_name` VALUES (2, \'Automotive\'); INSERT INTO `group_name` VALUES (3, \'Business & Entrepreneurs\'); INSERT INTO `group_name` VALUES (4, \'Cities & Neighborhoods\'); INSERT INTO `group_name` VALUES (5, \'Companies / Co-workers\'); INSERT INTO `group_name` VALUES (6, \'Computers & Internet\'); INSERT INTO `group_name` VALUES (7, \' Countries & Regional\'); INSERT INTO `group_name` VALUES (8, \'Cultures & Community\'); INSERT INTO `group_name` VALUES (9, \'Entertainment\'); INSERT INTO `group_name` VALUES (10, \'Family & Home\'); INSERT INTO `group_name` VALUES (11, \'Fan Clubs\'); INSERT INTO `group_name` VALUES (12, \'Fashion & Style\'); INSERT INTO `group_name` VALUES (13, \'Film & Television\'); INSERT INTO `group_name` VALUES (14, \'Food, Drink & Wine\'); INSERT INTO `group_name` VALUES (15, \'Games \'); INSERT INTO `group_name` VALUES (16, \'Gay, Lesbian & Bi\'); INSERT INTO `group_name` VALUES (17, \'Government & Politics\'); INSERT INTO `group_name` VALUES (18, \'Health, Wellness, Fitness\'); INSERT INTO `group_name` VALUES (19, \'Hobbies & Crafts\'); INSERT INTO `group_name` VALUES (20, \'Literature & Arts\'); INSERT INTO `group_name` VALUES (21, \'Money & Investing\'); INSERT INTO `group_name` VALUES (22, \'Music\'); INSERT INTO `group_name` VALUES (23, \'Nightlife & Clubs\'); INSERT INTO `group_name` VALUES (24, \'Recreation & Sports\'); -- -------------------------------------------------------- -- -- Table structure for table `hot_quiz` -- CREATE TABLE `hot_quiz` (   `id` int(11) NOT NULL auto_increment,   `user` tinytext NOT NULL,   `title` tinytext NOT NULL,   `time` int(11) NOT NULL default \'0\',   `player` tinytext NOT NULL,   `points` tinytext NOT NULL,   `views` int(11) NOT NULL default \'0\',   `type` tinytext NOT NULL,   PRIMARY KEY  (`id`) ) TYPE=MyISAM AUTO_INCREMENT=1; -- -- Dumping data for table `hot_quiz` -- -- -------------------------------------------------------- -- -- Table structure for table `html_layout` -- CREATE TABLE `html_layout` (   `id` int(11) NOT NULL auto_increment,   `name` tinytext NOT NULL,   `file` tinytext NOT NULL,   `default` tinytext NOT NULL,   PRIMARY KEY  (`id`) ) TYPE=MyISAM AUTO_INCREMENT=2; -- -- Dumping data for table `html_layout` -- INSERT INTO `html_layout` VALUES (1, \'Default\', \'new\', \'1\'); -- -------------------------------------------------------- -- -- Table structure for table `invite` -- CREATE TABLE `invite` (   `id` int(11) NOT NULL auto_increment,   `user` tinytext NOT NULL,   `email` tinytext NOT NULL,   `type` tinytext NOT NULL,   PRIMARY KEY  (`id`) ) TYPE=MyISAM AUTO_INCREMENT=1; -- -- Dumping data for table `invite` -- -- -------------------------------------------------------- -- -- Table structure for table `journal` -- CREATE TABLE `journal` (   `id` int(11) NOT NULL auto_increment,   `user` tinytext NOT NULL,   `title` tinytext NOT NULL,   `text` text NOT NULL,   `time` int(11) NOT NULL default \'0\',   `jmood` tinytext NOT NULL,   `gcatagory` tinytext NOT NULL,   `view` int(11) NOT NULL default \'0\',   `comment` int(11) NOT NULL default \'0\',   `dlink` tinytext NOT NULL,   `img` tinytext NOT NULL,   `ip` tinytext NOT NULL,   `rating` decimal(3,2) NOT NULL default \'0.00\',   PRIMARY KEY  (`id`) ) TYPE=MyISAM AUTO_INCREMENT=1; -- -- Dumping data for table `journal` -- -- -------------------------------------------------------- -- -- Table structure for table `listing` -- CREATE TABLE `listing` (   `id` int(11) NOT NULL auto_increment,   `name` tinytext NOT NULL,   `num` int(11) NOT NULL default \'0\',   PRIMARY KEY  (`id`) ) TYPE=MyISAM AUTO_INCREMENT=18; -- -- Dumping data for table `listing` -- INSERT INTO `listing` VALUES (1, \'JOBS - HIRING\', 2); INSERT INTO `listing` VALUES (2, \'JOBS - SEEKING\', 1); INSERT INTO `listing` VALUES (3, \'HOUSING & RENTALS\', 15); INSERT INTO `listing` VALUES (4, \'MUSICIAN XCHANGE\', 10); INSERT INTO `listing` VALUES (5, \'CASTING CALLS\', 11); INSERT INTO `listing` VALUES (6, \'FOR SALE\', 12); INSERT INTO `listing` VALUES (7, \'CARS FOR SALE\', 14); INSERT INTO `listing` VALUES (16, \'TICKETS EXCHANGE\', 8); INSERT INTO `listing` VALUES (9, \'FRIENDS\', 13); INSERT INTO `listing` VALUES (10, \'SERVICES OFFERED\', 3); INSERT INTO `listing` VALUES (11, \'SERVICES WANTED\', 4); INSERT INTO `listing` VALUES (12, \'BIZ OPPORTUNITIES\', 5); INSERT INTO `listing` VALUES (13, \'ITEMS WANTED\', 6); INSERT INTO `listing` VALUES (14, \'OTHER\', 7); -- -------------------------------------------------------- -- -- Table structure for table `listing_main` -- CREATE TABLE `listing_main` (   `id` int(11) NOT NULL auto_increment,   `list_id` tinytext NOT NULL,   `user` tinytext NOT NULL,   `title` tinytext NOT NULL,   `text` text NOT NULL,   `location` tinytext NOT NULL,   `city` tinytext NOT NULL,   `time` int(11) NOT NULL default \'0\',   `views` int(11) NOT NULL default \'0\',   `edit` int(11) NOT NULL default \'0\',   `state` tinytext NOT NULL,   PRIMARY KEY  (`id`) ) TYPE=MyISAM AUTO_INCREMENT=1; -- -- Dumping data for table `listing_main` -- -- -------------------------------------------------------- -- -- Table structure for table `mail` -- CREATE TABLE `mail` (   `id` int(11) NOT NULL auto_increment,   `to` tinytext NOT NULL,   `from` tinytext NOT NULL,   `title` tinytext NOT NULL,   `text` text NOT NULL,   `time` int(11) NOT NULL default \'0\',   `seen` tinytext NOT NULL,   `type` tinytext NOT NULL,   `ip` tinytext NOT NULL,   PRIMARY KEY  (`id`) ) TYPE=MyISAM AUTO_INCREMENT=1; -- -- Dumping data for table `mail` -- -- -------------------------------------------------------- -- -- Table structure for table `main` -- CREATE TABLE `main` (   `id` int(11) NOT NULL auto_increment,   `user` tinytext NOT NULL,   `text` text NOT NULL,   `time` int(11) NOT NULL default \'0\',   `gcatagory` tinytext NOT NULL,   `view` int(11) NOT NULL default \'0\',   `votes` int(11) NOT NULL default \'0\',   `ip` tinytext NOT NULL,   `rating` decimal(3,2) NOT NULL default \'0.00\',   `comment` int(11) NOT NULL default \'0\',   `faceoff` int(11) NOT NULL default \'0\',   `img` tinytext NOT NULL,   `width` tinytext NOT NULL,   `height` tinytext NOT NULL,   `allow` tinytext NOT NULL,   `feature` tinytext NOT NULL,   PRIMARY KEY  (`id`) ) TYPE=MyISAM AUTO_INCREMENT=1; -- -- Dumping data for table `main` -- -- -------------------------------------------------------- -- -- Table structure for table `music` -- CREATE TABLE `music` (   `musicid` int(11) NOT NULL auto_increment,   `id` int(11) NOT NULL default \'0\',   `artist` tinytext NOT NULL,   `title` tinytext NOT NULL,   `code` text NOT NULL,   `letter` tinytext NOT NULL,   `feature` tinytext NOT NULL,   `views` int(11) NOT NULL default \'0\',   PRIMARY KEY  (`musicid`) ) TYPE=MyISAM AUTO_INCREMENT=2839; -- -- Dumping data for table `music` -- -- -------------------------------------------------------- -- -- Table structure for table `online` -- CREATE TABLE `online` (   `id` int(11) NOT NULL auto_increment,   `user` tinytext NOT NULL,   `page` tinytext NOT NULL,   `time` int(11) NOT NULL default \'0\',   `ip` tinytext NOT NULL,   `browser` tinytext NOT NULL,   `session` tinytext NOT NULL,   PRIMARY KEY  (`id`) ) TYPE=MyISAM AUTO_INCREMENT=176; -- -- Dumping data for table `online` -- INSERT INTO `online` VALUES (119, \'\', \'/admin/?action=aG9tZQ==&frameset=true\', 1133229165, \'127.0.0.1\', \'\', \'\'); INSERT INTO `online` VALUES (126, \'\', \'/browse/\', 1133229169, \'66.249.66.244\', \'\', \'\'); INSERT INTO `online` VALUES (175, \'\', \'/\', 1133230404, \'213.114.138.121\', \'\', \'\'); -- -------------------------------------------------------- -- -- Table structure for table `page` -- CREATE TABLE `page` (   `id` int(11) NOT NULL auto_increment,   `user` tinytext NOT NULL,   `page` tinytext NOT NULL,   `time` int(11) NOT NULL default \'0\',   PRIMARY KEY  (`id`) ) TYPE=MyISAM AUTO_INCREMENT=9; -- -- Dumping data for table `page` -- -- -------------------------------------------------------- -- -- Table structure for table `poll_vote` -- CREATE TABLE `poll_vote` (   `id` tinytext NOT NULL,   `user` tinytext NOT NULL,   `poll` tinytext NOT NULL,   `answer` tinytext NOT NULL,   `ip` tinytext NOT NULL,   `time` int(11) NOT NULL default \'0\' ) TYPE=MyISAM; -- -- Dumping data for table `poll_vote` -- -- -------------------------------------------------------- -- -- Table structure for table `polls` -- CREATE TABLE `polls` (   `id` int(11) NOT NULL auto_increment,   `user` tinytext NOT NULL,   `poll` tinytext NOT NULL,   `option` tinytext NOT NULL,   `time` int(11) NOT NULL default \'0\',   `o1` tinytext NOT NULL,   `o2` tinytext NOT NULL,   `o3` tinytext NOT NULL,   `o4` tinytext NOT NULL,   `a1` int(11) NOT NULL default \'0\',   `a2` int(11) NOT NULL default \'0\',   `a3` int(11) NOT NULL default \'0\',   `a4` int(11) NOT NULL default \'0\',   `type` tinytext NOT NULL,   PRIMARY KEY  (`id`) ) TYPE=MyISAM AUTO_INCREMENT=1; -- -- Dumping data for table `polls` -- -- -------------------------------------------------------- -- -- Table structure for table `quiz` -- CREATE TABLE `quiz` (   `id` int(11) NOT NULL auto_increment,   `cid` tinytext NOT NULL,   `q1` tinytext NOT NULL,   `a1` tinytext NOT NULL,   `a2` tinytext NOT NULL,   `a3` tinytext NOT NULL,   `a4` tinytext NOT NULL,   `answer` tinytext NOT NULL,   PRIMARY KEY  (`id`) ) TYPE=MyISAM AUTO_INCREMENT=1; -- -- Dumping data for table `quiz` -- -- -------------------------------------------------------- -- -- Table structure for table `quiz_1` -- CREATE TABLE `quiz_1` (   `id` tinytext NOT NULL,   `q` tinytext NOT NULL,   `a1` tinytext NOT NULL,   `a2` tinytext NOT NULL ) TYPE=MyISAM; -- -- Dumping data for table `quiz_1` -- -- -------------------------------------------------------- -- -- Table structure for table `quiz_2` -- CREATE TABLE `quiz_2` (   `id` int(11) NOT NULL auto_increment,   `quizid` tinytext NOT NULL,   `user` tinytext NOT NULL,   `user1` tinytext NOT NULL,   `score` tinytext NOT NULL,   `time` int(11) NOT NULL default \'0\',   `seen` tinytext NOT NULL,   PRIMARY KEY  (`id`) ) TYPE=MyISAM AUTO_INCREMENT=1; -- -- Dumping data for table `quiz_2` -- -- -------------------------------------------------------- -- -- Table structure for table `rateme` -- CREATE TABLE `rateme` (   `id` int(11) NOT NULL auto_increment,   `type` tinytext NOT NULL,   `user` tinytext NOT NULL,   `viewing` tinytext NOT NULL,   `rating` decimal(3,2) NOT NULL default \'0.00\',   `time` int(11) NOT NULL default \'0\',   PRIMARY KEY  (`id`) ) TYPE=MyISAM AUTO_INCREMENT=1; -- -- Dumping data for table `rateme` -- -- -------------------------------------------------------- -- -- Table structure for table `rating` -- CREATE TABLE `rating` (   `id` int(11) NOT NULL auto_increment,   `main` tinytext NOT NULL,   `main2` tinytext NOT NULL,   `user` tinytext NOT NULL,   `rating` decimal(3,2) NOT NULL default \'0.00\',   `time` int(11) NOT NULL default \'0\',   `ip` tinytext NOT NULL,   PRIMARY KEY  (`id`) ) TYPE=MyISAM AUTO_INCREMENT=1; -- -- Dumping data for table `rating` -- -- -------------------------------------------------------- -- -- Table structure for table `session` -- CREATE TABLE `session` (   `id` int(11) NOT NULL auto_increment,   `user` tinytext NOT NULL,   `viewing` tinytext NOT NULL,   `time` int(11) NOT NULL default \'0\',   PRIMARY KEY  (`id`) ) TYPE=MyISAM AUTO_INCREMENT=1; -- -- Dumping data for table `session` -- -- -------------------------------------------------------- -- -- Table structure for table `site_session` -- CREATE TABLE `site_session` (   `id` int(11) NOT NULL auto_increment,   `user` tinytext NOT NULL,   `ip` tinytext NOT NULL,   `browser` text NOT NULL,   `host` text NOT NULL,   `time` int(11) NOT NULL default \'0\',   `page` tinytext NOT NULL,   `port` tinytext NOT NULL,   `protocal` tinytext NOT NULL,   `refer` text NOT NULL,   PRIMARY KEY  (`id`) ) TYPE=MyISAM AUTO_INCREMENT=1; -- -- Dumping data for table `site_session` -- -- -------------------------------------------------------- -- -- Table structure for table `template` -- CREATE TABLE `template` (   `id` int(11) NOT NULL auto_increment,   `user` tinytext NOT NULL,   `bg_color` tinytext NOT NULL,   `bg_img` tinytext NOT NULL,   `bg_main` tinytext NOT NULL,   `color_main` tinytext NOT NULL,   `link_on` tinytext NOT NULL,   `link_hover` tinytext NOT NULL,   `username_bg` tinytext NOT NULL,   `username_color` tinytext NOT NULL,   `top_menu` tinytext NOT NULL,   `top_text` tinytext NOT NULL,   `mainmenu4` tinytext NOT NULL,   `mainmenu4_txt` tinytext NOT NULL,   `border2` tinytext NOT NULL,   `border2_txt` tinytext NOT NULL,   `bottom` tinytext NOT NULL,   `bottom_txt` tinytext NOT NULL,   `nav1_bg` tinytext NOT NULL,   `nav1_a_bg` tinytext NOT NULL,   `nav1_a_txt` tinytext NOT NULL,   `nav1_a2_bg` tinytext NOT NULL,   `nav1_a2_txt` tinytext NOT NULL,   `nav2_a_bg` tinytext NOT NULL,   `nav2_a_txt` tinytext NOT NULL,   `nav2_a2_bg` tinytext NOT NULL,   `nav2_a2_txt` tinytext NOT NULL,   `nav2_sqr` tinytext NOT NULL,   `cmt_bg` tinytext NOT NULL,   `cmt_txt` tinytext NOT NULL,   `cmt2_bg` tinytext NOT NULL,   `cmt2_txt` tinytext NOT NULL,   `menu_bg` tinytext NOT NULL,   `menu_a` tinytext NOT NULL,   `menu_a_txt` tinytext NOT NULL,   `menu2_a` tinytext NOT NULL,   `menu2_a_txt` tinytext NOT NULL,   PRIMARY KEY  (`id`) ) TYPE=MyISAM AUTO_INCREMENT=9; -- -- Dumping data for table `template` -- INSERT INTO `template` VALUES (6, \'admin\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\'); -- -------------------------------------------------------- -- -- Table structure for table `user` -- CREATE TABLE `user` (   `id` int(11) NOT NULL auto_increment,   `admin` tinytext NOT NULL,   `type` tinytext NOT NULL,   `user` tinytext NOT NULL,   `password` tinytext NOT NULL,   `email` tinytext NOT NULL,   `gender` tinytext NOT NULL,   `sex` tinytext NOT NULL,   `age` tinytext NOT NULL,   `day` tinytext NOT NULL,   `month` tinytext NOT NULL,   `year` tinytext NOT NULL,   `location` tinytext NOT NULL,   `me` text NOT NULL,   `dating` tinytext NOT NULL,   `job` tinytext NOT NULL,   `smoke` tinytext NOT NULL,   `drink` tinytext NOT NULL,   `signup` int(11) NOT NULL default \'0\',   `signup_ip` tinytext NOT NULL,   `login` int(11) NOT NULL default \'0\',   `login_ip` tinytext NOT NULL,   `rec` tinytext NOT NULL,   `update` tinytext NOT NULL,   `religion` tinytext NOT NULL,   `turnon` tinytext NOT NULL,   `turnoff` tinytext NOT NULL,   `hobbies` tinytext NOT NULL,   `movies` tinytext NOT NULL,   `music` tinytext NOT NULL,   `books` tinytext NOT NULL,   `headline` text NOT NULL,   `views` int(11) NOT NULL default \'0\',   `css` tinytext NOT NULL,   `rateme1` decimal(3,2) NOT NULL default \'0.00\',   `rateme2` decimal(3,2) NOT NULL default \'0.00\',   `rateme3` decimal(3,2) NOT NULL default \'0.00\',   `rateon` tinytext NOT NULL,   `verify` tinytext NOT NULL,   `verifycode` tinytext NOT NULL,   `videon` tinytext NOT NULL,   `p_update` int(11) NOT NULL default \'0\',   `img` tinytext NOT NULL,   `mood` tinytext NOT NULL,   `music_video` tinytext NOT NULL,   `not_1` tinytext NOT NULL,   `not_2` tinytext NOT NULL,   `not_3` tinytext NOT NULL,   `not_4` tinytext NOT NULL,   `not_5` tinytext NOT NULL,   `feature` tinytext NOT NULL,   `html_layout` tinytext NOT NULL,   PRIMARY KEY  (`id`) ) TYPE=MyISAM AUTO_INCREMENT=9; -- -- Dumping data for table `user` -- INSERT INTO `user` VALUES (5, \'\', \'0\', \'admin\', \'test\', \'[email protected]\', \'Male\', \'Bi\', \'\', \'12\', \'10\', \'1982\', \'United States\', \'Test\', \'Bachelor\', \'Artist\', \'Yes\', \'Yes\', 1128252127, \'\', 1133226343, \'\', \'\', \'\', \'No Answer\', \'Test\', \'asd\', \'dsa\', \'fdg\', \'fds\', \'Test\', \'\', 21, \'17\', 0.00, 0.00, 0.00, \'\', \'\', \'\', \'\', 1130441074, \'2005/01/\', \'\', \'\', \'2\', \'2\', \'2\', \'2\', \'2\', \'1\', \'\'); -- -------------------------------------------------------- -- -- Table structure for table `user_info` -- CREATE TABLE `user_info` (   `id` int(11) NOT NULL auto_increment,   `user` tinytext NOT NULL,   `total` int(11) NOT NULL default \'0\',   `gallery` int(11) NOT NULL default \'0\',   `journal` int(11) NOT NULL default \'0\',   `poll` int(11) NOT NULL default \'0\',   `quiz` int(11) NOT NULL default \'0\',   `comment` int(11) NOT NULL default \'0\',   `forum` int(11) NOT NULL default \'0\',   `viewing` int(11) NOT NULL default \'0\',   `invite` int(11) NOT NULL default \'0\',   PRIMARY KEY  (`id`) ) TYPE=MyISAM AUTO_INCREMENT=9; -- -- Dumping data for table `user_info` -- INSERT INTO `user_info` VALUES (6, \'admin\', 25, 0, 0, 0, 0, 1, 1, 23, 0);';     return $str;   }   function remove_comments (&$output)   {     $lines = explode (' ', $output);     $output = '';     $linecount = count ($lines);     $in_comment = false;     for ($i = 0; $i < $linecount; ++$i)     {       if (preg_match ('/^\\/\\*/', preg_quote ($lines[$i])))       {         $in_comment = true;       }       if (!($in_comment))       {         $output .= $lines[$i] . ' ';       }       if (preg_match ('/\\*\\/$/', preg_quote ($lines[$i])))       {         $in_comment = false;         continue;       }     }     unset ($lines);     return $output;   }   function remove_remarks ($sql)   {     $lines = explode (' ', $sql);     $sql = '';     $linecount = count ($lines);     $output = '';     for ($i = 0; $i < $linecount; ++$i)     {       if (!((!($i != $linecount - 1) AND !(0 < strlen ($lines[$i])))))       {         if ($lines[$i][0] != '#')         {           $output .= $lines[$i] . ' ';         }         else         {           $output .= ' ';         }         $lines[$i] = '';         continue;       }     }     return $output;   }   function split_sql_file ($sql, $delimiter)   {     $tokens = explode ($delimiter, $sql);     $sql = '';     $output = array ();     $matches = array ();     $token_count = count ($tokens);     for ($i = 0; $i < $token_count; ++$i)     {       if (!((!($i != $token_count - 1) AND !strlen (0 < $tokens[$i]))))       {         $total_quotes = preg_match_all ('/\'/', $tokens[$i], $matches);         $escaped_quotes = preg_match_all ('/(?<!\\\\)(\\\\\\\\)*\\\\\'/', $tokens[$i], $matches);         $unescaped_quotes = $total_quotes - $escaped_quotes;         if ($unescaped_quotes % 2 == 0)         {           $output[] = $tokens[$i];           $tokens[$i] = '';           continue;         }         else         {           $temp = $tokens[$i] . $delimiter;           $tokens[$i] = '';           $complete_stmt = false;           $j = $i + 1;           while (!($complete_stmt))           {             for (; $j < $token_count; )             {               ++$j;               break;             }             break;           }           continue;         }         continue;       }     }     return $output;   }   function html_template ()   {     global $DATA;     global $STEP_NUM;     global $STEP_NAME;     global $COMPLETE;     $STR = $COMPLETE;     require_once 'inc/function/func_user_sub.inc';     echo '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" lang="en"> <head> <title>Install</title> <link rel="stylesheet" href="admin/main.css" type="text/css" /> <script type="text/javascript" src="inc/script/main.js"></script> <style type="text/css">body{background:#E6E6E6;}</style> </head> <body> <div style="text-align:center;"> <div id="main"> <div class="top"> <a href="http://www.1.com/members/viewforum.php?f=17" target="_blank">Install Help</a> | <a href="http://www.1.com/support" target="_blank">Support</a> | <a href="http://www.1.com/forum" target="_blank">Forum</a> | <a href="http://www.1.com/support/contact" target="_blank">Contact Us</a> </div> <table style="width:100%;" class="top"> <tr> <td style="width:50%;text-align:left;"> <a href="http://www.1.com" target="_blank"><img src="admin/img/logo.gif" alt="" /></a> </td><td style="font-size:14pt;text-align:center;width:50%;"> <b>VERSION: ' . $SOURCE_VERSION . '</b> </td> </tr> </table> <table style="width:100%;" cellpadding="5" id="main_body"> <tr> <td style="font-size:9pt;" class="color"> ' . $DATA . ' <table style="width:100%;" cellpadding="5" id="bottom2"> <tr>     <td>     <a href="http://www.php.net" onclick="window.open(this.href,\'_blank\');return false;"><img src="admin/img/php.gif" alt="" /></a>     </td>     <td style="text-align:right;">     <a href="http://www.mysql.com" onclick="window.open(this.href,\'_blank\');return false;"><img src="admin/img/mysql.gif" alt="" /></a>     </td> </tr> </table> <br /> <table style="width:100%;" id="bottom" cellpadding="5"> <tr>     <td>     1     </td>     <td style="text-align:right;">     <img src="admin/img/xhtml10.png" alt="" />     <img src="admin/img/css.png" alt="" />         <img src="admin/img/mozilla.png" alt="" />     </td> </tr> </table> </td> </tr> </table> </div> </div> </body> </html>';   }   function check_system ()   {     $canContinue = 1;     $check_say = array ();     $give_go = '';     $good = ('4.3.1' <= phpversion () ? 1 : 0);     $canContinue = ($canContinue AND $good);     $check_say[] = message ('PHP version >= 4.3.1: ', $good);     $good = (function_exists ('mysql_connect') ? 1 : 0);     $canContinue = ($canContinue AND $good);     $check_say[] = message ('MySQL support exists: ', $good);     $canContinue = check ($canContinue, './inc/');     $check_say[] = iswriteable ('./inc/');     $canContinue = check ($canContinue, './inc/config/');     $check_say[] = iswriteable ('./inc/config/');     $canContinue = check ($canContinue, './inc/config/connect.inc');     $check_say[] = iswriteable ('./inc/config/connect.inc');     $canContinue = check ($canContinue, './inc/config/site_config.php');     $check_say[] = iswriteable ('./inc/config/site_config.php');     $canContinue = check ($canContinue, './inc/css_source/');     $check_say[] = iswriteable ('./inc/css_source/');     $canContinue = check ($canContinue, './inc/cache/');     $check_say[] = iswriteable ('./inc/cache/');     $canContinue = check ($canContinue, './gallery/');     $check_say[] = iswriteable ('./gallery/');     $canContinue = check ($canContinue, './user/');     $check_say[] = iswriteable ('./user/');     $canContinue = check ($
×
×
  • 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.