Liberation_key

On our page you create User has name, address, email, and password as we release some liberation keys. These keys are already in MySql database. 

But my Dolphin 7.0.9 this accepting any key, password, and is not restricted keys that are in the database.

Any help?

Anybody to help us?

Try rewording your question/issue as I have no idea what you are talking about here.

Sorry, my English is terrible.

On our page "Join us"  you can create a User with  name, email  and  "liberation_keys". These keys are already in MySql database. 

But Dolphin 7.0.9 accept any password, and is not restricted by those keys that are in the database.

Thank you in advance.

Why would the password be restricted?

liberation_keys? I am not understanding based on definition of liberation http://www.thefreedictionary.com/liberation why it would have anything to do with a password.

And if you want to somehow restrict the password. That would require custom coding. Any password will be accepted that passes the password check field.

The last one is even more confusing.

The best thing to do is a screenshot of the entry your speaking about from the phpMyAdmin screen.

There is no entry like that in the "Profiles" in the database.

Have you added a module that is submitting a login code?

You need to explain in your language and let us translate what you mean.

 wait, please

In English:

Our business is to teach music from computer in schools  public/ from government. After, the childrens make upload  musics  to our Dolphin application and share with another students from other schools.

This is a closed app, we created LIBERATION_KEY that comes in the books that the children receive when starting this project. Only students can access our www.e-som.net/comunidades. 

We make update of our Dolphin in January, 2013 from 7.0.5 to 7.0.9 and we lost this script... any person can create a inscription there now. I make me understand now?

Thank you in advance.

Mila Menezes

In Portuguese:

Nosso negócio é ensinar música a partir do computador em escolas públicas / do governo. Depois, as crianças fazem upload de músicas para a nossa aplicação Dolphin e compartilhar com outros alunos de outras escolas.

Este é um aplicativo fechado, criamos LIBERATION_KEY que vem nos livros que as crianças recebem ao iniciar esse projeto. Apenas os estudantes podem acessar nossos www.e-som.net/comunidades.

Fazemos atualização de nosso Dolphin em janeiro de 2013, a partir de 7.0.5 para 7.0.9 e perdemos esse script ... qualquer pessoa pode criar uma inscrição agora. Faço-me entender agora?

Obrigado antecipadamente.

Mila Menezes

*we made update of our Dolphin

Our business is to teach music from your computer in public schools / government. Then kids do upload music to our application Dolphin and share with other students from other schools.

This is a closed application, created LIBERATION_KEY that comes in books that children receive when starting this project. Only students can access our www.e-som.net/comunidades.

We update our Dolphin in January 2013, from 7.0.5 to 7.0.9 and lost this script ... anyone can create a subscription now.

I think I am gaining an understanding.  The Liberation_key was needed in order for a student to sign up on the site; without the key the sign-up form would reject the registration to the site.

Adding this liberation_key back should not be that difficult but I am going to let the more knowledgeable ones guide you in this.

Ok, thank you geek girl.

I have the LIBERATION KEY in our MySQL data base. I need that our Join Page  accept only  LIBERATION KEY, that come in the books  and no another key different. Because if it stay open, somebody can enter  and  register easily.

Let me ask this, is the liberation_key used in place of a student's password to the site?  Or is it used to lock out registration if one does not have the key and the student still enters a password to access the site?

Hello,

No, the LIBERATION_KEY is used to confirm that user is a student and the password is required too . And for that we have a data base with all LIBERATION_KEY stored. We lost the script that verify if the LIBERATION_KEY already exist in our data base . If not, the user can´t create a account.

I realy need help.

Thank you.

Mila Menezes

 Can you not hire/contact the person that made that for you to begin with?

Yes Newton. But We´ll paid for that. The person responsable for this job doesn´t is employed anymore of the company that made this for us. So,  I want to try solve with of boonex forum help.

Thank you.

i wrote a script that does something similar - in my case - we are partnered with another organization. When a person signs up with that organization, they are advised that they may take advantage of the features of my site.

So, if a person decides that they do want to take advantage of my site, then they create an account, and enter their member ID of the partnered organization. A check is ran to first verify that their id exists, if it does then it automatically upgrades their membership level to unlimited streaming. If you want, I could send you what I wrote up and we can modify it for your needs.

I have to go out for a little bit, so here is what I have for mine. Please keep in mind, this will not stop a user from joining (we want members to join) but i am sure it can be modified for what you need. Hopefully one of the geniuses will be able to take it and help you modify it for your needs.

$user_id = $_COOKIE['memberID'];

// First off find out if there is an affiliate id

// Does id number exist

$is_id_present = mysql_query("select * from Profiles where ID = $user_id") or die

(mysql_error());
// We are going to use the "$row" method for this query. This is just my preference.
while ($row = mysql_fetch_array($is_id_present)) {
  
    $ID = $row["ID"];
    $Affiliation_Membership_ID = $row["Affiliation_Membership_ID"];
}

