I will investigate the schema files. :)

ALTER TABLE `cmsb_accounts`
ADD COLUMN stage_1 MEDIUMTEXT,
ADD COLUMN stage_2 MEDIUMTEXT,
ADD COLUMN stage_3 MEDIUMTEXT,
ADD COLUMN stage_4 MEDIUMTEXT;

However I would also like to be able to specify the content for "Field Label" and "Field Type" for these new columns too... (field labels would be same as field names and all field types would be "textfield")

If someone can give me a few pointers on how to do this it would be much appreciated as my mysql skills are quite limited.

I have a very large list of extra textfields I would like to add to the cms_accounts table.

Can you advise on the best way of going about this with v3.50.

Many thanks for the help!

dm

for some random featured listings on a home page i am limiting a list of records to 3 but i want to only display records where the upload field called "photos" has photos uploaded

is there a way to add to the 'where' clause below to achieve this via the mysql?

list($propertyRecords, $propertyMetaData) = getRecords(array(
'tableName' => 'property',
'limit' => '3',
'orderBy' => 'RAND()',
'loadUploads' => true,
'allowSearch' => false,
'useSeoUrls' => true,
'where' => "collection = '1'".' AND '."hide_property = '0'",
));

many thanks for the support!

The code below works ok except for when a word has more than one instance of a particular letter for examples the word "Bees"

For example it will go through find "e" but then replace both instances of the letter "e" with either

<input type="text" name="question_1_letter_1" class="inputs" maxlength="1" value="" />

or

<input type="text" name="question_1_letter_2" class="inputs" maxlength="1" value="" />

What I really want is for it to just replace once the first "e" it finds so one instance of the letter "e" is replaced by

<input type="text" name="question_1_letter_1" class="inputs" maxlength="1" value="" />

and the other instance is replaced with

<input type="text" name="question_1_letter_2" class="inputs" maxlength="1" value="" />

here is the main code

$one = "question_1_letter_$key1";
$two = "question_1_letter_$key2";
$three = "question_1_letter_$key3";
$four = "question_1_letter_$key4";

$string = Bees;

$selected_letter1 = B;
$selected_letter2 = e;
$selected_letter3 = e;
$selected_letter4 = s;

$Find = Array($selected_letter1, $selected_letter2, $selected_letter3, $selected_letter4);

$Replace = Array(
"<input type=\"text\" name=\"$one\" class=\"inputs\" maxlength=\"1\" value=\"\" />",
"<input type=\"text\" name=\"$two\" class=\"inputs\" maxlength=\"1\" value=\"\" />",
"<input type=\"text\" name=\"$three\" class=\"inputs\" maxlength=\"1\" value=\"\" />",
"<input type=\"text\" name=\"$four\" class=\"inputs\" maxlength=\"1\" value=\"\" />"
);

$New_string = strtr($string, array_combine($Find, $Replace));

echo $New_string;

Hope that makes sense! Im still very much a novice php programmer and stuck as to how I can achieve this and may well be overlooking a much simpler solution that I am currently unaware of... if anyone can lend a hand and give me some pointers it would be greatly appreciated!!

Not to worry, unfortunately consulting isn't an option for this site at the moment, I seemed to have found a way around the issue by using some mysql... will leave an example below in case anyone else is looking for something similar...

Thanks again for your time...

<?php
$con=mysqli_connect("localhost","my_user","my_password","my_db");

if (mysqli_connect_errno())
{echo "Failed to connect to MySQL: " . mysqli_connect_error();}

$result = mysqli_query($con,"SELECT * FROM cms_properties GROUP BY bedrooms ORDER BY bedrooms");

echo "<select name=\"bedrooms\" id=\"bedrooms\" >
<option value=\"\">Bedrooms</option>
";

while($row = mysqli_fetch_array($result))

if(@$_REQUEST['bedrooms'] == $row['bedrooms'])
{echo "<option selected=\"selected\" value=" . $row['bedrooms'] . " >" . $row['bedrooms'] . "&nbsp;Bedroom" ."</option>";}
else
{echo "<option value=" . $row['bedrooms'] . " >" . $row['bedrooms'] . "&nbsp;Bedroom" ."</option>";}
echo "<option value=\"\">All Bedrooms</option></select>";

mysqli_close($con);
?>

Thanks very much for spending time on this...

I tried to code something else skipping the getlistoptions method and using the usual foreach record code to display lists below:

<select name="bedrooms" id="bedrooms" >

<option value="">Bedrooms</option>

<?php foreach ($propertiesbedroomsRecords as $record): ?> 
<?php if (@$alreadyShown[ $record['bedrooms'] ]++) { continue; } ?>
<option value="<?php echo $record['bedrooms'] ?>" ><?php echo $record['bedrooms'] ?></option> 
<?php endforeach; ?> 
</select>

But unfortunately with the numerical search drop downs such as number of bedrooms and bathrooms if a number has already been "selected" in the one field it then doesn't display it in the other field (i think because it sees the number 1 in bedrooms for example and then assumes 1 is @$aleadyShown for any other numerical option in the search form), so back to the drawing board... i guess i could add 1 bed, 2 bed... 1 bath, 2 bath etc to make the field values unique but it is a pretty ugly way of going about it

