p server issues and resolve

Page 16 of 23

07/18/2011 15:21 serafincro#226

Age of Rappelz rar contains unnofifcal launcher file, recognized as Trojan...

so beware on your own risk.

07/18/2011 15:43 mizhe#227

Still says cannot connect to login server

07/19/2011 01:26 bubbakid#228

Quote:

Originally Posted by Doc Nobody

I just wanted to first say thank you to all devs that have contributed to this project.

I noticed a few people were looking to adjust taming rates, and it has been mentioned how to blanket adjust all rates, but for those who wanted to change the rates by tiers I provide my query below.

This is my first SQL query so if it could be done better, faster, cleaner, whatever... I make no claims to know anything about this stuff, only that I have been reading the forums and thought I'd contribute. If this is the wrong spot to place this, you can put it wherever. --Enjoy!

Spoiler

--Tier 6
UPDATE [Arcadia].[dbo].[MonsterResource]
SET [taming_percentage]=0.5000 --<<<<<<<< Adjust this to change tame success%
WHERE model LIKE '%dragon%'
GO

--Tier 5
UPDATE [Arcadia].[dbo].[MonsterResource]
SET [taming_percentage]=0.6700 --<<<<<<<< Adjust this to change tame success%
WHERE model LIKE '%jini%' OR model LIKE '%kerberos%'
GO

--Tier 4
UPDATE [Arcadia].[dbo].[MonsterResource]
SET [taming_percentage]=0.7500 --<<<<<<<< Adjust this to change tame success%
WHERE model LIKE '%angel%' OR model LIKE '%horseman%' OR model LIKE '%tafari%' or model LIKE '%eimus%'
GO

--Tier 3
UPDATE [Arcadia].[dbo].[MonsterResource]
SET [taming_percentage]=0.8200 --<<<<<<<< Adjust this to change tame success%
WHERE model LIKE '%hawkman%' OR model LIKE '%salamander%' OR model LIKE '%windsong%' OR model LIKE '%unicorn%'
GO

--Tier 2
UPDATE [Arcadia].[dbo].[MonsterResource]
SET [taming_percentage]=0.9000 --<<<<<<<< Adjust this to change tame success%
WHERE model LIKE '%pixi%' OR model LIKE '%seiren%' OR model LIKE '%skelfighter%' OR model LIKE '%orc%' OR model LIKE '%wolf%' OR model LIKE '%octopus%'
GO

--Tier 1
UPDATE [Arcadia].[dbo].[MonsterResource]
SET [taming_percentage]=1.0000 --<<<<<<<< Adjust this to change tame success%
WHERE model LIKE '%chichen%' OR model LIKE 'beast_hen%' or model LIKE '%turtle%' OR model LIKE '%panthera%'
GO

--View Results
SELECT model, taming_id, taming_percentage, taming_exp_mod
FROM MonsterResource
WHERE (taming_percentage > 0.0000)
ORDER BY taming_percentage, taming_id

hey just letting you know for the tier five "Kerberos" does not work for cerberus but i changed it to the correct name which is "Keberos" and it works great thanks ^^

and do you happen to know the name for Nightmares? or is that also Unicorn?

07/19/2011 06:02 Doc Nobody#229

Quote:

Originally Posted by bubbakid

hey just letting you know for the tier five "Kerberos" does not work for cerberus but i changed it to the correct name which is "Keberos" and it works great thanks ^^

and do you happen to know the name for Nightmares? or is that also Unicorn?

Thanks for the info, I edited the script to remove the spelling error.

As for Nightmare they are all beast_unicorn01_??? model in the DB, so the '%unicorn%" grabs them in my script.

07/19/2011 06:44 bubbakid#230

Quote:

Originally Posted by Doc Nobody

Thanks for the info, I edited the script to remove the spelling error.

As for Nightmare they are all beast_unicorn01_??? model in the DB, so the '%unicorn%" grabs them in my script.

hmm i asked because all my nightmares are failing.......my unicorns tame but nightmares fail for some reason....... i looked for them in the DB but couldnt fidn em....maybe im overlooking something.....

07/19/2011 06:59 RoflcopterGoesSoiSoiSoi#231

Do you have all the tame IDs set up properly? I haven't really messed with uni/NM taming as they're not in my drop tables (...as far as I know), but everything should be tamable with the latest repack (1.1). I don't use the repack out-of-box, so I can't give a tested and true answer. Sorry.

07/19/2011 07:38 bubbakid#232

oh i see..... that's probably why, I'm using Wisp66's beta 1.1 release [Only registered and activated users can see links. Click Here To Register...]

07/19/2011 07:44 RoflcopterGoesSoiSoiSoi#233

