:: ClanSphere :: Free OpenSource Clan CMS :: - Forum - mod/users/profile.php wie speichert die?

Antworten: 14

Seite [1]

maximal

Try to beat me

Beiträge: 189

# Thema - 09.10.2007 um 13:59 Uhr

füge mir gerade einen eintrag im profil hinzu, hab die *.tpl schon überarbeitet, die *.php aber er schreibt den wert nicht in die sql.

Jetzt meine frag, ist für das schreiben in die sql vll eine andere datei als die profile.php verantwortlich?

Inaktiv

Fr33z3m4n

Medal of Honor

Herkunft: Hamm
Beiträge: 11094

# Antwort: 1 - 09.10.2007 um 14:01 Uhr

nein, was hast du denn wo eingetragen ?

------------------
mfg
Patrick "Fr33z3m4n" Jaskulski

Antoine de Saint-Exupéry: Wenn Du ein Schiff bauen willst, so trommle nicht Männer zusammen, um Holz zu beschaffen, Aufgaben zu verteilen, sondern lehre die Männer die Sehnsucht nach dem endlosen weiten Meer.

Inaktiv

maximal
Thread-Ersteller

Try to beat me

Beiträge: 189

# Antwort: 2 - 09.10.2007 um 15:10 Uhr

coordx hab ich hinzugefügt, ist ein INT 8

profil.php

1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.
97.
98.
99.
100.
101.
102.
103.
104.
105.
106.
107.
108.
109.
110.
111.
112.
113.
114.
115.
116.
117.
118.
119.
120.
121.
122.
123.
124.
125.
126.
127.
128.
129.
130.
131.
132.
133.
134.
135.
136.
137.
138.
139.
140.
141.
142.
143.
144.
145.
146.
147.
148.
149.
150.
151.
152.
153.
154.
155.
156.
157.
158.
159.
160.
161.
162.
163.
164.
165.
166.
167.
168.
169.
170.
171.
172.
173.
174.
175.
176.
177.
178.
179.
180.
181.
182.
183.
184.
185.
186.
187.
188.
189.

1. / 2. / ...

<?php <?php
// ClanSphere 2007 - www.clansphere.net
// $Id: profile.php 185 2006-08-09 21:26:11Z hajo $

$cs_lang = cs_translate('users');

include_once('lang/' . $account['users_lang'] . '/countries.php');

$data = array();

