Chrisj

Thanks. To reply: /home/public_html/payment/classes/config.php does not exist. ../ 's or just put the full path from public html - this showed no errors, but also no header/footer. Any other suggestions. Thanks.

I have header and footer showing on most web pages, but not this one added later. I tried copying a few lines from another page that HAS the header and footer appearing, but got many errors which I've listed below. (The page code shown below I've extracted some lines of private data) Any help with trying to add header and footer to it will be appreciated. Working page without header/footer: <?php // Get Details $amount = $_POST['valu']; $credits = $_POST['cre']; $user_id = $_POST['uid']; $item_name = $_POST['itnm']; // Include the paypal library include_once ('Paypal.php'); // Create an instance of the paypal library $myPaypal = new Paypal(); // Specify your paypal email // Specify the url where paypal will send the user on success/failure // Specify the url where paypal will send the IPN // Specify the product information $myPaypal->addField('item_name', $item_name); $myPaypal->addField('amount', $amount); $myPaypal->addField('item_number', $credits); // Specify any custom value $myPaypal->addField('custom', $user_id); // Enable test mode if needed ///$myPaypal->enableTestMode(); // Go $myPaypal->submitPayment(); Added some lines from other page that has header/footer as an attempt, but got errors: <?php (include_once ('classes/config.php'); (include_once ('classes/sessions.php'); // Get Details $amount = $_POST['valu']; $credits = $_POST['cre']; $user_id = $_POST['uid']; $item_name = $_POST['itnm']; // Include the paypal library include_once ('Paypal.php'); // Create an instance of the paypal library $myPaypal = new Paypal(); // Specify your paypal email // Specify the url where paypal will send the user on success/failure // Specify the url where paypal will send the IPN // Specify the product information $myPaypal->addField('item_name', $item_name); $myPaypal->addField('amount', $amount); $myPaypal->addField('item_number', $credits); // Specify any custom value $myPaypal->addField('custom', $user_id); // Enable test mode if needed ///$myPaypal->enableTestMode(); // Go $myPaypal->submitPayment(); The errors were: Warning: include_once(classes/config.php) [function.include-once]: failed to open stream: No such file or directory in /home/public_html/payment/thispage.php on line 3 Warning: include_once() [function.include]: Failed opening 'classes/config.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/public_html/payment/thispage.php on line 3 Warning: include_once(classes/sessions.php) [function.include-once]: failed to open stream: No such file or directory in /home/public_html/payment/thispage.php on line 4 Warning: include_once() [function.include]: Failed opening 'classes/sessions.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/public_html/payment/thispage.php on line 4 Any help/thoughts/suggestions will be appreciated.

Is there a way to Search PHPfreaks by user name only? When I try it asks for search words.

I'm working with a php script that has a form for uploading video files. One of the choices in the form is to choose a "channel". I'd like help in changing this, so the user doesn't have to choose, it's always the same channel choice. I was given some advice, but I could use some more information. Here is the existing code that i'd like to change. And below that is the advice I was given. <li style="width:240px; text-align:right;"><strong>[var.lang_select_channel]:</strong></li> <li style="width:400px; text-align:left;"> <select class="upload-video-form-input" style="width:160px;" size="1" name="channel" onchange="javascript:ahahscript.ahah('[var.base_url]/uploader.php?sub_cat='+ document.form_upload.channel.value, 'sub_change', '', 'GET', '', this);"> [var.fields_all;htmlconv=no]</select> ([var.lang_select_one]) </li> The advice: "You need to remove the select input, and add this type of hidden input: <input type="hidden" name=" Can someone help me create the right replacement code, so it will hidden and automatically choose a single channel? Thanks.

I'd like to change the color of this one word that appears at: [var.lang_edit_profile]. How do I add font color to this line: <li><strong><!--[onload_829;block=li;when [var.profile_menu]=1;comm]--><a href="[var.base_url]/edit/editprofile.php?id=[var.member_id]" rel="gb_page_center[870, 450]">[var.lang_edit_profile]</a> </strong></li> Thanks

Thanks for your reply. If I add $ip = $_SERVER[REMOTE_ADDR]; to my registration page and add a corresponding field in my database, this will allow me to capture the IP address of the regisrtant? Should the db field be named REMOTE_ADDR ? Obviously I could use some more information. Any additional enlightening would be appreciated.

I'm using a php script for my web site which has registration, log-in, etc. Can you tell me how I might be able to capture the registrants IP adress upon registration? Thanks.

