Register Ip

[__G__]

hi can we record ip of people who registers the account on 4images ?

[CeJay]

There use to be a mod for this. I think from The Oracle?

I have not seen it in a while and can not find it.

[trez]

Well, just create a new field in your database and use for example

Code: [Select]

 
    $user_ip = $site_sess->user_ip;
    $additional_field_sql .= ", user_ip";
    $additional_value_sql .= ", '$user_ip'";
in your register.php ... of course you have to include it in your adminarea etc, but that wouldnt be difficult

[__G__]

bro i am not really a coder can u gimme instructions step by step please

[trez]

use the search for "additional user field", there was a large thread somewhere ... use "user_ip" as your new userfield. After you've done that open your register.php,
and find:

Code: [Select]

  if (!$error) {
    $additional_field_sql = "";
    $additional_value_sql = "";
    if (!empty($additional_user_fields)) {
      $table_fields = $site_db->get_table_fields(USERS_TABLE);
      foreach ($additional_user_fields as $key => $val) {
        if (isset($HTTP_POST_VARS[$key]) && isset($table_fields[$key])) {
          $additional_field_sql .= ", $key";
          $additional_value_sql .= ", '".un_htmlspecialchars(trim($HTTP_POST_VARS[$key]))."'";
        }
      }
    }
right after add:

Code: [Select]

    // IP Logging of new user
    $user_ip = $site_sess->user_ip;
    $additional_field_sql .= ", user_ip";
    $additional_value_sql .= ", '$user_ip'";
save it, and you should see the IP in the admin area under "edit user" (if you followed the thread for the add. user field)

[__G__]

bro when i run the run it in php my admin it shows this

Error

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unknown Punctuation String @ 22
STR: -&
SQL: $user_ip = $site_sess->user_ip

SQL query:

$user_ip = $site_sess->user_ip

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '$user_ip = $site_sess->user_ip' at line 1

[Acidgod]

Well, just create a new field in your database

Do you have done it bevor?

$user_ip = $site_sess->user_ip

And this is not for phpmyamdin!!!

[__G__]

how do we do that bro

[Acidgod]

ALTER TABLE `XXXX_users` ADD `user_ip` VARCHAR( 20 ) NOT NULL ;

Use the SQL Snippet (in phpmyadmin) to create a new Field (user_ip) in the User Table (rename XXXX_users)...

Good speed....

[__G__]

i am still lost abt this database thingy

[__G__]

 SQL query:

ALTER TABLE `XXXX_users` ADD `user_ip` VARCHAR( 20 ) NOT NULL


.XXXX_users' doesn't exist

[impss]

The XXXX is inteded for you to change.

Depending on what you use in your database.

I believe if you did not make any changes to that on install it would be 4Images_users

So then you would run:

Code: [Select]

ALTER TABLE `4Images_users` ADD `user_ip` VARCHAR( 20 ) NOT NULL ;

[__G__]

wow thanks a lot >< it worked

[__G__]

i did everything i dont see the ip Username    Email    Date of registration    Last activity    Options
   testaccount    lol@lol.com    07.02.2007 06:59    07.02.2007 06:59    

[Edit]  [Delete]    [Permissions]  [User Groups] 

[Foto-Portal]

hi erveryone.

its the same problem for me.
i can only see:

Username - Date - Date of registry - last action - options

???

thx for reply