if(isset($_POST['submit'])) {

  $op_users = cs_sql_option(__FILE__,'users');

  $cs_user['users_nick'] = $_POST['users_nick'];
  $cs_user['users_coordx'] = $_POST['users_coordx'];
  $cs_user['users_coordy'] = $_POST['users_coordy'];
  $cs_user['users_name'] = $_POST['users_name'];
  $cs_user['users_surname'] = $_POST['users_surname'];
  $cs_user['users_sex'] = $_POST['users_sex'];
  $cs_user['users_age'] = cs_datepost('age','date');
  $cs_user['users_height'] = $_POST['users_height'];
  $cs_user['users_country'] = $_POST['users_country'];
  $cs_user['users_postalcode'] = $_POST['users_postalcode'];
  $cs_user['users_place'] = $_POST['users_place'];
  $cs_user['users_adress'] = $_POST['users_adress'];
  $cs_user['users_icq'] = str_replace('-','',$_POST['users_icq']);
  $cs_user['users_msn'] = $_POST['users_msn'];
  $cs_user['users_skype'] = $_POST['users_skype'];
  $cs_user['users_email'] = $_POST['users_email'];
  $cs_user['users_url'] = $_POST['users_url'];
  $cs_user['users_phone'] = $_POST['users_phone'];
  $cs_user['users_mobile'] = $_POST['users_mobile'];
  $cs_user['users_info'] = $_POST['users_info'];

  $hidden = array();
  $hidden_count = isset($_POST['hidden']) ? count($_POST['hidden']) : 0;

  $canhid = array('users_name','users_surname','users_age','users_height','users_adress','users_place','users_icq','users_msn','users_skype','users_email','users_url','users_phone','users_mobile');
  for($hc = 0; $hc < $hidden_count; $hc++) {
    if(in_array($_POST['hidden'][$hc],$canhid)) {
      $hidden[] = $_POST['hidden'][$hc];
    }
  }

  $error = 0;
  $errormsg = '';

  $nick2 = str_replace(' ','',$cs_user['users_nick']);
  $nickchars = strlen($nick2);
  if($nickchars < $op_users['min_letters']) {
    $error++;
    $errormsg .= sprintf($cs_lang['short_nick'],$op_users['min_letters']) . cs_html_br(1);
  }

  $where = "users_nick = '" . cs_sql_escape($cs_user['users_nick']) . "' AND users_id != ";
  $search_nick = cs_sql_count(__FILE__,'users',$where . $account['users_id']);
  if(!empty($search_nick)) {
    $error++;
    $errormsg .= $cs_lang['nick_exists'] . cs_html_br(1);
  }

  $where = "users_email = '" . cs_sql_escape($cs_user['users_email']) . "' AND users_id != ";
  $search_email = cs_sql_count(__FILE__,'users',$where . $account['users_id']);
  if(!empty($search_email)) {
    $error++;
    $errormsg .= $cs_lang['email_exists'] . cs_html_br(1);
  }

  $pattern = "=^[_a-z0-9-]+(.[_a-z0-9-]+)*@([0-9a-z](-?[0-9a-z])*.)+[a-z]{2}([zmuvtg]|fo|me)?$=i";
  if(!preg_match($pattern,$cs_user['users_email'])) {
    $error++;
    $errormsg .= $cs_lang['email_false'] . cs_html_br(1);
  }

    if(!empty($cs_user['users_sex'])) {
        $cs_user['users_sex'] = $cs_user['users_sex'] == 'male' ? 'male' : 'female';
    }
    $country = $cs_user['users_country'];
    $cs_user['users_country'] = isset($cs_country[$country]) ? $cs_user['users_country'] : 'fam';
}
else {
  $cells = 'users_nick, users_name, users_surname, users_sex, users_age, users_height, users_country, users_postalcode, users_place, users_adress, users_icq, users_msn, users_skype, users_email, users_url, users_phone, users_mobile, users_info, users_hidden, users_coordx';
  $cs_user = cs_sql_select(__FILE__,'users',$cells,"users_id = '" . $account['users_id'] . "'");
  $hidden = explode(',',$cs_user['users_hidden']);
}
if(!isset($_POST['submit'])) {
$data['users']['body'] = $cs_lang['errors_here'];
}
elseif(!empty($error)) {
  $data['users']['body'] = $errormsg;
}
else {
  $data['users']['body'] =  $cs_lang['changes_done'];
}

