Leaderboard

original by Napster ( https://rathena.org/board/topic/97889- ) equivalent ExtendedVendingSystem_1.9.4_r15149.diff very recommend use clean server for this patch. back up your server first before patch and use as your own risk. Step 1: download patch.diff and place to rAthena working directory. Step 2: in Git Bash, browse to rathena directory (cd command) and execute this command. patch -p1 -l < patch.diff or git apply patch.diff result should be. Step 3: migrate database by command. mysql --user=dbuser -p dbname < sql-files/upgrade_extended_vending_item.sql Step 4: re-compile. Step 5: start the server. test result with rAthena server commit "f8a8c9fe798c315a3a340eb5a484d275c5c543b2" (24 August 2016) Edit: Updated 10 August 2016 patch.diff

File Name: FIXED*Slot Machine + Bevarage Vending Machine (Simulate Vending Machine System) File Submitter: yuchinin File Submitted: 08 Feb 2016 File Category: Games, Events, Quests Content Author: Yuchinin //===== rAthena Script =======================================//= Slot Machine + Bevarage Vending Machine (Simulate Vending Machine System)//===== By: ==================================================//= Yuchinin//===== Current Version: =====================================//= 1.1//===== Compatible With: =====================================//= rAthena Project//===== Description: =========================================//= A custom slot machine and vending machine I make few years ago.//= Using my Simulate Vending Machine System//= Need to insert coin to operate.//= It can also eject remaining coin for you.//= [ Note ] This is an rewrite from GmOcean Slot Machine.//= Part of the slot machine code are credited to GMOceon.//=====******** Note ********=================================//= This script need my release of://= 1. Common Useful Function (common.txt)//= Better let it load first before adding my other script.//= 2. You must also add vendingMachine.grf to your DATA.ini else it will not working properly//= 3. [Note] Some of the item data has been change ( 673,677,674,11506 ~ 11512 )//===== Additional Comments: =================================//= 1.0 Initial release.//= 1.1 Fixed F_Beverage function not found error and also add the iteminfo description file//============================================================ Click here to download this file

Hi all, Sometime last year I started working on a Ragnarok client. (Again...) It's very close in behavior to the original client, using DirectX and the original 3rd party libraries (granny2.dll, mss32.dll etc). It doesn't have a name yet, but I like to think of it as my "SakExe", since that's what it's based on. At this point it can be used for basic gameplay, though much of the user interface is still missing, as well as a lot of the effects. Recently I've made a few changes, making an alternative rendering implementation using OpenGL. After a little work I was able to compile my client for Linux and finally Android. I'll use this topic as a showcase/work log. Feel free to ask any questions. And now for some pictures... DirectX mode on Windows 8. Some features like the Granny3D actors are only supported on Windows. It's working great on Android, although some additional tweaks are needed to make it more accessible. What I've done so far is to scale the UI to make it easier to hit buttons, and adding touch gestures for things like camera rotation. This is with OpenGL ES rendering on my x86 Android phone (1920x1080). It also runs on 32 bit ARM. I've been testing it on both my newest phone and my old Samsung Galaxy Note II, the latter of which is a little over 3 years old at this point. Originally I got like 0.5~2 FPS on my phones with my naive GL renderer, but after some work the performance it pretty solid on both of my phones.

//===== rAthena Script ======================================= //= Common Useful Function //===== By: ================================================== //= Yuchinin //===== Current Version: ===================================== //= 1.2 //===== Compatible With: ===================================== //= rAthena Project //===== Description: ========================================= //= A common useful function I wrote these few years. //= Hoping with these can help other to write useful script. //=====******** Note ********================================= //= This will be the core of my other script. //= Better let it load first before adding my other script. //===== Additional Comments: ================================= //= 1.0 Initial script. //= 1.1 Change function arrdel from using 'value' to 'index' //= 1.2 Fixed sql query bug //============================================================ Function List: //=================================== //= walktonpc({<unitid>,<distance>}) //= walk character in npc <distance> //=================================== //=================================== //= npcindistance(<distance>) //= check if distance with npc smaller or equal to <distance> //= return to the caller //= else walk in npc <distance> //=================================== //=================================== //= getVariable(<"npc variable name">,{"<owner>"}) //= return variable value //= owner will be calling npc if omitted //=================================== //=================================== //= setVariable(<"npc variable name">,{<"owner">}) //= set variable value //= owner will be calling npc if omitted //=================================== //=================================== //= arradd("<arrayname>",<value>,{<"owner">}) //= add value to array //= owner will be calling npc if omitted //=================================== //=================================== //= arrdel("<arrayname>",<index>,{<"owner">}) //= delete index from array //= owner will be calling npc if omitted //=================================== //=================================== // arrhas("<arrayname>",<value>,{<"owner">}) //= check if value in array //= return 1 if in else return 0 //=================================== //=================================== // arrfind("<arrayname>",<value>,{<"owner">}) //= return first found value index in array //= return -1 if not found //=================================== //=================================== // arrselect("<arrayname>",{<"label">,"<owner>"}) //= return selected array value after selection //= label add before selection //= owner will be calling npc if omitted //=================================== //============================== //= UpperFirst("<string>") //= return string with first string capital //============================== //========================================= //= getRemain(<sec>) //= return remaining time string //========================================= //========================================= //= CStr(<"string to change color">,{<"color name">}) //= return string with selected color //========================================= //========================================= //= CZeny(<zeny>,{<"delimiter">,<"symbol">}) //= return ease look zeny string //========================================= //========================================= //= Itemlink(<itemid>) //= return item string with itemlink added //========================================= // Below is custom inventory system for npc //=================================== //= invcount("<owner>") //= return inventory count //=================================== //=================================== //= invcountitem(<itemid>,"<owner>") //= return item count in inventory //=================================== //=================================== //= invselect("<owner>","<blacklistid>","<label>") //= add label before selection //= return itemid after selection //=================================== //=================================== //= invgetitem(<itemid>,"<owner>",{<amount>}) //= return itemid if success //= return 0 if fail //=================================== //=================================== //= invhasitem(<itemid>,"<owner>") //= return itemid if have item //= return 0 if don't have item //=================================== //=================================== //= invdelitem(<itemid>,"<owner>",{<amount>}) //= return itemid if success //= return 0 if fail //=================================== //=================================== //= invclear("<owner>") //= clear all inventory //=================================== download: https://rathena.org/board/files/file/3432-common-useful-function/ Git: https://github.com/Yuchinin/rathena-script/blob/master/common.txt

Its done using a select and putting a WHERE like the one that Emistry do, but i really dont understand why you did this custom table, because al the information that you put there you can have it instantly in any script whitout doing a sql query, with the strcharinfo and getcharid that you just doed to put that information in the table... in any case, if you put another thing i might understand...

..... WHERE `char_id` = "+getcharid(0)+" ........