1. 

   vittorio, Member

   al
   I 'd like to be supported becuase I have following issue with url links:

   I have to link username listed in my reports with

   1. a url that link into user_profile contained in my user_tab . Each user is classified by user_ID. this link then change depending on the user following the below

   http://xxxxxxx/public/forum/memberlist.php?mode=viewprofile&u=user_ID

   how can I write this down with a command to let mydbr understand is the question.

   2. a url that link into existing submitted forum topics. Each topic is classified by topic_ID. this link then change depending on the user following the below for instance

   http://xxxxxxxxxxxxxx/public/forum/viewtopic.php?f=104&t=2256&flag=2

   thanks
   viktor
2. 

   myDBR Team, Key Master

   1. a url that link into user_profile contained in my user_tab . Each user is classified by user_ID. this link then change depending on the user following the below

   http://xxxxxxx/public/forum/memberlist.php?mode=viewprofile&u=user_ID

   You can use 'dbr.url' command to link report data to your url:

   select 'dbr.url', 'http://xxxxxxx/public/forum/memberlist.php?mode=viewprofile', 'View profile', 'u=1';
   
   select userid
   
   from forum_userdata;
   
   

   2. a url that link into existing submitted forum topics. Each topic is classified by topic_ID. this link then change depending on the user following the below for instance

   You can do this similarily to 1.

   --
   myDBR Team
3. 

   vittorio, Member

   Sorry

   the below is what I have now

   select 'dbr.url', '/public/forum/memberlist.php?mode=viewprofile', 'User details', 2, 'u=11';

   please detail me better what I have to do

   thanks

   vittorio
4. 

   myDBR Team, Key Master

   the below is what I have now

   select 'dbr.url', '/public/forum/memberlist.php?mode=viewprofile', 'User details', 2, 'u=11';

   please detail me better what I have to do

   What is it that you want to achieve?

   myDBR's 'dbr.url'-command allows you to access external URL and pass data in database as a URL variable. Please see myDBR documentation for it's parameters.

   --
   myDBR Team
5. 

   vittorio, Member

   dear sir
   please can I have required details.

   thanks
6. 

   myDBR Team, Key Master

   Could you please be more specific what you want to achieve. What is the problem you are trying to solve?

   --
   myDBR Team
7. 

   vittorio, Member

   why you are specifiying u=1 below?

   please advise
   thanks

   select 'dbr.url', 'http://xxxxxxx/public/forum/memberlist.php?mode=viewprofile', 'View profile', 'u=1';
8. 

   myDBR Team, Key Master

   The u=1 means that myDBR will take the first column from the result set and add it to the URL with name u.

   For example if you have the following result set:

   ID Name --------- 27 First user 39 Second user

   Then myDBR would create the following URL for you:

   http://xxxxxxx/public/forum/memberlist.php?mode=viewprofile&u=27

   Best Regards,

   myDBR Team
9. 

   vittorio, Member

   this is out typicl link

   http://95.110.227.182/public/forum/memberlist.php?mode=viewprofile&u=113

   where u=xxx change depending on User_id loaded in phpbb_users:

   select user_id
   from Sql254908_5.phpbb_users;

   so please can you detail how this link needs to be created.

   obviously what provided with u=1 is not applicable.

   pls advise

   thanks
10. 

    myDBR Team, Key Master

    so please can you detail how this link needs to be created.

    Please see the first answer (second post) in this thread. You will find the detailed example there answering your exact question.

    --
    myDBR Team
11. 

    vittorio, Member

    sir

    we have checked and the way the address URL cannot be resolved it appears to be becuse we need to add that marked in betweek ** ------** .

    adding that row you cannot anymore associete url at u&xxx so go through.

    below is the code, if you can check we would appreciate.

    thanks

    CREATE PROCEDURE


    _

    ()
    begin
    select 'dbr.hidecolumns', 1;
    select 'dbr.url', '/public/forum/memberlist.php?mode=viewprofile', 'User details', 2, 'u=11';

    set @x = 0;
    select @x := (@x+1) as 'no.',
    lcase(u.username) as 'Employee',
    if ( u.user_rank = 1, 'Site Admin', 'Registered User' ) as 'Rank',
    ****pfl.lang_value as 'Skill',*****
    u.user_email as 'Company Email',
    pf.pf_private_email_ad as 'Private Email',
    if (pf.pf_home_phone!='', concat('h:',pf.pf_home_phone), '') as 'Home Phone',
    if (pf.pf_mobile_phone!='', concat('m:',pf.pf_mobile_phone), '') as 'Mobile Phone',
    u.user_skype as 'Skype Id',
    pf.pf_msn_id as 'MSN Id',
    if (pf.pf_fax_number!='', concat('f:',pf.pf_fax_number), '') as 'FAX',
    u.user_id
    from
    Sql254908_5.phpbb_users u, Sql254908_5.phpbb_profile_fields_data pf, Sql254908_5.phpbb_profile_fields_lang pfl
    where
    u.user_id = pf.user_id and pfl.option_id = pf.pf_position-1 and pfl.field_id = 4
    order by lcase(u.username);
12. 

    myDBR Team, Key Master

    Your code:

    select 'dbr.url', '/public/forum/memberlist.php?mode=viewprofile', 'User details', 2, 'u=11';

    says that 'u'-parameter can be found in the result set's 11th column. The 11th column in the query is the 'FAX', which seems to be incorrect.

    When you add columns in the query, please check that the column references match (in your case the correct reference is probably the 12th column, u.user_id).

    So if you add a column pfl.lang_value to the query please also change the URL reference to be:

    select 'dbr.url', '/public/forum/memberlist.php?mode=viewprofile', 'User details', 2, 'u=12';

    --
    myDBR Team
13. 

    myDBR Team, Key Master

    Your code:

    select 'dbr.url', '/public/forum/memberlist.php?mode=viewprofile', 'User details', 2, 'u=11';

    says that 'u'-parameter can be found in the result set's 11th column. The 11th column in the query is the 'FAX', which seems to be incorrect.

    When you add columns in the query, please check that the column references match (in your case the correct reference is probably the 12th column, u.user_id).

    So if you add a column pfl.lang_value to the query please also change the URL reference to be:

    select 'dbr.url', '/public/forum/memberlist.php?mode=viewprofile', 'User details', 2, 'u=12';

    --
    myDBR Team
14. 

    vittorio, Member

    thanks for the answer,
    now we understand.

    however I feel sorry to duplicate queries but the manual if you follow it up is not clear with parenthesis etc.

    your explanation is now more than clear.

    thanks

Reply

You must log in to post.