Jump to content

Bifrost

Members
  • Posts

    17
  • Joined

  • Last visited

Everything posted by Bifrost

  1. Bifrost

    cell_pvp

    Thanks, I'll try that.
  2. Bifrost

    cell_pvp

    I'm terribly sorry for triple posting, but Zimtkeks said it was possible, so I still have hope... :/ Tried something myself and couldn't compile afterwards.
  3. I'm still using the PayPal sandbox which allows me to test the system on a safe environment, however, I'm quite certain this should already be enabled.
  4. Updated, bump. Still having problems. Could anyone help me?
  5. Bifrost

    cell_pvp

    I still need this. Could anyone help?
  6. Bifrost

    cell_pvp

    Nope, I want an arena in the middle of my main town that has PvP turned on. It doesn't need a pvp counter, I just want players to be able to fight IN there and not outside.
  7. Bifrost

    cell_pvp

    That's actually exactly what I'd like to do.
  8. Bifrost

    cell_pvp

    I'd like to make a PvP arena in a specific area of my main town. I know I could work with cell_basilica, but that would show the PvP counter to all players on the map. Could someone make a working cell_pvp cellflag that I could use?
  9. Nevermind, I'm retarded. Sorry. :x
  10. I'm using the pre-RE mob DBs, but the spawns are set in npc/mobs/ files. There are no different ones for RE and pre-RE (At least not for me).
  11. Hey there. I disabled pretty much any RE stuff on my server, however, the spawn locations of mobs are still RE. Is there any simple way to revert them to pre-RE? Something like importing eAthena files? Any help would be appreciated, thanks.
  12. Hey there. I set up FluxCP and the donation module. I tested the transaction process with the PayPal sandbox. I had no trouble receiving donations - they got through to my PayPal account - however, the buyer did not receive any credits as the SQL tables were not filled with data. Any idea what might be causing this? I'm out of ideas. I can provide additional information as needed.
  13. It wasn't the input part that was causing problems for me. The check of the ##owner variable didn't work properly. I fixed the problem by now (you can see the complete scripts in my second post), but I appreciate the help, thanks.
  14. I haven't scripted in athena for a few years - and I have never been good at it - so I have no idea what you're saying. Thanks for the input though, I appreciate it.
  15. Set would specify the variable for my own account, however, I need to specify the value for other accounts.
  16. The sql_query in my first snippet inputs the owner variable into the global_reg_value table. I'm trying to read it from there. I got it working after trying to fix it for a few hours. I have no idea how I did it, but here is the complete script (placeholder warp locations) : prontera,162,188,3 script Butler 862,{ if (getgroupid() == 99) goto T_GM; set .@accid, getcharid(3); query_sql "SELECT `account_id` FROM `global_reg_value` WHERE `str`='##owner' AND `account_id`='"+.@accid+"' AND `value`='1'", .@accid2; if (.@accid == .@accid2){ mes "[butler]"; mes "Would you like to visit your house?"; next; menu "Yes",T_Warp2, "Visit all houses",T_Warp, "No",quit; next; close; } mes "[butler]"; mes "I see you do not yet own a house. Are you interested in buying one?"; next; menu "Tell me more",T_More,"No",quit, "Warp me to the houses",T_Warp; next; T_More: mes "[butler]"; mes "Houses allow you to have some private space on the server with your own NPCs."; mes "They are available to all characters on your account and you're allowed to"; mes "bring a friend to your house aswell, however, they will not be able to use"; mes "any of the offered NPC services."; next; mes "[butler]"; mes "Houses are largely customizable so no house will be the same."; mes "We also offer guild houses for a larger group of players, however,"; mes "this service will cost a lot more."; next; mes "[butler]"; mes "If you would like to buy a house, please check the forum post by Odin."; close; T_Warp: warp "himinn",48,82; close; T_Warp2: warp "prt_in",95,169; close; T_GM: mes "Hi."; next; menu "Add house owner",T_Add, "Close",quit; next; T_Add: input .@aid; if (.@aid <= 0) goto T_Fail; if (.@aid > 2099999) goto T_Fail; if (.@aid < 2000000) goto T_Fail; if (.@aid != 0){ query_sql "INSERT INTO `global_reg_value` (`char_id`, `str`, `value`, `type`, `account_id`) VALUES ('0','##owner','1','1','"+.@aid+"')"; } end; close; T_Fail: mes "[butler]"; mes "Invalid Account ID"; close; quit: close; }
  17. I'm trying to implement a housing system for my server that allows me as an admin to add house owners through the NPC menu. When the NPC successfully checks for the admin group_id, they are allowed to input an integer (account_id of a player) that is then passed on as variable to the SQL server. T_Add: input .@aid; if (.@aid <= 0) goto T_Fail; if (.@aid > 2099999) goto T_Fail; if (.@aid < 2000000) goto T_Fail; if (.@aid != 0){ query_sql "INSERT INTO `global_reg_value` (`char_id`, `str`, `value`, `type`, `account_id`) VALUES ('0','owner','1','1','"+.@aid+"')"; } The SQL query works fine and is passed to the server without problems. However, the account which is supposed to be a houseowner now is not detected by the NPC. I check for the variable (##owner) at the beginning of the script. if(##owner==1) goto T_Owner; I have tried many variations of this, but it seems none of them are working. The account is always detected as non-houseowner. Could someone tell me what I'm doing wrong?
×
×
  • Create New...