drops_data.csv viewer

This is guide mostly for website tools and code, for example CMS or registration scripts.
There can also be tools.

Moderators: osRose dev team, ospRose dev team, osiRose dev team, Moderators

Re: drops_data.csv viewer

Postby rl2171 on Fri Oct 05, 2007 2:46 pm

Did you by chance post this one?

I am working on a tools section to place all tools into.

Thanks,

Rob

monkeyrose wrote:I was working on a CSV viewer that had a couple of hardcode SQL lookups (based on the name of the file) specifically for osRose. I imported a couple of files in mysql for lookup purposes. If your interested, I can clean it up and post it.

Image
rl2171
Admin
Admin
 
Posts: 1706
Joined: Mon Aug 06, 2007 5:17 pm
Location: Sacramento, CA USA - GMT-8

Re: drops_data.csv viewer

Postby xiaoOoaix on Sat Oct 06, 2007 5:12 am

is it possible to have monkeyrose's drop_data viewer ? so cool to have it~~
xiaoOoaix
Jelly Bean
Jelly Bean
 
Posts: 15
Joined: Fri Oct 05, 2007 5:38 pm

Re: drops_data.csv viewer

Postby monkeyrose on Sat Oct 06, 2007 10:10 am

Sent to Rob, Please let me know if you have any issues with it!

osRoseCSVReader

Your Download-Link:
http://www.megauploads.gr/download.php?id=1EA59A64



osRoseReloader - A tabbed server restarter. launcher.

Your Download-Link:
http://www.megauploads.gr/download.php?id=B8912515
monkeyrose
Smoulie
Smoulie
 
Posts: 58
Joined: Thu Aug 09, 2007 2:44 pm

Re: drops_data.csv viewer

Postby xiaoOoaix on Sat Oct 06, 2007 10:28 am

is there other uploader ?? can u use firefront D: megauploader dislike me T.T
xiaoOoaix
Jelly Bean
Jelly Bean
 
Posts: 15
Joined: Fri Oct 05, 2007 5:38 pm

Re: drops_data.csv viewer

Postby AmonRa on Sat Oct 06, 2007 1:10 pm

i thank your for you work

this is really very good
BabyBoy is back!!!!
User avatar
AmonRa
Smoulie
Smoulie
 
Posts: 64
Joined: Sun Sep 23, 2007 4:52 am

Re: drops_data.csv viewer

Postby lmame on Sat Oct 06, 2007 2:53 pm

Thanks :D
The world is full of love and peace ^_^
Image
User avatar
lmame
Admin
Admin
 
Posts: 8997
Joined: Mon Aug 06, 2007 4:42 pm
Location: July City

Re: drops_data.csv viewer

Postby fortunate on Sat Oct 06, 2007 8:26 pm

i get this error message everytime i click on something.

Image
fortunate
Jelly Bean
Jelly Bean
 
Posts: 11
Joined: Sat Oct 06, 2007 7:41 am

Re: drops_data.csv viewer

Postby lmame on Sat Oct 06, 2007 9:00 pm

I got this error too and it seems the display is not correct (I got a French XP Sp2):
al-0000.jpg





