Register | Login | |||||
Main
| Memberlist
| Active users
| ACS
| Commons
| Calendar
| Online users Ranks | FAQ | Color Chart | Photo album | IRC Chat |
| |
Acmlm's Board - I2 Archive - - Posts by CRZ |
User | Post | ||
CRZ Newcomer Level: 6 Posts: 1/9 EXP: 658 For next: 249 Since: 03-17-04 From: Twin Cities Since last post: 127 days Last activity: 6 days |
| ||
I wouldn't have felt right sneaking in and taking 300 since I never bothered to register before...although I did sit around for a while before pressing the button on the register page. But 299 is fine because mine makes easy rhyming line and it smells like pine and maybe I'll never post agine fine |
|||
CRZ Newcomer Level: 6 Posts: 2/9 EXP: 658 For next: 249 Since: 03-17-04 From: Twin Cities Since last post: 127 days Last activity: 6 days |
| ||
We thought about implementing some kind of convert-to-RSS process/script for The W a while back but never got around to it. I'm still interested enough in the idea to ask if the feed links are getting a lot of use here, or if it's just turned out to be an interesting challenge that got done, and is extremely clever, but no one actually uses - which is usually the case with a lot of the things I seem to end up doing. (edited by CRZ on 10-27-04 04:11 AM) |
|||
CRZ Newcomer Level: 6 Posts: 3/9 EXP: 658 For next: 249 Since: 03-17-04 From: Twin Cities Since last post: 127 days Last activity: 6 days |
| ||
Originally posted by XkeeperI think that was covered in the second post in this thread, actually. |
|||
CRZ Newcomer Level: 6 Posts: 4/9 EXP: 658 For next: 249 Since: 03-17-04 From: Twin Cities Since last post: 127 days Last activity: 6 days |
| ||
> AcmlmBoard 1.A2 (2004-04-05) Oh, man, this was ready LAST YEAR?!? ;-) |
|||
CRZ Newcomer Level: 6 Posts: 5/9 EXP: 658 For next: 249 Since: 03-17-04 From: Twin Cities Since last post: 127 days Last activity: 6 days |
| ||
Originally posted by danHeed these quoted words. In addition... Not only are you pulling arrays out of a null (I think you must have meant $query instead of $threadf in your "while" line), you are repeatedly referencing $thread[something] when I can only assume you probably mean $threadr[something]. You'd probably also want to change that "$thread=blahblahblah" line to "$thread.=blahblahblah" (notice the dot) or you'll constantly overwrite your single row of output fifty times before your code finally gets around to printing it to screen. Balancing your <td> and </td> tags wouldn't hurt either In short...what a mess (edited by CRZ on 05-31-05 08:12 AM) |
|||
CRZ Newcomer Level: 6 Posts: 6/9 EXP: 658 For next: 249 Since: 03-17-04 From: Twin Cities Since last post: 127 days Last activity: 6 days |
| ||
You should probably update your page with the code on it... Try the quotes here... - $query="mysql_query(SELECT threads.id, threads.title, threads.lastpostdate, users.name as username, users.id as userid FROM threads,users WHERE users.id = threads.lastposter ORDER BY threads.lastpostdate DESC LIMIT 50) or die(mysql_error())"; + $threadf=mysql_query("SELECT threads.id, threads.title, threads.lastpostdate, users.name as username, users.id as userid FROM threads,users WHERE users.id = threads.lastposter ORDER BY threads.lastpostdate DESC LIMIT 50 or die(mysql_error())"); Sorry for all the edits - stupid parentheses... (edited by CRZ on 05-31-05 08:22 AM) (edited by CRZ on 05-31-05 08:23 AM) (edited by CRZ on 05-31-05 08:24 AM) (edited by CRZ on 05-31-05 08:25 AM) |
|||
CRZ Newcomer Level: 6 Posts: 7/9 EXP: 658 For next: 249 Since: 03-17-04 From: Twin Cities Since last post: 127 days Last activity: 6 days |
| ||
Originally posted by TheGreatWhiteDopeYou still have mismatched parens... - $query=mysql_query("SELECT thread.id, thread.title, thread.lastpostdate, user.name as username, user.id as userid FROM thread,users WHERE user.id = thread.lastposter ORDER BY thread.lastpostdate DESC LIMIT 50) or die(mysql_error()"); + $query=mysql_query("SELECT thread.id, thread.title, thread.lastpostdate, user.name as username, user.id as userid FROM thread,users WHERE user.id = thread.lastposter ORDER BY thread.lastpostdate DESC LIMIT 50 or die(mysql_error())"); |
|||
CRZ Newcomer Level: 6 Posts: 8/9 EXP: 658 For next: 249 Since: 03-17-04 From: Twin Cities Since last post: 127 days Last activity: 6 days |
| ||
Originally posted by TheGreatWhiteDopeOne of these times I'll give you good advice. You'll see. I moved the quotes again and also put some quotes around your die message. Try this out: - $query=mysql_query("SELECT thread.id, thread.title, thread.lastpostdate, user.name as username, user.id as userid FROM thread,users WHERE user.id = thread.lastposter ORDER BY thread.lastpostdate DESC LIMIT 50 or die(mysql_error())"); + $query=mysql_query("SELECT thread.id, thread.title, thread.lastpostdate, user.name as username, user.id as userid FROM thread,users WHERE user.id = thread.lastposter ORDER BY thread.lastpostdate DESC LIMIT 50") or die("mysql_error()"); FWIW, I did something like this on my own board a long time ago (the-w.com) but I never included the die message in my code... so maybe that's why I got confused earlier. I know this DOES work, though, since it's been on my board forever... |
|||
CRZ Newcomer Level: 6 Posts: 9/9 EXP: 658 For next: 249 Since: 03-17-04 From: Twin Cities Since last post: 127 days Last activity: 6 days |
| ||
There IS no action. You have a conditional and no conditions. Why use if($id=="$user[id]") - and you shouldn't need those quotes anyway - when you have no $user by the time you've gone through the Userlist thing. I recommend something like... #-- Userlist --# + if (!$action) { // or you can even be really anal-retentive and use if ($action!="ban") { while($user=mysql_fetch_array($userquery)){ ... + } } #-- End --# ... - $ban="<FORM ACTION='admin\userban.php?id=$user[id]' METHOD='POST'><INPUT TYPE=submit VALUE='Ban User'></FORM>"; + $ban="<FORM ACTION='admin/userban.php?action=ban&id=".$user[id]."' METHOD='POST'><INPUT TYPE=submit VALUE='Ban User'></FORM>"; ... - if($id=="$user[id]") { - mysql_query("UPDATE users SET powerlevel=-1 WHERE id=$user[id]"); + if($action=="ban") { + mysql_query("UPDATE users SET powerlevel=-1 WHERE id=$id"); } Now, will this actually work? I dunno, I'm too lazy to go test it myself and it seems to me like you're just reinventing the wheel anyway. Hey, but more power to ya. Get it, MORE POWER, and you're setting the powerlevel to -1, ha ha ha, oh well. PS Don't AIM me later, thanks bye EDIT: Oops, forgot that the HTML would actually look like HTML - hopefully that's fixed - sorry about that (edited by CRZ on 06-27-05 07:01 PM) |
Acmlm's Board - I2 Archive - - Posts by CRZ |