Woops, I made a mistake there. I meant the 1.1 repack.

07/19/2011 07:49 bubbakid#234

Quote:

Originally Posted by RoflcopterGoesSoiSoiSoi

Woops, I made a mistake there. I meant the 1.1 repack.

oh lol,well yeah im using that and still cant tame Nightmares lol everything else is fine pet wise[cept two of the If's passive the M atk/Def passive(which i dun really care for lol since im more of a genie person)]
and ima stop complaining now since my server is only for me,my bro's and friends. but a solution would well......help lol
thanks again for replying ^^

07/19/2011 15:45 SilentBill#235

Well, if it's just for friends and family, I'm sure they won't mind if you tame from the DB. At least until the tables are 100% fixed.

07/19/2011 16:30 bubbakid#236

when i usually get Pets from the DB and i do a server restart their usually gone.... dun know why

07/19/2011 19:20 jhunatbj11#237

Quote:

Originally Posted by Doc Nobody

I just wanted to first say thank you to all devs that have contributed to this project.

I noticed a few people were looking to adjust taming rates, and it has been mentioned how to blanket adjust all rates, but for those who wanted to change the rates by tiers I provide my query below.

This is my first SQL query so if it could be done better, faster, cleaner, whatever... I make no claims to know anything about this stuff, only that I have been reading the forums and thought I'd contribute. If this is the wrong spot to place this, you can put it wherever. --Enjoy!

Spoiler

--Tier 6
UPDATE [Arcadia].[dbo].[MonsterResource]
SET [taming_percentage]=0.5000 --<<<<<<<< Adjust this to change tame success%
WHERE model LIKE '%dragon%'
GO

--Tier 5
UPDATE [Arcadia].[dbo].[MonsterResource]
SET [taming_percentage]=0.6700 --<<<<<<<< Adjust this to change tame success%
WHERE model LIKE '%jini%' OR model LIKE '%keberos%'
GO

--Tier 4
UPDATE [Arcadia].[dbo].[MonsterResource]
SET [taming_percentage]=0.7500 --<<<<<<<< Adjust this to change tame success%
WHERE model LIKE '%angel%' OR model LIKE '%horseman%' OR model LIKE '%tafari%' or model LIKE '%eimus%'
GO

--Tier 3
UPDATE [Arcadia].[dbo].[MonsterResource]
SET [taming_percentage]=0.8200 --<<<<<<<< Adjust this to change tame success%
WHERE model LIKE '%hawkman%' OR model LIKE '%salamander%' OR model LIKE '%windsong%' OR model LIKE '%unicorn%'
GO

--Tier 2
UPDATE [Arcadia].[dbo].[MonsterResource]
SET [taming_percentage]=0.9000 --<<<<<<<< Adjust this to change tame success%
WHERE model LIKE '%pixi%' OR model LIKE '%seiren%' OR model LIKE '%skelfighter%' OR model LIKE '%orc%' OR model LIKE '%wolf%' OR model LIKE '%octopus%'
GO

--Tier 1
UPDATE [Arcadia].[dbo].[MonsterResource]
SET [taming_percentage]=1.0000 --<<<<<<<< Adjust this to change tame success%
WHERE model LIKE '%chichen%' OR model LIKE 'beast_hen%' or model LIKE '%turtle%' OR model LIKE '%panthera%'
GO

--View Results
SELECT model, taming_id, taming_percentage, taming_exp_mod
FROM MonsterResource
WHERE (taming_percentage > 0.0000)
ORDER BY taming_percentage, taming_id

I just want to ask, can you make a tutz how to use these?
I'm really new at MySQL and I'm totally blank about it..

I managed to Launch my Server for my friends and found the Server Commands to Change the rates.. Thanks to the poster..

But they want me to change the Tame Success Rate and saw this.., but i dont have a clue how to input these, and where to..

If it wasnt to much to ask, Could you make a Tutorial about this, It would be much appreciated..

thanks in advance..

07/19/2011 20:13 jhunatbj11#238

the tutorial in tame success rate was incomplete, the 2nd picture doesnt show..

07/19/2011 20:35 jhunatbj11#239

the problem is, i dont know what to do with it,.. T_T
I dont know where to put it, or where to start..
That is why I always refer to the pixes for instructions... it tells me where to..
Im totally Blank in MySQL, i admit it..

so please, could you help me..
where would i type that, or where would i begin..

07/20/2011 00:36 SilentBill#240

There are a million SQL tutorials out there, Google is your friend. Also, this is not MySQL, it's MSSQL, one letter difference, but that difference will set you back several hundred dollars.
Also, there's an edit button, learn to love it, don't triple post. ;)

Page 16 of 23

« First

Last »