Dedimania forum

Feel free to express yourself on your favorite dedicated related tool.

You are not logged in.

#1 2009-02-12 00:32:11

TX-Slig
slig
Fast author / Dedimania maintainer
From: Traxicoland
Registered: 2006-11-23
Posts: 878
Website

Other records problems

Give here info about other problems about records.

Give as much detail as possible!  Just saying "records or my maps have disappeared" or such thing is just useless!!!

Offline

#2 2009-03-04 09:25:37

??????????.?i??õ
aswam
New member
Registered: 2009-03-04
Posts: 2

Re: Other records problems

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

Offline

#3 2009-03-05 00:59:39

TX-Slig
slig
Fast author / Dedimania maintainer
From: Traxicoland
Registered: 2006-11-23
Posts: 878
Website

Re: Other records problems

=xTs=ThugLame wrote:

identical cptimes

That is already checked.

The no cp times case can't be done easily actually because of compatibility with old game scripts.

Offline

#4 2009-03-26 11:54:18

[UF1R]`MAd
kdemirci
New member
Registered: 2009-01-04
Posts: 2

Re: Other records problems

how can i reset/remove all records for tracks ?

Offline

#5 2009-03-26 17:43:35

TX-Slig
slig
Fast author / Dedimania maintainer
From: Traxicoland
Registered: 2006-11-23
Posts: 878
Website

Re: Other records problems

You can't : it's the idea of global records !  For your own records that you can erase when you want, use local records. wink

Btw if you mean wrong records then post about it on the other topic

Offline

#6 2009-03-26 19:14:32

[UF1R]`MAd
kdemirci
New member
Registered: 2009-01-04
Posts: 2

Re: Other records problems

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

Offline

#7 2009-04-13 06:44:56

BR-Mort
_bb_mort
Member
Registered: 2009-02-20
Posts: 14

Re: Other records problems

Hi Slig,

I have been using this url with a wildcard to get a quick view of all my servers which has been wroking great for the last several months
http://dedimania.net/tmstats/?do=stat&a … ow=PLAYERS

But it appears to have stopped working recently. I can still see the servers using the full name without the wildcard though
http://dedimania.net/tmstats/?do=stat&a … ow=PLAYERS
http://dedimania.net/tmstats/?do=stat&a … ow=PLAYERS
etc.

Is this a recent change to the dedimania web lookup?

Thanks
Mort.

Offline

#8 2009-04-13 06:52:49

BR-Mort
_bb_mort
Member
Registered: 2009-02-20
Posts: 14

Re: Other records problems

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.

Offline

#9 2009-04-14 18:10:11

TX-Slig
slig
Fast author / Dedimania maintainer
From: Traxicoland
Registered: 2006-11-23
Posts: 878
Website

Re: Other records problems

Yes, it's new. Xymph is working actively to cleanup records those days, so he uses tmstats a lot, and after he noticed some kind of strange slow query results, i found that it was because of sql 'LIKE' with wildcards ('_' and '%' are natural mysql wildcards, so  those chars in names could slowdown). The better way to fix the problem was to use 'LIKE' only when wanted, so...  wink

Offline

#10 2009-04-16 15:40:53

ÇavalierDeVache
cavalierdevache
New member
Registered: 2007-01-12
Posts: 3

Re: Other records problems

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 sad , 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)

Offline

#11 2009-04-16 19:24:49

GFC?W1lla.nl
dccw1lla
New member
From: Venray
Registered: 2008-11-23
Posts: 8
Website

Re: Other records problems

Having same problems....

Shows no dedirecs and timeattack recs and round records are messed up....

+1

Offline

#12 2009-04-17 03:09:24

TX-Slig
slig
Fast author / Dedimania maintainer
From: Traxicoland
Registered: 2006-11-23
Posts: 878
Website

Re: Other records problems

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   sad  . 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).

Offline

#13 2009-06-24 20:54:13

??????????
r4isis_on_wr_hunting
New member
Registered: 2009-06-23
Posts: 2

Re: Other records problems