if(!empty($error) OR !isset($_POST['submit'])) {

  $hidden = array_flip($hidden);
  if(empty($cs_user['users_height'])) { $cs_user['users_height'] = ''; }
  if(empty($cs_user['users_icq'])) { $cs_user['users_icq'] = ''; }
//  if(empty($cs_user['users_coordx'])) { $cs_user['users_coordx'] = ''; }

$sel = 'selected="selected"';
$checked = 'checked="checked"';

$data['form']['action'] = cs_url('users','profile');
$data['users']['users_nick'] = $cs_user['users_nick'];
$data['users']['users_coordx'] = $cs_user['users_coordx'];
$data['users']['users_name'] = $cs_user['users_name'];
$data['users']['users_surname'] = $cs_user['users_surname'];
$data['users']['users_age'] = cs_dateselect('age','date',$cs_user['users_age']);
$data['users']['male_check'] = $cs_user['users_sex'] == 'male' ? $sel : '';
$data['users']['female_check'] = $cs_user['users_sex'] == 'female' ? $sel : '';
$data['users']['users_height'] = $cs_user['users_height'];
$data['users']['users_postalcode'] = $cs_user['users_postalcode'];
$data['users']['users_place'] = $cs_user['users_place'];
$data['users']['users_adress'] = $cs_user['users_adress'];
$data['users']['users_icq'] = $cs_user['users_icq'];
$data['users']['users_msn'] = $cs_user['users_msn'];
$data['users']['users_skype'] = $cs_user['users_skype'];
$data['users']['users_email'] = $cs_user['users_email'];
$data['users']['users_url'] = $cs_user['users_url'];
$data['users']['users_phone'] = $cs_user['users_phone'];
$data['users']['users_mobile'] = $cs_user['users_mobile'];
$data['users']['users_info'] = $cs_user['users_info'];
$data['users']['country_url'] = cs_html_img('symbols/countries/' . $cs_user['users_country'] . '.png',0,0,'id="country_1"');

$data['hidden']['users_name'] = isset($hidden['users_name']) ? $checked : '';
$data['hidden']['users_coordy'] = isset($hidden['users_coordy']) ? $checked : '';
$data['hidden']['users_surname'] = isset($hidden['users_surname']) ? $checked : '';
$data['hidden']['users_height'] = isset($hidden['users_height']) ? $checked : '';
$data['hidden']['users_postalcode'] = isset($hidden['users_postalcode']) ? $checked : '';
$data['hidden']['users_place'] = isset($hidden['users_place']) ? $checked : '';
$data['hidden']['users_adress'] = isset($hidden['users_adress']) ? $checked : '';
$data['hidden']['users_icq'] = isset($hidden['users_icq']) ? $checked : '';
$data['hidden']['users_msn'] = isset($hidden['users_msn']) ? $checked : '';
$data['hidden']['users_skype'] = isset($hidden['users_skype']) ? $checked : '';
$data['hidden']['users_email'] = isset($hidden['users_email']) ? $checked : '';
$data['hidden']['users_url'] = isset($hidden['users_url']) ? $checked : '';
$data['hidden']['users_phone'] = isset($hidden['users_phone']) ? $checked : '';
$data['hidden']['users_mobile'] = isset($hidden['users_mobile']) ? $checked : '';

$data['abcode']['features'] =cs_abcode_features('users_info');
$data['abcode']['smilies'] = cs_abcode_smileys('users_info');

$data['country'] = array();

$run = 0;
foreach ($cs_country AS $short => $full) {
  $data['country'][$run]['short'] = $short;
  $data['country'][$run]['selection'] = $short == $cs_user['users_country'] ? ' selected="selected"' : '';
  $data['country'][$run]['full'] = $full;
  $run++;
}

echo cs_subtemplate(__FILE__,$data,'users','profile2');

}
else {
    settype($cs_user['users_height'],'integer');
    settype($cs_user['users_icq'],'integer');
    settype($cs_user['users_coordx'],'integer');
  $cs_user['users_hidden'] = implode(',',$hidden);

  $users_cells = array_keys($cs_user);
  $users_save = array_values($cs_user);
  cs_sql_update(__FILE__,'users',$users_cells,$users_save,$account['users_id']);

  $data['link']['continue'] = cs_url('users','home');
  $data['lang']['head'] = $cs_lang['profile'];
  echo cs_subtemplate(__FILE__,$data,'users','done');

  if($account['access_wizard'] == 5) {
    $wizard = cs_sql_count(__FILE__,'options',"options_name = 'done_prfl' AND options_value = '1'");
    if(empty($wizard)) {
      echo cs_html_br(1);
      echo cs_html_table(1,'forum',1);
      echo cs_html_roco(1,'leftc');
      echo $cs_lang['wizard'] . ': ';
      echo cs_link($cs_lang['show'],'wizard','roots') . ' - ';
      echo cs_link($cs_lang['task_done'],'wizard','roots','handler=prfl&done=1');
      echo cs_html_roco(0);
      echo cs_html_table(0);
      }
  }
}

?> ?>

Inaktiv

Fr33z3m4n

Medal of Honor

Herkunft: Hamm
Beiträge: 11094

# Antwort: 3 - 09.10.2007 um 16:21 Uhr

debug.php mal nutzen, was die auswirft?

gibs denn in der sql die spalten users_coordx ???

------------------
mfg
Patrick "Fr33z3m4n" Jaskulski

Inaktiv

maximal
Thread-Ersteller

Try to beat me

Beiträge: 189

# Antwort: 4 - 09.10.2007 um 16:31 Uhr

ja gibt es

debug.php

Warning: cs_html_table - Function goes away in next minor release, use themes instead
Warning: cs_html_roco - Function goes away in next minor release, use themes instead
lang/Spanish/info.php: cs_checkdirs - Required file not found
SELECT options_name, options_value FROM cs_options WHERE options_mod = 'clansphere'
SELECT users_id, users_nick, users_lang, access_id, users_limit, users_view, users_timezone, users_dstime FROM cs_users WHERE users_id = '1' LIMIT 0,1
UPDATE cs_users SET users_laston='1191933011' WHERE users_id='1'
SELECT * FROM cs_access WHERE access_id = '5' LIMIT 0,1
SELECT count_id, count_time FROM cs_count WHERE count_ip = '213.147.169.76' ORDER BY count_id DESC LIMIT 0,1
UPDATE cs_count SET count_time='1191933011', count_location='users/profile2' WHERE count_id='796'
SELECT options_name, options_value FROM cs_options WHERE options_mod = 'counter'
SELECT users_nick, users_name, users_surname, users_sex, users_age, users_height, users_country, users_postalcode, users_place, users_adress, users_icq, users_msn, users_skype, users_email, users_url, users_phone, users_mobile, users_info, users_hidden, users_coordx FROM cs_users WHERE users_id = '1' LIMIT 0,1
SELECT abcode_pattern, abcode_file FROM cs_abcode WHERE abcode_func = 'img' LIMIT 0,10
SELECT metatags_id, metatags_name, metatags_content FROM cs_metatags WHERE metatags_active = 1 ORDER BY metatags_name
SELECT COUNT(*) FROM cs_messages WHERE users_id_to = '1' AND messages_show_receiver = 1 AND messages_view = 0

