> Rohan PServer Ask & Answer Thread <

Page 12 of 19 « First 21011 12 1314 Last »
10/05/2014 13:49 radekslu#166
Have no idea what to do with it, cuz i don't know sql

when i put
Code:
SET @a = @i - 1
it repeats forever


Code:
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?
10/05/2014 15:30 Danger Mouse#167
If you want to add an item to every single user out there do this
Code:
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
10/06/2014 07:54 Penelope Pitstop#168
Owned.
10/09/2014 01:22 novinhah#169
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
10/09/2014 01:36 Milocinia#170
If you need a detailed guide, making your own server isn't something you should be looking into unfortunately.
10/09/2014 01:42 novinhah#171
Quote:
Originally Posted by Milocinia View Post
If you need a detailed guide, making your own server isn't something you should be looking into unfortunately.
Thanks for your useful input....
10/09/2014 01:45 Milocinia#172
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.
10/09/2014 02:06 novinhah#173
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
10/09/2014 10:15 Dr.Dr.SheldonLeeCooper#174
Quote:
Originally Posted by novinhah View Post
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.
10/09/2014 16:38 revenant2010#175
Quote:
Or Download the Hero Files and make your own one.
Like it how you make that sound easy :P
10/09/2014 18:55 Banana Bandit#176
The downloading is easy.

It's the finding and setting up bits that is um.... challenging ;)
11/10/2014 17:10 lrdtarrask#177
Any max lvl 99 pserver online (english) ?
i found one, but indo. >__<

- No hero skills (1 and 2 )
- no pet fusion
- no hazy
- etc
11/13/2014 17:49 Dr.Dr.SheldonLeeCooper#178
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 :)
11/14/2014 23:02 whisker15#179
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.
11/14/2014 23:20 Banana Bandit#180
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.
Page 12 of 19 « First 21011 12 1314 Last »