ok thanks oh one more thing is there like a recommended settings file or webpage somewhere? There's alot of settings in this thing lol lq_239: Define "this thing". There are a lot of things. 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. My MP4 files have NULL filetype in the database. Where are file types identified? Great. File types are being determined by suffix. OK, changed to .mpeg and it now downloads. Well, it kind of downloads. Doesn't download as "dl123" but does as "podcasts/lsdjfslfsdfldfkjdslfjsdf", and as a BIN file instead of MPEG. I see the filename is missing .mpeg extension. 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. Are TW 2.2 podcast downloads sensitive to spaces in file names? tikiwiki: 03pkdille * r16769 10/trunk/lang/fr/language.php: [MOD] french translation file : get_strings + some translations hi all 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 never mind found it 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. 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. hi, I've some intersting requests here: 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, User-Agent: NV32ts Cookie: PHPSESSID=64e76fd7a68804bb8c03f94da795e7f0 is it a possible security problem? 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". polom here we are at http://tikiwiki.org/TikiFestMadrid streaming from time to time 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. well done, Gary! :-) ^chibaguy arffff off-air right now :) tikiwiki: 03sylvieg * r16774 10/trunk/templates/tiki-admin_contribution.tpl: [MOD]contribution: better layout broadcasting again from TikiFestMadrid tikiwiki: 03lphuberdeau * r16775 10/trunk/lib/wiki-plugins/wikiplugin_webservice.php: [FIX] Include path changes broke webservices so hello everybody from tikifest madrid tikiwiki: 03chibaguy * r16776 10/trunk/ (24 files in 5 dirs): [NEW] Implementation of Strasa design by Patrick Allard; initial commit of files. polom tikiwiki: 03axold * r16777 10/trunk/tests/testfile.txt: I added a file in test directory Has anyone had a problem with adminuser php loading properly everything else works fine. tikiwiki: 03axold * r16778 10/trunk/tests/example.txt: I added a file in test directory does any one know how to change the port for send mail my host does not support port 25? tikiwiki: 03rlopezs * r16779 10/trunk/tests/messu-compose.tpl: Rober's first commit.From TikiFest Madrid tikiwiki: 03matwho * r16780 10/trunk/tests/testfile.txt: a test polom polom tikiwiki: 03matwho * r16781 10/trunk/tests/testfile.txt: a test hi 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 tikiwiki: 03marclaporte * r16782 10/trunk/templates/tiki-install.tpl: [FIX] dos2unix tikiwiki: 03marclaporte * r16783 10/trunk/templates/tiki-install.tpl: [FIX] Making the password field use stars hello guys anyone from tikifest madrid on here? 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 hi lramon yes :) we are still here who are you? :-) do we know each other? sitting in the hostal bari? hey marc :) xavi: I talked to marc before, that I want to help, but can't come to madrid :/ yes , we are still sitting here :) lramon, have you seen us at http://tikiwiki.org/TikiFestMadrid streaming? you will even hear us, I think now :D right now we are very loud... (people is tired here....) what's your name? hey *wave* ^^ real name, I man Florian I mean where are you from? germany welcome, then. I pity you couldn't attend here... yeah :/ Ouh.... Ben (mangapowerx) speaks german! :-O oh... nice t-shirts I need such a shirt too :D hi Iramon! hi marc :) omg... is everyone of you wearing a tiki t-shirt? 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. not right now any more. We feel like dinner time... tomorrow, maybe We'll do out best to have streaming again, with voice ok :) we'll do our best to update the page tw.o/TikiFestMadrid when did you start today? so se there if there is something you feel that you can/want to help with ok I will check it tomorrow morning/noon and now you're getting dinner and more drinks? ;) yes, it looks like that k, then bon apetite and have a lot of fun ;) so bye... Solved my podcast problems. MIME types omitted some upload-accepted file suffixes, and TW 2.2 has a bug in download file directories. idle-: Obviously someone is trying to insert SQL into a request. I don't know if browse-gallery is protected from SQL injection. tikiwiki: 03pkdille * r16784 10/trunk/lang/fr/language.php: [MOD] french translation file : get_strings + some translations 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? lq_950: If I recall correctly, there are tables for category info. yeah I've looked at the tables but I can't make sense of it how is it that the database tells the wiki what pages are within what category in other words I can't seem to find how the categories are linked to the wiki pages 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. lq_950: Oh, I think I see it. Look at tiki_objects. 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. ok checking it now. thanks lq_950: The objectId is then used in tiki_category_objects to connect objects to categories. Probably. lq_950: That's a guess based on the database. The code is the authority. + tiki-category_object associatess categId and categObjectId , tiki_categorized_objects associates categObjectId and objectId hi folks Anything objections to me modifying the display of "new users" to include only those who have already confirmed their login? err, well, broken language, but I guess you know what I mean... :-) obnox: seems a good idea sylvieg: the solution seems to be to extend the queries to check for "`provpass`=''" I can not garanty that wihiout looking at the code - there is so many registration case.... obnox: List a column "confirmed" Y/N? Allow sorting by columns? well the confirm_user function sets provpass to '' SEWilco2: that'd be nice,too I was firstly thinking about the new_users feature in the modules/mod-since_last_visit* modules 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? SEWilco2: but as a next step the enhancement of the admin users page, yeah, I'm gonna look into that lq_950: Don't know. Maybe tiki_objects isn't what we're looking for. Hmm. It may be. I have a few items listed there tiki_objects is filled up only when needed - first categ, or first freetag... so there is no way I can link items in tiki_pages to a category in the database? you have to create the tiki_objects line on the fly lq_950: Oh. Categories are for linking things like an entire wiki page, not things within the wiki page. ??? sorry I don't know what that means. 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? Looks to me as if tiki_objects is for things like links and images used in wiki pages. Not what I was thinking. lq_950: If you're creating the items, why are you worried about the database instead of assigning categories to pages? lq_950: I thought you were asking about the database because you were altering a program. 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. right now I have a bunch of pages created with no information in them I was trying to go ahead and assign them to the proper category for now yeah I know how to assign them 1 at a time. problem is I have roughly 4000 to assign lq_950: I am not aware of a tool for assigning categories to pages. Interesting idea; an export/import format for category assignment. lq_950: Did you find your categorized pages in tiki_objects? yes lq_950: And do the objectIds match those in the tiki_categor* tables? http://mods.tikiwiki.org/details.php?type=goodies&mod=batch_load_pages not sure it is working 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. 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? 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. lq_950: Pick a page which doesn't have an object, add a category, then look again. yeah but like my homepage has an objectid, but it's not assigned to a category so why would it be in the objects table? lq_950: For that matter, look at the program for editing a wiki page and see how the category info is processed. lq_950: The objectId is used for many things other than categories. hmmm, there is a "race condition" in the confirmed-users thing as it is currently: the registrationDate is not update upon confirmation I think I have an idea lol obnox: Is registrationDate supposed to indicate when they started the process, or when they confirmed? 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 I bet if I just put them in objects too that I'll be able to link them in no time 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. not products table (pages table) I can just use my script again. The tables are similar. lq_950: See how batched pages are processed, and imagine the category data riding along and being processed when appropriate. one more question though. How can I keep the ip addresses of my users from showing? lq_950: Well, back up your database and good luck. Would be nice to have a generalized tool. 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. They're in the "last changes" page lq_950: Keeping in mind that if you create a custom style you can have separate .tpl files for that style. can I just keep that from showing? 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. yeah I realize I could just delete that but I want to keep it for me (admin) but not have it so registered and anon users can see it 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? 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. obnox: Depends on the meaning of "registration". I consider filling out the paperwork as the registration, not after the registration has been processed. SEWilco2: well, there is no separation between registrationDate and confirmationDate (or so) so when is registration completed I'd say, when the account has been confirmed 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. SEWilco2: add_user does fill the registrationDate, so confirm_user will always find a registrationDate already SEWilco2: the intent is the following: obnox: Then apparently the coder intended for "registration" to mean when the paperwork is filled in, not when they get around to confirming. obnox: What is the founder's intent? I want to change what the mod-since_last_visit* think are the new users since the last login i would like it to see only the users that have confirmed their login obnox: Sounds like you need a different date field, or an option to update registrationDate upon confirmation. SEWilco2: why an option? i'd simply update registrationDate in confirm_user obnox: If registrationDate is updated upon confirmation, "new users" need only show those with date AND confirmed_flag (whatever its actual name is) match. exactly obnox: An option is necessary if you want to be exactly compatible with the present behavior. SEWilco2: i don't get you. I want to change present behaviour. :-) obnox: If you want to change the present behavior for all TW, I can't judge that. Ask the dev list. 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. SEWilco2: ok, gonna read. 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. sylvieg: said above it sounded like a good idea, but in order to carry it through, this change is needed SEWilco2: or change then document... ;-) 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. 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? perhaps there is 2 behavior - admin sees all the user - non admin sees only confirmed I wonder if there is an "RSS feed of new users". i don't want to change all even unconfirmed users showing up in the admin users page! only the mod-since-last modules 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. obnox: While the date when the college processed the paperwork is a different date than the registration date. this is more like a three step paperwork: 1. you fill out the initial form 2. college sends you a confirmation form 3. you sign the confirmation form with current date... ;) obnox: Maybe the new changes page should, for admins, show two lists: new users and new confirmed users. yeah, that could be useful 4. You buy a stamp because you never use snail mail. ;) SEWilco2: there is still the "created" timestamp, this will not get modified sylvieg: in the little new since ... menu? oops. soory SEWilco2: what is "the doc" you were referring to, earlier tikiwiki: 03sylvieg * r16785 10/trunk/templates/tiki-list_comments.tpl: [FIX] good colspan obnox: Whatever might be on doc.tikiwiki.org is "the doc", plus comments in code (few). I haven't looked for doc for registration. ok thx obnox: I didn't know there was a "created" timestamp. I assume regdate == createddate at the beginning. at account creation, yes and when confirmation is required, I would set regdate at confirmation 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