noheaven

Thanks for this

Sorry if this question is out of place in this topic and forum. I'm currently using eAthena Version SVN r720M, a 3ceam platform. I was curious would this Extended Vending System designed for rAthena will work for me?

Thanks Emistry!

Edited. Might want to check some of your warp coordinates, I picked a random map then it warped somewhere in Rachel, dunno what option of yours did it. http://www.mediafire.com/?j2n0yca1t4jux1h

Capuche, oh my, thank you again, thanks for the time you've spent helping me. the banner_id is supposed to designate the banners from the vote for points system in my fluxCP. Ex. top100 = 1, top200 = 2, etc., but you fixed it and I thank you. 1 More question about this, can I add up these rows without deleting the rows itself and compiling it in one row, it kinda messes out with my v4p system in the fluxCP. Could I possible use this : set .@something, .@var1 + .@var2; while setting those ".@var" to query each banner_id like this: set .@var1, query_sql ("SELECT `credits` FROM `cp_votes` WHERE account_id="+.@account_id+" AND banner_id=1 LIMIT 100,.@points"); and so on and so forth ...

Thank you Capuche, that helped a lot. I got another problem, I fixed the NPC with your help Capuche, but another problem came out, it wouldn't add up the vote points from the SQL DB. Look at account_id column, where it says 2000003 for four columns, the NPC only displays 1 row, meaning every time I check the NPC for points, it only says that I have 5 points but in reality should have 20 points or so. This is my edited NPC script, maybe there's another problem that I don't see that you might see. quiz_02,22,375,6 script V4P NPC 829,{ set .n$,"[Vote Redeemer]"; function getPoints; function delPoints; set .@points,getPoints(getcharid(3)); mes .n$; mes "What would you like to do?"; next; switch(select("- Check Vote Points","- Redeem Vote Points","Cancel")) { Case 1: mes .n$; mes "You have :"; mes "^FF0000"+.@points+"^000000 Vote Point(s)."; close; Case 2: mes .n$; mes "How many you want to"; mes "exchange?"; input .@rpoints; next; if (.@rpoints > .@points) { mes .n$; mes "You don't have enough"; mes "vote points."; close; } else { delPoints(getcharid(3),.@rpoints); getitem 673,.@rpoints; mes .n$; mes "Congratulations~"; mes "Please vote again as soon as"; mes "you can."; close; } default : mes .n$; mes "Come back when you need"; mes "anything else."; close; } end; // END of NPC // FUNCTIONS function getPoints { set .@account_id,getarg(0); query_sql ("SELECT `credits` FROM `cp_votes` WHERE account_id="+.@account_id+" LIMIT 30",.@points); return .@points; } function delPoints { set .@account_id,getarg(0); set .@rpoints,getarg(1); query_sql("UPDATE `cp_votes` SET credits=(credits-"+.@rpoints+") WHERE account_id='"+.@account_id+"'"); return; } } My hypothesis on this is that the NPC only gets the information from the banner_id column if it states that it is banner "1", if so, how can I add up those multiple banners specifically banner "2","3", and "4" and some future banners that I might want to place there.

I've tried doing a script on my own on getting information from the SQL DB, but I can't seem to make it work. I don't know how the problem is and I've read almost every tutorial and examples available, I think I have trouble comprehending these simple 'query_sql' codes. prontera,158,177,4 script v4p 123,{ function getPoints; set .@points,getPoints(getcharid(3)); mes ""+.@points+""; close; end; function getPoints { set .@account_id,getarg(0); query_sql ("SELECT `credits` FROM `cp_votes` WHERE account_id="+.@account_id+" LIMIT 1",.@points); } } I don't what's the problem with this but it won't get the info from my SQL DB. Here's a screenshot of my cp_vote on my SQL DB. Please help. If you can make me a script that can check/delete points, I will be much indebted.

Thank you very much for this.

Hello, I'm kinda new here on this kinds of things, could anyone be kind enough to provide a guide to make this work? Because I downloaded the file, thanks by the way to Jaypee for this, but all I can see are folders and not sure how to use or even where to place them. I've been looking for guides on this but I can't seem to find any around the net.

Thanks a lot ..

Let me get this straight. You have a custom map named 'pvphero'. When you talk to the NPC it will give a buff depending on the Anime you have chosen then warp you to 'pvphero'. Hmm .. Looks interesting, but some buffs may be too overpowered when a certain class gets them. '@speed 1' to a champ or sura, LOL. Reading the script makes my eyes hurt. What is this? 'Tabbing' with steroids? :[