trying to make php code work for profile

[sabret00the]

PHP Code:

 $webpage = $DB_site->query("
    SELECT *
    FROM " . TABLE_PREFIX . "userfield
");  

 $webpage['text'] = stripslashes($row['text']);
            
            //Check text-formatting settings
            $settingvbcode = iif($row['vbcodeorhtml'] == 'vbcode' AND $vboptions['webpageallowvbcode'] == '1', '1', '0');
            $settinghtml = iif($row['vbcodeorhtml'] == 'html' AND $vboptions['webpageallowhtml'] == '1', '1', '0');
            if($settinghtml == 0 AND $settingvbcode == 0) {
                $settingvbcode = 1;
            }
            
            if($vboptions['webpagesmilies'] == 1 and $row['usesmilies'] == 1) {
                $settingsmilies = 1; } else { $settingsmilies = 0; }
            
            if($settingvbcode == 1) {
                $webpage['text'] = parse_bbcode2($webpage['text'], $settinghtml, 1, $settingsmilies, $settingvbcode);
            }
            if($settinghtml == 1) {
                //Remove scripts!!!
                $webpage['text'] = preg_replace("/(\<script)(.*?)(script>)/si", "", $webpage['text']);
                //Don't hide anything!
                $webpage['text'] = str_replace("<!--", "&lt;!--", $webpage['text']);
                //Allow specified tags (if empty in admin, ALL tags are allowed! SECURITY RISK!)
                if($settinghtml == 1 && !empty($vboptions['allowedhtmltags'])) {
                    $webpage['text'] = strip_tags($webpage['text'], $vboptions['allowedhtmltags']);
                }
            }
            
            //Javascript will not be allowed
            $webpage['text'] = ereg_replace("~<script[^>]*>.+</script[^>]*>~isU", "", $webpage['text']); 
            
            $webpage['hits'] = $row['hits'];
            $webpage['bgcolor'] = $row['bgcolor'];
            $webpage['bordersize'] = $row['bordersize'];
            $webpage['bordercolor'] = $row['bordercolor'];
            $webpage['fontface'] = $row['fontface'];
            $webpage['fontsize'] = $row['fontsize'];
            $webpage['fontcolor'] = $row['fontcolor']; 


[Gio~Logist]

i dont see $profilefields2[fieldx] in that code

I think the code would be something like this:

PHP Code:

 $profilefields2 = $DB_site->query(" 
    SELECT profilefieldid, required, title, type, data, def, height 
    FROM " . TABLE_PREFIX . "profilefield 
    WHERE form = 0 OR 6 OR 7  OR 8" . iif(!can_moderate(), " 
        AND hidden = 0") . " 
    ORDER BY displayorder 
");  

 $webpage['text'] = stripslashes($row['text']); 
             
            //Check text-formatting settings 
            $settingvbcode = iif($row['vbcodeorhtml'] == 'vbcode' AND $vboptions['webpageallowvbcode'] == '1', '1', '0'); 
            $settinghtml = iif($row['vbcodeorhtml'] == 'html' AND $vboptions['webpageallowhtml'] == '1', '1', '0'); 
            if($settinghtml == 0 AND $settingvbcode == 0) { 
                $settingvbcode = 1; 
            } 
             
            if($vboptions['webpagesmilies'] == 1 and $row['usesmilies'] == 1) { 
                $settingsmilies = 1; } else { $settingsmilies = 0; } 
             
            if($settingvbcode == 1) { 
                $webpage['text'] = parse_bbcode2($webpage['text'], $settinghtml, 1, $settingsmilies, $settingvbcode); 
            } 
            if($settinghtml == 1) { 
                //Remove scripts!!! 
                $webpage['text'] = preg_replace("/(\<script)(.*?)(script>)/si", "", $webpage['text']); 
                //Don't hide anything! 
                $webpage['text'] = str_replace("<!--", "&lt;!--", $webpage['text']); 
                //Allow specified tags (if empty in admin, ALL tags are allowed! SECURITY RISK!) 
                if($settinghtml == 1 && !empty($vboptions['allowedhtmltags'])) { 
                    $webpage['text'] = strip_tags($webpage['text'], $vboptions['allowedhtmltags']); 
                } 
            } 
             
            //Javascript will not be allowed 
            $webpage['text'] = ereg_replace("~<script[^>]*>.+</script[^>]*>~isU", "", $webpage['text']); 


However.... i know i have to edit alot where it sais $webpage['text'] but how would i edit it so that it works as $profilefields2['fieldx'] where x is the profilefieldid

[sabret00the]

i'm assuming webpage[text] is the field you're reffering to from the useroptions right?

then that being the case you could just select that field with a query assign it to webpage text and voila you have what you need.

but in these peoblems it's hard to help as it's less about pointing out the error in the code, it's more about building the code and with limted info that's very hard

ps replace you're iff's with trinary operators and also you'll find data from the DB selects alot faster when columns are specified as opposed to wild cards.

[Gio~Logist]

I'm sorry but i am not a php coder, i am still in the learning process when it comes to php. If i have not been sepcific as to what it is i want to do let me say it once more :

The $webpage[text] has limits as to what html is allowed.... i would like the same for $post[fieldx] (where x is the ID of the profile field). I would just like for $post[fieldx] to follow the same html rules as $webpage[text]


Thanks once again,
Gio

[sabret00the]

what is the query $webpage?

[Gio~Logist]

[high]*gio~logist takes a ballpark*[/high]

PHP Code:

            if($settingvbcode == 1) {
                $webpage['text'] = parse_bbcode2($webpage['text'], $settinghtml, 1, $settingsmilies, $settingvbcode);
            }
            if($settinghtml == 1) {
                //Remove scripts!!!
                $webpage['text'] = preg_replace("/(\<script)(.*?)(script>)/si", "", $webpage['text']);
                //Don't hide anything!
                $webpage['text'] = str_replace("<!--", "&lt;!--", $webpage['text']);
                //Allow specified tags (if empty in admin, ALL tags are allowed! SECURITY RISK!)
                if($settinghtml == 1 && !empty($vboptions['allowedhtmltags'])) {
                    $webpage['text'] = strip_tags($webpage['text'], $vboptions['allowedhtmltags']);
                }
            }
            
            //Javascript will not be allowed
            $webpage['text'] = ereg_replace("~<script[^>]*>.+</script[^>]*>~isU", "", $webpage['text']); 
            
            $webpage['hits'] = $row['hits'];
            $webpage['bgcolor'] = $row['bgcolor'];
            $webpage['bordersize'] = $row['bordersize'];
            $webpage['bordercolor'] = $row['bordercolor'];
            $webpage['fontface'] = $row['fontface'];
            $webpage['fontsize'] = $row['fontsize'];
            $webpage['fontcolor'] = $row['fontcolor']; 


This?

[sabret00the]

nope, it will be above that and it should say something like $webtext = $DB_site->query("

etc

[Gio~Logist]

this is what i've seen so far that looks anything like what you posted

PHP Code:

    $sql = mysql_query("SELECT * FROM user_webpage WHERE userid = ".GBUSERID."");
    
    if(mysql_num_rows($sql) == 0) {
        
        //Create ext. profile
        $createsql = mysql_query("INSERT INTO user_webpage (userid,hits,vbcodeorhtml) VALUES (".GBUSERID.",'1','".$vboptions['webpagevbcodeorhtml']."')");
        //ladda om $sql v?rde
        $sql = mysql_query("SELECT * FROM user_webpage WHERE userid = ".GBUSERID."");
        
    } 


[sabret00the]

find the $row variable's creation.

[Gio~Logist]

THIS?

PHP Code:

            $webpage['text'] = stripslashes($row['text']);