Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Topics - artmedia

Pages: [1]
1
Discussion & Troubleshooting / My site is down, help please!
« on: April 09, 2009, 09:20:32 AM »
Hi, my site www.ticas.cr is down, i have received this email from hosting company, but I have moved to this one bcz the previous hosting was down too, now i don't know what to fix, seem it is a problem on my side, any help?

This the email from the hosting:

System administration has been tracking higher resource usage on the machine housing your account, and has traced some of these issues to longer running mysql queries related to your account.

Unfortunately, at this time it is not clear exactly what on your site is causing these issues, but we do need you to see if you can reduce the burden these queries cause on the server.

In the shared system, most queries should complete through the server in less than a second.  Some of the queries related to your account take a good deal longer than this to complete, and seem to be the source of some latency we are seeing in server response.

Here are examples of such queries:

| 389163 | ticasc5_imga1 | localhost | ticasc5_Hi5 | Query   | 0    | Copying to tmp table | SELECT DISTINCT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_description, i.image_keywords |

In order to maintain stability and responsiveness in the shared environment, you will need to review the site to see if you can make any changes that can better the efficiency of these queries.

Thank you in advance for your cooperation, and feel free to let us know if you have any further questions or if we can be of assistance.

Best Regards,

Marco
InMotion Hosting
System Administration 

2
Chit Chat / 4homepages website Top 10 Rated
« on: November 28, 2008, 04:36:15 PM »
Somebody knows who is on charge of 4homepages top sites page? http://www.4homepages.de/resources/Ratings/ Because I checked every date the ranking because I used to have two sites there, but now one of them has been deleted www.ticas.cr and the other one has been underrated www.ticas.co.cr (I always keep the 4homepages copyright information and everything), and non existing sites in that list have been overrated with more votes and ranking irregularly. this is really unfair and irregular, who can help me?

Thanks.

3
In order to this request: http://www.4homepages.de/forum/index.php?topic=5789.0 I have started this mod, but, this is my first attempt, i need some help, can someone help me:

The first Step would be:

Add in includes/functions.php

this code:

Code: [Select]
// Top Categories
function get_top_categories() {
  global $site_db, $cat_cache, $total_images;
  $categories_top = array();
  $cat_id_sql = get_auth_cat_sql("auth_viewcat", "NOTIN");

  $sql = "SELECT c.cat_name AS NAME, sum( `i.image_votes` ) AS VOTES
  FROM (".IMAGES_TABLE." i,  ".CATEGORIES_TABLE." c)
            WHERE i.image_active = 1 AND i.cat_id NOT IN ($cat_id_sql) AND c.cat_id = i.cat_id
            GROUP BY cat_id
HAVING sum( `i.image_votes` ) > 100 //MINIMAL VOTES FOR THE TOP LIST
ORDER BY VOTES DESC
LIMIT 0 , 15";  // IN THIS CASE FOR MY TOP 15 LIST
   
  $result = $site_db->query($sql);
  while ($row = $site_db->fetch_array($result)) {
     // $categories_top[$row['cat_id']] = $row;
echo $row['NAME']. " - ". $row['VOTES'];
echo "<br />";
  }
  return $categories_top;


Second Step:
(I'm lost here, i don't know how to call a function from other page, for example, how to associate let's say {top_categories} to this function)

Someone knows how?

Thanks
Sorry if i posted this topic in the wrong section, i hope this be finished soon like a real MOD

Pages: [1]