[Skyy]

no. points are not saved.

[WolfGang]

Will there be any changes to that, so that points are saved?

[kiwi87]

Originally Posted by WolfGang For any Users out there, having trouble installing this plugins and uses XAMPP (included myself), XAMPP community have made changes to their database. In order for your database to work, go into your sourcemod folder (sourcemod\scripting\rpg) and edit the file "database.sp" (same steps for manager\database.sp): Before PHP Code: TYPE=MyISAM  After PHP Code: ENIGNE=MyISAM  Your database now should working fine. -Credit goes to Maxunit

Yeah, I realised this too
Did just like the above and was able to load the plugin into my server. However, when i try to join my own server, it crashes. This is the log...

L 07/23/2012 - 05:40:17: [rpg3.44.smx] Duplicate column name 'id'
L 07/23/2012 - 05:40:17: [rpg3.44.smx] Duplicate column name 'enable'
L 07/23/2012 - 05:40:17: [rpg3.44.smx] Duplicate column name 'pi0'
L 07/23/2012 - 05:40:17: [rpg3.44.smx] Duplicate column name 'pi1'
L 07/23/2012 - 05:40:17: [rpg3.44.smx] Duplicate column name 'pi2'
L 07/23/2012 - 05:40:17: [rpg3.44.smx] Duplicate column name 'pi3'
L 07/23/2012 - 05:40:17: [rpg3.44.smx] Duplicate column name 'uz0'
L 07/23/2012 - 05:40:17: [rpg3.44.smx] Duplicate column name 'uz1'
L 07/23/2012 - 05:40:17: [rpg3.44.smx] Duplicate column name 'uz2'
L 07/23/2012 - 05:40:17: [rpg3.44.smx] Duplicate column name 'uz3'
L 07/23/2012 - 05:40:17: [rpg3.44.smx] Duplicate column name 'sh0'
L 07/23/2012 - 05:40:17: [rpg3.44.smx] Duplicate column name 'sh1'
L 07/23/2012 - 05:40:17: [rpg3.44.smx] Duplicate column name 'sh2'
L 07/23/2012 - 05:40:17: [rpg3.44.smx] Duplicate column name 'sh3'
L 07/23/2012 - 05:40:17: [rpg3.44.smx] Duplicate column name 'ri0'
L 07/23/2012 - 05:40:17: Error log file session closed.
L 07/23/2012 - 05:40:47: SourceMod error session started
L 07/23/2012 - 05:40:47: Info (map "c1m1_hotel") (file "errors_20120723.log")
L 07/23/2012 - 05:40:47: [rpg3.44.smx] Duplicate column name 'id'
L 07/23/2012 - 05:40:47: [rpg3.44.smx] Duplicate column name 'enable'
L 07/23/2012 - 05:40:47: [rpg3.44.smx] Duplicate column name 'pi0'
L 07/23/2012 - 05:40:47: [rpg3.44.smx] Duplicate column name 'pi1'
L 07/23/2012 - 05:40:47: [rpg3.44.smx] Duplicate column name 'pi2'
L 07/23/2012 - 05:40:47: [rpg3.44.smx] Duplicate column name 'pi3'
L 07/23/2012 - 05:40:47: [rpg3.44.smx] Duplicate column name 'uz0'
L 07/23/2012 - 05:40:47: [rpg3.44.smx] Duplicate column name 'uz1'
L 07/23/2012 - 05:40:47: [rpg3.44.smx] Duplicate column name 'uz2'
L 07/23/2012 - 05:40:48: [rpg3.44.smx] Duplicate column name 'uz3'
L 07/23/2012 - 05:40:48: [rpg3.44.smx] Duplicate column name 'sh0'
L 07/23/2012 - 05:40:48: [rpg3.44.smx] Duplicate column name 'sh1'
L 07/23/2012 - 05:40:48: [rpg3.44.smx] Duplicate column name 'sh2'
L 07/23/2012 - 05:40:48: [rpg3.44.smx] Duplicate column name 'sh3'
L 07/23/2012 - 05:40:48: [rpg3.44.smx] Duplicate column name 'ri0'
L 07/23/2012 - 05:40:48: Error log file session closed.
L 07/23/2012 - 05:40:49: SourceMod error session started
L 07/23/2012 - 05:40:49: Info (map "c1m1_hotel") (file "errors_20120723.log")
L 07/23/2012 - 05:40:49: [rpg3.44.smx] Duplicate column name 'ri1'
L 07/23/2012 - 05:40:49: [rpg3.44.smx] Duplicate column name 'ri2'
L 07/23/2012 - 05:40:49: [rpg3.44.smx] Duplicate column name 'ri3'
L 07/23/2012 - 05:40:49: [rpg3.44.smx] Duplicate column name 'sn0'
L 07/23/2012 - 05:40:49: [rpg3.44.smx] Duplicate column name 'sn1'
L 07/23/2012 - 05:40:49: [rpg3.44.smx] Duplicate column name 'sn2'
L 07/23/2012 - 05:40:49: [rpg3.44.smx] Duplicate column name 'sn3'
L 07/23/2012 - 05:40:49: [rpg3.44.smx] Duplicate column name 'id'
L 07/23/2012 - 05:40:49: [rpg3.44.smx] Duplicate column name 'cstm'
L 07/23/2012 - 05:40:49: [rpg3.44.smx] Duplicate column name 'id'
L 07/23/2012 - 05:40:49: [rpg3.44.smx] Duplicate column name 'ck'
L 07/23/2012 - 05:40:49: [rpg3.44.smx] Duplicate column name 'sik'
L 07/23/2012 - 05:40:49: [rpg3.44.smx] Duplicate column name 'sid'
L 07/23/2012 - 05:40:49: [rpg3.44.smx] Duplicate column name 'hpd'
L 07/23/2012 - 05:40:49: [rpg3.44.smx] Duplicate column name 'day'
L 07/23/2012 - 05:40:49: [rpg3.44.smx] Duplicate column name 'name'
L 07/23/2012 - 05:40:49: [rpg3.44.smx] Duplicate column name 'td'
L 07/23/2012 - 05:40:49: [rpg3.44.smx] Duplicate column name 'th'
L 07/23/2012 - 05:40:49: [rpg3.44.smx] Duplicate column name 'tm'
L 07/23/2012 - 05:40:49: [rpg3.44.smx] Duplicate column name 'ts'
L 07/23/2012 - 05:40:49: [rpg3.44.smx] Duplicate column name 'id'
L 07/23/2012 - 05:40:49: [rpg3.44.smx] Duplicate column name 'ih'
L 07/23/2012 - 05:40:49: [rpg3.44.smx] Duplicate column name 'im'
L 07/23/2012 - 05:40:49: [rpg3.44.smx] Duplicate column name 'is'
L 07/23/2012 - 05:40:49: [rpg3.44.smx] Duplicate column name 'sd'
L 07/23/2012 - 05:40:49: [rpg3.44.smx] Duplicate column name 'sh'
L 07/23/2012 - 05:40:49: [rpg3.44.smx] Duplicate column name 'sm'
L 07/23/2012 - 05:40:49: [rpg3.44.smx] Duplicate column name 'ss'
L 07/23/2012 - 05:40:50: [rpg3.44.smx] Duplicate column name 'infl'
L 07/23/2012 - 05:40:50: [rpg3.44.smx] Duplicate column name 'survl'
L 07/23/2012 - 05:40:50: [rpg3.44.smx] Duplicate column name 'bty'
L 07/23/2012 - 05:40:50: [rpg3.44.smx] Duplicate column name 'paranthesis'
L 07/23/2012 - 05:40:50: [rpg3.44.smx] Duplicate column name 'team'
L 07/23/2012 - 05:40:50: [rpg3.44.smx] Duplicate column name 'name'
L 07/23/2012 - 05:40:50: [rpg3.44.smx] Duplicate column name 'text'
L 07/23/2012 - 05:40:50: [rpg3.44.smx] Duplicate column name 'last_name_used'
L 07/23/2012 - 05:40:50: [rpg3.44.smx] Duplicate column name 'micro_menu'
L 07/23/2012 - 05:40:50: [rpg3.44.smx] Duplicate column name 'points_display'
L 07/23/2012 - 05:40:50: [rpg3.44.smx] Duplicate column name 'cmds'
L 07/23/2012 - 05:40:50: [rpg3.44.smx] Duplicate column name 'id'
L 07/23/2012 - 05:40:50: [rpg3.44.smx] Duplicate column name 'phx'
L 07/23/2012 - 05:40:50: [rpg3.44.smx] Duplicate column name 'phn'
L 07/23/2012 - 05:40:50: [rpg3.44.smx] Duplicate column name 'phl'
L 07/23/2012 - 05:40:50: [rpg3.44.smx] Duplicate column name 'pix'
L 07/23/2012 - 05:40:50: [rpg3.44.smx] Duplicate column name 'pin'
L 07/23/2012 - 05:40:50: [rpg3.44.smx] Duplicate column name 'pil'
L 07/23/2012 - 05:40:50: [rpg3.44.smx] Duplicate column name 'mex'
L 07/23/2012 - 05:40:50: [rpg3.44.smx] Duplicate column name 'men'
L 07/23/2012 - 05:40:50: [rpg3.44.smx] Duplicate column name 'mel'
L 07/23/2012 - 05:40:50: [rpg3.44.smx] Duplicate column name 'uzx'
L 07/23/2012 - 05:40:50: [rpg3.44.smx] Duplicate column name 'uzn'
L 07/23/2012 - 05:40:50: [rpg3.44.smx] Duplicate column name 'uzl'
L 07/23/2012 - 05:40:50: [rpg3.44.smx] Duplicate column name 'shx'
L 07/23/2012 - 05:40:50: [rpg3.44.smx] Duplicate column name 'shn'
L 07/23/2012 - 05:40:50: [rpg3.44.smx] Duplicate column name 'shl'
L 07/23/2012 - 05:40:50: [rpg3.44.smx] Duplicate column name 'snx'
L 07/23/2012 - 05:40:50: [rpg3.44.smx] Duplicate column name 'snn'
L 07/23/2012 - 05:40:50: [rpg3.44.smx] Duplicate column name 'snl'
L 07/23/2012 - 05:40:51: [rpg3.44.smx] Duplicate column name 'rix'
L 07/23/2012 - 05:40:51: [rpg3.44.smx] Duplicate column name 'rin'
L 07/23/2012 - 05:40:51: [rpg3.44.smx] Duplicate column name 'ril'
L 07/23/2012 - 05:40:51: [rpg3.44.smx] Duplicate column name 'grx'
L 07/23/2012 - 05:40:51: [rpg3.44.smx] Duplicate column name 'grn'
L 07/23/2012 - 05:40:51: [rpg3.44.smx] Duplicate column name 'grl'
L 07/23/2012 - 05:40:51: [rpg3.44.smx] Duplicate column name 'itx'
L 07/23/2012 - 05:40:51: [rpg3.44.smx] Duplicate column name 'itn'
L 07/23/2012 - 05:40:51: [rpg3.44.smx] Duplicate column name 'itl'
L 07/23/2012 - 05:40:51: [rpg3.44.smx] Duplicate column name 'id'
L 07/23/2012 - 05:40:51: [rpg3.44.smx] Duplicate column name 'inx'
L 07/23/2012 - 05:40:51: [rpg3.44.smx] Duplicate column name 'inn'
L 07/23/2012 - 05:40:51: [rpg3.44.smx] Duplicate column name 'inl'
L 07/23/2012 - 05:40:51: [rpg3.44.smx] Duplicate column name 'hux'
L 07/23/2012 - 05:40:51: [rpg3.44.smx] Duplicate column name 'hun'
L 07/23/2012 - 05:40:51: [rpg3.44.smx] Duplicate column name 'hul'
L 07/23/2012 - 05:40:51: [rpg3.44.smx] Duplicate column name 'huw'
L 07/23/2012 - 05:40:51: [rpg3.44.smx] Duplicate column name 'smx'
L 07/23/2012 - 05:40:51: [rpg3.44.smx] Duplicate column name 'smn'
L 07/23/2012 - 05:40:51: [rpg3.44.smx] Duplicate column name 'sml'
L 07/23/2012 - 05:40:51: [rpg3.44.smx] Duplicate column name 'smw'
L 07/23/2012 - 05:40:51: [rpg3.44.smx] Duplicate column name 'box'
L 07/23/2012 - 05:40:51: [rpg3.44.smx] Duplicate column name 'bon'
L 07/23/2012 - 05:40:51: [rpg3.44.smx] Duplicate column name 'bol'
L 07/23/2012 - 05:40:51: [rpg3.44.smx] Duplicate column name 'bow'
L 07/23/2012 - 05:40:51: [rpg3.44.smx] Duplicate column name 'jox'
L 07/23/2012 - 05:40:51: [rpg3.44.smx] Duplicate column name 'jon'
L 07/23/2012 - 05:40:51: [rpg3.44.smx] Duplicate column name 'jol'
L 07/23/2012 - 05:40:51: [rpg3.44.smx] Duplicate column name 'jow'
L 07/23/2012 - 05:40:52: [rpg3.44.smx] Duplicate column name 'chx'
L 07/23/2012 - 05:40:52: [rpg3.44.smx] Duplicate column name 'chn'
L 07/23/2012 - 05:40:52: [rpg3.44.smx] Duplicate column name 'chl'
L 07/23/2012 - 05:40:52: [rpg3.44.smx] Duplicate column name 'chw'
L 07/23/2012 - 05:40:52: [rpg3.44.smx] Duplicate column name 'spx'
L 07/23/2012 - 05:40:52: [rpg3.44.smx] Duplicate column name 'spn'
L 07/23/2012 - 05:40:52: [rpg3.44.smx] Duplicate column name 'spl'
L 07/23/2012 - 05:40:52: [rpg3.44.smx] Duplicate column name 'spw'
L 07/23/2012 - 05:40:52: [rpg3.44.smx] Duplicate column name 'tax'
L 07/23/2012 - 05:40:52: [rpg3.44.smx] Duplicate column name 'tan'
L 07/23/2012 - 05:40:52: [rpg3.44.smx] Duplicate column name 'tal'
L 07/23/2012 - 05:40:52: [rpg3.44.smx] Duplicate column name 'taw'
L 07/23/2012 - 05:40:52: [rpg3.44.smx] Duplicate column name 'xp_timer'
L 07/23/2012 - 05:40:52: [rpg3.44.smx] Duplicate column name 'nemesis_steamid'
L 07/23/2012 - 05:40:52: [rpg3.44.smx] Duplicate column name 'id'
L 07/23/2012 - 05:40:52: [rpg3.44.smx] Duplicate column name 'mw1'
L 07/23/2012 - 05:40:52: [rpg3.44.smx] Duplicate column name 'mw2'
L 07/23/2012 - 05:40:52: [rpg3.44.smx] Duplicate column name 'mw3'
L 07/23/2012 - 05:40:52: [rpg3.44.smx] Duplicate column name 'mw4'
L 07/23/2012 - 05:40:52: [rpg3.44.smx] Duplicate column name 'mw5'
L 07/23/2012 - 05:40:52: [rpg3.44.smx] Duplicate column name 'sw1'
L 07/23/2012 - 05:40:52: [rpg3.44.smx] Duplicate column name 'sw2'
L 07/23/2012 - 05:40:52: [rpg3.44.smx] Duplicate column name 'sw3'
L 07/23/2012 - 05:40:52: [rpg3.44.smx] Duplicate column name 'sw4'
L 07/23/2012 - 05:40:52: [rpg3.44.smx] Duplicate column name 'sw5'
L 07/23/2012 - 05:40:52: [rpg3.44.smx] Duplicate column name 'hi1'
L 07/23/2012 - 05:40:52: [rpg3.44.smx] Duplicate column name 'hi2'
L 07/23/2012 - 05:40:52: [rpg3.44.smx] Duplicate column name 'hi3'
L 07/23/2012 - 05:40:52: [rpg3.44.smx] Duplicate column name 'hi4'
L 07/23/2012 - 05:40:52: [rpg3.44.smx] Duplicate column name 'hi5'
L 07/23/2012 - 05:40:53: [rpg3.44.smx] Duplicate column name 'gi1'
L 07/23/2012 - 05:40:53: [rpg3.44.smx] Duplicate column name 'gi2'
L 07/23/2012 - 05:40:53: [rpg3.44.smx] Duplicate column name 'gi3'
L 07/23/2012 - 05:40:53: [rpg3.44.smx] Duplicate column name 'gi4'
L 07/23/2012 - 05:40:53: [rpg3.44.smx] Duplicate column name 'gi5'
L 07/23/2012 - 05:40:53: [rpg3.44.smx] Duplicate column name 'unlocked4'
L 07/23/2012 - 05:40:53: [rpg3.44.smx] Duplicate column name 'unlocked5'
L 07/23/2012 - 05:40:53: [rpg3.44.smx] Duplicate column name 'best_kills'
L 07/23/2012 - 05:40:53: [rpg3.44.smx] Duplicate column name 'player_name'
L 07/23/2012 - 05:40:53: [rpg3.44.smx] Duplicate column name 'best_headshots'
L 07/23/2012 - 05:40:53: [rpg3.44.smx] Duplicate column name 'best_headshots_name'
L 07/23/2012 - 05:40:53: [rpg3.44.smx] Duplicate column name 'best_survivor_dmg'
L 07/23/2012 - 05:40:53: [rpg3.44.smx] Duplicate column name 'best_survivor_dmg_name'
L 07/23/2012 - 05:40:53: [rpg3.44.smx] Duplicate column name 'best_infected_damage'
L 07/23/2012 - 05:40:53: [rpg3.44.smx] Duplicate column name 'infected_name'
L 07/23/2012 - 05:40:53: [rpg3.44.smx] Duplicate column name 'best_healing'
L 07/23/2012 - 05:40:53: [rpg3.44.smx] Duplicate column name 'healing_name'
L 07/23/2012 - 05:40:53: [rpg3.44.smx] Duplicate column name 'best_rescuer'
L 07/23/2012 - 05:40:53: [rpg3.44.smx] Duplicate column name 'rescuer_name'
L 07/23/2012 - 05:40:53: [rpg3.44.smx] Duplicate column name 'sky_points'
L 07/23/2012 - 05:40:53: [rpg3.44.smx] Duplicate column name 'purchased'

