New Module "UserExtend"

[beatjost]

I have written a new module, which lets you store additional information for users (like address, phone, birthdate and freefields if whised -> config.php). The administration is in the admin-tools section and it's rather ment for backend purpose than to publish, but it might be suitable for a droplet or something... Available in English, Polish, Dutch, Norwegian and German. Also a zip available for frontend, so a logged in user may change its own data (post below).


Habe ein neues Modul geschrieben, welches zusätliche Informationen zu den Benutzern speichert (wie Adresse, Telefon, Geburtstag und freie Felder falls erwünscht -> config.php). Die Verwaltung erfolgt via Admin-Tools. Das Modul ist eher für den Backend-Bereich gedacht als für die Webseite, eignet sich aber wohl auch als Basis für ein Droplet... Aktuell in Deutsch, Holländisch, Norwegisch, Polnisch und Englisch verfügbar. Zusätzlich auch ein Zip für das Frontend verfügbar, so können eingeloggte Benutzer ihre Daten selber ändern (Post unten).





Download:
Admin-Modul (Version 2.0)
Frontend-Replacement WB2.8.3
(oder versions)
Admin-Modul (Version 1.4)
Frontend-Replacement WB2.8

Details: (AMASP)
Modul

[crnogorac081]

Just tried it, good work 

What I dont like is that only admin can change/view/update these info..there is no frontend interaction...and user cant change this data himself

cheers

[beatjost]

This would be a nice enhancement for the next version. I think the best place would be in the preference section, so each logged in user could change his detail information.

I just did not know how to change this form automatically within the install script... Did anybody have ideas?

[snark]

firts of all, I think this is really great stuff

1: I agree on what crnogorac081 says about the option for people to let them change their own extra's

2: Now all users are displayed in one big list but when using different groups in a website it would be very nice to have those users sorted.

3: It would also be very handy if the table that contains the info is sortable alphabethically not only on username but on the other fields too.
It is quite simple to add some code to make this possible

on http://www.cssjuice.com/16-sortable-table-techniques/ you will find lots of possibillities

[beatjost]

firts of all, I think this is really great stuff

1: I agree on what crnogorac081 says about the option for people to let them change their own extra's

2: Now all users are displayed in one big list but when using different groups in a website it would be very nice to have those users sorted.

3: It would also be very handy if the table that contains the info is sortable alphabethically not only on username but on the other fields too.
It is quite simple to add some code to make this possible

on http://www.cssjuice.com/16-sortable-table-techniques/ you will find lots of possibillities

=> Sorting ist now implemented, also the group is displayed. The frontend interaction is planned...

[beatjost]

Some pre-version of a frontend action for user extended data has been created. It's a droplet which should be placed on a private site. this allows a logged in user to change those data.

After saving the record the redirection links to an empty page   - does anybody know how to solve this?

Download Droplet: http://www.beatjost.heliohost.org/user_extend_fontend-droplet.zip
=> only with new version of UserExtend from 09.09.09...

[crnogorac081]

it doesnt have to be on private pages, you can set this code:

Code:

if ($_SESSION['USERNAME'] != NULL ) {

// User is loged in, then put code below..

}

cheers

[beatjost]

To add the extended field in frontend for the registerd user, just replace the files in the zip-archive for wb2.8.
This will show an extra block with those fields (Backend prefs are not done by now...)

Download Frontend 2.8: http://www.beatjost.heliohost.org/wb_account_2-8.zip

Download Frontend 2.7: http://www.beatjost.heliohost.org/wb_account_2-7.zip

[snark]

and for 2.7... will this work too?

[beatjost]

and for 2.7... will this work too?

I've added a 2.7 version, but not tested since I do not have this version anymore, but the files were mainly identically... please backup before testing. A short post about success or not would be nice 

[Hans>NULL]

Hallo.
Gibt's 'ne List-Möglichkeit aller Benutzer des UserExtend, ohne Änderungsmöglichkeit, nur zur Info, also auch nur für eingeloggte Benutzer/Mitglieder.
Gruß, Hans>NUL

[mr-fan]

hi jost,

Hallo.
Gibt's 'ne List-Möglichkeit aller Benutzer des UserExtend, ohne Änderungsmöglichkeit, nur zur Info, also auch nur für eingeloggte Benutzer/Mitglieder.
Gruß, Hans>NUL

