Archive for July 2009

is sql language really needed to c-like language to work with db

I have asked about this in ##php channel in FreeNode irc network. after i have said these my thoughts now i feel i have more right to learn sql. This is that talk in ##php with irrelevant said phrases, talked about other theme, deleted:
July 10 17:51:48 <qdb>    i do not understand why this additional sql layer is needed. cannot php s normal function and object interface work well with db?
July 10 17:52:07 <qdb>    for that i do not want to learn sql, like lazy
July 10 17:52:23 <Naktibalda>    qdb: use text files or some non-relational database 🙂
July 10 17:52:32 <Naktibalda>    they are popular now
July 10 17:53:06 <qdb>    Naktibalda, can you say that sql language can do something that normal if-then/for/functions/etc cannot do?
July 10 17:53:28 <Naktibalda>    qdb: than you have to implement database engine in PHP
July 10 17:53:29 <PoPSiCLe>    qdb: you need to actually… connect to some sort of DB…?
July 10 17:53:40 <qdb>    (or other people than Naktibalda )
July 10 17:53:54 <Naktibalda>    qdb: have you heard abour ORM?
July 10 17:54:14 <qdb>    Naktibalda, PoPSiCLe , for example, table is just an array ?
July 10 17:54:20 <qdb>    no
July 10 17:54:53 <Naktibalda>
July 10 17:55:00 <qdb>    may be object that has functions additional to normal access wby indexes
July 10 17:56:03 <Naktibalda>    qdb:
July 10 17:56:07 <qdb>    yes that is the idea
July 10 17:57:36 <qdb>    but this mapping use sql inside them aren’t they?
July 10 17:57:42 <cythrawll>    yes

how to install muckl 0.4.4


in muckl.html modify these:

find this which is at line 703:

// create a unique resource
if (typeof(ANONHOST) == 'undefined')
jid += '/' + hex_sha1(navigator.userAgent + Date.UTC(new Date()) + nick);

comment it out:

// create a unique resource
if (typeof(ANONHOST) == 'undefined')
  jid += '/' + hex_sha1(navigator.userAgent + Date.UTC(new Date()) + nick);

and add the code another way, it will look so, with commented out old code:

// create a unique resource
if (typeof(ANONHOST) == 'undefined')
  jid += '/' + hex_sha1(navigator.userAgent + Date.UTC(new Date()) + nick);
