INSERT INTO {$table_prefix}_players (id, name, v1, p1, r1) VALUES ('$id', '$name', '$villages', '$points', '$rank')
ON DUPLICATE KEY UPDATE p7=p6 , p6=p5 , p5=p4 , p4=p3 , p3=p2 , p2=p1 , p1='$points' ,
v7=v6 , v6=v5 , v5=v4 , v4=v3 , v3=v2 , v2=v1 , v1='$villages' ,
r7=r6 , r6=r5 , r5=r4 , r4=r3 , r3=r2 , r2=r1 , r1='$rank'"
Hi guys, I've been using this SQL query for a long time and it has worked perfectly. Now I'm moving to GQL and I have no idea on how to make this query. I've searched all the GQL docs but I can't find anything.
Can you help me? Thanks in advance