Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rohan
You last visited: Today at 07:24

  • Please register to post and access all features, it's quick, easy and FREE!

 

> Rohan PServer Ask & Answer Thread <

Reply
 
Old   #166
 
elite*gold: 0
Join Date: May 2013
Posts: 362
Received Thanks: 76
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?



radekslu is offline  
Old   #167
 
elite*gold: 0
Join Date: Jul 2014
Posts: 120
Received Thanks: 15
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


Danger Mouse is offline  
Old   #168
 
elite*gold: 0
Join Date: Jul 2014
Posts: 305
Received Thanks: 49
Owned.
Penelope Pitstop is offline  
Old   #169
 
elite*gold: 0
Join Date: Oct 2014
Posts: 3
Received Thanks: 0
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


novinhah is offline  
Old   #170
 
elite*gold: 0
Join Date: Jul 2014
Posts: 236
Received Thanks: 38
If you need a detailed guide, making your own server isn't something you should be looking into unfortunately.
Milocinia is offline  
Old   #171
 
elite*gold: 0
Join Date: Oct 2014
Posts: 3
Received Thanks: 0
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....
novinhah is offline  
Old   #172
 
elite*gold: 0
Join Date: Jul 2014
Posts: 236
Received Thanks: 38
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.
Milocinia is offline  
Old   #173
 
elite*gold: 0
Join Date: Oct 2014
Posts: 3
Received Thanks: 0
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
novinhah is offline  
Old   #174

 
elite*gold: 33
The Black Market: 100/0/2
Join Date: Jan 2011
Posts: 2,693
Received Thanks: 454
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.
Dr.Dr.SheldonLeeCooper is offline  
Old   #175
 
elite*gold: 0
Join Date: Dec 2011
Posts: 47
Received Thanks: 4
Quote:
Or Download the Hero Files and make your own one.
Like it how you make that sound easy :P
revenant2010 is offline  
Old   #176
 
elite*gold: 0
Join Date: Jul 2014
Posts: 278
Received Thanks: 50
The downloading is easy.

It's the finding and setting up bits that is um.... challenging
Banana Bandit is offline  
Old   #177
 
elite*gold: 0
Join Date: Feb 2010
Posts: 102
Received Thanks: 8
Any max lvl 99 pserver online (english) ?
i found one, but indo. >__<

- No hero skills (1 and 2 )
- no pet fusion
- no hazy
- etc
lrdtarrask is offline  
Old   #178

 
elite*gold: 33
The Black Market: 100/0/2
Join Date: Jan 2011
Posts: 2,693
Received Thanks: 454
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
Dr.Dr.SheldonLeeCooper is offline  
Old   #179
 
elite*gold: 0
Join Date: Nov 2014
Posts: 33
Received Thanks: 3
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.
whisker15 is offline  
Old   #180
 
elite*gold: 0
Join Date: Jul 2014
Posts: 278
Received Thanks: 50
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.


Banana Bandit is offline  
Reply



« Previous Thread | Next Thread »

Similar Threads
Allgemeiner Thread für Rohan | Main Rohan Thread
Deutsch Da ein bisschen Ordnung von Nöten ist,erstelle ich dieses Thema. Hier könnt ihr über alles reden,was mit Rohan zu tun hat ohne das ihr...
0 Replies - Rohan



All times are GMT +1. The time now is 07:24.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2017 elitepvpers All Rights Reserved.