SEOClerks

install flash games into my gaming site

install flash games into my gaming site

hello i have quite a few games i need to install in to my gaming site
i need the games history stats adding to my admin
and then the games to display in a table on a certain page
but i dont mind you hard coding the games via a embeded link simples
i have all code needed just moving games from one site to another
upgraded php5 to php 7 and mysql to mmsql

old login system / new login system

old code from php 5.3
<?php
error_reporting( 0 );
unset( $l );
session_start( );
session_register( $l );
if ( !isset( $l ) )

{
header( "Location: ../../login.php" );
exit( );

}
>

#/---------------------------------------------------------------
new login system

<?php
if ($gameid>0 && readcookie("validated")==1 ) { ?>

<?php } else { ?>
header( "Location: ../../login.php" );

<?php } ?>
#/-----------------------------------------------------------------


and this is the one of the game loader scripts edit database fields to work with mmsql
mysql and mmsql are basically the same , ad new fileds
pdo connect statment



<?php

function winlimit( )
{
$resultb=mysql_query("select * from game_bank where name='ttuz'");
$rowb=mysql_fetch_array($resultb);
$bank = $rowb[1];
$proc = $rowb[2];
$caswin = $bank/100*$proc;
return $caswin;
}

function cash( $l )
{
$table_cash = mysql_query("select * from jsgamingcenter_users where login='$l'");
$row = mysql_fetch_array( $table_cash );
$cash = $row['cash'];
return $cash;
}

function rnd1( )
{
srand( ( double )microtime( ) * time( ) );
$dig = rand( 0, 36 );
return $dig;
}

function rnd2( $cell, $dig )
{
$masvet0 = array( 0, 106 );
$masvet1 = array( 1, 37, 61, 94, 106, 107, 130, 146, 149, 157, 160, 161 );
$masvet2 = array( 2, 37, 38, 62, 94, 106, 107, 108, 130, 147, 149, 158, 159, 161 );
$masvet3 = array( 3, 38, 63, 94, 106, 108, 130, 148, 149, 157, 160, 161 );
$masvet4 = array( 4, 39, 61, 64, 95, 107, 109, 130, 131, 146, 149, 158, 159, 161 );
$masvet5 = array( 5, 39, 40, 62, 65, 95, 107, 108, 109, 110, 130, 131, 147, 149, 157, 160, 161 );
$masvet6 = array( 6, 40, 63, 95, 108, 110, 130, 131, 135, 148, 149, 158, 159, 161 );
$masvet7 = array( 7, 41, 64, 67, 96, 109, 111, 131, 132, 146, 149, 157, 160, 161 );
$masvet8 = array( 8, 41, 42, 65, 68, 96, 109, 110, 111, 112, 131, 132, 147, 149, 158, 159, 161 );
$masvet9 = array( 9, 42, 66, 69, 96, 110, 112, 131, 132, 148, 149, 157, 160, 161 );
$masvet10 = array( 10, 43, 67, 70, 97, 111, 113, 132, 133, 146, 149, 158, 159, 161 );
$masvet11 = array( 11, 43, 44, 68, 71, 97, 111, 112, 113, 114, 132, 133, 147, 149, 158, 160, 161 );
$masvet12 = array( 12, 44, 69, 72, 97, 112, 114, 132, 133, 148, 149, 157, 159, 161 );
$masvet13 = array( 13, 45, 70, 73, 98, 113, 115, 133, 134, 146, 150, 158, 160, 161 );
$masvet14 = array( 14, 45, 46, 71, 74, 98, 113, 114, 115, 116, 133, 134, 147, 150, 157, 159, 161 );
$masvet15 = array( 15, 46, 72, 75, 98, 114, 116, 133, 134, 148, 150, 158, 160, 161 );
$masvet16 = array( 16, 47, 73, 76, 99, 115, 117, 134, 146, 150, 157, 159, 161 );
$masvet17 = array( 17, 47, 48, 74, 77, 99, 115, 116, 117, 118, 134, 135, 147, 150, 158, 160, 161 );
$masvet18 = array( 18, 48, 75, 78, 99, 116, 118, 134, 135, 148, 150, 157, 159, 161 );
$masvet19 = array( 19, 49, 76, 79, 100, 117, 119, 135, 136, 146, 150, 157, 160, 162 );
$masvet20 = array( 20, 49, 50, 77, 80, 100, 117, 118, 119, 120, 135, 136, 147, 150, 158, 159, 162 );
$masvet21 = array( 21, 50, 78, 81, 100, 118, 120, 135, 136, 148, 150, 157, 160, 162 );
$masvet22 = array( 22, 51, 79, 82, 119, 121, 136, 137, 146, 150, 158, 159, 162 );
$masvet23 = array( 23, 51, 52, 80, 83, 101, 119, 120, 121, 122, 136, 137, 147, 150, 157, 160, 162 );
$masvet24 = array( 24, 52, 81, 84, 101, 120, 122, 136, 137, 148, 150, 158, 159, 162 );
$masvet25 = array( 25, 53, 82, 85, 102, 121, 123, 137, 138, 146, 151, 157, 160, 162 );
$masvet26 = array( 26, 53, 54, 83, 86, 102, 121, 122, 123, 124, 137, 138, 147, 151, 158, 159, 162 );
$masvet27 = array( 27, 54, 84, 87, 102, 122, 124, 137, 138, 148, 151, 157, 160, 162 );
$masvet28 = array( 28, 55, 85, 88, 103, 123, 125, 138, 139, 146, 151, 158, 159, 162 );
$masvet29 = array( 29, 55, 56, 86, 89, 103, 123, 124, 125, 126, 138, 139, 147, 151, 158, 160, 162 );
$masvet30 = array( 30, 56, 87, 90, 103, 124, 126, 138, 148, 151, 157, 159, 162 );
$masvet31 = array( 31, 57, 88, 91, 104, 125, 127, 139, 140, 146, 151, 158, 160, 162 );
$masvet32 = array( 32, 57, 58, 89, 92, 104, 125, 126, 127, 128, 139, 140, 147, 151, 157, 159, 162 );
$masvet33 = array( 33, 58, 90, 93, 104, 126, 128, 139, 140, 148, 151, 158, 160, 162 );
$masvet34 = array( 34, 59, 91, 105, 127, 140, 146, 151, 157, 159, 162 );
$masvet35 = array( 35, 59, 60, 92, 105, 127, 128, 140, 147, 151, 158, 160, 162 );
$masvet36 = array( 36, 60, 93, 105, 128, 140, 148, 151, 157, 159, 162 );
$mas = ${ "masvet".$dig };
$aa = in_array( $cell, $mas );
return $aa;
}

