modules/ajax_newsflash/ajax_newsflash.install

<?php
// $Id: ajax_newsflash.install,v 1.5 2008/08/28 07:56:09 thenicespider Exp $


function ajax_newsflash_install() {
  drupal_set_message('Installing Ajax Newsflash module');
  
  db_query("DELETE FROM {node_type} where type='newsflash'");
  db_query("DELETE FROM {variable} WHERE name='node_options_newsflash' "); 
  db_query("DROP TABLE IF EXISTS {content_type_newsflash} ");  
  
  for ($i=1;$i<=3;$i++) {
    if (!db_table_exists("{content_type_newsflash$i}")) {
        db_query("CREATE TABLE {content_type_newsflash$i} (
                  `vid`   int(10) NOT NULL default '0',
                  `nid`   int(10) NOT NULL default '0',
                   PRIMARY KEY (vid)
                ) /*!40100 DEFAULT CHARACTER SET utf8 */");
    }
    
    $results_check_type = db_query("SELECT * from {node_type} WHERE type='newsflash$i'");
    if (!db_num_rows($results_check_type)) { 
    db_query("INSERT INTO {node_type} (type,name,module,description, has_title,title_label, has_body, body_label, locked) "
	  ."VALUES ('newsflash$i','News Flash $i','node', 'News Flash $i',1,'Title', 1, 'Body', 0)"); 
    }
    variable_set("node_options_newsflash$i", array('status', FALSE)); 
  }
}

function ajax_newsflash_uninstall() {
  db_query("DELETE FROM {node_type} where type='newsflash'");
  db_query("DELETE FROM {variable} WHERE name='node_options_newsflash' "); 
  db_query("DROP TABLE IF EXISTS {content_type_newsflash} ");  
 
  for ($i=1;$i<=3;$i++) {
    if (db_table_exists("{content_type_newsflash$i}")) {
      db_query("DROP TABLE {content_type_newsflash$i}");
      db_query("DELETE FROM {node_type} where type='newsflash$i'");
      db_query("DELETE FROM {variable} WHERE name = 'node_options_newsflash$i'"); 
    }
  }
}
1	<?php
2	// $Id: ajax_newsflash.install,v 1.5 2008/08/28 07:56:09 thenicespider Exp $
3
4
5	function ajax_newsflash_install() {
6	drupal_set_message('Installing Ajax Newsflash module');
7
8	db_query("DELETE FROM {node_type} where type='newsflash'");
9	db_query("DELETE FROM {variable} WHERE name='node_options_newsflash' ");
10	db_query("DROP TABLE IF EXISTS {content_type_newsflash} ");
11
12	for ($i=1;$i<=3;$i++) {
13	if (!db_table_exists("{content_type_newsflash$i}")) {
14	db_query("CREATE TABLE {content_type_newsflash$i} (
15	`vid` int(10) NOT NULL default '0',
16	`nid` int(10) NOT NULL default '0',
17	PRIMARY KEY (vid)
18	) /!40100 DEFAULT CHARACTER SET utf8 /");
19	}
20
21	$results_check_type = db_query("SELECT * from {node_type} WHERE type='newsflash$i'");
22	if (!db_num_rows($results_check_type)) {
23	db_query("INSERT INTO {node_type} (type,name,module,description, has_title,title_label, has_body, body_label, locked) "
24	."VALUES ('newsflash$i','News Flash $i','node', 'News Flash $i',1,'Title', 1, 'Body', 0)");
25	}
26	variable_set("node_options_newsflash$i", array('status', FALSE));
27	}
28	}
29
30	function ajax_newsflash_uninstall() {
31	db_query("DELETE FROM {node_type} where type='newsflash'");
32	db_query("DELETE FROM {variable} WHERE name='node_options_newsflash' ");
33	db_query("DROP TABLE IF EXISTS {content_type_newsflash} ");
34
35	for ($i=1;$i<=3;$i++) {
36	if (db_table_exists("{content_type_newsflash$i}")) {
37	db_query("DROP TABLE {content_type_newsflash$i}");
38	db_query("DELETE FROM {node_type} where type='newsflash$i'");
39	db_query("DELETE FROM {variable} WHERE name = 'node_options_newsflash$i'");
40	}
41	}
42	}