Inaktiv

Fr33z3m4n

Medal of Honor

Herkunft: Hamm
Beiträge: 11094

# Antwort: 5 - 09.10.2007 um 16:35 Uhr

da ist aber nicht das speichern vorhanden

bitte wenn die Meldung kommt "Änderungen erfolgreich" bitte die debug. kopieren

------------------
mfg
Patrick "Fr33z3m4n" Jaskulski

Inaktiv

maximal
Thread-Ersteller

Try to beat me

Beiträge: 189

# Antwort: 6 - 09.10.2007 um 16:38 Uhr

debug.php beim speichern^^

lang/Spanish/info.php: cs_checkdirs - Required file not found
SELECT options_name, options_value FROM cs_options WHERE options_mod = 'clansphere'
SELECT users_id, users_nick, users_lang, access_id, users_limit, users_view, users_timezone, users_dstime FROM cs_users WHERE users_id = '1' LIMIT 0,1
UPDATE cs_users SET users_laston='1191933435' WHERE users_id='1'
SELECT * FROM cs_access WHERE access_id = '5' LIMIT 0,1
SELECT count_id, count_time FROM cs_count WHERE count_ip = '213.147.169.76' ORDER BY count_id DESC LIMIT 0,1
UPDATE cs_count SET count_time='1191933435', count_location='users/profile' WHERE count_id='796'
SELECT options_name, options_value FROM cs_options WHERE options_mod = 'counter'
SELECT options_name, options_value FROM cs_options WHERE options_mod = 'users'
SELECT COUNT(*) FROM cs_users WHERE users_nick = 'maximal' AND users_id != 1
SELECT COUNT(*) FROM cs_users WHERE users_email = 'mayer (dot) markus (at) gmx (dot) net' AND users_id != 1
UPDATE cs_users SET users_nick='maximal', users_name='', users_surname='', users_sex='male', users_age='1981-07-02', users_height='170', users_country='at', users_postalcode='', users_place='', users_adress='', users_icq='0', users_msn='', users_skype='', users_email='mayer (dot) markus (at) gmx (dot) net', users_url='', users_phone='2/10', users_mobile='', users_info='kommt noch^^rnrndie konfiguration der HP ist wichtiger', users_hidden='users_email' WHERE users_id='1'
SELECT metatags_id, metatags_name, metatags_content FROM cs_metatags WHERE metatags_active = 1 ORDER BY metatags_name
SELECT COUNT(*) FROM cs_messages WHERE users_id_to = '1' AND messages_show_receiver = 1 AND messages_view = 0

Zuletzt editiert von maximal am 09.10.2007 um 16:38 Uhr (1x Editiert)

Inaktiv

Fr33z3m4n

Medal of Honor

Herkunft: Hamm
Beiträge: 11094

# Antwort: 7 - 09.10.2007 um 16:40 Uhr

oberhalb von $users_cells = array_keys($cs_user);

bitte mal eintragen

print_R($cs_user);

und den ganzen teil dann kopieren und hier reinschreiben.

------------------
mfg
Patrick "Fr33z3m4n" Jaskulski

Inaktiv

maximal
Thread-Ersteller

Try to beat me

Beiträge: 189

# Antwort: 8 - 09.10.2007 um 16:45 Uhr

also, hab dass eingefügt in die profil2.php

und debug beim speichern kopiert, hoffe stimmt so^^

Ergebnis