Here is the error (columnindex is not within valid range):
  1.  
  2. Consultez la fin de ce message pour plus de détails sur l'appel du débogage
  3. juste-à-temps (JIT) à la place de cette boîte de dialogue.
  4.  
  5. ************** Texte de l'exception **************
  6. System.ArgumentOutOfRangeException: L'argument spécifié n'était pas dans les limites de la plage des valeurs valides.
  7. Nom du paramètre : columnIndex
  8.    à System.Windows.Forms.DataGrid.get_Item(Int32 rowIndex, Int32 columnIndex)
  9.    à OSRose_CSV_Reader.frmMain.handleCellChange()
  10.    à OSRose_CSV_Reader.frmMain.dGridCSVdata_MouseUp(Object sender, MouseEventArgs e)
  11.    à System.Windows.Forms.Control.OnMouseUp(MouseEventArgs e)
  12.    à System.Windows.Forms.DataGrid.OnMouseUp(MouseEventArgs e)
  13.    à System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
  14.    à System.Windows.Forms.Control.WndProc(Message& m)
  15.    à System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
  16.    à System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
  17.    à System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
  18.  
  19.  
  20. ************** Assemblys chargés **************
  21. mscorlib
  22.     Version de l'assembly : 2.0.0.0
  23.     Version Win32 : 2.0.50727.832 (QFE.050727-8300)
  24.     CodeBase : file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
  25. ----------------------------------------
  26. osRoseCSVReader
  27.     Version de l'assembly : 1.0.2835.7082
  28.     Version Win32 : 1.0.2835.7082
  29.     CodeBase : file:///C:/Documents%20and%20Settings/Administrateur/Bureau/osRoseCSVReader.exe
  30. ----------------------------------------
  31. System.Windows.Forms
  32.     Version de l'assembly : 2.0.0.0
  33.     Version Win32 : 2.0.50727.832 (QFE.050727-8300)
  34.     CodeBase : file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
  35. ----------------------------------------
  36. System
  37.     Version de l'assembly : 2.0.0.0
  38.     Version Win32 : 2.0.50727.832 (QFE.050727-8300)
  39.     CodeBase : file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
  40. ----------------------------------------
  41. System.Drawing
  42.     Version de l'assembly : 2.0.0.0
  43.     Version Win32 : 2.0.50727.832 (QFE.050727-8300)
  44.     CodeBase : file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
  45. ----------------------------------------
  46. System.Data
  47.     Version de l'assembly : 2.0.0.0
  48.     Version Win32 : 2.0.50727.832 (QFE.050727-8300)
  49.     CodeBase : file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
  50. ----------------------------------------
  51. System.Xml
  52.     Version de l'assembly : 2.0.0.0
  53.     Version Win32 : 2.0.50727.832 (QFE.050727-8300)
  54.     CodeBase : file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
  55. ----------------------------------------
  56. System.Transactions
  57.     Version de l'assembly : 2.0.0.0
  58.     Version Win32 : 2.0.50727.832 (QFE.050727-8300)
  59.     CodeBase : file:///C:/WINDOWS/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
  60. ----------------------------------------
  61. System.EnterpriseServices
  62.     Version de l'assembly : 2.0.0.0
  63.     Version Win32 : 2.0.50727.832 (QFE.050727-8300)
  64.     CodeBase : file:///C:/WINDOWS/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
  65. ----------------------------------------
  66. System.Configuration
  67.     Version de l'assembly : 2.0.0.0
  68.     Version Win32 : 2.0.50727.832 (QFE.050727-8300)
  69.     CodeBase : file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
  70. ----------------------------------------
  71. mscorlib.resources
  72.     Version de l'assembly : 2.0.0.0
  73.     Version Win32 : 2.0.50727.832 (QFE.050727-8300)
  74.     CodeBase : file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
  75. ----------------------------------------
  76. System.Windows.Forms.resources
  77.     Version de l'assembly : 2.0.0.0
  78.     Version Win32 : 2.0.50727.42 (RTM.050727-4200)
  79.     CodeBase : file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms.resources/2.0.0.0_fr_b77a5c561934e089/System.Windows.Forms.resources.dll
  80. ----------------------------------------
  81.  
  82. ************** Débogage JIT **************
  83. Pour activer le débogage juste-à-temps (JIT), le fichier de configuration pour cette
  84. application ou cet ordinateur (machine.config) doit avoir la valeur
  85. jitDebugging définie dans la section system.windows.forms.
  86. L'application doit également être compilée avec le débogage
  87. activé.
  88.  
  89. Par exemple :
  90.  
  91. <configuration>
  92.     <system.windows.forms jitDebugging="true" />
  93. </configuration>
  94.  
  95. Lorsque le débogage juste-à-temps est activé, les exceptions non gérées
  96. seront envoyées au débogueur JIT inscrit sur l'ordinateur
  97. plutôt que d'être gérées par cette boîte de dialogue.
  98.  
  99.  
The world is full of love and peace ^_^
Image
User avatar
lmame
Admin
Admin
 
Posts: 8997
Joined: Mon Aug 06, 2007 4:42 pm
Location: July City

Re: drops_data.csv viewer

Postby monkeyrose on Sat Oct 06, 2007 10:19 pm

Sorry, I had to go out of town this morning. What file were you loading when the error occurred? It could be trying to reference a db called item_reference. Its a db of items id, types, names.


The osRsoeCSVReader is a Common Delimited Values File reader. It reads a CSV file and loads it into a spreadsheet like cell format for easier editing. You can alter and write the file back to a csv file or to a database file of the same name.

Also, if you have a db file called item_reference, it will look up the item name from the item id and type. (I used rl2171 rev 142 spreadsheet to get the item_reference list)
Line number On/Off | Expand/Contract | Select all

  1. CREATE TABLE `item_reference` (
  2.    `itemID` int(11) NOT NULL auto_increment,
  3.    `Type` int(11) NOT NULL,
  4.    `ID` int(11) NOT NULL,
  5.    `Name` tinytext NOT NULL,
  6.   `Comment` text,
  7. PRIMARY KEY  (`itemID`)
  8. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;




The button Even Stevens was a means for me to easily set all the probability values to the same. That way for any particular set of drops, it was an even chance for anything to drop. If I wanted a particular item to drop more, I would add it to the drop list more times, and keep the probabilities even.

The osRoseReloader is a Server starter and restarter. I know that there are alot of these, but this one is different in that I redirect the server's outputs to individual tabs. Also, it you rename your server's executables, you can change it in this app. This is useful if you have multiple versions of osRose. Put it in your binary directory with your server's exes.

If your consoles are not being updated realtime, make this change.

in Common/Log.cpp at the end, after:



add


monkeyrose
Smoulie
Smoulie
 
Posts: 58
Joined: Thu Aug 09, 2007 2:44 pm

Re: drops_data.csv viewer

Postby lmame on Sat Oct 06, 2007 10:27 pm

The drop_data.csv file. Sounds strange it sees only one column, perhaps because I have a french system?
The world is full of love and peace ^_^
Image
User avatar
lmame
Admin
Admin
 
Posts: 8997
Joined: Mon Aug 06, 2007 4:42 pm
Location: July City

PreviousNext

Return to PHP / Web Guides, Scripts and tools.

Who is online

Users browsing this forum: No registered users and 7 guests