Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rappelz > Rappelz Private Server
You last visited: Today at 07:29

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

 

[Help Thread] Please post your questions here.

Reply
 
Old   #4591
 
elite*gold: 0
Join Date: Dec 2014
Posts: 31
Received Thanks: 0
where it fit to give the Hidden Village? prompt in the request. Rusty I have


USE [Auth]
GO

DECLARE @IN_ACCOUNT_ID INT
DECLARE @Counter int

SELECT @IN_ACCOUNT_ID = max([account_id]) FROM [dbo].[Accounts] where [block] = 0 --order by account_id

SET @Counter = 1
WHILE @Counter<[email protected]_ACCOUNT_ID BEGIN
if (SELECT Count(account_id) FROM Auth.dbo.accounts where account_id = @Counter) = 1
begin
INSERT INTO [Auth].[dbo].[PaidItem] ([account_id] ,[item_code] ,[item_count] ,[rest_item_count] ,[taken_account_id] ,[confirmed] ,[isCancel])
VALUES (@Counter, ID ,ID , @Counter, 1, 0)
end
SET @Counter = @Counter + 1
END
GO

Epic 9.1

When adding a hidden village an error, tweak for 9.1 epic if you can. I did not know in what subject to write

I'm confused by topics



sergeu1988 is offline  
Old   #4592
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,048
Received Thanks: 982
OMG ask your question in the help thread doesn't mean spam the forum.

Yet since you did at least post your question in the one thread where it belongs I will answer it here.

You need to carefully read step two in the 9.1 guide.

It will direct you to download some billing fixes and you will need to open the queries in your SQL object explorer and execute them in the following order...

add_paiditem_to_91.sql
smp_check_purchased_item.sql
smp_read_purchased_item.sql
smp_takeout_commercial_item.sql
smp_update_takeout_info.sql

You need to add the dbo.PaidItem to telecaster before you can add any of the SMPs

Throw out what you have it is junk there is no dbo.PaidItem in the Auth database.

Alternatively you can restore the original billing database which was included in the 7.4 repack releases and perform the fixes to the original billing database.

After running those queries you can then add the hidden village pass to an NPC and if a player buys it when they log out and log back in they will gain the hidden village buff.

See the following topic for more detail...



No I wont post pictures. If that information is not clear enough for you then it is like Darwinism and survival of the fittest.


ThunderNikk is offline  
Thanks
1 User
Old   #4593
 
elite*gold: 0
Join Date: Dec 2014
Posts: 31
Received Thanks: 0
thanks a lot.
sergeu1988 is offline  
Old   #4594
 
elite*gold: 0
Join Date: Jan 2010
Posts: 8
Received Thanks: 0
when I run the games with the client 9.1 I end up with this in my eureur Auth

2015-05-04 08:18:52 !!!!! Invalid Message from 127.0.0.1[ID: 61263, Size: -465269303]

thank you help
You must register and activate your account in order to view images.


karlkani600 is offline  
Old   #4595
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,048
Received Thanks: 982
The .opt files in the guide were designed to run with the auth emulator but you are not using the auth emulator, so I would be interested to see what your authserver.opt file looks like for the non emulator.

You get a message in game001 console...

Acceptor initialize... ok: (IP: 0.0.0.0, Port: 4514)

That address isn't right.
ThunderNikk is offline  
Old   #4596
 
elite*gold: 0
Join Date: Feb 2015
Posts: 56
Received Thanks: 1
hi all

I can not add a file to the dealer

Is there a new program?

In which I add a dealer?

sorry for bad english
king1king is offline  
Old   #4597
 
elite*gold: 0
Join Date: Aug 2011
Posts: 171
Received Thanks: 33
Red face

Quote:
Originally Posted by king1king View Post
hi all

I can not add a file to the dealer

Is there a new program?

In which I add a dealer?

sorry for bad english
if you mean ... how to creat a NPC

this thread i guess will help you

Modamer9 is offline  
Old   #4598
 
elite*gold: 0
Join Date: Aug 2014
Posts: 26
Received Thanks: 1
Scrolls ID

Would like to know the ID of the scrolls to be able to use UG and circus gear and weapons.

Thanks
Sand Dragon is offline  
Old   #4599
 
elite*gold: 0
Join Date: May 2014
Posts: 44
Received Thanks: 13
Quote:
Originally Posted by Sand Dragon View Post
Would like to know the ID of the scrolls to be able to use UG and circus gear and weapons.

Thanks
Hi

601100308
601100362
601100363
601100365
Taktiik is offline  
Thanks
1 User
Old   #4600
 
elite*gold: 0
Join Date: Nov 2009
Posts: 303
Received Thanks: 30
Hello,
So im trying to make a exchanger for my server, Seem i cant get the values right
Was wondering if anyone could and would help me correct my errors


Also id like to say, anyone who doesn't have this in there server and would like to use this, Please feel free to. Hopefully we can get the values correct.

Thank you again for all you help here
tokesbowls is offline  
Old   #4601
 
