function request_create_after($data) { $s = update_logo(); if ($s === false) { return false; } $profile_id = $data[0]["id"]; $user_id = $data[0]["_user_id"]; $gid = Jaring::db_generate_id(); // insert profile's admin $q = "\n\t\tinsert into _profile_admin (_profile_id, _user_id)\n\t\tvalues ({$profile_id}, {$user_id})\n\t\t"; Jaring::db_execute($q, null, false); // update user profile id. $q = "\n\t\tupdate\t_user\n\t\tset\t\t_profile_id = ?\n\t\twhere\tid\t\t\t= ?\n\t\t"; $qbind = array($profile_id, $user_id); Jaring::db_execute($q, $qbind, false); // add group Administrator to group. $q = "\n\t\tinsert into _group (_profile_id, id, pid, name, type)\n\t\tvalues ({$profile_id}, {$gid}, 0, 'Administrator', 0)\n\t\t"; Jaring::db_execute($q, null, false); // add user to group Administrator. $id = Jaring::db_generate_id(); $q = "\n\t\tinsert into _user_group (_profile_id, id, _user_id, _group_id)\n\t\tvalues ({$profile_id}, {$id}, {$user_id}, {$gid})\n\t\t"; Jaring::db_execute($q, null, false); // add menu access. $q = "\n\t\tinsert into _group_menu\n\t\t\tselect\t{$gid}, _menu_id, permission\n\t\t\tfrom\t_group_menu\n\t\t\twhere\t_group_id = 1\n\t\t"; Jaring::db_execute($q, null, false); }
<?php /* Copyright 2014 - Mhd Sulhan Authors: - mhd.sulhan (m.shulhan@gmail.com) */ // insert into media table $table = "_media"; $fields = ["id", "name", "extension", "size", "mime", "path"]; $fupath = Jaring::$_media_dir . sha1_file($_FILES["content"]["tmp_name"]); Jaring::db_prepare_insert($table, $fields); $pi = pathinfo($_FILES["content"]["name"]); $bindv = []; $bindv[] = Jaring::db_generate_id(); $bindv[] = $pi["filename"]; $bindv[] = $pi["extension"]; $bindv[] = $_FILES["content"]["size"]; $bindv[] = $_FILES["content"]["type"]; $bindv[] = $fupath; Jaring::$_db_ps->execute($bindv); Jaring::$_db_ps->closeCursor(); move_uploaded_file($_FILES["content"]["tmp_name"], APP_PATH . "/" . $fupath); // link media id into table _media_table $id = $bindv[0]; $table = "_media_table"; $fields = ["table_id", "_media_id"]; $bindv = [$_POST["table_id"], $id]; Jaring::db_prepare_insert($table, $fields); Jaring::$_db_ps->execute($bindv); Jaring::$_db_ps->closeCursor();