[Drixevel]

Originally Posted by Arkarr A bit of mySQL for some who need it : Move ALL the players value (steamID, id, name, credits, etc...) into the Zephyrus database : SET @DATABASE_NAME_REDERWOLF = 'store'; -- DO NOT FORGET TO EDIT ! SET @DATABASE_NAME_ZEPHYRUS = 'store2'; -- DO NOT FORGET TO EDIT ! SET @q = CONCAT('INSERT INTO ', @DATABASE_NAME_ZEPHYRUS, '.store_players select * from ', @DATABASE_NAME_REDERWOLF, '.store_users'); select @q; PREPARE stmt FROM @q; EXECUTE stmt; DEALLOCATE PREPARE stmt; UPDATE the number of credits from each players in Zephyrus database to have the exacte same value as in the r3dw3r3w0lf's database : SET @DATABASE_NAME_REDERWOLF = 'store'; -- DO NOT FORGET TO EDIT ! SET @DATABASE_NAME_ZEPHYRUS = 'store2'; -- DO NOT FORGET TO EDIT ! DELIMITER $$ DROP FUNCTION IF EXISTS `toSteamID`$$ CREATE FUNCTION toSteamID(id TEXT) RETURNS TEXT LANGUAGE SQL BEGIN RETURN CONCAT("STEAM_0:",id%2,":",floor(id/2)); END; $$ DELIMITER ; SET @q = CONCAT('UPDATE ', @DATABASE_NAME_ZEPHYRUS, '.store_players, ', @DATABASE_NAME_REDERWOLF, '.store_users', ' SET ', @DATABASE_NAME_ZEPHYRUS, '.store_players.credits=', @DATABASE_NAME_REDERWOLF,'.store_users.credits', ' WHERE toSteamID(', @DATABASE_NAME_REDERWOLF, '.store_users.auth)', '=CONCAT("STEAM_0:",', @DATABASE_NAME_ZEPHYRUS, '.store_players.authid)'); select @q; PREPARE stmt FROM @q; EXECUTE stmt; DEALLOCATE PREPARE stmt;

I'd like to point out to people that this will only work with Store 1.2 and under. We're changing things around in the database structures with the rest of the API.

[Arkarr]

Originally Posted by r3dw3r3w0lf I'd like to point out to people that this will only work with Store 1.2 and under. We're changing things around in the database structures with the rest of the API.

Great ! Good news ! But, hum... Can I ask you a release date ? I think Arrow is finished now, isn't it ?

[Drixevel]

Originally Posted by Arkarr Great ! Good news ! But, hum... Can I ask you a release date ? I think Arrow is finished now, isn't it ?

Rather not hijack this thread, visit the store section for details. I'm just making that statement so people know those SQLs will need updates soon.

[Arkarr]

Originally Posted by r3dw3r3w0lf Rather not hijack this thread, visit the store section for details. I'm just making that statement so people know those SQLs will need updates soon.

Yeah, you right. Thanks.

[PGUkilljoy]

Everything works perfectly in CSGO tested and have on all servers.

One thing to request - maybe it is done already.

When one buys a weapon skin (custom) it replaces that skin on Every gun- Even ones you pick up.

Is there a way to make it work towards only the gun you want to have that skin on?

[bebe9b]

Pls add store:
"Custom model skin"
{
"model" "models/models/batman/batman.mdl" (exemple model skin)
"entity" "model_skin"
"price" "20"
"type" "CustomModel"
"slot" "4"
}

Thx,

[e54385991]

Originally Posted by bebe9b Pls add store: "Custom model skin" { "model" "models/models/batman/batman.mdl" (exemple model skin) "entity" "model_skin" "price" "20" "type" "CustomModel" "slot" "4" } Thx,

Type "CustomModel" only suitable for weapon models!

PHP Code:

        "Player skins" //
        {
                        "Terrorists" 
                {
                        "batman"
                        {
                                "model"             "models/player/batman/batman.mdl"
                                "arms"                ""
                                "team"                "2" // define team 2=T 3=CT
                                "type"                "playerskin" 
                                "price"                "1500"
                        }
                }
        } 


[bebe9b]

Works server zombie escape csgo ??

[fard]

Originally Posted by e54385991 PHP Code:              "spray name"                     {                     "material"        "materials/spray/figure1.vmt"                     "type"        "spray"                     "price"        "100"                 }  You can make other api plugin include <store> Store_SetClientCredits(client, Store_GetClientCredits(client)+10);

Do i need any special plugin for sprays?

[Addicted.]

Originally Posted by fard Do i need any special plugin for sprays?

It's included in the plugin