error_reporting( 0 );
unset( $l );
session_start( );
session_register( $l );
if ( !isset( $l ) )
{
header( "Location: ../../login.php" );
exit( );

}


$date = date( "d.m.y" );
$time = date( "H:i:s" );

include database


$data_array = explode( "|", $BET );
$casbank = winlimit( );
$ams = 0;
while ( $ams < 10000 )
{
$dig = rnd1( );
$allbet = 0;
$win = 0;
$win2 = 0;
$k = 0;
for ( ; $k <= 162; ++$k )
{
if ( !( 0 < $data_array[$k] ) && !( $data_array[$k] != " " ) )
{
continue;
}
$allbet += $data_array[$k];
$aa = rnd2( $k, $dig );
if ( !( $aa == true ) )
{
continue;
}
if ( $k <= 36 && 0 <= $k )
{
$win = $win + $data_array[$k] * 33 + $data_array[$k];
$win2 += $data_array[$k] * 34;
}
if ( 37 <= $k && $k <= 93 )
{
$win = $win + $data_array[$k] * 15 + $data_array[$k];
$win2 += $data_array[$k] * 16;
}
if ( 94 <= $k && $k <= 105 )
{
$win = $win + $data_array[$k] * 9 + $data_array[$k];
$win2 += $data_array[$k] * 10;
}
if ( 106 <= $k && $k <= 128 )
{
$win = $win + $data_array[$k] * 6 + $data_array[$k];
$win2 += $data_array[$k] * 7;
}
if ( 130 <= $k && $k <= 140 )
{
$win = $win + $data_array[$k] * 3 + $data_array[$k];
$win2 += $data_array[$k] * 4;
}
if ( 146 <= $k && $k <= 151 )
{
$win = $win + $data_array[$k] * 0 + $data_array[$k];
$win2 += $data_array[$k] * 1;
}
if ( !( 157 <= $k ) && !( $k <= 162 ) )
{
continue;
}
$win = $win + $data_array[$k] * 2 + $data_array[$k];
$win2 += $data_array[$k] * 2;
}
$prib = $win - $allbet;
$prib_bet = $casbank + $allbet;
++$ams;
if ( $prib_bet < $prib )
{
$ams = 12;
}

if ( !( $prib < $prib_bet ) )
{
continue;
}
$ams = 12000;
}


