Waffen in MYSQL Tabelle loggen

<?php







/*
PLUGIN: Weaponrestrictions
================
Kicks players automatically when they are using a restricted weapon




CONFIG:
-------
[weaponrestrictions]
enabled = 1                                   ;Enable plugin
weapons = "gl,frag_grenade_short"             ;restricted weapons
warnstokick = 2                               ;Warns until players get kicked
mode = "tempban"                              ;kick/ban/tempban
kickreason = "Used a restricted weapon: <WEAPON>" ;Reason of the kick







NAMESPACE: weaponrestrictions




Functions:
 weaponrestrictions_main
 weaponrestrictions_playerInit
 
 DATABASE==============================
 
-- phpMyAdmin SQL Dump
-- version 2.11.8.1deb5+lenny6
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Erstellungszeit: 10. Dezember 2010 um 18:33
-- Server Version: 5.0.51
-- PHP-Version: 5.2.6-1+lenny9




SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";




--
-- Datenbank: `mamstats`
--




-- --------------------------------------------------------




--
-- Tabellenstruktur für Tabelle `waffen`
--
ALTER TABLE `mam01_user` ADD(
  `ak47_mp` int(11) NOT NULL,
  `g36c_mp` int(11) NOT NULL,
  `g3_mp` int(11) NOT NULL,
  `m14_mp` int(11) NOT NULL,
  `m16_mp` int(11) NOT NULL,
  `m4_mp` int(11) NOT NULL,
  `mp44_mp` int(11) NOT NULL,
  `mp5_mp` int(11) NOT NULL,
  `skorpion_mp` int(11) NOT NULL,
  `uzi_mp` int(11) NOT NULL,
  `ak74u_mp` int(11) NOT NULL,
  `p90_mp` int(11) NOT NULL,
  `saw_mp` int(11) NOT NULL,
  `rpd_mp` int(11) NOT NULL,
  `m60e4_mp` int(11) NOT NULL,
  `m1014_mp` int(11) NOT NULL,
  `winchester1200_mp` int(11) NOT NULL,
  `m40a3_mp` int(11) NOT NULL,
  `m21_mp` int(11) NOT NULL,
  `dragunov_mp` int(11) NOT NULL,
  `barrett_mp` int(11) NOT NULL,
  `remington700_mp` int(11) NOT NULL,
  `beretta_mp` int(11) NOT NULL,
  `usp_mp` int(11) NOT NULL,
  `colt45_mp` int(11) NOT NULL,
  `deserteagle_mp` int(11) NOT NULL,
  `flash_mp` int(11) NOT NULL,
  `frag_mp` int(11) NOT NULL,
  `smoke_mp` int(11) NOT NULL,
  `concussion_mp` int(11) NOT NULL,
  `frag_grenade_short_mp` int(11) NOT NULL,
  `artillery_mp` int(11) NOT NULL,
  `c4_mp` int(11) NOT NULL,
  `claymore_mp` int(11) NOT NULL,
  `cobra_mp` int(11) NOT NULL,
  `gl_mp` int(11) NOT NULL,
  `rpg_mp` int(11) NOT NULL
) ;







*/




$mod->setDefaultCV("weaponrestrictions", "enabled", 0);
$mod->setDefaultCV("weaponrestrictions", "weapons", "");
$mod->setDefaultCV("weaponrestrictions", "warnstokick", 2);
$mod->setDefaultCV("weaponrestrictions", "mode", "tempban");
$mod->setDefaultCV("weaponrestrictions", "kickreason", "Used a restricted weapon: <WEAPON>");




$mod->registerEvent("playerJoined", "weaponrestrictions_playerInit");
$mod->registerEvent("playerKill", "weaponrestrictions_main");
$mod->registerEvent("playerTeamKill", "weaponrestrictions_main");







//Init Players because playerJoined isn't called at startup
//Init Players because playerJoined isn't called at startup
array_map("weaponrestrictions_playerInit", array_keys($players));




function weaponrestrictions_main($parameters) {
global $mod;
global $players;
global $logging;
global $logkickbans_filehandle;
list($killer_guid, $victim_guid, $weapon) = $parameters;
  //  if ($weapon[1] == "MOD_MELEE") {
  //  //Dont warn when player knived while he had a restricted weapon
  //  return;
   // }







$weapon = $weapon[0];




if (!$mod->getCV("weaponrestrictions", "enabled")) {
    return;
}




$weapons = explode(",", $mod->getCV("weaponrestrictions", "weapons"));




$restricted = false;
foreach ($weapons as $value) {
if (strpos($weapon, $value . "_") === 0) {
$restricted = true;
break;
}
}




 mysql_connect("localhost","root","werdaskiestwüsstewohlgernemeinmysqlrootpwxD");

  mysql_select_db("mamstats");
  // Make a MySQL Connection
$sql = "SELECT * FROM `mam01_user` WHERE `guid` = $killer_guid" ;
 
$result = mysql_query($sql) or die(mysql_error());







while($row = mysql_fetch_array($result)){
  $row[$weapon] = $row[$weapon]++;
}




   
$sql1= "select * from 'mam01_nicks' UPDATE $weapon = $weapon +1 where 'guid' = $killer_guid ;";




mysql_query($sql1);







}







function weaponrestrictions_playerInit($guid) {
$GLOBALS['players'][$guid]->weaponrestrictions_warns = 0;
}




?>