Uban PHP Viewer

[Lt.Smith]

Good job, saves me writing my own

[AviZ]

what i would like to see is people help to make this a better thing, rather than just taking, editing it to their liking and thats it.

There must be some telented people out there that deals with php, afterall "Two Heads Are Better Than One"

[Lt.Smith]

Hey I'm fine with posting my code. It's not going to be much but I have no problem with sharing it

[Megiddo]

http://www.zkoss.org/
Useful++

[Lt.Smith]

Oooh that looks interesting! My coding skills aren't that well-tuned yet though, so I'm having a hard time figuring out how I'm supposed to use it, but hey, I have time.

Update: Needs configuring in the webserver... I doubt I'll be able to do that with my cheap-as- package, but I suppose it doesn't hurt to ask. I know PHP though, so I'll be focusing my efforts on that. Perhaps if my brain grows I'll try later, haha

[spbogie]

There's also the Google Web Toolkit. Cross compiles from Java, lets you use debuggers and everything else. I plan to try it myself when I get some time.

[Lt.Smith]

Heh, I ended up starting from scratch and writing my own page anyway.

You can take this and use it, modify it, whatever. Just remember to be nice and keep my name in the bottom or commented out in the page's source or something if you really find it ugly. Do whatever.

The coding is pretty sloppy, especially the pagination part, but I was too lazy to check where I'd mixed up ' and " quotes. I pulled the pagination part from a deceased script elsewhere, so it's a bit of a mess. If you want to cut down on the amount of queries you're executing, the thing you can remove is the permaban counter, it'll come out with no trouble at all. I tried to comment what I was doing as much as possible, so it shouldn't be too hard to follow.

The attached file is .txt by the way - just rename it to .php, fill in your database info and you're ready to roll!

Check out what she looks like here!

[Tophat Man]

We did the exact same thing about a month ago and it looks exactly the same as ours but ours showed more information on the ban when you clicked on the persons name. www.gman4president.com exept all the bans got erased in the re-install so it doesn't show up. Just ask mrpresident.

[MrPresident]

Na, we dont have the list anymore because I unistalled UBan. Our SQL host was being retarded and the game was locking up everytime it tried to connect.

[Lt.Smith]

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'zakap_tophatman'@'69.89.31.223' (using password: YES) in /home/theslick/public_html/MrPresident/bans.php on line 95
Unable to select database.

Well, there's only so many ways you can format a ban list. My database is in the USA, but the gameserver is in London, so yes, the game freezes for a bit when you run a query. My solution was to write to the db every 7 minutes instead of every minute. It means bans are lost if the server crashes within 1-7 minutes of banning someone, but if people got banned the server shouldn't be crashing anyway. It hides the latency issue pretty well.

[JamminR]

Is there not a way to make the gm_sql library run threaded? That is
Fake code-
Stored banlist -
Connect to SQL database
write stored banlist
<gmod, other lua scripts keep running here, not waiting on above lines>
<close connection>

[Megiddo]

Is there not a way to make the gm_sql library run threaded? That is
Fake code-
Stored banlist -
Connect to SQL database
write stored banlist
<gmod, other lua scripts keep running here, not waiting on above lines>
<close connection>

gm_sql runs asynchronously ("threaded") all the time.

[MrPresident]

I wish that were true Meg. With gm_sql whenever it attempts to make a connection, if it can not, the whole game server stops responding and everyone on it times out for about 10-15 seconds. then everything resumes. Of course, this only happens when it CANT connect.


OH WAIT.. I wonder.. Now that I think about it, It didn't lag when I was playing a listen server doing some tests.. I would just get the errors, but no lag. (threaded?) Maybe my dedicated server doesn't allow threaded processes since we are sharing a box with other clients? Is this possibly the case?

[JamminR]

doesn't allow threaded processes since we are sharing a box with other clients? Is this possibly the case?

Uh, won't say no, but, 99% doubtful.
I didn't mean threaded as in multi-core type threading anyway.
Just meant as in programming 'fork' where each process takes turns (as equally as possible).
Sounds like ded server gm_sql or lua calls to it aren't sharing as nice as they should.

[spbogie]

The calls to the gm_mysql module are all blocking because they all return a value depending on the result of the connection, however, they should all gracefully timeout after a short period of time if they can't connect.