if ( $l != "guestlogin" ) {

mysql_query( "update game_bank set bank=bank+'".$allbet."' where name='ttuz'" );

mysql_query( "update game_bank set bank=bank-'".$win2."' where name='ttuz'" );
}











mysql_query( "update jsgamingcenter_users set cash=cash+'".$win2."' where login='{$l}'" );

mysql_query( "update jsgamingcenter_users set cash=cash-'".$allbet."' where login='{$l}'" );







if ( 0 < $allbet )
{
$cash = cash( $l );

mysql_query( "INSERT INTO jsgamingcenter_gameplays VALUES('NULL','".$date."','{$time}','{$l}','{$cash}','{$allbet}','{$win2}','{$allbet}','roulette','NULL')" );










}

















$cash = cash( $l );
echo "&masvet_id=1012&JACKPOT=0.00&PAYOUT=".$win."&NUMBER={$dig}&RESULT=OK&BALANCE={$cash}&";
>


Requirements

hello i have quite a few games i need to install in to my gaming site
i need the games history stats adding to my admin
and then the games to display in a table on a certain page
but i dont mind you hard coding the games via a embeded link simples
i have all code needed just moving games from one site to another
upgraded php5 to php 7 and mysql to mmsql

old login system / new login system

old code from php 5.3
<?php
error_reporting( 0 );
unset( $l );
session_start( );
session_register( $l );
if ( !isset( $l ) )

{
header( "Location: ../../login.php" );
exit( );

}
>

#/---------------------------------------------------------------
new login system

<?php
if ($gameid>0 && readcookie("validated")==1 ) { ?>

<?php } else { ?>
header( "Location: ../../login.php" );

<?php } ?>
#/-----------------------------------------------------------------


and this is the one of the game loader scripts edit database fields to work with mmsql
mysql and mmsql are basically the same , ad new fileds
pdo connect statment



<?php

function winlimit( )
{
$resultb=mysql_query("select * from game_bank where name='ttuz'");
$rowb=mysql_fetch_array($resultb);
$bank = $rowb[1];
$proc = $rowb[2];
$caswin = $bank/100*$proc;
return $caswin;
}

function cash( $l )
{
$table_cash = mysql_query("select * from jsgamingcenter_users where login='$l'");
$row = mysql_fetch_array( $table_cash );
$cash = $row['cash'];
return $cash;
}

function rnd1( )
{
srand( ( double )microtime( ) * time( ) );
$dig = rand( 0, 36 );
return $dig;
}

