vb.org Archive - vB Member Photo

Page 19 of 23

« First

Last »

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)

- - vB Member Photo (https://vborg.vbsupport.ru/showthread.php?t=49565)

Velocd

07-28-2003 04:52 PM

Ok, I've uploaded version 1.4a, with the two minor fixes.

But, I'm not sure if I've fixed the error in pverify.php. I run vBulletin 3 Beta 4, and don't have my hack installed anymore, so I couldn't test to make sure I coded it correctly.

So Areku, or anyone else, if you could please test if out for me a.s.a.p, to make sure that everything works fine with the verification. ;)

I'm sorta in a bit of a hurry, because I have to leave soon, and wont be back until later tonight.

Areku

07-28-2003 06:28 PM

I still keep getting it, on the same line.

Any workaround meanwhile?

TonTon

07-28-2003 07:08 PM

Is it possible to make this picture go into the Get info bit.

Velocd

07-28-2003 08:44 PM

Quote:

I still keep getting it, on the same line.

Any workaround meanwhile?

Whoa.. are you sure you uploaded the new pverify.php file? Clear your cache and download the zip as well, since there is always this cache-glitch up with attachments on this forum.

I used a different method, so you shouldn't be getting a "each()" error. If you are getting a different error, please post it.

Quote:

Is it possible to make this picture go into the Get info bit.

Look through this thread, somebody posted an add-on for making it show up in the get-info page.

Areku

07-28-2003 10:17 PM

U were rite! Damn cache! I even compared dates before uploading cached 1.4 and they were still different...

Anyway, now 1.4 is on place and I get a different error:

Code:

Database error in vBulletin Control Panel 2.3.0:



Invalid SQL: 

                                            SELECT id

                                            FROM memberphoto

                                            WHERE visible!=1

                             

mysql error: Unknown column 'id' in 'field list'



mysql error number: 1054



Date: Tuesday 29th of July 2003 01:18:03 AM

Script: http://www.domain.com/forums/forums/admin/pverify.php

Referer: http://www.domain.com/forums/admin/p...?action=verify

I'm not sure why is there a second "FORUMS" on the first (script) URL...

Rebel38

07-29-2003 01:09 AM

Quote:

Today at 04:22 AM Velocd said this in Post #179
That is how I plan to release it. ;)
I'll take note of your name, and PM you later down the road when I get near finishing.

Thanks Velocd , much appreciated mate :)

Cheers
Rebel

Velocd

07-29-2003 02:02 AM

Um, Areku, change this:

PHP Code:


		
			
                        SELECT id

                        FROM memberphoto

                        WHERE visible!=1

To:

PHP Code:


		
			
                        SELECT userid

                        FROM memberphoto

                        WHERE visible!=1

And tell me if it works ;)

ryans

07-29-2003 04:49 AM

is there any way to have it resize images to a certain width? I saw a hack on here that said it would decrease the size but I was not sure if that was the size in file size or the actual image size?

thanks

Areku

07-29-2003 08:34 AM

Quote:

Today at 04:02 AM Velocd said this in Post #187
Um, Areku, change this:

PHP Code:

SELECT id FROM memberphoto WHERE visible!=1

To:

PHP Code:

SELECT userid FROM memberphoto WHERE visible!=1

And tell me if it works ;)

Velocd,

Now SQL error disappeared, but photos are NOT neither approved nor disapproved...

They remain there... in the admin environment.

Velocd

07-29-2003 04:40 PM

Alright Areku, hopefully this change will fix it.

Replace all of this in pverify.php:

PHP Code:


		
			
    $uv_photos = $DB_site->query("

                        SELECT userid

                        FROM memberphoto

                        WHERE visible!=1

                 ");



    while($uv_photo = $DB_site->fetch_array($uv_photos)) {



        $id = $_POST['photouse']["$photo[id]"];



        $DB_site->query("

                    UPDATE memberphoto

                    SET visible='1'

                    WHERE userid='$id'");



    }

With:

PHP Code:


		
			
    $uv_photos = $DB_site->query("

                        SELECT userid AS id

                        FROM memberphoto

                        WHERE visible!=1

                 ");



    while($uv_photo = $DB_site->fetch_array($uv_photos)) {



        $id = $_POST['photouse']["$uv_photo[id]"];



        $DB_site->query("

                    UPDATE memberphoto

                    SET visible='1'

                    WHERE userid='$id'");



    }

Sorry for the trouble, if I could debug the code myself I would.. but as said I don't have this hack installed, being I am running vB3. ;)

All times are GMT. The time now is 05:03 PM.

Page 19 of 23

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01378 seconds Memory Usage 1,762KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (6)bbcode_php_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: