*Solved *FEU: getting the username.

[Akonkagva]

In FEU to print username we simply use {username}.
I need to create little user defined tag which would use logged in user as it's username and add it to SQL.
Example:

$username1 = "uca";
$password = "Example";
$host = "localhost";
$database = "uca";

// Make the connect to MySQL or die
// and display an error.
$link = mysql_connect($host, $username1, $password);
if (!$link) {
   die('Could not connect: ' . mysql_error());
}
echo "Username".$username;
$query ="SELECT * FROM cms_module_feusers_users_paid WHERE 'username' = {$username} and 'sms_paid_one' = 1";
echo $query;
mysq;_query(..........
$id = mysql_num_rows($results);
if($id > ...........

How can I modify my code to make it display correct SQL with $username inside it ?

[Peciura]

Install module customcontent
http://dev.cmsmadesimple.org/projects/customcontent

Read module help, also search forum for

Code: Select all

$ccuser->property('propertyname')
$ccuser->loggedin()
$ccuser->memberof('group')
$ccuser->username()

Note tags like

Code: Select all

{$customcontent_loginname}
{$customcontent_loggedin} 

are deprecated.

[Akonkagva]

Sorry, I am still confused.

How can I just add current logged in username into sql statement. As in sql provided ?

Thank you for your patience.

[Akonkagva]

Let's make task even more simple:
{php}$thisStringShouldContainUsername = {$customcontent_loginname}{/php} // Big mistake
How to do something like this ?

[Peciura]

Let's make task even more simple:
{php}$thisStringShouldContainUsername = {$customcontent_loginname}{/php} // Big mistake
How to do something like this ?

Code: Select all

{php}
global $gCms;
$smarty = $gCms->GetSmarty();
$thisStringShouldContainUsername = $smarty->get_template_vars('customcontent_loginname');
{/php}

OR your SQL statement can be in UDT.
If your UDT is

Code: Select all

{my_udt my_parameter='some_value'}

In UDT parameter can be accessed this way

Code: Select all

$params['my_parameter'];

More info about UDT at http://wiki.cmsmadesimple.org/index.php ... fined_Tags

[Akonkagva]

{php}
global $gCms;
$smarty = $gCms->GetSmarty();
$thisStringShouldContainUsername = $smarty->get_template_vars('customcontent_loginname');
{/php}
Doesn't work, I have installed both Feu, and Custom Content. Cashable set to false.

[Dr.CSS]

You most likely have a problem from using {php}...

[Akonkagva]

Yes, in UDT after a bit reworking it works fine ! Thank you guy's ! I really needed your help !

[Dr.CSS]

[solved]...?