Fingers crossed one of the other devs has an idea re a simpler getlistoptions type method to achieve as I am sure this would be useful for anyone wanting a search form on their listings type site.

And from a visitor point of view it is much more user friendly than displaying search options that are are currently not in the database, saving them wasting time searching for things that don't exist on the site...

Thanks again and all the best!

thanks for taking a look, much appreciated!

i have been unable to contact my friend to get permission to post a live link (but can send you in a mail if needed) so i have uploaded an example php page

its is a basic property listings site and i just wanted the search form drop downs in the attached example to only pull in the list options if there is a property listing in the database with this option selected...

ie for bedrooms there is currently a list field "bedrooms" with options 1,2,3,4,5,6,7,8,9,10 - i would like that if there are no properties with 10 bedrooms in the database, don't show this in the search form dropdown.. to save visitors searching for something that doesnt exist

<select name="bedrooms" id="bedrooms">
<option value = "" <?php selectedIf($value, @$_REQUEST['bedrooms']);?>>Bedrooms</option>
<?php foreach (getListOptions('properties', 'bedrooms') as $value => $label): ?>
<option value = "<?php echo $value;?>" <?php selectedIf($value, @$_REQUEST['bedrooms']);?>><?php echo $label; ?></option>
<?php endforeach ?>
</select>

thanks again for you time!

I have a multi-record section with a table called 'properties' which has four list options:

'property_type', 'town', 'bedrooms' & 'bathrooms'.

I would like to be able to use these four lists to auto-populate drop downs in a search form but only display the options that have been selected in the database records.

I can auto populate the search drop downs no problem but I am unable to narrow down the results to selected list options...

Is it possible to expand on the getListOptions() method and do this?

ie getListOptions('properties','property_type') with some extra code to only display the "selected" list options..

If not could maybe someone point me in the right direction to achieve this...

Many thanks in advance for any help with this!

$string = $selected_word;
$Find = Array($selected_letter, $selected_letter2, $selected_letter3);
$Replace = Array("<input type=\"text\" name=\"one\" class=\"inputs\" maxlength=\"1\" value=\"\" />", "<input type=\"text\" name=\"two\" class=\"inputs\" maxlength=\"1\" value=\"\" />", "<input type=\"text\" name=\"three\" class=\"inputs\" maxlength=\"1\" value=\"\" />");

$New_string = strtr($string, array_combine($Find, $Replace));

echo $New_string;

Cheers!

Sorry for the late reply, thanks ever so much for taking the time to reply, it is really appreciated!

I actually found a dirty work around by bringing the value in using an include from a set field in the database but your way works much much neater, can't believe I didn't spot the name attrribute! Cheers!

One last question if I may:

Words over a certain size have 3 letters taken out (instead of just 1) and are replaced by 3 different input fields each with different name attributes

As suggested by example 2 on the php manual pages http://es1.php.net/preg_replace I have tried using arrays to achieve this but where it loops through it changes all the instances of the selected letter (ie if "i" is a selected letter it will also strip out i from input and the i from my class input) rather than just the one from the original string.

$string = $selected_word;
$patterns = array();
$patterns[0] = "/$selected_letter/";
$patterns[1] = "/$selected_letter2/";
$patterns[2] = "/$selected_letter3/";
$replacements = array();
$replacements[2] = "<input type=\"text\" name=\"test3\" class=\"inputs\" maxlength=\"1\" value=\"\" />";
$replacements[1] = "<input type=\"text\" name=\"test2\" class=\"inputs\" maxlength=\"1\" value=\"\" />";
$replacements[0] = "<input type=\"text\" name=\"test1\" class=\"inputs\" maxlength=\"1\" value=\"\" />";
echo preg_replace($patterns, $replacements, $string);

I know I can choose to replace more than one pattern with the same replacement and if the array route isnt doable I was hoping that it would be possible to do something like this below to define multiple things to replace and multiple replacement values but I can't seem to find any way of doing this...

ie something like this: echo preg_replace("/$selected_letter|$selected_letter2|$selected_letter3/", "<input type=\"text\" class=\"inputs\" maxlength=\"1\" />", $str);

Do you know of a way around the array issue or an easier way to achieve the same result?

Once again thanks very much for the awesome support!

I am using cms builder to make a kind of vocabulary hangman type game... using php preg_replace to remove random letters from words stored in the cms database and replacing them with text input fields which when the users enter what they think the missing letter is should be which are then submitted to my mysql database for checking as per the addform.php example found on this forum.

I am rather lost on how to convert the input "value" to echo php code needed to import the letter to my cms db...

In my php file I have the following:

<? echo preg_replace("/$selected_letter/", "<input type=\"text\" class=\"inputs\" maxlength=\"1\" value=\"\" />", $str); ?>

This echoes out into my page with no problems:

<input type="text" class="inputs" maxlength="1" value="" />

What I really need to echo is the following (as per the addform.php):

