a fix for nationalgunz vip wall

[mgdmgd]

Hey , when i do /vip_wall it say You ran our of VIP Walls
any fix for that?

[MentaL]

[flyffhelper]

search ng thread.

[sahar042]

Make sure you add the columns of VIP System on Account table

Account -> VIPWalls, LastVIPWall
Datatype -> int
Default Value or binding -> 0

And then queried:

spGetAccountInfo.sql
spUpdateAccountLastLogoutTime.sql

And the last one is to add the number of the walls that you want on Account->VIPWalls->Set the number you want.

[mgdmgd]

What to add to these
spGetAccountInfo.sql
spUpdateAccountLastLogoutTime.sql ?

- - - Updated - - -

i edited spGetAccountinfo
but what to do in this spUpdateAccountLastLogoutTime.sql ??

- - - Updated - - -

i added to line 17 at spGetAccountinfo VIPWalls, LastVIPWalls,

- - - Updated - - -

i fixed it but if i logout and login i can shout new wall :S

[mgdmgd]

Sahar help please :(

[sahar042]

Sahar help please :(

Post here the matchserver log while you are doing VIP wall in the gunz.

[mgdmgd]

u said to do something in this spUpdateAccountLastLogoutTime.sql
i did not know what to do in it , can u tell me?

[sahar042]

u said to do something in this spUpdateAccountLastLogoutTime.sql
i did not know what to do in it , can u tell me?

You have it on national gunz source folder->Tables.

[mgdmgd]

Thank you! fixed