How to send items to all accounts.Rohan

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.

Quote:

Originally Posted by PenguinJoe 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

Well, it's simple.
Add
to the end of the query

Further reading

[Only registered and activated users can see links. Click Here To Register...]

[Only registered and activated users can see links. Click Here To Register...]

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 [Only registered and activated users can see links. Click Here To Register...] [Only registered and activated users can see links. Click Here To Register...]

I'll try it, I hope will be successful

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 [Only registered and activated users can see links. Click Here To Register...] [Only registered and activated users can see links. Click Here To Register...]

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 [Only registered and activated users can see links. Click Here To Register...] [Only registered and activated users can see links. Click Here To Register...]

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.

And stop with the fking SPAMMING already!

Read the damn forum rules ffs!

Quote:

Originally Posted by im batman 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 damn forum rules ffs!

if you don't liek the forum get the shit out of here man they guy can post wherever he wants

Who says I don't like the forums? The forums are fine. :p

Quote:

Originally Posted by AbsoSN if you don't liek the forum get the shit out of here man they guy can post wherever he wants

There are rules on this forum and they are often enforced without prejudice.

Quote:

Originally Posted by yurierodriguez where i put that in sql? sorry im new in setting server :( where in sql i put that script sir? sorry im new in setting private server hope you help me ^_^

:wutface::thinking::facepalm:

WTF was that?? This stuff is for 8 years old kids.

Quote:

Originally Posted by oziel235 :wutface::thinking::facepalm: WTF was that?? This stuff is for 8 years old kids. [Only registered and activated users can see links. Click Here To Register...]

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.

Quote:

Originally Posted by im batman 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 fukkin' 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 screwing 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.