Help?

[Skyy]

@Wolfgang: No, I have no plans to add saving points. I've never played in a server where people actually wanted that feature, and the purpose of the rpg plugin is to focus its emphasis on the actual rpg elements, not the usepoints side of it.

@Kiwi: If the server is crashing, you need to take a look at your dumps. The spam in your log related to the database is in reference to it attempting to create columns that already exist, so it doesn't create them, and spits out a warning instead. this occurs every time the plugin is re-loaded. To remove this, I'd have to query the database checking if the columns existed, and if not, create them, and since it does not harm a server in any way, I haven't made that change.
Also, if you could refer to the other posts on the thread, as a few people have asked about this, and have received a response, it would be appreciated in the future.


If you're having server crashes, you should unload all plugins, and load them one by one to find the issue, and also make sure you've followed the installation instructions for each plugin to verify you have them installed properly. I have a video showing how to set this plugin up, as well as a demo server available on the OP.

[Maxunit]

Skyy, I "just" noticed, that there is code for the SG552, MP5 etc in it, means the CSS Weapons, which are usually only for german customers of L4D2 (or even for Australian too?).

So far I used WeaponUnlock and GunControll to have those guns on my L4D2 Server, but I noticed, that WeaponUnlock and GunControl cause issues. Are those guns properly unlocked with SkyRPG as well?