<input type="text" class="inputs" maxlength="1" value="<?php echo htmlspecialchars(@$_REQUEST['test']) ?>" />

Doing the following doesn't works as I am unable to echo <?php echo htmlspecialchars(@$_REQUEST['test']) ?> within the preg_replace echo if that makes sense...

<? echo preg_replace("/$selected_letter/", "<input type=\"text\" class=\"inputs\" maxlength=\"1\" value=\"<?php echo htmlspecialchars(@$_REQUEST['test']) ?>\" />", $str); ?>

I would greatly appreciate it if someone more skilled in php could point me in the right direction as to how/if I can acheive this? Maybe preg_replace is not the answer here but I have spent many days searching and not found a closer alternative so far..

Many Thanks!

this works great to get the filesize of each individual upload within a record, but i was wondering if there is similar code for the total size of all the uploads within a record ie if ten uploads have been uploaded what is the sum total of those ten not just individually if you follow...

cheers!

i am using the following code to add pdf upload file size information to my detail pages

<?php echo round(filesize($upload['filePath']) * .0009765625 * .0009765625, 2).' MB'; ?>

this works great but i was wondering if there is a similiar simple way to give me the sum total size of all uploads for a given record?

many thanks for you help!

e

Many thanks for your time!

Thanks for the reply, yeah sorry I know its a bit of an odd question to ask but the client would like it to be set up this way if possible.

If it is reasonably straight forward for you to do so, could you possibly tell me what I need to edit.

I'm reasonably comfortable editing the files as we have made a few edits already for report purposes.

Many thanks!

can anyone let me know if there is there a way to make the username field case sensitive?

many thanks for you help!

e

i have deactivated the previous version and removed it from the server then uploaded and activated your new edit however it does not appear to add a record in outgoing mail when logging into the client area...

one thing i omitted to mention in my previous post is that we are using the membership hack for the user logon time/ip address log as per:

http://www.interactivetools.com/forum/forum-posts.php?postNum=2217409#post2217409

http://www.interactivetools.com/forum/forum-posts.php?postNum=2213350#post2213350

could that be effecting the sending of alert email somehow?

i believe the only change in the membership plugin is the addition of the following lines:

// Save users last IP

$usersIpHasChanged = ($CURRENT_USER && $CURRENT_USER['last_ip'] != $_SERVER['REMOTE_ADDR']);
if ($usersIpHasChanged) {
mysql_update('accounts', $CURRENT_USER['num'], null, array('last_ip' => $_SERVER['REMOTE_ADDR']));
}

// CUSTOM CODE! add record to login_log

global $TABLE_PREFIX;
mysql_query(mysql_escapef("INSERT INTO {$TABLE_PREFIX}login_log SET createdDate = NOW(), who = ?, ip = ?", $CURRENT_USER['num'],$_SERVER['REMOTE_ADDR']))

your attached plugin here seems to be identical to the original plugin file?

in the decade or so that i have been using interactivetools software i have yet to come across another company with such consistently great support! keep up the good work!

we have had such a poor week with our webhost that we have jumped ship and set up somewhere new!

this has sorted the issue with the cms password reset not working and as per your advice i also have a basic mail script working fine no problems...

the alertAdminLogin plugin still doesnt seem to want to send any mail alerts out though...

do you know of any reason why this would not be working?

has anyone else here has experienced any problems using this plugin with 2.50?

would be nice to confirm the problem isn't between the pc and the chair!

many thanks for your help!

cheers for the info, nothing is going to spam so i set up a test email script which i have working on another site on the same hosting companies servers and it is not working here.

i should have tested that out first before coming here! sorry!

also just checked cmsbuilder install on this other site and the strange thing is even though the email script is working the cms installation password reminder on that site isn't working either (it had never been used so never noticed the error)

so kind of double confused now!

hopefully the hosting company will get back to me soon with fix and i can carry on developing the site..

many thanks for your help!

thanks for the help, this is a fresh installation of 2.50 using the membership plugin and admin login alert (i disabled these and had the same issue)

i just set up mail logging and cms builder indeed trying to send out the mail (it leaves a copy of the mail in ougoing)... so i guess its a server issue but not sure where to start?

any tips on where to start on this would be greatly appreciated

many thanks

elliot

I have a login log page set up to record details of when users enter the membership area pages giving me a simple list with username, time entered and ip as per the following posts

http://www.interactivetools.com/forum/forum-posts.php?postNum=2217409#post2217409

http://www.interactivetools.com/forum/forum-posts.php?postNum=2213350#post2213350

Does anyone know a way to record when the user logs off (or logged on time) and what membership pages were visited?

Many thanks for you help!

we have an issue with email on our cmsbuilder/server.

we are not receiving emails via the admin password reminder page and the alert admin login plugin which works with the membership plugin also isn't sending mail so i guess i have a bad setting somewhere.

my admin email address uses the same domain as the cms installation.

can anyone give me some hints on where to look to try and resolve this issue.

as far as i can see i have the admin email / server paths etc set up correctly in the general settings but no mail is being sent.

many thanks for you help!