msg_author is the same as username, same name in both fields/tables but is Letters only, author_id and user_id are again the same in both fields/tables, but this time is numeric.
SELECT COUNT(*) FROM `cpg14x_comments` WHERE msg_author = "Misty"; gives me a count result of 42. I thought if I could change "Misty" to username or poster_id then when viewtopic.php was run it would pick up the username or poster_id in the query and it would run. When it did not...
I've tried adding an if statement to the sql to help determine the username, with no success, I've tried the following two. if $username = get_username_string('full', $topic_data['topic_poster'], { $sql = 'SELECT COUNT(*) FROM `cpg14x_comments` WHERE msg_author = "$username"'; $result = $d...
I've added the sql and the second to last line in this first block of code here, and then made the edit to viewtopic_body.html. Only now it does not work. I think the problem is in the WHERE part and in particular the "username", should I be using some additional code to help me get the us...
I want to run a query and then print the result in the members profile on the topic, I think thats viewtopic_body.html. I have the query that gets the result I want and tested via phpmyadmin, I just need to know what to edit in the php files so that my result shows above or below where it says "...
"Exif" stands for "Exchangeable image file format" and is present in every photograph straight from the camera, some softwares remove it when it is saved, but the more serious photographer will keep it. Here is part of an exif from one of my old photos. Make = Canon Model = Canon...
The tabbed index I use was taken from the user control panel area and is controlled by this css #tabs a { background-image: url("{T_THEME_PATH}/images/bg_tabs1.gif"); } #tabs a span { background-image: url("{T_THEME_PATH}/images/bg_tabs2.gif"); color: #536482; } #tabs a:hover spa...
Hmm still not working, wonder if its to do with I'm using tabs. Sorry if it is as I did not think affect things. Here's the tabs code from overall_header <div id="tabs"> <ul> <li<!-- IF basename($_SERVER['SCRIPT_NAME']) == 'index.php' or basename($_SERVER['SCRIPT_NAME']) == 'viewforum.php'...
Is it possible to change the "x new messages" to red, when it has one or more new messages, but when its at zero..it stays the same colour as is default in prosilver? In functions.php, find: 'PRIVATE_MESSAGE_INFO' => $l_privmsgs_text, After, add: 'NEW_PM_NUMB...