Timestamps are in GMT/BST.
| 00:00:26 | | amgine123 Quit (Ping timeout: 246 seconds) |
| 00:34:11 | kaen | woo! |
| 00:34:13 | kaen | blank slate! |
| 00:34:14 | kaen | http://bitfighter.org/levels/ |
| 00:50:50 | raptor | hi again |
| 00:51:07 | raptor | ooooo |
| 00:51:10 | raptor | looks good kaen! |
| 00:53:33 | raptor | ok, so i have these levels... what do you think is a good way to get them in the db ? |
| 00:53:43 | raptor | i was thinking of just a crude python script or something |
| 00:55:04 | raptor | I have levels up to id 274 in file format |
| 00:55:38 | kaen | I think that's the way to go |
| 00:56:13 | raptor | is there a way you can lock down posting new levels to pleiades? |
| 00:56:56 | kaen | I can just chmod the directory for now |
| 00:57:02 | | Watusimoto has joined |
| 00:57:03 | kaen | I don't have a mechanism for that :P |
| 00:57:14 | raptor | oh? that's all that is required? |
| 00:57:33 | kaen | well, it just forbids all requests |
| 00:57:39 | kaen | so it doesn't work at all |
| 00:57:40 | raptor | oh wait, you mean just make the web resource unav... yes |
| 00:57:42 | kaen | but yep, that's it |
| 00:57:43 | raptor | ok, duh |
| 00:58:30 | | Flynnn has joined |
| 00:59:34 | raptor | python here i come! |
| 01:06:43 | raptor | kaen: what are the relevant datapoints for a level that i'll need? id, author, level, levelgen |
| 01:11:42 | sam686 | before you import level/levelgen into database, read http://bitfighter.org/forums/viewtopic.php?t=2156#p22333 |
| 01:11:58 | sam686 | basically, make sure "content" "levelgen" is mediumtext |
| 01:12:50 | raptor | oh... let me check the database |
| 01:14:21 | raptor | i sadly wont have any screenshots... |
| 01:14:59 | sam686 | perhaps we could.. make bitfighter.exe make the screenshots for all the levels listed... |
| 01:15:09 | raptor | done |
| 01:15:17 | raptor | both are mediumtext now |
| 01:15:21 | raptor | good remembering sam686 |
| 01:16:08 | raptor | kaen, was the 'description' field taken from the level? |
| 01:25:50 | | Watusimoto Quit (Ping timeout: 248 seconds) |
| 01:34:47 | sam686 | For http://sam6.25u.com/bitfighter/gamereports/graphs/ I need to put empty function in db_finctions.php, function imageantialias() {}; for graphs to work, otherwise there would be no graphs and complains about missing gd function |
| 01:35:23 | raptor | ah yes |
| 01:35:36 | raptor | thanks |
| 01:39:08 | sam686 | This is for kaen: https://github.com/kaen/bitfighter-stats/blob/master/index.php line 12: Delete this line $server = ""; as it was causing it to connect to wrong server, overriding whatever $server is set to in db_functions.php |
| 01:42:23 | sam686 | $server = ":/var/run/mysqld/mysqld2.sock" can also work, for my second mysql server on the same machine |
| 01:45:05 | raptor | yeah... screenshots are a problem :( |
| 01:47:33 | sam686 | just put no-screenshot.png everywhere... |
| 01:47:45 | sam686 | ... for now. |
| 01:47:47 | raptor | yeah, i'll have to do that... |
| 01:53:25 | raptor | do we need to set up a firewall on bitfighter.org? |
| 01:53:44 | raptor | i wonder if having the mysql server port so open is a good idea.. |
| 01:55:11 | sam686 | 1. most mysql logins only works in localhost |
| 01:55:47 | sam686 | 2. it needs external access so at least my server can connect and copy database |
| 02:03:10 | | Akien has joined |
| 02:21:29 | raptor | and you are using the 'backup' user? |
| 02:21:58 | sam686 | raptor, its probably safe to reduce 'backup' privilages to this much: http://sam6.25u.com/upload/backup_priv.png |
| 02:22:01 | sam686 | yes |
| 02:22:28 | raptor | ok |
| 02:22:32 | raptor | will do now |
| 02:23:02 | sam686 | the reason for 'lock tables' is so if the slave gets messed up, i can se-setup and go read-lock so the master database won't change while downloading entire database from master. |
| 02:23:15 | sam686 | re (not se- ) |
| 02:23:22 | raptor | whoa... how did it get so many privileges?? |
| 02:23:30 | sam686 | I went root login |
| 02:23:30 | raptor | i remember setting it up with much fewer... |
| 02:23:48 | raptor | done with privileges.. |
| 02:23:52 | sam686 | there wasn't enough permission to setup, mostly the missing 'replication' permission |
| 02:23:58 | raptor | ah ok |
| 02:24:44 | raptor | who created the level 'osteoporosis' ? |
| 02:24:53 | raptor | that's the only one I can't get the author from.. |
| 02:25:21 | sam686 | I think someone uploaded without author name... |
| 02:27:00 | | Akien Quit (Remote host closed the connection) |
| 02:29:54 | sam686 | I have the level Osteoporosis from March 8, 2011 |
| 02:30:13 | sam686 | yet again, with the missing LevelCredits |
| 02:30:29 | sam686 | and it wasn't made from me.. |
| 02:31:16 | sam686 | A simple forum search http://bitfighter.org/forums/search.php?keywords=Osteoporosis |
| 02:31:24 | sam686 | Osteoporosis - Skybax |
| 02:31:36 | sam686 | theres your answer raptor.. |
| 02:31:40 | raptor | oh good |
| 02:31:42 | raptor | thanks! |
| 02:32:20 | raptor | yay, i now can extract the author + phpbb user id from all my pleiades levels |
| 02:32:25 | raptor | on to the next data point! |
| 02:50:35 | raptor | oh my goodness it's late |
| 02:50:38 | raptor | have to sleep |
| 02:50:39 | raptor | night! |
| 02:50:47 | raptor | the python import script is about 1/3 done i think |
| 02:51:09 | raptor | this will be good because I can use it to add old levels from the forums, too |
| 02:57:29 | | raptor Quit () |
| 04:29:07 | sam686 | I might as well start asking others in the forums if they have downloaded anyone's file attachments to upload it so I can recover those that been uploaded |
| 04:30:42 | | watusimoto has joined |
| 04:30:42 | | ChanServ sets mode +o |
| 06:24:18 | | Flynnn Quit (Quit: Leaving) |
| 06:24:45 | | LordDVG has joined |
| 08:31:04 | | Watusimoto_ has joined |
| 09:00:03 | | kaen Quit (Remote host closed the connection) |
| 09:04:24 | | Watusimoto__ has joined |
| 09:07:25 | | Watusimoto_ Quit (Ping timeout: 240 seconds) |
| 09:56:14 | | -barjavel.freenode.net- *** Looking up your hostname... |
| 09:56:14 | | -barjavel.freenode.net- *** Checking Ident |
| 09:56:14 | | -barjavel.freenode.net- *** Couldn't look up your hostname |
| 09:56:14 | | -barjavel.freenode.net- *** No Ident response |
| 09:56:20 | | BFLogBot has joined |
| 09:56:20 | | -ChanServ- [#bitfighter] Welcome to #bitfighter. This is an IRC channel, many or all of the users may not be paying attention. Please have patience when waiting for a response. |
| 11:05:28 | | raptor has joined |
| 11:05:28 | | ChanServ sets mode +o |
| 11:05:37 | raptor | good morning! |
| 11:06:09 | sam686 | hi, i might fall asleep after a few more hours |
| 11:06:28 | raptor | still awake!? |
| 11:41:35 | raptor | watusimoto: in response to your response to my e-mail - |
| 11:43:06 | raptor | I agree with your assessment of jimmythesquid's design; however, lately I've been feeling partial to less-cluttered site designs |
| 11:43:32 | raptor | i.e. site designs without many bordered divs |
| 12:00:05 | | LordDVG Quit (Remote host closed the connection) |
| 12:08:28 | sam686 | still awake yes... but not for long. |
| 12:13:20 | raptor | oh my goodness brazil lost 7-1 |
| 12:38:34 | | LordDVG has joined |
| 12:53:02 | watusimoto | hi |
| 12:53:05 | watusimoto | yes, epic game |
| 12:53:20 | watusimoto | total devestation |
| 12:53:31 | watusimoto | as for site design, clean and modern is nice |
| 12:53:41 | watusimoto | but we're retro :-) |
| 12:54:53 | watusimoto | not sure why I don't like it more -- it has some very good points |
| 13:00:38 | sam686 | http://sam6.25u.com/upload/bigfile.7z 799 bytes to download, but you going to run out of disk space if you try to uncompress it. |
| 13:08:49 | | watusimoto Quit (Ping timeout: 240 seconds) |
| 13:18:45 | | Watusimoto__ Quit (Ping timeout: 240 seconds) |
| 15:33:47 | | Skybax has joined |
| 15:33:56 | Skybax | Good morning |
| 15:34:25 | Skybax | Is Pleides going to be back up soon? |
| 15:56:49 | | Skybax_ has joined |
| 15:59:31 | | Skybax Quit (Ping timeout: 260 seconds) |
| 16:01:30 | | Skybax_ is now known as Skybax |
| 16:06:52 | | Skybax_ has joined |
| 16:09:19 | | Skybax Quit (Ping timeout: 260 seconds) |
| 16:10:05 | | fordcars has joined |
| 16:23:18 | | Watusimoto has joined |
| 16:35:31 | raptor | hi Skybax_... hopefully, yes |
| 16:35:46 | raptor | however, there will be no screenshots, comments, or votes |
| 16:37:08 | raptor | Watusimoto: do we want a 'retro' site, though? If by retro you mean retro 90s/2000s look and feel :) |
| 16:37:25 | raptor | or do we want a nice clean site that'll get people to click a big clean download button |
| 16:40:55 | fordcars | Modern: http://powdertoy.co.uk/ |
| 16:41:02 | fordcars | Retro: http://www.phelios.com/mac/budredhead.html |
| 16:41:04 | fordcars | :P |
| 16:42:16 | | Skybax_ is now known as Skybax |
| 16:43:40 | | Akien has joined |
| 16:49:07 | Watusimoto | hi |
| 16:49:25 | Watusimoto | watching teh NL argentina game |
| 16:49:28 | Watusimoto | half time |
| 16:51:43 | Watusimoto | so, re the website |
| 16:53:15 | Watusimoto | of the two links fordcars posted, I prefer the modern one |
| 16:53:43 | Watusimoto | for what it's worth... |
| 16:55:32 | Watusimoto | I do like the vectory look of the squid site |
| 17:04:09 | Watusimoto | I'm not sure what I dislike about it... maybe it's the title; maybe the whole title block should be opaque and have the image start below it |
| 17:14:35 | | destroyerimo has joined |
| 17:27:29 | raptor | Watusimoto: the advantage of the squid site is that it's simple with simple CSS header and simple html structure |
| 17:27:53 | raptor | I would definitely change minor things about it - like there's a little too much green |
| 17:28:05 | raptor | we could make the h tags that yellow again |
| 17:28:22 | raptor | my main arguments for it are: |
| 17:28:50 | raptor | 1. cleaner look |
| 17:28:58 | raptor | 2. maintenance simplicity |
| 17:29:30 | raptor | so i'm not really meaning to compare the two sites as is, rather the overall feel on those two points |
| 17:48:06 | | Akien Quit (Quit: Quitte) |
| 18:00:01 | | destroyerimo_clo has joined |
| 18:02:35 | | destroyerimo Quit (Ping timeout: 252 seconds) |
| 18:14:28 | | Skybax Quit (Remote host closed the connection) |
| 18:40:33 | | Watusimoto Quit (Ping timeout: 255 seconds) |
| 18:51:21 | | LordDVG Quit (Remote host closed the connection) |
| 18:52:01 | | Flynnn has joined |
| 18:59:06 | | raptor Quit () |
| 19:47:21 | | raptor has joined |
| 19:47:21 | | ChanServ sets mode +o |
| 20:26:15 | | destroyerimo_clo Quit (Ping timeout: 240 seconds) |
| 20:33:03 | fordcars | Oh my I had no idea Mozilla was the successor of Netscape |
| 20:34:32 | raptor | yes! |
| 20:48:22 | raptor | technically, 'mozilla' was the internal code name for the netscape navigator |
| 20:49:15 | raptor | then when microsoft basically kicked them out of the market, they opensourced their code base as 'mozilla' |
| 20:52:18 | fordcars | Yeah I've been reading about Mozilla and Netscape, it's like a love story |
| 21:23:11 | | Flynnn Quit (Quit: This computer has gone to sleep) |
| 21:34:29 | | Flynnn has joined |
| 23:51:40 | | Flynnn Quit (Quit: This computer has gone to sleep) |
| 23:54:24 | | Flynnn has joined |
