[00:01] ok thanks [00:01] oh one more thing [00:01] is there like a recommended settings file or webpage somewhere? There's alot of settings in this thing lol [00:06] *** Bartos has quit IRC ("CGI:IRC (EOF)") [00:22] lq_239: Define "this thing". There are a lot of things. [00:24] Anyone know why TW 2.2 tiki-download_file.php might emit files of size zero? File permissions are OK, and browser thinks it is downloading a file. [00:30] *** franck has joined #tikiwiki [00:31] *** franck_ has quit IRC (Read error: 60 (Operation timed out)) [00:32] *** lq_239 has quit IRC ("CGI:IRC (EOF)") [00:53] *** franck_ has joined #tikiwiki [01:07] *** franck has quit IRC (Read error: 113 (No route to host)) [01:09] *** franck has joined #tikiwiki [01:21] *** Amorphous has quit IRC (Read error: 104 (Connection reset by peer)) [01:25] *** SEWilco21 has quit IRC ("Leaving.") [01:25] *** SEWilco2 has joined #tikiwiki [01:26] My MP4 files have NULL filetype in the database. Where are file types identified? [01:31] *** franck_ has quit IRC (Read error: 110 (Connection timed out)) [01:41] *** Amorphous has joined #tikiwiki [01:49] *** Caarrie|away is now known as Caarrie [02:19] Great. File types are being determined by suffix. OK, changed to .mpeg and it now downloads. [02:21] Well, it kind of downloads. Doesn't download as "dl123" but does as "podcasts/lsdjfslfsdfldfkjdslfjsdf", and as a BIN file instead of MPEG. [02:21] I see the filename is missing .mpeg extension. [02:37] Oh, a bug. TW 2.2 file_upload.php tests for .mp4 but .mp4 is not in the mime list. Fixed.. but still size zero on download. [02:37] Are TW 2.2 podcast downloads sensitive to spaces in file names? [03:08] *** Caarrie is now known as Caarrie|sleeping [05:53] *** navster has joined #tikiwiki [08:18] tikiwiki: 03pkdille * r16769 10/trunk/lang/fr/language.php: [MOD] french translation file : get_strings + some translations [09:30] *** Yoni has joined #tikiwiki [09:30] hi all [09:47] *** Lucymoz has quit IRC (Read error: 110 (Connection timed out)) [10:59] *** tomb_ has quit IRC (Remote closed the connection) [11:06] *** [Bart] has joined #tikiwiki [11:07] <[Bart]> Hi, I've used '{wiki}{literal}{GOOGLEANALYTICS(account=UA-(CODE))}{/literal}{/wiki} in my tikiwiki as custom end of code,but still don't get anything in google analytics. Do I miss something [11:16] <[Bart]> never mind [11:17] <[Bart]> found it [11:22] *** [Bart] has quit IRC ("CGI:IRC") [11:25] tikiwiki: 03chibaguy * r16770 10/trunk/templates/ (tiki-read_article.tpl tiki-view_articles.tpl): [ENH] Layout tables replaced with divs and spans; anchor class changed for uniformity. [11:30] tikiwiki: 03chibaguy * r16771 10/trunk/templates/ (blog-heading.tpl tiki-view_blog.tpl): [ENH] Blog title changed from div to h1 for uniformity; "breadcrumbs" added; title for tag list. [12:13] *** idle- has joined #tikiwiki [12:14] hi, I've some intersting requests here: [12:14] Request: /tiki-browse_gallery.php?offset=0&galleryid=1'%20and%201=2%20union%20select%20CONCAT(0x27,0x7c,0x5f,0x7c),CONCAT(0x27,0x7c,0x5f,0x7c),CONCAT(0x27,0x7c,0x5f,0x7c),CONCAT(0x27,0x7c,0x5f,0x7c),CONCAT(0x27,0x7c,0x5f,0x7c),CONCAT(0x27,0x7c,0x5f,0x7c),CONCAT(0x27,0x7c,0x5f,0x7c),CONCAT(0x27,0x7c,0x5f,0x7c),CONCAT(0x27,0x7c,0x5f,0x7c),CONCAT(0x27,0x7c,0x5f,0x7c),CONCAT(0x27,0x7c,0x5f,0x7c),CONCAT(0x27,0x7c,0x5f,0x7c),CONCAT(0x27,0x7c,0x5f, [12:14] User-Agent: NV32ts [12:14] Cookie: PHPSESSID=64e76fd7a68804bb8c03f94da795e7f0 [12:16] is it a possible security problem? [12:27] tikiwiki: 03chibaguy * r16772 10/trunk/templates/ (4 files): [FIX] Roll back if necessary, but link class="tableheading" didn't seem to have effect; style provided by "th a". [13:00] *** xavi has joined #tikiwiki [13:00] polom [13:00] here we are at http://tikiwiki.org/TikiFestMadrid [13:00] streaming from time to time [13:07] tikiwiki: 03chibaguy * r16773 10/trunk/ (13 files in 3 dirs): [NEW] Coelesce theme design by Patrick Allard for COE ui-revamp; initial commit of files adapted for trunk. [13:16] well done, Gary! [13:16] :-) [13:16] ^chibaguy [13:36] *** Caarrie|sleeping is now known as Caarrie|away [13:36] *** tomb has joined #tikiwiki [14:10] arffff off-air right now :) [14:12] *** Yoni has quit IRC () [14:24] *** danopia has joined #tikiwiki [14:47] tikiwiki: 03sylvieg * r16774 10/trunk/templates/tiki-admin_contribution.tpl: [MOD]contribution: better layout [14:52] broadcasting again [14:53] from TikiFestMadrid [14:53] tikiwiki: 03lphuberdeau * r16775 10/trunk/lib/wiki-plugins/wikiplugin_webservice.php: [FIX] Include path changes broke webservices [14:56] *** axold has joined #tikiwiki [14:56] so hello everybody from tikifest madrid [14:56] *** marclaporte has joined #tikiwiki [14:57] tikiwiki: 03chibaguy * r16776 10/trunk/ (24 files in 5 dirs): [NEW] Implementation of Strasa design by Patrick Allard; initial commit of files. [15:04] *** xavi has left [15:15] *** xavi has joined #tikiwiki [15:16] polom [15:46] *** aldo_ has joined #tikiwiki [15:47] *** xavi1 has joined #tikiwiki [15:47] *** marclaporte has quit IRC (Read error: 110 (Connection timed out)) [15:47] *** xavi has quit IRC (Read error: 110 (Connection timed out)) [15:48] *** xavi1 has left [15:48] *** axold has quit IRC (Read error: 110 (Connection timed out)) [15:54] *** xavi has joined #tikiwiki [15:59] *** lq_162 has joined #tikiwiki [16:01] tikiwiki: 03axold * r16777 10/trunk/tests/testfile.txt: I added a file in test directory [16:01] Has anyone had a problem with adminuser php loading properly everything else works fine. [16:01] *** marclaporte has joined #tikiwiki [16:03] tikiwiki: 03axold * r16778 10/trunk/tests/example.txt: I added a file in test directory [16:04] does any one know how to change the port for send mail my host does not support port 25? [16:06] tikiwiki: 03rlopezs * r16779 10/trunk/tests/messu-compose.tpl: Rober's first commit.From TikiFest Madrid [16:08] *** lq_162 has quit IRC ("CGI:IRC") [16:10] tikiwiki: 03matwho * r16780 10/trunk/tests/testfile.txt: a test [16:12] polom [16:13] polom [16:22] tikiwiki: 03matwho * r16781 10/trunk/tests/testfile.txt: a test [16:32] *** Caarrie|away has quit IRC ("rebooting") [16:44] *** Caarrie has joined #tikiwiki [16:47] *** xavi has quit IRC (Read error: 104 (Connection reset by peer)) [16:47] *** marclaporte has quit IRC (Read error: 104 (Connection reset by peer)) [16:47] *** aldo_ has quit IRC (Read error: 104 (Connection reset by peer)) [16:47] *** FrankP_german has joined #tikiwiki [17:04] *** aldo_ has joined #tikiwiki [17:05] *** xavi has joined #tikiwiki [17:07] *** lq_460 has joined #tikiwiki [17:08] *** Caarrie is now known as Caarrie|away [17:09] *** lq_473 has joined #tikiwiki [17:09] *** lq_473 has quit IRC (Client Quit) [17:24] *** marclaporte has joined #tikiwiki [17:37] *** lq_460 has quit IRC ("CGI:IRC (Ping timeout)") [17:45] hi [17:46] could this request be a possible security problem: /tiki-browse_gallery.php?offset=0&galleryid=1'%20and%201=2%20union%20select%20CONCAT(0x27,0x7c,0x5f,0x7c),CONCAT(0x27,0x7c,0x5f,0x7c),CONCAT(0x27,0x7c,0x5f,0x7c),CONCAT(0x27,0x7c,0x5f,0x7c),CONCAT(0x27,0x7c,0x5f,0x7c),CONCAT(0x27,0x7c,0x5f,0x7c),CONCAT(0x27,0x7c,0x5f,0x7c),CONCAT(0x27,0x7c,0x5f,0x7c),CONCAT(0x27,0x7c,0x5f,0x7c),CONCAT(0x27,0x7c,0x5f,0x7c),CONCAT(0x27,0x7c,0x5f,0x7c),CONCAT(0 [17:56] tikiwiki: 03marclaporte * r16782 10/trunk/templates/tiki-install.tpl: [FIX] dos2unix [17:58] tikiwiki: 03marclaporte * r16783 10/trunk/templates/tiki-install.tpl: [FIX] Making the password field use stars [18:08] *** marclaporte has quit IRC (Read error: 110 (Connection timed out)) [18:11] *** aldo_ has quit IRC (Read error: 110 (Connection timed out)) [18:11] *** xavi has quit IRC (Read error: 110 (Connection timed out)) [18:11] *** axold has joined #tikiwiki [18:12] *** xavi has joined #tikiwiki [18:13] *** tosi has joined #tikiwiki [18:13] hello guys [18:17] *** Iramon has joined #tikiwiki [18:17] anyone from tikifest madrid on here? [18:18] i have one question about tikiwiki import-users or their management. i would like to import a lot of users to tikiwiki from other system, where they are stored in the database and have encrypted password by md5. but i am not able to do so. if i add users through csv file, their passwords are encrypted again (hashed are again hashed). so i am able to create some db script for import, but there is a big problem with [18:20] *** navster has quit IRC () [18:20] hi lramon [18:20] yes [18:20] :) [18:20] we are still here [18:20] who are you? :-) [18:20] do we know each other? [18:20] sitting in the hostal bari? [18:20] *** marclaporte has joined #tikiwiki [18:21] hey marc :) [18:21] xavi: I talked to marc before, that I want to help, but can't come to madrid :/ [18:22] yes , we are still sitting here [18:22] :) [18:22] lramon, have you seen us at http://tikiwiki.org/TikiFestMadrid streaming? [18:23] you will even hear us, I think [18:23] now :D [18:23] right now we are very loud... (people is tired here....) [18:23] what's your name? [18:23] hey *wave* ^^ [18:23] real name, I man [18:23] Florian [18:23] I mean [18:24] where are you from? [18:24] germany [18:24] welcome, then. I pity you couldn't attend here... [18:24] yeah :/ [18:24] Ouh.... Ben (mangapowerx) speaks german! :-O [18:24] oh... nice t-shirts [18:25] I need such a shirt too :D [18:26] hi Iramon! [18:26] hi marc :) [18:27] omg... is everyone of you wearing a tiki t-shirt? [18:29] so if I can help somehow from here, let me know... if you're doing software modelling, brainstorming or whatever, I could get a headset e.g. [18:30] not right now any more. We feel like dinner time... [18:30] tomorrow, maybe [18:31] We'll do out best to have streaming again, with voice [18:31] ok :) [18:31] we'll do our best to update the page tw.o/TikiFestMadrid [18:31] when did you start today? [18:31] so se there if there is something you feel that you can/want to help with [18:32] ok I will check it tomorrow morning/noon [18:32] and now you're getting dinner and more drinks? ;) [18:33] yes, it looks like that [18:35] k, then bon apetite and have a lot of fun ;) [18:36] so bye... [18:36] *** xavi has left [18:37] *** baxz has joined #tikiwiki [18:38] *** baxz has quit IRC (Client Quit) [18:38] *** axold has quit IRC (Remote closed the connection) [18:39] *** tosi has quit IRC ("CGI:IRC") [18:52] *** Lucymoz has joined #tikiwiki [18:53] *** marclaporte has quit IRC ("Miranda IM! Smaller, Faster, Easier. http://miranda-im.org") [19:04] Solved my podcast problems. MIME types omitted some upload-accepted file suffixes, and TW 2.2 has a bug in download file directories. [19:09] idle-: Obviously someone is trying to insert SQL into a request. I don't know if browse-gallery is protected from SQL injection. [20:19] tikiwiki: 03pkdille * r16784 10/trunk/lang/fr/language.php: [MOD] french translation file : get_strings + some translations [20:43] *** lq_950 has joined #tikiwiki [20:44] Hello. I have a large number of items in my wiki database without categories assigned. Can someone explain to me how the category information is stored in the wiki database? [20:47] lq_950: If I recall correctly, there are tables for category info. [20:49] yeah I've looked at the tables but I can't make sense of it [20:49] how is it that the database tells the wiki what pages are within what category [20:50] in other words I can't seem to find how the categories are linked to the wiki pages [20:53] lq_950: Oh, I see what you mean. I thought that was in tiki_category_objects, but I don't see how that identifies objects of different types. Hmm. [20:54] lq_950: Oh, I think I see it. Look at tiki_objects. [20:55] lq_950: I'd have to check code to be certain, but I suspect "type" and "itemid" identify a kind of thing and the thing's id. Such as "articles","34" is a specific article. [20:55] ok checking it now. thanks [20:56] lq_950: The objectId is then used in tiki_category_objects to connect objects to categories. Probably. [20:57] lq_950: That's a guess based on the database. The code is the authority. [20:57] + tiki-category_object associatess categId and categObjectId , tiki_categorized_objects associates categObjectId and objectId [21:00] hi folks [21:01] Anything objections to me modifying the display of "new users" to include only those who have already confirmed their login? [21:02] err, well, broken language, but I guess you know what I mean... :-) [21:03] obnox: seems a good idea [21:04] sylvieg: the solution seems to be to extend the queries to check for "`provpass`=''" [21:05] I can not garanty that wihiout looking at the code - there is so many registration case.... [21:05] obnox: List a column "confirmed" Y/N? Allow sorting by columns? [21:06] well the confirm_user function sets provpass to '' [21:06] SEWilco2: that'd be nice,too [21:06] I was firstly thinking about the new_users feature in the modules/mod-since_last_visit* modules [21:07] Ok I've looked at how the stuff is linked. The problem is most of the items I have listed in tiki_pages are NOT listed in tiki_objects. What could be causing this? [21:07] SEWilco2: but as a next step the enhancement of the admin users page, yeah, I'm gonna look into that [21:16] lq_950: Don't know. Maybe tiki_objects isn't what we're looking for. Hmm. [21:16] It may be. I have a few items listed there [21:17] tiki_objects is filled up only when needed - first categ, or first freetag... [21:18] so there is no way I can link items in tiki_pages to a category in the database? [21:18] you have to create the tiki_objects line on the fly [21:20] lq_950: Oh. Categories are for linking things like an entire wiki page, not things within the wiki page. [21:20] ??? sorry I don't know what that means. [21:21] hmmm. The items in my tiki_pages are wiki pages, or will be. Could the problem be that alot of them are just blank pages at the moment? If I fill in some data would it place them in objects? [21:21] Looks to me as if tiki_objects is for things like links and images used in wiki pages. Not what I was thinking. [21:22] lq_950: If you're creating the items, why are you worried about the database instead of assigning categories to pages? [21:23] lq_950: I thought you were asking about the database because you were altering a program. [21:24] lq_950: Do you know how to assign a category to a page? On the edit page there is a text button-like thing to display a list of categories. [21:24] right now I have a bunch of pages created with no information in them [21:25] I was trying to go ahead and assign them to the proper category for now [21:25] yeah I know how to assign them 1 at a time. problem is I have roughly 4000 to assign [21:26] lq_950: I am not aware of a tool for assigning categories to pages. Interesting idea; an export/import format for category assignment. [21:27] lq_950: Did you find your categorized pages in tiki_objects? [21:27] yes [21:27] lq_950: And do the objectIds match those in the tiki_categor* tables? [21:27] http://mods.tikiwiki.org/details.php?type=goodies&mod=batch_load_pages not sure it is working [21:28] Thanks, sylvieg. If batch_load_pages doesn't include category info then maybe adding that to the existing format would be a way to start. [21:28] yeah they match. The problem is I have a bunch of stuff listed in tiki_pages not showing in the tiki_objects yet. could it be that I just need to add some info for them to show? [21:29] lq_950: Based on what I see in tiki_objects, it looks like things are added when they are needed. No categorization, no need for an objectId. [21:30] lq_950: Pick a page which doesn't have an object, add a category, then look again. [21:30] yeah but like my homepage has an objectid, but it's not assigned to a category [21:31] so why would it be in the objects table? [21:31] lq_950: For that matter, look at the program for editing a wiki page and see how the category info is processed. [21:31] lq_950: The objectId is used for many things other than categories. [21:32] hmmm, there is a "race condition" in the confirmed-users thing as it is currently: the registrationDate is not update upon confirmation [21:32] I think I have an idea lol [21:32] obnox: Is registrationDate supposed to indicate when they started the process, or when they confirmed? [21:32] I imported a bunch of stuff into the products table using a script I wrote (didn't know about the batch thing) and not into objects [21:33] I bet if I just put them in objects too that I'll be able to link them in no time [21:33] lq_950: See how that batch page tool works, and see if it has categories or if that data can be added to the imported data. [21:33] not products table (pages table) [21:33] I can just use my script again. The tables are similar. [21:33] lq_950: See how batched pages are processed, and imagine the category data riding along and being processed when appropriate. [21:34] one more question though. How can I keep the ip addresses of my users from showing? [21:34] lq_950: Well, back up your database and good luck. Would be nice to have a generalized tool. [21:35] lq_950: I don't know where they are visible. I'd look at the code for the page where they are visible, then at the .tpl file for that page. [21:35] They're in the "last changes" page [21:35] lq_950: Keeping in mind that if you create a custom style you can have separate .tpl files for that style. [21:36] can I just keep that from showing? [21:36] lq_950: The purpose of the .tpl is to emit the stuff on the page. So just have it not emit stuff. Or add a configuration parameter to control that. [21:36] yeah I realize I could just delete that [21:37] but I want to keep it for me (admin) but not have it so registered and anon users can see it [21:38] SEWilco2: well _I_ would say that the registrationDate should indicate when the registration has been completed, so the confirm_user should update the registrationDate. right? [21:38] There would be more control if you add a permission. Then admins can control who can see it. Or maybe there is such a permission -- there are so many. [21:39] obnox: Depends on the meaning of "registration". I consider filling out the paperwork as the registration, not after the registration has been processed. [21:39] SEWilco2: well, there is no separation between registrationDate and confirmationDate (or so) [21:39] so when is registration completed [21:40] *** Lucymoz has quit IRC (Read error: 110 (Connection timed out)) [21:40] I'd say, when the account has been confirmed [21:40] obnox: I don't know the intent. I'd leave an existing registrationDate alone, but if it is NULL at confirmation time then I'd fill it in. [21:42] SEWilco2: add_user does fill the registrationDate, so confirm_user will always find a registrationDate already [21:43] SEWilco2: the intent is the following: [21:43] obnox: Then apparently the coder intended for "registration" to mean when the paperwork is filled in, not when they get around to confirming. [21:43] obnox: What is the founder's intent? [21:44] I want to change what the mod-since_last_visit* think are the new users since the last login [21:44] i would like it to see only the users that have confirmed their login [21:45] obnox: Sounds like you need a different date field, or an option to update registrationDate upon confirmation. [21:45] SEWilco2: why an option? i'd simply update registrationDate in confirm_user [21:46] obnox: If registrationDate is updated upon confirmation, "new users" need only show those with date AND confirmed_flag (whatever its actual name is) match. [21:46] exactly [21:47] obnox: An option is necessary if you want to be exactly compatible with the present behavior. [21:47] SEWilco2: i don't get you. I want to change present behaviour. :-) [21:47] obnox: If you want to change the present behavior for all TW, I can't judge that. Ask the dev list. [21:48] obnox: I haven't even reread the doc to see if the current behavior is documented, much less whether reasons for the design are given. [21:48] SEWilco2: ok, gonna read. [21:49] obnox: For that matter, if the correct doc doesn't describe the current behavior then you could document it. :-) It can be updated if something changes. [21:49] sylvieg: said above it sounded like a good idea, but in order to carry it through, this change is needed [21:50] SEWilco2: or change then document... ;-) [21:51] obnox: Yes, it does sound useful. Unless someone wants new users to show before confirmation, such as if one wants to delete idiots before they become visible. [21:51] SEWilco2: btw: you're talking about paperwork, when is the paperwork finished? why does confirmation not belong to the paperwork? isn't it the final signature? [21:51] perhaps there is 2 behavior - admin sees all the user - non admin sees only confirmed [21:51] I wonder if there is an "RSS feed of new users". [21:51] i don't want to change all even unconfirmed users showing up in the admin users page! [21:51] *** lq_950 has quit IRC ("CGI:IRC") [21:52] only the mod-since-last modules [21:52] obnox: I'm equating paperwork delays to delays in confirmation. When you register to college, the date you fill out the paperwork is when you register. [21:52] obnox: While the date when the college processed the paperwork is a different date than the registration date. [21:53] this is more like a three step paperwork: [21:53] 1. you fill out the initial form [21:53] *** kerrnel has quit IRC ("CGI:IRC (Ping timeout)") [21:53] 2. college sends you a confirmation form [21:53] 3. you sign the confirmation form with current date... [21:53] ;) [21:53] obnox: Maybe the new changes page should, for admins, show two lists: new users and new confirmed users. [21:54] yeah, that could be useful [21:54] 4. You buy a stamp because you never use snail mail. [21:55] ;) [22:03] SEWilco2: there is still the "created" timestamp, this will not get modified [22:10] *** FrankP_german has quit IRC ("Nettalk6 - www.ntalk.de") [22:18] sylvieg: in the little new since ... menu? [22:19] oops. soory [22:23] *** Lucymoz has joined #tikiwiki [22:25] SEWilco2: what is "the doc" you were referring to, earlier [22:38] tikiwiki: 03sylvieg * r16785 10/trunk/templates/tiki-list_comments.tpl: [FIX] good colspan [22:46] obnox: Whatever might be on doc.tikiwiki.org is "the doc", plus comments in code (few). I haven't looked for doc for registration. [22:47] ok thx [22:48] obnox: I didn't know there was a "created" timestamp. I assume regdate == createddate at the beginning. [22:48] at account creation, yes [22:53] and when confirmation is required, I would set regdate at confirmation [23:15] tikiwiki: 03sylvieg * r16786 10/trunk/ (7 files in 3 dirs): [MOD]comments/forum: take away duplicated code in post topic in forum and post reply in forum and in comments.php itself: 2 new functions post_in_forum to post a topic or a reply and post_in_object to post a comment [23:22] *** rlopez has joined #tikiwiki [23:22] *** rlopez has quit IRC (Client Quit) [23:23] *** navster has joined #tikiwiki [23:30] *** jerkface03 has quit IRC (Nick collision from services.) [23:30] *** jerkface0 has joined #tikiwiki [23:30] *** rlopez has joined #tikiwiki [23:30] *** jerkface0 is now known as jerkface03 [23:31] *** rlopez has quit IRC (Client Quit) [23:32] *** rlopez has joined #tikiwiki [23:39] *** rlopez has quit IRC ("Leaving")