Change Guest to User on threads (EZBoard)

[Marco van Herwaarden]

Change:

PHP Code:

     $getuserid=$DB_site->query_first("SELECT userid FROM user WHERE username='".addslashes($newusername)."'"); 


To:

PHP Code:

     $getuserid=$DB_site->query_first("SELECT userid FROM " . TABLE_PREFIX . "user WHERE username='".addslashes($newusername)."'"); 


[feldon23]

Originally Posted by MarcoH64

Change:

PHP Code:

     $getuserid=$DB_site->query_first("SELECT userid FROM user WHERE username='".addslashes($newusername)."'"); 


To:

PHP Code:

     $getuserid=$DB_site->query_first("SELECT userid FROM " . TABLE_PREFIX . "user WHERE username='".addslashes($newusername)."'"); 


Thanks, Marco! As always, an invaluable member of vb.org.

I've updated the script to reflect this change.

[a squared]

Thank you both!!! I saw the post this morning and immediately changed the code. uploaded and ran the script. Ran without a hitch! Is it safe to assume that this script is now supports all versions of vB 3.0.x? It certainly works in 3.0.8

Thanks again

Mike

[feldon23]

Originally Posted by a squared

Thank you both!!! I saw the post this morning and immediately changed the code. uploaded and ran the script. Ran without a hitch! Is it safe to assume that this script is now supports all versions of vB 3.0.x? It certainly works in 3.0.8

Thanks again

Mike

To my knowledge, the user, post, thread, and forum tables did not change from vB3.0.0 through 3.0.9. Anyone?

[vocalise]

Will this work on vbulletin 3.5.0? Freddie just did a wonderful job importing my board from ezboard to vbulletin, and I'm kind of lost what to do with the script (excuse this very new newbie)

I saved the script to ezimport.php and uploaded it.

Do I just access it from http://mydomain.com/admincp/ezimport.php and then run it that way? I ask because I'm getting errors. I must be something.

Any help would be greatly appreciated.

[feldon23]

Originally Posted by vocalise

Will this work on vbulletin 3.5.0? Freddie just did a wonderful job importing my board from ezboard to vbulletin, and I'm kind of lost what to do with the script (excuse this very new newbie)

I saved the script to ezimport.php and uploaded it.

Do I just access it from http://mydomain.com/admincp/ezimport.php and then run it that way? I ask because I'm getting errors. I must be something.

Any help would be greatly appreciated.

I have not tested it in vB3.5.0. What error(s) are you getting?

[vocalise]

I am getting the following errors:

Notice: Only variable references should be returned by reference in /home/vocalise/public_html/includes/class_core.php on line 1824

Notice: Only variable references should be returned by reference in /home/vocalise/public_html/includes/class_core.php on line 1771

Notice: Only variables should be assigned by reference in /home/vocalise/public_html/includes/class_core.php on line 1510

[feldon23]

Originally Posted by vocalise

I am getting the following errors:

Notice: Only variable references should be returned by reference in /home/vocalise/public_html/includes/class_core.php on line 1824

Notice: Only variable references should be returned by reference in /home/vocalise/public_html/includes/class_core.php on line 1771

Notice: Only variables should be assigned by reference in /home/vocalise/public_html/includes/class_core.php on line 1510

Guess I need to learn how to code for vB3.5. What would be really nice is if Jelsoft took this project over and officially supported it.

[akanevsky]

Install my port of the Advanced Editing Options for Mods and Admins, then you get to have such feature

[vocalise]

I installed the port of the Advanced Editing Options, and it seems to be installed properly.

However, when I got to http://_mydomain_/admincp/ezimport.php

I am still getting the same errors..