script gemmer array i db
jeg er ved at skrive et script om som før har skrevet til nogle filer. Problemmet er at når jeg kører scriptet gemmer den ikke daten i databasen men skriver bare array.______________________________________________________
<?php
$temp1=reados();
$temp2=readbrowser();
$temp3=readstat();
$temp4=readscreen();
$temp5=readlang();
$color = $_REQUEST['color'];
$referer = $_REQUEST['referer'];
$res = $_REQUEST['res'];
webstat($temp1, $temp2, $temp3, $temp4, $temp5, $color, $referer, $res);
function write($statliste, $osliste, $browserliste, $screenliste, $la) {
include("setup.inc");
mysql_connect("$db_host", "$db_user", "$db_pass");
mysql_select_db("$database");
mysql_query("update `stats` set
stats='$statliste[dato]<ny>$statliste[sdato]<ny>$statliste[hits]<ny>$statliste[unike]<ny>$statliste[ip]<ny>$statliste[referer]<ny>\n',
os='$osliste[os_95]<ny>$osliste[os_31]<ny>$osliste[os_98]<ny>$osliste[os_me]<ny>$osliste[os_nt]<ny>$osliste[os_2000]<ny>$osliste[os_xp]<ny>$osliste[os_linux]<ny>$osliste[os_unix]<ny>$osliste[os_mac]<ny>$osliste[os_3195]<ny>$osliste[os_95nt]<ny>$osliste[os_andet]<ny>\n',
lang='',
browser='$browserliste[browser_ie3]<ny>$browserliste[browser_ie4]<ny>$browserliste[browser_ie5]<ny>$browserliste[browser_ie6]<ny>$browserliste[browser_ie]<ny>$browserliste[browser_nn4]<ny>$browserliste[browser_nn6]<ny>$browserliste[browser_opera]<ny>$browserliste[browser_lynx]<ny>$browserliste[browser_konqueror]<ny>$browserliste[browser_andet]<ny>\n',
screen='$screenliste[color_256]<ny>$screenliste[color_16]<ny>$screenliste[color_24]<ny>$screenliste[color_32]<ny>$screenliste[color_andet]<ny>$screenliste[res_640_480]<ny>$screenliste[res_720_480]<ny>$screenliste[res_800_600]<ny>$screenliste[res_848_480]<ny>$screenliste[res_1024_768]<ny>$screenliste[res_1152_864]<ny>$screenliste[res_1280_1024]<ny>$screenliste[res_1400_1050]<ny>$screenliste[res_1600_1200]<ny>$screenliste[res_andet]<ny>\n' where id='1'") or die("fejl");
}
function readlang() {
include("setup.inc");
mysql_connect("$db_host", "$db_user", "$db_pass");
mysql_select_db("$database");
$res = mysql_query("select stats from lang");
$line1 = split("<p>", $line1);
$la['ac'] = $line1[0];
$la['ad'] = $line1[1];
$la['ae'] = $line1[2];
$la['af'] = $line1[3];
$la['ag'] = $line1[4];
$la['ai'] = $line1[5];
$la['al'] = $line1[6];
$la['am'] = $line1[7];
$la['an'] = $line1[8];
$la['ao'] = $line1[9];
$la['aq'] = $line1[10];
$la['ar'] = $line1[11];
$la['as'] = $line1[12];
$la['at'] = $line1[13];
$la['au'] = $line1[14];
$la['aw'] = $line1[15];
$la['az'] = $line1[16];
$la['ba'] = $line1[17];
$la['bb'] = $line1[18];
$la['bd'] = $line1[19];
$la['be'] = $line1[20];
$la['bf'] = $line1[21];
$la['bg'] = $line1[22];
$la['bh'] = $line1[23];
$la['bi'] = $line1[24];
$la['bj'] = $line1[25];
$la['bm'] = $line1[26];
$la['bn'] = $line1[27];
$la['bo'] = $line1[28];
$la['br'] = $line1[29];
$la['bs'] = $line1[30];
$la['bt'] = $line1[31];
$la['bv'] = $line1[32];
$la['bw'] = $line1[33];
$la['by'] = $line1[34];
$la['bz'] = $line1[35];
$la['ca'] = $line1[36];
$la['cc'] = $line1[37];
$la['cf'] = $line1[38];
$la['cg'] = $line1[39];
$la['ch'] = $line1[40];
$la['ci'] = $line1[41];
$la['ck'] = $line1[42];
$la['cl'] = $line1[43];
$la['cm'] = $line1[44];
$la['cn'] = $line1[45];
$la['co'] = $line1[46];
$la['com'] = $line1[47];
$la['cr'] = $line1[48];
$la['cs'] = $line1[49];
$la['cu'] = $line1[50];
$la['cv'] = $line1[51];
$la['cx'] = $line1[52];
$la['cy'] = $line1[53];
$la['cz'] = $line1[54];
$la['de'] = $line1[55];
$la['dj'] = $line1[56];
$la['dk'] = $line1[57];
$la['dm'] = $line1[58];
$la['do'] = $line1[59];
$la['dz'] = $line1[60];
$la['ec'] = $line1[61];
$la['edu'] = $line1[62];
$la['ee'] = $line1[63];
$la['eg'] = $line1[64];
$la['eh'] = $line1[65];
$la['er'] = $line1[66];
$la['es'] = $line1[67];
$la['et'] = $line1[68];
$la['fi'] = $line1[69];
$la['fj'] = $line1[70];
$la['fk'] = $line1[71];
$la['fm'] = $line1[72];
$la['fo'] = $line1[73];
$la['fr'] = $line1[74];
$la['fx'] = $line1[75];
$la['ga'] = $line1[76];
$la['gb'] = $line1[77];
$la['gd'] = $line1[78];
$la['ge'] = $line1[79];
$la['gf'] = $line1[80];
$la['gh'] = $line1[81];
$la['gi'] = $line1[82];
$la['gl'] = $line1[83];
$la['gm'] = $line1[84];
$la['gn'] = $line1[85];
$la['gov'] = $line1[86];
$la['gp'] = $line1[87];
$la['gq'] = $line1[88];
$la['gr'] = $line1[89];
$la['gs'] = $line1[90];
$la['gt'] = $line1[91];
$la['gu'] = $line1[92];
$la['gw'] = $line1[93];
$la['gy'] = $line1[94];
$la['hk'] = $line1[95];
$la['hm'] = $line1[96];
$la['hn'] = $line1[97];
$la['hr'] = $line1[98];
$la['ht'] = $line1[99];
$la['hu'] = $line1[100];
$la['is'] = $line1[101];
$la['id'] = $line1[102];
$la['ie'] = $line1[103];
$la['il'] = $line1[104];
$la['in'] = $line1[105];
$la['io'] = $line1[106];
$la['iq'] = $line1[107];
$la['ir'] = $line1[108];
$la['it'] = $line1[109];
$la['jm'] = $line1[110];
$la['jo'] = $line1[111];
$la['jp'] = $line1[112];
$la['ke'] = $line1[113];
$la['kg'] = $line1[114];
$la['kh'] = $line1[115];
$la['ki'] = $line1[116];
$la['km'] = $line1[117];
$la['kn'] = $line1[118];
$la['kp'] = $line1[119];
$la['kr'] = $line1[120];
$la['ku'] = $line1[121];
$la['ky'] = $line1[122];
$la['kz'] = $line1[123];
$la['la'] = $line1[124];
$la['lb'] = $line1[125];
$la['lc'] = $line1[126];
$la['li'] = $line1[127];
$la['lk'] = $line1[128];
$la['lr'] = $line1[129];
$la['ls'] = $line1[130];
$la['lt'] = $line1[131];
$la['lu'] = $line1[132];
$la['lv'] = $line1[133];
$la['ly'] = $line1[134];
$la['ma'] = $line1[135];
$la['mc'] = $line1[136];
$la['md'] = $line1[137];
$la['mg'] = $line1[138];
$la['mh'] = $line1[139];
$la['mil'] = $line1[140];
$la['mk'] = $line1[141];
$la['ml'] = $line1[142];
$la['mm'] = $line1[143];
$la['mn'] = $line1[144];
$la['mo'] = $line1[145];
$la['mp'] = $line1[146];
$la['mq'] = $line1[147];
$la['mr'] = $line1[148];
$la['ms'] = $line1[149];
$la['mt'] = $line1[150];
$la['mu'] = $line1[151];
$la['mv'] = $line1[152];
$la['mw'] = $line1[153];
$la['mx'] = $line1[154];
$la['my'] = $line1[155];
$la['mz'] = $line1[156];
$la['na'] = $line1[157];
$la['nc'] = $line1[158];
$la['ne'] = $line1[159];
$la['net'] = $line1[160];
$la['nf'] = $line1[161];
$la['ng'] = $line1[162];
$la['ni'] = $line1[163];
$la['nl'] = $line1[164];
$la['no'] = $line1[165];
$la['np'] = $line1[166];
$la['nr'] = $line1[167];
$la['nt'] = $line1[168];
$la['nu'] = $line1[169];
$la['nz'] = $line1[170];
$la['om'] = $line1[171];
$la['org'] = $line1[172];
$la['pa'] = $line1[173];
$la['pe'] = $line1[174];
$la['pf'] = $line1[175];
$la['pg'] = $line1[176];
$la['ph'] = $line1[177];
$la['pk'] = $line1[178];
$la['pl'] = $line1[179];
$la['pm'] = $line1[180];
$la['pn'] = $line1[181];
$la['pr'] = $line1[182];
$la['pt'] = $line1[183];
$la['pw'] = $line1[184];
$la['py'] = $line1[185];
$la['qa'] = $line1[186];
$la['re'] = $line1[187];
$la['ro'] = $line1[188];
$la['ru'] = $line1[189];
$la['rw'] = $line1[190];
$la['sa'] = $line1[191];
$la['sb'] = $line1[192];
$la['sc'] = $line1[193];
$la['sd'] = $line1[194];
$la['se'] = $line1[195];
$la['sg'] = $line1[196];
$la['sh'] = $line1[197];
$la['si'] = $line1[198];
$la['sj'] = $line1[199];
$la['sk'] = $line1[200];
$la['sl'] = $line1[201];
$la['sm'] = $line1[202];
$la['sn'] = $line1[203];
$la['so'] = $line1[204];
$la['sr'] = $line1[205];
$la['st'] = $line1[206];
$la['su'] = $line1[207];
$la['sv'] = $line1[208];
$la['sy'] = $line1[209];
$la['sz'] = $line1[210];
$la['tc'] = $line1[211];
$la['td'] = $line1[212];
$la['tf'] = $line1[213];
$la['tg'] = $line1[214];
$la['th'] = $line1[215];
$la['tj'] = $line1[216];
$la['tk'] = $line1[217];
$la['tm'] = $line1[218];
$la['tn'] = $line1[219];
$la['to'] = $line1[220];
$la['tp'] = $line1[221];
$la['tr'] = $line1[222];
$la['tt'] = $line1[223];
$la['tv'] = $line1[224];
$la['tw'] = $line1[225];
$la['tz'] = $line1[226];
$la['ua'] = $line1[227];
$la['ug'] = $line1[228];
$la['uk'] = $line1[229];
$la['um'] = $line1[230];
$la['us'] = $line1[231];
$la['uy'] = $line1[232];
$la['uz'] = $line1[233];
$la['va'] = $line1[234];
$la['vc'] = $line1[235];
$la['ve'] = $line1[236];
$la['vg'] = $line1[237];
$la['vi'] = $line1[238];
$la['vn'] = $line1[239];
$la['vu'] = $line1[240];
$la['wf'] = $line1[241];
$la['ws'] = $line1[242];
$la['ye'] = $line1[243];
$la['yt'] = $line1[244];
$la['yu'] = $line1[245];
$la['za'] = $line1[246];
$la['zm'] = $line1[247];
$la['zr'] = $line1[248];
$la['zw'] = $line1[249];
$la['andet'] = $line1[250];
return $la;
}
function readbrowser() {
include("setup.inc");
mysql_connect("$db_host", "$db_user", "$db_pass");
mysql_select_db("$database");
$res = mysql_query("select browser from stats");
$line1 = mysql_fetch_array($res);
$line1 = split("<ny>", $line1);
$browserliste[browser_ie3] = $line1[0];
$browserliste[browser_ie4] = $line1[1];
$browserliste[browser_ie5] = $line1[2];
$browserliste[browser_ie6] = $line1[3];
$browserliste[browser_ie] = $line1[4];
$browserliste[browser_nn4] = $line1[5];
$browserliste[browser_nn6] = $line1[6];
$browserliste[browser_opera] = $line1[7];
$browserliste[browser_lynx] = $line1[8];
$browserliste[browser_konqueror] = $line1[9];
$browserliste[browser_andet] = $line1[10];
return $browserliste;
}
function readstat() {
include("setup.inc");
mysql_connect("$db_host", "$db_user", "$db_pass");
mysql_select_db("$database");
$res = mysql_query("select stats from stats");
$line1 = mysql_fetch_array($res);
$line1 = split("<ny>", $line1);
$statliste[dato] = $line1[0];
$statliste[sdato] = $line1[1];
$statliste[hits] = $line1[2];
$statliste[unike] = $line1[3];
$statliste[ip] = $line1[4];
$statliste[referer] = $line1[5];
return $statliste;
}
function readscreen() {
include("setup.inc");
mysql_connect("$db_host", "$db_user", "$db_pass");
mysql_select_db("$database");
$res = mysql_query("select browser from stats");
$line1 = mysql_fetch_array($res);
$line1 = split("<ny>", $line1);
$screenliste[color_256] = $line1[0];
$screenliste[color_16] = $line1[1];
$screenliste[color_24] = $line1[2];
$screenliste[color_32] = $line1[3];
$screenliste[color_andet] = $line1[4];
$screenliste[res_640_480] = $line1[5];
$screenliste[res_720_480] = $line1[6];
$screenliste[res_800_600] = $line1[7];
$screenliste[res_848_480] = $line1[8];
$screenliste[res_1024_768] = $line1[9];
$screenliste[res_1152_864] = $line1[10];
$screenliste[res_1280_1024] = $line1[11];
$screenliste[res_1400_1050] = $line1[12];
$screenliste[res_1600_1200] = $line1[13];
$screenliste[res_andet] = $line1[14];
return $screenliste;
}
function reados() {
include("setup.inc");
mysql_connect("$db_host", "$db_user", "$db_pass");
mysql_select_db("$database");
$res = mysql_query("select browser from stats");
$line1 = mysql_fetch_array($res);
$line1 = split("<ny>", $line1);
$osliste[os_95] = $line1[0];
$osliste[os_31] = $line1[1];
$osliste[os_98] = $line1[2];
$osliste[os_me] = $line1[3];
$osliste[os_nt] = $line1[4];
$osliste[os_2000] = $line1[5];
$osliste[os_xp] = $line1[6];
$osliste[os_linux] = $line1[7];
$osliste[os_unix] = $line1[8];
$osliste[os_mac] = $line1[9];
$osliste[os_3195] = $line1[10];
$osliste[os_95nt] = $line1[11];
$osliste[os_andet] = $line1[12];
return $osliste;
}
function webstat($osliste, $browserliste, $statliste, $screenliste, $la, $color, $referer, $res) {
global $REMOTE_ADDR;
$host = gethostbyaddr($REMOTE_ADDR);
if ($host != NULL){
$top = (strrchr($host, "."));
$top = (ereg_replace("\.", "", $top));
} else {
$top = "";
}
if (array_key_exists($top, $la)) {
$la[$top]++;
} else {
$la['andet']++;
}
$ip = getenv("REMOTE_ADDR");
$date=date("j/n Y");
if (ereg($date, $statliste[dato]) && ereg($ip, $statliste[ip])) {
$statliste[hits]++;
} else {
$statliste[unike]++;
$statliste[hits]++;
}
if (ereg($ip, $statliste[ip])) {
$ip = NULL;
} else {
$ip .= " ";
}
if (ereg($date, $statliste[dato])) {
$statliste[ip] .= $ip;
} else {
$statliste[ip] = NULL;
}
$statliste[dato] = $date;
if ($referer != NULL) {
$referer .= "<refny>";
}
$statliste[referer] .= $referer;
$browser = getenv("HTTP_USER_AGENT");
if (preg_match("/opera/i", $browser)) {
$browserliste[browser_opera]++;
}
elseif (preg_match("/konqueror/i", $browser)) {
$browserliste[browser_konqueror]++;
}
elseif (preg_match("/msie 3/i", $browser)) {
$browserliste[browser_ie3]++;
}
elseif (preg_match("/msie 4/i", $browser)) {
$browserliste[browser_ie4]++;
}
elseif (preg_match("/msie 5/i", $browser)) {
$browserliste[browser_ie5]++;
}
elseif (preg_match("/msie 6/i", $browser)) {
$browserliste[browser_ie6]++;
}
elseif (preg_match("/msie/i", $browser)) {
$browserliste[browser_ie]++;
}
elseif (preg_match("/lynx/i", $browser)) {
$browserliste[browser_lynx]++;
}
elseif (preg_match("/mozilla\/4/i", $browser)) {
$browserliste[browser_nn4]++;
}
elseif (preg_match("/mozilla\/5/i", $browser)) {
$browserliste[browser_nn6]++;
} else {
$browserliste[browser_andre]++;
}
if ($color == "8") {
$screenliste[color_256]++;
} elseif ($color == "16") {
$screenliste[color_16]++;
} elseif ($color == "24") {
$screenliste[color_24]++;
} elseif ($color == "32") {
$screenliste[color_32]++;
} else {
$screenliste[color_andet]++;
}
if ($res == "640x480") {
$screenliste[res_640_480]++;
} elseif ($res == "720x480") {
$screenliste[res_720_480]++;
} elseif ($res == "800x600") {
$screenliste[res_800_600]++;
} elseif ($res == "848x480") {
$screenliste[res_848_480]++;
} elseif ($res == "1024x768") {
$screenliste[res_1024_768]++;
} elseif ($res == "1152x864") {
$screenliste[res_1152_864]++;
} elseif ($res == "1280x1024") {
$screenliste[res_1280_1024]++;
} elseif ($res == "1400x1050") {
$screenliste[res_1400_1050]++;
} elseif ($res == "1600x1200") {
$screenliste[res_1600_1200]++;
} else {
$screenliste[res_andet]++;
}
$os = getenv("HTTP_USER_AGENT");
if (preg_match("/win95/i", $os)) {
$osliste[os_95]++;
}
elseif (preg_match("/Win 9x 4\.9/i", $os)) {
$osliste[os_me]++;
}
elseif (preg_match("/win98/i", $os)) {
$osliste[os_98]++;
}
elseif (preg_match("/winnt/i", $os)) {
$osliste[os_nt]++;
}
elseif (preg_match("/windows 2000/i", $os)) {
$osliste[os_2000]++;
}
elseif (preg_match("/windows me/i", $os)) {
$osliste[os_me]++;
}
elseif (preg_match("/windows xp/i", $os)) {
$osliste[os_xp]++;
}
elseif (preg_match("/winweb/i", $os)) {
$osliste[os_3195]++;
}
elseif (preg_match("/windows 95/i", $os)) {
$osliste[os_95]++;
}
elseif (preg_match("/windows 98/i", $os)) {
$osliste[os_98]++;
}
elseif (preg_match("/Windows NT 5\.1/i", $os)) {
$osliste[os_xp]++;
}
elseif (preg_match("/windows nt 5/i", $os)) {
$osliste[os_2000]++;
}
elseif (preg_match("/windows nt/i", $os)) {
$osliste[os_nt]++;
}
elseif (preg_match("/win16/i", $os)) {
$osliste[os_3195]++;
}
elseif(preg_match("/windows 3\.1/i", $os)) {
$osliste[os_31]++;
}
elseif (preg_match("/win32/i", $os)) {
$osliste[os_95nt]++;
}
elseif (preg_match("/windows/i", $os)) {
if (preg_match("/32bit/i", $os)) {
$osliste[os_95nt]++;
} else {
$osliste[os_3195]++;
}
}
elseif (preg_match("/iweng/i", $os)) {
$osliste[os_3195]++;
}
elseif (preg_match("/mac/i", $os)) {
$osliste[os_mac]++;
}
elseif (preg_match("/linux/i", $os)) {
$osliste[os_linux]++;
}
elseif (preg_match("/konqueror/i", $os)) {
$osliste[os_linux]++;
}
elseif (preg_match("/hp-ux/i", $os)) {
$osliste[os_unix]++;
}
elseif (preg_match("/sunos/i", $os)) {
$osliste[os_unix]++;
}
elseif (preg_match("/x11/i", $os)) {
$osliste[os_unix]++;
} else {
$osliste[os_andet]++;
}
write($statliste, $osliste, $browserliste, $screenliste, $la);
}
?>
