Patskie
-
Posts
1702 -
Joined
-
Last visited
-
Days Won
19
Content Type
Profiles
Forums
Downloads
Jobs Available
Server Database
Third-Party Services
Top Guides
Store
Everything posted by Patskie
-
Yaa haha. didn't comply with his/her requirement. ha ha ha
-
This! HAHA makes me roll on the floor! WTF?! HAHA
-
Sir how will I execute it? http://lmgtfy.com/?q=execute%20sql%20query%20on%20phpmyadmin
-
disablenpc "<npc name (warp)>";
-
There's an upgrade of SQL on SVN 17351. trunk/sql-files/upgrades/upgrade_svn17351.sql Execute this : ALTER TABLE `inventory` ADD COLUMN `bound` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `favorite`; ALTER TABLE `cart_inventory` ADD COLUMN `bound` TINYINT(3) UNSIGNED NOT NULL default '0' AFTER `expire_time`; ALTER TABLE `storage` ADD COLUMN `bound` TINYINT(3) UNSIGNED NOT NULL default '0' AFTER `expire_time`; ALTER TABLE `guild_storage` ADD COLUMN `bound` TINYINT(3) UNSIGNED NOT NULL default '0' AFTER `expire_time`;
-
if (getskilllv(SM_SWORD) <= 5) nude; *getskilllv(<skill id>) *getskilllv("<skill name>") This function returns the level of the specified skill that the invoking character has. If they don't have the skill, 0 will be returned. The full list of character skills is available in 'db/(pre-)re/skill_db.txt'. There are two main uses for this function, it can check whether the character has a skill or not, and it can tell you if the level is high enough.
-
http://rathena.org/board/topic/68468-utility-multi-currency-shop/
-
NPC that gives item if your acc is 1 month old
Patskie replied to Pink Guy's question in Script Requests
Ahh sorry haha me slow mind -
Try prontera,150,150,0 script Sample 100,{ set .@rand,rand(1,10); switch(.@rand) { case 1: mes <1st message>; break; case 2: mes <2nd message>; break; ... case 10: mes <10th message>; break; default: mes "Invalid choice"; break; } }
-
NPC that gives item if your acc is 1 month old
Patskie replied to Pink Guy's question in Script Requests
http://rathena.org/board/topic/83835-request-script-that-give-item-monthly-or-daily/?p=205098 -
Use atcommand on your script atcommand "@size 2";
-
Check mo if tama ung client date mo sa trunk/src/common/mmo.h at ung packet_ver sa trunk/db/packet_db.txt i-default mo
-
Survey NPC is good on your poll request just use search engine to find it
-
Check if your client date sync with trunk/src/common/mmo.h and packet_ver on trunk/db/packet_db.txt
-
account_id is a primary key, meaning all account_id values must be different from one another. In your case, You are duplicating "1" in account_id column which means that there is already an existing "1" value. Hope you understand my english haha
-
How can I change Max Array size in rAthena?
Patskie replied to grobyczen's question in Source Support
Try : trunk/src/map/script.c /// Maximum amount of elements in script arrays #define SCRIPT_MAX_ARRAYSIZE 128 -
Can make everything with encrypted data using MD5() UPDATE `login` SET `user_pass` = MD5('"+<NEW PASSWORD>+"') WHERE `account_id` = '"+getcharid(3)+"'";
-
dunno if this will work on item. didn't try this using items lol. { query_sql "UPDATE `char` SET `name` = '"+escape_sql("<DESIRED NAME>")+"' WHERE `char_id` = '"+getcharid(0)+"'"; }
-
You can ask @Cydh to tweak it and make it a npc instead of a command. But note that this is a paid one.
-
- Npc give quest kill - poring 30 OnNPCKillEvent: if ( killedrid == 1002 ) killed = killed + 1; end; Add a check if a character already killed 30 porings. If so, give the prize : if ( killed != 30 ) end; killed = 0; getitem <id>,<amount>;
-
As far as i know. No script can make a certain character do character select.
