function load($file) { try { execSQL($file, $this->db, PRE); } catch (PDOException $e) { throw new Exception($e->getMessage() . '<pre>' . $e . '</pre>'); } }
function chgPwdphpBBuser($nick, $pwd) { $cryptpass = phpbb_hash($pwd); $sql = "UPDATE `" . $_SESSION['Application_host'] . "`.`forum_users` "; $sql .= "SET `user_password` = '" . $cryptpass . "' "; $sql .= "WHERE `username` = '" . $nick . "'"; echo "<!--" . $sql . "-->"; $req = execSQL($sql, "function", __FILE__, __FUNCTION__); }
function getVersionForModule($dbh, $name) { $stmt = execSQL($dbh, "SELECT version FROM updates WHERE modulename='{$name}'"); $row = $stmt->fetch(); if ($row) { return $row["version"]; } else { return 0; } }
function runMatching($contacts) { // Read data from jva_contacts table and store it in a object $jva_data = array(); $jvaQuery = "SELECT * FROM jva_contacts"; $DBResource = getDBConnection(); $jva_resultSet = $resultSet = execSQL($DBResource, $jvaQuery); if (mysqli_num_rows($jva_resultSet) > 0) { while ($jva_r = mysqli_fetch_row($jva_resultSet)) { $jva_row = new TempContact(); $jva_row->jva_id = $jva_r[0]; $jva_row->jva_first_name = $jva_r[1]; $jva_row->jva_middle_name = $jva_r[2]; $jva_row->jva_last_name = $jva_r[3]; $jva_row->jva_salutation = $jva_r[4]; $jva_row->jva_phone_no = $jva_r[5]; $jva_row->jva_fax_no = $jva_r[6]; $jva_row->jva_country = $jva_r[7]; $jva_row->jva_zipcode = $jva_r[8]; $jva_row->jva_email = $jva_r[9]; array_push($jva_data, $jva_row); } closeDBConnection($DBResource); // To compare each record in jva_contacts with all records in the file foreach ($jva_data as $jva_row) { foreach ($contacts as $contacts_row) { $c_last = $contacts_row->con_last_name; $j_last = $jva_row->jva_last_name; $DBResource = getDBConnection(); if ($jva_row->jva_last_name == $contacts_row->con_last_name && $jva_row->jva_country == $contacts_row->con_country && $jva_row->jva_email == $contacts_row->con_email) { $nQuery = "INSERT INTO notifications(src_id,src_con_id,jva_id,match_case,pending_notification) values('" . $contacts_row->src_id . "','" . $contacts_row->src_con_id . "'," . $jva_row->jva_id . ",'Perfect',1)"; $resultSet = execSQL($DBResource, $nQuery); } else { if ($jva_row->jva_country == $contacts_row->con_country && $jva_row->jva_email == $contacts_row->con_email) { if (strpos($j_last, $c_last) !== FALSE || strpos($c_last, $j_last) !== FALSE) { $nQuery = "INSERT INTO notifications(src_id,src_con_id,jva_id,match_case,pending_notification) values('" . $contacts_row->src_id . "','" . $contacts_row->src_con_id . "'," . $jva_row->jva_id . ",'Partial',1)"; $resultSet = execSQL($DBResource, $nQuery); } } else { $nQuery = "INSERT INTO notifications(src_id,src_con_id,jva_id,match_case,pending_notification) values('" . $contacts_row->src_id . "','" . $contacts_row->src_con_id . "',0,'New',1)"; $resultSet = execSQL($DBResource, $nQuery); } } closeDBConnection($DBResource); } // end of inner for each loop } // end of outer for each loop } else { foreach ($contacts as $contacts_row) { $nQuery = "INSERT INTO notifications(src_id,src_con_id,jva_id,match_case,pending_notification) values('" . $contacts_row->src_id . "','" . $contacts_row->src_con_id . "',0,'New',1)"; execSQL($DBResource, $nQuery); } } }
function db_page_delete($page_id) { $param_arr = _init_db_params(); LOG_MSG('INFO', "db_page_delete(): START { page_id=[{$page_id}]"); // For the where clause $where_clause = " WHERE page_id=? AND shop_id=" . SHOP_ID; $param_arr = _db_prepare_param($param_arr, "i", "page_id", $page_id, true); $resp = execSQL("DELETE FROM \n\t\t\t\t\t\t\ttPage" . $where_clause, $param_arr['params'], true); LOG_MSG('INFO', "db_page_delete(): END"); return $resp; }
function getUser($username) { $result = execSQL("SELECT * FROM users WHERE username='******'"); $user = array("id" => 0, "username" => "", "about" => "", "profileimage" => ""); if ($result->num_rows > 0) { while ($row = $result->fetch_assoc()) { $user = array("id" => $row["id"], "username" => $row["username"], "about" => $row["about"], "profileimage" => $row["profileimage"]); } } return $user; }
function db_room_select($room_id = "", $room_name = "") { LOG_MSG('INFO', "db_wallet_select: START { \n\t\t\t\t\t\t\troom_id=[{$room_id}],\n\t\t\t\t\t\t\troom_name=[{$room_name}] \n}"); $param_arr = _init_db_params(); $where_clause = "WHERE room_name={$room_name} AND room_id = {$room_id}"; $param_arr['params'] = array(); LOG_MSG('INFO', "db_room_select(): WHERE CLAUSE = [{$where_clause}]"); $resp = execSQL("SELECT \n\t\t\t\t\t\troom_name,\n\t\t\t\t\t\troom_id,\n\t\t\t\t\t\tis_booked\n\t\t\t\t\tFROM \n\t\t\t\t\t\tbookrooms\n\t\t\t\t\t" . $where_clause, $param_arr['params'], false); LOG_MSG('INFO', "db_room_select(): END"); return $resp; }
function db_do_login($email_id, $password) { LOG_MSG('INFO', "db_do_login(): START {\n\t\t\t\t\t\t\t\t\t\temail_id=[{$email_id}],\n\t\t\t\t\t\t\t\t\t\tpassword=[{$password}]\n}"); $param_arr = _init_db_params(); $param_arr = _db_prepare_param($param_arr, "s", "email_id", $email_id, true); $param_arr = _db_prepare_param($param_arr, "s", "password", $password, true); // Create Query $resp = execSQL("SELECT \n\t\t\t\t\t\tu.user_id,\n\t\t\t\t\t\tu.name,\n\t\t\t\t\t\tu.email_id,\n\t\t\t\t\t\tu.password,\n\t\t\t\t\t\tu.phone_no,\n\t\t\t\t\t\tu.address,\n\t\t\t\t\t\tu.type,\n\t\t\t\t\t\tu.is_active,\n\t\t\t\t\t\tu.created_dt,\n\t\t\t\t\t\ts.supervisor_id,\n\t\t\t\t\t\tt.travel_id,\n\t\t\t\t\t\tt.name travel_name,\n\t\t\t\t\t\tt.domain\n\t\t\t\t\tFROM\n\t\t\t\t\t\ttUser u\n\t\t\t\t\t\tLEFT OUTER JOIN tSupervisor s ON(s.user_id=u.user_id)\n\t\t\t\t\t\tLEFT OUTER JOIN tTravel t ON(u.travel_id=t.travel_id)\n\t\t\t\t\tWHERE \n\t\t\t\t\t\tu.email_id=? \n\t\t\t\t\t\tAND u.password=? AND\n\t\t\t\t\t\tt.travel_id=" . TRAVEL_ID, $param_arr['params'], false); LOG_MSG('INFO', "db_do_login(): END"); return $resp; }
function login() { if (empty($_POST['username'])) { echo "Username is empty"; return false; } if (empty($_POST['password'])) { echo "Password is empty"; return false; } $username = trim($_POST['username']); $password = trim($_POST['password']); $conn = getDBConnection(); $query = "select password from login_details where username = '******'"; $res = execSQL($conn, $query); while ($row = $res->fetch_assoc()) { $pwdhash = $row['password']; } return password_verify($password, $pwdhash); }
function get_unique_field($table) { LOG_MSG("INFO", "####### GETTING UNIQUE KEY COLUMN NAME : for " . DB_NAME . $table); $row = execSQL("\n\t\t\t\tSELECT \n\t\t\t\t\tcolumn_name\n\t\t\t\tFROM \n\t\t\t\t\tinformation_schema.COLUMNS\n\t\t\t\tWHERE \n\t\t\t\t\ttable_name = '" . $table . "' AND\n\t\t\t\t\ttable_schema = '" . DB_NAME . "' AND\n\t\t\t\t\tcolumn_key='UNI';", array(), false); // If no unique key was found above if (!isset($row[0]['column_name'])) { LOG_MSG("INFO", "####### GETTING PRIMARY KEY COLUMN NAME : for " . DB_NAME . $table); $row = execSQL("\n\t\t\t\tSELECT \n\t\t\t\t\tcolumn_name\n\t\t\t\tFROM \n\t\t\t\t\tinformation_schema.COLUMNS\n\t\t\t\tWHERE \n\t\t\t\t\ttable_name = '" . $table . "' AND\n\t\t\t\t\ttable_schema = '" . DB_NAME . "' AND\n\t\t\t\t\tcolumn_key='PRI';", array(), false); } return $row[0]['column_name']; }
/** * splitExec */ function execSplit() { $EXEC_SQL = <<<SQL DROP TABLE IF EXISTS iidxsd_origin cascade; CREATE TABLE iidxsd_origin as ( SELECT no,msc,(CASE WHEN ver < 50 THEN ver ELSE (ver - 50) END) as ver_no,(CASE WHEN ver < 50 THEN 1 ELSE 2 END) as ver_type,bpm,bpmn,bpmx,(CASE WHEN bpmd = '' OR bpmd IS NULL THEN '\\N' ELSE bpmd END) as bpmd,artist,genre,spn as dif, n7 as notes,japan,abs(11) as dif_type FROM temp UNION SELECT no,msc,(CASE WHEN ver < 50 THEN ver ELSE (ver - 50) END) as ver_no,(CASE WHEN ver < 50 THEN 1 ELSE 2 END) as ver_type,bpm,bpmn,bpmx,(CASE WHEN bpmd = '' OR bpmd IS NULL THEN '\\N' ELSE bpmd END) as bpmd,artist,genre,dpn as dif, n14 as notes,japan,abs(21) as dif_type FROM temp UNION SELECT no,msc,(CASE WHEN ver < 50 THEN ver ELSE (ver - 50) END) as ver_no,(CASE WHEN ver < 50 THEN 1 ELSE 2 END) as ver_type,bpm,bpmn,bpmx,(CASE WHEN bpmd = '' OR bpmd IS NULL THEN '\\N' ELSE bpmd END) as bpmd,artist,genre,sph as dif, h7 as notes,japan,abs(12) as dif_type FROM temp UNION SELECT no,msc,(CASE WHEN ver < 50 THEN ver ELSE (ver - 50) END) as ver_no,(CASE WHEN ver < 50 THEN 1 ELSE 2 END) as ver_type,bpm,bpmn,bpmx,(CASE WHEN bpmd = '' OR bpmd IS NULL THEN '\\N' ELSE bpmd END) as bpmd,artist,genre,dph as dif, h14 as notes,japan,abs(22) as dif_type FROM temp UNION SELECT no,msc,(CASE WHEN ver < 50 THEN ver ELSE (ver - 50) END) as ver_no,(CASE WHEN ver < 50 THEN 1 ELSE 2 END) as ver_type,bpm,bpmn,bpmx,(CASE WHEN bpmd = '' OR bpmd IS NULL THEN '\\N' ELSE bpmd END) as bpmd,artist,genre,spa as dif, a7 as notes,japan,abs(13) as dif_type FROM temp UNION SELECT no,msc,(CASE WHEN ver < 50 THEN ver ELSE (ver - 50) END) as ver_no,(CASE WHEN ver < 50 THEN 1 ELSE 2 END) as ver_type,bpm,bpmn,bpmx,(CASE WHEN bpmd = '' OR bpmd IS NULL THEN '\\N' ELSE bpmd END) as bpmd,artist,genre,dpa as dif, a14 as notes,japan,abs(23) as dif_type FROM temp UNION SELECT no,msc,(CASE WHEN ver < 50 THEN ver ELSE (ver - 50) END) as ver_no,(CASE WHEN ver < 50 THEN 1 ELSE 2 END) as ver_type,bpm,bpmn,bpmx,(CASE WHEN bpmd = '' OR bpmd IS NULL THEN '\\N' ELSE bpmd END) as bpmd,artist,genre,spd as dif, d7 as notes,japan,abs(14) as dif_type FROM temp UNION SELECT no,msc,(CASE WHEN ver < 50 THEN ver ELSE (ver - 50) END) as ver_no,(CASE WHEN ver < 50 THEN 1 ELSE 2 END) as ver_type,bpm,bpmn,bpmx,(CASE WHEN bpmd = '' OR bpmd IS NULL THEN '\\N' ELSE bpmd END) as bpmd,artist,genre,dpd as dif, d14 as notes,japan,abs(24) as dif_type FROM temp ORDER BY dif,japan,msc,dif_type); -- 譜面詳細データ DROP TABLE IF EXISTS data_detail cascade; create table data_detail ( data_detail_id serial not null , playtime integer , bpm_detail text , constraint data_detail_PKC primary key (data_detail_id) ) ; -- 収録状況テーブル DROP TABLE IF EXISTS list cascade; create table list ( list_id serial not null , ver_id integer , data_id integer , secret_id integer , info text , constraint list_PKC primary key (list_id,ver_id,data_id,secret_id) ) ; -- 譜面データテーブル drop table notesdata cascade; create table notesdata ( data_id serial not null , music_id integer , dif_id integer , genre_id integer , artist_id integer , data_detail_id integer , dif integer , bpm_min integer , bpm_max integer , notes integer , scratch integer , chargenotes integer , bss integer , data_date date , constraint notesdata_PKC primary key (data_id,music_id,dif_id,genre_id,artist_id,data_detail_id) ) ; -- バージョンテーブル DROP TABLE IF EXISTS version cascade; create table version ( ver_id serial not null , ver_no integer , ver_type integer , ver_disc integer , ver_name text , ver_name_short text , ver_date date , constraint version_PKC primary key (ver_id) ) ; -- 難易度名テーブル DROP TABLE IF EXISTS diftype cascade; create table diftype ( dif_id serial not null , dif_type text , constraint diftype_PKC primary key (dif_id) ) ; -- ジャンル名テーブル DROP TABLE IF EXISTS genre cascade; create table genre ( genre_id serial not null , genre_name text , constraint genre_PKC primary key (genre_id) ) ; -- アーティスト名義テーブル DROP TABLE IF EXISTS artist cascade; create table artist ( artist_id serial not null , artist_name text , constraint artist_PKC primary key (artist_id) ) ; -- 曲情報テーブル DROP TABLE IF EXISTS music cascade; create table music ( music_id serial not null , music_no integer , music_name text , music_name_sort text , music_read text , music_battle integer , music_first_ver integer , music_folder_ver integer , constraint music_PKC primary key (music_id) ) ; comment on table data_detail is '譜面詳細データ'; comment on column data_detail.data_detail_id is '譜面詳細ID'; comment on column data_detail.playtime is '演奏時間'; comment on column data_detail.bpm_detail is '詳細BPM'; comment on table list is '収録状況テーブル'; comment on column list.list_id is 'リストID'; comment on column list.ver_id is 'バージョンID'; comment on column list.data_id is 'データID'; comment on column list.secret_id is 'シークレット'; comment on column list.info is '情報'; comment on table notesdata is '譜面データテーブル'; comment on column notesdata.data_id is 'データID'; comment on column notesdata.music_id is '曲ID'; comment on column notesdata.dif_id is '難度タイプID'; comment on column notesdata.genre_id is 'ジャンルID'; comment on column notesdata.artist_id is 'アーティスト名義ID'; comment on column notesdata.data_detail_id is '譜面詳細ID'; comment on column notesdata.dif is '難易度'; comment on column notesdata.bpm_min is '最小BPM'; comment on column notesdata.bpm_max is '最大BPM'; comment on column notesdata.notes is 'ノート数'; comment on column notesdata.scratch is 'スクラッチ'; comment on column notesdata.chargenotes is 'チャージノート'; comment on column notesdata.bss is 'バックスピンスクラッチ'; comment on column notesdata.data_date is 'データ日付'; comment on table version is 'バージョンテーブル'; comment on column version.ver_id is 'バージョンID'; comment on column version.ver_no is 'バージョンno'; comment on column version.ver_type is 'バージョンタイプ'; comment on column version.ver_disc is 'ディスク'; comment on column version.ver_name is '名前'; comment on column version.ver_name_short is '短縮名'; comment on column version.ver_date is '日付'; comment on table diftype is '難易度名テーブル'; comment on column diftype.dif_id is '難易度タイプID'; comment on column diftype.dif_type is '難易度名'; comment on table genre is 'ジャンル名テーブル'; comment on column genre.genre_id is 'ジャンル名ID'; comment on column genre.genre_name is 'ジャンル名'; comment on table artist is 'アーティスト名義テーブル'; comment on column artist.artist_id is 'アーティスト名義ID'; comment on column artist.artist_name is 'アーティスト名'; comment on table music is '曲情報テーブル'; comment on column music.music_id is '曲ID'; comment on column music.music_no is '曲no'; comment on column music.music_name is '曲名'; comment on column music.music_name_sort is 'ソート用曲名'; comment on column music.music_read is '読み方'; comment on column music.music_battle is '別難度Battle可否'; comment on column music.music_first_ver is '初登場version'; comment on column music.music_folder_ver is '収録フォルダ'; INSERT INTO genre SELECT nextval('genre_genre_id_seq') as genre_id,iidxsd_origin.genre as genre_name FROM iidxsd_origin GROUP BY iidxsd_origin.genre ORDER BY iidxsd_origin.genre; INSERT INTO artist SELECT nextval('artist_artist_id_seq') as artist_id,iidxsd_origin.artist as artist_name FROM iidxsd_origin GROUP BY iidxsd_origin.artist ORDER BY iidxsd_origin.artist; INSERT INTO data_detail SELECT nextval('data_detail_data_detail_id_seq') as data_detail_id,0 as time, iidxsd_origin.bpmd FROM iidxsd_origin GROUP BY iidxsd_origin.bpmd ORDER BY iidxsd_origin.bpmd; INSERT INTO music SELECT nextval('music_music_id_seq') as music_id, currval('music_music_id_seq') as music_no, msc as music_name, UPPER(msc) as music_name_sort, '' as music_read, 1 as music_battle, MIN(ver_no) as music_first_ver, MIN( CASE WHEN ver_type = 2 THEN (ver_no + 50) ELSE ver_no END ) as music_folder_ver FROM iidxsd_origin GROUP BY msc ORDER BY msc; -- バージョンテーブル DROP TABLE IF EXISTS version cascade; create table version ( ver_id serial not null , ver_no integer , ver_type integer , ver_disc integer , ver_name text , ver_name_short text , ver_date date , constraint version_PKC primary key (ver_id) ) ; -- 難易度名テーブル DROP TABLE IF EXISTS diftype cascade; create table diftype ( dif_id serial not null , dif_type text , constraint diftype_PKC primary key (dif_id) ) ; comment on table version is 'バージョンテーブル'; comment on column version.ver_id is 'バージョンID'; comment on column version.ver_no is 'バージョンno'; comment on column version.ver_type is 'バージョンタイプ'; comment on column version.ver_disc is 'ディスク'; comment on column version.ver_name is '名前'; comment on column version.ver_name_short is '短縮名'; comment on column version.ver_date is '日付'; comment on table diftype is '難易度名テーブル'; comment on column diftype.dif_id is '難易度タイプID'; comment on column diftype.dif_type is '難易度名'; --難易度テーブル挿入 INSERT INTO diftype VALUES (11,'SINGLE PLAY NORMAL'); INSERT INTO diftype VALUES (12,'SINGLE PLAY HYPER'); INSERT INTO diftype VALUES (13,'SINGLE PLAY ANOTHER'); INSERT INTO diftype VALUES (14,'SINGLE PLAY DARK ANOTHER'); INSERT INTO diftype VALUES (21,'DOUBLE PLAY NORMAL'); INSERT INTO diftype VALUES (22,'DOUBLE PLAY HYPER'); INSERT INTO diftype VALUES (23,'DOUBLE PLAY ANOTHER'); INSERT INTO diftype VALUES (24,'DOUBLE PLAY DARK ANOTHER'); --バージョンテーブル挿入 INSERT INTO version VALUES (nextval('version_ver_id_seq'),0,1,1,'1st style','1st','1999/02/26'); INSERT INTO version VALUES (nextval('version_ver_id_seq'),1,1,1,'substream','ss','1999/07/27'); INSERT INTO version VALUES (nextval('version_ver_id_seq'),2,1,1,'2nd style','2nd','1999/09/30'); INSERT INTO version VALUES (nextval('version_ver_id_seq'),3,1,1,'3rd style','3rd','2000/02/25'); INSERT INTO version VALUES (nextval('version_ver_id_seq'),4,1,1,'4th style','4th','2000/09/28'); INSERT INTO version VALUES (nextval('version_ver_id_seq'),3,2,1,'3rd style','3rd','2000/11/02'); INSERT INTO version VALUES (nextval('version_ver_id_seq'),5,1,1,'5th style','5th','2001/03/27'); INSERT INTO version VALUES (nextval('version_ver_id_seq'),4,2,1,'4th style','4th','2001/03/29'); INSERT INTO version VALUES (nextval('version_ver_id_seq'),5,2,1,'5th style','5th','2001/08/30'); INSERT INTO version VALUES (nextval('version_ver_id_seq'),6,1,1,'6th style','6th','2001/09/28'); INSERT INTO version VALUES (nextval('version_ver_id_seq'),7,1,1,'7th style','7th','2002/03/27'); INSERT INTO version VALUES (nextval('version_ver_id_seq'),6,2,1,'6th style','6th','2002/07/18'); INSERT INTO version VALUES (nextval('version_ver_id_seq'),8,1,1,'8th style','8th','2002/09/27'); INSERT INTO version VALUES (nextval('version_ver_id_seq'),9,1,1,'9th style','9th','2003/06/25'); INSERT INTO version VALUES (nextval('version_ver_id_seq'),10,1,1,'10th style','10th','2004/02/18'); INSERT INTO version VALUES (nextval('version_ver_id_seq'),7,2,1,'7th style','7th','2004/05/13'); INSERT INTO version VALUES (nextval('version_ver_id_seq'),11,1,1,'11 IIDX RED','RED','2004/10/28'); INSERT INTO version VALUES (nextval('version_ver_id_seq'),8,2,1,'8th style','8th','2004/11/18'); INSERT INTO version VALUES (nextval('version_ver_id_seq'),9,2,1,'9th style','9th','2005/03/24'); INSERT INTO version VALUES (nextval('version_ver_id_seq'),12,1,1,'12 HAPPY SKY','HSK','2005/07/13'); INSERT INTO version VALUES (nextval('version_ver_id_seq'),10,2,1,'10th style','10th','2005/11/17'); INSERT INTO version VALUES (nextval('version_ver_id_seq'),13,1,1,'13 DistorteD','DD','2006/03/15'); INSERT INTO version VALUES (nextval('version_ver_id_seq'),11,2,1,'11 IIDX RED','RED','2006/05/18'); INSERT INTO version VALUES (nextval('version_ver_id_seq'),12,2,1,'12 HAPPY SKY','HSK','2006/12/14'); INSERT INTO version VALUES (nextval('version_ver_id_seq'),14,1,1,'14 GOLD','GOLD','2007/02/21'); INSERT INTO version VALUES (nextval('version_ver_id_seq'),13,2,1,'13 DistorteD','DD','2007/08/30'); INSERT INTO version VALUES (nextval('version_ver_id_seq'),15,1,1,'15 DJ TROOPERS','DJT','2007/12/19'); INSERT INTO version VALUES (nextval('version_ver_id_seq'),14,2,1,'14 GOLD','GOLD','2008/05/29'); INSERT INTO version VALUES (nextval('version_ver_id_seq'),16,1,1,'16 EMPRESS','EMP','2008/11/19'); INSERT INTO version VALUES (nextval('version_ver_id_seq'),15,2,1,'15 DJ TROOPERS','DJT','2008/12/18'); INSERT INTO version VALUES (nextval('version_ver_id_seq'),16,2,1,'16 EMPRESS','EMP','2009/10/15'); INSERT INTO version VALUES (nextval('version_ver_id_seq'),16,2,2,'PREMIUM BEST','PB','2009/10/15'); INSERT INTO version VALUES (nextval('version_ver_id_seq'),17,1,1,'17 SIRIUS','SIR','2009/10/21'); INSERT INTO version VALUES (nextval('version_ver_id_seq'),18,1,1,'18 Resort Anthem','RA','2010/09/15'); INSERT INTO version VALUES (nextval('version_ver_id_seq'),19,1,1,'19 Lincle','LC','2011/09/15'); INSERT INTO version VALUES (nextval('version_ver_id_seq'),20,1,1,'20 tricoro','TCR','2012/09/19'); INSERT INTO version VALUES (nextval('version_ver_id_seq'),21,1,1,'21 SPADA','SPA','2013/11/13'); INSERT INTO notesdata (SELECT nextval('notesdata_data_id_seq') as data_id, music_id, dif_type as dif_id, genre_id, artist_id, data_detail_id, dif, bpmn as bpm_min, bpmx as bpm_max, notes, 0 as scratch, 0 as chargenotes, 0 as bss, MIN(ver_date) as data_date FROM (((((iidxsd_origin JOIN music ON iidxsd_origin.msc = music_name) JOIN genre ON iidxsd_origin.genre = genre_name) JOIN artist ON iidxsd_origin.artist = artist.artist_name) JOIN version ON iidxsd_origin.ver_no = version.ver_no AND iidxsd_origin.ver_type = version.ver_type) JOIN data_detail ON iidxsd_origin.bpmd = data_detail.bpm_detail AND data_detail.bpm_detail IS NOT NULL) GROUP BY music_id , dif_id , genre_id , artist_id , data_detail_id , dif , dif_type , bpm_min , bpm_max , notes HAVING notes > 0); DROP TABLE IF EXISTS iidxsd_origin_x; CREATE TABLE iidxsd_origin_x AS SELECT ver_no, ver_type, music_id, dif_type as dif_id, genre_id, artist_id, data_detail_id, dif, bpmn as bpm_min, bpmx as bpm_max, notes, 0 as chargenotes, 0 as bss FROM ((((iidxsd_origin JOIN music ON iidxsd_origin.msc = music_name) JOIN genre ON iidxsd_origin.genre = genre_name) JOIN artist ON iidxsd_origin.artist = artist.artist_name) JOIN data_detail ON iidxsd_origin.bpmd = data_detail.bpm_detail) ; INSERT INTO list ( SELECT nextval('list_list_id_seq') as list_id, ver_id, data_id, 0 as secret_id, '' as info FROM ((iidxsd_origin_x JOIN version USING(ver_no, ver_type) ) JOIN notesdata USING(dif, notes, bpm_min, bpm_max, music_id, genre_id, artist_id, data_detail_id)) GROUP BY ver_id, data_id ); DROP VIEW IF EXISTS ac0_core; DROP VIEW IF EXISTS ac0; CREATE VIEW ac0 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 1; DROP VIEW IF EXISTS ac1_core; DROP VIEW IF EXISTS ac1; CREATE VIEW ac1 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 2; DROP VIEW IF EXISTS ac2_core; DROP VIEW IF EXISTS ac2; CREATE VIEW ac2 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 3; DROP VIEW IF EXISTS ac3_core; DROP VIEW IF EXISTS ac3; CREATE VIEW ac3 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 4; DROP VIEW IF EXISTS ac4_core; DROP VIEW IF EXISTS ac4; CREATE VIEW ac4 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 5; DROP VIEW IF EXISTS cs3_core; DROP VIEW IF EXISTS cs3; CREATE VIEW cs3 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 6; DROP VIEW IF EXISTS ac5_core; DROP VIEW IF EXISTS ac5; CREATE VIEW ac5 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 7; DROP VIEW IF EXISTS cs4_core; DROP VIEW IF EXISTS cs4; CREATE VIEW cs4 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 8; DROP VIEW IF EXISTS cs5_core; DROP VIEW IF EXISTS cs5; CREATE VIEW cs5 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 9; DROP VIEW IF EXISTS ac6_core; DROP VIEW IF EXISTS ac6; CREATE VIEW ac6 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 10; DROP VIEW IF EXISTS ac7_core; DROP VIEW IF EXISTS ac7; CREATE VIEW ac7 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 11; DROP VIEW IF EXISTS cs6_core; DROP VIEW IF EXISTS cs6; CREATE VIEW cs6 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 12; DROP VIEW IF EXISTS ac8_core; DROP VIEW IF EXISTS ac8; CREATE VIEW ac8 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 13; DROP VIEW IF EXISTS ac9_core; DROP VIEW IF EXISTS ac9; CREATE VIEW ac9 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 14; DROP VIEW IF EXISTS ac10_core; DROP VIEW IF EXISTS ac10; CREATE VIEW ac10 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 15; DROP VIEW IF EXISTS cs7_core; DROP VIEW IF EXISTS cs7; CREATE VIEW cs7 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 16; DROP VIEW IF EXISTS ac11_core; DROP VIEW IF EXISTS ac11; CREATE VIEW ac11 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 17; DROP VIEW IF EXISTS cs8_core; DROP VIEW IF EXISTS cs8; CREATE VIEW cs8 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 18; DROP VIEW IF EXISTS cs9_core; DROP VIEW IF EXISTS cs9; CREATE VIEW cs9 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 19; DROP VIEW IF EXISTS ac12_core; DROP VIEW IF EXISTS ac12; CREATE VIEW ac12 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 20; DROP VIEW IF EXISTS cs10_core; DROP VIEW IF EXISTS cs10; CREATE VIEW cs10 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 21; DROP VIEW IF EXISTS ac13_core; DROP VIEW IF EXISTS ac13; CREATE VIEW ac13 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 22; DROP VIEW IF EXISTS cs11_core; DROP VIEW IF EXISTS cs11; CREATE VIEW cs11 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 23; DROP VIEW IF EXISTS cs12_core; DROP VIEW IF EXISTS cs12; CREATE VIEW cs12 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 24; DROP VIEW IF EXISTS ac14_core; DROP VIEW IF EXISTS ac14; CREATE VIEW ac14 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 25; DROP VIEW IF EXISTS cs13_core; DROP VIEW IF EXISTS cs13; CREATE VIEW cs13 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 26; DROP VIEW IF EXISTS ac15_core; DROP VIEW IF EXISTS ac15; CREATE VIEW ac15 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 27; DROP VIEW IF EXISTS cs14_core; DROP VIEW IF EXISTS cs14; CREATE VIEW cs14 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 28; DROP VIEW IF EXISTS ac16_core; DROP VIEW IF EXISTS ac16; CREATE VIEW ac16 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 29; DROP VIEW IF EXISTS cs15_core; DROP VIEW IF EXISTS cs15; CREATE VIEW cs15 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 30; DROP VIEW IF EXISTS cs16_core; DROP VIEW IF EXISTS cs16; CREATE VIEW cs16 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 31; DROP VIEW IF EXISTS cs16_2_core; DROP VIEW IF EXISTS cs16_2; CREATE VIEW cs16_2 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 32; DROP VIEW IF EXISTS ac17_core; DROP VIEW IF EXISTS ac17; CREATE VIEW ac17 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 33; DROP VIEW IF EXISTS ac18_core; DROP VIEW IF EXISTS ac18; CREATE VIEW ac18 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 34; DROP VIEW IF EXISTS ac19_core; DROP VIEW IF EXISTS ac19; CREATE VIEW ac19 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 35; DROP VIEW IF EXISTS ac20_core; DROP VIEW IF EXISTS ac20; CREATE VIEW ac20 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 36; DROP VIEW IF EXISTS ac21_core; DROP VIEW IF EXISTS ac21; CREATE VIEW ac21 AS SELECT list.info, ver_id, music.music_id, music.music_no, music.music_name, music.music_name_sort, music.music_battle, music.music_first_ver, music.music_folder_ver, genre.genre_id, genre.genre_name, artist.artist_id, artist.artist_name, notesdata.data_id, notesdata.dif, notesdata.dif_id, notesdata.bpm_min, notesdata.bpm_max, notesdata.notes, notesdata.scratch, notesdata.chargenotes, notesdata.bss FROM list JOIN notesdata USING(data_id) JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id) WHERE list.ver_id = 37; DROP VIEW IF EXISTS alldata; CREATE VIEW alldata AS SELECT music_id, music_no, music_name, music_name_sort, music_battle, music_folder_ver, genre_id, genre_name, artist_id, artist_name, data_id, dif, dif_id, bpm_min, bpm_max, notes, scratch, chargenotes, bss, data_date FROM (notesdata JOIN music USING(music_id) JOIN artist USING(artist_id) JOIN genre USING(genre_id)) SQL; execSQL($EXEC_SQL); echo "data splited"; }
function modulesetting_db_get($name, $category = '') { LOG_MSG('INFO', "modulesetting_db_get(): START { name=[{$name}] category=[{$category}] \n}"); $param_arr = _init_db_params(); // Where Clause $where_clause = "WHERE name = ? AND travel_id=" . TRAVEL_ID; $param_arr = _db_prepare_param($param_arr, "s", "name", $name, true); if ($category != '') { $where_clause .= " AND category=? "; $param_arr = _db_prepare_param($param_arr, "s", "category", $category, true); } $resp = execSQL("SELECT \n\t\t\t\t\t\tvalue\n\t\t\t\t\tFROM \n\t\t\t\t\t\ttSetting \n\t\t\t\t\t{$where_clause} ", $param_arr['params'], false); LOG_MSG('INFO', "modulesetting_db_get(): END"); if ($resp[0]['STATUS'] != 'OK') { LOG_MSG('ERROR', "modulesetting_db_get(): There was an error loading name=[{$name}]"); return false; } if ($resp[0]['NROWS'] != 1) { LOG_MSG('INFO', "modulesetting_get(): No value found for [{$name}]"); return false; } return $resp[0]['value']; }
if (isset($_POST['send_pwd'])) { $login = isset($_POST['f_caver_login']) ? $_POST['f_caver_login'] : ''; $contact = isset($_POST['f_caver_contact']) ? $_POST['f_caver_contact'] : ''; $password = generatePassword(10, 8); $string = isset($_POST['f_caver_check']) ? $_POST['f_caver_check'] : ''; $user_check = isset($_SESSION['userCheck']) ? $_SESSION['userCheck'] : ''; if (!$_SESSION['do_check'] || md5(getIp() . strtolower($string)) == $user_check) { $sql = "SELECT * FROM `" . $_SESSION['Application_host'] . "`.`T_caver`"; $sql .= " WHERE Login = '******' AND Contact ='" . $contact . "'"; $data = getDataFromSQL($sql, __FILE__, $frame, __FUNCTION__); if ($data['Count'] > 0) { if ($data[0]['Activated'] == 'YES') { $sql = "UPDATE `" . $_SESSION['Application_host'] . "`.`T_caver`"; $sql .= " SET Password ='******'"; $sql .= " WHERE Id = " . $data[0]['Id']; $req = execSQL($sql, $frame, __FILE__, __FUNCTION__); if (!defined('NO_PHPBB_INSTALLED')) { chgPwdphpBBuser($login, $password); } sendNewPwdMail($data[0], $password); //echo $password; trackAction("pwd_user", $data[0]['Id'], "T_caver"); $_SESSION['user_pwd_sent'] = true; } else { $activated = false; $_SESSION['user_pwd_sent'] = false; } } else { $_SESSION['user_pwd_sent'] = false; $_SESSION['send_retry'] += 1; }
/** * * * @param mixed $colNames * @param mixed $recID * @param mixed $rt */ function updateReportSchedule($colNames, $recID, $values) { global $db, $sys_usrReportSchedule_ColumnNames; $ret = null; if (count($colNames) && count($values)) { $db = mysqli_connection_overwrite(DATABASE); $isInsert = $recID < 0; $query = ""; $fieldNames = ""; $parameters = array(""); $fieldNames = join(",", $colNames); foreach ($colNames as $colName) { $val = array_shift($values); if (array_key_exists($colName, $sys_usrReportSchedule_ColumnNames)) { if ($query != "") { $query = $query . ","; } if ($isInsert) { $query = $query . "?"; } else { $query = $query . "{$colName} = ?"; } $parameters[0] = $parameters[0] . $sys_usrReportSchedule_ColumnNames[$colName]; //take datatype from array array_push($parameters, $val); } } //for columns if ($query != "") { if ($isInsert) { $query = "insert into usrReportSchedule (" . $fieldNames . ") values (" . $query . ")"; } else { $query = "update usrReportSchedule set " . $query . " where rps_ID = {$recID}"; } $rows = execSQL($db, $query, $parameters, true); if ($rows == 0 || is_string($rows)) { $oper = $isInsert ? "inserting" : "updating"; $ret = "error {$oper} in updateReportSchedule - " . $rows; //$msqli->error; } else { if ($isInsert) { $recID = $db->insert_id; $ret = -$recID; } else { $ret = $recID; } } } $db->close(); } //if column names if ($ret == null) { $ret = "no data supplied for updating report - {$recID}"; } return $ret; }
/** Run the module install/uninstall scripts * @param string The name of the module * @param string The action to perform, either 'install' or 'uninstall' * @return boolean If the action was succesful */ function _module_runscripts($modulename, $type) { global $amp_conf; $db_engine = $amp_conf["AMPDBENGINE"]; $moduledir = $amp_conf["AMPWEBROOT"] . "/admin/modules/" . $modulename; if (!is_dir($moduledir)) { return false; } switch ($type) { case 'install': // install sql files $sqlfilename = "install.sql"; $rc = true; if (is_file($moduledir . '/' . $sqlfilename)) { $rc = execSQL($moduledir . '/' . $sqlfilename); } // then run .php scripts return _modules_doinclude($moduledir . '/install.php', $modulename) && $rc; break; case 'uninstall': // run uninstall .php scripts first $rc = _modules_doinclude($moduledir . '/uninstall.php', $modulename); $sqlfilename = "uninstall.sql"; // then uninstall sql files if (is_file($moduledir . '/' . $sqlfilename)) { return $rc && execSQL($moduledir . '/' . $sqlfilename); } else { return $rc; } break; default: return false; } return true; }
`pabrik02`, `pabrik03`, `pabrik04`, `pabrik05`, `satuan_kirim`, `jenis_obat`, `kategori_obat`, `golongan`, `kode_guna`, `kode_persediaan`, `kode_pendapatan`, `kode_reduksi`, `kode_biaya`, `kode_ppn_k`, `kode_ppn_m`, `expire_date`, `ex_date`, `ex_month`, `ex_year`, `tipe_obat`, `obat_tunai`, `hna`, `harga_dosp`, `discount`, `ppn`, `averange_sale`, `stok_max`, `stok_min`, `stok`, `isi`, `kemasan`, `status`, `flags`, `created_datetime`, `created_user`, `update_datetime`, `update_user`, `no_batch`, `no_rak`, `fld01`, `fld02`, `fld03`) SELECT a.group_barang, a.kd_barang, a.nama, a.satuan, $suppID, a.pabrik02, a.pabrik03, a.pabrik04, a.pabrik05, b.satuan_po, a.jenis_obat, a.kategori_obat, a.golongan, a.kode_guna, a.kode_persediaan, a.kode_pendapatan, a.kode_reduksi, a.kode_biaya, a.kode_ppn_k, a.kode_ppn_m, b.fld05, day(b.fld05), month(b.fld05), year(b.fld05), a.tipe_obat, a.obat_tunai, a.hna, b.harga_po, b.discount, (b.harga_po *0.1), a.averange_sale, a.stok_max, a.stok_min, b.qty_po, a.isi, a.kemasan, 'Aktif', 1, now(), '$userLoged', now(), '$userLoged', a.fld06, a.no_rak, b.no_po, b.no_spb, b.id FROM ms_barang a INNER JOIN purchase_orderdetail b on a.id = b.barang_id WHERE b.id =$val "; execSQL($strSQLUpMs); //print $strSQLUpMs; $strSQLUpFlags = "UPDATE ms_barang set flags = 1 where id = $val"; execSQL ($strSQLUpFlags); } } die("<meta http-equiv='refresh' content='0;url=home.php?hal=content/list_po'>"); break; case 3: //die(print "$noPO :: $noReq :: $lastNO :: $items :: $dbPO :: $flags :: $suppID :: 3"); /* CHANGED PO STATUS TO (APPROVED) */ /* IF IT's ALREADY ON (APPROVED) STATUS THEN CHANGED TO (RECEIVING) */ $items = $_POST['param']; if(empty($noPO)){$noPO = $_POST['pono'];} if(empty($noReq)){$noReq = $_POST['no_req'];} if(empty($suppID)){$suppID = $_POST['posupplier'];} if(empty($poID)){$poID = $_POST['idPO'];} /*for($i=0;$i<=$items;$i++){ $toDBDetSatuan = $_POST['txtSat'.$i];
<?php include "header.php"; if ($loggedin) { if (isset($_POST["username"]) && isset($_POST["about"])) { // Modify existing profile $result = execSQL("UPDATE users SET about='" . $_POST["about"] . "', profileimage='" . $_POST["profileimage"] . "' WHERE username='******'"); redirect("profile.php?u=" . $_POST["username"]); } else { redirect(""); } } include "footer.php";
/** * put your comment there... * * @param mixed $rcons - array that contains data for on record in defRelationshipConstraints */ function updateRelConstraint($srcID, $trgID, $terms) { global $mysqli, $rcsColumnNames; $ret = null; if ($terms == null) { $terms = array("null", '', "null", ''); } if (intval($terms[2]) < 1) { //if($terms[2]==null || $terms[2]=="" || $terms[2]=="0"){ $terms[2] = "null"; } $where = " where "; if (intval($srcID) < 1) { $srcID = "null"; $where = $where . " rcs_SourceRectypeID is null"; } else { $where = $where . " rcs_SourceRectypeID=" . $srcID; } if (intval($trgID) < 1) { $trgID = "null"; $where = $where . " and rcs_TargetRectypeID is null"; } else { $where = $where . " and rcs_TargetRectypeID=" . $trgID; } if (intval($terms[0]) < 1) { // $terms[0]==null || $terms[0]==""){ $terms[0] == "null"; $where = $where . " and rcs_TermID is null"; } else { $where = $where . " and rcs_TermID=" . $terms[0]; } $query = "select rcs_ID from defRelationshipConstraints " . $where; $res = $mysqli->query($query); $parameters = array("s", $terms[3]); //notes will be parameter $query = ""; if ($res == null || $res->num_rows < 1) { //$mysqli->affected_rows<1){ //insert $query = "insert into defRelationshipConstraints(rcs_SourceRectypeID, rcs_TargetRectypeID, rcs_Description, rcs_TermID, rcs_TermLimit) values (" . $srcID . "," . $trgID . ",?," . $terms[0] . "," . $terms[2] . ")"; } else { //update $query = "update defRelationshipConstraints set rcs_Description=?, rcs_TermID=" . $terms[0] . ", rcs_TermLimit=" . $terms[2] . $where; } $rows = execSQL($mysqli, $query, $parameters, true); if ($rows == 0 || is_string($rows)) { $ret = "SQL error in updateRelConstraint: " . $query; //$mysqli->error; } else { $ret = array($srcID, $trgID, $terms); } return $ret; }
function uploadNewPics($overRideThumb = false) { global $config; $thumbOnly = $config->uploadThumbOnly; $PicIDs = array(); if ($thumbOnly && !$overRideThumb) { $query = "select MID,FileName,ThumbUpload,FullUpload,UNIX_TIMESTAMP(MotionTime) MotionTime from Motion where ThumbUpload=0"; $result = getSQLResult("uploadNewPics 1", $query); for ($row = $result->fetch_object(); $row; $row = $result->fetch_object()) { $PicIDs[$row->MID] = array('Filename' => $row->FileName, 'PictureTime' => $row->MotionTime); } foreach ($PicIDs as $PicID => $values) { $filename = $values["Filename"]; make_thumb($filename, "/dev/shm/upload/thumb.jpg", 240); $pic = file_get_contents("/dev/shm/upload/thumb.jpg"); $upload = uploadPic($pic, $values['PictureTime'], true, $PicID); if ($upload) { $query = "update Motion set ThumbUpload=1 where MID=?"; $result = execSQL("interact,uploadNewPics {$PicID}", $query, "i", $PicID); } } } else { $query = "select MID,FileName,ThumbUpload,FullUpload,UNIX_TIMESTAMP(MotionTime) MotionTime from Motion where FullUpload=0"; $result = getSQLResult("uploadNewPics 2", $query); for ($row = $result->fetch_object(); $row; $row = $result->fetch_object()) { $PicIDs[$row->MID] = array('Filename' => $row->FileName, 'PictureTime' => $row->MotionTime); } foreach ($PicIDs as $PicID => $values) { $filename = $values["Filename"]; $pic = file_get_contents($filename); logMessage("Found pic to upload PicID={$PicID} filename={$filename}, size=" . strlen($pic)); $upload = uploadPic($pic, $values['PictureTime'], false, $PicID); if ($upload) { $query = "update Motion set ThumbUpload=1,FullUpload=1 where MID=?"; $result = execSQL("interact,uploadNewPics {$PicID}", $query, "i", $PicID); } } } }
loadView("start"); ?> <h2>Home</h2> <form method="post" action="<?php url("post.php"); ?> " id="share"> <textarea name="content" placeholder="Share something!"></textarea> <input name="color" type="text" /> <button type="submit">Share</button> </form> <div id="posts"> <?php // Get the newest 50 posts $posts = execSQL("SELECT * FROM posts ORDER BY created DESC LIMIT 50"); if ($posts->num_rows > 0) { // Loop through the posts while ($post = $posts->fetch_assoc()) { ?> <div id="<?php echo $post["id"]; ?> "> <div class="sideline" style="border-color:<?php echo $post["color"]; ?> "></div> <div class="profileimage" style="background-image:url(<?php echo getUser($post["username"])["profileimage"]; ?>
execSQL($qp); echo "masuk update"; } echo "</script><script language=javascript>window.opener.location.reload();window.close();</script><script runat=server>"; } if ($_POST['in']==1) { $ket=$_POST['ket']; if(empty($ket)){$ket=$_GET['ket'];} $id=$_POST['id']; $No_SPP=$_GET['No_SPP']; $UsrRetur=$_POST['UsrRetur']; $tgl=date("d/m/Y"); $query=("UPDATE permintaan_unitdetail SET No_BTB='$no_BTB', tgl_retur='$tgl', UsrRetur='$UsrRetur', ket_retur='$ket', status_detail='6' WHERE id='$id'"); execSQL($query); //echo $count; //$rwt=($query); //die($query); //$result=mysql_fetch_array($query); //echo $ket; //echo "dapet"; $hehe=1; print "<script>alert('Data Berhasil di Input');location.href='input_buat_retur_rawat_jalan.php?No_SPP=$No_SPP&hehe=$hehe'</script>"; } ?> </head>
case 'ORTHOLOGY': $table = 'orthologies'; break; } preg_match("/^(.*?)(?:\\s+\\[(.*?):(.*)\\])?\$/", $match[4], $matchParts); if (strpos($matchParts[1], "[" !== FALSE)) { die("[DIE] More than one external datasource on line {$lineNo}: {$line}\n"); } if (count($matchParts) > 2) { foreach (explode(" ", $matchParts[3]) as $externalId) { execSQL("INSERT INTO `{$table}_dblinks` (id, db, external_id) VALUES ('{$match[3]}','{$matchParts[2]}','{$externalId}');"); } } execSQL("INSERT INTO `{$table}` (id, name) VALUES ('{$match[3]}','{$matchParts[1]}');"); execSQL("INSERT INTO `genes_{$table}` (genes_id, {$table}_id) VALUES ('{$gene}','{$match[3]}');"); break; case 'PATHWAY': execSQL("INSERT INTO `pathways` (id, name) VALUES ('{$match[3]}','{$match[4]}');"); execSQL("INSERT INTO `genes_pathways` (genes_id, pathways_id) VALUES ('{$gene}','{$match[3]}');"); break; case 'DISEASE': execSQL("INSERT INTO `diseases` (id, name) VALUES ('{$match[3]}','{$match[4]}');"); execSQL("INSERT INTO `genes_diseases` (genes_id, diseases_id) VALUES ('{$gene}','{$match[3]}');"); break; default: if (trim($line) != "") { die("[DIE] Unrecognized line {$lineNo}: " . $line . "\n"); } } } fclose($file_handle);
<?php include "header.php"; if (isset($_POST["username"]) && $_POST["password"] == $_POST["password2"]) { // Add new profile to databse execSQL("INSERT INTO users (username, password) " . "VALUES ('" . strtolower($_POST["username"]) . "', '" . sha1($_POST["password"]) . "')"); } redirect(""); include "footer.php";
/** * put your comment there... * * @param mixed $grpID - group ID * @param mixed $recIds - comma separated list of affected user IDs * @param mixed $newRole - new role */ function changeRole($grpID, $recIds, $newRole, $oldRole, $needCheck, $updateSession) { global $db; $ret = array(); /*****DEBUG****/ //error_log(">>>>> grpId=".$grpID.", recIds=".$recIds.", newrole=".$newRole.", oldrole=".$oldRole); if ($needCheck) { $ret2 = checkPermission('group', $grpID); if ($ret2 != null) { $ret['error'] = $ret2; return $ret; } } if (is_numeric($recIds)) { $arrUsers = array(); $arrUsers[0] = $recIds; } else { $arrUsers = split(",", $recIds); } $is_myself_affected = false; $current_user_id = get_user_id(); //remove from group if ($newRole == "delete") { $ret['results'] = array(); $ret['errors'] = array(); foreach ($arrUsers as $userID) { $is_myself_affected = $is_myself_affected || $userID == $current_user_id; if ($userID == 2) { $error = "Not possible to delete database owner"; } else { $error = checkLastAdmin($userID, $grpID); } if ($error == null) { /*****DEBUG****/ //error_log("DELETED DELETED DELETED DELETED DELETED DELETED DELETED DELETED "); $query = "delete from sysUsrGrpLinks where ugl_UserID={$userID} and ugl_GroupID={$grpID}"; $rows = execSQL($db, $query, null, true); if ($rows == 0 || is_string($rows)) { // error delete reference for this user array_push($ret['errors'], "db error deleting relations for user# {$userID}"); } else { array_push($ret['results'], $userID); } } else { array_push($ret['errors'], $error); } } } else { if ($oldRole != null) { //modification of role $ret['errors'] = array(); $ret['results'] = array(); foreach ($arrUsers as $userID) { $is_myself_affected = $is_myself_affected || $userID == $current_user_id; $error = null; if ($userID == 2 && $grpID == 1) { $error = "Not possible to change role for database owner"; array_push($ret['errors'], $error); } else { if ($oldRole == "admin" && $newRole == "member") { $error = checkLastAdmin($userID, $grpID); if ($error) { array_push($ret['errors'], $error); } } } if ($error == null) { $query = "UPDATE sysUsrGrpLinks set ugl_Role='{$newRole}' where ugl_GroupID={$grpID} and ugl_UserID={$userID}"; $rows = execSQL($db, $query, null, true); if ($rows == 0 || is_string($rows)) { array_push($ret['errors'], "DB error changing roles in sysUsrGrpLinks for group {$grpID}, user {$userID} - " . $rows); } else { array_push($ret['results'], $userID); } } } //for } else { //insert new roles for non-existing entries $query = "INSERT INTO sysUsrGrpLinks (ugl_GroupID, ugl_UserID, ugl_Role) VALUES "; $nofirst = false; $resIDs = ""; foreach ($arrUsers as $userID) { $is_myself_affected = $is_myself_affected || $userID == $current_user_id; if ($nofirst) { $query = $query . ", "; $resIDs = $resIDs . ", "; } $query = $query . "({$grpID}, {$userID}, '{$newRole}')"; $resIDs = $resIDs . "{$userID}"; $nofirst = true; } /* DEBUG if($nofirst){ /*****DEBUG****/ //error_log("DOWN TO DOWN TO DOWN TO DOWN TO DOWN TO DOWN TO DOWN TO DOWN TO $newRole"); /* //$nofirst = false; //$ret['result'] = $resIDs; } */ if ($nofirst) { $query = $query . " ON DUPLICATE KEY UPDATE ugl_Role='{$newRole}'"; $rows = execSQL($db, $query, null, true); if ($rows == 0 || is_string($rows)) { $ret['error'] = "DB error setting role in sysUsrGrpLinks - " . $rows; } else { $ret['result'] = $resIDs; } } } } //update group info for affected users if ($updateSession) { foreach ($arrUsers as $userID) { $groups = reloadUserGroups($userID); updateSessionForUser($userID, 'user_access', $groups); } } //if($is_myself_affected){ // updateSessionInfo(); //} return $ret; }
<?php include "header.php"; if ($loggedin) { if (isset($_POST["color"]) && isset($_POST["content"])) { // Save post to database $result = execSQL("INSERT INTO posts (username, content, color) " . "VALUES ('" . strtolower($user["username"]) . "', '" . $_POST["content"] . "', '" . $_POST["color"] . "')"); } redirect(""); } include "footer.php";
function loadPO($poNo){ $strSQLLoad= "SELECT * FROM `purchase_order` where `po_no` = '". $poNo . "' "; $execGo = execSQL($strSQLLoad); $retCreate = array ($execGo['po_no'], $execGo['request_no'], $execGo['tgl_po'], $execGo['id_supplier'], $execGo['created_user']); return($retCreate); }
include "header.php"; if ($loggedin) { if (isset($_GET["logout"])) { // Delete session, remove cookies to logout // http://php.net/manual/en/function.session-destroy.php setcookie("id", "", time() - 42000); setcookie("username", "", time() - 42000); setcookie(session_name(), "", time() - 42000); session_destroy(); redirect(""); } loadView("home"); } else { if (isset($_POST["username"]) && isset($_POST["password"])) { // Check if user with given credentials exists $result = execSQL("SELECT * FROM users WHERE username='******' AND password='******'"); if ($result->num_rows > 0) { // Correct username and password while ($row = $result->fetch_assoc()) { $expire = 60 * 60 * 12; // Cookies expire in 12 hours setcookie("id", $row["id"], time() + $expire); setcookie("username", $row["username"], time() + $expire); } redirect(""); } else { redirect("?wrong"); } } else { loadView("welcome"); }
function db_is_sync_supervisor_update($is_sync) { $param_arr = _init_db_params(); LOG_MSG('INFO', "db_is_sync_supervisor_update(): START {\n\t\t\t\t\t\t\tis_sync=[{$is_sync}]\n}"); // Add params to params_arr $param_arr = _db_prepare_param($param_arr, "i", "is_sync", $is_sync); // For the where clause $where_clause = " WHERE travel_id= " . TRAVEL_ID; $resp = execSQL("UPDATE \n\t\t\t\t\t\ttSupervisor\n\t\t\t\t\tSET " . $param_arr['update_fields'] . $where_clause, $param_arr['params'], true); LOG_MSG('INFO', "db_is_sync_supervisor_update(): END"); return $resp; }
/** Run the module install/uninstall scripts * @param string The name of the module * @param string The action to perform, either 'install' or 'uninstall' * @param array The modulexml array * @return boolean If the action was succesful */ function _runscripts($modulename, $type, $modulexml = false) { global $amp_conf; $db_engine = $amp_conf["AMPDBENGINE"]; $moduledir = $amp_conf["AMPWEBROOT"] . "/admin/modules/" . $modulename; if (!is_dir($moduledir)) { return false; } switch ($type) { case 'install': // install sql files $sqlfilename = "install.sql"; $rc = true; if (is_file($moduledir . '/' . $sqlfilename)) { $rc = execSQL($moduledir . '/' . $sqlfilename); } //include additional files developer requested if ($modulexml !== false) { $this->_runscripts_include($modulexml, $type); } // If it's a BMO module, manually include the file. $mn = ucfirst($modulename); $bmofile = "{$moduledir}/{$mn}.class.php"; if (file_exists($bmofile)) { try { FreePBX::create()->injectClass($mn, $bmofile); $o = FreePBX::create()->{$mn}->install(); if ($o === false) { return false; } } catch (Exception $e) { dbug("Error Returned was: " . $e->getMessage()); return false; } } // then run .php scripts return $this->_doinclude($moduledir . '/install.php', $modulename) && $rc; break; case 'uninstall': //include additional files developer requested if ($modulexml !== false) { $this->_runscripts_include($modulexml, $type); } // run uninstall .php scripts first $rc = $this->_doinclude($moduledir . '/uninstall.php', $modulename); $sqlfilename = "uninstall.sql"; // If it's a BMO module, run uninstall. $mn = ucfirst($modulename); $bmofile = "{$moduledir}/{$mn}.class.php"; if (file_exists($bmofile)) { try { $o = FreePBX::create()->{$mn}->uninstall(); if ($o === false) { return false; } } catch (Exception $e) { dbug("Error Returned was: " . $e->getMessage()); return false; } } // then uninstall sql files if (is_file($moduledir . '/' . $sqlfilename)) { return $rc && execSQL($moduledir . '/' . $sqlfilename); } else { return $rc; } break; default: return false; } return true; }
<?php ini_set('display_errors', 1); $_SERVER['SERVER_NAME'] = 'SERVER'; $_SERVER['REMOTE_ADDR'] = true; error_reporting(E_ERROR | E_PARSE); define("IGNORE_SWIFT", "true"); $DOMAIN = "script"; require_once '../../lib/swiftmailer/swift_required.php'; include "../../lib/utils.php"; include "../../tConf.php"; include "../../lib/db.php"; db_connect(); // Select vehicle $vehicle_report_select = execSQL("SELECT\n\t\t\t\t\t\t\t\t\t\treg_no,\n\t\t\t\t\t\t\t\t\t\timei,\n\t\t\t\t\t\t\t\t\t\tclient_name,\n\t\t\t\t\t\t\t\t\t\todometer_reading,\n\t\t\t\t\t\t\t\t\t\tfuel_filled,\n\t\t\t\t\t\t\t\t\t\tDATE_FORMAT(created_dt,'%Y-%m-%d %h:%i %p')\n\t\t\t\t\t\t\t\t\tFROM\n\t\t\t\t\t\t\t\t\t\ttSearch\n\t\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\t\ttravel_id=4 AND\n\t\t\t\t\t\t\t\t\t\tcreated_dt like '" . date("Y-m-d") . "%' AND\n\t\t\t\t\t\t\t\t\t\tfuel_filled <> 0", array(), false); if ($vehicle_report_select[0]['STATUS'] !== 'OK') { echo "Error fetching vehicle "; echo print_arr($vehicle_report_select); exit; } $fp = fopen("megha_report.csv", "w"); $nrows = $vehicle_report_select[0]['NROWS']; unset($vehicle_report_select[0]['NROWS']); unset($vehicle_report_select[0]['STATUS']); $report = "REG NO, IMEI, CLIENT, ODOMETER READING, FUEL FILLED, DATE" . "\r\n"; for ($i = 0; $i < $nrows; $i++) { //echo implode( ',' ,$vehicle_report_select[$i])."\r\n"; $report = $report . implode(',', $vehicle_report_select[$i]) . "\r\n"; } $fp = fwrite($fp, $report); rewind($fp);