könnte man das nicht mit dem modul "user-search" verbinden und ein "user-admin" daraus machen??

modul gibts hier:
http://www.websitebakers.com/pages/admin/admin-tools/user-search.php

also die suche nach den mitglieder daten + anzeige der daten aus deinem "extend" mod

wäre echt ein geniales teil - das user search hab ich fast auf jeder seite im einsatz!

mfg martin

Ps.: (schöne hochzeitsbilder - gratuliere nachträglich  )

[beatjost]

Hallo.
Gibt's 'ne List-Möglichkeit aller Benutzer des UserExtend, ohne Änderungsmöglichkeit, nur zur Info, also auch nur für eingeloggte Benutzer/Mitglieder.
Gruß, Hans>NUL

Aktuell gibt es keine solche Liste, ist aber relativ einfach möglich mit einem Droplet... (Beispiel unten).

Code:

// direct access prevention
if (defined('WB_PATH') == false) {
    exit("Cannot access this file directly");
}

if ($_SESSION['USERNAME'] == NULL ) {
  return "Not logged in!";
}

// load Language file
if (LANGUAGE_LOADED) {
    if (!file_exists(WB_PATH . '/modules/userextend/languages/' . LANGUAGE . '.php')) {
        require_once(WB_PATH . '/modules/userextend/languages/EN.php');
    } else {
        require_once(WB_PATH . '/modules/userextend/languages/' . LANGUAGE . '.php');
    }
}

// access database and obtain users table
$query = "SELECT * FROM `" . TABLE_PREFIX . "user_extend` e JOIN `" . TABLE_PREFIX . "users` u ON e.user_id=u.user_id JOIN `" . TABLE_PREFIX . "groups` g ON g.group_id=u.group_id ORDER BY u.display_name";
$results = $database->query($query);

$output;

$output = "<h2>" . $MUSEREXT_TEXT['HEADING'] . "</h2>";
$output .= "<table border=0>";
$output .= "<tr><th align='left'>".$MUSEREXT_TEXT['USR1']."</th><th align='left'>".$MUSEREXT_TEXT['FIELD1']."</th><th align='left'>".$MUSEREXT_TEXT['FIELD2']."</th><th align='left'>".$MUSEREXT_TEXT['FIELD3']."</th><th align='left'>".$MUSEREXT_TEXT['FIELD5']."</th><th align='left'>".$MUSEREXT_TEXT['FIELD6']."</th><th align='left'>".$MUSEREXT_TEXT['USR2']."</th><th align='left'>".$MUSEREXT_TEXT['FIELD8']."</th></tr>";

$i = 0;
$color;

// write out table with the usernames
while ($row = $results->fetchRow()) {
  if ($i % 2) {
      $color = "#FFFFFF";
  } else {
      $color = "#CCCCCC";
  }

  $output .= "<tr bgcolor='" . $color . "'><td>";
  $output .=  $row["display_name"] . "</td><td>" . $row["address"] . "</td><td>" . $row["zipcode"] . "</td><td>" . $row["city"] . "</td><td>" . $row["phone"] . "</td><td>" . $row["mobile"] . "</td>";
  $output .=  "<td><a href=\"mailto:" . $row["email"] . "\" title=\"" . $row["email"] . "\">" . $row["email"] . "</a></td>";
  $output .=  "<td><a href='" . $row["website"] . "' target='_new'>" . $row["website"] . "</a></td>";
  $i++;
}
$output .= "</table>";

return $output;

[Hans>NULL]

Toll, funktioniert wie gewünscht.
Ist denn schon Weihnachten?

Eines fehlt noch. Habe beim Versuch ID oder CLASS zuzuordnen (CSS)  leider PHP-Fehler bekommen.
Gibt's 'nen Tip, wie ich das korrekt einfügen kann. Habe den Eindruck, dass es an doppelten "" scheitert, aber "keine Ahnung", da kein Coder.