lang/Spanish/info.php: cs_checkdirs - Required file not found
SELECT options_name, options_value FROM cs_options WHERE options_mod = 'clansphere'
SELECT users_id, users_nick, users_lang, access_id, users_limit, users_view, users_timezone, users_dstime FROM cs_users WHERE users_id = '1' LIMIT 0,1
UPDATE cs_users SET users_laston='1191933880' WHERE users_id='1'
SELECT * FROM cs_access WHERE access_id = '5' LIMIT 0,1
SELECT count_id, count_time FROM cs_count WHERE count_ip = '213.147.169.76' ORDER BY count_id DESC LIMIT 0,1
UPDATE cs_count SET count_time='1191933880', count_location='users/profile' WHERE count_id='796'
SELECT options_name, options_value FROM cs_options WHERE options_mod = 'counter'
SELECT options_name, options_value FROM cs_options WHERE options_mod = 'users'
SELECT COUNT(*) FROM cs_users WHERE users_nick = 'maximal' AND users_id != 1
SELECT COUNT(*) FROM cs_users WHERE users_email = 'mayer (dot) markus (at) gmx (dot) net' AND users_id != 1
UPDATE cs_users SET users_nick='maximal', users_name='', users_surname='', users_sex='male', users_age='1981-07-02', users_height='170', users_country='at', users_postalcode='', users_place='', users_adress='', users_icq='0', users_msn='', users_skype='', users_email='mayer (dot) markus (at) gmx (dot) net', users_url='', users_phone='2/10', users_mobile='', users_info='kommt noch^^rnrndie konfiguration der HP ist wichtiger', users_hidden='users_email' WHERE users_id='1'
SELECT metatags_id, metatags_name, metatags_content FROM cs_metatags WHERE metatags_active = 1 ORDER BY metatags_name
SELECT COUNT(*) FROM cs_messages WHERE users_id_to = '1' AND messages_show_receiver = 1 AND messages_view = 0

Inaktiv

Fr33z3m4n

Medal of Honor

Herkunft: Hamm
Beiträge: 11094

# Antwort: 9 - 09.10.2007 um 16:49 Uhr

nein du sollst dann das kopieren, was er ausgibt, nich beim debug. sondern print_r gibt die vars alle aus.

öhm moment, du redest gerade von profil2.php
versteh ich dann richtig, das du in der original profil.php nichts geändert hast. sondern diese kopiert, deine Änderungen dort rein, und dann per link ?mod=users&action=profile2 aufrufst ?

------------------
mfg
Patrick "Fr33z3m4n" Jaskulski

Inaktiv

maximal
Thread-Ersteller

Try to beat me

Beiträge: 189

# Antwort: 10 - 09.10.2007 um 16:51 Uhr

klar, zerschiesse mir ja nicht vorher meine funktionierende

hätte ich vll sagensollen?

Inaktiv

Fr33z3m4n

Medal of Honor

Herkunft: Hamm
Beiträge: 11094

# Antwort: 11 - 09.10.2007 um 16:52 Uhr

ohh ja

$data['form']['action'] = cs_url('users','profile');

ändern in

$data['form']['action'] = cs_url('users','profile2');

------------------
mfg
Patrick "Fr33z3m4n" Jaskulski

Inaktiv

maximal
Thread-Ersteller

Try to beat me

Beiträge: 189

# Antwort: 12 - 09.10.2007 um 17:01 Uhr

danke das wars, hetzt darf ich alles wieder ohne die 2 umbenennen; hätte ich es gleich ohne gemacht hätte es funktioniert. aber besser erst testen als site tot^^

das was ich jetzt geändert habe sagt CS soviel wie: du niemst die geänderten daten aus der profiel2.php (die ja ursprünglich von profile2.tpl übergeben werden) und schreibe sie in die datenbank, richtig?

Inaktiv

Fr33z3m4n

Medal of Honor

Herkunft: Hamm
Beiträge: 11094

# Antwort: 13 - 09.10.2007 um 17:14 Uhr

naja die sprichst die profile2.php an, is richtig, aber gibst die daten vom tpl an die profile.php wo coordx usw nich vorhanden ist.

------------------
mfg
Patrick "Fr33z3m4n" Jaskulski

Inaktiv

maximal
Thread-Ersteller

Try to beat me

Beiträge: 189

# Antwort: 14 - 09.10.2007 um 18:16 Uhr

k, besten dank, vll komm ich ja mal irgendwann alleine zurecht, aber finde hab mich fast nicht dumm angestellt^^

Inaktiv

Antworten: 14

Seite [1]

Sie müssen sich registrieren, um zu antworten.

Forum - Thema
Nächstes Thema ->
Forum -> ClanSphere -> Allgemein (ClanSphere) -> mod/users/profile.php wie speichert die?