Item toegevoegd aan winkelwagentje!!
Naar winkelwagentje
Home
Biography (EN)
Biografie (NL)
News
Photos
Media
Recordings
Duo Vorontsova / Ruhadze
Contact
#016
Migratiecode copy/paste naar doel-website:
if (exist_db_field("_assets","record_id")) { die("Table [_assets] already exists"); } $query = "CREATE TABLE IF NOT EXISTS (_id int(11) NOT NULL auto_increment, timestamp VARCHAR(20) NOT NULL, PRIMARY KEY (_id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci"; $result = Db::run_query($query, "error creating ", true); $query = "CREATE TABLE IF NOT EXISTS _assets (record_id int(11) NOT NULL auto_increment, PRIMARY KEY (record_id)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci"; $result = Db::run_query($query, "error creating ", true); $query3 = "SELECT autorgrp_id FROM autorisatiegroepen WHERE autorgrp_superadministrator = 1"; $result3 = Db::run_query($query3, "error getting autorisatiegroepen", true); if ($result3->num_rows > 0) { while (list($autorgrp_id) = $result3->fetch_row()) { $query = "SELECT autorisa_tabelnaam FROM autorisatie WHERE autorisa_tabelnaam = ''"; $result = Db::run_query($query, "error getting autorisatie", true); if ($result->num_rows == 0) { $query2 = "INSERT INTO autorisatie SET autorisa_tabelnaam = '', autorisa_tabelkey = '', record_id = '0', autorgrp_id = '" . $autorgrp_id . "', autorisa_toevoegen = '1', autorisa_wijzigen = '1', autorisa_verwijderen = '1', autorisa_lezen = '1', autorisa_zichtbaar = '1', autorisa_uploaden = '1', autorisa_reageren = '1', autorisa_security = '1'"; $result2 = Db::run_query($query2, "error inserting autorisatie", true); } } } $query = "SELECT stamtab_omschrijvingkort FROM stamtabel WHERE stamtab_categorie = 'assettabellen' AND stamtab_omschrijvingkort = ''"; $result = Db::run_query($query, "error getting stamtabel", true); if ($result->num_rows == 0) { $query2 = 'INSERT INTO stamtabel SET stamtab_categorie = "assettabellen", stamtab_omschrijvingkort = "", stamtab_omschrijvinglang = ""'; $result2 = Db::run_query($query2, "error inserting stamtabel", true); $record_id = mysqli_insert_id(DB::getDbh()); } echo "Importeren van de tabel is geslaagd";
Toevoegen in blokitem van doel-website:
{{be_tabelbeheer|inc_tabel=""|inc_tabelkey="_id"|inc_titel=""|inc_nieuwvolgende=false}}
Home
Biography (EN)
Biografie (NL)
News
Photos
Media
Recordings
Duo Vorontsova / Ruhadze
Contact
Contact
Personal Inquiries
Igor Ruhadze
igorruhadze@gmail.com
Visit Igor on:
Facebook
Instagram