elite*gold: 0
Join Date: May 2014
Posts: 44
Received Thanks: 13
Quote:
Originally Posted by tokesbowls View Post
Hello,
So im trying to make a exchanger for my server, Seem i cant get the values right
Was wondering if anyone could and would help me correct my errors

function ruppee_exchange()
dlg_title( "Ruppee > Arena Points" )
dlg_text( "Hi there, would you like to exchange your ruppees to arena points?" )
dlg_menu( "250,000,000 Ruppees = 10,000 AP", "gold2ap(10,1)" )
dlg_menu( "750,000,000 Ruppees = 25,000 AP", "gold2ap(25,3)" )
dlg_menu( "1,500,000,000 Ruppees = 50,000 AP", "gold2ap(50,6)" )
dlg_menu( "3,000,000,000 Ruppees = 100,000 AP", "gold2ap(100,12)" )
dlg_menu( "Back", "exchange_arenapoints()" )
dlg_menu("@90010002", "")
dlg_show()
end

function gold2ap(count,lng)
local ap = get_value("ap")
local gold = get_value("gold")
local cost = 250000 * count
local applus =count * 1000

if gold >= ap then
set_value("ap",ap + applus)
set_value("gold", gold - cost)
message("<#FFFFFF><B>Success! you've paid: "..cost.." for "..applus.."Arena Points.")
--update_gold_chaos()
elseif ap < cost then --determination: if ap is less then the costs
if lng == 0 then
-- no_ap() some arabic shit
elseif lng == 1 then
message("<#CDRFDF><B>Sorry! not anough gold.")
end
end
end
-----------------------------------------------------------------------------------------------
function jp_exchange()
dlg_title( "Job Points > Ruppee" )
dlg_text( "Hi there, would you like to exchange your Job Points to Ruppee?" )
dlg_menu( "50,000,000 Ruppees = 10,000 AP", "jp2gold(10,1)" )
dlg_menu( "75,000,000 Ruppees = 25,000 AP", "jp2gold(25,1)" )
dlg_menu( "150,000,000 Ruppees = 50,000 AP", "jp2gold(50,1)" )
dlg_menu( "500,000,000 Ruppees = 100,000 AP", "jp2gold(100,1)" )
dlg_menu( "Back", "exchange_arenapoints()" )
dlg_menu("@90010002", "")
dlg_show()
end

function jp2gold(count,lng)
local jp = get_value("jp")
local gold = get_value("gold")
local cost = 5000000 * count
local applus =count * 1000

if jp >= gpld then
set_value("gold",gold + applus)
set_value("jp", jp - cost)
message("<#FFFFFF><B>Success! you've paid: "..cost.."JP for "..applus.."ruppees.")
--update_gold_chaos()
elseif ap < cost then --determination: if ap is less then the costs
if lng == 0 then
-- no_ap() some arabic shit
elseif lng == 1 then
message("<#CDRFDF><B>Sorry! not anough jp.")
end
end
end
------------------------------------------------------------------------------------------------
function jp_exchanger()
dlg_title( "Job Point > Arena Points" )
dlg_text( "Hi there, would you like to exchange your job points to arena points?" )
dlg_menu( "300,000,000 JP = 100,000 AP", "ap_ex(100,1000000)" )
dlg_menu( "Back", "exchange_arenapoints()" )
dlg_menu("@90010002", "")
dlg_show()
end

function ap_ex(count,lng)
local jp = get_value("jp")
local ap = get_value("ap")
local cost = 3000000 * count
local applus =count * 1000

if jp >= cost then
set_value("ap",ap + applus)
set_value("jp", jp - cost)
update_gold_chaos()
elseif jp < cost then
if lng == 0
then no_ap()
elseif lng == 1
then no_ape()
end
end
end


Also id like to say, anyone who doesn't have this in there server and would like to use this, Please feel free to. Hopefully we can get the values correct.

Thank you again for all you help here
Hi, here's one of my old script .. [FRENCH/US]

function NPC_Cps()
-- NPC_Trader 20143010
dlg_title( " Échangeur " )
dlg_text( "Salut / Hi : Veuillez choisir votre langue. / Please select your language. ")
dlg_menu( "Français", "NPC_CpsFR()" )
dlg_menu( "English", "NPC_CpsEN()" )
dlg_menu("@90010002", "")
dlg_show()
end

function NPC_CpsFR()
-- Version français
dlg_title( "Échangeur" )
dlg_text("Salut ! Ici tu pourras échanger tes Cps, ton argent ou des items contre de nouveaux trucs ! Passes un agréable moment avec nous sur Rappelz Paradise !")
dlg_menu( "Échanger mes CPs", "NPC_CpsFRCP()" )
dlg_menu( "Échanger un item boutique", "NPC_CpsFRboutique()" )
dlg_menu("Retour", "NPC_Cps()")
dlg_menu("@90010002", "")
dlg_show()
end