function rnd2( $cell, $dig )
{
$masvet0 = array( 0, 106 );
$masvet1 = array( 1, 37, 61, 94, 106, 107, 130, 146, 149, 157, 160, 161 );
$masvet2 = array( 2, 37, 38, 62, 94, 106, 107, 108, 130, 147, 149, 158, 159, 161 );
$masvet3 = array( 3, 38, 63, 94, 106, 108, 130, 148, 149, 157, 160, 161 );
$masvet4 = array( 4, 39, 61, 64, 95, 107, 109, 130, 131, 146, 149, 158, 159, 161 );
$masvet5 = array( 5, 39, 40, 62, 65, 95, 107, 108, 109, 110, 130, 131, 147, 149, 157, 160, 161 );
$masvet6 = array( 6, 40, 63, 95, 108, 110, 130, 131, 135, 148, 149, 158, 159, 161 );
$masvet7 = array( 7, 41, 64, 67, 96, 109, 111, 131, 132, 146, 149, 157, 160, 161 );
$masvet8 = array( 8, 41, 42, 65, 68, 96, 109, 110, 111, 112, 131, 132, 147, 149, 158, 159, 161 );
$masvet9 = array( 9, 42, 66, 69, 96, 110, 112, 131, 132, 148, 149, 157, 160, 161 );
$masvet10 = array( 10, 43, 67, 70, 97, 111, 113, 132, 133, 146, 149, 158, 159, 161 );
$masvet11 = array( 11, 43, 44, 68, 71, 97, 111, 112, 113, 114, 132, 133, 147, 149, 158, 160, 161 );
$masvet12 = array( 12, 44, 69, 72, 97, 112, 114, 132, 133, 148, 149, 157, 159, 161 );
$masvet13 = array( 13, 45, 70, 73, 98, 113, 115, 133, 134, 146, 150, 158, 160, 161 );
$masvet14 = array( 14, 45, 46, 71, 74, 98, 113, 114, 115, 116, 133, 134, 147, 150, 157, 159, 161 );
$masvet15 = array( 15, 46, 72, 75, 98, 114, 116, 133, 134, 148, 150, 158, 160, 161 );
$masvet16 = array( 16, 47, 73, 76, 99, 115, 117, 134, 146, 150, 157, 159, 161 );
$masvet17 = array( 17, 47, 48, 74, 77, 99, 115, 116, 117, 118, 134, 135, 147, 150, 158, 160, 161 );
$masvet18 = array( 18, 48, 75, 78, 99, 116, 118, 134, 135, 148, 150, 157, 159, 161 );
$masvet19 = array( 19, 49, 76, 79, 100, 117, 119, 135, 136, 146, 150, 157, 160, 162 );
$masvet20 = array( 20, 49, 50, 77, 80, 100, 117, 118, 119, 120, 135, 136, 147, 150, 158, 159, 162 );
$masvet21 = array( 21, 50, 78, 81, 100, 118, 120, 135, 136, 148, 150, 157, 160, 162 );
$masvet22 = array( 22, 51, 79, 82, 119, 121, 136, 137, 146, 150, 158, 159, 162 );
$masvet23 = array( 23, 51, 52, 80, 83, 101, 119, 120, 121, 122, 136, 137, 147, 150, 157, 160, 162 );
$masvet24 = array( 24, 52, 81, 84, 101, 120, 122, 136, 137, 148, 150, 158, 159, 162 );
$masvet25 = array( 25, 53, 82, 85, 102, 121, 123, 137, 138, 146, 151, 157, 160, 162 );
$masvet26 = array( 26, 53, 54, 83, 86, 102, 121, 122, 123, 124, 137, 138, 147, 151, 158, 159, 162 );
$masvet27 = array( 27, 54, 84, 87, 102, 122, 124, 137, 138, 148, 151, 157, 160, 162 );
$masvet28 = array( 28, 55, 85, 88, 103, 123, 125, 138, 139, 146, 151, 158, 159, 162 );
$masvet29 = array( 29, 55, 56, 86, 89, 103, 123, 124, 125, 126, 138, 139, 147, 151, 158, 160, 162 );
$masvet30 = array( 30, 56, 87, 90, 103, 124, 126, 138, 148, 151, 157, 159, 162 );
$masvet31 = array( 31, 57, 88, 91, 104, 125, 127, 139, 140, 146, 151, 158, 160, 162 );
$masvet32 = array( 32, 57, 58, 89, 92, 104, 125, 126, 127, 128, 139, 140, 147, 151, 157, 159, 162 );
$masvet33 = array( 33, 58, 90, 93, 104, 126, 128, 139, 140, 148, 151, 158, 160, 162 );
$masvet34 = array( 34, 59, 91, 105, 127, 140, 146, 151, 157, 159, 162 );
$masvet35 = array( 35, 59, 60, 92, 105, 127, 128, 140, 147, 151, 158, 160, 162 );
$masvet36 = array( 36, 60, 93, 105, 128, 140, 148, 151, 157, 159, 162 );
$mas = ${ "masvet".$dig };
$aa = in_array( $cell, $mas );
return $aa;
}

error_reporting( 0 );
unset( $l );
session_start( );
session_register( $l );
if ( !isset( $l ) )
{
header( "Location: ../../login.php" );
exit( );

}


