1. select your users from RohanUser.TUser
2. Send to the user's item mall inventory - lets user apply the item to any of his chars.
3. to automate add a where clause to apply restrictions
It helps to understand the Rohan database and table relationships.
It also helps to understand SQL to avoid inefficient code like unnecessary loops.
1. select your users from RohanUser.TUser
2. Send to the user's item mall inventory - lets user apply the item to any of his chars.
3. to automate add a where clause to apply restrictions
It helps to understand the Rohan database and table relationships.
It also helps to understand SQL to avoid inefficient code like unnecessary loops.
I've tried it, but I did not succeed in making the script
WHERE name = 'character name' -- for adding items to a specific character
WHERE user_id = 456789 -- for adding items to all characters a specific user has
WHERE name = 'character name' -- for adding items to a specific character
WHERE user_id = 456789 -- for adding items to all characters a specific user has
WHERE name = 'character name' -- for adding items to a specific character
WHERE user_id = 456789 -- for adding items to all characters a specific user has
to the end of the query
Further reading
where i put that in sql? sorry im new in setting server
Quote:
Originally Posted by zzerachiel
Well, it's simple.
Add
Code:
WHERE name = 'character name' -- for adding items to a specific character
WHERE user_id = 456789 -- for adding items to all characters a specific user has
to the end of the query
Further reading
Quote:
Originally Posted by oziel235
is a SQL script to insert items in EventInventory.
where in sql i put that script sir? sorry im new in setting private server hope you help me ^_^
First off, if you do not know how to use MSSQL server, you really should not touch making a Rohan Server. Stored procedures are a central part of Rohan server operation.
Second...
OMFG STOP Necroing threads that have been dead for 4+ YEARS!!!
Some of the guys you are asking do not even show up in here anymore.
First off, if you do not know how to use MSSQL server, you really should not touch making a Rohan Server. Stored procedures are a central part of Rohan server operation.
Second...
OMFG STOP Necroing threads that have been dead for 4+ YEARS!!!
Some of the guys you are asking do not even show up in here anymore.
And stop with the fking SPAMMING already!
Read the **** forum rules ffs!
if you don't liek the forum get the **** out of here man they guy can post wherever he wants
WTF was that?? This stuff is for 8 years old kids.
That guy has been posting not only here, but in other forums trying to get people to teach him how to use MS SQL server. He does not realize a certain level of technical knowledge is needed before you can tackle running any kind of game server.
My advice for this poster is to gather as much information that has been posted, and teach himself how to understand what it is doing. These are things he has to do for himself. No one is going to give him a college level computer science course in a gaming discussion forum.
That guy has been posting not only here, but in other forums trying to get people to teach him how to use MS SQL server. He does not realize a certain level of technical knowledge is needed before you can tackle running any kind of game server.
My advice for this poster is to gather as much information that has been posted, and teach himself how to understand what it is doing. These are things he has to do for himself. No one is going to give him a college level computer science course in a gaming discussion forum.
i dont know about computers but i have my own local server now. some of my problems is fix by my own. i need a little tips. im a fast learner, i dont care about computer science, come visit my server i already set starting, instant lvl, send items to all players, all of that info i found on internet but im not in college level computer science. only i want is a tool that can help me
Wait a minnit. You don't know about computers, but you want to build a ******' Rohan game server? Are you kidding me??!!
There are no "edit your database for dummies" tools. The tool you need comes with Microsoft SQL Server. The Microsoft SQL Server Management Console. The knowledge you need is how to code sql queries and inserts in Microsoft TSQL stored procedures. I have already told you before that if you do not know how to use this stuff, to stay away from rohan servers. 75% of what you will do with that kind of server requires using Microsoft SQL Server and its tools.
The knowledge to do that modifying comes after a LOT more than a couple days/weeks of ******** around with a database. Only WHEN you understand how to code TSQL stored procedures to query, update, add and delete database records, then, and only then will you be able to do this kind of work yourself.
All of the better devs here have spent months and even years gaining that knowledge. Not a single one is going to be your teacher for free in some gaming forums.
I strongly suggest you go back and get this background knowledge so you know what questions to ask that would actually get productive answers. Until then this is about the most helpful answer you will be getting.
anyone please send me a link for xor rohan bot 10/26/2012 - Rohan - 6 Replies hi there i need a link for bot in xor rohan, please if anyone know about bots that properly works for windows xp kindly just post a link here or you can email me at [email protected]
thanks :)
Selling Xor Rohan accounts, characters, money and items 05/20/2012 - Rohan - 17 Replies Right now I have A LOT of Xor Rohan accounts.
So if you are interesting having a Pro account or simply buy crones or even items you can pm me.
If you have questions or want more details contact me.
how to send items that can not be transferred? 01/21/2012 - Shaiya - 3 Replies how to send items that can not be transferred.For example how to pass for level 50 pet to another account