hey slig...
for first: sry 4 my english ;P
..i hope i am on the right topic :X
ok..my problem is that i drove a first dedi rec on Flow ...it was a "00:36:330" on "2009-05-31 21:58:57" (copied from rcp->aseco db)
...so i got 1st rec and 1st dedi....but one day later the dedi rec was deleted...
maybe u think that it was cheated or something like that....but it was normal way...just using of multilap...
if u want i send u the replay of it wink ....but i wanna get my dedi rec back xD
(i know that this rec is some weeks ago, but i didnt know that any kind of forum like this exist =P)

greetz raisis wink

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

/edit: why my nik says NoS》 ैुÇңξΛτξЯ´ू《 ??? o,O ...i changed my name hmm
here it is right: "Logout ᅔяλוॆѕוॆѕᅕ*aKa ÇңξΛτξЯ*"

Last edited by NoS》 ैुÇңξΛτξЯ´ू《 (2009-06-24 20:55:50)

Offline

#14 2009-06-24 22:31:49

Xymph
xymph
Moderator
Registered: 2009-05-26
Posts: 1969
Website

Re: Other records problems

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 wink ), but Flow is an obvious exception.

Offline

#15 2009-06-30 10:48:26

BR-Mort
_bb_mort
Member
Registered: 2009-02-20
Posts: 14

Re: Other records problems

Greetings,

I am trying to match up when a dedi record was made to the copy of the replay file on my server. My time zone is GMT+11 so I'm assuming the reason none of my replay times match the dedi record times is due to different time zones.

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

Thanks
Mort.

Offline

#16 2009-06-30 12:52:00

Xymph
xymph
Moderator
Registered: 2009-05-26
Posts: 1969
Website

Re: Other records problems

BR-Mort wrote:

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

Yes, GMT (+0).

Offline

#17 2009-11-19 23:29:45

«Oscarian»
oscarian
New member
Registered: 2008-04-17
Posts: 1

Re: Other records problems

Xymph wrote:

Exploiting the multilap start on that track is, in a way, cheating too. Just don't do it, such times will get deleted again.

I disagree.  It's poor track design.  Using the multi to get a faster time is no different to using a cut.

It's up to the track author to make the track so it can't be exploited this way.

-Oscarian

Offline

#18 2009-12-05 05:32:15

CCS»Casper
davidnaude123
New member
Registered: 2009-12-03
Posts: 1

Re: Other records problems

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

Offline

#19 2009-12-05 12:15:23

Xymph
xymph
Moderator
Registered: 2009-05-26
Posts: 1969
Website

Re: Other records problems

CCS»Casper wrote:

any advice on how to fix this?

Without details, nothing can be done. roll

Offline

#20 2009-12-19 21:54:16

ku!øut |? exp.
as96
New member
Registered: 2009-12-19
Posts: 7

Re: Other records problems

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... sad  sad  sad

Offline

#21 2009-12-19 23:11:51

Xymph
xymph
Moderator
Registered: 2009-05-26
Posts: 1969
Website

Re: Other records problems

Read my previous post. roll

Offline

#22 2009-12-20 13:24:12

ku!øut |? exp.
as96
New member
Registered: 2009-12-19
Posts: 7

Re: Other records problems

Xymph wrote:

Read my previous post. roll

What details are necessary to you? I cannot understand

PS: My login: as96

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

Offline

#23 2009-12-20 13:44:57

Xymph
xymph
Moderator
Registered: 2009-05-26
Posts: 1969
Website

Re: Other records problems

eXplø२eॆ२' wrote:

What details are necessary to you?

The server login, the controller you're using, any Dedimania errors in its log, and if the server isn't blocked also the UIDs of the tracks where you think records go missing... lots of details.

Offline

#24 2009-12-20 17:25:22

ku!øut |? exp.
as96
New member
Registered: 2009-12-19
Posts: 7

Re: Other records problems

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

Offline

#25 2009-12-20 19:58:58

Xymph
xymph
Moderator
Registered: 2009-05-26
Posts: 1969
Website

Re: Other records problems

You make no sense and don't provide any of the requested details. I guess you're not really interested in help after all. roll

Offline

#26 2009-12-20 21:59:30

TX-Slig
slig
Fast author / Dedimania maintainer
From: Traxicoland
Registered: 2006-11-23
Posts: 878
Website

Re: Other records problems

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

Offline

Board footer

Powered by PunBB
© Copyright 2002–2005 Rickard Andersson