Dedimania forum

Hi.
As they are many cheated records (ex. Japan Style,  Moving Power...) I thought about an easy way to track them and prevent them from being inserted. A hacked rec has either no cptimes or identical cptimes. So if there are at least to Cp times that are equal, the time was cheated. therefore, a simple SQL trigger after UPDATE and INSERT should check if 2 cptimes (at least) are equal. and if so, delete the inserted record (update in SQL is actually a delete and an insert so this works in all cases)
If you need help with it, i can write a sample trigger to show you.
feel free to contact me darkvad[at]gmail[dot]com

how can i reset/remove all records for tracks ?

thanks for answer slig, i moved my server to new pc and now all local records seems wrong thats why i wanna reset all records

Ah, never mind. I just noticed a "wildcards" option on the page now, and adding &Wildcards=on to the url fixes it up beautifully.

Mort.

Hi Slig
I'm not sure how this happened today, but I ended up with a #1 record on a map that I already had a #3 record on, and the #1 record is slower than the #3. Maybe a multilap in time attack mode problem since this map would send false incoherence bans in TMU? I dunno yet, I'll look at my server more closely.

Map: Evening Drive by pjw (old tmsx version)
http://sunrise.tm-exchange.com/main.asp … 33316#auto

http://dedimania.com/tmstats/?do=stat&a … ow=RECORDS

Edit: It is doing this on all maps on both my servers now, for some reason the existing records are not being retrieved from dedimania , It was working fine earlier. I will just unload the dedimania plugins for now I guess.

Last edited by ÇavalierDeVache (2009-04-16 17:55:12)

My apologies, it was not a bad script change, but an added column in one of the dedimania table, which by some side effect made some part of the script fail to work correctly     . And of course just after the table change i was too busy at my job, and so I noticed the problem very later.  :?

After having fixed the script, I had to remove all records made between ~ 15:00pm and 21:00pm (CET). The other solution would have been to come back to the database backup of 5:10am, which was worse. Sorry again, especially to those who made some good time while it was not working.

It should be ok now (i mean since about 21:15 cet).

NoS》 ैुÇңξΛτξЯ´ू《 wrote:

P.S: dont tell me that i should drive it again xD...cause to get it...cost me more than 2 houres :S

Exploiting the multilap start on that track is, in a way, cheating too. Just don't do it, such times will get deleted again.
Multilap starts on non-lapping tracks are a real pain for record consistency, and I can't do much about them on most such tracks (even though I'd like to ), but Flow is an obvious exception.

BR-Mort wrote:

What time zone are the dedi records displayed in on the web lookup (UTC\GMT?)

Yes, GMT (+0).

Hi, I have a problem where I get a dedi legitamately abd when I come back to the track afterwards my local is there but my dedi is not? any advice on how to fix this? Thanks

Hi, at me the same problem, all time at me vanish dedi records, I do not know why, what to me to do? local remains and dedi is not present...    

Xymph wrote:

Read my previous post.

What details are necessary to you? I cannot understand

PS: My login: as96

Last edited by eXplø२eॆ२' (2009-12-20 13:24:38)

Dedi vanish on all servers, everywhere, always, already a floor of year

he added his login in his previous post :  as96   (which is banned in dedimania database)