/**
* Execute the command.
*
* @return void
*/
public function handle()
{
$this->exam->create($this->request->all());
$this->exam->update(['uid' => generate_id()]);
session()->flash('success-message', trans('site.Successfully created'));
event(new Exam\Events\CreatedEvent($this->exam));
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
\Model\Course\Course::truncate();
// factory(\Model\Course\Course::class, 10)->create();
\Model\Course\Course::create(['id' => 1, 'uid' => generate_id(), 'url' => 'http://eders.manas.edu.kg/enrol/index.php?id=9', 'image' => 'img/course/cover/tarih-600x400.jpg', 'code' => 'TAR-251', 'name' => 'Ата Мекен Тарыхы I', 'description' => 'Атамекен (Кыргыз Республикасынын) тарыхын окутууга киришүү Кыргызстандагы этникалык процесстер, кыргыз элинин жаралышы жана калыптанышы жөнүндө', 'approved' => true, 'published' => true, 'order' => 10]);
\Model\Course\Course::create(['id' => 2, 'uid' => generate_id(), 'url' => null, 'image' => 'img/course/cover/ekoloji-600x400.jpg', 'code' => 'CEV-150', 'name' => 'Экология', 'description' => 'Киришүү. Экологиянын маселелери, изилдөө объектиси жана структурасы. Экологиянын дисциплиналар арасындагы мүнөзү', 'approved' => true, 'published' => true, 'order' => 20]);
\Model\Course\Course::create(['id' => 3, 'uid' => generate_id(), 'url' => 'http://eders.manas.edu.kg/enrol/index.php?id=8', 'image' => 'img/course/cover/turk-uygralik-600x400.jpg', 'code' => 'TAR-202', 'name' => 'Dünya ve Türk Uygarlıkları', 'description' => 'Көчмөн цивлизациялардын өзгөчөлүктөрү', 'approved' => true, 'published' => true, 'order' => 30]);
\Model\Course\Course::create(['id' => 4, 'uid' => generate_id(), 'url' => 'http://eders.manas.edu.kg/enrol/index.php?id=3', 'image' => 'img/course/cover/manas-600x400.jpg', 'code' => 'TUR-226', 'name' => 'Manasşinaslık', 'description' => '“Манас” эпосу – кыргыз рухунун туу чокусу', 'approved' => true, 'published' => true, 'order' => 40]);
\Model\Course\Course::create(['id' => 5, 'uid' => generate_id(), 'url' => 'http://eders.manas.edu.kg/enrol/index.php?id=7', 'image' => 'img/course/cover/felsefe-600x400.jpg', 'code' => 'FIL-291', 'name' => 'Felsefe', 'description' => 'Felsefe Tarihi II (İslam ve Ortaçağ Felsefesi)', 'approved' => true, 'published' => true, 'order' => 50]);
\Model\Course\Course::create(['id' => 6, 'uid' => generate_id(), 'url' => 'http://eders.manas.edu.kg/enrol/index.php?id=12', 'image' => 'img/course/cover/positif-bilimler-600x400.jpg', 'code' => 'FEN-102', 'name' => 'Pozitiv Bilim Kavramları', 'description' => 'Заманбап табият таануу илимдеринин концепциялары курсунун предмети. Коом, маданият жана илим.', 'approved' => true, 'published' => true, 'order' => 60]);
\Model\Course\Course::create(['id' => 7, 'uid' => generate_id(), 'url' => 'http://eders.manas.edu.kg/enrol/index.php?id=2', 'image' => 'img/course/cover/tarih-2-600x400.jpg', 'code' => 'FEN-102', 'name' => 'Ata Meken Tarihi II (TR)', 'description' => 'Türkiye Cumhuriyeti Tarihi', 'approved' => true, 'published' => true, 'order' => 70]);
\Model\Course\Course::create(['id' => 8, 'uid' => generate_id(), 'url' => null, 'image' => 'img/course/cover/ume-333-600x400.jpg', 'code' => 'UME3', 'name' => 'Programming Languages I', 'description' => 'Programming Languages I', 'approved' => true, 'published' => true, 'order' => 80]);
\Model\Course\Course::create(['id' => 9, 'uid' => generate_id(), 'url' => null, 'image' => 'img/course/cover/java-600x400.jpg', 'code' => 'UME4', 'name' => 'Programming Languages II', 'description' => 'Introduction to Programming using Java', 'approved' => true, 'published' => true, 'order' => 90]);
// $courses = \Model\Course\Course::lists('id');
// $users = \Model\User\User::whereIn('role', ['student', 'teacher'])->lists('id')->toArray();
\DB::table('user_course')->insert(['user_id' => 3, 'course_id' => 2]);
\DB::table('user_course')->insert(['user_id' => 4, 'course_id' => 2]);
$students = \Model\User\User::where('role', '=', 'student')->get();
// registering students to course
$arr = [];
foreach ($students as $student) {
$arr[] = ['user_id' => $student->id(), 'course_id' => 2];
}
\DB::table('user_course')->insert($arr);
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
\Model\Question\Question::truncate();
/* factory(\Model\Question\Question::class, 100)->create(); */
$section1 = \Model\Section\Section::where('course_id', '=', 2)->first();
$section2 = \Model\Section\Section::where('course_id', '=', 2)->where('id', '>', $section1->id())->first();
$section3 = \Model\Section\Section::where('course_id', '=', 2)->where('id', '>', $section2->id())->first();
$section4 = \Model\Section\Section::where('course_id', '=', 2)->where('id', '>', $section3->id())->first();
\Model\Question\Question::insert([['id' => 1, 'section_id' => $section1->id(), 'uid' => generate_id(), 'text' => '“Экология” терминин сунуштаган окумуштуу'], ['id' => 2, 'section_id' => $section1->id(), 'uid' => generate_id(), 'text' => '“Экосистема” терминин сунуштаган окумуштуу'], ['id' => 3, 'section_id' => $section1->id(), 'uid' => generate_id(), 'text' => 'Биосфера жана ноосфера жөнүндө окуунун негиздөөчүсү'], ['id' => 4, 'section_id' => $section1->id(), 'uid' => generate_id(), 'text' => 'Аутэкологиянын изилдөө предмети'], ['id' => 5, 'section_id' => $section1->id(), 'uid' => generate_id(), 'text' => 'Заманбап экологиянын максаты'], ['id' => 6, 'section_id' => $section2->id(), 'uid' => generate_id(), 'text' => 'Организмдин жашоо чөйрөсү деп эмнени айтабыз?'], ['id' => 7, 'section_id' => $section2->id(), 'uid' => generate_id(), 'text' => 'Эдафикалык факторлор бул:'], ['id' => 8, 'section_id' => $section2->id(), 'uid' => generate_id(), 'text' => 'Орографикалык факторлор бул:'], ['id' => 9, 'section_id' => $section2->id(), 'uid' => generate_id(), 'text' => 'Лимиттенген факторлордун түргө таасири кандай:'], ['id' => 10, 'section_id' => $section2->id(), 'uid' => generate_id(), 'text' => 'Эврибионттор кандай организмдер?'], ['id' => 11, 'section_id' => $section3->id(), 'uid' => generate_id(), 'text' => 'Биогеценоз түшүнүгүн сунуштаган окумуштуу'], ['id' => 12, 'section_id' => $section3->id(), 'uid' => generate_id(), 'text' => 'Экосистема терминин сунуштаган окумуштуу'], ['id' => 13, 'section_id' => $section3->id(), 'uid' => generate_id(), 'text' => 'Бентос бул:'], ['id' => 14, 'section_id' => $section3->id(), 'uid' => generate_id(), 'text' => 'Гетеротрофтор:'], ['id' => 15, 'section_id' => $section3->id(), 'uid' => generate_id(), 'text' => 'Сукцессия бул:'], ['id' => 16, 'section_id' => $section4->id(), 'uid' => generate_id(), 'text' => 'Биосфера бул:'], ['id' => 17, 'section_id' => $section4->id(), 'uid' => generate_id(), 'text' => 'Костук заттар:'], ['id' => 18, 'section_id' => $section4->id(), 'uid' => generate_id(), 'text' => 'Биогендик заттар:'], ['id' => 19, 'section_id' => $section4->id(), 'uid' => generate_id(), 'text' => 'Топурак бул:'], ['id' => 20, 'section_id' => $section4->id(), 'uid' => generate_id(), 'text' => 'Жандуу заттын негизги функцияларынын бири:']]);
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
\Model\User\User::truncate();
\Model\User\User::create(['department_id' => 2001, 'number' => '0933', 'uid' => generate_id(), 'role' => 'admin', 'first_name' => 'Cngz', 'last_name' => 'Bg', 'phone' => '0 777 99 88 77', 'email' => '*****@*****.**', 'password' => '123123', 'approved' => true]);
\Model\User\User::create(['department_id' => 7001, 'number' => '0934', 'uid' => generate_id(), 'role' => 'admin', 'first_name' => 'Juma', 'last_name' => 'Nur', 'phone' => '0 777 99 88 66', 'email' => '*****@*****.**', 'password' => '123123', 'approved' => true]);
\Model\User\User::create(['department_id' => 7002, 'number' => '1130', 'uid' => generate_id(), 'role' => 'teacher', 'first_name' => 'Др. Нурзат', 'last_name' => 'Тотубаева', 'phone' => '49 27 56-57 (1080)', 'email' => '*****@*****.**', 'password' => 'nurzat567', 'approved' => true]);
\Model\User\User::create(['department_id' => 7002, 'number' => '1244', 'uid' => generate_id(), 'role' => 'teacher', 'first_name' => 'Кубат', 'last_name' => 'Кемелов', 'phone' => '49 27 52-53 (1063)', 'email' => '*****@*****.**', 'password' => 'kubat567', 'approved' => true]);
\Model\User\User::create(['department_id' => 2001, 'number' => '0932', 'uid' => generate_id(), 'role' => 'student', 'first_name' => 'Chingiz', 'last_name' => 'Begimkulov', 'phone' => '0557905050', 'email' => '*****@*****.**', 'password' => '123123', 'approved' => true]);
// factory(\Model\User\User::class, 100)->create();
DB::statement("INSERT INTO `users` (`number`, `email`, `first_name`, `last_name`, `department_id`, `password`, `approved`, `uid`) VALUES\n ('1501.04019', '*****@*****.**', 'MAKSAT', 'KADIRBERDİEV', '1008', '" . bcrypt('1501.04019') . "', 1, '" . generate_id() . "'),\n ('1501.04012', '*****@*****.**', 'UMUT', 'SIDIKOVA', '1008', '" . bcrypt('1501.04012') . "', 1, '" . generate_id() . "'),\n ('1501.04001', '*****@*****.**', 'ZERE', 'ASILBEK KIZI', '1008', '" . bcrypt('1501.04001') . "', 1, '" . generate_id() . "'),\n ('1401.04018', '*****@*****.**', 'ALİNA', 'USUPBAEVA', '1008', '" . bcrypt('1401.04018') . "', 1, '" . generate_id() . "'),\n ('1401.04017', '*****@*****.**', 'ALTINAY', 'İMANALİEVA', '1008', '" . bcrypt('1401.04017') . "', 1, '" . generate_id() . "'),\n ('1401.04016', '*****@*****.**', 'AZİZA', 'KADIEVA', '1008', '" . bcrypt('1401.04016') . "', 1, '" . generate_id() . "'),\n ('1401.04015', '*****@*****.**', 'ASEL', 'BEYŞEEVA', '1008', '" . bcrypt('1401.04015') . "', 1, '" . generate_id() . "'),\n ('1401.04013', '*****@*****.**', 'ALTINAY', 'NABATBEKOVA', '1008', '" . bcrypt('1401.04013') . "', 1, '" . generate_id() . "'),\n ('1401.04011', '*****@*****.**', 'NAZIRA', 'AZİMBEK KIZI', '1008', '" . bcrypt('1401.04011') . "', 1, '" . generate_id() . "'),\n ('1401.04010', '*****@*****.**', 'MADİNA', 'SATAROVA', '1008', '" . bcrypt('1401.04010') . "', 1, '" . generate_id() . "'),\n ('1401.04008', '*****@*****.**', 'BENAZİRA', 'ASIRANBEKOVA', '1008', '" . bcrypt('1401.04008') . "', 1, '" . generate_id() . "'),\n ('1401.04007', '*****@*****.**', 'KANIKEY', 'AALİEVA', '1008', '" . bcrypt('1401.04007') . "', 1, '" . generate_id() . "'),\n ('1401.04006', '*****@*****.**', 'MALİKA', 'DCAPAROVA', '1008', '" . bcrypt('1401.04006') . "', 1, '" . generate_id() . "'),\n ('1401.04005', '*****@*****.**', 'AYMİRA', 'ÖSKÖNALİEVA', '1008', '" . bcrypt('1401.04005') . "', 1, '" . generate_id() . "'),\n ('1401.04003', '*****@*****.**', 'AİDA', 'MATAZIMOVA', '1008', '" . bcrypt('1401.04003') . "', 1, '" . generate_id() . "'),\n ('1401.04002', '*****@*****.**', 'AYNAZİK', 'ANARBAEVA', '1008', '" . bcrypt('1401.04002') . "', 1, '" . generate_id() . "'),\n ('1401.04001', '*****@*****.**', 'NURİLA', 'SATTAROVA', '1008', '" . bcrypt('1401.04001') . "', 1, '" . generate_id() . "'),\n ('1301.04033', '*****@*****.**', 'ELMİRA', 'RISBEKOVA', '1008', '" . bcrypt('1301.04033') . "', 1, '" . generate_id() . "'),\n ('1301.04027', '*****@*****.**', 'AYSULU', 'BAYCİGİTOVA', '1008', '" . bcrypt('1301.04027') . "', 1, '" . generate_id() . "'),\n ('1301.04020', '*****@*****.**', 'AYZADA', 'SUYUMBAEVA', '1008', '" . bcrypt('1301.04020') . "', 1, '" . generate_id() . "'),\n ('1301.04009', '*****@*****.**', 'NURAİDA', 'TINÇTIKBEK KIZI', '1008', '" . bcrypt('1301.04009') . "', 1, '" . generate_id() . "'),\n ('1201.04010', '*****@*****.**', 'CANIL', 'ADİSBEKOVA', '1008', '" . bcrypt('1201.04010') . "', 1, '" . generate_id() . "'),\n ('1201.04004', '*****@*****.**', 'ASEL', 'KANATBEK KIZI', '1008', '" . bcrypt('1201.04004') . "', 1, '" . generate_id() . "'),\n ('1201.04002', '*****@*****.**', 'AYCAN', 'TINÇTIKBEKOVA', '1008', '" . bcrypt('1201.04002') . "', 1, '" . generate_id() . "'),\n ('1201.04001', '*****@*****.**', 'SEZİM', 'TEMİRKANOVA', '1008', '" . bcrypt('1201.04001') . "', 1, '" . generate_id() . "'),\n ('1401.05012', '*****@*****.**', 'ENES', 'KAAN BAYRAM', '1007', '" . bcrypt('1401.05012') . "', 1, '" . generate_id() . "'),\n ('1401.05010', '*****@*****.**', 'CANUZAK', 'ŞARŞEEV', '1007', '" . bcrypt('1401.05010') . "', 1, '" . generate_id() . "'),\n ('1401.05009', '*****@*****.**', 'SAYKAL', 'SABIRBEKOVA', '1007', '" . bcrypt('1401.05009') . "', 1, '" . generate_id() . "'),\n ('1401.05007', '*****@*****.**', 'AYZAT', 'MEDETBEK KIZI', '1007', '" . bcrypt('1401.05007') . "', 1, '" . generate_id() . "'),\n ('1401.05006', '*****@*****.**', 'MADİNA', 'TOLKUNALİEVA', '1007', '" . bcrypt('1401.05006') . "', 1, '" . generate_id() . "'),\n ('1401.05005', '*****@*****.**', 'AZALİYA', 'NURLANOVA', '1007', '" . bcrypt('1401.05005') . "', 1, '" . generate_id() . "'),\n ('1401.05004', '*****@*****.**', 'ESENBEK', 'SAPAROV', '1007', '" . bcrypt('1401.05004') . "', 1, '" . generate_id() . "'),\n ('1401.05002', '*****@*****.**', 'ASEL', 'SABIRBEKOVA', '1007', '" . bcrypt('1401.05002') . "', 1, '" . generate_id() . "'),\n ('1401.05001', '*****@*****.**', 'AYTURGAN', 'MURATBEK KIZI', '1007', '" . bcrypt('1401.05001') . "', 1, '" . generate_id() . "'),\n ('1301.05027', '*****@*****.**', 'NAVRUZ', 'BAYMATOV', '1007', '" . bcrypt('1301.05027') . "', 1, '" . generate_id() . "'),\n ('1301.05024', '*****@*****.**', 'YUSUF', 'TOĞU', '1007', '" . bcrypt('1301.05024') . "', 1, '" . generate_id() . "'),\n ('1301.05022', '*****@*****.**', 'İBRAHİM', 'EMRE BODUR', '1007', '" . bcrypt('1301.05022') . "', 1, '" . generate_id() . "'),\n ('1301.05021', '*****@*****.**', 'EMRAH', 'GENÇ', '1007', '" . bcrypt('1301.05021') . "', 1, '" . generate_id() . "'),\n ('1301.05018', '*****@*****.**', 'RUKİYE', 'ÖZDEN', '1007', '" . bcrypt('1301.05018') . "', 1, '" . generate_id() . "'),\n ('1301.05010', '*****@*****.**', 'KANIKEY', 'MURATBEKOVA', '1007', '" . bcrypt('1301.05010') . "', 1, '" . generate_id() . "'),\n ('1301.05005', '*****@*****.**', 'MAYRAMKAN', 'ABDİSALAMOVA', '1007', '" . bcrypt('1301.05005') . "', 1, '" . generate_id() . "'),\n ('1201.05007', '*****@*****.**', 'SALAMAT', 'OMERKULOVA', '1007', '" . bcrypt('1201.05007') . "', 1, '" . generate_id() . "'),\n ('1501.03015', '*****@*****.**', 'BEGAYIM', 'SAGINBEK KIZI', '1006', '" . bcrypt('1501.03015') . "', 1, '" . generate_id() . "'),\n ('1501.03014', '*****@*****.**', 'KIMBAT', 'İMANBEKOVA', '1006', '" . bcrypt('1501.03014') . "', 1, '" . generate_id() . "'),\n ('1501.03013', '*****@*****.**', 'MADİNA', 'OSMONOVA', '1006', '" . bcrypt('1501.03013') . "', 1, '" . generate_id() . "'),\n ('1501.03012', '*****@*****.**', 'ALTINAY', 'ALMASBEKOVA', '1006', '" . bcrypt('1501.03012') . "', 1, '" . generate_id() . "'),\n ('1501.03003', '*****@*****.**', 'AYNURA', 'MELİSOVA', '1006', '" . bcrypt('1501.03003') . "', 1, '" . generate_id() . "'),\n ('1501.03002', '*****@*****.**', 'TAALAYKÜL', 'ATAEVA', '1006', '" . bcrypt('1501.03002') . "', 1, '" . generate_id() . "'),\n ('1401.03019', '*****@*****.**', 'ZEKİ', 'DUĞAN', '1006', '" . bcrypt('1401.03019') . "', 1, '" . generate_id() . "'),\n ('1401.03018', '*****@*****.**', 'ALİ', 'KENGER', '1006', '" . bcrypt('1401.03018') . "', 1, '" . generate_id() . "'),\n ('1401.03017', '*****@*****.**', 'DAMLA', 'GÜLŞAH GÜRE', '1006', '" . bcrypt('1401.03017') . "', 1, '" . generate_id() . "'),\n ('1401.03015', '*****@*****.**', 'BİCAN', 'NAZIM İRTEM', '1006', '" . bcrypt('1401.03015') . "', 1, '" . generate_id() . "'),\n ('1401.03012', '*****@*****.**', 'SÜLEYMAN', 'ULU', '1006', '" . bcrypt('1401.03012') . "', 1, '" . generate_id() . "'),\n ('1401.03011', '*****@*****.**', 'SALİM', 'ER', '1006', '" . bcrypt('1401.03011') . "', 1, '" . generate_id() . "'),\n ('1401.03009', '*****@*****.**', 'AYZADA', 'SUBANBEKOVA', '1006', '" . bcrypt('1401.03009') . "', 1, '" . generate_id() . "'),\n ('1401.03008', '*****@*****.**', 'NURCAMAL', 'TURGUNBAY KIZI', '1006', '" . bcrypt('1401.03008') . "', 1, '" . generate_id() . "'),\n ('1401.03007', '*****@*****.**', 'BEGİMAY', 'SUBAGOCOEVA', '1006', '" . bcrypt('1401.03007') . "', 1, '" . generate_id() . "'),\n ('1401.03005', '*****@*****.**', 'ŞAYIRGUL', 'GAPAROVA', '1006', '" . bcrypt('1401.03005') . "', 1, '" . generate_id() . "'),\n ('1401.03004', '*****@*****.**', 'AİDA', 'ABDIGAPAR KIZI', '1006', '" . bcrypt('1401.03004') . "', 1, '" . generate_id() . "'),\n ('1401.03003', '*****@*****.**', 'NARGİZA', 'KALMURZA KIZI', '1006', '" . bcrypt('1401.03003') . "', 1, '" . generate_id() . "'),\n ('1401.03002', '*****@*****.**', 'AKMARAL', 'ERMAMATOVA', '1006', '" . bcrypt('1401.03002') . "', 1, '" . generate_id() . "'),\n ('1401.03001', '*****@*****.**', 'ŞAHNOZA', 'SIDIKOVA', '1006', '" . bcrypt('1401.03001') . "', 1, '" . generate_id() . "'),\n ('1301.03027', '*****@*****.**', 'BİBİSORA', 'MAMATOVA', '1006', '" . bcrypt('1301.03027') . "', 1, '" . generate_id() . "'),\n ('1301.03013', '*****@*****.**', 'NURBEK', 'KARASARTOV', '1006', '" . bcrypt('1301.03013') . "', 1, '" . generate_id() . "'),\n ('1301.03007', '*****@*****.**', 'AYCOLBEK', 'USENKAN UULU', '1006', '" . bcrypt('1301.03007') . "', 1, '" . generate_id() . "'),\n ('1301.03005', '*****@*****.**', 'GULNAZ', 'ESENGULOVA', '1006', '" . bcrypt('1301.03005') . "', 1, '" . generate_id() . "'),\n ('1201.03011', '*****@*****.**', 'ROZA', 'MOLDOŞBAY KIZI', '1006', '" . bcrypt('1201.03011') . "', 1, '" . generate_id() . "'),\n ('1201.03008', '*****@*****.**', 'AİDA', 'BEKMURAT KIZI', '1006', '" . bcrypt('1201.03008') . "', 1, '" . generate_id() . "'),\n ('1101.03010', '*****@*****.**', 'ÇİNGİZ', 'MAMATOV', '1006', '" . bcrypt('1101.03010') . "', 1, '" . generate_id() . "'),\n ('1501.07005', '*****@*****.**', 'NURSULTAN', 'MUKAŞEV', '1003', '" . bcrypt('1501.07005') . "', 1, '" . generate_id() . "'),\n ('1401.07018', '*****@*****.**', 'AYZAADA', 'BÖRUKULOVA', '1003', '" . bcrypt('1401.07018') . "', 1, '" . generate_id() . "'),\n ('1401.07015', '*****@*****.**', 'ULUKBEK', 'HALBOTOEV', '1003', '" . bcrypt('1401.07015') . "', 1, '" . generate_id() . "'),\n ('1401.07014', '*****@*****.**', 'MEERİM', 'KARIBAEVA', '1003', '" . bcrypt('1401.07014') . "', 1, '" . generate_id() . "'),\n ('1401.07013', '*****@*****.**', 'BAYYAN', 'MUKANBETKERIMOVA', '1003', '" . bcrypt('1401.07013') . "', 1, '" . generate_id() . "'),\n ('1401.07012', '*****@*****.**', 'AYCAN', 'ABDIŞOVA', '1003', '" . bcrypt('1401.07012') . "', 1, '" . generate_id() . "'),\n ('1401.07011', '*****@*****.**', 'BEGİMAY', 'ABDIBEKOVA', '1003', '" . bcrypt('1401.07011') . "', 1, '" . generate_id() . "'),\n ('1401.07010', '*****@*****.**', 'MAHABAT', 'ESTEBESOVA', '1003', '" . bcrypt('1401.07010') . "', 1, '" . generate_id() . "'),\n ('1401.07009', '*****@*****.**', 'ALMANBET', 'SULAYMANOV', '1003', '" . bcrypt('1401.07009') . "', 1, '" . generate_id() . "'),\n ('1401.07008', '*****@*****.**', 'ADİNA', 'OLCOBAEVA', '1003', '" . bcrypt('1401.07008') . "', 1, '" . generate_id() . "'),\n ('1401.07007', '*****@*****.**', 'CILDIZBEK', 'ABİBAKIR UULU', '1003', '" . bcrypt('1401.07007') . "', 1, '" . generate_id() . "'),\n ('1401.07003', '*****@*****.**', 'SEZİM', 'CUMAGULOVA', '1003', '" . bcrypt('1401.07003') . "', 1, '" . generate_id() . "'),\n ('1401.07001', '*****@*****.**', 'AKSANA', 'ABDURASULOVA', '1003', '" . bcrypt('1401.07001') . "', 1, '" . generate_id() . "'),\n ('1301.07020', '*****@*****.**', 'AYCAMAL', 'URALBEKOVA', '1003', '" . bcrypt('1301.07020') . "', 1, '" . generate_id() . "'),\n ('1301.07019', '*****@*****.**', 'ANARA', 'KARİMOVA', '1003', '" . bcrypt('1301.07019') . "', 1, '" . generate_id() . "'),\n ('1301.07018', '*****@*****.**', 'ELİZA', 'ABSAMAT KIZI', '1003', '" . bcrypt('1301.07018') . "', 1, '" . generate_id() . "'),\n ('1301.07014', '*****@*****.**', 'MAYRAMKUL', 'SAPARBEKOVA', '1003', '" . bcrypt('1301.07014') . "', 1, '" . generate_id() . "'),\n ('1301.07009', '*****@*****.**', 'CALİL', 'BARIKTABASOV', '1003', '" . bcrypt('1301.07009') . "', 1, '" . generate_id() . "'),\n ('1301.07007', '*****@*****.**', 'DİNARA', 'BOLOTBEK KIZI', '1003', '" . bcrypt('1301.07007') . "', 1, '" . generate_id() . "'),\n ('1301.07003', '*****@*****.**', 'AKILAY', 'KASIMALI KIZI', '1003', '" . bcrypt('1301.07003') . "', 1, '" . generate_id() . "'),\n ('1501.08018', '*****@*****.**', 'AYGERİM', 'CUMABAEVA', '1005', '" . bcrypt('1501.08018') . "', 1, '" . generate_id() . "'),\n ('1501.08017', '*****@*****.**', 'AYTURGAN', 'ANARALI KIZI', '1005', '" . bcrypt('1501.08017') . "', 1, '" . generate_id() . "'),\n ('1501.08009', '*****@*****.**', 'AYDANA', 'MADIŞOVA', '1005', '" . bcrypt('1501.08009') . "', 1, '" . generate_id() . "'),\n ('1501.08006', '*****@*****.**', 'DİNARA', 'ŞAKİROVA', '1005', '" . bcrypt('1501.08006') . "', 1, '" . generate_id() . "'),\n ('1501.08005', '*****@*****.**', 'AYNEK', 'MURATBEKOVA', '1005', '" . bcrypt('1501.08005') . "', 1, '" . generate_id() . "'),\n ('1501.08004', '*****@*****.**', 'AYDAY', 'KIDIŞOVA', '1005', '" . bcrypt('1501.08004') . "', 1, '" . generate_id() . "'),\n ('1501.08003', '*****@*****.**', 'ŞİRİN', 'MAMITBEK KIZI', '1005', '" . bcrypt('1501.08003') . "', 1, '" . generate_id() . "'),\n ('1401.08020', '*****@*****.**', 'KİBOR', 'SOLMONOV', '1005', '" . bcrypt('1401.08020') . "', 1, '" . generate_id() . "'),\n ('1401.08019', '*****@*****.**', 'MAHMUT', 'ALKAN', '1005', '" . bcrypt('1401.08019') . "', 1, '" . generate_id() . "'),\n ('1401.08018', '*****@*****.**', 'ESMANUR', 'AKMAN', '1005', '" . bcrypt('1401.08018') . "', 1, '" . generate_id() . "'),\n ('1401.08017', '*****@*****.**', 'MUHAMMET', 'DENİZ TOPRAK', '1005', '" . bcrypt('1401.08017') . "', 1, '" . generate_id() . "'),\n ('1401.08016', '*****@*****.**', 'ATAKAN', 'ARSLAN', '1005', '" . bcrypt('1401.08016') . "', 1, '" . generate_id() . "'),\n ('1401.08015', '*****@*****.**', 'BAZARGUL', 'CALİLOVA', '1005', '" . bcrypt('1401.08015') . "', 1, '" . generate_id() . "'),\n ('1401.08013', '*****@*****.**', 'NURSULTAN', 'DANİYAR UULU', '1005', '" . bcrypt('1401.08013') . "', 1, '" . generate_id() . "'),\n ('1401.08009', '*****@*****.**', 'AİDA', 'SARKULOVA', '1005', '" . bcrypt('1401.08009') . "', 1, '" . generate_id() . "'),\n ('1401.08007', '*****@*****.**', 'ALİSA', 'AŞIRBAEVA', '1005', '" . bcrypt('1401.08007') . "', 1, '" . generate_id() . "'),\n ('1401.08004', '*****@*****.**', 'NURAYIM', 'ABDIRAKMANOVA', '1005', '" . bcrypt('1401.08004') . "', 1, '" . generate_id() . "'),\n ('1401.08003', '*****@*****.**', 'ASEL', 'MACANOVA', '1005', '" . bcrypt('1401.08003') . "', 1, '" . generate_id() . "'),\n ('1301.08020', '*****@*****.**', 'ONUR', 'GÜDEMEZ', '1005', '" . bcrypt('1301.08020') . "', 1, '" . generate_id() . "'),\n ('1301.08002', '*****@*****.**', 'BEGİMAY', 'UZENBEKOVA', '1005', '" . bcrypt('1301.08002') . "', 1, '" . generate_id() . "'),\n ('1501.06019', '*****@*****.**', 'CİBEK', 'ALİEVA', '1004', '" . bcrypt('1501.06019') . "', 1, '" . generate_id() . "'),\n ('1501.06016', '*****@*****.**', 'TOKTOMAMBET', 'CUMANALI UULU', '1004', '" . bcrypt('1501.06016') . "', 1, '" . generate_id() . "'),\n ('1501.06006', '*****@*****.**', 'DİNARA', 'ESANBEKOVA', '1004', '" . bcrypt('1501.06006') . "', 1, '" . generate_id() . "'),\n ('1501.06005', '*****@*****.**', 'NURKUL', 'KUDAYBERDİEV', '1004', '" . bcrypt('1501.06005') . "', 1, '" . generate_id() . "'),\n ('1501.06003', '*****@*****.**', 'GULSARA', 'MANASOVA', '1004', '" . bcrypt('1501.06003') . "', 1, '" . generate_id() . "'),\n ('1401.06024', '*****@*****.**', 'BABAKHAN', 'KHATSHYBAI', '1004', '" . bcrypt('1401.06024') . "', 1, '" . generate_id() . "'),\n ('1401.06023', '*****@*****.**', 'HALİL', 'AY', '1004', '" . bcrypt('1401.06023') . "', 1, '" . generate_id() . "'),\n ('1401.06022', '*****@*****.**', 'ABDULLAH', 'ÇELİK', '1004', '" . bcrypt('1401.06022') . "', 1, '" . generate_id() . "'),\n ('1401.06021', '*****@*****.**', 'GÜZİN', 'AKGÜL', '1004', '" . bcrypt('1401.06021') . "', 1, '" . generate_id() . "'),\n ('1401.06015', '*****@*****.**', 'TAHMİNA', 'ERMAMATOVA', '1004', '" . bcrypt('1401.06015') . "', 1, '" . generate_id() . "'),\n ('1401.06014', '*****@*****.**', 'NOORUZ', 'AKILBEKOVA', '1004', '" . bcrypt('1401.06014') . "', 1, '" . generate_id() . "'),\n ('1401.06013', '*****@*****.**', 'ELNURA', 'OSMONBEKOVA', '1004', '" . bcrypt('1401.06013') . "', 1, '" . generate_id() . "'),\n ('1401.06012', '*****@*****.**', 'ACAR', 'AYBEKOVA', '1004', '" . bcrypt('1401.06012') . "', 1, '" . generate_id() . "'),\n ('1401.06010', '*****@*****.**', 'ALİYA', 'MELSBEKOVA', '1004', '" . bcrypt('1401.06010') . "', 1, '" . generate_id() . "'),\n ('1401.06009', '*****@*****.**', 'AYPERİ', 'İSKENDEROVA', '1004', '" . bcrypt('1401.06009') . "', 1, '" . generate_id() . "'),\n ('1401.06007', '*****@*****.**', 'KANIKEY', 'ABDIRAHMANOVA', '1004', '" . bcrypt('1401.06007') . "', 1, '" . generate_id() . "'),\n ('1401.06006', '*****@*****.**', 'ALİNA', 'CIRGALBEKOVA', '1004', '" . bcrypt('1401.06006') . "', 1, '" . generate_id() . "'),\n ('1401.06005', '*****@*****.**', 'ZİYADAT', 'KUBANDIKOVA', '1004', '" . bcrypt('1401.06005') . "', 1, '" . generate_id() . "'),\n ('1401.06004', '*****@*****.**', 'CANERKE', 'ELMİR KIZI', '1004', '" . bcrypt('1401.06004') . "', 1, '" . generate_id() . "'),\n ('1401.06003', '*****@*****.**', 'BEYŞEGÜL', 'ALTIMIŞOVA', '1004', '" . bcrypt('1401.06003') . "', 1, '" . generate_id() . "'),\n ('1401.06002', '*****@*****.**', 'GULCAN', 'KURMANBEKOVA', '1004', '" . bcrypt('1401.06002') . "', 1, '" . generate_id() . "'),\n ('1401.06001', '*****@*****.**', 'BEGİMAY', 'ASANOVA', '1004', '" . bcrypt('1401.06001') . "', 1, '" . generate_id() . "'),\n ('1301.06023', '*****@*****.**', 'KAAN', 'SOYAK', '1004', '" . bcrypt('1301.06023') . "', 1, '" . generate_id() . "'),\n ('1501.01023', '*****@*****.**', 'MEYKİMBEK', 'ABDİBASİ UULU', '1001', '" . bcrypt('1501.01023') . "', 1, '" . generate_id() . "'),\n ('1501.01021', '*****@*****.**', 'SÜNÖTTİLA', 'NASRİDİN UULU', '1001', '" . bcrypt('1501.01021') . "', 1, '" . generate_id() . "'),\n ('1501.01013', '*****@*****.**', 'İSA', 'ALMASBEK UULU', '1001', '" . bcrypt('1501.01013') . "', 1, '" . generate_id() . "'),\n ('1501.01005', '*****@*****.**', 'İLGİZ', 'SULTANOV', '1001', '" . bcrypt('1501.01005') . "', 1, '" . generate_id() . "'),\n ('1401.01026', '*****@*****.**', 'ARİF', 'KAHRAMAN', '1001', '" . bcrypt('1401.01026') . "', 1, '" . generate_id() . "'),\n ('1401.01024', '*****@*****.**', 'BERKAY', 'HALİM DUMAN', '1001', '" . bcrypt('1401.01024') . "', 1, '" . generate_id() . "'),\n ('1401.01023', '*****@*****.**', 'MUHAMMED', 'İBRAHİM AKIL', '1001', '" . bcrypt('1401.01023') . "', 1, '" . generate_id() . "'),\n ('1401.01022', '*****@*****.**', 'AYZADA', 'CUNUSOVA', '1001', '" . bcrypt('1401.01022') . "', 1, '" . generate_id() . "'),\n ('1401.01020', '*****@*****.**', 'AKÇOLPON', 'TOYÇUEVA', '1001', '" . bcrypt('1401.01020') . "', 1, '" . generate_id() . "'),\n ('1401.01019', '*****@*****.**', 'AYZADA', 'TURGUNBAEVA', '1001', '" . bcrypt('1401.01019') . "', 1, '" . generate_id() . "'),\n ('1401.01017', '*****@*****.**', 'ALTINAY', 'OMURBEKOVA', '1001', '" . bcrypt('1401.01017') . "', 1, '" . generate_id() . "'),\n ('1401.01016', '*****@*****.**', 'NURZADA', 'ARAP KIZI', '1001', '" . bcrypt('1401.01016') . "', 1, '" . generate_id() . "'),\n ('1401.01015', '*****@*****.**', 'NARGİZA', 'TOKTOROVA', '1001', '" . bcrypt('1401.01015') . "', 1, '" . generate_id() . "'),\n ('1401.01014', '*****@*****.**', 'CARKINAY', 'IRISBEKOVA', '1001', '" . bcrypt('1401.01014') . "', 1, '" . generate_id() . "'),\n ('1401.01013', '*****@*****.**', 'ULANBEK', 'İKRAMOV', '1001', '" . bcrypt('1401.01013') . "', 1, '" . generate_id() . "'),\n ('1401.01011', '*****@*****.**', 'DAİRBEK', 'DARÇİBAEV', '1001', '" . bcrypt('1401.01011') . "', 1, '" . generate_id() . "'),\n ('1401.01010', '*****@*****.**', 'NURAYIM', 'BEKDAYIROVA', '1001', '" . bcrypt('1401.01010') . "', 1, '" . generate_id() . "'),\n ('1401.01009', '*****@*****.**', 'ALİZA', 'KURMANBEKOVA', '1001', '" . bcrypt('1401.01009') . "', 1, '" . generate_id() . "'),\n ('1401.01008', '*****@*****.**', 'SALIMBEK', 'CANIBEK UULU', '1001', '" . bcrypt('1401.01008') . "', 1, '" . generate_id() . "'),\n ('1401.01006', '*****@*****.**', 'AYCARKIN', 'ASANALIEVA', '1001', '" . bcrypt('1401.01006') . "', 1, '" . generate_id() . "'),\n ('1401.01005', '*****@*****.**', 'MIRZAYIM', 'SULAYMANOVA', '1001', '" . bcrypt('1401.01005') . "', 1, '" . generate_id() . "'),\n ('1401.01004', '*****@*****.**', 'BAYTUR', 'TOKTOSUNOV', '1001', '" . bcrypt('1401.01004') . "', 1, '" . generate_id() . "'),\n ('1401.01001', '*****@*****.**', 'ALİNA', 'TEMİRBEKOVA', '1001', '" . bcrypt('1401.01001') . "', 1, '" . generate_id() . "'),\n ('1301.01023', '*****@*****.**', 'AYCAMAL', 'ALMAZ KIZI', '1001', '" . bcrypt('1301.01023') . "', 1, '" . generate_id() . "'),\n ('1213.01007', '*****@*****.**', 'AYNAZİK', 'AZİZBEK KIZI', '1001', '" . bcrypt('1213.01007') . "', 1, '" . generate_id() . "'),\n ('1201.01021', '*****@*****.**', 'BİLGEKAĞAN', 'YILMAZ', '1001', '" . bcrypt('1201.01021') . "', 1, '" . generate_id() . "'),\n ('1101.01012', '*****@*****.**', 'ELDİYAR', 'TURUSBEK UULU', '1001', '" . bcrypt('1101.01012') . "', 1, '" . generate_id() . "'),\n ('1501.02030', '*****@*****.**', 'AYZADA', 'NURBEK KIZI', '1002', '" . bcrypt('1501.02030') . "', 1, '" . generate_id() . "'),\n ('1501.02029', '*****@*****.**', 'HANZADA', 'NURKAMİL', '1002', '" . bcrypt('1501.02029') . "', 1, '" . generate_id() . "'),\n ('1501.02026', '*****@*****.**', 'AZİZA', 'KERİMBEKOVA', '1002', '" . bcrypt('1501.02026') . "', 1, '" . generate_id() . "'),\n ('1501.02025', '*****@*****.**', 'NURAY', 'ŞARABİDİN KIZI', '1002', '" . bcrypt('1501.02025') . "', 1, '" . generate_id() . "'),\n ('1501.02024', '*****@*****.**', 'SALTANAT', 'MATAEVA', '1002', '" . bcrypt('1501.02024') . "', 1, '" . generate_id() . "'),\n ('1501.02012', '*****@*****.**', 'ABİL', 'NASİREDİN UULU', '1002', '" . bcrypt('1501.02012') . "', 1, '" . generate_id() . "'),\n ('1501.02004', '*****@*****.**', 'İNDİRA', 'AMANKOCOEVA', '1002', '" . bcrypt('1501.02004') . "', 1, '" . generate_id() . "'),\n ('1401.02041', '*****@*****.**', 'MÜCAHİT', 'ÇINAR', '1002', '" . bcrypt('1401.02041') . "', 1, '" . generate_id() . "'),\n ('1401.02039', '*****@*****.**', 'EMİNE', 'KORKMAZ', '1002', '" . bcrypt('1401.02039') . "', 1, '" . generate_id() . "'),\n ('1401.02038', '*****@*****.**', 'MÜBECCEL', 'SOLAK', '1002', '" . bcrypt('1401.02038') . "', 1, '" . generate_id() . "'),\n ('1401.02037', '*****@*****.**', 'GÖZDE', 'TOPAK', '1002', '" . bcrypt('1401.02037') . "', 1, '" . generate_id() . "'),\n ('1401.02034', '*****@*****.**', 'MUHAMMED', 'MUSTAFA BAKIR', '1002', '" . bcrypt('1401.02034') . "', 1, '" . generate_id() . "'),\n ('1401.02032', '*****@*****.**', 'İSLAM', 'ASANBAEV', '1002', '" . bcrypt('1401.02032') . "', 1, '" . generate_id() . "'),\n ('1401.02031', '*****@*****.**', 'AYDAY', 'ZAMİRBEK KIZI', '1002', '" . bcrypt('1401.02031') . "', 1, '" . generate_id() . "'),\n ('1401.02030', '*****@*****.**', 'AYZİREK', 'KALMANBETOVA', '1002', '" . bcrypt('1401.02030') . "', 1, '" . generate_id() . "'),\n ('1401.02029', '*****@*****.**', 'CANAR', 'MİRLAN KIZI', '1002', '" . bcrypt('1401.02029') . "', 1, '" . generate_id() . "'),\n ('1401.02028', '*****@*****.**', 'DAMİRA', 'SIDIKBEK KIZI', '1002', '" . bcrypt('1401.02028') . "', 1, '" . generate_id() . "'),\n ('1401.02027', '*****@*****.**', 'AYZA', 'ALİEVA', '1002', '" . bcrypt('1401.02027') . "', 1, '" . generate_id() . "'),\n ('1401.02023', '*****@*****.**', 'TOLGONAY', 'RISKULOVA', '1002', '" . bcrypt('1401.02023') . "', 1, '" . generate_id() . "'),\n ('1401.02020', '*****@*****.**', 'BERMET', 'ASKAR KIZI', '1002', '" . bcrypt('1401.02020') . "', 1, '" . generate_id() . "'),\n ('1401.02019', '*****@*****.**', 'CAYNA', 'ÇINIBEKOVA', '1002', '" . bcrypt('1401.02019') . "', 1, '" . generate_id() . "'),\n ('1401.02015', '*****@*****.**', 'AİDA', 'KILIÇBEK KIZI', '1002', '" . bcrypt('1401.02015') . "', 1, '" . generate_id() . "'),\n ('1401.02014', '*****@*****.**', 'CEENGUL', 'KAPAROVA', '1002', '" . bcrypt('1401.02014') . "', 1, '" . generate_id() . "'),\n ('1401.02013', '*****@*****.**', 'ALİZAT', 'İDİRİS KIZI', '1002', '" . bcrypt('1401.02013') . "', 1, '" . generate_id() . "'),\n ('1401.02010', '*****@*****.**', 'BEKBOLOT', 'SARIBAEV', '1002', '" . bcrypt('1401.02010') . "', 1, '" . generate_id() . "'),\n ('1401.02008', '*****@*****.**', 'CANIL', 'ABDIKADIROVA', '1002', '" . bcrypt('1401.02008') . "', 1, '" . generate_id() . "'),\n ('1401.02007', '*****@*****.**', 'GULAYIM', 'ABDIKERİM KIZI', '1002', '" . bcrypt('1401.02007') . "', 1, '" . generate_id() . "'),\n ('1401.02006', '*****@*****.**', 'AYZADA', 'GAYBILDAEVA', '1002', '" . bcrypt('1401.02006') . "', 1, '" . generate_id() . "'),\n ('1401.02005', '*****@*****.**', 'NURAYIM', 'SAYTAHMATOVA', '1002', '" . bcrypt('1401.02005') . "', 1, '" . generate_id() . "'),\n ('1401.02003', '*****@*****.**', 'AYNURA', 'SARBATOVA', '1002', '" . bcrypt('1401.02003') . "', 1, '" . generate_id() . "'),\n ('1401.02002', '*****@*****.**', 'TAHMİNA', 'DAMİRBEKOVA', '1002', '" . bcrypt('1401.02002') . "', 1, '" . generate_id() . "'),\n ('1301.02055', '*****@*****.**', 'TUĞBA', 'ÇALIŞKAN', '1002', '" . bcrypt('1301.02055') . "', 1, '" . generate_id() . "'),\n ('1301.02035', '*****@*****.**', 'MEHMET', 'KURTKAAN UZUN', '1002', '" . bcrypt('1301.02035') . "', 1, '" . generate_id() . "'),\n ('1301.02015', '*****@*****.**', 'KUMUSAY', 'KANIBEKOVA', '1002', '" . bcrypt('1301.02015') . "', 1, '" . generate_id() . "'),\n ('1301.02004', '*****@*****.**', 'ALTINAY', 'MADAKEEVA', '1002', '" . bcrypt('1301.02004') . "', 1, '" . generate_id() . "'),\n ('1504.01037', '*****@*****.**', 'AZAMAT', 'ZINTEMİROV', '7001', '" . bcrypt('1504.01037') . "', 1, '" . generate_id() . "'),\n ('1504.01036', '*****@*****.**', 'RAİMBEK', 'MUHTAROV', '7001', '" . bcrypt('1504.01036') . "', 1, '" . generate_id() . "'),\n ('1504.01035', '*****@*****.**', 'ULAN', 'MAMIRALİEV', '7001', '" . bcrypt('1504.01035') . "', 1, '" . generate_id() . "'),\n ('1504.01032', '*****@*****.**', 'NURBEK', 'ABDULAHATOV', '7001', '" . bcrypt('1504.01032') . "', 1, '" . generate_id() . "'),\n ('1504.01031', '*****@*****.**', 'BEKNAZAR', 'ALIBAEV', '7001', '" . bcrypt('1504.01031') . "', 1, '" . generate_id() . "'),\n ('1504.01025', '*****@*****.**', 'ULAN', 'CENIŞBEK UULU', '7001', '" . bcrypt('1504.01025') . "', 1, '" . generate_id() . "'),\n ('1504.01023', '*****@*****.**', 'AKILBEK', 'KARAGULOV', '7001', '" . bcrypt('1504.01023') . "', 1, '" . generate_id() . "'),\n ('1504.01021', '*****@*****.**', 'TANSULUU', 'ADIBAEVA', '7001', '" . bcrypt('1504.01021') . "', 1, '" . generate_id() . "'),\n ('1504.01020', '*****@*****.**', 'ELBAKIT', 'OROZBEKOV', '7001', '" . bcrypt('1504.01020') . "', 1, '" . generate_id() . "'),\n ('1504.01019', '*****@*****.**', 'SAGINDIK', 'AKCOLOV', '7001', '" . bcrypt('1504.01019') . "', 1, '" . generate_id() . "'),\n ('1504.01016', '*****@*****.**', 'BEKTUR', 'AYTBAEV', '7001', '" . bcrypt('1504.01016') . "', 1, '" . generate_id() . "'),\n ('1504.01007', '*****@*****.**', 'NURSULTAN', 'KURBANBEKOV', '7001', '" . bcrypt('1504.01007') . "', 1, '" . generate_id() . "'),\n ('1504.01005', '*****@*****.**', 'BEKSULTAN', 'OMURZAKOV', '7001', '" . bcrypt('1504.01005') . "', 1, '" . generate_id() . "'),\n ('1504.01003', '*****@*****.**', 'TAALAYBEK', 'CEENBEKOV', '7001', '" . bcrypt('1504.01003') . "', 1, '" . generate_id() . "'),\n ('1504.01002', '*****@*****.**', 'TOLOGON', 'KUDAYBERDİ UULU', '7001', '" . bcrypt('1504.01002') . "', 1, '" . generate_id() . "'),\n ('1404.01048', '*****@*****.**', 'ZAVKİDİN', 'AHMEDOV', '7001', '" . bcrypt('1404.01048') . "', 1, '" . generate_id() . "'),\n ('1404.01047', '*****@*****.**', 'SALVAR', 'BAKRADZE', '7001', '" . bcrypt('1404.01047') . "', 1, '" . generate_id() . "'),\n ('1404.01046', '*****@*****.**', 'AB.MAJED', 'NORGELDI', '7001', '" . bcrypt('1404.01046') . "', 1, '" . generate_id() . "'),\n ('1404.01045', '*****@*****.**', 'NOORAN', 'SHAH AMIRSHAH', '7001', '" . bcrypt('1404.01045') . "', 1, '" . generate_id() . "'),\n ('1404.01043', '*****@*****.**', 'MUSTAFA', 'ALP ÇETİN', '7001', '" . bcrypt('1404.01043') . "', 1, '" . generate_id() . "'),\n ('1404.01042', '*****@*****.**', 'HÜSEYİN', 'İLBAY', '7001', '" . bcrypt('1404.01042') . "', 1, '" . generate_id() . "'),\n ('1404.01041', '*****@*****.**', 'ATAY', 'SULTANGAZİEV', '7001', '" . bcrypt('1404.01041') . "', 1, '" . generate_id() . "'),\n ('1404.01039', '*****@*****.**', 'AYCAN', 'MURATBEK KIZI', '7001', '" . bcrypt('1404.01039') . "', 1, '" . generate_id() . "'),\n ('1404.01038', '*****@*****.**', 'APAS', 'ASANBEKOV', '7001', '" . bcrypt('1404.01038') . "', 1, '" . generate_id() . "'),\n ('1404.01037', '*****@*****.**', 'RUSLAN', 'BOSTONBAEV', '7001', '" . bcrypt('1404.01037') . "', 1, '" . generate_id() . "'),\n ('1404.01034', '*****@*****.**', 'BEGİMAY', 'ASANBEKOVA', '7001', '" . bcrypt('1404.01034') . "', 1, '" . generate_id() . "'),\n ('1404.01031', '*****@*****.**', 'BEKTUR', 'MURATOV', '7001', '" . bcrypt('1404.01031') . "', 1, '" . generate_id() . "'),\n ('1404.01030', '*****@*****.**', 'İSKANDER', 'KOPBAEV', '7001', '" . bcrypt('1404.01030') . "', 1, '" . generate_id() . "'),\n ('1404.01029', '*****@*****.**', 'ULAN', 'ERKİNBEK UULU', '7001', '" . bcrypt('1404.01029') . "', 1, '" . generate_id() . "'),\n ('1404.01024', '*****@*****.**', 'TİLEK', 'TEKİNOV', '7001', '" . bcrypt('1404.01024') . "', 1, '" . generate_id() . "'),\n ('1404.01022', '*****@*****.**', 'AKILAY', 'OSONOVA', '7001', '" . bcrypt('1404.01022') . "', 1, '" . generate_id() . "'),\n ('1404.01019', '*****@*****.**', 'TALGAT', 'ASANBAEV', '7001', '" . bcrypt('1404.01019') . "', 1, '" . generate_id() . "'),\n ('1404.01017', '*****@*****.**', 'DİNMUHAMED', 'ŞAKİRBEKOV', '7001', '" . bcrypt('1404.01017') . "', 1, '" . generate_id() . "'),\n ('1404.01016', '*****@*****.**', 'KILIÇ', 'ASANKULOV', '7001', '" . bcrypt('1404.01016') . "', 1, '" . generate_id() . "'),\n ('1404.01015', '*****@*****.**', 'DANİEL', 'KURMANALIEV', '7001', '" . bcrypt('1404.01015') . "', 1, '" . generate_id() . "'),\n ('1404.01014', '*****@*****.**', 'ARLEN', 'NURLANBEKOV', '7001', '" . bcrypt('1404.01014') . "', 1, '" . generate_id() . "'),\n ('1404.01013', '*****@*****.**', 'IRISKÜL', 'SAPARALİEVA', '7001', '" . bcrypt('1404.01013') . "', 1, '" . generate_id() . "'),\n ('1404.01011', '*****@*****.**', 'TOYÇUBEK', 'SULTANGAZİEV', '7001', '" . bcrypt('1404.01011') . "', 1, '" . generate_id() . "'),\n ('1404.01009', '*****@*****.**', 'NURMİLA', 'CETİMİŞOVA', '7001', '" . bcrypt('1404.01009') . "', 1, '" . generate_id() . "'),\n ('1404.01005', '*****@*****.**', 'ASEL', 'KURMANALİEVA', '7001', '" . bcrypt('1404.01005') . "', 1, '" . generate_id() . "'),\n ('1404.01004', '*****@*****.**', 'KANİET', 'KASIMBEKOV', '7001', '" . bcrypt('1404.01004') . "', 1, '" . generate_id() . "'),\n ('1404.01002', '*****@*****.**', 'OMUR', 'KUBANIÇBEKOV', '7001', '" . bcrypt('1404.01002') . "', 1, '" . generate_id() . "'),\n ('1404.01001', '*****@*****.**', 'ORHAN', 'ALİEV', '7001', '" . bcrypt('1404.01001') . "', 1, '" . generate_id() . "'),\n ('1304.01038', '*****@*****.**', 'BOYOMON', 'GOPPOROV', '7001', '" . bcrypt('1304.01038') . "', 1, '" . generate_id() . "'),\n ('1304.01035', '*****@*****.**', 'VELİ', 'MECİT ÇETİNKAYA', '7001', '" . bcrypt('1304.01035') . "', 1, '" . generate_id() . "'),\n ('1304.01022', '*****@*****.**', 'TOBOKEL', 'KEREZOV', '7001', '" . bcrypt('1304.01022') . "', 1, '" . generate_id() . "'),\n ('1304.01009', '*****@*****.**', 'MİRLAN', 'HAŞİMOV', '7001', '" . bcrypt('1304.01009') . "', 1, '" . generate_id() . "'),\n ('1304.01007', '*****@*****.**', 'TEMİRLAN', 'TALAPKEROV', '7001', '" . bcrypt('1304.01007') . "', 1, '" . generate_id() . "'),\n ('1204.01029', '*****@*****.**', 'NURAYIM', 'ERKİNBEKOVA', '7001', '" . bcrypt('1204.01029') . "', 1, '" . generate_id() . "'),\n ('1204.01025', '*****@*****.**', 'TİMUR', 'DİLDAEV', '7001', '" . bcrypt('1204.01025') . "', 1, '" . generate_id() . "'),\n ('1204.01015', '*****@*****.**', 'TİMUR', 'ALÇİBEKOV', '7001', '" . bcrypt('1204.01015') . "', 1, '" . generate_id() . "'),\n ('1501.10009', '*****@*****.**', 'NURCAN', 'TOLUKOVA', '1009', '" . bcrypt('1501.10009') . "', 1, '" . generate_id() . "'),\n ('1501.10004', '*****@*****.**', 'BEKMIRZA', 'CAMANGULOV', '1009', '" . bcrypt('1501.10004') . "', 1, '" . generate_id() . "'),\n ('1401.10028', '*****@*****.**', 'MEERİM', 'KAMÇIBEKOVA', '1009', '" . bcrypt('1401.10028') . "', 1, '" . generate_id() . "'),\n ('1401.10027', '*****@*****.**', 'AYCAN', 'OSMONOVA', '1009', '" . bcrypt('1401.10027') . "', 1, '" . generate_id() . "'),\n ('1401.10026', '*****@*****.**', 'ALİNA', 'BOZGUNÇİEVA', '1009', '" . bcrypt('1401.10026') . "', 1, '" . generate_id() . "'),\n ('1401.10025', '*****@*****.**', 'AYZAADA', 'AŞUUBAEVA', '1009', '" . bcrypt('1401.10025') . "', 1, '" . generate_id() . "'),\n ('1401.10023', '*****@*****.**', 'TOLGONAY', 'AKİMOVA', '1009', '" . bcrypt('1401.10023') . "', 1, '" . generate_id() . "'),\n ('1401.10020', '*****@*****.**', 'NARGİZA', 'NURLAN KIZI', '1009', '" . bcrypt('1401.10020') . "', 1, '" . generate_id() . "'),\n ('1401.10019', '*****@*****.**', 'MAYRAMKAN', 'COLON KIZI', '1009', '" . bcrypt('1401.10019') . "', 1, '" . generate_id() . "'),\n ('1401.10018', '*****@*****.**', 'GULMİRA', 'ALIMBEKOVA', '1009', '" . bcrypt('1401.10018') . "', 1, '" . generate_id() . "'),\n ('1401.10017', '*****@*****.**', 'MUNARA', 'AZİMBEKOVA', '1009', '" . bcrypt('1401.10017') . "', 1, '" . generate_id() . "'),\n ('1401.10016', '*****@*****.**', 'MAHABAT', 'AHMATOVA', '1009', '" . bcrypt('1401.10016') . "', 1, '" . generate_id() . "'),\n ('1401.10014', '*****@*****.**', 'BERMET', 'İSAEVA', '1009', '" . bcrypt('1401.10014') . "', 1, '" . generate_id() . "'),\n ('1401.10013', '*****@*****.**', 'MALİKE', 'ASILBEKOVA', '1009', '" . bcrypt('1401.10013') . "', 1, '" . generate_id() . "'),\n ('1401.10012', '*****@*****.**', 'NURKIZ', 'ABDİEVA', '1009', '" . bcrypt('1401.10012') . "', 1, '" . generate_id() . "'),\n ('1401.10009', '*****@*****.**', 'BEKMAMAT', 'TAALAYBEK UULU', '1009', '" . bcrypt('1401.10009') . "', 1, '" . generate_id() . "'),\n ('1401.10007', '*****@*****.**', 'AYPERİ', 'İLİYASOVA', '1009', '" . bcrypt('1401.10007') . "', 1, '" . generate_id() . "'),\n ('1401.10004', '*****@*****.**', 'SAMARA', 'AZİZBEK KIZI', '1009', '" . bcrypt('1401.10004') . "', 1, '" . generate_id() . "'),\n ('1401.10003', '*****@*****.**', 'AYNAGÜL', 'SARIBAEVA', '1009', '" . bcrypt('1401.10003') . "', 1, '" . generate_id() . "'),\n ('1401.10002', '*****@*****.**', 'ADİNAY', 'AKEEVA', '1009', '" . bcrypt('1401.10002') . "', 1, '" . generate_id() . "'),\n ('1401.10001', '*****@*****.**', 'NURZAT', 'NURLANOVA', '1009', '" . bcrypt('1401.10001') . "', 1, '" . generate_id() . "'),\n ('1301.10027', '*****@*****.**', 'AYPERİ', 'ZAKİROVA', '1009', '" . bcrypt('1301.10027') . "', 1, '" . generate_id() . "'),\n ('1301.10016', '*****@*****.**', 'ALİYA', 'SARIGULOVA', '1009', '" . bcrypt('1301.10016') . "', 1, '" . generate_id() . "'),\n ('1301.10013', '*****@*****.**', 'AYIMKAN', 'MIYMANALI KIZI', '1009', '" . bcrypt('1301.10013') . "', 1, '" . generate_id() . "'),\n ('1301.10006', '*****@*****.**', 'AVAZKAN', 'GALBAY KIZI', '1009', '" . bcrypt('1301.10006') . "', 1, '" . generate_id() . "'),\n ('1301.10003', '*****@*****.**', 'NURAYIM', 'KURBANOVA', '1009', '" . bcrypt('1301.10003') . "', 1, '" . generate_id() . "'),\n ('1501.09015', '*****@*****.**', 'ZARİPA', 'NURDİN KIZI', '1010', '" . bcrypt('1501.09015') . "', 1, '" . generate_id() . "'),\n ('1501.09014', '*****@*****.**', 'AYBEK', 'TURDUBAY UULU', '1010', '" . bcrypt('1501.09014') . "', 1, '" . generate_id() . "'),\n ('1501.09009', '*****@*****.**', 'MUNARA', 'KUBATBEK KIZI', '1010', '" . bcrypt('1501.09009') . "', 1, '" . generate_id() . "'),\n ('1401.09031', '*****@*****.**', 'NURJAMOL', 'SOİBNAZAROVA', '1010', '" . bcrypt('1401.09031') . "', 1, '" . generate_id() . "'),\n ('1401.09029', '*****@*****.**', 'AYZUURA', 'ERGEŞBEKOVA', '1010', '" . bcrypt('1401.09029') . "', 1, '" . generate_id() . "'),\n ('1401.09027', '*****@*****.**', 'NARGİZA', 'SOYUZBEKOVA', '1010', '" . bcrypt('1401.09027') . "', 1, '" . generate_id() . "'),\n ('1401.09026', '*****@*****.**', 'CANIL', 'ŞAYLOBEKOVA', '1010', '" . bcrypt('1401.09026') . "', 1, '" . generate_id() . "'),\n ('1401.09025', '*****@*****.**', 'KANIŞAY', 'BEYŞENALI KIZI', '1010', '" . bcrypt('1401.09025') . "', 1, '" . generate_id() . "'),\n ('1401.09023', '*****@*****.**', 'AYÇÜROK', 'ABDİMİTALİP KIZI', '1010', '" . bcrypt('1401.09023') . "', 1, '" . generate_id() . "'),\n ('1401.09022', '*****@*****.**', 'NURCİGİT', 'MIRZABEKOV', '1010', '" . bcrypt('1401.09022') . "', 1, '" . generate_id() . "'),\n ('1401.09021', '*****@*****.**', 'AYZİREK', 'ABDISALAMOVA', '1010', '" . bcrypt('1401.09021') . "', 1, '" . generate_id() . "'),\n ('1401.09018', '*****@*****.**', 'ADİNA', 'MOLDOYAR KIZI', '1010', '" . bcrypt('1401.09018') . "', 1, '" . generate_id() . "'),\n ('1401.09017', '*****@*****.**', 'RAHİMAHAN', 'ABDIKADIR KIZI', '1010', '" . bcrypt('1401.09017') . "', 1, '" . generate_id() . "'),\n ('1401.09015', '*****@*****.**', 'AYCAMAL', 'KANIBEK KIZI', '1010', '" . bcrypt('1401.09015') . "', 1, '" . generate_id() . "'),\n ('1401.09014', '*****@*****.**', 'AYDANEK', 'ABDUGAPAR KIZI', '1010', '" . bcrypt('1401.09014') . "', 1, '" . generate_id() . "'),\n ('1401.09012', '*****@*****.**', 'KALİDA', 'CANIŞ KIZI', '1010', '" . bcrypt('1401.09012') . "', 1, '" . generate_id() . "'),\n ('1401.09011', '*****@*****.**', 'ADİNA', 'ADILBEK KIZI', '1010', '" . bcrypt('1401.09011') . "', 1, '" . generate_id() . "'),\n ('1401.09010', '*****@*****.**', 'ELNURA', 'TABIŞBEKOVA', '1010', '" . bcrypt('1401.09010') . "', 1, '" . generate_id() . "'),\n ('1401.09009', '*****@*****.**', 'AYGANIŞ', 'BEKBOLOT KIZI', '1010', '" . bcrypt('1401.09009') . "', 1, '" . generate_id() . "'),\n ('1401.09008', '*****@*****.**', 'AZİZA', 'OMURBEKOVA', '1010', '" . bcrypt('1401.09008') . "', 1, '" . generate_id() . "'),\n ('1401.09007', '*****@*****.**', 'ÇERBEKBAY', 'ORMOŞ UULU', '1010', '" . bcrypt('1401.09007') . "', 1, '" . generate_id() . "'),\n ('1401.09006', '*****@*****.**', 'ELNAZA', 'KÖBÖGÖNOVA', '1010', '" . bcrypt('1401.09006') . "', 1, '" . generate_id() . "'),\n ('1401.09005', '*****@*****.**', 'ERCAN', 'BAYKULOV', '1010', '" . bcrypt('1401.09005') . "', 1, '" . generate_id() . "'),\n ('1401.09004', '*****@*****.**', 'AYBEK', 'KURBANBAEV', '1010', '" . bcrypt('1401.09004') . "', 1, '" . generate_id() . "'),\n ('1401.09002', '*****@*****.**', 'MAKSAT', 'NAZIROV', '1010', '" . bcrypt('1401.09002') . "', 1, '" . generate_id() . "'),\n ('1401.09001', '*****@*****.**', 'MEDİNA', 'KAMÇIBEK KIZI', '1010', '" . bcrypt('1401.09001') . "', 1, '" . generate_id() . "'),\n ('1301.09027', '*****@*****.**', 'ÇOLPON', 'ASKAROVA', '1010', '" . bcrypt('1301.09027') . "', 1, '" . generate_id() . "'),\n ('1301.09022', '*****@*****.**', 'CUMAGÜL', 'ERGESBAEVA', '1010', '" . bcrypt('1301.09022') . "', 1, '" . generate_id() . "'),\n ('1301.09021', '*****@*****.**', 'SEZİM', 'SATIBALDİEVA', '1010', '" . bcrypt('1301.09021') . "', 1, '" . generate_id() . "'),\n ('1301.09018', '*****@*****.**', 'ALİNA', 'KANIBEKOVA', '1010', '" . bcrypt('1301.09018') . "', 1, '" . generate_id() . "'),\n ('1301.09017', '*****@*****.**', 'AYZADA', 'SUYUNBAEVA', '1010', '" . bcrypt('1301.09017') . "', 1, '" . generate_id() . "'),\n ('1301.09016', '*****@*****.**', 'GÜLAYIM', 'MELİS KIZI', '1010', '" . bcrypt('1301.09016') . "', 1, '" . generate_id() . "'),\n ('1301.09015', '*****@*****.**', 'AYCAN', 'MURATBEKOVA', '1010', '" . bcrypt('1301.09015') . "', 1, '" . generate_id() . "'),\n ('1301.09010', '*****@*****.**', 'KLARA', 'ZAİTOVA', '1010', '" . bcrypt('1301.09010') . "', 1, '" . generate_id() . "'),\n ('1301.09007', '*****@*****.**', 'ZULAYKA', 'ABDIMOMUN KIZI', '1010', '" . bcrypt('1301.09007') . "', 1, '" . generate_id() . "'),\n ('1301.09006', '*****@*****.**', 'AYNURA', 'MURZALI KIZI', '1010', '" . bcrypt('1301.09006') . "', 1, '" . generate_id() . "'),\n ('1301.09004', '*****@*****.**', 'AYÇÜRÖK', 'NURLAN KIZI', '1010', '" . bcrypt('1301.09004') . "', 1, '" . generate_id() . "'),\n ('1301.09003', '*****@*****.**', 'MAKSATAY', 'ÇOLPONOVA', '1010', '" . bcrypt('1301.09003') . "', 1, '" . generate_id() . "'),\n ('1301.09002', '*****@*****.**', 'BEKMIRZA', 'NAZARBEKOV', '1010', '" . bcrypt('1301.09002') . "', 1, '" . generate_id() . "'),\n ('1501.11013', '*****@*****.**', 'AYDAY', 'MALABEKOVA', '1011', '" . bcrypt('1501.11013') . "', 1, '" . generate_id() . "'),\n ('1501.11008', '*****@*****.**', 'ADİNA', 'NURLAN KIZI', '1011', '" . bcrypt('1501.11008') . "', 1, '" . generate_id() . "'),\n ('1501.11006', '*****@*****.**', 'NURSULTAN', 'CANAZAKOV', '1011', '" . bcrypt('1501.11006') . "', 1, '" . generate_id() . "'),\n ('1401.11040', '*****@*****.**', 'KAMRAN', 'ABBASOV', '1011', '" . bcrypt('1401.11040') . "', 1, '" . generate_id() . "'),\n ('1401.11039', '*****@*****.**', 'SAİDA', 'ÇAZIMOVA', '1011', '" . bcrypt('1401.11039') . "', 1, '" . generate_id() . "'),\n ('1401.11038', '*****@*****.**', 'REGİNA', 'ABDULOVA', '1011', '" . bcrypt('1401.11038') . "', 1, '" . generate_id() . "'),\n ('1401.11036', '*****@*****.**', 'GİZEM', 'YAKACIK', '1011', '" . bcrypt('1401.11036') . "', 1, '" . generate_id() . "'),\n ('1401.11035', '*****@*****.**', 'PELİN', 'İÇEN', '1011', '" . bcrypt('1401.11035') . "', 1, '" . generate_id() . "'),\n ('1401.11033', '*****@*****.**', 'ERCAN', 'ÖZKAYA', '1011', '" . bcrypt('1401.11033') . "', 1, '" . generate_id() . "'),\n ('1401.11031', '*****@*****.**', 'ASLI', 'UZUN', '1011', '" . bcrypt('1401.11031') . "', 1, '" . generate_id() . "'),\n ('1401.11029', '*****@*****.**', 'ENES', 'CANBUDAK', '1011', '" . bcrypt('1401.11029') . "', 1, '" . generate_id() . "'),\n ('1401.11028', '*****@*****.**', 'MERT', 'EREN', '1011', '" . bcrypt('1401.11028') . "', 1, '" . generate_id() . "'),\n ('1401.11026', '*****@*****.**', 'ORHAN', 'VELİ KİLİT', '1011', '" . bcrypt('1401.11026') . "', 1, '" . generate_id() . "'),\n ('1401.11022', '*****@*****.**', 'NURSULUU', 'ABİEVA', '1011', '" . bcrypt('1401.11022') . "', 1, '" . generate_id() . "'),\n ('1401.11020', '*****@*****.**', 'ZARİNA', 'SEMETEEVA', '1011', '" . bcrypt('1401.11020') . "', 1, '" . generate_id() . "'),\n ('1401.11019', '*****@*****.**', 'GULZAT', 'BALTABAEVA', '1011', '" . bcrypt('1401.11019') . "', 1, '" . generate_id() . "'),\n ('1401.11018', '*****@*****.**', 'GULNURA', 'MELİSOVA', '1011', '" . bcrypt('1401.11018') . "', 1, '" . generate_id() . "'),\n ('1401.11016', '*****@*****.**', 'DİNARA', 'ŞAKİROVA', '1011', '" . bcrypt('1401.11016') . "', 1, '" . generate_id() . "'),\n ('1401.11013', '*****@*****.**', 'ELMİRA', 'ABDİLAMİT KIZI', '1011', '" . bcrypt('1401.11013') . "', 1, '" . generate_id() . "'),\n ('1401.11012', '*****@*****.**', 'AYDANEK', 'AMANCANOVA', '1011', '" . bcrypt('1401.11012') . "', 1, '" . generate_id() . "'),\n ('1401.11009', '*****@*****.**', 'GULZARBEK', 'ABDRASULOV', '1011', '" . bcrypt('1401.11009') . "', 1, '" . generate_id() . "'),\n ('1401.11008', '*****@*****.**', 'AYZADA', 'MARATBEK KIZI', '1011', '" . bcrypt('1401.11008') . "', 1, '" . generate_id() . "'),\n ('1401.11005', '*****@*****.**', 'DATKAYIM', 'SEİTBEK KIZI', '1011', '" . bcrypt('1401.11005') . "', 1, '" . generate_id() . "'),\n ('1401.11004', '*****@*****.**', 'NURBOLOT', 'NIMATOV', '1011', '" . bcrypt('1401.11004') . "', 1, '" . generate_id() . "'),\n ('1401.11003', '*****@*****.**', 'BERMET', 'ERKALI KIZI', '1011', '" . bcrypt('1401.11003') . "', 1, '" . generate_id() . "'),\n ('1401.11002', '*****@*****.**', 'AYPERİ', 'KUMARBEK KIZI', '1011', '" . bcrypt('1401.11002') . "', 1, '" . generate_id() . "'),\n ('1301.11041', '*****@*****.**', 'ZARNİGOR', 'SUYUNBAEVA', '1011', '" . bcrypt('1301.11041') . "', 1, '" . generate_id() . "'),\n ('1301.11040', '*****@*****.**', 'ABDULLAH', 'EROĞLU', '1011', '" . bcrypt('1301.11040') . "', 1, '" . generate_id() . "'),\n ('1301.11037', '*****@*****.**', 'HASAN', 'KARGI', '1011', '" . bcrypt('1301.11037') . "', 1, '" . generate_id() . "'),\n ('1301.11036', '*****@*****.**', 'BETÜL', 'ASAN', '1011', '" . bcrypt('1301.11036') . "', 1, '" . generate_id() . "'),\n ('1301.11030', '*****@*****.**', 'MUHAMMET', 'DURAN', '1011', '" . bcrypt('1301.11030') . "', 1, '" . generate_id() . "'),\n ('1301.11024', '*****@*****.**', 'KANIŞAY', 'KENEŞBEK KIZI', '1011', '" . bcrypt('1301.11024') . "', 1, '" . generate_id() . "'),\n ('1301.11005', '*****@*****.**', 'NURSULTAN', 'ABDIKALİL UULU', '1011', '" . bcrypt('1301.11005') . "', 1, '" . generate_id() . "'),\n ('1301.11002', '*****@*****.**', 'AYCAN', 'ASANOVA', '1011', '" . bcrypt('1301.11002') . "', 1, '" . generate_id() . "')\n ");
}
function add_user(&$dbh)
{
while (true) {
$user_id = generate_id();
$q = "INSERT INTO users (id) VALUES (?)";
log_debug($q, $user_id);
$res = $dbh->query($q, $user_id);
if (PEAR::isError($res)) {
if ($res->getCode() == DB_ERROR_ALREADY_EXISTS) {
continue;
}
die_with_code(500, "{$res->message}\n{$q}\n");
}
return get_user($dbh, $user_id);
}
}
function add_form(&$dbh, $user_id)
{
while (true) {
$form_id = generate_id();
$q = sprintf('INSERT INTO forms
SET id = %s, user_id = %s', $dbh->quoteSmart($form_id), $dbh->quoteSmart($user_id));
error_log(preg_replace('/\\s+/', ' ', $q));
$res = $dbh->query($q);
if (PEAR::isError($res)) {
if ($res->getCode() == DB_ERROR_ALREADY_EXISTS) {
continue;
}
die_with_code(500, "{$res->message}\n{$q}\n");
}
return get_form($dbh, $form_id);
}
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
\Model\Faculty\Faculty::truncate();
// factory(\Model\Faculty\Faculty::class, 10)->create();
\Model\Faculty\Faculty::create(['id' => 1, 'type' => 'faculty', 'uid' => generate_id(), 'code' => 'edb', 'name_en' => 'Letters', 'name_tr' => 'Edebiyat', 'name_kg' => 'Гуманитардык', 'name_ru' => 'Гуманитарный']);
\Model\Faculty\Faculty::create(['id' => 2, 'type' => 'faculty', 'uid' => generate_id(), 'code' => 'fen', 'name_en' => 'Science', 'name_tr' => 'Fen', 'name_kg' => 'Табигый Илимдер', 'name_ru' => 'Точные Науки']);
\Model\Faculty\Faculty::create(['id' => 3, 'type' => 'faculty', 'uid' => generate_id(), 'code' => 'arts', 'name_en' => 'Fine Arts', 'name_tr' => 'Güzel Sanatlar', 'name_kg' => 'Көркөм Өнөр', 'name_ru' => 'Искусство']);
\Model\Faculty\Faculty::create(['id' => 4, 'type' => 'faculty', 'uid' => generate_id(), 'code' => 'iibf', 'name_en' => 'Economics and Administrative Science', 'name_tr' => 'İktisadi ve İdari Bilimler', 'name_kg' => 'Экономика жана Башкаруу', 'name_ru' => 'Экономика и Управление']);
\Model\Faculty\Faculty::create(['id' => 5, 'type' => 'faculty', 'uid' => generate_id(), 'code' => 'teo', 'name_en' => 'Theology', 'name_tr' => 'İlahiyat', 'name_kg' => 'Теология', 'name_ru' => 'Теология']);
\Model\Faculty\Faculty::create(['id' => 6, 'type' => 'faculty', 'uid' => generate_id(), 'code' => 'ilet', 'name_en' => 'Communication', 'name_tr' => 'İletişim', 'name_kg' => 'Комуникация', 'name_ru' => 'Комуникация']);
\Model\Faculty\Faculty::create(['id' => 7, 'type' => 'faculty', 'uid' => generate_id(), 'code' => 'muh', 'name_en' => 'Engineering', 'name_tr' => 'Mühendislik', 'name_kg' => 'Инженердик', 'name_ru' => 'Инженерия']);
\Model\Faculty\Faculty::create(['id' => 8, 'type' => 'faculty', 'uid' => generate_id(), 'code' => 'vet', 'name_en' => 'Veterinary', 'name_tr' => 'Veteriner', 'name_kg' => 'Ветеринардык', 'name_ru' => 'Ветеринария']);
\Model\Faculty\Faculty::create(['id' => 9, 'type' => 'faculty', 'uid' => generate_id(), 'code' => 'ziraat', 'name_en' => 'Agriculture', 'name_tr' => 'Ziraat', 'name_kg' => 'Айыл Чарба', 'name_ru' => 'Сельскохозяйственный']);
\Model\Faculty\Faculty::create(['id' => 10, 'type' => 'highschool', 'uid' => generate_id(), 'code' => 'foreign', 'name_en' => 'Foreign Languages', 'name_tr' => 'Yabancı Diller', 'name_kg' => 'Чет Тилдер', 'name_ru' => 'Иностранные Языки']);
\Model\Faculty\Faculty::create(['id' => 11, 'type' => 'highschool', 'uid' => generate_id(), 'code' => 'beden', 'name_en' => 'Physical Education and Sports', 'name_tr' => 'Beden Eğitimi ve Spor', 'name_kg' => 'Физкультура жана Спорт', 'name_ru' => 'Физкультура и Спорт']);
\Model\Faculty\Faculty::create(['id' => 12, 'type' => 'highschool', 'uid' => generate_id(), 'code' => 'turizm', 'name_en' => 'Tourism and Hotel Management', 'name_tr' => 'Turizm ve Otelcilik', 'name_kg' => 'Туризм жана Мейманкана Иштетүү', 'name_ru' => 'Туризм и Гостиничное Дело']);
\Model\Faculty\Faculty::create(['id' => 13, 'type' => 'highschool', 'uid' => generate_id(), 'code' => 'meslek', 'name_en' => 'Vocational High School', 'name_tr' => 'Meslek Yüksekokulu', 'name_kg' => 'Кесиптик Жогорку Мектеби', 'name_ru' => 'Профессиональная Высшая Школа']);
}
function persist()
{
$sql = "REPLACE INTO " . $_prefix . $this->_table . " SET ";
//echo "<br><br>";
$fields = sqlListFields($this->_table);
$db = get_db();
$pkeys = $db->MetaPrimaryKeys($this->_table);
foreach ($fields as $field) {
$func = "get_" . $field;
//echo "f: $field m: $func status: " . (is_callable(array($this,$func))? "yes" : "no") . "<br>";
if (is_callable(array($this, $func))) {
$val = call_user_func(array($this, $func));
//modified 01-2010 by BGM to centralize to formdata.inc.php
// have place several debug statements to allow standardized testing over next several months
if (!is_array($val)) {
//DEBUG LINE - error_log("ORDataObject persist before strip: ".$val, 0);
$val = strip_escape_custom($val);
//DEBUG LINE - error_log("ORDataObject persist after strip: ".$val, 0);
}
if (in_array($field, $pkeys) && empty($val)) {
$last_id = generate_id();
call_user_func(array(&$this, "set_" . $field), $last_id);
$val = $last_id;
}
if (!empty($val)) {
//echo "s: $field to: $val <br>";
//modified 01-2010 by BGM to centralize to formdata.inc.php
// have place several debug statements to allow standardized testing over next several months
$sql .= " `" . $field . "` = '" . add_escape_custom(strval($val)) . "',";
//DEBUG LINE - error_log("ORDataObject persist after escape: ".add_escape_custom(strval($val)), 0);
//DEBUG LINE - error_log("ORDataObject persist after escape and then stripslashes test: ".stripslashes(add_escape_custom(strval($val))), 0);
//DEBUG LINE - error_log("ORDataObject original before the escape and then stripslashes test: ".strval($val), 0);
}
}
}
if (strrpos($sql, ",") == strlen($sql) - 1) {
$sql = substr($sql, 0, strlen($sql) - 1);
}
//echo "<br>sql is: " . $sql . "<br /><br>";
sqlQuery($sql);
return true;
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
\Model\Department\Department::truncate();
// factory(\Model\Department\Department::class, 10)->create();
\Model\Department\Department::create(['id' => 1001, 'faculty_id' => 1, 'uid' => generate_id(), 'code' => 'tar', 'name_en' => 'History', 'name_tr' => 'Tarih', 'name_kg' => 'Тарых', 'name_ru' => 'История']);
\Model\Department\Department::create(['id' => 1002, 'faculty_id' => 1, 'uid' => generate_id(), 'code' => 'tur', 'name_en' => 'Turkology', 'name_tr' => 'Türkoloji', 'name_kg' => 'Түркология', 'name_ru' => 'Тюркология']);
\Model\Department\Department::create(['id' => 1003, 'faculty_id' => 1, 'uid' => generate_id(), 'code' => 'fls', 'name_en' => 'Philosophy', 'name_tr' => 'Felsefe', 'name_kg' => 'Философия', 'name_ru' => 'Философия']);
\Model\Department\Department::create(['id' => 1004, 'faculty_id' => 1, 'uid' => generate_id(), 'code' => 'sos', 'name_en' => 'Sociology', 'name_tr' => 'Sosyoloji', 'name_kg' => 'Социология', 'name_ru' => 'Социология']);
\Model\Department\Department::create(['id' => 1005, 'faculty_id' => 1, 'uid' => generate_id(), 'code' => 'pdr', 'name_en' => 'Psychological Counseling And Guidance', 'name_tr' => 'Psikolojik Danışmanlık ve Rehberlik', 'name_kg' => 'Психологиялык Кеңеш Жана Көмөк', 'name_ru' => 'Психологическая Консультация И Помощ']);
\Model\Department\Department::create(['id' => 1006, 'faculty_id' => 1, 'uid' => generate_id(), 'code' => 'cde', 'name_en' => 'Eastern Languages (Chinese Language and Literature)', 'name_tr' => 'Doğu Dilleri (Çin Dili Ve Edebiyatı)', 'name_kg' => 'Чыгыш Тилдери (Кытай Тили жана Адабияты)', 'name_ru' => 'Восточные Языки (Китайский Язык и Литература)']);
\Model\Department\Department::create(['id' => 1007, 'faculty_id' => 1, 'uid' => generate_id(), 'code' => 'rde', 'name_en' => 'Eastern Languages (Russian Language and Literature)', 'name_tr' => 'Doğu Dilleri (Rus Dili Ve Edebiyatı)', 'name_kg' => 'Чыгыш Тилдери (Орус Тили жана Адабияты)', 'name_ru' => 'Восточные Языки (Русский Язык и Литература)']);
\Model\Department\Department::create(['id' => 1008, 'faculty_id' => 1, 'uid' => generate_id(), 'code' => 'ide', 'name_en' => 'Western Languages (English Language and Literature)', 'name_tr' => 'Batı Dilleri (İngiliz Dili Ve Edebiyatı)', 'name_kg' => 'Батыш Тилдери (Англис Тили жана Адабияты)', 'name_ru' => 'Западные Языки (Англиский Язык и Литература)']);
\Model\Department\Department::create(['id' => 1009, 'faculty_id' => 1, 'uid' => generate_id(), 'code' => 'tki', 'name_en' => 'Simultaneous Interpreting (Kyrgyz-English)', 'name_tr' => 'Mütercim-Tercümanlık (Kırgızca-İngilizce)', 'name_kg' => 'Синхрондук Котормо (Кыргызча-Англисче)', 'name_ru' => 'Синхронный Перевод (Кыргызско-Английский)']);
\Model\Department\Department::create(['id' => 1010, 'faculty_id' => 1, 'uid' => generate_id(), 'code' => 'tkt', 'name_en' => 'Simultaneous Interpreting (Kyrgyz-Turkish)', 'name_tr' => 'Mütercim-Tercümanlık (Kırgızca-Türkçe)', 'name_kg' => 'Синхрондук Котормо (Кыргызча-Түркчө)', 'name_ru' => 'Синхронный Перевод (Кыргызско-Турецкий)']);
\Model\Department\Department::create(['id' => 1011, 'faculty_id' => 1, 'uid' => generate_id(), 'code' => 'trt', 'name_en' => 'Simultaneous Interpreting (Russsian-Turkish)', 'name_tr' => 'Mütercim-Tercümanlık (Rusça-Türkçe)', 'name_kg' => 'Синхрондук Котормо (Орусча-Түркчө)', 'name_ru' => 'Синхронный Перевод (Русско-Турецкий)']);
\Model\Department\Department::create(['id' => 1012, 'faculty_id' => 1, 'uid' => generate_id(), 'code' => 'eyd', 'name_en' => 'Education Management and Supervision', 'name_tr' => 'Eğitim Yönetimi ve Denetimi', 'name_kg' => 'Билим Берүүнү Башкаруу жана Инспекциялоо', 'name_ru' => 'Менеджмент и Инспектирование Образования']);
\Model\Department\Department::create(['id' => 2001, 'faculty_id' => 2, 'uid' => generate_id(), 'code' => 'ume', 'name_en' => 'Applied Mathematics and Informatics', 'name_tr' => 'Uygulamalı Matematik ve Enformatik', 'name_kg' => 'Колдонмо Математика жана Информатика', 'name_ru' => 'Прикладная Математика и Информатика']);
\Model\Department\Department::create(['id' => 2002, 'faculty_id' => 2, 'uid' => generate_id(), 'code' => 'mat', 'name_en' => 'Mathematics', 'name_tr' => 'Matematik', 'name_kg' => 'Математика', 'name_ru' => 'Математика']);
\Model\Department\Department::create(['id' => 2003, 'faculty_id' => 2, 'uid' => generate_id(), 'code' => 'bio', 'name_en' => 'Biology', 'name_tr' => 'Biyoloji', 'name_kg' => 'Биология', 'name_ru' => 'Биология']);
\Model\Department\Department::create(['id' => 3001, 'faculty_id' => 3, 'uid' => generate_id(), 'code' => 'res', 'name_en' => 'Painting', 'name_tr' => 'Resim', 'name_kg' => 'Сүрөт', 'name_ru' => 'Живопись']);
\Model\Department\Department::create(['id' => 3002, 'faculty_id' => 3, 'uid' => generate_id(), 'code' => 'grf', 'name_en' => 'Graphics', 'name_tr' => 'Grafik', 'name_kg' => 'Графика', 'name_ru' => 'Графика']);
\Model\Department\Department::create(['id' => 3003, 'faculty_id' => 3, 'uid' => generate_id(), 'code' => 'muz', 'name_en' => 'Music Arts', 'name_tr' => 'Müzik Sanatı', 'name_kg' => 'Эстрадалык Вокал', 'name_ru' => 'Эстрадный Вокал']);
\Model\Department\Department::create(['id' => 3004, 'faculty_id' => 3, 'uid' => generate_id(), 'code' => 'tis', 'name_en' => 'Scene Arts', 'name_tr' => 'Sahne Sanatları', 'name_kg' => 'Актердук Өнөр', 'name_ru' => 'Актерское Искусство']);
\Model\Department\Department::create(['id' => 4001, 'faculty_id' => 4, 'uid' => generate_id(), 'code' => 'ekn', 'name_en' => 'Economy', 'name_tr' => 'İktisat', 'name_kg' => 'Экономика', 'name_ru' => 'Экономика']);
\Model\Department\Department::create(['id' => 4002, 'faculty_id' => 4, 'uid' => generate_id(), 'code' => 'isl', 'name_en' => 'Management', 'name_tr' => 'İşletme', 'name_kg' => 'Менеджмент', 'name_ru' => 'Менеджмент']);
\Model\Department\Department::create(['id' => 4003, 'faculty_id' => 4, 'uid' => generate_id(), 'code' => 'mab', 'name_en' => 'Finance', 'name_tr' => 'Maliye', 'name_kg' => 'Финанс', 'name_ru' => 'Финансы']);
\Model\Department\Department::create(['id' => 4004, 'faculty_id' => 4, 'uid' => generate_id(), 'code' => 'uls', 'name_en' => 'International Relations', 'name_tr' => 'Uluslararası İlişkiler', 'name_kg' => 'Эл Аралык Мамилелер', 'name_ru' => 'Международные Отношения']);
\Model\Department\Department::create(['id' => 4005, 'faculty_id' => 4, 'uid' => generate_id(), 'code' => 'fin', 'name_en' => 'Finance and Banking', 'name_tr' => 'Finans ve Bankacılık', 'name_kg' => 'Финанс жана Кредит', 'name_ru' => 'Финансы и Кредит']);
\Model\Department\Department::create(['id' => 5001, 'faculty_id' => 5, 'uid' => generate_id(), 'code' => 'ilh', 'name_en' => 'Islamic Studies', 'name_tr' => 'İslam Bilimleri', 'name_kg' => 'Ислам Билимдери', 'name_ru' => 'Исламоведение']);
\Model\Department\Department::create(['id' => 5002, 'faculty_id' => 5, 'uid' => generate_id(), 'code' => 'dib', 'name_en' => 'Religious Studies', 'name_tr' => 'Din Bilimleri', 'name_kg' => 'Дин Билимдери', 'name_ru' => 'Религиоведение']);
\Model\Department\Department::create(['id' => 6001, 'faculty_id' => 6, 'uid' => generate_id(), 'code' => 'gzt', 'name_en' => 'Journalism', 'name_tr' => 'Gazetecilik', 'name_kg' => 'Журналистика', 'name_ru' => 'Журналистика']);
\Model\Department\Department::create(['id' => 6002, 'faculty_id' => 6, 'uid' => generate_id(), 'code' => 'hir', 'name_en' => 'Public Relations and Advertising', 'name_tr' => 'Halkla İlişkiler ve Reklamcılık', 'name_kg' => 'Коом менен Байланыш жана Реклама', 'name_ru' => 'Связь с Общественностью и Рекламное Дело']);
\Model\Department\Department::create(['id' => 6003, 'faculty_id' => 6, 'uid' => generate_id(), 'code' => 'rts', 'name_en' => 'Radio, Television and Cinema', 'name_tr' => 'Radyo, Televizyon ve Sinema', 'name_kg' => 'Радио, Телевидение жана Кино', 'name_ru' => 'Радио, Телевидение и Кино']);
\Model\Department\Department::create(['id' => 7001, 'faculty_id' => 7, 'uid' => generate_id(), 'code' => 'bil', 'name_en' => 'Computer Engineering', 'name_tr' => 'Bilgisayar Mühendisliği', 'name_kg' => 'Компьютер Инженердиги', 'name_ru' => 'Компьютерная Инженерия']);
\Model\Department\Department::create(['id' => 7002, 'faculty_id' => 7, 'uid' => generate_id(), 'code' => 'cev', 'name_en' => 'Ecological Engineering', 'name_tr' => 'Çevre Mühendisliği', 'name_kg' => 'Экологиялык Инженердиги', 'name_ru' => 'Экологическая Инженерия']);
\Model\Department\Department::create(['id' => 7003, 'faculty_id' => 7, 'uid' => generate_id(), 'code' => 'kmu', 'name_en' => 'Chemical Engineering', 'name_tr' => 'Kimya Mühendisliği', 'name_kg' => 'Химия Инженердиги', 'name_ru' => 'Химическая Инженерия']);
\Model\Department\Department::create(['id' => 7004, 'faculty_id' => 7, 'uid' => generate_id(), 'code' => 'gid', 'name_en' => 'Food Engineering', 'name_tr' => 'Gıda Mühendisliği', 'name_kg' => 'Тамак-Аш Инженердиги', 'name_ru' => 'Пищевая Инженерия']);
\Model\Department\Department::create(['id' => 8001, 'faculty_id' => 8, 'uid' => generate_id(), 'code' => 'vet', 'name_en' => 'Veterinary', 'name_tr' => 'Veteriner', 'name_kg' => 'Ветеринардык', 'name_ru' => 'Ветеринария']);
\Model\Department\Department::create(['id' => 9001, 'faculty_id' => 9, 'uid' => generate_id(), 'code' => 'btb', 'name_en' => 'Horticulture and Agronomy', 'name_tr' => 'Bahçe ve Tarla Bitkileri', 'name_kg' => 'Мөмө-жемиш жана Талаа өсүмдүктөрү', 'name_ru' => 'Плодоовощеводство']);
\Model\Department\Department::create(['id' => 9002, 'faculty_id' => 9, 'uid' => generate_id(), 'code' => 'bko', 'name_en' => 'Plant Protection', 'name_tr' => 'Bitki Koruma', 'name_kg' => 'Өсүмдүктөрдү Коргоо', 'name_ru' => 'Защита Растений']);
\Model\Department\Department::create(['id' => 9003, 'faculty_id' => 9, 'uid' => generate_id(), 'code' => 'zoo', 'name_en' => 'Animal Science', 'name_tr' => 'Zootekni', 'name_kg' => 'Зоотехника', 'name_ru' => 'Зоотехника']);
}
function send_mail_etu()
{
//generation de l' id
generate_id();
require_once 'MSN.php';
//Parametres du mail
$subject = "[Master Upmc voeux inscription M1] Verification d'email";
$message = "Bonjour " . $_SESSION['prenom'] . ".<br/> Votre identifiant de session est : " . $_SESSION['ident'];
//Pour envoyer un mail HTML, l'en-tête Content-type doit être defini
$headers = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=utf-8' . "\r\n";
//En-têtes additionnels
$headers .= 'From: ' . $msn[$_SESSION['spe']] . "\r\n";
//envoi du mail
if (mail($_SESSION['mail'], $subject, $message, $headers)) {
header("Location: saisie_identifiant.php");
} else {
echo "Une erreur s'est produite!";
exit;
//sortie
}
}
function add_scan(&$dbh, $user_id)
{
while (true) {
$scan_id = generate_id();
if ($user_id != null) {
// TODO why doesn't this work wth params? Broken PEAR::DB version?
$q = sprintf("INSERT INTO scans (id, user_id) VALUES (%s, %s)", $dbh->quoteSmart($scan_id), $dbh->quoteSmart($user_id));
log_debug($q);
$res = $dbh->query($q);
} else {
$q = 'INSERT INTO scans (id) VALUES (?)';
log_debug($q, $scan_id);
$res = $dbh->query($q, $scan_id);
}
if (PEAR::isError($res)) {
if ($res->getCode() == DB_ERROR_ALREADY_EXISTS) {
continue;
}
die_with_code(500, "{$res->message}\n{$q}\n");
}
return get_scan($dbh, $scan_id);
}
}
function add_mbtiles(&$dbh, $user_id, $url, $file_name, $file_path)
{
$mbtiles_data = get_mbtiles_data($file_path);
$mbtiles_id = generate_id();
$q = sprintf('INSERT INTO mbtiles
SET id = %s,
user_id = %s,
url = %s,
uploaded_file = %s,
min_zoom = %d,
max_zoom = %d,
center_zoom = %d,
center_x_coord = %d,
center_y_coord = %d', $dbh->quoteSmart($mbtiles_id), $dbh->quoteSmart($user_id), $dbh->quoteSmart($url), $dbh->quoteSmart($file_name), $dbh->quoteSmart($mbtiles_data['min_zoom']), $dbh->quoteSmart($mbtiles_data['max_zoom']), $dbh->quoteSmart($mbtiles_data["center_coordinates"]['zoom']), $dbh->quoteSmart($mbtiles_data["center_coordinates"]['x']), $dbh->quoteSmart($mbtiles_data["center_coordinates"]['y']));
error_log(preg_replace('/\\s+/', ' ', $q));
$res = $dbh->query($q);
if (PEAR::isError($res)) {
if ($res->getCode() == DB_ERROR_ALREADY_EXISTS) {
continue;
}
die_with_code(500, "{$res->message}\n{$q}\n");
}
return get_mbtiles_by_id($dbh, $mbtiles_id);
}
function save($params, $data)
{
global $message, $api, $base_path;
$title = $params['title'];
$bbcode = $params['bbcode'];
if (strlen($title) < 3 && strlen($bbcode) < 7) {
if ($api) {
return_json(array('error' => 'Would not save empty data, sorry'));
} else {
$message = 'Would not save empty data, sorry';
}
return;
}
if (strlen($title) > 250) {
$spacepos = strrpos($title, ' ');
$title = substr($title, 0, $spacepos !== false ? $spacepos : 250);
}
$db = getdb();
if ($data && isset($params['key']) && $data['editid'] == $params['key']) {
// update
$codeid = $params['id'];
$editid = $params['key'];
$sql = !$db ? '' : "update " . DB_TABLE . " set updated=now(), title='" . $db->escape_string($title) . "', bbcode='" . $db->escape_string($bbcode) . "' where codeid = '{$codeid}'";
cache_remove($codeid, 'code');
cache_remove(false, 'user');
// yup, now a lot of users can have their libraries updated
} else {
$editid = generate_id(EDIT_HASH_LENGTH);
$tries = 10;
do {
$codeid = generate_id(HASH_LENGTH);
$exists = get_data($codeid) !== false;
} while ($exists);
$sql = !$db ? '' : "insert into " . DB_TABLE . " (created, updated, codeid, editid, title, bbcode) values(now(), now(), '{$codeid}', '{$editid}', '" . $db->escape_string($title) . "', '" . $db->escape_string($bbcode) . "')";
}
if ($db) {
$res = $db->query($sql);
} else {
// put code to cache
$assoc = array('editid' => $editid, 'title' => $title, 'bbcode' => $bbcode);
cache_put($codeid, 'code', $assoc);
$res = true;
}
if (!$api) {
if (!$res) {
$message = 'Failed to insert entry in the database: ' . $db->error;
} else {
header("Location: " . $base_path . "/{$codeid}/{$editid}");
exit;
}
} else {
if (!$res) {
return_json(array('error' => 'Failed to insert entry in the database: ' . $db->error));
} else {
return_json(array('codeid' => $codeid, 'editid' => $editid, 'viewurl' => $base_path . "/{$codeid}", 'editurl' => $base_path . "/{$codeid}/{$editid}"));
}
exit;
}
}
public function creating($model)
{
$model->uid = generate_id();
}
public function generateSequenceID()
{
return generate_id();
}
function process_tv()
{
global $config, $twitter;
$shows_added = 0;
$mail_string = '';
print date($config['logging']['date_format']) . 'hellaVCR/' . $config['version'] . "\n";
print date($config['logging']['date_format']) . "processing tv...\n";
//check to make sure the file exists
if (file_exists($config['xml_tv'])) {
//create a SimpleXML object
$xml = simplexml_load_file($config['xml_tv']) or die("Can't read XML");
//loop over each show
$shows = $xml->xpath('/tv/show');
foreach ($shows as $show) {
//extra show name info
$nameExtra = array();
if (array_key_exists(strval($show->format), $GLOBALS['formats'])) {
$nameExtra[] = $GLOBALS['formats'][strval($show->format)];
}
if (array_key_exists(strval($show->language), $GLOBALS['languages'])) {
$nameExtra[] = $GLOBALS['languages'][strval($show->language)];
}
if (array_key_exists(strval($show->source), $GLOBALS['sources'])) {
$nameExtra[] = $GLOBALS['sources'][strval($show->source)];
}
$nameExtra = implode(', ', $nameExtra);
if (strlen($nameExtra) > 0) {
$nameExtra = ' (' . $nameExtra . ')';
}
//full show name
$name = htmlspecialchars_decode($show->name) . $nameExtra;
print date($config['logging']['date_format']) . $name . "\n";
//add timestamp
if (empty($show['updated'])) {
$show->addAttribute('updated', 0);
}
//get info from tv scraper if past the refresh time
$show_info = get_show_info($show);
//no show info (skip)
if (empty($show_info)) {
print date($config['logging']['date_format']) . ' get show info FAILED! (' . $config['info_scraper'] . " likely down)\n";
continue;
}
//update timestamp
if (!$show_info['cached']) {
$show['updated'] = time();
}
//make sure it has an ID
if (empty($show['id'])) {
print "adding ID";
$show->addAttribute('id', generate_id());
}
//make sure it has a downloads node
if (!$show->downloads) {
$show->addChild('downloads', '');
} else {
$remove = 0;
foreach ($show->downloads->download as $download) {
if (!empty($download->episode)) {
$ep_parts = explode('x', $download->episode);
$double_parts = explode('-', $ep_parts[1]);
//add new nodes
foreach ($double_parts as $ep) {
$d = $show->downloads->addChild('download');
$d->addAttribute('season', intval($ep_parts[0]));
$d->addAttribute('episode', intval($ep));
$d->addAttribute('timestamp', $download->timestamp);
}
$remove++;
}
}
//remove old nodes
while ($remove-- > 0) {
unset($show->downloads->download[0]);
}
}
if (!$show_info['cached']) {
//auto update show name to match info scraper
if ($config['update_show_name'] && strlen(trim($show_info['name'])) > 0 && trim($show->name) != $show_info['name']) {
$show->name = $show_info['name'];
print date($config['logging']['date_format']) . ' name updated to match ' . $config['info_scraper'] . ': ' . $show->name . "\n";
}
//update tvrage series id
if (!$show->tvrageid) {
$show->addChild('tvrageid', $show_info['tvrageid']);
} else {
$show->tvrageid = trim($show_info['tvrageid']);
}
//update thetvdb series id
if (!$show->thetvdbid) {
$show->addChild('thetvdbid', $show_info['thetvdbid']);
} else {
$show->thetvdbid = trim($show_info['thetvdbid']);
}
//episode list (seasons, eps)
if (!$show->episodelist) {
$show->addChild('episodelist', '');
}
if (!empty($show_info['episodelist'])) {
foreach ($show_info['episodelist'] as $season => $episodes) {
$s_existing = $show->episodelist->xpath('season[@num=' . $season . ']');
//exists, so just update
if (!empty($s_existing)) {
$s_existing[0]['episodes'] = sizeof($episodes);
} else {
$s = $show->episodelist->addChild('season');
$s->addAttribute('num', $season);
$s->addAttribute('episodes', sizeof($episodes));
}
/*
//full episode details
foreach($episodes as $episode) {
$e = $s->addChild('episode');
$e->addAttribute('num', $episode['num']);
$e->addAttribute('aired', $episode['aired']);
$e->addAttribute('title', htmlentities($episode['title']));
}
*/
}
}
//update episode URL
if (!$show->url) {
$show->addChild('url', $show_info['Show URL']);
} else {
$show->url = trim($show_info['Show URL']);
}
//update status
if (!$show->status) {
$show->addChild('status', $show_info['Status']);
} else {
$show->status = htmlspecialchars(trim($show_info['Status']));
}
//update airtime
if (!$show->airtime) {
$show->addChild('airtime', $show_info['Airtime']);
} else {
$show->airtime = htmlspecialchars(trim($show_info['Airtime']));
}
//update network
if (!$show->network) {
$show->addChild('network', $show_info['Network']);
} else {
$show->network = htmlspecialchars(trim($show_info['Network']));
}
//update year the show started
if (!$show->year) {
$show->addChild('year', $show_info['Premiered']);
} else {
$show->year = htmlspecialchars(trim($show_info['Premiered']));
}
//update next ep
$air_date = $show_info['Next Episode']['airdate'];
if (substr_count($air_date, '/') == 2) {
$date_parts = explode('/', $air_date);
$air_date = date('(l) F j, Y', strtotime($date_parts[1] . ' ' . $date_parts[0] . ' ' . $date_parts[2]));
}
$next_info = strlen(trim($show_info['Next Episode']['episode'])) > 0 ? $show_info['Next Episode']['episode'] . ' - "' . $show_info['Next Episode']['title'] . '" airs ' . $air_date : '';
if (!$show->next) {
$show->addChild('next', htmlspecialchars(trim($next_info)));
} else {
$show->next = htmlspecialchars(trim($next_info));
}
//print date($config['logging']['date_format']) . ' next episode: ' . $show_info['Next Episode']['episode'] . "\n";
//update next timestamp (includes date and time)
if (strpos($show_info['RFC3339'], 'T:00-') !== false) {
$time_prefix = '00:00';
if (strlen($show_info['Airtime']) > 0) {
$time_parts = explode('at', $show_info['Airtime']);
$time_prefix = date('H:i', strtotime('today ' . $time_parts[1]));
}
$show_info['next_timestamp'] = strtotime(str_replace('T:00-', 'T' . $time_prefix . ':00-', $show_info['RFC3339']));
}
if (!$show->next_timestamp) {
$show->addChild('next_timestamp', $show_info['next_timestamp']);
} else {
$show->next_timestamp = trim($show_info['next_timestamp']);
}
//update latest episode
if (!$show->latest) {
$show->addChild('latest', trim($show_info['Latest Episode']['episode']));
} else {
$show->latest = trim($show_info['Latest Episode']['episode']);
}
}
//queue up any episodes prior to the last episode (there must be at least 1 aired episode)
if ($show->latest) {
$latest = explode('x', $show->latest);
$latest_season = intval($latest[0]);
$latest_episode = intval($latest[1]);
//if season or episode are blank, default to the last episode so shows are downloded moving forward
if ($show->season == '' && $show->episode == '') {
$show->season = $latest_season;
$show->episode = $latest_episode;
//special case for a brand new series
if ($latest_season == '1' && strpos($latest_episode, '01') !== false) {
$show->episode = 0;
}
}
//check on the day of air since tvrage doesn't update 'Latest Episode' until midnight
if (strval($show->next_timestamp) != '' && date('m/d/Y') == date('m/d/Y', strval($show->next_timestamp)) && $show->episode == $latest_episode) {
$pre_midnight_check = true;
$latest_episode = intval($latest_episode) + 1;
}
print date($config['logging']['date_format']) . ' last episode: ' . $show->season . 'x' . sprintf('%02d', $show->episode) . "\n";
$one_ep_behind = $show->season == $latest_season && $show->episode == $latest_episode - 1;
$skipped_episodes = 0;
//loop over all mising episodes
$current_season = intval($show->season);
while ($current_season <= $latest_season && $current_season <= sizeof($show->episodelist->xpath('season'))) {
$current_episode = $current_season > intval($show->season) ? 0 : intval($show->episode + 1);
while ($current_episode <= $latest_episode || $current_season < $latest_season) {
$episode_string = $current_season . 'x' . sprintf('%02d', $current_episode);
$episode_info = $show->episodelist->xpath('season[@num=' . $current_season . ']');
//episode found, attempt to queue
if (sizeof($episode_info) > 0 && $episode_info[0]['episodes'] >= $current_episode) {
// Fetch TVrage airtime
$airdate = $show_info['episodelist'][$current_season][$current_episode]['aired'];
if ($airdate) {
$airdate = date("Y-m-d", $airdate);
}
$nzb_info = false;
$nzb_info = search_nzb(array('show' => $show->name, 'year' => $show->year, 'season' => $current_season, 'episode' => $current_episode, 'language' => $show->language, 'format' => $show->format, 'source' => $show->source, 'airdate' => $airdate));
$nzb_downloaded = false;
$double_ep = false;
if (!$nzb_info) {
//try again without specified format
$nzb_info = search_nzb(array('show' => $show->name, 'year' => $show->year, 'season' => $current_season, 'episode' => $current_episode, 'language' => $show->language, 'format' => '', 'source' => $show->source, 'airdate' => $airdate));
}
//id found
if ($nzb_info) {
//nzbmatrix double ep
switch ($config['nzb_site']) {
case 'nzbmatrix':
$double_ep = strpos($nzb_info['title'], 'E' . sprintf('%02d', $current_episode) . 'E' . sprintf('%02d', $current_episode + 1));
break;
case 'tvnzb':
//--
break;
case 'newzbin':
default:
$double_ep = strpos($nzb_info['title'], $current_season . 'x' . sprintf('%02d', $current_episode + 1)) !== false;
}
//double episode found
if ($double_ep) {
$current_episode++;
$episode_string .= '-' . sprintf('%02d', $current_episode);
$double_ep = true;
print 'double episode found' . $config['debug_separator'];
}
switch ($config['nzb_handler']) {
//move to directory
case 'nzb':
$nzb_downloaded = download_nzb($nzb_info);
break;
//send to hellanzb
//send to hellanzb
case 'hellanzb':
$nzb_downloaded = send_to_hellanzb($nzb_info);
if ($nzb_downloaded) {
$shows_added++;
}
break;
//send to sabnzbd
//send to sabnzbd
case 'sabnzbd':
$nzb_downloaded = send_to_sabnzbd($nzb_info, $config['nzb_site'] == 'nzbmatrix');
if ($nzb_downloaded) {
$shows_added++;
}
break;
default:
//seems like a die worthy event
die('NZB Handler not configured properly');
break;
}
//newzbin has a limit of 5 nzb's per minute
//rate limit not needed in nzb mode since download_nzb handles the exact time to wait
if ($config['nzb_handler'] != 'nzb' && $shows_added % 5 == 0) {
sleep(60);
}
//send XBMC update
if ($nzb_downloaded && $config['xbmc'] && $config['xbmc_host']) {
$xbmc_ch = curl_init('http://' . $config['xbmc_host'] . '/xbmcCmds/xbmcHttp?command=ExecBuiltIn¶meter=Notification(Download+Started,' . urlencode($show->name) . '+' . $episode_string . ')');
curl_setopt($xbmc_ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($xbmc_ch, CURLOPT_TIMEOUT, 5);
$result = curl_exec($xbmc_ch);
curl_close($xbmc_ch);
print $config['debug_separator'] . 'XBMC notification ' . ($result ? 'ok' : 'FAILED');
}
//send twitter update
if ($nzb_downloaded && $config['twitter'] && $twitter) {
$prefix = $config['hollers'][@array_rand($config['hollers'])];
$status = $twitter->send($prefix . $show->name . ' ' . $episode_string . $nameExtra);
print $config['debug_separator'] . ($status ? 'tweeted ok' : 'twitter FAILED');
}
//build mail string
if ($nzb_downloaded) {
$mail_string .= $show->name . ' ' . $episode_string . ' (' . $GLOBALS['formats'][strval($show->format)] . ', ' . $GLOBALS['languages'][strval($show->language)] . ")\n";
}
//save to download history
if ($nzb_downloaded) {
$download_node = $show->downloads->addChild('download', '');
$download_node->addAttribute('season', $current_season);
$download_node->addAttribute('episode', $current_episode);
$download_node->addAttribute('timestamp', time());
if ($double_ep) {
$download_node = $show->downloads->addChild('download', '');
$download_node->addAttribute('season', $current_season);
$download_node->addAttribute('episode', $current_episode + 1);
$download_node->addAttribute('timestamp', time());
}
}
print "\n";
} else {
//$skipped_episodes++;
print "skipping this episode\n";
//increment season if we're out of eps
$seasonInfo = $show->episodelist->xpath('season[@num=' . $current_season . ']');
if (sizeof($seasonInfo) > 0 && $current_episode + 1 > $seasonInfo[0]['episodes']) {
break;
}
}
//increment last episode for the show
if ($nzb_downloaded) {
$show->season = $current_season;
$show->episode = $current_episode;
}
$current_episode++;
} else {
break;
}
}
$current_season++;
}
}
}
//send email
if (!empty($config['mail']) && $mail_string != '') {
$mail_sent = mail($config['mail_to'], '[hellaVCR] ' . substr_count($mail_string, "\n") . ' episodes found', "The following episodes have been queued:\n\n" . $mail_string, 'From: hellaVCR <*****@*****.**>');
print date($config['logging']['date_format']) . 'emailing queue' . $config['debug_separator'] . ($mail_sent ? 'done' : 'FAIL') . "\n";
}
//send prowl
if (!empty($config['prowl']) && $mail_string != '') {
$prowl_sent = send_prowl(substr_count($mail_string, "\n") . ' episodes found', "The following episodes have been queued:\n\n" . $mail_string);
print date($config['logging']['date_format']) . 'sending prowl notification' . $config['debug_separator'] . $prowl_sent . "\n";
}
//write new xml file
$xml_updated = saveXML($xml);
print date($config['logging']['date_format']) . 'saving xml file' . $config['debug_separator'] . ($xml_updated ? 'done' : 'FAIL') . "\n";
} else {
print date($config['logging']['date_format']) . 'tv XML (' . $config['xml_tv'] . ') file not found...make sure to use an absolute path' . "\n";
}
}
function check_for_import_content()
{
global $grid;
if (!file_exists(GRID_DIR . '/import')) {
return;
}
setup_user();
$dh = opendir(GRID_DIR . '/import');
$now = time();
$expires = $now + 31536000;
while ($filename = readdir($dh)) {
if (substr($filename, 0, 1) == '.') {
continue;
}
$message_id = generate_id();
$file_id = generate_id();
$created = $now;
if (substr($filename, -5, 5) == '.html') {
$html = file_get_contents(GRID_DIR . "/import/{$filename}");
if (preg_match('#<title>(.+)</title>#', $html, $matches)) {
list(, $content) = $matches;
} else {
$content = preg_replace('#\\.\\w+$#', '', $filename);
}
if (preg_match('#var meta = (.+?);#', $html, $matches)) {
list(, $meta) = $matches;
$meta = json_decode($meta);
if (!empty($meta->date_published)) {
$date_published = strtotime($meta->date_published);
if (!empty($date_published)) {
$created = $date_published;
}
}
}
} else {
$content = preg_replace('#\\.\\w+$#', '', $filename);
}
$grid->db->insert('message', array('id' => $message_id, 'user_id' => $grid->user->id, 'content' => $content, 'parent_id' => 'c/library', 'server_id' => $grid->meta['server_id'], 'file_id' => $file_id, 'expires' => $expires, 'created' => $created, 'updated' => $now));
$path = "../import/{$filename}";
$grid->db->insert('file', array('id' => $file_id, 'user_id' => $grid->user->id, 'server_id' => $grid->meta['server_id'], 'name' => $filename, 'path' => $path, 'created' => $now, 'updated' => $now));
attach_file($message_id, $file_id);
}
}
<?php
$id = generate_id();
$now = time();
$expires = $now + intval($_POST['ttl']);
$attachment = empty($_POST['attachment']) ? null : $_POST['attachment'];
$grid->db->insert('message', array('id' => $id, 'user_id' => $grid->user->id, 'content' => $params['content'], 'parent_id' => 0, 'server_id' => $grid->meta['server_id'], 'file_id' => $attachment, 'expires' => $expires, 'created' => $now, 'updated' => $now));
blink_leds($params['content']);
update_user();
if (!empty($attachment)) {
attach_file($id, $attachment);
}
$container = get_container();
$url = empty($container) ? GRID_URL . 'forum' : GRID_URL . "c/{$container->id}";
if (!empty($container)) {
$grid->db->update('message', array('parent_id' => "c/{$container->id}"), $id);
$grid->db->update('container', array('updated' => $now), $container->id);
}
$this->redirect($url);
exit;
++$count;
$ffmod = "_{$count}";
}
$target = "{$docdir}/{$ffname}{$ffmod}{$ffsuff}";
$docdate = fixDate($_POST['form_docdate']);
// Create the target PDF. Note that we are relying on the .tif files for
// the individual pages to already exist in the faxcache directory.
//
$info_msg .= mergeTiffs();
// The -j option here requires that libtiff is configured with libjpeg.
// It could be omitted, but the output PDFs would then be quite large.
$tmp0 = exec("tiff2pdf -j -p letter -o '{$target}' '{$faxcache}/temp.tif'", $tmp1, $tmp2);
if ($tmp2) {
$info_msg .= "tiff2pdf returned {$tmp2}: {$tmp0} ";
} else {
$newid = generate_id();
$fsize = filesize($target);
$catid = (int) $_POST['form_category'];
// Update the database.
$query = "INSERT INTO documents ( " . "id, type, size, date, url, mimetype, foreign_id, docdate" . " ) VALUES ( " . "'{$newid}', 'file_url', '{$fsize}', NOW(), 'file://{$target}', " . "'application/pdf', {$patient_id}, '{$docdate}' " . ")";
sqlStatement($query);
$query = "INSERT INTO categories_to_documents ( " . "category_id, document_id" . " ) VALUES ( " . "'{$catid}', '{$newid}' " . ")";
sqlStatement($query);
}
// end not error
// If we are posting a note...
if ($_POST['form_cb_note'] && !$info_msg) {
// Build note text in a way that identifies the new document.
// See pnotes_full.php which uses this to auto-display the document.
$note = "{$ffname}{$ffmod}{$ffsuff}";
for ($tmp = $catid; $tmp;) {
case 'add':
//check to make sure the file exists
if (file_exists($config['xml_tv'])) {
//create a SimpleXML object
$xml = simplexml_load_file($config['xml_tv']);
$season = $_POST['season'];
$episode = $_POST['episode'];
if ($_POST['dlnew'] == 1) {
$season = '';
$episode = '';
} elseif ($_POST['dlfull'] == 1) {
$season = 1;
$episode = 0;
}
$show = $xml->addChild('show');
$show->addAttribute('id', generate_id());
$show->addChild('name', htmlspecialchars(trim(get_magic_quotes_gpc() ? stripslashes($_POST['name']) : $_POST['name'])));
$show->addChild('format', $_POST['format']);
$show->addChild('language', $_POST['language']);
$show->addChild('source', $_POST['source']);
$show->addChild('season', $season);
$show->addChild('episode', $episode);
$show->addChild('poster', trim($_POST['poster']));
$show->addChild('next', '');
$show->addChild('url', '');
$show->addChild('status', '');
//write updated xml file
print saveXML($xml) ? 1 : 0;
}
exit;
//edit
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
\Model\Answer\Answer::truncate();
/* factory(\Model\Answer\Answer::class, 500)->create(); */
\Model\Answer\Answer::insert([['question_id' => 1, 'uid' => generate_id(), 'answer' => 1, 'text' => 'Э.Геккель'], ['question_id' => 1, 'uid' => generate_id(), 'answer' => 0, 'text' => 'Ю. Одум'], ['question_id' => 1, 'uid' => generate_id(), 'answer' => 0, 'text' => 'Р.Бойль'], ['question_id' => 2, 'uid' => generate_id(), 'answer' => 1, 'text' => 'А.Тенсли'], ['question_id' => 2, 'uid' => generate_id(), 'answer' => 0, 'text' => 'В. Вернадский'], ['question_id' => 2, 'uid' => generate_id(), 'answer' => 0, 'text' => 'И.Шилов'], ['question_id' => 3, 'uid' => generate_id(), 'answer' => 1, 'text' => 'В.Вернадский'], ['question_id' => 3, 'uid' => generate_id(), 'answer' => 0, 'text' => 'Р.Дажо'], ['question_id' => 3, 'uid' => generate_id(), 'answer' => 0, 'text' => 'Ю.Израэль'], ['question_id' => 4, 'uid' => generate_id(), 'answer' => 1, 'text' => 'Коомдун экологиясы'], ['question_id' => 4, 'uid' => generate_id(), 'answer' => 0, 'text' => 'Организмдердин экологиясы'], ['question_id' => 4, 'uid' => generate_id(), 'answer' => 0, 'text' => 'Популяциялардын экологиясы'], ['question_id' => 5, 'uid' => generate_id(), 'answer' => 1, 'text' => 'Жаратылыш ресурстарын цивилизациянын өнүгүшүнө толук түрдө колдонуу жана бүтүн биосфераны башкаруу ыкмаларын иштеп чыгуу'], ['question_id' => 5, 'uid' => generate_id(), 'answer' => 0, 'text' => 'Цивилизациянын туруктуу өнүгүүсүн экологиянын мыйзамдарына ылайык келтирүү жана бүтүн биосфераны башкаруу ыкмаларын иштеп чыгуу'], ['question_id' => 5, 'uid' => generate_id(), 'answer' => 0, 'text' => 'Адамзаттын туруктуу өнүгүшүн камсыздоо жана ага ылайык бүтүн биосфераны башкаруу ыкмаларын иштеп чыгуу'], ['question_id' => 6, 'uid' => generate_id(), 'answer' => 1, 'text' => 'Организмди курчап турган жана аны менен тынымсыз карым катнашта болгон абиотикалык жана биотикалык шарттарынын жыйындысы'], ['question_id' => 6, 'uid' => generate_id(), 'answer' => 0, 'text' => 'Биосферада тынымсыз карым катнашта болгон абиотикалык жана биотикалык шарттардын жыйындысы'], ['question_id' => 6, 'uid' => generate_id(), 'answer' => 0, 'text' => 'Организмди курчап турган жана аны менен тынымсыз карым катнашта болгон биотикалык шарттарынын жыйындысы'], ['question_id' => 7, 'uid' => generate_id(), 'answer' => 1, 'text' => 'Топурактын өсүмдүктөргө тийгизген таасири'], ['question_id' => 7, 'uid' => generate_id(), 'answer' => 0, 'text' => 'Нымдын өсүмдүктөргө тийгизген таасири'], ['question_id' => 7, 'uid' => generate_id(), 'answer' => 0, 'text' => 'Топурактын организмге тийгизген таасири '], ['question_id' => 8, 'uid' => generate_id(), 'answer' => 1, 'text' => 'Рельефтин өзгөчөлүгүнүн организмдердин жашоосуна тийгизген таасири '], ['question_id' => 8, 'uid' => generate_id(), 'answer' => 0, 'text' => 'Абанын мүнөзүнүн организмдердин жашоосуна тийгизген таасири '], ['question_id' => 8, 'uid' => generate_id(), 'answer' => 0, 'text' => 'Климаттын мүнөзүнүн организмдердин жашоосуна тийгизген таасири'], ['question_id' => 9, 'uid' => generate_id(), 'answer' => 1, 'text' => 'Түрдүн географиялык ареалын аныктайт'], ['question_id' => 9, 'uid' => generate_id(), 'answer' => 0, 'text' => 'Түрдүн тиргиликте калуу жөндөмдүүлүгүн аныктайт'], ['question_id' => 9, 'uid' => generate_id(), 'answer' => 0, 'text' => 'Түрдүн көбөйүү денгээлин чектейт'], ['question_id' => 10, 'uid' => generate_id(), 'answer' => 1, 'text' => 'Толеранттулук чектери кең болгон организмдер'], ['question_id' => 10, 'uid' => generate_id(), 'answer' => 0, 'text' => 'Толеранттулук чектери тар болгон организмдер'], ['question_id' => 10, 'uid' => generate_id(), 'answer' => 0, 'text' => 'Биосферанын ар кыл чектеринде тараган организмдер'], ['question_id' => 11, 'uid' => generate_id(), 'answer' => 1, 'text' => 'В.Сукачев'], ['question_id' => 11, 'uid' => generate_id(), 'answer' => 0, 'text' => 'А.Тенсли '], ['question_id' => 11, 'uid' => generate_id(), 'answer' => 0, 'text' => 'А. Громов'], ['question_id' => 12, 'uid' => generate_id(), 'answer' => 1, 'text' => 'А.Тенсли'], ['question_id' => 12, 'uid' => generate_id(), 'answer' => 0, 'text' => 'В.Сукачев'], ['question_id' => 12, 'uid' => generate_id(), 'answer' => 0, 'text' => 'Э.Геккель '], ['question_id' => 13, 'uid' => generate_id(), 'answer' => 1, 'text' => 'Суунун түбүндө жашоочулар'], ['question_id' => 13, 'uid' => generate_id(), 'answer' => 0, 'text' => 'Суунун катмарында жашоочулар'], ['question_id' => 13, 'uid' => generate_id(), 'answer' => 0, 'text' => 'Сууда чырмашып өсүүчүлөр'], ['question_id' => 14, 'uid' => generate_id(), 'answer' => 1, 'text' => 'Даяр органикалык зат менен азыктануучулар'], ['question_id' => 14, 'uid' => generate_id(), 'answer' => 0, 'text' => 'Органикалык эмес заттан органикалык затты синтездөөчү организмдер'], ['question_id' => 14, 'uid' => generate_id(), 'answer' => 0, 'text' => 'Органикалык затты бузуучулар'], ['question_id' => 15, 'uid' => generate_id(), 'answer' => 1, 'text' => 'Бир экосистеманын башка экосистема менен ырааттуу түрдө алмашуусу'], ['question_id' => 15, 'uid' => generate_id(), 'answer' => 0, 'text' => 'Экосистеманын көп түрдүүлүгү жана чыдамкайлуулугу'], ['question_id' => 15, 'uid' => generate_id(), 'answer' => 0, 'text' => 'Бир экосистеманын агроландшафтка айлануусу'], ['question_id' => 16, 'uid' => generate_id(), 'answer' => 1, 'text' => 'Жандуу организмдер жайгашкан катмар'], ['question_id' => 16, 'uid' => generate_id(), 'answer' => 0, 'text' => 'Жандуу организмдер менен жансыз организмдердин карым катнашы'], ['question_id' => 16, 'uid' => generate_id(), 'answer' => 0, 'text' => 'Жансыз заттардын катмары'], ['question_id' => 17, 'uid' => generate_id(), 'answer' => 1, 'text' => 'Пайда болушуна тирүү организмдер катышпаган заттардын тобу '], ['question_id' => 17, 'uid' => generate_id(), 'answer' => 0, 'text' => 'Пайда болушуна тирүү организмдер катышкан заттардын тобу '], ['question_id' => 17, 'uid' => generate_id(), 'answer' => 0, 'text' => 'Тирүү организмдер тарабынан курулган заттардын тобу'], ['question_id' => 18, 'uid' => generate_id(), 'answer' => 1, 'text' => 'Тирүү организмдер тарабынан түзүлгөн жана иштелип чыккан заттардын жыйындысы'], ['question_id' => 18, 'uid' => generate_id(), 'answer' => 0, 'text' => 'Тирүү жана костук заттардын динамикалык тең салмактуулугун системаны чагылдырган заттар '], ['question_id' => 18, 'uid' => generate_id(), 'answer' => 0, 'text' => 'Радиоактивдүү ажыроо абалында турган изотоптук элементтердин жыйындысы'], ['question_id' => 19, 'uid' => generate_id(), 'answer' => 1, 'text' => 'Асылдуулукка ээ болгон, физикалык, химиялык жана биологиялык факторлордун таасири астында пайда болгон жер кыртышынын үстүнкү катмары'], ['question_id' => 19, 'uid' => generate_id(), 'answer' => 0, 'text' => 'Физикалык жана химиялык факторлордун таасири астында пайда болгон жер кыртышынын үстүнкү катмары'], ['question_id' => 19, 'uid' => generate_id(), 'answer' => 0, 'text' => 'Гидросфера менен чектеш литосфераны үстүнкү катмары'], ['question_id' => 20, 'uid' => generate_id(), 'answer' => 1, 'text' => 'Муундардын алмашып туруусу'], ['question_id' => 20, 'uid' => generate_id(), 'answer' => 0, 'text' => 'Химиялык курамынын туруктуулугу'], ['question_id' => 20, 'uid' => generate_id(), 'answer' => 0, 'text' => 'Физикалык факторлорго чыдамдуулугу']]);
}
$factory->define(\Model\Section\Section::class, function ($faker) {
$courses = \Model\Course\Course::all();
$course = random_array($courses);
return ['course_id' => $course->id(), 'name' => $faker->unique()->word, 'description' => $faker->sentence(rand(3, 12)), 'published' => true];
});
$factory->define(\Model\Note\Note::class, function ($faker) {
$sections = \Model\Section\Section::all();
$section = random_array($sections);
$users = \Model\User\User::all();
$user = random_array($users);
return ['section_id' => $section->id(), 'name' => $faker->unique()->word, 'description' => $faker->sentence(rand(3, 12)), 'published' => true];
});
$factory->define(\Model\Question\Question::class, function ($faker) {
// $exams = \Model\Exam\Exam::all();
// $exam = random_array($exams);
$sections = \Model\Section\Section::where('course_id', '=', 2)->get();
//course_id = 2 is ekloji course
$section = random_array($sections);
return ['uid' => generate_id(), 'section_id' => $section->id(), 'text' => $faker->unique()->sentence(), 'description' => $faker->unique()->paragraph(), 'timer' => random_array([30, 40, 50, 60, 70, 80, 90, 100, 110, 120, 130, 140, 150, 160, 170, 180, 190, 200])];
});
$factory->define(\Model\Answer\Answer::class, function ($faker) {
$questions = \Model\Question\Question::all();
$question = random_array($questions);
return ['uid' => generate_id(), 'question_id' => $question->id(), 'text' => $faker->unique()->sentence(), 'description' => $faker->unique()->sentence()];
});
$factory->define(\Model\Exam\Exam::class, function ($faker) {
$sections = \Model\Section\Section::where('course_id', '=', 2)->get();
//course_id = 2 is ekloji course
$section = random_array($sections);
return ['uid' => generate_id(), 'section_id' => $section->id(), 'text' => $faker->unique()->sentence(), 'description' => $faker->unique()->sentence()];
});
function add_visitor(&$C)
{
while (true) {
$visitor_id = generate_id();
$q = sprintf('INSERT INTO visitors
SET id = %s', $C->dbh->quoteSmart($visitor_id));
error_log(preg_replace('/\\s+/', ' ', $q));
$res = $C->dbh->query($q);
if (PEAR::isError($res)) {
if ($res->getCode() == DB_ERROR_ALREADY_EXISTS) {
continue;
}
die_with_code(500, "{$res->message}\n{$q}\n");
}
return get_visitor($C, $visitor_id);
}
}
<?php
// If we are saving, then save and close the window.
//
if ($_POST['form_save']) {
$ins_id = '';
$ins_name = $_POST['form_name'];
if ($ins_id) {
// sql for updating could go here if this script is enhanced to support
// editing of existing insurance companies.
} else {
$ins_id = generate_id();
sqlInsert("INSERT INTO insurance_companies ( " . "id, name, attn, cms_id, freeb_type, x12_receiver_id, x12_default_partner_id " . ") VALUES ( " . $ins_id . ", " . "'" . $ins_name . "', " . "'" . $_POST['form_attn'] . "', " . "'" . $_POST['form_cms_id'] . "', " . "'" . $_POST['form_freeb_type'] . "', " . "'" . $_POST['form_partner'] . "', " . "'" . $_POST['form_partner'] . "' " . ")");
sqlInsert("INSERT INTO addresses ( " . "id, line1, line2, city, state, zip, country, foreign_id " . ") VALUES ( " . generate_id() . ", " . "'" . $_POST['form_addr1'] . "', " . "'" . $_POST['form_addr2'] . "', " . "'" . $_POST['form_city'] . "', " . "'" . $_POST['form_state'] . "', " . "'" . $_POST['form_zip'] . "', " . "'" . $_POST['form_country'] . "', " . $ins_id . " " . ")");
$phone_parts = array();
preg_match("/(\\d\\d\\d)\\D*(\\d\\d\\d)\\D*(\\d\\d\\d\\d)/", $_POST['form_phone'], $phone_parts);
sqlInsert("INSERT INTO phone_numbers ( " . "id, country_code, area_code, prefix, number, type, foreign_id " . ") VALUES ( " . generate_id() . ", " . "'+1'" . ", " . "'" . $phone_parts[1] . "', " . "'" . $phone_parts[2] . "', " . "'" . $phone_parts[3] . "', " . "'2'" . ", " . $ins_id . " " . ")");
}
// Close this window and tell our opener to select the new company.
//
echo "<script language='JavaScript'>\n";
if ($info_msg) {
echo " alert('{$info_msg}');\n";
}
echo " parent.\$.fn.fancybox.close();\n";
echo " top.restoreSession();\n";
echo " if (parent.set_insurance) parent.set_insurance({$ins_id},'{$ins_name}');\n";
echo "</script></body></html>\n";
exit;
}
// Query x12_partners.
$xres = sqlStatement("SELECT id, name FROM x12_partners ORDER BY name");
}
// run the word filter
if ($system->SETTINGS['wordsfilter'] == 'y') {
$TPL_title_value = $title = $system->filter($title);
$TPL_description_shown_value = $description = $system->filter($description);
}
// check for errors
if ($ERR == "ERR_") {
$ERR = "ERR_" . CheckSellData();
if ($ERR != "ERR_") {
$_SESSION['action'] = 1;
$noerror = false;
}
}
if ($noerror) {
$auction_id = generate_id();
if ($imgtype == 1 && !empty($_FILES['userfile']['name']) && $_FILES['userfile']['name'] != "none") {
$inf = getimagesize($_FILES['userfile']['tmp_name']);
$er = false;
if ($inf) {
$inf[2] = intval($inf[2]);
if ($inf[2] < 1 || $inf[2] > 3) {
$er = true;
$ERR = "ERR_602";
} elseif (intval($userfile_size) > $system->SETTINGS['maxuploadsize']) {
$er = true;
$ERR = "ERR_603";
} else {
switch ($inf[2]) {
case 1:
$ext = ".gif";
$onset_date = isset($_POST['form_onset_date']) ? $_POST['form_onset_date'] : '';
$sensitivity = isset($_POST['form_sensitivity']) ? $_POST['form_sensitivity'] : '';
$pc_catid = isset($_POST['pc_catid']) ? $_POST['pc_catid'] : '';
$facility_id = isset($_POST['facility_id']) ? $_POST['facility_id'] : '';
$billing_facility = isset($_POST['billing_facility']) ? $_POST['billing_facility'] : '';
$reason = isset($_POST['reason']) ? $_POST['reason'] : '';
$mode = isset($_POST['mode']) ? $_POST['mode'] : '';
$referral_source = isset($_POST['form_referral_source']) ? $_POST['form_referral_source'] : '';
$pos_code = isset($_POST['pos_code']) ? $_POST['pos_code'] : '';
$facilityresult = sqlQuery("select name FROM facility WHERE id = ?", array($facility_id));
$facility = $facilityresult['name'];
$normalurl = "patient_file/encounter/encounter_top.php";
$nexturl = $normalurl;
if ($mode == 'new') {
$provider_id = $userauthorized ? $_SESSION['authUserID'] : 0;
$encounter = generate_id();
addForm($encounter, "New Patient Encounter", sqlInsert("INSERT INTO form_encounter SET " . "date = '" . add_escape_custom($date) . "', " . "onset_date = '" . add_escape_custom($onset_date) . "', " . "reason = '" . add_escape_custom($reason) . "', " . "facility = '" . add_escape_custom($facility) . "', " . "pc_catid = '" . add_escape_custom($pc_catid) . "', " . "facility_id = '" . add_escape_custom($facility_id) . "', " . "billing_facility = '" . add_escape_custom($billing_facility) . "', " . "sensitivity = '" . add_escape_custom($sensitivity) . "', " . "referral_source = '" . add_escape_custom($referral_source) . "', " . "pid = '" . add_escape_custom($pid) . "', " . "encounter = '" . add_escape_custom($encounter) . "', " . "pos_code = '" . add_escape_custom($pos_code) . "', " . "provider_id = '" . add_escape_custom($provider_id) . "'"), "newpatient", $pid, $userauthorized, $date);
} else {
if ($mode == 'update') {
$id = $_POST["id"];
$result = sqlQuery("SELECT encounter, sensitivity FROM form_encounter WHERE id = ?", array($id));
if ($result['sensitivity'] && !acl_check('sensitivities', $result['sensitivity'])) {
die(xlt("You are not authorized to see this encounter."));
}
$encounter = $result['encounter'];
// See view.php to allow or disallow updates of the encounter date.
$datepart = acl_check('encounters', 'date_a') ? "date = '" . add_escape_custom($date) . "', " : "";
sqlStatement("UPDATE form_encounter SET " . $datepart . "onset_date = '" . add_escape_custom($onset_date) . "', " . "reason = '" . add_escape_custom($reason) . "', " . "facility = '" . add_escape_custom($facility) . "', " . "pc_catid = '" . add_escape_custom($pc_catid) . "', " . "facility_id = '" . add_escape_custom($facility_id) . "', " . "billing_facility = '" . add_escape_custom($billing_facility) . "', " . "sensitivity = '" . add_escape_custom($sensitivity) . "', " . "referral_source = '" . add_escape_custom($referral_source) . "', " . "pos_code = '" . add_escape_custom($pos_code) . "' " . "WHERE id = '" . add_escape_custom($id) . "'");
} else {
die("Unknown mode '" . text($mode) . "'");
}
<?php
$id = generate_id('file');
$now = time();
$ext = '';
$dir = '00';
if (preg_match('/file\\..+\\.(\\d\\d)/', $id, $matches)) {
$dir = $matches[1];
}
if (preg_match('/\\.(.+)$/', $params['original'], $matches)) {
$ext = '.' . strtolower($matches[1]);
if ($ext == '.jpeg') {
$ext = '.jpg';
}
}
if (!file_exists(GRID_DIR . "/public/uploads/{$dir}")) {
mkdir(GRID_DIR . "/public/uploads/{$dir}");
}
$path = "{$dir}/{$id}{$ext}";
$filename = str_replace('..', '', $params['filename']);
rename(GRID_DIR . "/public/uploads/tmp/{$filename}", GRID_DIR . "/public/uploads/{$path}");
$grid->db->insert('file', array('id' => $id, 'user_id' => $grid->user->id, 'name' => $params['name'], 'type' => $params['type'], 'path' => $path, 'original' => $params['original'], 'server_id' => $grid->meta['server_id'], 'created' => $now, 'updated' => $now));
if (!empty($_POST['username']) && $grid->user->name != $_POST['username']) {
$update = array('name' => $_POST['username'], 'updated' => $now);
$grid->db->update('user', $update, $grid->user->id);
}
$this->redirect(GRID_URL);