<edit>Hab's nun doch schon mal mit dem Titel etc. hinbekommen (Denkfehler, was sonst). Doch die Werte für Tabelle. und Schrift, die über $color gesetzt werden, stehen noch aus. Da werde ich mich jetzt auch versuchen, aber eigentlich "hört's spätestens hier für mich auf    Jemand, der sich auskennt, macht sowas in 5 Minuten fertig</edit>

Gruß, Hans>NUL

Edit: Ich war mal mutig und es klappt. Klassen für email und href fehlen noch.

Code:

// direct access prevention
if (defined('WB_PATH') == false) {
    exit("Cannot access this file directly");
}

if ($_SESSION['USERNAME'] == NULL ) {
  return "Not logged in!";
}

// load Language file
if (LANGUAGE_LOADED) {
    if (!file_exists(WB_PATH . '/modules/userextend/languages/' . LANGUAGE . '.php')) {
        require_once(WB_PATH . '/modules/userextend/languages/EN.php');
    } else {
        require_once(WB_PATH . '/modules/userextend/languages/' . LANGUAGE . '.php');
    }
}

// access database and obtain users table
$query = "SELECT * FROM `" . TABLE_PREFIX . "user_extend` e JOIN `" . TABLE_PREFIX . "users` u ON e.user_id=u.user_id JOIN `" . TABLE_PREFIX . "groups` g ON g.group_id=u.group_id ORDER BY u.display_name";
$results = $database->query($query);

$output;

$output = "<div id=uelthead>" . $MUSEREXT_TEXT['HEADING'] . "</div>";
$output .= "<table border=0>";
$output .= "<tr class=uelt><th align='left'>".$MUSEREXT_TEXT['USR1']."</th><th align='left'>".$MUSEREXT_TEXT['FIELD1']."</th><th align='left'>".$MUSEREXT_TEXT['FIELD2']."</th><th align='left'>".$MUSEREXT_TEXT['FIELD3']."</th><th align='left'>".$MUSEREXT_TEXT['FIELD5']."</th><th align='left'>".$MUSEREXT_TEXT['FIELD6']."</th><th align='left'>".$MUSEREXT_TEXT['USR2']."</th><th align='left'>".$MUSEREXT_TEXT['FIELD8']."</th></tr>";

$i = 0;
$css;
// write out table with the usernames
while ($row = $results->fetchRow()) {
  if ($i % 2) {
      $css = "class=ueltact";
  } else {
      $css = "class=ueltpass";
  }

  $output .= "<tr " . $css . "><td>";
  $output .=  $row["display_name"] . "</td><td>" . $row["address"] . "</td><td>" . $row["zipcode"] . "</td><td>" . $row["city"] . "</td><td>" . $row["phone"] . "</td><td>" . $row["mobile"] . "</td>";
  $output .=  "<td><a href=\"mailto:" . $row["email"] . "\" title=\"" . $row["email"] . "\">" . $row["email"] . "</a></td>";
  $output .=  "<td><a href='" . $row["website"] . "' target='_new'>" . $row["website"] . "</a></td>";
  $i++;
}
$output .= "</table><br />";

return $output;

Wenn man schon soweit ist, stellt sich die Frage nach 'ner frontend.css

[bupaje]

Hey this looks very interesting!

I am using Mura a ColdFusion CMS at work. They have a "Class Extension Manager" which provides this type of functionality. It allows extending User/Page/File and other classes with additional strictly typed values which are then available via coding (User.GetValue.MyExt endedAttribute) and 'Extended Attributes" tab for the User/Page/File Admin areas. It has proven very useful and versatile.

[xoanon]

firts of all, I think this is really great stuff

1: I agree on what crnogorac081 says about the option for people to let them change their own extra's

2: Now all users are displayed in one big list but when using different groups in a website it would be very nice to have those users sorted.

3: It would also be very handy if the table that contains the info is sortable alphabethically not only on username but on the other fields too.
It is quite simple to add some code to make this possible

on http://www.cssjuice.com/16-sortable-table-techniques/ you will find lots of possibillities

I have implemented a similar user-code functionality on our sports-site, where the end-user can modify their information...  please have a look at http://www.gvaa.eu  login-in as "dummy" password "dummy" (please do not change the password)...   if happy with what you see I can make the code available to the author of the "userExtend" module.... (please note that I have made changes (additions) to 2-3 core programs..
-- contact on am@idx.com.au --
regards
tony