function NPC_CpsEN()
-- Version anglaise
dlg_title( "Trader" )
dlg_text("Hi ! You can trade me your JPs, your ruppys or some items to have new and exclusive things ! Have fun with us on Rappelz Paradise !")
dlg_menu( "Trade my JPs", "NPC_CpsENCP()" )
dlg_menu( "Trade an item from ParadiseShop", "NPC_CpsENboutique()" )
dlg_menu("Back", "NPC_Cps()")
dlg_menu("@90010002", "")
dlg_show()
end

-- ECHANGE VS CP
function NPC_CpsFRCP()
dlg_title( "Échangeur" )
dlg_text("Tu veux échanger tes CP. Mais contre quoi ?")
dlg_menu( "Argent", "NPC_CpsFRCP_money()" )
dlg_menu( "Points ours", "NPC_CpsFRCP_ours()" )
dlg_menu( "Points arène", "NPC_CpsFRCP_arena()" )
dlg_menu( "Points talent", "NPC_CpsFRCP_talent()" )
dlg_menu( "CP créature", "NPC_CpsFRCP_pets()" )
dlg_menu("Retour", "NPC_CpsFR()")
dlg_menu("@90010002", "")
dlg_show()
end

function NPC_CpsENCP()
dlg_title( "Trader" )
dlg_text("You want to trade your JP. But against what ?")
dlg_menu( "Ruppies", "NPC_CpsENCP_money()" )
dlg_menu( "Holic points", "NPC_CpsENCP_ours()" )
dlg_menu( "Arena points", "NPC_CpsENCP_arena()" )
dlg_menu( "Talent points", "NPC_CpsENCP_talent()" )
dlg_menu( "Pet JPs", "NPC_CpsENCP_pets()" )
dlg_menu("Back", "NPC_CpsEN()")
dlg_menu("@90010002", "")
dlg_show()
end

function NPC_CpsFRCP_money()
dlg_title( "Échangeur" )
dlg_text("Tu veux échanger tes CP contre de l'argent. 1CP correspond à 1RP.")
dlg_menu( "1M CP", "echangetorp(1)" )
dlg_menu( "5M CP", "echangetorp(2)" )
dlg_menu( "10M CP", "echangetorp(3)" )
dlg_menu( "50M CP", "echangetorp(4)" )
dlg_menu( "100M CP", "echangetorp(5)" )
dlg_menu( "500M CP", "echangetorp(6)" )
dlg_menu( "1000M CP", "echangetorp(7)" )
dlg_menu( "5000M CP", "echangetorp(8)" )
dlg_menu("Retour", "NPC_CpsFRCP()")
dlg_menu("@90010002", "")
dlg_show()
end

function NPC_CpsENCP_money()
dlg_title( "Trader" )
dlg_text("You want to trade your JPs vs gold. 1JP equals to 1RP.")
dlg_menu( "1M JP", "echangetorp(1)" )
dlg_menu( "5M JP", "echangetorp(2)" )
dlg_menu( "10M JP", "echangetorp(3)" )
dlg_menu( "50M JP", "echangetorp(4)" )
dlg_menu( "100M JP", "echangetorp(5)" )
dlg_menu( "500M JP", "echangetorp(6)" )
dlg_menu( "1000M JP", "echangetorp(7)" )
dlg_menu( "5000M JP", "echangetorp(8)" )
dlg_menu("Back", "NPC_CpsEN()")
dlg_menu("@90010002", "")
dlg_show()
end

function echangetorp(id)
local jp = get_value( "jp" )
local gold = get_value( "gold" )
text_confirmation_rp = "Vos points de compétences ont été convertis en RP !"

if id == 1 then
if jp >= 1000000 then
set_value( "jp", jp - 1000000 )
set_value( "gold", gold + 1000000 )
cprint(text_confirmation_rp)
NPC_CpsFRCP_money()
else
dlg_title( "Paradise Manager" )
dlg_text( "Hey, la maison ne fait pas crédit ! Vous n'avez pas assez de points de compétences !" )
dlg_menu( "@90010003", "NPC_CpsFRCP_money()" )
dlg_menu( "Je reviendrai.", " " )
dlg_show()
end
return
end

if id == 2 then
if jp >= 5000000 then
set_value( "jp", jp - 5000000 )
set_value( "gold", gold + 5000000 )
cprint(text_confirmation_rp)
NPC_CpsFRCP_money()
else
dlg_title( "Paradise Manager" )
dlg_text( "Hey, la maison ne fait pas crédit ! Vous n'avez pas assez de points de compétences !" )
dlg_menu( "@90010003", "NPC_CpsFRCP_money()" )
dlg_menu( "Je reviendrai.", " " )
dlg_show()
end
return
end

if id == 3 then
if jp >= 10000000 then
set_value( "jp", jp - 10000000 )
set_value( "gold", gold + 10000000 )
cprint(text_confirmation_rp)
NPC_CpsFRCP_money()
else
dlg_title( "Paradise Manager" )
dlg_text( "Hey, la maison ne fait pas crédit ! Vous n'avez pas assez de points de compétences !" )
dlg_menu( "@90010003", "NPC_CpsFRCP_money()" )
dlg_menu( "Je reviendrai.", " " )
dlg_show()
end
return
end

