phplink is free?

Discussion in 'Directories' started by humm, Jun 4, 2006.

  1. iatbm

    iatbm Prominent Member

    Messages:
    5,151
    Likes Received:
    352
    Best Answers:
    0
    Trophy Points:
    360
    #21
    humm : I just saw that this is version 2.2 was released yesterday and my sql dump is for 2.0 so refer to readme how to upgrade from 2.0 and 2.1 to 2.2 ... You just need to do this in phpmyadmin :

    
    ALTER TABLE dir_pend_cat ADD meta_title CHAR(100) NOT NULL DEFAULT '' AFTER name;
    ALTER TABLE dir_pend_cat ADD meta_description CHAR(255) NOT NULL DEFAULT '' AFTER meta_title;
    ALTER TABLE dir_pend_cat ADD meta_keywords CHAR(255) NOT NULL DEFAULT '' AFTER meta_description;
    ALTER TABLE dir_cat ADD meta_title CHAR(100) NOT NULL DEFAULT '' AFTER name;
    ALTER TABLE dir_cat CHANGE description meta_description CHAR(255) NOT NULL DEFAULT '' AFTER meta_title;
    ALTER TABLE dir_cat ADD meta_keywords CHAR(255) NOT NULL DEFAULT '' AFTER meta_description;
    ALTER TABLE dir_settings ADD cat_list INT(11) NOT NULL DEFAULT '0' AFTER pay_options;
    ALTER TABLE dir_settings ADD pend_list INT(11) NOT NULL DEFAULT '0' AFTER cat_list;
    
    
    Code (markup):
     
    iatbm, Jun 4, 2006 IP
  2. iatbm

    iatbm Prominent Member

    Messages:
    5,151
    Likes Received:
    352
    Best Answers:
    0
    Trophy Points:
    360
    #22
    amtipel I see you installed good now ... just do what I posted up !
     
    iatbm, Jun 4, 2006 IP
  3. humm

    humm बहादुर बच्चा

    Messages:
    4,346
    Likes Received:
    850
    Best Answers:
    0
    Trophy Points:
    310
    #23
    i am trying to do as you said iatbm .. infact figuring how to do it.. i am newbie at it. in the myphpadmin :(

    if u could help me how to do it.. :)..il be glad
     
    humm, Jun 4, 2006 IP
  4. amitpatel_3001

    amitpatel_3001 Results Follow Patience

    Messages:
    14,074
    Likes Received:
    1,178
    Best Answers:
    0
    Trophy Points:
    430
    #24
    i have done with everything,
    now which categories database do i need to use?
    the one on your website? 20kb one? or the one u posted on this page?
     
    amitpatel_3001, Jun 4, 2006 IP
  5. iatbm

    iatbm Prominent Member

    Messages:
    5,151
    Likes Received:
    352
    Best Answers:
    0
    Trophy Points:
    360
    #25
    The one on page 20kb one ... make sure you empty your current database !!
    then install mine and do those alter tables in readme.txt file of the script
     
    iatbm, Jun 4, 2006 IP
  6. iatbm

    iatbm Prominent Member

    Messages:
    5,151
    Likes Received:
    352
    Best Answers:
    0
    Trophy Points:
    360
    #26
    or if you wait I will make new sql dump for 2.2 version ... You will have to wait half an hour hehe :)
     
    iatbm, Jun 4, 2006 IP
  7. amitpatel_3001

    amitpatel_3001 Results Follow Patience

    Messages:
    14,074
    Likes Received:
    1,178
    Best Answers:
    0
    Trophy Points:
    430
    #27
    oops just ran the 20kb one lol and now running the code from the readme file ;)
    and messed up again, as it says the duplicate entries :confused:
    lemme wait for the new sql dump now :)
     
    amitpatel_3001, Jun 4, 2006 IP
  8. humm

    humm बहादुर बच्चा

    Messages:
    4,346
    Likes Received:
    850
    Best Answers:
    0
    Trophy Points:
    310
    #28
    i am dead.. now// i am newbie at it.. now how do i again revery back the improper changes i did in the database... coz i am waiting for the new of iatbm

    helpme! :(
     
    humm, Jun 4, 2006 IP
  9. amitpatel_3001

    amitpatel_3001 Results Follow Patience

    Messages:
    14,074
    Likes Received:
    1,178
    Best Answers:
    0
    Trophy Points:
    430
    #29
    Dont worry iam with you ;)
    Will reinstall everything once the newsql dump is ready :)
     
    amitpatel_3001, Jun 4, 2006 IP
  10. humm

    humm बहादुर बच्चा

    Messages:
    4,346
    Likes Received:
    850
    Best Answers:
    0
    Trophy Points:
    310
    #30
    lol.. amit..we r in the same boat
     
    humm, Jun 4, 2006 IP
  11. iatbm

    iatbm Prominent Member

    Messages:
    5,151
    Likes Received:
    352
    Best Answers:
    0
    Trophy Points:
    360
    #31
    Ok I uploaded new sql dump .... You can download it at the same place !

    Now .... erase everything you have and install the script again

    Then :

    1. go to phpmyadmin and drop dir_cat table
    2. import sql dump file or click SQL in phpmyadmin and copy/paste into the field and click go ;)
    3. you are done
     
    iatbm, Jun 4, 2006 IP
  12. humm

    humm बहादुर बच्चा

    Messages:
    4,346
    Likes Received:
    850
    Best Answers:
    0
    Trophy Points:
    310
    #32
    Strange i am getting a error while adding the file

     SQL query:
    
    -- phpMyAdmin SQL Dump
    -- version 2.6.4-pl2
    -- http://www.phpmyadmin.net
    -- 
    -- Host: localhost
    -- Generation Time: Jun 04, 2006 at 12:18 PM
    -- 
    - --
    -- --------------------------------------------------------
    -- 
    -- Table structure for table `dir_cat`
    -- 
    CREATE TABLE `dir_cat` (
    `cat_id` int( 11 ) NOT NULL default '0',
    `parent_id` int( 11 ) NOT NULL default '0',
    `name` varchar( 50 ) NOT NULL default '',
    `meta_title` varchar( 100 ) NOT NULL default '',
    `meta_description` varchar( 255 ) NOT NULL default '',
    `meta_keywords` varchar( 255 ) NOT NULL default '',
    `indexdisplay` char( 1 ) NOT NULL default '',
    KEY `name` ( `name` ) ,
    KEY `cat_id` ( `cat_id` ) ,
    KEY `parent_id` ( `parent_id` )
    ) TYPE = MYISAM
    
    MySQL said: Documentation
    #1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '-
    -- 
    
    -- ----------------------------------------------------- 
    PHP:
     
    humm, Jun 4, 2006 IP
  13. amitpatel_3001

    amitpatel_3001 Results Follow Patience

    Messages:
    14,074
    Likes Received:
    1,178
    Best Answers:
    0
    Trophy Points:
    430
    #33
    amitpatel_3001, Jun 4, 2006 IP
  14. iatbm

    iatbm Prominent Member

    Messages:
    5,151
    Likes Received:
    352
    Best Answers:
    0
    Trophy Points:
    360
    #34
    humm :

    make sure you leave ( in line 26 and delete TYPE=MyISAM;

    ampitel : change line 53 in show_cat.php to this :

    $row = @mysql_fetch_array($rst);

    I don't know exactly it should work ;) ... It is working fine on my server when I do clean install with sql dump
     
    iatbm, Jun 4, 2006 IP
  15. amitpatel_3001

    amitpatel_3001 Results Follow Patience

    Messages:
    14,074
    Likes Received:
    1,178
    Best Answers:
    0
    Trophy Points:
    430
    #35
    Better i will install on a new domain name on a differant host.
    this one i will use any other script for now :)
    Thanks for your help and assistance.
    I will surely contact you when i get the other name :)
     
    amitpatel_3001, Jun 4, 2006 IP
  16. iatbm

    iatbm Prominent Member

    Messages:
    5,151
    Likes Received:
    352
    Best Answers:
    0
    Trophy Points:
    360
    #36
    It should work hehe amitpatel ;) something you are doing wrong :(
     
    iatbm, Jun 4, 2006 IP
  17. humm

    humm बहादुर बच्चा

    Messages:
    4,346
    Likes Received:
    850
    Best Answers:
    0
    Trophy Points:
    310
    #37
    i didn't need to delete anything, u just made a small mistake i take.. or maybe i while copy/paste :confused:

    -- phpMyAdmin SQL Dump
    -- version 2.6.4-pl2
    -- http://www.phpmyadmin.net
    -- 
    -- Host: localhost
    -- Generation Time: Jun 04, 2006 at 12:18 PM
    
    -- 
    -
    -- 
    
    -- --------------------------------------------------------
    
    -- 
    -- Table structure for table `dir_cat`
    -- 
    
    CREATE TABLE `dir_cat` (
      `cat_id` int(11) NOT NULL default '0',
      `parent_id` int(11) NOT NULL default '0',
      `name` varchar(50) NOT NULL default '',
      `meta_title` varchar(100) NOT NULL default '',
      `meta_description` varchar(255) NOT NULL default '',
      `meta_keywords` varchar(255) NOT NULL default '',
      `indexdisplay` char(1) NOT NULL default '',
      KEY `name` (`name`),
      KEY `cat_id` (`cat_id`),
      KEY `parent_id` (`parent_id`)
    ) TYPE=MyISAM;
    
    PHP:

    see there is only only -

    correct code is

    -- phpMyAdmin SQL Dump
    -- version 2.6.4-pl2
    -- http://www.phpmyadmin.net
    -- 
    -- Host: localhost
    -- Generation Time: Jun 04, 2006 at 12:18 PM
    
    -- 
    -- corrected by adding one more -
    -- 
    
    -- --------------------------------------------------------
    
    -- 
    -- Table structure for table `dir_cat`
    -- 
    
    CREATE TABLE `dir_cat` (
      `cat_id` int(11) NOT NULL default '0',
      `parent_id` int(11) NOT NULL default '0',
      `name` varchar(50) NOT NULL default '',
      `meta_title` varchar(100) NOT NULL default '',
      `meta_description` varchar(255) NOT NULL default '',
      `meta_keywords` varchar(255) NOT NULL default '',
      `indexdisplay` char(1) NOT NULL default '',
      KEY `name` (`name`),
      KEY `cat_id` (`cat_id`),
      KEY `parent_id` (`parent_id`)
    ) TYPE=MyISAM;
    
    PHP:
    works perfect now.. no error at all ;)

    http://www.technofreakonline.com/index.php
     
    humm, Jun 4, 2006 IP
  18. iatbm

    iatbm Prominent Member

    Messages:
    5,151
    Likes Received:
    352
    Best Answers:
    0
    Trophy Points:
    360
    #38
    yes yes hehe .... good you have it working ... now go and skin it a little
     
    iatbm, Jun 4, 2006 IP
  19. johnwoof

    johnwoof Peon

    Messages:
    911
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    0
    #39
    Hi Guys

    My problem is different

    Message at install.php
    Notice: Undefined index: act in E:\myclients\sonkali_bcoder\dir\is\install\install.php on line 41

    I contnue installing
    :
    Notice: Undefined index: status in E:\myclients\sonkali_bcoder\dir\is\login.php on line 68

    Notice: Undefined index: status in E:\myclients\sonkali_bcoder\dir\is\login.php on line 73

    What is problem

    Thanks in advance
     
    johnwoof, Jun 4, 2006 IP