if ($Affiliation_Membership_ID == '') {

// No id number so now we gotta make sure membership does not allow streaming unless the date is not equal to zeros

$what_is_member2 = mysql_query("select * from sys_acl_levels_members where IDMember = $user_id") or die (mysql_error());
// We are going to use the "$row" method for this query. This is just my preference.
while ($row = mysql_fetch_array($what_is_member2)) {
  
    $IDLevel2 = $row["IDLevel"];
    $DateStarts2 = $row["DateStarts"];
}
// get current membership level

// check date and change membership level if equal to zeros

if ($DateStarts == '0000-00-00 00:00:00') {

mysql_query("UPDATE sys_acl_levels_members SET IDLevel = '2' WHERE IDMember = $user_id")
or die(mysql_error()); 

// do nothing else
}

}
else
{

// there is an id number so now we gotta check to see if the id number matches the one in the list

$is_membership_id_present = mysql_query("select * from affiliated_memberships where membership_code = $Affiliation_Membership_ID") or die (mysql_error());
// We are going to use the "$row" method for this query. This is just my preference.
while ($row = mysql_fetch_array($is_membership_id_present)) {
  
    $membership_code = $row["membership_code"];
}

if ($membership_code == '') {

// id number blank, so get existing membership level

$what_is_member3 = mysql_query("select * from sys_acl_levels_members where IDMember = $user_id") or die (mysql_error());
// We are going to use the "$row" method for this query. This is just my preference.
while ($row = mysql_fetch_array($what_is_member3)) {
  
    $IDLevel3 = $row["IDLevel"];
    $DateStarts3 = $row["DateStarts"];
}

// change membership to standard if date equals zeros

if ($DateStarts3 == '0000-00-00 00:00:00') {

mysql_query("UPDATE sys_acl_levels_members SET IDLevel = '2' WHERE IDMember = $user_id")
or die(mysql_error()); 

// do nothing else
}

}

else
{
// id numbers do match so now we gotta check membership levels again

$what_is_member = mysql_query("select * from sys_acl_levels_members where IDMember = $user_id") or die (mysql_error());
// We are going to use the "$row" method for this query. This is just my preference.
while ($row = mysql_fetch_array($what_is_member)) {
  
    $IDLevel = $row["IDLevel"];
}

if ($IDLevel == '') {

mysql_query("INSERT INTO sys_acl_levels_members (IDMember, IDLevel) VALUES ('$user_id', '4');")
or die(mysql_error()); 

}
elseif ($IDLevel == '1' OR $IDLevel == '2' OR $IDLevel == '3') {

mysql_query("UPDATE sys_acl_levels_members SET IDLevel = '4' WHERE IDMember = $user_id")
or die(mysql_error()); 
}
elseif ($IDLevel == '4') {
}
}
}

TO THE GENIUSES: I know my coding abilities are a little juvenile, please dont criticize me too much as I know there is a lot I still need to learn.

Have you contacted the company where the person was employed?  Most likely the company owns the script since the coder was an employee of the company.  Hopefully they will provide you with another copy of the script.

Looks like the same thing I use to verify you're a human. It's a simple code that's entered or the registration fails. Can't you guys understand broken english yet? I've been here for several years and I'm getting pretty good at it

Yes, I understand the nature of the problem perfectly.

Simply add a profile field to the join page with the argument

return strtolower($arg0) == 'your secret code';

 *bows

That will only cover one code.

As i understand it he has many.

Hello, 

I know that is too complicated to write here and  try to solve problems in app that you never saw the code. 

Before We do update, this was working very well. But after update from 7.0.5 to 7.0.9 We lost this control.

Only I need is that our Dolphin check it before of a new user can make your entrance in our app. If the Liberation_Key doesn´t exist in our data base, he must stop registration of a new member. 

Thank to all !!!

 Next question.

For such what looks like a very useful site, I would think you would have done backups of your database(s.)

Did you?

I should have asked this before.  You have the script, correct?  You just need the script added to the 7.0.9 installation.

I try to make a search in a backup before update. But I ask for LIBERATION_KEY and 

nothing was found. I did it until in Windows, for a search with more details and nothing was found.  Observing in Builders > Profile fields,  the block is an especial block. What it means? this is located only in database?...so many doubts....

I made right now,  a test in a copy that TMDHosting told us was a faithful copy of our app. But neither there it is working. :(  Now I´m complete lost . When it stoped of working?

If you would like me to take a look at fixing the problem, then you would need to send me a Private Message with your server access information.  Don't post the information in the forum; send it in a private message only.

Hello,

I came here to give very thank you.

We solved the problem thanks to you guys . geek_girl and Prashank25

Mila 

The solution was:

function checkIfInputAllowed($sValue)
{
      $sValue = strtolower(trim($sValue));
      if(!$sValue) return false;
      $sValue = process_db_input($sValue);

     // Check if the value even exists in the allowed values
     $iValueExist = $GLOBALS['MySQL']->getOne("SELECT `ID` FROM `table` WHERE `column` = '$sValue'");
     if(empty($iValueExist))
          return false;
      
     // The given value is valid, we are good lets be happy
     return true;
}

Table is replaced with the actual table in the database; and column is replaced with the column to check in that table.

In the form builder for the join form click on the name of the input field on the join form.  Click on advance tab and in the "check" field add:

return (checkIfInputAllowed($arg0)) ? true : false;

I love this line!

  // The given value is valid, we are good lets be happy
     return true;