So, at the nearest future we will even try to transfer the entire our family-type clan at once from Syrtis to Ignis realms (on some forums has been rumored that this can be done with using next SQL command by NGD Studios (so, therefore our clannies, who work in database development industry, currently study SQL intensively!) and with a lot of premium Regnum Online currency, approx. 100k Ximerin).:
UPDATE clans SET clan_name = 'Ignis War Stalkers', clan_importance = 'VIP', realm_id = (SELECT id FROM realms WHERE realm_name = 'Ignis') WHERE realm_name = 'Syrtis War Stalkers';Help us to migrate in any way! Please donate us!
At the very beginning we will build friendship relations with all major Ignis clan.
UPDATED (2011/04/02): of course, it was an April Fools' Day joke! We really hope that everybody had a fun during whole this great day! ;-)
SYRTIS WAR STALKERS CLAN DOES NOT GO NEITHER RED NOR BLUE, BUT STAYS GREEN ALWAYS!
why Ignis, not Alsius?
ReplyDeletewhere did you get that SQL? can I know more about RO db structure? where?
ReplyDeleteI wish it were true
ReplyDeleteI think you have an error in your SQL.. Shouldn't it be:
ReplyDeleteUPDATE clans SET clan_name = 'Ignis War Stalkers', clan_importance = 'VIP', realm_id = (SELECT id FROM realms WHERE realm_name = 'Ignis') WHERE clan_name = 'Syrtis War Stalkers';
see... realm_name = xyz should be clan_name = xyz
Don't want you guys to disappear into nothingness :P
Also, see interesting "Syrtis War Stalkers clan goes red!" thread on "Fighters of Syrtis" forum and "Syrtis War Stalkers clan goes red!" thread on "Regnum Online" forum.
ReplyDelete> I think you have an error in your SQL ... realm_name = xyz should be clan_name = xyz ...
ReplyDeleteBravo +1! :-)
Hehe, see First April Joke dialog with one of clan member, 1st April 2011' also.
ReplyDeleteHello fellow Syrtis War Stalkers!
ReplyDeleteAs of recent I have managed to get back to the clan and look forward to seeing you all in RO!
- Jarci Ret
Jarci, we are always happy to see you with us, welcome!
ReplyDelete