Neffletics

The server owner can create an API for you that fetches the vending data. Stop making it complicated, haha.

Your server won't run if login table's missing.

If it's really missing, please run this sql query.

 
CREATE TABLE IF NOT EXISTS `login` ( `account_id` int(11) unsigned NOT NULL auto_increment, `userid` varchar(23) NOT NULL default '', `user_pass` varchar(32) NOT NULL default '', `sex` enum('M','F','S') NOT NULL default 'M', `email` varchar(39) NOT NULL default '', `group_id` tinyint(3) NOT NULL default '0', `state` int(11) unsigned NOT NULL default '0', `unban_time` int(11) unsigned NOT NULL default '0', `expiration_time` int(11) unsigned NOT NULL default '0', `logincount` mediumint(9) unsigned NOT NULL default '0', `lastlogin` datetime NOT NULL default '0000-00-00 00:00:00', `last_ip` varchar(100) NOT NULL default '', `birthdate` DATE NOT NULL DEFAULT '0000-00-00', `character_slots` tinyint(3) unsigned NOT NULL default '0', `pincode` varchar(4) NOT NULL DEFAULT '', `pincode_change` int(11) unsigned NOT NULL DEFAULT '0', `vip_time` int(11) unsigned NOT NULL default '0', `old_group` tinyint(3) NOT NULL default '0', PRIMARY KEY (`account_id`), KEY `name` (`userid`) ) ENGINE=MyISAM AUTO_INCREMENT=2000000; INSERT INTO `login` (`account_id`, `userid`, `user_pass`, `sex`, `email`) VALUES ('1', 's1', 'p1', 'S','[email protected]');  

Try using 127.0.0.1 instead of your VPS' IP in inter_athena.conf

For some reason, it fails when it's not running with admin privileges. Try running as admin.

This might help: http://pastebin.com/Hn02Hw1z

I got it from a Thai Developer that I am working with another game. 

Everything's in our wiki. You should browse it https://rathena.org/wiki/Adding_a_Script

//===== rAthena Script ======================================= //= Reset NPC //===== By: ================================================== //= rAthena Dev Team //===== Current Version: ===================================== //= 1.3 //===== Compatible With: ===================================== //= rAthena Project //===== Description: ========================================= //= Resets skills, stats, or both. //===== Additional Comments: ================================= //= 1.0 First Version //= 1.1 Optimized for the greater good. [Kisuka] //= 1.2 Cleaning [Euphy] //= 1.3 All statuses removed upon skill reset. [Euphy] //============================================================ prontera,150,193,4 script Reset Girl 124,{ .@ResetStat = 5000; // Zeny for stat reset .@ResetSkill = 5000; // Zeny for skill reset .@ResetBoth = 9000; // Zeny for resetting both together mes "[Reset Girl]"; mes "You need premium reset stone each in resetting your skills and Stats"; mes "Reset Stats: Premium Stone + " + callfunc("F_InsertComma", .@ResetStat) + "z"; mes "Reset Skills: Premium Stone + " + callfunc("F_InsertComma", .@ResetSkill) + "z"; mes "Reset Both: 2x Premium Stone + " + callfunc("F_InsertComma", .@ResetBoth) + "z"; mes "Please select the service you want:"; next; switch(select("^FF3355Reset Skills:Reset Stats:Reset Both^000000:Cancel")) { case 1: mes "[Reset Girl]"; if (countitem(6320) < 1) goto NoStone; if (Zeny < .@ResetSkill) { mes "Sorry, you don't have enough Zeny."; close; } Zeny -= .@ResetSkill; delitem 6320,1; sc_end SC_ALL; resetskill; mes "There you go!"; close; case 2: mes "[Reset Girl]"; if (countitem(6320) < 1) goto NoStone; if (Zeny < .@ResetStat) { mes "Sorry, you don't have enough Zeny."; close; } Zeny -= .@ResetStat; delitem 6320,1; resetstatus; mes "There you go!"; close; case 3: mes "[Reset Girl]"; if (countitem(6320) < 2) goto NoStone2; if (Zeny < .@ResetBoth) { mes "Sorry, you don't have enough Zeny."; close; } Zeny -= .@ResetBoth; delitem 6320,2; sc_end SC_ALL; resetskill; resetstatus; mes "There you go!"; close; case 4: close; } NoStone: mes "[Reset Girl]"; mes "You must have a ^FF3355Premium Reset Stone^000000 to continue."; close; NoStone2: mes "[Reset Girl]"; mes "You must have 2 ^FF3355Premium Reset Stones^000000 to continue."; close; } Here you go... Requires 2 stone, changed the welcome message and edited the requirements.

http://www.html-form-guide.com/php-form/php-registration-form.html(same thing)

Just do some tweaking and add reCaptcha.