> Rohan PServer Ask & Answer Thread <

[radekslu]

Have no idea what to do with it, cuz i don't know sql

when i put

SET @a = @i - 1

it repeats forever

DECLARE @a integer = 186475
declare @i integer 

select @i =(user_id) FROM RohanGame .dbo.TCharacter

way:
set @i = @a + 1
insert into RohanMall .dbo. Titem(type,attr,stack,rank,equip_level,equip_strength,equip_dexterity,equip_intelligence,user_id,date)
values(4390973,0x00,1,0,0,0,0,0,@i,getdate())

if (@i<186494) goto way;

now it loops only the seccond value, and it keeps on putting the same item. How to make it loop only once for each id?

[Danger Mouse]

If you want to add an item to every single user out there do this

insert into RohanMall.dbo. Titem(type,attr,stack,rank,equip_level,equip_strength,equip_dexterity,equip_intelligence,user_id,date)
SELECT 4390973,0x00,1,0,0,0,0,0,id,getdate() FROM RohanUser.dbo.TUser

[Penelope Pitstop]

Owned.

[novinhah]

Hey everyone. I want to make an own rohan private server....so, how do I go about doing that? Could anyone post a detailed guide? Thanks

[Milocinia]

If you need a detailed guide, making your own server isn't something you should be looking into unfortunately.

[novinhah]

Originally Posted by Milocinia

If you need a detailed guide, making your own server isn't something you should be looking into unfortunately.

Thanks for your useful input....

[Milocinia]

Like it or not it's the truth I'm afraid.

If you don't have your own in-house coders, any server you make will be hacked to within the end of its life.

[novinhah]

hey dude for real? I don't plan on having an OFFICIAL private server. just a server where I can test and try things out myself, ya know? That's all about it. I heard you could edit the host file in database to your own ip address, I dunno though. Any thoughts? if anyone could share something thanks

[Dr.Dr.SheldonLeeCooper]

Originally Posted by novinhah

hey dude for real? I don't plan on having an OFFICIAL private server. just a server where I can test and try things out myself, ya know? That's all about it. I heard you could edit the host file in database to your own ip address, I dunno though. Any thoughts? if anyone could share something thanks

Mhh...
If i use Google i can find some TuT about how to open a Loca Server.
Why are you such a lazy Guy ?

Download the English VMware and go have some Fun.
Or Download the Hero Files and make your own one.

[revenant2010]

Or Download the Hero Files and make your own one.

Like it how you make that sound easy :P

[Banana Bandit]

The downloading is easy.

It's the finding and setting up bits that is um.... challenging

[lrdtarrask]

Any max lvl 99 pserver online (english) ?
i found one, but indo. >__<

- No hero skills (1 and 2 )
- no pet fusion
- no hazy
- etc

[Dr.Dr.SheldonLeeCooper]

Hello Guys,

if you want, i can Post your Server on the first Page on this Thread.
Just send me some Infos about your Server

[whisker15]

Hello. I have a question. Way back in xor rohan there was a texture editing tool provided by someone,but i lost it. IS that legal to do and could someone share the tool if its not paid one? Thanks.

[Banana Bandit]

Texture editor is anything that can edit .dds files (i.e Photoshop with a .dds plugin).

what you need is:
1. Something that can crack a .gem/gel archive into its bits.
2. A way to convert textures from .gtx to .dds and back. The second thing you need to know is how when a .gtx file is a .dds file or a .tga file. YNK used .gtx to package both. Look around on the internet for information how to convert them back and forth.
3. Something that can compile all the files from (1) back into the GEB/GEL archive.

I even wrote up a tutorial on how to do (2) myself. But you gotta go find it, I'm not about to repeat myself.