if (typeof(ANONHOST) == 'undefined') {
  var ts = new Date();
  jid += '/' +
      navigator.userAgent +
      Date.UTC(ts.getFullYear(), ts.getMonth(), ts.getDate(), ts.getHours(), ts.getMinutes(), ts.getSeconds()) +

>i add at 2009-07-30: i have read about this patch at<
then find this near line 718, it is immediately after the code that i have just said:

/* get style */
if (opener && opener.myStyle)
  stylesheet = THEMESDIR + "/" + opener.myStyle + "/" + stylesheet;
else if (passedArgs['myStyle'])
  stylesheet = THEMESDIR + "/" + passedArgs['myStyle'] + "/" + stylesheet;

and comment it out:

/* get style */
/*if (opener && opener.myStyle)
  stylesheet = THEMESDIR + "/" + opener.myStyle + "/" + stylesheet;
else if (passedArgs['myStyle'])
  stylesheet = THEMESDIR + "/" + passedArgs['myStyle'] + "/" + stylesheet;

this code produced error message like “have not permission to get style” and it caused stopping of muckl on start.

then edit config.js file:
BACKENDTYPE option is set to polling by default. it does not work. it does not work with new firefoxes, as i remember. if you set it to binding it works with most of browsers. except konqueror and may be others like it.

var BACKENDTYPE = 'polling';

at line 31 and modify it like this:

//var BACKENDTYPE = 'polling';
var BACKENDTYPE = 'binding';

then find

var HTTPBASE = "/http-poll/";

at line 44 and modify it this way:

//var HTTPBASE = "/http-poll/";
var HTTPBASE = "/http-bind/";

may be you will need write another address instead of “/http-bind/”, according to what is set up on your jabber server or jabber to http-bind bridge/gate.

you can install muckl on external domain while jabber server is in internal domain, i have now installed it just so and

var XMPPDOMAIN = "localhost";

is not modified on my installation.

name and password:

var MUCKLJID = "muckl"; // username
var MUCKLPASS = "muckl"; // password

you should first create a user i.e. to register an account on the jabber server especially for muckl. i use for it user with name ccccc and with password 123456. name and password can be simple, because they are open through directly opening config.js file from browser (or saving and opening with text editor). i have modified this place this way:

//var MUCKLJID = "muckl"; // username
//var MUCKLPASS = "muckl"; // password
var MUCKLJID = "ccccc"; // username
var MUCKLPASS = "123456"; // password

then i have modified this place:

                description:'some room for testing',

i have written it this way:

                description:'Attention! <a href="" target="_blank">Sometimes talks are logged and published</a>!',

i have previously created that room which is at “name” field, “kukmara_region” in this example, and set it persistent, though if you do not set it persistent it also will work. but if it is persistent, you will be “owner” of the room. if it is not persistent, then if all people quit the room and somebody enters it first then, he will became owner, because he creates room, because when all people quit, room is destroyed if it is not persistent.
do not use that muckl’s account (ccccc in this example) to create the room.
also i have written that talks may be published here and link to the published talks, this description appear at login page before user enters, so he can select appropriate username and look at published talks before he enters the room.
i have used name of room with bottom line character instead of space, as i remember i could not create room with space in name using pidgin, may be it is restriction of jabber/xmpp but i am not sure now, may be it is possible to create room with space in name using other jabber client program.

also i have made several modifications in html files in my installations:
link to main site at top left corner of login page,
“switch to russian language” link under login rectangle which is with rounded corners, also made it in span tag with switching in onclick attribute in another installation of the chat,
“instruction” link near sound and exit icons in chat,
“sometimes is published” attention again in right side from “send” button.

Etymology of “earth” and “great groups of words”

I have posted this in i add at 22:05 (utc+4, summer moscow time): this post is deleted again in the web-forum. i had written it several times after post #73 in Etymology: Earth topic and it was deleted several times with leaving place of post and reason, now they are deleted completely.
Hello. In tatar(a turkic) language it is “jir” (written “җир”). It is quite similar to “terra” and “ge”. There are also words “yir”(written “ер” pronunciated “йыр”) and “yor” (written “йөр”, means “walk”, “go”). “yir” means to go pushing something to right and left side by bottom part and may be right and left sides and may be destroying that material, can be used with melt(?) erth, mud(?) and with water (to go in not deep water) and with grass and with grass that cutten off and lay on earth and anything that is such/enough soft . “y” and “j” sounds often replaced in modern tatar language in different places and people. May be that “jir” is from sound of going through such material and also it is like sound of ploughing, plowing(?). “yir” can also become ” ‘ard ” tis way: beginning “y” becomes ” ‘ ” (hamza, written in arabic “ء” and this sound is in french language as i know: d’… . ) and very old and common “t” suffix added and made noun/past participle from verb. And yir-t meant “what appears after ‘yir’ing” and it is earth which indeed become visible itself only if to push to sides grass or if plough or dig top layer of earth with grass and roots of grass. What I think about t suffix: it has modified to forms “n” and “l” also. “-ed”,”-et”,”-ne” makes past simple and past participle in english: lef-t, go-ne, “-do”-“-to”-“-di”-“-ti” makes form like past simple or present perfect in tatar: yor-do, “-l” makes form like past simple or present perfect in russian: sdela-l, dela-l. also that “yir” word is in a great group of words with meanings like strew, comb, spread, open and derived from them and pronunciations like tar, sar, taz, saz, nar, yar, naz, yaz, tes, res etc. For example may be english words say, sail, sale, sand are in this group. Some of these words i have collected in my notebook: — – i delete address this time because moderator says it is self promotion but i still think it is link to material , you can browse other pages and djvu format version of it from — page on that site and there is mirror of the site address of which i do not post this time .
Words with meaning “red” could be derived from words meaning “earth” as color of earth. Among them also tatar “saro”, english “yellow”, russian “zeltiy” which mean “yellow”; and english “gray” and tatar “soro” and russian “seriy” which mean “grey”; and russian “korichneviy” which means “brown”; and english “red” and tatar “qizil” and russian “krasniy” which mean “red”. By the way words meaning “green” are also in that group of words but they are as color of grass and words meaning grass are in that group together with words meaning hair etc like them because they are something that spread their branches. (Hair is “chach” in tatar, grass is “chiram” in tatar and “trava” in russian, green is “zeleniy” in russian and “yashil” in tatar.)
By the way this group of word are together because all they have sound of t-r-d-z-s-y-n-l group of sounds as first and last-third consonant and some almost any vowel as second-middle vowel. also that consonants can modify to k-g-q from s-ch and from y and can modify to w from y and q-g and then w can modify to b-p-f-v , words with b-p-f-v derived such way from d-z-r-l-n are rare, i think.
If to take to account that group of sounds, ‘ar part of ‘ard and ear part of earth are in that “great group of words”. Also rd part of ‘ard and rth part of earth can be root part of them and they also in that group of words.
Another great group of words (that (also) i have found/have found myself) are “sap”-“qap” group of words which appeared from sound of closing something or stepping foot to earth or stone.
I will post this also to my english blog link to which i do not dare to post because moderator already has deleted one my post.
Please do not delete my links (or post)… Now there is no link….

End of post as it is at the web-forum.

You can see that great group of words like “ser” at You can browse pages of that notebook in gif and djvu formats at There is mirror of this site at

several words that are similar in english and tatar languages

you can see them also in or or or and also on other pages of that notebook. it is possible to browse pages of it in or

be – bul- , golden – alton

in the next page:

slimy – silagay,

english: spit-spew-sputter-sprinkle-spray – tatar: chapchira, sip .

degree-daraja (daraja is probably arabic word)

english: day-dawn – tatar: tan – russian: day.

get – jit

pass- bas,bar – russian dobratsa – english/russian/tatar port – russian pol and pad-

bring – bir – russian брать(but meaning is to another direction)

cheek – russian shcheka – tatar chiga(means temple) – russian shkura (skin) – skin – tatar chik (boundary)

hand – qul

quit – kit

hack – qaq

fade – bit-,bat- – russian pad-

chop – chap

curse – qarga

draw – tart

dust – tuzan

damp – dm

utter – uta (though may be it is new word)

morn,born – boron