if id == 4 then
if jp >= 50000000 then
set_value( "jp", jp - 50000000 )
set_value( "gold", gold + 50000000 )
cprint(text_confirmation_rp)
NPC_CpsFRCP_money()
else
dlg_title( "Paradise Manager" )
dlg_text( "Hey, la maison ne fait pas crédit ! Vous n'avez pas assez de points de compétences !" )
dlg_menu( "@90010003", "NPC_CpsFRCP_money()" )
dlg_menu( "Je reviendrai.", " " )
dlg_show()
end
return
end

if id == 5 then
if jp >= 100000000 then
set_value( "jp", jp - 100000000 )
set_value( "gold", gold + 100000000 )
cprint(text_confirmation_rp)
NPC_CpsFRCP_money()
else
dlg_title( "Paradise Manager" )
dlg_text( "Hey, la maison ne fait pas crédit ! Vous n'avez pas assez de points de compétences !" )
dlg_menu( "@90010003", "NPC_CpsFRCP_money()" )
dlg_menu( "Je reviendrai.", " " )
dlg_show()
end
return
end

if id == 6 then
if jp >= 500000000 then
set_value( "jp", jp - 500000000 )
set_value( "gold", gold + 500000000 )
cprint(text_confirmation_rp)
NPC_CpsFRCP_money()
else
dlg_title( "Paradise Manager" )
dlg_text( "Hey, la maison ne fait pas crédit ! Vous n'avez pas assez de points de compétences !" )
dlg_menu( "@90010003", "NPC_CpsFRCP_money()" )
dlg_menu( "Je reviendrai.", " " )
dlg_show()
end
return
end

if id == 7 then
if jp >= 1000000000 then
set_value( "jp", jp - 1000000000 )
set_value( "gold", gold + 1000000000 )
cprint(text_confirmation_rp)
NPC_CpsFRCP_money()
else
dlg_title( "Paradise Manager" )
dlg_text( "Hey, la maison ne fait pas crédit ! Vous n'avez pas assez de points de compétences !" )
dlg_menu( "@90010003", "NPC_CpsFRCP_money()" )
dlg_menu( "Je reviendrai.", " " )
dlg_show()
end
return
end

if id == 8 then
if jp >= 5000000000 then
set_value( "jp", jp - 5000000000 )
set_value( "gold", gold + 5000000000 )
cprint(text_confirmation_rp)
NPC_CpsFRCP_money()
else
dlg_title( "Paradise Manager" )
dlg_text( "Hey, la maison ne fait pas crédit ! Vous n'avez pas assez de points de compétences !" )
dlg_menu( "@90010003", "NPC_CpsFRCP_money()" )
dlg_menu( "Je reviendrai.", " " )
dlg_show()
end
return
end
end

function NPC_CpsFRCP_ours()
dlg_title( "Échangeur" )
dlg_text("Tu veux échanger tes CP contre de l'argent. 1000CP correspond à 1 points ours.")
dlg_menu( "1M CP", "echangetoours(1)" )
dlg_menu( "5M CP", "echangetoours(2)" )
dlg_menu( "10M CP", "echangetoours(3)" )
dlg_menu( "50M CP", "echangetoours(4)" )
dlg_menu( "100M CP", "echangetoours(5)" )
dlg_menu( "500M CP", "echangetoours(6)" )
dlg_menu( "1000M CP", "echangetoours(7)" )
dlg_menu( "5000M CP", "echangetoours(8)" )
dlg_menu("Retour", "NPC_CpsFRCP()")
dlg_menu("@90010002", "")
dlg_show()
end

function NPC_CpsENCP_ours()
dlg_title( "Trader" )
dlg_text("You want to trade your JPs vs gold. 1000JP equals to 1 point ours.")
dlg_menu( "1M JP", "echangetoours(1)" )
dlg_menu( "5M JP", "echangetoours(2)" )
dlg_menu( "10M JP", "echangetoours(3)" )
dlg_menu( "50M JP", "echangetoours(4)" )
dlg_menu( "100M JP", "echangetoours(5)" )
dlg_menu( "500M JP", "echangetoours(6)" )
dlg_menu( "1000M JP", "echangetoours(7)" )
dlg_menu( "5000M JP", "echangetoours(8)" )
dlg_menu("Back", "NPC_CpsEN()")
dlg_menu("@90010002", "")
dlg_show()
end
function echangetoours(id)
local jp = get_value( "jp" )
local holic = get_value( "huntaholic_point" )
text_confirmation_ours = "Vos points de compétences ont été convertis en points ours !"

if id == 1 then
if jp >= 1000000 then
set_value( "jp", jp - 1000000 )
set_value( "huntaholic_point", holic + 1000)
cprint( "1.000 Points d'ours reçu" )
cprint(text_confirmation_ours)
NPC_CpsFRCP_ours()
else
dlg_title( "Paradise Manager" )
dlg_text( "Hey, la maison ne fait pas crédit ! Vous n'avez pas assez de points de compétences !" )
dlg_menu( "@90010003", "NPC_CpsFRCP_ours()" )
dlg_menu( "Je reviendrai.", " " )
dlg_show()
end
return
end