$date = date( "d.m.y" );
$time = date( "H:i:s" );

include database


$data_array = explode( "|", $BET );
$casbank = winlimit( );
$ams = 0;
while ( $ams < 10000 )
{
$dig = rnd1( );
$allbet = 0;
$win = 0;
$win2 = 0;
$k = 0;
for ( ; $k <= 162; ++$k )
{
if ( !( 0 < $data_array[$k] ) && !( $data_array[$k] != " " ) )
{
continue;
}
$allbet += $data_array[$k];
$aa = rnd2( $k, $dig );
if ( !( $aa == true ) )
{
continue;
}
if ( $k <= 36 && 0 <= $k )
{
$win = $win + $data_array[$k] * 33 + $data_array[$k];
$win2 += $data_array[$k] * 34;
}
if ( 37 <= $k && $k <= 93 )
{
$win = $win + $data_array[$k] * 15 + $data_array[$k];
$win2 += $data_array[$k] * 16;
}
if ( 94 <= $k && $k <= 105 )
{
$win = $win + $data_array[$k] * 9 + $data_array[$k];
$win2 += $data_array[$k] * 10;
}
if ( 106 <= $k && $k <= 128 )
{
$win = $win + $data_array[$k] * 6 + $data_array[$k];
$win2 += $data_array[$k] * 7;
}
if ( 130 <= $k && $k <= 140 )
{
$win = $win + $data_array[$k] * 3 + $data_array[$k];
$win2 += $data_array[$k] * 4;
}
if ( 146 <= $k && $k <= 151 )
{
$win = $win + $data_array[$k] * 0 + $data_array[$k];
$win2 += $data_array[$k] * 1;
}
if ( !( 157 <= $k ) && !( $k <= 162 ) )
{
continue;
}
$win = $win + $data_array[$k] * 2 + $data_array[$k];
$win2 += $data_array[$k] * 2;
}
$prib = $win - $allbet;
$prib_bet = $casbank + $allbet;
++$ams;
if ( $prib_bet < $prib )
{
$ams = 12;
}

if ( !( $prib < $prib_bet ) )
{
continue;
}
$ams = 12000;
}


if ( $l != "guestlogin" ) {

mysql_query( "update game_bank set bank=bank+'".$allbet."' where name='ttuz'" );

mysql_query( "update game_bank set bank=bank-'".$win2."' where name='ttuz'" );
}











mysql_query( "update jsgamingcenter_users set cash=cash+'".$win2."' where login='{$l}'" );

mysql_query( "update jsgamingcenter_users set cash=cash-'".$allbet."' where login='{$l}'" );







if ( 0 < $allbet )
{
$cash = cash( $l );

mysql_query( "INSERT INTO jsgamingcenter_gameplays
VALUES('NULL','".$date."','{$time}','{$l}','{$cash}','{$allbet}','{$win2}','{$allbet}','roulette','NULL')"
);










}

















$cash = cash( $l );
echo "&masvet_id=1012&JACKPOT=0.00&PAYOUT=".$win."&NUMBER={$dig}&RESULT=OK&BALANCE={$cash}&";
>


Skills Required

Php Mysql Mmsql

Bids

hi,
i will move your game on php site and create the code by that any other site can use that.
i will help you out to show statas to.we are small it company located in pune.

Bid On Listing Created 9 years ago in Programming

Other jobs by rlencouk

Order Now
Process Time: 0.19723010063171

Possible Duplicate queries found!
MatchCountSQLScript
SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-864001SELECT querystring, added FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400

/opt/clerks-staging/docroot/include/functions/includes/security.php 398 fetchMemberLedger() include_once()

SELECT * FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.wantid='55497' AND A.category=B.CATID AND A.USERID=C.USERID1SELECT A.*, B.name, B.seo, C.username, C.userlevel, C.footer_code, C.rating, C.ratingcount, C.googleplus_profile, C.total_recommendations, C.USERID, C.profilepicture, C.average_response_time, C.lastlogin, C.addtime FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.wantid='55497' AND A.category=B.CATID AND A.USERID=C.USERID

/opt/clerks-staging/docroot/viewwant.php 163 () ()

SELECT * FROM ratings_buyer WHERE USERID=6307901SELECT sum(good) as thumbup, sum(bad) as thumbdown FROM ratings_buyer WHERE USERID=630790