Greetings,

Maxunit

[Skyy]

I use both of those on my server, and have never had a problem with either of them. If you don't wish to use those weapons, you can always edit them out in the source that is provided.

[Maxunit]

I managed to fix the problems and WeaponUnlock and GunControl are working again.

[kiwi87]

Originally Posted by Skyy @Wolfgang: No, I have no plans to add saving points. I've never played in a server where people actually wanted that feature, and the purpose of the rpg plugin is to focus its emphasis on the actual rpg elements, not the usepoints side of it. @Kiwi: If the server is crashing, you need to take a look at your dumps. The spam in your log related to the database is in reference to it attempting to create columns that already exist, so it doesn't create them, and spits out a warning instead. this occurs every time the plugin is re-loaded. To remove this, I'd have to query the database checking if the columns existed, and if not, create them, and since it does not harm a server in any way, I haven't made that change. Also, if you could refer to the other posts on the thread, as a few people have asked about this, and have received a response, it would be appreciated in the future. If you're having server crashes, you should unload all plugins, and load them one by one to find the issue, and also make sure you've followed the installation instructions for each plugin to verify you have them installed properly. I have a video showing how to set this plugin up, as well as a demo server available on the OP.

Would be really thankful if you could add in the feature you mentioned regarding the duplicated columns My Server is still crashing due to this error according to the logs. I got no programming knowledge so its really a helpless situation here...
btw from your youtube video is too pixelated It seems you clicked on something like an SQL dump which loaded a table instead of the plugin creating one. Need a higher resolution video more details such as the mySQL version you using and what program you used to setup the databases...would help alot of beginners like me. Btw, I have successfully setup a few databases for plugins like custom player stats etc. Now i'm left with troubleshooting this one >.<
Manager plugin of yours is working fine...