if id == 2 then
if jp >= 5000000 then
set_value( "jp", jp - 5000000 )
set_value( "huntaholic_point", holic + 5000)
cprint( "5.000 Points d'ours reçu" )
cprint(text_confirmation_ours)
NPC_CpsFRCP_ours()
else
dlg_title( "Paradise Manager" )
dlg_text( "Hey, la maison ne fait pas crédit ! Vous n'avez pas assez de points de compétences !" )
dlg_menu( "@90010003", "NPC_CpsFRCP_ours()" )
dlg_menu( "Je reviendrai.", " " )
dlg_show()
end
return
end

if id == 3 then
if jp >= 10000000 then
set_value( "jp", jp - 10000000 )
set_value( "huntaholic_point", holic + 10000)
cprint( "10.000 Points d'ours reçu" )
cprint(text_confirmation_ours)
NPC_CpsFRCP_ours()
else
dlg_title( "Paradise Manager" )
dlg_text( "Hey, la maison ne fait pas crédit ! Vous n'avez pas assez de points de compétences !" )
dlg_menu( "@90010003", "NPC_CpsFRCP_ours()" )
dlg_menu( "Je reviendrai.", " " )
dlg_show()
end
return
end

if id == 4 then
if jp >= 50000000 then
set_value( "jp", jp - 50000000 )
set_value( "huntaholic_point", holic + 50000)
cprint( "50.000 Points d'ours reçu" )
cprint(text_confirmation_ours)
NPC_CpsFRCP_ours()
else
dlg_title( "Paradise Manager" )
dlg_text( "Hey, la maison ne fait pas crédit ! Vous n'avez pas assez de points de compétences !" )
dlg_menu( "@90010003", "NPC_CpsFRCP_ours()" )
dlg_menu( "Je reviendrai.", " " )
dlg_show()
end
return
end

if id == 5 then
if jp >= 100000000 then
set_value( "jp", jp - 100000000 )
set_value( "huntaholic_point", holic + 100000)
cprint( "100.000 Points d'ours reçu" )
cprint(text_confirmation_ours)
NPC_CpsFRCP_ours()
else
dlg_title( "Paradise Manager" )
dlg_text( "Hey, la maison ne fait pas crédit ! Vous n'avez pas assez de points de compétences !" )
dlg_menu( "@90010003", "NPC_CpsFRCP_ours()" )
dlg_menu( "Je reviendrai.", " " )
dlg_show()
end
return
end

if id == 6 then
if jp >= 500000000 then
set_value( "jp", jp - 500000000 )
set_value( "huntaholic_point", holic + 500000)
cprint( "500.000 Points d'ours reçu" )
cprint(text_confirmation_ours)
NPC_CpsFRCP_ours()
else
dlg_title( "Paradise Manager" )
dlg_text( "Hey, la maison ne fait pas crédit ! Vous n'avez pas assez de points de compétences !" )
dlg_menu( "@90010003", "NPC_CpsFRCP_ours()" )
dlg_menu( "Je reviendrai.", " " )
dlg_show()
end
return
end

if id == 7 then
if jp >= 1000000000 then
set_value( "jp", jp - 1000000000 )
set_value( "huntaholic_point", holic + 1000000)
cprint( "1.000.000 Points d'ours reçu" )
cprint(text_confirmation_ours)
NPC_CpsFRCP_ours()
else
dlg_title( "Paradise Manager" )
dlg_text( "Hey, la maison ne fait pas crédit ! Vous n'avez pas assez de points de compétences !" )
dlg_menu( "@90010003", "NPC_CpsFRCP_ours()" )
dlg_menu( "Je reviendrai.", " " )
dlg_show()
end
return
end

if id == 8 then
if jp >= 5000000000 then
set_value( "jp", jp - 5000000000 )
set_value( "huntaholic_point", holic + 5000000)
cprint( "5.000.000 Points d'ours reçu" )
cprint(text_confirmation_ours)
NPC_CpsFRCP_ours()
else
dlg_title( "Paradise Manager" )
dlg_text( "Hey, la maison ne fait pas crédit ! Vous n'avez pas assez de points de compétences !" )
dlg_menu( "@90010003", "NPC_CpsFRCP_ours()" )
dlg_menu( "Je reviendrai.", " " )
dlg_show()
end
return
end
end

function NPC_CpsFRCP_arena()
dlg_title( "Échangeur" )
dlg_text("Tu veux échanger tes CP contre de l'argent. 3000CP correspond à 1 points arène.")
dlg_menu( "1M CP", "echangetoarena(1)" )
dlg_menu( "5M CP", "echangetoarena(2)" )
dlg_menu( "10M CP", "echangetoarena(3)" )
dlg_menu( "50M CP", "echangetoarena(4)" )
dlg_menu( "100M CP", "echangetoarena(5)" )
dlg_menu( "500M CP", "echangetoarena(6)" )
dlg_menu( "1000M CP", "echangetoarena(7)" )
dlg_menu( "5000M CP", "echangetoarena(8)" )
dlg_menu("Retour", "NPC_CpsFRCP()")
dlg_menu("@90010002", "")
dlg_show()
end

