UAN Statistics - Elmo's dead IV

i actually play as Darwin Award or [UAN]Darwin Award sometimes.

Elmo or Krome,

How did you get that UAN members stats to work?

I scripted a page just for it. Basically, copy and paste.

I had it do a search for [UAN] but now that I think about it, all I had to do was add something like "AND playername LIKE %[%U%A%N%]%" to the mYSQL query.

PS, krome or xpider, I know that's not EXACT syntax. I'm just spouting stuff off the top of my head.

I've added: "AND playername LIKE %[%U%A%N%]%" to the mYSQL query, but nothing happened...

Well, I don't think that was the exact syntax, plus, you would have to do MUCH more than just add that to the query.

Also, the % symbol just means that there can be other characters in between the letters/symbols. In this case, it could mean color codes: "^3 ^2" etc.

So, by looking for "%[U%A%N%]%" it's looking for all player names that contain [UAN], regardless of what color codes may be between or after them.

Example: (REO) would be %(%R%E%O%)%

There's a lot that needs to be done to actually code and add the Members page. If you don't know PHP/mySQL, I'd suggest asking someone to do it for you. I'm moving in 3 days, else I'd offer to do it.

That was just my way of saying thanks for your explanation which, of course, didn't help at all... Im not that noob

I'll contact you asap Krome.

Haha, ok elite. It did seem pretty funny but I treated it as if you were serious.

I don't know how to explain it better.

Let me try:

You need to make a page and put the functions from the index.php page.

I chose to copy and paste the search function over. I commented out things so it would perform a name search and then I defined: $search_txt=('[UAN]');

What I meant before was, it may have been better to make a new query. Something along the lines of"

Code:

$sql="select playerID,playerName,skill as skill,kills,deaths,kill_streak,death_streak,games

yes! its as follows:

1. WEAO
2. elmo
3. LayZ
4. LayZ's mum
4. me
4. you
5. kr0me

cool

can you add "thegreenlantern" as best hacker.....so funny, please!!!!

p.s. I love you kr0me!!!!