SkyRPG tables but nothing seems to get in because of the duplicate column error

[Skyy]

The simple answer is...

It doesn't cause crashes, from the logs it generates.
Like I've posted 4 or 5 times already (it would be nice if you'd actually go and read the posts before posting a complaint, especially when answered, several times) it generates logs only when you first load the plugin. What the warnings are saying are "Hey, we attempted to create these columns, but they already existed, so we didn't create them, and we just thought we'd let you know."

It doesn't cause the server to crash.

Also, your levels aren't saving because it doesn't save a players data if their level isn't greater than 1. I implemented this in the code to prevent players who join and leave without playing from being saved into the database. You can always edit the code and remove that requirement, though.

Edit:
By the time anyone reads this part, rpg3.45 will be posted. See the changelog for details on what I've done. I do recommend ANYONE posting anything issue-related prior to 3.45 to update to 3.45 as I'm not going to troubleshoot 3.44--

Also, I didn't load an sql dump. I clicked the "refresh" button, after the server booted up, because it creates the tables on plugin load. The video only exists to show that the plugin does install correctly and function properly.

[Maxunit]

Thank you for the new version, Skyy

I updated it right away.

I have a small question tho, I think you can help me with that.

SkyRPG has Left4Loading as a dependency, no problem with that. It only annoys my players, that they always have to wait 30 - 60 seconds, before the safe room door opens and that they are frozen on the first map of a chapter.

I'm currently trying to remove at least the freezing, because if I reduce the readyup time from 30 - 60 seconds to less, SkyRPG acts...a bit weird. One of the "problems" I had after changing the values in survivorhandling.sp from Left4Loading, was, that SkyRPG always displayed the "You are dead. What now?" info screen whenever a new map was loaded, BUT! the Survivors also kept any Medical Items or Bombs after the mapchance, which they got from the SkyRPG Menu. Usually, those items get removed (for me).