x-MU.net форум

require("config.php");

$mmotop_db = file($Sky['ParserURL']);
foreach($mmotop_db as $mmotop_line) {
$vote_db    = explode("    ",$mmotop_line);
$vote_id    = $vote_db

• ;

$vote_time    = strtotime($vote_db[1]);
$vote_ip    = $vote_db[2];
$vote_acc    = $vote_db[3];
$vote_type    = substr($vote_db[4],0,1);    //    1 - Простой; 2 - SMS
$query = mssql_query("SELECT memb___id FROM $Sky[CrDB] WHERE memb___id = '".$vote_acc."'");
$acc_check = mssql_num_rows($query);
if ($acc_check > 0) {
$query=mssql_query("SELECT * FROM Sky_MMOTOP WHERE vote_id = '".$vote_id."' AND vote_time = '".$vote_time."' AND vote_acc = '".$vote_acc."' AND vote_type = '".$vote_type."'");
$check_vote = mssql_num_rows($query);
if ($check_vote <= 0) {
mssql_query("UPDATE $Sky[CrDB] SET $Sky[CrCol] = $Sky[CrCol]+'".$vote_type."'* $Sky[CredPerVote] WHERE memb___id='".$vote_acc."'");
mssql_query("INSERT INTO Sky_MMOTOP (vote_id,vote_time,vote_ip,vote_acc,vote_type) VALUES ('$vote_id','$vote_time','$vote_ip','$vote_acc','$vote_type')");

}

}

}
?>

$Sky[CrDB]        = 'MEMB_CREDITS';        // Credits Database
$Sky[CrCol]        = 'credits';            // Credits column on a $Sky[CrDB]

$Sky[ParserURL]        = 'URL of statistics txt file';
$Sky[CredPerVote]    = '10';                // Reward

CREATE TABLE [dbo].[Sky_MMOTOP] (
[vote_id] [int] NULL ,
[vote_time] [varchar] (50) COLLATE Korean_Wansung_CI_AS NULL ,
[vote_ip] [varchar] (50) COLLATE Korean_Wansung_CI_AS NULL ,
[vote_acc] [varchar] (50) COLLATE Korean_Wansung_CI_AS NULL ,
[vote_type] [int] NULL
) ON [PRIMARY]
GO