HristDead

Thank you, this one works!

Tried this but it also kicks the second client of the player that uses an whitelist IP, while i want whitelist IPs to allow 2 clients.

Aah, it doesnt seem to work the way I am looking for after all. >.< What I am looking for is... Player IP/accounts which arent listed in the IP whitelist can open ONLY ONE client in mentioned maps. Player IP/accounts that are listed can open ONLY TWO clients in mentioned maps. Is that possible, sir Capuche?

No, only for the maps in the oninit if possible. I want players in the same household to be able to play WoE and BG together, but still to make it so that they can not open unlimited clients (2 max.) on these maps to avoid an unfair advantage. Also that script seems to work fine! thank you

Hi Capuche, I tried that but it kicks my second client. I want the second client to be allowed for the whitelisted IPs, but have the third client kicked. (So two players in the same household can play together)

I found this script and wanted to request a few additions... 1) How to make it works per multiple maps? ex. prtg_cas01 and aldeg_cas01? (Currently only works on 1 map) 2) How to make it so that the accepted/whitelist IP can only open a max of two clients in these maps? (Currently allows unlimit clients) I have asked for a solution on other forums, but their solution it didnt work. D: Can rAthena please help? - script WoE_IP_Kick -1,{ OnInit: setmapflag "prtg_cas01", mf_loadevent; set .whitelist$, "xx.xx.xx.xx | xx.xx.xx.xx"; end; // Trigger when a player enters a map with "loadevent" mapflag. OnPCLoadMapEvent: // Only run for map "prtg_cas01". if (strcharinfo(3) != "prtg_cas01") end; set .@my_ip$, getcharip(); if ( compare( .@my_ip$, .whitelist$ ) ) end; // Get list of accounts with attached character's IP address. set .@size, query_sql("SELECT `account_id` FROM `login` WHERE `last_ip` = '"+ .@my_ip$ +"'",.@aid); // Passed check if only the attached player is returned. if (.@size < 2) end; // Check all online characters using the IP address if they are on a Battlegrounds map. set .@self, getcharid(3); for(set .@i,0; .@i<.@size; set .@i,.@i+1) { if (.@aid[.@i] == .@self) continue; if (attachrid(.@aid[.@i])) { if (compare(strcharinfo(3),"prtg_cas01")) { set .@name$, strcharinfo(0); attachrid(.@self); message strcharinfo(0),"Character "+.@name$+" is already present in this map with your IP. Kicking...."; sleep2 2000; atcommand "@kick "+strcharinfo(0); end; } } } // Passed check. end; }

I believe this belongs in source because I've made all client changes possible... On my server i have third job suits (change appearance of your second job), but the problem is, when a level 99 player equips this, the aura disappears. Is there any way i can have a aura for it, for a level 99 third job? Thank you.

Hi rAthena, I'm using Feefty's support ticket system and this script came along with it (see bottom) this script checks for support tickets. As of now, all the support tickets are showing except the ones that got deleted... I want the "solved" and "closed" ones to not appear when I use @checkunread / @cu in-game. In the sql database status 0 and status 2 are closed and resolved if that helps anything. I need a query for that to exclude these statuses but i cant figure it out, this is what i have so far: query_sql("SELECT status = 0 FROM cp_support_tickets"); set .@sql$, .@sql$ - "1"; Thanks so much who can figure this out for me! Whole script (unedited yet): - script atcmd_ticket_notify -1,{ OnInit: bindatcmd("checkunread", "atcmd_ticket_notify::OnAtcommand"); bindatcmd("cu", "atcmd_ticket_notify::OnAtcommand"); end; OnAtcommand: set .@unreadmsg$, "You have %d unread support tickets."; set .@sql$, "SELECT id, department, ticket_read FROM cp_support_tickets WHERE "; if (getgmlevel() > 0) { set .@sql$, .@sql$ + "1"; } else { set .@sql$, .@sql$ + "account_id = " + getcharid(3) + " AND unread = 1"; } set .@count, query_sql(.@sql$, @id, @department, @ticket_read$); if (.@count) { if (getgmlevel() == 0) { dispbottom(sprintf(.@unreadmsg$, .@count)); end; } if (.@count > 1) { set .@ticket_count, 0; for (set .@i, 0; .@i < getarraysize(@id); .@i++) { set .@isRead, 0; query_sql("SELECT group_id FROM cp_support_dep WHERE id = " + @department[.@i], @group_id); if (@ticket_read$ != "") { explode(.@tickets_read$, @ticket_read$[.@i], ","); for (set .@j, 0; .@j < getarraysize(.@tickets_read$); .@j++) { if (atoi(.@tickets_read$[.@j]) == getcharid(3)) { set .@isRead, 1; break; } } } if (@group_id <= getgmlevel() && .isRead == 0) { .@ticket_count++; } } dispbottom(sprintf(.@unreadmsg$, .@count)); end; } else { query_sql("SELECT group_id FROM cp_support_dep WHERE id = " + @department, @group_id); set .@isRead, 0; if (@ticket_read$ != "") { explode(.@tickets_read$, @ticket_read$, ","); for (set .@j, 0; .@j < getarraysize(.@tickets_read$); .@j++) { if (atoi(.@tickets_read$[.@j]) == getcharid(3)) { set .@isRead, 1; break; } } } if (@group_id <= getgmlevel() && .@isRead == 0) { dispbottom(sprintf(.@unreadmsg$, .@count)); end; } else { dispbottom(sprintf(.@unreadmsg$, 0)); end; } } } else { dispbottom(sprintf(.@unreadmsg$, 0)); end; } end; }

Hi rAthena Is this possible? What i want is to have the purchase page from flux lead to another page that is different from my website theme. The problem is, with my theme i do not like how it looks if i fill it with items. It looks off and messes up with the borders. Maybe that is because the images are too large. I prefer something like a simple page opens (or even the default flux purchase page but without other subcategories on the side). Is it possible? Help is much appreciated! ^^

Thanks Emistry and GMOcean. I am not worried about too much item in storage, if I give box treasures i will only be 1 of 1 item. Mailbox would be a nice idea.. is that hard to do? Thanks for the help so far.

Aw, not possible?

Too many selfish guild owners in my server... i want to try to avoid this this. I'm looking for some sort of box item script. Say a guild master/castle owner opens/clicks this box item, then all the guildmembers get the item that the box contains. Preferably must go through an IP check to avoid abuse too. Offline and online member get item! Thank you so much rAthena.

Omg it's that easy! Thank you Emistry!

Hello rAthena, I've browsed ths entire forum and old eathena forum but suprisingly i couldn't find a answer to this. Am I really the first to ask? What i am looking for is a script (for a card or something), that when you compound the card in a weapon (or whatever equipment), you get an additional 10% experience from every monster in-game, except bosses. Pretty much a permanent Battle Manual idea. Is a script like this possible? Thanks!

that is weird. i put the correct info. x.x do i need to request my host to open certain ports?

did that, now it says this string(105) "SQLSTATE[28000] [1045] Access denied for user 'root'@'us10.la.thewebhostserver.com' (using password: YES)" NULL

changed but still not work

The page (www.----.com/merchant_db) now says "NULL". [26-Aug-2013 05:51:00 America/Los_Angeles] PHP Fatal error: Call to a member function setErrorCallbackFunction() on a non-object in /home/server/public_html/merchant_db/config.php on line 10 [26-Aug-2013 05:51:01 America/Los_Angeles] PHP Fatal error: Call to a member function setErrorCallbackFunction() on a non-object in /home/server/public_html/merchant_db/config.php on line 10 [26-Aug-2013 05:51:02 America/Los_Angeles] PHP Fatal error: Call to a member function setErrorCallbackFunction() on a non-object in /home/server/public_html/merchant_db/config.php on line 10 [26-Aug-2013 05:51:03 America/Los_Angeles] PHP Fatal error: Call to a member function setErrorCallbackFunction() on a non-object in /home/server/public_html/merchant_db/config.php on line 10 [26-Aug-2013 05:51:04 America/Los_Angeles] PHP Fatal error: Call to a member function setErrorCallbackFunction() on a non-object in /home/server/public_html/merchant_db/config.php on line 10 [26-Aug-2013 05:51:04 America/Los_Angeles] PHP Fatal error: Call to a member function setErrorCallbackFunction() on a non-object in /home/server/public_html/merchant_db/config.php on line 10 [26-Aug-2013 05:52:39 America/Los_Angeles] PHP Fatal error: Call to a member function setErrorCallbackFunction() on a non-object in /home/server/public_html/merchant_db/config.php on line 10 [26-Aug-2013 05:55:06 America/Los_Angeles] PHP Fatal error: Call to a member function setErrorCallbackFunction() on a non-object in /home/server/public_html/merchant_db/config.php on line 10 [26-Aug-2013 07:56:06 America/Los_Angeles] PHP Fatal error: Call to a member function setErrorCallbackFunction() on a non-object in /home/server/public_html/merchant_db/config.php on line 10 [26-Aug-2013 11:49:40 America/Los_Angeles] PHP Fatal error: Call to a member function setErrorCallbackFunction() on a non-object in /home/server/public_html/merchant_db/config.php on line 12 [26-Aug-2013 11:49:45 America/Los_Angeles] PHP Fatal error: Call to a member function setErrorCallbackFunction() on a non-object in /home/server/public_html/merchant_db/config.php on line 12 [26-Aug-2013 11:50:32 America/Los_Angeles] PHP Fatal error: Call to a member function setErrorCallbackFunction() on a non-object in /home/server/public_html/merchant_db/config.php on line 12 [26-Aug-2013 11:50:32 America/Los_Angeles] PHP Fatal error: Call to a member function setErrorCallbackFunction() on a non-object in /home/server/public_html/merchant_db/config.php on line 12

Thanks sanasol, it only gives me 1 error now on this line: $db->setErrorCallbackFunction("print_r", "text"); [26-Aug-2013 04:46:52 America/Los_Angeles] PHP Fatal error: Call to a member function setErrorCallbackFunction() on a non-object in /home/server/public_html/merchant_db/config.php on line 11

Updated. still error but less error now! [26-Aug-2013 03:59:32 America/Los_Angeles] PHP Fatal error: Call to a member function setErrorCallbackFunction() on a non-object in /home/server/public_html/merchant_db/config.php on line 11 [26-Aug-2013 04:01:58 America/Los_Angeles] PHP Fatal error: Call to a member function setErrorCallbackFunction() on a non-object in /home/server/public_html/merchant_db/config.php on line 11 [26-Aug-2013 04:02:00 America/Los_Angeles] PHP Fatal error: Call to a member function setErrorCallbackFunction() on a non-object in /home/server/public_html/merchant_db/config.php on line 11 [26-Aug-2013 04:10:36 America/Los_Angeles] PHP Fatal error: Call to a member function setErrorCallbackFunction() on a non-object in /home/server/public_html/merchant_db/config.php on line 11 [26-Aug-2013 04:10:39 America/Los_Angeles] PHP Fatal error: Call to a member function setErrorCallbackFunction() on a non-object in /home/server/public_html/merchant_db/config.php on line 11 [26-Aug-2013 04:13:07 America/Los_Angeles] PHP Warning: require(/home/server/public_html/merch/class.db.php) [<a href='function.require'>function.require</a>]: failed to open stream: No such file or directory in /home/server/public_html/merchant_db/config.php on line 8 [26-Aug-2013 04:13:07 America/Los_Angeles] PHP Fatal error: require() [<a href='function.require'>function.require</a>]: Failed opening required '/home/server/public_html/merch/class.db.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/server/public_html/merchant_db/config.php on line 8 [26-Aug-2013 04:20:15 America/Los_Angeles] PHP Fatal error: Call to a member function setErrorCallbackFunction() on a non-object in /home/server/public_html/merchant_db/config.php on line 11

ah found... [26-Aug-2013 03:25:45 America/Los_Angeles] PHP Warning: require(/home/server/public_html/merch/class.db.php) [<a href='function.require'>function.require</a>]: failed to open stream: No such file or directory in /home/server/public_html/merchant_db/config.php on line 8 [26-Aug-2013 03:25:45 America/Los_Angeles] PHP Fatal error: require() [<a href='function.require'>function.require</a>]: Failed opening required '/home/server/public_html/merch/class.db.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/server/public_html/merchant_db/config.php on line 8 [26-Aug-2013 03:27:10 America/Los_Angeles] PHP Warning: require(/home/server/public_html/merch/class.db.php) [<a href='function.require'>function.require</a>]: failed to open stream: No such file or directory in /home/server/public_html/merchant_db/config.php on line 8 [26-Aug-2013 03:27:10 America/Los_Angeles] PHP Fatal error: require() [<a href='function.require'>function.require</a>]: Failed opening required '/home/server/public_html/merch/class.db.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/server/public_html/merchant_db/config.php on line 8 [26-Aug-2013 03:29:23 America/Los_Angeles] PHP Warning: require(/home/server/public_html/merch/class.db.php) [<a href='function.require'>function.require</a>]: failed to open stream: No such file or directory in /home/server/public_html/merchant_db/config.php on line 8 [26-Aug-2013 03:29:23 America/Los_Angeles] PHP Fatal error: require() [<a href='function.require'>function.require</a>]: Failed opening required '/home/server/public_html/merch/class.db.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/server/public_html/merchant_db/config.php on line 8 [26-Aug-2013 03:29:25 America/Los_Angeles] PHP Warning: require(/home/server/public_html/merch/class.db.php) [<a href='function.require'>function.require</a>]: failed to open stream: No such file or directory in /home/server/public_html/merchant_db/config.php on line 8 [26-Aug-2013 03:29:25 America/Los_Angeles] PHP Fatal error: require() [<a href='function.require'>function.require</a>]: Failed opening required '/home/server/public_html/merch/class.db.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/server/public_html/merchant_db/config.php on line 8 [26-Aug-2013 03:29:27 America/Los_Angeles] PHP Warning: require(/home/server/public_html/merch/class.db.php) [<a href='function.require'>function.require</a>]: failed to open stream: No such file or directory in /home/server/public_html/merchant_db/config.php on line 8 [26-Aug-2013 03:29:27 America/Los_Angeles] PHP Fatal error: require() [<a href='function.require'>function.require</a>]: Failed opening required '/home/server/public_html/merch/class.db.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/server/public_html/merchant_db/config.php on line 8 [26-Aug-2013 03:29:31 America/Los_Angeles] PHP Warning: require(/home/server/public_html/merch/class.db.php) [<a href='function.require'>function.require</a>]: failed to open stream: No such file or directory in /home/server/public_html/merchant_db/config.php on line 8 [26-Aug-2013 03:29:31 America/Los_Angeles] PHP Fatal error: require() [<a href='function.require'>function.require</a>]: Failed opening required '/home/server/public_html/merch/class.db.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/server/public_html/merchant_db/config.php on line 8 [26-Aug-2013 03:32:21 America/Los_Angeles] PHP Warning: require(/home/server/public_html/merch/class.db.php) [<a href='function.require'>function.require</a>]: failed to open stream: No such file or directory in /home/server/public_html/merchant_db/config.php on line 8 [26-Aug-2013 03:32:21 America/Los_Angeles] PHP Fatal error: require() [<a href='function.require'>function.require</a>]: Failed opening required '/home/server/public_html/merch/class.db.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/server/public_html/merchant_db/config.php on line 8 [26-Aug-2013 03:32:31 America/Los_Angeles] PHP Warning: require(/home/server/public_html/merch/class.db.php) [<a href='function.require'>function.require</a>]: failed to open stream: No such file or directory in /home/server/public_html/merchant_db/config.php on line 8 [26-Aug-2013 03:32:31 America/Los_Angeles] PHP Fatal error: require() [<a href='function.require'>function.require</a>]: Failed opening required '/home/server/public_html/merch/class.db.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/server/public_html/merchant_db/config.php on line 8 [26-Aug-2013 03:32:39 America/Los_Angeles] PHP Warning: require(/home/server/public_html/merch/class.db.php) [<a href='function.require'>function.require</a>]: failed to open stream: No such file or directory in /home/server/public_html/merchant_db/config.php on line 8 [26-Aug-2013 03:32:39 America/Los_Angeles] PHP Fatal error: require() [<a href='function.require'>function.require</a>]: Failed opening required '/home/server/public_html/merch/class.db.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/server/public_html/merchant_db/config.php on line 8 [26-Aug-2013 03:34:34 America/Los_Angeles] PHP Warning: require(/home/server/public_html/merch/class.db.php) [<a href='function.require'>function.require</a>]: failed to open stream: No such file or directory in /home/server/public_html/merchant_db/config.php on line 8 [26-Aug-2013 03:34:34 America/Los_Angeles] PHP Fatal error: require() [<a href='function.require'>function.require</a>]: Failed opening required '/home/server/public_html/merch/class.db.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/server/public_html/merchant_db/config.php on line 8 [26-Aug-2013 03:35:54 America/Los_Angeles] PHP Warning: require(/home/server/public_html/merch/class.db.php) [<a href='function.require'>function.require</a>]: failed to open stream: No such file or directory in /home/server/public_html/merchant_db/config.php on line 8 [26-Aug-2013 03:35:54 America/Los_Angeles] PHP Fatal error: require() [<a href='function.require'>function.require</a>]: Failed opening required '/home/server/public_html/merch/class.db.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/server/public_html/merchant_db/config.php on line 8 [26-Aug-2013 03:37:11 America/Los_Angeles] PHP Warning: require(/home/server/public_html/merch/class.db.php) [<a href='function.require'>function.require</a>]: failed to open stream: No such file or directory in /home/server/public_html/vending/config.php on line 8 [26-Aug-2013 03:37:11 America/Los_Angeles] PHP Fatal error: require() [<a href='function.require'>function.require</a>]: Failed opening required '/home/server/public_html/merch/class.db.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/server/public_html/vending/config.php on line 8 [26-Aug-2013 03:37:40 America/Los_Angeles] PHP Warning: require(/home/server/public_html/merch/class.db.php) [<a href='function.require'>function.require</a>]: failed to open stream: No such file or directory in /home/server/public_html/vending/config.php on line 8 [26-Aug-2013 03:37:40 America/Los_Angeles] PHP Fatal error: require() [<a href='function.require'>function.require</a>]: Failed opening required '/home/server/public_html/merch/class.db.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/server/public_html/vending/config.php on line 8 [26-Aug-2013 03:47:17 America/Los_Angeles] PHP Warning: require(/home/server/public_html/merch/class.db.php) [<a href='function.require'>function.require</a>]: failed to open stream: No such file or directory in /home/server/public_html/vending/config.php on line 8 [26-Aug-2013 03:47:17 America/Los_Angeles] PHP Fatal error: require() [<a href='function.require'>function.require</a>]: Failed opening required '/home/server/public_html/merch/class.db.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/server/public_html/vending/config.php on line 8 [26-Aug-2013 03:51:27 America/Los_Angeles] PHP Warning: require(/home/server/public_html/merch/class.db.php) [<a href='function.require'>function.require</a>]: failed to open stream: No such file or directory in /home/server/public_html/merchant_db/config.php on line 8 [26-Aug-2013 03:51:27 America/Los_Angeles] PHP Fatal error: require() [<a href='function.require'>function.require</a>]: Failed opening required '/home/server/public_html/merch/class.db.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/server/public_html/merchant_db/config.php on line 8 [26-Aug-2013 03:51:31 America/Los_Angeles] PHP Warning: require(/home/server/public_html/merch/class.db.php) [<a href='function.require'>function.require</a>]: failed to open stream: No such file or directory in /home/server/public_html/merchant_db/config.php on line 8 [26-Aug-2013 03:51:31 America/Los_Angeles] PHP Fatal error: require() [<a href='function.require'>function.require</a>]: Failed opening required '/home/server/public_html/merch/class.db.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/server/public_html/merchant_db/config.php on line 8

I'm getting a blank page when I go to the www ----.com/merchbase I've followed all the steps though. Any idea?

nice i'll try that thanks!

is that not character-based?

Hi rAthena, I tried searching for a script like this but couldnt find. What im requesting is when a new player signs in he gets 2 cash point., but only one time per account... to avoid they making 10 characters to get cash points. does someone have a script like that? thanks.