Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rappelz > Rappelz Private Server
You last visited: Today at 14:42

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

 

[Help Thread] Please post your questions here.

Reply
 
Old   #1756
 
elite*gold: 0
Join Date: Nov 2011
Posts: 10
Received Thanks: 0
Hello i'm using this for registration page i added every column which is needed for making account, now i have small problem with account id, how to make it read last id and add +1.
Code:
                            SqlCommand cmd = new SqlCommand("INSERT INTO Account (account_id,account,password,block,withdraw_remain_time,age,auth_ok,pcbang,last_login_server_idx,event_code,result, email)VALUES(5,@User,@Pass,0,0,@Age,1,1,1,0,1,@Email)");
i tryed just 5, but there cant be multiple id 5



matedgo is offline  
Old   #1757
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,045
Received Thanks: 979
Quote:
Originally Posted by matedgo View Post
Hello i'm using this for registration page i added every column which is needed for making account, now i have small problem with account id, how to make it read last id and add +1.
Code:
                            SqlCommand cmd = new SqlCommand("INSERT INTO Account (account_id,account,password,block,withdraw_remain_time,age,auth_ok,pcbang,last_login_server_idx,event_code,result, email)VALUES(5,@User,@Pass,0,0,@Age,1,1,1,0,1,@Email)");
i tryed just 5, but there cant be multiple id 5
Why put account_id in the script, it auto populates that field when an account is created.

Does it really need to auto populate by +1?

I use the same script but I never put in account_id


ThunderNikk is offline  
Old   #1758
 
elite*gold: 0
Join Date: Nov 2011
Posts: 10
Received Thanks: 0
if i erase account_id in script, on registration it says it cannot be null. Idk do we use same auth database, because database from gameportal is alot different then this scripts is made of.
matedgo is offline  
Old   #1759
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,045
Received Thanks: 979
If you manually create an account do you fill in that column?

Cause I don't and my DB fills it in automatically the same way as if I use the script.

My script is a little different from yours because I have a few different columns but I still do not put in account_id and my database does not allow nulls in account_id either.

My script...

Code:
SqlCommand cmd = new SqlCommand("INSERT INTO Account (account,password,email,pk_,creationDate_,updateDate_,creatorId_,updatorId_,portId_,accessDate_,password2,ban,bantime,age)VALUES(@User,@Pass,@Email,1,NULL,NULL,NULL,NULL,NULL,NULL,@Pass,NULL,NULL,@Age)");
account_id is also the first row in my database.


ThunderNikk is offline  
Old   #1760
 
elite*gold: 0
Join Date: Nov 2011
Posts: 10
Received Thanks: 0
nope, i need to insert it manual:
Code:
nnot insert the value NULL into column 'account_id', table 'Auth.dbo.Account'; column does not allow nulls. INSERT fails. The statement has been terminated.
http://i.imgur.com/QCc8gn5.png

EDIT:Fixed,made that account_id is identity, now everything works.
matedgo is offline  
Old   #1761
 
elite*gold: 0
Join Date: Jun 2012
Posts: 18
Received Thanks: 0
I'm having Big problem i almost done everything i restore the data base to SQL but when i open Auth Server i get DB Auth Error and ConnectionOpen i can many pepole have this problem i tryed all things posted in forum but nothing worked Config is done ! i reamoved the Pass from sa ! and everything doen Like The Tuto i dont know what is the problem will someone add me in skype and fix the problem please = espion54
ridhapellz is offline  
Old   #1762
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,045
Received Thanks: 979
Does "sa" own the databases? (set ownership to "sa")

Did you make your edits to the .opt files and compress them?

Did you open the correct ports in Windows Advanced Firewall?
ThunderNikk is offline  
Old   #1763
 
elite*gold: 0
Join Date: Nov 2011
Posts: 10
Received Thanks: 0
how to give world buff or better to say buff to all players ?

EDITne more question, is this database problem or client problem, skills after relog does not stay. i need put them again in slots.
matedgo is offline  
Old   #1764
 
elite*gold: 0
Join Date: Sep 2008
Posts: 120
Received Thanks: 94
For buff:
I think you mean serverwide buffs who do not expire.

You have to add this into server_init: add_event_state(id, lv).

Look at following post to understand:
Player95 is offline  
Thanks
1 User
Old   #1765
 
elite*gold: 0
Join Date: May 2013
Posts: 43
Received Thanks: 1
Quote:
Originally Posted by HeavenOnlyWishes View Post
Or you can just add the add_event_state() statements. LUA in Rappelz doesn't require you to setup a function to run most of it's built in methods. And since on_server_init() is already a setup function, you can just add the statements to that function... rather than using a stacked function.

So it would look like this:

Code:
function on_server_init()
	roaming()
	rare_mob()
	guardian_spawn()
	random_respawn()
        add_event_state(1013,20)
        add_event_state(1007,15)
        add_event_state(1008,15)
        add_event_state(1002,10)
        add_event_state(1001,10)
end
I tried this and it doesn't buff me on log in

================================================== ============

Also when I go on my server, the Keys do not work. "I" is suppose to be a hot key to the inventory but it does not work! I go in options and I set them all up and then I place player attack to key "1" but when I disconnect and reconnect, it doesn't work
Pyrochina is offline  
Old   #1766
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,045
Received Thanks: 979
Quote:
Originally Posted by Pyrochina View Post
I tried this and it doesn't buff me on log in
The method I left in that thread works in my server, not sure if his would or not but since my function works I have no need to try his.

