Register - Login
Views: 99871695
 Main - Memberlist - Active users - Calendar - Wiki - IRC Chat - Online users
Ranks - Rules/FAQ - Stats - Latest Posts - Color Chart - Smilies 		05-04-22 07:14:28 PM
Jul - General Chat - Pre-thread post dump New poll - New thread - New reply
Pages: 1 2Next newer thread | Next older thread
Xkeeper

Level: 263


Posts: 3135/25353
EXP: 297182377
For next: 1778076

Since: 07-03-07

Pronouns: they/them/????????

Since last post: 4 days
Last activity: 7 hours
Posted on 09-27-07 03:17:59 AM Link | Quote
Daily Cycle II ~ 3135
Originally posted by Silly Shadic
I'm gonna have to agree with the "What the fuck is this?" comments.

So... I can fuck things up by replying to a thread that doesn't exist?
Yes, which is where these posts were from.


EXPLANATION
You can post replies in threads that don't exist -- old Acmlmboard bug (was fixed in a later version that I don't have... oops) ... needless to say all posts I find like that will get dumped back here.


____________________
(If you need to talk to me on AIM, PM me first, since I'll be off my regular account for at least a few hours, if not a few days)
Stats
Level 59
EXP: 48575/95582
Time: 85 days
Ranked at #1
 

 
Kles

Level: 87


Posts: 810/1947
EXP: 6312793
For next: 79981

Since: 07-23-07


Since last post: 79 days
Last activity: 7 hours
Posted on 09-27-07 04:43:46 AM Link | Quote
Head -> wall

____________________
( ﾟ³ﾟ)三№♥
chungy
Member
Level: 31


Posts: 64/174
EXP: 168467
For next: 16896

Since: 08-04-07


Since last post: 14.1 years
Last activity: 13.9 years
Posted on 09-27-07 07:18:24 AM Link | Quote
Originally posted by Biospark
You can post replies in threads that don't exist -- old Acmlmboard bug (was fixed in a later version that I don't have... oops) ... needless to say all posts I find like that will get dumped back here.

switch to InnoDB :p
Xkeeper

Level: 263


Posts: 3137/25353
EXP: 297182377
For next: 1778076

Since: 07-03-07

Pronouns: they/them/????????

Since last post: 4 days
Last activity: 7 hours
Posted on 09-27-07 07:23:22 AM Link | Quote
Daily Cycle II ~ 3137
Database type has nothing to do with it.

____________________
(If you need to talk to me on AIM, PM me first, since I'll be off my regular account for at least a few hours, if not a few days)
Stats
Level 59
EXP: 51747/95582
Time: 85 days
Ranked at #1
 

(Download this)
 
chungy
Member
Level: 31


Posts: 65/174
EXP: 168467
For next: 16896

Since: 08-04-07


Since last post: 14.1 years
Last activity: 13.9 years
Posted on 09-27-07 07:28:08 AM Link | Quote
If you set it up properly, the database engine itself could block invalid data. Such as posting to invalid threads or forums.
Ninji

Birdo
Why did my user title say I'm a toaster anyway
Level: 88


Posts: 86/2014
EXP: 6639502
For next: 11162

Since: 07-26-07

Pronouns: he/him or they/them
From: Glasgow, Scotland

Since last post: 115 days
Last activity: 7 days
Posted on 09-27-07 07:43:19 AM; last edit by Treeki on 09-27-07 07:44 AM Link | Quote
At the time of writing this post, I had..
Posts: 86 ~ Level: 12 ~ Exp: 6318

Originally posted by chungy
If you set it up properly, the database engine itself could block invalid data. Such as posting to invalid threads or forums.

Why go through so much trouble?

function thread_exists($tid) {
$te_check = mysql_query('SELECT topicid FROM topics WHERE topicid = '.$tid);
if mysql_num_rows($te_check) > 0 return true; else return false;
}


____________________


NSMB Editor 2.2
making awesome SMB remakes since 16/7/07
what? you want a new version already? are you joking?
The "Official" NSMB Hacking Links Page
Nitro Explorer: universal NDS ROM file extracter/inserter
chungy
Member
Level: 31


Posts: 66/174
EXP: 168467
For next: 16896

Since: 08-04-07


Since last post: 14.1 years
Last activity: 13.9 years
Posted on 09-27-07 09:15:19 AM Link | Quote
Because it's generally easier and faster to do it database-side.
Ninji

Birdo
Why did my user title say I'm a toaster anyway
Level: 88


Posts: 87/2014
EXP: 6639502
For next: 11162

Since: 07-26-07

Pronouns: he/him or they/them
From: Glasgow, Scotland

Since last post: 115 days
Last activity: 7 days
Posted on 09-27-07 10:11:57 AM; last edit by Treeki on 09-27-07 10:12 AM Link | Quote
At the time of writing this post, I had..
Posts: 87 ~ Level: 12 ~ Exp: 6434

Originally posted by chungy
Because it's generally easier and faster to do it database-side.

Unless the DB returns an error, you would just get it appearing to the user that their post has worked, but with no post actually appearing.
Also: Depending on how the software is coded, this could be used to get "fake" post counts. I'm not a board expert, but I've coded part of one before.
Here's the code from TCMS3 for posting, as an example:
$trash = mysql_query('INSERT INTO '.$sql_tpfx.'posts VALUES(0, '.mysql_insert_id().
', \''.$username.'\', '.$userid.', NOW(), \''.iprotect($_POST['text']).'\', '.
$newpc.')');
$trash = mysql_query('UPDATE '.$sql_tpfx.'forums SET fposts = fposts + 1, '.
'WHERE fid = '.$forum_id);
$trash = mysql_query('UPDATE '.$sql_tpfx.'users SET postcount = postcount + 1 '.
'WHERE userid = '.$userid);

Let's assume that every query is run.
The first is run and tries to make the post, but fails due to the database limits. (This was from the new topic code, so ignore the mysql_insert_id(), but you get the idea.)
The second runs and increments the forum post count.
The third runs and increments the user's post count. Yay, ghost posts!

____________________


NSMB Editor 2.2
making awesome SMB remakes since 16/7/07
what? you want a new version already? are you joking?
The "Official" NSMB Hacking Links Page
Nitro Explorer: universal NDS ROM file extracter/inserter
chungy
Member
Level: 31


Posts: 67/174
EXP: 168467
For next: 16896

Since: 08-04-07


Since last post: 14.1 years
Last activity: 13.9 years
Posted on 09-27-07 05:26:26 PM Link | Quote
That's stupid; of course there will be an error.
Pages: 1 2Next newer thread | Next older thread
Jul - General Chat - Pre-thread post dump New poll - New thread - New reply


Rusted Logic

Acmlmboard - commit 47be4dc [2021-08-23]
©2000-2022 Acmlm, Xkeeper, Kaito Sinclaire, et al.

29 database queries, 4 query cache hits.
Query execution time: 0.077431 seconds
Script execution time: 0.021060 seconds
Total render time: 0.098492 seconds