function NPC_CpsENCP_arena()
dlg_title( "Trader" )
dlg_text("You want to trade your JPs vs gold. 5000JP equals to 1 point ours.")
dlg_menu( "1M JP", "echangetoarena(1)" )
dlg_menu( "5M JP", "echangetoarena(2)" )
dlg_menu( "10M JP", "echangetoarena(3)" )
dlg_menu( "50M JP", "echangetoarena(4)" )
dlg_menu( "100M JP", "echangetoarena(5)" )
dlg_menu( "500M JP", "echangetoarena(6)" )
dlg_menu( "1000M JP", "echangetoarena(7)" )
dlg_menu( "5000M JP", "echangetoarena(8)" )
dlg_menu("Back", "NPC_CpsEN()")
dlg_menu("@90010002", "")
dlg_show()
end

function echangetoarena(id)
local jp = get_value( "jp" )
local arena = get_value( "arena_point" )
text_confirmation_arena = "Vos points de compétences ont été convertis en points arène !"

if id == 1 then
if jp >= 1000000 then
set_value( "jp", jp - 1000000 )
set_value( "arena_point", arena + 200)
cprint( "200 Points arène reçu" )
cprint(text_confirmation_arena)
NPC_CpsFRCP_ours()
else
dlg_title( "Paradise Manager" )
dlg_text( "Hey, la maison ne fait pas crédit ! Vous n'avez pas assez de points de compétences !" )
dlg_menu( "@90010003", "NPC_CpsFRCP_arena()" )
dlg_menu( "Je reviendrai.", " " )
dlg_show()
end
return
end

if id == 2 then
if jp >= 5000000 then
set_value( "jp", jp - 5000000 )
set_value( "arena_point", arena + 1000)
cprint( "1.000 Points arène reçu" )
cprint(text_confirmation_arena)
NPC_CpsFRCP_ours()
else
dlg_title( "Paradise Manager" )
dlg_text( "Hey, la maison ne fait pas crédit ! Vous n'avez pas assez de points de compétences !" )
dlg_menu( "@90010003", "NPC_CpsFRCP_arena()" )
dlg_menu( "Je reviendrai.", " " )
dlg_show()
end
return
end

if id == 3 then
if jp >= 10000000 then
set_value( "jp", jp - 10000000 )
set_value( "arena_point", arena + 2000)
cprint( "2.000 Points arène reçu" )
cprint(text_confirmation_arena)
NPC_CpsFRCP_ours()
else
dlg_title( "Paradise Manager" )
dlg_text( "Hey, la maison ne fait pas crédit ! Vous n'avez pas assez de points de compétences !" )
dlg_menu( "@90010003", "NPC_CpsFRCP_arena()" )
dlg_menu( "Je reviendrai.", " " )
dlg_show()
end
return
end

if id == 4 then
if jp >= 50000000 then
set_value( "jp", jp - 50000000 )
set_value( "arena_point", arena + 10000)
cprint( "10.000 Points arène reçu" )
cprint(text_confirmation_arena)
NPC_CpsFRCP_ours()
else
dlg_title( "Paradise Manager" )
dlg_text( "Hey, la maison ne fait pas crédit ! Vous n'avez pas assez de points de compétences !" )
dlg_menu( "@90010003", "NPC_CpsFRCP_arena()" )
dlg_menu( "Je reviendrai.", " " )
dlg_show()
end
return
end

if id == 5 then
if jp >= 100000000 then
set_value( "jp", jp - 100000000 )
set_value( "arena_point", arena + 20000)
cprint( "20.000 Points arène reçu" )
cprint(text_confirmation_arena)
NPC_CpsFRCP_ours()
else
dlg_title( "Paradise Manager" )
dlg_text( "Hey, la maison ne fait pas crédit ! Vous n'avez pas assez de points de compétences !" )
dlg_menu( "@90010003", "NPC_CpsFRCP_arena()" )
dlg_menu( "Je reviendrai.", " " )
dlg_show()
end
return
end

if id == 6 then
if jp >= 500000000 then
set_value( "jp", jp - 500000000 )
set_value( "arena_point", arena + 100000)
cprint( "100.000 Points arène reçu" )
cprint(text_confirmation_arena)
NPC_CpsFRCP_ours()
else
dlg_title( "Paradise Manager" )
dlg_text( "Hey, la maison ne fait pas crédit ! Vous n'avez pas assez de points de compétences !" )
dlg_menu( "@90010003", "NPC_CpsFRCP_arena()" )
dlg_menu( "Je reviendrai.", " " )
dlg_show()
end
return
end

