| 10:44 |
coolguy |
hi there! when developing an extension and you need to use a db, would you prefer to use $GLOBAL['TYPO3_DB'] for it? |
| 10:45 |
fuchur |
yes |
| 10:48 |
coolguy |
but theres something i dop ot understand, why have i to submit the database on each query? .... $res = mysql(TYPO3_db, 'INSERT ... |
| 10:48 |
fuchur |
o_O |
| 10:48 |
coolguy |
i set the db allready with: $GLOBALS['TYPO3_DB']->sql_select_db |
| 10:49 |
coolguy |
ah sorry i meant: $res = $GLOBALS['TYPO3_DB']->sql(TYPO3_db, 'SELECT |
| 10:49 |
fuchur |
you don't push queries directly o_O |
| 10:50 |
coolguy |
? why not? |
| 10:50 |
fuchur |
use $GLOBALS['TYPO3_DB']->exec_INSERTquery() instead |
| 10:51 |
fuchur |
please install extension "extdeveval" in your TYPO3 and read t3lib_db-documentation |
| 10:51 |
coolguy |
i need selects and as i can see the wrapper is not functional with many joins |
| 10:53 |
coolguy |
or what do you think |
| 10:56 |
coolguy |
you see typo3 db is easy |
| 10:56 |
coolguy |
$GLOBALS['TYPO3_DB']->exec_SELECTquery( |
| 10:56 |
coolguy |
$select_fields, |
| 10:56 |
coolguy |
$from_table, |
| 10:56 |
coolguy |
$where_clause, |
| 10:56 |
coolguy |
$groupBy = '', |
| 10:56 |
coolguy |
$orderBy = '', |
| 10:56 |
coolguy |
$limit = '' |
| 10:56 |
coolguy |
) |
| 10:56 |
coolguy |
but i need joins over 4 tables |
| 11:52 |
esbite |
Hi all. Im having trouble with the extension Powermail. Does anyone here have experience with it? |
| 12:17 |
foool |
is it java in powermail |
| 13:11 |
HardPhuck |
can i authenticate FE users against another table than fe_users? |
| 13:11 |
HardPhuck |
if i have a custom table in another database |
| 13:18 |
crisb2010 |
hi |
| 13:19 |
crisb2010 |
i am using this ts code (http://pastie.org/621783) to generate the third level of a menu. what i want it to do is to hide the third level once a page on this hierarchy is active. i have tried for hours to get it working, but i had no luck yet. does anyone have a clue? |
| 13:25 |
crisb2010 |
it is easy to use css to hide the active page (via ACT) but i found no way to address the other pages |
| 13:39 |
crisb2010 |
if anyone has a clue, drop me a line. i'm going to be here for some time :) |
| 13:42 |
pmk65 |
crisb2010: you could use a custom register value. Then you could check if that is present in your 3rdlevel menu, and hide it if needed. |
| 13:43 |
MasterYin |
Hey together :) |
| 13:44 |
pmk65 |
crisb2010: here's an example of using registervalues in a menu.. -> http://www.typo3wizard.com/en/snippets/menus/tabsmenu-tmenu-sample.html |
| 13:44 |
crisb2010 |
cool, thanks |
| 13:44 |
MasterYin |
got a problem with crawler... if i try to crawl the root page i got the error http://www.myDomain.net// (tx_indexedsearch_reindex) => Error checking Crawler Result: Error! Error! The requested page does not exist! ... |
| 13:45 |
MasterYin |
the same job crawls all other pages successfully |
| 13:46 |
crisb2010 |
pmk65 this seems to be far more complicated than i thought .) |
| 13:47 |
pmk65 |
crisb2010: maybe you could use conditions, and check if the page is below a certain pid, and then kill off the 3rd level of your menu. |
| 13:48 |
crisb2010 |
but that wouldn't be dynamic right? |
| 13:48 |
pmk65 |
theres several usable condition types for that, like: treeLevel, PIDinRootline and PIDupinRootline |
| 13:49 |
pmk65 |
if it's always the 3rd level you want to remove, then I guess treeLevel will work |
| 14:15 |
Anto|ne |
Hi |
| 14:15 |
sorenmalling |
Anyone worked with realurl and calendar base? |
| 14:15 |
Anto|ne |
There is a function to parse a pi_flexform field in a mod1 (on be) |
| 14:16 |
Anto|ne |
like pi_getFFvalue in pibase |
| 14:17 |
Anto|ne |
? |
| 14:24 |
pmk65 |
Anto|ne> I think there's some functions if you include the TemplaVoila API. |
| 14:25 |
Anto|ne |
:-( |
| 14:27 |
pmk65 |
or just copy the func from pibase and include them in your code. (they are pretty simple) |
| 14:27 |
Anto|ne |
yes it was my solution |
| 14:29 |
pmk65 |
but the templavoila API has similar functions, and they are usable from BE modules/code. |
| 14:30 |
pmk65 |
I have used it in one of my BE ext for accessing the TV page structure. |
| 14:32 |
crisb2010 |
pmk65: treelevel was a good hint. works this way |
| 14:39 |
crisb2010 |
rejoyed too soon |
| 14:45 |
crisb2010 |
what i need is a condition like this: if the visitor is on a 3rd level page do this |
| 14:48 |
crisb2010 |
if possible i would like to keep away from javascript for this job, because this is the last way if nothing else works |
| 14:57 |
R2c |
Hello |
| 14:57 |
R2c |
i have a question |
| 14:57 |
R2c |
How debug this => $GLOBALS['TYPO3_DB']->exec_INSERTquery('tx_cfiwebbrochure_infos',$insertFields); |
| 14:58 |
_pedda_ |
hi all |
| 14:58 |
flurl__ |
crisb2010: does this work for you? http://pastie.org/624492 |
| 14:59 |
crisb2010 |
flurl__ i tried this, with level 2. this doesn't work unfortunately, because then the menu isn't displayed at all |
| 15:09 |
MasterYin |
i can't get my indexed_search indexing pdfs |
| 15:09 |
MasterYin |
i have pfdtotext and pdfinfo installed but opening a link to a pdf it will be displayes but not indexed |
| 15:10 |
maholtz|WORK |
is there an API function to check if an pages-record is in a specific rootline? |
| 15:10 |
sorenmalling |
maholtz|WORK: PIDinRootline |
| 15:10 |
sorenmalling |
Arh, sorry my bad - didn't get the part that you needed it as a function |
| 15:11 |
maholtz|WORK |
thanks anyway... i had an look in it and i cannot missues it:/ |
| 15:11 |
sorenmalling |
$GLOBALS['TSFE']->tmpl->rootLine |
| 15:11 |
maholtz|WORK |
ah, ok i have to specifiy my question better... :) |
| 15:12 |
maholtz|WORK |
i have a multi site installation |
| 15:12 |
sorenmalling |
Or maybe i need more coffee :) |
| 15:12 |
maholtz|WORK |
no, normally you would be right i think |
| 15:12 |
maholtz|WORK |
:) |
| 15:13 |
maholtz|WORK |
but i have an extension which gets some pages records from the db and i need to check if they are in the actuall domain |
| 15:14 |
sorenmalling |
In the frontend right? |
| 15:14 |
maholtz|WORK |
yep |
| 15:15 |
sorenmalling |
if(in_array($GLOBALS['TSFE']->id, $GLOBALS['TSFE']->tmpl->rootLine)) ? |
| 15:15 |
sorenmalling |
Isn't that what you need? |
| 15:16 |
maholtz|WORK |
$GLOBALS['TSFE']->tmpl->rootLine holds the rootline of the page which is renderd (afaik)? |
| 15:16 |
maholtz|WORK |
i need in_array($pid, $pagesInThisBranch) |
| 15:16 |
maholtz|WORK |
perhaps data = leveluid:1 could help me with that...? |
| 15:17 |
sorenmalling |
Else, check the code generating the page tree in the backend |
| 15:18 |
maholtz|WORK |
good hint, thx |
| 15:18 |
sorenmalling |
or the sitemap tt_content element |
| 15:19 |
sorenmalling |
Anyone used realurl along with calendar base? |
| 15:21 |
pmk65 |
maholtz|WORK: http://typo3.org/documentation/document-library/core-documentation/doc_core_tstemplates/0.0.1/view/2/7/ (bottom of page) |
| 15:22 |
maholtz|WORK |
hm... thx, but i need to know if a specific page is in an specific branch, not only in the rootline |
| 15:29 |
|00| |
hello everybody |
| 15:30 |
|00| |
I am an experienced typo3 user and developer but I have not had time so far to put my fingers on version 4.3 so far. |
| 15:30 |
|00| |
I have a few stupid questions about these : |
| 15:30 |
|00| |
possible to have traditional extensions living aside extbase extensions on the very same page ? |
| 15:31 |
|00| |
<is it> possible... |
| 15:34 |
maholtz|WORK |
yep |
| 15:34 |
maholtz|WORK |
you can work as you know from 4.2 |
| 15:36 |
maholtz|WORK |
you do not need to write your extensions with extbase and fluid |
| 15:37 |
jacky |
fluid? |
| 15:37 |
jacky |
new template engine? |
| 15:37 |
maholtz|WORK |
yep |
| 15:38 |
coolguy |
it seems that the method gettypolink does not work. i doesnt returns a <a href link ... |
| 15:38 |
coolguy |
$marker['###newslink###'] = $this->cObj->getTypoLink( |
| 15:38 |
coolguy |
stripslashes($f['title']), |
| 15:38 |
coolguy |
array( |
| 15:38 |
coolguy |
'parameter' => 2289, |
| 15:38 |
coolguy |
'additionalParams' => '?newsid='.$f['uid'], |
| 15:38 |
coolguy |
'useCacheHash' => 1 |
| 15:38 |
coolguy |
) |
| 15:38 |
coolguy |
); |
| 15:39 |
coolguy |
does somebody know why? ... it only returns the title .... nothing more |
| 15:42 |
maholtz|WORK |
@pmk65 & sorenmalling: $GLOBALS['TSFE']->sys_page->getPage($row['uid']) returns only array if the user is allowed to access that page... seems to work |
| 15:42 |
sorenmalling |
Thanks maholtz|WORK :) |
| 15:44 |
maholtz|WORK |
well, thanks too:) |
| 15:45 |
maholtz|WORK |
@coolguy: dont start additionalParams with ? |
| 15:45 |
maholtz|WORK |
but with & |
| 15:47 |
coolguy |
that does not work. but how do i link the first target then? its always test.html?id=1&id1=2 etc . pp. |
| 15:48 |
maholtz|WORK |
@coolguy usually typolink cares for that... (perhaps i am wrong?) |
| 15:48 |
coolguy |
even when i remove the additionalParams element from the array, it does not work. the functions only return the title name as in $f['title'] ... |
| 15:49 |
maholtz|WORK |
you sure that your $f has something in it (btw. call it f.e. $newsitem) |
| 15:50 |
pmk65 |
coolguy: you are using wrong parameters for that function.. |
| 15:51 |
pmk65 |
2nd parameter should be a string not an array.. |
| 15:52 |
pmk65 |
but if you use the "typolink" function instead of "getTypoLink", it should work. |
| 15:55 |
maholtz|WORK |
ah... |
| 15:57 |
coolguy |
no doesnt work either. i only return the title ... with no tags and params ;-( ... is there a logfile where i can see why typo only returns the text? |
| 15:58 |
coolguy |
(but as i typo3 know, there is no log ;-) ) |
| 16:08 |
MasterYin |
hey does anyone know a working stop-word-list for german language and indexed_search ? |
| 17:13 |
sorenmalling |
If i want the unix path to the typo3conf folder what variable should i use? |
| 17:14 |
phil1 |
maybe EXT:/../ |
| 17:28 |
pmk65 |
sorenmalling> t3lib_extMgm::extRelPath($key) or t3lib_extMgm::siteRelPath($key) |
| 17:28 |
pmk65 |
if you want the path to your ext folder. |
| 17:29 |
sorenmalling |
Thanks, neded up using t3lib_extMgm::extPath for the job :) |
| 17:29 |
sorenmalling |
nede == ended :) |
| 17:30 |
pmk65 |
there's also a lot of predefined constants you can use.. http://typo3.org/documentation/document-library/core-documentation/doc_core_api/4.2.0/view/3/5/ |
| 17:31 |
sorenmalling |
That was what i was looking for :) bookmarked right away :) |
| 17:31 |
pmk65 |
PATH_typo3conf |
| 17:45 |
howard |
hello channel |
| 17:45 |
howard |
short question |
| 17:46 |
howard |
If I have some extension ie. tx_abcd, and there are tx_abcd_tbl, table in database |
| 17:47 |
howard |
how I can add tx_abcd_tbl2 to the system? |
| 17:47 |
howard |
in that tbl2 I want to use some informations from tt_news table ie. |
| 17:48 |
howard |
I think that using straight forward sql queries for creation of table isn't so smart |
| 17:49 |
howard |
kickstarter maybe? |
| 17:58 |
esbite |
My powermail wont let me add fields or fieldsets. Anyone had this problem? Any guess where I could find help? |
| 17:59 |
maholtz|WORK |
@esbite: tried different browser? check for javascript errors |
| 18:00 |
maholtz|WORK |
@howard: yep, use kickstarter |
| 18:22 |
esbite |
maholtz|WORK: yeah... hmm... "element is null". |
| 18:23 |
esbite |
in prototype.js |
| 18:59 |
maholtz|WORK |
@esbite: afaik there are some problems with powermail and older date2cal extension.. perhaps check that or clear browser cache |
| 18:59 |
maholtz|WORK |
have to leave now |
| 18:59 |
maholtz|WORK |
cu all |
| 19:04 |
schabracke |
hey there! |
| 19:08 |
schabracke |
i use ext comments within tt_news, but all my comments are disordered |
| 19:09 |
schabracke |
has anyone got amn idea? |
| 19:24 |
ries |
schabracke: I use sk_pagecomments... also allows you to comment on news items... |
| 19:24 |
ries |
schabracke: unfortunatly, I don't have comments experiences |
| 19:33 |
schabracke |
xcuse me |
| 19:33 |
schabracke |
i use sk_pagecomments too |
| 19:34 |
schabracke |
wrote the wrong extname :) |
| 19:34 |
schabracke |
but its all disordered, any ideas? |
| 20:14 |
schabracke |
@ries are u still there? lost connection sry |
| 20:15 |
schabracke |
i got the same tt_news / sk_pagecommentes setup as you |
| 20:15 |
schabracke |
but all of my comments are disordered |
| 20:15 |
ries |
schabracke: what do you mean with disordered ?? |
| 20:15 |
schabracke |
the best thing would be to try it yourselve? |
| 20:15 |
schabracke |
all comments are on the same site |
| 20:15 |
schabracke |
but the site changes some way |
| 20:16 |
schabracke |
its hard to explain .... |
| 20:19 |
schabracke |
and with disordered i mean the teaser of sk_pagecomments |
| 20:19 |
schabracke |
forogt to mention that ... |
| 20:19 |
schabracke |
the comments on the singleview tt_news are okay |
| 20:50 |
HardPhuck |
are there any screenshots for T3 5.0 BE? |
| 21:06 |
HardPhuck |
found them |
| 22:29 |
ries |
HardPhuck: never knew they where already there.... what URL? |
| 22:30 |
HardPhuck |
http://tr.im/t35ui |
| 22:31 |
ries |
Ahh yeaa I have seen them.. but nothing concrete yet, right? |
