|
You last visited: Today at 14:57
Advertisement
How to send items to all accounts.Rohan
Discussion on How to send items to all accounts.Rohan within the Rohan forum part of the MMORPGs category.
06/06/2014, 19:47
|
#16
|
elite*gold: 0 
Join Date: Jan 2014
Posts: 184
Received Thanks: 30
|
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.
|
|
|
|
06/07/2014, 06:55
|
#17
|
elite*gold: 0
Join Date: Mar 2013
Posts: 34
Received Thanks: 5
|
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
|
|
|
|
|
06/07/2014, 11:32
|
#18
|
elite*gold: 0
Join Date: Feb 2011
Posts: 333
Received Thanks: 111
|
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
|
|
|
|
|
06/07/2014, 13:23
|
#19
|
elite*gold: 0
Join Date: Mar 2013
Posts: 34
Received Thanks: 5
|
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
|
I'll try it, I hope will be successful
|
|
|
|
|
06/23/2018, 05:02
|
#20
|
elite*gold: 0
Join Date: Jun 2018
Posts: 20
Received Thanks: 0
|
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
|
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 ^_^
|
|
|
|
|
06/23/2018, 16:58
|
#21
|
elite*gold: 0
Join Date: Apr 2015
Posts: 1,212
Received Thanks: 721
|
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!
|
|
|
|
|
06/23/2018, 20:00
|
#22
|
elite*gold: 0
Join Date: Aug 2016
Posts: 187
Received Thanks: 58
|
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 **** forum rules ffs!
|
if you don't liek the forum get the **** out of here man they guy can post wherever he wants
|
|
|
|
|
06/23/2018, 20:37
|
#23
|
elite*gold: 0
Join Date: Apr 2015
Posts: 1,212
Received Thanks: 721
|
Who says I don't like the forums? The forums are fine. 
|
|
|
|
|
06/24/2018, 00:04
|
#24
|
elite*gold: 0
Join Date: Oct 2013
Posts: 1,166
Received Thanks: 855
|
Quote:
Originally Posted by AbsoSN
if you don't liek the forum get the **** out of here man they guy can post wherever he wants
|
There are rules on this forum and they are often enforced without prejudice.
|
|
|
|
|
06/24/2018, 03:38
|
#25
|
elite*gold: 0
Join Date: May 2009
Posts: 697
Received Thanks: 250
|
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 ^_^ |
  
WTF was that?? This stuff is for 8 years old kids.
|
|
|
|
|
06/24/2018, 16:26
|
#26
|
elite*gold: 0
Join Date: Apr 2015
Posts: 1,212
Received Thanks: 721
|
Quote:
Originally Posted by oziel235
|
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.
|
|
|
|
|
06/26/2018, 16:00
|
#27
|
elite*gold: 0
Join Date: Jun 2018
Posts: 20
Received Thanks: 0
|
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
|
|
|
|
|
06/26/2018, 18:49
|
#28
|
elite*gold: 0
Join Date: Apr 2015
Posts: 1,212
Received Thanks: 721
|
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.
|
|
|
|
All times are GMT +1. The time now is 14:58.
|
|