if id == 7 then
if jp >= 1000000000 then
set_value( "jp", jp - 1000000000 )
set_value( "arena_point", arena + 200000)
cprint( "200.000 Points arène reçu" )
cprint(text_confirmation_arena)
NPC_CpsFRCP_ours()
else
dlg_title( "Paradise Manager" )
dlg_text( "Hey, la maison ne fait pas crédit ! Vous n'avez pas assez de points de compétences !" )
dlg_menu( "@90010003", "NPC_CpsFRCP_arena()" )
dlg_menu( "Je reviendrai.", " " )
dlg_show()
end
return
end

if id == 8 then
if jp >= 5000000000 then
set_value( "jp", jp - 5000000000 )
set_value( "arena_point", arena + 1000000)
cprint( "1.000.000 Points arène reçu" )
cprint(text_confirmation_arena)
NPC_CpsFRCP_ours()
else
dlg_title( "Paradise Manager" )
dlg_text( "Hey, la maison ne fait pas crédit ! Vous n'avez pas assez de points de compétences !" )
dlg_menu( "@90010003", "NPC_CpsFRCP_arena()" )
dlg_menu( "Je reviendrai.", " " )
dlg_show()
end
return
end
end

function NPC_CpsFRCP_talent()
dlg_title( "Échangeur" )
dlg_text("Tu veux échanger tes CP contre un points de talent. 5000MCP correspond à 1 point de talent.")
dlg_menu( "Je veux mon points de talent !", "echangetotalent()" )
dlg_menu("Retour", "NPC_CpsFRCP()")
dlg_menu("@90010002", "")
dlg_show()
end

function NPC_CpsENCP_talent()
dlg_title( "Trader" )
dlg_text("You can trade all of your JP vs one talent's point. 5000MCP equals to 1 point of talent.")
dlg_menu( "I want my point !", "echangetotalent()" )
dlg_menu("Back", "NPC_CpsENCP()")
dlg_menu("@90010002", "")
dlg_show()
end

function echangetotalent()
local jp = get_value( "jp" )
local job = get_value( "job_2" )
text_confirmation_tp = "Vos points de compétences ont été convertis en points de talent !"

if jp == 5000000000 then
if job > 0 then
set_value( "jp", jp - 5000000000 )
set_value( "tp", tp + 1)
cprint( "1 Point de talent reçu" )
cprint(text_confirmation_tp)
NPC_CpsFRCP_ours()
else
dlg_title( "Paradise Manager" )
dlg_text( "Hey, la maison ne fait pas crédit ! Vous n'avez pas assez de points de compétences !" )
dlg_menu( "@90010003", "NPC_CpsFRCP_arena()" )
dlg_menu( "Je reviendrai.", " " )
dlg_show()
end
return
end
end

function NPC_CpsFRCP_pets()
dlg_title( "Échangeur" )
dlg_text("Tu veux échanger tes CP contre des CP pour ta créature. 1000MCP correspond à 1 CP pour ta créature.")
dlg_menu( "1000M CP", "echangetopet(1)" )
dlg_menu( "2000M CP", "echangetopet(2)" )
dlg_menu( "3000M CP", "echangetopet(3)" )
dlg_menu( "4000M CP", "echangetopet(4)" )
dlg_menu( "5000M CP", "echangetopet(5)" )
dlg_menu("Retour", "NPC_CpsFRCP()")
dlg_menu("@90010002", "")
dlg_show()
end

function NPC_CpsENCP_pets()
dlg_title( "Trader" )
dlg_text("You want to change your JP for JP to your pet. 1000MJP equals to 1 JP for your pet.")
dlg_menu( "1000M JP", "echangetopet(1)" )
dlg_menu( "2000M JP", "echangetopet(2)" )
dlg_menu( "3000M JP", "echangetopet(3)" )
dlg_menu( "4000M JP", "echangetopet(4)" )
dlg_menu( "5000M JP", "echangetopet(5)" )
dlg_menu("Back", "NPC_CpsENCP()")
dlg_menu("@90010002", "")
dlg_show()
end

function echangetopet(id)
local jp = get_value( "jp" )
local petjp = get_creature_value( handle, "jp" )
text_confirmation_tp = "Vos points de compétences ont été convertis en points de compétences pour votre créature !"

if id == 1 then
if jp == 1000000000 then
set_value( "jp", jp - 1000000000 )
set_creature_value( handle, "jp", petjp + 1 )
cprint( "1 Point de compétences reçu" )
cprint(text_confirmation_tp)
NPC_CpsFRCP_ours()
else
dlg_title( "Paradise Manager" )
dlg_text( "Hey, la maison ne fait pas crédit ! Vous n'avez pas assez de points de compétences !" )
dlg_menu( "@90010003", "NPC_CpsFRCP_arena()" )
dlg_menu( "Je reviendrai.", " " )
dlg_show()
end
return
end

