ctcp
-
Posts
170 -
Joined
-
Last visited
Never
ctcp's Achievements
Regular Member (3/5)
1
Reputation
-
i need somthink like this <li><a href="test.php" if($pageOn == 'test.php'){ id="selected" }>home</a></li> becouse not working ?> <? ..
-
Hello im runnin Smf forum and im trying add some links in my header but im confuesed how to syntax can sombady help me <?php /** * Simple Machines Forum (SMF) * * @package SMF * @author Simple Machines * @copyright 2011 Simple Machines * @license http://www.simplemachines.org/about/smf/license.php BSD * * @version 2.0 */ /* This template is, perhaps, the most important template in the theme. It contains the main template layer that displays the header and footer of the forum, namely with main_above and main_below. It also contains the menu sub template, which appropriately displays the menu; the init sub template, which is there to set the theme up; (init can be missing.) and the linktree sub template, which sorts out the link tree. The init sub template should load any data and set any hardcoded options. The main_above sub template is what is shown above the main content, and should contain anything that should be shown up there. The main_below sub template, conversely, is shown after the main content. It should probably contain the copyright statement and some other things. The linktree sub template should display the link tree, using the data in the $context['linktree'] variable. The menu sub template should display all the relevant buttons the user wants and or needs. For more information on the templating system, please see the site at: http://www.simplemachines.org/ */ // Initialize the template... mainly little settings. function template_init() { global $context, $settings, $options, $txt; /* Use images from default theme when using templates from the default theme? if this is 'always', images from the default theme will be used. if this is 'defaults', images from the default theme will only be used with default templates. if this is 'never' or isn't set at all, images from the default theme will not be used. */ $settings['use_default_images'] = 'never'; /* What document type definition is being used? (for font size and other issues.) 'xhtml' for an XHTML 1.0 document type definition. 'html' for an HTML 4.01 document type definition. */ $settings['doctype'] = 'xhtml'; /* The version this template/theme is for. This should probably be the version of SMF it was created for. */ $settings['theme_version'] = '2.0'; /* Set a setting that tells the theme that it can render the tabs. */ $settings['use_tabs'] = true; /* Use plain buttons - as opposed to text buttons? */ $settings['use_buttons'] = true; /* Show sticky and lock status separate from topic icons? */ $settings['separate_sticky_lock'] = true; /* Does this theme use the strict doctype? */ $settings['strict_doctype'] = false; /* Does this theme use post previews on the message index? */ $settings['message_index_preview'] = false; /* Set the following variable to true if this theme requires the optional theme strings file to be loaded. */ $settings['require_theme_strings'] = false; } // The main sub template above the content. function template_html_above() { global $context, $settings, $options, $scripturl, $txt, $modSettings; // Show right to left and the character set for ease of translating. echo '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"', $context['right_to_left'] ? ' dir="rtl"' : '', '> <head>'; // The ?fin20 part of this link is just here to make sure browsers don't cache it wrongly. echo ' <link rel="stylesheet" type="text/css" href="', $settings['theme_url'], '/css/index', $context['theme_variant'], '.css?fin20" />'; // Some browsers need an extra stylesheet due to bugs/compatibility issues. foreach (array('ie7', 'ie6', 'webkit') as $cssfix) if ($context['browser']['is_' . $cssfix]) echo ' <link rel="stylesheet" type="text/css" href="', $settings['default_theme_url'], '/css/', $cssfix, '.css" />'; // RTL languages require an additional stylesheet. if ($context['right_to_left']) echo ' <link rel="stylesheet" type="text/css" href="', $settings['theme_url'], '/css/rtl.css" />'; // Here comes the JavaScript bits! echo ' <script type="text/javascript" src="', $settings['default_theme_url'], '/scripts/script.js?fin20"></script> <script type="text/javascript" src="', $settings['theme_url'], '/scripts/theme.js?fin20"></script> <script type="text/javascript"><!-- // --><![CDATA[ var smf_theme_url = "', $settings['theme_url'], '"; var smf_default_theme_url = "', $settings['default_theme_url'], '"; var smf_images_url = "', $settings['images_url'], '"; var smf_scripturl = "', $scripturl, '"; var smf_iso_case_folding = ', $context['server']['iso_case_folding'] ? 'true' : 'false', '; var smf_charset = "', $context['character_set'], '";', $context['show_pm_popup'] ? ' var fPmPopup = function () { if (confirm("' . $txt['show_personal_messages'] . '")) window.open(smf_prepareScriptUrl(smf_scripturl) + "action=pm"); } addLoadEvent(fPmPopup);' : '', ' var ajax_notification_text = "', $txt['ajax_in_progress'], '"; var ajax_notification_cancel_text = "', $txt['modify_cancel'], '"; // ]]></script>'; echo ' <meta http-equiv="Content-Type" content="text/html; charset=', $context['character_set'], '" /> <meta name="description" content="', $context['page_title_html_safe'], '" />', !empty($context['meta_keywords']) ? ' <meta name="keywords" content="' . $context['meta_keywords'] . '" />' : '', ' <title>', $context['page_title_html_safe'], '</title>'; // Please don't index these Mr Robot. if (!empty($context['robot_no_index'])) echo ' <meta name="robots" content="noindex" />'; // Present a canonical url for search engines to prevent duplicate content in their indices. if (!empty($context['canonical_url'])) echo ' <link rel="canonical" href="', $context['canonical_url'], '" />'; // Show all the relative links, such as help, search, contents, and the like. echo ' <link rel="help" href="', $scripturl, '?action=help" /> <link rel="search" href="', $scripturl, '?action=search" /> <link rel="contents" href="', $scripturl, '" />'; // If RSS feeds are enabled, advertise the presence of one. if (!empty($modSettings['xmlnews_enable']) && (!empty($modSettings['allow_guestAccess']) || $context['user']['is_logged'])) echo ' <link rel="alternate" type="application/rss+xml" title="', $context['forum_name_html_safe'], ' - ', $txt['rss'], '" href="', $scripturl, '?type=rss;action=.xml" />'; // If we're viewing a topic, these should be the previous and next topics, respectively. if (!empty($context['current_topic'])) echo ' <link rel="prev" href="', $scripturl, '?topic=', $context['current_topic'], '.0;prev_next=prev" /> <link rel="next" href="', $scripturl, '?topic=', $context['current_topic'], '.0;prev_next=next" />'; // If we're in a board, or a topic for that matter, the index will be the board's index. if (!empty($context['current_board'])) echo ' <link rel="index" href="', $scripturl, '?board=', $context['current_board'], '.0" />'; // Output any remaining HTML headers. (from mods, maybe?) echo $context['html_headers']; echo ' </head> <body>'; } function template_body_above() { global $context, $settings, $options, $scripturl, $txt, $modSettings; echo !empty($settings['forum_width']) ? ' <div id="wrapper" style="width: ' . $settings['forum_width'] . '">' : '', ' <div id="header"><div class="frame"> <div id="top_section"> <h1 class="forumtitle"> <a href="', 'index.php?action=forum', '">', empty($context['header_logo_url_html_safe']) ? $context['forum_name'] : '<img src="' . $context['header_logo_url_html_safe'] . '" alt="' . $context['forum_name'] . '" />', '</a> </h1>'; // the upshrink image, right-floated echo ' <img id="upshrink" src="', $settings['images_url'], '/upshrink.png" alt="*" title="', $txt['upshrink_description'], '" style="display: none;" />'; // The code for the menu you installed dont you remember it? $x='home.php'; $xx='id=selected'; $xxx='Home'; echo ' </div> <div id="upper_section" class="middletext"', !empty($options['collapse_header']) ? '' : ' style="display: none;"', '> <div class="user">'; // If the user is logged in, display stuff like their name, new messages, etc. if ($context['user']['is_logged']) { if (!empty($context['user']['avatar'])) echo ' <p class="avatar">', $context['user']['avatar']['image'], '</p>'; echo ' <ul class="reset"> <li class="greeting">', $txt['hello_member_ndt'], ' <span>', $context['user']['name'], '</span></li> <li><a href="', $scripturl, '?action=unread">', $txt['unread_since_visit'], '</a></li> <li><a href="', $scripturl, '?action=unreadreplies">', $txt['show_unread_replies'], '</a></li>'; // Is the forum in maintenance mode? if ($context['in_maintenance'] && $context['user']['is_admin']) echo ' <li class="notice">', $txt['maintain_mode_on'], '</li>'; // Are there any members waiting for approval? if (!empty($context['unapproved_members'])) echo ' <li>', $context['unapproved_members'] == 1 ? $txt['approve_thereis'] : $txt['approve_thereare'], ' <a href="', $scripturl, '?action=admin;area=viewmembers;sa=browse;type=approve">', $context['unapproved_members'] == 1 ? $txt['approve_member'] : $context['unapproved_members'] . ' ' . $txt['approve_members'], '</a> ', $txt['approve_members_waiting'], '</li>'; if (!empty($context['open_mod_reports']) && $context['show_open_reports']) echo ' <li><a href="', $scripturl, '?action=moderate;area=reports">', sprintf($txt['mod_reports_waiting'], $context['open_mod_reports']), '</a></li>'; echo ' <li>', $context['current_time'], '</li> </ul>'; } // Otherwise they're a guest - this time ask them to either register or login - lazy bums... elseif (!empty($context['show_login_bar'])) { echo ' <script type="text/javascript" src="', $settings['default_theme_url'], '/scripts/sha1.js"></script> <form id="guest_form" action="', $scripturl, '?action=login2" method="post" accept-charset="', $context['character_set'], '" ', empty($context['disable_login_hashing']) ? ' onsubmit="hashLoginPassword(this, \'' . $context['session_id'] . '\');"' : '', '> <div class="info">', sprintf($txt['welcome_guest'], $txt['guest_title']), '</div> <input type="text" name="user" size="10" class="input_text" /> <input type="password" name="passwrd" size="10" class="input_password" /> <select name="cookielength"> <option value="60">', $txt['one_hour'], '</option> <option value="1440">', $txt['one_day'], '</option> <option value="10080">', $txt['one_week'], '</option> <option value="43200">', $txt['one_month'], '</option> <option value="-1" selected="selected">', $txt['forever'], '</option> </select> <input type="submit" value="', $txt['login'], '" class="button_submit" /><br /> <div class="info">', $txt['quick_login_dec'], '</div>'; if (!empty($modSettings['enableOpenID'])) echo ' <br /><input type="text" name="openid_identifier" id="openid_url" size="25" class="input_text openid_login" />'; echo ' <input type="hidden" name="hash_passwrd" value="" /> </form>'; } echo ' </div> <div class="news normaltext"> <form id="search_form" action="', $scripturl, '?action=search2" method="post" accept-charset="', $context['character_set'], '"> <input type="text" name="search" value="" class="input_text" /> <input type="submit" name="submit" value="', $txt['search'], '" class="button_submit" /> <input type="hidden" name="advanced" value="0" />'; // Search within current topic? if (!empty($context['current_topic'])) echo ' <input type="hidden" name="topic" value="', $context['current_topic'], '" />'; // If we're on a certain board, limit it to this board . elseif (!empty($context['current_board'])) echo ' <input type="hidden" name="brd[', $context['current_board'], ']" value="', $context['current_board'], '" />'; echo '</form>'; // Show a random news item? (or you could pick one from news_lines...) if (!empty($settings['enable_news'])) echo ' <h2>', $txt['news'], ': </h2> <p>', $context['random_news_line'], '</p>'; echo ' </div> </div> <br class="clear" />'; // Define the upper_section toggle in JavaScript. echo ' <script type="text/javascript"><!-- // --><![CDATA[ var oMainHeaderToggle = new smc_Toggle({ bToggleEnabled: true, bCurrentlyCollapsed: ', empty($options['collapse_header']) ? 'false' : 'true', ', aSwappableContainers: [ \'upper_section\' ], aSwapImages: [ { sId: \'upshrink\', srcExpanded: smf_images_url + \'/upshrink.png\', altExpanded: ', JavaScriptEscape($txt['upshrink_description']), ', srcCollapsed: smf_images_url + \'/upshrink2.png\', altCollapsed: ', JavaScriptEscape($txt['upshrink_description']), ' } ], oThemeOptions: { bUseThemeSettings: ', $context['user']['is_guest'] ? 'false' : 'true', ', sOptionName: \'collapse_header\', sSessionVar: ', JavaScriptEscape($context['session_var']), ', sSessionId: ', JavaScriptEscape($context['session_id']), ' }, oCookieOptions: { bUseCookie: ', $context['user']['is_guest'] ? 'true' : 'false', ', sCookieName: \'upshrink\' } }); // ]]></script>'; // Show the menu here, according to the menu sub template. template_menu(); echo ' <br class="clear" /> </div></div>'; // The main content should go here. echo ' <div id="content_section"><div class="frame"> <div id="main_content_section">'; // Custom banners and shoutboxes should be placed here, before the linktree. // Show the navigation tree. theme_linktree(); } function template_body_below() { global $context, $settings, $options, $scripturl, $txt, $modSettings; echo ' </div> </div></div>'; // Show the "Powered by" and "Valid" logos, as well as the copyright. Remember, the copyright must be somewhere! echo ' <div id="footer_section"><div class="frame"> <ul class="reset"> <li class="copyright">', /*theme_copyright(), */'</li> <li><a id="button_xhtml" href="http://validator.w3.org/check?uri=referer" target="_blank" class="new_win" title="', $txt['valid_xhtml'], '"><span>', $txt['xhtml'], '</span></a></li> ', !empty($modSettings['xmlnews_enable']) && (!empty($modSettings['allow_guestAccess']) || $context['user']['is_logged']) ? '<li><a id="button_rss" href="' . $scripturl . '?action=.xml;type=rss" class="new_win"><span>' . $txt['rss'] . '</span></a></li>' : '', ' <li class="last"><a id="button_wap2" href="', $scripturl , '?wap2" class="new_win"><span>', $txt['wap2'], '</span></a></li> </ul>'; // Show the load time? if ($context['show_load_time']) echo ' <p>', $txt['page_created'], $context['load_time'], $txt['seconds_with'], $context['load_queries'], $txt['queries'], '</p>'; echo ' </div></div>', !empty($settings['forum_width']) ? ' </div>' : ''; } function template_html_below() { global $context, $settings, $options, $scripturl, $txt, $modSettings; echo ' </body></html>'; } // Show a linktree. This is that thing that shows "My Community | General Category | General Discussion".. function theme_linktree($force_show = false) { global $context, $settings, $options, $shown_linktree; // If linktree is empty, just return - also allow an override. if (empty($context['linktree']) || (!empty($context['dont_default_linktree']) && !$force_show)) return; echo ' <div class="navigate_section"> <ul>'; // Each tree item has a URL and name. Some may have extra_before and extra_after. foreach ($context['linktree'] as $link_num => $tree) { echo ' <li', ($link_num == count($context['linktree']) - 1) ? ' class="last"' : '', '>'; // Show something before the link? if (isset($tree['extra_before'])) echo $tree['extra_before']; // Show the link, including a URL if it should have one. echo $settings['linktree_link'] && isset($tree['url']) ? ' <a href="' . $tree['url'] . '"><span>' . $tree['name'] . '</span></a>' : '<span>' . $tree['name'] . '</span>'; // Show something after the link...? if (isset($tree['extra_after'])) echo $tree['extra_after']; // Don't show a separator for the last one. if ($link_num != count($context['linktree']) - 1) echo ' »'; echo ' </li>'; } echo ' </ul> </div>'; $shown_linktree = true; } // Show the menu up top. Something like [home] [help] [profile] [logout]... function template_menu() { global $context, $settings, $options, $scripturl, $txt; echo ' <div id="main_menu"> <ul class="dropmenu" id="menu_nav">'; foreach ($context['menu_buttons'] as $act => $button) { echo ' <li id="button_', $act, '"> <a class="', $button['active_button'] ? 'active ' : '', 'firstlevel" href="', $button['href'], '"', isset($button['target']) ? ' target="' . $button['target'] . '"' : '', '> <span class="', isset($button['is_last']) ? 'last ' : '', 'firstlevel">', $button['title'], '</span> </a>'; if (!empty($button['sub_buttons'])) { echo ' <ul>'; foreach ($button['sub_buttons'] as $childbutton) { echo ' <li> <a href="', $childbutton['href'], '"', isset($childbutton['target']) ? ' target="' . $childbutton['target'] . '"' : '', '> <span', isset($childbutton['is_last']) ? ' class="last"' : '', '>', $childbutton['title'], !empty($childbutton['sub_buttons']) ? '...' : '', '</span> </a>'; // 3rd level menus if (!empty($childbutton['sub_buttons'])) { echo ' <ul>'; foreach ($childbutton['sub_buttons'] as $grandchildbutton) echo ' <li> <a href="', $grandchildbutton['href'], '"', isset($grandchildbutton['target']) ? ' target="' . $grandchildbutton['target'] . '"' : '', '> <span', isset($grandchildbutton['is_last']) ? ' class="last"' : '', '>', $grandchildbutton['title'], '</span> </a> </li>'; echo ' </ul>'; } echo ' </li>'; } echo ' </ul>'; } echo ' </li>'; } echo ' </ul> </div>'; } // Generate a strip of buttons. function template_button_strip($button_strip, $direction = 'top', $strip_options = array()) { global $settings, $context, $txt, $scripturl; if (!is_array($strip_options)) $strip_options = array(); // List the buttons in reverse order for RTL languages. if ($context['right_to_left']) $button_strip = array_reverse($button_strip, true); // Create the buttons... $buttons = array(); foreach ($button_strip as $key => $value) { if (!isset($value['test']) || !empty($context[$value['test']])) $buttons[] = ' <li><a' . (isset($value['id']) ? ' id="button_strip_' . $value['id'] . '"' : '') . ' class="button_strip_' . $key . (isset($value['active']) ? ' active' : '') . '" href="' . $value['url'] . '"' . (isset($value['custom']) ? ' ' . $value['custom'] : '') . '><span>' . $txt[$value['text']] . '</span></a></li>'; } // No buttons? No button strip either. if (empty($buttons)) return; // Make the last one, as easy as possible. $buttons[count($buttons) - 1] = str_replace('<span>', '<span class="last">', $buttons[count($buttons) - 1]); echo ' <div class="buttonlist', !empty($direction) ? ' float' . $direction : '', '"', (empty($buttons) ? ' style="display: none;"' : ''), (!empty($strip_options['id']) ? ' id="' . $strip_options['id'] . '"': ''), '> <ul>', implode('', $buttons), ' </ul> </div>'; } ?> line 189 i whant to add this <div class="navigation"> <ul> <li><a href="test.php"<?php if($pageOn == 'test.php'){?> id="selected"<?php }?>>home</a></li> <li><a href="book.php"<?php if($pageOn == 'book.php'){?> id="selected"<?php }?>>books</a></li> <li><a href="movie.php"<?php if($pageOn == 'movie.php'){?> id="selected"<?php }?>>movies</a></li> <li><a href="contact.php"<?php if($pageOn == 'contact.php'){?> id="selected"<?php }?>>contact</a></li> </ul> </div>
-
<?php ob_start(); $host="xx"; // Host name $username="xx"; // Mysql username $password="xx"; // Mysql password $db_name="xx"; // Database name $tbl_name="smf_members"; // Table name // Connect to server and select databse. mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB"); // Define $myusername and $mypassword $myusername=$_GET['u']; $mypassword=$_GET['p']; // encrypt password $encrypted_mypassword=sha1(strtolower($myusername).$mypassword); $sql="SELECT * FROM $tbl_name WHERE member_name='$myusername' and passwd='$encrypted_mypassword'"; $result=mysql_query($sql); // Mysql_num_row is counting table row $count=mysql_num_rows($result); // If result matched $myusername and $mypassword, table row must be 1 row $row = mysql_fetch_array($result); $x=$row['id_group']; if($x==1){ // Register $myusername, $mypassword and redirect to file "login_success.php" session_register("u"); session_register("p"); echo ok ; } else { echo "Wrong Username or Password"; } ob_end_flush(); ?>
-
Im using SMF forum im trying to connect (my software C#) and grand access from forum DB this is a hash from SMF sha1(strtolower($membername) . $password); <?php include("config.php"); $user = "-1"; if (isset($_GET['user'])) { $user = $_GET['user']; } $pass = "-1"; if (isset($_GET['pass'])) { $pass = $_GET['pass']; } $ip = $_SERVER['REMOTE_ADDR']; $sql = "select id_member,count from smf_members where real_name='$user' and passwd=MD5('$pass')"; $results = mysql_query($sql, $con); $values = mysql_fetch_assoc($results); $user_id = $values['id_member']; $login=$values['count']; ?> MD5 working fine but how to use SMF hash to login?
-
i need to run new query ? its any another way to do that?
-
<?php $usergender = mysql_query("SELECT * FROM `fb_acc` WHERE `user_id`='{$data->id}'"); $rowuser = mysql_fetch_object($usergender); $xx = $rowuser->gender; $usercountry = strtoupper($autocountry); $Regions = mysql_query("SELECT * FROM `regions` WHERE `active`='1' AND `shortname`='$usercountry'"); $Regs = mysql_fetch_object($Regions); } if(!$Regs) { $site2 = mysql_query("SELECT * FROM facebook a WHERE (a.active= '0' AND `gender`='$xx' AND (SELECT `coins` FROM `users` WHERE `id`=a.user) > a.cpc) AND a.id NOT IN (SELECT `site_id` FROM `liked` WHERE `user_id`='{$data->id}') AND `regionid`=1 ORDER BY a.cpc DESC LIMIT 0, 16"); } else { $site2 = mysql_query("SELECT * FROM facebook a WHERE (a.active= '0' AND `gender`='$xx' AND (SELECT `coins` FROM `users` WHERE `id`=a.user) > a.cpc) AND a.id NOT IN (SELECT `site_id` FROM `liked` WHERE `user_id`='{$data->id}') AND (`regionid`='Regs->id' OR `regionid`='Regs->continent' OR `regionid`=1) ORDER BY a.cpc DESC LIMIT 0, 16"); } $ext = mysql_num_rows($site2); if($ext > 0){ ?> in my database row gender i got 3 options female male all (or both) how can i say if if($xx=all) show both records mela and female .
-
Your host is to slow i can't test it i need 2 min to load a image
-
Thank you my frineds
-
Hi. this one site that is based on phpfreaks forum help. If you looking for facebook likes would you use this. The site is very new and needs a lot of work , but I want to see if people like it (like IDEA). Tradelike.Net Thank you for your time.
-
<?php $query="SELECT date_liked , COUNT(site_id) AS num_site_id FROM `liked` WHERE date_liked < CURDATE() AND date_liked > CURDATE() - INTERVAL 1 WEEK AND site_id='$id' GROUP BY date_liked"; $result = mysql_query($query); while($row = mysql_fetch_array($result)){ echo $row['date_liked']; echo "<br>"; echo $row['num_site_id']; echo "<br>"; $p = $data->coins; $num_amount =$row['num_site_id']; echo ($num_amount/$p*100) . "% of rows selected."; } // end statistic last 7 days// ?>
-
Thank you my friend for replay now i got this promblem how can i loop percent fuction ? <?php $query="SELECT date_liked , COUNT(site_id) AS num_site_id FROM `liked` WHERE date_liked < CURDATE() AND date_liked > CURDATE() - INTERVAL 1 WEEK AND site_id='$id' GROUP BY date_liked"; $result = mysql_query($query); while($row = mysql_fetch_array($result)){ echo $row['date_liked']; echo "<br>"; echo $row['num_site_id']; echo "<br>"; $num_total = $data->coins; $num_amount =$row['num_site_id']; function percent1($num_amount, $num_total) { //<-- line 21 $count1 = $num_amount / $num_total; $count2 = $count1 * 100; $count = number_format($count2, 0); echo $count; } // end statistic last 7 days// } ?> Fatal error: Cannot redeclare percent1() (previously declared in line 21
-
<?php $statisctis=("SELECT date_liked , COUNT(site_id) AS num_site_id FROM `liked` WHERE date_liked < CURDATE() AND date_liked > CURDATE() - INTERVAL 1 WEEK AND site_id='45' GROUP BY date_liked"); $result1 = mysql_query ($statisctis) or die(mysql_error()); ?> in php admin i get result like this date_liked num_site_id 2011-11-28 10:00:29 1 2011-11-29 05:03:17 1 2011-11-30 04:51:37 1 how to echo this in my page? Here i get a COUNT number only <?php $sum_datas = mysql_result($result1, 0); echo $sum_datas['date_liked']; ?>
-
Im trying to get percents from my DB <?php $statisctis="SELECT COUNT(user_id) FROM `liked` WHERE ((DATE_SUB(CURDATE(),INTERVAL 1 DAY) <= date_liked) AND site_id='data->site_id') "; $datas = mysql_query($statisctis); $sum_datas = mysql_result($datas, 0); function Get_Percent($number,$total) { $percentage = round($number * 100 / $total); echo $percentage; } // Usage Get_Percent($sum_datas,$data->coins); ?> i got the result for one day i whant get result for last 12 days how can i do that? or i need to write 12 querys?
-
stats for my app and not for user statistics..
-
Hello i whant to creat stats page for my website can sombady help me how can SELECT database id |user_id | site_id | date 1 | 2222 | 18 | 2011-11-28 06:10:06 select id COUNT(site_id ) from table WHERE date = ? i whant to select last 7 days from database and count site_id per day .