[MOD] SMF integration

[lesmond]

I did rem it out, and the error has gone now, nor do I see any errors in my log, thanks very much budduke 

[nguago]

I want 4images 1.7.6 & SMF 1.1.7 integration
I read http://www.4homepages.de/forum/index.php?topic=22672.0
But i don't success. Help !

[budduke]

I want 4images 1.7.6 & SMF 1.1.7 integration
I read http://www.4homepages.de/forum/index.php?topic=22672.0
But i don't success. Help !

I just upgraded my installation to the SMF 1.1.7 and it still works correctly for me...
You need to be more specific then just it does not work...

[nguago]

Code: [Select]

      $sql = "UPDATE ".USERS_TABLE."
              SET ".get_user_table_field("", "user_password")." = '".md5($user_password)."'
              WHERE ".get_user_table_field("", "user_id")." = ".$checkuser[$user_table_fields['user_id']];
      $site_db->query($sql);


Code: [Select]

    $sql = "UPDATE ".USERS_TABLE."
            SET ".get_user_table_field("", "user_email")." = '$user_email', ".get_user_table_field("", "user_showemail")." = $user_showemail, ".get_user_table_field("", "user_allowemails")." = $user_allowemails, ".get_user_table_field("", "user_invisible")." = $user_invisible, ".get_user_table_field("", "user_homepage")." = '$user_homepage', ".get_user_table_field("", "user_icq")." = '$user_icq'".$additional_sql."
            WHERE ".get_user_table_field("", "user_id")." = ".$user_info['user_id'];
    $site_db->query($sql);

In the includes\sessions.php dont have it. help me !

[budduke]

Both of those codes are in the Member.php file and not the session.php file.
I rechecked my original post and it is listed correctly.
Look for those codes in the member.php and everything should be fine.

[nguago]

Thanks 

[nguago]

Code: [Select]

if (($context['user']['is_owner'] && allowedTo('profile_remove_own')) || allowedTo('profile_remove_any'))
$context['profile_areas']['profile_action']['areas']['deleteAccount'] = '<a href="' . $scripturl . '?action=profile;u=' . $memID . ';sa=deleteAccount">' . $txt['deleteAccount'] . '</a>';

no have in the sources\profile.php file.
I use SMF 1.1.7

Help

[Nicky]

nguago,

source/Profile.php (unchanged)

line 258 and 259

[nguago]

Thanks, i'm finished !

copy
smf_api.php
smf_api_2.php
smf_api_2_examples.php
smf_api_subs.php

To /forums

But error:
Warning: require(./../../forums/smf_api_2.php) [function.require]: failed to open stream: No such file or directory in E:\AppServ\www\gallery\includes\sessions.php on line 58

file sessions.php on line 85:

require(ROOT_PATH.'../../forums/smf_api_2.php'); //change paths to your forums directory

[V@no]

require(ROOT_PATH.'../../forums/smf_api_2.php'); //change paths to your forums directory

[nguago]

new error:

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in E:\AppServ\www\forums\smf_api.php on line 162

[budduke]

new error:

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in E:\AppServ\www\forums\smf_api.php on line 162

See reply #13 and #14 on the 1st page of this topic...
It should explain it to you...

[Anarchology]

Hey guys,

It looks like I'm getting a series of errors here. For some odd reason, one of them is repeated. I checked the corresponding lines in question, and still can't figure out what the issue may be. I'm hoping you guys could point me in the right direction. I don't know if the the Ajax Starrating MOD has any conflict with the SMF integration, but I do have that mod added to my site already in perfect working order.

These are the errors that show up on the HOME page and under clicking on the categories...

Code: [Select]

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/sayyo1/public_html/taintedpix/forum/smf_api.php on line 162

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/sayyo1/public_html/taintedpix/includes/functions.php on line 524

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/sayyo1/public_html/taintedpix/includes/functions.php on line 524

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/sayyo1/public_html/taintedpix/includes/functions.php on line 524

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/sayyo1/public_html/taintedpix/includes/functions.php on line 524

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/sayyo1/public_html/taintedpix/includes/functions.php on line 524

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/sayyo1/public_html/taintedpix/includes/functions.php on line 524

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/sayyo1/public_html/taintedpix/includes/functions.php on line 524

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/sayyo1/public_html/taintedpix/includes/functions.php on line 524
I have also included my the two files they as they would be on my site when this problem shows up, but put them as "txt" since it says I can't upload a php file

Thanks in advance!!!!

[budduke]

Anarchology,

both files that were attached were blank (0k) in size.
The best thing I found was to zip the original files into one zip file and attach them.

the first error message seems to be normal, read the above replies on how to get rid of it...
the other one, will wait till I see the files...

[Anarchology]

Anarchology,

both files that were attached were blank (0k) in size.
The best thing I found was to zip the original files into one zip file and attach them.

the first error message seems to be normal, read the above replies on how to get rid of it...
the other one, will wait till I see the files...

Sorry, I'm an idiot, and it was getting late when I made the last post. I didn't transfer the actual PHP files into the text before uploading, since I can't upload a PHP file. I have fixed it, and uploading it again below. I should be messing with it all again tonight. If you can look at them for me, that would be great.  I did look back at posts #13 and #14. I added the "//" in there to ignore the section. I will still have to see if I still run that other code once I mess with it all later.


OK... I just pulled the line from functions.php below. By the looks of it, it almost seems like it might be related to the other error. I know some programming, but not all so maybe just talking out of my rear end here :

LINE 524 of functions.php (text file below has the whole thing)

Code: [Select]

$voted=mysql_num_rows(mysql_query("SELECT image_used_ips FROM ".IMAGES_TABLE." WHERE image_used_ips LIKE '%".$ip."%' AND image_id='".$image_id."' "));