p server issues and resolve

[serafincro]

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

so beware on your own risk.

[mizhe]

Still says cannot connect to login server

[bubbakid]

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?

[Doc Nobody]

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.

[bubbakid]

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.....

[RoflcopterGoesSoiSoiSoi]

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.

[bubbakid]

oh i see..... that's probably why, I'm using Wisp66's beta 1.1 release

[RoflcopterGoesSoiSoiSoi]

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

[bubbakid]

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 ^^

[SilentBill]

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.

[bubbakid]

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

[jhunatbj11]

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..

[jhunatbj11]

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

[jhunatbj11]

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..

[SilentBill]

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.