Swimfin131 Posted November 4, 2006 Share Posted November 4, 2006 (See title above) We need a place to have some flaming fun with the noobs PS : I Like the idea of "The Flaming Pit" :) Quote Link to comment Share on other sites More sharing options...
RobotChild Posted November 4, 2006 Share Posted November 4, 2006 I didn't realize it had left. Quote Link to comment Share on other sites More sharing options...
moonlit Posted November 4, 2006 Share Posted November 4, 2006 Ehh we kinda figured it wasn't really doing much just sitting there... was a good idea at the time, if you see what I mean. Quote Link to comment Share on other sites More sharing options...
RobotChild Posted November 4, 2006 Share Posted November 4, 2006 Ehh we kinda figured it wasn't really doing much just sitting there... was a good idea at the time, if you see what I mean.I sorta agree with that.The only funny thing in there was Panarchy! The rest was just spam-bots and such. Quote Link to comment Share on other sites More sharing options...
Kateweb Posted November 5, 2006 Share Posted November 5, 2006 you could open it up for other Short buss stuff from around the net , could still be fun. Quote Link to comment Share on other sites More sharing options...
SomeoneE1se Posted November 5, 2006 Share Posted November 5, 2006 thats not a bad idea you could put things like the kid trying to get someones steam User/pass and gets his stolen Quote Link to comment Share on other sites More sharing options...
Kateweb Posted November 5, 2006 Share Posted November 5, 2006 thats not a bad idea you could put things like the kid trying to get someones steam User/pass and gets his stolen why oh why can i see this as a skit? Quote Link to comment Share on other sites More sharing options...
VaKo Posted November 5, 2006 Share Posted November 5, 2006 I just hid it for the moment :twisted:. We needed to come up with a way of de-n00bifiying the forums and surprisingly enough, shouting threats about compact public transport at them proved highly ineffective (massive increase of locked threads, mainly due to arguments about tiny transport). So its back to the drawing boards. My main thoughts for a second attempt is once again education, ie instead of flaming n00bs, we either ignore them or try and educate them. If they don't listen, just stop replying. And thus, we come to the Short Buss replacement, Newbie Questions. All the hack tejh skool, myspace pwning hotmail craxzing you can take and more. Thoughts? As for a funnize forum, Everything Else should do nicely? Quote Link to comment Share on other sites More sharing options...
Sparda Posted November 5, 2006 Share Posted November 5, 2006 I just hid it for the moment :twisted:. We needed to come up with a way of de-n00bifiying the forums and surprisingly enough, shouting threats about compact public transport at them proved highly ineffective (massive increase of locked threads, mainly due to arguments about tiny transport). So its back to the drawing boards. My main thoughts for a second attempt is once again education, ie instead of flaming n00bs, we either ignore them or try and educate them. If they don't listen, just stop replying. And thus, we come to the Short Buss replacement, Newbie Questions. All the hack tejh skool, myspace pwning hotmail craxzing you can take and more. Thoughts? As for a funnize forum, Everything Else should do nicely? I vote for editing phpBB to force every new member to watch a 30 -60 second flash animation about what not to do here. It might confuse spam bots as well ;) Quote Link to comment Share on other sites More sharing options...
VaKo Posted November 5, 2006 Share Posted November 5, 2006 Make it work (flawlessly, 100% of the time) as a phpBB 2 plugin and we'll talk. Quote Link to comment Share on other sites More sharing options...
Sparda Posted November 5, 2006 Share Posted November 5, 2006 Well, in theory it's easy, just add a if statement to the top of every .php file. This php runs a quick MySQL quarry that checks if they have watch it or not and it's sorted :P Quote Link to comment Share on other sites More sharing options...
VaKo Posted November 5, 2006 Share Posted November 5, 2006 Plugin. Working. Make one? I'm mail you a Stella. Quote Link to comment Share on other sites More sharing options...
Sparda Posted November 5, 2006 Share Posted November 5, 2006 While it is simple, relitvly, I don't know enough php to do it my self. I'm looking at the code now, and it looks like it's going to be a if statement that sends a viewers browser to the flash page (using the header function) if it turns out that they haven't viewed it. Any one willing to do the actual flash animation? :/ Quote Link to comment Share on other sites More sharing options...
Sparda Posted November 6, 2006 Share Posted November 6, 2006 I actually have cooked up some of the php necessary for this to work :D This is all I have added: if ((!$userdata['viewedthing'] == 2) && ($userdata['session_logged_in'])) { $sql = "INSERT INTO " . USERS_TABLE . " (viewdthing) VALUES (2) WHERE user_id = " . $userdata['user_id']; if ( !$db->sql_query($sql, END_TRANSACTION) ) { message_die(GENERAL_ERROR, "Could not insert user_id for poll", "", __LINE__, __FILE__, $sql); } Header("Location: http://sparda.hopto.org/ok.xml"); } While that is only at line 262 in index.php, it will also need to be added to a couple of other php files to make it properly effective. A more pressing matter, however, is that disspite my (weak) attempt at inserting the value 2 in to the viewedthing field where the correct userid is, it doesn't work, any one have any cluies? :/ If you want to help just PM me on IRC (Username = Boris). Quote Link to comment Share on other sites More sharing options...
Guest Posted November 6, 2006 Share Posted November 6, 2006 I actually have cooked up some of the php necessary for this to work :DThis is all I have added: if ((!$userdata['viewedthing'] == 2) && ($userdata['session_logged_in'])) { $sql = "INSERT INTO " . USERS_TABLE . " (viewdthing) VALUES (2) WHERE user_id = " . $userdata['user_id']; if ( !$db->sql_query($sql, END_TRANSACTION) ) { message_die(GENERAL_ERROR, "Could not insert user_id for poll", "", __LINE__, __FILE__, $sql); } Header("Location: http://sparda.hopto.org/ok.xml"); } While that is only at line 262 in index.php, it will also need to be added to a couple of other php files to make it properly effective. A more pressing matter, however, is that disspite my (weak) attempt at inserting the value 2 in to the viewedthing field where the correct userid is, it doesn't work, any one have any cluies? :/ If you want to help just PM me on IRC (Username = Boris). The problem is probly with this line $sql = "INSERT INTO " . USERS_TABLE . " (viewdthing) VALUES (2) WHERE user_id = " . $userdata['user_id']; Is Users_TABLE a var? if it is it should be $sql = "INSERT INTO " .$USERS_TABLE . " (viewdthing) VALUES (2) WHERE user_id = " . $userdata['user_id']; if it isnt it should be $sql = "INSERT INTO USERS_TABLEÂ Â (viewdthing) VALUES (2) WHERE user_id = " . $userdata['user_id']; Quote Link to comment Share on other sites More sharing options...
Sparda Posted November 6, 2006 Share Posted November 6, 2006 I tried using this on the server mysql and it says the syntax is invalid :/ mysql> INSERT INTO phpbb_users (viwedthing) VALUES (2) WHERE 'user_id' = 2; ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE 'user_id' = 2' at line 1 I'v checked the spelling of fields and table names and they are correct, any one have any idea? Quote Link to comment Share on other sites More sharing options...
Guest Posted November 6, 2006 Share Posted November 6, 2006 try this mysql>INSERT INTO `phpbb_users` (`viwedthing`) VALUES (`2`) WHERE 'user_id' = 2; are you sure you want to insert though, i would of though you would use update mysql> UPDATE `phpbb_users` SET `viwedthing` = '2' WHERE `ID` =2; Quote Link to comment Share on other sites More sharing options...
Sparda Posted November 6, 2006 Share Posted November 6, 2006 That worked, and thank you, SWEET! The only thing this thing needs now is the actual flash animation ;) A a few bits here and there, but the majority of it is done. Quote Link to comment Share on other sites More sharing options...
cooper Posted November 6, 2006 Share Posted November 6, 2006 Could you do me a favor and see if this one would work? INSERT INTO phpbb_users (viwedthing) VALUES (2) WHERE user_id = 2; I have never, ever seen quoting in SQL except for the passing in of a string value. If MySQL complains about the above statement it would mean MySQL is even more broken than I thought... Quote Link to comment Share on other sites More sharing options...
Guest Posted November 6, 2006 Share Posted November 6, 2006 I have never, ever seen quoting in SQL except for the passing in of a string value. If MySQL complains about the above statement it would mean MySQL is even more broken than I thought... You dont actually use the quote, most sql servers require you to use the ` ( ` != ' ) around table names and table colums Quote Link to comment Share on other sites More sharing options...
Kateweb Posted November 6, 2006 Share Posted November 6, 2006 That worked, and thank you, SWEET!The only thing this thing needs now is the actual flash animation ;) A a few bits here and there, but the majority of it is done. give me a basic scrip as to what you want in it and I'll do it, tho some one will have to do the sound because I don't have a mic . Quote Link to comment Share on other sites More sharing options...
SomeoneE1se Posted November 6, 2006 Share Posted November 6, 2006 The crew needs to do the audio use http://www.hak5.org/wiki/forum_intro_script to edit the script.. I'd start it off but I'm too tired to make sense... I'll help in the morning Quote Link to comment Share on other sites More sharing options...
Kateweb Posted November 6, 2006 Share Posted November 6, 2006 ok so i wrote some of what i think should be thair , once we have the script done tho anyone who has ever done anamation know that you should do the audio first it saves some much hair pullling. Quote Link to comment Share on other sites More sharing options...
SomeoneE1se Posted November 6, 2006 Share Posted November 6, 2006 I fixed it up a bit and added to it but now I'm wondering if we should use flash or video and the script I've started would be acted by Darren and Wess... Guys if your reading this let me know if this is a problem Quote Link to comment Share on other sites More sharing options...
Sparda Posted November 6, 2006 Share Posted November 6, 2006 I like my method ;), the only thing that the flash needs to do is to except options from the html (you know, like flashobject.swf?options) and it'll be brill. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.