1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Code requires me to make SQL change but I'm lost

Discussion in 'Databases' started by steveeyes, Nov 9, 2005.

  1. #1
    Hello

    I hope it is ok to ask this question here. I found a mod for phpbb that I would like to use. I have added mods to my phpbb programs before, but never had to actually do anything with my sql. There was always an auto script that took care of adding tables, etc. But not this time.

    After spending the day trying to figure this out I'm hoping someone wouldn't mind helping a rookie (I did go to the creator of the mod, but no response).

    The part that is confusing me is this:

    CREATE TABLE `phpbb_inline_ads` (
    `ad_id` TINYINT( 5 ) NOT NULL auto_increment,
    `ad_code` TEXT NOT NULL ,
    `ad_name` CHAR( 25 ) NOT NULL,
    PRIMARY KEY (`ad_id`)
    );
    
    INSERT INTO `phpbb_inline_ads` (`ad_id` , `ad_code`, `ad_name` )
    VALUES 
    ('1', 'Your banner code goes here', 'Default');
    
    INSERT INTO `phpbb_config` ( `config_name` , `config_value` )
    VALUES 
    ('ad_after_post', '1'),
    ('ad_post_threshold', ''),
    ('ad_every_post', ''),
    ('ad_who', '1'),
    ('ad_no_forums', ''),
    ('ad_no_groups', ''),
    ('ad_old_style', '1');
    #
    #-----[ COPY ]------------------------------------------
    Code (sql):
    I have phpmyadmin for sql but never used it. By looking at phpmyadmin, i think creating a table is evident, but all the other instructions above leaves me in the dark. I hate to start it when I'm not sure I could complete it.

    Is there anyone willing to shed some light on what I need to do in myphpadmin? There is more to this mod after the COPY remark, but the rest of the mod is making changes or additions to the current php files which I have no problem wiith. It's just the sql part above that is keeping me from getting this mod installed.

    Any help would be appreciated.

    Thanks
    Steve
     
    steveeyes, Nov 9, 2005 IP
  2. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,333
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #2
    Pull up the database in phpmysqladmin and click on the SQL tab at the top. Copy/paste your SQL statement (what you just posted) into that box and run it.

    Back everything up first!
     
    digitalpoint, Nov 9, 2005 IP
  3. piniyini

    piniyini Well-Known Member

    Messages:
    514
    Likes Received:
    26
    Best Answers:
    0
    Trophy Points:
    170
    #3
    Thats a good mod, I may use it in the future. Nice one for bringing it to my attention.
     
    piniyini, Nov 9, 2005 IP