Leaderboard

Dude, school knowledge is one thing, experience another... Redundancy isn't always a bad thing. It can boost the performance and useablity. I'm working with SQL databases everyday and know many companies which do so. Neither me nor one of those campanies uses the foreign key enigine which is shipped with the SQL server. Why this? Pretty simple... Your application should manage the data and the processes, not the SQL server. The SQL server is just a stupid data holding backend which should be replaceable in no time. When you pack it with tons of business logic that's nearly impossible...

E - Script Collection Last Update : September 10, 2013 Refine Function SQL Mission Board Monster Marching Vendor Control Advanced Stylist Coin Exchanger Doppelganger Race Of The Day Limited Items Multi Currency Shop Random News GM Online List Link Broken E-Inquiry DotA Runes Flower Counting Game Class Restriction Chain Quest Build Manager Misc Scripts : Freebies Script Card Trader Gold Room [ Pick Gold ] Gold Room [ Guild Tax ] Map Restriction [ GM Based ] Daily Reward Monthly Reward Monster Spawner Monster Summoner with Last Summoned Display Players Stats & Equipments 3rd Job Item Giver Exchanger [ Cashpoint to Coins ] Exchanger [ Poring Coin - Zeny ] Exchanger [ Points to Tickets ] Exchanger [ Item to Item ] Exchanger [ Item to Item ] Exchanger [ Multi Item to 1 Item ] Party Match Auto Ban Over Stats Users Soul Link Buff Kill Players gain Cash Points Party Members All Get Items [ Snippet ] Message Board Stalker Class Skill Reproduce NPC Multiple Selection Quest [ Template ] In-Game Item Rewarder In-Game Points Rewarder Invasion Event Custom Item Rate Status Point Seller [ Snippet ] Anti Bot Security Script Anti Bot Script [ Code / Question ] Item Combo Restriction [ LHZ Card ] Drop Item Upon Death PVP Switcher + Announcer [ Guild Master ] Rotating Waitingroom Messages +10 Refiner [ Specific Items ] Random Rate Item Exchanger MVP Invasion Premium Users [ Boost Rates ] Display Cutin Image upon Login Custom Randomed Box Items Kick GM during WOE Custom Crafting NPC Restrict Same IP [ Certain Map ] Coloured Items Exchanger Guild Master Changer Party Team PK Match Gambling Game IRC Channel Crafting NPC Guild Storage Restriction Stage Game [ Version 4 ] Monster Wiki Event [ Version 3 ] Special Thank you for my Tutor : Notes : I am a bit lazy to write all those Script Descriptions, i do believe that all of you able to get how this script works. Anyway, i will still doing my best to write the Updated Changelog or informations about the script as detail as possible. All the Scripts above are uploaded to Pastebin . Abide the Following Rule : Scripts Error / Not Working , you have to Explain it in Details. ( Add in Images / Modified Scripts ) Do not SPAM / BUMP in my Topic. Do not ask for Support stuffs for other Scripts in this Topic. Link Down , then drop [ @Emistry ] a message. I Reserved the Right for NOT Answering your Posts if you did not abide my Topic's Rules. Keep This In Your Mind : All the Scripts i distribute here are NOT FOR COMMERCIAL USES . DO NOT remove my Credits if you are using part of the scripts to modify your own. DO NOT re-release the scripts in any form / way. If you ♥ these Scripts , Click on to Vote this Topic up. Or you may also click on at above the Topic

Euphy's Scripts Disclaimer You may use, modify, and host all of my released scripts. You may not sell them, re-release them in any way (modified or otherwise), or remove the credits. < Event Manager > < Hunting Missions > < Queue System > < Euphy's WOE Controller > < All-In-One NPC > < Euphy's Quest Shop > < Euphy's Warper > < Item Rewards > < Custom Currency Multi-Shop > < Build Manager + > < Class Mastery System > < Class Specialization > < Badge System > < Guarantee Refine Ticket > < Item Fusion > < Euphy's MVP Ladder > < Card Trader > < NPC Duplicate Generator > < Auto-Potion >

