#!/usr/bin/php -f
<?php

$mdb = mysqli_connect("localhost", "crashtest", "crashtest", "crashtest");

function query($sql)
{
	global $mdb;

	$res = mysqli_query($mdb, $sql);
	if ($res === true) {
		return;
	}
	if ($res === false) {
		printf("ERROR: %s: %s\n", date("Y-m-d H:i:s"), mysqli_error($mdb));
	} else {
		mysqli_free_result($res);
	}
}

# repeat count
$count = 100000;

# starting data-id 
$newid = 16207;

for($i = 1; $i < $count; $i++) {
printf("%s: Cycle #%d\n", date("Y-m-d H:i:s"), $i);


query("INSERT INTO isys_catg_custom_fields_list SET isys_catg_custom_fields_list__isys_obj__id = 23, isys_catg_custom_fields_list__isysgui_catg_custom__id = 9, isys_catg_custom_fields_list__field_key = 'C__CMDB__CAT__COMMENTARY_49', isys_catg_custom_fields_list__field_content = '', isys_catg_custom_fields_list__field_type = 'commentary', isys_catg_custom_fields_list__status = 2, isys_catg_custom_fields_list__description = '', isys_catg_custom_fields_list__data__id = ".$newid);

query("SET AUTOCOMMIT=0");
query("COMMIT");

query("SELECT LAST_INSERT_ID() as id");

query("SELECT isys_catg_custom_fields_list__id FROM isys_catg_custom_fields_list WHERE isys_catg_custom_fields_list__isys_obj__id = 23 AND isys_catg_custom_fields_list__field_key = 'c_1501692823543' AND isys_catg_custom_fields_list__data__id = ".$newid);

query("INSERT INTO isys_catg_custom_fields_list SET isys_catg_custom_fields_list__isys_obj__id = 23, isys_catg_custom_fields_list__isysgui_catg_custom__id = 9, isys_catg_custom_fields_list__field_key = 'c_1501692823543', isys_catg_custom_fields_list__field_content = '163589', isys_catg_custom_fields_list__field_type = 'f_popup', isys_catg_custom_fields_list__status = 2, isys_catg_custom_fields_list__description = '', isys_catg_custom_fields_list__data__id = ".$newid);
query("SET AUTOCOMMIT=0");
query("COMMIT");
query("SELECT LAST_INSERT_ID() as id");

query("UPDATE isys_catg_custom_fields_list SET isys_catg_custom_fields_list__isysgui_catg_custom__id = 9, isys_catg_custom_fields_list__field_key = 'c_1501692823543', isys_catg_custom_fields_list__field_content = '163589', isys_catg_custom_fields_list__field_type = 'f_popup', isys_catg_custom_fields_list__status = 2, isys_catg_custom_fields_list__description = '', isys_catg_custom_fields_list__data__id = 20766 WHERE isys_catg_custom_fields_list__isysgui_catg_custom__id = 9 AND isys_catg_custom_fields_list__field_key = 'c_1501692823543' AND isys_catg_custom_fields_list__data__id = ".$newid);

query("SET AUTOCOMMIT=0");
query("COMMIT");
query("SELECT isys_catg_custom_fields_list__id FROM isys_catg_custom_fields_list WHERE isys_catg_custom_fields_list__isys_obj__id = 23 AND isys_catg_custom_fields_list__field_key = 'c_1501683324836' AND isys_catg_custom_fields_list__data__id = ".$newid);

query("INSERT INTO isys_catg_custom_fields_list SET isys_catg_custom_fields_list__isys_obj__id = 23, isys_catg_custom_fields_list__isysgui_catg_custom__id = 9, isys_catg_custom_fields_list__field_key = 'c_1501683324836', isys_catg_custom_fields_list__field_content = 'CVS ACS', isys_catg_custom_fields_list__field_type = 'f_text', isys_catg_custom_fields_list__status = 2, isys_catg_custom_fields_list__description = '', isys_catg_custom_fields_list__data__id = ".$newid);

query("SET AUTOCOMMIT=0");
query("COMMIT");
query("SELECT LAST_INSERT_ID() as id");

query("UPDATE isys_catg_custom_fields_list SET isys_catg_custom_fields_list__isysgui_catg_custom__id = 9, isys_catg_custom_fields_list__field_key = 'c_1501683324836', isys_catg_custom_fields_list__field_content = 'CVS ACS', isys_catg_custom_fields_list__field_type = 'f_text', isys_catg_custom_fields_list__status = 2, isys_catg_custom_fields_list__description = '', isys_catg_custom_fields_list__data__id = 20766 WHERE isys_catg_custom_fields_list__isysgui_catg_custom__id = 9 AND isys_catg_custom_fields_list__field_key = 'c_1501683324836' AND isys_catg_custom_fields_list__data__id = ".$newid);

query("SET AUTOCOMMIT=0");
query("COMMIT");
query("SELECT isys_catg_custom_fields_list__id FROM isys_catg_custom_fields_list WHERE isys_catg_custom_fields_list__isys_obj__id = 23 AND isys_catg_custom_fields_list__field_key = 'c_1501683371760' AND isys_catg_custom_fields_list__data__id = ".$newid);

query("INSERT INTO isys_catg_custom_fields_list SET isys_catg_custom_fields_list__isys_obj__id = 23, isys_catg_custom_fields_list__isysgui_catg_custom__id = 9, isys_catg_custom_fields_list__field_key = 'c_1501683371760', isys_catg_custom_fields_list__field_content = 'RW', isys_catg_custom_fields_list__field_type = 'f_text', isys_catg_custom_fields_list__status = 2, isys_catg_custom_fields_list__description = '', isys_catg_custom_fields_list__data__id = ".$newid);

query("SET AUTOCOMMIT=0");
query("COMMIT");
query("SELECT LAST_INSERT_ID() as id");

query("UPDATE isys_catg_custom_fields_list SET isys_catg_custom_fields_list__isysgui_catg_custom__id = 9, isys_catg_custom_fields_list__field_key = 'c_1501683371760', isys_catg_custom_fields_list__field_content = 'RW', isys_catg_custom_fields_list__field_type = 'f_text', isys_catg_custom_fields_list__status = 2, isys_catg_custom_fields_list__description = '', isys_catg_custom_fields_list__data__id = 20766 WHERE isys_catg_custom_fields_list__isysgui_catg_custom__id = 9 AND isys_catg_custom_fields_list__field_key = 'c_1501683371760' AND isys_catg_custom_fields_list__data__id = ".$newid);

query("SET AUTOCOMMIT=0");
query("COMMIT");
query("SELECT isys_catg_custom_fields_list__id FROM isys_catg_custom_fields_list WHERE isys_catg_custom_fields_list__isys_obj__id = 23 AND isys_catg_custom_fields_list__field_key = 'c_1501683444012' AND isys_catg_custom_fields_list__data__id = ".$newid);

query("INSERT INTO isys_catg_custom_fields_list SET isys_catg_custom_fields_list__isys_obj__id = 23, isys_catg_custom_fields_list__isysgui_catg_custom__id = 9, isys_catg_custom_fields_list__field_key = 'c_1501683444012', isys_catg_custom_fields_list__field_content = '/here', isys_catg_custom_fields_list__field_type = 'f_text', isys_catg_custom_fields_list__status = 2, isys_catg_custom_fields_list__description = '', isys_catg_custom_fields_list__data__id = ".$newid);

query("SET AUTOCOMMIT=0");
query("COMMIT");
query("SELECT LAST_INSERT_ID() as id");

query("UPDATE isys_catg_custom_fields_list SET isys_catg_custom_fields_list__isysgui_catg_custom__id = 9, isys_catg_custom_fields_list__field_key = 'c_1501683444012', isys_catg_custom_fields_list__field_content = '/here', isys_catg_custom_fields_list__field_type = 'f_text', isys_catg_custom_fields_list__status = 2, isys_catg_custom_fields_list__description = '', isys_catg_custom_fields_list__data__id = 20766 WHERE isys_catg_custom_fields_list__isysgui_catg_custom__id = 9 AND isys_catg_custom_fields_list__field_key = 'c_1501683444012' AND isys_catg_custom_fields_list__data__id = ".$newid);

query("SET AUTOCOMMIT=0");
query("COMMIT");

query("SELECT isys_catg_custom_fields_list__id FROM isys_catg_custom_fields_list WHERE isys_catg_custom_fields_list__isys_obj__id = 23 AND isys_catg_custom_fields_list__field_key = 'c_1501683480114' AND isys_catg_custom_fields_list__data__id = ".$newid);

query("INSERT INTO isys_catg_custom_fields_list SET isys_catg_custom_fields_list__isys_obj__id = 23, isys_catg_custom_fields_list__isysgui_catg_custom__id = 9, isys_catg_custom_fields_list__field_key = 'c_1501683480114', isys_catg_custom_fields_list__field_content = '172.22.11.10', isys_catg_custom_fields_list__field_type = 'f_text', isys_catg_custom_fields_list__status = 2, isys_catg_custom_fields_list__description = '', isys_catg_custom_fields_list__data__id = ".$newid);

query("SET AUTOCOMMIT=0");
query("COMMIT");
query("SELECT LAST_INSERT_ID() as id");

query("UPDATE isys_catg_custom_fields_list SET isys_catg_custom_fields_list__isysgui_catg_custom__id = 9, isys_catg_custom_fields_list__field_key = 'c_1501683480114', isys_catg_custom_fields_list__field_content = '172.22.11.10', isys_catg_custom_fields_list__field_type = 'f_text', isys_catg_custom_fields_list__status = 2, isys_catg_custom_fields_list__description = '', isys_catg_custom_fields_list__data__id = 20766 WHERE isys_catg_custom_fields_list__isysgui_catg_custom__id = 9 AND isys_catg_custom_fields_list__field_key = 'c_1501683480114' AND isys_catg_custom_fields_list__data__id = ".$newid);

query("SET AUTOCOMMIT=0");
query("COMMIT");

query("SELECT isys_catg_custom_fields_list__id FROM isys_catg_custom_fields_list WHERE isys_catg_custom_fields_list__isys_obj__id = 23 AND isys_catg_custom_fields_list__field_key = 'c_1501683447293' AND isys_catg_custom_fields_list__data__id = ".$newid);

query("INSERT INTO isys_catg_custom_fields_list SET isys_catg_custom_fields_list__isys_obj__id = 23, isys_catg_custom_fields_list__isysgui_catg_custom__id = 9, isys_catg_custom_fields_list__field_key = 'c_1501683447293', isys_catg_custom_fields_list__field_content = 'comment', isys_catg_custom_fields_list__field_type = 'f_text', isys_catg_custom_fields_list__status = 2, isys_catg_custom_fields_list__description = '', isys_catg_custom_fields_list__data__id = ".$newid);

query("SET AUTOCOMMIT=0");
query("COMMIT");
query("SELECT LAST_INSERT_ID() as id");

query("UPDATE isys_catg_custom_fields_list SET isys_catg_custom_fields_list__isysgui_catg_custom__id = 9, isys_catg_custom_fields_list__field_key = 'c_1501683447293', isys_catg_custom_fields_list__field_content = 'comment', isys_catg_custom_fields_list__field_type = 'f_text', isys_catg_custom_fields_list__status = 2, isys_catg_custom_fields_list__description = '', isys_catg_custom_fields_list__data__id = 20766 WHERE isys_catg_custom_fields_list__isysgui_catg_custom__id = 9 AND isys_catg_custom_fields_list__field_key = 'c_1501683447293' AND isys_catg_custom_fields_list__data__id = ".$newid);
query("SET AUTOCOMMIT=0");
query("COMMIT");

query("SELECT isys_obj__title FROM isys_obj WHERE isys_obj__id = 23");

query("SET AUTOCOMMIT=0");
query("BEGIN");

query("INSERT INTO isys_logbook SET isys_logbook__user_name_static = 'admin admin', isys_logbook__isys_obj__id = 9, isys_logbook__isys_logbook_level__id = 1, isys_logbook__status = 2, isys_logbook__isys_logbook_reason__id = NULL, isys_logbook__entry_identifier_static = '', isys_logbook__changecount = 0, isys_logbook__property = NULL, isys_logbook__description = NULL, isys_logbook__isys_logbook_source__id = 1, isys_logbook__date  = '2017-08-05 11:40:16', isys_logbook__event_static = 'C__LOGBOOK_EVENT__CATEGORY_CHANGED', isys_logbook__obj_name_static  = 'Armin', isys_logbook__category_static = 'Repository Access List', isys_logbook__comment = '', isys_logbook__changes = 'a:6:{s:63:\"isys_cmdb_dao_category_g_custom_fields::f_popup_c_1501692823543\";a:2:{s:4:\"from\";s:18:\"Repos 00001-keeper\";s:2:\"to\";s:19:\"Repos 00000-holding\";}s:62:\"isys_cmdb_dao_category_g_custom_fields::f_text_c_1501683324836\";a:2:{s:4:\"from\";s:14:\"Projectarchive\";s:2:\"to\";s:7:\"CVS ACS\";}s:62:\"isys_cmdb_dao_category_g_custom_fields::f_text_c_1501683371760\";a:2:{s:4:\"from\";s:10:\"read-write\";s:2:\"to\";s:2:\"RW\";}s:62:\"isys_cmdb_dao_category_g_custom_fields::f_text_c_1501683444012\";a:2:{s:4:\"from\";s:0:\"\";s:2:\"to\";s:5:\"/here\";}s:62:\"isys_cmdb_dao_category_g_custom_fields::f_text_c_1501683480114\";a:2:{s:4:\"from\";s:0:\"\";s:2:\"to\";s:12:\"172.22.11.10\";}s:62:\"isys_cmdb_dao_category_g_custom_fields::f_text_c_1501683447293\";a:2:{s:4:\"from\";s:0:\"\";s:2:\"to\";s:7:\"comment\";}}', isys_logbook__obj_type_static = 'LC__CONTACT__TREE__PERSON'");

query("SELECT LAST_INSERT_ID() as id");

query("INSERT INTO isys_catg_logb_list SET isys_catg_logb_list__isys_obj__id = 23, isys_catg_logb_list__isys_logbook__id = (SELECT LAST_INSERT_ID()), isys_catg_logb_list__status = 2");

query("SET AUTOCOMMIT=0");
query("COMMIT");

query("REPLACE INTO isys_search_idx ( isys_search_idx__version, isys_search_idx__type, isys_search_idx__key, isys_search_idx__value, isys_search_idx__reference) SELECT 1, 'cmdb', CONCAT( isys_obj__isys_obj_type__id, '.custom_fields.', isys_catg_custom_fields_list__data__id, '.', REPLACE(isysgui_catg_custom__title, '.', '_'), '.', isysgui_catg_custom__id, '.', isys_catg_custom_fields_list__field_key), isys_catg_custom_fields_list__field_content, isys_obj__id FROM isys_catg_custom_fields_list INNER JOIN isys_obj ON isys_catg_custom_fields_list__isys_obj__id = isys_obj__id INNER JOIN isysgui_catg_custom ON isys_catg_custom_fields_list__isysgui_catg_custom__id = isysgui_catg_custom__id WHERE isys_catg_custom_fields_list__field_type IN ('f_text', 'f_textarea', 'f_link') AND isys_catg_custom_fields_list__isysgui_catg_custom__id = 9");


query("REPLACE INTO isys_search_idx (isys_search_idx__version, isys_search_idx__type, isys_search_idx__key, isys_search_idx__value, isys_search_idx__reference) SELECT 1, 'cmdb', CONCAT(isys_obj__isys_obj_type__id, '.custom_fields.', isys_catg_custom_fields_list__data__id, '.', REPLACE(isysgui_catg_custom__title, '.', '_'), '.', isysgui_catg_custom__id, '.', isys_catg_custom_fields_list__field_key), isys_dialog_plus_custom__title, isys_obj__id FROM isys_catg_custom_fields_list INNER JOIN isys_obj ON isys_catg_custom_fields_list__isys_obj__id = isys_obj__id INNER JOIN isysgui_catg_custom ON isys_catg_custom_fields_list__isysgui_catg_custom__id = isysgui_catg_custom__id INNER JOIN isys_dialog_plus_custom ON isys_dialog_plus_custom__id = isys_catg_custom_fields_list__field_content WHERE isys_catg_custom_fields_list__field_type = 'f_popup' AND isys_catg_custom_fields_list__isysgui_catg_custom__id = 9");

query("SET AUTOCOMMIT=0");
query("COMMIT");

$newid++;

} // for


exit(0);
?>