if id == 2 then
if jp == 2000000000 then
set_value( "jp", jp - 2000000000 )
set_creature_value( handle, "jp", petjp + 2 )
cprint( "2 Points de compétences reçu" )
cprint(text_confirmation_tp)
NPC_CpsFRCP_ours()
else
dlg_title( "Paradise Manager" )
dlg_text( "Hey, la maison ne fait pas crédit ! Vous n'avez pas assez de points de compétences !" )
dlg_menu( "@90010003", "NPC_CpsFRCP_arena()" )
dlg_menu( "Je reviendrai.", " " )
dlg_show()
end
return
end

if id == 3 then
if jp == 3000000000 then
set_value( "jp", jp - 3000000000 )
set_creature_value( handle, "jp", petjp + 3 )
cprint( "3 Points de compétences reçu" )
cprint(text_confirmation_tp)
NPC_CpsFRCP_ours()
else
dlg_title( "Paradise Manager" )
dlg_text( "Hey, la maison ne fait pas crédit ! Vous n'avez pas assez de points de compétences !" )
dlg_menu( "@90010003", "NPC_CpsFRCP_arena()" )
dlg_menu( "Je reviendrai.", " " )
dlg_show()
end
return
end

if id == 4 then
if jp == 4000000000 then
set_value( "jp", jp - 4000000000 )
set_creature_value( handle, "jp", petjp + 4 )
cprint( "4 Points de compétences reçu" )
cprint(text_confirmation_tp)
NPC_CpsFRCP_ours()
else
dlg_title( "Paradise Manager" )
dlg_text( "Hey, la maison ne fait pas crédit ! Vous n'avez pas assez de points de compétences !" )
dlg_menu( "@90010003", "NPC_CpsFRCP_arena()" )
dlg_menu( "Je reviendrai.", " " )
dlg_show()
end
return
end

if id == 5 then
if jp == 5000000000 then
set_value( "jp", jp - 5000000000 )
set_creature_value( handle, "jp", petjp + 5 )
cprint( "5 Points de compétences reçu" )
cprint(text_confirmation_tp)
NPC_CpsFRCP_ours()
else
dlg_title( "Paradise Manager" )
dlg_text( "Hey, la maison ne fait pas crédit ! Vous n'avez pas assez de points de compétences !" )
dlg_menu( "@90010003", "NPC_CpsFRCP_arena()" )
dlg_menu( "Je reviendrai.", " " )
dlg_show()
end
return
end
end

-- ECHANGE VS item boutique
function NPC_CpsFRRP()
dlg_title( "Échangeur" )
dlg_text("Tu veux échanger tes items boutique. Mais contre quoi ?")
dlg_menu( "A venir", "NPC_CpsFR" )
dlg_menu("Retour", "NPC_CpsFR()")
dlg_menu("@90010002", "")
dlg_show()
end

function NPC_CpsENRP()
dlg_title( "Trader" )
dlg_text("You want to trade your ParadiseShop items. But against what ?")
dlg_menu( "Available soon", "NPC_CpsEN" )
dlg_menu("Back", "NPC_CpsEN()")
dlg_menu("@90010002", "")
dlg_show()
end
Taktiik is offline  
Old   #4602
 
elite*gold: 0
Join Date: Nov 2009
Posts: 303
Received Thanks: 30
Thank you,
But only seems only jp to ruppes work, the others take my money but dont give anything in return
I think i did this right, If not please point out where i messed up. Thank you
tokesbowls is offline  
Old   #4603
 
elite*gold: 20
Join Date: Sep 2010
Posts: 57
Received Thanks: 25
Learn to use a spoiler please. X.x
Saltaya is offline  
Thanks
1 User
Old   #4604
 
elite*gold: 0
Join Date: Feb 2013
Posts: 118
Received Thanks: 12
Hello gays ..

i'm trying to get the official Cash Shop working !!

after fixing many many error's , im getting those error'r now and i don't know how to fix it OO"



Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'SP_Check_OTP'., SQL state 37000 in SQLExecDirect in C:\inetpub\wwwroot\shop\includes\checkava.php on line 141

Warning: odbc_fetch_array(): supplied argument is not a valid ODBC result resource in C:\inetpub\wwwroot\shop\includes\checkava.php on line 143

Notice: Undefined index: server in C:\inetpub\wwwroot\shop\includes\items.php on line 23

Notice: Undefined index: db in C:\inetpub\wwwroot\shop\index.php on line 129
Notice: Undefined variable: chosenItem in C:\inetpub\wwwroot\shop\index.php on line 225

Notice: Trying to get property of non-object in C:\inetpub\wwwroot\shop\index.php on line 225
mohamad512 is offline  
Old   #4605
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,048
Received Thanks: 982
I hope you are using the official billing DB because if you are not you are going to be missing a lot.

So I have to ask...

line 141
line 143
line 23
line 129
line 225

Have you read any of those lines in any of those files it is complaining about?


ThunderNikk is offline  
Reply

Tags
7.4, client, rappelz



« Previous Thread | Next Thread »

Similar Threads
[Helping Topic] 24/7 Helping Services!
stucked on anything while setuping your server? post your problem here and you will get answer as fast as possible better than spamming with posts...
31 Replies - EO PServer Hosting



All times are GMT +2. The time now is 07:29.


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.