https://wiki.rene.ee/ 2026-04-30T14:21:35+00:00 https://wiki.rene.ee/ https://wiki.rene.ee/lib/exe/fetch.php?media=wiki:dokuwiki.svg text/html 2019-09-20T12:52:58+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.rene.ee/doku.php?id=prog:ajax&rev=1568983978&do=diff XAJAX SuggestX Configuration TODO BUGS * peaks olema võimalik määrata aega, mille jooksul uusi päringuid ei tehta (kiiresti trükkimisel). this.sgx_timeOut mõte on hoopis muu!!! * kui multiselect väljal vahepealt osad valikud kustutada, siis extra field-de kustutamine ei toimi text/html 2019-09-20T12:52:58+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.rene.ee/doku.php?id=prog:fwk&rev=1568983978&do=diff TODO * Tõlkimise võimalus!!! * Smarty * failide kommentaarides IPDB, VBM jne -> FWK * muutujate nimedes ja failide nimedes IPDB, VBM jne -> FWK * CVS kataloogid ära * pluginad eraldada (õiguste süsteem, XML-RPC, AJAX, LDAP, dünaamilised/staatilised menüüd) text/html 2019-09-20T12:52:58+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.rene.ee/doku.php?id=prog:html&rev=1568983978&do=diff Bordered table with CSS table.inline{ background-color:#ffffff; border-spacing:0px; border-collapse:collapse; } table.inline th{ padding:3px; border:1px solid #000000; background-color:gray; } table.inline td{ padding:3px; border:1px solid #000000; } text/html 2019-09-20T12:52:58+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.rene.ee/doku.php?id=prog:js.picture_changer&rev=1568983978&do=diff <?php // leiame teatud kataloogis olevad pildid ning moodustame neist sobiva JS array $pics = scandir('gfx'); array_shift($pics); array_shift($pics); $pics_js = "var pics = Array('".implode("','", $pics)."');"; ?> <script type="text/javascript"> // var pics = Array( // 'img1.jpg', // 'img2.jpg', // 'img3.jpg' // ); <?php echo $pics_js; ?> var currPic = 0; var lastPic = pics.length - 1; function ScrollToNextPicture() { if (currPic == lastPic) currPic = 0; el… text/html 2019-09-20T12:52:58+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.rene.ee/doku.php?id=prog:js&rev=1568983978&do=diff Lingid * file upload kasti modimine * How to hide windowed elements * How to hide windowed elements * <http://www.softcomplex.com/> - palju lahedaid ja hästi tehtud JS tükke (puu, color-picker, hints, scrolling, slider jne) Funktsioonid addLoadEvent() Võimaldab lisada 1..n uut onLoad handlerit ilma eelmisi ülekirjutamata. function addLoadEvent(func) { var oldonload = window.onload; if (typeof window.onload != 'function') { window.onload = func; } else { window.onload … text/html 2019-09-20T12:52:58+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.rene.ee/doku.php?id=prog:mysql&rev=1568983978&do=diff * encodingu määramine: CREATE TABLE unicode_stuff ( ... ) CHARACTER SET utf8; CREATE TABLE intl_strings ( id INTEGER UNSIGNED AUTO_INCREMENT PRIMARY KEY, german_string VARCHAR(255) CHARACTER SET latin1, japanese_string VARCHAR(255) CHARACTER SET utf8, enlish_us_string VARCHAR(255) CHARACTER SET latin1, chinese_string VARCHAR(255) CHARACTER SET big5 ); text/html 2019-09-20T12:52:58+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.rene.ee/doku.php?id=prog:oracle&rev=1568983978&do=diff Schema Lisa tabelisse veerg koos foregin key-ga: alter table ipdb.ports add rootdevice_id number(9) references ipdb.devices(device_id) not null; Eemalda veerg: alter table ipdb.ports drop column root_device_id; Lisa tabel: CREATE TABLE ipdb.vlan_connections ( vlan_connection_id NUMBER (9) primary key, connection1_id NUMBER (9) references ipdb.connections(connection_id), connection2_id NUMBER (9) … text/html 2019-09-20T12:52:58+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.rene.ee/doku.php?id=prog:perl&rev=1568983978&do=diff my @clients = ( ["rakvere", "viktor.kruuse\@elion.ee"], ["varulinn", "rene.bernard\@elion.ee"] ); for ($i = 0; $i < scalar(@clients); $i++) { print $clients[$i][1]; } text/html 2022-03-29T15:00:43+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.rene.ee/doku.php?id=prog:php&rev=1648566043&do=diff * Smarty Librarys * CSV (PEAR::File) * FPDF - free PDF generator Functions * generate_csv - moodustab array põhjal CSV formaadis stringi * dijkstra - Dijkstra graafi algoritmi realisatsioon * ipv6_full_uncompress - Teeb IPv6 aadressi nii pikaks kui v6imalik. N2ide: 2001::67:a --> 2001:0000:0000:0000:0000:0000:0067:000a * text/html 2019-09-20T12:52:58+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.rene.ee/doku.php?id=prog:pl_pgsql&rev=1568983978&do=diff Baasist funktsiooni body saamine SELECT proname, pr.prosrc FROM pg_proc pr, pg_type tp WHERE tp.oid = pr.prorettype AND pr.proisagg = FALSE AND tp.typname <> 'trigger' AND pr.pronamespace IN ( SELECT oid FROM pg_namespace WHERE nspname NOT LIKE 'pg_%' AND nspname != 'information_schema' ); text/html 2022-06-14T13:40:43+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.rene.ee/doku.php?id=prog:postgres&rev=1655214043&do=diff ALTER TABLE alter table haaletus add column modified timestamp; alter table haaletus alter column modified set default now(); update haaletus set modified = aeg; alter table haaletus alter column modified set not null; alter table haaletustabel alter column id set default nextval('item_id_seq'::text); update haaletustabel set id = nextval('item_id_seq'::text); text/html 2019-10-10T07:27:10+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.rene.ee/doku.php?id=prog:prometheus&rev=1570692430&do=diff Prometheus Blackbox exporter Enables to set up a probe that monitors HTTP request for example. Prometheus itself can't do API endpoint monitoring - it can only ask results from probes. <https://github.com/prometheus/blackbox_exporter> You can just download the binary and run it on your server. It will be available on a configured port. In the blackbox directory is blackbox.yml file with configurations of different monitoring options. The text/html 2019-09-20T12:52:58+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.rene.ee/doku.php?id=prog:python&rev=1568983978&do=diff Stringitöötlus <http://docs.python.org/lib/string-methods.html> strip >>> ' spacious '.lstrip() 'spacious ' >>> 'www.example.com'.lstrip('cmowz.') 'example.com' Näited Strings * <http://www.python.org/doc/current/lib/string-methods.html> ### >>> word = 'Help' + 'A' >>> word[4] 'A' >>> word[0:2] 'He' >>> word[2:4] 'lp' >>> word[:2] # The first two characters 'He' >>> word[2:] # Everything except the first two characters 'lpA' >>> word[-1] # The last cha… text/html 2019-09-20T12:52:58+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.rene.ee/doku.php?id=prog:shell&rev=1568983978&do=diff Luku kasutamine croni skriptis #!/bin/bash cd /opt/ipdbd if [ -f crontask.lock ] ; then exit 0 fi touch crontask.lock python2.4 crontask.py >> crontask.log rm -f crontask.lock Scripti parameetrite kasutamine ja kontrollimine #!/bin/bash if [ -z "$1" ]; then echo "Please add device_id as first parameter! This is NOT the hardware serial!"; exit 0; fi if [ -z "$2" ]; then echo "Please add date of interest as second parameter!"; exit 0; fi echo "$2" > /tmp/$1 chmod … text/html 2019-09-20T12:52:58+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.rene.ee/doku.php?id=prog:smarty&rev=1568983978&do=diff {$smarty.now|date_format:"<b>%H:%M</b> %d.%m.%Y "} text/html 2019-09-20T12:52:58+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.rene.ee/doku.php?id=prog:zend&rev=1568983978&do=diff Installimine * laadida alla Zend Server (/tmp kausta): <http://framework.zend.com/download/current/> * installimine: sudo -s cd /tmp tar -xvvzf ZendServer-4.0.6-RepositoryInstaller-linux.tar.gz cd ZendServer-RepositoryInstaller-linux/ ./install_zs.sh 5.2 ce * aliased: vim ~/.bashrc alias apache2-restart='/etc/init.d/apache2 restart' alias zend="cd /usr/local/zend/share/ZendFramework/bin/" alias zf="/usr/local/zend/share/ZendFramework/bin/zf.sh"