Quote:
Originally Posted by Pyrochina View Post
Also when I go on my server, the Keys do not work. "I" is suppose to be a hot key to the inventory but it does not work! I go in options and I set them all up and then I place player attack to key "1" but when I disconnect and reconnect, it doesn't work
Getting hot keys to save is an easy task but getting HV to work again afterward is a not so easy task.

Hot keys will function if you change...

T game.cash_usable_server:1

to...

T game.cash_usable_server:0

but as stated I am not sure why this fixes Hotkeys but I do know why it turns HV NPCs off.

Now in order to fix the HV NPCs you need to change their value in dbo.NPCResource.

The Value you need to change is "spawn_type" which will originally be a "4" so it only spawns if it is a cash usable server.

Change the value to "0" and they will spawn like any other NPC.

Code:
use
Arcadia
UPDATE [Arcadia].[dbo].[NPCResource]  SET[spawn_type] = 0  WHERE [contact_script] LIKE '%Secroute%'
ThunderNikk is offline  
Old   #1767
 
elite*gold: 0
Join Date: May 2013
Posts: 43
Received Thanks: 1
Ok! And I want to know the line to pop a Butkadah to me
Pyrochina is offline  
Old   #1768
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,045
Received Thanks: 979
Quote:
Originally Posted by Pyrochina View Post
Ok! And I want to know the line to pop a Butkadah to me
/run add_npc(X, Y, MOB-ID, HowMuch)

Butkadah 20185001

To find your X, Y

/position
ThunderNikk is offline  
Thanks
2 Users
Old   #1769
 
elite*gold: 0
Join Date: Nov 2011
Posts: 10
Received Thanks: 0
when i make "T game.cash_usable_server:0" then always getting sql error and cant start server, if is at 1 then it works.

How to make npc seller and add item to him, same thing with npc buff.
matedgo is offline  
Old   #1770
 
elite*gold: 0
Join Date: May 2013
Posts: 43
Received Thanks: 1
Need Help plz.

Can't log in to server (Log in error message):


Game Server

Code:
S:app.name:game001
N:auth.server_idx:1
S:auth.server_name:Test
S:db.c._password:
S:db.c.account:sa
S:db.c.name:Arcadia
S:db.c.server:127.0.0.1
S:db.user._password:
S:db.user.account:sa
S:db.user.server:127.0.0.1
N:game.AdultServer:0
F:game.ally_pcbang_bonus_rate:0.1
F:game.ally_pcbang_chaos_bonus_rate:0.1
N:game.broadcast_event_item_pickup:0
N:game.cash_usable_server:1
F:game.chaos_drop_rate:1
N:game.check_storage_security_always:0
N:game.enhance_fail_type:2
F:game.exp_rate:1
F:game.gold_drop_rate:1
F:game.item_drop_rate:1
N:game.limit_field_logout:0
S:game.local_setting_list:log.ip|log.chat.ip|io.au th.ip|io.ip_address|db.c.server|db.user.server|N game.periodical_npc_adjustment
F:game.mod:0.2
N:game.pcbang_bonus_server:0
F:game.premium_pcbang_bonus_rate:1
F:game.premium_pcbang_chaos_bonus_rate:0.1
N:game.restrict_banword_for_booth:1
N:game.use_auto_jail:0
N:game.use_auto_trap:0
N:game.use_delete_security:0
N:game.use_play_point:0
N:game.use_security:0
N:game.use_storage_security:0
N:io.max_connection:5000
N:log.chat.working:0
N:game.ServiceServer:1
S:game.caution_url:http://IP/upload/client/popup/default.aspx
S:game.guild_icon_base_url:http://IP/upload/client/guild/
S:game.server_screenshot_url:
N:game.update.version:24
S:game.url_list:guild.url||http://IP/client/guild/login.aspx|gu...load.port|4615
N:game.version:200610030
S:io.auth.ip:127.0.0.1
S:io.ip_address:25.97.227.214
S io.port:4504
S:log.ip:127.0.0.1
N:game.disable_buy_booth:0
S:io.upload.ip:127.0.0.1
S:io.upload.port:4616
S:upload.server_name:game001
N:game.disable_trade:0
N:game.disable_booth:0
S:console.allow_ip:127.0.0.1
S:console._password:
Auth

Code:
 S db.auth.server:127.0.0.1
S db.auth.name:Auth
S db.auth.account:sa
S db.auth._password:
S db.auth.port:1433
S io.auth.port:8841
S app.name:auth
N game.user_limit:3000
N auth.max_client_per_ip:30000
S log.ip:127.0.0.1
N _auth.version:200604290
N auth.version:200701120
N auth.max_daily_client_per_ip:50000
S db.auth.md5_key:5412
N db.auth.use_md5:1
N db.auth.use_md5_for_security_no:0
N billing.user_keep_alive_interval:30000
Start

Code:
 Start SFrame.exe /auth_ip:25.97.227.214 /auth_port:8841 /locale:ASCII /country:US /cash /commercial_shophelp_url_w:620 /help_url_h:633


Pyrochina 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 14:42.


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.