Hi Again!! Well this is a small guide hope u all take it as important guide Softwares And Script Needed:- Calcium Kid renewal FluxCp since this works for both renewal and non renewal so i don't this u have to ask for it. CMS by Calcium Kid Install this before u install the theme [Recommended] Themes By Gerome : u can find on rAthena Forums. ____________________________________________________________________________________________________________________________________ Guide starts Here!! Step 1:- Upload the theme.zip to ur webhost [or whtever extension ur webhost supports] then,put the theme inside ur [flux directory]=>themes folder Mine:- 1: i have named my theme as default , u can Leave it as it is no problem in that i would tell u later why.. 2: the orignal theme must be there for backup DO NOT DELETE IT...it would be like leaving ur girlfriend for the new lady ___________________________________________________________________________________________________________________________________ Step 2:- when the theme is uploaded do the permission for each folder to this for files default one is ok. ___________________________________________________________________________________________________________________________________ Step 3:- In the theme folder u uploaded there are the folders of ur use :- 1: Css: well this the is stylesheet folder u can edit size position etc from this folder details later. 2: font: Well self explanatory 3: img: all the needed images goes here edit according to ur needs 4: gthemes well this is custom folder NOT found in every theme u get, Since i m using Gerome's themes so u would likely to have it every time u use his this [and coz he is the only one providing the themes for free ] GTHEMES FOLDER USE: [the below file it made by Gerome and not by me] The last point "replace default to diabro" here diabro is theme name since i have named the theme as default i don't need to replace but it u do have orignal name u have to do this in order to make ur addons work on the particular theme ___________________________________________________________________________________________________________________________________ Step 4:- Files u can edit for appereance change:- the footer php or header php [i choose the one whose size is larger but by default its the header php] can be edited for ur need, since the theme we are using is scripted user friendly manner u can change or remove the modules like screen shots inside this file. ___________________________________________________________________________________________________________________________________ Step 5:- Inside CSS folder :- 1: Images : well its not for ur use so just check it once since i know peoples have curiosity and close it:P 2: img: here ur backgroud and other nessasary files goes u can edit them according to ur need. 3: flux.css: its the style sheet for flux u don't need to edit it untill u have very much experimental nature. 4: main.css : the main stylesheet for the theme u can edit it for modules size and othe specifications. ___________________________________________________________________________________________________________________________________ Step 6:- Since From my side all Work is done Relace this :- 1: since i named my theme folder default i wont take pain to replace this but if u don't just replace it by the folder name of ur theme. +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ IF u Have Done EveryThing Well Manned U will See This:- if not then dude please check ur configs. |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||_____________________________FINISHED_______________________||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| ***************************************************************************************************************************************************************************************** *All Trademarks and themes are property of : . *CMS and flux is made by Calcium Kid *Guide is made by me although *Please Do Comment if u read this guide,i really like it!! ********************************************************************************************************************************************************************************************* sorry for my bad grammer though i would correct it when i have time

In reference to this and all future post. Please avoid making this topic into a Support Topic of all kinds. Part 1 - Setting up your server. http://tinyurl.com/7dcwdz2 Part 2 - Getting onto your server. http://tinyurl.com/7nqunos Part 3 - All about groups.conf and setting server admins and GM's. http://tinyurl.com/7u6c442 Part 4 - Adding custom NPCs http://tinyurl.com/8x359bt

File Name: Instanced PvP File Submitter: Hoshiro File Submitted: 06 Jan 2011 File Category: PvP, GvG, WoE http://www.eathena.ws/board/index.php?showtopic=253019 This script is a Instance Duel Pvp NPC. Here some Explanation how it works Its Working now!!!!! Explaination: It´s a new Instance that is created for exactly 2 People. The Main Npc will create the instance for you. After creating you can chose to enter the Instance. This will warp you to 1@pvp There begins an announce e.g. 4... 3... 2... 1... GO!!.. Then starts @pvpon You will fight till one die! And for the Finish it warps you back and so far it will destroy Instance after it. Guide how to add is on the Readme.txt Credits to Me for creating xDDDDD Credits to Davven for his map. Credits to Masao for his support. Click here to download this file