Thanks for your reply. Here is the page of code: <?php session_start(); //CHECK IF FORM SUBMITTED if ($_POST['submitted'] == 'yes') { $pages = $_POST['id']; if (!isset($_POST['id'])) { echo "<script>document.location.href='index.php'</script>"; die(); } $skey = $_SESSION['searched']; if ($_POST['user_id'] != "") { $member_id = $_POST['user_id']; } if ($_POST['ttl'] != "") { $total = $_POST['ttl']; } } foreach ($pages as $vid) { $my_db_info[] = $vid; } include_once ('classes/config.php'); include_once ('classes/functions.inc.php'); $member_credits = get_member_credits($member_id); $balance = $member_credits - $total; if ($member_credits >= $total && $balance >= 0) { for( $x = 0; $x < sizeof( $my_db_info ); ++$x) { $sql = "INSERT INTO credits_temp ( mem_id, vid_id ) VALUES ( $member_id, $my_db_info[$x] )"; $query = @mysql_query($sql); } $sql1 = "UPDATE credits SET total_credits=$balance where user_id=$member_id"; //subtract credits $query1 = mysql_query($sql1); if ($query1 && $query) { $result = "Success! Payment Complete!<br><br>"; $rlink = "search.php"; //$rlink = "search.php?".$slink; $rtitle = "Go To Display"; }else{ $result = "There was a problem processing your request. Try again later or"; $rlink = "page.php?page=2"; $rtitle = "Contact Support"; } } else{ $error = "You do not have enough credits. To purchase credits, "; $rlink = "credits.php"; $rtitle = "Click Here"; } $template = "themes/$user_theme/templates/main_1.htm"; $inner_template1 = "themes/$user_theme/templates/inner_buy.htm"; //middle of page $TBS = new clsTinyButStrong; $TBS->NoErr = true; // no more error message displayed. $TBS->LoadTemplate("$template"); $TBS->MergeBlock('mp', $members_full); $TBS->Render = TBS_OUTPUT; $TBS->Show(); @mysql_close(); die(); /* // show "nothing to show" empty arrays if (empty($result_featured)) { $show_v = 1; } else { $show_v = 2; } // display results $template = "themes/$user_theme/templates/main_1.htm"; $inner_template1 = "themes/$user_theme/templates/inner_buy.htm"; //middle of page $TBS = new clsTinyButStrong; $TBS->NoErr = true; // no more error message displayed. $TBS->LoadTemplate("$template"); $TBS->MergeBlock('blkfeatured', $result_featured); $TBS->Render = TBS_OUTPUT; $TBS->Show(); @mysql_close(); die(); */ ?>

Enable html is probably good advice, but I don't know what in particular to do with that in regard to my request for help.

Thank you for your reply, but your suggestion appears on the web page like this: Success! Payment Complete! <br><br> Any other suggestions, would be appreciated.

Thanks for that reply. I tried this: $result = "Success! Payment Complete!"<br><br>; and I tried this: $result = "Success! Payment Complete!"; <br><br> $rlink = "search.php"; //$rlink = "search.php?".$slink; $rtitle = "Go To Display"; Both were unsuccessful.