[beatjost]

With new version 1.1 also a search is implemented (for username, displayname, email, groupname, city, address or website). Also some smaller bugs had been fixed...

[D. Peeters]

I've translated the language file into Dutch. See attachment...

[beatjost]

I've translated the language file into Dutch. See attachment...

Thanks! 

[crnogorac081]

Cool, just tested it.. Working great

cheers

[Hans>NULL]

Leider erhalte ich Fehlermeldungen:

Code:

Notice: Undefined index: param in /www/modules/userextend/tool.php on line 45
Notice: Undefined variable: where in /www/modules/userextend/tool.php on line 49
Notice: Undefined index: param in /www/modules/userextend/tool.php on line 55

Server: PHP as CGI
Gibt's "Serverzustände" zu beachten (z.B. htaccess) ?
Die 1.0 Version lief mal auf wb-portable ohne Probleme.
Gibt's bekannte Konflikte mit anderen Modulen ?
Ein paar Tip's zur Hand? Suchen & Prüfen kann ich dann wieder alleine 
Heute ist mein "Blauer Montag", also nur Ausführung und Beschränkung auf das was auf'm Zettel steht. 
Gruß, Hans>NUL

[beatjost]

Leider erhalte ich Fehlermeldungen:

Code:

Notice: Undefined index: param in /www/modules/userextend/tool.php on line 45
Notice: Undefined variable: where in /www/modules/userextend/tool.php on line 49
Notice: Undefined index: param in /www/modules/userextend/tool.php on line 55

Server: PHP as CGI
Gibt's "Serverzustände" zu beachten (z.B. htaccess) ?
Die 1.0 Version lief mal auf wb-portable ohne Probleme.
Gibt's bekannte Konflikte mit anderen Modulen ?
Ein paar Tip's zur Hand? Suchen & Prüfen kann ich dann wieder alleine 
Heute ist mein "Blauer Montag", also nur Ausführung und Beschränkung auf das was auf'm Zettel steht. 
Gruß, Hans>NUL

Hast du alle aktuellen fiels von version 1.1? Ev. zip nochmals überprüfen... Die Fehlermeldung sieht nach der neuen Suchfunktion aus?!

[beatjost]

Leider erhalte ich Fehlermeldungen:

Code:

Notice: Undefined index: param in /www/modules/userextend/tool.php on line 45
Notice: Undefined variable: where in /www/modules/userextend/tool.php on line 49
Notice: Undefined index: param in /www/modules/userextend/tool.php on line 55

Server: PHP as CGI
Gibt's "Serverzustände" zu beachten (z.B. htaccess) ?
Die 1.0 Version lief mal auf wb-portable ohne Probleme.
Gibt's bekannte Konflikte mit anderen Modulen ?
Ein paar Tip's zur Hand? Suchen & Prüfen kann ich dann wieder alleine 
Heute ist mein "Blauer Montag", also nur Ausführung und Beschränkung auf das was auf'm Zettel steht. 
Gruß, Hans>NUL

Hast du alle aktuellen fiels von version 1.1? Ev. zip nochmals überprüfen... Die Fehlermeldung sieht nach der neuen Suchfunktion aus?!

Versuch sonst mal in toolphp folgendes replacement...

  // access database and obtain users table
  $where = "";
  $search = "";
  if (isset($_POST['param']) AND $_POST['param'] != "") {

[Hans>NULL]

Kurze Rückmeldung
Leider erst in ein paar Tagen komme ich wieder dazu.
Werde es so ausführen wie vorgeschlagen.

Gruß, Hans>NUL

[snark]

the frontend add works for 2.7 but...

as you have succesfully subsrcibed you can log in but you cannot alter and save the extra info

in stead you are being redirected to the admin side where you get 'no user selected'

option 1 (no admin-rights)
- you cannot save the extra info (notification you have insufficiant rights to be here)


option 2 (subscribersgroup has rights to acces the admin)
- you cannot alter the info rightaway (news subscribers with no page edit rights)
- you are being send to the admin-side
- you have to add your account to the extend list manually
- you can access the other info

I think it should be more like the sample provided by xoanon, in his module the info gets saved in the frontend and the user is not bothered with the admin-side