Well since I was tortured at school with database designing I thought I will give it a try and post some of my ideas in here. What I am talking about is the whole structure of the current (SQL) database. A lot of data is saved redundant and the integrity of the data is not given on database side. Why is this important? So let us say some user edits some of their entries in the character table. Something went wrong with the saving of a wedding and it is only partially stored into the database. The administrator puts the id of the husband/wife manually into the database and does a typo with the ID of the character. He will not be able to recognize his mistake at that point of time, but he will have to look for it later on. And that is a problem that could easily be fixed with the usage of foreign keys. But there would be a lot more of awesome features like for example check constraints which are not featured by MySQL but there still is a workaround for it. This could be used to check buy/sell price values. That is something that came to my mind when I was told about a bug that existed on euRO about 2 weeks ago, where you could buy some item for 1000z which would give you 1000z on usage, but that one could be sold for ~1300z to the npc because the database definition was wrong. So my question here is: Would the developers want someone who redesigns the database or do they even care about the ideas I mentioned above? If you want me to do it or to give you a small preview or something, I would not mind. I just do not want to design the whole database and it is not used afterwards. So let me know, if you do not want to discuss this matter publicaly, let me know how we can talk these things out.

Thanks. It worked. But now, I cant see the name of the Jobs. What I can only see now was Blvl/*Blank*/Jlvl/Exp. The blank part was supposed to be the job name right? How can I return it back? try to change the diff of your client. Increase Headgear View ID make it 2000 or 4000.

Hi manabeast, Just edit the root user and add a password in the 'Users' tab.

change your langtype from 0 to 1

it will only show when you have meet the minimum point to exchange to bronze coin

try this prontera,155,181,5 script Sample 757,{ switch( select( "Enter Greedy Points Room", "Exchange Points to "+getitemname(.CoinID), "Check Points", "Exit" ) ){ Case 1: warp .Map$,0,0; end; Case 2: mes "You got "+#Points+" Points."; mes "How many will be used to change into "+getitemname(.CoinID)+" ?"; mes "Each "+getitemname(.CoinID)+" = "+.Rate+" Points."; if( #Points >= .Rate ){ input .@Amount,0,#Points; set .@Calculation,( .@Amount / .Rate ); if( .@Calculation ){ set #Points,#Points - ( .@Calculation * .Rate ); getitem 673,.@Calculation; mes "Gained "+.@Calculation+" x "+getitemname(.CoinID); } } close; Case 3: mes "You got "+#Points+" Points."; default: break; } close; OnInit: set .Map$,"guild_vs5"; set .CoinID,673; set .Rate,10; monster .Map$,0,0,1002,100,strnpcinfo(0)+"::OnKilled"; end; OnKilled: set #Points,#Points + rand(1,2); monster .Map$,0,0,1002,1,strnpcinfo(0)+"::OnKilled"; end; }

Or you can go to your database of ragnarok and put your guild id (preferably your GM Guild) on all castle table... that would be an easier method. To get your guild id, go to your fluxcp and check your guild name there to find your guild id.

I think the reason why some data is saved redundant (for example some guild table fields) is, because of the possibility to run the login, char and map server stuff in different databases. So you couldn't get the data with joins and we could use foreign keys only for tables of the same server. And currently MyISAM is used as storage engine, we would have to switch to InnoDB to use foreign keys (MyISAM doesn't support them).

Tested on latest fluxcp-renewal with GMail settings (mentioned here) and it worked. I received the email, I clicked the confirmation link, and the account can now be accessed. 'RequireEmailConfirm' => true, // Require e-mail confirmation during registration. ... 'MailerFromAddress' => '[email protected]', // The e-mail address displayed in the From field. 'MailerFromName' => 'Xantara - CP', // The name displayed with the From e-mail address. 'MailerUseSMTP' => true, // Whether or not to use a separate SMTP server for sending mail. 'MailerSMTPUseSSL' => true, // Whether or not mailer should connect using SSL (yes for GMail). 'MailerSMTPUseTLS' => false, // Same as above SSL setting, but for TLS. This setting will override the SSL setting. 'MailerSMTPPort' => 465, // When MailerUseSMTP is true: SMTP server port (mailer will default to 25). 'MailerSMTPHosts' => 'smtp.gmail.com', // When MailerUseSMTP is true: A string host or array of hosts (e.g., 'host1' or array('host1', 'backuphost')). 'MailerSMTPUsername' => '[email protected]', // When MailerUseSMTP is true: Authorized username for SMTP server. 'MailerSMTPPassword' => '****', // When MailerUseSMTP is true: Authorized password for SMTP server (for above user). Note: Input for 'MailerSMTPPassword' has been starred out. Also, if you think there is a bug with FluxCP, please also send in an issue (here) so that CalciumKid (and others) are aware and can look into it. (You can still inquire about it on rA boards but an email notification is sent to the us if an issue is created =p)