In this if/else function (below), how can I put some space between "Success! Payment Complete!" and "Go To Display". When it shows up on the web page those two lines are stacked right on top of each other. How do I put some space between them? Thanks if ($query1 && $query) { $result = "Success! Payment Complete!"; $rlink = "search.php"; //$rlink = "search.php?".$slink; $rtitle = "Go To Display"; }else{ $result = "There was a problem processing your request. Try again later or"; $rlink = "page.php?page=2"; $rtitle = "Contact Support"; } }

On a page in a php script users are given a choice to choose which Channel thye want. I'd like to change this so the user choice is always the same and chosen automatically and hidden on the page. So the user basically skips this part. I asked a similar question somewhere else and was directed to "remove the select input, and add a hidden input. But I don't know how to do. This is the code, that shows choices, that I'd like to change to a hidden choice. Any help will be appreciated. Thanks. <li style="width:240px; text-align:right;"><strong>[var.lang_select_channel]:</strong></li> <li style="width:400px; text-align:left;"> <select class="upload-video-form-input" style="width:160px;" size="1" name="channel" onchange="javascript:ahahscript.ahah('[var.base_url]/uploader.php?sub_cat='+ document.form_upload.channel.value, 'sub_change', '', 'GET', '', this);"> [var.fields_all;htmlconv=no]</select> ([var.lang_select_one]) </li>

Thanks for that idea. I tried it unsuccessfully. There were many Warnings on the page.

I need a basic form to submit for a php web page. Can you provide one with a two seperate fields, one text area and a submit button? Thanks

I had help adding a paypal function to a php script I'm using. This help included adding a php page to the original script. This page, when displayed, doesn't show the header and footer like most of the pages do. When I asked how to make the header and footer appear on the new page I was told "you'll have to add the html in to the appropriate places". So, I'm hoping someomnje can help me with the code needed. I'm posting the new paypal page and also a original page that shows the header and footer. Can you direct me to the correct code from orginal page that I can add to the new page so the header and footer will show on the new page, please? Thanks New Page: <?php include_once ('classes/config.php'); // Get User Details $amount = $_POST['valu']; $credits = $_POST['cre']; $user_id = $_POST['uid']; // Include the paypal library include_once ('Paypal.php'); // Create an instance of the paypal library $myPaypal = new Paypal(); // Specify your paypal email $myPaypal->addField('business', 'admin@mywebsite.com'); // Specify the currency $myPaypal->addField('currency_code', 'USD'); // Specify the url where paypal will send the user on success/failure $myPaypal->addField('return', 'http://mywebsite.com/payment/paypal_success.php'); $myPaypal->addField('cancel_return', 'http://mywebsite.com/payment/paypal_failure.php'); // Specify the url where paypal will send the IPN $myPaypal->addField('notify_url', 'http://mywebsite.com/payment/paypal_ipn.php'); // Specify the product information $myPaypal->addField('item_name', 'Account Credits'); $myPaypal->addField('amount', $amount); $myPaypal->addField('item_number', $credits); // Specify any custom value $myPaypal->addField('custom', $user_id); // Enable test mode if needed ///$myPaypal->enableTestMode(); $myPaypal->submitPayment(); Original Page: <?php error_reporting(0); include_once ('classes/config.php'); include_once ('classes/sessions.php'); $default_album_pic = $config['default_album_pic']; /////////////////////////////////////////////////////////////////////////////////////// // changed search server method to get to get rid of cache expired error if( ( $_SERVER['REQUEST_METHOD'] != 'GET') ) dieNice(); $_SESSION['searched'] = $_GET['keyword']; $prch = $_GET['p']; if ($user_id == "") { $new_temp = "themes/$user_theme/templates/search_results_guest.htm"; }elseif ($prch == "1") { $new_temp = "themes/$user_theme/templates/search_results_paid.htm"; }else{ $new_temp = "themes/$user_theme/templates/search_results.htm"; } $queryString = strtolower($_SERVER['QUERY_STRING']); if (strstr($queryString,'%20union%20') OR strstr($queryString,'/*')) dieNice(); $referer = mysql_real_escape_string( $_SERVER['HTTP_REFERER'] ); if ( $referer == '' ) dieNice(); if ( !ereg ($_SERVER['SERVER_NAME'], $referer) ) $flag_stop++; if ( !ereg ($base_url, $referer) ) $flag_stop++; if ( $flag_stop == 2 ) dieNice(); $keywords = $_GET['keyword']; $keywords = str_replace('&#039;s', "", $keywords); //$keywords2 = $_GET['keyword']; $debug_log_file = 'logs/search_log.txt'; if (@file_exists($debug_log_file)) { $fo = @fopen($debug_log_file, 'a'); @fwrite($fo, $keyword); @fclose($fo); } else { $fo = @fopen($debug_log_file, 'w'); @fwrite($fo, $keyword); @fclose($fo); } $keyword = mysql_real_escape_string($keywords); $type = mysql_real_escape_string( $_GET['type'] ); if ($type == '') { $keyword = mysql_real_escape_string($keywords); $type = mysql_real_escape_string($_GET['type']); } if ($keyword == '' | $type == '' ) { $type = 'videos'; $keyword = 'none'; } $get_type = $type; switch ( $get_type ) { case 'videos'; $type_videos = 1; $row_id = 'video_id'; $media_comments = 'videocomments'; $type_query_rows = 'indexer, video_id, title, title_seo, date_uploaded, user_id, video_length, approved, public_private, description, tags, number_of_views'; break; } $query_get_type = $get_type; if ( $query_get_type == 'groups' ) { $query_get_type = 'group_profile'; $page_guery = "SELECT indexer FROM $query_get_type WHERE (group_name like '%$keyword%' or group_description like '%$keyword%')"; $search_query = "SELECT $type_query_rows FROM $query_get_type WHERE (group_name like '%$keyword%' or group_description like '%$keyword%') LIMIT "; // $set_limit, $limit"; } else { $tag_cloud = make_tag_cloud( $get_type ); $tag_cloud_block = $tag_cloud[1]; $page_guery = "SELECT indexer FROM $query_get_type WHERE approved = 'yes' AND public_private = 'public' and (title like '%$keyword%' or tags like '%$keyword%' or description like '%$keyword%')"; $search_query = "SELECT $type_query_rows FROM $query_get_type WHERE approved = 'yes' AND public_private = 'public' and (title like '%$keyword%' or tags like '%$keyword%' or description like '%$keyword%') LIMIT "; // $set_limit, $limit"; } if ( $query_get_type == 'group_profile' ) { $limit = (int) mysql_real_escape_string( $config['search_page_limits'] ); $pagination = pagination($page_guery, $limit); $set_limit = $pagination[0]['set_limit']; $total_pages = $pagination[0]['total_pages']; $current_page = $pagination[0]['current_page']; $total_records = $pagination[0]['total_records']; $next_page = $pagination[0]['next_page']; $prev_page = $pagination[0]['prev_page']; $nl = $pagination[0]['nl']; $pl = $pagination[0]['pl']; $results_of = $current_page * $limit; $results_show = $set_limit + 1; if ( $results_of > $total_records ) $results_of = $total_records; if ( $set_limit == 0 ) $results_show = 1; if ( $total_records == 0 ) $results_show = 0; //define($get_type, true); // TODO // /* add group rating to search display re-write the 3 queries below using 1 JOIN query */ // END // $sql = $search_query . $set_limit .','. $limit; $query = @mysql_query($sql); while ($result = @mysql_fetch_array($query)) { $group_id = $result['indexer']; $sql2 = "SELECT indexer, video_id FROM group_videos WHERE group_id = $group_id AND video_status = 'active'"; $query2 = @mysql_query($sql2); $count_group_videos = @mysql_num_rows($query2); //get group video thumbnail if ($count_group_videos == 0) { $video_picture = 'default_no_group_video'; $group_video_id = 0; } else { $result2 = @mysql_fetch_array($query2); $group_video_id = mysql_real_escape_string($result2['video_id']); $sql0 = "SELECT indexer, video_id FROM videos WHERE indexer = $group_video_id"; $query0 = @mysql_query($sql0); $result0 = @mysql_fetch_array($query0); $group_video_image = $result0['video_id']; $video_picture = $result0['video_id']; $group_video_id = $result0['indexer']; } $video_array = array('video_picture' => $video_picture, 'group_video_id' => $group_video_id); $sql3 = "SELECT indexer FROM group_membership WHERE group_id = $group_id"; $query3 = @mysql_query($sql3); $count_group_members = @mysql_num_rows($query3); $sql4 = "SELECT member_username, member_id FROM group_membership WHERE group_id = $group_id AND group_admin = 'yes'"; $query4 = @mysql_query($sql4); $result4 = @mysql_fetch_array($query4); $admin_username = $result4['member_username']; $group_other_info = array('group_videos' => $count_group_videos, 'group_members' => $count_group_members, 'admin_username' => $admin_username); //merge arrays $group_array = @array_merge($result, $group_other_info, $video_array); $mygroups[] = $group_array; } } if ( $type == 'videos' || $type == 'audios' || $type == 'images' || $type == 'blogs' ) { $limit = (int) mysql_real_escape_string( $config['search_page_limits'] ); $pagination = pagination($page_guery, $limit); $set_limit = $pagination[0]['set_limit']; $total_pages = $pagination[0]['total_pages']; $current_page = $pagination[0]['current_page']; $total_records = $pagination[0]['total_records']; $next_page = $pagination[0]['next_page']; $prev_page = $pagination[0]['prev_page']; $nl = $pagination[0]['nl']; $pl = $pagination[0]['pl']; $result_search = array(); $sql = $search_query . $set_limit .','. $limit; $query = @mysql_query($sql); $results_of = $current_page * $limit; $results_show = $set_limit + 1; if ( $results_of > $total_records ) $results_of = $total_records; if ( $set_limit == 0 ) $results_show = 1; if ( $total_records == 0 ) $results_show = 0; define($get_type, true); while ($result1 = @mysql_fetch_array($query)) { $media_id = mysql_real_escape_string($result1['indexer']); $sql2 = "SELECT indexer FROM $media_comments WHERE $row_id = $media_id"; $query2 = @mysql_query($sql2); $comments_number = @mysql_num_rows($query2); $comments_array = array('comments' => $comments_number); $id = $media_id; if ( $get_type == 'videos' ) { $stars_array = stars_array($media_id); } else { include ('stars_include.php'); $stars_array = array('star1' => $star1,'star2' => $star2,'star3' => $star3, 'star4' => $star4,'star5' => $star5); } // we need dynamic media image query $result_image = $get_type; switch ( $result_image ) { case 'audios'; $pic_sql = "SELECT album_picture FROM audio_albums WHERE album_id = '$media_id' LIMIT 1"; $album_pic_result = @mysql_query($pic_sql); $row = mysql_fetch_array( $album_pic_result ); $album_pic_result = $row['album_picture']; if ( $album_pic_result != "" ) { $album_pic = 'addons/audio/images/album_images/' . $album_pic_result; } else { $album_pic = 'addons/audio/images/' . $default_album_pic; } $result_image_array = array('media_image' => $album_pic); break; case 'images'; $full_view = $result1['image_id']; $full_url = $config['site_base_url'] . '/addons/albums/images/'.$full_view; $result_image_array = array('media_image' => $full_url); break; case 'blogs'; $blog_owner = $result1['user_id']; $a1_sql = "SELECT file_name, approved FROM pictures WHERE user_id = $blog_owner"; $a1_result = @mysql_query($a1_sql); if (@mysql_num_rows($a1_result) != 0) { $a1_result = @mysql_fetch_array($a1_result); $a1_existing_file = $a1_result['file_name']; $a1_approved = $a1_result['approved']; if ($a1_approved == "yes") { $poster_picture = $config['site_base_url'] . '/pictures/' . $a1_existing_file; } else { $poster_picture = $config['site_base_url'] . "/themes/$user_theme/images/placeholder.gif"; } } else { $poster_picture = $config['site_base_url'] . "/themes/$user_theme/images/placeholder.gif"; } $result_image_array = array('media_image' => $poster_picture); break; } // end switch media images //merge arrays if ( sizeof($result_image_array) > 0 ) $result2 = @array_merge($result1, $comments_array, $stars_array, $result_image_array); else $result2 = @array_merge($result1, $comments_array, $stars_array); $result_search[] = $result2; } } $video_price = videoPrice(); $total_price = $video_price * $total_records; $member_credits = get_member_credits($user_id); //PAGINATION PLUS $url = 'search.php'; $additional_url_variable = "?keyword=$keyword&type=$type&page="; include_once('includes/pagination.inc.php'); //PAGINATION PLUS >> end // checking for any error codes $codes = $_GET['code']; $error_code = errorcodes($codes); if (!empty($error_code)) { $blk_notification = $error_code['error_display']; $message_type = $error_code['error_type']; $error_message =$error_code['error_message']; } // create dynamic template words $url_link = $get_type; if ( $url_link == 'images' ) $url_link = 'albums'; if ( $query_get_type == 'group_profile' ) { if ( $results_show == 0 ) $type_groups = '0'; else $type_groups = 4; } $get_type = ucwords($get_type); $get_type_word = substr($get_type, 0, -1); $page_title = $config['site_name'] . ' ' . $get_type_word . ' ' . $lang_search . ' ' . $lang_results . ' ' . $lang_for . ' ' . $keyword; $template = "themes/$user_theme/templates/main_1.htm"; $inner_template1 = $new_temp; $TBS = new clsTinyButStrong; $TBS->NoErr = true; $TBS->LoadTemplate("$template"); if ( $query_get_type == 'group_profile' ) $TBS->MergeBlock('blkfeatured', $mygroups); else $TBS->MergeBlock('blkfeatured', $result_search); $TBS->MergeBlock('blkfeatured2', $result_search); $TBS->Render = TBS_OUTPUT; $TBS->Show(); @mysql_close(); die(); function dieNice() { header("Location: index.php"); die(); } ?>

Thanks for your help. I have not removed anything from the form. But I have added. I submitted this in the correct database under Submit Query, and a message appears that states "You have to choose at least one coulmn to display". Can you help direct me from here, please? <?php $sql = "INSERT into member_profile (email_address, user_name, password, passwordSalt, first_name, last_name, Address_1, Address_2, City, State, zip_code, country, birthday, account_status, account_type, date_created, random_code) VALUES ('$email_address', '$user_name', '$password', '$passwordSalt', '$first_name', '$last_name', '$Address_1' '$Address_2' '$City', '$State', '$zip_code', '$country_list', '$birthday', 'new', 'standard', NOW(), '$random_code')"; ?>

Thanks for looking here. I'd like to move the list of thumbnails that appears on the serch page of this php script (see attached). They appear on the left side of the right column. I'd like them to appear on the right side of the right columns and was told to tweak the serch results part of the page and the css. So i thought i'd start with the search resukts code> Can you help me determine which part of this code I could change to accomplish this? Thanks. Any help will be appreciated. <!--Begin Left Column--> <div id="column-left-2"> <br /> <!--Begin Popular Tag Cloud populate from search type ??--> <div class="header-narrow"><h3>[var.lang_Tags_most_popular]</h3></div> <div class="whats-showing"><!--[var.tag_cloud_block;htmlconv=no;comm]--></div> <div class="container-narrow-bottom"></div><!--End Popular Tag Cloud--> <!--Begin Left Advert--> <div class="container-narrow-top"></div> <div id="advert-left"><!--[var.ads_left;htmlconv=no;comm]--></div> <div class="container-narrow-bottom"></div><!--End Left Advert--> <div style="height:120px;"> </div> </div><!--End Left Column--> <!--Begin Right Column--> <div id="column-right-2"> <!--Begin Video Search List--> <div style="height: 2px;"> </div> <span style="margin-bottom: 12px;" class="font5_15"> "[var.keyword]" [var.get_type_word] [var.lang_search] [var.results_show] - [var.results_of] of [var.total_records] [var.lang_results] <br />You must <a href="login.php">log in</a> to view these video search results.<br /><br /> </span> <div id="content-list"> <ul class="content-list-thumb"> <li><a href="videos/[blkfeatured.indexer;block=div]/[blkfeatured.title_seo;block=div]"><img src="uploads/thumbs/[blkfeatured.video_id;block=div].jpg" alt="video pic" width="120" height="90" border="0" /></a></li> </ul> <ul class="content-list-info"> <li><h4> <!--[var.lang_title]:--><!--<a href="videos/[blkfeatured.indexer;block=div]/[blkfeatured.title_seo;block=div]"><!--[blkfeatured.title;htmlconv=no;block=div;ope=max:70;comm]--></a>--></h4></li> <li><b><!--[var.lang_description]:--> </b></li> <li><!--<span class="font4_12">[var.lang_rating] </span>--> <!--<img border="0" src="themes/[var.user_theme]/images/[blkfeatured.star1;block=div]" width="18" height="18" alt="1 Star" />--> <!--<img border="0" src="themes/[var.user_theme]/images/[blkfeatured.star2;block=div]" width="18" height="18" alt="1 Star" />--> <!--<img border="0" src="themes/[var.user_theme]/images/[blkfeatured.star3;block=div]" width="18" height="18" alt="1 Star" />--> <!--<img border="0" src="themes/[var.user_theme]/images/[blkfeatured.star4;block=div]" width="18" height="18" alt="1 Star" />--> <!--<img border="0" src="themes/[var.user_theme]/images/[blkfeatured.star5;block=div]" width="18" height="18" alt="1 Star" />--> <!--<span class="font4_12">[var.lang_views]: </span>--><!--(<!--[blkfeatured.number_of_views;block=div;comm]-->)--> <!--<span class="font4_12">[var.lang_duration]: </span>--><!--(<!--[blkfeatured.video_length;block=div;ope=max:45;comm]-->)--> <!--<span class="font4_12">[var.lang_uploaded]: </span>--> </li> <li><!--<span class="font4_12">[var.lang_tags]: </span>--></li> <!--<li><b>[var.lang_comments] - [var.lang_responses]: </b>(<!--[blkfeatured.comments;block=div;ope=max:80;comm]-->)</li>--> </ul> [onload;block=div;when [var.type_videos]=1;] </div> <!--End Video Search--> <!-- Pagination start --> <div align="center"> <div id="pagination"> <li> </li> <ul>[var.show_pages;htmlconv=no]</ul> </div> </div> <!-- Pagination end --> </div><!--End Right Column-->

Thanks for your reply. I think this code below is it. Does it look like it? Thanks <?php error_reporting (0); include_once ('classes/config.php'); include_once ('includes/reserved_names.php'); // define access for loading non display php files define('access',true); $ahah = 1; $show_register = ''; $load_ajax = ''; $form_submitted = ''; $action = ''; $new_user_name = ''; $account_type = ''; $first_name = ''; $last_name = ''; $email_address = ''; $email_address2 = ''; $user_name = ''; $password = ''; $confirm_password = ''; $country_list = ''; $dob_month = ''; $dob_day = ''; $dob_year = ''; $zip_code = ''; $birthday = ''; $error_message = ''; $checked = ''; $show_register = 1; $load_ajax = 1; $procede = true; $action = mysql_real_escape_string( $_GET['action'] ); $new_user_name = mysql_real_escape_string( $_GET['new_user_name'] ); $site_name = mysql_real_escape_string($config['site_name']); $form_submitted = mysql_real_escape_string( $_POST['form_submitted'] ); if ( $action == 'check_user' ) { $new_user_name = trim(strtolower($new_user_name)); if ( $new_user_name == '' ) { echo "<font color=\"#EE0000\" size=\"2\"><b>".$config['fill_all_fields']."</b></font>"; die(); } if ( strlen($new_user_name) < 4 ) { echo "<font color=\"#EE0000\" size=\"2\"><b>".$config['username_4_chars']."</b></font>"; die(); } // check against reserved names e.g. -> admin etc... or adult words ban if ( in_array( $new_user_name, $reserved_names ) ) { echo "<font color=\"#EE0000\" size=\"2\"><b>".$config['username_not_allowed'] .""; die(); } $sql = "SELECT user_name FROM member_profile WHERE user_name = '$new_user_name'"; $query = @mysql_query($sql); $count = @mysql_num_rows($query); if ( $count > 0 ) { echo "<font size=\"2\"><b>$new_user_name</b></font><font color=\"#EE0000\" size=\"2\"> <b>=> $lang_not_available</b></font>"; } else { echo "<font size=\"2\"><b>$new_user_name</b></font><font color=\"#00DD00\" size=\"2\"> <b>=> $lang_available </b></font>"; } @mysql_free_result($result); @mysql_close(); die(); } if ( $action == 'show_country' ) { $country_fields_all = ''; $show_fields = ''; $country_list = file('includes/country.list'); foreach ( $country_list as $country_select ) { $country_fields_all = $country_fields_all . $country_select; } $show_fields = '<div style="margin-left:30px; float:left;"><b>'.$lang_country.':</b></div>'; $show_fields .= '<div style="margin-left:95px; float:left;" id="country_list">'; $show_fields .= '<select class="FormSpecialInput_1" id="country_list" name="country_list" style="font-size: 9pt; width:128px; height:20px; font-weight:bold; color:#444444; letter-spacing: 1; border: 1px solid #DFDCDC; background-color: #FDFDFD">'; $show_fields .= $country_fields_all; $show_fields .= '</select></div>'; echo $show_fields; die(); } if ( $procede == true ) { $account_type = 'Standard'; $first_name = trim(mysql_real_escape_string( $_POST['first_name'] )); $last_name = trim(mysql_real_escape_string( $_POST['last_name'] )); $email_address = trim(mysql_real_escape_string( $_POST['email_address'] )); $email_address2 = trim(mysql_real_escape_string( $_POST['email_address2'] )); $user_name = trim(mysql_real_escape_string( $_POST['user_name'] )); $password = trim(mysql_real_escape_string( $_POST['password'] )); $confirm_password = trim(mysql_real_escape_string( $_POST['confirm_password'] )); $country_list = trim(mysql_real_escape_string( $_POST['country_list'] )); $dob_month = (int) mysql_real_escape_string( $_POST['dob_month'] ); $dob_day = (int) mysql_real_escape_string( $_POST['dob_day'] ); $dob_year = (int) mysql_real_escape_string( $_POST['dob_year'] ); $zip_code = (int) mysql_real_escape_string( $_POST['zip_code'] ); if ( $_POST['terms'] == 'yes' ) { $checked = 'checked=\"checked\"'; $procede = true; } else { $procede = false; $error_message = $config['agree_to_terms']; } // dDB birthday must be this format =>2008-09-17 $birthday = $dob_year .'-'. $dob_month .'-'. $dob_day; foreach ($_POST as $key => $value) { if (!isset($value) || ($value == '')) { $display_key = @str_replace('_', ' ', $key); if ( $display_key == 'zip code' && $value == '' ) { $value = 'none'; } else { $error_message = $error_message . ' - ' . $display_key . ' '.$lang_required.' '; $procede = false; } } else { if ( $key == 'email_address2' ) $key = 'email_address'; if ( $key !== 'email_address' && (!eregi("^[ _a-zA-Z0-9-]*$", $value)) ) { $display_key = @str_replace('_', ' ', $key); $error_message = $error_message . ' - ' . $display_key . ' '.$config['invalid_email_text'].' '; $procede = false; } if ( $key == 'email_address' && !eregi("^[_a-zA-Z0-9-]+(\.[_a-zA-Z0-9-]+)*@[a-zA-Z0-9-]+(\.[a-zA-Z0-9-]+)*(\.[a-z]{2,3})$", $value) ) { $display_key = @str_replace('_', ' ', $key); $error_message = $error_message . ' - ' . $display_key . ' '.$config['invalid_email_format'].' '; $procede = false; } if ( $key == 'user_name' ) { // check against reserved names e.g. -> admin etc... or adult words ban if ( in_array( $user_name, $reserved_names ) ) { $display_key = @str_replace('_', ' ', $key); $error_message = $error_message . ' ' .$config['username_not_allowed'] . ' !'; $procede = false; } } } } } // checking if emails match if ( $procede == true ) { if ( $email_address !== $email_address2 ) { $error_message = ' '.$config['emails_do_not_match']; $procede = false; } } // checking if passwords match if ( $procede == true ) { if ($confirm_password !== $password) { $error_message = ' '.$config['password_do_not_match']; $procede = false; } } // checking if username and email is unique if ( $procede == true ) { $sql = "SELECT user_name, email_address FROM member_profile"; $query = @mysql_query($sql); while ($result = (@mysql_fetch_array($query))) { if ( !empty($result['user_name']) || !empty($result['email_address']) ) { // case insensitive login and registration $reg_user_name = strtolower($user_name); $db_user_name = strtolower($result['user_name']); if ($db_user_name == $reg_user_name) { $error_message = ' '.$config['username_is taken']; $procede = false; } if ( $result['email_address'] == $email_address ) { $error_message = $error_message . ' -'.$config['email_already_exists']; $procede = false; } } } } // if any errors display error message => [var.message_type] - [var.error_message] if ($procede == false && $form_submitted == "yes") { $message_type = $lang_error; $blk_notification = 1; $show_signup = 1; $template = "themes/$user_theme/templates/main_1.htm"; $inner_template1 = "themes/$user_theme/templates/inner_signup_form.htm"; $TBS = new clsTinyButStrong; $TBS->NoErr = true; $TBS->LoadTemplate("$template"); $TBS->Render = TBS_OUTPUT; $TBS->Show(); @mysql_close(); die(); } // START => load page with form if ( !isset($form_submitted) || ($form_submitted == '') ) { $show_signup = 1; $template = "themes/$user_theme/templates/main_1.htm"; $inner_template1 = "themes/$user_theme/templates/inner_signup_form.htm"; $TBS = new clsTinyButStrong; $TBS->NoErr = true; $TBS->LoadTemplate("$template"); $TBS->Render = TBS_OUTPUT; $TBS->Show(); die(); } // if no errors register user and load welcome page if ($procede == true) { $random_code = randomcode(); $password_email = $password; $password = md5($password); $passwordSalt = substr(md5(rand()), 0, 4); if ( $zip_code > '' ) { $country_list = 'USA'; } // insert new user record $sql = "INSERT into member_profile (email_address, user_name, password, passwordSalt, first_name, last_name, zip_code, country, birthday, account_status, account_type, date_created, random_code) VALUES ('$email_address', '$user_name', '$password', '$passwordSalt', '$first_name', '$last_name', '$zip_code', '$country_list', '$birthday', 'new', 'standard', NOW(), '$random_code')"; @mysql_query($sql) or die($config['error_26']);//error // get new user_id $sql = "SELECT user_id, email_address, random_code FROM member_profile WHERE random_code = '$random_code' AND email_address = '$email_address'"; $query = @mysql_query($sql); while ($result = @mysql_fetch_array($query)) { $user_id = $result['user_id']; } // set new user default privacy settings $sql = "INSERT INTO privacy (videocomments, profilecomments, privatemessage, friendsinvite, newsletter, user_id, publicfavorites, publicplaylists) VALUES ('yes', 'yes', 'yes', 'yes', 'yes', '$user_id', 'yes', 'yes')"; $query = @mysql_query($sql); @mysql_close(); // send email $email_template = 'email_templates/newmember.htm'; $subject = $config['email_welcome']; $to = $email_address; $from = $config['notifications_from_email']; //send email template to TBS for rendering of variable inside $template = $email_template; $TBS = new clsTinyButStrong; $TBS->NoErr = true; $TBS->LoadTemplate("$template"); $TBS->tbs_show(TBS_NOTHING); $message = $TBS->Source; //load postage.php define('access',true); include ('includes/postage.php'); // show success $notification_type = $config['notification_success']; $message = $config['registration_success']; $blk_notification = 0; $template = "themes/$user_theme/templates/main_1.htm"; $inner_template1 = "themes/$user_theme/templates/inner_notification.htm"; $TBS = new clsTinyButStrong; $TBS->NoErr = true; $TBS->LoadTemplate("$template"); $TBS->Render = TBS_OUTPUT; $TBS->Show(); @mysql_close(); die(); } ?>

Greybox, the pop-up window: http://orangoo.com/labs/GreyBox/ I'd just like to know how I can get it to pop-up not in the center of the page. I'd like it to pop-up on the left side of the page. Is that possible? If so can you help me accomplish this? I was told to look at the CSS styles, but I and others were unsuccessful there. It amy need added code. Any help would be appreciated. Thanks.

In a php script I'm using the Registration page only had fields for name and email address, basically. I added fields, just by copying the code on the page. I added Address1, Address2, City and State. Then I added those fields to the mysql db. However, I need help with two things, when I Submit, and some field happens to be incomplete an error message appears and asks the user to complete. All fields remain filled, except the ones I added. How to I keep my just-added-fields populated, like the rest of the fields? And secondly, when I tested my additions, by registering, my newly added fields info, didn't get added to the db. Your help will be appreciated. <div class="signup-right"> <h1 style="border-bottom: 1px solid #666666;">[var.lang_register_today]!</h1> <form action="join.php" method="post" name="capform" class="FormGeneric" onSubmit="return capCheck(this);"> <div> <div style="margin-left:52px; float:left;"> <b>[var.lang_first_name]:</b> </div> <div style="margin-right:50px; float:right;"> <input type="text" name="first_name" size="20" value="[var.first_name]" /> </div> </div> <br /> <br /> <div> <div style="margin-left:52px; float:left;"> <b>[var.lang_last_name]:</b> </div> <div style="margin-right:50px; float:right;"> <input type="text" name="last_name" size="20" value="[var.last_name]" /> </div> </div> <br /> <br /> <div> <div style="margin-left:52px; float:left;"> <b>Address 1:</b> </div> <div style="margin-right:50px; float:right;"> <input type="text" name="address_1" size="26" value="[var.Address_1]" /> </div> </div> <br /> <br /> <div> <div style="margin-left:52px; float:left;"> <b>Address 2:</b> </div> <div style="margin-right:50px; float:right;"> <input type="text" name="address_2" size="26" value="[var.Address_2]" /> </div> </div> <br /> <br /> <div> <div style="margin-left:52px; float:left;"> <b>City:</b> </div> <div style="margin-right:50px; float:right;"> <input type="text" name="city" size="26" value="[var.city]" /> </div> </div> <br /> <br /> <div> <div style="margin-left:52px; float:left;"> <b>State/Province:</b> </div> <div style="margin-right:50px; float:right;"> <input type="text" name="state" size="26" value="[var.state]" /> </div> </div> <br /> <br /> <div> <div style="margin-left:52px; float:left;"> <b>Zip Code/Mail Code:</b> </div> <div style="margin-right:110px; float:right;"> <input type="text" name="zip_code" size="6" maxlength="5" value="[var.zip_code]" /> </div> </div>

If you're familiar with Greybox, the pop-up window: http://orangoo.com/labs/GreyBox/ I'd just like to know how I can get it to pop-up not in the center of the page. I'd like it to pop-up on the left side of the page. Is that possible? If so can you help me accomplish this? Thanks.

Currently, a vistor to the web site can search by keyword and the script generates a total number of results. I’d like to multiply the number of searched results by a set price, and proceed to Paypal for payment, and then be re-directed to a protected page. If the set price for each searched result is $1, just as an example, and the total number of searched results generated is 29, then process 29 x $1 = $29.00. If the number generated is 29 or more—process $1 x 29, or $1 x30, or $1 x 31, etc. If the number generated is less then 29, charge the minimum price of $29, and the unused paid units get stored in the User account for credit towards future purchases. For example, if the number generated is 9, the User pays the minimum price of $29, and 20 credits are added to his membership account. The next time he visits the web site he searches by keyword, this search generates results, the total number, for example is 12, he pays nothing, and proceeds (to Paypal? or) the protected page, and now has a credit in his account of 8. (20 - 12 = . When he next visits and generates a number, say for example 15, he only has 8 credits in his account, so he must pay another minimum payment of $29, which puts his account at 29 + 8 - 15 = 22 credits on account. Can you give me your thoughts on this?

Can Crystal Reports be used with MySQL? If not, what reporetiung tool do you recommend?

I was provided this code (and some css) to create three boxes on my web site. It was successful. Now what code do I need to add content to these boxes? Thanks. <div class="container1"> </div> <div class="container1"> </div> <div class="container1"> </div>