iMonitor

[finality]

I quit this project, cause of less time and not much interest in WoW anymore...

I've uploaded the current site, maybe someone need it.

Maybe I make in the future a new plugin maybe not

The current website will be online, until 01.02.2010.

 

[Cracktomte]

Use IP as primary key instead, safer than a random number imo, or just character name?

 

[finality]

Ok IP is a good idear...but the Char name can be twice. Different Realms^^
I think I will use IP, thanks for it

 

[Cracktomte]

Ok IP is a good idear...but the Char name can be twice. Different Realms^^
I think I will use IP, thanks for it

But you can also run several bots from the same IP. I don't know if HB know what realm the char is on, if it does, a combination of name and realm would be the best. I think... Haven't slept for days, lol.

 

[finality]

I think... Haven't slept for days, lol.

Yeah thats my feelings, too...^^
I will have a look into the API with the Object inspector... Maybe i find something Unique
But I think it would be the best if it's not the Accountname or the realm... Some data should never been captured

 

[finality]

Something went wrong with the host... I will fix it.. Sorry -.- Nice startup

 

[Laso49]

Found a problem, It routed me to someone else's ID so I had to go in Imonitor.cs and edit Line 64-66
I

 Commented out those
//Random number = new Random(1337);
                
                //ident = number.Next(1, 9999999);

and then
ident = XXXXX;
Added my own number... Then I had space on the site you have.... For some reason it links everyone to ID 2088883

 

[finality]

yeah i know i fixed that
But thx
I just fixed one thing in the index.php. So now the Search works...

 

[Laso49]

Not quite.
If you search the name for example Joe, and refresh the page it gives you
No record found

at http://usilight.us.ohost.de/index.php?id=joe

 

[finality]

Yeah I know... I must change something...but i can't find the answer...

if(is_numeric($_GET['id']))
{
$query = mysql_query("SELECT * FROM data WHERE charID = '".mysql_real_escape_string($_GET['id'])."'");
}else{
// Get charID by Name and the newest entry
$id = mysql_fetch_array(mysql_query("SELECT charID FROM data WHERE name = '".mysql_real_escape_string($_GET['id'])."' AND zeit = (SELECT MAX(zeit) FROM data)"));
$query = mysql_query("SELECT * FROM data WHERE charID = '".$id['charID']."'");
}

There's a fault I can't find...

Because if u search by ID u always get an result. But if u search by Name it's lucky to receive one...

 

[Laso49]

Well I guess It's a good thing I set my own id huh I can just use that

 

[finality]

I think i fixed this...
Noob mistake -.-

if(is_numeric($_GET['id']))
{
$query = mysql_query("SELECT * FROM data WHERE charID = '".mysql_real_escape_string($_GET['id'])."'");
}else{
// Get charID by Name and the newest entry
$id = mysql_fetch_array(mysql_query("SELECT charID FROM data WHERE name = '".mysql_real_escape_string($_GET['id'])."' AND zeit = (SELECT MAX(zeit) FROM data WHERE name = '".mysql_real_escape_string($_GET['id'])."')"));
$query = mysql_query("SELECT * FROM data WHERE charID = '".$id['charID']."'");
}

I compared wrong Data rows.....

So now it should works well...

 

[finality]

If something went wrong, or u're data would'nt been captured report to me pls.

 

[SkyHigh]

Looks good, is it me or have there been a ton of these popping up over the last month?

 

[Spartanmfot]

Just gave it a little test and it worked perfectly! Hope it carries on and thank you very much!

 

[Possien]

you might want to have a look a some mysql libs/class's for php

 

[finality]

you might want to have a look a some mysql libs/class's for php

And why?^^

 

[Possien]

And why?^^

It makes doing your > 20 sql statements alot easier and most libs prevent sql injection ( couldn't see any in your code )

 

[Cardsmall]

What's the website to check? I had it but now it doesn't work.. Is it down or am I missing something

 

[finality]

What's the website to check? I had it but now it doesn't work.. Is it down or am I missing something

Hm...I think the Freehoster is not glad about my Database.
Now I'm at work...I think I'm fix this this evening, and will move the Site to my own Webspace not a freehost.