/opt/clerks-staging/docroot/include/functions/main.php 19523 GetRatingsAsBuyerTotal() ()

SELECT * FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 55497 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Php Mysql Mmsql%' ) LIMIT 41SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 55497 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Php Mysql Mmsql%' ) LIMIT 4

/opt/clerks-staging/docroot/viewwant.php 551 () ()

SELECT * FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 55497 AND A.category=B.CATID AND A.active=1 AND A.USERID=630790 LIMIT 41SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 55497 AND A.category=B.CATID AND A.active=1 AND A.USERID=630790 LIMIT 4

/opt/clerks-staging/docroot/viewwant.php 568 () ()

SELECT * FROM wantcomments a, seoclerks.members b WHERE a.PID='55497' AND a.USERID=b.USERID and b.status='1' AND a.status=1 order by a.CID asc1SELECT a.comment, a.USERID, a.CID, a.time_added, a.istranslated, a.parentid, b.username, b.profilepicture FROM wantcomments a, seoclerks.members b WHERE a.PID='55497' AND a.USERID=b.USERID and b.status='1' AND a.status=1 order by a.CID asc

/opt/clerks-staging/docroot/viewwant.php 835 () ()

UPDATE wanttobuy SET viewcount = viewcount + 1 WHERE wantid='55497'1UPDATE wanttobuy SET viewcount = viewcount + 1 WHERE wantid='55497'

/opt/clerks-staging/docroot/include/functions/main.php 1729 update_wantviewcount() ()

SELECT * FROM wantbids as w, seoclerks.members AS m WHERE w.active=1 AND m.USERID=w.USERID AND m.status=1 AND w.USERID>0 AND w.wantid='55497' ORDER BY w.bidid ASC 1SELECT w.bidid, w.PID, w.comment, w.title, w.pricepublic, w.USERID, w.adjustedprice, w.ip, m.profilepicture FROM wantbids as w, seoclerks.members AS m WHERE w.active=1 AND m.USERID=w.USERID AND m.status=1 AND w.USERID>0 AND w.wantid='55497' ORDER BY w.bidid ASC

/opt/clerks-staging/docroot/viewwant.php 1192 () ()

SELECT * FROM seoclerks.members as m WHERE m.USERID=991611SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations FROM seoclerks.members as m WHERE m.USERID=99161

/opt/clerks-staging/docroot/viewwant.php 1258 () ()

SELECT * FROM categories_wanttobuy1SELECT * FROM categories_wanttobuy

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()

SELECT * FROM posts WHERE USERID=6307901SELECT sum(positive_ratings) as thumbup, sum(negative_ratings) as thumbdown FROM posts WHERE USERID=630790

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetBuyerRatingsTotal()

SELECT * FROM categories1SELECT * FROM categories

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()

select * from categories_software order by name asc1select * from categories_software order by name asc

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetSoftwareCategories()

select * from categories_wanttobuy order by name asc1select * from categories_wanttobuy order by name asc

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_wantcategories()

select * from categories_wanttotrade order by name asc1select * from categories_wanttotrade order by name asc

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_tradecategories()

SELECT * FROM seoclerks.members WHERE USERID='99161'1SELECT profilepicture FROM seoclerks.members WHERE USERID='99161'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='630790'1SELECT profile_data FROM seoclerks.members WHERE USERID='630790'

/opt/clerks-staging/docroot/include/functions/main.php 1927 getUserBackground() include()

Invalid SQL

count(*)sql1error_msg

Expensive SQL

Tuning the following SQL could reduce the server load substantially
LoadCountSQLMaxMin

Suspicious SQL

The following SQL have high average execution times
Avg TimeCountSQLMaxMin
0.3477431SELECT A.*, B.seo, B.name as categoryname, C.username, C.userlevel, C.lastlogin, C.ip, C.profilepicture FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID ORDER BY A.viewcount desc LIMIT 0,400.3477430.347743
0.2045801SELECT COUNT(A.wantid) AS total FROM wanttobuy as A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID 0.2045800.204580
0.1420731SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 55497 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Php Mysql Mmsql%' ) LIMIT 40.1420730.142073