--- counter/counter.install 2010-04-06 14:32:01.000000000 +0800 +++ counter.install_6.2.11_added_counter_base_node_type 2010-11-28 12:41:07.310000001 +0800 @@ -12,6 +12,7 @@ counter_update_6001(); counter_update_6002(); counter_update_6003(); + counter_update_6004(); } function counter_uninstall() { @@ -185,4 +186,26 @@ db_add_index($ret, 'counter', 'counter_date', array('counter_date')); db_add_index($ret, 'counter', 'counter_ip', array('counter_ip')); return $ret; +} + +//hack:added group type banji and fenhui +function counter_update_6004() { + $ret = array(); + //node type + $node_types=array_keys(node_get_types('names')); + foreach($node_types as $typestr){ + $sql = " SELECT count(*) as total FROM {node} WHERE type='".$typestr."'"; + $data = db_fetch_object(db_query($sql)); + $counter_total = $data->total; + + $sql = " SELECT count(*) as total FROM {counter_data} WHERE counter_name= 'node_type_".$typestr."' "; + $counter_data = db_fetch_object(db_query($sql)); + $counter_name_exist = $counter_data->total; + + if (!$counter_name_exist) { + $sql = " INSERT INTO {counter_data} (counter_name,counter_value) VALUES ('%s','%s')"; + $results = db_query($sql,"node_type_".$typestr,$counter_total); + } + } + } \ No newline at end of file